WebTM/views/³µ¼ä¹ÜÀí/±¨±í·ÖÎö/Kf_ProdProcessSumReport_DyeColor.html
@@ -34,15 +34,15 @@
                                    </div>
                                </div>
                                <!--<div class="layui-inline">
                                    <label class="layui-form-label">状态</label>
                                    <div class="layui-input-block" style="margin-left: 120px;width: 184px;">
                                        <select name="HState" lay-verify="HState" id="HState">
                                            <option value="0" selected="selected">全部</option>
                                            <option value="1">未开工</option>
                                            <option value="3">已入库</option>
                                        </select>
                                    </div>
                                </div>-->
        <label class="layui-form-label">状态</label>
        <div class="layui-input-block" style="margin-left: 120px;width: 184px;">
            <select name="HState" lay-verify="HState" id="HState">
                <option value="0" selected="selected">全部</option>
                <option value="1">未开工</option>
                <option value="3">已入库</option>
            </select>
        </div>
    </div>-->
                                <div class="layui-inline">
                                    <label class="layui-form-label">日期</label>
                                    <div class="layui-input-block">
@@ -59,17 +59,29 @@
                                    <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
                                </button>
                                <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnReSearch" id="btnReSearch" style="padding:0 5px">重置</button>
                                <div class="layui-inline">
                                    <label class="layui-form-label">合计公斤数</label>
                                <div class="layui-inline" style="display:none;">
                                    <label class="layui-form-label">白坯发布合计公斤数</label>
                                    <div class="layui-input-block" style="margin-left: 120px;">
                                        <input type="text" class="layui-input" name="SumHMaterOutQty" id="SumHMaterOutQty" disabled="disabled">
                                    </div>
                                </div>
                                <!--<div class="layui-inline">
                                    <div style="padding-left: 10px;">
                                        <input type="checkbox" name="checkWRuku" id="checkWRuku" lay-skin="primary" lay-filter="checkWRuku" title="未下推及已入库">
                                <div class="layui-inline" style="display:none;">
                                    <label class="layui-form-label">染厂出站合计公斤数</label>
                                    <div class="layui-input-block" style="margin-left: 120px;">
                                        <input type="text" class="layui-input" name="SumDyeColorOut" id="SumDyeColorOut" disabled="disabled">
                                    </div>
                                </div>-->
                                </div>
                                <div class="layui-inline" style="display:none;">
                                    <label class="layui-form-label">差额</label>
                                    <div class="layui-input-block" style="margin-left: 120px;">
                                        <input type="text" class="layui-input" name="SumCompare" id="SumCompare" disabled="disabled">
                                    </div>
                                </div>
                                <!--<div class="layui-inline">
        <div style="padding-left: 10px;">
            <input type="checkbox" name="checkWRuku" id="checkWRuku" lay-skin="primary" lay-filter="checkWRuku" title="未下推及已入库">
        </div>
    </div>-->
                                <div class="layui-colla-content" style="padding: 0px; margin-left: 6%;">
                                    <div class="layui-row" style="margin-top:10px;">
                                        <!--其他条件-->
@@ -162,7 +174,9 @@
            //查询条件
            var sWhere = "";
            var option = [];
            var HModName = "MaterOutSumReport_Cloth";
            var HModName = "ProdProcessSumReport_DyeColor";
            var titleData = ["HCusID"];//不需要显示的字段 å¯æ‰©å±•
            //#endregion
            //#region è¿›å…¥é¡µé¢æ—¢åŠ è½½
@@ -183,8 +197,10 @@
                    case 'HideColumn':
                        get_HideColumn();
                        break;
                    //明细报表
                    case 'btn-detail':
                        get_EntryReport();
                        break;
                };
            });
            //重置按钮
