private function getRegistrationForm()
{
$db = Core_Database::__getInstance();
$login = Core_Login::__getInstance();
$text = Core_Text::__getInstance();
$text->setFile('account');
$text->setSection('register');
// Check for input
$firstname = Core_Tools::getInput('_POST', 'firstname', 'varchar');
$name = Core_Tools::getInput('_POST', 'name', 'varchar');
$email = Core_Tools::getInput('_POST', 'email', 'varchar');
$pass1 = Core_Tools::getInput('_POST', 'password1', 'varchar');
$pass2 = Core_Tools::getInput('_POST', 'password2', 'varchar');
$showform = true;
if ($firstname && $name && $email && $pass1 && $pass2) {
// Second check: E-mail
$chk = $db->select('players', array('plid'), "email = '" . $db->escape($email) . "'");
if (count($chk) == 1) {
$warning = $text->get('emailFound');
} else {
// Seems to be alright... let's continue the quest.
if ($pass1 != $pass2) {
$warning = $text->get('passFault');
} else {
$login->registerAccount($firstname, $email, $pass1, $firstname, $name);
$showform = false;
if ($login->isLogin()) {
// Post a redirect, just to be sure ;-)
header('Location: ' . Pages_Page::getUrl('page=register'));
return $this->getChooseCompany();
} else {
return '<p>' . $text->get('done') . '</p>';
}
}
}
} elseif ($firstname || $name || $email || $pass1 || $pass2) {
$warning = $text->get('complete');
}
if ($showform) {
$page = new Core_Template();
$page->set('form_action', self::getUrl('page=register'));
$page->set('title', $text->get('title'));
$page->set('about', $text->get('about'));
$page->set('contactDetails', $text->get('contactDetails'));
if (isset($warning)) {
$page->set('warning', $warning);
}
// Form fields
$page->set('name', $text->get('name'));
$page->set('firstname', $text->get('firstname'));
$page->set('email', $text->get('email'));
$page->set('password1', $text->get('password1'));
$page->set('password2', $text->get('password2'));
$page->set('submit', $text->get('submit'));
// Form field values
$page->set('name_value', Core_Tools::getInput('_POST', 'name', 'varchar', null));
$page->set('firstname_value', Core_Tools::getInput('_POST', 'firstname', 'varchar', null));
$page->set('email_value', Core_Tools::getInput('_POST', 'email', 'varchar', null));
return $page->parse('register.tpl');
}
}
protected function getLogin()
{
$login = Core_Login::__getInstance();
$text = Core_Text::__getInstance();
$page = new Core_Template();
// Check for login input
$username = Core_Tools::getInput('_POST', 'email', 'varchar');
$password = Core_Tools::getInput('_POST', 'password', 'varchar');
$page->set('login', $text->get('login', 'login', 'main'));
$page->set('logout', $text->get('logout', 'login', 'main'));
$page->set('logout_url', self::getUrl('page=home&logout=true'));
$page->set('loginAction', self::getUrl('page=home'));
if ($username && $password) {
if (!$login->login($username, $password)) {
$page->set('warning', $text->get($login->getWarnings(), 'login', 'main', $login->getWarnings()));
}
}
if ($login->isLogin()) {
// Already logged in.
$page->set('isLogin', true);
$myself = Profile_Member::getMyself();
$page->set('myName', Core_Tools::putIntoText($text->get('welcome', 'login', 'main'), array(Core_Tools::output_varchar($myself->getUsername()))));
} else {
// Login form
$page->set('isLogin', false);
$page->set('email', $text->get('email', 'login', 'main'));
$page->set('password', $text->get('password', 'login', 'main'));
$page->set('submit', $text->get('submit', 'login', 'main'));
$page->set('lostpass', $text->get('lostpass', 'login', 'main'));
$page->set('lostpass_url', self::getUrl('page=lostPassword'));
}
return $page->parse('blocks/login.tpl');
}
public function getRegStatus()
{
$this->loadData();
$login = Core_Login::__getInstance();
$db = Core_Database::__getInstance();
if (!$login->isLogin()) {
return 0;
} else {
// logged in
$chk = $db->select('players_comp', array('c_id'), "plid = '" . $this->id . "'");
if (count($chk) == 0 && intval($this->data['noCompany']) != 1) {
return 1;
} else {
return 2;
}
}
}
public function getShopManagement($objShop)
{
$login = Core_Login::__getInstance();
$db = Core_Database::__getInstance();
$text = Core_Text::__getInstance();
$text->setFile('shop');
$text->setSection('manager');
// Check for input
$input = Core_Tools::getInput('_POST', 'submit', 'varchar');
if ($input == 'saveSettings') {
$this->processManagementInput($objShop);
}
$page = new Core_Template();
$categories = $objShop->getCategories();
$colsToShow = $objShop->getMaxPricesPerCategory($categories);
foreach ($categories as $v) {
$page->addListValue('categories', array('id' => $v['c_id'], 'name' => Core_Tools::output_varchar($v['c_name'])));
}
$page->set('priceColsToShow', $colsToShow);
$page->set('title', Core_Tools::putIntoText($text->get('title'), array(Core_Tools::output_varchar($objShop->getName()))));
$page->set('message', $text->get('message'));
$page->set('message_value', Core_Tools::output_form($objShop->getMessage()));
$page->set('products', $text->get('products'));
$page->set('productName', $text->get('productName'));
$page->set('productText', $text->get('productText'));
$page->set('productPrice', $text->get('productPrice'));
$page->set('noRows', $text->get('noRows'));
$page->set('submit', $text->get('submit'));
$page->set('formAction', self::getUrl('page=shop&id=' . $objShop->getId() . '&action=manage'));
// Add row link
$page->set('toAddRow', $text->getClickTo($text->get('toAddRow')));
$page->set('addRow', $text->get('addRow'));
$page->set('editCategory', $text->get('editCategory'));
$page->set('editCategory_url', self::getUrl('page=shop&id=' . $objShop->getId() . '&action=categories'));
// Loop products
$products = $objShop->getProducts();
foreach ($products as $v) {
// Fetch the prices
$page->addListValue('products', array($v['p_id'], Core_Tools::output_form($v['p_name']), Core_Tools::output_form($v['p_info']), $v['prices'], $v['c_id']));
}
return $page->parse('shop_manage.tpl');
}
private function addPoefboekLog($objUser, $amount, $newAmount, $action, $actor = false, $comment = null)
{
if (!$actor) {
$login = Core_Login::__getInstance();
$actor = $login->getUserId();
}
$db = Core_Database::__getInstance();
// Insert log
$db->insert('players_poefboeklog', array('plid' => $objUser->getId(), 'c_id' => $this->getId(), 'l_amount' => $amount, 'l_newpoef' => $newAmount, 'l_date' => 'NOW()', 'l_action' => $action, 'l_actor' => $actor, 'l_description' => $comment));
}
private function getChangePassword($id, $key)
{
$text = Core_Text::__getInstance();
$text->setFile('main');
$text->setSection('lostpass');
// Check the key
$db = Core_Database::__getInstance();
$chk = $db->select('players', array('plid'), "plid = " . intval($id) . " AND seckey = '" . $db->escape($key) . "'");
if (count($chk) === 1) {
$password1 = Core_Tools::getInput('_POST', 'pass1', 'varchar');
$password2 = Core_Tools::getInput('_POST', 'pass2', 'varchar');
$page = new Core_Template();
$page->set('title', $text->get('changepass'));
$page->set('about', $text->get('aboutchange'));
$page->set('pass1', $text->get('pass1'));
$page->set('pass2', $text->get('pass2'));
$page->set('submit', $text->get('submitchange'));
if ($password1 && $password1 === $password2) {
$login = Core_Login::__getInstance();
$login->setPassword($chk[0]['plid'], $password1);
$page->set('success', $text->get('passchanged'));
} elseif ($password1 || $password2) {
$page->set('warning', $text->get('passmismatch'));
}
return $page->parse('lostPassword_res.tpl');
} else {
return '<p class="false">Security Key Not Found.</p>';
}
}
private function getSubmitOrder($id)
{
$text = Core_Text::__getInstance();
$text->setFile('order');
$text->setSection('submit');
$login = Core_Login::__getInstance();
if ($login->isLogin()) {
$userID = (int) $login->getUserId();
} else {
$userID = 0;
}
// Fetch the order
$db = Core_Database::__getInstance();
$order = $db->getDataFromQuery($db->customQuery("\r\n\t\t\tSELECT\r\n\t\t\t\t*\r\n\t\t\tFROM\r\n\t\t\t\torders\r\n\t\t\tLEFT JOIN\r\n\t\t\t\tcompanies ON orders.c_id = companies.c_id\r\n\t\t\tLEFT JOIN\r\n\t\t\t\tplayers_comp ON players_comp.c_id = companies.c_id\r\n\t\t\t\tAND players_comp.plid = '" . $userID . "'\r\n\t\t\tWHERE\r\n\t\t\t\to_id = '" . (int) $id . "'\r\n\t\t"));
if (count($order) == 1 && $order[0]['o_isDone'] == 0 && $order[0]['compStatus'] > 0) {
$key = Core_Tools::getInput('_POST', 'confirmKey', 'varchar');
if ($key && Core_Tools::checkConfirmLink($key)) {
$this->doSubmit($order[0]);
return $this->getOrderPrint($order[0]['o_id']);
} else {
return $this->getSubmitForm($order[0]);
}
} else {
return '<p>Invalid input.</p>';
}
}
private function getCompanyOverview($objCompany)
{
$text = Core_Text::__getInstance();
$text->setFile('company');
$text->setSection('overview');
$db = Core_Database::__getInstance();
$login = Core_Login::__getInstance();
$page = new Core_Template();
if ($objCompany->isFound()) {
// Everything okay, let's just continue our path to destruction.
$page->set('title', Core_Tools::putIntoText($text->get('title'), array(Core_Tools::output_varchar($objCompany->getName()))));
// Let's go for the other data
$data = $objCompany->getData();
foreach ($data as $k => $v) {
$page->set($k, Core_Tools::output_varchar($v));
}
$page->set('adres', $text->get('adres'));
$page->set('naam', $text->get('naam'));
$page->set('users', $text->get('users'));
$page->set('noUsers', $text->get('noUsers'));
$page->set('listusers', $text->get('listusers'));
$page->set('shops', $text->get('shops'));
$page->set('listshops', $text->get('listshops'));
$page->set('noShops', $text->get('noShops'));
$page->set('moderate', $text->get('moderate'));
$users = $objCompany->getUsers();
$page->set('userAmount', count($users));
// Get my status in here
$myself = Profile_Member::getMyself();
if ($myself) {
$myStatus = $objCompany->getUserStatus($myself);
if ($myStatus == 'administrator') {
$page->set('admin_user_link', self::getUrl('page=company&id=' . $objCompany->getId() . '&action=userman'));
$page->set('admin_user', $text->get('useradmin'));
$page->set('admin_edit_link', self::getUrl('page=company&id=' . $objCompany->getId() . '&action=edit'));
$page->set('admin_edit', $text->get('edit'));
}
if ($myStatus == 'moderator' || $myStatus == 'administrator') {
$page->set('admin_shops_link', self::getUrl('page=company&id=' . $objCompany->getId() . '&action=shopman'));
$page->set('admin_shops', $text->get('shopadmin'));
$page->set('admin_poefboek_link', self::getUrl('page=company&id=' . $objCompany->getId() . '&action=poefboek'));
$page->set('admin_poefboek', $text->get('poefboek'));
// Poefboek content
$page->set('poeftotal', $text->get('poeftotal'));
$page->set('poeftotal_value', '€ ' . Core_Tools::convert_price($objCompany->getPoefboekTotal()));
}
$showPoefboek = true;
} else {
$showPoefboek = false;
}
foreach ($users as $v) {
$page->addListValue('users', array(Core_Tools::output_varchar($v[0]->getFullname()), $text->get($v[1], 'userstatus', 'company', $v[1]), $showPoefboek ? Core_Tools::convert_price($v[2]) : null, Pages_Page::getUrl('page=company&id=' . $objCompany->getId() . '&action=poeflog&uid=' . $v[0]->getId())));
}
// Broodjeswinkels
$shops = $objCompany->getShops();
$page->set('shopAmount', count($shops));
foreach ($shops as $v) {
$page->addListValue('shops', array(Core_Tools::output_varchar($v->getName()), $v->canModerate($myself) ? self::getUrl('page=shop&id=' . $v->getId() . '&action=manage') : null, self::getUrl('page=shop&id=' . $v->getId())));
}
} else {
$page->set('title', $text->get('notFound'));
$page->set('notFound', $text->get('notFoundA'));
}
return $page->parse('company_overview.tpl');
}
