<? include("connessione.php");


if ($userlog<>"OK"){

		session_start();

		session_destroy();

		session_start();

		header("Location:login.php");

		exit();

}


if($passa=="5"){

	unlink("/web/htdocs/www.encocrema.com/home/img_cantieri/$nome");

	unlink("/web/htdocs/www.encocrema.com/home/img_cantieri/t_$nome");

	$sql_up = "UPDATE cantiere SET ";

  $sql = "SELECT * FROM cantiere where id='$id'";

  $result=mysql_db_query($database,$sql,$db);

	$row=mysql_fetch_assoc($result);

	$nome=$nome."|";

	$foto_dettaglio = str_replace($nome,"",$row["fotografie"]);

	$sql_up.= "fotografie = '$foto_dettaglio' ";

	$sql_up.= "where id='$id' ";

	$result=mysql_db_query($database,$sql_up,$db);

	$passa=1;	

	
}


if($passa=="99"){

	unlink("/web/htdocs/www.encocrema.com/home/img_cantieri/$nome");

	unlink("/web/htdocs/www.encocrema.com/home/img_cantieri/t_$nome");

	$sql_up = "UPDATE cantiere SET ";

	$sql_up.= "foto = '' ";

	$sql_up.= "where id='$id' ";

	$result=mysql_db_query($database,$sql_up,$db);

	$passa=1;	

	
}

if($passa=="3"){

		$sql_delete = "DELETE FROM cantiere WHERE ID='$id'"; 

		$result_delete = mysql_db_query($database, $sql_delete, $db);

}


