userAccount.js 20 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593
  1. var pageNo = 1;
  2. var totalPages = 0;
  3. var depname = 0;
  4. var companyId = 0;
  5. var param1 = '';
  6. //用户列表
  7. getListDataAjax();
  8. //获取用户列表 ajax请求
  9. function getListDataAjax(queryParam = {}, pageNo = 1) {
  10. queryParam.pageNo = pageNo;
  11. // queryParam.pageSize = 4;
  12. queryParam.roleId = 1;
  13. ajaxRequest(USER_LIT, "POST", queryParam, function(result) {
  14. let data = result.pageList;
  15. let items = '';
  16. data.forEach(function(item, key) {
  17. let posName = "";
  18. if (item.posname == 1) {
  19. posName = "超级管理员"
  20. } else if (item.posname == 2) {
  21. posName = "普通员工"
  22. }
  23. let locked = item.locked ? '未锁定' : '锁定';
  24. items += "<tr>" +
  25. "<td class='status' data-user='" + JSON.stringify(item) + "' data-id=" + item.id + " data-username='" + item.username + "'></td>" +
  26. "<td>" + item.truename + "</td>" +
  27. "<td>" + item.sex + "</td>" +
  28. "<td>" + posName + "</td>" +
  29. "<td>" + getFormatDate(item.ctime.time) + "</td>" +
  30. "<td>" + item.addman + "</td>" +
  31. "<td>" + locked + "</td>" +
  32. "<td>" + item.wrongtimes + "</td>" +
  33. "</tr>"
  34. })
  35. $('#dataList').html(items);
  36. totalPages = result.totalPages;
  37. $('#totalPage').html(totalPages); //总共多少页
  38. $('#dataTotal').html(result.totalCount); //总共多少条数据
  39. $('#currentPage').val(pageNo); //当前页面
  40. let pageFrom = (pageNo - 1) * result.pageSize + 1; //开始
  41. let pageTo = result.pageNo * result.pageSize; //结束
  42. pageTo = pageTo > result.totalCount ? result.totalCount : pageTo;
  43. $('#pageFrom').html(pageFrom);
  44. $('#pageTo').html(pageTo);
  45. // 无数据时
  46. if (!data.length) {
  47. $('.pager.has-data').hide()
  48. $('.pager.no-data').show()
  49. } else {
  50. $('.pager.has-data').show()
  51. $('.pager.no-data').hide()
  52. }
  53. if (pageNo < totalPages) {
  54. $('#nextPageButton,#lastPageButton').removeClass('disabled');
  55. } else {
  56. $('#nextPageButton,#lastPageButton').addClass('disabled');
  57. }
  58. if (pageNo === 1) {
  59. $('#firstPageButton,#prevPageButton').addClass('disabled');
  60. } else {
  61. $('#firstPageButton,#prevPageButton').removeClass('disabled');
  62. }
  63. }, function(errorMsg) {
  64. alert("请求数据失败!");
  65. })
  66. }
  67. //按钮搜索
  68. $('#buttonClick').on('click', function() {
  69. pageNo = 1;
  70. getListDataAjax(getSearchParamObj());
  71. param1 = $('#userName').val()
  72. })
  73. //拼接搜索条件
  74. function getSearchParamObj() {
  75. let queryParam = {};
  76. let userName = $('#userName').val();
  77. queryParam.userName = userName;
  78. if (companyId != 0) {
  79. queryParam.companyId = companyId;
  80. }
  81. if (depname != 0) {
  82. queryParam.depname = depname;
  83. }
  84. return queryParam;
  85. }
  86. //重置表单
  87. $('.reset').click(resetForm);
  88. //分页刷新按钮
  89. $('.pg-refresh').click(resetForm);
  90. //角色列表
  91. getUserRole()
  92. //获取公司树结构 ajax请求
  93. getCompanyTree()
  94. function getCompanyTree() {
  95. ajaxRequest(COMPANY_LIST, "POST", {}, function(result) {
  96. let data = result.data;
  97. let items = '';
  98. let companyItems = '';
  99. let companyDepartmentItems = '<option value="">请选择</option>';
  100. data.forEach(function(item, key) {
  101. items += `<li data-id=${item.ownerId} ><span data-id=${item.ownerId} class="treeCompany"><img class="img" src="images/login.png" alt=""> ${item.ownerName} (${item.userNumber})</span>`;
  102. if (item.child) {
  103. let data = item.child;
  104. items += `<ul class="child-three">`;
  105. data.forEach(function(item, key) {
  106. items += `<li data-id=${item.departmentId} ><span data-id=${item.departmentId} class="treeDepartment"><img class="img" src="images/login.png" alt="">${item.departmentName}</span></li>`
  107. });
  108. items += ` </ul>`;
  109. }
  110. `</li>`
  111. companyItems += `<option value="${item.ownerId}">${item.ownerName}</option>`
  112. if (key == 0) {
  113. let departmentObj = item.child;
  114. if (departmentObj) {
  115. departmentObj.forEach(function(item, key) {
  116. companyDepartmentItems += `<option value="${item.id}">${item.departmentName}</option>`
  117. })
  118. $('#departmentId').html(companyDepartmentItems);
  119. $('#departmentIdUpdate').html(companyDepartmentItems);
  120. }
  121. }
  122. })
  123. $('#child-two').html(items);
  124. $('#companyId').html(companyItems);
  125. $('#companyId2').html(companyItems);
  126. }, function(errorMsg) {
  127. alert("请求数据失败!");
  128. })
  129. }
  130. //获取检测对象设备列表 ajax请求
  131. getTypeListDataAjax()
  132. function getTypeListDataAjax(queryParam = {}) {
  133. ajaxRequest(COMPANY_LIST, "POST", queryParam, function(result) {
  134. // let data = result.pageList;
  135. let data = result.data;
  136. let items = '';
  137. data.forEach(function(item, key) {
  138. items += ` <input type="checkbox" name="device_code" value="${item.ownerId}" lay-skin="primary" title="${item.ownerName}" >`
  139. })
  140. $('#checkselfblock').html(items);
  141. layui.use(['form'], function() {
  142. var form = layui.form;
  143. form.render('checkbox');
  144. });
  145. }, function(errorMsg) {
  146. alert("请求数据失败!");
  147. })
  148. }
  149. //分页操作
  150. $('#firstPageButton').on('click', function() {
  151. pageNo = 1;
  152. getListDataAjax(getSearchParamObj(), 1);
  153. })
  154. $('#lastPageButton').on('click', function() {
  155. pageNo = totalPages;
  156. getListDataAjax(getSearchParamObj(), pageNo);
  157. })
  158. $('#prevPageButton').on('click', function() {
  159. pageNo -= 1;
  160. getListDataAjax(getSearchParamObj(), pageNo);
  161. })
  162. $('#nextPageButton').on('click', function() {
  163. pageNo += 1;
  164. getListDataAjax(getSearchParamObj(), pageNo);
  165. })
  166. //重置表单
  167. function resetForm() {
  168. pageNo = 1
  169. $("#userName").val("");
  170. $('#roleId option').eq(0).prop("selected", true)
  171. getListDataAjax(getSearchParamObj());
  172. param1 = $('#userName').val()
  173. }
  174. //拼接树搜索条件
  175. //角色查询 ajax请求
  176. function getUserRole() {
  177. ajaxRequest(USER_ROLE, "POST", {}, function(result) {
  178. $("#loading").empty()
  179. let data = result.data;
  180. let roleItems = '';
  181. let roleItems2 = '';
  182. data.forEach(function(item, key) {
  183. roleItems += `<option value="${item.roleId}">${item.roleName}</option>`
  184. roleItems2 += `<option value="${item.roleId}">${item.roleName}</option>`
  185. })
  186. $('#roleId').append(roleItems);
  187. $('#roleId2').html(roleItems2);
  188. $('#roleId3').html(roleItems2);
  189. }, function(errorMsg) {
  190. alert("请求数据失败!");
  191. })
  192. }
  193. /*新增 修改 关闭 弹框*/
  194. var layer = layui.layer;
  195. var layerCreateIndex = '';
  196. var layerUpdateIndex = ''
  197. layui.use('layer', function() {
  198. //新增弹框
  199. $('.add').click(function() {
  200. layerCreateIndex = layer.open({
  201. type: 1,
  202. title: false,
  203. closeBtn: 0,
  204. skin: 'yourclass',
  205. area: ['410px', '500px'],
  206. content: $(".addUserOut"),
  207. success: function() {
  208. $('.clsBtn,.cancel').click(function() {
  209. layer.close(layerCreateIndex);
  210. })
  211. }
  212. })
  213. })
  214. //修改弹框信息
  215. $('.edit').click(function() {
  216. if (!$('.pure-table tr').has('.checked').length) {
  217. layer.msg('请选择一条需要修改的信息!', { icon: 5 });
  218. } else {
  219. let dataId = $('.pure-table tr').find('.checked').data('id');
  220. let userInfo = $('.pure-table tr').find('.checked').data('user');
  221. $('.editUserOut input[name=truename').val(userInfo.truename)
  222. $('.editUserOut select[name=sex]').val(userInfo.sex)
  223. $('.editUserOut input[name=phone').val(userInfo.phone)
  224. $('.editUserOut select[name=posname').val(userInfo.posname)
  225. $('.editUserOut select[name=locked]').val(userInfo.locked)
  226. $('.editUserOut select[name=status]').val(userInfo.status)
  227. $('.editUserOut input[name=wrongtimes').val(userInfo.wrongtimes)
  228. // 单位赋值
  229. $('.editUserOut select[name=bian').val(userInfo.bian)
  230. // 复选框赋值
  231. // var checkValue = userInfo.bian;
  232. // if (checkValue) {
  233. // alert(checkValue)
  234. // $(".editUserOut input:checkbox[value=" + checkValue + "]").attr('checked', 'true');
  235. // layui.form.render();
  236. // }
  237. // 部门下拉展示及赋值
  238. if ($('#companyId2').val()) {
  239. listDepname()
  240. function listDepname() {
  241. let companyName = $('#companyId2').find('option:selected').val();
  242. ajaxRequest(COMPANY_LIST, "POST", { "ownerId": companyName }, function(result) {
  243. let companyDepartmentItems = '<option value="">请选择</option>';
  244. let departmentObj = result.data[0].child;
  245. departmentObj.forEach(function(item, key) {
  246. companyDepartmentItems += `<option value="${item.departmentId}">${item.departmentName}</option>`
  247. })
  248. $('#departmentIdUpdate').html(companyDepartmentItems);
  249. }, function(errorMsg) {
  250. alert("请求数据失败!");
  251. })
  252. }
  253. }
  254. // 部门赋值
  255. $('.editUserOut select[name=depname').val(userInfo.depname)
  256. $('.editUserOut input[name=username]').val(userInfo.username)
  257. layerUpdateIndex = layer.open({
  258. type: 1,
  259. title: false,
  260. closeBtn: 0,
  261. skin: 'yourclass',
  262. area: ['410px', '500px'],
  263. content: $(".editUserOut"),
  264. success: function() {
  265. $('.clsBtn,.cancel').click(function() {
  266. // 清除checkbox选中
  267. // $('.editUserOut input[name=device_code]').prop('checked', false);
  268. // layui.form.render();
  269. layer.close(layerUpdateIndex);
  270. })
  271. }
  272. });
  273. }
  274. })
  275. //删除信息
  276. $('.delete').click(function() {
  277. if (!$('.pure-table tr').has('.checked').length) {
  278. //layer.msg('请选择一条需要修改的信息');
  279. layer.msg('请选择一条需要删除的信息!', { icon: 5 });
  280. } else {
  281. let dataUserName = $('.pure-table tr').find('.checked').data('username');
  282. ajaxRequest(USER_DELETE, "POST", { "username": dataUserName }, function(result) {
  283. $(".pure-table tbody tr.selected").remove()
  284. layer.close(layer.layerCreateIndex);
  285. layer.msg('删除成功!', { icon: 6 });
  286. getListDataAjax()
  287. }, function(errorMsg) {
  288. alert("用户删除失败!");
  289. })
  290. }
  291. })
  292. });
  293. /* 新增用户发送请求 */
  294. $('#addUser').click(function() {
  295. //获取表单的值
  296. let userAddObj = $("#addUserForm").serializeArray();
  297. //发送给服务端的数据格式
  298. let userAddParam = {};
  299. for (let key in userAddObj) { //循环验证······
  300. //验证用户名
  301. if (userAddObj[key].name == 'username') {
  302. if (!userAddObj[key].value) {
  303. alert('请输入用户名');
  304. return;
  305. }
  306. userAddParam['username'] = userAddObj[key].value; // aa
  307. userAddParam['agentid'] = userAddObj[key].value;
  308. } else if (userAddObj[key].name == 'password') {
  309. if (!userAddObj[key].value) {
  310. alert('请输入密码');
  311. return;
  312. }
  313. userAddParam['password'] = md5(userAddObj[key].value);
  314. } else if (userAddObj[key].name == 'age') { //aa验证年龄
  315. if (!userAddObj[key].value) {
  316. alert('请填写年龄');
  317. return;
  318. } else {
  319. let pattern = /^(([0-9]|[1-9][1-9]|1[0-7][0-9])(\\.[0-9]+)?|180)$/;
  320. if (!pattern.test(userAddObj[key].value)) {
  321. alert('请输正确的年龄');
  322. return false;
  323. }
  324. }
  325. userAddParam['age'] = userAddObj[key].value;
  326. } else if (userAddObj[key].name == 'truename') { //aa验证真实姓名
  327. if (!userAddObj[key].value) {
  328. alert('请填写真实姓名');
  329. return;
  330. }
  331. userAddParam['truename'] = userAddObj[key].value;
  332. } else if (userAddObj[key].name == 'phone') { //aa验证手机号
  333. if (!userAddObj[key].value) {
  334. alert('请填写手机号码');
  335. return;
  336. } else {
  337. let telre = /^(13[0-9]|14[0-9]|15[0-9]|17[0-9]|18[0-9])\d{8}$/;
  338. if (!telre.test(userAddObj[key].value)) {
  339. alert('请输入有效的手机号码');
  340. return false;
  341. }
  342. }
  343. userAddParam['phone'] = userAddObj[key].value;
  344. } else {
  345. //其它字段 ....
  346. userAddParam[userAddObj[key].name] = userAddObj[key].value; // aa inputKey[]???
  347. }
  348. }
  349. //验证通过 请求ajax
  350. ajaxRequest(USER_ADD, "POST", userAddParam, function(result) {
  351. let data = result.data;
  352. layer.close(layerCreateIndex);
  353. layer.msg('添加成功!', { icon: 6 });
  354. getListDataAjax();
  355. $('#addUserForm')[0].reset();
  356. }, function(errorMsg) {
  357. alert("用户添加失败!");
  358. })
  359. })
  360. /* 修改用户发送请求 */
  361. $('#editUser').click(function() {
  362. $("#companyId2").removeAttr("disabled");
  363. //获取表单的值
  364. let userEditObj = $("#editUserForm").serializeArray();
  365. //发送给服务端的数据格式
  366. let userEditParam = {};
  367. for (let key in userEditObj) { //循环验证······
  368. //验证用户名
  369. if (userEditObj[key].name == 'username') {
  370. if (!userEditObj[key].value) {
  371. alert('请输入用户名');
  372. return;
  373. }
  374. userEditParam['username'] = userEditObj[key].value; // aa
  375. userEditParam['agentid'] = userEditObj[key].value;
  376. } else if (userEditObj[key].name == 'password') {
  377. if (!userEditObj[key].value) {
  378. alert('请输入密码');
  379. return;
  380. }
  381. userEditParam['password'] = md5(userEditObj[key].value);
  382. } else if (userEditObj[key].name == 'age') { //aa验证年龄
  383. if (!userEditObj[key].value) {
  384. alert('请填写年龄');
  385. return;
  386. } else {
  387. let pattern = /^(([0-9]|[1-9][1-9]|1[0-7][0-9])(\\.[0-9]+)?|180)$/;
  388. if (!pattern.test(userEditObj[key].value)) {
  389. alert('请输正确的年龄');
  390. return false;
  391. }
  392. }
  393. userEditParam['age'] = userEditObj[key].value;
  394. } else if (userEditObj[key].name == 'truename') { //aa验证真实姓名
  395. if (!userEditObj[key].value) {
  396. alert('请填写真实姓名');
  397. return;
  398. }
  399. userEditParam['truename'] = userEditObj[key].value;
  400. } else if (userEditObj[key].name == 'phone') { //aa验证手机号
  401. if (!userEditObj[key].value) {
  402. alert('请填写手机号码');
  403. return;
  404. } else {
  405. let telre = /^(13[0-9]|14[0-9]|15[0-9]|17[0-9]|18[0-9])\d{8}$/;
  406. if (!telre.test(userEditObj[key].value)) {
  407. alert('请输入有效的手机号码');
  408. return false;
  409. }
  410. }
  411. userEditParam['phone'] = userEditObj[key].value;
  412. } else {
  413. //其它字段 ....
  414. userEditParam[userEditObj[key].name] = userEditObj[key].value; // aa inputKey[]???
  415. }
  416. }
  417. //验证通过 请求ajax
  418. ajaxRequest(USER_UPDATE, "POST", userEditParam, function(result) {
  419. $("#companyId2").attr("disabled", "disabled");
  420. let data = result.data;
  421. layer.close(layerUpdateIndex);
  422. layer.msg('修改成功!', { icon: 6 });
  423. getListDataAjax();
  424. }, function(errorMsg) {
  425. alert("用户修改失败!");
  426. })
  427. })
  428. // 公司与部门联动 (修改和新增)
  429. linkDep('#companyId')
  430. linkDep('#companyId2')
  431. function linkDep(element) {
  432. $(element).on('change', function() {
  433. //获取公司id
  434. let companyName = $(this).find('option:selected').val();
  435. ajaxRequest(COMPANY_LIST, "POST", { "ownerId": companyName }, function(result) {
  436. let companyDepartmentItems = '<option value="">请选择</option>';
  437. let departmentObj = result.data[0].child;
  438. departmentObj.forEach(function(item, key) {
  439. companyDepartmentItems += `<option value="${item.departmentId}">${item.departmentName}</option>`
  440. })
  441. $('#departmentId').html(companyDepartmentItems);
  442. $('#departmentIdUpdate').html(companyDepartmentItems);
  443. }, function(errorMsg) {
  444. alert("请求数据失败!");
  445. })
  446. })
  447. }
  448. // 导出 start
  449. $('.export').click(function() {
  450. getDataExport({ "userName": param1, "roleId": 1 })
  451. })
  452. function getDataExport(queryParam = {}) {
  453. // 输出base64编码
  454. const base64 = s => window.btoa(unescape(encodeURIComponent(s)));
  455. ajaxRequest(USER_EXPORT, "POST", queryParam, function(result) {
  456. let data = result.data;
  457. let newData = [];
  458. data.forEach(function(item, index) {
  459. let posName = "";
  460. if (item.posname == 1) {
  461. posName = "超级管理员"
  462. } else if (item.posname == 2) {
  463. posName = "普通员工"
  464. }
  465. let locked = item.locked ? '未锁定' : '锁定';
  466. let time = getFormatDate(item.ctime.time)
  467. newData.push({ truename: item.truename, sex: item.sex, posname: posName, time: time, addman: item.addman, locked: locked, wrongtimes: item.wrongtimes })
  468. });
  469. let str = '<tr style="text-align:center"><th>真实姓名</th><th>性别</th><th>用户身份</th><th>创建时间</th><th>创建人</th><th>锁定状态</th><th>错误次数</th></tr>';
  470. // 循环遍历,每行加入tr标签,每个单元格加td标签
  471. for (let i = 0; i < newData.length; i++) {
  472. str += '<tr style="text-align:center">';
  473. for (const key in newData[i]) {
  474. // 增加\t为了不让表格显示科学计数法或者其他格式
  475. str += `<td x:str>${ newData[i][key] + '\t'}</td>`;
  476. }
  477. str += '</tr>';
  478. }
  479. // Worksheet名
  480. const worksheet = 'Sheet1'
  481. const uri = 'data:application/vnd.ms-excel;base64,';
  482. // 下载的表格模板数据
  483. let template = `<html xmlns:o="urn:schemas-microsoft-com:office:office"
  484. xmlns:x="urn:schemas-microsoft-com:office:excel"
  485. xmlns="http://www.w3.org/TR/REC-html40">
  486. <head><meta charset='UTF-8'><!--[if gte mso 9]><xml><x:ExcelWorkbook><x:ExcelWorksheets><x:ExcelWorksheet>
  487. <x:Name>${worksheet}</x:Name>
  488. <x:WorksheetOptions><x:DisplayGridlines/></x:WorksheetOptions></x:ExcelWorksheet>
  489. </x:ExcelWorksheets></x:ExcelWorkbook></xml><![endif]-->
  490. </head><body><table>${str}</table></body></html>`;
  491. // 通过创建a标签实现
  492. const link = document.createElement("a");
  493. link.href = uri + base64(template);
  494. // 对下载的文件命名
  495. link.download = "用户管理数据表.xls";
  496. link.click();
  497. }, function(errorMsg) {
  498. alert("请求数据失败!");
  499. })
  500. }
  501. // 导出 end