budget_detail.js 36 KB

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