@@ -195,7 +211,61 @@
            form.on('submit(btnSearch)', function (data) {
                get_FastQuery();
            });
            //行监听事件
            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;
                    }
                });
            });
            //行监听事件-双击
            table.on('rowDouble(mainTable)', function (obj) {
                //选中高亮 åŒå‡»è¡Œ
                obj.tr.find(':checkbox').prop('checked', true);
                obj.tr.find('.layui-form-checkbox').addClass('layui-form-checked');  //设置复选框选中样式
                $(obj.tr.selector).attr({ "style": "background:#ceedfa;color:black" });//改变当前tr背景颜色和字体颜色
                //mainTable ä¸ºè¡¨æ ¼ID   æ³¨æ„æ­¤å¤„如果ID不正确将导致你在监听复选框时获取不到你选择的数据,前面的只是添加或删除选中未选中样式以及设置背景色,字体颜色
                layui.each(table.cache.mainTable, function (i, l) {
                    if (obj.tr.index() == l.LAY_TABLE_INDEX) {
                        l.LAY_CHECKED = true;
                    }
                });
                //下推
                var sBillNo = obj.data["生产订单号"];
                layer.open({
                    type: 2
                    , area: ['90%', '90%']
                    , title: '染厂明细报表'
                    , closeBtn: 1
                    , shade: 0.6 //遮罩透明度
                    , maxmin: true //允许全屏最小化
                    , anim: 0 //0-6的动画形式,-1不开启
                    , content: 'Kf_ProdProcessEntryReport_DyeColor.html?sBillNo=' + sBillNo
                    , resize: false
                    , btn: ["确定", "取消"]
                    , end: function () {
                        //刷新页面,
                        //location.reload();
                    }
                    , cancel: function () {
                        //$(".layui-btn").removeClass("layui-btn-disabled");
                    }
                })
            });
            //#endregion
@@ -251,6 +321,10 @@
                    com = " and (" + ColName + " " + com + ")";
                }
                //根据用户过滤用户关联客户的记录
                var OtherSearch = getSWhereByHUser();
                sWhere = {
                    HBeginDate: HBeginDate
                    , HEndDate: HEndDate
@@ -259,6 +333,7 @@
                    , HProductName: HProductName
                    , HProductModel: HProductModel
                    , RandomSearch: com
                    , OtherSearch: (OtherSearch == null || OtherSearch == "undefine") ? " and 1=1 " : OtherSearch
                }
                sWhere = JSON.stringify(sWhere);
