<?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;			//总记录数

//区域列表
$ArrayOrdAreaType=array();
$sql = "select vID,vtext from dictionary where vtitle='ServiceOrdAreaType' order by vOrder" ;
$data = sqlsrv_query($conn,$sql);
if($data == true){
	$i=0;
	while($rs = sqlsrv_fetch_array( $data, SQLSRV_FETCH_ASSOC) ) {
		$ArrayOrdAreaType[$rs['vID']]=$rs['vtext'];
		$i++;
	}
}

//类型列表
$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 (empty($_REQUEST['CarID'])==false){
	$searchSql=$searchSql." and DispatchOrdCarID=".$_REQUEST['CarID']." ";
}

$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;
$sql="select DispatchOrdID,ServiceOrdID,CarStItm_Time=convert(char,CarStItm_Time,120)
,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)
,OrdDistance=convert(money,Replace(Replace(ServiceOrdTraDistance,'公里',''),'km','')),ServiceOrdAreaType,ServiceOrdType,DispatchOrd_NS_Time=convert(char,DispatchOrd_NS_Time,23)
,TraStreet=(case when DispatchOrdTraVia<>'' then DispatchOrdTraVia else DispatchOrdTraStreet end)
,TraEnd=DispatchOrdTraEnd
,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)
,RunningTimeJson=(select '['+ stuff((select ',{\"State\": \"' + convert(varchar(2),DispatchOrdState) + '\",\"StateDate\": \"' + convert(varchar(20),DispatchOrdStartDate,120) + '\"}' from DispatchOrd_Running where DispatchOrdIDDt=DispatchOrdID order by id for xml path('')),1,1,'') +']') from DispatchOrd,ServiceOrder where ServiceOrdID=ServiceOrdIDDt and DispatchOrdState in (8,9) and DispatchOrd_NS_Time ".$SqlOrdDateType.$searchSql." and ServiceOrdClass in ('".$OrdClassListSql."') order by DispatchOrd_NS_Time desc";
//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) ) {
			//读取数据
			$DispatchOrdID		= $rs['DispatchOrdID'];
			$ServiceOrdID		= $rs['ServiceOrdID'];
			$DispatchOrdNo		= $rs['DispatchOrdNo'];
			$ServiceOrdAreaType	= $rs['ServiceOrdAreaType'];
			$ServiceOrdType		= $rs['ServiceOrdType'];
			$OrdDistance		= $rs['OrdDistance'];
			$DispatchOrd_NS_Time= $rs['DispatchOrd_NS_Time'];
			$ServiceOrdPtOutHosp= $rs['ServiceOrdPtOutHosp'];
			$ServiceOrdPtInHosp	= $rs['ServiceOrdPtInHosp'];
			$TraStreet			= $rs['TraStreet'];
			$TraEnd				= $rs['TraEnd'];
			$CarStItm_Time		= $rs['CarStItm_Time'];
			$RunningTimeJson	= $rs['RunningTimeJson'];
			$RunningTimeArr		= json_decode($RunningTimeJson,true);
			$RunningTime_start=0;
			$RunningTime_wait_sa=0;
			$RunningTime_wait_ba=0;
			$RunningTime_end=0;
			$RunningTime_wait=0;
			$RunningTime_wait=0;
			$RunningTime_wait="";
			$RunningTime_diff="";
			if (!empty($RunningTimeArr)){
				foreach($RunningTimeArr as $x=>$RunningTimeArr_value) {
					switch ($RunningTimeArr_value["State"])
					{
						case "4":
							if (empty($RunningTime_start)) {$RunningTime_start=$RunningTimeArr_value["StateDate"];}break;
						case "5":
							if (empty($RunningTime_wait_sa)) {$RunningTime_wait_sa=$RunningTimeArr_value["StateDate"];}break;
						case "6":
							if (empty($RunningTime_wait_ba)) {$RunningTime_wait_ba=$RunningTimeArr_value["StateDate"];}break;
						case "7":
							$RunningTime7=$RunningTimeArr_value["StateDate"];break;
						case "8":
							if (empty($RunningTime_end)) {$RunningTime_end=$RunningTimeArr_value["StateDate"];}break;
						case "9":
							if (empty($RunningTime_end)) {$RunningTime_end=$RunningTimeArr_value["StateDate"];}break;
					}
				}
			}else{
				$RunningTime_start="--";
				$RunningTime_end="--";
			}
			if (!empty($RunningTime_wait_sa) and !empty($RunningTime_wait_ba)) {
				$RunningTime_wait_date=floor((strtotime($RunningTime_wait_ba)-strtotime($RunningTime_wait_sa))/86400);
				$RunningTime_wait_hour=floor((strtotime($RunningTime_wait_ba)-strtotime($RunningTime_wait_sa))%86400/3600);
				$RunningTime_wait_minute=floor((strtotime($RunningTime_wait_ba)-strtotime($RunningTime_wait_sa))%86400%3600/60);
				if (!empty($RunningTime_wait_date)) {$RunningTime_wait=$RunningTime_wait.$RunningTime_wait_date."天 ";}
				if (!empty($RunningTime_wait_hour)) {$RunningTime_wait=$RunningTime_wait.$RunningTime_wait_hour."小时 ";}
				if (!empty($RunningTime_wait_minute)) {$RunningTime_wait=$RunningTime_wait.$RunningTime_wait_minute."分钟";}
				if (empty($RunningTime_wait)) {$RunningTime_wait="小于1分钟";}
			}
			if (empty($RunningTime_start) and !empty($RunningTime_end)) {$RunningTime_start=$RunningTime_end;}
			if (!empty($RunningTime_start) and !empty($RunningTime_end)) {
				$RunningTime_diff_date=floor((strtotime($RunningTime_end)-strtotime($RunningTime_start))/86400);
				$RunningTime_diff_hour=floor((strtotime($RunningTime_end)-strtotime($RunningTime_start))%86400/3600);
				$RunningTime_diff_minute=floor((strtotime($RunningTime_end)-strtotime($RunningTime_start))%86400%3600/60);
				if (!empty($RunningTime_diff_date)) {$RunningTime_diff=$RunningTime_diff.$RunningTime_diff_date."天 ";}
				if (!empty($RunningTime_diff_hour)) {$RunningTime_diff=$RunningTime_diff.$RunningTime_diff_hour."小时 ";}
				if (!empty($RunningTime_diff_minute)) {$RunningTime_diff=$RunningTime_diff.$RunningTime_diff_minute."分钟";}
				if (empty($RunningTime_diff)) {$RunningTime_diff="小于1分钟";}
			}
			if (empty($CarStItm_Time)) {$CarStItm_Time=$RunningTime_start;}
			//读取数据--End

			//写入数组
			$FormArray[$i][0]=$i;
			$FormArray[$i][1]=$DispatchOrd_NS_Time;
			$FormArray[$i][2]="<a href=DispatchOrder.gds?DispatchOrdID=".$DispatchOrdID."&OrdDateType=4&OrdClassList=&h_menu1_1=1 target=_blank>".$DispatchOrdNo."</a>";
			$FormArray[$i][3]=$ArrayOrdAreaType[$ServiceOrdAreaType];
			$FormArray[$i][4]=$ArrayOrdType[$ServiceOrdType];
			$FormArray[$i][5]=$ServiceOrdPtOutHosp;
			$FormArray[$i][6]=$TraStreet;
			$FormArray[$i][7]=$ServiceOrdPtInHosp;
			$FormArray[$i][8]=$TraEnd;
			$FormArray[$i][9]=floatval(number_format($OrdDistance,2,".",""));
			$FormArray[$i][10]=$CarStItm_Time;
			$FormArray[$i][11]=$RunningTime_start;
			$FormArray[$i][12]=$RunningTime_end;
			$FormArray[$i][13]=$RunningTime_diff;
			//$FormArray[$i][14]=$RunningTime_wait;
			$i++;
			
		}
			

	}
}

if ($is_CSV==2) {
	echo json_encode($FormArray);
}
//echo print_r($FormArray);
//exit;
?>