销售出库明细报表：增加 表头 重量_吨，设置合计

duhe

2024-09-27 c2b05e1ec0bbbbf0147378e9570bc66bb715078f

销售出库明细报表：增加 表头 重量_吨，设置合计

 WebTM/views/Ó¦ÊÕ¹ÜÀí/±¨±í·ÖÎö/Kf_SellOutEntryReport.html

@@ -81,6 +81,13 @@
                                                <input type="text" class="layui-input" name="HMoneyTotalSum" id="HMoneyTotalSum" style="background-color:#efefef4d;" readonly>
                                            </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="text" class="layui-input" name="HWeightTotalSum" id="HWeightTotalSum" style="background-color:#efefef4d;" readonly>
                                            </div>
                                        </div>
                                        <span>吨</span>
                                    </div>
                                    <div class="layui-row" style="position:relative; left:30px;">
                                        <div class="layui-inline" style="width:450px;">
@@ -103,6 +110,13 @@
                                                <input type="text" class="layui-input" name="HMoneySum" id="HMoneySum" style="background-color:#efefef4d;" readonly>
                                            </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="text" class="layui-input" name="HWeightSum" id="HWeightSum" style="background-color:#efefef4d;" readonly>
                                            </div>
                                        </div>
                                        <span>吨</span>
                                    </div>
                                    <div class="layui-row" style="position:relative; left:30px;">
                                        <div class="layui-inline" style="width:450px;">
@@ -125,6 +139,13 @@
                                                <input type="text" class="layui-input" name="HMoneySum_YM" id="HMoneySum_YM" style="background-color:#efefef4d;" readonly>
                                            </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="text" class="layui-input" name="HWeightSum_YM" id="HWeightSum_YM" style="background-color:#efefef4d;" readonly>
                                            </div>
                                        </div>
                                        <span>吨</span>
                                    </div>
                                    <div class="layui-colla-content" style="padding: 0px; margin-left: 6%;">
                                        <div class="layui-row" style="margin-top:5px">
@@ -442,7 +463,7 @@
                    data: { "sWhere": sWhere, "user": sessionStorage["HUserName"], "userid": sessionStorage["Czybm"]},
                    success: function (data1) {
                        if (data1.count == 1) {
                            var totalArray = ["件数", "米数","金额"];
                            var totalArray = ["件数", "米数","金额","重量_吨"];
                            var data = [];
                            var col = [];
                            //给空的数组赋值
@@ -484,12 +505,15 @@
                            var HPieceQtyTotalSum = 0;
                            var HQtyTotalSum = 0;
                            var HMoneyTotalSum = 0;
                            var HWeightTotalSum = 0;
                            var HPieceQtySum = 0;
                            var HQtySum = 0;
                            var HMoneySum = 0;
                            var HWeightSum = 0;
                            var HPieceQtySum_YM = 0;
                            var HQtySum_YM= 0;
                            var HMoneySum_YM = 0;
                            var HWeightSum_YM = 0;
                            //获取子表列数据
                            var colList = [];
                            for (var i = 0; i < option.cols[0].length; i++) {
@@ -503,6 +527,7 @@
                                HPieceQtySum += result[i]["件数"] * 1;
                                HQtySum += result[i]["米数"] * 1;
                                HMoneySum += result[i]["金额"] * 1;
                                HWeightSum += result[i]["重量_吨"] * 1;

                                //设置只显示单据的第一行主表信息，其他行只显示子表信息
                                if (temp != result[i]["hmainid"]) {
@@ -531,6 +556,7 @@
                                HPieceQtySum_YM += result1[i]["件数"] * 1;
                                HQtySum_YM += result1[i]["米数"] * 1;
                                HMoneySum_YM += result1[i]["金额"] * 1;
                                HWeightSum_YM += result1[i]["重量_吨"] * 1;

                                //设置只显示单据的第一行主表信息，其他行只显示子表信息
                                if (temp1 != result1[i]["hmainid"]) {
@@ -557,15 +583,20 @@
                            HPieceQtyTotalSum = HPieceQtySum + HPieceQtySum_YM;
                            HQtyTotalSum = HQtySum + HQtySum_YM;
                            HMoneyTotalSum = HMoneySum + HMoneySum_YM;
                            HWeightTotalSum = (HWeightSum.toFixed(2) * 1) + (HWeightSum_YM.toFixed(2) * 1);

                            $("#HPieceQtySum").val(fixed(HPieceQtySum*1));
                            $("#HQtySum").val(fixed(HQtySum.toFixed(6)*1));
                            $("#HMoneySum").val(fixed(HMoneySum.toFixed(6)*1));
                            $("#HMoneySum").val(fixed(HMoneySum.toFixed(6) * 1));
                            $("#HWeightSum").val(fixed(HWeightSum.toFixed(2) * 1));
                            $("#HPieceQtySum_YM").val(fixed(HPieceQtySum_YM*1));
                            $("#HQtySum_YM").val(fixed(HQtySum_YM.toFixed(6)*1));
                            $("#HMoneySum_YM").val(fixed(HMoneySum_YM.toFixed(6)*1));
                            $("#HMoneySum_YM").val(fixed(HMoneySum_YM.toFixed(6) * 1));
                            $("#HWeightSum_YM").val(fixed(HWeightSum_YM.toFixed(2) * 1));
                            $("#HPieceQtyTotalSum").val(fixed(HPieceQtyTotalSum*1));
                            $("#HQtyTotalSum").val(fixed(HQtyTotalSum.toFixed(6)*1));
                            $("#HMoneyTotalSum").val(fixed(HMoneyTotalSum.toFixed(6)*1));
                            $("#HMoneyTotalSum").val(fixed(HMoneyTotalSum.toFixed(6) * 1));
                            $("#HWeightTotalSum").val(fixed(HWeightTotalSum.toFixed(2) * 1));