| 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 | foreach ($alfa as $ltr) {
|
|---|
| 50 |
|
|---|
| 51 |
|
|---|
| 52 | 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>";
|
|---|
| 53 | if ( $counter == round($num/2) ) {
|
|---|
| 54 | echo " ]\n<br />\n[ ";
|
|---|
| 55 | } elseif ( $counter != $num ) {
|
|---|
| 56 | echo " | \n";
|
|---|
| 57 | }
|
|---|
| 58 | $counter++;
|
|---|
| 59 | }
|
|---|
| 60 | echo " ]\n</div>\n<br />\n";
|
|---|
| 61 |
|
|---|
| 62 | // ordine
|
|---|
| 63 | if ($ordine=="") $ordine="cognome";
|
|---|
| 64 | echo "\n<div>\n"; // Start of HTML
|
|---|
| 65 | echo ""._ORDINE." <b>[</b> ";
|
|---|
| 66 | if ($ordine == "cognome" OR !$ordine) {
|
|---|
| 67 | echo ""._COGNOME." | ";
|
|---|
| 68 | } else {
|
|---|
| 69 | 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> | ";
|
|---|
| 70 | }
|
|---|
| 71 |
|
|---|
| 72 | if ($ordine == "id_lista") {
|
|---|
| 73 | echo ""._LISTA." | ";
|
|---|
| 74 | } else {
|
|---|
| 75 | 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> ";
|
|---|
| 76 | }
|
|---|
| 77 |
|
|---|
| 78 | /*
|
|---|
| 79 | if($genere!=4)
|
|---|
| 80 | if ($ordine == "id_gruppo") {
|
|---|
| 81 | echo ""._GRUPPO." ";
|
|---|
| 82 | } else {
|
|---|
| 83 |
|
|---|
| 84 | 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> ";
|
|---|
| 85 | }
|
|---|
| 86 | */
|
|---|
| 87 |
|
|---|
| 88 | echo " <b>]</b>\n</div>\n";
|
|---|
| 89 |
|
|---|
| 90 | if ($lettera ==""._ALL."") $lettera="";
|
|---|
| 91 | // Fine ordine
|
|---|
| 92 |
|
|---|
| 93 |
|
|---|
| 94 | # conta il numero dei candidati
|
|---|
| 95 | if ($circo=="1"){
|
|---|
| 96 | $sql="select id_lista from ".$prefix."_ele_lista where id_cons='$id_cons' and id_circ='$id_circ'";
|
|---|
| 97 | $res = $dbi->prepare("$sql");
|
|---|
| 98 | $res->execute();
|
|---|
| 99 | while(list($id_lista2) = $res->fetch(PDO::FETCH_NUM)){
|
|---|
| 100 | $sql="select id_cand from ".$prefix."_ele_candidati where id_lista='$id_lista2' and cognome like \"$lettera%\"";
|
|---|
| 101 | $res2 = $dbi->prepare("$sql");
|
|---|
| 102 | $res2->execute();
|
|---|
| 103 | while(list($id_cand2) = $res2->fetch(PDO::FETCH_NUM)){
|
|---|
| 104 | $max=$max+1;
|
|---|
| 105 | }
|
|---|
| 106 | }
|
|---|
| 107 |
|
|---|
| 108 | }else{
|
|---|
| 109 |
|
|---|
| 110 | $sql="SELECT id_cons FROM ".$prefix."_ele_candidati where id_cons='$id_cons' and cognome like \"$lettera%\" ";
|
|---|
| 111 | $res = $dbi->prepare("$sql");
|
|---|
| 112 | $res->execute();
|
|---|
| 113 | if($res) $max = $res->rowCount();
|
|---|
| 114 |
|
|---|
| 115 | }
|
|---|
| 116 |
|
|---|
| 117 |
|
|---|
| 118 | //if ($ordine=="" or !$ordine) $ordine="cognome";
|
|---|
| 119 |
|
|---|
| 120 | if ($lettera!="") echo "Lettera: <span class=\"red\">$lettera </span>";
|
|---|
| 121 | if ($ordine=="cognome") echo " Ordine: <span class=\"red\"> Cognome</span>";
|
|---|
| 122 | if ($ordine=="id_lista") echo " Ordine: <span class=\"red\">"._LISTA."</span>";
|
|---|
| 123 | //if ($ordine=="id_gruppo") echo " Ordine:<span class=\"red\"> "._GRUPPO."</span>";
|
|---|
| 124 | echo " Numero Candidati: <span class=\"red\">$max</span>";
|
|---|
| 125 | echo "<br /><br />
|
|---|
| 126 | <table class=\"table-80\" rules=\"rows\" ><tr class=\"bggray\">"
|
|---|
| 127 | ."<td><b>"._NUM."</b></td>"
|
|---|
| 128 | ."<td ><b>"._NOME."</b></td>"
|
|---|
| 129 | ."<td><b>"._LISTA."</b></td>";
|
|---|
| 130 | if ($genere!=4) echo "<td><b>"._GRUPPO."</b></td></tr>";
|
|---|
| 131 |
|
|---|
| 132 |
|
|---|
| 133 |
|
|---|
| 134 | if ($ordine=="id_gruppo") $ordine="id_lista";
|
|---|
| 135 | $sql="select * from ".$prefix."_ele_candidati where id_cons='$id_cons' and cognome like \"$lettera%\" order by $ordine LIMIT $min,$offset";
|
|---|
| 136 | $result = $dbi->prepare("$sql");
|
|---|
| 137 | $result->execute();
|
|---|
| 138 |
|
|---|
| 139 |
|
|---|
| 140 | while(list($id_cand,$id_cons2,$id_lista, $numlista, $cognome, $nome, $note,, $num_cand) = $result->fetch(PDO::FETCH_NUM)) {
|
|---|
| 141 | if ($circo=="1") $circos=" and id_circ='$id_circ'";else $circos='';// per circosc 5-06
|
|---|
| 142 | // dati lista
|
|---|
| 143 | $sql="select descrizione,id_gruppo,id_circ from ".$prefix."_ele_lista where id_lista='$id_lista' $circos ";
|
|---|
| 144 | $res01 = $dbi->prepare("$sql");
|
|---|
| 145 | $res01->execute();
|
|---|
| 146 |
|
|---|
| 147 | if ($circo=="1") list($descr_lista,$id_gruppo,$id_circ2)=$res01->fetch(PDO::FETCH_NUM);
|
|---|
| 148 | else list($descr_lista,$id_gruppo,$id_circ_off)=$res01->fetch(PDO::FETCH_NUM);
|
|---|
| 149 |
|
|---|
| 150 |
|
|---|
| 151 | // dati gruppo
|
|---|
| 152 |
|
|---|
| 153 | if ($genere!=4){
|
|---|
| 154 | $sql="select descrizione from ".$prefix."_ele_gruppo where id_gruppo='$id_gruppo' ";
|
|---|
| 155 | $res2 = $dbi->prepare("$sql");
|
|---|
| 156 | $res2->execute();
|
|---|
| 157 | list($descr_gruppo)=$res2->fetch(PDO::FETCH_NUM);
|
|---|
| 158 |
|
|---|
| 159 | }
|
|---|
| 160 |
|
|---|
| 161 | if (!$id_circ)$id_circ="";
|
|---|
| 162 | if (!isset($id_circ2)) $id_circ2="";
|
|---|
| 163 |
|
|---|
| 164 | if ($id_circ==$id_circ2){
|
|---|
| 165 |
|
|---|
| 166 |
|
|---|
| 167 | echo "<tr class=\"table-main\"><td class=\"bggray\"><b>$num_cand</b>"
|
|---|
| 168 | ."</td><td style=\"text-align:left;\"><b>";
|
|---|
| 169 | if($votog){ echo "$cognome $nome";
|
|---|
| 170 | }else{
|
|---|
| 171 | 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>";
|
|---|
| 172 | }
|
|---|
| 173 |
|
|---|
| 174 | echo "</b></td>
|
|---|
| 175 | <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\">
|
|---|
| 176 | <img class=\"stemmapic\" src=\"modules.php?name=Elezioni&file=foto&id_lista=$id_lista\" alt=\"$cognome $nome\" /><br />$descr_lista </a></b>";
|
|---|
| 177 |
|
|---|
| 178 | if ($genere!=4){
|
|---|
| 179 |
|
|---|
| 180 | echo "</td><td>
|
|---|
| 181 | <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>";
|
|---|
| 182 | echo "</td></tr>";
|
|---|
| 183 | }
|
|---|
| 184 | }
|
|---|
| 185 |
|
|---|
| 186 | }
|
|---|
| 187 |
|
|---|
| 188 |
|
|---|
| 189 |
|
|---|
| 190 | echo "</table>";
|
|---|
| 191 |
|
|---|
| 192 |
|
|---|
| 193 | if (!$circo) page($id_cons_gen,$go,$max,$min,$prev,$next,$offset,$file);
|
|---|
| 194 |
|
|---|
| 195 | }
|
|---|
| 196 |
|
|---|
| 197 |
|
|---|
| 198 |
|
|---|
| 199 |
|
|---|
| 200 |
|
|---|
| 201 |
|
|---|
| 202 |
|
|---|
| 203 |
|
|---|
| 204 |
|
|---|
| 205 | ?>
|
|---|
