#库存预警、库存统计同步物料

zjj

2023-09-07 607e14a92ba7c0b2dc277591e93104b53274d282

#库存预警、库存统计同步物料

 .idea/misc.xml

@@ -10,7 +10,7 @@
      </list>
    </option>
  </component>
  <component name="ProjectRootManager" version="2" languageLevel="JDK_14" project-jdk-name="1.8" project-jdk-type="JavaSDK">
  <component name="ProjectRootManager" version="2" languageLevel="JDK_1_8" default="true" project-jdk-name="1.8" project-jdk-type="JavaSDK">
    <output url="file://$PROJECT_DIR$/out" />
  </component>
</project>

 .idea/zy-asrs.iml

@@ -22,8 +22,6 @@
    </content>
    <orderEntry type="jdk" jdkName="1.8" jdkType="JavaSDK" />
    <orderEntry type="sourceFolder" forTests="false" />
    <orderEntry type="library" name="Maven: cn.cool:framework:2.2.0" level="project" />
    <orderEntry type="library" scope="PROVIDED" name="Maven: org.projectlombok:lombok:1.18.14" level="project" />
    <orderEntry type="library" name="Maven: org.springframework.boot:spring-boot-starter-web:2.1.3.RELEASE" level="project" />
    <orderEntry type="library" name="Maven: org.springframework.boot:spring-boot-starter:2.1.3.RELEASE" level="project" />
    <orderEntry type="library" name="Maven: org.springframework.boot:spring-boot:2.1.3.RELEASE" level="project" />
@@ -48,6 +46,7 @@
    <orderEntry type="library" name="Maven: org.springframework:spring-beans:5.1.5.RELEASE" level="project" />
    <orderEntry type="library" name="Maven: org.springframework:spring-webmvc:5.1.5.RELEASE" level="project" />
    <orderEntry type="library" name="Maven: org.springframework:spring-aop:5.1.5.RELEASE" level="project" />
    <orderEntry type="library" name="Maven: org.springframework:spring-context:5.1.5.RELEASE" level="project" />
    <orderEntry type="library" name="Maven: org.springframework:spring-expression:5.1.5.RELEASE" level="project" />
    <orderEntry type="library" scope="PROVIDED" name="Maven: org.springframework.boot:spring-boot-starter-tomcat:2.1.3.RELEASE" level="project" />
    <orderEntry type="library" name="Maven: javax.annotation:javax.annotation-api:1.3.2" level="project" />
@@ -70,7 +69,6 @@
    <orderEntry type="library" name="Maven: io.projectreactor:reactor-core:3.2.6.RELEASE" level="project" />
    <orderEntry type="library" name="Maven: org.reactivestreams:reactive-streams:1.0.2" level="project" />
    <orderEntry type="library" name="Maven: cn.cool:framework:2.2.0" level="project" />
    <orderEntry type="library" name="Maven: org.springframework:spring-context:5.1.5.RELEASE" level="project" />
    <orderEntry type="library" name="Maven: mysql:mysql-connector-java:5.1.47" level="project" />
    <orderEntry type="library" name="Maven: com.microsoft.sqlserver:mssql-jdbc:8.2.2.jre8" level="project" />
    <orderEntry type="library" name="Maven: com.baomidou:mybatis-plus-boot-starter:2.3.2" level="project" />
@@ -160,10 +158,5 @@
    <orderEntry type="library" name="Maven: org.apache.cxf:cxf-rt-ws-policy:3.3.4" level="project" />
    <orderEntry type="library" name="Maven: org.apache.neethi:neethi:3.1.1" level="project" />
    <orderEntry type="library" name="Maven: javax.validation:validation-api:2.0.1.Final" level="project" />
    <orderEntry type="library" name="Maven: com.sun.activation:javax.activation:1.2.0" level="project" />
    <orderEntry type="library" name="Maven: org.apache.geronimo.specs:geronimo-ws-metadata_2.0_spec:1.1.3" level="project" />
    <orderEntry type="library" name="Maven: org.jacorb:jacorb-omgapi:3.7" level="project" />
    <orderEntry type="library" name="Maven: org.apache.geronimo.specs:geronimo-jta_1.1_spec:1.1.1" level="project" />
    <orderEntry type="library" name="Maven: org.jboss.spec.javax.rmi:jboss-rmi-api_1.0_spec:1.0.6.Final" level="project" />
  </component>
