/** * @param $result * @return base_database_statement_Insert|base_database_statement_Update * @throws base_database_Exception */ protected function getStatementForImport($result) { if (empty($result)) { $statement = new base_database_statement_Insert(); return $statement; } else { $statement = new base_database_statement_Update(); $colPK = $this->table->getColumn('PK'); $statement->setWhere(DB::where($colPK, DB::intTerm($result))); return $statement; } }
public function count($historic = false) { $columns = array($this->table->getColumn('LK')); if ($historic == false) { if (empty($this->where)) { $this->where = DB::where($this->table->getColumn('histtop'), DB::term('Y')); } else { $this->where->addAnd($this->table->getColumn('histtop'), DB::term('Y')); } } if (empty($this->order)) { $this->order = new base_database_Order($this->table->getColumn('LK'), base_database_Order::ASC); } $select = $this->_createSelectStatement($columns); $result = $select->fetchDatabase(); return count($result); }
/** * set existing actual revision of the object to self::HISTORIC * * @param $table * @param $historicValue * @return base_database_statement_Update * @throws base_database_Exception */ private function _setHistoricData(base_database_Table $table, $historicValue) { $statement = new base_database_statement_Update(); $where = DB::where($table->getColumn('histtop'), DB::term(self::ACTUAL)); $where->addAnd($table->getColumn('LK'), DB::intTerm((int) $this['LK'])); $statement->setTable($table); $statement->setWhere($where); $statement->setColumnValue($table->getColumn('histtop'), DB::term($historicValue)); $statement->insertDatabase(); }
private static function _updateLoginTries(base_database_Table $table, User $user) { $loginTries = $user['loginTries']; $where = DB::where($table->getColumn('userid'), DB::term($user['userid'])); if ($loginTries < self::LOGIN_MAX_TRIES) { $loginTries++; self::_updateUserLoginData($table, $where, array('loginTries' => DB::term($loginTries))); return self::LOGIN_FAILURE; } if ($loginTries >= self::LOGIN_MAX_TRIES) { self::_updateUserLoginData($table, $where, array('disabled' => DB::term(self::USER_DISABLED))); return self::LOGIN_USER_DISABLED; } return self::LOGIN_FAILURE; }