$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++; } } //合作公司列表 $CoopUnitName="未选择"; $CoopUnitNames=array(); $CoopUnitNames[0]=array(0,"未选择"); if ($CoopUnitID!="" and $CoopUnitID!="0") {$CoopUnitName="多选";} if (substr($CoopUnitID,0,2)=="0,") {$CoopUnitID=substr($CoopUnitID,2);} $sql = "select UnitID,UnitShort from IntroducerUnitData where UnitState=1 order by UnitID desc" ; $data = sqlsrv_query($conn,$sql); if($data == true){ $i=1; while($rs = sqlsrv_fetch_array( $data, SQLSRV_FETCH_ASSOC) ) { $CoopUnitNames[$i]=array($rs['UnitID'],$rs['UnitShort']); if (strval($CoopUnitNames[$i][0])==$CoopUnitID){$CoopUnitName = $CoopUnitNames[$i][1];} $i++; } } $page_URL_noDate="searchTXT=".$searchTXT."&orderby=".$orderby."&UnitNameID=".$UnitNameID."&CoopUnitID=".$CoopUnitID; $page_URL="OrdDateType=".$OrdDateType."&OrdDateStart=".$OrdDateStart."&OrdDateEnd=".$OrdDateEnd."&".$page_URL_noDate; ?> <?php echo $LindemanAdmin?>