<?php // Copyright SQCRM. For licensing, reuse, modification and distribution see license.txt /** * Create report step6 view * @author Abhik Chakraborty */ $do_report_fields = new ReportFields(); $do_report_filter = new ReportFilter(); $primary_module_id = $_SESSION["primary_module"]; $secondary_module_id = $_SESSION["secondary_module"]; $primary_report_fields = $do_report_fields->get_module_fields_for_report($_SESSION["primary_module"]); $secondary_report_fields = $do_report_fields->get_module_fields_for_report($_SESSION["secondary_module"]); $date_filters = $do_report_filter->get_date_filter_fields($primary_module_id, $secondary_module_id); $date_filter_options = $do_report_filter->get_date_filter_options(); $advanced_filter_options = $do_report_filter->get_advanced_filter_options(); $custom_date_options_style = 'style="display:block;"'; $selected_date_filters = array(); $selected_adv_filters = array(); if (isset($edit) && $edit == 1) { $selected_date_filters = $do_report_filter->get_saved_filter_details($sqcrm_record_id); $selected_adv_filters = $do_report_filter->get_saved_adv_filter_options($sqcrm_record_id); } elseif (isset($_SESSION["report_filter"])) { $selected_date_filter = $_SESSION["report_filter"]["date_filter_options"]; $selected_adv_filters = $_SESSION["report_filter"]["advanced_filter_options"]; } if (count($selected_date_filter) > 0 && $selected_date_filter["report_date_field_type"] != 1) { $custom_date_options_style = 'style="display:none;"'; } $e_set_report_data = new Event("Report->eventSetReportData"); if (isset($edit) && $edit == 1) {
$do_report->set_report_date_filter($do_report_filter->get_parsed_date_filter($sqcrm_record_id, $data)); } } if (false !== $adv_filter) { $do_report->set_report_adv_filter($adv_filter["where"]); $report_query = $do_report->execute_report($sqcrm_record_id); //echo $report_query; $do_report->query($report_query, $adv_filter["bind_params"]); } else { $report_query = $do_report->execute_report($sqcrm_record_id); //echo $report_query; $do_report->query($report_query); } //echo $report_query;exit; $report_modules = $do_report->get_report_modules(); $date_filters = $do_report_filter->get_date_filter_fields($report_modules["primary"]["idmodule"], $report_modules["secondary"]["idmodule"]); $date_filter_options = $do_report_filter->get_date_filter_options(); $saved_date_filter = array(); $custom_date_filter_values = false; if (isset($_REQUEST["runtime"]) && (int) $_REQUEST["runtime"] == 1) { if ($_REQUEST["report_date_field_type_runtime"] == 1) { $custom_date_filter_values = true; } $saved_date_filter = array("idfield" => $_REQUEST["report_date_field_runtime"], "filter_type" => $_REQUEST["report_date_field_type_runtime"], "start_date" => FieldType9::convert_before_save($_REQUEST["report_date_start_runtime"]), "end_date" => FieldType9::convert_before_save($_REQUEST["report_date_end_runtime"])); } else { $saved_date_filter_qry = $do_report_filter->get_saved_date_filter(); $do_report_filter->query($saved_date_filter_qry, array($sqcrm_record_id)); if ($do_report_filter->getNumRows() > 0) { $do_report_filter->next(); if ($do_report_filter->filter_type == 1) { $custom_date_filter_values = true;