<?php include "../inc/odbc.php"; ?>
|
<?php include "../inc/function.php"; ?>
|
<?php
|
$WEB_Name="推荐人员列表";
|
?>
|
<!DOCTYPE html>
|
<html>
|
|
<head>
|
<?php require 'ccs.php';?>
|
<title><?php echo $WEB_Name;?></title>
|
|
<!--Begin Page Level CSS -->
|
<link href="assets/plugins/morris-chart/morris.css" rel="stylesheet">
|
<link href="assets/plugins/jquery-ui/jquery-ui.min.css" rel="stylesheet"/>
|
<!--End Page Level CSS -->
|
|
<!-- BEGIN PAGE LEVEL STYLES -->
|
<link href="assets/plugins/bootstrap-daterangepicker/daterangepicker.css" rel="stylesheet">
|
<!-- END PAGE LEVEL STYLES -->
|
</head>
|
<?php $memu="UserLite";?>
|
<body class="sticky-header">
|
<!--Start left side Menu-->
|
<?php require 'menu_left.php';?>
|
<!--End left side menu-->
|
|
<!-- main content start-->
|
<div class="main-content" >
|
|
<!-- header section start-->
|
<?php require 'menu_header.php';?>
|
<!-- header section end-->
|
|
|
<!--body wrapper start-->
|
<div class="wrapper">
|
<?php
|
$DateStart=empty($_REQUEST['DateStart'])!=false ? date("Y/m/d", strtotime("-29 day")) : addslashes($_REQUEST['DateStart']);
|
$DateEnd=empty($_REQUEST['DateEnd'])!=false ? date("Y/m/d") : addslashes($_REQUEST['DateEnd']);
|
$OrdState=empty($_REQUEST['OrdState'])!=false ? 0 : addslashes($_REQUEST['OrdState']);
|
$OrdDateType=0;
|
$page_no=1;
|
$page_size=30;
|
|
|
?>
|
|
<!--Start Page Title-->
|
<!--End Page Title-->
|
|
<!--Start row-->
|
<div class="row">
|
<div class="container">
|
<div class="analytics-box">
|
|
</div>
|
</div>
|
</div>
|
<!--End row-->
|
|
|
|
<!--Start row-->
|
<div class="row">
|
|
<!-- Start inbox widget-->
|
<div class="col-md-12">
|
<div class="white-box">
|
<h2 class="header-title"> 推荐人员列表<?php echo $AdminUserID ;?> </h2>
|
<div class="table-responsive">
|
<table class="table table-hover">
|
<thead>
|
<tr>
|
<!--<th>#</th>-->
|
<th>姓名</th>
|
<th>日期</th>
|
<th>他推荐的</th>
|
</tr>
|
</thead>
|
<tbody>
|
<?php
|
//表列内容
|
$i=0;
|
$sql="select UserID,UserName,NoteName,UserPhone,UserNickName,RecommendTime=CONVERT(varchar(20),RecommendTime,111),sumUser=(select COUNT(UserID) from UserData as b where b.RecommendUserIDs like '%,'+CONVERT(varchar(10),a.UserID)+',%') from UserData as a LEFT JOIN UserRecommendNote on ToUserID=UserID and ToRUserID=RecommendUserID where RecommendUserID=$AdminUserID order by RecommendTime desc";
|
$data = sqlsrv_query($conn,$sql);
|
if($data == true){
|
if (sqlsrv_rows_affected($data)!=0) {
|
while($rs = sqlsrv_fetch_array($data) ) {
|
$i++;
|
if ($rs["NoteName"]!=""){
|
$UserName=substr($rs["NoteName"],0,16);
|
$UserName1=$rs["NoteName"];
|
}elseif ($rs["UserName"]!=""){
|
$UserName=$rs["UserName"];
|
if ($rs["UserNickName"]!=""){
|
if (strlen($rs["UserNickName"])>10) {
|
$UserName1=$UserName."(".$rs["UserNickName"].")";
|
$UserName=$UserName."(".substr($rs["UserNickName"],0,10)."...)";
|
}else{
|
$UserName=$UserName."(".$rs["UserNickName"].")";
|
$UserName1=$UserName;
|
}
|
}
|
}elseif ($rs["UserNickName"]!=""){
|
if (strlen($rs["UserNickName"])>16) {
|
$UserName=substr($rs["UserNickName"],0,16)."...";
|
$UserName1=$rs["UserNickName"];
|
}else{
|
$UserName=$rs["UserNickName"];
|
$UserName1=$UserName;
|
}
|
}else{
|
$UserName="微信用户".substr($rs["UserID"],-4);
|
$UserName1=$UserName;
|
}
|
?>
|
<tr>
|
<td><a data-pk="<?php echo $rs["UserID"];?>" data-value="<?php echo $UserName1;?>" data-emptytext="<?php echo $UserName;?>" data-type="text" data-title="修改备注名称" class="editable editable-click"><?php echo $UserName;?></a></td>
|
<td><?php echo $rs["RecommendTime"];?></td>
|
<td><?php echo $rs["sumUser"];?></td>
|
</tr>
|
<?php }?>
|
<?php }else{?>
|
<br><p style="padding: 10% 0;text-align: center;color:#FF5D5E;">没有找到相关的记录</p>
|
<?php }
|
}?>
|
|
</tbody>
|
</table>
|
</div>
|
|
|
</div>
|
</div>
|
<!-- Start inbox widget-->
|
</div>
|
<!--End row-->
|
|
</div>
|
<!-- End Wrapper-->
|
|
|
|
|
</div>
|
<!--End main content -->
|
|
<?php require 'vicgame.php';?>
|
<!-- BEGIN 页面JS -->
|
<script src="assets/plugins//bootstrap-editable/js/bootstrap-editable.min.js"></script>
|
<script>
|
$(function(){
|
$(".editable-click").editable({
|
url: 'UserList_save.php',
|
type: 'text',
|
name: "NoteName",
|
title: 'Enter username'
|
});
|
});
|
//--按钮操作--End
|
</script>
|
|
<!-- End PAGE 页面JS -->
|
|
</body>
|
|
</html>
|
