revise.js 37 KB

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