if($passa=="2"){

	ini_set("memory_limit", "128M");


	if(copy( $fprincipale , "/web/htdocs/www.encocrema.com/home/img_cantieri/$fprincipale_name" )){	


			$new_file_d="cantiere_".mktime().".jpg";			

			$image = "/web/htdocs/www.encocrema.com/home/img_cantieri/$fprincipale_name";

			$newimage = "/web/htdocs/www.encocrema.com/home/img_cantieri/t_$new_file_d";			

			$image_quality = 80;

			$addborder = 1;

			$max_height = 60;

			$max_width = 60;			

			$src_img = ImageCreateFromJpeg($image);

			$orig_x = ImageSX($src_img);

			$orig_y = ImageSY($src_img);

			$new_y = $max_height;

			$new_x = $orig_x/($orig_y/$max_height);  			

			if ($new_x > $max_width) {

				$new_x = $max_width;

				$new_y = $orig_y/($orig_x/$max_width);

			}

			
			$dst_img = ImageCreateTrueColor($new_x,$new_y);

			ImageCopyResampled($dst_img, $src_img, 0, 0, 0, 0, $new_x, $new_y, $orig_x, $orig_y);

			
			if ($addborder == 1) {

				// Add border

				$black = ImageColorAllocate($dst_img, 0, 0, 0);

				ImageSetThickness($dst_img, 1);

				ImageLine($dst_img, 0, 0, $new_x, 0, $black);

				ImageLine($dst_img, 0, 0, 0, $new_y, $black);

				ImageLine($dst_img, $new_x-1, 0, $new_x-1, $new_y, $black);

				ImageLine($dst_img, 0, $new_y-1, $new_x, $new_y-1, $black);

			}

				
			ImageJpeg($dst_img, $newimage, $image_quality);

			ImageDestroy($src_img);

			ImageDestroy($dst_img);


			$newimage = "/web/htdocs/www.encocrema.com/home/img_cantieri/$new_file_d";

			
			$image_quality = 80;

			$addborder = 1;

			$max_height = 400;

			$max_width = 400;

			
			// Main code

			$src_img = ImageCreateFromJpeg($image);

			$orig_x = ImageSX($src_img);

			$orig_y = ImageSY($src_img);

			
			$new_y = $max_height;

			$new_x = $orig_x/($orig_y/$max_height);  

			
			if ($new_x > $max_width) {

				$new_x = $max_width;

				$new_y = $orig_y/($orig_x/$max_width);

			}

			
			$dst_img = ImageCreateTrueColor($new_x,$new_y);

			ImageCopyResampled($dst_img, $src_img, 0, 0, 0, 0, $new_x, $new_y, $orig_x, $orig_y);

			
			if ($addborder == 1) {

				// Add border

				$black = ImageColorAllocate($dst_img, 0, 0, 0);

				ImageSetThickness($dst_img, 1);

				ImageLine($dst_img, 0, 0, $new_x, 0, $black);

				ImageLine($dst_img, 0, 0, 0, $new_y, $black);

				ImageLine($dst_img, $new_x-1, 0, $new_x-1, $new_y, $black);

				ImageLine($dst_img, 0, $new_y-1, $new_x, $new_y-1, $black);

			}

				
			ImageJpeg($dst_img, $newimage, $image_quality);

			ImageDestroy($src_img);

			ImageDestroy($dst_img);


			unlink("/web/htdocs/www.encocrema.com/home/img_cantieri/$fprincipale_name");

			
			$foto_principale=$new_file_d;

	}


	if(copy( $dettagli , "/web/htdocs/www.encocrema.com/home/img_cantieri/$dettagli_name" )){	

			$new_file_d="cantiere_".mktime().".jpg";			

			$image = "/web/htdocs/www.encocrema.com/home/img_cantieri/$dettagli_name";

			$newimage = "/web/htdocs/www.encocrema.com/home/img_cantieri/t_$new_file_d";			

			$image_quality = 80;

			$addborder = 1;

			$max_height = 60;

			$max_width = 60;			

			$src_img = ImageCreateFromJpeg($image);

			$orig_x = ImageSX($src_img);

			$orig_y = ImageSY($src_img);

			$new_y = $max_height;

			$new_x = $orig_x/($orig_y/$max_height);  			

			if ($new_x > $max_width) {

				$new_x = $max_width;

				$new_y = $orig_y/($orig_x/$max_width);

			}

			
			$dst_img = ImageCreateTrueColor($new_x,$new_y);

			ImageCopyResampled($dst_img, $src_img, 0, 0, 0, 0, $new_x, $new_y, $orig_x, $orig_y);

			
			if ($addborder == 1) {

				// Add border

				$black = ImageColorAllocate($dst_img, 0, 0, 0);

				ImageSetThickness($dst_img, 1);

				ImageLine($dst_img, 0, 0, $new_x, 0, $black);

				ImageLine($dst_img, 0, 0, 0, $new_y, $black);

				ImageLine($dst_img, $new_x-1, 0, $new_x-1, $new_y, $black);

				ImageLine($dst_img, 0, $new_y-1, $new_x, $new_y-1, $black);

			}

				
			ImageJpeg($dst_img, $newimage, $image_quality);

			ImageDestroy($src_img);

			ImageDestroy($dst_img);


			$newimage = "/web/htdocs/www.encocrema.com/home/img_cantieri/$new_file_d";

			
			$image_quality = 80;

			$addborder = 1;

			$max_height = 400;

			$max_width = 400;

			
			// Main code

			$src_img = ImageCreateFromJpeg($image);

			$orig_x = ImageSX($src_img);

			$orig_y = ImageSY($src_img);

			
			$new_y = $max_height;

			$new_x = $orig_x/($orig_y/$max_height);  

			
			if ($new_x > $max_width) {

				$new_x = $max_width;

				$new_y = $orig_y/($orig_x/$max_width);

			}

			
			$dst_img = ImageCreateTrueColor($new_x,$new_y);

			ImageCopyResampled($dst_img, $src_img, 0, 0, 0, 0, $new_x, $new_y, $orig_x, $orig_y);

			
			if ($addborder == 1) {

				// Add border

				$black = ImageColorAllocate($dst_img, 0, 0, 0);

				ImageSetThickness($dst_img, 1);

				ImageLine($dst_img, 0, 0, $new_x, 0, $black);

				ImageLine($dst_img, 0, 0, 0, $new_y, $black);

				ImageLine($dst_img, $new_x-1, 0, $new_x-1, $new_y, $black);

				ImageLine($dst_img, 0, $new_y-1, $new_x, $new_y-1, $black);

			}

				
			ImageJpeg($dst_img, $newimage, $image_quality);

			ImageDestroy($src_img);

			ImageDestroy($dst_img);


			unlink("/web/htdocs/www.encocrema.com/home/img_cantieri/$dettagli_name");

			ini_set("memory_limit", "32M");

			
			$foto_dettaglio=$foto_dettaglio.$new_file_d."|";

	}

	
	if($id==""){

		$sql_in = "INSERT INTO cantiere (data) VALUES ('".mktime()."')";

		$result_in = mysql_db_query($database, $sql_in, $db);

		$id=mysql_insert_id($db);	

	}


	$sql_up = "UPDATE cantiere SET ";

	$sql_up.= "nome = '$nome', ";

  $sql_up.= "gd = '$gd', ";

	$sql_up.= "descrizione1 = '$descrizione1', ";

	$sql_up.= "scheda = '$scheda', ";

	$sql_up.= "scheda2 = '$scheda2', ";

	$sql_up.= "descrizione1_eng = '$descrizione1_eng', ";

	$sql_up.= "scheda_eng = '$scheda_eng', ";

	$sql_up.= "scheda2_eng = '$scheda2_eng', ";	

	$sql_up.= "categoria = '$categoria', ";

	$sql_up.= "pubblica = '$pubblica', ";	

	$sql_up.= "datainizio = '$datainizio', ";

	$sql_up.= "datafine = '$datafine', ";

	$sql_up.= "citta = '$citta', ";

	$sql_up.= "collaboratori = '$collaboratori', ";

	$sql_up.= "elenco = '$elenco', ";

	$sql_up.= "tipo = '$tipo', ";

	if($new_file_d<>""){

  		$sql_up.= "fotografie = '$foto_dettaglio', ";

  }
	if($foto_principale<>""){

  		$sql_up.= "foto = '$foto_principale', ";

  }

	$sql_up.= "copertina = '$copertina' ";

	$sql_up.= "WHERE id = '$id'";

	$result = mysql_db_query($database,$sql_up,$db);	

	header("location:cantieri.php?passa=1&id=$id");

}


