TradeRecord_Admin.js 17 KB

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