layui table 表格上添加日期控件
方法一(推荐):
var tableInit = table.render({ elem: '#tbtxrz' , method: 'post' , data: jsonData , height: "auto" , id: "tbtxrz" , text: {none: '暂无相关数据'} , toolbar: toolbartxrz , cols: [[ {field: "txmc", title: "<span style='color:#c00'></span>体系名称", width: 140, align: "left", edit: 'text'} , {field: "rztxmc", title: "<span style='color:#c00'>*</span>认证体系名称", width: 140, align: 'left', edit: 'text'} , {
field: "rzrq", title: "认证日期", width: 160, align: 'left',event: 'editStartDate',data_field:'rzrq' } , {field: "ywjm", title: "原文件名", width: 140, align: 'left'} , { field: '操作', title: '操作', width: '10%', unresize: true, templet: function (res) { return '<button type="button" class="layui-btn layui-btn-xs" data-type="' + res['LAY_TABLE_INDEX'] + '" id="uploadFile' + res['LAY_TABLE_INDEX'] + '" lay-event="upload"><i class="layui-icon layui-icon-upload-drag"></i></button> <button type="button" class="layui-btn layui-btn-xs layui-btn-danger" lay-event="del"><i class="layui-icon layui-icon-delete"></i></button>'; } } , {field: "pc", title: "批次", align: 'left', hide: true} ]] , done: function (res, curr, count) { //日期控件 // 上传文件 var data = res.data; for (var i = 0; i < data.length; i++) { var elem = '#uploadFile' + i; //循环初始上传组件 var uploadInst = upload.render({ elem: elem //绑定元素 , url: $("#contextpath").val() + '/upload/uploadFile2.do' //上传接口 , field: 'files' , auto: true , accept: 'file' // ,exts: 'xls|xlsx|csv' //添加上传额外参数 , data: { sjbs: function () { var sjbs = $("#sjbs").val(); var logId = $("#logId").val(); if (sjbs !== null && sjbs.length > 0) { sjbs = sjbs; } else { sjbs = $("#sjbs").attr('name') + new Date().getTime();//设置每次新增的批次 $("#sjbs").val($("#sjbs").attr('name') + new Date().getTime());//如果没有创建时间标识,就自己新增 } mcs.setSjbs(sjbs); return sjbs; } } //文件上传前回调 , before: function (obj) { //开启加载 layer.load(2, {time: 10 * 1000, offset: '200px'}); //从表格缓存中获取table指定行数据 updateRow = tableRowTool.data; var files = this.files = obj.pushFile(); obj.preview(function (index, file, result) { updateRow['scsj'] = new Date(new Date()).format("yyyy-MM-dd hh:mm:ss"); updateRow['ywjm'] = file.name; updateRow['xg'] = 1; // updateRow['wjdx'] = (file.size/1024).toFixed(1) +'kb'; }) } //上传成功后回调 , done: function (res, index, upload) { txrzxg = true; layer.closeAll(); if (res.status === "Y") { updateRow['ccm'] = res.fileName; updateRow['sjbs'] = res.sjbs; //文件上传成功,更新表格数据 tableRowTool.update(updateRow); //文件上传成功后,去掉.layui-table-click Table选中行状态 tableRowTool.tr.prop("class", ""); layer.msg(res.msg, { icon: 1 , time: 2000 , offset: '200px' }, function () { }) } else { layer.msg(res.msg, { icon: 5 , time: 2000 , offset: '200px' }) } //删除文件队列已经上传成功的文件 return delete this.files[index]; } //上传错误回调 , error: function () { layer.closeAll(); //请求异常回调 } }); } layer.closeAll(); } })
处理方法:
//监听行工具事件 table.on('tool(tbtxrz)', function (obj) { var data = obj.data; if(obj.event === 'editStartDate'){ var field = $(this).data('field'); laydate.render({ elem: this.firstChild , show: true //直接显示 , closeStop: this , done: function (value, date) { data[field] = value; obj.update(data); } }); } else if (obj.event='editzsdqsj'){ var field = $(this).data('field'); laydate.render({ elem: this.firstChild , show: true //直接显示 , closeStop: this , done: function (value, date) { data[field] = value; obj.update(data); }}); } });
方法二:不建议使用,因为不够灵活
js代码:
var layer = layui.layer, form = layui.form, table = layui.table;
var $ = layui.$;
/*select gysmc,zyzw ,xm ,sjhm ,bgshm ,emilyx ,
zgsrgzwsj ,zggsgl ,cast(gysxxid as int) as gysxxid, pc,
gysryxxMdataID as ID,sjbs from gysryxxMdata*/
var tableInit = table.render({
elem: '#tbgysplay'
, method: 'post'
, data: jsonData
, height: "auto"
, id: "tbgysplay"
, text: {none: '暂无相关数据'}
, toolbar: "#toolbarplan"
, cols: [[
{type: "checkbox", fixed: "left", width: 50}
, {
field: "number", title: "序号", width: '10%', align: "left", templet: function (data) {
return data.LAY_INDEX
}
}
, {field: "ID", title: "ID", align: "left", hide: true}
, {field: "action", title: "action", align: "left", hide: true}
, {field: "sjbs", title: "sjbs", align: "left", hide: true}
, {field: "供应商名称", title: "供应商名称", width: '15%', align: "left"}
, {field: "主要产品类型", title: "主要产品类型", width: '15%', align: 'left'}
, {field: "所在省份", title: "所在省份", width: '15%', align: 'left'}
, {
field: "PSA计划时间", title: "PSA计划时间", width: '20%', align: 'left', templet:function (d) {
return ' <input type="text" class="layui-input layui-input-date" value="'+d.PSA计划时间+'" id="test1">'
}
}
, {field: "PSA计划负责人", title: "PSA计划负责人", align: 'left',edit:'text'} ]] , done: function (res) {//当数据渲染完后,执行的回调 //日期控件 $(".layui-input-date").each(function (i) { layui.laydate.render({ elem: this, format: "yyyy-MM-dd", done: function (value, date) { if (res && res.data[i]) { $.extend(res.data[i], {'PSA计划时间': value}) } } }); }); layer.closeAll(); } });