/**
* Function to get the list view entries
* @param Vtiger_Paging_Model $pagingModel
* @return <Array> - Associative array of record id mapped to Vtiger_Record_Model instance.
*/
public function getListViewEntries($pagingModel)
{
$queryGenerator = $this->get('query_generator');
// Added as Users module do not have custom filters and id column is added by querygenerator.
$fields = $queryGenerator->getFields();
$fields[] = 'id';
$queryGenerator->setFields($fields);
return parent::getListViewEntries($pagingModel);
}
/**
* Function to get the list view entries
* @param Vtiger_Paging_Model $pagingModel, $status (Active or Inactive User). Default false
* @return <Array> - Associative array of record id mapped to Vtiger_Record_Model instance.
*/
public function getListViewEntries($pagingModel)
{
$queryGenerator = $this->get('query_generator');
// Added as Users module do not have custom filters and id column is added by querygenerator.
$fields = $queryGenerator->getFields();
$fields[] = 'id';
$queryGenerator->setFields($fields);
$userFieldsFix = $this->get('search_params');
if (empty($userFieldsFix)) {
$userFieldsFix[0]['columns'] = array();
}
$indexKey = '';
$indexValue = '';
$roleKey = '';
$roleValue = '';
$roleDataInfo = array();
foreach ($userFieldsFix[0]['columns'] as $key => $column) {
if (strpos($column['columnname'], 'is_admin') !== false) {
$indexKey = $key;
$indexValue = $column['value'] == '0' ? 'off' : 'on';
} else {
if (strpos($column['columnname'], 'roleid') !== false) {
$roleKey = $key;
$db = PearDatabase::getInstance();
$sql = "SELECT `roleid`, `rolename` FROM `vtiger_role`;";
$result = $db->query($sql, true);
$roleNum = $db->num_rows($result);
if ($roleNum > 0) {
for ($i = 0; $i < $roleNum; $i++) {
$roleid = $db->query_result($result, $i, 'roleid');
$rolename = $db->query_result($result, $i, 'rolename');
$translated = vtranslate($rolename);
if ($translated == $column['value']) {
$roleValue = $roleid;
}
}
}
}
}
}
if ($indexValue !== '') {
$userFieldsFix[0]['columns'][$indexKey]['value'] = $indexValue;
}
if ($roleValue !== '') {
$userFieldsFix[0]['columns'][$roleKey]['value'] = $roleValue;
}
$this->set('search_params', $userFieldsFix);
return parent::getListViewEntries($pagingModel);
}
