mtb_crm_asp/system/customers.php

<?php
require_once('conn.php');
checkLogin("信息管理");

// Initialize variables
$urlStr = "";
$act = $_GET['act'] ?? '';
$output = '';

// Process all actions that might need headers
if ($act == "save") {
    $isEdit = false;
    $id = $_POST['id'] ?? '';
    if (!empty($id) && is_numeric($id)) {
        $isEdit = true;
    }

    // Main customer table fields
    $cs_code = textEncode($_POST['cs_code'] ?? '');
    $cs_company = textEncode($_POST['cs_company'] ?? '');
    $cs_belong = intval($_POST['cs_belong'] ?? 0);
    $cs_country = intval($_POST['cs_country'] ?? 0);
    $cs_from = intval($_POST['cs_from'] ?? 0);
    $cs_state = intval($_POST['cs_state'] ?? 0);
    $cs_deal = intval($_POST['cs_deal'] ?? 0);
    $no_content = htmlEncode($_POST['no_content'] ?? '');
    $cs_address = textEncode($_POST['cs_address'] ?? '');
    $allowedit = isset($_POST['allowedit']) ? 1 : 0;

    // Contact fields
    $contact_name = textEncode($_POST['cs_name'] ?? '');
    $tel = textEncode($_POST['cs_tel'] ?? '');
    $email = textEncode($_POST['cs_email'] ?? '');
    $whatsapp = textEncode($_POST['cs_whatsapp'] ?? '');
    $wechat = textEncode($_POST['cs_wechat'] ?? '');
    $linkedin = textEncode($_POST['cs_linkedin'] ?? '');
    $facebook = textEncode($_POST['cs_facebook'] ?? '');
    $alibaba = textEncode($_POST['cs_alibaba'] ?? '');

    if ($isEdit) {
        $sql = "SELECT cs_chain FROM customer WHERE id=" . $id;
        $result = $conn->query($sql);
        
        if ($row = $result->fetch_assoc()) {
            $cs_chain = $row['cs_chain'];
            $chain_array = explode(',', $cs_chain);
            $last_item = end($chain_array);
            
            if ($last_item != $cs_belong) {
                $cs_chain .= ",$cs_belong";
            }
            
            // Update customer table
            $sql = "UPDATE customer SET 
                cs_code='$cs_code', 
                cs_company='$cs_company', 
                cs_belong=$cs_belong,
                cs_country=$cs_country,
                cs_from=$cs_from,
                cs_state=$cs_state,
                cs_deal=$cs_deal,
                cs_note='$no_content',
                cs_address='$cs_address',
                allowedit=$allowedit,
                cs_chain='$cs_chain',
                cs_updatetime=NOW()
                WHERE id=$id";
            $conn->query($sql);

            // Check if contact exists for this customer
            $sql = "SELECT id FROM customer_contact WHERE customer_id=$id";
            $contact_result = $conn->query($sql);
            
            if ($contact_result->num_rows > 0) {
                $contact_row = $contact_result->fetch_assoc();
                $contact_id = $contact_row['id'];
                
                // Update existing contact
                $sql = "UPDATE customer_contact SET 
                    contact_name='$contact_name',
                    tel='$tel',
                    email='$email',
                    whatsapp='$whatsapp',
                    wechat='$wechat',
                    linkedin='$linkedin',
                    facebook='$facebook',
                    alibaba='$alibaba',
                    updated_at=NOW()
                    WHERE id=$contact_id";
                $conn->query($sql);
            } else {
                // Create new contact for existing customer
                $sql = "INSERT INTO customer_contact (
                    customer_id, contact_name, tel, email, whatsapp, wechat, 
                    linkedin, facebook, alibaba, created_at, updated_at
                ) VALUES (
                    $id, '$contact_name', '$tel', '$email', '$whatsapp', '$wechat',
                    '$linkedin', '$facebook', '$alibaba', NOW(), NOW()
                )";
                $conn->query($sql);
            }

            $page = $_GET['Page'] ?? '';
            $keys = urlencode($_GET['Keys'] ?? '');
            header("Location: ?keys=$keys&Page=$page$urlStr");
            exit;
        } else {
            $output = "<script>alert('不存在该客户');history.back();</script>";
        }
    } else {
        // Begin transaction
        $conn->begin_transaction();
        
        try {
            // Insert into customer table
            $sql = "INSERT INTO customer (
                cs_code, cs_company, cs_belong, cs_country, cs_from,
                cs_state, cs_deal, cs_note, cs_address,
                allowedit, cs_chain, cs_addtime, cs_updatetime
            ) VALUES (
                '$cs_code', '$cs_company', $cs_belong, $cs_country, $cs_from,
                $cs_state, $cs_deal, '$no_content', '$cs_address',
                $allowedit, '$cs_belong', NOW(), NOW()
            )";
            
            $conn->query($sql);
            $new_customer_id = $conn->insert_id;
            
            // Insert into customer_contact table
            $sql = "INSERT INTO customer_contact (
                customer_id, contact_name, tel, email, whatsapp, wechat, 
                linkedin, facebook, alibaba, created_at, updated_at
            ) VALUES (
                $new_customer_id, '$contact_name', '$tel', '$email', '$whatsapp', '$wechat',
                '$linkedin', '$facebook', '$alibaba', NOW(), NOW()
            )";
            $conn->query($sql);
            
            // Commit transaction
            $conn->commit();
            header("Location: ?");
            exit;
        } catch (Exception $e) {
            // Rollback on failure
            $conn->rollback();
            $output = "<script>alert('保存失败: " . $e->getMessage() . "');history.back();</script>";
        }
    }
}

