<?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;
|
?>
|
