<?php
|
$UnitNameID=empty($_REQUEST['UnitNameID'])!=false ? "" : addslashes($_REQUEST['UnitNameID']);
|
|
//分页信息
|
$page=empty($_REQUEST['page'])!=false ? 1 : $_REQUEST['page'];
|
$QuantityInt = 20; //每页显示数量
|
$acc1=$page; //当前页数
|
$acc2=0; //总页数
|
$acc3=0; //总记录数
|
|
//类型列表
|
$ArrayOrdType=array();
|
$sql = "select vID,vtext from dictionary where vtitle='ServiceOrderType' order by vOrder" ;
|
$data = sqlsrv_query($conn,$sql);
|
if($data == true){
|
$i=0;
|
while($rs = sqlsrv_fetch_array( $data, SQLSRV_FETCH_ASSOC) ) {
|
$ArrayOrdType[$rs['vID']]=$rs['vtext'];
|
$i++;
|
}
|
}
|
|
//查看各分公司报表权限
|
if (isDepartment("070109")==1) {
|
$OrdClassListSql="";
|
//$UnitNameID="1";
|
If ($UnitNameID!="" and $UnitNameID!="0") {
|
$sql="select vOrder2 from dictionary where vtitle='UnitName' and vID=".$UnitNameID;
|
$data = sqlsrv_query($conn,$sql);
|
if($data == true){
|
if (sqlsrv_rows_affected($data)!=0) {
|
while($rs = sqlsrv_fetch_array($data) ) {
|
$UnitTypeID = $rs[0];
|
$sql="select vID,vtext,vOrder2 from dictionary where vID in (".$UnitTypeID.") and vtitle='OrderClass' order by vOrder";
|
$data1 = sqlsrv_query($conn,$sql);
|
if($data1 == true){
|
while($rs1 = sqlsrv_fetch_array($data1) ) {
|
$OrderClassID = $rs1['vOrder2'];
|
$OrdClassListSql .= ",".$OrderClassID;
|
}
|
}
|
$OrdClassListSql=substr($OrdClassListSql,1);
|
$OrdClassListSql=str_replace(",","','",$OrdClassListSql);
|
}
|
}
|
}
|
}else{
|
$sql="select vID,vtext,vOrder2 from dictionary where vType in (1,2) and vtitle='OrderClass' order by vOrder";
|
$data1 = sqlsrv_query($conn,$sql);
|
if($data1 == true){
|
while($rs1 = sqlsrv_fetch_array($data1) ) {
|
$OrderClassID = $rs1['vOrder2'];
|
$OrdClassListSql .= ",".$OrderClassID;
|
}
|
}
|
$OrdClassListSql=substr($OrdClassListSql,1);
|
$OrdClassListSql=str_replace(",","','",$OrdClassListSql);
|
}
|
}
|
|
//查询条件
|
$searchSql="";
|
$searchTXT=empty($searchTXT)!=false ? "" : $searchTXT;
|
if ($searchTXT!=""){
|
$searchSql=" and (OA_Name like '%$searchTXT%') ";
|
}else{
|
$searchSql="";
|
}
|
if ($StaffScoreID=="1") {
|
$searchSql=$searchSql." and (Guest_PointE like '%9%' or Guest_PointE like '%8%' or RV_PointE like '%9%' or RV_PointE like '%8%') ";
|
}elseif ($StaffScoreID=="2") {
|
$searchSql=$searchSql." and (Guest_PointE like '%1%' or Guest_PointE like '%2%' or RV_PointE like '%1%' or RV_PointE like '%2%') ";
|
}elseif ($StaffScoreID=="3") {
|
$searchSql=$searchSql." and (Guest_PointE='0' and RV_PointE='0' and ServiceOrdVisit<>'') ";
|
}
|
|
$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 ? "" : $SqlOrdDateType;
|
$OAOccupationSQL=empty($OAOccupation)!=false ? "" : " and EntourageID in (".$OAOccupation.") ";
|
$StaffScoreSum=0;
|
$StaffScoreSum_Bad=0;
|
$StaffScoreSum_Other=0;
|
//汇总查询
|
$sql="select StaffScoreSum=count(DispatchOrdID) from (select DispatchOrdID from DispatchOrd_Entourage,DispatchOrd,ServiceOrder where ServiceOrdID=ServiceOrdIDDt and DispatchOrdID=DispatchOrdIDDt and (Guest_PointE<>'0' or RV_PointE<>'0') and DispatchOrdState in (4,5,6,7,8,9) and EntourageState<>4".$OAOccupationSQL." and ServiceOrdVisit_time ".$SqlOrdDateType." and DispatchOrdClass in ('".$OrdClassListSql."') GROUP BY DispatchOrdID) as aa";
|
//echo $sql;exit;
|
$data = sqlsrv_query($conn,$sql);
|
if($data == true){
|
while($rs = sqlsrv_fetch_array( $data, SQLSRV_FETCH_ASSOC) ) {
|
$StaffScoreSum = $rs['StaffScoreSum'];
|
}
|
}
|
$sql="select StaffScoreSum_Bad=count(DispatchOrdID) from (select DispatchOrdID from DispatchOrd_Entourage,DispatchOrd,ServiceOrder where ServiceOrdID=ServiceOrdIDDt and DispatchOrdID=DispatchOrdIDDt and (Guest_PointE like '%1%' or Guest_PointE like '%2%' or RV_PointE like '%1%' or RV_PointE like '%2%') and DispatchOrdState in (4,5,6,7,8,9) and EntourageState<>4".$OAOccupationSQL." and (ServiceOrdVisit_time ".$SqlOrdDateType." or Guest_Time ".$SqlOrdDateType.") and DispatchOrdClass in ('".$OrdClassListSql."') GROUP BY DispatchOrdID) as aa";
|
//echo $sql;exit;
|
$data = sqlsrv_query($conn,$sql);
|
if($data == true){
|
while($rs = sqlsrv_fetch_array( $data, SQLSRV_FETCH_ASSOC) ) {
|
$StaffScoreSum_Bad = $rs['StaffScoreSum_Bad'];
|
}
|
}
|
$sql="select StaffScoreSum_Other=count(DispatchOrdID) from (select DispatchOrdID from DispatchOrd_Entourage,DispatchOrd,ServiceOrder where DispatchOrdID=DispatchOrdIDDt
|
and ServiceOrdID=ServiceOrdIDDt and Guest_PointE='0' and RV_PointE='0' and ServiceOrdVisit<>'' and DispatchOrdState in (4,5,6,7,8,9) and EntourageState<>4".$OAOccupationSQL." and ServiceOrdVisit_time ".$SqlOrdDateType." and DispatchOrdClass in ('".$OrdClassListSql."') GROUP BY DispatchOrdID) as aa";
|
//echo $sql;exit;
|
$data = sqlsrv_query($conn,$sql);
|
if($data == true){
|
while($rs = sqlsrv_fetch_array( $data, SQLSRV_FETCH_ASSOC) ) {
|
$StaffScoreSum_Other = $rs['StaffScoreSum_Other'];
|
}
|
}
|
|
//查询开始
|
$sql="select OA_User_ID,OA_Name,DispatchOrdID,ServiceOrdID,DispatchOrdNo=DispatchOrdClass+convert(nvarchar(10),year(DispatchOrd_NS_Time))+right('0'+convert(nvarchar(10),month(DispatchOrd_NS_Time)),2)+right('0'+convert(nvarchar(10),day(DispatchOrd_NS_Time)),2)+'-'+right('00'+convert(nvarchar(10),DispatchOrdNo),3),ServiceOrdType,DispatchOrd_NS_Time=convert(char,DispatchOrd_NS_Time,120),Guest_Point_1,Guest_Point_2,Guest_Point_3,Guest_PointE,Guest_Impression,Guest_Evaluate,Guest_Reward,Guest_openid,Guest_Time=convert(char,Guest_Time,120),ServiceOrdReturnChannel,ServiceOrdVisit,ServiceOrdVisit_time=convert(char,ServiceOrdVisit_time,120),RV_Point_1,RV_Point_2,RV_Point_3,RV_PointE,ServiceOrdPtOutHosp=(select vtext from dictionary where vType=1 and vtitle='HospName' and vID=ServiceOrdPtOutHosp),ServiceOrdPtInHosp=(select vtext from dictionary where vType=1 and vtitle='HospName' and vID=ServiceOrdPtInHosp) from DispatchOrd_Entourage,DispatchOrd,OA_User,ServiceOrder where OA_User_ID=EntourageOAid and ServiceOrdID=ServiceOrdIDDt and DispatchOrdID=DispatchOrdIDDt and (Guest_Point_1>0 or Guest_Point_2>0 or Guest_Point_3>0 or Guest_PointE<>'0' or RV_Point_1>0 or RV_Point_2>0 or RV_Point_3>0 or RV_PointE<>'0' or ServiceOrdVisit<>'') and DispatchOrdState in (4,5,6,7,8,9) and EntourageState<>4".$OAOccupationSQL." and (ServiceOrdVisit_time ".$SqlOrdDateType." or Guest_Time ".$SqlOrdDateType.")".$searchSql." and ServiceOrdClass in ('".$OrdClassListSql."') order by OA_User_ID,DispatchOrd_NS_Time";
|
//echo $sql;exit;
|
$data = sqlsrv_query($conn,$sql);
|
if($data == true){
|
$FormArray=array();
|
//表头
|
$FormArray[0]=array("单号","部门","员工姓名","转出医院","转入医院","服务评价","评价内容","获知渠道","打赏","订单时间","评价时间","openid","评价来源");
|
|
$FormArrayX=count($FormArray[0]);
|
if (sqlsrv_rows_affected($data)==0) {
|
$SystemMessageType=2;
|
$SystemMessageTXT="数据库中相关无数据！";
|
$y=0;
|
} else {
|
$i=1;
|
while($rs = sqlsrv_fetch_array( $data, SQLSRV_FETCH_ASSOC) ) {
|
//读取数据
|
$OA_User_ID = $rs['OA_User_ID'];
|
|
$OA_Name = $rs['OA_Name'];
|
$DispatchOrdID = $rs['DispatchOrdID'];
|
$ServiceOrdID = $rs['ServiceOrdID'];
|
$DispatchOrdNo = $rs['DispatchOrdNo'];
|
$DispatchOrd_NS_Time= $rs['DispatchOrd_NS_Time'];
|
$ServiceOrdType = $rs['ServiceOrdType'];
|
$Guest_Point_1 = $rs['Guest_Point_1'];
|
$Guest_Point_2 = $rs['Guest_Point_2'];
|
$Guest_Point_3 = $rs['Guest_Point_3'];
|
$Guest_PointE = $rs['Guest_PointE']; //客户微信评分(2020.12.22)
|
$Guest_Impression = $rs['Guest_Impression'];
|
$Guest_Evaluate = $rs['Guest_Evaluate'];
|
$RV_Point_1 = $rs['RV_Point_1'];
|
$RV_Point_2 = $rs['RV_Point_2'];
|
$RV_Point_3 = $rs['RV_Point_3'];
|
$RV_PointE = $rs['RV_PointE']; //电话回访评分(2020.12.22)
|
$ReturnChannel = $rs['ServiceOrdReturnChannel'];
|
$ServiceOrdVisit = $rs['ServiceOrdVisit'];
|
$ServiceOrdVisit = str_replace(PHP_EOL, '', $ServiceOrdVisit);
|
if (mb_strlen($ServiceOrdVisit)>20 and $is_CSV!=1) $ServiceOrdVisit=mb_substr($ServiceOrdVisit,0,20) . '...';
|
$ServiceOrdVisit_time=$rs['ServiceOrdVisit_time'];
|
$Guest_Reward = $rs['Guest_Reward'];
|
$Guest_openid = $rs['Guest_openid'];
|
$Guest_Time = $rs['Guest_Time'];
|
$ServiceOrdPtOutHosp= $rs['ServiceOrdPtOutHosp'];
|
$ServiceOrdPtInHosp = $rs['ServiceOrdPtInHosp'];
|
if ($Guest_Point_1+$Guest_Point_2+$Guest_Point_3==15) {$Guest_PointE=",9";}
|
if ($RV_Point_1+$RV_Point_2+$RV_Point_3==15) {$RV_PointE=",8";}
|
|
//读取数据--End
|
|
//写入数组
|
$FormArray[$i][0]="<a href=DispatchOrder.gds?DispatchOrdID=".$DispatchOrdID."&OrdDateType=4&OrdClassList=&h_menu1_1=1 target=_blank>".$DispatchOrdNo."</a>";
|
$FormArray[$i][1]=OAUser($OA_User_ID,"DepartmentName");
|
$FormArray[$i][2]=$OA_Name;
|
$FormArray[$i][3]=$ServiceOrdPtOutHosp;
|
$FormArray[$i][4]=$ServiceOrdPtInHosp;
|
|
if ($Guest_Point_1>0 or !empty($Guest_PointE)) {
|
if (empty($Guest_PointE)){
|
$FormArray[$i][5]=$Guest_Point_1."/".$Guest_Point_2."/1".$Guest_Point_3;
|
}else{
|
$FormArray[$i][5]=Guest_PointEA($Guest_PointE);
|
}
|
$FormArray[$i][6]=$Guest_Evaluate.$ServiceOrdVisit;
|
$FormArray[$i][10]=date("Y-m-d",strtotime($Guest_Time));
|
if ($Guest_openid!="") {
|
$FormArray[$i][12]="客户微信";
|
}else{
|
$FormArray[$i][12]="客户短信";
|
}
|
}else{
|
if (empty($RV_PointE) and empty($ServiceOrdVisit)){
|
$FormArray[$i][5]=$RV_Point_1."/".$RV_Point_2."/".$RV_Point_3;
|
}else{
|
$FormArray[$i][5]=Guest_PointEA($RV_PointE);
|
}
|
if (empty($FormArray[$i][5])) {$FormArray[$i][5]='其它';}
|
$FormArray[$i][6]=$Guest_Evaluate.$ServiceOrdVisit;
|
$FormArray[$i][10]=date("Y-m-d",strtotime($ServiceOrdVisit_time));
|
$FormArray[$i][12]="客服调查";
|
}
|
$FormArray[$i][7]=$ReturnChannel;
|
$FormArray[$i][8]=round($Guest_Reward,0);
|
$FormArray[$i][9]=date("Y-m-d",strtotime($DispatchOrd_NS_Time));
|
$FormArray[$i][11]=$Guest_openid;
|
|
|
$i++;
|
|
}
|
|
|
}
|
}
|
|
if ($is_CSV==2) {
|
echo json_encode($FormArray);
|
}
|
//echo print_r($FormArray);
|
//exit;
|
?>
|
