6 units per 10 minutes <=> one hour) // Generate date array $dateArray = array(); for ($k = 0; $k < $numOfDays; $k++) : $dateArray[] = getDateTime("format", array(0,0,0,$selMonth,$selDay + $k,$selYear), "Y-m-d"); endfor; // 1 = Schnelsen // 2 = Moorfleet // 17093 = Altona // 3534 = Ludwigsburg // 3540 = Sindelfingen $csIdArray = array("1","2","17093","3534","3540"); $csIdArrayLen = count($csIdArray); // Iterate all customers for ($i = 0; $i < $csIdArrayLen; $i++) : $csId = $csIdArray[$i]; // Get array of day times of the current customer $dayTimes = getColVectorFromDB2ArrayByClause("metatype", "mt_sort", "mt_type = 'day_time' AND mt_objtype = 'cs' AND mt_objid = '" . $csId . "'", "", "mt_sort", ""); $dayTimeNames = getColVectorFromDB2ArrayByClause("metatype", "mt_value", "mt_type = 'day_time' AND mt_objtype = 'cs' AND mt_objid = '" . $csId . "'", "", "mt_sort", ""); $dayTimeMappedValues = getColVectorFromDB2ArrayByClause("metatype", "mt_mapped_value", "mt_type = 'day_time' AND mt_objtype = 'cs' AND mt_objid = '" . $csId . "'", "", "mt_sort", ""); $dayTimesLen = count($dayTimes); // Get the vehicles for the current customer $crvhList = array(); $sqlquery = getStmtCustomerVehicleRelation("", $csId); $result = $db->query($sqlquery); if (DB::isError($result)) die ("$PHP_SELF: " . $result->getMessage()); while ($row = $result->fetch_assoc()): $crvhList[] = $row["crvh_id"]; endwhile; $result->free(); $crvhListLen = count($crvhList); // Check for each vehicle displayed the existence of entries in "vehicledisposition", "vehicleavailability" and "vehicleavailabilitytimeunits". // If it does not exist then generate it to handle the drag and dropping the jobs etc. for ($v = 0; $v < $crvhListLen; $v++) : $crvhId = $crvhList[$v]; // Iterate the next x days for ($k = 0; $k < $numOfDays; $k++) : $retVal = updateVehicleAvailability ($crvhId, $csId, $dateArray[$k]); echo "CS = " . $csId . " | " . "CRVH = " . $crvhId . " | " . "DAY = " . $dateArray[$k] . " | " . " RET = [" . $retVal . "]"; echo "
"; ob_flush(); flush(); endfor; endfor; endfor; // Deactivate buffering and flush data ob_end_flush(); ?>