添加福祉车爬楼机费和向转运隐藏成交价格

hzj

1 天以前 d08ed14d6a4589c034140fdc8ac04a277c8e4b36

 Report_MileageMan3_Data.php

@@ -110,7 +110,7 @@
 ,ServiceOrdAreaType,ServiceOrdType,DispatchOrd_NS_Time=convert(char,DispatchOrd_NS_Time,120),TimeLength_Program,TimeLength_ICU,TimeLength_Wait,EntourageOT_is,EntourageOT2_is,EntourageBetimesHH,EntourageState_Time,Entourage_Time=convert(char,Entourage_Time,120)

 ,EntourageOA_DepartmentName,EntourageOutHosp,EntourageInHosp,DispatchOrdPerfomance

 ,ConversionDistance,EntourageOT_Money,Stretcher_Money,EntourageMileageFactor,EntourageMileageEdit

 ,ServiceOrdPtOutHosp,ServiceOrdTraVia,ServiceOrdPtInHosp,ServiceOrdTraEnd

 ,ServiceOrdPtOutHosp,ServiceOrdTraVia,ServiceOrdPtInHosp,ServiceOrdTraEnd,ServiceOrdStairClimberPrice

from DispatchOrd_Entourage,DispatchOrd,ServiceOrder 

where ServiceOrdID=ServiceOrdIDDt and DispatchOrdID=DispatchOrdIDDt and DispatchOrdState in (8,9) and EntourageState<>4".$OAOccupationSQL." and DispatchOrd_NS_Time ".$SqlOrdDateType.$searchSql." order by EntourageOAid,DispatchOrd_NS_Time";

//echo $sql;exit;

