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
}
}
}
