Page MenuHomePhabricator
Paste P7008

Civi trigger updates for moved do_not_solicit field
ActivePublic
Actions

Authored by Ejegg on Apr 18 2018, 3:45 PM.
DELIMITER //
DROP TRIGGER IF EXISTS civicrm_geocoder_before_insert //
DELIMITER ;
DELIMITER //
DROP TRIGGER IF EXISTS civicrm_geocoder_before_update //
DELIMITER ;
DELIMITER //
DROP TRIGGER IF EXISTS civicrm_geocoder_before_delete //
DELIMITER ;
DELIMITER //
DROP TRIGGER IF EXISTS civicrm_geocoder_after_insert //
DELIMITER ;
DELIMITER //
DROP TRIGGER IF EXISTS civicrm_geocoder_after_update //
DELIMITER ;
DELIMITER //
DROP TRIGGER IF EXISTS civicrm_geocoder_after_delete //
DELIMITER ;
DELIMITER //
CREATE TRIGGER civicrm_value_1_communication_4_after_insert after insert ON civicrm_value_1_communication_4 FOR EACH ROW BEGIN IF ( @civicrm_disable_logging IS NULL OR @civicrm_disable_logging = 0 ) THEN INSERT INTO log_civicrm_value_1_communication_4 (`id`, `entity_id`, `invalid_mailing_address`, `invalid_e_mail_address`, `survey_group_73`, `do_not_solicit`, log_conn_id, log_user_id, log_action) VALUES ( NEW.`id`, NEW.`entity_id`, NEW.`invalid_mailing_address`, NEW.`invalid_e_mail_address`, NEW.`survey_group_73`, NEW.`do_not_solicit`, COALESCE(@uniqueID, LEFT(CONCAT('c_', unix_timestamp()/3600, CONNECTION_ID()), 17)), @civicrm_user_id, 'insert'); END IF;
UPDATE civicrm_contact SET modified_date = CURRENT_TIMESTAMP WHERE id = NEW.entity_id;
END //
DELIMITER ;
DELIMITER //
DROP TRIGGER IF EXISTS civicrm_value_1_communication_4_after_update //
DELIMITER ;
DELIMITER //
CREATE TRIGGER civicrm_value_1_communication_4_after_update after update ON civicrm_value_1_communication_4 FOR EACH ROW BEGIN IF ( (IFNULL(OLD.`id`,'') <> IFNULL(NEW.`id`,'') OR IFNULL(OLD.`entity_id`,'') <> IFNULL(NEW.`entity_id`,'') OR IFNULL(OLD.`invalid_mailing_address`,'') <> IFNULL(NEW.`invalid_mailing_address`,'') OR IFNULL(OLD.`invalid_e_mail_address`,'') <> IFNULL(NEW.`invalid_e_mail_address`,'') OR IFNULL(OLD.`survey_group_73`,'') <> IFNULL(NEW.`survey_group_73`,'') OR IFNULL(OLD.`do_not_solicit`,'') <> IFNULL(NEW.`do_not_solicit`,'')) AND ( @civicrm_disable_logging IS NULL OR @civicrm_disable_logging = 0 ) ) THEN INSERT INTO log_civicrm_value_1_communication_4 (`id`, `entity_id`, `invalid_mailing_address`, `invalid_e_mail_address`, `survey_group_73`, `do_not_solicit`, log_conn_id, log_user_id, log_action) VALUES (NEW.`id`, NEW.`entity_id`, NEW.`invalid_mailing_address`, NEW.`invalid_e_mail_address`, NEW.`survey_group_73`, NEW.`do_not_solicit`, COALESCE(@uniqueID, LEFT(CONCAT('c_', unix_timestamp()/3600, CONNECTION_ID()), 17)), @civicrm_user_id, 'update'); END IF;
UPDATE civicrm_contact SET modified_date = CURRENT_TIMESTAMP WHERE id = NEW.entity_id;
END //
DELIMITER ;

Event Timeline

Ejegg created this paste.Apr 18 2018, 3:45 PM
Ejegg edited the content of this paste. (Show Details)
Ejegg edited the content of this paste. (Show Details)Apr 18 2018, 3:50 PM
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL