lgUtil.js 14 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374
  1. var grid;
  2. var id;
  3. var rowindex = 0;
  4. var columns = []; //所有的列表names
  5. var hideColumns = []; //所有的列表names
  6. var disabledColumns = []; //所有只显示却不能编辑的列 -》》需要解决这种不能编辑的列的值保存不成功的问题。
  7. var disabledColumnsDatas = {}; //所有只显示却不能编辑的列 -》》需要解决这种不能编辑的列的值保存不成功的问题。
  8. var currentEditData; //当前编辑行的数据
  9. var innerEdit = true; //页内编辑是否
  10. var innerAdd = false; //页内编辑是否
  11. var pageBean = {}; // 分页对象
  12. var needToolbar = true; //设置是否需要操作栏
  13. var newRows=[];//新增添并且没有保存的数据
  14. $(function() {
  15. $("div.groupUI > a.link.del").unbind("click");
  16. $("div.groupUI > a.link.search").unbind("click");
  17. //删除操作
  18. $("div.groupUI > a.link.del").click(delFunction);
  19. //查询操作
  20. $("div.groupUI > a.link.search").click(function() {
  21. if (!$(this).hasClass('disabled')) {
  22. var queryDatas={};
  23. grid.options.isAdding = false;
  24. $(".inputText").each(function(index, item) {
  25. queryDatas[$(item).attr("name")] = $(item).val();
  26. });
  27. grid.options.parms=$.extend(true, {}, queryDatas);
  28. queryDatas.page = 1;
  29. queryDatas.pagesize = pageBean["pageSize"];
  30. var serachAction = $("#searchForm").attr("action");
  31. $.post(serachAction, queryDatas,
  32. function(response) {
  33. grid.options['newPage']=1;
  34. grid._getSearchData(response);
  35. })
  36. }
  37. });
  38. });
  39. function initData(context) {
  40. //通过context.columns 获取当前的显示的columns、隐藏的hideColumns和不能编辑的disabledColumns列。
  41. for (var column in context.columns) {
  42. if (!context.columns[column]["hide"]) {
  43. columns.push(context.columns[column]["name"]);
  44. } else {
  45. var hideCol = context.columns[column]["name"]
  46. hideColumns.push(hideCol);
  47. }
  48. if (!context.columns[column]["editor"]) {
  49. disabledColumns.push(context.columns[column]["name"]);
  50. }
  51. }
  52. innerEdit = context.innerEdit;
  53. innerAdd = context.innerAdd;
  54. needToolbar = context.needToolbar;
  55. //计算列宽
  56. var columnWidth = Math.ceil((document.body.clientWidth) / (columns.length)) - 8;
  57. if (needToolbar) {
  58. //如果需要操作栏 需要减去操作栏的列宽在进行计算
  59. columnWidth = Math.ceil((document.body.clientWidth - 200) / (columns.length)) - 8;
  60. context.columns.push({
  61. display: '操作',
  62. isSort: false,
  63. isAllowHide: false,
  64. width: 200,
  65. render: function(rowdata, rowindex, value) {
  66. var h = "";
  67. //操作栏的显示按钮 可以进行扩展
  68. if (!rowdata._editing) {
  69. h += "<a href='javascript:beginEdit(" + rowindex + "," + rowdata.id + ")'>修改</a> ";
  70. h += "<a class='link del' href='javascript:delFunction(" + rowindex + "," + rowdata.id + ")'>删除</a> ";
  71. } else {
  72. h += "<a href='javascript:submitChange(" + rowindex + "," + rowdata.id + ")'>提交</a> ";
  73. h += "<a href='javascript:cancelEdit(" + rowindex + ")'>取消</a> ";
  74. }
  75. return h;
  76. }
  77. });
  78. }
  79. grid = $("#grid").ligerGrid({
  80. columns: context.columns, //展现的字段
  81. usePager: true, //是否用分页
  82. url: "getList.ht", //url 这里使用url 那么dataAction需要设为'server'
  83. root: "Rows", //json数据的开头 不需要修改
  84. record: 'Total', //总数的开头 不需要修改
  85. dataAction: 'server', //数据从服务器获取
  86. pageSize: 10, //当前页的显示数据大小
  87. pageSizeOptions :[5,10,15,20],
  88. width: 'auto', //设置宽度
  89. heightDiff: -10, //设置高度调整,当height为100%时可能会超过屏幕。
  90. checkbox: true, //是否显示复选框
  91. rownumbers: true, //是否显示行序号
  92. columnWidth: columnWidth, //默认列宽度
  93. rowHeight: 35, //行默认的高度
  94. enabledSort: true, //是否允许排序
  95. enabledEdit: true, //是否允许编辑
  96. clickToEdit: false, //是否允许 单击进行单元格编辑
  97. dateFormat: "yyyy-MM-dd", //默认时间显示格式
  98. fixedCellHeight: true, //是否固定单元格的高度
  99. colDraggable: false,
  100. allowAdjustColWidth: 0,
  101. onCheckRow: function(checked, data, rowid, rowobj) {
  102. if (checked) {
  103. id = data.id;
  104. rowindex = data.__index;
  105. } //选中之后触发的事件 这里锁定id和rowindex
  106. },
  107. onAfterSubmitEdit: function(e) {
  108. currentEditData = e;
  109. for (var id in disabledColumns) {
  110. if (!isInArray(hideColumns, disabledColumns[id])) {
  111. currentEditData.newdata[disabledColumns[id]] = disabledColumnsDatas[disabledColumns[id]];
  112. currentEditData.record[disabledColumns[id]] = disabledColumnsDatas[disabledColumns[id]];
  113. }
  114. }
  115. },
  116. onLoaded: function(grid) {
  117. grid.gridloading['hide']();
  118. },
  119. onEndEdit: function(e) {
  120. console.info("onEndEdit");
  121. }
  122. });
  123. //判断是否需要进行页内添加
  124. innerAdd=true;
  125. if(innerAdd||columns.length<=9){
  126. //添加操作
  127. $("div.groupUI > a.link.add").unbind("click");
  128. $("div.groupUI > a.link.add").click(function(){
  129. grid.options.isAdding = true;
  130. grid.currentData.Rows=[];
  131. newRows.push(grid.addRow());
  132. for(var index=0;index<newRows.length;index++){
  133. grid.beginEdit(newRows[index]);
  134. }
  135. });
  136. }else{
  137. $("div.groupUI > a.link.add").attr("href",$("div.groupUI > a.link.add").attr("action"));
  138. }
  139. //判断是否需要进行页内编辑
  140. $("a.link.update").unbind("click");
  141. $("div.groupUI > a.link.update").click(function() {
  142. if ($(this).hasClass('disabled'))
  143. return false;
  144. var aryId = [];
  145. var rows = grid.getCheckedRows();
  146. $(rows).each(function(i, item) {
  147. aryId.push(item.id);
  148. });
  149. if (aryId.length == 0) {
  150. $.ligerDialog.warn("还没有选择,请选择一项进行编辑!", '提示信息');
  151. return false;
  152. } else if (aryId.length > 1) {
  153. $.ligerDialog.warn("已经选择了多项,请选择一项进行编辑!", '提示信息');
  154. return false;
  155. }
  156. innerEdit=true;
  157. if (innerEdit||columns.length<=9) {
  158. beginEdit(rowindex);
  159. return false;
  160. }
  161. var name = "id";
  162. var value = aryId[0];
  163. var form = new com.hotent.form.Form();
  164. var action = $(this).attr("action");
  165. form.creatForm("form", action);
  166. form.addFormEl(name, value);
  167. form.submit();
  168. });
  169. //判断是否需要进行页内编辑
  170. $("a.link.merge").unbind("click");
  171. $("div.group > a.link.merge").click(function() {
  172. });
  173. }
  174. // 开始编辑
  175. function beginEdit(rowid, curId) {
  176. rowindex = rowid;
  177. id = curId;
  178. var currentRow = grid['currentData']['Rows'][rowindex];
  179. for (var id in disabledColumns) {
  180. disabledColumnsDatas[disabledColumns[id]] = currentRow[disabledColumns[id]];
  181. }
  182. grid.beginEdit(rowid);
  183. }
  184. ;
  185. // 取消编辑
  186. function cancelEdit(rowid, id) {
  187. loadData();
  188. grid.cancelEdit(rowid);
  189. }
  190. ;
  191. function endEdit(rowid, id) {
  192. grid.endEdit(rowid);
  193. }
  194. ;
  195. //删除操作
  196. function delFunction(index, id) {
  197. var params = {}, rowid = "", delId = "";
  198. if (id && index >= 0) {
  199. delId = id;
  200. rowid = index;
  201. } else {
  202. delId = [];
  203. var rows = grid.getCheckedRows();
  204. $(rows).each(function(i, item) {
  205. delId.push(item.id);
  206. });
  207. if (delId.length == 0) {
  208. $.ligerDialog.warn("请选择记录!");
  209. return;
  210. }
  211. delId = JSON.stringify(delId);
  212. if(delId.indexOf("[")>=0){
  213. delId=delId.substring(1,delId.length-1);
  214. }
  215. }
  216. //向后台传输的值 当前页、当前选中的id 和当前页大小
  217. params= $.extend(true,{},grid.options.parms);
  218. params.id = delId;
  219. params.page = pageBean["currentPage"];
  220. params.pagesize = pageBean["pageSize"];
  221. $.ligerDialog.confirm('确认删除所选数据吗?', '提示信息', function(rtn) {
  222. if (rtn) {
  223. $.post("del.ht", params, function(response) {
  224. //在LigerGrid中自定仪的_getSearchData方法 用于渲染返回回来的json数据列表 response主要返回了两个数据 一个是提示信息,另一个是删除之后查询出来的json数据
  225. //在grid列表中删除选中的行
  226. if (rowid != '') {
  227. grid.deleteRow(rowid);
  228. } else {
  229. grid.deleteSelectedRow();
  230. }
  231. grid._getSearchData(response.substring(response.indexOf("}") + 1, response.length));
  232. showResponse(response.substring(0, response.indexOf("}") + 1));
  233. })
  234. }
  235. });
  236. }
  237. //提交修改
  238. function submitChange(rowid, id) {
  239. endEdit(rowid, id);
  240. var dateCols = currentEditData.dateCols;
  241. var json = currentEditData.newdata;
  242. for (var js in json) {
  243. if (json[js] instanceof Date) {
  244. json[js] = json[js].Format(dateCols[js]);
  245. } else {
  246. json[js] = json[js];
  247. }
  248. }
  249. json["id"] = id;
  250. var jsonObj = {"json": JSON.stringify(json)};
  251. $.post("save.ht", jsonObj, function(response) {
  252. showResponse(response);
  253. })
  254. }
  255. //提示操作后的反馈信息
  256. function showResponse(responseText) {
  257. loadData();
  258. var obj = new com.hotent.form.ResultMessage(responseText);
  259. if (obj.isSuccess()) { // 成功
  260. $.ligerDialog.closeWaitting();
  261. $.ligerDialog.success('<p><font color="green">' + obj.getMessage()
  262. + '</font></p>', '提示信息', function() {
  263. });
  264. } else { // 失败
  265. $.ligerDialog.closeWaitting();
  266. var message = '<p><font color="red">' + obj.getMessage()
  267. + '</font></p>';
  268. $.ligerDialog.tipDialog('提示信息', "删除结果如下:", message, null, function() {
  269. $.ligerDialog.hide();
  270. });
  271. }
  272. }
  273. //获取日期类型中的配置
  274. function getFormat(json) {
  275. json = eval("[" + json + "]");
  276. var format = json[0].format || "yyyy-MM-dd";
  277. return format;
  278. }
  279. //获取代码生成之后下拉选择框的参数 因为ligerui支持的是 [{fieldName : "", text:""},{fieldName : "", text:""}]类型的数据格式
  280. function getSelectData(options, fieldName) {
  281. options = options.replaceAll('key', fieldName);
  282. options = eval(options.replaceAll('value', 'text'));
  283. return options;
  284. }
  285. // 初始化数据 ,并且将带有日期的数据转换
  286. function getFormatData(response) {
  287. var jsonObj = {};
  288. jsonObj.Rows = eval(response);
  289. for (var i = 0; i < jsonObj.Rows.length; i++) {
  290. for (var j = 0; j < columns.length; j++) {
  291. var tempVar = jsonObj.Rows[i][columns[j]];
  292. if (tempVar && tempVar.time) {
  293. jsonObj.Rows[i][columns[j]] = new Date(tempVar.time);
  294. }
  295. }
  296. }
  297. return jsonObj.Rows;
  298. }
  299. //解决IE下面new Date("yyyy-mm-dd")为NAN值的情况
  300. function newDate(str) {
  301. str = str.split('-');
  302. var date = new Date();
  303. date.setUTCFullYear(str[0], str[1] - 1, str[2]);
  304. date.setUTCHours(0, 0, 0, 0);
  305. return date;
  306. }
  307. //获取单选框和复选框key对应的值 用于显示在grid中。
  308. function getComboboxValue(options, curVal) {
  309. if (!curVal) {
  310. return;
  311. }
  312. var curVals = curVal.split(",");
  313. var returnText = "";
  314. options = eval(options);
  315. for (var i = 0; i < options.length; i++) {
  316. for (var j in curVals) {
  317. if (options[i]['key'] == curVals[j]) {
  318. returnText += options[i]['value'] + ",";
  319. }
  320. }
  321. }
  322. return returnText.substring(0, returnText.length - 1);
  323. }
  324. //当窗口大小改变时 自动改变列宽
  325. function relaziseWidth() {
  326. var columnWidth = Math.ceil((document.body.clientWidth) / (columns.length)) - 8;
  327. var columnsLength = grid.columns.length;
  328. if (needToolbar) {
  329. columnWidth = Math.ceil((document.body.clientWidth - 200) / (columns.length)) - 8;
  330. columnsLength = columnsLength - 1;
  331. }
  332. for (var i = 1; i < columnsLength; i++) {
  333. grid.columns[i]["_width"] = columnWidth;
  334. }
  335. var headCells = $(".l-grid-hd-cell-inner:parent[columnname!='']");
  336. for (var i = 1; i < headCells.length; i++) {
  337. if (needToolbar && i == headCells.length - 1) {
  338. $(headCells[i]).attr("style", "width:" + 200 + "px;");
  339. break;
  340. }
  341. if (hideColumns.length > 0) {
  342. if (headCells[i]['clientWidth'] != 0) {
  343. $(headCells[i]).attr("style", "width:" + (columnWidth) + "px;");
  344. $(headCells[i]).parent(".l-grid-hd-cell").attr("style", "width:" + (columnWidth - 2) + "px;");
  345. }
  346. } else {
  347. $(headCells[i]).attr("style", "width:" + (columnWidth - 2) + "px;");
  348. $(headCells[i]).parent(".l-grid-hd-cell").attr("style", "width:" + (columnWidth) + "px;");
  349. }
  350. }
  351. if (grid.currentData) {
  352. grid.reRender();
  353. }
  354. }
  355. function isInArray(arr, obj) {
  356. for (i = 0; i < arr.length && arr[i] != obj; i++);
  357. return !(i == arr.length);
  358. }
  359. function loadData(){
  360. if(grid.options.isAdding){
  361. grid.options['newPage']=1;
  362. grid.loadData(true);
  363. grid.options.isAdding=false;
  364. }
  365. }