365 lines
13 KiB
PHP
365 lines
13 KiB
PHP
<?php
|
|
/*+********************************************************************************
|
|
* The contents of this file are subject to the vtiger CRM Public License Version 1.0
|
|
* ("License"); You may not use this file except in compliance with the License
|
|
* The Original Code is: vtiger CRM Open Source
|
|
* The Initial Developer of the Original Code is vtiger.
|
|
* Portions created by vtiger are Copyright (C) vtiger.
|
|
* All Rights Reserved.
|
|
********************************************************************************/
|
|
require_once('data/Tracker.php');
|
|
|
|
global $mod_strings;
|
|
global $app_list_strings;
|
|
global $app_strings;
|
|
global $current_user;
|
|
$focus = 0;
|
|
global $theme;
|
|
global $log,$default_charset;
|
|
|
|
//<<<<<>>>>>>
|
|
global $oCustomView;
|
|
//<<<<<>>>>>>
|
|
|
|
$error_msg = '';
|
|
$theme_path="themes/".$theme."/";
|
|
$image_path=$theme_path."images/";
|
|
require_once('modules/CustomView/CustomView.php');
|
|
|
|
$cv_module = vtlib_purify($_REQUEST['module']);
|
|
|
|
$recordid = vtlib_purify($_REQUEST['record']);
|
|
|
|
$smarty->assign("MOD", $mod_strings);
|
|
$smarty->assign("CATEGORY", getParentTab());
|
|
$smarty->assign("APP", $app_strings);
|
|
$smarty->assign("THEME", $theme);
|
|
$smarty->assign("IMAGE_PATH", $image_path);
|
|
$smarty->assign("MODULE",$cv_module);
|
|
$smarty->assign("MODULELABEL",getTranslatedString($cv_module,$cv_module));
|
|
$smarty->assign("CVMODULE", $cv_module);
|
|
$smarty->assign("CUSTOMVIEWID",$recordid);
|
|
$smarty->assign("DATEFORMAT",$current_user->date_format);
|
|
$smarty->assign("JS_DATEFORMAT",parse_calendardate($app_strings['NTC_DATE_FORMAT']));
|
|
|
|
if($recordid == "") {
|
|
$oCustomView = new CustomView();
|
|
$modulecollist = $oCustomView->getModuleColumnsList($cv_module);
|
|
$log->info('CustomView :: Successfully got ColumnsList for the module'.$cv_module);
|
|
if(isset($modulecollist)) {
|
|
$choosecolslist = getByModule_ColumnsList($cv_module,$modulecollist);
|
|
}
|
|
for($i=1;$i<10;$i++) {
|
|
$smarty->assign("CHOOSECOLUMN".$i,$choosecolslist);
|
|
}
|
|
|
|
$stdfilterhtml = $oCustomView->getStdFilterCriteria();
|
|
$stdfiltercolhtml = getStdFilterHTML($cv_module);
|
|
$stdfilterjs = $oCustomView->getCriteriaJS();
|
|
|
|
$smarty->assign("STDFILTERCOLUMNS",$stdfiltercolhtml);
|
|
$smarty->assign("STDCOLUMNSCOUNT",count($stdfiltercolhtml));
|
|
$smarty->assign("STDFILTERCRITERIA",$stdfilterhtml);
|
|
$smarty->assign("STDFILTER_JAVASCRIPT",$stdfilterjs);
|
|
|
|
$advfilterhtml = getAdvCriteriaHTML();
|
|
$modulecolumnshtml = getByModule_ColumnsHTML($cv_module,$modulecollist);
|
|
$smarty->assign("FOPTION",$advfilterhtml);
|
|
$smarty->assign("COLUMNS_BLOCK",$modulecolumnshtml);
|
|
|
|
$smarty->assign("MANDATORYCHECK",implode(",",array_unique($oCustomView->mandatoryvalues)));
|
|
$smarty->assign("SHOWVALUES",implode(",",$oCustomView->showvalues));
|
|
$data_type[] = $oCustomView->data_type;
|
|
$smarty->assign("DATATYPE",$data_type);
|
|
|
|
} else {
|
|
$oCustomView = new CustomView($cv_module);
|
|
$now_action = vtlib_purify($_REQUEST['action']);
|
|
if($oCustomView->isPermittedCustomView($recordid,$now_action,$oCustomView->customviewmodule) == 'yes') {
|
|
$customviewdtls = $oCustomView->getCustomViewByCvid($recordid);
|
|
$log->info('CustomView :: Successfully got ViewDetails for the Viewid'.$recordid);
|
|
$modulecollist = $oCustomView->getModuleColumnsList($cv_module);
|
|
$selectedcolumnslist = $oCustomView->getColumnsListByCvid($recordid);
|
|
$log->info('CustomView :: Successfully got ColumnsList for the Viewid'.$recordid);
|
|
|
|
$smarty->assign("VIEWNAME",$customviewdtls["viewname"]);
|
|
|
|
if($customviewdtls["setdefault"] == 1) {
|
|
$smarty->assign("CHECKED","checked");
|
|
}
|
|
if($customviewdtls["setmetrics"] == 1) {
|
|
$smarty->assign("MCHECKED","checked");
|
|
}
|
|
$status = $customviewdtls["status"];
|
|
$smarty->assign("STATUS",$status);
|
|
|
|
for($i=1;$i<10;$i++) {
|
|
$choosecolslist = getByModule_ColumnsList($cv_module,$modulecollist,$selectedcolumnslist[$i-1]);
|
|
$smarty->assign("CHOOSECOLUMN".$i,$choosecolslist);
|
|
}
|
|
|
|
$stdfilterlist = $oCustomView->getStdFilterByCvid($recordid);
|
|
$log->info('CustomView :: Successfully got Standard Filter for the Viewid'.$recordid);
|
|
$stdfilterlist["stdfilter"] = ($stdfilterlist["stdfilter"] != "") ? ($stdfilterlist["stdfilter"]) : ("custom");
|
|
$stdfilterhtml = $oCustomView->getStdFilterCriteria($stdfilterlist["stdfilter"]);
|
|
$stdfiltercolhtml = getStdFilterHTML($cv_module,$stdfilterlist["columnname"]);
|
|
$stdfilterjs = $oCustomView->getCriteriaJS();
|
|
|
|
$smarty->assign("STARTDATE",$stdfilterlist["startdate"]);
|
|
$smarty->assign("ENDDATE",$stdfilterlist["enddate"]);
|
|
|
|
$smarty->assign("STDFILTERCOLUMNS",$stdfiltercolhtml);
|
|
$smarty->assign("STDCOLUMNSCOUNT",count($stdfiltercolhtml));
|
|
$smarty->assign("STDFILTERCRITERIA",$stdfilterhtml);
|
|
$smarty->assign("STDFILTER_JAVASCRIPT",$stdfilterjs);
|
|
|
|
$advfilterlist = $oCustomView->getAdvFilterByCvid($recordid);
|
|
$advfilterhtml = getAdvCriteriaHTML();
|
|
$modulecolumnshtml = getByModule_ColumnsHTML($cv_module,$modulecollist);
|
|
$smarty->assign("FOPTION",$advfilterhtml);
|
|
$smarty->assign("COLUMNS_BLOCK",$modulecolumnshtml);
|
|
$smarty->assign("CRITERIA_GROUPS",$advfilterlist);
|
|
|
|
$smarty->assign("MANDATORYCHECK",implode(",",array_unique($oCustomView->mandatoryvalues)));
|
|
$smarty->assign("SHOWVALUES",implode(",",$oCustomView->showvalues));
|
|
$smarty->assign("EXIST","true");
|
|
$cactionhtml = "<input name='customaction' class='button' type='button' value='Create Custom Action' onclick=goto_CustomAction('".$cv_module."');>";
|
|
|
|
if($cv_module == "Leads" || $cv_module == "Accounts" || $cv_module == "Contacts")
|
|
{
|
|
$smarty->assign("CUSTOMACTIONBUTTON",$cactionhtml);
|
|
}
|
|
$data_type[] = $oCustomView->data_type;
|
|
$smarty->assign("DATATYPE",$data_type);
|
|
}
|
|
else
|
|
{
|
|
echo "<table border='0' cellpadding='5' cellspacing='0' width='100%' height='450px'><tr><td align='center'>";
|
|
echo "<div style='border: 3px solid rgb(153, 153, 153); background-color: rgb(255, 255, 255); width: 55%; position: relative; z-index: 10000000;'>
|
|
<table border='0' cellpadding='5' cellspacing='0' width='98%'>
|
|
<tbody><tr>
|
|
<td rowspan='2' width='11%'><img src='". vtiger_imageurl('denied.gif', $theme)."' ></td>
|
|
<td style='border-bottom: 1px solid rgb(204, 204, 204);' nowrap='nowrap' width='70%'><span class='genHeaderSmall'>$app_strings[LBL_PERMISSION]</span></td>
|
|
</tr>
|
|
<tr>
|
|
<td class='small' align='right' nowrap='nowrap'>
|
|
<a href='javascript:window.history.back();'>$app_strings[LBL_GO_BACK]</a><br>
|
|
</td>
|
|
</tr>
|
|
</tbody></table>
|
|
</div>";
|
|
echo "</td></tr></table>";
|
|
exit;
|
|
}
|
|
}
|
|
|
|
$smarty->assign("RETURN_MODULE", $cv_module);
|
|
if($cv_module == "Calendar")
|
|
$return_action = "ListView";
|
|
else
|
|
$return_action = "index";
|
|
|
|
if($recordid == '')
|
|
$act = $mod_strings['LBL_NEW'];
|
|
else
|
|
$act = $mod_strings['LBL_EDIT'];
|
|
|
|
$smarty->assign("ACT", $act);
|
|
$smarty->assign("RETURN_ACTION", $return_action);
|
|
|
|
$smarty->display("CustomView.tpl");
|
|
|
|
function getByModule_ColumnsHTML($module,$columnslist,$selected="") {
|
|
$columnsList = getByModule_ColumnsList($module,$columnslist,$selected);
|
|
return generateSelectColumnsHTML($columnsList,$module);
|
|
}
|
|
|
|
function generateSelectColumnsHTML($columnsList, $module) {
|
|
$shtml = '';
|
|
|
|
foreach($columnsList as $blocklabel=>$blockcolumns) {
|
|
$shtml .= "<optgroup label='".getTranslatedString($blocklabel,$module)."' class='select' style='border:none'>";
|
|
foreach($blockcolumns as $columninfo) {
|
|
$shtml .= "<option ".$columninfo['selected']." value='".$columninfo['value']."'>".$columninfo['text']."</option>";
|
|
}
|
|
}
|
|
return $shtml;
|
|
}
|
|
|
|
function getByModule_ColumnsList($module,$columnslist,$selected="") {
|
|
global $oCustomView, $current_language,$theme;
|
|
global $app_list_strings;
|
|
$advfilter = array();
|
|
$mod_strings = return_specified_module_language($current_language,$module);
|
|
|
|
$check_dup = Array();
|
|
foreach($oCustomView->module_list[$module] as $key=>$value)
|
|
{
|
|
$advfilter = array();
|
|
$label = $key;
|
|
if(isset($columnslist[$module][$key]))
|
|
{
|
|
foreach($columnslist[$module][$key] as $field=>$fieldlabel)
|
|
{
|
|
if(!in_array($fieldlabel,$check_dup))
|
|
{
|
|
if(isset($mod_strings[$fieldlabel]))
|
|
{
|
|
if($selected == $field)
|
|
{
|
|
$advfilter_option['value'] = $field;
|
|
$advfilter_option['text'] = $mod_strings[$fieldlabel];
|
|
$advfilter_option['selected'] = "selected";
|
|
}else
|
|
{
|
|
$advfilter_option['value'] = $field;
|
|
$advfilter_option['text'] = $mod_strings[$fieldlabel];
|
|
$advfilter_option['selected'] = "";
|
|
}
|
|
}else
|
|
{
|
|
if($selected == $field)
|
|
{
|
|
$advfilter_option['value'] = $field;
|
|
$advfilter_option['text'] = $fieldlabel;
|
|
$advfilter_option['selected'] = "selected";
|
|
}else
|
|
{
|
|
$advfilter_option['value'] = $field;
|
|
$advfilter_option['text'] = $fieldlabel;
|
|
$advfilter_option['selected'] = "";
|
|
}
|
|
}
|
|
$advfilter[] = $advfilter_option;
|
|
$check_dup [] = $fieldlabel;
|
|
}
|
|
}
|
|
$advfilter_out[$label]= $advfilter;
|
|
}
|
|
}
|
|
// Special case handling only for Calendar moudle - Not required for other modules.
|
|
if($module == 'Calendar') {
|
|
$finalfield = Array();
|
|
$finalfield1 = Array();
|
|
$finalfield2 = Array();
|
|
$newLabel = $mod_strings['LBL_CALENDAR_INFORMATION'];
|
|
|
|
if(isset($advfilter_out[$mod_strings['LBL_TASK_INFORMATION']])) {
|
|
$finalfield1 = $advfilter_out[$mod_strings['LBL_TASK_INFORMATION']];
|
|
}
|
|
if(isset($advfilter_out[$mod_strings['LBL_EVENT_INFORMATION']])) {
|
|
$finalfield2 = $advfilter_out[$mod_strings['LBL_EVENT_INFORMATION']];
|
|
}
|
|
$finalfield[$newLabel] = array_merge($finalfield1,$finalfield2);
|
|
if (isset ($advfilter_out[$mod_strings['LBL_CUSTOM_INFORMATION']])) {
|
|
$finalfield[$mod_strings['LBL_CUSTOM_INFORMATION']] = $advfilter_out[$mod_strings['LBL_CUSTOM_INFORMATION']];
|
|
}
|
|
$advfilter_out=$finalfield;
|
|
}
|
|
return $advfilter_out;
|
|
}
|
|
|
|
/** to get the standard filter criteria
|
|
* @param $module(module name) :: Type String
|
|
* @param $elected (selection status) :: Type String (optional)
|
|
* @returns $filter Array in the following format
|
|
* $filter = Array( 0 => array('value'=>$tablename:$colname:$fieldname:$fieldlabel,'text'=>$mod_strings[$field label],'selected'=>$selected),
|
|
* 1 => array('value'=>$$tablename1:$colname1:$fieldname1:$fieldlabel1,'text'=>$mod_strings[$field label1],'selected'=>$selected),
|
|
*/
|
|
function getStdFilterHTML($module,$selected="")
|
|
{
|
|
global $app_list_strings, $current_language,$app_strings,$current_user;
|
|
require('user_privileges/user_privileges_'.$current_user->id.'.php');
|
|
global $oCustomView;
|
|
$stdfilter = array();
|
|
$result = $oCustomView->getStdCriteriaByModule($module);
|
|
$mod_strings = return_module_language($current_language,$module);
|
|
|
|
if(isset($result))
|
|
{
|
|
foreach($result as $key=>$value)
|
|
{
|
|
if($value == 'Start Date & Time')
|
|
{
|
|
$value = 'Start Date';
|
|
}
|
|
$use_module_label = getTranslatedString($module, $module);
|
|
if(isset($app_list_strings['moduleList'][$module])) {
|
|
$use_module_label = $app_list_strings['moduleList'][$module];
|
|
}
|
|
if(isset($mod_strings[$value]))
|
|
{
|
|
if($key == $selected)
|
|
{
|
|
|
|
$filter['value'] = $key;
|
|
$filter['text'] = $use_module_label." - ".getTranslatedString($value);
|
|
$filter['selected'] = "selected";
|
|
}else
|
|
{
|
|
$filter['value'] = $key;
|
|
$filter['text'] = $use_module_label." - ".getTranslatedString($value);
|
|
$filter['selected'] ="";
|
|
}
|
|
}
|
|
else
|
|
{
|
|
if($key == $selected)
|
|
{
|
|
$filter['value'] = $key;
|
|
|
|
$filter['text'] = $use_module_label." - ".$value;
|
|
$filter['selected'] = 'selected';
|
|
}else
|
|
{
|
|
$filter['value'] = $key;
|
|
$filter['text'] = $use_module_label." - ".$value;
|
|
$filter['selected'] ='';
|
|
}
|
|
}
|
|
$stdfilter[]=$filter;
|
|
//added to fix ticket #5117. If a user doesn't have permission for a field and it has been used to fileter a custom view, it should be get displayed to him as Not Accessible.
|
|
if(!$is_admin && $selected != '' && $filter['selected'] == '')
|
|
{
|
|
$keys = explode(":",$selected);
|
|
if(getFieldVisibilityPermission($module,$current_user->id,$keys[2]) != '0')
|
|
{
|
|
$filter['value'] = "not_accessible";
|
|
$filter['text'] = $app_strings["LBL_NOT_ACCESSIBLE"];
|
|
$filter['selected'] = "selected";
|
|
$stdfilter[]=$filter;
|
|
}
|
|
}
|
|
|
|
}
|
|
|
|
}
|
|
return $stdfilter;
|
|
}
|
|
|
|
/** to get the Advanced filter criteria
|
|
* @param $selected :: Type String (optional)
|
|
* @returns $AdvCriteria Array in the following format
|
|
* $AdvCriteria = Array( 0 => array('value'=>$tablename:$colname:$fieldname:$fieldlabel,'text'=>$mod_strings[$field label],'selected'=>$selected),
|
|
* 1 => array('value'=>$$tablename1:$colname1:$fieldname1:$fieldlabel1,'text'=>$mod_strings[$field label1],'selected'=>$selected),
|
|
* |
|
|
* n => array('value'=>$$tablenamen:$colnamen:$fieldnamen:$fieldlabeln,'text'=>$mod_strings[$field labeln],'selected'=>$selected))
|
|
*/
|
|
function getAdvCriteriaHTML($selected="")
|
|
{
|
|
global $adv_filter_options;
|
|
|
|
foreach($adv_filter_options as $key=>$value)
|
|
{
|
|
if($selected == $key)
|
|
{
|
|
$shtml .= "<option selected value=\"".$key."\">".$value."</option>";
|
|
}else
|
|
{
|
|
$shtml .= "<option value=\"".$key."\">".$value."</option>";
|
|
}
|
|
}
|
|
|
|
return $shtml;
|
|
}
|
|
?>
|