block_lib.js 19 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440
  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.rationSpread = sheetCommonObj.buildSheet($('#div_block_ration')[0], me.rationSetting, 1);
  122. me.rationSheet = me.rationSpread.getSheet(0);
  123. sheetCommonObj.spreadDefaultStyle(me.rationSpread);
  124. $.bootstrapLoading.end();
  125. },
  126. loadDetailDatas: function (node){
  127. let me = this;
  128. if (node.data.type == 2){
  129. let sourceNode = node.data.sourceNode;
  130. let rations = sourceNode.children;
  131. let rationDatas = [];
  132. for (let r of rations){
  133. rationDatas.push(r.data);
  134. };
  135. sheetCommonObj.showData(me.billSheet, me.billSetting, [sourceNode.data]);
  136. let rCount = (rationDatas.length > 0) ? rationDatas.length : 1;
  137. me.rationSheet.setRowCount(rCount, GC.Spread.Sheets.SheetArea.viewport);
  138. sheetCommonObj.showData(me.rationSheet, me.rationSetting, rationDatas);
  139. }
  140. else{
  141. sheetCommonObj.cleanSheet(me.billSheet, me.billSetting, 1);
  142. sheetCommonObj.cleanSheet(me.rationSheet, me.rationSetting, 1);
  143. }
  144. },
  145. getTreeCell: function (tree) {
  146. let me = this;
  147. let indent = 20, levelIndent = -5, halfBoxLength = 5, halfExpandLength = 3, imgWidth = 14, imgHeight = 14;
  148. let TreeCell = function () {};
  149. TreeCell.prototype = new GC.Spread.Sheets.CellTypes.Text();
  150. TreeCell.prototype.paint = function (ctx, value, x, y, w, h, style, options) {
  151. if (style.backColor) {
  152. ctx.save();
  153. ctx.fillStyle = style.backColor;
  154. ctx.fillRect(x, y, w, h);
  155. ctx.restore();
  156. } else {
  157. ctx.clearRect(x, y, w, h);
  158. };
  159. let drawLine = function (canvas, x1, y1, x2, y2, color) {
  160. ctx.save();
  161. ctx.translate(0.5, 0.5);
  162. ctx.beginPath();
  163. ctx.moveTo(x1, y1);
  164. ctx.lineTo(x2, y2);
  165. ctx.strokeStyle = color;
  166. ctx.stroke();
  167. ctx.restore();
  168. };
  169. let drawExpandBox = function (ctx, x, y, w, h, centerX, centerY, expanded) {
  170. let rect = {}, h1, h2, offset = 1;
  171. rect.top = centerY - halfBoxLength;
  172. rect.bottom = centerY + halfBoxLength;
  173. rect.left = centerX - halfBoxLength;
  174. rect.right = centerX + halfBoxLength;
  175. if (rect.left < x + w) {
  176. rect.right = Math.min(rect.right, x + w);
  177. ctx.save();
  178. ctx.translate(0.5, 0.5);
  179. ctx.strokeStyle = 'black';
  180. ctx.beginPath();
  181. ctx.moveTo(rect.left, rect.top);
  182. ctx.lineTo(rect.left, rect.bottom);
  183. ctx.lineTo(rect.right, rect.bottom);
  184. ctx.lineTo(rect.right, rect.top);
  185. ctx.lineTo(rect.left, rect.top);
  186. ctx.stroke();
  187. ctx.fillStyle = 'white';
  188. ctx.fill();
  189. ctx.restore();
  190. // Draw Horizontal Line
  191. h1 = centerX - halfExpandLength;
  192. h2 = Math.min(centerX + halfExpandLength, x + w);
  193. if (h2 > h1) {
  194. drawLine(ctx, h1, centerY, h2, centerY, 'black');
  195. }
  196. // Draw Vertical Line
  197. if (!expanded && (centerX < x + w)) {
  198. drawLine(ctx, centerX, centerY - halfExpandLength, centerX, centerY + halfExpandLength, 'black');
  199. }
  200. }
  201. };
  202. let node = tree.items[options.row];
  203. if (!node) return;
  204. let showTreeLine = true;
  205. let centerX = Math.floor(x) + node.depth() * indent + node.depth() * levelIndent + indent / 2;
  206. let x1 = centerX + indent / 2;
  207. let centerY = Math.floor((y + (y + h)) / 2);
  208. let y1;
  209. // Draw Horizontal Line、Image、sibling Vertical Line
  210. if (centerX < x + w) {
  211. // Draw Horizontal Line
  212. drawLine(ctx, centerX, centerY, Math.min(x1, x + w), centerY, 'gray');
  213. // Draw Image
  214. let imgId;
  215. if (node.data.type === 0) imgId = 'blockLib_pic'
  216. else if (node.data.type === 1) imgId = 'folder_pic'
  217. else if (node.data.type === 2) {
  218. imgId = 'block_pic';
  219. };
  220. let img = document.getElementById(imgId);
  221. ctx.drawImage(img, centerX+indent/2+3, centerY - 7, imgWidth, imgHeight);
  222. // Draw Vertical Line
  223. y1 = node.isLast() ? centerY : y + h;
  224. if (node.isFirst() && !node.parent/*.parent*/) {
  225. drawLine(ctx, centerX, centerY, centerX, y1, 'gray');
  226. } else {
  227. drawLine(ctx, centerX, y, centerX, y1, 'gray');
  228. }
  229. }
  230. // Draw Expand Box
  231. if (node.children.length > 0) {
  232. drawExpandBox(ctx, x, y, w, h, centerX, centerY, node.expanded);
  233. }
  234. // Draw Parent Line
  235. var curNode = node.parent, parentCenterX = centerX - indent - levelIndent;
  236. while (curNode) {
  237. if (!curNode.isLast()) {
  238. if (parentCenterX < x + w) {
  239. drawLine(ctx, parentCenterX, y, parentCenterX, y + h, 'gray');
  240. }
  241. }
  242. curNode = curNode.parent;
  243. parentCenterX -= (indent + levelIndent);
  244. }
  245. // Draw Text
  246. x = x + (node.depth() + 1) * indent + node.depth() * levelIndent + imgWidth + 3;
  247. w = w - (node.depth() + 1) * indent - node.depth() * levelIndent - imgWidth - 3;
  248. GC.Spread.Sheets.CellTypes.Text.prototype.paint.apply(this, arguments);
  249. };
  250. TreeCell.prototype.getHitInfo = function (x, y, cellStyle, cellRect, context) {
  251. let info = {x: x, y: y, row: context.row, col: context.col, cellStyle: cellStyle, cellRect: cellRect, sheetArea: context.sheetArea};
  252. let node = tree.items[info.row];
  253. let offset = -1;
  254. let centerX = info.cellRect.x + offset + node.depth() * indent + node.depth() * levelIndent + indent / 2;
  255. let text = context.sheet.getText(info.row, info.col);
  256. let value = context.sheet.getValue(info.row, info.col);
  257. let acStyle = context.sheet.getActualStyle(info.row, info.col),
  258. zoom = context.sheet.zoom();
  259. let textLength = this.getAutoFitWidth(value, text, acStyle, zoom, {sheet: context.sheet, row: info.row, col: info.col, sheetArea: GC.Spread.Sheets.SheetArea.viewport});
  260. if(info.x > centerX + halfBoxLength && info.x < centerX + halfBoxLength + imgWidth + indent/2+3 + textLength){
  261. info.isReservedLocation = true;
  262. }
  263. return info;
  264. };
  265. TreeCell.prototype.processMouseDown = function (hitinfo) {
  266. let offset = -1;
  267. let node = tree.items[hitinfo.row];
  268. let centerX = hitinfo.cellRect.x + offset + node.depth() * indent + node.depth() * levelIndent + indent / 2;
  269. let centerY = (hitinfo.cellRect.y + offset + (hitinfo.cellRect.y + offset + hitinfo.cellRect.height)) / 2;
  270. let text = hitinfo.sheet.getText(hitinfo.row, hitinfo.col);
  271. let value = hitinfo.sheet.getValue(hitinfo.row, hitinfo.col);
  272. let acStyle = hitinfo.sheet.getActualStyle(hitinfo.row, hitinfo.col),
  273. zoom = hitinfo.sheet.zoom();
  274. let textLength = this.getAutoFitWidth(value, text, acStyle, zoom, {sheet: hitinfo.sheet, row: hitinfo.row, col: hitinfo.col, sheetArea: GC.Spread.Sheets.SheetArea.viewport});
  275. //(图标+名字)区域
  276. function withingClickArea(){
  277. return hitinfo.x > centerX + halfBoxLength && hitinfo.x < centerX + halfBoxLength + imgWidth + indent/2+3 + textLength;
  278. }
  279. if (hitinfo.x > centerX - halfBoxLength && hitinfo.x < centerX + halfBoxLength && hitinfo.y > centerY - halfBoxLength && hitinfo.y < centerY + halfBoxLength) {
  280. node.setExpanded(!node.expanded);
  281. TREE_SHEET_HELPER.massOperationSheet(hitinfo.sheet, function () {
  282. let iCount = node.posterityCount(), i, child;
  283. for (i = 0; i < iCount; i++) {
  284. child = tree.items[hitinfo.row + i + 1];
  285. hitinfo.sheet.setRowVisible(hitinfo.row + i + 1, child.visible, hitinfo.sheetArea);
  286. }
  287. hitinfo.sheet.invalidateLayout();
  288. });
  289. hitinfo.sheet.repaint();
  290. }
  291. };
  292. TreeCell.prototype.processMouseMove = function (hitInfo) {
  293. let sheet = hitInfo.sheet;
  294. let div = sheet.getParent().getHost();
  295. let canvasId = div.id + "vp_vp";
  296. /* let canvas = $(`#${canvasId}`)[0];
  297. //改变鼠标图案
  298. if (sheet && hitInfo.isReservedLocation) {
  299. canvas.style.cursor='pointer';
  300. return true;
  301. }else{
  302. canvas.style.cursor='default';
  303. }*/
  304. return false;
  305. };
  306. TreeCell.prototype.processMouseEnter = function (hitinfo) {
  307. let text = hitinfo.sheet.getText(hitinfo.row, hitinfo.col);
  308. let value = hitinfo.sheet.getValue(hitinfo.row, hitinfo.col);
  309. let tag = hitinfo.sheet.getTag(hitinfo.row, hitinfo.col);
  310. let acStyle = hitinfo.sheet.getActualStyle(hitinfo.row, hitinfo.col),
  311. zoom = hitinfo.sheet.zoom();
  312. let node = me.mainTree.items[hitinfo.row];
  313. let nodeIndent = node ? (node.depth() + 1) * indent + node.depth() * levelIndent + imgWidth + 3 : 0;
  314. let textLength = this.getAutoFitWidth(value, text, acStyle, zoom, {sheet: hitinfo.sheet, row: hitinfo.row, col: hitinfo.col, sheetArea: GC.Spread.Sheets.SheetArea.viewport});
  315. let cellWidth = hitinfo.sheet.getCell(-1, hitinfo.col).width();
  316. if(textLength > cellWidth - nodeIndent){
  317. TREE_SHEET_HELPER.showTipsDiv(text,{pos: {}},hitinfo);
  318. }
  319. };
  320. TreeCell.prototype.processMouseLeave = function (hitinfo) {
  321. let me = this;
  322. TREE_SHEET_HELPER.tipDiv = 'hide';
  323. if (TREE_SHEET_HELPER._toolTipElement) {
  324. $(TREE_SHEET_HELPER._toolTipElement).hide();
  325. TREE_SHEET_HELPER._toolTipElement = null;
  326. };
  327. TREE_SHEET_HELPER.tipDivCheck();//延时检查:当tips正在show的时候,就调用了hide方法,会导致tips一直存在,所以设置一个超时处理
  328. };
  329. return new TreeCell();
  330. },
  331. newNode: function (nodeType, nodeName, categoryID, sourceNode){ // 1 分类(只用前两个参数) 2 块文件
  332. let tree = blockLibObj.mainTree;
  333. let pID = -1, nID = -1;
  334. let select = tree.selected;
  335. if (nodeType == 1){
  336. if (!select) {
  337. nID = -1;
  338. }
  339. else if (select.data.type == 1){
  340. nID = select.getNextSiblingID();
  341. }
  342. else if (select.data.type == 2){
  343. nID = select.parent.getNextSiblingID();
  344. };
  345. }
  346. else if (nodeType == 2) {
  347. pID = categoryID;
  348. nID = -1;
  349. }
  350. let newNode = tree.insert(pID, nID);
  351. newNode.data.type = nodeType;
  352. newNode.data.name = nodeName;
  353. if (nodeType == 2)
  354. newNode.data.sourceNode = sourceNode;
  355. tree.selected = newNode;
  356. let sheet = blockLibObj.mainSheet;
  357. sheet.suspendPaint();
  358. sheet.suspendEvent();
  359. let idx = tree.items.indexOf(newNode);
  360. sheet.addRows(idx, 1);
  361. sheet.getRange(idx, 0, 1, 1).locked(true);
  362. sheet.setValue(idx, 0, newNode.data.name);
  363. sheet.setSelection(idx, 0, 1, 1);
  364. sheet.resumeEvent();
  365. sheet.resumePaint();
  366. },
  367. reName: function (node, newName){
  368. node.data.name = newName;
  369. let idx = blockLibObj.mainTree.items.indexOf(node);
  370. blockLibObj.mainSheet.setValue(idx, 0, newName);
  371. },
  372. getCategories: function () {
  373. let nodes = [], node = blockLibObj.mainTree.items[0];
  374. nodes.push(node);
  375. while (node.nextSibling != null){
  376. node = node.nextSibling;
  377. nodes.push(node);
  378. };
  379. return nodes;
  380. }
  381. };
  382. $(document).ready(function(){
  383. $('#blockLibTab').on('click', function (){
  384. if ($("#kmbk").is(":visible")){
  385. if (!blockLibObj.mainSpread){
  386. blockLibObj.buildSheet();
  387. };
  388. }
  389. });
  390. $('#btn_block_newFolder').on('click', function (){
  391. $('#input_block_newFolder').val('');
  392. });
  393. $('#btn_block_newFolder_add').on('click', function (){
  394. let name = $('#input_block_newFolder').val();
  395. if (name != '') blockLibObj.newNode(1, name);
  396. });
  397. $('#btn_block_reName').on('click', function (){
  398. let select = blockLibObj.mainTree.selected;
  399. $('#input_block_reName').val(select.data.name);
  400. });
  401. $('#btn_block_reName_OK').on('click', function (){
  402. let select = blockLibObj.mainTree.selected;
  403. let oldName = select.data.name;
  404. let newName = $('#input_block_reName').val();
  405. if (oldName != newName) blockLibObj.reName(select, newName);
  406. });
  407. });