wtt
昨天 581556dfd901c43a27f1ec85f4cb8bc37b392bef
WebTM/views/Éú²ú¹ÜÀí/Èռƻ®±¨±í/ReportMOMaterReadysBillList.html
@@ -5,13 +5,14 @@
    <title>齐套报表</title>
    <link rel="stylesheet" href="../../../layuiadmin/layui/css/layui.css" media="all">
    <link rel="stylesheet" href="../../../layuiadmin/style/admin.css" media="all">
    <link rel="stylesheet" href="../../../layuiadmin/ext/soulTable.css" media="all">
    <script src="../../../layuiadmin/zgqCustom/zgqCustom.js"></script>
    <script src="../../../layuiadmin/layui/layui.js"></script>
    <script src="../../../layuiadmin/Scripts/json2.js"></script>
    <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>
    <!--<script src="../../../layuiadmin/soulTable.slim.js"></script>--> <!--标题筛选不能引用此js文件-->
</head>
<body>
    <div class="layui-fluid">
@@ -24,14 +25,6 @@
                                <div class="layui-colla-title layui-inline">
                                    <div class="layui-inline">
                                        <span>更多</span>
                                    </div>
                                </div>
                                <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>
                                    </div>
                                </div>
                                <div class="layui-inline">
@@ -48,17 +41,45 @@
                                    <label class="layui-form-label" style="width: 85px;padding: 9px 18px;">生产车间</label>
                                    <div class="layui-input-block" style="margin-left: 77px;">
                                        <input type="hidden" class="layui-input" lay-verify="HDeptID" name="HDeptID" id="HDeptID" value="0" style="background-color:#efefef4d;width: 60%;display: inline-block;" readonly>
                                        <input type="text" class="layui-input" lay-verify="DeptNAME" name="DeptNAME" id="DeptNAME" value="" style="background-color:#efefef4d;width: 60%;display: inline-block;" readonly>
                                        <input type="text" class="layui-input" lay-verify="DeptNAME" name="DeptNAME" id="DeptNAME" value="" style="width: 60%;display: inline-block;">
                                        <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnHDeptID" id="btnHDeptID" 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">日期间隔</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;">
                                    </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="HEndDate" name="HEndDate" id="HEndDate" style="padding-left: 58px;width:160px;">
                                    </div>
                                </div>
                                <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch">查询</button>
                                <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnReSearch" id="btnReSearch">重置</button>
                                <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnExport" id="btnExport">导出</button>
                                <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="bthHideColumn" id="bthHideColumn">列设置</button>
                                <div class="layui-colla-content" style="padding: 0px; margin-left: 6%;">
                                    <div class="layui-row" style="margin: 10px 0 10px;">
                                        <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>
                                            </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;">
@@ -81,89 +102,95 @@
                                                <input type="text" class="layui-input" name="HMOBILLNO" id="HMOBILLNO">
                                            </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 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="HMaterAtt" id="HMaterAtt">
                                            </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-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>
