PageManagerPublic::__construct
PageBuilderPublic::__construct
Page::__construct
PageManagerPublic::displayPage
SELECT id_page FROM ga_page WHERE page_url="emissions"
SELECT COUNT(1) count FROM ga_page WHERE page_url="emissions" AND page_link="0"
SELECT id_page FROM ga_page WHERE page_link="70" AND page_url="electro-bamako-02-11-2012"
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="electro-bamako-02-11-2012"
SELECT id_stage, page_name, page_title, page_description, page_keywords FROM ma_stage WHERE page_url="electro-bamako-02-11-2012"
SELECT id_programme, page_name, page_title, page_description, page_keywords FROM ma_programme WHERE page_url="electro-bamako-02-11-2012"
SELECT id_emission, page_name, page_title, page_description, page_keywords FROM ma_emission WHERE page_url="electro-bamako-02-11-2012"
SELECT id_page,page_link FROM ga_page WHERE page_url="emission"
SELECT page_url FROM ga_page WHERE id_page="70"
SELECT page_url FROM ga_page WHERE id_page="8"
Page::getPageStatic
SELECT * FROM ga_page WHERE page_url="emission" 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="8" 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="8" 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='8' 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="emission" 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.id_emission, ma_emission.page_name, ma_emission.page_url, ma_emission.page_title, ma_emission.page_description, ma_emission.page_keywords, ma_emission.emission_datetime, ma_emission.emission_datetime_fin, ma_emission.emission_duree, ma_emission.emission_sujet, ma_emission.emission_entete, ma_emission.emission_description, ma_emission.emission_audio, ma_emission.id_playlist_emission, ma_programme.programme_nom, ma_programme.programme_description, ma_media.media_name, ma_media.media_description, ma_programme.page_url media_repertoire, ma_programme.id_programme 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.page_url="electro-bamako-02-11-2012"
SELECT ma_media.media_name emission_media_name, ma_media.media_description emission_media_description FROM ( ma_emission) LEFT JOIN ma_media ON ma_media.id_emission=ma_emission.id_emission WHERE page_url="electro-bamako-02-11-2012" AND media_type='une'
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
SELECT ma_tag.tag_name FROM ( ma_emission) LEFT JOIN ma_tag ON ma_tag.id_programme=ma_emission.id_programme WHERE ma_emission.page_url="electro-bamako-02-11-2012"
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() ORDER BY ma_emission.emission_datetime ASC LIMIT 30
SELECT ma_media.media_name, ma_media.media_description FROM ( ma_emission) LEFT JOIN ma_media ON ma_media.id_emission=ma_emission.id_emission WHERE page_url="electro-bamako-02-11-2012" AND ma_media.media_type='son'
SELECT ma_commentaire.id_commentaire, ma_commentaire.commentaire_name, ma_commentaire.commentaire_contenu, ma_commentaire.commentaire_date, ma_commentaire.commentaire_auteur, ma_commentaire.id_article, ma_commentaire.id_emission, ma_commentaire.commentaire_email FROM ( ma_commentaire) LEFT JOIN ma_emission ON ma_commentaire.id_emission=ma_emission.id_emission WHERE ma_emission.page_url="electro-bamako-02-11-2012" AND ma_commentaire.commentaire_status=1 ORDER BY ma_commentaire.commentaire_date ASC
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='17' 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='17' 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='17' AND
emission_datetime<'2012-11-02 20:00:00'
ORDER BY emission_datetime DESC
LIMIT 1
SELECT ma_emission.emission_datetime,ma_emission.emission_sujet,page_url
FROM ma_emission
WHERE id_programme='17' AND
emission_datetime>'2012-11-02 20:00:00'
ORDER BY emission_datetime ASC
LIMIT 1
[2] => Array
(
[page_url] => fete-de-la-musique-prun-21-06-2013
[evenement_nom] => Fête de la musique Prun'
[evenement_type] => prun
[evenement_debut] => 2013-06-21 17:00:00
[evenement_entete] => Emission en direct et live
[evenement_etat] => 2
[media_name] => 2013-06-13-dbcce7ecf85683c33373cc5d3023fdef.jpg
)
[2] => Array
(
[page_url] => triangle-20-06-2013
[emission_datetime] => 2013-06-20 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
)
[3] => Array
(
[page_url] => orbeat-20-06-2013
[emission_datetime] => 2013-06-20 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
)
[4] => Array
(
[page_url] => electric-chicken-20-06-2013
[emission_datetime] => 2013-06-20 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
)
[5] => Array
(
[page_url] => ground-control-21-06-2013
[emission_datetime] => 2013-06-21 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
)
[6] => Array
(
[page_url] => ghetto-blaster-21-06-2013
[emission_datetime] => 2013-06-21 17:00:00
[emission_entete] => Emission spéciale Fête de la Musique en direct du Check Point !!
[programme_nom] => Ghetto Blaster
[programme_entete] => Magazine quotidien de 2h dédiées à l'actualité culturelle locale
[media_name] => 2013-04-15-24e3d517441a03b1abb0ab0ba4e2c3a4.jpg
)
[7] => Array
(
[page_url] => electro-bamako-21-06-2013
[emission_datetime] => 2013-06-21 20:00:00
[emission_entete] =>
[programme_nom] => Electro Bamako
[programme_entete] => Du bon son pour vous faire voyager autour du monde !
[media_name] => 2012-09-21-45ba135502082264957c92e9300861a8.jpg
)
[14] => Array
(
[page_url] => super-blender-22062013
[emission_datetime] => 2013-06-22 12:00:00
[emission_entete] =>
[programme_nom] => Super Blender
[programme_entete] => Emission qui cuisine les sujets de société de la sphère alimentaire
[media_name] => 2012-09-28-7dd7a9697791767c406ab890930dc405.jpg
)
[15] => Array
(
[page_url] => i-r-m-22062013
[emission_datetime] => 2013-06-22 13:00:00
[emission_entete] =>
[programme_nom] => I.R.M
[programme_entete] => Emission sur la santé, tous les derniers samedi du mois
[media_name] => 2013-06-18-785dc82fec992af99ebf0751432a0f94.jpg
)
[16] => Array
(
[page_url] => hoop-kultur-22-06-2013
[emission_datetime] => 2013-06-22 14:00:00
[emission_entete] =>
[programme_nom] => Hoop Kultur
[programme_entete] => Voyage de curiosité en quête des cultures alternatives et indisciplinées
[media_name] => 2012-10-09-2253a2845d895175ea05237f3eb1fa6d.jpg
)
[17] => Array
(
[page_url] => disques-et-sons-de-comptoir-22-06-2013
[emission_datetime] => 2013-06-22 15:00:00
[emission_entete] =>
[programme_nom] => Disques et sons de comptoir
[programme_entete] => Emission de découverte de la nouvelle scène francophone
[media_name] => 2012-10-01-79b5f64cb92ae124712f30b9142eee9f.jpg
)
[19] => Array
(
[page_url] => inna-di-roots-22-06-2013
[emission_datetime] => 2013-06-22 17:00:00
[emission_entete] =>
[programme_nom] => Inna Di Roots
[programme_entete] => Sonorités jamaïcaines depuis leurs origines jusqu'à nos jours
[media_name] => 2012-10-01-33f8537d680d43f05d0f0cfe9f1bfb07.jpg
)
[20] => Array
(
[page_url] => take-jazz-22-06-2013
[emission_datetime] => 2013-06-22 18:00:00
[emission_entete] =>
[programme_nom] => Take Jazz
[programme_entete] => Emission de tous les jazz en compagnie de Tom Select et François
[media_name] => 2012-10-02-da14dd5ede6273ae6621eefdd0e7ec40.jpg
)
[21] => Array
(
[page_url] => groove-au-logis-22-06-2013
[emission_datetime] => 2013-06-22 19:00:00
[emission_entete] =>
[programme_nom] => Groove au Logis
[programme_entete] => Black Music d'hier à aujourd'hui dans votre Logis !
[media_name] => 2012-09-27-79b1bfc2ca0c5fe748622baef75fca12.jpg
)
[22] => Array
(
[page_url] => les-oreilles-de-jankev-22-06-2013
[emission_datetime] => 2013-06-22 20:00:00
[emission_entete] =>
[programme_nom] => Les oreilles de Jankev
[programme_entete] => Toute l'actu musique, c'est dans Les oreilles de Jankev
[media_name] => 2012-09-27-68cf8f7fdb5278e310c41aadbb1ac382.jpg
)
[24] => Array
(
[page_url] => chromosome-x-23062013
[emission_datetime] => 2013-06-23 11:00:00
[emission_entete] =>
[programme_nom] => Chromosome X
[programme_entete] => Un autre regard sur la condition féminine
[media_name] => 2013-01-22-6ce47c6d5eee981ac168fca7a43dad55.jpg
)
[25] => Array
(
[page_url] => cosmopolite-23-06-2013
[emission_datetime] => 2013-06-23 12:00:00
[emission_entete] =>
[programme_nom] => Cosmopolite
[programme_entete] => Savourez un délicieux cocktail épicé de musiques du monde !
[media_name] => 2012-10-09-f6eef342fc1024de295192b48d3e77e6.jpg
)
[26] => Array
(
[page_url] => planet-hip-hop-23-06-2013
[emission_datetime] => 2013-06-23 15:00:00
[emission_entete] =>
[programme_nom] => Planet Hip Hop
[programme_entete] => Emission à ne pas manquer pour les amoureux du Hip Hop
[media_name] => 2012-09-28-7621ebc283873f613950376555920aec.jpg
)
[27] => Array
(
[page_url] => hip-hop-shop-23-06-2013
[emission_datetime] => 2013-06-23 16:00:00
[emission_entete] =>
[programme_nom] => Hip Hop Shop
[programme_entete] => L'actualité du Hip Hop de la France au Québec, de Nantes à Queensbridge !
[media_name] => 2012-09-27-8c2721485af082b7405e138f2130d64b.jpg
)
[28] => Array
(
[page_url] => get-up-23-06-2013
[emission_datetime] => 2013-06-23 17:00:00
[emission_entete] =>
[programme_nom] => Get Up!
[programme_entete] => La culture reggae sur la bande fm nantaise !
[media_name] => 2012-10-14-b8a5c707b3a276b9d69797f6f67952a5.jpg
)
[29] => Array
(
[page_url] => truth-right-23-06-2013
[emission_datetime] => 2013-06-23 19:00:00
[emission_entete] =>
[programme_nom] => Truth & Right
[programme_entete] => Le meilleur de la musique jamaïcaine, des fondations jusqu'à aujourd'hui
[media_name] => 2012-09-27-bf404ad13a754f8e3041625646188725.jpg
)
PageBuilderPublic::headerHTML
PageBuilderPublic::headerTPL
PageBuilderPublic::footerTPL
PageBuilderPublic::footerHTML
SELECT config_value FROM ga_config WHERE config_label="project_debug"