Changeset 184

Timestamp:

May 19, 2013, 8:00:31 PM (11 years ago)

Author:

roby

Message:

admin: ele_comuni - sistemata gestione fasce

File:

• trunk/admin/modules/Elezioni/ele_comuni.php (modified) (3 diffs)

trunk/admin/modules/Elezioni/ele_comuni.php

@@ -94 +94 @@
         echo "<tr><td bgcolor=\"$bgcolor1\"><b>"._INDIRIZZO."</b></td><td><input name=\"indirizzo\" value=\"".stripslashes($indirizzo)."\"></td>";
         echo "<td bgcolor=\"$bgcolor1\"><b>"._CENTRALINO."</b></td><td><input name=\"centralino\" value=\"$centralino\" size=\"6\"></td></tr>";
-        echo "<tr><td bgcolor=\"$bgcolor1\"><b>"._FASCIA."</b></td><td><select name=\"fascia\">"
-                ."<option value=\"1\"".$sel[1].">0-3.000"
-                ."<option value=\"2\"".$sel[2].">3.001-10.000"
-                ."<option value=\"3\"".$sel[3].">10.001-15.000"
-                ."<option value=\"4\"".$sel[4].">15.001-30.000"
-                ."<option value=\"5\"".$sel[5].">30.001-100.000"
-                ."<option value=\"6\"".$sel[6].">100.001-250.000"
-                ."<option value=\"7\"".$sel[7].">250.001-500.000"
-                ."<option value=\"8\"".$sel[8].">500.001-1.000.000"
-                ."<option value=\"9\"".$sel[9]."> >1.000.000";
-        echo "</select></td>";
+        echo "<tr><td bgcolor=\"$bgcolor1\"><b>"._FASCIA."</b></td><td><select name=\"fascia\">";
+        $descr2="<";
+                        $resopt1 = mysql_query("select id_fascia, abitanti from ".$prefix."_ele_fasce where data_fine='0000-00-00' order by id_fascia", $dbi);
+                while(list($id,$descr)=mysql_fetch_row($resopt1)){
+                        $selid= ($id == $fasciatmp) ? "selected":"";
+                        
+                        echo "<option value=\"$id\" $selid>$descr2 $descr";
+                        $descr2="$descr -";
+                }
+                echo "</select></td>";
+
         echo "<td bgcolor=\"$bgcolor1\"><b>"._FAX."</b></td><td><input name=\"fax\" value=\"$fax\" size=\"6\"></td></tr>";
         echo "<tr><td bgcolor=\"$bgcolor1\"><b>"._EMAIL."</b></td><td><input name=\"email\" value=\"$email\"></td>";
@@ -149 +149 @@
                 echo "<td><b>$fax</b></td>";
                 echo "<td><b>".substr($email,0,15)."...</b></td>";
+                $resopt1 = mysql_query("select abitanti from ".$prefix."_ele_fasce where id_fascia=$fasciatmp and data_fine='0000-00-00'", $dbi);
+                list($tmpfascia)=mysql_fetch_row($resopt1);
+                $fasciaref=$fasciatmp-1;
+                $resopt1 = mysql_query("select abitanti from ".$prefix."_ele_fasce where id_fascia=$fasciaref and data_fine='0000-00-00'", $dbi);
+                if(mysql_num_rows($resopt1)==0) $valfascia="< $tmpfascia";
+                else
+                {
+                    list($tmp2fascia)=mysql_fetch_row($resopt1);
+                        $valfascia="$tmp2fascia - $tmpfascia";
+                }
+                
+/*
                 switch ($fasciatmp) {
                         case '0': $valfascia="-"; break;
@@ -160 +172 @@
                         case '8':$valfascia="500.001-1000.000"; break;
                         case '9': $valfascia=" >1.000.000"; break;
-                }       
+                }       */
                 echo "<td><b>$valfascia</b></td>";
                 echo "<input type=\"hidden\" name=\"ok\" value=0>";