<?php
/*
+--------------------------------------------------------------------+
- | CiviCRM version 4.5 |
+ | CiviCRM version 4.6 |
+--------------------------------------------------------------------+
| Copyright CiviCRM LLC (c) 2004-2014 |
+--------------------------------------------------------------------+
*/
// Set ADD_TO_DB = FALSE to do a dry run
- CONST ADD_TO_DB = TRUE;
+ const ADD_TO_DB = TRUE;
- CONST DATA_FILENAME = "sample_data.xml";
- CONST NUM_DOMAIN = 1;
- CONST NUM_CONTACT = 200;
- CONST INDIVIDUAL_PERCENT = 80;
- CONST HOUSEHOLD_PERCENT = 10;
- CONST ORGANIZATION_PERCENT = 10;
- CONST NUM_INDIVIDUAL_PER_HOUSEHOLD = 4;
- CONST NUM_ACTIVITY = 150;
+ const DATA_FILENAME = "sample_data.xml";
+ const NUM_DOMAIN = 1;
+ const NUM_CONTACT = 200;
+ const INDIVIDUAL_PERCENT = 80;
+ const HOUSEHOLD_PERCENT = 10;
+ const ORGANIZATION_PERCENT = 10;
+ const NUM_INDIVIDUAL_PER_HOUSEHOLD = 4;
+ const NUM_ACTIVITY = 150;
// Location types from the table crm_location_type
- CONST HOME = 1;
- CONST WORK = 2;
- CONST MAIN = 3;
- CONST OTHER = 4;
+ const HOME = 1;
+ const WORK = 2;
+ const MAIN = 3;
+ const OTHER = 4;
/**
* Class constructor
}
for ($i = 0; $i < self::NUM_ACTIVITY; $i++) {
$activityDAO = new CRM_Activity_DAO_Activity();
- $activityTypeID = mt_rand(7, 10);
+ $activityId = CRM_Core_OptionGroup::values('activity_type', NULL, NULL, NULL, ' AND v.name IN ("Tell A Friend", "Pledge Acknowledgment")');
+ $activityTypeID = array_rand($activityId);
$activity = CRM_Core_PseudoConstant::activityType();
$activityDAO->activity_type_id = $activityTypeID;
$activityDAO->subject = "Subject for $activity[$activityTypeID]";
$activityContactDAO->record_type_id = CRM_Utils_Array::key('Activity Source', $activityContacts);
$this->_insert($activityContactDAO);
- if (in_array($activityTypeID, array(6, 9))) {
+ if ($activityTypeID == 9) {
$activityContactDAO = new CRM_Activity_DAO_ActivityContact();
$activityContactDAO->activity_id = $activityDAO->id;
$activityContactDAO->contact_id = mt_rand(1, 101);
$activityContactDAO->record_type_id = CRM_Utils_Array::key('Activity Targets', $activityContacts);
$this->_insert($activityContactDAO);
}
-
- if ($activityTypeID == 7) {
- $activityContactDAO = new CRM_Activity_DAO_ActivityContact();
- $activityContactDAO->activity_id = $activityDAO->id;
- $activityContactDAO->contact_id = mt_rand(1, 101);
- $activityContactDAO->record_type_id = CRM_Utils_Array::key('Activity Assignees', $activityContacts);
- $this->_insert($activityContactDAO);
- }
}
}
}
}
private function addContributionLineItem() {
- $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`)
-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
+ $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`)
+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
FROM civicrm_contribution cc
LEFT JOIN civicrm_price_set cps ON cps.name = 'default_contribution_amount'
LEFT JOIN civicrm_price_field cpf ON cpf.price_set_id = cps.id
'status_id' => 1,
'trxn_id' => $result->trxn_id,
'contribution_id' => $result->contribution_id,
- 'to_financial_account_id' => $result->payment_instrument_id ? $financialAccountId[$result->payment_instrument_id] : $defaultFinancialAccount,
+ 'to_financial_account_id' => empty($financialAccountId[$result->payment_instrument_id]) ? $defaultFinancialAccount : $financialAccountId[$result->payment_instrument_id],
'payment_instrument_id' => $result->payment_instrument_id,
'check_number' => $result->check_number
);
private function addLineItemParticipants() {
$participant = new CRM_Event_DAO_Participant();
- $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`)
-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");
+ $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`)
+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
+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");
}
private function addMembershipPayment() {
$this->_query($sql);
- $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)
-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
+ $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)
+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
LEFT JOIN civicrm_membership_payment cmp ON cmp.membership_id = cm.id
LEFT JOIN civicrm_price_field_value cpfv ON cpfv.membership_type_id = cm.membership_type_id
LEFT JOIN civicrm_price_field cpf ON cpf.id = cpfv.price_field_id