7f26b7307ab722bd21e4f9f196f38e55b6d7211b
3 +--------------------------------------------------------------------+
4 | CiviCRM version 4.5 |
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
37 * Class contains functions for phone
39 class CRM_Core_BAO_Phone
extends CRM_Core_DAO_Phone
{
42 * Create phone object - note that the create function calls 'add' but
43 * has more business logic
45 * @param array $params input parameters
48 * @param array $params
51 * @throws API_Exception
53 static function create($params) {
54 // Ensure mysql phone function exists
55 CRM_Core_DAO
::checkSqlFunctionsExist();
57 if (is_numeric(CRM_Utils_Array
::value('is_primary', $params)) ||
58 // if id is set & is_primary isn't we can assume no change
61 CRM_Core_BAO_Block
::handlePrimary($params, get_class());
63 $phone = self
::add($params);
69 * takes an associative array and adds phone
71 * @param array $params (reference ) an assoc array of name/value pairs
73 * @return object CRM_Core_BAO_Phone object on success, null otherwise
77 static function add(&$params) {
78 // Ensure mysql phone function exists
79 CRM_Core_DAO
::checkSqlFunctionsExist();
81 $hook = empty($params['id']) ?
'create' : 'edit';
82 CRM_Utils_Hook
::pre($hook, 'Phone', CRM_Utils_Array
::value('id', $params), $params);
84 $phone = new CRM_Core_DAO_Phone();
85 $phone->copyValues($params);
88 CRM_Utils_Hook
::post($hook, 'Phone', $phone->id
, $phone);
93 * Given the list of params in the params array, fetch the object
94 * and store the values in the values array
96 * @param array entityBlock input parameters to find object
98 * @return array array of phone objects
102 static function &getValues($entityBlock) {
103 $getValues = CRM_Core_BAO_Block
::getValues('phone', $entityBlock);
108 * Get all the phone numbers for a specified contact_id, with the primary being first
110 * @param int $id the contact id
112 * @param bool $updateBlankLocInfo
114 * @param array $filters
116 * @return array the array of phone ids which are potential numbers
120 static function allPhones($id, $updateBlankLocInfo = FALSE, $type = NULL, $filters = array()) {
127 $phoneTypeId = array_search($type, CRM_Core_PseudoConstant
::get('CRM_Core_DAO_Phone', 'phone_type_id'));
129 $cond = " AND civicrm_phone.phone_type_id = $phoneTypeId";
133 if (!empty($filters) && is_array($filters)) {
134 foreach ($filters as $key => $value) {
135 $cond .= " AND " . $key . " = " . $value;
140 SELECT phone, civicrm_location_type.name as locationType, civicrm_phone.is_primary as is_primary,
141 civicrm_phone.id as phone_id, civicrm_phone.location_type_id as locationTypeId,
142 civicrm_phone.phone_type_id as phoneTypeId
144 LEFT JOIN civicrm_phone ON ( civicrm_contact.id = civicrm_phone.contact_id )
145 LEFT JOIN civicrm_location_type ON ( civicrm_phone.location_type_id = civicrm_location_type.id )
146 WHERE civicrm_contact.id = %1 $cond
147 ORDER BY civicrm_phone.is_primary DESC, phone_id ASC ";
157 $numbers = $values = array();
158 $dao = CRM_Core_DAO
::executeQuery($query, $params);
160 while ($dao->fetch()) {
162 'locationType' => $dao->locationType
,
163 'is_primary' => $dao->is_primary
,
164 'id' => $dao->phone_id
,
165 'phone' => $dao->phone
,
166 'locationTypeId' => $dao->locationTypeId
,
167 'phoneTypeId' => $dao->phoneTypeId
,
170 if ($updateBlankLocInfo) {
171 $numbers[$count++
] = $values;
174 $numbers[$dao->phone_id
] = $values;
181 * Get all the phone numbers for a specified location_block id, with the primary phone being first
183 * @param array $entityElements the array containing entity_id and
188 * @return array the array of phone ids which are potential numbers
192 static function allEntityPhones($entityElements, $type = NULL) {
193 if (empty($entityElements)) {
199 $phoneTypeId = array_search($type, CRM_Core_PseudoConstant
::get('CRM_Core_DAO_Phone', 'phone_type_id'));
201 $cond = " AND civicrm_phone.phone_type_id = $phoneTypeId";
205 $entityId = $entityElements['entity_id'];
206 $entityTable = $entityElements['entity_table'];
208 $sql = " SELECT phone, ltype.name as locationType, ph.is_primary as is_primary,
209 ph.id as phone_id, ph.location_type_id as locationTypeId
210 FROM civicrm_loc_block loc, civicrm_phone ph, civicrm_location_type ltype, {$entityTable} ev
212 AND loc.id = ev.loc_block_id
213 AND ph.id IN (loc.phone_id, loc.phone_2_id)
214 AND ltype.id = ph.location_type_id
215 ORDER BY ph.is_primary DESC, phone_id ASC ";
224 $dao = CRM_Core_DAO
::executeQuery($sql, $params);
225 while ($dao->fetch()) {
226 $numbers[$dao->phone_id
] = array(
227 'locationType' => $dao->locationType
,
228 'is_primary' => $dao->is_primary
,
229 'id' => $dao->phone_id
,
230 'phone' => $dao->phone
,
231 'locationTypeId' => $dao->locationTypeId
,
238 * Set NULL to phone, mapping, uffield
240 * @param $optionId value of option to be deleted
245 static function setOptionToNull($optionId) {
249 // Ensure mysql phone function exists
250 CRM_Core_DAO
::checkSqlFunctionsExist();
254 'civicrm_mapping_field',
264 foreach ($tables as $tableName) {
265 $query = "UPDATE `{$tableName}` SET `phone_type_id` = NULL WHERE `phone_type_id` = %1";
266 CRM_Core_DAO
::executeQuery($query, $params);
271 * Call common delete function
273 static function del($id) {
274 // Ensure mysql phone function exists
275 CRM_Core_DAO
::checkSqlFunctionsExist();
276 return CRM_Contact_BAO_Contact
::deleteObjectWithPrimary('Phone', $id);