WebTM/views/Éú²ú¹ÜÀí/¼ðÁÏÅäË͵¥/JIT_ComplementGoodsList.html
@@ -11,6 +11,7 @@
    <script src="../../../layuiadmin/Scripts/jquery-1.4.1.js"></script>
    <script src="../../../layuiadmin/Scripts/webConfig.js"></script>
    <script src="../../../layuiadmin/PubCustom.js"></script>
    <script src="../../../layuiadmin/soulTable.slim.js"></script>
    <style>
        .layui-row .layui-btn layui-btn-normal {
            margin: 0px 10px;
@@ -29,6 +30,10 @@
                        <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="Xc" id="Xc">下查</button>
                        <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="Ylan" id="Ylan">预览</button>
                        <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="Dyin" id="Dyin">打印</button>
                        <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="Cx" id="Cx">查询</button>
                        <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="Jlps" id="Jlps">拣料配送</button>
                        <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="set_DeleteBill" id="set_DeleteBill">删除</button>
                        <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="HideColumn" id="HideColumn">隐藏列设置</button>
                    </div>
                    <div class="layui-collapse">
                        <div class="layui-colla-item">
@@ -38,28 +43,52 @@
                                </div>
                            </div>
                            <div class="layui-inline">
                                <label class="layui-form-label" style="width: 85px;">物料代码</label>
                                <div class="layui-input-block" style="margin-left: 77px;">
                                    <input type="text" class="layui-input" lay-verify="MaterialNumber" name="MaterialNumber" id="MaterialNumber" style="background-color:#efefef4d;width: 60%;display: inline-block;" readonly>
                                    <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnMaterial" id="btnMaterial" style="padding: 0 10px;float: right;margin-right: 3px;">
                                        <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
                                    </button>
                                <label class="layui-form-label">拣料状态</label>
                                <div class="layui-input-block" style="margin-left: 120px;width: 184px;">
                                    <select name="HJLStatus" lay-verify="HJLStatus" id="HJLStatus">
                                        <option value="全部">全部</option>
                                        <option value="已拣料">已拣料</option>
                                        <option value="未拣料" selected="selected">未拣料</option>
                                    </select>
                                </div>
                            </div>
                            <div class="layui-inline">
                                <label class="layui-form-label" style="width: 85px;">物料名称</label>
                                <label class="layui-form-label" style="width: 85px;">拣料日期</label>
                                <div class="layui-input-block" style="margin-left: 120px;">
                                    <input type="text" class="layui-input" name="MaterialName" lay-verify="MaterialName" id="MaterialName" style="background-color:#efefef4d;" readonly>
                                    <input type="hidden" name="MaterialID" id="MaterialID" lay-verify="MaterialID" value="0">
                                    <input type="date" class="layui-input" lay-verify="HBeginDate" name="HBeginDate" id="HBeginDate" style="padding-left: 80px;">
                                </div>
                            </div>
                            <div class="layui-inline">
                                <label class="layui-form-label" style="width: 85px;">物料规格型号</label>
                                <div class="layui-input-block" style="margin-left: 120px;">
                                    <input type="text" class="layui-input" name="MaterialModel" id="MaterialModel" onmouseover="this.title=this.value" readonly>
                                <label class="layui-form-label" style="width: 85px;">—</label>
                                <div class="layui-input-block" style="margin-left: 118px;">
                                    <input type="date" class="layui-input" lay-verify="HEndDate" name="HEndDate" id="HEndDate" style="padding-left: 80px;">
                                </div>
                            </div>
                            <div class="layui-colla-content" style="padding: 0px; margin-left: 6%;">
                            <div class="layui-colla-content" style="padding: 0px; margin-left: 5%;">
                                <div class="layui-row" style="margin-top:10px;">
                                    <div class="layui-inline">
                                        <label class="layui-form-label" style="width: 85px;">物料代码</label>
                                        <div class="layui-input-block" style="margin-left: 77px;">
                                            <input type="text" class="layui-input" lay-verify="MaterialNumber" name="MaterialNumber" id="MaterialNumber" style="background-color:#efefef4d;width: 60%;display: inline-block;" readonly>
                                            <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnMaterial" id="btnMaterial" style="padding: 0 10px;float: right;margin-right: 3px;">
                                                <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
                                            </button>
                                        </div>
                                    </div>
                                    <div class="layui-inline">
                                        <label class="layui-form-label" style="width: 85px;">物料名称</label>
                                        <div class="layui-input-block" style="margin-left: 120px;">
                                            <input type="text" class="layui-input" name="MaterialName" lay-verify="MaterialName" id="MaterialName" style="background-color:#efefef4d;" readonly>
                                            <input type="hidden" name="MaterialID" id="MaterialID" lay-verify="MaterialID" value="0">
                                        </div>
                                    </div>
                                    <div class="layui-inline">
                                        <label class="layui-form-label" style="width: 85px;">物料规格型号</label>
                                        <div class="layui-input-block" style="margin-left: 120px;">
                                            <input type="text" class="layui-input" name="MaterialModel" id="MaterialModel" onmouseover="this.title=this.value" readonly>
                                        </div>
                                    </div>
                                </div>
                                <div class="layui-row" style="margin-top:10px;">
                                    <div class="layui-inline">
                                        <label class="layui-form-label" style="width: 85px;padding: 9px 18px;">工段</label>
@@ -80,6 +109,17 @@
                                        </div>
                                    </div>
                                    <div class="layui-inline">
                                        <label class="layui-form-label" style="width: 85px;">部门</label>
                                        <div class="layui-input-block" style="margin-left: 77px;">
                                            <input type="text" class="layui-input" name="HDeptName" lay-verify="HDeptName" id="HDeptName" style="background-color:#efefef4d;width: 60%;display: inline-block;" readonly>
                                            <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnHDeptName" id="btnHDeptName" style="padding: 0 10px;margin-right: 3px;">
                                                <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
                                            </button>
                                        </div>
                                    </div>
                                </div>
                                <div class="layui-row" style="margin-top:10px;">
                                    <div class="layui-inline">
                                        <label class="layui-form-label" style="width: 80px;">当前组织</label>
                                        <div class="layui-input-block" style="margin-left: 110px; width: 185px;">
                                            <select name="Organization" id="Organization" lay-verify="Organization">
@@ -88,46 +128,6 @@
                                        </div>
                                    </div>
                                </div>
                                <div class="layui-row" style="margin-top:10px;">
                                    <div class="layui-inline">
                                        <label class="layui-form-label" style="width: 85px;">拣料日期</label>
                                        <div class="layui-input-block" style="margin-left: 120px;">
                                            <input type="date" class="layui-input" lay-verify="HBeginDate" name="HBeginDate" id="HBeginDate" style="padding-left: 48px;">
                                        </div>
                                    </div>
                                    <div class="layui-inline">
                                        <label class="layui-form-label" style="width: 85px;">—</label>
                                        <div class="layui-input-block" style="margin-left: 118px;">
                                            <input type="date" class="layui-input" lay-verify="HEndDate" name="HEndDate" id="HEndDate" style="padding-left: 48px;">
                                        </div>
                                    </div>
                                    <div class="layui-inline">
                                        <label class="layui-form-label" style="width: 85px;padding: 9px 18px;">部门</label>
                                        <div class="layui-input-block" style="margin-left: 77px;">
                                            <input type="text" class="layui-input" name="HDeptName" lay-verify="HDeptName" id="HDeptName" style="background-color:#efefef4d;width: 60%;display: inline-block;" readonly>
                                            <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnHDeptName" id="btnHDeptName" style="padding: 0 10px;float: right;margin-right: 3px;">
                                                <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
                                            </button>
                                        </div>
                                    </div>
                                </div>
                                <div class="layui-row" style="margin-top:10px;">
                                    <div class="layui-inline">
                                        <label class="layui-form-label">拣料状态</label>
                                        <div class="layui-input-block" style="margin-left: 120px;width: 184px;">
                                            <select name="HJLStatus" lay-verify="HJLStatus" id="HJLStatus">
                                                <option value="全部">全部</option>
                                                <option value="已拣料">已拣料</option>
                                                <option value="未拣料">未拣料</option>
                                            </select>
                                        </div>
                                    </div>
                                </div>
                            </div>
                            <div class="layui-row" style="text-align: center; margin-bottom: 20px; margin-top: 20px;">
                                <button class="layui-btn layui-btn-normal" type="button" lay-submit="" lay-filter="Cx" id="Cx">查询</button>
                                <button class="layui-btn layui-btn-normal" type="button" lay-submit="" lay-filter="Jlps" id="Jlps">拣料配送</button>
                                <button class="layui-btn layui-btn-normal" type="button" lay-submit="" lay-filter="set_DeleteBill" id="set_DeleteBill">删除</button>
                            </div>
                            <table class="" id="mainTable" lay-filter="mainTable"></table>
                        </div>
@@ -145,17 +145,19 @@
        base: '../../../layuiadmin/' //静态资源所在路径
    }).extend({
        index: 'lib/index' //主入口模块
    }).use(['index', 'form', 'laydate', 'table', 'element'], function () {
    }).use(['index', 'form', 'laydate', 'table', 'element','soulTable'], function () {
        //#region å…¬å…±å˜é‡
        var $ = layui.$
            , admin = layui.admin
            , layer = layui.layer
            , table = layui.table
            , form = layui.form
            , soulTable = layui.soulTable
            , element = layui.element;
        //查询条件
        var sWhere = "";
        var option = [];
        var HModName = "JIT_ComplementGoods";
        //#endregion
        //#region è¿›å…¥é¡µé¢å³åŠ è½½
@@ -217,6 +219,12 @@
            set_Xc();
        })
        //隐藏列设置
        form.on('submit(HideColumn)', function () {
            get_HideColumn();
        })
        //#endregion
        //#region æ­¤é¡µé¢æ‰€æœ‰çš„æ–¹æ³•