// If we have output from processing, we'll show it instead of the normal page
if (!empty($output)) {
    echo $output;
    exit;
}
?>
<!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" || $act == "add") {
    $id = $_GET['id'] ?? '';
    $isEdit = false;
    
    // 初始化变量
    $cs_code = $cs_company = $cs_name = $cs_tel = $cs_telBu = '';
    $cs_wechat = $cs_wechatBu = $cs_whatsapp = $cs_whatsappBu = '';
    $cs_email = $cs_emailBu = $cs_linkedin = $cs_linkedinBu = '';
    $cs_facebook = $cs_facebookBu = $cs_alibaba = $cs_alibabaBu = '';
    $cs_address = $cs_addtime = $cs_updatetime = $cs_note = '';
    $cs_belong = $cs_country = $cs_from = $cs_state = $cs_deal = $allowedit = 0;

    if (!empty($id) && is_numeric($id)) {
        $isEdit = true;
        
        // Join customer and customer_contact tables
        $sql = "SELECT c.*, cc.contact_name, cc.tel, cc.tel_bu, cc.email, cc.email_bu,
                cc.whatsapp, cc.whatsapp_bu, cc.wechat, cc.wechat_bu, 
                cc.linkedin, cc.linkedin_bu, cc.facebook, cc.facebook_bu,
                cc.alibaba, cc.alibaba_bu
                FROM customer c 
                LEFT JOIN customer_contact cc ON c.id = cc.customer_id
                WHERE c.id=$id";
        $result = $conn->query($sql);
        
        if ($row = $result->fetch_assoc()) {
            $cs_code = textUncode($row['cs_code']);
            $cs_company = textUncode($row['cs_company']);
            $cs_name = textUncode($row['contact_name']);
            $cs_country = $row['cs_country'];
            $cs_from = $row['cs_from'];
            $cs_tel = textUncode($row['tel']);
            $cs_telBu = textUncode($row['tel_bu']);
            $cs_wechat = textUncode($row['wechat']);
            $cs_wechatBu = textUncode($row['wechat_bu']);
            $cs_whatsapp = textUncode($row['whatsapp']);
            $cs_whatsappBu = textUncode($row['whatsapp_bu']);
            $cs_email = textUncode($row['email']);
            $cs_emailBu = textUncode($row['email_bu']);
            $cs_linkedin = textUncode($row['linkedin']);
            $cs_linkedinBu = textUncode($row['linkedin_bu']);
            $cs_facebook = textUncode($row['facebook']);
            $cs_facebookBu = textUncode($row['facebook_bu']);
            $cs_alibaba = textUncode($row['alibaba']);
            $cs_alibabaBu = textUncode($row['alibaba_bu']);
            $cs_address = textUncode($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 = htmlUncode($row['cs_note']);
            $allowedit = $row['allowedit'];
        }
    }

    $page = $_GET['Page'] ?? '';
    $keys = urlencode($_GET['Keys'] ?? '');
    $ord = urlencode($_GET['Ord'] ?? '');
    $hrefstr = "?keys=$keys&Page=$page&Ord=$ord";
    ?>
    <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="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><input type="text" id="cs_name" name="cs_name" value="<?php echo $cs_name; ?>" 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 = $conn->query($sql);
                        while($row = $result->fetch_assoc()) {
                            $selected = ($row['id'] == $cs_belong) ? ' selected="selected"' : '';
                            echo "<option value=\"{$row['id']}\"$selected>{$row['em_user']}</option>";
                        }
                        ?>
                    </select>
                </td>
            </tr>
            <tr>
                <th width="8%">国家</th>
                <td>
                    <select name="cs_country">
                        <option value="0">请选择</option>
                        <?php
                        $sql = "SELECT id,countryCode,countryName FROM country";
                        $result = $conn->query($sql);
                        while($row = $result->fetch_assoc()) {
                            $selected = ($row['id'] == $cs_country) ? ' selected="selected"' : '';
                            echo "<option value=\"{$row['id']}\"$selected>{$row['countryName']}</option>";
                        }
                        ?>
                    </select>
                </td>
            </tr>
            <tr>
                <th width="8%">来源</th>
                <td>
                    <select name="cs_from">
                        <option value="0">请选择</option>
                        <?php
                        $sql = "SELECT id,ch_name FROM qudao";
                        $result = $conn->query($sql);
                        while($row = $result->fetch_assoc()) {
                            $selected = ($row['id'] == $cs_from) ? ' selected="selected"' : '';
                            echo "<option value=\"{$row['id']}\"$selected>{$row['ch_name']}</option>";
                        }
                        ?>
                    </select>
                </td>
            </tr>                
            <tr>
                <th width="8%">录入时间</th>
                <td><?php echo $cs_addtime; ?></td>
            </tr>
            <tr>
                <th width="8%">更新时间</th>
                <td><?php echo $cs_updatetime; ?></td>
            </tr>
            <tr>
                <th width="8%" rowspan="7">联系方式</th>
                <td><input type="text" id="cs_tel" name="cs_tel" value="<?php echo $cs_tel ?? ''; ?>" class="txt5 tel" />备份:<?php echo $cs_telBu ?? ''; ?></td>
            </tr>
            <tr>
                <td><input type="text" id="cs_email" name="cs_email" value="<?php echo $cs_email ?? ''; ?>" class="txt5 mail" />备份:<?php echo $cs_emailBu ?? ''; ?></td>
            </tr>    
            <tr>
                <td><input type="text" id="cs_whatsapp" name="cs_whatsapp" value="<?php echo $cs_whatsapp ?? ''; ?>" class="txt5 whatsapp" />备份：<?php echo $cs_whatsappBu ?? ''; ?></td>        
            </tr>    
            <tr>
                <td><input type="text" id="cs_wechat" name="cs_wechat" value="<?php echo $cs_wechat ?? ''; ?>" class="txt5 wechat" />备份：<?php echo $cs_wechatBu ?? ''; ?></td>    
            </tr>
            <tr>
                <td><input type="text" id="cs_linkedin" name="cs_linkedin" value="<?php echo $cs_linkedin ?? ''; ?>" class="txt5 linkedin" />备份：<?php echo $cs_linkedinBu ?? ''; ?></td>
            </tr>    
            <tr>
                <td><input type="text" id="cs_facebook" name="cs_facebook" value="<?php echo $cs_facebook ?? ''; ?>" class="txt5 facebook" />备份：<?php echo $cs_facebookBu ?? ''; ?></td>        
            </tr>    
            <tr>
                <td><input type="text" id="cs_alibaba" name="cs_alibaba" value="<?php echo $cs_alibaba ?? ''; ?>" class="txt5 alibaba" />备份：<?php echo $cs_alibabaBu ?? ''; ?></td>    
            </tr>        
            <tr>
                <th width="8%">地址</th>
                <td><input type="text" id="cs_address" name="cs_address" value="<?php echo $cs_address ?? ''; ?>" class="txt1" /></td>
            </tr>        
            <tr>
                <th width="8%">标签</th>
                <td>
                    <?php
                    if($isEdit ?? false) {
                        $sql = "SELECT id,tagName FROM tagtable WHERE customerId = ?";
                        $stmt = $conn->prepare($sql);
                        $stmt->bind_param("i", $id);
                        $stmt->execute();
                        $result = $stmt->get_result();
                        while($row = $result->fetch_assoc()) {
                            echo htmlspecialchars($row['tagName'] ?? '') . ',';
                        }
                        $stmt->close();
                    }
                    ?>                
                </td>
            </tr>                        
            <tr>
                <th width="8%">状态</th>
                <td>
                    <label><input type="radio" name="cs_state" value="1" <?php if(($cs_state ?? 0)==1) echo 'checked="checked"'; ?> />有效</label> 
                    <label><input type="radio" name="cs_state" value="0" <?php if(($cs_state ?? 0)!=1) echo 'checked="checked"'; ?> />不再跟进</label>
                </td>
            </tr>
            <tr>
                <th width="8%">是否误报</th>
                <td>
                    <label><input type="radio" name="allowedit" value="1" <?php if(($allowedit ?? 0)==1) echo 'checked="checked"'; ?> />审核通过</label> 
                    <label><input type="radio" name="allowedit" value="0" <?php if(($allowedit ?? 0)!=1) echo 'checked="checked"'; ?> />一般处理</label>
                </td>
            </tr>            
            <tr>
                <th width="8%">是否成交</th>
                <td>
                    <label><input type="radio" name="cs_deal" value="3" <?php if(($cs_deal ?? 0)==3) echo 'checked="checked"'; ?> />成交</label> 
                    <label><input type="radio" name="cs_deal" value="2" <?php if(($cs_deal ?? 0)==2) echo 'checked="checked"'; ?> />明确需求</label>
                    <label><input type="radio" name="cs_deal" value="1" <?php if(($cs_deal ?? 0)==1) echo 'checked="checked"'; ?> />背景调查</label>                    
                    <label><input type="radio" name="cs_deal" value="0" <?php if(($cs_deal ?? 0)==0) echo 'checked="checked"'; ?> />无响应</label>
                </td>
            </tr>
            <tr>
                <th>内容</th>
                <td><textarea id="no_content" name="no_content" class="txt2"><?php echo $cs_note ?? ''; ?></textarea></td>
            </tr>
            <tr>
                <th></th>
                <td>
                    <input type="submit" name="save" id="save" value="确定" class="btn1" /> 
                    <input type="reset" name="save" id="save" 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'] ?? '';
    
    if (isset($_POST['chkbox']) && is_array($_POST['chkbox'])) {
        $ids = array_map('intval', $_POST['chkbox']);
        $idList = implode(',', $ids);
        
        if (!empty($idList)) {
            switch($chkact) {
                case "0":
                case "1":
                    $sql = "UPDATE customer SET cs_state=$chkact WHERE id IN ($idList)";
                    break;
                default:
                    // In delete case, let's use transactions to ensure both tables are updated
                    $conn->begin_transaction();
                    try {
                        // Delete from customer_contact first (due to foreign key constraint)
                        $sql = "DELETE FROM customer_contact WHERE customer_id IN ($idList)";
                        $conn->query($sql);
                        
                        // Then delete from customer table
                        $sql = "DELETE FROM customer WHERE id IN ($idList)";
                        $conn->query($sql);
                        
                        $conn->commit();
                    } catch (Exception $e) {
                        $conn->rollback();
                        echo "<script>alert('删除失败: " . $e->getMessage() . "');</script>";
                    }
            }
            if ($chkact == "0" || $chkact == "1") {
                $conn->query($sql);
            }
        }
    }
    
    header("Location: ?Keys=$keys&Page=$page");
    exit;
}

