CRM/Batch/Page/AJAX.php

   1 <?php
   2 /*
   3  +--------------------------------------------------------------------+
   4  | CiviCRM version 4.7                                                |
   5  +--------------------------------------------------------------------+
   6  | Copyright CiviCRM LLC (c) 2004-2017                                |
   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-2017
  32  */
  33
  34 /**
  35  * This class contains functions that are called using AJAX.
  36  */
  37 class CRM_Batch_Page_AJAX {
  38
  39   /**
  40    * Save record.
  41    */
  42   public function batchSave() {
  43     // save the entered information in 'data' column
  44     $batchId = CRM_Utils_Type::escape($_POST['batch_id'], 'Positive');
  45
  46     unset($_POST['qfKey']);
  47     CRM_Core_DAO::setFieldValue('CRM_Batch_DAO_Batch', $batchId, 'data', json_encode(array('values' => $_POST)));
  48
  49     CRM_Utils_System::civiExit();
  50   }
  51
  52   /**
  53    * This function uses the deprecated v1 datatable api and needs updating. See CRM-16353.
  54    * @deprecated
  55    */
  56   public static function getBatchList() {
  57     $context = isset($_REQUEST['context']) ? CRM_Utils_Type::escape($_REQUEST['context'], 'String') : NULL;
  58     if ($context != 'financialBatch') {
  59       $sortMapper = array(
  60         0 => 'title',
  61         1 => 'type_id.label',
  62         2 => 'item_count',
  63         3 => 'total',
  64         4 => 'status_id.label',
  65         5 => 'created_id.sort_name',
  66       );
  67     }
  68     else {
  69       $sortMapper = array(
  70         1 => 'title',
  71         2 => 'payment_instrument_id.label',
  72         3 => 'item_count',
  73         4 => 'total',
  74         5 => 'status_id.label',
  75         6 => 'created_id.sort_name',
  76       );
  77     }
  78     $sEcho = CRM_Utils_Type::escape($_REQUEST['sEcho'], 'Integer');
  79     $offset = isset($_REQUEST['iDisplayStart']) ? CRM_Utils_Type::escape($_REQUEST['iDisplayStart'], 'Integer') : 0;
  80     $rowCount = isset($_REQUEST['iDisplayLength']) ? CRM_Utils_Type::escape($_REQUEST['iDisplayLength'], 'Integer') : 25;
  81     $sort = isset($_REQUEST['iSortCol_0']) ? CRM_Utils_Array::value(CRM_Utils_Type::escape($_REQUEST['iSortCol_0'], 'Integer'), $sortMapper) : NULL;
  82     $sortOrder = isset($_REQUEST['sSortDir_0']) ? CRM_Utils_Type::escape($_REQUEST['sSortDir_0'], 'String') : 'asc';
  83
  84     $params = $_REQUEST;
  85     if ($sort && $sortOrder) {
  86       $params['sortBy'] = $sort . ' ' . $sortOrder;
  87     }
  88
  89     $params['page'] = ($offset / $rowCount) + 1;
  90     $params['rp'] = $rowCount;
  91
  92     if ($context != 'financialBatch') {
  93       // data entry status batches
  94       $params['status_id'] = CRM_Core_PseudoConstant::getKey('CRM_Batch_BAO_Batch', 'status_id', 'Data Entry');
  95     }
  96
  97     $params['context'] = $context;
  98
  99     // get batch list
 100     $batches = CRM_Batch_BAO_Batch::getBatchListSelector($params);
 101
 102     $iFilteredTotal = $iTotal = $params['total'];
 103
 104     if ($context == 'financialBatch') {
 105       $selectorElements = array(
 106         'check',
 107         'batch_name',
 108         'payment_instrument',
 109         'item_count',
 110         'total',
 111         'status',
 112         'created_by',
 113         'links',
 114       );
 115     }
 116     else {
 117       $selectorElements = array(
 118         'batch_name',
 119         'type',
 120         'item_count',
 121         'total',
 122         'status',
 123         'created_by',
 124         'links',
 125       );
 126     }
 127     CRM_Utils_System::setHttpHeader('Content-Type', 'application/json');
 128     echo CRM_Utils_JSON::encodeDataTableSelector($batches, $sEcho, $iTotal, $iFilteredTotal, $selectorElements);
 129     CRM_Utils_System::civiExit();
 130   }
 131
 132 }