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
47 * 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";
55 $locationClause = NULL;
56 if ($locationTypeID) {
57 $locationClause = " AND civicrm_email.location_type_id = $locationTypeID";
61 SELECT civicrm_contact.display_name,
63 civicrm_email.location_type_id,
66 LEFT JOIN civicrm_email ON ( civicrm_contact.id = civicrm_email.contact_id {$primaryClause} {$locationClause} )
67 WHERE civicrm_contact.id = %1";
69 $params = array(1 => array($id, 'Integer'));
70 $dao = CRM_Core_DAO
::executeQuery($sql, $params);
72 return array($dao->display_name
, $dao->email
, $dao->location_type_id
, $dao->id
);
74 return array(NULL, NULL, NULL, NULL);
78 * Get the sms number and display name of a contact
86 * tuple of display_name and sms if found, or (null,null)
88 public static function getPhoneDetails($id, $type = NULL) {
90 return array(NULL, NULL);
95 $cond = " AND civicrm_phone.phone_type_id = '$type'";
99 SELECT civicrm_contact.display_name, civicrm_phone.phone, civicrm_contact.do_not_sms
101 LEFT JOIN civicrm_phone ON ( civicrm_phone.contact_id = civicrm_contact.id )
102 WHERE civicrm_phone.is_primary = 1
104 AND civicrm_contact.id = %1";
106 $params = array(1 => array($id, 'Integer'));
107 $dao = CRM_Core_DAO
::executeQuery($sql, $params);
109 return array($dao->display_name
, $dao->phone
, $dao->do_not_sms
);
111 return array(NULL, NULL, NULL);
115 * Get the information to map a contact
118 * The list of ids for which we want map info.
119 * $param int $locationTypeID
121 * @param int $locationTypeID
122 * @param bool $imageUrlOnly
124 * @return null|string
125 * display name of the contact if found
127 public static function &getMapInfo($ids, $locationTypeID = NULL, $imageUrlOnly = FALSE) {
128 $idString = ' ( ' . implode(',', $ids) . ' ) ';
130 SELECT civicrm_contact.id as contact_id,
131 civicrm_contact.contact_type as contact_type,
132 civicrm_contact.contact_sub_type as contact_sub_type,
133 civicrm_contact.display_name as display_name,
134 civicrm_address.street_address as street_address,
135 civicrm_address.supplemental_address_1 as supplemental_address_1,
136 civicrm_address.supplemental_address_2 as supplemental_address_2,
137 civicrm_address.city as city,
138 civicrm_address.postal_code as postal_code,
139 civicrm_address.postal_code_suffix as postal_code_suffix,
140 civicrm_address.geo_code_1 as latitude,
141 civicrm_address.geo_code_2 as longitude,
142 civicrm_state_province.abbreviation as state,
143 civicrm_country.name as country,
144 civicrm_location_type.name as location_type
146 LEFT JOIN civicrm_address ON civicrm_address.contact_id = civicrm_contact.id
147 LEFT JOIN civicrm_state_province ON civicrm_address.state_province_id = civicrm_state_province.id
148 LEFT JOIN civicrm_country ON civicrm_address.country_id = civicrm_country.id
149 LEFT JOIN civicrm_location_type ON civicrm_location_type.id = civicrm_address.location_type_id
150 WHERE civicrm_address.geo_code_1 IS NOT NULL
151 AND civicrm_address.geo_code_2 IS NOT NULL
152 AND civicrm_contact.id IN $idString ";
155 if (!$locationTypeID) {
156 $sql .= " AND civicrm_address.is_primary = 1";
159 $sql .= " AND civicrm_address.location_type_id = %1";
160 $params[1] = array($locationTypeID, 'Integer');
163 $dao = CRM_Core_DAO
::executeQuery($sql, $params);
165 $locations = array();
166 $config = CRM_Core_Config
::singleton();
168 while ($dao->fetch()) {
170 $location['contactID'] = $dao->contact_id
;
171 $location['displayName'] = addslashes($dao->display_name
);
172 $location['city'] = $dao->city
;
173 $location['state'] = $dao->state
;
174 $location['postal_code'] = $dao->postal_code
;
175 $location['lat'] = $dao->latitude
;
176 $location['lng'] = $dao->longitude
;
177 $location['marker_class'] = $dao->contact_type
;
180 CRM_Utils_String
::append($address, '<br />',
182 $dao->street_address
,
183 $dao->supplemental_address_1
,
184 $dao->supplemental_address_2
,
188 CRM_Utils_String
::append($address, ', ',
189 array($dao->state
, $dao->postal_code
)
191 CRM_Utils_String
::append($address, '<br /> ',
194 $location['address'] = addslashes($address);
195 $location['displayAddress'] = str_replace('<br />', ', ', addslashes($address));
196 $location['url'] = CRM_Utils_System
::url('civicrm/contact/view', 'reset=1&cid=' . $dao->contact_id
);
197 $location['location_type'] = $dao->location_type
;
198 $location['image'] = CRM_Contact_BAO_Contact_Utils
::getImage(isset($dao->contact_sub_type
) ?
$dao->contact_sub_type
: $dao->contact_type
, $imageUrlOnly, $dao->contact_id
200 $locations[] = $location;