igamebox
/
mtb_crm_asp


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416
							<?php
include "conn.php";
checkLogin("信息管理");
?>
<!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>
</head>

<body>
<div id="man_zone">
<?php
$act = $_GET['act'] ?? '';
$productName = textEncode($_POST['ProductName'] ?? '');
$productImg = textEncode($_POST['ProductImg'] ?? '');
$unit = textEncode($_POST['unit'] ?? '');
$moq = textEncode($_POST['moq'] ?? '');
$nosale = $_POST['nosale'] ?? '';
$num = $_POST['num'] ?? '';
$price = $_POST['price'] ?? '';
$note = textEncode($_POST['note'] ?? '');
$tips = textEncode($_POST['tips'] ?? '');

if ($act == "save") {
    $isedit = false;
    $id = $_POST['id'] ?? '';
    if ($id != "" && is_numeric($id)) {
        $isedit = true;
    }

    if ($isedit) {
        $sql = "Select * From Products Where id=" . $id;
        $rs = $conn->query($sql);
        if ($row = $rs->fetch()) {
            $sql = "Update Products Set 
                    ProductName='" . $productName . "',
                    ProductImg='" . $productImg . "',
                    Addtime=NOW(),
                    moq='" . $moq . "',
                    unit='" . $unit . "',
                    nosale='" . $nosale . "',
                    note='" . $note . "',
                    tips='" . $tips . "'
                    Where id=" . $id;
            $conn->query($sql);
            
            $conn->query("delete from price where productId=" . $id . " and AreaId=0");
            
            $numarr = explode(",", $num);
            $pricearr = explode(",", $price);
            
            for ($i = 0; $i < count($numarr); $i++) {
                if ($numarr[$i] == "") $numarr[$i] = 0;
                if ($pricearr[$i] == "") $pricearr[$i] = 0;
                $conn->query("insert into price (productId,AreaId,num,price) values(" . $id . ",0," . $numarr[$i] . ",'" . $pricearr[$i] . "')");
            }
        }
    } else {
        $sql = "Insert Into Products(ProductName,ProductImg,Addtime,unit,moq,nosale,note,tips) values(
                '" . $productName . "',
                '" . $productImg . "',
                NOW(),
                '" . $unit . "',
                '" . $moq . "',
                '" . $nosale . "',
                '" . $note . "',
                '" . $tips . "'
                )";
        $conn->query($sql);
        
        $sql = "select top 1 id from Products order by id desc";
        $rs = $conn->query($sql);
        $id = $rs->fetch()['id'];
        
        $numarr = explode(",", $num);
        $pricearr = explode(",", $price);
        
        for ($i = 0; $i < count($numarr); $i++) {
            if ($numarr[$i] == "") $numarr[$i] = 0;
            if ($pricearr[$i] == "") $pricearr[$i] = 0;
            $conn->query("insert into price (productId,AreaId,num,price) values(" . $id . ",0," . $numarr[$i] . ",'" . $pricearr[$i] . "')");
        }
    }

    $page = $_GET['Page'] ?? '';
    $keys = urlencode($_GET['Keys'] ?? '');
    header("Location: ?keys=" . $keys . "&Page=" . $page . $urlStr);
    exit;
}

