← Back
Editing: clienti_ed.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 ("conn.php"); $table = "clienti"; $ptitolo = "Archivio Clienti"; $html = ""; # htmlarea type require_once ("testacoda.php"); $perpg = 50; # amount of rows per page displayed $pgb = 19; # upper ad lower limit for bottom page count $noEmpty = array ('codice', 'rag_sociale'); $outFlds[] = "codiceC"; $outFlds[] = "ragsocC"; $dateFlds = array ('decennale','scad_valv','tara_valv','scad_decenn'); $codiceC = $_REQUEST['codiceC']; $ragsocC = $_REQUEST['ragsocC']; $valop = "ds"; if ($az == "ed") $intesta="Modifica"; else $intesta="Aggiungi"; $query = new doQuery (); if ($az=="canc") { $query->delete (); header("Location: ".$_SERVER['PHP_SELF']."?pg=$pg"); } if ($codiceC || $ragsocC) { if ($codiceC) $whCond.= " AND `codice` LIKE '$codiceC%'"; if ($ragsocC) $whCond.= " AND `rag_sociale` LIKE '$ragsocC%'"; } if ($op == "ds") { $query->insert ($_POST, $noEmpty); } else if ($op == "up") { $query->update ($_POST, $noEmpty); } if ($az=="ed") { $row = $query->selectById (0); $id = $row->id; $valop = "up"; $decennale = date2data ($_row->decennale); $scad_valv = date2data ($row->scad_valv); $tara_valv = date2data ($row->tara_valv); $scad_decenn = date2data ($row->scad_decenn); } $elenco.= "<tr bgcolor=\"#FFFFFF\"><td valign=\"bottom\" align=\"center\" rowspan=\"5\">funzioni</td> <td><b>Codice</b></td> <td colspan=\"3\"><b>Ragione sociale</b></td> <td colspan=\"3\"><b>Indirizzo</b></td> <td colspan=\"2\"><b>Localita</b></td> <td><b>Telefono</b></td> <td><b>Telefono 2</b></td> </tr> <tr bgcolor=\"#EEEEEE\"> <td><input name=\"codice\" type=\"text\" size=\"6\" maxlenght=\"6\" value=\"".$row->codice."\" /></td> <td colspan=\"3\"><input name=\"rag_sociale\" type=\"text\" size=\"25\" maxlenght=\"100\" value=\"".$row->rag_sociale."\" /></td> <td colspan=\"3\"><input name=\"indirizzo\" type=\"text\" size=\"25\" maxlenght=\"50\" value=\"".$row->indirizzo."\" /></td> <td colspan=\"2\"><input name=\"localita\" type=\"text\" size=\"15\" maxlenght=\"50\" value=\"".$row->localita."\" /></td> <td><input name=\"telefono\" type=\"text\" size=\"8\" maxlenght=\"20\" value=\"".$row->telefono."\" /></td> <td><input name=\"telefono2\" type=\"text\" size=\"8\" maxlenght=\"20\" value=\"".$row->telefono2."\" /></td> </tr> <td><b>Capacità</b></td> <td><b>Tipo serbatoio</b></td> <td><b>Decennale</b></td> <td><b>Sigla</b></td> <td><b>Fabbrica</b></td> <td><b>Matricola</b></td> <td><b>Tipo valvola</b></td> <td><b>Numero valvola</b></td> <td><b>Scadenza valvola</b></td> <td><b>Taratura valvola</b></td> <td><b>Scadenza decennale</b></td> </tr><tr bgcolor=\"#EEEEEE\"> <td><input name=\"capacita\" type=\"text\" size=\"6\" maxlenght=\"6\" value=\"".$row->capacita."\" /></td> <td><input name=\"tipo_serb\" type=\"text\" size=\"5\" maxlenght=\"15\" value=\"".$row->tipo_serb."\" /></td> <td><input name=\"decennale\" type=\"text\" size=\"8\" maxlenght=\"\" value=\"".date2data ($row->decennale)."\" /></td> <td><input name=\"sigla\" type=\"text\" size=\"5\" maxlenght=\"15\" value=\"".$row->sigla."\" /></td> <td><input name=\"fabbrica\" type=\"text\" size=\"10\" maxlenght=\"15\" value=\"".$row->fabbrica."\" /></td> <td><input name=\"matricola\" type=\"text\" size=\"10\" maxlenght=\"15\" value=\"".$row->matricola."\" /></td> <td><input name=\"tipo_valv\" type=\"text\" size=\"10\" maxlenght=\"15\" value=\"".$row->tipo_valv."\" /></td> <td><input name=\"num_valv\" type=\"text\" size=\"7\" maxlenght=\"9\" value=\"".$row->num_valv."\" /></td> <td><input name=\"scad_valv\" type=\"text\" size=\"8\" maxlenght=\"\" value=\"".date2data ($row->scad_valv)."\" /></td> <td><input name=\"tara_valv\" type=\"text\" size=\"8\" maxlenght=\"\" value=\"".date2data ($row->tara_valv)."\" /></td> <td><input name=\"scad_decenn\" type=\"text\" size=\"8\" maxlenght=\"\" value=\"".date2data ($row->scad_decenn)."\" /></td> </tr><tr bgcolor=\"#FFFFFF\"> <td><input name=\"codiceC\" type=\"text\" size=\"6\" value=\"$codiceC\" /></td> <td colspan=\"2\"><input name=\"ragsocC\" type=\"text\" size=\"10\" value=\"$ragsocC\" /> <input type=\"submit\" value=\"cerca\" /></td> <td colspan=\"4\" align=\"center\"> <input type=\"submit\" name=\"invio\" value=\"$intesta\" /> <input type=\"hidden\" name=\"op\" value=\"$valop\" /> <input type=\"hidden\" name=\"id\" value=\"$row->id\" /> <input type=\"hidden\" name=\"pg\" value=\"$pg\" /> </td></tr><tr><td colspan=\"15\" bgcolor=\"#000000\" height=\"4\"></td>"; $rows = $query->selectAll ($table, array('rag_sociale'=>'ASC'), $pg, 0, $whCond); foreach ($rows as $i=>$row) { $bgcolor = rowCol ($i); $elenco.= " </tr> <tr bgcolor=\"#$bgcolor\"><td nowrap rowspan=\"2\">\n"; if ($az!="ed") $elenco.= "<a href=\"".$_SERVER['PHP_SELF']."?id=".$row->id."&az=ed&pg=$pg&codiceC=".$codiceC."&ragsocC=".$ragsocC."\" title=\"modifica cliente\"><img src=\"images/edit.gif\" border=\"0\" hspace=\"3\" alt=\"modifica cliente\" align=\"absmiddle\" /></a> <a href=\"#\" onClick=\"javascript:confDel($row->id)\" title=\"cancella cliente\"><img src=\"images/delete.gif\" border=\"0\" alt=\"cancella cliente\" align=\"absmiddle\" /></a></td>"; else $elenco.= " "; $elenco.= "<td>".$row->codice."</td><td colspan=\"3\">".$row->rag_sociale."</td><td colspan=\"3\">".$row->indirizzo."</td> <td colspan=\"2\">".$row->localita."</td><td>".$row->telefono."</td><td>".$row->telefono2."</td> </tr><tr bgcolor=\"#$bgcolor\"> <td>".$row->capacita."</td><td>".$row->tipo_serb."</td><td>".date2data ($row->decennale)."</td><td>".$row->sigla."</td> <td>".$row->fabbrica."</td><td>".$row->matricola."</td><td>".$row->tipo_valv."</td><td>".$row->num_valv."</td> <td>".date2data ($row->scad_valv)."</td><td>".date2data ($row->tara_valv)."</td><td>".date2data ($row->scad_decenn)."</td>\n"; } $elenco.= " </tr> <tr><td colspan=\"18\" bgcolor=\"#000000\" height=\"4\"></td></tr> <tr><td colspan=\"18\" align=\"center\">". pager ($pg) ."</td></tr>"; echo "$testa <script type=\"text/javascript\" language=\"JavaScript\"> function confDel(id) { if (confirm('Vuoi cancellare veramente questo cliente? Premi OK per confermare.')) document.location='".$_SERVER['PHP_SELF']."?id='+ id +'&az=canc&pg=$pg'; } </script> <h2 align=\"center\">$ptitolo</h2> <form name=\"form1\" method=\"post\" action=\"".$_SERVER['PHP_SELF']."\" > <table align=\"center\"> $elenco </table> $barra $coda"; ?>
Save File
Cancel