";
/******************************************************/
/*Funzione di visualizzazione globale */
/*****************************************************/
//crea la pagina delle affluenze
function all() {
global $bgcolor1, $bgcolor2, $prefix, $dbi, $offset, $min,$id_cons_gen;
echo "
"
."
"._ORA."
"
."
"._DATA."
";
# echo "
";
echo "
";
$res = mysql_query("SELECT * FROM ".$prefix."_ele_rilaff where id_cons_gen=$id_cons_gen order by data,orario", $dbi);
$max = mysql_num_rows($res);
echo "
";
if ($max != "0") {
$i=1;
while(list($id_cons2,$orario,$data) = mysql_fetch_row($res)){
// esplode la data
$bgcolor1=($bgcolor1==$_SESSION['bgcolor1'])?$_SESSION['bgcolor2']:$_SESSION['bgcolor1'];
list($av1,$msv1,$gv1) = explode("-",$data);
list($ov1,$mv1,$sv1) = explode(":",$orario);
$i++;
echo "
";
echo "
$ov1,$mv1
";
echo "
$gv1-$msv1-$av1
";
echo "
"
."
";
}
}
echo "
";
}
// memorizza le affluenze
function rec_add_aff($do,$ov,$mv,$gv,$msv,$av,$tipo,$ok, $modello) {
global $prefix, $dbi,$id_cons_gen;
$perms=ChiSei(0);
if ($perms<256) die("Non hai i permessi per eseguire questa operazione!");
$data="$av-$msv-$gv";
$orario="$ov:$mv:00";
$confr = mysql_query("SELECT data_inizio, data_fine FROM ".$prefix."_ele_consultazione WHERE id_cons_gen ='$id_cons_gen'", $dbi);
list($dadata, $adata) = mysql_fetch_row($confr);
$dadata=strtotime($dadata);
$adata=strtotime($adata);
$cdata=strtotime($data);
// verifica se data e ora esiste e fa l'upgrade
$res = mysql_query("select * from ".$prefix."_ele_rilaff where id_cons_gen='$id_cons_gen' and data='$data' and orario='$orario'", $dbi);
$tipo= mysql_num_rows($res);
if(($tipo==0) and ($dadata <= $cdata) and ($adata >= $cdata)){
if(checkdate(intval($msv),intval($gv),intval($av))){
$result = mysql_query("insert into ".$prefix."_ele_rilaff values ('$id_cons_gen','$orario','$data')", $dbi)|| die("Impossibile inserire i dati! ".mysql_error());
}
Header("Location: admin.php?op=rec_add_aff&id_cons_gen=$id_cons_gen");
} elseif ($do==2) {
if ($ok !="1") {
ele();
OpenTable();
echo "
"._DOMCANCELLA." ? ";
echo "[ "._NO." ] - ["._YES." ]";
CloseTable();
include("footer.php");
die();
}else{
$res = mysql_query("select id_cons from ".$prefix."_ele_cons_comune where id_cons_gen='$id_cons_gen'", $dbi);
while (list($id_cons2) = mysql_fetch_row($res))
mysql_query("delete from ".$prefix."_ele_voti_parziale where id_cons='$id_cons2' and data='$data' and orario='$orario'", $dbi)|| die("Impossibile cancellare i dati! ".mysql_error());
mysql_query("delete from ".$prefix."_ele_rilaff where id_cons_gen='$id_cons_gen' and data='$data' and orario='$orario'", $dbi)|| die("Impossibile cancellare i dati! ".mysql_error());
Header("Location: admin.php?op=rec_add_aff&id_cons_gen=$id_cons_gen&contr=$data");
}
}else{
Header("Location: admin.php?op=rec_add_aff&id_cons_gen=$id_cons_gen&contr=$data");
}
}
if($do) rec_add_aff($do,$ov,$mv,$gv,$msv,$av,$tipo,$ok, $modello);
ele();
OpenTable();
all();
CloseTable();
include("footer.php");
?>