function handle_search() { if (check_valid_entries() == true) { $trans_ref = false; $sql = get_sql_for_view_transactions($_POST['filterType'], $_POST['FromTransNo'], $_POST['ToTransNo'], $trans_ref); if ($sql == "") { return; } $print_type = $_POST['filterType']; $print_out = $print_type == ST_SALESINVOICE || $print_type == ST_CUSTCREDIT || $print_type == ST_CUSTDELIVERY || $print_type == ST_PURCHORDER || $print_type == ST_SALESORDER || $print_type == ST_SALESQUOTE || $print_type == ST_CUSTPAYMENT || $print_type == ST_SUPPAYMENT || $print_type == ST_WORKORDER; $cols = array(_("#") => array('insert' => true, 'fun' => 'view_link'), _("Reference") => array('fun' => 'ref_view'), _("Date") => array('type' => 'date', 'fun' => 'date_view'), _("Print") => array('insert' => true, 'fun' => 'prt_link'), _("GL") => array('insert' => true, 'fun' => 'gl_view')); if (!$print_out) { array_remove($cols, 3); } if (!$trans_ref) { array_remove($cols, 1); } $table =& new_db_pager('transactions', $sql, $cols); $table->width = "40%"; display_db_pager($table); } }
function handle_void_transaction() { if (check_valid_entries() == true) { $void_entry = get_voided_entry($_POST['filterType'], $_POST['trans_no']); if ($void_entry != null) { display_error(tr("The selected transaction has already been voided."), true); unset($_POST['trans_no']); unset($_POST['memo_']); unset($_POST['date_']); set_focus('trans_no'); return; } $ret = void_transaction($_POST['filterType'], $_POST['trans_no'], $_POST['date_'], $_POST['memo_']); if ($ret) { display_notification_centered(tr("Selected transaction has been voided.")); unset($_POST['trans_no']); unset($_POST['memo_']); unset($_POST['date_']); } else { display_error(tr("The entered transaction does not exist or cannot be voided.")); set_focus('trans_no'); } } }
set_focus('target_amount'); return false; } if (isset($_POST['target_amount']) && input_num('target_amount') == 0) { display_error(_("The incomming bank amount cannot be 0.")); set_focus('target_amount'); return false; } if (!db_has_currency_rates(get_bank_account_currency($_POST['FromBankAccount']), $_POST['DatePaid'])) { return false; } if (!db_has_currency_rates(get_bank_account_currency($_POST['ToBankAccount']), $_POST['DatePaid'])) { return false; } return true; } //---------------------------------------------------------------------------------------- function handle_add_deposit() { new_doc_date($_POST['DatePaid']); $trans_no = add_bank_transfer($_POST['FromBankAccount'], $_POST['ToBankAccount'], $_POST['DatePaid'], input_num('amount'), $_POST['ref'], $_POST['memo_'], input_num('charge'), input_num('target_amount')); meta_forward($_SERVER['PHP_SELF'], "AddedID={$trans_no}"); } //---------------------------------------------------------------------------------------- if (isset($_POST['AddPayment'])) { if (check_valid_entries() == true) { handle_add_deposit(); } } gl_payment_controls(); end_page();
function handle_search() { global $table_style; if (check_valid_entries() == true) { $db_info = get_systype_db_info($_POST['filterType']); if ($db_info == null) { return; } $table_name = $db_info[0]; $type_name = $db_info[1]; $trans_no_name = $db_info[2]; $trans_ref = $db_info[3]; $sql = "SELECT DISTINCT {$trans_no_name} "; if ($trans_ref) { $sql .= " ,{$trans_ref} "; } $sql .= " FROM {$table_name}\n\t\t\tWHERE {$trans_no_name} >= " . $_POST['FromTransNo'] . "\n\t\t\tAND {$trans_no_name} <= " . $_POST['ToTransNo']; if ($type_name != null) { $sql .= " AND {$type_name} = " . $_POST['filterType']; } $sql .= " ORDER BY {$trans_no_name}"; $result = db_query($sql, "could not query transactions on {$table_name}"); if (db_num_rows($result) == 0) { echo tr("There are no transactions for the given parameters."); return; } $print_type = $_POST['filterType']; $print_out = $print_type == 10 || $print_type == 11 || $print_type == systypes::cust_dispatch() || $print_type == systypes::po() || $print_type == systypes::sales_order(); if ($print_out) { print_hidden_script($print_type); if ($trans_ref) { $th = array(tr("#"), tr("Reference"), tr("View"), tr("Print"), tr("GL")); } else { $th = array(tr("#"), tr("View"), tr("Print"), tr("GL")); } } else { if ($trans_ref) { $th = array(tr("#"), tr("Reference"), tr("View"), tr("GL")); } else { $th = array(tr("#"), tr("View"), tr("GL")); } } start_table($table_style); table_header($th); $k = 0; while ($line = db_fetch($result)) { alt_table_row_color($k); label_cell($line[$trans_no_name]); if ($trans_ref) { label_cell($line[$trans_ref]); } label_cell(get_trans_view_str($_POST['filterType'], $line[$trans_no_name], tr("View"))); if ($print_out) { label_cell(print_document_link($line[$trans_no_name], tr("Print"), true, $print_type)); } label_cell(get_gl_view_str($_POST['filterType'], $line[$trans_no_name], tr("View GL"))); end_row(); } end_table(); } }