budget_detail.js 33 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745
  1. 'use strict';
  2. /**
  3. *
  4. *
  5. * @author Mai
  6. * @date
  7. * @version
  8. */
  9. const invalidFields = {
  10. parent: ['total_price', 'unit_price'],
  11. gcl: ['dgn_qty1', 'dgn_qty2', 'total_price'],
  12. };
  13. $(document).ready(() => {
  14. const copyBlockTag = 'zh.calc.copyBlock';
  15. if (needGcl) invalidFields.parent.push('quantity');
  16. let stdXmj, stdGcl, searchBudget;
  17. autoFlashHeight();
  18. const budgetSpread = SpreadJsObj.createNewSpread($('#budget-spread')[0]);
  19. const budgetSheet = budgetSpread.getActiveSheet();
  20. sjsSettingObj.setFxTreeStyle(spreadSetting, sjsSettingObj.FxTreeStyle.jz);
  21. spreadSetting.readOnly = readOnly;
  22. // if (thousandth) sjsSettingObj.setTpThousandthFormat(spreadSetting);
  23. SpreadJsObj.initSheet(budgetSheet, spreadSetting);
  24. $.subMenu({
  25. menu: '#sub-menu', miniMenu: '#sub-mini-menu', miniMenuList: '#mini-menu-list',
  26. toMenu: '#to-menu', toMiniMenu: '#to-mini-menu',
  27. key: 'menu.1.0.0',
  28. miniHint: '#sub-mini-hint', hintKey: 'menu.hint.1.0.1',
  29. callback: function (info) {
  30. if (info.mini) {
  31. $('.panel-title').addClass('fluid');
  32. $('#sub-menu').removeClass('panel-sidebar');
  33. } else {
  34. $('.panel-title').removeClass('fluid');
  35. $('#sub-menu').addClass('panel-sidebar');
  36. }
  37. autoFlashHeight();
  38. }
  39. });
  40. const budgetTree = createNewPathTree('ledger', {
  41. id: 'tree_id',
  42. pid: 'tree_pid',
  43. order: 'order',
  44. level: 'level',
  45. rootId: -1,
  46. keys: ['id', 'bid', 'tree_id'],
  47. autoExpand: 3,
  48. markExpandKey: 'bills-expand',
  49. markExpandSubKey: window.location.pathname.split('/')[2],
  50. calcFields: ['total_price'],
  51. calcFun: function (node) {
  52. node.dgn_price = ZhCalc.div(node.total_price, node.dgn_qty1, 2);
  53. },
  54. });
  55. $.divResizer({
  56. select: '#right-spr',
  57. callback: function () {
  58. budgetSpread.refresh();
  59. if (stdXmj) stdXmj.spread.refresh();
  60. if (stdGcl) stdGcl.spread.refresh();
  61. if (searchBudget) searchBudget.spread.refresh();
  62. }
  63. });
  64. const budgetTreeOpr = {
  65. refreshTree: function (sheet, data) {
  66. SpreadJsObj.massOperationSheet(sheet, function () {
  67. const tree = sheet.zh_tree;
  68. // 处理删除
  69. if (data.delete) {
  70. data.delete.sort(function (a, b) {
  71. return b.deleteIndex - a.deleteIndex;
  72. });
  73. for (const d of data.delete) {
  74. sheet.deleteRows(d.deleteIndex, 1);
  75. }
  76. }
  77. // 处理新增
  78. if (data.create) {
  79. const newNodes = data.create;
  80. if (newNodes) {
  81. newNodes.sort(function (a, b) {
  82. return a.index - b.index;
  83. });
  84. for (const node of newNodes) {
  85. sheet.addRows(node.index, 1);
  86. SpreadJsObj.reLoadRowData(sheet, tree.nodes.indexOf(node), 1);
  87. }
  88. }
  89. }
  90. // 处理更新
  91. if (data.update) {
  92. const rows = [];
  93. for (const u of data.update) {
  94. rows.push(tree.nodes.indexOf(u));
  95. }
  96. SpreadJsObj.reLoadRowsData(sheet, rows);
  97. }
  98. // 处理展开
  99. if (data.expand) {
  100. const expanded = [];
  101. for (const e of data.expand) {
  102. if (expanded.indexOf(e) === -1) {
  103. const posterity = tree.getPosterity(e);
  104. for (const p of posterity) {
  105. sheet.setRowVisible(tree.nodes.indexOf(p), p.visible);
  106. expanded.push(p);
  107. }
  108. }
  109. }
  110. }
  111. });
  112. },
  113. getDefaultSelectInfo: function (sheet) {
  114. const tree = sheet.zh_tree;
  115. if (!tree) return;
  116. const sel = sheet.getSelections()[0];
  117. const node = sheet.zh_tree.nodes[sel.row];
  118. if (!node) return;
  119. let count = 1;
  120. if (sel.rowCount > 1) {
  121. for (let r = 1; r < sel.rowCount; r++) {
  122. const rNode = sheet.zh_tree.nodes[sel.row + r];
  123. if (rNode.level > node.level) continue;
  124. if ((rNode.level < node.level) || (rNode.level === node.level && rNode.pid !== node.pid)) {
  125. toastr.warning('请选择同一节点下的节点,进行该操作');
  126. return;
  127. }
  128. count += 1;
  129. }
  130. }
  131. return [tree, node, count];
  132. },
  133. /**
  134. * 刷新顶部按钮是否可用
  135. * @param sheet
  136. * @param selections
  137. */
  138. refreshOperationValid: function (sheet, selection) {
  139. const setObjEnable = function (obj, enable) {
  140. if (enable) {
  141. obj.removeClass('disabled');
  142. } else {
  143. obj.addClass('disabled');
  144. }
  145. };
  146. const invalidAll = function () {
  147. setObjEnable($('a[name=base-opr][type=add]'), false);
  148. setObjEnable($('a[name=base-opr][type=delete]'), false);
  149. setObjEnable($('a[name=base-opr][type=up-move]'), false);
  150. setObjEnable($('a[name=base-opr][type=down-move]'), false);
  151. setObjEnable($('a[name=base-opr][type=up-level]'), false);
  152. setObjEnable($('a[name=base-opr][type=down-level]'), false);
  153. };
  154. const sel = selection ? selection[0] : sheet.getSelections()[0];
  155. const row = sel ? sel.row : -1;
  156. const tree = sheet.zh_tree;
  157. if (!tree) {
  158. invalidAll();
  159. return;
  160. }
  161. const first = sheet.zh_tree.nodes[row];
  162. if (!first) {
  163. invalidAll();
  164. return;
  165. }
  166. let last = first, sameParent = true;
  167. if (sel.rowCount > 1 && first) {
  168. for (let r = 1; r < sel.rowCount; r++) {
  169. const rNode = tree.nodes[sel.row + r];
  170. if (!rNode) {
  171. sameParent = false;
  172. break;
  173. }
  174. if (rNode.level > first.level) continue;
  175. if ((rNode.level < first.level) || (rNode.level === first.level && rNode.pid !== first.pid)) {
  176. sameParent = false;
  177. break;
  178. }
  179. last = rNode;
  180. }
  181. }
  182. const preNode = tree.getPreSiblingNode(first);
  183. const valid = !readOnly;
  184. setObjEnable($('a[name=base-opr][type=add]'), valid && first && first.level > 1);
  185. setObjEnable($('a[name=base-opr][type=delete]'), valid && first && sameParent && first.level > 1);
  186. setObjEnable($('a[name=base-opr][type=up-move]'), valid && first && sameParent && first.level > 1 && preNode);
  187. setObjEnable($('a[name=base-opr][type=down-move]'), valid && first && sameParent && first.level > 1 && !tree.isLastSibling(last));
  188. setObjEnable($('a[name=base-opr][type=up-level]'), valid && first && sameParent && tree.getParent(first) && first.level > 2 && tree.isLastSibling(last));
  189. setObjEnable($('a[name=base-opr][type=down-level]'), valid && first && sameParent && first.level > 1 && preNode);
  190. },
  191. selectionChanged: function (e, info) {
  192. if (info.newSelections) {
  193. if (!info.oldSelections || info.newSelections[0].row !== info.oldSelections[0].row) {
  194. budgetTreeOpr.refreshOperationValid(info.sheet);
  195. }
  196. }
  197. },
  198. /**
  199. * 新增节点
  200. * @param spread
  201. */
  202. baseOpr: function (sheet, type, addCount = 1) {
  203. const self = this;
  204. const [tree, node, count] = this.getDefaultSelectInfo(sheet);
  205. if (!tree || !node || !count) return;
  206. if (type === 'delete') {
  207. deleteAfterHint(function () {
  208. postData(window.location.pathname + '/update', {
  209. postType: type,
  210. postData: { id: node.tree_id, count: type === 'add' ? addCount : count }
  211. }, function (result) {
  212. const refreshData = tree.loadPostData(result);
  213. self.refreshTree(sheet, refreshData);
  214. const sel = sheet.getSelections()[0];
  215. if (sel) {
  216. sheet.setSelection(sel.row, sel.col, 1, sel.colCount);
  217. }
  218. self.refreshOperationValid(sheet);
  219. });
  220. });
  221. } else {
  222. postData(window.location.pathname + '/update', {
  223. postType: type,
  224. postData: { id: node.tree_id, count: type === 'add' ? addCount : count }
  225. }, function (result) {
  226. const refreshData = tree.loadPostData(result);
  227. self.refreshTree(sheet, refreshData);
  228. if (['up-move', 'down-move'].indexOf(type) > -1) {
  229. const sel = sheet.getSelections()[0];
  230. if (sel) {
  231. sheet.setSelection(tree.nodes.indexOf(node), sel.col, sel.rowCount, sel.colCount);
  232. SpreadJsObj.reloadRowsBackColor(sheet, [sel.row, tree.nodes.indexOf(node)]);
  233. }
  234. } else if (type === 'add') {
  235. const sel = sheet.getSelections()[0];
  236. if (sel) {
  237. sheet.setSelection(tree.nodes.indexOf(refreshData.create[0]), sel.col, sel.rowCount, sel.colCount);
  238. SpreadJsObj.reloadRowsBackColor(sheet, [sel.row, tree.nodes.indexOf(refreshData.create[0])]);
  239. }
  240. }
  241. self.refreshOperationValid(sheet);
  242. });
  243. }
  244. },
  245. editStarting(e, info) {
  246. if (!info.sheet.zh_setting || !info.sheet.zh_tree) return;
  247. const col = info.sheet.zh_setting.cols[info.col];
  248. const node = info.sheet.zh_tree.nodes[info.row];
  249. if (!node) {
  250. info.cancel = true;
  251. return;
  252. }
  253. switch (col.field) {
  254. case 'unit_price':
  255. info.cancel = (node.children && node.children.length > 0) || !node.b_code;
  256. break;
  257. case 'total_price':
  258. info.cancel = (node.children && node.children.length > 0) || node.b_code;
  259. break;
  260. case 'quantity':
  261. info.cancel = (node.children && node.children.length > 0);
  262. break;
  263. case 'dgn_price':
  264. info.cance = false;
  265. break;
  266. case 'dgn_qty1':
  267. case 'dgn_qty2':
  268. info.cancel = !_.isEmpty(node.b_code);
  269. break;
  270. }
  271. },
  272. /**
  273. * 编辑单元格响应事件
  274. * @param {Object} e
  275. * @param {Object} info
  276. */
  277. editEnded: function (e, info) {
  278. if (info.sheet.zh_setting) {
  279. const col = info.sheet.zh_setting.cols[info.col];
  280. const sortData = info.sheet.zh_tree.nodes;
  281. const node = sortData[info.row];
  282. const data = { id: node.id, bid: node.bid, tree_id: node.tree_id };
  283. // 未改变值则不提交
  284. const orgValue = node[col.field];
  285. const newValue = trimInvalidChar(info.editingText);
  286. if (orgValue == info.editingText || ((!orgValue || orgValue === '') && (newValue === ''))) return;
  287. if (node.b_code && invalidFields.gcl.indexOf(col.field) >=0) {
  288. toastr.error('工程量清单请勿输入设计数量、金额');
  289. return;
  290. }
  291. // 获取更新数据
  292. if (newValue) {
  293. if (col.type === 'Number') {
  294. const num = _.toNumber(newValue);
  295. if (_.isNaN(num)) {
  296. toastr.error('请输入数字');
  297. SpreadJsObj.reLoadRowData(info.sheet, info.row);
  298. return;
  299. }
  300. data[col.field] = num;
  301. } else {
  302. data[col.field] = newValue;
  303. }
  304. } else {
  305. data[col.field] = col.type === 'Number' ? 0 : '';
  306. }
  307. console.log(data);
  308. // 更新至服务器
  309. postData(window.location.pathname + '/update', {postType: 'update', postData: data}, function (result) {
  310. const refreshNode = budgetTree.loadPostData(result);
  311. budgetTreeOpr.refreshTree(info.sheet, refreshNode);
  312. });
  313. }
  314. },
  315. clipboardPasting: function (e, info) {
  316. const tree = info.sheet.zh_tree, setting = info.sheet.zh_setting;
  317. info.cancel = true;
  318. if (!setting || !tree) return;
  319. const pasteData = info.pasteData.html
  320. ? SpreadJsObj.analysisPasteHtml(info.pasteData.html)
  321. : (info.pasteData.text === ''
  322. ? SpreadJsObj.Clipboard.getAnalysisPasteText()
  323. : SpreadJsObj.analysisPasteText(info.pasteData.text));
  324. const hint = {
  325. invalidNum: {type: 'warning', msg: '粘贴的数字非法'},
  326. parent: {type: 'warning', msg: `含有子项,不可粘贴${needGcl ? '数量、单价、' : ''}金额`},
  327. gcl: {type: 'warning', msg: '工程量清单,不可粘贴项目节数量、金额'}
  328. };
  329. const datas = [], filterNodes = [];
  330. let filterRow = 0;
  331. for (let iRow = 0; iRow < info.cellRange.rowCount; iRow ++) {
  332. const curRow = info.cellRange.row + iRow;
  333. const node = tree.nodes[curRow];
  334. if (!node) continue;
  335. let bPaste = false;
  336. const data = info.sheet.zh_tree.getNodeKeyData(node);
  337. for (let iCol = 0; iCol < info.cellRange.colCount; iCol++) {
  338. const curCol = info.cellRange.col + iCol;
  339. const colSetting = info.sheet.zh_setting.cols[curCol];
  340. const value = trimInvalidChar(pasteData[iRow-filterRow][iCol]);
  341. if (node.children && node.children.length > 0 && invalidFields.parent.indexOf(colSetting.field) >= 0) {
  342. toastMessageUniq(hint.parent);
  343. continue;
  344. }
  345. if (!_.isEmpty(node.b_code) && invalidFields.gcl.indexOf(colSetting.field) >= 0) {
  346. toastMessageUniq(hint.gcl);
  347. continue;
  348. }
  349. if (colSetting.type === 'Number') {
  350. if (colSetting.type === 'Number') {
  351. const num = _.toNumber(value);
  352. if (_.isNaN(num)) {
  353. toastMessageUniq(hint.invalidExpr);
  354. continue;
  355. }
  356. data[colSetting.field] = num;
  357. } else {
  358. data[colSetting.field] = value;
  359. }
  360. } else {
  361. data[colSetting.field] = colSetting.type === 'Number' ? 0 : '';
  362. }
  363. bPaste = true;
  364. }
  365. if (bPaste) {
  366. datas.push(data);
  367. } else {
  368. filterNodes.push(node);
  369. }
  370. }
  371. if (datas.length > 0) {
  372. postData(window.location.pathname + '/update', {postType: 'update', postData: datas}, function (result) {
  373. const refreshNode = tree.loadPostData(result);
  374. if (refreshNode.update) refreshNode.update = refreshNode.update.concat(filterNodes);
  375. budgetTreeOpr.refreshTree(info.sheet, refreshNode);
  376. }, function () {
  377. SpreadJsObj.reLoadRowData(info.sheet, info.cellRange.row, info.cellRange.rowCount);
  378. });
  379. } else {
  380. SpreadJsObj.reLoadRowData(info.sheet, info.cellRange.row, info.cellRange.rowCount);
  381. }
  382. },
  383. pasteBlock: function (sheet, copyInfo) {
  384. const self = this;
  385. const [tree, node] = this.getDefaultSelectInfo(sheet);
  386. postData(window.location.pathname + '/update', {
  387. postType: 'paste-block',
  388. postData: {
  389. id: tree.getNodeKey(node),
  390. bid: copyInfo.bid,
  391. block: copyInfo.block,
  392. }
  393. }, function (data) {
  394. const result = tree.loadPostData(data);
  395. self.refreshTree(sheet, result);
  396. const sel = sheet.getSelections()[0];
  397. if (sel) {
  398. sheet.setSelection(tree.nodes.indexOf(result.create[0]), sel.col, sel.rowCount, sel.colCount);
  399. SpreadJsObj.reloadRowsBackColor(sheet, [sel.row, tree.nodes.indexOf(result.create[0])]);
  400. }
  401. self.refreshOperationValid(sheet);
  402. removeLocalCache(copyBlockTag);
  403. }, null, true);
  404. }
  405. };
  406. budgetSpread.bind(spreadNS.Events.SelectionChanged, budgetTreeOpr.selectionChanged);
  407. if (!readOnly) {
  408. // 增删上下移升降级
  409. $('a[name="base-opr"]').click(function () {
  410. budgetTreeOpr.baseOpr(budgetSheet, this.getAttribute('type'));
  411. });
  412. budgetSpread.bind(spreadNS.Events.EditStarting, budgetTreeOpr.editStarting);
  413. budgetSpread.bind(spreadNS.Events.EditEnded, budgetTreeOpr.editEnded);
  414. budgetSpread.bind(spreadNS.Events.ClipboardPasting, budgetTreeOpr.clipboardPasting);
  415. $.contextMenu({
  416. selector: '#budget-spread',
  417. build: function ($trigger, e) {
  418. const target = SpreadJsObj.safeRightClickSelection($trigger, e, budgetSpread);
  419. return target.hitTestType === spreadNS.SheetArea.viewport || target.hitTestType === spreadNS.SheetArea.rowHeader;
  420. },
  421. items: {
  422. copyBlock: {
  423. name: '复制整块',
  424. icon: 'fa-files-o',
  425. callback: function (key, opt) {
  426. const copyBlockList = [];
  427. const sheet = budgetSheet;
  428. const sel = sheet.getSelections()[0];
  429. let iRow = sel.row;
  430. const pid = sheet.zh_tree.nodes[iRow].tree_pid;
  431. while (iRow < sel.row + sel.rowCount) {
  432. const node = sheet.zh_tree.nodes[iRow];
  433. if (node.tree_pid !== pid) {
  434. toastr.error('仅可同时选中同层节点');
  435. return;
  436. }
  437. const posterity = sheet.zh_tree.getPosterity(node);
  438. iRow += posterity.length + 1;
  439. posterity.unshift(node);
  440. copyBlockList.push(sheet.zh_tree.getDefaultData(posterity));
  441. }
  442. setLocalCache(copyBlockTag, JSON.stringify({ block: copyBlockList }));
  443. },
  444. visible: function (key, opt) {
  445. const select = SpreadJsObj.getSelectObject(budgetSheet);
  446. return !!select;
  447. },
  448. disabled: function (key, opt) {
  449. const select = SpreadJsObj.getSelectObject(budgetSheet);
  450. return !!select && select.level <= 1;
  451. }
  452. },
  453. copyBlockXmj: {
  454. name: '复制整块(只复制项目节)',
  455. icon: 'fa-files-o',
  456. callback: function (key, opt) {
  457. const copyBlockList = [];
  458. const sheet = budgetSheet;
  459. const sel = sheet.getSelections()[0];
  460. let iRow = sel.row;
  461. const pid = sheet.zh_tree.nodes[iRow].ledger_pid;
  462. while (iRow < sel.row + sel.rowCount) {
  463. const node = sheet.zh_tree.nodes[iRow];
  464. if (node.ledger_pid !== pid) {
  465. toastr.error('仅可同时选中同层节点');
  466. return;
  467. }
  468. const posterity = sheet.zh_tree.getPosterity(node);
  469. iRow += posterity.length + 1;
  470. const copyPosterity = posterity.filter(x => { return !x.b_code; });
  471. copyPosterity.unshift(node);
  472. const copyData = sheet.zh_tree.getDefaultData(copyPosterity);
  473. for (const p of copyData) {
  474. const children = copyData.filter(y => {return y.ledger_pid === p.ledger_id}) || [];
  475. p.is_leaf = children.length === 0;
  476. }
  477. copyBlockList.push(copyData);
  478. }
  479. setLocalCache(copyBlockTag, JSON.stringify({ block: copyBlockList }));
  480. },
  481. visible: function (key, opt) {
  482. const select = SpreadJsObj.getSelectObject(budgetSheet);
  483. return needGcl && !!select;
  484. },
  485. disabled: function (key, opt) {
  486. const select = SpreadJsObj.getSelectObject(budgetSheet);
  487. return !!select && select.level <= 1;
  488. }
  489. },
  490. pasteBlock: {
  491. name: '粘贴整块',
  492. icon: 'fa-clipboard',
  493. disabled: function (key, opt) {
  494. const copyInfo = JSON.parse(getLocalCache(copyBlockTag));
  495. return !(copyInfo && copyInfo.block && copyInfo.block.length > 0);
  496. },
  497. callback: function (key, opt) {
  498. const copyInfo = JSON.parse(getLocalCache(copyBlockTag));
  499. if (copyInfo.block.length > 0) {
  500. budgetTreeOpr.pasteBlock(budgetSheet, copyInfo);
  501. } else {
  502. document.execCommand('paste');
  503. }
  504. },
  505. visible: function (key, opt) {
  506. return !readOnly;
  507. }
  508. }
  509. }
  510. });
  511. }
  512. postData(window.location.pathname + '/load', {}, function (result) {
  513. budgetTree.loadDatas(result);
  514. treeCalc.calculateAll(budgetTree);
  515. SpreadJsObj.loadSheetData(budgetSheet, SpreadJsObj.DataType.Tree, budgetTree);
  516. budgetTreeOpr.refreshOperationValid(budgetSheet);
  517. });
  518. const stdLibCellDoubleClick = function (e, info) {
  519. const stdSheet = info.sheet;
  520. if (!stdSheet.zh_setting || !stdSheet.zh_tree || !budgetSheet.zh_tree) return;
  521. const stdTree = stdSheet.zh_tree;
  522. const stdNode = stdTree.nodes[info.row];
  523. if (!stdNode) return;
  524. const budgetTree = budgetSheet.zh_tree;
  525. const sel = budgetSheet.getSelections()[0];
  526. const mainNode = budgetTree.nodes[sel.row];
  527. if (info.sheet.zh_setting.stdType === 'gcl') {
  528. if (mainNode.code && mainNode.code !== '' && !budgetTree.isLeafXmj(mainNode)) {
  529. toastr.warning('非最底层项目下,不应添加清单');
  530. return;
  531. }
  532. }
  533. postData(window.location.pathname + '/update', {
  534. postType: 'add-std',
  535. postData: {
  536. id: budgetTree.getNodeKey(mainNode),
  537. tender_id: mainNode.tender_id,
  538. stdType: info.sheet.zh_setting.stdType,
  539. stdLibId: stdNode.list_id,
  540. stdNode: stdTree.getNodeKey(stdNode)
  541. }
  542. }, function (result) {
  543. const refreshNode = budgetTree.loadPostData(result);
  544. budgetTreeOpr.refreshTree(budgetSheet, refreshNode);
  545. if (refreshNode.create && refreshNode.create.length > 0) {
  546. budgetSheet.setSelection(refreshNode.create[refreshNode.create.length - 1].index, sel.col, sel.rowCount, sel.colCount);
  547. SpreadJsObj.reloadRowsBackColor(budgetSheet, [sel.row, refreshNode.create[refreshNode.create.length - 1].index]);
  548. } else {
  549. const node = _.find(budgetTree.nodes, {code: stdNode.code, name: stdNode.name});
  550. if (node) {
  551. budgetSheet.setSelection(budgetTree.nodes.indexOf(node), sel.col, sel.rowCount, sel.colCount);
  552. SpreadJsObj.reloadRowsBackColor(budgetSheet, [sel.row, budgetTree.nodes.indexOf(node)]);
  553. }
  554. }
  555. budgetTreeOpr.refreshOperationValid(budgetSheet);
  556. budgetSpread.focus();
  557. });
  558. };
  559. const stdXmjSetting = {
  560. selector: '#std-xmj',
  561. stdType: 'xmj',
  562. treeSetting: {
  563. id: 'chapter_id',
  564. pid: 'pid',
  565. order: 'order',
  566. level: 'level',
  567. rootId: -1,
  568. keys: ['id', 'list_id', 'chapter_id'],
  569. },
  570. spreadSetting: {
  571. cols: [
  572. {title: '项目节编号', field: 'code', hAlign: 0, width: 120, formatter: '@', cellType: 'tree'},
  573. {title: '名称', field: 'name', hAlign: 0, width: 150, formatter: '@'},
  574. {title: '单位', field: 'unit', hAlign: 1, width: 50, formatter: '@'}
  575. ],
  576. treeCol: 0,
  577. emptyRows: 0,
  578. headRows: 1,
  579. headRowHeight: [32],
  580. defaultRowHeight: 21,
  581. headerFont: '12px 微软雅黑',
  582. font: '12px 微软雅黑',
  583. headColWidth: [30],
  584. selectedBackColor: '#fffacd',
  585. readOnly: true,
  586. },
  587. cellDoubleClick: !readOnly ? stdLibCellDoubleClick : null,
  588. page: 'ledger',
  589. };
  590. const stdGclSetting = {
  591. selector: '#std-gcl',
  592. stdType: 'gcl',
  593. treeSetting: {
  594. id: 'bill_id',
  595. pid: 'pid',
  596. order: 'order',
  597. level: 'level',
  598. rootId: -1,
  599. keys: ['id', 'list_id', 'bill_id']
  600. },
  601. spreadSetting: {
  602. cols: [
  603. {title: '清单编号', field: 'b_code', hAlign: 0, width: 120, formatter: '@', cellType: 'tree'},
  604. {title: '名称', field: 'name', hAlign: 0, width: 150, formatter: '@'},
  605. {title: '单位', field: 'unit', hAlign: 1, width: 50, formatter: '@'}
  606. ],
  607. treeCol: 0,
  608. emptyRows: 0,
  609. headRows: 1,
  610. headRowHeight: [32],
  611. defaultRowHeight: 21,
  612. headerFont: '12px 微软雅黑',
  613. font: '12px 微软雅黑',
  614. headColWidth: [30],
  615. selectedBackColor: '#fffacd',
  616. readOnly: true,
  617. },
  618. cellDoubleClick: !readOnly ? stdLibCellDoubleClick : null,
  619. };
  620. // 展开收起标准清单
  621. $('a', '.side-menu').bind('click', function (e) {
  622. e.preventDefault();
  623. const tab = $(this), tabPanel = $(tab.attr('content'));
  624. // 展开工具栏、切换标签
  625. if (!tab.hasClass('active')) {
  626. $('a', '.side-menu').removeClass('active');
  627. $('.tab-content .tab-select-show.tab-pane.active').removeClass('active');
  628. tab.addClass('active');
  629. tabPanel.addClass('active');
  630. showSideTools(tab.hasClass('active'));
  631. if (tab.attr('content') === '#std-xmj') {
  632. if (!stdXmj) stdXmj = new stdLib(stdXmjSetting);
  633. stdXmj.spread.refresh();
  634. } else if (tab.attr('content') === '#std-gcl') {
  635. if (!stdGcl) stdGcl = new stdLib(stdGclSetting);
  636. stdGcl.spread.refresh();
  637. } else if (tab.attr('content') === '#search') {
  638. if (!searchBudget) {
  639. const searchSetting = {
  640. selector: '#search',
  641. searchSpread: budgetSpread,
  642. resultSpreadSetting: {
  643. cols: [
  644. {title: '项目节编号', field: 'code', hAlign: 0, width: 120, formatter: '@'},
  645. {title: '清单编号', field: 'b_code', hAlign: 0, width: 80, formatter: '@'},
  646. {title: '名称', field: 'name', width: 150, hAlign: 0, formatter: '@'},
  647. {title: '单位', field: 'unit', width: 50, hAlign: 1, formatter: '@'},
  648. ],
  649. emptyRows: 0,
  650. headRows: 1,
  651. headRowHeight: [32],
  652. headColWidth: [30],
  653. defaultRowHeight: 21,
  654. headerFont: '12px 微软雅黑',
  655. font: '12px 微软雅黑',
  656. selectedBackColor: '#fffacd',
  657. readOnly: true,
  658. },
  659. };
  660. if (!needGcl) {
  661. searchSetting.resultSpreadSetting.cols = searchSetting.resultSpreadSetting.cols.filter(x => {
  662. return ['b_code', 'quantity', 'unit_price'].indexOf(x.field) < 0;
  663. });
  664. searchSetting.searchRangeStr = '项目节编号/名称';
  665. } else {
  666. searchSetting.searchRangeStr = '项目节编号/清单编号/名称';
  667. }
  668. searchBudget = $.billsSearch(searchSetting);
  669. }
  670. searchBudget.spread.refresh();
  671. }
  672. } else { // 收起工具栏
  673. tab.removeClass('active');
  674. tabPanel.removeClass('active');
  675. showSideTools(tab.hasClass('active'));
  676. }
  677. budgetSpread.refresh();
  678. });
  679. // 显示层次
  680. (function (select, sheet) {
  681. $(select).click(function () {
  682. if (!sheet.zh_tree) return;
  683. const tag = $(this).attr('tag');
  684. const tree = sheet.zh_tree;
  685. setTimeout(() => {
  686. showWaitingView();
  687. switch (tag) {
  688. case "1":
  689. case "2":
  690. case "3":
  691. case "4":
  692. case "5":
  693. tree.expandByLevel(parseInt(tag));
  694. SpreadJsObj.refreshTreeRowVisible(sheet);
  695. break;
  696. case "last":
  697. tree.expandByCustom(() => { return true; });
  698. SpreadJsObj.refreshTreeRowVisible(sheet);
  699. break;
  700. case "leafXmj":
  701. tree.expandToLeafXmj();
  702. SpreadJsObj.refreshTreeRowVisible(sheet);
  703. break;
  704. }
  705. closeWaitingView();
  706. }, 100);
  707. });
  708. })('a[name=showLevel]', budgetSheet);
  709. // 导入
  710. $('#budget-import').click(() => {
  711. importExcel.doImport({
  712. template: {
  713. hint: '导入Excel',
  714. url: '/template/导入分项清单EXCEL格式.xlsx',
  715. },
  716. filter: needGcl,
  717. callback: function (sheet, filter) {
  718. postDataCompress(window.location.pathname + '/upload-excel/tz', {sheet, filter}, function (result) {
  719. budgetTree.loadDatas(result);
  720. treeCalc.calculateAll(budgetTree);
  721. SpreadJsObj.reLoadSheetData(budgetSheet);
  722. checkShowLast(result.length);
  723. }, null);
  724. },
  725. });
  726. })
  727. });