$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="2";
$OrdDateTypeName="本周";
$OrdDateTypeName1=$OrdDateTypeName;
$SqlOrdDateType="between DATEADD(wk,DATEDIFF(wk,0,getdate()),0)-1 and DATEADD(ss,-1,DATEADD(wk,DATEDIFF(wk,0,getdate()),0)+6)";
}
}
}
//各种返回信息
$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++;
}
}
$page_URL_noDate="searchTXT=".$searchTXT."&orderby=".$orderby."&UnitNameID=".$UnitNameID;
$page_URL="OrdDateType=".$OrdDateType."&OrdDateStart=".$OrdDateStart."&OrdDateEnd=".$OrdDateEnd."&".$page_URL_noDate;
?>
<?php echo $LindemanAdmin?>
".$FormArray[0][$x]."";
}
?>