<?
header('Content-Type: application/json');
if(!$_GET['radioid']){exit();}

// initialisation de la connexion CLOUD
include "config.php";

// on se connecte à la base de données
$apconnect = mysql_connect("localhost", "api", "eqnFKPUzaS7NX2Ef");
mysql_select_db("api",$apconnect) or die ('Problème de connection: ' . mysql_error());

// on détermine des variables
$ajoutsql = "";
if($_GET['day']){$ajoutsql = " AND jour=\"".$_GET['day']."\"";}else{
    //$ajoutsql = " AND jour=\"".date('Y-m-d')."\"";
    }
    
// quel jour sommes-nous
$jour = date('N');
switch($jour)
  {
    case "1": $day1="lundi";$day2="mardi";$day3="mercredi";$day4="jeudi";$day5="vendredi";$day6="samedi";$day7="dimanche";break;
    case "2": $day1="mardi";$day2="mercredi";$day3="jeudi";$day4="vendredi";$day5="samedi";$day6="dimanche";$day7="lundi";break;
    case "3": $day1="mercredi";$day2="jeudi";$day3="vendredi";$day4="samedi";$day5="dimanche";$day6="lundi";$day7="mardi";break;
    case "4": $day1="jeudi";$day2="vendredi";$day3="samedi";$day4="dimanche";$day5="lundi";$day6="mardi";$day7="mercredi";break;
    case "5": $day1="vendredi";$day2="samedi";$day3="dimanche";$day4="lundi";$day5="mardi";$day6="mercredi";$day7="jeudi";break;
    case "6": $day1="samedi";$day2="dimanche";$day3="lundi";$day4="mardi";$day5="mercredi";$day6="jeudi";$day7="vendredi";break;
    case "7": $day1="dimanche";$day2="lundi";$day3="mardi";$day4="mercredi";$day5="jeudi";$day6="vendredi";$day7="samedi";break;
  }

// on créé le tableau original
mysql_query('SET CHARACTER SET utf8');
$tab=array();
$i2=0;

// Jour 1
$liste=mysql_query("SELECT * FROM programmes WHERE radioid=\"".$_GET['radioid']."\" AND ".$day1."=\"O\"".$ajoutsql." ORDER BY heure_debut ASC LIMIT 20");$res=mysql_num_rows($liste);
for($i=0;$i<$res;$i++)  {
    $tab['programmes'][$i2]['id'] = mysql_result($liste,$i,'id');
    $tab['programmes'][$i2]['radioid'] = mysql_result($liste,$i,'radioid');
    $tab['programmes'][$i2]['titre'] = mysql_result($liste,$i,'titre');
    $tab['programmes'][$i2]['animateur'] = mysql_result($liste,$i,'animateur');
    $tab['programmes'][$i2]['heure_debut'] = mysql_result($liste,$i,'heure_debut');
    $tab['programmes'][$i2]['heure_fin'] = mysql_result($liste,$i,'heure_fin');
    $tab['programmes'][$i2]['jour'] = date("Y-m-d", time());
    $tab['programmes'][$i2]['photo'] = mysql_result($liste,$i,'photo');
    if(mysql_result($liste,$i,'heure_debut')<="".date('H:i:s')."" AND mysql_result($liste,$i,'heure_fin')>="".date('H:i:s').""){$tab['programmes'][$i2]['live'] = true;}else{$tab['programmes'][$i2]['live'] = false;}
    $i2++;
  }

// Jour 2
$liste=mysql_query("SELECT * FROM programmes WHERE radioid=\"".$_GET['radioid']."\" AND ".$day2."=\"O\"".$ajoutsql." ORDER BY heure_debut ASC LIMIT 50");$res=mysql_num_rows($liste);
for($i=0;$i<$res;$i++)  {
    $tab['programmes'][$i2]['id'] = mysql_result($liste,$i,'id');
    $tab['programmes'][$i2]['radioid'] = mysql_result($liste,$i,'radioid');
    $tab['programmes'][$i2]['titre'] = mysql_result($liste,$i,'titre');
    $tab['programmes'][$i2]['animateur'] = mysql_result($liste,$i,'animateur');
    $tab['programmes'][$i2]['heure_debut'] = mysql_result($liste,$i,'heure_debut');
    $tab['programmes'][$i2]['heure_fin'] = mysql_result($liste,$i,'heure_fin');
    $tab['programmes'][$i2]['jour'] = date("Y-m-d", time()+(3600*24));
    $tab['programmes'][$i2]['photo'] = mysql_result($liste,$i,'photo');
    $tab['programmes'][$i2]['live'] = false;
    $i2++;
  }

// Jour 3
$liste=mysql_query("SELECT * FROM programmes WHERE radioid=\"".$_GET['radioid']."\" AND ".$day3."=\"O\"".$ajoutsql." ORDER BY heure_debut ASC LIMIT 50");$res=mysql_num_rows($liste);
for($i=0;$i<$res;$i++)  {
    $tab['programmes'][$i2]['id'] = mysql_result($liste,$i,'id');
    $tab['programmes'][$i2]['radioid'] = mysql_result($liste,$i,'radioid');
    $tab['programmes'][$i2]['titre'] = mysql_result($liste,$i,'titre');
    $tab['programmes'][$i2]['animateur'] = mysql_result($liste,$i,'animateur');
    $tab['programmes'][$i2]['heure_debut'] = mysql_result($liste,$i,'heure_debut');
    $tab['programmes'][$i2]['heure_fin'] = mysql_result($liste,$i,'heure_fin');
    $tab['programmes'][$i2]['jour'] = date("Y-m-d", time()+(3600*24*2));
    $tab['programmes'][$i2]['photo'] = mysql_result($liste,$i,'photo');
    $tab['programmes'][$i2]['live'] = false;
    $i2++;
  }

