<?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="UserOrderList";?>
|
<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
|
$method='ServiceOrder_List';
|
$DateStart=empty($_REQUEST['DateStart'])!=false ? date("Y/m/d", strtotime("-365 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;
|
//表列汇总
|
$OrderTotal=0;
|
$OrdTotalState1=0;
|
$OrdTotalState2=0;
|
//已推荐人数
|
$sql="select count(UserID) from UserData where RecommendUserIDs like '%,".$AdminUserID.",%'";
|
$data = sqlsrv_query($conn,$sql);
|
if($data == true){
|
if (sqlsrv_rows_affected($data)!=0) {
|
while($rs = sqlsrv_fetch_array($data) ) {
|
$OrdTotalState1 = ceil($rs[0]);
|
}
|
}
|
}
|
|
//下单金额
|
$sql="select isnull(SUM(ServiceOrdTraTxnPrice),0) from ServiceOrder where ServiceOrdUserID in (select UserID from UserData where RecommendUserIDs like '%,".$AdminUserID.",%') and ServiceOrdState not in (4) and ServiceOrd_CC_Time BETWEEN '$DateStart' and '$DateEnd'";
|
$data = sqlsrv_query($conn,$sql);
|
if($data == true){
|
if (sqlsrv_rows_affected($data)!=0) {
|
while($rs = sqlsrv_fetch_array($data) ) {
|
$OrdTotalState2 = ceil($rs[0]);
|
}
|
}
|
}
|
if ($OrderTotal==0) {$OrderTotal=1;}
|
|
|
?>
|
|
<!--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 info box-->
|
<div class="col-md-20 col-sm-6">
|
<div class="info-box-main" id="OrdState1" style="cursor: pointer;">
|
<div class="info-stats">
|
<p><?php echo $OrdTotalState1;?></p>
|
<span>已推荐人数</span>
|
</div>
|
<div class="info-icon text-primary ">
|
<i class="mdi mdi-clipboard-outline"></i>
|
</div>
|
<div class="info-box-progress">
|
<div class="progress">
|
<div class="progress-bar progress-bar-primary" role="progressbar" aria-valuenow="48" aria-valuemin="0" aria-valuemax="100" style="width: <?php echo ceil($OrdTotalState1/$OrderTotal);?>%;">
|
</div>
|
</div>
|
</div>
|
</div>
|
</div>
|
<!--End info box-->
|
|
<!--Start info box-->
|
<div class="col-md-20 col-sm-6">
|
<div class="info-box-main" id="OrdState2" style="cursor: pointer;">
|
<div class="info-stats">
|
<p><?php echo $OrdTotalState2;?></p>
|
<span>近一年下单金额</span>
|
</div>
|
<div class="info-icon text-warning">
|
<i class="mdi mdi-clipboard-text"></i>
|
</div>
|
<div class="info-box-progress">
|
<div class="progress">
|
<div class="progress-bar progress-bar-warning" role="progressbar" aria-valuenow="48" aria-valuemin="0" aria-valuemax="100" style="width: <?php echo ceil($OrdTotalState2/$OrderTotal);?>%;">
|
</div>
|
</div>
|
</div>
|
</div>
|
</div>
|
<!--End info box-->
|
|
</div>
|
<!--End row-->
|
|
<!--Start row-->
|
<div class="row">
|
|
<!-- Start inbox widget-->
|
<div class="col-md-12">
|
<div class="white-box">
|
<h2 class="header-title"> 任务单记录(最近一年) </h2>
|
<div class="table-responsive">
|
<!--
|
<form class="form-horizontal" method="post" id="OrderListSearch" action="?">
|
<input type="hidden" name="DateStart" id="DateStart" value="<?php echo $DateStart;?>">
|
<input type="hidden" name="DateEnd" id="DateEnd" value="<?php echo $DateEnd;?>">
|
<input type="hidden" name="OrdState" id="OrdState" value="<?php echo $OrdState;?>">
|
<div class="form-group">
|
<div class="col-md-8">
|
<div id="reportrange" class="pull-left form-control" style="max-width: 450px;">
|
<i class="glyphicon glyphicon-calendar fa fa-calendar"></i>
|
<span></span>
|
</div>
|
</div>
|
</div>
|
</form>
|
-->
|
<table class="table table-hover">
|
<thead>
|
<tr>
|
<!--<th>#</th>-->
|
<th>日期</th>
|
<th>金额</th>
|
<th>姓名</th>
|
<th>状态</th>
|
</tr>
|
</thead>
|
<tbody>
|
<?php
|
//表列内容
|
$i=0;
|
$sql="select ServiceOrdID,OrdDate=convert(varchar(21),ServiceOrd_CC_Time,111),ServiceOrdUserID,ServiceOrdState,DispatchOrdState=isnull(DispatchOrdState,-1),ServiceOrdTraTxnPrice,NoteName,ServiceOrdCoName,ServiceOrdCoPhone,UserData.RecommendUserID,RecommendUserIDs from UserData LEFT JOIN UserRecommendNote on ToUserID=UserID and ToRUserID=RecommendUserID,ServiceOrder LEFT JOIN DispatchOrd ON ServiceOrdIDDt=ServiceOrdID and DispatchOrdState<>'10' where UserID=ServiceOrdUserID and RecommendUserIDs like '%,".$AdminUserID.",%' and ServiceOrdState not in (4) and ServiceOrd_CC_Time BETWEEN '$DateStart' and '$DateEnd' order by ServiceOrd_NS_Time 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);
|
}else{
|
$UserName=$rs["ServiceOrdCoName"];
|
}
|
?>
|
<tr>
|
<!--<td><?php echo $i+(($page_no-1)*$page_size);?></td>-->
|
<td><?php echo $rs["OrdDate"];?></td>
|
<td><?php echo ceil($rs["ServiceOrdTraTxnPrice"]);?></td>
|
<td><?php echo $UserName;?></td>
|
<td>
|
<?php
|
if ($rs["ServiceOrdState"]==1){
|
echo "<span class='label label-primary'>咨询</span>";
|
}elseif ($rs["ServiceOrdState"]==2){
|
echo "<span class='label label-warning'>未调度</span>";
|
}elseif ($rs["ServiceOrdState"]==3){
|
$DispatchState=$rs["DispatchOrdState"];
|
if ($DispatchState==8){
|
echo "<span class='label label-success'>订单完成</span>";
|
}elseif ($DispatchState==9 or $DispatchState==10) {
|
echo "<span class='label label-danger'>跑空取消</span>";
|
}else{
|
echo "<span class='label label-966120'>转运中</span>";
|
}
|
}elseif ($rs["ServiceOrdState"]==4){
|
echo "<span class='label label-danger'>无效取消</span>";
|
}
|
?>
|
</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-daterangepicker/daterangepicker.js"></script>
|
<script>
|
// Time Picker
|
|
$('#reportrange span').html('<?php echo $DateStart;?> - <?php echo $DateEnd;?>');
|
|
$('#reportrange').daterangepicker({
|
format: 'YYYY/MM/DD',
|
startDate: "<?php echo date('m/d/Y',strtotime($DateStart));?>",
|
endDate: "<?php echo date('m/d/Y',strtotime($DateEnd));?>",
|
minDate: '01/01/2016',
|
maxDate: '12/31/2025',
|
showDropdowns: true,
|
showWeekNumbers: true,
|
timePicker: false,
|
timePickerIncrement: 1,
|
timePicker12Hour: true,
|
ranges: {
|
'今天': [moment(), moment()],
|
'昨天': [moment().subtract(1, 'days'), moment().subtract(1, 'days')],
|
'最近7天': [moment().subtract(6, 'days'), moment()],
|
'最近30天': [moment().subtract(29, 'days'), moment()],
|
'本月': [moment().startOf('month'), moment().endOf('month')],
|
'上月': [moment().subtract(1, 'month').startOf('month'), moment().subtract(1, 'month').endOf('month')]
|
},
|
opens: 'left',
|
drops: 'down',
|
buttonClasses: ['btn', 'btn-sm'],
|
applyClass: 'btn-default',
|
cancelClass: 'btn-white',
|
separator: ' to ',
|
locale: {
|
applyLabel: '确定',
|
cancelLabel: '取消',
|
fromLabel: 'From',
|
toLabel: 'To',
|
customRangeLabel: '自定义',
|
daysOfWeek: ['一', '二', '三', '四', '五', '六', '日'],
|
monthNames: ['一月', '二月', '三月', '四月', '五月', '六月', '七月', '八月', '九月', '十月', '十一月', '十二月'],
|
firstDay: 1
|
}
|
}, function (start, end, label) {
|
//console.log(start.toISOString(), end.toISOString(), label);
|
if (start.format('YYYY/MM/DD')!=end.format('YYYY/MM/DD'))
|
{
|
$('#reportrange span').html(start.format('YYYY/MM/DD') + ' - ' + end.format('YYYY/MM/DD'));
|
}else{
|
$('#reportrange span').html(start.format('YYYY/MM/DD'));
|
}
|
$('#DateStart').val(start.format('YYYY/MM/DD'));
|
$('#DateEnd').val(end.format('YYYY/MM/DD'));
|
$('#OrderListSearch').submit()
|
|
});
|
</script>
|
|
<script>
|
//--按钮操作--BEGIN
|
|
//列表分页
|
$('button[name="page_no"]').click(function(){
|
DateStart=$('#DateStart').val();
|
DateEnd=$('#DateEnd').val();
|
OrdState=$('#OrdState').val();
|
page_no=$(this).text();
|
window.location.href="?DateStart="+DateStart+"&DateEnd="+DateEnd+"&OrdState="+OrdState+"&page_no="+page_no;
|
});
|
|
//分类列表提交
|
$('#OrdState1').click(function(){
|
DateStart=$('#DateStart').val();
|
DateEnd=$('#DateEnd').val();
|
window.location.href="UserList.php";
|
});
|
/*
|
$('#OrdState2').click(function(){
|
DateStart=$('#DateStart').val();
|
DateEnd=$('#DateEnd').val();
|
window.location.href="?DateStart="+DateStart+"&DateEnd="+DateEnd+"&OrdState=2";
|
});
|
*/
|
|
//--按钮操作--End
|
</script>
|
|
<!-- End PAGE 页面JS -->
|
|
</body>
|
|
</html>
|
