function updateIssueQtyANDlocation($item_code, $currentIssueQty, $issueLocation) { $sql = "Update raw_item set stock_issue_qty='{$currentIssueQty}' , issue_location='{$issueLocation}' WHERE stock_item_id='{$item_code}'"; return parent::updateQuery($sql); }
function updateReqStatus($rm_id) { $sql = 'UPDATE requisitions_master set status=3 WHERE rm_id=' . $rm_id; return parent::updateQuery($sql); }
function updateDepartment($depid, $depOfficeID, $department_name) { $sql = "UPDATE departments \n\t\t\t\tSET department_name = '{$department_name}',department_office_id='{$depOfficeID}' \n\t\t\t\tWHERE department_id='{$depid}'"; parent::updateQuery($sql); }
function updateStockPartNo($stcItmId, $txtStkPart) { $sql = "UPDATE stock_part_details SET stock_part = '{$txtStkPart}' WHERE stock_part_m_id= '{$stcItmId}'"; return parent::updateQuery($sql); }
function updateReqStatus($user_level, $rm_id) { if ($user_level == 0) { $sql = 'UPDATE requisitions_master set status=1 WHERE rm_id=' . $rm_id; } if ($user_level == 1) { $sql = 'UPDATE requisitions_master set status=2 WHERE rm_id=' . $rm_id; } return parent::updateQuery($sql); }
function Update() { $sql = "UPDATE companies SET\n\t\tcompany_name='{$this->name}',\n\t\tcompany_mailing_name='{$this->mailing_name}',\n\t\tcompany_address='{$this->address}',\n\t\tcompany_phone='{$this->phone}',\n\t\tcompany_email='{$this->email}',\n\t\tcompany_financial_year_start='{$this->financial_year_start}',\n\t\tcompany_financial_year_end ='{$this->financial_year_end}',\n\t\tupdated_at=NOW()\t\n\t\t"; parent::updateQuery($sql); }
function updateSection($secid, $section_name, $department, $officeName) { $sql = "UPDATE user_section \n\t\t\t\tSET sec_name = '{$section_name}',dep_id='{$department}',office_id='{$officeName}'\n\t\t\t\tWHERE sec_id='{$secid}'"; parent::updateQuery($sql); }
function updateReceivedQty($item_code, $current_recieved_qty) { $sql = "Update finish_item set \tstock_received_qty='{$current_recieved_qty}' WHERE stock_item_id='{$item_code}'"; return parent::updateQuery($sql); }