</module>

 src/main/java/com/zy/asrs/controller/LocDetlController.java

@@ -11,6 +11,7 @@
import com.core.common.DateUtils;
import com.core.common.R;
import com.zy.asrs.entity.LocDetl;
import com.zy.asrs.entity.LocDetlWarningDTO;
import com.zy.asrs.entity.LocMast;
import com.zy.asrs.service.LocDetlService;
import com.zy.asrs.service.LocMastService;
@@ -212,6 +213,24 @@
        return R.ok();
    }


    @RequestMapping(value = "/locDetl/selectAllWarning/auth")
    @ManagerAuth(memo = "库存预警")
    public Map<String,Object> queryViewStayTimeListByPages(@RequestParam(defaultValue = "1")Integer curr,
                                                           @RequestParam(defaultValue = "10")Integer limit,
                                                           @RequestParam Map<String, Object> param){
        LocDetlWarningDTO locDetlWarningDTO = new LocDetlWarningDTO();
        locDetlWarningDTO.setPageSize(limit);
        locDetlWarningDTO.setPageNumber(curr);
        String mat_no = String.valueOf(param.get("mat_no"));
        if (!Cools.isEmpty(mat_no) && !mat_no.equals("null")) {
            locDetlWarningDTO.setMat_no(mat_no);
        }
        List<LocDetlWarningDTO> list = locDetlService.selectAllWarning(locDetlWarningDTO);
        int count = locDetlService.getAllWarningCount(locDetlWarningDTO);
        Page<LocDetlWarningDTO> page = new Page<>();
        page.setRecords(list);
        page.setTotal(count);
        return R.ok(page);
    }

}

 src/main/java/com/zy/asrs/entity/LocDetl.java

@@ -132,6 +132,7 @@
    @ApiModelProperty(value= "类别")
    private String str5;


    public String getStr5$(){
        if (Cools.isEmpty(this.str5) ){
            return "";

 src/main/java/com/zy/asrs/entity/LocDetlWarningDTO.java

New file
@@ -0,0 +1,27 @@
package com.zy.asrs.entity;

import lombok.Data;

import java.util.Date;

@Data
public class LocDetlWarningDTO {

    private int pageNumber;
    private int pageSize;
    private Integer row;
    private String mat_name;
    private String mat_no;
    private String str3;
    private Double qty;
    private Double all_qty;
    private String specs;
    private String unit;
    private String color;
    private Double qty_box;
    private Double weight;
    private String str4;
    private String str5;
    private String num1;
    private String str6;
}

 src/main/java/com/zy/asrs/mapper/LocDetlMapper.java

@@ -2,6 +2,7 @@

import com.baomidou.mybatisplus.mapper.BaseMapper;
import com.zy.asrs.entity.LocDetl;
import com.zy.asrs.entity.LocDetlWarningDTO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
@@ -46,4 +47,7 @@
    @Select("select mat_no,mat_name,sum(qty) qty from asr_loc_detl group by mat_no,mat_name")
    List<LocDetl> getStockSum();

    List<LocDetlWarningDTO> selectAllWarning(LocDetlWarningDTO locDetlWarningDTO);

    int getAllWarningCount(LocDetlWarningDTO locDetlWarningDTO);
}

 src/main/java/com/zy/asrs/service/LocDetlService.java

@@ -3,6 +3,7 @@
import com.baomidou.mybatisplus.plugins.Page;
import com.baomidou.mybatisplus.service.IService;
import com.zy.asrs.entity.LocDetl;
import com.zy.asrs.entity.LocDetlWarningDTO;

import java.util.List;

@@ -66,4 +67,7 @@
     */
    public List<LocDetl> getStockSum();

    List<LocDetlWarningDTO> selectAllWarning(LocDetlWarningDTO locDetlWarningDTO);

    int getAllWarningCount(LocDetlWarningDTO locDetlWarningDTO);
}

 src/main/java/com/zy/asrs/service/impl/LocDetlServiceImpl.java

