ProfitRewardRecord_Admin.js 17 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424
  1. var ExcelData,ExcelKind;
  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("导入成功", { 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. //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/ProfitRewardRecord/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/ProfitRewardRecord/IndexData' //模拟接口
  86. , cols: [[
  87. { type: 'checkbox', fixed: 'left' }
  88. , {field:'Id', fixed: 'left', title:'ID', width:80, sort: true, unresize: true}
  89. ,{field:'UserId', width: 200, title:'创客', sort: true}
  90. ,{field:'CreateDate', width: 200, title:'创建时间', sort: true}
  91. ,{field:'ProfitType', width: 200, title:'创客分润类型', sort: true}
  92. ,{field:'OtherTradeAmt', width: 200, title:'其他产品交易总金额', sort: true}
  93. ,{field:'OtherCreditTradeAmt', width: 200, title:'其他产品贷记卡交易总金额', sort: true}
  94. ,{field:'OtherDebitNotCapTradeAmt', width: 200, title:'其他产品借记卡非封顶交易总金额', sort: true}
  95. ,{field:'TradeAmt', width: 200, title:'商户交易总额', sort: true}
  96. ,{field:'CreditTradeAmt', width: 200, title:'贷记卡交易总金额', sort: true}
  97. ,{field:'QrCreditTradeAmt', width: 200, title:'(云闪付)贷记卡交易总金额', sort: true}
  98. ,{field:'NonQrCreditTradeAmt', width: 200, title:'(非云闪付)贷记卡交易总金额', sort: true}
  99. ,{field:'DebitNonCapTradeAmt', width: 200, title:'商户非封顶借记卡交易总额', sort: true}
  100. ,{field:'QrDebitNotCapTradeAmt', width: 200, title:'(云闪付)商户非封顶借记卡交易总额', sort: true}
  101. ,{field:'NonQrDebitNotCapTradeAmt', width: 200, title:'(非云闪付)商户非封顶借记卡交易总额', sort: true}
  102. ,{field:'DebitCapTradeAmt', width: 200, title:'商户借记卡封顶交易总额', sort: true}
  103. ,{field:'DebitCapTradeNum', width: 200, title:'商户借记卡封顶交易总笔数', sort: true}
  104. ,{field:'TradeProfit', width: 200, title:'交易分润', sort: true}
  105. ,{field:'CreditTradeProfit', width: 200, title:'贷记卡分润总金额', sort: true}
  106. ,{field:'QrCreditTradeProfit', width: 200, title:'(云闪付)贷记卡交易分润', sort: true}
  107. ,{field:'NonQrCreditTradeProfit', width: 200, title:'(非云闪付)贷记卡交易分润', sort: true}
  108. ,{field:'DebitNonTradeCapProfit', width: 200, title:'借记卡非封顶交易分润总金额', sort: true}
  109. ,{field:'QrDebitNonTradeCapProfit', width: 200, title:'(云闪付)借记卡非封顶交易分润总金额', sort: true}
  110. ,{field:'NonQrDebitNonTradeCapProfit', width: 200, title:'(非云闪付)借记卡非封顶交易分润总金额', sort: true}
  111. ,{field:'DebitTradeCapProfit', width: 200, title:'借记卡封顶交易分润总金额', sort: true}
  112. ,{field:'CheckStatus', width: 200, title:'验证和同步账户状态', sort: true}
  113. ,{field:'TradeMonth', width: 200, title:'交易月', sort: true}
  114. ,{field:'RecordNo', width: 200, title:'记录单号', sort: true}
  115. , {field:'Sort', fixed: 'right', title:'排序', width:80, edit: 'text'}
  116. , { title: '操作', align: 'center', fixed: 'right', toolbar: '#table-list-tools' }
  117. ]]
  118. , where: {
  119. }
  120. , page: true
  121. , limit: 30
  122. , height: 'full-220'
  123. , text: '对不起,加载出现异常!'
  124. , done: function (res, curr, count) {
  125. $(".layui-none").text("无数据");
  126. }
  127. });
  128. //监听工具条
  129. table.on('tool(LAY-list-manage)', function (obj) {
  130. var data = obj.data;
  131. if (obj.event === 'del') {
  132. var index = layer.confirm('确定要删除吗?删除后不能恢复!', function (index) {
  133. $.ajax({
  134. type: "POST",
  135. url: "/Admin/ProfitRewardRecord/Delete?r=" + Math.random(1),
  136. data: "Id=" + data.Id,
  137. dataType: "text",
  138. success: function (data) {
  139. if (data == "success") {
  140. obj.del();
  141. layer.close(index);
  142. } else {
  143. parent.layer.msg(data);
  144. }
  145. }
  146. });
  147. });
  148. } else if (obj.event === 'edit') {
  149. var tr = $(obj.tr);
  150. var perContent = layer.open({
  151. type: 2
  152. , title: '分润奖励记录-编辑'
  153. , content: 'Edit?Id=' + data.Id + ''
  154. , maxmin: true
  155. , area: ['500px', '450px']
  156. , btn: ['确定', '取消']
  157. , yes: function (index, layero) {
  158. var iframeWindow = window['layui-layer-iframe' + index]
  159. , submitID = 'LAY-list-front-submit'
  160. , submit = layero.find('iframe').contents().find('#' + submitID);
  161. setTimeout(function () {
  162. layero.find('iframe').contents().find('.layui-tab-item').each(function (i) {
  163. var errObj = $(this).find('.layui-form-danger');
  164. if (errObj.length > 0) {
  165. iframeWindow.element.tabChange('mytabbar', String(i + 1));
  166. submit.click();
  167. }
  168. });
  169. }, 300);
  170. //监听提交
  171. iframeWindow.layui.form.on('submit(' + submitID + ')', function (data) {
  172. var field = data.field; //获取提交的字段
  173. var userdata = "";
  174. for (var prop in field) {
  175. userdata += prop + "=" + encodeURIComponent(field[prop]) + "&";
  176. }
  177. //提交 Ajax 成功后,静态更新表格中的数据
  178. //$.ajax({});
  179. $.ajax({
  180. type: "POST",
  181. url: "/Admin/ProfitRewardRecord/Edit?r=" + Math.random(1),
  182. data: userdata,
  183. dataType: "text",
  184. success: function (data) {
  185. layer.close(index); //关闭弹层
  186. if (data == "success") {
  187. table.reload('LAY-list-manage'); //数据刷新
  188. } else {
  189. layer.msg(data);
  190. }
  191. }
  192. });
  193. });
  194. submit.trigger('click');
  195. }
  196. , success: function (layero, index) {
  197. }
  198. });
  199. layer.full(perContent);
  200. }
  201. });
  202. //监听搜索
  203. form.on('submit(LAY-list-front-search)', function (data) {
  204. var field = data.field;
  205. //执行重载
  206. table.reload('LAY-list-manage', {
  207. where: field
  208. });
  209. });
  210. form.on('submit(LAY-list-front-searchall)', function (data) {
  211. table.reload('LAY-list-manage', {
  212. where: null
  213. });
  214. });
  215. //事件
  216. var active = {
  217. batchdel: function () {
  218. var checkStatus = table.checkStatus('LAY-list-manage')
  219. , data = checkStatus.data; //得到选中的数据
  220. if (data.length < 1) {
  221. parent.layer.msg("请选择要删除的项");
  222. } else {
  223. var ids = "";
  224. $.each(data, function (index, value) {
  225. ids += data[index].Id + ",";
  226. });
  227. ids = ids.substring(0, ids.length - 1);
  228. var index = layer.confirm('确定要删除吗?删除后不能恢复!', function (index) {
  229. $.ajax({
  230. type: "POST",
  231. url: "/Admin/ProfitRewardRecord/Delete?r=" + Math.random(1),
  232. data: "Id=" + ids,
  233. dataType: "text",
  234. success: function (data) {
  235. layer.close(index);
  236. if (data == "success") {
  237. table.reload('LAY-list-manage');
  238. } else {
  239. layer.msg(data);
  240. }
  241. }
  242. });
  243. });
  244. }
  245. }
  246. , add: function () {
  247. var perContent = layer.open({
  248. type: 2
  249. , title: '分润奖励记录-添加'
  250. , content: 'Add'
  251. , maxmin: true
  252. , area: ['500px', '450px']
  253. , btn: ['确定', '取消']
  254. , yes: function (index, layero) {
  255. var iframeWindow = window['layui-layer-iframe' + index]
  256. , submitID = 'LAY-list-front-submit'
  257. , submit = layero.find('iframe').contents().find('#' + submitID);
  258. setTimeout(function () {
  259. layero.find('iframe').contents().find('.layui-tab-item').each(function (i) {
  260. var errObj = $(this).find('.layui-form-danger');
  261. if (errObj.length > 0) {
  262. iframeWindow.element.tabChange('mytabbar', String(i + 1));
  263. submit.click();
  264. }
  265. });
  266. }, 300);
  267. //监听提交
  268. iframeWindow.layui.form.on('submit(' + submitID + ')', function (data) {
  269. var field = data.field; //获取提交的字段
  270. var userdata = "";
  271. for (var prop in field) {
  272. userdata += prop + "=" + encodeURIComponent(field[prop]) + "&";
  273. }
  274. //提交 Ajax 成功后,静态更新表格中的数据
  275. //$.ajax({});
  276. $.ajax({
  277. type: "POST",
  278. url: "/Admin/ProfitRewardRecord/Add?r=" + Math.random(1),
  279. data: userdata,
  280. dataType: "text",
  281. success: function (data) {
  282. layer.close(index); //关闭弹层
  283. if (data == "success") {
  284. table.reload('LAY-list-manage'); //数据刷新
  285. } else {
  286. layer.msg(data);
  287. }
  288. }
  289. });
  290. });
  291. submit.trigger('click');
  292. }
  293. });
  294. layer.full(perContent);
  295. }
  296. , ImportData: function () {
  297. ExcelKind = 1;
  298. layer.open({
  299. type: 1,
  300. title: '导入',
  301. maxmin: false,
  302. area: ['460px', '280px'],
  303. content: $('#excelForm'),
  304. cancel: function () {
  305. }
  306. });
  307. $("#excelTemp").html('<a href="/excelfile/模板文件.xlsx">点击下载模板文件</a>');
  308. }
  309. , ExportExcel: function () {
  310. var userdata = '';
  311. $(".layuiadmin-card-header-auto input").each(function (i) {
  312. userdata += $(this).attr('name') + '=' + encodeURIComponent($(this).val()) + '&';
  313. });
  314. $(".layuiadmin-card-header-auto select").each(function (i) {
  315. userdata += $(this).attr('name') + '=' + encodeURIComponent($(this).val()) + '&';
  316. });
  317. $.ajax({
  318. type: "GET",
  319. url: "/Admin/ProfitRewardRecord/ExportExcel?r=" + Math.random(1),
  320. data: userdata,
  321. dataType: "json",
  322. success: function (data) {
  323. data.Obj.unshift(data.Fields);
  324. excel.exportExcel(data.Obj, data.Info, 'xlsx');
  325. }
  326. });
  327. }
  328. , Open: function () {
  329. var checkStatus = table.checkStatus('LAY-list-manage')
  330. , data = checkStatus.data; //得到选中的数据
  331. if(data.length < 1){
  332. parent.layer.msg("请选择要开启的项");
  333. }else{
  334. var ids = "";
  335. $.each(data, function (index, value) {
  336. ids += data[index].Id + ",";
  337. });
  338. ids = ids.substring(0, ids.length - 1);
  339. var index = layer.confirm('确定要开启吗?', function (index) {
  340. $.ajax({
  341. type: "POST",
  342. url: "/Admin/ProfitRewardRecord/Open?r=" + Math.random(1),
  343. data: "Id=" + ids,
  344. dataType: "text",
  345. success: function (data) {
  346. layer.close(index);
  347. if (data == "success") {
  348. table.reload('LAY-list-manage');
  349. } else {
  350. layer.msg(data);
  351. }
  352. }
  353. });
  354. });
  355. }
  356. }
  357. , Close: function () {
  358. var checkStatus = table.checkStatus('LAY-list-manage')
  359. , data = checkStatus.data; //得到选中的数据
  360. if(data.length < 1){
  361. parent.layer.msg("请选择要关闭的项");
  362. }else{
  363. var ids = "";
  364. $.each(data, function (index, value) {
  365. ids += data[index].Id + ",";
  366. });
  367. ids = ids.substring(0, ids.length - 1);
  368. var index = layer.confirm('确定要关闭吗?', function (index) {
  369. $.ajax({
  370. type: "POST",
  371. url: "/Admin/ProfitRewardRecord/Close?r=" + Math.random(1),
  372. data: "Id=" + ids,
  373. dataType: "text",
  374. success: function (data) {
  375. layer.close(index);
  376. if (data == "success") {
  377. table.reload('LAY-list-manage');
  378. } else {
  379. layer.msg(data);
  380. }
  381. }
  382. });
  383. });
  384. }
  385. }
  386. };
  387. $('.layui-btn').on('click', function () {
  388. var type = $(this).data('type');
  389. active[type] ? active[type].call(this) : '';
  390. });
  391. });