FrameBeurk File
Fmbk/Module/Beurk/_sql/moduleBeurkcontroles.sql
# FrameBeurk V0.61 Copyright ToolOscope 2015. Licence CeCILL-C.
# requêtes de controles et d extractions
#
# extrait toutes les relations
# les libellés des noeuds et relations non terminaux sont affiché comme suit :
# Terminal du noeud relié par 'estDeType', suivi d un espace et du numéro du noeud
SELECT L.IdNoeud, IFNULL(A.Terminal, CONCAT(
(SELECT D.Terminal FROM Beurk_Terminal D
LEFT JOIN Beurk_Lien DR ON D.IdTerminal = DR.IdLie AND DR.IdRelation = (SELECT IdTerminal FROM Beurk_Terminal WHERE Terminal = 'estDeType')
WHERE DR.IdNoeud = L.IdNoeud)
, ' ', L.IdNoeud)) AS Noeud,
L.IdRelation, IFNULL(B.Terminal, CONCAT(
(SELECT E.Terminal FROM Beurk_Terminal E
LEFT JOIN Beurk_Lien ER ON E.IdTerminal = ER.IdLie AND ER.IdRelation = (SELECT IdTerminal FROM Beurk_Terminal WHERE Terminal = 'estDeType')
WHERE ER.IdNoeud = L.IdRelation)
, ' ', L.IdRelation)) AS Relation,
L.IdLie, IFNULL(C.Terminal, CONCAT(
(SELECT F.Terminal FROM Beurk_Terminal F
LEFT JOIN Beurk_Lien FR ON F.IdTerminal = FR.IdLie AND FR.IdRelation = (SELECT IdTerminal FROM Beurk_Terminal WHERE Terminal = 'estDeType')
WHERE FR.IdNoeud = L.IdLie)
, ' ', L.IdLie)) AS NoeudLie
FROM Beurk_Lien L
LEFT JOIN Beurk_Terminal A ON L.IdNoeud = A.IdTerminal
LEFT JOIN Beurk_Terminal B ON L.IdRelation = B.IdTerminal
LEFT JOIN Beurk_Terminal C ON L.IdLie = C.IdTerminal;
© 2010-2015 by ToolOscope SASU. © 2016-2018 by Arnaud De Rette. All rights reserved