+ case "delete":
+ S::assert_xsrf_token();
+
+ XDB::execute('DELETE FROM photo WHERE uid = {?}', $uid);
+ break;
+ }
+
+ $page->assign('forlife', $forlife);
+ }
+ function handler_admin_binets(&$page, $action = 'list', $id = null) {
+ $page->setTitle('Administration - Binets');
+ $page->assign('title', 'Gestion des binets');
+ $table_editor = new PLTableEditor('admin/binets', 'binets_def', 'id');
+ $table_editor->add_join_table('binets_ins','binet_id',true);
+ $table_editor->describe('text','intitulé',true);
+ $table_editor->apply($page, $action, $id);
+ }
+ function handler_admin_education(&$page, $action = 'list', $id = null) {
+ $page->setTitle('Administration - Formations');
+ $page->assign('title', 'Gestion des formations');
+ $table_editor = new PLTableEditor('admin/education', 'profile_education_enum', 'id');
+ $table_editor->add_join_table('profile_education', 'eduid', true);
+ $table_editor->add_join_table('profile_education_degree', 'eduid', true);
+ $table_editor->describe('name', 'intitulé', true);
+ $table_editor->describe('url', 'site web', false);
+ $table_editor->apply($page, $action, $id);
+ }
+ function handler_admin_education_field(&$page, $action = 'list', $id = null) {
+ $page->setTitle('Administration - Domaines de formation');
+ $page->assign('title', 'Gestion des domaines de formation');
+ $table_editor = new PLTableEditor('admin/education_field', 'profile_education_field_enum', 'id', true);
+ $table_editor->add_join_table('profile_education', 'fieldid', true);
+ $table_editor->describe('field', 'domaine', true);
+ $table_editor->apply($page, $action, $id);
+ }
+ function handler_admin_education_degree(&$page, $action = 'list', $id = null) {
+ $page->setTitle('Administration - Niveau de formation');
+ $page->assign('title', 'Gestion des niveau de formation');
+ $table_editor = new PLTableEditor('admin/education_degree', 'profile_education_degree_enum', 'id', true);
+ $table_editor->add_join_table('profile_education_degree', 'degreeid', true);
+ $table_editor->add_join_table('profile_education', 'degreeid', true);
+ $table_editor->describe('degree', 'niveau', true);
+ $table_editor->apply($page, $action, $id);
+ }
+ function handler_admin_education_degree_set(&$page, $action = 'list', $id = null) {
+ $page->setTitle('Administration - Correspondances formations - niveau de formation');
+ $page->assign('title', 'Gestion des correspondances formations - niveau de formation');
+ $table_editor = new PLTableEditor('admin/education_degree_set', 'profile_education_degree', 'eduid', true);
+ $table_editor->describe('eduid', 'formation', true);
+ $table_editor->describe('degreeid', 'niveau', true);
+ $table_editor->apply($page, $action, $id);
+ }
+ function handler_admin_sections(&$page, $action = 'list', $id = null) {
+ $page->setTitle('Administration - Sections');
+ $page->assign('title', 'Gestion des sections');
+ $table_editor = new PLTableEditor('admin/sections','sections','id');
+ $table_editor->describe('text','intitulé',true);
+ $table_editor->apply($page, $action, $id);
+ }
+ function handler_admin_ss_secteurs(&$page, $action = 'list', $id = null) {
+ $page->setTitle('Administration - Sous-secteurs');
+ $page->assign('title', 'Gestion des sous-secteurs');
+ $table_editor = new PLTableEditor('admin/ss_secteurs', 'emploi_ss_secteur', 'id', true);
+ $table_editor->describe('label', 'intitulé', true);
+ $table_editor->apply($page, $action, $id);
+ }
+ function handler_admin_fonctions(&$page, $action = 'list', $id = null) {
+ $page->setTitle('Administration - Fonctions');
+ $page->assign('title', 'Gestion des fonctions');
+ $table_editor = new PLTableEditor('admin/fonctions', 'fonctions_def', 'id', true);
+ $table_editor->describe('fonction_fr', 'intitulé', true);
+ $table_editor->describe('fonction_en', 'intitulé (ang)', true);
+ $table_editor->describe('flags', 'titre', true);
+ $table_editor->apply($page, $action, $id);
+ }
+ function handler_admin_secteurs(&$page, $action = 'list', $id = null) {
+ $page->setTitle('Administration - Secteurs');
+ $page->assign('title', 'Gestion des secteurs');
+ $table_editor = new PLTableEditor('admin/secteurs', 'emploi_secteur', 'id', true);
+ $table_editor->describe('label', 'intitulé', true);
+ $table_editor->apply($page, $action, $id);
+ }
+ function handler_admin_networking(&$page, $action = 'list', $id = null) {
+ $page->assign('xorg_title', 'Polytechnique.org - Administration - Networking');
+ $page->assign('title', 'Gestion des types de networking');
+ $table_editor = new PLTableEditor('admin/networking', 'profile_networking_enum', 'network_type');
+ $table_editor->describe('name', 'intitulé', true);
+ $table_editor->describe('icon', 'nom de l\'icône', false);
+ $table_editor->describe('filter', 'filtre', true);
+ $table_editor->describe('link', 'lien web', true);
+ $table_editor->apply($page, $action, $id);
+ }
+ function handler_admin_medals(&$page, $action = 'list', $id = null) {
+ $page->setTitle('Administration - Distinctions');
+ $page->assign('title', 'Gestion des Distinctions');
+ $table_editor = new PLTableEditor('admin/medals','profile_medals','id');
+ $table_editor->describe('text', 'intitulé', true);
+ $table_editor->describe('img', 'nom de l\'image', false);
+ $table_editor->describe('flags', 'valider', true);
+ $table_editor->apply($page, $action, $id);
+ if ($id && $action == 'edit') {
+ $page->changeTpl('profile/admin_decos.tpl');
+
+ $mid = $id;
+
+ if (Post::v('act') == 'del') {
+ XDB::execute('DELETE FROM profile_medals_grades
+ WHERE mid={?} AND gid={?}', $mid, Post::i('gid'));
+ } else {
+ foreach (Post::v('grades', array()) as $gid=>$text) {
+ if ($gid === 0) {
+ if (!empty($text)) {
+ $res = XDB::query('SELECT MAX(gid)
+ FROM profile_medals_grades
+ WHERE mid = {?}', $mid);
+ $gid = $res->fetchOneCell() + 1;
+
+ XDB::execute('INSERT INTO profile_medals_grades (mid, gid, text, pos)
+ VALUES ({?}, {?}, {?}, {?})',
+ $mid, $gid, $text, $_POST['pos']['0']);
+ }
+ } else {
+ XDB::execute('UPDATE profile_medals_grades
+ SET pos={?}, text={?}
+ WHERE gid={?} AND mid={?}', $_POST['pos'][$gid], $text, $gid, $mid);
+ }
+ }
+ }
+ $res = XDB::iterator('SELECT gid, text, pos FROM profile_medals_grades WHERE mid={?} ORDER BY pos', $mid);
+ $page->assign('grades', $res);
+ }