| Line 9... |
Line 9... |
| 9 |
UPDATE cel_utilisateurs_infos SET nom = (SELECT U_NAME FROM tela_prod_v4.annuaire_tela WHERE U_ID = id_utilisateur);
|
9 |
UPDATE cel_utilisateurs_infos SET nom = (SELECT U_NAME FROM tela_prod_v4.annuaire_tela WHERE U_ID = id_utilisateur);
|
| 10 |
UPDATE cel_utilisateurs_infos SET courriel = (SELECT U_MAIL FROM tela_prod_v4.annuaire_tela WHERE U_ID = id_utilisateur)
|
10 |
UPDATE cel_utilisateurs_infos SET courriel = (SELECT U_MAIL FROM tela_prod_v4.annuaire_tela WHERE U_ID = id_utilisateur)
|
| Line 11... |
Line 11... |
| 11 |
|
11 |
|
| 12 |
-- recollage des intitulés (lent et facultatif)
|
12 |
-- recollage des intitulés (lent et facultatif)
|
| - |
|
13 |
UPDATE cel_utilisateurs_infos SET intitule = (SELECT IF ((SELECT amv_valeur FROM tela_prod_v4.annu_meta_valeurs WHERE amv_ce_colonne = 136 AND amv_cle_ligne = tela_prod_v4.annuaire_tela.U_ID ORDER BY amv_valeur DESC LIMIT 1) = 1, (SELECT amv_valeur FROM tela_prod_v4.annu_meta_valeurs WHERE amv_ce_colonne = 99 AND amv_cle_ligne = tela_prod_v4.annuaire_tela.U_ID), CONCAT(U_SURNAME, ' ', U_NAME)) AS intitule FROM tela_prod_v4.annuaire_tela WHERE U_ID = id_utilisateur);
|
| - |
|
14 |
|
| - |
|
15 |
|
| - |
|
16 |
-- suppression de la vue !
|