public function createAddPart() { if (isset($_REQUEST['itemid']) && !empty($_REQUEST['wid'])) { $worksheet = Worksheet::find_by_id($_REQUEST['wid']); $myItem = Items::find_by_id($_REQUEST['itemid']); $propart = new Prodpart(); $propart->part_name = $myItem->item_name; $propart->qty = $_REQUEST['qty']; $propart->works_id = $_REQUEST['wid']; $propart->prod_id = $worksheet->prod_id; $propart->item_id = $_REQUEST['itemid']; $propart->datecreated = date("Y:m:d H:i:s"); $propart->des = ""; $propart->unit_cost = $_REQUEST['price']; $propart->total_cost = (int) $_REQUEST['price'] * (int) $_REQUEST['qty']; $Tlog = new Transaction(); $Tlog->com_id = $myItem->item_id; $Tlog->trans_type = "WORKSHEET PART SUPPLY"; $Tlog->trans_description = "allocation of resources to worksheet"; $Tlog->datecreated = date("Y-m-d H:i:s"); $Tlog->user_id = $_SESSION['emp_ident']; if ($propart->create()) { $Tlog->create(); return $propart; } else { return false; } } }
public function createAddPart() { if (isset($_POST['itemid']) && !empty($_POST['wid'])) { $worksheet = Worksheet::find_by_id($_POST['wid']); $myItem = Items::find_by_id($_POST['itemid']); $propart = new Prodpart(); $propart->part_name = $myItem->item_name; $propart->qty = $_POST['qty']; $propart->works_id = $_POST['wid']; $propart->prod_id = $worksheet->prod_id; $propart->item_id = $_POST['itemid']; $propart->date_changed = date("Y:m:d H:i:s"); $propart->desc = ""; $propart->unit_cost = $_POST['price']; $propart->total_cost = (int) $_POST['price'] * (int) $_POST['qty']; if ($propart->create()) { return $propart; } else { return false; } } }
/** * section to update * work sheet on support * or care resource * supply */ public function updateWorkSheet($id) { if (isset($_POST['pgid'])) { if (isset($_POST["prod_id"])) { $cproduct = Cproduct::find_by_id((int) preg_replace('#[^0-9]#i', '', $_POST["prod_id"])); } $WorkSheet = Worksheet::find_by_id((int) preg_replace('#[^0-9]#i', '', $id)); $WorkSheet->prod_id = isset($_POST["prod_id"]) && !empty($_POST["prod_id"]) ? $_POST["prod_id"] : $WorkSheet->prod_id; $WorkSheet->prod_name = isset($_POST["prod_id"]) && !empty($_POST["prod_id"]) ? $cproduct->prod_name : $WorkSheet->prod_name; $WorkSheet->sheet_date = isset($_POST["w_date"]) && !empty($_POST["w_date"]) ? $_POST["w_date"] : $WorkSheet->sheet_date; $WorkSheet->time_in = isset($_POST["time_in"]) && !empty($_POST["time_in"]) ? $_POST["time_in"] : $WorkSheet->time_in; $WorkSheet->time_out = isset($_POST["time_out"]) && !empty($_POST["time_out"]) ? $_POST["time_out"] : $WorkSheet->time_out; $WorkSheet->contact_person = isset($_POST["contact_person"]) && !empty($_POST["contact_person"]) ? $_POST["contact_person"] : $WorkSheet->contact_person; $WorkSheet->cse_emp_id = isset($_POST["emp_id"]) && !empty($_POST["emp_id"]) ? $_POST["emp_id"] : $WorkSheet->emp_id; $WorkSheet->problem = isset($_POST["problem"]) && !empty($_POST["problem"]) ? $_POST["problem"] : $WorkSheet->problem; $WorkSheet->cause = isset($_POST["cause"]) && !empty($_POST["cause"]) ? $_POST["cause"] : $WorkSheet->cause; $WorkSheet->corrective_action = isset($_POST["corrective_action"]) && !empty($_POST["corrective_action"]) ? $_POST["corrective_action"] : $WorkSheet->corrective_action; $WorkSheet->part_changed = isset($_POST["part_changed"]) && !empty($_POST["part_changed"]) ? $_POST["part_changed"] : $WorkSheet->part_changed; $WorkSheet->cse_remark = isset($_POST["cse_remark"]) && !empty($_POST["cse_remark"]) ? $_POST["cse_remark"] : $WorkSheet->cse_remark; $WorkSheet->client_remark = isset($_POST["client_remark"]) && !empty($_POST["client_remark"]) ? $_POST["client_remark"] : $WorkSheet->client_remark; $WorkSheet->datemodified = date("Y-m-d H:i:s"); $WorkSheet->fund = isset($_POST["fund"]) && !empty($_POST["fund"]) ? $_POST["fund"] : $WorkSheet->fund; $WorkSheet->part_supplied = isset($_POST["parts"]) && !empty($_POST["parts"]) ? $_POST["parts"] : $WorkSheet->part_supplied; global $session; if ($WorkSheet->update()) { $_SESSION["message"] = "<div data-alert class='alert-box success'>Record Saved <a href='#' class='close'>×</a></div>"; return 1; //returns 1 on success } else { $_SESSION["message"] = "<div data-alert class='alert-box alert'>Unexpected Error! Record not Saved <a href='#' class='close'>×</a></div>"; return 2; // returns 2 on insert error } } }