// Si hemos recibido algún criterio de busqueda lo capturamos
if ( isset($_POST['place']) ) { $centrosSelec=$_POST['place']; }
if ( isset($_POST['distritos']) ) { $distritosSelec=$_POST["distritos"]; }
if ( isset($_POST['materias']) ) { $materiasSelec=$_POST["materias"]; }
if ( isset($_POST['plazas']) ) { $plazasSelec=$_POST["plazas"]; }
if ( isset($_POST['edades']) ) { $edadesSelec=$_POST["edades"]; }
if ( isset($_POST['dia']) ) { $diaSelec=$_POST["dia"]; }
if ( isset($_POST['diadisp']) ) { $dia2Selec=$_POST["diadisp"]; }
if ( isset($_POST['semana']) ) { $semanaSelec=$_POST["semana"]; }
if ( isset($_POST['formulario'])) { $formularioSelec=$_POST["formulario"]; }
/**
* Añadimos el criterio seleccionado a la sentencia SQL
*/
$criterio="";
// Si hemos recibido un distrito en el criterio de busqueda,
// buscamos todos los centros del distrito
if ($distritosSelec) {
$centrosdistrito = mysql_query("SELECT DISTINCTROW id FROM ".$tb_centros." WHERE disponible=1 AND distrito='".$distritosSelec."' ORDER BY id ASC", $link);
if ($centrodistrito = mysql_fetch_array($centrosdistrito))
{
$criteriodistrito ="";
do
{
$criteriodistrito=$criteriodistrito." idcentro='".$centrodistrito["id"]."' OR";
}
while ($centrodistrito = mysql_fetch_array($centrosdistrito));
$criteriodistrito=$criteriodistrito." idcentro='00' ";
}
else
{
$criteriodistrito=$criteriodistrito." idcentro='00' ";
}
}
// Si hemos recibido un centro en el criterio de busqueda no buscamos por distritos
if (($distritosSelec) AND !($centrosSelec)) { $criterio=$criterio." AND (".$criteriodistrito.")"; }
if ($centrosSelec) { $criterio=$criterio." AND idcentro='".$centrosSelec."'"; }
if ($materiasSelec) { $criterio=$criterio." AND materia='".$materiasSelec."'"; }
if ($plazasSelec) { $criterio=$criterio." AND plazas='".$plazasSelec."'"; }
if ($edadesSelec) { $criterio=$criterio." AND edad LIKE'".$edadesSelec."%'"; }
if ($fechainicioSelec) { $criterio=$criterio." AND fechainicio='".$fechainicioSelec."'"; }
if ($diaSelec) { $criterio=$criterio." AND dia LIKE '%".$diaSelec."%'"; }
if ($dia2Selec) { $criterio=$criterio." AND dia='".$dia2Selec."'"; }
// Si hemos recibido una semana en el criterio de busqueda, buscamos todas las actividades
// con fecha en los dias correspondientes a la semana
if ($semanaSelec)
{
switch ($semanaSelec)
{
case 9:
$criterio=$criterio." AND ( dia LIKE '%26/02/%' OR dia LIKE '%27/02/%' OR dia LIKE '%28/02/%' OR dia LIKE '%01/03/%' OR dia LIKE '%02/03/%' OR dia LIKE '%03/03/%' OR dia LIKE '%04/03/%' ) ";
break;
case 10:
$criterio=$criterio." AND ( dia LIKE '%05/03/%' OR dia LIKE '%06/03/%' OR dia LIKE '%07/03/%' OR dia LIKE '%08/03/%' OR dia LIKE '%09/03/%' OR dia LIKE '%10/03/%' OR dia LIKE '%11/03/%' ) ";
break;
case 11:
$criterio=$criterio." AND ( dia LIKE '%12/03/%' OR dia LIKE '%13/03/%' OR dia LIKE '%14/03/%' OR dia LIKE '%15/03/%' OR dia LIKE '%16/03/%' OR dia LIKE '%17/03/%' OR dia LIKE '%18/03/%' ) ";
break;
case 12:
$criterio=$criterio." AND ( dia LIKE '%19/03/%' OR dia LIKE '%20/03/%' OR dia LIKE '%21/03/%' OR dia LIKE '%22/03/%' OR dia LIKE '%23/03/%' OR dia LIKE '%24/03/%' OR dia LIKE '%25/03/%' ) ";
break;
case 13:
$criterio=$criterio." AND ( dia LIKE '%26/03/%' OR dia LIKE '%27/03/%' OR dia LIKE '%28/03/%' OR dia LIKE '%29/03/%' OR dia LIKE '%30/03/%' OR dia LIKE '%31/03/%' OR dia LIKE '%01/04/%' ) ";
break;
case 14:
$criterio=$criterio." AND ( dia LIKE '%02/04/%' OR dia LIKE '%03/04/%' OR dia LIKE '%04/04/%' OR dia LIKE '%05/04/%' OR dia LIKE '%06/04/%' OR dia LIKE '%07/04/%' OR dia LIKE '%08/04/%' ) ";
break;
case 15:
$criterio=$criterio." AND ( dia LIKE '%09/04/%' OR dia LIKE '%10/04/%' OR dia LIKE '%11/04/%' OR dia LIKE '%12/04/%' OR dia LIKE '%13/04/%' OR dia LIKE '%14/04/%' OR dia LIKE '%15/04/%' ) ";
break;
case 16:
$criterio=$criterio." AND ( dia LIKE '%16/04/%' OR dia LIKE '%17/04/%' OR dia LIKE '%18/04/%' OR dia LIKE '%19/04/%' OR dia LIKE '%20/04/%' OR dia LIKE '%21/04/%' OR dia LIKE '%22/04/%' ) ";
break;
case 17:
$criterio=$criterio." AND ( dia LIKE '%23/04/%' OR dia LIKE '%24/04/%' OR dia LIKE '%25/04/%' OR dia LIKE '%26/04/%' OR dia LIKE '%27/04/%' OR dia LIKE '%28/04/%' OR dia LIKE '%29/04/%' ) ";
break;
case 18:
$criterio=$criterio." AND ( dia LIKE '%30/04/%' OR dia LIKE '%01/05/%' OR dia LIKE '%02/05/%' OR dia LIKE '%03/05/%' OR dia LIKE '%04/05/%' OR dia LIKE '%05/05/%' OR dia LIKE '%06/05/%' ) ";
break;
case 19:
$criterio=$criterio." AND ( dia LIKE '%07/05/%' OR dia LIKE '%08/05/%' OR dia LIKE '%09/05/%' OR dia LIKE '%10/05/%' OR dia LIKE '%11/05/%' OR dia LIKE '%12/05/%' OR dia LIKE '%13/05/%' ) ";
break;
case 20:
$criterio=$criterio." AND ( dia LIKE '%14/05/%' OR dia LIKE '%15/05/%' OR dia LIKE '%16/05/%' OR dia LIKE '%17/05/%' OR dia LIKE '%18/05/%' OR dia LIKE '%19/05/%' OR dia LIKE '%20/05/%' ) ";
break;
case 21:
$criterio=$criterio." AND ( dia LIKE '%21/05/%' OR dia LIKE '%22/05/%' OR dia LIKE '%23/05/%' OR dia LIKE '%24/05/%' OR dia LIKE '%25/05/%' OR dia LIKE '%26/05/%' OR dia LIKE '%27/05/%' ) ";
break;
case 22:
$criterio=$criterio." AND ( dia LIKE '%28/05/%' OR dia LIKE '%29/05/%' OR dia LIKE '%30/05/%' OR dia LIKE '%31/05/%' OR dia LIKE '%01/06/%' OR dia LIKE '%02/06/%' OR dia LIKE '%03/06/%' ) ";
break;
case 23:
$criterio=$criterio." AND ( dia LIKE '%04/06/%' OR dia LIKE '%05/06/%' OR dia LIKE '%06/06/%' OR dia LIKE '%07/06/%' OR dia LIKE '%08/06/%' OR dia LIKE '%09/06/%' OR dia LIKE '%10/06/%' ) ";
break;
case 24:
$criterio=$criterio." AND ( dia LIKE '%11/06/%' OR dia LIKE '%12/06/%' OR dia LIKE '%13/06/%' OR dia LIKE '%14/06/%' OR dia LIKE '%15/06/%' OR dia LIKE '%16/06/%' OR dia LIKE '%17/06/%' ) ";
break;
case 25:
$criterio=$criterio." AND ( dia LIKE '%18/06/%' OR dia LIKE '%19/06/%' OR dia LIKE '%20/06/%' OR dia LIKE '%21/06/%' OR dia LIKE '%22/06/%' OR dia LIKE '%23/06/%' OR dia LIKE '%24/06/%' ) ";
break;
}
}
?>
Selecciona una o més opcions de cerca perquè apareguin les activitats