StoreHouseCardAmountRecord_Admin.js 16 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420
  1. var ExcelData, ExcelKind;
  2. function ConfirmImport() {
  3. $.ajax({
  4. type: "POST",
  5. url: "/Admin/StoreHouseAmountRecord/Imports?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 if (data.indexOf("warning") == 0) {
  14. var datalist = data.split('|');
  15. layer.alert(datalist[0], { time: 20000 }, function () {
  16. window.location.reload();
  17. });
  18. } else {
  19. layer.msg(data);
  20. }
  21. }
  22. });
  23. }
  24. var excel;
  25. layui.config({
  26. base: '/layuiadmin/' //静态资源所在路径
  27. }).extend({
  28. myexcel: 'layui/lay/modules/excel',
  29. index: 'lib/index' //主入口模块
  30. }).use(['index', 'table', 'excel', 'laydate'], function () {
  31. var $ = layui.$
  32. , form = layui.form
  33. , table = layui.table;
  34. //- 筛选条件-日期
  35. var laydate = layui.laydate;
  36. var layCreateDate = laydate.render({
  37. elem: '#CreateDate',
  38. type: 'date',
  39. range: true,
  40. trigger: 'click',
  41. change: function (value, date, endDate) {
  42. var op = true;
  43. if (date.year == endDate.year && endDate.month - date.month <= 1) {
  44. if (endDate.month - date.month == 1 && endDate.date > date.date) {
  45. op = false;
  46. layCreateDate.hint('日期范围请不要超过1个月');
  47. setTimeout(function () {
  48. $(".laydate-btns-confirm").addClass("laydate-disabled");
  49. }, 1);
  50. }
  51. } else {
  52. op = false;
  53. layCreateDate.hint('日期范围请不要超过1个月');
  54. setTimeout(function () {
  55. $(".laydate-btns-confirm").addClass("laydate-disabled");
  56. }, 1);
  57. }
  58. if (op) {
  59. $('#CreateDate').val(value);
  60. }
  61. }
  62. });
  63. //excel导入
  64. excel = layui.excel;
  65. $('#ExcelFile').change(function (e) {
  66. var files = e.target.files;
  67. excel.importExcel(files, {}, function (data) {
  68. ExcelData = data[0].sheet1;
  69. });
  70. });
  71. //监听单元格编辑
  72. table.on('edit(LAY-list-manage)', function (obj) {
  73. var value = obj.value //得到修改后的值
  74. , data = obj.data //得到所在行所有键值
  75. , field = obj.field; //得到字段
  76. if (field == "Sort") {
  77. $.ajax({
  78. type: "POST",
  79. url: "/Admin/StoreHouseAmountRecord/Sort?r=" + Math.random(1),
  80. data: "Id=" + data.Id + "&Sort=" + value,
  81. dataType: "text",
  82. success: function (data) {
  83. }
  84. });
  85. }
  86. });
  87. //列表数据
  88. table.render({
  89. elem: '#LAY-list-manage'
  90. , url: '/Admin/StoreHouseAmountRecord/IndexsData' //模拟接口
  91. , cols: [[
  92. { type: 'checkbox', fixed: 'left' }
  93. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  94. , { field: 'Status', width: 200, title: '状态', sort: true }
  95. , { field: 'UserIdRealName', width: 200, title: '创客真实姓名', sort: true }
  96. , { field: 'UserIdMakerCode', width: 200, title: '创客创客编号', sort: true }
  97. , { field: 'CreateDate', width: 200, title: '创建时间', sort: true }
  98. , { field: 'UseAmount', width: 200, title: '申请提现临额', sort: true }
  99. , { field: 'CertId', width: 200, title: '身份证号', sort: true }
  100. , { field: 'SettleBankCardNo', width: 200, title: '银行卡号', sort: true }
  101. , { field: 'SettleBankName', width: 200, title: '银行名称', sort: true }
  102. , { field: 'Mobile', width: 200, title: '手机号', sort: true }
  103. , { field: 'Type', width: 200, title: '交易类型', sort: true }
  104. // , { field: 'Sort', fixed: 'right', title: '排序', width: 80, edit: 'text' }
  105. // , { title: '操作', align: 'center', fixed: 'right', toolbar: '#table-list-tools' }
  106. ]]
  107. , where: {
  108. }
  109. , page: true
  110. , limit: 30
  111. , height: 'full-220'
  112. , text: '对不起,加载出现异常!'
  113. , done: function (res, curr, count) {
  114. $(".layui-none").text("无数据");
  115. }
  116. });
  117. //监听工具条
  118. table.on('tool(LAY-list-manage)', function (obj) {
  119. var data = obj.data;
  120. if (obj.event === 'del') {
  121. var index = layer.confirm('确定要删除吗?删除后不能恢复!', function (index) {
  122. $.ajax({
  123. type: "POST",
  124. url: "/Admin/StoreHouseAmountRecord/Delete?r=" + Math.random(1),
  125. data: "Id=" + data.Id,
  126. dataType: "text",
  127. success: function (data) {
  128. if (data == "success") {
  129. obj.del();
  130. layer.close(index);
  131. } else {
  132. parent.layer.msg(data);
  133. }
  134. }
  135. });
  136. });
  137. } else if (obj.event === 'edit') {
  138. var tr = $(obj.tr);
  139. var perContent = layer.open({
  140. type: 2
  141. , title: '分仓机具额度记录-编辑'
  142. , content: 'Edit?Id=' + data.Id + ''
  143. , maxmin: true
  144. , area: ['500px', '450px']
  145. , btn: ['确定', '取消']
  146. , yes: function (index, layero) {
  147. var iframeWindow = window['layui-layer-iframe' + index]
  148. , submitID = 'LAY-list-front-submit'
  149. , submit = layero.find('iframe').contents().find('#' + submitID);
  150. setTimeout(function () {
  151. layero.find('iframe').contents().find('.layui-tab-item').each(function (i) {
  152. var errObj = $(this).find('.layui-form-danger');
  153. if (errObj.length > 0) {
  154. iframeWindow.element.tabChange('mytabbar', String(i + 1));
  155. submit.click();
  156. }
  157. });
  158. }, 300);
  159. //监听提交
  160. iframeWindow.layui.form.on('submit(' + submitID + ')', function (data) {
  161. var field = data.field; //获取提交的字段
  162. var userdata = "";
  163. for (var prop in field) {
  164. userdata += prop + "=" + encodeURIComponent(field[prop]) + "&";
  165. }
  166. //提交 Ajax 成功后,静态更新表格中的数据
  167. //$.ajax({});
  168. $.ajax({
  169. type: "POST",
  170. url: "/Admin/StoreHouseAmountRecord/Edit?r=" + Math.random(1),
  171. data: userdata,
  172. dataType: "text",
  173. success: function (data) {
  174. layer.close(index); //关闭弹层
  175. if (data == "success") {
  176. table.reload('LAY-list-manage'); //数据刷新
  177. } else {
  178. layer.msg(data);
  179. }
  180. }
  181. });
  182. });
  183. submit.trigger('click');
  184. }
  185. , success: function (layero, index) {
  186. }
  187. });
  188. layer.full(perContent);
  189. }
  190. });
  191. //监听搜索
  192. form.on('submit(LAY-list-front-search)', function (data) {
  193. var field = data.field;
  194. //执行重载
  195. table.reload('LAY-list-manage', {
  196. where: field,
  197. page: {
  198. curr: 1
  199. }
  200. });
  201. });
  202. form.on('submit(LAY-list-front-searchall)', function (data) {
  203. table.reload('LAY-list-manage', {
  204. where: null,
  205. page: {
  206. curr: 1
  207. }
  208. });
  209. });
  210. //事件
  211. var active = {
  212. batchdel: function () {
  213. var checkStatus = table.checkStatus('LAY-list-manage')
  214. , data = checkStatus.data; //得到选中的数据
  215. if (data.length < 1) {
  216. parent.layer.msg("请选择要删除的项");
  217. } else {
  218. var ids = "";
  219. $.each(data, function (index, value) {
  220. ids += data[index].Id + ",";
  221. });
  222. ids = ids.substring(0, ids.length - 1);
  223. var index = layer.confirm('确定要删除吗?删除后不能恢复!', function (index) {
  224. $.ajax({
  225. type: "POST",
  226. url: "/Admin/StoreHouseAmountRecord/Delete?r=" + Math.random(1),
  227. data: "Id=" + ids,
  228. dataType: "text",
  229. success: function (data) {
  230. layer.close(index);
  231. if (data == "success") {
  232. table.reload('LAY-list-manage');
  233. } else {
  234. layer.msg(data);
  235. }
  236. }
  237. });
  238. });
  239. }
  240. }
  241. , add: function () {
  242. var perContent = layer.open({
  243. type: 2
  244. , title: '分仓机具额度记录-添加'
  245. , content: 'Add'
  246. , maxmin: true
  247. , area: ['500px', '450px']
  248. , btn: ['确定', '取消']
  249. , yes: function (index, layero) {
  250. var iframeWindow = window['layui-layer-iframe' + index]
  251. , submitID = 'LAY-list-front-submit'
  252. , submit = layero.find('iframe').contents().find('#' + submitID);
  253. setTimeout(function () {
  254. layero.find('iframe').contents().find('.layui-tab-item').each(function (i) {
  255. var errObj = $(this).find('.layui-form-danger');
  256. if (errObj.length > 0) {
  257. iframeWindow.element.tabChange('mytabbar', String(i + 1));
  258. submit.click();
  259. }
  260. });
  261. }, 300);
  262. //监听提交
  263. iframeWindow.layui.form.on('submit(' + submitID + ')', function (data) {
  264. var field = data.field; //获取提交的字段
  265. var userdata = "";
  266. for (var prop in field) {
  267. userdata += prop + "=" + encodeURIComponent(field[prop]) + "&";
  268. }
  269. //提交 Ajax 成功后,静态更新表格中的数据
  270. //$.ajax({});
  271. $.ajax({
  272. type: "POST",
  273. url: "/Admin/StoreHouseAmountRecord/Add?r=" + Math.random(1),
  274. data: userdata,
  275. dataType: "text",
  276. success: function (data) {
  277. layer.close(index); //关闭弹层
  278. if (data == "success") {
  279. table.reload('LAY-list-manage'); //数据刷新
  280. } else {
  281. layer.msg(data);
  282. }
  283. }
  284. });
  285. });
  286. submit.trigger('click');
  287. }
  288. });
  289. layer.full(perContent);
  290. }
  291. , ImportData: function () {
  292. ExcelKind = 1;
  293. layer.open({
  294. type: 1,
  295. title: '导入',
  296. maxmin: false,
  297. area: ['460px', '280px'],
  298. content: $('#excelForm'),
  299. cancel: function () {
  300. }
  301. });
  302. $("#excelTemp");
  303. }
  304. , ExportExcel: function () {
  305. var userdata = '';
  306. $(".layuiadmin-card-header-auto input").each(function (i) {
  307. userdata += $(this).attr('name') + '=' + encodeURIComponent($(this).val()) + '&';
  308. });
  309. $(".layuiadmin-card-header-auto select").each(function (i) {
  310. userdata += $(this).attr('name') + '=' + encodeURIComponent($(this).val()) + '&';
  311. });
  312. $.ajax({
  313. type: "GET",
  314. url: "/Admin/StoreHouseAmountRecord/ExportsExcel?r=" + Math.random(1),
  315. data: userdata,
  316. dataType: "json",
  317. success: function (data) {
  318. data.Obj.unshift(data.Fields);
  319. excel.exportExcel(data.Obj, data.Info, 'xlsx');
  320. window.location.reload();
  321. }
  322. });
  323. }
  324. , BatchSetting: function () {
  325. var checkStatus = table.checkStatus('LAY-list-manage')
  326. , data = checkStatus.data; //得到选中的数据
  327. if (data.length < 1) {
  328. parent.layer.msg("请选择要设置的项");
  329. } else {
  330. var ids = "";
  331. $.each(data, function (index, value) {
  332. ids += data[index].Id + ",";
  333. });
  334. ids = ids.substring(0, ids.length - 1);
  335. var index = layer.confirm('确定批量设置完成记录吗?', function (index) {
  336. $.ajax({
  337. type: "POST",
  338. url: "/Admin/StoreHouseAmountRecord/BatchSetting?r=" + Math.random(1),
  339. data: "Id=" + ids,
  340. dataType: "text",
  341. success: function (data) {
  342. layer.close(index);
  343. if (data == "success") {
  344. table.reload('LAY-list-manage');
  345. } else {
  346. layer.msg(data);
  347. }
  348. }
  349. });
  350. });
  351. }
  352. }
  353. , Close: function () {
  354. var checkStatus = table.checkStatus('LAY-list-manage')
  355. , data = checkStatus.data; //得到选中的数据
  356. if (data.length < 1) {
  357. parent.layer.msg("请选择要关闭的项");
  358. } else {
  359. var ids = "";
  360. $.each(data, function (index, value) {
  361. ids += data[index].Id + ",";
  362. });
  363. ids = ids.substring(0, ids.length - 1);
  364. var index = layer.confirm('确定要关闭吗?', function (index) {
  365. $.ajax({
  366. type: "POST",
  367. url: "/Admin/StoreHouseAmountRecord/Close?r=" + Math.random(1),
  368. data: "Id=" + ids,
  369. dataType: "text",
  370. success: function (data) {
  371. layer.close(index);
  372. if (data == "success") {
  373. table.reload('LAY-list-manage');
  374. } else {
  375. layer.msg(data);
  376. }
  377. }
  378. });
  379. });
  380. }
  381. }
  382. };
  383. $('.layui-btn').on('click', function () {
  384. var type = $(this).data('type');
  385. active[type] ? active[type].call(this) : '';
  386. });
  387. });