tests/phpunit/api/v3/JobTest.php

   1 <?php
   2 /*
   3  +--------------------------------------------------------------------+
   4  | CiviCRM version 4.7                                                |
   5  +--------------------------------------------------------------------+
   6  | Copyright CiviCRM LLC (c) 2004-2016                                |
   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  * File for the CiviCRM APIv3 job functions
  30  *
  31  * @package CiviCRM_APIv3
  32  * @subpackage API_Job
  33  *
  34  * @copyright CiviCRM LLC (c) 2004-2016
  35  * @version $Id: Job.php 30879 2010-11-22 15:45:55Z shot $
  36  *
  37  */
  38
  39 /**
  40  * Class api_v3_JobTest
  41  * @group headless
  42  */
  43 class api_v3_JobTest extends CiviUnitTestCase {
  44   protected $_apiversion = 3;
  45
  46   public $DBResetRequired = FALSE;
  47   public $_entity = 'Job';
  48   public $_params = array();
  49
  50   public function setUp() {
  51     parent::setUp();
  52     $this->useTransaction(TRUE);
  53     $this->_params = array(
  54       'sequential' => 1,
  55       'name' => 'API_Test_Job',
  56       'description' => 'A long description written by hand in cursive',
  57       'run_frequency' => 'Daily',
  58       'api_entity' => 'ApiTestEntity',
  59       'api_action' => 'apitestaction',
  60       'parameters' => 'Semi-formal explanation of runtime job parameters',
  61       'is_active' => 1,
  62     );
  63   }
  64
  65   /**
  66    * Check with no name.
  67    */
  68   public function testCreateWithoutName() {
  69     $params = array(
  70       'is_active' => 1,
  71     );
  72     $this->callAPIFailure('job', 'create', $params,
  73       'Mandatory key(s) missing from params array: run_frequency, name, api_entity, api_action'
  74     );
  75   }
  76
  77   /**
  78    * Create job with an invalid "run_frequency" value.
  79    */
  80   public function testCreateWithInvalidFrequency() {
  81     $params = array(
  82       'sequential' => 1,
  83       'name' => 'API_Test_Job',
  84       'description' => 'A long description written by hand in cursive',
  85       'run_frequency' => 'Fortnightly',
  86       'api_entity' => 'ApiTestEntity',
  87       'api_action' => 'apitestaction',
  88       'parameters' => 'Semi-formal explanation of runtime job parameters',
  89       'is_active' => 1,
  90     );
  91     $this->callAPIFailure('job', 'create', $params);
  92   }
  93
  94   /**
  95    * Create job.
  96    */
  97   public function testCreate() {
  98     $result = $this->callAPIAndDocument('job', 'create', $this->_params, __FUNCTION__, __FILE__);
  99     $this->assertNotNull($result['values'][0]['id']);
 100
 101     // mutate $params to match expected return value
 102     unset($this->_params['sequential']);
 103     //assertDBState compares expected values in $result to actual values in the DB
 104     $this->assertDBState('CRM_Core_DAO_Job', $result['id'], $this->_params);
 105   }
 106
 107   /**
 108    * Check with empty array.
 109    */
 110   public function testDeleteEmpty() {
 111     $params = array();
 112     $result = $this->callAPIFailure('job', 'delete', $params);
 113   }
 114
 115   /**
 116    * Check with No array.
 117    */
 118   public function testDeleteParamsNotArray() {
 119     $result = $this->callAPIFailure('job', 'delete', 'string');
 120   }
 121
 122   /**
 123    * Check if required fields are not passed.
 124    */
 125   public function testDeleteWithoutRequired() {
 126     $params = array(
 127       'name' => 'API_Test_PP',
 128       'title' => 'API Test Payment Processor',
 129       'class_name' => 'CRM_Core_Payment_APITest',
 130     );
 131
 132     $result = $this->callAPIFailure('job', 'delete', $params);
 133     $this->assertEquals($result['error_message'], 'Mandatory key(s) missing from params array: id');
 134   }
 135
 136   /**
 137    * Check with incorrect required fields.
 138    */
 139   public function testDeleteWithIncorrectData() {
 140     $params = array(
 141       'id' => 'abcd',
 142     );
 143     $result = $this->callAPIFailure('job', 'delete', $params);
 144   }
 145
 146   /**
 147    * Check job delete.
 148    */
 149   public function testDelete() {
 150     $createResult = $this->callAPISuccess('job', 'create', $this->_params);
 151     $params = array('id' => $createResult['id']);
 152     $result = $this->callAPIAndDocument('job', 'delete', $params, __FUNCTION__, __FILE__);
 153     $this->assertAPIDeleted($this->_entity, $createResult['id']);
 154   }
 155
 156   /**
 157    *
 158    * public function testCallUpdateGreetingMissingParams() {
 159    * $result = $this->callAPISuccess($this->_entity, 'update_greeting', array('gt' => 1));
 160    * $this->assertEquals('Mandatory key(s) missing from params array: ct', $result['error_message']);
 161    * }
 162    *
 163    * public function testCallUpdateGreetingIncorrectParams() {
 164    * $result = $this->callAPISuccess($this->_entity, 'update_greeting', array('gt' => 1, 'ct' => 'djkfhdskjfhds'));
 165    * $this->assertEquals('ct `djkfhdskjfhds` is not valid.', $result['error_message']);
 166    * }
 167    * /*
 168    * Note that this test is about tesing the metadata / calling of the function & doesn't test the success of the called function
 169    */
 170   public function testCallUpdateGreetingSuccess() {
 171     $result = $this->callAPISuccess($this->_entity, 'update_greeting', array(
 172       'gt' => 'postal_greeting',
 173       'ct' => 'Individual',
 174     ));
 175   }
 176
 177   public function testCallUpdateGreetingCommaSeparatedParamsSuccess() {
 178     $gt = 'postal_greeting,email_greeting,addressee';
 179     $ct = 'Individual,Household';
 180     $result = $this->callAPISuccess($this->_entity, 'update_greeting', array('gt' => $gt, 'ct' => $ct));
 181   }
 182
 183   /**
 184    * Test the call reminder success sends more than 25 reminders & is not incorrectly limited.
 185    *
 186    * Note that this particular test sends the reminders to the additional recipients only
 187    * as no real reminder person is configured
 188    *
 189    * Also note that this is testing a 'job' api so is in this class rather than scheduled_reminder - which
 190    * seems a cleaner place to build up a collection of scheduled reminder testing functions. However, it seems
 191    * that the api itself would need to be moved to the scheduled_reminder fn to do that  with the job wrapper being respected for legacy functions
 192    */
 193   public function testCallSendReminderSuccessMoreThanDefaultLimit() {
 194     $membershipTypeID = $this->membershipTypeCreate();
 195     $this->membershipStatusCreate();
 196     $createTotal = 30;
 197     for ($i = 1; $i <= $createTotal; $i++) {
 198       $contactID = $this->individualCreate();
 199       $groupID = $this->groupCreate(array('name' => $i, 'title' => $i));
 200       $result = $this->callAPISuccess('action_schedule', 'create', array(
 201         'title' => " job $i",
 202         'subject' => "job $i",
 203         'entity_value' => $membershipTypeID,
 204         'mapping_id' => 4,
 205         'start_action_date' => 'membership_join_date',
 206         'start_action_offset' => 0,
 207         'start_action_condition' => 'before',
 208         'start_action_unit' => 'hour',
 209         'group_id' => $groupID,
 210         'limit_to' => FALSE,
 211       ));
 212       $this->callAPISuccess('group_contact', 'create', array(
 213         'contact_id' => $contactID,
 214         'status' => 'Added',
 215         'group_id' => $groupID,
 216       ));
 217     }
 218     $result = $this->callAPISuccess('job', 'send_reminder', array());
 219     $successfulCronCount = CRM_Core_DAO::singleValueQuery("SELECT count(*) FROM civicrm_action_log");
 220     $this->assertEquals($successfulCronCount, $createTotal);
 221   }
 222
 223   /**
 224    * Test scheduled reminders respect limit to (since above identified addition_to handling issue).
 225    *
 226    * We create 3 contacts - 1 is in our group, 1 has our membership & the chosen one has both
 227    * & check that only the chosen one got the reminder
 228    */
 229   public function testCallSendReminderLimitTo() {
 230     $membershipTypeID = $this->membershipTypeCreate();
 231     $this->membershipStatusCreate();
 232     $createTotal = 3;
 233     $groupID = $this->groupCreate(array('name' => 'Texan drawlers', 'title' => 'a...'));
 234     for ($i = 1; $i <= $createTotal; $i++) {
 235       $contactID = $this->individualCreate();
 236       if ($i == 2) {
 237         $theChosenOneID = $contactID;
 238       }
 239       if ($i < 3) {
 240         $this->callAPISuccess('group_contact', 'create', array(
 241           'contact_id' => $contactID,
 242           'status' => 'Added',
 243           'group_id' => $groupID,
 244         ));
 245       }
 246       if ($i > 1) {
 247         $this->callAPISuccess('membership', 'create', array(
 248             'contact_id' => $contactID,
 249             'membership_type_id' => $membershipTypeID,
 250             'join_date' => 'now',
 251             'start_date' => '+ 1 hour',
 252           )
 253         );
 254       }
 255     }
 256     $this->callAPISuccess('action_schedule', 'create', array(
 257       'title' => " remind all Texans",
 258       'subject' => "drawling renewal",
 259       'entity_value' => $membershipTypeID,
 260       'mapping_id' => 4,
 261       'start_action_date' => 'membership_start_date',
 262       'start_action_offset' => 0,
 263       'start_action_condition' => 'before',
 264       'start_action_unit' => 'hour',
 265       'group_id' => $groupID,
 266       'limit_to' => TRUE,
 267     ));
 268     $this->callAPISuccess('job', 'send_reminder', array());
 269     $successfulCronCount = CRM_Core_DAO::singleValueQuery("SELECT count(*) FROM civicrm_action_log");
 270     $this->assertEquals($successfulCronCount, 1);
 271     $sentToID = CRM_Core_DAO::singleValueQuery("SELECT contact_id FROM civicrm_action_log");
 272     $this->assertEquals($sentToID, $theChosenOneID);
 273   }
 274
 275   public function testCallDisableExpiredRelationships() {
 276     $individualID = $this->individualCreate();
 277     $orgID = $this->organizationCreate();
 278     CRM_Utils_Hook_UnitTests::singleton()->setHook('civicrm_pre', array($this, 'hookPreRelationship'));
 279     $relationshipTypeID = $this->callAPISuccess('relationship_type', 'getvalue', array(
 280       'return' => 'id',
 281       'name_a_b' => 'Employee of',
 282     ));
 283     $result = $this->callAPISuccess('relationship', 'create', array(
 284       'relationship_type_id' => $relationshipTypeID,
 285       'contact_id_a' => $individualID,
 286       'contact_id_b' => $orgID,
 287       'is_active' => 1,
 288       'end_date' => 'yesterday',
 289     ));
 290     $relationshipID = $result['id'];
 291     $this->assertEquals('Hooked', $result['values'][$relationshipID]['description']);
 292     $this->callAPISuccess($this->_entity, 'disable_expired_relationships', array());
 293     $result = $this->callAPISuccess('relationship', 'get', array());
 294     $this->assertEquals('Go Go you good thing', $result['values'][$relationshipID]['description']);
 295     $this->contactDelete($individualID);
 296     $this->contactDelete($orgID);
 297   }
 298
 299   /**
 300    * Test the batch merge function.
 301    *
 302    * We are just checking it returns without error here.
 303    */
 304   public function testBatchMerge() {
 305     $this->callAPISuccess('Job', 'process_batch_merge', array());
 306   }
 307
 308   /**
 309    * Test the batch merge function actually works!
 310    *
 311    * @dataProvider getMergeSets
 312    *
 313    * @param $dataSet
 314    */
 315   public function testBatchMergeWorks($dataSet) {
 316     foreach ($dataSet['contacts'] as $params) {
 317       $this->callAPISuccess('Contact', 'create', $params);
 318     }
 319
 320     $result = $this->callAPISuccess('Job', 'process_batch_merge', array('mode' => $dataSet['mode']));
 321     $this->assertEquals($dataSet['skipped'], count($result['values']['skipped']), 'Failed to skip the right number:' . $dataSet['skipped']);
 322     $this->assertEquals($dataSet['merged'], count($result['values']['merged']));
 323     $result = $this->callAPISuccess('Contact', 'get', array('contact_sub_type' => 'Student', 'sequential' => 1));
 324     $this->assertEquals(count($dataSet['expected']), $result['count']);
 325     foreach ($dataSet['expected'] as $index => $contact) {
 326       foreach ($contact as $key => $value) {
 327         $this->assertEquals($value, $result['values'][$index][$key]);
 328       }
 329     }
 330   }
 331
 332   /**
 333    * Test that in aggressive mode our conflicted contacts are merged.
 334    */
 335   public function testBatchMergeAggressive() {
 336
 337   }
 338
 339   /**
 340    * Get data for batch merge.
 341    */
 342   public function getMergeSets() {
 343     $data = array(
 344       array(
 345         array(
 346           'mode' => 'safe',
 347           'contacts' => array(
 348             array(
 349               'first_name' => 'Michael',
 350               'last_name' => 'Jackson',
 351               'email' => 'michael@neverland.com',
 352               'contact_type' => 'Individual',
 353               'contact_sub_type' => 'Student',
 354               'api.Address.create' => array(
 355                 'street_address' => 'big house',
 356                 'location_type_id' => 'Home',
 357               ),
 358             ),
 359             array(
 360               'first_name' => 'Michael',
 361               'last_name' => 'Jackson',
 362               'email' => 'michael@neverland.com',
 363               'contact_type' => 'Individual',
 364               'contact_sub_type' => 'Student',
 365             ),
 366           ),
 367           'skipped' => 0,
 368           'merged' => 1,
 369           'expected' => array(
 370             array(
 371               'first_name' => 'Michael',
 372               'last_name' => 'Jackson',
 373               'email' => 'michael@neverland.com',
 374               'contact_type' => 'Individual',
 375             ),
 376           ),
 377         ),
 378       ),
 379       array(
 380         array(
 381           'mode' => 'safe',
 382           'contacts' => array(
 383             array(
 384               'first_name' => 'Michael',
 385               'last_name' => 'Jackson',
 386               'email' => 'michael@neverland.com',
 387               'contact_type' => 'Individual',
 388               'contact_sub_type' => 'Student',
 389               'api.Address.create' => array(
 390                 'street_address' => 'big house',
 391                 'location_type_id' => 'Home',
 392               ),
 393             ),
 394             array(
 395               'first_name' => 'Michael',
 396               'last_name' => 'Jackson',
 397               'email' => 'michael@neverland.com',
 398               'contact_type' => 'Individual',
 399               'contact_sub_type' => 'Student',
 400               'api.Address.create' => array(
 401                 'street_address' => 'bigger house',
 402                 'location_type_id' => 'Home',
 403               ),
 404             ),
 405           ),
 406           'skipped' => 1,
 407           'merged' => 0,
 408           'expected' => array(
 409             array(
 410               'first_name' => 'Michael',
 411               'last_name' => 'Jackson',
 412               'email' => 'michael@neverland.com',
 413               'contact_type' => 'Individual',
 414               'street_address' => 'big house',
 415             ),
 416             array(
 417               'first_name' => 'Michael',
 418               'last_name' => 'Jackson',
 419               'email' => 'michael@neverland.com',
 420               'contact_type' => 'Individual',
 421               'street_address' => 'bigger house',
 422             ),
 423           ),
 424         ),
 425       ),
 426       array(
 427         array(
 428           'mode' => 'aggressive',
 429           'contacts' => array(
 430             array(
 431               'first_name' => 'Michael',
 432               'last_name' => 'Jackson',
 433               'email' => 'michael@neverland.com',
 434               'contact_type' => 'Individual',
 435               'contact_sub_type' => 'Student',
 436               'api.Address.create' => array(
 437                 'street_address' => 'big house',
 438                 'location_type_id' => 'Home',
 439               ),
 440             ),
 441             array(
 442               'first_name' => 'Michael',
 443               'last_name' => 'Jackson',
 444               'email' => 'michael@neverland.com',
 445               'contact_type' => 'Individual',
 446               'contact_sub_type' => 'Student',
 447               'api.Address.create' => array(
 448                 'street_address' => 'bigger house',
 449                 'location_type_id' => 'Home',
 450               ),
 451             ),
 452           ),
 453           'skipped' => 0,
 454           'merged' => 1,
 455           'expected' => array(
 456             array(
 457               'first_name' => 'Michael',
 458               'last_name' => 'Jackson',
 459               'email' => 'michael@neverland.com',
 460               'contact_type' => 'Individual',
 461               'street_address' => 'big house',
 462             ),
 463           ),
 464         )
 465       ),
 466     );
 467     return $data;
 468   }
 469
 470   /**
 471    * @param $op
 472    * @param string $objectName
 473    * @param int $id
 474    * @param array $params
 475    */
 476   public function hookPreRelationship($op, $objectName, $id, &$params) {
 477     if ($op == 'delete') {
 478       return;
 479     }
 480     if ($params['is_active']) {
 481       $params['description'] = 'Hooked';
 482     }
 483     else {
 484       $params['description'] = 'Go Go you good thing';
 485     }
 486   }
 487
 488 }