mtb_crm_asp/system/customers.php

<?php
require_once("conn.php");
include("checklogin.php"); 

// 辅助函数
function textEncode($str) {
    return htmlspecialchars($str, ENT_QUOTES, 'UTF-8');
}

function textDecode($str) {
    return htmlspecialchars_decode($str, ENT_QUOTES);
}

function htmlEncode($str) {
    return htmlspecialchars($str, ENT_QUOTES, 'UTF-8');
}

function htmlDecode($str) {
    return htmlspecialchars_decode($str, ENT_QUOTES);
}

$act = $_GET['act'] ?? '';
$urlStr = '';

// 处理保存操作
if ($act == "save") {
    $isedit = false;
    $id = $_POST['id'] ?? '';
    if (!empty($id) && is_numeric($id)) {
        $isedit = true;
    }
    
    // 获取表单数据
    $cs_code = textEncode($_POST['cs_code']);
    $cs_company = textEncode($_POST['cs_company']);
    $cs_name = textEncode($_POST['cs_name']);
    $cs_belong = $_POST['cs_belong'];
    $cs_country = $_POST['cs_country'];
    $cs_from = $_POST['cs_from'];
    $cs_tel = textEncode($_POST['cs_tel']);
    $cs_email = textEncode($_POST['cs_email']);
    $cs_whatsapp = textEncode($_POST['cs_whatsapp']);
    $cs_wechat = textEncode($_POST['cs_wechat']);
    $cs_linkedin = textEncode($_POST['cs_linkedin']);
    $cs_facebook = textEncode($_POST['cs_facebook']);
    $cs_alibaba = textEncode($_POST['cs_alibaba']);
    $cs_state = $_POST['cs_state'];
    $cs_deal = $_POST['cs_deal'];
    $no_content = htmlEncode($_POST['no_content']);
    $allowedit = isset($_POST['allowedit']) ? 1 : 0;

    if ($isedit) {
        // 更新现有记录
        $sql = "SELECT cs_chain FROM customer WHERE id = $id";
        $result = mysqli_query($conn, $sql);
        if ($row = mysqli_fetch_assoc($result)) {
            $cs_chain = $row['cs_chain'];
            $chain_array = explode(',', $cs_chain);
            $last_item = end($chain_array);
            
            if ($last_item != $cs_belong) {
                $cs_chain .= ",$cs_belong";
            }
            
            $sql = "UPDATE customer SET 
                    cs_code = '$cs_code',
                    cs_company = '$cs_company',
                    cs_name = '$cs_name',
                    cs_belong = '$cs_belong',
                    cs_country = '$cs_country',
                    cs_from = '$cs_from',
                    cs_tel = '$cs_tel',
                    cs_email = '$cs_email',
                    cs_whatsapp = '$cs_whatsapp',
                    cs_wechat = '$cs_wechat',
                    cs_linkedin = '$cs_linkedin',
                    cs_facebook = '$cs_facebook',
                    cs_alibaba = '$cs_alibaba',
                    cs_state = '$cs_state',
                    cs_deal = '$cs_deal',
                    cs_note = '$no_content',
                    allowedit = $allowedit,
                    cs_chain = '$cs_chain',
                    cs_updatetime = NOW()
                    WHERE id = $id";
                    
            mysqli_query($conn, $sql);
            
            $page = $_GET['Page'] ?? '';
            $keys = urlencode($_GET['Keys'] ?? '');
            header("Location: ?keys=$keys&Page=$page$urlStr");
            exit;
        }
    }
}

// 处理编辑操作
if ($act == "edit") {
    $id = $_GET['id'] ?? '';
    $isedit = false;
    if (!empty($id) && is_numeric($id)) {
        $isedit = true;
    }
    
    if ($isedit) {
        $sql = "SELECT c.*, n.c_code FROM customer c 
                LEFT JOIN myNote n ON c.cs_code = n.c_code 
                WHERE c.id = $id";
        $result = mysqli_query($conn, $sql);
        if ($row = mysqli_fetch_assoc($result)) {
            $cs_code = textDecode($row['cs_code']);
            $cs_company = textDecode($row['cs_company']);
            $cs_name = textDecode($row['cs_name']);
            $cs_country = $row['cs_country'];
            $cs_from = $row['cs_from'];
            $cs_tel = textDecode($row['cs_tel']);
            $cs_telBu = textDecode($row['cs_telBu']);
            $cs_email = textDecode($row['cs_email']);
            $cs_emailBu = textDecode($row['cs_emailBu']);
            $cs_whatsapp = textDecode($row['cs_whatsapp']);
            $cs_whatsappBu = textDecode($row['cs_whatsappBu']);
            $cs_wechat = textDecode($row['cs_wechat']);
            $cs_wechatBu = textDecode($row['cs_wechatBu']);
            $cs_linkedin = textDecode($row['cs_linkedin']);
            $cs_linkedinBu = textDecode($row['cs_linkedinBu']);
            $cs_facebook = textDecode($row['cs_facebook']);
            $cs_facebookBu = textDecode($row['cs_facebookBu']);
            $cs_alibaba = textDecode($row['cs_alibaba']);
            $cs_alibabaBu = textDecode($row['cs_alibabaBu']);
            $cs_address = textDecode($row['cs_address']);
            $cs_addtime = $row['cs_addtime'];
            $cs_updatetime = $row['cs_updatetime'];
            $cs_belong = $row['cs_belong'];
            $cs_state = $row['cs_state'];
            $cs_deal = $row['cs_deal'];
            $cs_note = htmlDecode($row['cs_note']);
            $allowedit = $row['allowedit'];
        }
    }
}

