-
Notifications
You must be signed in to change notification settings - Fork 34
/
DM_crm.php
105 lines (104 loc) · 7.34 KB
/
DM_crm.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
<?php
set_time_limit(600);
session_start();
date_default_timezone_set('Asia/Shanghai');
header("Content-type: text/html; charset=utf-8");
if (empty($_SESSION['domainid']))
die("没有登录！请先登录系统！");
include_once 'DM_db.php';
if (!empty($_POST['ph'])){
$id = intval($_POST['id']);
if (!$id){ //如果是新插入数据，需要多验证一下是否这个数据存在！因为本页是ajax提交post的，新数据被提交后页面不刷新再次提交就会重复提交！
$result = $mysqli->prepare("select `id` from fs_crm where `phone`=? and `domainid`=?");
$result->bind_param('ss', $_POST['ph'],$_SESSION['domainid']);
$result->execute();
$result->bind_result($id);
$result->fetch();
}
if ($id){
$sql = "update fs_crm set `phone`=?,`name`=?,`sex`=?,`age`=?,`place`=?,`job`=?,`memo`=?,`edu`=?,`last_modi`=? where id = $id";
}else{
$sql = "insert into fs_crm (`phone`,`name`,`sex`,`age`,`place`,`job`,`memo`,`edu`,`last_modi`,`domainid`) values (?,?,?,?,?,?,?,?,?,'$_SESSION[domainid]')";
}
$result = $mysqli->prepare($sql);
$result->bind_param('ssissssss', $_POST['ph'],$_POST['name'],$_POST['sex'],$_POST['age'],$_POST['place'],$_POST['job'],$_POST['memo'],$_POST['edu'],$_SESSION['lmxccusers']);
$result->execute();
if (!$id)
if ($result->insert_id){
die("$result->insert_id");
}else
die("操作没有成功！请重试");
else die("$id");
}elseif ($_POST){
die("没有提交电话号码！");
}
$autolabel = "";
$ph = !empty($_GET['callto'])?$_GET['callto']:"";
if (!empty($_GET['account']))
$account = intval($_GET['account']);
else
$account = 0;
if (!$account){
$account = "信息联动...";
$url = "DM_call_list.php?account=0";
}else{
if (!empty($_GET['auto'])){
$url = "DM_call_list.php?auto=1&account=$account";
$autolabel = " checked=\"checked\" ";
}else
$url = "DM_call_list.php?auto=0&account=$account";
}
$msg = $name = $age = $place = $job = $memo = $edu = $last_mod ="";
$last_time = $sex = $id = 0;
if ($ph){
$result = $mysqli->prepare("select `phone`,`name`,`sex`,`age`,`place`,`job`,`memo`,`edu`,`last_time`,`last_modi`,`id` from fs_crm where `phone` = ? and `domainid`='$_SESSION[domainid]'");
$result->bind_param('s', $ph);
$return = $result->execute();
if ($return){
$result->bind_result($ph,$name,$sex,$age,$place,$job,$memo,$edu,$last_time,$last_mod,$id);
$result->fetch();
}
if ($id)
$msg .=" 已发现记录，可修改更新： ";
else
$msg .=" 未发现记录，将添加信息： ";
}
$time = time();
$date_now = date("Y-m-d%20H:i:s",$time);
$date_end = date("Y-m-d%20H:i:s",$time-259200);
echo <<<HTML
<!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"/>
<link rel="stylesheet" type="text/css" href="css/main.css"/><script type="text/javascript" src="css/jquery.js"></script><script type="text/javascript" src="css/jquery.form.js"></script>
<script> function ajaxSubmitForm() {
var option = {
url : 'DM_crm.php?callto=$ph', type : 'POST',//dataType : 'json',
headers : {"ClientCallMode" : "ajax"}, //添加请求头部
success : function(data) {if (isNaN(data)) { alert("【错误】"+data); $("#labelcid").text(data);} else{ alert("【成功】保存信息成功！"); $("#cid").val(data);}},
error: function(data) { alert("【失败】"+data); }
};
if (a) $("#client_add").ajaxSubmit(option);
return false;
}
var a=0;
function gopage(){ a = parseInt($('#account').val()); if (a) window.location="?account="+a;};
function gophone(){ a = parseInt($('#phone').val()); if (a) window.location="?account=$account&callto="+a;};
function changed() { a = 1; };
function getauto() { a = $('#autoget').prop('checked'); if (a) $('#inframe').attr("src","$url&auto=1"); else $('#inframe').attr("src","$url&auto=0"); };
</script>
</head><body onunload="ajaxSubmitForm()">
HTML;
$submit = "<input class=\"btn-green\" type=\"button\" value=\"提交保存\" onclick=\"ajaxSubmitForm();\"/>";
$showinfo = "<form method='post' id=\"client_add\" onsubmit=\"return false;\"><div id=\"labelcid\" style=\"text-align:center;margin-top:10px;font-size:12pt;color:red;\">".($last_time?"<span class='smallsize-font'> 【$last_mod 于 $last_time 提交】 </span>":"")." <span style='color:gray;'>修改信息后请保存！» </span>$submit</div><input id=\"cid\" name=\"id\" type=\"hidden\" value=\"$id\"/>";
$showinfo .= <<<HTML
<div style="margin-top:10px;font-size:12pt;text-align:center;">电话号码：<input id='ph' name='ph' value='$ph' class='input-blue' size=9><span style="font-size:9pt;"> 话单：<a href="DM_cdr_list.php?startdate=$date_now&enddate=$date_end&phone0=$ph" target="_blank">主叫</a> <a href="DM_cdr_list.php?startdate=$date_now&enddate=$date_end&phone=$ph" target="_blank">被叫</a></span> 称呼：<input id='name' name='name' value='$name' class='input-blue' size=7 onchange='changed();'> 性别：<label><input name="sex" id="sex0" type="radio" value="0" onchange='changed();'> 未知</label> <label><input name="sex" id="sex1" type="radio" value="1" onchange='changed();'> 男</label> <label><input name="sex" id="sex2" type="radio" value="2" onchange='changed();'> 女</label></div>
<div style="margin-top:10px;font-size:12pt;text-align:center;">年龄情况：<input id="age" name="age" class="input-blue" value="$age" size="90" onchange='changed();'/></div>
<div style="margin-top:10px;font-size:12pt;text-align:center;">地区住所：<input id="place" name="place" class="input-blue" value="$place" size="90" onchange='changed();'/></div>
<div style="margin-top:10px;font-size:12pt;text-align:center;">工作职业：<input id="job" name="job" class="input-blue" value="$job" size="90" onchange='changed();'/></div>
<div style="margin-top:10px;font-size:12pt;text-align:center;">素质教育：<input id="edu" name="edu" class="input-blue" value="$edu" size="90" onchange='changed();'/></div>
<div style="margin-top:10px;font-size:12pt;text-align:center;"><textarea id='memo' name='memo' class='input-blue' style='width:600px;height:100px;' placeholder="* 本处可记录对方的相关意向、是否有反馈等信息 *" onchange='changed();'>$memo</textarea></div>
</form>
<script>$('#sex$sex').prop("checked",true);</script>
HTML;
echo '<p class=\'pcenter\' style=\'font-size:18pt;\'>顾客信息 <span style=\'font-size:12pt;\'>坐席ID：<input id="account" name="account" value="'.$account.'" class="inputline1" size="6" onclick="select();"> <button onclick="gopage();"> >开始 </button><label><input id="autoget" name="autoget" type="checkbox" value="1" '.$autolabel.' onclick="getauto();">自动</label></span> <span style=\'font-size:12pt;\'>查号码：<input id="phone" name="phone" value="'.$ph.'" class="inputline1" size="8" onclick="select();"> <button onclick="gophone();"> >查看 </button></span> <a href="?account='.$account.'" style="font-size:9pt;">【刷新页面】</a></p><table class="tablegreen" width="1260" align="center"><tr><th><div id="message">'.$msg.'</div></th></tr><tr><td>'.$showinfo.'</td></tr><tr><td><iframe src="'.$url.'" width="1260" height="650" frameborder="0" id="inframe"/></td></tr></table></body></html>';