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_Contact_Form_Search_Custom_PostalMailing
extends CRM_Contact_Form_Search_Custom_Base
implements CRM_Contact_Form_Search_Interface
{
39 public function __construct(&$formValues) {
40 parent
::__construct($formValues);
42 $this->_columns
= array(
43 ts('Contact ID') => 'contact_id',
44 ts('Address') => 'address',
45 ts('Contact Type') => 'contact_type',
46 ts('Name') => 'sort_name',
47 ts('State') => 'state_province',
52 * @param CRM_Core_Form $form
54 public function buildForm(&$form) {
55 $groups = array('' => ts('- select group -')) + CRM_Core_PseudoConstant
::nestedGroup(FALSE);
56 $form->addElement('select', 'group_id', ts('Group'), $groups, array('class' => 'crm-select2 huge'));
59 * if you are using the standard template, this array tells the template what elements
60 * are part of the search criteria
62 $form->assign('elements', array('group_id'));
65 public function contactIDs($offset = 0, $rowcount = 0, $sort = NULL, $returnSQL = FALSE) {
66 return $this->all($offset, $rowcount, $sort, FALSE, TRUE);
71 * @param int $rowcount
73 * @param bool $includeContactIDs
74 * @param bool $justIDs
79 $offset = 0, $rowcount = 0, $sort = NULL,
80 $includeContactIDs = FALSE, $justIDs = FALSE
83 $selectClause = "contact_a.id as contact_id";
84 $sort = 'contact_a.id';
88 DISTINCT contact_a.id as contact_id ,
89 contact_a.contact_type as contact_type,
90 contact_a.sort_name as sort_name,
91 address.street_address as address,
92 state_province.name as state_province
96 return $this->sql($selectClause,
97 $offset, $rowcount, $sort,
98 $includeContactIDs, NULL
105 public function from() {
107 FROM civicrm_group_contact as cgc,
108 civicrm_contact as contact_a
109 LEFT JOIN civicrm_address address ON (address.contact_id = contact_a.id AND
110 address.is_primary = 1 )
111 LEFT JOIN civicrm_state_province state_province ON state_province.id = address.state_province_id
116 * @param bool $includeContactIDs
120 public function where($includeContactIDs = FALSE) {
125 $groupID = CRM_Utils_Array
::value('group_id',
129 $params[$count] = array($groupID, 'Integer');
130 $clause[] = "cgc.group_id = %{$count}";
133 $clause[] = "cgc.status = 'Added'";
134 $clause[] = "contact_a.id = IF( EXISTS(select cr.id from civicrm_relationship cr where (cr.contact_id_a = cgc.contact_id AND (cr.relationship_type_id = 7 OR cr.relationship_type_id = 6))),
135 (select cr.contact_id_b from civicrm_relationship cr where (cr.contact_id_a = cgc.contact_id AND (cr.relationship_type_id = 7 OR cr.relationship_type_id = 6))),
137 $clause[] = "contact_a.contact_type IN ('Individual','Household')";
139 if (!empty($clause)) {
140 $where = implode(' AND ', $clause);
143 return $this->whereClause($where, $params);
149 public function templateFile() {
150 return 'CRM/Contact/Form/Search/Custom.tpl';