← Back
Editing: clienti_ric.php
<?php require_once ("funct.php"); require_once ("conn.php"); $ptitolo = "Archivio interventi"; require_once ("testacoda.php"); $query = new doQuery (); $codiceC = $_REQUEST['codiceC']; $ragsocC = $_REQUEST['ragsocC']; if ($id) { $sqlI = "SELECT `rag_sociale`, `interventi`.`id`, `interventi`.`data`, `interventi`.`scad_valv`, `interventi`.`num_valv`, `interventi`.`tipo_valv`, `motivo` FROM `clienti`, `interventi` WHERE `id_cliente` = $id AND `clienti`.`id` = `id_cliente` ORDER BY `data`"; $rowsI = $query->freequery ($sqlI, 0); $ptitolo = "Archivio interventi<br />".$rowsI[0]->rag_sociale; $elenco.= "<tr><td></td><td><b>Data</b></td><td><b>Valvola n. tipo scade</b></td></tr>"; foreach ($rowsI AS $rowI) $elenco.= "<tr><td nowrap><a href=\"scheda-pdf.php?id=".$id."&idInt=".$rowI->id."\" title=\"stampa intervento\"><img src=\"images/doc.gif\" border=\"0\" hspace=\"3\" alt=\"stampa intervento\" align=\"absmiddle\" /></a> <a href=\"ins_intervento.php?idCli=".$id."&id=".$rowI->id."&az=ed\" title=\"vedi intervento\"><img src=\"images/edit.gif\" border=\"0\" hspace=\"3\" alt=\"vedi intervento\" align=\"absmiddle\" /></a></td> <td>".date2data ($rowI->data)." - </td><td>".$rowI->num_valv." ".$rowI->tipo_valv." ".date2data ($rowI->scad_valv)."</td></tr>"; $sqlC = "UPDATE `clienti` SET `scad_valv` = '".data2date($_POST['scad_valv'])."', `num_valv` = '".$_POST['num_valv']."', `tipo_valv` = '".$_POST['tipo_valv']."', `tara_valv`= '".data2date($_POST['data_tara'])."' WHERE `id` = '".$_POST['id_cliente']."'"; } else { $form = "<div align=\"center\"><form method=\"post\" action=\"\"> Codice <input name=\"codiceC\" type=\"text\" size=\"6\" value=\"$codiceC\" /> - Rag. Soc. <input name=\"ragsocC\" type=\"text\" size=\"10\" value=\"$ragsocC\" /> <input type=\"submit\" value=\"cerca\" /> </form></div>"; if ($codiceC || $ragsocC) { if ($codiceC) $whCond.= " AND `codice` LIKE '$codiceC%'"; if ($ragsocC) $whCond.= " AND `rag_sociale` LIKE '$ragsocC%'"; } else $whCond.= " AND 0"; $sqlI = "SELECT `id`,`rag_sociale`, `indirizzo`, `localita`, `telefono` FROM`clienti` WHERE 1 $whCond ORDER BY `rag_sociale`"; $rowsI = $query->freequery ($sqlI, 0); foreach ($rowsI AS $rowI) $elenco.= "<tr><td nowrap><a href=\"scheda-pdf.php?id=".$rowI->id."\" title=\"stampa scheda intervento\"><img src=\"images/doc.gif\" border=\"0\" alt=\"stampa scheda\" align=\"absmiddle\" /></a> <a href=\"ins_intervento.php?idCli=".$rowI->id."\" title=\"inserisci dati intervento\"><img src=\"images/edit.gif\" border=\"0\" hspace=\"5\" alt=\"inserisci dati intervento\" align=\"absmiddle\" /></a> <a href=\"".$_SERVER['php_self']."?id=".$rowI->id."\" title=\"vedi tutti gli interventi\"><img src=\"images/details_cry.gif\" border=\"0\" alt=\"stampa scheda\" align=\"absmiddle\" /></a> </td><td> ".$rowI->rag_sociale." </td><td> ".$rowI->indirizzo." </td><td> ".$rowI->localita."</td> <td> ".$rowI->telefono."</td></tr>"; } ?> <?php echo $testa."<h2 align=\"center\">".$ptitolo."</h2>".$barra.$form; ?> <table cellspacing="2" cellpadding="2" align="center"> <?php echo $elenco; ?> </table> <?php echo $barra.$coda; ?>
Save File
Cancel