Exemple #1
0
                        <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 -->
Exemple #2
0
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();
}