1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67
| <?php
// On appelle la session
session_start();
// enregistrement dans la table situations
include('dates.php');
/*$date_debut = "$annee1$mois1$jours1";
$date_prevue = "$annee2$mois2$jours2";
$date_reelle = "$annee3$mois3$jours3";*/
$dateamj=date("Ymd");
$date_debut=save_date($date_debut);
$date_fin_prevue=save_date($date_fin_prevue);
$date_fin_reelle=save_date($date_fin_reelle);
include('connection.php3');
$requeteinsert2 = "INSERT INTO
situations
(num_candidat, categorie, commentaire, date_debut, date_fin_prevue, date_fin_reelle, date_amj, conseiller, idtemp, operateur1, operateur2)
VALUES
('$num_candidat', '$type_situation', '$commentaire', '$date_debut', '$date_fin_prevue', '$date_fin_reelle', '$dateamj', '$conseiller', '$idtemp_situ', '$partenaire1', '$partenaire2' )";
$resultsubmit2 = mysql_query ($requeteinsert2,$idConnexion);
// on enregistre dans la table dossier_situ(x) concernée
switch ($type_situation)
{
case 1:
// situ DE
$requete = "INSERT INTO dossier_situ1 (num_candidat, idtemp, type_situ)
VALUES
( '$num_candidat', '$idtemp_situ', '$type_situ' ) ";
$result = mysql_query ($requete,$idConnexion);
break;
case 2:
// situ Emploi
$requete2 = "INSERT INTO dossier_situ2 (num_candidat, idtemp, type_contrat, employeur, rome, nb_heures, interruption, crci)
VALUES
( '$num_candidat', '$idtemp_situ', '$contrat', '$num_entreprisemer', '$rome1_candidat', '$nb_heures', '$interruption', '1' ) ";
$result2 = mysql_query ($requete2,$idConnexion);
break;
case 3:
// situ Formation
$requete3 = "INSERT INTO dossier_situ3 (num_candidat, idtemp, type_formation, organisme, intitule, metier, niveau, obtention, interruption)
VALUES
( '$num_candidat', '$idtemp_situ', '$type_formation', '$organisme', '$intitule', '$rome1_candidat', '$niveau', '$obtention', '$interruption' ) ";
$result3 = mysql_query ($requete3,$idConnexion);
break;
case 4:
// situ Formation
$requete4 = "INSERT INTO dossier_situ4 (num_candidat, idtemp, type_formation, organisme, employeur, intitule, metier, niveau, obtention, interruption, crci)
VALUES
( '$num_candidat', '$idtemp_situ', '$type_formation', '$organisme', '$num_entreprisemer', '$intitule', '$rome1_candidat', '$niveau', '$obtention', '$interruption' , '1') ";
$result4 = mysql_query ($requete4,$idConnexion);
break;
}
header("Location: situations.php?deb=0");
?> |
Partager