ProfitSubsidyDetail_Admin.js 17 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420
  1. var ExcelData;
  2. function ConfirmImport() {
  3. $.ajax({
  4. type: "POST",
  5. url: "/Admin/ProfitSubsidyDetail/Import?r=" + Math.random(1),
  6. data: "ExcelData=" + encodeURIComponent(JSON.stringify(ExcelData)),
  7. dataType: "text",
  8. success: function (data) {
  9. if (data == "success") {
  10. layer.msg("导入成功", { time: 2000 }, function () {
  11. window.location.reload();
  12. });
  13. } else {
  14. layer.msg(data);
  15. }
  16. }
  17. });
  18. }
  19. var excel;
  20. layui.config({
  21. base: '/layuiadmin/' //静态资源所在路径
  22. }).extend({
  23. myexcel: 'layui/lay/modules/excel',
  24. index: 'lib/index' //主入口模块
  25. }).use(['index', 'table', 'excel', 'laydate'], function () {
  26. var $ = layui.$
  27. , form = layui.form
  28. , table = layui.table;
  29. //- 筛选条件-日期
  30. var laydate = layui.laydate;
  31. var layCreateDate = laydate.render({
  32. elem: '#CreateDate',
  33. type: 'date',
  34. range: true,
  35. trigger: 'click',
  36. change: function (value, date, endDate) {
  37. var op = true;
  38. if (date.year == endDate.year && endDate.month - date.month <= 1) {
  39. if (endDate.month - date.month == 1 && endDate.date > date.date) {
  40. op = false;
  41. layCreateDate.hint('日期范围请不要超过1个月');
  42. setTimeout(function () {
  43. $(".laydate-btns-confirm").addClass("laydate-disabled");
  44. }, 1);
  45. }
  46. } else {
  47. op = false;
  48. layCreateDate.hint('日期范围请不要超过1个月');
  49. setTimeout(function () {
  50. $(".laydate-btns-confirm").addClass("laydate-disabled");
  51. }, 1);
  52. }
  53. if (op) {
  54. $('#CreateDate').val(value);
  55. }
  56. }
  57. });
  58. laydate.render({
  59. elem: '#TradeMonthSelect'
  60. , type: 'month'
  61. });
  62. //excel导入
  63. excel = layui.excel;
  64. $('#ExcelFile').change(function (e) {
  65. var files = e.target.files;
  66. excel.importExcel(files, { }, function (data) {
  67. ExcelData = data[0].sheet1;
  68. });
  69. });
  70. //监听单元格编辑
  71. table.on('edit(LAY-list-manage)', function(obj){
  72. var value = obj.value //得到修改后的值
  73. ,data = obj.data //得到所在行所有键值
  74. ,field = obj.field; //得到字段
  75. if(field == "Sort"){
  76. $.ajax({
  77. type: "POST",
  78. url: "/Admin/ProfitSubsidyDetail/Sort?r=" + Math.random(1),
  79. data: "Id=" + data.Id + "&Sort=" + value,
  80. dataType: "text",
  81. success: function (data) {
  82. }
  83. });
  84. }
  85. });
  86. //列表数据
  87. table.render({
  88. elem: '#LAY-list-manage'
  89. , url: '/Admin/ProfitSubsidyDetail/IndexData' //模拟接口
  90. , cols: [[
  91. { type: 'checkbox', fixed: 'left' }
  92. ,{field:'RealName', width: 200, title:'补贴创客姓名', sort: true}
  93. ,{field:'MakerCode', width: 200, title:'补贴创客编码', sort: true}
  94. ,{field:'TradeMonth', width: 200, title:'交易月份', sort: true}
  95. ,{field:'BrandId', width: 200, title:'产品类型', sort: true}
  96. ,{field:'MerchantNo', width: 200, title:'商户编号', sort: true}
  97. ,{field:'MerchantName', width: 200, title:'商户姓名', sort: true}
  98. ,{field:'MerNo', width: 200, title:'快钱商户编码', sort: true}
  99. ,{field:'SnNo', width: 200, title:'快钱SN号', sort: true}
  100. ,{field:'MerRegTime', width: 200, title:'快钱注册时间', sort: true}
  101. ,{field:'MerStandardDate', width: 200, title:'商户激活时间', sort: true}
  102. ,{field:'SubsidyType', width: 200, title:'创客分润补贴类型', sort: true}
  103. ,{field:'CreditTradeAmt', width: 300, title:'商户贷记卡交易总金额(元)', sort: true}
  104. ,{field:'QrCreditTradeAmt', width: 300, title:'商户(云闪付)贷记卡交易总金额(元)', sort: true}
  105. ,{field:'NonQrCreditTradeAmt', width: 300, title:'商户(非云闪付)贷记卡交易总金额(元)', sort: true}
  106. ,{field:'CreditProfitRate', width: 300, title:'创客(非云闪付)贷记卡交易分润比例', sort: true}
  107. ,{field:'SubsidyProfitRate', width: 300, title:'创客活动期内直营商户分润万分之十', sort: true}
  108. ,{field:'SubsidyProfit', width: 300, title:'商户(非云闪付)贷记卡交易分润补贴金额(元)', sort: true}
  109. ]]
  110. , where: {
  111. }
  112. , page: true
  113. , limit: 30
  114. , height: 'full-' + String($('.layui-card-header').height() + 130)
  115. , text: '对不起,加载出现异常!'
  116. , done: function (res, curr, count) {
  117. $("#SubsidyProfit").text(res.other.SubsidyProfit);
  118. $(".layui-none").text("无数据");
  119. }
  120. });
  121. //监听工具条
  122. table.on('tool(LAY-list-manage)', function (obj) {
  123. var data = obj.data;
  124. if (obj.event === 'del') {
  125. var index = layer.confirm('确定要删除吗?删除后不能恢复!', function (index) {
  126. $.ajax({
  127. type: "POST",
  128. url: "/Admin/ProfitSubsidyDetail/Delete?r=" + Math.random(1),
  129. data: "Id=" + data.Id,
  130. dataType: "text",
  131. success: function (data) {
  132. if (data == "success") {
  133. obj.del();
  134. layer.close(index);
  135. } else {
  136. parent.layer.msg(data);
  137. }
  138. }
  139. });
  140. });
  141. } else if (obj.event === 'edit') {
  142. var tr = $(obj.tr);
  143. var perContent = layer.open({
  144. type: 2
  145. , title: '分润补贴明细-编辑'
  146. , content: 'Edit?Id=' + data.Id + ''
  147. , maxmin: true
  148. , area: ['500px', '450px']
  149. , btn: ['确定', '取消']
  150. , yes: function (index, layero) {
  151. var iframeWindow = window['layui-layer-iframe' + index]
  152. , submitID = 'LAY-list-front-submit'
  153. , submit = layero.find('iframe').contents().find('#' + submitID);
  154. setTimeout(function () {
  155. layero.find('iframe').contents().find('.layui-tab-item').each(function (i) {
  156. var errObj = $(this).find('.layui-form-danger');
  157. if (errObj.length > 0) {
  158. iframeWindow.element.tabChange('mytabbar', String(i + 1));
  159. submit.click();
  160. }
  161. });
  162. }, 300);
  163. //监听提交
  164. iframeWindow.layui.form.on('submit(' + submitID + ')', function (data) {
  165. var field = data.field; //获取提交的字段
  166. var userdata = "";
  167. for (var prop in field) {
  168. userdata += prop + "=" + encodeURIComponent(field[prop]) + "&";
  169. }
  170. //提交 Ajax 成功后,静态更新表格中的数据
  171. //$.ajax({});
  172. $.ajax({
  173. type: "POST",
  174. url: "/Admin/ProfitSubsidyDetail/Edit?r=" + Math.random(1),
  175. data: userdata,
  176. dataType: "text",
  177. success: function (data) {
  178. layer.close(index); //关闭弹层
  179. if (data == "success") {
  180. table.reload('LAY-list-manage'); //数据刷新
  181. } else {
  182. layer.msg(data);
  183. }
  184. }
  185. });
  186. });
  187. submit.trigger('click');
  188. }
  189. , success: function (layero, index) {
  190. }
  191. });
  192. layer.full(perContent);
  193. }
  194. });
  195. //监听搜索
  196. form.on('submit(LAY-list-front-search)', function (data) {
  197. var field = data.field;
  198. //执行重载
  199. table.reload('LAY-list-manage', {
  200. where: field,
  201. page: {
  202. curr: 1
  203. }
  204. });
  205. });
  206. form.on('submit(LAY-list-front-searchall)', function (data) {
  207. table.reload('LAY-list-manage', {
  208. where: null,
  209. page: {
  210. curr: 1
  211. }
  212. });
  213. });
  214. //事件
  215. var active = {
  216. batchdel: function () {
  217. var checkStatus = table.checkStatus('LAY-list-manage')
  218. , data = checkStatus.data; //得到选中的数据
  219. if (data.length < 1) {
  220. parent.layer.msg("请选择要删除的项");
  221. } else {
  222. var ids = "";
  223. $.each(data, function (index, value) {
  224. ids += data[index].Id + ",";
  225. });
  226. ids = ids.substring(0, ids.length - 1);
  227. var index = layer.confirm('确定要删除吗?删除后不能恢复!', function (index) {
  228. $.ajax({
  229. type: "POST",
  230. url: "/Admin/ProfitSubsidyDetail/Delete?r=" + Math.random(1),
  231. data: "Id=" + ids,
  232. dataType: "text",
  233. success: function (data) {
  234. layer.close(index);
  235. if (data == "success") {
  236. table.reload('LAY-list-manage');
  237. } else {
  238. layer.msg(data);
  239. }
  240. }
  241. });
  242. });
  243. }
  244. }
  245. , add: function () {
  246. var perContent = layer.open({
  247. type: 2
  248. , title: '分润补贴明细-添加'
  249. , content: 'Add'
  250. , maxmin: true
  251. , area: ['500px', '450px']
  252. , btn: ['确定', '取消']
  253. , yes: function (index, layero) {
  254. var iframeWindow = window['layui-layer-iframe' + index]
  255. , submitID = 'LAY-list-front-submit'
  256. , submit = layero.find('iframe').contents().find('#' + submitID);
  257. setTimeout(function () {
  258. layero.find('iframe').contents().find('.layui-tab-item').each(function (i) {
  259. var errObj = $(this).find('.layui-form-danger');
  260. if (errObj.length > 0) {
  261. iframeWindow.element.tabChange('mytabbar', String(i + 1));
  262. submit.click();
  263. }
  264. });
  265. }, 300);
  266. //监听提交
  267. iframeWindow.layui.form.on('submit(' + submitID + ')', function (data) {
  268. var field = data.field; //获取提交的字段
  269. var userdata = "";
  270. for (var prop in field) {
  271. userdata += prop + "=" + encodeURIComponent(field[prop]) + "&";
  272. }
  273. //提交 Ajax 成功后,静态更新表格中的数据
  274. //$.ajax({});
  275. $.ajax({
  276. type: "POST",
  277. url: "/Admin/ProfitSubsidyDetail/Add?r=" + Math.random(1),
  278. data: userdata,
  279. dataType: "text",
  280. success: function (data) {
  281. layer.close(index); //关闭弹层
  282. if (data == "success") {
  283. table.reload('LAY-list-manage'); //数据刷新
  284. } else {
  285. layer.msg(data);
  286. }
  287. }
  288. });
  289. });
  290. submit.trigger('click');
  291. }
  292. });
  293. layer.full(perContent);
  294. }
  295. , ImportData: function () {
  296. layer.open({
  297. type: 1,
  298. title: '导入',
  299. maxmin: false,
  300. area: ['460px', '180px'],
  301. content: $('#excelForm'),
  302. cancel: function () {
  303. }
  304. });
  305. }
  306. , ExportExcel: function () {
  307. var userdata = '';
  308. $(".layuiadmin-card-header-auto input").each(function (i) {
  309. userdata += $(this).attr('name') + '=' + encodeURIComponent($(this).val()) + '&';
  310. });
  311. $(".layuiadmin-card-header-auto select").each(function (i) {
  312. userdata += $(this).attr('name') + '=' + encodeURIComponent($(this).val()) + '&';
  313. });
  314. $.ajax({
  315. type: "GET",
  316. url: "/Admin/ProfitSubsidyDetail/ExportExcel?r=" + Math.random(1),
  317. data: userdata,
  318. dataType: "json",
  319. success: function (data) {
  320. data.Obj.unshift(data.Fields);
  321. excel.exportExcel(data.Obj, data.Info, 'xlsx');
  322. }
  323. });
  324. }
  325. , Open: function () {
  326. var checkStatus = table.checkStatus('LAY-list-manage')
  327. , data = checkStatus.data; //得到选中的数据
  328. if(data.length < 1){
  329. parent.layer.msg("请选择要开启的项");
  330. }else{
  331. var ids = "";
  332. $.each(data, function (index, value) {
  333. ids += data[index].Id + ",";
  334. });
  335. ids = ids.substring(0, ids.length - 1);
  336. var index = layer.confirm('确定要开启吗?', function (index) {
  337. $.ajax({
  338. type: "POST",
  339. url: "/Admin/ProfitSubsidyDetail/Open?r=" + Math.random(1),
  340. data: "Id=" + ids,
  341. dataType: "text",
  342. success: function (data) {
  343. layer.close(index);
  344. if (data == "success") {
  345. table.reload('LAY-list-manage');
  346. } else {
  347. layer.msg(data);
  348. }
  349. }
  350. });
  351. });
  352. }
  353. }
  354. , Close: function () {
  355. var checkStatus = table.checkStatus('LAY-list-manage')
  356. , data = checkStatus.data; //得到选中的数据
  357. if(data.length < 1){
  358. parent.layer.msg("请选择要关闭的项");
  359. }else{
  360. var ids = "";
  361. $.each(data, function (index, value) {
  362. ids += data[index].Id + ",";
  363. });
  364. ids = ids.substring(0, ids.length - 1);
  365. var index = layer.confirm('确定要关闭吗?', function (index) {
  366. $.ajax({
  367. type: "POST",
  368. url: "/Admin/ProfitSubsidyDetail/Close?r=" + Math.random(1),
  369. data: "Id=" + ids,
  370. dataType: "text",
  371. success: function (data) {
  372. layer.close(index);
  373. if (data == "success") {
  374. table.reload('LAY-list-manage');
  375. } else {
  376. layer.msg(data);
  377. }
  378. }
  379. });
  380. });
  381. }
  382. }
  383. };
  384. $('.layui-btn').on('click', function () {
  385. var type = $(this).data('type');
  386. active[type] ? active[type].call(this) : '';
  387. });
  388. });