grantprograms_disable.sql 1.79 KB
Newer Older
Mayur Jadhav's avatar
Mayur Jadhav committed
1 2
/**
 * Grant Programs extension improves grant allocation
3 4
 * in CiviGrant
 *
Mayur Jadhav's avatar
Mayur Jadhav committed
5 6 7 8 9 10
 * Copyright (C) 2012 JMA Consulting
 *
 * This program is free software: you can redistribute it and/or modify
 * it under the terms of the GNU Affero General Public License as
 * published by the Free Software Foundation, either version 3 of the
 * License, or (at your option) any later version.
11
 *
Mayur Jadhav's avatar
Mayur Jadhav committed
12 13 14 15
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU Affero General Public License for more details.
16
 *
Mayur Jadhav's avatar
Mayur Jadhav committed
17 18
 * You should have received a copy of the GNU Affero General Public License
 * along with this program.  If not, see <http://www.gnu.org/licenses/>.
19
 *
Mayur Jadhav's avatar
Mayur Jadhav committed
20
 * Support: https://github.com/JMAConsulting/biz.jmaconsulting.grantprograms/issues
21
 *
Mayur Jadhav's avatar
Mayur Jadhav committed
22 23 24
 * Contact: info@jmaconsulting.biz
 *          JMA Consulting
 *          215 Spadina Ave, Ste 400
25
 *          Toronto, ON
Mayur Jadhav's avatar
Mayur Jadhav committed
26 27 28
 *          Canada   M5T 2C7
 */

Monish Deb's avatar
Monish Deb committed
29
UPDATE civicrm_option_group SET is_active = 0 WHERE name IN ('grant_payment_status','grant_program_status', 'allocation_algorithm', 'grant_thresholds', 'reason_grant_ineligible', 'reason_grant_incomplete', 'grant_info_too_late', 'msg_tpl_workflow_grant');
Mayur Jadhav's avatar
Mayur Jadhav committed
30

31
UPDATE civicrm_option_value SET is_active = 0 WHERE option_group_id IN (SELECT id FROM civicrm_option_group WHERE name IN ('grant_payment_status','grant_program_status', 'allocation_algorithm', 'grant_thresholds', 'reason_grant_ineligible', 'reason_grant_incomplete', 'grant_info_too_late', 'msg_tpl_workflow_grant'));
32 33

-- RG-212
Monish Deb's avatar
Monish Deb committed
34
UPDATE  civicrm_option_group cog INNER JOIN civicrm_option_value cov ON cov.option_group_id = cog.id
35
SET cov.is_active = 0
36
WHERE  cog.name = 'activity_type' AND cov.name IN ('grant_status_change', 'grant_payment');