/cercaxid.php

<?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 &nbsp &nbsp</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 &nbsp &nbsp &nbsp</font>
_END;
if($tipo=='sost')
    echo "<font class=\"blue\">SOSTITUZIONE</font>&nbsp &nbsp &nbsp &nbsp &nbsp &nbsp $datarichiesta";
if($tipo=='nuovo')
    echo"<font class=\"blue\">NUOVO</font>&nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp $datarichiesta";  
if($tipo=='sost'){
echo <<<_END
            <table>
            <tr>
                <td>$ID_bene</td>
                <td>$marcamodello</td>
                <td>&nbsp &nbsp</td>
                <td>$ID_monitor</td>
                <td>$pollici</td>
            </tr>
            </table>
_END;
}
echo <<<_END
            <table>
            <tr>
                <td>$cognome_nome_utente &nbsp &nbsp </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';
?>