igamebox
/
mtb_crm_asp


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368
							<?php
require_once('conn.php');

// Check login status (assuming you have a similar function in PHP)
checkLogin("信息管理");

// Initialize all variables to avoid undefined warnings
$act = isset($_GET['act']) ? $_GET['act'] : '';
$page = isset($_GET['Page']) ? $_GET['Page'] : 1;
$keys = isset($_GET['Keys']) ? urlencode($_GET['Keys']) : '';
$keyscode = isset($_GET['Keys']) ? htmlspecialcharsFix($_GET['Keys']) : '';
$category_id = isset($_GET['category_id']) ? intval($_GET['category_id']) : 0;

// Handle form submissions and redirects before any output
if ($act == 'add') {
    // Redirect to the add product page
    header("Location: add_product.php?Keys=" . $keys . "&Page=" . $page . ($category_id ? "&category_id=" . $category_id : ""));
    exit();
} else if ($act == 'edit') {
    $id = isset($_GET['id']) ? (int)$_GET['id'] : 0;
    if ($id > 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();
    }
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>产品信息管理</title>
<link rel="stylesheet" href="css/common.css" type="text/css" />
<script language="javascript" src="js/jquery-1.7.2.min.js"></script>
<script type="text/javascript" src="js/js.js"></script>
<script type="text/javascript" src="js/SearchArea.js"></script>
<script type="text/javascript" src="xheditor-1.1.9/xheditor-1.1.9-zh-cn.min.js"></script>
<style>
    .add_btn {
        background-color: #5cb85c;
        color: white;
        padding: 6px 15px;
        border: none;
        border-radius: 3px;
        cursor: pointer;
        font-weight: bold;
    }
    .add_btn:hover {
        background-color: #449d44;
    }
    .search_panel {
        padding: 15px;
        border-radius: 4px;
        border: 1px solid #ddd;
        margin-bottom: 20px;
    }
    .search_panel label {
        font-weight: bold;
        margin-right: 5px;
    }
    .search_panel .inputTxt {
        width: 200px;
        padding: 5px;
        border: 1px solid #ccc;
        border-radius: 3px;
    }
    .search_panel .searchgo {
        padding: 5px 15px;
        background-color: #337ab7;
        color: white;
        border: none;
        border-radius: 3px;
        cursor: pointer;
    }
    .search_panel .searchgo:hover {
        background-color: #286090;
    }
    .select1 {
        padding: 5px;
        border: 1px solid #ccc;
        border-radius: 3px;
        min-width: 200px;
    }
</style>
</head>

<body>
<div id="man_zone">
<?php
// Display product list
require_once 'functions.php';

// Get filter category id
$filter_category_id = $category_id;

// Prepare SQL condition for category filtering
$category_condition = '';
if ($filter_category_id > 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);
?>
<div class="search_panel">
    <form method="get" action="">
        <input type="hidden" name="Page" value="1">
        <div style="display: flex; margin-bottom: 10px;style="margin-left: 20px;"">
        <div style="margin-right: 20px;">
            <input type="button" value="+ 新增产品" onClick="location.href='?act=add<?php echo $filter_category_id ? '&category_id='.$filter_category_id : ''; ?>'" class="add_btn" />
        </div>
            <div style="margin-right: 20px;">
                <label>按分类筛选:</label>
                <select name="category_id" class="select1" onchange="this.form.submit()">
                    <option value="0">-- 所有分类 --</option>
                    <?php
                    // Build category tree for filter dropdown
                    $category_data = buildCategoryTree($conn);
                    $cat_tree = $category_data['tree'];
                    
                    // Output options
                    outputCategoryOptions($cat_tree, $filter_category_id);
                    ?>
                </select>
            </div>
            <div>
                <label>关键词搜索:</label>
                <input type="text" name="Keys" value="<?php echo $keyscode; ?>" class="inputTxt" placeholder="请输入产品名称">
                <input type="submit" value="搜索" class="searchgo">
            </div>

        </div>
    </form>
</div>

<form id="form1" method="post" action="?act=postchk&Keys=<?php echo $keys; ?>&Page=<?php echo $page; ?><?php echo $filter_category_id ? '&category_id='.$filter_category_id : ''; ?>">
    <table width="100%" border="0" cellpadding="3" cellspacing="1" class="table1">
        <thead>
            <tr>
                <th width="4%"><input type="checkbox" name="chkall" id="chkall" onClick="chkboxall(this,'chkbox')" /></th>
                <th width="6%">序号</th>
                <th width="25%">产品名称</th>
                <th width="15%">产品分类</th>
                <th width="30%">图片</th>
                <th width="10%">规格数量</th>
                <th width="20%">操作</th>
            </tr>
        </thead>
        <tbody>
        <?php
        if (mysqli_num_rows($result) > 0) {
            $temp_num = $pageSize * ($page - 1);
            while ($row = mysqli_fetch_assoc($result)) {
                $temp_num++;
                ?>
                <tr onMouseOver="this.style.background='#F7FCFF'" onMouseOut="this.style.background='#FFFFFF'">
                    <td align="center"><input type="checkbox" name="chkbox[]" value="<?php echo $row['id']; ?>" /></td>
                    <td align="center"><?php echo $temp_num; ?></td>
                    <td align="center"><?php echo htmlspecialcharsFix($row['ProductName']); ?></td>
                    <td align="center">
                        <?php 
                        require_once 'functions.php';
                        echo getCategoryPath($conn, $row['category_id']); 
                        ?>
                    </td>
                    <td align="center"><img src="<?php echo htmlspecialcharsFix($row['ProductImg']); ?>" width="30px"></td>
                    <td align="center">
                        <?php 
                        // Count specifications for this product
                        $spec_sql = "SELECT COUNT(*) as spec_count FROM product_specifications WHERE product_id = " . $row['id'];
                        $spec_result = mysqli_query($conn, $spec_sql);
                        $spec_row = mysqli_fetch_assoc($spec_result);
                        echo $spec_row['spec_count']; 
                        ?>
                    </td>
                    <td align="center">
                        <a href="?Keys=<?php echo $keys; ?>&Page=<?php echo $page; ?>&act=edit&id=<?php echo $row['id']; ?><?php echo $filter_category_id ? '&category_id='.$filter_category_id : ''; ?>" class="ico_edit ico">修改</a>
                    </td>
                </tr>
                <?php
            }
        } else {
            ?>
            <tr>
                <td colspan="9" align="center">
                    <?php echo empty($keys) ? 'Sorry，当前暂无信息' : '<a href="?">Sorry，没有找到"' . htmlspecialcharsFix($keyscode) . '"相关的信息，点击返回</a>'; ?>
                </td>
            </tr>
            <?php
        }
        ?>
        </tbody>
        <tfoot>
            <tr>
                <td colspan="9">
                    <div class="showpagebox">
                    <?php
                    if ($total_pages > 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 "<a href=\"{$page_name}Page=1\">首页</a>";
                            echo "<a href=\"{$page_name}Page=" . ($page-1) . "\">上一页</a>";
                        }
                        
                        // 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 "<a class=\"current\">$i</a>";
                            } else {
                                echo "<a href=\"{$page_name}Page=$i\">$i</a>";
                            }
                        }
                        
                        // Next page links
                        if ($page < $total_pages) {
                            if ($total_pages - $page > $page_len) {
                                echo "<a href=\"{$page_name}Page=$total_pages\">...$total_pages</a>";
                            }
                            echo "<a href=\"{$page_name}Page=" . ($page+1) . "\">下一页</a>";
                            echo "<a href=\"{$page_name}Page=$total_pages\">尾页</a>";
                        }
                        
                        // Jump to page input
                        echo "<input type=\"text\" id=\"Pagego\" value=\"$page\" 
                              onFocus=\"if(this.value == '$page'){this.value='';}\" 
                              onBlur=\"if(this.value == ''){this.value='$page';}\" 
                              onKeyUp=\"this.value=this.value.replace(/\D/g,'')\" 
                              onKeyDown=\"if(event.keyCode==13){location.href='{$page_name}Page='+document.getElementById('Pagego').value}\" />";
                    }
                    ?>
                    </div>
                    
                    <div class="postchkbox">
                        <select id="chkact" name="chkact">

                            <option value="-1">删除</option>
                        </select>
                        <input type="button" value="执行" onClick="postchk_products(1)" class="btn1" />
                        <input type="button" value="新增" onClick="location.href='?act=add<?php echo $filter_category_id ? '&category_id='.$filter_category_id : ''; ?>'" class="btn1" />
                    </div>
                </td>
            </tr>
        </tfoot>
    </table>
</form>
</div>
<script type="application/javascript">

    function postchk_products(formBtn) {
        // Check if at least one checkbox is selected
        var checkboxes = document.getElementsByName('chkbox[]');
        var isChecked = false;

        for (var i = 0; i < checkboxes.length; i++) {
            if (checkboxes[i].checked) {
                isChecked = true;
                break;
            }
        }

        if (!isChecked) {
            alert('请至少选择一条数据');
            return false;
        }

        // If at least one checkbox is selected, submit the form
        document.getElementById('form1').submit();
        return true;
    }
</script>
</body>
</html>
<?php mysqli_close($conn); ?>