Line 111... |
Line 111... |
111 |
cp_truk_courriel, cp_truk_url,
|
111 |
cp_truk_courriel, cp_truk_url,
|
112 |
cp_description,
|
112 |
cp_description,
|
113 |
cp_ce_truk_role,
|
113 |
cp_ce_truk_role,
|
114 |
cp_mot_de_passe, cp_login, cp_ce_annuaire_tela, cp_parametre,
|
114 |
cp_mot_de_passe, cp_login, cp_ce_annuaire_tela, cp_parametre,
|
115 |
cp_ce_meta)
|
115 |
cp_ce_meta)
|
116 |
SELECT U_ID, '3', CONCAT(U_SURNAME,'',U_NAME) AS NOM_COMPLET, U_SURNAME, U_NAME,
|
116 |
SELECT U_ID, '3', CONCAT(U_SURNAME,' ',UPPER(U_NAME)) AS NOM_COMPLET, U_SURNAME, UPPER(U_NAME),
|
117 |
U_ADDR1, U_ADDR2, U_STATE, U_ZIP_CODE, U_CITY, CP.CP_Intitule_pays,
|
117 |
U_ADDR1, U_ADDR2, U_STATE, U_ZIP_CODE, U_CITY, CP.CP_Intitule_pays,
|
118 |
LOWER(U_MAIL), U_WEB,
|
118 |
LOWER(U_MAIL), U_WEB,
|
119 |
CONCAT('Spécialités systématiques : ', U_SPE, '\nSpécialités géographiques : ', U_GEO, '\nFonction : ', U_FONCTION, '\nStructure : ', U_TITLE),
|
119 |
CONCAT('Spécialités systématiques : ', U_SPE, '\nSpécialités géographiques : ', U_GEO, '\nFonction : ', U_FONCTION, '\nStructure : ', U_TITLE),
|
120 |
IF(EDP_ID_DROIT = '1', '2022', IF(EDP_ID_DROIT = '2', '2023', IF(EDP_ID_DROIT = '3', '2024', 0))),
|
120 |
IF(EDP_ID_DROIT = '1', '2022', IF(EDP_ID_DROIT = '2', '2023', IF(EDP_ID_DROIT = '3', '2024', 0))),
|
121 |
U_PASSWD, U_MAIL, U_ID, CONCAT('<?xml version="1.0" encoding="UTF-8"><parametres><niveau_bota>', U_NIV,'</niveau_bota></parametres>'),
|
121 |
U_PASSWD, U_MAIL, U_ID, CONCAT('<?xml version="1.0" encoding="UTF-8"><parametres><niveau_bota>', U_NIV,'</niveau_bota></parametres>'),
|
Line 152... |
Line 152... |
152 |
#------------------------------------------------------------------------------------------------------------------------
|
152 |
#------------------------------------------------------------------------------------------------------------------------
|
153 |
#HERBIERS_STAFF vers coel_personne
|
153 |
#HERBIERS_STAFF vers coel_personne
|
154 |
INSERT INTO tb_coel.coel_personne
|
154 |
INSERT INTO tb_coel.coel_personne
|
155 |
(cp_id_personne, cp_ce_projet, cp_fmt_nom_complet, cp_nom, cp_prenom, cp_adresse_01, cp_adresse_02, cp_code_postal, cp_ville, cp_truk_courriel,
|
155 |
(cp_id_personne, cp_ce_projet, cp_fmt_nom_complet, cp_nom, cp_prenom, cp_adresse_01, cp_adresse_02, cp_code_postal, cp_ville, cp_truk_courriel,
|
156 |
cp_truk_telephone, cp_truk_fax, cp_ce_meta)
|
156 |
cp_truk_telephone, cp_truk_fax, cp_ce_meta)
|
157 |
SELECT 100000+ID_STAFF, '2', CONCAT(PRENOM,'', NOM) AS NOM_COMPLET, NOM, PRENOM, ADRESSE1, ADRESSE2, CP, VILLE, LOWER(MAIL),
|
157 |
SELECT 100000+ID_STAFF, '2', CONCAT(PRENOM,' ', UPPER(NOM)) AS NOM_COMPLET, UPPER(NOM), PRENOM, ADRESSE1, ADRESSE2, CP, VILLE, LOWER(MAIL),
|
158 |
IF(TEL != '', CONCAT('+33', TRIM(LEADING '0' FROM REPLACE(TEL,'[33]',''))), NULL), IF(FAX != '', CONCAT('+33', TRIM(LEADING '0' FROM REPLACE(FAX,'[33]',''))), NULL), @idm := @idm+1
|
158 |
IF(TEL != '', CONCAT('+33', TRIM(LEADING '0' FROM REPLACE(TEL,'[33]',''))), NULL), IF(FAX != '', CONCAT('+33', TRIM(LEADING '0' FROM REPLACE(FAX,'[33]',''))), NULL), @idm := @idm+1
|
159 |
FROM tb_herbiers.HERBIERS_STAFF
|
159 |
FROM tb_herbiers.HERBIERS_STAFF
|
160 |
ORDER BY ID_STAFF ASC;
|
160 |
ORDER BY ID_STAFF ASC;
|
161 |
INSERT INTO tb_coel.coel_meta_historique_ligne
|
161 |
INSERT INTO tb_coel.coel_meta_historique_ligne
|
162 |
(cmhl_id_historique_ligne, cmhl_ce_table, cmhl_cle_ligne, cmhl_enregistrement,
|
162 |
(cmhl_id_historique_ligne, cmhl_ce_table, cmhl_cle_ligne, cmhl_enregistrement,
|