/** * 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')); } }