PageManagerPublic::__construct
PageBuilderPublic::__construct
Page::__construct
PageManagerPublic::displayPage
Page::getPageStatic
SELECT * FROM ga_page WHERE page_url="err404" AND page_type="0"
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="2" 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="2" 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='2' AND ga_page_rss.id_rss=ga_rss.id_rss ORDER BY ga_rss.id_rss
Site::getConfig
SELECT * FROM ga_config
SELECT page_url FROM ga_page WHERE id_page="2"
Page::getPageStatic
SELECT * FROM ga_page WHERE page_url="err404" 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="2" 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="2" 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='2' 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="err404" 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_emission.page_url, ma_emission.emission_datetime, ma_emission.emission_entete, ma_programme.programme_nom, programme_entete, ma_media.media_name FROM ( ma_emission) LEFT JOIN ma_programme ON ma_programme.id_programme=ma_emission.id_programme LEFT JOIN ma_media ON ma_media.id_programme=ma_emission.id_programme WHERE ma_emission.emission_datetime>=CURDATE() AND ma_emission.emission_datetime<=CURDATE()+1 ORDER BY ma_emission.emission_datetime ASC
SELECT ma_evenement.page_url, ma_evenement.evenement_nom, ma_evenement.evenement_type, ma_evenement.evenement_debut, ma_evenement.evenement_entete, ma_evenement.evenement_etat, ma_media.media_name FROM ( ma_evenement) LEFT JOIN ma_media ON ma_media.id_evenement=ma_evenement.id_evenement WHERE ma_evenement.evenement_debut>=NOW() AND ma_evenement.evenement_etat='2' ORDER BY ma_evenement.evenement_debut ASC LIMIT 5
Données envoyés au template :
Array
(
[prochaine_emission_liste] => Array
(
[0] => Array
(
[page_url] => evan-dream-on-the-mix-23-05-2013
[emission_datetime] => 2013-05-23 00:00:00
[emission_entete] =>
[programme_nom] => Evan Dream On the Mix
[programme_entete] => 2H de Mix autour des musiques électroniques
[media_name] => 2012-09-25-d7fd483399938bb8a372bb07e4a160a4.jpg
)
[1] => Array
(
[page_url] => la-matinale-23052013
[emission_datetime] => 2013-05-23 07:00:00
[emission_entete] =>
[programme_nom] => La Matinale
[programme_entete] => Réveillez-vous avec l'actualité locale, nationale et internationale
[media_name] => 2012-12-17-e774b6059eeabd80af2b2e794bbf3b51.jpg
)
[2] => Array
(
[page_url] => emission-speciale-23052013
[emission_datetime] => 2013-05-23 17:00:00
[emission_entete] => En direct de la Cité des Congrès
[programme_nom] => Emission Spéciale
[programme_entete] => Prun' en direct pour une émission spéciale.
[media_name] => 2012-10-16-31755eeba6d5da8bb0c795d18e2a91a2.jpg
)
[3] => Array
(
[page_url] => my-web-generation-23-05-2013
[emission_datetime] => 2013-05-23 19:00:00
[emission_entete] =>
[programme_nom] => My Web Generation
[programme_entete] => L'émission 2.0 qui vous parle de Web et des nouvelles technologies
[media_name] => 2012-09-17-2b3464f80061078b82b3d14b5477268d.jpg
)
[4] => Array
(
[page_url] => triangle-23-05-2013
[emission_datetime] => 2013-05-23 20:00:00
[emission_entete] =>
[programme_nom] => Triangle
[programme_entete] => Découverte de l'IDM, de l'Electronica et des dérives électroniques
[media_name] => 2012-10-01-a145d06e9be6b1a35a3980b7f7ea571a.jpg
)
[5] => Array
(
[page_url] => orbeat-23-05-2013
[emission_datetime] => 2013-05-23 21:00:00
[emission_entete] =>
[programme_nom] => Orbeat
[programme_entete] => Emission des musiques électroniques qui font remuer les fesses !
[media_name] => 2013-02-28-defabb6331aa0546c025bbc6fc7bb41c.jpg
)
[6] => Array
(
[page_url] => electric-chicken-23-05-2013
[emission_datetime] => 2013-05-23 23:00:00
[emission_entete] =>
[programme_nom] => Electric Chicken
[programme_entete] => Emission qui vous emmène aux frontières des musiques électroniques
[media_name] => 2012-09-19-2cff457fd21bcb519e6e20b09665361e.jpg
)
[7] => Array
(
[page_url] => ground-control-24-05-2013
[emission_datetime] => 2013-05-24 00:00:00
[emission_entete] =>
[programme_nom] => Ground Control
[programme_entete] => Emission de mix dédié à la Bass Music sous toutes ses coutures
[media_name] => 2012-10-08-ac2d53e7e652899bf7d83b5593c05c99.jpg
)
)
[evenements_liste] => Array
(
[0] => Array
(
[page_url] => les-3-elephants-24-05-2013
[evenement_nom] => Les 3 Eléphants
[evenement_type] => partenaire
[evenement_debut] => 2013-05-24 19:00:00
[evenement_entete] => Festival - Concerts et arts de rue
[evenement_etat] => 2
[media_name] => 2013-04-30-8e2be6c7b8ad4de684f64027a23c3c43.jpg
)
PageBuilderPublic::headerHTML
PageBuilderPublic::headerTPL
PageBuilderPublic::footerTPL
PageBuilderPublic::footerHTML
SELECT config_value FROM ga_config WHERE config_label="project_debug"