Php Rent Free Weeks Better -

$sql = "INSERT INTO rent_free_weeks (lease_id, free_week_number, free_week_start_date, free_week_end_date, reason) VALUES (?, ?, ?, ?, ?)"; $stmt = $pdo->prepare($sql); $stmt->execute([$lease_id, $free_week_number, $start_date->format('Y-m-d'), $end_date->format('Y-m-d'), $reason]);

function generateInvoices($leaseId, $startDate, $endDate, $adjustedMonthlyRent) $invoices = []; $current = new DateTime($startDate); $end = new DateTime($endDate); while ($current <= $end) $invoiceDate = clone $current; $invoiceMonth = $invoiceDate->format('Y-m-01'); php rent free weeks

If you offer 2 rent-free weeks, the tenant still stays for 52 weeks but only pays for 50. How do you represent this? $sql = "INSERT INTO rent_free_weeks (lease_id

// add_free_week.php if ($_SERVER['REQUEST_METHOD'] === 'POST') $lease_id = $_POST['lease_id']; $free_week_number = $_POST['free_week_number']; $reason = $_POST['reason']; // Calculate actual dates based on lease start $lease = getLease($lease_id); $start_date = new DateTime($lease['start_date']); $start_date->modify('+' . ($free_week_number - 1) . ' weeks'); $end_date = clone $start_date; $end_date->modify('+6 days'); reason) VALUES (?