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_BAO_Contact_Location
{
38 * Get the display name, primary email, location type and location id of a contact
43 * @param bool $isPrimary
44 * @param int $locationTypeID
46 * @return array of display_name, email, location type and location id if found, or (null,null,null, null)
49 public static function getEmailDetails($id, $isPrimary = TRUE, $locationTypeID = NULL) {
50 $primaryClause = NULL;
52 $primaryClause = " AND civicrm_email.is_primary = 1";
56 $locationClause = NULL;
57 if ($locationTypeID) {
58 $locationClause = " AND civicrm_email.location_type_id = $locationTypeID";
62 SELECT civicrm_contact.display_name,
64 civicrm_email.location_type_id,
67 LEFT JOIN civicrm_email ON ( civicrm_contact.id = civicrm_email.contact_id {$primaryClause} {$locationClause} )
68 WHERE civicrm_contact.id = %1";
70 $params = array(1 => array($id, 'Integer'));
71 $dao = CRM_Core_DAO
::executeQuery($sql, $params);
73 return array($dao->display_name
, $dao->email
, $dao->location_type_id
, $dao->id
);
75 return array(NULL, NULL, NULL, NULL);
79 * Get the sms number and display name of a contact
86 * @return array tuple of display_name and sms if found, or (null,null)
89 public static function getPhoneDetails($id, $type = NULL) {
91 return array(NULL, NULL);
96 $cond = " AND civicrm_phone.phone_type_id = '$type'";
101 SELECT civicrm_contact.display_name, civicrm_phone.phone, civicrm_contact.do_not_sms
103 LEFT JOIN civicrm_phone ON ( civicrm_phone.contact_id = civicrm_contact.id )
104 WHERE civicrm_phone.is_primary = 1
106 AND civicrm_contact.id = %1";
108 $params = array(1 => array($id, 'Integer'));
109 $dao = CRM_Core_DAO
::executeQuery($sql, $params);
111 return array($dao->display_name
, $dao->phone
, $dao->do_not_sms
);
113 return array(NULL, NULL, NULL);
117 * Get the information to map a contact
120 * The list of ids for which we want map info.
121 * $param int $locationTypeID
123 * @param int $locationTypeID
124 * @param bool $imageUrlOnly
126 * @return null|string display name of the contact if found
129 public static function &getMapInfo($ids, $locationTypeID = NULL, $imageUrlOnly = FALSE) {
130 $idString = ' ( ' . implode(',', $ids) . ' ) ';
132 SELECT civicrm_contact.id as contact_id,
133 civicrm_contact.contact_type as contact_type,
134 civicrm_contact.contact_sub_type as contact_sub_type,
135 civicrm_contact.display_name as display_name,
136 civicrm_address.street_address as street_address,
137 civicrm_address.supplemental_address_1 as supplemental_address_1,
138 civicrm_address.supplemental_address_2 as supplemental_address_2,
139 civicrm_address.city as city,
140 civicrm_address.postal_code as postal_code,
141 civicrm_address.postal_code_suffix as postal_code_suffix,
142 civicrm_address.geo_code_1 as latitude,
143 civicrm_address.geo_code_2 as longitude,
144 civicrm_state_province.abbreviation as state,
145 civicrm_country.name as country,
146 civicrm_location_type.name as location_type
148 LEFT JOIN civicrm_address ON civicrm_address.contact_id = civicrm_contact.id
149 LEFT JOIN civicrm_state_province ON civicrm_address.state_province_id = civicrm_state_province.id
150 LEFT JOIN civicrm_country ON civicrm_address.country_id = civicrm_country.id
151 LEFT JOIN civicrm_location_type ON civicrm_location_type.id = civicrm_address.location_type_id
152 WHERE civicrm_address.geo_code_1 IS NOT NULL
153 AND civicrm_address.geo_code_2 IS NOT NULL
154 AND civicrm_contact.id IN $idString ";
157 if (!$locationTypeID) {
158 $sql .= " AND civicrm_address.is_primary = 1";
161 $sql .= " AND civicrm_address.location_type_id = %1";
162 $params[1] = array($locationTypeID, 'Integer');
165 $dao = CRM_Core_DAO
::executeQuery($sql, $params);
167 $locations = array();
168 $config = CRM_Core_Config
::singleton();
170 while ($dao->fetch()) {
172 $location['contactID'] = $dao->contact_id
;
173 $location['displayName'] = addslashes($dao->display_name
);
174 $location['city'] = $dao->city
;
175 $location['state'] = $dao->state
;
176 $location['postal_code'] = $dao->postal_code
;
177 $location['lat'] = $dao->latitude
;
178 $location['lng'] = $dao->longitude
;
179 $location['marker_class'] = $dao->contact_type
;
182 CRM_Utils_String
::append($address, '<br />',
184 $dao->street_address
,
185 $dao->supplemental_address_1
,
186 $dao->supplemental_address_2
,
190 CRM_Utils_String
::append($address, ', ',
191 array($dao->state
, $dao->postal_code
)
193 CRM_Utils_String
::append($address, '<br /> ',
196 $location['address'] = addslashes($address);
197 $location['displayAddress'] = str_replace('<br />', ', ', addslashes($address));
198 $location['url'] = CRM_Utils_System
::url('civicrm/contact/view', 'reset=1&cid=' . $dao->contact_id
);
199 $location['location_type'] = $dao->location_type
;
200 $location['image'] = CRM_Contact_BAO_Contact_Utils
::getImage(isset($dao->contact_sub_type
) ?
201 $dao->contact_sub_type
: $dao->contact_type
, $imageUrlOnly, $dao->contact_id
203 $locations[] = $location;