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