-function getCustInvTax($taxtype, $from, $to)
-{
- $fromdate = date2sql($from);
- $todate = date2sql($to);
- $amount = "IF(".TB_PREF."debtor_trans_tax_details.debtor_trans_type=11,-amount,amount)*".TB_PREF."debtor_trans.rate";
- $mamount = "IF(".TB_PREF."debtor_trans_tax_details.included_in_price=0, 0, $amount)";
- $netamount = "IF(".TB_PREF."debtor_trans.type=11,-quantity,quantity)*unit_price*".TB_PREF."debtor_trans.rate-$mamount";
-
- $sql = "SELECT SUM($netamount),
- SUM($amount)
- FROM ".TB_PREF."debtor_trans_details, ".TB_PREF."debtor_trans_tax_details, ".TB_PREF."debtor_trans
- WHERE ".TB_PREF."debtor_trans.type>=10
- AND ".TB_PREF."debtor_trans.type<=11
- AND ".TB_PREF."debtor_trans_details.debtor_trans_no=".TB_PREF."debtor_trans.trans_no
- AND ".TB_PREF."debtor_trans_details.debtor_trans_type=".TB_PREF."debtor_trans.type
- AND ".TB_PREF."debtor_trans.trans_no=".TB_PREF."debtor_trans_tax_details.debtor_trans_no
- AND ".TB_PREF."debtor_trans.type=".TB_PREF."debtor_trans_tax_details.debtor_trans_type
- AND ".TB_PREF."debtor_trans_tax_details.amount <> 0
- AND ".TB_PREF."debtor_trans_tax_details.tax_type_id=$taxtype
- AND ".TB_PREF."debtor_trans.tran_date >= '$fromdate'
- AND ".TB_PREF."debtor_trans.tran_date <= '$todate'";
-
- $result = db_query($sql,"No transactions were returned");
- return db_fetch_row($result);
-}
-
-function getSuppInvTax($taxtype, $from, $to)
-{
- $fromdate = date2sql($from);
- $todate = date2sql($to);
- $sql = "SELECT SUM(unit_price * quantity * ".TB_PREF."supp_trans.rate), SUM(amount*".TB_PREF."supp_trans.rate)
- FROM ".TB_PREF."supp_invoice_items, ".TB_PREF."supp_invoice_tax_items, ".TB_PREF."supp_trans
- WHERE ".TB_PREF."supp_trans.type>=20
- AND ".TB_PREF."supp_trans.type<=21
- AND ".TB_PREF."supp_trans.trans_no=".TB_PREF."supp_invoice_tax_items.supp_trans_no
- AND ".TB_PREF."supp_trans.type=".TB_PREF."supp_invoice_tax_items.supp_trans_type
- AND ".TB_PREF."supp_invoice_items.supp_trans_no=".TB_PREF."supp_trans.trans_no
- AND ".TB_PREF."supp_invoice_items.supp_trans_type=".TB_PREF."supp_trans.type
- AND ".TB_PREF."supp_invoice_tax_items.tax_type_id=$taxtype
- AND ".TB_PREF."supp_invoice_tax_items.amount <> 0
- AND ".TB_PREF."supp_trans.tran_date >= '$fromdate'
- AND ".TB_PREF."supp_trans.tran_date <= '$todate'";
-
- $result = db_query($sql,"No transactions were returned");
- return db_fetch_row($result);
-}
-