<?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;
}
