IN-HOUSE EMPLOYEE AUCTION

Admin Guide · managing bids, items, deadlines & directory
Admin access

This guide covers everything Admin needs to run the auction day-to-day: reviewing and deleting bids, setting the submission deadline, finding the highest bidder for each item, generating the final results list, and managing the item catalogue and employee directory.

What's in this guide
1. Logging In
  1. Go to yourdomain.com/admin.php (replace with your actual domain).
  2. Enter the admin password and click "Log in."
Security: The admin password is set in config.php. If you have not changed it from the default yet, do so before sharing the form link with employees — see Appendix A.2.
2. The Admin Dashboard

After logging in you'll see, in order:

3. Setting the Submission Deadline

Only Admin can set, change, or clear this — employees only ever see the result, never a way to edit it.

  1. Under "Submission deadline" on the dashboard, pick a date in the "Set / change deadline" field.
  2. Click "Save." The bid form immediately starts showing this date and a live day count to every employee who opens it.
  3. To remove the deadline entirely (so the form stops showing one), click "Clear deadline."

Employees see one of three messages depending on the date:

"X days remaining" while there's time left
"Today is the last day to submit a bid" on the deadline date itself
"This auction is now closed" once the date has passed
Note: Setting a deadline is informational only — it does not currently stop an employee from submitting a bid after the date has passed. Enforcing a hard cutoff would be a small follow-up change if you want it.
4. Viewing and Deleting Bids

Every submission appears in the table with the employee's details, the item(s) and bid amount(s), payment mode, and the confirmation checkboxes they ticked.

Deleting a bid

  1. Find the row you want to remove.
  2. Click "Delete" at the end of that row.
  3. Confirm when prompted — this cannot be undone.
Note: Deleting a bid removes that entire submission. If an employee bid on multiple items in one submission, deleting it removes all of those items' bids from that employee at once, since they were submitted together.
5. One Bid Per Employee — and how to let someone resubmit

Each Employee ID can submit only one bid. If they try again, the form blocks it and shows them the reference number of their existing bid instead of saving a new one.

If an employee needs to correct or change their bid, delete their existing submission (see Section 4 above). Once it's deleted, their Employee ID is immediately free to submit a new bid — this is the intended way to handle corrections.

6. Finding the Highest Bidder for an Item
  1. Under "Highest bidder lookup," choose an item from the dropdown (it lists every item that has at least one bid on it).
  2. Click "Find highest bidders."
  3. A ranked table appears showing every employee who bid on that item, highest amount first, with their name, Employee ID, department, contact number, and bid reference.
If two or more employees bid the exact same highest amount, the tool flags this clearly as a TIE instead of guessing a winner — you'll need to resolve ties manually (e.g. by contacting both bidders).
7. Generating the Final Bidder List

When the auction is done, click "Generate Final Bidder List" on the dashboard. This computes, for every item in the catalogue, the single highest bid and who placed it — all at once, rather than one item at a time.

Each item shows one of three outcomes:

Awarded A clear highest bidder, shown with their name, Employee ID, department, contact number, and bid reference
TIE Two or more employees bid the exact same highest amount. Every tied bidder is listed; you resolve this manually
No bids received Nobody bid on that item

A summary strip at the top gives quick counts (items total, awarded, tied, no bids). From this page you can also:

  1. Download CSV — exports this exact final list (one row per item, or one row per tied bidder for items with a tie) as a spreadsheet, separate from the raw submissions.csv export on the main dashboard.
  2. Print — opens the browser's print dialog with a clean, print-friendly layout (buttons and navigation are hidden automatically).
Note: This list is computed live from data/submissions.csv every time you open the page. If you delete a bid or a new one comes in, just reopen "Generate Final Bidder List" for an up-to-date result.
8. Downloading Records

Click "Download CSV" on the dashboard to download every raw submission as a spreadsheet, ready to open in Excel or Google Sheets — useful for offline review, sharing with Finance, or archiving after the auction closes. (This is different from the Final Bidder List CSV in Section 7, which is a computed summary rather than the raw submission log.)

9. Managing Items

Click "Manage Items" on the dashboard to open the item catalogue page.