// 处理批量操作
if ($act == "postchk") {
    if (isset($_POST['chkbox']) && isset($_POST['chkact'])) {
        $chkact = $_POST['chkact'];
        $ids = implode(',', array_map('intval', $_POST['chkbox']));
        
        switch($chkact) {
            case "0":
            case "1":
                $sql = "UPDATE customer SET cs_state = $chkact WHERE id IN ($ids)";
                break;
            case "-1":
                $sql = "DELETE FROM customer WHERE id IN ($ids)";
                break;
        }
        
        if (isset($sql)) {
            mysqli_query($conn, $sql);
        }
        
        $keys = urlencode($_GET['Keys'] ?? '');
        $page = $_GET['Page'] ?? '';
        header("Location: ?keys=$keys&Page=$page$urlStr");
        exit;
    }
}

// ... (第一部分代码续)

// 处理筛选条件
$fliterQudao = $_GET['fliterQudao'] ?? '';
$fliterDeal = $_GET['fliterDeal'] ?? '';
$fliterTeam = $_GET['fliterTeam'] ?? '';
$fliterContact = $_GET['fliterContact'] ?? '';
$fliterEmployee = $_GET['fliterEmployee'] ?? '';

$fliterStr = "";

if (!empty($fliterQudao)) {
    $fliterStr .= " AND cs_from = " . intval($fliterQudao);
    $urlStr .= "&fliterQudao=" . $fliterQudao;
}

if (!empty($fliterDeal)) {
    $fliterStr .= " AND cs_deal = " . intval($fliterDeal);
    $urlStr .= "&fliterDeal=" . $fliterDeal;
}

if (!empty($fliterTeam)) {
    $fliterStr .= " AND (cs_belong = " . intval($fliterTeam) . 
                  " OR cs_belong IN (SELECT id FROM employee WHERE em_role = " . intval($fliterTeam) . "))";
    $urlStr .= "&fliterTeam=" . $fliterTeam;
}

if (!empty($fliterEmployee)) {
    $fliterStr .= " AND cs_belong = " . intval($fliterEmployee);
    $urlStr .= "&fliterEmployee=" . $fliterEmployee;
}

if (!empty($fliterContact)) {
    switch($fliterContact) {
        case "1": $fliterStr .= " AND cs_tel != ''"; break;
        case "2": $fliterStr .= " AND cs_wechat != ''"; break;
        case "3": $fliterStr .= " AND cs_whatsapp != ''"; break;
        case "4": $fliterStr .= " AND cs_email != ''"; break;
        case "5": $fliterStr .= " AND cs_linkedin != ''"; break;
        case "6": $fliterStr .= " AND cs_facebook != ''"; break;
        case "7": $fliterStr .= " AND cs_alibaba != ''"; break;
    }
    $urlStr .= "&fliterContact=" . $fliterContact;
}

// 搜索和排序
$keys = $_GET['Keys'] ?? '';
$keyscode = textEncode($keys);
$page = $_GET['Page'] ?? 1;
$ord = $_GET['Ord'] ?? '';

$ordStr = !empty($ord) ? "$ord," : "";

// 构建查询SQL
$sqlStr = "SELECT id, cs_code, cs_name, cs_country, cs_address, cs_tel, cs_email, 
           cs_whatsapp, cs_wechat, cs_linkedin, cs_facebook, cs_addtime, cs_alibaba,
           cs_from, cs_deal, cs_updatetime, cs_belong, cs_note, cs_claimFrom, cs_chain, 
           cs_dealdate 
           FROM customer 
           WHERE (cs_code LIKE '%$keyscode%' 
           OR cs_name LIKE '%$keyscode%' 
           OR cs_wechat LIKE '%$keyscode%' 
           OR cs_alibaba LIKE '%$keyscode%' 
           OR cs_telformat LIKE '%$keyscode%' 
           OR cs_whatsappformat LIKE '%$keyscode%' 
           OR cs_email LIKE '%$keyscode%') 
           $fliterStr 
           ORDER BY {$ordStr}cs_updatetime DESC";

