block_lib.js 19 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442
  1. /**
  2. * 块模板库管理。
  3. * Created by CSL on 2018-09-19.
  4. */
  5. var blockLibObj = {
  6. mainSpread: null,
  7. mainSheet: null,
  8. mainTree: null,
  9. mainTreeController: null,
  10. mainSetting: {
  11. "emptyRowHeader": true,
  12. "rowHeaderWidth": 15,
  13. "emptyRows":0,
  14. "headRows":1,
  15. "headRowHeight":[30],
  16. "defaultRowHeight": 21,
  17. "treeCol": 9,
  18. "cols":[{
  19. "width":400,
  20. "readOnly": true,
  21. "head":{
  22. "titleNames":["名称"],
  23. "spanCols":[1],
  24. "spanRows":[1],
  25. "vAlign":[1],
  26. "hAlign":[1],
  27. "font":["Arial"]
  28. },
  29. "data":{
  30. "field":"name",
  31. "vAlign":1,
  32. "hAlign":0,
  33. "font":"Arial"
  34. }
  35. }]
  36. },
  37. mainDatas: [],
  38. billSpread: null,
  39. billSheet: null,
  40. billSetting: {
  41. header: [
  42. {headerName: "项目编码", headerWidth: 90, dataCode: "code", dataType: "String", hAlign: "center"},
  43. {headerName: "项目名称", headerWidth: 100, dataCode: "name", dataType: "String"},
  44. {headerName: "单位", headerWidth: 40, dataCode: "unit", dataType: "String", hAlign: "center"},
  45. {headerName: "综合单价", headerWidth: 60, dataCode: "quantity", dataType: "Number"},
  46. {headerName: "项目特征", headerWidth: 120, dataCode: "itemCharacterText", dataType: "String"}
  47. ],
  48. view: {
  49. lockColumns: [0, 1, 2, 3, 4]
  50. }
  51. },
  52. rationSpread: null,
  53. rationSheet: null,
  54. rationSetting: {
  55. header: [
  56. {headerName: "编码", headerWidth: 45, dataCode: "code", dataType: "String", hAlign: "center"},
  57. {headerName: "名称", headerWidth: 100, dataCode: "name", dataType: "String"},
  58. {headerName: "单位", headerWidth: 40, dataCode: "unit", dataType: "String", hAlign: "center"},
  59. {headerName: "含量", headerWidth: 40, dataCode: "contain", dataType: "Number"},
  60. {headerName: "取费专业", headerWidth: 60, dataCode: "programID", dataType: "Number"},
  61. {headerName: "综合单价", headerWidth: 60, dataCode: "quantity", dataType: "Number"},
  62. {headerName: "子目换算状态", headerWidth: 90, dataCode: "adjustState", dataType: "String"}
  63. ],
  64. view: {
  65. lockColumns: [0, 1, 2, 3, 4, 5, 6]
  66. }
  67. },
  68. buildSheet: function () {
  69. $.bootstrapLoading.start();
  70. let me = this;
  71. me.mainDatas = [
  72. {ID: 1, ParentID: -1, NextSiblingID: 2, name: '分类1', type: 1},
  73. {ID: 2, ParentID: -1, NextSiblingID: 3, name: '分类2', type: 1},
  74. {ID: 3, ParentID: -1, NextSiblingID: 4, name: '分类3', type: 1},
  75. // {ID: 105, ParentID: 1, NextSiblingID: 106, name: '块1', type: 2},
  76. // {ID: 106, ParentID: 1, NextSiblingID: 107, name: '块2', type: 2},
  77. {ID: 7, ParentID: -1, NextSiblingID: 8, name: '分类7', type: 1},
  78. {ID: 9, ParentID: -1, NextSiblingID: -1, name: '分类9', type: 1}//,
  79. // {ID: 201, ParentID: 52, NextSiblingID: -1, name: '块201', type: 2}
  80. ];
  81. if (me.mainSpread) {
  82. me.mainSpread.destroy();
  83. me.mainSpread = null;
  84. };
  85. if (me.billSpread) {
  86. me.billSpread.destroy();
  87. me.billSpread = null;
  88. };
  89. if (me.rationSpread) {
  90. me.rationSpread.destroy();
  91. me.rationSpread = null;
  92. };
  93. me.mainSpread = SheetDataHelper.createNewSpread($('#div_block_tree')[0]);
  94. // me.mainSpread = TREE_SHEET_HELPER.createNewSpread($('#div_block_tree')[0]);
  95. me.mainSheet = me.mainSpread.getSheet(0);
  96. me.mainSheet.name('blockLibSheet');
  97. sheetCommonObj.spreadDefaultStyle(me.mainSpread);
  98. // me.mainSpread.bind(GC.Spread.Sheets.Events.CellDoubleClick, this.onCellDoubleClick);
  99. var showblockTree = function (datas) {
  100. me.mainTree = idTree.createNew({id: 'ID', pid: 'ParentID', nid: 'NextSiblingID', rootId: -1, autoUpdate: false});
  101. me.mainTreeController = TREE_SHEET_CONTROLLER.createNew(me.mainTree, me.mainSheet, me.mainSetting);
  102. me.mainTree.loadDatas(datas);
  103. me.mainTreeController.showTreeData();
  104. me.mainSheet.getRange(-1, 0, -1, 1).cellType(me.getTreeCell(me.mainTree));
  105. me.mainTree.selected = me.mainTree.items[0];
  106. me.mainTreeController.bind(TREE_SHEET_CONTROLLER.eventName.treeSelectedChanged, function (node) {
  107. blockLibObj.loadDetailDatas(node);
  108. });
  109. };
  110. /* CommonAjax.post('/complementaryRation/api/getRationTree', {userId: userID, rationRepId: rationLibID}, function (datas) {
  111. showblockTree(datas);
  112. $.bootstrapLoading.end();
  113. }, function () {
  114. showblockTree([]);
  115. $.bootstrapLoading.end();
  116. });*/
  117. showblockTree(me.mainDatas);
  118. me.billSpread = sheetCommonObj.buildSheet($('#div_block_bill')[0], me.billSetting, 1);
  119. me.billSheet = me.billSpread.getSheet(0);
  120. sheetCommonObj.spreadDefaultStyle(me.billSpread);
  121. me.billSheet.setColumnWidth(0, 20, GC.Spread.Sheets.SheetArea.rowHeader);
  122. me.rationSpread = sheetCommonObj.buildSheet($('#div_block_ration')[0], me.rationSetting, 1);
  123. me.rationSheet = me.rationSpread.getSheet(0);
  124. sheetCommonObj.spreadDefaultStyle(me.rationSpread);
  125. me.rationSheet.setColumnWidth(0, 20, GC.Spread.Sheets.SheetArea.rowHeader);
  126. $.bootstrapLoading.end();
  127. },
  128. loadDetailDatas: function (node){
  129. let me = this;
  130. if (node.data.type == 2){
  131. let sourceNode = node.data.sourceNode;
  132. let rations = sourceNode.children;
  133. let rationDatas = [];
  134. for (let r of rations){
  135. rationDatas.push(r.data);
  136. };
  137. sheetCommonObj.showData(me.billSheet, me.billSetting, [sourceNode.data]);
  138. let rCount = (rationDatas.length > 0) ? rationDatas.length : 1;
  139. me.rationSheet.setRowCount(rCount, GC.Spread.Sheets.SheetArea.viewport);
  140. sheetCommonObj.showData(me.rationSheet, me.rationSetting, rationDatas);
  141. }
  142. else{
  143. sheetCommonObj.cleanSheet(me.billSheet, me.billSetting, 1);
  144. sheetCommonObj.cleanSheet(me.rationSheet, me.rationSetting, 1);
  145. }
  146. },
  147. getTreeCell: function (tree) {
  148. let me = this;
  149. let indent = 20, levelIndent = -5, halfBoxLength = 5, halfExpandLength = 3, imgWidth = 14, imgHeight = 14;
  150. let TreeCell = function () {};
  151. TreeCell.prototype = new GC.Spread.Sheets.CellTypes.Text();
  152. TreeCell.prototype.paint = function (ctx, value, x, y, w, h, style, options) {
  153. if (style.backColor) {
  154. ctx.save();
  155. ctx.fillStyle = style.backColor;
  156. ctx.fillRect(x, y, w, h);
  157. ctx.restore();
  158. } else {
  159. ctx.clearRect(x, y, w, h);
  160. };
  161. let drawLine = function (canvas, x1, y1, x2, y2, color) {
  162. ctx.save();
  163. ctx.translate(0.5, 0.5);
  164. ctx.beginPath();
  165. ctx.moveTo(x1, y1);
  166. ctx.lineTo(x2, y2);
  167. ctx.strokeStyle = color;
  168. ctx.stroke();
  169. ctx.restore();
  170. };
  171. let drawExpandBox = function (ctx, x, y, w, h, centerX, centerY, expanded) {
  172. let rect = {}, h1, h2, offset = 1;
  173. rect.top = centerY - halfBoxLength;
  174. rect.bottom = centerY + halfBoxLength;
  175. rect.left = centerX - halfBoxLength;
  176. rect.right = centerX + halfBoxLength;
  177. if (rect.left < x + w) {
  178. rect.right = Math.min(rect.right, x + w);
  179. ctx.save();
  180. ctx.translate(0.5, 0.5);
  181. ctx.strokeStyle = 'black';
  182. ctx.beginPath();
  183. ctx.moveTo(rect.left, rect.top);
  184. ctx.lineTo(rect.left, rect.bottom);
  185. ctx.lineTo(rect.right, rect.bottom);
  186. ctx.lineTo(rect.right, rect.top);
  187. ctx.lineTo(rect.left, rect.top);
  188. ctx.stroke();
  189. ctx.fillStyle = 'white';
  190. ctx.fill();
  191. ctx.restore();
  192. // Draw Horizontal Line
  193. h1 = centerX - halfExpandLength;
  194. h2 = Math.min(centerX + halfExpandLength, x + w);
  195. if (h2 > h1) {
  196. drawLine(ctx, h1, centerY, h2, centerY, 'black');
  197. }
  198. // Draw Vertical Line
  199. if (!expanded && (centerX < x + w)) {
  200. drawLine(ctx, centerX, centerY - halfExpandLength, centerX, centerY + halfExpandLength, 'black');
  201. }
  202. }
  203. };
  204. let node = tree.items[options.row];
  205. if (!node) return;
  206. let showTreeLine = true;
  207. let centerX = Math.floor(x) + node.depth() * indent + node.depth() * levelIndent + indent / 2;
  208. let x1 = centerX + indent / 2;
  209. let centerY = Math.floor((y + (y + h)) / 2);
  210. let y1;
  211. // Draw Horizontal Line、Image、sibling Vertical Line
  212. if (centerX < x + w) {
  213. // Draw Horizontal Line
  214. drawLine(ctx, centerX, centerY, Math.min(x1, x + w), centerY, 'gray');
  215. // Draw Image
  216. let imgId;
  217. if (node.data.type === 0) imgId = 'blockLib_pic'
  218. else if (node.data.type === 1) imgId = 'folder_pic'
  219. else if (node.data.type === 2) {
  220. imgId = 'block_pic';
  221. };
  222. let img = document.getElementById(imgId);
  223. ctx.drawImage(img, centerX+indent/2+3, centerY - 7, imgWidth, imgHeight);
  224. // Draw Vertical Line
  225. y1 = node.isLast() ? centerY : y + h;
  226. if (node.isFirst() && !node.parent/*.parent*/) {
  227. drawLine(ctx, centerX, centerY, centerX, y1, 'gray');
  228. } else {
  229. drawLine(ctx, centerX, y, centerX, y1, 'gray');
  230. }
  231. }
  232. // Draw Expand Box
  233. if (node.children.length > 0) {
  234. drawExpandBox(ctx, x, y, w, h, centerX, centerY, node.expanded);
  235. }
  236. // Draw Parent Line
  237. var curNode = node.parent, parentCenterX = centerX - indent - levelIndent;
  238. while (curNode) {
  239. if (!curNode.isLast()) {
  240. if (parentCenterX < x + w) {
  241. drawLine(ctx, parentCenterX, y, parentCenterX, y + h, 'gray');
  242. }
  243. }
  244. curNode = curNode.parent;
  245. parentCenterX -= (indent + levelIndent);
  246. }
  247. // Draw Text
  248. x = x + (node.depth() + 1) * indent + node.depth() * levelIndent + imgWidth + 3;
  249. w = w - (node.depth() + 1) * indent - node.depth() * levelIndent - imgWidth - 3;
  250. GC.Spread.Sheets.CellTypes.Text.prototype.paint.apply(this, arguments);
  251. };
  252. TreeCell.prototype.getHitInfo = function (x, y, cellStyle, cellRect, context) {
  253. let info = {x: x, y: y, row: context.row, col: context.col, cellStyle: cellStyle, cellRect: cellRect, sheetArea: context.sheetArea};
  254. let node = tree.items[info.row];
  255. let offset = -1;
  256. let centerX = info.cellRect.x + offset + node.depth() * indent + node.depth() * levelIndent + indent / 2;
  257. let text = context.sheet.getText(info.row, info.col);
  258. let value = context.sheet.getValue(info.row, info.col);
  259. let acStyle = context.sheet.getActualStyle(info.row, info.col),
  260. zoom = context.sheet.zoom();
  261. let textLength = this.getAutoFitWidth(value, text, acStyle, zoom, {sheet: context.sheet, row: info.row, col: info.col, sheetArea: GC.Spread.Sheets.SheetArea.viewport});
  262. if(info.x > centerX + halfBoxLength && info.x < centerX + halfBoxLength + imgWidth + indent/2+3 + textLength){
  263. info.isReservedLocation = true;
  264. }
  265. return info;
  266. };
  267. TreeCell.prototype.processMouseDown = function (hitinfo) {
  268. let offset = -1;
  269. let node = tree.items[hitinfo.row];
  270. let centerX = hitinfo.cellRect.x + offset + node.depth() * indent + node.depth() * levelIndent + indent / 2;
  271. let centerY = (hitinfo.cellRect.y + offset + (hitinfo.cellRect.y + offset + hitinfo.cellRect.height)) / 2;
  272. let text = hitinfo.sheet.getText(hitinfo.row, hitinfo.col);
  273. let value = hitinfo.sheet.getValue(hitinfo.row, hitinfo.col);
  274. let acStyle = hitinfo.sheet.getActualStyle(hitinfo.row, hitinfo.col),
  275. zoom = hitinfo.sheet.zoom();
  276. let textLength = this.getAutoFitWidth(value, text, acStyle, zoom, {sheet: hitinfo.sheet, row: hitinfo.row, col: hitinfo.col, sheetArea: GC.Spread.Sheets.SheetArea.viewport});
  277. //(图标+名字)区域
  278. function withingClickArea(){
  279. return hitinfo.x > centerX + halfBoxLength && hitinfo.x < centerX + halfBoxLength + imgWidth + indent/2+3 + textLength;
  280. }
  281. if (hitinfo.x > centerX - halfBoxLength && hitinfo.x < centerX + halfBoxLength && hitinfo.y > centerY - halfBoxLength && hitinfo.y < centerY + halfBoxLength) {
  282. node.setExpanded(!node.expanded);
  283. TREE_SHEET_HELPER.massOperationSheet(hitinfo.sheet, function () {
  284. let iCount = node.posterityCount(), i, child;
  285. for (i = 0; i < iCount; i++) {
  286. child = tree.items[hitinfo.row + i + 1];
  287. hitinfo.sheet.setRowVisible(hitinfo.row + i + 1, child.visible, hitinfo.sheetArea);
  288. }
  289. hitinfo.sheet.invalidateLayout();
  290. });
  291. hitinfo.sheet.repaint();
  292. }
  293. };
  294. TreeCell.prototype.processMouseMove = function (hitInfo) {
  295. let sheet = hitInfo.sheet;
  296. let div = sheet.getParent().getHost();
  297. let canvasId = div.id + "vp_vp";
  298. /* let canvas = $(`#${canvasId}`)[0];
  299. //改变鼠标图案
  300. if (sheet && hitInfo.isReservedLocation) {
  301. canvas.style.cursor='pointer';
  302. return true;
  303. }else{
  304. canvas.style.cursor='default';
  305. }*/
  306. return false;
  307. };
  308. TreeCell.prototype.processMouseEnter = function (hitinfo) {
  309. let text = hitinfo.sheet.getText(hitinfo.row, hitinfo.col);
  310. let value = hitinfo.sheet.getValue(hitinfo.row, hitinfo.col);
  311. let tag = hitinfo.sheet.getTag(hitinfo.row, hitinfo.col);
  312. let acStyle = hitinfo.sheet.getActualStyle(hitinfo.row, hitinfo.col),
  313. zoom = hitinfo.sheet.zoom();
  314. let node = me.mainTree.items[hitinfo.row];
  315. let nodeIndent = node ? (node.depth() + 1) * indent + node.depth() * levelIndent + imgWidth + 3 : 0;
  316. let textLength = this.getAutoFitWidth(value, text, acStyle, zoom, {sheet: hitinfo.sheet, row: hitinfo.row, col: hitinfo.col, sheetArea: GC.Spread.Sheets.SheetArea.viewport});
  317. let cellWidth = hitinfo.sheet.getCell(-1, hitinfo.col).width();
  318. if(textLength > cellWidth - nodeIndent){
  319. TREE_SHEET_HELPER.showTipsDiv(text,{pos: {}},hitinfo);
  320. }
  321. };
  322. TreeCell.prototype.processMouseLeave = function (hitinfo) {
  323. let me = this;
  324. TREE_SHEET_HELPER.tipDiv = 'hide';
  325. if (TREE_SHEET_HELPER._toolTipElement) {
  326. $(TREE_SHEET_HELPER._toolTipElement).hide();
  327. TREE_SHEET_HELPER._toolTipElement = null;
  328. };
  329. TREE_SHEET_HELPER.tipDivCheck();//延时检查:当tips正在show的时候,就调用了hide方法,会导致tips一直存在,所以设置一个超时处理
  330. };
  331. return new TreeCell();
  332. },
  333. newNode: function (nodeType, nodeName, categoryID, sourceNode){ // 1 分类(只用前两个参数) 2 块文件
  334. let tree = blockLibObj.mainTree;
  335. let pID = -1, nID = -1;
  336. let select = tree.selected;
  337. if (nodeType == 1){
  338. if (!select) {
  339. nID = -1;
  340. }
  341. else if (select.data.type == 1){
  342. nID = select.getNextSiblingID();
  343. }
  344. else if (select.data.type == 2){
  345. nID = select.parent.getNextSiblingID();
  346. };
  347. }
  348. else if (nodeType == 2) {
  349. pID = categoryID;
  350. nID = -1;
  351. }
  352. let newNode = tree.insert(pID, nID);
  353. newNode.data.type = nodeType;
  354. newNode.data.name = nodeName;
  355. if (nodeType == 2)
  356. newNode.data.sourceNode = sourceNode;
  357. tree.selected = newNode;
  358. let sheet = blockLibObj.mainSheet;
  359. sheet.suspendPaint();
  360. sheet.suspendEvent();
  361. let idx = tree.items.indexOf(newNode);
  362. sheet.addRows(idx, 1);
  363. sheet.getRange(idx, 0, 1, 1).locked(true);
  364. sheet.setValue(idx, 0, newNode.data.name);
  365. sheet.setSelection(idx, 0, 1, 1);
  366. sheet.resumeEvent();
  367. sheet.resumePaint();
  368. },
  369. reName: function (node, newName){
  370. node.data.name = newName;
  371. let idx = blockLibObj.mainTree.items.indexOf(node);
  372. blockLibObj.mainSheet.setValue(idx, 0, newName);
  373. },
  374. getCategories: function () {
  375. let nodes = [], node = blockLibObj.mainTree.items[0];
  376. nodes.push(node);
  377. while (node.nextSibling != null){
  378. node = node.nextSibling;
  379. nodes.push(node);
  380. };
  381. return nodes;
  382. }
  383. };
  384. $(document).ready(function(){
  385. $('#blockLibTab').on('click', function (){
  386. if ($("#kmbk").is(":visible")){
  387. if (!blockLibObj.mainSpread){
  388. blockLibObj.buildSheet();
  389. };
  390. }
  391. });
  392. $('#btn_block_newFolder').on('click', function (){
  393. $('#input_block_newFolder').val('');
  394. });
  395. $('#btn_block_newFolder_add').on('click', function (){
  396. let name = $('#input_block_newFolder').val();
  397. if (name != '') blockLibObj.newNode(1, name);
  398. });
  399. $('#btn_block_reName').on('click', function (){
  400. let select = blockLibObj.mainTree.selected;
  401. $('#input_block_reName').val(select.data.name);
  402. });
  403. $('#btn_block_reName_OK').on('click', function (){
  404. let select = blockLibObj.mainTree.selected;
  405. let oldName = select.data.name;
  406. let newName = $('#input_block_reName').val();
  407. if (oldName != newName) blockLibObj.reName(select, newName);
  408. });
  409. });