/sopralluogo.php

<?php
session_start();
include 'CSS/templateTop.html';

require_once 'login.php';

if(!isset($_SESSION['changeover_IDutente'])){
    header("location: index.php");
}
else 
{
    
include 'barramenu.php';


?>
<SCRIPT LANGUAGE="JavaScript">
function radioChecked(radioObj) {
        if(!radioObj)
                return alert("Non hai indicato l'esito!");
        var radioLength = radioObj.length;
        if(radioLength == undefined)
                if(radioObj.checked)
                        return document.form1.submit();
                else
                        return alert("Non hai indicato l'esito!");;
        for(var i = 0; i < radioLength; i++) {
                if(radioObj[i].checked) {
                        return document.form1.submit();
                }
        }
        return alert("Non hai indicato l'esito!");;
}

</SCRIPT>
<?php

$ID = $_POST['ID'];

$presarete = (isset($_POST['presarete'])) ? $_POST['presarete'] :  "assente";
$corrente = (isset($_POST['corrente'])) ? $_POST['corrente'] :  "assente";

$notasop = (isset($_POST['notasop'])) ? $_POST['notasop'] : '';
$esito = (isset($_POST['esito'])) ? $_POST['esito'] : '';


//recupera i dati dell'intervento

$query = "SELECT * FROM interventi WHERE ID = $ID ";
    $result = mysql_query($query);
    if (!$result) die ("Database access failed: " . mysql_error());  
            $row = mysql_fetch_row($result);
            $tipo = $row[1];

            $codbene = $row[2];
        if($tipo=='sost'){            
            $query = "SELECT * FROM pc WHERE ID=$codbene";
            $result2 = mysql_query($query);
            if (!$result2) die ("Database access failed: " . mysql_error());
            $row2 = mysql_fetch_row($result2);
            $ID_bene = $row2[1];
            $modello= $row2[2];
            $monitor = $row2[3];
            $pollici= $row2[4];
        }else{
            $ID_bene = '';
            $modello= '';
            $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];
        
        $npresarete=$row[6];
        $attiva=$row[7];
        
        $n1 = $row[8];
        $n2 = $row[9];
        $n3 = $row[10];
        
        $data = $row[15];
        list($data_a,$data_m,$data_g) = explode("-",$data);
        $time = mktime(0,0,0, $data_m, $data_g, $data_a);
        $data= date ('d-m-Y',$time);
        
        $sopralluogo = $row[11];
 
if($n1!=0)
{
    $query = "SELECT nota FROM note WHERE ID=$n1";
        $result2 = mysql_query($query);
        if (!$result2) die ("Database access failed: " . mysql_error());
        $row2 = mysql_fetch_row($result2);
        $nota1 = $row2[0];
}else{
    $nota1="";
}
if($n2!=0)
{
    $query = "SELECT nota FROM note WHERE ID=$n2";
        $result2 = mysql_query($query);
        if (!$result2) die ("Database access failed: " . mysql_error());
        $row2 = mysql_fetch_row($result2);
        $nota2 = $row2[0];   
}else{
    $nota2="";
}
if($n3!=0)
{
    $query = "SELECT nota FROM note WHERE ID=$n3";
        $result2 = mysql_query($query);
        if (!$result2) die ("Database access failed: " . mysql_error());
        $row2 = mysql_fetch_row($result2);
        $nota3 = $row2[0]; 
}else{
    $nota3="";
}

//<<<<<<

if(isset($_POST['esito']))     ///salvataggio dati
{
$nota1 = (isset($_POST['nota1'])) ? $_POST['nota1'] :  '';
$nota2 = (isset($_POST['nota2'])) ? $_POST['nota2'] :  '';
$nota3 = (isset($_POST['nota3'])) ? $_POST['nota3'] :  '';

$npresarete = (isset($_POST['npresarete'])) ? $_POST['npresarete'] :  '';
$attiva = (isset($_POST['attiva'])) ? $_POST['attiva'] :  '';

    
if ($n1!=0){
    if(!empty($nota1)){
        $query = "UPDATE note SET nota=\"$nota1\" WHERE ID=\"$n1\"";
        $result = mysql_query($query);
        if (!$result) die ("Database access failed: " . mysql_error());
    }
    else{
        $n1=0;
    }
}
else{
    if(!empty($nota1))
    {
        $query = "INSERT INTO note(nota ) VALUES (\"$nota1\")";
        $result = mysql_query($query);
        if (!$result) die ("Database access failed: " . mysql_error());
        $n1= mysql_insert_id(); 
    }
}

if ($n2!=0){
    if(!empty($nota2)){
        $query = "UPDATE note SET nota=\"$nota2\" WHERE ID=\"$n2\"";
        $result = mysql_query($query);
        if (!$result) die ("Database access failed: " . mysql_error());
    }
    else{
        $n2=0;
    }
}
else{
    if(!empty($nota2))
    {
        $query = "INSERT INTO note(nota ) VALUES (\"$nota2\")";
        $result = mysql_query($query);
        if (!$result) die ("Database access failed: " . mysql_error());
        $n2= mysql_insert_id(); 
    }
}

if ($n3!=0){
    if(!empty($nota3)){
        $query = "UPDATE note SET nota=\"$nota3\" WHERE ID=\"$n3\"";
        $result = mysql_query($query);
        if (!$result) die ("Database access failed: " . mysql_error());
    }
    else{
        $n3=0;
    }
}
else{
    if(!empty($nota3))
    {
        $query = "INSERT INTO note(nota ) VALUES (\"$nota3\")";
        $result = mysql_query($query);
        if (!$result) die ("Database access failed: " . mysql_error());
        $n3= mysql_insert_id(); 
    }
}

if(!empty($notasop))
    {
        $query = "INSERT INTO note(nota ) VALUES (\"$notasop\")";
        $result = mysql_query($query);
        if (!$result) die ("Database access failed: " . mysql_error());
        $nsop= mysql_insert_id(); 
    }
    else{
        $nsop=0;
    }

    $operatore = $_SESSION['changeover_IDutente'];
    
$query = "INSERT INTO sopralluogo (presarete,corrente,nota,operatore ) VALUES (\"$presarete\",\"$corrente\",\"$nsop\", \"$operatore\")";
        $result = mysql_query($query);
        if (!$result) die ("Database access failed: " . mysql_error());
        $sopralluogo= mysql_insert_id(); 

    
    $query = "UPDATE interventi SET sopralluogo= \"$sopralluogo\", nota1=\"$n1\", nota2=\"$n2\", nota3=\"$n3\", STATO2=\"$esito\", presadirete=\"$npresarete\",attiva=\"$attiva\" WHERE ID= \"$ID\"";
    $result = mysql_query($query);
    if (!$result) die ("Database access failed: " . mysql_error());
    echo"SOPRALLUOGO INSERITO CON SUCCESSO!<br><br>";
    
}
   
//visualizza il form >>>>>
echo <<<_END
<font class="blue">PC</font>&nbsp &nbsp &nbsp &nbsp<font class="rosso">ID: $ID </font>
<table class="ret">
<tr>
<td>
_END;
if($tipo=='sost'){
    echo "SOSTITUZIONE:<br>$ID_bene     $modello      $monitor      $pollici <br>";
}
if($tipo=='nuovo'){
    echo "NUOVO:<br>";
}
echo <<<_END
$cognome_nome_utente        $telefono <br>
$ubicazione      $sc        $ufficio  <br>
_END;

echo <<<_END
<form action="sopralluogo.php" method="post" name="form1"><pre>
    <input type="hidden" name="ID" value="$ID">
    <input type="hidden" name="tipo" value="$tipo">
Note:
Programmi particolari da installare<br>
<textarea rows="2" cols="50" name="nota1">$nota1</textarea><br>
Esigenze particolari di orario per l'installazione<br>
<textarea rows="2" cols="50" name="nota2">$nota2</textarea><br>
note<br>
<textarea rows="2" cols="50" name="nota3">$nota3</textarea><br>
<br><br>
</td>
</tr>
</table>
<p class="giallo">SOPRALLUOGO</p>

<table>
<tr>
<td id="retg">
_END;
if($tipo=='nuovo'){
echo <<<_END
<table>
<tr>
<td>
<input 
_END;
if ($presarete == "presente")
    echo "checked ";
echo <<<_END
type="checkbox" name="presarete" value="presente"/>
Presa di rete &nbsp <input type="text" name="npresarete" value="$npresarete" size="10"/>
<select name="attiva" size="1">
<option  
_END;
if ($attiva == "")
    echo "selected=\"selected\" ";
echo <<<_END
value=""></option>
<option 
_END;
if ($attiva == "da attivare")
    echo "selected=\"selected\" ";
echo <<<_END
value="da attivare">da attivare</option>
<option 
_END;
if ($attiva == "attiva")
    echo "selected=\"selected\" ";
echo <<<_END
value="attiva">attiva</option>
</select>
</td>
</tr>
<tr>
<td align="left">
<input 
_END;
if ($corrente == "presente")
    echo "checked ";
echo <<<_END
type="checkbox" name="corrente" value="presente"/> corrente
</td>
</tr>
</table>
<br>
_END;
}
echo <<<_END
<br>Note:<br>
<textarea rows="4" cols="50" name="notasop">$notasop</textarea><br>
<br>

<table>
<tr>
<td><p class="giallo">ESITO:</p></td>
<td>&nbsp &nbsp<input 
_END;
if ($esito == 'S')
    echo "checked ";
echo <<<_END
type="radio" id="pos" name="esito" value="S" /></td>
<td><label for="pos"><p class="giallop">POSITIVO</p></label></td>
<td>&nbsp &nbsp</td>
<td><input 
_END;
if ($esito == 'N')
    echo "checked ";
echo <<<_END
type="radio" id="neg" name="esito" value="N" /></td>
<td><label for="neg"><p class="giallop">NEGATIVO</p></label></td>
</tr>
</table>
<br>
<input type="button" name="salva" value="SALVA" onclick="radioChecked(document.form1.esito)"/></td>
</pre></form>
</td>
</tr>
</table>
_END;

    
//>>>>>
}

include 'CSS/templateEnd.html';
?>