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; } $ObjTuple->SetSiteEntreprise($ValSiteEntreprise); if ($ValPK_Entreprise == 0) { $ObjTuple->Insert(); } else { $ObjTuple->Update(); }
$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) { $ObjTuple->Insert(); } else { $ObjTuple->Update(); } } $Step = 'MAJTabOK';
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 }
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); } else { $ObjSoc->SetCivilite(${$ValCiviliteRespAdmin}); $ObjSoc->SetNomR(ProtectApos($ValNomRespAdmin)); $ObjSoc->SetPrenomR(ProtectApos($ValPrenomRespAdmin));