@@ -181,10 +208,18 @@
    var treeCkData = { id: 0 };
    var TagId = "";
    var TagParentId = "";
    //#region æ–‡æœ¬æ¡†è¾“入搜索相关数据-变量
    var childPage = null;                       //获取子窗口对象,用于操作子窗口的变量和方法
    var currRowIndex = 0;                       //用于定位子窗口当前选中的行
    var childData = null;                       //用于获取子窗口返回的数据
    //#endregion
    layui.config({
        base: '../../../layuiadmin/' //静态资源所在路径
    }).extend({
        index: 'lib/index', //主入口模块
        index: 'lib/index', //主入口模块
        soulTable: '../ext/soulTable'
    }).use(['tree', 'index', 'form', 'table', 'element', 'laypage', 'laydate', 'util','soulTable'], function () {
        //#region å…¬ç”¨å˜é‡
        var $ = layui.$
@@ -202,6 +237,8 @@
        var sWhere = "";
        var option = [];
        var ins;                        //用于导出excel
        var HModName = "ReportMOMaterReadysBillList";
        var titleData = [];
        //#endregion
        //#region è¿›å…¥é¡µé¢å³åŠ è½½
@@ -212,6 +249,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) {
@@ -249,12 +306,150 @@
        });
        //#endregion
        //#region åˆ—设置按钮
        form.on('submit(bthHideColumn)', function (data) {
            get_HideColumn();
        });
        //#endregion
        //#region æ–‡æœ¬æ¡†ç›‘听
        $(document).ready(function () {
            //#region æ ¹æ®ç‰©æ–™ä»£ç èŽ·å–ç‰©æ–™åŸºç¡€èµ„æ–™ç­›é€‰å¼¹çª—
            //根据元素ID对元素进行监听=============================================================================
            $("#DeptNAME").on('keydown', function (data) {
                //================================================================================================
                var errKeys = ["ArrowUp", "ArrowDown", "ArrowLeft", "ArrowRight", "Enter"];
                if ($.inArray(event.key, errKeys) == -1) {              //如果按下的键位不是 æ–¹å‘键,则刷新弹窗中的数据
                    if (childPage == null) {                            //判断当前子窗口是否已经打开,若未打卡,则打开页面,并获取子窗口的对象
                        var offset = $(this).offset();                  //获取触发事件的元素的位置,用于定位子窗口打开的位置
                        var innerHeight = window.innerHeight;
                        var top = offset.top + 0.05 * innerHeight;
                        var left = offset.left;
                        if (top + 0.05 * innerHeight + 0.3 * innerHeight > innerHeight) {
                            top = top - 0.3 * innerHeight - 0.05 * innerHeight;
                        }
                        layer.open({
                            type: 2                                                                                     //弹窗类型
                            , skin: 'layui-layer-rim'                                                                   //加上边框
                            , area: ['25%', '30%']                                                                      //大小
                            , shadeClose: true                                                                          //点击遮罩时关闭弹窗
                            , offset: [top, left]
                            , title: false                                                                              //不显示标题栏
                            //, title: '项目费用列表'                                                                     //标题
                            , shift: 2                                                                                  //弹出动画
                            , closeBtn: 0                                                                               //禁用关闭按钮
                            , content: ["../../基础资料/通用基础资料/Gy_CommonBaseDataCheck.html?OperationType=2", "yes"]
                            , btn: ['确定', '取消']
                            , btn1: function (index, layero) {//按钮【按钮一】的回调
                                var iframeWindow = window['layui-layer-iframe' + index]  //获取弹框页面
                                var checkStatus = iframeWindow.layui.table.checkStatus('mainTable');//获取table的elem:"#test"
                                if (checkStatus.data.length === 0) {
                                    return layer.msg('请选择数据');
                                }
                                var HIDValue = "";
                                var HNameValue = "";
                                for (var i = 0; i < checkStatus.data.length; i++) {
                                    HIDValue += checkStatus.data[i].HItemID + ",";
                                    HNameValue += checkStatus.data[i].部门名称 + ",";
                                }
                                //去除末尾逗号
                                HIDValue = HIDValue.substring(0, HIDValue.length - 1);
                                HNameValue = HNameValue.substring(0, HNameValue.length - 1);
                                $("#HDeptID").val(HIDValue);
                                $("#DeptNAME").val(HNameValue);
                                //获取数据
                                layer.close(index); //它获取的始终是最新弹出的某个层,值是由layer内部动态递增计算的
                            }
                            , btn2: function (index, layero) { }
                            , success: function (layero, index) {
                                setTimeout(function () {
                                    //修改,根据文本框数据,编写查询语句================================================================================================
                                    var value = $("#DeptNAME").val().replace(/'/g, "");                                  //获取文本框最新值
                                    currRowIndex = 0;
                                    var tableView = "h_v_Gy_DepartmentList";
                                    var childSWhere = "select top(10) HItemID,部门代码,部门名称 from " + tableView + " where 1=1 and ç»„织名称 = '" + sessionStorage["Organization"] + "' and (部门代码 like '%" + value + "%' or éƒ¨é—¨åç§° like '%" + value + "%') order by éƒ¨é—¨ä»£ç  desc";
                                    childPage.getData(childSWhere, tableView);
                                    //===================================================================================================================================
                                }, 200);
                            }
                            , end: function () {
                                childPage = null;
                                currRowIndex = 0;
                                if (childData != null) {
                                    //根据弹窗返回数据设置文本框数据=================================================================================================
                                    //获取数据
                                    $("#HDeptID").val(childData.HItemID);//车间id
                                    $("#DeptNAME").val(childData.部门名称);//车间名称
                                    //===============================================================================================================================
                                    childData = null;
                                }
                            }
                        });
                    } else {
                        setTimeout(function () {
                            //修改,根据文本框数据,编写查询语句================================================================================================
                            var value = $("#DeptNAME").val().replace(/'/g, "");                                  //获取文本框最新值
                            currRowIndex = 0;
                            var tableView = "h_v_Gy_DepartmentList";
                            var childSWhere = "select top(10) HItemID,部门代码,部门名称 from " + tableView + " where 1=1 and ç»„织名称 = '" + sessionStorage["Organization"] + "' and (部门代码 like '%" + value + "%' or éƒ¨é—¨åç§° like '%" + value + "%') order by éƒ¨é—¨ä»£ç  desc";
                            childPage.getData(childSWhere, tableView);
                            //=================================================================================================================================
                        }, 200);
                    }
                } else {                                                    //如果按下的键位是 æ–¹å‘键,则调整窗口中 é€‰ä¸­è¡Œ çš„位置
                    if (event.key == "ArrowUp") {
                        currRowIndex--;
                        childPage.setSelectedRow(currRowIndex);
                    } else if (event.key == "ArrowDown") {
                        currRowIndex++;
                        childPage.setSelectedRow(currRowIndex);
                    } else if (event.key == "Enter") {
                        //手动失焦
                        var element = document.getElementById("HMaterNumber");
                        element.blur();
                        childPage.getSelectedData(currRowIndex);
                        if (childData != null) {
                            //根据弹窗返回数据设置文本框数据=================================================================================================
                            //获取数据
                            $("#HDeptID").val(childData.HItemID);//车间id
                            $("#DeptNAME").val(childData.部门名称);//车间名称
                            //===============================================================================================================================
                            childData = null;
                        }
                        childPage = null;
                        currRowIndex = 0;
                        childData = null;
                    }
                }
            });
            //#endregion
        });
        //#endregion
        //#endregion
        //#region æœ¬é¡µé¢è¢«è°ƒç”¨çš„æ‰€æœ‰æ–¹æ³•
        //#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().setDate(new Date().getDate() + HInitTimeCycle), "yyyy-MM-dd"));//至
            //生产组织加载
            Organ();
            //初始化表格
@@ -276,36 +471,41 @@
                , totalRow: true
                , limit: 1000
                , limits: [50, 500,1000, 5000, 20000]
                , loading: false
                //, loading: false
                , cols: [[
                    { type: 'checkbox', fixed: 'left' }
                    , { field: '组织名称', title: '组织名称', width: 120, sort: true, filter: true }
                    , { field: '生产车间名称', title: '生产车间名称', sort: true, filter: true  }
                    , { field: '生产资源名称', title: '生产资源名称', width: 100, sort: true, filter: true }
                    , { field: '生产订单号', title: '生产订单号', sort: true, filter: true }
                    , { field: '客户订单号', title: '客户订单号', sort: true, filter: true }
                    , { field: '销售订单号', title: '销售订单号', sort: true, filter: true  }
                    , { field: 'FCOLUMN9', title: '电压/功率/底板', sort: true, filter: true }
                    , { field: '订单交期', title: '订单交期', templet: "<div>{{d.订单交期 ==null ?'':layui.util.toDateString(d.订单交期, 'yyyy-MM-dd')}}</div>", sort: true, filter: { type: 'date[yyyy-MM-dd HH:mm:ss]' } }
                    , { field: '产品编码', title: '产品编码', sort: true, filter: true  }
                    , { field: '产品名称', title: '产品名称', sort: true, filter: true  }
                    , { field: '产品规格型号', title: '产品规格型号', sort: true, filter: true }
                    , { field: '日计划日期', title: '日计划日期', templet: "<div>{{d.日计划日期 ==null ?'':layui.util.toDateString(d.日计划日期, 'yyyy-MM-dd')}}</div>", sort: true, filter: { type: 'date[yyyy-MM-dd HH:mm:ss]' } }
                    , { 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, totalRow: 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  }
                    , { field: '即时库存数量', title: '即时库存数量', sort: true, totalRow: true, filter: true  }
                    , { field: '占用数量', title: '占用数量', sort: true, totalRow: true, filter: true  }
                    , { field: '领用占用数量', title: '领用占用数量', sort: true, totalRow: true, filter: true }
                    , { field: '有无采购订单', title: '有无采购订单', sort: true, filter: true  }
                ]]
                , done: function (res, curr, count) {
                    soulTable.render(this);
                }
                , cols: [[
                    { type: 'checkbox', fixed: 'left' }
                    , { field: '组织名称', title: '组织名称', width: 120, sort: true }
                    , { field: '生产车间名称', title: '生产车间名称', sort: true }
                    , { field: '生产资源名称', title: '生产资源名称', width: 100, sort: true }
                    , { field: '生产订单号', title: '生产订单号', sort: true }
                    , { field: '销售订单号', title: '销售订单号', sort: true }
                    , { field: 'FCOLUMN9', title: '电压/功率/底板', sort: true }
                    , { field: '订单交期', title: '订单交期', templet: "<div>{{d.订单交期 ==null ?'':layui.util.toDateString(d.订单交期, 'yyyy-MM-dd')}}</div>", sort: true }
                    , { field: '产品编码', title: '产品编码', sort: true }
                    , { field: '产品名称', title: '产品名称', sort: true }
                    , { field: '产品规格型号', title: '产品规格型号', sort: true }
                    , { field: '日计划日期', title: '日计划日期', templet: "<div>{{d.日计划日期 ==null ?'':layui.util.toDateString(d.日计划日期, 'yyyy-MM-dd')}}</div>", sort: true }
                    , { field: '日计划数量', title: '日计划数量', sort: true, totalRow: true}
                    , { field: '物料编码', title: '物料编码', sort: true }
                    , { field: '物料名称', title: '物料名称', sort: true }
                    , { field: '物料规格型号', title: '物料规格型号', sort: true }
                    , { field: '计划发料数量', title: '计划发料数量', sort: true, totalRow: true }
                    , { field: '齐套数量', title: '齐套数量', sort: true, totalRow: true}
                    , { field: '缺料数量', title: '缺料数量', sort: true, totalRow: true }
                    , { field: '可用数量', title: '可用数量', sort: true, totalRow: true }
                    , { field: '即时库存数量', title: '即时库存数量', sort: true, totalRow: true }
                    , { field: '占用数量', title: '占用数量', sort: true, totalRow: true }
                    , { field: '领用占用数量', title: '领用占用数量', sort: true, totalRow: true}
                    , { field: '有无采购订单', title: '有无采购订单', sort: true }
                ]]
            };
        }
        //#endregion
