1

yxj

2024-11-26 e9d2113417213c45750130861c935267498a90b1

 WebTM/views/³µ¼ä¹ÜÀí/±¨±í·ÖÎö/Sc_PlanAchievementRateReport.html

@@ -87,6 +87,7 @@
                                        <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>
                                    <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="get_export" id="get_export" style="padding:0 5px">导出</button>
                                </div>
                                <div class="layui-colla-content" style="padding: 0px; margin-left: 6%;">
                                    <div class="layui-row" style="margin-top:10px;margin-left:5%;">
@@ -217,6 +218,7 @@
        var option = [];
        var HModName = "Sc_PlanAchievementRateReport";
        var titleData = ["HInterID", "HEntryID", "HBadReasonID", "HSourceInterID", "HSourceEntryID"];//子表不需要显示的字段 å¯æ‰©å±•
        var ins;  //用于导出excel

        //#endregion

@@ -249,6 +251,23 @@
        form.on('submit(btnReSearch)', function (data) {
            set_ClearQuery();
        });

        //导出
        form.on('submit(get_export)', function (data) {
            var data = option.data
            data.forEach((item) => {
                for (let itemobj in item) {
                    if (item[itemobj] == null) {
                        item[itemobj] = "";
                    }
                    if (item[itemobj].length > 0) {  // å‡è®¾å­—段名为field
                        item[itemobj] = item[itemobj].toString().replaceAll(/[\r\n]+/g, '').replaceAll(',','，');  // å°†æ¢è¡Œç¬¦æ›¿æ¢ä¸ºç©ºå­—符串
                    }
                }
            });

            table.exportFile(ins.config.id, option.data, "xls");
        });        

        //日期间隔下拉列表监听
        form.on('select(HInitTimeCycle)', function (data) {
@@ -410,13 +429,13 @@
                                        //计算平均值
                                        var data = $(".layui-table-total div:eq(9)").html();
                                        var trArr = $(".layui-table-body.layui-table-main tr").length * 100;
                                        content = (data / trArr * 100).toFixed(2);
                                        content = ($(".layui-table-total div:eq(8)").html() / $(".layui-table-total div:eq(9)").html() * 100).toFixed(2);
                                        divHtml.html(content);
                                    }
                                });
                            }
                        }
                        table.render(option);
                        ins = table.render(option);
                       
                        //刷新表格数据
                        DisPlay_HideColumn();