Commit | Line | Data |
---|---|---|
6a488035 TO |
1 | -- /******************************************************* |
2 | -- * | |
3 | -- * Configuration Data for CiviCase Component | |
4 | -- * For: HRD | |
5 | -- * | |
6 | -- *******************************************************/ | |
7 | ||
8 | -- /******************************************************* | |
9 | -- * | |
10 | -- * Case Types | |
11 | -- * | |
12 | -- *******************************************************/ | |
6a488035 TO |
13 | SELECT @caseCompId := id FROM `civicrm_component` where `name` like 'CiviCase'; |
14 | ||
8ef12e64 | 15 | INSERT INTO |
8ffdec17 | 16 | `civicrm_case_type` (`title`, `name`, `weight`, `is_reserved`, `is_active`) |
6a488035 | 17 | VALUES |
8ffdec17 ARW |
18 | ('Civil and Political' , 'Civil and Political' , 1, NULL, 1, 1), |
19 | ('Economic, Social and Cultural', 'Economic, Social and Cultural', 2, NULL, 1, 1), | |
20 | ('Gender Issues' , 'Gender Issues' , 3, NULL, 1, 1); | |
6a488035 TO |
21 | |
22 | ||
23 | -- /******************************************************* | |
24 | -- * | |
25 | -- * Additional Case Activity Types | |
26 | -- * | |
27 | -- *******************************************************/ | |
28 | SELECT @option_group_id_activity_type := max(id) from civicrm_option_group where name = 'activity_type'; | |
29 | ||
30 | SELECT @max_val := MAX(ROUND(op.value)) FROM civicrm_option_value op WHERE op.option_group_id = @option_group_id_activity_type; | |
31 | ||
8ef12e64 | 32 | INSERT INTO |
33 | `civicrm_option_value` (`option_group_id`, `label`, `value`, `name`, `grouping`, `filter`, `is_default`, `weight`, `description`, `is_optgroup`, `is_reserved`, `is_active`, `component_id` ) | |
6a488035 TO |
34 | VALUES |
35 | (@option_group_id_activity_type, 'Source(incoming)', (SELECT @max_val := @max_val+1), 'Source(incoming)', NULL, 0, 0, (SELECT @max_val := @max_val+1), '', 0, 0, 1, @caseCompId ), | |
36 | (@option_group_id_activity_type, 'Incoming correspondence', (SELECT @max_val := @max_val+1), 'Incoming correspondence', NULL, 0, 0, (SELECT @max_val := @max_val+1), '', 0, 0, 1, @caseCompId ), | |
37 | (@option_group_id_activity_type, 'Incoming Press Release', (SELECT @max_val := @max_val+1), 'Incoming Press Release', NULL, 0, 0, (SELECT @max_val := @max_val+1), '', 0, 0, 1, @caseCompId ), | |
38 | (@option_group_id_activity_type, 'Complaint', (SELECT @max_val := @max_val+1), 'Complaint', NULL, 0, 0, (SELECT @max_val := @max_val+1), '', 0, 0, 1, @caseCompId ), | |
39 | (@option_group_id_activity_type, 'Urgent Action(incoming)', (SELECT @max_val := @max_val+1), 'Urgent Action(incoming)', NULL, 0, 0, (SELECT @max_val := @max_val+1), '', 0, 0, 1, @caseCompId ), | |
40 | (@option_group_id_activity_type, 'Outgoing correspondence', (SELECT @max_val := @max_val+1), 'Outgoing correspondence', NULL, 0, 0, (SELECT @max_val := @max_val+1), '', 0, 0, 1, @caseCompId ), | |
41 | (@option_group_id_activity_type, 'Outgoing Press Release', (SELECT @max_val := @max_val+1), 'Outgoing Press Release', NULL, 0, 0, (SELECT @max_val := @max_val+1), '', 0, 0, 1, @caseCompId ), | |
42 | (@option_group_id_activity_type, 'FL Action(outgoing)', (SELECT @max_val := @max_val+1), 'FL Action(outgoing)', NULL, 0, 0, (SELECT @max_val := @max_val+1), '', 0, 0, 1, @caseCompId ), | |
43 | (@option_group_id_activity_type, 'FL Urgent Action(outgoing)', (SELECT @max_val := @max_val+1), 'FL Urgent Action(outgoing)', NULL, 0, 0, (SELECT @max_val := @max_val+1), '', 0, 0, 1, @caseCompId ), | |
44 | (@option_group_id_activity_type, 'Lobbying(outgoing)', (SELECT @max_val := @max_val+1), '', NULL, 0, 0, (SELECT @max_val := @max_val+1), '', 0, 0, 1, @caseCompId ); |