Subversion Repositories eFlore/Applications.coel

Rev

Rev 85 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 85 Rev 87
Line 299... Line 299...
299
	ccac_truk_type, 
299
	ccac_truk_type, 
300
	ccac_ce_meta)
300
	ccac_ce_meta)
301
	SELECT hi.ID_INDIC, ID, 
301
	SELECT hi.ID_INDIC, ID, 
302
		CAST(GROUP_CONCAT(DISTINCT CASE ID_TYPE WHEN '1' THEN '2368' WHEN '2' THEN '2369' WHEN '3' THEN '2370' WHEN '4' THEN '2371' WHEN '5' THEN '2372' WHEN '6' THEN '2373' ELSE NULL END SEPARATOR ";") AS CHAR)  AS TYPE,
302
		CAST(GROUP_CONCAT(DISTINCT CASE ID_TYPE WHEN '1' THEN '2368' WHEN '2' THEN '2369' WHEN '3' THEN '2370' WHEN '4' THEN '2371' WHEN '5' THEN '2372' WHEN '6' THEN '2373' ELSE NULL END SEPARATOR ";") AS CHAR)  AS TYPE,
303
		@idm := @idm+1 
303
		@idm := @idm+1 
304
	FROM tb_herbiers.HERBIERS_INDIC AS hi LEFT JOIN tb_herbiers.HERBIERS_A_UN_TYPE AS haut ON (hi.ID_INDIC = haut.ID_INDIC)  
304
	FROM tb_herbiers.HERBIERS_INDIC AS hi LEFT JOIN tb_herbiers.HERBIERS_A_UN_TYPE AS haut ON (hi.ID_INDIC = haut.ID_INDIC)
-
 
305
	WHERE ID IN (SELECT ccm_id_commentaire FROM tb_coel.coel_commentaire)
305
	GROUP BY hi.ID_INDIC 
306
	GROUP BY hi.ID_INDIC 
306
	ORDER BY hi.ID_INDIC ASC;
307
	ORDER BY hi.ID_INDIC ASC;
307
INSERT INTO tb_coel.coel_meta_historique_ligne 
308
INSERT INTO tb_coel.coel_meta_historique_ligne 
308
	(cmhl_id_historique_ligne, cmhl_ce_table, cmhl_cle_ligne, cmhl_enregistrement, 
309
	(cmhl_id_historique_ligne, cmhl_ce_table, cmhl_cle_ligne, cmhl_enregistrement, 
309
	cmhl_date_modification, cmhl_notes, cmhl_ce_modifier_par, cmhl_ce_etat, cmhl_ip) 
310
	cmhl_date_modification, cmhl_notes, cmhl_ce_modifier_par, cmhl_ce_etat, cmhl_ip) 
310
	SELECT @idm_tmp := @idm_tmp+1, '102', hi.ID_INDIC, NULL, 
311
	SELECT @idm_tmp := @idm_tmp+1, '102', hi.ID_INDIC, NULL, 
311
		FROM_UNIXTIME(MAJ_INDIC) , CONCAT('Ajout des types du commentaire #',hi.ID_INDIC,' de la table HERBIERS_A_UN_TYPE.'), IF(ID_INDICATEUR != '0', ID_INDICATEUR, '1'), '1', IF(ID_INDICATEUR != '0', NULL, '162.38.234.1') 	
312
		FROM_UNIXTIME(MAJ_INDIC) , CONCAT('Ajout des types du commentaire #',hi.ID_INDIC,' de la table HERBIERS_A_UN_TYPE.'), IF(ID_INDICATEUR != '0', ID_INDICATEUR, '1'), '1', IF(ID_INDICATEUR != '0', NULL, '162.38.234.1') 	
312
	FROM tb_herbiers.HERBIERS_INDIC AS hi LEFT JOIN tb_herbiers.HERBIERS_A_UN_TYPE AS haut ON (hi.ID_INDIC = haut.ID_INDIC) LEFT JOIN tb_herbiers.HERBIERS_INDIC_HISTORIQUE AS hih ON (hi.ID_INDIC = hih.ID_INDIC) 
313
	FROM tb_herbiers.HERBIERS_INDIC AS hi LEFT JOIN tb_herbiers.HERBIERS_A_UN_TYPE AS haut ON (hi.ID_INDIC = haut.ID_INDIC) LEFT JOIN tb_herbiers.HERBIERS_INDIC_HISTORIQUE AS hih ON (hi.ID_INDIC = hih.ID_INDIC)
-
 
314
	WHERE ID IN (SELECT ccm_id_commentaire FROM tb_coel.coel_commentaire)
313
	GROUP BY hi.ID_INDIC 
315
	GROUP BY hi.ID_INDIC 
314
	ORDER BY hi.ID_INDIC ASC;
316
	ORDER BY hi.ID_INDIC ASC;
Line 315... Line 317...
315
 
317
 
316
#------------------------------------------------------------------------------------------------------------------------
318
#------------------------------------------------------------------------------------------------------------------------