UserAccountRecord_Admin.js 18 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429
  1. var ExcelData;
  2. function ConfirmImport() {
  3. $.ajax({
  4. type: "POST",
  5. url: "/Admin/UserAccountRecord/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: 'date',
  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 <= 2) {
  39. if (endDate.month - date.month == 2 && endDate.date > date.date) {
  40. op = false;
  41. layCreateDate.hint('日期范围请不要超过2个月');
  42. setTimeout(function () {
  43. $(".laydate-btns-confirm").addClass("laydate-disabled");
  44. }, 1);
  45. }
  46. } else {
  47. op = false;
  48. layCreateDate.hint('日期范围请不要超过2个月');
  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/UserAccountRecord/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/UserAccountRecord/IndexData' //模拟接口
  86. , cols: [[
  87. { type: 'checkbox', fixed: 'left' }
  88. , { field: 'MakerCode', width: 105, title: '创客编号', sort: true }
  89. , { field: 'RealName', width: 105, title: '创客姓名', sort: true }
  90. // ,{field:'TopMakerCode', width: 200, title:'顶级创客编号', sort: true}
  91. // ,{field:'TopRealName', width: 200, title:'顶级创客名称', sort: true}
  92. , { field: 'ProductTypeName', width: 105, title: '产品类型', sort: true }
  93. // ,{field:'TransRecordNo', width: 200, title:'交易流水编号', sort: true}
  94. , { field: 'ChangeTypeName', width: 110, title: '交易类型', sort: true }
  95. , { field: 'ChangeAmount', width: 110, title: '交易金额', sort: true }
  96. , { field: 'Remark', width: 100, title: '备注', sort: true }
  97. , { field: 'BeforeTotalAmount', width: 130, title: '交易前总金额', sort: true }
  98. , { field: 'AfterTotalAmount', width: 130, title: '交易后总金额', sort: true }
  99. , { field: 'BeforeFreezeAmount', width: 150, title: '交易前冻结金额', sort: true }
  100. , { field: 'AfterFreezeAmount', width: 150, title: '交易后冻结金额', sort: true }
  101. , { field: 'BeforeBalanceAmount', width: 120, title: '交易前余额', sort: true }
  102. , { field: 'AfterBalanceAmount', width: 120, title: '交易后余额', sort: true }
  103. , { field: 'CreateDate', width: 110, title: '交易时间', sort: true }
  104. , { field: 'PosSn', width: 110, title: '机具Sn', sort: true }
  105. ]]
  106. , where: {
  107. UserId: UserId
  108. }
  109. , page: true
  110. , limit: 30
  111. , height: 'full-' + String($('.layui-card-header').height() + 130)
  112. , text: '对不起,加载出现异常!'
  113. , done: function (res, curr, count) {
  114. $("#ChangeTypeAmount0").text(res.other.ChangeTypeAmount0);
  115. $("#ChangeTypeAmount1").text(res.other.ChangeTypeAmount1);
  116. $("#ChangeTypeAmount2").text(res.other.ChangeTypeAmount2);
  117. $("#ChangeTypeAmount3").text(res.other.ChangeTypeAmount3);
  118. $("#ChangeTypeAmount4").text(res.other.ChangeTypeAmount4);
  119. $("#ChangeTypeAmount5").text(res.other.ChangeTypeAmount5);
  120. $("#ChangeTypeAmount6").text(res.other.ChangeTypeAmount6);
  121. $("#ChangeTypeAmount61").text(res.other.ChangeTypeAmount61);
  122. $("#ChangeTypeAmount62").text(res.other.ChangeTypeAmount62);
  123. $("#ChangeTypeAmount63").text(res.other.ChangeTypeAmount63);
  124. $("#ChangeTypeAmount64").text(res.other.ChangeTypeAmount64);
  125. $("#ChangeTypeAmount50").text(res.other.ChangeTypeAmount50);
  126. $("#ChangeTypeAmount111").text(res.other.ChangeTypeAmount111);
  127. $("#ChangeTypeAmount112").text(res.other.ChangeTypeAmount112);
  128. $("#ChangeTypeAmount60").text(res.other.ChangeTypeAmount60);
  129. $("#ChangeTypeAmount31").text(res.other.ChangeTypeAmount31);
  130. $("#ChangeTypeAmount124").text(res.other.ChangeTypeAmount124);
  131. $("#ChangeTypeAmount125").text(res.other.ChangeTypeAmount125);
  132. $(".layui-none").text("无数据");
  133. }
  134. });
  135. //监听工具条
  136. table.on('tool(LAY-list-manage)', function (obj) {
  137. var data = obj.data;
  138. if (obj.event === 'del') {
  139. var index = layer.confirm('确定要删除吗?删除后不能恢复!', function (index) {
  140. $.ajax({
  141. type: "POST",
  142. url: "/Admin/UserAccountRecord/Delete?r=" + Math.random(1),
  143. data: "Id=" + data.Id,
  144. dataType: "text",
  145. success: function (data) {
  146. if (data == "success") {
  147. obj.del();
  148. layer.close(index);
  149. } else {
  150. parent.layer.msg(data);
  151. }
  152. }
  153. });
  154. });
  155. } else if (obj.event === 'edit') {
  156. var tr = $(obj.tr);
  157. var perContent = layer.open({
  158. type: 2
  159. , title: '创客账户变动记录-编辑'
  160. , content: 'Edit?Id=' + data.Id + ''
  161. , maxmin: true
  162. , area: ['500px', '450px']
  163. , btn: ['确定', '取消']
  164. , yes: function (index, layero) {
  165. var iframeWindow = window['layui-layer-iframe' + index]
  166. , submitID = 'LAY-list-front-submit'
  167. , submit = layero.find('iframe').contents().find('#' + submitID);
  168. setTimeout(function () {
  169. layero.find('iframe').contents().find('.layui-tab-item').each(function (i) {
  170. var errObj = $(this).find('.layui-form-danger');
  171. if (errObj.length > 0) {
  172. iframeWindow.element.tabChange('mytabbar', String(i + 1));
  173. submit.click();
  174. }
  175. });
  176. }, 300);
  177. //监听提交
  178. iframeWindow.layui.form.on('submit(' + submitID + ')', function (data) {
  179. var field = data.field; //获取提交的字段
  180. var userdata = "";
  181. for (var prop in field) {
  182. userdata += prop + "=" + encodeURIComponent(field[prop]) + "&";
  183. }
  184. //提交 Ajax 成功后,静态更新表格中的数据
  185. //$.ajax({});
  186. $.ajax({
  187. type: "POST",
  188. url: "/Admin/UserAccountRecord/Edit?r=" + Math.random(1),
  189. data: userdata,
  190. dataType: "text",
  191. success: function (data) {
  192. layer.close(index); //关闭弹层
  193. if (data == "success") {
  194. table.reload('LAY-list-manage'); //数据刷新
  195. } else {
  196. layer.msg(data);
  197. }
  198. }
  199. });
  200. });
  201. submit.trigger('click');
  202. }
  203. , success: function (layero, index) {
  204. }
  205. });
  206. layer.full(perContent);
  207. }
  208. });
  209. //监听搜索
  210. form.on('submit(LAY-list-front-search)', function (data) {
  211. var field = data.field;
  212. //执行重载
  213. table.reload('LAY-list-manage', {
  214. where: field
  215. });
  216. });
  217. form.on('submit(LAY-list-front-searchall)', function (data) {
  218. table.reload('LAY-list-manage', {
  219. where: {
  220. UserId: UserId
  221. }
  222. });
  223. });
  224. //事件
  225. var active = {
  226. batchdel: function () {
  227. var checkStatus = table.checkStatus('LAY-list-manage')
  228. , data = checkStatus.data; //得到选中的数据
  229. if (data.length < 1) {
  230. parent.layer.msg("请选择要删除的项");
  231. } else {
  232. var ids = "";
  233. $.each(data, function (index, value) {
  234. ids += data[index].Id + ",";
  235. });
  236. ids = ids.substring(0, ids.length - 1);
  237. var index = layer.confirm('确定要删除吗?删除后不能恢复!', function (index) {
  238. $.ajax({
  239. type: "POST",
  240. url: "/Admin/UserAccountRecord/Delete?r=" + Math.random(1),
  241. data: "Id=" + ids,
  242. dataType: "text",
  243. success: function (data) {
  244. layer.close(index);
  245. if (data == "success") {
  246. table.reload('LAY-list-manage');
  247. } else {
  248. layer.msg(data);
  249. }
  250. }
  251. });
  252. });
  253. }
  254. }
  255. , add: function () {
  256. var perContent = layer.open({
  257. type: 2
  258. , title: '创客账户变动记录-添加'
  259. , content: 'Add'
  260. , maxmin: true
  261. , area: ['500px', '450px']
  262. , btn: ['确定', '取消']
  263. , yes: function (index, layero) {
  264. var iframeWindow = window['layui-layer-iframe' + index]
  265. , submitID = 'LAY-list-front-submit'
  266. , submit = layero.find('iframe').contents().find('#' + submitID);
  267. setTimeout(function () {
  268. layero.find('iframe').contents().find('.layui-tab-item').each(function (i) {
  269. var errObj = $(this).find('.layui-form-danger');
  270. if (errObj.length > 0) {
  271. iframeWindow.element.tabChange('mytabbar', String(i + 1));
  272. submit.click();
  273. }
  274. });
  275. }, 300);
  276. //监听提交
  277. iframeWindow.layui.form.on('submit(' + submitID + ')', function (data) {
  278. var field = data.field; //获取提交的字段
  279. var userdata = "";
  280. for (var prop in field) {
  281. userdata += prop + "=" + encodeURIComponent(field[prop]) + "&";
  282. }
  283. //提交 Ajax 成功后,静态更新表格中的数据
  284. //$.ajax({});
  285. $.ajax({
  286. type: "POST",
  287. url: "/Admin/UserAccountRecord/Add?r=" + Math.random(1),
  288. data: userdata,
  289. dataType: "text",
  290. success: function (data) {
  291. layer.close(index); //关闭弹层
  292. if (data == "success") {
  293. table.reload('LAY-list-manage'); //数据刷新
  294. } else {
  295. layer.msg(data);
  296. }
  297. }
  298. });
  299. });
  300. submit.trigger('click');
  301. }
  302. });
  303. layer.full(perContent);
  304. }
  305. , ImportData: function () {
  306. layer.open({
  307. type: 1,
  308. title: '导入',
  309. maxmin: false,
  310. area: ['460px', '180px'],
  311. content: $('#excelForm'),
  312. cancel: function () {
  313. }
  314. });
  315. }
  316. , ExportExcel: function () {
  317. var userdata = '';
  318. $(".layuiadmin-card-header-auto input").each(function (i) {
  319. userdata += $(this).attr('name') + '=' + encodeURIComponent($(this).val()) + '&';
  320. });
  321. $(".layuiadmin-card-header-auto select").each(function (i) {
  322. userdata += $(this).attr('name') + '=' + encodeURIComponent($(this).val()) + '&';
  323. });
  324. $.ajax({
  325. type: "GET",
  326. url: "/Admin/UserAccountRecord/ExportExcel?r=" + Math.random(1),
  327. data: userdata,
  328. dataType: "json",
  329. success: function (data) {
  330. data.Obj.unshift(data.Fields);
  331. excel.exportExcel(data.Obj, data.Info, 'xlsx');
  332. }
  333. });
  334. }
  335. , Open: function () {
  336. var checkStatus = table.checkStatus('LAY-list-manage')
  337. , data = checkStatus.data; //得到选中的数据
  338. if (data.length < 1) {
  339. parent.layer.msg("请选择要开启的项");
  340. } else {
  341. var ids = "";
  342. $.each(data, function (index, value) {
  343. ids += data[index].Id + ",";
  344. });
  345. ids = ids.substring(0, ids.length - 1);
  346. var index = layer.confirm('确定要开启吗?', function (index) {
  347. $.ajax({
  348. type: "POST",
  349. url: "/Admin/UserAccountRecord/Open?r=" + Math.random(1),
  350. data: "Id=" + ids,
  351. dataType: "text",
  352. success: function (data) {
  353. layer.close(index);
  354. if (data == "success") {
  355. table.reload('LAY-list-manage');
  356. } else {
  357. layer.msg(data);
  358. }
  359. }
  360. });
  361. });
  362. }
  363. }
  364. , Close: function () {
  365. var checkStatus = table.checkStatus('LAY-list-manage')
  366. , data = checkStatus.data; //得到选中的数据
  367. if (data.length < 1) {
  368. parent.layer.msg("请选择要关闭的项");
  369. } else {
  370. var ids = "";
  371. $.each(data, function (index, value) {
  372. ids += data[index].Id + ",";
  373. });
  374. ids = ids.substring(0, ids.length - 1);
  375. var index = layer.confirm('确定要关闭吗?', function (index) {
  376. $.ajax({
  377. type: "POST",
  378. url: "/Admin/UserAccountRecord/Close?r=" + Math.random(1),
  379. data: "Id=" + ids,
  380. dataType: "text",
  381. success: function (data) {
  382. layer.close(index);
  383. if (data == "success") {
  384. table.reload('LAY-list-manage');
  385. } else {
  386. layer.msg(data);
  387. }
  388. }
  389. });
  390. });
  391. }
  392. }
  393. };
  394. $('.layui-btn').on('click', function () {
  395. var type = $(this).data('type');
  396. active[type] ? active[type].call(this) : '';
  397. });
  398. });