- 25 May 2014, 08:56
#1721
"RUSS I was expecting a response from you"
Alright i got it figured out you have to make changes in
CATSROOT/module/activiry/datagrid.php make changes as follows:
$this->_classColumns = array(
'Date' => array('pagerRender' => 'return $rsData[\'dateCreated\'];',
'sortableColumn' => 'dateCreatedSort',
'pagerWidth' => 110,
'pagerOptional' => true,
'alphaNavigation'=> true,
'filter' => 'activity.date_created'),
'First Name' => array('pagerRender' => 'if ($rsData[\'dataItemType\']=='.DATA_ITEM_CANDIDATE.') {$ret = \'<img src="images/mru/candidate.gif" height="12" alt="" />\';} else if ($rsData[\'dataItemType\']=='.DATA_ITEM_CONTACT.') {$ret = \'<img src="images/mru/contact.gif" height="12">\';} else {$ret = \'<img src="images/mru/blank.gif">\';} if ($rsData[\'isHot\'] == 1) $className = \'jobLinkHot\'; else $className = \'jobLinkCold\'; if ($rsData[\'dataItemType\']=='.DATA_ITEM_CANDIDATE.') {return $ret.\' <a href="'.CATSUtility::getIndexName().'?m=candidates&a=show&candidateID=\'.$rsData[\'dataItemID\'].\'" class="\'.$className.\'" title="\'.htmlspecialchars(InfoString::make($rsData[\'dataItemType\'],$rsData[\'dataItemID\'],$rsData[\'siteID\'])).\'">\'.htmlspecialchars($rsData[\'firstName\']).\'</a>\';} else {return $ret.\' <a href="'.CATSUtility::getIndexName().'?m=contacts&a=show&contactID=\'.$rsData[\'dataItemID\'].\'" class="\'.$className.\'" title="\'.htmlspecialchars(InfoString::make($rsData[\'dataItemType\'],$rsData[\'dataItemID\'],$rsData[\'siteID\'])).\'">\'.htmlspecialchars($rsData[\'firstName\']).\'</a>\';}',
'sortableColumn' => 'firstName',
'pagerWidth' => 85,
'pagerOptional' => false,
'alphaNavigation' => true,
'filterable' => false,
'filterHaving' => 'firstName'),
'Last Name' => array('pagerRender' => 'if ($rsData[\'isHot\'] == 1) $className = \'jobLinkHot\'; else $className = \'jobLinkCold\'; if ($rsData[\'dataItemType\']=='.DATA_ITEM_CANDIDATE.') {return \'<a href="'.CATSUtility::getIndexName().'?m=candidates&a=show&candidateID=\'.$rsData[\'dataItemID\'].\'" class="\'.$className.\'" title="\'.htmlspecialchars(InfoString::make($rsData[\'dataItemType\'],$rsData[\'dataItemID\'],$rsData[\'siteID\'])).\'"> \'.htmlspecialchars($rsData[\'lastName\']).\'</a>\';} else {return \'<a href="'.CATSUtility::getIndexName().'?m=contacts&a=show&contactID=\'.$rsData[\'dataItemID\'].\'" class="\'.$className.\'" title="\'.htmlspecialchars(InfoString::make($rsData[\'dataItemType\'],$rsData[\'dataItemID\'],$rsData[\'siteID\'])).\'"> \'.htmlspecialchars($rsData[\'lastName\']).\'</a>\';}',
'sortableColumn' => 'lastName',
'pagerWidth' => 75,
'pagerOptional' => false,
'alphaNavigation' => true,
'filterable' => false,
'filterHaving' => 'lastName'),
'Regarding' => array('pagerRender' => 'if ($rsData[\'jobIsHot\'] == 1) $className = \'jobLinkHot\'; else $className = \'jobLinkCold\'; if ($rsData[\'companyIsHot\'] == 1) $companyClassName = \'jobLinkHot\'; else $companyClassName = \'jobLinkCold\'; if ($rsData[\'regardingJobTitle\'] == \'\') {$ret = \'General\'; } else {$ret = \'<a href="'.CATSUtility::getIndexName().'?m=joborders&a=show&jobOrderID=\'.$rsData[\'jobOrderID\'].\'" class="\'.$className.\'">\'.htmlspecialchars($rsData[\'regardingJobTitle\']).\'</a>\'; if($rsData[\'regardingCompanyName\'] != \'\') {$ret .= \' <a href="'.CATSUtility::getIndexName().'?m=companies&a=show&companyID=\'.$rsData[\'companyID\'].\'" class="\'.$companyClassName.\'">(\'.htmlspecialchars($rsData[\'regardingCompanyName\']).\')\';}} return $ret;',
'sortableColumn' => 'regarding',
'pagerWidth' => 125,
'pagerOptional' => true,
'alphaNavigation' => true,
'filter' => 'CONCAT(joborder.title, company.name)'),
'Activity' => array('pagerRender' => '$ret = $rsData[\'typeDescription\']; return $ret;',
'sortableColumn' => 'typeDescription',
'pagerWidth' => 65,
'pagerOptional' => true,
'alphaNavigation' => true,
'filter' => 'activity_type.short_description'),
'Notes' => array('pagerRender' => 'return $rsData[\'notes\'];',
'sortableColumn' => 'notes',
'pagerWidth' => 240,
'pagerOptional' => true,
'alphaNavigation' => true,
'filter' => 'activity.notes'),
'Entered By' => array(
'pagerRender' => 'return StringUtility::makeInitialName($rsData[\'enteredByFirstName\'], $rsData[\'enteredByLastName\'], false, LAST_NAME_MAXLEN);',
'exportRender' => 'return $rsData[\'enteredByFirstName\'] . " " .$rsData[\'enteredByLastName\'];',
'sortableColumn' => 'enteredBySort',
'pagerWidth' => 60,
'alphaNavigation' => true,
'filter' => 'CONCAT(entered_by_user.last_name, entered_by_user.first_name)'),
);
Note the new words in "filter".
As for exporting add the following line:
/**
* Adds more options to the action area on the pager. Overloads
* DataGrid Inner Action Area function.
*
* @return html innerActionArea commands.
*/
public function getInnerActionArea()
{
$html = '';
$html .= $this->getInnerActionAreaItem('Export', CATSUtility::getIndexName().'?m=export&a=exportByDataGrid');
$html .= parent::getInnerActionArea();
return $html;
this will enable export option.