#Hotficx Ymanci

UPDATE financial_parametre SET valeur = 'YMANCI CREDIT IMMOBILIER' WHERE (variable = 'PARAM_ENTREPRISE_SOCIETE' OR variable = 'PARAM_ENTREPRISE') AND id_local IS NULL;
UPDATE financial_parametre SET valeur = 'reclamations@ymanci.fr' WHERE variable = 'PARAM_MAIL_RECLAMATION' AND id_local IS NULL;
UPDATE financial_parametre SET valeur = ' https://www.belenvol.lu/app/logo_app/logo_app_ymanci_immo.png' WHERE variable = 'APP_LOGO' AND id_local IS NULL;
UPDATE financial_parametre SET valeur = 'YMANCI CREDIT IMMOBILLIER' WHERE variable = 'APP_LOGO_TITLE' AND id_local IS NULL;
UPDATE financial_parametre SET valeur = 'YMI' WHERE variable = 'PREFIXE_DOCUMENT' AND id_local IS NULL;
UPDATE financial_parametre SET valeur = 'DYMI' WHERE variable = 'PREFIX_NUM_CLIENT' AND id_local IS NULL;
UPDATE financial_parametre SET valeur = 'DYMI' WHERE variable = 'PREFIX_NUM_DOSSIER' AND id_local IS NULL;
UPDATE financial_parametre SET valeur = 'analyse@ymanci.fr' WHERE variable = 'MAIL_ASSURANCE' AND id_local IS NULL;
UPDATE financial_parametre SET valeur = 'analyse@ymanci.fr' WHERE variable = 'PARAM_MAIL_ANALYSE' AND id_local IS NULL;
UPDATE financial_parametre SET valeur = 'dpo@ymanci.fr' WHERE variable = 'PARAM_MAIL_DPO' AND id_local IS NULL;

# TODO
# Waiting right value to update data:
#UPDATE financial_parametre SET valeur = 'https://partenaire.uci-france.fr' WHERE variable = 'PARAM_ADRESSE_EXTRANET' AND id_local = 2;

UPDATE financial_utilisateur SET mail = REPLACE(LOWER(mail), '@centralfinances.fr', '@ymanci.fr');
UPDATE financial_utilisateur SET mail = REPLACE(LOWER(mail), '@uci-france.fr', '@ymanci.fr');



INSERT INTO financial_parametre (variable, valeur, type) VALUES ('PARAM_SMS_DEFAULT_FROM', 'YMANCI', 'String');


#Hotfix 8.21.0
START TRANSACTION;

INSERT INTO financial_parametre (variable, valeur, type) VALUES ('PARAM_FINANCEMENT_ASSURANCE','PREMIDIRECT a enregistré, au titre de son activité d’intermédiaire en assurance au cours de l’année 2018, une part supérieure au tiers de son chiffre d’affaires avec ELOIS ASSURANCE et STRATEGIE EURO PRESTIGE', 'String');

COMMIT;