@@ -118,7 +118,7 @@
if($data == true){

   $FormArray=array();

   //表头

   $FormArray[0]=array("员工姓名","所属部门","日期","单号","总成交价","等待费","担架费","居家ICU费","区域","类型","转出医院","转出地址","转入医院","转入地址","班次","出车时间","收车时间","加班时长","出车里程","收车里程","实际公里","预估距离","活动保障","居家ICU","等待","居家ICU绩效","担架费计提","订单提成");

   $FormArray[0]=array("员工姓名","所属部门","日期","单号","总成交价","爬楼机费","等待费","担架费","居家ICU费","区域","类型","转出医院","转出地址","转入医院","转入地址","班次","出车时间","收车时间","加班时长","出车里程","收车里程","实际公里","预估距离","活动保障","居家ICU","等待","居家ICU绩效","担架费计提","订单提成");



   $FormArrayX=count($FormArray[0]);

   if (sqlsrv_rows_affected($data)==0) {

@@ -173,6 +173,7 @@
         $EntourageOT_Money      = $rs['EntourageOT_Money'];   //加班费/项目费

         $EntourageMileageEdit      = $rs['EntourageMileageEdit'];   //修改提成金额

         $Entourage_Time         = $rs['Entourage_Time'];

         $ServiceOrdStairClimberPrice   = $rs['ServiceOrdStairClimberPrice'];   //爬楼机价格

         //加班出车绩效1.1倍,超12点出车1.2倍

         $EntourageDKPOTScale   = 1;

         If ($EntourageOT2_is==1 And date("H:i",strtotime($Entourage_Time))<"07:00") {

@@ -255,35 +256,36 @@
         $FormArray[$i][2]=date("Y-m-d",strtotime($DispatchOrd_NS_Time));

         $FormArray[$i][3]="<a href=DispatchOrder.gds?DispatchOrdID=".$DispatchOrdID."&OrdDateType=4&OrdClassList=&h_menu1_1=1 target=_blank>".$DispatchOrdNo."</a>";

         $FormArray[$i][4]=floatval(number_format(($ServiceOrdTraTxnPrice+$AddMoney2+$AddMoney3),2,".",""));

         $FormArray[$i][5]=floatval(number_format($AddMoney1,2,".",""));

         $FormArray[$i][6]=floatval(number_format($AddMoney2,2,".",""));

         $FormArray[$i][7]=floatval(number_format($AddMoney3,2,".",""));

         $FormArray[$i][8]=$ArrayOrdAreaType[$ServiceOrdAreaType];

         $FormArray[$i][9]=$ArrayOrdType[$ServiceOrdType];

         $FormArray[$i][10]=$EntourageOutHosp;

         $FormArray[$i][11]=$ServiceOrdTraVia;

         $FormArray[$i][12]=$EntourageInHosp;

         $FormArray[$i][13]=$ServiceOrdTraEnd;

         $FormArray[$i][14]=date("H:i",strtotime($DispatchOrd_NS_Time))>"08:30" && date("H:i",strtotime($DispatchOrd_NS_Time))<"17:30" ? "白班" : "夜班";

         $FormArray[$i][15]=$DispatchOrdActualDate;

         $FormArray[$i][16]=$DispatchOrdReturnDate;

         $FormArray[$i][5]=floatval(number_format($ServiceOrdStairClimberPrice,2,".",""));

         $FormArray[$i][6]=floatval(number_format($AddMoney1,2,".",""));

         $FormArray[$i][7]=floatval(number_format($AddMoney2,2,".",""));

         $FormArray[$i][8]=floatval(number_format($AddMoney3,2,".",""));

         $FormArray[$i][9]=$ArrayOrdAreaType[$ServiceOrdAreaType];

         $FormArray[$i][10]=$ArrayOrdType[$ServiceOrdType];

         $FormArray[$i][11]=$EntourageOutHosp;

         $FormArray[$i][12]=$ServiceOrdTraVia;

         $FormArray[$i][13]=$EntourageInHosp;

         $FormArray[$i][14]=$ServiceOrdTraEnd;

         $FormArray[$i][15]=date("H:i",strtotime($DispatchOrd_NS_Time))>"08:30" && date("H:i",strtotime($DispatchOrd_NS_Time))<"17:30" ? "白班" : "夜班";

         $FormArray[$i][16]=$DispatchOrdActualDate;

         $FormArray[$i][17]=$DispatchOrdReturnDate;

         //$FormArray[$i][14]=floatval(number_format($OTTime/60/60,1,".",""));   //加长时长-小时

         if (isDepartment("070122")==1) {

            $FormArray[$i][17]=time2second($OTTime);                     //加长时长-X天X小时X分钟

            $FormArray[$i][18]=time2second($OTTime);                     //加长时长-X天X小时X分钟

         }else{

            $FormArray[$i][17]="--";

            $FormArray[$i][18]="--";

         }

         $FormArray[$i][18]=floatval(number_format($DispatchOrdTraStreetMileage,2,".",""));

         $FormArray[$i][19]=floatval(number_format($DispatchOrdTraEndMileage,2,".",""));

         $FormArray[$i][20]=floatval(number_format($DispatchOrdMileage,2,".",""));

         $FormArray[$i][21]=floatval(number_format($OrdDistance,2,".",""));

         $FormArray[$i][19]=floatval(number_format($DispatchOrdTraStreetMileage,2,".",""));

         $FormArray[$i][20]=floatval(number_format($DispatchOrdTraEndMileage,2,".",""));

         $FormArray[$i][21]=floatval(number_format($DispatchOrdMileage,2,".",""));

         $FormArray[$i][22]=floatval(number_format($OrdDistance,2,".",""));



         $FormArray[$i][22]=floatval(number_format($TimeLength_Program,2,".",""));

         $FormArray[$i][23]=floatval(number_format($TimeLength_ICU,2,".",""));

         $FormArray[$i][24]=floatval(number_format($TimeLength_Wait,2,".",""));

         $FormArray[$i][25]=floatval(number_format($TimeLength_ICU_Money,2,".",""));

         $FormArray[$i][26]=floatval(number_format($Stretcher_Money,2,".",""));

         $FormArray[$i][27]=floatval(number_format($EntourageDKP_Money,2,".",""));

         $FormArray[$i][23]=floatval(number_format($TimeLength_Program,2,".",""));

         $FormArray[$i][24]=floatval(number_format($TimeLength_ICU,2,".",""));

         $FormArray[$i][25]=floatval(number_format($TimeLength_Wait,2,".",""));

         $FormArray[$i][26]=floatval(number_format($TimeLength_ICU_Money,2,".",""));

         $FormArray[$i][27]=floatval(number_format($Stretcher_Money,2,".",""));

         $FormArray[$i][28]=floatval(number_format($EntourageDKP_Money,2,".",""));

         

         $i++;