if ($act == "add" || $act == "edit") {
    $id = $_GET['id'] ?? '';
    $isedit = false;
    if ($id != "" && is_numeric($id)) {
        $isedit = true;
        $sql = "Select ProductName,ProductImg,unit,moq,nosale,note,tips from Products Where id=" . $id;
        $rs = $conn->query($sql);
        if ($row = $rs->fetch()) {
            $productName = textUncode($row['ProductName']);
            $productImg = textUncode($row['ProductImg']);
            $unit = $row['unit'];
            $moq = textUncode($row['moq']);
            $nosale = $row['nosale'];
            $note = textUncode($row['note']);
            $tips = textUncode($row['tips']);
        } else {
            $isedit = false;
        }
    }

    $page = $_GET['Page'] ?? '';
    $keys = urlencode($_GET['Keys'] ?? '');
    $hrefstr = "?keys=" . $keys . "&Page=" . $page;
?>
    <form name="form1" method="post" action="<?php echo $hrefstr; ?>&act=save">
    <table width="100%" border="0" cellpadding="3" cellspacing="1" class="table1">
        <tbody>
            <tr>
                <th width="8%">产品名称</th>
                <td><input type="text" id="ProductName" name="ProductName" value="<?php echo $productName; ?>" class="txt1" />
                    <input type="hidden" name="id" value="<?php echo $id; ?>" /></td>
            </tr>
            <tr>
                <th width="8%">产品图片</th>
                <td><input type="text" id="ProductImg" name="ProductImg" placeholder="186x*186px" value="<?php echo $productImg; ?>" class="txt1" style="width:390px;float:left;" />
                    <iframe src="uploadfile.php" frameborder="0" scrolling="no" style="width:400px;height:22px;float:left;margin-left:10px;"></iframe></td>
            </tr>
            <tr>
                <th width="8%">计价单位</th>
                <td><input type="text" id="unit" name="unit" value="<?php echo $unit; ?>" class="txt1"/></td>
            </tr>
            <tr>
                <th width="8%">起订数量</th>
                <td><input type="text" id="moq" name="moq" value="<?php echo $moq; ?>" class="txt1"/></td>
            </tr>
            <tr>
                <th width="8%">默认售价</th>
                <td>
                    <div class="Price">
                    <?php 
                    if ($isedit) {
                        $rs = $conn->query("Select num,price from price where AreaId=0 and productId=" . $id . " order by num asc");
                        if ($rs->rowCount() > 0) {
                            while ($row = $rs->fetch()) {
                    ?>
                        <div class="priceitem">
                            <label>≥</label>
                            <input type="number" class="txt3 num" name="num" value="<?php echo $row['num']; ?>">
                            <label class="unit"><?php echo $unit; ?></label>
                            <label>售价</label>
                            <input type="text" class="txt3 price" name="price" value="<?php echo $row['price']; ?>">
                            <label>RMB</label>
                            <span class="additem"></span>
                            <span class="delitem"></span>
                            <span class="note"></span>
                        </div>
                    <?php
                            }
                        } else {
                    ?>
                        <div class="priceitem">
                            <label>≥</label>
                            <input type="number" class="txt3 num" name="num">
                            <label class="unit"><?php echo $unit; ?></label>
                            <label>售价</label>
                            <input type="text" class="txt3 price" name="price">
                            <label>RMB</label>
                            <span class="additem"></span>
                            <span class="delitem"></span>
                            <span class="note"></span>
                        </div>
                    <?php
                        }
                    } else {
                    ?>
                        <div class="priceitem">
                            <label>≥</label>
                            <input type="number" class="txt3 num" name="num">
                            <label class="unit"><?php echo $unit; ?></label>
                            <label>售价</label>
                            <input type="text" class="txt3 price" name="price">
                            <label>RMB</label>
                            <span class="additem"></span>
                            <span class="delitem"></span>
                            <span class="note"></span>
                        </div>
                    <?php
                    }
                    ?>
                    </div>
                </td>
            </tr>
            <tr>
                <th width="8%">不报价地区</th>
                <td>
                    <ul class="areadd">
                    <?php
                    if ($nosale != "") {
                        $rs = $conn->query("select id,countryName from country where id in(" . $nosale . ")");
                        while ($row = $rs->fetch()) {
                    ?>
                        <li>
                            <input type="hidden" name="nosale" value="<?php echo $row['id']; ?>">
                            <span class="cname"><?php echo $row['countryName']; ?></span>
                            <span class="close"></span>
                        </li>
                    <?php
                        }
                    }
                    ?>
                    </ul>
                    <input type="text" id="AreaSearch" class="fastsearch">
                    <div id="arealist" class="productlist"><ul></ul></div>
                </td>
            </tr>
            <tr>
                <th width="8%">不报价处理方式</th>
                <td><input type="text" id="note" name="note" value="<?php echo $note; ?>" class="txt1"/></td>
            </tr>
            <tr>
                <th width="8%">备注</th>
                <td><input type="text" id="tips" name="tips" value="<?php echo $tips; ?>" class="txt1"/></td>
            </tr>
            <tr>
                <th></th>
                <td>
                    <input type="submit" name="save" value="确定" class="btn1" />
                    <input type="reset" name="reset" value="重置" class="btn1" />
                    <input type="button" value="返回" class="btn1" onClick="location.href='<?php echo $hrefstr; ?>'" />
                </td>
            </tr>
        </tbody>
    </table>
    </form>
<?php
    exit;
}

if ($act == "postchk") {
    $keys = urlencode($_GET['Keys'] ?? '');
    $page = $_GET['Page'] ?? '';
    $chkact = $_POST['chkact'] ?? '';
    $sqlStr = "";
    
    if (isset($_POST['chkbox'])) {
        foreach ($_POST['chkbox'] as $value) {
            if ($sqlStr != "") {
                $sqlStr .= " Or id=" . $value;
            } else {
                $sqlStr = " Where id=" . $value;
            }
        }

        switch ($chkact) {
            case "0":
                $sqlStr = "Update Products Set cs_state=" . $chkact . $sqlStr;
                break;
            case "1":
                $sqlStr = "Update Products Set cs_state=" . $chkact . $sqlStr;
                break;
            default:
                $sqlStr = "Delete From Products" . $sqlStr;
        }

        $conn->query($sqlStr);
    }
    
    header("Location: ?Keys=" . $keys . "&Page=" . $page);
    exit;
}

