0 and (DispatchOrdReturnDate is null or dateadd(day,7,DispatchOrdReturnDate)>=GETDATE()) and weixinOpenID='".$openid."'order by ServiceOrdStartDate desc";
} else{
//转运记录
$sql="select top 50 ServiceOrdID,ServiceOrdClass,ServiceOrdState,ServiceOrdCoName,ServiceOrdCoPhone,ServiceOrdPtName,ServiceOrdTraVia,ServiceOrdTraEnd,ServiceOrdStartDate=convert(char,ServiceOrdStartDate,120),DispatchOrdID,DispatchOrdClass,DispatchOrdState,Guest_Point,ServiceOrdPtOutHospID,ServiceOrdPtInHospID from weixinOpenIDToPhone,ServiceOrder LEFT JOIN DispatchOrd ON ServiceOrdIDDt=ServiceOrdID and DispatchOrdState not in (10) where ServiceOrdCoPhone=UserPhone and weixinOpenID='".$openid."' order by ServiceOrdStartDate desc";
}
if ($openid=='oAJ1cwegdmr12YVPyyM5hF1EhcOk'){
$sql=str_replace(" and weixinOpenID='".$openid."'","",$sql);
}
$data = sqlsrv_query($conn,$sql);
if($data == true){
if (sqlsrv_rows_affected($data)!=0) {
while($rs = sqlsrv_fetch_array($data) ) {
$ServiceOrdID = $rs['ServiceOrdID']; //服务单ID
$ServiceOrdClass = $rs['ServiceOrdClass']; //服务单类型
$ServiceOrdState = $rs['ServiceOrdState']; //服务单状态
$ServiceOrdCoName = $rs['ServiceOrdCoName']; //联系人姓名
$ServiceOrdCoPhone = $rs['ServiceOrdCoPhone']; //联系人电话
$ServiceOrdPtName = $rs['ServiceOrdPtName']; //患者姓名
$ServiceOrdTraVia = $rs['ServiceOrdTraVia']; //客人出发地
$ServiceOrdTraEnd = $rs['ServiceOrdTraEnd']; //客人目的地
$ServiceOrdStartDate= $rs['ServiceOrdStartDate'];//下单日期
$DispatchOrdID = $rs['DispatchOrdID']; //调度单ID
$DispatchOrdClass = $rs['DispatchOrdClass']; //调度类型
$DispatchOrdState = $rs['DispatchOrdState']; //调度单状态
$Guest_Point = $rs['Guest_Point']; //评价情况
$ServiceOrdPtOutHospID=$rs['ServiceOrdPtOutHospID'];//转出医院ID
$ServiceOrdPtInHospID=$rs['ServiceOrdPtInHospID'];//转入医院ID
if ($ServiceOrdPtOutHospID!='0' and $ServiceOrdPtOutHospID!='153') {
$sql="select HospName,HospLevel from HospData where HospID=".$ServiceOrdPtOutHospID;
$HospData = sqlsrv_query($conn,$sql);
if($HospData == true){
if (sqlsrv_rows_affected($HospData)!=0) {
while($rsHosp = sqlsrv_fetch_array($HospData) ) {
$ServiceOrdTraVia=$rsHosp['HospName'];
}
}
}
}
if ($ServiceOrdPtInHospID!='0' and $ServiceOrdPtInHospID!='153') {
$sql="select HospName,HospLevel from HospData where HospID=".$ServiceOrdPtInHospID;
$HospData = sqlsrv_query($conn,$sql);
if($HospData == true){
if (sqlsrv_rows_affected($HospData)!=0) {
while($rsHosp = sqlsrv_fetch_array($HospData) ) {
$ServiceOrdTraEnd=$rsHosp['HospName'];
}
}
}
}
if ($OrderType=="2") {
if ($Guest_Point==0){
if (strtotime($ServiceOrdStartDate)+2592000
=strtotime(date("y-m-d h:i:s"))) {?>