igamebox
/
mtb_crm_asp


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264
							<?php
require_once 'conn.php';
checkLogin();

$keywordsNative = $_POST['keywords'] ?? '';
$keywords = str_replace(['+', ' ', '-', ')', '('], '', $keywordsNative);
$keywords = textEncode($keywords);

if (empty($keywords) || strlen($keywords) < 4) {
    echo "<script>alert('请至少输入4位数字或文字进行查找');window.location.href='/home.php';</script>";
    exit;
}

$searchStr = "SELECT c.id, c.cs_code, cc.contact_name as cs_name, c.cs_country, cc.tel_1 as cs_tel, 
             cc.email_1 as cs_email, cc.whatsapp_1 as cs_whatsapp, cc.wechat_1 as cs_wechat, 
             cc.linkedin_1 as cs_linkedin, cc.facebook_1 as cs_facebook, c.cs_addtime, 
             c.cs_from, c.cs_belong, c.cs_deal, cc.alibaba_1 as cs_alibaba 
             FROM customer c 
             LEFT JOIN customer_contact cc ON c.id = cc.customer_id
             WHERE (cc.tel_1_format LIKE '%" . $conn->real_escape_string($keywords) . "%' 
             OR cc.tel_2_format LIKE '%" . $conn->real_escape_string($keywords) . "%' 
             OR cc.tel_3_format LIKE '%" . $conn->real_escape_string($keywords) . "%' 
             OR cc.email_1 LIKE '%" . $conn->real_escape_string($keywords) . "%' 
             OR cc.email_2 LIKE '%" . $conn->real_escape_string($keywords) . "%' 
             OR cc.email_3 LIKE '%" . $conn->real_escape_string($keywords) . "%' 
             OR cc.whatsapp_1_format LIKE '%" . $conn->real_escape_string($keywords) . "%' 
             OR cc.whatsapp_2_format LIKE '%" . $conn->real_escape_string($keywords) . "%' 
             OR cc.whatsapp_3_format LIKE '%" . $conn->real_escape_string($keywords) . "%' 
             OR cc.wechat_1 LIKE '%" . $conn->real_escape_string($keywords) . "%' 
             OR cc.wechat_2 LIKE '%" . $conn->real_escape_string($keywords) . "%' 
             OR cc.wechat_3 LIKE '%" . $conn->real_escape_string($keywords) . "%' 
             OR cc.alibaba_1 LIKE '%" . $conn->real_escape_string($keywords) . "%' 
             OR cc.alibaba_2 LIKE '%" . $conn->real_escape_string($keywords) . "%' 
             OR cc.alibaba_3 LIKE '%" . $conn->real_escape_string($keywords) . "%' 
             OR cc.linkedin_1 LIKE '%" . $conn->real_escape_string($keywords) . "%' 
             OR cc.linkedin_2 LIKE '%" . $conn->real_escape_string($keywords) . "%' 
             OR cc.linkedin_3 LIKE '%" . $conn->real_escape_string($keywords) . "%' 
             OR cc.facebook_1 LIKE '%" . $conn->real_escape_string($keywords) . "%' 
             OR cc.facebook_2 LIKE '%" . $conn->real_escape_string($keywords) . "%' 
             OR cc.facebook_3 LIKE '%" . $conn->real_escape_string($keywords) . "%' 
             OR cc.email_1 LIKE '%" . $conn->real_escape_string($keywordsNative) . "%' 
             OR cc.email_2 LIKE '%" . $conn->real_escape_string($keywordsNative) . "%' 
             OR cc.email_3 LIKE '%" . $conn->real_escape_string($keywordsNative) . "%' 
             OR cc.wechat_1 LIKE '%" . $conn->real_escape_string($keywordsNative) . "%' 
             OR cc.wechat_2 LIKE '%" . $conn->real_escape_string($keywordsNative) . "%' 
             OR cc.wechat_3 LIKE '%" . $conn->real_escape_string($keywordsNative) . "%' 
             OR cc.alibaba_1 LIKE '%" . $conn->real_escape_string($keywordsNative) . "%' 
             OR cc.alibaba_2 LIKE '%" . $conn->real_escape_string($keywordsNative) . "%' 
             OR cc.alibaba_3 LIKE '%" . $conn->real_escape_string($keywordsNative) . "%' 
             OR cc.linkedin_1 LIKE '%" . $conn->real_escape_string($keywordsNative) . "%' 
             OR cc.linkedin_2 LIKE '%" . $conn->real_escape_string($keywordsNative) . "%' 
             OR cc.linkedin_3 LIKE '%" . $conn->real_escape_string($keywordsNative) . "%' 
             OR cc.facebook_1 LIKE '%" . $conn->real_escape_string($keywordsNative) . "%' 
             OR cc.facebook_2 LIKE '%" . $conn->real_escape_string($keywordsNative) . "%' 
             OR cc.facebook_3 LIKE '%" . $conn->real_escape_string($keywordsNative) . "%')";
