Registry::set('navigation.tabs.' . $value['code'], array('title' => __('reports_parameter_' . $value['element_id']), 'js' => true)); } Registry::get('view')->assign('search_condition', true); Registry::get('view')->assign('intervals', db_get_array("SELECT * FROM ?:sales_reports_intervals ORDER BY interval_id")); // Payments Registry::get('view')->assign('payment_processors', db_get_array("SELECT processor_id, processor FROM ?:payment_processors")); Registry::get('view')->assign('payments', db_get_array("SELECT ?:payments.*, ?:payment_descriptions.* FROM ?:payments LEFT JOIN ?:payment_descriptions ON ?:payment_descriptions.payment_id = ?:payments.payment_id AND ?:payment_descriptions.lang_code = ?s ORDER BY ?:payments.position", DESCR_SL)); // Users Location Registry::get('view')->assign('usergroups', fn_get_usergroups('C', CART_LANGUAGE)); Registry::get('view')->assign('countries', fn_get_simple_countries(true, CART_LANGUAGE)); Registry::get('view')->assign('states', fn_get_all_states()); Registry::get('view')->assign('destinations', fn_get_destinations(CART_LANGUAGE)); // Locations Registry::get('view')->assign('destinations', fn_get_destinations(CART_LANGUAGE)); if (!empty($_REQUEST['table_id'])) { $table_data = fn_get_report_data($_REQUEST['report_id'], $_REQUEST['table_id']); $conditions = fn_get_table_condition($_REQUEST['table_id']); if (empty($conditions)) { $conditions = array(); } Registry::get('view')->assign('conditions', $conditions); Registry::get('view')->assign('table', $table_data); } // Delete report table } elseif ($mode == 'delete_table') { if (!empty($_REQUEST['table_id'])) { fn_delete_report_data('table', $_REQUEST['table_id']); } return array(CONTROLLER_STATUS_REDIRECT, "sales_reports.update?report_id={$_REQUEST['report_id']}&selected_section=tables"); // Clear table conditions } elseif ($mode == 'clear_conditions') {
$conditions = fn_get_table_condition($_REQUEST['table_id']); if (empty($conditions)) { $conditions = array(); } $view->assign('conditions', $conditions); // [Page sections] Registry::set('navigation.tabs.general', array('title' => fn_get_lang_var('general'), 'js' => true)); foreach ($depend_items as $value) { Registry::set('navigation.tabs.' . $value['code'], array('title' => fn_get_lang_var('reports_parameter_' . $value['element_id']), 'js' => true)); } // [/Page sections] $view->assign('search_condition', true); $intervals = db_get_array("SELECT a.* FROM ?:sales_reports_intervals as a ORDER BY a.interval_id"); $view->assign('intervals', $intervals); } $report_data = fn_get_report_data($_REQUEST['report_id']); fn_add_breadcrumb($report_data['description'], "sales_reports.report?report_id={$_REQUEST['report_id']}"); if (!empty($table_data)) { $view->assign('table', $table_data); } // // View reports // } elseif ($mode == 'reports') { $report_id = empty($_REQUEST['report_id']) ? db_get_field("SELECT report_id FROM ?:sales_reports WHERE status = 'A' ORDER BY position ASC LIMIT 1") : $_REQUEST['report_id']; $table_id = empty($_REQUEST['table_id']) ? db_get_field("SELECT table_id FROM ?:sales_reports_tables WHERE report_id = ?i ORDER BY position ASC LIMIT 1", $report_id) : intval($_REQUEST['table_id']); $reports = fn_get_order_reports(true, $report_id); // If some reports defined calculate data for them if (!empty($reports)) { $report = $reports[$report_id]; // Get report data for each table;