<div id="form-container" class="ui-widget-content ui-corner-bottom"> <div class="xhtml_form"> <form id="user_form" method="post" action="index.php?controleur=session&tache=rechercher_session"> <p style="padding:7px;"> Renseigner au moins un critère de recherche (une recherche sans critère affichera la totalité des sessions)</p> <table class="formulaire"> <tr> <td class="form_desc">Date de session </td><td> <input type="text" id="date_session" name="date_session" <?php if ($_GET['tache'] == "supprimer_session") { echo 'disabled '; } ?> value="<?php if (isset($page['session'])) { echo date_en_to_fr($page['session']['date_session']); } elseif (isset($_POST['date_session'])) { echo $_POST['date_session']; } ?> "/> </td><td class="form_desc_2">Durée de session (jours) </td><td> <input type="text" name="duree_session" <?php if ($_GET['tache'] == "supprimer_session") { echo 'disabled '; } ?> value="<?php if (isset($page['session'])) { echo $page['session']['duree_session']; } elseif (isset($_POST['duree_session'])) {
?> value="<?php if (isset($page['item'])) { echo date_en_to_fr($page['item']['date_creation']); } ?> "/> </td><td class="form_desc_2">Date modification </td><td> <input type="text" name="modif" <?php if ($_GET['tache'] == "supprimer_item" || $_GET['tache'] == "visualiser_item") { echo 'disabled '; } ?> value="<?php if (isset($page['item'])) { echo date_en_to_fr($page['item']['date_modification']); } ?> "/> </td></tr> <?php } ?> <tr><td class="form_desc">Résolution *</td><td> <select name="resolution" <?php if ($_GET['tache'] == "supprimer_item" || $_GET['tache'] == "visualiser_item" || $_GET['tache'] == "dupliquer_item") { echo 'disabled '; } ?> > <?php
function recherche_candidat($nid, $naissance, $nom, $prenom, $genre, $mail, $cirfa) { global $db; $where = " genre.id_genre=candidat.id_genre and candidat.id_genre like '{$genre}'"; if ($nid != '') { $where .= " and nid_candidat='{$nid}' "; } if ($naissance != '') { $where .= " and date_naissance_candidat like '%{$naissance}%' "; } if ($nom != '') { $where .= " and (nom_usage_candidat like '%" . utf8_decode(maj_strtoupper($nom)) . "%' or nom_naissance_candidat like '%" . utf8_decode(maj_strtoupper($nom)) . "%') "; } if ($prenom != '') { $where .= " and (prenom_candidat like '%" . utf8_decode(maj_strtoupper($prenom)) . "%' or prenom_2_candidat like '%" . utf8_decode(maj_strtoupper($prenom)) . "%') "; } if ($mail != '') { $where .= " and mail_candidat like '%{$mail}%' "; } if ($cirfa != '%') { $where .= " and candidat.cirfa = {$cirfa} "; } /*On verifie si le login n'existe pas*/ $sql_verif = "select id_candidat, nid_candidat, nom_usage_candidat,nom_naissance_candidat, prenom_candidat , date_naissance_candidat, lieu_naissance_candidat, libelle_genre,libelle\r\n\t\t\t\tfrom candidat, genre, cirfa\r\n\t\t\t\t where candidat.cirfa=cirfa.id_cirfa and {$where};"; $req_verif = $db->prepare($sql_verif); if (!$req_verif->execute()) { write_log('Erreur SQL:' . $sql_verif . ' sur fonction : ' . __FUNCTION__ . ' ligne : ' . __LINE__); } $res = $req_verif->fetchAll(PDO::FETCH_ASSOC); $reponse = (object) array('records' => "", 'total' => "", 'page' => "", 'rows' => ""); $count = sizeof($res); //$total=ceil($count/$limit); $reponse->page = 1; $reponse->total = $count; $reponse->records = $count; $i = 0; foreach ($res as $key => $user) { foreach ($res[$key] as $k => $v) { $res[$key][$k] = utf8_encode($v); } $res[$key]['nid_candidat'] = utf8_encode($user['nid_candidat']) . "|" . $user['id_candidat']; $res[$key]['id_candidat-a'] = "<a href='index.php?controleur=administration&tache=modifier_candidat&id=" . $user['id_candidat'] . "'>Modifier</a>" . ' | ' . "<a href='index.php?controleur=administration&tache=supprimer_candidat&id=" . $user['id_candidat'] . "'>Supprimer</a>"; } foreach ($res as $line) { $reponse->rows[$i]['id'] = $line['id_candidat']; $reponse->rows[$i]['cell'] = array($line['nid_candidat'], $line['nom_usage_candidat'], $line['nom_naissance_candidat'], $line['prenom_candidat'], date_en_to_fr($line['date_naissance_candidat']), $line['lieu_naissance_candidat'], $line['libelle'], $line['libelle_genre'], $line['id_candidat-a']); $i++; } return $reponse; //return $res_verif; }
</div> <div id="form-container" class="ui-widget-content ui-corner-bottom"> <div class="xhtml_form"> <?php if (isset($page['candidature']) && $page['candidature'] != null) { ?> <table> <tr><th>Session</th><th>Rang</th><th>Statut inscription</th><th>Motif</th></tr> <?php foreach ($page['candidature'] as $c) { ?> <tr><td><a href="index.php?controleur=session&tache=visualiser_session&id=<?php echo $c['id_session']; ?> "><?php echo date_en_to_fr($c['date_session']); ?> </a></td><td><?php echo $c['rang_session']; ?> </td><td><?php if ($c['statut_inscription'] == 0) { echo 'Inscrit'; } elseif ($c['statut_inscription'] == 1) { echo 'Reportée'; } else { echo 'Session terminée'; } ?> </td><td><?php echo utf8_encode($c['libelle_long_motif']);
<div id="form-container" class="ui-widget-content ui-corner-bottom"> <div class="xhtml_form"> <table> <tr><th>Test</th><th>Date</th><th>Motif</th><th>Score</th><th>Action</th></tr> <?php foreach ($page['resultats'] as $result) { if (isset($result['id_test'])) { ?> <tr><td><a href="index.php?controleur=test&tache=visualiser_test&id=<?php echo $result['id_test']; ?> "><?php echo $result['code_test']; ?> </a></td><td><?php echo date_en_to_fr($result['date_passation']); ?> </td><td><?php if (isset($result['motifs'])) { foreach ($result['motifs'] as $motif) { echo $motif['libelle_court_motif'] . '<br/>'; } } ?> </td> <td><?php if (isset($result['score'])) { foreach ($result['score'] as $score) { echo $score . '<br/>'; } }
<tr> <td class="form_desc">Date de mise en production </td><td> <input id="date_session" type="text" name="date_mise_en_prod" disabled value="<?php if (isset($page['test'])) { echo date_en_to_fr($page['test']['date_mise_en_prod']); } elseif (isset($_POST['date_mise_en_prod'])) { echo date_en_to_fr($_POST['date_mise_en_prod']); } ?> "/> </td><td class="form_desc_2">Date de retrait </td><td> <input id="date_retrait" type="text" name="date_retrait" disabled value="<?php if (isset($page['test'])) { echo date_en_to_fr($page['test']['date_retrait']); } elseif (isset($_POST['date_retrait'])) { echo date_en_to_fr($_POST['date_retrait']); } ?> "/> </td></tr> <?php } ?> <tr> <tr> <td class="form_desc">Sphère * </td><td> <select onchange="show_facteur()" name="id_sphere" id="id_sphere" <?php if ($_GET['tache'] == "supprimer_test" || $_GET['tache'] == "visualiser_test" || $_GET['tache'] == "dupliquer_test" || $_GET['tache'] == "production_test") { echo 'disabled '; } ?> >
?> " style="" class=""><ins class="session"> </ins><?php echo $id . ' ' . $candidat['code_organisme'] . ' ' . count_candidat_session($candidat['id_session']) . '/' . $candidat['nb_candidats_max']; ?> </a></li> <?php } } else { $min = date("Y-m-d", strtotime("-7 days")); $max = date("Y-m-d", strtotime("+14 days")); ?> <li class="node-class closed " style="font-style: normal; font-size: x-small;">Aucune session du <?php echo date_en_to_fr($min); ?> au <?php echo date_en_to_fr($max); ?> </li> <?php } ?> </ul></div> </div> </div> </div> <div style="display: block;" id="section-actions"><div id="action-title" class="ui-widget ui-widget-header ui-state-default container-title ui-corner-top">Actions</div> <div id="action-items" class="session_item ui-widget ui-widget-content ui-corner-bottom"> <div id="action_search"> <a class="nav" href="index.php?controleur=session&tache=rechercher_session" title="Rechercher"> <img src="./images/search.png"><br>