MerchantRebateDetail_Admin.js 16 KB

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