1
chenhaozhe
2025-07-02 fe50d723e5d050113c4ecc493220e264f39d8e5f
WebTM/views/Éú²ú¹ÜÀí/Èռƻ®±¨±í/ReportMOMaterReadysBillList.html
@@ -12,6 +12,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/xm-select.js"></script>
    <!--<script src="../../../layuiadmin/soulTable.slim.js"></script>--> <!--标题筛选不能引用此js文件-->
</head>
<body>
@@ -48,6 +49,13 @@
                                    </div>
                                </div>
                                <div class="layui-inline">
                                    <label class="layui-form-label">日期间隔</label>
                                    <div class="layui-input-block">
                                        <select name="HInitTimeCycle" id="HInitTimeCycle" class="ForFilteringSchemes" lay-filter="HInitTimeCycle" style="width:190px;">
                                        </select>
                                    </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="date" class="layui-input" lay-verify="HBeginDate" name="HBeginDate" id="HBeginDate" style="padding-left: 58px;width:160px;">
@@ -68,9 +76,12 @@
                                        <div class="layui-inline">
                                            <label class="layui-form-label" style="width: 85px;">组织</label>
                                            <div class="layui-input-block" style="margin-left: 120px; width: 185px;">
                                                <select name="HORGID" id="HORGID" lay-verify="HORGID">
                                                <!--<select name="HORGID" id="HORGID" lay-verify="HORGID">-->
                                                    <!--动态渲染组织-->
                                                </select>
                                                <!--</select>-->
                                                <div id="demo1">
                                                </div>
                                            </div>
                                        </div>
                                        <div class="layui-inline">
