个人资料
个人主页
发表文章
主页
博客
留言板
搜索
搜本站
首页
>
博客列表
>
博客正文
Excel中用Power View快速制作智能动态报表
分类
<iframe/> </div> <div style="overflow: hidden; margin: 5px 0;" class="column"> <a title="创作作者"> <img class="photo-small" src='https://thirdqq.qlogo.cn/qqapp/101381207/177D227E8741607D1E56F351D4A52CAA/100' /> <span style="vertical-align: top">songshizhao</span> </a> <div style="float: right"> <i id="pTime" class="fa fa-calendar-o">最初发表2018/10/30 2:10:09 </i> <i class="fa fa-calendar-check-o">最近更新2018/10/30 2:10:09 </i> <i title="访问量" class="fa fa-eye">115</i> </div> <style> .well { min-height: 20px; padding: 19px; background-color: #f5f5f5; border: 1px solid #e3e3e3; border-radius: 4px; -webkit-box-shadow: inset 0 1px 1px rgba(0,0,0,.05); box-shadow: inset 0 1px 1px rgba(0,0,0,.05); } .star { cursor:pointer; font-size: 22px; } .fa-star { color: #e3cf7a; } .fa-star-o { color: #777; } </style> <div class="well"> <div>为此篇作品打分</div> <span id="star1" data-score="1" class="star fa fa-star-o" title="很差"></span> <span id="star2" data-score="2" class="star fa fa-star-o" title="不太好"></span> <span id="star3" data-score="3" class="star fa fa-star-o" title="一般"></span> <span id="star4" data-score="4" class="star fa fa-star-o" title="较好"></span> <span id="star5" data-score="5" class="star fa fa-star-o" title="完美"></span> <span id="rate-score" style="margin-left:15px;">10</span> <script> var myRate = 0; var generalRate = 0; $(function () { $("#rate-score").text(generalRate*2+"分"); setRate(generalRate); $("span.star").click(function () { myRate = $(this).attr("data-score"); setRate(myRate); var desription=$(this).attr("title"); $("#rate-score").text(desription); Rate(myRate) }); $("span.star").hover(function () { setRate($(this).attr("data-score")); }); $("div.well").mouseleave(function () { setRate(myRate);//恢复原始的打分数值 }); }); function Rate(score) { if (confirm("评分" + myRate + "星，确定吗？")) { $.ajax({ url: '/blog/Blogs.asmx/RateBlog', //调用WebService的地址和方法名称组合 ---- WsURL/方法名 ContentType: "application/json;charset=utf-8", //WebService 会返回Json类型 dataType: "json", type: "Post", //访问WebService使用Post方式请求 data: "{BlogID:557,Score:"+myRate+"}", beforeSend: function (x) { x.setRequestHeader("Content-Type", "application/json; charset=utf-8"); }, success: function (result) {//回调函数，result，返回值 r = result.d; if (r.IsSuccess) { alert(r.MsgAlert); } else { alert(r.MsgAlert); } }, error: function (XMLHttpRequest, textStatus, errorThrown) { alert("没有登陆"); }, async: false, }); } } function setRate(score) { $("span.star").each(function () { var thisStar = $(this); if (thisStar.attr("data-score")<=score) { thisStar.removeClass("fa-star-o").addClass("fa-star"); } else { thisStar.removeClass("fa-star").addClass("fa-star-o"); } }); } function clearRate() { $("span.star").each(function () { var thisStar = $(this); thisStar.removeClass("fa-star").addClass("fa-star-o"); }); } </script> </div> </div> <div id="comment-block"> <div class="myTitle"> <i class="fa fa-commenting-o"><span>评论</span></i> <a id="submit-comment-lnkbutton" style="float: right; margin-right: 5px"> <i class="fa fa-hand-o-right ani-moveright"></i> [发表评论] </a> </div> <div id="comments"> </div> <div id="myPager" class="pager"></div> <div id="submit-comment" style="display: none;"> <textarea id="commentBox" style="width: 95%; box-sizing: border-box; margin: 7px;" placeholder="在这里输入内容,长度大于4字符"></textarea> <p class="pc-only">请将下图中苹果拖拽到图中盘子里面,进行提交</p> <div class="yz-bg pc-only" style="margin: 0 auto;"> <div id="plate" class="yz-plate"> </div> <div id="apple" class="yz-apple"></div> </div> <input type="checkbox" id="isNotifyAuthor" checked="checked" value="是否通知作者" /><span>是否通知文章作者[邮件]</span> <input type="button" value="长按提交评论" id="btn-touch-submit" style="padding: 7px; width: 190px; border-radius: 15px;" class="mobel-only" /> <script> $(function () { //原生js 中的 touch 事件 var btn = document.getElementById('btn-touch-submit'); //触摸开始 调用 btn.addEventListener('touchstart', function () { setTimeout(function () { var content = $('#commentBox').val(); if (content.length >= 4) { submitComment(557, content, $('#isNotifyAuthor').is(':checked')) } else { alert("内容太短"); } }, 1000); console.log('js start'); }) }); </script> </div> </div> <script> var myPager = $('#myPager'); var currentPage = 1;//当前页码 var perPageNum = 20; var showRange = 4;//显示页码宽度（*2） var commentCount = 0; var m = 0; var n = 20; var currentPageArray; //加载评论 $(function () { //获得评论数 commentCount = getBlogCommentCount(557); //加载一级评论 loadBlogComments(557, m, n, "comments"); //定义pager行为 freshCommentPager(); //点击评论-弹出对话框 $('#submit-comment-lnkbutton').click(function () { $("#submit-comment").dialog({ title: "参与回复", modal: true, width: 500, }); }); //拖拽验证提交评论 $('#apple').draggable({ revert: "valid" }); $("#plate").droppable({ drop: function (event, ui) { $(this).css("margin-left", "solid red 2px"); $("#submit-comment").dialog("close"); var content = $('#commentBox').val(); if (content.length >= 4) { submitComment(557, content, $('#isNotifyAuthor').is(':checked')) } else { alert("内容太短"); } } }); //编辑文章 $("#btnEdit").click(function () { $.ajax({ type: "Post", data: "{'id':'557'}", contentType: "application/json; charset=utf-8", url: '/blog/blogPage.aspx/Edit_Click', async: true, dataType: "json", beforeSend: function (x) { x.setRequestHeader("Content-Type", "application/json; charset=utf-8"); }, success: function (data) { //返回的数据用data.d获取内容 var result = data.d; //console.log("success"+data.d.MsgAlert); if (result.IsSuccess) { window.location.href = result.UrlNav; } else { alert(result.MsgAlert); } }, error: function (XMLHttpRequest, textStatus, errorThrown) { alert(errorThrown + '请求失败'); }, }); }); //删除文章 $("#btnDelete").click(function () { $.ajax({ type: "Post", data: "{'id':'557'}", contentType: "application/json; charset=utf-8", url: '/blog/blogPage.aspx/Delete_Click', async: true, dataType: "json", beforeSend: function (x) { x.setRequestHeader("Content-Type", "application/json; charset=utf-8"); }, success: function (data) { //返回的数据用data.d获取内容 var result = data.d; //console.log("success"+data.d.MsgAlert); if (result.IsSuccess) { window.location.href = result.UrlNav; } else { alert(result.MsgAlert); } }, error: function (XMLHttpRequest, textStatus, errorThrown) { alert(errorThrown + '请求失败'); }, }); }) }); function freshCommentPager() { var pageNum = Math.ceil(commentCount / perPageNum);//分页页码数 var startNum = currentPage - showRange;//开始页码 var endNum = currentPage + showRange;//结束页码 //开始页面小于1 if (startNum - showRange < 1) { startNum = 1; endNum = 1 + showRange * 2; //结束页 不能大于总数 if (endNum > pageNum) { endNum = pageNum } } //最后一页页面大于总页数 if (endNum > pageNum) { endNum = pageNum; startNum = endNum - showRange * 2; //开始页面 不能小于1 if (startNum < 0) { startNum = 1; } } myPager.empty(); m = (currentPage - 1) * perPageNum;//起始位置 n = m + perPageNum;//终止位置 $('.pagerLnk').remove();//移除旧页码 var firstpage = $("<a class='pagerLnk' href=#" + 0 + ">").text('←'); firstpage.click(function loadfirst() { currentPage = 1; freshCommentPager(); //loadComments("replies", 0, perPageNum); }); myPager.append(firstpage);//添加新页码 for (var i = startNum; i <= endNum; i++) { var page = $("<a class='pagerLnk' href=#" + i + ">").text(i); page.click(function getBlogItem() { currentPage = parseInt(this.textContent); m = (currentPage - 1) * perPageNum;//起始位置 n = m + perPageNum;//终止位置 freshCommentPager(); loadBlogComments(557, m, n, "comments"); }); myPager.append(page);//添加新页码 } var lastpage = $("<a class='pagerLnk' href=#" + pageNum + ">").text('→'); lastpage.click(function loadLast() { currentPage = pageNum; freshCommentPager(); }); myPager.append(lastpage);//添加新页码 } //获取一级评论 function loadBlogComments(blogId, m, n, containerID) { //加载的field var field = $('#' + containerID); $.ajax({ url: '/blog/Blogs.asmx/GetBlogComments', ContentType: "application/json;charset=utf-8", dataType: "json", type: "Post", data: "{blogID:" + blogId + ",m:" + m + ",n:" + n + "}", beforeSend: function (x) { x.setRequestHeader("Content-Type", "application/json; charset=utf-8"); }, success: function (result) { field.empty();//清空field var commemts = result.d; $.each(commemts, function GenerateItem(key, comment) { //评论的主容器 var main = $("<div class='column page-comment'>"); //赞成评论按钮 var icon_agree = $("<a><i class='fa fa-thumbs-o-up' style='float:right;'> 赞(" + comment.Statis + ")</i></a>"); icon_agree.click(function () { agreeComment(comment.ID); }); //删除评论 var icon_delete = $("<a><i class='fa fa-close' style='float:right;'></i></a>"); icon_delete.click(function () { deleteComment(comment.ID) }); //回复评论按钮 var icon_reply = $("<a><i class='fa fa-commenting' style='float:right;'> 回复</i></a>"); icon_reply.click(function () { if (div_reply.css("display") == "none") { div_reply.css("display", "inline-block"); } else { div_reply.css("display", "none"); } }); //回复评论文本输入框以及提交按钮 var div_reply = $("<div style='width:100%;display:none;margin:0 auto;margin-top:15px;'>"); var reply_ipt = $("<input type=text placeholder='回复"+comment.Username+":' style='display:inline-block;height:26px;border: solid 1px #a8a295;width:100%;margin:0;padding-right:60px;'>"); var submit_reply = $("<a class='submit_reply'><i class='fa fa-send'>提交</i></a>"); submit_reply.click(function () { div_reply.css("display", "none"); CommentComment(comment, reply_ipt.val(), false); }); div_reply.append(reply_ipt); div_reply.append(submit_reply); //用户头像 var img = $("<img src=" + comment.Photo + " />"); //用户名 var uName = $("<a href='" + comment.Url + "'>" + comment.Username + "</a>"); var uContainer = $("<div class='uContainer'>"); uContainer.append(img); uContainer.append(uName); //用户信息框 main.append(uContainer); //回复内容表 var content = $("<div title='发布时间：" + comment.Time + "' class='page-comment-content'><div style='margin-bottom:20px;'>" + comment.Content + "</div></div>"); var bottom = $("<div style='overflow: hidden;'>"); bottom.append(icon_delete); bottom.append(icon_agree); bottom.append(icon_reply); bottom.append(div_reply); content.append(bottom); //设置下部评论的评论容器id var comments = $("<div/>"); comments.attr("id", "comment" + comment.ID); content.append(comments); main.append(content); loadCommentComment(comment, 0, 10) field.append(main); }) }, error: function (XMLHttpRequest, textStatus, errorThrown) { $("<div title='loadComments出错'>").text(XMLHttpRequest.responseText).dialog(); } }); } function getBlogCommentCount(blogID) { var ar = 30; $.ajax({ url: '/blog/Blogs.asmx/GetBlogCommentCount', //调用WebService的地址和方法名称组合 ---- WsURL/方法名 ContentType: "application/json;charset=utf-8", //WebService 会返回Json类型 dataType: "json", async: false, type: "Post", //访问WebService使用Post方式请求 data: "{blogID:" + blogID + "}", //这里是要传递的参数 beforeSend: function (x) { x.setRequestHeader("Content-Type", "application/json; charset=utf-8"); }, success: function (result) {//回调函数，result，返回值 ar = parseInt(result.d); }, error: function (XMLHttpRequest, textStatus, errorThrown) { $("<div title='loadBlog出错'>").text(XMLHttpRequest.responseText).dialog(); } }); return ar; } function deleteComment(commentID) { if (!confirm("将要删除此评论和所有回复此条的评论，确定吗？")) { return; } $.ajax({ url: '/blog/blogPage.aspx/Delete_Commemt', //调用WebService的地址和方法名称组合 ---- WsURL/方法名 ContentType: "application/json;charset=utf-8", //WebService 会返回Json类型 dataType: "json", async: false, type: "Post", //访问WebService使用Post方式请求 data: "{commentID:" + commentID + "}", //这里是要传递的参数 beforeSend: function (x) { x.setRequestHeader("Content-Type", "application/json; charset=utf-8"); }, success: function (result) {//回调函数，result，返回值 var data = result.d; if (data.IsSuccess) { alert('删除成功'); loadBlogComments(557, m, n, "comments"); freshCommentPager(); } else { alert(data.MsgAlert); } }, error: function (XMLHttpRequest, textStatus, errorThrown) { $("<div title='loadBlog出错'>").text(XMLHttpRequest.responseText).dialog(); } }); } function agreeComment(commentID) { $.ajax({ url: '/blog/blogPage.aspx/Agree_Comment', //调用WebService的地址和方法名称组合 ---- WsURL/方法名 ContentType: "application/json;charset=utf-8", //WebService 会返回Json类型 dataType: "json", async: true, type: "Post", //访问WebService使用Post方式请求 data: "{commentID:" + commentID + "}", //这里是要传递的参数 beforeSend: function (x) { x.setRequestHeader("Content-Type", "application/json; charset=utf-8"); }, success: function (result) {//回调函数，result，返回值 var data = result.d; if (data.IsSuccess) { alert(data.MsgAlert); loadBlogComments(557, m, n, "comments"); freshCommentPager(); } else { alert(data.MsgAlert + "失败"); } }, error: function (XMLHttpRequest, textStatus, errorThrown) { $("<div>").text(XMLHttpRequest.responseText).dialog(); } }); } function submitComment(blogID, content, isNotify) { content = encodeURIComponent(content); $.ajax({ url: '/blog/blogPage.aspx/Submit_Comment', //调用WebService的地址和方法名称组合 ---- WsURL/方法名 ContentType: "application/json;charset=utf-8", //WebService 会返回Json类型 dataType: "json", async: true, type: "Post", data: "{articleId:" + blogID + ",content:'" + content + "',isNotify:" + isNotify + "}", //这里是要传递的参数 beforeSend: function (x) { x.setRequestHeader("Content-Type", "application/json; charset=utf-8"); }, success: function (result) {//回调函数，result，返回值 var data = result.d; if (data.IsSuccess) { alert(data.MsgAlert); loadBlogComments(557, m, n, "comments"); freshCommentPager(); } else { alert(data.MsgAlert); } }, error: function (XMLHttpRequest, textStatus, errorThrown) { $("<div>").text(XMLHttpRequest.responseText).dialog(); } }); } function CommentComment(Comment, content, isNotify,grade=0) { content = encodeURIComponent(content); //console.log(content.length); $.ajax({ url: '/blog/blogPage.aspx/Comment_Comment', //调用WebService的地址和方法名称组合 ---- WsURL/方法名 ContentType: "application/json;charset=utf-8", //WebService 会返回Json类型 dataType: "json", async: true, type: "Post", data: "{CommentID:" + Comment.ID + ",CommentContent:'" + content + "',IsNotify:" + isNotify + "}", //这里是要传递的参数 beforeSend: function (x) { x.setRequestHeader("Content-Type", "application/json; charset=utf-8"); }, success: function (result) {//回调函数，result，返回值 var data = result.d; if (data.IsSuccess) { //清空旧的页面信息 $("#comment" + Comment.ID).empty(); //评论成功后，局部更新页面 if (grade==0) { loadCommentComment(Comment, 0, 10); } else { loadCommentComment(Comment, 0, 10,Comment.Username); } } else { alert(data.MsgAlert); } }, error: function (XMLHttpRequest, textStatus, errorThrown) { $("<div>").text(XMLHttpRequest.responseText).dialog(); } }); } function loadCommentComment(comment, m, n, reply_username = "") { $.ajax({ url: '/blog/blogPage.aspx/Get_Comment_Comment', //调用WebService的地址和方法名称组合 ---- WsURL/方法名 ContentType: "application/json;charset=utf-8", //WebService 会返回Json类型 dataType: "json", async: true, type: "Post", data: "{CommentID:" + comment.ID + ",m:" + m + ",n:" + n + "}", //这里是要传递的参数 beforeSend: function (x) { x.setRequestHeader("Content-Type", "application/json; charset=utf-8"); }, success: function (result) { var field = $("#comment" + comment.ID); $.each(result.d, function (key, comment_1) { var item = $("<div style='padding:5px 0 0 0;font-size:12px;line-height:20px;background: #f6f6f6;border-top:solid 1px #ebdfdf'/>"); item.attr("id", "comment" + comment_1.ID); var photo = $("<img class='photo-small' src='" + comment_1.Photo + "'/>"); var lnk = $("<a style='color:#2d64b3;'>" + comment_1.Username + ":</a>"); var ipt = $("<input type=text placeholder='回复"+comment_1.Username+"：' style='display:inline-block;height:26px;border: solid 1px #a8a295;width:99%;margin:0;padding-right:60px;'>"); var submit_reply = $("<a class='submit_reply'><i class='fa fa-send' >提交</i></a>"); var ipt_div = $("<div style='display:none;width:100%'>"); ipt_div.append(ipt); ipt_div.append(submit_reply); var bottom = $("<div style='overflow: hidden;'>"); var reply_icon = $("<a style='float:right'><i class='fa fa-commenting'/>回复</a>"); reply_icon.click(function () { if (ipt_div.css("display") == "none") { ipt_div.css("display", "inline-block"); } else { ipt_div.css("display", "none"); } }); var delete_icon = $("<a style='float:right;padding:0 8px;color:gray'><i class='fa fa-close'/></a>"); delete_icon.click(function () { deleteComment(comment_1.ID); }); bottom.append(delete_icon); bottom.append(reply_icon) bottom.append(ipt_div); //评论 submit_reply.click(function () { ipt_div.css("display", "none"); CommentComment(comment_1, ipt.val(), false,9527); }); item.append(photo); item.append(lnk); var reply_title = ""; if (reply_username.length > 0) { reply_title = "回复" + reply_username + ":"; } item.append(reply_title + comment_1.Content); item.append(bottom); field.attr("id", "comment" + comment.ID); field.append(item); //加载评论的评论，这里是个递归 loadCommentComment(comment_1, 0, 10, comment_1.Username) }); }, error: function (XMLHttpRequest, textStatus, errorThrown) { $("<div>").text(XMLHttpRequest.responseText).dialog(); } }); } </script> </main> <aside class="pc-only"> <div class="myTitle"> <i class="fa fa-lightbulb-o"></i>推荐 </div> <div class="相关的博客列表"> <ol class="myol" id="relitive-blogs"> </ol> </div> <div id="bdad2" class="bd-Ad"> <script type="text/javascript">(function () { var s = "_" + Math.random().toString(36).slice(2); document.write('<div style="" id="' + s + '"></div>'); (window.slotbydup = window.slotbydup || []).push({ id: "u3576446", container: s }); })();</script> </div> <div class="pc-only"> <div class="myTitle"> <i class="fa fa-lightbulb-o"></i>阅读 </div> <div style="float: left; width: 100%;"> <ol id="random-blogs" class="myol"> </ol> </div> </div> </aside> <script> $(function () { var topic = 'Excel,教程'; var keywords = topic.split(','); //处理关键词链接 $.each(keywords, function (key, value) { var link = $("<a target='_blank' class='keyword' href='../blogItem/" + value + ".html'>" + value + "</a>"); $("#KeywordsContainer").append(link); }) //加载可能感兴趣的博客,拼接sql var searchCmd = "SELECT TOP 10 * FROM[blog]"; for (var i = 0; i < keywords.length; i++) { if (i == 0) { searchCmd += "where [topic] like '%" + keywords[i] + "%'"; } else { searchCmd += "or [topic] like '%" + keywords[i] + "%'"; } } searchCmd += "ORDER BY[statis] DESC,[rateScore] DESC"; var blogs = loadBlogList(searchCmd); var field = $("ol#relitive-blogs"); //field.empty(); $.each(blogs, function (key, value) { var blogList = $("<li class='blogList'>"); var link = $("<a target='_blank' href=" + value.BlogUrl + ">" + value.BlogTitle + "</a>"); blogList.append(link); field.append(blogList); }); //加载随机阅读的博客 var r = 234565182; searchCmd = "SELECT TOP 10 * FROM [blog] ORDER BY Rnd(" + r + "*id) "; blogs = loadBlogList(searchCmd); var field = $("ol#random-blogs"); $.each(blogs, function (key, value) { var blogList = $("<li class='blogList'>"); var link = $("<a target='_blank' href=" + value.BlogUrl + ">" + value.BlogTitle + "</a>"); blogList.append(link); field.append(blogList); }); }); function loadBlogList(sql) { var blogs; $.ajax({ url: "/blog/Blogs.asmx/GetBlogs", //调用WebService的地址和方法名称组合 ---- WsURL/方法名 ContentType: "application/json;charset=utf-8", //WebService 会返回Json类型 dataType: "json", type: "Post", //访问WebService使用Post方式请求 data: "{searchCmd:\"" + sql + "\"}", //这里是要传递的参数 beforeSend: function (x) { x.setRequestHeader("Content-Type", "application/json; charset=utf-8"); }, success: function (result) { blogs = result.d; }, error: function (XMLHttpRequest, textStatus, errorThrown) { $("<div title='loadBlog出错'>").text(sql + XMLHttpRequest.responseText).dialog(); }, async: false, }); return blogs; } </script> <script>var cs = document.getElementsByClassName("prettyprint lang-cs"); while (cs.length > 0) { cs[0].className = "brush: csharp"; } var js = document.getElementsByClassName("prettyprint lang-js"); while (js.length > 0) { js[0].className = "brush: js"; } var xml = document.getElementsByClassName("prettyprint lang-xml"); while (xml.length > 0) { xml[0].className = "brush: xml"; } var html = document.getElementsByClassName("prettyprint lang-html"); while (html.length > 0) { html[0].className = "brush: xml"; } var css = document.getElementsByClassName("prettyprint lang-css"); while (css.length > 0) { css[0].className = "brush: css"; } </script> <script src="https://apps.bdimg.com/libs/SyntaxHighlighter/3.0.83/scripts/shCore.js"></script> <script src="https://apps.bdimg.com/libs/SyntaxHighlighter/3.0.83/scripts/shBrushJScript.js"></script> <script src="https://apps.bdimg.com/libs/SyntaxHighlighter/3.0.83/scripts/shBrushCSharp.js"></script> <script src="https://apps.bdimg.com/libs/SyntaxHighlighter/3.0.83/scripts/shBrushXml.js"></script> <script src="https://apps.bdimg.com/libs/SyntaxHighlighter/3.0.83/scripts/shBrushCss.js"></script> <link href="https://apps.bdimg.com/libs/SyntaxHighlighter/3.0.83/styles/shCoreRDark.css" rel="stylesheet" /> <script>SyntaxHighlighter.all();</script> <script>(function () { var canonicalURL, curProtocol; var x = document.getElementsByTagName("link"); if (x.length > 0) { for (i = 0; i < x.length; i++) { if (x[i].rel.toLowerCase() == 'canonical' && x[i].href) { canonicalURL = x[i].href } } } if (!canonicalURL) { curProtocol = window.location.protocol.split(':')[0] } else { curProtocol = canonicalURL.split(':')[0] } if (!canonicalURL) canonicalURL = window.location.href; !function () { var e = /([http|https]:\/\/[a-zA-Z0-9\_\.]+\.baidu\.com)/gi, r = canonicalURL, t = document.referrer; if (!e.test(r)) { var n = (String(curProtocol).toLowerCase() === 'https') ? "https://sp0.baidu.com/9_Q4simg2RQJ8t7jm9iCKT-xh_/s.gif" : "//api.share.baidu.com/s.gif"; t ? (n += "?r=" + encodeURIComponent(document.referrer), r && (n += "&l=" + r)) : r && (n += "?l=" + r); var i = new Image; i.src = n } }(window) })();</script> </div> <!--footer--> <footer> Copyright©[技术家园] All rights reserved.2017 京ICP备17009470号 <a title="sitemap" href='/sitemap.xml' style="color: #818181; margin: 0;">sitemap</a> </footer> </body> </html>