CRM/Contact/Form/Task/LabelCommon.php

   1 <?php
   2 /*
   3  +--------------------------------------------------------------------+
   4  | Copyright CiviCRM LLC. All rights reserved.                        |
   5  |                                                                    |
   6  | This work is published under the GNU AGPLv3 license with some      |
   7  | permitted exceptions and without any warranty. For full license    |
   8  | and copyright information, see https://civicrm.org/licensing       |
   9  +--------------------------------------------------------------------+
  10  */
  11
  12 /**
  13  *
  14  * @package CRM
  15  * @copyright CiviCRM LLC https://civicrm.org/licensing
  16  */
  17
  18 /**
  19  * This class provides the common functionality for sending email to one or a group of contact ids.
  20  */
  21 class CRM_Contact_Form_Task_LabelCommon {
  22
  23   /**
  24    * Create labels (pdf).
  25    *
  26    * @param array $contactRows
  27    *   Associated array of contact data.
  28    * @param string $format
  29    *   Format in which labels needs to be printed.
  30    * @param string $fileName
  31    *   The name of the file to save the label in.
  32    */
  33   public static function createLabel(&$contactRows, &$format, $fileName = 'MailingLabels_CiviCRM.pdf') {
  34     $pdf = new CRM_Utils_PDF_Label($format, 'mm');
  35     $pdf->Open();
  36     $pdf->AddPage();
  37
  38     //build contact string that needs to be printed
  39     $val = NULL;
  40     foreach ((array) $contactRows as $row => $value) {
  41       foreach ($value as $k => $v) {
  42         $val .= "$v\n";
  43       }
  44
  45       $pdf->AddPdfLabel($val);
  46       $val = '';
  47     }
  48     $pdf->Output($fileName, 'D');
  49   }
  50
  51   /**
  52    * Get the rows for the labels.
  53    *
  54    * @param $contactIDs
  55    * @param int $locationTypeID
  56    * @param bool $respectDoNotMail
  57    * @param $mergeSameAddress
  58    * @param bool $mergeSameHousehold
  59    *   UNUSED.
  60    *
  61    * @return array
  62    *   Array of rows for labels
  63    */
  64   public static function getRows($contactIDs, $locationTypeID, $respectDoNotMail, $mergeSameAddress, $mergeSameHousehold) {
  65     $locName = NULL;
  66     $rows = [];
  67     //get the address format sequence from the config file
  68     $addressReturnProperties = CRM_Contact_Form_Task_LabelCommon::getAddressReturnProperties();
  69
  70     //build the return properties
  71     $returnProperties = ['display_name' => 1, 'contact_type' => 1, 'prefix_id' => 1];
  72     $mailingFormat = Civi::settings()->get('mailing_format');
  73
  74     $mailingFormatProperties = [];
  75     if ($mailingFormat) {
  76       $mailingFormatProperties = CRM_Utils_Token::getReturnProperties($mailingFormat);
  77       $returnProperties = array_merge($returnProperties, $mailingFormatProperties);
  78     }
  79
  80     $customFormatProperties = [];
  81     if (stristr($mailingFormat, 'custom_')) {
  82       foreach ($mailingFormatProperties as $token => $true) {
  83         if (substr($token, 0, 7) == 'custom_') {
  84           if (empty($customFormatProperties[$token])) {
  85             $customFormatProperties[$token] = $mailingFormatProperties[$token];
  86           }
  87         }
  88       }
  89     }
  90     $returnProperties = array_merge($returnProperties, $customFormatProperties);
  91
  92     if ($mergeSameAddress) {
  93       // we need first name/last name for summarising to avoid spillage
  94       $returnProperties['first_name'] = 1;
  95       $returnProperties['last_name'] = 1;
  96     }
  97
  98     //get the contacts information
  99     $params = $custom = [];
 100     foreach ($contactIDs as $key => $contactID) {
 101       $params[] = [
 102         CRM_Core_Form::CB_PREFIX . $contactID,
 103         '=',
 104         1,
 105         0,
 106         0,
 107       ];
 108     }
 109
 110     // fix for CRM-2651
 111     if (!empty($respectDoNotMail['do_not_mail'])) {
 112       $params[] = ['do_not_mail', '=', 0, 0, 0];
 113     }
 114     // fix for CRM-2613
 115     $params[] = ['is_deceased', '=', 0, 0, 0];
 116
 117     if ($locationTypeID) {
 118       $locType = CRM_Core_PseudoConstant::get('CRM_Core_DAO_Address', 'location_type_id');
 119       $locName = $locType[$locationTypeID];
 120       $location = ['location' => ["{$locName}" => $addressReturnProperties]];
 121       $returnProperties = array_merge($returnProperties, $location);
 122       $params[] = ['location_type', '=', [$locationTypeID => 1], 0, 0];
 123     }
 124     else {
 125       $returnProperties = array_merge($returnProperties, $addressReturnProperties);
 126     }
 127
 128     foreach ($returnProperties as $name) {
 129       $cfID = CRM_Core_BAO_CustomField::getKeyID($name);
 130       if ($cfID) {
 131         $custom[] = $cfID;
 132       }
 133     }
 134
 135     //get the total number of contacts to fetch from database.
 136     $numberofContacts = count($contactIDs);
 137     //this does the same as calling civicrm_api3('contact, get, array('id' => array('IN' => $this->_contactIds)
 138     // except it also handles multiple locations
 139     $query = new CRM_Contact_BAO_Query($params, $returnProperties);
 140     $details = $query->apiQuery($params, $returnProperties, NULL, NULL, 0, $numberofContacts);
 141
 142     $messageToken = CRM_Utils_Token::getTokens($mailingFormat);
 143     // $details[0] is an array of [ contactID => contactDetails ]
 144     $details = $details[0];
 145     $tokenFields = CRM_Contact_Form_Task_LabelCommon::getTokenData($details);
 146
 147     foreach ($contactIDs as $value) {
 148       foreach ($custom as $cfID) {
 149         if (isset($details[$value]["custom_{$cfID}"])) {
 150           $details[$value]["custom_{$cfID}"] = CRM_Core_BAO_CustomField::displayValue($details[$value]["custom_{$cfID}"], $cfID);
 151         }
 152       }
 153       $contact = $details[$value] ?? NULL;
 154
 155       if (is_a($contact, 'CRM_Core_Error')) {
 156         return NULL;
 157       }
 158
 159       // we need to remove all the "_id"
 160       unset($contact['contact_id']);
 161
 162       if ($locName && !empty($contact[$locName])) {
 163         // If location type is not primary, $contact contains
 164         // one more array as "$contact[$locName] = array( values... )"
 165
 166         if (!CRM_Contact_Form_Task_Label::tokenIsFound($contact, $mailingFormatProperties, $tokenFields)) {
 167           continue;
 168         }
 169
 170         unset($contact[$locName]);
 171
 172         if (!empty($contact['county_id'])) {
 173           unset($contact['county_id']);
 174         }
 175
 176         foreach ($contact as $field => $fieldValue) {
 177           $rows[$value][$field] = $fieldValue;
 178         }
 179
 180         $valuesothers = [];
 181         $paramsothers = ['contact_id' => $value];
 182         $valuesothers = CRM_Core_BAO_Location::getValues($paramsothers, $valuesothers);
 183         if ($locationTypeID) {
 184           foreach ($valuesothers as $vals) {
 185             if (CRM_Utils_Array::value('location_type_id', $vals) ==
 186               $locationTypeID
 187             ) {
 188               foreach ($vals as $k => $v) {
 189                 if (in_array($k, [
 190                   'email',
 191                   'phone',
 192                   'im',
 193                   'openid',
 194                 ])) {
 195                   if ($k == 'im') {
 196                     $rows[$value][$k] = $v['1']['name'];
 197                   }
 198                   else {
 199                     $rows[$value][$k] = $v['1'][$k];
 200                   }
 201                   $rows[$value][$k . '_id'] = $v['1']['id'];
 202                 }
 203               }
 204             }
 205           }
 206         }
 207       }
 208       else {
 209         if (!CRM_Contact_Form_Task_Label::tokenIsFound($contact, $mailingFormatProperties, $tokenFields)) {
 210           continue;
 211         }
 212
 213         if (!empty($contact['addressee_display'])) {
 214           $contact['addressee_display'] = trim($contact['addressee_display']);
 215         }
 216         if (!empty($contact['addressee'])) {
 217           $contact['addressee'] = $contact['addressee_display'];
 218         }
 219
 220         // now create the rows for generating mailing labels
 221         foreach ($contact as $field => $fieldValue) {
 222           $rows[$value][$field] = $fieldValue;
 223         }
 224       }
 225     }
 226     // sigh couldn't extract out tokenfields yet
 227     return [$rows, $tokenFields];
 228   }
 229
 230   /**
 231    * Get array of return properties for address fields required for mailing label.
 232    *
 233    * @return array
 234    *   return properties for address e.g
 235    *   [street_address => 1, supplemental_address_1 => 1, supplemental_address_2 => 1]
 236    */
 237   public static function getAddressReturnProperties() {
 238     $mailingFormat = Civi::settings()->get('mailing_format');
 239
 240     $addressFields = CRM_Utils_Address::sequence($mailingFormat);
 241     $addressReturnProperties = array_fill_keys($addressFields, 1);
 242
 243     if (array_key_exists('postal_code', $addressReturnProperties)) {
 244       $addressReturnProperties['postal_code_suffix'] = 1;
 245     }
 246     return $addressReturnProperties;
 247   }
 248
 249   /**
 250    * Get token list from mailing format & contacts
 251    * @param array $contacts
 252    * @return array
 253    */
 254   public static function getTokenData(&$contacts) {
 255     $mailingFormat = Civi::settings()->get('mailing_format');
 256     $tokens = $tokenFields = [];
 257     $messageToken = CRM_Utils_Token::getTokens($mailingFormat);
 258
 259     // also get all token values
 260     CRM_Utils_Hook::tokenValues($contacts,
 261       array_keys($contacts),
 262       NULL,
 263       $messageToken,
 264       'CRM_Contact_Form_Task_LabelCommon'
 265     );
 266
 267     CRM_Utils_Hook::tokens($tokens);
 268
 269     foreach ($tokens as $category => $catTokens) {
 270       foreach ($catTokens as $token => $tokenName) {
 271         $tokenFields[] = $token;
 272       }
 273     }
 274     return $tokenFields;
 275
 276   }
 277
 278   /**
 279    * @param array $rows
 280    *
 281    * @return array
 282    */
 283   public function mergeSameHousehold(&$rows) {
 284     // group selected contacts by type
 285     $individuals = [];
 286     $households = [];
 287     foreach ($rows as $contact_id => $row) {
 288       if ($row['contact_type'] == 'Household') {
 289         $households[$contact_id] = $row;
 290       }
 291       elseif ($row['contact_type'] == 'Individual') {
 292         $individuals[$contact_id] = $row;
 293       }
 294     }
 295
 296     // exclude individuals belonging to selected households
 297     foreach ($households as $household_id => $row) {
 298       $dao = new CRM_Contact_DAO_Relationship();
 299       $dao->contact_id_b = $household_id;
 300       $dao->find();
 301       while ($dao->fetch()) {
 302         $individual_id = $dao->contact_id_a;
 303         if (array_key_exists($individual_id, $individuals)) {
 304           unset($individuals[$individual_id]);
 305         }
 306       }
 307     }
 308
 309     // merge back individuals and households
 310     $rows = array_merge($individuals, $households);
 311     return $rows;
 312   }
 313
 314 }