UserCashRecord_Admin.js 21 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563
  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: 'StatusName',
  161. width: 200,
  162. title: '订单状态',
  163. templet: '#StatusTpl',
  164. sort: true
  165. }, {
  166. field: 'LockName',
  167. width: 200,
  168. title: '提现标记',
  169. sort: true
  170. }, {
  171. field: 'ReturnCode',
  172. width: 200,
  173. title: '提现服务返回编码',
  174. sort: true
  175. }, {
  176. field: 'ReturnMsg',
  177. width: 200,
  178. title: '提现服务返回信息',
  179. sort: true
  180. }, {
  181. field: 'CreateDate',
  182. width: 200,
  183. title: '创建时间',
  184. sort: true
  185. }
  186. ]
  187. ],
  188. where: {
  189. },
  190. page: true,
  191. limit: 30,
  192. height: 'full-' + String($('.layui-card-header').height() + 130),
  193. text: '对不起,加载出现异常!',
  194. done: function (res, curr, count) {
  195. $("#WaitAmount").text(res.other.WaitAmount);
  196. $("#SuccessAmount").text(res.other.SuccessAmount);
  197. $("#FailAmount").text(res.other.FailAmount);
  198. $(".layui-none").text("无数据");
  199. }
  200. });
  201. //监听工具条
  202. table.on('tool(LAY-list-manage)', function (obj) {
  203. var data = obj.data;
  204. if (obj.event === 'del') {
  205. var index = layer.confirm('确定要删除吗?删除后不能恢复!', function (index) {
  206. $.ajax({
  207. type: "POST",
  208. url: "/Admin/UserCashRecord/Delete?r=" + Math.random(1),
  209. data: "Id=" + data.Id,
  210. dataType: "text",
  211. success: function (data) {
  212. if (data == "success") {
  213. obj.del();
  214. layer.close(index);
  215. } else {
  216. parent.layer.msg(data);
  217. }
  218. }
  219. });
  220. });
  221. } else if (obj.event === 'edit') {
  222. var tr = $(obj.tr);
  223. var perContent = layer.open({
  224. type: 2,
  225. title: '提现记录-编辑',
  226. content: 'Edit?Id=' + data.Id + '',
  227. maxmin: true,
  228. area: ['500px', '450px'],
  229. btn: ['确定', '取消'],
  230. yes: function (index, layero) {
  231. var iframeWindow = window['layui-layer-iframe' + index],
  232. submitID = 'LAY-list-front-submit',
  233. submit = layero.find('iframe').contents().find('#' + submitID);
  234. setTimeout(function () {
  235. layero.find('iframe').contents().find('.layui-tab-item').each(function (i) {
  236. var errObj = $(this).find('.layui-form-danger');
  237. if (errObj.length > 0) {
  238. iframeWindow.element.tabChange('mytabbar', String(i + 1));
  239. submit.click();
  240. }
  241. });
  242. }, 300);
  243. //监听提交
  244. iframeWindow.layui.form.on('submit(' + submitID + ')', function (data) {
  245. var field = data.field; //获取提交的字段
  246. var userdata = "";
  247. for (var prop in field) {
  248. userdata += prop + "=" + encodeURIComponent(field[prop]) + "&";
  249. }
  250. //提交 Ajax 成功后,静态更新表格中的数据
  251. //$.ajax({});
  252. $.ajax({
  253. type: "POST",
  254. url: "/Admin/UserCashRecord/Edit?r=" + Math.random(1),
  255. data: userdata,
  256. dataType: "text",
  257. success: function (data) {
  258. layer.close(index); //关闭弹层
  259. if (data == "success") {
  260. table.reload('LAY-list-manage'); //数据刷新
  261. } else {
  262. layer.msg(data);
  263. }
  264. }
  265. });
  266. });
  267. submit.trigger('click');
  268. },
  269. success: function (layero, index) {
  270. }
  271. });
  272. layer.full(perContent);
  273. }
  274. });
  275. //监听搜索
  276. form.on('submit(LAY-list-front-search)', function (data) {
  277. var field = data.field;
  278. //执行重载
  279. table.reload('LAY-list-manage', {
  280. where: field
  281. });
  282. });
  283. form.on('submit(LAY-list-front-searchall)', function (data) {
  284. table.reload('LAY-list-manage', {
  285. where: null
  286. });
  287. });
  288. //事件
  289. var active = {
  290. batchdel: function () {
  291. var checkStatus = table.checkStatus('LAY-list-manage'),
  292. data = checkStatus.data; //得到选中的数据
  293. if (data.length < 1) {
  294. parent.layer.msg("请选择要删除的项");
  295. } else {
  296. var ids = "";
  297. $.each(data, function (index, value) {
  298. ids += data[index].Id + ",";
  299. });
  300. ids = ids.substring(0, ids.length - 1);
  301. var index = layer.confirm('确定要删除吗?删除后不能恢复!', function (index) {
  302. $.ajax({
  303. type: "POST",
  304. url: "/Admin/UserCashRecord/Delete?r=" + Math.random(1),
  305. data: "Id=" + ids,
  306. dataType: "text",
  307. success: function (data) {
  308. layer.close(index);
  309. if (data == "success") {
  310. table.reload('LAY-list-manage');
  311. } else {
  312. layer.msg(data);
  313. }
  314. }
  315. });
  316. });
  317. }
  318. },
  319. add: function () {
  320. var perContent = layer.open({
  321. type: 2,
  322. title: '提现记录-添加',
  323. content: 'Add',
  324. maxmin: true,
  325. area: ['500px', '450px'],
  326. btn: ['确定', '取消'],
  327. yes: function (index, layero) {
  328. var iframeWindow = window['layui-layer-iframe' + index],
  329. submitID = 'LAY-list-front-submit',
  330. submit = layero.find('iframe').contents().find('#' + submitID);
  331. setTimeout(function () {
  332. layero.find('iframe').contents().find('.layui-tab-item').each(function (i) {
  333. var errObj = $(this).find('.layui-form-danger');
  334. if (errObj.length > 0) {
  335. iframeWindow.element.tabChange('mytabbar', String(i + 1));
  336. submit.click();
  337. }
  338. });
  339. }, 300);
  340. //监听提交
  341. iframeWindow.layui.form.on('submit(' + submitID + ')', function (data) {
  342. var field = data.field; //获取提交的字段
  343. var userdata = "";
  344. for (var prop in field) {
  345. userdata += prop + "=" + encodeURIComponent(field[prop]) + "&";
  346. }
  347. //提交 Ajax 成功后,静态更新表格中的数据
  348. //$.ajax({});
  349. $.ajax({
  350. type: "POST",
  351. url: "/Admin/UserCashRecord/Add?r=" + Math.random(1),
  352. data: userdata,
  353. dataType: "text",
  354. success: function (data) {
  355. layer.close(index); //关闭弹层
  356. if (data == "success") {
  357. table.reload('LAY-list-manage'); //数据刷新
  358. } else {
  359. layer.msg(data);
  360. }
  361. }
  362. });
  363. });
  364. submit.trigger('click');
  365. }
  366. });
  367. layer.full(perContent);
  368. },
  369. ImportData: function () {
  370. var perContent = layer.open({
  371. type: 2
  372. , title: '提现结果导入'
  373. , content: 'Import'
  374. , maxmin: true
  375. , area: ['650px', '350px']
  376. , btn: ['确定', '取消']
  377. , yes: function (index, layero) {
  378. var iframeWindow = window['layui-layer-iframe' + index]
  379. , submitID = 'LAY-list-front-submit'
  380. , submit = layero.find('iframe').contents().find('#' + submitID);
  381. //监听提交
  382. iframeWindow.layui.form.on('submit(' + submitID + ')', function (data) {
  383. var field = data.field; //获取提交的字段
  384. var userdata = "";
  385. for (var prop in field) {
  386. userdata += prop + "=" + encodeURIComponent(field[prop]) + "&";
  387. }
  388. //提交 Ajax 成功后,静态更新表格中的数据
  389. //$.ajax({});
  390. var loadindex = layer.load(1, {
  391. shade: [0.5, '#000']
  392. });
  393. $.ajax({
  394. type: "POST",
  395. url: "/Admin/UserCashRecord/ImportPost?r=" + Math.random(1),
  396. data: userdata,
  397. dataType: "text",
  398. success: function (data) {
  399. if (data.indexOf("success") == 0) {
  400. var datalist = data.split('|');
  401. var key = datalist[1];
  402. CheckImport(table, key, loadindex, index);
  403. } else {
  404. layer.msg(data);
  405. }
  406. }
  407. });
  408. });
  409. submit.trigger('click');
  410. }
  411. });
  412. },
  413. ExportExcel: function () {
  414. var userdata = '';
  415. $(".layuiadmin-card-header-auto input").each(function (i) {
  416. userdata += $(this).attr('name') + '=' + encodeURIComponent($(this).val()) + '&';
  417. });
  418. $(".layuiadmin-card-header-auto select").each(function (i) {
  419. userdata += $(this).attr('name') + '=' + encodeURIComponent($(this).val()) + '&';
  420. });
  421. $.ajax({
  422. type: "GET",
  423. url: "/Admin/UserCashRecord/ExportExcel?r=" + Math.random(1),
  424. data: userdata,
  425. dataType: "json",
  426. success: function (data) {
  427. data.Obj.unshift(data.Fields);
  428. excel.exportExcel(data.Obj, data.Info, 'xlsx');
  429. }
  430. });
  431. },
  432. Open: function () {
  433. var checkStatus = table.checkStatus('LAY-list-manage'),
  434. data = checkStatus.data; //得到选中的数据
  435. if (data.length < 1) {
  436. parent.layer.msg("请选择要开启的项");
  437. } else {
  438. var ids = "";
  439. $.each(data, function (index, value) {
  440. ids += data[index].Id + ",";
  441. });
  442. ids = ids.substring(0, ids.length - 1);
  443. var index = layer.confirm('确定要开启吗?', function (index) {
  444. $.ajax({
  445. type: "POST",
  446. url: "/Admin/UserCashRecord/Open?r=" + Math.random(1),
  447. data: "Id=" + ids,
  448. dataType: "text",
  449. success: function (data) {
  450. layer.close(index);
  451. if (data == "success") {
  452. table.reload('LAY-list-manage');
  453. } else {
  454. layer.msg(data);
  455. }
  456. }
  457. });
  458. });
  459. }
  460. },
  461. Close: function () {
  462. var checkStatus = table.checkStatus('LAY-list-manage'),
  463. data = checkStatus.data; //得到选中的数据
  464. if (data.length < 1) {
  465. parent.layer.msg("请选择要关闭的项");
  466. } else {
  467. var ids = "";
  468. $.each(data, function (index, value) {
  469. ids += data[index].Id + ",";
  470. });
  471. ids = ids.substring(0, ids.length - 1);
  472. var index = layer.confirm('确定要关闭吗?', function (index) {
  473. $.ajax({
  474. type: "POST",
  475. url: "/Admin/UserCashRecord/Close?r=" + Math.random(1),
  476. data: "Id=" + ids,
  477. dataType: "text",
  478. success: function (data) {
  479. layer.close(index);
  480. if (data == "success") {
  481. table.reload('LAY-list-manage');
  482. } else {
  483. layer.msg(data);
  484. }
  485. }
  486. });
  487. });
  488. }
  489. },
  490. Cash: function () {
  491. var checkStatus = table.checkStatus('LAY-list-manage'),
  492. data = checkStatus.data; //得到选中的数据
  493. if (data.length < 1) {
  494. parent.layer.msg("请选择要提交代付的项");
  495. } else {
  496. var ids = "";
  497. $.each(data, function (index, value) {
  498. ids += data[index].Id + ",";
  499. });
  500. ids = ids.substring(0, ids.length - 1);
  501. var index = layer.confirm('确定要提交到代付平台申请出款吗?', function (index) {
  502. $.ajax({
  503. type: "POST",
  504. url: "/Admin/UserCashRecord/Cash?r=" + Math.random(1),
  505. data: "Id=" + ids,
  506. dataType: "text",
  507. success: function (data) {
  508. layer.close(index);
  509. if (data == "success") {
  510. layer.msg('提交成功,请等待代付平台处理');
  511. table.reload('LAY-list-manage');
  512. } else {
  513. layer.msg(data);
  514. }
  515. }
  516. });
  517. });
  518. }
  519. },
  520. };
  521. $('.layui-btn').on('click', function () {
  522. var type = $(this).data('type');
  523. active[type] ? active[type].call(this) : '';
  524. });
  525. });