@@ -4,6 +4,7 @@
import com.baomidou.mybatisplus.plugins.Page;
import com.baomidou.mybatisplus.service.impl.ServiceImpl;
import com.zy.asrs.entity.LocDetl;
import com.zy.asrs.entity.LocDetlWarningDTO;
import com.zy.asrs.entity.MatCode;
import com.zy.asrs.mapper.LocDetlMapper;
import com.zy.asrs.service.LocDetlService;
@@ -85,4 +86,13 @@
        return locDetlMapper.getStockSum();
    }

    @Override
    public List<LocDetlWarningDTO> selectAllWarning(LocDetlWarningDTO locDetlWarningDTO) {
        return this.baseMapper.selectAllWarning(locDetlWarningDTO);
    }

    @Override
    public int getAllWarningCount(LocDetlWarningDTO locDetlWarningDTO) {
        return this.baseMapper.getAllWarningCount(locDetlWarningDTO);
    }
}

 src/main/resources/mapper/LocDetlMapper.xml

@@ -197,18 +197,19 @@
        where loc_no=#{locNo}
    </select>
    <select id="getStockStatis" resultMap="BaseResultMap">
        select * from
        select  * ,str6 as qty_box,(qty * str6) as all_qty from
        (
        select ROW_NUMBER() over (order by a.mat_no) as row,
        a.mat_name,a.mat_no,a.str3,sum(a.qty) qty,sum(all_qty) all_qty, specs,unit,color,qty_box,weight,str4,str5  from
        a.mat_name,a.mat_no,a.str3,sum(a.qty) qty, specs,unit,color,weight,str4,str5,num1,str6  from
        (
        select
        mat_name,mat_no,str3,qty,all_qty,specs,unit,color,qty_box,weight,str4,str5
        c.mat_name,c.mat_no,c.str3,c.qty,c.all_qty,c.specs,c.unit,c.color,c.weight,c.str4,c.str5,m.num1,m.str6
        from asr_loc_detl c
        LEFT JOIN bas_mat_code m ON c.mat_no = m.mat_no
        where 1=1
        <include refid="stockOutCondition1"></include>
        ) a
        group by a.mat_no,a.mat_name,a.str3,a.specs,a.unit,a.color,a.qty_box,a.weight,a.str4,a.str5
        group by a.mat_no,a.mat_name,a.str3,a.specs,a.unit,a.color,a.weight,a.str4,a.str5,num1,str6
        ) d
        where 1=1
        and row between ((#{pageNumber}-1)*#{pageSize}+1) and (#{pageNumber}*#{pageSize})
@@ -234,15 +235,16 @@
        select count(1) from
        (
        select ROW_NUMBER() over (order by a.mat_no) as row,
        a.mat_name,a.mat_no,a.str3,sum(a.qty) qty,specs,unit,color,qty_box,weight,str4,str5  from
        a.mat_name,a.mat_no,a.str3,sum(a.qty) qty, specs,unit,color,qty_box,weight,str4,str5,num1,str6  from
        (
        select
        mat_name,mat_no,str3,qty,specs,unit,color,qty_box,weight,str4,str5
        c.mat_name,c.mat_no,c.str3,c.qty,c.all_qty,c.specs,c.unit,c.color,c.qty_box,c.weight,c.str4,c.str5,m.num1,m.str6
        from asr_loc_detl c
        LEFT JOIN bas_mat_code m ON c.mat_no = m.mat_no
        where 1=1
        <include refid="stockOutCondition1"></include>
        ) a
        group by a.mat_no,a.mat_name,a.str3,a.specs,a.unit,a.color,a.qty_box,a.weight,a.str4,a.str5
        group by a.mat_no,a.mat_name,a.str3,a.specs,a.unit,a.color,a.qty_box,a.weight,a.str4,a.str5,num1,str6
        ) d
<!--        select count(1) from-->
<!--        (-->
@@ -270,7 +272,143 @@
        group by a.mat_no,a.mat_name,a.supplier,a.str3,a.specs,a.unit,a.color,a.qty_box,a.weight,a.str4,a.str5
    </select>

<!--    <select id="getStockSum" resultMap="BaseResultMap">-->
    <sql id="selectAllWarningSql">
        <if test="mat_name != null and mat_name != '' ">
            and c.mat_name like '%' + #{mat_name} + '%'
        </if>
        <if test="mat_no != null and mat_no !='' ">
            and c.mat_no like '%' + #{mat_no} + '%'
        </if>

    </sql>
    <select id="selectAllWarning" resultType="com.zy.asrs.entity.LocDetlWarningDTO">
        SELECT
        *,(qty * str6) as all_qty
        FROM
        (
        SELECT
        ROW_NUMBER ( ) OVER ( ORDER BY a.mat_no ) AS row,
        a.mat_name,
        a.mat_no,
        a.str3,
        SUM ( a.qty ) qty,
        specs,
        unit,
        color,
        qty_box,
        weight,
        str4,
        str5,
        num1,
        str6
        FROM
        (
        SELECT
        c.mat_name,
        c.mat_no,
        c.str3,
        c.qty,
        c.all_qty,
        c.specs,
        c.unit,
        c.color,
        c.qty_box,
        c.weight,
        c.str4,
        c.str5,
        m.num1,
        str6
        FROM
        asr_loc_detl c
        LEFT JOIN bas_mat_code m ON c.mat_no = m.mat_no
        WHERE
        1 = 1
        <include refid="selectAllWarningSql"></include>
        ) a
        GROUP BY
        a.mat_no,
        a.mat_name,
        a.str3,
        a.specs,
        a.unit,
        a.color,
        a.qty_box,
        a.weight,
        a.str4,
        a.str5,
        a.num1,
        str6
        ) d
        WHERE
        1 = 1
        AND qty &lt;= num1
        AND d.row BETWEEN ((#{pageNumber}-1)*#{pageSize}+1) and (#{pageNumber}*#{pageSize})
    </select>

    <select id="getAllWarningCount" resultType="java.lang.Integer">
        SELECT
            COUNT(1)
        FROM
            (
        SELECT
            ROW_NUMBER ( ) OVER ( ORDER BY a.mat_no ) AS row,
                a.mat_name,
            a.mat_no,
            a.str3,
            SUM ( a.qty ) qty,
            SUM ( all_qty ) all_qty,
            specs,
            unit,
            color,
            qty_box,
            weight,
            str4,
            str5,
            num1
        FROM
            (
            SELECT
                c.mat_name,
                c.mat_no,
                c.str3,
                c.qty,
                c.all_qty,
                c.specs,
                c.unit,
                c.color,
                c.qty_box,
                c.weight,
                c.str4,
                c.str5,
                m.num1
            FROM
                asr_loc_detl c
                    LEFT JOIN bas_mat_code m ON c.mat_no = m.mat_no
            WHERE
                1 = 1
            <include refid="selectAllWarningSql"></include>
            ) a
        GROUP BY
            a.mat_no,
            a.mat_name,
            a.str3,
            a.specs,
            a.unit,
            a.color,
            a.qty_box,
            a.weight,
            a.str4,
            a.str5,
            a.num1
            ) d
        WHERE
            1 = 1
          AND qty &lt;= num1
    </select>



    <!--    <select id="getStockSum" resultMap="BaseResultMap">-->
<!--        select mat_no,mat_name,sum(qty) qty  from asr_loc_detl-->
<!--        group by mat_no,mat_name-->
<!--    </select>-->

 src/main/webapp/static/js/locDetlWarning/locDetlWarning.js

New file
@@ -0,0 +1,269 @@
var pageCurr;
function getCol() {
    var cols = [
        {field: 'countAnfme', align: 'center',title: '库存数量', style: 'font-weight: bold'}
    ];
    arrRemove(detlCols, "field", "anfme")
    arrRemove(detlCols, "field", "zpallet")
    cols.push.apply(cols, detlCols);
    // cols.push({field: 'anfme', align: 'center',title: '数量', style: 'font-weight: bold'}
    // )
    return cols;
}

layui.use(['table','laydate', 'form'], function(){
    var table = layui.table;
    var $ = layui.jquery;
    var layer = layui.layer;
    var layDate = layui.laydate;
    var form = layui.form;

    // 数据渲染
    tableIns = table.render({
        elem: '#locDetlWarning',
        headers: {token: localStorage.getItem('token')},
        url: baseUrl+'/locDetl/selectAllWarning/auth',
        page: true,
        limit: 20,
        limits: [20, 30, 50, 100, 200, 500],
        even: true,
        toolbar: '#toolbar',
        cellMinWidth: 50,
        cols: [[
            {field: 'qty', align: 'center', title: '在库箱数', width: 120}
            ,{field: 'num1', align: 'center', title: '安全箱数', width: 120}
            , {field: 'mat_no', align: 'center', title: '产品编码'}
            , {field: 'mat_name', align: 'center', title: '产品名称'}
            , {field: 'specs', align: 'center',title: '规格'}
            , {field: 'unit', align: 'center',title: '单位', width:80}
            , {field: 'color', align: 'center',title: '颜色'}
            , {field: 'str6', align: 'center',title: '每箱数量(PCS)'}
            , {field: 'all_qty', align: 'center',title: '总数量(PCS)'}
            , {field: 'weight', align: 'center',title: '每箱重量(KG)'}

        ]
        ],
        request: {
            pageName: 'curr',
            pageSize: 'limit'
        },
        parseData: function (res) {
            return {
                'code': res.code,
                'msg': res.msg,
                'count': res.data.total,
                'data': res.data.records
            }
        },
        response: {
            statusCode: 200
        },
        done: function(res, curr, count) {
            if (res.code === 403) {
                top.location.href = baseUrl+"/";
            }
            pageCurr=curr;
            limit();
            form.on('checkbox(tableCheckbox)', function (data) {
                var _index = $(data.elem).attr('table-index')||0;
                if(data.elem.checked){
                    res.data[_index][data.value] = 'Y';
                }else{
                    res.data[_index][data.value] = 'N';
                }
            });
            /**
             * 显示库存总数量
             */
            $.ajax({
                url: baseUrl+"/locDetl/count",
                headers: {'token': localStorage.getItem('token')},
                contentType:'application/json;charset=UTF-8',
                method: 'POST',
                success: function (res) {
                    $("#countNum").text(res.data + '个');
                }
            });

        }
    });

    // 监听排序事件
    table.on('sort(locDetlStatis)', function (obj) {
        var searchData = {};
        $.each($('#search-box [name]').serializeArray(), function() {
            searchData[this.name] = this.value;
        });
        searchData['orderByField'] = obj.field;
        searchData['orderByType'] = obj.type;
        tableIns.reload({
            where: searchData,
            page: {
                curr: 1
            },
            done: function (res, curr, count) {
                if (res.code === 403) {
                    top.location.href = baseUrl+"/";
                }
                pageCurr=curr;
                limit();
            }
        });
    });

    // 监听头工具栏事件
    table.on('toolbar(locDetlStatis)', function (obj) {
        var checkStatus = table.checkStatus(obj.config.id);
        switch(obj.event) {
            case 'exportAll':
                layer.closeAll();
                layer.load(1, {shade: [0.1,'#fff']});
                location.href = baseUrl + "/locDetl/statis/export";
                layer.closeAll('loading');
                break;
            case 'exportData':
                layer.confirm('确定导出Excel吗', {shadeClose: true}, function(){
                    var titles=[];
                    var fields=[];
                    obj.config.cols[0].map(function (col) {
                        if (col.type === 'normal' && col.hide === false && col.toolbar == null) {
                            titles.push(col.title);
                            fields.push(col.field);
                        }
                    });
                    var exportData = {};
                    $.each($('#search-box [name]').serializeArray(), function() {
                        exportData[this.name] = this.value;
                    });
                    var param = {
                        'locDetl': exportData,
                        'fields': fields
                    };
                    $.ajax({
                        url: baseUrl+"/locDetl/export/auth",
                        headers: {'token': localStorage.getItem('token')},
                        data: JSON.stringify(param),
                        dataType:'json',
                        contentType:'application/json;charset=UTF-8',
                        method: 'POST',
                        success: function (res) {
                            layer.closeAll();
                            if (res.code === 200) {
                                table.exportFile(titles,res.data,'xls');
                            } else if (res.code === 403) {
                                top.location.href = baseUrl+"/";
                            } else {
                                layer.msg(res.msg)
                            }
                        }
                    });
                });
                break;
        }
    });

    // 监听行工具事件
    table.on('tool(locDetlStatis)', function(obj){
        var data = obj.data;
        switch (obj.event) {
            // 详情
            case 'detail':
                layer.open({
                    type: 2,
                    title: '详情',
                    maxmin: true,
                    area: [top.detailWidth, top.detailHeight],
                    shadeClose: false,
                    content: 'locDetl_detail.html',
                    success: function(layero, index){
                        setFormVal(layer.getChildFrame('#detail', index), data, true);
                        top.convertDisabled(layer.getChildFrame('#data-detail :input', index), true);
                        layer.getChildFrame('#data-detail-submit-save,#data-detail-submit-edit,#prompt', index).hide();
                        layer.iframeAuto(index);layer.style(index, {top: (($(window).height()-layer.getChildFrame('#data-detail', index).height())/3)+"px"});
                        layero.find('iframe')[0].contentWindow.layui.form.render('select');
                        layero.find('iframe')[0].contentWindow.layui.form.render('checkbox');
                    }
                });
                break;

        }
    });


    // 搜索栏搜索事件
    form.on('submit(search)', function (data) {
        pageCurr = 1;
        tableReload(false);
    });

    // 搜索栏重置事件
    form.on('submit(reset)', function (data) {
        pageCurr = 1;
        clearFormVal($('#search-box'));
        tableReload(false);
    });

    // 时间选择器
    layDate.render({
        elem: '#modiTime\\$',
        type: 'datetime'
    });
    layDate.render({
        elem: '#appeTime\\$',
        type: 'datetime'
    });


});

// 关闭动作
$(document).on('click','#data-detail-close', function () {
    parent.layer.closeAll();
});

function tableReload(child) {
    var searchData = {};
    $.each($('#search-box [name]').serializeArray(), function() {
        searchData[this.name] = this.value;
    });
    (child ? parent.tableIns : tableIns).reload({
        where: searchData,
        page: {
            curr: pageCurr
        },
        done: function (res, curr, count) {
            if (res.code === 403) {
                top.location.href = baseUrl+"/";
            }
            pageCurr=curr;
            if (res.data.length === 0 && count !== 0) {
                tableIns.reload({
                    where: searchData,
                    page: {
                        curr: pageCurr-1
                    }
                });
                pageCurr -= 1;
            }
            limit(child);
        }
    });
}

function detailScreen(index) {
    var detail = layer.getChildFrame('#data-detail', index);
    var height = detail.height()+60;
    if (height > ($(window).height()*0.9)) {
        height = ($(window).height()*0.8);
    }
    layer.style(index, {
//        top: (($(window).height()-height)/3)+"px",
        height: height+'px'
    });
}

$('body').keydown(function () {
    if (event.keyCode === 13) {
        $("#search").click();
    }
});

 src/main/webapp/views/locDetlWarning/locDetlWarning.html

New file
@@ -0,0 +1,59 @@
<!DOCTYPE html>
<html lang="en">
<head>
  <meta charset="utf-8">
  <title></title>
  <meta name="renderer" content="webkit">
  <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
  <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1">
  <link rel="stylesheet" href="../../static/layui/css/layui.css" media="all">
  <link rel="stylesheet" href="../../static/css/cool.css" media="all">
  <link rel="stylesheet" href="../../static/css/common.css" media="all">
</head>
<body>

<!-- 搜索栏 -->
<div id="search-box" class="layui-form layui-card-header">
  <div class="layui-inline">
    <div class="layui-input-inline">
      <input class="layui-input" type="text" name="mat_no" placeholder="商品编号" autocomplete="off">
    </div>
  </div>
  <!-- 待添加 -->
  <div id="data-search-btn" class="layui-btn-container layui-form-item" style="display: inline-block">
    <button id="search" class="layui-btn layui-btn-primary layui-btn-radius" lay-submit lay-filter="search">搜索
    </button>
    <button id="reset" class="layui-btn layui-btn-primary layui-btn-radius" lay-submit lay-filter="reset">重置
    </button>
  </div>
<!--  <div class="layui-inline">-->
<!--    <fieldset class="layui-elem-field">-->
<!--      <legend>总计数量</legend>-->
<!--      <div class="layui-field-box" id="countNum">-->
<!--        请稍等-->
<!--      </div>-->
<!--    </fieldset>-->
<!--  </div>-->
</div>

<!-- 表格 -->
<div class="layui-form">
  <table class="layui-hide" id="locDetlWarning" lay-filter="locDetlWarning"></table>
</div>
<script type="text/html" id="toolbar">

<!--  <div class="layui-btn-container layui-col-md1">-->
<!--    <button class="layui-btn" lay-event="exportAll" style="margin-top: -0px">导出全部</button>-->
<!--  </div>-->
</script>


<script type="text/javascript" src="../../static/js/jquery/jquery-3.3.1.min.js"></script>
<script type="text/javascript" src="../../static/layui/layui.js" charset="utf-8"></script>
<script type="text/javascript" src="../../static/js/common.js" charset="utf-8"></script>
<script type="text/javascript" src="../../static/js/cool.js" charset="utf-8"></script>
<script type="text/javascript" src="../../static/js/locDetlWarning/locDetlWarning.js" charset="utf-8"></script>

</body>
</html>