"; if($validation==0){ echo "Transfert bureau à la prefecture

"; echo ""; echo "

"; echo "Code collectivite, departement circonscription a saisir en table collectivie
"; echo "Code depot de liste a remplir en table election_candidat
"; echo "Code prefecture du canton a saisir en table canton
"; echo "

Note prefecture Cantonale
"; echo "

Note prefecture Presidentielle
"; echo "

Note prefecture legislative
"; }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); // type election if($row['typeelection']== 'MUN') echo $_SESSION['election']['election']." est une election municipale - voir procedure speciale
"; // correspondance a verifier *** switch ($row['typeelection']) { case "CAN": $scrutin="CN"; break; case "LEG": $scrutin="LG"; //*** break; case "PRE": $scrutin="PR"; //*** break; case "REF": $scrutin="RF"; //*** break; case "REG": $scrutin="RG"; //*** break; case "EUR": $scrutin="EU"; //*** break; case "MUN": $scrutin="MN"; break; } // canton if($scrutin=="CN"){ $sql="select canton_prefecture from canton where canton = '". $row['election_canton']."'"; $canton = $db -> getOne ($sql); }else $canton=""; // ligne1 $ligne1= $scrutin.";"; $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.= str_pad($canton,2,"0", STR_PAD_LEFT).";"; $export.= str_pad($circonscription,2,"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.= "00000000;"; // nbre de bulletin blanc 8*0 $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']; // candidat $export.= $nbcandidat.";"; 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=substr($export,0,strlen($export)-1); $export.="\n"; } } $res -> free (); // ecriture des fichiers en tmp echo ""; echo ""; echo ""; echo ""; echo ""; $verif1=$votant-($exprime+$nul); if($verif1 !=0) echo ""; echo ""; $verif2=$exprime-$totalcandidat; if($verif2 !=0) echo ""; echo ""; 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."_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."_bureau.csv sauvegarde

"; $affiche= str_replace("\n","
",$export); echo $affiche; }//fin validation //======================================================================= echo "