/var/www/vhosts/m-auto.co/httpdocs
Edit: /var/www/vhosts/m-auto.co/httpdocs/visit_process.php (2771B)
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 visit_reservations (name, phone, branch_id, visit_date) VALUES (?, ?, ?, ?)");
$stmt->bind_param("ssis", $name, $phone, $branch_id, $visit_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تاريخ الزيارة: {$visit_date}",
'source' => OdooConfig::LEAD_SOURCE_WEBSITE_VISIT,
'branch_name' => $branch_name,
'visit_date' => $visit_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} حجز زيارة إلى فرع {$branch_name} في تاريخ {$visit_date}"
);
}
} catch (Exception $e) {
// Log error but don't fail the booking
error_log('Odoo integration error for visit booking: ' . $e->getMessage());
}
header("Location: visit.php?status=success");
} else {
header("Location: visit.php?status=error");
}
$stmt->close();
$conn->close();
} else {
header("Location: visit.php");
exit();
}
?>