'profile/ajax/address' => $this->make_hook('ajax_address', AUTH_COOKIE, 'user', NO_AUTH),
'profile/ajax/tel' => $this->make_hook('ajax_tel', AUTH_COOKIE, 'user', NO_AUTH),
'profile/ajax/medal' => $this->make_hook('ajax_medal', AUTH_COOKIE, 'user', NO_AUTH),
+ 'profile/networking' => $this->make_hook('networking', AUTH_PUBLIC),
'profile/ajax/job' => $this->make_hook('ajax_job', AUTH_COOKIE, 'user', NO_AUTH),
'profile/ajax/secteur' => $this->make_hook('ajax_secteur', AUTH_COOKIE, 'user', NO_AUTH),
'profile/ajax/skill' => $this->make_hook('ajax_skill', AUTH_COOKIE, 'user', NO_AUTH),
'admin/formations' => $this->make_hook('admin_formations', AUTH_MDP, 'admin'),
'admin/sections' => $this->make_hook('admin_sections', AUTH_MDP, 'admin'),
'admin/secteurs' => $this->make_hook('admin_secteurs', AUTH_MDP, 'admin'),
+ 'admin/networking' => $this->make_hook('admin_networking', AUTH_MDP, 'admin'),
'admin/trombino' => $this->make_hook('admin_trombino', AUTH_MDP, 'admin'),
'admin/ss_secteurs' => $this->make_hook('admin_ss_secteurs', AUTH_MDP, 'admin'),
'admin/fonctions' => $this->make_hook('admin_fonctions', AUTH_MDP, 'admin'),
+ 'admin/phones_format_display' => $this->make_hook('admin_phones_format_display', AUTH_MDP, 'admin'),
);
}
exit;
}
+ function handler_networking(&$page, $mid)
+ {
+ $res = XDB::query("SELECT icon
+ FROM profile_networking_enum
+ WHERE network_type = {?}",
+ $mid);
+ $img = dirname(__FILE__) . '/../htdocs/images/networking/' . $res->fetchOneCell();
+ $type = mime_content_type($img);
+ header("Content-Type: $type");
+ echo file_get_contents($img);
+ exit;
+ }
+
function handler_photo_change(&$page)
{
$page->changeTpl('profile/trombino.tpl');
$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_phones_format_display(&$page, $action = 'list', $id = null) {
+ $page->assign('xorg_title', 'Polytechnique.org - Administration - Format d\'affichage des numéros de téléphone ');
+ $page->assign('title', 'Gestion des formats d\'affichage des numéros de téléphone');
+ $table_editor = new PLTableEditor('admin/phones_format_display', 'phone_formats', 'phoneprf',true);
+ $table_editor->describe('phoneprf', 'Préfixe International', true);
+ $table_editor->describe('format', 'format d\'Affichage (ex: (+p) ### ## ## ##)', true);
+ if ($action == 'update') {
+ if ((Post::has('phoneprf')) && (Post::v('phoneprf') == $id)) {
+ $res = XDB::query("SELECT format
+ FROM phone_formats
+ WHERE phoneprf = {?}",
+ $id);
+ $old_val = $res->fetchOneCell();
+ if (Post::has('format')) {
+ $new_val = Post::v('format');
+ } else {
+ $new_val = '';
+ }
+ if ($new_val != $old_val){
+ require_once("profil.func.inc.php");
+ XDB::execute("UPDATE phone_formats
+ SET format = {?}
+ WHERE phoneprf = {?}",
+ $new_val, $id);
+ $prefixe = $id . '%';
+ $res = XDB::iterator("SELECT uid, link_type, link_id, tel_id, tel_type, search_tel, pub
+ FROM telephone
+ WHERE search_tel LIKE {?}",
+ $prefixe);
+ $req = '';
+ $i = 0;
+ while($phonenumber = $res->next()) {
+ if ($req != '') {
+ $req .= ",\n";
+ }
+ $req .= "('" . addslashes($phonenumber['uid']) . "', '" . addslashes($phonenumber['link_type']) . "', '" . addslashes($phonenumber['link_id'])
+ . "', '" . addslashes($phonenumber['tel_id']) . "', '" . addslashes($phonenumber['tel_type'])
+ . "', '" . addslashes($phonenumber['search_tel']) . "', '"
+ . addslashes(format_display_number($phonenumber['search_tel'], &$erreur, array('format' => $new_val, 'phoneprf' => $id)))
+ . "', '" . addslashes($phonenumber['pub']) . "')";
+ $i++;
+ if( $i == 1000) {
+ XDB::execute("INSERT INTO telephone(uid, link_type, link_id, tel_id ,tel_type,
+ search_tel, display_tel, pub)
+ VALUES " . $req . "
+ ON DUPLICATE KEY UPDATE display_tel = VALUES(display_tel)");
+ $req = '';
+ $i = 0;
+ }
+ }
+ if ($req != '') {
+ XDB::execute("INSERT INTO telephone(uid, link_type, link_id, tel_id ,tel_type,
+ search_tel, display_tel, pub)
+ VALUES " . $req . "
+ ON DUPLICATE KEY UPDATE display_tel = VALUES(display_tel)");
+ }
+ }
+ }
+ $action = 'list';
+ $id = null;
+ }
+ $table_editor->apply($page, $action, $id);
+ }
function handler_admin_medals(&$page, $action = 'list', $id = null) {
$page->assign('xorg_title','Polytechnique.org - Administration - Distinctions');
$page->assign('title', 'Gestion des Distinctions');