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
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
[48] => Array
(
[id_canton] => 56
[canton_name] => Pontivy
[canton_commercial_name] => Jean Paul LE BRETON - Pontivy
[canton_departement] => 56
)
[49] => Array
(
[id_canton] => 62
[canton_name] => La Trinité-Porhoët
[canton_commercial_name] => Jean Paul LE BRETON- La Trinité
[canton_departement] => 56
)
[60] => Array
(
[id_canton] => 48
[canton_name] => Josselin
[canton_commercial_name] => Jean Paul LE BRETON - Josselin
[canton_departement] => 56
)
[61] => Array
(
[id_canton] => 61
[canton_name] => Rohan
[canton_commercial_name] => Jean Paul LE BRETON - Rohan
[canton_departement] => 56
)
)
)
PageBuilderPublic::headerHTML
PageBuilderPublic::headerTPL
PageBuilderPublic::footerTPL
PageBuilderPublic::footerHTML
SELECT config_value FROM ga_config WHERE config_label="project_debug"