X-Git-Url: https://vcs.fsf.org/?a=blobdiff_plain;f=sql%2FGenerateData.php;h=be420a2242b92c4729a8b15e5a6ef374723cf496;hb=5e74f823023ca2b84cb42f6602f9606c58e2c368;hp=071ed835634831065883c2fb28dded2e2e1b54da;hpb=13c1cf91881e22bbcc38024c645736a3fc6fad4a;p=civicrm-core.git diff --git a/sql/GenerateData.php b/sql/GenerateData.php index 071ed83563..be420a2242 100644 --- a/sql/GenerateData.php +++ b/sql/GenerateData.php @@ -1,9 +1,9 @@ relTypes = CRM_Utils_Array::index(array('name_a_b'), CRM_Core_PseudoConstant::relationshipType('name')); - + } /** @@ -485,6 +485,7 @@ class CRM_GCD { if ($this->probability(.5)) { $contact->preferred_communication_method = CRM_Core_DAO::VALUE_SEPARATOR . $this->randomItem($this->preferredCommunicationMethod) . CRM_Core_DAO::VALUE_SEPARATOR; } + $contact->source = 'Sample Data'; $this->_insert($contact); } } @@ -804,6 +805,8 @@ class CRM_GCD { * * @param $cid int: contact id * @param $masterContactId int: set if this is a shared address + * + * @return array */ private function _addAddress($cid, $masterContactId = NULL) { @@ -861,6 +864,8 @@ class CRM_GCD { * Add a phone number for a contact * * @param $cid int: contact id + * + * @return array */ private function _addPhone($cid) { $area = $this->probability(.5) ? '' : mt_rand(201, 899); @@ -881,6 +886,10 @@ class CRM_GCD { * Add an email for a contact * * @param $cid int: contact id + * @param $email + * @param $locationType + * + * @return array */ private function _addEmail($cid, $email, $locationType) { $params = array( @@ -898,6 +907,8 @@ class CRM_GCD { * * @param $cid int: contact id * @param $name str: contact name + * + * @return array */ private function _addWebsite($cid, $name) { $part = array_pad(split(' ', strtolower($name)), 3, ''); @@ -932,8 +943,11 @@ class CRM_GCD { /** * Create an email address based on a person's name * Using common naming patterns + * * @param $contact obj: individual contact record * @param $domain str: supply a domain (i.e. for a work address) + * + * @return string */ private function _individualEmail($contact, $domain = NULL) { $first = $contact->first_name; @@ -1713,23 +1727,28 @@ VALUES $sql = "SELECT id from civicrm_contribution where contact_id = 34"; $contriId2 = CRM_Core_DAO::singleValueQuery($sql); + $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'"; + + $pcpId = CRM_Core_DAO::singleValueQuery($sql); + $query = " INSERT INTO `civicrm_contribution_soft` - ( contribution_id, contact_id ,amount , currency, pcp_id , pcp_display_in_roll ,pcp_roll_nickname,pcp_personal_note ) + ( contribution_id, contact_id ,amount , currency, pcp_id , pcp_display_in_roll ,pcp_roll_nickname,pcp_personal_note, soft_credit_type_id ) VALUES - ( $contriId1, {$this->Individual[3]}, 10.00, 'USD', 1, 1, 'Jones Family', 'Helping Hands'), - ( $contriId2, {$this->Individual[3]}, 250.00, 'USD', 1, 1, 'Annie and the kids', 'Annie Helps'); + ( $contriId1, {$this->Individual[3]}, 10.00, 'USD', 1, 1, 'Jones Family', 'Helping Hands', $pcpId), + ( $contriId2, {$this->Individual[3]}, 250.00, 'USD', 1, 1, 'Annie and the kids', 'Annie Helps', $pcpId); "; + $this->_query($query); } private function addPledge() { $pledge = "INSERT INTO civicrm_pledge - (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) + (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) VALUES - (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), - (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), - (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); + (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), + (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), + (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); "; $this->_query($pledge); } @@ -1776,7 +1795,7 @@ WHERE cefa.account_relationship = 1; "; private function addParticipantFinancialItem() { - $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 + $sql = " SELECT cpp.contribution_id, cli.id as line_item_id, cp.contact_id, now() as receive_date, cp.fee_amount as total_amount, cp.fee_currency as currency, cli.label, cli.financial_type_id, cefa.financial_account_id, 4 as payment_instrument_id, NULL as check_number, NULL as trxn_id FROM `civicrm_participant` cp INNER JOIN civicrm_participant_payment cpp ON cpp.participant_id = cp.id INNER JOIN civicrm_line_item cli ON cli.entity_id = cp.id and cli.entity_table = 'civicrm_participant' @@ -1826,8 +1845,9 @@ SELECT 'civicrm_participant',cp.id, cpfv.price_field_id, cpfv.label, 1, cpfv.amo private function addMembershipPayment() { $maxContribution = CRM_Core_DAO::singleValueQuery("select max(id) from civicrm_contribution"); $financialTypeID = CRM_Core_DAO::singleValueQuery("select id from civicrm_financial_type where name = 'Member Dues'"); - $sql = "INSERT INTO civicrm_contribution (contact_id,financial_type_id,receive_date, total_amount, currency, source, contribution_status_id) -SELECT cm.contact_id, $financialTypeID, now(), cmt.minimum_fee, 'USD', CONCAT(cmt.name, ' Membership: Offline signup'), 1 FROM `civicrm_membership` cm + $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')"); + $sql = "INSERT INTO civicrm_contribution (contact_id,financial_type_id,payment_instrument_id, receive_date, total_amount, currency, source, contribution_status_id) +SELECT cm.contact_id, $financialTypeID, $paymentInstrumentID, now(), cmt.minimum_fee, 'USD', CONCAT(cmt.name, ' Membership: Offline signup'), 1 FROM `civicrm_membership` cm LEFT JOIN civicrm_membership_type cmt ON cmt.id = cm.membership_type_id;"; $this->_query($sql); @@ -1865,8 +1885,9 @@ AND a.details = 'Membership Payment' private function addParticipantPayment() { $maxContribution = CRM_Core_DAO::singleValueQuery("select max(id) from civicrm_contribution"); $financialTypeID = CRM_Core_DAO::singleValueQuery("select id from civicrm_financial_type where name = 'Event Fee'"); - $sql = "INSERT INTO civicrm_contribution (contact_id, financial_type_id, receive_date, total_amount, currency, receipt_date, source, contribution_status_id) -SELECT `contact_id`, $financialTypeID, now(), `fee_amount`, 'USD', now(), CONCAT(ce.title, ' : Offline registration'), 1 FROM `civicrm_participant` cp + $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')"); + $sql = "INSERT INTO civicrm_contribution (contact_id, financial_type_id, payment_instrument_id, receive_date, total_amount, currency, receipt_date, source, contribution_status_id) +SELECT `contact_id`, $financialTypeID, $paymentInstrumentID, now(), `fee_amount`, 'USD', now(), CONCAT(ce.title, ' : Offline registration'), 1 FROM `civicrm_participant` cp LEFT JOIN civicrm_event ce ON ce.id = cp.event_id group by `contact_id`;";