?>
<!DOCTYPE html>
<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="xheditor-1.1.9/xheditor-1.1.9-zh-cn.min.js"></script>
    <script>
    $(document).ready(function(){
        $('.txt2').xheditor({
            tools:'full',
            hoverExecDelay:-1,
            urlBase:'system/',
            upLinkUrl:"upload.php",
            upLinkExt:"zip,rar,txt,pdf",
            upImgUrl:"upload.php",
            upImgExt:"jpg,jpeg,gif,png",
            upFlashUrl:"upload.php",
            upFlashExt:"swf",
            upMediaUrl:"upload.php",
            upMediaExt:"wmv,avi,wma,mp3,mid"
        });
    });
    </script>
</head>

<body>
<div id="man_zone">
<?php if ($act == "edit"): ?>
    <form name="form1" method="post" action="<?php echo "?keys=" . urlencode($keys) . "&Page=" . ($page ?? '') . "&act=save" . $urlStr; ?>">
        <table width="100%" border="0" cellpadding="3" cellspacing="1" class="table1">
            <tbody>
                <tr>
                    <th width="8%">客户编号</th>
                    <td><input type="text" id="cs_code" name="cs_code" value="<?php echo $cs_code ?? ''; ?>" class="txt1" />
                    <input type="hidden" name="id" value="<?php echo $id ?? ''; ?>" /></td>
                </tr>
                <tr>
                    <th width="8%">公司名称</th>
                    <td><input type="text" id="cs_company" name="cs_company" value="<?php echo $cs_company ?? ''; ?>" class="txt1" /></td>
                </tr>
                <!-- 其他表单字段 -->
                <tr>
                    <th width="8%">所属业务</th>
                    <td>
                        <select name="cs_belong">
                            <option value="0">请选择</option>
                            <?php
                            $sql = "SELECT id, em_user FROM employee";
                            $result = mysqli_query($conn, $sql);
                            while ($row = mysqli_fetch_assoc($result)) {
                                $selected = ($row['id'] == ($cs_belong ?? '')) ? ' selected="selected"' : '';
                                echo "<option value=\"{$row['id']}\"$selected>{$row['em_user']}</option>";
                            }
                            ?>
                        </select>
                    </td>
                </tr>
                <!-- 更多表单字段 -->
            </tbody>
        </table>
    </form>
<?php else: ?>
    <form id="form1" method="post" action="?act=postchk&keys=<?php echo urlencode($keys); ?>&Page=<?php echo $page; ?>" onSubmit="return false;">
        <div class="fastSelect clear">
            <H1>搜索条件</H1>
            <!-- 筛选条件 -->
            <div class="selectItem">
                <label>来源渠道</label>
                <select name="fliterQudao" class="filterSearch">
                    <option value="">请选择渠道</option>
                    <?php
                    $sql = "SELECT id, ch_name FROM qudao";
                    $result = mysqli_query($conn, $sql);
                    while ($row = mysqli_fetch_assoc($result)) {
                        $selected = ($fliterQudao == $row['id']) ? ' selected="selected"' : '';
                        echo "<option value=\"{$row['id']}\"$selected>{$row['ch_name']}</option>";
                    }
                    ?>
                </select>
            </div>
            <!-- 其他筛选条件 -->
        </div>

        <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="20%">客户编码</th>
                    <th width="10%">联系人</th>
                    <th width="10%">国家地区</th>
                    <th width="7.5%">来源</th>
                    <th width="7.5%">
                        <a href="?keys=<?php echo urlencode($keys); ?>&Ord=<?php echo ($ord == 'cs_dealdate') ? 'cs_dealdate DESC' : 'cs_dealdate'; ?>">
                            是否成交
                        </a>
                    </th>
                    <th width="10%">业务员</th>
                    <th width="10%">操作</th>
                </tr>
            </thead>
            <tbody>
            <?php
            $result = mysqli_query($conn, $sqlStr);
            if (mysqli_num_rows($result) > 0) {
                $page_size = 18;
                $total_records = mysqli_num_rows($result);
                $total_pages = ceil($total_records / $page_size);
                
                if ($page > $total_pages) $page = $total_pages;
                $start = ($page - 1) * $page_size;
                
                mysqli_data_seek($result, $start);
                $counter = $start;
                
                for ($i = 0; $i < $page_size && $row = mysqli_fetch_assoc($result); $i++) {
                    $counter++;
                    // 显示数据行
                    include('customer_row.php'); // 建议将行模板分离到单独文件
                }
            } else {
                echo "<tr><td colspan='9' align='center'>没有找到相关记录</td></tr>";
            }
            ?>
            </tbody>
            <!-- 分页控件 -->
            <tfoot>
                <tr>
                    <td colspan="9">
                        <div class="showpagebox">
                            <?php include('pagination.php'); // 建议将分页逻辑分离到单独文件 ?>
                        </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>
<?php endif; ?>
</div>
</body>
</html>