X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=gl%2Fincludes%2Fdb%2Fgl_db_bank_trans.inc;h=5ffa2d0cf0acd52f8f5eabead63a537971f4abe9;hb=fd70a44680d92dab4b7abdbe9903a40c9f20314b;hp=a4228f5c434177e4c97e45efe9b54d1b566d1516;hpb=95ff74b5722826544743a01daf527aa3c9efe11a;p=fa-stable.git diff --git a/gl/includes/db/gl_db_bank_trans.inc b/gl/includes/db/gl_db_bank_trans.inc index a4228f5c..5ffa2d0c 100644 --- a/gl/includes/db/gl_db_bank_trans.inc +++ b/gl/includes/db/gl_db_bank_trans.inc @@ -76,13 +76,13 @@ function get_bank_trans($type, $trans_no=null, $person_type_id=null, $person_id= LEFT JOIN ".TB_PREF."suppliers supplier ON supplier.supplier_id = st.supplier_id, ".TB_PREF."bank_accounts act WHERE act.id=bt.bank_act "; - if ($type != null) + if (isset($type)) $sql .= " AND bt.type=".db_escape($type); - if ($trans_no != null) + if (isset($trans_no)) $sql .= " AND bt.trans_no = ".db_escape($trans_no); - if ($person_type_id != null) + if (isset($person_type_id)) $sql .= " AND bt.person_type_id = ".db_escape($person_type_id); - if ($person_id != null) + if (isset($person_id)) $sql .= " AND bt.person_id = ".db_escape($person_id); $sql .= " ORDER BY trans_date, bt.id";