duhe
2024-11-20 3bd2c47598b8c6fca2c2fe5bebc280cb536dbae9
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>
@@ -116,7 +123,7 @@
        }).extend({
            index: 'lib/index', //主入口模块
        }).use(['index', 'form', 'table', 'element', 'laypage', 'laydate','soulTable'], function () {
        //#region å…¬å…±å˜é‡
            var $ = layui.$
                , admin = layui.admin
@@ -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,10 +161,29 @@
                //初始化表格
                set_InitGrid();
                //查询
                get_Display(sWhere);
                get_Display();
            }
            //#endregion
            //#region ç‚¹å‡»è¡Œé€‰ä¸­é«˜äº®
            table.on('row(mainTable)', function (obj) {
                //选中行改变颜色
                var flag = !obj.tr.find(':checkbox:first').prop('checked');
                obj.tr.find(':checkbox').prop('checked', flag);
                if (flag) {
                    obj.tr.find('.layui-form-checkbox').addClass('layui-form-checked');  //设置复选框选中样式
                    $(obj.tr.selector).attr({ "style": "background:#ceedfa;color:black" });//改变当前tr背景颜色和字体颜色
                } else {
                    obj.tr.find('.layui-form-checkbox').removeClass('layui-form-checked');//取消复选框选中样式
                    $(obj.tr.selector).attr({ "style": "background:" });//取消当前tr颜色
                }
                //mainTable ä¸ºè¡¨æ ¼ID   æ³¨æ„æ­¤å¤„如果ID不正确将导致你在监听复选框时获取不到你选择的数据,前面的只是添加或删除选中未选中样式以及设置背景色,字体颜色
                layui.each(table.cache.mainTable, function (i, l) {
                    if (obj.tr.index() == l.LAY_TABLE_INDEX) {
                        l.LAY_CHECKED = flag;
                    }
                });
            })
            //#endregion
            //#region   èŽ·å–ç»„ç»‡
            function Organ() {
                //获取登录页组织列
@@ -187,6 +220,7 @@
                    , cellMinWidth: 90
                    , limit: 50
                    , limits: [50, 500, 5000, 20000]
                    , cols:[[]]
                    , done: function (res, curr, count) {
                        soulTable.render(this);
                    }
@@ -313,6 +347,9 @@
                    //查询按钮
                    case 'btn_Query': get_Display();
                        break;
                    //库存校对按钮
                    case 'btn_Proofread': get_Proofread();
                        break;
                    //退出按钮
                    case 'btn_Exit': Pub_Close(2);
                        break;
@@ -337,6 +374,7 @@
            //#region æŸ¥è¯¢
            function get_Display() {
                var HMaterID = $("#HMaterID").val();            //物料ID
                var HMaterNumber = $("#HMaterNumber").val();            //物料编码
                var HMaterName = $("#HMaterName").val();                //物料名称
                var HAuxProp = $("#HAuxProp").val();            //辅助属性
@@ -345,16 +383,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 +441,7 @@
                                });
                            }
                            option.cols = [columns];
                        if (data1.data != null) {
                            option.data = data1.data;
                            option.totalRow = true;
                            table.render(option);
@@ -411,8 +450,11 @@
                            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 });
                          /*  layer.alert(data1.code + data1.Message, { icon: 5 });*/
                        }
                    },
                    error: function () {
@@ -424,6 +466,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 +498,9 @@
            //重置过滤条件
            function set_ClearQuery() {
                $("#HMaterID").val("");            //物料ID
                 $("#HMaterNumber").val("");            //物料编码
                 $("#HMater").val("");                //物料名称
                 $("#HMaterName").val("");                //物料名称
                 $("#HAuxProp").val("");            //辅助属性
                 $("#HBatchNo").val("");            //批号
                 $("#HWHName").val("");              //仓库