exportSEIInterface.js 14 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368
  1. /**
  2. * Created by zhang on 2019/5/20.
  3. */
  4. let exportUtil = {
  5. setEngineerPriceIndex:function (tender,projectData) {
  6. let priceIndex = {
  7. name:"工程造价指标",
  8. attrs:[],
  9. children:[],
  10. };
  11. let fixMap = {};
  12. let buildingArea = this.getBuildArea(tender.property.engineerFeatures); //tender.property.projectFeature?getItemValueBykey(tender.property.projectFeature,"buildingArea"):1;//建筑面积
  13. for(let b of projectData.bills){
  14. if(b.flags && b.flags.length > 0){
  15. let f = _.find(b.flags,{"fieldName":"fixed"});
  16. if(f) fixMap[f.flag] = this.getTotalFee(b);
  17. }
  18. }
  19. //计算其他组织措施费 = 施工组织措施项目下的子项,除了 安全文明施工费、建设工程竣工档案编制费以外的项
  20. let CONSTRUCTION_ORGANIZATION = fixMap[fixedFlag.CONSTRUCTION_ORGANIZATION]?fixMap[fixedFlag.CONSTRUCTION_ORGANIZATION]:0;
  21. let SAFETY_CONSTRUCTION = fixMap[fixedFlag.SAFETY_CONSTRUCTION]?fixMap[fixedFlag.SAFETY_CONSTRUCTION]:0;
  22. let PROJECT_COMPLETE_ARCH_FEE = fixMap[fixedFlag.PROJECT_COMPLETE_ARCH_FEE]? fixMap[fixedFlag.PROJECT_COMPLETE_ARCH_FEE]:0;
  23. let other_org_fee = CONSTRUCTION_ORGANIZATION - SAFETY_CONSTRUCTION - PROJECT_COMPLETE_ARCH_FEE;
  24. other_org_fee = other_org_fee >0 ?other_org_fee:0;
  25. let engineerCost = fixMap[fixedFlag.ENGINEERINGCOST]?fixMap[fixedFlag.ENGINEERINGCOST]:1;
  26. priceIndex.children.push(this.getFlag("分部分项工程费",fixMap[fixedFlag.SUB_ENGINERRING],engineerCost,buildingArea));
  27. priceIndex.children.push(this.getFlag("技术措施费",fixMap[fixedFlag.CONSTRUCTION_TECH],engineerCost,buildingArea));
  28. priceIndex.children.push(this.getFlag("安全文明施工费",fixMap[fixedFlag.SAFETY_CONSTRUCTION],engineerCost,buildingArea));
  29. priceIndex.children.push(this.getFlag("建设工程竣工档案编制费",fixMap[fixedFlag.PROJECT_COMPLETE_ARCH_FEE],engineerCost,buildingArea));
  30. priceIndex.children.push(this.getFlag("其他组织措施费",other_org_fee,engineerCost,buildingArea));
  31. priceIndex.children.push(this.getFlag("暂列金额",fixMap[fixedFlag.PROVISIONAL],engineerCost,buildingArea));
  32. priceIndex.children.push(this.getFlag("专业工程暂估价",fixMap[fixedFlag.ENGINEERING_ESITIMATE],engineerCost,buildingArea));
  33. priceIndex.children.push(this.getFlag("计日工",fixMap[fixedFlag.DAYWORK],engineerCost,buildingArea));
  34. priceIndex.children.push(this.getFlag("总承包服务费",fixMap[fixedFlag.TURN_KEY_CONTRACT],engineerCost,buildingArea));
  35. priceIndex.children.push(this.getFlag("索赔与现场签证",fixMap[fixedFlag.CLAIM_VISA],engineerCost,buildingArea));
  36. priceIndex.children.push(this.getFlag("规费",fixMap[fixedFlag.CHARGE],engineerCost,buildingArea));
  37. priceIndex.children.push(this.getFlag("税金",fixMap[fixedFlag.TAX],engineerCost,buildingArea));
  38. priceIndex.children.push(this.getFlag("工程造价",fixMap[fixedFlag.ENGINEERINGCOST],engineerCost,buildingArea));
  39. return priceIndex;
  40. },
  41. getTotalFee:function (b) {
  42. let total = 0;
  43. if(b.fees && b.fees.length > 0){
  44. let common = _.find(b.fees,{"fieldName":"common"});
  45. if(common) total = scMathUtil.roundForObj(common.totalFee,getDecimal("bills.totalPrice"))
  46. }
  47. return total;
  48. },
  49. getFlag: function (name,totalCost,engineerCost,buildingArea) {
  50. totalCost = totalCost?totalCost:0;
  51. let flag = {
  52. name:name,
  53. attrs:[
  54. {name: "金额", value: scMathUtil.roundToString(totalCost,3)},
  55. {name: "单方造价", value: scMathUtil.roundToString(exportUtil.calcUnitB(totalCost,buildingArea),2)},
  56. {name: "占造价比例", value: scMathUtil.roundToString(totalCost/engineerCost * 100,2)},
  57. ],
  58. };
  59. return flag;
  60. },
  61. getBuildArea:function (features) {
  62. if(features){
  63. let areas = [];
  64. for(let f of features){
  65. if(f.index == true && f.value && f.value !=="" && IsNumber(f.value)) areas.push(f.value);
  66. }
  67. return _.isEmpty(areas)?1:areas;
  68. }
  69. return 1
  70. },
  71. calcUnitB:function (total,building,coe,decimal = 3) {
  72. if(Array.isArray(building)){
  73. for(let b of building){
  74. total = scMathUtil.roundForObj(total/b,6);
  75. }
  76. }else {
  77. total = scMathUtil.roundForObj(total/building,6);
  78. }
  79. coe = coe?coe:1;
  80. return scMathUtil.roundForObj(total*coe,decimal);
  81. },
  82. calUnitWidthCoe:function (total) {
  83. let areas = exportUtil.getBuildArea(projectObj.project.property.engineerFeatures);
  84. let f = _.find(projectObj.project.property.engineerFeatures,{index:true});
  85. return f?exportUtil.calcUnitB(total,areas,f.coe):exportUtil.calcUnitB(total,areas);
  86. }
  87. };
  88. async function exportSEI(projectID) {
  89. let tenderProjects = [];
  90. let result = await ajaxPost("/project/getSEIProjects",{projectID:projectID});
  91. console.log(result);
  92. let project = getProject(result);
  93. await prepareTenderDatas(tenderProjects,project);
  94. toXml(project);
  95. function getProject(orignal) {//取建设项目信息
  96. let basicInformation = getBaseInfo(orignal);
  97. let project = {
  98. name: "建设项目",
  99. attrs: [
  100. {name: "项目名称", value: orignal.name},
  101. {name:"建设单位",value:getItemValueBykey(basicInformation.items,"constructionUnit")},
  102. {name:"施工单位",value:getItemValueBykey(basicInformation.items,"buildingUnit")},
  103. {name: "标准名称", value: "重庆市建设工程造价指标采集标准(清单计价)"},
  104. {name: "标准版本号", value: "1.1"}
  105. ],
  106. basicInformation:basicInformation,
  107. children:[]
  108. };
  109. initAtts(project.attrs);
  110. for(let c of orignal.children){
  111. project.children.push(getEngineering(c));
  112. }
  113. return project;
  114. }
  115. function getEngineering(source){
  116. let engineer = {
  117. name:"单项工程",
  118. attrs:[
  119. {name: "名称", value: source.name}
  120. ],
  121. children:[]
  122. };
  123. for(let c of source.children){
  124. let tenderProject = getTender(c);
  125. engineer.children.push(tenderProject);
  126. tenderProjects.push(tenderProject);
  127. }
  128. return engineer
  129. };
  130. function getTender(source) {
  131. let tender = {
  132. ID:source.ID,
  133. name:"单位工程",
  134. attrs:[
  135. {name: "名称", value: source.name}
  136. ],
  137. children:[],
  138. valuationType:source.property.valuationType,
  139. taxType:source.property.taxType,
  140. property:source.property
  141. };
  142. return tender;
  143. }
  144. async function prepareTenderDatas(tenders,project) {
  145. for(let t of tenders){
  146. await setTenderData(t,project);
  147. }
  148. }
  149. async function setTenderData(tender,project) {
  150. let projectData = await ajaxPost("/project/loadSEIProjectData",{projectID:tender.ID});
  151. tender.children.push(setEngineerInfo(tender,project));//设置工程信息
  152. tender.children.push(setEngineerIndex(tender,projectData));
  153. tender.children.push(await setGLJSummy(tender,projectData));
  154. //
  155. }
  156. function setEngineerIndex(tender,projectData) {//设置工程指标
  157. let index = {
  158. name:"工程指标",
  159. attrs:[],
  160. children:[],
  161. };
  162. index.children.push(exportUtil.setEngineerPriceIndex(tender,projectData));
  163. return index;
  164. }
  165. async function setGLJSummy(tender,projectData) {
  166. let gljs = {
  167. name:"人材机汇总",
  168. attrs:[],
  169. children:[]
  170. };
  171. setGLJDetail(projectData,tender.property,gljs);
  172. return gljs;
  173. }
  174. function setGLJDetail(projectData,property,gljs) {
  175. if(projectData){
  176. gljUtil.calcProjectGLJQuantity(projectData.projectGLJs,projectData.ration_gljs,projectData.rations,projectData.bills,getDecimal("glj.quantity"),_,scMathUtil);
  177. }
  178. for(let g of projectData.projectGLJs.gljList) {
  179. if (!g.quantity || g.quantity == "") continue;
  180. g.marketPrice = gljUtil.getMarketPrice(g,projectData.projectGLJs,property.calcOptions,property.decimal,false,_,scMathUtil);
  181. gljs.children.push(setEachGLJ(g));
  182. }
  183. }
  184. function setEachGLJ(source){
  185. let g = {
  186. name:"人材机",
  187. attrs:[
  188. {name: "代码", value: source.code},
  189. {name: "名称", value: source.name},
  190. {name: "规格型号", value: source.specs},
  191. {name: "单位", value: source.unit},
  192. {name: "市场单价", value: source.marketPrice},
  193. {name: "数量", value: source.quantity},
  194. {name: "类型", value: source.type},
  195. {name: "产地", value: source.originPlace},
  196. {name: "厂家", value: source.vender},
  197. {name: "备注", value: source.remark}
  198. ]
  199. };
  200. return g;
  201. }
  202. function setEngineerInfo(tender,project) {//设置工程信息
  203. let baseInfo = project.basicInformation;
  204. let calcType ={"bill":"工程量清单计价","ration":"定额计价"};
  205. let info = {
  206. name:"工程信息",
  207. attrs:[
  208. {name:"造价编制单位",value:getItemValueBykey(baseInfo.items,"establishmentUnit")},
  209. {name:"造价审核单位",value:getItemValueBykey(baseInfo.items,"auditUnit")},
  210. {name:"项目负责人",value:""},
  211. {name:"施工单位编制人员",value:""},
  212. {name:"编制人员",value:""},
  213. {name:"审核人员",value:""},
  214. {name:"开工日期",value:""},
  215. {name:"竣工日期",value:""},
  216. {name:"工程地点",value:""},
  217. {name:"工程类型",value:""},
  218. {name:"合同价类型",value:""},
  219. {name:"造价类型",value:""},
  220. {name:"计价方式及依据",value:calcType[tender.valuationType]},
  221. {name:"工程类别",value:""},
  222. {name:"编制日期",value:""},
  223. {name:"审查日期",value:""}
  224. ]
  225. };
  226. initAtts(info.attrs);
  227. return info;
  228. }
  229. //造价编制单位="" 造价审核单位="" 项目负责人="" 施工单位编制人员="" 编制人员="" 审核人员="" 开工日期="" 竣工日期="" 工程地点="" 工程类型="" 合同价类型="" 造价类型="" 计价方式及依据="" 工程类别="" 编制日期="" 计税方法="一般计税"
  230. function getBaseInfo(project){
  231. let basicInformation = {items:[]};
  232. let tem = null;
  233. if(project.property&&project.property.basicInformation) tem =_.find(project.property.basicInformation,{"key":"basicInfo"});
  234. if(tem) basicInformation = tem;
  235. return basicInformation;
  236. }
  237. function getItemValueBykey(items,key) {
  238. let item = _.find(items,{"key":key});
  239. if(item) return item.value;
  240. return ""
  241. }
  242. function initAtts(arrs) {
  243. _.remove(arrs,function (item) {
  244. return item.required == false && _.isEmpty(item.value)
  245. })
  246. }
  247. //开始标签
  248. function startTag(ele) {
  249. let rst = `<${ele.name}`;
  250. for (let attr of ele.attrs) {
  251. rst += ` ${attr.name}="${ attr.value!=undefined&&attr.value!= null?attr.value:""}"`;
  252. }
  253. rst += ele.children&&ele.children.length > 0 ? '>' : '/>';
  254. return rst;
  255. }
  256. //结束标签
  257. function endTag(ele) {
  258. return `</${ele.name}>`;
  259. }
  260. //拼接成xml字符串
  261. function toXMLStr(eles) {
  262. let rst = '';
  263. for (let ele of eles) {
  264. rst += startTag(ele);
  265. if (ele.children&& ele.children.length > 0) {
  266. rst += toXMLStr(ele.children);
  267. rst += endTag(ele);
  268. }
  269. }
  270. return rst;
  271. }
  272. //格式化xml字符串
  273. function formatXml(text) {
  274. //去掉多余的空格
  275. text = '\n' + text.replace(/>\s*?</g, ">\n<");
  276. //调整格式
  277. let rgx = /\n(<(([^\?]).+?)(?:\s|\s*?>|\s*?(\/)>)(?:.*?(?:(?:(\/)>)|(?:<(\/)\2>)))?)/mg;
  278. let nodeStack = [];
  279. let output = text.replace(rgx, function($0, all, name, isBegin, isCloseFull1, isCloseFull2, isFull1, isFull2){
  280. let isClosed = (isCloseFull1 === '/') || (isCloseFull2 === '/' ) || (isFull1 === '/') || (isFull2 === '/');
  281. let prefix = '';
  282. if (isBegin === '!') {
  283. prefix = getPrefix(nodeStack.length);
  284. } else {
  285. if (isBegin !== '/') {
  286. prefix = getPrefix(nodeStack.length);
  287. if (!isClosed) {
  288. nodeStack.push(name);
  289. }
  290. } else {
  291. nodeStack.pop();
  292. prefix = getPrefix(nodeStack.length);
  293. }
  294. }
  295. let ret = '\n' + prefix + all;
  296. return ret;
  297. });
  298. let outputText = output.substring(1);
  299. return outputText;
  300. function getPrefix(prefixIndex) {
  301. let span = ' ';
  302. let output = [];
  303. for (let i = 0 ; i < prefixIndex; ++i) {
  304. output.push(span);
  305. }
  306. return output.join('');
  307. }
  308. }
  309. /*
  310. * 导出数据
  311. * @param {Number}tenderID(当前界面的单位工程ID,后台根据这个单位工程,根据导出粒度去找其建设项目下相关数据)
  312. * @return {void}
  313. * */
  314. function toXml(eleData) {
  315. //转换成xml字符串
  316. let xmlStr = toXMLStr([eleData]);
  317. //加上xml声明
  318. xmlStr = `<?xml version="1.0" encoding="utf-8"?>${xmlStr}`;
  319. //格式化
  320. xmlStr = formatXml(xmlStr);
  321. let blob = new Blob([xmlStr], {type: 'text/plain;charset=utf-8'});
  322. saveAs(blob, '经济指标.ZBF');
  323. }
  324. }