<?php require '/inc/odbc.php';?>
<?php require '/inc/function.php';?>
<?php 
$searchTXT=empty($_REQUEST['searchTXT'])!=false ? "" : $_REQUEST['searchTXT'];
$orderby=empty($_REQUEST['orderby'])!=false ? "" : $_REQUEST['orderby'];

$OrdDateType=empty($_REQUEST['OrdDateType'])!=false ? "0" : $_REQUEST['OrdDateType'];
$OrdDateStart=empty($_REQUEST['OrdDateStart'])!=false ? "" : $_REQUEST['OrdDateStart'];
$OrdDateEnd=empty($_REQUEST['OrdDateEnd'])!=false ? "" : $_REQUEST['OrdDateEnd'];

if(isDepartment("070120")==0){
  header("Location: /"); 
  exit;
}

//默认显示字段
$Report_Name	= "消杀记录";
if ($OrdDateType=="0" and $OrdDateStart=="" and $OrdDateEnd=="") {
	$OrdDateType=6;
	$OrdDateTop=" top 20 ";
}
else {
	$OrdDateTop="";
}
$OrdDateTypeName="";
if ($OrdDateType=="0") {
	if ($OrdDateStart=="" and $OrdDateEnd=="") {
		$OrdDateStart=date("Y-m-d");
		$OrdDateEnd=date("Y-m-d");
	}
	elseif ($OrdDateStart!="" and $OrdDateEnd=="") {
		$OrdDateEnd=$OrdDateStart;
	}
	elseif ($OrdDateStart=="" and $OrdDateEnd!="") {
		$OrdDateStart=$OrdDateEnd;
	}
	If ($OrdDateStart>$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="6";
			$OrdDateTypeName="本年";
			$OrdDateTypeName1=$OrdDateTypeName;
			$SqlOrdDateType="between DATEADD(yy,DATEDIFF(yy,0,getdate()),0) and dateadd(ms,-3,DATEADD(yy,DATEDIFF(yy,0,getdate())+1,0))";

		}
	}
	
}

//各种返回信息
$SystemMessageTXT="";
$SystemMessageType="";

//数据读取
$is_CSV=1;

if (empty($SqlOrdDateType)==false) {
	$SqlOrdDateType=str_replace("between","",$SqlOrdDateType);
	$DateTypeArray = explode(" and ", $SqlOrdDateType);
	$StDate=$DateTypeArray[0];
	$BeDate=$DateTypeArray[1];
} else {
	$StDate="DATEADD(yy,DATEDIFF(yy,0,getdate()),0)";
	$BeDate="dateadd(ms,-3,DATEADD(yy,DATEDIFF(yy,0,getdate())+1,0))";
}

//查询开始
$sql ="select Sterilize_CarLicense,Sterilize_Mode,Sterilize_Time=CONVERT(nvarchar(20),Sterilize_Time,120),OA_Name,DispatchOrdTraVia,DispatchOrdTraEnd from OA_User,OA_Sterilize LEFT JOIN DispatchOrd on DispatchOrdID=Sterilize_DispatchOrdID where OA_User_ID=Sterilize_OAID order by Sterilize_Time desc";
//echo $sql;
//exit;
$data = sqlsrv_query($conn,$sql);
if($data == true){
	$FormArray=array();
	//表头
	$FormArray[0]=array("消杀日期","车辆","消杀地点","行程","人员");
	$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) ) {
			//读取数据
			$Sterilize_Time			= $rs['Sterilize_Time'];
			$Sterilize_CarLicense	= $rs['Sterilize_CarLicense'];
			$Sterilize_Mode			= $rs['Sterilize_Mode'];
			$Sterilize_OAName		= $rs['OA_Name'];
			$OrdTraVia				= $rs['DispatchOrdTraVia'];
			$OrdTraEnd				= $rs['DispatchOrdTraEnd'];
			If (!empty($OrdTraEnd)) {
				$Sterilize_OrdTra = $OrdTraVia. " 至 " .$OrdTraEnd;
			}else{
				$Sterilize_OrdTra = "--";
			}
			
			//读取数据--End
			
			//写入数组
			$FormArray[$i][0]=$Sterilize_Time;
			$FormArray[$i][1]=$Sterilize_CarLicense;
			$FormArray[$i][2]=$Sterilize_Mode;
			$FormArray[$i][3]=$Sterilize_OrdTra;
			$FormArray[$i][4]=$Sterilize_OAName;
			$i++;
			//写入数组--End
		}
			

	}
}

if ($SystemMessageType!="2"){
	$dateTiem = date("YmdHis",time());
	$filename=$Report_Name.$dateTiem;
	include_once('/PHPExcel/PHPExcel.php');
	error_reporting(E_ALL);
	ini_set('display_errors', TRUE);
	ini_set('display_startup_errors', TRUE);
	  
	//创建对象  
	$excel = new PHPExcel();

	//填充表头信息
	for($x=0;$x<$FormArrayX;$x++) {
	  $excel->getActiveSheet()->setCellValue(IntToChr($x)."1",$FormArray[0][$x]);
	}

	//填充表格信息
	for($y=1;$y<count($FormArray);$y++) {
		for($x=0;$x<count($FormArray[$y]);$x++) {
			$excel->getActiveSheet()->setCellValue(IntToChr($x).($y+1),strip_tags($FormArray[$y][$x]));  
		}
	}
	  
	//创建Excel输入对象
	$write = new PHPExcel_Writer_Excel5($excel);
	header("Pragma: public");  
	header("Expires: 0");  
	header("Cache-Control:must-revalidate, post-check=0, pre-check=0");  
	header("Content-Type:application/force-download");  
	header("Content-Type:application/vnd.ms-execl");  
	header("Content-Type:application/octet-stream");  
	header("Content-Type:application/download");;  
	header('Content-Disposition:attachment;filename="'.$filename.'.xls"');  
	header("Content-Transfer-Encoding:binary");  
	$write->save('php://output');  
}else{
	echo $SystemMessageTXT;
}
?>