CRM/Activity/Tokens.php

   1 <?php
   2
   3 /*
   4  +--------------------------------------------------------------------+
   5  | CiviCRM version 4.7                                                |
   6  +--------------------------------------------------------------------+
   7  | Copyright CiviCRM LLC (c) 2004-2017                                |
   8  +--------------------------------------------------------------------+
   9  | This file is a part of CiviCRM.                                    |
  10  |                                                                    |
  11  | CiviCRM is free software; you can copy, modify, and distribute it  |
  12  | under the terms of the GNU Affero General Public License           |
  13  | Version 3, 19 November 2007 and the CiviCRM Licensing Exception.   |
  14  |                                                                    |
  15  | CiviCRM is distributed in the hope that it will be useful, but     |
  16  | WITHOUT ANY WARRANTY; without even the implied warranty of         |
  17  | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.               |
  18  | See the GNU Affero General Public License for more details.        |
  19  |                                                                    |
  20  | You should have received a copy of the GNU Affero General Public   |
  21  | License and the CiviCRM Licensing Exception along                  |
  22  | with this program; if not, contact CiviCRM LLC                     |
  23  | at info[AT]civicrm[DOT]org. If you have questions about the        |
  24  | GNU Affero General Public License or the licensing of CiviCRM,     |
  25  | see the CiviCRM license FAQ at http://civicrm.org/licensing        |
  26  +--------------------------------------------------------------------+
  27  */
  28
  29 /**
  30  * @package CRM
  31  * @copyright CiviCRM LLC (c) 2004-2017
  32  */
  33
  34 /**
  35  * Class CRM_Member_Tokens
  36  *
  37  * Generate "activity.*" tokens.
  38  *
  39  * This TokenSubscriber was produced by refactoring the code from the
  40  * scheduled-reminder system with the goal of making that system
  41  * more flexible. The current implementation is still coupled to
  42  * scheduled-reminders. It would be good to figure out a more generic
  43  * implementation which is not tied to scheduled reminders, although
  44  * that is outside the current scope.
  45  */
  46 class CRM_Activity_Tokens extends \Civi\Token\AbstractTokenSubscriber {
  47
  48   /**
  49    * CRM_Activity_Tokens constructor.
  50    */
  51   public function __construct() {
  52     parent::__construct('activity', array(
  53       'activity_id' => ts('Activity ID'),
  54       'activity_type' => ts('Activity Type'),
  55       'subject' => ts('Activity Subject'),
  56       'details' => ts('Activity Details'),
  57       'activity_date_time' => ts('Activity Date-Time'),
  58     ));
  59   }
  60
  61   /**
  62    * @inheritDoc
  63    */
  64   public function checkActive(\Civi\Token\TokenProcessor $processor) {
  65     // Extracted from scheduled-reminders code. See the class description.
  66     return
  67       !empty($processor->context['actionMapping'])
  68       && $processor->context['actionMapping']->getEntity() === 'civicrm_activity';
  69   }
  70
  71   /**
  72    * @inheritDoc
  73    */
  74   public function alterActionScheduleQuery(\Civi\ActionSchedule\Event\MailingQueryEvent $e) {
  75     if ($e->mapping->getEntity() !== 'civicrm_activity') {
  76       return;
  77     }
  78
  79     // The joint expression for activities needs some extra nuance to handle.
  80     // Multiple revisions of the activity.
  81     // Q: Could we simplify & move the extra AND clauses into `where(...)`?
  82     $e->query->param('casEntityJoinExpr', 'e.id = reminder.entity_id AND e.is_current_revision = 1 AND e.is_deleted = 0');
  83
  84     $e->query->select('e.*'); // FIXME: seems too broad.
  85     $e->query->select('ov.label as activity_type, e.id as activity_id');
  86
  87     $e->query->join("og", "!casMailingJoinType civicrm_option_group og ON og.name = 'activity_type'");
  88     $e->query->join("ov", "!casMailingJoinType civicrm_option_value ov ON e.activity_type_id = ov.value AND ov.option_group_id = og.id");
  89
  90     // if CiviCase component is enabled, join for caseId.
  91     $compInfo = CRM_Core_Component::getEnabledComponents();
  92     if (array_key_exists('CiviCase', $compInfo)) {
  93       $e->query->select("civicrm_case_activity.case_id as case_id");
  94       $e->query->join('civicrm_case_activity', "LEFT JOIN `civicrm_case_activity` ON `e`.`id` = `civicrm_case_activity`.`activity_id`");
  95     }
  96   }
  97
  98   /**
  99    * @inheritDoc
 100    */
 101   public function evaluateToken(\Civi\Token\TokenRow $row, $entity, $field, $prefetch = NULL) {
 102     $actionSearchResult = $row->context['actionSearchResult'];
 103
 104     if (in_array($field, array('activity_date_time'))) {
 105       $row->tokens($entity, $field, \CRM_Utils_Date::customFormat($actionSearchResult->$field));
 106     }
 107     elseif (isset($actionSearchResult->$field)) {
 108       $row->tokens($entity, $field, $actionSearchResult->$field);
 109     }
 110     else {
 111       $row->tokens($entity, $field, '');
 112     }
 113   }
 114
 115 }