PR Tracking Portal - Google Sheet CSV Version

Purpose:
This lightweight PHP portal lets end users search their purchase request either by
Assigned PR Control Number or by Requesting Party (employee name).
It displays only:
- Requesting Party
- PR Date
- Approved Budget
- Status

Files:
- index.php
- config.php
- assets/style.css

Setup:
1. Open your Google Sheet.
2. Go to File > Share > Publish to web.
3. Select the specific sheet/tab containing the PR data.
4. Choose format: Comma-separated values (.csv).
5. Click Publish.
6. Copy the generated CSV link.
7. Open config.php.
8. Replace PASTE_YOUR_PUBLISHED_CSV_LINK_HERE with your CSV link.
9. Upload the whole folder contents to your Hostinger subdomain folder.

Required spreadsheet headers:
- Requesting Party
- Mode of Procurement
- Approved Budget
- PR Date
- Assigned PR Control Number
- Status
- Winning Bidder
- PO Number
- PO Date
- Amount

Search options used by the portal:
- Assigned PR Control Number (exact match, returns one result)
- Requesting Party / Employee Name (partial match, returns all matching PRs for that person)

Search column names are configurable in config.php via $SEARCH_COLUMN and
$NAME_SEARCH_COLUMN.

End-user visible fields:
- Requesting Party
- PR Date
- Approved Budget
- Status

Notes:
- Header names must match exactly, including spaces.
- If the sheet is not published to web, the portal cannot read it.
- Do not include confidential fields in a published sheet if privacy is a concern.
- Employee name search matches on partial/substring text and is case-insensitive,
  so "juan" will match "Juan Dela Cruz".
