ledger.js 57 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293
  1. /**
  2. * 台账相关js
  3. *
  4. * @author Mai
  5. * @date 2018/02/05
  6. * @version
  7. */
  8. function checkTzMeasureType () {
  9. return tender.measure_type === measureType.tz.value;
  10. }
  11. function getTenderId() {
  12. return window.location.pathname.split('/')[2];
  13. }
  14. $(document).ready(function() {
  15. autoFlashHeight();
  16. // 初始化台账
  17. const ledgerSpread = SpreadJsObj.createNewSpread($('#ledger-spread')[0]);
  18. SpreadJsObj.addDeleteBind(ledgerSpread);
  19. const treeSetting = {
  20. id: 'ledger_id',
  21. pid: 'ledger_pid',
  22. order: 'order',
  23. level: 'level',
  24. rootId: -1,
  25. keys: ['id', 'tender_id', 'ledger_id'],
  26. preUrl: '/tender/' + getTenderId() + '/ledger',
  27. };
  28. if (checkTzMeasureType()) {
  29. treeSetting.calcFields = ['total_price'];
  30. } else {
  31. treeSetting.calcFields = ['deal_tp', 'total_price'];
  32. }
  33. treeSetting.calcFun = function (node) {
  34. if (checkZero(node.dgn_qty1)) {
  35. node.dgn_price = _.round(node.total_price/node.dgn_qty1, 6);
  36. } else {
  37. node.dgn_price = null;
  38. }
  39. };
  40. const ledgerTree = createNewPathTree('ledger', treeSetting);
  41. ledgerTree.loadDatas(ledger);
  42. treeCalc.calculateAll(ledgerTree);
  43. SpreadJsObj.initSheet(ledgerSpread.getActiveSheet(), ledgerSpreadSetting);
  44. // 加载台账数据到界面
  45. SpreadJsObj.loadSheetData(ledgerSpread.getActiveSheet(), 'tree', ledgerTree);
  46. // 初始化 部位明细
  47. const pos = new PosData({
  48. id: 'id', masterId: 'lid',
  49. });
  50. const posSpread = SpreadJsObj.createNewSpread($('#pos-spread')[0]);
  51. // 定义事件
  52. const treeOperationObj = {
  53. getSelectNode: function (sheet) {
  54. if (!sheet || !sheet.zh_tree) {
  55. return null;
  56. } else {
  57. const sel = sheet.getSelections()[0];
  58. return sheet.zh_tree.nodes[sel.row];
  59. }
  60. },
  61. /**
  62. * 刷新顶部按钮是否可用
  63. * @param sheet
  64. * @param selections
  65. */
  66. refreshOperationValid: function (sheet, selections) {
  67. const setObjEnable = function (obj, enable) {
  68. if (enable) {
  69. obj.removeClass('disabled');
  70. } else {
  71. obj.addClass('disabled');
  72. }
  73. };
  74. const row = selections[0].row;
  75. const tree = sheet.zh_tree;
  76. if (!tree) { return; }
  77. const node = sheet.zh_tree.nodes[row];
  78. const valid = !sheet.zh_setting.readOnly;
  79. setObjEnable($('#delete'), valid && node);
  80. setObjEnable($('#up-move'), valid && node && node.order > 1);
  81. setObjEnable($('#down-move'), valid && node && !tree.isLastSibling(node));
  82. if (checkTzMeasureType()) {
  83. const posRange = node ? pos.getMasterRange(node.id) : [];
  84. setObjEnable($('#up-level'), valid && node && tree.getParent(node) && (!posRange || posRange.length === 0));
  85. } else {
  86. setObjEnable($('#up-level'), valid && node && tree.getParent(node));
  87. }
  88. setObjEnable($('#down-level'), valid && node && node.order > 1);
  89. },
  90. refreshTree: function (sheet, data) {
  91. SpreadJsObj.massOperationSheet(sheet, function () {
  92. const tree = sheet.zh_tree;
  93. // 处理删除
  94. if (data.delete) {
  95. for (const d of data.delete) {
  96. sheet.deleteRows(tree.nodes.indexOf(d), 1);
  97. }
  98. }
  99. // 处理新增
  100. let cTime = new Date();
  101. if (data.create) {
  102. const newNodes = data.create;
  103. if (newNodes) {
  104. let sTime = new Date();
  105. newNodes.sort(function (a, b) {
  106. return a.index - b.index;
  107. });
  108. sTime = new Date() - sTime;
  109. console.log('sort: ' + sTime);
  110. let lTime = new Date();
  111. for (const node of newNodes) {
  112. sheet.addRows(node.index, 1);
  113. SpreadJsObj.reLoadRowData(sheet, tree.nodes.indexOf(node), 1);
  114. }
  115. lTime = new Date() - lTime;
  116. console.log('load: '+ lTime);
  117. }
  118. }
  119. cTime = new Date() - cTime;
  120. console.log('refreshNewNode: ' + cTime);
  121. // 处理更新
  122. if (data.update) {
  123. const rows = [];
  124. for (const u of data.update) {
  125. rows.push(tree.nodes.indexOf(u));
  126. }
  127. SpreadJsObj.reLoadRowsData(sheet, rows);
  128. }
  129. // 处理展开
  130. if (data.expand) {
  131. const expanded = [];
  132. for (const e of data.expand) {
  133. if (expanded.indexOf(e) === -1) {
  134. const posterity = tree.getPosterity(e);
  135. for (const p of posterity) {
  136. sheet.setRowVisible(tree.nodes.indexOf(p), p.visible);
  137. expanded.push(p);
  138. }
  139. }
  140. }
  141. }
  142. });
  143. },
  144. /**
  145. * 新增节点
  146. * @param spread
  147. */
  148. addNode: function (spread) {
  149. const self = this;
  150. const sheet = spread.getActiveSheet();
  151. const row = sheet.getSelections()[0].row;
  152. const tree = sheet.zh_tree;
  153. if (!tree) { return; }
  154. const node = sheet.zh_tree.nodes[row];
  155. if (!node) { return; }
  156. SpreadJsObj.massOperationSheet(sheet, function () {
  157. tree.baseOperation('/tender/' + getTenderId() + '/ledger/base-operation', node, 'add', function (result) {
  158. self.refreshTree(sheet, result);
  159. self.refreshOperationValid(sheet, sheet.getSelections());
  160. });
  161. });
  162. },
  163. /**
  164. * 删除选中节点
  165. * @param spread
  166. */
  167. deleteNode: function (spread) {
  168. const self = this;
  169. const sheet = spread.getActiveSheet();
  170. const row = sheet.getSelections()[0].row;
  171. const tree = sheet.zh_tree;
  172. if (!tree) { return; }
  173. const node = sheet.zh_tree.nodes[row];
  174. if (!node) { return; }
  175. const count = ledgerTree.getPosterity(node).length;
  176. tree.baseOperation('/tender/' + getTenderId() + '/ledger/base-operation', node, 'delete', function (result) {
  177. sheet.deleteRows(row, count + 1);
  178. for (const data of result.update) {
  179. SpreadJsObj.reLoadRowData(sheet, tree.nodes.indexOf(data), tree.getPosterity(data).length + 1);
  180. }
  181. self.refreshOperationValid(sheet, sheet.getSelections());
  182. for (const data of result.delete) {
  183. pos.removeDatasByMasterId(data.id);
  184. }
  185. posOperationObj.loadCurPosData();
  186. });
  187. },
  188. /**
  189. * 上移选中节点
  190. * @param spread
  191. */
  192. upMove: function (spread) {
  193. const self = this;
  194. const sheet = spread.getActiveSheet();
  195. const sel = sheet.getSelections()[0];
  196. const row = sel.row;
  197. const tree = sheet.zh_tree;
  198. if (!tree) { return; }
  199. const node = tree.nodes[row];
  200. if (!node) { return; }
  201. tree.baseOperation('/tender/' + getTenderId() + '/ledger/base-operation', node, 'up-move', function (result) {
  202. for (const data of result.update) {
  203. SpreadJsObj.reLoadRowData(sheet, tree.nodes.indexOf(data), tree.getPosterity(data).length + 1);
  204. }
  205. sheet.setSelection(tree.nodes.indexOf(node), sel.col, sel.rowCount, sel.colCount);
  206. self.refreshOperationValid(sheet, sheet.getSelections());
  207. //sheet.moveTo(row, -1, tree.nodes.indexOf(node), -1, tree.getPosterity(node).length + 1, -1, GC.Spread.Sheets.CopyToOptions.value);
  208. });
  209. },
  210. /**
  211. * 下移选中节点
  212. * @param spread
  213. */
  214. downMove: function (spread) {
  215. const self = this;
  216. const sheet = spread.getActiveSheet();
  217. const sel = sheet.getSelections()[0];
  218. const row = sel.row;
  219. const tree = sheet.zh_tree;
  220. if (!tree) { return; }
  221. const node = tree.nodes[row];
  222. if (!node) { return; }
  223. tree.baseOperation('/tender/' + getTenderId() + '/ledger/base-operation', node, 'down-move', function (result) {
  224. for (const data of result.update) {
  225. SpreadJsObj.reLoadRowData(sheet, tree.nodes.indexOf(data), tree.getPosterity(data).length + 1);
  226. }
  227. sheet.setSelection(tree.nodes.indexOf(node), sel.col, sel.rowCount, sel.colCount);
  228. self.refreshOperationValid(sheet, sheet.getSelections());
  229. });
  230. },
  231. /**
  232. * 升级选中节点
  233. * @param spread
  234. */
  235. upLevel: function (spread) {
  236. const self = this;
  237. const sheet = spread.getActiveSheet();
  238. const row = sheet.getSelections()[0].row;
  239. const tree = sheet.zh_tree;
  240. if (!tree) { return; }
  241. const node = tree.nodes[row];
  242. if (!node) { return; }
  243. tree.baseOperation('/tender/' + getTenderId() + '/ledger/base-operation', node, 'up-level', function (result) {
  244. self.refreshTree(sheet, result);
  245. self.refreshOperationValid(sheet, sheet.getSelections());
  246. });
  247. },
  248. /**
  249. * 降级选中节点
  250. * @param spread
  251. */
  252. downLevel: function (spread) {
  253. const self = this;
  254. const sheet = spread.getActiveSheet();
  255. const row = sheet.getSelections()[0].row;
  256. const tree = sheet.zh_tree;
  257. if (!tree) { return; }
  258. const node = tree.nodes[row];
  259. if (!node) { return; }
  260. tree.baseOperation('/tender/' + getTenderId() + '/ledger/base-operation', node, 'down-level', function (result) {
  261. self.refreshTree(sheet, result);
  262. self.refreshOperationValid(sheet, sheet.getSelections());
  263. });
  264. },
  265. /**
  266. * 编辑单元格响应事件
  267. * @param {Object} e
  268. * @param {Object} info
  269. */
  270. editEnded: function (e, info) {
  271. if (info.sheet.zh_setting) {
  272. const col = info.sheet.zh_setting.cols[info.col];
  273. const sortData = info.sheet.zh_dataType === 'tree' ? info.sheet.zh_tree.nodes : info.sheet.zh_data;
  274. const node = sortData[info.row];
  275. const data = {
  276. id: node.id,
  277. tender_id: node.tender_id,
  278. ledger_id: node.ledger_id
  279. };
  280. data[col.field] = col.type === 'Number' ? parseFloat(info.editingText) : info.editingText;
  281. info.sheet.zh_tree.update('/tender/' + getTenderId() + '/ledger/update', data, function (result) {
  282. treeOperationObj.refreshTree(info.sheet, result);
  283. });
  284. }
  285. },
  286. /**
  287. * 粘贴单元格响应事件
  288. * @param e
  289. * @param info
  290. */
  291. clipboardPasted: function (e, info) {
  292. if (info.sheet.zh_setting && info.sheet.zh_dataType === 'tree') {
  293. const tree = sheet.zh_tree;
  294. if (!tree) { return; }
  295. const sortData = info.sheet.zh_tree.nodes;
  296. const datas = [], nodes = [];
  297. for (let iRow = 0; iRow < info.cellRange.rowCount; iRow ++) {
  298. const curRow = info.cellRange.row + iRow;
  299. const node = sortData[curRow];
  300. if (node) {
  301. const data = info.sheet.zh_tree.getNodeKeyData(node);
  302. for (let iCol = 0; iCol < info.cellRange.colCount; iCol++) {
  303. const curCol = info.cellRange.col + iCol;
  304. const colSetting = info.sheet.zh_setting.cols[curCol];
  305. data[colSetting.field] = info.sheet.getText(curRow, curCol);
  306. }
  307. datas.push(data);
  308. nodes.push(node);
  309. }
  310. }
  311. info.sheet.zh_tree.update('/tender/' + getTenderId() + '/ledger/update', datas, function (result) {
  312. treeOperationObj.refreshTree(info.sheet, result);
  313. });
  314. }
  315. },
  316. /**
  317. * 删除按钮响应事件
  318. * @param sheet
  319. */
  320. deletePress: function (sheet) {
  321. if (sheet.zh_setting && sheet.zh_dataType === 'tree') {
  322. const tree = sheet.zh_tree;
  323. if (!tree) { return; }
  324. const sortData = sheet.zh_tree.nodes;
  325. const datas = [], nodes = [];
  326. const sel = sheet.getSelections()[0];
  327. for (let iRow = sel.row; iRow < sel.row + sel.rowCount; iRow++) {
  328. const node = sortData[iRow];
  329. if (node) {
  330. const data = sheet.zh_tree.getNodeKeyData(node);
  331. for (let iCol = sel.col; iCol < sel.col + sel.colCount; iCol++) {
  332. const colSetting = sheet.zh_setting.cols[iCol];
  333. data[colSetting.field] = null;
  334. }
  335. datas.push(data);
  336. nodes.push(node);
  337. }
  338. }
  339. sheet.zh_tree.update('/tender/' + getTenderId() + '/ledger/update', datas, function (result) {
  340. treeOperationObj.refreshTree(sheet, result);
  341. });
  342. }
  343. },
  344. /**
  345. * 粘贴整块
  346. * @param spread
  347. * @param block
  348. */
  349. pasteBlock: function (spread, block) {
  350. const self = this;
  351. const sheet = spread.getActiveSheet();
  352. const row = sheet.getSelections()[0].row;
  353. const tree = sheet.zh_tree;
  354. if (!tree) { return; }
  355. const node = tree.nodes[row];
  356. if (!node) { return; }
  357. postData('/tender/' + getTenderId() + '/ledger/paste-block', {
  358. id: node[tree.setting.id],
  359. block: block,
  360. }, function (data) {
  361. pos.updateDatas(data.pos);
  362. tree.loadPostData(data.ledger, function (result) {
  363. self.refreshTree(sheet, result);
  364. self.refreshOperationValid(sheet, sheet.getSelections());
  365. });
  366. });
  367. },
  368. selectionChanged: function (e, info) {
  369. if (info.newSelections[0].row !== info.oldSelections[0].row) {
  370. posOperationObj.loadCurPosData();
  371. }
  372. },
  373. };
  374. // 绑定事件
  375. if (!ledgerSpreadSetting.readOnly) {
  376. ledgerSpread.bind(GC.Spread.Sheets.Events.SelectionChanged, function (e, info) {
  377. treeOperationObj.refreshOperationValid(info.sheet, info.newSelections);
  378. });
  379. ledgerSpread.bind(GC.Spread.Sheets.Events.EditEnded, treeOperationObj.editEnded);
  380. ledgerSpread.bind(GC.Spread.Sheets.Events.ClipboardPasted, treeOperationObj.clipboardPasted);
  381. SpreadJsObj.addDeleteBind(ledgerSpread, treeOperationObj.deletePress);
  382. ledgerSpread.bind(GC.Spread.Sheets.Events.ClipboardChanging, function (e, info) {
  383. const copyText = SpreadJsObj.getFilterCopyText(info.sheet);
  384. });
  385. ledgerSpread.bind(GC.Spread.Sheets.Events.ClipboardChanged, function (e, info) {
  386. console.log(info.copyData.text);
  387. });
  388. ledgerSpread.bind(GC.Spread.Sheets.Events.ClipboardPasting, function (e, info) {
  389. });
  390. ledgerSpread.bind(GC.Spread.Sheets.Events.SelectionChanged, treeOperationObj.selectionChanged);
  391. // 绑定 删除等 顶部按钮
  392. $('#delete').click(function () {
  393. treeOperationObj.deleteNode(ledgerSpread);
  394. });
  395. $('#up-move').click(function () {
  396. treeOperationObj.upMove(ledgerSpread);
  397. });
  398. $('#down-move').click(function () {
  399. treeOperationObj.downMove(ledgerSpread);
  400. });
  401. $('#up-level').click(function () {
  402. treeOperationObj.upLevel(ledgerSpread);
  403. });
  404. $('#down-level').click(function () {
  405. treeOperationObj.downLevel(ledgerSpread);
  406. });
  407. let batchInsertObj;
  408. // 右键菜单
  409. $.contextMenu({
  410. selector: '#ledger-spread',
  411. build: function ($trigger, e) {
  412. const target = SpreadJsObj.safeRightClickSelection($trigger, e, ledgerSpread);
  413. return target.hitTestType === GC.Spread.Sheets.SheetArea.viewport || target.hitTestType === GC.Spread.Sheets.SheetArea.rowHeader;
  414. },
  415. items: {
  416. 'create': {
  417. name: '新增',
  418. icon: 'fa-sign-in',
  419. callback: function (key, opt) {
  420. treeOperationObj.addNode(ledgerSpread);
  421. },
  422. visible: function(key, opt){
  423. const sheet = ledgerSpread.getActiveSheet();
  424. const selection = sheet.getSelections();
  425. const row = selection[0].row;
  426. const select = ledgerTree.nodes[row];
  427. return select;
  428. }
  429. },
  430. 'delete': {
  431. name: '删除',
  432. icon: 'fa-remove',
  433. callback: function (key, opt) {
  434. treeOperationObj.deleteNode(ledgerSpread);
  435. },
  436. visible: function (key, opt) {
  437. const sheet = ledgerSpread.getActiveSheet();
  438. const selection = sheet.getSelections();
  439. const row = selection[0].row;
  440. const select = ledgerTree.nodes[row];
  441. return select;
  442. }
  443. },
  444. 'copyBlock': {
  445. name: '复制整块',
  446. icon: 'fa-files-o',
  447. callback: function (key, opt) {
  448. /*ledgerSpread.commandManager().execute({
  449. cmd:"copy",
  450. sheetName:ledgerSpread.getActiveSheet().name()
  451. });*/
  452. treeOperationObj.block = [];
  453. const copyBlockList = [];
  454. const sheet = ledgerSpread.getActiveSheet();
  455. const sel = sheet.getSelections()[0];
  456. let iRow = sel.row;
  457. const pid = sheet.zh_tree.nodes[iRow].ledger_pid;
  458. while (iRow < sel.row + sel.rowCount) {
  459. const node = sheet.zh_tree.nodes[iRow];
  460. if (node.ledger_pid !== pid) {
  461. toast('error: 仅可同时选中同层节点', 'error', 'exclamation-circle');
  462. return;
  463. }
  464. copyBlockList.push(node.ledger_id);
  465. iRow += sheet.zh_tree.getPosterity(node).length + 1;
  466. }
  467. treeOperationObj.block = copyBlockList;
  468. },
  469. visible: function (key, opt) {
  470. const sheet = ledgerSpread.getActiveSheet();
  471. const selection = sheet.getSelections();
  472. const row = selection[0].row;
  473. const select = ledgerTree.nodes[row];
  474. return select;
  475. }
  476. },
  477. 'pasteBlock': {
  478. name: '粘贴整块',
  479. icon: 'fa-clipboard',
  480. disabled: function (key, opt) {
  481. const block = treeOperationObj.block || [];
  482. return block.length <= 0 && false;
  483. },
  484. callback: function (key, opt) {
  485. const block = treeOperationObj.block || [];
  486. if (block.length > 0) {
  487. treeOperationObj.pasteBlock(ledgerSpread, block);
  488. } else {
  489. document.execCommand('paste');
  490. }
  491. }
  492. },
  493. 'batchInsertBillsPos': {
  494. name: '批量插入清单部位',
  495. icon: 'fa-sign-in',
  496. disabled: function (key, opt) {
  497. const sheet = ledgerSpread.getActiveSheet();
  498. const selection = sheet.getSelections();
  499. const row = selection[0].row;
  500. const select = ledgerTree.nodes[row];
  501. if (select) {
  502. if (select.code && select.code !== '') {
  503. return !ledgerTree.isLeafXmj(select);
  504. } else {
  505. const parent = ledgerTree.getParent(select);
  506. return !(parent && ledgerTree.isLeafXmj(parent));
  507. }
  508. } else {
  509. return false;
  510. }
  511. },
  512. callback: function (key, opt) {
  513. if (!batchInsertObj) {
  514. batchInsertObj = new BatchInsertBillsPosObj($('#batch'));
  515. } else {
  516. batchInsertObj.initView();
  517. }
  518. $('#batch').modal('show');
  519. }
  520. },
  521. 'importExcel': {
  522. name: '导入分项清单Excel',
  523. icon: 'file-excel-o',
  524. disabled: function (key, opt) {
  525. return tender.ledger_status !== 1;
  526. },
  527. callback: function (key, opt) {
  528. $('#upload-ledger').modal('show');
  529. }
  530. }
  531. }
  532. });
  533. }
  534. treeOperationObj.refreshOperationValid(ledgerSpread.getActiveSheet(), ledgerSpread.getActiveSheet().getSelections());
  535. // 台账模式加载部位明细数据
  536. if (checkTzMeasureType()) {
  537. SpreadJsObj.initSheet(posSpread.getActiveSheet(), posSpreadSetting);
  538. postData('/tender/' + getTenderId() + '/pos', null, function (data) {
  539. pos.loadDatas(data);
  540. });
  541. }
  542. // 绑定部位明细编辑事件
  543. const posOperationObj = {
  544. /**
  545. * 加载部位明细 根据当前台账选择节点
  546. */
  547. loadCurPosData: function () {
  548. const node = treeOperationObj.getSelectNode(ledgerSpread.getActiveSheet());
  549. if (node) {
  550. const posData = pos.masterRange[itemsPre + node.id] || [];
  551. SpreadJsObj.loadSheetData(posSpread.getActiveSheet(), 'data', posData);
  552. } else {
  553. SpreadJsObj.loadSheetData(posSpread.getActiveSheet(), 'data', []);
  554. }
  555. },
  556. /**
  557. * 编辑单元格响应事件
  558. * @param {Object} e
  559. * @param {Object} info
  560. */
  561. editEnding: function (e, info) {
  562. if (info.sheet.zh_setting) {
  563. const orgText = info.sheet.getCell(info.row, info.row).value();
  564. if (orgText === info.editingText || ((!orgText || orgText === '') && (info.editingText === ''))) {
  565. return;
  566. }
  567. const node = treeOperationObj.getSelectNode(ledgerSpread.getActiveSheet());
  568. if (!node) {
  569. toast('数据错误, 请刷新页面后再试', 'warning')
  570. info.cancel = true;
  571. return;
  572. } else if (info.editingText !== '' && node.children && node.children > 0) {
  573. toast('父节点不可插入部位明细', 'error');
  574. info.cancel = true;
  575. return;
  576. } else if (info.editingText !== '' && node.code && node.code !== '') {
  577. toast('项目节不可插入部位明细', 'error');
  578. info.cancel = true;
  579. return;
  580. }
  581. const curPosData = pos.getMasterRange(node.id);
  582. const position = curPosData ? curPosData[info.row] : null;
  583. const col = info.sheet.zh_setting.cols[info.col];
  584. const data = {};
  585. if (col.field === 'name') {
  586. console.log(1);
  587. if (info.editingText === '' && position) {
  588. console.log(2);
  589. toast('部位名称不可为空', 'error', 'exclamation-circle');
  590. info.cancel = true;
  591. return;
  592. } else if (!position) {
  593. if (info.editingText !== '') {
  594. data.updateType = 'add';
  595. data.updateData = { name: info.editingText, lid: node.id, tid: tender.id };
  596. } else {
  597. return;
  598. }
  599. } else {
  600. data.updateType = 'update';
  601. data.updateData = {id: position.id, name: info.editingText};
  602. }
  603. } else if (!position) {
  604. toast('新增部位请先输入名称', 'warning');
  605. } else {
  606. data.updateType = 'update';
  607. data.updateData = {id: position.id};
  608. data.updateData[col.field] = col.type === 'Number' ? parseFloat(info.editingText) : info.editingText;
  609. }
  610. postData('/tender/' + getTenderId() + '/pos/update', data, function (result) {
  611. pos.updateDatas(result.pos);
  612. posOperationObj.loadCurPosData();
  613. ledgerTree.loadPostData(result.ledger, function (loadResult) {
  614. treeOperationObj.refreshTree(ledgerSpread.getActiveSheet(), loadResult);
  615. });
  616. }, function () {
  617. posOperationObj.loadCurPosData();
  618. });
  619. }
  620. },
  621. /**
  622. * 删除按钮响应事件
  623. * @param sheet
  624. */
  625. deletePress: function (sheet) {
  626. const self = this;
  627. if (sheet.zh_setting) {
  628. const sortData = sheet.zh_data;
  629. const datas = [], posSelects = [];
  630. const sel = sheet.getSelections()[0];
  631. for (let iRow = sel.row; iRow < sel.row + sel.rowCount; iRow++) {
  632. const node = sortData[iRow];
  633. if (node) {
  634. const data = {id: node.id};
  635. for (let iCol = sel.col; iCol < sel.col + sel.colCount; iCol++) {
  636. const colSetting = sheet.zh_setting.cols[iCol];
  637. if (colSetting.field === 'name') {
  638. toast('部位名称不能为空', 'error');
  639. return;
  640. }
  641. data[colSetting.field] = null;
  642. }
  643. datas.push(data);
  644. posSelects.push(node);
  645. }
  646. }
  647. sheet.zh_tree.update('/tender/' + getTenderId() + '/pos/update', datas, function (result) {
  648. pos.updateDatas(result);
  649. // todo 只加载改变项
  650. self.loadCurPosData();
  651. });
  652. }
  653. },
  654. /**
  655. * 删除 部位明细
  656. * @param sheet
  657. */
  658. deletePos: function (sheet) {
  659. const selection = sheet.getSelections();
  660. const data = {
  661. updateType: 'delete',
  662. updateData: [],
  663. }
  664. const row = selection[0].row, count = selection[0].rowCount;
  665. const sortData = sheet.zh_data;
  666. for (let iRow = 0; iRow < count; iRow++) {
  667. data.updateData.push(sortData[iRow + row].id);
  668. }
  669. postData('/tender/' + getTenderId() + '/pos/update', data, function (result) {
  670. pos.updateDatas(result.pos);
  671. sheet.deleteRows(row, count);
  672. ledgerTree.loadPostData(result.ledger, function (loadResult) {
  673. treeOperationObj.refreshTree(ledgerSpread.getActiveSheet(), loadResult);
  674. });
  675. });
  676. },
  677. /**
  678. * 粘贴单元格响应事件
  679. * @param e
  680. * @param info
  681. */
  682. clipboardPasted: function (e, info) {
  683. const self = this;
  684. const node = treeOperationObj.getSelectNode(ledgerSpread.getActiveSheet());
  685. if (node.code && (node.code !== '')) {
  686. toast('项目节不可含有清单明细', 'error');
  687. self.loadCurPosData();
  688. return;
  689. }
  690. if (node.children && (node.children.length > 0)) {
  691. toast('仅清单子项可以含有部位明细', 'error');
  692. self.loadCurPosData();
  693. return;
  694. }
  695. if (info.sheet.zh_setting) {
  696. const data = { updateType: '', updateData: [], };
  697. const sortData = info.sheet.zh_data;
  698. if (sortData && (info.cellRange.row >= sortData.length)) {
  699. data.updateType = 'add';
  700. if (info.cellRange.col !== 0) {
  701. toast('新增部位请先输入名称', 'warning');
  702. self.loadCurPosData();
  703. return;
  704. }
  705. for (let iRow = 0; iRow < info.cellRange.rowCount; iRow++) {
  706. const curRow = info.cellRange.row + iRow;
  707. const newData = {};
  708. for (let iCol = 0; iCol < info.cellRange.colCount; iCol++) {
  709. const curCol = info.cellRange.col + iCol;
  710. const colSetting = info.sheet.zh_setting.cols[curCol];
  711. data[colSetting.field] = info.sheet.getText(curRow, curCol);
  712. if (colSetting.type === 'Number') {
  713. data[colSetting.field] = _.toNumber(data[colSetting.field]);
  714. }
  715. }
  716. data.updateData.push(newData);
  717. }
  718. } else {
  719. data.updateType = 'update';
  720. for (let iRow = 0; iRow < info.cellRange.rowCount; iRow++) {
  721. const curRow = info.cellRange.row + iRow;
  722. const curPos = sortData[curRow];
  723. if (curPos) {
  724. const newData = {id: curPos.id};
  725. for (let iCol = 0; iCol < info.cellRange.colCount; iCol++) {
  726. const curCol = info.cellRange.col + iCol;
  727. const colSetting = info.sheet.zh_setting.cols[curCol];
  728. newData[colSetting.field] = info.sheet.getText(curRow, curCol);
  729. if (colSetting.type === 'Number') {
  730. newData[colSetting.field] = _.toNumber(newData[colSetting.field]);
  731. }
  732. }
  733. data.updateData.push(newData);
  734. }
  735. }
  736. }
  737. postData('/tender/' + getTenderId() + '/pos/update', data, function (result) {
  738. pos.updateDatas(result.pos);
  739. posOperationObj.loadCurPosData();
  740. ledgerTree.loadPostData(result.ledger, function (loadResult) {
  741. treeOperationObj.refreshTree(ledgerSpread.getActiveSheet(), loadResult);
  742. });
  743. posOperationObj.loadCurPosData();
  744. });
  745. }
  746. },
  747. };
  748. posOperationObj.loadCurPosData();
  749. if (!posSpreadSetting.readOnly) {
  750. SpreadJsObj.addDeleteBind(posSpread, posOperationObj.deletePress);
  751. posSpread.bind(GC.Spread.Sheets.Events.EditEnding, posOperationObj.editEnding);
  752. posSpread.bind(GC.Spread.Sheets.Events.ClipboardPasted, posOperationObj.clipboardPasted);
  753. // 右键菜单
  754. $.contextMenu({
  755. selector: '#pos-spread',
  756. build: function ($trigger, e) {
  757. const target = SpreadJsObj.safeRightClickSelection($trigger, e, posSpread);
  758. return target.hitTestType === GC.Spread.Sheets.SheetArea.viewport || target.hitTestType === GC.Spread.Sheets.SheetArea.rowHeader;
  759. },
  760. items: {
  761. 'delete': {
  762. name: '删除',
  763. icon: 'fa-remove',
  764. disabled: function (key, opt) {
  765. const sheet = posSpread.getActiveSheet();
  766. if (sheet.zh_data) {
  767. const selection = sheet.getSelections();
  768. return sheet.zh_data.length < selection[0].row + selection[0].rowCount;
  769. } else {
  770. return true;
  771. }
  772. },
  773. callback: function (key, opt) {
  774. posOperationObj.deletePos(posSpread.getActiveSheet());
  775. }
  776. },
  777. }
  778. });
  779. }
  780. let stdChapter, stdBills, dealBills, searchLedger;
  781. // 展开收起标准清单
  782. $('a', '#side-menu').bind('click', function () {
  783. const tab = $(this), tabPanel = $(tab.attr('content'));
  784. const showSideTools = function (show) {
  785. if (show) {
  786. $('.c-body.col-12').removeClass('col-12').addClass('col-8');
  787. $('.c-body.col-0').removeClass('col-0').addClass('col-4').show();
  788. } else {
  789. $('.c-body.col-8').removeClass('col-8').addClass('col-12');
  790. $('.c-body.col-4').removeClass('col-4').addClass('col-0').hide();
  791. }
  792. };
  793. // 展开工具栏、切换标签
  794. if (!tab.hasClass('active')) {
  795. $('a', '#side-menu').removeClass('active');
  796. tab.addClass('active');
  797. showSideTools(tab.hasClass('active'));
  798. $('.tab-content .tab-pane').hide();
  799. tabPanel.show();
  800. autoFlashHeight();
  801. if (tab.attr('content') === '#std-chapter') {
  802. if (!stdChapter) {
  803. stdChapter = new stdLib($('#std-chapter-spread')[0], 'chapter', {
  804. id: 'chapter_id',
  805. pid: 'pid',
  806. order: 'order',
  807. level: 'level',
  808. rootId: -1,
  809. keys: ['id', 'list_id', 'chapter_id'],
  810. }, {
  811. cols: [
  812. {title: '项目节编号', field: 'code', width: 120, formatter: '@', readOnly: true, cellType: 'tree'},
  813. {title: '名称', field: 'name', width: 230, formatter: '@', readOnly: true},
  814. {title: '单位', field: 'unit', width: 50, formatter: '@', readOnly: true}
  815. ],
  816. treeCol: 0,
  817. emptyRows: 0,
  818. headRows: 1,
  819. headRowHeight: [40],
  820. defaultRowHeight: 21,
  821. });
  822. stdChapter.loadLib(1);
  823. }
  824. stdChapter.spread.refresh();
  825. } else if (tab.attr('content') === '#std-bills') {
  826. if (!stdBills) {
  827. stdBills = new stdLib($('#std-bills-spread')[0], 'bills', {
  828. id: 'bill_id',
  829. pid: 'pid',
  830. order: 'order',
  831. level: 'level',
  832. rootId: -1,
  833. keys: ['id', 'list_id', 'bill_id']
  834. }, {
  835. cols: [
  836. {title: '清单编号', field: 'code', width: 120, formatter: '@', readOnly: true, cellType: 'tree'},
  837. {title: '名称', field: 'name', width: 230, formatter: '@', readOnly: true},
  838. {title: '单位', field: 'unit', width: 50, formatter: '@', readOnly: true}
  839. ],
  840. treeCol: 0,
  841. emptyRows: 0,
  842. headRows: 1,
  843. headRowHeight: [40],
  844. defaultRowHeight: 21,
  845. });
  846. stdBills.loadLib(1);
  847. }
  848. stdBills.spread.refresh();
  849. } else if (tab.attr('content') === '#deal-bills') {
  850. if (!dealBills) {
  851. dealBills = new DealBills($('#deal-bills-spread')[0], {
  852. cols: [
  853. {title: '清单编号', field: 'code', width: 120, formatter: '@', readOnly: true},
  854. {title: '名称', field: 'name', width: 230, formatter: '@', readOnly: true},
  855. {title: '单位', field: 'unit', width: 50, formatter: '@', readOnly: true},
  856. {title: '单价', field: 'unit_price', width: 50, readOnly: true},
  857. {title: '数量', field: 'quantity', width: 50, readOnly: true},
  858. ],
  859. emptyRows: 0,
  860. headRows: 1,
  861. headRowHeight: [40],
  862. defaultRowHeight: 21,
  863. });
  864. dealBills.loadData();
  865. }
  866. dealBills.spread.refresh();
  867. } else if (tab.attr('content') === '#search' && !searchLedger) {
  868. if (!searchLedger) {
  869. searchLedger = new SearchLedger($('#search'), {
  870. cols: [
  871. {title: '项目节编号', field: 'code', width: 120, formatter: '@', readOnly: true},
  872. {title: '清单编号', field: 'b_code', width: 120, formatter: '@', readOnly: true},
  873. {title: '名称', field: 'name', width: 230, formatter: '@', readOnly: true},
  874. {title: '单位', field: 'unit', width: 50, formatter: '@', readOnly: true},
  875. {title: '单价', field: 'unit_price', width: 50, readOnly: true},
  876. {title: '数量', field: 'quantity', width: 50, readOnly: true},
  877. ],
  878. emptyRows: 3,
  879. headRows: 1,
  880. headRowHeight: [40],
  881. defaultRowHeight: 21,
  882. });
  883. }
  884. searchLedger.spread.refresh();
  885. }
  886. } else { // 收起工具栏
  887. tab.removeClass('active');
  888. showSideTools(tab.hasClass('active'));
  889. tabPanel.hide();
  890. }
  891. ledgerSpread.refresh();
  892. posSpread.refresh();
  893. });
  894. class stdLib {
  895. constructor(obj, stdType, treeSetting, spreadSetting) {
  896. this.obj = obj;
  897. this.url = '/std/' + stdType;
  898. this.treeSetting = treeSetting;
  899. treeSetting.preUrl = this.url;
  900. this.spreadSetting = spreadSetting;
  901. this.spread = SpreadJsObj.createNewSpread(this.obj);
  902. SpreadJsObj.initSheet(this.spread.getActiveSheet(), this.spreadSetting);
  903. this.spread.getActiveSheet().bind(GC.Spread.Sheets.Events.CellDoubleClick, function (e, info) {
  904. const stdSheet = info.sheet;
  905. const mainSheet = ledgerSpread.getActiveSheet();
  906. if (!stdSheet.zh_setting || !stdSheet.zh_tree || !mainSheet.zh_tree) { return; }
  907. const stdTree = stdSheet.zh_tree;
  908. const stdNode = stdTree.nodes[info.row];
  909. const mainTree = mainSheet.zh_tree;
  910. const sel = mainSheet.getSelections()[0];
  911. const mainNode = mainTree.nodes[sel.row];
  912. if (!stdNode) { return; }
  913. mainTree.postData('/tender/' + getTenderId() + '/ledger/add-by-std', mainNode, {
  914. tender_id: mainNode.tender_id,
  915. stdType: stdType,
  916. stdLibId: stdNode.list_id,
  917. stdNode: stdTree.getNodeKey(stdNode)
  918. }, function (result) {
  919. treeOperationObj.refreshTree(mainSheet, result);
  920. treeOperationObj.refreshOperationValid(mainSheet, mainSheet.getSelections());
  921. });
  922. });
  923. this.pathTree = createNewPathTree('base', this.treeSetting);
  924. }
  925. loadLib (listId) {
  926. const self = this;
  927. postData(this.url+'/get-data', {list_id: listId}, function (data) {
  928. self.pathTree.loadDatas(data);
  929. SpreadJsObj.loadSheetData(self.spread.getActiveSheet(), 'tree', self.pathTree);
  930. });
  931. }
  932. }
  933. class DealBills {
  934. constructor (obj, spreadSetting) {
  935. const self = this;
  936. this.obj = obj;
  937. this.url = '/tender/' + getTenderId() + '/deal';
  938. this.spreadSetting = spreadSetting;
  939. this.spread = SpreadJsObj.createNewSpread(this.obj);
  940. SpreadJsObj.initSheet(this.spread.getActiveSheet(), this.spreadSetting);
  941. $('#upload-deal-bills').click(function () {
  942. const file = $('#deal-bills-file')[0];
  943. const formData = new FormData();
  944. formData.append('file', file.files[0]);
  945. postDataWithFile(self.url+'/upload-excel', formData, function (data) {
  946. SpreadJsObj.loadSheetData(self.spread.getActiveSheet(), 'data', data);
  947. $('#upload-deal').modal('hide');
  948. }, function () {
  949. $('#upload-deal').modal('hide');
  950. });
  951. });
  952. }
  953. loadData () {
  954. const self = this;
  955. postData(this.url+'/get-data', {}, function (data) {
  956. this.data = data;
  957. SpreadJsObj.loadSheetData(self.spread.getActiveSheet(), 'data', data);
  958. });
  959. }
  960. }
  961. class BatchInsertBillsPosObj {
  962. constructor (obj) {
  963. const self = this;
  964. this.obj = obj;
  965. this.billsCount = 6;
  966. this.posCount = 1000;
  967. // 初始化 清单编号窗口 参数
  968. this.qdSpreadSetting = {
  969. cols: [
  970. {title: '编号', field: 'code', width: 80, formatter: '@'},
  971. {title: '名称', field: 'name', width: 120, formatter: '@'},
  972. {title: '单位', field: 'unit', width: 50, formatter: '@'},
  973. {title: '单价', field: 'unit_price', width: 50},
  974. {title: '图册号', field: 'name', width: 60, formatter: '@'},
  975. ],
  976. emptyRows: this.billsCount,
  977. headRows: 1,
  978. headRowHeight: [40],
  979. };
  980. this.qdSpread = SpreadJsObj.createNewSpread($('.batch-l-t', this.obj)[0]);
  981. // 初始化 部位数量复核表 参数
  982. this.posSpreadSetting = {
  983. cols: [
  984. {title: '部位', field: 'bw', width: 80, formatter: '@'},
  985. {title: '图册号', field: 'drawingCode', formatter: '@', width: 60},
  986. ],
  987. emptyRows: this.posCount,
  988. headRows: 1,
  989. headRowHeight: [40],
  990. };
  991. for (let iNum = 1; iNum <= this.billsCount; iNum++) {
  992. this.posSpreadSetting.cols.push(
  993. {title: '清单' + iNum, field: 'bills' + iNum, width: 50}
  994. )
  995. }
  996. this.posSpread = SpreadJsObj.createNewSpread($('.batch-l-b', this.obj)[0]);
  997. // 初始化 清单编号、部位数量复核表 表格
  998. this.initView();
  999. // 初始化 签约清单 参数
  1000. this.dealSpreadSetting = {
  1001. cols: [
  1002. {title: '清单编号', field: 'code', width: 80, formatter: '@', readOnly: true},
  1003. {title: '名称', field: 'name', width: 120, formatter: '@', readOnly: true},
  1004. {title: '单位', field: 'unit', width: 50, formatter: '@', readOnly: true},
  1005. {title: '单价', field: 'unit_price', width: 50, readOnly: true},
  1006. ],
  1007. emptyRows: 0,
  1008. headRows: 1,
  1009. headRowHeight: [40],
  1010. };
  1011. this.dealSpread = SpreadJsObj.createNewSpread($('.batch-r', this.obj)[0]);
  1012. SpreadJsObj.initSheet(this.dealSpread.getActiveSheet(), this.dealSpreadSetting);
  1013. // 拉取签约清单数据
  1014. if (dealBills) {
  1015. SpreadJsObj.loadSheetData(this.dealSpread.getActiveSheet(), 'data', dealBills.data);
  1016. } else {
  1017. postData('/tender/' + getTenderId() + '/deal/get-data', {}, function (data) {
  1018. SpreadJsObj.loadSheetData(self.dealSpread.getActiveSheet(), 'data', data);
  1019. });
  1020. }
  1021. // 双击签约清单,自动添加到清单编号窗口
  1022. this.dealSpread.bind(GC.Spread.Sheets.Events.CellDoubleClick, function (e, info) {
  1023. const deal = info.sheet.zh_data[info.row];
  1024. const sel = self.gclSpread.getActiveSheet().getSelections()[0];
  1025. self.qdSpread.getActiveSheet().getCell(sel.row, 0).value(deal.code);
  1026. self.qdSpread.getActiveSheet().getCell(sel.row, 1).value(deal.name);
  1027. self.qdSpread.getActiveSheet().getCell(sel.row, 2).value(deal.unit);
  1028. self.qdSpread.getActiveSheet().getCell(sel.row, 3).value(deal.unit_price);
  1029. if (sel.row + 1 === self.gclSpread.getActiveSheet().getRowCount()) {
  1030. const count = sel.row + 2;
  1031. self.qdSpread.getActiveSheet().setRowCount(count);
  1032. self.qdSpread.getActiveSheet().getCell(sel.row + 1, 0, GC.Spread.Sheets.SheetArea.rowHeader).text('清单' + count);
  1033. const colCount = self.posSpread.getActiveSheet().getColumnCount() + 1
  1034. self.posSpread.getActiveSheet().setColumnCount(colCount);
  1035. self.posSpread.getActiveSheet().getCell(0, colCount - 1, GC.Spread.Sheets.SheetArea.colHeader).text('数量' + count);
  1036. }
  1037. self.qdSpread.getActiveSheet().setSelection(sel.row + 1, sel.col, 1, 1);
  1038. });
  1039. this.obj.bind('shown.bs.modal', function () {
  1040. self.qdSpread.refresh();
  1041. self.posSpread.refresh();
  1042. self.dealSpread.refresh();
  1043. });
  1044. $('#batch-ok').click(function () {
  1045. const sheet = ledgerSpread.getActiveSheet();
  1046. const selection = sheet.getSelections();
  1047. const row = selection[0].row;
  1048. const select = ledgerTree.nodes[row];
  1049. if (select) {
  1050. const insertData = {};
  1051. insertData.batchType = (select.code && select.code !== '') ? 'child' : 'next';
  1052. insertData.id = select[ledgerTree.setting.id];
  1053. insertData.batchData = self.getBatchData();
  1054. postData('/tender/' + getTenderId() + '/ledger/batch-insert', insertData, function (data) {
  1055. pos.updateDatas(data.pos);
  1056. ledgerTree.loadPostData(data.ledger, function (result) {
  1057. treeOperationObj.refreshTree(sheet, result);
  1058. treeOperationObj.refreshOperationValid(sheet, selection);
  1059. });
  1060. self.obj.modal('hide');
  1061. });
  1062. }
  1063. });
  1064. }
  1065. // 初始化左侧表格
  1066. initView () {
  1067. // 初始化 清单编号
  1068. const qdSheet = this.qdSpread.getActiveSheet();
  1069. SpreadJsObj.initSheet(qdSheet, this.qdSpreadSetting);
  1070. // 清理原有数据
  1071. SpreadJsObj.beginMassOperation(qdSheet);
  1072. qdSheet.clear(0, 0, qdSheet.getRowCount(), qdSheet.getColumnCount(), GC.Spread.Sheets.SheetArea.viewport, GC.Spread.Sheets.StorageType.data);
  1073. for (let iRow = 1; iRow <= this.billsCount; iRow ++) {
  1074. qdSheet.getCell(iRow - 1, 0, GC.Spread.Sheets.SheetArea.rowHeader).text('清单' + iRow);
  1075. }
  1076. SpreadJsObj.endMassOperation(qdSheet);
  1077. // 初始化 部位数量复核表
  1078. const posSheet = this.posSpread.getActiveSheet();
  1079. SpreadJsObj.initSheet(posSheet, this.posSpreadSetting);
  1080. // 清理原有数据
  1081. SpreadJsObj.beginMassOperation(posSheet);
  1082. posSheet.setColumnWidth(0, 45, GC.Spread.Sheets.SheetArea.rowHeader);
  1083. posSheet.clear(0, 0, posSheet.getRowCount(), posSheet.getColumnCount(), GC.Spread.Sheets.SheetArea.viewport, GC.Spread.Sheets.StorageType.data);
  1084. SpreadJsObj.endMassOperation(posSheet);
  1085. }
  1086. // 获取界面数据
  1087. getBatchData () {
  1088. const result = [];
  1089. const qdSheet = this.qdSpread.getActiveSheet(), posSheet = this.posSpread.getActiveSheet();
  1090. for (let iRow = 0; iRow < qdSheet.getRowCount(); iRow++) {
  1091. if (qdSheet.getText(iRow, 0) === '') { continue; }
  1092. const qd = {
  1093. b_code: qdSheet.getText(iRow, 0),
  1094. name: qdSheet.getText(iRow, 1),
  1095. unit: qdSheet.getText(iRow, 2),
  1096. price: _.toNumber(qdSheet.getText(iRow, 3)),
  1097. pos: [],
  1098. };
  1099. result.push(qd);
  1100. for (let iPosRow = 0; iPosRow < posSheet.getRowCount(); iPosRow++) {
  1101. const value = _.toNumber(posSheet.getText(iPosRow, iRow + 2));
  1102. if (value !== 0 && !isNaN(value)) {
  1103. qd.pos.push({
  1104. name: posSheet.getText(iPosRow, 0),
  1105. drawing_code: posSheet.getText(iPosRow, 1),
  1106. quantity: value,
  1107. });
  1108. }
  1109. }
  1110. }
  1111. return result;
  1112. }
  1113. }
  1114. class SearchLedger {
  1115. constructor(obj, spreadSetting) {
  1116. const self = this;
  1117. this.obj = obj;
  1118. this.url = '/ledger/search';
  1119. this.spreadSetting = spreadSetting;
  1120. this.spread = SpreadJsObj.createNewSpread($('#search-result', this.obj)[0]);
  1121. SpreadJsObj.initSheet(this.spread.getActiveSheet(), this.spreadSetting);
  1122. $('#searchLedger', this.obj).bind('click', function () {
  1123. const data = { keyword: $('input', self.obj).val() };
  1124. postData(preUrl + '/ledger/search', data, function (result) {
  1125. SpreadJsObj.loadSheetData(self.spread.getActiveSheet(), 'data', result);
  1126. });
  1127. });
  1128. this.spread.getActiveSheet().bind(GC.Spread.Sheets.Events.CellDoubleClick, function (e, info) {
  1129. const sheet = info.sheet;
  1130. const data = sheet.zh_data;
  1131. if (!data) { return }
  1132. const curBills = data[info.row];
  1133. if (!curBills) { return }
  1134. const mainSheet = ledgerSpread.getActiveSheet();
  1135. const mainTree = mainSheet.zh_tree;
  1136. mainTree.postData('locate', null, {id: curBills.ledger_id}, function (result) {
  1137. treeOperationObj.refreshTree(mainSheet, result);
  1138. treeOperationObj.refreshOperationValid(mainSheet, mainSheet.getSelections());
  1139. SpreadJsObj.locateTreeNode(mainSheet, curBills.ledger_id);
  1140. });
  1141. });
  1142. }
  1143. }
  1144. $('#searchAccount').click(() => {
  1145. const data = {
  1146. keyword: $('#searchName').val(),
  1147. }
  1148. postData('/search/user', data, (data) => {
  1149. const resultDiv = $('#searchResult');
  1150. $('h5>span', resultDiv).text(data.name);
  1151. $('#addAuditor').attr('auditorId', data.id);
  1152. $('h6', resultDiv).text(data.role);
  1153. $('p', resultDiv).text(data.company);
  1154. resultDiv.show();
  1155. }, () => {
  1156. $('#searchResult').hide();
  1157. });
  1158. });
  1159. $('#addAuditor').click(() => {
  1160. const data = {
  1161. auditorId: $('#addAuditor').attr('auditorId'),
  1162. };
  1163. console.log(data);
  1164. postData('/tender/' + getTenderId() + '/ledger/audit/add', data, (data) => {
  1165. const html = [];
  1166. html.push('<li class="list-group-item" auditorId="'+ data.audit_id +'"><a href="javascript: void(0)" class="text-danger pull-right">移除</a>');
  1167. html.push('<span>');
  1168. html.push(data.audit_order + ' ');
  1169. html.push(data.name + ' ');
  1170. html.push('</span>');
  1171. html.push('<small class="text-muted">');
  1172. html.push(data.role);
  1173. html.push('</small></li>');
  1174. $('#auditors').append(html.join(''));
  1175. });
  1176. });
  1177. $('li>a', '#auditors').bind('click', function () {
  1178. const li = $(this).parent();
  1179. const data = {
  1180. auditorId: parseInt(li.attr('auditorId')),
  1181. };
  1182. postData('/tender/' + getTenderId() + '/ledger/audit/delete', data, (data) => {
  1183. li.remove();
  1184. for (const a of data) {
  1185. const aLi = $('li[auditorId=' + a.audit_id + ']');
  1186. $('span', aLi).text(a.audit_order + ' ' + a.name + ' ');
  1187. }
  1188. });
  1189. });
  1190. // 选择excel文件后,加载全部sheet
  1191. $('#upload-ledger-file').change(function () {
  1192. if (this.files.length === 0) {
  1193. $('#upload-ledger-sheets').html('').hide();
  1194. return;
  1195. }$('#upload-ledger-sheets').hide();
  1196. try {
  1197. xlsxUtils.import(this.files[0], (excelData) => {
  1198. if (excelData.SheetNames.length > 0) {
  1199. const html = [];
  1200. html.push('<label for="exampleFormControlFile1">勾选要导入的工作簿</label>');
  1201. html.push('<div class="form-control">')
  1202. for (const iName in excelData.SheetNames) {
  1203. const name = excelData.SheetNames[iName];
  1204. html.push('<div class="form-group form-check">');
  1205. html.push('<input type="radio" class="form-check-input" name="sheetName"', (iName == 0 ? ' checked=""' : ''), ' value="' + name + '"', '>');
  1206. html.push('<label class="form-check-label" for="ledger-dgn-qty">', name, '</label>');
  1207. html.push('</div>');
  1208. }
  1209. html.push('</div>');
  1210. $('#upload-ledger-sheets').html(html.join('')).show();
  1211. } else {
  1212. toast('选择的Excel无有效数据,请重新选择', 'hint');
  1213. $('#upload-ledger-sheets').hide();
  1214. }
  1215. });
  1216. } catch(err) {
  1217. toast('加载excel异常,请刷新当前页面', 'error');
  1218. $('#upload-ledger-sheets').hide();
  1219. }
  1220. });
  1221. // 上传excel内容,并导入
  1222. $('#upload-ledger-ok').click(function () {
  1223. const sheetName = $('input[name=sheetName]:checked').val();
  1224. if (sheetName) {
  1225. const sheet = {
  1226. rows: xlsxUtils.getSheetByName(sheetName, {header: 1}),
  1227. merge: xlsxUtils._wb.Sheets[sheetName]["!merges"]
  1228. };
  1229. postDataCompress(window.location.pathname + '/upload-excel', sheet, function (result) {
  1230. ledgerTree.loadDatas(result.bills);
  1231. treeCalc.calculateAll(ledgerTree);
  1232. SpreadJsObj.loadSheetData(ledgerSpread.getActiveSheet(), 'tree', ledgerTree);
  1233. pos.loadDatas(result.pos);
  1234. posOperationObj.loadCurPosData();
  1235. $('#upload-ledger').modal('hide');
  1236. });
  1237. }
  1238. });
  1239. $('#upload-ledger').bind('hidden.bs.modal', function () {
  1240. $('#upload-ledger-file').val('');
  1241. $('#upload-ledger-sheets').html('');
  1242. });
  1243. });