"; echo ""; echo "
Elections MN2008 - Municipales
"; echo "Code collectivite et departement a saisir en table collectivie
"; echo "Code depot de liste a remplir election candidat
"; echo "
Note MN2008";
}else{
echo "indicatif : ".$indicatif.""; // données election $sql= "select * from election where election ='".$_SESSION['election']['election']."'"; $res = $db -> query ($sql); if (DB :: isError ($res)) die ($res -> getMessage ()." Erreur ".$sql); else { $row =& $res -> fetchRow (DB_FETCHMODE_ASSOC); //sequence à creer if($row['typeelection']!= 'MUN') echo $_SESSION['election']['election']." n est pas une election municipale
"; $ligne1= "MN;"; $ligne1.= substr($row['election_date'],0,4).";"; $ligne1.= $row['election_tour'].";"; $ligne1.= $departement.";"; // code departement collectivite $ligne1.= $commune.";"; // code insee collectivite // nombre de candidat $nbcandidat = str_pad($row['election_nbcandidat'],2,"0", STR_PAD_LEFT); } $res -> free (); // liste prefecture $sql= "select liste_prefecture from election_candidat where election ='". $_SESSION['election']['election']."' order by election_candidat_ordre"; $res = $db -> query ($sql); if (DB :: isError ($res)) die ($res -> getMessage ()." Erreur ".$sql); else { $k=1; while ($row=& $res->fetchRow(DB_FETCHMODE_ASSOC)){ $liste[$k]=str_pad($row['liste_prefecture'],3,"0", STR_PAD_LEFT); $k++; } } $res -> free (); // resultat $sql= "select * from resultat where election ='".$_SESSION['election']['election']."'"; $res = $db -> query ($sql); if (DB :: isError ($res)) die ($res -> getMessage ()." Erreur ".$sql); else { while ($row=& $res->fetchRow(DB_FETCHMODE_ASSOC)){ $seq++; $sequence=str_pad($seq,4,"0", STR_PAD_LEFT); $export.= $sequence.";".$ligne1.str_pad($row['bureau'],4,"0", STR_PAD_LEFT).";"; $export.= $indicatif.";"; $export.= str_pad($row['inscrit'],8,"0", STR_PAD_LEFT).";"; $abstention = $row['inscrit']- $row['votant']; $export.= str_pad($abstention,8,"0", STR_PAD_LEFT).";"; $export.= str_pad($row['votant'],8,"0", STR_PAD_LEFT).";"; $export.= ";"; // votant fe a vide $export.= str_pad($row['nul'],8,"0", STR_PAD_LEFT).";"; $export.= str_pad($row['exprime'],8,"0", STR_PAD_LEFT).";"; // total pour verification $inscrit=$inscrit+$row['inscrit']; $votant=$votant+$row['votant']; $nul=$nul+$row['nul']; $exprime=$exprime+$row['exprime']; $export.= $nbcandidat.";"; // candidat for($i=1;$i<=$nbcandidat;$i++){ $export.= $liste[$i].";"; $export.= str_pad($row['candidat'.$i],8,"0", STR_PAD_LEFT).";;"; // code depot de liste ? $totalcandidat=$totalcandidat+ $row['candidat'.$i]; } $export.="\n"; } } $res -> free (); // ecriture des fichiers en tmp echo "
| verification: | |
| Total inscrits | ".$inscrit." |
| Total votants | ".$votant." |
| Total nul | ".$nul." |
| Total exprime | ".$exprime." |
| *** ATTENTION ERREUR votant/exprime+nul *** | |
| verification : votant - (exprime + nul) = 0 | ".$verif1." |
| *** ATTENTION ERREUR exprime/totalcandidat *** | |
| verification : exprime - totalcandidat = 0 | ".$verif2." |
"; $fichier = "../tmp/".$departement.$commune."_mn_bureau.csv"; $inf = fopen($fichier,"w"); //$export=substr($export,0,strlen($export)-1); // un \n en trop fwrite($inf,$export); fclose($inf); echo "fichier ../tmp/".$departement.$commune."_mn_bureau.csv sauvegarde
"; $affiche= str_replace("\n","
",$export); echo $affiche; }//fin validation //======================================================================= echo "