Let me first understand the full current state of the codebase and database before making changes.

Checked DB schema

Now let me read the rest of the sales page, the dashboard, and get all DB tables:

Now I have the full picture. Let me also check what tables exist in the DB so I can wipe them properly:

Loaded SQL tool

Listed all tables

Listed all tables

Now I have the full picture. Let me set up a plan and execute:

Task 1: Wipe all DB data except users.

Wiped all data

All data wiped. Let me verify users are still there:

Verified users

User preserved. Now let me also add a balance_transactions table for tracking cash-to-bank transfers and manual adjustments:

Created balance_transactions

Good. Now let me move to Task 2 - fix the sales page to allow closing only once per day, and update today's sales on the dashboard:

I need to rewrite the sales page to enforce once-per-day closing, and update the dashboard to show today's sales. Let me also check the sales table schema and how daily_balances is structured:

Checked sales schema

Checked daily_balances schema

Now I have the full schema. The sales page currently has a complex flow with nozzle readings and closing. I need to rewrite it so:

1. User can enter closing readings and record sales only ONCE per day
2. If already closed for today, show a read-only summary
3. Update daily_balances with the cash/bank totals from sales

Let me also check the nozzle_readings table:

Checked nozzle_readings

Now I have everything I need. Let me rewrite the sales page to enforce one closing per day, and then update the dashboard: