Changeset 253 for trunk/client/modules/Elezioni/index.php

Timestamp:

Mar 12, 2018, 8:53:21 PM (7 years ago)

Author:

roby

Message:

 

File:

• trunk/client/modules/Elezioni/index.php (modified) (3 diffs)

trunk/client/modules/Elezioni/index.php

@@ -15 +15 @@
         $_GET : $_POST;
 
-
+include("pdoquery.php");
 if (isset($param['rss'])) $rss=intval($param['rss']); else $rss='0';
 if (isset($param['xls'])) $xls=intval($param['xls']); else $xls='0';
@@ -24 +24 @@
 if (isset($param['id_cons_gen'])) $id_cons_gen=intval($param['id_cons_gen']); else 
 {
-        $res = mysql_query("SELECT id_cons FROM ".$prefix."_ele_comuni where id_comune='$id_comune' ", $dbi);
-        list($id_cons_pred)=mysql_fetch_row($res);
-        $res = mysql_query("SELECT id_cons_gen FROM ".$prefix."_ele_cons_comune where id_cons='$id_cons_pred' ", $dbi);
-        list($id_cons_gen)=mysql_fetch_row($res);
+        $id_cons_gen=dbpredefinita();
+        
 }       
 if (isset($param['op'])) $op=$param['op']; else $op='';
@@ -62 +60 @@
 $ordine=htmlentities($ordine); 
 
-$res = mysql_query("SELECT id_conf FROM ".$prefix."_ele_cons_comune where id_cons_gen='$id_cons_gen' and id_comune='$id_comune'" , $dbi);
-list($hondt) = mysql_fetch_row($res);
-
-$sql = "SELECT t3.genere,t1.tipo_cons,t1.descrizione,t2.id_cons_gen FROM ".$prefix."_ele_consultazione as t1, ".$prefix."_ele_cons_comune as t2, ".$prefix."_ele_tipo as t3 where t1.tipo_cons=t3.tipo_cons and t2.id_comune=$id_comune and t1.id_cons_gen=t2.id_cons_gen and t2.id_cons_gen='$id_cons_gen' and t2.chiusa!='2' ";
-$res = mysql_query("$sql",$dbi);
-$tot=mysql_num_rows($res);
-if ($tot>0 and $id_cons_gen>0) {
-        $sql = "SELECT t3.genere,t1.tipo_cons,t1.descrizione,t2.id_cons_gen FROM ".$prefix."_ele_consultazione as t1, ".$prefix."_ele_cons_comune as t2, ".$prefix."_ele_tipo as t3 where t1.tipo_cons=t3.tipo_cons and t2.id_comune=$id_comune and t1.id_cons_gen=t2.id_cons_gen and t2.id_cons_gen='$id_cons_gen' and t2.chiusa!='2'";
-}else{
-        $sql = "SELECT t3.genere,t1.tipo_cons,t1.descrizione,t2.id_cons_gen FROM ".$prefix."_ele_consultazione as t1, ".$prefix."_ele_cons_comune as t2, ".$prefix."_ele_tipo as t3 where t1.tipo_cons=t3.tipo_cons and t2.id_comune=$id_comune and t1.id_cons_gen=t2.id_cons_gen and t2.chiusa!='2' order by t1.data_fine desc limit 0,1 ";
-}
-$res = mysql_query("$sql",$dbi);
-if ($res) list($genere,$tipo_cons,$descr_cons,$id_cons_gen) = mysql_fetch_row($res);
+$hondt = dbvalorehondt();
+
+$res=dbselectcons();
+
+$genere=$res['genere'];
+$tipo_cons=$res['tipo_cons'];
+$descr_cons=$res['descrizione'];
+$id_cons_gen=$res['id_cons_gen'];
+echo "descr:$descr_cons";
+
+
+
+##########
 
 if ($tipo_cons!=3) $limite=0;