搜索条件

3 AND c.cs_deal<>0 AND c.cs_type<>2 AND c.cs_belong<>13 AND c.cs_belong<>" . $_SESSION['employee_id'] . " AND DATEDIFF(NOW(), c.cs_updatetime) > 120 AND c.cs_country NOT IN (2, 229, 13, 153) AND c.cs_belongclient=0 AND cc.wechat NOT LIKE 'wxid%' AND (c.cs_code LIKE '%" . $conn->real_escape_string($keyscode) . "%' OR cc.contact_name LIKE '%" . $conn->real_escape_string($keyscode) . "%' OR cc.email LIKE '%" . $conn->real_escape_string($keyscode) . "%' OR cc.wechat LIKE '%" . $conn->real_escape_string($keyscode) . "%' OR cc.tel LIKE '%" . $conn->real_escape_string($keyscode) . "%' OR cc.whatsapp LIKE '%" . $conn->real_escape_string($keyscode) . "%')" . $filterStr . " ORDER BY c.cs_state DESC, c.id DESC"; $result = $conn->query($sql); if ($result && $result->num_rows > 0) { $pageSize = 20; $page = empty($page) ? 1 : $page; $page = ($page === 'end') ? ceil($result->num_rows / $pageSize) : $page; $page = (!is_numeric($page) || $page < 1) ? 1 : (int)$page; $totalPages = ceil($result->num_rows / $pageSize); $page = ($page > $totalPages) ? $totalPages : $page; $offset = $pageSize * ($page - 1); // Store results in array for pagination $rows = []; while ($row = $result->fetch_assoc()) { $rows[] = $row; } // Get paginated results $paginatedRows = array_slice($rows, $offset, $pageSize); $tempNum = $offset; foreach ($paginatedRows as $row) { $tempNum++; ?>