/** Setup index page
*/
public function indexAction()
{
$content = new Content();
$this->view->contents = $content->getFrontContent('database');
$thumbs = new Slides();
$this->view->thumbs = $thumbs->getLast10Thumbnails(4);
$finds = new Finds();
$this->view->counts = $finds->getCountAllFinds();
$recent = new Logins();
$this->view->logins = $recent->todayVisitors();
$form = new SolrForm();
$form->setMethod('post');
$this->view->form = $form;
$values = $form->getValues();
if ($this->getRequest()->isPost() && $form->isValid($_POST)) {
if ($form->isValid($form->getValues())) {
$params = array_filter($form->getValues());
$params = $this->array_cleanup($params);
$this->_flashMessenger->addMessage('Your search is complete');
$this->_helper->Redirector->gotoSimple('results', 'search', 'database', $params);
} else {
$form->populate($data);
}
}
}
public function login()
{
/*
$db = ECPFactory::getDbo();
* */
ecpimport("helpers.cryptology");
$db = ECPFactory::getPDO("Logins");
$pasw = 'c17a1a963e2b9ebb228030c0615fdb4bd91bd982';
//$pasw = ECPFactory::getForm("login")->pasw->value;
$login = '******';
$loginpin = ECP_Cryptology::generateInteger(30);
$pinhash = ECP_Cryptology::generateHash($loginpin);
$log = new Logins();
$log->setLogin($login)->setPaswoord($pasw);
$results = Logins::findByExample($db, $log);
if (empty($results)) {
//email en ww komt niet overeen
return false;
} else {
foreach ($results as $result) {
$id = $result->getId();
$result->setIpadres($_SERVER['REMOTE_ADDR'])->setLoginpin($pinhash);
$count = $result->updateToDatabase($db);
if ($count != l) {
return 2;
} else {
return array("uid" => $id, "pin" => $loginpin);
}
}
}
}
/** Work out how many people have used a certain IP address
*/
public function iptousersAction()
{
if ($this->_getParam('ip', false)) {
$ip = $this->_getParam('ip');
$this->view->headTitle('Users who have used IP address: ' . $ip);
$logins = new Logins();
$this->view->logins = $logins->users2Ip($ip);
} else {
throw new Pas_Exception_Param($this->_missingParameter);
}
}
/** Setup index page
* @access public
* @return void
*/
public function indexAction()
{
$content = new Content();
$this->view->contents = $content->getFrontContent('database');
$recent = new Logins();
$this->view->logins = $recent->todayVisitors();
$form = new SolrForm();
$form->q->setLabel('Search our database: ');
$form->setMethod('post');
$this->view->form = $form;
if ($this->getRequest()->isPost() && $form->isValid($this->_request->getPost())) {
$functions = new Pas_ArrayFunctions();
$params = $functions->array_cleanup($form->getValues());
$params = $this->process($params);
$this->getFlash()->addMessage('Your search is complete');
$this->_helper->Redirector->gotoSimple('results', 'search', 'database', $params);
} else {
$form->populate($this->_request->getPost());
}
}
public function isValid($value, $context = null)
{
$value = (string) $value;
$this->_setValue($value);
if (is_array($context)) {
if (!isset($context['password'])) {
return false;
}
}
$dbAdapter = Zend_Registry::get('db');
$this->_authAdapter = new Zend_Auth_Adapter_DbTable($dbAdapter);
$this->_authAdapter->setTableName('users')->setIdentityColumn('username')->setCredentialColumn('password');
// get "salt" for better security
$salt = $this->_config->auth->salt;
$password = sha1($salt . $context['password']);
$this->_authAdapter->setIdentity($value);
$this->_authAdapter->setCredential($password);
$auth = Zend_Auth::getInstance();
$result = $auth->authenticate($this->_authAdapter);
if (!$result->isValid()) {
$this->_error(self::NOT_AUTHORISED);
return false;
}
//Updated the user table - this needs moving to the users model
$users = new Users();
$updateArray = array('visits' => new Zend_Db_Expr('visits + 1'), 'lastLogin' => Zend_Date::now()->toString('yyyy-MM-dd HH:mm'));
$where = array();
$where[] = $users->getAdapter()->quoteInto('username = ?', $value);
$users->update($updateArray, $where);
//Update login table needs moving to the login model
$logins = new Logins();
$data['loginDate'] = Zend_Date::now()->toString('yyyy-MM-dd HH:mm');
$data['userAgent'] = $_SERVER['HTTP_USER_AGENT'];
$data['ipAddress'] = $_SERVER['REMOTE_ADDR'];
$data['username'] = $value;
$insert = $logins->insert($data);
return true;
}
/** List user's logins
* @access public
* @return void
*/
public function loginsAction()
{
$logins = new Logins();
$this->view->logins = $logins->myLogins($this->getUsername(), $this->getParam('page'));
$this->view->ips = $logins->myIps($this->getUsername());
}
/**
* Fetch Logins which references this Overlegbasis. Will return null in case reference is invalid.
* `overlegbasis`.`coordinator_id` -> `logins`.`id`
*
* @param PDO $db a PDO Database instance
* @param array $sort array of DSC instances
* @return Logins
*/
public function fetchLogins(PDO $db, $sort = null)
{
$filter = array(Logins::FIELD_ID => $this->getCoordinatorId());
$result = Logins::findByFilter($db, $filter, true, $sort);
return empty($result) ? null : $result[0];
}
/**
* get single Logins instance from a DOMElement
*
* @param DOMElement $node
* @return Logins
*/
public static function fromDOMElement(DOMElement $node)
{
$o = new Logins();
$o->assignByHash(self::domNodeToHash($node, self::$FIELD_NAMES, self::$DEFAULT_VALUES, self::$FIELD_TYPES));
$o->notifyPristine();
return $o;
}
/**
* Fetch Logins's which this Gemeente references.
* `gemeente`.`zip` -> `logins`.`overleg_gemeente`
*
* @param PDO $db a PDO Database instance
* @param array $sort array of DSC instances
* @return Logins[]
*/
public function fetchLoginsCollection(PDO $db, $sort = null)
{
$filter = array(Logins::FIELD_OVERLEG_GEMEENTE => $this->getZip());
return Logins::findByFilter($db, $filter, true, $sort);
}
/**
* Fetch Logins's which this TpProject references.
* `tp_project`.`id` -> `logins`.`tp_project`
*
* @param PDO $db a PDO Database instance
* @param array $sort array of DSC instances
* @return Logins[]
*/
public function fetchLoginsCollection(PDO $db, $sort = null)
{
$filter = array(Logins::FIELD_TP_PROJECT => $this->getId());
return Logins::findByFilter($db, $filter, true, $sort);
}
public function eid()
{
include "openid.php";
$openid = new LightOpenID('localhost');
if ($openid->mode) {
$session = ECPFactory::getSession();
ecpimport("helpers.cryptology");
$loginpin = ECP_Cryptology::generateInteger(30);
$pinhash = ECP_Cryptology::generateHash($loginpin);
$user = $openid->getAttributes();
$achternaam = $user["namePerson/last"];
$postcode = $user["contact/postalCode/home"];
$adres = $user["contact/postalAddress/home"];
$db = ECPFactory::getPDO("Logins");
$log = new Logins();
$log->setAdres($adres)->setOverlegGemeente($postcode)->setNaam($achternaam);
$results = Logins::findByExample($db, $log);
if (empty($results)) {
//email en ww komt niet overeen
ecpexit("exit");
} else {
foreach ($results as $result) {
$id = $result->getId();
$result->setIpadres($_SERVER['REMOTE_ADDR'])->setLoginpin($pinhash);
$count = $result->updateToDatabase($db);
if ($count != l) {
return 2;
} else {
ecpexit("uid=>{$id},pin=>{$loginpin}");
}
}
}
} else {
//Step 2: Authentication, with requirements
$openid->identity = 'https://www.e-contract.be/eid-idp/endpoints/openid/auth-ident';
$openid->required = array('namePerson/first', 'namePerson/last', 'namePerson', 'person/gender', 'contact/postalCode/home', 'contact/postalAddress/home', 'contact/city/home', 'eid/nationality', 'eid/pob', 'birthDate', 'eid/card-number', 'eid/card-validity/begin', 'eid/card-validity/end');
//$openid->optional = array('');
header('Location: ' . $openid->authUrl());
}
}