@@ -102,88 +113,88 @@
                                            </div>
                                        </div>
                                        <!--<div class="layui-row" style=" margin-top: 10px; margin-left: 70px;">
                                            <div class="layui-inline">
                                                <label class="layui-form-label">过滤</label>
                                                <div class="layui-input-block">
                                                    <select name="ColName" id="ColName" class="ForFilteringSchemes" lay-filter="ColName" style="width:190px;">
                                                    </select>
                                                </div>
                                            </div>
                                            <div class="layui-inline">
                                                <select name="Comparator" id="Comparator" class="ForFilteringSchemes" lay-filter="Comparator" style="width:190px;">
                                                    <option value="0" selected="selected"></option>
                                                    <option value="=">=</option>
                                                    <option value=">=">>=</option>
                                                    <option value=">">></option>
                                                    <option value="<="><=</option>
                                                    <option value="<"><</option>
                                                    <option value="<>"><></option>
                                                    <option value="7">包含</option>
                                                    <option value="8">左包含</option>
                                                    <option value="9">右包含</option>
                                                    <option value="10">不包含</option>
                                                </select>
                                            </div>
                                            <div class="layui-inline">
                                                <input type="text" class="layui-input ForFilteringSchemes" value="" name="ColContent" id="ColContent">
                                            </div>
                                        </div>
                <div class="layui-inline">
                    <label class="layui-form-label">过滤</label>
                    <div class="layui-input-block">
                        <select name="ColName" id="ColName" class="ForFilteringSchemes" lay-filter="ColName" style="width:190px;">
                        </select>
                    </div>
                </div>
                <div class="layui-inline">
                    <select name="Comparator" id="Comparator" class="ForFilteringSchemes" lay-filter="Comparator" style="width:190px;">
                        <option value="0" selected="selected"></option>
                        <option value="=">=</option>
                        <option value=">=">>=</option>
                        <option value=">">></option>
                        <option value="<="><=</option>
                        <option value="<"><</option>
                        <option value="<>"><></option>
                        <option value="7">包含</option>
                        <option value="8">左包含</option>
                        <option value="9">右包含</option>
                        <option value="10">不包含</option>
                    </select>
                </div>
                <div class="layui-inline">
                    <input type="text" class="layui-input ForFilteringSchemes" value="" name="ColContent" id="ColContent">
                </div>
            </div>
                                        <div class="layui-row" style=" margin-top: 10px; margin-left: 70px;">
                                            <div class="layui-inline">
                                                <label class="layui-form-label">过滤</label>
                                                <div class="layui-input-block">
                                                    <select name="ColName1" id="ColName1" class="ForFilteringSchemes" lay-filter="ColName1" style="width:190px;">
                                                    </select>
                                                </div>
                                            </div>
                                            <div class="layui-inline">
                                                <select name="Comparator1" id="Comparator1" class="ForFilteringSchemes" lay-filter="Comparator1" style="width:190px;">
                                                    <option value="0" selected="selected"></option>
                                                    <option value="=">=</option>
                                                    <option value=">=">>=</option>
                                                    <option value=">">></option>
                                                    <option value="<="><=</option>
                                                    <option value="<"><</option>
                                                    <option value="<>"><></option>
                                                    <option value="7">包含</option>
                                                    <option value="8">左包含</option>
                                                    <option value="9">右包含</option>
                                                    <option value="10">不包含</option>
                                                </select>
                                            </div>
                                            <div class="layui-inline">
                                                <input type="text" class="layui-input ForFilteringSchemes" value="" name="ColContent1" id="ColContent1">
                                            </div>
                                        </div>
            <div class="layui-row" style=" margin-top: 10px; margin-left: 70px;">
                <div class="layui-inline">
                    <label class="layui-form-label">过滤</label>
                    <div class="layui-input-block">
                        <select name="ColName1" id="ColName1" class="ForFilteringSchemes" lay-filter="ColName1" style="width:190px;">
                        </select>
                    </div>
                </div>
                <div class="layui-inline">
                    <select name="Comparator1" id="Comparator1" class="ForFilteringSchemes" lay-filter="Comparator1" style="width:190px;">
                        <option value="0" selected="selected"></option>
                        <option value="=">=</option>
                        <option value=">=">>=</option>
                        <option value=">">></option>
                        <option value="<="><=</option>
                        <option value="<"><</option>
                        <option value="<>"><></option>
                        <option value="7">包含</option>
                        <option value="8">左包含</option>
                        <option value="9">右包含</option>
                        <option value="10">不包含</option>
                    </select>
                </div>
                <div class="layui-inline">
                    <input type="text" class="layui-input ForFilteringSchemes" value="" name="ColContent1" id="ColContent1">
                </div>
            </div>
                                        <div class="layui-row" style=" margin-top: 10px; margin-left: 70px;">
                                            <div class="layui-inline">
                                                <label class="layui-form-label">过滤</label>
                                                <div class="layui-input-block">
                                                    <select name="ColName2" id="ColName2" class="ForFilteringSchemes" lay-filter="ColName2" style="width:190px;">
                                                    </select>
                                                </div>
                                            </div>
                                            <div class="layui-inline">
                                                <select name="Comparator2" id="Comparator2" class="ForFilteringSchemes" lay-filter="Comparator2" style="width:190px;">
                                                    <option value="0" selected="selected"></option>
                                                    <option value="=">=</option>
                                                    <option value=">=">>=</option>
                                                    <option value=">">></option>
                                                    <option value="<="><=</option>
                                                    <option value="<"><</option>
                                                    <option value="<>"><></option>
                                                    <option value="7">包含</option>
                                                    <option value="8">左包含</option>
                                                    <option value="9">右包含</option>
                                                    <option value="10">不包含</option>
                                                </select>
                                            </div>
                                            <div class="layui-inline">
                                                <input type="text" class="layui-input ForFilteringSchemes" value="" name="ColContent2" id="ColContent2">
                                            </div>
                                        </div>-->
            <div class="layui-row" style=" margin-top: 10px; margin-left: 70px;">
                <div class="layui-inline">
                    <label class="layui-form-label">过滤</label>
                    <div class="layui-input-block">
                        <select name="ColName2" id="ColName2" class="ForFilteringSchemes" lay-filter="ColName2" style="width:190px;">
                        </select>
                    </div>
                </div>
                <div class="layui-inline">
                    <select name="Comparator2" id="Comparator2" class="ForFilteringSchemes" lay-filter="Comparator2" style="width:190px;">
                        <option value="0" selected="selected"></option>
                        <option value="=">=</option>
                        <option value=">=">>=</option>
                        <option value=">">></option>
                        <option value="<="><=</option>
                        <option value="<"><</option>
                        <option value="<>"><></option>
                        <option value="7">包含</option>
                        <option value="8">左包含</option>
                        <option value="9">右包含</option>
                        <option value="10">不包含</option>
                    </select>
                </div>
                <div class="layui-inline">
                    <input type="text" class="layui-input ForFilteringSchemes" value="" name="ColContent2" id="ColContent2">
                </div>
            </div>-->
                                    </div>
                                </div>
