| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349 |
- <!DOCTYPE html>
- <html>
- <head>
- <meta charset="UTF-8">
- <script src="../Script/Common/huayi.load.js"></script>
- <script src="../Script/Common/huayi.config.js"></script>
- <link rel="stylesheet" href="../css/layer/need/layer.css" />
- <link rel="stylesheet" href="../js/zTree/zTreeStyle.css" />
- <link rel="stylesheet" href="../css/init.css" />
- <title>通讯录</title>
- <style>
- .toolBar {
- padding: 15px 0;
- border-bottom: 1px solid #ccc;
- }
-
- #upFile {
- width: initial!important;
- }
- </style>
- </head>
- <body class="gray-bg">
- <div class="container-fluid wrapper wrapper-content animated fadeInRight">
- <div class="daoHang clearfix">
- <div class="dhLeft">
- <sapn><i class="syIcon"></i>位置:
- <a id="ReIndex">首页</a>>
- <a href="javaScript:;">系统管理</a>>
- <a href="" class="nowPosition">通讯录</a>
- </sapn>
- </div>
- <div class="dhRight">
- <a href="" title="刷新"><i class="fa fa-refresh"></i></a>
- </div>
- </div>
- <div class="toolBar clearfix">
- <!--<div class="toolLeft">
- <span style="display: inline-block;"><input class="fl" type="file" id="upFile" name="upFile" /></span>
- <a class="btns" id="daoRu">导入</a>
- <a href="muban/AddressBook.xlsx" download="通讯录模板.xlsx" title="点击下载模板" style="margin-right: 10px;">通讯录模板</a>
- </div>-->
- <div class="toolRight">
- <span>关键字:<input type="text" class="KeyWord" style="height: 31px;"/></span>
- <button class="btns searchGo">搜索</button>
- <button class="btns return">添加</button>
- <a class="btns dbexecl">导出</a>
- </div>
- </div>
- <!--苗福浩导入-->
- <div style="padding: 10px; margin-bottom: 20px;">
- <div class="alert alert-info" role="alert">
- <span class="glyphicon glyphicon-exclamation-sign" aria-hidden="true"></span>
- <span class="sr-only">tips:</span> 上传文件需要严格按照下载的EXCEL模板进行填写!
- </div>
- <div class="form-inline clearfix">
- <div class="form-group">
- <a href="muban/AddressBook.xlsx" download="通讯录模板.xlsx" title="点击下载模板" style="margin-right: 10px;">通讯录模板</a>
- </div>
- <div class="form-group">
- <input class="hidden" type="file" id="upFile" name="upFile" accept=".csv, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet, application/vnd.ms-excel,application/x-xls,application/x-xlsx" />
- <input class="form-control btn btn-success" title="点击上传Excel文件" type="button" value="上传Excel文件" id="upFileExcel" />
- <span class="excelName"></span>
- </div>
- </div>
- <div class="progress">
- <div class="progress-bar progress-bar-striped" role="progressbar" aria-valuenow="0" aria-valuemin="0" aria-valuemax="100">
- </div>
- </div>
- <!--<div class="form-group text-center">
- <input type="button" id="importNum" class="form-control btn btn-success" value="导入" />
- </div>-->
- </div>
- <div class="treeTable clearfix">
- <div class="tableCon col-md-12">
- <table id="table1" data-row-style="rowStyle" data-query-params="queryParams" data-pagination="true">
- <thead>
- <tr>
- <th data-field="F_Name" data-align="left">姓名</th>
- <th data-field="F_Sex" data-align="left">性别</th>
- <th data-field="F_Mobile" data-align="left" data-formatter="phoneTableHtml1">手机号</th>
- <th data-field="F_ElseMobile" data-align="left" data-formatter="phoneTableHtml2">其他电话</th>
- <!--<th data-field="F_Birthday" data-align="left">生日</th>
- <th data-field="F_IDCard" data-align="center">身份证号</th>
- <th data-field="F_Education" data-align="center">学历</th>-->
- <th data-field="F_Email" data-align="center">邮件</th>
- <th data-field="F_Department" data-align="center">单位名称</th>
- <th data-field="F_Telephone" data-align="center" data-formatter="phoneTableHtml3">单位电话</th>
- <th data-field="F_Company" data-align="center">部门</th>
- <th data-field="F_Position" data-align="center">职务</th>
- <th data-field="F_Address" data-align="center">地址</th>
- <th data-field="F_Note" data-align="center">备注</th>
- <th data-align="center" data-formatter="caoZuo">操作</th>
- </tr>
- </thead>
- <tbody id="tbody"></tbody>
- </table>
- </div>
- </div>
- </div>
- <script src="../css/layer/layer.js"></script>
- <script src="../js/zTree/jquery.ztree.core.js"></script>
- <script src="../js/visit/ajaxfileupload.js"></script>
- <script src="../js/sm2/sm2.js"></script>
- <script src="../js/sm2/decrypt.js"></script>
- <script>
- var token = $.cookie("token");
- var table = $('#table1');
- initTable();
- $('.searchGo').click(function() {
- initTable();
- })
- function initTable() {
- //先销毁表格
- table.bootstrapTable('destroy');
- //初始化表格,动态从服务器加载数据
- table.bootstrapTable({
- method: "get", //使用get请求到服务器获取数据
- url: huayi.config.callcenter_url + "AddressBook/GetList", //获取数据的Servlet地址
- contentType: "application/x-www-form-urlencoded",
- striped: true, //表格显示条纹
- pagination: true, //启动分页
- pageSize: 10, //每页显示的记录数
- pageNumber: 1, //当前第几页
- pageList: [10, 20, 50, 100], //记录数可选列表
- search: false, //是否启用查询
- showColumns: false, //显示下拉框勾选要显示的列
- showRefresh: false, //显示刷新按钮
- sidePagination: "server", //表示服务端请求
- //设置为undefined可以获取pageNumber,pageSize,searchText,sortName,sortOrder
- //设置为limit可以获取limit, offset, search, sort, order
- queryParamsType: "undefined",
- queryParams: function queryParams(params) { //设置查询参数
- var param = {
- page: params.pageNumber,
- pagesize: params.pageSize,
- token: $.cookie("token"),
- keyWord: $('.KeyWord').val()
- };
- return param;
- },
- onLoadSuccess: function() { //加载成功时执行
- //layer.msg("加载成功");
- },
- onLoadError: function() { //加载失败时执行
- //layer.msg("加载数据失败", { time: 1500, icon: 2 });
- }
- });
- }
-
- function phoneTableHtml1(val, row){
- return '<a onclick="phoneTableClick(this ,\'' +row.F_MobileShow+'\')"> ' + val + '</a>'
- }
- function phoneTableHtml2(val, row){
- return '<a onclick="phoneTableClick(this ,\'' +row.F_ElseMobileShow+'\')"> ' + val + '</a>'
- }
- function phoneTableHtml3(val, row){
- return '<a onclick="phoneTableClick(this ,\'' +row.F_TelephoneShow+'\')"> ' + val + '</a>'
- }
- function caoZuo(val, row) {
- return '<div><a title="编辑" style="margin-right:5px;" onclick="XG(' + row.F_UserId + ')"><i class="fa fa-pencil-square-o"></i></a><a title="删除" onclick="del(' + row.F_UserId + ')"><i class="fa fa-remove"></i></a> </div>'
- }
- //添加
- $('.return').click(function() {
- // top.$("iframe:visible")[0].src = "SystemManager/addTongXun.html";
- layer.open({
- maxmin: true, //开启最大化最小化按钮
- type: 2,
- content: "addTongXun.html", //iframe的url,no代表不显示滚动条
- title: '添加通讯录',
- area: ['65%', '85%'], //宽高
- });
- })
- //删除
- function del(ids) {
- var laye = layer.confirm('您确定要删除吗?', {
- btn: ['确定', '取消'] //可以无限个按钮
- }, function(index, layero) {
- //按钮【按钮一】的回调 AddressBook/DelAddressBook
- $.ajax({
- type: "post",
- url: huayi.config.callcenter_url + "AddressBook/DelAddressBook",
- async: true,
- dataType: 'json',
- data: {
- token: $.cookie("token"),
- ids: ids
- },
- success: function(data) {
- if(data.state.toLowerCase() == 'success') {
- layer.msg('删除成功');
- initTable();
- }
- }
- });
- }, function(index) {
- //按钮【按钮二】的回调
- layer.close(laye)
- });
- }
- //修改
- function XG(id) {
- layer.open({
- maxmin: true, //开启最大化最小化按钮
- type: 2,
- content: "editTongXun.html?id=" + id, //iframe的url,no代表不显示滚动条
- title: '修改通讯录',
- area: ['65%', '85%'], //宽高
- });
- }
- //导出
- $('.dbexecl').click(function() {
- dcexcel(this);
- })
- function dcexcel(obj) {
- var url = huayi.config.callcenter_url + "AddressBook/ExportAddressBook?token=" + $.cookie("token");
- url += "&keyWord=" + $(".KeyWord").val();
- obj.href = url;
- }
- // //导入
- // $("#daoRu").click(function() {
- //
- // ajaxFileUpload();
- // });
- //
- // function ajaxFileUpload() {
- // $.ajaxFileUpload({
- // url: huayi.config.callcenter_url + 'AddressBook/ImportAddressBook', //用于文件上传的服务器端请求地址
- // secureuri: false, //是否需要安全协议,一般设置为false
- // fileElementId: 'upFile', //文件上传域的ID
- // dataType: 'json', //返回值类型 一般设置为json
- // data: {
- // token: $.cookie("token"),
- // upFile: "upFile"
- // },
- // success: function(data) //服务器成功响应处理函数
- // {
- // if(data.state.toLowerCase() == 'success') {
- // layer.msg("导入成功!");
- //
- // }
- // }
- // })
- // return false;
- // }
-
- $(document).ready(function() {
- //上传EXCEL文件
- $("#upFileExcel").click(function() {
- $("#upFile").trigger("click");
-
- });
- $("#upFile").change(function() {
- var Files = document.getElementById("upFile").files;
- $('.excelName').html(Files[0].name); //文件名称
- uploads();
- });
- // $("#importNum").click(function() {
- // uploads();
- // });
- });
- //上传Excel文件 模拟实时进度
- function uploads() {
- var txtName = $('.excelName').text();
- if(txtName == '') {
- layer.confirm('请先上传文件', {
- icon: 2,
- btn: ['确定']
- });
- return;
- }
- //一般情况下,excel后缀是".xls",在2007以及以后的版本中又增加了".xlsx"。excel的模板文件后缀名是".xlt",启动宏的工作簿后缀名是".xlsm"。
- if(txtName.indexOf('.xls') != -1 ||
- txtName.indexOf('.xlsx') != -1 ||
- txtName.indexOf('.xlt') != -1 ||
- txtName.indexOf('.xlsm') != -1
- ) {
- var formData = new FormData();
- var Files = document.getElementById("upFile").files;
- formData.append("upFile", Files[0]);
- // formData.append("taskid", wid);
- formData.append("token", $.cookie("token"));
- $.ajax({
- url: huayi.config.callcenter_url + "AddressBook/ImportAddressBook",
- type: "POST",
- data: formData,
- /**
- *必须false才会自动加上正确的Content-Type
- */
- contentType: false,
- /**
- * 必须false才会避开jQuery对 formdata 的默认处理
- * XMLHttpRequest会对 formdata 进行正确的处理
- */
- processData: false,
- success: function(result) {
- $("#importNum").attr("disabled", false);
- $("#importNum").val('导入');
- window.location.reload();
- },
- error: function(textStatus) {
- // percents = 0;
- $('.progress').hide();
- layer.confirm('网络繁忙,请稍后再试...', {
- btn: ['确定'] //按钮
- });
- $("#importNum").attr("disabled", false);
- $("#importNum").val('导入');
- },
- complete: function(XMLHttpRequest, textStatus) {
- // percents = 0;
- $('.progress').hide();
- if(textStatus == 'timeout') {
- var xmlhttp = window.XMLHttpRequest ? new window.XMLHttpRequest() : new ActiveXObject("Microsoft.XMLHttp");
- xmlhttp.abort();
- layer.confirm('网络延时,请稍后再试...', {
- btn: ['确定'] //按钮
- });
- }
- $("#importNum").attr("disabled", false);
- $("#importNum").val('导入');
- },
- });
- } else {
- layer.confirm('请上传EXCEL文件', {
- icon: 2,
- btn: ['确定']
- });
- return;
- }
- }
- </script>
- </body>
- </html>
|