PHP fn_delete_report_data Examples

Example #1

File: sales_reports.php Project: OneataBogdan/lead_coriolan

    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') {
    db_query("DELETE FROM ?:sales_reports_table_conditions WHERE table_id = ?i", $_REQUEST['table_id']);
    fn_set_notification('N', __('notice'), __('text_conditions_cleared'));
    return array(CONTROLLER_STATUS_REDIRECT, "sales_reports.update_table?report_id={$_REQUEST['report_id']}&table_id={$_REQUEST['table_id']}");
    // View report
} elseif ($mode == 'view') {
    $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];

Example #2

File: sales_reports.php Project: askzap/ultimate

    if ($mode == 'delete_table') {
        if (!empty($_REQUEST['table_id'])) {
            fn_delete_report_data('table', $_REQUEST['table_id']);
        }
        $suffix = ".update?report_id={$_REQUEST['report_id']}&selected_section=tables";
    }
    // Clear table conditions
    if ($mode == 'clear_conditions') {
        db_query("DELETE FROM ?:sales_reports_table_conditions WHERE table_id = ?i", $_REQUEST['table_id']);
        fn_set_notification('N', __('notice'), __('text_conditions_cleared'));
        $suffix = ".update_table?report_id={$_REQUEST['report_id']}&table_id={$_REQUEST['table_id']}";
    }
    // Delete single report
    if ($mode == 'delete') {
        if (!empty($_REQUEST['report_id'])) {
            fn_delete_report_data('report', $_REQUEST['report_id']);
        }
        $suffix = '.manage';
    }
    return array(CONTROLLER_STATUS_OK, 'sales_reports' . $suffix);
}
$depend_items = fn_get_depended();
// The list of all reports
if ($mode == 'manage') {
    Tygh::$app['view']->assign('reports', fn_get_order_reports());
    // Edit report
} elseif ($mode == 'update' || $mode == 'add') {
    Registry::set('navigation.tabs.general', array('title' => __('general'), 'js' => true));
    if (!empty($_REQUEST['report_id'])) {
        Registry::set('navigation.tabs.tables', array('title' => __('charts'), 'js' => true));
        $report_data = fn_get_report_data($_REQUEST['report_id']);