MODE DEBUG

PageManagerPublic::__construct
PageBuilderPublic::__construct
Page::__construct
PageManagerPublic::displayPage
SELECT id_page FROM ga_page WHERE page_url="jcb"

SELECT COUNT(1) count FROM ga_page WHERE page_url="jcb" AND page_link="0"

SELECT id_page FROM ga_page WHERE page_link="71" AND page_url="categorie-jcb"

SELECT page_url FROM ga_page WHERE id_page="91"

Page::getPageStatic
SELECT * FROM ga_page WHERE page_url="categorie-jcb" 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="91" 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="91" 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='91' 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="categorie-jcb" 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_categorie.page_url, ma_categorie.categorie_nom, ma_categorie.categorie_visuel, ma_categorie.id_marque, ma_categorie.categorie_nom_marque FROM ma_categorie WHERE ma_categorie.id_marque="1" ORDER BY ma_categorie.categorie_ordre_catalogue ASC


Appel d'un fichier de post-traitement : /action/process/dataflow/categorie.php

SELECT ma_modele_catalogue.page_url, ma_modele_catalogue.id_categorie, ma_modele_catalogue.modele_catalogue_nom,
ma_modele_catalogue.modele_catalogue_teasing, ma_modele_catalogue.modele_catalogue_visuel1,
ma_categorie.categorie_nom, ma_categorie.id_categorie
FROM ( ma_modele_catalogue)
LEFT JOIN ma_categorie ON ma_modele_catalogue.id_categorie=ma_categorie.id_categorie
WHERE ma_categorie.page_url='transports-workmax'
ORDER BY ma_modele_catalogue.page_name ASC


Données envoyés au template :
Array
(
[categories_jcb_liste] => Array
(
[0] => Array
(
[page_url] => telescopiques
[categorie_nom] => Télescopiques (JCB)
[categorie_visuel] => jcb-telescopiques
[id_marque] => 1
[categorie_nom_marque] => Télescopiques
)

[1] => Array
(
[page_url] => telescopiques-articules
[categorie_nom] => Télescopiques articulés (JCB)
[categorie_visuel] => jcb-telescopiques-articules
[id_marque] => 1
[categorie_nom_marque] => Télescopiques articulés
)

[2] => Array
(
[page_url] => telescopiques-compacts
[categorie_nom] => Télescopiques compacts (JCB)
[categorie_visuel] => jcb-telescopiques-compacts
[id_marque] => 1
[categorie_nom_marque] => Télescopiques compacts
)

[3] => Array
(
[page_url] => agro-chargeuses
[categorie_nom] => Agro chargeuses (JCB)
[categorie_visuel] => jcb-agrochargeuses
[id_marque] => 1
[categorie_nom_marque] => Agro chargeuses
)

[4] => Array
(
[page_url] => chargeuses-compacts
[categorie_nom] => Chargeuses compacts (JCB)
[categorie_visuel] => jcb-chargeuses-compacts
[id_marque] => 1
[categorie_nom_marque] => Chargeuses compacts
)

[5] => Array
(
[page_url] => fastrac
[categorie_nom] => Fastrac (JCB)
[categorie_visuel] => jcb-fastrac
[id_marque] => 1
[categorie_nom_marque] => Fastrac
)

[6] => Array
(
[page_url] => transports-workmax
[categorie_nom] => Transports workmax
[categorie_visuel] => jcb-workmax
[id_marque] => 1
[categorie_nom_marque] => Transports workmax
)

)

[modele_catalogue_liste] => Array
(
[0] => Array
(
[page_url] => workmax-800d
[id_categorie] => 27
[modele_catalogue_nom] => Workmax 800D
[modele_catalogue_teasing] => Pour toutes les tâches quotidiennes à la ferme, en champ de foire et sur grands domaines, le véhicule utilitaire WORKMAX 800 D de JCB s'utilise sur tous les terrains
[modele_catalogue_visuel1] => 84-1266e1c21cf5c7c969c97796eac28f1b.jpg
[categorie_nom] => Transports workmax
)

[1] => Array
(
[page_url] => workmax-1000d
[id_categorie] => 27
[modele_catalogue_nom] => Workmax 1000D
[modele_catalogue_teasing] => Le JCB WORKMAX 1000 D est un véhicule utilitaire tout-terrain robuste, polyvalent et puissant, conçu pour exécuter une grande variété de tâches sur tout type de terrain.
[modele_catalogue_visuel1] => 85-5d066f578cec3d561a939533cad69ebc.jpg
[categorie_nom] => Transports workmax
)

[2] => Array
(
[page_url] => workmax-6x4
[id_categorie] => 27
[modele_catalogue_nom] => Workmax 6x4
[modele_catalogue_teasing] => Conçu pour une utilisation sur terrains gazonnés, le JCB WORKMAX 6x4 exerce une faible pression au sol afin de ne pas abîmer les surfaces délicates.
[modele_catalogue_visuel1] => 83-61f05f2e981c315793692e2c5f4d142f.jpg
[categorie_nom] => Transports workmax
)

)

)

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