} } if ($flyt_row) { for ($x = 1; $x <= count($flyt_row); $x++) { if ($flyt_row[$x] != $x && $flyt_row[$x] <= count($flyt_row)) { db_modify("update pos_buttons set row='0' where menu_id='{$menu_id}' and row='{$x}'", __FILE__ . " linje " . __LINE__); db_modify("update pos_buttons set row='{$x}' where menu_id='{$menu_id}' and row='{$flyt_row[$x]}'", __FILE__ . " linje " . __LINE__); db_modify("update pos_buttons set row='{$flyt_row[$x]}' where menu_id='{$menu_id}' and row='0'", __FILE__ . " linje " . __LINE__); } } } } $beskrivelse = db_escape_string($beskrivelse); if ($menutype) { $begin = tid($begin); $end = tid($end); if ($end == '00:00') { $end = '24:00'; } } if ($menuvalg == 'ny') { $x = 0; $m_id = NULL; $kodenr = array(); $q = db_select("select kodenr from grupper where art='POSBUT' order by kodenr", __FILE__ . " linje " . __LINE__); while ($r = db_fetch_array($q)) { $kodenr[$x] = $r['kodenr']; $x++; } for ($x = 0; $x < count($kodenr); $x++) { if (!$m_id && $x && !in_array($x, $kodenr)) {
<?php echo "<div id='topbar'>"; echo "Uge " . uge() . " - " . dag() . " " . dato() . " " . tid() . " - " . $username . " • "; echo "<a href='mailto:CKM@Bang-Olufsen.dk?subject=Feedback til Timer'><img src='images/feedback.png' /></a> • "; echo "<a href='overview.php'>Overblik</a> • "; echo "<a href='add.php'>Tilføj</a> • "; echo "<a href='settings.php'>Indstillinger</a> • "; echo "<a href='logout.php'>Log ud</a>"; echo "</div>";
} } } } mysql_query("INSERT INTO checks (`user`, `week`, `day`, `date`, `checkin`, `pause`) VALUES ('" . $username . "', '" . $week . "', '" . $day . "', DATE_FORMAT(NOW(),'%Y.%m.%d'), '" . $checkin . "', '" . $expPause . "')"); mysql_query("UPDATE users SET status=1 WHERE username='******'"); } } else { if ($_POST['checkstatus'] == "Check Ud") { if ($status == 0) { echo "<p class='error'>Du er allerede checket ud!</p><br />"; } else { $sql = mysql_query("SELECT checkin FROM checks WHERE user = '******' AND checkin != '00:00:00' AND checkout = '00:00:00' ORDER BY id desc"); $result = mysql_fetch_assoc($sql); $lastcheckin = $result['checkin']; $checkout = tid(); $worktime = worktime($lastcheckin, $checkout); // Pausen trækkes fra i oversigten. Ikke her. $status = 0; $checkedIn = false; mysql_query("UPDATE checks SET checkout='" . $checkout . "', worktime='" . $worktime . "' WHERE user='******' AND date = DATE_FORMAT(NOW(),'%Y.%m.%d') AND checkin='" . $lastcheckin . "'"); mysql_query("UPDATE users SET status=0 WHERE username='******'"); } } } } // Vis check knapper. if ($status == 1) { echo "<br /><form method='post' action='overview.php'><img src='images/checkOut.png'/><input type='submit' name='checkstatus' id='checkOutButton' value='Check Ud'></form><br />"; } else { if ($status == 0) {
$daysql = mysql_query("SELECT date,checkin,worktime,pause FROM checks WHERE user = '******' AND date = '" . $result['date'] . "' ORDER BY date desc"); while ($day = mysql_fetch_assoc($daysql)) { if ($result['date'] == date("Y-m-d") && $day['worktime'] == date('00:00:00') && $status == 1) { $worktimeThisCheck = hoursToSeconds(tid()) - hoursToSeconds($day['checkin']) - $day['pause'] * 60; } else { $worktimeThisCheck = hoursToSeconds($day['worktime']) - $day['pause'] * 60; } $worktimeThisDay += $worktimeThisCheck; } $balanceToday = $worktimeThisDay - 26640; $balance += $balanceToday; array_push($DatesCalculated, $result['date']); } else { if ($entriesThisDay == 1) { if ($result['date'] == date("Y-m-d") && $result['worktime'] == date('00:00:00') && $status == 1) { $worktimeThisDay = hoursToSeconds(tid()) - hoursToSeconds($result['checkin']) - $result['pause'] * 60; } else { $worktimeThisDay = hoursToSeconds($result['worktime']) - $result['pause'] * 60; } $balanceToday = $worktimeThisDay - 26640; $balance += $balanceToday; } } } // Formater balance if ($balance >= 26640) { $feriedage = mround($balance / 26640, 0); $balance -= $feriedage * 26640; } if ($balance < 0) { $image = "negative";