Merge branch 'master' of http://101.37.171.70:10101/r/MES-WEB-LayUI

yangle

2024-06-18 ac5962f71fe0f4fd4e7e44fb74a02bba7ff816b4

 WebTM/views/²Ö´æ¹ÜÀí/ÌõÂ뱨±í/KF_ICinventoryQueryReport.html

@@ -88,6 +88,12 @@
                                                <input type="text" class="layui-input" name="HMTO" id="HMTO" style="width:190px;">
                                            </div>
                                        </div>
                                        <div class="layui-inline">
                                            <label class="layui-form-label">物料ID</label>
                                            <div class="layui-input-block">
                                                <input type="text" class="layui-input" name="HMaterID" id="HMaterID" style="width:190px;">
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
@@ -97,6 +103,7 @@
                            <div class="layui-btn-container">
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn_Export" id="Export"><i class="layui-icon layui-icon-export"></i>导出</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn_Query" id="Query"><i class="layui-icon layui-icon-search"></i>查询</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn_Proofread" id="Proofread"><i class="layui-icon layui-icon-radio"></i>库存校对</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Cell" id="Cell"><i class="layui-icon layui-icon-slider"></i>保存列宽</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-RefreshCell" id="RefreshCell"><i class="layui-icon layui-icon-cols"></i>默认列宽</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn_HideColumn" id="HideColumn"><i class="layui-icon layui-icon-form"></i>列设置</button>
@@ -131,12 +138,19 @@
            var option = [];
            var ins;                        //用于导出excel
            var columns = "";
            var HModName = "Kf_ICInventory_BarCode";
            var HModName = "Kf_ICInventoryQueryReport";
            var titleData = [];     //不需要显示的字段
        //#endregion

        //#region è¿›å…¥é¡µé¢å³åŠ è½½

            //获取页面跳转参数
            var params = get_UrlVars();
            var OperationType = params[params[0]]; //从参数中获取 æ•°æ®ç±»åž‹  1查询
            var HMaterID = params[params[1]]; //从参数中获取 ç‰©æ–™id
            if (HMaterID != null) {
                $("#HMaterID").val(HMaterID);
            }
            //初始化界面
            set_ClearBill();

@@ -147,7 +161,7 @@
                //初始化表格
                set_InitGrid();
                //查询
                get_Display(sWhere);
                get_Display();
            }
            //#endregion

@@ -187,6 +201,7 @@
                    , cellMinWidth: 90
                    , limit: 50
                    , limits: [50, 500, 5000, 20000]
                    , cols:[[]]
                    , done: function (res, curr, count) {
                        soulTable.render(this);
                    }
@@ -313,6 +328,9 @@
                    //查询按钮
                    case 'btn_Query': get_Display();
                        break;
                    //库存校对按钮
                    case 'btn_Proofread': get_Proofread();
                        break;
                    //退出按钮
                    case 'btn_Exit': Pub_Close(2);
                        break;
@@ -337,6 +355,7 @@

            //#region æŸ¥è¯¢
            function get_Display() {
                var HMaterID = $("#HMaterID").val();            //物料ID
                var HMaterNumber = $("#HMaterNumber").val();            //物料编码
                var HMaterName = $("#HMaterName").val();                //物料名称
                var HAuxProp = $("#HAuxProp").val();            //辅助属性
@@ -345,16 +364,16 @@
                var HSPName = $("#HSPName").val();              //仓位
                var HModel = $("#HModel").val();               //规格型号
                var HMTO = $("#HMTO").val();                  //MTO计划跟踪号
                sWhere = "'" + HMaterNumber + "','" + HMaterName + "','" + HModel + "','" + HAuxProp + "','" + HWHName + "','" + HSPName + "','" + HBatchNo + "','" + HMTO + "'";
                sWhere = "'" + HMaterID+"','" + HMaterNumber + "','" + HMaterName + "','" + HModel + "','" + HAuxProp + "','" + HWHName + "','" + HSPName + "','" + HBatchNo + "','" + HMTO + "'";

                var ajaxLoad = layer.load();
                $.ajax({
                    type: "GET",
                    url: GetWEBURL() + '/WEBSController/GetKF_ICinventoryQueryReport_Json',
                    async: false,    //async用于控制（false）同步和（true）异步，默认的是true，即请求默认的是异步请求
                    data: { "sWhere": sWhere },
                    data: { "sWhere": sWhere},
                    success: function (data1) {
                        if (data1.count == 1) {
                        
                            var data = [];
                            var col = [];
                            //给空的数组赋值
@@ -403,6 +422,7 @@
                                });
                            }
                            option.cols = [columns];
                        if (data1.data != null) {
                            option.data = data1.data;
                            option.totalRow = true;
                            table.render(option);
@@ -411,6 +431,9 @@
                            DisPlay_HideColumn();
                            layer.close(ajaxLoad);
                        } else {
                            option.data = [[]];
                            option.totalRow = true;
                            table.render(option);
                            layer.close(ajaxLoad);
                            layer.alert(data1.code + data1.Message, { icon: 5 });
                        }
@@ -424,6 +447,30 @@
            }
            //#endregion

            //#region åº“存校对
            function get_Proofread() {
            
                var ajaxLoad = layer.load();
                $.ajax({
                    type: "GET",
                    url: GetWEBURL() + '/WEBSController/UpdateKf_ICInvBal',
                    async: false,    //async用于控制（false）同步和（true）异步，默认的是true，即请求默认的是异步请求
                    data: {},
                    success: function (data1) {
                        if (data1.count == 1) {
                            layer.msg(data.Message, { time: 1 * 2000, icon: 1 }, function (index) {
                               
                            });
                        }
                    },
                    error: function () {
                        layer.close(ajaxLoad);
                        layer.alert("接口请求失败!", { icon: 5 });
                    }
                });
            }
            //#endregion

            //#region é‡ç½®æŒ‰é’®
            form.on('submit(btnReSearch)', function (data) {
                //清空过滤条件
@@ -432,8 +479,9 @@

            //重置过滤条件
            function set_ClearQuery() {
                $("#HMaterID").val("");            //物料ID
                 $("#HMaterNumber").val("");            //物料编码
                 $("#HMater").val("");                //物料名称
                 $("#HMaterName").val("");                //物料名称
                 $("#HAuxProp").val("");            //辅助属性
                 $("#HBatchNo").val("");            //批号
                 $("#HWHName").val("");              //仓库