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]; } }