// 主列表页面
$fliterQudao = $_GET['fliterQudao'] ?? '';
$fliterDeal = $_GET['fliterDeal'] ?? '';
$fliterTeam = $_GET['fliterTeam'] ?? '';
$fliterContact = $_GET['fliterContact'] ?? '';
$fliterEmployee = $_GET['fliterEmployee'] ?? '';

$filterStr = "";
$urlStr = "";

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

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

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

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

if (!empty($fliterContact)) {
    switch($fliterContact) {
        case "1": $filterStr .= " AND cc.tel<>''"; break;
        case "2": $filterStr .= " AND cc.wechat<>''"; break;
        case "3": $filterStr .= " AND cc.whatsapp<>''"; break;
        case "4": $filterStr .= " AND cc.email<>''"; break;
        case "5": $filterStr .= " AND cc.linkedin<>''"; break;
        case "6": $filterStr .= " AND cc.facebook<>''"; break;
        default: $filterStr .= " AND cc.alibaba<>''";
    }
    $urlStr .= "&fliterContact=$fliterContact";
}

$keys = $_GET['Keys'] ?? '';
$keyscode = textEncode($keys);
$page = $_GET['Page'] ?? '';
$ord = $_GET['Ord'] ?? '';

$sql = "SELECT c.id, c.cs_code, c.cs_company, c.cs_country, c.cs_address, 
        c.cs_from, c.cs_deal, c.cs_addtime, c.cs_updatetime, c.cs_belong, c.cs_note, 
        c.cs_claimFrom, c.cs_chain, c.cs_dealdate,
        cc.contact_name as cs_name, cc.tel as cs_tel, cc.email as cs_email, 
        cc.whatsapp as cs_whatsapp, cc.wechat as cs_wechat, cc.linkedin as cs_linkedin, 
        cc.facebook as cs_facebook, cc.alibaba as cs_alibaba
        FROM customer c 
        LEFT JOIN customer_contact cc ON c.id = cc.customer_id
        WHERE (c.cs_code LIKE '%$keyscode%' 
        OR cc.contact_name LIKE '%$keyscode%' 
        OR cc.wechat LIKE '%$keyscode%'
        OR cc.alibaba LIKE '%$keyscode%' 
        OR cc.tel LIKE '%$keyscode%' 
        OR cc.whatsapp LIKE '%$keyscode%'
        OR cc.email LIKE '%$keyscode%') 
        $filterStr 
        ORDER BY c.cs_updatetime DESC";

