<?php
include_once 'inc.db.php';
include_once 'inc.functions.php';
for ($i = 0; $i < 100; $i++) {
//get all regions from DB
$sql = "SELECT * FROM vi_regions;";
$sth = $pdo->prepare($sql);
$sth->execute();
$regions = array();
foreach ($sth as $row) {
$regions[] = array('id' => $row['id'], 'travel-time' => $row['travel-time']);
}
$selected_region = $regions[array_rand($regions)];
//generate random date
$d_begin = new DateTime('2015-06-01');
$d_end = new DateTime();
$date_from = DateTime::createFromFormat('U', rand($d_begin->format('U'), $d_end->format('U')));
//calculate till date
$date_till = new DateTime($date_from->format('Y-m-d'));
$date_till->add(new DateInterval("P" . $selected_region['travel-time'] . "D"));
//get free couriers
$couriers = find_free_couriers($date_from->format('Y-m-d'), $date_till->format('Y-m-d'));
if (count($couriers) > 0) {
//random courier
$courier = $couriers[array_rand($couriers)]['id'];
//insert to DB
insert_to_schedule($couriers, $date_from->format('Y-m-d'), $courier, $selected_region['id']);
}
}
<?php
include_once 'inc.db.php';
include_once 'inc.functions.php';
//parse date
$date_tmp = array_reverse(explode('.', $_GET['datefrom']));
array_map('intval', $date_tmp);
$date_tmp[0] = $date_tmp[0] > 2000 ? $date_tmp[0] : $date_tmp[0] + 2000;
$date_from = new DateTime(implode('-', $date_tmp));
$id = @intval($_GET['region']);
//get travel time
$travel_time = get_travel_time($id);
if ($travel_time > 0) {
//calculate till date
$date_till = new DateTime($date_from->format('Y-m-d'));
$date_till->add(new DateInterval("P" . $travel_time . "D"));
//find free couriers
$couriers = find_free_couriers($date_from->format('Y-m-d'), $date_till->format('Y-m-d'));
//insert courier to schedule
if (count($couriers) > 0 && $_GET["action"] == 'add' && intval($_GET['courier'])) {
insert_to_schedule($couriers, $date_from->format('Y-m-d'), @intval($_GET['courier']), @intval($_GET['region']));
}
}
//output
if (isset($couriers)) {
$result = array('type' => 'success', 'names' => $couriers, 'time' => $travel_time, 'arrival' => $date_till->format('d.m.Y'));
} else {
$result = array('type' => 'error');
}
print json_encode($result);