break;
case 24:
$CurrAnnSpecLeavDeci = $res[wdays];
break;
default:
$CurrentAnnualLeaveDecision = 0;
$CurrAnnSpecLeavDeci = 0;
$CurrAnnSabbDeci = 0;
break;
}
}
}
/**
* Results of hours
*/
$hhmmu = new myClasses();
$HourResult = $plusHour - $PrivateOutput - $hourCompensate;
$HourResult = $hhmmu->sec2hms($HourResult);
/**
* Results of leave days
*/
/**
* AnnualLeave results
*/
$CurrLeavStat = $annLeavDeci - $leave - $dayCompensate;
$CheckYearLeaveStatus = $CurrentAnnualLeaveDecision - $CurrLeavStat;
if ($CheckYearLeaveStatus < 0) {
$LastYearLeaveStatus = $CheckYearLeaveStatus * -1;
$ThisYearLeaveStatus = $CurrentAnnualLeaveDecision;
} elseif ($CheckYearLeaveStatus >= 0) {
$ThisYearLeaveStatus = $CurrLeavStat;
}
if ($submit != 0) {
$sql = "SELECT timestamp FROM working_time \r\n where jobtype_id={$job_drop} \r\n and person_id = '{$name_drop}' \r\n and unix_timestamp(concat(valid_from, ' ', minStart)) >'{$start_time}' \r\n AND unix_timestamp(concat(valid_to, ' ', maxEnd))<'{$stop_time}'";
$result = $db->fetchOne($sql);
if (!$result) {
//preveri če že ima za ta dan defaukt službo in če je ji vzame dolžino službe in max dolžino službe iz default
$sql3 = "SELECT * \r\n FROM `working_time` \r\n WHERE( '{$date}' between `valid_from` and `valid_to`) and `person_id` ={$name_drop}\r\n and DayOfWeek=dayofweek('{$date}')\r\n ORDER BY id DESC \r\n LIMIT 0 , 1";
$result = $db->fetchAll($sql3);
if ($result) {
foreach ($result as $res) {
$weekday = $res["DayOfWeek"];
$maxJobTime = $res["maxJobTime"];
$workingTime = $res["workingTime"];
}
} else {
$myClasse = new myClasses();
$workingTime = $diffUnixTime;
$workingTime = $myClasse->sec2hms($workingTime, $padHours = true);
$maxJobTime = $workingTime;
$weekday = $DayOfWeek;
}
$now = date("Y-m-d H:i:s");
//dejansko vnesemo
$data = array('timestamp' => $now, 'person_id' => $name_drop, 'jobtype_id' => $job_drop, 'valid_from' => $fyear_drop . '-' . $fmonth_drop . '-' . $fday_drop, 'valid_to' => $syear_drop . '-' . $smonth_drop . '-' . $sday_drop, 'minStart' => $fhour_drop . ':' . $fmin_drop . ':00', 'maxEnd' => $shour_drop . ':' . $smin_drop . ':00', 'DayOfWeek' => $weekday, 'EvenOrOddWeek' => 'all', 'maxJobTime' => $maxJobTime, 'workingTime' => $workingTime, 'note' => $note . " " . "//dodal" . " " . $identity);
$db->insert('working_time', $data);
$lastInsertedId = $db->lastInsertId();
$messagetype = "success";
$message .= "Vloga številka {$lastInsertedId} je oddana";
$sql = "SELECT * FROM working_time\r\n WHERE id={$lastInsertedId}";
$result = $db->fetchAll($sql);
//var_dump($sql); die;
