UserCashRecord_Admin.js 27 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690
  1. var ExcelData;
  2. function ConfirmImport() {
  3. $.ajax({
  4. type: "POST",
  5. url: "/Admin/UserCashRecord/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("导入成功", {
  11. time: 2000
  12. }, function () {
  13. window.location.reload();
  14. });
  15. } else {
  16. layer.msg(data);
  17. }
  18. }
  19. });
  20. }
  21. function CheckImport(table, key, loadindex, index) {
  22. $.ajax({
  23. url: "/Admin/UserCashRecord/CheckImport?r=" + Math.random(1),
  24. data: "key=" + key,
  25. dataType: "text",
  26. success: function (data) {
  27. if (data.indexOf('success') == 0) {
  28. layer.msg("成功操作" + data.split('|')[1] + "笔提现申请", { time: 2000 }, function () {
  29. layer.close(index); //关闭弹层
  30. layer.close(loadindex);
  31. table.reload('LAY-list-manage'); //数据刷新
  32. });
  33. } else {
  34. layer.msg(data, { time: 1000 }, function () {
  35. CheckImport(table, key, loadindex, index);
  36. });
  37. }
  38. }
  39. });
  40. }
  41. var excel;
  42. layui.config({
  43. base: '/layuiadmin/' //静态资源所在路径
  44. }).extend({
  45. myexcel: 'layui/lay/modules/excel',
  46. index: 'lib/index' //主入口模块
  47. }).use(['index', 'table', 'excel', 'laydate'], function () {
  48. var $ = layui.$,
  49. form = layui.form,
  50. table = layui.table;
  51. //- 筛选条件-日期
  52. var laydate = layui.laydate;
  53. var layCreateDate = laydate.render({
  54. elem: '#CreateDate',
  55. type: 'date',
  56. range: true,
  57. trigger: 'click',
  58. change: function (value, date, endDate) {
  59. var op = true;
  60. if (date.year == endDate.year && endDate.month - date.month <= 1) {
  61. if (endDate.month - date.month == 1 && endDate.date > date.date) {
  62. op = false;
  63. layCreateDate.hint('日期范围请不要超过1个月');
  64. setTimeout(function () {
  65. $(".laydate-btns-confirm").addClass("laydate-disabled");
  66. }, 1);
  67. }
  68. } else {
  69. op = false;
  70. layCreateDate.hint('日期范围请不要超过1个月');
  71. setTimeout(function () {
  72. $(".laydate-btns-confirm").addClass("laydate-disabled");
  73. }, 1);
  74. }
  75. if (op) {
  76. $('#CreateDate').val(value);
  77. }
  78. }
  79. });
  80. //excel导入
  81. excel = layui.excel;
  82. $('#ExcelFile').change(function (e) {
  83. var files = e.target.files;
  84. excel.importExcel(files, {}, function (data) {
  85. ExcelData = data[0].sheet1;
  86. });
  87. });
  88. //监听单元格编辑
  89. table.on('edit(LAY-list-manage)', function (obj) {
  90. var value = obj.value //得到修改后的值
  91. ,
  92. data = obj.data //得到所在行所有键值
  93. ,
  94. field = obj.field; //得到字段
  95. if (field == "Sort") {
  96. $.ajax({
  97. type: "POST",
  98. url: "/Admin/UserCashRecord/Sort?r=" + Math.random(1),
  99. data: "Id=" + data.Id + "&Sort=" + value,
  100. dataType: "text",
  101. success: function (data) {}
  102. });
  103. }
  104. });
  105. //列表数据
  106. table.render({
  107. elem: '#LAY-list-manage',
  108. url: '/Admin/UserCashRecord/IndexData' //模拟接口
  109. ,
  110. cols: [
  111. [{
  112. type: 'checkbox',
  113. fixed: 'left'
  114. }, {
  115. field: 'CashOrderNo',
  116. width: 200,
  117. title: '提现单号',
  118. sort: true
  119. }, {
  120. field: 'MakerCode',
  121. width: 200,
  122. title: '创客编码',
  123. sort: true
  124. }, {
  125. field: 'RealName',
  126. width: 200,
  127. title: '创客名称',
  128. sort: true
  129. }, {
  130. field: 'IdCardNo',
  131. width: 200,
  132. title: '身份证号',
  133. sort: true
  134. }, {
  135. field: 'SettleBankCardNo',
  136. width: 200,
  137. title: '提现卡号',
  138. sort: true
  139. }, {
  140. field: 'SettleBankName',
  141. width: 200,
  142. title: '银行名称',
  143. sort: true
  144. }, {
  145. field: 'TradeType',
  146. width: 200,
  147. title: '交易类型',
  148. sort: true
  149. }, {
  150. field: 'TradeAmount',
  151. width: 200,
  152. title: '提现金额(元)',
  153. sort: true
  154. }, {
  155. field: 'ActualTradeAmount',
  156. width: 200,
  157. title: '发佣金额(元)',
  158. sort: true
  159. }, {
  160. field: 'ManageFee',
  161. width: 200,
  162. title: '交易扣税(元)',
  163. sort: true
  164. }, {
  165. field: 'TradeFee',
  166. width: 200,
  167. title: '交易手续费(元)',
  168. sort: true
  169. }, {
  170. field: 'StatusName',
  171. width: 200,
  172. title: '订单状态',
  173. templet: '#StatusTpl',
  174. sort: true
  175. }, {
  176. field: 'LockName',
  177. width: 200,
  178. title: '提现标记',
  179. sort: true
  180. }, {
  181. field: 'ReturnCode',
  182. width: 200,
  183. title: '提现服务返回编码',
  184. sort: true
  185. }, {
  186. field: 'ReturnMsg',
  187. width: 200,
  188. title: '提现服务返回信息',
  189. sort: true
  190. }, {
  191. field: 'CreateDate',
  192. width: 200,
  193. title: '创建时间',
  194. sort: true
  195. }, { title: '操作', align: 'center', width: 300, fixed: 'right', toolbar: '#table-list-tools' }
  196. ]
  197. ],
  198. where: {
  199. },
  200. page: true,
  201. limit: 30,
  202. height: 'full-' + String($('.layui-card-header').height() + 130),
  203. text: '对不起,加载出现异常!',
  204. done: function (res, curr, count) {
  205. $("#SuccessAmount").text(res.other.SuccessAmount);
  206. $("#FailAmount").text(res.other.FailAmount);
  207. $("#WaitAmount").text(res.other.WaitAmount);
  208. $("#WaitTaxAmount").text(res.other.WaitTaxAmount);
  209. $("#SuccessTaxAmount").text(res.other.SuccessTaxAmount);
  210. $("#FailTaxAmount").text(res.other.FailTaxAmount);
  211. $(".layui-none").text("无数据");
  212. }
  213. });
  214. //监听工具条
  215. table.on('tool(LAY-list-manage)', function (obj) {
  216. var data = obj.data;
  217. if (obj.event === 'del') {
  218. var index = layer.confirm('确定要删除吗?删除后不能恢复!', function (index) {
  219. $.ajax({
  220. type: "POST",
  221. url: "/Admin/UserCashRecord/Delete?r=" + Math.random(1),
  222. data: "Id=" + data.Id,
  223. dataType: "text",
  224. success: function (data) {
  225. if (data == "success") {
  226. obj.del();
  227. layer.close(index);
  228. } else {
  229. parent.layer.msg(data);
  230. }
  231. }
  232. });
  233. });
  234. } else if (obj.event === 'cancel') {
  235. var index = layer.confirm('确定要解除吗?操作后不能恢复!', function (index) {
  236. $.ajax({
  237. type: "POST",
  238. url: "/Admin/UserCashRecord/Cancel?r=" + Math.random(1),
  239. data: "Id=" + data.Id,
  240. dataType: "text",
  241. success: function (data) {
  242. layer.close(index);
  243. if (data == "success") {
  244. parent.layer.msg('已解除');
  245. table.reload('LAY-list-manage'); //数据刷新
  246. } else {
  247. parent.layer.msg(data);
  248. }
  249. }
  250. });
  251. });
  252. } else if (obj.event === 'edit') {
  253. var tr = $(obj.tr);
  254. var perContent = layer.open({
  255. type: 2,
  256. title: '提现记录-编辑',
  257. content: 'Edit?Id=' + data.Id + '',
  258. maxmin: true,
  259. area: ['500px', '450px'],
  260. btn: ['确定', '取消'],
  261. yes: function (index, layero) {
  262. var iframeWindow = window['layui-layer-iframe' + index],
  263. submitID = 'LAY-list-front-submit',
  264. submit = layero.find('iframe').contents().find('#' + submitID);
  265. setTimeout(function () {
  266. layero.find('iframe').contents().find('.layui-tab-item').each(function (i) {
  267. var errObj = $(this).find('.layui-form-danger');
  268. if (errObj.length > 0) {
  269. iframeWindow.element.tabChange('mytabbar', String(i + 1));
  270. submit.click();
  271. }
  272. });
  273. }, 300);
  274. //监听提交
  275. iframeWindow.layui.form.on('submit(' + submitID + ')', function (data) {
  276. var field = data.field; //获取提交的字段
  277. var userdata = "";
  278. for (var prop in field) {
  279. userdata += prop + "=" + encodeURIComponent(field[prop]) + "&";
  280. }
  281. //提交 Ajax 成功后,静态更新表格中的数据
  282. //$.ajax({});
  283. $.ajax({
  284. type: "POST",
  285. url: "/Admin/UserCashRecord/Edit?r=" + Math.random(1),
  286. data: userdata,
  287. dataType: "text",
  288. success: function (data) {
  289. layer.close(index); //关闭弹层
  290. if (data == "success") {
  291. table.reload('LAY-list-manage'); //数据刷新
  292. } else {
  293. layer.msg(data);
  294. }
  295. }
  296. });
  297. });
  298. submit.trigger('click');
  299. },
  300. success: function (layero, index) {
  301. }
  302. });
  303. layer.full(perContent);
  304. } else if (obj.event === 'reduce') {
  305. var tr = $(obj.tr);
  306. var perContent = layer.open({
  307. type: 2,
  308. title: '拒绝处理',
  309. content: 'Reduce?Id=' + data.Id + '',
  310. maxmin: true,
  311. area: ['500px', '450px'],
  312. btn: ['确定', '取消'],
  313. yes: function (index, layero) {
  314. var iframeWindow = window['layui-layer-iframe' + index],
  315. submitID = 'LAY-list-front-submit',
  316. submit = layero.find('iframe').contents().find('#' + submitID);
  317. setTimeout(function () {
  318. layero.find('iframe').contents().find('.layui-tab-item').each(function (i) {
  319. var errObj = $(this).find('.layui-form-danger');
  320. if (errObj.length > 0) {
  321. iframeWindow.element.tabChange('mytabbar', String(i + 1));
  322. submit.click();
  323. }
  324. });
  325. }, 300);
  326. //监听提交
  327. iframeWindow.layui.form.on('submit(' + submitID + ')', function (data) {
  328. var field = data.field; //获取提交的字段
  329. var userdata = "";
  330. for (var prop in field) {
  331. userdata += prop + "=" + encodeURIComponent(field[prop]) + "&";
  332. }
  333. //提交 Ajax 成功后,静态更新表格中的数据
  334. //$.ajax({});
  335. $.ajax({
  336. type: "POST",
  337. url: "/Admin/UserCashRecord/ReduceDo?r=" + Math.random(1),
  338. data: userdata,
  339. dataType: "text",
  340. success: function (data) {
  341. layer.close(index); //关闭弹层
  342. if (data == "success") {
  343. table.reload('LAY-list-manage'); //数据刷新
  344. } else {
  345. layer.msg(data);
  346. }
  347. }
  348. });
  349. });
  350. submit.trigger('click');
  351. },
  352. success: function (layero, index) {
  353. }
  354. });
  355. }
  356. });
  357. //监听搜索
  358. form.on('submit(LAY-list-front-search)', function (data) {
  359. var field = data.field;
  360. //执行重载
  361. table.reload('LAY-list-manage', {
  362. where: field,
  363. page: {
  364. curr: 1
  365. }
  366. });
  367. });
  368. form.on('submit(LAY-list-front-searchall)', function (data) {
  369. table.reload('LAY-list-manage', {
  370. where: null,
  371. page: {
  372. curr: 1
  373. }
  374. });
  375. });
  376. //事件
  377. var active = {
  378. batchdel: function () {
  379. var checkStatus = table.checkStatus('LAY-list-manage'),
  380. data = checkStatus.data; //得到选中的数据
  381. if (data.length < 1) {
  382. parent.layer.msg("请选择要删除的项");
  383. } else {
  384. var ids = "";
  385. $.each(data, function (index, value) {
  386. ids += data[index].Id + ",";
  387. });
  388. ids = ids.substring(0, ids.length - 1);
  389. var index = layer.confirm('确定要删除吗?删除后不能恢复!', function (index) {
  390. $.ajax({
  391. type: "POST",
  392. url: "/Admin/UserCashRecord/Delete?r=" + Math.random(1),
  393. data: "Id=" + ids,
  394. dataType: "text",
  395. success: function (data) {
  396. layer.close(index);
  397. if (data == "success") {
  398. table.reload('LAY-list-manage');
  399. } else {
  400. layer.msg(data);
  401. }
  402. }
  403. });
  404. });
  405. }
  406. },
  407. add: function () {
  408. var perContent = layer.open({
  409. type: 2,
  410. title: '提现记录-添加',
  411. content: 'Add',
  412. maxmin: true,
  413. area: ['500px', '450px'],
  414. btn: ['确定', '取消'],
  415. yes: function (index, layero) {
  416. var iframeWindow = window['layui-layer-iframe' + index],
  417. submitID = 'LAY-list-front-submit',
  418. submit = layero.find('iframe').contents().find('#' + submitID);
  419. setTimeout(function () {
  420. layero.find('iframe').contents().find('.layui-tab-item').each(function (i) {
  421. var errObj = $(this).find('.layui-form-danger');
  422. if (errObj.length > 0) {
  423. iframeWindow.element.tabChange('mytabbar', String(i + 1));
  424. submit.click();
  425. }
  426. });
  427. }, 300);
  428. //监听提交
  429. iframeWindow.layui.form.on('submit(' + submitID + ')', function (data) {
  430. var field = data.field; //获取提交的字段
  431. var userdata = "";
  432. for (var prop in field) {
  433. userdata += prop + "=" + encodeURIComponent(field[prop]) + "&";
  434. }
  435. //提交 Ajax 成功后,静态更新表格中的数据
  436. //$.ajax({});
  437. $.ajax({
  438. type: "POST",
  439. url: "/Admin/UserCashRecord/Add?r=" + Math.random(1),
  440. data: userdata,
  441. dataType: "text",
  442. success: function (data) {
  443. layer.close(index); //关闭弹层
  444. if (data == "success") {
  445. table.reload('LAY-list-manage'); //数据刷新
  446. } else {
  447. layer.msg(data);
  448. }
  449. }
  450. });
  451. });
  452. submit.trigger('click');
  453. }
  454. });
  455. layer.full(perContent);
  456. },
  457. ImportData: function () {
  458. var perContent = layer.open({
  459. type: 2
  460. , title: '提现结果导入'
  461. , content: 'Import'
  462. , maxmin: true
  463. , area: ['650px', '350px']
  464. , btn: ['确定', '取消']
  465. , yes: function (index, layero) {
  466. var iframeWindow = window['layui-layer-iframe' + index]
  467. , submitID = 'LAY-list-front-submit'
  468. , submit = layero.find('iframe').contents().find('#' + submitID);
  469. //监听提交
  470. iframeWindow.layui.form.on('submit(' + submitID + ')', function (data) {
  471. var field = data.field; //获取提交的字段
  472. var userdata = "";
  473. for (var prop in field) {
  474. userdata += prop + "=" + encodeURIComponent(field[prop]) + "&";
  475. }
  476. //提交 Ajax 成功后,静态更新表格中的数据
  477. //$.ajax({});
  478. var loadindex = layer.load(1, {
  479. shade: [0.5, '#000']
  480. });
  481. $.ajax({
  482. type: "POST",
  483. url: "/Admin/UserCashRecord/ImportPost?r=" + Math.random(1),
  484. data: userdata,
  485. dataType: "text",
  486. success: function (data) {
  487. if (data.indexOf("success") == 0) {
  488. var datalist = data.split('|');
  489. var key = datalist[1];
  490. CheckImport(table, key, loadindex, index);
  491. } else {
  492. layer.msg(data);
  493. }
  494. }
  495. });
  496. });
  497. submit.trigger('click');
  498. }
  499. });
  500. },
  501. ExportExcel: function () {
  502. var userdata = '';
  503. $(".layuiadmin-card-header-auto input").each(function (i) {
  504. userdata += $(this).attr('name') + '=' + encodeURIComponent($(this).val()) + '&';
  505. });
  506. $(".layuiadmin-card-header-auto select").each(function (i) {
  507. userdata += $(this).attr('name') + '=' + encodeURIComponent($(this).val()) + '&';
  508. });
  509. $.ajax({
  510. type: "GET",
  511. url: "/Admin/UserCashRecord/ExportExcel?r=" + Math.random(1),
  512. data: userdata,
  513. dataType: "json",
  514. success: function (data) {
  515. data.Obj.unshift(data.Fields);
  516. excel.exportExcel(data.Obj, data.Info, 'xlsx');
  517. }
  518. });
  519. },
  520. BatchSetting: function () {
  521. var checkStatus = table.checkStatus('LAY-list-manage'),
  522. data = checkStatus.data; //得到选中的数据
  523. if (data.length < 1) {
  524. parent.layer.msg("请选择要设置的项");
  525. } else {
  526. var ids = "";
  527. $.each(data, function (index, value) {
  528. ids += data[index].Id + ",";
  529. });
  530. ids = ids.substring(0, ids.length - 1);
  531. var index = layer.confirm('确定要设为成功状态吗?', function (index) {
  532. $.ajax({
  533. type: "POST",
  534. url: "/Admin/UserCashRecord/BatchSetting?r=" + Math.random(1),
  535. data: "Id=" + ids,
  536. dataType: "text",
  537. success: function (data) {
  538. layer.close(index);
  539. if (data == "success") {
  540. table.reload('LAY-list-manage');
  541. } else {
  542. layer.msg(data);
  543. }
  544. }
  545. });
  546. });
  547. }
  548. },
  549. Open: function () {
  550. var checkStatus = table.checkStatus('LAY-list-manage'),
  551. data = checkStatus.data; //得到选中的数据
  552. if (data.length < 1) {
  553. parent.layer.msg("请选择要开启的项");
  554. } else {
  555. var ids = "";
  556. $.each(data, function (index, value) {
  557. ids += data[index].Id + ",";
  558. });
  559. ids = ids.substring(0, ids.length - 1);
  560. var index = layer.confirm('确定要开启吗?', function (index) {
  561. $.ajax({
  562. type: "POST",
  563. url: "/Admin/UserCashRecord/Open?r=" + Math.random(1),
  564. data: "Id=" + ids,
  565. dataType: "text",
  566. success: function (data) {
  567. layer.close(index);
  568. if (data == "success") {
  569. table.reload('LAY-list-manage');
  570. } else {
  571. layer.msg(data);
  572. }
  573. }
  574. });
  575. });
  576. }
  577. },
  578. Close: function () {
  579. var checkStatus = table.checkStatus('LAY-list-manage'),
  580. data = checkStatus.data; //得到选中的数据
  581. if (data.length < 1) {
  582. parent.layer.msg("请选择要关闭的项");
  583. } else {
  584. var ids = "";
  585. $.each(data, function (index, value) {
  586. ids += data[index].Id + ",";
  587. });
  588. ids = ids.substring(0, ids.length - 1);
  589. var index = layer.confirm('确定要关闭吗?', function (index) {
  590. $.ajax({
  591. type: "POST",
  592. url: "/Admin/UserCashRecord/Close?r=" + Math.random(1),
  593. data: "Id=" + ids,
  594. dataType: "text",
  595. success: function (data) {
  596. layer.close(index);
  597. if (data == "success") {
  598. table.reload('LAY-list-manage');
  599. } else {
  600. layer.msg(data);
  601. }
  602. }
  603. });
  604. });
  605. }
  606. },
  607. Cash: function () {
  608. var checkStatus = table.checkStatus('LAY-list-manage'),
  609. data = checkStatus.data; //得到选中的数据
  610. if (data.length < 1) {
  611. parent.layer.msg("请选择要提交代付的项");
  612. } else {
  613. var ids = "";
  614. $.each(data, function (index, value) {
  615. ids += data[index].Id + ",";
  616. });
  617. ids = ids.substring(0, ids.length - 1);
  618. var index = layer.confirm('确定要提交到代付平台申请出款吗?', function (index) {
  619. $.ajax({
  620. type: "POST",
  621. url: "/Admin/UserCashRecord/Cash?r=" + Math.random(1),
  622. data: "Id=" + ids,
  623. dataType: "text",
  624. success: function (data) {
  625. layer.close(index);
  626. if (data == "success") {
  627. layer.msg('提交成功,请等待代付平台处理');
  628. table.reload('LAY-list-manage');
  629. } else {
  630. layer.msg(data);
  631. }
  632. }
  633. });
  634. });
  635. }
  636. },
  637. };
  638. $('.layui-btn').on('click', function () {
  639. var type = $(this).data('type');
  640. active[type] ? active[type].call(this) : '';
  641. });
  642. });