public function lijst($parameters)
{
$starget = new securitytarget();
$starget->setId('voorinschrijving_lijst');
if (!myacl::isAllowed(myauth::getCurrentuser(), $starget, 'view')) {
return;
}
$template = new ui($this);
$uurModel = new uurModel();
$ingeschrevenModel = new ingeschrevenModel();
$trajectModel = new trajectModel();
$userModel = new userModel();
$form = new form($parameters);
$select = new selectField('wat', '', '');
$select->addOption(new selectoptionField('Alles', '9990'));
$daggroup = new selectoptgroupField('Dagen');
$daggroup->addOption(new selectoptionField('Zaterdag', '6661'));
$daggroup->addOption(new selectoptionField('Zondag', '4442'));
$select->addOptgroup($daggroup);
$trajecten = $trajectModel->get();
$trajectgroup = new selectoptgroupField('Trajecten');
foreach ($trajecten as $tr) {
$trajectgroup->addOption(new selectoptionField($tr->getName(), 888 . $tr->getId()));
}
$select->addOptgroup($trajectgroup);
$typegroup = new selectoptgroupField('Type');
$typegroup->addOption(new selectoptionField('Personeel', '1114'));
$typegroup->addOption(new selectoptionField('VIP', '1115'));
$select->addOptgroup($typegroup);
$uren = $uurModel->get();
$uurgroup = new selectoptgroupField('Uren - Zaterdag');
$uurgroup2 = new selectoptgroupField('Uren - Zondag');
foreach ($uren as $uur) {
if ($uur->getDag() == 1) {
$uurgroup->addOption(new selectoptionField($uur->getUur(), 777 . $uur->getId()));
} else {
$uurgroup2->addOption(new selectoptionField($uur->getUur(), 555 . $uur->getId()));
}
}
$select->addOptgroup($uurgroup);
$select->addOptgroup($uurgroup2);
$form->addField($select);
$template->assign('form', $form);
$terug = new pagerequest(1);
$template->assign('terug', $terug);
if (!$form->isSent()) {
$wat = 9990;
} else {
$wat = $form->getFieldvalue('wat');
}
$mode = substr($wat, 0, 3);
$modevalue = substr($wat, 3);
if ($mode == 999 || $mode == 888) {
$dag = 0;
} elseif ($mode == 777 || $mode == 666) {
$dag = 1;
} elseif ($mode == 555 || $mode == 444) {
$dag = 2;
}
if ($dag == 0) {
$lijst[0]['dag'] = 'Zaterdag';
$lijst[1]['dag'] = 'Zondag';
} elseif ($dag == 1) {
$lijst[0]['dag'] = 'Zaterdag';
} elseif ($dag == 2) {
$lijst[1]['dag'] = 'Zondag';
}
foreach ($lijst as $dag => $lijstelement) {
$dag++;
if ($mode == 888) {
$uurCond = array('AND' => array('dag' => array('mode' => '=', 'value' => $dag), 'trajectid' => array('mode' => '=', 'value' => $modevalue)));
} elseif ($mode == 777 || $mode == 555) {
$uurCond = array('AND' => array('id' => array('mode' => '=', 'value' => $modevalue)));
} else {
$uurCond = array('AND' => array('dag' => array('mode' => '=', 'value' => $dag)));
}
$uren = $uurModel->get($uurCond);
foreach ($uren as $uur) {
$tempuur = array();
$tempuur['uur'] = $uur;
$gasten = $ingeschrevenModel->getfromUurid($uur->getId());
$tempuur['aantal'] = 0;
foreach ($gasten as $gast) {
$tempgast = array();
$tempgast['gast'] = $gast;
if ($mode == 111) {
if ($gast->getUserid() != $modevalue) {
continue;
}
}
if ($gast->getRegistrationtime() > time() - 60 * 60 * 24) {
$tempgast['new'] = 'true';
} else {
$tempgast['new'] = 'false';
}
$sameip = $ingeschrevenModel->getfromIpaddress($gast->getIpaddress());
if (count($sameip) > 1) {
$tempgast['sameip']['aantal'] = count($sameip);
$tempgast['sameip']['wie'] = $sameip;
$showrequest = new ajaxrequest('myvoorinschrijving', 'showsameip', array('id' => $gast->getId()));
$hiderequest = new ajaxrequest('myvoorinschrijving', 'hidesameip', array('id' => $gast->getId()));
$tempgast['sameip']['showrequest'] = $showrequest;
$tempgast['sameip']['hiderequest'] = $hiderequest;
} else {
$tempgast['sameip'] = 0;
}
$showmorerequest = new ajaxrequest('myvoorinschrijving', 'showmore', array('id' => $gast->getId()));
$hidemorerequest = new ajaxrequest('myvoorinschrijving', 'hidemore', array('id' => $gast->getId()));
$tempgast['showmorerequest'] = $showmorerequest;
$tempgast['hidemorerequest'] = $hidemorerequest;
$deleterequest = new ajaxrequest('myvoorinschrijving', 'deletegast', array('gastid' => $gast->getId()));
$tempgast['deleterequest'] = $deleterequest;
$user = $userModel->getfromId($gast->getUserid());
$tempgast['user'] = $user[0];
$tempuur['aantal'] += $gast->getAantal();
$tempuur['gasten'][] = $tempgast;
}
if (count($tempuur['gasten']) > 0) {
if (!isset($lijst[$dag - 1]['trajecten'][$uur->getTrajectid()]['traject'])) {
$traject = $trajectModel->getfromId($uur->getTrajectid());
$lijst[$dag - 1]['trajecten'][$uur->getTrajectid()]['traject'] = $traject[0];
}
$lijst[$dag - 1]['trajecten'][$uur->getTrajectid()]['uren'][] = $tempuur;
}
}
}
foreach ($lijst as $id => $dag) {
if (count($dag['trajecten']) == 0) {
unset($lijst[$id]);
}
}
$template->assign('lijst', $lijst);
$this->response->assign($this->self, 'innerHTML', $template->fetch('myvoorinschrijving_lijst.tpl'));
}
public static function getCurrentuser()
{
require FRAMEWORK . DS . 'conf' . DS . 'auth.php';
if (!self::$currentuser instanceof userObject) {
if (isset($_COOKIE['userid']) && isset($_COOKIE['challenge'])) {
$loginModel = new loginModel();
$useridCond['userid'] = array('mode' => '=', 'value' => $_COOKIE['userid']);
$challengeCond['challenge'] = array('mode' => '=', 'value' => $_COOKIE['challenge']);
$cond['AND'] = array($useridCond, $challengeCond);
$logins = $loginModel->get($cond);
// This should give us 1 hit
if (count($logins) == 1) {
$userid = $_COOKIE['userid'];
$model = new userModel();
$tmp = $model->getfromId($userid);
} else {
$userid = $defaultUserid;
$model = new userModel(1);
$tmp = $model->getfromId($userid);
}
} elseif ($_SERVER['REMOTE_USER'] != '' && !isset($_COOKIE['noremoteuser'])) {
$cred = explode('\\', $_SERVER['REMOTE_USER']);
if (count($cred) == 2) {
list($domainpart, $user) = $cred;
} else {
$user = $cred;
}
$model = new userModel();
$tmp = $model->getfromUsername(addslashes($user));
if (count($tmp) == 1) {
$userid = $tmp[0]->getId();
} else {
$userid = $defaultUserid;
$tmp = $model->getfromId($userid);
}
} else {
$userid = $defaultUserid;
$model = new userModel(1);
$tmp = $model->getfromId($userid);
}
if (count($tmp) != 1) {
throw new Exception('user could not be retrieved');
}
self::$currentuser = $tmp[0];
}
/*
if(! (self::$currentuser instanceof userObject ) ){
$user = new userObject();
$user->setId('c5c1c65fd9d4144aafb6fe15abc7f366');
$user->setName('Tim D\'Hooge - FAKE');
$user->setUsername('tim.dhooge');
$user->setDescription('');
$user->setMail('');
$user->setMemberof(array('CN=dienst_informatica,OU=Diensten,OU=Groepen,DC=stadskliniek,DC=lokeren,DC=be'));
$user->setGroupid(array('799045fc4d2cee4090c2c5fb5a121942'));
self::$currentuser = $user;
}
*/
$_SESSION['authenticated_user'] = self::$currentuser->getName();
return self::$currentuser;
}
