X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=include%2Fvalidations%2Forange.inc.php;h=e2e2987f687d9b7bc4152083c01870db44ed17c4;hb=a19178e9a93c4eb3eb750845e85f87f2294ed1e4;hp=1d2acda393c0497f0c06135591e6f87bc0bf980f;hpb=353f2d2b11c4e3c6c0bc3553813368b6f42fa9c6;p=platal.git diff --git a/include/validations/orange.inc.php b/include/validations/orange.inc.php index 1d2acda..e2e2987 100644 --- a/include/validations/orange.inc.php +++ b/include/validations/orange.inc.php @@ -1,6 +1,6 @@ newGradYear = $_newGradYear; - $res = XDB::query("SELECT entry_year + $res = XDB::query("SELECT entry_year, grad_year FROM profile_education - WHERE uid = {?} AND FIND_IN_SET('primary', flags)", $this->user->id()); - $this->entryYear = $res->fetchOneCell(); - $this->oldGradYear = $this->entryYear + 3; + WHERE pid = {?} AND FIND_IN_SET('primary', flags)", $this->user->profile()->id()); + $years = $res->fetchOneRow(); + $this->entryYear = $years[0]; + $this->oldGradYear = $years[1]; } // }}} @@ -71,11 +72,11 @@ class OrangeReq extends Validate protected function _mail_body($isok) { if ($isok) { - return " La demande de changement de promotion de sortie que tu as demandée vient d'être effectuée. " + return " La demande de changement de promotion que tu as demandée vient d'être effectuée. " . "Si tu le souhaites, tu peux maintenant modifier l'affichage de ta promotion sur le site sur la page suivante : " . "https://www.polytechnique.org/profile/edit"; } else { - return " La demande de changement de promotion de sortie tu avais faite a été refusée."; + return " La demande de changement de promotion tu avais faite a été refusée."; } } @@ -86,7 +87,8 @@ class OrangeReq extends Validate { XDB::execute("UPDATE profile_education SET grad_year = {?} - WHERE uid = {?} AND FIND_IN_SET('primary', flags)", $this->newGradYear, $this->user->id()); + WHERE pid = {?} AND FIND_IN_SET('primary', flags)", + $this->newGradYear, $this->user->profile()->id()); return true; }