<?php
|
//分页信息
|
$page=empty($_REQUEST['page'])!=false ? 1 : $_REQUEST['page'];
|
$QuantityInt = 20; //每页显示数量
|
$acc1=$page; //当前页数
|
$acc2=0; //总页数
|
$acc3=0; //总记录数
|
|
//查询条件
|
$searchSql="";
|
$searchTXT=empty($searchTXT)!=false ? "" : $searchTXT;
|
if ($searchTXT!=""){
|
$searchSql=" and (OA_Name like '%$searchTXT%') ";
|
}else{
|
$searchSql="";
|
}
|
|
$orderby=empty($orderby)!=false ? "" : $orderby;
|
If (strrpos($orderby," desc")>1){
|
$orderbydesc="";
|
$descTXT="↓";
|
}else{
|
$orderbydesc=" desc";
|
$descTXT="↑";
|
}
|
|
If ($orderby=="") {
|
$orderby="OA_DepartmentID,OA_User_ID";
|
$descTXT="↓";
|
}
|
|
if ($OrdDateType=="0" and $OrdDateStart=="" and $OrdDateEnd=="") {$OrdDateType=4;}
|
|
//查询开始
|
$SqlOrdDateType=empty($SqlOrdDateType)!=false ? "" : " and ServiceOrd_CC_Time ".$SqlOrdDateType;
|
$sql="select * from (select UserID,UserName,UserPhone,UserNickName,UserRegisterTime=convert(varchar(21),UserRegisterTime,120),UserLoginTime=convert(varchar(21),UserLoginTime,120),RecommendUserID,RecommendName=(select ISNULL(ISNULL(UserName,UserNickName),UserPhone) from UserData as b where b.UserID=a.RecommendUserID),RecommendInt=(select count(UserID) from UserData as b where b.RecommendUserIDs like '%,'+convert(varchar(10),a.UserID)+',%'),RecommendOrdInt=(select count(ServiceOrdUserID) from ServiceOrder where ServiceOrd_CC_Time>=RecommendTime and ServiceOrdUserID in (select UserID from UserData as b where b.RecommendUserIDs like '%,'+convert(varchar(10),a.UserID)+',%')".$SqlOrdDateType." and ServiceOrdState in (3)),RecommendOrdPrice=(select isnull(SUM(ServiceOrdTraTxnPrice),0) from ServiceOrder where ServiceOrd_CC_Time>=RecommendTime and ServiceOrdUserID in (select UserID from UserData as b where b.RecommendUserIDs like '%,'+convert(varchar(10),a.UserID)+',%')".$SqlOrdDateType." and ServiceOrdState in (3))
|
from UserData as a,weixinQR where QR_Key=UserID and QR_type=4) as SQLDate order by RecommendOrdInt desc,RecommendInt desc,RecommendOrdPrice desc";
|
//echo $sql;exit;
|
$data = sqlsrv_query($conn,$sql);
|
if($data == true){
|
$FormArray=array();
|
//表头
|
$FormArray[0]=array("用户ID","姓名","电话","注册时间","最后登陆时间","推荐人","下线会员","下线订单数量","下线订单金额");
|
$FormArrayX=count($FormArray[0]);
|
if (sqlsrv_rows_affected($data)==0) {
|
$SystemMessageType=2;
|
$SystemMessageTXT="数据库中相关无数据！";
|
$y=0;
|
} else {
|
$i=1;
|
$OA_User_ID_Old=0;
|
$Dete_OrdDistance=0;
|
$Dete_OT_OrdDistance=0;
|
$Dete_OrdInt=0;
|
$Dete_OT_OrdInt=0;
|
$EntourageBetimesHHInt=0;
|
$Dete_DKPMoney=0;
|
$Dete_OT_DKPMoney=0;
|
while($rs = sqlsrv_fetch_array( $data, SQLSRV_FETCH_ASSOC) ) {
|
//读取数据
|
$UserID = $rs['UserID'];
|
$UserName = $rs['UserName'];
|
$UserPhone = $rs['UserPhone'];
|
$UserNickName = $rs['UserNickName'];
|
$UserRegisterTime = $rs['UserRegisterTime'];
|
$UserLoginTime = $rs['UserLoginTime'];
|
$RecommendUserID = $rs['RecommendUserID'];
|
$RecommendName = $rs['RecommendName'];
|
$RecommendInt = $rs['RecommendInt'];
|
$RecommendOrdInt = $rs['RecommendOrdInt'];
|
$RecommendOrdPrice = ceil($rs['RecommendOrdPrice']);
|
if ($UserName=='') {$UserName=$UserNickName;}
|
|
|
|
//写入数组
|
$FormArray[$i][0]=$UserID;
|
$FormArray[$i][1]=$UserName;
|
$FormArray[$i][2]=$UserPhone;
|
$FormArray[$i][3]=$UserRegisterTime;
|
$FormArray[$i][4]=$UserLoginTime;
|
if ($RecommendName!='') {$FormArray[$i][5]=$RecommendName;} else {$FormArray[$i][5]="--";}
|
$FormArray[$i][6]=$RecommendInt;
|
$FormArray[$i][7]=$RecommendOrdInt;
|
$FormArray[$i][8]=$RecommendOrdPrice;
|
$i++;
|
//写入数组--End
|
|
|
//读取数据--End
|
}
|
|
}
|
}
|
|
if ($is_CSV==2) {
|
echo json_encode($FormArray);
|
}
|
//echo print_r($FormArray);
|
//exit;
|
?>
|
