PERAK 2023: Open Recruitement Boilerplate

Task Link: TugasOprecWebdev

This boilerplate already provides you the Prisma schemes and TRPC queries to develop the application, so you just have to implement the frond-end (Next.js) features of this application using the provided schemes and queries. You can add any schemes or queries if you think it's needed.

This is a T3 Stack project bootstrapped with create-t3-app. Use Next Stride to keep the consistency across your project structure and source code. If you are not familiar with the different technologies used in this project, please refer to the respective docs. If you still are in the wind, please join our contact person and ask for help.

• Next.js
• Prisma
• Tailwind CSS
• tRPC
• Next Stride

To run this project

1. Make sure to make .env file. Create DATABASE_URL variable in that file, you can use the default SQLite, just copy the DATABASE_URL inside .env.sample or you can use you're preferred DB client (ex: PostgresSQL, etc).
2. Run npm install to install all the dependencies.
3. Run npx prisma db push to sync you scheme to the database. Run npx prisma studio to manage your data in the database.
4. Run npm run dev to run the application on your localhost. Please read the documentation for more commands and information about the stack!

Queries and Mutations

You can check the TRPC routers inside src/server/api/root.ts

• game (src/server/api/routers/game.ts)
  • getGames : to GET all the games in the database (paymentInfos included)
  • getGame : to GET one game by id
• auth (src/server/api/routers/auth.ts)
  • getUserTypes : to GET all the user types in the database (The user types you need to add is "Elemen" and "Mahasiswa")
  • register : to POST registration data to the database, the fields are:
    • name: string
    • contactInfo: string
    • nickname: string
    • npm: string
    • registerGameId: string (References Game)
    • typeId: string (References UserType)

Learn More

To learn more about the T3 Stack, take a look at the following resources:

• Documentation
• Learn the T3 Stack — Check out these awesome tutorials You can check out the create-t3-app GitHub repository — your feedback and contributions are welcome!

Good luck, have fun!