/** * function to export the list view data * @param string $module * @param integer $module_id * @param string $type * @param integer $view_id * @see self::export_data() */ public function export_list_data($module, $module_id, $type, $view_id = 0) { $file_name = $module; $object = new $module(); $do_crm_fields = new CRMFields(); $do_crm_list_view = new CRMListView(); $fields_info = $do_crm_list_view->get_listview_field_info($module, $module_id, "list", $view_id); $entity_table_name = $object->getTable(); $security_where = ""; $security_where = $_SESSION["do_crm_action_permission"]->get_user_where_condition($entity_table_name, $module_id); $additional_where_condition = ''; $group_by = ''; $order_by = ''; $object->get_list_query(); $qry = $object->getSqlQuery(); if (property_exists($object, "list_query_group_by") === true && $object->list_query_group_by != '') { $group_by = " group by " . $object->list_query_group_by; } if ($object->get_default_order_by() != "") { $order_by = " order by " . $object->get_default_order_by(); } if ((int) $view_id > 0) { $do_custom_view_filter = new CustomViewFilter(); $custom_view_date_filter_qry = $do_custom_view_filter->parse_custom_view_date_filter($view_id); $custom_view_adv_filter_qry = $do_custom_view_filter->parse_custom_view_advanced_filter($view_id); $additional_where_condition .= ' ' . $custom_view_date_filter_qry; if (false !== $custom_view_adv_filter_qry) { $additional_where_condition .= ' ' . $custom_view_adv_filter_qry["where"]; } $qry .= $security_where . $additional_where_condition . $group_by . $order_by; if (false !== $custom_view_adv_filter_qry) { $this->query($qry, $custom_view_adv_filter_qry["bind_params"]); } else { $this->query($qry); } } else { $this->query($qry . $security_where . $group_by . $order_by); } $this->export_data($file_name, $fields_info, $type, $module_id); }
$method_param_used = true; } else { $object->{$method}(); } } else { $object->{$method}(); } } else { $do_crm_list_view = new CRMListView(); $object = $do_crm_list_view->get_list_view_object($m, "list"); $object->get_list_query(); //check if the custom view is on and get the date filter and advanced filter query if (isset($_REQUEST["custom_view_id"]) && (int) $_REQUEST["custom_view_id"] > 0) { $do_custom_view_filter = new CustomViewFilter(); $additional_where_condition = ''; $custom_view_date_filter_qry = $do_custom_view_filter->parse_custom_view_date_filter((int) $_REQUEST["custom_view_id"]); $custom_view_adv_filter_qry = $do_custom_view_filter->parse_custom_view_advanced_filter((int) $_REQUEST["custom_view_id"]); $additional_where_condition .= ' ' . $custom_view_date_filter_qry; //print_r($custom_view_adv_filter_qry); if (false !== $custom_view_adv_filter_qry) { $additional_where_condition = ' ' . $custom_view_adv_filter_qry["where"]; $do_data_display->set_ds_additional_query_param($custom_view_adv_filter_qry["bind_params"]); } $do_data_display->set_ds_additional_where($additional_where_condition); } } $entity_table_name = $object->getTable(); //CRMListView::get_listview_field_info() sets the list_view_field_information $fields_info = $object->list_view_field_information; /** * FIXME