<?php require '/inc/odbc.php';?>
<?php require '/inc/function.php';?>
<?php 
if(isDepartment("0302")==0){
  header("Location: /"); 
  exit;
}

$searchTXT=empty($_REQUEST['searchTXT'])==true ? "" : addslashes($_REQUEST['searchTXT']);
$orderby=empty($_REQUEST['orderby'])==true ? "" : addslashes($_REQUEST['orderby']);
$OrdDateType=empty($_REQUEST['OrdDateType'])==true ? "7" : addslashes($_REQUEST['OrdDateType']);
$OrdDateStart=empty($_REQUEST['OrdDateStart'])==true ? "" : addslashes($_REQUEST['OrdDateStart']);
$OrdDateEnd=empty($_REQUEST['OrdDateEnd'])==true ? "" : addslashes($_REQUEST['OrdDateEnd']);
$AuditStatus=empty($_REQUEST['AuditStatus'])==true ? "0" : addslashes($_REQUEST['AuditStatus']);

$InvoiceType=empty($_REQUEST['InvoiceType'])==true ? "0" : addslashes($_REQUEST['InvoiceType']);
$page=empty($_REQUEST['page'])==true ? 1 : $_REQUEST['page']; //当前页数

$OrdDateTypeName="";
if ($OrdDateType=="-1") {
	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="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'])==true ? "" : $_REQUEST['SystemMessageType'];
$SMT=empty($_REQUEST['SMT'])==true ? "" : $_REQUEST['SMT'];
if ($SystemMessageType!="") {
	if ($SMT=="1") {
		$SystemMessageTXT="保存成功";
	}elseif ($SMT=="2") {
		$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++;
	}
}

//发票处理状态
$AuditStatusName="全部";
$AuditStatusArray=array();
$AuditStatusArray[0]=array(-1,"全部");
$sql = "select vID,vtext from dictionary where vType>=1 and vtitle='AuditStatus' order by vOrder" ;
$data = sqlsrv_query($conn,$sql);
if($data == true){
	$i=1;
	while($rs = sqlsrv_fetch_array( $data, SQLSRV_FETCH_ASSOC) ) {
		$AuditStatusArray[$i]=array($rs['vID'],$rs['vtext']);
		if (strval($rs['vID'])==$AuditStatus){$AuditStatusName = $rs['vtext'];}
		$i++;
	}
}

//分公司名称列表
$UnitNameListArray=array();
$sql = "select ServiceBranch,case when UnitShort='微信小程序' then '广州' else UnitShort END as UnitShort from IntroducerUnitData where ServiceBranch<>'' and UnitID<>32" ;
$data = sqlsrv_query($conn,$sql);
if($data == true){
	$i=1;
	while($rs = sqlsrv_fetch_array( $data, SQLSRV_FETCH_ASSOC) ) {
		$UnitNameListArray[$i]=array($rs['ServiceBranch'],$rs['UnitShort']);
		$i++;
	}
}

//默认显示字段
$Report_Name	= "用户积分提现管理";

$page_URL_noDate="h_menu1_1=2&searchTXT=".$searchTXT."&orderby=".$orderby."&InvoiceType=".$InvoiceType."&AuditStatus=".$AuditStatus."&OrdDateType=".$OrdDateType."&OrdDateStart=".$OrdDateStart."&OrdDateEnd=".$OrdDateEnd;
$page_URL="h_menu1_1=2&searchTXT=".$searchTXT."&orderby=".$orderby."&InvoiceType=".$InvoiceType."&AuditStatus=".$AuditStatus."&OrdDateType=".$OrdDateType."&OrdDateStart=".$OrdDateStart."&OrdDateEnd=".$OrdDateEnd;

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
	<head>
		<title><?php echo $LindemanAdmin?></title>
		<?php require '/inc/ccs.php';?>
		<!-- DataTables -->
		<link rel="stylesheet" type="text/css" href="/js/media/css/jquery.dataTables.css">
		<script type="text/javascript" charset="utf8" src="/js/media/js/jquery.js"></script>
		<script type="text/javascript" charset="utf8" src="/js/media/js/jquery.dataTables.js"></script>
		<style type="text/css">
		#content div.box table td {
			border-right: 1px solid #cdcdcd;
			text-align: center;
		}
		</style>
	</head>
	<body onkeydown="xKeyEvent(event)">
		<?php require 'menu_header.php';?>
		<!-- content -->
		<div id="content">
			<?php require 'Dispatch_menu_left.php';?>
			<!-- content / right -->
			<div id="right">
				<!-- table -->
				<div class="box">
					<!-- box / title -->
					<div class="title">
						<h5><?php if($searchTXT!=""){echo $Report_Name." ".$searchTXT;} else {echo $Report_Name;} ?></h5>
						<ul class="links">
							<!--
							<li><a onclick="javascript:JS_CarGasAdd();">新建</a></li>
							<li><a href="UserPoints_List_Excel.php?<?php echo $page_URL;?>">导出</a></li>
							-->
							<li>
								<?php
								//下拉菜单设定
								$DownMenuName="处理状态";		//菜单名称
								$DownMenuNameID="AuditStatus";	//菜单ID
								$DownMenuArray=$AuditStatusArray;	//菜单数组
								$DownMenuOldName=$AuditStatusName;	//默认值名称
								$DownMenuOldID=$AuditStatus	//默认值ID
								?>
								<div class="search">
								<div name="DownMenu_container" id="<?php echo $DownMenuNameID?>_container" class="select-container" style="overflow: hidden;cursor:pointer" onclick="JS_DownMenu('<?php echo $DownMenuNameID?>')">
									<span class="select-content" style="width: 46px;"><?php echo $DownMenuName."：".$DownMenuOldName?></span><span class="arrow" id="<?php echo $DownMenuNameID?>_arrow" name="DownMenu_arrow"></span>
								</div>
								<div name="DownMenu_list" id="<?php echo $DownMenuNameID?>_list" class="select-list scroll-pane" style="overflow: hidden; position: absolute; background-color: white; width: 90px; display: none;background-position: initial initial; background-repeat: initial initial;margin-left: 69px;">
									<div class="jspContainer" style="width: 90px;">
										<div style="padding: 0px; top: 0px; width: 90px;">
										<?php for($i=0;$i<count($DownMenuArray);$i++) {?>
										  <span title="<?php echo $DownMenuArray[$i][1]?>" name="DownMenu_<?php echo $DownMenuNameID?>" onmouseover="JS_DownMenuMouseover('<?php echo $DownMenuNameID?>',<?php echo $i?>)" onclick="JS_DownMenuJump('<?php echo "?".$page_URL?>','<?php echo $DownMenuOldID?>','<?php echo $DownMenuNameID?>','<?php echo $DownMenuArray[$i][0]?>')" class="list-option<?php if ($DownMenuArray[$i][0]==$DownMenuOldID){echo " option";}?>"><?php echo $DownMenuArray[$i][1]?></span>
										<?php }?>
										</div>
									</div>
								</div>
								</div>
							</li>
							<li>
								<div class="search">
								<div id="Date_container" class="select-container" style="overflow: hidden;cursor:pointer" onclick="JS_OrdDateType()">
									<span class="select-content" style="width: 46px;">期间：<?php echo $OrdDateTypeName?></span><span class="arrow" id="Date_arrow"></span>
								</div>
								<div id="Date_list" class="select-list scroll-pane" style="overflow: hidden; position: absolute; background-color: white; width: 65px; display: none;background-position: initial initial; background-repeat: initial initial;margin-left: 35px;">
									<div class="jspContainer" style="width: 63px;">
										<div style="padding: 0px; top: 0px; width: 63px;">
										<?php for($i=0;$i<count($OrdDateTypes);$i++) {?>
										  <span title="<?php echo $OrdDateTypes[$i][1]?>" onmouseover="JS_OrdDateTypeMouseover('OrdDateType_<?php echo $OrdDateTypes[$i][0]?>')" onclick="JS_OrdDateTypeJump('<?php echo $OrdDateTypes[$i][0]?>')" id="OrdDateType_<?php echo $OrdDateTypes[$i][0]?>" class="list-option<?php if ($OrdDateTypes[$i][0]==$OrdDateType){echo " option";}?>"><?php echo $OrdDateTypes[$i][1]?></span>
										<?php }?>
										<span title="自定义" onmouseover="JS_OrdDateTypeMouseover('OrdDateType_0')" onclick="JS_OrdDateTypeCreateOpen()" id="OrdDateType_0" name="OrdDateType" class="list-option">自定义</span>
										</div>
									</div>
								</div>
								</div>
							</li>
					<div class="dialogJ  dialogJfix dialogJshadow" id="OrdDateTypeCreate" style="width: 440px;right: 80px; top: 150px;height:80px ;display:none;z-index: 100;">
						<div class="dialogJtitle">
							<a href="javascript:JS_OrdDateTypeCreateClose();" class="dialogJclose" title="关闭本窗口">&nbsp;</a>
							<span class="dialogJtxt" id="EditPhotoTXT">请选择时间段</span>
						</div>
						<div class="dialogJcontent" style="margin-left: 5px;margin-right:5px;">
							<div class="input" style="float:left;margin-top: 10px;margin-left: 5px;" id="two-inputs">
								期间：
								<input type="text" id="OrdDateStart" name="OrdDateStart" class="date" style="width:138px;" value="<?php echo $OrdDateStart?>">
								至
								<input type="text" id="OrdDateEnd" name="OrdDateEnd" class="date" style="width:138px;" value="<?php echo $OrdDateEnd?>">
								<input type="button" class="dialogJbtn first-child" onclick="JS_OrdDateJump()" value="查询">
							</div>
						</div>
					</div>
					<!--时间选择js  liang------------->
					<link rel="stylesheet" href="css/daterangepicker.css">
					<script src="js/moment.min.js"></script>
					<script src="js/jquery.daterangepicker.js"></script>
					<script>
							$(function()
						{
							$('#two-inputs').dateRangePicker(
							{
								separator : ' to ',
								getValue: function()
								{
									if ($('#OrdDateStart').val() && $('#OrdDateEnd').val() )
										return $('#OrdDateStart').val() + ' to ' + $('#OrdDateEnd').val();
									else
										return '';
								},
								setValue: function(s,s1,s2)
								{
									$('#OrdDateStart').val(s1);
									$('#OrdDateEnd').val(s2);
								}

							});
						});
					</script>
				<!--时间选择js  liang------------->
					<script type="text/javascript">
						//时间表列显示下拉菜单
						function JS_OrdDateType(){
						  if (Date_container.className!="select-container select-container-show-list"){
							Date_container.className="select-container select-container-show-list";
							Date_arrow.className="arrow arrow-up";
							Date_list.style.display="block";
							OrdClass_container.className="select-container";
							OrdClass_arrow.className="arrow";
							OrdClass_list.style.display="none";
							OrdDateTypeCreate.style.display="none";
						  }
						  else {
							Date_container.className="select-container";
							Date_arrow.className="arrow";
							Date_list.style.display="none";
						  }
						}
						//时间表列指针移动到下拉菜单
						function JS_OrdDateTypeMouseover(id){
						  var d=document.getElementById(id);
						  <?php for($i=0;$i<count($OrdDateTypes);$i++) {?>
						  document.getElementById("OrdDateType_<?php echo $OrdDateTypes[$i][0]?>").className="list-option";
						  <?php }?>
						  document.getElementById("OrdDateType_0").className="list-option";
						  d.className="list-option option";
						}
						//自定义时间-打开窗口
						function JS_OrdDateTypeCreateOpen()
						{
							JS_OrdDateType();
							OrdDateTypeCreate.style.display="block";
						}
						//自定义时间-关闭窗口
						function JS_OrdDateTypeCreateClose()
						{
							JS_OrdDateType();
							OrdDateTypeCreate.style.display="none";
						}
						//自定义时间-确定时间
						function JS_OrdDateTypeCreateSave()
						{
						document.getElementById('ServiceOrdTraStreet').value=document.getElementById('Duration').value;
						document.getElementById('ServiceOrdTraEnd').value=document.getElementById('ServiceOrdTraEnd').value;
						document.getElementById('ServiceOrdTraStreetCoo').value=results.sw.point.lng + ','+ results.sw.point.lat; //起点坐标
						document.getElementById('ServiceOrdTraEndCoo').value=results.Lu.point.lng + ','+ results.Lu.point.lat; //起点坐标
						}
						//时间类表列转跳
						function JS_OrdDateJump(id){
							var OrdDateStart=document.getElementById("OrdDateStart").value;
							var OrdDateEnd=document.getElementById("OrdDateEnd").value;
							//var searchTXT=document.getElementById("searchTXT").value;
							window.location.href='UserPoints_List.php?<?php echo $page_URL_noDate?>&OrdDateType=-1&OrdDateStart='+OrdDateStart+'&OrdDateEnd='+OrdDateEnd;
						}
						//自定义时间转跳
						function JS_OrdDateTypeJump(id){
							//var searchTXT=document.getElementById("searchTXT").value;
							window.location.href='UserPoints_List.php?<?php echo $page_URL_noDate?>&OrdDateType='+id;
						}

						//时间表列转跳
						function JS_OrdClassTypeJump(id){
							//var searchTXT=document.getElementById("searchTXT").value;
							window.location.href='UserPoints_List.php?<?php echo $page_URL_noDate?>&OrdClassList='+id;
						}
						
					</script>
					<script LANGUAGE="javascript">

						//新建字典-关闭上传窗口
						function JS_CarCreateClose()
						{
						CarCreate.style.display="none";
						}
						function JS_InvoiceType(){
							InvoiceType = document.form2.InvoiceType.value;
							if(InvoiceType=='2') {
								InvoiceCompanyAddDiv.style.display="none";
								InvoiceCompanyBankDiv.style.display="none";
								Invoice_strAddDiv.style.display="none";
								Invoice_strEmailDiv.style.display="block";
								Invoice_strNameTXT.innerHTML="接收人<font color='#ff0000'>*</font>：";
								Invoice_strPhoneTXT.innerHTML="接收短信电话<font color='#ff0000'>*</font>：";
							}else if (InvoiceType=='3') {
								InvoiceCompanyAddDiv.style.display="none";
								InvoiceCompanyBankDiv.style.display="none";
								Invoice_strAddDiv.style.display="block";
								Invoice_strEmailDiv.style.display="none";
								Invoice_strNameTXT.innerHTML="收件人<font color='#ff0000'>*</font>：";
								Invoice_strPhoneTXT.innerHTML="收件人电话<font color='#ff0000'>*</font>：";
							}else if (InvoiceType=='4') {
								InvoiceCompanyAddDiv.style.display="block";
								InvoiceCompanyBankDiv.style.display="block";
								Invoice_strAddDiv.style.display="block";
								Invoice_strEmailDiv.style.display="none";
								Invoice_strNameTXT.innerHTML="收件人<font color='#ff0000'>*</font>：";
								Invoice_strPhoneTXT.innerHTML="收件人电话<font color='#ff0000'>*</font>：";
							}
						}
						//新建字典-保存
						function JS_CarCreateSave()
						{
							InvoiceType=document.form2.InvoiceType.value;
							InvoiceMoney=document.form2.InvoiceMoney.value;
							InvoiceName=document.form2.InvoiceName.value;
							InvoiceCompanyID=document.form2.InvoiceCompanyID.value;
							Invoice_strAdd=document.form2.Invoice_strAdd.value;
							Invoice_strName=document.form2.Invoice_strName.value;
							Invoice_strPhone=document.form2.Invoice_strPhone.value;
							Invoice_strEmail=document.form2.Invoice_strEmail.value;
							if (InvoiceMoney==''){alert("请填写开票金额！");return false;}
							if (InvoiceName==''){alert("请填写发票抬头！");return false;}
							if (InvoiceName.indexOf("公司")>=0 && InvoiceCompanyID==''){alert("请填写纳税识别号！");return false;}
							if (InvoiceType=='2'){
								if (Invoice_strEmail==''){alert("请填写电子邮箱！");return false;}
								if (Invoice_strPhone==''){alert("请填写接收短信电话！");return false;}
							}else if (InvoiceType=='3'){
								if (Invoice_strPhone==''){alert("请填写收件人电话！");return false;}
								if (Invoice_strName==''){alert("请填写收件人！");return false;}
								if (Invoice_strAdd==''){alert("请填写邮寄地址！");return false;}
							}
							form2.submit();
						}
						//受理单调单查询
						function JS_ServiceOrdSearch()
						{
						ServiceOrdNo=document.form2.ServiceOrdNo.value;
						window.HiddenFrame.location.replace('Search_ServiceOrd.gds?Invoice=1&ServiceOrdNo='+ServiceOrdNo);
						}
						//显示车牌号
						function JS_PaidMoneyData(ServiceOrdID,ServiceOrdPtName,InvoiceMoney)
						{
							
							if (ServiceOrdID=='')
							{
								document.form2.ServiceOrdID.value=0;
								alert("服务单号错误!!");
							}
							else 
							{
								if (InvoiceMoney==0){
									document.getElementById('ErrorsTXT').innerHTML = '已有开票记录,禁止重复申请!!'; 
									//JS_CarGasAdd();
								}else{
									document.form2.ServiceOrdID.value=ServiceOrdID;
									document.getElementById('InvoiceMoney').value = InvoiceMoney; 
									document.getElementById('ServiceOrdNo').className = 'valid'; 
									document.getElementById('ServiceOrdNo').readOnly=true;
									document.getElementById('AuditMakeout').className = ''; 
									document.getElementById('AuditMakeout').readOnly=false;
									document.getElementById('InvoiceMoney').className = ''; 
									document.getElementById('InvoiceMoney').readOnly=false;
									document.getElementById('InvoiceNo').className = ''; 
									document.getElementById('InvoiceNo').readOnly=false;
									document.getElementById('InvoiceName').value = ServiceOrdPtName; 
									document.getElementById('InvoiceName').className='';
									document.getElementById('InvoiceName').readOnly=false;
									document.getElementById('InvoiceMakeout').className = ''; 
									document.getElementById('InvoiceMakeout').readOnly=false;
									document.getElementById('InvoiceCompanyPhone').className = ''; 
									document.getElementById('InvoiceCompanyPhone').readOnly=false;
									document.getElementById('InvoiceCompanyID').className = ''; 
									document.getElementById('InvoiceCompanyID').readOnly=false;
									document.getElementById('InvoiceCompanyAdd').className = ''; 
									document.getElementById('InvoiceCompanyAdd').readOnly=false;
									document.getElementById('InvoiceCompanyBank').className = ''; 
									document.getElementById('InvoiceCompanyBank').readOnly=false;
									document.getElementById('InvoiceCompanyBankNo').className = ''; 
									document.getElementById('InvoiceCompanyBankNo').readOnly=false;
									document.getElementById('InvoiceZipCode').className = ''; 
									document.getElementById('InvoiceZipCode').readOnly=false;
									document.getElementById('Invoice_strAdd').className = ''; 
									document.getElementById('Invoice_strAdd').readOnly=false;
									document.getElementById('Invoice_strEmail').className = ''; 
									document.getElementById('Invoice_strEmail').readOnly=false;
									document.getElementById('Invoice_strName').className = ''; 
									document.getElementById('Invoice_strName').readOnly=false;
									document.getElementById('Invoice_strPhone').className = ''; 
									document.getElementById('Invoice_strPhone').readOnly=false;
								}
							}
						}
						//新建单据信息
						function JS_CarGasAdd()
						{
							CarCreate.style.display='block';
							document.getElementById('EditPhotoTXT').innerHTML = '新建发票申请'; 
							document.getElementById('ErrorsTXT').innerHTML = ''; 
							document.form2.admin_save.value='13';
							document.form2.ServiceOrdID.value=0;
							document.form2.InvoiceID.value=0;
							document.getElementById('ServiceOrdNo').value = ''; 
							document.getElementById('ServiceOrdNo').className = ''; 
							document.getElementById('ServiceOrdNo').readOnly=false;
							document.getElementById('AuditMakeout').value = ''; 
							document.getElementById('AuditMakeout').className = 'valid'; 
							document.getElementById('AuditMakeout').readOnly=true;
							document.getElementById('InvoiceMoney').value = ''; 
							document.getElementById('InvoiceMoney').className = 'valid'; 
							document.getElementById('InvoiceMoney').readOnly=true;
							document.getElementById('InvoiceNo').value = ''; 
							document.getElementById('InvoiceNo').className = 'valid'; 
							document.getElementById('InvoiceNo').readOnly=true;
							document.getElementById('InvoiceName').value = ''; 
							document.getElementById('InvoiceName').className = 'valid'; 
							document.getElementById('InvoiceName').readOnly=true;
							document.getElementById('InvoiceMakeout').value = ''; 
							document.getElementById('InvoiceMakeout').className = 'valid'; 
							document.getElementById('InvoiceMakeout').readOnly=true;
							
							document.getElementById('InvoiceCompanyPhone').value = ''; 
							document.getElementById('InvoiceCompanyPhone').className = 'valid'; 
							document.getElementById('InvoiceCompanyPhone').readOnly=true;
							document.getElementById('InvoiceCompanyID').value = ''; 
							document.getElementById('InvoiceCompanyID').className = 'valid'; 
							document.getElementById('InvoiceCompanyID').readOnly=true;
							document.getElementById('InvoiceCompanyAdd').value = ''; 
							document.getElementById('InvoiceCompanyAdd').className = 'valid'; 
							document.getElementById('InvoiceCompanyAdd').readOnly=true;
							document.getElementById('InvoiceCompanyBank').value = ''; 
							document.getElementById('InvoiceCompanyBank').className = 'valid'; 
							document.getElementById('InvoiceCompanyBank').readOnly=true;
							document.getElementById('InvoiceCompanyBankNo').value = ''; 
							document.getElementById('InvoiceCompanyBankNo').className = 'valid'; 
							document.getElementById('InvoiceCompanyBankNo').readOnly=true;
							document.getElementById('InvoiceZipCode').value = ''; 
							document.getElementById('InvoiceZipCode').className = 'valid'; 
							document.getElementById('InvoiceZipCode').readOnly=true;
							document.getElementById('Invoice_strAdd').value = ''; 
							document.getElementById('Invoice_strAdd').className = 'valid'; 
							document.getElementById('Invoice_strAdd').readOnly=true;
							document.getElementById('Invoice_strEmail').value = ''; 
							document.getElementById('Invoice_strEmail').className = 'valid'; 
							document.getElementById('Invoice_strEmail').readOnly=true;
							document.getElementById('Invoice_strName').value = ''; 
							document.getElementById('Invoice_strName').className = 'valid'; 
							document.getElementById('Invoice_strName').readOnly=true;
							document.getElementById('Invoice_strPhone').value = ''; 
							document.getElementById('Invoice_strPhone').className = 'valid'; 
							document.getElementById('Invoice_strPhone').readOnly=true;

							document.getElementById('ApplicationTime').innerHTML = ''; 
							document.getElementById('AuditTime').innerHTML = ''; 
							document.getElementById('AuditOAID').innerHTML = ''; 
							$("#AuditStatus").val(0);
							$("#InvoiceType").val(2);
							document.form2.ServiceOrdNo.value='';
							JS_InvoiceType();
						}

						//显示修改单据信息
						function JS_InvoiceEdit(InvoiceID,ServiceOrdID,ServiceOrdNo,InvoiceName,InvoiceMakeout,InvoiceCompanyPhone,InvoiceCompanyID,InvoiceCompanyAdd,InvoiceCompanyBank,InvoiceCompanyBankNo,InvoiceZipCode,Invoice_strAdd,Invoice_strEmail,Invoice_strName,Invoice_strPhone,AuditMakeout,InvoiceMoney,InvoiceNo,ApplicationTime,AuditTime,AuditOAID,AuditStatus,InvoiceType,InvoiceURL,EleCloud_ZTDM,EleCloud_ZTXX,EleCloud_Time)
						{
							CarCreate.style.display='block';
							document.getElementById('EditPhotoTXT').innerHTML = '发票申请信息'; 
							document.form2.admin_save.value='13';
							document.form2.ServiceOrdID.value=ServiceOrdID;
							document.form2.InvoiceID.value=InvoiceID;
							document.getElementById('ServiceOrdNo').value = ServiceOrdNo; 
							document.getElementById('ServiceOrdNo').className = 'valid'; 
							document.getElementById('ServiceOrdNo').readOnly=true;
							document.getElementById('AuditMakeout').value = AuditMakeout; 
							document.getElementById('AuditMakeout').className = ''; 
							document.getElementById('AuditMakeout').readOnly=false;
							document.getElementById('InvoiceMoney').value = InvoiceMoney; 
							document.getElementById('InvoiceMoney').className = ''; 
							document.getElementById('InvoiceMoney').readOnly=false;
							document.getElementById('InvoiceNo').value = InvoiceNo; 
							document.getElementById('InvoiceNo').className = ''; 
							document.getElementById('InvoiceNo').readOnly=false;
							document.getElementById('InvoiceName').value = InvoiceName; 
							document.getElementById('InvoiceName').className = ''; 
							document.getElementById('InvoiceName').readOnly=false;
							document.getElementById('InvoiceMakeout').value = InvoiceMakeout; 
							document.getElementById('InvoiceMakeout').className = ''; 
							document.getElementById('InvoiceMakeout').readOnly=false;
							
							document.getElementById('InvoiceCompanyPhone').value = InvoiceCompanyPhone; 
							document.getElementById('InvoiceCompanyPhone').className = ''; 
							document.getElementById('InvoiceCompanyPhone').readOnly=false;
							document.getElementById('InvoiceCompanyID').value = InvoiceCompanyID; 
							document.getElementById('InvoiceCompanyID').className = ''; 
							document.getElementById('InvoiceCompanyID').readOnly=false;
							document.getElementById('InvoiceCompanyAdd').value = InvoiceCompanyAdd; 
							document.getElementById('InvoiceCompanyAdd').className = ''; 
							document.getElementById('InvoiceCompanyAdd').readOnly=false;
							document.getElementById('InvoiceCompanyBank').value = InvoiceCompanyBank; 
							document.getElementById('InvoiceCompanyBank').className = ''; 
							document.getElementById('InvoiceCompanyBank').readOnly=false;
							document.getElementById('InvoiceCompanyBankNo').value = InvoiceCompanyBankNo; 
							document.getElementById('InvoiceCompanyBankNo').className = ''; 
							document.getElementById('InvoiceCompanyBankNo').readOnly=false;
							document.getElementById('InvoiceZipCode').value = InvoiceZipCode; 
							document.getElementById('InvoiceZipCode').className = ''; 
							document.getElementById('InvoiceZipCode').readOnly=false;
							document.getElementById('Invoice_strAdd').value = Invoice_strAdd; 
							document.getElementById('Invoice_strAdd').className = ''; 
							document.getElementById('Invoice_strAdd').readOnly=false;
							document.getElementById('Invoice_strEmail').value = Invoice_strEmail; 
							document.getElementById('Invoice_strEmail').className = ''; 
							document.getElementById('Invoice_strEmail').readOnly=false;
							document.getElementById('Invoice_strName').value = Invoice_strName; 
							document.getElementById('Invoice_strName').className = ''; 
							document.getElementById('Invoice_strName').readOnly=false;
							document.getElementById('Invoice_strPhone').value = Invoice_strPhone; 
							document.getElementById('Invoice_strPhone').className = ''; 
							document.getElementById('Invoice_strPhone').readOnly=false;

							document.getElementById('ApplicationTime').innerHTML = ApplicationTime; 
							document.getElementById('AuditTime').innerHTML = AuditTime; 
							document.getElementById('AuditOAID').innerHTML = AuditOAID; 
							$("#AuditStatus").val(AuditStatus);
							$("#InvoiceType").val(InvoiceType);
							document.form2.ServiceOrdNo.value=ServiceOrdNo;
							JS_InvoiceType();
						}
					</script>

					<div class="dialogJ  dialogJfix dialogJshadow" id="CarCreate" style="width:800px; right: 300px; top: 80px;display:none;">
					
						<div class="dialogJtitle">
							<a href="javascript:JS_CarCreateClose();" class="dialogJclose" title="关闭本窗口">&nbsp;</a>
							<span class="dialogJtxt" id="EditPhotoTXT">发票申请信息</span>
						</div>
						<form id="form2" name="form2" action="admin_save.php" method="post">
						<input name="admin_save" type="hidden" value="13">
						<input name="searchTXT" type="hidden" value="<?php echo $searchTXT?>">
						<input name="ServiceOrdID" type="hidden" value="">
						<input name="InvoiceID" type="hidden" value="0">
						<input name="page" type="hidden" value="<?php echo $page?>">
						<div class="dialogJcontent">
							<div class="dialogJbody" id="dialogJbody">
								<div class="modify-album-name">
									<span>服务单号：</span>
									<input id="ServiceOrdNo" name="ServiceOrdNo" type="text" value="" style="width: 165px;" maxlength="99/"><input type="button" style="text-indent:initial;" class="dialogJbtn first-child" onclick="JS_ServiceOrdSearch()" value="调用"> <input type="button" style="text-indent:initial;" class="dialogJbtn first-child" onclick="JS_CarGasAdd()" value="重置"> <span class="dialogJtxt" id="ErrorsTXT" style="color: #ef0303;"></span>
								</div>
								<div class="modify-album-name">
									<span>处理状态：</span>
									<select id="AuditStatus" name="AuditStatus" style="padding: 5px 0 5px 8px;">
										<?php for($i=0;$i<count($AuditStatusArray);$i++) {?>
										  <option value="<?php echo $AuditStatusArray[$i][0]?>"><?php echo $AuditStatusArray[$i][1]?></option>
										<?php }?>
									</select>
									<span>处理日期：</span>
									<span id="AuditTime"></span>
									<span>处理人员：</span>
									<span id="AuditOAID"></span>
								</div>
								<div class="modify-album-name">
									<span>处理备注：</span>
									<input id="AuditMakeout" name="AuditMakeout" type="text" value="" maxlength="99/" style="width: 400px;" readonly="true" class="valid">
								</div>
								<div class="modify-album-name">
									<span>发票号码：</span>
									<input id="InvoiceNo" name="InvoiceNo" type="text" value="" maxlength="99/" style="width: 400px;" readonly="true" class="valid">
								</div>
								<div class="modify-album-name">
									<span>发票类型：</span>
									<select id="InvoiceType" name="InvoiceType" onchange="JS_InvoiceType();" style="padding: 5px 0 5px 8px;">
										<option value="1">不开发票</option>
										<option value="2">电子发票</option>
										<option value="3">增值税普票</option>
										<option value="4">增值税专票</option>
									</select>
									<span>开票金额<font color="#ff0000">*</font>：</span>
									<input id="InvoiceMoney" name="InvoiceMoney" type="text" value="" maxlength="99/" style="width: 100px;" readonly="true" class="valid">
									<span>申请日期：</span>
									<span id="ApplicationTime"></span>
								</div>
								<div class="modify-album-name">
									<span>发票抬头<font color="#ff0000">*</font>：</span>
									<input id="InvoiceName" name="InvoiceName" type="text" value="" maxlength="99/" style="width: 400px;" readonly="true" class="valid">
								</div>
								<div class="modify-album-name">
									<span>发票备注：</span>
									<input id="InvoiceMakeout" name="InvoiceMakeout" type="text" value="" maxlength="99/" style="width: 400px;" readonly="true" class="valid">
								</div>
								<div class="modify-album-name">
									<span>纳税识别号：</span>
									<input id="InvoiceCompanyID" name="InvoiceCompanyID" type="text" value="" maxlength="99/" style="width: 388px;" readonly="true" class="valid">
								</div>
								<div class="modify-album-name"  id="InvoiceCompanyAddDiv" style="display:none;">
									<span>企业注册地址：</span>
									<input id="InvoiceCompanyAdd" name="InvoiceCompanyAdd" type="text" value="" maxlength="99/" style="width: 300px;" readonly="true" class="valid">
									<span>企业电话：</span>
									<input id="InvoiceCompanyPhone" name="InvoiceCompanyPhone" type="text" value="" maxlength="99/" style="width: 200px;" readonly="true" class="valid">
								</div>
								<div class="modify-album-name" id="InvoiceCompanyBankDiv" style="display:none;">
									<span>企业开户银行：</span>
									<input id="InvoiceCompanyBank" name="InvoiceCompanyBank" type="text" value="" maxlength="99/" style="width: 200px;" readonly="true" class="valid">
									<span>企业银行账号：</span>
									<input id="InvoiceCompanyBankNo" name="InvoiceCompanyBankNo" type="text" value="" maxlength="99/" style="width: 276px;" readonly="true" class="valid">
								</div>
								<div class="modify-album-name" id="Invoice_strAddDiv" style="display:none;">
									<span>邮寄地址：</span>
									<input id="Invoice_strAdd" name="Invoice_strAdd" type="text" value="" maxlength="99/" style="width: 448px;" readonly="true" class="valid">
									<span>邮编：</span>
									<input id="InvoiceZipCode" name="InvoiceZipCode" type="text" value="" maxlength="99/" style="width: 100px;" readonly="true" class="valid">
								</div>
								<div class="modify-album-name"  id="Invoice_strEmailDiv">
									<span>接收电子邮箱<font color="#ff0000">*</font>：</span>
									<input id="Invoice_strEmail" name="Invoice_strEmail" type="text" value="" maxlength="99/" style="width: 200px;" readonly="true" class="valid">若无邮箱，请填写“无”
								</div>
								<div class="modify-album-name">
									<span id="Invoice_strNameTXT">联系人<font color="#ff0000">*</font>：</span>
									<input id="Invoice_strName" name="Invoice_strName" type="text" value="" maxlength="99/" style="width: 200px;" readonly="true" class="valid">
									<span id="Invoice_strPhoneTXT">联系电话<font color="#ff0000">*</font>：</span>
									<input id="Invoice_strPhone" name="Invoice_strPhone" type="text" value="" maxlength="99/" style="width: 200px;" readonly="true" class="valid">
								</div>
							</div>
						</div>
						</form>
						<div class="dialogJanswers" style="padding: 30px 20px 13px 18px;">
							<input type="button" class="dialogJbtn first-child" onclick="JS_CarCreateSave()" value="确定"> 
							<input type="button" class="dialogJbtn" onclick="JS_CarCreateClose()" value="取消">
						</div>
					</div>

							<div class="search">
							<form action="?" method="post">
								<div class="input">
									<input type="text" id="searchTXT" name="searchTXT" value="<?php echo $searchTXT?>" />
								</div>
								
								<div class="button">
									<input type="submit" name="submit" value="搜索" />
								</div>
							</form>
							</div>
						</ul>
					</div>
					<!-- end box / title -->
					<?php
					//分页信息
					$page=empty($_REQUEST['page'])==true ? 1 : $_REQUEST['page']; //当前页数
					$page=empty($draw)==true ? $page : $draw; //当前页数
					$page_size = 20;	//每页显示数量
					$total_page=0;			//总页数
					$total_records=0;			//总记录数
					//查询条件
					$searchSql="";
					$searchTXT=empty($searchTXT)==true ? "" : $searchTXT;
					if (strlen($searchTXT)==14 and !is_numeric(substr($searchTXT,0,2)) And is_numeric(substr($searchTXT,2,8)) And is_numeric(substr($searchTXT,-3)) And substr($searchTXT,10,1)=="-"){
						$searchSql=" and ((ServiceOrdClass='".substr($searchTXT,0,2)."' and CONVERT(VARCHAR(10),ServiceOrd_CC_Time,120)=CONVERT(VARCHAR(10),'".substr($searchTXT,2,4)."-".substr($searchTXT,6,2)."-".substr($searchTXT,8,2)."',120) and Right('00'+convert(varchar(3),ServiceOrdNo),3)='".substr($searchTXT,-3)."') or ServiceOrdID in (select ServiceOrdIDDt from DispatchOrd where DispatchOrdClass='".substr($searchTXT,0,2)."' and CONVERT(VARCHAR(10),DispatchOrd_NS_Time,120)=CONVERT(VARCHAR(10),'".substr($searchTXT,2,4)."-".substr($searchTXT,6,2)."-".substr($searchTXT,8,2)."',120) and Right('00'+convert(varchar(3),DispatchOrdNo),3)='".substr($searchTXT,-3)."')) ";
					}elseif ($searchTXT!=""){
						$searchSql=" and (InvoiceName like '%$searchTXT%' or InvoiceNo='$searchTXT') ";
					}elseif ($AuditStatus!=-1) {
						$searchSql=" and Points_State=$AuditStatus ";
						$searchSql = $searchSql." and Points_Time ".$SqlOrdDateType;
					}else{
						$searchSql=" and Points_State<>4 ";
						$searchSql = $searchSql." and Points_Time ".$SqlOrdDateType;
					}
					//$searchSql = $searchSql." and ApplicationTime ".$SqlOrdDateType;
					$orderby=empty($orderby)==true ? "" : $orderby;
					If (strrpos($orderby," desc")>1){
						$orderbydesc="";
						$descTXT="↓";
					}else{
						$orderbydesc=" desc";
						$descTXT="↑";
					}

					If ($orderby=="") {
					  $orderby="OutHosp|InHosp desc,OutHospPrice|InHospPrice desc";
					  $descTXT="↓";
					}
					//echo $OrdClassListSql;

					//查询开始
					$InvoiceType=empty($InvoiceType)==true ? "1" : $InvoiceType;
					//按调度单统计
					//SQL查询条件
					$sqlWhere=" from UserPoints,UserData where UserID=ToUserID and Points_Type=4".$searchSql;
					//组成计算总页数SQL
					$total_sql = "select Pid $sqlWhere";	
					//组成显示结果SQL
					$Result_sql = "select Pid,UserID,Points_Score=abs(Points_Score),Points_Type,Points_Time=CONVERT(nvarchar(20),Points_Time,120),Points_State,Points_Value1,Points_Value2,Points_Value3,UserName,UserPhone,UserNickName,AuditTime=CONVERT(nvarchar(20),AuditTime,120),AuditOAID,AuditMakeout,row_number() over (order by Points_Time desc) n  $sqlWhere";	
					//附加结果SQL
					$Additional_sql = "";

					//计算总页数
					$data = sqlsrv_query( $conn, $total_sql, array(), array( "Scrollable" => 'keyset' ));
					$total_records=sqlsrv_num_rows($data);	//总行数
					$total_page=ceil($total_records/$page_size);	//总页数
					//避免page小于0或大于总页数
					$page=$page<=0?1:$page;
					$page=$page>$total_page?$total_page:$page;  
					//计算开始和结束行数
					$pageStart = ($page-1)*$page_size;
					$pageEnd = $pageStart+$page_size;
					$sqlPage = " where sqlData.n > $pageStart and sqlData.n <= $pageEnd " ;

					$sql = "select * $Additional_sql from ($Result_sql) sqlData ".$sqlPage." order by sqlData.n" ;
					//echo $sql;exit;
					$data = sqlsrv_query($conn,$sql);
					if (sqlsrv_rows_affected($data)==0) {
						$SystemMessageType=2;
						$SystemMessageTXT="数据库中相关无数据！";
					}
					?>
					<?php require '/inc/SystemMessages.php';?>
					<div class="table" style="overflow:auto">
						<form id="form1" name="form1" action="" method="post">
						<input name="admin_save" type="hidden" value="13">
						<input name="Car_Check" type="hidden" value="">
						<input name="searchTXT" type="hidden" value="<%=searchTXT%>">
						<input name="page" type="hidden" value="<%=acc1%>">
						<table>
							<thead>
								<tr style="white-space: nowrap;">
									<th>积分流水号</th>
									<th>用户姓名</th>
									<th>用户电话</th>
									<th>申请时间</th>
									<th>提现金额</th>
									<th>提现方式</th>
									<th>提现备注</th>
									<th>处理状态</th>
									<th>处理人</th>
									<th>处理时间</th>
									<th class="last">处理备注</th>
								</tr>
							</thead>
							<tbody>
			<?php 
			$i=1;
			while($rs = sqlsrv_fetch_array( $data, SQLSRV_FETCH_ASSOC) ) {
				$i++;
				$Pid				= $rs['Pid'];		//积分流水号
				$UserID				= $rs['UserID'];		//用户ID
				$Points_Score		= floor($rs['Points_Score']);		//提现金额
				$Points_Type	= $rs['Points_Type'];		//积分类型

				$Points_Time			= $rs['Points_Time'];			//申请时间
				$Points_State		= $rs['Points_State'];		//处理状态
				$Points_Value1		= $rs['Points_Value1'];		//提现方式
				$Points_Value2		= $rs['Points_Value2'];		//提现备注
				$Points_Value3		= $rs['Points_Value3'];		//处理状态(中文)

				$UserName			= $rs['UserName'];	//用户姓名
				$UserPhone			= $rs['UserPhone'];//用户电话
				$UserNickName		= $rs['UserNickName'];//用户微信名称
				$AuditTime			= $rs['AuditTime'];			//处理时间
				$AuditOAID			= $rs['AuditOAID'];			//处理人
				$AuditMakeout		= $rs['AuditMakeout'];		//处理备注

				$AuditOAName=empty($AuditOAID)==true ? "--" : OAUser($AuditOAID,"UserName");
			?>
			
			  <tr style="white-space: nowrap;">
				<td class="category category2"><?php echo $Pid?></td>
				<td class="category category2"><?php echo $UserName?></td>
				<td class="category category2"><?php echo $UserPhone?></td>
				<td class="category category2"><?php echo $Points_Time?></td>
				<td class="category category2"><?php echo $Points_Score?></td>
				<td class="category category2"><?php echo $Points_Value1?></td>
				<td class="category category2"><?php echo $Points_Value2?></td>
				<td class="category category2"><?php echo $Points_Value3?></td>
				<td class="category category2"><?php echo $AuditTime?></td>
				<td class="category category2"><?php echo $AuditOAName?></td>
				<td class="category category2 last"><?php echo $AuditMakeout?></td>
			  </tr>
			<?php }?>
			<?php
			$classHtml="";
			for($j=$i;$j<=20;$j++) {
				echo "<tr>";
				echo "<td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td class='last'>&nbsp;</td>";
				echo "</tr>";
			}
			?>
							</tbody>
						</table>
						<!-- 分页 -->
						<?php if ($total_records>=1) {?>
						<div class="pagination pagination-left">
							<div class="results">
								<?php
								$ShowingLeast = ($page-1)*$page_size+1;
								$ShowingMax = $page_size*$page;
								if ($ShowingMax>$total_records) {$ShowingMax=$total_records;}
								?>
								<span><?php echo "显示&nbsp;$ShowingLeast-$ShowingMax&nbsp;of&nbsp;$total_records";?></span>
							</div>
							<?php if ($total_page>1) {?>
							<ul class="pager">
								<?php
								if ($page==1) {
									echo "<li class=\"disabled\">&laquo; 上页</li>";
								}else{
									echo "<li><a href=\"?page=".($page-1)."&".$page_URL."\">&laquo; 上页</a></li>";
								}
								
								$acc4=0;
								for($i=1;$i<=$total_page;$i++) {
									if ($i==$page) {echo "<li class=\"current\">$i</li>";}
									elseif ($i<=3 or $i>($total_page-3)  ) {echo "<li><a href=\"?page=$i&$page_URL\">$i</a></li>";}
									elseif ($acc4==0){echo "<li class=\"separator\">...</li>";$acc4=$i<$page ? 1 : 2;}
									elseif ($acc4==1 and $i>$page+3){echo "<li class=\"separator\">...</li>";$acc4=2;}
									elseif ($acc4==1 and $i>=$page-3){echo "<li><a href=\"?page=$i&$page_URL\">$i</a></li>";}
								}

								if ($page>=$total_page) {
									echo "<li class=\"disabled\">下页 &raquo;</li>";
								}else{
									echo "<li><a href=\"?page=".($page+1)."&".$page_URL."\">下页 &raquo;</a></li>";
								}
								?>
							</ul>
							<?php }?>
						</div>
						<?php }?>
						<!-- end 分页 -->
					</div>
				</div>
				<!-- end table -->


				
			</div>
			<!-- end content / right -->
		</div>
		<!-- end content -->
		<!--#include FILE="vicgame.asp"-->
		<IFRAME id="HiddenFrame" name="HiddenFrame" WIDTH=0 HEIGHT=0 MARGINWIDTH=0 MARGINHEIGHT=0 HSPACE=0 VSPACE=0 FRAMEBORDER=0 SCROLLING=no BORDERCOLOR=#ffffff></IFRAME>
	</body>
</html>