if($passa=="1"){

	$query = "SELECT * FROM cantiere where id='$id'";

	$result = mysql_db_query($database, $query, $db);

	$row=mysql_fetch_assoc($result);

	
	?>

	<html>

		<head>

			<title>..::: Enco engineering consulting s.r.l. :::..</title>

			<link href="styles.css" rel="stylesheet" type="text/css">

		</head>

		<body onload="runSlideShow()">

		<table width="100%" height="100%" border="0" cellspacing="0" cellpadding="0">

			<tr>

				<td align="center" valign="middle" >

					<table border="0" cellspacing="0" cellpadding="0" width="950" height="600" bgcolor="#2C2E32">				

						<tr>

						  <td valign="top" height="30px"><img src="../foto_home/"></td>

							<td align="right" valign="top" height="30px"><br>	

							<a href="logout.php">Esci >></a><br>

							<a href="menu.php">Menu >></a>

							<br><a href="cantieri.php">Elenco Cantieri >></a>

							</td>

						 </tr>

						 <tr>

							<td colspan="2" height="3px" bgcolor="#535660"></td>

						 </tr>

						<tr>

							<td colspan="2" valign="middle" align="center" height="546px">	

								<p><b>Scheda</b></p>

								<form name="utente" method="post" ENCTYPE="multipart/form-data">

								<table border="0" cellspacing="0" cellpadding="0" width="550">

									<tr>

											<td>Ordinamento: </td>

											<td><input type="text" name="gd" value="" size="3"></td>

									</tr>

									<tr>

											<td>Nome Progetto: </td>

											<td><input type="text" name="nome" value=""  size="100" maxlenght="100"></td>

									</tr>

									<tr>

											<td>Città: </td>

											<td><input type="text" name="citta" value="" size="50" maxlenght="100"></td>

									</tr>																											

									<tr>

											<td>Tipo:</td>

											<td>

													<select name="tipo">

															<option value="1" <? if($row["tipo"]==1) print "selected";?>>Cantiere</option>

															<option value="2" <? if($row["tipo"]==2) print "selected";?>>Progetto</option>

													</select>

											</td>

									</tr>	
                  
									<tr>

											<td>Collaboratori</td>

											<td><textarea name="collaboratori" cols="30" rows="3"></textarea></td>

									</tr>                  				

									<tr>

											<td>Descrizione Breve: (max 250 caratteri)</td>

											<td><textarea name="descrizione1" cols="30" rows="3"></textarea></td>

									</tr>

									<tr>

											<td>Descrizione Breve Inglese: (max 250 caratteri)</td>

											<td><textarea name="descrizione1_eng" cols="30" rows="3"></textarea></td>

									</tr>									

									<tr>

											<td>Scheda:</td>

											<td><textarea name="scheda" cols="30" rows="3"></textarea></td>

									</tr>	

									<tr>

											<td>Scheda Inglese:</td>

											<td><textarea name="scheda_eng" cols="30" rows="3"></textarea></td>

									</tr>										

									<tr>

											<td>Scheda breve: (max 250 caratteri)</td>

											<td><textarea name="scheda2" cols="30" rows="3"></textarea></td>

									</tr>	

									<tr>

											<td>Scheda breve Inglese: (max 250 caratteri)</td>

											<td><textarea name="scheda2_eng" cols="30" rows="3"></textarea></td>

									</tr>																																			

									<tr>

											<td>Categoria:</td>

											<td>

													<select name="categoria">

													<?

													$query_categoria = "SELECT * FROM categoria order by id ";

													$result_categoria = mysql_db_query($database, $query_categoria, $db);

													while($row_categoria=mysql_fetch_assoc($result_categoria)){													

													?>

															<option value="" <? if($row["categoria"]==$row_categoria["id"]) print "selected";?>></option>

															
													<? } ?>																

													</select>

											</td>

									</tr>	

									<tr>

											<td>Prima pagina:</td>

											<td>

													<input type="checkbox" value="1" name="elenco" <? if($row["elenco"]==1) print "checked";?>>

											</td>

									</tr>									

									<tr>

											<td>copertina:</td>

											<td>

													<input type="checkbox" value="1" name="copertina" <? if($row["copertina"]==1) print "checked";?>>

											</td>

									</tr>

									<tr>

											<td>Pubblica:</td>

											<td>

													<input type="checkbox" value="1" name="pubblica" <? if($row["pubblica"]==1) print "checked";?>>

											</td>

									</tr>

									<tr>

											<td>Foto Principale:</td>

											<td>

													<input type="file" name="fprincipale" maxlegnt=150 size=50 class="SezTextForm">
													&nbsp;
													<?
													if($row["foto"]){
														?>
															<img src="../img_cantieri/t_<? print $row["foto"];?>">
															<a href="cantieri.php?nome=<? print $row["foto"];?>&dato=d&id=<? print $row["id"];?>&passa=99" title="Cancella Foto">[X]</a>&nbsp;
														<?
													}
													?>

											</td>

									</tr>


                    <? if($row["id"]>0){?>


                    <tr>

                        <td valign=top>Foto Dettagli</td>

                        <td>

														<input type="file" name="dettagli" maxlegnt=150 size=50 class="SezTextForm">

														<input type="hidden" name="foto_dettaglio" value="<? print $row["fotografie"];?>"><br>

														<?

															if($row["fotografie"]){

																$dettaglio = explode("|",$row["fotografie"]);

																$x=0;

																while($dettaglio[$x]<>""){

																	?>

																	<img src="../img_cantieri/t_<? print $dettaglio[$x];?>"><a href="cantieri.php?nome=<? print $dettaglio[$x];?>&dato=d&id=<? print $row["id"];?>&passa=5" title="Cancella Foto">[X]</a>&nbsp;

																	<?

																	$x++;

																}

															}

														?>

												</td>

                    </tr>	

									<? } ?>																					

									<tr>

											<td colspan="2" align="center"><br>

												<input type="hidden" value="" name="id">

												<input type="hidden" value="2" name="passa">

												<input type="submit" value="** Salva Scheda **">

											</td>

									</tr>																																													

								</table>

								</form>										

						</td>

					 </tr>

					<tr>

						<td colspan="2" height="1px" bgcolor="#ffffff"></td>

					</tr>				 

					<tr>

						<td colspan="2" align="right" valign="top" height="20px">	

						Area Riservata&nbsp;

						</td>

					 </tr>					 					 				 					 			 

				 </table>		

			</td>

		</tr>

	</table>

	</body>

</html>									

	
	<?

exit();

}


