$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; $LastYearLeaveStatus = 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; if (!$result) { $messagetype = "error";