function compta_add() { global $tpl; $mdl = new Modele('user_accounts'); $fields = array('ua_identifier', 'ua_number'); if ($_SERVER['REQUEST_METHOD'] == 'POST') { $info = array_merge($_POST, array('ua_user' => $_SESSION['user']['user_id'])); $info['ua_number'] = strtoupper(str_replace(' ', '', $info['ua_number'])); if (checkIBAN($info['ua_number'])) { if ($mdl->addFrom($info)) { redirect("compta", "index", array('hsuccess' => 1)); } else { $tpl->assign('hsuccess', false); } } else { $tpl->assign('hsuccess', "Le numero IBAN est invalide"); } } $tpl->assign('form', $mdl->edit($fields)); display(); }
/** * Modification du profil utilisateur * @global type $tpl */ function index_profile() { global $tpl, $srcdir, $pdo; $mdl = new Modele('users'); $mdl->fetch($_SESSION['user']['user_id']); if (isset($_POST['edit'])) { $tpl->assign('hsuccess', $mdl->modFrom($_POST)); } if (isset($_POST['editpass'])) { if ($_POST['pwd1'] == '' || $_POST['oldpass'] != md5($_SESSION['user']['user_pass'] . $_SESSION['random'])) { $tpl->assign('hsuccess', false); } else { $tpl->assign('hsuccess', $mdl->modFrom(array('user_pass' => $_POST['pwd1']), false)); } } $mdt = new Modele('mandate'); if ($mdt->find('`mandate_start` < now() and `mandate_end` > now()')) { while ($line = $mdt->next()) { $tpl->append('mandate', $line); } } $mdtu = $pdo->prepare('SELECT * FROM user_mandate LEFT JOIN mandate ON um_mandate = mandate_id WHERE um_user = ? ORDER BY `mandate_end` DESC'); $mdtu->bindValue(1, $_SESSION['user']['user_id']); $mdtu->execute(); while ($line = $mdtu->fetch()) { $tpl->append('usr_mandate', $line); } $_SESSION['random'] = md5(uniqid('epicenote')); $tpl->assign('random', $_SESSION['random']); $tpl->assign('isMember', hasAcl(ACL_USER)); $tpl->assign('form', $mdl->edit()); $mdl = new Modele('card'); $mdl->find(array('card_user' => $_SESSION['user']['user_id'])); $l = $mdl->next(); if (!$l) { $tpl->assign('cards', false); } while ($l) { $o = new Modele('card'); $o->fetch($mdl->card_id); $tpl->append('cards', $o); $l = $mdl->next(); } //GoogleAuthentificator require_once $srcdir . '/libs/GoogleAuthenticator/GoogleAuthenticator.php'; $api = new GoogleAuthenticator(); $_SESSION['user']['GoogleAuthenticator'] = $api->generateSecret(); $tpl->assign('GoogleAuth', $api); //FIN GoogleAuthentificator display(); }
function section_addpoints() { global $tpl, $pdo; $section = new Modele('sections'); $section->fetch($_REQUEST['section']); $tpl->assign('section', $section); $queryFields = array('part_duration', 'part_title', 'part_justification'); $mdl = new Modele('participations'); $tpl->assign('form', $mdl->edit($queryFields)); if (isset($_POST['edit'])) { $data = array('part_section' => $section->section_id, 'part_attribution_date' => date('Y-m-d'), 'part_status' => 'SUBMITTED'); foreach ($queryFields as $field) { $data[$field] = $_POST[$field]; } if (!$mdl->addFrom($data)) { redirect('section', 'details', array('section' => $section->section_id, 'hsuccess' => '0')); } $sql = $pdo->prepare('SELECT * FROM user_sections LEFT JOIN users ON user_id = us_user WHERE us_section = ? ORDER BY user_name'); $sql->bindValue(1, $section->section_id); $sql->execute(); $mdlMark = new Modele('marks'); $dataMark = array('mark_participation' => $mdl->getKey()); while ($user = $sql->fetch()) { if (in_array($user['user_id'], $_POST['staffs'])) { $dataMark['mark_user'] = $user['user_id']; $dataMark['mark_period'] = $_POST['type-' . $user['user_type']]; $mdlMark->addFrom($dataMark); } } redirect('section', 'details', array('section' => $section->section_id, 'hsuccess' => '1')); } $types = new Modele('user_types'); $types->find(); while ($type = $types->next()) { $periods = $pdo->prepare('SELECT * FROM periods WHERE period_start < NOW() AND period_end > NOW() AND period_type = ? AND period_state = "ACTIVE"'); $periods->bindValue(1, $types->ut_id); $periods->execute(); $repPeriods = array(); while ($period = $periods->fetch()) { $repPeriods[] = $period; } $tpl->append('types', array('id' => $types->ut_id, 'name' => $types->ut_name, 'periods' => $repPeriods)); } $sql = $pdo->prepare('SELECT * FROM user_sections LEFT JOIN users ON user_id = us_user WHERE us_section = ? ORDER BY user_name'); $sql->bindValue(1, $section->section_id); $sql->execute(); while ($user = $sql->fetch()) { $tpl->append('staffs', $user); } display(); }
function trip_opt_edit() { global $tpl; $opt = new Modele('trip_option_options'); $opt->fetch($_GET['option']); $opt->assignTemplate('ooption'); $mod = $opt->too_option; $mod->assignTemplate('option'); $mdl = $mod->topt_trip; $mdl->assignTemplate('trip'); $tpl->assign('form', $opt->edit(array('too_value', 'too_price'))); if ($_SERVER['REQUEST_METHOD'] == 'POST') { if ($opt->modFrom($_POST)) { redirect('trip', 'opt_list', array('option' => $mod->getKey(), 'hsuccess' => 1)); } $tpl->assign('hsuccess', false); } display(); }
function event_addpoints() { global $tpl, $pdo; $event = new Modele('events'); $event->fetch($_GET['event']); $event->assignTemplate('event'); $section = new Modele('sections'); $section->fetch($_REQUEST['section']); $section->assignTemplate('section'); $queryFields = array('part_duration', 'part_title', 'part_justification'); $mdl = new Modele('participations'); $tpl->assign('form', $mdl->edit($queryFields)); if (isset($_POST['edit'])) { $data = array('part_section' => $section->section_id, 'part_attribution_date' => date('Y-m-d'), 'part_status' => 'SUBMITTED', 'part_event' => $event->getKey()); foreach ($queryFields as $field) { $data[$field] = $_POST[$field]; } if (!$mdl->addFrom($data)) { redirect('section', 'details', array('section' => $section->section_id, 'hsuccess' => '0')); } $sql = $pdo->prepare('SELECT * FROM event_staff LEFT JOIN users ON user_id = est_user WHERE est_section = ? AND est_event = ?'); $sql->bindValue(1, $section->getKey()); $sql->bindValue(2, $event->getKey()); $sql->execute(); $mdlMark = new Modele('marks'); $dataMark = array('mark_participation' => $mdl->getKey()); while ($user = $sql->fetch()) { $markOk = $_POST['staff-' . $user['user_id'] . '-ok']; $markPeriod = $_POST['staff-' . $user['user_id'] . '-period']; $markMark = $_POST['staff-' . $user['user_id'] . '-mark']; if ($markOk == 'YES') { $dataMark['mark_user'] = $user['user_id']; $dataMark['mark_period'] = $markPeriod; $dataMark['mark_mark'] = $markMark; $mdlMark->addFrom($dataMark); } } redirect('event', 'staff_activities', array('event' => $event->getKey(), 'section' => $section->section_id, 'hsuccess' => '1')); } $types = new Modele('user_types'); $types->find(); $repPeriods = array(); while ($type = $types->next()) { $periods = $pdo->prepare('SELECT * FROM periods WHERE period_start < NOW() AND period_end > NOW() AND period_type = ? AND period_state = "ACTIVE"'); $periods->bindValue(1, $types->ut_id); $periods->execute(); while ($period = $periods->fetch()) { if (!isset($repPeriods[$types->ut_id])) { $repPeriods[$types->ut_id] = array(); } $repPeriods[$types->ut_id][] = $period; } } $tpl->assign('periods', $repPeriods); $sql = $pdo->prepare('SELECT * FROM event_staff LEFT JOIN users ON user_id =est_user WHERE est_section = ? AND est_event = ? ORDER BY user_name'); $sql->bindValue(1, $section->getKey()); $sql->bindValue(2, $event->getKey()); $sql->execute(); while ($user = $sql->fetch()) { $tpl->append('staffs', $user); } display(); }