/cercaxid.php
PHP | 326 lines | 282 code | 31 blank | 13 comment | 28 complexity | 474113180e9355d800e761c1bcb65a77 MD5 | raw file
- <?php
- session_start();
- include 'CSS/templateTop.html';
- require_once 'login.php';
- if(!isset($_SESSION['changeover_IDutente'])){
- header("location: index.php");
- }
- else
- {
- /*
- /* per far accedere alla pagina solo un amministratore
- if($_SESSION['nonconf_DBA']=='Y')
- {
- */
- include 'barramenu.php';
- echo <<<_END
- CERCA:<br>
- <form action="cercaxid.php" method="post"><pre><br>
- Per ID:<input type="text" name="ID"/><br>
- <input type="submit" name="cerca" value="CERCA" />
- </pre></form>
- _END;
- if(isset($_POST['cerca'])){
- if(isset($_POST['ID'])){
- $temp= $_POST['ID'];
- $condizione="ID= $temp";
- }
- //cerca e restituisce la linea corrispondente
- $query = "SELECT * FROM interventi WHERE $condizione";
- $result = mysql_query($query);
- if (!$result) die ("Database access failed: " . mysql_error());
- echo <<<_END
- <table border="5" bordercolor= "#6FD1D2" rules="all" cellspacing="5" width="900" >
- <tr bgcolor="#6FD1D2" bordercolor= "#6FD1D2" >
- <td width="70%">
- <table align="left">
- <tr>
- <td align="left">
- <table>
- <tr>
- <td>PC</td>
- </tr>
- <tr>
- <td>Utente di riferimento    </td>
- </tr>
- <tr>
- <td>Collocazione</td>
- </tr>
- </table>
- </td>
- <td></td>
- <td></td>
- </tr>
- </table>
- </td>
- <td bgcolor="#FF0000" bordercolor= "#FF0000" >
- STATO
- </td>
- <td bgcolor="#FFCC33" bordercolor= "#FFCC33" >
- SOPRALLUOGO
- </td>
- </tr>
-
- _END;
- $righe = mysql_num_rows($result);
- for ($j = 0 ; $j < $righe ; ++$j)
- {
- $row = mysql_fetch_row($result);
- $ID = $row[0];
- $tipo = $row[1];
- if($tipo=='sost'){
- $bene = $row[2];
-
- $query = "SELECT * FROM pc WHERE ID=$bene";
- $result2 = mysql_query($query);
- if (!$result2) die ("Database access failed: " . mysql_error());
- $row2 = mysql_fetch_row($result2);
- $ID_bene = $row2[1];
- $marcamodello= $row2[2];
- $ID_monitor = $row2[3];
- $pollici= $row2[4];
- }else{
- $bene = '';
- $ID_bene = '';
- $marcamodello= '';
- $ID_monitor = '';
- $pollici= '';
- }
-
- $collocazione= $row[3];
-
- $query = "SELECT * FROM collocazione WHERE ID=$collocazione";
- $result2 = mysql_query($query);
- if (!$result2) die ("Database access failed: " . mysql_error());
- $row2 = mysql_fetch_row($result2);
- $ubicazione = $row2[1];
- $sc= $row2[2];
- $ufficio = $row2[3];
-
- $query = "SELECT * FROM sc WHERE ID=$sc";
- $result2 = mysql_query($query);
- if (!$result2) die ("Database access failed: " . mysql_error());
- $row2 = mysql_fetch_row($result2);
- $sc = $row2[1];
-
- $cognome_nome_utente = $row[4];
- $telefono = $row[5];
- $n1 = $row[8];
- $n2 = $row[9];
- $n3 = $row[10];
-
- $presadirete=$row[6];
- $attiva=$row[7];
-
- $sopralluogo = $row[11];
- $stato= $row[12];
- $esito= $row[13];
- $statol= '';
- switch ($stato) {
- case "R" :
- $statol= 'RICHIESTO';
- break;
- case "A" :
- $statol= 'APPROVATO';
- break;
- case "S" :
- $statol= 'SOSPESO';
- break;
- case "E" :
- $statol= 'EFFETTUATO';
- break;
- default :
- $statol= '';
- break;}
-
-
- $datarichiesta = $row[15];
- list($data_a,$data_m,$data_g) = explode("-",$datarichiesta);
- $time = mktime(0,0,0, $data_m, $data_g, $data_a);
- $datarichiesta= date ('d-m-Y',$time);
-
- echo <<<_END
- <tr>
- <td>
- <table align="left">
- <tr>
- <td align="left">
- <font class="rosso">$ID      </font>
- _END;
- if($tipo=='sost')
- echo "<font class=\"blue\">SOSTITUZIONE</font>            $datarichiesta";
- if($tipo=='nuovo')
- echo"<font class=\"blue\">NUOVO</font>                                  $datarichiesta";
- if($tipo=='sost'){
- echo <<<_END
- <table>
- <tr>
- <td>$ID_bene</td>
- <td>$marcamodello</td>
- <td>   </td>
- <td>$ID_monitor</td>
- <td>$pollici</td>
- </tr>
- </table>
- _END;
- }
- echo <<<_END
- <table>
- <tr>
- <td>$cognome_nome_utente     </td>
- <td>$telefono</td>
- </tr>
- </table>
-
- <table>
- <tr>
- <td>$ubicazione</td>
- <td>$sc</td>
- <td>$ufficio</td>
- </tr>
- </table>
- _END;
- if($n1!=0 || $n2!=0 ||$n3!=0)
- {
- echo <<<_END
- Note:
- <table>
- _END;
- if($n1!=0)
- {
- $query = "SELECT * FROM note WHERE ID=$n1";
- $result2 = mysql_query($query);
- if (!$result2) die ("Database access failed: " . mysql_error());
- $row2 = mysql_fetch_row($result2);
- $nota1 = $row2[1];
- echo <<<_END
- <tr>
- <td>Programmi:</td>
- <td>$nota1</td>
- </tr>
- _END;
- }
- if($n2!=0)
- {
- $query = "SELECT * FROM note WHERE ID=$n2";
- $result2 = mysql_query($query);
- if (!$result2) die ("Database access failed: " . mysql_error());
- $row2 = mysql_fetch_row($result2);
- $nota2 = $row2[1];
- echo <<<_END
- <tr>
- <td>Orario:</td>
- <td>$nota2</td>
- </tr>
- _END;
- }
- if($n3!=0)
- {
- $query = "SELECT * FROM note WHERE ID=$n3";
- $result2 = mysql_query($query);
- if (!$result2) die ("Database access failed: " . mysql_error());
- $row2 = mysql_fetch_row($result2);
- $nota3 = $row2[1];
- echo <<<_END
- <tr>
- <td>Varie:</td>
- <td>$nota3</td>
- </tr>
- _END;
- }
- echo <<<_END
- </table>
- _END;
- }
- echo <<<_END
- <form action="modifica.php" method="post"><pre><input type="hidden" name="ID" value="$ID" ><input type="submit" name="modifica" value="MODIFICA" /></td>
- </pre></form>
- </tr>
- </table>
-
- </td>
- <td bordercolor= "#FF0000" >
- <u><a title="$statol"> $stato</a></u>
- </td>
- <td bordercolor= "#FFCC33" >
- _END;
- if ($sopralluogo==0){
- echo <<<_END
- <form action="sopralluogo.php" method="post"><pre>
- <input type="hidden" name="ID" value="$ID">
- <input type="submit" name="sopralluogo" value="INSERISCI SOPRALLUOGO" />
- </pre></form>
- _END;
- }else{
- $query = "SELECT * FROM sopralluogo WHERE ID=\"$sopralluogo\"";
- $result2 = mysql_query($query);
- if (!$result2) die ("Database access failed: " . mysql_error());
- $row2 = mysql_fetch_row($result2);
- $presarete = $row2[1];
- $corrente = $row2[2];
- $nsop = $row2[3];
-
- if($nsop!=0)
- {
- $query = "SELECT nota FROM note WHERE ID=\"$nsop\"";
- $result2 = mysql_query($query);
- if (!$result2) die ("Database access failed: " . mysql_error());
- $row2 = mysql_fetch_row($result2);
- $notasop = $row2[0];
- }
- else{
- $notasop=' ';
- }
- echo <<<_END
- corrente: $corrente
- <br>
- presarete: $presarete $presadirete $attiva
- <br>
- $notasop
- <br>esito:
- _END;
- if($esito=='S')
- echo"POSITIVO";
- if($esito=='N')
- echo"NEGATIVO";
- echo <<<_END
- <form action="modsopralluogo.php" method="post"><pre>
- <input type="hidden" name="ID" value="$ID">
- <input type="submit" name="modifica" value="MODIFICA" />
- </pre></form>
- _END;
-
- }
- echo <<<_END
- </td>
- </tr>
- _END;
- }
- echo" </table>";
- }
- /*
- } else
- {
- echo "protezione pagina - no diritti di amministrazine";
- }
- */
- }
- include 'CSS/templateEnd.html';
- ?>