_queryParams = &$queryParams; $this->_single = $single; $this->_limit = $limit; $this->_context = $context; $this->_compContext = $compContext; $this->_mailingClause = $mailingClause; // type of selector $this->_action = $action; $this->_query = new CRM_Contact_BAO_Query($this->_queryParams, CRM_Mailing_BAO_Query::defaultReturnProperties(CRM_Contact_BAO_Query::MODE_MAILING, FALSE ), NULL, FALSE, FALSE, CRM_Contact_BAO_Query::MODE_MAILING ); $this->_query->_distinctComponentClause = " civicrm_mailing_recipients.id "; } /** * This method returns the links that are given for each search row. * currently the links added for each row are * * - View * - Edit * * @return array */ public static function &links() { if (!(self::$_links)) { list($context, $key) = func_get_args(); $extraParams = ($key) ? "&key={$key}" : NULL; $searchContext = ($context) ? "&context=$context" : NULL; self::$_links = [ CRM_Core_Action::VIEW => [ 'name' => ts('View'), 'url' => 'civicrm/contact/view', 'qs' => "reset=1&cid=%%cid%%{$searchContext}{$extraParams}", 'title' => ts('View Contact Details'), ], CRM_Core_Action::UPDATE => [ 'name' => ts('Edit'), 'url' => 'civicrm/contact/add', 'qs' => "reset=1&action=update&cid=%%cid%%{$searchContext}{$extraParams}", 'title' => ts('Edit Contact Details'), ], CRM_Core_Action::DELETE => [ 'name' => ts('Delete'), 'url' => 'civicrm/contact/view/delete', 'qs' => "reset=1&delete=1&cid=%%cid%%{$searchContext}{$extraParams}", 'title' => ts('Delete Contact'), ], ]; } return self::$_links; } /** * Getter for array of the parameters required for creating pager. * * @param $action * @param array $params */ public function getPagerParams($action, &$params) { $params['status'] = ts('Mailing Recipient') . ' %%StatusMessage%%'; $params['csvString'] = NULL; if ($this->_limit) { $params['rowCount'] = $this->_limit; } else { $params['rowCount'] = CRM_Utils_Pager::ROWCOUNT; } $params['buttonTop'] = 'PagerTopButton'; $params['buttonBottom'] = 'PagerBottomButton'; } /** * Returns total number of rows for the query. * * @param string $action * * @return int * Total number of rows */ public function getTotalCount($action) { return $this->_query->searchQuery(0, 0, NULL, TRUE, FALSE, FALSE, FALSE, FALSE, $this->_mailingClause ); } /** * Returns all the rows in the given offset and rowCount. * * @param string $action * The action being performed. * @param int $offset * The row number to start from. * @param int $rowCount * The number of rows to return. * @param string $sort * The sql string that describes the sort order. * @param string $output * What should the result set include (web/email/csv). * * @return int * the total number of rows for this action */ public function &getRows($action, $offset, $rowCount, $sort, $output = NULL) { $result = $this->_query->searchQuery($offset, $rowCount, $sort, FALSE, FALSE, FALSE, FALSE, FALSE, $this->_mailingClause ); // process the result of the query $rows = []; $permissions = [CRM_Core_Permission::getPermission()]; if (CRM_Core_Permission::check('delete contacts')) { $permissions[] = CRM_Core_Permission::DELETE; } $mask = CRM_Core_Action::mask($permissions); $qfKey = $this->_key; while ($result->fetch()) { $row = []; // the columns we are interested in foreach (self::$_properties as $property) { if (property_exists($result, $property)) { $row[$property] = $result->$property; } } $row['checkbox'] = CRM_Core_Form::CB_PREFIX . $result->mailing_recipients_id; $actions = [ 'cid' => $result->contact_id, 'cxt' => $this->_context, ]; $row['action'] = CRM_Core_Action::formLink( self::links($qfKey, $this->_context), $mask, $actions, ts('more'), FALSE, 'contact.mailing.row', 'Contact', $result->contact_id ); $row['contact_type'] = CRM_Contact_BAO_Contact_Utils::getImage($result->contact_sub_type ? $result->contact_sub_type : $result->contact_type, FALSE, $result->contact_id ); $rows[] = $row; } return $rows; } /** * @inheritDoc */ public function getQILL() { return $this->_query->qill(); } /** * Returns the column headers as an array of tuples: * (name, sortName (key to the sort array)) * * @param string $action * The action being performed. * @param string $output * What should the result set include (web/email/csv). * * @return array * the column headers that need to be displayed */ public function &getColumnHeaders($action = NULL, $output = NULL) { if (!isset(self::$_columnHeaders)) { $isMultiLingual = CRM_Core_I18n::isMultiLingual(); $headers = [ ['desc' => ts('Contact Type')], [ 'name' => ts('Name'), 'sort' => 'sort_name', 'direction' => CRM_Utils_Sort::DONTCARE, ], [ 'name' => ts('Email'), 'sort' => 'email', 'direction' => CRM_Utils_Sort::DONTCARE, ], [ 'name' => ts('Mailing Name'), 'sort' => 'mailing_name', 'direction' => CRM_Utils_Sort::DONTCARE, ], ]; // Check to see if languages column should be displayed. if ($isMultiLingual) { $headers[] = [ 'name' => ts('Language'), 'sort' => 'language', 'direction' => CRM_Utils_Sort::DONTCARE, ]; } self::$_columnHeaders = array_merge($headers, [ [ 'name' => ts('Mailing Subject'), 'sort' => 'mailing_subject', 'direction' => CRM_Utils_Sort::DONTCARE, ], [ 'name' => ts('Mailing Status'), 'sort' => 'mailing_job_status', 'direction' => CRM_Utils_Sort::DONTCARE, ], [ 'name' => ts('Completed Date'), 'sort' => 'mailing_job_end_date', 'direction' => CRM_Utils_Sort::DONTCARE, ], ['desc' => ts('Actions')], ]); } return self::$_columnHeaders; } /** * @return mixed */ public function alphabetQuery() { return $this->_query->alphabetQuery(); } /** * @return string */ public function &getQuery() { return $this->_query; } /** * Name of export file. * * @param string $output * Type of output. * * @return string * name of the file */ public function getExportFileName($output = 'csv') { return ts('CiviCRM Mailing Search'); } }