@@ -338,11 +538,14 @@
            $.ajax({
                url: GetWEBURL() + '/JIT_Complete/ReportMOMaterReadysBillList',
                type: "GET",
                data: { "sWhere": sWhere },//, "user": sessionStorage["HUserName"]
                data: { "sWhere": sWhere, "user": sessionStorage["HUserName"]  },//, "user": sessionStorage["HUserName"]
                success: function (result) {
                    if (result.count == 1) {
                        option.data = result.data;
                        table.render(option);
                        //刷新表格数据
                        DisPlay_HideColumn();
                        layer.close(ajaxLoad);
                    } else {
                        layer.close(ajaxLoad);
@@ -367,7 +570,10 @@
            var HSCZYID = $("#HSCZYID").val();//生产资源
            var HXQD = $("#HXQD").val();//需求单号
            var HMOBILLNO = $("#HMOBILLNO").val();//生产订单号
            var HBeginDate = $("#HBeginDate").val();//提料日期
            var HEndDate = $("#HEndDate").val();//至
            var HMaterAtt = $("#HMaterAtt").val();//物料属性
            var ColName = $("#ColName").val();//复选框
            var Comparator = $("#Comparator").val()
            var ColContent = $("#ColContent").val();
@@ -442,6 +648,16 @@
                }
                sWhere += " and " + ColName2 + " " + com2;
            }
            if (HBeginDate > HEndDate) {
                layer.close(ajaxLoad);
                return layer.msg("开始日期不能小于结束日期!");
            }
            if (HBeginDate != null && HEndDate != null) {
                sWhere += " and HDate between ''" + HBeginDate + "'' and ''" + HEndDate + "'' ";
            }
            sWhere = {
                HORGID: HORGID
                , HMATERIALID: HMATERIALID
@@ -449,18 +665,18 @@
                , HSCZYID: HSCZYID
                , HXQD: HXQD
                , HMOBILLNO: HMOBILLNO
                , HBeginDate: HBeginDate
                , HEndDate: HEndDate
                , HMaterAtt: HMaterAtt
            }
            $.ajax({
                url: GetWEBURL() + '/JIT_Complete/ReportMOMaterReadysBillList',
                type: "GET",
                data: { "sWhere": JSON.stringify(sWhere) },//, "user": sessionStorage["HUserName"]
                data: { "sWhere": JSON.stringify(sWhere), "user": sessionStorage["HUserName"]  },//, "user": sessionStorage["HUserName"]
                success: function (result) {
                    if (result.count == 1) {
                        data = result.data;
                        option.data = data;
                        ins = table.render(option);
                        data.forEach((item) => {
                            for (let itemobj in item) {
@@ -469,11 +685,12 @@
                                }
                                if (item[itemobj].length > 0) {  // å‡è®¾å­—段名为field
                                    item[itemobj] = item[itemobj].toString().replace(/[\r\n]+/g, '');  // å°†æ¢è¡Œç¬¦æ›¿æ¢ä¸ºç©ºå­—符串
                                    item[itemobj] = item[itemobj].toString().replace(/,/g, '');  // å°†æ¢è¡Œç¬¦æ›¿æ¢ä¸ºç©ºå­—符串
                                }
                            }
                        });
                        table.exportFile(ins.config.id, data, "xls");
                        table.exportFile('mainTable', data, "xls");
                        layer.close(ajaxLoad);
                    } else {
@@ -504,6 +721,9 @@
            var HSCZYID = $("#HSCZYID").val();//生产资源
            var HXQD = $("#HXQD").val();//需求单号
            var HMOBILLNO = $("#HMOBILLNO").val();//生产订单号
            var HBeginDate = $("#HBeginDate").val();//提料日期
            var HEndDate = $("#HEndDate").val();//至
            var HMaterAtt = $("#HMaterAtt").val();//物料属性
            var ColName = $("#ColName").val();//复选框
            var Comparator = $("#Comparator").val()
@@ -579,6 +799,15 @@
                }
                sWhere += " and " + ColName2 + " " + com2;
            }
            if (HBeginDate > HEndDate) {
                return layer.msg("开始日期不能小于结束日期!");
            }
            if (HBeginDate != null && HEndDate != null) {
                sWhere += " and HDate between ''" + HBeginDate + "'' and ''" + HEndDate + "'' ";
            }
            sWhere = {
                HORGID: HORGID
                , HMATERIALID: HMATERIALID
@@ -586,6 +815,9 @@
                , HSCZYID: HSCZYID
                , HXQD: HXQD
                , HMOBILLNO: HMOBILLNO
                , HBeginDate: HBeginDate
                , HEndDate: HEndDate
                , HMaterAtt: HMaterAtt
            }
            get_Display(JSON.stringify(sWhere));
            sWhere = "";//调用接口后清空sWhere缓存
@@ -612,6 +844,9 @@
            $("#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("");
            form.render('select');
            sWhere = "";
        }
@@ -709,6 +944,157 @@
            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 = "";
            var contentUrl = "";
            for (var i = 1; i < option.cols[0].length; i++) {
                colName += option.cols[0][i]["field"] + ",";
            }
            var urlStr = window.document.location.pathname;//获取文件路径
            var urlLen = urlStr.split('/');
            for (var i = 0; i < urlLen.length - 4; i++) {
                contentUrl += "../";
            }
            colName = encodeURI(colName.substring(0, colName.length - 1));//对 URI è¿›è¡Œç¼–码
            contentUrl += '基础资料/隐藏列设置/Gy_GridView_Hide_New.html?HModName=' + HModName + '&colName=' + colName;
            layer.open({
                type: 2
                , skin: "layui-layer-rim" //加上边框
                , title: "隐藏列设置"  //标题
                , closeBtn: 1  //窗体右上角关闭 çš„ æ ·å¼
                , shift: 2 //弹出动画
                , area: ["50%", "90%"] //窗体大小
                , maxmin: true //设置最大最小按钮是否显示
                , content: [contentUrl, "yes"]
                , btn: ["确定", "取消"]
                , btn1: function (index, laero) {
                    //刷新表格数据
                    DisPlay_HideColumn();
                    //更新表格缓存的数据
                    layer.close(index);//关闭弹窗
                }
            })
        }
        //#endregion
        //#region æ˜¾ç¤ºåˆ—数据
        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) {
                        titleData = [];
                        var dataCol = [];//数据库查询出的列数据
                        var newCols = [[]];//对应数据库列顺序col
                        newCols[0].push(option.cols[0][0]);//放入第一个checkbox
                        dataCol = data1.data[0].HGridString.split(',');
                        //列设置列数与页面列数是否一致
                        if (dataCol.length == option.cols[0].length - 1) {
                            //遍历寻找列设置对应列按顺序插入
                            for (var j = 0; j < option.cols[0].length - 1; j++) {
                                for (var i = 0; i < option.cols[0].length - 1; i++) {
                                    var dataCols = dataCol[j].split('|');
                                    //选择与datacols相应列进行修改
                                    if (option.cols[0][i + 1]["field"] == dataCols[5]) {
                                        //隐藏列
                                        if (dataCols[1] == 1) {
                                            option.cols[0][i + 1]["hide"] = true;
                                        }
                                        //设置列宽
                                        if (dataCols[3] > 0) {
                                            option.cols[0][i + 1]["width"] = dataCols[3];
                                        }
                                        //设置内容字体大小
                                        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[1] == 0 && $.inArray(option.cols[0][i + 1]["title"], titleData) == -1) {
                                            option.cols[0][i + 1]["hide"] = false;
                                        }
                                        //统计列
                                        if (dataCols[6] == 1) {
                                            option.cols[0][i + 1]["totalRow"] = true;
                                        }
                                        //字体所在位置(å·¦ å±…中 å³)
                                        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;
                                        }
                                        //设置表格title属性显示别名
                                        if (dataCols[4] != null && dataCols[4] != "") {
                                            option.cols[0][i + 1]["title"] = dataCols[4];
                                        }
                                        newCols[0].push(option.cols[0][i + 1]);
                                    }
                                }
                            }
                            //遍历循环后判断对应列数是否一致
                            if (dataCol.length == newCols[0].length - 1) {
                                option.cols = newCols;
                                //取消冻结列
                                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
        //#endregion
        //以上是layui模块
    });