61,112
社区成员
发帖
与我相关
我的任务
分享
<!DOCTYPE html>
<html lang="zh-CN">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta name="keywords" content="" />
<meta name="description" content="" />
<link rel="stylesheet" href="css/bootstrap.css">
<script src="laydate/laydate.js"></script>
<script src="js/jquery-1.11.0.min.js" type="text/javascript" charset="utf-8"></script>
<script src="js/jquery.table2excel.js" type="text/javascript" charset="utf-8"></script>
</head>
<body>
<div class="header_wrap" style="background:#1ab394;">
<div id="header" class="auto" style="background:#1ab394;">
<div class="logo" style=" text-align:center;">Weida Freight System </div>
<div class="login">
</div>
</div>
</div>
<br />
<br />
<div style="margin-top:55px;"></div>
<form class="" method="get" role="form">
<div class="container">
<div class="row">
<div class="form-group col-lg-3">
<div class="input-group">
<span class="input-group-addon">DN#</span>
<input type="text" class="form-control" id="exampleInputName2" name="dn_no" value="<?php if(!empty($_GET['submit'])){echo $_GET['dn_no'];} ?>">
</div>
</div>
<div class="form-group col-lg-3">
<div class="input-group">
<span class="input-group-addon">HAWB</span>
<input type="text" class="form-control" id="exampleInputName2" name="bl_no" value="<?php if(!empty($_GET['submit'])){echo $_GET['bl_no'];} ?>"/>
</div>
</div>
<div class="form-group col-lg-3">
<div class="input-group">
<span class="input-group-addon">Ex-date</span>
<input class="form-control" name="sdate" onclick="laydate()" value="<?php if(!empty($_GET['submit'])){echo $_GET['sdate'];} ?>"/>
</div>
</div>
<div class="form-group col-lg-3">
<div class="input-group">
<input class="form-control" name="edate" id="demo" value="<?php if(!empty($_GET['submit'])){echo $_GET['edate'];} ?>"/>
</div>
</div>
</div>
<div class="row">
<div class="form-group col-lg-3">
<div class="input-group">
<span class="input-group-addon">Dest</span>
<input class="form-control" type="text" name ="dest_nm" value="<?php if(!empty($_GET['submit'])){echo $_GET['dest_nm'];} ?>"/>
</div>
</div>
<div class="form-group col-lg-3">
<div class="input-group">
<span class="input-group-addon">Transport</span>
<select class="form-control" id="select_1" onclick="setCookie('select_1',this.selectedIndex)" name="sales_dep" disabled="disabled">
<option value="AIR">AIR</option>
<option value="SEA">SEA</option>
<option value="RAIL">RAIL</option>
</select>
</div>
</div>
<div class="form-group col-lg-3">
<div class="input-group">
<span class="input-group-addon">CustomerPN</span>
<input class="form-control" type="text" name ="customer_pn" value="<?php if(!empty($_GET['submit'])){echo $_GET['customer_pn'];} ?>"/>
</div>
</div>
</div>
<div class="row">
<div class="form-group col-lg-3">
<div class="input-group">
<span class="input-group-addon">Order No</span>
<input class="form-control" type="text" name ="order_no" value="<?php if(!empty($_GET['submit'])){echo $_GET['order_no'];} ?>"/>
</div>
</div>
<div class="form-group col-lg-3">
<div class="input-group">
<span class="input-group-addon">Term</span>
<input class="form-control" type="text" name ="svc_mode_term" value="<?php if(!empty($_GET['submit'])){echo $_GET['svc_mode_term'];} ?>"/>
</div>
</div>
</div>
<!--<input name="ok" id="ok" type="hidden" /> -->
<div class="row">
<div class="form-group col-lg-3">
<label for="exampleInputName2">BU: </label>
</div>
</div>
<br />
<button class="btn btn-primary" type="submit" name="submit" value="submit" id="submit" >Search</button>
<button class="btn btn-success" type="button" id="btn" name="btn">Export excel</button>
<input class="btn btn-warning" type="submit" name="sign up" value="Reset"/>
<br />
<br />
</div>
</form>
<script type="text/javascript">
$('#form').children(':text').focus(function(){
if(!this.initValue){
this.initValue = this.value;
}
if(this.value === this.initValue){
this.value = '';
}
}).blur(function(){
if(this.value === '' || this.value === null){
this.value = this.initValue;
}
});
</script>
<div class="table-responsive" style="overflow:scroll;">
<table class="table table-striped table-bordered" id="hb" style="min-width:1500px;">
<thead>
<tr>
<td><b>#</b></td>
<td><b>DN#</b></td>
<td><b>HAWB</b></td>
<td><b>Dest</b></td>
<td><b>Transport</b></td>
<td><b>CustomerPN</b></td>
<td><b>Order No.</b></td>
<td><b>BU</b></td>
<td><b>Term</b></td>
<td><b>ETD</b></td>
<td><b>ETA</b></td>
<td><b>ATD</b></td>
<td><b>ATA</b></td>
</tr>
</thead>
<?php
<tr>
<td><?php echo $data['rownumber'];?></td>
<td><?php
$download="SELECT * FROM EDC_ACCESS_LOG WHERE DN_NO='{$data['DN_NO']}'";
$dlresult=sqlsrv_query($conn, $download);
$dldata=sqlsrv_fetch_array($dlresult,SQLSRV_FETCH_ASSOC);
if(!empty($dldata['FILE_DESCP'])){?>
<a href="download.php?dn_no=<?php echo $data['DN_NO']?>" style="color: #ee3e1b" onclick="window.open(this.href, '_blank', 'width=500,height=300,top=300,left=300,resizable=yes,toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no');return false"><?php echo $data['DN_NO']?></a>
<?php }else{
echo $data['DN_NO'];
}
?></td>
<td><?php echo $data['BL_NO'];?></td>
<td><?php echo $data['DEST_NM']?></td>
<td><?php if(!empty($_GET['submit'])){ echo 'AIR';}?></td>
<td><?php echo $data['CUSTOMER_PN'];?></td>
<td><?php echo $data['ORDER_NO'];?></td>
<td><?php echo $data['BU'];?></td>
<td><?php echo $data['SVC_MODE_TERM'];?></td>
<td><?php if(empty($data['ETD']) || $etd==$abc){echo '';}else{echo $etd;}?></td>
<td><?php if(empty($data['ETA']) || $eta==$abc){echo '';}else{echo $eta;}?></td>
<td><?php if(empty($data['ATD']) || $atd==$abc){echo '';}else{echo $atd;}?></td>
<td><?php if(empty($data['ATA']) || $ata==$abc){echo '';}else{echo $ata;}?></td>
</tr>
<?php
}
?>
</table>
</div>
<div class="pages_wrap">
<div class="pages">
<?php
echo "Page ";
echo $page['html'];
echo " Total {$count} records";?>
</div>
<div style="clear:both;"></div>
</div>
<?php
}else{
echo '<script language="javascript">
alert("No record!");
</script>
';
}
?>
<div id="footer" class="auto">
<div class="bottom">
<a>Footer</a>
</div>
<div class="copyright">2018 </div>
</div>
<script src="js/jquery.table2excel.js"></script>
<script src="js/bootstrap.min.js"></script>
</body>
</html>