ProfitRewardRecord_Admin.js 22 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574
  1. var ExcelData;
  2. function ConfirmImport() {
  3. $.ajax({
  4. type: "POST",
  5. url: "/Admin/ProfitRewardRecord/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. var excel;
  22. layui.config({
  23. base: '/layuiadmin/' //静态资源所在路径
  24. }).extend({
  25. myexcel: 'layui/lay/modules/excel',
  26. index: 'lib/index' //主入口模块
  27. }).use(['index', 'table', 'excel', 'laydate'], function () {
  28. var $ = layui.$,
  29. form = layui.form,
  30. table = layui.table;
  31. //- 筛选条件-日期
  32. var laydate = layui.laydate;
  33. var layCreateDate = laydate.render({
  34. elem: '#CreateDate',
  35. type: 'date',
  36. range: true,
  37. trigger: 'click',
  38. change: function (value, date, endDate) {
  39. var op = true;
  40. if (date.year == endDate.year && endDate.month - date.month <= 1) {
  41. if (endDate.month - date.month == 1 && endDate.date > date.date) {
  42. op = false;
  43. layCreateDate.hint('日期范围请不要超过1个月');
  44. setTimeout(function () {
  45. $(".laydate-btns-confirm").addClass("laydate-disabled");
  46. }, 1);
  47. }
  48. } else {
  49. op = false;
  50. layCreateDate.hint('日期范围请不要超过1个月');
  51. setTimeout(function () {
  52. $(".laydate-btns-confirm").addClass("laydate-disabled");
  53. }, 1);
  54. }
  55. if (op) {
  56. $('#CreateDate').val(value);
  57. }
  58. }
  59. });
  60. //excel导入
  61. excel = layui.excel;
  62. $('#ExcelFile').change(function (e) {
  63. var files = e.target.files;
  64. excel.importExcel(files, {}, function (data) {
  65. ExcelData = data[0].sheet1;
  66. });
  67. });
  68. //监听单元格编辑
  69. table.on('edit(LAY-list-manage)', function (obj) {
  70. var value = obj.value //得到修改后的值
  71. ,
  72. data = obj.data //得到所在行所有键值
  73. ,
  74. field = obj.field; //得到字段
  75. if (field == "Sort") {
  76. $.ajax({
  77. type: "POST",
  78. url: "/Admin/ProfitRewardRecord/Sort?r=" + Math.random(1),
  79. data: "Id=" + data.Id + "&Sort=" + value,
  80. dataType: "text",
  81. success: function (data) {}
  82. });
  83. }
  84. });
  85. //列表数据
  86. table.render({
  87. elem: '#LAY-list-manage',
  88. url: '/Admin/ProfitRewardRecord/IndexData' //模拟接口
  89. ,
  90. cols: [
  91. [{
  92. type: 'checkbox',
  93. fixed: 'left'
  94. }, {
  95. field: 'RecordNo',
  96. width: 200,
  97. title: '记录单号',
  98. sort: true
  99. }, {
  100. field: 'MakerCode',
  101. width: 200,
  102. title: '创客编号',
  103. sort: true
  104. }, {
  105. field: 'RealName',
  106. width: 200,
  107. title: '创客姓名',
  108. sort: true
  109. }, {
  110. field: 'TopMakerCode',
  111. width: 200,
  112. title: '顶级创客编码',
  113. sort: true
  114. }, {
  115. field: 'TopRealName',
  116. width: 200,
  117. title: '顶级创客名称',
  118. sort: true
  119. }, {
  120. field: 'TradeMonth',
  121. width: 200,
  122. title: '交易所在月份',
  123. sort: true
  124. }, {
  125. field: 'ProfitType',
  126. width: 200,
  127. title: '分润类型',
  128. sort: true
  129. }, {
  130. field: 'TradeAmt',
  131. width: 200,
  132. title: '商户交易总额(元)',
  133. sort: true
  134. }, {
  135. field: 'OtherTradeAmt',
  136. width: 380,
  137. title: '其他产品交易额(元)',
  138. sort: true
  139. }, {
  140. field: 'CreditTradeAmt',
  141. width: 380,
  142. title: '贷记卡交易金额(元)',
  143. sort: true
  144. }, {
  145. field: 'MerDebitTradeAmt',
  146. width: 380,
  147. title: '商户借记卡交易金额(元)',
  148. sort: true
  149. }, {
  150. field: 'TradeProfit',
  151. width: 200,
  152. title: '交易分润(元)',
  153. sort: true
  154. }, {
  155. field: 'CreditProfitAmt',
  156. width: 380,
  157. title: '贷记卡分润金额',
  158. sort: true
  159. }, {
  160. field: 'DebitProfitAmt',
  161. width: 380,
  162. title: '借记卡交易分润金额',
  163. sort: true
  164. }, {
  165. field: 'CheckStatus',
  166. width: 200,
  167. title: '验证和同步账户状态',
  168. sort: true
  169. }]
  170. ],
  171. where: {
  172. BrandId: BrandId
  173. },
  174. page: true,
  175. limit: 30,
  176. height: 'full-' + String($('.layui-card-header').height() + 130),
  177. text: '对不起,加载出现异常!',
  178. done: function (res, curr, count) {
  179. $("#MerchantTradeAmount").text(res.other.MerchantTradeAmount.toFixed(2));
  180. $("#CreditTradeAmount").text(res.other.CreditTradeAmount.toFixed(2));
  181. $("#MerchantProfitAmount").text(res.other.MerchantProfitAmount.toFixed(2));
  182. $("#CreditProfitAmount").text(res.other.CreditProfitAmount.toFixed(2));
  183. $(".layui-none").text("无数据");
  184. }
  185. });
  186. //监听工具条
  187. table.on('tool(LAY-list-manage)', function (obj) {
  188. var data = obj.data;
  189. if (obj.event === 'del') {
  190. var index = layer.confirm('确定要删除吗?删除后不能恢复!', function (index) {
  191. $.ajax({
  192. type: "POST",
  193. url: "/Admin/ProfitRewardRecord/Delete?r=" + Math.random(1),
  194. data: "Id=" + data.Id,
  195. dataType: "text",
  196. success: function (data) {
  197. if (data == "success") {
  198. obj.del();
  199. layer.close(index);
  200. } else {
  201. parent.layer.msg(data);
  202. }
  203. }
  204. });
  205. });
  206. } else if (obj.event === 'edit') {
  207. var tr = $(obj.tr);
  208. var perContent = layer.open({
  209. type: 2,
  210. title: '分润奖励记录-编辑',
  211. content: 'Edit?Id=' + data.Id + '',
  212. maxmin: true,
  213. area: ['500px', '450px'],
  214. btn: ['确定', '取消'],
  215. yes: function (index, layero) {
  216. var iframeWindow = window['layui-layer-iframe' + index],
  217. submitID = 'LAY-list-front-submit',
  218. submit = layero.find('iframe').contents().find('#' + submitID);
  219. setTimeout(function () {
  220. layero.find('iframe').contents().find('.layui-tab-item').each(function (i) {
  221. var errObj = $(this).find('.layui-form-danger');
  222. if (errObj.length > 0) {
  223. iframeWindow.element.tabChange('mytabbar', String(i + 1));
  224. submit.click();
  225. }
  226. });
  227. }, 300);
  228. //监听提交
  229. iframeWindow.layui.form.on('submit(' + submitID + ')', function (data) {
  230. var field = data.field; //获取提交的字段
  231. var userdata = "";
  232. for (var prop in field) {
  233. userdata += prop + "=" + encodeURIComponent(field[prop]) + "&";
  234. }
  235. //提交 Ajax 成功后,静态更新表格中的数据
  236. //$.ajax({});
  237. $.ajax({
  238. type: "POST",
  239. url: "/Admin/ProfitRewardRecord/Edit?r=" + Math.random(1),
  240. data: userdata,
  241. dataType: "text",
  242. success: function (data) {
  243. layer.close(index); //关闭弹层
  244. if (data == "success") {
  245. table.reload('LAY-list-manage'); //数据刷新
  246. } else {
  247. layer.msg(data);
  248. }
  249. }
  250. });
  251. });
  252. submit.trigger('click');
  253. },
  254. success: function (layero, index) {
  255. }
  256. });
  257. layer.full(perContent);
  258. }
  259. });
  260. //监听搜索
  261. form.on('submit(LAY-list-front-search)', function (data) {
  262. var field = data.field;
  263. //执行重载
  264. table.reload('LAY-list-manage', {
  265. where: field
  266. });
  267. });
  268. form.on('submit(LAY-list-front-searchall)', function (data) {
  269. table.reload('LAY-list-manage', {
  270. where: {
  271. BrandId: BrandId
  272. }
  273. });
  274. });
  275. //事件
  276. var active = {
  277. batchdel: function () {
  278. var checkStatus = table.checkStatus('LAY-list-manage'),
  279. data = checkStatus.data; //得到选中的数据
  280. if (data.length < 1) {
  281. parent.layer.msg("请选择要删除的项");
  282. } else {
  283. var ids = "";
  284. $.each(data, function (index, value) {
  285. ids += data[index].Id + ",";
  286. });
  287. ids = ids.substring(0, ids.length - 1);
  288. var index = layer.confirm('确定要删除吗?删除后不能恢复!', function (index) {
  289. $.ajax({
  290. type: "POST",
  291. url: "/Admin/ProfitRewardRecord/Delete?r=" + Math.random(1),
  292. data: "Id=" + ids,
  293. dataType: "text",
  294. success: function (data) {
  295. layer.close(index);
  296. if (data == "success") {
  297. table.reload('LAY-list-manage');
  298. } else {
  299. layer.msg(data);
  300. }
  301. }
  302. });
  303. });
  304. }
  305. },
  306. add: function () {
  307. var perContent = layer.open({
  308. type: 2,
  309. title: '分润奖励记录-添加',
  310. content: 'Add',
  311. maxmin: true,
  312. area: ['500px', '450px'],
  313. btn: ['确定', '取消'],
  314. yes: function (index, layero) {
  315. var iframeWindow = window['layui-layer-iframe' + index],
  316. submitID = 'LAY-list-front-submit',
  317. submit = layero.find('iframe').contents().find('#' + submitID);
  318. setTimeout(function () {
  319. layero.find('iframe').contents().find('.layui-tab-item').each(function (i) {
  320. var errObj = $(this).find('.layui-form-danger');
  321. if (errObj.length > 0) {
  322. iframeWindow.element.tabChange('mytabbar', String(i + 1));
  323. submit.click();
  324. }
  325. });
  326. }, 300);
  327. //监听提交
  328. iframeWindow.layui.form.on('submit(' + submitID + ')', function (data) {
  329. var field = data.field; //获取提交的字段
  330. var userdata = "";
  331. for (var prop in field) {
  332. userdata += prop + "=" + encodeURIComponent(field[prop]) + "&";
  333. }
  334. //提交 Ajax 成功后,静态更新表格中的数据
  335. //$.ajax({});
  336. $.ajax({
  337. type: "POST",
  338. url: "/Admin/ProfitRewardRecord/Add?r=" + Math.random(1),
  339. data: userdata,
  340. dataType: "text",
  341. success: function (data) {
  342. layer.close(index); //关闭弹层
  343. if (data == "success") {
  344. table.reload('LAY-list-manage'); //数据刷新
  345. } else {
  346. layer.msg(data);
  347. }
  348. }
  349. });
  350. });
  351. submit.trigger('click');
  352. }
  353. });
  354. layer.full(perContent);
  355. },
  356. ImportData: function () {
  357. layer.open({
  358. type: 1,
  359. title: '导入',
  360. maxmin: false,
  361. area: ['460px', '180px'],
  362. content: $('#excelForm'),
  363. cancel: function () {}
  364. });
  365. },
  366. ExportExcel: function () {
  367. var userdata = '';
  368. $(".layuiadmin-card-header-auto input").each(function (i) {
  369. userdata += $(this).attr('name') + '=' + encodeURIComponent($(this).val()) + '&';
  370. });
  371. $(".layuiadmin-card-header-auto select").each(function (i) {
  372. userdata += $(this).attr('name') + '=' + encodeURIComponent($(this).val()) + '&';
  373. });
  374. $.ajax({
  375. type: "GET",
  376. url: "/Admin/ProfitRewardRecord/ExportExcel?r=" + Math.random(1),
  377. data: userdata,
  378. dataType: "json",
  379. success: function (data) {
  380. data.Obj.unshift(data.Fields);
  381. excel.exportExcel(data.Obj, data.Info, 'xlsx');
  382. }
  383. });
  384. },
  385. Open: function () {
  386. var checkStatus = table.checkStatus('LAY-list-manage'),
  387. data = checkStatus.data; //得到选中的数据
  388. if (data.length < 1) {
  389. parent.layer.msg("请选择要开启的项");
  390. } else {
  391. var ids = "";
  392. $.each(data, function (index, value) {
  393. ids += data[index].Id + ",";
  394. });
  395. ids = ids.substring(0, ids.length - 1);
  396. var index = layer.confirm('确定要开启吗?', function (index) {
  397. $.ajax({
  398. type: "POST",
  399. url: "/Admin/ProfitRewardRecord/Open?r=" + Math.random(1),
  400. data: "Id=" + ids,
  401. dataType: "text",
  402. success: function (data) {
  403. layer.close(index);
  404. if (data == "success") {
  405. table.reload('LAY-list-manage');
  406. } else {
  407. layer.msg(data);
  408. }
  409. }
  410. });
  411. });
  412. }
  413. },
  414. Close: function () {
  415. var checkStatus = table.checkStatus('LAY-list-manage'),
  416. data = checkStatus.data; //得到选中的数据
  417. if (data.length < 1) {
  418. parent.layer.msg("请选择要关闭的项");
  419. } else {
  420. var ids = "";
  421. $.each(data, function (index, value) {
  422. ids += data[index].Id + ",";
  423. });
  424. ids = ids.substring(0, ids.length - 1);
  425. var index = layer.confirm('确定要关闭吗?', function (index) {
  426. $.ajax({
  427. type: "POST",
  428. url: "/Admin/ProfitRewardRecord/Close?r=" + Math.random(1),
  429. data: "Id=" + ids,
  430. dataType: "text",
  431. success: function (data) {
  432. layer.close(index);
  433. if (data == "success") {
  434. table.reload('LAY-list-manage');
  435. } else {
  436. layer.msg(data);
  437. }
  438. }
  439. });
  440. });
  441. }
  442. },
  443. SycnData: function () {
  444. var index = layer.confirm('确定要同步到APP展示吗?操作后无法撤回', function (index) {
  445. layer.close(index);
  446. var loadindex = layer.load(1, {
  447. shade: [0.5, '#000']
  448. });
  449. $.ajax({
  450. type: "POST",
  451. url: "/Admin/ProfitRewardRecord/SycnData?r=" + Math.random(1),
  452. data: "BrandId=" + BrandId,
  453. dataType: "text",
  454. success: function (data) {
  455. layer.close(loadindex);
  456. if (data == "success") {
  457. layer.msg('同步成功');
  458. table.reload('LAY-list-manage');
  459. } else {
  460. layer.msg(data);
  461. }
  462. }
  463. });
  464. });
  465. },
  466. SycnDataByCondi: function () {
  467. var MakerCode = $(".layuiadmin-card-header-auto input[name=MakerCode]").val();
  468. var index = layer.confirm('确定要同步到APP展示吗?操作后无法撤回', function (index) {
  469. layer.close(index);
  470. var loadindex = layer.load(1, {
  471. shade: [0.5, '#000']
  472. });
  473. $.ajax({
  474. type: "POST",
  475. url: "/Admin/ProfitRewardRecord/SycnDataByCondi?r=" + Math.random(1),
  476. data: "BrandId=" + BrandId + "&MakerCode=" + MakerCode,
  477. dataType: "text",
  478. success: function (data) {
  479. layer.close(loadindex);
  480. if (data == "success") {
  481. layer.msg('同步成功');
  482. table.reload('LAY-list-manage');
  483. } else {
  484. layer.msg(data);
  485. }
  486. }
  487. });
  488. });
  489. },
  490. SycnCash: function () {
  491. var index = layer.confirm('确定要同步到余额吗?操作后无法撤回', function (index) {
  492. layer.close(index);
  493. var loadindex = layer.load(1, {
  494. shade: [0.5, '#000']
  495. });
  496. $.ajax({
  497. type: "POST",
  498. url: "/Admin/ProfitRewardRecord/SycnData?r=" + Math.random(1),
  499. data: "BrandId=" + BrandId + "&OpType=1",
  500. dataType: "text",
  501. success: function (data) {
  502. layer.close(loadindex);
  503. if (data == "success") {
  504. layer.msg('同步成功');
  505. table.reload('LAY-list-manage');
  506. } else {
  507. layer.msg(data);
  508. }
  509. }
  510. });
  511. });
  512. },
  513. SycnCashByCondi: function () {
  514. var MakerCode = $(".layuiadmin-card-header-auto input[name=MakerCode]").val();
  515. var index = layer.confirm('确定要同步到余额吗?操作后无法撤回', function (index) {
  516. layer.close(index);
  517. var loadindex = layer.load(1, {
  518. shade: [0.5, '#000']
  519. });
  520. $.ajax({
  521. type: "POST",
  522. url: "/Admin/ProfitRewardRecord/SycnDataByCondi?r=" + Math.random(1),
  523. data: "BrandId=" + BrandId + "&MakerCode=" + MakerCode + "&OpType=1",
  524. dataType: "text",
  525. success: function (data) {
  526. layer.close(loadindex);
  527. if (data == "success") {
  528. layer.msg('同步成功');
  529. table.reload('LAY-list-manage');
  530. } else {
  531. layer.msg(data);
  532. }
  533. }
  534. });
  535. });
  536. }
  537. };
  538. $('.layui-btn').on('click', function () {
  539. var type = $(this).data('type');
  540. active[type] ? active[type].call(this) : '';
  541. });
  542. });