LEFT JOIN ".TB_PREF."voided v ON gl.type_no=v.id AND v.type=gl.type
LEFT JOIN ".TB_PREF."supp_trans st ON gl.type_no=st.trans_no AND st.type=gl.type AND (gl.type!=".ST_JOURNAL." OR gl.person_id=st.supplier_id)
- LEFT JOIN ".TB_PREF."grn_batch grn ON grn.id=gl.type_no AND gl.type=".ST_SUPPRECEIVE." AND gl.person_id=grn.supplier_id
+ LEFT JOIN ".TB_PREF."grn_batch grn ON grn.id=gl.type_no AND gl.type=".ST_SUPPRECEIVE."
LEFT JOIN ".TB_PREF."debtor_trans dt ON gl.type_no=dt.trans_no AND dt.type=gl.type AND (gl.type!=".ST_JOURNAL." OR gl.person_id=dt.debtor_no)
LEFT JOIN ".TB_PREF."suppliers sup ON st.supplier_id=sup.supplier_id OR grn.supplier_id=sup.supplier_id
function get_trans_tax_details($trans_type, $trans_no)
{
- $sql = "SELECT tax_details.*,
- tax_type.name AS tax_type_name,
- tax_details.rate AS effective_rate,
- tax_type.rate AS rate
- FROM ".TB_PREF."trans_tax_details tax_details,
- ".TB_PREF."tax_types tax_type
- WHERE
- trans_type = ".db_escape($trans_type)."
- AND trans_no = ".db_escape($trans_no)."
- AND (net_amount != 0 OR amount != 0)
- AND tax_type.id = tax_details.tax_type_id";
-
- return db_query($sql, "The transaction tax details could not be retrieved");
+ $sql = "SELECT tax_details.*, tax_type.name AS tax_type_name, tax_type.rate AS rate
+ FROM ".TB_PREF."trans_tax_details tax_details INNER JOIN
+ ".TB_PREF."tax_types tax_type ON tax_type.id = tax_details.tax_type_id
+ WHERE
+ trans_type = ".db_escape($trans_type)."
+ AND trans_no = ".db_escape($trans_no)."
+ AND (net_amount != 0 OR amount != 0)";
+
+ return db_query($sql, "The transaction tax details could not be retrieved");
}
//----------------------------------------------------------------------------------------