Commit | Line | Data |
---|---|---|
6a488035 TO |
1 | -- CRM-10810 |
2 | SELECT @max_strict := max(id), @cnt_strict := count(*) FROM `civicrm_dedupe_rule_group` WHERE `contact_type` = 'Individual' AND `level` = 'Strict' AND `is_default` = 1; | |
3 | UPDATE `civicrm_dedupe_rule_group` SET `is_default` = 0 WHERE @cnt_strict > 1 AND id = @max_strict; | |
4 | ||
5 | SELECT @max_fuzzy := max(id), @cnt_fuzzy := count(*) FROM `civicrm_dedupe_rule_group` WHERE `contact_type` = 'Individual' AND `level` = 'Fuzzy' AND `is_default` = 1; | |
6 | UPDATE `civicrm_dedupe_rule_group` SET `is_default` = 0 WHERE @cnt_fuzzy > 1 AND id = @max_fuzzy; | |
7 | ||
10824d34 | 8 | -- Insert line items for contribution for api/import |
6a488035 TO |
9 | SELECT @fieldID := cpf.id, @fieldValueID := cpfv.id FROM civicrm_price_set cps |
10 | LEFT JOIN civicrm_price_field cpf ON cps.id = cpf.price_set_id | |
11 | LEFT JOIN civicrm_price_field_value cpfv ON cpf.id = cpfv.price_field_id | |
12 | WHERE cps.name = 'default_contribution_amount'; | |
13 | ||
14 | INSERT INTO civicrm_line_item ( entity_table, entity_id, price_field_id,label, qty, unit_price, line_total, participant_count, price_field_value_id ) | |
15 | SELECT 'civicrm_contribution', cc.id, @fieldID, 'Contribution Amount', 1, total_amount, total_amount , 0, @fieldValueID | |
16 | FROM `civicrm_contribution` cc | |
17 | LEFT JOIN civicrm_line_item cli ON cc.id=cli.entity_id and cli.entity_table = 'civicrm_contribution' | |
18 | LEFT JOIN civicrm_membership_payment cmp ON cc.id = cmp.contribution_id | |
19 | LEFT JOIN civicrm_participant_payment cpp ON cc.id = cpp.contribution_id | |
20 | WHERE cli.entity_id IS NULL AND cc.contribution_page_id IS NULL AND cmp.contribution_id IS NULL AND cpp.contribution_id IS NULL | |
21 | GROUP BY cc.id; |