mirror of
https://github.com/ngthanhvu/kr-phim.git
synced 2026-08-10 16:07:47 +00:00
ngthanhvu
d982449464
- Implemented AuthModal.vue for user login and registration with form handling. - Created useAuth composable for managing user state and authentication requests. - Added admin route middleware to protect admin routes. - Developed admin login page with authentication checks. - Implemented API endpoints for user management (login, logout, fetch user, register). - Created database migrations for users table and updated movies table. - Added utility functions for password hashing and JWT token management.
39 lines
924 B
TypeScript
39 lines
924 B
TypeScript
import { users } from '../../database/schema'
|
|
import { desc, like, sql } from 'drizzle-orm'
|
|
|
|
export default defineEventHandler(async (event) => {
|
|
const db = useDb()
|
|
const query = getQuery(event)
|
|
const keyword = typeof query.keyword === 'string' ? query.keyword.trim() : ''
|
|
|
|
const whereClause = keyword
|
|
? like(users.name, `%${keyword}%`)
|
|
: undefined
|
|
|
|
const [items, countResult] = await Promise.all([
|
|
db
|
|
.select({
|
|
id: users.id,
|
|
name: users.name,
|
|
email: users.email,
|
|
role: users.role,
|
|
avatar: users.avatar,
|
|
active: users.active,
|
|
createdAt: users.createdAt,
|
|
})
|
|
.from(users)
|
|
.where(whereClause)
|
|
.orderBy(desc(users.createdAt))
|
|
.limit(100),
|
|
db
|
|
.select({ count: sql<number>`count(*)` })
|
|
.from(users)
|
|
.where(whereClause),
|
|
])
|
|
|
|
return {
|
|
items,
|
|
total: countResult[0]?.count ?? 0,
|
|
}
|
|
})
|