function recuperer_OMI($recherche, $type)
{
//Récupération des données
$q1 = "SELECT * FROM MISSION M WHERE M.MIS_NO=" . $_GET['recherche'];
$r1 = $GLOBALS['connexion']->query($q1)->fetch_assoc();
$query = "SELECT * FROM PROJET P LEFT JOIN COLLABORATEUR COL ON COL.COL_NO=P.COL_NO, CONTACT_CLIENT CTC, CLIENT C WHERE C.CLI_NO=P.CLI_NO AND CTC.CTC_NO=P.CTC_NO AND P.PRO_NO=" . $r1['PRO_NO'];
$row = $GLOBALS['connexion']->query($query)->fetch_assoc();
$query_getNseq = "SELECT MAX(SUBSTRING(MIS_NSEQUENTIEL,11,3)) AS NSEQ FROM MISSION WHERE SUBSTRING(MIS_NSEQUENTIEL,7,4)='" . date("Y") . "'";
$row_Nseq = $GLOBALS['connexion']->query($query_getNseq)->fetch_assoc();
if ($row_Nseq['NSEQ'] == null) {
$num = "001";
} else {
$num = (int) $row_Nseq['NSEQ'];
$num++;
}
$nsequentiel = "OM" . $row['COL_MNEMONIC'] . '-' . date("Y") . sprintf("%03d", $num);
$numdoc = $nsequentiel;
$iddoc = null;
$nomcol = $row['COL_NOM'] . ' ' . $row['COL_PRENOM'];
$adrcli = $row['CLI_ADRESSE_1'] . ' ' . $row['CLI_ADRESSE_2'] . ' ' . $row['CLI_CP'] . ' ' . $row['CLI_VILLE'];
$nomctc = $row['CTC_NOM'] . ' ' . $row['CTC_PRENOM'] . ' - ' . $row['CTC_PRT'] . ' / ' . $row['CTC_EMAIL'];
$nomctf = $row['CTF_NOM'] . ' ' . $row['CTF_PRENOM'] . ' - ' . $row['CTF_PRT'] . ' / ' . $row['CTF_EMAIL'];
if ($row['CTC_NO'] == 0) {
$nomctc = '';
}
if ($row['CTF_NO'] == 0) {
$nomctf = '';
}
$periode = 'du ' . format_date($r1['MIS_DTDEBUT']) . ' au ' . format_date($r1['MIS_DTFIN']);
if ($r1['MIS_NBJOURS'] > 0) {
$nbjours = 'Nombre de jours prévus : ' . $r1['MIS_NBJOURS'];
}
$djour = date2fr(date("d F Y"));
$query = "SELECT * FROM LIBDOCUMENT L LEFT JOIN COLLABORATEUR COL ON COL.COL_NO=L.COL_NO LEFT JOIN DOCUMENT D ON D.DOC_NO = L.DOC_NO WHERE D.DOC_CODE='" . $type . "' ORDER BY LDO_ORDRE";
$lib = $GLOBALS['connexion']->query($query)->fetch_assoc();
// Mise en POST
$_POST['numdoc'] = $numdoc;
$_POST['periode'] = $periode;
$_POST['article'] = $lib['LDO_CONTENU'];
$_POST['nomcol'] = $nomcol;
$_POST['nomcli'] = $row['CLI_NOM'];
$_POST['adrcli'] = $adrcli;
$_POST['nompro'] = $r1['MIS_NOM'];
$_POST['nomctc'] = $nomctc;
$_POST['nomctf'] = $nomctf;
$_POST['nbjours'] = $nbjours;
$_POST['prodet'] = $row['PRO_DETAIL'];
$_POST['promod'] = $row['PRO_MODALITE'];
$_POST['djour'] = $djour;
}
function recuperer_CDI($recherche, $type)
{
//Récupération des données
$query = "SELECT * FROM COLLABORATEUR P LEFT JOIN INTERNE I ON I.COL_NO=P.COL_NO LEFT JOIN FONCTION F ON F.FCT_NO=I.FCT_NO WHERE P.COL_NO=" . $_GET['recherche'];
$row = $GLOBALS['connexion']->query($query)->fetch_assoc();
// Mise en place No de document : test si déja un CDI pour ce collaborateur dans l'historique des documents
$q1 = "SELECT SUBSTRING(HID_NOMDOC, 6, 3)) as COL, HID_NOMDOC, HID_NO FROM HISTDOC WHERE HID_TYPE ='CDI'";
$r1 = $GLOBALS['connexion']->query($q1);
if ($r1 == null) {
//if ($r1['COL'] == null){
$numdoc = date('Y') . '-' . $row['COL_MNEMONIC'] . "CDI";
$req = "SELECT MAX(SUBSTRING(HID_NOMDOC, 12, 1)) as NUM FROM HISTDOC WHERE HID_TYPE ='CDI'";
$res = $GLOBALS['connexion']->query($req)->fetch_assoc();
if ($res['NUM'] == null) {
$num = "1";
} else {
$num = (int) $res['NUM'];
$num++;
}
$numdoc .= $num;
$iddoc = null;
} else {
$res1 = $r1->fetch_assoc();
$numdoc = $res1['HID_NOMDOC'];
$iddoc = $res1['HID_NO'];
}
$nomcol = $row['COL_CIVILITE'] . ' ' . $row['COL_PRENOM'] . ' ' . $row['COL_NOM'];
$natcol = ', de nationalité ' . $row['INT_NATIONALITE'];
$adrcol = 'Demeurant à ' . $row['INT_ADRESSE'];
if ($row['INT_ADRESSE2'] != '') {
$adrcol .= ' ' . $row['INT_ADRESSE2'];
}
$adrcol .= ' ' . $row['INT_CP'] . ' ' . $row['INT_VILLE'];
$nsscol = $row['INT_NSS'];
$datejour = date('d-m-Y');
//$query = "SELECT * FROM LIBDOCUMENT L LEFT JOIN COLLABORATEUR COL ON COL.COL_NO=L.COL_NO WHERE L.DOC_NO='2' ORDER BY LDO_ORDRE";
$query = "SELECT * FROM LIBDOCUMENT L LEFT JOIN DOCUMENT D ON D.DOC_NO = L.DOC_NO WHERE D.DOC_CODE='CDI' ORDER BY LDO_ORDRE";
$lib = $GLOBALS['connexion']->query($query);
while ($par = $lib->fetch_assoc()) {
$i = $par['LDO_ORDRE'] - 1;
$t[$i] = $par['LDO_NOM'];
$p[$i] = $par['LDO_CONTENU'];
}
// Remplacements de champs dans les libellés
$dentree = date2fr(date("l d F Y", mktime(0, 0, 0, substr($row['INT_DTENTREE'], 8, 2), substr($row['INT_DTENTREE'], 5, 2), substr($row['INT_DTENTREE'], 0, 4))));
// Periode d'essai : valeurs par défaut :
// Si cadre : 4 mois + renouv 3 mois
// employés : 2 mois + renouv 1 mois
if (strtolower($row['INT_STATUT']) == "cadre") {
$periode = "4 mois";
$renouv = "3 mois";
} else {
$periode = "2 mois";
$renouv = "1 mois";
}
// Remplacements dans les articles concernés
$p[0] = str_replace('INT_DTENTREE', $dentree, $p[0]);
$p[0] = str_replace('FCT_NOM', $row['FCT_NOM'], $p[0]);
$p[0] = str_replace('INT_STATUT', $row['INT_STATUT'], $p[0]);
$p[0] = str_replace('INT_COEFF', $row['INT_COEFF'], $p[0]);
$p[0] = str_replace('INT_POSITION', $row['INT_POSITION'], $p[0]);
$p[1] = str_replace('INT_ESSAIPER', $periode, $p[1]);
$p[1] = str_replace('INT_ESSAIREN', $renouv, $p[1]);
$p[3] = str_replace('INT_REMUNFIXE', $row['INT_REMUNFIXE'] . " " . EURO, $p[3]);
$p[15] = str_replace('COL_NOMCOMPLET', $nomcol, $p[15]);
$p[20] = str_replace('COL_NOMCOMPLET', $nomcol, $p[20]);
// Mise en POST
$_POST['numdoc'] = $numdoc;
$_POST['nomcol'] = $nomcol;
$_POST['natcol'] = $natcol;
$_POST['adrcol'] = $adrcol;
$_POST['nsscol'] = $nsscol;
for ($i = 0; $i < count($t); $i++) {
$_POST['t[' . $i . ']'] = $t[$i];
$_POST['p[' . $i . ']'] = $p[$i];
}
}
