页面需要:
<!DOCTYPE html>
<html lang="zh" xmlns:th="http://www.thymeleaf.org" xmlns:shiro="http://www.pollix.at/thymeleaf/shiro">
<head>
<title>企业概况列表</title>
<th:block th:include="include :: header('企业概况列表')" />
<meta charset="utf-8" name="viewport" content="initial-scale=1,maximum-scale=1, minimum-scale=1">
<script type="text/javascript">
document.documentElement.style.fontSize = document.documentElement.clientWidth / 1280*100 + 'px';
</script>
</head>
<!--bein-->
<style type="text/css">
body{background:url(/img/bg2.jpg) no-repeat;background-size: 100% 100%;margin-top:1%;}
/* 头部图片样式*/
.top-banner img{width:50%;height:auto; }
.top-banner{text-align:center }
.fixed-table-toolbar .bs-bars,.fixed-table-toolbar .columns,.fixed-table-toolbar .search{
position:relative;
margin-top:0.10rem;
margin-bottom:0.10rem;
line-height:0.34rem;
width: 108%;
}
#formId{
float: right;
margin-right: 5%;
}
#toolbar{
background-color: rgba(0,0,0,0);
}
/*表头*/
.table-striped table thead {
background-color: rgba(17,97,192,.8);
}
/*第偶数行*/
#bootstrap-table tr:nth-child(even){
background: rgba(50,0,0,.0);
}
/*第奇数行*/
#bootstrap-table tr:nth-child(odd) {
background: rgba(0,50,0,.20);;
}
/*去除表格边框线*/
.table>tbody>tr>td{
height: 0.40rem;
border: 0.01rem solid transparent !important;
}
/*去除表头的分隔线*/
.table-striped .table>thead>tr>th, .table-striped .table>tbody>tr>th {
border-bottom: 0px!important;
border-top: 0px!important;
}
/*关闭横向滚动条*/
.fixed-table-body {
overflow-x: hidden;
overflow-y: auto;
height: 100%;
}
/*分页部分*/
.btn-default{
color: #ffffff;
background-color:rgba(0,0,0,0);
border-color:#ccc
}
/*右侧分页栏*/
.pagination>li>a,.pagination>li>span{
position:relative;
float:left;padding:0.06rem 0.12rem;
margin-left:-0.01rem;
line-height:1.42857143;
color:#337ab7;
text-decoration:none;
background-color:rgba(0,0,0,0);
border:0rem solid #ddd;
}
.pagination>.disabled>a,
.pagination>.disabled>a:focus,
.pagination>.disabled>a:hover,
.pagination>.disabled>span,
.pagination>.disabled>span:focus,
.pagination>.disabled>span:hover{
color:#777;
cursor:not-allowed;
background-color:rgba(0,0,0,0);
border-color:#ddd
}
/*.select-table .table td {
text-overflow:ellipsis;
!*规定段落中的文本不进行换行 *!
white-space:nowrap;
!* 配合宽度来使用 *!
height:40rem;
}*/
/*select-table1 {
width: 80%;
background: rgba(0,0,0,0);
border-radius: 6rem;
margin-top: 10rem;
padding-top: 5rem;
padding-bottom: 13rem;
box-shadow: 1rem 1rem 3rem rgba(0,0,0,.2);
}
*/
/*整体页面字体背景颜色*/
body{
font-family:"Helvetica Neue",Helvetica,Arial,sans-serif;
font-size:0.14rem;
line-height:1.42857143;
color:#fff;
background-color:#fff;
border-color:rgba(0,0,0,0);
height:8.84rem;
}
/*字体颜色*/
.table-striped .table>thead:first-child>tr:first-child>th {
font-effect:SourceHanSansSC-Light ;
font-size: 0.15rem;
color: white;
}
/*左上角总额样式*/
/*左上角总额样式*/
input::-webkit-input-placeholder{
color: white;
}
/*搜索input框背景*/
searchInputStyle{
background: #fff url(../img/user.png) no-repeat 95% center;
background-image: url(../img/user.png);
background-size: initial;
color: #FFFFFF;
}
/*鼠标悬浮*/
/*.table-hover > tbody > tr:hover > td {
background-color: grey;
}
*/
/*当鼠标悬浮table行时,改变样式*/
.table-hover > tbody > tr:hover > td,
.table-hover > tbody > tr:hover > tr {
color: #faf32a;
cursor: pointer;
}
/*企业名过长省略号*/
.divstyle{
width: 1.00rem;
overflow: hidden;
text-overflow: ellipsis;
white-space: nowrap;
}
/*设置搜索区域样式*/
#leibie label{
background-color: rgba(40,104,181,0.25);
color: #FFFFFF;
border:solid rgba(59,147,255,0.25) 0.01rem;
border-radius: 0.04rem;
font-size: 0.16rem;
}
#leibie input{
background-color: rgba(0,0,0,0);
color: #FFFFFF;
border: 0rem;
font-size: 0.15rem;
text-align: center;
}
#leibie input:hover{
color:yellow;
cursor:pointer;
border: 0rem rgba(0,0,0,0);
}
inputColor{
color:yellow;
}
/*分类查询的第一个input框左对齐,其余居中*/
#lb1{
text-align: left!important;
}
#hx1{
text-align: left!important;
}
#hx7{
text-align: left!important;
}
#qy1{
text-align: left!important;
}
#qy12{
text-align: left!important;
}
/*#leibie td{
border:solid red 2rem;
}*/
/*form{
float: right;
text-align: right;
}
.select-list{
float: right!important;
padding-right: 0rem!important;
}*/
a:hover { cursor:pointer;}
#backHome{
background:url(/img/回到首页_03.png);
background-size:100% 100%;
display: inline;
float: right;
color:#f9de49;
font-size: 0.16rem;
padding: 0.16rem;
padding-top:0.04rem;
margin-top:1%;
text-decoration :none;
}
/*q去除多条件查询时的聚焦facus边框*/
/*:focus {
outline: -webkit-focus-ring-color auto 0rem;
}
*/
</style>
<body class="gray-bg">
<div class="container-div">
<div class="row">
<div id="util">
<div class="col-xs-12">
<!--页面上方显示的字“....咨询平台”-->
<div class="top-banner">
<img src="/img/item_fire.png">
</div>
</div>
<div class="col-sm-12 search-collapse" style="text-align: center;background-color: rgba(0,0,0,0);width: 80%;margin: 0 10%;margin-top: 2%" >
<span style="margin-left:20%;color: #7cdafd;font-size: 0.40rem;letter-spacing:0.40rem;">产业概况</span>
<a id="backHome" onclick="toMap()">回到首页</a>
</div>
<form id="formId" style="display: inline;float: right" autocomplete="off">
<div class="select-list">
<ul>
<li>
<div>
<!--年份条件-->
<input id="year" name="year" type="hidden" />
<!--企业类别条件-->
<!--国有、外资、港澳台-->
<input id="qb18" name="qb18" type="hidden" />
<!--高新企业-->
<input id="qb11" name="qb11" type="hidden" />
<!--未上市企业-->
<input id="qb15_1" name="qb15_1" type="hidden" />
<!--产业画像条件-->
<input id="qb16A" name="qb16A" type="hidden" />
<input id="qb16B" name="qb16B" type="hidden" />
<!--企业区域条件-->
<input id="saddress" name="saddress" type="hidden" />
<input id="saddressA" name="saddressA" type="hidden" />
<input id="saddressB" name="saddressB" type="hidden" />
</div>
</li>
<li>
<div >
<input id="sname" style="color: #FFFFFF;" type="text" name="sname" placeholder="请输入企业名称"/>
<div class="btn btn-rounded btn-sm btn-info" onclick="$.table.search()"><em class="fa fa-search"></em></div>
</div>
</li>
</ul>
</div>
</form>
<div style="display: inline;background-color: rgba(0,0,0,0)" class="btn-group-sm" id="toolbar" role="group">
<div id ="leibie" style="display: inline;float: left">
<tr style="float: left" cellpadding="5">
<label>企业类别</label>
<td><input id="lbAll" type="text" style="width: 1.00rem;" value="全部" onclick="setQb18Value('','lbAll')" readonly></td>
<td><input id="lb1" type="text" style="width: 1.20rem;" value="高新技术企业" onclick="setQb18Value(1,'lb1')" readonly></td>
<td><input id="lb2" type="text" style="width: 0.80rem" value="国有企业" onclick="setQb18Value(1,'lb2')" readonly></td>
<td><input id="lb3" type="text" style="width: 0.80rem" value="上市企业" onclick="setQb18Value('00.无','lb3')" readonly></td>
<td><input id="lb4" type="text" style="width: 0.80rem" value="港澳台企业" onclick="setQb18Value(4,'lb4')" readonly></td>
<td><input id="lb5" type="text" style="width: 0.80rem" value="外资企业" onclick="setQb18Value(5,'lb5')" readonly></td>
</tr>
<br>
<tr style="float: left" cellspacing="5">
<label>产业画像</label>
<!--现在换上11类-->
<td><input id="hxAll" type="text" style="width:1.00rem" value="全部" onclick="setQb16Value('','','hxAll')" readonly></td>
<td><input id="hx1" type="text" style="width: 1.00rem" value="电子与信息" onclick="setQb16Value(101,110,'hx1')" readonly></td>
<td><input id="hx2" type="text" style="width: 1.40rem" value="生物、医药技术" onclick="setQb16Value(201,204,'hx2')" readonly></td>
<td><input id="hx3" type="text" style="width: 0.60rem" value="新材料" onclick="setQb16Value(301,305,'hx3')" readonly></td>
<td><input id="hx4" type="text" style="width: 1.20rem" value="光机电一体化" onclick="setQb16Value(401,407,'hx4')" readonly></td>
<td><input id="hx5" type="text" style="width: 1.60rem" value="新能源、高效节能" onclick="setQb16Value(501,502,'hx5')" readonly></td>
<td><input id="hx6" type="text" style="width: 0.80rem" value="环境保护" onclick="setQb16Value(601,606,'hx6')" readonly></td>
<br>
<td><input type="text" style="width: 1.70rem" disabled></td>
<td><input id="hx7" type="text" style="width: 0.80rem" value="航空航天" onclick="setQb16Value(701,706,'hx7')" readonly></td>
<td><input id="hx8" type="text" style="width: 1.00rem" value="核应用技术" onclick="setQb16Value(901,908,'hx8')" readonly></td>
<td><input id="hx9" type="text" style="width: 1.00rem" value="其他高技术" onclick="setQb16Value(999,999,'hx9')" readonly></td>
<td><input id="hx10" type="text" style="width: 0.80rem" value="非高技术" onclick="setQb16Value(900,900,'hx10')" readonly></td>
<td><input id="hx11" type="text" style="width: 2.00rem" value="地球、空间、海洋工程" onclick="setQb16Value(801,806,'hx11')" readonly></td>
</tr>
<br>
<tr style="float: left">
<label>企业区域</label>
<td><input id="qyAll" type="text" style="width: 1.00rem" value="全部" onclick="setSaddressValue('','qyAll')" readonly></td>
<td><input id="qy1" type="text" style="width: 1.00rem" value="昆山开发区" onclick="setSaddressValue('昆山开发区','qy1')" readonly></td>
<td><input id="qy2" type="text" style="width: 1.00rem" value="昆山高新区" onclick="setSaddressValue1('昆山高新区','高新区','玉山镇','qy2')" readonly></td>
<td><input id="qy3" type="text" style="width: 0.80rem" value="花桥开发区" onclick="setSaddressValue('花桥开发区','qy3')" readonly></td>
<td><input id="qy4" type="text" style="width: 0.60rem" value="张浦镇" onclick="setSaddressValue('张浦镇','qy4')" readonly></td>
<td><input id="qy5" type="text" style="width: 0.60rem" value="周市镇" onclick="setSaddressValue('周市镇','qy5')" readonly></td>
<td><input id="qy6" type="text" style="width: 0.60rem" value="巴城镇" onclick="setSaddressValue2('巴城镇','正仪镇','qy6')" readonly></td>
<td><input id="qy7" type="text" style="width: 0.60rem" value="陆家镇" onclick="setSaddressValue('陆家镇','qy7')" readonly></td>
<td><input id="qy8" type="text" style="width: 0.60rem" value="千灯镇" onclick="setSaddressValue('千灯镇','qy8')" readonly></td>
<td><input id="qy9" type="text" style="width: 0.80rem" value="淀山湖镇" onclick="setSaddressValue('淀山湖镇','qy9')" readonly></td>
<td><input id="qy10" type="text" style="width: 0.60rem" value="周庄镇" onclick="setSaddressValue('周庄镇','qy10')" readonly></td>
<td><input id="qy11" type="text" style="width: 0.60rem" value="锦溪镇" onclick="setSaddressValue('锦溪镇','qy11')" readonly></td>
<br>
<td><input type="text" style="width: 1.70rem" disabled></td>
<td><input id="qy12" type="text" style="width: 0.60rem" value="其他" onclick="setSaddressValue('其他','qy12')" readonly></td>
</tr>
</div>
</div>
</div>
<div class="col-sm-12 select-table1 table-striped " style="width: 80%;margin: 0 10%">
<table id="bootstrap-table" data-mobile-responsive="true" ></table>
</div>
</div>
</div>
<div th:include="include :: footer"></div>
<script th:inline="javascript">
var year = [[${year}]]
var prefix = ctx + "system/industryMapSecondLevel";
window.onload=function setValue() {
document.getElementById("year").value=year;
$("div").remove(".gohome");
}
$(function() {
var options = {
url: prefix + "/toQygkList",
modalName: "企业概况",
showExport: false,
showSearch: false,
showRefresh: false,
showColumns: false,
showToggle: false,
// height: $(window).height()-$("#util").height()-220,
/*height:900-$("#util").height()-220,*/
// 查询条件
queryParams:function(params) {
return {
// 传递参数查询参数
pageSize: params.limit,
pageNum: params.offset / params.limit + 1,
searchValue: params.search,
orderByColumn: params.sort,
isAsc: params.order,
year: year,
};
},
columns: [
/*{
field : 'number',
title : '序号',
},*/
{
title : '序号',
align: 'center',
formatter: function (value, row, index) {
return index + 1;
}
},
{
field : 'sname',
title : '企业名称',
sortable: true,
formatter: function(value, row, index) {
return "<div class=\"divstyle\" title='"+value+"' style='width:2.00rem;'>"+row.sname+"</div>";
},
},
{
field : 'qb18',
title : '企业类别',
formatter: function(value, row, index) {
/*国有企业、港澳台企业、外资企业*/
if($("#qb18").val()!=''){
if(row.qb18 == 1) {
return '<div class="divstyle" style="width:1.00rem;">' + "国有企业" + '</div>';
}else if(row.qb18 == 4){
return '<div class="divstyle" style="width:1.00rem;">' + "港澳台企业" + '</div>';
}else if(row.qb18 == 5){
return '<div class="divstyle" style="width:1.00rem;">' + "外资企业" + '</div>';
}
}/*上市企业*/
else if($("#qb15_1").val()!=''){
if(row.qb15_1 !='00.无'){
return '<div class="divstyle" style="width:1.00rem;">' + "上市企业"+ '</div>';
}
}
/*高新技术企业*/
else if ($("#qb11").val()!=''){
if(row.qb11 == 1){
return '<div class="divstyle" style="width:1.00rem;">' + "高新技术企业" + '</div>';
}
}
/*当点击全部时*/
else if ($("#qb18").val()==''&&$("#qb11").val()==''&&$("#qb15_1").val()==''){
/*国有企业*/
if(row.qb18 == 1) {
return '<div class="divstyle" style="width:1.00rem;">' + "国有企业" + '</div>';
}else if(row.qb18 == 4){
return '<div class="divstyle" style="width:1.00rem;">' + "港澳台企业" + '</div>';
}else if(row.qb18 == 5){
return '<div class="divstyle" style="width:1.00rem;">' + "外资企业" + '</div>';
}
/*上市企业*/
else if(row.qb15_1 !='00.无'){
/*待定*/
return '<div class="divstyle" style="width:1.00rem;">' + "上市企业"+ '</div>';
}else if(row.qb11 == 1){
/*待定*/
return '<div class="divstyle" style="width:1.00rem;">' + "高新技术企业" + '</div>';
}else{
return '<div class="divstyle" style="width:1.00rem;">' + "其他" + '</div>';
}
}
},
},
{
field : 'qb16',
title : '所属产业',
formatter: function(value, row, index) {
if(row.qb16>=101 && row.qb16<=110) {
return '<div class="divstyle" style="width:1.00rem;">' + "电子与信息" + '</div>';
}else if(row.qb16>=201 && row.qb16<=204){
/*待定*/
return '<div class="divstyle" style="width:1.00rem;">' + "生物、医药技术"+ '</div>';
}else if(row.qb16>=301 && row.qb16<=305){
/*待定*/
return '<div class="divstyle" style="width:1.00rem;">' + "新材料"+ '</div>';
}else if(row.qb16>=401 && row.qb16<=407){
/*待定*/
return '<div class="divstyle" style="width:1.00rem;">' + "光机电一体化"+ '</div>';
}else if(row.qb16>=501 && row.qb16<=502){
/*待定*/
return '<div class="divstyle" style="width:1.00rem;">' + "新能源高效节能"+ '</div>';
}else if(row.qb16>=601 && row.qb16<=606){
/*待定*/
return '<div class="divstyle" style="width:1.00rem;">' + "环境保护"+ '</div>';
}else if(row.qb16>=701 && row.qb16<=706){
/*待定*/
return '<div class="divstyle" style="width:1.00rem;">' + "航空航天"+ '</div>';
}else if(row.qb16>=801 && row.qb16<=806){
/*待定*/
return '<div class="divstyle" style="width:1.00rem;">' + "地球、空间、海洋工程"+ '</div>';
}else if(row.qb16>=901 && row.qb16<=908){
/*待定*/
return '<div class="divstyle" style="width:1.00rem;">' + "核应用技术"+ '</div>';
}else if(row.qb16==999){
/*待定*/
return '<div class="divstyle" style="width:1.00rem;">' + "其它高技术"+ '</div>';
}else if(row.qb16==900){
/*待定*/
return '<div class="divstyle" title="" style="width:1.00rem;">' + "非高技术"+ '</div>';
}
},
},
{
field : 'saddress',
title : '所在区域',
formatter: function(value, row, index) {
if(value!=null&&value!=""){
if(row.saddress.indexOf("昆山开发区")!=-1) {
return '<div class="divstyle" style="width:1.50rem;">' + "昆山开发区" + '</div>';
}else if(row.saddress.indexOf("昆山高新区")!=-1||row.saddress.indexOf("高新区")!=-1||row.saddress.indexOf("玉山镇")!=-1){
return '<div class="divstyle" style="width:1.50rem;">' + "昆山高新区"+ '</div>';
}else if(row.saddress.indexOf("花桥镇")!=-1){
return '<div class="divstyle" style="width:1.50rem;">' + "花桥开发区"+ '</div>';
}else if(row.saddress.indexOf("张浦镇")!=-1){
return '<div class="divstyle" style="width:1.50rem;">' + "张浦镇"+ '</div>';
}else if(row.saddress.indexOf("周市镇")!=-1){
return '<div class="divstyle" style="width:1.50rem;">' + "周市镇"+ '</div>';
} else if(row.saddress.indexOf("巴城镇")!=-1||row.saddress.indexOf("正仪镇")!=-1){
return '<div class="divstyle" style="width:1.50rem;">' + "巴城镇"+ '</div>';
} else if(row.saddress.indexOf("陆家镇")!=-1){
return '<div class="divstyle" style="width:1.50rem;">' + "陆家镇"+ '</div>';
} else if(row.saddress.indexOf("千灯镇")!=-1){
return '<div class="divstyle" style="width:1.50rem;">' + "千灯镇"+ '</div>';
} else if(row.saddress.indexOf("淀山湖镇")!=-1){
return '<div class="divstyle" style="width:1.50rem;">' + "淀山湖镇"+ '</div>';
} else if(row.saddress.indexOf("周庄镇")!=-1){
return '<div class="divstyle" style="width:1.50rem;">' + "周庄镇"+ '</div>';
}else if(row.saddress.indexOf("锦溪镇")!=-1){
return '<div class="divstyle" style="width:1.50rem;">' + "锦溪镇"+ '</div>';
} else{
return '<div class="divstyle" title="'+value+'" style="width:1.50rem;">' + row.saddress+ '</div>';
}
}else{
return '<div class="divstyle" title="'+value+'" style="width:1.50rem;">' +" "+ '</div>';
}
},
},
{
title : '操作',
formatter: function(value, row, index) {
var actions = [];
actions.push('<a style="color: #FFFFFF" href="/system/gxqEvaluationGjcompany/exportData?year">详情</a> ');
return actions.join('');
}
},
]
};
$.table.init(options);
});
//当点击enter键时,进行搜索
/*$("#sname").onkeydown = function(e){
var e = event || window.event || arguments.callee.caller.arguments[0];
if (e && e.keyCode==13) {
$.table.search();//查询方法
} val
}*/
//多条件分类查询
function setQb18Value(val,th) {
/*点击高新技术*/
if(th=="lb1"){
document.getElementById("qb11").value = val;
document.getElementById("qb15_1").value = "";
document.getElementById("qb18").value = "";
}else if(th=="lb3"){
/*点击上市企业*/
document.getElementById("qb15_1").value = val;
document.getElementById("qb11").value = "";
document.getElementById("qb18").value = "";
} else if(th=="lbAll"){
/*点击全部*/
document.getElementById("qb15_1").value = "";
document.getElementById("qb11").value = "";
document.getElementById("qb15_1").value = "";
} else {
/*点击其他类型*/
document.getElementById("qb18").value = val;
document.getElementById("qb15_1").value = "";
document.getElementById("qb11").value = "";
}
var div1=document.getElementById(th);
var divAll=document.getElementById("lbAll");
var divA=document.getElementById("lb1");
var divB=document.getElementById("lb2");
var divC=document.getElementById("lb3");
var divD=document.getElementById("lb4");
var divF=document.getElementById("lb5");
divAll.style.color="white";
divA.style.color="white";
divB.style.color="white";
divC.style.color="white";
divD.style.color="white";
divF.style.color="white";
//当进行点击事件时,去除其他样式,为此附上样式
// debuggers
// $("leibie").children("tr").children("input").html("5");
div1.style.color="yellow";
$.table.search();
}
function setQb16Value(valA,valB,th) {
document.getElementById("qb16A").value=valA;
document.getElementById("qb16B").value=valB;
var hxTh=document.getElementById(th);
var hxAll=document.getElementById("hxAll");
var hxA=document.getElementById("hx1");
var hxB=document.getElementById("hx2");
var hxC=document.getElementById("hx3");
var hxD=document.getElementById("hx4");
var hxE=document.getElementById("hx5");
var hxF=document.getElementById("hx6");
var hxG=document.getElementById("hx7");
var hxH=document.getElementById("hx8");
var hxI=document.getElementById("hx9");
var hxJ=document.getElementById("hx10");
var hxK=document.getElementById("hx11");
hxAll.style.color="white";
hxA.style.color="white";
hxB.style.color="white";
hxC.style.color="white";
hxD.style.color="white";
hxE.style.color="white";
hxF.style.color="white";
hxG.style.color="white";
hxH.style.color="white";
hxI.style.color="white";
hxJ.style.color="white";
hxK.style.color="white";
hxTh.style.color="yellow";
$.table.search();
}
function setSaddressValue1(val,valA,valB,th) {
document.getElementById("saddress").value=val;
document.getElementById("saddressA").value=valA;
document.getElementById("saddressB").value=valB;
var qyTh=document.getElementById(th);
var qyAll=document.getElementById("qyAll");
var qyA=document.getElementById("qy1");
var qyB=document.getElementById("qy2");
var qyC=document.getElementById("qy3");
var qyD=document.getElementById("qy4");
var qyE=document.getElementById("qy5");
var qyF=document.getElementById("qy6");
var qyG=document.getElementById("qy7");
var qyH=document.getElementById("qy8");
var qyI=document.getElementById("qy9");
var qyJ=document.getElementById("qy10");
var qyK=document.getElementById("qy11");
var qyM=document.getElementById("qy12");
qyAll.style.color="white";
qyA.style.color="white";
qyB.style.color="white";
qyC.style.color="white";
qyD.style.color="white";
qyE.style.color="white";
qyF.style.color="white";
qyG.style.color="white";
qyH.style.color="white";
qyI.style.color="white";
qyJ.style.color="white";
qyK.style.color="white";
qyM.style.color="white";
qyTh.style.color="yellow";
$.table.search();
}
function setSaddressValue2(val,valA,th) {
document.getElementById("saddress").value=val;
document.getElementById("saddressA").value=valA;
document.getElementById("saddressB").value="Null";
var qyTh=document.getElementById(th);
var qyAll=document.getElementById("qyAll");
var qyA=document.getElementById("qy1");
var qyB=document.getElementById("qy2");
var qyC=document.getElementById("qy3");
var qyD=document.getElementById("qy4");
var qyE=document.getElementById("qy5");
var qyF=document.getElementById("qy6");
var qyG=document.getElementById("qy7");
var qyH=document.getElementById("qy8");
var qyI=document.getElementById("qy9");
var qyJ=document.getElementById("qy10");
var qyK=document.getElementById("qy11");
var qyM=document.getElementById("qy12");
qyAll.style.color="white";
qyA.style.color="white";
qyB.style.color="white";
qyC.style.color="white";
qyD.style.color="white";
qyE.style.color="white";
qyF.style.color="white";
qyG.style.color="white";
qyH.style.color="white";
qyI.style.color="white";
qyJ.style.color="white";
qyK.style.color="white";
qyM.style.color="white";
qyTh.style.color="yellow";
$.table.search();
}
function setSaddressValue(val,th) {
document.getElementById("saddress").value=val;
document.getElementById("saddressA").value="Null";
document.getElementById("saddressB").value="Null";
var qyTh=document.getElementById(th);
var qyAll=document.getElementById("qyAll");
var qyA=document.getElementById("qy1");
var qyB=document.getElementById("qy2");
var qyC=document.getElementById("qy3");
var qyD=document.getElementById("qy4");
var qyE=document.getElementById("qy5");
var qyF=document.getElementById("qy6");
var qyG=document.getElementById("qy7");
var qyH=document.getElementById("qy8");
var qyI=document.getElementById("qy9");
var qyJ=document.getElementById("qy10");
var qyK=document.getElementById("qy11");
var qyM=document.getElementById("qy12");
qyAll.style.color="white";
qyA.style.color="white";
qyB.style.color="white";
qyC.style.color="white";
qyD.style.color="white";
qyE.style.color="white";
qyF.style.color="white";
qyG.style.color="white";
qyH.style.color="white";
qyI.style.color="white";
qyJ.style.color="white";
qyK.style.color="white";
qyM.style.color="white";
qyTh.style.color="yellow";
$.table.search();
}
function toMap() {
var screemWidth=$(window).width();
var screemHeight=$(window).height();
location.href="/system/industryMap/toIndustryMap?screemWidth="+screemWidth+"&screemHeight="+screemHeight;
}
/*s双击清空条件*/
$("#sname").dblclick(function() {
$("#sname").val("");
})
</script>
</body>
</html>
后台:
/*
* 4查询企业概况企业信息
*/
@PostMapping("/toQygkList")
@ResponseBody
public TableDataInfo toQygkList(GxqEvaluationGjcompany gxqEvaluationGjcompany)
{
startPage();
List<GxqEvaluationGjcompany> listNew = gxqEvaluationGjcompanyService.selectGxqEvaluationGjcompanyOnly(gxqEvaluationGjcompany);
return getDataTable(listNew);
}
Xml文件:
<!--产业图谱——查询国家高新区企业附件详情-->
<select id="selectGxqEvaluationGjcompanyOnly" parameterType="String" resultMap="GxqEvaluationGjcompanyResultOnly">
<include refid="selectGxqEvaluationGjcompanyVoOnly"/>
<where>
<if test="year != null and qb18 != '' "> and year = #{year}</if>
/*企业类别搜索条件qb18*/
<if test="qb18 != null and qb18 != '' "> and qb18 = #{qb18}</if>
<if test="qb11 != null and qb11 != '' "> and qb11 = #{qb11}</if>
<if test="qb15_1 != null and qb15_1 != '' "> and qb15_1 != #{qb15_1}</if>
/* 产业画像搜索条件*/
<if test="qb16A != null and qb16A != '' "> and qb16 >= #{qb16A}</if>
<if test="qb16B != null and qb16B != '' "> and qb16 <= #{qb16B}</if>
/*企业区域搜索条件*/
<if test="saddress != null and saddress != '' and saddress neq '其他'.toString()"> and (saddress like concat('%', #{saddress}, '%') OR saddress like concat('%', #{saddressA}, '%') OR saddress like concat('%', #{saddressB}, '%')) </if>
<if test="saddress != null and saddress != ''and saddress eq '其他'.toString()"> and saddress not like concat('%', "巴城镇", '%') and saddress not like concat('%', "昆山开发区", '%') and saddress not like concat('%', "昆山高新区", '%') and saddress not like concat('%', "高新区", '%')
and saddress not like concat('%', "玉山镇", '%') and saddress not like concat('%', "正仪镇", '%')
and saddress not like concat('%', "花桥镇", '%') and saddress not like concat('%', "张浦镇", '%')
and saddress not like concat('%', "周市镇", '%') and saddress not like concat('%', "陆家镇", '%')
and saddress not like concat('%', "千灯镇", '%') and saddress not like concat('%', "淀山湖镇", '%')
and saddress not like concat('%', "周庄镇", '%') and saddress not like concat('%', "锦溪镇", '%')
</if>
<if test="sname != null and sname != '' "> and sname like concat('%', #{sname}, '%')</if>
and del_flag = 0
</where>
</select>