0) { // Redirect to the edit product page header("Location: edit_product.php?id=" . $id . "&Keys=" . $keys . "&Page=" . $page . ($category_id ? "&category_id=" . $category_id : "")); exit(); } } // Handle bulk actions if ($act == 'postchk') { if (isset($_POST['chkbox']) && isset($_POST['chkact'])) { $chk_ids = array_map('intval', $_POST['chkbox']); $chk_act = (int)$_POST['chkact']; if (!empty($chk_ids)) { $ids_str = implode(',', $chk_ids); switch ($chk_act) { case 0: case 1: $sql = "UPDATE customer SET cs_state = " . $chk_act . " WHERE id IN (" . $ids_str . ")"; break; case -1: $sql = "DELETE FROM products WHERE id IN (" . $ids_str . ")"; break; } if (isset($sql)) { mysqli_query($conn, $sql); } } header("Location: ?Keys=" . $keys . "&Page=" . $page . ($category_id ? "&category_id=" . $category_id : "")); exit(); } } ?> 产品信息管理
0) { // Get all subcategories of the selected category $category_data = buildCategoryTree($conn); $all_categories = $category_data['all_categories']; $category_ids = array($filter_category_id); getSubcategoryIds($all_categories, $filter_category_id, $category_ids); $category_condition = " WHERE category_id IN (" . implode(',', $category_ids) . ")"; } // Search condition $search_condition = ''; if (!empty($keyscode)) { $search_condition = ($category_condition ? " AND " : " WHERE ") . "ProductName LIKE '%" . mysqli_real_escape_string($conn, $keyscode) . "%'"; } // Get total records count using a COUNT query instead of fetching all records $count_sql = "SELECT COUNT(*) as total FROM products" . $category_condition . $search_condition; $count_result = mysqli_query($conn, $count_sql); $count_row = mysqli_fetch_assoc($count_result); $total_records = $count_row['total']; // 固定每页显示18条记录(与 customers.php 保持一致) $pageSize = 18; $total_pages = ceil($total_records / $pageSize); if ($total_pages < 1) $total_pages = 1; // 确保至少有一页,即使没有结果 // Validate page number if (empty($page)) $page = 1; if ($page == 'end') $page = $total_pages; if (!is_numeric($page) || $page < 1) $page = 1; $page = (int)$page; if ($page > $total_pages) $page = $total_pages; // Apply pagination $offset = ($page - 1) * $pageSize; if ($offset < 0) $offset = 0; // 确保偏移量不为负数 // Fetch only the records for the current page $sql = "SELECT id, ProductName, ProductImg, category_id FROM products" . $category_condition . $search_condition . " ORDER BY id DESC LIMIT $offset, $pageSize"; $result = mysqli_query($conn, $sql); $temp_num = $pageSize * ($page - 1); ?>
0) { $temp_num = $pageSize * ($page - 1); while ($row = mysqli_fetch_assoc($result)) { $temp_num++; ?>
序号 产品名称 产品分类 图片 返点规则数量 操作
0) $rebate_sql = "SELECT COUNT(*) as rebate_count FROM rebate_rules WHERE product_id = " . $row['id'] . " AND rebate_amount > 0"; $rebate_result = mysqli_query($conn, $rebate_sql); $rebate_row = mysqli_fetch_assoc($rebate_result); echo $rebate_row['rebate_count']; ?> 修改
Sorry,没有找到"' . htmlspecialcharsFix($keyscode) . '"相关的信息,点击返回'; ?>
1) { // Build page URL with all parameters $page_params = array(); if (!empty($keys)) $page_params[] = "Keys=" . urlencode($keys); if ($filter_category_id > 0) $page_params[] = "category_id=" . $filter_category_id; $page_name = "?" . implode("&", $page_params) . ($page_params ? "&" : ""); $page_len = 3; // Previous page links if ($page > 1) { echo "首页"; echo "上一页"; } // Calculate page range if ($page_len * 2 + 1 >= $total_pages) { $start_page = 1; $end_page = $total_pages; } else { if ($page <= $page_len + 1) { $start_page = 1; $end_page = $page_len * 2 + 1; } else { $start_page = $page - $page_len; $end_page = $page + $page_len; } if ($page + $page_len > $total_pages) { $start_page = $total_pages - $page_len * 2; $end_page = $total_pages; } } // Page numbers for ($i = $start_page; $i <= $end_page; $i++) { if ($i == $page) { echo "$i"; } else { echo "$i"; } } // Next page links if ($page < $total_pages) { if ($total_pages - $page > $page_len) { echo "...$total_pages"; } echo "下一页"; echo "尾页"; } // Jump to page input echo ""; } ?>