revise.js 31 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712
  1. 'use strict';
  2. /**
  3. * 台账修订页面js
  4. *
  5. * @author Mai
  6. * @date
  7. * @version
  8. */
  9. const ckBillsSpread = window.location.pathname + '-billsSelect';
  10. $(document).ready(() => {
  11. autoFlashHeight();
  12. // 初始化spread
  13. const billsSpread = SpreadJsObj.createNewSpread($('#bills-spread')[0]);
  14. const billsSheet = billsSpread.getActiveSheet();
  15. SpreadJsObj.initSheet(billsSheet, billsSpreadSetting);
  16. const posSpread = SpreadJsObj.createNewSpread($('#pos-spread')[0]);
  17. const posSheet = posSpread.getActiveSheet();
  18. SpreadJsObj.initSheet(posSheet, posSpreadSetting);
  19. // 初始化 清单树结构
  20. const treeSetting = {
  21. id: 'ledger_id',
  22. pid: 'ledger_pid',
  23. order: 'order',
  24. level: 'level',
  25. rootId: -1,
  26. keys: ['id', 'tender_id', 'ledger_id'],
  27. calcFields: ['sgfh_tp', 'sjcl_tp', 'qtcl_tp', 'total_price'],
  28. };
  29. if (!isTz) {
  30. treeSetting.calcFields.push('deal_tp');
  31. }
  32. treeSetting.calcFun = function (node) {
  33. node.dgn_price = ZhCalc.round(ZhCalc.div(node.total_price, node.dgn_qty1), 2);
  34. };
  35. const billsTree = createNewPathTree('ledger', treeSetting);
  36. billsTree.loadDatas(billsData);
  37. treeCalc.calculateAll(billsTree);
  38. // 加载至spread
  39. SpreadJsObj.loadSheetData(billsSheet, SpreadJsObj.DataType.Tree, billsTree);
  40. SpreadJsObj.loadTopAndSelect(billsSheet, ckBillsSpread);
  41. // 初始化 部位明细
  42. const pos = new PosData({ id: 'id', ledgerId: 'lid' });
  43. pos.loadDatas(posData);
  44. const billsTreeSpreadObj = {
  45. /**
  46. * 刷新顶部按钮是否可用
  47. * @param sheet
  48. * @param selections
  49. */
  50. refreshOperationValid: function (sheet) {
  51. const setObjEnable = function (obj, enable) {
  52. if (enable) {
  53. obj.removeClass('disabled');
  54. } else {
  55. obj.addClass('disabled');
  56. }
  57. };
  58. const tree = sheet.zh_tree;
  59. const node = SpreadJsObj.getSelectObject(sheet);
  60. const preNode = tree.getPreSiblingNode(node);
  61. const valid = !sheet.zh_setting.readOnly;
  62. setObjEnable($('a[type="add"]'), valid);
  63. setObjEnable($('a[type="delete"]'), valid && node);
  64. setObjEnable($('a[type="up-move"]'), valid && node && preNode);
  65. setObjEnable($('a[type="down-move"]'), valid && node && !tree.isLastSibling(node));
  66. if (isTz) {
  67. const posRange = node ? pos.getLedgerPos(node.id) : [];
  68. setObjEnable($('a[type="up-level"]'), valid && node && tree.getParent(node) && node.level > 2 && (!posRange || posRange.length === 0));
  69. const preNodePosRange = preNode ? pos.getLedgerPos(preNode.id) : [];
  70. setObjEnable($('a[type="down-level"]'), valid && node && preNode && (!preNodePosRange || preNodePosRange.length === 0));
  71. } else {
  72. setObjEnable($('#up-level'), valid && node && tree.getParent(node));
  73. setObjEnable($('#down-level'), valid && node && preNode);
  74. }
  75. setObjEnable($('#cut'), valid);
  76. setObjEnable($('#paste'), valid);
  77. },
  78. /**
  79. *
  80. * @param sheet
  81. * @param data
  82. */
  83. refreshTree: function (sheet, data) {
  84. SpreadJsObj.massOperationSheet(sheet, function () {
  85. const tree = sheet.zh_tree;
  86. // 处理删除
  87. if (data.delete) {
  88. for (const d of data.delete) {
  89. sheet.deleteRows(tree.nodes.indexOf(d), 1);
  90. }
  91. }
  92. // 处理新增
  93. if (data.create) {
  94. const newNodes = data.create;
  95. if (newNodes) {
  96. newNodes.sort(function (a, b) {
  97. return a.index - b.index;
  98. });
  99. for (const node of newNodes) {
  100. sheet.addRows(node.index, 1);
  101. SpreadJsObj.reLoadRowData(sheet, tree.nodes.indexOf(node), 1);
  102. }
  103. }
  104. }
  105. // 处理更新
  106. if (data.update) {
  107. const rows = [];
  108. for (const u of data.update) {
  109. rows.push(tree.nodes.indexOf(u));
  110. }
  111. SpreadJsObj.reLoadRowsData(sheet, rows);
  112. }
  113. // 处理展开
  114. if (data.expand) {
  115. const expanded = [];
  116. for (const e of data.expand) {
  117. if (expanded.indexOf(e) === -1) {
  118. const posterity = tree.getPosterity(e);
  119. for (const p of posterity) {
  120. sheet.setRowVisible(tree.nodes.indexOf(p), p.visible);
  121. expanded.push(p);
  122. }
  123. }
  124. }
  125. }
  126. });
  127. },
  128. selectionChanged: function (e, info) {
  129. if (info.newSelections[0].row !== info.oldSelections[0].row) {
  130. billsTreeSpreadObj.refreshOperationValid(info.sheet);
  131. posSpreadObj.loadCurPosData();
  132. //posSearch.search($('#pos-keyword').val());
  133. }
  134. SpreadJsObj.saveTopAndSelect(info.sheet, ckBillsSpread);
  135. },
  136. /**
  137. * 新增节点
  138. * @param spread
  139. */
  140. baseOpr: function (sheet, type) {
  141. const self = this;
  142. const tree = sheet.zh_tree;
  143. const node = SpreadJsObj.getSelectObject(sheet);
  144. if (!tree || !node) return;
  145. postData(window.location.pathname + '/base-opr', {id: node.ledger_id, postType: type}, function (result) {
  146. const refreshData = tree.loadPostData(result);
  147. self.refreshTree(sheet, refreshData);
  148. if (['up-move', 'down-move', 'up-level', 'down-level'].indexOf(type) > -1) {
  149. const sel = sheet.getSelections()[0];
  150. if (sel) {
  151. sheet.setSelection(tree.nodes.indexOf(node), sel.col, sel.rowCount, sel.colCount);
  152. }
  153. }
  154. self.refreshOperationValid(sheet);
  155. });
  156. },
  157. /**
  158. * 编辑单元格响应事件
  159. * @param {Object} e
  160. * @param {Object} info
  161. */
  162. editEnded: function (e, info) {
  163. if (info.sheet.zh_setting) {
  164. const col = info.sheet.zh_setting.cols[info.col];
  165. const sortData = info.sheet.zh_dataType === 'tree' ? info.sheet.zh_tree.nodes : info.sheet.zh_data;
  166. const node = sortData[info.row];
  167. const data = {
  168. id: node.id,
  169. tender_id: node.tender_id,
  170. ledger_id: node.ledger_id
  171. };
  172. // 未改变值则不提交
  173. const orgValue = node[col.field];
  174. if (orgValue == info.editingText || ((!orgValue || orgValue === '') && (info.editingText === ''))) {
  175. return;
  176. }
  177. // 台账模式,检查部位明细相关
  178. if (checkTzMeasureType()) {
  179. if (col.field === 'sgfh_qty' || col.field === 'sgfh_tp' ||
  180. col.field === 'sjcl_qty' || col.field === 'sjcl_tp' ||
  181. col.field === 'qtcl_qty' || col.field === 'qtcl_tp') {
  182. if (!node.children || node.children.length ===0) {
  183. const lPos = pos.getLedgerPos(node.id);
  184. if (lPos && lPos.length > 0) {
  185. toast('清单含有部位明细,不可修改施工图复核数量', 'error');
  186. SpreadJsObj.reLoadRowData(info.sheet, info.row);
  187. return;
  188. }
  189. }
  190. }
  191. if (col.field === 'b_code' && (info.editingText === '' || !info.editingText)) {
  192. const lPos = pos.getLedgerPos(node.id);
  193. if (lPos && lPos.length > 0) {
  194. toast('清单含有部位明细,请先删除部位明细,再删除清单编号', 'error');
  195. SpreadJsObj.reLoadRowData(info.sheet, info.row);
  196. return;
  197. }
  198. }
  199. }
  200. // 获取更新数据
  201. if (info.editingText) {
  202. data[col.field] = col.type === 'Number' ? parseFloat(info.editingText) : info.editingText.replace('\n', '');
  203. } else {
  204. data[col.field] = null;
  205. }
  206. // 更新至服务器
  207. info.sheet.zh_tree.update('/tender/' + getTenderId() + '/ledger/update', data, function (result) {
  208. treeOperationObj.refreshTree(info.sheet, result);
  209. });
  210. }
  211. },
  212. topRowChanged: function (e, info) {
  213. SpreadJsObj.saveTopAndSelect(info.sheet, ckBillsSpread);
  214. },
  215. };
  216. billsTreeSpreadObj.refreshOperationValid(billsSheet);
  217. billsSpread.bind(spreadNS.Events.SelectionChanged, billsTreeSpreadObj.selectionChanged);
  218. billsSpread.bind(spreadNS.Events.topRowChanged, billsTreeSpreadObj.topRowChanged);
  219. if (!readOnly) {
  220. // 增删上下移升降级
  221. $('a[name="base-opr"]').click(function () {
  222. billsTreeSpreadObj.baseOpr(billsSheet, this.getAttribute('type'));
  223. });
  224. let batchInsertObj;
  225. // 右键菜单
  226. $.contextMenu({
  227. selector: '#bills-spread',
  228. build: function ($trigger, e) {
  229. const target = SpreadJsObj.safeRightClickSelection($trigger, e, billsSpread);
  230. return target.hitTestType === spreadNS.SheetArea.viewport || target.hitTestType === spreadNS.SheetArea.rowHeader;
  231. },
  232. items: {
  233. 'batchInsertBillsPos': {
  234. name: '批量插入清单-部位',
  235. icon: 'fa-sign-in',
  236. disabled: function (key, opt) {
  237. const select = SpreadJsObj.getSelectObject(billsSheet);
  238. if (select) {
  239. if (select.code && select.code !== '') {
  240. return !billsTree.isLeafXmj(select);
  241. } else {
  242. const parent = billsTree.getParent(select);
  243. return !(parent && billsTree.isLeafXmj(parent));
  244. }
  245. } else {
  246. return false;
  247. }
  248. },
  249. callback: function (key, opt) {
  250. if (!batchInsertObj) {
  251. batchInsertObj = new BatchInsertBillsPosObj($('#batch'));
  252. } else {
  253. batchInsertObj.initView();
  254. }
  255. $('#batch').modal('show');
  256. }
  257. },
  258. }
  259. });
  260. }
  261. const posSpreadObj = {
  262. /**
  263. * 加载部位明细 根据当前台账选择节点
  264. */
  265. loadCurPosData: function () {
  266. const node = SpreadJsObj.getSelectObject(billsSheet);
  267. if (node) {
  268. const posData = pos.getLedgerPos(node.id) || [];
  269. SpreadJsObj.loadSheetData(posSpread.getActiveSheet(), 'data', posData);
  270. } else {
  271. SpreadJsObj.loadSheetData(posSpread.getActiveSheet(), 'data', []);
  272. }
  273. },
  274. editStarting: function (e, info) {
  275. posSpreadObj.ledgerTreeNode = SpreadJsObj.getSelectObject(billsSheet);
  276. },
  277. };
  278. posSpreadObj.loadCurPosData();
  279. $.divResizer({
  280. select: '#revise-resize',
  281. callback: function () {
  282. billsSpread.refresh();
  283. let bcontent = $(".bcontent-wrap") ? $(".bcontent-wrap").height() : 0;
  284. $(".sp-wrap").height(bcontent-40);
  285. posSpread.refresh();
  286. }
  287. });
  288. class stdLib {
  289. constructor(obj, stdType, treeSetting, spreadSetting) {
  290. this.obj = obj;
  291. this.url = '/std/' + stdType;
  292. this.treeSetting = treeSetting;
  293. treeSetting.preUrl = this.url;
  294. this.spreadSetting = spreadSetting;
  295. this.spread = SpreadJsObj.createNewSpread(this.obj);
  296. SpreadJsObj.initSheet(this.spread.getActiveSheet(), this.spreadSetting);
  297. this.spread.getActiveSheet().bind(GC.Spread.Sheets.Events.CellDoubleClick, function (e, info) {
  298. const stdSheet = info.sheet;
  299. const mainSheet = ledgerSpread.getActiveSheet();
  300. if (!stdSheet.zh_setting || !stdSheet.zh_tree || !mainSheet.zh_tree) { return; }
  301. const stdTree = stdSheet.zh_tree;
  302. const stdNode = stdTree.nodes[info.row];
  303. const mainTree = mainSheet.zh_tree;
  304. const sel = mainSheet.getSelections()[0];
  305. const mainNode = mainTree.nodes[sel.row];
  306. if (!stdNode) { return; }
  307. mainTree.postData('/tender/' + getTenderId() + '/ledger/add-by-std', mainNode, {
  308. tender_id: mainNode.tender_id,
  309. stdType: stdType,
  310. stdLibId: stdNode.list_id,
  311. stdNode: stdTree.getNodeKey(stdNode)
  312. }, function (result) {
  313. treeOperationObj.refreshTree(mainSheet, result);
  314. treeOperationObj.refreshOperationValid(mainSheet);
  315. });
  316. });
  317. this.pathTree = createNewPathTree('base', this.treeSetting);
  318. }
  319. loadLib (listId) {
  320. const self = this;
  321. postData(this.url+'/get-data', {list_id: listId}, function (data) {
  322. self.pathTree.loadDatas(data);
  323. SpreadJsObj.loadSheetData(self.spread.getActiveSheet(), 'tree', self.pathTree);
  324. });
  325. }
  326. }
  327. class DealBills {
  328. constructor (selector, spreadSetting) {
  329. const self = this;
  330. this.loaded = false;
  331. this.obj = $(selector)[0];
  332. this.url = '/tender/' + window.location.pathname.split('/')[2] + '/deal';
  333. this.spreadSetting = spreadSetting;
  334. this.spread = SpreadJsObj.createNewSpread(this.obj);
  335. SpreadJsObj.initSheet(this.spread.getActiveSheet(), this.spreadSetting);
  336. this.spread.bind(spreadNS.Events.CellDoubleClick, function (e, info) {
  337. const dealSheet = info.sheet;
  338. const mainSheet = ledgerSpread.getActiveSheet();
  339. const dealBills = SpreadJsObj.getSelectObject(dealSheet);
  340. if (!dealBills) { return; }
  341. const mainTree = mainSheet.zh_tree;
  342. const mainNode = SpreadJsObj.getSelectObject(mainSheet);
  343. if (!mainNode || !mainTree) { return; }
  344. if (mainNode.code && mainNode.code !== '' && !mainTree.isLeafXmj(mainNode)) {
  345. toast('非最底层项目下,不应添加清单', 'error');
  346. return;
  347. }
  348. postData('/tender/' + getTenderId() + '/ledger/add-by-deal', {
  349. id: mainNode.ledger_id,
  350. type: mainNode.code ? 'child' : 'next',
  351. dealBills: {
  352. b_code: dealBills.code, name: dealBills.name, unit: dealBills.unit,
  353. unit_price: dealBills.unit_price,
  354. },
  355. }, function (result) {
  356. const refreshData = mainTree.loadPostData(result);
  357. treeOperationObj.refreshTree(mainSheet, refreshData);
  358. treeOperationObj.refreshOperationValid(mainSheet);
  359. });
  360. });
  361. SpreadJsObj.forbiddenSpreadContextMenu(selector, this.spread);
  362. }
  363. loadData () {
  364. if (this.loaded) return;
  365. const self = this;
  366. postData(this.url+'/get-data', {}, function (data) {
  367. self.data = data;
  368. //self.calculateData();
  369. SpreadJsObj.loadSheetData(self.spread.getActiveSheet(), 'data', data);
  370. self.loaded = true;
  371. });
  372. }
  373. calculateData () {
  374. if (this.data) {
  375. for (const d of this.data) {
  376. d.total_price = _.multiply(d.quantity, d.unit_price);
  377. }
  378. }
  379. }
  380. }
  381. class BatchInsertBillsPosObj {
  382. constructor (obj) {
  383. const self = this;
  384. this.obj = obj;
  385. this.billsCount = 6;
  386. this.posCount = 1000;
  387. // 初始化 清单编号窗口 参数
  388. this.qdSpreadSetting = {
  389. cols: [
  390. {title: '编号', field: 'code', hAlign: 0, width: 80, formatter: '@'},
  391. {title: '名称', field: 'name', hAlign: 0, width: 120, formatter: '@'},
  392. {title: '单位', field: 'unit', hAlign: 1, width: 50, formatter: '@'},
  393. {title: '单价', field: 'unit_price', hAlign: 2, width: 50},
  394. {title: '图册号', field: 'name', hAlign: 0, width: 60, formatter: '@'},
  395. ],
  396. emptyRows: this.billsCount,
  397. headRows: 1,
  398. headRowHeight: [40],
  399. };
  400. this.qdSpread = SpreadJsObj.createNewSpread($('.batch-l-t', this.obj)[0]);
  401. // 初始化 部位数量复核表 参数
  402. this.posSpreadSetting = {
  403. cols: [
  404. {title: '部位', field: 'bw', hAlign: 0, width: 80, formatter: '@'},
  405. {title: '图册号', field: 'drawingCode', hAlign: 0, formatter: '@', width: 60},
  406. ],
  407. emptyRows: this.posCount,
  408. headRows: 1,
  409. headRowHeight: [40],
  410. };
  411. for (let iNum = 1; iNum <= this.billsCount; iNum++) {
  412. this.posSpreadSetting.cols.push(
  413. {title: '清单' + iNum, field: 'bills' + iNum, hAlign: 2, width: 50}
  414. )
  415. }
  416. this.posSpread = SpreadJsObj.createNewSpread($('.batch-l-b', this.obj)[0]);
  417. // 初始化 签约清单 参数
  418. this.dealSpreadSetting = {
  419. cols: [
  420. {title: '清单编号', field: 'code', width: 80, formatter: '@', readOnly: true},
  421. {title: '名称', field: 'name', width: 120, formatter: '@', readOnly: true},
  422. {title: '单位', field: 'unit', width: 50, formatter: '@', readOnly: true},
  423. {title: '单价', field: 'unit_price', width: 50, readOnly: true},
  424. ],
  425. emptyRows: 0,
  426. headRows: 1,
  427. headRowHeight: [40],
  428. };
  429. this.dealSpread = SpreadJsObj.createNewSpread($('.batch-r', this.obj)[0]);
  430. // 初始化 清单编号、部位数量复核表 表格
  431. this.initView();
  432. SpreadJsObj.initSheet(this.dealSpread.getActiveSheet(), this.dealSpreadSetting);
  433. SpreadJsObj.refreshColumnAlign(this.dealSpread.getActiveSheet());
  434. // 拉取签约清单数据
  435. dealBills.loadData();
  436. SpreadJsObj.loadSheetData(this.dealSpread.getActiveSheet(), 'data', dealBills.data);
  437. // 双击签约清单,自动添加到清单编号窗口
  438. this.dealSpread.bind(GC.Spread.Sheets.Events.CellDoubleClick, function (e, info) {
  439. const deal = info.sheet.zh_data[info.row];
  440. const qdSheet = self.qdSpread.getActiveSheet(), posSheet = self.posSpread.getActiveSheet();
  441. const sel = qdSheet.getSelections()[0];
  442. qdSheet.getCell(sel.row, 0).value(deal.code);
  443. qdSheet.getCell(sel.row, 1).value(deal.name);
  444. qdSheet.getCell(sel.row, 2).value(deal.unit);
  445. qdSheet.getCell(sel.row, 3).value(deal.unit_price);
  446. if (sel.row + 1 === qdSheet.getRowCount()) {
  447. const count = sel.row + 2;
  448. qdSheet.setRowCount(count);
  449. qdSheet.getCell(sel.row + 1, 0, GC.Spread.Sheets.SheetArea.rowHeader).text('清单' + count);
  450. const colCount = posSheet.getColumnCount() + 1
  451. posSheet.setColumnCount(colCount);
  452. posSheet.getCell(0, colCount - 1, GC.Spread.Sheets.SheetArea.colHeader).text('数量' + count);
  453. }
  454. qdSheet.setSelection(sel.row + 1, sel.col, 1, 1);
  455. });
  456. this.obj.bind('shown.bs.modal', function () {
  457. self.qdSpread.refresh();
  458. self.posSpread.refresh();
  459. self.dealSpread.refresh();
  460. });
  461. $('#batch-ok').click(function () {
  462. const selection = billsSheet.getSelections();
  463. const row = selection[0].row;
  464. const select = billsTree.nodes[row];
  465. if (select) {
  466. const insertData = {};
  467. insertData.batchType = (select.code && select.code !== '') ? 'child' : 'next';
  468. insertData.id = select[billsTree.setting.id];
  469. insertData.batchData = self.getBatchData();
  470. postData(window.location.pathname + '/batch-insert', insertData, function (data) {
  471. pos.updateDatas(data.pos);
  472. const result = billsTree.loadPostData(data.ledger);
  473. billsTreeSpreadObj.refreshTree(billsSheet, result);
  474. billsTreeSpreadObj.refreshOperationValid(billsSheet, selection);
  475. self.obj.modal('hide');
  476. });
  477. }
  478. });
  479. }
  480. // 初始化左侧表格
  481. initView () {
  482. // 初始化 清单编号
  483. const qdSheet = this.qdSpread.getActiveSheet();
  484. SpreadJsObj.initSheet(qdSheet, this.qdSpreadSetting);
  485. SpreadJsObj.refreshColumnAlign(qdSheet);
  486. // 清理原有数据
  487. SpreadJsObj.beginMassOperation(qdSheet);
  488. qdSheet.clear(0, 0, qdSheet.getRowCount(), qdSheet.getColumnCount(), GC.Spread.Sheets.SheetArea.viewport, GC.Spread.Sheets.StorageType.data);
  489. for (let iRow = 1; iRow <= this.billsCount; iRow++) {
  490. qdSheet.getCell(iRow - 1, 0, GC.Spread.Sheets.SheetArea.rowHeader).text('清单' + iRow);
  491. }
  492. qdSheet.setSelection(0, 0, 1 ,1);
  493. SpreadJsObj.endMassOperation(qdSheet);
  494. // 初始化 部位数量复核表
  495. const posSheet = this.posSpread.getActiveSheet();
  496. SpreadJsObj.initSheet(posSheet, this.posSpreadSetting);
  497. SpreadJsObj.refreshColumnAlign(posSheet);
  498. // 清理原有数据
  499. SpreadJsObj.beginMassOperation(posSheet);
  500. posSheet.setColumnWidth(0, 45, GC.Spread.Sheets.SheetArea.rowHeader);
  501. posSheet.clear(0, 0, posSheet.getRowCount(), posSheet.getColumnCount(), GC.Spread.Sheets.SheetArea.viewport, GC.Spread.Sheets.StorageType.data);
  502. posSheet.setSelection(0, 0, 1 ,1);
  503. SpreadJsObj.endMassOperation(posSheet);
  504. // 检查签约清单数据,以工具栏数据为准
  505. if (dealBills) {
  506. SpreadJsObj.loadSheetData(this.dealSpread.getActiveSheet(), 'data', dealBills.data);
  507. }
  508. this.dealSpread.getActiveSheet().setSelection(0, 0, 1, 1);
  509. }
  510. // 获取界面数据
  511. getBatchData () {
  512. const result = [];
  513. const qdSheet = this.qdSpread.getActiveSheet(), posSheet = this.posSpread.getActiveSheet();
  514. for (let iRow = 0; iRow < qdSheet.getRowCount(); iRow++) {
  515. if (qdSheet.getText(iRow, 0) === '') { continue; }
  516. const qd = {
  517. b_code: qdSheet.getText(iRow, 0),
  518. name: qdSheet.getText(iRow, 1),
  519. unit: qdSheet.getText(iRow, 2),
  520. price: _.toNumber(qdSheet.getText(iRow, 3)),
  521. pos: [],
  522. };
  523. result.push(qd);
  524. for (let iPosRow = 0; iPosRow < posSheet.getRowCount(); iPosRow++) {
  525. const value = _.toNumber(posSheet.getText(iPosRow, iRow + 2));
  526. if (value !== 0 && !isNaN(value)) {
  527. qd.pos.push({
  528. name: posSheet.getText(iPosRow, 0),
  529. drawing_code: posSheet.getText(iPosRow, 1),
  530. quantity: value,
  531. });
  532. }
  533. }
  534. }
  535. return result;
  536. }
  537. }
  538. let stdChapter, stdBills;
  539. const dealBills = new DealBills('#deal-bills-spread', {
  540. cols: [
  541. {title: '清单编号', field: 'code', hAlign: 0, width: 120, formatter: '@', readOnly: true},
  542. {title: '名称', field: 'name', hAlign: 0, width: 230, formatter: '@', readOnly: true},
  543. {title: '单位', field: 'unit', hAlign: 1, width: 50, formatter: '@', readOnly: true},
  544. {title: '单价', field: 'unit_price', hAlign: 2, width: 50, readOnly: true},
  545. {title: '数量', field: 'quantity', hAlign: 2, width: 50, readOnly: true},
  546. {title: '金额', field: 'total_price', hAlign: 2, width: 50, readOnly: true},
  547. ],
  548. emptyRows: 0,
  549. headRows: 1,
  550. headRowHeight: [40],
  551. defaultRowHeight: 21,
  552. });
  553. $.divResizer({
  554. select: '#revise-right-spr',
  555. callback: function () {
  556. billsSpread.refresh();
  557. if (posSpread) {
  558. posSpread.refresh();
  559. }
  560. if (stdChapter) {
  561. stdChapter.spread.refresh();
  562. }
  563. if (stdBills) {
  564. stdBills.spread.refresh();
  565. }
  566. }
  567. });
  568. // 展开收起标准清单
  569. $('a', '#side-menu').bind('click', function (e) {
  570. e.preventDefault();
  571. const tab = $(this), tabPanel = $(tab.attr('content'));
  572. const showSideTools = function (show) {
  573. const left = $('#left-view'), right = $('#right-view'), parent = left.parent();
  574. if (show) {
  575. right.show();
  576. autoFlashHeight();
  577. /**
  578. * right.show()后, parent被撑开成2倍left.height, 导致parent.width减少了10px
  579. * 第一次left.width调整后,parent的缩回left.height, 此时parent.width又增加了10px
  580. * 故需要通过最终的parent.width再计算一次left.width
  581. *
  582. * Q: 为什么不通过先计算left.width的宽度,以避免计算两次left.width?
  583. * A: 右侧工具栏不一定显示,当右侧工具栏显示过一次后,就必须使用parent和right来计算left.width
  584. *
  585. */
  586. //left.css('width', parent.width() - right.outerWidth());
  587. //left.css('width', parent.width() - right.outerWidth());
  588. const percent = 100 - right.outerWidth() /parent.width() * 100;
  589. left.css('width', percent + '%');
  590. } else {
  591. left.width(parent.width());
  592. right.hide();
  593. }
  594. };
  595. // 展开工具栏、切换标签
  596. if (!tab.hasClass('active')) {
  597. const close = $('.active', '#side-menu').length === 0;
  598. $('a', '#side-menu').removeClass('active');
  599. tab.addClass('active');
  600. $('.tab-content .tab-pane').removeClass('active');
  601. tabPanel.addClass('active');
  602. showSideTools(tab.hasClass('active'));
  603. if (tab.attr('content') === '#std-chapter') {
  604. if (!stdChapter) {
  605. stdChapter = new stdLib($('#std-chapter-spread')[0], 'chapter', {
  606. id: 'chapter_id',
  607. pid: 'pid',
  608. order: 'order',
  609. level: 'level',
  610. rootId: -1,
  611. keys: ['id', 'list_id', 'chapter_id'],
  612. }, {
  613. cols: [
  614. {title: '项目节编号', field: 'code', hAlign: 0, width: 120, formatter: '@', readOnly: true, cellType: 'tree'},
  615. {title: '名称', field: 'name', hAlign: 0, width: 230, formatter: '@', readOnly: true},
  616. {title: '单位', field: 'unit', hAlign: 1, width: 50, formatter: '@', readOnly: true}
  617. ],
  618. treeCol: 0,
  619. emptyRows: 0,
  620. headRows: 1,
  621. headRowHeight: [40],
  622. defaultRowHeight: 21,
  623. });
  624. stdChapter.loadLib(1);
  625. }
  626. stdChapter.spread.refresh();
  627. } else if (tab.attr('content') === '#std-bills') {
  628. if (!stdBills) {
  629. stdBills = new stdLib($('#std-bills-spread')[0], 'bills', {
  630. id: 'bill_id',
  631. pid: 'pid',
  632. order: 'order',
  633. level: 'level',
  634. rootId: -1,
  635. keys: ['id', 'list_id', 'bill_id']
  636. }, {
  637. cols: [
  638. {title: '清单编号', field: 'code', hAlign: 0, width: 120, formatter: '@', readOnly: true, cellType: 'tree'},
  639. {title: '名称', field: 'name', hAlign: 0, width: 230, formatter: '@', readOnly: true},
  640. {title: '单位', field: 'unit', hAlign: 1, width: 50, formatter: '@', readOnly: true}
  641. ],
  642. treeCol: 0,
  643. emptyRows: 0,
  644. headRows: 1,
  645. headRowHeight: [40],
  646. defaultRowHeight: 21,
  647. });
  648. stdBills.loadLib(1);
  649. }
  650. stdBills.spread.refresh();
  651. } else if (tab.attr('content') === '#deal-bills') {
  652. dealBills.loadData();
  653. dealBills.spread.refresh();
  654. }
  655. }
  656. billsSpread.refresh();
  657. if (posSpread) {
  658. posSpread.refresh();
  659. }
  660. });
  661. // 修订详情 保存
  662. $('#save').click(function () {
  663. const content = $('textarea').val();
  664. postData('save', { content: content });
  665. });
  666. // 显示层次
  667. (function (select, sheet) {
  668. if (!sheet.zh_tree) return;
  669. $(select).click(function () {
  670. const tag = $(this).attr('tag');
  671. const tree = sheet.zh_tree;
  672. switch (tag) {
  673. case "1":
  674. case "2":
  675. case "3":
  676. case "4":
  677. case "5":
  678. tree.expandByLevel(parseInt(tag));
  679. SpreadJsObj.refreshTreeRowVisible(sheet);
  680. break;
  681. case "last":
  682. tree.expandByCustom(() => { return true; });
  683. SpreadJsObj.refreshTreeRowVisible(sheet);
  684. break;
  685. case "leafXmj":
  686. tree.expandToLeafXmj();
  687. SpreadJsObj.refreshTreeRowVisible(sheet);
  688. break;
  689. }
  690. });
  691. })('a[name=showLevel]', billsSheet);
  692. });