/
ce.esiti_commissione_paesaggio.php
111 lines (97 loc) · 3.97 KB
/
ce.esiti_commissione_paesaggio.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
<?
include_once("login.php");
include "./lib/tabella_h.class.php";
include_once "./lib/tabella_v.class.php";
$active_form="ce.esiti_commissione.php";
$tabpath="ce";
$file_config="$tabpath/esiti_commissione";
$modo=(isset($_REQUEST["mode"]))?($_REQUEST["mode"]):('view');
$idcomm=$_REQUEST["pratica"];
//print_r($_REQUEST);
$tornaacasa="
<script language=javascript>
parent.location='index.php';
</script>";
if ($modo=="edit" || $modo=="view"){
$db = new sql_db(DB_HOST,DB_USER,DB_PWD,DB_NAME, false);
if(!$db->db_connect_id) die( "Impossibile connettersi al database");
$sql="SELECT numero FROM pe.pareri left join pe.avvioproc on pareri.pratica=avvioproc.pratica WHERE pareri.id=".$_REQUEST["id_parere"];
$db->sql_query($sql);
print_debug($sql);
$num=$db->sql_fetchfield("numero");
}
?>
<html>
<head>
<title>Pareri della commissione - <?=$titolo?></title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge" />
<SCRIPT language="javascript" src="js/LoadLibs.js" type="text/javascript"></SCRIPT>
<SCRIPT>
function link(id,prat){
loc="ce.esiti_commissione_paesaggio.php?mode=view&pratica=<?=$idcomm?>&id_pratica="+prat+"&id_parere="+id+"&comm_paesaggio=1";
//alert(loc);
window.location=loc;
}
</SCRIPT>
</head>
<body>
<?
if ($modo=="edit" or $modo=="new"){
include "./inc/inc.page_header.php";
print("<H2 class=\"blueBanner\">Parere</H2>");
$idpratica=$_REQUEST["id_pratica"];
$id_parere=$_REQUEST["id_parere"];
$tabella=new Tabella_v($file_config,$modo);
$tabella->set_errors($Errors);
if ($modo=="edit") {
$tabella->set_dati("id=$id_parere");
$tabella->set_titolo("Modifica parere della pratica n° $num");
}
else{
$_SESSION["ADD_NEW"]=0;
$tabella->set_titolo("Nuovo parere della pratica n° ".$_REQUEST["numero"]);
}
$tabella->get_titolo();?>
<form name="pareri" method="post" action="praticaweb.php">
<?$tabella->edita();?>
<input name="active_form" type="hidden" value="ce.esiti_commissione_paesaggio.php">
<input name="mode" type="hidden" value="<?=$modo?>">
<input name="id_pratica" type="hidden" value="<?=$idpratica?>">
<input name="comm_paesaggio" type="hidden" value=1>
<input name="id_parere" type="hidden" value="<?=$id_parere?>">
<input name="pratica" type="hidden" value="<?=$idcomm?>">
<input name="tipo" type="hidden" value="<?=$tipo?>">
<input name="id" type="hidden" value="<?=$id_parere?>">
<input name="numero" type="hidden" value=<?=$_POST["numero"]?>>
<input name="azione" type="submit" class="hexfield" tabindex="14" value="Salva" style="margin-top:10">
<?if ($modo=="edit"){?><input name="azione" type="submit" class="hexfield" tabindex="14" value="Elimina" style="margin-top:10" onclick="return confirm('Sei sicuro di voler eliminare il parere?')"><?}?>
<input name="azione" type="submit" class="hexfield" tabindex="14" value="Annulla" style="margin-top:10">
</form>
<?include "./inc/inc.window.php";
}
elseif($modo=="view"){
$idpratica=$_REQUEST["id_pratica"];
$id_parere=$_REQUEST["id_parere"];
$tabella=new Tabella_v($file_config,$modo);
$tabella->set_dati("id=$id_parere");
$tabella->set_titolo("Parere della pratica n° $num",'Modifica',Array("id_pratica"=>$id_pratica,"id_parere"=>$id_parere,"comm_paesaggio"=>"1"));
$tabella->get_titolo();
$tabella->tabella();
}
else {
print("<H2 class=\"blueBanner\">Elenco Pareri Espressi</H2>");
$tabella=new Tabella_h($file_config,'list');
//$tabella->set_tag($idpr);
$tabella->set_dati("ente =(SELECT tipo_comm FROM ce.commissione WHERE id=$idcomm) AND data_rich = (SELECT data_convocazione FROM ce.commissione WHERE id=$idcomm);");
//$titolo="Pratica n° ".$num;
$mod=(($parere==0)?("new"):("edit"));
//$butt_mod=(($parere==0)?("nuovo"):("modifica"));
//$tabella->set_titolo($titolo,"",array("id_pratica"=>$idpr,"numero"=>$num,"mode"=>"$mod","id_parere"=>$parere));
//$tabella->get_titolo();
$tabella->elenco();
//}
}
?>
</body>
</html>