<?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);
	}
}

//查询条件
$OrderType1Sql="0";
$OrderType2Sql="0";
$OrderType3Sql="0";
$sql="select vID,vType from dictionary where vtitle='ServiceOrderType'";
$data = sqlsrv_query($conn,$sql);
if($data == true){
	while($rs = sqlsrv_fetch_array($data) ) {
		if ($rs['vType']==1 and $rs['vID']!=7){
			$OrderType1Sql	.= ",".$rs['vID'];
		}elseif ($rs['vType']==1 and $rs['vID']==7){
			$OrderType2Sql	.= ",".$rs['vID'];
		}elseif ($rs['vType']==2){
			$OrderType3Sql	.= ",".$rs['vID'];
		}
	}
}

$searchSql="";
$searchTXT=empty($searchTXT)!=false ? "" : $searchTXT;
if ($searchTXT!=""){
	$searchSql=" and (EntourageOA_Name like '%$searchTXT%') ";
}else{
	$searchSql="";
}

$orderby=empty($orderby)!=false ? "" : $orderby;
If (strrpos($orderby," desc")>1){
	$orderbydesc="";
	$descTXT="↓";
}else{
	$orderbydesc=" desc";
	$descTXT="↑";
}

If ($orderby=="") {
  $orderby="EntourageOA_DepartmentName,EntourageOAid";
  $descTXT="↓";
}

if ($OrdDateType=="0" and $OrdDateStart=="" and $OrdDateEnd=="") {$OrdDateType=4;}

//个人查询日期类型转换

if ($OrdDateType=="4") {
	$UserOrderDateType="11";
}elseif ($OrdDateType=="5"){
	$UserOrderDateType="11-1";
}elseif ($OrdDateType=="0"){
	$UserOrderDateType="0";
}else{
	$UserOrderDateType="";
}

//查询开始
$SqlOrdDateType=empty($SqlOrdDateType)!=false ? "" : $SqlOrdDateType;
$OAOccupationSQL=empty($OAOccupation)!=false ? "" : " and EntourageID in (".$OAOccupation.") ";

//日期跨度计算
$DateInt=0;
$sql=str_replace(" and ",",",str_replace("between ","select DateInt=DATEDIFF(d,",$SqlOrdDateType)).")";
$data = sqlsrv_query($conn,$sql);
if (sqlsrv_rows_affected($data)!=0) {
	while($rs = sqlsrv_fetch_array( $data, SQLSRV_FETCH_ASSOC) ) {
		$DateInt=$rs['DateInt'];
	}
}
//echo $DateInt;

$SqlOrdClass=" and DispatchOrdClass in ('SA') "; //只统计广州总部订单

