function deleteStaple_len($id)
{
$sql = 'DELETE FROM staple_length WHERE sta_len_id=' . $id;
return parent::deleteQuery($sql);
}
function deleteStockEngineerItem($id)
{
$sql = 'DELETE FROM stock_item WHERE stock_item_id=' . $id;
return parent::deleteQuery($sql);
}
function deleteLc($id)
{
$sql = 'DELETE FROM lc WHERE lc_id=' . $id;
return parent::deleteQuery($sql);
}
function deleteRequisitionById($id)
{
/*------------------------------------------
| this is a cascading delete by mysql
|-------------------------------------------*/
$sql = ' DELETE rm.*,rd.* FROM requisitions_master rm
INNER JOIN requisition_details rd ON
rm.rm_id=rd.requisition_master_id
WHERE rm.rm_id=' . $id;
return parent::deleteQuery($sql);
}
function deleteCount($id)
{
$sql = 'DELETE FROM count WHERE count_id=' . $id;
return parent::deleteQuery($sql);
}
function deleteLot($id)
{
$sql = 'DELETE FROM lot WHERE lot_id=' . $id;
return parent::deleteQuery($sql);
}
