URGENT: Complete job application system is broken in my RateRight Flask marketplace!

CURRENT BROKEN STATE:
- Job details page shows HARDCODED fake data instead of real database data
- "Apply for Job" button redirects to /login instead of actually applying
- No Flask route exists for handling job applications
- 0 applications in database despite users trying to apply
- Worker/contractor dashboards are empty (can't see applications)

SPECIFIC ISSUES FOUND:
1. app/templates/jobs/details.html has fake JavaScript data:
   ```javascript
   const jobData = {
       title: "Kitchen Renovation - Carpentry Work", // FAKE!

Apply button goes nowhere:
html<a href="/login" class="btn btn-construction">Apply for Job</a>

Missing Flask routes for applications

CURRENT DATABASE STATE:

2 Jobs exist (Kitchen Cabinet Installation, Deck Construction)
4 Users exist (contractors/workers)
0 Applications exist (BROKEN!)

WHAT NEEDS TO BE FIXED:

Fix /jobs/int:job_id route to load real Job data from database and pass to template
Create /jobs/int:job_id/apply POST route to handle job applications:

Create Application record in database
Link current_user.id as worker_id
Set status='pending', save cover_letter, proposed_rate
Flash success message


Fix job details template to:

Show real database data (not fake JavaScript)
Have working application form with cover_letter and proposed_rate fields
Submit to /jobs/<job_id>/apply endpoint


Fix dashboard queries:

Worker dashboard: show jobs current user applied for + status
Contractor dashboard: show applications received for their jobs


Add application management:

Contractors can approve/reject applications
Workers can see application status



DATABASE MODELS EXIST:

Job (id, title, description, contractor_id, budget_min, budget_max, location, category)
Application (id, job_id, worker_id, status, proposed_rate, cover_letter, created_at)
User (id, email, role)

AUTHENTICATION: Flask-Login with current_user available
Make this a fully functional job marketplace where workers can actually apply for jobs and see their application status!