X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=admin%2Fview_print_transaction.php;h=0b4de2d25fde1dc98498a595e96ee33c0148a026;hb=a31195793c023906ab5da62f06ab84aefed445c3;hp=8e07831474eb3f9b9cc79638039840800877867f;hpb=335234b4bfa5e4fb58e35da36322b8d0cdfe7f89;p=fa-stable.git diff --git a/admin/view_print_transaction.php b/admin/view_print_transaction.php index 8e078314..0b4de2d2 100644 --- a/admin/view_print_transaction.php +++ b/admin/view_print_transaction.php @@ -1,16 +1,16 @@ . + See the License here . ***********************************************************************/ -$path_to_root=".."; -$page_security = 5; +$page_security = 'SA_VIEWPRINTTRANSACTION'; +$path_to_root = ".."; include($path_to_root . "/includes/db_pager.inc"); include_once($path_to_root . "/includes/session.inc"); @@ -18,35 +18,55 @@ include_once($path_to_root . "/includes/session.inc"); 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 . "/admin/db/transactions_db.inc"); include_once($path_to_root . "/reporting/includes/reporting.inc"); $js = ""; -if ($use_popup_windows) +if ($SysPrefs->use_popup_windows) $js .= get_js_open_window(800, 500); -page(_("View or Print Transactions"), false, false, "", $js); +page(_($help_context = "View or Print Transactions"), false, false, "", $js); //---------------------------------------------------------------------------------------- function view_link($trans) { + if (!isset($trans['type'])) + $trans['type'] = $_POST['filterType']; 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. + if (!isset($row['type'])) + $row['type'] = $_POST['filterType']; + if ($row['type'] == ST_PURCHORDER || $row['type'] == ST_SALESORDER || $row['type'] == ST_SALESQUOTE || + $row['type'] == ST_WORKORDER) return print_document_link($row['trans_no'], _("Print"), true, $row['type'], ICON_PRINT); + else + return print_document_link($row['trans_no']."-".$row['type'], _("Print"), true, $row['type'], ICON_PRINT); } function gl_view($row) { + if (!isset($row['type'])) + $row['type'] = $_POST['filterType']; return get_gl_view_str($row["type"], $row["trans_no"]); } +function date_view($row) +{ + return $row['trans_date']; +} + +function ref_view($row) +{ + return $row['ref']; +} + function viewing_controls() { display_note(_("Only documents can be printed.")); - start_table("class='tablestyle_noborder'"); + start_table(TABLESTYLE_NOBORDER); start_row(); systypes_list_cells(_("Type:"), 'filterType', null, true); @@ -60,7 +80,7 @@ function viewing_controls() ref_cells(_("to #:"), 'ToTransNo'); - submit_cells('ProcessSearch', _("Search"), '', '', true); + submit_cells('ProcessSearch', _("Search"), '', '', 'default'); end_row(); end_table(1); @@ -82,8 +102,6 @@ function check_valid_entries() display_error(_("The ending transaction number is expected to be numeric and greater than zero.")); return false; } - if (!isset($_POST['filterType']) || $_POST['filterType'] == "") - return false; return true; } @@ -92,42 +110,22 @@ function check_valid_entries() function handle_search() { - global $table_style; if (check_valid_entries()==true) { - $db_info = get_systype_db_info($_POST['filterType']); - - if ($db_info == null) + $trans_ref = false; + $sql = get_sql_for_view_transactions(get_post('filterType'), get_post('FromTransNo'), get_post('ToTransNo'), $trans_ref); + if ($sql == "") 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 as trans_no"; - - if ($trans_ref) - $sql .= " ,$trans_ref "; - - $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 .= " ORDER BY $trans_no_name"; - - - $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()); + $print_type = get_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( - _("#"), - _("Reference"), - _("View") => array('insert'=>true, 'fun'=>'view_link'), + _("#") => 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') ); @@ -139,10 +137,6 @@ function handle_search() } $table =& new_db_pager('transactions', $sql, $cols); - if (list_updated('filterType')) { - $table->set_sql($sql); - $table->set_columns($cols); - } $table->width = "40%"; display_db_pager($table); } @@ -160,11 +154,10 @@ if (isset($_POST['ProcessSearch'])) //---------------------------------------------------------------------------------------- -start_form(false, true); +start_form(false); viewing_controls(); handle_search(); end_form(2); end_page(); -?>