X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=include%2Fvalidations%2Fentreprises.inc.php;h=47e6a023f4ad03bf17f44d632154702a4d2ae693;hb=7c4ae1c3d38d458ac3b6dea25ca76ebdd2c0ecd8;hp=6d269d8963b78c3a792879daa5eb9f755620546d;hpb=3f5cf357e7ab02c9cbf616bc8cc3a70278af62cc;p=platal.git diff --git a/include/validations/entreprises.inc.php b/include/validations/entreprises.inc.php index 6d269d8..47e6a02 100644 --- a/include/validations/entreprises.inc.php +++ b/include/validations/entreprises.inc.php @@ -1,6 +1,6 @@ id = $_id; $this->name = $_name; $this->acronym = $_acronym; @@ -68,12 +68,14 @@ class EntrReq extends Validate $where .= "name LIKE '%" . $name_array[$i] . "%'"; } } - $res = XDB::iterator('SELECT name - FROM profile_job_enum - WHERE ' . $where); - $this->suggestions = "| "; - while ($sug = $res->next()) { - $this->suggestions .= $sug['name'] . " | "; + if ($where != '') { + $res = XDB::iterator('SELECT name + FROM profile_job_enum + WHERE ' . $where); + $this->suggestions = "| "; + while ($sug = $res->next()) { + $this->suggestions .= $sug['name'] . " | "; + } } } @@ -98,26 +100,37 @@ class EntrReq extends Validate protected function handle_editor() { + if (Env::has('name')) { + $this->name = Env::t('name'); + } + if (Env::has('acronym')) { + $this->acronym = Env::t('acronym'); + } + if (Env::has('url')) { + $this->url = Env::t('url'); + } + if (Env::has('email')) { + $this->email = Env::t('email'); + } if (Env::has('holdingid')) { - $this->holdingid = trim(Env::v('holdingid')); + $this->holdingid = Env::i('holdingid'); } - if (Env::has('name')) { - $this->name = trim(Env::v('name')); - if (Env::has('acronym')) { - $this->acronym = trim(Env::v('acronym')); - if (Env::has('url')) { - $this->url = trim(Env::v('url')); - if (Env::has('NAF_code')) { - $this->NAF_code = trim(Env::v('NAF_code')); - if (Env::has('AX_code')) { - $this->AX_code = trim(Env::v('AX_code')); - return true; - } - } - } - } + if (Env::has('NAF_code')) { + $this->NAF_code = Env::t('NAF_code'); + } + if (Env::has('AX_code')) { + $this->AX_code = Env::i('AX_code'); + } + if (Env::has('address')) { + $this->address['text'] = Env::t('address'); } - return false; + if (Env::has('tel')) { + $this->tel = Env::t('tel'); + } + if (Env::has('fax')) { + $this->fax = Env::t('fax'); + } + return true; } // }}} @@ -164,7 +177,7 @@ class EntrReq extends Validate $jobid = XDB::insertId(); $display_tel = format_display_number($this->tel, $error_tel); $display_fax = format_display_number($this->fax, $error_fax); - XDB::execute("INSERT INTO profile_phones (uid, link_type, link_id, tel_id, tel_type, + XDB::execute("INSERT INTO profile_phones (pid, link_type, link_id, tel_id, tel_type, search_tel, display_tel, pub) VALUES ({?}, 'hq', 0, 0, 'fixed', {?}, {?}, 'public'), ({?}, 'hq', 0, 1, 'fax', {?}, {?}, 'public')", @@ -191,12 +204,17 @@ class EntrReq extends Validate $this->address['east'], $this->address['west']); } else { $jobid = $res->fetchOneCell(); - $success = true; } - return XDB::execute('UPDATE profile_job - SET jobid = {?} - WHERE uid = {?} AND id = {?}', - $jobid, $this->user->id(), $this->id); + XDB::execute('UPDATE profile_job + SET jobid = {?} + WHERE pid = {?} AND id = {?}', + $jobid, $this->profile->id(), $this->id); + if (XDB::affectedRows() == 0) { + return XDB::execute('INSERT INTO profile_job (jobid, pid, id) + VALUES ({?}, {?}, {?})', + $jobid, $this->profile->id(), $this->id); + } + return true; } // }}}