MODE DEBUG

PageManagerPublic::__construct
PageBuilderPublic::__construct
Page::__construct
PageManagerPublic::displayPage
SELECT id_page FROM ga_page WHERE page_url="case-ih"

SELECT COUNT(1) count FROM ga_page WHERE page_url="case-ih" AND page_link="0"

SELECT id_page FROM ga_page WHERE page_link="54" AND page_url="contact-case-ih"

SELECT page_url FROM ga_page WHERE id_page="73"

Page::getPageStatic
SELECT * FROM ga_page WHERE page_url="contact-case-ih" AND page_type=""

Page::getCssPage
SELECT ga_file.file_name FROM ga_file, ga_file_page WHERE ga_file.id_file=ga_file_page.id_file AND ga_file_page.id_page="73" AND file_extension="css" ORDER BY ga_file_page.id_file_page

Page::getJsPage
SELECT ga_file.file_name FROM ga_file, ga_file_page WHERE ga_file.id_file=ga_file_page.id_file AND ga_file_page.id_page="73" AND file_extension="js" ORDER BY ga_file_page.id_file_page

Page::getRSSPage
SELECT rss_url,rss_description FROM ga_rss,ga_page_rss WHERE ga_page_rss.id_page='73' AND ga_page_rss.id_rss=ga_rss.id_rss ORDER BY ga_rss.id_rss

Site::getConfig
SELECT * FROM ga_config

PageBuilderPublic::buildPage
dataflow::__construct

dataflow::getDataflowQueries

Récupération des requêtes supplémentaires.
SELECT ga_query.id_query, ga_query_asso.query_asso_order, ga_query.query_column, ga_query.query_table, ga_query.query_where, ga_query.query_group, ga_query.query_order, ga_query.query_left, ga_query.query_on, ga_query.query_list, ga_query.query_limit, ga_query.query_type, ga_query.query_log, ga_query.query_output_name, ga_fileprocess.fileprocess_name FROM ( ga_dataflow, ga_query, ga_query_asso) LEFT JOIN ga_fileprocess ON ga_dataflow.id_fileprocess=ga_fileprocess.id_fileprocess WHERE ga_dataflow.dataflow_name="contact-case-ih" AND ga_dataflow.id_dataflow=ga_query_asso.id_dataflow AND ga_query.id_query=ga_query_asso.id_query ORDER BY ga_query_asso.query_asso_order, ga_query.query_list

SELECT ma_canton.id_canton, ma_canton.canton_name, ma_canton.canton_departement FROM ma_canton ORDER BY ma_canton.canton_departement ASC


Appel d'un fichier de post-traitement : /action/process/dataflow/canton.php
SELECT DISTINCT(ma_canton_commercial.id_canton), ma_canton.canton_name, ma_canton_commercial.canton_commercial_name, ma_canton.canton_departement
FROM ma_canton_commercial
LEFT JOIN ma_canton ON ma_canton.id_canton=ma_canton_commercial.id_canton
LEFT JOIN ma_commercial ON ma_commercial.id_commercial=ma_canton_commercial.id_commercial
LEFT JOIN ma_marque ON ma_marque.id_marque=ma_commercial.id_marque
WHERE ma_marque.marque_url='case-ih'
ORDER BY ma_canton.canton_departement ASC


