function editJob($jobNo, $jobDate, $distNo)
{
//RAYMOND: if all variable == null, will occur error
$result = getOrdersByJobNo($jobNo);
if ($result) {
return false;
}
//JSON Array?
if (isset($jobNo) && is_array($jobNo)) {
$jobObj = $jobNo;
$jobDate = $jobObj[jobDate];
$distNo = $jobObj[distNo];
}
//Getting value
if (isset($jobDate)) {
$values[] = jobDate . " = '{$jobDate}'";
}
if (isset($distNo)) {
$values[] = distNo . " = '{$distNo}'";
}
if (count($values) < 0) {
return false;
}
$query = "UPDATE Schedule SET ";
foreach ($values as $value) {
$query .= $value . ",";
}
$query = rtrim($query, ",") . " ";
$query .= "WHERE " . jobNo . " = '{$jobNo}'";
return DB::query($query);
}
return;
}
$currentDay = date("Y-m-d");
if (isset($_POST[jobNo])) {
if (isset($_POST[jobDate])) {
if (editJob($_POST[jobNo], $_POST[jobDate], null)) {
echo "true";
} else {
echo "false";
}
return;
} else {
if (isset($_POST["getDetail"])) {
$retTable = '<table name="OrderTable" class="tableSimpleList" width="100%">
<caption>' . $_POST[jobNo] . ' Details </caption><thead><tr><th>OrderNo</th><th>Address</th></tr></thead>';
$result = getOrdersByJobNo($_POST[jobNo]);
if (!isset($result)) {
echo "No Order assigned";
return;
}
while ($row = $result->fetch_array()) {
$retTable .= "<tr><td align='center'>" . $row[ordNo] . "</td><td align='center'>" . $row[deliAddr] . "</td></tr>";
}
$retTable .= '</table>';
echo $retTable;
return;
} else {
if (isset($_POST[distNo])) {
if (editJob($_POST[jobNo], null, $_POST[distNo])) {
echo "true";
} else {
