Changeset 262 for trunk/admin
- Timestamp:
- Apr 7, 2019, 5:16:46 PM (6 years ago)
- Location:
- trunk/admin/modules/Elezioni
- Files:
-
- 1 added
- 7 edited
-
ele_colora_sez.php (modified) (3 diffs)
-
ele_controlli.php (added)
-
ele_voti.php (modified) (2 diffs)
-
salva_aff.php (modified) (2 diffs)
-
salva_gruppi.php (modified) (2 diffs)
-
salva_liste.php (modified) (3 diffs)
-
salva_ref.php (modified) (2 diffs)
-
salva_voti.php (modified) (2 diffs)
Legend:
- Unmodified
- Added
- Removed
-
trunk/admin/modules/Elezioni/ele_colora_sez.php
r260 r262 23 23 $res = $dbi->prepare("$sql"); 24 24 $res->execute(); 25 if($liste && $liste==$res->rowCount()){ 25 list($ltot)=$res->fetch(PDO::FETCH_NUM); 26 if($liste && $liste==$ltot){ 26 27 $sezstat=2; 27 28 $sql="UPDATE ".$prefix."_ele_sezioni set colore='#99CC33' where id_cons='$id_cons' and id_sez='$id_sez'"; #VERDE … … 39 40 $res->execute(); 40 41 }elseif(!$sezstat){ #gruppi 41 if($genere) 42 $sql="SELECT id_gruppo FROM ".$prefix."_ele_voti_gruppo where id_sez='$id_sez'"; 43 else 44 $sql="SELECT id_gruppo FROM ".$prefix."_ele_voti_ref where id_sez='$id_sez'"; 45 $res = $dbi->prepare("$sql"); 46 $res->execute(); 47 $righe=$res->rowCount(); 42 if($genere!=4){ 43 if($genere) 44 $sql="SELECT id_gruppo FROM ".$prefix."_ele_voti_gruppo where id_sez='$id_sez'"; 45 else 46 $sql="SELECT id_gruppo FROM ".$prefix."_ele_voti_ref where id_sez='$id_sez'"; 47 48 $res = $dbi->prepare("$sql"); 49 $res->execute(); 50 $righe=$res->rowCount(); 51 }else $righe=0; 48 52 if($righe){ 49 53 $sezstat=4; … … 58 62 if($voti) { 59 63 $sezstat=5; 60 $sql="UPDATE ".$prefix."_ele_sezioni set colore='#F5 F5F5' where id_cons='$id_cons' and id_sez='$id_sez'"; #whitesmoke64 $sql="UPDATE ".$prefix."_ele_sezioni set colore='#F5DEB3' where id_cons='$id_cons' and id_sez='$id_sez'"; #"WHEAT" 61 65 $res = $dbi->prepare("$sql"); 62 66 $res->execute(); -
trunk/admin/modules/Elezioni/ele_voti.php
r260 r262 514 514 if ((!$id_lista)){$tab="_ele_voti_lista";} else {$tab="_ele_voti_candidati";} 515 515 if(($genere==4 or ($genere==5 and $votog)) and !$id_lista) { 516 $sql="SELECT sum(t1.voti),t2.validi, t2.solo_gruppo,t2.contestati_lista,t2.voti_nulli,t2.bianchi,t2.nulli, 0,0,0 from ".$prefix."_ele_sezioni as t2 left join ".$prefix.$tab." as t1 on (t1.id_sez=t2.id_sez) where t2.id_sez=$id_sez group by t1.id_sez";516 $sql="SELECT sum(t1.voti),t2.validi, t2.solo_gruppo,t2.contestati_lista,t2.voti_nulli,t2.bianchi,t2.nulli,t2.contestati,0,0 from ".$prefix."_ele_sezioni as t2 left join ".$prefix.$tab." as t1 on (t1.id_sez=t2.id_sez) where t2.id_sez=$id_sez group by t1.id_sez"; 517 517 $result = $dbi->prepare("$sql"); 518 518 $result->execute(); … … 1132 1132 $riga[$y].= "<span class=\"td\"><input type=\"hidden\" name=\"op\" value=\"rec_add_votanti\"/>"; 1133 1133 $riga[$y].= "<input type=\"hidden\" name=\"id_cons_gen\" value=\"$id_cons_gen\"/>" 1134 ."<input type=\"hidden\" name=\"genere\" value=\"$genere\"/>" 1134 1135 ."<input type=\"hidden\" name=\"id_sez\" value=\"$id_sez\"/>" 1135 1136 ."<input type=\"hidden\" name=\"id_circ\" value=\"$id_circ\"/>" -
trunk/admin/modules/Elezioni/salva_aff.php
r258 r262 37 37 if (isset($_GET['id_comune'])) $id_comune=intval($_GET['id_comune']); else $id_comune='0'; 38 38 if (isset($_GET['id_gruppo'])) $id_gruppo=intval($_GET['id_gruppo']); else $id_gruppo='0'; 39 if (isset($_GET['genere'])) $genere=intval($_GET['genere']); else $genere='0'; 39 40 if (isset($_GET['delete'])) get_magic_quotes_gpc() ? $delete=$_GET['delete']:$delete=addslashes($_GET['delete']); else $delete=''; 40 41 global $prefix,$id_parz,$tempo,$username,$aid,$dbi,$genere; 41 /* ############42 $sql="SELECT orario,data FROM ".$prefix."_ele_rilaff where id_cons_gen=$id_cons_gen order by data,orario ";43 $res = $dbi->prepare("$sql");44 $res->execute();45 $num = $res->rowCount();46 $y=0;47 while(list($i,$a)=$result->fetch(PDO::FETCH_BOTH)) {48 $y++;49 $sql="SELECT * FROM ".$prefix."_ele_gruppo where id_cons='$id_cons' ";50 $res2 = $dbi->prepare("$sql");51 $res2->execute();52 for($i=1;$i<=$max;$i++){53 $idg="id_gruppo$i";$vnp="vnpl$i";$slp="slpl$i";$idlist="id_lista$i";54 if (isset($_GET[$vnp])) $vnpl[$i]=intval($_GET[$vnp]); else $vnpl[$i]='0';55 if (isset($_GET[$vot])) $voti[$i]=intval($_GET[$vot]); else $voti[$i]='0';56 if (isset($_GET[$slp])) $slpl[$i]=intval($_GET[$slp]); else $slpl[$i]='0';57 if (isset($_GET[$idlist])) $idlista[$i]=intval($_GET[$idlist]); else $idlista[$i]='0';58 $sololiste+=$slpl[$i];59 }60 }61 #############62 */63 42 64 43 if (!isset($fileout)) $fileout=''; … … 105 84 $res->execute(); 106 85 } 107 controllo_aff($id_cons,$id_sez,$id_parz); 86 #controllo_aff($id_cons,$id_sez,$id_parz); 87 include("ele_controlli.php"); 88 controllo_aff($id_cons,$id_sez,$id_parz); 89 include("ele_colora_sez.php"); 108 90 109 91 Header("Location: ".$BASE."admin.php?op=voti&id_cons_gen=$id_cons_gen&id_circ=$id_circ&id_sede=$id_sede&id_sez=$id_sez&ops=1&do=spoglio"); 110 92 111 93 112 function controllo_aff($id_cons,$id_sez,$id_parz){113 global $prefix,$dbi,$id_sede,$id_con_gen;114 ##############################115 # $sql="select * from ".$prefix."_ele_controllosez where id_cons='$id_cons' and id_sez='$id_sez'";116 # $resc = $dbi->prepare("$sql");117 # $resc->execute();118 # $conta=$resc->rowCount();119 $err=0;120 # $err2=0;121 $sql="select maschi,femmine from ".$prefix."_ele_sezioni where id_sez='$id_sez'";122 $res = $dbi->prepare("$sql");123 $res->execute();124 list($maschi,$femmine)=$res->fetch(PDO::FETCH_NUM);125 126 $sql="select voti_uomini,voti_donne,voti_complessivi from ".$prefix."_ele_voti_parziale where id_sez='$id_sez' and id_parz='$id_parz'";127 $res = $dbi->prepare("$sql");128 $res->execute();129 while(list($voti_u,$voti_d,$voti_t)=$res->fetch(PDO::FETCH_NUM))130 if(($voti_u+$voti_d!=$voti_t || $voti_u>$maschi || $voti_d>$femmine) and ($voti_u+$voti_d>0)) {$err=1; break;}131 /* if($conta){132 $aff=$resc->fetch(PDO::FETCH_BOTH);133 if($aff['status'])134 if ($aff['stato_val'] || $aff['stato_lis'] || $aff['stato_gru'] || $aff['stato_can']) $err2=1;135 }136 if($conta && !$err2) {137 $sql="update ".$prefix."_ele_controllosez set stato_aff='$err',status='$err' where id_cons='$id_cons' and id_sez='$id_sez'";138 $res = $dbi->prepare("$sql");139 $res->execute();140 } elseif($conta && !$err){141 $sql="update ".$prefix."_ele_controllosez set stato_aff='$err' where id_cons='$id_cons' and id_sez='$id_sez'";142 $res = $dbi->prepare("$sql");143 $res->execute();144 return;145 } else {146 $sql="insert into ".$prefix."_ele_controllosez values ('$id_sez','$id_cons','$err','0','0','0','0','$err')";147 $res = $dbi->prepare("$sql");148 $res->execute();149 }*/150 #######################151 $tipo='affluenze';152 $sql="select id from ".$prefix."_ele_controlli where tipo='$tipo' and id_sez='$id_sez' ";153 $res = $dbi->prepare("$sql");154 $res->execute();155 $righe=$res->rowCount();156 if($righe){157 while(list($id)=$res->fetch(PDO::FETCH_NUM)){158 if($id==$id_parz){159 if(!$err){160 $sql="delete from ".$prefix."_ele_controlli where tipo='$tipo' and id='$id_parz' ";161 $res = $dbi->prepare("$sql");162 $res->execute();163 164 }165 $err=0;166 break;167 }168 }169 }170 if($err){171 $sql="insert into ".$prefix."_ele_controlli value('$id_cons','$id_sez','$tipo','$id_parz')";172 $res = $dbi->prepare("$sql");173 $res->execute();174 }175 176 177 #######################178 include("ele_colora_sez.php");179 }180 181 94 ?> -
trunk/admin/modules/Elezioni/salva_gruppi.php
r260 r262 102 102 103 103 104 104 include("ele_controlli.php"); 105 105 controllo_votig($id_cons,$id_sez,$genere); 106 include("ele_colora_sez.php"); 106 107 107 108 if ($fileout) fclose($fp); … … 114 115 115 116 116 function controllo_votig($id_cons,$id_sez,$genere){117 global $prefix,$dbi,$id_sede,$id_cons_gen;118 ##############################119 $err=0; $err2=0;120 $sql="SELECT id_gruppo FROM ".$prefix."_ele_gruppo where id_cons='$id_cons'";121 $resref = $dbi->prepare("$sql");122 $resref->execute();123 $sql="SELECT max(voti_complessivi) FROM ".$prefix."_ele_voti_parziale where id_sez='$id_sez'";124 $res3 = $dbi->prepare("$sql");125 $res3->execute();126 list($voti)=$res3->fetch(PDO::FETCH_NUM);127 $sql="SELECT validi FROM ".$prefix."_ele_sezioni where id_sez='$id_sez' and id_cons='$id_cons' ";128 $res2 = $dbi->prepare("$sql");129 $res2->execute();130 list($validi) = $res2->fetch(PDO::FETCH_NUM);131 if($validi) {132 $status=0;133 $query="SELECT validi,nulli,bianchi,contestati,voti_nulli,solo_gruppo,validi_lista,contestati_lista,voti_nulli_lista,solo_lista FROM ".$prefix."_ele_sezioni as t1 where t1.id_sez='$id_sez'";134 $sql="$query";135 $res4 = $dbi->prepare("$sql");136 $res4->execute();137 list($validi, $nulli, $bianchi,$contestati,$votinulli)=$res4->fetch(PDO::FETCH_NUM);138 if (($validi+$nulli+$bianchi+$contestati+$votinulli)!=$voti)139 {$err=1;}140 }141 $tipo='gruppo';142 $sql="select id from ".$prefix."_ele_controlli where tipo='$tipo' and id_sez='$id_sez'";143 $res = $dbi->prepare("$sql");144 $res->execute();145 $righe=$res->rowCount();146 if($righe){147 if(!$err){148 $sql="delete from ".$prefix."_ele_controlli where tipo='$tipo' and id='$id_sez' ";149 $res = $dbi->prepare("$sql");150 $res->execute();151 }152 $err=0;153 }154 if($err){155 $sql="insert into ".$prefix."_ele_controlli value('$id_cons','$id_sez','$tipo','$id_sez')";156 $res = $dbi->prepare("$sql");157 $res->execute();158 }159 include("ele_colora_sez.php");160 161 }162 117 163 118 ?> -
trunk/admin/modules/Elezioni/salva_liste.php
r260 r262 88 88 $res = $dbi->prepare("$sql"); 89 89 $res->execute(); 90 $sql="delete from ".$prefix."_ele_voti_lista where id_cons='$id_cons' and id_sez='$id_sez'"; 91 $res = $dbi->prepare("$sql"); 92 $res->execute(); 93 $sql="delete from ".$prefix."_ele_controlli where tipo='lista' and id_sez='$id_sez' "; 94 $res = $dbi->prepare("$sql"); 95 $res->execute(); 96 $sql="update ".$prefix."_ele_sezioni set validi_lista='',contestati_lista='',voti_nulli_lista='',solo_gruppo='',solo_lista='' where id_cons='$id_cons' and id_sez='$id_sez'"; 97 $res = $dbi->prepare("$sql"); 98 $res->execute(); 90 if(!$id_lista){ 91 $sql="delete from ".$prefix."_ele_voti_lista where id_cons='$id_cons' and id_sez='$id_sez'"; 92 $res = $dbi->prepare("$sql"); 93 $res->execute(); 94 $sql="delete from ".$prefix."_ele_controlli where tipo='lista' and id_sez='$id_sez' "; 95 $res = $dbi->prepare("$sql"); 96 $res->execute(); 97 $sql="update ".$prefix."_ele_sezioni set validi_lista='',contestati_lista='',voti_nulli_lista='',solo_gruppo='',solo_lista='' where id_cons='$id_cons' and id_sez='$id_sez'"; 98 $res = $dbi->prepare("$sql"); 99 $res->execute(); 100 } 99 101 100 102 }elseif($id_lista){ … … 149 151 150 152 151 153 include("ele_controlli.php"); 152 154 controllo_votil($id_cons,$id_sez,$id_lista); 153 155 include("ele_colora_sez.php"); 156 154 157 if ($fileout) fclose($fp); 155 158 $BASE=substr($_SERVER['PHP_SELF'], 0, strrpos($_SERVER['REQUEST_URI'], "/")-16); … … 161 164 162 165 163 function controllo_votil($id_cons,$id_sez,$id_lista){164 global $prefix,$dbi,$id_sede,$id_cons_gen,$validi;165 ##############################166 $err=0; $err2=0;167 if($id_lista){168 $sql="SELECT preferenze FROM ".$prefix."_ele_cons_comune where id_cons='$id_cons'";169 $res = $dbi->prepare("$sql");170 $res->execute();171 list($prefs)=$res->fetch(PDO::FETCH_NUM);172 $sql="select voti from ".$prefix."_ele_voti_lista where id_lista='$id_lista' and id_sez='$id_sez'";173 $res = $dbi->prepare("$sql");174 $res->execute();175 list($votil)=$res->fetch(PDO::FETCH_NUM);176 $sql="SELECT sum(voti),max(voti) FROM ".$prefix."_ele_voti_candidati where id_sez='$id_sez' and id_cand in (select id_cand from ".$prefix."_ele_candidati where id_lista='$id_lista')";177 $res = $dbi->prepare("$sql");178 $res->execute();179 list($votic,$mvc)=$res->fetch(PDO::FETCH_NUM);180 if(($votic*$prefs)>$votil || $mvc>$votil)181 $err=1;182 }else{183 $sql="select id_gruppo from ".$prefix."_ele_lista where id_lista='$id_lista'";184 $res = $dbi->prepare("$sql");185 $res->execute();186 list($idg)=$res->fetch(PDO::FETCH_NUM);187 $sql="SELECT id_gruppo, voti, solo_gruppo FROM ".$prefix."_ele_voti_gruppo where id_sez='$id_sez'";188 $resref = $dbi->prepare("$sql");189 $resref->execute();190 $totlis=0;191 $totgru=0;192 $totsg=0;193 $totsl=0;194 $sql="SELECT validi,validi_lista,contestati_lista,voti_nulli_lista,solo_lista FROM ".$prefix."_ele_sezioni where id_cons='$id_cons' and id_sez='$id_sez'";195 $res = $dbi->prepare("$sql");196 $res->execute();197 list($votiv,$validil,$contestatil,$nullil,$solol) = $res->fetch(PDO::FETCH_NUM);198 while (list($idg,$votig,$svg)=$resref->fetch(PDO::FETCH_NUM)) {199 $sql="SELECT sum(voti), sum(solo_lista) FROM ".$prefix."_ele_voti_lista where id_sez='$id_sez' and id_lista in (select id_lista from ".$prefix."_ele_lista where id_gruppo='$idg')";200 $res2 = $dbi->prepare("$sql");201 $res2->execute();202 $totgru+=$votig;203 $totsg+=$svg;204 if($res2->rowCount()){205 list($votil,$svl)=$res2->fetch(PDO::FETCH_NUM);206 $totlis+=$votil;207 $totsl+=$svl;208 if(($votig+$svl)<($votil+$svg))209 $err=1;210 }211 212 }213 if ($validil+$contestatil+$nullil+$solol+$totsg!=$votiv and $validil+$contestatil+$nullil+$solol>0) $err=1;214 }215 216 $tipo='lista';217 $sql="select id from ".$prefix."_ele_controlli where tipo='$tipo' and id_sez='$id_sez'";218 $res = $dbi->prepare("$sql");219 $res->execute();220 $righe=$res->rowCount();221 if($righe){222 if(!$err){223 $sql="delete from ".$prefix."_ele_controlli where tipo='$tipo' and id='$id_sez' ";224 $res = $dbi->prepare("$sql");225 $res->execute();226 }227 $err=0;228 }229 if($err){230 $sql="insert into ".$prefix."_ele_controlli value('$id_cons','$id_sez','$tipo','$id_sez')";231 $res = $dbi->prepare("$sql");232 $res->execute();233 }234 include("ele_colora_sez.php");235 236 166 237 167 238 239 240 }241 242 168 ?> -
trunk/admin/modules/Elezioni/salva_ref.php
r261 r262 92 92 93 93 94 95 controllo_votir($id_cons,$id_sez ,$genere,$id_gruppo);96 94 include("ele_controlli.php"); 95 controllo_votir($id_cons,$id_sez); 96 include("ele_colora_sez.php"); 97 97 if ($fileout) fclose($fp); 98 98 $BASE=substr($_SERVER['PHP_SELF'], 0, strrpos($_SERVER['REQUEST_URI'], "/")-16); … … 104 104 105 105 106 function controllo_votir($id_cons,$id_sez,$genere){107 global $prefix,$dbi,$id_sede,$id_cons_gen;108 ##############################109 $err=0; $err2=0;110 $sql="SELECT id_gruppo FROM ".$prefix."_ele_gruppo where id_cons='$id_cons'";111 $resref = $dbi->prepare("$sql");112 $resref->execute();113 $numscru=$resref->rowCount(); $rifscru=0;114 while(list($idrefgruppo)=$resref->fetch(PDO::FETCH_NUM)) {115 $sql="SELECT si,no,validi,nulli,bianchi,contestati FROM ".$prefix."_ele_voti_ref where id_sez='$id_sez' and id_gruppo='$idrefgruppo'";116 $res2 = $dbi->prepare("$sql");117 $res2->execute();118 $refscru=$res2->rowCount();119 $sql="SELECT max(voti_complessivi) FROM ".$prefix."_ele_voti_parziale where id_sez='$id_sez' and id_gruppo='$idrefgruppo'";120 $res3 = $dbi->prepare("$sql");121 $res3->execute();122 list($voti)=$res3->fetch(PDO::FETCH_NUM);123 $rifscru++;124 list($si,$no,$validi,$nulli,$bianchi,$contestati)=$res2->fetch(PDO::FETCH_NUM);125 if(($si+$no==$validi) and ($validi+$nulli+$bianchi+$contestati==$voti))126 continue;127 else {$err=1; break;}128 106 129 130 131 #############132 $tipo='referendum';133 $sql="select id from ".$prefix."_ele_controlli where tipo='$tipo' and id_sez='$id_sez' and id='$idrefgruppo' ";134 $res = $dbi->prepare("$sql");135 $res->execute();136 $righe=$res->rowCount();137 if($righe){138 if(!$err){139 $sql="delete from ".$prefix."_ele_controlli where tipo='$tipo' and id='$id_sez' ";140 $res = $dbi->prepare("$sql");141 $res->execute();142 }143 $err=0;144 }145 if($err){146 $sql="insert into ".$prefix."_ele_controlli value('$id_cons','$id_sez','$tipo','$id_sez')";147 $res = $dbi->prepare("$sql");148 $res->execute();149 }150 #############151 }152 include("ele_colora_sez.php");153 }154 107 155 108 ?> -
trunk/admin/modules/Elezioni/salva_voti.php
r261 r262 78 78 if ($fileout) fwrite($fp,"$sql;\n"); */ 79 79 #} 80 include("ele_controlli.php"); 80 81 controllo_voti($id_cons,$id_sez); 82 include("ele_colora_sez.php"); 81 83 82 84 if ($fileout) fclose($fp); … … 88 90 89 91 90 91 function controllo_voti($id_cons,$id_sez){ 92 global $prefix,$dbi,$id_sede,$id_con_gen,$genere; 93 ############################## 94 $sql="select * from ".$prefix."_ele_controllosez where id_cons='$id_cons' and id_sez='$id_sez'"; 95 $resc = $dbi->prepare("$sql"); 96 $resc->execute(); 97 $conta=$resc->rowCount(); 98 $err=0; $err2=0; 99 $sql="SELECT id_gruppo FROM ".$prefix."_ele_gruppo where id_cons='$id_cons'"; 100 $resref = $dbi->prepare("$sql"); 101 $resref->execute(); 102 if($genere==0){ 103 $numscru=$resref->rowCount(); $rifscru=0; 104 while(list($idrefgruppo)=$resref->fetch(PDO::FETCH_NUM)) { 105 $sql="SELECT si,no,validi,nulli,bianchi,contestati FROM ".$prefix."_ele_voti_ref where id_sez='$id_sez' and id_gruppo='$idrefgruppo'"; 106 $res2 = $dbi->prepare("$sql"); 107 $res2->execute(); 108 $refscru=$res2->rowCount(); 109 $sql="SELECT max(voti_complessivi) FROM ".$prefix."_ele_voti_parziale where id_sez='$id_sez' and id_gruppo='$idrefgruppo'"; 110 $res3 = $dbi->prepare("$sql"); 111 $res3->execute(); 112 list($voti)=$res3->fetch(PDO::FETCH_NUM); 113 $rifscru++; 114 list($si,$no,$validi,$nulli,$bianchi,$contestati)=$res2->fetch(PDO::FETCH_NUM); 115 if(($si+$no==$validi) and ($validi+$nulli+$bianchi+$contestati==$voti)) 116 continue; 117 else {$err=1; break;} 118 } 119 }else{ 120 #per le altre consultazione 121 $sql="SELECT max(voti_complessivi) FROM ".$prefix."_ele_voti_parziale where id_sez='$id_sez'"; 122 $res3 = $dbi->prepare("$sql"); 123 $res3->execute(); 124 list($voti)=$res3->fetch(PDO::FETCH_NUM); 125 $sql="SELECT validi FROM ".$prefix."_ele_sezioni where id_sez='$id_sez' and id_cons='$id_cons' "; 126 $res2 = $dbi->prepare("$sql"); 127 $res2->execute(); 128 list($validi) = $res2->fetch(PDO::FETCH_NUM); 129 if($validi) { 130 $status=0; 131 $query="SELECT validi,nulli,bianchi,contestati,voti_nulli,solo_gruppo,validi_lista,contestati_lista,voti_nulli_lista,solo_lista FROM ".$prefix."_ele_sezioni as t1 where t1.id_sez='$id_sez'"; 132 $sql="$query"; 133 $res4 = $dbi->prepare("$sql"); 134 $res4->execute(); 135 list($validi, $nulli, $bianchi,$contestati,$votinulli)=$res4->fetch(PDO::FETCH_NUM); 136 if (($validi+$nulli+$bianchi+$contestati+$votinulli)!=$voti) 137 {$err=1;} 138 } 139 } 140 $tipo='votanti'; 141 $sql="select id from ".$prefix."_ele_controlli where tipo='$tipo' and id_sez='$id_sez' "; 142 $res = $dbi->prepare("$sql"); 143 $res->execute(); 144 $righe=$res->rowCount(); 145 if($righe){ 146 if(!$err){ 147 $sql="delete from ".$prefix."_ele_controlli where tipo='$tipo' and id='$id_sez' "; 148 $res = $dbi->prepare("$sql"); 149 $res->execute(); 150 } 151 $err=0; 152 } 153 if($err){ 154 $sql="insert into ".$prefix."_ele_controlli value('$id_cons','$id_sez','$tipo','$id_sez')"; 155 $res = $dbi->prepare("$sql"); 156 $res->execute(); 157 } 158 include("ele_colora_sez.php"); 159 } 92 160 93 161 94 ?>
Note:
See TracChangeset
for help on using the changeset viewer.
