Users_Admin.js 16 KB

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