3 +--------------------------------------------------------------------+
4 | Copyright CiviCRM LLC. All rights reserved. |
6 | This work is published under the GNU AGPLv3 license with some |
7 | permitted exceptions and without any warranty. For full license |
8 | and copyright information, see https://civicrm.org/licensing |
9 +--------------------------------------------------------------------+
15 * @copyright CiviCRM LLC https://civicrm.org/licensing
21 * This class generates data for the schema located in Contact.sql
23 * each public method generates data for the concerned table.
24 * so for example the addContactDomain method generates and adds
25 * data to the contact_domain table
27 * Data generation is a bit tricky since the data generated
28 * randomly in one table could be used as a FKEY in another
31 * In order to ensure that a randomly generated FKEY matches
32 * a field in the referened table, the field in the referenced
33 * table is always generated linearly.
40 * Domain ID's - 1 to NUM_DOMAIN
44 * Contact - 1 to NUM_CONTACT
49 * Contact to Domain distribution should be equal.
52 * Contact Individual = 1 to 0.8*NUM_CONTACT
54 * Contact Household = 0.8*NUM_CONTACT to 0.9*NUM_CONTACT
56 * Contact Organization = 0.9*NUM_CONTACT to NUM_CONTACT
58 * Assumption is that each household contains 4 individuals
64 * Note: implication of using of mt_srand(1) in constructor
65 * The data generated will be done in a consistent manner
66 * so as to give the same data during each run (but this
67 * would involve populating the entire db at one go - since
68 * mt_srand(1) is in the constructor, if one needs to be able
69 * to get consistent random numbers then the mt_srand(1) shld
70 * be in each function that adds data to each table.
75 require_once '../civicrm.config.php';
78 require_once 'CRM/Core/ClassLoader.php';
79 CRM_Core_ClassLoader
::singleton()->register();
90 // Set ADD_TO_DB = FALSE to do a dry run
91 const ADD_TO_DB
= TRUE;
93 const DATA_FILENAME
= "sample_data.xml";
95 const NUM_CONTACT
= 200;
96 const INDIVIDUAL_PERCENT
= 80;
97 const HOUSEHOLD_PERCENT
= 10;
98 const ORGANIZATION_PERCENT
= 10;
99 const NUM_INDIVIDUAL_PER_HOUSEHOLD
= 4;
100 const NUM_ACTIVITY
= 150;
102 // Location types from the table crm_location_type
111 public function __construct() {
112 // initialize all the vars
113 $this->numIndividual
= self
::INDIVIDUAL_PERCENT
* self
::NUM_CONTACT
/ 100;
114 $this->numHousehold
= self
::HOUSEHOLD_PERCENT
* self
::NUM_CONTACT
/ 100;
115 $this->numOrganization
= self
::ORGANIZATION_PERCENT
* self
::NUM_CONTACT
/ 100;
116 $this->numStrictIndividual
= $this->numIndividual
- ($this->numHousehold
* self
::NUM_INDIVIDUAL_PER_HOUSEHOLD
);
119 foreach ((array) simplexml_load_file(self
::DATA_FILENAME
) as $key => $val) {
121 $this->sampleData
[$key] = (array) $val['item'];
124 $config = CRM_Core_Config
::singleton();
126 // Relationship types indexed by name_a_b from the table civicrm_relationship_type
127 $this->relTypes
= CRM_Utils_Array
::index(array('name_a_b'), CRM_Core_PseudoConstant
::relationshipType('name'));
132 * Public wrapper for calling private "add" functions
133 * Provides user feedback
136 public function generate($itemName) {
137 echo "Generating $itemName\n";
138 $fn = "add$itemName";
143 * this function creates arrays for the following
147 * contact_location id
148 * contact_contact_location id
151 * contact_instant_message uuid
152 * contact_relationship uuid
156 public function initID() {
157 // get the domain and contact id arrays
158 $this->domain
= range(1, self
::NUM_DOMAIN
);
159 shuffle($this->domain
);
161 // Get first contact id
162 $this->startCid
= $cid = CRM_Core_DAO
::singleValueQuery("SELECT MAX(id) FROM civicrm_contact");
163 $this->contact
= range($cid +
1, $cid + self
::NUM_CONTACT
);
164 shuffle($this->contact
);
166 // get the individual, household and organizaton contacts
168 $this->Individual
= array_slice($this->contact
, $offset, $this->numIndividual
);
169 $offset +
= $this->numIndividual
;
170 $this->Household
= array_slice($this->contact
, $offset, $this->numHousehold
);
171 $offset +
= $this->numHousehold
;
172 $this->Organization
= array_slice($this->contact
, $offset, $this->numOrganization
);
174 // get the strict individual contacts (i.e individual contacts not belonging to any household)
175 $this->strictIndividual
= array_slice($this->Individual
, 0, $this->numStrictIndividual
);
177 // get the household to individual mapping array
178 $this->householdIndividual
= array_slice($this->Individual
, $this->numStrictIndividual
);
179 $this->householdIndividual
= array_chunk($this->householdIndividual
, self
::NUM_INDIVIDUAL_PER_HOUSEHOLD
);
180 $this->householdIndividual
= array_combine($this->Household
, $this->householdIndividual
);
189 * enum's from database
192 private $preferredCommunicationMethod = array('1', '2', '3', '4', '5');
193 private $contactType = array('Individual', 'Household', 'Organization');
194 private $phoneType = array('1', '2', '3', '4');
197 * customizable enums (foreign keys)
200 private $prefix = array(
216 private $suffix = array(1 => 'Jr.', 2 => 'Sr.', 3 => 'II', 4 => 'III');
217 private $gender = array(1 => 'female', 2 => 'male');
223 private $domain = array();
229 private $contact = array();
230 private $Individual = array();
231 private $Household = array();
232 private $Organization = array();
234 // store which contacts have a location entity
236 * for automatic management of is_primary field
239 private $location = array(
242 'Address' => array(),
246 * stores the strict individual id and household id to individual id mapping
249 private $strictIndividual = array();
250 private $householdIndividual = array();
251 private $householdName = array();
254 * sample data in xml format
257 private $sampleData = array();
264 private $numIndividual = 0;
265 private $numHousehold = 0;
266 private $numOrganization = 0;
267 private $numStrictIndividual = 0;
268 private $stateMap = array();
269 private $states = array();
271 private $groupMembershipStatus = array('Added', 'Removed', 'Pending');
272 private $subscriptionHistoryMethod = array('Admin', 'Email');
273 private $deceasedContactIds = array();
275 /*********************************
277 * *******************************
283 * Get a randomly generated string.
289 private function randomString($size = 32) {
292 // get an ascii code for each character
293 for ($i = 0; $i < $size; $i++
) {
294 $random_int = mt_rand(65, 122);
295 if (($random_int < 97) && ($random_int > 90)) {
296 // if ascii code between 90 and 97 substitute with space
299 $random_char = chr($random_int);
300 $string .= $random_char;
308 private function randomChar() {
309 return chr(mt_rand(65, 90));
313 * Get a random item from the sample data or any other array
315 * @param $items (array or string) - if string, used as key for sample data, if array, used as data source
317 * @return mixed (element from array)
321 private function randomItem($items) {
322 if (!is_array($items)) {
324 $items = $this->sampleData
[$key];
327 echo "Error: no items found for '$key'\n";
330 return $items[mt_rand(0, count($items) - 1)];
338 private function randomIndex($items) {
339 return $this->randomItem(array_keys($items));
347 private function randomKeyValue($items) {
348 $key = $this->randomIndex($items);
349 return array($key, $items[$key]);
357 private function probability($chance) {
358 if (mt_rand(0, 100) < ($chance * 100)) {
365 * Generate a random date.
367 * If both $startDate and $endDate are defined generate
370 * If only startDate is specified then date generated is
371 * between startDate + 1 year.
373 * if only endDate is specified then date generated is
374 * between endDate - 1 year.
376 * if none are specified - date is between today - 1year
379 * @param int $startDate Start Date in Unix timestamp
380 * @param int $endDate End Date in Unix timestamp
383 * @return string randomly generated date in the format "Ymd"
386 private function randomDate($startDate = 0, $endDate = 0) {
388 // number of seconds per year
389 $numSecond = 31536000;
390 $dateFormat = "YmdHis";
394 if ($startDate && $endDate) {
395 return date($dateFormat, mt_rand($startDate, $endDate));
398 // only startDate is defined
400 return date($dateFormat, mt_rand($startDate, $startDate +
$numSecond));
403 // only endDate is defined
405 return date($dateFormat, mt_rand($endDate - $numSecond, $endDate));
409 return date($dateFormat, mt_rand($today - $numSecond, $today));
413 * Automatically manage the is_primary field by tracking which contacts have each item
418 private function isPrimary($cid, $type) {
419 if (empty($this->location
[$type][$cid])) {
420 $this->location
[$type][$cid] = TRUE;
427 * Execute a query unless we are doing a dry run
428 * Note: this wrapper should not be used for SELECT queries
430 * @param array $params
431 * @return \CRM_Core_DAO
433 private function _query($query, $params = array()) {
434 if (self
::ADD_TO_DB
) {
435 return CRM_Core_DAO
::executeQuery($query, $params);
440 * Call dao insert method unless we are doing a dry run
443 private function _insert(&$dao) {
444 if (self
::ADD_TO_DB
) {
445 if (!$dao->insert()) {
446 echo "ERROR INSERT: " . mysqli_error($dao->getConnection()->connection
) . "\n";
454 * Call dao update method unless we are doing a dry run
457 private function _update(&$dao) {
458 if (self
::ADD_TO_DB
) {
459 if (!$dao->update()) {
460 echo "ERROR UPDATE: " . mysqli_error($dao->getConnection()->connection
) . "\n";
468 * Add core DAO object
472 private function _addDAO($type, $params) {
473 $daoName = "CRM_Core_DAO_$type";
474 $obj = new $daoName();
475 foreach ($params as $key => $value) {
478 if (isset($this->location
[$type])) {
479 $obj->is_primary
= $this->isPrimary($params['contact_id'], $type);
481 $this->_insert($obj);
485 * Fetch contact type based on stored mapping
487 * @return string $type
489 private function getContactType($id) {
490 foreach (array('Individual', 'Household', 'Organization') as $type) {
491 if (in_array($id, $this->$type)) {
498 * This method adds NUM_DOMAIN domains and then adds NUM_REVISION
499 * revisions for each domain with the latest revision being the last one..
501 private function addDomain() {
503 /* Add a location for domain 1 */
505 $domain = new CRM_Core_DAO_Domain();
506 for ($id = 2; $id <= self
::NUM_DOMAIN
; $id++
) {
507 // domain name is pretty simple. it is "Domain $id"
508 $domain->name
= "Domain $id";
509 $domain->description
= "Description $id";
510 $domain->contact_name
= $this->randomName();
513 $this->_insert($domain);
520 public function randomName() {
521 $first_name = $this->randomItem(($this->probability(.5) ?
'fe' : '') . 'male_name');
522 $middle_name = ucfirst($this->randomChar());
523 $last_name = $this->randomItem('last_name');
524 return "$first_name $middle_name. $last_name";
528 * This method adds data to the contact table
531 * contact_type 'Individual' 'Household' 'Organization'
532 * preferred_communication (random 1 to 3)
534 private function addContact() {
535 $contact = new CRM_Contact_DAO_Contact();
536 $cid = $this->startCid
;
538 for ($id = $cid +
1; $id <= $cid + self
::NUM_CONTACT
; $id++
) {
539 $contact->contact_type
= $this->getContactType($id);
540 $contact->do_not_phone
= $this->probability(.2);
541 $contact->do_not_email
= $this->probability(.2);
542 $contact->do_not_post
= $this->probability(.2);
543 $contact->do_not_trade
= $this->probability(.2);
544 $contact->preferred_communication_method
= NULL;
545 if ($this->probability(.5)) {
546 $contact->preferred_communication_method
= CRM_Core_DAO
::VALUE_SEPARATOR
. $this->randomItem($this->preferredCommunicationMethod
) . CRM_Core_DAO
::VALUE_SEPARATOR
;
548 $contact->source
= 'Sample Data';
549 $this->_insert($contact);
556 * This method adds individual's data to the contact table
558 * The following fields are generated and added.
560 * contact_uuid - individual
561 * contact_rid - latest one
562 * first_name 'First Name $contact_uuid'
563 * middle_name 'Middle Name $contact_uuid'
564 * last_name 'Last Name $contact_uuid'
565 * job_title 'Job Title $contact_uuid'
568 private function addIndividual() {
570 $contact = new CRM_Contact_DAO_Contact();
571 $year = 60 * 60 * 24 * 365.25;
574 foreach ($this->Individual
as $cid) {
575 $contact->is_deceased
= $contact->gender_id
= $contact->birth_date
= $contact->deceased_date
= $email = NULL;
576 list($gender_id, $gender) = $this->randomKeyValue($this->gender
);
577 $birth_date = mt_rand($now - 90 * $year, $now - 10 * $year);
579 $contact->last_name
= $this->randomItem('last_name');
581 // Manage household names
582 if (!in_array($contact->id
, $this->strictIndividual
)) {
583 // Find position in household
584 foreach ($this->householdIndividual
as $householdId => $house) {
585 foreach ($house as $position => $memberId) {
586 if ($memberId == $cid) {
591 // Head of household: set name
592 if (empty($this->householdName
[$householdId])) {
593 $this->householdName
[$householdId] = $contact->last_name
;
595 // Kids get household name, spouse might get it
596 if ($position > 1 ||
$this->probability(.5)) {
597 $contact->last_name
= $this->householdName
[$householdId];
599 elseif ($this->householdName
[$householdId] != $contact->last_name
) {
600 // Spouse might hyphenate name
601 if ($this->probability(.5)) {
602 $contact->last_name
.= '-' . $this->householdName
[$householdId];
604 // Kids might hyphenate name
606 $this->householdName
[$householdId] .= '-' . $contact->last_name
;
609 // Sensible ages and genders
610 $offset = mt_rand($now - 40 * $year, $now);
613 $birth_date = mt_rand($offset - 35 * $year, $offset - 20 * $year);
614 if ($this->probability(.8)) {
615 $gender_id = 2 - $position;
616 $gender = $this->gender
[$gender_id];
621 $birth_date = mt_rand($offset - 10 * $year, $offset);
624 // Non household people
626 if ($this->probability(.6)) {
627 $this->_addAddress($cid);
631 $contact->first_name
= $this->randomItem($gender . '_name');
632 $contact->middle_name
= $this->probability(.5) ?
'' : ucfirst($this->randomChar());
633 $age = intval(($now - $birth_date) / $year);
635 // Prefix and suffix by gender and age
636 $contact->prefix_id
= $contact->suffix_id
= $prefix = $suffix = NULL;
637 if ($this->probability(.5) && $age > 20) {
638 list($contact->prefix_id
, $prefix) = $this->randomKeyValue($this->prefix
[$gender_id]);
641 if ($gender == 'male' && $this->probability(.50)) {
642 list($contact->suffix_id
, $suffix) = $this->randomKeyValue($this->suffix
);
643 $suffix = ' ' . $suffix;
645 if ($this->probability(.7)) {
646 $contact->gender_id
= $gender_id;
648 if ($this->probability(.7)) {
649 $contact->birth_date
= date("Ymd", $birth_date);
652 // Deceased probability based on age
653 if ($contact->gender_id
&& $contact->gender_id
== 2) {
659 if ($age > $checkAge && count($this->deceasedContactIds
) < 4) {
660 $contact->is_deceased
= $this->probability(($age - 30) / 100);
661 if ($contact->is_deceased
&& $this->probability(.7)) {
662 $contact->deceased_date
= $this->randomDate();
666 // Add 0, 1 or 2 email address
667 $count = mt_rand(0, 2);
668 for ($i = 0; $i < $count; ++
$i) {
669 $email = $this->_individualEmail($contact);
670 $this->_addEmail($cid, $email, self
::HOME
);
673 // Add 0, 1 or 2 phones
674 $count = mt_rand(0, 2);
675 for ($i = 0; $i < $count; ++
$i) {
676 $this->_addPhone($cid);
679 // Occasionally you get contacts with just an email in the db
680 if ($this->probability(.2) && $email) {
681 $contact->first_name
= $contact->last_name
= $contact->middle_name
= NULL;
682 $contact->is_deceased
= $contact->gender_id
= $contact->birth_date
= $contact->deceased_date
= NULL;
683 $contact->display_name
= $contact->sort_name
= $email;
684 $contact->postal_greeting_display
= $contact->email_greeting_display
= "Dear $email";
687 $contact->display_name
= $prefix . $contact->first_name
. ' ' . $contact->last_name
. $suffix;
688 $contact->sort_name
= $contact->last_name
. ', ' . $contact->first_name
;
689 $contact->postal_greeting_display
= $contact->email_greeting_display
= 'Dear ' . $contact->first_name
;
691 $contact->addressee_id
= $contact->postal_greeting_id
= $contact->email_greeting_id
= 1;
692 $contact->addressee_display
= $contact->display_name
;
693 $contact->hash
= crc32($contact->sort_name
);
695 $this->_update($contact);
696 if ($contact->is_deceased
) {
697 $this->deceasedContactIds
[] = $cid;
703 * This method adds household's data to the contact table
705 * The following fields are generated and added.
707 * contact_uuid - household_individual
708 * contact_rid - latest one
709 * household_name 'household $contact_uuid primary contact $primary_contact_uuid'
710 * nick_name 'nick $contact_uuid'
711 * primary_contact_uuid = $household_individual[$contact_uuid][0];
714 private function addHousehold() {
716 $contact = new CRM_Contact_DAO_Contact();
717 foreach ($this->Household
as $cid) {
719 $this->_addAddress($cid);
722 $contact->household_name
= $this->householdName
[$cid] . " family";
723 // need to update the sort name for the main contact table
724 $contact->display_name
= $contact->sort_name
= $contact->household_name
;
725 $contact->postal_greeting_id
= $contact->email_greeting_id
= 5;
726 $contact->postal_greeting_display
= $contact->email_greeting_display
= 'Dear ' . $contact->household_name
;
727 $contact->addressee_id
= 2;
728 $contact->addressee_display
= $contact->display_name
;
729 $contact->hash
= crc32($contact->sort_name
);
730 $this->_update($contact);
735 * This method adds organization data to the contact table
737 * The following fields are generated and added.
739 * contact_uuid - organization
740 * contact_rid - latest one
741 * organization_name 'organization $contact_uuid'
742 * legal_name 'legal $contact_uuid'
743 * nick_name 'nick $contact_uuid'
744 * sic_code 'sic $contact_uuid'
745 * primary_contact_id - random individual contact uuid
748 private function addOrganization() {
750 $org = new CRM_Contact_DAO_Contact();
751 $employees = $this->Individual
;
754 foreach ($this->Organization
as $key => $id) {
755 $org->primary_contact_id
= $website = $email = NULL;
757 $address = $this->_addAddress($id);
759 $namePre = $this->randomItem('organization_prefix');
760 $nameMid = $this->randomItem('organization_name');
761 $namePost = $this->randomItem('organization_suffix');
763 // Some orgs are named after their location
764 if ($this->probability(.7)) {
765 $place = $this->randomItem(array('city', 'street_name', 'state'));
766 $namePre = $address[$place];
768 $org->organization_name
= "$namePre $nameMid $namePost";
770 // Most orgs have a website and email
771 if ($this->probability(.8)) {
772 $website = $this->_addWebsite($id, $org->organization_name
);
773 $url = str_replace('http://', '', $website['url']);
774 $email = $this->randomItem('email_address') . '@' . $url;
775 $this->_addEmail($id, $email, self
::MAIN
);
779 if ($this->probability(.8)) {
780 $indiv = new CRM_Contact_DAO_Contact();
781 $org->primary_contact_id
= $indiv->id
= $employees[$key];
782 $indiv->organization_name
= $org->organization_name
;
783 $indiv->employer_id
= $id;
784 $this->_update($indiv);
785 // Share address with employee
786 if ($this->probability(.8)) {
787 $this->_addAddress($indiv->id
, $id);
789 // Add work email for employee
792 $email = $this->_individualEmail($indiv, $url);
793 $this->_addEmail($indiv->id
, $email, self
::WORK
);
797 // need to update the sort name for the main contact table
798 $org->display_name
= $org->sort_name
= $org->organization_name
;
799 $org->addressee_id
= 3;
800 $org->addressee_display
= $org->display_name
;
801 $org->hash
= crc32($org->sort_name
);
802 $this->_update($org);
807 * This method adds data to the contact_relationship table
809 private function addRelationship() {
811 $relationship = new CRM_Contact_DAO_Relationship();
813 // Household relationships
814 foreach ($this->householdIndividual
as $household_id => $household_member) {
816 $relationship->is_active
= 1;
818 // add child_of relationship for each child
819 $relationship->relationship_type_id
= $this->relTypes
['Child of']['id'];
820 foreach (array(0, 1) as $parent) {
821 foreach (array(2, 3) as $child) {
822 $relationship->contact_id_a
= $household_member[$child];
823 $relationship->contact_id_b
= $household_member[$parent];
824 $this->_insert($relationship);
828 // add sibling_of relationship
829 $relationship->relationship_type_id
= $this->relTypes
['Sibling of']['id'];
830 $relationship->contact_id_a
= $household_member[3];
831 $relationship->contact_id_b
= $household_member[2];
832 $this->_insert($relationship);
834 // add member_of_household relationships and shared address
835 $relationship->relationship_type_id
= $this->relTypes
['Household Member of']['id'];
836 $relationship->contact_id_b
= $household_id;
837 for ($i = 1; $i < 4; ++
$i) {
838 $relationship->contact_id_a
= $household_member[$i];
839 $this->_insert($relationship);
840 $this->_addAddress($household_member[$i], $household_id);
843 // Divorced/separated couples - end relationship and different address
844 if ($this->probability(.4)) {
845 $relationship->is_active
= 0;
846 $this->_addAddress($household_member[0]);
849 $this->_addAddress($household_member[0], $household_id);
852 // add head_of_household relationship 1 for head of house
853 $relationship->relationship_type_id
= $this->relTypes
['Head of Household for']['id'];
854 $relationship->contact_id_a
= $household_member[0];
855 $relationship->contact_id_b
= $household_id;
856 $this->_insert($relationship);
858 // add spouse_of relationship 1 for both the spouses
859 $relationship->relationship_type_id
= $this->relTypes
['Spouse of']['id'];
860 $relationship->contact_id_a
= $household_member[1];
861 $relationship->contact_id_b
= $household_member[0];
862 $this->_insert($relationship);
865 // Add current employer relationships
866 $this->_query("INSERT INTO civicrm_relationship
867 (contact_id_a, contact_id_b, relationship_type_id, is_active)
868 (SELECT id, employer_id, " . $this->relTypes
['Employee of']['id'] . ", 1 FROM civicrm_contact WHERE employer_id IN (" . implode(',', $this->Organization
) . "))"
873 * Create an address for a contact
875 * @param $cid int: contact id
876 * @param $masterContactId int: set if this is a shared address
880 private function _addAddress($cid, $masterContactId = NULL) {
882 // Share existing address
883 if ($masterContactId) {
884 $dao = new CRM_Core_DAO_Address();
885 $dao->is_primary
= 1;
886 $dao->contact_id
= $masterContactId;
888 $dao->master_id
= $dao->id
;
890 $dao->contact_id
= $cid;
891 $dao->is_primary
= $this->isPrimary($cid, 'Address');
892 $dao->location_type_id
= $this->getContactType($masterContactId) == 'Organization' ? self
::WORK
: self
::HOME
;
893 $this->_insert($dao);
896 // Generate new address
899 'contact_id' => $cid,
900 'location_type_id' => $this->getContactType($cid) == 'Organization' ? self
::MAIN
: self
::HOME
,
901 'street_number' => mt_rand(1, 1000),
902 'street_number_suffix' => ucfirst($this->randomChar()),
903 'street_name' => $this->randomItem('street_name'),
904 'street_type' => $this->randomItem('street_type'),
905 'street_number_postdirectional' => $this->randomItem('address_direction'),
909 $params['street_address'] = $params['street_number'] . $params['street_number_suffix'] . " " . $params['street_name'] . " " . $params['street_type'] . " " . $params['street_number_postdirectional'];
911 if ($params['location_type_id'] == self
::MAIN
) {
912 $params['supplemental_address_1'] = $this->randomItem('supplemental_addresses_1');
915 // Hack to add lat/long (limited to USA based addresses)
917 $params['country_id'],
918 $params['state_province_id'],
920 $params['postal_code'],
921 $params['geo_code_1'],
922 $params['geo_code_2'],
923 ) = $this->getZipCodeInfo();
925 $this->_addDAO('Address', $params);
926 $params['state'] = $this->states
[$params['state_province_id']];
932 * Add a phone number for a contact
934 * @param $cid int: contact id
938 private function _addPhone($cid) {
939 $area = $this->probability(.5) ?
'' : mt_rand(201, 899);
940 $pre = mt_rand(201, 899);
941 $post = mt_rand(1000, 9999);
943 'location_type_id' => $this->getContactType($cid) == 'Organization' ? self
::MAIN
: self
::HOME
,
944 'contact_id' => $cid,
945 'phone' => ($area ?
"($area) " : '') . "$pre-$post",
946 'phone_numeric' => $area . $pre . $post,
947 'phone_type_id' => mt_rand(1, 2),
949 $this->_addDAO('Phone', $params);
954 * Add an email for a contact
956 * @param $cid int: contact id
958 * @param $locationType
962 private function _addEmail($cid, $email, $locationType) {
964 'location_type_id' => $locationType,
965 'contact_id' => $cid,
968 $this->_addDAO('Email', $params);
973 * Add a website based on organization name
974 * Using common naming patterns
976 * @param $cid int: contact id
977 * @param $name str: contact name
981 private function _addWebsite($cid, $name) {
982 $part = array_pad(explode(' ', strtolower($name)), 3, '');
983 if (count($part) > 3) {
984 // Abbreviate the place name if it's two words
985 $domain = $part[0][0] . $part[1][0] . $part[2] . $part[3];
988 // Common naming patterns
989 switch (mt_rand(1, 3)) {
991 $domain = $part[0] . $part[1] . $part[2];
995 $domain = $part[0] . $part[1];
999 $domain = $part[0] . $part[2];
1004 'website_type_id' => 1,
1005 'location_type_id' => self
::MAIN
,
1006 'contact_id' => $cid,
1007 'url' => "http://$domain.org",
1009 $this->_addDAO('Website', $params);
1014 * Create an email address based on a person's name
1015 * Using common naming patterns
1017 * @param $contact obj: individual contact record
1018 * @param $domain str: supply a domain (i.e. for a work address)
1022 private function _individualEmail($contact, $domain = NULL) {
1023 $first = $contact->first_name
;
1024 $last = $contact->last_name
;
1027 $m = $contact->middle_name ?
$contact->middle_name
[0] . '.' : '';
1028 // Common naming patterns
1029 switch (mt_rand(1, 6)) {
1031 $email = $first . $last;
1035 $email = "$last.$first";
1039 $email = $last . $f;
1043 $email = $first . $l;
1047 $email = "$last.$m$first";
1051 $email = "$f$m$last";
1054 //to ensure we dont insert
1055 //invalid characters in email
1056 $email = preg_replace("([^a-zA-Z0-9_\.-]*)", "", $email);
1058 // Some people have numbers in their address
1059 if ($this->probability(.4)) {
1060 $email .= mt_rand(1, 99);
1062 // Generate random domain if not specified
1064 $domain = $this->randomItem('email_domain') . '.' . $this->randomItem('email_tld');
1066 return strtolower($email) . '@' . $domain;
1070 * This method populates the civicrm_entity_tag table
1072 private function addEntityTag() {
1074 $entity_tag = new CRM_Core_DAO_EntityTag();
1076 // add categories 1,2,3 for Organizations.
1077 for ($i = 0; $i < $this->numOrganization
; $i +
= 2) {
1078 $org_id = $this->Organization
[$i];
1079 // echo "org_id = $org_id\n";
1080 $entity_tag->entity_id
= $this->Organization
[$i];
1081 $entity_tag->entity_table
= 'civicrm_contact';
1082 $entity_tag->tag_id
= mt_rand(1, 3);
1083 $this->_insert($entity_tag);
1086 // add categories 4,5 for Individuals.
1087 for ($i = 0; $i < $this->numIndividual
; $i +
= 2) {
1088 $entity_tag->entity_table
= 'civicrm_contact';
1089 $entity_tag->entity_id
= $this->Individual
[$i];
1090 if (($entity_tag->entity_id
) %
3) {
1091 $entity_tag->tag_id
= mt_rand(4, 5);
1092 $this->_insert($entity_tag);
1095 // some of the individuals are in both categories (4 and 5).
1096 $entity_tag->tag_id
= 4;
1097 $this->_insert($entity_tag);
1098 $entity_tag->tag_id
= 5;
1099 $this->_insert($entity_tag);
1105 * This method populates the civicrm_group_contact table
1107 private function addGroup() {
1108 // add the 3 groups first
1109 foreach ($this->sampleData
['group'] as $groupName) {
1110 $group = new CRM_Contact_BAO_Group();
1111 $group->name
= $group->title
= $groupName;
1112 $group->group_type
= "\ 11\ 12\ 1";
1113 $group->visibility
= 'Public Pages';
1114 $group->is_active
= 1;
1118 // 60 are for newsletter
1119 for ($i = 0; $i < 60; $i++
) {
1120 $groupContact = new CRM_Contact_DAO_GroupContact();
1121 // newsletter subscribers
1122 $groupContact->group_id
= 2;
1123 $groupContact->contact_id
= $this->Individual
[$i];
1124 // always add members
1125 $groupContact->status
= 'Added';
1127 $subscriptionHistory = new CRM_Contact_DAO_SubscriptionHistory();
1128 $subscriptionHistory->contact_id
= $groupContact->contact_id
;
1130 $subscriptionHistory->group_id
= $groupContact->group_id
;
1131 $subscriptionHistory->status
= $groupContact->status
;
1133 $subscriptionHistory->method
= $this->randomItem($this->subscriptionHistoryMethod
);
1134 $subscriptionHistory->date
= $this->randomDate();
1135 if ($groupContact->status
!= 'Pending') {
1136 $this->_insert($groupContact);
1138 $this->_insert($subscriptionHistory);
1142 for ($i = 0; $i < 15; $i++
) {
1143 $groupContact = new CRM_Contact_DAO_GroupContact();
1145 $groupContact->group_id
= 3;
1146 $groupContact->contact_id
= $this->Individual
[$i +
60];
1147 // membership status
1148 $groupContact->status
= 'Added';
1150 $subscriptionHistory = new CRM_Contact_DAO_SubscriptionHistory();
1151 $subscriptionHistory->contact_id
= $groupContact->contact_id
;
1152 $subscriptionHistory->group_id
= $groupContact->group_id
;
1153 $subscriptionHistory->status
= $groupContact->status
;
1155 $subscriptionHistory->method
= $this->randomItem($this->subscriptionHistoryMethod
);
1156 $subscriptionHistory->date
= $this->randomDate();
1158 if ($groupContact->status
!= 'Pending') {
1159 $this->_insert($groupContact);
1161 $this->_insert($subscriptionHistory);
1164 // 8 advisory board group
1165 for ($i = 0; $i < 8; $i++
) {
1166 $groupContact = new CRM_Contact_DAO_GroupContact();
1167 // advisory board group
1168 $groupContact->group_id
= 4;
1169 $groupContact->contact_id
= $this->Individual
[$i * 7];
1170 // membership status
1171 $groupContact->status
= 'Added';
1173 $subscriptionHistory = new CRM_Contact_DAO_SubscriptionHistory();
1174 $subscriptionHistory->contact_id
= $groupContact->contact_id
;
1175 $subscriptionHistory->group_id
= $groupContact->group_id
;
1176 $subscriptionHistory->status
= $groupContact->status
;
1178 $subscriptionHistory->method
= $this->randomItem($this->subscriptionHistoryMethod
);
1179 $subscriptionHistory->date
= $this->randomDate();
1181 if ($groupContact->status
!= 'Pending') {
1182 $this->_insert($groupContact);
1184 $this->_insert($subscriptionHistory);
1187 //In this function when we add groups that time we are cache the contact fields
1188 //But at the end of setup we are appending sample custom data, so for consistency
1190 Civi
::cache('fields')->flush();
1191 CRM_Core_BAO_Cache
::resetCaches();
1195 * This method populates the civicrm_note table
1197 private function addNote() {
1199 'entity_table' => 'civicrm_contact',
1203 for ($i = 0; $i < self
::NUM_CONTACT
; $i +
= 10) {
1204 $params['entity_id'] = $this->randomItem($this->contact
);
1205 $params['note'] = $this->randomItem('note');
1206 $params['modified_date'] = $this->randomDate();
1207 $this->_addDAO('Note', $params);
1212 * This method populates the civicrm_activity_history table
1214 private function addActivity() {
1215 $contactDAO = new CRM_Contact_DAO_Contact();
1216 $contactDAO->contact_type
= 'Individual';
1217 $contactDAO->selectAdd();
1218 $contactDAO->selectAdd('id');
1219 $contactDAO->orderBy('sort_name');
1220 $contactDAO->find();
1223 $activityContacts = CRM_Activity_BAO_ActivityContact
::buildOptions('record_type_id', 'validate');
1224 while ($contactDAO->fetch()) {
1228 for ($i = 0; $i < self
::NUM_ACTIVITY
; $i++
) {
1229 $activityDAO = new CRM_Activity_DAO_Activity();
1230 $activityId = CRM_Core_OptionGroup
::values('activity_type', NULL, NULL, NULL, ' AND v.name IN ("Tell A Friend", "Pledge Acknowledgment")');
1231 $activityTypeID = array_rand($activityId);
1232 $activity = CRM_Core_PseudoConstant
::activityType();
1233 $activityDAO->activity_type_id
= $activityTypeID;
1234 $activityDAO->subject
= "Subject for $activity[$activityTypeID]";
1235 $activityDAO->activity_date_time
= $this->randomDate();
1236 $activityDAO->status_id
= 2;
1237 $this->_insert($activityDAO);
1239 $activityContactDAO = new CRM_Activity_DAO_ActivityContact();
1240 $activityContactDAO->activity_id
= $activityDAO->id
;
1241 $activityContactDAO->contact_id
= $contactDAO->id
;
1242 $activityContactDAO->record_type_id
= CRM_Utils_Array
::key('Activity Source', $activityContacts);
1243 $this->_insert($activityContactDAO);
1245 if ($activityTypeID == 9) {
1246 $activityContactDAO = new CRM_Activity_DAO_ActivityContact();
1247 $activityContactDAO->activity_id
= $activityDAO->id
;
1248 $activityContactDAO->contact_id
= mt_rand(1, 101);
1249 $activityContactDAO->record_type_id
= CRM_Utils_Array
::key('Activity Targets', $activityContacts);
1250 $this->_insert($activityContactDAO);
1259 public function getZipCodeInfo() {
1261 if (!$this->stateMap
) {
1262 $query = 'SELECT id, name, abbreviation from civicrm_state_province where country_id = 1228';
1263 $dao = new CRM_Core_DAO();
1264 $dao->query($query);
1265 $this->stateMap
= array();
1266 while ($dao->fetch()) {
1267 $this->stateMap
[$dao->abbreviation
] = $dao->id
;
1268 $this->states
[$dao->id
] = $dao->name
;
1272 static $zipCodes = NULL;
1273 if ($zipCodes === NULL) {
1274 $zipCodes = json_decode(file_get_contents(__DIR__
. '/zipcodes.json'));
1277 $zipCode = $zipCodes[mt_rand(0, count($zipCodes))];
1279 if ($this->stateMap
[$zipCode->state
]) {
1280 $stateID = $this->stateMap
[$zipCode->state
];
1286 $zip = str_pad($zipCode->zip
, 5, '0', STR_PAD_LEFT
);
1287 return array(1228, $stateID, $zipCode->city
, $zip, $zipCode->latitude
, $zipCode->longitude
);
1295 public static function getLatLong($zipCode) {
1296 $query = "http://maps.google.com/maps?q=$zipCode&output=js";
1297 $userAgent = "Mozilla/5.0 (Macintosh; U; PPC Mac OS X Mach-O; en-US; rv:1.7.5) Gecko/20041107 Firefox/1.0";
1300 curl_setopt($ch, CURLOPT_URL
, $query);
1301 curl_setopt($ch, CURLOPT_HEADER
, FALSE);
1302 curl_setopt($ch, CURLOPT_USERAGENT
, $userAgent);
1303 curl_setopt($ch, CURLOPT_RETURNTRANSFER
, 1);
1305 // grab URL and pass it to the browser
1306 $outstr = curl_exec($ch);
1308 // close CURL resource, and free up system resources
1311 $preg = "/'(<\?xml.+?)',/s";
1312 preg_match($preg, $outstr, $matches);
1314 $xml = simplexml_load_string($matches[1]);
1315 $attributes = $xml->center
->attributes();
1316 if (!empty($attributes)) {
1317 return array((float ) $attributes['lat'], (float ) $attributes['lng']);
1320 return array(NULL, NULL);
1323 private function addMembershipType() {
1324 $organizationDAO = new CRM_Contact_DAO_Contact();
1325 $organizationDAO->id
= 5;
1326 $organizationDAO->find(TRUE);
1327 $contact_id = $organizationDAO->contact_id
;
1329 $membershipType = "INSERT INTO civicrm_membership_type
1330 (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)
1332 ('General', 'Regular annual membership.', " . $contact_id . ", 2, 100, 'year', 1, 'rolling',null, null, 7, 'b_a', 'Public', 1, 1),
1333 ('Student', 'Discount membership for full-time students.', " . $contact_id . ", 2, 50, 'year', 1, 'rolling', null, null, 7, 'b_a', 'Public', 2, 1),
1334 ('Lifetime', 'Lifetime membership.', " . $contact_id . ", 2, 1200, 'lifetime', 1, 'rolling', null, null, 7, 'b_a', 'Admin', 3, 1);
1336 $this->_query($membershipType);
1339 private function addMembership() {
1340 $contact = new CRM_Contact_DAO_Contact();
1341 $contact->query("SELECT id FROM civicrm_contact where contact_type = 'Individual'");
1342 $activityContacts = CRM_Activity_BAO_ActivityContact
::buildOptions('record_type_id', 'validate');
1343 while ($contact->fetch()) {
1344 $contacts[] = $contact->id
;
1348 $randomContacts = array_slice($contacts, 20, 30);
1350 $sources = array('Payment', 'Donation', 'Check');
1351 $membershipTypes = array(1, 2);
1352 $membershipTypeNames = array('General', 'Student');
1353 $statuses = array(3, 4);
1356 INSERT INTO civicrm_membership
1357 (contact_id, membership_type_id, join_date, start_date, end_date, source, status_id)
1362 INSERT INTO civicrm_activity
1363 (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)
1367 $activityContact = "
1368 INSERT INTO civicrm_activity_contact
1369 (activity_id, contact_id, record_type_id)
1373 $currentActivityID = CRM_Core_DAO
::singleValueQuery("SELECT MAX(id) FROM civicrm_activity");
1374 $sourceID = CRM_Utils_Array
::key('Activity Source', $activityContacts);
1375 foreach ($randomContacts as $count => $dontCare) {
1376 $source = $this->randomItem($sources);
1377 $activitySourceId = $count +
1;
1378 $currentActivityID++
;
1379 $activityContact .= "( $currentActivityID, {$randomContacts[$count]}, {$sourceID} )";
1380 if ((($count +
1) %
11 == 0)) {
1381 // lifetime membership, status can be anything
1382 $startDate = date('Y-m-d', mktime(0, 0, 0, date('m'), (date('d') - $count), date('Y')));
1383 $membership .= "( {$randomContacts[$count]}, 3, '{$startDate}', '{$startDate}', null, '{$source}', 1)";
1384 $activity .= "( {$activitySourceId}, 7, 'Lifetime', '{$startDate} 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 )";
1386 elseif (($count +
1) %
5 == 0) {
1387 // Grace or expired, memberhsip type is random of 1 & 2
1388 $randIndex = array_rand($membershipTypes);
1389 $membershipTypeId = $membershipTypes[$randIndex];
1390 $membershipStatusId = $statuses[$randIndex];
1391 $membershipTypeName = $membershipTypeNames[$randIndex];
1392 $YearFactor = $membershipTypeId * 2;
1393 //reverse the type and consider as year factor.
1394 if ($YearFactor != 2) {
1397 $dateFactor = ($count * ($YearFactor) * ($YearFactor) * ($YearFactor));
1398 $startDate = date('Y-m-d', mktime(0, 0, 0,
1400 (date('d') - ($dateFactor)),
1401 (date('Y') - ($YearFactor))
1403 $partOfDate = explode('-', $startDate);
1404 $endDate = date('Y-m-d', mktime(0, 0, 0,
1406 ($partOfDate[2] - 1),
1407 ($partOfDate[0] +
($YearFactor))
1410 $membership .= "( {$randomContacts[$count]}, {$membershipTypeId}, '{$startDate}', '{$startDate}', '{$endDate}', '{$source}', {$membershipStatusId})";
1411 $activity .= "( {$activitySourceId}, 7, '{$membershipTypeName}', '{$startDate} 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 )";
1413 elseif (($count +
1) %
2 == 0) {
1414 // membership type 2
1415 $startDate = date('Y-m-d', mktime(0, 0, 0, date('m'), (date('d') - $count), date('Y')));
1416 $endDate = date('Y-m-d', mktime(0, 0, 0, date('m'), (date('d') - ($count +
1)), (date('Y') +
1)));
1417 $membership .= "( {$randomContacts[$count]}, 2, '{$startDate}', '{$startDate}', '{$endDate}', '{$source}', 1)";
1418 $activity .= "( {$activitySourceId}, 7, 'Student', '{$startDate} 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 )";
1421 // membership type 1
1422 $startDate = date('Y-m-d', mktime(0, 0, 0, date('m'), (date('d') - $count), date('Y')));
1423 $endDate = date('Y-m-d', mktime(0, 0, 0, date('m'), (date('d') - ($count +
1)), (date('Y') +
2)));
1424 $membership .= "( {$randomContacts[$count]}, 1, '{$startDate}', '{$startDate}', '{$endDate}', '{$source}', 1)";
1425 $activity .= "( {$activitySourceId}, 7, 'General', '{$startDate} 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 )";
1431 $activityContact .= ",";
1435 $this->_query($membership);
1436 $this->_query($activity);
1437 $this->_query($activityContact);
1445 public static function repairDate($date) {
1446 $dropArray = array('-' => '', ':' => '', ' ' => '');
1447 return strtr($date, $dropArray);
1450 private function addMembershipLog() {
1451 $membership = new CRM_Member_DAO_Membership();
1452 $membership->query("SELECT id FROM civicrm_membership");
1453 while ($membership->fetch()) {
1454 $ids[] = $membership->id
;
1456 foreach ($ids as $id) {
1457 $membership = new CRM_Member_DAO_Membership();
1458 $membership->id
= $id;
1459 $membershipLog = new CRM_Member_DAO_MembershipLog();
1460 if ($membership->find(TRUE)) {
1461 $membershipLog->membership_id
= $membership->id
;
1462 $membershipLog->status_id
= $membership->status_id
;
1463 $membershipLog->start_date
= self
::repairDate($membership->start_date
);
1464 $membershipLog->end_date
= self
::repairDate($membership->end_date
);
1465 $membershipLog->modified_id
= $membership->contact_id
;
1466 $membershipLog->modified_date
= date("Ymd");
1467 $membershipLog->membership_type_id
= $membership->membership_type_id
;
1468 $membershipLog->save();
1470 $membershipLog = NULL;
1474 private function addEvent() {
1475 $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)
1477 ( 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),
1478 ( 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),
1479 ( 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)
1481 $this->_query($event);
1483 $sql = "SELECT id from civicrm_address where street_address = '14S El Camino Way E'";
1484 $eventAdd1 = CRM_Core_DAO
::singleValueQuery($sql);
1485 $sql = "SELECT id from civicrm_address where street_address = '11B Woodbridge Path SW'";
1486 $eventAdd2 = CRM_Core_DAO
::singleValueQuery($sql);
1487 $sql = "SELECT id from civicrm_address where street_address = '581O Lincoln Dr SW'";
1488 $eventAdd3 = CRM_Core_DAO
::singleValueQuery($sql);
1490 $event = "INSERT INTO civicrm_email (contact_id, location_type_id, email, is_primary, is_billing, on_hold, hold_date, reset_date)
1492 (NULL, 1, 'development@example.org', 0, 0, 0, NULL, NULL),
1493 (NULL, 1, 'tournaments@example.org', 0, 0, 0, NULL, NULL),
1494 (NULL, 1, 'celebration@example.org', 0, 0, 0, NULL, NULL)
1496 $this->_query($event);
1498 $sql = "SELECT id from civicrm_email where email = 'development@example.org'";
1499 $eventEmail1 = CRM_Core_DAO
::singleValueQuery($sql);
1500 $sql = "SELECT id from civicrm_email where email = 'tournaments@example.org'";
1501 $eventEmail2 = CRM_Core_DAO
::singleValueQuery($sql);
1502 $sql = "SELECT id from civicrm_email where email = 'celebration@example.org'";
1503 $eventEmail3 = CRM_Core_DAO
::singleValueQuery($sql);
1505 $event = "INSERT INTO civicrm_phone (contact_id, location_type_id, is_primary, is_billing, mobile_provider_id, phone, phone_numeric, phone_type_id)
1507 (NULL, 1, 0, 0, NULL, '204 222-1000', '2042221000', '1'),
1508 (NULL, 1, 0, 0, NULL, '204 223-1000', '2042231000', '1'),
1509 (NULL, 1, 0, 0, NULL, '303 323-1000', '3033231000', '1')
1511 $this->_query($event);
1513 $sql = "SELECT id from civicrm_phone where phone = '204 222-1000'";
1514 $eventPhone1 = CRM_Core_DAO
::singleValueQuery($sql);
1515 $sql = "SELECT id from civicrm_phone where phone = '204 223-1000'";
1516 $eventPhone2 = CRM_Core_DAO
::singleValueQuery($sql);
1517 $sql = "SELECT id from civicrm_phone where phone = '303 323-1000'";
1518 $eventPhone3 = CRM_Core_DAO
::singleValueQuery($sql);
1520 $event = "INSERT INTO civicrm_loc_block ( address_id, email_id, phone_id, address_2_id, email_2_id, phone_2_id)
1522 ( $eventAdd1, $eventEmail1, $eventPhone1, NULL,NULL,NULL),
1523 ( $eventAdd2, $eventEmail2, $eventPhone2, NULL,NULL,NULL),
1524 ( $eventAdd3, $eventEmail3, $eventPhone3, NULL,NULL,NULL)
1527 $this->_query($event);
1529 $sql = "SELECT id from civicrm_loc_block where phone_id = $eventPhone1 AND email_id = $eventEmail1 AND address_id = $eventAdd1";
1530 $eventLok1 = CRM_Core_DAO
::singleValueQuery($sql);
1531 $sql = "SELECT id from civicrm_loc_block where phone_id = $eventPhone2 AND email_id = $eventEmail2 AND address_id = $eventAdd2";
1532 $eventLok2 = CRM_Core_DAO
::singleValueQuery($sql);
1533 $sql = "SELECT id from civicrm_loc_block where phone_id = $eventPhone3 AND email_id = $eventEmail3 AND address_id = $eventAdd3";
1534 $eventLok3 = CRM_Core_DAO
::singleValueQuery($sql);
1536 $event = "INSERT INTO civicrm_event
1537 ( 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 )
1539 ( '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=https://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' ),
1540 ( '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=https://civicrm.org>Back to CiviCRM Home Page</a></p>', 0, NULL, NULL, 1, 0, 'USD' ),
1541 ( '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=https://civicrm.org>Back to CiviCRM Home Page</a></p>', 0, NULL, NULL, 0, 0, 'USD' )
1543 $this->_query($event);
1546 $eventTemplates = "INSERT INTO civicrm_event
1547 ( 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 )
1549 ( 1, 'Free Meeting without Online Registration', 4, 1, 1, 1, 0, 0, null, null, null, null, null, null, null, null, null, 1, 'USD' ),
1550 ( 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' ),
1551 ( 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' )";
1553 $this->_query($eventTemplates);
1555 $ufJoinValues = $tellFriendValues = array();
1556 $profileID = CRM_Core_DAO
::singleValueQuery("Select id from civicrm_uf_group where name ='event_registration'");
1558 // grab id's for all events and event templates
1561 FROM civicrm_event";
1563 $template = CRM_Core_DAO
::executeQuery($query);
1564 while ($template->fetch()) {
1566 $ufJoinValues[] = "( 1, 'CiviEvent', 'civicrm_event', {$template->id}, 1, {$profileID} )";
1568 $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)";
1571 //insert values in civicrm_uf_join for the required event_registration profile - CRM-9587
1572 if (!empty($ufJoinValues)) {
1573 $includeProfile = "INSERT INTO civicrm_uf_join
1574 (is_active, module, entity_table, entity_id, weight, uf_group_id )
1575 VALUES " . implode(',', $ufJoinValues);
1576 $this->_query($includeProfile);
1579 //insert values in civicrm_tell_friend
1580 if (!empty($tellFriendValues)) {
1581 $tellFriend = "INSERT INTO civicrm_tell_friend
1582 (entity_table, entity_id, title, intro, suggested_message,
1583 general_link, thankyou_title, thankyou_text, is_active)
1584 VALUES " . implode(',', $tellFriendValues);
1585 $this->_query($tellFriend);
1589 private function addParticipant() {
1590 $contact = new CRM_Contact_DAO_Contact();
1591 $contact->query("SELECT id FROM civicrm_contact");
1592 while ($contact->fetch()) {
1593 $contacts[] = $contact->id
;
1596 $randomContacts = array_slice($contacts, 20, 50);
1599 INSERT INTO civicrm_participant
1600 (contact_id, event_id, status_id, role_id, register_date, source, fee_level, is_test, fee_amount, fee_currency)
1602 ( " . $randomContacts[0] . ", 1, 1, 1, '2009-01-21', 'Check', 'Single', 0, 50, 'USD'),
1603 ( " . $randomContacts[1] . ", 2, 2, 2, '2008-05-07', 'Credit Card', 'Soprano', 0, 50, 'USD'),
1604 ( " . $randomContacts[2] . ", 3, 3, 3, '2008-05-05', 'Credit Card', 'Tiny-tots (ages 5-8)', 0, 800, 'USD') ,
1605 ( " . $randomContacts[3] . ", 1, 4, 4, '2008-10-21', 'Direct Transfer', 'Single', 0, 50, 'USD'),
1606 ( " . $randomContacts[4] . ", 2, 1, 1, '2008-01-10', 'Check', 'Soprano', 0, 50, 'USD'),
1607 ( " . $randomContacts[5] . ", 3, 2, 2, '2008-03-05', 'Direct Transfer', 'Tiny-tots (ages 5-8)', 0, 800, 'USD'),
1608 ( " . $randomContacts[6] . ", 1, 3, 3, '2009-07-21', 'Direct Transfer', 'Single', 0, 50, 'USD'),
1609 ( " . $randomContacts[7] . ", 2, 4, 4, '2009-03-07', 'Credit Card', 'Soprano', 0, 50, 'USD'),
1610 ( " . $randomContacts[8] . ", 3, 1, 1, '2008-02-05', 'Direct Transfer', 'Tiny-tots (ages 5-8)', 0, 800, 'USD'),
1611 ( " . $randomContacts[9] . ", 1, 2, 2, '2008-02-01', 'Check', 'Single', 0, 50, 'USD'),
1612 ( " . $randomContacts[10] . ", 2, 3, 3, '2009-01-10', 'Direct Transfer', 'Soprano', 0, 50, 'USD'),
1613 ( " . $randomContacts[11] . ", 3, 4, 4, '2009-03-06', 'Credit Card', 'Tiny-tots (ages 5-8)', 0, 800, 'USD'),
1614 ( " . $randomContacts[12] . ", 1, 1, 2, '2008-06-04', 'Credit Card', 'Single', 0, 50, 'USD'),
1615 ( " . $randomContacts[13] . ", 2, 2, 3, '2008-01-10', 'Direct Transfer', 'Soprano', 0, 50, 'USD'),
1616 ( " . $randomContacts[14] . ", 3, 4, 1, '2008-07-04', 'Check', 'Tiny-tots (ages 5-8)', 0, 800, 'USD'),
1617 ( " . $randomContacts[15] . ", 1, 4, 2, '2009-01-21', 'Credit Card', 'Single', 0, 50, 'USD'),
1618 ( " . $randomContacts[16] . ", 2, 2, 3, '2008-01-10', 'Credit Card', 'Soprano', 0, 50, 'USD'),
1619 ( " . $randomContacts[17] . ", 3, 3, 1, '2009-03-05', 'Credit Card', 'Tiny-tots (ages 5-8)', 0, 800, 'USD'),
1620 ( " . $randomContacts[18] . ", 1, 2, 1, '2008-10-21', 'Direct Transfer', 'Single', 0, 50, 'USD'),
1621 ( " . $randomContacts[19] . ", 2, 4, 1, '2009-01-10', 'Credit Card', 'Soprano', 0, 50, 'USD'),
1622 ( " . $randomContacts[20] . ", 3, 1, 4, '2008-03-25', 'Check', 'Tiny-tots (ages 5-8)', 0, 800, 'USD'),
1623 ( " . $randomContacts[21] . ", 1, 2, 3, '2009-10-21', 'Direct Transfer', 'Single', 0, 50, 'USD'),
1624 ( " . $randomContacts[22] . ", 2, 4, 1, '2008-01-10', 'Direct Transfer', 'Soprano', 0, 50, 'USD'),
1625 ( " . $randomContacts[23] . ", 3, 3, 1, '2008-03-11', 'Credit Card', 'Tiny-tots (ages 5-8)', 0, 800, 'USD'),
1626 ( " . $randomContacts[24] . ", 3, 2, 2, '2008-04-05', 'Direct Transfer', 'Tiny-tots (ages 5-8)', 0, 800, 'USD'),
1627 ( " . $randomContacts[25] . ", 1, 1, 1, '2009-01-21', 'Check', 'Single', 0, 50, 'USD'),
1628 ( " . $randomContacts[26] . ", 2, 2, 2, '2008-05-07', 'Credit Card', 'Soprano', 0, 50, 'USD'),
1629 ( " . $randomContacts[27] . ", 3, 3, 3, '2009-12-12', 'Direct Transfer', 'Tiny-tots (ages 5-8)', 0, 800, 'USD'),
1630 ( " . $randomContacts[28] . ", 1, 4, 4, '2009-12-13', 'Credit Card', 'Single', 0, 50, 'USD'),
1631 ( " . $randomContacts[29] . ", 2, 1, 1, '2009-12-14', 'Direct Transfer', 'Soprano', 0, 50, 'USD'),
1632 ( " . $randomContacts[30] . ", 3, 2, 2, '2009-12-15', 'Credit Card', 'Tiny-tots (ages 5-8)', 0, 800, 'USD'),
1633 ( " . $randomContacts[31] . ", 1, 3, 3, '2009-07-21', 'Check', 'Single', 0, 50, 'USD'),
1634 ( " . $randomContacts[32] . ", 2, 4, 4, '2009-03-07', 'Direct Transfer', 'Soprano', 0, 50, 'USD'),
1635 ( " . $randomContacts[33] . ", 3, 1, 1, '2009-12-15', 'Credit Card', 'Tiny-tots (ages 5-8)', 0, 800, 'USD'),
1636 ( " . $randomContacts[34] . ", 1, 2, 2, '2009-12-13', 'Direct Transfer', 'Single', 0, 50, 'USD'),
1637 ( " . $randomContacts[35] . ", 2, 3, 3, '2009-01-10', 'Direct Transfer', 'Soprano', 0, 50, 'USD'),
1638 ( " . $randomContacts[36] . ", 3, 4, 4, '2009-03-06', 'Check', 'Tiny-tots (ages 5-8)', 0, 800, 'USD'),
1639 ( " . $randomContacts[37] . ", 1, 1, 2, '2009-12-13', 'Direct Transfer', 'Single', 0, 50, 'USD'),
1640 ( " . $randomContacts[38] . ", 2, 2, 3, '2008-01-10', 'Direct Transfer', 'Soprano', 0, 50, 'USD'),
1641 ( " . $randomContacts[39] . ", 3, 4, 1, '2009-12-14', 'Credit Card', 'Tiny-tots (ages 5-8)', 0, 800, 'USD'),
1642 ( " . $randomContacts[40] . ", 1, 4, 2, '2009-01-21', 'Credit Card', 'Single', 0, 50, 'USD'),
1643 ( " . $randomContacts[41] . ", 2, 2, 3, '2009-12-15', 'Credit Card', 'Soprano', 0, 50, 'USD'),
1644 ( " . $randomContacts[42] . ", 3, 3, 1, '2009-03-05', 'Credit Card', 'Tiny-tots (ages 5-8)', 0, 800, 'USD'),
1645 ( " . $randomContacts[43] . ", 1, 2, 1, '2009-12-13', 'Direct Transfer', 'Single', 0, 50, 'USD'),
1646 ( " . $randomContacts[44] . ", 2, 4, 1, '2009-01-10', 'Direct Transfer', 'Soprano', 0, 50, 'USD'),
1647 ( " . $randomContacts[45] . ", 3, 1, 4, '2009-12-13', 'Check', 'Tiny-tots (ages 5-8)', 0, 800, 'USD'),
1648 ( " . $randomContacts[46] . ", 1, 2, 3, '2009-10-21', 'Credit Card', 'Single', 0, 50, 'USD'),
1649 ( " . $randomContacts[47] . ", 2, 4, 1, '2009-12-10', 'Credit Card', 'Soprano', 0, 50, 'USD'),
1650 ( " . $randomContacts[48] . ", 3, 3, 1, '2009-03-11', 'Credit Card', 'Tiny-tots (ages 5-8)', 0, 800, 'USD'),
1651 ( " . $randomContacts[49] . ", 3, 2, 2, '2009-04-05', 'Check', 'Tiny-tots (ages 5-8)', 0, 800, 'USD');
1653 $this->_query($participant);
1656 INSERT INTO civicrm_activity
1657 (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)
1659 (01, 5, 'NULL', '2009-01-21 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1660 (02, 5, 'NULL', '2008-05-07 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1661 (03, 5, 'NULL', '2008-05-05 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1662 (04, 5, 'NULL', '2008-10-21 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1663 (05, 5, 'NULL', '2008-01-10 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1664 (06, 5, 'NULL', '2008-03-05 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1665 (07, 5, 'NULL', '2009-07-21 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1666 (08, 5, 'NULL', '2009-03-07 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1667 (09, 5, 'NULL', '2008-02-05 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1668 (10, 5, 'NULL', '2008-02-01 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1669 (11, 5, 'NULL', '2009-01-10 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1670 (12, 5, 'NULL', '2009-03-06 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1671 (13, 5, 'NULL', '2008-06-04 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1672 (14, 5, 'NULL', '2008-01-10 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1673 (15, 5, 'NULL', '2008-07-04 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1674 (16, 5, 'NULL', '2009-01-21 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1675 (17, 5, 'NULL', '2008-01-10 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1676 (18, 5, 'NULL', '2009-03-05 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1677 (19, 5, 'NULL', '2008-10-21 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1678 (20, 5, 'NULL', '2009-01-10 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1679 (21, 5, 'NULL', '2008-03-25 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1680 (22, 5, 'NULL', '2009-10-21 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1681 (23, 5, 'NULL', '2008-01-10 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1682 (24, 5, 'NULL', '2008-03-11 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1683 (25, 5, 'NULL', '2008-04-05 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1684 (26, 5, 'NULL', '2009-01-21 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1685 (27, 5, 'NULL', '2008-05-07 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1686 (28, 5, 'NULL', '2009-12-12 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1687 (29, 5, 'NULL', '2009-12-13 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1688 (30, 5, 'NULL', '2009-12-14 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1689 (31, 5, 'NULL', '2009-12-15 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1690 (32, 5, 'NULL', '2009-07-21 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1691 (33, 5, 'NULL', '2009-03-07 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1692 (34, 5, 'NULL', '2009-12-15 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1693 (35, 5, 'NULL', '2009-12-13 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1694 (36, 5, 'NULL', '2009-01-10 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1695 (37, 5, 'NULL', '2009-03-06 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1696 (38, 5, 'NULL', '2009-12-13 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1697 (39, 5, 'NULL', '2008-01-10 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1698 (40, 5, 'NULL', '2009-12-14 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1699 (41, 5, 'NULL', '2009-01-21 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1700 (42, 5, 'NULL', '2009-12-15 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1701 (43, 5, 'NULL', '2009-03-05 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1702 (44, 5, 'NULL', '2009-12-13 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1703 (45, 5, 'NULL', '2009-01-10 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1704 (46, 5, 'NULL', '2009-12-13 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1705 (47, 5, 'NULL', '2009-10-21 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1706 (48, 5, 'NULL', '2009-12-10 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1707 (49, 5, 'NULL', '2009-03-11 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1708 (50, 5, 'NULL', '2009-04-05 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 )
1710 $this->_query($query);
1712 $activityContact = "
1713 INSERT INTO civicrm_activity_contact
1714 (contact_id, activity_id, record_type_id)
1717 $activityContacts = CRM_Activity_BAO_ActivityContact
::buildOptions('record_type_id', 'validate');
1718 $currentActivityID = CRM_Core_DAO
::singleValueQuery("SELECT MAX(id) FROM civicrm_activity");
1719 $currentActivityID -= 50;
1720 $sourceID = CRM_Utils_Array
::key('Activity Source', $activityContacts);
1721 for ($i = 0; $i < 50; $i++
) {
1722 $currentActivityID++
;
1723 $activityContact .= "({$randomContacts[$i]}, $currentActivityID, $sourceID)";
1725 $activityContact .= ", ";
1728 $this->_query($activityContact);
1731 private function addPCP() {
1733 INSERT INTO `civicrm_pcp`
1734 (contact_id, status_id, title, intro_text, page_text, donate_link_text, page_id, page_type, is_thermometer, is_honor_roll, goal_amount, currency, is_active, pcp_block_id, is_notify)
1736 ({$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=\"https://civicrm.org\">You can learn more about CiviCRM here</a>.</p>\r\n<p>Then click the <strong>Contribute Now</strong> button to go to our easy-to-use online contribution form.</p>', 'Contribute Now', 1, 'contribute', 1, 1, 5000.00, 'USD', 1, 1, 1);
1738 $this->_query($query);
1741 private function addContribution() {
1743 INSERT INTO civicrm_contribution
1744 (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 )
1746 (2, 1, 4, '2010-04-11 00:00:00', 0.00, 125.00, NULL, '1041', 'USD', NULL, NULL, NULL, NULL, 'Apr 2007 Mailer 1' ),
1747 (4, 1, 1, '2010-03-21 00:00:00', 0.00, 50.00, 'P20901X1', NULL, 'USD', NULL, NULL, NULL, NULL, 'Online: Save the Penguins' ),
1748 (6, 1, 4, '2010-04-29 00:00:00', 0.00, 25.00, NULL, '2095', 'USD', NULL, NULL, NULL, NULL, 'Apr 2007 Mailer 1' ),
1749 (8, 1, 4, '2010-04-11 00:00:00', 0.00, 50.00, NULL, '10552', 'USD', NULL, NULL, NULL, NULL, 'Apr 2007 Mailer 1' ),
1750 (16, 1, 4, '2010-04-15 00:00:00', 0.00, 500.00, NULL, '509', 'USD', NULL, NULL, NULL, NULL, 'Apr 2007 Mailer 1' ),
1751 (19, 1, 4, '2010-04-11 00:00:00', 0.00, 175.00, NULL, '102', 'USD', NULL, NULL, NULL, NULL, 'Apr 2007 Mailer 1' ),
1752 (82, 1, 1, '2010-03-27 00:00:00', 0.00, 50.00, 'P20193L2', NULL, 'USD', NULL, NULL, NULL, NULL, 'Online: Save the Penguins' ),
1753 (92, 1, 1, '2010-03-08 00:00:00', 0.00, 10.00, 'P40232Y3', NULL, 'USD', NULL, NULL, NULL, NULL, 'Online: Help CiviCRM' ),
1754 (34, 1, 1, '2010-04-22 00:00:00', 0.00, 250.00, 'P20193L6', NULL, 'USD', NULL, NULL, NULL, NULL, 'Online: Help CiviCRM' ),
1755 (71, 1, 1, '2009-07-01 11:53:50', 0.00, 500.00, 'PL71', NULL, 'USD', NULL, NULL, NULL, NULL, NULL ),
1756 (43, 1, 1, '2009-07-01 12:55:41', 0.00, 200.00, 'PL43II', NULL, 'USD', NULL, NULL, NULL, NULL, NULL ),
1757 (32, 1, 1, '2009-10-01 11:53:50', 0.00, 200.00, 'PL32I', NULL, 'USD', NULL, NULL, NULL, NULL, NULL ),
1758 (32, 1, 1, '2009-12-01 12:55:41', 0.00, 200.00, 'PL32II', NULL, 'USD', NULL, NULL, NULL, NULL, NULL );
1760 $this->_query($query);
1762 $currentActivityID = CRM_Core_DAO
::singleValueQuery("SELECT MAX(id) FROM civicrm_activity");
1764 INSERT INTO civicrm_activity
1765 (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)
1767 (1, 6, '$ 125.00-Apr 2007 Mailer 1', '2010-04-11 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1768 (2, 6, '$ 50.00-Online: Save the Penguins', '2010-03-21 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1769 (3, 6, '$ 25.00-Apr 2007 Mailer 1', '2010-04-29 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1770 (4, 6, '$ 50.00-Apr 2007 Mailer 1', '2010-04-11 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1771 (5, 6, '$ 500.00-Apr 2007 Mailer 1', '2010-04-15 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1772 (6, 6, '$ 175.00-Apr 2007 Mailer 1', '2010-04-11 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1773 (7, 6, '$ 50.00-Online: Save the Penguins', '2010-03-27 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1774 (8, 6, '$ 10.00-Online: Save the Penguins', '2010-03-08 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1775 (9, 6, '$ 250.00-Online: Save the Penguins', '2010-04-22 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1776 (10, 6, NULL, '2009-07-01 11:53:50', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1777 (11, 6, NULL, '2009-07-01 12:55:41', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1778 (12, 6, NULL, '2009-10-01 11:53:50', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 ),
1779 (13, 6, NULL, '2009-12-01 12:55:41', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2 );
1781 $this->_query($query);
1783 $activityContact = "
1784 INSERT INTO civicrm_activity_contact
1785 (contact_id, activity_id, record_type_id)
1789 $arbitraryNumbers = array(2, 4, 6, 8, 16, 19, 82, 92, 34, 71, 43, 32, 32);
1790 for ($i = 0; $i < count($arbitraryNumbers); $i++
) {
1791 $currentActivityID++
;
1792 $activityContact .= "({$arbitraryNumbers[$i]}, $currentActivityID, 2)";
1793 if ($i != count($arbitraryNumbers) - 1) {
1794 $activityContact .= ", ";
1797 $this->_query($activityContact);
1800 private function addSoftContribution() {
1802 $sql = "SELECT id from civicrm_contribution where contact_id = 92";
1803 $contriId1 = CRM_Core_DAO
::singleValueQuery($sql);
1805 $sql = "SELECT id from civicrm_contribution where contact_id = 34";
1806 $contriId2 = CRM_Core_DAO
::singleValueQuery($sql);
1808 $sql = "SELECT cov.value FROM civicrm_option_value cov LEFT JOIN civicrm_option_group cog ON cog.id = cov.option_group_id WHERE cov.name = 'pcp' AND cog.name = 'soft_credit_type'";
1810 $pcpId = CRM_Core_DAO
::singleValueQuery($sql);
1813 INSERT INTO `civicrm_contribution_soft`
1814 ( contribution_id, contact_id ,amount , currency, pcp_id , pcp_display_in_roll ,pcp_roll_nickname,pcp_personal_note, soft_credit_type_id )
1816 ( $contriId1, {$this->Individual[3]}, 10.00, 'USD', 1, 1, 'Jones Family', 'Helping Hands', $pcpId),
1817 ( $contriId2, {$this->Individual[3]}, 250.00, 'USD', 1, 1, 'Annie and the kids', 'Annie Helps', $pcpId);
1820 $this->_query($query);
1823 private function addPledge() {
1824 $pledge = "INSERT INTO civicrm_pledge
1825 (contact_id, financial_type_id, contribution_page_id, amount, original_installment_amount, currency,frequency_unit, frequency_interval, frequency_day, installments, start_date, create_date, acknowledge_date, modified_date, cancel_date, end_date, status_id, is_test)
1827 (71, 1, 1, 500.00, '500', 'USD', 'month', 1, 1, 1, '2009-07-01 00:00:00', '2009-06-26 00:00:00', NULL, NULL, NULL,'2009-07-01 00:00:00', 1, 0),
1828 (43, 1, 1, 800.00, '200', 'USD', 'month', 3, 1, 4, '2009-07-01 00:00:00', '2009-06-23 00:00:00', '2009-06-23 00:00:00', NULL, NULL, '2009-04-01 10:11:40', 5, 0),
1829 (32, 1, 1, 600.00, '200', 'USD', 'month', 1, 1, 3, '2009-10-01 00:00:00', '2009-09-14 00:00:00', '2009-09-14 00:00:00', NULL, NULL, '2009-12-01 00:00:00', 5, 0);
1831 $this->_query($pledge);
1834 private function addPledgePayment() {
1835 $pledgePayment = "INSERT INTO civicrm_pledge_payment
1836 ( pledge_id, contribution_id, scheduled_amount, actual_amount, currency, scheduled_date, reminder_date, reminder_count, status_id)
1838 (1, 10, 500.00, 500.00, 'USD','2009-07-01 00:00:00', null, 0, 1 ),
1839 (2, 11, 200.00, 200.00, 'USD','2009-07-01 00:00:00', null, 0, 1 ),
1840 (2, null, 200.00, null, 'USD', '2009-10-01 00:00:00', null, 0, 2 ),
1841 (2, null, 200.00, null, 'USD', '2009-01-01 00:00:00', null, 0, 2 ),
1842 (2, null, 200.00, null, 'USD', '2009-04-01 00:00:00', null, 0, 2 ),
1844 (3, 12, 200.00, 200.00, 'USD', '2009-10-01 00:00:00', null, 0, 1 ),
1845 (3, 13, 200.00, 200.00, 'USD', '2009-11-01 00:0:00', '2009-10-28 00:00:00', 1, 1),
1846 (3, null, 200.00, null, 'USD', '2009-12-01 00:00:00', null, 0, 2 );
1848 $this->_query($pledgePayment);
1851 private function addContributionLineItem() {
1852 $query = " INSERT INTO civicrm_line_item (`entity_table`, `entity_id`, contribution_id, `price_field_id`, `label`, `qty`, `unit_price`, `line_total`, `participant_count`, `price_field_value_id`, `financial_type_id`)
1853 SELECT 'civicrm_contribution', cc.id, cc.id contribution_id, cpf.id as price_field, cpfv.label, 1, cc.total_amount, cc.total_amount line_total, 0, cpfv.id as price_field_value, cpfv.financial_type_id
1854 FROM civicrm_contribution cc
1855 LEFT JOIN civicrm_price_set cps ON cps.name = 'default_contribution_amount'
1856 LEFT JOIN civicrm_price_field cpf ON cpf.price_set_id = cps.id
1857 LEFT JOIN civicrm_price_field_value cpfv ON cpfv.price_field_id = cpf.id
1859 $this->_query($query);
1862 private function addAccountingEntries() {
1863 $components = array('contribution', 'membership', 'participant');
1864 $select = 'SELECT contribution.id contribution_id, cli.id as line_item_id, contribution.contact_id, contribution.receive_date, contribution.total_amount, contribution.currency, cli.label,
1865 cli.financial_type_id, cefa.financial_account_id, contribution.payment_instrument_id, contribution.check_number, contribution.trxn_id';
1866 $where = 'WHERE cefa.account_relationship = 1';
1867 $financialAccountId = CRM_Financial_BAO_FinancialTypeAccount
::getInstrumentFinancialAccount(4);
1868 foreach ($components as $component) {
1869 if ($component == 'contribution') {
1870 $from = 'FROM `civicrm_contribution` contribution';
1873 $from = " FROM `civicrm_{$component}` {$component}
1874 INNER JOIN civicrm_{$component}_payment cpp ON cpp.{$component}_id = {$component}.id
1875 INNER JOIN civicrm_contribution contribution on contribution.id = cpp.contribution_id";
1877 $from .= " INNER JOIN civicrm_line_item cli ON cli.entity_id = {$component}.id and cli.entity_table = 'civicrm_{$component}'
1878 INNER JOIN civicrm_entity_financial_account cefa ON cefa.entity_id = cli.financial_type_id ";
1879 $sql = " {$select} {$from} {$where} ";
1880 $result = CRM_Core_DAO
::executeQuery($sql);
1881 $this->addFinancialItem($result, $financialAccountId);
1887 * @param null $financialAccountId
1889 private function addFinancialItem($result, $financialAccountId) {
1890 $defaultFinancialAccount = CRM_Core_DAO
::singleValueQuery("SELECT id FROM civicrm_financial_account WHERE is_default = 1");
1891 while ($result->fetch()) {
1892 $trxnParams = array(
1893 'trxn_date' => CRM_Utils_Date
::processDate($result->receive_date
),
1894 'total_amount' => $result->total_amount
,
1895 'currency' => $result->currency
,
1897 'trxn_id' => $result->trxn_id
,
1898 'contribution_id' => $result->contribution_id
,
1899 'to_financial_account_id' => empty($financialAccountId[$result->payment_instrument_id
]) ?
$defaultFinancialAccount : $financialAccountId[$result->payment_instrument_id
],
1900 'payment_instrument_id' => $result->payment_instrument_id
,
1901 'check_number' => $result->check_number
,
1904 $trxn = CRM_Core_BAO_FinancialTrxn
::create($trxnParams);
1905 $financialItem = array(
1906 'transaction_date' => CRM_Utils_Date
::processDate($result->receive_date
),
1907 'amount' => $result->total_amount
,
1908 'currency' => $result->currency
,
1910 'entity_id' => $result->line_item_id
,
1911 'contact_id' => $result->contact_id
,
1912 'entity_table' => 'civicrm_line_item',
1913 'description' => $result->label
,
1914 'financial_account_id' => $result->financial_account_id
,
1916 $trxnId['id'] = $trxn->id
;
1917 CRM_Financial_BAO_FinancialItem
::create($financialItem, NULL, $trxnId);
1921 private function addLineItemParticipants() {
1922 $participant = new CRM_Event_DAO_Participant();
1923 $participant->query("INSERT INTO civicrm_line_item (`entity_table`, `entity_id`, contribution_id, `price_field_id`, `label`, `qty`, `unit_price`, `line_total`, `participant_count`, `price_field_value_id`, `financial_type_id`)
1924 SELECT 'civicrm_participant', cp.id, cpp.contribution_id, cpfv.price_field_id, cpfv.label, 1, cpfv.amount, cpfv.amount as line_total, 0, cpfv.id, cpfv.financial_type_id FROM civicrm_participant cp LEFT JOIN civicrm_participant_payment cpp ON cpp.participant_id = cp.id
1925 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");
1928 private function addMembershipPayment() {
1929 $maxContribution = CRM_Core_DAO
::singleValueQuery("select max(id) from civicrm_contribution");
1930 $financialTypeID = CRM_Core_DAO
::singleValueQuery("select id from civicrm_financial_type where name = 'Member Dues'");
1931 $paymentInstrumentID = CRM_Core_DAO
::singleValueQuery("select value from civicrm_option_value where name = 'Credit Card' AND option_group_id = (SELECT id from civicrm_option_group where name = 'payment_instrument')");
1932 $sql = "INSERT INTO civicrm_contribution (contact_id,financial_type_id,payment_instrument_id, receive_date, total_amount, currency, source, contribution_status_id)
1933 SELECT cm.contact_id, $financialTypeID, $paymentInstrumentID, now(), cmt.minimum_fee, 'USD', CONCAT(cmt.name, ' Membership: Offline signup'), 1 FROM `civicrm_membership` cm
1934 LEFT JOIN civicrm_membership_type cmt ON cmt.id = cm.membership_type_id;";
1936 $this->_query($sql);
1938 $sql = "INSERT INTO civicrm_membership_payment (contribution_id,membership_id)
1939 SELECT cc.id, cm.id FROM civicrm_contribution cc
1940 LEFT JOIN civicrm_membership cm ON cm.contact_id = cc.contact_id
1941 WHERE cc.id > $maxContribution;";
1943 $this->_query($sql);
1945 $sql = "INSERT INTO civicrm_line_item (entity_table, entity_id, contribution_id, price_field_value_id, price_field_id, label, qty, unit_price, line_total, financial_type_id)
1946 SELECT 'civicrm_membership', cm.id, cmp.contribution_id, cpfv.id, cpfv.price_field_id, cpfv.label, 1, cpfv.amount, cpfv.amount as unit_price, cpfv.financial_type_id FROM `civicrm_membership` cm
1947 LEFT JOIN civicrm_membership_payment cmp ON cmp.membership_id = cm.id
1948 LEFT JOIN civicrm_price_field_value cpfv ON cpfv.membership_type_id = cm.membership_type_id
1949 LEFT JOIN civicrm_price_field cpf ON cpf.id = cpfv.price_field_id
1950 LEFT JOIN civicrm_price_set cps ON cps.id = cpf.price_set_id
1951 WHERE cps.name = 'default_membership_type_amount'";
1952 $this->_query($sql);
1954 $sql = "INSERT INTO civicrm_activity(source_record_id, activity_type_id, subject, activity_date_time, status_id, details)
1955 SELECT id, 6, CONCAT('$ ', total_amount, ' - ', source), now(), 2, 'Membership Payment' FROM civicrm_contribution WHERE id > $maxContribution";
1956 $this->_query($sql);
1958 $sql = "INSERT INTO civicrm_activity_contact(contact_id, activity_id, record_type_id)
1959 SELECT c.contact_id, a.id, 2
1960 FROM civicrm_contribution c, civicrm_activity a
1961 WHERE c.id > $maxContribution
1962 AND a.source_record_id = c.id
1963 AND a.details = 'Membership Payment'
1965 $this->_query($sql);
1968 private function addParticipantPayment() {
1969 $maxContribution = CRM_Core_DAO
::singleValueQuery("select max(id) from civicrm_contribution");
1970 $financialTypeID = CRM_Core_DAO
::singleValueQuery("select id from civicrm_financial_type where name = 'Event Fee'");
1971 $paymentInstrumentID = CRM_Core_DAO
::singleValueQuery("select value from civicrm_option_value where name = 'Credit Card' AND option_group_id = (SELECT id from civicrm_option_group where name = 'payment_instrument')");
1972 $sql = "INSERT INTO civicrm_contribution (contact_id, financial_type_id, payment_instrument_id, receive_date, total_amount, currency, receipt_date, source, contribution_status_id)
1973 SELECT `contact_id`, $financialTypeID, $paymentInstrumentID, now(), `fee_amount`, 'USD', now(), CONCAT(ce.title, ' : Offline registration'), 1 FROM `civicrm_participant` cp
1974 LEFT JOIN civicrm_event ce ON ce.id = cp.event_id
1975 group by `contact_id`, `fee_amount`, `title`;";
1977 $this->_query($sql);
1979 $sql = "INSERT INTO civicrm_participant_payment (contribution_id,participant_id)
1980 SELECT cc.id, cp.id FROM civicrm_contribution cc
1981 LEFT JOIN civicrm_participant cp ON cp.contact_id = cc.contact_id
1982 WHERE cc.id > $maxContribution";
1984 $this->_query($sql);
1986 $sql = "INSERT INTO civicrm_activity(source_record_id, activity_type_id, subject, activity_date_time, status_id, details)
1987 SELECT id, 6, CONCAT('$ ', total_amount, ' - ', source), now(), 2, 'Participant' FROM `civicrm_contribution` WHERE id > $maxContribution";
1988 $this->_query($sql);
1990 $sql = "INSERT INTO civicrm_activity_contact(contact_id, activity_id, record_type_id)
1991 SELECT c.contact_id, a.id, 2
1992 FROM civicrm_contribution c, civicrm_activity a
1993 WHERE c.id > $maxContribution
1994 AND a.source_record_id = c.id
1995 AND a.details = 'Participant Payment'
1997 $this->_query($sql);
2002 echo ("Starting data generation on " . date("F dS h:i:s A") . "\n");
2003 $gcd = new CRM_GCD();
2005 $gcd->generate('Domain');
2006 $gcd->generate('Contact');
2007 $gcd->generate('Individual');
2008 $gcd->generate('Household');
2009 $gcd->generate('Organization');
2010 $gcd->generate('Relationship');
2011 $gcd->generate('EntityTag');
2012 $gcd->generate('Group');
2013 $gcd->generate('Note');
2014 $gcd->generate('Activity');
2015 $gcd->generate('Event');
2016 $gcd->generate('Contribution');
2017 $gcd->generate('ContributionLineItem');
2018 $gcd->generate('Membership');
2019 $gcd->generate('MembershipPayment');
2020 $gcd->generate('MembershipLog');
2021 $gcd->generate('PCP');
2022 $gcd->generate('SoftContribution');
2023 $gcd->generate('Pledge');
2024 $gcd->generate('PledgePayment');
2025 $gcd->generate('Participant');
2026 $gcd->generate('ParticipantPayment');
2027 $gcd->generate('LineItemParticipants');
2028 $gcd->generate('AccountingEntries');
2029 echo ("Ending data generation on " . date("F dS h:i:s A") . "\n");