PHP ReportFilter::get_date_filter_fields Exemples

Exemple #1

Fichier : create_report_step6_view.php Projet : abhikchakraborty/sqcrm

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

Exemple #2

Fichier : run_report.php Projet : abhikchakraborty/sqcrm

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