Commit | Line | Data |
---|---|---|
6a488035 TO |
1 | -- adding inbound activity CRM-5290 |
2 | {if $addInboundEmail} | |
3 | SELECT @option_group_id_activity_type := max(id) from civicrm_option_group where name = 'activity_type'; | |
4 | SELECT @max_val := MAX(ROUND(op.value)) FROM civicrm_option_value op WHERE op.option_group_id = @option_group_id_activity_type; | |
5 | SELECT @max_wt := max(weight) from civicrm_option_value where option_group_id=@option_group_id_activity_type; | |
6 | ||
7 | INSERT INTO civicrm_option_value | |
8 | (option_group_id, {localize field='label'}label{/localize}, {localize field='description'}description{/localize}, value, name, weight, filter, is_reserved) | |
9 | VALUES | |
10 | (@option_group_id_activity_type, {localize}'Inbound Email'{/localize}, {localize}'Inbound Email.'{/localize}, (SELECT @max_val := @max_val+1), 'Inbound Email', (SELECT @max_wt := @max_wt+1), 1, 1); | |
11 | {/if} |