/modsopralluogo.php
PHP | 369 lines | 326 code | 40 blank | 3 comment | 41 complexity | 39b2693ff495764cab6ce5dcaaa03cc7 MD5 | raw file
- <?php
- session_start();
- include 'CSS/templateTop.html';
- require_once 'login.php';
- if(!isset($_SESSION['changeover_IDutente'])){
- header("location: index.php");
- }
- else
- {
-
- include 'barramenu.php';
- $ID = $_POST['ID'];
- //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];
- $esito = $row[13];
-
- 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="";
- }
- //recupra dati del sopralluogo
- $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='';
- }
- if(isset($_POST['salva'])) ///salvataggio dati
- {
-
- $presarete = (isset($_POST['presarete'])) ? $_POST['presarete'] : "assente";
- $corrente = (isset($_POST['corrente'])) ? $_POST['corrente'] : "assente";
- $notasop = $_POST['notasop'];
- $notasop = (isset($_POST['notasop'])) ? $_POST['notasop'] : '';
- $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'] : '';
- $esito = $_POST['esito'];
-
- 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 ($nsop!=0){
- if(!empty($notasop)){
- $query = "UPDATE note SET nota=\"$notasop\" WHERE ID=\"$nsop\"";
- $result = mysql_query($query);
- if (!$result) die ("Database access failed: " . mysql_error());
- }else{
- $nsop=0;
- }
- }
- else{
- 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();
- }
- }
- $operatore = $_SESSION['changeover_IDutente'];
-
- $query = "UPDATE sopralluogo SET presarete = \"$presarete\",corrente = \"$corrente\" ,nota= \"$nsop\" ,operatore =\"$operatore\" WHERE ID=\"$sopralluogo\"";
- $result = mysql_query($query);
- if (!$result) die ("Database access failed: " . mysql_error());
- $query = "UPDATE interventi SET STATO2=\"$esito\", nota1=\"$n1\", nota2=\"$n2\", nota3=\"$n3\", presadirete=\"$npresarete\", attiva=\"$attiva\" WHERE ID=\"$ID\"";
- $result = mysql_query($query);
- if (!$result) die ("Database access failed: " . mysql_error());
- echo"SOPRALLUOGO MODIFICATO CON SUCCESSO!";
- }
-
- //visualizza il form >>>>>
- echo <<<_END
- <p class="blue">PC</p>
- <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="modsopralluogo.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   <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>   <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>   </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="submit" name="salva" value="SALVA"/></td>
- </pre></form>
- </td>
- </tr>
- </table>
- _END;
-
- //>>>>>
- }
- include 'CSS/templateEnd.html';
- ?>