/**
* 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
