std_bills_lib.js 21 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520
  1. /**
  2. * Standard Bills Lib
  3. * Created by Mai on 2017/5/16.
  4. */
  5. var billsLibObj = {
  6. stdBillsTree: null,
  7. stdBillsSpread: null,
  8. stdBillsJobSpread: null,
  9. stdBillsFeatureSpread: null,
  10. refreshSettingForHint: function () {
  11. TREE_SHEET_HELPER.initSetting($('#stdBillsSpread')[0], billsLibObj.stdBillsTreeSetting);
  12. },
  13. checkBillsSpread: function () {
  14. if (!this.stdBillsSpread) {
  15. this.stdBillsSpread = SheetDataHelper.createNewSpread($('#stdBillsSpread')[0]);
  16. sheetCommonObj.spreadDefaultStyle(this.stdBillsSpread);
  17. this.stdBillsSpread.getSheet(0).name('stdBillsLib_bills');
  18. // 刷新setting中记录的spread的位置
  19. this.refreshSettingForHint();
  20. }
  21. },
  22. refreshBillsSpread: function () {
  23. if (this.stdBillsSpread) {
  24. this.stdBillsSpread.refresh();
  25. }
  26. },
  27. checkBillsRelaSpread: function () {
  28. if (!this.stdBillsJobSpread) {
  29. this.stdBillsJobSpread = SheetDataHelper.createNewSpread($('#stdBillsJobs')[0]);
  30. sheetCommonObj.spreadDefaultStyle(this.stdBillsJobSpread);
  31. }
  32. if (!this.stdBillsFeatureSpread) {
  33. this.stdBillsFeatureSpread = SheetDataHelper.createNewSpread($('#stdBillsFeatures')[0]);
  34. sheetCommonObj.spreadDefaultStyle(this.stdBillsFeatureSpread);
  35. }
  36. },
  37. refreshBillsRelaSpread: function () {
  38. if (this.stdBillsJobSpread) {
  39. this.stdBillsJobSpread.refresh();
  40. }
  41. if (this.stdBillsFeatureSpread) {
  42. this.stdBillsFeatureSpread.refresh();
  43. }
  44. },
  45. clearHighLight: function (spread) {
  46. if (spread) {
  47. let sheet = spread.getActiveSheet();
  48. sheet.suspendPaint();
  49. let orgColor = optionsOprObj.getOption('COLOROPTS', 'DEFAULT').backColor;
  50. sheet.getRange(0, -1, sheet.getRowCount(), -1, GC.Spread.Sheets.SheetArea.viewport).backColor(orgColor);
  51. sheet.resumePaint();
  52. }
  53. },
  54. setTagForHint: function (nodes) {
  55. let sheet = this.stdBillsSpread.getActiveSheet();
  56. sheet.suspendPaint();
  57. sheet.suspendEvent();
  58. for(let node of nodes){
  59. sheet.setTag(node.serialNo(), 2, node.data.ruleText ? node.data.ruleText : '');
  60. }
  61. sheet.resumePaint();
  62. sheet.resumeEvent();
  63. },
  64. loadStdBillsLib: function () {
  65. let i, select = $('#stdBillsLibSelect');
  66. select.empty();
  67. let bills_lib = projectInfoObj.projectInfo.engineeringInfo.bill_lib;
  68. let selectedBillsLib = sessionStorage.getItem('stdBillsLib');
  69. bills_lib.forEach(function (data) {
  70. var option = $('<option>').val(data.id).text(data.name);
  71. if(selectedBillsLib && data.id == selectedBillsLib){
  72. option.attr('selected', 'selected');
  73. }
  74. select.append(option);
  75. });
  76. if (select.children.length !== 0) {
  77. billsLibObj.loadStdBills(select.val());
  78. }
  79. },
  80. sortJobsAndFeatures: function (arr) {
  81. arr.sort(function (a, b) {
  82. let rst = 0;
  83. if(a.serialNo > b.serialNo) rst = 1;
  84. else if(a.serialNo < b.serialNo) rst = -1;
  85. return rst;
  86. });
  87. },
  88. findData: function (value, field, Array) {
  89. var i = 0;
  90. for (i = 0; i < Array.length; i++) {
  91. if (value[field] == Array[i][field]) {
  92. return Array[i];
  93. }
  94. }
  95. return null;
  96. },
  97. getBillsJobs: function (stdBillsJobData, node) {
  98. var jobs = [], i, jobData = null;
  99. if (stdBillsJobData && node && node.data.jobs) {
  100. for (i = 0; i < node.data.jobs.length; i++) {
  101. jobData = this.findData(node.data.jobs[i], 'id', stdBillsJobData);
  102. if (jobData) {
  103. jobData.serialNo = node.data.jobs[i].serialNo;
  104. jobs.push(jobData);
  105. }
  106. }
  107. }
  108. this.sortJobsAndFeatures(jobs);
  109. return jobs;
  110. },
  111. getBillsFeatures: function (stdBillsFeatureData, node) {
  112. var features = [], i, featureData = null;
  113. if (stdBillsFeatureData && node && node.data.items) {
  114. for (i = 0; i < node.data.items.length; i++) {
  115. featureData = this.findData(node.data.items[i], 'id', stdBillsFeatureData);
  116. if (featureData) {
  117. featureData.serialNo = node.data.items[i].serialNo;
  118. features.push(featureData);
  119. }
  120. }
  121. }
  122. this.sortJobsAndFeatures(features);
  123. return features;
  124. },
  125. insertBills: function (stdBillsJobData, stdBillsFeatureData, node) {
  126. if(projectInfoObj.projectInfo.property.lockBills == true && projectObj.project.withinBillsLocked(projectObj.project.mainTree.selected)){
  127. return false;
  128. }
  129. $.bootstrapLoading.start();
  130. //设置清单备注
  131. if(node.parent && node.parent.data.recharge){
  132. node.data.comments = node.parent.data.recharge;
  133. }
  134. //特征及内容转化
  135. pageCCOprObj.setItemContentNode(node, this.getBillsJobs(stdBillsJobData, node), this.getBillsFeatures(stdBillsFeatureData, node), node.data.name);
  136. if (/\//.test(node.data.unit)) {
  137. let existB = projectObj.project.Bills.sameStdCodeBillsData(node.data.code);
  138. if (existB) {
  139. let std = JSON.parse(JSON.stringify(node.data));
  140. std.unit = existB.unit;
  141. let canAdd = ProjectController.addBills(projectObj.project, projectObj.mainController, std);
  142. if(canAdd === false && $.bootstrapLoading.isLoading()){
  143. $.bootstrapLoading.end();
  144. }
  145. } else {
  146. ConfirmModal.stdBillsUnit.check(node.data, function (std) {
  147. let canAdd = ProjectController.addBills(projectObj.project, projectObj.mainController, std);
  148. if(canAdd === false && $.bootstrapLoading.isLoading()){
  149. $.bootstrapLoading.end();
  150. }
  151. }, function () {
  152. if($.bootstrapLoading.isLoading()){
  153. $.bootstrapLoading.end();
  154. }
  155. });
  156. }
  157. } else {
  158. let canAdd = ProjectController.addBills(projectObj.project, projectObj.mainController, node.data);
  159. if(canAdd === false && $.bootstrapLoading.isLoading()){
  160. $.bootstrapLoading.end();
  161. }
  162. }
  163. return true;
  164. },
  165. loadStdBills: function (stdBillsLibID) {
  166. var that = this;
  167. var stdBillsJobData, stdBillsFeatureData, stdBills;
  168. if(that.stdBillsTree){
  169. that.stdBillsTree = null;
  170. }
  171. that.stdBillsTree = idTree.createNew({id: 'ID', pid: 'ParentID', nid: 'NextSiblingID', rootId: -1, autoUpdate: true});
  172. var stdBillsTreeController = TREE_SHEET_CONTROLLER.createNew(that.stdBillsTree, billsLibObj.stdBillsSpread.getActiveSheet(), billsLibObj.stdBillsTreeSetting);
  173. var showJobs = function (jobs) {
  174. SheetDataHelper.loadSheetHeader(billsLibObj.jobsSetting, billsLibObj.stdBillsJobSpread.getActiveSheet());
  175. SheetDataHelper.loadSheetData(billsLibObj.jobsSetting, billsLibObj.stdBillsJobSpread.getActiveSheet(), jobs);
  176. };
  177. var showFeatures = function (features) {
  178. SheetDataHelper.loadSheetHeader(billsLibObj.featuresSetting, billsLibObj.stdBillsFeatureSpread.getActiveSheet());
  179. SheetDataHelper.loadSheetData(billsLibObj.featuresSetting, billsLibObj.stdBillsFeatureSpread.getActiveSheet(), features);
  180. };
  181. var showJobsAndFeatures = function (node) {
  182. $('#stdBillsJobTab').show();
  183. $('#stdBillsRemarkTab').hide();
  184. billsLibObj.refreshBillsRelaSpread();
  185. billsLibObj.checkBillsRelaSpread();
  186. showJobs(billsLibObj.getBillsJobs(stdBillsJobData, node));
  187. showFeatures(billsLibObj.getBillsFeatures(stdBillsFeatureData, node));
  188. };
  189. var showBillsRemark = function (node) {
  190. $('#stdBillsJobTab').hide();
  191. $('#stdBillsRemarkTab').show();
  192. $('#stdBillsRemark').text(node && node.data.recharge ? node.data.recharge : '');
  193. };
  194. var showBillsRela = function (node) {
  195. if (node && node.children.length === 0) {
  196. showJobsAndFeatures(node);
  197. } else {
  198. showBillsRemark(node);
  199. }
  200. };
  201. $.bootstrapLoading.start();
  202. CommonAjax.post('/stdBillsEditor/getJobContent', {userId: userID, billsLibId: stdBillsLibID}, function (datas) {
  203. stdBillsJobData = datas;
  204. }, function () {
  205. stdBillsJobData = [];
  206. });
  207. CommonAjax.post('/stdBillsEditor/getItemCharacter', {userId: userID, billsLibId: stdBillsLibID}, function (datas) {
  208. stdBillsFeatureData = datas;
  209. }, function () {
  210. stdBillsFeatureData = [];
  211. });
  212. CommonAjax.post('/stdBillsEditor/getBills', {userId: userID, billsLibId: stdBillsLibID}, function (datas) {
  213. stdBills = datas;
  214. that.stdBillsTree.loadDatas(stdBills);
  215. //读取展开收起状态
  216. let currentExpState = sessionStorage.getItem('stdBillsLibExpState');
  217. if(currentExpState){
  218. that.stdBillsTree.setExpandedByState(that.stdBillsTree.items, currentExpState);
  219. }
  220. //非叶子节点默认收起
  221. else{
  222. that.stdBillsTree.setRootExpanded(that.stdBillsTree.roots, false);
  223. }
  224. stdBillsTreeController.showTreeData();
  225. billsLibObj.setTagForHint(that.stdBillsTree.items);
  226. showBillsRela(that.stdBillsTree.firstNode());
  227. stdBillsTreeController.bind(TREE_SHEET_CONTROLLER.eventName.treeSelectedChanged, showBillsRela);
  228. that.stdBillsSpread.unbind(GC.Spread.Sheets.Events.CellDoubleClick);
  229. that.stdBillsSpread.bind(GC.Spread.Sheets.Events.CellDoubleClick, function (sender, args) {
  230. let selectNode = that.stdBillsTree.items[args.row];
  231. let name = selectNode.data.name;
  232. if (that.stdBillsTree.items[args.row].children.length === 0) {
  233. billsLibObj.insertBills(stdBillsJobData, stdBillsFeatureData, selectNode);
  234. }
  235. else{
  236. let me = billsLibObj;
  237. let node = that.stdBillsTree.items[args.row];
  238. if (!node || node.children.length === 0)
  239. return;
  240. node.setExpanded(!node.expanded);
  241. //设置展开收起状态
  242. sessionStorage.setItem('stdBillsLibExpState', that.stdBillsTree.getExpState(that.stdBillsTree.items));
  243. TREE_SHEET_HELPER.massOperationSheet(args.sheet, function () {
  244. let iCount = node.posterityCount(), i, child;
  245. for (i = 0; i < iCount; i++) {
  246. child = that.stdBillsTree.items[args.row + i + 1];
  247. args.sheet.setRowVisible(args.row + i + 1, child.visible, args.sheetArea);
  248. }
  249. args.sheet.invalidateLayout();
  250. });
  251. args.sheet.repaint();
  252. }
  253. });
  254. $.bootstrapLoading.end();
  255. }, function () {
  256. that.stdBillsSpread.unbind(GC.Spread.Sheets.Events.CellDoubleClick);
  257. $.bootstrapLoading.end();
  258. });
  259. $('#stdBillsSearch>div>button').click(function () {
  260. billsLibObj.clearHighLight(billsLibObj.stdBillsSpread);
  261. var keyword = $('#stdBillsSearch>input').val();
  262. if (!keyword || keyword === '') {
  263. $('#stdBillsSearchResult').hide();
  264. return;
  265. }
  266. var result = that.stdBillsTree.items.filter(function (item) {
  267. var codeIs = item.data.code ? item.data.code.indexOf(keyword) !== -1 : false;
  268. var nameIs = item.data.name ? item.data.name.indexOf(keyword) !== -1 : false;
  269. return codeIs || nameIs;
  270. });
  271. result.sort(function (x, y) {
  272. return x.serialNo() - y.serialNo();
  273. });
  274. if (result.length !== 0) {
  275. //展开搜索出来的节点
  276. billsLibObj.expandSearchNodes(result);
  277. //设置记住展开
  278. sessionStorage.setItem('stdBillsLibExpState', that.stdBillsTree.getExpState(that.stdBillsTree.items));
  279. TREE_SHEET_HELPER.massOperationSheet(billsLibObj.stdBillsSpread.getActiveSheet(), function () {
  280. var sel = billsLibObj.stdBillsSpread.getActiveSheet().getSelections();
  281. stdBillsTreeController.setTreeSelected(result[0]);
  282. billsLibObj.stdBillsSpread.getActiveSheet().setSelection(result[0].serialNo(), sel[0].col, 1, 1);
  283. for (let node of result) {
  284. billsLibObj.stdBillsSpread.getActiveSheet().getRange(node.serialNo(), -1, 1, -1).backColor('lemonChiffon');
  285. }
  286. });
  287. billsLibObj.stdBillsSpread.getActiveSheet().showRow(result[0].serialNo(), GC.Spread.Sheets.VerticalPosition.bottom);
  288. $('#nextStdBills').show();
  289. $('#nextStdBills').unbind('click');
  290. $('#nextStdBills').bind('click', function () {
  291. var cur = that.stdBillsTree.selected, resultIndex = result.indexOf(cur), sel = billsLibObj.stdBillsSpread.getActiveSheet().getSelections();
  292. if (resultIndex === result.length - 1) {
  293. stdBillsTreeController.setTreeSelected(result[0]);
  294. billsLibObj.stdBillsSpread.getActiveSheet().setSelection(result[0].serialNo(), sel[0].col, 1, 1);
  295. billsLibObj.stdBillsSpread.getActiveSheet().showRow(result[0].serialNo(), GC.Spread.Sheets.VerticalPosition.top);
  296. } else {
  297. stdBillsTreeController.setTreeSelected(result[resultIndex + 1]);
  298. billsLibObj.stdBillsSpread.getActiveSheet().setSelection(result[resultIndex + 1].serialNo(), sel[0].col, 1, 1);
  299. billsLibObj.stdBillsSpread.getActiveSheet().showRow(result[resultIndex + 1].serialNo(), GC.Spread.Sheets.VerticalPosition.bottom);
  300. }
  301. });
  302. } else {
  303. billsLibObj.clearHighLight(billsLibObj.stdBillsSpread);
  304. $('#nextStdBills').hide();
  305. }
  306. $('#stdBillsSearchResultCount').text('搜索结果:' + result.length);
  307. $('#stdBillsSearchResult').show();
  308. });
  309. },
  310. expandSearchNodes: function(nodes){
  311. let that = this;
  312. TREE_SHEET_HELPER.massOperationSheet(billsLibObj.stdBillsSpread.getActiveSheet(), function () {
  313. function expParentNode(node){
  314. if(node.parent && !node.parent.expanded){
  315. node.parent.setExpanded(true);
  316. expParentNode(node.parent);
  317. }
  318. }
  319. for(let node of nodes){
  320. expParentNode(node);
  321. }
  322. TREE_SHEET_HELPER.refreshTreeNodeData(that.stdBillsTreeSetting, that.stdBillsSpread.getActiveSheet(), that.stdBillsTree.roots, true);
  323. TREE_SHEET_HELPER.refreshNodesVisible(that.stdBillsTree.roots, that.stdBillsSpread.getActiveSheet(), true);
  324. });
  325. },
  326. stdBillsTreeSetting: {
  327. "emptyRowHeader": true,
  328. "rowHeaderWidth": 15,
  329. "treeCol": 0,
  330. "emptyRows":0,
  331. "headRows":1,
  332. "headRowHeight":[
  333. 40
  334. ],
  335. "defaultRowHeight": 21,
  336. "cols":[{
  337. "width":140,
  338. "readOnly": true,
  339. "head":{
  340. "titleNames":["项目编码"],
  341. "spanCols":[1],
  342. "spanRows":[1],
  343. "vAlign":[1],
  344. "hAlign":[1],
  345. "font":["Arial"]
  346. },
  347. "data":{
  348. "field":"code",
  349. "vAlign":1,
  350. "hAlign":0,
  351. "font":"Arial"
  352. }
  353. }, {
  354. "width":190,
  355. "readOnly": true,
  356. "head":{
  357. "titleNames":["项目名称"],
  358. "spanCols":[1],
  359. "spanRows":[1],
  360. "vAlign":[1],
  361. "hAlign":[1],
  362. "font":["Arial"]
  363. },
  364. "data":{
  365. "field":"name",
  366. "vAlign":1,
  367. "hAlign":0,
  368. "font":"Arial"
  369. }
  370. }, {
  371. "width":45,
  372. "readOnly": true,
  373. "showHint": true,
  374. "head":{
  375. "titleNames":["计量单位"],
  376. "spanCols":[1],
  377. "spanRows":[1],
  378. "vAlign":[1],
  379. "hAlign":[1],
  380. "font":["Arial"],
  381. "wordWrap": true
  382. },
  383. "data":{
  384. "field":"unit",
  385. "vAlign":1,
  386. "hAlign":1,
  387. "font":"Arial"
  388. }
  389. }/*, {
  390. "width":100,
  391. "readOnly": true,
  392. "showHint": true,
  393. "head":{
  394. "titleNames":["工程量计算规则"],
  395. "spanCols":[1],
  396. "spanRows":[1],
  397. "vAlign":[1],
  398. "hAlign":[1],
  399. "font":["Arial"]
  400. },
  401. "data":{
  402. "field":"ruleText",
  403. "vAlign":1,
  404. "hAlign":0,
  405. "font":"Arial"
  406. }
  407. }*/]
  408. },
  409. jobsSetting: {
  410. "emptyRows":0,
  411. "headRows":1,
  412. "headRowHeight":[25],
  413. "defaultRowHeight": 21,
  414. "cols":[{
  415. "width":160,
  416. "readOnly":true,
  417. "head":{
  418. "titleNames":["工作内容"],
  419. "spanCols":[1],
  420. "spanRows":[1],
  421. "vAlign":[1],
  422. "hAlign":[1],
  423. "font":["Arial"]
  424. },
  425. "data":{
  426. "field":"content",
  427. "vAlign":0,
  428. "hAlign":3,
  429. "font":"Arial"
  430. }
  431. }]
  432. },
  433. featuresSetting: {
  434. "emptyRows":0,
  435. "headRows":1,
  436. "headRowHeight":[25],
  437. "defaultRowHeight": 21,
  438. "cols":[{
  439. "width":160,
  440. "readOnly":true,
  441. "head":{
  442. "titleNames":["项目特征"],
  443. "spanCols":[1],
  444. "spanRows":[1],
  445. "vAlign":[1],
  446. "hAlign":[1],
  447. "font":["Arial"]
  448. },
  449. "data":{
  450. "field":"content",
  451. "vAlign":0,
  452. "hAlign":3,
  453. "font":"Arial"
  454. }
  455. }]
  456. }
  457. };
  458. function addEventOnResize(fn){
  459. let originFn = window.onresize;
  460. window.onresize =function () {
  461. originFn && originFn();
  462. fn();
  463. }
  464. }
  465. addEventOnResize(billsLibObj.refreshSettingForHint);
  466. //赋初始高度
  467. if($('#stdBillsSpread').height() === 0 || $('#qd').find('.bottom-content').height() === 0){
  468. $('#stdBillsSpread').height($(window).height()-$(".header").height()-$(".toolsbar").height()-$(".tools-bar-height-q").height()-312);
  469. $('#qd').find('.bottom-content').find('.p-0').height(270);
  470. }
  471. $('#stdBillsTab').bind('click', function () {
  472. refreshSubSpread();//subSpread、jobSpread、itemSpread显示问题
  473. //$(".main-data-side-q").height($(window).height() - $(".header").height() - $(".toolsbar").height() - $(".tools-bar-height-q").height() - 202);
  474. var select = $('#stdBillsLibSelect');
  475. billsLibObj.refreshBillsSpread();
  476. billsLibObj.refreshBillsRelaSpread();
  477. billsLibObj.checkBillsSpread();
  478. if (select[0].options.length === 0) {
  479. billsLibObj.loadStdBillsLib();
  480. };
  481. });
  482. $('#stdBillsLibSelect').change(function () {
  483. $('#stdBillsSearchResult').hide();
  484. //$(".main-data-side-q").height($(window).height() - $(".header").height() - $(".toolsbar").height() - $(".tools-bar-height-q").height() - 202);
  485. billsLibObj.clearHighLight(billsLibObj.stdBillsSpread);
  486. var select = $(this);
  487. if (this.children.length !== 0) {
  488. //设置sessionStorage
  489. let billsLibId = select.val();
  490. sessionStorage.setItem('stdBillsLib', billsLibId);
  491. //清除展开收起状态sessionStorage
  492. sessionStorage.removeItem('stdBillsLibExpState');
  493. billsLibObj.loadStdBills(billsLibId);
  494. }
  495. });
  496. //搜索框回车
  497. $('#stdBillsSearch>input').bind('keypress', function (event) {
  498. if(event.keyCode === 13){
  499. $(this).blur();
  500. $('#stdBillsSearch>div>button').click();
  501. }
  502. });
  503. // 关闭搜索结果
  504. $('#closeSearchStdBills').click(function () {
  505. $('#stdBillsSearchResult').hide();
  506. $(".main-data-side-q").height($(window).height() - $(".header").height() - $(".toolsbar").height() - $(".tools-bar-height-q").height() - 202);
  507. billsLibObj.clearHighLight(billsLibObj.stdBillsSpread);
  508. billsLibObj.refreshBillsSpread();
  509. billsLibObj.refreshBillsRelaSpread();
  510. });