<?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,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,120),TimeLength_Program,TimeLength_ICU,TimeLength_Wait,DispatchOrdPerfomance,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),DoctorsName=(select CASE WHEN EntourageMileageFactor<>1 THEN '，'+OA_Name+'/'+CONVERT(nvarchar(5),EntourageMileageFactor) ELSE '，'+OA_Name END from DispatchOrd_Entourage,OA_User where OA_User_ID=EntourageOAid and EntourageState<>4 and DispatchOrdIDDt=DispatchOrdID and EntourageID in (3,5) for xml path('')),NurseName=(select CASE WHEN EntourageMileageFactor<>1 THEN '，'+OA_Name+'/'+CONVERT(nvarchar(5),EntourageMileageFactor) ELSE '，'+OA_Name END from DispatchOrd_Entourage,OA_User where OA_User_ID=EntourageOAid and EntourageState<>4 and DispatchOrdIDDt=DispatchOrdID and EntourageID in (4,6) for xml path('')),DriverName=(select CASE WHEN EntourageMileageFactor<>1 THEN '，'+OA_Name+'/'+CONVERT(nvarchar(5),EntourageMileageFactor) ELSE '，'+OA_Name END from DispatchOrd_Entourage,OA_User where OA_User_ID=EntourageOAid and EntourageState<>4 and DispatchOrdIDDt=DispatchOrdID and EntourageID in (1,2) for xml path('')) from DispatchOrd,ServiceOrder where ServiceOrdID=ServiceOrdIDDt and (ServiceOrdTraDistance like '%公里%' or ServiceOrdTraDistance like '%km%') 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("单号","类型","转出医院","转入医院","医生","护士","司机","实际公里数","大型活动保障时长","居家ICU时长","等待时长","折算公里数");
|
|
$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'];
|
$TimeLength_Program = $rs['TimeLength_Program'];
|
$TimeLength_ICU = $rs['TimeLength_ICU'];
|
$TimeLength_Wait = $rs['TimeLength_Wait'];
|
$DispatchOrd_NS_Time= $rs['DispatchOrd_NS_Time'];
|
$DispatchOrdPerfomance = $rs['DispatchOrdPerfomance'];
|
$ServiceOrdPtOutHosp= $rs['ServiceOrdPtOutHosp'];
|
$ServiceOrdPtInHosp = $rs['ServiceOrdPtInHosp'];
|
$DoctorsName = substr($rs['DoctorsName'],3);
|
$NurseName = substr($rs['NurseName'],3);
|
$DriverName = substr($rs['DriverName'],3);
|
|
//读取数据--End
|
|
$ConversionDistance = 0;
|
//行驾里程
|
if ($OrdDistance>=0 and $OrdDistance<=50) {$ConversionDistance = 50;}
|
elseif ($OrdDistance>50 and $OrdDistance<=100 and $ServiceOrdType!=9) {$ConversionDistance = 100;}
|
elseif ($OrdDistance>100 and $OrdDistance<=150 and $ServiceOrdType!=9) {$ConversionDistance = 150;}
|
elseif ($OrdDistance>150 and $OrdDistance<=200 and $ServiceOrdType!=9) {$ConversionDistance = 200;}
|
elseif ($OrdDistance>200 and $OrdDistance<=250 and $ServiceOrdType!=9) {$ConversionDistance = 250;}
|
else {$ConversionDistance = floatval(number_format($OrdDistance,0,".",""));}
|
//大型活动保障时长
|
if ($TimeLength_Program>0) {$ConversionDistance=$ConversionDistance+($TimeLength_Program*30);}
|
//居家ICU
|
if ($TimeLength_ICU>0) {$ConversionDistance=$ConversionDistance+($TimeLength_ICU*50);}
|
//等待时长
|
if ($TimeLength_Wait>0) {$ConversionDistance=$ConversionDistance+($TimeLength_Wait*20);}
|
//机场单
|
if ($ServiceOrdType==4) {
|
if ($OrdDistance==0) {$ConversionDistance=0;}
|
$ConversionDistance=$ConversionDistance+150;
|
}
|
//救援单
|
if ($ServiceOrdType==10) {
|
if ($OrdDistance<50) {$ConversionDistance = 50;}
|
else {$ConversionDistance = floatval(number_format($OrdDistance,0,".",""));}
|
}
|
//高铁,航空单
|
if ($ServiceOrdType==8 or $ServiceOrdType==5) {
|
$ConversionDistance=0;
|
}
|
|
//写入数组
|
$FormArray[$i][0]="<a href=DispatchOrder.gds?DispatchOrdID=".$DispatchOrdID."&OrdDateType=4&OrdClassList=&h_menu1_1=1 target=_blank>".$DispatchOrdNo."</a>";
|
$FormArray[$i][1]=$ArrayOrdAreaType[$ServiceOrdAreaType];
|
$FormArray[$i][2]=$ArrayOrdType[$ServiceOrdType];
|
$FormArray[$i][3]=$ServiceOrdPtOutHosp;
|
$FormArray[$i][4]=$ServiceOrdPtInHosp;
|
$FormArray[$i][5]=$DoctorsName;
|
$FormArray[$i][6]=$NurseName;
|
$FormArray[$i][7]=$DriverName;
|
$FormArray[$i][8]=floatval(number_format($OrdDistance,2,".",""));
|
$FormArray[$i][9]=floatval(number_format($TimeLength_Program,2,".",""));
|
$FormArray[$i][10]=floatval(number_format($TimeLength_ICU,2,".",""));
|
$FormArray[$i][11]=floatval(number_format($TimeLength_Wait,2,".",""));
|
$FormArray[$i][12]=$ConversionDistance;
|
$i++;
|
|
}
|
|
|
}
|
}
|
|
if ($is_CSV==2) {
|
echo json_encode($FormArray);
|
}
|
//echo print_r($FormArray);
|
//exit;
|
?>
|
