function RecupOldEntreprises() { global $ConnectStages; /* * / $ReqOldSocs = $ConnectStages->query("SELECT oldtabentreprises.*, oldtabstages.NomEtudiant, oldtabstages.Annee FROM oldtabentreprises, oldtabstages WHERE oldtabentreprises.NomEntreprise = oldtabstages.NomEntreprise AND oldtabstages.Annee > 1999 ORDER BY oldtabstages.Annee DESC, oldtabentreprises.NomEntreprise"); /* */ /* */ // $ReqOldSocs = $ConnectStages->query("SELECT DISTINCT oldtabentreprises.* // FROM oldtabentreprises, oldtabstages // WHERE oldtabentreprises.NomEntreprise = oldtabstages.NomEntreprise // AND oldtabstages.Annee > 1999 // ORDER BY oldtabentreprises.NomEntreprise"); $ReqOldSocs = $ConnectStages->query("SELECT DISTINCT oldtabentreprises.*\n\t FROM oldtabentreprises, oldtabstages \n\t\t\t\t\t\t WHERE oldtabentreprises.NomEntreprise = oldtabstages.NomEntreprise\n\t\t\t\t\t\t\t AND oldtabstages.Annee > 1999\n\t\t\t\t\t\t\t ORDER BY oldtabentreprises.NomEntreprise"); /* */ ?> <table> <tr> <th>Is_Valide</th> <th>NomEntreprise</th> <th>NomRespAdmin</th> <th>NomEtudiant</th> <th>Annee</th> </tr> <?php while ($ObjReq = $ReqOldSocs->fetch()) { $ObjSoc = new CEntreprise(); $ObjSoc->SetPK_Entreprise(0); $ObjSoc->SetNomE($ObjReq['NomEntreprise']); $ObjSoc->SetNomR($ObjReq['NomRespAdmin']); $ObjSoc->SetPrenomR($ObjReq['PrenomRespAdmin']); $ObjSoc->SetAdr1($ObjReq['Adr1']); $ObjSoc->SetAdr2($ObjReq['Adr2']); $ObjSoc->SetCP($ObjReq['CP']); $ObjSoc->SetVille($ObjReq['Ville']); $ObjSoc->SetTelR($ObjReq['TelRespAdmin']); $ObjSoc->SetMailR($ObjReq['emailRespAdmin']); $ObjSoc->Insert(); ?> <tr> <td><?php echo $ObjReq['Is_Valide']; ?> </td> <td><?php echo $ObjReq['NomEntreprise']; ?> </td> <td><?php echo $ObjReq['NomRespAdmin']; ?> </td> <td><?php echo $ObjReq['NomEtudiant']; ?> </td> <td><?php echo $ObjReq['Annee']; ?> </td> </tr> <?php } ?> </table> <?php }
} else { if ($Err = NormaliserTel($ValTelR)) { array_push($CodErrInval, $Err); $ValidTelR = FLECHE; } } $ValMailR = trim($MailR); if (($ValFaxR = trim($FaxR)) != '' && ($Err = NormaliserTel($ValFaxR))) { array_push($CodErrInval, $Err); $ValidFaxR = FLECHE; } if (!count($CodErrVide)) { // Validation des valeurs des attributs } if (!($CodErrVide || $CodErrInval)) { $ObjTuple = new CEntreprise(); $ObjTuple->SetPK_Entreprise($ValPK_Entreprise); $ObjTuple->SetNomE(ProtectApos($ValNomE)); $ObjTuple->SetCivilite($ValCivilite); $ObjTuple->SetNomR(ProtectApos($ValNomR)); $ObjTuple->SetPrenomR(ProtectApos($ValPrenomR)); $ObjTuple->SetAdr1(ProtectApos($ValAdr1)); $ObjTuple->SetAdr2(ProtectApos($ValAdr2)); $ObjTuple->SetCP($ValCP); $ObjTuple->SetVille(ProtectApos($ValVille)); $ObjTuple->SetTelR($ValTelR); $ObjTuple->SetMailR($ValMailR); $ObjTuple->SetFaxR($ValFaxR); $ObjTuple->SetPresentEntreprise($ValPresentEntreprise); if (substr($ValSiteEntreprise, 0, 7) != 'http://') { $ValSiteEntreprise = 'http://' . $ValSiteEntreprise;
$Fleche = FLECHE; // on compare l' entreprise entrée avec les entreprises déjà existantes $ReqL = $ConnectStages->query("SELECT NomE from tabentreprise"); while ($RowL = $ReqL->fetch(PDO::FETCH_NUM)) { if ($ValNomE == $RowL[0]) { $CodErrLog = true; $ValidNomE = FLECHE; } } if (!count($CodErrVide)) { // Validation des valeurs des attributs } if (!$CodErrVide && !$CodErrInval) { print '<h1>Enregistrer</h1>'; // Préparation de l'enreg. à enregistrer $ObjTuple = new CEntreprise(); $ObjTuple->SetPK_Entreprise($ValPK_Entreprise); $ObjTuple->SetNomE($ValNomE); $ObjTuple->SetNomR($ValNomR); $ObjTuple->SetPrenomR($ValPrenomR); $ObjTuple->SetAdr1($ValAdr1); $ObjTuple->SetAdr2($ValAdr2); $ObjTuple->SetCP($ValCP); $ObjTuple->SetVille($ValVille); $ObjTuple->SetTelR($ValTelR); $ObjTuple->SetMailR($ValMailR); $ObjTuple->SetFaxR($ValFaxR); if ($IdentPK == 0) { $ObjTuple->Insert(); } else { if ($SaveAsNew) {
<?php if ($CleOK == '069b9247591948b71d303ac66371bf0b') { require_once $PATH_CLASS . 'CEntreprise.php'; require_once $PATH_RACINE . 'Util/UtilPages.php'; if ($Status == TUTEUR) { $IdentPK = $FK_EntrepriseUser; } $ObjTuple = new CEntreprise($IdentPK); $ValPK_Entreprise = $ObjTuple->GetPK_Entreprise(); $ValNomE = $ObjTuple->GetNomE(); $ValAdr1 = $ObjTuple->GetAdr1(); $ValAdr2 = $ObjTuple->GetAdr2(); $ValCP = $ObjTuple->GetCP(); $ValVille = $ObjTuple->GetVille(); $ValCivilite = $ObjTuple->GetCivilite(); $ValNomRespAdmin = $ObjTuple->GetNomR(); $ValPrenomRespAdmin = $ObjTuple->GetPrenomR(); $ValTelRespAdmin = $ObjTuple->GetTelR(); $ValMailRespAdmin = $ObjTuple->GetMailR(); $ValFaxRespAdmin = $ObjTuple->GetFaxR(); $ValPresentEntreprise = $ObjTuple->GetPresentEntreprise(); $ValSiteEntreprise = $ObjTuple->GetSiteEntreprise(); $WidthButton = 100; ?> <br /> <h4 class="center"><?php echo $ValNomE; ?> </h4>
<?php if ($CleOK == '069b9247591948b71d303ac66371bf0b') { require_once $PATH_COMMUNS . 'FctDiverses.php'; // IsInSet() $ReqLangages = $ConnectStages->query("SELECT * FROM {$NomTabLangages}"); $ReqMateriels = $ConnectStages->query("SELECT * FROM {$NomTabMateriels}"); $ReqBDs = $ConnectStages->query("SELECT * FROM {$NomTabBasesDonnees}"); require_once $PATH_CLASS . 'CStage.php'; require_once $PATH_CLASS . 'CUser.php'; require_once $PATH_CLASS . 'CEntreprise.php'; $ObjStage = new CStage($IdentPK); $ObjEntreprise = new CEntreprise($ObjStage->GetFK_Entreprise()); $ObjUser = new CUser($ObjStage->GetFK_Tuteur()); if ($ObjStage->GetAdr1Stage() != '') { $Adr1Stage = $ObjStage->GetAdr1Stage(); $Adr2Stage = $ObjStage->GetAdr2Stage(); $CPStage = $ObjStage->GetCPStage(); $VilleStage = $ObjStage->GetVilleStage(); } else { $Adr1Stage = $ObjEntreprise->GetAdr1(); $Adr2Stage = $ObjEntreprise->GetAdr2(); $CPStage = $ObjEntreprise->GetCP(); $VilleStage = $ObjEntreprise->GetVille(); } $ValPK_Stage = $ObjStage->GetPK_Stage(); $ValRemarquesGenerales = $ObjStage->GetRemarquesGenerales(); $WidthButton = 100; $WidthCadre = 800; $MsgProposeA = array(); $MsgProposeA[1] = 'aux étudiants de DUT';
$ValAdr2 = trim($Adr2); } // Validation du login if (($ValLoginTuteur = trim($LoginTuteur)) == '') { array_push($CodErrVide, 'LoginTuteur'); $ValidLoginTuteur = FLECHE; } else { if ($Err = ErrorLogin($LoginTuteur)) { array_push($CodErrInval, $Err); $ValidLoginTuteur = FLECHE; } } if (!(count($CodErrVide) || count($CodErrInval))) { if ($ValFK_Entreprise == 0) { // Création d'une nouvelle entreprise $ObjSoc = new CEntreprise(); $ObjSoc->SetIs_Valide(1); $ObjSoc->SetNomE(ProtectApos($ValNomE)); $ObjSoc->SetAdr1(ProtectApos($ValAdr1)); $ObjSoc->SetAdr2(ProtectApos($ValAdr2)); $ObjSoc->SetCP($ValCP); $ObjSoc->SetVille(ProtectApos($ValVille)); if ($ValIs_IdemTuteur) { $ValCiviliteRespAdmin = $ValCiviliteTuteur; $ValNomRespAdmin = $ValNomTuteur; $ObjSoc->SetCivilite(${$ValCiviliteRespAdmin}); $ObjSoc->SetNomR(ProtectApos($ValNomTuteur)); $ObjSoc->SetPrenomR(ProtectApos($ValPrenomTuteur)); $ObjSoc->SetTelR($ValTelTuteur); $ObjSoc->SetMailR($ValMailTuteur); $ObjSoc->SetFaxR($ValFaxTuteur);
<?php if ($CleOK == '069b9247591948b71d303ac66371bf0b') { require_once $PATH_COMMUNS . 'FctDiverses.php'; // IsInSet() $ReqLangages = $ConnectStages->query("SELECT * FROM {$NomTabLangages}"); $ReqMateriels = $ConnectStages->query("SELECT * FROM {$NomTabMateriels}"); $ReqBDs = $ConnectStages->query("SELECT * FROM {$NomTabBasesDonnees}"); require_once $PATH_CLASS . 'CStage.php'; require_once $PATH_CLASS . 'CUser.php'; require_once $PATH_CLASS . 'CEntreprise.php'; $ObjStage = new CStage($IdentPK); $ValPK_Stage = $ObjStage->GetPK_Stage(); $ValRemarquesGenerales = $ObjStage->GetRemarquesGenerales(); $ObjEntreprise = new CEntreprise($ObjStage->GetFK_Entreprise()); $ObjUser = new CUser($ObjStage->GetFK_Tuteur()); $WidthButton = 100; $WidthCadre = 800; ?> <h2 style="text-align : center;">Fiche de stage n° <?php echo $ValPK_Stage; ?> </h2> <table align="center" border="1" width="<?php echo $WidthCadre; ?> "><tr><td> <table cellpadding="2" width="100%"> <tr>