* SPDX-License-Identifier: AGPL-3.0-only
************************************/
require_once('include/CustomFieldUtil.php');
require_once('modules/CustomView/CustomView.php');
global $mod_strings,$app_strings,$app_list_strings,$theme,$adb,$current_user;
global $list_max_entries_per_page;
global $table_prefix;
require_once('modules/VteCore/layout_utils.php'); //crmv@30447
$iCurRecord = vtlib_purify($_REQUEST['CurRecordId']);
$sModule = vtlib_purify($_REQUEST['CurModule']);
require_once('data/CRMEntity.php');
$foc_obj = CRMEntity::getInstance($sModule);
//crmv@40590
$query = $adb->pquery("SELECT tabid,tablename,entityidfield,fieldname from ".$table_prefix."_entityname WHERE modulename = ?",array($sModule));
$tabid = $adb->query_result($query,0,'tabid');
//crmv@40590e
$table_name = $adb->query_result($query,0,'tablename');
$field_name = $adb->query_result($query,0,'fieldname');
$id_field = $adb->query_result($query,0,'entityidfield');
$fieldname = explode(",",$field_name);
$fields_array = array($sModule=>$fieldname);
$id_array = array($sModule=>$id_field);
$tables_array = array($sModule=>$table_name);
$permittedFieldNameList = array();
//crmv@40590
$result = $adb->pquery("SELECT fieldname,columnname FROM {$table_prefix}_field WHERE tabid = ? AND fieldname IN (".generateQuestionMarks($fieldname).")",array($tabid,$fieldname));
if ($result && $adb->num_rows($result) > 0) {
while($row=$adb->fetchByAssoc($result)) {
if(getFieldVisibilityPermission($sModule,$current_user->id,$row['fieldname']) == '0'){
$permittedFieldNameList[] = $row['columnname'];
}
}
}
//crmv@40590e
$cv = CRMEntity::getInstance('CustomView'); // crmv@115329
$viewId = $cv->getViewId($sModule);
if(!VteSession::isEmpty($sModule.'_DetailView_Navigation'.$viewId)){
$recordNavigationInfo = Zend_Json::decode(VteSession::get($sModule.'_DetailView_Navigation'.$viewId));
$recordList = array();
$recordIndex = null;
$recordPageMapping = array();
foreach ($recordNavigationInfo as $start=>$recordIdList){
foreach ($recordIdList as $index=>$recordId) {
$recordList[] = $recordId;
$recordPageMapping[$recordId] = $start;
if($recordId == $iCurRecord){
$recordIndex = count($recordList)-1;
}
}
}
}else{
$recordList = array();
}
$output = '
| '.$app_strings['JUMP_TO'].' '.$app_strings[$sModule].' |
|
';
$output .= '
';
$output .= '';
$output .= ' ';
if(count($recordList) > 0){
$displayRecordCount = 10;
$count = count($recordList);
$idListEndIndex = ($count < ($recordIndex+$displayRecordCount))? ($count+1) : ($recordIndex+$displayRecordCount+1);
$idListStartIndex = $recordIndex-$displayRecordCount;
if($idListStartIndex < 0){
$idListStartIndex = 0;
}
$idsArray = array_slice($recordList,$idListStartIndex,($idListEndIndex - $idListStartIndex));
$selectColString = implode(',',$permittedFieldNameList).', '.$id_array[$sModule];
$fieldQuery = "SELECT $selectColString from ".$tables_array[$sModule]." WHERE ".$id_array[$sModule]." IN (". generateQuestionMarks($idsArray) .")";
$fieldResult = $adb->pquery($fieldQuery,$idsArray);
$numOfRows = $adb->num_rows($fieldResult);
$recordNameMapping = array();
for($i=0; $i<$numOfRows; ++$i) {
$recordId = $adb->query_result($fieldResult,$i,$id_array[$sModule]);
$fieldValue = '';
foreach ($permittedFieldNameList as $fieldName) {
$fieldValue .= " ".$adb->query_result($fieldResult,$i,$fieldName);
}
$fieldValue = textlength_check($fieldValue);
$recordNameMapping[$recordId] = $fieldValue;
}
foreach ($idsArray as $id) {
if($id===$iCurRecord){
$output .= '| '.$recordNameMapping[$id].' | ';
}else{
$output .= '| '.$recordNameMapping[$id].' | ';
}
}
}
$output .= ' ';
$output .= ' | |
';
$output .= '';
echo $output;
?>