2226 lines
106 KiB
PHP
2226 lines
106 KiB
PHP
<?php
|
||
date_default_timezone_set('Asia/Shanghai');
|
||
session_start();
|
||
require_once 'db_connect.php';
|
||
|
||
$message = '';
|
||
$success_message = '';
|
||
|
||
// 处理表单提交
|
||
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
|
||
try {
|
||
// 验证并获取客户类型
|
||
$customer_type = isset($_POST['customer_type']) ? $_POST['customer_type'] : '';
|
||
if (!in_array($customer_type, ['vip', 'new'])) {
|
||
throw new Exception('无效的客户类型');
|
||
}
|
||
|
||
$vip_id = isset($_POST['vip_id']) ? (int)$_POST['vip_id'] : 0;
|
||
|
||
// 如果选择VIP客户，从VIP表获取信息
|
||
if ($customer_type === 'vip' && $vip_id > 0) {
|
||
$stmt = $pdo->prepare("SELECT * FROM vip_customers WHERE id = ? AND is_active = 1");
|
||
$stmt->execute([$vip_id]);
|
||
$vip_customer = $stmt->fetch();
|
||
|
||
if (!$vip_customer) {
|
||
throw new Exception('选择的VIP客户无效');
|
||
}
|
||
|
||
// 使用VIP客户信息
|
||
$customer_name = $vip_customer['customer_name'];
|
||
$phone = $vip_customer['phone'];
|
||
// #region agent log
|
||
$log_data = json_encode(['location' => 'index.php:28', 'message' => 'VIP customer data', 'data' => ['vip_id' => $vip_id, 'has_car_model' => isset($vip_customer['car_model']), 'has_car_number' => isset($vip_customer['car_number'])], 'timestamp' => time() * 1000, 'sessionId' => 'debug-session', 'runId' => 'run1', 'hypothesisId' => 'A']);
|
||
file_put_contents('.cursor/debug.log', $log_data . "\n", FILE_APPEND);
|
||
// #endregion
|
||
// VIP客户信息优先，但允许通过POST覆盖（如果用户想修改）
|
||
$car_model = isset($_POST['car_model']) && trim($_POST['car_model']) ? trim($_POST['car_model']) : (isset($vip_customer['car_model']) && $vip_customer['car_model'] ? $vip_customer['car_model'] : '');
|
||
$car_number = isset($_POST['car_number']) && trim($_POST['car_number']) ? trim($_POST['car_number']) : (isset($vip_customer['car_number']) && $vip_customer['car_number'] ? $vip_customer['car_number'] : '');
|
||
$member_type = 'VIP会员';
|
||
} else {
|
||
// 新客户录入
|
||
$customer_name = trim($_POST['customer_name'] ?? '');
|
||
$phone = trim($_POST['phone'] ?? '');
|
||
$car_model = trim($_POST['car_model'] ?? '');
|
||
$car_number = trim($_POST['car_number'] ?? '');
|
||
}
|
||
$package_id = (int)($_POST['package_id'] ?? 0);
|
||
$custom_services = trim($_POST['custom_services'] ?? '');
|
||
$appointment_date = $_POST['appointment_date'] ?? '';
|
||
$appointment_time = $_POST['appointment_time'] ?? '';
|
||
$duration = (int)($_POST['duration'] ?? 60);
|
||
$notes = trim($_POST['notes'] ?? '');
|
||
|
||
// 验证member_type和source
|
||
$allowed_member_types = ['普通客户', 'VIP会员'];
|
||
$member_type = isset($_POST['member_type']) && in_array($_POST['member_type'], $allowed_member_types) ? $_POST['member_type'] : '普通客户';
|
||
|
||
$allowed_sources = ['抖音', '微信', '快手', '朋友介绍', '其他'];
|
||
$source = isset($_POST['source']) && in_array($_POST['source'], $allowed_sources) ? $_POST['source'] : '其他';
|
||
|
||
// 验证必填字段
|
||
if (empty($customer_name) || empty($phone) || empty($car_model) ||
|
||
empty($car_number) || empty($appointment_date) || empty($appointment_time)) {
|
||
throw new Exception('请填写所有必填字段');
|
||
}
|
||
|
||
// 验证VIP客户或新客户的必填字段
|
||
if ($customer_type === 'vip') {
|
||
if (empty($vip_id)) {
|
||
throw new Exception('请选择一个VIP客户');
|
||
}
|
||
} else {
|
||
if (empty($customer_name) || empty($phone)) {
|
||
throw new Exception('请填写客户姓名和联系电话');
|
||
}
|
||
}
|
||
|
||
// 验证套餐
|
||
if ($package_id) {
|
||
$stmt = $pdo->prepare("SELECT * FROM packages WHERE id = ? AND is_active = 1");
|
||
$stmt->execute([$package_id]);
|
||
$package = $stmt->fetch();
|
||
|
||
if (!$package) {
|
||
throw new Exception('选择的套餐无效');
|
||
}
|
||
|
||
$total_price = $package['price'];
|
||
} else {
|
||
throw new Exception('请选择一个套餐');
|
||
}
|
||
|
||
// 验证日期和时间格式
|
||
if (!preg_match('/^\d{4}-\d{2}-\d{2}$/', $appointment_date)) {
|
||
throw new Exception('预约日期格式不正确');
|
||
}
|
||
if (!preg_match('/^\d{2}:\d{2}$/', $appointment_time)) {
|
||
throw new Exception('预约时间格式不正确');
|
||
}
|
||
|
||
// 计算预约时间范围
|
||
$start_time = $appointment_date . ' ' . $appointment_time . ':00';
|
||
$start_timestamp = strtotime($start_time);
|
||
if ($start_timestamp === false) {
|
||
throw new Exception('预约时间无效，请检查日期和时间');
|
||
}
|
||
$end_time = date('Y-m-d H:i:s', $start_timestamp + $duration * 60);
|
||
|
||
// 验证结束时间是否有效
|
||
if ($end_time === false) {
|
||
throw new Exception('计算结束时间失败');
|
||
}
|
||
|
||
// 检查时间冲突
|
||
// 两个时间段重叠的条件：现有预约的开始时间 < 新预约的结束时间 AND 现有预约的结束时间 > 新预约的开始时间
|
||
// #region agent log
|
||
$log_data = json_encode(['location' => 'index.php:98', 'message' => 'Checking time conflict', 'data' => ['start_time' => $start_time, 'end_time' => $end_time, 'duration' => $duration], 'timestamp' => time() * 1000, 'sessionId' => 'debug-session', 'runId' => 'run1', 'hypothesisId' => 'F']);
|
||
file_put_contents('.cursor/debug.log', $log_data . "\n", FILE_APPEND);
|
||
// #endregion
|
||
$stmt = $pdo->prepare("SELECT COUNT(*) FROM bookings
|
||
WHERE status != '已取消'
|
||
AND start_time < ?
|
||
AND end_time > ?");
|
||
$stmt->execute([$end_time, $start_time]);
|
||
$conflict_count = $stmt->fetchColumn();
|
||
// #region agent log
|
||
$log_data = json_encode(['location' => 'index.php:107', 'message' => 'Time conflict check result', 'data' => ['conflict_count' => $conflict_count], 'timestamp' => time() * 1000, 'sessionId' => 'debug-session', 'runId' => 'run1', 'hypothesisId' => 'F']);
|
||
file_put_contents('.cursor/debug.log', $log_data . "\n", FILE_APPEND);
|
||
// #endregion
|
||
|
||
if ($conflict_count > 0) {
|
||
throw new Exception('该时间段已被预约，请选择其他时间');
|
||
}
|
||
|
||
// 检查客户是否有历史预约记录，如果有则自动转为普通客户
|
||
// #region agent log
|
||
$log_data = json_encode(['location' => 'index.php:136', 'message' => 'Checking customer booking history', 'data' => ['phone' => $phone, 'car_number' => $car_number, 'current_member_type' => $member_type], 'timestamp' => time() * 1000, 'sessionId' => 'debug-session', 'runId' => 'run1', 'hypothesisId' => 'I']);
|
||
file_put_contents('.cursor/debug.log', $log_data . "\n", FILE_APPEND);
|
||
// #endregion
|
||
// 检查该手机号和车牌号组合是否有历史预约记录
|
||
$stmt = $pdo->prepare("SELECT COUNT(*) FROM bookings
|
||
WHERE phone = ? AND car_number = ?");
|
||
$stmt->execute([$phone, $car_number]);
|
||
$has_booking_history = $stmt->fetchColumn() > 0;
|
||
|
||
// 如果客户有历史预约记录，自动转为普通客户（除非是VIP客户模式）
|
||
if ($has_booking_history && $member_type === 'VIP会员' && $customer_type !== 'vip') {
|
||
$member_type = '普通客户';
|
||
// #region agent log
|
||
$log_data = json_encode(['location' => 'index.php:144', 'message' => 'Auto converted to regular customer', 'data' => ['reason' => 'has_booking_history', 'phone' => $phone, 'car_number' => $car_number], 'timestamp' => time() * 1000, 'sessionId' => 'debug-session', 'runId' => 'run1', 'hypothesisId' => 'I']);
|
||
file_put_contents('.cursor/debug.log', $log_data . "\n", FILE_APPEND);
|
||
// #endregion
|
||
}
|
||
|
||
// 插入预约记录
|
||
// 对于0元订单，自动标记为已付款
|
||
$payment_status = ($total_price <= 0) ? '已付款' : '未付款';
|
||
|
||
$stmt = $pdo->prepare("INSERT INTO bookings
|
||
(customer_name, phone, car_model, car_number, package_id, custom_services,
|
||
start_time, end_time, duration, total_price, notes, member_type, source, payment_status)
|
||
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)");
|
||
|
||
$stmt->execute([$customer_name, $phone, $car_model, $car_number, $package_id, $custom_services,
|
||
$start_time, $end_time, $duration, $total_price, $notes, $member_type, $source, $payment_status]);
|
||
|
||
$success_message = "预约提交成功！";
|
||
|
||
} catch (Exception $e) {
|
||
$message = $e->getMessage();
|
||
}
|
||
}
|
||
|
||
// 获取套餐列表
|
||
$stmt = $pdo->query("SELECT * FROM packages WHERE is_active = 1 ORDER BY price");
|
||
$packages = $stmt->fetchAll();
|
||
|
||
// 获取一周内的预约数据用于日历显示
|
||
$start_date = date('Y-m-d');
|
||
$end_date = date('Y-m-d', strtotime('+7 days'));
|
||
$stmt = $pdo->prepare("SELECT DATE(start_time) as date,
|
||
COUNT(*) as booking_count,
|
||
GROUP_CONCAT(
|
||
CONCAT(
|
||
TIME_FORMAT(start_time, '%H:%i'), '-',
|
||
TIME_FORMAT(end_time, '%H:%i'),
|
||
'(', status, ')'
|
||
) ORDER BY start_time SEPARATOR '<br>'
|
||
) as bookings
|
||
FROM bookings
|
||
WHERE DATE(start_time) BETWEEN ? AND ?
|
||
AND status NOT IN ('已完成', '已取消')
|
||
GROUP BY DATE(start_time)
|
||
ORDER BY date");
|
||
$stmt->execute([$start_date, $end_date]);
|
||
$results = $stmt->fetchAll(PDO::FETCH_ASSOC);
|
||
|
||
// 将结果转换为键值对格式（日期 => 预约数量）
|
||
$booking_schedule = [];
|
||
$booking_details = []; // 存储详细的预约信息
|
||
foreach ($results as $row) {
|
||
$booking_schedule[$row['date']] = $row['booking_count'];
|
||
$booking_details[$row['date']] = $row['bookings'];
|
||
}
|
||
|
||
// 获取具体的时间段预约信息供JavaScript使用
|
||
$stmt2 = $pdo->prepare("SELECT DATE(start_time) as date,
|
||
TIME_FORMAT(start_time, '%H:%i') as start_time,
|
||
TIME_FORMAT(end_time, '%H:%i') as end_time,
|
||
status,
|
||
customer_name,
|
||
car_model,
|
||
car_number
|
||
FROM bookings
|
||
WHERE DATE(start_time) BETWEEN ? AND ?
|
||
AND status NOT IN ('已完成', '已取消')
|
||
ORDER BY date, start_time");
|
||
$stmt2->execute([$start_date, $end_date]);
|
||
$all_bookings = $stmt2->fetchAll(PDO::FETCH_ASSOC);
|
||
|
||
// 按日期组织预约数据，处理跨天预约情况
|
||
$bookings_by_date = [];
|
||
foreach ($all_bookings as $booking) {
|
||
$booking_date = $booking['date']; // 使用不同的变量名避免覆盖外层$start_date
|
||
$booking_start_time = $booking['start_time'];
|
||
$booking_end_time = $booking['end_time'];
|
||
|
||
// 将预约添加到开始日期
|
||
$bookings_by_date[$booking_date][] = $booking;
|
||
|
||
// 检查是否是跨天预约（结束时间早于开始时间，表示跨天）
|
||
// 注意：这里比较的是时间字符串（HH:MM格式），需要转换为可比较的格式
|
||
$start_timestamp = strtotime($booking_start_time);
|
||
$end_timestamp = strtotime($booking_end_time);
|
||
|
||
// #region agent log
|
||
$log_data = json_encode(['location' => 'index.php:196', 'message' => 'Checking cross-day booking', 'data' => ['booking_date' => $booking_date, 'start_time' => $booking_start_time, 'end_time' => $booking_end_time, 'start_ts' => $start_timestamp, 'end_ts' => $end_timestamp], 'timestamp' => time() * 1000, 'sessionId' => 'debug-session', 'runId' => 'run1', 'hypothesisId' => 'G']);
|
||
file_put_contents('.cursor/debug.log', $log_data . "\n", FILE_APPEND);
|
||
// #endregion
|
||
|
||
if ($start_timestamp !== false && $end_timestamp !== false && $end_timestamp < $start_timestamp) {
|
||
// 计算第二天的日期
|
||
$next_date = date('Y-m-d', strtotime($booking_date . ' +1 day'));
|
||
|
||
// 创建第二天的预约记录副本
|
||
$next_day_booking = $booking;
|
||
$next_day_booking['is_cross_day'] = true; // 标记为跨天预约
|
||
|
||
// 将预约添加到第二天
|
||
$bookings_by_date[$next_date][] = $next_day_booking;
|
||
}
|
||
}
|
||
|
||
// 获取套餐信息用于JavaScript
|
||
$packages_json = json_encode(array_map(function($package) {
|
||
$package['services'] = array_filter(array_map('trim', explode(',', $package['services'])));
|
||
return $package;
|
||
}, $packages));
|
||
?>
|
||
<!DOCTYPE html>
|
||
<html lang="zh-CN">
|
||
<head>
|
||
<meta charset="UTF-8">
|
||
<meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=no">
|
||
<meta name="apple-mobile-web-app-capable" content="yes">
|
||
<meta name="apple-mobile-web-app-status-bar-style" content="black-translucent">
|
||
<meta name="format-detection" content="telephone=no">
|
||
<meta name="description" content="洗车预约系统 - 在线预约洗车服务">
|
||
<meta name="keywords" content="洗车,预约,在线预约,汽车美容">
|
||
<link rel="apple-touch-icon" href="data:image/svg+xml;base64,PHN2ZyB3aWR0aD0iMTkyIiBoZWlnaHQ9IjE5MiIgdmlld0JveD0iMCAwIDE5MiAxOTIiIGZpbGw9Im5vbmUiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyI+CjxyZWN0IHdpZHRoPSIxOTIiIGhlaWdodD0iMTkyIiByeD0iMjQiIGZpbGw9IiMzMDk1RjQiLz4KPHN2ZyB4PSI0OCIgeT0iNDgiIHdpZHRoPSI5NiIgaGVpZ2h0PSI5NiIgdmlld0JveD0iMCAwIDI0IDI0IiBmaWxsPSJ3aGl0ZSI+CjxwYXRoIGQ9Ik0yMS4yIDQuNEMyMS42IDMuNiAyMi4xIDMuMSAyMi41IDIuN0MyMy40IDIuMSAyNC41IDIuMSAyNS4yIDIuN0MyNS44IDMuMSAyNi4zIDMuNiAyNi43IDQuNEMyNy4xIDUuMSAyNy4xIDYuMiAyNi43IDcuMUMyNi4zIDcuOCAyNS44IDguMyAyNS4yIDguN0MyNC43IDkuMSAyMy42IDkuMSAyMi45IDguN0MyMi4zIDguMyAyMS44IDcuOCAyMS40IDcuMUMyMS4wIDYuMiAyMS4wIDUuMSAyMS4yIDQuNFoiLz4KPHN2ZyB4PSIyMCIgeT0iMTIiIHdpZHRoPSIyMCIgaGVpZ2h0PSIyMCIgdmlld0JveD0iMCAwIDI0IDI0IiBmaWxsPSJ3aGl0ZSI+CjxwYXRoIGQ9Ik0yMSAyMy41QzIwLjUgMjMuNSAyMCAyMyAyMCAyMi41VjEyQzIwIDExLjUgMjAuNSAxMSAyMSAxMUg5QzguNSAxMSAxMi41IDEwLjUgMTIgMTBIMjBWMTBCMjAgMTAuNSAyMC41IDExIDIxIDExVjIzLjVaIi8+CjxwYXRoIGQ9Ik0xOCAyMFYxN0gxNFY4SDVWMTNIMTlWMTVIMTlWMjBaIi8+CjxwYXRoIGQ9Ik04IDEwSDVWN0g4VjEwWiIvPgo8L3N2Zz4KPC9zdmc+">
|
||
<title>张老师撸车（私家车库）工作室</title>
|
||
<link rel="stylesheet" href="style.css">
|
||
<script src="mobile-nav.js" defer></script>
|
||
|
||
<style>
|
||
/* VIP搜索结果样式 */
|
||
.vip-search-results {
|
||
position: absolute;
|
||
top: 100%;
|
||
left: 0;
|
||
right: 0;
|
||
background: white;
|
||
border: 1px solid #ddd;
|
||
border-radius: 8px;
|
||
box-shadow: 0 4px 12px rgba(0,0,0,0.15);
|
||
z-index: 1000;
|
||
max-height: 200px;
|
||
overflow-y: auto;
|
||
}
|
||
|
||
.vip-search-item {
|
||
padding: 12px 16px;
|
||
cursor: pointer;
|
||
border-bottom: 1px solid #f0f0f0;
|
||
transition: background-color 0.2s ease;
|
||
}
|
||
|
||
.vip-search-item:hover {
|
||
background-color: #f8f9fa;
|
||
}
|
||
|
||
.vip-search-item:last-child {
|
||
border-bottom: none;
|
||
}
|
||
|
||
.vip-search-item .customer-name {
|
||
font-weight: bold;
|
||
color: #333;
|
||
margin-bottom: 4px;
|
||
}
|
||
|
||
.vip-search-item .customer-phone {
|
||
color: #666;
|
||
font-size: 0.9em;
|
||
}
|
||
|
||
.vip-search-item .customer-car {
|
||
color: #888;
|
||
font-size: 0.85em;
|
||
margin-top: 4px;
|
||
}
|
||
|
||
.vip-search-item.selected {
|
||
background-color: #e3f2fd;
|
||
}
|
||
|
||
#vip_search {
|
||
position: relative;
|
||
}
|
||
|
||
.form-group {
|
||
position: relative;
|
||
}
|
||
|
||
.form-group #vip_search {
|
||
margin-bottom: 10px;
|
||
}
|
||
|
||
.search-tips {
|
||
font-size: 0.85em;
|
||
color: #666;
|
||
margin-top: 5px;
|
||
}
|
||
|
||
.no-results {
|
||
text-align: center;
|
||
color: #999;
|
||
padding: 20px;
|
||
font-style: italic;
|
||
}
|
||
|
||
.vip-search-results mark {
|
||
background-color: #ffeb3b;
|
||
color: #333;
|
||
padding: 1px 2px;
|
||
border-radius: 2px;
|
||
font-weight: bold;
|
||
}
|
||
|
||
.phone-vip-tip {
|
||
font-size: 0.85em;
|
||
margin-top: 5px;
|
||
padding: 8px 12px;
|
||
border-radius: 6px;
|
||
border: 1px solid #ddd;
|
||
}
|
||
|
||
.phone-vip-tip.vip-detected {
|
||
background-color: #e8f5e8;
|
||
border-color: #4caf50;
|
||
color: #2e7d32;
|
||
}
|
||
|
||
.phone-vip-tip.suggestion {
|
||
background-color: #fff3e0;
|
||
border-color: #ff9800;
|
||
color: #ef6c00;
|
||
}
|
||
</style>
|
||
</head>
|
||
<body>
|
||
<div class="container">
|
||
<header class="header">
|
||
<button class="mobile-menu-toggle" onclick="toggleMobileMenu()" aria-label="菜单">
|
||
<span></span>
|
||
<span></span>
|
||
<span></span>
|
||
</button>
|
||
<h1>🚗 张老师撸车工作室</h1>
|
||
<nav class="nav">
|
||
<a href="index.php" class="nav-link active">预约洗车</a>
|
||
<a href="bookings.php" class="nav-link">预约管理</a>
|
||
<a href="pending_bookings.php" class="nav-link">待处理预约</a>
|
||
<a href="packages.php" class="nav-link">套餐管理</a>
|
||
<a href="vip.php" class="nav-link">VIP管理</a>
|
||
<a href="announcement.php" class="nav-link">今日待办</a>
|
||
</nav>
|
||
</header>
|
||
|
||
<!-- 移动端导航菜单 -->
|
||
<div class="mobile-nav-overlay" onclick="closeMobileMenu()"></div>
|
||
<nav class="mobile-nav">
|
||
<a href="index.php" class="nav-link active">预约洗车</a>
|
||
<a href="bookings.php" class="nav-link">预约管理</a>
|
||
<a href="pending_bookings.php" class="nav-link">待处理预约</a>
|
||
<a href="packages.php" class="nav-link">套餐管理</a>
|
||
<a href="vip.php" class="nav-link">VIP管理</a>
|
||
<a href="announcement.php" class="nav-link">今日待办</a>
|
||
</nav>
|
||
|
||
<?php if ($message): ?>
|
||
<div class="message error-message" style="background-color: #fee; color: #c33; border-color: #fcc;">
|
||
<?= htmlspecialchars($message) ?>
|
||
</div>
|
||
<?php endif; ?>
|
||
|
||
<?php if ($success_message): ?>
|
||
<div class="message success-message">
|
||
<?= htmlspecialchars($success_message) ?>
|
||
</div>
|
||
<?php endif; ?>
|
||
|
||
<div class="booking-container">
|
||
<div class="calendar-section">
|
||
<h2>📅 选择预约日期</h2>
|
||
|
||
<!-- 分页控制 -->
|
||
<div class="pagination-controls">
|
||
<button type="button" id="prevPage" class="btn btn-sm btn-secondary" onclick="changePage(-1)">上一页</button>
|
||
<span id="pageInfo" class="page-info">第 1 页 / 共 4 页</span>
|
||
<button type="button" id="nextPage" class="btn btn-sm btn-secondary" onclick="changePage(1)">下一页</button>
|
||
</div>
|
||
|
||
<style>
|
||
/* 分页控制样式 */
|
||
.pagination-controls {
|
||
display: flex;
|
||
justify-content: center;
|
||
align-items: center;
|
||
margin-bottom: 20px;
|
||
gap: 15px;
|
||
}
|
||
|
||
.page-info {
|
||
font-size: 14px;
|
||
font-weight: bold;
|
||
color: #333;
|
||
}
|
||
|
||
.btn:disabled {
|
||
opacity: 0.5;
|
||
cursor: not-allowed;
|
||
}
|
||
|
||
/* 日历布局样式 */
|
||
.calendar {
|
||
display: grid;
|
||
grid-template-columns: repeat(7, 1fr);
|
||
gap: 10px;
|
||
margin-bottom: 20px;
|
||
}
|
||
|
||
/* 确保响应式布局 */
|
||
@media (max-width: 768px) {
|
||
.calendar {
|
||
grid-template-columns: repeat(4, 1fr);
|
||
}
|
||
}
|
||
|
||
@media (max-width: 480px) {
|
||
.calendar {
|
||
grid-template-columns: repeat(2, 1fr);
|
||
}
|
||
}
|
||
|
||
/* 超出范围日期样式 */
|
||
.calendar-day.disabled {
|
||
background-color: #f5f5f5;
|
||
color: #999;
|
||
cursor: not-allowed;
|
||
}
|
||
|
||
.calendar-day.disabled:hover {
|
||
transform: none;
|
||
box-shadow: none;
|
||
}
|
||
</style>
|
||
|
||
<div class="calendar enhanced-card" id="calendarContainer">
|
||
<!-- 日期将通过JavaScript动态生成 -->
|
||
</div>
|
||
|
||
<script>
|
||
// 初始化当前页码（从0开始）
|
||
let currentPage = 0;
|
||
const totalPages = 4; // 总共4页（28天）
|
||
const daysPerPage = 7; // 每页7天
|
||
|
||
// 获取本周一的日期
|
||
function getCurrentMonday() {
|
||
const today = new Date();
|
||
const dayOfWeek = today.getDay(); // 0是周日，1-6是周一到周六
|
||
const diff = today.getDate() - dayOfWeek + (dayOfWeek === 0 ? -6 : 1); // 调整为周一
|
||
const monday = new Date(today);
|
||
monday.setDate(diff);
|
||
return monday;
|
||
}
|
||
|
||
// 生成日历数据 - 按周一到周日顺序排列
|
||
const generateCalendarDays = () => {
|
||
const calendarContainer = document.getElementById('calendarContainer');
|
||
calendarContainer.innerHTML = '';
|
||
|
||
// 获取基准周一日期
|
||
const baseMonday = getCurrentMonday();
|
||
// 根据页码计算当前页的起始周
|
||
const weekOffset = currentPage;
|
||
// 计算当前页第一周的周一
|
||
const pageStartMonday = new Date(baseMonday);
|
||
pageStartMonday.setDate(baseMonday.getDate() + weekOffset * 7);
|
||
|
||
// 按周一到周日的顺序生成日期
|
||
for (let dayOffset = 0; dayOffset < 7; dayOffset++) {
|
||
const date = new Date(pageStartMonday);
|
||
date.setDate(pageStartMonday.getDate() + dayOffset);
|
||
// 确保使用本地时区获取日期字符串
|
||
const year = date.getFullYear();
|
||
const month = String(date.getMonth() + 1).padStart(2, '0');
|
||
const day = String(date.getDate()).padStart(2, '0');
|
||
const dateStr = `${year}-${month}-${day}`;
|
||
const dateDisplay = `${date.getMonth() + 1}/${date.getDate()}`;
|
||
const weekday = ['日', '一', '二', '三', '四', '五', '六'][date.getDay()];
|
||
|
||
// 获取今天的日期字符串用于比较
|
||
const today = new Date();
|
||
const todayYear = today.getFullYear();
|
||
const todayMonth = String(today.getMonth() + 1).padStart(2, '0');
|
||
const todayDay = String(today.getDate()).padStart(2, '0');
|
||
const todayStr = `${todayYear}-${todayMonth}-${todayDay}`;
|
||
const isToday = dateStr === todayStr;
|
||
|
||
// 获取预约数量
|
||
const bookingCount = bookingsByDate[dateStr] ? bookingsByDate[dateStr].length : 0;
|
||
const isFull = bookingCount >= 8; // 假设每天最多8个时段
|
||
|
||
// 检查日期是否在未来28天内
|
||
const currentDate = new Date();
|
||
const maxDate = new Date(currentDate);
|
||
maxDate.setDate(currentDate.getDate() + 27); // 28天包括今天
|
||
const isWithinRange = date >= currentDate && date <= maxDate;
|
||
|
||
const statusClass = isFull ? 'full' : (bookingCount > 0 ? 'busy' : (isWithinRange ? 'available' : 'disabled'));
|
||
const statusText = isFull ? '已满' : (bookingCount > 0 ? '繁忙' : (isWithinRange ? '可预约' : '超出范围'));
|
||
|
||
const dayDiv = document.createElement('div');
|
||
dayDiv.className = `calendar-day ${statusClass} ${isToday ? 'today' : ''}`;
|
||
dayDiv.dataset.date = dateStr;
|
||
dayDiv.dataset.bookingCount = bookingCount;
|
||
|
||
// 只有在范围内的日期才可点击
|
||
if (isWithinRange) {
|
||
dayDiv.onclick = () => showDateDetails(dateStr);
|
||
}
|
||
|
||
dayDiv.innerHTML = `
|
||
<div class="day-number">${dateDisplay}</div>
|
||
<div class="day-week">周${weekday}</div>
|
||
<div class="day-status">${statusText}</div>
|
||
<div class="booking-count">${bookingCount}个预约</div>
|
||
`;
|
||
|
||
calendarContainer.appendChild(dayDiv);
|
||
}
|
||
|
||
// 更新分页信息
|
||
updatePaginationInfo();
|
||
};
|
||
|
||
// 更新分页信息
|
||
const updatePaginationInfo = () => {
|
||
const pageInfo = document.getElementById('pageInfo');
|
||
pageInfo.textContent = `第 ${currentPage + 1} 页 / 共 ${totalPages} 页`;
|
||
|
||
// 启用/禁用翻页按钮
|
||
document.getElementById('prevPage').disabled = currentPage === 0;
|
||
document.getElementById('nextPage').disabled = currentPage === totalPages - 1;
|
||
};
|
||
|
||
// 切换页面
|
||
const changePage = (direction) => {
|
||
const newPage = currentPage + direction;
|
||
if (newPage >= 0 && newPage < totalPages) {
|
||
currentPage = newPage;
|
||
generateCalendarDays();
|
||
}
|
||
};
|
||
|
||
// 页面加载时生成第一页
|
||
document.addEventListener('DOMContentLoaded', function() {
|
||
generateCalendarDays();
|
||
});
|
||
</script>
|
||
|
||
<style>
|
||
/* 统一时间选择样式为pending_bookings.php的样式 */
|
||
.calendar-day {
|
||
padding: 15px;
|
||
background: #f5f5f5;
|
||
border-radius: 4px;
|
||
text-align: center;
|
||
cursor: pointer;
|
||
transition: all 0.3s ease;
|
||
}
|
||
|
||
.calendar-day:hover {
|
||
background: #e9ecef;
|
||
}
|
||
|
||
.calendar-day.selected {
|
||
background: #007bff;
|
||
color: white;
|
||
}
|
||
|
||
.time-slots-container {
|
||
margin-bottom: 20px;
|
||
}
|
||
|
||
.time-grid {
|
||
display: grid;
|
||
grid-template-columns: repeat(auto-fit, minmax(100px, 1fr));
|
||
gap: 10px;
|
||
}
|
||
|
||
.time-slot {
|
||
padding: 10px;
|
||
border-radius: 4px;
|
||
text-align: center;
|
||
cursor: pointer;
|
||
transition: all 0.3s ease;
|
||
}
|
||
|
||
.time-slot.available {
|
||
background: #d4edda;
|
||
color: #155724;
|
||
}
|
||
|
||
.time-slot.booked {
|
||
background: #f8d7da;
|
||
color: #721c24;
|
||
cursor: not-allowed;
|
||
}
|
||
|
||
.time-slot.past {
|
||
background: #e9ecef;
|
||
color: #6c757d;
|
||
cursor: not-allowed;
|
||
}
|
||
|
||
.time-slot.selected {
|
||
background: #007bff;
|
||
color: white;
|
||
}
|
||
|
||
.time-slot:hover.available {
|
||
background: #c3e6cb;
|
||
}
|
||
</style>
|
||
|
||
<div class="time-slots enhanced-card" id="timeSlots" style="display: none;">
|
||
<h3>🕐 选择时间段</h3>
|
||
<div class="quick-duration">
|
||
<span>快捷时长：</span>
|
||
<button type="button" class="duration-btn" onclick="selectDuration(60)">1小时</button>
|
||
<button type="button" class="duration-btn" onclick="selectDuration(90)">1.5小时</button>
|
||
<button type="button" class="duration-btn" onclick="selectDuration(120)">2小时</button>
|
||
<button type="button" class="duration-btn" onclick="selectDuration(240)">4小时</button>
|
||
<button type="button" class="duration-btn" onclick="selectDuration(360)">6小时</button>
|
||
<button type="button" class="duration-btn" onclick="selectDuration(480)">8小时</button>
|
||
<button type="button" class="duration-btn" onclick="selectDuration(600)">10小时</button>
|
||
<button type="button" class="duration-btn" onclick="selectDuration(720)">12小时</button>
|
||
<!-- <input type="number" id="customDuration" min="30" step="30" value="60" style="width: 80px; margin-left: 10px;"> -->
|
||
<!-- <button type="button" class="btn btn-sm" onclick="applyCustomDuration()">确定</button> -->
|
||
</div>
|
||
<div class="time-grid" id="timeGrid">
|
||
<!-- 时间段将通过JavaScript动态生成 -->
|
||
</div>
|
||
</div>
|
||
|
||
<!-- 预约详情显示区域 -->
|
||
<div id="bookingDetails" class="booking-details enhanced-card" style="display: none;">
|
||
<h3 id="detailsDateTitle"></h3>
|
||
<div id="bookingDetailsContent"></div>
|
||
</div>
|
||
</div>
|
||
|
||
<div class="booking-form-section enhanced-card">
|
||
<h2>📋 预约信息</h2>
|
||
<form method="POST" class="form" id="bookingForm">
|
||
<div class="form-row">
|
||
<div class="form-group">
|
||
<label for="customer_type">客户类型 *</label>
|
||
<select id="customer_type" name="customer_type" required onchange="handleCustomerTypeChange()">
|
||
<option value="new">新客户</option>
|
||
<option value="vip">VIP客户</option>
|
||
</select>
|
||
</div>
|
||
|
||
<div class="form-group" id="vip_select_group" style="display: none;">
|
||
<label for="vip_search">搜索VIP客户</label>
|
||
<input type="text" id="vip_search" placeholder="输入姓名或手机号搜索"
|
||
oninput="searchVIPCustomers()" autocomplete="off"
|
||
onfocus="clearSearchResults()">
|
||
<div class="search-tips">💡 支持模糊搜索，输入姓名或手机号即可快速定位</div>
|
||
|
||
<label for="vip_id" style="margin-top: 10px;">选择VIP客户</label>
|
||
<select id="vip_id" name="vip_id" onchange="loadVIPInfo()">
|
||
<option value="">请选择VIP客户</option>
|
||
</select>
|
||
<div id="vip_search_results" class="vip-search-results" style="display: none;"></div>
|
||
</div>
|
||
</div>
|
||
|
||
<!-- VIP客户上次预约信息显示区域 -->
|
||
<div id="vip_last_booking_info" class="vip-last-booking-info" style="display: none;">
|
||
<h4>📋 最近预约信息</h4>
|
||
<div id="last_booking_content" style="padding: 10px; background-color: #f8f9fa; border-radius: 5px;">
|
||
<!-- 这里将显示上次预约信息 -->
|
||
</div>
|
||
</div>
|
||
|
||
<div class="form-row" id="new_customer_fields">
|
||
<div class="form-group">
|
||
<label for="customer_name">客户姓名 *</label>
|
||
<input type="text" id="customer_name" name="customer_name" placeholder="请输入客户姓名">
|
||
</div>
|
||
|
||
<div class="form-group">
|
||
<label for="phone">联系电话 *</label>
|
||
<input type="tel" id="phone" name="phone" placeholder="请输入联系电话"
|
||
oninput="checkPhoneForVIP()">
|
||
<div id="phone_vip_tip" class="phone-vip-tip" style="display: none;"></div>
|
||
</div>
|
||
</div>
|
||
|
||
<div class="form-row">
|
||
<div class="form-group">
|
||
<label for="car_model">车型 *</label>
|
||
<input type="text" id="car_model" name="car_model" placeholder="如：大众朗逸" required>
|
||
</div>
|
||
|
||
<div class="form-group">
|
||
<label for="car_number">车牌号 *</label>
|
||
<input type="text" id="car_number" name="car_number" placeholder="如：京A12345" required>
|
||
</div>
|
||
</div>
|
||
|
||
<div class="form-group">
|
||
<label for="package_id">选择套餐 *</label>
|
||
<select id="package_id" name="package_id" required onchange="updatePackageInfo()">
|
||
<option value="">请选择套餐</option>
|
||
<?php foreach ($packages as $package): ?>
|
||
<option value="<?= $package['id'] ?>"
|
||
data-duration="<?= $package['base_duration'] ?>"
|
||
data-price="<?= $package['price'] ?>"
|
||
data-services='<?= htmlspecialchars($package['services']) ?>'>
|
||
<?= htmlspecialchars($package['package_name']) ?> - ￥<?= number_format($package['price'], 2) ?>
|
||
</option>
|
||
<?php endforeach; ?>
|
||
</select>
|
||
</div>
|
||
|
||
<div class="package-info" id="packageInfo" style="display: none;">
|
||
<div class="package-details">
|
||
<h4 id="packageName"></h4>
|
||
<p id="packageDescription"></p>
|
||
<div class="package-meta">
|
||
<span id="packageDuration"></span>
|
||
<span id="packagePrice"></span>
|
||
</div>
|
||
<!-- 可编辑的价格输入字段 -->
|
||
<div class="form-group" style="margin-top: 15px;">
|
||
<label for="total_price">最终价格 (￥)</label>
|
||
<input type="number" id="total_price" name="total_price" min="0" step="0.01" value="0" placeholder="输入最终价格" required>
|
||
<input type="hidden" id="package_price" value="0">
|
||
</div>
|
||
<div id="packageServices"></div>
|
||
</div>
|
||
</div>
|
||
|
||
<div class="form-group">
|
||
<label for="custom_services">自定义服务需求</label>
|
||
<textarea id="custom_services" name="custom_services" rows="3"
|
||
placeholder="如有特殊需求，请在此说明..."></textarea>
|
||
</div>
|
||
|
||
<div class="form-row">
|
||
<div class="form-group">
|
||
<label for="appointment_date">预约日期 *</label>
|
||
<input type="date" id="appointment_date" name="appointment_date" required readonly>
|
||
</div>
|
||
|
||
<div class="form-group">
|
||
<label for="appointment_time">预约时间 *</label>
|
||
<input type="time" id="appointment_time" name="appointment_time" required readonly>
|
||
</div>
|
||
</div>
|
||
|
||
<div class="form-group">
|
||
<label for="duration">服务时长（分钟） *</label>
|
||
<input type="number" id="duration" name="duration" min="30" step="30" value="60" required>
|
||
</div>
|
||
|
||
<div class="form-row">
|
||
<div class="form-group">
|
||
<label for="member_type">会员类型 *</label>
|
||
<select id="member_type" name="member_type" required>
|
||
<option value="普通客户">普通客户</option>
|
||
<option value="VIP会员">VIP会员</option>
|
||
</select>
|
||
</div>
|
||
|
||
<div class="form-group">
|
||
<label for="source">客户来源 *</label>
|
||
<select id="source" name="source" required>
|
||
<option value="抖音">抖音</option>
|
||
<option value="微信">微信</option>
|
||
<option value="快手">快手</option>
|
||
<option value="朋友介绍">朋友介绍</option>
|
||
<option value="其他">其他</option>
|
||
</select>
|
||
</div>
|
||
</div>
|
||
|
||
<div class="form-group">
|
||
<label for="notes">备注</label>
|
||
<textarea id="notes" name="notes" rows="3" placeholder="其他备注信息..."></textarea>
|
||
</div>
|
||
|
||
<div class="form-actions">
|
||
<button type="submit" class="btn btn-primary" id="submitBtn" disabled>提交预约</button>
|
||
<button type="reset" class="btn" onclick="resetForm()">重置</button>
|
||
</div>
|
||
</form>
|
||
</div>
|
||
</div>
|
||
|
||
|
||
</div>
|
||
|
||
<script>
|
||
const packages = <?= $packages_json ?>;
|
||
const bookingSchedule = <?= json_encode($booking_schedule) ?>;
|
||
const bookingsByDate = <?= json_encode($bookings_by_date) ?>;
|
||
let selectedDate = null;
|
||
let selectedTime = null;
|
||
let selectedDuration = 60;
|
||
|
||
// 工作时间设置 - 改为24小时制
|
||
const workingHours = {
|
||
start: 0, // 00:00
|
||
end: 24, // 24:00
|
||
slotDuration: 30 // 30分钟一个时段
|
||
};
|
||
|
||
// 页面加载完成时初始化
|
||
document.addEventListener('DOMContentLoaded', function() {
|
||
// 初始化时间选择
|
||
generateTimeSlots();
|
||
|
||
// 处理当前时间
|
||
const now = new Date();
|
||
const todayStr = now.getFullYear() + '-' +
|
||
String(now.getMonth() + 1).padStart(2, '0') + '-' +
|
||
String(now.getDate()).padStart(2, '0');
|
||
document.getElementById('appointment_date').value = todayStr;
|
||
|
||
// 初始化VIP客户全局变量
|
||
window.allVIPCustomers = [];
|
||
|
||
// 加载VIP客户（使用异步加载确保数据完整性）
|
||
console.log('开始初始化VIP客户数据...');
|
||
loadVIPCustomers()
|
||
.then(data => {
|
||
console.log('VIP客户数据初始化成功，共', data.length, '条记录');
|
||
})
|
||
.catch(error => {
|
||
console.error('VIP客户数据初始化失败:', error);
|
||
// 即使VIP数据加载失败，也要继续页面初始化
|
||
});
|
||
|
||
// 初始化调试面板
|
||
setupVIPDebugPanel();
|
||
updateDebugStatus('正在加载...');
|
||
|
||
// 调试信息
|
||
console.log('页面初始化完成');
|
||
});
|
||
|
||
// 加载VIP客户列表 - 返回Promise以支持异步调用
|
||
function loadVIPCustomers() {
|
||
console.log('开始加载VIP客户列表...');
|
||
|
||
return new Promise((resolve, reject) => {
|
||
// 定义多个可能的API路径，优先使用绝对路径
|
||
const apiUrls = [
|
||
'/get_vip_customers.php', // 推荐的绝对路径
|
||
'get_vip_customers.php', // 原始相对路径
|
||
'./get_vip_customers.php' // 另一种相对路径
|
||
];
|
||
|
||
let currentAttempt = 0;
|
||
|
||
// 从本地存储加载或创建测试数据
|
||
function getTestVIPData() {
|
||
// 先尝试从localStorage加载
|
||
const savedVips = localStorage.getItem('temp_vip_customers');
|
||
if (savedVips) {
|
||
try {
|
||
const data = JSON.parse(savedVips);
|
||
console.log('从本地存储加载了测试VIP数据:', data.length, '条记录');
|
||
return data;
|
||
} catch (e) {
|
||
console.error('解析本地存储的VIP数据失败:', e);
|
||
}
|
||
}
|
||
|
||
// 创建测试数据
|
||
const testCustomers = [
|
||
{ customer_name: '张三', phone: '18612345678', car_model: '奔驰C级', car_number: '京A12345' },
|
||
{ customer_name: '李四', phone: '13987654321', car_model: '宝马3系', car_number: '京B54321' },
|
||
{ customer_name: '王五', phone: '18699627661', car_model: '奥迪A4', car_number: '沪A12345' },
|
||
{ customer_name: '赵六', phone: '18699627777', car_model: '特斯拉Model 3', car_number: '深A67890' },
|
||
{ customer_name: '钱七', phone: '13812345678', car_model: '丰田凯美瑞', car_number: '广A12345' }
|
||
];
|
||
|
||
// 为每个客户添加ID和时间戳
|
||
testCustomers.forEach((customer, index) => {
|
||
customer.id = index + 1;
|
||
customer.created_at = new Date().toISOString();
|
||
customer.is_active = 1;
|
||
});
|
||
|
||
// 保存到localStorage
|
||
localStorage.setItem('temp_vip_customers', JSON.stringify(testCustomers));
|
||
console.log('创建并保存了测试VIP数据，共', testCustomers.length, '条记录');
|
||
|
||
return testCustomers;
|
||
}
|
||
|
||
function tryNextUrl() {
|
||
if (currentAttempt >= apiUrls.length) {
|
||
const errorMsg = '所有URL尝试失败，使用测试数据进行演示';
|
||
console.error(errorMsg);
|
||
updateDebugStatus(errorMsg, 'warning');
|
||
|
||
// 使用测试数据
|
||
const testData = getTestVIPData();
|
||
window.allVIPCustomers = testData;
|
||
updateVIPSelect(testData);
|
||
|
||
// 更新调试面板
|
||
const historyElem = document.getElementById('debug-search-history');
|
||
if (historyElem) {
|
||
const previewEntry = document.createElement('div');
|
||
previewEntry.style.cssText = 'border-bottom: 1px solid #eee; padding: 5px 0; color: #444;';
|
||
previewEntry.innerHTML = `
|
||
<div style="font-weight: bold; color: orange;">⚠️ 使用测试VIP数据:</div>
|
||
<div>加载了 ${testData.length} 个测试VIP客户</div>
|
||
<div style="margin-top: 5px; font-size: 11px;">
|
||
${testData.map((vip, idx) =>
|
||
`${idx + 1}. ${vip.customer_name}: ${vip.phone}`
|
||
).join('<br>')}
|
||
</div>
|
||
`;
|
||
historyElem.innerHTML = '';
|
||
historyElem.appendChild(previewEntry);
|
||
}
|
||
|
||
// 返回测试数据
|
||
resolve(testData);
|
||
return;
|
||
}
|
||
|
||
const currentUrl = apiUrls[currentAttempt];
|
||
console.log(`尝试加载VIP数据 (${currentAttempt + 1}/${apiUrls.length}): ${currentUrl}`);
|
||
|
||
fetch(currentUrl)
|
||
.then(response => {
|
||
console.log(`URL ${currentUrl} 响应状态: ${response.status} ${response.statusText}`);
|
||
|
||
if (!response.ok) {
|
||
throw new Error(`HTTP ${response.status}: ${response.statusText}`);
|
||
}
|
||
|
||
return response.text();
|
||
})
|
||
.then(text => {
|
||
console.log(`URL ${currentUrl} 原始响应文本长度: ${text.length} 字符`);
|
||
|
||
// 显示部分原始响应以便调试
|
||
if (text.length > 0) {
|
||
console.log('原始响应前100字符:', text.substring(0, Math.min(100, text.length)));
|
||
}
|
||
|
||
try {
|
||
// 先检查是否为空响应
|
||
if (!text || text.trim() === '') {
|
||
throw new Error('API返回空响应');
|
||
}
|
||
|
||
// 检查是否包含HTML标签（可能是错误页面）
|
||
if (text.includes('<html') || text.includes('<body') || text.includes('</html>')) {
|
||
throw new Error('响应包含HTML内容而非JSON');
|
||
}
|
||
|
||
// 尝试解析JSON
|
||
let data;
|
||
try {
|
||
data = JSON.parse(text);
|
||
} catch (parseError) {
|
||
// 尝试修复常见的JSON格式问题
|
||
console.warn('JSON解析失败，尝试修复格式...');
|
||
|
||
// 移除可能的BOM字符
|
||
const cleanText = text.replace(/^\uFEFF/, '');
|
||
// 移除可能的多余逗号
|
||
const fixedText = cleanText.replace(/,\s*}/g, '}').replace(/,\s*\]/g, ']');
|
||
|
||
if (fixedText !== text) {
|
||
console.log('使用修复后的文本重新解析');
|
||
try {
|
||
data = JSON.parse(fixedText);
|
||
console.log('修复后解析成功！');
|
||
} catch (fixError) {
|
||
// 如果修复失败，继续尝试下一个URL
|
||
currentAttempt++;
|
||
tryNextUrl();
|
||
return;
|
||
}
|
||
} else {
|
||
// 如果没有修复，继续尝试下一个URL
|
||
currentAttempt++;
|
||
tryNextUrl();
|
||
return;
|
||
}
|
||
}
|
||
|
||
// 检查是否是错误响应
|
||
if (data.error) {
|
||
// 如果API返回错误，继续尝试下一个URL
|
||
currentAttempt++;
|
||
tryNextUrl();
|
||
return;
|
||
}
|
||
|
||
console.log('VIP客户数据解析成功:', typeof data);
|
||
|
||
// 处理可能的嵌套数据结构
|
||
let finalData = data;
|
||
if (!Array.isArray(data)) {
|
||
console.log('数据不是数组，检查是否有嵌套结构...');
|
||
if (data && data.customers && Array.isArray(data.customers)) {
|
||
console.log('发现嵌套的customers数组');
|
||
finalData = data.customers;
|
||
} else if (data && data.vip_customers && Array.isArray(data.vip_customers)) {
|
||
console.log('发现嵌套的vip_customers数组');
|
||
finalData = data.vip_customers;
|
||
} else {
|
||
// 格式不符合预期，继续尝试下一个URL
|
||
currentAttempt++;
|
||
tryNextUrl();
|
||
return;
|
||
}
|
||
}
|
||
|
||
console.log('最终VIP数据类型检查:', Array.isArray(finalData));
|
||
console.log('VIP客户数量:', finalData.length);
|
||
|
||
// 存储VIP客户数据
|
||
window.allVIPCustomers = finalData;
|
||
updateVIPSelect(finalData); // 更新下拉列表
|
||
|
||
// 更新调试面板状态
|
||
updateDebugStatus('加载成功，共 ' + finalData.length + ' 条记录', 'success');
|
||
|
||
// 显示前几个VIP客户信息（如果有的话）
|
||
if (finalData.length > 0) {
|
||
console.log('前3个VIP客户信息:');
|
||
finalData.slice(0, 3).forEach((vip, index) => {
|
||
console.log(`${index + 1}. ${vip.customer_name || '未知'} - ${vip.phone || '未知'}`);
|
||
});
|
||
}
|
||
|
||
// 在调试面板中显示部分数据预览
|
||
const historyElem = document.getElementById('debug-search-history');
|
||
if (historyElem) {
|
||
const previewEntry = document.createElement('div');
|
||
previewEntry.style.cssText = 'border-bottom: 1px solid #eee; padding: 5px 0; color: #444;';
|
||
previewEntry.innerHTML = `
|
||
<div style="font-weight: bold;">📋 VIP数据预览:</div>
|
||
<div>加载了 ${finalData.length} 个VIP客户</div>
|
||
`;
|
||
|
||
// 显示前3个VIP客户作为预览
|
||
if (finalData.length > 0) {
|
||
let previewHtml = '<div style="margin-top: 5px; font-size: 11px;">';
|
||
finalData.slice(0, 3).forEach((vip, idx) => {
|
||
previewHtml += `${idx + 1}. ${vip.customer_name || '未知'}: ${vip.phone || '未知'}<br>`;
|
||
});
|
||
previewHtml += '</div>';
|
||
previewEntry.innerHTML += previewHtml;
|
||
}
|
||
|
||
historyElem.innerHTML = '';
|
||
historyElem.appendChild(previewEntry);
|
||
}
|
||
|
||
// 成功完成，resolve Promise（使用处理后的finalData）
|
||
resolve(finalData);
|
||
} catch(e) {
|
||
console.error('VIP客户数据处理过程中发生异常:', e);
|
||
// 继续尝试下一个URL
|
||
currentAttempt++;
|
||
tryNextUrl();
|
||
}
|
||
})
|
||
.catch(error => {
|
||
console.error(`URL ${currentUrl} 请求失败:`, error.message);
|
||
// 继续尝试下一个URL
|
||
currentAttempt++;
|
||
tryNextUrl();
|
||
});
|
||
}
|
||
|
||
// 开始尝试第一个URL
|
||
tryNextUrl();
|
||
});
|
||
}
|
||
|
||
// 测试搜索功能
|
||
function testSearchFunction() {
|
||
if (window.allVIPCustomers.length > 0) {
|
||
console.log('当前VIP客户:', window.allVIPCustomers);
|
||
|
||
// 模拟搜索测试
|
||
const testTerm = window.allVIPCustomers[0].customer_name.substring(0, 1);
|
||
const results = window.allVIPCustomers.filter(vip =>
|
||
vip.customer_name.includes(testTerm) ||
|
||
vip.phone.includes(testTerm)
|
||
);
|
||
|
||
console.log('搜索测试:', testTerm, '->', results.length, '个结果');
|
||
}
|
||
}
|
||
|
||
// 更新VIP客户下拉列表
|
||
function updateVIPSelect(customers) {
|
||
const vipSelect = document.getElementById('vip_id');
|
||
vipSelect.innerHTML = '<option value="">请选择VIP客户</option>';
|
||
customers.forEach(vip => {
|
||
const option = document.createElement('option');
|
||
option.value = vip.id;
|
||
option.textContent = `${vip.customer_name} (${vip.phone})`;
|
||
vipSelect.appendChild(option);
|
||
});
|
||
}
|
||
|
||
// VIP客户搜索功能 - 修复版本
|
||
function searchVIPCustomers() {
|
||
console.log('开始搜索VIP客户...');
|
||
|
||
// 确保allVIPCustomers已初始化
|
||
if (!window.allVIPCustomers || !Array.isArray(window.allVIPCustomers)) {
|
||
window.allVIPCustomers = [];
|
||
console.warn('allVIPCustomers未初始化，已创建空数组');
|
||
}
|
||
|
||
const searchInput = document.getElementById('vip_search');
|
||
const searchResultsDiv = document.getElementById('vip_search_results');
|
||
const vipSelect = document.getElementById('vip_id');
|
||
|
||
if (!searchInput || !searchResultsDiv || !vipSelect) {
|
||
console.error('找不到必要的DOM元素');
|
||
return;
|
||
}
|
||
|
||
const searchTerm = searchInput.value.trim();
|
||
console.log('搜索关键词:', searchTerm);
|
||
|
||
// 检查数据加载状态
|
||
console.log('VIP客户总数:', window.allVIPCustomers.length);
|
||
|
||
// 立即处理空搜索情况
|
||
if (searchTerm === '') {
|
||
searchResultsDiv.innerHTML = '';
|
||
searchResultsDiv.style.display = 'none';
|
||
vipSelect.style.display = 'block';
|
||
return;
|
||
}
|
||
|
||
// 始终显示搜索结果容器
|
||
searchResultsDiv.style.display = 'block';
|
||
|
||
// 如果数据还没加载完成，先加载数据
|
||
if (window.allVIPCustomers.length === 0) {
|
||
console.log('VIP客户数据尚未加载，先加载数据...');
|
||
searchResultsDiv.innerHTML = '<div class="loading">正在加载VIP客户数据...</div>';
|
||
|
||
loadVIPCustomers().then(() => {
|
||
console.log('数据加载完成，重新执行搜索');
|
||
// 数据加载后执行搜索
|
||
performSearch(searchTerm);
|
||
}).catch(error => {
|
||
console.error('加载VIP数据失败:', error);
|
||
searchResultsDiv.innerHTML = '<div class="search-error">加载VIP客户数据失败，请重试</div>';
|
||
});
|
||
} else {
|
||
// 直接执行搜索
|
||
performSearch(searchTerm);
|
||
}
|
||
|
||
function performSearch(term) {
|
||
// 标准化手机号函数
|
||
const normalizePhone = (phoneStr) => {
|
||
return phoneStr ? phoneStr.replace(/[^0-9]/g, '') : '';
|
||
};
|
||
|
||
// 模糊搜索：支持姓名、手机号和车牌号搜索，增强匹配逻辑
|
||
const filteredCustomers = window.allVIPCustomers.filter(vip => {
|
||
// 确保vip对象有效
|
||
if (!vip || typeof vip !== 'object') return false;
|
||
|
||
const searchLower = term.toLowerCase();
|
||
const name = (vip.customer_name || '').toLowerCase();
|
||
const phone = vip.phone || '';
|
||
const carModel = (vip.car_model || '').toLowerCase();
|
||
const carNumber = (vip.car_number || '').toLowerCase();
|
||
|
||
// 基本匹配
|
||
let isMatch = name.includes(searchLower) ||
|
||
phone.includes(term) ||
|
||
carModel.includes(searchLower) ||
|
||
carNumber.includes(searchLower);
|
||
|
||
// 手机号标准化匹配（处理数字搜索）
|
||
if (!isMatch && /^\d+$/.test(term)) {
|
||
const normalizedPhone = normalizePhone(phone);
|
||
const normalizedSearch = normalizePhone(term);
|
||
isMatch = normalizedPhone.includes(normalizedSearch) ||
|
||
normalizedSearch.includes(normalizedPhone);
|
||
}
|
||
|
||
// 调试日志
|
||
console.log('搜索项检查:', {
|
||
id: vip.id,
|
||
name: vip.customer_name,
|
||
phone: phone,
|
||
match: isMatch
|
||
});
|
||
|
||
return isMatch;
|
||
});
|
||
|
||
console.log('搜索结果数量:', filteredCustomers.length);
|
||
|
||
// 显示搜索结果
|
||
if (filteredCustomers.length === 0) {
|
||
searchResultsDiv.innerHTML = '<div class="no-results">未找到匹配的VIP客户<br>请尝试使用姓名、手机号或车牌号搜索</div>';
|
||
} else {
|
||
let html = '';
|
||
filteredCustomers.forEach(vip => {
|
||
// 安全获取数据并设置默认值
|
||
const name = vip.customer_name || '未知客户';
|
||
const phone = vip.phone || '未知手机号';
|
||
const id = vip.id || '';
|
||
const carModel = vip.car_model || '';
|
||
const carNumber = vip.car_number || '';
|
||
|
||
// 转义HTML和引号，防止XSS和JS语法错误
|
||
const escapeHtml = (str) => {
|
||
const div = document.createElement('div');
|
||
div.textContent = str;
|
||
return div.innerHTML;
|
||
};
|
||
const escapeJs = (str) => {
|
||
return str.replace(/'/g, "\\'").replace(/"/g, '\\"').replace(/\\/g, '\\\\');
|
||
};
|
||
|
||
const escapedId = escapeJs(id.toString());
|
||
const escapedName = escapeJs(name);
|
||
const escapedPhone = escapeJs(phone);
|
||
|
||
// 高亮处理（先转义HTML，再进行高亮）
|
||
const escapedNameHtml = escapeHtml(name);
|
||
const escapedPhoneHtml = escapeHtml(phone);
|
||
const escapedTerm = escapeHtml(term);
|
||
const highlightedName = escapedNameHtml.replace(new RegExp(`(${escapedTerm.replace(/[.*+?^${}()|[\]\\]/g, '\\$&')})`, 'gi'), '<span class="highlight">$1</span>');
|
||
const highlightedPhone = escapedPhoneHtml.replace(new RegExp(`(${escapedTerm.replace(/[.*+?^${}()|[\]\\]/g, '\\$&')})`, 'gi'), '<span class="highlight">$1</span>');
|
||
|
||
const escapedCarModel = escapeHtml(carModel);
|
||
const escapedCarNumber = escapeHtml(carNumber);
|
||
|
||
html += `
|
||
<div class="vip-search-item" onclick="selectVIPCustomer('${escapedId}', '${escapedName}', '${escapedPhone}')">
|
||
<div class="customer-name">${highlightedName}</div>
|
||
<div class="customer-phone">${highlightedPhone}</div>
|
||
${carModel || carNumber ? `<div class="customer-car">${escapedCarModel} ${escapedCarNumber}</div>` : ''}
|
||
</div>
|
||
`;
|
||
});
|
||
searchResultsDiv.innerHTML = html;
|
||
}
|
||
|
||
// 隐藏下拉列表
|
||
vipSelect.style.display = 'none';
|
||
}
|
||
}
|
||
|
||
// 显示搜索结果
|
||
function displaySearchResults(results, searchTerm) {
|
||
console.log('显示搜索结果...', results.length, '个结果');
|
||
|
||
const searchResultsDiv = document.getElementById('vip_search_results');
|
||
|
||
if (!searchResultsDiv) {
|
||
console.error('找不到VIP搜索结果容器');
|
||
return;
|
||
}
|
||
|
||
if (results.length === 0) {
|
||
searchResultsDiv.innerHTML = '<div class="no-results">未找到匹配的VIP客户</div>';
|
||
searchResultsDiv.style.display = 'block';
|
||
return;
|
||
}
|
||
|
||
let html = '';
|
||
results.forEach(vip => {
|
||
// 安全地处理数据
|
||
const name = vip.customer_name || '';
|
||
const phone = vip.phone || '';
|
||
const id = vip.id || '';
|
||
|
||
const highlightedName = highlightSearchTerm(name, searchTerm);
|
||
const highlightedPhone = highlightSearchTerm(phone, searchTerm);
|
||
|
||
html += `
|
||
<div class="vip-search-item" onclick="selectVIPCustomer('${id}', '${name}', '${phone}')">
|
||
<div class="customer-name">${highlightedName}</div>
|
||
<div class="customer-phone">${highlightedPhone}</div>
|
||
${vip.car_model || vip.car_number ? `<div class="customer-car">${vip.car_model || ''} ${vip.car_number || ''}</div>` : ''}
|
||
</div>
|
||
`;
|
||
});
|
||
|
||
searchResultsDiv.innerHTML = html;
|
||
searchResultsDiv.style.display = 'block';
|
||
console.log('搜索结果已显示');
|
||
}
|
||
|
||
// 高亮搜索关键词
|
||
function highlightSearchTerm(text, searchTerm) {
|
||
if (!text || !searchTerm) return text || '';
|
||
|
||
console.log('高亮处理:', text, '关键词:', searchTerm);
|
||
|
||
const regex = new RegExp(`(${searchTerm})`, 'gi');
|
||
const result = text.replace(regex, '<span class="highlight">$1</span>');
|
||
|
||
console.log('高亮结果:', result);
|
||
return result;
|
||
}
|
||
|
||
// 清除搜索结果
|
||
function clearSearchResults() {
|
||
console.log('清除搜索结果');
|
||
|
||
const searchResults = document.getElementById('vip_search_results');
|
||
if (searchResults) {
|
||
searchResults.innerHTML = '';
|
||
searchResults.style.display = 'none';
|
||
}
|
||
|
||
const searchInput = document.getElementById('vip_search');
|
||
if (searchInput) {
|
||
searchInput.value = '';
|
||
}
|
||
}
|
||
|
||
// 选择VIP客户 - 修复版本
|
||
function selectVIPCustomer(customerId, customerName = '', customerPhone = '') {
|
||
console.log('选择VIP客户:', customerId, customerName, customerPhone);
|
||
|
||
// 设置下拉选择值
|
||
const vipSelect = document.getElementById('vip_id');
|
||
const searchResultsDiv = document.getElementById('vip_search_results');
|
||
const searchInput = document.getElementById('vip_search');
|
||
|
||
if (vipSelect) {
|
||
vipSelect.value = customerId;
|
||
vipSelect.style.display = 'block';
|
||
console.log('已设置VIP选择值:', customerId);
|
||
} else {
|
||
console.error('找不到VIP选择元素');
|
||
}
|
||
|
||
// 清除搜索状态
|
||
if (searchResultsDiv) {
|
||
searchResultsDiv.innerHTML = '';
|
||
searchResultsDiv.style.display = 'none';
|
||
}
|
||
|
||
if (searchInput) {
|
||
searchInput.value = '';
|
||
}
|
||
|
||
// 加载VIP客户信息
|
||
loadVIPInfo();
|
||
|
||
// 显示选择成功的提示
|
||
if (customerName) {
|
||
console.log('成功选择VIP客户:', customerName);
|
||
}
|
||
}
|
||
|
||
// 检查手机号是否为VIP客户 - 完全重写的可靠版本
|
||
function checkPhoneForVIP() {
|
||
console.log('--- 开始检查手机号是否为VIP客户 ---');
|
||
|
||
const phoneInput = document.getElementById('phone');
|
||
const tipDiv = document.getElementById('phone_vip_tip');
|
||
const phone = phoneInput.value.trim();
|
||
|
||
// 清除提示
|
||
tipDiv.style.display = 'none';
|
||
tipDiv.className = 'phone-vip-tip';
|
||
|
||
// 基本检查
|
||
if (phone.length < 3) {
|
||
console.log('手机号过短，不进行检查:', phone);
|
||
return;
|
||
}
|
||
|
||
// 检查window.allVIPCustomers是否存在且为数组
|
||
if (!window.allVIPCustomers || !Array.isArray(window.allVIPCustomers)) {
|
||
console.error('错误：window.allVIPCustomers未正确初始化');
|
||
tipDiv.innerHTML = '<span style="color:red;">⚠️ VIP客户数据未加载，请刷新页面</span>';
|
||
tipDiv.className = 'phone-vip-tip error';
|
||
tipDiv.style.display = 'block';
|
||
return;
|
||
}
|
||
|
||
console.log('搜索手机号:', phone);
|
||
console.log('VIP客户总数:', window.allVIPCustomers.length);
|
||
|
||
// 创建标准化函数：移除所有非数字字符
|
||
const normalizePhone = (phoneStr) => {
|
||
return phoneStr ? phoneStr.replace(/[^0-9]/g, '') : '';
|
||
};
|
||
|
||
const normalizedInput = normalizePhone(phone);
|
||
console.log('标准化后的输入:', normalizedInput);
|
||
|
||
// 找出所有可能匹配的VIP客户
|
||
const potentialMatches = [];
|
||
let matchedVIP = null;
|
||
let bestMatchScore = 0;
|
||
|
||
for (const vip of window.allVIPCustomers) {
|
||
if (!vip.phone) continue;
|
||
|
||
const vipPhone = vip.phone;
|
||
const normalizedVIPPhone = normalizePhone(vipPhone);
|
||
|
||
console.log('检查VIP:', vip.customer_name, '手机号:', vipPhone, '标准化后:', normalizedVIPPhone);
|
||
|
||
// 计算匹配分数
|
||
let matchScore = 0;
|
||
|
||
// 精确匹配（最高优先级）
|
||
if (vipPhone === phone) {
|
||
matchScore = 100;
|
||
} else if (normalizedVIPPhone === normalizedInput) {
|
||
matchScore = 95;
|
||
}
|
||
// 包含匹配（中等优先级）
|
||
else if (vipPhone.includes(phone)) {
|
||
matchScore = 90;
|
||
} else if (phone.includes(vipPhone)) {
|
||
matchScore = 85;
|
||
} else if (normalizedVIPPhone.includes(normalizedInput)) {
|
||
matchScore = 80;
|
||
} else if (normalizedInput.includes(normalizedVIPPhone)) {
|
||
matchScore = 75;
|
||
}
|
||
// 后几位匹配（低优先级）
|
||
else if (normalizedInput.length >= 4 && normalizedVIPPhone.endsWith(normalizedInput)) {
|
||
matchScore = 70;
|
||
}
|
||
// 前几位匹配
|
||
else if (normalizedInput.length >= 4 && normalizedVIPPhone.startsWith(normalizedInput)) {
|
||
matchScore = 65;
|
||
}
|
||
// 部分匹配（最低优先级）
|
||
else if (normalizedVIPPhone.includes(normalizedInput.substring(normalizedInput.length - 4))) {
|
||
matchScore = 60;
|
||
} else if (normalizedInput.length >= 6 && normalizedVIPPhone.includes(normalizedInput.substring(0, 6))) {
|
||
matchScore = 55;
|
||
}
|
||
|
||
// 如果找到更好的匹配，更新匹配结果
|
||
if (matchScore > bestMatchScore) {
|
||
bestMatchScore = matchScore;
|
||
matchedVIP = vip;
|
||
console.log('找到更好的匹配:', vip.customer_name, vipPhone, '分数:', matchScore);
|
||
}
|
||
|
||
// 记录潜在匹配供调试
|
||
if (matchScore >= 50 && matchScore < bestMatchScore) {
|
||
potentialMatches.push({name: vip.customer_name, phone: vipPhone, score: matchScore});
|
||
} else if (normalizedVIPPhone.includes(normalizedInput.substring(normalizedInput.length - 3)) ||
|
||
normalizedInput.includes(normalizedVIPPhone.substring(normalizedVIPPhone.length - 3))) {
|
||
potentialMatches.push({name: vip.customer_name, phone: vipPhone, score: 40});
|
||
}
|
||
}
|
||
|
||
// 根据分数过滤潜在匹配，只保留分数较高的
|
||
potentialMatches.sort((a, b) => (b.score || 0) - (a.score || 0));
|
||
|
||
console.log('潜在匹配列表:', potentialMatches);
|
||
console.log('最终匹配结果:', matchedVIP, '匹配分数:', bestMatchScore);
|
||
|
||
// 设置最小匹配分数阈值
|
||
const MIN_MATCH_SCORE = 55;
|
||
|
||
// 只有当匹配分数足够高时才认为是有效匹配
|
||
const isEffectiveMatch = matchedVIP && bestMatchScore >= MIN_MATCH_SCORE;
|
||
|
||
if (isEffectiveMatch) {
|
||
console.log('确认有效匹配，分数:', bestMatchScore);
|
||
// 显示VIP客户提示
|
||
tipDiv.innerHTML = `
|
||
<strong>👑 检测到VIP客户！</strong><br>
|
||
该手机号属于 VIP客户：${matchedVIP.customer_name}<br>
|
||
手机号：${matchedVIP.phone}<br>
|
||
车牌号：${matchedVIP.car_number || '暂无'}<br>
|
||
匹配度：${bestMatchScore}分<br>
|
||
<button type="button" onclick="switchToVIPMode(${matchedVIP.id})" class="switch-to-vip-btn">
|
||
切换到VIP客户模式
|
||
</button>
|
||
`;
|
||
tipDiv.className = 'phone-vip-tip vip-detected';
|
||
tipDiv.style.display = 'block';
|
||
} else if (phone.length >= 8) {
|
||
// 显示建议提示（当手机号长度足够时）
|
||
let message = '💡 <strong>提示：</strong>未找到该手机号的VIP客户<br>';
|
||
message += '如果此客户是VIP客户，请检查手机号是否正确';
|
||
|
||
// 如果有潜在匹配，添加提示并显示匹配分数
|
||
if (potentialMatches.length > 0) {
|
||
message += '<br><br><strong>可能相关的VIP客户：</strong><br>';
|
||
potentialMatches.slice(0, 3).forEach(vip => {
|
||
const scoreText = vip.score ? ` (匹配度: ${vip.score}分)` : '';
|
||
message += `- ${vip.name} (${vip.phone})${scoreText}<br>`;
|
||
});
|
||
} else if (matchedVIP && bestMatchScore > 0) {
|
||
// 如果有低分数匹配，也显示出来
|
||
message += `<br><br><strong>相似手机号的VIP客户：</strong><br>`;
|
||
message += `- ${matchedVIP.customer_name} (${matchedVIP.phone}) (匹配度: ${bestMatchScore}分)<br>`;
|
||
}
|
||
|
||
tipDiv.innerHTML = message;
|
||
tipDiv.className = 'phone-vip-tip suggestion';
|
||
tipDiv.style.display = 'block';
|
||
}
|
||
|
||
// 增强的调试日志
|
||
console.log('--- 结束检查手机号 ---');
|
||
console.log('检查总结: 输入手机号=', phone, '标准化后=', normalizedInput, 'VIP客户总数=', window.allVIPCustomers.length, '有效匹配=', isEffectiveMatch);
|
||
|
||
// 记录到调试面板，包含更详细的信息
|
||
logSearchToDebugPanel(phone, matchedVIP, potentialMatches, {
|
||
normalizedInput,
|
||
matchScore: bestMatchScore,
|
||
isEffectiveMatch,
|
||
vipCount: window.allVIPCustomers.length
|
||
});
|
||
}
|
||
|
||
// VIP客户搜索调试面板
|
||
/*
|
||
* VIP客户搜索调试面板 - 默认隐藏
|
||
*
|
||
* 开启方式:
|
||
* 1. 页面加载时默认隐藏，点击右上角"显示"按钮可开启调试面板
|
||
* 2. 或在控制台执行: document.getElementById('vip-debug-panel').style.display = 'block'
|
||
* 3. 或修改上方style.cssText中的'display: none'为'display: block'使其默认显示
|
||
*
|
||
* 使用方式:
|
||
* 1. 查看VIP数据加载状态（成功/失败/数量）
|
||
* 2. 查看每次搜索的详细历史记录，包括输入手机号、匹配结果和潜在匹配
|
||
* 3. 点击"隐藏"按钮可关闭面板，再次点击"显示"可重新打开
|
||
*/
|
||
function setupVIPDebugPanel() {
|
||
// 检查是否已存在调试面板
|
||
if (document.getElementById('vip-debug-panel')) return;
|
||
|
||
// 创建调试面板HTML
|
||
const debugPanel = document.createElement('div');
|
||
debugPanel.id = 'vip-debug-panel';
|
||
debugPanel.style.cssText = `
|
||
position: fixed;
|
||
top: 10px;
|
||
right: 10px;
|
||
width: 350px;
|
||
max-height: 400px;
|
||
background: #f8f9fa;
|
||
border: 1px solid #ddd;
|
||
border-radius: 8px;
|
||
padding: 15px;
|
||
box-shadow: 0 2px 10px rgba(0,0,0,0.1);
|
||
z-index: 10000;
|
||
overflow-y: auto;
|
||
font-family: monospace;
|
||
font-size: 12px;
|
||
display: none;
|
||
`;
|
||
|
||
debugPanel.innerHTML = `
|
||
<div style="display: flex; justify-content: space-between; align-items: center; margin-bottom: 10px;">
|
||
<h4 style="margin: 0; font-size: 14px;">VIP客户搜索调试面板</h4>
|
||
<button id="toggle-vip-debug" style="padding: 2px 8px; font-size: 10px;">显示</button>
|
||
</div>
|
||
<div id="debug-status" style="margin-bottom: 10px; padding: 5px; background: #e3f2fd; border-radius: 4px;">
|
||
VIP数据加载状态: <span id="vip-data-status">未加载</span>
|
||
</div>
|
||
<div id="debug-search-history" style="max-height: 250px; overflow-y: auto;">
|
||
<p style="color: #666; font-style: italic; text-align: center;">搜索历史将显示在这里</p>
|
||
</div>
|
||
`;
|
||
|
||
// 添加到页面
|
||
document.body.appendChild(debugPanel);
|
||
|
||
// 注: 调试面板默认隐藏，可通过点击右上角"显示"按钮打开
|
||
|
||
// 添加切换显示/隐藏功能
|
||
document.getElementById('toggle-vip-debug').addEventListener('click', function() {
|
||
const panel = document.getElementById('vip-debug-panel');
|
||
const button = document.getElementById('toggle-vip-debug');
|
||
|
||
if (panel.style.display === 'none') {
|
||
panel.style.display = 'block';
|
||
button.textContent = '隐藏';
|
||
} else {
|
||
panel.style.display = 'none';
|
||
button.textContent = '显示';
|
||
}
|
||
});
|
||
}
|
||
|
||
// 更新调试面板状态
|
||
function updateDebugStatus(status) {
|
||
const statusElem = document.getElementById('vip-data-status');
|
||
if (statusElem) {
|
||
statusElem.textContent = status;
|
||
|
||
// 设置不同状态的颜色
|
||
if (status.includes('成功')) {
|
||
statusElem.style.color = 'green';
|
||
} else if (status.includes('错误') || status.includes('未加载')) {
|
||
statusElem.style.color = 'red';
|
||
} else {
|
||
statusElem.style.color = 'black';
|
||
}
|
||
}
|
||
}
|
||
|
||
// 记录搜索历史到调试面板
|
||
function logSearchToDebugPanel(phone, result, potentialMatches, searchInfo = {}) {
|
||
const historyElem = document.getElementById('debug-search-history');
|
||
if (!historyElem) return;
|
||
|
||
const timestamp = new Date().toLocaleTimeString();
|
||
const { normalizedInput, matchScore, isEffectiveMatch, vipCount } = searchInfo;
|
||
const logEntry = document.createElement('div');
|
||
logEntry.style.cssText = 'border-bottom: 1px solid #eee; padding: 8px 0; font-size: 12px;';
|
||
|
||
// 构建日志内容
|
||
let logContent = `
|
||
<div style="color: #666; font-weight: bold;">[${timestamp}] 搜索: ${phone}</div>
|
||
`;
|
||
|
||
// 添加详细信息
|
||
if (normalizedInput) {
|
||
logContent += `
|
||
<div style="color: #6c757d; margin-left: 10px; font-size: 11px;">标准化: ${normalizedInput}</div>
|
||
`;
|
||
}
|
||
|
||
if (vipCount !== undefined) {
|
||
logContent += `
|
||
<div style="color: #6c757d; margin-left: 10px; font-size: 11px;">数据库中VIP客户数: ${vipCount}</div>
|
||
`;
|
||
}
|
||
|
||
// 显示匹配结果
|
||
let resultHtml = '<span style="color: red;">未匹配</span>';
|
||
if (isEffectiveMatch !== undefined) {
|
||
if (isEffectiveMatch && result) {
|
||
resultHtml = `<span style="color: green;">匹配成功: ${result.customer_name} (${result.phone})</span>`;
|
||
if (matchScore !== undefined) {
|
||
logContent += `
|
||
<div>结果: ${resultHtml}</div>
|
||
<div style="color: #28a745; margin-left: 10px; font-size: 11px;">匹配度: ${matchScore}分</div>
|
||
`;
|
||
} else {
|
||
logContent += `
|
||
<div>结果: ${resultHtml}</div>
|
||
`;
|
||
}
|
||
} else {
|
||
if (result && matchScore !== undefined) {
|
||
resultHtml = `<span style="color: orange;">相似匹配: ${result.customer_name} (${result.phone}) (匹配度: ${matchScore}分)</span>`;
|
||
}
|
||
logContent += `
|
||
<div>结果: ${resultHtml}</div>
|
||
`;
|
||
}
|
||
} else if (result) {
|
||
// 兼容旧版本调用
|
||
resultHtml = `<span style="color: green;">匹配成功: ${result.customer_name} (${result.phone})</span>`;
|
||
logContent += `
|
||
<div>结果: ${resultHtml}</div>
|
||
`;
|
||
} else {
|
||
logContent += `
|
||
<div>结果: ${resultHtml}</div>
|
||
`;
|
||
}
|
||
|
||
// 如果有潜在匹配，也显示出来
|
||
if (potentialMatches && potentialMatches.length > 0) {
|
||
let potentialHtml = '<div style="margin-top: 2px; font-size: 11px; color: #666;">潜在匹配: ';
|
||
potentialHtml += potentialMatches.slice(0, 2).map(v => {
|
||
const scoreText = v.score ? ` (${v.score}分)` : '';
|
||
return `${v.name} (${v.phone})${scoreText}`;
|
||
}).join(', ');
|
||
if (potentialMatches.length > 2) potentialHtml += '...';
|
||
potentialHtml += '</div>';
|
||
logContent += potentialHtml;
|
||
}
|
||
|
||
logEntry.innerHTML = logContent;
|
||
|
||
// 添加到历史的顶部
|
||
if (historyElem.firstChild) {
|
||
historyElem.insertBefore(logEntry, historyElem.firstChild);
|
||
} else {
|
||
historyElem.appendChild(logEntry);
|
||
}
|
||
|
||
// 限制历史记录数量
|
||
while (historyElem.children.length > 20) {
|
||
historyElem.removeChild(historyElem.lastChild);
|
||
}
|
||
}
|
||
|
||
// 在页面加载时初始化调试面板
|
||
document.addEventListener('DOMContentLoaded', function() {
|
||
setupVIPDebugPanel();
|
||
});
|
||
|
||
|
||
// 切换到VIP模式
|
||
function switchToVIPMode(vipId = null) {
|
||
// 切换到VIP客户模式
|
||
document.getElementById('customer_type').value = 'vip';
|
||
handleCustomerTypeChange();
|
||
|
||
// 如果提供了VIP ID，选择该VIP客户
|
||
if (vipId) {
|
||
// 先等待VIP客户列表加载完成
|
||
setTimeout(() => {
|
||
document.getElementById('vip_id').value = vipId;
|
||
loadVIPInfo();
|
||
}, 500);
|
||
}
|
||
|
||
// 隐藏提示
|
||
document.getElementById('phone_vip_tip').style.display = 'none';
|
||
}
|
||
|
||
// 处理客户类型变更
|
||
function handleCustomerTypeChange() {
|
||
const customerType = document.getElementById('customer_type').value;
|
||
const vipSelectGroup = document.getElementById('vip_select_group');
|
||
const newCustomerFields = document.getElementById('new_customer_fields');
|
||
|
||
console.log('切换客户类型:', customerType);
|
||
|
||
if (customerType === 'vip') {
|
||
vipSelectGroup.style.display = 'block';
|
||
newCustomerFields.style.display = 'none';
|
||
// 隐藏新客户字段的必填属性
|
||
document.getElementById('customer_name').required = false;
|
||
document.getElementById('phone').required = false;
|
||
|
||
// 确保VIP客户数据已加载
|
||
if (window.allVIPCustomers.length === 0) {
|
||
console.log('VIP客户数据未加载，开始加载...');
|
||
loadVIPCustomers().then(() => {
|
||
console.log('VIP客户数据加载完成，可进行搜索和选择');
|
||
}).catch(error => {
|
||
console.error('加载VIP数据失败:', error);
|
||
});
|
||
}
|
||
} else {
|
||
vipSelectGroup.style.display = 'none';
|
||
newCustomerFields.style.display = 'flex';
|
||
// 显示新客户字段的必填属性
|
||
document.getElementById('customer_name').required = true;
|
||
document.getElementById('phone').required = true;
|
||
|
||
// 清除VIP选择
|
||
const vipSelect = document.getElementById('vip_id');
|
||
if (vipSelect) {
|
||
vipSelect.value = '';
|
||
}
|
||
|
||
// 清除搜索结果
|
||
const searchResultsDiv = document.getElementById('vip_search_results');
|
||
const searchInput = document.getElementById('vip_search');
|
||
if (searchResultsDiv) {
|
||
searchResultsDiv.innerHTML = '';
|
||
searchResultsDiv.style.display = 'none';
|
||
}
|
||
if (searchInput) {
|
||
searchInput.value = '';
|
||
}
|
||
}
|
||
|
||
updateSubmitButton();
|
||
}
|
||
|
||
// 加载VIP客户信息
|
||
function loadVIPInfo() {
|
||
const vipId = document.getElementById('vip_id').value;
|
||
if (vipId) {
|
||
// 这里将从数据库获取VIP客户详细信息
|
||
fetch(`get_vip_customer.php?id=${vipId}`)
|
||
.then(response => response.json())
|
||
.then(vip => {
|
||
if (vip.car_model) {
|
||
document.getElementById('car_model').value = vip.car_model;
|
||
}
|
||
if (vip.car_number) {
|
||
document.getElementById('car_number').value = vip.car_number;
|
||
}
|
||
})
|
||
.catch(error => {
|
||
console.log('加载VIP信息失败:', error);
|
||
});
|
||
|
||
// 获取并显示VIP客户最近预约记录
|
||
fetchLastBookingInfo(vipId);
|
||
} else {
|
||
// 如果没有选择VIP客户，隐藏上次预约信息区域
|
||
document.getElementById('vip_last_booking_info').style.display = 'none';
|
||
}
|
||
updateSubmitButton();
|
||
}
|
||
|
||
// 获取并显示VIP客户最近预约记录
|
||
function fetchLastBookingInfo(vipId) {
|
||
const vipName = document.getElementById('vip_id').options[document.getElementById('vip_id').selectedIndex].text;
|
||
|
||
fetch(`get_vip_last_booking.php?vip_id=${vipId}`)
|
||
.then(response => response.json())
|
||
.then(data => {
|
||
const infoContainer = document.getElementById('vip_last_booking_info');
|
||
const contentContainer = document.getElementById('last_booking_content');
|
||
|
||
infoContainer.style.display = 'block';
|
||
|
||
if (data.has_booking) {
|
||
// 有预约记录，显示上次预约信息
|
||
contentContainer.innerHTML = `
|
||
<p style="margin-bottom: 8px;"><strong>👤 ${vipName}</strong></p>
|
||
<p>📅 <strong>预约时间:</strong> ${data.appointment_date} ${data.appointment_time}</p>
|
||
<p>💼 <strong>套餐类型:</strong> ${data.package_name}</p>
|
||
<p>⏱️ <strong>施工时长:</strong> ${data.duration} 分钟</p>
|
||
`;
|
||
} else {
|
||
// 没有预约记录，显示首次到店提示
|
||
contentContainer.innerHTML = `
|
||
<p style="margin-bottom: 8px;"><strong>👤 ${vipName}</strong></p>
|
||
|
||
<p>这是该VIP客户的首次预约，请为客户提供优质服务体验。</p>
|
||
`;
|
||
}
|
||
})
|
||
.catch(error => {
|
||
console.error('获取上次预约记录失败:', error);
|
||
// 即使失败，也显示一个友好的提示
|
||
const infoContainer = document.getElementById('vip_last_booking_info');
|
||
const contentContainer = document.getElementById('last_booking_content');
|
||
infoContainer.style.display = 'block';
|
||
contentContainer.innerHTML = `<p style="color: #dc3545;">无法获取预约记录，请稍后重试。</p>`;
|
||
});
|
||
}
|
||
|
||
function showDateDetails(date) {
|
||
// 获取预约详情容器
|
||
const detailsDiv = document.getElementById('bookingDetails');
|
||
const detailsDateTitle = document.getElementById('detailsDateTitle');
|
||
const detailsContent = document.getElementById('bookingDetailsContent');
|
||
|
||
// 设置日期标题
|
||
const dateObj = new Date(date);
|
||
const dateStr = dateObj.toLocaleDateString('zh-CN', {
|
||
year: 'numeric',
|
||
month: 'long',
|
||
day: 'numeric',
|
||
weekday: 'long'
|
||
});
|
||
detailsDateTitle.textContent = dateStr + ' - 预约详情';
|
||
|
||
// 获取并显示预约详情
|
||
const details = getBookingDetailsForDate(date);
|
||
detailsContent.innerHTML = details;
|
||
|
||
// 显示预约详情区域
|
||
detailsDiv.style.display = 'block';
|
||
|
||
// 同时选择该日期用于预约
|
||
selectDate(date);
|
||
|
||
// 滚动到预约详情区域
|
||
setTimeout(() => {
|
||
detailsDiv.scrollIntoView({ behavior: 'smooth' });
|
||
}, 100);
|
||
}
|
||
|
||
function hideDateDetails() {
|
||
document.getElementById('bookingDetails').style.display = 'none';
|
||
}
|
||
|
||
function selectDate(date) {
|
||
selectedDate = date;
|
||
document.getElementById('appointment_date').value = date;
|
||
|
||
// 更新日历选中状态
|
||
document.querySelectorAll('.calendar-day').forEach(day => {
|
||
day.classList.remove('selected');
|
||
});
|
||
document.querySelector(`[data-date="${date}"]`).classList.add('selected');
|
||
|
||
// 生成时间段
|
||
generateTimeSlots(date);
|
||
}
|
||
|
||
function generateTimeSlots(date) {
|
||
const timeGrid = document.getElementById('timeGrid');
|
||
const timeSlotsDiv = document.getElementById('timeSlots');
|
||
|
||
timeGrid.innerHTML = '';
|
||
|
||
// 获取当天已有预约
|
||
const dayBookings = bookingSchedule[date];
|
||
|
||
// 生成时间段
|
||
for (let hour = workingHours.start; hour < workingHours.end; hour++) {
|
||
for (let minute = 0; minute < 60; minute += workingHours.slotDuration) {
|
||
const timeString = `${hour.toString().padStart(2, '0')}:${minute.toString().padStart(2, '0')}`;
|
||
const slotTime = new Date(`${date} ${timeString}:00`);
|
||
const now = new Date();
|
||
const isPast = slotTime <= now;
|
||
const isBooked = checkTimeSlotBooked(date, timeString);
|
||
|
||
const slotDiv = document.createElement('div');
|
||
slotDiv.className = `time-slot ${isPast ? 'past' : ''} ${isBooked ? 'booked' : 'available'}`;
|
||
slotDiv.textContent = timeString;
|
||
slotDiv.dataset.time = timeString; // 添加数据属性，与pending_bookings.php保持一致
|
||
slotDiv.onclick = () => selectTimeSlot(timeString);
|
||
|
||
timeGrid.appendChild(slotDiv);
|
||
}
|
||
}
|
||
|
||
timeSlotsDiv.style.display = 'block';
|
||
selectedTime = null;
|
||
updateSubmitButton();
|
||
}
|
||
|
||
function checkTimeSlotBooked(date, time) {
|
||
// 检查指定时间段是否已被预约
|
||
const bookings = bookingsByDate[date] || [];
|
||
for (let booking of bookings) {
|
||
const bookingStart = booking.start_time;
|
||
const bookingEnd = booking.end_time;
|
||
|
||
// 处理跨天预约的情况
|
||
if (booking.is_cross_day) {
|
||
// 如果是跨天预约的第二天记录，所有时间都应该是已被预约的（从00:00到结束时间）
|
||
if (time < bookingEnd) {
|
||
return true; // 该时间段已被预约
|
||
}
|
||
} else {
|
||
// 正常预约检查
|
||
if (time >= bookingStart && time < bookingEnd) {
|
||
return true; // 该时间段已被预约
|
||
}
|
||
}
|
||
}
|
||
return false; // 该时间段可用
|
||
}
|
||
|
||
function getBookingDetailsForDate(date) {
|
||
// 获取指定日期的所有预约详情
|
||
const bookings = bookingsByDate[date] || [];
|
||
let details = '';
|
||
|
||
if (bookings.length === 0) {
|
||
return '<p>该日期暂无预约</p>';
|
||
}
|
||
|
||
details += `<h4>当日预约情况 (共${bookings.length}个预约):</h4>`;
|
||
bookings.forEach((booking, index) => {
|
||
// 处理跨天预约的显示
|
||
let displayStartTime = booking.start_time;
|
||
let displayEndTime = booking.end_time;
|
||
let crossDayLabel = '';
|
||
|
||
if (booking.is_cross_day) {
|
||
// 对于跨天预约的第二天记录，显示为从00:00开始
|
||
displayStartTime = '00:00';
|
||
crossDayLabel = ' <small style="color: #ff6b6b;">(跨天预约延续)</small>';
|
||
}
|
||
|
||
details += `
|
||
<div class="booking-detail-item">
|
||
<div class="booking-time">${displayStartTime} - ${displayEndTime}${crossDayLabel}</div>
|
||
<div class="booking-info">
|
||
<strong>客户:</strong> ${booking.customer_name} |
|
||
<strong>车辆:</strong> ${booking.car_model} (${booking.car_number}) |
|
||
<strong>状态:</strong> <span class="status-${booking.status}">${booking.status}</span>
|
||
</div>
|
||
</div>
|
||
`;
|
||
});
|
||
|
||
return details;
|
||
}
|
||
|
||
function selectTimeSlot(time) {
|
||
selectedTime = time;
|
||
document.getElementById('appointment_time').value = time;
|
||
|
||
// 更新时间段选中状态
|
||
document.querySelectorAll('.time-slot').forEach(slot => {
|
||
slot.classList.remove('selected');
|
||
});
|
||
|
||
// 使用data-time属性查找元素，与pending_bookings.php保持一致
|
||
const slotElement = document.querySelector(`[data-time="${time}"]`);
|
||
if (slotElement) {
|
||
slotElement.classList.add('selected');
|
||
}
|
||
|
||
updateSubmitButton();
|
||
}
|
||
|
||
function selectDuration(minutes) {
|
||
selectedDuration = minutes;
|
||
document.getElementById('duration').value = minutes;
|
||
|
||
// 更新时长按钮选中状态
|
||
document.querySelectorAll('.duration-btn').forEach(btn => {
|
||
btn.classList.remove('selected');
|
||
});
|
||
|
||
const btn = document.querySelector(`[onclick="selectDuration(${minutes})"]`);
|
||
if (btn) {
|
||
btn.classList.add('selected');
|
||
}
|
||
}
|
||
|
||
function applyCustomDuration() {
|
||
const customDuration = parseInt(document.getElementById('customDuration').value);
|
||
const maxDuration = 720; // 最大时长为12小时（720分钟）
|
||
if (customDuration < 30) {
|
||
alert('自定义时长不能少于30分钟');
|
||
} else if (customDuration > maxDuration) {
|
||
alert('自定义时长不能超过12小时');
|
||
} else {
|
||
selectDuration(customDuration);
|
||
}
|
||
}
|
||
|
||
function updatePackageInfo() {
|
||
const packageSelect = document.getElementById('package_id');
|
||
const selectedOption = packageSelect.options[packageSelect.selectedIndex];
|
||
const packageInfoDiv = document.getElementById('packageInfo');
|
||
|
||
if (selectedOption && selectedOption.value) {
|
||
const packageId = parseInt(selectedOption.value);
|
||
const package = packages.find(p => p.id === packageId);
|
||
|
||
if (package) {
|
||
// 更新套餐信息显示
|
||
document.getElementById('packageName').textContent = package.package_name;
|
||
document.getElementById('packageDescription').textContent = package.description;
|
||
document.getElementById('packageDuration').textContent = `基础时长: ${package.base_duration}分钟`;
|
||
document.getElementById('packagePrice').textContent = `套餐价格: ￥${package.price}`;
|
||
|
||
// 显示服务项目
|
||
const servicesContainer = document.getElementById('packageServices');
|
||
if (package.services && package.services.length > 0) {
|
||
servicesContainer.innerHTML = '<strong>包含服务:</strong><br>' +
|
||
package.services.map(service => `• ${service}`).join('<br>');
|
||
}
|
||
|
||
packageInfoDiv.style.display = 'block';
|
||
|
||
// 自动设置基础时长
|
||
document.getElementById('duration').value = package.base_duration;
|
||
selectDuration(package.base_duration);
|
||
|
||
// 设置价格输入字段的值为套餐价格
|
||
document.getElementById('package_price').value = package.price;
|
||
document.getElementById('total_price').value = package.price;
|
||
|
||
console.log('已设置价格:', package.price);
|
||
}
|
||
} else {
|
||
packageInfoDiv.style.display = 'none';
|
||
document.getElementById('package_price').value = 0;
|
||
document.getElementById('total_price').value = 0;
|
||
}
|
||
|
||
updateSubmitButton();
|
||
}
|
||
|
||
function updateSubmitButton() {
|
||
const submitBtn = document.getElementById('submitBtn');
|
||
const customerType = document.getElementById('customer_type').value;
|
||
|
||
// 根据客户类型进行不同的验证
|
||
let isFormValid;
|
||
|
||
if (customerType === 'vip') {
|
||
// VIP模式：验证VIP选择和其他必要字段，但不验证新客户字段
|
||
isFormValid = selectedDate && selectedTime &&
|
||
document.getElementById('vip_id').value &&
|
||
document.getElementById('car_model').value &&
|
||
document.getElementById('car_number').value &&
|
||
document.getElementById('package_id').value &&
|
||
document.getElementById('total_price').value;
|
||
} else {
|
||
// 新客户模式：验证所有必填字段
|
||
isFormValid = selectedDate && selectedTime &&
|
||
document.getElementById('customer_name').value &&
|
||
document.getElementById('phone').value &&
|
||
document.getElementById('car_model').value &&
|
||
document.getElementById('car_number').value &&
|
||
document.getElementById('package_id').value &&
|
||
document.getElementById('total_price').value;
|
||
}
|
||
|
||
submitBtn.disabled = !isFormValid;
|
||
console.log('更新提交按钮状态:', isFormValid ? '可点击' : '禁用');
|
||
}
|
||
|
||
function resetForm() {
|
||
selectedDate = null;
|
||
selectedTime = null;
|
||
selectedDuration = 60;
|
||
document.getElementById('appointment_date').value = '';
|
||
document.getElementById('appointment_time').value = '';
|
||
document.getElementById('duration').value = 60;
|
||
document.getElementById('packageInfo').style.display = 'none';
|
||
document.getElementById('timeSlots').style.display = 'none';
|
||
|
||
// 重置所有选中状态
|
||
document.querySelectorAll('.calendar-day').forEach(day => {
|
||
day.classList.remove('selected');
|
||
});
|
||
document.querySelectorAll('.time-slot').forEach(slot => {
|
||
slot.classList.remove('selected');
|
||
});
|
||
document.querySelectorAll('.duration-btn').forEach(btn => {
|
||
btn.classList.remove('selected');
|
||
});
|
||
}
|
||
|
||
// 表单验证
|
||
document.getElementById('bookingForm').addEventListener('input', updateSubmitButton);
|
||
|
||
// 触摸反馈效果
|
||
document.addEventListener('touchstart', function(e) {
|
||
if (e.target.classList.contains('btn') || e.target.classList.contains('time-slot')) {
|
||
e.target.style.transform = 'scale(0.95)';
|
||
}
|
||
});
|
||
|
||
document.addEventListener('touchend', function(e) {
|
||
if (e.target.classList.contains('btn') || e.target.classList.contains('time-slot')) {
|
||
setTimeout(() => {
|
||
e.target.style.transform = 'scale(1)';
|
||
}, 150);
|
||
}
|
||
});
|
||
|
||
// 防止双击缩放（iOS Safari）
|
||
let lastTouchEnd = 0;
|
||
document.addEventListener('touchend', function(event) {
|
||
const now = (new Date()).getTime();
|
||
if (now - lastTouchEnd <= 300) {
|
||
event.preventDefault();
|
||
}
|
||
lastTouchEnd = now;
|
||
}, false);
|
||
</script>
|
||
</body>
|
||
</html>
|