← Back
Editing: nongraditi_ed.php
<?php ###___###___###___###___###___###___###___###___###___###___###___###___### ### SmaDIB: Smart Database Interface Builder 1.0.b1 ### ### by Smartmedia 2000 http://www.smartmedia2000.it/ ### ### info email: smadib@smartmedia2000.it ### ###___###___###___###___###___###___###___###___###___###___###___###___### require_once ("../funct.php"); require_once ("sess.php"); require_once ("conn.php"); $table = "persone"; $ptitolo = "Ospiti non graditi"; require_once ("../lan_it.php"); require_once ("testacoda.php"); $query = new doQuery (); $noEmpty = array ('cognome', 'nome', 'data_nasc', 'stato_nasc'); # insert here the field names you want to be compiled for query to go $dateFlds = array ('data_nasc', 'docum_data'); # date fields to be converted in dd//mm/yyyy $urlParam = "?tp=$tp&tpC=$tpC&st=$st&idC=$idC&nomeC=$nomeC"; if ($az=="canc") { $query->delete (); $query->freeQuery ("DELETE FROM `presenze` WHERE `id_utente`=".ID_UTENTE." AND `id_contratto`='$idC' AND `id_persona`=$id LIMIT 1", 0); header("Location: ".$_SERVER['PHP_SELF'].$urlParam); } if ($op == "ds") { $query->insert ($_POST, $noEmpty); $idPersona = mysql_insert_id(); $sqlPr = "INSERT INTO `presenze` (`id_utente`, `id_contratto`, `id_persona`) VALUES (".ID_UTENTE.", '$idC', '$idPersona')"; $query->freeQuery ($sqlPr, 4); } else if ($op == "up") { $query->update ($_POST, $noEmpty); } if ($az=="ed") { $row = $query->selectById (0); $id = $row->id; $valop = "up"; $backPres = "<input type=\"button\" value=\"Annulla mod.\" onclick=\"javascript:document.location='".$_SERVER['PHP_SELF']."$urlParam'\" />"; $luogoNasc = $query->getPlace ($row->comune_nasc, $row->stato_nasc); $luogoRes = $query->getPlace ($row->comune_res, $row->stato_res); $cittadin = $query->getPlace (0, $row->cittadinanza); $luogoDoc = $query->getPlace ($row->docum_rilasc, $row->docum_rilasc); $cittadin = $query->getPlace (0, $row->cittadinanza); $fieldDocRil = $row->cittadinanza != 120 ? "stato" : "comune"; $docum_rilascN = $luogoDoc[$fieldDocRil]; } else { $valop = "ds"; $fieldDocRil = "comune"; } $elenco.= "<tr bgcolor=\"#FFFFFF\"><td valign=\"bottom\" rowspan=\"8\" align=\"center\">funzioni</td> $iniTab <td><b>Nome</b></td> <td><b>Cognome</b></td> <td><b>Sesso</b></td> <td><b>Data iscr.</b></td> <td><b>Tipo</b></td> <td><b>Stato</b></td> $mezTab <td><input name=\"nome\" type=\"text\" size=\"8\" maxlenght=\"50\" value=\"".$row->nome."\" /></td> <td><input name=\"cognome\" type=\"text\" size=\"10\" maxlenght=\"80\" value=\"".$row->cognome."\" /></td> <td bgcolor=\"#EEEEEE\">".selList ('sesso', $arSesso, '', $row->sesso, '', '')." </td> <td bgcolor=\"#EEEEEE\">".date2data ($row->data_iscr)." </td> <td>".selList ('tipo', $tipoPers, '', $row->tipo, '', '')."</td> <td>".selList ('stato', $statoPers, '', $row->stato, '', '')."</td> $finTab$iniTab <td><b>Data nascita</b></td> <td><b>Telefono</b></td> <td><b>Fax</b></td> <td><b>Email</b></td> $mezTab <td><input name=\"data_nasc\" type=\"text\" size=\"7\" maxlenght=\"\" value=\"".date2data ($row->data_nasc)."\" /></td> <td><input name=\"telefono\" type=\"text\" size=\"8\" maxlenght=\"20\" value=\"".$row->telefono."\" /></td> <td><input name=\"fax\" type=\"text\" size=\"6\" maxlenght=\"20\" value=\"".$row->fax."\" /></td> <td><input name=\"email\" type=\"text\" size=\"20\" maxlenght=\"50\" value=\"".$row->email."\" /></td> $finTab$iniTab <td><b>Comune Provincia nascita</b></td> <td><b>Stato nascita</b></td> $mezTab <td>".ajLookup ('comune_nasc', $row->comune_nasc, $luogoNasc['comune']." ".$luogoNasc['targa'])."</td> <td>".ajLookup ('stato_nasc', $row->stato_nasc, $luogoNasc['stato'])."</td> $finTab$iniTab <td><b>Indirizzo</b></td> <td><b>Cap</b></td> <td><b>Città</b></td> $mezTab <td><input name=\"indirizzo\" type=\"text\" size=\"20\" maxlenght=\"50\" value=\"".$row->indirizzo."\" /></td> <td><input name=\"cap\" type=\"text\" size=\"5\" maxlenght=\"10\" value=\"".$row->cap."\" /></td> <td><input name=\"citta\" type=\"text\" size=\"15\" maxlenght=\"50\" value=\"".$row->citta."\" /></td> $finTab$iniTab <td><b>Comune Provincia</b></td> <td><b>Stato</b></td> $mezTab <td>".ajLookup ('comune_res', $row->comune_res, $luogoRes['comune']." ".$luogoRes['targa'])."</td> <td>".ajLookup ('stato_res', $row->stato_res, $luogoRes['stato'])."</td> $finTab$iniTab <td><b>Stato Cittadinanza</b></td> <td><b>Documento: rilasciato in</b></td> <td><b>Tipo</b></td> <td><b>Numero</b></td> <td><b>Data rilascio</b></td> $mezTab <td>".ajLookup ('cittadinanza', $row->cittadinanza, $cittadin['stato'])."</td> <td>".ajLookup ('docum_rilasc', $row->docum_rilasc, $docum_rilascN)."</td> <td>".selList ('docum_tipo', $listDocum, '', $row->docum_tipo, '', '')."</td> <td><input name=\"docum_num\" type=\"text\" size=\"8\" maxlenght=\"25\" value=\"".$row->docum_num."\" /></td> <td><input name=\"docum_data\" type=\"text\" size=\"7\" maxlenght=\"\" value=\"".date2data ($row->docum_data)."\" /></td> $finTab <tr bgcolor=\"#FFFFFF\"><td colspan=\"2\" align=\"center\"> <input type=\"submit\" name=\"invio\" value=\"$intesta\" /> $backPres <input type=\"hidden\" name=\"op\" value=\"$valop\" /> <input type=\"hidden\" name=\"id\" value=\"$row->id\" /> <input type=\"hidden\" name=\"idC\" value=\"$idC\" /> <input type=\"hidden\" name=\"nomeC\" value=\"$nomeC\" /> <input type=\"hidden\" name=\"tp\" value=\"$tp\" /> <input type=\"hidden\" name=\"tpC\" value=\"$tpC\" /> <input type=\"hidden\" name=\"st\" value=\"$st\" /> </td></tr><tr><td colspan=\"21\" bgcolor=\"#000000\" height=\"4\"></td>"; $sql = "SELECT `persone`.* FROM `persone` WHERE `stato`<0 ORDER BY `cognome`, `nome`"; $rows = $query->freeQuery ($sql, 0); foreach ($rows as $i=>$row) { $bgcolor = rowCol ($i); $luogoNascG = $query->getPlace ($row->comune_nasc, $row->stato_nasc); $luogoResG = $query->getPlace ($row->comune_res, $row->stato_res); $cittadinG = $query->getPlace (0, $row->cittadinanza); $luogoDocG = $query->getPlace ($row->docum_rilasc, $row->docum_rilasc); $fieldDocRilG = $row->cittadinanza != 120 ? "stato" : "comune"; $elenco.= " </tr> <tr bgcolor=\"#$bgcolor\"><td rowspan=\"1\" nowrap>\n"; if ($az!="ed") $elenco.= "<a href=\"".$_SERVER['PHP_SELF'].$urlParam."&id=".$row->id."&az=ed&idC=$idC\" title=\"modifica riga\"><img src=\"images/edit.gif\" border=\"0\" hspace=\"3\" alt=\"modifica riga\" align=\"absmiddle\" /></a> <a href=\"#\" onClick=\"javascript:confDel($row->id)\" title=\"cancella persona\"><img src=\"images/delete.gif\" border=\"0\" alt=\"cancella riga\" align=\"absmiddle\" /></a></td>"; else $elenco.= " "; $elenco.= "<td>$iniTabR <td><b>".$row->cognome."</b></td>\n<td><b>".$row->nome."</b></td> \n <td><b>".date2data ($row->data_nasc)."</b></td>\n<td><b>".$luogoNascG['comune']." ".$luogoNascG['targa'].", ".$luogoNascG['stato']."</b> - </td> <td>".date2data ($row->data_iscr)."</td>\n<td>".$statoPers[$row->stato]."</td> $finTabR"; } $elenco.= " </tr> <tr><td colspan=\"21\" bgcolor=\"#000000\" height=\"4\"></td></tr>\n"; echo "$testa <script type=\"text/javascript\" language=\"JavaScript\"> function confDel(id) { if (confirm('Vuoi cancellare veramente questa riga? Premi OK per confermare.')) document.location='".$_SERVER['PHP_SELF'].$urlParam."&id='+ id +'&az=canc'; } </script> <h2 align=\"center\">$ptitolo</h2> ".scrAjLookup ('comune_nasc', 'comune').scrAjLookup ('stato_nasc', 'stato').scrAjLookup ('comune_res', 'comune').scrAjLookup('stato_res', 'stato').scrAjLookup ('cittadinanza', 'stato').scrAjLookup ('docum_rilasc', $fieldDocRil)." <form name=\"form1\" method=\"post\" action=\"".$_SERVER['PHP_SELF']."\" > <table align=\"center\"> $elenco </table></form> $coda"; ?>
Save File
Cancel