Add a /open page

[hkirat]

Should share the number of users, number of models trained, number of images generated, number of pack create requests, total revenue.
Should also have daily charts of the same

[dev17sh]

Since, /open page contains details of number of users , total revenue and other important details . It should be authorized to certain users.

Maybe adding a isAdmin Boolean @default(false) in user table .
And setting its value true for certain users.

In frontend adding a button Metrics or Stats which will be only visible for users who are authorized and then on clicking it will redirect us to /open page and there it will fetch data from the database and show it on the page.

Also /open page will be protected if any users who are not authorized trying to access directly will be redirected back to /dashboard page.

Is it a right approach or should i do something else ?

[hkirat]

Nope it should be open. Similar to https://cal.com/open

[dev17sh]

@yashmakhija can you help me in setting the project
there is an issue while running the project locally

while running the container after building the docker image it say missing secret key from clerk/nextjs
i even pass the key as -e NEXT_PUBLIC_CLERK_PUBLISHABLE_KEY= while running the container

can you tell me how did you setup yours

[yashmakhija]

@dev17sh We have updated our README.md file. Please follow the process as described. If you continue to experience any issues, kindly let me know.

[dev17sh]

frontend has been running smoothly
while running backend it required STRIPE_SECRET_KEY is created one and provided it

it also requires RAZORPAY_KEY_ID and RAZORPAY_KEY_SECRET i tried to create it requires the bank details and all kyc
is there a way to skip the setup to RAZORPAY_KEY_ID and RAZORPAY_KEY_SECRET (i think there isn't)

also /open page has default appbar

i think it should not be the part of the page
just simple stats and charts

[yashmakhija]

@dev17sh You need to provide RAZORPAY_KEY_ID and RAZORPAY_KEY_SECRET because the backend has a check that requires these values before continuing. Unfortunately, there's no way to skip this setup as Razorpay requires full KYC and bank details to generate API keys.

[hanuchaudhary]

hey @dev17sh If you are not doing it, then please let me know.

[IkramBagban]

Hey @hkirat @yashmakhija
could you assign me this issue? I’ll make sure it includes the number of users, models trained, images generated, pack create requests, and total revenue.

[IkramBagban]

Hi @hkirat I've resolved the issue. In PR #48

I've added statistics, daily charts, and implemented ISR to revalidate the data every hour

[hanuchaudhary]

@hkirat What if we create a separate DATA_SET table for storing data for /open page like:

model DailyStats {
id Int @id @default(uuid())
date DateTime @unique
userCount Int
trainedModelCount Int
generatedImageCount Int
revenue Float
}

and just store day by day using some sort of cron-job.
and using Redis for cache it.
What's your opinion?

and Checkout this issue as well #65

[IkramBagban]

@hkirat What if we create a separate DATA_SET table for storing data for /open page like:

model DailyStats { id Int @id @default(uuid()) date DateTime @unique userCount Int trainedModelCount Int generatedImageCount Int revenue Float }

and just store day by day using some sort of cron-job. and using Redis for cache it. What's your opinion?

and Checkout this issue as well #65

I don't think we need that. as my current implemention caches the stats data and revalidate every 24hours. So it's not an expensive operation.