/** * 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); }
$do_crm_list_view = new CRMListView(); $custom_view_id = 0; if ($_SESSION["do_crm_action_permission"]->action_permitted('view', 17)) { if (isset($_REQUEST["custom_view_id"]) && (int) $_REQUEST["custom_view_id"] > 0) { $custom_view_id = (int) $_REQUEST["custom_view_id"]; } else { if (isset($_SESSION[$module]["pinned_list_view"]) && (int) $_SESSION[$module]["pinned_list_view"] > 0) { $custom_view_id = $_SESSION[$module]["pinned_list_view"]; } else { $custom_view_id = $default_custom_view; // check list.php for the module ex. modules/Leads/list.php } } } $_SESSION[$module]["pinned_list_view"] = $custom_view_id; $fields_info = $do_crm_list_view->get_listview_field_info($module, $module_id, "list", $custom_view_id); $lp = 'n'; $lp_object = ''; $method = ''; $method_param = ''; $lp_mid = ''; } else { // if special list $lp = 'y'; $lp_object = $list_special_object; } ?> <link href="/js/plugins/DataTables/datatables.min.css" rel="stylesheet"> <script type="text/javascript" charset="utf-8"> $(document).ready(function() { //Select all records
function get_field_info_related_view($related_module, $mid) { $do_crm_list_view = new CRMListView(); return $do_crm_list_view->get_listview_field_info($related_module, $mid, "related"); }
* Popup modal for the list data for different modules * @author Abhik Chakraborty */ include_once "config.php"; $m = $_GET["m"]; $field = $_GET["fieldname"]; $fielddisp = $_GET["fielddisp"]; $special_field = ''; $special_field_name = ''; if (isset($_GET["special_field"]) && $_GET["special_field"] == 'yes') { $special_field = $_GET["special_field"]; $special_field_name = $_GET["special_field_name"]; } $module_id = $_SESSION["do_module"]->get_idmodule_by_name($m, $_SESSION["do_module"]); $do_crm_list_view = new CRMListView(); $fields_info = $do_crm_list_view->get_listview_field_info($m, $module_id, "popup"); $allow = true; if ($allow === true) { // FIXME ugly heck to fix the issue of not loading the datatable on popup on multiple try $table_div_id = 'sqcrmpopuplist' . time(); ?> <!-- Modifying the existing style for the datatable to fit the popup window /--> <style> div.dataTables_length label { width :250px; margin-left:5px; text-align: left; } div.dataTables_length select { width :75px;
?> </a> <? $e_finish = new Event("do_import->eventFinishImport"); ?> <a href="/<?php echo $e_finish->getUrl(); ?> " class="btn btn-primary"> <?php echo _('Done'); ?> </a> </div> <div class="clear_float"></div> <hr class="form_hr"> <div class="clear_float"></div> </div> <?php $do_crm_list_view = new CRMListView(); $fields_info = $do_crm_list_view->get_listview_field_info($_SESSION["do_module"]->modules_full_details[$import_module_id]["name"], $import_module_id, "list"); if (!is_object($_SESSION[$list_special_object])) { $ImportModule = new $list_special_object(); $ImportModule->sessionPersistent($list_special_object, "logout.php", TTL); } $list_special = true; $lp_mid = $import_module_id; $_SESSION[$list_special_object]->list_view_field_information = $fields_info; $method = "list_imported_data"; require_once 'view/listview_entry.php'; }