← Back
Editing: presenze_sto.php
<?php ###___###___###___###___###___###___###___###___###___###___###___###___### ### SmaDIB: Smart Database Interface Builder 1.0.b1 ### ### by Smartmedia 2000 http://www.smartmedia2000.it/ ### ### info email: smadib@smartmedia2000.it ### ### released under GPLv2 license http://www.gnu.org/licenses/gpl.txt ### ###___###___###___###___###___###___###___###___###___###___###___###___### require_once ("../funct.php"); require_once ("sess.php"); require_once ("conn.php"); $ptitolo = "Storico presenze"; $table = "presenze"; require_once ("../lan_it.php"); require_once ("testacoda.php"); $st = $_REQUEST['st'] != "" ? $_REQUEST['st'] : 3; $numeroC = $_REQUEST['numeroC']; $nomePC = $_REQUEST['nomePC']; $sistC = $_REQUEST['sistC']; $query = new doQuery(); $id_sistemaz_id = array (); $id_sistemaz_nome = array (); $sqlSi = "SELECT `id`, `nome` FROM `sistemazioni` WHERE `id_utente`=$id_utente"; $rowSi = $query->freeQuery ($sqlSi, 0); foreach ($rowSi AS $i=>$rowSi) { $id_sistemaz_id[] = $rowSi->id; $id_sistemaz_nome[] = $rowSi->nome; } $elenco.= "<tr bgcolor=\"#FFFFFF\"> <td><b>Numero</b></td> <td><b>Sist.</b></td> <td><b>Persona:<br />Cognome Nome</b></td> <td><b><br />Luogo Data nascita</b></td> <td><b>Tipo pers.</b></td> <td><b>Check-In</b></td> <td>previsto</td> <td><b>Check-out</b></td> <td>previsto</td> </tr> <tr><td colspan=\"18\" bgcolor=\"#000000\" height=\"2\"></td></tr> <tr><td><input type=\"hidden\" name=\"tp\" value=\"$tp\" /> <input type=\"hidden\" name=\"tpC\" value=\"$tpC\" /> <input type=\"hidden\" name=\"st\" value=\"$st\" /> <input name=\"numeroC\" type=\"text\" size=\"6\" value=\"$numeroC\" /></td> <td> </td> <td colspan=\"3\"><input name=\"nomeC\" type=\"text\" size=\"8\" value=\"$nomeC\" /> <input name=\"nomePC\" type=\"text\" size=\"8\" value=\"$nomePC\" /> <input type=\"submit\" value=\"cerca\" /></td> <td colspan=\"8\"> </td></tr> <tr><td colspan=\"18\" bgcolor=\"#000000\" height=\"2\"></td></tr>\n"; if ($nomeC || $sistC || $numeroC) { # condizioni supplementari di ricerca if ($numeroC) $whCond.= "AND `numero` LIKE '%$numeroC%' "; if ($nomeC) $whCond.= "AND `cognome` LIKE '$nomeC%' "; if ($nomePC) $whCond.= "AND `nome` LIKE '$nomePC%' "; $sql = "SELECT `contratti`.`id` AS `idContratti`, `numero`, `contratti`.`tipo`, `tipo_contr`, `contratti`.`stato`, `contratti`.`data_in`, `contratti`.`data_out`, `id_sistemaz`, `data_operaz`, DATE_FORMAT(`contratti`.`data_in`, '%w') AS `g_in`, DATE_FORMAT(`contratti`.`data_out`, '%w') AS `g_out`,`persone`, `adulti`, `bambini`, `neonati`, `cani0`, `cani1`, `cani2`, `persone`.`id` AS `idPersona`, `cognome`, `nome`, `data_nasc`, `comune_nasc`, `persone`.`tipo` AS `persTipo` FROM $wc2p AND `persone`.`stato`>=0 $whCond ORDER BY $ordCond"; $sql = "SELECT `presenze`.*, `cognome`, `nome`, `data_nasc`, `comune_nasc`, `persone`.`tipo`, `contratti`.`tipo` AS `tipoC`, `id_sistemaz`, `contratti`.`data_in` AS `data_in_pr`, `numero` FROM $wc2p AND `persone`.`stato`>=0 AND `presenze`.`data_in` NOT LIKE '0000%' $whCond ORDER BY `presenze`.`data_in` DESC"; $rows = $query->freeQuery ($sql, 0); } if ($rows != "") foreach ($rows as $i=>$row) { $bgcolor = rowCol ($i); $numero = $row->numero ? $row->numero : ""; $comune_nasc = $query->getPlace ($row->comune_nasc, 0); if ($row->id_sistemaz != 0) $idSist = array_search ($row->id_sistemaz, $id_sistemaz_id); else $idSist = ""; # stato maggiore di 10 per posto fisso if ($row->stato > 10) $pf = "PF"; else $pf = ""; $stato = fmod ($row->stato, 10); $dataCkout = !strpos($row->data_out, "00-00") ? date2data ($row->data_out) : ""; $dataOutPr = !strpos($row->data_out_pr, "00-00") ? date2data ($row->data_out_pr) : ""; $urlParam = "?tp=".$row->tipo."&tpC=".$row->tipo_contr."&st=".$stato."&nomeC=$nomeC&nomePC=$nomePC"; $elenco.= " </tr> <tr bgcolor=\"#$bgcolor\" rowspan=\"1\"> <td><b>".$numero."</b></td> <td><b>".$tipoAr[$row->tipoC]." ".$id_sistemaz_nome[$idSist]." $pf</b></td> <td><b>".$row->cognome." ".$row->nome."</b></td> <td>".$comune_nasc['comune']." ".date2data ($row->data_nasc)."</td> <td>".$tipoPers[$row->tipo]."</td> <td><b>".date2data ($row->data_in)."</b></td> <td>".date2data ($row->data_in_pr)."</td> <td><b>".$dataCkout."</b></td> <td>$dataOutPr</td>\n"; } $elenco.= " </tr> <tr><td colspan=\"18\" bgcolor=\"#000000\" height=\"4\"></td></tr>\n"; if ($isCkin) $cal.= "<b>Arrivi previsti nel giorno: $ap</b>"; echo "$testa <script type=\"text/javascript\" language=\"JavaScript\"> function checkIn(id, num) { if (confirm('Stai per effettuare il check-in rapido del contratto '+num+'. Premi OK per confermare.')) document.location='".$_SERVER['PHP_SELF'].$urlParam."&idC='+ id +'&az=ckinr'; } </script> <h2 align=\"center\">$ptitolo</h2> $cal <form name=\"form1\" method=\"post\" action=\"".$_SERVER['PHP_SELF']."\" > <table align=\"center\"> $elenco </table></form> $coda"; ?>
Save File
Cancel