@@ -242,6 +253,26 @@
        //#endregion
        //#region è§¦å‘事件:包括form.on(){}格式的所有点击事件、选择事件等
        //#region æ—¥æœŸé—´éš”下拉列表监听
        form.on('select(HInitTimeCycle)', function (data) {
            var HInitTimeCycle = $("#HInitTimeCycle").val() * 1;
            //若日期间隔不为 ä»»æ„é—´éš”,则禁用开始日期与结束日期的选择
            if (HInitTimeCycle != -1) {
                //$('#HDate').prop('disabled', true);
                //$('#HDate1').prop('disabled', true);
                $("#HBEGINDATE").val(Format(new Date().setDate(new Date().getDate()), "yyyy-MM-dd"));//欠料日期
                $("#HEndDate").val(Format(new Date().setDate(new Date().getDate() + HInitTimeCycle), "yyyy-MM-dd"));//至
                //执行查询方法
                get_FastQuery();
            } else {
                //$('#HDate').prop('disabled', false);
                //$('#HDate1').prop('disabled', false);
            }
        });
            //#endregion
        //#region äº§å“ç¼–码
        form.on('submit(btnHMATERIALID)', function (data) {
@@ -416,9 +447,13 @@
        //#region åˆå§‹åŒ–界面
        function set_ClearBill() {
            //初始化日期间隔、开始日期、结束日期
            setSelect_HInitTimeCycle();
            //若日期间隔不为 ä»»æ„é—´éš”,则禁用开始日期与结束日期的选择
            var HInitTimeCycle = $("#HInitTimeCycle").val() * 1;
            //初始化日期
            $("#HBeginDate").val(Format(new Date(new Date()), "yyyy-MM-dd"));//提料日期
            $("#HEndDate").val(Format(new Date($("#HBeginDate").val()).setDate(new Date($("#HBeginDate").val()).getDate() + 7), "yyyy-MM-dd"));//至
            $("#HEndDate").val(Format(new Date().setDate(new Date().getDate() + HInitTimeCycle), "yyyy-MM-dd"));//至
            //生产组织加载
            Organ();
            //初始化表格
@@ -438,8 +473,9 @@
                , page: true
                , cellMinWidth: 90
                , totalRow: true
                , limit: 1000
                , limits: [50, 500,1000, 5000, 20000]
                , limit: 50
                , limits: [50, 500, 1000, 5000]
                , title:"齐套报表"
                //, loading: false               
                , cols: [[
                    { type: 'checkbox', fixed: 'left' }
@@ -458,8 +494,12 @@
                    , { field: '日计划数量', title: '日计划数量', sort: true, totalRow: true, filter: true }
                    , { field: '物料编码', title: '物料编码', sort: true, filter: true  }
                    , { field: '物料名称', title: '物料名称', sort: true, filter: true  }
                    , { field: '物料规格型号', title: '物料规格型号', sort: true, filter: true  }
                    , { field: '物料属性', title: '物料属性', sort: true, filter: true  }
                    , { field: '物料规格型号', title: '物料规格型号', sort: true, filter: true }
                    , { field: '单位用量', title: '单位用量', sort: true, filter: true }
                    , { field: '供货车间代码', title: '供货车间代码', sort: true, filter: true }
                    , { field: '供货车间', title: '供货车间', sort: true, filter: true }
                    , { field: '物料属性', title: '物料属性', sort: true, filter: true }
                    , { field: '仓库名称', title: '仓库名称', sort: true, filter: true }
                    , { field: '计划发料数量', title: '计划发料数量', sort: true, totalRow: true, filter: true  }
                    , { field: '齐套数量', title: '齐套数量', sort: true, totalRow: true, filter: true }
                    , { field: '缺料数量', title: '缺料数量', sort: true, totalRow: true, filter: true  }
@@ -480,22 +520,34 @@
        function Organ() {
            //获取登录页组织列
            var Organization = '';
            var selectDataList = [];
            $.ajax({
                type: "get",
                url: GetWEBURL() + "/Web/GetOrganizations",
                async: false,
                success: function (result) {
                    if (result.count == 1) { // è¯´æ˜ŽéªŒè¯æˆåŠŸäº†ï¼Œ
                        var data = result.data;
                        for (var i = 0; i < data.length; i++) {
                            Organization += '<option  style="color:blue;" value="' + data[i].ID + '">' + data[i].Name + '</option>';
                            /*Organization += '<option  style="color:blue;" value="' + data[i].ID + '">' + data[i].Name + '</option>';*/
                            //下拉多选框数据初始化
                            var selectData = { name: data[i].Name, value: data[i].ID };
                            selectDataList.push(selectData);
                        }
                        $("#HORGID").append(Organization);
                        $("#HORGID").val(sessionStorage["OrganizationID"])
                        //$("#HORGID").append(Organization);
                        //$("#HORGID").val(sessionStorage["OrganizationID"]);
                        var demo1 = xmSelect.render({
                            el: '#demo1',
                            language: 'zn',
                            /*initValue: [sessionStorage["OrganizationID"]],*///默认选项
                            data: selectDataList
                        })
                        form.render('select');
                    }
                    layer.closeAll("loading");
                }
            })
        }
        //#region æŸ¥è¯¢
@@ -530,7 +582,14 @@
        function getExportData() {
            var data;//导出的数据
            var ajaxLoad = layer.load();
            var HORGID = $("#HORGID").val();//组织
            var HORGID = "";//组织
            var xmList = xmSelect.get('#demo1', true);//获取选择框实例
            var xmValueStr = xmList.getValue("valueStr")//获取值字符串
            if (xmValueStr == "") {
                HORGID = "'0'"//没选择组织则全部组织
            } else {
                HORGID = "'" + xmValueStr + "'"
            }
            var HMATERIALID = $("#HMATERIALID").val();//物料/产品
            var HDeptID = $("#HDeptID").val();//生产车间
            var HSCZYID = $("#HSCZYID").val();//生产资源
@@ -540,80 +599,6 @@
            var HEndDate = $("#HEndDate").val();//至
            var HMaterAtt = $("#HMaterAtt").val();//物料属性
            
            var ColName = $("#ColName").val();//复选框
            var Comparator = $("#Comparator").val()
            var ColContent = $("#ColContent").val();
            var ColName1 = $("#ColName1").val();//复选框
            var Comparator1 = $("#Comparator1").val()
            var ColContent1 = $("#ColContent1").val();
            var ColName2 = $("#ColName2").val();//复选框
            var Comparator2 = $("#Comparator2").val()
            var ColContent2 = $("#ColContent2").val();
            if (ColName != 0 && Comparator != 0) {
                var com = "";
                switch (Comparator) {
                    case "7":
                        com = "like'%" + ColContent + "%'";
                        break;
                    case "8":
                        com = "like'%" + ColContent + "'";
                        break;
                    case "9":
                        com = "like'" + ColContent + "%'";
                        break;
                    case "10":
                        com = "not like'%" + ColContent + "%'";
                        break;
                    default:
                        com = "" + Comparator + "'" + ColContent + "'";
                        break;
                }
                sWhere += " and " + ColName + " " + com;
            }
            if (ColName1 != 0 && Comparator1 != 0) {
                var com1 = "";
                switch (Comparator1) {
                    case "7":
                        com1 = "like'%" + ColContent1 + "%'";
                        break;
                    case "8":
                        com1 = "like'%" + ColContent1 + "'";
                        break;
                    case "9":
                        com1 = "like'" + ColContent1 + "%'";
                        break;
                    case "10":
                        com1 = "not like'%" + ColContent1 + "%'";
                        break;
                    default:
                        com1 = "" + Comparator1 + "'" + ColContent1 + "'";
                        break;
                }
                sWhere += " and " + ColName1 + " " + com1;
            }
            if (ColName2 != 0 && Comparator2 != 0) {
                var com2 = "";
                switch (Comparator2) {
                    case "7":
                        com2 = "like'%" + ColContent2 + "%'";
                        break;
                    case "8":
                        com2 = "like'%" + ColContent2 + "'";
                        break;
                    case "9":
                        com2 = "like'" + ColContent2 + "%'";
                        break;
                    case "10":
                        com2 = "not like'%" + ColContent2 + "%'";
                        break;
                    default:
                        com2 = "" + Comparator + "'" + ColContent + "'";
                        break;
                }
                sWhere += " and " + ColName2 + " " + com2;
            }
            if (HBeginDate > HEndDate) {
                layer.close(ajaxLoad);
@@ -650,7 +635,14 @@
                                    item[itemobj] = "";
                                }
                                if (item[itemobj].length > 0) {  // å‡è®¾å­—段名为field
                                    item[itemobj] = item[itemobj].toString().replaceAll(/[\r\n]+/g, '');  // å°†æ¢è¡Œç¬¦æ›¿æ¢ä¸ºç©ºå­—符串
                                    item[itemobj] = item[itemobj].toString().replace(/[\r\n]+/g, '');  // å°†æ¢è¡Œç¬¦æ›¿æ¢ä¸ºç©ºå­—符串
                                    item[itemobj] = item[itemobj].toString().replace(/,/g, '');  // å°†æ¢è¡Œç¬¦æ›¿æ¢ä¸ºç©ºå­—符串
                                }
                                if (itemobj == "订单交期") {
                                    item[itemobj] = item[itemobj].toString().split('T')[0];
                                }
                                if (itemobj == "日计划日期") {
                                    item[itemobj] = item[itemobj].toString().split('T')[0];
                                }
                            }
                        });
@@ -675,11 +667,18 @@
        //#region å¿«é€Ÿè¿‡æ»¤
        function get_FastQuery(number) {
            var HORGID = "";
            if (number == 1) {
                HORGID = sessionStorage["OrganizationID"];
            }
            else {
                HORGID = $("#HORGID").val();//组织
            //if (number == 1) {
            //    HORGID = sessionStorage["OrganizationID"];
            //}
            //else {
            //    HORGID = $("#HORGID").val();//组织
            //}
            var xmList = xmSelect.get('#demo1', true);//获取选择框实例
            var xmValueStr = xmList.getValue("valueStr")//获取值字符串
            if (xmValueStr == "") {
                HORGID = "'0'"
            } else {
                HORGID = "'" + xmValueStr + "'"
            }
            var HMATERIALID = $("#HMATERIALID").val();//物料/产品
            var HDeptID = $("#HDeptID").val();//生产车间
@@ -689,81 +688,6 @@
            var HBeginDate = $("#HBeginDate").val();//提料日期
            var HEndDate = $("#HEndDate").val();//至
            var HMaterAtt = $("#HMaterAtt").val();//物料属性
            var ColName = $("#ColName").val();//复选框
            var Comparator = $("#Comparator").val()
            var ColContent = $("#ColContent").val();
            var ColName1 = $("#ColName1").val();//复选框
            var Comparator1 = $("#Comparator1").val()
            var ColContent1 = $("#ColContent1").val();
            var ColName2 = $("#ColName2").val();//复选框
            var Comparator2 = $("#Comparator2").val()
            var ColContent2 = $("#ColContent2").val();
            if (ColName != 0 && Comparator != 0) {
                var com = "";
                switch (Comparator) {
                    case "7":
                        com = "like'%" + ColContent + "%'";
                        break;
                    case "8":
                        com = "like'%" + ColContent + "'";
                        break;
                    case "9":
                        com = "like'" + ColContent + "%'";
                        break;
                    case "10":
                        com = "not like'%" + ColContent + "%'";
                        break;
                    default:
                        com = "" + Comparator + "'" + ColContent + "'";
                        break;
                }
                sWhere += " and " + ColName + " " + com;
            }
            if (ColName1 != 0 && Comparator1 != 0) {
                var com1 = "";
                switch (Comparator1) {
                    case "7":
                        com1 = "like'%" + ColContent1 + "%'";
                        break;
                    case "8":
                        com1 = "like'%" + ColContent1 + "'";
                        break;
                    case "9":
                        com1 = "like'" + ColContent1 + "%'";
                        break;
                    case "10":
                        com1 = "not like'%" + ColContent1 + "%'";
                        break;
                    default:
                        com1 = "" + Comparator1 + "'" + ColContent1 + "'";
                        break;
                }
                sWhere += " and " + ColName1 + " " + com1;
            }
            if (ColName2 != 0 && Comparator2 != 0) {
                var com2 = "";
                switch (Comparator2) {
                    case "7":
                        com2 = "like'%" + ColContent2 + "%'";
                        break;
                    case "8":
                        com2 = "like'%" + ColContent2 + "'";
                        break;
                    case "9":
                        com2 = "like'" + ColContent2 + "%'";
                        break;
                    case "10":
                        com2 = "not like'%" + ColContent2 + "%'";
                        break;
                    default:
                        com2 = "" + Comparator + "'" + ColContent + "'";
                        break;
                }
                sWhere += " and " + ColName2 + " " + com2;
            }
            if (HBeginDate > HEndDate) {
                return layer.msg("开始日期不能小于结束日期!");
@@ -791,7 +715,7 @@
        //#region é‡ç½®è¿‡æ»¤æ¡ä»¶æ–¹æ³•
        function set_ClearQuery() {
            $("#HORGID").val(sessionStorage["OrganizationID"]);//组织
            $("#HMATERIALID").val(0);//物料/产品
            $("#HMATERIALNAME").val("");
            $("#HDeptID").val(0);//生产车间
@@ -800,17 +724,8 @@
            $("#HSCZYName").val("");
            $("#HXQD").val("");//需求单号
            $("#HMOBILLNO").val("");//生产订单号
            $("#ColContent").val("");
            $("#ColName").val("0");
            $("#Comparator").val("0");
            $("#ColContent1").val("");
            $("#ColName1").val("0");
            $("#Comparator1").val("0");
            $("#ColContent2").val("");
            $("#ColName2").val("0");
            $("#Comparator2").val("0");
            $("#HBeginDate").val(Format(new Date(new Date()), "yyyy-MM-dd"));//提料日期
            $("#HEndDate").val(Format(new Date($("#HBeginDate").val()).setDate(new Date($("#HBeginDate").val()).getDate() + 7), "yyyy-MM-dd"));//至
            $("#HEndDate").val(Format(new Date($("#HBeginDate").val()).setDate(new Date($("#HBeginDate").val()).getDate() + 30), "yyyy-MM-dd"));//至
            $("#HMaterAtt").val("");
            form.render('select');
            sWhere = "";
@@ -909,6 +824,24 @@
            form.render('select');
        }
        //#region åˆå§‹æ—¥æœŸé—´éš” ä¸‹æ‹‰åˆ—表
        function setSelect_HInitTimeCycle() {
            var valueList = [7,30, 45, 60];
            var titleList = ["近7天","近一月", "近45天", "近60天"];
            var HInitTimeCycle_ArrayList = '<option  value="-1" selected="selected" >任意间隔</option>';
            for (var i = 0; i < valueList.length; i++) {
                HInitTimeCycle_ArrayList += '<option  style="color:blue;" value="' + valueList[i] + '">' + titleList[i] + '</option>';
            }
            $("#HInitTimeCycle").empty();
            $("#HInitTimeCycle").append(HInitTimeCycle_ArrayList);
            form.render('select');
            $("#HInitTimeCycle").val("30");
        }
            //#endregion
        //#region éšè—åˆ—设置
        function get_HideColumn() {
            var colName = "";