Commit | Line | Data |
---|---|---|
d70eb7e0 | 1 | {* file to handle db changes in 4.4.5 during upgrade *} |
d0d6e5fd PN |
2 | -- CRM-14191 |
3 | SELECT @option_group_id_batch_status := max(id) from civicrm_option_group where name = 'batch_status'; | |
4 | SELECT @weight := MAX(value) FROM civicrm_option_value WHERE option_group_id = @option_group_id_batch_status; | |
5 | ||
fd7abdce | 6 | UPDATE civicrm_option_value |
d0d6e5fd PN |
7 | SET value = (Select @weight := @weight +1), |
8 | weight = @weight | |
fd7abdce | 9 | WHERE option_group_id = @option_group_id_batch_status AND name IN ('Data Entry', 'Reopened', 'Exported') AND value = 0 ORDER BY id; |
d0d6e5fd PN |
10 | |
11 | SELECT @option_group_id_batch_modes := max(id) from civicrm_option_group where name = 'batch_mode'; | |
12 | SELECT @weights := MAX(value) FROM civicrm_option_value WHERE option_group_id = @option_group_id_batch_modes; | |
13 | ||
fd7abdce | 14 | UPDATE civicrm_option_value |
d0d6e5fd PN |
15 | SET value = (Select @weights := @weights +1), |
16 | weight = @weights | |
fd7abdce PN |
17 | WHERE option_group_id = @option_group_id_batch_modes AND name IN ('Manual Batch', 'Automatic Batch') AND value = 0; |
18 | ||
19 | SELECT @manual_mode_id := MAX(value) FROM civicrm_option_value WHERE option_group_id = @option_group_id_batch_modes AND name = 'Manual Batch'; | |
20 | UPDATE civicrm_batch SET mode_id = @manual_mode_id WHERE (mode_id IS NULL OR mode_id = 0) AND type_id IS NULL; | |
21 | ||
22 | SELECT @data_entry_status_id := MAX(value) FROM civicrm_option_value WHERE option_group_id = @option_group_id_batch_status AND name = 'Data Entry'; | |
23 | UPDATE civicrm_batch SET status_id = @data_entry_status_id WHERE status_id = 3 AND type_id IS NOT NULL; | |
24 | ||
25 | SELECT @exported_status_id := MAX(value) FROM civicrm_option_value WHERE option_group_id = @option_group_id_batch_status AND name = 'Exported'; | |
26 | UPDATE civicrm_navigation SET url = CONCAT('civicrm/financial/financialbatches?reset=1&batchStatus=', @exported_status_id) WHERE name = 'Exported Batches'; | |
27 | ||
28 | -- update status_id to Exported | |
29 | SELECT @export_activity_type := max(value) FROM civicrm_option_value cov | |
30 | INNER JOIN civicrm_option_group cog ON cog.id = cov.option_group_id | |
31 | WHERE cog.name = 'activity_type' AND cov.name = 'Export Accounting Batch'; | |
32 | ||
33 | UPDATE civicrm_batch cb | |
34 | INNER JOIN civicrm_activity ca ON ca.source_record_id = cb.id | |
35 | SET cb.status_id = @exported_status_id | |
36 | WHERE cb.status_id = 0 AND ca.activity_type_id = @export_activity_type; |