JOBS EXCEL UPLOAD MODULE

Files included:
1. upload_jobs_excel.php
   - Uploads an .xlsx file and inserts rows into the database as jobs/tasks/tickets.
   - Saves date-column updates into task_history.
   - Creates missing companies, projects, and staff automatically.
   - Requires admin or manager role.

2. jobs_upload_template.xlsx
   - Excel template for weekly delivery tracker imports.
   - Upload this same file format through upload_jobs_excel.php.

How to install:
1. Upload both files to the same folder as jobs.php.
2. Open upload_jobs_excel.php in the browser while logged in as admin/manager.
3. Download/fill the template.
4. Upload the filled .xlsx file.

Optional menu link:
Add this under your Jobs dropdown menu:
<li><a class="dropdown-item" href="upload_jobs_excel.php">Upload Jobs Excel</a></li>

Notes:
- Company Name + Project Title are used to link jobs to projects.
- If Company Name, Project Title, or Staff Owner does not exist, it will be created automatically.
- Any header that looks like a date, e.g. 18th May 2026, is imported as a task history update.
- Job Type can be Task or Ticket.
- If Job Type is Ticket, Ticket Number is saved when provided.