public function registration() { $bookhouse = new Model_BookhouseModel(); $bookhouse->loadActiveBookhouse(); if ($bookhouse->getCanUserRegister() == 0) { $this->setValidationError('Bookhouse', 'Registration is disabled'); } $userCheckModel = new Model_UserModel(); $userCheckModel->load(array('user_name' => $this->getUserName())); $userId = $userCheckModel->getUserId(); if (isset($userId)) { $this->setValidationError('username', 'Username already exist'); return; } $userCheckModel->load(array('email' => $this->getEmail())); $userId = $userCheckModel->getUserId(); if (isset($userId)) { $this->setValidationError('username', 'Email already exist'); return; } $this->setLastLogin(date('Y-m-d H:i:s')); $this->setUserStatusIdFK(3); $this->setBanned(0); $this->setEmailValidated(0); $this->insert(); $userIdFK = $this->getConnection()->getInsertId(); $transaction = new Model_TransactionModel(); $transaction->setUserIdFK($userIdFK); $transaction->setTransactionTypeIdFK(1); $transaction->setMoney($bookhouse->getDefaultMoneyValue()); $transaction->setTransactionTypeIdendifier(null); $transaction->insert(); }
private function setBookhouseTable() { $bookhouse = $this->bookhouseTableWithPanel->getTable(); $bookhouseModel = new Model_BookhouseModel(); $bookhouseModel->addQuery('select', array('table' => $bookhouseModel->getTableName())); $this->bookhouseTableWithPanel->setModel($bookhouseModel); $this->bookhouseTableWithPanel->isAddButtonEnabled(false); $this->bookhouseTableWithPanel->isDeleteEnabled(false); $bookhouse->addColumn(array('key' => 'bookhouse_id', 'label' => 'ID')); $bookhouse->addColumn(array('key' => 'house_name', 'label' => 'Bookhouse')); $bookhouse->addColumn(array('key' => 'default_money_value', 'label' => 'Default Money')); $bookhouse->addColumn('{key:"can_user_register",label:"Can User Register",allowHTML:true,formatter:' . $bookhouse->getFormatter('selectYesNo', array('attributes' => array('name' => 'model[' . $this->bookhouseTableWithPanel->getModelName() . '][can_user_register]'))) . '}', false, 'can_user_register'); $bookhouse->addColumn('{key:"active",label:"Active",allowHTML:true,formatter:' . $bookhouse->getFormatter("selectYesNo", array('attributes' => array('name' => 'model[' . $this->bookhouseTableWithPanel->getModelName() . '][active]'))) . '}', false, 'active'); }
private function setSportsTablePanel() { $this->sportsTableWithPanel = new Extension_View_Yui35_DataTableEdit(); $sports = $this->sportsTableWithPanel->getTable(); $sportsModel = new Model_SportsModel(); $sportsModel->addQuery('select', array('table' => $sportsModel->getTableName())); $sportsModel->addQuery('order', array('order' => implode($sportsModel->getPrimaryKeys(), ",") . ' DESC')); $sportsModel->addQuery('limit', array('limit' => 20)); $this->sportsTableWithPanel->setModel($sportsModel); $this->sportsTableWithPanel->setRowsPerPage(20); $sports->addColumn(array('key' => 'sports_id', 'label' => 'ID')); $sports->addColumn(array('key' => 'name_of_sport', 'label' => 'Sport')); $bookhouseModel = new Model_BookhouseModel(); $bookhouseModel->addQuery('select', array('table' => $bookhouseModel->getTableName())); $bookhouseCollection = new Core_Model_Adapter_ModelCollection(); $bookhouseCollectionData = $bookhouseCollection->getModelCollection($bookhouseModel); $sports->addColumn('{key:"bookhouse_id_FK",label:"Bookhouse",allowHTML:true,formatter:' . $sports->getFormatter("selectFromModel", array('values' => $bookhouseCollectionData, 'value' => 'bookhouse_id', 'label' => 'house_name', 'attributes' => array('name' => 'model[' . $this->sportsTableWithPanel->getModelName() . '][bookhouse_id_FK]'))) . '}', false, 'active'); }