sql/GenerateData.php

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