copyValues($params); // lower case email field to optimize queries $strtolower = function_exists('mb_strtolower') ? 'mb_strtolower' : 'strtolower'; $email->email = $strtolower($email->email); /* * since we're setting bulkmail for 1 of this contact's emails, first reset all their other emails to is_bulkmail false * We shouldn't not set the current email to false even though we * are about to reset it to avoid contaminating the changelog if logging is enabled * (only 1 email address can have is_bulkmail = true) */ if ($email->is_bulkmail != 'null' && $params['contact_id'] && !self::isMultipleBulkMail()) { $sql = " UPDATE civicrm_email SET is_bulkmail = 0 WHERE contact_id = {$params['contact_id']} "; if ($hook == 'edit') { $sql .= " AND id <> {$params['id']}"; } CRM_Core_DAO::executeQuery($sql); } // handle if email is on hold self::holdEmail($email); $email->save(); if ($email->is_primary) { // update the UF user email if that has changed CRM_Core_BAO_UFMatch::updateUFName($email->contact_id); } CRM_Utils_Hook::post($hook, 'Email', $email->id, $email); return $email; } /** * Given the list of params in the params array, fetch the object * and store the values in the values array * * @param array $entityBlock * Input parameters to find object. * * @return boolean * @static */ public static function &getValues($entityBlock) { return CRM_Core_BAO_Block::getValues('email', $entityBlock); } /** * Get all the emails for a specified contact_id, with the primary email being first * * @param int $id * The contact id. * * @param bool $updateBlankLocInfo * * @return array the array of email id's * @static */ public static function allEmails($id, $updateBlankLocInfo = FALSE) { if (!$id) { return NULL; } $query = " SELECT email, civicrm_location_type.name as locationType, civicrm_email.is_primary as is_primary, civicrm_email.on_hold as on_hold, civicrm_email.id as email_id, civicrm_email.location_type_id as locationTypeId FROM civicrm_contact LEFT JOIN civicrm_email ON ( civicrm_email.contact_id = civicrm_contact.id ) LEFT JOIN civicrm_location_type ON ( civicrm_email.location_type_id = civicrm_location_type.id ) WHERE civicrm_contact.id = %1 ORDER BY civicrm_email.is_primary DESC, email_id ASC "; $params = array( 1 => array( $id, 'Integer', ), ); $emails = $values = array(); $dao = CRM_Core_DAO::executeQuery($query, $params); $count = 1; while ($dao->fetch()) { $values = array( 'locationType' => $dao->locationType, 'is_primary' => $dao->is_primary, 'on_hold' => $dao->on_hold, 'id' => $dao->email_id, 'email' => $dao->email, 'locationTypeId' => $dao->locationTypeId, ); if ($updateBlankLocInfo) { $emails[$count++] = $values; } else { $emails[$dao->email_id] = $values; } } return $emails; } /** * Get all the emails for a specified location_block id, with the primary email being first * * @param array $entityElements * The array containing entity_id and. * entity_table name * * @return array the array of email id's * @static */ public static function allEntityEmails(&$entityElements) { if (empty($entityElements)) { return NULL; } $entityId = $entityElements['entity_id']; $entityTable = $entityElements['entity_table']; $sql = " SELECT email, ltype.name as locationType, e.is_primary as is_primary, e.on_hold as on_hold,e.id as email_id, e.location_type_id as locationTypeId FROM civicrm_loc_block loc, civicrm_email e, civicrm_location_type ltype, {$entityTable} ev WHERE ev.id = %1 AND loc.id = ev.loc_block_id AND e.id IN (loc.email_id, loc.email_2_id) AND ltype.id = e.location_type_id ORDER BY e.is_primary DESC, email_id ASC "; $params = array( 1 => array( $entityId, 'Integer', ), ); $emails = array(); $dao = CRM_Core_DAO::executeQuery($sql, $params); while ($dao->fetch()) { $emails[$dao->email_id] = array( 'locationType' => $dao->locationType, 'is_primary' => $dao->is_primary, 'on_hold' => $dao->on_hold, 'id' => $dao->email_id, 'email' => $dao->email, 'locationTypeId' => $dao->locationTypeId, ); } return $emails; } /** * Set / reset hold status for an email * * @param object $email * Email object. * * @return void * @static */ public static function holdEmail(&$email) { //check for update mode if ($email->id) { $params = array(1 => array($email->id, 'Integer')); if ($email->on_hold && $email->on_hold != 'null') { $sql = " SELECT id FROM civicrm_email WHERE id = %1 AND hold_date IS NULL "; if (CRM_Core_DAO::singleValueQuery($sql, $params)) { $email->hold_date = date('YmdHis'); $email->reset_date = 'null'; } } elseif ($email->on_hold == 'null') { $sql = " SELECT id FROM civicrm_email WHERE id = %1 AND hold_date IS NOT NULL AND reset_date IS NULL "; if (CRM_Core_DAO::singleValueQuery($sql, $params)) { //set reset date only if it is not set and if hold date is set $email->on_hold = FALSE; $email->hold_date = 'null'; $email->reset_date = date('YmdHis'); } } } else { if (($email->on_hold != 'null') && $email->on_hold) { $email->hold_date = date('YmdHis'); } } } /** * Build From Email as the combination of all the email ids of the logged in user and * the domain email id * * @return array an array of email ids * @static */ public static function getFromEmail() { $session = CRM_Core_Session::singleton(); $contactID = $session->get('userID'); $fromEmailValues = array(); // add all configured FROM email addresses $domainFrom = CRM_Core_OptionGroup::values('from_email_address'); foreach (array_keys($domainFrom) as $k) { $domainEmail = $domainFrom[$k]; $fromEmailValues[$domainEmail] = htmlspecialchars($domainEmail); } // add logged in user's active email ids if ($contactID) { $contactEmails = self::allEmails($contactID); $fromDisplayName = CRM_Core_DAO::getFieldValue('CRM_Contact_DAO_Contact', $contactID, 'display_name'); foreach ($contactEmails as $emailId => $emailVal) { $email = trim($emailVal['email']); if (!$email || $emailVal['on_hold']) { continue; } $fromEmail = "$fromDisplayName <$email>"; $fromEmailHtml = htmlspecialchars($fromEmail) . ' ' . $emailVal['locationType']; if (!empty($emailVal['is_primary'])) { $fromEmailHtml .= ' ' . ts('(preferred)'); } $fromEmailValues[$fromEmail] = $fromEmailHtml; } } return $fromEmailValues; } /** * @return object */ public static function isMultipleBulkMail() { return CRM_Core_BAO_Setting::getItem(CRM_Core_BAO_Setting::MAILING_PREFERENCES_NAME, 'civimail_multiple_bulk_emails', NULL, FALSE); } /** * Call common delete function */ public static function del($id) { return CRM_Contact_BAO_Contact::deleteObjectWithPrimary('Email', $id); } }