// 主列表页面
$keyscode = textEncode($_GET['Keys'] ?? '');
$page = $_GET['Page'] ?? '';

$sqlStr = "Select id,ProductName,ProductImg from Products order by id Desc";
$rs = $conn->query($sqlStr);
?>
<form id="form1" method="post" action="?act=postchk&Keys=<?php echo urlencode($_GET['Keys'] ?? ''); ?>&Page=<?php echo $page; ?>" onSubmit="return false">
<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="30%">产品名称</th>
            <th width="40%">图片</th>
            <th width="20%">操作</th>
        </tr>
    </thead>
    <tbody>
    <?php
    if ($rs->rowCount() > 0) {
        $rs->setFetchMode(PDO::FETCH_ASSOC);
        $records_per_page = 18;
        
        if ($page == "") $page = 1;
        if ($page == "end") $page = ceil($rs->rowCount() / $records_per_page);
        if (!is_numeric($page) || $page < 1) $page = 1;
        $page = (int)$page;
        
        $start = ($page - 1) * $records_per_page;
        $tempNum = $start;
        
        $count = 0;
        while ($row = $rs->fetch()) {
            $count++;
            if ($count > $start && $count <= $start + $records_per_page) {
                $tempNum++;
    ?>
            <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 $tempNum; ?></td>
                <td align="center"><?php echo $row['ProductName']; ?></td>
                <td align="center"><img src="<?php echo $row['ProductImg']; ?>" width="80px"></td>
                <td align="center">
                    <a href="?Keys=<?php echo urlencode($_GET['Keys'] ?? ''); ?>&Page=<?php echo $page; ?><?php echo $urlStr ?? ''; ?>&act=edit&id=<?php echo $row['id']; ?>" class="ico_edit ico">修改</a>
                </td>
            </tr>
    <?php
            }
        }
    } else {
        if ($_GET['Keys'] ?? '' == "") {
    ?>
            <tr>
                <td align="center" colspan="9">Sorry，当前暂无信息</td>
            </tr>
    <?php
        } else {
    ?>
            <tr>
                <td align="center" colspan="9"><a href="?">Sorry，没有找到"<?php echo $keyscode; ?>"相关的信息，点击返回</a></td>
            </tr>
    <?php
        }
    }
    ?>
    </tbody>
    <tfoot>
        <tr>
            <td colspan="9">
                <div class="showpagebox">
                <?php
                if ($rs->rowCount() > 0) {
                    $total_pages = ceil($rs->rowCount() / $records_per_page);
                    if ($total_pages > 1) {
                        $pageName = "?Keys=" . urlencode($_GET['Keys'] ?? '') . ($urlStr ?? '') . "&";
                        $pagelen = 3;

                        if ($page > 1) {
                            echo "<a href=\"{$pageName}Page=1\">首页</a>";
                            echo "<a href=\"{$pageName}Page=" . ($page-1) . "\">上一页</a>";
                        }

                        if ($pagelen * 2 + 1 >= $total_pages) {
                            $startPage = 1;
                            $endPage = $total_pages;
                        } else {
                            if ($page <= $pagelen + 1) {
                                $startPage = 1;
                                $endPage = $pagelen * 2 + 1;
                            } else {
                                $startPage = $page - $pagelen;
                                $endPage = $page + $pagelen;
                            }
                            if ($page + $pagelen > $total_pages) {
                                $startPage = $total_pages - $pagelen * 2;
                                $endPage = $total_pages;
                            }
                        }

                        for ($i = $startPage; $i <= $endPage; $i++) {
                            if ($i == $page) {
                                echo "<a class=\"current\">$i</a>";
                            } else {
                                echo "<a href=\"{$pageName}Page=$i\">$i</a>";
                            }
                        }

                        if ($page < $total_pages) {
                            if ($total_pages - $page > $pagelen) {
                                echo "<a href=\"{$pageName}Page=$total_pages\">...$total_pages</a>";
                            }
                            echo "<a href=\"{$pageName}Page=" . ($page+1) . "\">下一页</a>";
                            echo "<a href=\"{$pageName}Page=$total_pages\">尾页</a>";
                        }

                        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='{$pageName}Page='+document.getElementById('Pagego').value}\" />";
                    }
                }
                ?>
                </div>
                <div class="postchkbox">
                    <select id="chkact" name="chkact">
                        <option value="1">显示</option>
                        <option value="0">隐藏</option>
                        <option value="-1">删除</option>
                    </select>
                    <input type="button" value="执行" onClick="postchk(1)" class="btn1" />
                    <input type="button" value="新增" onClick="location.href='?act=add'" class="btn1" />
                </div>
            </td>
        </tr>
    </tfoot>
</table>
</form>
</div>
</body>
</html>