$data["AuthorID"] = $userid;
$data["DateNeedBy"] = $dtt;
$data["DateCreated"] = date('Y-m-d');
$data["Assigned"] = false;
$data["Approved"] = false;
$data["ApprovedByCap"] = false;
$data["Finished"] = false;
$data["Closed"] = false;
$data["Active"] = true;
$r = CreateNewWorkOrder($data);
if ($r[1] !== true) {
$error_msg = $r[1];
$doform = true;
goto GenerateHtml;
}
$wid = $r[0];
PopulateParamList($param_list, $data);
$success_msg = "New work order " . WIDStrHtml($wid, 0, false) . " created!";
$link_to_view = "wo_display.php?wid=" . $wid;
$doform = false;
}
GenerateHtml:
$picid = GetPicIDForUserID($userid);
if ($picid > 0) {
$picurl = PicUrl($picid, "thumb");
}
$stylesheet = array("../css/global.css", "../css/nav.css", "../css/wo_new.css");
include "forms/header.php";
include "forms/nav_form.php";
include "forms/wo_new_form.php";
include "forms/footer.php";
//print $sql; /*used for testing*/
$filterresult = SqlQuery($loc, $sql);
$pagetitle = "";
$pagetext = "";
if ($sql != "") {
if ($view == "full") {
$tableheader = array("WO", "Title", "Receiving IPT", "DateNeeded", "CAP", "AP", "AS", "F ", "C");
} else {
$tableheader = array("WO", "Title", "Receiving IPT", "DateNeeded");
}
$tabledata = array();
while ($row = $filterresult->fetch_assoc()) {
$wid = $row["WID"];
$rev = $row["Revision"];
$app = $row["Approved"] || $row["ApprovedByCap"];
$woname = WIDStrHtml($wid, $rev, $app);
unset($dd);
$dd = array();
$dd[] = '<a href="wo_display.php?wid=' . $row["WID"] . '">' . $woname . '</a>';
$dd[] = $row["Title"];
$dd[] = $row["Receiver"];
$dd[] = $row["DateNeedBy"];
if ($view == "full") {
if ($row["ApprovedByCap"]) {
$dd[] = "X";
} else {
$dd[] = "--";
}
if ($app) {
$dd[] = "X";
} else {
