3 +--------------------------------------------------------------------+
4 | CiviCRM version 4.6 |
5 +--------------------------------------------------------------------+
6 | Copyright CiviCRM LLC (c) 2004-2014 |
7 +--------------------------------------------------------------------+
8 | This file is a part of CiviCRM. |
10 | CiviCRM is free software; you can copy, modify, and distribute it |
11 | under the terms of the GNU Affero General Public License |
12 | Version 3, 19 November 2007 and the CiviCRM Licensing Exception. |
14 | CiviCRM is distributed in the hope that it will be useful, but |
15 | WITHOUT ANY WARRANTY; without even the implied warranty of |
16 | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. |
17 | See the GNU Affero General Public License for more details. |
19 | You should have received a copy of the GNU Affero General Public |
20 | License and the CiviCRM Licensing Exception along |
21 | with this program; if not, contact CiviCRM LLC |
22 | at info[AT]civicrm[DOT]org. If you have questions about the |
23 | GNU Affero General Public License or the licensing of CiviCRM, |
24 | see the CiviCRM license FAQ at http://civicrm.org/licensing |
25 +--------------------------------------------------------------------+
31 * @copyright CiviCRM LLC (c) 2004-2014
35 class CRM_Event_Page_ParticipantListing_NameStatusAndDate
extends CRM_Core_Page
{
39 protected $_participantListingID;
41 protected $_eventTitle;
45 function preProcess() {
46 $this->_id
= CRM_Utils_Request
::retrieve('id', 'Integer', $this, TRUE);
48 // ensure that there is a particpant type for this
49 $this->_participantListingID
= CRM_Core_DAO
::getFieldValue('CRM_Event_DAO_Event',
51 'participant_listing_id'
53 if (!$this->_participantListingID
) {
54 CRM_Core_Error
::fatal(ts("The Participant Listing feature is not currently enabled for this event."));
57 // retrieve Event Title and include it in page title
58 $this->_eventTitle
= CRM_Core_DAO
::getFieldValue('CRM_Event_DAO_Event',
62 CRM_Utils_System
::setTitle(ts('%1 - Participants', array(1 => $this->_eventTitle
)));
64 // we do not want to display recently viewed contacts since this is potentially a public page
65 $this->assign('displayRecent', FALSE);
76 INNER JOIN civicrm_participant ON civicrm_contact.id = civicrm_participant.contact_id
77 INNER JOIN civicrm_event ON civicrm_participant.event_id = civicrm_event.id
81 WHERE civicrm_event.id = %1";
83 $params = array(1 => array($this->_id
, 'Integer'));
84 $this->pager($fromClause, $whereClause, $params);
85 $orderBy = $this->orderBy();
87 list($offset, $rowCount) = $this->_pager
->getOffsetAndRowCount();
90 SELECT civicrm_contact.id as contact_id ,
91 civicrm_contact.display_name as name ,
92 civicrm_contact.sort_name as sort_name ,
93 civicrm_participant.id as participant_id,
94 civicrm_participant.status_id as status_id ,
95 civicrm_participant.register_date as register_date
99 LIMIT $offset, $rowCount";
102 $object = CRM_Core_DAO
::executeQuery($query, $params);
103 $statusLookup = CRM_Event_PseudoConstant
::participantStatus();
104 while ($object->fetch()) {
105 $status = CRM_Utils_Array
::value($object->status_id
, $statusLookup);
107 $status = ts($status);
110 'id' => $object->contact_id
,
111 'participantID' => $object->participant_id
,
112 'name' => $object->name
,
114 'date' => $object->register_date
,
118 $this->assign_by_ref('rows', $rows);
120 return parent
::run();
125 * @param $whereClause
126 * @param array $whereParams
128 function pager($fromClause, $whereClause, $whereParams) {
132 $params['status'] = ts('Group') . ' %%StatusMessage%%';
133 $params['csvString'] = NULL;
134 $params['buttonTop'] = 'PagerTopButton';
135 $params['buttonBottom'] = 'PagerBottomButton';
136 $params['rowCount'] = $this->get(CRM_Utils_Pager
::PAGE_ROWCOUNT
);
137 if (!$params['rowCount']) {
138 $params['rowCount'] = CRM_Utils_Pager
::ROWCOUNT
;
142 SELECT count( civicrm_contact.id )
146 $params['total'] = CRM_Core_DAO
::singleValueQuery($query, $whereParams);
147 $this->_pager
= new CRM_Utils_Pager($params);
148 $this->assign_by_ref('pager', $this->_pager
);
155 static $headers = NULL;
158 $headers[1] = array('name' => ts('Name'),
159 'sort' => 'civicrm_contact.sort_name',
160 'direction' => CRM_Utils_Sort
::ASCENDING
,
162 $headers[2] = array('name' => ts('Status'),
163 'sort' => 'civicrm_participant.status_id',
164 'direction' => CRM_Utils_Sort
::DONTCARE
,
166 $headers[3] = array('name' => ts('Register Date'),
167 'sort' => 'civicrm_participant.register_date',
168 'direction' => CRM_Utils_Sort
::DONTCARE
,
172 if ($this->get(CRM_Utils_Sort
::SORT_ID
)) {
173 $sortID = CRM_Utils_Sort
::sortIDValue($this->get(CRM_Utils_Sort
::SORT_ID
),
174 $this->get(CRM_Utils_Sort
::SORT_DIRECTION
)
177 $sort = new CRM_Utils_Sort($headers, $sortID);
178 $this->assign_by_ref('headers', $headers);
179 $this->assign_by_ref('sort', $sort);
180 $this->set(CRM_Utils_Sort
::SORT_ID
,
181 $sort->getCurrentSortID()
183 $this->set(CRM_Utils_Sort
::SORT_DIRECTION
,
184 $sort->getCurrentSortDirection()
187 return $sort->orderBy();