| 1 | <?php
|
|---|
| 2 | ########## funzione candidato
|
|---|
| 3 |
|
|---|
| 4 |
|
|---|
| 5 | if (!defined('MODULE_FILE')) {
|
|---|
| 6 | die ("You can't access this file directly...");
|
|---|
| 7 | }
|
|---|
| 8 |
|
|---|
| 9 |
|
|---|
| 10 | /******************************************************/
|
|---|
| 11 | /*Funzione di visualizzazione globale candidato */
|
|---|
| 12 | /*****************************************************/
|
|---|
| 13 | function candidato() {
|
|---|
| 14 | global $tipo_cons, $prefix, $dbi, $offset, $min, $id_cons_gen, $id_cons,$file,$genere,$prev,$next,$lettera,$ltr,$ordine,$id_comune,$id_circ,$id_lista,$votog,$circo,$num;
|
|---|
| 15 |
|
|---|
| 16 |
|
|---|
| 17 |
|
|---|
| 18 | $offset=15;
|
|---|
| 19 | if ($circo==1) $offset=1000;
|
|---|
| 20 | if (!isset($min)) $min=0;
|
|---|
| 21 | $go="candi";
|
|---|
| 22 |
|
|---|
| 23 |
|
|---|
| 24 | if($circo==0)$id_circ='';
|
|---|
| 25 |
|
|---|
| 26 |
|
|---|
| 27 |
|
|---|
| 28 |
|
|---|
| 29 | # numero sezioni
|
|---|
| 30 | $sql = "select * from ".$prefix."_ele_sezioni where id_cons='$id_cons' ";
|
|---|
| 31 | $res = $dbi->prepare("$sql");
|
|---|
| 32 | $res->execute();
|
|---|
| 33 |
|
|---|
| 34 | $sezioni = $res->rowCount();
|
|---|
| 35 |
|
|---|
| 36 |
|
|---|
| 37 |
|
|---|
| 38 | /* Scelta alfabetica */
|
|---|
| 39 |
|
|---|
| 40 | echo "<br /><h2>"._CANDIDATI." "._CONSIGLIO."</h2>";
|
|---|
| 41 | echo "<div><b>"._INIZIALI."</b></div>";
|
|---|
| 42 | $alfa = array (""._ALL."", "A","B","C","D","E","F","G","H","I","J","K","L","M",
|
|---|
| 43 | "N","O","P","Q","R","S","T","U","V","W","X","Y","Z");
|
|---|
| 44 | $num = count($alfa) - 1;
|
|---|
| 45 | echo "<div>[ ";
|
|---|
| 46 | $counter = 0;
|
|---|
| 47 | while (list(, $ltr) = each($alfa)) {
|
|---|
| 48 |
|
|---|
| 49 |
|
|---|
| 50 | echo "<a href=\"modules.php?name=Elezioni&id_cons_gen=$id_cons_gen&id_comune=$id_comune&id_circ=$id_circ&op=candi&lettera=$ltr&ordine=$ordine\">$ltr</a>";
|
|---|
| 51 | if ( $counter == round($num/2) ) {
|
|---|
| 52 | echo " ]\n<br />\n[ ";
|
|---|
| 53 | } elseif ( $counter != $num ) {
|
|---|
| 54 | echo " | \n";
|
|---|
| 55 | }
|
|---|
| 56 | $counter++;
|
|---|
| 57 | }
|
|---|
| 58 | echo " ]\n</div>\n<br />\n";
|
|---|
| 59 |
|
|---|
| 60 | // ordine
|
|---|
| 61 | if ($ordine=="") $ordine="cognome";
|
|---|
| 62 | echo "\n<div>\n"; // Start of HTML
|
|---|
| 63 | echo ""._ORDINE." <b>[</b> ";
|
|---|
| 64 | if ($ordine == "cognome" OR !$ordine) {
|
|---|
| 65 | echo ""._COGNOME." | ";
|
|---|
| 66 | } else {
|
|---|
| 67 | echo "<a href=\"modules.php?name=Elezioni&id_cons_gen=$id_cons_gen&id_comune=$id_comune&id_circ=$id_circ&op=candi&lettera=$lettera&ordine=cognome&min=$min&offset=$offset\">"._COGNOME."</a> | ";
|
|---|
| 68 | }
|
|---|
| 69 |
|
|---|
| 70 | if ($ordine == "id_lista") {
|
|---|
| 71 | echo ""._LISTA." | ";
|
|---|
| 72 | } else {
|
|---|
| 73 | echo "<a href=\"modules.php?name=Elezioni&id_cons_gen=$id_cons_gen&id_comune=$id_comune&id_circ=$id_circ&op=candi&lettera=$lettera&ordine=id_lista\">"._LISTA."</a> ";
|
|---|
| 74 | }
|
|---|
| 75 |
|
|---|
| 76 | /*
|
|---|
| 77 | if($genere!=4)
|
|---|
| 78 | if ($ordine == "id_gruppo") {
|
|---|
| 79 | echo ""._GRUPPO." ";
|
|---|
| 80 | } else {
|
|---|
| 81 |
|
|---|
| 82 | echo "<a href=\"modules.php?name=Elezioni&id_cons_gen=$id_cons_gen&id_comune=$id_comune&id_circ=$id_circ&op=candi&lettera=$lettera&ordine=id_gruppo\">"._GRUPPO."</a> ";
|
|---|
| 83 | }
|
|---|
| 84 | */
|
|---|
| 85 |
|
|---|
| 86 | echo " <b>]</b>\n</div>\n";
|
|---|
| 87 |
|
|---|
| 88 | if ($lettera ==""._ALL."") $lettera="";
|
|---|
| 89 | // Fine ordine
|
|---|
| 90 |
|
|---|
| 91 |
|
|---|
| 92 | # conta il numero dei candidati
|
|---|
| 93 | if ($circo=="1"){
|
|---|
| 94 | $sql="select id_lista from ".$prefix."_ele_lista where id_cons='$id_cons' and id_circ='$id_circ'";
|
|---|
| 95 | $res = $dbi->prepare("$sql");
|
|---|
| 96 | $res->execute();
|
|---|
| 97 | while(list($id_lista2) = $res->fetch(PDO::FETCH_NUM)){
|
|---|
| 98 | $sql="select id_cand from ".$prefix."_ele_candidati where id_lista='$id_lista2' and cognome like \"$lettera%\"";
|
|---|
| 99 | $res2 = $dbi->prepare("$sql");
|
|---|
| 100 | $res2->execute();
|
|---|
| 101 | while(list($id_cand2) = $res2->fetch(PDO::FETCH_NUM)){
|
|---|
| 102 | $max=$max+1;
|
|---|
| 103 | }
|
|---|
| 104 | }
|
|---|
| 105 |
|
|---|
| 106 | }else{
|
|---|
| 107 |
|
|---|
| 108 | $sql="SELECT id_cons FROM ".$prefix."_ele_candidati where id_cons='$id_cons' and cognome like \"$lettera%\" ";
|
|---|
| 109 | $res = $dbi->prepare("$sql");
|
|---|
| 110 | $res->execute();
|
|---|
| 111 | if($res) $max = $res->rowCount();
|
|---|
| 112 |
|
|---|
| 113 | }
|
|---|
| 114 |
|
|---|
| 115 |
|
|---|
| 116 | //if ($ordine=="" or !$ordine) $ordine="cognome";
|
|---|
| 117 |
|
|---|
| 118 | if ($lettera!="") echo "Lettera: <span class=\"red\">$lettera </span>";
|
|---|
| 119 | if ($ordine=="cognome") echo " Ordine: <span class=\"red\"> Cognome</span>";
|
|---|
| 120 | if ($ordine=="id_lista") echo " Ordine: <span class=\"red\">"._LISTA."</span>";
|
|---|
| 121 | //if ($ordine=="id_gruppo") echo " Ordine:<span class=\"red\"> "._GRUPPO."</span>";
|
|---|
| 122 | echo " Numero Candidati: <span class=\"red\">$max</span>";
|
|---|
| 123 | echo "<br /><br />
|
|---|
| 124 | <table class=\"table-80\" rules=\"rows\" ><tr class=\"bggray\">"
|
|---|
| 125 | ."<td><b>"._NUM."</b></td>"
|
|---|
| 126 | ."<td ><b>"._NOME."</b></td>"
|
|---|
| 127 | ."<td><b>"._LISTA."</b></td>";
|
|---|
| 128 | if ($genere!=4) echo "<td><b>"._GRUPPO."</b></td></tr>";
|
|---|
| 129 |
|
|---|
| 130 |
|
|---|
| 131 |
|
|---|
| 132 | if ($ordine=="id_gruppo") $ordine="id_lista";
|
|---|
| 133 | $sql="select * from ".$prefix."_ele_candidati where id_cons='$id_cons' and cognome like \"$lettera%\" order by $ordine LIMIT $min,$offset";
|
|---|
| 134 | $result = $dbi->prepare("$sql");
|
|---|
| 135 | $result->execute();
|
|---|
| 136 |
|
|---|
| 137 |
|
|---|
| 138 | while(list($id_cand,$id_cons2,$id_lista, $cognome, $nome, $note,, $num_cand) = $result->fetch(PDO::FETCH_NUM)) {
|
|---|
| 139 | if ($circo=="1") $circos=" and id_circ='$id_circ'";else $circos='';// per circosc 5-06
|
|---|
| 140 | // dati lista
|
|---|
| 141 | $sql="select descrizione,id_gruppo,id_circ from ".$prefix."_ele_lista where id_lista='$id_lista' $circos ";
|
|---|
| 142 | $res01 = $dbi->prepare("$sql");
|
|---|
| 143 | $res01->execute();
|
|---|
| 144 |
|
|---|
| 145 | if ($circo=="1") list($descr_lista,$id_gruppo,$id_circ2)=$res01->fetch(PDO::FETCH_NUM);
|
|---|
| 146 | else list($descr_lista,$id_gruppo,$id_circ_off)=$res01->fetch(PDO::FETCH_NUM);
|
|---|
| 147 |
|
|---|
| 148 |
|
|---|
| 149 | // dati gruppo
|
|---|
| 150 |
|
|---|
| 151 | if ($genere!=4){
|
|---|
| 152 | $sql="select descrizione from ".$prefix."_ele_gruppo where id_gruppo='$id_gruppo' ";
|
|---|
| 153 | $res2 = $dbi->prepare("$sql");
|
|---|
| 154 | $res2->execute();
|
|---|
| 155 | list($descr_gruppo)=$res2->fetch(PDO::FETCH_NUM);
|
|---|
| 156 |
|
|---|
| 157 | }
|
|---|
| 158 |
|
|---|
| 159 | if (!$id_circ)$id_circ="";
|
|---|
| 160 | if (!isset($id_circ2)) $id_circ2="";
|
|---|
| 161 |
|
|---|
| 162 | if ($id_circ==$id_circ2){
|
|---|
| 163 |
|
|---|
| 164 |
|
|---|
| 165 | echo "<tr class=\"table-main\"><td class=\"bggray\"><b>$num_cand</b>"
|
|---|
| 166 | ."</td><td style=\"text-align:left;\"><b>";
|
|---|
| 167 | if($votog){ echo "$cognome $nome";
|
|---|
| 168 | }else{
|
|---|
| 169 | echo " <a href=\"modules.php?name=Elezioni&id_cons_gen=$id_cons_gen&id_comune=$id_comune&op=candidato_sezione&min=$num_cand&offset=$num_cand&id_lista=$id_lista&orvert=1&offsetsez=$sezioni&id_circ=$id_circ\">$cognome $nome</a>";
|
|---|
| 170 | }
|
|---|
| 171 |
|
|---|
| 172 | echo "</b></td>
|
|---|
| 173 | <td><b><a href=\"modules.php?name=Elezioni&id_gruppo=$id_gruppo&id_circ=$id_circ&id_cons_gen=$id_cons_gen&id_lista=$id_lista&op=partiti&id_comune=$id_comune\">
|
|---|
| 174 | <img class=\"stemmapic\" src=\"modules.php?name=Elezioni&file=foto&id_lista=$id_lista\" alt=\"$cognome $nome\" /><br />$descr_lista </a></b>";
|
|---|
| 175 |
|
|---|
| 176 | if ($genere!=4){
|
|---|
| 177 |
|
|---|
| 178 | echo "</td><td>
|
|---|
| 179 | <a href=\"modules.php?name=Elezioni&op=gruppo&id_cons_gen=$id_cons_gen&id_comune=$id_comune&id_circ=$id_circ\"><img class=\"stemmapic\" src=\"modules.php?name=Elezioni&file=foto&id_gruppo=$id_gruppo \" alt=\" \" /><br />$descr_gruppo</a>";
|
|---|
| 180 | echo "</td></tr>";
|
|---|
| 181 | }
|
|---|
| 182 | }
|
|---|
| 183 |
|
|---|
| 184 | }
|
|---|
| 185 |
|
|---|
| 186 |
|
|---|
| 187 |
|
|---|
| 188 | echo "</table>";
|
|---|
| 189 |
|
|---|
| 190 |
|
|---|
| 191 | if (!$circo) page($id_cons_gen,$go,$max,$min,$prev,$next,$offset,$file);
|
|---|
| 192 |
|
|---|
| 193 | }
|
|---|
| 194 |
|
|---|
| 195 |
|
|---|
| 196 |
|
|---|
| 197 |
|
|---|
| 198 |
|
|---|
| 199 |
|
|---|
| 200 |
|
|---|
| 201 |
|
|---|
| 202 |
|
|---|
| 203 | ?>
|
|---|
