X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=admin%2Fview_print_transaction.php;h=94c22416102df6f35e29af92c87de8d7991bce1c;hb=c0d93311185d0657a6ff4a3c1e00c7967738fd27;hp=a8c09d2d6b0f7d13edaf70b459a333e9b9d5dd3e;hpb=da8311619dd73feae101d246a1957b972e00cbd2;p=fa-stable.git diff --git a/admin/view_print_transaction.php b/admin/view_print_transaction.php index a8c09d2d..94c22416 100644 --- a/admin/view_print_transaction.php +++ b/admin/view_print_transaction.php @@ -1,39 +1,70 @@ . +***********************************************************************/ $path_to_root=".."; $page_security = 5; +include($path_to_root . "/includes/db_pager.inc"); include_once($path_to_root . "/includes/session.inc"); -page(_("View or Print Transactions")); - include_once($path_to_root . "/includes/date_functions.inc"); include_once($path_to_root . "/includes/ui.inc"); include_once($path_to_root . "/includes/data_checks.inc"); include_once($path_to_root . "/reporting/includes/reporting.inc"); +$js = ""; +if ($use_popup_windows) + $js .= get_js_open_window(800, 500); +page(_("View or Print Transactions"), false, false, "", $js); //---------------------------------------------------------------------------------------- +function view_link($trans) +{ + return get_trans_view_str($trans["type"], $trans["trans_no"]); +} + +function prt_link($row) +{ + if ($row['type'] != 12 && $row['type'] != 2) // customer payment or bank deposit printout not defined yet. + return print_document_link($row['trans_no'], _("Print"), true, $row['type'], ICON_PRINT); +} + +function gl_view($row) +{ + return get_gl_view_str($row["type"], $row["trans_no"]); +} function viewing_controls() { - start_form(false, true); + display_note(_("Only documents can be printed.")); start_table("class='tablestyle_noborder'"); start_row(); systypes_list_cells(_("Type:"), 'filterType', null, true); + if (!isset($_POST['FromTransNo'])) + $_POST['FromTransNo'] = "1"; + if (!isset($_POST['ToTransNo'])) + $_POST['ToTransNo'] = "999999"; + ref_cells(_("from #:"), 'FromTransNo'); ref_cells(_("to #:"), 'ToTransNo'); - submit_cells('ProcessSearch', _("Search")); + submit_cells('ProcessSearch', _("Search"), '', '', 'default'); end_row(); end_table(1); - end_form(); } //---------------------------------------------------------------------------------------- @@ -42,13 +73,13 @@ function check_valid_entries() { if (!is_numeric($_POST['FromTransNo']) OR $_POST['FromTransNo'] <= 0) { - display_note(_("The starting transaction number is expected to be numeric and greater than zero.")); + display_error(_("The starting transaction number is expected to be numeric and greater than zero.")); return false; } if (!is_numeric($_POST['ToTransNo']) OR $_POST['ToTransNo'] <= 0) { - echo _("The ending transaction number is expected to be numeric and greater than zero."); + display_error(_("The ending transaction number is expected to be numeric and greater than zero.")); return false; } @@ -64,75 +95,56 @@ function handle_search() { $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 "; + $sql = "SELECT DISTINCT $trans_no_name as trans_no"; if ($trans_ref) $sql .= " ,$trans_ref "; - $sql .= " FROM $table_name + $sql .= ", ".$_POST['filterType']." as type FROM $table_name WHERE $trans_no_name >= " . $_POST['FromTransNo']. " AND $trans_no_name <= " . $_POST['ToTransNo']; if ($type_name != null) - $sql .= " AND $type_name = " . $_POST['filterType']; + $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 _("There are no transactions for the given parameters."); - return; - } - start_table($table_style); - if ($trans_ref) - $th = array(_("#"), _("Reference"), _("View"), _("Print")); - else - $th = array(_("#"), _("View"), _("Print")); - 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], _("View"))); - label_cell(get_gl_view_str_cell($_POST['filterType'], $line[$trans_no_name], _("View GL"))); - - $forms = get_form_entries($_POST['filterType'], $line[$trans_no_name]); - while ($form_item = db_fetch($forms)) - { - - $param1 = $form_item['param1']; - $param2 = $form_item['param2']; - - if ($_POST['filterType'] == systypes::bank_payment() - || $_POST['filterType'] == systypes::bank_deposit() - || $_POST['filterType'] == systypes::cust_payment() - || $_POST['filterType'] == systypes::supp_payment()) - { - $param1 = payment_person_types::type_name($form_item['param1']); - $param2 = payment_person_types::person_name($form_item['param1'], $form_item['param2'], false); - } - - //label_cell(printTransaction(_("Print") . " " . getFormTypeName($form_item["form_type"]), $form_item['form_id'], $form_item['form_type'], $_POST['filterType'], $line[$trans_no_name], $line[$trans_ref], $param1, $param2)); - } - end_row(); + $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()); + $cols = array( + _("#"), + _("Reference"), + _("View") => array('insert'=>true, 'fun'=>'view_link'), + _("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); } - end_table(); + $table =& new_db_pager('transactions', $sql, $cols); + if (list_updated('filterType') || get_post('ProcessSearch')) { + $table->set_sql($sql); + $table->set_columns($cols); + } + $table->width = "40%"; + display_db_pager($table); } + } //---------------------------------------------------------------------------------------- @@ -141,17 +153,15 @@ if (isset($_POST['ProcessSearch'])) { if (!check_valid_entries()) unset($_POST['ProcessSearch']); + $Ajax->activate('transactions'); } //---------------------------------------------------------------------------------------- -viewing_controls(); - -//echo getHiddenFieldScript(); - -handle_search(); - -br(2); +start_form(false); + viewing_controls(); + handle_search(); +end_form(2); end_page();