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 {