天天看点

layui laytable数据表格让符合条件的数据进行变色高亮显示

layui.use('table', function(){

  var table = layui.table;

  table.render({

    elem: '#test'

    ,url:globalData.pre+'/manager/getAllManagerByPage'

    ,toolbar: '#toolbarDemo'

    ,title: '项目信息数据表'

    ,cols: [[

         {type: 'checkbox', fixed: 'left'}

         ,{field:'manager_num', title:'项目编号', width:120, edit: 'text',align:'center',fixed:'left'}

         ,{field:'manager_name', title:'项目名称', width:120, edit: 'text',align:'center'}

         ,{field:'manager_creator', title:'创建者', width:100,align:'center'}

         ,{field:'project_manager', title:'项目经理', width:100,align:'center'}

         ,{field:'title', title:'项目类型', width:100, align:'center',

             templet:function(res){return '<span>'+res.projectUtil.title+'</span>'}

         }

         ,{field:'manager_state', title:'状态', width:100,align:'center'}

         ,{field:'manager_notice', title:'公告', width:120, edit: 'text',align:'center'}

         ,{field:'project_weight', title:'项目权重', width:100,sort: true, edit: 'text',align:'center'}

         ,{field:'manager_create_time', title:'创建时间', width:120, align:'center'}

         ,{field:'manager_start_date', title:'启动日期', width:120, align:'center'}

         ,{field:'manager_end_date', title:'结束日期', width:120, align:'center'}

         ,{field:'online_run_date', title:'试运行日期', width:120,align:'center'}

         ,{field:'cliam_online_date', title:'要求上线日期', width:120, align:'center'}

         ,{fixed: 'right', title:'操作',width:160, toolbar: '#barDemo',align:'center'}

    ]]

    ,page: true

       //将分页条固定在底部

    ,done:function(res,curr,count){

        currPage=curr;

       var that=this.elem.next();

       $.each(res.data, function (index, obj) {

           if(obj.cliam_online_date != null){

               var day3 = new Date(obj.cliam_online_date);

                  var myDate = new Date();

                  var date = myDate.toLocaleDateString().split('/').join('-');

                  var day2=new Date(date);

                  if(Math.ceil((day2-day3)/86400000)<=2 && Math.ceil((day2-day3)/86400000)>=0 && obj.manager_state!='已完成'){

                that.find(".layui-table-box tbody tr[data-index='" + index + "']").css("background-color", "#FAB000");

                  }else if(Math.ceil((day2-day3)/86400000)<0 && obj.manager_state!='已完成'){

                      that.find(".layui-table-box tbody tr[data-index='" + index + "']").css("background-color", "#F08080");

                  }

           }

   })

   }

  });