1
duhe
2025-09-04 57e698ff50b2dbd3ca9bb73932fba21dfe828e9a
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>
@@ -75,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">
@@ -470,7 +474,8 @@
                , cellMinWidth: 90
                , totalRow: true
                , limit: 50
                , limits: [50, 500,1000, 5000]
                , limits: [50, 500, 1000, 5000]
                , title:"齐套报表"
                //, loading: false               
                , cols: [[
                    { type: 'checkbox', fixed: 'left' }
@@ -493,7 +498,8 @@
                    , { 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  }
@@ -514,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 æŸ¥è¯¢
@@ -564,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();//生产资源
@@ -574,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);
@@ -687,6 +638,12 @@
                                    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];
                                }
                            }
                        });
@@ -710,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();//生产车间
@@ -724,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("开始日期不能小于结束日期!");
@@ -826,7 +715,7 @@
        //#region é‡ç½®è¿‡æ»¤æ¡ä»¶æ–¹æ³•
        function set_ClearQuery() {
            $("#HORGID").val(sessionStorage["OrganizationID"]);//组织
            $("#HMATERIALID").val(0);//物料/产品
            $("#HMATERIALNAME").val("");
            $("#HDeptID").val(0);//生产车间
@@ -835,15 +724,6 @@
            $("#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() + 30), "yyyy-MM-dd"));//至
            $("#HMaterAtt").val("");