CRM/Mailing/Page/AJAX.php

   1 <?php
   2 /*
   3  +--------------------------------------------------------------------+
   4  | CiviCRM version 4.6                                                |
   5  +--------------------------------------------------------------------+
   6  | Copyright CiviCRM LLC (c) 2004-2014                                |
   7  +--------------------------------------------------------------------+
   8  | This file is a part of CiviCRM.                                    |
   9  |                                                                    |
  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.   |
  13  |                                                                    |
  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.        |
  18  |                                                                    |
  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  +--------------------------------------------------------------------+
  26  */
  27
  28 /**
  29  *
  30  * @package CRM
  31  * @copyright CiviCRM LLC (c) 2004-2014
  32  * $Id$
  33  *
  34  */
  35
  36 /**
  37  * This class contains all the function that are called using AJAX
  38  */
  39 class CRM_Mailing_Page_AJAX {
  40
  41   /**
  42    * Fetch the template text/html messages
  43    */
  44   public static function template() {
  45     $templateId = CRM_Utils_Type::escape($_POST['tid'], 'Integer');
  46
  47     $messageTemplate = new CRM_Core_DAO_MessageTemplate();
  48     $messageTemplate->id = $templateId;
  49     $messageTemplate->selectAdd();
  50     $messageTemplate->selectAdd('msg_text, msg_html, msg_subject, pdf_format_id');
  51     $messageTemplate->find(TRUE);
  52     $messages = array(
  53       'subject' => $messageTemplate->msg_subject,
  54       'msg_text' => $messageTemplate->msg_text,
  55       'msg_html' => $messageTemplate->msg_html,
  56       'pdf_format_id' => $messageTemplate->pdf_format_id,
  57     );
  58
  59     CRM_Utils_JSON::output($messages);
  60   }
  61
  62   /**
  63    * Retrieve contact mailings.
  64    */
  65   public static function getContactMailings() {
  66     $contactID = CRM_Utils_Type::escape($_GET['contact_id'], 'Integer');
  67
  68     $sortMapper = array(
  69       0 => 'subject',
  70       1 => 'creator_name',
  71       2 => '',
  72       3 => 'start_date',
  73       4 => '',
  74       5 => 'links',
  75     );
  76
  77     $sEcho = CRM_Utils_Type::escape($_REQUEST['sEcho'], 'Integer');
  78     $offset = isset($_REQUEST['iDisplayStart']) ? CRM_Utils_Type::escape($_REQUEST['iDisplayStart'], 'Integer') : 0;
  79     $rowCount = isset($_REQUEST['iDisplayLength']) ? CRM_Utils_Type::escape($_REQUEST['iDisplayLength'], 'Integer') : 25;
  80     $sort = isset($_REQUEST['iSortCol_0']) ? CRM_Utils_Array::value(CRM_Utils_Type::escape($_REQUEST['iSortCol_0'], 'Integer'), $sortMapper) : NULL;
  81     $sortOrder = isset($_REQUEST['sSortDir_0']) ? CRM_Utils_Type::escape($_REQUEST['sSortDir_0'], 'String') : 'asc';
  82
  83     $params = $_POST;
  84     if ($sort && $sortOrder) {
  85       $params['sortBy'] = $sort . ' ' . $sortOrder;
  86     }
  87
  88     $params['page'] = ($offset / $rowCount) + 1;
  89     $params['rp'] = $rowCount;
  90
  91     $params['contact_id'] = $contactID;
  92     $params['context'] = $context;
  93
  94     // get the contact mailings
  95     $mailings = CRM_Mailing_BAO_Mailing::getContactMailingSelector($params);
  96
  97     $iFilteredTotal = $iTotal = $params['total'];
  98     $selectorElements = array(
  99       'subject',
 100       'mailing_creator',
 101       'recipients',
 102       'start_date',
 103       'openstats',
 104       'links',
 105     );
 106
 107     echo CRM_Utils_JSON::encodeDataTableSelector($mailings, $sEcho, $iTotal, $iFilteredTotal, $selectorElements);
 108     CRM_Utils_System::civiExit();
 109   }
 110
 111 }