<?php include_once $_SERVER['DOCUMENT_ROOT'] . "/ABC/model/getDate.php"; include_once $_SERVER['DOCUMENT_ROOT'] . "/ABC/model/connectDatabase.php"; // ket noi csdl $db = new PDOData(); $d = new getDate(); // lay ve ngay $toda = $d->getNextDaysForPrint(0); $todayForDatabase = $d->getNextDaysForDatabase(0); // lay ve thu tu ngay trong tuan $spaceOfDays = $d->getDaysOfWeek(0); $data = $db->getData("SELECT tk.idTAIKHOAN, ten, maNhanVien, hoTen FROM taikhoan AS tk, thongtintaikhoan AS tttk WHERE tttk.idTAIKHOAN IN (SELECT DISTINCT idTAIKHOAN FROM dangkycuthe WHERE ngay= '{$todayForDatabase}') AND tk.idTAIKHOAN IN (SELECT DISTINCT idTAIKHOAN FROM dangkycuthe WHERE ngay= '{$todayForDatabase}') AND tk.idTAIKHOAN= tttk.idTAIKHOAN"); if (isset($_POST['submit'])) { foreach ($data as $spe) { // lay ra nhung thong bao co thay doi // ghep lai ten cua check box $idtk = $spe['idTAIKHOAN']; $aidtk = "a" . $idtk; if (isset($_POST[$idtk])) { $db->editData("UPDATE dangkycuthe SET denAnThucTe= 0 WHERE idTAIKHOAN= {$idtk}"); } } $noti = "Thêm thành công các tài khoản không đến ăn ngày {$toda}..."; echo "<script type='text/javascript'>alert('{$noti}'); window.location= 'index.php';</script>"; }
<?php include_once $_SERVER['DOCUMENT_ROOT'] . "/ABC/model/connectDatabase.php"; include_once $_SERVER['DOCUMENT_ROOT'] . "/ABC/model/getDate.php"; // nhan ve va thay doi format cua ngay mai $d = new getDate(); $db = new PDOData(); $days = array(); $oneDayLater = $d->getTomorrowForPrint(); $twoDaysLater = $d->getNextDaysForPrint(2); $threeDaysLater = $d->getNextDaysForPrint(3); $fourDaysLater = $d->getNextDaysForPrint(4); $fiveDaysLater = $d->getNextDaysForPrint(5); $sixDaysLater = $d->getNextDaysForPrint(6); $sevenDaysLater = $d->getNextDaysForPrint(7); $selected = 0; $data = ""; // su kien nut random if (isset($_POST["change"]) && isset($_POST["randomButton"])) { $countt = 0; $dbArr1 = array(); $tempArr = $db->getData("SELECT idMONAN FROM monan WHERE idLOAIMONAN= 1"); $lengthOfArr1 = count($tempArr); foreach ($tempArr as $s1) { $dbArr1[$countt] = $s1['idMONAN']; $countt++; } $countt = 0; $dbArr2 = array(); $tempArr = $db->getData("SELECT * FROM monan WHERE idLOAIMONAN= 2"); $lengthOfArr2 = count($tempArr);