<?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 ? "" : $SqlOrdDateType;
|
$OAOccupationSQL=empty($OAOccupation)!=false ? "" : " and EntourageID in (".$OAOccupation.") ";
|
$sql="select OA_User_ID,OA_Name,EntourageName=vtext,DispatchOrdID,ServiceOrdID,OrdDistance=convert(money,Replace(Replace(ServiceOrdTraDistance,'公里',''),'km','')),convert(char,DispatchOrdActualDate,120) DispatchOrdActualDate,convert(char,(case when DispatchOrdReturnDate is null then (select top 1 DispatchOrdStartDate from DispatchOrd_Running where DispatchOrdIDDt=DispatchOrdID and DispatchOrdState in (8,9) order by DispatchOrdStartDate desc) else DispatchOrdReturnDate end),120) DispatchOrdReturnDate
|
,DispatchOrd_NS_Time,DispatchOrdPerfomance,EntourageOT_is,EntourageOT2_is,EntourageLong_is,EntourageBetimesHH,EntourageDKP,EntourageDKPScale,EntourageState_Time,Stretcher_is,StretcherM=isnull((select sum(AddMoney) from (select AddMoney=(AddMoney/COUNT(a.Stretcher_is)) from DispatchOrd_Entourage as a,PaidMoney_Add as b where a.DispatchOrdIDDt=DispatchOrd_Entourage.DispatchOrdIDDt and b.ToDispatchOrdID=a.DispatchOrdIDDt and a.EntourageState<>4 and a.Stretcher_is=1 and b.AddMoneyType=2 GROUP BY AddMoney) as c),0) from DispatchOrd_Entourage,DispatchOrd,dictionary,OA_User,ServiceOrder where OA_User_ID=EntourageOAid and ServiceOrdID=ServiceOrdIDDt and vtitle='DispatchOrdEntourage' and EntourageID=vID and DispatchOrdID=DispatchOrdIDDt and (ServiceOrdTraDistance like '%公里%' or ServiceOrdTraDistance like '%km%') and DispatchOrdState in (8,9) and EntourageState=3".$OAOccupationSQL." and ServiceOrdType not in (14,15,16,17,18,19,21,22,23,24,25,13) and ServiceOrdClass in ('BF') and DispatchOrd_NS_Time $SqlOrdDateType $searchSql order by OA_User_ID,DispatchOrd_NS_Time";
|
//echo $sql;
|
//exit;
|
$data = sqlsrv_query($conn,$sql);
|
if($data == true){
|
$FormArray=array();
|
//表头
|
//$FormArray[0]=array("姓名","岗位","总里程","加班里程","加班比例","总单数","加班单数","加班比例","提前出车单数","提前出车比例","总提成","加班提成","加班提成比例");
|
$FormArray[0]=array("姓名","岗位","总里程","加班里程","加班比例","总单数","加班补贴单数","加班补贴比例","加班补贴任务累计时长","加班绩效单数","加班绩效比例","加班绩效任务总时长");
|
$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;
|
$Dete_OT_OrdTime=0;
|
$Dete_OT2_OrdInt=0;
|
$Dete_OT2_OrdTime=0;
|
$EntourageBetimesHHInt=0;
|
$Dete_DKPMoney=0;
|
$Dete_OT_DKPMoney=0;
|
while($rs = sqlsrv_fetch_array( $data, SQLSRV_FETCH_ASSOC) ) {
|
//读取数据
|
$OA_User_ID = $rs['OA_User_ID'];
|
if ($OA_User_ID_Old==0 and $OA_User_ID!=$OA_User_ID_Old) {$OA_User_ID_Old=$OA_User_ID;}
|
|
$OA_Name = $rs['OA_Name'];
|
$EntourageName = $rs['EntourageName'];
|
$DispatchOrdID = $rs['DispatchOrdID'];
|
$ServiceOrdID = $rs['ServiceOrdID'];
|
$OrdDistance = $rs['OrdDistance'];
|
$DispatchOrdActualDate = $rs['DispatchOrdActualDate']; //任务开始时间
|
$DispatchOrdReturnDate = $rs['DispatchOrdReturnDate']; //任务结束时间
|
$DispatchOrd_NS_Time = $rs['DispatchOrd_NS_Time'];
|
$DispatchOrdPerfomance = $rs['DispatchOrdPerfomance'];
|
$EntourageOT_is = $rs['EntourageOT_is'];
|
$EntourageOT2_is = $rs['EntourageOT2_is'];
|
$EntourageLong_is = $rs['EntourageLong_is'];
|
$EntourageBetimesHH = $rs['EntourageBetimesHH'];
|
$EntourageDKP = $rs['EntourageDKP'];
|
$EntourageDKPScale = $rs['EntourageDKPScale'];
|
$EntourageState_Time = $rs['EntourageState_Time'];
|
$Stretcher_is = $rs['Stretcher_is'];
|
$StretcherM = $rs['StretcherM'];
|
|
|
|
//写入数组
|
if ($OA_User_ID!=$OA_User_ID_Old) {
|
$FormArray[$i][0]="<a href=DispatchOrder_List.gds?searchTXT=staff1|".$OA_User_ID_Old."&OrdDateType=".$OrdDateType."&OrdDateStart=".$OrdDateStart."&OrdDateEnd=".$OrdDateEnd." 23:59:59&OrdClassList=&h_menu1_1=1 target=_blank>".$Dete_OA_Name."</a>";
|
$FormArray[$i][1]=$Dete_EntourageName;
|
$FormArray[$i][2]=$Dete_OrdDistance;
|
$FormArray[$i][3]=$Dete_OT_OrdDistance;
|
if ($Dete_OT_OrdDistance>0) {$FormArray[$i][4]=round($Dete_OT_OrdDistance/$Dete_OrdDistance*100,2)."%";} else {$FormArray[$i][4]="0%";}
|
$FormArray[$i][5]=$Dete_OrdInt;
|
$FormArray[$i][6]=$Dete_OT_OrdInt;
|
if ($Dete_OT_OrdInt>0) {$FormArray[$i][7]=round($Dete_OT_OrdInt/$Dete_OrdInt*100,2)."%";} else {$FormArray[$i][7]="0%";}
|
$FormArray[$i][8]=$Dete_OT_OrdTime;
|
$FormArray[$i][9]=$Dete_OT2_OrdInt;
|
if ($Dete_OT2_OrdInt>0) {$FormArray[$i][10]=round($Dete_OT2_OrdInt/$Dete_OrdInt*100,2)."%";} else {$FormArray[$i][10]="0%";}
|
$FormArray[$i][11]=$Dete_OT2_OrdTime;
|
$OA_User_ID_Old=$OA_User_ID;
|
$Dete_OrdDistance=0;
|
$Dete_OT_OrdDistance=0;
|
$Dete_OrdInt=0;
|
$Dete_OT_OrdInt=0;
|
$Dete_OT_OrdTime=0;
|
$Dete_OT2_OrdInt=0;
|
$Dete_OT2_OrdTime=0;
|
$Dete_DKPMoney=0;
|
$Dete_OT_DKPMoney=0;
|
$i++;
|
}
|
//写入数组--End
|
|
if ($OA_User_ID==$OA_User_ID_Old) {
|
$Dete_OA_Name = $OA_Name;
|
$Dete_EntourageName = $EntourageName;
|
//总里程
|
$Dete_OrdDistance += $OrdDistance;
|
|
//加班里程
|
if ($EntourageOT_is==1) {$Dete_OT_OrdDistance += $OrdDistance;}
|
|
//总单数
|
$Dete_OrdInt++;
|
|
//加班补贴单数
|
if ($EntourageOT_is==1) {
|
$Dete_OT_OrdInt++;
|
$Dete_OT_OrdTime=$Dete_OT_OrdTime+abs(round(((strtotime($DispatchOrdReturnDate)-strtotime($DispatchOrdActualDate))/60/60),1));
|
/*
|
if (strtotime($DispatchOrdActualDate)<strtotime(date("Y-m-d 8:30:00",strtotime($DispatchOrdActualDate)))) {
|
$Dete_OT_OrdTime=$Dete_OT_OrdTime+abs(round(((strtotime(date("Y-m-d 8:30:00",strtotime($DispatchOrdActualDate)))-strtotime($DispatchOrdActualDate))/60/60),1));
|
}elseif (strtotime($DispatchOrdActualDate)>strtotime(date("Y-m-d 17:30:00",strtotime($DispatchOrdActualDate)))){
|
$Dete_OT_OrdTime=$Dete_OT_OrdTime+abs(round(((strtotime($DispatchOrdActualDate)-strtotime(date("Y-m-d 17:30:00",strtotime($DispatchOrdActualDate))))/60/60),1));
|
}
|
if (strtotime(date("Y-m-d",strtotime($DispatchOrdActualDate)))<strtotime(date("Y-m-d",strtotime($DispatchOrdReturnDate)))) {
|
$Dete_OT_OrdTime=$Dete_OT_OrdTime+abs(round(((strtotime($DispatchOrdReturnDate)-strtotime(date("Y-m-d 23:59:59",strtotime($DispatchOrdActualDate))))/60/60),1));
|
}elseif (strtotime($DispatchOrdReturnDate)>strtotime(date("Y-m-d 17:30:00",strtotime($DispatchOrdReturnDate)))){
|
$Dete_OT_OrdTime=$Dete_OT_OrdTime+abs(round(((strtotime($DispatchOrdReturnDate)-strtotime(date("Y-m-d 17:30:00",strtotime($DispatchOrdReturnDate))))/60/60),1));
|
}
|
*/
|
}
|
|
//加班绩效单数
|
if ($EntourageOT2_is==1) {
|
$Dete_OT2_OrdInt++;
|
$Dete_OT2_OrdTime=$Dete_OT2_OrdTime+abs(round(((strtotime($DispatchOrdReturnDate)-strtotime($DispatchOrdActualDate))/60/60),1));
|
}
|
|
//总提成
|
$Dete_DKPMoney+=EntourageDKP_Money_B($DispatchOrdPerfomance,$EntourageOT_is,$EntourageLong_is,$EntourageBetimesHH,$EntourageDKP,$EntourageDKPScale,$EntourageState_Time,$StretcherM);
|
|
//加班提成
|
if ($EntourageOT_is==1) {$Dete_OT_DKPMoney += EntourageDKP_Money_B($DispatchOrdPerfomance,$EntourageOT_is,$EntourageLong_is,$EntourageBetimesHH,$EntourageDKP,$EntourageDKPScale,$EntourageState_Time,$StretcherM);}
|
}
|
//读取数据--End
|
}
|
|
//写入最后一个
|
$OA_User_ID_Old=$OA_User_ID;
|
$FormArray[$i][0]="<a href=DispatchOrder_List.gds?searchTXT=staff1|".$OA_User_ID_Old."&OrdDateType=".$OrdDateType."&OrdDateStart=".$OrdDateStart."&OrdDateEnd=".$OrdDateEnd." 23:59:59&OrdClassList=&h_menu1_1=1 target=_blank>".$OA_Name."</a>";
|
$FormArray[$i][1]=$EntourageName;
|
$FormArray[$i][2]=$Dete_OrdDistance;
|
$FormArray[$i][3]=$Dete_OT_OrdDistance;
|
if ($Dete_OT_OrdDistance>0) {$FormArray[$i][4]=round($Dete_OT_OrdDistance/$Dete_OrdDistance*100,2)."%";} else {$FormArray[$i][4]="0%";}
|
$FormArray[$i][5]=$Dete_OrdInt;
|
$FormArray[$i][6]=$Dete_OT_OrdInt;
|
if ($Dete_OT_OrdInt>0) {$FormArray[$i][7]=round($Dete_OT_OrdInt/$Dete_OrdInt*100,2)."%";} else {$FormArray[$i][7]="0%";}
|
$FormArray[$i][8]=$Dete_OT_OrdTime;
|
$FormArray[$i][9]=$Dete_OT2_OrdInt;
|
if ($Dete_OT2_OrdInt>0) {$FormArray[$i][10]=round($Dete_OT2_OrdInt/$Dete_OrdInt*100,2)."%";} else {$FormArray[$i][10]="0%";}
|
$FormArray[$i][11]=$Dete_OT2_OrdTime;
|
$Dete_OrdDistance=0;
|
$Dete_OrdInt=0;
|
$Dete_OT_OrdTime=0;
|
$Dete_OT2_OrdInt=0;
|
$Dete_OT2_OrdTime=0;
|
$Dete_DKPMoney=0;
|
$Dete_OT_DKPMoney=0;
|
$i++;
|
|
|
}
|
}
|
|
if ($is_CSV==2) {
|
echo json_encode($FormArray);
|
}
|
//echo print_r($FormArray);
|
//exit;
|
?>
|
