<?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;
|
}
|
?>
|
