std_bills_lib.js 15 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407
  1. /**
  2. * Standard Bills Lib
  3. * Created by Mai on 2017/5/16.
  4. */
  5. var billsLibObj = {
  6. stdBillsSpread: null,
  7. stdBillsJobSpread: null,
  8. stdBillsFeatureSpread: null,
  9. refreshSettingForHint: function () {
  10. TREE_SHEET_HELPER.initSetting($('#stdBillsSpread')[0], billsLibObj.stdBillsTreeSetting);
  11. },
  12. checkBillsSpread: function () {
  13. if (!this.stdBillsSpread) {
  14. this.stdBillsSpread = SheetDataHelper.createNewSpread($('#stdBillsSpread')[0]);
  15. // 刷新setting中记录的spread的位置
  16. this.refreshSettingForHint();
  17. }
  18. },
  19. refreshBillsSpread: function () {
  20. if (this.stdBillsSpread) {
  21. this.stdBillsSpread.refresh();
  22. }
  23. },
  24. checkBillsRelaSpread: function () {
  25. if (!this.stdBillsJobSpread) {
  26. this.stdBillsJobSpread = SheetDataHelper.createNewSpread($('#stdBillsJobs')[0]);
  27. }
  28. if (!this.stdBillsFeatureSpread) {
  29. this.stdBillsFeatureSpread = SheetDataHelper.createNewSpread($('#stdBillsFeatures')[0]);
  30. }
  31. },
  32. refreshBillsRelaSpread: function () {
  33. if (this.stdBillsJobSpread) {
  34. this.stdBillsJobSpread.refresh();
  35. }
  36. if (this.stdBillsFeatureSpread) {
  37. this.stdBillsFeatureSpread.refresh();
  38. }
  39. },
  40. clearHighLight: function (spread) {
  41. if (spread) {
  42. let sheet = spread.getActiveSheet();
  43. sheet.suspendPaint();
  44. sheet.getRange(0, -1, sheet.getRowCount(), -1, GC.Spread.Sheets.SheetArea.viewport).backColor(undefined);
  45. sheet.resumePaint();
  46. }
  47. },
  48. setTagForHint: function (datas) {
  49. let sheet = this.stdBillsSpread.getActiveSheet();
  50. sheet.suspendPaint();
  51. sheet.suspendEvent();
  52. for(let i = 0, len = sheet.getRowCount(); i < len; i++){
  53. sheet.setTag(i, 2, '');
  54. }
  55. for(let i = 0, len = datas.length; i < len; i++){
  56. sheet.setTag(i, 2, datas[i].ruleText ? datas[i].ruleText : '');
  57. }
  58. sheet.resumePaint();
  59. sheet.resumeEvent();
  60. },
  61. loadStdBillsLib: function () {
  62. let i, select = $('#stdBillsLibSelect');
  63. select.empty();
  64. let bills_lib = projectInfoObj.projectInfo.engineeringInfo.bill_lib;
  65. bills_lib.forEach(function (data) {
  66. var option = $('<option>').val(data.id).text(data.name);
  67. select.append(option);
  68. });
  69. if (select.children.length !== 0) {
  70. billsLibObj.loadStdBills(select.val());
  71. }
  72. },
  73. loadStdBills: function (stdBillsLibID) {
  74. var that = this;
  75. var stdBillsJobData, stdBillsFeatureData, stdBills;
  76. var stdBillsTree = idTree.createNew({id: 'ID', pid: 'ParentID', nid: 'NextSiblingID', rootId: -1, autoUpdate: true});
  77. var stdBillsTreeController = TREE_SHEET_CONTROLLER.createNew(stdBillsTree, billsLibObj.stdBillsSpread.getActiveSheet(), billsLibObj.stdBillsTreeSetting);
  78. var findData = function (value, field, Array) {
  79. var i = 0;
  80. for (i = 0; i < Array.length; i++) {
  81. if (value[field] === Array[i][field]) {
  82. return Array[i];
  83. }
  84. }
  85. return null;
  86. };
  87. let sortJobsAndFeatures = function (arr) {
  88. arr.sort(function (a, b) {
  89. let rst = 0;
  90. if(a.serialNo > b.serialNo) rst = 1;
  91. else if(a.serialNo < b.serialNo) rst = -1;
  92. return rst;
  93. });
  94. };
  95. var getBillsJobs = function (node) {
  96. var jobs = [], i, jobData = null;
  97. if (stdBillsJobData && node && node.data.jobs) {
  98. for (i = 0; i < node.data.jobs.length; i++) {
  99. jobData = findData(node.data.jobs[i], 'id', stdBillsJobData);
  100. if (jobData) {
  101. jobData.serialNo = node.data.jobs[i].serialNo;
  102. jobs.push(jobData);
  103. }
  104. }
  105. }
  106. sortJobsAndFeatures(jobs);
  107. return jobs;
  108. };
  109. var getBillsFeatures = function (node) {
  110. var features = [], i, featureData = null;
  111. if (stdBillsFeatureData && node && node.data.items) {
  112. for (i = 0; i < node.data.items.length; i++) {
  113. featureData = findData(node.data.items[i], 'id', stdBillsFeatureData);
  114. if (featureData) {
  115. featureData.serialNo = node.data.items[i].serialNo;
  116. features.push(featureData);
  117. }
  118. }
  119. }
  120. sortJobsAndFeatures(features);
  121. return features;
  122. };
  123. var showJobs = function (jobs) {
  124. SheetDataHelper.loadSheetHeader(billsLibObj.jobsSetting, billsLibObj.stdBillsJobSpread.getActiveSheet());
  125. SheetDataHelper.loadSheetData(billsLibObj.jobsSetting, billsLibObj.stdBillsJobSpread.getActiveSheet(), jobs);
  126. };
  127. var showFeatures = function (features) {
  128. SheetDataHelper.loadSheetHeader(billsLibObj.featuresSetting, billsLibObj.stdBillsFeatureSpread.getActiveSheet());
  129. SheetDataHelper.loadSheetData(billsLibObj.featuresSetting, billsLibObj.stdBillsFeatureSpread.getActiveSheet(), features);
  130. };
  131. var showJobsAndFeatures = function (node) {
  132. $('#stdBillsJobTab').show();
  133. $('#stdBillsRemarkTab').hide();
  134. billsLibObj.refreshBillsRelaSpread();
  135. billsLibObj.checkBillsRelaSpread();
  136. sortJobsAndFeatures(getBillsJobs(node));
  137. showJobs(getBillsJobs(node));
  138. showFeatures(getBillsFeatures(node));
  139. };
  140. var showBillsRemark = function (node) {
  141. $('#stdBillsJobTab').hide();
  142. $('#stdBillsRemarkTab').show();
  143. $('#stdBillsRemark').text(node && node.data.recharge ? node.data.recharge : '');
  144. };
  145. var showBillsRela = function (node) {
  146. if (node && node.children.length === 0) {
  147. showJobsAndFeatures(node);
  148. } else {
  149. showBillsRemark(node);
  150. }
  151. };
  152. CommonAjax.post('/stdBillsEditor/getJobContent', {userId: userID, billsLibId: stdBillsLibID}, function (datas) {
  153. stdBillsJobData = datas;
  154. }, function () {
  155. stdBillsJobData = [];
  156. });
  157. CommonAjax.post('/stdBillsEditor/getItemCharacter', {userId: userID, billsLibId: stdBillsLibID}, function (datas) {
  158. stdBillsFeatureData = datas;
  159. }, function () {
  160. stdBillsFeatureData = [];
  161. });
  162. CommonAjax.post('/stdBillsEditor/getBills', {userId: userID, billsLibId: stdBillsLibID}, function (datas) {
  163. stdBills = datas;
  164. stdBillsTree.loadDatas(stdBills);
  165. stdBillsTreeController.showTreeData();
  166. billsLibObj.setTagForHint(datas);
  167. showBillsRela(stdBillsTree.firstNode());
  168. stdBillsTreeController.bind(TREE_SHEET_CONTROLLER.eventName.treeSelectedChanged, showBillsRela);
  169. that.stdBillsSpread.unbind(GC.Spread.Sheets.Events.CellDoubleClick);
  170. that.stdBillsSpread.bind(GC.Spread.Sheets.Events.CellDoubleClick, function (sender, args) {
  171. let selectNode = stdBillsTree.items[args.row];
  172. if (stdBillsTree.items[args.row].children.length === 0) {
  173. //特征及内容转化
  174. pageCCOprObj.setItemContentNode(stdBillsTree.items[args.row], getBillsJobs(stdBillsTree.items[args.row]), getBillsFeatures(stdBillsTree.items[args.row]));
  175. if (/\//.test(selectNode.data.unit)) {
  176. let existB = projectObj.project.Bills.sameStdCodeBillsData(selectNode.data.code);
  177. if (existB) {
  178. let std = JSON.parse(JSON.stringify(selectNode.data));
  179. std.unit = existB.unit;
  180. ProjectController.addBills(projectObj.project, projectObj.mainController, std);
  181. } else {
  182. ConfirmModal.stdBillsUnit.check(selectNode.data, function (std) {
  183. ProjectController.addBills(projectObj.project, projectObj.mainController, std);
  184. });
  185. }
  186. } else {
  187. ProjectController.addBills(projectObj.project, projectObj.mainController, selectNode.data);
  188. }
  189. }
  190. });
  191. }, function () {
  192. that.stdBillsSpread.unbind(GC.Spread.Sheets.Events.CellDoubleClick);
  193. });
  194. $('#stdBillsSearch>span>button').click(function () {
  195. var keyword = $('#stdBillsSearch>input').val();
  196. if (!keyword || keyword === '') {return}
  197. var result = stdBillsTree.items.filter(function (item) {
  198. var codeIs = item.data.code ? item.data.code.indexOf(keyword) !== -1 : false;
  199. var nameIs = item.data.name ? item.data.name.indexOf(keyword) !== -1 : false;
  200. return codeIs || nameIs;
  201. });
  202. result.sort(function (x, y) {
  203. return x.serialNo() - y.serialNo();
  204. });
  205. if (result.length !== 0) {
  206. var sel = billsLibObj.stdBillsSpread.getActiveSheet().getSelections();
  207. stdBillsTreeController.setTreeSelected(result[0]);
  208. billsLibObj.stdBillsSpread.getActiveSheet().setSelection(result[0].serialNo(), sel[0].col, 1, 1);
  209. for (let node of result) {
  210. billsLibObj.stdBillsSpread.getActiveSheet().getRange(node.serialNo(), -1, 1, -1).backColor('lemonChiffon');
  211. }
  212. $('#nextStdBills').show();
  213. $('#nextStdBills').click(function () {
  214. var cur = stdBillsTree.selected, resultIndex = result.indexOf(cur), sel = billsLibObj.stdBillsSpread.getActiveSheet().getSelections();
  215. if (resultIndex === result.length - 1) {
  216. stdBillsTreeController.setTreeSelected(result[0]);
  217. billsLibObj.stdBillsSpread.getActiveSheet().setSelection(result[0].serialNo(), sel[0].col, 1, 1);
  218. } else {
  219. stdBillsTreeController.setTreeSelected(result[resultIndex + 1]);
  220. billsLibObj.stdBillsSpread.getActiveSheet().setSelection(result[resultIndex + 1].serialNo(), sel[0].col, 1, 1);
  221. }
  222. });
  223. } else {
  224. billsLibObj.clearHighLight(billsLibObj.stdBillsSpread);
  225. $('#nextStdBills').hide();
  226. }
  227. $('#stdBillsSearchResultCount').text('搜索结果:' + result.length);
  228. $('#stdBillsSearchResult').show();
  229. });
  230. },
  231. stdBillsTreeSetting: {
  232. "treeCol": 0,
  233. "emptyRows":0,
  234. "headRows":1,
  235. "headRowHeight":[
  236. 40
  237. ],
  238. "defaultRowHeight": 21,
  239. "cols":[{
  240. "width":160,
  241. "readOnly": true,
  242. "head":{
  243. "titleNames":["项目编码"],
  244. "spanCols":[1],
  245. "spanRows":[1],
  246. "vAlign":[1],
  247. "hAlign":[1],
  248. "font":["Arial"]
  249. },
  250. "data":{
  251. "field":"code",
  252. "vAlign":1,
  253. "hAlign":0,
  254. "font":"Arial"
  255. }
  256. }, {
  257. "width":220,
  258. "readOnly": true,
  259. "head":{
  260. "titleNames":["项目名称"],
  261. "spanCols":[1],
  262. "spanRows":[1],
  263. "vAlign":[1],
  264. "hAlign":[1],
  265. "font":["Arial"]
  266. },
  267. "data":{
  268. "field":"name",
  269. "vAlign":1,
  270. "hAlign":0,
  271. "font":"Arial"
  272. }
  273. }, {
  274. "width":50,
  275. "readOnly": true,
  276. "showHint": true,
  277. "head":{
  278. "titleNames":["计量单位"],
  279. "spanCols":[1],
  280. "spanRows":[1],
  281. "vAlign":[1],
  282. "hAlign":[1],
  283. "font":["Arial"],
  284. "wordWrap": true
  285. },
  286. "data":{
  287. "field":"unit",
  288. "vAlign":1,
  289. "hAlign":1,
  290. "font":"Arial"
  291. }
  292. }/*, {
  293. "width":100,
  294. "readOnly": true,
  295. "showHint": true,
  296. "head":{
  297. "titleNames":["工程量计算规则"],
  298. "spanCols":[1],
  299. "spanRows":[1],
  300. "vAlign":[1],
  301. "hAlign":[1],
  302. "font":["Arial"]
  303. },
  304. "data":{
  305. "field":"ruleText",
  306. "vAlign":1,
  307. "hAlign":0,
  308. "font":"Arial"
  309. }
  310. }*/]
  311. },
  312. jobsSetting: {
  313. "emptyRows":0,
  314. "headRows":1,
  315. "headRowHeight":[25],
  316. "defaultRowHeight": 21,
  317. "cols":[{
  318. "width":160,
  319. "readOnly":true,
  320. "head":{
  321. "titleNames":["工作内容"],
  322. "spanCols":[1],
  323. "spanRows":[1],
  324. "vAlign":[1],
  325. "hAlign":[1],
  326. "font":["Arial"]
  327. },
  328. "data":{
  329. "field":"content",
  330. "vAlign":0,
  331. "hAlign":3,
  332. "font":"Arial"
  333. }
  334. }]
  335. },
  336. featuresSetting: {
  337. "emptyRows":0,
  338. "headRows":1,
  339. "headRowHeight":[25],
  340. "defaultRowHeight": 21,
  341. "cols":[{
  342. "width":160,
  343. "readOnly":true,
  344. "head":{
  345. "titleNames":["项目特征"],
  346. "spanCols":[1],
  347. "spanRows":[1],
  348. "vAlign":[1],
  349. "hAlign":[1],
  350. "font":["Arial"]
  351. },
  352. "data":{
  353. "field":"content",
  354. "vAlign":0,
  355. "hAlign":3,
  356. "font":"Arial"
  357. }
  358. }]
  359. }
  360. };
  361. function addEventOnResize(fn){
  362. let originFn = window.onresize;
  363. window.onresize =function () {
  364. originFn && originFn();
  365. fn();
  366. }
  367. }
  368. addEventOnResize(billsLibObj.refreshSettingForHint);
  369. $('#stdBillsTab').bind('click', function () {
  370. refreshSubSpread();//subSpread、jobSpread、itemSpread显示问题
  371. $(".main-data-side-q").height($(window).height() - $(".header").height() - $(".toolsbar").height() - $(".tools-bar-height-q").height() - 202);
  372. var select = $('#stdBillsLibSelect');
  373. billsLibObj.refreshBillsSpread();
  374. billsLibObj.refreshBillsRelaSpread();
  375. billsLibObj.checkBillsSpread();
  376. if (select[0].options.length === 0) {
  377. billsLibObj.loadStdBillsLib();
  378. };
  379. });
  380. $('#stdBillsLibSelect').change(function () {
  381. $('#stdBillsSearchResult').hide();
  382. $(".main-data-side-q").height($(window).height() - $(".header").height() - $(".toolsbar").height() - $(".tools-bar-height-q").height() - 202);
  383. billsLibObj.clearHighLight(billsLibObj.stdBillsSpread);
  384. var select = $(this);
  385. if (this.children.length !== 0) {
  386. billsLibObj.loadStdBills(select.val());
  387. }
  388. });
  389. // 关闭搜索结果
  390. $('#closeSearchStdBills').click(function () {
  391. $('#stdBillsSearchResult').hide();
  392. $(".main-data-side-q").height($(window).height() - $(".header").height() - $(".toolsbar").height() - $(".tools-bar-height-q").height() - 202);
  393. billsLibObj.clearHighLight(billsLibObj.stdBillsSpread);
  394. });