\n"; if($validation==0){ $validation=1; echo ""; echo ""; echo ""; // choix scrutin $sql="select scrutin,libelle from scrutin where solde ='Oui'"; $res = $f -> db -> query($sql); if (DB :: isError($res)) die($res->getMessage()."erreur SELECT ".$sql); echo ""; // choix scrutin $sql="select scrutin,libelle from scrutin where solde !='Oui'"; $res = $f -> db -> query($sql); if (DB :: isError($res)) die($res->getMessage()."erreur SELECT ".$sql); echo ""; // choix poste $sql="select poste,poste from poste where nature ='candidature'"; $res = $f -> db -> query($sql); if (DB :: isError($res)) die($res->getMessage()."erreur SELECT ".$sql); echo ""; If ($_SESSION['profil'] >= $f -> droit){ echo ""; echo "

".$f -> lang("transfert")." ".$f -> lang("de")." ".$f -> lang("candidature")."
".$f -> lang("selectionnez")." ".$f -> lang("un")." ".$f -> lang("scrutin")." ".$f -> lang("solde")."
".$f -> lang("selectionnez")." ".$f -> lang("un")." ".$f -> lang("scrutin")." ".$f -> lang("encours")."
".$f -> lang("selectionnez")." ".$f -> lang("un")." ".$f -> lang("poste")."
"; echo ""; echo " "; echo $f -> lang("attention")." ".$f -> lang("traitement")." ".$f -> lang("non")." ".$f -> lang("controle")." , ".$f -> lang("decision")." = ".$f -> lang("non")." !"; }else echo "
Droits insuffisants ou reconnectez-vous."; echo ""; echo "

"; }else{ // validation = 1 echo "

"; // verification existence echo "

".$f -> lang("traitement").""; $sql = "select count(candidature) from candidature where scrutin ='". $scrutin."' and poste ='".$poste."' and decision = 'Oui'"; $nb = $f -> db -> getOne($sql); echo "
".$f -> lang("il_existe")." ".$nb." ".$poste.$f -> lang("pluriel")." ".$f -> lang("pour")." ".$scrutin." ".$f -> lang("avec")." ".$f -> lang("decision")." = ".$f -> lang("oui")."

"; // selection $sql = "select bureau,recuperation,periode,candidature.agent,nom,prenom from candidature inner join agent on agent.agent=candidature.agent where scrutin ='". $scrutinsolde."' and candidature.poste ='".$poste."' and decision = 'Oui'"; $res = $f -> db -> query($sql); if (DB :: isError($res)) die($res->getMessage()."erreur SELECT ".$sql); while ($row=& $res->fetchRow(DB_FETCHMODE_ASSOC)){ $candidature = $f -> db -> nextId('candidature'); $sql="insert into candidature (candidature,scrutin,decision,periode,poste,bureau,recuperation,note,agent) values('".$candidature."','".$scrutin."','Non','".$row['periode']."','".$poste."','". $row['bureau']."','".$row['recuperation']."','transfert ".$scrutinsolde. "','".$row['agent']."')"; $res1 = $f -> db -> query($sql); if (DB :: isError($res1)) die($res1->getMessage()."erreur maj ".$sql); echo "
".$row['agent']." ".$row['nom']." ".$row['prenom']." ".$row['bureau'].' '.$row['periode']."
"; } echo ""; echo "

"; echo "

"; } echo "