/var/www/vhosts/m-auto.co/httpdocs
Edit: /var/www/vhosts/m-auto.co/httpdocs/maintenance_process.php (3408B)
prepare("SELECT name FROM branches WHERE id = ?");
$branch_stmt->bind_param("i", $branch_id);
$branch_stmt->execute();
$branch_result = $branch_stmt->get_result();
$branch_name = '';
if ($branch_row = $branch_result->fetch_assoc()) {
$branch_name = $branch_row['name'];
}
$branch_stmt->close();
// Prepare and bind
$stmt = $conn->prepare("INSERT INTO maintenance_reservations (name, phone, car_info, service_type, branch_id, reservation_date) VALUES (?, ?, ?, ?, ?, ?)");
$stmt->bind_param("ssssis", $name, $phone, $car_info, $service_type, $branch_id, $reservation_date);
if ($stmt->execute()) {
// Send data to Odoo CRM
try {
$odoo = new OdooAPI();
// Prepare lead data for Odoo
$leadData = [
'name' => 'حجز صيانة - ' . $name,
'contact_name' => $name,
'phone' => $phone,
'description' => "حجز صيانة في فرع: {$branch_name}\nنوع الخدمة: {$service_type}\nمعلومات السيارة: {$car_info}\nتاريخ الحجز: {$reservation_date}",
'source' => OdooConfig::LEAD_SOURCE_WEBSITE_MAINTENANCE,
'branch_name' => $branch_name,
'service_type' => $service_type,
'car_info' => $car_info,
'reservation_date' => $reservation_date
];
// Create lead in Odoo
$leadId = $odoo->createLead($leadData);
if ($leadId) {
// Create follow-up activity
$odoo->createActivity(
$leadId,
1, // Default activity type (adjust as needed)
'متابعة حجز الصيانة',
"العميل {$name} حجز صيانة {$service_type} في فرع {$branch_name} لسيارة {$car_info} في تاريخ {$reservation_date}"
);
}
} catch (Exception $e) {
// Log error but don't fail the booking
error_log('Odoo integration error for maintenance booking: ' . $e->getMessage());
}
header("Location: maintenance.php?status=success");
} else {
header("Location: maintenance.php?status=error");
}
$stmt->close();
$conn->close();
} else {
header("Location: maintenance.php");
exit();
}
?>