public static function update()
{
global $db;
global $auth_session;
$sql = "UPDATE\n " . TB_PREFIX . "expense\n SET\n amount = :amount,\n expense_account_id = :expense_account_id,\n biller_id = :biller_id,\n customer_id = :customer_id,\n invoice_id = :invoice_id,\n product_id = :product_id,\n date = :date,\n status = :status,\n note = :note\n WHERE\n id = :id\n AND\n domain_id = :domain_id\n ";
$db->query($sql, ':id', $_POST['id'], ':domain_id', $auth_session->domain_id, ':amount', $_POST['amount'], ':expense_account_id', $_POST['expense_account_id'], ':biller_id', $_POST['biller_id'], ':invoice_id', $_POST['invoice_id'], ':product_id', $_POST['product_id'], ':customer_id', $_POST['customer_id'], ':date', $_POST['date'], ':status', $_POST['status'], ':note', $_POST['note']);
expense::expense_item_tax($_POST['id'], $_POST['tax_id'][0], $_POST['amount'], "1", "update");
return true;
}
public static function update()
{
global $db;
global $auth_session;
$sql = "UPDATE
".TB_PREFIX."expense
SET
amount = :amount,
expense_account_id = :expense_account_id,
biller_id = :biller_id,
customer_id = :customer_id,
invoice_id = :invoice_id,
product_id = :product_id,
date = :date,
status = :status,
note = :note
WHERE
id = :id
AND
domain_id = :domain_id
";
$db->query($sql,
':id',$_POST['id'],
':domain_id',$auth_session->domain_id,
':amount', $_POST['amount'],
':expense_account_id', $_POST['expense_account_id'],
':biller_id', $_POST['biller_id'],
':invoice_id', $_POST['invoice_id'],
':product_id', $_POST['product_id'],
':customer_id', $_POST['customer_id'],
':date', $_POST['date'],
':status', $_POST['status'],
':note', $_POST['note']
);
expense::expense_item_tax($_POST['id'],$_POST['tax_id'][0],$_POST['amount'],"1","update");
return true;
}
