= '" . mysqli_real_escape_string($conn, $fliterFromDate) . "'"; $urlStr .= "&fliterFromDate=" . urlencode($fliterFromDate); } if (!empty($fliterToDate)) { $fliterStr .= " AND o.order_date <= '" . mysqli_real_escape_string($conn, $fliterToDate) . " 23:59:59'"; $urlStr .= "&fliterToDate=" . urlencode($fliterToDate); } // 搜索和排序 $keys = $_GET['Keys'] ?? ''; $keyscode = mysqli_real_escape_string($conn, $keys); $page = $_GET['Page'] ?? 1; $ord = $_GET['Ord'] ?? ''; $ordStr = !empty($ord) ? "$ord," : ""; // 构建查询SQL $employee_id = $_SESSION['employee_id']; $sqlStr = "SELECT o.*, c.cs_company, cc.contact_name FROM orders o LEFT JOIN customer c ON o.customer_id = c.id LEFT JOIN customer_contact cc ON o.contact_id = cc.id WHERE o.employee_id = $employee_id"; if (!empty($keyscode)) { $sqlStr .= " AND (o.order_code LIKE '%$keyscode%' OR c.cs_company LIKE '%$keyscode%' OR cc.contact_name LIKE '%$keyscode%')"; } $sqlStr .= " $fliterStr ORDER BY {$ordStr}o.created_at DESC"; ?> 订单列表

筛选条件

$totalPages) $page = $totalPages; // 计算起始记录 $offset = ($page - 1) * $pageSize; // 添加分页条件 $sqlStr .= " LIMIT $offset, $pageSize"; $result = mysqli_query($conn, $sqlStr); if (mysqli_num_rows($result) > 0) { $tempNum = ($page - 1) * $pageSize; while ($row = mysqli_fetch_assoc($result)) { $tempNum++; ?> '; } else { echo ''; } } ?>
序号 订单编号 客户 联系人 订单日期 订单状态 付款状态 订单金额 操作
'已取消', 1 => '待确认', 2 => '已确认', 3 => '生产中', 4 => '已发货', 5 => '已完成' ]; echo '' . $statusMap[$row['order_status']] . ''; ?> '未付款', 1 => '部分付款', 2 => '已付清' ]; echo '' . $paymentMap[$row['payment_status']] . ''; ?> 修改 查看详情
当前暂无订单记录
没有找到匹配的订单记录，点击返回