//今日新增
$today = "and createdate>='{$to_sta_date}' and createdate<'{$to_end_date}'";
$sql_today = "select COUNT(*) AS NUM from customer where 1=1 {$today}";
$sql_today = getCustomerRoleByUser($sql_today, "sysuser");
//echo $sql_today."<br>";
$rs = $db->CacheExecute(150, $sql_today);
$rs_today = $rs->fields['NUM'];
//本周新增
$thisweek = "and createdate>='{$week_sta_date}'";
$sql_week = "select COUNT(*) AS NUM from customer where 1=1 {$thisweek}";
$sql_week = getCustomerRoleByUser($sql_week, "sysuser");
$rs = $db->CacheExecute(150, $sql_week);
$rs_week = $rs->fields['NUM'];
//本月新增
$thismonth = "and createdate>='{$month_sta_date}'";
$sql_mon = "select COUNT(*) AS NUM from customer where 1=1 {$thismonth}";
$sql_mon = getCustomerRoleByUser($sql_mon, "sysuser");
$rs = $db->CacheExecute(150, $sql_mon);
$rs_mon = $rs->fields['NUM'];
//本年新增
$thisyear = "and createdate>='{$year_sta_date}'";
$sql_year = "select COUNT(*) AS NUM from customer where 1=1 {$thisyear}";
$sql_year = getCustomerRoleByUser($sql_year, "sysuser");
$rs = $db->CacheExecute(150, $sql_year);
$rs_year = $rs->fields['NUM'];
$module_body .= "<table border=0 width=100% height=100%>";
$module_body .= "<tr class=TableBlock>\n\t\t\t\t<td valign=bottom align=left>\n\t\t\t\t<img src=\"../images/node_user.gif\" align=\"absmiddle\"> <a href=../../JXC/customer_newai.php?action=init_default target=_blank>客户总量 ( " . number_format($rs_con, 0, '', ',') . " ) 个\n\t\t\t\t</td>\n\t\t\t\t</tr>\n\t\t\t\t<tr class=TableBlock>\n\t\t\t\t<td valign=bottom align=left>\n\t\t\t\t<img src=\"../images/node_user.gif\" align=\"absmiddle\"> <a href=../../JXC/customer_newai.php?action=init_default&desksearch=" . urlencode($today) . " target=_blank>今日新增 ( " . number_format($rs_today, 0, '', ',') . " ) 个</a>\n\t\t\t\t</td>\n\t\t\t\t<td valign=bottom align=left>\n\t\t\t\t<img src=\"../images/node_user.gif\" align=\"absmiddle\"> <a href=../../JXC/customer_newai.php?action=init_default&desksearch=" . urlencode($thisweek) . " target=_blank>本周新增 ( " . number_format($rs_week, 0, '', ',') . " ) 个</a>\n\t\t\t\t</td>\n\t\t\t\t</tr>\n\t\t\t\t<tr class=TableBlock>\n\t\t\t\t<td valign=bottom align=left>\n\t\t\t\t<img src=\"../images/node_user.gif\" align=\"absmiddle\"> <a href=../../JXC/customer_newai.php?" . base64_encode("action=init_default&desksearch=" . urlencode($thismonth)) . " target=_blank>本月新增 ( " . number_format($rs_mon, 0, '', ',') . " ) 个</a>\n\t\t\t\t</td>\n\t\t\t\t<td valign=bottom align=left>\n\t\t\t\t<img src=\"../images/node_user.gif\" align=\"absmiddle\"> <a href=../../JXC/customer_newai.php?action=init_default&desksearch=" . urlencode($thisyear) . " target=_blank>本年新增 ( " . number_format($rs_year, 0, '', ',') . " ) 个</a>\n\t\t\t\t</td>\n\t\t\t\t\n\t\t\t\t</tr>";
$module_body .= "<form action=\"../../JXC/customer_newai.php\" name=\"form1\" method=\"get\">";
$module_body .= "<tr class=TableBlock>\n\t\t\t\t\t\t<td valign=Middle align=left> 客户名称：<input type=\"text\" name=\"searchvalue\" class=\"SmallInput\" size=\"26.5\" maxlength=\"25\">\n\t\t\t\t\t\t<input type=hidden name='action' value='init_default_search'>\n\t\t\t\t\t\t\t<input type=hidden name='searchfield' value='supplyname'>\n\t\t\t\t\t\t\t <input type=\"submit\" value=\"查询\" class=\"SmallButton\" title=\"模糊查询\" name=\"button\">\n\t\t\t\t\t\t </td></tr></form>";
$module_body .= "</table>";
echo $module_body;
}
function borderize_off(id)
{
targetelement=document.getElementById(id);
if(targetelement.className.indexOf("TableRowActive") >= 0)
targetelement.className = 'menulines';
}
</script>
</head>
<body class="bodycolor" topmargin="1" leftmargin="0" >
<?php
$showfield = $_GET['showfield'];
$AddSql = $AddSql . " where 1=1";
//添加权限条件
$AddSql = getCustomerRoleByUser($AddSql, "sysuser");
//添加名称、拼音码搜索条件
if ($_GET['action'] == "SEARCH") {
$KEYVALUE = $_GET['KEYVALUE'];
$AddSql = $AddSql . " and (a.supplyname like '%{$KEYVALUE}%' or a.calling like '%{$KEYVALUE}%' or b.linkmanname like '%{$KEYVALUE}%' or b.linkmanpy like '%{$KEYVALUE}%')";
}
echo "<table class=\"TableBlock\" width=\"100%\"><tr class=TableHeader> <td align=\"center\"><b>客户</b></td><td align=center><b>联系人</b></td><td align=center>{$showfield}</td>\r\n</tr>\r\n\r\n";
$sql = "select a.supplyname,b.linkmanname,b.{$showfield},b.rowid from customer a inner join linkman b on a.rowid=b.customerid {$AddSql} order by supplyname,linkmanname";
$rs = $db->CacheExecute(150, $sql);
$rs_a = $rs->GetArray();
if (sizeof($rs_a) > 0) {
for ($i = 0; $i < sizeof($rs_a); $i++) {
$supplyname = $rs_a[$i]['supplyname'];
$linkman = $rs_a[$i]['linkmanname'];
$sf = $rs_a[$i][$showfield];
$rowid = $rs_a[$i]['rowid'];
print_infor("客户资料已删除", 'trip', "location='?{$return}'", "?{$return}", 0);
exit;
}
for ($i = 0; $i < count($selectid); $i++) {
if ($selectid[$i] != '') {
$billid = returntablefield("sellplanmain", "supplyid", $selectid[$i], "billid");
if ($billid != '') {
$customername = returntablefield("customer", "rowid", $selectid[$i], "supplyname");
print "<script language='javascript'>alert('" . $customername . " 存在合同或销售单记录，请先删除相关单据');window.history.back(-1);</script>";
exit;
}
}
}
}
if ($_GET['action'] == "addlinkman") {
print "<script>location.href='linkman_newai.php?action=add_default&customerid=" . $_GET['ROWID'] . "';</script>";
exit;
}
if ($_GET['action'] == "addcrmvisit") {
print "<script>location.href='crm_contact_newai.php?action=add_default&customerid=" . $_GET['ROWID'] . "';</script>";
exit;
}
$SYSTEM_ADD_SQL = getCustomerRoleByUser($SYSTEM_ADD_SQL, "sysuser");
$limitEditDelUser = '******';
addShortCutByDate("createdate", "创建时间");
//print_r($_SESSION);
//$SYSTEM_ADD_SQL = " and ((sysuser='******'LOGIN_USER_ID']."' and datascope=0) or datascope=1)";
//$SYSTEM_PRINT_SQL=1;
$filetablename = "customer";
require_once "include.inc.php";
systemhelpcontent("客户管理", "100%");
