| /trunk/services/modules/0.1/observations/ListeObservations.php |
|---|
| 428,7 → 428,7 |
| 'FROM '.$this->gestionBdd->formaterTable('del_observation', 'dob'). |
| 'INNER JOIN '.$this->gestionBdd->formaterTable('del_obs_image', 'doi'). |
| 'ON doi.id_observation = dob.id_observation '. |
| 'INNER JOIN del_utilisateur du '. |
| 'LEFT JOIN del_utilisateur du '. |
| 'ON du.id_utilisateur = dob.ce_utilisateur '. |
| 'INNER JOIN del_image di '. |
| 'ON di.id_image = doi.id_image '; |
| /trunk/services/modules/0.1/syndication/SyndicationVotesParProtocole.php |
|---|
| 112,7 → 112,7 |
| ' INNER JOIN del_obs_image doi ON divo.ce_image = doi.id_image '. |
| ' INNER JOIN del_observation dob ON dob.id_observation = doi.id_observation '. |
| ' INNER JOIN del_image_protocole ON ce_protocole = id_protocole '. |
| ' INNER JOIN del_utilisateur ON dob.ce_utilisateur = id_utilisateur '. |
| ' LEFT JOIN del_utilisateur ON dob.ce_utilisateur = id_utilisateur '. |
| $this->chargerClauseWhere()." ". |
| ' ORDER BY divo.date DESC '. |
| ' LIMIT '.$this->navigation->getDepart().','.$this->navigation->getLimite(); |
| /trunk/services/modules/0.1/determinations/ListeImagesDeterminationsProbables.php |
|---|
| 187,7 → 187,7 |
| 'ON doi.id_image = di.id_image '. |
| 'INNER JOIN del_observation dob '. |
| 'ON doi.id_observation = dob.id_observation '. |
| 'INNER JOIN del_utilisateur du '. |
| 'LEFT JOIN del_utilisateur du '. |
| 'ON du.id_utilisateur = di.ce_utilisateur '. |
| 'LEFT JOIN del_image_vote dvote '. |
| 'ON doi.id_image = dvote.ce_image '. |
| /trunk/doc/bdd/sql/tela/tb_del_cel_vues.sql |
|---|
| 1,7 → 1,7 |
| -- ----------------------------------------------------- |
| -- Placeholder table for view `del_utilisateur` |
| -- ----------------------------------------------------- |
| CREATE TABLE IF NOT EXISTS `del_utilisateur` (`id_utilisateur` INT, `prenom` INT, `nom` INT, `courriel` INT, `mot_de_passe` INT); |
| CREATE TABLE IF NOT EXISTS `del_utilisateur` (`id_utilisateur` VARCHAR, `prenom` INT, `nom` INT, `courriel` INT, `mot_de_passe` INT); |
| -- ----------------------------------------------------- |
| -- Placeholder table for view `del_observation` |
| 25,7 → 25,7 |
| DROP TABLE IF EXISTS `del_utilisateur`; |
| DELIMITER $$ |
| CREATE OR REPLACE ALGORITHM=MERGE VIEW del_utilisateur AS |
| SELECT at.U_ID AS id_utilisateur, at.U_SURNAME AS prenom, at.U_NAME AS nom, at.U_MAIL AS courriel, at.U_PASSWD AS mot_de_passe |
| SELECT CAST(at.U_ID AS CHAR) AS id_utilisateur, at.U_SURNAME AS prenom, at.U_NAME AS nom, at.U_MAIL AS courriel, at.U_PASSWD AS mot_de_passe |
| FROM tb_cel.cel_utilisateurs_infos AS ui |
| LEFT JOIN tela_prod_v4.annuaire_tela AS at ON (ui.id_utilisateur = at.U_ID); |
| $$ |
| /trunk/scripts/modules/adeterminer/AlerteMailADeterminer.php |
|---|
| 46,7 → 46,7 |
| "FROM del_obs_image doi ". |
| "INNER JOIN del_observation do ". |
| "ON doi.id_observation = do.id_observation ". |
| "INNER JOIN del_utilisateur du ". |
| "LEFT JOIN del_utilisateur du ". |
| "ON do.ce_utilisateur = du.id_utilisateur ". |
| 'WHERE (do.mots_cles_texte LIKE "%aDeterminer%" OR nom_sel IS NULL OR nom_ret IS NULL) AND '. |
| '(do.date_transmission > DATE_SUB(CURDATE(), INTERVAL 1 DAY) OR '. |