// Jour 4
$liste=mysql_query("SELECT * FROM programmes WHERE radioid=\"".$_GET['radioid']."\" AND ".$day4."=\"O\"".$ajoutsql." ORDER BY heure_debut ASC LIMIT 50");$res=mysql_num_rows($liste);
for($i=0;$i<$res;$i++)  {
    $tab['programmes'][$i2]['id'] = mysql_result($liste,$i,'id');
    $tab['programmes'][$i2]['radioid'] = mysql_result($liste,$i,'radioid');
    $tab['programmes'][$i2]['titre'] = mysql_result($liste,$i,'titre');
    $tab['programmes'][$i2]['animateur'] = mysql_result($liste,$i,'animateur');
    $tab['programmes'][$i2]['heure_debut'] = mysql_result($liste,$i,'heure_debut');
    $tab['programmes'][$i2]['heure_fin'] = mysql_result($liste,$i,'heure_fin');
    $tab['programmes'][$i2]['jour'] = date("Y-m-d", time()+(3600*24*3));
    $tab['programmes'][$i2]['photo'] = mysql_result($liste,$i,'photo');
    $tab['programmes'][$i2]['live'] = false;
    $i2++;
  }

// Jour 5
$liste=mysql_query("SELECT * FROM programmes WHERE radioid=\"".$_GET['radioid']."\" AND ".$day5."=\"O\"".$ajoutsql." ORDER BY heure_debut ASC LIMIT 50");$res=mysql_num_rows($liste);
for($i=0;$i<$res;$i++)  {
    $tab['programmes'][$i2]['id'] = mysql_result($liste,$i,'id');
    $tab['programmes'][$i2]['radioid'] = mysql_result($liste,$i,'radioid');
    $tab['programmes'][$i2]['titre'] = mysql_result($liste,$i,'titre');
    $tab['programmes'][$i2]['animateur'] = mysql_result($liste,$i,'animateur');
    $tab['programmes'][$i2]['heure_debut'] = mysql_result($liste,$i,'heure_debut');
    $tab['programmes'][$i2]['heure_fin'] = mysql_result($liste,$i,'heure_fin');
    $tab['programmes'][$i2]['jour'] = date("Y-m-d", time()+(3600*24*4));
    $tab['programmes'][$i2]['photo'] = mysql_result($liste,$i,'photo');
    $tab['programmes'][$i2]['live'] = false;
    $i2++;
  }

// Jour 6
$liste=mysql_query("SELECT * FROM programmes WHERE radioid=\"".$_GET['radioid']."\" AND ".$day6."=\"O\"".$ajoutsql." ORDER BY heure_debut ASC LIMIT 50");$res=mysql_num_rows($liste);
for($i=0;$i<$res;$i++)  {
    $tab['programmes'][$i2]['id'] = mysql_result($liste,$i,'id');
    $tab['programmes'][$i2]['radioid'] = mysql_result($liste,$i,'radioid');
    $tab['programmes'][$i2]['titre'] = mysql_result($liste,$i,'titre');
    $tab['programmes'][$i2]['animateur'] = mysql_result($liste,$i,'animateur');
    $tab['programmes'][$i2]['heure_debut'] = mysql_result($liste,$i,'heure_debut');
    $tab['programmes'][$i2]['heure_fin'] = mysql_result($liste,$i,'heure_fin');
    $tab['programmes'][$i2]['jour'] = date("Y-m-d", time()+(3600*24*5));
    $tab['programmes'][$i2]['photo'] = mysql_result($liste,$i,'photo');
    $tab['programmes'][$i2]['live'] = false;
    $i2++;
  }

// Jour 7
$liste=mysql_query("SELECT * FROM programmes WHERE radioid=\"".$_GET['radioid']."\" AND ".$day7."=\"O\"".$ajoutsql." ORDER BY heure_debut ASC LIMIT 50");$res=mysql_num_rows($liste);
for($i=0;$i<$res;$i++)  {
    $tab['programmes'][$i2]['id'] = mysql_result($liste,$i,'id');
    $tab['programmes'][$i2]['radioid'] = mysql_result($liste,$i,'radioid');
    $tab['programmes'][$i2]['titre'] = mysql_result($liste,$i,'titre');
    $tab['programmes'][$i2]['animateur'] = mysql_result($liste,$i,'animateur');
    $tab['programmes'][$i2]['heure_debut'] = mysql_result($liste,$i,'heure_debut');
    $tab['programmes'][$i2]['heure_fin'] = mysql_result($liste,$i,'heure_fin');
    $tab['programmes'][$i2]['jour'] = date("Y-m-d", time()+(3600*24*6));
    $tab['programmes'][$i2]['photo'] = mysql_result($liste,$i,'photo');
    $tab['programmes'][$i2]['live'] = false;
    $i2++;
  }

// on convertit en JSON le tableau PHP
$json = json_encode($tab);

// on ferme la base de données
echo $json;

mysql_close();
exit();
?>