85 lines
2.7 KiB
PHP
85 lines
2.7 KiB
PHP
<?php
|
|
include('include/entete.php');
|
|
include('include/entete_cfa.php');
|
|
include('config/config.inc.php');
|
|
include('config/lib.inc.php');
|
|
$maCleDeCryptage = getCleDeCryptage();
|
|
|
|
if(isset($_POST['action']) && $_POST['action']=='go_jpo' && isset($_POST['detailsJpo'])){
|
|
|
|
|
|
foreach($_POST as $cle=>$val) $$cle=$val;
|
|
$detailsJpo = utf8_encode($detailsJpo);
|
|
$detailsJpo=crypter($maCleDeCryptage,$detailsJpo);
|
|
$dateCreation = date('Y-m-d');
|
|
|
|
|
|
//Impossible de créer une jpo si une jpo existe déjà pour le CFA/LP
|
|
$query="select * from jpo where id_eta=:etaID";
|
|
$db = connect_base();
|
|
$queryRequest = $db->prepare( $query );
|
|
$queryRequest->bindParam( ':etaID', $_SESSION['cfa_num'], PDO::PARAM_STR );
|
|
$queryRequest->execute();
|
|
$test=$queryRequest->rowCount();
|
|
if($test>0){
|
|
$_SESSION['msg']='Cet établissement a déjà renseigné ses journées portes ouvertes';
|
|
header('location:po-cfa.php');
|
|
exit();
|
|
}
|
|
|
|
|
|
$query = 'insert into jpo (id_eta,details_jpo,date_create_jpo) values (:num_eta,:details_jpo, :date_create_jpo)';
|
|
$db = connect_base();
|
|
$queryRequest = $db->prepare( $query );
|
|
$queryRequest->bindParam( ':num_eta', $_SESSION['cfa_num'], PDO::PARAM_INT );
|
|
$queryRequest->bindParam( ':details_jpo', $detailsJpo, PDO::PARAM_STR);
|
|
$queryRequest->bindParam( ':date_create_jpo', $dateCreation, PDO::PARAM_STR );
|
|
$queryRequest->execute();
|
|
|
|
$_SESSION['msg']='Vos journées portes ouvertes ont été créées.';
|
|
header('location:po-cfa.php');
|
|
exit();
|
|
|
|
}
|
|
|
|
// Modification de la JPO enregistrée
|
|
if(isset($_POST['action']) && $_POST['action']=='mo_jpo'){
|
|
foreach($_POST as $cle=>$val) $$cle=$val;
|
|
|
|
if(!isset($id_jpo) || empty($id_jpo)){
|
|
header('location:po-cfa.php');
|
|
exit();
|
|
}
|
|
|
|
|
|
$query="select * from jpo where id_jpo=:id_cap and id_eta=:num_eta";
|
|
$db = connect_base();
|
|
$queryRequest = $db->prepare( $query );
|
|
$queryRequest->bindParam( ':id_cap', $id_jpo, PDO::PARAM_INT );
|
|
$queryRequest->bindParam( ':num_eta', $_SESSION['cfa_num'], PDO::PARAM_INT );
|
|
$queryRequest->execute();
|
|
if($queryRequest->rowCount()==0){
|
|
header('location:po-cfa.phpp');
|
|
exit();
|
|
}else{
|
|
$dataActual=$queryRequest->fetchAll();
|
|
$actualdetails = $dataActual[0]['details_jpo'];
|
|
}
|
|
$newJpoDetails = crypter($maCleDeCryptage,utf8_encode($detailsJpo));
|
|
$newDate = date('Y-m-d');
|
|
|
|
|
|
$query='update jpo set details_jpo=:details_jpo, date_create_jpo=:date where id_jpo=:id_jpo';
|
|
$queryRequest = $db->prepare( $query );
|
|
$queryRequest->bindParam( ':details_jpo', $newJpoDetails, PDO::PARAM_STR );
|
|
$queryRequest->bindParam( ':date', $newDate, PDO::PARAM_STR );
|
|
$queryRequest->bindParam( ':id_jpo', $id_jpo, PDO::PARAM_INT );
|
|
$queryRequest->execute();
|
|
|
|
$_SESSION['msg']='Les journées portes ouvertes ont bien été modifiées.';
|
|
header('location:po-cfa.php');
|
|
exit();
|
|
|
|
|
|
}
|