<?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) {
<?php // Copyright SQCRM. For licensing, reuse, modification and distribution see license.txt /** * Create report step4 view * @author Abhik Chakraborty */ $do_report_fields = new ReportFields(); $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"]); $selected_report_fields = array(); if (isset($edit) && $edit == 1) { $do_report_sorting = new ReportSorting(); $saved_fields = $do_report_fields->get_report_fields_ids($sqcrm_record_id); if (false !== $saved_fields && count($saved_fields) > 0) { $selected_report_fields = $do_report_sorting->get_report_sorting_fields_on_create($saved_fields); } else { $selected_report_fields = array(); } } elseif (isset($_SESSION["report_fields"])) { if (isset($_SESSION["report_fields_data"]) && count($_SESSION["report_fields_data"]) > 0) { $selected_report_fields = $_SESSION["report_fields_data"]; } } $e_set_report_data = new Event("Report->eventSetReportData"); $e_set_report_data->addParam("step", "4"); if (isset($edit) && $edit == 1) { $edit_msg = _('Update Report'); $e_set_report_data->addParam("mode", "edit");
<?php // Copyright SQCRM. For licensing, reuse, modification and distribution see license.txt /** * Report run * @author Abhik Chakraborty */ if ((int) $sqcrm_record_id > 0) { $do_report = new Report(); $do_report_module_rel = new ReportModuleRel(); $do_report->set_report_modules($do_report_module_rel->get_report_modules($sqcrm_record_id)); $do_report_fields = new ReportFields(); $do_report->set_report_fields($do_report_fields->get_report_fields($sqcrm_record_id)); $do_report_sorting = new ReportSorting(); $do_report->set_report_order_by($do_report_sorting->get_report_sorting_condition($sqcrm_record_id)); $do_report_filter = new ReportFilter(); $do_report->set_report_date_filter($do_report_filter->get_parsed_date_filter($sqcrm_record_id)); $adv_filter = $do_report_filter->get_parsed_adv_filter($sqcrm_record_id); if (isset($_REQUEST["runtime"]) && (int) $_REQUEST["runtime"] == 1) { $data = array("filter_type" => $_REQUEST["report_date_field_type_runtime"], "idfield" => $_REQUEST["report_date_field_runtime"], "start_date" => $_REQUEST["report_date_start_runtime"], "end_date" => $_REQUEST["report_date_end_runtime"]); $set_date_filter = true; if ((int) $_REQUEST["report_date_field_runtime"] == 0) { $set_date_filter = false; } else { if ((int) $_REQUEST["report_date_field_type_runtime"] == 1 && ($_REQUEST["report_date_start_runtime"] == '' || $_REQUEST["report_date_end_runtime"] == '')) { $set_date_filter = false; } } if (true === $set_date_filter) { $do_report->set_report_date_filter($do_report_filter->get_parsed_date_filter($sqcrm_record_id, $data)); }
/** * function update report data * @param object $evctl * @return integer */ public function update_report($evctl) { $idreport = $evctl->sqrecord; $qry = "\n\t\tupdate `" . $this->getTable() . "`\n\t\tset `name` = ?,\n\t\t`description` = ?,\n\t\t`idreport_folder` = ?,\n\t\t`report_type` = ?\n\t\twhere `idreport` = ?\n\t\t"; $this->query($qry, array($evctl->name, $evctl->description, $evctl->idreport_folder, $_SESSION["report_type"], $idreport)); $do_report_module_rel = new ReportModuleRel(); $do_report_module_rel->update_report_module_rel($idreport, $_SESSION["primary_module"], $_SESSION["secondary_module"]); $do_report_fields = new ReportFields(); $do_report_fields->update_report_fields($idreport, $_SESSION["report_fields"]); $do_report_sorting = new ReportSorting(); $do_report_sorting->update_report_sort_fields($idreport, $_SESSION["report_order_by"]); $do_report_filter = new ReportFilter(); $do_report_filter->update_report_filter($idreport, $_SESSION["report_filter"]); return $idreport; }