/** * 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); }
if (is_array($method_param) && count($method_param) > 0) { call_user_func_array(array($object, $method), $method_param); $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;
/** * function to edit custom view * @param object $evctl * @return void */ public function eventEditRecord(EventControler $evctl) { $do_edit = true; $error_message = ''; if ((int) $evctl->sqrecord == 0) { $error_message = _('Missing record id'); $do_edit = false; } elseif ((int) $evctl->target_module_id == 0) { $error_message = _('Missing target module for custom view !'); $do_edit = false; } elseif (trim($evctl->cvname) == '') { $error_message = _('Please add a custom view name before saving !'); $do_edit = false; } elseif ((int) $evctl->sqrecord > 0) { $this->getId($evctl->sqrecord); if ($this->getNumRows() > 0) { if ($this->iduser != $_SESSION["do_user"]->iduser) { $error_message = _('You do not have permission to edit the record !'); $do_edit = false; } if ($this->is_editable == 0) { $error_message = _('You do not have permission to edit the record !'); $do_edit = false; } if ($this->deleted == 1) { $error_message = _('You do not have permission to edit the record !'); $do_edit = false; } } else { $error_message = _('Custom view not found !'); $do_edit = false; } } if (true === $do_edit) { $idcustom_view = (int) $evctl->sqrecord; $this->getId($idcustom_view); $is_public = $this->is_public; $is_default = $evctl->is_default == 'on' ? 1 : 0; if ($_SESSION["do_user"]->is_admin == 1) { $is_public = $evctl->is_public == 'on' ? 1 : 0; } $qry = "\n\t\t\tupdate `" . $this->getTable() . "`\n\t\t\tset \n\t\t\t`name` = ? ,\n\t\t\t`is_default` = ? ,\n\t\t\t`is_public` = ? \n\t\t\twhere \n\t\t\t`idcustom_view` = ?\n\t\t\t"; $this->query($qry, array($evctl->cvname, $is_default, $is_public, $evctl->sqrecord)); //reset default custom view if is_default is set if ($evctl->is_default == 'on') { $this->reset_default_custom_view($idcustom_view, $evctl->target_module_id); } //update custom view fields $do_custom_view_fields = new CustomViewFields(); $do_custom_view_fields->update_custom_view_fields($evctl->sqrecord, $evctl->cv_fields); //add custom view filter $do_custom_view_filter = new CustomViewFilter(); $do_custom_view_filter->update_custom_view_date_filter($evctl->sqrecord, $evctl->cv_date_field, $evctl->cv_date_field_type, $evctl->cv_date_start, $evctl->cv_date_end); //update advanced filter $adv_filter_data = array("cv_adv_fields_1" => $evctl->cv_adv_fields_1, "cv_adv_fields_type_1" => $evctl->cv_adv_fields_type_1, "cv_adv_fields_val_1" => $_POST["cv_adv_fields_val_1"], "cv_adv_fields_2" => $evctl->cv_adv_fields_2, "cv_adv_fields_type_2" => $evctl->cv_adv_fields_type_2, "cv_adv_fields_val_2" => $_POST["cv_adv_fields_val_2"], "cv_adv_fields_3" => $evctl->cv_adv_fields_3, "cv_adv_fields_type_3" => $evctl->cv_adv_fields_type_3, "cv_adv_fields_val_3" => $_POST["cv_adv_fields_val_3"], "cv_adv_fields_4" => $evctl->cv_adv_fields_4, "cv_adv_fields_type_4" => $evctl->cv_adv_fields_type_4, "cv_adv_fields_val_4" => $_POST["cv_adv_fields_val_4"], "cv_adv_fields_5" => $evctl->cv_adv_fields_5, "cv_adv_fields_type_5" => $evctl->cv_adv_fields_type_5, "cv_adv_fields_val_5" => $_POST["cv_adv_fields_val_5"]); $do_custom_view_filter->update_custom_view_adv_filter($idcustom_view, $adv_filter_data); //redirect after adding the custom view $next_page = NavigationControl::getNavigationLink($_SESSION["do_module"]->modules_full_details[$evctl->target_module_id]["name"], "list", '', '&custom_view_id=' . $idcustom_view); $dis = new Display($next_page); $evctl->setDisplayNext($dis); } else { $_SESSION["do_crm_messages"]->set_message('error', $error_message); $next_page = NavigationControl::getNavigationLink("CustomView", "edit", $idcustom_view); $dis = new Display($next_page); $evctl->setDisplayNext($dis); } }
$do_edit = false; } if ($module_obj->is_editable == 0) { $do_edit = false; } } else { $do_edit = false; } } else { $do_edit = false; } if ($do_edit === false) { echo '<div class="alert alert-error alert-block" style="height:100px;margin-top:100px;margin-left:200px;margin-right:200px;">'; echo '<h4>'; echo _('Access Denied ! '); echo '</h4>'; echo _('You are not authorized to perform this operation.'); echo '</div>'; } else { $do_crmfields = new CRMFields(); $do_custom_view_fields = new CustomViewFields(); $do_custom_view_filter = new CustomViewFilter(); $cv_fields = $do_crmfields->get_fieldinfo_grouped_by_block($module_obj->idmodule, true); $date_filters = $do_crmfields->get_date_fields($module_obj->idmodule, true); $date_filter_options = ViewFilterUtils::get_date_filter_otions(); $advanced_filter_options = ViewFilterUtils::get_advanced_filter_options(); $saved_fields = $do_custom_view_fields->get_custom_view_fields($sqcrm_record_id); $saved_date_filter = $do_custom_view_filter->get_date_filter_information($sqcrm_record_id); $saved_advanced_filter = $do_custom_view_filter->get_saved_advanced_filter_information($sqcrm_record_id); require_once 'view/customview_edit_view.php'; }