sql/GenerateData.php

   1 <?php
   2 /**
   3  * +--------------------------------------------------------------------+
   4  * | CiviCRM version 4.7                                                |
   5  * +--------------------------------------------------------------------+
   6  * | Copyright CiviCRM LLC (c) 2004-2015                                |
   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-2015
  32  * $Id$
  33  *
  34  */
  35
  36 /**
  37  * This class generates data for the schema located in Contact.sql
  38  *
  39  * each public method generates data for the concerned table.
  40  * so for example the addContactDomain method generates and adds
  41  * data to the contact_domain table
  42  *
  43  * Data generation is a bit tricky since the data generated
  44  * randomly in one table could be used as a FKEY in another
  45  * table.
  46  *
  47  * In order to ensure that a randomly generated FKEY matches
  48  * a field in the referened table, the field in the referenced
  49  * table is always generated linearly.
  50  *
  51  *
  52  *
  53  *
  54  * Some numbers
  55  *
  56  * Domain ID's - 1 to NUM_DOMAIN
  57  *
  58  * Context - 3/domain
  59  *
  60  * Contact - 1 to NUM_CONTACT
  61  *           80% - Individual
  62  *           10% - Household
  63  *           10% - Organization
  64  *
  65  *           Contact to Domain distribution should be equal.
  66  *
  67  *
  68  * Contact Individual = 1 to 0.8*NUM_CONTACT
  69  *
  70  * Contact Household = 0.8*NUM_CONTACT to 0.9*NUM_CONTACT
  71  *
  72  * Contact Organization = 0.9*NUM_CONTACT to NUM_CONTACT
  73  *
  74  * Assumption is that each household contains 4 individuals
  75  *
  76  */
  77
  78 /**
  79  *
  80  * Note: implication of using of mt_srand(1) in constructor
  81  * The data generated will be done in a consistent manner
  82  * so as to give the same data during each run (but this
  83  * would involve populating the entire db at one go - since
  84  * mt_srand(1) is in the constructor, if one needs to be able
  85  * to get consistent random numbers then the mt_srand(1) shld
  86  * be in each function that adds data to each table.
  87  *
  88  */
  89
  90
  91 require_once '../civicrm.config.php';
  92
  93 // autoload
  94 require_once 'CRM/Core/ClassLoader.php';
  95 CRM_Core_ClassLoader::singleton()->register();
  96
  97 /**
  98  * Class CRM_GCD
  99  */
 100 class CRM_GCD {
 101
 102   /**
 103    * Constants
 104    */
 105
 106   // Set ADD_TO_DB = FALSE to do a dry run
 107   const ADD_TO_DB = TRUE;
 108
 109   const DATA_FILENAME = "sample_data.xml";
 110   const NUM_DOMAIN = 1;
 111   const NUM_CONTACT = 200;
 112   const INDIVIDUAL_PERCENT = 80;
 113   const HOUSEHOLD_PERCENT = 10;
 114   const ORGANIZATION_PERCENT = 10;
 115   const NUM_INDIVIDUAL_PER_HOUSEHOLD = 4;
 116   const NUM_ACTIVITY = 150;
 117
 118   // Location types from the table crm_location_type
 119   const HOME = 1;
 120   const WORK = 2;
 121   const MAIN = 3;
 122   const OTHER = 4;
 123
 124   /**
 125    * Class constructor
 126    */
 127   public function __construct() {
 128     // initialize all the vars
 129     $this->numIndividual = self::INDIVIDUAL_PERCENT * self::NUM_CONTACT / 100;
 130     $this->numHousehold = self::HOUSEHOLD_PERCENT * self::NUM_CONTACT / 100;
 131     $this->numOrganization = self::ORGANIZATION_PERCENT * self::NUM_CONTACT / 100;
 132     $this->numStrictIndividual = $this->numIndividual - ($this->numHousehold * self::NUM_INDIVIDUAL_PER_HOUSEHOLD);
 133
 134     // Parse data file
 135     foreach ((array) simplexml_load_file(self::DATA_FILENAME) as $key => $val) {
 136       $val = (array) $val;
 137       $this->sampleData[$key] = (array) $val['item'];
 138     }
 139     // Init DB
 140     $config = CRM_Core_Config::singleton();
 141
 142     // Relationship types indexed by name_a_b from the table civicrm_relationship_type
 143     $this->relTypes = CRM_Utils_Array::index(array('name_a_b'), CRM_Core_PseudoConstant::relationshipType('name'));
 144
 145   }
 146
 147   /**
 148    * Public wrapper for calling private "add" functions
 149    * Provides user feedback
 150    * @param $itemName
 151    */
 152   public function generate($itemName) {
 153     echo "Generating $itemName\n";
 154     $fn = "add$itemName";
 155     $this->$fn();
 156   }
 157
 158   /**
 159    * this function creates arrays for the following
 160    *
 161    * domain id
 162    * contact id
 163    * contact_location id
 164    * contact_contact_location id
 165    * contact_email uuid
 166    * contact_phone_uuid
 167    * contact_instant_message uuid
 168    * contact_relationship uuid
 169    * contact_task uuid
 170    * contact_note uuid
 171    */
 172   public function initID() {
 173     // get the domain and contact id arrays
 174     $this->domain = range(1, self::NUM_DOMAIN);
 175     shuffle($this->domain);
 176
 177     // Get first contact id
 178     $this->startCid = $cid = CRM_Core_DAO::singleValueQuery("SELECT MAX(id) FROM civicrm_contact");
 179     $this->contact = range($cid + 1, $cid + self::NUM_CONTACT);
 180     shuffle($this->contact);
 181
 182     // get the individual, household  and organizaton contacts
 183     $offset = 0;
 184     $this->Individual = array_slice($this->contact, $offset, $this->numIndividual);
 185     $offset += $this->numIndividual;
 186     $this->Household = array_slice($this->contact, $offset, $this->numHousehold);
 187     $offset += $this->numHousehold;
 188     $this->Organization = array_slice($this->contact, $offset, $this->numOrganization);
 189
 190     // get the strict individual contacts (i.e individual contacts not belonging to any household)
 191     $this->strictIndividual = array_slice($this->Individual, 0, $this->numStrictIndividual);
 192
 193     // get the household to individual mapping array
 194     $this->householdIndividual = array_slice($this->Individual, $this->numStrictIndividual);
 195     $this->householdIndividual = array_chunk($this->householdIndividual, self::NUM_INDIVIDUAL_PER_HOUSEHOLD);
 196     $this->householdIndividual = array_combine($this->Household, $this->householdIndividual);
 197   }
 198
 199   /*********************************
 200    * private members
 201    *********************************/
 202
 203   // enum's from database
 204   private $preferredCommunicationMethod = array('1', '2', '3', '4', '5');
 205   private $contactType = array('Individual', 'Household', 'Organization');
 206   private $phoneType = array('1', '2', '3', '4');
 207
 208   // customizable enums (foreign keys)
 209   private $prefix = array(
 210     // Female
 211     1 => array(
 212       1 => 'Mrs.',
 213       2 => 'Ms.',
 214       4 => 'Dr.',
 215     ),
 216     // Male
 217     2 => array(
 218       3 => 'Mr.',
 219       4 => 'Dr.',
 220     ),
 221   );
 222   private $suffix = array(1 => 'Jr.', 2 => 'Sr.', 3 => 'II', 4 => 'III');
 223   private $gender = array(1 => 'female', 2 => 'male');
 224
 225   // store domain id's
 226   private $domain = array();
 227
 228   // store contact id's
 229   private $contact = array();
 230   private $Individual = array();
 231   private $Household = array();
 232   private $Organization = array();
 233
 234   // store which contacts have a location entity
 235   // for automatic management of is_primary field
 236   private $location = array(
 237     'Email' => array(),
 238     'Phone' => array(),
 239     'Address' => array(),
 240   );
 241
 242   // stores the strict individual id and household id to individual id mapping
 243   private $strictIndividual = array();
 244   private $householdIndividual = array();
 245   private $householdName = array();
 246
 247   // sample data in xml format
 248   private $sampleData = array();
 249
 250   // private vars
 251   private $startCid;
 252   private $numIndividual = 0;
 253   private $numHousehold = 0;
 254   private $numOrganization = 0;
 255   private $numStrictIndividual = 0;
 256   private $stateMap = array();
 257   private $states = array();
 258
 259   private $groupMembershipStatus = array('Added', 'Removed', 'Pending');
 260   private $subscriptionHistoryMethod = array('Admin', 'Email');
 261
 262   /*********************************
 263    * private methods
 264    ********************************
 265    * @param int $size
 266    * @return string
 267    */
 268
 269   /**
 270    * get a randomly generated string
 271    */
 272   private function randomString($size = 32) {
 273     $string = "";
 274
 275     // get an ascii code for each character
 276     for ($i = 0; $i < $size; $i++) {
 277       $random_int = mt_rand(65, 122);
 278       if (($random_int < 97) && ($random_int > 90)) {
 279         // if ascii code between 90 and 97 substitute with space
 280         $random_int = 32;
 281       }
 282       $random_char = chr($random_int);
 283       $string .= $random_char;
 284     }
 285     return $string;
 286   }
 287
 288   /**
 289    * @return string
 290    */
 291   private function randomChar() {
 292     return chr(mt_rand(65, 90));
 293   }
 294
 295   /**
 296    * Get a random item from the sample data or any other array
 297    *
 298    * @param $items (array or string) - if string, used as key for sample data, if array, used as data source
 299    *
 300    * @return mixed (element from array)
 301    *
 302    * @private
 303    */
 304   private function randomItem($items) {
 305     if (!is_array($items)) {
 306       $key = $items;
 307       $items = $this->sampleData[$key];
 308     }
 309     if (!$items) {
 310       echo "Error: no items found for '$key'\n";
 311       return FALSE;
 312     }
 313     return $items[mt_rand(0, count($items) - 1)];
 314   }
 315
 316   /**
 317    * @param $items
 318    *
 319    * @return mixed
 320    */
 321   private function randomIndex($items) {
 322     return $this->randomItem(array_keys($items));
 323   }
 324
 325   /**
 326    * @param $items
 327    *
 328    * @return array
 329    */
 330   private function randomKeyValue($items) {
 331     $key = $this->randomIndex($items);
 332     return array($key, $items[$key]);
 333   }
 334
 335   /**
 336    * @param $chance
 337    *
 338    * @return int
 339    */
 340   private function probability($chance) {
 341     if (mt_rand(0, 100) < ($chance * 100)) {
 342       return 1;
 343     }
 344     return 0;
 345   }
 346
 347   /**
 348    * Generate a random date.
 349    *
 350    *   If both $startDate and $endDate are defined generate
 351    *   date between them.
 352    *
 353    *   If only startDate is specified then date generated is
 354    *   between startDate + 1 year.
 355    *
 356    *   if only endDate is specified then date generated is
 357    *   between endDate - 1 year.
 358    *
 359    *   if none are specified - date is between today - 1year
 360    *   and today
 361    *
 362    * @param  int $startDate Start Date in Unix timestamp
 363    * @param  int $endDate End Date in Unix timestamp
 364    * @access private
 365    *
 366    * @return string randomly generated date in the format "Ymd"
 367    *
 368    */
 369   private function randomDate($startDate = 0, $endDate = 0) {
 370
 371     // number of seconds per year
 372     $numSecond = 31536000;
 373     $dateFormat = "Ymdhis";
 374     $today = time();
 375
 376     // both are defined
 377     if ($startDate && $endDate) {
 378       return date($dateFormat, mt_rand($startDate, $endDate));
 379     }
 380
 381     // only startDate is defined
 382     if ($startDate) {
 383       return date($dateFormat, mt_rand($startDate, $startDate + $numSecond));
 384     }
 385
 386     // only endDate is defined
 387     if ($startDate) {
 388       return date($dateFormat, mt_rand($endDate - $numSecond, $endDate));
 389     }
 390
 391     // none are defined
 392     return date($dateFormat, mt_rand($today - $numSecond, $today));
 393   }
 394
 395   /**
 396    * Automatically manage the is_primary field by tracking which contacts have each item
 397    * @param $cid
 398    * @param $type
 399    * @return int
 400    */
 401   private function isPrimary($cid, $type) {
 402     if (empty($this->location[$type][$cid])) {
 403       $this->location[$type][$cid] = TRUE;
 404       return 1;
 405     }
 406     return 0;
 407   }
 408
 409   /**
 410    * Execute a query unless we are doing a dry run
 411    * Note: this wrapper should not be used for SELECT queries
 412    * @param $query
 413    * @param array $params
 414    * @return \CRM_Core_DAO
 415    */
 416   private function _query($query, $params = array()) {
 417     if (self::ADD_TO_DB) {
 418       return CRM_Core_DAO::executeQuery($query, $params);
 419     }
 420   }
 421
 422   /**
 423    * Call dao insert method unless we are doing a dry run
 424    * @param $dao
 425    */
 426   private function _insert(&$dao) {
 427     if (self::ADD_TO_DB) {
 428       if (!$dao->insert()) {
 429         echo "ERROR INSERT: " . mysql_error() . "\n";
 430         print_r($dao);
 431         exit(1);
 432       }
 433     }
 434   }
 435
 436   /**
 437    * Call dao update method unless we are doing a dry run
 438    * @param $dao
 439    */
 440   private function _update(&$dao) {
 441     if (self::ADD_TO_DB) {
 442       if (!$dao->update()) {
 443         echo "ERROR UPDATE: " . mysql_error() . "\n";
 444         print_r($dao);
 445         exit(1);
 446       }
 447     }
 448   }
 449
 450   /**
 451    * Add core DAO object
 452    * @param $type
 453    * @param $params
 454    */
 455   private function _addDAO($type, $params) {
 456     $daoName = "CRM_Core_DAO_$type";
 457     $obj = new $daoName();
 458     foreach ($params as $key => $value) {
 459       $obj->$key = $value;
 460     }
 461     if (isset($this->location[$type])) {
 462       $obj->is_primary = $this->isPrimary($params['contact_id'], $type);
 463     }
 464     $this->_insert($obj);
 465   }
 466
 467   /**
 468    * Fetch contact type based on stored mapping
 469    * @param $id
 470    * @return string $type
 471    */
 472   private function getContactType($id) {
 473     foreach (array('Individual', 'Household', 'Organization') as $type) {
 474       if (in_array($id, $this->$type)) {
 475         return $type;
 476       }
 477     }
 478   }
 479
 480   /**
 481    * This method adds NUM_DOMAIN domains and then adds NUM_REVISION
 482    * revisions for each domain with the latest revision being the last one..
 483    */
 484   private function addDomain() {
 485
 486     /* Add a location for domain 1 */
 487
 488     $domain = new CRM_Core_DAO_Domain();
 489     for ($id = 2; $id <= self::NUM_DOMAIN; $id++) {
 490       // domain name is pretty simple. it is "Domain $id"
 491       $domain->name = "Domain $id";
 492       $domain->description = "Description $id";
 493       $domain->contact_name = $this->randomName();
 494
 495       // insert domain
 496       $this->_insert($domain);
 497     }
 498   }
 499
 500   /**
 501    * @return string
 502    */
 503   public function randomName() {
 504     $first_name = $this->randomItem(($this->probability(.5) ? 'fe' : '') . 'male_name');
 505     $middle_name = ucfirst($this->randomChar());
 506     $last_name = $this->randomItem('last_name');
 507     return "$first_name $middle_name. $last_name";
 508   }
 509
 510   /**
 511    * This method adds data to the contact table
 512    *
 513    * id - from $contact
 514    * contact_type 'Individual' 'Household' 'Organization'
 515    * preferred_communication (random 1 to 3)
 516    */
 517   private function addContact() {
 518     $contact = new CRM_Contact_DAO_Contact();
 519     $cid = $this->startCid;
 520
 521     for ($id = $cid + 1; $id <= $cid + self::NUM_CONTACT; $id++) {
 522       $contact->contact_type = $this->getContactType($id);
 523       $contact->do_not_phone = $this->probability(.2);
 524       $contact->do_not_email = $this->probability(.2);
 525       $contact->do_not_post = $this->probability(.2);
 526       $contact->do_not_trade = $this->probability(.2);
 527       $contact->preferred_communication_method = NULL;
 528       if ($this->probability(.5)) {
 529         $contact->preferred_communication_method = CRM_Core_DAO::VALUE_SEPARATOR . $this->randomItem($this->preferredCommunicationMethod) . CRM_Core_DAO::VALUE_SEPARATOR;
 530       }
 531       $contact->source = 'Sample Data';
 532       $this->_insert($contact);
 533     }
 534   }
 535
 536   /**
 537    * addIndividual()
 538    *
 539    * This method adds individual's data to the contact table
 540    *
 541    * The following fields are generated and added.
 542    *
 543    * contact_uuid - individual
 544    * contact_rid - latest one
 545    * first_name 'First Name $contact_uuid'
 546    * middle_name 'Middle Name $contact_uuid'
 547    * last_name 'Last Name $contact_uuid'
 548    * job_title 'Job Title $contact_uuid'
 549    *
 550    */
 551   private function addIndividual() {
 552
 553     $contact = new CRM_Contact_DAO_Contact();
 554     $year = 60 * 60 * 24 * 365.25;
 555     $now = time();
 556
 557     foreach ($this->Individual as $cid) {
 558       $contact->is_deceased = $contact->gender_id = $contact->birth_date = $contact->deceased_date = $email = NULL;
 559       list($gender_id, $gender) = $this->randomKeyValue($this->gender);
 560       $birth_date = mt_rand($now - 90 * $year, $now - 10 * $year);
 561
 562       $contact->last_name = $this->randomItem('last_name');
 563
 564       // Manage household names
 565       if (!in_array($contact->id, $this->strictIndividual)) {
 566         // Find position in household
 567         foreach ($this->householdIndividual as $householdId => $house) {
 568           foreach ($house as $position => $memberId) {
 569             if ($memberId == $cid) {
 570               break 2;
 571             }
 572           }
 573         }
 574         // Head of household: set name
 575         if (empty($this->householdName[$householdId])) {
 576           $this->householdName[$householdId] = $contact->last_name;
 577         }
 578         // Kids get household name, spouse might get it
 579         if ($position > 1 || $this->probability(.5)) {
 580           $contact->last_name = $this->householdName[$householdId];
 581         }
 582         elseif ($this->householdName[$householdId] != $contact->last_name) {
 583           // Spouse might hyphenate name
 584           if ($this->probability(.5)) {
 585             $contact->last_name .= '-' . $this->householdName[$householdId];
 586           }
 587           // Kids might hyphenate name
 588           else {
 589             $this->householdName[$householdId] .= '-' . $contact->last_name;
 590           }
 591         }
 592         // Sensible ages and genders
 593         $offset = mt_rand($now - 40 * $year, $now);
 594         // Parents
 595         if ($position < 2) {
 596           $birth_date = mt_rand($offset - 35 * $year, $offset - 20 * $year);
 597           if ($this->probability(.8)) {
 598             $gender_id = 2 - $position;
 599             $gender = $this->gender[$gender_id];
 600           }
 601         }
 602         // Kids
 603         else {
 604           $birth_date = mt_rand($offset - 10 * $year, $offset);
 605         }
 606       }
 607       // Non household people
 608       else {
 609         if ($this->probability(.6)) {
 610           $this->_addAddress($cid);
 611         }
 612       }
 613
 614       $contact->first_name = $this->randomItem($gender . '_name');
 615       $contact->middle_name = $this->probability(.5) ? '' : ucfirst($this->randomChar());
 616       $age = intval(($now - $birth_date) / $year);
 617
 618       // Prefix and suffix by gender and age
 619       $contact->prefix_id = $contact->suffix_id = $prefix = $suffix = NULL;
 620       if ($this->probability(.5) && $age > 20) {
 621         list($contact->prefix_id, $prefix) = $this->randomKeyValue($this->prefix[$gender_id]);
 622         $prefix .= ' ';
 623       }
 624       if ($gender == 'male' && $this->probability(.50)) {
 625         list($contact->suffix_id, $suffix) = $this->randomKeyValue($this->suffix);
 626         $suffix = ' ' . $suffix;
 627       }
 628       if ($this->probability(.7)) {
 629         $contact->gender_id = $gender_id;
 630       }
 631       if ($this->probability(.7)) {
 632         $contact->birth_date = date("Ymd", $birth_date);
 633       }
 634
 635       // Deceased probability based on age
 636       if ($age > 40) {
 637         $contact->is_deceased = $this->probability(($age - 30) / 100);
 638         if ($contact->is_deceased && $this->probability(.7)) {
 639           $contact->deceased_date = $this->randomDate();
 640         }
 641       }
 642
 643       // Add 0, 1 or 2 email address
 644       $count = mt_rand(0, 2);
 645       for ($i = 0; $i < $count; ++$i) {
 646         $email = $this->_individualEmail($contact);
 647         $this->_addEmail($cid, $email, self::HOME);
 648       }
 649
 650       // Add 0, 1 or 2 phones
 651       $count = mt_rand(0, 2);
 652       for ($i = 0; $i < $count; ++$i) {
 653         $this->_addPhone($cid);
 654       }
 655
 656       // Occasionally you get contacts with just an email in the db
 657       if ($this->probability(.2) && $email) {
 658         $contact->first_name = $contact->last_name = $contact->middle_name = NULL;
 659         $contact->is_deceased = $contact->gender_id = $contact->birth_date = $contact->deceased_date = NULL;
 660         $contact->display_name = $contact->sort_name = $email;
 661         $contact->postal_greeting_display = $contact->email_greeting_display = "Dear $email";
 662       }
 663       else {
 664         $contact->display_name = $prefix . $contact->first_name . ' ' . $contact->last_name . $suffix;
 665         $contact->sort_name = $contact->last_name . ', ' . $contact->first_name;
 666         $contact->postal_greeting_display = $contact->email_greeting_display = 'Dear ' . $contact->first_name;
 667       }
 668       $contact->addressee_id = $contact->postal_greeting_id = $contact->email_greeting_id = 1;
 669       $contact->addressee_display = $contact->display_name;
 670       $contact->hash = crc32($contact->sort_name);
 671       $contact->id = $cid;
 672       $this->_update($contact);
 673     }
 674   }
 675
 676   /**
 677    * This method adds household's data to the contact table
 678    *
 679    * The following fields are generated and added.
 680    *
 681    * contact_uuid - household_individual
 682    * contact_rid - latest one
 683    * household_name 'household $contact_uuid primary contact $primary_contact_uuid'
 684    * nick_name 'nick $contact_uuid'
 685    * primary_contact_uuid = $household_individual[$contact_uuid][0];
 686    *
 687    */
 688   private function addHousehold() {
 689
 690     $contact = new CRM_Contact_DAO_Contact();
 691     foreach ($this->Household as $cid) {
 692       // Add address
 693       $this->_addAddress($cid);
 694
 695       $contact->id = $cid;
 696       $contact->household_name = $this->householdName[$cid] . " family";
 697       // need to update the sort name for the main contact table
 698       $contact->display_name = $contact->sort_name = $contact->household_name;
 699       $contact->postal_greeting_id = $contact->email_greeting_id = 5;
 700       $contact->postal_greeting_display = $contact->email_greeting_display = 'Dear ' . $contact->household_name;
 701       $contact->addressee_id = 2;
 702       $contact->addressee_display = $contact->display_name;
 703       $contact->hash = crc32($contact->sort_name);
 704       $this->_update($contact);
 705     }
 706   }
 707
 708   /**
 709    * This method adds organization data to the contact table
 710    *
 711    * The following fields are generated and added.
 712    *
 713    * contact_uuid - organization
 714    * contact_rid - latest one
 715    * organization_name 'organization $contact_uuid'
 716    * legal_name 'legal  $contact_uuid'
 717    * nick_name 'nick $contact_uuid'
 718    * sic_code 'sic $contact_uuid'
 719    * primary_contact_id - random individual contact uuid
 720    *
 721    */
 722   private function addOrganization() {
 723
 724     $org = new CRM_Contact_DAO_Contact();
 725     $employees = $this->Individual;
 726     shuffle($employees);
 727
 728     foreach ($this->Organization as $key => $id) {
 729       $org->primary_contact_id = $website = $email = NULL;
 730       $org->id = $id;
 731       $address = $this->_addAddress($id);
 732
 733       $namePre = $this->randomItem('organization_prefix');
 734       $nameMid = $this->randomItem('organization_name');
 735       $namePost = $this->randomItem('organization_suffix');
 736
 737       // Some orgs are named after their location
 738       if ($this->probability(.7)) {
 739         $place = $this->randomItem(array('city', 'street_name', 'state'));
 740         $namePre = $address[$place];
 741       }
 742       $org->organization_name = "$namePre $nameMid $namePost";
 743
 744       // Most orgs have a website and email
 745       if ($this->probability(.8)) {
 746         $website = $this->_addWebsite($id, $org->organization_name);
 747         $url = str_replace('http://', '', $website['url']);
 748         $email = $this->randomItem('email_address') . '@' . $url;
 749         $this->_addEmail($id, $email, self::MAIN);
 750       }
 751
 752       // current employee
 753       if ($this->probability(.8)) {
 754         $indiv = new CRM_Contact_DAO_Contact();
 755         $org->primary_contact_id = $indiv->id = $employees[$key];
 756         $indiv->organization_name = $org->organization_name;
 757         $indiv->employer_id = $id;
 758         $this->_update($indiv);
 759         // Share address with employee
 760         if ($this->probability(.8)) {
 761           $this->_addAddress($indiv->id, $id);
 762         }
 763         // Add work email for employee
 764         if ($website) {
 765           $indiv->find(TRUE);
 766           $email = $this->_individualEmail($indiv, $url);
 767           $this->_addEmail($indiv->id, $email, self::WORK);
 768         }
 769       }
 770
 771       // need to update the sort name for the main contact table
 772       $org->display_name = $org->sort_name = $org->organization_name;
 773       $org->addressee_id = 3;
 774       $org->addressee_display = $org->display_name;
 775       $org->hash = crc32($org->sort_name);
 776       $this->_update($org);
 777     }
 778   }
 779
 780   /**
 781    * This method adds data to the contact_relationship table
 782    */
 783   private function addRelationship() {
 784
 785     $relationship = new CRM_Contact_DAO_Relationship();
 786
 787     // Household relationships
 788     foreach ($this->householdIndividual as $household_id => $household_member) {
 789       // Default active
 790       $relationship->is_active = 1;
 791
 792       // add child_of relationship for each child
 793       $relationship->relationship_type_id = $this->relTypes['Child of']['id'];
 794       foreach (array(0, 1) as $parent) {
 795         foreach (array(2, 3) as $child) {
 796           $relationship->contact_id_a = $household_member[$child];
 797           $relationship->contact_id_b = $household_member[$parent];
 798           $this->_insert($relationship);
 799         }
 800       }
 801
 802       // add sibling_of relationship
 803       $relationship->relationship_type_id = $this->relTypes['Sibling of']['id'];
 804       $relationship->contact_id_a = $household_member[3];
 805       $relationship->contact_id_b = $household_member[2];
 806       $this->_insert($relationship);
 807
 808       // add member_of_household relationships and shared address
 809       $relationship->relationship_type_id = $this->relTypes['Household Member of']['id'];
 810       $relationship->contact_id_b = $household_id;
 811       for ($i = 1; $i < 4; ++$i) {
 812         $relationship->contact_id_a = $household_member[$i];
 813         $this->_insert($relationship);
 814         $this->_addAddress($household_member[$i], $household_id);
 815       }
 816
 817       // Divorced/separated couples - end relationship and different address
 818       if ($this->probability(.4)) {
 819         $relationship->is_active = 0;
 820         $this->_addAddress($household_member[0]);
 821       }
 822       else {
 823         $this->_addAddress($household_member[0], $household_id);
 824       }
 825
 826       // add head_of_household relationship 1 for head of house
 827       $relationship->relationship_type_id = $this->relTypes['Head of Household for']['id'];
 828       $relationship->contact_id_a = $household_member[0];
 829       $relationship->contact_id_b = $household_id;
 830       $this->_insert($relationship);
 831
 832       // add spouse_of relationship 1 for both the spouses
 833       $relationship->relationship_type_id = $this->relTypes['Spouse of']['id'];
 834       $relationship->contact_id_a = $household_member[1];
 835       $relationship->contact_id_b = $household_member[0];
 836       $this->_insert($relationship);
 837     }
 838
 839     // Add current employer relationships
 840     $this->_query("INSERT INTO civicrm_relationship
 841       (contact_id_a, contact_id_b, relationship_type_id, is_active)
 842       (SELECT id, employer_id, " . $this->relTypes['Employee of']['id'] . ", 1 FROM civicrm_contact WHERE employer_id IN (" . implode(',', $this->Organization) . "))"
 843     );
 844   }
 845
 846   /**
 847    * Create an address for a contact
 848    *
 849    * @param $cid int: contact id
 850    * @param $masterContactId int: set if this is a shared address
 851    *
 852    * @return array
 853    */
 854   private function _addAddress($cid, $masterContactId = NULL) {
 855
 856     // Share existing address
 857     if ($masterContactId) {
 858       $dao = new CRM_Core_DAO_Address();
 859       $dao->is_primary = 1;
 860       $dao->contact_id = $masterContactId;
 861       $dao->find(TRUE);
 862       $dao->master_id = $dao->id;
 863       $dao->id = NULL;
 864       $dao->contact_id = $cid;
 865       $dao->is_primary = $this->isPrimary($cid, 'Address');
 866       $dao->location_type_id = $this->getContactType($masterContactId) == 'Organization' ? self::WORK : self::HOME;
 867       $this->_insert($dao);
 868     }
 869
 870     // Generate new address
 871     else {
 872       $params = array(
 873         'contact_id' => $cid,
 874         'location_type_id' => $this->getContactType($cid) == 'Organization' ? self::MAIN : self::HOME,
 875         'street_number' => mt_rand(1, 1000),
 876         'street_number_suffix' => ucfirst($this->randomChar()),
 877         'street_name' => $this->randomItem('street_name'),
 878         'street_type' => $this->randomItem('street_type'),
 879         'street_number_postdirectional' => $this->randomItem('address_direction'),
 880         'county_id' => 1,
 881       );
 882
 883       $params['street_address'] = $params['street_number'] . $params['street_number_suffix'] . " " . $params['street_name'] . " " . $params['street_type'] . " " . $params['street_number_postdirectional'];
 884
 885       if ($params['location_type_id'] == self::MAIN) {
 886         $params['supplemental_address_1'] = $this->randomItem('supplemental_addresses_1');
 887       }
 888
 889       // Hack to add lat/long (limited to USA based addresses)
 890       list(
 891         $params['country_id'],
 892         $params['state_province_id'],
 893         $params['city'],
 894         $params['postal_code'],
 895         $params['geo_code_1'],
 896         $params['geo_code_2'],
 897         ) = $this->getZipCodeInfo();
 898
 899       $this->_addDAO('Address', $params);
 900       $params['state'] = $this->states[$params['state_province_id']];
 901       return $params;
 902     }
 903   }
 904
 905   /**
 906    * Add a phone number for a contact
 907    *
 908    * @param $cid int: contact id
 909    *
 910    * @return array
 911    */
 912   private function _addPhone($cid) {
 913     $area = $this->probability(.5) ? '' : mt_rand(201, 899);
 914     $pre = mt_rand(201, 899);
 915     $post = mt_rand(1000, 9999);
 916     $params = array(
 917       'location_type_id' => $this->getContactType($cid) == 'Organization' ? self::MAIN : self::HOME,
 918       'contact_id' => $cid,
 919       'phone' => ($area ? "($area) " : '') . "$pre-$post",
 920       'phone_numeric' => $area . $pre . $post,
 921       'phone_type_id' => mt_rand(1, 2),
 922     );
 923     $this->_addDAO('Phone', $params);
 924     return $params;
 925   }
 926
 927   /**
 928    * Add an email for a contact
 929    *
 930    * @param $cid int: contact id
 931    * @param $email
 932    * @param $locationType
 933    *
 934    * @return array
 935    */
 936   private function _addEmail($cid, $email, $locationType) {
 937     $params = array(
 938       'location_type_id' => $locationType,
 939       'contact_id' => $cid,
 940       'email' => $email,
 941     );
 942     $this->_addDAO('Email', $params);
 943     return $params;
 944   }
 945
 946   /**
 947    * Add a website based on organization name
 948    * Using common naming patterns
 949    *
 950    * @param $cid int: contact id
 951    * @param $name str: contact name
 952    *
 953    * @return array
 954    */
 955   private function _addWebsite($cid, $name) {
 956     $part = array_pad(explode(' ', strtolower($name)), 3, '');
 957     if (count($part) > 3) {
 958       // Abbreviate the place name if it's two words
 959       $domain = $part[0][0] . $part[1][0] . $part[2] . $part[3];
 960     }
 961     else {
 962       // Common naming patterns
 963       switch (mt_rand(1, 3)) {
 964         case 1:
 965           $domain = $part[0] . $part[1] . $part[2];
 966           break;
 967
 968         case 2:
 969           $domain = $part[0] . $part[1];
 970           break;
 971
 972         case 3:
 973           $domain = $part[0] . $part[2];
 974           break;
 975       }
 976     }
 977     $params = array(
 978       'website_type_id' => 1,
 979       'location_type_id' => self::MAIN,
 980       'contact_id' => $cid,
 981       'url' => "http://$domain.org",
 982     );
 983     $this->_addDAO('Website', $params);
 984     return $params;
 985   }
 986
 987   /**
 988    * Create an email address based on a person's name
 989    * Using common naming patterns
 990    *
 991    * @param $contact obj: individual contact record
 992    * @param $domain str: supply a domain (i.e. for a work address)
 993    *
 994    * @return string
 995    */
 996   private function _individualEmail($contact, $domain = NULL) {
 997     $first = $contact->first_name;
 998     $last = $contact->last_name;
 999     $f = $first[0];
1000     $l = $last[0];
1001     $m = $contact->middle_name ? $contact->middle_name[0] . '.' : '';
1002     // Common naming patterns
1003     switch (mt_rand(1, 6)) {
1004       case 1:
1005         $email = $first . $last;
1006         break;
1007
1008       case 2:
1009         $email = "$last.$first";
1010         break;
1011
1012       case 3:
1013         $email = $last . $f;
1014         break;
1015
1016       case 4:
1017         $email = $first . $l;
1018         break;
1019
1020       case 5:
1021         $email = "$last.$m$first";
1022         break;
1023
1024       case 6:
1025         $email = "$f$m$last";
1026         break;
1027     }
1028     //to ensure we dont insert
1029     //invalid characters in email
1030     $email = preg_replace("([^a-zA-Z0-9_\.-]*)", "", $email);
1031
1032     // Some people have numbers in their address
1033     if ($this->probability(.4)) {
1034       $email .= mt_rand(1, 99);
1035     }
1036     // Generate random domain if not specified
1037     if (!$domain) {
1038       $domain = $this->randomItem('email_domain') . '.' . $this->randomItem('email_tld');
1039     }
1040     return strtolower($email) . '@' . $domain;
1041   }
1042
1043   /**
1044    * This method populates the civicrm_entity_tag table
1045    */
1046   private function addEntityTag() {
1047
1048     $entity_tag = new CRM_Core_DAO_EntityTag();
1049
1050     // add categories 1,2,3 for Organizations.
1051     for ($i = 0; $i < $this->numOrganization; $i += 2) {
1052       $org_id = $this->Organization[$i];
1053       // echo "org_id = $org_id\n";
1054       $entity_tag->entity_id = $this->Organization[$i];
1055       $entity_tag->entity_table = 'civicrm_contact';
1056       $entity_tag->tag_id = mt_rand(1, 3);
1057       $this->_insert($entity_tag);
1058     }
1059
1060     // add categories 4,5 for Individuals.
1061     for ($i = 0; $i < $this->numIndividual; $i += 2) {
1062       $entity_tag->entity_table = 'civicrm_contact';
1063       $entity_tag->entity_id = $this->Individual[$i];
1064       if (($entity_tag->entity_id) % 3) {
1065         $entity_tag->tag_id = mt_rand(4, 5);
1066         $this->_insert($entity_tag);
1067       }
1068       else {
1069         // some of the individuals are in both categories (4 and 5).
1070         $entity_tag->tag_id = 4;
1071         $this->_insert($entity_tag);
1072         $entity_tag->tag_id = 5;
1073         $this->_insert($entity_tag);
1074       }
1075     }
1076   }
1077
1078   /**
1079    * This method populates the civicrm_group_contact table
1080    */
1081   private function addGroup() {
1082     // add the 3 groups first
1083     foreach ($this->sampleData['group'] as $groupName) {
1084       $group = new CRM_Contact_BAO_Group();
1085       $group->name = $group->title = $groupName;
1086       $group->group_type = "\ 11\ 12\ 1";
1087       $group->visibility = 'Public Pages';
1088       $group->is_active = 1;
1089       $group->save();
1090       $group->buildClause();
1091       $group->save();
1092     }
1093
1094     // 60 are for newsletter
1095     for ($i = 0; $i < 60; $i++) {
1096       $groupContact = new CRM_Contact_DAO_GroupContact();
1097       // newsletter subscribers
1098       $groupContact->group_id = 2;
1099       $groupContact->contact_id = $this->Individual[$i];
1100       // always add members
1101       $groupContact->status = 'Added';
1102
1103       $subscriptionHistory = new CRM_Contact_DAO_SubscriptionHistory();
1104       $subscriptionHistory->contact_id = $groupContact->contact_id;
1105
1106       $subscriptionHistory->group_id = $groupContact->group_id;
1107       $subscriptionHistory->status = $groupContact->status;
1108       // method
1109       $subscriptionHistory->method = $this->randomItem($this->subscriptionHistoryMethod);
1110       $subscriptionHistory->date = $this->randomDate();
1111       if ($groupContact->status != 'Pending') {
1112         $this->_insert($groupContact);
1113       }
1114       $this->_insert($subscriptionHistory);
1115     }
1116
1117     // 15 volunteers
1118     for ($i = 0; $i < 15; $i++) {
1119       $groupContact = new CRM_Contact_DAO_GroupContact();
1120       // Volunteers
1121       $groupContact->group_id = 3;
1122       $groupContact->contact_id = $this->Individual[$i + 60];
1123       // membership status
1124       $groupContact->status = 'Added';
1125
1126       $subscriptionHistory = new CRM_Contact_DAO_SubscriptionHistory();
1127       $subscriptionHistory->contact_id = $groupContact->contact_id;
1128       $subscriptionHistory->group_id = $groupContact->group_id;
1129       $subscriptionHistory->status = $groupContact->status;
1130       // method
1131       $subscriptionHistory->method = $this->randomItem($this->subscriptionHistoryMethod);
1132       $subscriptionHistory->date = $this->randomDate();
1133
1134       if ($groupContact->status != 'Pending') {
1135         $this->_insert($groupContact);
1136       }
1137       $this->_insert($subscriptionHistory);
1138     }
1139
1140     // 8 advisory board group
1141     for ($i = 0; $i < 8; $i++) {
1142       $groupContact = new CRM_Contact_DAO_GroupContact();
1143       // advisory board group
1144       $groupContact->group_id = 4;
1145       $groupContact->contact_id = $this->Individual[$i * 7];
1146       // membership status
1147       $groupContact->status = 'Added';
1148
1149       $subscriptionHistory = new CRM_Contact_DAO_SubscriptionHistory();
1150       $subscriptionHistory->contact_id = $groupContact->contact_id;
1151       $subscriptionHistory->group_id = $groupContact->group_id;
1152       $subscriptionHistory->status = $groupContact->status;
1153       // method
1154       $subscriptionHistory->method = $this->randomItem($this->subscriptionHistoryMethod);
1155       $subscriptionHistory->date = $this->randomDate();
1156
1157       if ($groupContact->status != 'Pending') {
1158         $this->_insert($groupContact);
1159       }
1160       $this->_insert($subscriptionHistory);
1161     }
1162
1163     //In this function when we add groups that time we are cache the contact fields
1164     //But at the end of setup we are appending sample custom data, so for consistency
1165     //reset the cache.
1166     CRM_Core_BAO_Cache::deleteGroup('contact fields');
1167   }
1168
1169   /**
1170    * This method populates the civicrm_note table
1171    */
1172   private function addNote() {
1173     $params = array(
1174       'entity_table' => 'civicrm_contact',
1175       'contact_id' => 1,
1176       'privacy' => 0,
1177     );
1178     for ($i = 0; $i < self::NUM_CONTACT; $i += 10) {
1179       $params['entity_id'] = $this->randomItem($this->contact);
1180       $params['note'] = $this->randomItem('note');
1181       $params['modified_date'] = $this->randomDate();
1182       $this->_addDAO('Note', $params);
1183     }
1184   }
1185
1186   /**
1187    * This method populates the civicrm_activity_history table
1188    */
1189   private function addActivity() {
1190     $contactDAO = new CRM_Contact_DAO_Contact();
1191     $contactDAO->contact_type = 'Individual';
1192     $contactDAO->selectAdd();
1193     $contactDAO->selectAdd('id');
1194     $contactDAO->orderBy('sort_name');
1195     $contactDAO->find();
1196
1197     $count = 0;
1198     $activityContacts = CRM_Core_OptionGroup::values('activity_contacts', FALSE, FALSE, FALSE, NULL, 'name');
1199     while ($contactDAO->fetch()) {
1200       if ($count++ > 2) {
1201         break;
1202       }
1203       for ($i = 0; $i < self::NUM_ACTIVITY; $i++) {
1204         $activityDAO = new CRM_Activity_DAO_Activity();
1205         $activityId = CRM_Core_OptionGroup::values('activity_type', NULL, NULL, NULL, ' AND v.name IN ("Tell A Friend", "Pledge Acknowledgment")');
1206         $activityTypeID = array_rand($activityId);
1207         $activity = CRM_Core_PseudoConstant::activityType();
1208         $activityDAO->activity_type_id = $activityTypeID;
1209         $activityDAO->subject = "Subject for $activity[$activityTypeID]";
1210         $activityDAO->activity_date_time = $this->randomDate();
1211         $activityDAO->status_id = 2;
1212         $this->_insert($activityDAO);
1213
1214         $activityContactDAO = new CRM_Activity_DAO_ActivityContact();
1215         $activityContactDAO->activity_id = $activityDAO->id;
1216         $activityContactDAO->contact_id = $contactDAO->id;
1217         $activityContactDAO->record_type_id = CRM_Utils_Array::key('Activity Source', $activityContacts);
1218         $this->_insert($activityContactDAO);
1219
1220         if ($activityTypeID == 9) {
1221           $activityContactDAO = new CRM_Activity_DAO_ActivityContact();
1222           $activityContactDAO->activity_id = $activityDAO->id;
1223           $activityContactDAO->contact_id = mt_rand(1, 101);
1224           $activityContactDAO->record_type_id = CRM_Utils_Array::key('Activity Targets', $activityContacts);
1225           $this->_insert($activityContactDAO);
1226         }
1227       }
1228     }
1229   }
1230
1231   /**
1232    * @return array
1233    */
1234   public function getZipCodeInfo() {
1235
1236     if (!$this->stateMap) {
1237       $query = 'SELECT id, name, abbreviation from civicrm_state_province where country_id = 1228';
1238       $dao = new CRM_Core_DAO();
1239       $dao->query($query);
1240       $this->stateMap = array();
1241       while ($dao->fetch()) {
1242         $this->stateMap[$dao->abbreviation] = $dao->id;
1243         $this->states[$dao->id] = $dao->name;
1244       }
1245       $dao->free();
1246     }
1247
1248     $offset = mt_rand(1, 43000);
1249     $query = "SELECT city, state, zip, latitude, longitude FROM zipcodes LIMIT $offset, 1";
1250     $dao = new CRM_Core_DAO();
1251     $dao->query($query);
1252     while ($dao->fetch()) {
1253       if ($this->stateMap[$dao->state]) {
1254         $stateID = $this->stateMap[$dao->state];
1255       }
1256       else {
1257         $stateID = 1004;
1258       }
1259
1260       $zip = str_pad($dao->zip, 5, '0', STR_PAD_LEFT);
1261       return array(1228, $stateID, $dao->city, $zip, $dao->latitude, $dao->longitude);
1262     }
1263   }
1264
1265   /**
1266    * @param $zipCode
1267    *
1268    * @return array
1269    */
1270   public static function getLatLong($zipCode) {
1271     $query = "http://maps.google.com/maps?q=$zipCode&output=js";
1272     $userAgent = "Mozilla/5.0 (Macintosh; U; PPC Mac OS X Mach-O; en-US; rv:1.7.5) Gecko/20041107 Firefox/1.0";
1273
1274     $ch = curl_init();
1275     curl_setopt($ch, CURLOPT_URL, $query);
1276     curl_setopt($ch, CURLOPT_HEADER, FALSE);
1277     curl_setopt($ch, CURLOPT_USERAGENT, $userAgent);
1278     curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
1279
1280     // grab URL and pass it to the browser
1281     $outstr = curl_exec($ch);
1282
1283     // close CURL resource, and free up system resources
1284     curl_close($ch);
1285
1286     $preg = "/'(<\?xml.+?)',/s";
1287     preg_match($preg, $outstr, $matches);
1288     if ($matches[1]) {
1289       $xml = simplexml_load_string($matches[1]);
1290       $attributes = $xml->center->attributes();
1291       if (!empty($attributes)) {
1292         return array((float ) $attributes['lat'], (float ) $attributes['lng']);
1293       }
1294     }
1295     return array(NULL, NULL);
1296   }
1297
1298   private function addMembershipType() {
1299     $organizationDAO = new CRM_Contact_DAO_Contact();
1300     $organizationDAO->id = 5;
1301     $organizationDAO->find(TRUE);
1302     $contact_id = $organizationDAO->contact_id;
1303
1304     $membershipType = "INSERT INTO civicrm_membership_type
1305         (name, description, member_of_contact_id, financial_type_id, minimum_fee, duration_unit, duration_interval, period_type, fixed_period_start_day, fixed_period_rollover_day, relationship_type_id, relationship_direction, visibility, weight, is_active)
1306         VALUES
1307         ('General', 'Regular annual membership.', " . $contact_id . ", 2, 100, 'year', 1, 'rolling',null, null, 7, 'b_a', 'Public', 1, 1),
1308         ('Student', 'Discount membership for full-time students.', " . $contact_id . ", 2, 50, 'year', 1, 'rolling', null, null, 7, 'b_a', 'Public', 2, 1),
1309         ('Lifetime', 'Lifetime membership.', " . $contact_id . ", 2, 1200, 'lifetime', 1, 'rolling', null, null, 7, 'b_a', 'Admin', 3, 1);
1310         ";
1311     $this->_query($membershipType);
1312   }
1313
1314   private function addMembership() {
1315     $contact = new CRM_Contact_DAO_Contact();
1316     $contact->query("SELECT id FROM civicrm_contact where contact_type = 'Individual'");
1317     $activityContacts = CRM_Core_OptionGroup::values('activity_contacts', FALSE, FALSE, FALSE, NULL, 'name');
1318     while ($contact->fetch()) {
1319       $contacts[] = $contact->id;
1320     }
1321     shuffle($contacts);
1322
1323     $randomContacts = array_slice($contacts, 20, 30);
1324
1325     $sources = array('Payment', 'Donation', 'Check');
1326     $membershipTypes = array(1, 2);
1327     $membershipTypeNames = array('General', 'Student');
1328     $statuses = array(3, 4);
1329
1330     $membership = "
1331 INSERT INTO civicrm_membership
1332         (contact_id, membership_type_id, join_date, start_date, end_date, source, status_id)
1333 VALUES
1334 ";
1335
1336     $activity = "
1337 INSERT INTO civicrm_activity
1338         (source_record_id, activity_type_id, subject, activity_date_time, duration, location, phone_id, phone_number, details, priority_id,parent_id, is_test, status_id)
1339 VALUES
1340 ";
1341
1342     $activityContact = "
1343 INSERT INTO civicrm_activity_contact
1344   (activity_id, contact_id, record_type_id)
1345 VALUES
1346 ";
1347
1348     $currentActivityID = CRM_Core_DAO::singleValueQuery("SELECT MAX(id) FROM civicrm_activity");
1349     $sourceID = CRM_Utils_Array::key('Activity Source', $activityContacts);
1350     foreach ($randomContacts as $count => $dontCare) {
1351       $source = $this->randomItem($sources);
1352       $activitySourceId = $count + 1;
1353       $currentActivityID++;
1354       $activityContact .= "( $currentActivityID, {$randomContacts[$count]}, {$sourceID} )";
1355       if ((($count + 1) % 11 == 0)) {
1356         // lifetime membership, status can be anything
1357         $startDate = date('Y-m-d', mktime(0, 0, 0, date('m'), (date('d') - $count), date('Y')));
1358         $membership .= "( {$randomContacts[$count]}, 3, '{$startDate}', '{$startDate}', null, '{$source}', 1)";
1359         $activity .= "( {$activitySourceId}, 7, 'Lifetime', '{$startDate} 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 )";
1360       }
1361       elseif (($count + 1) % 5 == 0) {
1362         // Grace or expired, memberhsip type is random of 1 & 2
1363         $randIndex = array_rand($membershipTypes);
1364         $membershipTypeId = $membershipTypes[$randIndex];
1365         $membershipStatusId = $statuses[$randIndex];
1366         $membershipTypeName = $membershipTypeNames[$randIndex];
1367         $YearFactor = $membershipTypeId * 2;
1368         //reverse the type and consider as year factor.
1369         if ($YearFactor != 2) {
1370           $YearFactor = 1;
1371         }
1372         $dateFactor = ($count * ($YearFactor) * ($YearFactor) * ($YearFactor));
1373         $startDate = date('Y-m-d', mktime(0, 0, 0,
1374           date('m'),
1375           (date('d') - ($dateFactor)),
1376           (date('Y') - ($YearFactor))
1377         ));
1378         $partOfDate = explode('-', $startDate);
1379         $endDate = date('Y-m-d', mktime(0, 0, 0,
1380           $partOfDate[1],
1381           ($partOfDate[2] - 1),
1382           ($partOfDate[0] + ($YearFactor))
1383         ));
1384
1385         $membership .= "( {$randomContacts[$count]}, {$membershipTypeId}, '{$startDate}', '{$startDate}', '{$endDate}', '{$source}', {$membershipStatusId})";
1386         $activity .= "( {$activitySourceId}, 7, '{$membershipTypeName}', '{$startDate} 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 )";
1387       }
1388       elseif (($count + 1) % 2 == 0) {
1389         // membership type 2
1390         $startDate = date('Y-m-d', mktime(0, 0, 0, date('m'), (date('d') - $count), date('Y')));
1391         $endDate = date('Y-m-d', mktime(0, 0, 0, date('m'), (date('d') - ($count + 1)), (date('Y') + 1)));
1392         $membership .= "( {$randomContacts[$count]}, 2, '{$startDate}', '{$startDate}', '{$endDate}', '{$source}', 1)";
1393         $activity .= "( {$activitySourceId}, 7, 'Student', '{$startDate} 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 )";
1394       }
1395       else {
1396         // membership type 1
1397         $startDate = date('Y-m-d', mktime(0, 0, 0, date('m'), (date('d') - $count), date('Y')));
1398         $endDate = date('Y-m-d', mktime(0, 0, 0, date('m'), (date('d') - ($count + 1)), (date('Y') + 2)));
1399         $membership .= "( {$randomContacts[$count]}, 1, '{$startDate}', '{$startDate}', '{$endDate}', '{$source}', 1)";
1400         $activity .= "( {$activitySourceId}, 7, 'General', '{$startDate} 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 )";
1401       }
1402
1403       if ($count != 29) {
1404         $membership .= ",";
1405         $activity .= ",";
1406         $activityContact .= ",";
1407       }
1408     }
1409
1410     $this->_query($membership);
1411     $this->_query($activity);
1412     $this->_query($activityContact);
1413   }
1414
1415   /**
1416    * @param $date
1417    *
1418    * @return string
1419    */
1420   public static function repairDate($date) {
1421     $dropArray = array('-' => '', ':' => '', ' ' => '');
1422     return strtr($date, $dropArray);
1423   }
1424
1425   private function addMembershipLog() {
1426     $membership = new CRM_Member_DAO_Membership();
1427     $membership->query("SELECT id FROM civicrm_membership");
1428     while ($membership->fetch()) {
1429       $ids[] = $membership->id;
1430     }
1431     foreach ($ids as $id) {
1432       $membership = new CRM_Member_DAO_Membership();
1433       $membership->id = $id;
1434       $membershipLog = new CRM_Member_DAO_MembershipLog();
1435       if ($membership->find(TRUE)) {
1436         $membershipLog->membership_id = $membership->id;
1437         $membershipLog->status_id = $membership->status_id;
1438         $membershipLog->start_date = self::repairDate($membership->start_date);
1439         $membershipLog->end_date = self::repairDate($membership->end_date);
1440         $membershipLog->modified_id = $membership->contact_id;
1441         $membershipLog->modified_date = date("Ymd");
1442         $membershipLog->membership_type_id = $membership->membership_type_id;
1443         $membershipLog->save();
1444       }
1445       $membershipLog = NULL;
1446     }
1447   }
1448
1449   private function addEvent() {
1450     $event = "INSERT INTO civicrm_address ( contact_id, location_type_id, is_primary, is_billing, street_address, street_number, street_number_suffix, street_number_predirectional, street_name, street_type, street_number_postdirectional, street_unit, supplemental_address_1, supplemental_address_2, supplemental_address_3, city, county_id, state_province_id, postal_code_suffix, postal_code, usps_adc, country_id, geo_code_1, geo_code_2, timezone)
1451       VALUES
1452       ( NULL, 1, 1, 1, '14S El Camino Way E', 14, 'S', NULL, 'El Camino', 'Way', NULL, NULL, NULL, NULL, NULL, 'Collinsville', NULL, 1006, NULL, '6022', NULL, 1228, 41.8328, -72.9253, NULL),
1453       ( NULL, 1, 1, 1, '11B Woodbridge Path SW', 11, 'B', NULL, 'Woodbridge', 'Path', NULL, NULL, NULL, NULL, NULL, 'Dayton', NULL, 1034, NULL, '45417', NULL, 1228, 39.7531, -84.2471, NULL),
1454       ( NULL, 1, 1, 1, '581O Lincoln Dr SW', 581, 'O', NULL, 'Lincoln', 'Dr', NULL, NULL, NULL, NULL, NULL, 'Santa Fe', NULL, 1030, NULL, '87594', NULL, 1228, 35.5212, -105.982, NULL)
1455       ";
1456     $this->_query($event);
1457
1458     $sql = "SELECT id from civicrm_address where street_address = '14S El Camino Way E'";
1459     $eventAdd1 = CRM_Core_DAO::singleValueQuery($sql);
1460     $sql = "SELECT id from civicrm_address where street_address = '11B Woodbridge Path SW'";
1461     $eventAdd2 = CRM_Core_DAO::singleValueQuery($sql);
1462     $sql = "SELECT id from civicrm_address where street_address = '581O Lincoln Dr SW'";
1463     $eventAdd3 = CRM_Core_DAO::singleValueQuery($sql);
1464
1465     $event = "INSERT INTO civicrm_email (contact_id, location_type_id, email, is_primary, is_billing, on_hold, hold_date, reset_date)
1466        VALUES
1467        (NULL, 1, 'development@example.org', 0, 0, 0, NULL, NULL),
1468        (NULL, 1, 'tournaments@example.org', 0, 0, 0, NULL, NULL),
1469        (NULL, 1, 'celebration@example.org', 0, 0, 0, NULL, NULL)
1470        ";
1471     $this->_query($event);
1472
1473     $sql = "SELECT id from civicrm_email where email = 'development@example.org'";
1474     $eventEmail1 = CRM_Core_DAO::singleValueQuery($sql);
1475     $sql = "SELECT id from civicrm_email where email = 'tournaments@example.org'";
1476     $eventEmail2 = CRM_Core_DAO::singleValueQuery($sql);
1477     $sql = "SELECT id from civicrm_email where email = 'celebration@example.org'";
1478     $eventEmail3 = CRM_Core_DAO::singleValueQuery($sql);
1479
1480     $event = "INSERT INTO civicrm_phone (contact_id, location_type_id, is_primary, is_billing, mobile_provider_id, phone, phone_numeric, phone_type_id)
1481        VALUES
1482        (NULL, 1, 0, 0, NULL, '204 222-1000', '2042221000', '1'),
1483        (NULL, 1, 0, 0, NULL, '204 223-1000', '2042231000', '1'),
1484        (NULL, 1, 0, 0, NULL, '303 323-1000', '3033231000', '1')
1485        ";
1486     $this->_query($event);
1487
1488     $sql = "SELECT id from civicrm_phone where phone = '204 222-1000'";
1489     $eventPhone1 = CRM_Core_DAO::singleValueQuery($sql);
1490     $sql = "SELECT id from civicrm_phone where phone = '204 223-1000'";
1491     $eventPhone2 = CRM_Core_DAO::singleValueQuery($sql);
1492     $sql = "SELECT id from civicrm_phone where phone = '303 323-1000'";
1493     $eventPhone3 = CRM_Core_DAO::singleValueQuery($sql);
1494
1495     $event = "INSERT INTO civicrm_loc_block ( address_id, email_id, phone_id, address_2_id, email_2_id, phone_2_id)
1496        VALUES
1497       ( $eventAdd1, $eventEmail1, $eventPhone1, NULL,NULL,NULL),
1498       ( $eventAdd2, $eventEmail2, $eventPhone2, NULL,NULL,NULL),
1499       ( $eventAdd3, $eventEmail3, $eventPhone3, NULL,NULL,NULL)
1500        ";
1501
1502     $this->_query($event);
1503
1504     $sql = "SELECT id from civicrm_loc_block where phone_id = $eventPhone1 AND email_id = $eventEmail1 AND address_id = $eventAdd1";
1505     $eventLok1 = CRM_Core_DAO::singleValueQuery($sql);
1506     $sql = "SELECT id from civicrm_loc_block where phone_id = $eventPhone2 AND email_id = $eventEmail2 AND address_id = $eventAdd2";
1507     $eventLok2 = CRM_Core_DAO::singleValueQuery($sql);
1508     $sql = "SELECT id from civicrm_loc_block where phone_id = $eventPhone3 AND email_id = $eventEmail3 AND address_id = $eventAdd3";
1509     $eventLok3 = CRM_Core_DAO::singleValueQuery($sql);
1510
1511     $event = "INSERT INTO civicrm_event
1512         ( title, summary, description, event_type_id, participant_listing_id, is_public, start_date, end_date, is_online_registration, registration_link_text, max_participants, event_full_text, is_monetary, financial_type_id, is_map, is_active, fee_label, is_show_location, loc_block_id,intro_text, footer_text, confirm_title, confirm_text, confirm_footer_text, is_email_confirm, confirm_email_text, confirm_from_name, confirm_from_email, cc_confirm, bcc_confirm, default_fee_id, thankyou_title, thankyou_text, thankyou_footer_text, is_pay_later, pay_later_text, pay_later_receipt, is_multiple_registrations, allow_same_participant_emails, currency )
1513         VALUES
1514         ( 'Fall Fundraiser Dinner', 'Kick up your heels at our Fall Fundraiser Dinner/Dance at Glen Echo Park! Come by yourself or bring a partner, friend or the entire family!', 'This event benefits our teen programs. Admission includes a full 3 course meal and wine or soft drinks. Grab your dancing shoes, bring the kids and come join the party!', 3, 1, 1, '" . date('Y-m-d 17:00:00', strtotime("+6 months")) . "', '" . date('Y-m-d 17:00:00', strtotime("+6 months +2 days")) . "', 1, 'Register Now', 100, 'Sorry! The Fall Fundraiser Dinner is full. Please call Jane at 204 222-1000 ext 33 if you want to be added to the waiting list.', 1, 4, 1, 1, 'Dinner Contribution', 1 ,$eventLok1,'Fill in the information below to join as at this wonderful dinner event.', NULL, 'Confirm Your Registration Information', 'Review the information below carefully.', NULL, 1, 'Contact the Development Department if you need to make any changes to your registration.', 'Fundraising Dept.', 'development@example.org', NULL, NULL, NULL, 'Thanks for Registering!', '<p>Thank you for your support. Your contribution will help us build even better tools.</p><p>Please tell your friends and colleagues about this wonderful event.</p>', '<p><a href=http://civicrm.org>Back to CiviCRM Home Page</a></p>', 1, 'I will send payment by check', 'Send a check payable to Our Organization within 3 business days to hold your reservation. Checks should be sent to: 100 Main St., Suite 3, San Francisco CA 94110', 1, 0, 'USD' ),
1515         ( 'Summer Solstice Festival Day Concert', 'Festival Day is coming! Join us and help support your parks.', 'We will gather at noon, learn a song all together,  and then join in a joyous procession to the pavilion. We will be one of many groups performing at this wonderful concert which benefits our city parks.', 5, 1, 1, '" . date('Y-m-d 12:00:00', strtotime("-1 day")) . "', '" . date('Y-m-d 17:00:00', strtotime("-1 day")) . "', 1, 'Register Now', 50, 'We have all the singers we can handle. Come to the pavilion anyway and join in from the audience.', 1, 2, NULL, 1, 'Festival Fee', 1, $eventLok2, 'Complete the form below and click Continue to register online for the festival. Or you can register by calling us at 204 222-1000 ext 22.', '', 'Confirm Your Registration Information', '', '', 1, 'This email confirms your registration. If you have questions or need to change your registration - please do not hesitate to call us.', 'Event Dept.', 'events@example.org', '', NULL, NULL, 'Thanks for Your Joining In!', '<p>Thank you for your support. Your participation will help build new parks.</p><p>Please tell your friends and colleagues about the concert.</p>', '<p><a href=http://civicrm.org>Back to CiviCRM Home Page</a></p>', 0, NULL, NULL, 1, 0, 'USD' ),
1516         ( 'Rain-forest Cup Youth Soccer Tournament', 'Sign up your team to participate in this fun tournament which benefits several Rain-forest protection groups in the Amazon basin.', 'This is a FYSA Sanctioned Tournament, which is open to all USSF/FIFA affiliated organizations for boys and girls in age groups: U9-U10 (6v6), U11-U12 (8v8), and U13-U17 (Full Sided).', 3, 1, 1, '" . date('Y-m-d 07:00:00', strtotime("+7 months")) . "', '" . date('Y-m-d 17:00:00', strtotime("+7 months +3 days")) . "', 1, 'Register Now', 500, 'Sorry! All available team slots for this tournament have been filled. Contact Jill Futbol for information about the waiting list and next years event.', 1, 4, NULL, 1, 'Tournament Fees',1, $eventLok3, 'Complete the form below to register your team for this year''s tournament.', '<em>A Soccer Youth Event</em>', 'Review and Confirm Your Registration Information', '', '<em>A Soccer Youth Event</em>', 1, 'Contact our Tournament Director for eligibility details.', 'Tournament Director', 'tournament@example.org', '', NULL, NULL, 'Thanks for Your Support!', '<p>Thank you for your support. Your participation will help save thousands of acres of rainforest.</p>', '<p><a href=http://civicrm.org>Back to CiviCRM Home Page</a></p>', 0, NULL, NULL, 0, 0, 'USD' )
1517          ";
1518     $this->_query($event);
1519
1520     //CRM-4464
1521     $eventTemplates = "INSERT INTO civicrm_event
1522         ( is_template, template_title, event_type_id, default_role_id, participant_listing_id, is_public, is_monetary, is_online_registration, is_multiple_registrations, allow_same_participant_emails, is_email_confirm, financial_type_id, fee_label, confirm_title, thankyou_title, confirm_from_name, confirm_from_email, is_active, currency )
1523         VALUES
1524         ( 1, 'Free Meeting without Online Registration', 4, 1, 1, 1, 0, 0, null, null, null, null,             null, null, null, null, null, 1, 'USD'  ),
1525         ( 1, 'Free Meeting with Online Registration',    4, 1, 1, 1, 0, 1,    1,    1,    0, null,             null, 'Confirm Your Registration Information', 'Thanks for Registering!', null, null, 1, 'USD'  ),
1526         ( 1, 'Paid Conference with Online Registration', 1, 1, 1, 1, 1, 1,    1,    1,    1,     4, 'Conference Fee', 'Confirm Your Registration Information', 'Thanks for Registering!', 'Event Template Dept.', 'event_templates@example.org', 1, 'USD' )";
1527
1528     $this->_query($eventTemplates);
1529
1530     $ufJoinValues = $tellFriendValues = array();
1531     $profileID = CRM_Core_DAO::singleValueQuery("Select id from civicrm_uf_group where name ='event_registration'");
1532
1533     // grab id's for all events and event templates
1534     $query = "
1535 SELECT  id
1536   FROM  civicrm_event";
1537
1538     $template = CRM_Core_DAO::executeQuery($query);
1539     while ($template->fetch()) {
1540       if ($profileID) {
1541         $ufJoinValues[] = "( 1, 'CiviEvent', 'civicrm_event', {$template->id}, 1, {$profileID} )";
1542       }
1543       $tellFriendValues[] = "( 'civicrm_event', {$template->id}, 'Tell A Friend', '<p>Help us spread the word about this event. Use the space below to personalize your email message - let your friends know why you''re attending. Then fill in the name(s) and email address(es) and click ''Send Your Message''.</p>', 'Thought you might be interested in checking out this event. I''m planning on attending.', NULL, 'Thanks for Spreading the Word', '<p>Thanks for spreading the word about this event to your friends.</p>', 1)";
1544     }
1545
1546     //insert values in civicrm_uf_join for the required event_registration profile - CRM-9587
1547     if (!empty($ufJoinValues)) {
1548       $includeProfile = "INSERT INTO civicrm_uf_join
1549                                (is_active, module, entity_table, entity_id, weight, uf_group_id )
1550                                VALUES " . implode(',', $ufJoinValues);
1551       $this->_query($includeProfile);
1552     }
1553
1554     //insert values in civicrm_tell_friend
1555     if (!empty($tellFriendValues)) {
1556       $tellFriend = "INSERT INTO civicrm_tell_friend
1557                            (entity_table, entity_id, title, intro, suggested_message,
1558                            general_link,  thankyou_title, thankyou_text, is_active)
1559                            VALUES " . implode(',', $tellFriendValues);
1560       $this->_query($tellFriend);
1561     }
1562   }
1563
1564   private function addParticipant() {
1565     $contact = new CRM_Contact_DAO_Contact();
1566     $contact->query("SELECT id FROM civicrm_contact");
1567     while ($contact->fetch()) {
1568       $contacts[] = $contact->id;
1569     }
1570     shuffle($contacts);
1571     $randomContacts = array_slice($contacts, 20, 50);
1572
1573     $participant = "
1574 INSERT INTO civicrm_participant
1575         (contact_id, event_id, status_id, role_id, register_date, source, fee_level, is_test, fee_amount, fee_currency)
1576 VALUES
1577         ( " . $randomContacts[0] . ", 1, 1, 1, '2009-01-21', 'Check', 'Single', 0, 50, 'USD'),
1578         ( " . $randomContacts[1] . ", 2, 2, 2, '2008-05-07', 'Credit Card', 'Soprano', 0, 50, 'USD'),
1579         ( " . $randomContacts[2] . ", 3, 3, 3, '2008-05-05', 'Credit Card', 'Tiny-tots (ages 5-8)', 0, 800, 'USD') ,
1580         ( " . $randomContacts[3] . ", 1, 4, 4, '2008-10-21', 'Direct Transfer', 'Single', 0, 50, 'USD'),
1581         ( " . $randomContacts[4] . ", 2, 1, 1, '2008-01-10', 'Check', 'Soprano', 0, 50, 'USD'),
1582         ( " . $randomContacts[5] . ", 3, 2, 2, '2008-03-05', 'Direct Transfer', 'Tiny-tots (ages 5-8)', 0, 800, 'USD'),
1583         ( " . $randomContacts[6] . ", 1, 3, 3, '2009-07-21', 'Direct Transfer', 'Single', 0, 50, 'USD'),
1584         ( " . $randomContacts[7] . ", 2, 4, 4, '2009-03-07', 'Credit Card', 'Soprano', 0, 50, 'USD'),
1585         ( " . $randomContacts[8] . ", 3, 1, 1, '2008-02-05', 'Direct Transfer', 'Tiny-tots (ages 5-8)', 0, 800, 'USD'),
1586         ( " . $randomContacts[9] . ", 1, 2, 2, '2008-02-01', 'Check', 'Single', 0, 50, 'USD'),
1587         ( " . $randomContacts[10] . ", 2, 3, 3, '2009-01-10', 'Direct Transfer', 'Soprano', 0, 50, 'USD'),
1588         ( " . $randomContacts[11] . ", 3, 4, 4, '2009-03-06', 'Credit Card', 'Tiny-tots (ages 5-8)', 0, 800, 'USD'),
1589         ( " . $randomContacts[12] . ", 1, 1, 2, '2008-06-04', 'Credit Card', 'Single', 0, 50, 'USD'),
1590         ( " . $randomContacts[13] . ", 2, 2, 3, '2008-01-10', 'Direct Transfer', 'Soprano', 0, 50, 'USD'),
1591         ( " . $randomContacts[14] . ", 3, 4, 1, '2008-07-04', 'Check', 'Tiny-tots (ages 5-8)', 0, 800, 'USD'),
1592         ( " . $randomContacts[15] . ", 1, 4, 2, '2009-01-21', 'Credit Card', 'Single', 0, 50, 'USD'),
1593         ( " . $randomContacts[16] . ", 2, 2, 3, '2008-01-10', 'Credit Card', 'Soprano', 0, 50, 'USD'),
1594         ( " . $randomContacts[17] . ", 3, 3, 1, '2009-03-05', 'Credit Card', 'Tiny-tots (ages 5-8)', 0, 800, 'USD'),
1595         ( " . $randomContacts[18] . ", 1, 2, 1, '2008-10-21', 'Direct Transfer', 'Single', 0, 50, 'USD'),
1596         ( " . $randomContacts[19] . ", 2, 4, 1, '2009-01-10', 'Credit Card', 'Soprano', 0, 50, 'USD'),
1597         ( " . $randomContacts[20] . ", 3, 1, 4, '2008-03-25', 'Check', 'Tiny-tots (ages 5-8)', 0, 800, 'USD'),
1598         ( " . $randomContacts[21] . ", 1, 2, 3, '2009-10-21', 'Direct Transfer', 'Single', 0, 50, 'USD'),
1599         ( " . $randomContacts[22] . ", 2, 4, 1, '2008-01-10', 'Direct Transfer', 'Soprano', 0, 50, 'USD'),
1600         ( " . $randomContacts[23] . ", 3, 3, 1, '2008-03-11', 'Credit Card', 'Tiny-tots (ages 5-8)', 0, 800, 'USD'),
1601         ( " . $randomContacts[24] . ", 3, 2, 2, '2008-04-05', 'Direct Transfer', 'Tiny-tots (ages 5-8)', 0, 800, 'USD'),
1602         ( " . $randomContacts[25] . ", 1, 1, 1, '2009-01-21', 'Check', 'Single', 0, 50, 'USD'),
1603         ( " . $randomContacts[26] . ", 2, 2, 2, '2008-05-07', 'Credit Card', 'Soprano', 0, 50, 'USD'),
1604         ( " . $randomContacts[27] . ", 3, 3, 3, '2009-12-12', 'Direct Transfer', 'Tiny-tots (ages 5-8)', 0, 800, 'USD'),
1605         ( " . $randomContacts[28] . ", 1, 4, 4, '2009-12-13', 'Credit Card', 'Single', 0, 50, 'USD'),
1606         ( " . $randomContacts[29] . ", 2, 1, 1, '2009-12-14', 'Direct Transfer', 'Soprano', 0, 50, 'USD'),
1607         ( " . $randomContacts[30] . ", 3, 2, 2, '2009-12-15', 'Credit Card', 'Tiny-tots (ages 5-8)', 0, 800, 'USD'),
1608         ( " . $randomContacts[31] . ", 1, 3, 3, '2009-07-21', 'Check', 'Single', 0, 50, 'USD'),
1609         ( " . $randomContacts[32] . ", 2, 4, 4, '2009-03-07', 'Direct Transfer', 'Soprano', 0, 50, 'USD'),
1610         ( " . $randomContacts[33] . ", 3, 1, 1, '2009-12-15', 'Credit Card', 'Tiny-tots (ages 5-8)', 0, 800, 'USD'),
1611         ( " . $randomContacts[34] . ", 1, 2, 2, '2009-12-13', 'Direct Transfer', 'Single', 0, 50, 'USD'),
1612         ( " . $randomContacts[35] . ", 2, 3, 3, '2009-01-10', 'Direct Transfer', 'Soprano', 0, 50, 'USD'),
1613         ( " . $randomContacts[36] . ", 3, 4, 4, '2009-03-06', 'Check', 'Tiny-tots (ages 5-8)', 0, 800, 'USD'),
1614         ( " . $randomContacts[37] . ", 1, 1, 2, '2009-12-13', 'Direct Transfer', 'Single', 0, 50, 'USD'),
1615         ( " . $randomContacts[38] . ", 2, 2, 3, '2008-01-10', 'Direct Transfer', 'Soprano', 0, 50, 'USD'),
1616         ( " . $randomContacts[39] . ", 3, 4, 1, '2009-12-14', 'Credit Card', 'Tiny-tots (ages 5-8)', 0, 800, 'USD'),
1617         ( " . $randomContacts[40] . ", 1, 4, 2, '2009-01-21', 'Credit Card', 'Single', 0, 50, 'USD'),
1618         ( " . $randomContacts[41] . ", 2, 2, 3, '2009-12-15', 'Credit Card', 'Soprano', 0, 50, 'USD'),
1619         ( " . $randomContacts[42] . ", 3, 3, 1, '2009-03-05', 'Credit Card', 'Tiny-tots (ages 5-8)', 0, 800, 'USD'),
1620         ( " . $randomContacts[43] . ", 1, 2, 1, '2009-12-13', 'Direct Transfer', 'Single', 0, 50, 'USD'),
1621         ( " . $randomContacts[44] . ", 2, 4, 1, '2009-01-10', 'Direct Transfer', 'Soprano', 0, 50, 'USD'),
1622         ( " . $randomContacts[45] . ", 3, 1, 4, '2009-12-13', 'Check', 'Tiny-tots (ages 5-8)', 0, 800, 'USD'),
1623         ( " . $randomContacts[46] . ", 1, 2, 3, '2009-10-21', 'Credit Card', 'Single', 0, 50, 'USD'),
1624         ( " . $randomContacts[47] . ", 2, 4, 1, '2009-12-10', 'Credit Card', 'Soprano', 0, 50, 'USD'),
1625         ( " . $randomContacts[48] . ", 3, 3, 1, '2009-03-11', 'Credit Card', 'Tiny-tots (ages 5-8)', 0, 800, 'USD'),
1626         ( " . $randomContacts[49] . ", 3, 2, 2, '2009-04-05', 'Check', 'Tiny-tots (ages 5-8)', 0, 800, 'USD');
1627 ";
1628     $this->_query($participant);
1629
1630     $query = "
1631 INSERT INTO civicrm_activity
1632     (source_record_id, activity_type_id, subject, activity_date_time, duration, location, phone_id, phone_number, details, priority_id,parent_id, is_test, status_id)
1633 VALUES
1634     (01, 5, 'NULL', '2009-01-21 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1635     (02, 5, 'NULL', '2008-05-07 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1636     (03, 5, 'NULL', '2008-05-05 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1637     (04, 5, 'NULL', '2008-10-21 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1638     (05, 5, 'NULL', '2008-01-10 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1639     (06, 5, 'NULL', '2008-03-05 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1640     (07, 5, 'NULL', '2009-07-21 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1641     (08, 5, 'NULL', '2009-03-07 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1642     (09, 5, 'NULL', '2008-02-05 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1643     (10, 5, 'NULL', '2008-02-01 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1644     (11, 5, 'NULL', '2009-01-10 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1645     (12, 5, 'NULL', '2009-03-06 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1646     (13, 5, 'NULL', '2008-06-04 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1647     (14, 5, 'NULL', '2008-01-10 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1648     (15, 5, 'NULL', '2008-07-04 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1649     (16, 5, 'NULL', '2009-01-21 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1650     (17, 5, 'NULL', '2008-01-10 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1651     (18, 5, 'NULL', '2009-03-05 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1652     (19, 5, 'NULL', '2008-10-21 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1653     (20, 5, 'NULL', '2009-01-10 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1654     (21, 5, 'NULL', '2008-03-25 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1655     (22, 5, 'NULL', '2009-10-21 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1656     (23, 5, 'NULL', '2008-01-10 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1657     (24, 5, 'NULL', '2008-03-11 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1658     (25, 5, 'NULL', '2008-04-05 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1659     (26, 5, 'NULL', '2009-01-21 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1660     (27, 5, 'NULL', '2008-05-07 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1661     (28, 5, 'NULL', '2009-12-12 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1662     (29, 5, 'NULL', '2009-12-13 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1663     (30, 5, 'NULL', '2009-12-14 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1664     (31, 5, 'NULL', '2009-12-15 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1665     (32, 5, 'NULL', '2009-07-21 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1666     (33, 5, 'NULL', '2009-03-07 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1667     (34, 5, 'NULL', '2009-12-15 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1668     (35, 5, 'NULL', '2009-12-13 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1669     (36, 5, 'NULL', '2009-01-10 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1670     (37, 5, 'NULL', '2009-03-06 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1671     (38, 5, 'NULL', '2009-12-13 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1672     (39, 5, 'NULL', '2008-01-10 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1673     (40, 5, 'NULL', '2009-12-14 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1674     (41, 5, 'NULL', '2009-01-21 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1675     (42, 5, 'NULL', '2009-12-15 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1676     (43, 5, 'NULL', '2009-03-05 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1677     (44, 5, 'NULL', '2009-12-13 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1678     (45, 5, 'NULL', '2009-01-10 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1679     (46, 5, 'NULL', '2009-12-13 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1680     (47, 5, 'NULL', '2009-10-21 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1681     (48, 5, 'NULL', '2009-12-10 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1682     (49, 5, 'NULL', '2009-03-11 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1683     (50, 5, 'NULL', '2009-04-05 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 )
1684     ";
1685     $this->_query($query);
1686
1687     $activityContact = "
1688 INSERT INTO civicrm_activity_contact
1689   (contact_id, activity_id, record_type_id)
1690 VALUES
1691 ";
1692     $activityContacts = CRM_Core_OptionGroup::values('activity_contacts', FALSE, FALSE, FALSE, NULL, 'name');
1693     $currentActivityID = CRM_Core_DAO::singleValueQuery("SELECT MAX(id) FROM civicrm_activity");
1694     $currentActivityID -= 50;
1695     $sourceID = CRM_Utils_Array::key('Activity Source', $activityContacts);
1696     for ($i = 0; $i < 50; $i++) {
1697       $currentActivityID++;
1698       $activityContact .= "({$randomContacts[$i]}, $currentActivityID, $sourceID)";
1699       if ($i != 49) {
1700         $activityContact .= ", ";
1701       }
1702     }
1703     $this->_query($activityContact);
1704   }
1705
1706   private function addPCP() {
1707     $query = "
1708 INSERT INTO `civicrm_pcp`
1709     (contact_id, status_id, title, intro_text, page_text, donate_link_text, page_id, page_type, is_thermometer, is_honor_roll, goal_amount, currency, is_active, pcp_block_id, is_notify)
1710 VALUES
1711     ({$this->Individual[3]}, 2, 'My Personal Civi Fundraiser', 'I''m on a mission to get all my friends and family to help support my favorite open-source civic sector CRM.', '<p>Friends and family - please help build much needed infrastructure for the civic sector by supporting my personal campaign!</p>\r\n<p><a href=\"http://civicrm.org\">You can learn more about CiviCRM here</a>.</p>\r\n<p>Then click the <strong>Contribute Now</strong> button to go to our easy-to-use online contribution form.</p>', 'Contribute Now', 1, 'contribute', 1, 1, 5000.00, 'USD', 1, 1, 1);
1712 ";
1713     $this->_query($query);
1714   }
1715
1716   private function addContribution() {
1717     $query = "
1718 INSERT INTO civicrm_contribution
1719     (contact_id, financial_type_id, payment_instrument_id, receive_date, non_deductible_amount, total_amount, trxn_id, check_number, currency, cancel_date, cancel_reason, receipt_date, thankyou_date, source )
1720 VALUES
1721     (2, 1, 4, '2010-04-11 00:00:00', 0.00, 125.00, NULL, '1041', 'USD', NULL, NULL, NULL, NULL, 'Apr 2007 Mailer 1' ),
1722     (4, 1, 1, '2010-03-21 00:00:00', 0.00, 50.00, 'P20901X1', NULL, 'USD', NULL, NULL, NULL, NULL, 'Online: Save the Penguins' ),
1723     (6, 1, 4, '2010-04-29 00:00:00', 0.00, 25.00, NULL, '2095', 'USD', NULL, NULL, NULL, NULL, 'Apr 2007 Mailer 1' ),
1724     (8, 1, 4, '2010-04-11 00:00:00', 0.00, 50.00, NULL, '10552', 'USD', NULL, NULL, NULL, NULL, 'Apr 2007 Mailer 1' ),
1725     (16, 1, 4, '2010-04-15 00:00:00', 0.00, 500.00, NULL, '509', 'USD', NULL, NULL, NULL, NULL, 'Apr 2007 Mailer 1' ),
1726     (19, 1, 4, '2010-04-11 00:00:00', 0.00, 175.00, NULL, '102', 'USD', NULL, NULL, NULL, NULL, 'Apr 2007 Mailer 1' ),
1727     (82, 1, 1, '2010-03-27 00:00:00', 0.00, 50.00, 'P20193L2', NULL, 'USD', NULL, NULL, NULL, NULL, 'Online: Save the Penguins' ),
1728     (92, 1, 1, '2010-03-08 00:00:00', 0.00, 10.00, 'P40232Y3', NULL, 'USD', NULL, NULL, NULL, NULL, 'Online: Help CiviCRM' ),
1729     (34, 1, 1, '2010-04-22 00:00:00', 0.00, 250.00, 'P20193L6', NULL, 'USD', NULL, NULL, NULL, NULL, 'Online: Help CiviCRM' ),
1730     (71, 1, 1, '2009-07-01 11:53:50', 0.00, 500.00, 'PL71', NULL, 'USD', NULL, NULL, NULL, NULL, NULL ),
1731     (43, 1, 1, '2009-07-01 12:55:41', 0.00, 200.00, 'PL43II', NULL, 'USD', NULL, NULL, NULL, NULL, NULL ),
1732     (32, 1, 1, '2009-10-01 11:53:50', 0.00, 200.00, 'PL32I', NULL, 'USD', NULL, NULL, NULL, NULL, NULL ),
1733     (32, 1, 1, '2009-12-01 12:55:41', 0.00, 200.00, 'PL32II', NULL, 'USD', NULL, NULL, NULL, NULL, NULL );
1734 ";
1735     $this->_query($query);
1736
1737     $currentActivityID = CRM_Core_DAO::singleValueQuery("SELECT MAX(id) FROM civicrm_activity");
1738     $query = "
1739 INSERT INTO civicrm_activity
1740     (source_record_id, activity_type_id, subject, activity_date_time, duration, location, phone_id, phone_number, details, priority_id,parent_id, is_test, status_id)
1741 VALUES
1742     (1, 6, '$ 125.00-Apr 2007 Mailer 1', '2010-04-11 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1743     (2, 6, '$ 50.00-Online: Save the Penguins', '2010-03-21 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1744     (3, 6, '$ 25.00-Apr 2007 Mailer 1', '2010-04-29 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1745     (4, 6, '$ 50.00-Apr 2007 Mailer 1', '2010-04-11 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1746     (5, 6, '$ 500.00-Apr 2007 Mailer 1', '2010-04-15 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1747     (6, 6, '$ 175.00-Apr 2007 Mailer 1', '2010-04-11 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1748     (7, 6, '$ 50.00-Online: Save the Penguins', '2010-03-27 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1749     (8, 6, '$ 10.00-Online: Save the Penguins', '2010-03-08 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1750     (9, 6, '$ 250.00-Online: Save the Penguins', '2010-04-22 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1751     (10, 6, NULL, '2009-07-01 11:53:50', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1752     (11, 6, NULL, '2009-07-01 12:55:41', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1753     (12, 6, NULL, '2009-10-01 11:53:50', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1754     (13, 6, NULL, '2009-12-01 12:55:41', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 );
1755     ";
1756     $this->_query($query);
1757
1758     $activityContact = "
1759 INSERT INTO civicrm_activity_contact
1760   (contact_id, activity_id, record_type_id)
1761 VALUES
1762 ";
1763
1764     $arbitraryNumbers = array(2, 4, 6, 8, 16, 19, 82, 92, 34, 71, 43, 32, 32);
1765     for ($i = 0; $i < count($arbitraryNumbers); $i++) {
1766       $currentActivityID++;
1767       $activityContact .= "({$arbitraryNumbers[$i]}, $currentActivityID, 2)";
1768       if ($i != count($arbitraryNumbers) - 1) {
1769         $activityContact .= ", ";
1770       }
1771     }
1772     $this->_query($activityContact);
1773   }
1774
1775   private function addSoftContribution() {
1776
1777     $sql = "SELECT id from civicrm_contribution where contact_id = 92";
1778     $contriId1 = CRM_Core_DAO::singleValueQuery($sql);
1779
1780     $sql = "SELECT id from civicrm_contribution where contact_id = 34";
1781     $contriId2 = CRM_Core_DAO::singleValueQuery($sql);
1782
1783     $sql = "SELECT cov.value FROM civicrm_option_value cov LEFT JOIN civicrm_option_group cog ON cog.id = cov.option_group_id WHERE cov.name = 'pcp' AND cog.name = 'soft_credit_type'";
1784
1785     $pcpId = CRM_Core_DAO::singleValueQuery($sql);
1786
1787     $query = "
1788 INSERT INTO `civicrm_contribution_soft`
1789       ( contribution_id, contact_id ,amount , currency, pcp_id , pcp_display_in_roll ,pcp_roll_nickname,pcp_personal_note, soft_credit_type_id )
1790 VALUES
1791     ( $contriId1, {$this->Individual[3]}, 10.00, 'USD', 1, 1, 'Jones Family', 'Helping Hands', $pcpId),
1792     ( $contriId2, {$this->Individual[3]}, 250.00, 'USD', 1, 1, 'Annie and the kids', 'Annie Helps', $pcpId);
1793  ";
1794
1795     $this->_query($query);
1796   }
1797
1798   private function addPledge() {
1799     $pledge = "INSERT INTO civicrm_pledge
1800         (contact_id, financial_type_id, contribution_page_id, amount, original_installment_amount, currency,frequency_unit, frequency_interval, frequency_day, installments, start_date, create_date, acknowledge_date, modified_date, cancel_date, end_date, status_id, is_test)
1801         VALUES
1802        (71, 1, 1, 500.00, '500', 'USD', 'month', 1, 1, 1, '2009-07-01 00:00:00', '2009-06-26 00:00:00', NULL, NULL, NULL,'2009-07-01 00:00:00', 1, 0),
1803        (43, 1, 1, 800.00, '200', 'USD', 'month', 3, 1, 4, '2009-07-01 00:00:00', '2009-06-23 00:00:00', '2009-06-23 00:00:00', NULL, NULL, '2009-04-01 10:11:40', 5, 0),
1804        (32, 1, 1, 600.00, '200', 'USD', 'month', 1, 1, 3, '2009-10-01 00:00:00', '2009-09-14 00:00:00', '2009-09-14 00:00:00', NULL, NULL, '2009-12-01 00:00:00', 5, 0);
1805 ";
1806     $this->_query($pledge);
1807   }
1808
1809   private function addPledgePayment() {
1810     $pledgePayment = "INSERT INTO civicrm_pledge_payment
1811         ( pledge_id, contribution_id, scheduled_amount, actual_amount, currency, scheduled_date, reminder_date, reminder_count, status_id)
1812        VALUES
1813          (1, 10, 500.00, 500.00, 'USD','2009-07-01 00:00:00', null, 0, 1 ),
1814          (2, 11,   200.00, 200.00, 'USD','2009-07-01 00:00:00', null, 0,  1 ),
1815          (2, null, 200.00, null, 'USD', '2009-10-01 00:00:00', null, 0,  2 ),
1816          (2, null, 200.00, null, 'USD', '2009-01-01 00:00:00', null, 0,  2 ),
1817          (2, null, 200.00, null, 'USD', '2009-04-01 00:00:00', null, 0,  2 ),
1818
1819          (3, 12,   200.00, 200.00, 'USD', '2009-10-01 00:00:00', null, 0, 1 ),
1820          (3, 13,   200.00, 200.00, 'USD', '2009-11-01 00:0:00', '2009-10-28 00:00:00', 1, 1),
1821          (3, null, 200.00, null, 'USD', '2009-12-01 00:00:00', null, 0, 2 );
1822         ";
1823     $this->_query($pledgePayment);
1824   }
1825
1826   private function addContributionLineItem() {
1827     $query = " INSERT INTO civicrm_line_item (`entity_table`, `entity_id`, contribution_id, `price_field_id`, `label`, `qty`, `unit_price`, `line_total`, `participant_count`, `price_field_value_id`, `financial_type_id`)
1828 SELECT 'civicrm_contribution', cc.id, cc.id contribution_id, cpf.id as price_field, cpfv.label, 1, cc.total_amount, cc.total_amount line_total, 0, cpfv.id as price_field_value, cpfv.financial_type_id
1829 FROM civicrm_contribution cc
1830 LEFT JOIN civicrm_price_set cps ON cps.name = 'default_contribution_amount'
1831 LEFT JOIN civicrm_price_field cpf ON cpf.price_set_id = cps.id
1832 LEFT JOIN civicrm_price_field_value cpfv ON cpfv.price_field_id = cpf.id
1833 order by cc.id; ";
1834     $this->_query($query);
1835   }
1836
1837   private function addContributionFinancialItem() {
1838
1839     $sql = " SELECT cc.id contribution_id, cli.id as line_item_id, cc.contact_id, cc.receive_date, cc.total_amount, cc.currency, cli.label, cli.financial_type_id,  cefa.financial_account_id, cc.payment_instrument_id, cc.check_number, cc.trxn_id
1840 FROM `civicrm_contribution` cc
1841 INNER JOIN civicrm_line_item cli ON cli.entity_id = cc.id and cli.entity_table = 'civicrm_contribution'
1842 INNER JOIN civicrm_entity_financial_account cefa ON cefa.entity_id =  cli.financial_type_id
1843 WHERE cefa.account_relationship = 1; ";
1844     $result = CRM_Core_DAO::executeQuery($sql);
1845     $financialAccountId = CRM_Financial_BAO_FinancialTypeAccount::getInstrumentFinancialAccount();
1846     $this->addFinancialItem($result, $financialAccountId);
1847   }
1848
1849   private function addParticipantFinancialItem() {
1850
1851     $sql = " SELECT cpp.contribution_id, cli.id as line_item_id, cp.contact_id, now() as receive_date, cp.fee_amount as total_amount, cp.fee_currency as currency, cli.label, cli.financial_type_id, cefa.financial_account_id, 4 as payment_instrument_id, NULL as check_number, NULL as trxn_id
1852 FROM `civicrm_participant` cp
1853 INNER JOIN civicrm_participant_payment cpp ON cpp.participant_id = cp.id
1854 INNER JOIN civicrm_line_item cli ON cli.entity_id = cp.id and cli.entity_table = 'civicrm_participant'
1855 INNER JOIN civicrm_entity_financial_account cefa ON cefa.entity_id =  cli.financial_type_id
1856 WHERE cefa.account_relationship = 1";
1857     $result = CRM_Core_DAO::executeQuery($sql);
1858     $this->addFinancialItem($result);
1859   }
1860
1861   /**
1862    * @param $result
1863    * @param null $financialAccountId
1864    */
1865   private function addFinancialItem($result, $financialAccountId = NULL) {
1866     $defaultFinancialAccount = CRM_Core_DAO::singleValueQuery("SELECT id FROM civicrm_financial_account WHERE is_default = 1");
1867     while ($result->fetch()) {
1868       $trxnParams = array(
1869         'trxn_date' => CRM_Utils_Date::processDate($result->receive_date),
1870         'total_amount' => $result->total_amount,
1871         'currency' => $result->currency,
1872         'status_id' => 1,
1873         'trxn_id' => $result->trxn_id,
1874         'contribution_id' => $result->contribution_id,
1875         'to_financial_account_id' => empty($financialAccountId[$result->payment_instrument_id]) ? $defaultFinancialAccount : $financialAccountId[$result->payment_instrument_id],
1876         'payment_instrument_id' => $result->payment_instrument_id,
1877         'check_number' => $result->check_number,
1878       );
1879       $trxn = CRM_Core_BAO_FinancialTrxn::create($trxnParams);
1880       $financialItem = array(
1881         'transaction_date' => CRM_Utils_Date::processDate($result->receive_date),
1882         'amount' => $result->total_amount,
1883         'currency' => $result->currency,
1884         'status_id' => 1,
1885         'entity_id' => $result->line_item_id,
1886         'contact_id' => $result->contact_id,
1887         'entity_table' => 'civicrm_line_item',
1888         'description' => $result->label,
1889         'financial_account_id' => $result->financial_account_id,
1890       );
1891       $trxnId['id'] = $trxn->id;
1892       CRM_Financial_BAO_FinancialItem::create($financialItem, NULL, $trxnId);
1893     }
1894   }
1895
1896   private function addLineItemParticipants() {
1897     $participant = new CRM_Event_DAO_Participant();
1898     $participant->query("INSERT INTO civicrm_line_item (`entity_table`, `entity_id`, contribution_id, `price_field_id`, `label`, `qty`, `unit_price`, `line_total`, `participant_count`, `price_field_value_id`, `financial_type_id`)
1899 SELECT 'civicrm_participant', cp.id, cpp.contribution_id, cpfv.price_field_id, cpfv.label, 1, cpfv.amount, cpfv.amount as line_total, 0, cpfv.id, cpfv.financial_type_id FROM civicrm_participant cp LEFT JOIN civicrm_participant_payment cpp ON cpp.participant_id = cp.id
1900 LEFT JOIN civicrm_price_set_entity cpe ON cpe.entity_id = cp.event_id LEFT JOIN civicrm_price_field cpf ON cpf.price_set_id = cpe.price_set_id LEFT JOIN civicrm_price_field_value cpfv ON cpfv.price_field_id = cpf.id WHERE cpfv.label = cp.fee_level");
1901   }
1902
1903   private function addMembershipPayment() {
1904     $maxContribution = CRM_Core_DAO::singleValueQuery("select max(id) from civicrm_contribution");
1905     $financialTypeID = CRM_Core_DAO::singleValueQuery("select id from civicrm_financial_type where name = 'Member Dues'");
1906     $paymentInstrumentID = CRM_Core_DAO::singleValueQuery("select value from civicrm_option_value where name = 'Credit Card' AND option_group_id = (SELECT id from civicrm_option_group where name = 'payment_instrument')");
1907     $sql = "INSERT INTO civicrm_contribution (contact_id,financial_type_id,payment_instrument_id, receive_date, total_amount, currency, source, contribution_status_id)
1908 SELECT  cm.contact_id, $financialTypeID, $paymentInstrumentID, now(), cmt.minimum_fee, 'USD', CONCAT(cmt.name, ' Membership: Offline signup'), 1 FROM `civicrm_membership` cm
1909 LEFT JOIN civicrm_membership_type cmt ON cmt.id = cm.membership_type_id;";
1910
1911     $this->_query($sql);
1912
1913     $sql = "INSERT INTO civicrm_membership_payment (contribution_id,membership_id)
1914 SELECT cc.id, cm.id FROM civicrm_contribution cc
1915 LEFT JOIN civicrm_membership cm ON cm.contact_id = cc.contact_id
1916 WHERE cc.id > $maxContribution;";
1917
1918     $this->_query($sql);
1919
1920     $sql = "INSERT INTO civicrm_line_item (entity_table, entity_id, contribution_id, price_field_value_id, price_field_id, label, qty, unit_price, line_total, financial_type_id)
1921 SELECT 'civicrm_membership', cm.id, cmp.contribution_id, cpfv.id, cpfv.price_field_id, cpfv.label, 1, cpfv.amount, cpfv.amount as unit_price, cpfv.financial_type_id FROM `civicrm_membership` cm
1922 LEFT JOIN civicrm_membership_payment cmp ON cmp.membership_id = cm.id
1923 LEFT JOIN civicrm_price_field_value cpfv ON cpfv.membership_type_id = cm.membership_type_id
1924 LEFT JOIN civicrm_price_field cpf ON cpf.id = cpfv.price_field_id
1925 LEFT JOIN civicrm_price_set cps ON cps.id = cpf.price_set_id
1926 WHERE cps.name = 'default_membership_type_amount'";
1927     $this->_query($sql);
1928
1929     $sql = "INSERT INTO civicrm_activity(source_record_id, activity_type_id, subject, activity_date_time, status_id, details)
1930 SELECT id, 6, CONCAT('$ ', total_amount, ' - ', source), now(), 2, 'Membership Payment' FROM civicrm_contribution WHERE id > $maxContribution";
1931     $this->_query($sql);
1932
1933     $sql = "INSERT INTO civicrm_activity_contact(contact_id, activity_id, record_type_id)
1934 SELECT c.contact_id, a.id, 2
1935 FROM   civicrm_contribution c, civicrm_activity a
1936 WHERE  c.id > $maxContribution
1937 AND    a.source_record_id = c.id
1938 AND    a.details = 'Membership Payment'
1939 ";
1940     $this->_query($sql);
1941   }
1942
1943   private function addParticipantPayment() {
1944     $maxContribution = CRM_Core_DAO::singleValueQuery("select max(id) from civicrm_contribution");
1945     $financialTypeID = CRM_Core_DAO::singleValueQuery("select id from civicrm_financial_type where name = 'Event Fee'");
1946     $paymentInstrumentID = CRM_Core_DAO::singleValueQuery("select value from civicrm_option_value where name = 'Credit Card' AND option_group_id = (SELECT id from civicrm_option_group where name = 'payment_instrument')");
1947     $sql = "INSERT INTO civicrm_contribution (contact_id, financial_type_id, payment_instrument_id, receive_date, total_amount, currency, receipt_date, source, contribution_status_id)
1948 SELECT  `contact_id`, $financialTypeID, $paymentInstrumentID, now(), `fee_amount`, 'USD', now(), CONCAT(ce.title, ' : Offline registration'), 1  FROM `civicrm_participant` cp
1949 LEFT JOIN civicrm_event ce ON ce.id = cp.event_id
1950 group by `contact_id`;";
1951
1952     $this->_query($sql);
1953
1954     $sql = "INSERT INTO civicrm_participant_payment (contribution_id,participant_id)
1955 SELECT cc.id, cp.id FROM civicrm_contribution cc
1956 LEFT JOIN civicrm_participant cp ON cp.contact_id = cc.contact_id
1957 WHERE cc.id > $maxContribution";
1958
1959     $this->_query($sql);
1960
1961     $sql = "INSERT INTO civicrm_activity(source_record_id, activity_type_id, subject, activity_date_time, status_id, details)
1962 SELECT id, 6, CONCAT('$ ', total_amount, ' - ', source), now(), 2, 'Participant' FROM `civicrm_contribution` WHERE id > $maxContribution";
1963     $this->_query($sql);
1964
1965     $sql = "INSERT INTO civicrm_activity_contact(contact_id, activity_id, record_type_id)
1966 SELECT c.contact_id, a.id, 2
1967 FROM   civicrm_contribution c, civicrm_activity a
1968 WHERE  c.id > $maxContribution
1969 AND    a.source_record_id = c.id
1970 AND    a.details = 'Participant Payment'
1971 ";
1972     $this->_query($sql);
1973   }
1974
1975 }
1976
1977 /**
1978  * @param null $str
1979  *
1980  * @return bool
1981  */
1982 function user_access($str = NULL) {
1983   return TRUE;
1984 }
1985
1986 /**
1987  * @return array
1988  */
1989 function module_list() {
1990   return array();
1991 }
1992
1993 echo ("Starting data generation on " . date("F dS h:i:s A") . "\n");
1994 $gcd = new CRM_GCD();
1995 $gcd->initID();
1996 $gcd->generate('Domain');
1997 $gcd->generate('Contact');
1998 $gcd->generate('Individual');
1999 $gcd->generate('Household');
2000 $gcd->generate('Organization');
2001 $gcd->generate('Relationship');
2002 $gcd->generate('EntityTag');
2003 $gcd->generate('Group');
2004 $gcd->generate('Note');
2005 $gcd->generate('Activity');
2006 $gcd->generate('Event');
2007 $gcd->generate('Contribution');
2008 $gcd->generate('ContributionLineItem');
2009 $gcd->generate('Membership');
2010 $gcd->generate('MembershipPayment');
2011 $gcd->generate('MembershipLog');
2012 $gcd->generate('PCP');
2013 $gcd->generate('SoftContribution');
2014 $gcd->generate('Pledge');
2015 $gcd->generate('PledgePayment');
2016 $gcd->generate('ContributionFinancialItem');
2017 $gcd->generate('Participant');
2018 $gcd->generate('ParticipantPayment');
2019 $gcd->generate('LineItemParticipants');
2020 $gcd->generate('ParticipantFinancialItem');
2021 echo ("Ending data generation on " . date("F dS h:i:s A") . "\n");