TradeRecord_Admin.js 18 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441
  1. var ExcelData, ExcelKind;
  2. function ConfirmImport() {
  3. $.ajax({
  4. type: "POST",
  5. url: "/Admin/SpTradeRecord/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. trigger: 'click',
  34. type: 'date',
  35. range: true,
  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. //excel导入
  59. excel = layui.excel;
  60. $('#ExcelFile').change(function (e) {
  61. var files = e.target.files;
  62. excel.importExcel(files, {}, function (data) {
  63. ExcelData = data[0].sheet1;
  64. });
  65. });
  66. //监听单元格编辑
  67. table.on('edit(LAY-list-manage)', function (obj) {
  68. var value = obj.value //得到修改后的值
  69. , data = obj.data //得到所在行所有键值
  70. , field = obj.field; //得到字段
  71. if (field == "Sort") {
  72. $.ajax({
  73. type: "POST",
  74. url: "/Admin/SpTradeRecord/Sort?r=" + Math.random(1),
  75. data: "Id=" + data.Id + "&Sort=" + value,
  76. dataType: "text",
  77. success: function (data) {
  78. }
  79. });
  80. }
  81. });
  82. //列表数据
  83. table.render({
  84. elem: '#LAY-list-manage'
  85. , url: '/Admin/SpTradeRecord/IndexData' //模拟接口
  86. , cols: [[
  87. { type: 'checkbox', fixed: 'left' }
  88. // , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  89. , { field: 'Status', width: 200, title: '状态', sort: true }
  90. , { field: 'TradeSerialNo', width: 200, title: '交易单号', sort: true }
  91. , { field: 'MerNo', width: 200, title: '商户编号', sort: true }
  92. , { field: 'TradeAmount', width: 200, title: '交易金额', sort: true }
  93. , { field: 'CreateDate', width: 200, title: '创建时间', sort: true }
  94. , { field: 'AgentNo', width: 200, title: '代理编号', sort: true }
  95. , { field: 'BankCardNo', width: 200, title: '交易卡号', sort: true }
  96. , { field: 'TradeSnNo', width: 200, title: '机具号', sort: true }
  97. , { field: 'TradeType', width: 200, title: '交易类型', sort: true }
  98. , { field: 'TradeStatus', width: 200, title: '交易状态', sort: true }
  99. // , { field: 'TradeDate', width: 200, title: '交易日期', sort: true }
  100. , { field: 'TradeTime', width: 200, title: '交易时间', sort: true }
  101. , { field: 'BankCardType', width: 200, title: '银行卡类型', sort: true }
  102. , { field: 'MerNo', width: 200, title: '商户编号', sort: true }
  103. // , { field: 'SettleFee', width: 200, title: '出款手续费', sort: true }
  104. // , { field: 'Remark', width: 200, title: '备注', sort: true }
  105. , { field: 'ProductType', width: 200, title: '产品类型', sort: true }
  106. // , { field: 'AgentNo', width: 200, title: '代理商编号', sort: true }
  107. , { field: 'ChannelSerial', width: 200, title: '渠道流水号', sort: true }
  108. , { field: 'TradeSerialNo', width: 200, title: '贸易序列号', sort: true }
  109. // , { field: 'Sort', fixed: 'right', title: '排序', width: 80, edit: 'text' }
  110. , { title: '操作', align: 'center', width: 100, fixed: 'right', toolbar: '#table-list-tools' }
  111. ]]
  112. , where: {
  113. }
  114. , page: true
  115. , limit: 30
  116. , height: 'full-220'
  117. , text: '对不起,加载出现异常!'
  118. , done: function (res, curr, count) {
  119. $(".layui-none").text("无数据");
  120. }
  121. });
  122. //监听工具条
  123. table.on('tool(LAY-list-manage)', function (obj) {
  124. var data = obj.data;
  125. if (obj.event === 'del') {
  126. var index = layer.confirm('确定要删除吗?删除后不能恢复!', function (index) {
  127. $.ajax({
  128. type: "POST",
  129. url: "/Admin/SpTradeRecord/Delete?r=" + Math.random(1),
  130. data: "Id=" + data.Id,
  131. dataType: "text",
  132. success: function (data) {
  133. if (data == "success") {
  134. obj.del();
  135. layer.close(index);
  136. } else {
  137. parent.layer.msg(data);
  138. }
  139. }
  140. });
  141. });
  142. } else if (obj.event === 'push') {
  143. var index = layer.confirm('确定要推送吗?推送后不能撤回!', function (index) {
  144. $.ajax({
  145. type: "POST",
  146. url: "/Admin/SpTradeRecord/push?r=" + Math.random(1),
  147. data: "Id=" + data.Id,
  148. dataType: "text",
  149. success: function (data) {
  150. layer.close(index);
  151. if (data == "success") {
  152. parent.layer.msg('推送成功');
  153. } else {
  154. parent.layer.msg(data);
  155. }
  156. }
  157. });
  158. });
  159. } else if (obj.event === 'edit') {
  160. var tr = $(obj.tr);
  161. var perContent = layer.open({
  162. type: 2
  163. , title: '交易记录-编辑'
  164. , content: 'Edit?Id=' + data.Id + ''
  165. , maxmin: true
  166. , area: ['500px', '450px']
  167. , btn: ['确定', '取消']
  168. , yes: function (index, layero) {
  169. var iframeWindow = window['layui-layer-iframe' + index]
  170. , submitID = 'LAY-list-front-submit'
  171. , submit = layero.find('iframe').contents().find('#' + submitID);
  172. setTimeout(function () {
  173. layero.find('iframe').contents().find('.layui-tab-item').each(function (i) {
  174. var errObj = $(this).find('.layui-form-danger');
  175. if (errObj.length > 0) {
  176. iframeWindow.element.tabChange('mytabbar', String(i + 1));
  177. submit.click();
  178. }
  179. });
  180. }, 300);
  181. //监听提交
  182. iframeWindow.layui.form.on('submit(' + submitID + ')', function (data) {
  183. var field = data.field; //获取提交的字段
  184. var userdata = "";
  185. for (var prop in field) {
  186. userdata += prop + "=" + encodeURIComponent(field[prop]) + "&";
  187. }
  188. //提交 Ajax 成功后,静态更新表格中的数据
  189. //$.ajax({});
  190. $.ajax({
  191. type: "POST",
  192. url: "/Admin/SpTradeRecord/Edit?r=" + Math.random(1),
  193. data: userdata,
  194. dataType: "text",
  195. success: function (data) {
  196. layer.close(index); //关闭弹层
  197. if (data == "success") {
  198. table.reload('LAY-list-manage'); //数据刷新
  199. } else {
  200. layer.msg(data);
  201. }
  202. }
  203. });
  204. });
  205. submit.trigger('click');
  206. }
  207. , success: function (layero, index) {
  208. }
  209. });
  210. layer.full(perContent);
  211. }
  212. });
  213. //监听搜索
  214. form.on('submit(LAY-list-front-search)', function (data) {
  215. var field = data.field;
  216. //执行重载
  217. table.reload('LAY-list-manage', {
  218. where: field,
  219. page: {
  220. curr: 1
  221. }
  222. });
  223. });
  224. form.on('submit(LAY-list-front-searchall)', function (data) {
  225. table.reload('LAY-list-manage', {
  226. where: null,
  227. page: {
  228. curr: 1
  229. }
  230. });
  231. });
  232. //事件
  233. var active = {
  234. batchdel: function () {
  235. var checkStatus = table.checkStatus('LAY-list-manage')
  236. , data = checkStatus.data; //得到选中的数据
  237. if (data.length < 1) {
  238. parent.layer.msg("请选择要删除的项");
  239. } else {
  240. var ids = "";
  241. $.each(data, function (index, value) {
  242. ids += data[index].Id + ",";
  243. });
  244. ids = ids.substring(0, ids.length - 1);
  245. var index = layer.confirm('确定要删除吗?删除后不能恢复!', function (index) {
  246. $.ajax({
  247. type: "POST",
  248. url: "/Admin/SpTradeRecord/Delete?r=" + Math.random(1),
  249. data: "Id=" + ids,
  250. dataType: "text",
  251. success: function (data) {
  252. layer.close(index);
  253. if (data == "success") {
  254. table.reload('LAY-list-manage');
  255. } else {
  256. layer.msg(data);
  257. }
  258. }
  259. });
  260. });
  261. }
  262. }
  263. , add: function () {
  264. var perContent = layer.open({
  265. type: 2
  266. , title: '交易记录-添加'
  267. , content: 'Add'
  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/SpTradeRecord/Add?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. });
  311. layer.full(perContent);
  312. }
  313. , ImportData: function () {
  314. ExcelKind = 1;
  315. layer.open({
  316. type: 1,
  317. title: '导入',
  318. maxmin: false,
  319. area: ['460px', '280px'],
  320. content: $('#excelForm'),
  321. cancel: function () {
  322. }
  323. });
  324. $("#excelTemp").html('<a href="/excelfile/模板文件.xlsx">点击下载模板文件</a>');
  325. }
  326. , ExportExcel: function () {
  327. var userdata = '';
  328. $(".layuiadmin-card-header-auto input").each(function (i) {
  329. userdata += $(this).attr('name') + '=' + encodeURIComponent($(this).val()) + '&';
  330. });
  331. $(".layuiadmin-card-header-auto select").each(function (i) {
  332. userdata += $(this).attr('name') + '=' + encodeURIComponent($(this).val()) + '&';
  333. });
  334. $.ajax({
  335. type: "GET",
  336. url: "/Admin/SpTradeRecord/ExportExcel?r=" + Math.random(1),
  337. data: userdata,
  338. dataType: "json",
  339. success: function (data) {
  340. data.Obj.unshift(data.Fields);
  341. excel.exportExcel(data.Obj, data.Info, 'xlsx');
  342. }
  343. });
  344. }
  345. , Open: function () {
  346. var checkStatus = table.checkStatus('LAY-list-manage')
  347. , data = checkStatus.data; //得到选中的数据
  348. if (data.length < 1) {
  349. parent.layer.msg("请选择要开启的项");
  350. } else {
  351. var ids = "";
  352. $.each(data, function (index, value) {
  353. ids += data[index].Id + ",";
  354. });
  355. ids = ids.substring(0, ids.length - 1);
  356. var index = layer.confirm('确定要开启吗?', function (index) {
  357. $.ajax({
  358. type: "POST",
  359. url: "/Admin/SpTradeRecord/Open?r=" + Math.random(1),
  360. data: "Id=" + ids,
  361. dataType: "text",
  362. success: function (data) {
  363. layer.close(index);
  364. if (data == "success") {
  365. table.reload('LAY-list-manage');
  366. } else {
  367. layer.msg(data);
  368. }
  369. }
  370. });
  371. });
  372. }
  373. }
  374. , Close: function () {
  375. var checkStatus = table.checkStatus('LAY-list-manage')
  376. , data = checkStatus.data; //得到选中的数据
  377. if (data.length < 1) {
  378. parent.layer.msg("请选择要关闭的项");
  379. } else {
  380. var ids = "";
  381. $.each(data, function (index, value) {
  382. ids += data[index].Id + ",";
  383. });
  384. ids = ids.substring(0, ids.length - 1);
  385. var index = layer.confirm('确定要关闭吗?', function (index) {
  386. $.ajax({
  387. type: "POST",
  388. url: "/Admin/SpTradeRecord/Close?r=" + Math.random(1),
  389. data: "Id=" + ids,
  390. dataType: "text",
  391. success: function (data) {
  392. layer.close(index);
  393. if (data == "success") {
  394. table.reload('LAY-list-manage');
  395. } else {
  396. layer.msg(data);
  397. }
  398. }
  399. });
  400. });
  401. }
  402. }
  403. };
  404. $('.layui-btn').on('click', function () {
  405. var type = $(this).data('type');
  406. active[type] ? active[type].call(this) : '';
  407. });
  408. });