給与・勤務時間 集計画面
");
print("
");
print("| 勤務日付 | ");
print("通常勤務代 | ");
print("残 業 代 | ");
print("深夜勤務代 | ");
print("日 計 | ");
print(" | ");
print("
");
$total = 0;
$zikan_array[0]=0;
$zikan_array[1]=0;
$zikan_array[2]=0;
$kyuyo_array[0]=0;
$kyuyo_array[1]=0;
$kyuyo_array[2]=0;
//該当する年月の勤務データをkinmuから取得
$sql = "select * from kinmu where '$user' = k_username and k_nen = $year and k_tuki = $month order by k_hi";
$result = sqlite_query($con,$sql);
$row = sqlite_num_rows($result);
for($i = 0;$i < $row;$i++){
print("
\n");
$array = sqlite_fetch_array($result);
$sql = "select * from kinmu_meisai where k_id = $array[0]";
$result2 = sqlite_query($con,$sql);
$row2 = sqlite_num_rows($result2);
//時間計算
$start_time[1] = $start_time[2] = 0;
$end_time[1] = $end_time[2] = 0;
for($j = 0;$j < $row2;$j++){
$array2 = sqlite_fetch_array($result2);
$start_time[$j] = $array2[2] * 60 + $array2[3];
$end_time[$j] = $array2[4] * 60 + $array2[5];
}
$tuzyo = 0;
for($j = 0;$j < 3;$j++){
$tuzyo = $tuzyo + $end_time[$j] - $start_time[$j];
}
if($tuzyo > 480){
$zangyo = $tuzyo - 480;
}else{
$zangyo = 0;
}
$sinya = 0;
for($j = 0;$j < 3;$j++){
if($end_time[$j] > 1320){
if($start_time[$j] > 1320){
$sinya = $sinya + $end_time[$j] - $start_time[$j];
}else{
$sinya = $sinya + $end_time[$j] - 1320;
}
}
}
//給料計算
$tuzyo_kyuyo = (int)($tuzyo * $array[4] / 60);
$zangyo_kyuyo = (int)($zangyo * $array[4] * 0.25 / 60);
$sinya_kyuyo = (int)($sinya * $array[4] * 0.25 / 60);
//出力部分
$color = "black";
$hizuke_value = $array[1] * 10000 + $array[2] * 100 + $array[3];
$today_hizuke_value = $t_year * 10000 + $t_month * 100 + $t_day;
if($today_hizuke_value > $hizuke_value){
$color = "green";
}else{
if($today_hizuke_value == $hizuke_value){
for($j = 0;$j < 3;$j++){
if($end_time[$j] != 0){
$end_t = $end_time[$j];
}else{
$j = 3;
}
}
$pre_zikoku = $t_hour * 60 + $t_minute;
if($end_t <= $pre_zikoku){
$color = "green";
}
}
}
$hizuke = $array[1]."/".$array[2]."/".$array[3];
print("| $hizuke\n | ");
print("$tuzyo_kyuyo | \n");
print("$zangyo_kyuyo | \n");
print("$sinya_kyuyo | \n");
$sum = $tuzyo_kyuyo + $zangyo_kyuyo + $sinya_kyuyo;
print("$sum | \n");
print("明細 | \n");
$kyuyo_array[0] = $kyuyo_array[0] + $tuzyo_kyuyo;
$kyuyo_array[1] = $kyuyo_array[1] + $zangyo_kyuyo;
$kyuyo_array[2] = $kyuyo_array[2] + $sinya_kyuyo;
$total = $total + $sum;
print("
\n");
}
$color = "black";
$hizuke_value = $array[1] * 10000 + $array[2] * 100;
$today_hizuke_value = $t_year * 10000 + $t_month * 100;
if($today_hizuke_value > $hizuke_value){
$color = "green";
}else{
}
//合計額表示部分
print("
\n");
print("| 合 計 | \n");
print("$kyuyo_array[0] | \n");
print("$kyuyo_array[1] | \n");
print("$kyuyo_array[2] | \n");
print("$total | \n");
print("
\n");
//実際振込額および予定との差額表示部分
if($total > 0){
$sql = "select sum(kh_kingaku) from kyuyo_zissai where '$user' = kh_username and kh_year = $array[1] and kh_month = $array[2]";
$result = sqlite_query($sql,$con);
$kyuyo_zissai = sqlite_fetch_array($result);
if($kyuyo_zissai[0] > 0){
print("
\n");
print("| 実際振込額 | \n");
print("$kyuyo_zissai[0] | \n");
print("
\n");
print("
\n");
$sagaku = $kyuyo_zissai[0] - $total;
if($sagaku < 0){
$color = "blue";
$display_sagaku = $sagaku;
}else{
$color = "red";
$display_sagaku = "+".$sagaku;
}
print("| 差額 | \n");
print("$display_sagaku | \n");
print("
\n");
}
}
?>
勤務管理メイン画面へ戻る