MODE DEBUG
PageManagerPublic::__construct
PageBuilderPublic::__construct
Page::__construct
PageManagerPublic::displayPage
Page::getPageStatic
SELECT * FROM ga_page WHERE page_url="get-up" 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="" 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="" 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='' AND ga_page_rss.id_rss=ga_rss.id_rss ORDER BY ga_rss.id_rss
Site::getConfig
SELECT * FROM ga_config
Page::getPageDynamic
Page::getModels
SELECT model_name FROM ga_model WHERE model_type="page"
SELECT id_utilisateur, page_name, page_title, page_description, page_keywords FROM ma_utilisateur WHERE page_url="get-up"
SELECT id_stage, page_name, page_title, page_description, page_keywords FROM ma_stage WHERE page_url="get-up"
SELECT id_programme, page_name, page_title, page_description, page_keywords FROM ma_programme WHERE page_url="get-up"
SELECT id_page,page_link FROM ga_page WHERE page_url="programme"
SELECT page_url FROM ga_page WHERE id_page="7"
Page::getPageStatic
SELECT * FROM ga_page WHERE page_url="programme" AND page_type="1"
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="7" 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="7" 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='7' 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="programme" 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_programme.id_programme, ma_programme.page_name, ma_programme.page_url, ma_programme.page_title, ma_programme.page_description, ma_programme.page_keywords, ma_programme.programme_nom, ma_programme.programme_heure, ma_programme.programme_duree, ma_programme.id_programme_categorie, ma_programme.id_programme_type, ma_programme.programme_recurrence, ma_programme.programme_description, ma_programme.programme_jour, ma_programme.programme_entete, ma_media.media_name FROM ( ma_programme) LEFT JOIN ma_media ON ma_media.id_programme=ma_programme.id_programme WHERE page_url="get-up"
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
Appel d'un fichier de post-traitement : /action/process/dataflow/emissions_programme.php
SELECT ma_emission.emission_datetime,ma_emission.page_url,ma_emission.emission_sujet
FROM ma_emission
WHERE id_programme='1' AND
emission_datetime<=CURRENT_DATE()
ORDER BY emission_datetime DESC
SELECT ma_emission.emission_datetime,ma_emission.emission_sujet,page_url
FROM ma_emission
WHERE id_programme='1' AND
emission_datetime>=NOW()
ORDER BY emission_datetime ASC
LIMIT 1
SELECT ma_emission.emission_datetime,ma_emission.emission_sujet,page_url
FROM ma_emission
WHERE id_programme='1' AND
emission_datetime<''
ORDER BY emission_datetime DESC
LIMIT 1
SELECT ma_emission.emission_datetime,ma_emission.emission_sujet,page_url
FROM ma_emission
WHERE id_programme='1' AND
emission_datetime>''
ORDER BY emission_datetime ASC
LIMIT 1
SELECT id_em_titre, em_titre_name, em_titre_artiste,
id_emission, em_titre_label, em_titre_annee,
em_titre_album, em_titre_site, em_titre_facebook,
em_titre_twitter, em_titre_bandcamp, em_titre_myspace,
em_titre_soundcloud, em_titre_mixcloud, em_titre_ra,
em_titre_youtube, em_titre_vimeo, em_titre_discogs,
em_titre_cover
FROM ma_em_titre
WHERE id_emission=''
Données envoyés au template :
Array
(
[id_programme] => 1
[page_name] => Get Up!
[page_url] => get-up
[page_title] => Get Up!
[page_description] =>
[page_keywords] =>
[programme_nom] => Get Up!
[programme_heure] => 0000-00-00 17:00:00
[programme_duree] => 119
[id_programme_categorie] => 2
[id_programme_type] => 5
[programme_recurrence] => Hebdomadaire
[programme_description] =>
Le Get Up ! Radio Show c'est deux heures consacrées à la culture reggae.
Deux heures où se mêlent selections musicales, chroniques, interviews et bons plans sound system ou live !
Tous les dimanches de 17h à 19h le Get Up Radio Show c'est le rendez-vous reggae sur Radio Prun' !
http://assogetup.com
[programme_jour] => Dimanche
[programme_entete] => La culture reggae sur la bande fm nantaise !
[media_name] => 2012-10-14-b8a5c707b3a276b9d69797f6f67952a5.jpg
[prochaine_emission_liste] => Array
(
[0] => Array
(
[page_url] => la-matinale-20052013
[emission_datetime] => 2013-05-20 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
)
[1] => Array
(
[page_url] => ghetto-blaster-20-05-2013
[emission_datetime] => 2013-05-20 17:00:00
[emission_entete] => Ghetto Blaster - 20/05/2013
[programme_nom] => Ghetto Blaster
[programme_entete] => Magazine quotidien de 2h dédiées à l'actualité culturelle locale
[media_name] => 2013-04-15-24e3d517441a03b1abb0ab0ba4e2c3a4.jpg
)
[2] => Array
(
[page_url] => cite-a-la-une-20-05-2013
[emission_datetime] => 2013-05-20 19:00:00
[emission_entete] =>
[programme_nom] => Cité à la une
[programme_entete] => Les politiques s’intéressent à vous, intéressez vous à la politique !
[media_name] => 2012-10-03-d2cbe36877a0421d4cac5b831855d067.jpg
)
[3] => Array
(
[page_url] => mixadelic-20-05-2013
[emission_datetime] => 2013-05-20 20:00:00
[emission_entete] =>
[programme_nom] => Mixadelic
[programme_entete] => L'émission de la culture Hip Hop !!
[media_name] => 2012-09-26-d5bc66dcd3953fc00bfc0ddb100b70ca.jpg
)
[4] => Array
(
[page_url] => la-planete-de-cire-20-05-2013
[emission_datetime] => 2013-05-20 21:00:00
[emission_entete] =>
[programme_nom] => La Planète de Cire
[programme_entete] => Explorations au fin fond d'univers musicales sans règles ni frontières...
[media_name] => 2012-09-28-3bedfde6fbcb0424bd8db2063a44a383.jpg
)
[5] => Array
(
[page_url] => remixed-20-05-2013
[emission_datetime] => 2013-05-20 22:00:00
[emission_entete] =>
[programme_nom] => Remixed
[programme_entete] => Dj Moar nous présente une émission 100% remix !
[media_name] => 2012-09-25-22377c603c7df3eba18aedfa4a58e6ad.jpg
)
[6] => Array
(
[page_url] => rapide-et-furieux-20-05-2013
[emission_datetime] => 2013-05-20 23:00:00
[emission_entete] =>
[programme_nom] => Rapide et Furieux
[programme_entete] => Emission qui balaye un vaste spectre musical jusque dans ses obscurs recoins
[media_name] => 2012-10-08-dcedcd49810b6254e558ec0cbac180b4.jpg
)
[7] => 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
)
)
[evenements_liste] => Array
(
[0] => Array
(
[page_url] => ozma-raha-22-05-2013
[evenement_nom] => Ozma + Raha
[evenement_type] => partenaire
[evenement_debut] => 2013-05-22 20:30:00
[evenement_entete] => Concert - Jazz
[evenement_etat] => 2
[media_name] => 2013-05-14-75a6e5c1f7dc2d800e8c228ba9768e8f.jpg
)
[1] => Array
(
[page_url] => dillinger-22-05-2013
[evenement_nom] => Dillinger
[evenement_type] => partenaire
[evenement_debut] => 2013-05-22 20:30:00
[evenement_entete] => Film - Braqueurs de banque
[evenement_etat] => 2
[media_name] => 2013-05-13-c801c7683d7efe59efa8373d62149f49.jpg
)
[2] => Array
(
[page_url] => takataka-poesie-22-05-2013
[evenement_nom] => Takataka Poésie
[evenement_type] => partenaire
[evenement_debut] => 2013-05-22 21:00:00
[evenement_entete] => Soirée slam avec Nina Kibuanda
[evenement_etat] => 2
[media_name] => 2013-05-17-24763fdc84b941c3c251fa6a6d41d345.jpg
)
[3] => Array
(
[page_url] => tac-taking-haart-23-05-2013
[evenement_nom] => TAC, Taking Haart
[evenement_type] => partenaire
[evenement_debut] => 2013-05-23 18:30:00
[evenement_entete] => Projection / débat
[evenement_etat] => 2
[media_name] => 2013-05-13-a0580099e27fff995789d451f223e1b5.jpg
)
[4] => Array
(
[page_url] => nautilis-23-05-2013
[evenement_nom] => Nautilis
[evenement_type] => partenaire
[evenement_debut] => 2013-05-23 20:30:00
[evenement_entete] => Concert - Jazz
[evenement_etat] => 2
[media_name] => 2013-05-14-957ac5356248a1d87300ed1800154dbe.jpg
)
)
[emissions_passees_liste] => Array
(
[0] => Array
(
[emission_datetime] => 2013-05-19 17:00:00
[page_url] => get-up-19-05-2013
[emission_sujet] =>
)
[1] => Array
(
[emission_datetime] => 2013-05-12 17:00:00
[page_url] => get-up-12-05-2013
[emission_sujet] => EMISSION #72
)
[2] => Array
(
[emission_datetime] => 2013-05-05 17:00:00
[page_url] => get-up-05-05-2013
[emission_sujet] => Emission #71 : Emission After Get Up & Skank EN DIRECT du Canotier et jusqu'à 22h !
)
[3] => Array
(
[emission_datetime] => 2013-04-28 17:00:00
[page_url] => get-up-28-04-2013
[emission_sujet] => Emission #70 | Special Get Up! & Skank Festival !
)
[4] => Array
(
[emission_datetime] => 2013-04-21 17:00:00
[page_url] => get-up-21-04-2013
[emission_sujet] => Emission #69 | Roots Selection
)
[5] => Array
(
[emission_datetime] => 2013-04-14 17:00:00
[page_url] => get-up-14-04-2013
[emission_sujet] => Emission #68 / Emission spéciale GET UP SESSION #14 ! Johnny Osbourne, Lone Ranger, Soul Stereo, Legal Shot Sound System & Truth & Right
)
[6] => Array
(
[emission_datetime] => 2013-04-07 17:00:00
[page_url] => get-up-07-04-2013
[emission_sujet] => Emission #67
)
[7] => Array
(
[emission_datetime] => 2013-03-31 17:00:00
[page_url] => get-up-31032013
[emission_sujet] => Emission #66
)
[8] => Array
(
[emission_datetime] => 2013-03-24 17:00:00
[page_url] => get-up-24-03-2013
[emission_sujet] => Emission #65
)
[9] => Array
(
[emission_datetime] => 2013-03-17 17:00:00
[page_url] => get-up-17-03-2013
[emission_sujet] => Emission #64
)
[10] => Array
(
[emission_datetime] => 2013-03-10 17:00:00
[page_url] => get-up-10-03-2013
[emission_sujet] => Emission #63 | Spéciale Nantes Dub Club #8
)
[11] => Array
(
[emission_datetime] => 2013-03-03 17:00:00
[page_url] => get-up-03-03-2013
[emission_sujet] => Emission #62
)
[12] => Array
(
[emission_datetime] => 2013-02-24 17:00:00
[page_url] => get-up-24-02-2013
[emission_sujet] => Emission #61
)
[13] => Array
(
[emission_datetime] => 2013-02-17 17:00:00
[page_url] => get-up-17-02-2013
[emission_sujet] => Emission #60
)
[14] => Array
(
[emission_datetime] => 2013-02-10 17:00:00
[page_url] => get-up-10-02-2013
[emission_sujet] => Emission #59
)
[15] => Array
(
[emission_datetime] => 2013-02-03 17:00:00
[page_url] => get-up-03-02-2013
[emission_sujet] => Emission #58
)
[16] => Array
(
[emission_datetime] => 2013-01-27 17:00:00
[page_url] => get-up-27-01-2013
[emission_sujet] => Emission #57 : Special Nantes Dub Club | Interview | Mix | Places à gagner !
)
[17] => Array
(
[emission_datetime] => 2013-01-20 17:00:00
[page_url] => get-up-20-01-2013
[emission_sujet] => Emission #56
)
[18] => Array
(
[emission_datetime] => 2013-01-13 17:00:00
[page_url] => get-up-13-01-2013
[emission_sujet] => Emission #55
)
[19] => Array
(
[emission_datetime] => 2013-01-06 17:00:00
[page_url] => get-up-06-01-2013
[emission_sujet] => Emission #54
)
[20] => Array
(
[emission_datetime] => 2012-12-23 17:00:00
[page_url] => get-up-23-12-2012
[emission_sujet] => Emission #53
)
[21] => Array
(
[emission_datetime] => 2012-12-16 17:00:00
[page_url] => get-up-16-12-2012
[emission_sujet] => Emission #52
)
[22] => Array
(
[emission_datetime] => 2012-12-09 17:00:00
[page_url] => get-up-09-12-2012
[emission_sujet] => Emission #51
)
[23] => Array
(
[emission_datetime] => 2012-12-02 17:00:00
[page_url] => get-up-02-12-2012
[emission_sujet] => Emission #50
)
[24] => Array
(
[emission_datetime] => 2012-11-25 17:00:00
[page_url] => get-up-25-11-2012
[emission_sujet] => Emission #49 | Zgoaya et RDH HI FI en live dans les studios & Découverte : The Resonators
)
[25] => Array
(
[emission_datetime] => 2012-11-18 17:00:00
[page_url] => get-up-18-11-2012
[emission_sujet] => Emission #48 | Emission Spéciale DUB CLUB #6 !
)
[26] => Array
(
[emission_datetime] => 2012-11-11 17:00:00
[page_url] => get-up-11-11-2012
[emission_sujet] => Emission #47
)
[27] => Array
(
[emission_datetime] => 2012-11-04 17:00:00
[page_url] => get-up-04-11-2012
[emission_sujet] => Emission #46
)
[28] => Array
(
[emission_datetime] => 2012-10-28 17:00:00
[page_url] => get-up-28-10-2012
[emission_sujet] => Emission #45
)
[29] => Array
(
[emission_datetime] => 2012-10-21 17:00:00
[page_url] => get-up-21-10-2012
[emission_sujet] => Emission #44 | RDH Hifi en live !
)
[30] => Array
(
[emission_datetime] => 2012-10-14 17:00:00
[page_url] => get-up-14-10-2012
[emission_sujet] => Emission #43
)
[31] => Array
(
[emission_datetime] => 2012-10-07 17:00:00
[page_url] => get-up-07-10-2012
[emission_sujet] => Emission #42
)
[32] => Array
(
[emission_datetime] => 2012-09-30 17:00:00
[page_url] => get-up-30-09-2012
[emission_sujet] => Emission #41 - Nantes Dub Club #5
)
)
[prochaine_emission_programme] => Array
(
[emission_datetime] => 2013-05-26 17:00:00
[emission_sujet] =>
[page_url] => get-up-26-05-2013
)
[precedente_emission_programme] => 0
[suivante_emission_programme] => Array
(
[emission_datetime] => 2012-09-30 17:00:00
[emission_sujet] => Emission #41 - Nantes Dub Club #5
[page_url] => get-up-30-09-2012
)
[playlist] => Array
(
)
)
PageBuilderPublic::headerHTML
PageBuilderPublic::headerTPL
PageBuilderPublic::footerTPL
PageBuilderPublic::footerHTML
SELECT config_value FROM ga_config WHERE config_label="project_debug"
