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         $activityDAO->source_contact_id = $contactDAO->id;
1148         $activityTypeID = mt_rand(7, 10);
1149         $activity = CRM_Core_PseudoConstant::activityType();
1150         $activityDAO->activity_type_id = $activityTypeID;
1151         $activityDAO->subject = "Subject for $activity[$activityTypeID]";
1152         $activityDAO->activity_date_time = $this->randomDate();
1153         $activityDAO->duration = mt_rand(1, 6);
1154         $activityDAO->status_id = 2;
1155         $this->_insert($activityDAO);
1156
1157         if (in_array($activityTypeID, array(
1158           6, 9))) {
1159           $activityTargetDAO = new CRM_Activity_DAO_ActivityTarget();
1160           $activityTargetDAO->activity_id = $activityDAO->id;
1161           $activityTargetDAO->target_contact_id = mt_rand(1, 101);
1162           $this->_insert($activityTargetDAO);
1163         }
1164
1165         if ($activityTypeID == 7) {
1166           $activityAssignmentDAO = new CRM_Activity_DAO_ActivityAssignment();
1167           $activityAssignmentDAO->activity_id = $activityDAO->id;
1168           $activityAssignmentDAO->assignee_contact_id = mt_rand(1, 101);
1169           $this->_insert($activityAssignmentDAO);
1170         }
1171       }
1172     }
1173   }
1174
1175   function getZipCodeInfo() {
1176
1177     if (!$this->stateMap) {
1178       $query = 'SELECT id, name, abbreviation from civicrm_state_province where country_id = 1228';
1179       $dao = new CRM_Core_DAO();
1180       $dao->query($query);
1181       $this->stateMap = array();
1182       while ($dao->fetch()) {
1183         $this->stateMap[$dao->abbreviation] = $dao->id;
1184         $this->states[$dao->id] = $dao->name;
1185       }
1186       $dao->free();
1187     }
1188
1189     $offset = mt_rand(1, 43000);
1190     $query = "SELECT city, state, zip, latitude, longitude FROM zipcodes LIMIT $offset, 1";
1191     $dao = new CRM_Core_DAO();
1192     $dao->query($query);
1193     while ($dao->fetch()) {
1194       if ($this->stateMap[$dao->state]) {
1195         $stateID = $this->stateMap[$dao->state];
1196       }
1197       else {
1198         $stateID = 1004;
1199       }
1200
1201       $zip = str_pad($dao->zip, 5, '0', STR_PAD_LEFT);
1202       return array(1228, $stateID, $dao->city, $zip, $dao->latitude, $dao->longitude);
1203     }
1204   }
1205
1206   static
1207   function getLatLong($zipCode) {
1208     $query = "http://maps.google.com/maps?q=$zipCode&output=js";
1209     $userAgent = "Mozilla/5.0 (Macintosh; U; PPC Mac OS X Mach-O; en-US; rv:1.7.5) Gecko/20041107 Firefox/1.0";
1210
1211     $ch = curl_init();
1212     curl_setopt($ch, CURLOPT_URL, $query);
1213     curl_setopt($ch, CURLOPT_HEADER, FALSE);
1214     curl_setopt($ch, CURLOPT_USERAGENT, $userAgent);
1215     curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
1216
1217     // grab URL and pass it to the browser
1218     $outstr = curl_exec($ch);
1219
1220     // close CURL resource, and free up system resources
1221     curl_close($ch);
1222
1223     $preg = "/'(<\?xml.+?)',/s";
1224     preg_match($preg, $outstr, $matches);
1225     if ($matches[1]) {
1226       $xml = simplexml_load_string($matches[1]);
1227       $attributes = $xml->center->attributes();
1228       if (!empty($attributes)) {
1229         return array((float ) $attributes['lat'], (float ) $attributes['lng']);
1230       }
1231     }
1232     return array(NULL, NULL);
1233   }
1234
1235   private function addMembershipType() {
1236     $organizationDAO = new CRM_Contact_DAO_Contact();
1237     $organizationDAO->id = 5;
1238     $organizationDAO->find(TRUE);
1239     $contact_id = $organizationDAO->contact_id;
1240
1241     $membershipType = "INSERT INTO civicrm_membership_type
1242         (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)
1243         VALUES
1244         ('General', 'Regular annual membership.', " . $contact_id . ", 2, 100, 'year', 1, 'rolling',null, null, 7, 'b_a', 'Public', 1, 1),
1245         ('Student', 'Discount membership for full-time students.', " . $contact_id . ", 2, 50, 'year', 1, 'rolling', null, null, 7, 'b_a', 'Public', 2, 1),
1246         ('Lifetime', 'Lifetime membership.', " . $contact_id . ", 2, 1200, 'lifetime', 1, 'rolling', null, null, 7, 'b_a', 'Admin', 3, 1);
1247         ";
1248     $this->_query($membershipType);
1249   }
1250
1251   private function addMembership() {
1252     $contact = new CRM_Contact_DAO_Contact();
1253     $contact->query("SELECT id FROM civicrm_contact where contact_type = 'Individual'");
1254     while ($contact->fetch()) {
1255       $contacts[] = $contact->id;
1256     }
1257     shuffle($contacts);
1258
1259     $randomContacts = array_slice($contacts, 20, 30);
1260
1261     $sources = array('Payment', 'Donation', 'Check');
1262     $membershipTypes = array(1, 2);
1263     $membershipTypeNames = array('General', 'Student');
1264     $statuses = array(3, 4);
1265
1266     $membership = "
1267 INSERT INTO civicrm_membership
1268         (contact_id, membership_type_id, join_date, start_date, end_date, source, status_id)
1269 VALUES
1270 ";
1271     $activity = "
1272 INSERT INTO civicrm_activity
1273         (source_contact_id, 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)
1274 VALUES
1275 ";
1276
1277     foreach ($randomContacts as $count => $dontCare) {
1278       $source = $this->randomItem($sources);
1279       $acititySourceId = $count + 1;
1280       if ((($count + 1) % 11 == 0)) {
1281         // lifetime membership, status can be anything
1282         $startDate = date('Y-m-d', mktime(0, 0, 0, date('m'), (date('d') - $count), date('Y')));
1283         $membership .= "( {$randomContacts[$count]}, 3, '{$startDate}', '{$startDate}', null, '{$source}', 1)";
1284         $activity .= "( {$randomContacts[$count]}, {$acititySourceId}, 7, 'Lifetime', '{$startDate} 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 )";
1285       }
1286       elseif (($count + 1) % 5 == 0) {
1287         // Grace or expired, memberhsip type is random of 1 & 2
1288         $randIndex = array_rand($membershipTypes);
1289         $membershipTypeId = $membershipTypes[$randIndex];
1290         $membershipStatusId = $statuses[$randIndex];
1291         $membershipTypeName = $membershipTypeNames[$randIndex];
1292         $YearFactor = $membershipTypeId * 2;
1293         //reverse the type and consider as year factor.
1294         if ($YearFactor != 2) {
1295           $YearFactor = 1;
1296         }
1297         $dateFactor = ($count * ($YearFactor) * ($YearFactor) * ($YearFactor));
1298         $startDate = date('Y-m-d', mktime(0, 0, 0,
1299             date('m'),
1300             (date('d') - ($dateFactor)),
1301             (date('Y') - ($YearFactor))
1302           ));
1303         $partOfDate = explode('-', $startDate);
1304         $endDate = date('Y-m-d', mktime(0, 0, 0,
1305             $partOfDate[1],
1306             ($partOfDate[2] - 1),
1307             ($partOfDate[0] + ($YearFactor))
1308           ));
1309
1310         $membership .= "( {$randomContacts[$count]}, {$membershipTypeId}, '{$startDate}', '{$startDate}', '{$endDate}', '{$source}', {$membershipStatusId})";
1311         $activity .= "( {$randomContacts[$count]}, {$acititySourceId}, 7, '{$membershipTypeName}', '{$startDate} 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 )";
1312       }
1313       elseif (($count + 1) % 2 == 0) {
1314         // membership type 2
1315         $startDate = date('Y-m-d', mktime(0, 0, 0, date('m'), (date('d') - $count), date('Y')));
1316         $endDate = date('Y-m-d', mktime(0, 0, 0, date('m'), (date('d') - ($count + 1)), (date('Y') + 1)));
1317         $membership .= "( {$randomContacts[$count]}, 2, '{$startDate}', '{$startDate}', '{$endDate}', '{$source}', 1)";
1318         $activity .= "( {$randomContacts[$count]}, {$acititySourceId}, 7, 'Student', '{$startDate} 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 )";
1319       }
1320       else {
1321         // membership type 1
1322         $startDate = date('Y-m-d', mktime(0, 0, 0, date('m'), (date('d') - $count), date('Y')));
1323         $endDate = date('Y-m-d', mktime(0, 0, 0, date('m'), (date('d') - ($count + 1)), (date('Y') + 2)));
1324         $membership .= "( {$randomContacts[$count]}, 1, '{$startDate}', '{$startDate}', '{$endDate}', '{$source}', 1)";
1325         $activity .= "( {$randomContacts[$count]}, {$acititySourceId}, 7, 'General', '{$startDate} 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 )";
1326       }
1327
1328       if ($count != 29) {
1329         $membership .= ",";
1330         $activity .= ",";
1331       }
1332     }
1333
1334     $this->_query($membership);
1335
1336     $this->_query($activity);
1337   }
1338
1339   static
1340   function repairDate($date) {
1341     $dropArray = array('-' => '', ':' => '', ' ' => '');
1342     return strtr($date, $dropArray);
1343   }
1344
1345   private function addMembershipLog() {
1346     $membership = new CRM_Member_DAO_Membership();
1347     $membership->query("SELECT id FROM civicrm_membership");
1348     while ($membership->fetch()) {
1349       $ids[] = $membership->id;
1350     }
1351     foreach ($ids as $id) {
1352       $membership = new CRM_Member_DAO_Membership();
1353       $membership->id = $id;
1354       $membershipLog = new CRM_Member_DAO_MembershipLog();
1355       if ($membership->find(TRUE)) {
1356         $membershipLog->membership_id = $membership->id;
1357         $membershipLog->status_id = $membership->status_id;
1358         $membershipLog->start_date = self::repairDate($membership->start_date);
1359         $membershipLog->end_date = self::repairDate($membership->end_date);
1360         $membershipLog->modified_id = $membership->contact_id;
1361         $membershipLog->modified_date = date("Ymd");
1362         $membershipLog->membership_type_id = $membership->membership_type_id;
1363         $membershipLog->save();
1364       }
1365       $membershipLog = NULL;
1366     }
1367   }
1368
1369   private function addEvent() {
1370     $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)
1371       VALUES
1372       ( 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),
1373       ( 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),
1374       ( 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)
1375       ";
1376     $this->_query($event);
1377
1378     $sql = "SELECT id from civicrm_address where street_address = '14S El Camino Way E'";
1379     $eventAdd1 = CRM_Core_DAO::singleValueQuery($sql);
1380     $sql = "SELECT id from civicrm_address where street_address = '11B Woodbridge Path SW'";
1381     $eventAdd2 = CRM_Core_DAO::singleValueQuery($sql);
1382     $sql = "SELECT id from civicrm_address where street_address = '581O Lincoln Dr SW'";
1383     $eventAdd3 = CRM_Core_DAO::singleValueQuery($sql);
1384
1385     $event = "INSERT INTO civicrm_email (contact_id, location_type_id, email, is_primary, is_billing, on_hold, hold_date, reset_date)
1386        VALUES
1387        (NULL, 1, 'development@example.org', 0, 0, 0, NULL, NULL),
1388        (NULL, 1, 'tournaments@example.org', 0, 0, 0, NULL, NULL),
1389        (NULL, 1, 'celebration@example.org', 0, 0, 0, NULL, NULL)
1390        ";
1391     $this->_query($event);
1392
1393     $sql = "SELECT id from civicrm_email where email = 'development@example.org'";
1394     $eventEmail1 = CRM_Core_DAO::singleValueQuery($sql);
1395     $sql = "SELECT id from civicrm_email where email = 'tournaments@example.org'";
1396     $eventEmail2 = CRM_Core_DAO::singleValueQuery($sql);
1397     $sql = "SELECT id from civicrm_email where email = 'celebration@example.org'";
1398     $eventEmail3 = CRM_Core_DAO::singleValueQuery($sql);
1399
1400     $event = "INSERT INTO civicrm_phone (contact_id, location_type_id, is_primary, is_billing, mobile_provider_id, phone, phone_numeric, phone_type_id)
1401        VALUES
1402        (NULL, 1, 0, 0, NULL, '204 222-1000', '2042221000', '1'),
1403        (NULL, 1, 0, 0, NULL, '204 223-1000', '2042231000', '1'),
1404        (NULL, 1, 0, 0, NULL, '303 323-1000', '3033231000', '1')
1405        ";
1406     $this->_query($event);
1407
1408     $sql = "SELECT id from civicrm_phone where phone = '204 222-1000'";
1409     $eventPhone1 = CRM_Core_DAO::singleValueQuery($sql);
1410     $sql = "SELECT id from civicrm_phone where phone = '204 223-1000'";
1411     $eventPhone2 = CRM_Core_DAO::singleValueQuery($sql);
1412     $sql = "SELECT id from civicrm_phone where phone = '303 323-1000'";
1413     $eventPhone3 = CRM_Core_DAO::singleValueQuery($sql);
1414
1415     $event = "INSERT INTO civicrm_loc_block ( address_id, email_id, phone_id, address_2_id, email_2_id, phone_2_id)
1416        VALUES
1417       ( $eventAdd1, $eventEmail1, $eventPhone1, NULL,NULL,NULL),
1418       ( $eventAdd2, $eventEmail2, $eventPhone2, NULL,NULL,NULL),
1419       ( $eventAdd3, $eventEmail3, $eventPhone3, NULL,NULL,NULL)
1420        ";
1421
1422     $this->_query($event);
1423
1424     $sql = "SELECT id from civicrm_loc_block where phone_id = $eventPhone1 AND email_id = $eventEmail1 AND address_id = $eventAdd1";
1425     $eventLok1 = CRM_Core_DAO::singleValueQuery($sql);
1426     $sql = "SELECT id from civicrm_loc_block where phone_id = $eventPhone2 AND email_id = $eventEmail2 AND address_id = $eventAdd2";
1427     $eventLok2 = CRM_Core_DAO::singleValueQuery($sql);
1428     $sql = "SELECT id from civicrm_loc_block where phone_id = $eventPhone3 AND email_id = $eventEmail3 AND address_id = $eventAdd3";
1429     $eventLok3 = CRM_Core_DAO::singleValueQuery($sql);
1430
1431     $event = "INSERT INTO civicrm_event
1432         ( 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 )
1433         VALUES
1434         ( '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' ),
1435         ( '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' ),
1436         ( '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' )
1437          ";
1438     $this->_query($event);
1439
1440     //CRM-4464
1441     $eventTemplates = "INSERT INTO civicrm_event
1442         ( 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 )
1443         VALUES
1444         ( 1, 'Free Meeting without Online Registration', 4, 1, 1, 1, 0, 0, null, null, null, null,             null, null, null, null, null, 1, 'USD'  ),
1445         ( 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'  ),
1446         ( 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' )";
1447
1448     $this->_query($eventTemplates);
1449
1450     $ufJoinValues = $tellFriendValues = array();
1451     $profileID = CRM_Core_DAO::singleValueQuery("Select id from civicrm_uf_group where name ='event_registration'");
1452
1453     // grab id's for all events and event templates
1454     $query = "
1455 SELECT  id
1456   FROM  civicrm_event";
1457
1458     $template = CRM_Core_DAO::executeQuery($query);
1459     while ($template->fetch()) {
1460       if ($profileID) {
1461         $ufJoinValues[] = "( 1, 'CiviEvent', 'civicrm_event', {$template->id}, 1, {$profileID} )";
1462       }
1463       $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)";
1464     }
1465
1466     //insert values in civicrm_uf_join for the required event_registration profile - CRM-9587
1467     if (!empty($ufJoinValues)) {
1468       $includeProfile = "INSERT INTO civicrm_uf_join
1469                                (is_active, module, entity_table, entity_id, weight, uf_group_id )
1470                                VALUES " . implode(',', $ufJoinValues);
1471       $this->_query($includeProfile);
1472     }
1473
1474     //insert values in civicrm_tell_friend
1475     if (!empty($tellFriendValues)) {
1476       $tellFriend = "INSERT INTO civicrm_tell_friend
1477                            (entity_table, entity_id, title, intro, suggested_message,
1478                            general_link,  thankyou_title, thankyou_text, is_active)
1479                            VALUES " . implode(',', $tellFriendValues);
1480       $this->_query($tellFriend);
1481     }
1482   }
1483
1484   private function addParticipant() {
1485     $contact = new CRM_Contact_DAO_Contact();
1486     $contact->query("SELECT id FROM civicrm_contact");
1487     while ($contact->fetch()) {
1488       $contacts[] = $contact->id;
1489     }
1490     shuffle($contacts);
1491     $randomContacts = array_slice($contacts, 20, 50);
1492
1493     $participant = "
1494 INSERT INTO civicrm_participant
1495         (contact_id, event_id, status_id, role_id, register_date, source, fee_level, is_test, fee_amount, fee_currency)
1496 VALUES
1497         ( " . $randomContacts[0] . ", 1, 1, 1, '2009-01-21', 'Check', 'Single', 0, 50, 'USD'),
1498         ( " . $randomContacts[1] . ", 2, 2, 2, '2008-05-07', 'Credit Card', 'Soprano', 0, 50, 'USD'),
1499         ( " . $randomContacts[2] . ", 3, 3, 3, '2008-05-05', 'Credit Card', 'Tiny-tots (ages 5-8)', 0, 800, 'USD') ,
1500         ( " . $randomContacts[3] . ", 1, 4, 4, '2008-10-21', 'Direct Transfer', 'Single', 0, 50, 'USD'),
1501         ( " . $randomContacts[4] . ", 2, 1, 1, '2008-01-10', 'Check', 'Soprano', 0, 50, 'USD'),
1502         ( " . $randomContacts[5] . ", 3, 2, 2, '2008-03-05', 'Direct Transfer', 'Tiny-tots (ages 5-8)', 0, 800, 'USD'),
1503         ( " . $randomContacts[6] . ", 1, 3, 3, '2009-07-21', 'Direct Transfer', 'Single', 0, 50, 'USD'),
1504         ( " . $randomContacts[7] . ", 2, 4, 4, '2009-03-07', 'Credit Card', 'Soprano', 0, 50, 'USD'),
1505         ( " . $randomContacts[8] . ", 3, 1, 1, '2008-02-05', 'Direct Transfer', 'Tiny-tots (ages 5-8)', 0, 800, 'USD'),
1506         ( " . $randomContacts[9] . ", 1, 2, 2, '2008-02-01', 'Check', 'Single', 0, 50, 'USD'),
1507         ( " . $randomContacts[10] . ", 2, 3, 3, '2009-01-10', 'Direct Transfer', 'Soprano', 0, 50, 'USD'),
1508         ( " . $randomContacts[11] . ", 3, 4, 4, '2009-03-06', 'Credit Card', 'Tiny-tots (ages 5-8)', 0, 800, 'USD'),
1509         ( " . $randomContacts[12] . ", 1, 1, 2, '2008-06-04', 'Credit Card', 'Single', 0, 50, 'USD'),
1510         ( " . $randomContacts[13] . ", 2, 2, 3, '2008-01-10', 'Direct Transfer', 'Soprano', 0, 50, 'USD'),
1511         ( " . $randomContacts[14] . ", 3, 4, 1, '2008-07-04', 'Check', 'Tiny-tots (ages 5-8)', 0, 800, 'USD'),
1512         ( " . $randomContacts[15] . ", 1, 4, 2, '2009-01-21', 'Credit Card', 'Single', 0, 50, 'USD'),
1513         ( " . $randomContacts[16] . ", 2, 2, 3, '2008-01-10', 'Credit Card', 'Soprano', 0, 50, 'USD'),
1514         ( " . $randomContacts[17] . ", 3, 3, 1, '2009-03-05', 'Credit Card', 'Tiny-tots (ages 5-8)', 0, 800, 'USD'),
1515         ( " . $randomContacts[18] . ", 1, 2, 1, '2008-10-21', 'Direct Transfer', 'Single', 0, 50, 'USD'),
1516         ( " . $randomContacts[19] . ", 2, 4, 1, '2009-01-10', 'Credit Card', 'Soprano', 0, 50, 'USD'),
1517         ( " . $randomContacts[20] . ", 3, 1, 4, '2008-03-25', 'Check', 'Tiny-tots (ages 5-8)', 0, 800, 'USD'),
1518         ( " . $randomContacts[21] . ", 1, 2, 3, '2009-10-21', 'Direct Transfer', 'Single', 0, 50, 'USD'),
1519         ( " . $randomContacts[22] . ", 2, 4, 1, '2008-01-10', 'Direct Transfer', 'Soprano', 0, 50, 'USD'),
1520         ( " . $randomContacts[23] . ", 3, 3, 1, '2008-03-11', 'Credit Card', 'Tiny-tots (ages 5-8)', 0, 800, 'USD'),
1521         ( " . $randomContacts[24] . ", 3, 2, 2, '2008-04-05', 'Direct Transfer', 'Tiny-tots (ages 5-8)', 0, 800, 'USD'),
1522         ( " . $randomContacts[25] . ", 1, 1, 1, '2009-01-21', 'Check', 'Single', 0, 50, 'USD'),
1523         ( " . $randomContacts[26] . ", 2, 2, 2, '2008-05-07', 'Credit Card', 'Soprano', 0, 50, 'USD'),
1524         ( " . $randomContacts[27] . ", 3, 3, 3, '2009-12-12', 'Direct Transfer', 'Tiny-tots (ages 5-8)', 0, 800, 'USD'),
1525         ( " . $randomContacts[28] . ", 1, 4, 4, '2009-12-13', 'Credit Card', 'Single', 0, 50, 'USD'),
1526         ( " . $randomContacts[29] . ", 2, 1, 1, '2009-12-14', 'Direct Transfer', 'Soprano', 0, 50, 'USD'),
1527         ( " . $randomContacts[30] . ", 3, 2, 2, '2009-12-15', 'Credit Card', 'Tiny-tots (ages 5-8)', 0, 800, 'USD'),
1528         ( " . $randomContacts[31] . ", 1, 3, 3, '2009-07-21', 'Check', 'Single', 0, 50, 'USD'),
1529         ( " . $randomContacts[32] . ", 2, 4, 4, '2009-03-07', 'Direct Transfer', 'Soprano', 0, 50, 'USD'),
1530         ( " . $randomContacts[33] . ", 3, 1, 1, '2009-12-15', 'Credit Card', 'Tiny-tots (ages 5-8)', 0, 800, 'USD'),
1531         ( " . $randomContacts[34] . ", 1, 2, 2, '2009-12-13', 'Direct Transfer', 'Single', 0, 50, 'USD'),
1532         ( " . $randomContacts[35] . ", 2, 3, 3, '2009-01-10', 'Direct Transfer', 'Soprano', 0, 50, 'USD'),
1533         ( " . $randomContacts[36] . ", 3, 4, 4, '2009-03-06', 'Check', 'Tiny-tots (ages 5-8)', 0, 800, 'USD'),
1534         ( " . $randomContacts[37] . ", 1, 1, 2, '2009-12-13', 'Direct Transfer', 'Single', 0, 50, 'USD'),
1535         ( " . $randomContacts[38] . ", 2, 2, 3, '2008-01-10', 'Direct Transfer', 'Soprano', 0, 50, 'USD'),
1536         ( " . $randomContacts[39] . ", 3, 4, 1, '2009-12-14', 'Credit Card', 'Tiny-tots (ages 5-8)', 0, 800, 'USD'),
1537         ( " . $randomContacts[40] . ", 1, 4, 2, '2009-01-21', 'Credit Card', 'Single', 0, 50, 'USD'),
1538         ( " . $randomContacts[41] . ", 2, 2, 3, '2009-12-15', 'Credit Card', 'Soprano', 0, 50, 'USD'),
1539         ( " . $randomContacts[42] . ", 3, 3, 1, '2009-03-05', 'Credit Card', 'Tiny-tots (ages 5-8)', 0, 800, 'USD'),
1540         ( " . $randomContacts[43] . ", 1, 2, 1, '2009-12-13', 'Direct Transfer', 'Single', 0, 50, 'USD'),
1541         ( " . $randomContacts[44] . ", 2, 4, 1, '2009-01-10', 'Direct Transfer', 'Soprano', 0, 50, 'USD'),
1542         ( " . $randomContacts[45] . ", 3, 1, 4, '2009-12-13', 'Check', 'Tiny-tots (ages 5-8)', 0, 800, 'USD'),
1543         ( " . $randomContacts[46] . ", 1, 2, 3, '2009-10-21', 'Credit Card', 'Single', 0, 50, 'USD'),
1544         ( " . $randomContacts[47] . ", 2, 4, 1, '2009-12-10', 'Credit Card', 'Soprano', 0, 50, 'USD'),
1545         ( " . $randomContacts[48] . ", 3, 3, 1, '2009-03-11', 'Credit Card', 'Tiny-tots (ages 5-8)', 0, 800, 'USD'),
1546         ( " . $randomContacts[49] . ", 3, 2, 2, '2009-04-05', 'Check', 'Tiny-tots (ages 5-8)', 0, 800, 'USD');
1547 ";
1548     $this->_query($participant);
1549
1550     $query = "
1551 INSERT INTO civicrm_activity
1552     (source_contact_id, 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)
1553 VALUES
1554     ($randomContacts[0], 01, 5, 'NULL', '2009-01-21 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1555     ($randomContacts[1], 02, 5, 'NULL', '2008-05-07 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1556     ($randomContacts[2], 03, 5, 'NULL', '2008-05-05 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1557     ($randomContacts[3], 04, 5, 'NULL', '2008-10-21 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1558     ($randomContacts[4], 05, 5, 'NULL', '2008-01-10 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1559     ($randomContacts[5], 06, 5, 'NULL', '2008-03-05 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1560     ($randomContacts[6], 07, 5, 'NULL', '2009-07-21 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1561     ($randomContacts[7], 08, 5, 'NULL', '2009-03-07 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1562     ($randomContacts[8], 09, 5, 'NULL', '2008-02-05 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1563     ($randomContacts[9], 10, 5, 'NULL', '2008-02-01 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1564     ($randomContacts[10], 11, 5, 'NULL', '2009-01-10 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1565     ($randomContacts[11], 12, 5, 'NULL', '2009-03-06 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1566     ($randomContacts[12], 13, 5, 'NULL', '2008-06-04 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1567     ($randomContacts[13], 14, 5, 'NULL', '2008-01-10 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1568     ($randomContacts[14], 15, 5, 'NULL', '2008-07-04 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1569     ($randomContacts[15], 16, 5, 'NULL', '2009-01-21 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1570     ($randomContacts[16], 17, 5, 'NULL', '2008-01-10 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1571     ($randomContacts[17], 18, 5, 'NULL', '2009-03-05 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1572     ($randomContacts[18], 19, 5, 'NULL', '2008-10-21 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1573     ($randomContacts[19], 20, 5, 'NULL', '2009-01-10 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1574     ($randomContacts[20], 21, 5, 'NULL', '2008-03-25 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1575     ($randomContacts[21], 22, 5, 'NULL', '2009-10-21 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1576     ($randomContacts[22], 23, 5, 'NULL', '2008-01-10 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1577     ($randomContacts[23], 24, 5, 'NULL', '2008-03-11 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1578     ($randomContacts[24], 25, 5, 'NULL', '2008-04-05 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1579     ($randomContacts[25], 26, 5, 'NULL', '2009-01-21 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1580     ($randomContacts[26], 27, 5, 'NULL', '2008-05-07 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1581     ($randomContacts[27], 28, 5, 'NULL', '2009-12-12 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1582     ($randomContacts[28], 29, 5, 'NULL', '2009-12-13 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1583     ($randomContacts[29], 30, 5, 'NULL', '2009-12-14 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1584     ($randomContacts[30], 31, 5, 'NULL', '2009-12-15 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1585     ($randomContacts[31], 32, 5, 'NULL', '2009-07-21 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1586     ($randomContacts[32], 33, 5, 'NULL', '2009-03-07 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1587     ($randomContacts[33], 34, 5, 'NULL', '2009-12-15 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1588     ($randomContacts[34], 35, 5, 'NULL', '2009-12-13 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1589     ($randomContacts[35], 36, 5, 'NULL', '2009-01-10 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1590     ($randomContacts[36], 37, 5, 'NULL', '2009-03-06 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1591     ($randomContacts[37], 38, 5, 'NULL', '2009-12-13 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1592     ($randomContacts[38], 39, 5, 'NULL', '2008-01-10 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1593     ($randomContacts[39], 40, 5, 'NULL', '2009-12-14 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1594     ($randomContacts[40], 41, 5, 'NULL', '2009-01-21 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1595     ($randomContacts[41], 42, 5, 'NULL', '2009-12-15 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1596     ($randomContacts[42], 43, 5, 'NULL', '2009-03-05 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1597     ($randomContacts[43], 44, 5, 'NULL', '2009-12-13 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1598     ($randomContacts[44], 45, 5, 'NULL', '2009-01-10 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1599     ($randomContacts[45], 46, 5, 'NULL', '2009-12-13 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1600     ($randomContacts[46], 47, 5, 'NULL', '2009-10-21 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1601     ($randomContacts[47], 48, 5, 'NULL', '2009-12-10 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1602     ($randomContacts[48], 49, 5, 'NULL', '2009-03-11 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1603     ($randomContacts[49], 50, 5, 'NULL', '2009-04-05 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 )
1604     ";
1605     $this->_query($query);
1606   }
1607
1608   private function addPCP() {
1609     $query = "
1610 INSERT INTO `civicrm_pcp`
1611     (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)
1612 VALUES
1613     ({$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);
1614 ";
1615     $this->_query($query);
1616   }
1617
1618   private function addContribution() {
1619     $query = "
1620 INSERT INTO civicrm_contribution
1621     (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 )
1622 VALUES
1623     (2, 1, 4, '2010-04-11 00:00:00', 0.00, 125.00, NULL, '1041', 'USD', NULL, NULL, NULL, NULL, 'Apr 2007 Mailer 1' ),
1624     (4, 1, 1, '2010-03-21 00:00:00', 0.00, 50.00, 'P20901X1', NULL, 'USD', NULL, NULL, NULL, NULL, 'Online: Save the Penguins' ),
1625     (6, 1, 4, '2010-04-29 00:00:00', 0.00, 25.00, NULL, '2095', 'USD', NULL, NULL, NULL, NULL, 'Apr 2007 Mailer 1' ),
1626     (8, 1, 4, '2010-04-11 00:00:00', 0.00, 50.00, NULL, '10552', 'USD', NULL, NULL, NULL, NULL, 'Apr 2007 Mailer 1' ),
1627     (16, 1, 4, '2010-04-15 00:00:00', 0.00, 500.00, NULL, '509', 'USD', NULL, NULL, NULL, NULL, 'Apr 2007 Mailer 1' ),
1628     (19, 1, 4, '2010-04-11 00:00:00', 0.00, 175.00, NULL, '102', 'USD', NULL, NULL, NULL, NULL, 'Apr 2007 Mailer 1' ),
1629     (82, 1, 1, '2010-03-27 00:00:00', 0.00, 50.00, 'P20193L2', NULL, 'USD', NULL, NULL, NULL, NULL, 'Online: Save the Penguins' ),
1630     (92, 1, 1, '2010-03-08 00:00:00', 0.00, 10.00, 'P40232Y3', NULL, 'USD', NULL, NULL, NULL, NULL, 'Online: Help CiviCRM' ),
1631     (34, 1, 1, '2010-04-22 00:00:00', 0.00, 250.00, 'P20193L6', NULL, 'USD', NULL, NULL, NULL, NULL, 'Online: Help CiviCRM' ),
1632     (71, 1, 1, '2009-07-01 11:53:50', 0.00, 500.00, 'PL71', NULL, 'USD', NULL, NULL, NULL, NULL, NULL ),
1633     (43, 1, 1, '2009-07-01 12:55:41', 0.00, 200.00, 'PL43II', NULL, 'USD', NULL, NULL, NULL, NULL, NULL ),
1634     (32, 1, 1, '2009-10-01 11:53:50', 0.00, 200.00, 'PL32I', NULL, 'USD', NULL, NULL, NULL, NULL, NULL ),
1635     (32, 1, 1, '2009-12-01 12:55:41', 0.00, 200.00, 'PL32II', NULL, 'USD', NULL, NULL, NULL, NULL, NULL );
1636 ";
1637     $this->_query($query);
1638
1639     $query = "
1640 INSERT INTO civicrm_activity
1641     (source_contact_id, 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)
1642 VALUES
1643     (2, 1, 6, '$ 125.00-Apr 2007 Mailer 1', '2010-04-11 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1644     (4, 2, 6, '$ 50.00-Online: Save the Penguins', '2010-03-21 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1645     (6, 3, 6, '$ 25.00-Apr 2007 Mailer 1', '2010-04-29 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1646     (8, 4, 6, '$ 50.00-Apr 2007 Mailer 1', '2010-04-11 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1647     (16, 5, 6, '$ 500.00-Apr 2007 Mailer 1', '2010-04-15 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1648     (19, 6, 6, '$ 175.00-Apr 2007 Mailer 1', '2010-04-11 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1649     (82, 7, 6, '$ 50.00-Online: Save the Penguins', '2010-03-27 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1650     (92, 8, 6, '$ 10.00-Online: Save the Penguins', '2010-03-08 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1651     (34, 9, 6, '$ 250.00-Online: Save the Penguins', '2010-04-22 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1652     (71, 10, 6, NULL, '2009-07-01 11:53:50', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1653     (43, 11, 6, NULL, '2009-07-01 12:55:41', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1654     (32, 12, 6, NULL, '2009-10-01 11:53:50', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1655     (32, 13, 6, NULL, '2009-12-01 12:55:41', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 );
1656     ";
1657     $this->_query($query);
1658   }
1659
1660   private function addSoftContribution() {
1661
1662     $sql = "SELECT id from civicrm_contribution where contact_id = 92";
1663     $contriId1 = CRM_Core_DAO::singleValueQuery($sql);
1664
1665     $sql = "SELECT id from civicrm_contribution where contact_id = 34";
1666     $contriId2 = CRM_Core_DAO::singleValueQuery($sql);
1667
1668     $query = "
1669 INSERT INTO `civicrm_contribution_soft`
1670       ( contribution_id, contact_id ,amount , currency, pcp_id , pcp_display_in_roll ,pcp_roll_nickname,pcp_personal_note )
1671 VALUES
1672     ( $contriId1, {$this->Individual[3]}, 10.00, 'USD', 1, 1, 'Jones Family', 'Helping Hands'),
1673     ( $contriId2, {$this->Individual[3]}, 250.00, 'USD', 1, 1, 'Annie and the kids', 'Annie Helps');
1674  ";
1675     $this->_query($query);
1676   }
1677
1678   private function addPledge() {
1679     $pledge = "INSERT INTO civicrm_pledge
1680         (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)
1681         VALUES
1682        (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),
1683        (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),
1684        (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);
1685 ";
1686     $this->_query($pledge);
1687   }
1688
1689   private function addPledgePayment() {
1690     $pledgePayment = "INSERT INTO civicrm_pledge_payment
1691         ( pledge_id, contribution_id, scheduled_amount, actual_amount, currency, scheduled_date, reminder_date, reminder_count, status_id)
1692        VALUES
1693          (1, 10, 500.00, 500.00, 'USD','2009-07-01 00:00:00', null, 0, 1 ),
1694          (2, 11,   200.00, 200.00, 'USD','2009-07-01 00:00:00', null, 0,  1 ),
1695          (2, null, 200.00, null, 'USD', '2009-10-01 00:00:00', null, 0,  2 ),
1696          (2, null, 200.00, null, 'USD', '2009-01-01 00:00:00', null, 0,  2 ),
1697          (2, null, 200.00, null, 'USD', '2009-04-01 00:00:00', null, 0,  2 ),
1698
1699          (3, 12,   200.00, 200.00, 'USD', '2009-10-01 00:00:00', null, 0, 1 ),
1700          (3, 13,   200.00, 200.00, 'USD', '2009-11-01 00:0:00', '2009-10-28 00:00:00', 1, 1),
1701          (3, null, 200.00, null, 'USD', '2009-12-01 00:00:00', null, 0, 2 );
1702         ";
1703     $this->_query($pledgePayment);
1704   }
1705
1706   private function addContributionLineItem() {
1707     $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`)
1708 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
1709 FROM civicrm_contribution cc
1710 LEFT JOIN civicrm_price_set cps ON cps.name = 'default_contribution_amount'
1711 LEFT JOIN civicrm_price_field cpf ON cpf.price_set_id = cps.id
1712 LEFT JOIN civicrm_price_field_value cpfv ON cpfv.price_field_id = cpf.id
1713 order by cc.id; ";
1714     $this->_query($query);
1715   }
1716
1717   private function addContributionFinancialItem() {
1718
1719     $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
1720 FROM `civicrm_contribution` cc
1721 INNER JOIN civicrm_line_item cli ON cli.entity_id = cc.id and cli.entity_table = 'civicrm_contribution'
1722 INNER JOIN civicrm_entity_financial_account cefa ON cefa.entity_id =  cli.financial_type_id
1723 WHERE cefa.account_relationship = 1; ";
1724     $result = CRM_Core_DAO::executeQuery($sql);
1725     $financialAccountId = CRM_Financial_BAO_FinancialTypeAccount::getInstrumentFinancialAccount();
1726     $this->addFinancialItem($result, $financialAccountId);
1727   }
1728
1729   private function addParticipantFinancialItem() {
1730
1731     $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
1732 FROM `civicrm_participant` cp
1733 INNER JOIN civicrm_participant_payment cpp ON cpp.participant_id = cp.id
1734 INNER JOIN civicrm_line_item cli ON cli.entity_id = cp.id and cli.entity_table = 'civicrm_participant'
1735 INNER JOIN civicrm_entity_financial_account cefa ON cefa.entity_id =  cli.financial_type_id
1736 WHERE cefa.account_relationship = 1";
1737     $result = CRM_Core_DAO::executeQuery($sql);
1738     $this->addFinancialItem($result);
1739   }
1740
1741   private function addFinancialItem($result, $financialAccountId = NULL) {
1742     $defaultFinancialAccount = CRM_Core_DAO::singleValueQuery("SELECT id FROM civicrm_financial_account WHERE is_default = 1");
1743     while($result->fetch()){
1744       $trxnParams = array(
1745         'trxn_date' => CRM_Utils_Date::processDate($result->receive_date),
1746         'total_amount' => $result->total_amount,
1747         'currency' => $result->currency,
1748         'status_id' => 1,
1749         'trxn_id' => $result->trxn_id,
1750         'contribution_id' => $result->contribution_id,
1751         'to_financial_account_id' => $result->payment_instrument_id ? $financialAccountId[$result->payment_instrument_id] : $defaultFinancialAccount,
1752         'payment_instrument_id' => $result->payment_instrument_id,
1753         'check_number' => $result->check_number
1754       );
1755       $trxn = CRM_Core_BAO_FinancialTrxn::create($trxnParams);
1756       $financialItem = array(
1757         'transaction_date' => CRM_Utils_Date::processDate($result->receive_date),
1758         'amount' => $result->total_amount,
1759         'currency' => $result->currency,
1760         'status_id' => 1,
1761         'entity_id' => $result->line_item_id,
1762         'contact_id' => $result->contact_id,
1763         'entity_table' => 'civicrm_line_item',
1764         'description' => $result->label,
1765         'financial_account_id' => $result->financial_account_id
1766       );
1767       $trxnId['id'] = $trxn->id;
1768       CRM_Financial_BAO_FinancialItem::create($financialItem, null, $trxnId);
1769   }
1770   }
1771
1772   private function addLineItemParticipants() {
1773     $participant = new CRM_Event_DAO_Participant();
1774     $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`)
1775 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");
1776   }
1777
1778   private function addMembershipPayment() {
1779     $maxContribution = CRM_Core_DAO::singleValueQuery("select max(id) from civicrm_contribution");
1780     $financialTypeID = CRM_Core_DAO::singleValueQuery("select id from civicrm_financial_type where name = 'Member Dues'");
1781     $sql = "INSERT INTO civicrm_contribution (contact_id,financial_type_id,receive_date, total_amount, currency, source, contribution_status_id)
1782 SELECT  cm.contact_id, $financialTypeID, now(), cmt.minimum_fee, 'USD', CONCAT(cmt.name, ' Membership: Offline signup'), 1 FROM `civicrm_membership` cm
1783 LEFT JOIN civicrm_membership_type cmt ON cmt.id = cm.membership_type_id;";
1784
1785     $this->_query($sql);
1786
1787     $sql = "INSERT INTO civicrm_membership_payment (contribution_id,membership_id)
1788 SELECT cc.id, cm.id FROM civicrm_contribution cc
1789 LEFT JOIN civicrm_membership cm ON cm.contact_id = cc.contact_id
1790 WHERE cc.id > $maxContribution;";
1791
1792     $this->_query($sql);
1793
1794     $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)
1795 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
1796 LEFT JOIN civicrm_membership_payment cmp ON cmp.membership_id = cm.id
1797 LEFT JOIN civicrm_price_field_value cpfv ON cpfv.membership_type_id = cm.membership_type_id
1798 LEFT JOIN civicrm_price_field cpf ON cpf.id = cpfv.price_field_id
1799 LEFT JOIN civicrm_price_set cps ON cps.id = cpf.price_set_id
1800 WHERE cps.name = 'default_membership_type_amount'";
1801
1802     $this->_query($sql);
1803
1804     $sql = "INSERT INTO civicrm_activity(source_contact_id, source_record_id, activity_type_id, subject, activity_date_time, status_id)
1805 SELECT contact_id, id, 6, CONCAT('$ ', total_amount, ' - ', source), now(), 2 FROM `civicrm_contribution` WHERE id > $maxContribution";
1806
1807     $this->_query($sql);
1808 }
1809
1810   private function addParticipantPayment() {
1811     $maxContribution = CRM_Core_DAO::singleValueQuery("select max(id) from civicrm_contribution");
1812     $financialTypeID = CRM_Core_DAO::singleValueQuery("select id from civicrm_financial_type where name = 'Event Fee'");
1813     $sql = "INSERT INTO civicrm_contribution (contact_id, financial_type_id, receive_date, total_amount, currency, receipt_date, source, contribution_status_id)
1814 SELECT  `contact_id`, $financialTypeID, now(), `fee_amount`, 'USD', now(), CONCAT(ce.title, ' : Offline registration'), 1  FROM `civicrm_participant` cp
1815 LEFT JOIN civicrm_event ce ON ce.id = cp.event_id
1816 group by `contact_id`;";
1817
1818     $this->_query($sql);
1819
1820     $sql = "INSERT INTO civicrm_participant_payment (contribution_id,participant_id)
1821 SELECT cc.id, cp.id FROM civicrm_contribution cc
1822 LEFT JOIN civicrm_participant cp ON cp.contact_id = cc.contact_id
1823 WHERE cc.id > $maxContribution";
1824
1825     $this->_query($sql);
1826
1827     $sql = "INSERT INTO civicrm_activity(source_contact_id, source_record_id, activity_type_id, subject, activity_date_time, status_id)
1828 SELECT contact_id, id, 6, CONCAT('$ ', total_amount, ' - ', source), now(), 2 FROM `civicrm_contribution` WHERE id > $maxContribution";
1829
1830     $this->_query($sql);
1831   }
1832 }
1833
1834 function user_access($str = NULL) {
1835   return TRUE;
1836 }
1837
1838 function module_list() {
1839   return array();
1840 }
1841
1842 echo ("Starting data generation on " . date("F dS h:i:s A") . "\n");
1843 $obj1 = new CRM_GCD();
1844 $obj1->initID();
1845 $obj1->generate('Domain');
1846 $obj1->generate('Contact');
1847 $obj1->generate('Individual');
1848 $obj1->generate('Household');
1849 $obj1->generate('Organization');
1850 $obj1->generate('Relationship');
1851 $obj1->generate('EntityTag');
1852 $obj1->generate('Group');
1853 $obj1->generate('Note');
1854 $obj1->generate('Activity');
1855 $obj1->generate('Event');
1856 $obj1->generate('Contribution');
1857 $obj1->generate('ContributionLineItem');
1858 $obj1->generate('Membership');
1859 $obj1->generate('MembershipPayment');
1860 $obj1->generate('MembershipLog');
1861 $obj1->generate('PCP');
1862 $obj1->generate('SoftContribution');
1863 $obj1->generate('Pledge');
1864 $obj1->generate('PledgePayment');
1865 $obj1->generate('ContributionFinancialItem');
1866 $obj1->generate('Participant');
1867 $obj1->generate('ParticipantPayment');
1868 $obj1->generate('LineItemParticipants');
1869 $obj1->generate('ParticipantFinancialItem');
1870 echo ("Ending data generation on " . date("F dS h:i:s A") . "\n");