function get_transactions() { $date_after = date2sql($_POST['TransAfterDate']); $date_to = date2sql($_POST['TransToDate']); $sql = "SELECT debtor_trans.*,debtors_master.name AS CustName," . "debtors_master.curr_code AS CustCurrCode," . "(debtor_trans.ov_amount + debtor_trans.ov_gst + " . "debtor_trans.ov_freight + debtor_trans.ov_freight_tax + " . "debtor_trans.ov_discount) AS " . "TotalAmount, debtor_trans.alloc AS Allocated, " . "((debtor_trans.type = 10) " . "AND debtor_trans.due_date < '" . date2sql(Today()) . "') AS OverDue " . "FROM debtor_trans, debtors_master " . "WHERE debtors_master.debtor_no = debtor_trans.debtor_no " . "AND debtor_trans.tran_date >= '{$date_after}' " . "AND debtor_trans.tran_date <= '{$date_to}'"; if ($_POST['customer_id'] != reserved_words::get_all()) { $sql .= " AND debtor_trans.debtor_no = '" . $_POST['customer_id'] . "'"; } if ($_POST['filterType'] != reserved_words::get_all()) { if ($_POST['filterType'] == '1') { $sql .= " AND (debtor_trans.type = 10 OR debtor_trans.type = 1) "; } elseif ($_POST['filterType'] == '2') { $sql .= " AND (debtor_trans.type = 10) "; } elseif ($_POST['filterType'] == '3') { $sql .= " AND (debtor_trans.type = " . systypes::cust_payment() . " OR debtor_trans.type = 2) "; } elseif ($_POST['filterType'] == '4') { $sql .= " AND debtor_trans.type = 11 "; } elseif ($_POST['filterType'] == '5') { $sql .= " AND debtor_trans.type = 13 "; } if ($_POST['filterType'] == '2') { $today = date2sql(Today()); $sql .= " AND debtor_trans.due_date < '{$today}' " . "AND (debtor_trans.ov_amount + debtor_trans.ov_gst + " . "debtor_trans.ov_freight_tax + debtor_trans.ov_freight + " . "debtor_trans.ov_discount - debtor_trans.alloc > 0) "; } } $sql .= " ORDER BY debtor_trans.tran_date DESC,debtor_trans.type," . "debtor_trans.trans_no "; return db_query($sql, "No transactions were returned"); }
function get_transactions() { $data_after = date2sql($_POST['TransAfterDate']); $date_to = date2sql($_POST['TransToDate']); $sql = "SELECT debtor_trans.*,\n\t\tdebtors_master.name AS CustName, debtors_master.curr_code AS CustCurrCode,\n \t(debtor_trans.ov_amount + debtor_trans.ov_gst + " . "debtor_trans.ov_freight + debtor_trans.ov_freight_tax + debtor_trans.ov_discount)\n\t\tAS TotalAmount,\n\t\tdebtor_trans.alloc AS Allocated,\n\t\t((debtor_trans.type = 10)\n\t\tAND debtor_trans.due_date < '" . date2sql(Today()) . "') AS OverDue\n \tFROM debtor_trans, debtors_master\n \tWHERE debtors_master.debtor_no = debtor_trans.debtor_no\n\t\t\tAND (debtor_trans.ov_amount + debtor_trans.ov_gst + " . "debtor_trans.ov_freight + debtor_trans.ov_freight_tax + debtor_trans.ov_discount != 0)\n \t\tAND debtor_trans.tran_date >= '{$data_after}'\n \t\tAND debtor_trans.tran_date <= '{$date_to}'"; if ($_POST['customer_id'] != reserved_words::get_all()) { $sql .= " AND debtor_trans.debtor_no = '" . $_POST['customer_id'] . "'"; } if (isset($_POST['filterType']) && $_POST['filterType'] != reserved_words::get_all()) { if ($_POST['filterType'] == '1' || $_POST['filterType'] == '2') { $sql .= " AND debtor_trans.type = 10 "; } elseif ($_POST['filterType'] == '3') { $sql .= " AND debtor_trans.type = " . systypes::cust_payment(); } elseif ($_POST['filterType'] == '4') { $sql .= " AND debtor_trans.type = 11 "; } if ($_POST['filterType'] == '2') { $today = date2sql(Today()); $sql .= " AND debtor_trans.due_date < '{$today}'\n\t\t\t\tAND (round(abs(debtor_trans.ov_amount + " . "debtor_trans.ov_gst + debtor_trans.ov_freight + " . "debtor_trans.ov_freight_tax + debtor_trans.ov_discount) - debtor_trans.alloc,6) > 0) "; } } else { $sql .= " AND debtor_trans.type != 13 "; } if (!check_value('showSettled')) { $sql .= " AND (round(abs(debtor_trans.ov_amount + debtor_trans.ov_gst + " . "debtor_trans.ov_freight + debtor_trans.ov_freight_tax + " . "debtor_trans.ov_discount) - debtor_trans.alloc,6) != 0) "; } $sql .= " ORDER BY debtor_trans.tran_date"; return db_query($sql, "No transactions were returned"); }
include_once $path_to_root . "/includes/date_functions.inc"; include_once $path_to_root . "/includes/ui.inc"; include_once $path_to_root . "/sales/includes/sales_db.inc"; if (isset($_GET["trans_no"])) { $trans_id = $_GET["trans_no"]; } $receipt = get_customer_trans($trans_id, systypes::cust_payment()); display_heading(sprintf(tr("Customer Payment #%d"), $trans_id)); echo "<br>"; start_table("{$table_style} width=80%"); start_row(); label_cells(tr("From Customer"), $receipt['DebtorName'], "class='tableheader2'"); label_cells(tr("Into Bank Account"), $receipt['bank_account_name'], "class='tableheader2'"); label_cells(tr("Date of Deposit"), sql2date($receipt['tran_date']), "class='tableheader2'"); end_row(); start_row(); label_cells(tr("Payment Currency"), $receipt['curr_code'], "class='tableheader2'"); label_cells(tr("Amount"), price_format($receipt['ov_amount']), "class='tableheader2'"); label_cells(tr("Discount"), price_format($receipt['ov_discount']), "class='tableheader2'"); end_row(); start_row(); label_cells(tr("Payment Type"), $receipt['BankTransType'], "class='tableheader2'"); label_cells(tr("Reference"), $receipt['reference'], "class='tableheader2'", "colspan=4"); end_row(); comments_display_row(systypes::cust_payment(), $trans_id); end_table(1); $voided = is_voided_display(systypes::cust_payment(), $trans_id, tr("This customer payment has been voided.")); if (!$voided) { display_allocations_from(payment_person_types::customer(), $receipt['debtor_no'], systypes::cust_payment(), $trans_id, -$receipt['Total']); } end_page(true);