/INVA.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';





$query = "SELECT * FROM nchange ORDER BY nchange";

$result = mysql_query($query);

if (!$result) die ("Database access failed: " . mysql_error());



$righe = mysql_num_rows($result);           

for ($j = 0 ; $j < $righe ; ++$j)

    {

        $row = mysql_fetch_row($result);

        $ID = $row[0];

        $nchange = $row[1];

        $nomefile = $row[2];

        $data = $row[3];

        

        echo <<<_END

CHANGE OVER $nchange <a href="dati\\$nomefile" target="_blank">scarica il file excel</a>      data: $data

<br>

_END;

    }

echo <<<_END

<form action="creafile.php" method="post" name="form1">

<input type="hidden" name="numero" value="$j">

<input type="submit" name="salva" value="CREA NUOVO FILE"/></td>

    

    

_END;







$query = "SELECT * FROM interventi WHERE STATO1='A' && inva='0' ORDER BY datarichiesta";

$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 bgcolor="#000000" bordercolor= "#000000"></td>

     <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="#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];

        $esito= $row[13];

        

        $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 bordercolor= "#000000" ><input type="checkbox" name="dainviare[]" value="$ID"/></td>

    <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

        </tr>

        </table>

     

    </td>

    <td bordercolor= "#FFCC33" >

_END;



    $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

    </td>

    </tr>

_END;

    }



echo"  </table></form>";









/* 

}  else 

{

    echo "protezione pagina - no diritti di amministrazine";

} 

*/

}



include 'CSS/templateEnd.html';

?>