@@ -281,9 +356,9 @@
                            }
                            //在列表左边添加勾选框
                            col.push({ type: 'radio', fixed: 'left' });
                            col.push({ type: 'checkbox', fixed: 'left' });
                            for (var i = 0; i < data.length; i++) {
                                if ($.inArray(data[i].name, "") > -1) {
                                if ($.inArray(data[i].name, titleData) > -1) {
                                    col.push({ field: data[i].id, title: data[i].name, align: 'center', hide: true }); //隐藏id列
                                }
                                else if (data[i].ColName == '白坯发布') {
@@ -349,10 +424,10 @@
                })
            }
            //列明显示下拉框
            //列名显示下拉框
            function ColFilter() {
                var Organization = '<option  value="0" selected="selected" ></option>';
                for (var i = 0; i < option.cols[0].length; i++) {
                for (var i = 1; i < option.cols[0].length; i++) {
                    if (option.cols[0][i].hide != true) {
                        Organization += '<option  style="color:blue;" value="' + option.cols[0][i].field + '">' + option.cols[0][i].field + '</option>';
                    }
@@ -374,8 +449,9 @@
                        if (data1.count == 1) {
                            //调整日期格式:显示 å¹´æœˆæ—¥ å’Œ æ—¶
                            for (var i = 0; i < data1.data.length; i++) {
                                data1.data[i].生产订单日期 = data1.data[i]["生产订单日期"].split(":")[0] + ':' + data1.data[i]["生产订单日期"].split(":")[1];
                                data1.data[i].生产订单日期 = data1.data[i]["生产订单日期"].replace("T", " ");
                                if (data1.data[i].生产订单日期!=null) {
                                    data1.data[i].生产订单日期 = data1.data[i]["生产订单日期"].split("T")[0];
                                }
                            }
                            option.data = data1.data;
@@ -393,12 +469,24 @@
                            //}
                            table.render(option);
                            //计算合计公斤数
                            //计算白坯发布合计公斤数
                            var sumHMaterOutQty = 0;
                            for (var i = 0; i < data1.data.length; i++) {
                                sumHMaterOutQty += data1.data[i]["白坯发布"];
                            }
                            $("#SumHMaterOutQty").val(sumHMaterOutQty);
                            //计算染厂出站合计公斤数
                            var sumDyeColorOut = 0;
                            for (var i = 0; i < data1.data.length; i++) {
                                sumDyeColorOut += data1.data[i]["染厂出站"];
                            }
                            $("#SumDyeColorOut").val(sumDyeColorOut);
                            //计算差额
                            var sumCompare = sumHMaterOutQty - sumDyeColorOut;
                            $("#SumCompare").val(sumCompare);
                            layer.close(wait);
                        } else {
@@ -451,14 +539,19 @@
                    com = " and (" + ColName + " " + com + ")";
                }
                //根据用户过滤用户关联客户的记录
                var OtherSearch = getSWhereByHUser();
                sWhere = {
                    HBeginDate: HBeginDate
                    , HEndDate: HEndDate
                    ,HMaterNumber: HMaterNumber
                    , HMaterNumber: HMaterNumber
                    , HBillNo: HBillNo
                    , HProductName: HProductName
                    , HProductModel: HProductModel
                    , RandomSearch:com
                    , RandomSearch: com
                    , OtherSearch: (OtherSearch == null || OtherSearch == "undefine") ? " and 1=1 " : OtherSearch
                }
                //set_InitGrid(JSON.stringify(sWhere));
                get_Display(JSON.stringify(sWhere));
@@ -486,7 +579,7 @@
            //隐藏列设置
            function get_HideColumn() {
                var colName = "";
                for (var i = 1; i < option.cols[0].length - 1; i++) {
                for (var i = 1; i < option.cols[0].length; i++) {
                    colName += option.cols[0][i]["title"] + ",";
                }
@@ -521,11 +614,11 @@
                        if (data1.data.length != 0) {
                            var dataCol = [];//数据库查询出的列数据
                            var titleData = [];//不需要显示的字段 å¯æ‰©å±•
                            /*var titleData = [];//不需要显示的字段 å¯æ‰©å±•*/
                            dataCol = data1.data[0].HGridString.split(',');
                            for (var i = 0; i < option.cols[0].length - 2; i++) {
                            for (var i = 0; i < option.cols[0].length - 1; i++) {
                                if (dataCol[i]) {
                                    var dataCols = dataCol[i].split('|');
                                }
@@ -589,6 +682,7 @@
                })
            }
            //明细报表
            function get_EntryReport() {
                var checkStatus = table.checkStatus('mainTable')
                    , data = checkStatus.data;
@@ -618,6 +712,31 @@
                    layer.msg('请选择一行数据编辑!');
                }
            }
            //#region æ ¹æ®ç”¨æˆ·èŽ·å–ç”¨æˆ·å…³è”å®¢æˆ·çš„è¿‡æ»¤æ¡ä»¶
            function getSWhereByHUser() {
                var res = "";
                $.ajax({
                    type: "GET",
                    async: false,
                    url: GetWEBURL() + "/Xs_SeOrderBill/getCusIDListByUser", //方法所在页面和方法名
                    data: { "CurUserID": sessionStorage["Czybm"], "CurUserName": sessionStorage["HUserName"] },
                    success: function (result) {
                        if (result.count == 1) {
                            res = result.data;
                        } else {
                            res = result.data;
                            layer.alert(result.code + result.Message, { icon: 5 });
                        }
                    }, error: function (err) {
                        res = " and 1 = 0";
                        layer.alert("接口请求失败!", { icon: 5 });
                    }
                });
                return res;
            }
            //#endregion
            //#endregion
        });
    </script>