CRM/Member/Import/Form/Preview.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  * $Id$
  33  *
  34  */
  35
  36 /**
  37  * This class previews the uploaded file and returns summary
  38  * statistics
  39  */
  40 class CRM_Member_Import_Form_Preview extends CRM_Import_Form_Preview {
  41
  42   /**
  43    * Set variables up before form is built.
  44    *
  45    * @return void
  46    */
  47   public function preProcess() {
  48     $skipColumnHeader = $this->controller->exportValue('DataSource', 'skipColumnHeader');
  49
  50     //get the data from the session
  51     $dataValues = $this->get('dataValues');
  52     $mapper = $this->get('mapper');
  53     $invalidRowCount = $this->get('invalidRowCount');
  54     $conflictRowCount = $this->get('conflictRowCount');
  55     $mismatchCount = $this->get('unMatchCount');
  56
  57     //get the mapping name displayed if the mappingId is set
  58     $mappingId = $this->get('loadMappingId');
  59     if ($mappingId) {
  60       $mapDAO = new CRM_Core_DAO_Mapping();
  61       $mapDAO->id = $mappingId;
  62       $mapDAO->find(TRUE);
  63       $this->assign('loadedMapping', $mappingId);
  64       $this->assign('savedName', $mapDAO->name);
  65     }
  66
  67     if ($skipColumnHeader) {
  68       $this->assign('skipColumnHeader', $skipColumnHeader);
  69       $this->assign('rowDisplayCount', 3);
  70     }
  71     else {
  72       $this->assign('rowDisplayCount', 2);
  73     }
  74
  75     if ($invalidRowCount) {
  76       $urlParams = 'type=' . CRM_Import_Parser::ERROR . '&parser=CRM_Member_Import_Parser';
  77       $this->set('downloadErrorRecordsUrl', CRM_Utils_System::url('civicrm/export', $urlParams));
  78     }
  79
  80     if ($conflictRowCount) {
  81       $urlParams = 'type=' . CRM_Import_Parser::CONFLICT . '&parser=CRM_Member_Import_Parser';
  82       $this->set('downloadConflictRecordsUrl', CRM_Utils_System::url('civicrm/export', $urlParams));
  83     }
  84
  85     if ($mismatchCount) {
  86       $urlParams = 'type=' . CRM_Import_Parser::NO_MATCH . '&parser=CRM_Member_Import_Parser';
  87       $this->set('downloadMismatchRecordsUrl', CRM_Utils_System::url('civicrm/export', $urlParams));
  88     }
  89
  90     $properties = array(
  91       'mapper',
  92       'dataValues',
  93       'columnCount',
  94       'totalRowCount',
  95       'validRowCount',
  96       'invalidRowCount',
  97       'conflictRowCount',
  98       'downloadErrorRecordsUrl',
  99       'downloadConflictRecordsUrl',
 100       'downloadMismatchRecordsUrl',
 101     );
 102
 103     foreach ($properties as $property) {
 104       $this->assign($property, $this->get($property));
 105     }
 106   }
 107
 108   /**
 109    * Process the mapped fields and map it into the uploaded file
 110    * preview the file and extract some summary statistics
 111    *
 112    * @return void
 113    */
 114   public function postProcess() {
 115     $fileName = $this->controller->exportValue('DataSource', 'uploadFile');
 116     $seperator = $this->controller->exportValue('DataSource', 'fieldSeparator');
 117     $skipColumnHeader = $this->controller->exportValue('DataSource', 'skipColumnHeader');
 118     $invalidRowCount = $this->get('invalidRowCount');
 119     $conflictRowCount = $this->get('conflictRowCount');
 120     $onDuplicate = $this->get('onDuplicate');
 121
 122     $mapper = $this->controller->exportValue('MapField', 'mapper');
 123     $mapperKeys = array();
 124     $mapperLocType = array();
 125     $mapperPhoneType = array();
 126     // Note: we keep the multi-dimension array (even thought it's not
 127     // needed in the case of memberships import) so that we can merge
 128     // the common code with contacts import later and subclass contact
 129     // and membership imports from there
 130     foreach ($mapper as $key => $value) {
 131       $mapperKeys[$key] = $mapper[$key][0];
 132
 133       if (!empty($mapper[$key][1]) && is_numeric($mapper[$key][1])) {
 134         $mapperLocType[$key] = $mapper[$key][1];
 135       }
 136       else {
 137         $mapperLocType[$key] = NULL;
 138       }
 139
 140       if (!empty($mapper[$key][2]) && (!is_numeric($mapper[$key][2]))) {
 141         $mapperPhoneType[$key] = $mapper[$key][2];
 142       }
 143       else {
 144         $mapperPhoneType[$key] = NULL;
 145       }
 146     }
 147
 148     $parser = new CRM_Member_Import_Parser_Membership($mapperKeys, $mapperLocType, $mapperPhoneType);
 149
 150     $mapFields = $this->get('fields');
 151
 152     foreach ($mapper as $key => $value) {
 153       $header = array();
 154       if (isset($mapFields[$mapper[$key][0]])) {
 155         $header[] = $mapFields[$mapper[$key][0]];
 156       }
 157       $mapperFields[] = implode(' - ', $header);
 158     }
 159     $parser->run($fileName, $seperator,
 160       $mapperFields,
 161       $skipColumnHeader,
 162       CRM_Import_Parser::MODE_IMPORT,
 163       $this->get('contactType'),
 164       $onDuplicate
 165     );
 166
 167     // add all the necessary variables to the form
 168     $parser->set($this, CRM_Import_Parser::MODE_IMPORT);
 169
 170     // check if there is any error occurred
 171
 172     $errorStack = CRM_Core_Error::singleton();
 173     $errors = $errorStack->getErrors();
 174     $errorMessage = array();
 175
 176     if (is_array($errors)) {
 177       foreach ($errors as $key => $value) {
 178         $errorMessage[] = $value['message'];
 179       }
 180
 181       $errorFile = $fileName['name'] . '.error.log';
 182
 183       if ($fd = fopen($errorFile, 'w')) {
 184         fwrite($fd, implode('\n', $errorMessage));
 185       }
 186       fclose($fd);
 187
 188       $this->set('errorFile', $errorFile);
 189       $urlParams = 'type=' . CRM_Import_Parser::ERROR . '&parser=CRM_Member_Import_Parser';
 190       $this->set('downloadErrorRecordsUrl', CRM_Utils_System::url('civicrm/export', $urlParams));
 191       $urlParams = 'type=' . CRM_Import_Parser::CONFLICT . '&parser=CRM_Member_Import_Parser';
 192       $this->set('downloadConflictRecordsUrl', CRM_Utils_System::url('civicrm/export', $urlParams));
 193       $urlParams = 'type=' . CRM_Import_Parser::NO_MATCH . '&parser=CRM_Member_Import_Parser';
 194       $this->set('downloadMismatchRecordsUrl', CRM_Utils_System::url('civicrm/export', $urlParams));
 195     }
 196   }
 197
 198 }