PageRenderTime 53ms CodeModel.GetById 27ms RepoModel.GetById 0ms app.codeStats 0ms

/modsopralluogo.php

https://bitbucket.org/amorello/changeover
PHP | 369 lines | 326 code | 40 blank | 3 comment | 41 complexity | 39b2693ff495764cab6ce5dcaaa03cc7 MD5 | raw file
  1. <?php
  2. session_start();
  3. include 'CSS/templateTop.html';
  4. require_once 'login.php';
  5. if(!isset($_SESSION['changeover_IDutente'])){
  6. header("location: index.php");
  7. }
  8. else
  9. {
  10. include 'barramenu.php';
  11. $ID = $_POST['ID'];
  12. //recupera i dati dell'intervento
  13. $query = "SELECT * FROM interventi WHERE ID = $ID ";
  14. $result = mysql_query($query);
  15. if (!$result) die ("Database access failed: " . mysql_error());
  16. $row = mysql_fetch_row($result);
  17. $tipo = $row[1];
  18. $codbene = $row[2];
  19. if($tipo=='sost'){
  20. $query = "SELECT * FROM pc WHERE ID=$codbene";
  21. $result2 = mysql_query($query);
  22. if (!$result2) die ("Database access failed: " . mysql_error());
  23. $row2 = mysql_fetch_row($result2);
  24. $ID_bene = $row2[1];
  25. $modello= $row2[2];
  26. $monitor = $row2[3];
  27. $pollici= $row2[4];
  28. }else{
  29. $ID_bene = '';
  30. $modello= '';
  31. $monitor = '';
  32. $pollici= '';
  33. }
  34. $collocazione= $row[3];
  35. $query = "SELECT * FROM collocazione WHERE ID=$collocazione";
  36. $result2 = mysql_query($query);
  37. if (!$result2) die ("Database access failed: " . mysql_error());
  38. $row2 = mysql_fetch_row($result2);
  39. $ubicazione = $row2[1];
  40. $sc= $row2[2];
  41. $ufficio = $row2[3];
  42. $query = "SELECT * FROM sc WHERE ID=$sc";
  43. $result2 = mysql_query($query);
  44. if (!$result2) die ("Database access failed: " . mysql_error());
  45. $row2 = mysql_fetch_row($result2);
  46. $sc = $row2[1];
  47. $cognome_nome_utente = $row[4];
  48. $telefono = $row[5];
  49. $npresarete=$row[6];
  50. $attiva=$row[7];
  51. $n1 = $row[8];
  52. $n2 = $row[9];
  53. $n3 = $row[10];
  54. $data = $row[15];
  55. list($data_a,$data_m,$data_g) = explode("-",$data);
  56. $time = mktime(0,0,0, $data_m, $data_g, $data_a);
  57. $data= date ('d-m-Y',$time);
  58. $sopralluogo = $row[11];
  59. $esito = $row[13];
  60. if($n1!=0)
  61. {
  62. $query = "SELECT nota FROM note WHERE ID=$n1";
  63. $result2 = mysql_query($query);
  64. if (!$result2) die ("Database access failed: " . mysql_error());
  65. $row2 = mysql_fetch_row($result2);
  66. $nota1 = $row2[0];
  67. }else{
  68. $nota1="";
  69. }
  70. if($n2!=0)
  71. {
  72. $query = "SELECT nota FROM note WHERE ID=$n2";
  73. $result2 = mysql_query($query);
  74. if (!$result2) die ("Database access failed: " . mysql_error());
  75. $row2 = mysql_fetch_row($result2);
  76. $nota2 = $row2[0];
  77. }else{
  78. $nota2="";
  79. }
  80. if($n3!=0)
  81. {
  82. $query = "SELECT nota FROM note WHERE ID=$n3";
  83. $result2 = mysql_query($query);
  84. if (!$result2) die ("Database access failed: " . mysql_error());
  85. $row2 = mysql_fetch_row($result2);
  86. $nota3 = $row2[0];
  87. }else{
  88. $nota3="";
  89. }
  90. //recupra dati del sopralluogo
  91. $query = "SELECT * FROM sopralluogo WHERE ID=\"$sopralluogo\"";
  92. $result2 = mysql_query($query);
  93. if (!$result2) die ("Database access failed: " . mysql_error());
  94. $row2 = mysql_fetch_row($result2);
  95. $presarete = $row2[1];
  96. $corrente = $row2[2];
  97. $nsop = $row2[3];
  98. if($nsop!=0)
  99. {
  100. $query = "SELECT nota FROM note WHERE ID=\"$nsop\"";
  101. $result2 = mysql_query($query);
  102. if (!$result2) die ("Database access failed: " . mysql_error());
  103. $row2 = mysql_fetch_row($result2);
  104. $notasop = $row2[0];
  105. }
  106. else{
  107. $notasop='';
  108. }
  109. if(isset($_POST['salva'])) ///salvataggio dati
  110. {
  111. $presarete = (isset($_POST['presarete'])) ? $_POST['presarete'] : "assente";
  112. $corrente = (isset($_POST['corrente'])) ? $_POST['corrente'] : "assente";
  113. $notasop = $_POST['notasop'];
  114. $notasop = (isset($_POST['notasop'])) ? $_POST['notasop'] : '';
  115. $nota1 = (isset($_POST['nota1'])) ? $_POST['nota1'] : '';
  116. $nota2 = (isset($_POST['nota2'])) ? $_POST['nota2'] : '';
  117. $nota3 = (isset($_POST['nota3'])) ? $_POST['nota3'] : '';
  118. $npresarete = (isset($_POST['npresarete'])) ? $_POST['npresarete'] : '';
  119. $attiva = (isset($_POST['attiva'])) ? $_POST['attiva'] : '';
  120. $esito = $_POST['esito'];
  121. if ($n1!=0){
  122. if(!empty($nota1)){
  123. $query = "UPDATE note SET nota=\"$nota1\" WHERE ID=\"$n1\"";
  124. $result = mysql_query($query);
  125. if (!$result) die ("Database access failed: " . mysql_error());
  126. }
  127. else{
  128. $n1=0;
  129. }
  130. }
  131. else{
  132. if(!empty($nota1))
  133. {
  134. $query = "INSERT INTO note(nota ) VALUES (\"$nota1\")";
  135. $result = mysql_query($query);
  136. if (!$result) die ("Database access failed: " . mysql_error());
  137. $n1= mysql_insert_id();
  138. }
  139. }
  140. if ($n2!=0){
  141. if(!empty($nota2)){
  142. $query = "UPDATE note SET nota=\"$nota2\" WHERE ID=\"$n2\"";
  143. $result = mysql_query($query);
  144. if (!$result) die ("Database access failed: " . mysql_error());
  145. }
  146. else{
  147. $n2=0;
  148. }
  149. }
  150. else{
  151. if(!empty($nota2))
  152. {
  153. $query = "INSERT INTO note(nota ) VALUES (\"$nota2\")";
  154. $result = mysql_query($query);
  155. if (!$result) die ("Database access failed: " . mysql_error());
  156. $n2= mysql_insert_id();
  157. }
  158. }
  159. if ($n3!=0){
  160. if(!empty($nota3)){
  161. $query = "UPDATE note SET nota=\"$nota3\" WHERE ID=\"$n3\"";
  162. $result = mysql_query($query);
  163. if (!$result) die ("Database access failed: " . mysql_error());
  164. }
  165. else{
  166. $n3=0;
  167. }
  168. }
  169. else{
  170. if(!empty($nota3))
  171. {
  172. $query = "INSERT INTO note(nota ) VALUES (\"$nota3\")";
  173. $result = mysql_query($query);
  174. if (!$result) die ("Database access failed: " . mysql_error());
  175. $n3= mysql_insert_id();
  176. }
  177. }
  178. if ($nsop!=0){
  179. if(!empty($notasop)){
  180. $query = "UPDATE note SET nota=\"$notasop\" WHERE ID=\"$nsop\"";
  181. $result = mysql_query($query);
  182. if (!$result) die ("Database access failed: " . mysql_error());
  183. }else{
  184. $nsop=0;
  185. }
  186. }
  187. else{
  188. if(!empty($notasop))
  189. {
  190. $query = "INSERT INTO note(nota ) VALUES (\"$notasop\")";
  191. $result = mysql_query($query);
  192. if (!$result) die ("Database access failed: " . mysql_error());
  193. $nsop= mysql_insert_id();
  194. }
  195. }
  196. $operatore = $_SESSION['changeover_IDutente'];
  197. $query = "UPDATE sopralluogo SET presarete = \"$presarete\",corrente = \"$corrente\" ,nota= \"$nsop\" ,operatore =\"$operatore\" WHERE ID=\"$sopralluogo\"";
  198. $result = mysql_query($query);
  199. if (!$result) die ("Database access failed: " . mysql_error());
  200. $query = "UPDATE interventi SET STATO2=\"$esito\", nota1=\"$n1\", nota2=\"$n2\", nota3=\"$n3\", presadirete=\"$npresarete\", attiva=\"$attiva\" WHERE ID=\"$ID\"";
  201. $result = mysql_query($query);
  202. if (!$result) die ("Database access failed: " . mysql_error());
  203. echo"SOPRALLUOGO MODIFICATO CON SUCCESSO!";
  204. }
  205. //visualizza il form >>>>>
  206. echo <<<_END
  207. <p class="blue">PC</p>
  208. <table class="ret">
  209. <tr>
  210. <td>
  211. _END;
  212. if($tipo=='sost'){
  213. echo "SOSTITUZIONE:<br>$ID_bene $modello $monitor $pollici <br>";
  214. }
  215. if($tipo=='nuovo'){
  216. echo "NUOVO:<br>";
  217. }
  218. echo <<<_END
  219. $cognome_nome_utente $telefono <br>
  220. $ubicazione $sc $ufficio <br>
  221. _END;
  222. echo <<<_END
  223. <form action="modsopralluogo.php" method="post" name="form1"><pre>
  224. <input type="hidden" name="ID" value="$ID">
  225. <input type="hidden" name="tipo" value="$tipo">
  226. Note:
  227. Programmi particolari da installare<br>
  228. <textarea rows="2" cols="50" name="nota1">$nota1</textarea><br>
  229. Esigenze particolari di orario per l'installazione<br>
  230. <textarea rows="2" cols="50" name="nota2">$nota2</textarea><br>
  231. note<br>
  232. <textarea rows="2" cols="50" name="nota3">$nota3</textarea><br>
  233. <br><br>
  234. </td>
  235. </tr>
  236. </table>
  237. <p class="giallo">SOPRALLUOGO</p>
  238. <table>
  239. <tr>
  240. <td id="retg">
  241. _END;
  242. if($tipo=='nuovo'){
  243. echo <<<_END
  244. <table>
  245. <tr>
  246. <td>
  247. <input
  248. _END;
  249. if ($presarete == "presente")
  250. echo "checked ";
  251. echo <<<_END
  252. type="checkbox" name="presarete" value="presente"/>
  253. Presa di rete &nbsp <input type="text" name="npresarete" value="$npresarete" size="10"/>
  254. <select name="attiva" size="1">
  255. <option
  256. _END;
  257. if ($attiva == "")
  258. echo "selected=\"selected\" ";
  259. echo <<<_END
  260. value=""></option>
  261. <option
  262. _END;
  263. if ($attiva == "da attivare")
  264. echo "selected=\"selected\" ";
  265. echo <<<_END
  266. value="da attivare">da attivare</option>
  267. <option
  268. _END;
  269. if ($attiva == "attiva")
  270. echo "selected=\"selected\" ";
  271. echo <<<_END
  272. value="attiva">attiva</option>
  273. </select>
  274. </td>
  275. </tr>
  276. <tr>
  277. <td align="left">
  278. <input
  279. _END;
  280. if ($corrente == "presente")
  281. echo "checked ";
  282. echo <<<_END
  283. type="checkbox" name="corrente" value="presente"/> corrente
  284. </td>
  285. </tr>
  286. </table>
  287. <br>
  288. _END;
  289. }
  290. echo <<<_END
  291. <br>Note:<br>
  292. <textarea rows="4" cols="50" name="notasop">$notasop</textarea><br>
  293. <br>
  294. <table>
  295. <tr>
  296. <td><p class="giallo">ESITO:</p></td>
  297. <td>&nbsp &nbsp<input
  298. _END;
  299. if ($esito == 'S')
  300. echo "checked ";
  301. echo <<<_END
  302. type="radio" id="pos" name="esito" value="S" /></td>
  303. <td><label for="pos"><p class="giallop">POSITIVO</p></label></td>
  304. <td>&nbsp &nbsp</td>
  305. <td><input
  306. _END;
  307. if ($esito == 'N')
  308. echo "checked ";
  309. echo <<<_END
  310. type="radio" id="neg" name="esito" value="N" /></td>
  311. <td><label for="neg"><p class="giallop">NEGATIVO</p></label></td>
  312. </tr>
  313. </table>
  314. <br>
  315. <input type="submit" name="salva" value="SALVA"/></td>
  316. </pre></form>
  317. </td>
  318. </tr>
  319. </table>
  320. _END;
  321. //>>>>>
  322. }
  323. include 'CSS/templateEnd.html';
  324. ?>