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] => global-movement-21052013
[emission_datetime] => 2013-05-21 00:00:00
[emission_entete] =>
[programme_nom] => Global Movement
[programme_entete] => Tous les 3ème lundi du mois, une émission 100% Hip Hop international
[media_name] => 2012-09-19-cf3e7a90fcae7d38092cf3d7f0924f0a.jpg
)
[1] => Array
(
[page_url] => la-matinale-21052013
[emission_datetime] => 2013-05-21 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] => ghetto-blaster-21-05-2013
[emission_datetime] => 2013-05-21 17:00:00
[emission_entete] => Rimo - Voyage à Nantes - festival de Cannes
[programme_nom] => Ghetto Blaster
[programme_entete] => Magazine quotidien de 2h dédiées à l'actualité culturelle locale
[media_name] => 2013-04-15-24e3d517441a03b1abb0ab0ba4e2c3a4.jpg
)
[3] => Array
(
[page_url] => le-labo-des-savoirs-21052013
[emission_datetime] => 2013-05-21 19:00:00
[emission_entete] => La biodiversité en ville
[programme_nom] => Le Labo des Savoirs
[programme_entete] => L'émission scientifique de Prun'
[media_name] => 2012-09-26-22d3fdd9d93a84f28ba40ff129059ae2.jpg
)
[4] => Array
(
[page_url] => version-papier-21-05-2013
[emission_datetime] => 2013-05-21 20:00:00
[emission_entete] =>
[programme_nom] => Version Papier
[programme_entete] => Exploration des cavités mystérieuses des musiques indés
[media_name] => 2012-10-05-f749b2b13f02dc0128140a2c5f150d08.jpg
)
[5] => Array
(
[page_url] => yckm-21-05-2013
[emission_datetime] => 2013-05-21 21:00:00
[emission_entete] =>
[programme_nom] => YCKM
[programme_entete] => Tour d'horizon global des scènes extrèmes actuelles et antérieures
[media_name] => 2012-10-05-9bbe23440563474f8460d07d4bc70002.jpg
)
[7] => Array
(
[page_url] => jay-deemension-22-05-2013
[emission_datetime] => 2013-05-22 00:00:00
[emission_entete] =>
[programme_nom] => Jay Deemension
[programme_entete] => Immersion dans l'univers de la musique alternative et expérimentale
[media_name] => 2012-09-24-0529e7108d5c613b911e34afdf93d6de.jpg
)
PageBuilderPublic::headerHTML
PageBuilderPublic::headerTPL
PageBuilderPublic::footerTPL
PageBuilderPublic::footerHTML
SELECT config_value FROM ga_config WHERE config_label="project_debug"
