Açıklama Yok

customTemplate.html 14KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461
  1. <!DOCTYPE html>
  2. <html>
  3. <head>
  4. <meta charset="UTF-8">
  5. <script src="../Script/Common/huayi.load.js"></script>
  6. <script src="../Script/Common/huayi.http.js"></script>
  7. <script src="../Script/Common/huayi.config.js"></script>
  8. <script src="../js/eid/bootstrap-editable.js"></script>
  9. <link href="../css/init.css" rel="stylesheet" />
  10. <link href="../css/Table/table1.css" rel="stylesheet" />
  11. <link rel="stylesheet" href="../css/eid/bootstrap-editable.css" />
  12. <title>自定义模板设置</title>
  13. </head>
  14. <body class="gray-bg">
  15. <div class="daoHang clearfix">
  16. <div class="dhLeft">
  17. <sapn><i class="syIcon"></i>位置:
  18. <a id="ReIndex" href="javaScript:;">首页</a>&gt;
  19. <a href="javaScript:;">系统管理</a>&gt;
  20. <a href="javaScript:;">系统设置</a>&gt;
  21. <a href="javascript:location.reload()" class="now_position">自定义模板设置</a>
  22. </sapn>
  23. </div>
  24. </div>
  25. <div class="wrapper wrapper-content animated">
  26. <div class="th-box">
  27. <div class="th-bar">
  28. <div class="form-inline clearfix">
  29. <div class="form-group">
  30. <select class="form-control" id="TYpe">
  31. <option value="">请选择类型</option>
  32. <option value="nvarchar">文本</option>
  33. <option value="int">整数</option>
  34. <option value="datetime">日期</option>
  35. </select>
  36. </div>
  37. <div class="form-group pull-right">
  38. <input type="button" class="btn_gray" id="sc_btns" value="搜索" />
  39. </div>
  40. </div>
  41. </div>
  42. </div>
  43. <div class="clearfix">
  44. <div style="width: 50%;padding: 10px; float: left;">
  45. <p class="tool_bars"><button authorize="yes" id="HY_moveTos" onclick="btn_moveTos()" class="btns">移入<i class="fa fa-angle-double-right" style="margin-left: 5px;"></i></button></p>
  46. <table id="list" data-row-style="rowStyle" data-query-params="queryParams" data-pagination="true" data-click-to-select="true">
  47. <thead>
  48. <tr>
  49. <th data-field="state" data-align="center" data-checkbox="true"></th>
  50. <th data-field="name" data-align="center" id="username ">属性名称</th>
  51. <th data-field="length" data-align="center">长度</th>
  52. <th data-field="type" data-align="center">数据类型</th>
  53. <th data-field="field" data-align="center">数据字段</th>
  54. </tr>
  55. </thead>
  56. <tbody id="tbody"></tbody>
  57. </table>
  58. </div>
  59. <div style="width: 50%;padding: 10px;float: right;">
  60. <div class="form-inline tool_bars">
  61. <button class="btns" authorize="yes" id="HY_moveOuts" onclick="btn_moveOuts()"><i class="fa fa-angle-double-left" style="margin-right: 5px;"></i>移出</button>
  62. <button class="btns" authorize="yes" id="HY_save" style="margin-right: 15px;" onclick="btn_save()">保存为模板</button>
  63. <div class="form-group">
  64. <select name="" id="" class="m-kuang tempselect form-control"></select>
  65. </div>
  66. <button class="btns" authorize="yes" id="HY_delete" onclick="btn_delete()">删除模板</button>
  67. </div>
  68. <table id="lists" data-row-style="rowStyle" data-query-params="queryParams" data-pagination="true" data-click-to-select="true">
  69. <thead>
  70. <tr>
  71. <th data-field="state" data-align="center" data-checkbox="true"></th>
  72. <th data-field="name" data-align="center" id="username " data-formatter="shtype">属性名称</th>
  73. <th data-field="length" data-align="center">长度</th>
  74. <th data-field="type" data-align="center">数据类型</th>
  75. <th data-field="field" data-align="center">数据字段</th>
  76. </tr>
  77. </thead>
  78. <tbody id="tbody"></tbody>
  79. </table>
  80. </div>
  81. </div>
  82. </div>
  83. <script>
  84. var curRow = {};
  85. $(document).ready(function() {
  86. $('.tool_bars').authorizeButton();
  87. initTable(0);
  88. initTables(-1, 0);
  89. $("#sc_btns").click(function() {
  90. initTable();
  91. })
  92. initTempSelect();
  93. $('.tempselect').change(function() {
  94. parent.$('#tempid').val($(this).val());
  95. initTable($(this).val());
  96. initTables(0, $(this).val());
  97. });
  98. });
  99. function initTempSelect() {
  100. $('.tempselect').empty();
  101. $.ajax({
  102. type: "get",
  103. url: huayi.config.callcenter_url + "GoodsExcelTmp/GetAllTemp",
  104. async: true,
  105. dataType: 'json',
  106. data: {
  107. token: $.cookie("token")
  108. },
  109. success: function(data) {
  110. var con = data.data;
  111. $('.tempselect').append('<option value="0">未选择模板</option>');
  112. $(con).each(function(i, n) {
  113. $('.tempselect').append('<option value="' + n.F_ID + '">' + n.F_Name + '</option>');
  114. })
  115. }
  116. });
  117. }
  118. function initTable(tempId) {
  119. //先销毁表格
  120. $('#list').bootstrapTable('destroy');
  121. //初始化表格,动态从服务器加载数据
  122. $("#list").bootstrapTable({
  123. method: "get", //使用get请求到服务器获取数据
  124. url: huayi.config.callcenter_url + "/GoodsExcelTmp/GetList", //获取数据的Servlet地址
  125. contentType: "application/x-www-form-urlencoded",
  126. striped: true, //表格显示条纹
  127. pagination: true, //启动分页
  128. pageSize: 10, //每页显示的记录数
  129. pageNumber: 1, //当前第几页
  130. pageList: [10, 20, 50, 100], //记录数可选列表
  131. search: false, //是否启用查询
  132. showColumns: false, //显示下拉框勾选要显示的列
  133. showRefresh: false, //显示刷新按钮
  134. sidePagination: "server", //表示服务端请求
  135. // clickToSelect: true,
  136. //设置为undefined可以获取pageNumber,pageSize,searchText,sortName,sortOrder
  137. //设置为limit可以获取limit, offset, search, sort, order
  138. queryParamsType: "undefined",
  139. queryParams: function queryParams(params) { //设置查询参数
  140. var param = {
  141. pageindex: params.pageNumber,
  142. pagesize: params.pageSize,
  143. typename: $('#TYpe').val(),
  144. taskId: -1,
  145. tempId: tempId,
  146. token: $.cookie("token")
  147. };
  148. return param;
  149. },
  150. columns: [{
  151. checkbox: true
  152. }, {
  153. title: "操作",
  154. formatter: function(value, row, index) {
  155. return '<div class="tool_downL"><a title="点击移入" authorize="yes" id="HY_moveTo_' + row.id + '" onclick="btn_moveTo(' + row.id + ')"><i class="fa fa-arrow-right"></i></a></div>'
  156. }
  157. }, {
  158. field: "name",
  159. title: "属性名称",
  160. }, {
  161. field: "length",
  162. title: "长度",
  163. }, {
  164. field: "type",
  165. title: "数据类型",
  166. },
  167. {
  168. field: "field",
  169. title: "数据字段"
  170. }
  171. ],
  172. // onClickRow: function(row, $element) {
  173. // var curRow = row.id;
  174. // console.log(curRow);
  175. // //请求方法
  176. // $.ajax({       
  177. // type: 'POST',
  178. //        url: huayi.config.callcenter_url + "/GoodsExcelTmp/Add",
  179. //        data: {
  180. // ids: curRow,
  181. // taskId:0,
  182. // token: $.cookie("token")
  183. // },
  184. //        dataType: 'JSON',
  185. //        success: function(data, textStatus, jqXHR) {        
  186. //
  187. // initTables();
  188. // },
  189. //        error: function() {
  190. // alert("error");
  191. // }      
  192. // }); 
  193. //
  194. // },
  195. onLoadSuccess: function(data) { //加载成功时执行
  196. $('.tool_downL').authorizeOperateButton();
  197. },
  198. onLoadError: function() { //加载失败时执行
  199. //layer.msg("加载数据失败", { time: 1500, icon: 2 });
  200. }
  201. });
  202. }
  203. function btn_moveTo(ids) {
  204. $.ajax({
  205. type: 'POST',
  206. url: huayi.config.callcenter_url + "/GoodsExcelTmp/Add",
  207. data: {
  208. ids: ids,
  209. taskId: -1,
  210. tempId: $('.tempselect').val(),
  211. token: $.cookie("token")
  212. },
  213. dataType: 'JSON',
  214. success: function(data, textStatus, jqXHR) {
  215. $('#list').bootstrapTable('refresh');
  216. $('#lists').bootstrapTable('refresh');
  217. },
  218. error: function() {
  219. alert("error");
  220. }
  221. });
  222. }
  223. function btn_moveTos() {
  224. var changes = $.map($('#list').bootstrapTable('getSelections'), function(row) {
  225. return row.id;
  226. });
  227. if(changes.length <= 0) {
  228. layer.confirm('请选择一项移入!', {
  229. btn: ['确定']
  230. });
  231. return;
  232. } else {
  233. btn_moveTo(changes)
  234. }
  235. }
  236. //右边
  237. function initTables(taskId, tempId) {
  238. //先销毁表格
  239. $('#lists').bootstrapTable('destroy');
  240. //初始化表格,动态从服务器加载数据
  241. $("#lists").bootstrapTable({
  242. method: "get", //使用get请求到服务器获取数据
  243. url: huayi.config.callcenter_url + "/GoodsExcelTmp/GetSelectList", //获取数据的Servlet地址
  244. contentType: "application/x-www-form-urlencoded",
  245. striped: true, //表格显示条纹
  246. pagination: true, //启动分页
  247. pageSize: 10, //每页显示的记录数
  248. pageNumber: 1, //当前第几页
  249. pageList: [10, 20, 50, 100], //记录数可选列表
  250. search: false, //是否启用查询
  251. showColumns: false, //显示下拉框勾选要显示的列
  252. showRefresh: false, //显示刷新按钮
  253. sidePagination: "server", //表示服务端请求
  254. // clickToSelect: true,
  255. //设置为undefined可以获取pageNumber,pageSize,searchText,sortName,sortOrder
  256. //设置为limit可以获取limit, offset, search, sort, order
  257. queryParamsType: "undefined",
  258. queryParams: function queryParams(params) { //设置查询参数
  259. var param = {
  260. pageindex: params.pageNumber,
  261. pagesize: params.pageSize,
  262. taskId: taskId,
  263. tempId: tempId,
  264. token: $.cookie("token")
  265. };
  266. return param;
  267. },
  268. columns: [{
  269. checkbox: true
  270. }, {
  271. // field: "length",
  272. title: "操作",
  273. formatter: function(value, row, index) {
  274. return '<div class="tool_downR"><a title="点击移出" authorize="yes" id="HY_moveOut_' + row.id + '" onclick="btn_moveOut(' + row.id + ')"><i class="fa fa-arrow-left"></i></a></div>'
  275. }
  276. }, {
  277. field: "name",
  278. title: "属性名称",
  279. formatter: function(value, row, index) {
  280. return "<a href=\"#\" class=\"change\" title=\"点击修改\" name='" + value + "' data-type=\"text\" data-pk=\"" + row.id + "\" data-title=\"用户名\">" + value + "</a>";
  281. }
  282. }, {
  283. field: "length",
  284. title: "长度",
  285. }, {
  286. field: "type",
  287. title: "数据类型",
  288. },
  289. {
  290. field: "field",
  291. title: "数据字段"
  292. }
  293. ],
  294. onClickRow: function(row, $element) {
  295. var curRow = row.id;
  296. //console.log(curRow);
  297. // //请求方法
  298. // $.ajax({       
  299. // type: 'POST',
  300. //        url: huayi.config.callcenter_url + "/GoodsExcelTmp/GetSelectIdList",
  301. //        data: {
  302. // taskId: curRow,
  303. // token: $.cookie("token")
  304. // },
  305. //        dataType: 'JSON',
  306. //        success: function(data, textStatus, jqXHR) {        
  307. // // alert('保存成功!');       
  308. // },
  309. //        error: function() {
  310. // alert("error");
  311. // }      
  312. // }); 
  313. },
  314. onLoadSuccess: function(data) { //加载成功时执行
  315. $("#lists a.change").editable({
  316. url: function(params) {
  317. var name = $(this).attr("name");
  318. var id = $(this).attr("data-pk");
  319. curRow[name] = params.value;
  320. console.log(params.value);
  321. $.ajax({
  322. type: 'POST',
  323. url: huayi.config.callcenter_url + "/GoodsExcelTmp/Update",
  324. data: {
  325. id: id,
  326. name: params.value,
  327. token: $.cookie("token")
  328. },
  329. dataType: 'JSON',
  330. success: function(data, textStatus, jqXHR) {
  331. $('#lists').bootstrapTable('refresh');
  332. },
  333. error: function() {
  334. alert("error");
  335. }
  336. });
  337. },
  338. type: 'text'
  339. });
  340. $('.tool_downR').authorizeOperateButton();
  341. },
  342. onLoadError: function() { //加载失败时执行
  343. //layer.msg("加载数据失败", { time: 1500, icon: 2 });
  344. }
  345. });
  346. }
  347. //编辑
  348. function shtype(val, row, index) {
  349. return "<a href='#' data-type='text' data-title='" + val + "'>" + val + "</a>";
  350. }
  351. function btn_moveOut(ids) {
  352. $.ajax({
  353. type: 'POST',
  354. url: huayi.config.callcenter_url + "GoodsExcelTmp/Remove",
  355. data: {
  356. ids: ids,
  357. // taskId:0,
  358. token: $.cookie("token")
  359. },
  360. dataType: 'JSON',
  361. success: function(data, textStatus, jqXHR) {
  362. $('#list').bootstrapTable('refresh');
  363. $('#lists').bootstrapTable('refresh');
  364. },
  365. error: function() {
  366. alert("error");
  367. }
  368. });
  369. }
  370. //右边
  371. function btn_moveOuts() {
  372. var changes = $.map($('#lists').bootstrapTable('getSelections'), function(row) {
  373. return row.id;
  374. });
  375. if(changes.length <= 0) {
  376. layer.confirm('请选择一项移出!', {
  377. btn: ['确定']
  378. });
  379. return;
  380. } else {
  381. btn_moveOut(changes)
  382. }
  383. }
  384. function btn_save() {
  385. layer.prompt({
  386. title: '添加模板',
  387. formType: 2
  388. }, function(text, index) {
  389. layer.close(index);
  390. $.ajax({
  391. type: 'POST',
  392. url: huayi.config.callcenter_url + "GoodsExcelTmp/AddTemp",
  393. data: {
  394. name: text,
  395. id: $('.tempselect').val(),
  396. token: $.cookie("token")
  397. },
  398. dataType: 'JSON',
  399. success: function(data, textStatus, jqXHR) {
  400. initTempSelect();
  401. },
  402. error: function() {
  403. alert("error");
  404. }
  405. });
  406. });
  407. }
  408. function btn_delete() {
  409. if($('.tempselect ').val() > 0){
  410. layer.confirm('您确定要删除当前模板吗?', {
  411. btn: ['确定']
  412. }, function() {
  413. $.ajax({
  414. type: 'POST',
  415. url: huayi.config.callcenter_url + "GoodsExcelTmp/DeleteTemp",
  416. data: {
  417. id: $('.tempselect').val(),
  418. token: $.cookie("token")
  419. },
  420. dataType: 'JSON',
  421. success: function(data, textStatus, jqXHR) {
  422. layer.msg("删除成功");
  423. initTempSelect();
  424. }
  425. });
  426. });
  427. }else{
  428. layer.confirm('您还没有选择模板', {
  429. btn: ['确定']
  430. })
  431. }
  432. }
  433. </script>
  434. </body>
  435. </html>