| KURIERE OHNE AUFTRAG<\/td><\/tr>"));
endif;
$cur_vht_id_job = $db->getOne("SELECT vht_id FROM job WHERE jb_id = '" . $jb_id . "'");
// $cur_vht_id_value_job = $db->getOne("SELECT mt_value FROM metatype WHERE mt_sort = " . $cur_vht_id_job . " AND mt_type = 'vehicletype'");
$cur_vht_id_value_job = $vehicletypes[$cur_vht_id_job];
array_unshift($cr_id_order_list_temp, array("#", "Auftrag Nr. "
. "$jb_id"
. ", Start: " .
"$tr_comp" . (trim($tr_person) != "" ? ", $tr_person" : "") . ", $ad_street $tr_hsno, $ad_zipcode $ad_city; Fahrzeug: $cur_vht_id_value_job" .
""));
endif;
// Alle Kuriere finden, die KEINE newbies sind... (d.h. erster eledigter Job innerhalb von MASK_COURIER_NEWBIE_TIME Tagen in der Vergangenheit)
$newbie_date = getdate(mktime(0, 0, 0, date("m"), date("d") - MASK_COURIER_NEWBIE_TIME, date("Y")));
$newbie_date_sql = $newbie_date['year'] . "-" . sprintf("%02d", $newbie_date['mon']) . "-" . sprintf("%02d", $newbie_date['mday']) . " 23:59:59";
$newbie_cr_sids = array();
$sqlQuery = "SELECT cr_id, MIN(jb_ordertime) AS min_jb_ordertime FROM job WHERE jb_status = 2 AND cr_id IS NOT NULL AND cr_id != '' GROUP BY cr_id ORDER BY min_jb_ordertime ASC";
$res = $db->query($sqlQuery);
if (DB::isError($res)) reportDie ("$PHP_SELF: '$sqlQuery': " . $res->getMessage());
while ($row = $res->fetch_assoc()):
if ($row["min_jb_ordertime"] < $newbie_date_sql)
$newbie_cr_sids[$row["cr_id"]] = 1;
else
break;
endwhile;
$res->free();
// Alle laufenden Aufträge laden, damit nicht für jeden Kurier die DB einzeln abgefrägt werden muss
$job_ids_sql = "";
$current_jobs = array();
$sqlQuery = "SELECT jb_id, jb_ordertime, cr_sid FROM job WHERE jb_status = 0 OR jb_status = 1 ORDER BY cr_sid, jb_id ASC";
$res = $db->query($sqlQuery);
if (DB::isError($res)) reportDie ("$PHP_SELF: '$sqlQuery': " . $res->getMessage());
while ($row = $res->fetch_assoc()):
$current_jobs[$row["cr_sid"]][] = array($row["jb_id"], $row["jb_ordertime"]);
if ($job_ids_sql != "")
$job_ids_sql .= ",";
$job_ids_sql .= "'" . $row["jb_id"] . "'";
endwhile;
$res->free();
$current_tours = array();
if ($job_ids_sql != ""):
$sqlQuery = "SELECT tour.jb_id, tour.tr_sort, tour.tr_status, address.ad_zipcode FROM tour, address WHERE tour.jb_id IN ($job_ids_sql) AND tour.ad_id = address.ad_id ORDER BY tour.jb_id, tour.tr_sort ASC";
$res = $db->query($sqlQuery);
if (DB::isError($res)) reportDie ("$PHP_SELF: '$sqlQuery': " . $res->getMessage());
while ($row = $res->fetch_assoc()):
$current_tours[$row["jb_id"]][] = array($row["tr_sort"], $row["tr_status"], $row["ad_zipcode"]);
endwhile;
$res->free();
endif;
// Jeden Kurier einzeln verarzten
$i1 = 0;
$i2 = 1;
$cr_id_order_list2 .= "\"* |
KURIERE MIT AUFTRAG<\/td><\/tr>" . "\"";
for($i = 0; $i < count($cr_id_order_list_temp); $i++):
if ($cr_id_order_list_temp[$i][0] != "*" && $cr_id_order_list_temp[$i][0] != "#" && $cr_id_order_list_temp[$i][0] != "~"):
list($dummy_year, $dummy_month, $dummy_day, $hours, $minutes) =
getValsFromDate(trim($cr_id_order_list_temp[$i][5]));
// courierfilter
// $curFilter = substr(trim($cr_id_order_list_temp[$i][6]), 1, strlen(trim($cr_id_order_list_temp[$i][6])) - 2);
// if ($curFilter != "")
// $curFilter = " (" . $curFilter . ")";
// find jobs of occupied couriers
// if ($cr_id_order_list_temp[$i][7] == 1):
// $sqlQuery =
// "SELECT jb_id, jb_ordertime FROM job WHERE cr_sid = '" . $cr_id_order_list_temp[$i][1] . "' AND (jb_status = 0 OR jb_status = 1 AND (jb_globaljob IS NULL OR jb_globaljob = 0)) ORDER BY jb_id ASC";
// $sqlQuery =
// "SELECT jb_id, jb_ordertime FROM job WHERE cr_sid = '" . $cr_id_order_list_temp[$i][1] . "' AND (jb_status = 0 OR jb_status = 1) ORDER BY jb_id ASC";
// $res = $db->query($sqlQuery);
// if (DB::isError($res)) reportDie ("$PHP_SELF: '$sqlQuery'" . $res->getMessage());
$cr_id_order_list_temp[$i][7] = "";
$cr_is_occupied = false;
// while ($row = $res->fetch_assoc()):
if ($current_jobs[$cr_id_order_list_temp[$i][1]] != ""):
foreach($current_jobs[$cr_id_order_list_temp[$i][1]] as $current_job) {
$plz_str = "";
// $max_tr_sort = $db->getOne("SELECT max(tr_sort) FROM tour WHERE jb_id = '" . $row["jb_id"] . "'");
//echo "Honk: " . $row["jb_id"] . $max_tr_sort . "
\n";
// for ($j = 1; $j <= $max_tr_sort; $j++):
if ($current_tours[$current_job[0]] != ""):
foreach($current_tours[$current_job[0]] as $current_tour) {
// $ad_zipcode =
// $db->getOne("SELECT ad_zipcode FROM address WHERE ad_id = '" .
// $db->getOne("SELECT ad_id FROM tour WHERE tr_sort = '" . $j . "' AND jb_id = '" . $row["jb_id"] . "'")
// . "'");
// $tr_status =
// $db->getOne("SELECT tr_status FROM tour WHERE tr_sort = '" . $j . "' AND jb_id = '" . $row["jb_id"] . "'");
$cur_zipcode = ($current_tour[1] == "1" ? "" . $current_tour[2] . "" : $current_tour[2]);
$plz_str .= ($plz_str == "" ? $cur_zipcode : "->" . $cur_zipcode);
//echo "i:$i
\n";
//echo $plz_str;
}
endif;
// endfor;
// $start_plz =
// $db->getOne("SELECT ad_zipcode FROM address WHERE ad_id = '" .
// $db->getOne("SELECT ad_id FROM tour WHERE tr_sort = '1' AND jb_id = '" . $row["jb_id"] . "'")
// . "'");
// $ziel_plz = "";
// if ($db->getOne("SELECT max(tr_sort) FROM tour WHERE jb_id = '" . $row["jb_id"] . "'") > 1):
// $ziel_plz =
// $db->getOne("SELECT ad_zipcode FROM address WHERE ad_id = '" .
// $db->getOne("SELECT ad_id FROM tour WHERE tr_sort = '" .
// $db->getOne("SELECT max(tr_sort) FROM tour WHERE jb_id = '" . $row["jb_id"] . "'") .
// "' AND jb_id = '" . $row["jb_id"] . "'") . "'");
// endif;
if ($plz_str != "")
$plz_str = " (" . $plz_str . ")";
$curFilter = "";
$jb_ordertimeStr = "";
// $jb_ordertime_vals = getValsFromDate($row["jb_ordertime"]);
$jb_ordertime_vals = getValsFromDate($current_job[1]);
$today = getdate();
if ($today['mon'] != $jb_ordertime_vals[1] || $today['mday'] != $jb_ordertime_vals[2]):
// Kurier hat Auftrag für nachfolgenden Tag aufgenommen, d.h. er gilt nicht als besetzt
$jb_ordertimeStr = " (" . sprintf("%02d", $jb_ordertime_vals[2]) . "." . sprintf("%02d", $jb_ordertime_vals[1])
. "., " . sprintf("%02d", $jb_ordertime_vals[3]) . ":" . sprintf("%02d", $jb_ordertime_vals[4]) . ")";
else:
// Kurier hat Auftrag für heutigen Tag aufgenommen, gilt erstmal als besetzt
$row = array();
$row["jb_id"] = $current_job[0];
$row["jb_ordertime"] = $current_job[1];
$job_is_occupied = checkCrIsOccupied($row);
if (!$cr_is_occupied)
$cr_is_occupied = $job_is_occupied;
// prüfen, ob Auftragsdatum heute in der Zukunft liegt
if (($jb_ordertime_vals[3] > $today['hours']) || ($jb_ordertime_vals[3] == $today['hours'] && $jb_ordertime_vals[4] > $today['minutes'])):
// prüfen, ob Vorlaufzeit schon erreicht
if (!$job_is_occupied):
$jb_ordertimeStr = " (" . sprintf("%02d", $jb_ordertime_vals[3]) . ":" . sprintf("%02d", $jb_ordertime_vals[4]) . ")";
endif;
endif;
endif;
if ($cr_id_order_list_temp[$i][7] == ""):
$cr_id_order_list_temp[$i][7] = "<\/a>, aktueller Auftrag: ";
else:
$cr_id_order_list_temp[$i][7] .= ", ";
endif;
$cr_id_order_list_temp[$i][7] .=
"" . $current_job[0] . $plz_str . $jb_ordertimeStr . "";
}
endif;
// endwhile;
// $res->free();
// else:
// $cr_id_order_list_temp[$i][7] = "";
// endif;
$plzString = trim($cr_id_order_list_temp[$i][4]);
if ($plzString == "")
$plzString = "00000";
// if ($hq_id == 3)
// $plzString .= " " . getAreaName($cr_id_order_list_temp[$i][4], 1);
if ($cr_is_occupied)
$plzString = "" . $plzString . "";
$leadingStr = "";
$leadingStr = " " . $plzString . ", " . $hours . ":" . $minutes . " - ";
if (trim($hours) == "")
$hours = "00";
if (trim($minutes) == "")
$minutes = "00";
// Auftragserfassung: Zusätzlich Datum anzeigen, wenn nicht heute
if (!(isset($jb_id) && $jb_id != "" && isset($zipcode) && $zipcode != "")):
$leadingStr = " " . $plzString . ", " . $hours . ":" . $minutes . " (" . sprintf("%02d", $dummy_day) . "." . sprintf("%02d", $dummy_month) . ".)" . " - ";
if ($today['mday'] == $dummy_day && $today['mon'] == $dummy_month && $today['year'] == $dummy_year)
$leadingStr = " " . $plzString . ", " . $hours . ":" . $minutes . " (" . sprintf("%02d", $dummy_day) . "." . sprintf("%02d", $dummy_month) . ".)" . " - ";
endif;
$tmp_cr_sid = trim($cr_id_order_list_temp[$i][1]);
if ($newbie_cr_sids[trim($cr_id_order_list_temp[$i][0])] != 1):
$tmp_cr_sid = "" . $tmp_cr_sid . "<\/span>";
endif;
$tmpCourierStr =
"\"" . $leadingStr .
"" . $tmp_cr_sid . ", " . trim($cr_id_order_list_temp[$i][3]) .
"" . $curFilter . "" . $cr_id_order_list_temp[$i][7] . "\"";
// Wenn MASK_COURIER_SORT_BY_OCCUPIED gesetzt, dann müssen die Kuriere nach occupied-status sortiert werden
if (MASK_COURIER_SORT_BY_OCCUPIED == "1"):
if ($cr_is_occupied != true || !(isset($jb_id) && $jb_id != "" && isset($zipcode) && $zipcode != "")):
if ($i1++ > 0) $cr_id_order_list .= ",\n";
$cr_id_order_list .= /* "cr_id_order_list[" . $i1++ . "] = " . */ $tmpCourierStr;
else:
if ($i2++ > 0) $cr_id_order_list2 .= ",\n";
$cr_id_order_list2 .= /* "cr_id_order_list2[" . $i2++ . "] = " . */ $tmpCourierStr;
endif;
else:
if ($i1++ > 0) $cr_id_order_list .= ",\n";
$cr_id_order_list .= /* "cr_id_order_list[" . $i1++ . "] = " . */ $tmpCourierStr;
endif;
// Abgleich der Fahrzeugtypen Kurier/Auftrag
$vht_id_str = "";
// $cur_vht_id_job = $db->getOne("SELECT vht_id FROM job WHERE jb_id = '" . $jb_id . "'");
// $cur_vht_id_value_job = $db->getOne("SELECT mt_value FROM metatype WHERE mt_sort = " . $cur_vht_id_job . " AND mt_type = 'vehicletype'");
// $cur_vht_id_courier = $db->getOne("SELECT mt_sort FROM metatype WHERE mt_value = '" . $cr_id_order_list_temp[$i][3] . "' AND mt_type = 'vehicletype'");
$cur_vht_id_courier = $vehicletype_ids[$cr_id_order_list_temp[$i][3]];
if ($cur_vht_id_job > $cur_vht_id_courier)
$vht_id_str = "\\n\\nACHTUNG: Fahrzeug passt nicht! (Angefordert: " . $cur_vht_id_value_job . ", zuweisen: " . $cr_id_order_list_temp[$i][3] . ")";
if ($cur_vht_id_job < $cur_vht_id_courier)
$vht_id_str = "\\n\\n(Fahrzeug angefordert: " . $cur_vht_id_value_job . ", zuweisen: " . $cr_id_order_list_temp[$i][3] . ")";
if ($vht_id_str != "")
// $vht_id_str_js .= "vht_id_str[] = " . "new Array(\"" . $cr_id_order_list_temp[$i][1] . "\", \"" . $vht_id_str . "\");\n";
// else
// $vht_id_str_js .= "vht_id_str[] = " . "new Array(\"" . $cr_id_order_list_temp[$i][1] . "\", \"\");\n";
$vht_id_str_js .= "vht_id_str[\"" . $cr_id_order_list_temp[$i][1] . "\"] = \"" . $vht_id_str . "\";\n";
else
$vht_id_str_js .= "vht_id_str[\"" . $cr_id_order_list_temp[$i][1] . "\"] = \"\";\n";
else:
if ($i1++ > 0) $cr_id_order_list .= ",\n";
$cr_id_order_list .= "\"" . trim($cr_id_order_list_temp[$i][0]) . trim($cr_id_order_list_temp[$i][1]) . "\"";
if (MASK_COURIER_SORT_BY_OCCUPIED == "1" && $cr_id_order_list_temp[$i][0] != "#" && trim($cr_id_order_list_temp[$i][1]) != "| KURIERE OHNE AUFTRAG<\/td><\/tr>"):
if ($i2++ > 0) $cr_id_order_list2 .= ",\n";
$cr_id_order_list2 .= "\"" . trim($cr_id_order_list_temp[$i][0]) . trim($cr_id_order_list_temp[$i][1]) . "\"";
endif;
endif;
endfor;
if ($hq_workmode != "2" || $hq_id == 1):
// $hq_distancecalc = getFieldValueFromId("headquarters", "hq_id", "$hq_id", "hq_distancecalc");
// if ($hq_workmode == "1" && $hq_distancecalc == "1"):
// $res = $db->query("SELECT cr.cr_sid, cr.cr_locationzipcode, cr.cr_availabletime, srvp.srvp_latitude, srvp.srvp_longitude, cr.cr_occupied, mt.mt_value" .
// " FROM courier AS cr, serviceplz AS srvp, couriervehicle AS crvh, metatype AS mt" .
// " WHERE cr.hq_id = '$hq_id' AND" .
// " cr.cr_locationzipcode = srvp.srvp_plz AND" .
// " cr.cr_available = 1 AND" .
// " cr.cr_id = crvh.cr_id AND" .
// " cr.cr_sid = crvh.crvh_sid AND" .
// " crvh.vht_id = mt.mt_sort AND" .
// " mt.mt_type = 'vehicletype' " .
// " ORDER BY cr.cr_locationzipcode ASC, cr.cr_availabletime ASC");
// elseif ($hq_workmode == "1" || $hq_workmode == "0" || $hq_id == 1):
// $res = $db->query("SELECT cr.cr_sid, cr.cr_locationzipcode, cr.cr_availabletime, cr.cr_occupied, mt.mt_value" .
// " FROM courier AS cr, couriervehicle AS crvh, metatype AS mt" .
// " WHERE cr.hq_id = '$hq_id' AND" .
// " cr.cr_available = 1 AND" .
// " cr.cr_id = crvh.cr_id AND" .
// " cr.cr_sid = crvh.crvh_sid AND" .
// " crvh.vht_id = mt.mt_sort AND" .
// " mt.mt_type = 'vehicletype' " .
// " ORDER BY cr.cr_locationzipcode ASC, cr.cr_availabletime ASC");
// endif;
// if (DB::isError($res))
// reportDie ("$PHP_SELF: 'SELECT cr_sid ...' :" . $res->getMessage());
// $plz_geo_list = array();
// $i = 0;
// while ($row = $res->fetch_assoc()):
// // Kuriere einsammeln
// if ($hq_workmode == "1" || $hq_id == 1):
// list($dummy_year, $dummy_month, $dummy_day, $hours, $minutes) =
// getValsFromDate($row["cr_availabletime"]);
// $cr_occupied_sign = ($row["cr_occupied"] > 0) ? "*" : "";
// $cr_id_order_list .= "cr_id_order_list[" . $i++ . "] = \"" . trim($row["cr_sid"]) . " - " . trim($row["mt_value"]) .
// $cr_occupied_sign . " (" . trim($row["cr_locationzipcode"]) . ", " . $hours . ":" . $minutes . ")\";\n";
// // Liste der Koordinaten (nur wenn hq_distancecalc = 1)
// if ($hq_distancecalc == "1"):
// $plz_geo_list[$row["cr_locationzipcode"]] = array($row["srvp_latitude"] , $row["srvp_longitude"]);
// // save courier-zipcodes for search of surrounding zipcodes below
// // we want to avoid duplicate querys for duplicate courier-zipcodes
// endif;
// else:
// $cr_id_order_list .= "cr_id_order_list[" . $i++ . "] = \"" . trim($row["cr_sid"]) . "\";\n";
// endif;
// endwhile;
// $res->free();
// /** Searches for valid PLZs, that are in a specified radius around the PLZ of each courier.
// Nur wenn hq_workmode = 1 und hq_distancecalc = 1
// */
// if ($hq_workmode == "1" && $hq_distancecalc == "1"):
// $plz_key_list = array_keys($plz_geo_list);
// foreach($plz_key_list as $zipcode)
// {
// $query = "SELECT srvp_plz, srvp_latitude, srvp_longitude" .
// " FROM serviceplz WHERE srvp_valid = 1 AND " .
// "(ACOS((SIN(" . deg2rad($plz_geo_list[$zipcode][0]) . ")*SIN(RADIANS(srvp_latitude))) + " .
// "(COS(" . deg2rad($plz_geo_list[$zipcode][0]) . ")*COS(RADIANS(srvp_latitude))*COS(RADIANS(srvp_longitude)-" .
// deg2rad($plz_geo_list[$zipcode][1]) . "))) * " . GEO_EARTH_RADIUS . ") < " . MAXIMUM_SEARCH_RADIUS;
// $res_geo = $db->query($query);
// if (DB::isError($res_geo))
// reportDie ("$PHP_SELF: '$query': " . $res_geo->getMessage());
// while ($row = $res_geo->fetch_assoc()):
// $plz_geo_list[$row["srvp_plz"]] = array($row["srvp_latitude"] , $row["srvp_longitude"]);
// endwhile;
// $res_geo->free();
// }
// endif;
endif;
$cr_id_order_list .= "];\n";
$cr_id_order_list2 .= "];\n";
if (isset($jb_id) && $jb_id != "" && isset($zipcode) && $zipcode != ""):
writeLog_("../log/job_courier_cur_", trace_execution_time_stop() . " job_courier.inc.php executed: \$jb_id = $jb_id, couriers: " . count($cr_id_order_list_temp) . ", vehicletype: $cur_vht_id_value_job" . ", \$usr_id = $usr_id");
else:
writeLog_("../log/job_courier_", trace_execution_time_stop() . " job_courier.inc.php executed: \$jb_id = $jb_id, couriers: " . count($cr_id_order_list_temp) . ", vehicletype: $cur_vht_id_value_job" . ", \$usr_id = $usr_id");
endif;
//// Gesperrte / gewünschte Kuriere der Kunden
//$res = $db->query("SELECT cs_id, cr_id, cscr_relation FROM customercourier ORDER BY cr_id");
//if (DB::isError($res))
// reportDie ("$PHP_SELF: 'SELECT cs_id, cr_id, cscr_relation FROM customercourier ORDER BY cr_id': " . $res->getMessage());
//$customercourier_list = "var customercourier_list = new Array();\n";
//$i = 0;
//while ($row = $res->fetch_assoc()):
// $customercourier_list .= "customercourier_list[" . $i++ . "] = " .
// "new Array(" . $row["cs_id"] . ", " . $row["cr_id"] . ", " . $row["cscr_relation"] . ");\n";
//endwhile;
//$res->free();
?>
| |