コード例 #1
0
function getTransactions($debtorno, $from, $date)
{
    $sql = "SELECT " . TB_PREF . "debtor_trans.*, v.type as IsVoid,\t\n\t\t" . amountSQL() . "\n\t\tAS TotalAmount, " . TB_PREF . "debtor_trans.alloc AS Allocated,\n\t\t((" . TB_PREF . "debtor_trans.type != " . ST_SALESINVOICE . ")\n\t\tOR " . TB_PREF . "debtor_trans.due_date <= '{$date}') AS OverDue,\n\t\tIF(due_date = '0000-00-00' , " . TB_PREF . "debtor_trans.tran_date, due_date) AS EffectiveDate\n\t\tFROM " . TB_PREF . "debtor_trans\n\t\tLEFT JOIN " . TB_PREF . "voided v  ON v.type = " . TB_PREF . "debtor_trans.type and v.id=" . TB_PREF . "debtor_trans.trans_no\n\t\twhere GREATEST(" . TB_PREF . "debtor_trans.tran_date, " . TB_PREF . "debtor_trans.due_date) >= '{$from}' AND " . TB_PREF . "debtor_trans.debtor_no = " . db_escape($debtorno) . "\n\t\tAND " . TB_PREF . "debtor_trans.type <> " . ST_CUSTDELIVERY . "\n\t\tAND ABS(" . TB_PREF . "debtor_trans.ov_amount + " . TB_PREF . "debtor_trans.ov_gst + " . TB_PREF . "debtor_trans.ov_freight +\n\t\t" . TB_PREF . "debtor_trans.ov_freight_tax + " . TB_PREF . "debtor_trans.ov_discount) > 1e-6";
    $sql .= " ORDER BY " . TB_PREF . "debtor_trans.type";
    //and ".TB_PREF."debtor_trans.payment_terms != 4
    return db_query($sql, "No transactions were returned");
}
コード例 #2
0
function getTransactions($debtorno, $from, $date)
{
    $sql = "SELECT " . TB_PREF . "debtor_trans.*,\n\t\t" . amountSQL() . "\n\t\tAS TotalAmount, " . TB_PREF . "debtor_trans.alloc AS Allocated,\n\t\t((" . TB_PREF . "debtor_trans.type != " . ST_SALESINVOICE . ")\n\t\tOR " . TB_PREF . "debtor_trans.due_date <= '{$date}') AS OverDue,\n\t\tIF(due_date = '0000-00-00' , tran_date, due_date) AS EffectiveDate\n\t\tFROM " . TB_PREF . "debtor_trans\n\t\tWHERE GREATEST(" . TB_PREF . "debtor_trans.tran_date, " . TB_PREF . "debtor_trans.due_date) >= '{$from}' AND " . TB_PREF . "debtor_trans.debtor_no = " . db_escape($debtorno) . "\n\t\tAND " . TB_PREF . "debtor_trans.type <> " . ST_CUSTDELIVERY . "\n\t\tAND ABS(" . TB_PREF . "debtor_trans.ov_amount + " . TB_PREF . "debtor_trans.ov_gst + " . TB_PREF . "debtor_trans.ov_freight +\n\t\t" . TB_PREF . "debtor_trans.ov_freight_tax + " . TB_PREF . "debtor_trans.ov_discount) > 1e-6";
    $sql .= " ORDER BY IF(due_date = '0000-00-00' , tran_date, due_date)";
    return db_query($sql, "No transactions were returned");
}