revise.js 32 KB

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