UserCashRecord_Admin.js 27 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700
  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: 'SeoKeyword',
  192. width: 200,
  193. title: '备注',
  194. sort: true
  195. }, {
  196. field: 'Remark',
  197. width: 200,
  198. title: '代付返回信息',
  199. sort: true
  200. }, {
  201. field: 'CreateDate',
  202. width: 200,
  203. title: '创建时间',
  204. sort: true
  205. }, { title: '操作', align: 'center', width: 300, fixed: 'right', toolbar: '#table-list-tools' }
  206. ]
  207. ],
  208. where: {
  209. },
  210. page: true,
  211. limit: 30,
  212. height: 'full-' + String($('.layui-card-header').height() + 130),
  213. text: '对不起,加载出现异常!',
  214. done: function (res, curr, count) {
  215. $("#SuccessAmount").text(res.other.SuccessAmount);
  216. $("#FailAmount").text(res.other.FailAmount);
  217. $("#WaitAmount").text(res.other.WaitAmount);
  218. $("#WaitTaxAmount").text(res.other.WaitTaxAmount);
  219. $("#SuccessTaxAmount").text(res.other.SuccessTaxAmount);
  220. $("#FailTaxAmount").text(res.other.FailTaxAmount);
  221. $(".layui-none").text("无数据");
  222. }
  223. });
  224. //监听工具条
  225. table.on('tool(LAY-list-manage)', function (obj) {
  226. var data = obj.data;
  227. if (obj.event === 'del') {
  228. var index = layer.confirm('确定要删除吗?删除后不能恢复!', function (index) {
  229. $.ajax({
  230. type: "POST",
  231. url: "/Admin/UserCashRecord/Delete?r=" + Math.random(1),
  232. data: "Id=" + data.Id,
  233. dataType: "text",
  234. success: function (data) {
  235. if (data == "success") {
  236. obj.del();
  237. layer.close(index);
  238. } else {
  239. parent.layer.msg(data);
  240. }
  241. }
  242. });
  243. });
  244. } else if (obj.event === 'cancel') {
  245. var index = layer.confirm('确定要解除吗?操作后不能恢复!', function (index) {
  246. $.ajax({
  247. type: "POST",
  248. url: "/Admin/UserCashRecord/Cancel?r=" + Math.random(1),
  249. data: "Id=" + data.Id,
  250. dataType: "text",
  251. success: function (data) {
  252. layer.close(index);
  253. if (data == "success") {
  254. parent.layer.msg('已解除');
  255. table.reload('LAY-list-manage'); //数据刷新
  256. } else {
  257. parent.layer.msg(data);
  258. }
  259. }
  260. });
  261. });
  262. } else if (obj.event === 'edit') {
  263. var tr = $(obj.tr);
  264. var perContent = layer.open({
  265. type: 2,
  266. title: '提现记录-编辑',
  267. content: 'Edit?Id=' + data.Id + '',
  268. maxmin: true,
  269. area: ['500px', '450px'],
  270. btn: ['确定', '取消'],
  271. yes: function (index, layero) {
  272. var iframeWindow = window['layui-layer-iframe' + index],
  273. submitID = 'LAY-list-front-submit',
  274. submit = layero.find('iframe').contents().find('#' + submitID);
  275. setTimeout(function () {
  276. layero.find('iframe').contents().find('.layui-tab-item').each(function (i) {
  277. var errObj = $(this).find('.layui-form-danger');
  278. if (errObj.length > 0) {
  279. iframeWindow.element.tabChange('mytabbar', String(i + 1));
  280. submit.click();
  281. }
  282. });
  283. }, 300);
  284. //监听提交
  285. iframeWindow.layui.form.on('submit(' + submitID + ')', function (data) {
  286. var field = data.field; //获取提交的字段
  287. var userdata = "";
  288. for (var prop in field) {
  289. userdata += prop + "=" + encodeURIComponent(field[prop]) + "&";
  290. }
  291. //提交 Ajax 成功后,静态更新表格中的数据
  292. //$.ajax({});
  293. $.ajax({
  294. type: "POST",
  295. url: "/Admin/UserCashRecord/Edit?r=" + Math.random(1),
  296. data: userdata,
  297. dataType: "text",
  298. success: function (data) {
  299. layer.close(index); //关闭弹层
  300. if (data == "success") {
  301. table.reload('LAY-list-manage'); //数据刷新
  302. } else {
  303. layer.msg(data);
  304. }
  305. }
  306. });
  307. });
  308. submit.trigger('click');
  309. },
  310. success: function (layero, index) {
  311. }
  312. });
  313. layer.full(perContent);
  314. } else if (obj.event === 'reduce') {
  315. var tr = $(obj.tr);
  316. var perContent = layer.open({
  317. type: 2,
  318. title: '拒绝处理',
  319. content: 'Reduce?Id=' + data.Id + '',
  320. maxmin: true,
  321. area: ['500px', '450px'],
  322. btn: ['确定', '取消'],
  323. yes: function (index, layero) {
  324. var iframeWindow = window['layui-layer-iframe' + index],
  325. submitID = 'LAY-list-front-submit',
  326. submit = layero.find('iframe').contents().find('#' + submitID);
  327. setTimeout(function () {
  328. layero.find('iframe').contents().find('.layui-tab-item').each(function (i) {
  329. var errObj = $(this).find('.layui-form-danger');
  330. if (errObj.length > 0) {
  331. iframeWindow.element.tabChange('mytabbar', String(i + 1));
  332. submit.click();
  333. }
  334. });
  335. }, 300);
  336. //监听提交
  337. iframeWindow.layui.form.on('submit(' + submitID + ')', function (data) {
  338. var field = data.field; //获取提交的字段
  339. var userdata = "";
  340. for (var prop in field) {
  341. userdata += prop + "=" + encodeURIComponent(field[prop]) + "&";
  342. }
  343. //提交 Ajax 成功后,静态更新表格中的数据
  344. //$.ajax({});
  345. $.ajax({
  346. type: "POST",
  347. url: "/Admin/UserCashRecord/ReduceDo?r=" + Math.random(1),
  348. data: userdata,
  349. dataType: "text",
  350. success: function (data) {
  351. layer.close(index); //关闭弹层
  352. if (data == "success") {
  353. table.reload('LAY-list-manage'); //数据刷新
  354. } else {
  355. layer.msg(data);
  356. }
  357. }
  358. });
  359. });
  360. submit.trigger('click');
  361. },
  362. success: function (layero, index) {
  363. }
  364. });
  365. }
  366. });
  367. //监听搜索
  368. form.on('submit(LAY-list-front-search)', function (data) {
  369. var field = data.field;
  370. //执行重载
  371. table.reload('LAY-list-manage', {
  372. where: field,
  373. page: {
  374. curr: 1
  375. }
  376. });
  377. });
  378. form.on('submit(LAY-list-front-searchall)', function (data) {
  379. table.reload('LAY-list-manage', {
  380. where: null,
  381. page: {
  382. curr: 1
  383. }
  384. });
  385. });
  386. //事件
  387. var active = {
  388. batchdel: function () {
  389. var checkStatus = table.checkStatus('LAY-list-manage'),
  390. data = checkStatus.data; //得到选中的数据
  391. if (data.length < 1) {
  392. parent.layer.msg("请选择要删除的项");
  393. } else {
  394. var ids = "";
  395. $.each(data, function (index, value) {
  396. ids += data[index].Id + ",";
  397. });
  398. ids = ids.substring(0, ids.length - 1);
  399. var index = layer.confirm('确定要删除吗?删除后不能恢复!', function (index) {
  400. $.ajax({
  401. type: "POST",
  402. url: "/Admin/UserCashRecord/Delete?r=" + Math.random(1),
  403. data: "Id=" + ids,
  404. dataType: "text",
  405. success: function (data) {
  406. layer.close(index);
  407. if (data == "success") {
  408. table.reload('LAY-list-manage');
  409. } else {
  410. layer.msg(data);
  411. }
  412. }
  413. });
  414. });
  415. }
  416. },
  417. add: function () {
  418. var perContent = layer.open({
  419. type: 2,
  420. title: '提现记录-添加',
  421. content: 'Add',
  422. maxmin: true,
  423. area: ['500px', '450px'],
  424. btn: ['确定', '取消'],
  425. yes: function (index, layero) {
  426. var iframeWindow = window['layui-layer-iframe' + index],
  427. submitID = 'LAY-list-front-submit',
  428. submit = layero.find('iframe').contents().find('#' + submitID);
  429. setTimeout(function () {
  430. layero.find('iframe').contents().find('.layui-tab-item').each(function (i) {
  431. var errObj = $(this).find('.layui-form-danger');
  432. if (errObj.length > 0) {
  433. iframeWindow.element.tabChange('mytabbar', String(i + 1));
  434. submit.click();
  435. }
  436. });
  437. }, 300);
  438. //监听提交
  439. iframeWindow.layui.form.on('submit(' + submitID + ')', function (data) {
  440. var field = data.field; //获取提交的字段
  441. var userdata = "";
  442. for (var prop in field) {
  443. userdata += prop + "=" + encodeURIComponent(field[prop]) + "&";
  444. }
  445. //提交 Ajax 成功后,静态更新表格中的数据
  446. //$.ajax({});
  447. $.ajax({
  448. type: "POST",
  449. url: "/Admin/UserCashRecord/Add?r=" + Math.random(1),
  450. data: userdata,
  451. dataType: "text",
  452. success: function (data) {
  453. layer.close(index); //关闭弹层
  454. if (data == "success") {
  455. table.reload('LAY-list-manage'); //数据刷新
  456. } else {
  457. layer.msg(data);
  458. }
  459. }
  460. });
  461. });
  462. submit.trigger('click');
  463. }
  464. });
  465. layer.full(perContent);
  466. },
  467. ImportData: function () {
  468. var perContent = layer.open({
  469. type: 2
  470. , title: '提现结果导入'
  471. , content: 'Import'
  472. , maxmin: true
  473. , area: ['650px', '350px']
  474. , btn: ['确定', '取消']
  475. , yes: function (index, layero) {
  476. var iframeWindow = window['layui-layer-iframe' + index]
  477. , submitID = 'LAY-list-front-submit'
  478. , submit = layero.find('iframe').contents().find('#' + submitID);
  479. //监听提交
  480. iframeWindow.layui.form.on('submit(' + submitID + ')', function (data) {
  481. var field = data.field; //获取提交的字段
  482. var userdata = "";
  483. for (var prop in field) {
  484. userdata += prop + "=" + encodeURIComponent(field[prop]) + "&";
  485. }
  486. //提交 Ajax 成功后,静态更新表格中的数据
  487. //$.ajax({});
  488. var loadindex = layer.load(1, {
  489. shade: [0.5, '#000']
  490. });
  491. $.ajax({
  492. type: "POST",
  493. url: "/Admin/UserCashRecord/ImportPost?r=" + Math.random(1),
  494. data: userdata,
  495. dataType: "text",
  496. success: function (data) {
  497. if (data.indexOf("success") == 0) {
  498. var datalist = data.split('|');
  499. var key = datalist[1];
  500. CheckImport(table, key, loadindex, index);
  501. } else {
  502. layer.msg(data);
  503. }
  504. }
  505. });
  506. });
  507. submit.trigger('click');
  508. }
  509. });
  510. },
  511. ExportExcel: function () {
  512. var userdata = '';
  513. $(".layuiadmin-card-header-auto input").each(function (i) {
  514. userdata += $(this).attr('name') + '=' + encodeURIComponent($(this).val()) + '&';
  515. });
  516. $(".layuiadmin-card-header-auto select").each(function (i) {
  517. userdata += $(this).attr('name') + '=' + encodeURIComponent($(this).val()) + '&';
  518. });
  519. $.ajax({
  520. type: "GET",
  521. url: "/Admin/UserCashRecord/ExportExcel?r=" + Math.random(1),
  522. data: userdata,
  523. dataType: "json",
  524. success: function (data) {
  525. data.Obj.unshift(data.Fields);
  526. excel.exportExcel(data.Obj, data.Info, 'xlsx');
  527. }
  528. });
  529. },
  530. BatchSetting: function () {
  531. var checkStatus = table.checkStatus('LAY-list-manage'),
  532. data = checkStatus.data; //得到选中的数据
  533. if (data.length < 1) {
  534. parent.layer.msg("请选择要设置的项");
  535. } else {
  536. var ids = "";
  537. $.each(data, function (index, value) {
  538. ids += data[index].Id + ",";
  539. });
  540. ids = ids.substring(0, ids.length - 1);
  541. var index = layer.confirm('确定要设为成功状态吗?', function (index) {
  542. $.ajax({
  543. type: "POST",
  544. url: "/Admin/UserCashRecord/BatchSetting?r=" + Math.random(1),
  545. data: "Id=" + ids,
  546. dataType: "text",
  547. success: function (data) {
  548. layer.close(index);
  549. if (data == "success") {
  550. table.reload('LAY-list-manage');
  551. } else {
  552. layer.msg(data);
  553. }
  554. }
  555. });
  556. });
  557. }
  558. },
  559. Open: function () {
  560. var checkStatus = table.checkStatus('LAY-list-manage'),
  561. data = checkStatus.data; //得到选中的数据
  562. if (data.length < 1) {
  563. parent.layer.msg("请选择要开启的项");
  564. } else {
  565. var ids = "";
  566. $.each(data, function (index, value) {
  567. ids += data[index].Id + ",";
  568. });
  569. ids = ids.substring(0, ids.length - 1);
  570. var index = layer.confirm('确定要开启吗?', function (index) {
  571. $.ajax({
  572. type: "POST",
  573. url: "/Admin/UserCashRecord/Open?r=" + Math.random(1),
  574. data: "Id=" + ids,
  575. dataType: "text",
  576. success: function (data) {
  577. layer.close(index);
  578. if (data == "success") {
  579. table.reload('LAY-list-manage');
  580. } else {
  581. layer.msg(data);
  582. }
  583. }
  584. });
  585. });
  586. }
  587. },
  588. Close: function () {
  589. var checkStatus = table.checkStatus('LAY-list-manage'),
  590. data = checkStatus.data; //得到选中的数据
  591. if (data.length < 1) {
  592. parent.layer.msg("请选择要关闭的项");
  593. } else {
  594. var ids = "";
  595. $.each(data, function (index, value) {
  596. ids += data[index].Id + ",";
  597. });
  598. ids = ids.substring(0, ids.length - 1);
  599. var index = layer.confirm('确定要关闭吗?', function (index) {
  600. $.ajax({
  601. type: "POST",
  602. url: "/Admin/UserCashRecord/Close?r=" + Math.random(1),
  603. data: "Id=" + ids,
  604. dataType: "text",
  605. success: function (data) {
  606. layer.close(index);
  607. if (data == "success") {
  608. table.reload('LAY-list-manage');
  609. } else {
  610. layer.msg(data);
  611. }
  612. }
  613. });
  614. });
  615. }
  616. },
  617. Cash: function () {
  618. var checkStatus = table.checkStatus('LAY-list-manage'),
  619. data = checkStatus.data; //得到选中的数据
  620. if (data.length < 1) {
  621. parent.layer.msg("请选择要提交代付的项");
  622. } else {
  623. var ids = "";
  624. $.each(data, function (index, value) {
  625. ids += data[index].Id + ",";
  626. });
  627. ids = ids.substring(0, ids.length - 1);
  628. var index = layer.confirm('确定要提交到代付平台申请出款吗?', function (index) {
  629. $.ajax({
  630. type: "POST",
  631. url: "/Admin/UserCashRecord/Cash?r=" + Math.random(1),
  632. data: "Id=" + ids,
  633. dataType: "text",
  634. success: function (data) {
  635. layer.close(index);
  636. if (data == "success") {
  637. layer.msg('提交成功,请等待代付平台处理');
  638. table.reload('LAY-list-manage');
  639. } else {
  640. layer.msg(data);
  641. }
  642. }
  643. });
  644. });
  645. }
  646. },
  647. };
  648. $('.layui-btn').on('click', function () {
  649. var type = $(this).data('type');
  650. active[type] ? active[type].call(this) : '';
  651. });
  652. });