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>
