/** * Удалить запись * @return int * @throws \Base\Db\MySql\Exception */ public function delete() { return Service::db()->delete('DELETE FROM ' . static::$TABLE . ' WHERE id = :id', ['id' => $this->id]); }
/** * Грузим по токену * @param $token * @return null */ public function loadByToken($token) { $data = Service::db()->select('SELECT ' . implode(',', static::$fields) . ' FROM ' . self::$TABLE . " WHERE token = :token AND UNIX_TIMESTAMP(tokenExpired) > UNIX_TIMESTAMP(:tokenExpired) LIMIT 0,1", ['token' => $token, 'tokenExpired' => date('Y-m-d H:i:s')]); if (isset($data[0])) { $this->assign($data[0]); } return $this; }