| [2] | 1 | <?php
|
|---|
| 2 | /************************************************************************/
|
|---|
| 3 | /* Eleonline - Raccolta e diffusione dei dati elettorali */
|
|---|
| 4 | /* by Roberto Gigli & Luciano Apolito */
|
|---|
| 5 | /* http://www.eleonline.it */
|
|---|
| 6 | /* info@eleonline.it luciano@aniene.net rgigli@libero.it */
|
|---|
| 7 | /************************************************************************/
|
|---|
| 8 | /* Modulo gruppo */
|
|---|
| 9 | /* Amministrazione */
|
|---|
| 10 | /************************************************************************/
|
|---|
| 11 | if (!defined('ADMIN_FILE')) {
|
|---|
| 12 | die ("You can't access this file directly...");
|
|---|
| 13 | }
|
|---|
| 14 |
|
|---|
| 15 | // Offset - visualizza il numero di elementi per pagina
|
|---|
| 16 | $offset=5;
|
|---|
| [257] | 17 | global $db1;
|
|---|
| [2] | 18 | $aid=$_SESSION['aid'];
|
|---|
| 19 | $prefix=$_SESSION['prefix'];
|
|---|
| 20 | $currentlang=$_SESSION['lang'];
|
|---|
| 21 | $param=strtolower($_SERVER['REQUEST_METHOD']) == 'get' ? $_GET : $_POST;
|
|---|
| 22 | $id_cons_gen=$param['id_cons_gen'];
|
|---|
| 23 | $perms=ChiSei($id_cons_gen);
|
|---|
| 24 | if ($perms<32 or !$id_cons_gen) die("Non hai i permessi per inserire dati, o non hai scelto la consultazione!");
|
|---|
| 25 |
|
|---|
| 26 | $id_comune=$_SESSION['id_comune'];
|
|---|
| [257] | 27 | $sql = "SELECT t1.tipo_cons,t2.id_cons FROM ".$prefix."_ele_consultazione as t1, ".$prefix."_ele_cons_comune as t2 where t1.id_cons_gen=t2.id_cons_gen and t2.id_cons_gen='$id_cons_gen' and t2.id_comune='$id_comune' ";
|
|---|
| 28 | $res = $dbi->prepare("$sql");
|
|---|
| 29 | $res->execute();
|
|---|
| 30 | list($tipo_cons,$id_cons) = $res->fetch(PDO::FETCH_NUM);
|
|---|
| [2] | 31 |
|
|---|
| 32 | include("modules/Elezioni/funzionidata.php");
|
|---|
| 33 | include("modules/Elezioni/ele.php");
|
|---|
| 34 |
|
|---|
| 35 | if (isset($param['do'])) get_magic_quotes_gpc() ? $do=$param['do']:$do=addslashes($param['do']); else $do='';
|
|---|
| 36 | if (isset($param['min'])) $min=intval($param['min']); else $min=0;
|
|---|
| 37 | if (isset($param['ok'])) get_magic_quotes_gpc() ? $ok=$param['ok']:$ok=addslashes($param['ok']); else $ok='';
|
|---|
| 38 | if (isset($param['descrizione'])) get_magic_quotes_gpc() ?
|
|---|
| 39 | $descrizione=$param['descrizione']:$descrizione=addslashes($param['descrizione']); else $descrizione='';
|
|---|
| 40 | if (isset($param['id_conf'])) $id_conf=intval($param['id_conf']); else $id_conf='';
|
|---|
| 41 | if (isset($param['limite'])) get_magic_quotes_gpc() ? $limite=$param['limite']:$limite=addslashes($param['limite']); else $limite='';
|
|---|
| 42 | if (isset($param['consin'])) get_magic_quotes_gpc() ? $consin=$param['consin']:$consin=addslashes($param['consin']); else $consin='';
|
|---|
| 43 | if (isset($param['infpremio'])) get_magic_quotes_gpc() ? $infpremio=$param['infpremio']:$infpremio=addslashes($param['infpremio']); else $infpremio='';
|
|---|
| 44 | if (isset($param['listinfsbar'])) get_magic_quotes_gpc() ? $listinfsbar=$param['listinfsbar']:$listinfsbar=addslashes($param['listinfsbar']); else $listinfsbar='';
|
|---|
| 45 | if (isset($param['infminpremio'])) get_magic_quotes_gpc() ? $infminpremio=$param['infminpremio']:$infminpremio=addslashes($param['infminpremio']); else $infminpremio='';
|
|---|
| 46 | if (isset($param['listinfconta'])) get_magic_quotes_gpc() ? $listinfconta=$param['listinfconta']:$listinfconta=addslashes($param['listinfconta']); else $listinfconta='';
|
|---|
| 47 | if (isset($param['suppremio'])) get_magic_quotes_gpc() ? $suppremio=$param['suppremio']:$suppremio=addslashes($param['suppremio']); else $suppremio='';
|
|---|
| 48 | if (isset($param['supsbarramento'])) get_magic_quotes_gpc() ? $supsbarramento=$param['supsbarramento']:$supsbarramento=addslashes($param['supsbarramento']); else $supsbarramento='';
|
|---|
| 49 | if (isset($param['supminpremio'])) get_magic_quotes_gpc() ? $supminpremio=$param['supminpremio']:$supminpremio=addslashes($param['supminpremio']); else $supminpremio='';
|
|---|
| 50 | if (isset($param['listsupconta'])) get_magic_quotes_gpc() ? $listsupconta=$param['listsupconta']:$listsupconta=addslashes($param['listsupconta']); else $listsupconta='';
|
|---|
| [254] | 51 | #if (isset($param['infdisgiunto'])) get_magic_quotes_gpc() ? $infdisgiunto=$param['infdisgiunto']:$infdisgiunto=addslashes($param['infdisgiunto']); else $infdisgiunto='';
|
|---|
| 52 | #if (isset($param['supdisgiunto'])) get_magic_quotes_gpc() ? $supdisgiunto=$param['supdisgiunto']:$supdisgiunto=addslashes($param['supdisgiunto']); else $supdisgiunto='';
|
|---|
| [54] | 53 | if (isset($param['help'])) $help=intval($param['help']);
|
|---|
| 54 |
|
|---|
| [2] | 55 | /******************************************************/
|
|---|
| 56 | /*Funzione di visualizzazione globale */
|
|---|
| 57 | /*****************************************************/
|
|---|
| 58 | function all() {
|
|---|
| [54] | 59 | global $tipo_cons,$param,$currentlang, $bgcolor1, $bgcolor2, $prefix, $dbi, $offset, $min, $id_cons,$id_cons_gen,$id_comune,$do,$id_conf, $language,$help;
|
|---|
| [2] | 60 |
|
|---|
| 61 | // $restemp = mysql_query("select count(0) from ".$prefix."_ele_conf where id_conf='$id_conf'", $dbi);
|
|---|
| 62 | // list($numtemp)=mysql_fetch_row($restemp);
|
|---|
| 63 |
|
|---|
| [54] | 64 | if (isset($help)) include("language/$language/ele_confcons.html");
|
|---|
| [2] | 65 |
|
|---|
| 66 | echo "<center><br><table border=\"0\" width=\"100%\">";
|
|---|
| 67 |
|
|---|
| 68 | //-----------------------visualizza blocco inserimento -
|
|---|
| [257] | 69 | $sql="SELECT * FROM ".$prefix."_ele_conf"; //da modificare
|
|---|
| 70 | $res = $dbi->prepare("$sql");
|
|---|
| 71 | $res->execute();
|
|---|
| 72 | $max = $res->rowCount();
|
|---|
| [2] | 73 | $nuovo_gruppo=$max+1;
|
|---|
| 74 | echo "<form name=\"gruppo2\" enctype=\"multipart/form-data\" action=\"admin.php\" method=\"post\">"
|
|---|
| 75 | ."<input type=\"hidden\" name=\"op\" value=\"confconsiglio\">";
|
|---|
| 76 | if ($do=='modify') {
|
|---|
| [257] | 77 | $sql="SELECT * FROM ".$prefix."_ele_conf where id_conf='$id_conf'";
|
|---|
| [317] | 78 | $resl = $dbi->prepare("$sql");
|
|---|
| 79 | $resl->execute();
|
|---|
| [257] | 80 | $gru=$resl->fetch(PDO::FETCH_BOTH);
|
|---|
| [2] | 81 | $nuovo_gruppo=$gru['id_conf'];
|
|---|
| 82 | echo "<input type=\"hidden\" name=\"do\" value=\"update\">";
|
|---|
| 83 | }else{
|
|---|
| [254] | 84 | $gru['id_conf']=$nuovo_gruppo;$gru['descrizione']='';$gru['limite']='';$gru['consin']='';$gru['infpremio']='';$gru['listinfsbar']='';$gru['listinfconta']='';$gru['supminpremio']='';$gru['infminpremio']='';$gru['suppremio']='';$gru['supsbarramento']='';$gru['listsupconta']='';
|
|---|
| [2] | 85 | echo "<input type=\"hidden\" name=\"do\" value=\"add\">";
|
|---|
| 86 | }
|
|---|
| 87 | echo "<tr bgcolor=\"$bgcolor2\"><td align=\"center\"><input type=\"hidden\" name=\"id_cons_gen\" value=\"$id_cons_gen\">";
|
|---|
| 88 | // echo "<b>"._NUM."</b></td><td><input type=\"hidden\" name=\"id_conf\" value=\"".$gru['id_conf']."\">".$gru['id_conf']."</td><td align=\"center\">"
|
|---|
| 89 | echo "<input type=\"hidden\" name=\"id_conf\" value=\"".$gru['id_conf']."\"><b>"._DESCR."</b></td><td colspan=\"3\"><input type=\"text\" name=\"descrizione\" value=\"".$gru['descrizione']."\"></td></tr>"
|
|---|
| 90 | ."<tr><td align=\"center\"><b>"._LIMITE."</b></td><td><select name=\"limite\"><option value=\"0\">"._NOFASCIA;
|
|---|
| 91 |
|
|---|
| [257] | 92 | $sql="select id_fascia, abitanti from ".$prefix."_ele_fasce where id_conf='".$gru['id_conf']."' order by id_fascia";
|
|---|
| 93 | $result1 = $dbi->prepare("$sql");
|
|---|
| 94 | $result1->execute();
|
|---|
| 95 | while(list($id,$descr)=$result1->fetch(PDO::FETCH_NUM)){
|
|---|
| 96 | $sel= ($id == $gru['limite']) ? "selected":"";
|
|---|
| 97 | echo "<option value=\"$id\" $sel>$descr";
|
|---|
| 98 | }
|
|---|
| 99 | echo "</select></td>";
|
|---|
| [2] | 100 | $sel= ($gru['consin']==1) ? "selected":"";
|
|---|
| 101 | echo "<td align=\"center\"><b>"._CONSIN."</b></td><td><select name=\"consin\"><option value=\"0\">No<option value=\"1\" $sel>Si</select></td></tr>"
|
|---|
| [139] | 102 | ."<tr><td align=\"center\" colspan=\"4\" bgcolor=\"$bgcolor2\"><b>"._SISTEMA_MAGGIORITARIO."</b></td></tr>";
|
|---|
| [254] | 103 | echo "<tr><td align=\"center\"><b>"._INFPREMIO."</b></td><td><input type=\"text\" name=\"infpremio\" value=\"".$gru['infpremio']."\"></td>"
|
|---|
| [2] | 104 | ."<td align=\"center\"><b>"._LISTINFSBAR."</b></td><td><input type=\"text\" name=\"listinfsbar\" value=\"".$gru['listinfsbar']."\"></td></tr>"
|
|---|
| 105 | ."<tr><td align=\"center\"><b>"._INFMINPREMIO."</b></td><td><input type=\"text\" name=\"infminpremio\" value=\"".$gru['infminpremio']."\"></td>";
|
|---|
| 106 | $sel= ($gru['listinfconta']==1) ? "selected":"";
|
|---|
| 107 | echo"<td align=\"center\"><b>"._LISTINFCONTA."</b></td><td><select name=\"listinfconta\"><option value=\"0\">No<option value=\"1\" $sel>Si</select></td></tr>"
|
|---|
| [139] | 108 | ."<tr><td align=\"center\" colspan=\"4\" bgcolor=\"$bgcolor2\"><b>"._SISTEMA_PROPORZIONALE."</b></td></tr>";
|
|---|
| [254] | 109 | echo "<tr><td align=\"center\"><b>"._SUPPREMIO."</b></td><td><input type=\"text\" name=\"suppremio\" value=\"".$gru['suppremio']."\"></td>"
|
|---|
| [2] | 110 | ."<td align=\"center\"><b>"._SUPSBAR."</b></td><td><input type=\"text\" name=\"supsbarramento\" value=\"".$gru['supsbarramento']."\"></td></tr>"
|
|---|
| 111 | ."<tr><td align=\"center\"><b>"._SUPMINPREMIO."</b></td><td><input type=\"text\" name=\"supminpremio\" value=\"".$gru['supminpremio']."\"></td>";
|
|---|
| 112 | $sel= ($gru['listsupconta']==1) ? "selected":"";
|
|---|
| 113 | echo "<td align=\"center\"><b>"._LISTSUPCONTA."</b></td><td><select name=\"listsupconta\"><option value=\"0\">No<option value=\"1\" $sel>Si</select>";
|
|---|
| 114 | echo "<input type=\"hidden\" name=\"id_cons\" value=\"$id_cons\">"
|
|---|
| 115 | ."<input type=\"hidden\" name=\"id_cons_gen\" value=\"$id_cons_gen\">"
|
|---|
| 116 | ."<input type=\"hidden\" name=\"min\" value=\"$min\"></td></tr><tr><td></td><td></td><td></td>";
|
|---|
| 117 | if ($do=='modify')
|
|---|
| 118 | echo "<td align=\"center\"><input type=\"submit\" name=\"add\" value=\""._MODIFY."\"></td>";
|
|---|
| 119 | else
|
|---|
| 120 | echo "<td align=\"center\"><input type=\"submit\" name=\"add\" value=\""._ADD."\"></td>";
|
|---|
| 121 | echo "</tr></form>";
|
|---|
| 122 |
|
|---|
| 123 |
|
|---|
| 124 |
|
|---|
| [257] | 125 | $sql="SELECT * FROM ".$prefix."_ele_conf";
|
|---|
| 126 | $res = $dbi->prepare("$sql");
|
|---|
| 127 | $res->execute();
|
|---|
| 128 | $max = $res->rowCount();
|
|---|
| 129 | $sql="select * from ".$prefix."_ele_conf ORDER BY id_conf LIMIT $min,$offset";
|
|---|
| 130 | $result = $dbi->prepare("$sql");
|
|---|
| 131 | $result->execute();
|
|---|
| 132 | while(list($id_conf,$descrizione,$limite, $consin,$infpremio, $supsbarramento, $suppremio, $listinfsbar, $listinfconta, $listsupconta) = $result->fetch(PDO::FETCH_NUM)) {
|
|---|
| [2] | 133 | $bgcolor1=($bgcolor1==$_SESSION['bgcolor1'])?$_SESSION['bgcolor2']:$_SESSION['bgcolor1'];
|
|---|
| 134 | echo "<tr bgcolor=\"$bgcolor1\"><td align=\"center\"><b>$id_conf</b></td>"
|
|---|
| 135 | ."<td align=\"left\"><b>$descrizione</b></td>"; /*
|
|---|
| 136 | ."<td align=\"center\"><b>$limite</b></td>"
|
|---|
| 137 | ."<td align=\"center\"><b>$consin</b></td>"
|
|---|
| 138 | ."<td align=\"center\"><b>$infpremio</b></td>"
|
|---|
| 139 | ."<td align=\"center\"><b>$supsbarramento</b></td>"
|
|---|
| 140 | ."<td align=\"center\"><b>$suppremio</b></td>"
|
|---|
| 141 | ."<td align=\"center\"><b>$listinfsbar</b></td>"
|
|---|
| 142 | ."<td align=\"center\"><b>$listinfconta</b></td>"
|
|---|
| 143 | ."<td align=\"center\"><b>$listsupconta</b></td>" */
|
|---|
| 144 | echo "<td align=\"center\" nowrap>[<a
|
|---|
| 145 | href=\"admin.php?op=confconsiglio&do=modify&id_conf=$id_conf&id_cons_gen=$id_cons_gen&min=$min\"><img src=\"modules/Elezioni/images/edit.gif\"
|
|---|
| 146 | border=\"0\" align=\"center\"> "._EDIT."</a>]";
|
|---|
| 147 |
|
|---|
| 148 | if (!isset($numtemp))
|
|---|
| 149 | echo "[<a href=\"admin.php?op=confconsiglio&do=delete&id_conf=$id_conf&id_cons_gen=$id_cons_gen&min=$min\">"._DELETE." <img src=\"modules/Elezioni/images/delete.gif\" border=\"0\" align=\"center\"></a>]";
|
|---|
| 150 | else
|
|---|
| 151 | echo "["._DELETE." <img src=\"modules/Elezioni/images/delete.gif\" border=\"0\" align=\"center\"></a>]";
|
|---|
| 152 | echo "</td></tr>";
|
|---|
| 153 | }
|
|---|
| 154 | echo "</table></center>";
|
|---|
| 155 |
|
|---|
| 156 | // #'Pagina precedente' e 'Pagina Successiva'
|
|---|
| 157 |
|
|---|
| 158 | echo"<table align=\"center\" width=\"100%\" ><tr>";
|
|---|
| 159 | $prev=$min-$offset;
|
|---|
| 160 | if ($prev>=0) {
|
|---|
| 161 | echo "<td colspan=\"5\" align=\"center\" bgcolor=\"$bgcolor1\"><a href=\"admin.php?op=confconsiglio&id_conf=$id_conf&id_cons_gen=$id_cons_gen&id_comune=$id_comune&min=$prev\">";
|
|---|
| 162 | echo "<b>$offset "._PREV_MATCH."</b></a></td>";
|
|---|
| 163 | }
|
|---|
| 164 |
|
|---|
| 165 | $next=$min+$offset;
|
|---|
| 166 | if ($next>=($offset-1)) {
|
|---|
| 167 | if($next>=$max) $next = $max;
|
|---|
| 168 | else {
|
|---|
| 169 | echo "<td colspan=\"5\" align=\"center\" bgcolor=\"$bgcolor1\"><a href=\"admin.php?op=confconsiglio&id_conf=$id_conf&id_cons_gen=$id_cons_gen&min=$next\">";
|
|---|
| 170 | echo "<b>$offset "._NEXT_MATCH."</b></a></td>";
|
|---|
| 171 | }
|
|---|
| 172 | }
|
|---|
| 173 | echo "</tr></table><br>";
|
|---|
| 174 |
|
|---|
| 175 | }
|
|---|
| 176 |
|
|---|
| 177 | //***********************************************************
|
|---|
| 178 | //Funzione di inserimento e gestione dei gruppi
|
|---|
| 179 | //************************************************************
|
|---|
| 180 |
|
|---|
| 181 | function confcons($ok, $do) {
|
|---|
| [254] | 182 | global $prefix, $dbi, $id_cons,$simbolo2,$genere,$id_cons_gen,$id_comune,$min,$id_conf,$descrizione, $limite,$consin,$infpremio,$listinfsbar,$infminpremio,$listinfconta,$supsbarramento,$suppremio,$supminpremio,$listsupconta;
|
|---|
| [2] | 183 | $aid=$_SESSION['aid'];
|
|---|
| 184 | $perms=ChiSei($id_cons_gen);
|
|---|
| 185 | if ($perms >128) {
|
|---|
| 186 | if ($do == "delete") {
|
|---|
| 187 | if ($ok !="1") {
|
|---|
| 188 | ele();
|
|---|
| 189 | echo "<center><br><br>"._DOMCANCELLA." "._DESCR." $descrizione ?<br>";
|
|---|
| 190 | echo "[ <a href=\"admin.php?op=confconsiglio&id_cons_gen=$id_cons_gen&id_conf=$id_conf\">"._NO."</a> ] - [<a href=\"admin.php?op=confconsiglio&do=delete&id_conf=$id_conf&id_cons_gen=$id_cons_gen&id_comune=$id_comune&ok=1\">"._YES."</a> ]";exit;
|
|---|
| 191 | }else{
|
|---|
| [257] | 192 | $sql="delete from ".$prefix."_ele_conf where id_conf='$id_conf'";
|
|---|
| 193 | $result = $dbi->prepare("$sql");
|
|---|
| 194 | $result->execute();
|
|---|
| 195 | if (!$result->rowCount()) return;
|
|---|
| [2] | 196 | Header("Location: admin.php?op=confconsiglio&id_cons_gen=$id_cons_gen&id_conf=$id_conf&min=$min");
|
|---|
| 197 | }
|
|---|
| 198 | } elseif ($do == "add") {
|
|---|
| 199 | if ($descrizione) {
|
|---|
| 200 | $sqlset='';
|
|---|
| [257] | 201 | $sql="insert into ".$prefix."_ele_conf(id_conf,descrizione, limite,consin,infpremio,supsbarramento,suppremio,listinfsbar,listinfconta,listsupconta,infminpremio,supminpremio) values ('$id_conf','$descrizione','$limite','$consin','$infpremio','$supsbarramento','$suppremio','$listinfsbar','$listinfconta','$listsupconta','$infminpremio','$supminpremio')";
|
|---|
| 202 | $result = $dbi->prepare("$sql");
|
|---|
| 203 | $result->execute();
|
|---|
| 204 | if (!$result->rowCount()) return;
|
|---|
| [2] | 205 | Header("Location: admin.php?op=confconsiglio&id_cons_gen=$id_cons_gen&min=$min");
|
|---|
| 206 | } else {
|
|---|
| 207 | ele();
|
|---|
| 208 | OpenTable();
|
|---|
| 209 | echo "<center>"._GESTIONE." "._CONF." ";
|
|---|
| 210 | echo "<br><br><a href=\"admin.php?op=confconsiglio&id_cons_gen=$id_cons_gen\">"._IMM." "._CONF."</a></center>";
|
|---|
| 211 | CloseTable();
|
|---|
| 212 | }
|
|---|
| 213 | } elseif ($do == "update") {
|
|---|
| [257] | 214 | $sql="update ".$prefix."_ele_conf set descrizione='$descrizione', limite='$limite', consin='$consin', infpremio='$infpremio', supsbarramento='$supsbarramento', suppremio='$suppremio', listinfsbar='$listinfsbar', listinfconta='$listinfconta', listsupconta='$listsupconta', infminpremio='$infminpremio', supminpremio='$supminpremio' where id_conf='$id_conf' ";
|
|---|
| 215 | $result = $dbi->prepare("$sql");
|
|---|
| 216 | $result->execute();
|
|---|
| [2] | 217 | Header("Location: admin.php?op=confconsiglio&id_cons_gen=$id_cons_gen&min=$min");
|
|---|
| 218 | }
|
|---|
| 219 |
|
|---|
| 220 | }
|
|---|
| 221 | }
|
|---|
| 222 |
|
|---|
| 223 | if ($do and $do!="modify")
|
|---|
| 224 | confcons($ok, $do);
|
|---|
| 225 | ele();
|
|---|
| 226 | all();
|
|---|
| 227 | echo"</td></tr></table>";
|
|---|
| 228 | include("footer.php");
|
|---|
| 229 |
|
|---|
| 230 |
|
|---|
| 231 |
|
|---|
| 232 |
|
|---|
| 233 | ?>
|
|---|
| 234 |
|
|---|