?>
<!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" />
    <link rel="stylesheet" href="css/alert.css" type="text/css" />
    <script src="system/js/jquery-1.7.2.min.js"></script>
    <script src="js/js.js"></script>
    <style>
        body {
            margin: 0;
            padding: 20px;
            background: #fff;
        }
        #man_zone {
            margin-left: 0;
        }
    </style>
</head>
<body class="clear">
<?php // require_once 'panel.php'; ?>
<div id="man_zone">
    <div class="searchForm resultSearch">
        <form method="post" action="searchResult.php" accept-charset="UTF-8">
            <input class="keywords" name="keywords" id="keyword" placeholder="请输入电话/邮箱/微信/WhatsApp.." value="<?= htmlspecialcharsFix($keywordsNative) ?>">
            <input class="searchSubmit" type="submit" value="客户检索">
        </form>
    </div>
    <table width="100%" class="resultForm">
        <tr class="tableHead">
            <td align="center">序号</td>
            <td align="center">客户编号</td>
            <td align="center">联系人</td>
            <td align="center">国家</td>
            <td align="center">来源</td>
            <td align="center">跟进阶段</td>
            <td align="center">录入日期</td>
            <td align="center">所属业务员</td>
        </tr>
<?php
$result = $conn->query($searchStr);
if ($result && $result->num_rows > 0) {
    $i = 1;
    while ($row = $result->fetch_assoc()) {
?>
        <tr>
            <td align="center" rowspan="2"><?= $i ?></td>
            <td align="center"><?= htmlspecialcharsFix($row['cs_code']) ?></td>
            <td align="center"><?= htmlspecialcharsFix($row['cs_name']) ?></td>
            <td align="center">
                <?php
                $countryResult = $conn->query("SELECT countryName FROM country WHERE id=" . (int)$row['cs_country']);
                echo ($countryRow = $countryResult->fetch_assoc()) ? htmlspecialcharsFix($countryRow['countryName']) : '未选择';
                ?>
            </td>
            <td align="center">
                <?php
                $qudaoResult = $conn->query("SELECT ch_name FROM qudao WHERE id=" . (int)$row['cs_from']);
                echo ($qudaoRow = $qudaoResult->fetch_assoc()) ? htmlspecialcharsFix($qudaoRow['ch_name']) : '未选择';
                ?>
            </td>
            <td align="center">
                <?= ($row['cs_deal'] == 3) ? '<span class="highline">成交</span>' : '未成交' ?>
            </td>
            <td align="center"><?= $row['cs_addtime'] ?></td>
            <td align="center" rowspan="2">
                <?php
                $employeeResult = $conn->query("SELECT em_user FROM employee WHERE id=" . (int)$row['cs_belong']);
                echo ($employeeRow = $employeeResult->fetch_assoc()) ? htmlspecialcharsFix($employeeRow['em_user']) : '系统出错';
                ?>
            </td>
        </tr>
        <tr>
            <td colspan="6" class="contacts">
                <?php
                // 获取该客户的所有联系人信息
                if (isset($row['id']) && !empty($row['id'])) {
                    $contact_sql = "SELECT * FROM customer_contact WHERE customer_id = " . (int)$row['id'];
                    $contact_result = mysqli_query($conn, $contact_sql);
                    while ($contact = mysqli_fetch_assoc($contact_result)) {
                ?>
                <div class="contact-block">
                    <?php if(!empty($contact['contact_name'])): ?>
                        <div class="contact-name"><?= htmlspecialcharsFix($contact['contact_name']) ?></div>
                    <?php endif; ?>
                    <div class="tel">
                        <?php if(!empty($contact['tel_1'])): ?>
                            <div><?= htmlspecialcharsFix($contact['tel_1']) ?></div>
                        <?php endif; ?>
                        <?php if(!empty($contact['tel_2'])): ?>
                            <div><?= htmlspecialcharsFix($contact['tel_2']) ?></div>
                        <?php endif; ?>
                        <?php if(!empty($contact['tel_3'])): ?>
                            <div><?= htmlspecialcharsFix($contact['tel_3']) ?></div>
                        <?php endif; ?>
                    </div>
                    <div class="mail">
                        <?php if(!empty($contact['email_1'])): ?>
                            <div><a href="mailto:<?= $contact['email_1'] ?>"><?= htmlspecialcharsFix($contact['email_1']) ?></a></div>
                        <?php endif; ?>
                        <?php if(!empty($contact['email_2'])): ?>
                            <div><a href="mailto:<?= $contact['email_2'] ?>"><?= htmlspecialcharsFix($contact['email_2']) ?></a></div>
                        <?php endif; ?>
                        <?php if(!empty($contact['email_3'])): ?>
                            <div><a href="mailto:<?= $contact['email_3'] ?>"><?= htmlspecialcharsFix($contact['email_3']) ?></a></div>
                        <?php endif; ?>
                    </div>
                    <div class="whatsapp">
                        <?php if(!empty($contact['whatsapp_1'])): ?>
                            <div><?= htmlspecialcharsFix($contact['whatsapp_1']) ?></div>
                        <?php endif; ?>
                        <?php if(!empty($contact['whatsapp_2'])): ?>
                            <div><?= htmlspecialcharsFix($contact['whatsapp_2']) ?></div>
                        <?php endif; ?>
                        <?php if(!empty($contact['whatsapp_3'])): ?>
                            <div><?= htmlspecialcharsFix($contact['whatsapp_3']) ?></div>
                        <?php endif; ?>
                    </div>
                    <div class="wechat">
                        <?php if(!empty($contact['wechat_1'])): ?>
                            <div><?= htmlspecialcharsFix($contact['wechat_1']) ?></div>
                        <?php endif; ?>
                        <?php if(!empty($contact['wechat_2'])): ?>
                            <div><?= htmlspecialcharsFix($contact['wechat_2']) ?></div>
                        <?php endif; ?>
                        <?php if(!empty($contact['wechat_3'])): ?>
                            <div><?= htmlspecialcharsFix($contact['wechat_3']) ?></div>
                        <?php endif; ?>
                    </div>
                    <div class="linkedin">
                        <?php if(!empty($contact['linkedin_1'])): ?>
                            <div><?= htmlspecialcharsFix($contact['linkedin_1']) ?></div>
                        <?php endif; ?>
                        <?php if(!empty($contact['linkedin_2'])): ?>
                            <div><?= htmlspecialcharsFix($contact['linkedin_2']) ?></div>
                        <?php endif; ?>
                        <?php if(!empty($contact['linkedin_3'])): ?>
                            <div><?= htmlspecialcharsFix($contact['linkedin_3']) ?></div>
                        <?php endif; ?>
                    </div>
                    <div class="facebook">
                        <?php if(!empty($contact['facebook_1'])): ?>
                            <div><?= htmlspecialcharsFix($contact['facebook_1']) ?></div>
                        <?php endif; ?>
                        <?php if(!empty($contact['facebook_2'])): ?>
                            <div><?= htmlspecialcharsFix($contact['facebook_2']) ?></div>
                        <?php endif; ?>
                        <?php if(!empty($contact['facebook_3'])): ?>
                            <div><?= htmlspecialcharsFix($contact['facebook_3']) ?></div>
                        <?php endif; ?>
                    </div>
                    <div class="alibaba">
                        <?php if(!empty($contact['alibaba_1'])): ?>
                            <div><?= htmlspecialcharsFix($contact['alibaba_1']) ?></div>
                        <?php endif; ?>
                        <?php if(!empty($contact['alibaba_2'])): ?>
                            <div><?= htmlspecialcharsFix($contact['alibaba_2']) ?></div>
                        <?php endif; ?>
                        <?php if(!empty($contact['alibaba_3'])): ?>
                            <div><?= htmlspecialcharsFix($contact['alibaba_3']) ?></div>
                        <?php endif; ?>
                    </div>
                </div>
                <?php 
                    }
                } else {
                    // 如果没有ID，则显示查询返回的基本联系信息
                ?>
                <div class="contact-block">
                    <div class="tel"><?= htmlspecialcharsFix($row['cs_tel'] ?? '') ?></div>
                    <div class="mail"><?= htmlspecialcharsFix($row['cs_email'] ?? '') ?></div>
                    <div class="whatsapp"><?= htmlspecialcharsFix($row['cs_whatsapp'] ?? '') ?></div>
                    <div class="wechat"><?= htmlspecialcharsFix($row['cs_wechat'] ?? '') ?></div>
                    <div class="linkedin"><?= htmlspecialcharsFix($row['cs_linkedin'] ?? '') ?></div>
                    <div class="facebook"><?= htmlspecialcharsFix($row['cs_facebook'] ?? '') ?></div>
                    <div class="alibaba"><?= htmlspecialcharsFix($row['cs_alibaba'] ?? '') ?></div>
                </div>
                <?php
                }
                ?>
            </td>
        </tr>
<?php
        $i++;
    }
} else {
    if (empty($keywords)) {
?>
        <tr>
            <td colspan="8" align="center">暂无相关记录，可录入该客户,<a href="/customerAdd.php" class="highline">点击录入客户数据</a></td>
        </tr>
<?php
    } else {
?>
        <tr>
            <td colspan="8" align="center">
                <a href="?">Sorry，没有找到"<?= htmlspecialcharsFix($keywords) ?>"相关的信息，点击返回</a>
            </td>
        </tr>
<?php
    }
}
?>
    </table>
</div>
</body>
</html>