$sql="SELECT OA_User_ID,OA_Name,OA_DepartmentID,OA_Position,vtext as OA_DepartmentName
 
 ,OrdSum1=(select COUNT(DispatchOrdID) from DispatchOrd,ServiceOrder,DispatchOrd_Entourage where ServiceOrdID=ServiceOrdIDDt and DispatchOrdID=DispatchOrdIDDt and EntourageState<>4 ".$SqlOrdClass." and OA_User_ID=EntourageOAid and ServiceOrdType in (".$OrderType1Sql.") and EntourageOT_is=0 and (DispatchOrdState in (8) or (DispatchOrdState=9 and ServiceOrdAreaType<>1)) and DispatchOrd_NS_Time ".$SqlOrdDateType.")
 
 ,OrdSum_OT=(select COUNT(DispatchOrdID) from DispatchOrd,ServiceOrder,DispatchOrd_Entourage where ServiceOrdID=ServiceOrdIDDt and DispatchOrdID=DispatchOrdIDDt and EntourageState<>4 ".$SqlOrdClass." and OA_User_ID=EntourageOAid and ServiceOrdType in (".$OrderType1Sql.") and EntourageOT_is=1 and (DispatchOrdState in (8) or (DispatchOrdState=9 and ServiceOrdAreaType<>1)) and DispatchOrd_NS_Time ".$SqlOrdDateType.")

 ,OrdSum2=(select COUNT(DispatchOrdID) from DispatchOrd,ServiceOrder,DispatchOrd_Entourage where ServiceOrdID=ServiceOrdIDDt and DispatchOrdID=DispatchOrdIDDt and EntourageState<>4 ".$SqlOrdClass." and OA_User_ID=EntourageOAid and ServiceOrdType in (".$OrderType2Sql.") and EntourageOT_is=0 and (DispatchOrdState in (8) or (DispatchOrdState=9 and ServiceOrdAreaType<>1)) and DispatchOrd_NS_Time ".$SqlOrdDateType.")

 ,OrdSum2_OT=(select COUNT(DispatchOrdID) from DispatchOrd,ServiceOrder,DispatchOrd_Entourage where ServiceOrdID=ServiceOrdIDDt and DispatchOrdID=DispatchOrdIDDt and EntourageState<>4 ".$SqlOrdClass." and OA_User_ID=EntourageOAid and ServiceOrdType in (".$OrderType2Sql.") and EntourageOT_is=1 and (DispatchOrdState in (8) or (DispatchOrdState=9 and ServiceOrdAreaType<>1)) and DispatchOrd_NS_Time ".$SqlOrdDateType.")

 ,OrdSum3=(select COUNT(DispatchOrdID) from DispatchOrd,ServiceOrder,DispatchOrd_Entourage where ServiceOrdID=ServiceOrdIDDt and DispatchOrdID=DispatchOrdIDDt and EntourageState<>4 ".$SqlOrdClass." and OA_User_ID=EntourageOAid and ServiceOrdType in (".$OrderType3Sql.") and EntourageOT_is=0 and (DispatchOrdState in (8) or (DispatchOrdState=9 and ServiceOrdAreaType<>1)) and DispatchOrd_NS_Time ".$SqlOrdDateType.")
 
 ,OrdSum3_OT=(select COUNT(DispatchOrdID) from DispatchOrd,ServiceOrder,DispatchOrd_Entourage where ServiceOrdID=ServiceOrdIDDt and DispatchOrdID=DispatchOrdIDDt and EntourageState<>4 ".$SqlOrdClass." and OA_User_ID=EntourageOAid and ServiceOrdType in (".$OrderType3Sql.") and EntourageOT_is=1 and (DispatchOrdState in (8) or (DispatchOrdState=9 and ServiceOrdAreaType<>1)) and DispatchOrd_NS_Time ".$SqlOrdDateType.") 

 ,OrdDKPMoneySum1=(select OA_DKPMoney_Sum=isnull(cast(sum(CASE when EntourageMileageEdit IS Not null then Round(EntourageMileageEdit+Stretcher_Money,2) WHEN ServiceOrdType in (14,15,16,17,18,19,21,23,24,25) THEN Round(DispatchOrdPerfomance,2) WHEN EntourageDKPScale>0 THEN Round((ServiceOrdTraTxnPrice+isnull(AddMoney,0))*(cast(CASE when EntourageOT2_is=1 and ((datename(hour,Entourage_Time)<7) or ((datename(hour,Entourage_Time)<8 or (datename(hour,Entourage_Time)=8 And datename(Mi,Entourage_Time)<30)) and Entourage_Time<'2024-03-01')) THEN EntourageDKPScale*1.2 when EntourageOT2_is=1 THEN EntourageDKPScale*1.1 else EntourageDKPScale END as decimal(11,6))/100)+Stretcher_Money+EntourageOT_Money+Condition_Money,2) ELSE EntourageOT_Money END) as decimal(10,2)),0) from DispatchOrd_Entourage,ServiceOrder,DispatchOrd left join (select ToDispatchOrdID,AddMoney=sum(AddMoney) from PaidMoney_Add where AddMoneyType=1 GROUP BY ToDispatchOrdID) as PaidMoney_Add_B on ToDispatchOrdID=DispatchOrdID where DispatchOrdID=DispatchOrdIDDt and ServiceOrdID=ServiceOrdIDDt and ServiceOrdType in (".$OrderType1Sql.") and EntourageOT_is=0 and DispatchOrdState in (8,9) and EntourageState<>4 ".$SqlOrdClass." and OA_User_ID=EntourageOAid and DispatchOrd_NS_Time ".$SqlOrdDateType.")

  ,OrdDKPMoneySum2=(select OA_DKPMoney_Sum=isnull(cast(sum(CASE when EntourageMileageEdit IS Not null then EntourageMileageEdit+Stretcher_Money WHEN ServiceOrdType in (14,15,16,17,18,19,21,23,24,25) THEN DispatchOrdPerfomance WHEN EntourageDKPScale>0 THEN Round((ServiceOrdTraTxnPrice+isnull(AddMoney,0))*(cast(CASE when EntourageOT2_is=1 and ((datename(hour,Entourage_Time)<7) or ((datename(hour,Entourage_Time)<8 or (datename(hour,Entourage_Time)=8 And datename(Mi,Entourage_Time)<30)) and Entourage_Time<'2024-03-01')) THEN EntourageDKPScale*1.2 when EntourageOT2_is=1 THEN EntourageDKPScale*1.1 else EntourageDKPScale END as decimal(11,6))/100)+Stretcher_Money+EntourageOT_Money+Condition_Money,2) ELSE EntourageOT_Money END) as decimal(10,2)),0) from DispatchOrd_Entourage,ServiceOrder,DispatchOrd left join (select ToDispatchOrdID,AddMoney=sum(AddMoney) from PaidMoney_Add where AddMoneyType=1 GROUP BY ToDispatchOrdID) as PaidMoney_Add_B on ToDispatchOrdID=DispatchOrdID where DispatchOrdID=DispatchOrdIDDt and ServiceOrdID=ServiceOrdIDDt and ServiceOrdType in (".$OrderType2Sql.") and EntourageOT_is=0 and DispatchOrdState in (8,9) and EntourageState<>4 ".$SqlOrdClass." and OA_User_ID=EntourageOAid and DispatchOrd_NS_Time ".$SqlOrdDateType.")

 ,OrdDKPMoneySum3=(select OA_DKPMoney_Sum=isnull(cast(sum(CASE when EntourageMileageEdit IS Not null then EntourageMileageEdit+Stretcher_Money WHEN ServiceOrdType in (14,15,16,17,18,19,21,23,24,25) THEN DispatchOrdPerfomance ELSE DispatchOrdPerfomance END) as decimal(10,2)),0) from DispatchOrd_Entourage,DispatchOrd,ServiceOrder where DispatchOrdID=DispatchOrdIDDt and ServiceOrdID=ServiceOrdIDDt and ServiceOrdType in (".$OrderType3Sql.") and EntourageOT_is=0 and DispatchOrdState in (8,9) and EntourageState<>4 ".$SqlOrdClass." and OA_User_ID=EntourageOAid and DispatchOrd_NS_Time ".$SqlOrdDateType.")

  ,OrdDKPMoneySum_OT=(select OA_DKPMoney_Sum=isnull(cast(sum(CASE when EntourageMileageEdit IS Not null then EntourageMileageEdit+Stretcher_Money WHEN ServiceOrdType in (14,15,16,17,18,19,21,23,24,25) THEN DispatchOrdPerfomance WHEN EntourageDKPScale>0 THEN Round((ServiceOrdTraTxnPrice+isnull(AddMoney,0))*(cast(CASE when EntourageOT2_is=1 and ((datename(hour,Entourage_Time)<7) or ((datename(hour,Entourage_Time)<8 or (datename(hour,Entourage_Time)=8 And datename(Mi,Entourage_Time)<30)) and Entourage_Time<'2024-03-01')) THEN EntourageDKPScale*1.2 when EntourageOT2_is=1 THEN EntourageDKPScale*1.1 else EntourageDKPScale END as decimal(11,6))/100)+Stretcher_Money+EntourageOT_Money+Condition_Money,2) ELSE EntourageOT_Money END) as decimal(10,2)),0) from DispatchOrd_Entourage,ServiceOrder,DispatchOrd left join (select ToDispatchOrdID,AddMoney=sum(AddMoney) from PaidMoney_Add where AddMoneyType=1 GROUP BY ToDispatchOrdID) as PaidMoney_Add_B on ToDispatchOrdID=DispatchOrdID where DispatchOrdID=DispatchOrdIDDt and ServiceOrdID=ServiceOrdIDDt and ServiceOrdType in (".$OrderType1Sql.") and EntourageOT_is=1 and DispatchOrdState in (8,9) and EntourageState<>4 ".$SqlOrdClass." and OA_User_ID=EntourageOAid and DispatchOrd_NS_Time ".$SqlOrdDateType.")

  ,OrdDKPMoneySum2_OT=(select OA_DKPMoney_Sum=isnull(cast(sum(CASE when EntourageMileageEdit IS Not null then EntourageMileageEdit+Stretcher_Money WHEN ServiceOrdType in (14,15,16,17,18,19,21,23,24,25) THEN DispatchOrdPerfomance WHEN EntourageDKPScale>0 THEN Round((ServiceOrdTraTxnPrice+isnull(AddMoney,0))*(cast(CASE when EntourageOT2_is=1 and ((datename(hour,Entourage_Time)<7) or ((datename(hour,Entourage_Time)<8 or (datename(hour,Entourage_Time)=8 And datename(Mi,Entourage_Time)<30)) and Entourage_Time<'2024-03-01')) THEN EntourageDKPScale*1.2 when EntourageOT2_is=1 THEN EntourageDKPScale*1.1 else EntourageDKPScale END as decimal(11,6))/100)+Stretcher_Money+EntourageOT_Money+Condition_Money,2) ELSE EntourageOT_Money END) as decimal(10,2)),0) from DispatchOrd_Entourage,ServiceOrder,DispatchOrd left join (select ToDispatchOrdID,AddMoney=sum(AddMoney) from PaidMoney_Add where AddMoneyType=1 GROUP BY ToDispatchOrdID) as PaidMoney_Add_B on ToDispatchOrdID=DispatchOrdID where DispatchOrdID=DispatchOrdIDDt and ServiceOrdID=ServiceOrdIDDt and ServiceOrdType in (".$OrderType2Sql.") and EntourageOT_is=1 and DispatchOrdState in (8,9) and EntourageState<>4 ".$SqlOrdClass." and OA_User_ID=EntourageOAid and DispatchOrd_NS_Time ".$SqlOrdDateType.")

  ,OrdDKPMoneySum3_OT=(select OA_DKPMoney_Sum=isnull(cast(sum(CASE when EntourageMileageEdit IS Not null then Round(EntourageMileageEdit+Stretcher_Money,2) WHEN ServiceOrdType in (14,15,16,17,18,19,21,23,24,25) THEN DispatchOrdPerfomance WHEN EntourageDKPScale>0 THEN Round((ServiceOrdTraTxnPrice+isnull(AddMoney,0))*(cast(CASE when EntourageOT2_is=1 and ((datename(hour,Entourage_Time)<7) or ((datename(hour,Entourage_Time)<8 or (datename(hour,Entourage_Time)=8 And datename(Mi,Entourage_Time)<30)) and Entourage_Time<'2024-03-01')) THEN EntourageDKPScale*1.2 when EntourageOT2_is=1 THEN EntourageDKPScale*1.1 else EntourageDKPScale END as decimal(11,6))/100)+Stretcher_Money+EntourageOT_Money+Condition_Money,2) ELSE EntourageOT_Money END) as decimal(10,2)),0) from DispatchOrd_Entourage,ServiceOrder,DispatchOrd left join (select ToDispatchOrdID,AddMoney=sum(AddMoney) from PaidMoney_Add where AddMoneyType=1 GROUP BY ToDispatchOrdID) as PaidMoney_Add_B on ToDispatchOrdID=DispatchOrdID where DispatchOrdID=DispatchOrdIDDt and ServiceOrdID=ServiceOrdIDDt and ServiceOrdType in (".$OrderType3Sql.") and EntourageOT_is=1 and DispatchOrdState in (8,9) and EntourageState<>4 ".$SqlOrdClass." and OA_User_ID=EntourageOAid and DispatchOrd_NS_Time ".$SqlOrdDateType.")

 ,OrdMoneySum=(select sum(Round(ServiceOrdTraTxnPrice,2)) from ( select ServiceOrdTraTxnPrice=(ServiceOrdTraTxnPrice+isnull((select sum(AddMoney) from PaidMoney_Add where ToDispatchOrdID=DispatchOrdID),0)) from DispatchOrd_Entourage,ServiceOrder,DispatchOrd where DispatchOrdID=DispatchOrdIDDt and ServiceOrdID=ServiceOrdIDDt  and DispatchOrdState in (8,9) and EntourageState<>4 and OA_User_ID=EntourageOAid  and DispatchOrd_NS_Time ".$SqlOrdDateType.") as aa)

 from OA_User,dictionary as OA_Department where vtitle='OA_Department' and vType<>14 and vID=OA_DepartmentID and OA_OrderClass like '%SA%' and OA_User_ID in (select EntourageOAid from DispatchOrd_Entourage where EntourageState_Time ".$SqlOrdDateType." and EntourageState<>4)";
