customer.html 10 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273
  1. <!DOCTYPE html>
  2. <html>
  3. <head>
  4. <meta charset="utf-8">
  5. <title>客户档案</title>
  6. <meta name="renderer" content="webkit">
  7. <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
  8. <meta name="viewport"
  9. content="width=device-width, initial-scale=1.0, minimum-scale=1.0, maximum-scale=1.0, user-scalable=0">
  10. <link rel="stylesheet" href="../../layuiadmin/layui/css/layui.css" media="all">
  11. <link rel="stylesheet" href="../../layuiadmin/style/admin.css" media="all">
  12. <style type="text/css">
  13. .LAY-btns .layui-nav {
  14. padding-left: 0;
  15. padding-right: 10px;
  16. top: -4px;
  17. margin: 0 10px;
  18. border: 0;
  19. background-color: #009688;
  20. }
  21. .LAY-btns .layui-nav .layui-nav-item {
  22. line-height: 30px;
  23. }
  24. .LAY-btns .layui-nav .layui-nav-child {
  25. top: 34px;
  26. }
  27. .LAY-btns .layui-nav .layui-nav-bar {
  28. display: none;
  29. }
  30. .LAY-btns .layui-nav .layui-nav-child dd.layui-this a {
  31. color: #333;
  32. background-color: #fff;
  33. }
  34. .LAY-btns .layui-nav .layui-nav-child dd.layui-this a:hover {
  35. background-color: #f2f2f2;
  36. color: #000;
  37. }
  38. </style>
  39. </head>
  40. <body>
  41. <div class="layui-fluid">
  42. <div class="layui-card">
  43. <div class="layui-card-body" pad15>
  44. <div class="layui-row layui-col-space15">
  45. <div class="layui-col-md12">
  46. <div class="LAY-btns" style="margin-bottom: 10px;">
  47. <button class="layui-btn layui-btn-sm" id="btn_add" data-permission="customer.add_customer"><i
  48. class="layui-icon layui-icon-add-circle"></i>添加
  49. </button>
  50. <button class="layui-nav" data-permission="customer.import_customer">
  51. <div class="layui-nav-item">
  52. <a href="javascript:;" style="color:#fff;">导入</a>
  53. <dl class="layui-nav-child"> <!-- 二级菜单 -->
  54. <dd><a href="#" id="btn_import">执行导入</a></dd>
  55. <dd><a href="#" id="btn_download">下载模板</a></dd>
  56. </dl>
  57. </div>
  58. </button>
  59. <button class="layui-btn layui-btn-sm" id="btn_export"
  60. data-permission="customer.export_customer"><i
  61. class="layui-icon layui-icon-download-circle"></i>导出
  62. </button>
  63. <button class="layui-btn layui-btn-sm" id="btn_query"><i
  64. class="layui-icon layui-icon-search"></i>查询
  65. </button>
  66. </div>
  67. <table class="layui-hide" id="datagrid" lay-filter="datagrid-operate"></table>
  68. <script type="text/html" id="datagrid-operate-bar">
  69. <div class="layui-btn-group">
  70. <a class="layui-btn layui-btn-xs" lay-event="edit" data-permission="customer.add_customer">修改</a>
  71. <a class="layui-btn layui-btn-danger layui-btn-xs" lay-event="del"
  72. data-permission="customer.delete_customer">删除</a>
  73. </div>
  74. </script>
  75. </div>
  76. </div>
  77. </div>
  78. </div>
  79. </div>
  80. <div id="dlg_query" style="display: none">
  81. <div class="layui-card-body" pad15>
  82. <form class="layui-form" lay-filter="query-form-element">
  83. <div class="layui-row layui-col-space10 layui-form-item">
  84. <div class="layui-col-xs12 layui-col-sm12">
  85. <label class="layui-form-label">姓名:</label>
  86. <div class="layui-input-block">
  87. <input type="text" name="name" class="layui-input" autocomplete="off">
  88. </div>
  89. </div>
  90. <div class="layui-col-xs12 layui-col-sm12">
  91. <label class="layui-form-label">手机:</label>
  92. <div class="layui-input-block">
  93. <input type="text" name="mobile" class="layui-input" autocomplete="off">
  94. </div>
  95. </div>
  96. </div>
  97. <div style="display:none">
  98. <button id="query-submit" lay-submit lay-filter="query-form-element">查询</button>
  99. </div>
  100. </form>
  101. </div>
  102. </div>
  103. <script src="../../layuiadmin/layui/layui.js?t=1"></script>
  104. <script>
  105. layui.config({
  106. base: '../../../layuiadmin/' //静态资源所在路径
  107. }).extend({
  108. index: 'lib/index' //主入口模块
  109. }).use(['index', 'table', 'form', 'upload'], function () {
  110. var $ = layui.$;
  111. var table = layui.table
  112. , form = layui.form
  113. , upload = layui.upload;
  114. table.render({
  115. elem: '#datagrid'
  116. , url: '/customer/customer/data/'
  117. , cols: [[
  118. {field: 'company_name', title: '客户(公司)名称', width: 190}
  119. , {field: 'company_tel', title: '客户(公司)电话', width: 120}
  120. , {field: 'name', title: '联系人姓名', width: 100}
  121. , {field: 'mobile', title: '联系人电话', width: 120}
  122. , {field: 'opening_bank', title: '开户行', width: 100}
  123. , {field: 'account', title: '帐号', width: 160}
  124. , {field: 'credit_code', title: '信用代码', width: 120}
  125. , {field: 'address', title: '地址', width: 200}
  126. , {field: 'create_time', title: '创建时间', width: 150}
  127. , {field: 'create_user_text', title: '创建人', width: 100}
  128. , {field: 'notes', title: '备注', minWidth: 200}
  129. , {width: 100, align: 'left', fixed: 'right', toolbar: '#datagrid-operate-bar'}
  130. ]]
  131. , page: true
  132. , height: 'full-104'
  133. , done: function () {
  134. layui.index.removeNoPermButtons();
  135. }
  136. });
  137. //监听工具条
  138. table.on('tool(datagrid-operate)', function (obj) {
  139. var data = obj.data;
  140. if (obj.event === 'edit') {
  141. table.editdata = data;
  142. //layer.alert('编辑行:<br>'+ JSON.stringify(data))
  143. layer.open({
  144. type: 2,
  145. title: '修改客户',
  146. shadeClose: false,
  147. area: ['700px', '90%'],
  148. btn: ['保存', '取消'],
  149. yes: function (index, dom) {
  150. layui.onSubmitChild = function (data) {
  151. layer.close(index);
  152. table.reload('datagrid', {});
  153. };
  154. layui.submitChild();
  155. },
  156. btn2: function (index, layero) {
  157. layer.close(index);//关闭当前按钮
  158. },
  159. content: 'customer_edit.html?id=' + data.id
  160. });
  161. } else if (obj.event === 'del') {
  162. layer.confirm('确定要删除吗?', function (index) {
  163. layer.close(index);
  164. layui.admin.req({
  165. url: '/customer/customer/delete/?id=' + data.id
  166. , done: function (res) {
  167. table.reload('datagrid', {});
  168. }
  169. });
  170. });
  171. }
  172. });
  173. $('#btn_add').on('click', function () {
  174. layer.open({
  175. type: 2,
  176. title: '添加客户',
  177. shadeClose: false,
  178. area: ['700px', '90%'],
  179. btn: ['保存', '取消'],
  180. yes: function (index, dom) {
  181. layui.onSubmitChild = function (data) {
  182. layer.close(index);
  183. table.reload('datagrid', {});
  184. };
  185. layui.submitChild();
  186. },
  187. btn2: function (index, layero) {
  188. layer.close(index);//关闭当前按钮
  189. },
  190. content: 'customer_edit.html'
  191. });
  192. });
  193. $('#btn_query').on('click', function () {
  194. layer.open({
  195. type: 1,
  196. shadeClose: true,
  197. area: ['520px', '240px'],
  198. title: '查询',
  199. btn: ['查询'],
  200. yes: function (index, dom) {
  201. $("#query-submit").click();
  202. },
  203. content: $('#dlg_query')
  204. });
  205. });
  206. var _params;
  207. form.on('submit(query-form-element)', function (data) {
  208. //layer.msg(JSON.stringify(data.field));
  209. _params = data.field;
  210. table.reload('datagrid', {
  211. where: data.field,
  212. page: {curr: 1}
  213. });
  214. layer.closeAll();
  215. return false
  216. });
  217. $('#btn_export').on('click', function () {
  218. layui.admin.req({
  219. url: '/customer/customer/export/'
  220. , data: _params
  221. , type: 'get'
  222. , done: function (res) {
  223. layui.view.download(res.data.filename);
  224. }
  225. });
  226. });
  227. $('#btn_download').on('click', function () {
  228. layui.view.download("/static/xls/客户导入模板.xlsx");
  229. });
  230. upload.render({
  231. elem: '#btn_import'
  232. , url: '/customer/customer/import/'
  233. , accept: 'file'
  234. , acceptMime: 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'
  235. , exts: 'xlsx'
  236. , field: 'excel_file'
  237. , multiple: false
  238. , done: function (res) {
  239. if (res.code == 0) {
  240. table.reload('datagrid', {});
  241. } else {
  242. layer.msg(res.msg);
  243. }
  244. }
  245. , error: function () {
  246. layer.msg('导入失败');
  247. }
  248. });
  249. });
  250. </script>
  251. </body>
  252. </html>