<select id="zc_state_id" name="zc_state_id" lay-verify="required" lay-search=""></select>
如果动态获取数据
$.ajax({
type:"post",
url:'zd/csleibie',
dataType:"json",
async:false,
success:function (data) {
$("zc_state_id").append(new Option("全部",""));
$.each(data,function (index,state) {
$("zc_state_id").append(state.leibie_name,state.zd_leibie_id)
})
form.render();
}
layui.use(['form', 'table'], function () {
var $ = layui.jquery,
form = layui.form,
layer=layui.layer,
table = layui.table;//获取当前页面所有的table
var exportData; //后台原始数据
var title = []; //excel头部title
var importData = []; //导出excel数据
var abc = [
{field: 'zdid', title: '工单编号', style:'width:10%',},
];
//渲染表格
var ins1= table.render({
elem: '#demo',//指定table的id
url: '/zd/ceshicha',
done:function(res, curr ,count){
exportData=res.data;
$('th').css(({ 'text-align':'center','background-color': '#bdccea', 'color': 'black', 'font-weight': '500' }))
$('layui-table-total.layui-table tbody tr').css({ 'color': 'red' });
$('.layui-table-total.layui-table tbody tr').css({ 'background-color': '#ffffb4' });
var that = this.elem.next(); res.data.forEach(function (item, index) {
//console.log(item.empName);item表示每列显示的数据
if (index % 2 == 0) {
var tr = that.find(".layui-table-box tbody tr[data-index='" + index + "']")
.css(({'border-top':'1px solid black','border-bottom':'dashed','border-left':'1px','text-align':'center'}));
} else {
var tr = that.find(".layui-table-box tbody tr[data-index='" + index + "']")
.css(({'border-top':'1px solid red','border-bottom':'dashed','text-align':'center'}));
}
});
//遍历excel表格头部
$.each(abc,function (index,item) {
title.push(item.title);
});
//遍历excel表格数据
$.each(exportData,function (index,item) {
var row_arr = [];
$.each(abc,function (i,row) {
if(row.field=="zd_state"){
row_arr.push( item.zd_state.access_network);
}else{
row_arr.push(item[row.field]);
}
});
importData.push(row_arr);
});
},
defaultToolbar: ['filter', 'exports', 'print', {
title: '提示',
layEvent: 'LAYTABLE_TIPS',
icon: 'layui-icon-tips'
}],
method: "post",
cols: [abc],
limits: [10, 15, 20, 25, 50, 100],
limit: 15,
page: true,
skin: 'line'
});
//导出excel
$("#export").click(function(){
table.exportFile(title, importData,'xls');
});
//点击监听
table.on('row(demo)', function (obj) {
//获取的zdid
//跳转的时候如何拿到获取的值
layer.open({
type:2,
shadeClose: true,
shade: false,
maxmin:true,
area:['100%','100%'],
content: 'http://localhost:8887/zd/xiangxi/'+obj.data.zdid
});
})
// 监听搜索操作
form.on('submit(data-search-btn)', function (data) {
//执行搜索重载
table.reload('demo', {
page: {
curr: 1
},
where: data.field
}, 'data');
return false;
});
table.on('tool(currentTableFilter)', function (obj) {
var data = obj.data;
if (obj.event === 'exit') {
layer.open({
type: 2
,title: false //不显示标题栏
,closeBtn: false
,area: ['900px','600px']
,shade: 0.8
,id: 'LAY_layuipro' //设定一个id,防止重复弹出
,btn: ['取消']
,btnAlign: 'c'
,moveType: 1 //拖拽模式,0或者1
,content: '/letter/toLetterList?lNumber='+data.lNumber
,success: function(layero,index){
}
});
}
});
});