customer.html 8.3 KB

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