Données envoyés au template :
Array
(
[cantons_liste] => Array
(
[0] => Array
(
[id_canton] => 25
[canton_name] => Plouguenast
[canton_commercial_name] => Florence Morin - Plouguenast
[canton_departement] => 22
)

[1] => Array
(
[id_canton] => 20
[canton_name] => Plancoët
[canton_commercial_name] => Boulard - Plancoet
[canton_departement] => 22
)

[2] => Array
(
[id_canton] => 22
[canton_name] => Pléneuf
[canton_commercial_name] => Boulard - Pleneuf
[canton_departement] => 22
)

[3] => Array
(
[id_canton] => 24
[canton_name] => Ploubalay
[canton_commercial_name] => Boulard - Ploubalay
[canton_departement] => 22
)

[4] => Array
(
[id_canton] => 28
[canton_name] => Saint-Brieuc
[canton_commercial_name] => Boulard - St-Brieuc
[canton_departement] => 22
)

[5] => Array
(
[id_canton] => 3
[canton_name] => Chatelaudren
[canton_commercial_name] => Florence Morin - Chatelaudren
[canton_departement] => 22
)

[6] => Array
(
[id_canton] => 5
[canton_name] => Collinee
[canton_commercial_name] => Florence Morin - Collinee
[canton_departement] => 22
)

[7] => Array
(
[id_canton] => 9
[canton_name] => Etables sur mer
[canton_commercial_name] => Florence Morin - Etables
[canton_departement] => 22
)

[8] => Array
(
[id_canton] => 13
[canton_name] => Lamballe
[canton_commercial_name] => Florence Morin - Lamballe
[canton_departement] => 22
)

[9] => Array
(
[id_canton] => 18
[canton_name] => Moncontour
[canton_commercial_name] => Florence Morin - Moncontour
[canton_departement] => 22
)

[10] => Array
(
[id_canton] => 23
[canton_name] => Ploeuc
[canton_commercial_name] => Florence Morin - Ploeuc
[canton_departement] => 22
)

[11] => Array
(
[id_canton] => 11
[canton_name] => Gouarec
[canton_commercial_name] => Cyrille Jounot - Gouarec
[canton_departement] => 22
)

[12] => Array
(
[id_canton] => 26
[canton_name] => Quintin
[canton_commercial_name] => Florence Morin - Quintin
[canton_departement] => 22
)

[13] => Array
(
[id_canton] => 27
[canton_name] => Rostrenen
[canton_commercial_name] => Florence Morin - Rostrenen
[canton_departement] => 22
)

[14] => Array
(
[id_canton] => 28
[canton_name] => Saint-Brieuc
[canton_commercial_name] => Florence Morin - St-Brieuc
[canton_departement] => 22
)

[15] => Array
(
[id_canton] => 32
[canton_name] => Langueux
[canton_commercial_name] => Florence Morin - Langueux
[canton_departement] => 22
)

[16] => Array
(
[id_canton] => 33
[canton_name] => Plérin
[canton_commercial_name] => Florence Morin - Plerin
[canton_departement] => 22
)

[17] => Array
(
[id_canton] => 34
[canton_name] => Ploufragan
[canton_commercial_name] => Florence Morin - Ploufragan
[canton_departement] => 22
)

[18] => Array
(
[id_canton] => 4
[canton_name] => La Chèze
[canton_commercial_name] => Jean Paul LE BRETON- La Chèze
[canton_departement] => 22
)

[19] => Array
(
[id_canton] => 14
[canton_name] => Loudéac
[canton_commercial_name] => Jean Paul LE BRETON - Loudeac
[canton_departement] => 22
)

[20] => Array
(
[id_canton] => 31
[canton_name] => Uzel
[canton_commercial_name] => Jean Paul LE BRETON - Uzel
[canton_departement] => 22
)

[21] => Array
(
[id_canton] => 13
[canton_name] => Lamballe
[canton_commercial_name] => Boulard - Lamballe
[canton_departement] => 22
)

[22] => Array
(
[id_canton] => 19
[canton_name] => Mûr-de-Bretagne
[canton_commercial_name] => Cyrille Jounot - Mur de Bretagne
[canton_departement] => 22
)

[23] => Array
(
[id_canton] => 15
[canton_name] => Maël-Carhaix
[canton_commercial_name] => Cyrille Jounot - Mael Carhaix
[canton_departement] => 22
)

[24] => Array
(
[id_canton] => 27
[canton_name] => Rostrenen
[canton_commercial_name] => Cyrille Jounot - Rostrenen
[canton_departement] => 22
)

[25] => Array
(
[id_canton] => 30
[canton_name] => St-Nicolas-du-Pélem
[canton_commercial_name] => Cyrille Jounot - Saint Nicolas
[canton_departement] => 22
)

[26] => Array
(
[id_canton] => 6
[canton_name] => Corlay
[canton_commercial_name] => Cyrille Jounot - Corlay
[canton_departement] => 22
)

[27] => Array
(
[id_canton] => 1
[canton_name] => Broons
[canton_commercial_name] => Jean-Marie Nizan - Broons
[canton_departement] => 22
)

[28] => Array
(
[id_canton] => 2
[canton_name] => Caulnes
[canton_commercial_name] => Jean-Marie Nizan - Caulnes
[canton_departement] => 22
)

[29] => Array
(
[id_canton] => 37
[canton_name] => Dinan
[canton_commercial_name] => Jean-Marie Nizan - Dinan
[canton_departement] => 22
)

[30] => Array
(
[id_canton] => 10
[canton_name] => Evran
[canton_commercial_name] => Jean-Marie Nizan - Evran
[canton_departement] => 22
)

[31] => Array
(
[id_canton] => 17
[canton_name] => Merdrignac
[canton_commercial_name] => Jean-Marie Nizan - Merdrignac
[canton_departement] => 22
)

[32] => Array
(
[id_canton] => 21
[canton_name] => Plélan Le Petit
[canton_commercial_name] => Jean-Marie Nizan - Plelan
[canton_departement] => 22
)

[33] => Array
(
[id_canton] => 16
[canton_name] => Matignon
[canton_commercial_name] => Boulard - Matignon
[canton_departement] => 22
)

[34] => Array
(
[id_canton] => 12
[canton_name] => Jugon
[canton_commercial_name] => Boulard - Jugon
[canton_departement] => 22
)

[35] => Array
(
[id_canton] => 39
[canton_name] => St-Meen-le-Grand
[canton_commercial_name] => Jean-Marie Nizan - St Meen
[canton_departement] => 35
)

[36] => Array
(
[id_canton] => 38
[canton_name] => Dinard
[canton_commercial_name] => Boulard - Dinard
[canton_departement] => 35
)

[37] => Array
(
[id_canton] => 62
[canton_name] => La Trinité-Porhoët
[canton_commercial_name] => Jean Paul LE BRETON- La Trinité
[canton_departement] => 56
)

[38] => Array
(
[id_canton] => 56
[canton_name] => Pontivy
[canton_commercial_name] => Yann Garin - Pontivy
[canton_departement] => 56
)

[39] => Array
(
[id_canton] => 57
[canton_name] => Pont-Scorff
[canton_commercial_name] => Yann Garin - Pont Scorff
[canton_departement] => 56
)

[40] => Array
(
[id_canton] => 55
[canton_name] => Pluvigner
[canton_commercial_name] => Yann Garin - Pluvigner
[canton_departement] => 56
)

[41] => Array
(
[id_canton] => 59
[canton_name] => Port-Louis
[canton_commercial_name] => Yann Garin - Port Louis
[canton_departement] => 56
)

[42] => Array
(
[id_canton] => 60
[canton_name] => Quiberon
[canton_commercial_name] => Yann Garin - Quiberon
[canton_departement] => 56
)

[43] => Array
(
[id_canton] => 63
[canton_name] => Lanester
[canton_commercial_name] => Yann Garin - Lanester
[canton_departement] => 56
)

[44] => Array
(
[id_canton] => 65
[canton_name] => Ploemeur
[canton_commercial_name] => Yann Garin - Ploemeur
[canton_departement] => 56
)

[45] => Array
(
[id_canton] => 48
[canton_name] => Josselin
[canton_commercial_name] => Jean Paul LE BRETON - Josselin
[canton_departement] => 56
)

[46] => Array
(
[id_canton] => 56
[canton_name] => Pontivy
[canton_commercial_name] => Jean Paul LE BRETON - Pontivy
[canton_departement] => 56
)

[47] => Array
(
[id_canton] => 61
[canton_name] => Rohan
[canton_commercial_name] => Jean Paul LE BRETON - Rohan
[canton_departement] => 56
)

[48] => Array
(
[id_canton] => 54
[canton_name] => Plouay
[canton_commercial_name] => Yann Garin - Plouay
[canton_departement] => 56
)

[49] => Array
(
[id_canton] => 53
[canton_name] => Locmaria-Berrien
[canton_commercial_name] => Yann Garin - Locmaria
[canton_departement] => 56
)

[50] => Array
(
[id_canton] => 144
[canton_name] => Lorient
[canton_commercial_name] => Yann Garin - Lorient
[canton_departement] => 56
)

[51] => Array
(
[id_canton] => 49
[canton_name] => Locminé
[canton_commercial_name] => Yann Garin - Locminé
[canton_departement] => 56
)

[52] => Array
(
[id_canton] => 47
[canton_name] => Hennebont
[canton_commercial_name] => Yann Garin - Hennebont
[canton_departement] => 56
)

[53] => Array
(
[id_canton] => 45
[canton_name] => Groix
[canton_commercial_name] => Yann Garin - Groix
[canton_departement] => 56
)

[54] => Array
(
[id_canton] => 43
[canton_name] => Le Faouët
[canton_commercial_name] => Yann Garin - Le Faouet
[canton_departement] => 56
)

[55] => Array
(
[id_canton] => 41
[canton_name] => Belz
[canton_commercial_name] => Yann Garin - Belz
[canton_departement] => 56
)

[56] => Array
(
[id_canton] => 40
[canton_name] => Baud
[canton_commercial_name] => Yann Garin - Baud
[canton_departement] => 56
)

[57] => Array
(
[id_canton] => 42
[canton_name] => Cléguerec
[canton_commercial_name] => Cyrille Jounot - Cleguerec
[canton_departement] => 56
)

[58] => Array
(
[id_canton] => 43
[canton_name] => Le Faouët
[canton_commercial_name] => Cyrille Jounot - Le Faouet
[canton_departement] => 56
)

[59] => Array
(
[id_canton] => 44
[canton_name] => Gourin
[canton_commercial_name] => Cyrille Jounot - Gourin
[canton_departement] => 56
)

[60] => Array
(
[id_canton] => 46
[canton_name] => Guémené-sur-Scorff
[canton_commercial_name] => Cyrille Jounot - Guémené
[canton_departement] => 56
)

[61] => Array
(
[id_canton] => 52
[canton_name] => Mauron
[canton_commercial_name] => Jean-Marie Nizan - Mauron
[canton_departement] => 56
)

)

)

PageBuilderPublic::headerHTML
PageBuilderPublic::headerTPL
PageBuilderPublic::footerTPL
PageBuilderPublic::footerHTML
SELECT config_value FROM ga_config WHERE config_label="project_debug"