/**
* 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';
}