@@ -230,6 +238,7 @@
            //时间初始化
            $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd"));
            $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd"));
            DisPlay_HideColumn();
        }
        //获取组织
        function Organ() {
@@ -245,6 +254,7 @@
                            Organization += '<option  style="color:blue;" value="' + data[i].ID + '">' + data[i].Name + '</option>';
                        }
                        $("#Organization").append(Organization);
                        $("#Organization").val(sessionStorage["OrganizationID"]);
                        form.render('select');
                    }
                    layer.closeAll("loading");
@@ -256,30 +266,34 @@
            option = {
                elem: '#mainTable'
                //, toolbar: '#toolbarDemo'
                , height: 'full-190'
                , height: 'full-120'
                , page: true
                , totalRow: true
                , cellMinWidth: 90
                , limit: 50
                , limits: [50, 500, 5000, 20000]
                , done: function (res, curr, count) {
                    soulTable.render(this);
                }
                , cols: [[
                    { type: 'checkbox', fixed: 'left' }
                    , { field: '拣料单日期', title: '拣料单日期', width: 150, templet: "<div>{{d.拣料单日期 ==null ?'':layui.util.toDateString(d.拣料单日期, 'yyyy-MM-dd')}}</div>" }
                    , { field: '拣料配送单号', title: '生产订单号', width: 170 }
                    , { field: '配送人', title: '配送人', width: 170 }
                    , { field: '制单人', title: '制单人', width: 260, }
                    , { field: '制单日期', title: '制单日期', width: 160, templet: "<div>{{d.制单日期 ==null ?'':layui.util.toDateString(d.制单日期, 'yyyy-MM-dd')}}</div>" }
                    , { field: 'HMaterID', title: 'HMaterID', width: 160, hide: true }
                    , { field: '物料代码', title: '物料代码', width: 160 }
                    , { field: '物料名称', title: '物料名称', width: 160 }
                    , { field: '规格型号', title: '规格型号', width: 160 }
                    , { field: '拣料数量', title: '拣料数量', width: 160 }
                    , { field: '已调拨数量', title: '已调拨数量', width: 160 }
                    , { field: '计量单位', title: '计量单位', width: 160 }
                    , { field: '车间', title: '车间', width: 160 }
                    , { field: '工段', title: '工段', width: 160 }
                    , { field: '备注', title: '备注', width: 160 }
                    , { field: '调出仓库', title: '调出仓库', width: 160 }
                    , { field: '调出仓位', title: '调出仓位', width: 160 }
                    , { field: '拣料单日期', title: '拣料单日期', width: 150, templet: "<div>{{d.拣料单日期 ==null ?'':layui.util.toDateString(d.拣料单日期, 'yyyy-MM-dd')}}</div>" ,sort:true}
                    , { field: '拣料配送单号', title: '生产订单号', width: 170 ,sort:true}
                    , { field: '配送人', title: '配送人', width: 170, sort: true}
                    , { field: '制单人', title: '制单人', width: 260,  sort: true}
                , { field: '制单日期', title: '制单日期', width: 160, templet: "<div>{{d.制单日期 ==null ?'':layui.util.toDateString(d.制单日期, 'yyyy-MM-dd')}}</div>", sort: true}
                , { field: 'HMaterID', title: 'HMaterID', width: 160, hide: true, sort: true}
                , { field: '物料代码', title: '物料代码', width: 160, sort: true}
                , { field: '物料名称', title: '物料名称', width: 160, sort: true}
                    , { field: '规格型号', title: '规格型号', width: 160, sort: true}
                    , { field: '拣料数量', title: '拣料数量', totalRow: true,width: 160, sort: true}
                    , { field: '已调拨数量', title: '已调拨数量', totalRow: true, width: 160, sort: true}
                    , { field: '计量单位', title: '计量单位', width: 160, sort: true}
                    , { field: '车间', title: '车间', width: 160, sort: true}
                    , { field: '工段', title: '工段', width: 160, sort: true}
                    , { field: '备注', title: '备注', width: 160, sort: true}
                    , { field: '调出仓库', title: '调出仓库', width: 160, sort: true}
                    , { field: '调出仓位', title: '调出仓位', width: 160, sort: true}
                ]]
            };
        }
