| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379 |
- <%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
- <%@ page import="com.runzhixing.bean.CityPlace" %>
- <%@ page import="com.runzhixing.bean.CountryPlace" %>
- <%@ page import="com.runzhixing.bean.Station" %>
- <%@ page import="com.runzhixing.bean.AuthorityRegionPlace" %>
- <%@ page import="com.runzhixing.bean.User" %>
- <%@ page import="com.runzhixing.constant.Constant" %>
- <%
- String path = request.getContextPath();
- String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
- User user = (User)session.getAttribute(Constant.userMark);
- List<AuthorityRegionPlace> arplist = user.getPrivilegePlaces1();
- List<CityPlace> cplist = new ArrayList<CityPlace>();
- List<CountryPlace> cyplist = new ArrayList<CountryPlace>();
- List<Station> slist = new ArrayList<Station>();
- %>
- <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
- <html>
- <head>
- <base href="<%=basePath%>">
-
- <title>气瓶数据查询</title>
-
- <meta http-equiv="pragma" content="no-cache">
- <meta http-equiv="cache-control" content="no-cache">
- <meta http-equiv="expires" content="0">
- <meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
- <meta http-equiv="description" content="This is my page">
- <meta http-equiv="X-UA-Compatible" content="IE=9"/>
- <meta http-equiv="X-UA-Compatible" content="IE=10"/>
- <link rel="stylesheet" type="text/css" href="css/easyui/themes/default/easyui.css">
- <link rel="stylesheet" type="text/css" href="css/easyui/themes/icon.css">
- <link rel="stylesheet" type="text/css" href="css/easyui/demo/demo.css">
- <script type="text/javascript" src="css/easyui/jquery.min.js"></script>
- <script type="text/javascript" src="css/easyui/jquery.easyui.min.js" charset="utf-8"></script>
- <script type="text/javascript" src="css/easyui/locale/easyui-lang-zh_CN.js" charset="utf-8"></script>
- <link rel="stylesheet" type="text/css" href="css/common/hzbstyle.css">
- <script type="text/javascript">
- var i = 1;//第几页
- var sum;//总条数
- var totalpage;//总页数
- $(document).ready(function(){
- fLoadTable();
- pageSize = $('#pageSize').val();
- fLoadData(i,pageSize);
- selectCountry();
- });
- function fLoadTable(){
- var st = $('#st').val();
- var et = $('#et').val();
- if(st!=null&&st!=""){
- $("#searchst").datebox("setValue", st);
-
- }
- if(et!=null&&et!=""){
- $("#searchet").datebox("setValue", et);
- }
- $('#tt').datagrid({
- fit: true,//自动大小
- title: '参数表',
- width: '100%',
- height: 580,
- toolbar: '#toolbar',
- fitColumns: true,
- singleSelect:false,
- loadMsg:'正在加载, 请稍等 …',
- nowrap : true,//设置为true,当数据长度超出列宽时将会自动截取
- striped : true,//设置为true将交替显示行背景
- collapsible : true,//显示可折叠按钮
- singleSelect:true,//为true时只能选择单行
- fitColumns:true,//允许表格自动缩放,以适应父容器
- rownumbers:true,
- pagination:true,//分页控件
- frozenColumns:[[ //选择框
- {field:'ck',checkbox:true}
- ]],
- columns:[[
- {field:'carNo',title:'所属车辆',width:'7%'},
- {field:'cylinderNo',title:'气瓶使用编号',width:'7%'},
- {field:'productNo',title:'生产厂家',width:'7%'},
- {field:'cylinderNo',title:'气瓶出厂编号',width:'7%'},
- {field:'cylinderTypeName',title:'气瓶类型',width:'7%'},
- {field:'productDate',title:'生产年月',width:'7%',formatter:function(value,row,index){
- var unixTimestamp = new Date(value);
- return unixTimestamp.toLocaleString();
- }},
- {field:'productType',title:'型号',width:'7%'},
- {field:'cylinderState',title:'使用状态',width:'7%',formatter: function(value, row, index){
- if (value == "0") {
- return '<font style="color:green;font-weight: bold;">'+"在用"+'</font>';
- }
- else if(value == "1") {
- return '<font style="color:red;font-weight: bold;">'+"报废"+'</font>';
- }else if(value == "2") {
- return '<font style="color:red;font-weight: bold;">'+"超期未检"+'</font>';
- }else if(value == "3") {
- return '<font style="color:red;font-weight: bold;">'+"周转"+'</font>';
- }}},
- {field:'nextCheckDate',title:'下次检验日期',width:'7%',formatter:function(value,row,index){
- var unixTimestamp = new Date(value);
- return unixTimestamp.toLocaleString();
- }},
- {field:'checkDate',title:'最后检验日期',width:'7%',formatter:function(value,row,index){
- var unixTimestamp = new Date(value);
- return unixTimestamp.toLocaleString();
- }},
- {field:'startUseDate',title:'开始投用日期',width:'7%',formatter:function(value,row,index){
- var unixTimestamp = new Date(value);
- return unixTimestamp.toLocaleString();
- }},
- {field:'installDate',title:'安装日期',width:'7%',formatter:function(value,row,index){
- var unixTimestamp = new Date(value);
- return unixTimestamp.toLocaleString();
- }},
- {field:'yearLimit',title:'使用年限',width:'7%'},
- {field:'timesAvailable',title:'可充装次数',width:'7%'},
- {field:'fillTimes',title:'已充装次数',width:'7%'},
- {field:'checkStation',title:'检验单位',width:'7%'},
- {field:'checkState',title:'检验状态',width:'7%',formatter: function(value, row, index){
- if (value == "0") {
- return '<font style="color:green;font-weight: bold;">'+"合格"+'</font>';
- }
- else if(value == "1") {
- return '<font style="color:red;font-weight: bold;">'+"不合格"+'</font>';
- }}},
- {field:'installStation',title:'安装单位',width:'7%'},
- {field:'installLicence',title:'安装许可',width:'7%'},
- {field:'monitorStation',title:'安装监检单位',width:'7%'},
- {field:'weight',title:'重量',width:'7%'},
- {field:'vol',title:'容积',width:'7%'},
- {field:'thickness',title:'壁厚',width:'7%'},
- {field:'press',title:'压力',width:'7%'},
- {field:'material',title:'材质',width:'7%'},
- {field:'installLoc',title:'安装位置',width:'7%'}
-
-
- ]]
- });
- }
- function fLoadData(page,rows){
- document.getElementById("pageNumber").innerText = i;
- document.getElementById("from").innerText = (page-1)*rows;
- document.getElementById("to").innerText = page*rows;
- $.messager.progress({
- title: '请等待',
- msg: '正在加载数据...',
- text: '查询中.......'
- });
- $.ajax({
- type:"POST",
- contentType: "application/x-www-form-urlencoded; charset=UTF-8",
- url:"ajax/cylinderDataQuery?page="+page+"&psize="+rows,
- success:function (data){
- $.messager.progress('close');
- var vData = $.parseJSON(data);
- sum = vData.total;
- totalpage = Math.ceil(sum/rows);
- document.getElementById("total").innerText = sum;
- document.getElementById("totalpage").innerText = totalpage;
- $('#tt').datagrid('loadData', vData); //将数据绑定到datagrid
- $('#pp').pagination({
- total:sum,
- pageList: [2,10,50,100],
- beforePageText: '第',//页数文本框前显示的汉字
- afterPageText: '页 共 {pages} 页',
- displayMsg: '当前显示 {from} - {to} 条记录 共 {total} 条记录',
- onSelectPage:function(pageNumber, pageSize){
- fLoadData();
- }
-
-
- });
- }
- });
-
-
- }
-
-
-
- function paginationpre(){
- pageSize = $('#pageSize').val();
- if(i<=1){
- return false;
- }else{
- i--;
- fLoadData(i,pageSize);
- }
- }
- function paginationnext(){
- //先跟总页数相比,看看有没得下一页
- pageSize = $('#pageSize').val();
- if(i<totalpage){
- i++;
- fLoadData(i,pageSize);
- }else{
- return false;
- }
- }
- function changeSize(){
- var changeSize = $('#pageSize').val();
- pageSize = $('#pageSize').val();
- fLoadData(i,changeSize);
- }
-
-
-
- function selectCountry(){
- var id=document.getElementById("city").value;
- var select = document.getElementById("country");
- for(var i=select.options.length-1;i>=0;i--) {
- select.options.remove(i);
- }
- $.ajax({
- type:"POST",
- contentType: "application/x-www-form-urlencoded; charset=UTF-8",
- url:"ajax/hiddenCity?cityId="+id,
- success:function (data){
- var obj=eval("(" + data + ")");
- $.each(obj.rows, function(i,item){
- select.options.add(new Option(item.name, item.id));
- });
-
-
- }
- });
- }
-
- function selectCountry1(){
- selectCountry();
- fLoadData(1,10);
- }
-
- function selectpage(){
- var selectpage = $('#selectpage').val();
- if(selectpage>=1&&selectpage<=totalpage){
- i = selectpage;
- $("#selectpage").val("");
- pageSize = $('#pageSize').val();
- fLoadData(i,pageSize);
- }else{
- $("#selectpage").val("");
- return false;
- }
- }
- </script>
-
- </head>
-
- <body>
- <!-- 查询结果:数据表格 -->
- <table id="tt" cellspacing="0" cellpadding="0" >
- </table>
- <div id="" style="background:#efefef;width:100%; border:1px solid #ccc;position: absolute;bottom: 0px;float: left;">
- <!--<input type="text" id="pageNumber">-->
- <div style="float: left;text-align: left;padding-left: 20px;">
- <span class="hzbspan">第</span><span id="pageNumber" class="hzbspan"></span><span class="hzbspan">页 共</span><span class="hzbspan" id="totalpage"></span><span class="hzbspan">页 </span>
- <select onchange="changeSize();" id="pageSize">
- <option value="5">5</option>
- <option value="10" selected="selected">10</option>
- <option value="20">20</option>
- <option value="30">30</option>
- </select>
- <a id="prepage" onclick="paginationpre()" class="easyui-linkbutton easyui-tooltip" title="上一页" data-options="iconCls:'icon-undo',plain:true" ></a>
- <input type="text" id="selectpage" style="width: 30px;" onchange="selectpage();"/>
- <a id="nextpage" onclick="paginationnext()" class="easyui-linkbutton easyui-tooltip" title="下一页" data-options="iconCls:'icon-redo',plain:true" ></a>
- </div>
- <div style="float: left;text-align: right;position: absolute;right: 20px;padding-top: 2px" ><span class="hzbspan">当前显示</span><span class="hzbspan" id="from"></span>-<span class="hzbspan" id="to"></span><span class="hzbspan"> 记录 共</span><span class="hzbspan" id ="total"></span><span class="hzbspan">条记录</span></div>
- </div>
- <div id="toolbar" style="padding-top: 10px;height: auto;"><!--
-
- <form name="form1" method="post" runat="server">
- <span class="easyui-linkbutton" style="cursor: default;margin-bottom: 5px;"><span class="hzbspan" style="color: #f08300;font-size: 16px;" >查询条件:</span></span>
- <span class="hzbspan">气瓶所属城市:</span>
- <select name="s1" onChange="changeselect1(this.value)" style="width: 100px;height: 24px;" class="hzbspan">
- <option>==请选择==</option>
- <option value="中文">中文</option>
- <option value="英语">英语</option>
- <option value="英语">法语</option>
- </select>
- <span class="hzbspan">气瓶所属县: </span>
- <select name="s2" style="width: 100px;height: 24px;" class="hzbspan">
- <option>==请选择==</option>
- </select>
- -->
-
-
- <form id="Supervisormanagementform" action="ajax/Supervisormanagement" method="post">
- <span class="easyui-linkbutton" style="cursor: default;margin-bottom: 5px;"><span class="hzbspan" style="color: #f08300;font-size: 16px;" >查询条件:</span></span>
-
- <span class="easyui-linkbutton" style="cursor: default;margin-bottom: 5px;"><span class="hzbspan" style="color: #f08300;font-size: 16px;" >省:</span></span>
- <select name="province" style="width: auto;height: 24px;min-width: 100px;" class="hzbspan">
- <%for(AuthorityRegionPlace arp:arplist){
- cplist = arp.getCityPlace();
- %>
- <option value="<%=arp.getId() %>">
- <%=arp.getName() %>
- </option>
- <%} %>
- </select>
-
- <span class="easyui-linkbutton" style="cursor: default;margin-bottom: 5px;"><span class="hzbspan" style="color: #f08300;font-size: 16px;" >市:</span></span>
- <select name="city" id="city" style="width: auto;height: 24px;min-width: 100px;" class="hzbspan" onchange="selectCountry1()">
-
- <%
-
- for(CityPlace cp:cplist){
- cyplist = cp.getSubPlaceList();
- %>
-
- <option value="<%=cp.getId() %>">
- <%=cp.getName() %>
- </option>
-
-
- <%} %>
- </select>
- <span class="easyui-linkbutton" style="cursor: default;margin-bottom: 5px;"><span class="hzbspan" style="color: #f08300;font-size: 16px;" >县:</span></span>
- <select name="country" id = "country" style="width: auto;height: 24px;min-width: 100px;" class="hzbspan" onchange="fLoadData(1,10)" >
- </select>
-
-
-
-
-
- <span style="cursor: default"><span class="hzbspan">生产厂家简称:</span></span> <input type="text" style="width: 100px;height: 24px;" class="hzbspan">
- <br/>
-
-
-
- <span style="cursor: default"><span class="hzbspan">车牌号: </span></span> <input type="text" style="width: 100px;height: 24px;" class="hzbspan">
- <span style="cursor: default"><span class="hzbspan">下次检验开始时间:</span></span> <input type="text" id="searchst" class="easyui-datebox" style="width: 100px;height: 24px;" class="hzbspan">
-
-
- <span style="cursor: default"><span class="hzbspan">气瓶出厂编号:</span></span> <input type="text" style="width: 100px;height: 24px;" class="hzbspan">
-
- <br/>
-
-
-
-
- <span style="cursor: default"><span class="hzbspan">气瓶类型: </span></span> <select name="address" style="width: 100px;height: 24px;" class="hzbspan">
- <option>全部</option>
- <option>成都市</option>
- <option>全部</option>
- <option>全部</option>
- <option>全部</option>
- </select>
- <span style="cursor: default"><span class="hzbspan">下次检验结束时间:</span></span> <input type="text" id="searchet" class="easyui-datebox" style="width: 100px;height: 24px;" class="hzbspan">
-
- <span style="cursor: default"><span class="hzbspan">改装单位: </span></span> <input type="text" style="width: 100px;height: 24px;" class="hzbspan">
- <br/>
-
-
-
- <span style="cursor: default"><span class="hzbspan">改装开始时间:</span></span> <input type="text" class="easyui-datebox" style="width: 100px;height: 24px;" class="hzbspan">
- <span style="cursor: default"><span class="hzbspan">改装结束时间: </span></span> <input type="text" class="easyui-datebox" style="width: 100px;height: 24px;" class="hzbspan">
- <span style="cursor: default"><span class="hzbspan">气瓶状态: </span></span> <select name="address" style="width: 100px;height: 24px;" class="hzbspan">
- <option>全部</option>
- <option>成都市</option>
- <option>全部</option>
- <option>全部</option>
- <option>全部</option>
- </select>
-
-
- <a id="btninfosearch" class="easyui-linkbutton" icon="icon-search" href="javascript:void(0)" style="margin-bottom: 5px;" ><span class="hzbspan" style="color: #f08300;font-size: 16px;">查 询 </span></a>
- </form>
- </div>
-
- <input id = "st" type="hidden" value="<%=session.getAttribute("st") %>"/>
- <input id = "et" type="hidden" value="<%=session.getAttribute("et") %>"/>
- </body>
- </html>
|