$OrdDateEnd) { $OrdDateStart1=$OrdDateStart; $OrdDateStart=$OrdDateEnd; $OrdDateEnd=$OrdDateStart1; } If ($OrdDateStart==$OrdDateEnd) { $OrdDateTypeName=$OrdDateStart; $OrdDateTypeName1=$OrdDateTypeName; } Else { $OrdDateTypeName=$OrdDateStart." 至 ".$OrdDateEnd; $OrdDateTypeName1="时间段 ".$OrdDateTypeName; } $SqlOrdDateType=" between '".$OrdDateStart."' and '".$OrdDateEnd." 23:59:59'"; } Else { $sql = "select top 1 vID,vtext,vOrder2 from dictionary where vType>=1 and vtitle='OrdDateType' and vID=".$OrdDateType ; $data = sqlsrv_query($conn,$sql); if($data == true){ if (sqlsrv_rows_affected($data)!=0) { while($rs = sqlsrv_fetch_array( $data, SQLSRV_FETCH_ASSOC) ) { $OrdDateTypeName = $rs['vtext']; $OrdDateTypeName1 = $OrdDateTypeName; $SqlOrdDateType = $rs['vOrder2']; } } else { $OrdDateType="4"; $OrdDateTypeName="本月"; $OrdDateTypeName1=$OrdDateTypeName; $SqlOrdDateType="between DATEADD(mm,DATEDIFF(mm,0,getdate()),0) and dateadd(ms,-3,DATEADD(mm,DATEDIFF(m,0,getdate())+1,0))"; } } } //各种返回信息 $SystemMessageTXT=""; $SystemMessageType=empty($_REQUEST['SystemMessageType'])!=false ? "" : $_REQUEST['SystemMessageType']; $SMT=empty($_REQUEST['SMT'])!=false ? "" : $_REQUEST['SMT']; if ($SystemMessageType!="") { if ($SMT=="1") { $SystemMessageTXT="请选择日期"; } } //时间段列表 $OrdDateTypes=array(); $sql = "select vID,vtext from dictionary where vType>=1 and vtitle='OrdDateType' order by vOrder" ; $data = sqlsrv_query($conn,$sql); if($data == true){ $i=0; while($rs = sqlsrv_fetch_array( $data, SQLSRV_FETCH_ASSOC) ) { $OrdDateTypes[$i]=array($rs['vID'],$rs['vtext']); $i++; } } //公司列表 $UnitNameName="全部"; $UnitNames=array(); $UnitNames[0]=array(0,"全部"); $sql = "select vID,vtext,vType from dictionary where vType>=0 and vtitle='UnitName' order by vType desc,vOrder" ; $data = sqlsrv_query($conn,$sql); if($data == true){ $i=1; while($rs = sqlsrv_fetch_array( $data, SQLSRV_FETCH_ASSOC) ) { $UnitName=$rs['vtext']; if ($rs['vType']==0) {$UnitName = $UnitName."(停用)";} $UnitNames[$i]=array($rs['vID'],$UnitName); if (strval($UnitNames[$i][0])==$UnitNameID){$UnitNameName = $UnitNames[$i][1];} $i++; } } //区域列表 $OrdAreaTypeName="全部"; $ArrayOrdAreaType=array(); $ArrayOrdAreaType[0]=array(0,"全部"); $sql = "select vID,vtext from dictionary where vType>=1 and vtitle='ServiceOrdAreaType' order by vOrder" ; $data = sqlsrv_query($conn,$sql); if($data == true){ $i=1; while($rs = sqlsrv_fetch_array( $data, SQLSRV_FETCH_ASSOC) ) { $ArrayOrdAreaType[$i]=array($rs['vID'],$rs['vtext']); if (strval($ArrayOrdAreaType[$i][0])==$OrdAreaTypeID){$OrdAreaTypeName = $ArrayOrdAreaType[$i][1];} $i++; } } //类型列表 $OrdTypeName="全部"; $ArrayOrdType=array(); $ArrayOrdType[0]=array(0,"全部"); $sql = "select vID,vtext from dictionary where vType>=1 and vtitle='ServiceOrderType' order by vOrder" ; $data = sqlsrv_query($conn,$sql); if($data == true){ $i=1; while($rs = sqlsrv_fetch_array( $data, SQLSRV_FETCH_ASSOC) ) { $ArrayOrdType[$i]=array($rs['vID'],$rs['vtext']); if (strval($ArrayOrdType[$i][0])==$OrdTypeID){$OrdTypeName = $ArrayOrdType[$i][1];} $i++; } } //单据类型表列 $OrdClassTypeName="调度单"; if(isDepartment("02")==0){ $OrdClassTypes = array( array(1,"调度单") ); }else{ $OrdClassTypes = array( array(1,"调度单"), array(2,"服务单") ); } for($i=0;$i <?php echo $LindemanAdmin?>