3 +--------------------------------------------------------------------+
4 | Copyright CiviCRM LLC. All rights reserved. |
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 +--------------------------------------------------------------------+
15 * @copyright CiviCRM LLC https://civicrm.org/licensing
20 * This class provides the functionality to email a group of
23 class CRM_Contribute_Form_Task_Invoice
extends CRM_Contribute_Form_Task
{
25 * Are we operating in "single mode", i.e. updating the task of only
26 * one specific contribution?
30 public $_single = FALSE;
33 * Gives all the statues for conribution.
36 public $_contributionStatusId;
39 * Gives the HTML template of PDF Invoice.
42 public $_messageInvoice;
45 * This variable is used to assign parameters for HTML template of PDF Invoice.
48 public $_invoiceTemplate;
54 public $_selectedOutput;
57 * Build all the data structures needed to build the form.
59 public function preProcess() {
60 $id = CRM_Utils_Request
::retrieve('id', 'Positive', $this, FALSE);
62 $this->_contributionIds
= [$id];
63 $this->_componentClause
= " civicrm_contribution.id IN ( $id ) ";
64 $this->_single
= TRUE;
65 $this->assign('totalSelectedContributions', 1);
67 // set the redirection after actions
68 $contactId = CRM_Utils_Request
::retrieve('cid', 'Positive', $this, FALSE);
69 $url = CRM_Utils_System
::url('civicrm/contact/view/contribution',
70 "action=view&reset=1&id={$id}&cid={$contactId}&context=contribution&selectedChild=contribute"
73 CRM_Core_Session
::singleton()->pushUserContext($url);
79 // check that all the contribution ids have status Completed, Pending, Refunded, or Partially Paid.
80 $this->_contributionStatusId
= CRM_Contribute_PseudoConstant
::contributionStatus(NULL, 'name');
81 $status = ['Completed', 'Pending', 'Refunded', 'Partially paid'];
83 foreach ($this->_contributionStatusId
as $key => $value) {
84 if (in_array($value, $status)) {
88 $Id = implode(",", $statusId);
89 $query = "SELECT count(*) FROM civicrm_contribution WHERE contribution_status_id NOT IN ($Id) AND {$this->_componentClause}";
90 $count = CRM_Core_DAO
::singleValueQuery($query);
92 CRM_Core_Error
::statusBounce(ts('Please select only contributions with Completed, Pending, Refunded, or Partially Paid status.'));
95 // we have all the contribution ids, so now we get the contact ids
96 parent
::setContactIDs();
97 $this->assign('single', $this->_single
);
99 $qfKey = CRM_Utils_Request
::retrieve('qfKey', 'String', $this);
100 $urlParams = 'force=1';
101 if (CRM_Utils_Rule
::qfKey($qfKey)) {
102 $urlParams .= "&qfKey=$qfKey";
105 $url = CRM_Utils_System
::url('civicrm/contribute/search', $urlParams);
109 'title' => ts('Search Results'),
113 CRM_Utils_System
::appendBreadCrumb($breadCrumb);
115 $this->_selectedOutput
= CRM_Utils_Request
::retrieve('select', 'String', $this);
116 $this->assign('selectedOutput', $this->_selectedOutput
);
118 CRM_Contact_Form_Task_EmailCommon
::preProcessFromAddress($this);
119 if ($this->_selectedOutput
== 'email') {
120 CRM_Utils_System
::setTitle(ts('Email Invoice'));
123 CRM_Utils_System
::setTitle(ts('Print Contribution Invoice'));
128 * Build the form object.
130 public function buildQuickForm() {
131 $this->preventAjaxSubmit();
132 if (CRM_Core_Permission
::check('administer CiviCRM')) {
133 $this->assign('isAdmin', 1);
136 $this->add('select', 'from_email_address', ts('From'), $this->_fromEmails
, TRUE);
137 if ($this->_selectedOutput
!= 'email') {
138 $this->addElement('radio', 'output', NULL, ts('Email Invoice'), 'email_invoice');
139 $this->addElement('radio', 'output', NULL, ts('PDF Invoice'), 'pdf_invoice');
140 $this->addRule('output', ts('Selection required'), 'required');
141 $this->addFormRule(['CRM_Contribute_Form_Task_Invoice', 'formRule']);
144 $this->addRule('from_email_address', ts('From Email Address is required'), 'required');
147 $attributes = ['class' => 'huge'];
148 $this->addEntityRef('cc_id', ts('CC'), [
152 $this->add('text', 'subject', ts('Subject'), $attributes +
['placeholder' => ts('Optional')]);
153 $this->add('wysiwyg', 'email_comment', ts('If you would like to add personal message to email please add it here. (If sending to more then one receipient the same message will be sent to each contact.)'), [
161 'name' => $this->_selectedOutput
== 'email' ?
ts('Send Email') : ts('Process Invoice(s)'),
166 'name' => ts('Cancel'),
172 * Global validation rules for the form.
174 * @param array $values
177 * list of errors to be posted back to the form
179 public static function formRule($values) {
182 if ($values['output'] == 'email_invoice' && empty($values['from_email_address'])) {
183 $errors['from_email_address'] = ts("From Email Address is required");
190 * Process the form after the input has been submitted and validated.
192 public function postProcess() {
193 $params = $this->controller
->exportValues($this->_name
);
194 self
::printPDF($this->_contributionIds
, $params, $this->_contactIds
);
198 * Process the PDf and email with activity and attachment on click of Print Invoices.
200 * @param array $contribIDs
202 * @param array $params
203 * Associated array of submitted values.
204 * @param array $contactIds
207 public static function printPDF($contribIDs, &$params, $contactIds) {
208 // get all the details needed to generate a invoice
209 $messageInvoice = [];
210 $invoiceTemplate = CRM_Core_Smarty
::singleton();
211 $invoiceElements = CRM_Contribute_Form_Task_PDF
::getElements($contribIDs, $params, $contactIds);
213 // gives the status id when contribution status is 'Refunded'
214 $contributionStatusID = CRM_Contribute_PseudoConstant
::contributionStatus(NULL, 'name');
215 $refundedStatusId = CRM_Utils_Array
::key('Refunded', $contributionStatusID);
216 $cancelledStatusId = CRM_Utils_Array
::key('Cancelled', $contributionStatusID);
217 $pendingStatusId = CRM_Utils_Array
::key('Pending', $contributionStatusID);
219 foreach ($invoiceElements['details'] as $contribID => $detail) {
220 $input = $ids = $objects = [];
221 if (in_array($detail['contact'], $invoiceElements['excludeContactIds'])) {
225 $input['component'] = $detail['component'];
227 $ids['contact'] = $detail['contact'];
228 $ids['contribution'] = $contribID;
229 $ids['contributionRecur'] = NULL;
230 $ids['contributionPage'] = NULL;
231 $ids['membership'] = $detail['membership'] ??
NULL;
232 $ids['participant'] = $detail['participant'] ??
NULL;
233 $ids['event'] = $detail['event'] ??
NULL;
235 if (!$invoiceElements['baseIPN']->validateData($input, $ids, $objects, FALSE)) {
236 CRM_Core_Error
::statusBounce('Supplied data was not able to be validated');
239 $contribution = &$objects['contribution'];
241 $input['amount'] = $contribution->total_amount
;
242 $input['invoice_id'] = $contribution->invoice_id
;
243 $input['receive_date'] = $contribution->receive_date
;
244 $input['contribution_status_id'] = $contribution->contribution_status_id
;
245 $input['organization_name'] = $contribution->_relatedObjects
['contact']->organization_name
;
247 $objects['contribution']->receive_date
= CRM_Utils_Date
::isoToMysql($objects['contribution']->receive_date
);
249 // Fetch the billing address. getValues should prioritize the billing
250 // address, otherwise will return the primary address.
251 $billingAddress = [];
253 $addressDetails = CRM_Core_BAO_Address
::getValues([
254 'contact_id' => $contribution->contact_id
,
258 if (!empty($addressDetails)) {
259 $billingAddress = array_shift($addressDetails);
262 if ($contribution->contribution_status_id
== $refundedStatusId ||
$contribution->contribution_status_id
== $cancelledStatusId) {
263 $creditNoteId = $contribution->creditnote_id
;
265 if (!$contribution->invoice_number
) {
266 $contribution->invoice_number
= CRM_Contribute_BAO_Contribution
::getInvoiceNumber($contribution->id
);
269 //to obtain due date for PDF invoice
270 $contributionReceiveDate = date('F j,Y', strtotime(date($input['receive_date'])));
271 $invoiceDate = date("F j, Y");
272 $dueDateSetting = Civi
::settings()->get('invoice_due_date');
273 $dueDatePeriodSetting = Civi
::settings()->get('invoice_due_date_period');
274 $dueDate = date('F j, Y', strtotime($contributionReceiveDate . "+" . $dueDateSetting . "" . $dueDatePeriodSetting));
276 $amountPaid = CRM_Core_BAO_FinancialTrxn
::getTotalPayments($contribID, TRUE);
277 $amountDue = ($input['amount'] - $amountPaid);
279 // retrieving the subtotal and sum of same tax_rate
282 $lineItem = CRM_Price_BAO_LineItem
::getLineItemsByContributionID($contribID);
283 foreach ($lineItem as $taxRate) {
284 if (isset($dataArray[(string) $taxRate['tax_rate']])) {
285 $dataArray[(string) $taxRate['tax_rate']] = $dataArray[(string) $taxRate['tax_rate']] + CRM_Utils_Array
::value('tax_amount', $taxRate);
288 $dataArray[(string) $taxRate['tax_rate']] = $taxRate['tax_amount'] ??
NULL;
290 $subTotal +
= CRM_Utils_Array
::value('subTotal', $taxRate);
293 // to email the invoice
296 if ($contribution->_component
== 'event') {
297 $daoName = 'CRM_Event_DAO_Event';
298 $pageId = $contribution->_relatedObjects
['event']->id
;
302 'confirm_from_email',
304 CRM_Core_DAO
::commonRetrieveAll($daoName, 'id', $pageId, $mailDetails, $mailElements);
305 $values['title'] = $mailDetails[$contribution->_relatedObjects
['event']->id
]['title'] ??
NULL;
306 $values['confirm_from_name'] = $mailDetails[$contribution->_relatedObjects
['event']->id
]['confirm_from_name'] ??
NULL;
307 $values['confirm_from_email'] = $mailDetails[$contribution->_relatedObjects
['event']->id
]['confirm_from_email'] ??
NULL;
309 $title = $mailDetails[$contribution->_relatedObjects
['event']->id
]['title'] ??
NULL;
311 elseif ($contribution->_component
== 'contribute') {
312 $daoName = 'CRM_Contribute_DAO_ContributionPage';
313 $pageId = $contribution->contribution_page_id
;
317 'receipt_from_email',
321 CRM_Core_DAO
::commonRetrieveAll($daoName, 'id', $pageId, $mailDetails, $mailElements);
323 $values['title'] = CRM_Utils_Array
::value('title', CRM_Utils_Array
::value($contribution->contribution_page_id
, $mailDetails));
324 $values['receipt_from_name'] = CRM_Utils_Array
::value('receipt_from_name', CRM_Utils_Array
::value($contribution->contribution_page_id
, $mailDetails));
325 $values['receipt_from_email'] = CRM_Utils_Array
::value('receipt_from_email', CRM_Utils_Array
::value($contribution->contribution_page_id
, $mailDetails));
326 $values['cc_receipt'] = CRM_Utils_Array
::value('cc_receipt', CRM_Utils_Array
::value($contribution->contribution_page_id
, $mailDetails));
327 $values['bcc_receipt'] = CRM_Utils_Array
::value('bcc_receipt', CRM_Utils_Array
::value($contribution->contribution_page_id
, $mailDetails));
329 $title = CRM_Utils_Array
::value('title', CRM_Utils_Array
::value($contribution->contribution_page_id
, $mailDetails));
331 $source = $contribution->source
;
333 $config = CRM_Core_Config
::singleton();
334 if (!isset($params['forPage'])) {
335 $config->doNotAttachPDFReceipt
= 1;
338 // get organization address
339 $domain = CRM_Core_BAO_Domain
::getDomain();
340 $locParams = ['contact_id' => $domain->contact_id
];
341 $locationDefaults = CRM_Core_BAO_Location
::getValues($locParams);
342 if (isset($locationDefaults['address'][1]['state_province_id'])) {
343 $stateProvinceAbbreviationDomain = CRM_Core_PseudoConstant
::stateProvinceAbbreviation($locationDefaults['address'][1]['state_province_id']);
346 $stateProvinceAbbreviationDomain = '';
348 if (isset($locationDefaults['address'][1]['country_id'])) {
349 $countryDomain = CRM_Core_PseudoConstant
::country($locationDefaults['address'][1]['country_id']);
355 $invoiceNotes = Civi
::settings()->get('invoice_notes') ??
NULL;
357 // parameters to be assign for template
360 'component' => $input['component'],
361 'id' => $contribution->id
,
363 'invoice_number' => $contribution->invoice_number
,
364 'invoice_id' => $contribution->invoice_id
,
365 'resourceBase' => $config->userFrameworkResourceURL
,
366 'defaultCurrency' => $config->defaultCurrency
,
367 'amount' => $contribution->total_amount
,
368 'amountDue' => $amountDue,
369 'amountPaid' => $amountPaid,
370 'invoice_date' => $invoiceDate,
371 'dueDate' => $dueDate,
372 'notes' => $invoiceNotes,
373 'display_name' => $contribution->_relatedObjects
['contact']->display_name
,
374 'lineItem' => $lineItem,
375 'dataArray' => $dataArray,
376 'refundedStatusId' => $refundedStatusId,
377 'pendingStatusId' => $pendingStatusId,
378 'cancelledStatusId' => $cancelledStatusId,
379 'contribution_status_id' => $contribution->contribution_status_id
,
380 'contributionStatusName' => CRM_Core_PseudoConstant
::getName('CRM_Contribute_BAO_Contribution', 'contribution_status_id', $contribution->contribution_status_id
),
381 'subTotal' => $subTotal,
382 'street_address' => $billingAddress['street_address'] ??
NULL,
383 'supplemental_address_1' => $billingAddress['supplemental_address_1'] ??
NULL,
384 'supplemental_address_2' => $billingAddress['supplemental_address_2'] ??
NULL,
385 'supplemental_address_3' => $billingAddress['supplemental_address_3'] ??
NULL,
386 'city' => $billingAddress['city'] ??
NULL,
387 'postal_code' => $billingAddress['postal_code'] ??
NULL,
388 'state_province' => $billingAddress['state_province'] ??
NULL,
389 'state_province_abbreviation' => $billingAddress['state_province_abbreviation'] ??
NULL,
390 // Kept for backwards compatibility
391 'stateProvinceAbbreviation' => $billingAddress['state_province_abbreviation'] ??
NULL,
392 'country' => $billingAddress['country'] ??
NULL,
393 'is_pay_later' => $contribution->is_pay_later
,
394 'organization_name' => $contribution->_relatedObjects
['contact']->organization_name
,
395 'domain_organization' => $domain->name
,
396 'domain_street_address' => CRM_Utils_Array
::value('street_address', CRM_Utils_Array
::value('1', $locationDefaults['address'])),
397 'domain_supplemental_address_1' => CRM_Utils_Array
::value('supplemental_address_1', CRM_Utils_Array
::value('1', $locationDefaults['address'])),
398 'domain_supplemental_address_2' => CRM_Utils_Array
::value('supplemental_address_2', CRM_Utils_Array
::value('1', $locationDefaults['address'])),
399 'domain_supplemental_address_3' => CRM_Utils_Array
::value('supplemental_address_3', CRM_Utils_Array
::value('1', $locationDefaults['address'])),
400 'domain_city' => CRM_Utils_Array
::value('city', CRM_Utils_Array
::value('1', $locationDefaults['address'])),
401 'domain_postal_code' => CRM_Utils_Array
::value('postal_code', CRM_Utils_Array
::value('1', $locationDefaults['address'])),
402 'domain_state' => $stateProvinceAbbreviationDomain,
403 'domain_country' => $countryDomain,
404 'domain_email' => CRM_Utils_Array
::value('email', CRM_Utils_Array
::value('1', $locationDefaults['email'])),
405 'domain_phone' => CRM_Utils_Array
::value('phone', CRM_Utils_Array
::value('1', $locationDefaults['phone'])),
408 if (isset($creditNoteId)) {
409 $tplParams['creditnote_id'] = $creditNoteId;
412 $pdfFileName = $contribution->invoice_number
. ".pdf";
413 $sendTemplateParams = [
414 'groupName' => 'msg_tpl_workflow_contribution',
415 'valueName' => 'contribution_invoice_receipt',
416 'contactId' => $contribution->contact_id
,
417 'tplParams' => $tplParams,
418 'PDFFilename' => $pdfFileName,
421 // from email address
422 $fromEmailAddress = $params['from_email_address'] ??
NULL;
423 if (!empty($params['cc_id'])) {
424 // get contacts and their emails from email id
425 $emailIDs = $params['cc_id'] ?
explode(',', $params['cc_id']) : [];
426 $emails = Email
::get()
427 ->addWhere('id', 'IN', $emailIDs)
428 ->setCheckPermissions(FALSE)
429 ->setSelect(['contact_id', 'email', 'contact.sort_name', 'contact.display_name'])->execute();
430 $emailStrings = $contactUrlStrings = [];
431 foreach ($emails as $email) {
432 $emailStrings[] = '"' . $email['contact.sort_name'] . '" <' . $email['email'] . '>';
433 // generate the contact url to put in Activity
434 $contactURL = CRM_Utils_System
::url('civicrm/contact/view', ['reset' => 1, 'force' => 1, 'cid' => $email['contact_id']], TRUE);
435 $contactUrlStrings[] = "<a href='{$contactURL}'>" . $email['contact.display_name'] . '</a>';
437 $cc_emails = implode(',', $emailStrings);
438 $values['cc_receipt'] = $cc_emails;
439 $ccContactsDetails = implode(',', $contactUrlStrings);
440 // add CC emails as activity details
441 $params['activity_details'] = "\ncc : " . $ccContactsDetails;
443 // unset bcc to avoid unknown email come from online page configuration.
444 unset($values['bcc_receipt']);
447 // get subject from UI
448 if (!empty($params['subject'])) {
449 $sendTemplateParams['subject'] = $values['subject'] = $params['subject'];
452 // condition to check for download PDF Invoice or email Invoice
453 if ($invoiceElements['createPdf']) {
454 list($sent, $subject, $message, $html) = CRM_Core_BAO_MessageTemplate
::sendTemplate($sendTemplateParams);
455 if (isset($params['forPage'])) {
460 'subject' => $subject,
465 $messageInvoice[] = $mail['html'];
468 $messageInvoice[] = nl2br($mail['body']);
472 elseif ($contribution->_component
== 'contribute') {
473 $email = CRM_Contact_BAO_Contact
::getPrimaryEmail($contribution->contact_id
);
475 $sendTemplateParams['tplParams'] = array_merge($tplParams, ['email_comment' => $invoiceElements['params']['email_comment']]);
476 $sendTemplateParams['from'] = $fromEmailAddress;
477 $sendTemplateParams['toEmail'] = $email;
478 $sendTemplateParams['cc'] = $values['cc_receipt'] ??
NULL;
479 $sendTemplateParams['bcc'] = $values['bcc_receipt'] ??
NULL;
481 list($sent, $subject, $message, $html) = CRM_Core_BAO_MessageTemplate
::sendTemplate($sendTemplateParams);
482 // functions call for adding activity with attachment
483 // make sure page layout is same for email and download invoices.
484 $fileName = self
::putFile($html, $pdfFileName, [
489 self
::addActivities($subject, $contribution->contact_id
, $fileName, $params, $contribution->id
);
491 elseif ($contribution->_component
== 'event') {
492 $email = CRM_Contact_BAO_Contact
::getPrimaryEmail($contribution->contact_id
);
494 $sendTemplateParams['tplParams'] = array_merge($tplParams, ['email_comment' => $invoiceElements['params']['email_comment']]);
495 $sendTemplateParams['from'] = $fromEmailAddress;
496 $sendTemplateParams['toEmail'] = $email;
497 $sendTemplateParams['cc'] = $values['cc_confirm'] ??
NULL;
498 $sendTemplateParams['bcc'] = $values['bcc_confirm'] ??
NULL;
500 list($sent, $subject, $message, $html) = CRM_Core_BAO_MessageTemplate
::sendTemplate($sendTemplateParams);
501 // functions call for adding activity with attachment
502 $fileName = self
::putFile($html, $pdfFileName);
503 self
::addActivities($subject, $contribution->contact_id
, $fileName, $params, $contribution->id
);
505 $invoiceTemplate->clearTemplateVars();
508 if ($invoiceElements['createPdf']) {
509 if (isset($params['forPage'])) {
513 CRM_Utils_PDF_Utils
::html2pdf($messageInvoice, $pdfFileName, FALSE, [
518 // functions call for adding activity with attachment
519 $fileName = self
::putFile($html, $pdfFileName, [
524 self
::addActivities($subject, $contactIds, $fileName, $params);
526 CRM_Utils_System
::civiExit();
530 if ($invoiceElements['suppressedEmails']) {
531 $status = ts('Email was NOT sent to %1 contacts (no email address on file, or communication preferences specify DO NOT EMAIL, or contact is deceased).', [1 => $invoiceElements['suppressedEmails']]);
532 $msgTitle = ts('Email Error');
536 $status = ts('Your mail has been sent.');
537 $msgTitle = ts('Sent');
538 $msgType = 'success';
540 CRM_Core_Session
::setStatus($status, $msgTitle, $msgType);
545 * Add activity for Email Invoice and the PDF Invoice.
547 * @param string $subject
549 * @param array $contactIds
551 * @param string $fileName
552 * Gives the location with name of the file.
553 * @param array $params
555 * @param int $contributionId
559 public static function addActivities($subject, $contactIds, $fileName, $params, $contributionId = NULL) {
560 $session = CRM_Core_Session
::singleton();
561 $userID = $session->get('userID');
562 $config = CRM_Core_Config
::singleton();
563 $config->doNotAttachPDFReceipt
= 1;
565 if (!empty($params['output']) && $params['output'] == 'pdf_invoice') {
566 $activityType = 'Downloaded Invoice';
569 $activityType = 'Emailed Invoice';
573 'subject' => $subject,
574 'source_contact_id' => $userID,
575 'target_contact_id' => $contactIds,
576 'activity_type_id' => $activityType,
577 'activity_date_time' => date('YmdHis'),
578 'details' => $params['activity_details'] ??
NULL,
581 'type' => 'application/pdf',
582 'location' => $fileName,
583 'upload_date' => date('YmdHis'),
586 if ($contributionId) {
587 $activityParams['source_record_id'] = $contributionId;
589 civicrm_api3('Activity', 'create', $activityParams);
593 * Create the Invoice file in upload folder for attachment.
595 * @param string $html
596 * Content for pdf in html format.
598 * @param string $name
599 * @param array $format
602 * Name of file which is in pdf format
604 public static function putFile($html, $name = 'Invoice.pdf', $format = NULL) {
605 return CRM_Utils_Mail
::appendPDF($name, $html, $format)['fullPath'] ??
'';
609 * Callback to perform action on Print Invoice button.
611 public static function getPrintPDF() {
612 $contributionId = CRM_Utils_Request
::retrieve('id', 'Positive', CRM_Core_DAO
::$_nullObject, FALSE);
613 $contributionIDs = [$contributionId];
614 $contactId = CRM_Utils_Request
::retrieve('cid', 'Positive', CRM_Core_DAO
::$_nullObject, FALSE);
615 $params = ['output' => 'pdf_invoice'];
616 CRM_Contribute_Form_Task_Invoice
::printPDF($contributionIDs, $params, $contactId);