PHP fn_get_report_data Examples

Example #1

File: sales_reports.php Project: OneataBogdan/lead_coriolan

        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') {

Example #2

File: sales_reports.php Project: diedsmiling/busenika

        $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;