revise.js 31 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713
  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(posSheet, 'data', posData);
  270. } else {
  271. SpreadJsObj.loadSheetData(posSheet, 'data', []);
  272. }
  273. SpreadJsObj.resetFieldReadOnly(posSheet);
  274. },
  275. editStarting: function (e, info) {
  276. posSpreadObj.ledgerTreeNode = SpreadJsObj.getSelectObject(billsSheet);
  277. },
  278. };
  279. posSpreadObj.loadCurPosData();
  280. $.divResizer({
  281. select: '#revise-resize',
  282. callback: function () {
  283. billsSpread.refresh();
  284. let bcontent = $(".bcontent-wrap") ? $(".bcontent-wrap").height() : 0;
  285. $(".sp-wrap").height(bcontent-40);
  286. posSpread.refresh();
  287. }
  288. });
  289. class stdLib {
  290. constructor(obj, stdType, treeSetting, spreadSetting) {
  291. this.obj = obj;
  292. this.url = '/std/' + stdType;
  293. this.treeSetting = treeSetting;
  294. treeSetting.preUrl = this.url;
  295. this.spreadSetting = spreadSetting;
  296. this.spread = SpreadJsObj.createNewSpread(this.obj);
  297. SpreadJsObj.initSheet(this.spread.getActiveSheet(), this.spreadSetting);
  298. this.spread.getActiveSheet().bind(GC.Spread.Sheets.Events.CellDoubleClick, function (e, info) {
  299. const stdSheet = info.sheet;
  300. const mainSheet = ledgerSpread.getActiveSheet();
  301. if (!stdSheet.zh_setting || !stdSheet.zh_tree || !mainSheet.zh_tree) { return; }
  302. const stdTree = stdSheet.zh_tree;
  303. const stdNode = stdTree.nodes[info.row];
  304. const mainTree = mainSheet.zh_tree;
  305. const sel = mainSheet.getSelections()[0];
  306. const mainNode = mainTree.nodes[sel.row];
  307. if (!stdNode) { return; }
  308. mainTree.postData('/tender/' + getTenderId() + '/ledger/add-by-std', mainNode, {
  309. tender_id: mainNode.tender_id,
  310. stdType: stdType,
  311. stdLibId: stdNode.list_id,
  312. stdNode: stdTree.getNodeKey(stdNode)
  313. }, function (result) {
  314. treeOperationObj.refreshTree(mainSheet, result);
  315. treeOperationObj.refreshOperationValid(mainSheet);
  316. });
  317. });
  318. this.pathTree = createNewPathTree('base', this.treeSetting);
  319. }
  320. loadLib (listId) {
  321. const self = this;
  322. postData(this.url+'/get-data', {list_id: listId}, function (data) {
  323. self.pathTree.loadDatas(data);
  324. SpreadJsObj.loadSheetData(self.spread.getActiveSheet(), 'tree', self.pathTree);
  325. });
  326. }
  327. }
  328. class DealBills {
  329. constructor (selector, spreadSetting) {
  330. const self = this;
  331. this.loaded = false;
  332. this.obj = $(selector)[0];
  333. this.url = '/tender/' + window.location.pathname.split('/')[2] + '/deal';
  334. this.spreadSetting = spreadSetting;
  335. this.spread = SpreadJsObj.createNewSpread(this.obj);
  336. SpreadJsObj.initSheet(this.spread.getActiveSheet(), this.spreadSetting);
  337. this.spread.bind(spreadNS.Events.CellDoubleClick, function (e, info) {
  338. const dealSheet = info.sheet;
  339. const mainSheet = ledgerSpread.getActiveSheet();
  340. const dealBills = SpreadJsObj.getSelectObject(dealSheet);
  341. if (!dealBills) { return; }
  342. const mainTree = mainSheet.zh_tree;
  343. const mainNode = SpreadJsObj.getSelectObject(mainSheet);
  344. if (!mainNode || !mainTree) { return; }
  345. if (mainNode.code && mainNode.code !== '' && !mainTree.isLeafXmj(mainNode)) {
  346. toast('非最底层项目下,不应添加清单', 'error');
  347. return;
  348. }
  349. postData('/tender/' + getTenderId() + '/ledger/add-by-deal', {
  350. id: mainNode.ledger_id,
  351. type: mainNode.code ? 'child' : 'next',
  352. dealBills: {
  353. b_code: dealBills.code, name: dealBills.name, unit: dealBills.unit,
  354. unit_price: dealBills.unit_price,
  355. },
  356. }, function (result) {
  357. const refreshData = mainTree.loadPostData(result);
  358. treeOperationObj.refreshTree(mainSheet, refreshData);
  359. treeOperationObj.refreshOperationValid(mainSheet);
  360. });
  361. });
  362. SpreadJsObj.forbiddenSpreadContextMenu(selector, this.spread);
  363. }
  364. loadData () {
  365. if (this.loaded) return;
  366. const self = this;
  367. postData(this.url+'/get-data', {}, function (data) {
  368. self.data = data;
  369. //self.calculateData();
  370. SpreadJsObj.loadSheetData(self.spread.getActiveSheet(), 'data', data);
  371. self.loaded = true;
  372. });
  373. }
  374. calculateData () {
  375. if (this.data) {
  376. for (const d of this.data) {
  377. d.total_price = _.multiply(d.quantity, d.unit_price);
  378. }
  379. }
  380. }
  381. }
  382. class BatchInsertBillsPosObj {
  383. constructor (obj) {
  384. const self = this;
  385. this.obj = obj;
  386. this.billsCount = 6;
  387. this.posCount = 1000;
  388. // 初始化 清单编号窗口 参数
  389. this.qdSpreadSetting = {
  390. cols: [
  391. {title: '编号', field: 'code', hAlign: 0, width: 80, formatter: '@'},
  392. {title: '名称', field: 'name', hAlign: 0, width: 120, formatter: '@'},
  393. {title: '单位', field: 'unit', hAlign: 1, width: 50, formatter: '@'},
  394. {title: '单价', field: 'unit_price', hAlign: 2, width: 50},
  395. {title: '图册号', field: 'name', hAlign: 0, width: 60, formatter: '@'},
  396. ],
  397. emptyRows: this.billsCount,
  398. headRows: 1,
  399. headRowHeight: [40],
  400. };
  401. this.qdSpread = SpreadJsObj.createNewSpread($('.batch-l-t', this.obj)[0]);
  402. // 初始化 部位数量复核表 参数
  403. this.posSpreadSetting = {
  404. cols: [
  405. {title: '部位', field: 'bw', hAlign: 0, width: 80, formatter: '@'},
  406. {title: '图册号', field: 'drawingCode', hAlign: 0, formatter: '@', width: 60},
  407. ],
  408. emptyRows: this.posCount,
  409. headRows: 1,
  410. headRowHeight: [40],
  411. };
  412. for (let iNum = 1; iNum <= this.billsCount; iNum++) {
  413. this.posSpreadSetting.cols.push(
  414. {title: '清单' + iNum, field: 'bills' + iNum, hAlign: 2, width: 50}
  415. )
  416. }
  417. this.posSpread = SpreadJsObj.createNewSpread($('.batch-l-b', this.obj)[0]);
  418. // 初始化 签约清单 参数
  419. this.dealSpreadSetting = {
  420. cols: [
  421. {title: '清单编号', field: 'code', width: 80, formatter: '@', readOnly: true},
  422. {title: '名称', field: 'name', width: 120, formatter: '@', readOnly: true},
  423. {title: '单位', field: 'unit', width: 50, formatter: '@', readOnly: true},
  424. {title: '单价', field: 'unit_price', width: 50, readOnly: true},
  425. ],
  426. emptyRows: 0,
  427. headRows: 1,
  428. headRowHeight: [40],
  429. };
  430. this.dealSpread = SpreadJsObj.createNewSpread($('.batch-r', this.obj)[0]);
  431. // 初始化 清单编号、部位数量复核表 表格
  432. this.initView();
  433. SpreadJsObj.initSheet(this.dealSpread.getActiveSheet(), this.dealSpreadSetting);
  434. SpreadJsObj.refreshColumnAlign(this.dealSpread.getActiveSheet());
  435. // 拉取签约清单数据
  436. dealBills.loadData();
  437. SpreadJsObj.loadSheetData(this.dealSpread.getActiveSheet(), 'data', dealBills.data);
  438. // 双击签约清单,自动添加到清单编号窗口
  439. this.dealSpread.bind(GC.Spread.Sheets.Events.CellDoubleClick, function (e, info) {
  440. const deal = info.sheet.zh_data[info.row];
  441. const qdSheet = self.qdSpread.getActiveSheet(), posSheet = self.posSpread.getActiveSheet();
  442. const sel = qdSheet.getSelections()[0];
  443. qdSheet.getCell(sel.row, 0).value(deal.code);
  444. qdSheet.getCell(sel.row, 1).value(deal.name);
  445. qdSheet.getCell(sel.row, 2).value(deal.unit);
  446. qdSheet.getCell(sel.row, 3).value(deal.unit_price);
  447. if (sel.row + 1 === qdSheet.getRowCount()) {
  448. const count = sel.row + 2;
  449. qdSheet.setRowCount(count);
  450. qdSheet.getCell(sel.row + 1, 0, GC.Spread.Sheets.SheetArea.rowHeader).text('清单' + count);
  451. const colCount = posSheet.getColumnCount() + 1
  452. posSheet.setColumnCount(colCount);
  453. posSheet.getCell(0, colCount - 1, GC.Spread.Sheets.SheetArea.colHeader).text('数量' + count);
  454. }
  455. qdSheet.setSelection(sel.row + 1, sel.col, 1, 1);
  456. });
  457. this.obj.bind('shown.bs.modal', function () {
  458. self.qdSpread.refresh();
  459. self.posSpread.refresh();
  460. self.dealSpread.refresh();
  461. });
  462. $('#batch-ok').click(function () {
  463. const selection = billsSheet.getSelections();
  464. const row = selection[0].row;
  465. const select = billsTree.nodes[row];
  466. if (select) {
  467. const insertData = {};
  468. insertData.batchType = (select.code && select.code !== '') ? 'child' : 'next';
  469. insertData.id = select[billsTree.setting.id];
  470. insertData.batchData = self.getBatchData();
  471. postData(window.location.pathname + '/batch-insert', insertData, function (data) {
  472. pos.updateDatas(data.pos);
  473. const result = billsTree.loadPostData(data.ledger);
  474. billsTreeSpreadObj.refreshTree(billsSheet, result);
  475. billsTreeSpreadObj.refreshOperationValid(billsSheet, selection);
  476. self.obj.modal('hide');
  477. });
  478. }
  479. });
  480. }
  481. // 初始化左侧表格
  482. initView () {
  483. // 初始化 清单编号
  484. const qdSheet = this.qdSpread.getActiveSheet();
  485. SpreadJsObj.initSheet(qdSheet, this.qdSpreadSetting);
  486. SpreadJsObj.refreshColumnAlign(qdSheet);
  487. // 清理原有数据
  488. SpreadJsObj.beginMassOperation(qdSheet);
  489. qdSheet.clear(0, 0, qdSheet.getRowCount(), qdSheet.getColumnCount(), GC.Spread.Sheets.SheetArea.viewport, GC.Spread.Sheets.StorageType.data);
  490. for (let iRow = 1; iRow <= this.billsCount; iRow++) {
  491. qdSheet.getCell(iRow - 1, 0, GC.Spread.Sheets.SheetArea.rowHeader).text('清单' + iRow);
  492. }
  493. qdSheet.setSelection(0, 0, 1 ,1);
  494. SpreadJsObj.endMassOperation(qdSheet);
  495. // 初始化 部位数量复核表
  496. const posSheet = this.posSpread.getActiveSheet();
  497. SpreadJsObj.initSheet(posSheet, this.posSpreadSetting);
  498. SpreadJsObj.refreshColumnAlign(posSheet);
  499. // 清理原有数据
  500. SpreadJsObj.beginMassOperation(posSheet);
  501. posSheet.setColumnWidth(0, 45, GC.Spread.Sheets.SheetArea.rowHeader);
  502. posSheet.clear(0, 0, posSheet.getRowCount(), posSheet.getColumnCount(), GC.Spread.Sheets.SheetArea.viewport, GC.Spread.Sheets.StorageType.data);
  503. posSheet.setSelection(0, 0, 1 ,1);
  504. SpreadJsObj.endMassOperation(posSheet);
  505. // 检查签约清单数据,以工具栏数据为准
  506. if (dealBills) {
  507. SpreadJsObj.loadSheetData(this.dealSpread.getActiveSheet(), 'data', dealBills.data);
  508. }
  509. this.dealSpread.getActiveSheet().setSelection(0, 0, 1, 1);
  510. }
  511. // 获取界面数据
  512. getBatchData () {
  513. const result = [];
  514. const qdSheet = this.qdSpread.getActiveSheet(), posSheet = this.posSpread.getActiveSheet();
  515. for (let iRow = 0; iRow < qdSheet.getRowCount(); iRow++) {
  516. if (qdSheet.getText(iRow, 0) === '') { continue; }
  517. const qd = {
  518. b_code: qdSheet.getText(iRow, 0),
  519. name: qdSheet.getText(iRow, 1),
  520. unit: qdSheet.getText(iRow, 2),
  521. price: _.toNumber(qdSheet.getText(iRow, 3)),
  522. pos: [],
  523. };
  524. result.push(qd);
  525. for (let iPosRow = 0; iPosRow < posSheet.getRowCount(); iPosRow++) {
  526. const value = _.toNumber(posSheet.getText(iPosRow, iRow + 2));
  527. if (value !== 0 && !isNaN(value)) {
  528. qd.pos.push({
  529. name: posSheet.getText(iPosRow, 0),
  530. drawing_code: posSheet.getText(iPosRow, 1),
  531. quantity: value,
  532. });
  533. }
  534. }
  535. }
  536. return result;
  537. }
  538. }
  539. let stdChapter, stdBills;
  540. const dealBills = new DealBills('#deal-bills-spread', {
  541. cols: [
  542. {title: '清单编号', field: 'code', hAlign: 0, width: 120, formatter: '@', readOnly: true},
  543. {title: '名称', field: 'name', hAlign: 0, width: 230, formatter: '@', readOnly: true},
  544. {title: '单位', field: 'unit', hAlign: 1, width: 50, formatter: '@', readOnly: true},
  545. {title: '单价', field: 'unit_price', hAlign: 2, width: 50, readOnly: true},
  546. {title: '数量', field: 'quantity', hAlign: 2, width: 50, readOnly: true},
  547. {title: '金额', field: 'total_price', hAlign: 2, width: 50, readOnly: true},
  548. ],
  549. emptyRows: 0,
  550. headRows: 1,
  551. headRowHeight: [40],
  552. defaultRowHeight: 21,
  553. });
  554. $.divResizer({
  555. select: '#revise-right-spr',
  556. callback: function () {
  557. billsSpread.refresh();
  558. if (posSpread) {
  559. posSpread.refresh();
  560. }
  561. if (stdChapter) {
  562. stdChapter.spread.refresh();
  563. }
  564. if (stdBills) {
  565. stdBills.spread.refresh();
  566. }
  567. }
  568. });
  569. // 展开收起标准清单
  570. $('a', '#side-menu').bind('click', function (e) {
  571. e.preventDefault();
  572. const tab = $(this), tabPanel = $(tab.attr('content'));
  573. const showSideTools = function (show) {
  574. const left = $('#left-view'), right = $('#right-view'), parent = left.parent();
  575. if (show) {
  576. right.show();
  577. autoFlashHeight();
  578. /**
  579. * right.show()后, parent被撑开成2倍left.height, 导致parent.width减少了10px
  580. * 第一次left.width调整后,parent的缩回left.height, 此时parent.width又增加了10px
  581. * 故需要通过最终的parent.width再计算一次left.width
  582. *
  583. * Q: 为什么不通过先计算left.width的宽度,以避免计算两次left.width?
  584. * A: 右侧工具栏不一定显示,当右侧工具栏显示过一次后,就必须使用parent和right来计算left.width
  585. *
  586. */
  587. //left.css('width', parent.width() - right.outerWidth());
  588. //left.css('width', parent.width() - right.outerWidth());
  589. const percent = 100 - right.outerWidth() /parent.width() * 100;
  590. left.css('width', percent + '%');
  591. } else {
  592. left.width(parent.width());
  593. right.hide();
  594. }
  595. };
  596. // 展开工具栏、切换标签
  597. if (!tab.hasClass('active')) {
  598. const close = $('.active', '#side-menu').length === 0;
  599. $('a', '#side-menu').removeClass('active');
  600. tab.addClass('active');
  601. $('.tab-content .tab-pane').removeClass('active');
  602. tabPanel.addClass('active');
  603. showSideTools(tab.hasClass('active'));
  604. if (tab.attr('content') === '#std-chapter') {
  605. if (!stdChapter) {
  606. stdChapter = new stdLib($('#std-chapter-spread')[0], 'chapter', {
  607. id: 'chapter_id',
  608. pid: 'pid',
  609. order: 'order',
  610. level: 'level',
  611. rootId: -1,
  612. keys: ['id', 'list_id', 'chapter_id'],
  613. }, {
  614. cols: [
  615. {title: '项目节编号', field: 'code', hAlign: 0, width: 120, formatter: '@', readOnly: true, cellType: 'tree'},
  616. {title: '名称', field: 'name', hAlign: 0, width: 230, formatter: '@', readOnly: true},
  617. {title: '单位', field: 'unit', hAlign: 1, width: 50, formatter: '@', readOnly: true}
  618. ],
  619. treeCol: 0,
  620. emptyRows: 0,
  621. headRows: 1,
  622. headRowHeight: [40],
  623. defaultRowHeight: 21,
  624. });
  625. stdChapter.loadLib(1);
  626. }
  627. stdChapter.spread.refresh();
  628. } else if (tab.attr('content') === '#std-bills') {
  629. if (!stdBills) {
  630. stdBills = new stdLib($('#std-bills-spread')[0], 'bills', {
  631. id: 'bill_id',
  632. pid: 'pid',
  633. order: 'order',
  634. level: 'level',
  635. rootId: -1,
  636. keys: ['id', 'list_id', 'bill_id']
  637. }, {
  638. cols: [
  639. {title: '清单编号', field: 'code', hAlign: 0, width: 120, formatter: '@', readOnly: true, cellType: 'tree'},
  640. {title: '名称', field: 'name', hAlign: 0, width: 230, formatter: '@', readOnly: true},
  641. {title: '单位', field: 'unit', hAlign: 1, width: 50, formatter: '@', readOnly: true}
  642. ],
  643. treeCol: 0,
  644. emptyRows: 0,
  645. headRows: 1,
  646. headRowHeight: [40],
  647. defaultRowHeight: 21,
  648. });
  649. stdBills.loadLib(1);
  650. }
  651. stdBills.spread.refresh();
  652. } else if (tab.attr('content') === '#deal-bills') {
  653. dealBills.loadData();
  654. dealBills.spread.refresh();
  655. }
  656. }
  657. billsSpread.refresh();
  658. if (posSpread) {
  659. posSpread.refresh();
  660. }
  661. });
  662. // 修订详情 保存
  663. $('#save').click(function () {
  664. const content = $('textarea').val();
  665. postData('save', { content: content });
  666. });
  667. // 显示层次
  668. (function (select, sheet) {
  669. if (!sheet.zh_tree) return;
  670. $(select).click(function () {
  671. const tag = $(this).attr('tag');
  672. const tree = sheet.zh_tree;
  673. switch (tag) {
  674. case "1":
  675. case "2":
  676. case "3":
  677. case "4":
  678. case "5":
  679. tree.expandByLevel(parseInt(tag));
  680. SpreadJsObj.refreshTreeRowVisible(sheet);
  681. break;
  682. case "last":
  683. tree.expandByCustom(() => { return true; });
  684. SpreadJsObj.refreshTreeRowVisible(sheet);
  685. break;
  686. case "leafXmj":
  687. tree.expandToLeafXmj();
  688. SpreadJsObj.refreshTreeRowVisible(sheet);
  689. break;
  690. }
  691. });
  692. })('a[name=showLevel]', billsSheet);
  693. });