. TB_PREF . "bank_trans,"
. TB_PREF . "bank_accounts "
. "WHERE "
- . TB_PREF . "supp_trans.supplier_id=" . $supplier_id . " "
+ . TB_PREF . "supp_trans.supplier_id='" . $supplier_id . "' "
. "AND " . TB_PREF . "supp_trans.tran_date<'" . $date . "' "
. "AND " . TB_PREF . "supp_trans.type=" . ST_SUPPAYMENT . " "
. "AND " . TB_PREF . "supp_trans.trans_no=" . TB_PREF . "bank_trans.trans_no "
else {
$sql .= " AND trans.tran_date >= '$date_after'
AND trans.tran_date <= '$date_to'";
+ $sql2 .= " AND trans.delivery_date >= '$date_after'
+ AND trans.delivery_date <= '$date_to'";
}
if ($supplier_id != ALL_TEXT) {