From cc170291673472d3cda8d7ea77f6bd3a3b5dbb83 Mon Sep 17 00:00:00 2001 From: username@email.com <yzy2002yzy@163.com> Date: 星期一, 09 九月 2024 14:06:09 +0800 Subject: [PATCH] 增加了一些统计修改 --- CoreCms.Net.Web.Admin/wwwroot/views/corecmsplanorder/index.html | 327 ++++++++++++++++++++++++++++++++++++++++++++++-------- 1 files changed, 277 insertions(+), 50 deletions(-) diff --git a/CoreCms.Net.Web.Admin/wwwroot/views/corecmsplanorder/index.html b/CoreCms.Net.Web.Admin/wwwroot/views/corecmsplanorder/index.html index 3286391..07900f9 100644 --- a/CoreCms.Net.Web.Admin/wwwroot/views/corecmsplanorder/index.html +++ b/CoreCms.Net.Web.Admin/wwwroot/views/corecmsplanorder/index.html @@ -33,24 +33,47 @@ <input type="text" name="orderAmount" placeholder="璇疯緭鍏ヨ皟鏁磋鍗曢噾棰�" class="layui-input"> </div> </div>--> - + <div class="layui-inline"> <label class="layui-form-label" for="status">璁㈠崟鐘舵��</label> - <div class="layui-input-inline"> - <select name="status"> - <option value="">璇烽�夋嫨</option> - <option value="1">鏈彁浜�</option> - <option value="2">宸叉彁浜�</option> - </select> - </div> - </div> + <div class="layui-input-inline"> + <select name="status"> + <option value="">璇烽�夋嫨</option> + <option value="1">鏈攣鍗�</option> + <option value="2">宸查攣鍗�</option> + </select> + </div> + </div> <!--<div class="layui-inline"> <label class="layui-form-label" for="userId">鐢ㄦ埛ID 鍏宠仈user.id</label> <div class="layui-input-inline"> <input type="text" name="userId" placeholder="璇疯緭鍏ョ敤鎴稩D 鍏宠仈user.id" class="layui-input"> </div> </div>--> + <div class="layui-inline"> + <label class="layui-form-label" for="shi">甯�</label> + <div class="layui-input-inline"> + <!--<input type="text" name="shi" placeholder="璇疯緭鍏ュ競" class="layui-input">--> + + <select name="shi" id="shi" lay-filter="cityFilter" > + <option value="0">璇烽�夋嫨</option> + {{# layui.each(indexData, function(index, item){ }} + <option value="{{ item.id }}">{{ item.name }}</option> + {{# }); }} + </select> + </div> + </div> + <div class="layui-inline"> + <label class="layui-form-label" for="quxian">鍖哄幙</label> + <div class="layui-input-inline"> + <!--<input type="text" name="quxian" placeholder="璇疯緭鍏ュ尯鍘�" class="layui-input">--> + <select name="quxian" id="quxian" lay-filter="quxian"> + + + </select> + </div> + </div> <div class="layui-inline"> <label class="layui-form-label" for="shipAddress">瀛︽牎</label> <div class="layui-input-inline"> @@ -67,6 +90,12 @@ <label class="layui-form-label" for="shipMobile">鑱旂郴鐢佃瘽</label> <div class="layui-input-inline"> <input type="text" name="shipMobile" placeholder="璇疯緭鍏ヨ仈绯荤數璇�" class="layui-input"> + </div> + </div> + <div class="layui-inline"> + <label class="layui-form-label" for="shouhuoAddress">鏀惰揣鍦板潃</label> + <div class="layui-input-inline"> + <input type="text" name="shouhuoAddress" placeholder="鏀惰揣鍦板潃" class="layui-input"> </div> </div> <!--<div class="layui-inline"> @@ -117,26 +146,37 @@ </div>--> <div class="layui-inline"> <button class="layui-btn layui-btn-sm" lay-submit lay-filter="LAY-app-CoreCmsPlanOrder-search"><i class="layui-icon layui-icon-search"></i>绛涢��</button> + <button class="layui-btn layui-btn-sm" lay-submit lay-filter="LAY-app-doBatchDelete"><i class="layui-icon layui-icon-add-circle"></i>鎵归噺閿佸崟</button> + <button class="layui-btn layui-btn-sm" lay-submit lay-filter="LAY-app-selectchakan"><i class="layui-icon layui-icon-add-circle"></i>鎵归噺鏌ョ湅</button> + <button type="button" class="layui-btn layui-btn-sm" id="upIndexPopupWindowImageUrlBtn">涓婁紶璁″垝璁㈠崟</button> + <button class="layui-btn layui-btn-sm" lay-submit lay-filter="LAY-app-selectExportExcel"><i class="layui-icon layui-icon-add-circle"></i>閫夋嫨瀵煎嚭</button> + <button class="layui-btn layui-btn-sm" lay-submit lay-filter="LAY-app-queryExportExcel"><i class="layui-icon layui-icon-download-circle"></i>鏌ヨ瀵煎嚭</button> + <a class="layui-btn layui-btn-sm" href="/static/jihuageshi/涓婁紶璁″垝璁㈠崟.xlsx">涓婁紶妯℃澘</a> + + <button class="layui-btn layui-btn-sm" lay-submit lay-filter="LAY-app-DeldoBatchDelete"><i class="layui-icon layui-icon-delete"></i>鎵归噺鍒犻櫎</button> </div> </div> </div> </script> <script type="text/html" id="LAY-app-CoreCmsPlanOrder-pagebar"> + <div class="layui-btn-container"> <!--<button class="layui-btn layui-btn-sm" lay-event="addData"><i class="layui-icon layui-icon-add-1"></i>娣诲姞鏁版嵁</button> - <button class="layui-btn layui-btn-sm" lay-event="batchDelete"><i class="layui-icon layui-icon-delete"></i>鎵归噺鍒犻櫎</button>--> - <button type="button" class="layui-btn layui-btn-sm" id="upIndexPopupWindowImageUrlBtn">涓婁紶璁″垝璁㈠崟</button> + <button class="layui-btn layui-btn-sm" lay-event="batchDelete"><i class="layui-icon layui-icon-delete"></i>鎵归噺鍒犻櫎</button>--> + <!--<button type="button" class="layui-btn layui-btn-sm" id="upIndexPopupWindowImageUrlBtn">涓婁紶璁″垝璁㈠崟</button> <button class="layui-btn layui-btn-sm" lay-event="selectExportExcel"><i class="layui-icon layui-icon-add-circle"></i>閫夋嫨瀵煎嚭</button> <button class="layui-btn layui-btn-sm" lay-event="queryExportExcel"><i class="layui-icon layui-icon-download-circle"></i>鏌ヨ瀵煎嚭</button> - <a class="layui-btn layui-btn-sm" href="/static/jihuageshi/涓婁紶璁″垝璁㈠崟.xlsx" >涓婁紶妯℃澘</a> + <a class="layui-btn layui-btn-sm" href="/static/jihuageshi/涓婁紶璁″垝璁㈠崟.xlsx" >涓婁紶妯℃澘</a>--> </div> </script> <script type="text/html" id="LAY-app-CoreCmsPlanOrder-tableBox-bar"> <a class="layui-btn layui-btn-primary layui-btn-xs" lay-event="detail">鏌ョ湅</a> - <!--<a class="layui-btn layui-btn-xs" lay-event="edit">缂栬緫</a> - <a class="layui-btn layui-btn-danger layui-btn-xs" data-dropdown="#CoreCmsPlanOrderTbDelDrop{{d.LAY_INDEX}}" no-shade="true">鍒犻櫎</a>--> + <a class="layui-btn layui-btn-xs" lay-event="edit">淇敼</a> + <a class="layui-btn layui-btn-xs" lay-event="del">閿佸崟</a> + <a class="layui-btn layui-btn-xs" lay-event="deldel">鍒犻櫎</a> + <!--<a class="layui-btn layui-btn-danger layui-btn-xs" data-dropdown="#CoreCmsPlanOrderTbDelDrop{{d.LAY_INDEX}}" no-shade="true">鍒犻櫎</a> <div class="dropdown-menu-nav dropdown-popconfirm dropdown-top-right layui-hide" id="CoreCmsPlanOrderTbDelDrop{{d.LAY_INDEX}}" style="max-width: 200px;white-space: normal;min-width: auto;margin-left: 10px;"> <div class="dropdown-anchor"></div> @@ -148,10 +188,11 @@ <a class="layui-btn layui-btn-primary cursor" btn-cancel>鍙栨秷</a> <a class="layui-btn layui-btn-normal cursor" lay-event="del">纭畾</a> </div> - </div> + </div>--> </script> <script> + var indexData; var debug= layui.setter.debug; layui.data.done = function (d) { @@ -181,6 +222,74 @@ //鎵ц閲嶈浇 table.reloadData('LAY-app-CoreCmsPlanOrder-tableBox',{ where: field }); }); + + //鐩戝惉鎼滅储 + form.on('submit(LAY-app-selectExportExcel)', + function (data) { + var checkStatus = table.checkStatus("LAY-app-CoreCmsPlanOrder-tableBox"); + doSelectExportExcel(checkStatus); + }); + + //鐩戝惉鎼滅储 + form.on('submit(LAY-app-selectchakan)', + function (data) { + var checkStatus = table.checkStatus("LAY-app-CoreCmsPlanOrder-tableBox"); + doSelectselectchakan(checkStatus); + }); + + //鐩戝惉鎼滅储 + form.on('submit(LAY-app-doBatchDelete)', + function (data) { + var checkStatus = table.checkStatus("LAY-app-CoreCmsPlanOrder-tableBox"); + doBatchDelete(checkStatus); + }); + + + //鐩戝惉鎼滅储 + form.on('submit(LAY-app-DeldoBatchDelete)', + function (data) { + var checkStatus = table.checkStatus("LAY-app-CoreCmsPlanOrder-tableBox"); + doBatchDeleteDel(checkStatus); + }); + + + //鐩戝惉鎼滅储 + form.on('submit(LAY-app-queryExportExcel)', + function (data) { + doQueryExportexcel(); + }); + // 鐩戝惉鎻愪氦浜嬩欢 + form.on('select(cityFilter)', function (data) { + var city = $("#shi").val(); + $.ajax({ + type: "GET", + url: layui.setter.apiUrl + 'Api/CoreCmsPlanOrder/GetAreaId?cityid=' + city, + dataType: "json", + global: false, + data: "", + success: function (data) { + console.log(data.data); + var quxian = $("#quxian"); + quxian.find('option').remove(); + var aaa = '<option value="0">璇烽�夋嫨</option>'; + quxian.append(aaa); + if (data.data.length > 0) { + for (var i = 0; i < data.data.length; i++) { + + var o = '<option value="' + data.data[i].id + '" >' + data.data[i].name + '</option>'; + quxian.append(o); + } + // 浣跨敤form.render鏂规硶閲嶆柊娓叉煋select + form.render('select'); + } + }, + error: function () { + + + parent.layer.msg('澶辫触', { icon: 5 }); + } + }); + }); //鏁版嵁缁戝畾 table.render({ elem: '#LAY-app-CoreCmsPlanOrder-tableBox', @@ -197,26 +306,42 @@ text: {none: '鏆傛棤鐩稿叧鏁版嵁'}, cols: [ [ - { type: "checkbox", fixed: "left" }, - { field: 'orderId', title: '璁㈠崟鍙�', sort: false,width: 115 }, - - + { type: "checkbox" }, + { field: 'zizeng', width: 50, title: '搴忓彿', type: 'numbers' }, + { field: 'orderId', title: '璁㈠崟鍙�', sort: false,width: 135 }, + { field: 'shi', title: '甯�', sort: false, width: 50 }, + { field: 'quxian', title: '鍖哄幙', sort: false, width: 50 }, + { field: 'pianqu', title: '鐗囧尯', sort: false, width: 65 }, /* { field: 'userId', title: '鐢ㄦ埛ID 鍏宠仈user.id', sort: false,width: 105 },*/ - { field: 'shipAddress', title: '瀛︽牎', sort: false,width: 335 }, - { field: 'shipName', title: '鑱旂郴浜�', sort: false,width: 115 }, - { field: 'shipMobile', title: '鑱旂郴鐢佃瘽', sort: false,width: 115 }, - { field: 'oldOrderAmount', title: '璁″垝閲戦', sort: false, width: 115 }, - { field: 'orderAmount', title: '璋冩暣閲戦', sort: false, width: 115 }, - { field: 'keYongAmount', title: '鍙敤浣欓', sort: false,width: 115 }, - { field: 'createTime', title: '寤虹珛鏃堕棿', width: 140, sort: false}, - { field: 'upDataTime', title: '淇敼鏃堕棿', width: 140, sort: false}, + { field: 'shipAddress', title: '瀛︽牎', sort: false, width: 135 }, + { field: 'shipName', title: '鑱旂郴浜�', sort: false,width: 55 }, + { field: 'shipMobile', title: '鑱旂郴鐢佃瘽', sort: false, width: 115 }, + { field: 'shouhuoAddress', title: '鏀惰揣鍦板潃', sort: false, width: 165 }, + { field: 'oldOrderAmount', title: '璁″垝閲戦', sort: false, width: 75 }, + { field: 'orderAmount', title: '璋冩暣閲戦', sort: false, width: 75 }, + { field: 'keYongAmount', title: '鍙敤浣欓', sort: false, width: 65 }, + { field: 'createTime', title: '寤虹珛鏃堕棿', width: 95, sort: false}, + { field: 'upDataTime', title: '淇敼鏃堕棿', width: 95, sort: false}, //{ field: 'createBy', title: '鍒涘缓浜�', sort: false,width: 105 }, //{ field: 'upDataBy', title: '淇敼浜�', sort: false,width: 105 }, //{ field: 'isdelete', title: '鍒犻櫎鏍囧織', width: 95, templet: '#switch_isdelete', sort: false , unresize: true}, - { field: 'statusText', title: '璁㈠崟鐘舵��', sort: false, width: 115 }, - { width: 172, align: 'center', title:'鎿嶄綔', fixed: 'right', toolbar: '#LAY-app-CoreCmsPlanOrder-tableBox-bar' } + { field: 'statusText', title: '璁㈠崟鐘舵��', sort: false, width: 55 }, + { width: 222, align: 'center', title:'鎿嶄綔', toolbar: '#LAY-app-CoreCmsPlanOrder-tableBox-bar' } ] - ] + ], done: function (res, curr, count) { + + console.log(res); + // 鍒涘缓鍚堣琛岀殑HTML + var totalRowHtml = '<tr class="layui-table-total" style="background-color: #f2f2f2; font-weight: bold;">\ + <td></td><td></td><td colspan="8">褰撻〉鍚堣</td><td> '+ res.otherData.heji1 + '</td><td> ' + res.otherData.heji2 + '</td><td> ' + res.otherData.heji3 + '</td><td></td><td></td><td></td><td></td>\ + </tr>\ + <tr class="layui-table-total" style="background-color: #e9e9e9; font-weight: bold;">\ + <td></td><td></td><td colspan="8">鎬诲悎璁�</td><td> '+ res.otherData.heji4 + '</td><td> ' + res.otherData.heji5 + '</td><td> ' + res.otherData.heji6 + '</td><td></td><td></td><td></td><td></td>\ + </tr>'; + + // 灏嗗悎璁¤娣诲姞鍒拌〃鏍煎簳閮� + $('#LAY-app-CoreCmsPlanOrder-tableBox').next().find('.layui-table-body tbody').append(totalRowHtml); + } }); //鐩戝惉鎺掑簭浜嬩欢 table.on('sort(LAY-app-CoreCmsPlanOrder-tableBox)', function(obj){ @@ -260,7 +385,9 @@ doDelete(obj); } else if (obj.event === 'edit') { doEdit(obj) - } + } else if (obj.event === 'deldel') { + doDeletedel(obj); + } }); //鎵ц鍒涘缓鎿嶄綔 function doCreate(){ @@ -309,7 +436,7 @@ } //鎵ц缂栬緫鎿嶄綔 function doEdit(obj){ - coreHelper.Post("Api/CoreCmsPlanOrder/GetEdit", {id:obj.data.id}, function (e) { + coreHelper.Post("Api/CoreCmsPlanOrder/GetEdit", { id: obj.data.orderId }, function (e) { if (e.code === 0) { admin.popup({ shadeClose: false, @@ -317,15 +444,31 @@ area: ['1200px', '90%'], id: 'LAY-popup-CoreCmsPlanOrder-edit', success: function (layero, index) { - view(this.id).render('base/CoreCmsPlanOrder/edit', { data: e.data }).done(function () { + view(this.id).render('CoreCmsPlanOrder/edit', { data: e.data }).done(function () { //鐩戝惉鎻愪氦 form.on('submit(LAY-app-CoreCmsPlanOrder-editForm-submit)', function(data) { var field = data.field; //鑾峰彇鎻愪氦鐨勫瓧娈� - - field.isdelete = field.isdelete == 'on'; + + //field.isdelete = field.isdelete == 'on'; + delete field["itemNumarray"]; + var newarray = Array(); + for (v = 0; v < $("input[name='itemNumarray']").size(); v++) { + newarray.push($("input[name='itemNumarray']:eq("+v+")").val()) + } + field["itemNumarray"] = newarray; + + + delete field["itemIdarray"]; + var newarray = Array(); + for (v = 0; v < $("input[name='itemIdarray']").size(); v++) { + newarray.push($("input[name='itemIdarray']:eq(" + v + ")").val()) + } + field["itemIdarray"] = newarray; + if (debug) { console.log(field); } //寮�鍚皟璇曡繑鍥炴暟鎹� + console.log(field); //鎻愪氦 Ajax 鎴愬姛鍚庯紝鍏抽棴褰撳墠寮瑰眰骞堕噸杞借〃鏍� coreHelper.Post("Api/CoreCmsPlanOrder/DoEdit", field, function (e) { console.log(e) @@ -340,7 +483,7 @@ }); }) // 绂佹寮圭獥鍑虹幇婊氬姩鏉� - $(layero).children('.layui-layer-content').css('overflow', 'visible'); + /* $(layero).children('.layui-layer-content').css('overflow', 'visible');*/ } , btn: ['纭畾', '鍙栨秷'] , yes: function (index, layero) { @@ -366,7 +509,7 @@ form.render(); }); // 绂佹寮圭獥鍑虹幇婊氬姩鏉� - $(layero).children('.layui-layer-content').css('overflow', 'visible'); + /* $(layero).children('.layui-layer-content').css('overflow', 'visible');*/ } }); } else { @@ -375,25 +518,48 @@ }); } //鎵ц鍗曚釜鍒犻櫎 - function doDelete(obj){ - coreHelper.Post("Api/CoreCmsPlanOrder/DoDelete", { id: obj.data.id }, function (e) { - if (debug) { console.log(e); } //寮�鍚皟璇曡繑鍥炴暟鎹� - table.reloadData('LAY-app-CoreCmsPlanOrder-tableBox'); - layer.msg(e.msg); + function doDelete(obj) { + if (obj.data.status == 2) { + layer.msg("宸茬粡閿佸崟锛�"); + return; + } + layer.confirm('纭畾閿佸崟鍚楋紵', + function (index) { + coreHelper.Post("Api/CoreCmsPlanOrder/DoDelete", { id: obj.data.orderId }, function (e) { + if (debug) { console.log(e); } //寮�鍚皟璇曡繑鍥炴暟鎹� + table.reloadData('LAY-app-CoreCmsPlanOrder-tableBox'); + layer.msg(e.msg); + }); +}); + + } + //鎵ц鍗曚釜鍒犻櫎 + function doDeletedel(obj) { + layer.confirm('纭畾鍒犻櫎鍚楋紵', + function (index) { + coreHelper.Post("Api/CoreCmsPlanOrder/DoDeletedel", { id: obj.data.orderId }, function (e) { + if (debug) { console.log(e); } //寮�鍚皟璇曡繑鍥炴暟鎹� + table.reloadData('LAY-app-CoreCmsPlanOrder-tableBox'); + layer.msg(e.msg); + }); }); - } + + } + + + //鎵ц鎵归噺鍒犻櫎 function doBatchDelete(checkStatus){ var checkData = checkStatus.data; if (checkData.length === 0) { - return layer.msg('璇烽�夋嫨瑕佸垹闄ょ殑鏁版嵁'); + return layer.msg('璇烽�夋嫨瑕侀攣鍗曠殑鏁版嵁'); } - layer.confirm('纭畾鍒犻櫎鍚楋紵鍒犻櫎鍚庡皢鏃犳硶鎭㈠銆�', + layer.confirm('纭畾閿佸崟鍚楋紵閿佸崟鍚庡皢鏃犳硶淇敼銆�', function(index) { var delidsStr = []; layui.each(checkData, function(index, item) { - delidsStr.push(item.id); + delidsStr.push(item.orderId); }); coreHelper.Post("Api/CoreCmsPlanOrder/DoBatchDelete", { id: delidsStr }, function (e) { if (debug) { console.log(e); } //寮�鍚皟璇曡繑鍥炴暟鎹� @@ -401,7 +567,29 @@ layer.msg(e.msg); }); }); - } + } + + //鎵ц鎵归噺鍒犻櫎 + function doBatchDeleteDel(checkStatus) { + var checkData = checkStatus.data; + if (checkData.length === 0) { + return layer.msg('璇烽�夋嫨瑕佸垹闄ょ殑鏁版嵁'); + } + layer.confirm('纭畾鍒犻櫎鍚楋紵', + function (index) { + var delidsStr = []; + layui.each(checkData, + function (index, item) { + delidsStr.push(item.orderId); + }); + coreHelper.Post("Api/CoreCmsPlanOrder/DoBatchDeletedel", { id: delidsStr }, function (e) { + if (debug) { console.log(e); } //寮�鍚皟璇曡繑鍥炴暟鎹� + table.reloadData('LAY-app-CoreCmsPlanOrder-tableBox'); + layer.msg(e.msg); + }); + }); + } + //鎵ц鏌ヨ鏉′欢瀵煎嚭excel function doQueryExportexcel(){ layer.confirm('纭畾鏍规嵁褰撳墠鐨勬煡璇㈡潯浠跺鍑烘暟鎹悧锛�', @@ -416,7 +604,42 @@ } }); }); - } + } + + + //鎵ц閫夋嫨鐩綍瀵煎嚭鏁版嵁 + function doSelectselectchakan(checkStatus) { + var checkData = checkStatus.data; + if (checkData.length === 0) { + return layer.msg('璇烽�夋嫨鎮ㄨ鏌ョ湅鐨勬暟鎹�'); + } + var delidsStr = []; + layui.each(checkData, + function (index, item) { + delidsStr.push(item.orderId); + }); + + coreHelper.Post("Api/CoreCmsPlanOrder/Selectselectchakan", { id: delidsStr }, function (e) { + if (e.code === 0) { + admin.popup({ + shadeClose: false, + title: '鏌ョ湅璇︽儏', + area: ['1200px', '90%'], + id: 'LAY-popup-CoreCmsPlanOrder-details', + success: function (layero, index) { + view(this.id).render('CoreCmsPlanOrder/Selectselectchakan', { data: e.data }).done(function () { + form.render(); + }); + // 绂佹寮圭獥鍑虹幇婊氬姩鏉� + /* $(layero).children('.layui-layer-content').css('overflow', 'visible');*/ + } + }); + } else { + layer.msg(e.msg); + } + }); + } + //鎵ц閫夋嫨鐩綍瀵煎嚭鏁版嵁 function doSelectExportExcel(checkStatus){ var checkData = checkStatus.data; @@ -428,11 +651,11 @@ var delidsStr = []; layui.each(checkData, function(index, item) { - delidsStr.push(item.id); + delidsStr.push(item.orderId); }); layer.close(index); coreHelper.Post("Api/CoreCmsPlanOrder/SelectExportExcel", { id: delidsStr }, function (e) { - if (debug) { console.log(e); } //寮�鍚皟璇曡繑鍥炴暟鎹� + if (debug) { console.log(e); } //寮�鍚皟璇曡繑鍥炴暟鎹� if (e.code === 0) { window.open(e.data); } else { @@ -486,6 +709,10 @@ form.render(); }); }; + + + + </script> <!--璁剧疆鍒犻櫎鏍囧織--> -- Gitblit v1.9.1