PageManagerPublic::__construct
PageBuilderPublic::__construct
Page::__construct
PageManagerPublic::displayPage
SELECT id_page FROM ga_page WHERE page_url="magasin-libre-service-promotions"
SELECT COUNT(1) count FROM ga_page WHERE page_url="magasin-libre-service-promotions" AND page_link="0"
SELECT id_page FROM ga_page WHERE page_link="112" AND page_url="promotions-case-ih"
SELECT page_url FROM ga_page WHERE id_page="114"
Page::getPageStatic
SELECT * FROM ga_page WHERE page_url="promotions-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="114" 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="114" 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='114' 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="promotions-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_promotion.promotion_name, ma_promotion.promotion_visuel, ma_promotion.promotion_descriptif, ma_promotion.promotion_prix, ma_promotion.promotion_pourcentage, ma_promotion.promotion_prix_promo, ma_promotion.promotion_active, ma_promotion.promotion_validite, ma_promotion.promotion_descriptif_long, ma_promotion.promo_marque, ma_promotion.id_promotion FROM ma_promotion WHERE ma_promotion.promotion_active="1" AND ma_promotion.promo_marque="4" AND ma_promotion.promotion_validite>=CURDATE() ORDER BY ma_promotion.id_promotion
Appel d'un fichier de post-traitement : /action/process/dataflow/case_promo.php
SELECT COUNT(id_promotion)
FROM ma_promotion
WHERE ma_promotion.promotion_active='1'
AND ma_promotion.promo_marque='3'
AND ma_promotion.promotion_validite>=CURRENT_DATE()
SELECT ma_promotion.promotion_name, ma_promotion.promotion_visuel,
ma_promotion.promotion_descriptif, ma_promotion.promotion_prix,
ma_promotion.promotion_prix_promo, ma_promotion.promotion_active,
ma_promotion.promotion_validite, ma_promotion.promotion_descriptif_long,
ma_promotion.id_promotion
FROM ma_promotion
WHERE ma_promotion.promotion_active='1'
AND ma_promotion.promo_marque='3'
AND ma_promotion.promotion_validite>=CURRENT_DATE()
ORDER BY ma_promotion.id_promotion DESC
LIMIT 6
PageBuilderPublic::headerHTML
PageBuilderPublic::headerTPL
PageBuilderPublic::footerTPL
PageBuilderPublic::footerHTML
SELECT config_value FROM ga_config WHERE config_label="project_debug"
