StoreHouseAmountPromiss_Admin.js 16 KB

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