WebTM/views/²Ö´æ¹ÜÀí/ÌõÂ뱨±í/Kf_StockInOutSumQueryReport.html
@@ -76,6 +76,12 @@
                                                <input type="text" class="layui-input" name="HWHName" id="HWHName" 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>
@@ -85,6 +91,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_Detail" id="Detail"><i class="layui-icon layui-icon-search"></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>
@@ -104,7 +111,7 @@
        }).extend({
            index: 'lib/index', //主入口模块
        }).use(['index', 'form', 'table', 'element', 'laypage', 'laydate','soulTable'], function () {
        //#region å…¬å…±å˜é‡
            var $ = layui.$
                , admin = layui.admin
@@ -119,26 +126,60 @@
            var option = [];
            var ins;                        //用于导出excel
            var columns = "";
            var HModName = "Kf_MaterOutInReport";
            var HModName = "Kf_StockInOutSumQueryReport";
            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);
                //获取开始日期、结束日期
                $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30 * 6), "yyyy-MM-dd"));
                $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd"));
            } else {
                //获取开始日期、结束日期
                $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd"));
                $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd"));
            }
            //初始化界面
            set_ClearBill();
            //#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 set_ClearBill() {
                //获取开始日期、结束日期
                $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd"));
                $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd"));
                //获取组织
                Organ();
                //初始化表格
                set_InitGrid();
                //查询
                get_Display(sWhere);
                get_Display();
            }
            //#endregion
@@ -304,6 +345,9 @@
                    //查询按钮
                    case 'btn_Query': get_Display();
                        break;
                    //查询按钮明细
                    case 'btn_Detail': get_Detail();
                        break;
                    //退出按钮
                    case 'btn_Exit': Pub_Close(2);
                        break;
@@ -330,12 +374,13 @@
            function get_Display() {
                var HBeginDate = $("#HBeginDate").val();        //开始日期
                var HEndDate = $("#HEndDate").val();            //结束日期
                var HMaterID = $("#HMaterID").val();            //物料ID
                var HMaterNumber = $("#HMaterNumber").val();          //物料编码
                var HMaterName = $("#HMaterName").val();          //物料名称
                var HWHName = $("#HWHName").val();              //仓库
                var HModel = $("#HModel").val();               //规格型号
                sWhere = "'" + HBeginDate + "','" + HEndDate + "','" + HMaterNumber + "','" + HMaterName + "','" + HModel + "','" + HWHName + "'" ;
                sWhere = "'" + HBeginDate + "','" + HEndDate + "','" + HMaterID + "','" + HMaterNumber + "','" + HMaterName + "','" + HModel + "','" + HWHName + "'" ;
                var ajaxLoad = layer.load();
                $.ajax({
@@ -344,7 +389,7 @@
                    async: false,    //async用于控制(false)同步和(true)异步,默认的是true,即请求默认的是异步请求
                    data: { "sWhere": sWhere },
                    success: function (data1) {
                        if (data1.count == 1) {
                        if (data1.data != null) {
                            var data = [];
                            var col = [];
                            //给空的数组赋值
@@ -401,8 +446,57 @@
                            DisPlay_HideColumn();
                            layer.close(ajaxLoad);
                        } else {
                            var data = [];
                            var col = [];
                            //给空的数组赋值
                            for (var key in data1.list) {
                                //动态获取列表所有列名
                                data.push({ "id": data1.list[key].ColmCols, "name": data1.list[key].ColmCols, "Type": data1.list[key].ColmType });
                                //获取不需要显示的列(H开头的列不显示)
                                var patrn = new RegExp(/^h/i);
                                if (patrn.test(data1.list[key].ColmCols)) {
                                    titleData[key] = data1.list[key].ColmCols;
                                }
                            }
                            //在列表左边添加勾选框
                            col.push({ type: 'checkbox', fixed: 'left', totalRowText: '合计' });
                            for (var i = 0; i < data.length; i++) {
                                if ($.inArray(data[i].name, titleData) > -1) {
                                    col.push({ field: data[i].id, title: data[i].name, align: 'center', hide: true }); //隐藏id列
                                }
                                else {
                                    switch (data[i].Type) {
                                        //int
                                        case 'DateTime':
                                            col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, templet: "<div>{{d." + data[i].name + " ==null ?'':layui.util.toDateString(d." + data[i].name + ", 'yyyy-MM-dd')}}</div>", width: 200 });
                                            break;
                                        default:
                                            if (data[i].name == '数量') {
                                                col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, totalRow: true });
                                            } else {
                                                col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true });
                                            }
                                    }
                                }
                            }
                            columns = col;
                            //设置赋值列宽
                            var colWidth = getColumnsWidth();
                            if (colWidth == "" || colWidth == []) {
                            }
                            else {
                                $.each(columns, function (x, m) {
                                    m["width"] = colWidth[x];
                                });
                            }
                            option.cols = [columns];
                            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 () {
@@ -414,6 +508,39 @@
            }
            //#endregion
            //查看明细
            function get_Detail() {
                var checkStatus = table.checkStatus('mainTable')
                    , data = checkStatus.data;
                if (checkStatus.data.length === 1) {
                    var HMaterID = data[0].HMaterID.toString();
                    var HMaterName = data[0].物料名称.toString();
                    var HBeginDate = $("#HBeginDate").val();//欠料日期
                    var HEndDate = $("#HEndDate").val();//至
                    var HWHName = data[0].仓库.toString();
                    //if (AllowLoadData(sSubStr) != false) {//非空验证
                    layer.open({
                        type: 2
                        , area: ['100%', '100%']
                        , title: '查看明细'
                        , closeBtn: 1
                        , shade: 0.6 //遮罩透明度
                        , maxmin: true //允许全屏最小化
                        , anim: 0 //0-6的动画形式,-1不开启
                        , content: `./Kf_StockInOutEntryByPageReport.html?OperationType=2&HMaterID=${HMaterID}&HMaterName=${HMaterName}&HWHName=${HWHName}&HBeginDate=${HBeginDate}&HEndDate=${HEndDate}`
                        , resize: false,
                        end: function () {
                        }
                        , cancel: function () {
                            //$(".layui-btn").removeClass("layui-btn-disabled");
                        }
                    })
                } else {
                    layer.msg('请选择一行数据查看!');
                }
            }
            //#region é‡ç½®æŒ‰é’®
            form.on('submit(btnReSearch)', function (data) {
                //清空过滤条件
@@ -424,6 +551,7 @@
            function set_ClearQuery() {
                $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd"));    //开始日期
                $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd"));   //结束日期
                $("#HMaterID").val("");            //物料ID
                $("#HMaterNumber").val("");           //物料编码
                $("#HMaterName").val("");         //物料名称
                $("#HModel").val("");          //规格型号