Adding an item

  1. Fill in the Item No (must be unique, e.g. "F-21"), the Item Name, and the Minimum Amount (PKR).
  2. Click "Add item."
  3. The new item is immediately available in the dropdown on the employee bid form.

Editing an item

  1. Click "Edit" next to the item — its details load into the form above, which switches to "Edit item" mode.
  2. Change the Item No, Item Name, and/or Minimum Amount as needed.
  3. Click "Save changes" (or "Cancel" to leave it as is).
Note: If bids have already been placed on an item, the edit screen shows how many. Renaming the Item No or Item Name at that point won't retroactively update those existing bids' records — they'll keep showing the old name in reports. It's safest to only adjust the minimum amount once bidding has started on an item.

Deleting an item

  1. Click "Delete" next to the item, and confirm.

This only removes it from the dropdown for new bids — any past submissions that already reference it are left untouched in the records, so auction history is never altered.

Items live in data/items.csv, protected from direct browser access the same way submissions.csv is.

10. The Employee-Facing User Guide Page

A "User Guide" button in the header of the bid form opens a walkthrough built right into the site (guide.php) — the same visual style as the bid form, covering the whole process step by step, with an FAQ.

There's nothing to configure day-to-day. If you later change how the form itself behaves (e.g. add a new payment method or change the number of required confirmations), update the matching wording in guide.php so the guide stays accurate — see Appendix A.3 for the file location.

11. Short URL (Optional)

If you'd like employees to use a short link (e.g. yourdomain.com/vote) instead of the full path to index.php, this is set up once via a .htaccess file at the root of your site — not inside the auction folder.

  1. Place the provided .htaccess file in your site's root folder (public_html/), one level above the auction/ folder.
  2. It aliases the short path to the real form, and also routes the stylesheet and Employee ID lookup through correctly so nothing breaks under the shorter address.
Note: If your site already has its own .htaccess for something else, don't overwrite it — add the new rules into the existing file instead.
12. Security Best Practices
13. Troubleshooting

An employee says their Employee ID is not recognised
Check the employee directory (Appendix A.1) to confirm their ID is listed correctly. If they're a new hire or their ID is missing, add them.

An employee says they can't submit a second time
That's expected — each Employee ID is limited to one bid. If they need to change something, delete their existing bid (Section 4) so they can resubmit.

The page looks broken or unstyled after an update
This is almost always a caching issue. Try a hard refresh (Ctrl+Shift+R) or an incognito/private browser window. If your host uses a caching layer (e.g. LiteSpeed Cache on Hostinger), purge it after uploading updated files.

An employee's bid did not save
Ask them for their reference number (shown after a successful submission, e.g. AUC-20260902-113641-F9CE). If they never received one, their submission didn't go through — most likely a validation message was shown on screen that they need to correct and resubmit.

Appendix A: Technical Reference

The tasks below require editing a file directly via your host's File Manager (or FTP). If you're not comfortable doing this yourself, ask your IT contact or the person who deployed the system.

A.1 — Updating the employee directory

Open employees.php in a code editor. Each employee is one line, in the form:

'9001' => ['name' => 'Faisal Abid', 'designation' => 'Company Secretary & Deputy CFO', 'department' => 'Finance', 'contact' => '923002036854'],

Add, edit, or remove a line as needed (keep the Employee ID in quotes as the array key, and make sure each line still ends with a comma), then save the file.

A.2 — Changing the admin password

Open config.php and change the value on the line starting with define('ADMIN_PASSWORD', ...) to a new, strong password, then save the file.

A.3 — File reference

index.php — employee-facing bid submission form
guide.php — employee-facing User Guide page
admin.php — admin dashboard: deadline, view/delete, CSV, lookup
admin-items.php — add, edit, delete items in catalogue
admin-final-list.php — generates final highest-bidder list
employees.php — employee directory (edit directly)
items.php — loader/saver for item catalogue
deadline.php — loader/saver for submission deadline
bid-helpers.php — shared logic for reading bid records
lookup.php — Employee ID lookup behind the form
ratelimit.php — throttles Employee ID lookup
config.php — settings: password, company name, data folder
data/submissions.csv — all bid records (protected)
data/items.csv — item catalogue
data/deadline.txt — current submission deadline date
Need Help?

For anything beyond this guide, contact your IT department or the person who set up this system.