@@ -297,7 +311,7 @@
                        option.data = data1.data;
                        table.render(option);
                        layer.close(ajaxLoad);
                        //layer.alert("查询成功", { icon: 1 });
                    } else {
                        layer.close(ajaxLoad);
                        layer.alert(data1.code + data1.Message, { icon: 5 });
@@ -428,6 +442,9 @@
                    , shift: 2//弹出动画
                    , maxmin: true
                    , content: "../../生产管理/拣料配送单/JIT_ComplementGoodsBill.html?hmainid=" + hmainid
                    ,end: function () {
                        get_FastQuery();
                    }
                })
            }
        }
@@ -483,6 +500,7 @@
            var HDeptName = $("#HDeptName").val(); //部门
            var HJLStatus = $("#HJLStatus").val(); //拣料状态
            var user = sessionStorage["HUserName"]; //制单人
            sWhere = {
                MaterialNumber: MaterialNumber,
                MaterialName: MaterialName,
@@ -494,7 +512,7 @@
                HEndDate: HEndDate,
                HDeptName: HDeptName,
                HJLStatus: HJLStatus,
                user: user
                user: user,
            };
            get_Display(JSON.stringify(sWhere));
            sWhere = "";
@@ -580,6 +598,110 @@
            }
        }
        //隐藏列设置
        function get_HideColumn() {
            var colName = "";
            for (var i = 1; i < option.cols[0].length - 1; i++) {
                colName += option.cols[0][i]["title"] + ",";
            }
            colName = encodeURI(colName.substring(0, colName.length - 1));//对 URI è¿›è¡Œç¼–码
            layer.open({
                type: 2
                , skin: "layui-layer-rim" //加上边框
                , title: "隐藏列设置"  //标题
                , closeBtn: 1  //窗体右上角关闭 çš„ æ ·å¼
                , shift: 2 //弹出动画
                , area: ["50%", "90%"] //窗体大小
                , maxmin: true //设置最大最小按钮是否显示
                , content: ['../../基础资料/隐藏列设置/Gy_GridView_Hide.html?HModName=' + HModName + '&colName=' + colName, "yes"]
                , btn: ["确定", "取消"]
                , btn1: function (index, laero) {
                    //刷新表格数据
                    DisPlay_HideColumn();
                    //更新表格缓存的数据
                    layer.close(index);//关闭弹窗
                }
            })
        }
        //显示列数据
        function DisPlay_HideColumn() {
            $.ajax({
                url: GetWEBURL() + '/Xt_grdAlignment_WMES/grdAlignmentWMESList',
                type: "GET",
                data: { "HModName": HModName, "user": sessionStorage["HUserName"] },
                success: function (data1) {
                    if (data1.data.length != 0) {
                        var dataCol = [];//数据库查询出的列数据
                        var titleData = ["HMaterID"];//不需要显示的字段 å¯æ‰©å±•
                        dataCol = data1.data[0].HGridString.split(',');
                        for (var i = 0; i < option.cols[0].length - 2; i++) {
                            var dataCols = dataCol[i].split('|');
                            //隐藏列
                            if (dataCols[1] == 1) {
                                option.cols[0][i + 1]["hide"] = true;
                            }
                            //设置内容字体大小
                            if (data1.data[0].HFontSize != 0) {
                                option.cols[0][i + 1]["style"] = "font-size:" + data1.data[0].HFontSize + "px;";
                            } else {
                                option.cols[0][i + 1]["style"] = "font-size:100%";
                            }
                            //设置列宽
                            if (dataCols[3] > 0) {
                                option.cols[0][i + 1]["width"] = dataCols[3];
                            }
                            //显示列
                            if (dataCols[1] == 0 && $.inArray(option.cols[0][i + 1]["field"], titleData) == -1) {
                                option.cols[0][i + 1]["hide"] = false;
                            }
                            //字体所在位置(å·¦ å±…中 å³)
                            switch (dataCols[2]) {
                                case "L":
                                    option.cols[0][i + 1]["align"] = "left";
                                    break;
                                case "M":
                                    option.cols[0][i + 1]["align"] = "center";
                                    break;
                                case "R":
                                    option.cols[0][i + 1]["align"] = "right";
                                    break;
                            }
                        }
                        //取消冻结列
                        for (var i = 1; i < option.cols[0].length - 1; i++) {
                            if (option.cols[0][i]["fixed"] != null) {
                                option.cols[0][i]["fixed"] = null;
                            }
                            else {
                                break;
                            }
                        }
                        //冻结列
                        if (data1.data[0].HFixCols != 0) {
                            for (var i = 0; i < data1.data[0].HFixCols; i++) {
                                if ($.inArray(option.cols[0][i + 1]["title"], titleData) != -1) {
                                    data1.data[0].HFixCols += 1;
                                }
                                option.cols[0][i + 1]["fixed"] = "left";
                            }
                        }
                        table.render(option);
                    } else {
                        table.render(option);
                    }
                }, error: function () {
                    layer.alert("接口请求失败!", { icon: 5 });
                }
            })
        }
        //#endregion
    });