<div class="row" style="padding: 10px 30px;"> <div id="genCopy" class="col-md-4 btn btn-success" >Use Last Weeks</br> <?php rangeWeek(date("Y-m-d", time() - 604800)); ?> </div> <div id="genNew" class="col-md-4 btn btn-success">Create New Schedule For</br> <?php rangeWeek(date("Y-m-d", time())); ?> </div> <div class="col-md-4 row"> <div id="genToday" class="col-md-12 btn btn-success">Recalculate Today </br> <?php echo date("Y-m-d", time()); ?> </div> <div class="col-md-12 row"> <?php todaysDrivers(getTodaysDay(date('w'))); ?> </div> </div> </div> </div> </div> </div> <!--/tabWrapper --> </div> <!-- /.container-fluid -->
function populateRoutes() { $time_pre = microtime(true); include '../connection.php'; set_time_limit(120); $reportS = 0; $reportW = 0; $thisWeek = getWeek(); $query = "SELECT cID FROM clients WHERE cActive = 1"; $sql = $db->query($query); while ($info = $sql->fetch_array()) { $cID = $info['cID']; // Check if client is in for this week. if (!inForThisWeek($cID, $thisWeek, $db)) { // Today is for ($i = 1; $i <= 5; $i++) { $delDay = date('Y/m/d', time() + ($i - date('w')) * 24 * 3600); $rDay = getTodaysDay($i); //echo $delDay.' '.$info['cID'].' '.$rDay.' '.$thisWeek.'</br>'; $unixDate = unixTime($delDay); $query = "INSERT INTO routes (cID,rDate,unixDate,rDay,rWeek) \n\t\t\t\t\t\t\t\tVALUES ('{$cID}', '{$delDay}','{$unixDate}', '{$rDay}', '{$thisWeek}')"; //echo $query; $db->query($query); $reportS++; } } else { $reportW++; } } $time_post = microtime(true); $exec_time = $time_post - $time_pre; echo "{$reportS} Clients were populated -- {$reportW} Clients were already populated for this week</br>"; echo "Routes has been populated: " . format_period($exec_time) . "</br>"; }
$dx = 60 * 60 * 24 * -1; $dDay = getTodaysDay($d); } else { if ($day == 'tomorrow') { $d = date('w'); if ($d == 6) { $d = 0; $weekNumber = $weekNumber + 1; } else { if ($d == 0) { $weekNumber = $weekNumber + 1; } $d = $d + 1; } $dx = 60 * 60 * 24 * 1; $dDay = getTodaysDay($d); } } //echo "$weekNumber $dDay $dx</br>"; getDeliverys($weekNumber, $dDay, $dx); } if ($_POST['action'] == "genNew") { initRoutes(); } if ($_POST['action'] == "genToday") { $driverArray = $_POST['driverArray']; insertDriver(1, $driverArray); } if ($_POST['action'] == "genCopy") { copyLastWeek(); }