igamebox
/
mtb_crm_asp


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169
							<?php
require_once 'conn.php';
checkLogin();
?>
<!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 src="system/js/jquery-1.7.2.min.js"></script>
    <script src="js/js.js"></script>
    <script src="system/xheditor-1.1.9/xheditor-1.1.9-zh-cn.min.js"></script>
</head>
<style>
    body {
        margin: 0;
        padding: 20px;
        background: #fff;
    }
    #man_zone {
        margin-left: 0;
    }
</style>
<body class="clear">
<?php // require_once 'panel.php'; ?>
<div id="man_zone">
<?php
$id = $_GET['id'] ?? '';
$page = $_GET['Page'] ?? '';
$keys = urlencode($_GET['Keys'] ?? '');
$ord = urlencode($_GET['Ord'] ?? '');
$hrefstr = "?keys=" . $keys . "&Ord=" . $ord . "&Page=" . $page;

if (!empty($id) && is_numeric($id)) {
    $sql = "SELECT c.*, 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_belong IN (SELECT id FROM employee WHERE em_role=" . $_SESSION['employee_id'] . ") 
            AND c.id=" . (int)$id;
            
    $result = $conn->query($sql);
    
    if ($result && $row = $result->fetch_assoc()) {
        $cs_company = textUncode($row['cs_company']);
        $cs_name = textUncode($row['cs_name']);
        $cs_country = textUncode($row['cs_country']);
        $cs_tel = textUncode($row['cs_tel']);
        $cs_email = textUncode($row['cs_email']);
        $cs_whatsapp = textUncode($row['cs_whatsapp']);
        $cs_wechat = textUncode($row['cs_wechat']);
        $cs_linkedin = textUncode($row['cs_linkedin']);
        $cs_facebook = textUncode($row['cs_facebook']);
        $cs_alibaba = textUncode($row['cs_alibaba']);
        $cs_address = textUncode($row['cs_address']);
        $cs_code = textUncode($row['cs_code']);
        $cs_deal = textUncode($row['cs_deal']);
        $cs_addtime = $row['cs_addtime'];
        $cs_updatetime = $row['cs_updatetime'];
        $cs_from = $row['cs_from'];
        $cs_note = $row['cs_note'];
?>
    <table width="100%" border="0" cellpadding="3" cellspacing="1" class="table1">
        <tbody>
            <tr>
                <th width="8%">客户编号</th>
                <td><?= htmlspecialcharsFix($cs_code) ?></td>
            </tr>
            <tr>
                <th width="8%">公司名称</th>
                <td><?= htmlspecialcharsFix($cs_company) ?></td>
            </tr>
            <tr>
                <th width="8%">联系人</th>
                <td><?= htmlspecialcharsFix($cs_name) ?></td>
            </tr>
            <tr>
                <th width="8%">地区</th>
                <td>
                    <?php
                    $countryResult = $conn->query("SELECT countryCode, countryName FROM country WHERE countryCode='" . 
                                                $conn->real_escape_string($cs_country) . "'");
                    if ($countryRow = $countryResult->fetch_assoc()) {
                        echo "(+" . htmlspecialcharsFix($countryRow['countryCode']) . ")" . 
                             htmlspecialcharsFix($countryRow['countryName']);
                    }
                    ?>
                </td>
            </tr>
            <tr>
                <th width="8%">客户来源</th>
                <td>
                    <?php
                    $qudaoResult = $conn->query("SELECT id, ch_name FROM qudao WHERE id=" . (int)$cs_from);
                    if ($qudaoRow = $qudaoResult->fetch_assoc()) {
                        echo htmlspecialcharsFix($qudaoRow['ch_name']);
                    }
                    ?>
                </td>
            </tr>
            <tr>
                <th rowspan="7">联系方式</th>
                <td><?= htmlspecialcharsFix($cs_tel) ?></td>
            </tr>
            <tr>
                <td><span class="wechat"><?= htmlspecialcharsFix($cs_wechat) ?></span></td>
            </tr>
            <tr>
                <td><span class="whatsapp"><?= htmlspecialcharsFix($cs_whatsapp) ?></span></td>
            </tr>
            <tr>
                <td><span class="mail"><?= htmlspecialcharsFix($cs_email) ?></span></td>
            </tr>
            <tr>
                <td><span class="linkedin"><?= htmlspecialcharsFix($cs_linkedin) ?></span></td>
            </tr>
            <tr>
                <td><span class="facebook"><?= htmlspecialcharsFix($cs_facebook) ?></span></td>
            </tr>
            <tr>
                <td><span class="alibaba"><?= htmlspecialcharsFix($cs_alibaba) ?></span></td>
            </tr>
            <tr>
                <th width="8%">地址</th>
                <td><?= htmlspecialcharsFix($cs_address) ?></td>
            </tr>
            <tr>
                <th>是否成交</th>
                <td>
                    <?php
                    if ($cs_deal == 1) {
                        echo "<span style='color:red;'>已经成交</span>";
                    } elseif ($cs_deal == 2) {
                        echo "无响应";
                    } else {
                        echo "未成交";
                    }
                    ?>
                </td>
            </tr>
            <tr>
                <th width="8%">备注</th>
                <td><?= htmlUnCode($cs_note) ?></td>
            </tr>
            <tr>
                <th></th>
                <td>
                    <input type="button" value="返回" class="btn1" 
                           onClick="location.href='subcustomers.php<?= $hrefstr ?>'" />
                </td>
            </tr>
        </tbody>
    </table>
<?php
    } else {
        echo "<script>alert('客户不存在或你没权限查看！');history.back();</script>";
        exit;
    }
} else {
    echo "<script>alert('客户不存在!');history.back();</script>";
    header("Location: " . $hrefstr);
    exit;
}
?>
</div>
</body>
</html>