/**
* where / qill clause for task / task status
*
* @return void
* @access public
*/
function task(&$values)
{
list($name, $op, $value, $grouping, $wildcard) = $values;
$targetName = $this->getWhereValues('task_id', $grouping);
if (!$targetName) {
return;
}
$taskID = CRM_Utils_Type::escape($targetName[2], 'Integer');
$clause = "civicrm_task_status.task_id = {$taskID} ";
$statusID = NULL;
if ($value) {
$statusID = CRM_Utils_Type::escape($value, 'Integer');
$clause .= " AND civicrm_task_status.status_id = {$statusID}";
}
$this->_where[$grouping][] = "civicrm_task_status.task_id = {$taskID} AND civicrm_task_status.status_id = {$statusID}";
$this->_tables['civicrm_task_status'] = $this->_whereTables['civicrm_task_status'] = 1;
$taskSelect = CRM_Core_PseudoConstant::tasks();
$this->_qill[$grouping][] = ts('Task') . ": {$taskSelect[$taskID]}";
if ($statusID) {
$statusSelect = CRM_Core_OptionGroup::values('task_status');
$this->_qill[$grouping][] = ts('Task Status') . ": {$statusSelect[$statusID]}";
}
}
static function task(&$form)
{
$form->add('hidden', 'hidden_task', 1);
if (CRM_Core_Permission::access('Quest')) {
$form->assign('showTask', 1);
// add the task search stuff
// we add 2 select boxes, one for the task from the task table
$taskSelect = array('' => '- select -') + CRM_Core_PseudoConstant::tasks();
$form->addElement('select', 'task_id', ts('Task'), $taskSelect);
$form->addSelect('task_status', ts('Task Status'));
}
}
