master

分支 (1)

标签 (4)

管理

管理

master

v1.1.0

v1.0.2

v1.0.1

v1.0.0

php_issue
/
versionlist.php

<?php
	include 'inc/conn.php';
	$pageSize = 40;
	echo "<!DOCTYPE html>\n";
?>
<html>
<head>
<title>版本管控系统(Firmware Version Control System)</title>
<meta http-equiv="content-type" content="text/html;charset=utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<!-- <link rel="stylesheet" href="https://cdn.staticfile.org/twitter-bootstrap/3.3.7/css/bootstrap.min.css">-->
<link rel="stylesheet" href="/css/bootstrap.min.css">
<script src="js/jquery.min.js"></script>
<script src="js/bootstrap.min.js"></script>
<!-- HTML5 shim and Respond.js for IE8 support of HTML5 elements and media queries -->
<!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
<!--[if lt IE 9]>
  <script src="https://oss.maxcdn.com/html5shiv/3.7.3/html5shiv.min.js"></script>
  <script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
<![endif]-->
<?
	$view=0;  /*default is list*/

	extract($_POST);
	extract($_GET);
	unset($_POST,$_GET);
	if (isset($view))
	{
		if ($view == "1"){
			$view=1;
		}else{
			$view=0;
		}
	}

	if (!isset($page))
		$page = 1;

	$pageCount = 0;
	$db = new mysql();
	$db->query("select count(id) as CNT from eng_version_control_table");
	$row = $db->fetch_assoc();
	$rowCount = $row['CNT'];
	$db->close();
	$pageCount = ceil(($rowCount/$pageSize));
	$pre = ($page-1)*$pageSize;
?>
<script language="javascript">
function   Go(it)   {
      window.location="<? echo $pagestr ?>?page="+it.value;
}
</script>

<script type="text/javascript">
function goTopEx() {
    var obj = document.getElementById("goTopBtn");
    function getScrollTop() {
        return document.documentElement.scrollTop + document.body.scrollTop;
    }
    function setScrollTop(value) {
        if (document.documentElement.scrollTop) {
            document.documentElement.scrollTop = value;
        } else {
            document.body.scrollTop = value;
        }
    }
    window.onscroll = function() {
        getScrollTop() > 0 ? obj.style.display = "": obj.style.display = "none";
    }
    obj.onclick = function() {
        var goTop = setInterval(scrollMove, 10);
        function scrollMove() {
            setScrollTop(getScrollTop() / 1.1);
            if (getScrollTop() < 1) clearInterval(goTop);
        }
    }
}
</script>
<style>
	BODY {
		HEIGHT: auto;
	}
	#goTopBtn {
		POSITION: fixed; TEXT-ALIGN: center; LINE-HEIGHT: 30px; WIDTH: 30px; BOTTOM: 35px;
		HEIGHT: 33px; FONT-SIZE: 12px; CURSOR: pointer; RIGHT: 0px; _position: absolute; _right: auto
	}
</style>

</head>
<body class="background">
<div style="display: none" id="goTopBtn"><img border=0 src="/image/top.jpg"></div>
<script type=text/javascript>goTopEx();</script>
<?
	include "top.php";

	echo "<div class='container-fluid'>";
	echo "<div><h3><span class='label label-primary'>版本管控系统(Firmware Version Control System)</span></h3></div>";
	echo "<div class='well'> ";
	echo "<form class='form-inline'>";
	echo "<div style='form-group'>";
	if (isset($search))
		echo "机种搜索：<input type='text' class='form-control' name='search' value='$search'><button type='submit' class='btn btn-info'>Search</button>";
	else
		echo "机种搜索：<input type='text' class='form-control' name='search'><button type='submit' class='btn btn-info'>Search</button>";
	echo "<div style='float:right'>操作：<a href='export-2003.php'><span class=\"glyphicon glyphicon-download-alt\"></span> 导出Excel</a></div>";
	echo "</form>";
	echo "</div>";
	echo "</div>";
	echo "<div>";
	echo "<table border=0 cellpadding=0 class='table table-striped'>";
	if ($view == 0){
		echo "<tr class='success'><th>Item</th><th>机种</th><th>客户</th><th>出货系统</th><th>BIOS版本</th><th>EC版本</th><th>负责人</th><th>建立日期</th><th>品保结果</th><th>备注</th></tr>";
	}
	$db = new mysql();
	if (isset($search))
	{
		$db->query("select * from eng_version_control_table where model_name like '%$search%' ORDER BY build_date DESC");
	}else
		$db->query("select * from eng_version_control_table ORDER BY build_date DESC limit $pre,$pageSize");
	$num = $db->db_num_rows();
	for($i=0; $i<$num; $i++){
		$row = $db->fetch_assoc();
		$item = $i + 1;
		echo "<tr>";
		echo "<td>$item</td>";
		echo "<td><a href=\"review_verlist.php?id=".$row['ID']."\">".htmlspecialchars_decode($row['Model_name'])."</a></td>";
		echo "<td>".htmlspecialchars_decode($row['Customer'])."</td>";
		echo "<td>".htmlspecialchars_decode($row['System_type'])."</td>";
		echo "<td>".htmlspecialchars_decode($row['BIOS_version'])."</td>";
		echo "<td>".htmlspecialchars_decode($row['EC_version'])."</td>";
		echo "<td>".htmlspecialchars_decode($row['Owner'])."</td>";
		echo "<td>".substr($row['Build_Date'],0,10)."</td>";
		if ($row['Q_result']==1)
			echo "<td><font color='green'>通过</font></td>";
		else
			echo "<td><font color='blue'>待测</font></td>";
		if(htmlspecialchars_decode($row['REMARK'])=="N/A")
			echo "<td>无</td>";
		else
			echo "<td title='".htmlspecialchars_decode($row['REMARK'])."'>看备注</td>";
		echo "</tr>\n";
	}
?>
		</table>
	</div>
	<? if($pageCount>1) { ?>
	<div align="center">
		<ul class='pager'>
			<li class='previous'><a href="<? echo $pagestr ?>?page=<?if($page>=2) echo $page-1; else echo $page;?>">&larr;上一页</a></li>
			第<select name="page" id="page" onchange="javascript:Go(this);">
			<?
				for($j=1;$j<=$pageCount;$j++){
					if($j==$page)
						echo "<option value='$j' selected='$j'>$j</option>\n";
					else
						echo "<option value='$j'>$j</option>\n";
				}
			?>
			</select>页
			<li class='next'><a href="<? echo $pagestr ?>?page=<?if($page<$pageCount) echo $page+1; else echo 1;?>">下一页&rarr;</a></li>
		</ul>
	</div>
	<? } ?>
</div>
<?
include 'bottom.php';
?>
</body>
</html>
<?
	$db->close();
?>