//echo $sql;exit;
$data = sqlsrv_query($conn,$sql);
if($data == true){
	$FormArray=array();
	//表头
	$FormArray[0]=array("员工姓名","职位","所属部门","单量（正常单）","单量（保障单）","单量（特殊任务单）","加班（陆地）","加班（保障）","加班（特殊任务）","季度单量奖励","普通绩效汇总","保障单绩效汇总","特殊任务绩效汇总","加班（陆地）绩效汇总","加班（保障）绩效汇总","加班（特殊任务）绩效汇总","绩效汇总","参与任务总额");

	$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'];
			$DepartmentID	= $rs['OA_DepartmentID'];
			$DepartmentName	= $rs['OA_DepartmentName'];
			$OA_Position	= "0".$rs['OA_Position'];
			$OrdSum1		= $rs['OrdSum1'];			//单量（普通单）
			$OrdSum_OT		= $rs['OrdSum_OT'];			//单量（普通加班单）
			$OrdSum2		= $rs['OrdSum2'];			//单量（保障单）
			$OrdSum2_OT		= $rs['OrdSum2_OT'];;		//单量（保障加班单）
			$OrdSum3		= $rs['OrdSum3'];			//单量（特殊任务单）
			$OrdSum3_OT		= $rs['OrdSum3_OT'];		//单量（特殊任务加班单）
			$OrdDKPMoneySum1= $rs['OrdDKPMoneySum1'];	//普通绩效汇总
			$OrdDKPMoneySum2= $rs['OrdDKPMoneySum2'];	//保障单绩效汇总
			$OrdDKPMoneySum3= $rs['OrdDKPMoneySum3'];	//特殊任务绩效汇总
			$OrdDKPMoneySum_OT= $rs['OrdDKPMoneySum_OT'];	//加班（普通加班单）绩效汇总
			$OrdDKPMoneySum2_OT= $rs['OrdDKPMoneySum2_OT'];	//加班（保障加班单）绩效汇总
			$OrdDKPMoneySum3_OT= $rs['OrdDKPMoneySum3_OT'];	//加班（特殊任务加班单）绩效汇总
			$OrdMoneySum	= $rs['OrdMoneySum'];		//参与任务总额

			//读取数据--End
			
			/*
			if (stripos($OA_Position,"医生")>0) {
				$OA_Position="医生";
				//单量奖励 20以下扣50元/单,20以上奖励55元/单
				if (($OrdSum1+$OrdSum2)>20){
					$OrdRewardMoney	= (($OrdSum1+$OrdSum2)-20)*55;
				}elseif (($OrdSum1+$OrdSum2+$OrdSum3)<20){
					$OrdRewardMoney	= -(20-($OrdSum1+$OrdSum2+$OrdSum3))*50;
				}else{
					$OrdRewardMoney = 0;	
				}
			}elseif (stripos($OA_Position,"护士")>0) {
				$OA_Position="护士";
				//单量奖励 20以下扣50元/单,20以上奖励50元/单
				if (($OrdSum1+$OrdSum2)>20){
					$OrdRewardMoney	= (($OrdSum1+$OrdSum2)-20)*50;
				}elseif (($OrdSum1+$OrdSum2+$OrdSum3)<20){
					$OrdRewardMoney	= -(20-($OrdSum1+$OrdSum2+$OrdSum3))*50;
				}else{
					$OrdRewardMoney = 0;	
				}
			}elseif (stripos($OA_Position,"司机")>0) {
				$OA_Position="司机";
				//单量奖励 20以下扣50元/单,20以上奖励50元/单
				if (($OrdSum1+$OrdSum2)>25){
					$OrdRewardMoney	= (($OrdSum1+$OrdSum2)-25)*40;
				}elseif (($OrdSum1+$OrdSum2+$OrdSum3)<25){
					$OrdRewardMoney	= -(25-($OrdSum1+$OrdSum2+$OrdSum3))*45;
				}else{
					$OrdRewardMoney = 0;	
				}
			}else{
				$OA_Position="";
				$OrdRewardMoney=0;
			}
			*/

			//季度单量奖励 转运组医护司每季度完成达标单量为60单，如大于60单小于90单部份则按每单20元做为加班费补贴；如大于90单部份则按每单30元做为加班费补贴。
			
			if (stripos($OA_Position,"医生")>0) {
				$OA_Position="医生";
				//单量奖励 60以下扣50元/单,60~90奖励20元/单,90以上奖励30元/单
				if (($OrdSum1+$OrdSum2+$OrdSum_OT+$OrdSum2_OT)>90){
					$OrdRewardMoney	= (($OrdSum1+$OrdSum2+$OrdSum_OT+$OrdSum2_OT)-90)*30+30*20;
				}elseif (($OrdSum1+$OrdSum2+$OrdSum_OT+$OrdSum2_OT)>60){
					$OrdRewardMoney	= (($OrdSum1+$OrdSum2+$OrdSum_OT+$OrdSum2_OT)-60)*20;
				}elseif (($OrdSum1+$OrdSum2+$OrdSum3+$OrdSum_OT+$OrdSum2_OT+$OrdSum3_OT)<60 and ($OrdSum1+$OrdSum2+$OrdSum3+$OrdSum_OT+$OrdSum2_OT+$OrdSum3_OT)>0){
					$OrdRewardMoney	= -(60-($OrdSum1+$OrdSum2+$OrdSum3+$OrdSum_OT+$OrdSum2_OT+$OrdSum3_OT))*50;
				}else{
					$OrdRewardMoney = 0;	
				}
			}elseif (stripos($OA_Position,"护士")>0) {
				$OA_Position="护士";
				//单量奖励 60以下扣50元/单,60~90奖励20元/单,90以上奖励30元/单
				if (($OrdSum1+$OrdSum2+$OrdSum_OT+$OrdSum2_OT)>90){
					$OrdRewardMoney	= (($OrdSum1+$OrdSum2+$OrdSum_OT+$OrdSum2_OT)-90)*30+30*20;
				}elseif (($OrdSum1+$OrdSum2+$OrdSum_OT+$OrdSum2_OT)>60){
					$OrdRewardMoney	= (($OrdSum1+$OrdSum2+$OrdSum_OT+$OrdSum2_OT)-60)*20;
				}elseif (($OrdSum1+$OrdSum2+$OrdSum3+$OrdSum_OT+$OrdSum2_OT+$OrdSum3_OT)<60 and ($OrdSum1+$OrdSum2+$OrdSum3+$OrdSum_OT+$OrdSum2_OT+$OrdSum3_OT)>0){
					$OrdRewardMoney	= -(60-($OrdSum1+$OrdSum2+$OrdSum3+$OrdSum_OT+$OrdSum2_OT+$OrdSum3_OT))*50;
				}else{
					$OrdRewardMoney = 0;	
				}
			}elseif (stripos($OA_Position,"司机")>0) {
				$OA_Position="司机";
				//单量奖励 60以下扣40元/单,60~90奖励20元/单,90以上奖励30元/单
				if (($OrdSum1+$OrdSum2+$OrdSum_OT+$OrdSum2_OT)>90){
					$OrdRewardMoney	= (($OrdSum1+$OrdSum2+$OrdSum_OT+$OrdSum2_OT)-90)*30+30*20;
				}elseif (($OrdSum1+$OrdSum2+$OrdSum_OT+$OrdSum2_OT)>60){
					$OrdRewardMoney	= (($OrdSum1+$OrdSum2+$OrdSum_OT+$OrdSum2_OT)-60)*20;
				}elseif (($OrdSum1+$OrdSum2+$OrdSum3+$OrdSum_OT+$OrdSum2_OT+$OrdSum3_OT)<60 and ($OrdSum1+$OrdSum2+$OrdSum3+$OrdSum_OT+$OrdSum2_OT+$OrdSum3_OT)>0){
					$OrdRewardMoney	= -(60-($OrdSum1+$OrdSum2+$OrdSum3+$OrdSum_OT+$OrdSum2_OT+$OrdSum3_OT))*40;
				}else{
					$OrdRewardMoney = 0;	
				}
			}else{
				$OA_Position="";
				$OrdRewardMoney=0;
			}
			if ($DateInt<89 or $DateInt>92) {$OrdRewardMoney=0;}

			//写入数组
			$FormArray[$i][0]="<a href=Report_MileageMan3.php?searchTXT=".$OA_Name."&orderby=&UnitNameID=&OrdDateType=".$OrdDateType."&OrdDateStart=".$OrdDateStart."&OrdDateEnd=".$OrdDateEnd." target=_blank>".$OA_Name."</a>";
			$FormArray[$i][1]=$OA_Position;
			$FormArray[$i][2]=$DepartmentName;
			$FormArray[$i][3]=$OrdSum1;
			$FormArray[$i][4]=$OrdSum2;
			$FormArray[$i][5]=$OrdSum3;
			$FormArray[$i][6]=$OrdSum_OT;
			$FormArray[$i][7]=$OrdSum2_OT;
			$FormArray[$i][8]=$OrdSum3_OT;
			$FormArray[$i][9]=floatval(number_format($OrdRewardMoney,2,".",""));
			if ($DateInt<89 or $DateInt>92) {$FormArray[$i][9]="--";}
			$FormArray[$i][10]=floatval(number_format($OrdDKPMoneySum1,2,".",""));
			$FormArray[$i][11]=floatval(number_format($OrdDKPMoneySum2,2,".",""));
			$FormArray[$i][12]=floatval(number_format($OrdDKPMoneySum3,2,".",""));
			$FormArray[$i][13]=floatval(number_format($OrdDKPMoneySum_OT,2,".",""));
			$FormArray[$i][14]=floatval(number_format($OrdDKPMoneySum2_OT,2,".",""));
			$FormArray[$i][15]=floatval(number_format($OrdDKPMoneySum3_OT,2,".",""));
			if ($UserOrderDateType!="") {
				$FormArray[$i][16]="<a href='/m_UserOrder_List.gds?OrdState=100&OrdDateType=$UserOrderDateType&OrdDateStart=$OrdDateStart&OrdDateEnd=$OrdDateEnd&OAadminID=$OA_User_ID' target=_blank>".floatval(number_format($OrdDKPMoneySum1+$OrdDKPMoneySum2+$OrdDKPMoneySum3+$OrdRewardMoney+$OrdDKPMoneySum_OT+$OrdDKPMoneySum2_OT+$OrdDKPMoneySum3_OT,2,".",""))."</a>";
			}else{
				$FormArray[$i][16]=floatval(number_format($OrdDKPMoneySum1+$OrdDKPMoneySum2+$OrdDKPMoneySum3+$OrdRewardMoney+$OrdDKPMoneySum_OT+$OrdDKPMoneySum2_OT+$OrdDKPMoneySum3_OT,2,".",""));
			}
			$FormArray[$i][17]=floatval(number_format($OrdMoneySum,2,".",""));
			$i++;
			
		}
			

	}
}

if ($is_CSV==2) {
	echo json_encode($FormArray);
}
//echo print_r($FormArray);
//exit;
?>