$count = mysql_query("SELECT COUNT(id) FROM cantiere");

$res_count = mysql_fetch_row($count);

$tot_records = $res_count[0];

$per_page = 24;		

$tot_pages = ceil($tot_records / $per_page);		

$current_page = (!$_GET['page']) ? 1 : (int)$_GET['page'];

$primo = ($current_page - 1) * $per_page;


$query = "SELECT * FROM cantiere ";

$query.= "order by id DESC LIMIT $primo, $per_page";


$result = mysql_db_query($database, $query, $db);


?>


<html>

	<head>

		<title>..::: Enco engineering consulting s.r.l. :::..</title>

		<link href="styles.css" rel="stylesheet" type="text/css">

	</head>

	<body onload="runSlideShow()">

	<table width="100%" height="100%" border="0" cellspacing="0" cellpadding="0">

		<tr>

			<td align="center" valign="middle" >

				<table border="0" cellspacing="0" cellpadding="0" width="950" height="600" bgcolor="#3A3C43">				

					<tr>

					  <td valign="top" height="30px"><img src="../foto_home/"></td>

						<td align="right" valign="top" height="30px"><br>	

						<a href="logout.php">Esci >></a><br>

						<a href="menu.php">Menu >></a>

						</td>

					 </tr>

					 <tr>

						<td colspan="2" height="3px" bgcolor="#535660"></td>

					 </tr>

					<tr>

						<td colspan="2" valign="middle" align="center" height="546px">

							<p><b>Elenco Cantieri</b></p>

							
							<table border="0" cellspacing="3" cellpadding="3" width="500">

								<tr>

								  <td colspan="4" align="right"><a href="cantieri.php?passa=1">Nuova Scheda >></a></td>

								</tr>									

								<tr>

								  <td bgcolor="#330099" width="20">&nbsp;<b>ID</b></td>

								  <td bgcolor="#330099"><b>NOME</b></td>

								  <td bgcolor="#330099" width="60"><b>TIPO</b></td>

								  <td bgcolor="#330099" width="40" align="center"><b>Opz</b></td>

								  <td bgcolor="#330099" width="16"><b>Pub</b></td>

								  
								</tr>									

							  <? while($row=mysql_fetch_assoc($result)){ ?>		

								<tr>

								  <td>&nbsp;</td>

								  <td></td>

								  <td><? 
										// print $row["cantiere"]."<br>";	
										if($row["tipo"]==2){ print "Progetto"; }
										 if($row["tipo"]==1){ print "Cantiere";} ?></td>

									<td align="center">

										<a href="cantieri.php?passa=1&id="><img src="immagini/edit.gif" title="Modifica" border="0"></a>&nbsp;

									  <a href="cantieri.php?passa=3&id="><img src="immagini/delete.gif" title="Cancella" border="0"></a>

									</td>	

									<td align="center">

									<? if($row["pubblica"]==1) print "<img src=\"immagini/statusCheck_28x28.gif\" width=\"16\">";?>

									</td>

								</tr>																			

								<? } 									

								  if ($r=="") $r=1;

									$p=500;

									$paginazione="[";

									if( $tot_pages<>"0" ){	

										for( $i=$r;$i<=$tot_pages;$i++ ){

											$r=$i;

											if($i<$p){		

												if( $i==$current_page )

													$paginazione.=($i<10?"0".$i:$i)." ";

												else

													$paginazione.="<a href=\"?tipo=$tipo&categoria=$scategoria&page=".$i."&incr=".$i."\" title=\"Vai alla pagina ".$i."\">".($i<10?"0".$i:$i)."</a> ";

												if( $i%30==0 )

													$paginazione.="";

											}

										}

										$paginazione.="]";

									}								

								
								?>	

								<tr>

								  <td colspan="4" align="right"> su </td>

								</tr>																																																																							

							</table>	

					
						</td>

					 </tr>

					<tr>

						<td colspan="2" height="1px" bgcolor="#ffffff"></td>

					</tr>				 

					<tr>

						<td colspan="2" align="right" valign="top" height="20px">	

						Area Riservata&nbsp;

						</td>

					 </tr>					 					 				 					 			 

				 </table>		

			</td>

		</tr>

	</table>

	</body>

</html>					 		

<? mysql_close(); ?>