$result = $conn->query($sql);
?>

<form id="form1" method="post" action="?act=postchk&Keys=<?php echo $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_temp = "SELECT id,ch_name FROM qudao";
                $qudaoResult = $conn->query($sql_temp);
                while($row = $qudaoResult->fetch_assoc()) {
                    $selected = ($fliterQudao == $row['id']) ? ' selected="selected"' : '';
                    echo "<option value=\"{$row['id']}\"$selected>{$row['ch_name']}</option>";
                }
                ?>
            </select>    
        </div>
        <div class="selectItem">        
        <label>是否成交</label>
            <select name="fliterDeal" class="filterSearch">
                <option value="">请选择</option>
                <option value="3" <?php if($fliterDeal=="3") echo 'selected="selected"'; ?>>已成交</option>                    
                <option value="2" <?php if($fliterDeal=="2") echo 'selected="selected"'; ?>>明确需求</option>                    
                <option value="1" <?php if($fliterDeal=="1") echo 'selected="selected"'; ?>>背景调查</option>    
                <option value="0" <?php if($fliterDeal=="0") echo 'selected="selected"'; ?>>无响应</option>            
            </select>
        </div>
        <div class="selectItem">        
        <label>按组</label>
            <select name="fliterTeam" class="filterSearch">
                <option value="">请选择</option>
                <?php
                $sql_temp = "SELECT id,em_user FROM employee WHERE em_role=0";
                $teamResult = $conn->query($sql_temp);
                while($row = $teamResult->fetch_assoc()) {
                    $selected = ($fliterTeam == $row['id']) ? ' selected="selected"' : '';
                    echo "<option value=\"{$row['id']}\"$selected>{$row['em_user']}组</option>";
                }
                ?>            
            </select>
        </div>
        
        <div class="selectItem">        
        <label>业务</label>
            <select name="fliterEmployee" class="filterSearch">
                <option value="">请选择</option>
                <?php
                $sql_temp = "SELECT id,em_user FROM employee";
                $empResult = $conn->query($sql_temp);
                while($row = $empResult->fetch_assoc()) {
                    $selected = ($fliterEmployee == $row['id']) ? ' selected="selected"' : '';
                    echo "<option value=\"{$row['id']}\"$selected>{$row['em_user']}</option>";
                }
                ?>            
            </select>
        </div>
        
        <div class="selectItem">        
        <label>联系方式</label>
            <select name="fliterContact" class="filterSearch">
                <option value="">请选择</option>
                <option value="1" <?php if($fliterContact=="1") echo 'selected="selected"'; ?>>电话</option>        
                <option value="2" <?php if($fliterContact=="2") echo 'selected="selected"'; ?>>微信</option>    
                <option value="3" <?php if($fliterContact=="3") echo 'selected="selected"'; ?>>WhatsApp</option>        
                <option value="4" <?php if($fliterContact=="4") echo 'selected="selected"'; ?>>邮箱</option>            
                <option value="5" <?php if($fliterContact=="5") echo 'selected="selected"'; ?>>领英</option>        
                <option value="6" <?php if($fliterContact=="6") echo 'selected="selected"'; ?>>Facebook</option>            
                <option value="7" <?php if($fliterContact=="7") echo 'selected="selected"'; ?>>阿里巴巴</option>            
            </select>
        </div>
        <div class="inputSearch">
            <input type="text" id="keys" class="inputTxt" value="<?php echo empty($keyscode) ? '请输入搜索关键词' : $keyscode; ?>" 
                   onFocus="if(this.value == '<?php echo empty($keyscode) ? '请输入搜索关键词' : $keyscode; ?>'){this.value='';}" 
                   onBlur="if(this.value == ''){this.value='<?php echo empty($keyscode) ? '请输入搜索关键词' : $keyscode; ?>';}" 
                   onKeyDown="if(event.keyCode==13){location.href='?Keys='+escape(document.getElementById('keys').value)+'<?php echo $urlStr; ?>'}" />
            <input type="button" id="searchgo" class="searchgo" value="go" 
                   onClick="location.href='?Keys='+escape(document.getElementById('keys').value)+'<?php echo $urlStr; ?>'" />
        </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%">是否成交</th>        
                <th width="10%">业务员</th>                    
                <th width="10%">操作</th>
            </tr>
        </thead>
        <tbody>
        <?php
        if ($result->num_rows > 0) {
            $pageSize = 18;
            $totalPages = ceil($result->num_rows / $pageSize);
            
            if (empty($page)) $page = 1;
            if ($page == 'end') $page = $totalPages;
            if (!is_numeric($page) || $page < 1) $page = 1;
            $page = (int)$page;
            if ($page > $totalPages) $page = $totalPages;
            
            $offset = ($page - 1) * $pageSize;
            $sql .= " LIMIT $offset, $pageSize";


            $result = $conn->query($sql);
            
            $tempNum = $pageSize * ($page - 1);
            
            while ($row = $result->fetch_assoc()) {



                $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" class="code" data-id="<?php echo $row['id'] ?? ''; ?>">
                        <?php

                        echo $row['cs_code'] ?? ''; ?>
                        <?php if(($row['cs_claimFrom'] ?? 0) > 0): ?>
                            <img src="../images/yijiao.png" class="handover">
                        <?php endif; ?>
                    </td>
                    <td align="center"><?php echo $row['cs_name'] ?? ''; ?></td>
                    <td align="center">
                        <?php
                        $countryId = intval($row['cs_country'] ?? 0);
                        $sql = "SELECT countryName FROM country WHERE id = ?";
                        $stmt = $conn->prepare($sql);
                        $stmt->bind_param("i", $countryId);
                        $stmt->execute();
                        $countryResult = $stmt->get_result();
                        if ($countryRow = $countryResult->fetch_assoc()) {
                            echo htmlspecialchars($countryRow['countryName']);
                        } else {
                            echo "未选择";
                        }
                        $stmt->close();
                        ?>
                    </td>
                    <td align="center">
                        <?php
                        $fromId = intval($row['cs_from'] ?? 0);
                        $sql = "SELECT ch_name FROM qudao WHERE id = ?";
                        $stmt = $conn->prepare($sql);
                        $stmt->bind_param("i", $fromId);
                        $stmt->execute();
                        $qudaoResult = $stmt->get_result();
                        if ($qudaoRow = $qudaoResult->fetch_assoc()) {
                            echo htmlspecialchars($qudaoRow['ch_name']);
                        } else {
                            echo "未选择";
                        }
                        $stmt->close();
                        ?>
                    </td>                
                    <td align="center">
                        <?php 
                        $cs_deal = intval($row['cs_deal'] ?? 0);
                        if ($cs_deal == 3) {
                            echo "<span style='color:red;font-size:10px;'>" . htmlspecialchars($row['cs_dealdate'] ?? '') . "成交</span>";
                        } elseif ($cs_deal == 2) {
                            echo "明确需求";
                        } elseif ($cs_deal == 1) {
                            echo "背景调查";
                        } else {
                            echo "无响应";
                        }
                        ?>
                    </td>
                    <td align="center">
                        <?php
                        $belongId = intval($row['cs_belong'] ?? 0);
                        $sql = "SELECT em_user FROM employee WHERE id = ?";
                        $stmt = $conn->prepare($sql);
                        $stmt->bind_param("i", $belongId);
                        $stmt->execute();
                        $empResult = $stmt->get_result();
                        if ($empRow = $empResult->fetch_assoc()) {
                            echo htmlspecialchars($empRow['em_user']);
                        } else {
                            echo "未选择";
                        }
                        $stmt->close();
                        ?>
                    </td>                
                    <td align="center">
                        <a href="?Keys=<?php echo urlencode($keys ?? ''); ?>&Page=<?php echo urlencode($page ?? '') . $urlStr; ?>&act=edit&id=<?php echo $row['id'] ?? ''; ?>" class="ico_edit ico">修改</a>
                    </td>
                </tr>
                <tr class="detail_panel code<?php echo $row['id'] ?? ''; ?>__panel">
                    <td colspan="2"></td>
                    <td colspan="7" class="cs_detail">                    
                        <ul>                
                            <li class="cs_detail_addtime">录入时间:<?php echo htmlspecialchars($row['cs_addtime'] ?? ''); ?></li>
                            <li class="cs_detail_addtime">更新时间:<?php echo htmlspecialchars($row['cs_updatetime'] ?? ''); ?></li>
                            <li class="cs_detail_addtime">
                                流转记录：
                                <?php                                
                                $chain = $row['cs_chain'] ?? '';
                                if(!empty($chain)) {
                                    $chain_array = explode(',', $chain);
                                    $chain_ids = array_filter(array_map('intval', $chain_array));
                                    
                                    if(!empty($chain_ids)) {
                                        $placeholders = str_repeat('?,', count($chain_ids) - 1) . '?';
                                        $sql = "SELECT em_user FROM employee WHERE id IN ($placeholders)";
                                        $stmt = $conn->prepare($sql);
                                        $stmt->bind_param(str_repeat('i', count($chain_ids)), ...$chain_ids);
                                        $stmt->execute();
                                        $chainResult = $stmt->get_result();
                                        $chain_users = [];
                                        while($chainRow = $chainResult->fetch_assoc()) {
                                            $chain_users[] = htmlspecialchars($chainRow['em_user']);
                                        }
                                        echo implode(' > ', $chain_users);
                                        $stmt->close();
                                    }
                                }
                                ?>             
                            </li>                            
                            <?php if(!empty($row['cs_tel'] ?? '')): ?>
                                <li class="tel"><?php echo htmlspecialchars($row['cs_tel']); ?></li>
                            <?php endif; ?>
                            <?php if(!empty($row['cs_email'] ?? '')): ?>
                                <li class="mail"><?php echo htmlspecialchars($row['cs_email']); ?></li>
                            <?php endif; ?>
                            <?php if(!empty($row['cs_whatsapp'] ?? '')): ?>
                                <li class="whatsapp"><?php echo htmlspecialchars($row['cs_whatsapp']); ?></li>
                            <?php endif; ?>
                            <?php if(!empty($row['cs_wechat'] ?? '')): ?>
                                <li class="wechat"><?php echo htmlspecialchars($row['cs_wechat']); ?></li>
                            <?php endif; ?>
                            <?php if(!empty($row['cs_linkedin'] ?? '')): ?>
                                <li class="linkedin"><?php echo htmlspecialchars($row['cs_linkedin']); ?></li>
                            <?php endif; ?>
                            <?php if(!empty($row['cs_facebook'] ?? '')): ?>
                                <li class="facebook"><?php echo htmlspecialchars($row['cs_facebook']); ?></li>
                            <?php endif; ?>
                            <?php if(!empty($row['cs_alibaba'] ?? '')): ?>
                                <li class="alibaba"><?php echo htmlspecialchars($row['cs_alibaba']); ?></li>
                            <?php endif; ?>
                            <?php if(!empty($row['cs_address'] ?? '')): ?>
                                <li class="address"><?php echo htmlspecialchars($row['cs_address']); ?></li>
                            <?php endif; ?>
                        </ul>
                        <div class="cs_detail_note"><?php echo htmlspecialchars($row['cs_note'] ?? ''); ?></div>
                    </td>                
                </tr>
                <?php
            }
        } else {
            if (empty($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 ($totalPages > 1) {
                        $pageName = "?Keys=$keys&Ord=$ord$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 >= $totalPages) {
                            $startPage = 1;
                            $endPage = $totalPages;
                        } else {
                            if ($page <= $pageLen + 1) {
                                $startPage = 1;
                                $endPage = $pageLen * 2 + 1;
                            } else {
                                $startPage = $page - $pageLen;
                                $endPage = $page + $pageLen;
                            }
                            if ($page + $pageLen > $totalPages) {
                                $startPage = $totalPages - $pageLen * 2;
                                $endPage = $totalPages;
                            }
                        }
                        
                        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 < $totalPages) {
                            if ($totalPages - $page > $pageLen) {
                                echo "<a href=\"{$pageName}Page=$totalPages\">...$totalPages</a>";
                            }
                            echo "<a href=\"{$pageName}Page=" . ($page+1) . "\">下一页</a>";
                            echo "<a href=\"{$pageName}Page=$totalPages\">尾页</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>
<?php
$conn->close();
?>