igamebox
/
mtb_crm_asp


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

$id = $_GET['id'] ?? '';
$page = $_GET['Page'] ?? '';
$keys = urlencode($_GET['Keys'] ?? '');

$hrefstr = "?keys=$keys&Page=$page";

// Validate and fetch customer data
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 = ? AND c.id = ?";
    
    $stmt = $conn->prepare($sql);
    $stmt->bind_param("ii", $_SESSION['employee_id'], $id);
    $stmt->execute();
    $result = $stmt->get_result();
    
    if ($row = $result->fetch_assoc()) {
        $customer = [
            'cs_company' => textUncode($row['cs_company']),
            'cs_name' => textUncode($row['cs_name']),
            'cs_country' => $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_address' => textUncode($row['cs_address']),
            'cs_alibaba' => textUncode($row['cs_alibaba']),
            'cs_code' => textUncode($row['cs_code']),
            'cs_deal' => textUncode($row['cs_deal']),
            'cs_addtime' => $row['cs_addtime'],
            'cs_belongclient' => $row['cs_belongclient'],
            'cs_updatetime' => $row['cs_updatetime'],
            'cs_from' => $row['cs_from'],
            'cs_type' => $row['cs_type'],
            'cs_note' => htmlUnCode($row['cs_note']),
            'cs_claimFrom' => $row['cs_claimFrom'],
            'allowedit' => $row['allowedit']
        ];
    } else {
        echo "<script>alert('客户不存在或你没权限查看！');history.back();</script>";
        exit;
    }
} else {
    echo "<script>alert('客户不存在!');history.back();</script>";
    header("Location: $hrefstr");
    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 src="system/js/jquery-1.7.2.min.js"></script>
    <script src="js/js.js"></script>
    <script src="js/xheditor-1.1.9/xheditor-1.1.9-zh-cn.min.js"></script>
    <script src="js/Hz2Py-szm-min.js"></script>
    <script src="js/ySearchSelect.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>
    <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">
    <form name="form1" id="form1" method="post" action="customerSave.php<?= $hrefstr ?>" onSubmit="return checkInput();">
        <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="<?= htmlspecialcharsFix($customer['cs_code']) ?>" 
                            <?= !empty($customer['cs_claimFrom']) ? 'readonly' : '' ?> class="txt1" />
                        <input type="hidden" name="id" value="<?= $id ?>" />
                        <input type="hidden" name="cs_addtime" value="<?= $customer['cs_addtime'] ?>" />
                        <input type="hidden" name="Permissions" value="<?= $customer['allowedit'] ?>" />
                    </td>
                </tr>
                <tr>
                    <th width="8%">公司名称</th>
                    <td><input type="text" id="cs_company" name="cs_company" value="<?= htmlspecialcharsFix($customer['cs_company']) ?>" class="txt1" /></td>
                </tr>
                <tr>
                    <th width="8%">联系人</th>
                    <td><input type="text" id="cs_name" name="cs_name" value="<?= htmlspecialcharsFix($customer['cs_name']) ?>" class="txt1" /></td>
                </tr>
                <tr>
                    <th width="8%">地区</th>
                    <td>
                        <div class="layui-input-inline">
                            <div class="layui-form-select ySearchSelect y1">
                                <div class="layui-input">
                                    <?php
                                    $stmt = $conn->prepare("SELECT id, countryCode, countryName FROM country WHERE id = ?");
                                    $stmt->bind_param("i", $customer['cs_country']);
                                    $stmt->execute();
                                    $countryResult = $stmt->get_result();
                                    if ($countryRow = $countryResult->fetch_assoc()) {
                                        $countryId = $countryRow['id'];
                                        echo htmlspecialcharsFix($countryRow['countryName']);
                                    } else {
                                        echo "请选择";
                                    }
                                    ?>
                                </div>
                                <ul>
                                    <?php
                                    $result = $conn->query("SELECT id, countryCode, countryName FROM country");
                                    while ($row = $result->fetch_assoc()) {
                                        echo "<li class=\"on\" data-c=\"{$row['id']}\">(+{$row['countryCode']}){$row['countryName']}</li>";
                                    }
                                    ?>
                                    <p>无匹配项</p>
                                </ul>
                                <input name="cs_country" id="cs_country" value="<?= $countryId ?? '' ?>" type="hidden">
                            </div>
                        </div>
                        <script>
                            $(function () {
                                $(".y1").ySearchSelect();  
                            })
                        </script>
                    </td>
                </tr>
                <tr>
                    <th width="8%">客户来源</th>
                    <td>
                        <select id="cs_from" name="cs_from">
                            <option value="0">请选择来源</option>
                            <?php
                            $result = $conn->query("SELECT id, ch_name FROM qudao");
                            while ($row = $result->fetch_assoc()) {
                                $selected = ($customer['cs_from'] == $row['id']) ? ' selected="selected"' : '';
                                echo "<option value=\"{$row['id']}\"$selected>{$row['ch_name']}</option>";
                            }
                            ?>
                        </select>
                    </td>
                </tr>
                <tr>
                    <th rowspan="7">联系方式</th>
                    <td><input type="text" id="cs_tel" name="cs_tel" value="<?= htmlspecialcharsFix($customer['cs_tel']) ?>" class="txt1 tel" placeholder="电话格式:区号+号码 如:+86 15012345678" /></td>
                </tr>
                <tr>
                    <td><input type="text" id="cs_wechat" name="cs_wechat" value="<?= htmlspecialcharsFix($customer['cs_wechat']) ?>" class="txt1 wechat" placeholder="微信"/></td>
                </tr>
                <tr>
                    <td><input type="text" id="cs_whatsapp" name="cs_whatsapp" value="<?= htmlspecialcharsFix($customer['cs_whatsapp']) ?>" class="txt1 whatsapp" placeholder="Whatsapp 格式:区号+号码 如:+86 15012345678"/></td>
                </tr>
                <tr>
                    <td><input type="text" id="cs_email" name="cs_email" value="<?= htmlspecialcharsFix($customer['cs_email']) ?>" class="txt1 mail" placeholder="邮件" /></td>
                </tr>
                <tr>
                    <td><input type="text" id="cs_linkedin" name="cs_linkedin" value="<?= htmlspecialcharsFix($customer['cs_linkedin']) ?>" class="txt1 linkedin" placeholder="领英链接"/></td>
                </tr>
                <tr>
                    <td><input type="text" id="cs_facebook" name="cs_facebook" value="<?= htmlspecialcharsFix($customer['cs_facebook']) ?>" class="txt1 facebook" placeholder="Facebook" /></td>
                </tr>
                <tr>
                    <td><input type="text" id="cs_alibaba" name="cs_alibaba" value="<?= htmlspecialcharsFix($customer['cs_alibaba']) ?>" class="txt1 alibaba" placeholder="alibaba" /></td>
                </tr>
                <tr>
                    <th width="8%">地址</th>
                    <td><input type="text" id="cs_address" name="cs_address" value="<?= htmlspecialcharsFix($customer['cs_address']) ?>" class="txt1" /></td>
                </tr>
                <tr>
                    <th>业务类型</th>
                    <td>
                        <?php
                        $result = $conn->query("SELECT id, businessType FROM clienttype");
                        while ($row = $result->fetch_assoc()) {
                            $checked = ($row['id'] == $customer['cs_type']) ? ' checked="checked"' : '';
                            echo "<input type=\"radio\" name=\"cs_type\" value=\"{$row['id']}\" id=\"fortype{$row['id']}\"$checked>
                                  <label for=\"fortype{$row['id']}\">{$row['businessType']}</label>";
                        }
                        ?>
                    </td>
                </tr>
                <tr>
                    <th>跟进阶段</th>
                    <td>
                        <?php
                        $dealOptions = [
                            ['id' => '0', 'label' => '无响应'],
                            ['id' => '1', 'label' => '背景调查'],
                            ['id' => '2', 'label' => '明确需求'],
                            ['id' => '3', 'label' => '已成交']
                        ];
                        
                        foreach ($dealOptions as $option) {
                            $checked = ($customer['cs_deal'] == $option['id']) ? ' checked="checked"' : '';
                            $disabled = ($customer['cs_deal'] == '3' && $option['id'] != '3') ? ' disabled="disabled"' : '';
                            echo "<input type=\"radio\" id=\"fordeal{$option['id']}\" class=\"cs_deal\" name=\"cs_deal\" 
                                  value=\"{$option['id']}\"$checked$disabled><label for=\"fordeal{$option['id']}\">{$option['label']}</label>";
                        }
                        ?>
                    </td>
                </tr>
                <tr>
                    <th>其他</th>
                    <td>
                        <input type="checkbox" id="belongClient" class="cs_belongClient" name="cs_belongClient" 
                            value="1"<?= $customer['cs_belongclient'] == 1 ? ' checked="checked"' : '' ?>>
                        <label for="belongClient">客户的客户</label>
                    </td>
                </tr>
                <tr>
                    <th>自定义标签</th>
                    <td>
                        <div class="taglist">
                            <?php
                            $stmt = $conn->prepare("SELECT id, tagName FROM tagtable WHERE customerId = ?");
                            $stmt->bind_param("i", $id);
                            $stmt->execute();
                            $result = $stmt->get_result();
                            while ($row = $result->fetch_assoc()) {
                                echo "<span>" . htmlspecialcharsFix($row['tagName']) . "</span>";
                            }
                            ?>
                        </div>
                        <div class="commontag">
                            <i class="tag">美特柏品牌客户</i>,
                            <i class="tag">OEM定制客户</i>,
                            <i class="tag">小型B端客户</i>,
                            <i class="tag">C端客户</i>,
                            <i class="tag">贸易公司</i>，
                            <i class="tag">档口客户</i>
                            <?php
                            $stmt = $conn->prepare("SELECT DISTINCT tagName FROM tagtable WHERE employeeId = ?");
                            $stmt->bind_param("i", $_SESSION['employee_id']);
                            $stmt->execute();
                            $result = $stmt->get_result();
                            while ($row = $result->fetch_assoc()) {
                                echo "<i class=\"tag\">" . htmlspecialcharsFix(textUncode($row['tagName'])) . "</i>,";
                            }
                            ?>
                        </div>
                        <input type="text" id="tapinput" class="txt-short" placeholder="自定义标签，按Enter添加">
                        <input type="hidden" id="mytag" name="mytag" value="">
                    </td>
                </tr>
                <tr>
                    <th width="8%">备注</th>
                    <td><textarea name="cs_note" class="txt2"><?= htmlspecialcharsFix($customer['cs_note']) ?></textarea></td>
                </tr>
                <tr>
                    <th></th>
                    <td>
                        <input type="button" name="save" id="save" value="确定" class="btn1" onclick="subform();">
                        <input type="button" value="返回" class="btn1" onClick="location.href='customers.php<?= $hrefstr ?>'" />
                    </td>
                </tr>
            </tbody>
        </table>
    </form>
</div>
</body>
</html>