bill_facade.js 26 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593
  1. /**
  2. * Created by zhang on 2018/1/22.
  3. */
  4. let mongoose = require('mongoose');
  5. let projectConst = require('../models/project_consts');
  6. const rationType = projectConst.rationType;
  7. const rationKeyArray = projectConst.rationKeyArray;
  8. const gljKeyArray = projectConst.gljKeyArray;
  9. let quantity_detail = require("./quantity_detail_facade");
  10. let quantity_detail_model = mongoose.model('quantity_detail');
  11. let ration_glj_facade = require("../../ration_glj/facade/ration_glj_facade");
  12. let Bills_Lib = mongoose.model('std_bills_lib_bills');
  13. let ration_Model = mongoose.model('ration');
  14. let ration_glj_Model = mongoose.model('ration_glj');
  15. let ration_coe_Model = mongoose.model('ration_coe');
  16. const projectModel = mongoose.model('projects');
  17. let ration_installation_Model = mongoose.model('ration_installation');
  18. let ration_template_Model = mongoose.model('ration_template');
  19. let bill_Model = require('../models/bills').model;
  20. let billsLibDao = require("../../bills_lib/models/bills_lib_interfaces");
  21. const pmFacade = require('../../pm/facade/pm_facade');
  22. const { getSortedTreeData, getEngineeringFeeType } = require('../../../public/common_util');
  23. const { billType, constructionFeeNodeID, constructionEquipmentFeeNodeID, BudgetArea, fixedFlag, BudgetType } = require('../../../public/common_constants');
  24. const scMathUtil = require('../../../public/scMathUtil').getUtil();
  25. const uuidV1 = require('uuid/v1');
  26. const equipmentFacade = require('../../equipment_purchase/facade/equipment_purchase_facade');
  27. const gatherModel = mongoose.model('gather_calc_programs');
  28. const GLJController = require("../../glj/controllers/glj_controller");
  29. const GLJListModel = require('../../glj/models/glj_list_model');
  30. let _ = require("lodash");
  31. module.exports={
  32. getSectionInfo : async function (data) {
  33. let conditions=[];
  34. let fxList=[];
  35. let sectionInfo ={};
  36. for(let libID in data){
  37. let codes=[];
  38. let temp={};
  39. codes= _.keys(data[libID]);
  40. temp['billsLibId']=libID;
  41. temp['code'] = {"$in": codes};
  42. conditions.push(temp);
  43. }
  44. if(conditions.length>0){
  45. fxList = await Bills_Lib.find({"$or":conditions});
  46. }
  47. if(fxList.length>0){
  48. let sectionIDs = {};
  49. for(let f of fxList){
  50. if(f._doc.sectionInfo){
  51. f._doc.sectionInfo.first?sectionIDs[f._doc.sectionInfo.first]=true:"";
  52. f._doc.sectionInfo.second?sectionIDs[f._doc.sectionInfo.second]=true:"";
  53. f._doc.sectionInfo.third?sectionIDs[f._doc.sectionInfo.third]=true:"";
  54. }
  55. }
  56. let IDList = _.keys(sectionIDs);
  57. let sectionList = await Bills_Lib.find({'ID':{'$in':IDList}});
  58. let sectionMap = _.mapKeys(sectionList,'ID');
  59. let fxMap = _.mapKeys(fxList,'code');
  60. sectionInfo={
  61. fxMap:fxMap,
  62. sectionMap :sectionMap
  63. }
  64. return sectionInfo;
  65. }
  66. return null;
  67. },
  68. reorganizeFBFX:async function(data){
  69. let result = {};
  70. let tasks = generateBillTasks(data);
  71. if(data.delete && data.delete.length > 0){
  72. let qd_query={projectID: data.projectID, billID: {"$in": data.delete}};
  73. await quantity_detail.deleteByQuery(qd_query) ;
  74. }
  75. if(tasks.length > 0){
  76. result =await bill_Model.bulkWrite(tasks);
  77. }
  78. return result;
  79. },
  80. pasteBlock : async function(data,compilation){
  81. let pasteTasks = [
  82. pasteRationsAndRationGLJ(data.rations,data.ration_gljs,compilation),//这一步会花费比较多时间
  83. pasteOtherData(data)
  84. ];
  85. let [rationsAndRationGLJ,resultMap] = await Promise.all(pasteTasks);
  86. let gljController = new GLJController();
  87. // let projectGLJ = await gljController.getProjectGLJsByProjectID(data.projectID);
  88. resultMap.rations = rationsAndRationGLJ.rations;
  89. resultMap.ration_gljs = rationsAndRationGLJ.new_ration_gljs;
  90. resultMap.projectGLJList = rationsAndRationGLJ.projectGLJList;
  91. // resultMap.gljData = projectGLJ.data;
  92. return resultMap;
  93. },
  94. createNewBills:async function(newDatas){
  95. // billsLibDao.getStdBillsByCode 从这里取数据
  96. let results = [];
  97. for(let bills of newDatas){
  98. let stdB = await billsLibDao.getStdBillsByCode({billsLibId:bills.billsLibId,code:bills.billsLocation});
  99. if(stdB){
  100. stdB = JSON.parse(JSON.stringify(stdB));
  101. if(!bills.unit && /\//.test(stdB.unit)){
  102. bills.unit = stdB.unit.split(/\//)[0];
  103. }
  104. //处理项目特征和工作内容,现在默认都添加到项目特征列中
  105. stdB.itemCharacterText = "[项目特征]\n[工作内容]\n"+stdB.jobContentText;
  106. stdB.jobContentText="";
  107. bills = _.merge(stdB,bills);
  108. }
  109. delete bills.billsLocation;
  110. results.push(bills);
  111. }
  112. if(results.length > 0){
  113. await bill_Model.create(results);
  114. }
  115. return results;
  116. },
  117. insertBills: async function(datas) {
  118. let bulks = [];
  119. for (let data of datas) {
  120. if (data.updateType === 'update') {
  121. bulks.push({updateOne: {filter: {ID: data.updateData.ID}, update: {NextSiblingID: data.updateData.NextSiblingID}}});
  122. } else {
  123. bulks.push({insertOne: {document: data.updateData}});
  124. }
  125. }
  126. if (bulks.length > 0) {
  127. await bill_Model.bulkWrite(bulks);
  128. }
  129. },
  130. // 获取单位工程ID 工程费用(费用汇总里的totalFee) 映射表
  131. getUnitsBudgetMap: async function (unitIDs) {
  132. const rst = {};
  133. const gatherData = await gatherModel.find({ projectID: { $in: unitIDs } }, '-_id projectID totalFee').lean();
  134. const gatherMap = {};
  135. gatherData.forEach(item => gatherMap[item.projectID] = item.totalFee || 0);
  136. unitIDs.forEach(unitID => {
  137. rst[unitID] = gatherMap[unitID] || 0;
  138. });
  139. return rst;
  140. },
  141. // 获取设备购置费
  142. getUnitsEquipmentMap: async function (unitIDs) {
  143. return await equipmentFacade.getEquipmentTotalCost(unitIDs);
  144. },
  145. // 获取概算汇总初始化数据
  146. initialBudgetSummary: async function (constructionID) {
  147. const treeData = await this.getBudgetSummary(constructionID);
  148. const construction = await projectModel.findOne({ ID: constructionID }, { 'property.costGrowthRate': 1, 'property.growthPeriod': 1, 'property.budgetType': 1 }).lean();
  149. const costGrowthRate = construction && construction.property && construction.property.costGrowthRate || 0;
  150. const growthPeriod = construction && construction.property && construction.property.growthPeriod || 0;
  151. const budgetType = construction && construction.property && construction.property.budgetType || BudgetType.BUILDING;
  152. return {
  153. budgetType,
  154. treeData,
  155. costGrowthRate,
  156. growthPeriod,
  157. }
  158. },
  159. // 项目管理等需要获取概算汇总项目数据映射
  160. getBudgetSummaryInfo: async function (constructionIDs) {
  161. const map = {};
  162. const task = [];
  163. for (const constructionID of constructionIDs) {
  164. task.push(this.getBudgetSummary(constructionID, true));
  165. }
  166. const summaryResult = await Promise.all(task);
  167. summaryResult.forEach(items => {
  168. const constructionBudget = items.find(item => item.flags && item.flags[0] && item.flags[0].flag === fixedFlag.CONSTRUCTION_BUDGET);
  169. items.forEach(item => {
  170. if (item.orgProjectID) {
  171. map[item.orgProjectID] = item;
  172. if (item.projType === 'Project' && constructionBudget) {
  173. // 建设项目的总价需要取建设项目总概算
  174. map[item.orgProjectID].totalFee = constructionBudget.totalFee;
  175. map[item.orgProjectID].fees = constructionBudget.fees;
  176. }
  177. }
  178. });
  179. });
  180. return map;
  181. },
  182. // 获取概算汇总单项工程级别数据(拍好序的,报表接口用)
  183. getSinglesBudgetSummary: async function (constructionID) {
  184. const items = await this.getBudgetSummary(constructionID, true);
  185. // 去除建设项目层级
  186. items.shift();
  187. items.forEach(item => {
  188. // 方便报表取值处理
  189. if (item.projType === 'Engineering') {
  190. item.engineeringName = item.name || '';
  191. } else if (item.projType === 'Tender') {
  192. item.tenderName = item.name || '';
  193. }
  194. });
  195. return items;
  196. },
  197. // 获取概算汇总数据(拍好序的)
  198. // 如果isSimple为true,只进行工程费用部分汇总,只返回工程费用部分数据
  199. getBudgetSummary: async function (constructionID, isSimple = false) {
  200. // 获取建设项目清单数据(工程建设其他费用 - 建设项目总概算)部分
  201. let sortedOtherFeeBills = [];
  202. if (!isSimple) {
  203. const constructionOtherFeeBills = await bill_Model.find({ projectID: constructionID }).lean();
  204. sortedOtherFeeBills = getSortedTreeData('-1', constructionOtherFeeBills);
  205. sortedOtherFeeBills.forEach(item => item.area = BudgetArea.CONSTRUCTION_OTHER_FEE);
  206. } else {
  207. sortedOtherFeeBills = await bill_Model.find({ projectID: constructionID, 'flags.flag': fixedFlag.CONSTRUCTION_BUDGET }).lean();
  208. }
  209. // 获取工程费用数据
  210. const constructionFeeBills = await this.getConstructionFeeData(constructionID, (sortedOtherFeeBills[0] && sortedOtherFeeBills[0].ID) || '-1');
  211. // 汇算工程费用
  212. await this.summarizeData(constructionFeeBills);
  213. const rst = [...constructionFeeBills, ...sortedOtherFeeBills];
  214. const totalItem = rst.find(item => item.flags && item.flags[0] && item.flags[0].flag === fixedFlag.CONSTRUCTION_BUDGET);
  215. let totalFee = 0;
  216. if (totalItem) {
  217. const totalFeeItem = totalItem.fees && totalItem.fees.find(f => f.fieldName === 'common');
  218. totalFee = totalFeeItem ? +totalFeeItem.totalFee : 0;
  219. }
  220. // 方便报表取数据,规范数据
  221. rst.forEach(item => {
  222. item.code = item.code || '';
  223. item.name = item.name || '';
  224. item.unit = item.unit || '';
  225. item.quantity = item.quantity || '';
  226. const buildingFeeItem = item.fees && item.fees.find(f => f.fieldName === 'building');
  227. const installFeeItem = item.fees && item.fees.find(f => f.fieldName === 'installation');
  228. const equipmentFeeItem = item.fees && item.fees.find(f => f.fieldName === 'equipment');
  229. const otherFeeItem = item.fees && item.fees.find(f => f.fieldName === 'other');
  230. const totalFeeItem = item.fees && item.fees.find(f => f.fieldName === 'common');
  231. item.buildingFee = buildingFeeItem ? buildingFeeItem.totalFee : 0;
  232. item.installationFee = installFeeItem ? installFeeItem.totalFee : 0;
  233. item.equipmentFee = equipmentFeeItem ? equipmentFeeItem.totalFee : 0;
  234. item.otherFee = otherFeeItem ? otherFeeItem.totalFee : 0;
  235. item.totalFee = totalFeeItem ? totalFeeItem.totalFee : 0;
  236. item.unitFee = totalFeeItem ? totalFeeItem.unitFee : 0;
  237. // 计算占总投资比例
  238. const rate = totalFee ? scMathUtil.roundForObj(item.totalFee / totalFee, 4) : 0;
  239. item.rate = rate * 100; // 转换为百分比
  240. });
  241. return rst;
  242. },
  243. // 获取工程费用数据,作为概算汇总数据的拼接树数据
  244. getConstructionFeeData: async function (constructionID, nextID) {
  245. const projects = await pmFacade.getPosterityProjects([constructionID], true, { _id: 0, ID: 1, ParentID: 1, NextSiblingID: 1, name: 1, projType: 1, chapterCode: 1, sectionCode: 1, quantity: 1, unit: 1, 'property.engineeringName': 1});
  246. const construction = projects.find(p => p.ID === constructionID);
  247. const items = getSortedTreeData(construction.ParentID, projects);
  248. // 转换为uuid
  249. const IDMap = {};
  250. items.forEach((item, index) => {
  251. //保留项目ID
  252. item.orgProjectID = item.ID;
  253. if (index == 0) {
  254. IDMap[item.ID] = constructionFeeNodeID;
  255. } else {
  256. IDMap[item.ID] = uuidV1()
  257. }
  258. });
  259. // 将项目调整为工程费用数据
  260. let curConstructionID;
  261. let curSingleNo = 0;
  262. let curSingleID;
  263. let curUnitNo = 0;
  264. // let latestSingleNode;
  265. items.forEach((item, index) => {
  266. item.area = BudgetArea.CONSTRUCTION_FEE;
  267. item.ID = IDMap[item.ID];
  268. item.ParentID = IDMap[item.ParentID] || '-1';
  269. item.NextSiblingID = IDMap[item.NextSiblingID] || '-1';
  270. if (index === 0) {
  271. curConstructionID = item.ID;
  272. item.type = billType.DXFY;
  273. item.flags = [{ fieldName: 'fixed', flag: fixedFlag.CONSTRUCTION_FEE }];
  274. item.code = '1';
  275. item.name = '工程费用';
  276. item.NextSiblingID = nextID;
  277. } else {
  278. item.type = billType.BILL;
  279. if (item.ParentID === curConstructionID) {
  280. // latestSingleNode = item;
  281. curSingleNo += 1;
  282. curUnitNo = 0;
  283. curSingleID = item.ID;
  284. item.code = `1.${curSingleNo}`
  285. } else if (item.ParentID === curSingleID) {
  286. curUnitNo += 1;
  287. item.code = `1.${curSingleNo}.${curUnitNo}`
  288. }
  289. }
  290. });
  291. /* const constructionFeeNode = items[0];
  292. // 设备及工器具购置费
  293. const constructionEquipmentNode = {
  294. type: billType.BILL,
  295. area: BudgetArea.CONSTRUCTION_FEE,
  296. flags: [{ fieldName: 'fixed', flag: fixedFlag.CONSTRUCTION_EQUIPMENT_FEE }],
  297. ID: constructionEquipmentFeeNodeID,
  298. ParentID: constructionFeeNode.ID,
  299. NextSiblingID: '-1',
  300. code: `1.${curSingleNo + 1}`,
  301. name: '设备及工器具购置费',
  302. };
  303. latestSingleNode.NextSiblingID = constructionEquipmentNode.ID;
  304. items.push(constructionEquipmentNode); */
  305. return items;
  306. },
  307. // 汇算数据
  308. summarizeData: async function (items) {
  309. const processDecimal = 6;
  310. const construction = items.find(item => item.projType === pmFacade.projectType.project);
  311. if (!construction) {
  312. return;
  313. }
  314. const singles = items.filter(item => item.projType === pmFacade.projectType.engineering);
  315. const units = items.filter(item => item.projType === pmFacade.projectType.tender);
  316. if (!singles.length || !units.length) {
  317. return;
  318. }
  319. const unitProjectIDs = units.map(unit => unit.orgProjectID);
  320. // 获取第一个单位工程的小数位数(清单合价)
  321. const theUnit = await projectModel.findOne({ ID: unitProjectIDs[0] }, { _id: 0, 'property.decimal': 1 }).lean();
  322. const decimal = theUnit && theUnit.property && theUnit.property.decimal && theUnit.property.decimal.bills && theUnit.property.decimal.bills.totalPrice || 2;
  323. // 获取单位工程 -工程费用映射表
  324. const unitBudgetMap = await this.getUnitsBudgetMap(unitProjectIDs);
  325. // 获取单位工程 - 设备购置费映射表
  326. const unitEquipmentMap = await this.getUnitsEquipmentMap(unitProjectIDs);
  327. // 汇算
  328. const constructionFeeObj = { total: 0, building: 0, installation: 0, equipment: 0 };
  329. for (const single of singles) {
  330. const singleFeeObj = { total: 0, building: 0, installation: 0, equipment: 0 };
  331. const refUnits = units.filter(unit => unit.ParentID === single.ID);
  332. for (const unit of refUnits) {
  333. const unitFee = +unitBudgetMap[unit.orgProjectID]; // 费用汇总算出来的值
  334. const unitEquipmentFee = +unitEquipmentMap[unit.orgProjectID]; // 设备购置窗口的值
  335. const unitTotalFee = scMathUtil.roundForObj(unitFee + unitEquipmentFee, decimal); // 费用汇总算出来的值 + 设备购置值
  336. // 汇算到单项工程
  337. singleFeeObj.total = scMathUtil.roundForObj(singleFeeObj.total + unitTotalFee, processDecimal);
  338. singleFeeObj.equipment = scMathUtil.roundForObj(singleFeeObj.equipment + unitEquipmentFee, processDecimal);
  339. const unitFeeObj = { total: unitTotalFee || 0, building: 0, installation: 0, equipment: unitEquipmentFee || 0 };
  340. // 建筑工程费、安装工程费
  341. const feeType = getEngineeringFeeType(unit.property && unit.property.engineeringName || '');
  342. if (feeType) {
  343. unitFeeObj[feeType] = unitFee;
  344. singleFeeObj[feeType] = scMathUtil.roundForObj(singleFeeObj[feeType] + unitFee, processDecimal);
  345. }
  346. unit.fees = feeObj2Fees(unitFeeObj, unit.quantity);
  347. }
  348. single.fees = feeObj2Fees(singleFeeObj, single.quantity);
  349. // 汇算到建设项目
  350. constructionFeeObj.total = scMathUtil.roundForObj(constructionFeeObj.total + singleFeeObj.total, processDecimal);
  351. constructionFeeObj.building = scMathUtil.roundForObj(constructionFeeObj.building + singleFeeObj.building, processDecimal);
  352. constructionFeeObj.installation = scMathUtil.roundForObj(constructionFeeObj.installation + singleFeeObj.installation, processDecimal);
  353. constructionFeeObj.equipment = scMathUtil.roundForObj(constructionFeeObj.equipment + singleFeeObj.equipment, processDecimal);
  354. }
  355. construction.fees = feeObj2Fees(constructionFeeObj, construction.quantity);
  356. // 更新fees字段
  357. const bulks = [];
  358. items.forEach(item => {
  359. if (item.orgProjectID && item.fees) {
  360. bulks.push({
  361. updateOne: {
  362. filter: { ID: item.orgProjectID },
  363. update: { $set: { fees: item.fees } }
  364. }
  365. })
  366. }
  367. });
  368. if (bulks.length) {
  369. await projectModel.bulkWrite(bulks);
  370. }
  371. // 获取设备购置费(旧)
  372. /* const equipmentFee = await this.getEquipmentFee(unitProjectIDs);
  373. const equipmentItem = items.find(item => item.flags && item.flags[0] && item.flags[0].flag === fixedFlag.CONSTRUCTION_EQUIPMENT_FEE);
  374. const equipmentFeeObj = { fieldName: 'equipment', totalFee: equipmentFee };
  375. if (equipmentItem) {
  376. equipmentItem.fees = [equipmentFeeObj];
  377. }
  378. construction.fees.push(equipmentFeeObj); */
  379. function feeObj2Fees(feeObj, quantity) {
  380. const totalFee = scMathUtil.roundForObj(feeObj.total, decimal)
  381. let unitFee = 0;
  382. if (+quantity && totalFee) {
  383. unitFee = scMathUtil.roundForObj(totalFee / (+quantity), 2);
  384. }
  385. return [
  386. { fieldName: 'common', totalFee: scMathUtil.roundForObj(feeObj.total, decimal), unitFee },
  387. { fieldName: 'building', totalFee: scMathUtil.roundForObj(feeObj.building, decimal) },
  388. { fieldName: 'installation', totalFee: scMathUtil.roundForObj(feeObj.installation, decimal) },
  389. { fieldName: 'equipment', totalFee: scMathUtil.roundForObj(feeObj.equipment, decimal) },
  390. ];
  391. }
  392. },
  393. bulkOperation: async function (bulkData) {
  394. const bulks = [];
  395. const projectBulks = [];
  396. bulkData.forEach(item => {
  397. if (item.type === 'new') {
  398. bulks.push({
  399. insertOne: { document: item.data }
  400. });
  401. } else if (item.type === 'update') {
  402. bulks.push({
  403. updateOne: { filter: { ID: item.data.ID }, update: { $set: item.data } }
  404. });
  405. } else if (item.type === 'updateProject') {
  406. projectBulks.push({
  407. updateOne: { filter: { ID: item.data.ID }, update: { $set: item.data } }
  408. });
  409. } else {
  410. bulks.push({
  411. deleteOne: { filter: { ID: item.data.ID } }
  412. });
  413. }
  414. });
  415. if (bulks.length) {
  416. await bill_Model.bulkWrite(bulks);
  417. }
  418. if (projectBulks.length) {
  419. await projectModel.bulkWrite(projectBulks);
  420. }
  421. }
  422. };
  423. async function pasteOtherData(data) {
  424. let bills = data.bills;
  425. let quantity_details = data.quantity_details;
  426. let ration_coes = data.ration_coes;
  427. let ration_installations = data.ration_installations;
  428. let ration_templates = data.ration_templates;
  429. let updateData = data.updateData;
  430. let uModel = null;
  431. let tasks = [];
  432. //生成更新任务
  433. for(let u of updateData){
  434. if(u.type == "bills"){
  435. uModel = bill_Model;
  436. }else {
  437. uModel = ration_Model;
  438. }
  439. let tem = {
  440. updateOne:{
  441. filter:u.query,
  442. update :u.doc
  443. }
  444. };
  445. tasks.push(tem);
  446. }
  447. bills.length > 0 ? await insertMany(bills,bill_Model):'';
  448. quantity_details.length > 0 ? await insertMany(quantity_details,quantity_detail_model):'';
  449. ration_coes.length > 0 ? await insertMany(ration_coes,ration_coe_Model):'';
  450. ration_installations.length > 0 ? await insertMany(ration_installations,ration_installation_Model):'';
  451. ration_templates.length > 0? await insertMany(ration_templates,ration_template_Model):'';
  452. tasks.length>0?await uModel.bulkWrite(tasks):'';
  453. return {bills:bills,quantity_details:quantity_details,ration_coes:ration_coes,ration_installations:ration_installations,ration_templates:ration_templates,updateData:updateData}
  454. }
  455. async function pasteRationsAndRationGLJ (rations,ration_gljs,compilation) {
  456. let projectGljModel = new GLJListModel();
  457. let gljMap = {}, new_ration_gljs=[],projectID=null,projectGLJList =[];
  458. if(rations.length > 0) projectID = rations[0].projectID;
  459. if(projectID==null && ration_gljs.length > 0) projectID = ration_gljs[0].projectID;
  460. if(projectID == null) return {rations:rations,new_ration_gljs:new_ration_gljs};
  461. let [unitFileId,ext] = await ration_glj_facade.prepareExtData(projectID,compilation);
  462. //先根据定额类型的工料机,插入到项目工料机中
  463. for(let r of rations){
  464. if(r.type == rationType.gljRation){
  465. let projectGLJ = await getProjectGLJ(r,rationKeyArray,gljMap,unitFileId,ext);
  466. projectGLJList.push(projectGLJ);
  467. }
  468. }
  469. for(let rg of ration_gljs){
  470. let projectGLJ = await getProjectGLJ(rg,gljKeyArray,gljMap,unitFileId,ext);
  471. let temRecord = ration_glj_facade.createNewRecord(rg);
  472. rg.rcode?temRecord.rcode = rg.rcode:'';
  473. rg.hasOwnProperty("customQuantity")?temRecord.customQuantity = rg.customQuantity:'';
  474. new_ration_gljs.push(temRecord);
  475. projectGLJList.push(projectGLJ);
  476. }
  477. rations.length>0?await insertMany(rations,ration_Model):'';
  478. new_ration_gljs.length>0?await insertMany(new_ration_gljs,ration_glj_Model):'';
  479. return {rations:rations,new_ration_gljs:new_ration_gljs,projectGLJList:projectGLJList};
  480. async function getProjectGLJ (glj,keyArray,gljMap,unitFileId,ext) {
  481. let keyIndex = projectGljModel.getIndex(glj,keyArray);
  482. let pgljResult = null;
  483. if(gljMap[keyIndex]){
  484. pgljResult = gljMap[keyIndex]
  485. }else {
  486. let p_glj = ration_glj_facade.getGLJSearchInfo(glj);
  487. pgljResult = await projectGljModel.addList(p_glj,unitFileId,ext);//逐条添加到项目工料机
  488. gljMap[keyIndex] = pgljResult;
  489. }
  490. setResult(glj,pgljResult);
  491. return pgljResult
  492. }
  493. function setResult(glj,result ) {
  494. let typeString = result.type+'';
  495. glj.marketPrice = result.unit_price.market_price;
  496. glj.adjustPrice = result.unit_price.base_price;
  497. glj.basePrice = result.unit_price.base_price;
  498. glj.isAdd = result.unit_price.is_add;
  499. glj.projectGLJID = result.id;
  500. if (typeString.startsWith("2")||typeString=='4'||typeString=='5') {//只有材料类型才显示是否暂估
  501. glj.isEstimate = result.is_evaluate;
  502. }
  503. }
  504. }
  505. function generateBillTasks(data) {
  506. let tasks=[];
  507. let user_id = data.user_id,projectID = data.projectID;
  508. let deleteInfo={deleted: true, deleteDateTime: new Date(), deleteBy: user_id};
  509. if(data.delete && data.delete.length > 0){
  510. for(let d_ID of data.delete){
  511. //原先是假删除,现在改成真删除
  512. let task = {
  513. deleteOne:{
  514. filter:{
  515. ID:d_ID,
  516. projectID:projectID
  517. }
  518. }
  519. };
  520. /* let task={
  521. updateOne:{
  522. filter:{
  523. ID:d_ID,
  524. projectID:projectID
  525. },
  526. update :{
  527. deleteInfo:deleteInfo
  528. }
  529. }
  530. };*/
  531. tasks.push(task);
  532. }
  533. }
  534. if(data.update && data.update.length > 0){
  535. for(let u_data of data.update){
  536. let task ={
  537. updateOne:{
  538. filter : {
  539. ID:u_data.ID,
  540. projectID:projectID
  541. },
  542. update : u_data.data
  543. }
  544. };
  545. tasks.push(task);
  546. }
  547. }
  548. if(data.create && data.create.length > 0){
  549. for(let n_data of data.create){
  550. let task = {
  551. insertOne :{
  552. document:n_data
  553. }
  554. };
  555. tasks.push(task);
  556. }
  557. }
  558. return tasks;
  559. }
  560. async function insertMany(datas,model) {
  561. let tem = [];
  562. console.log(datas);
  563. while (datas.length>1000){//因为mongoose限制了批量插入的条数为1000.所以超出限制后需要分批插入
  564. let newList = datas.splice(0,1000);//一次插入1000条
  565. await model.insertMany(newList);
  566. tem = tem.concat(newList);
  567. }
  568. await model.insertMany(datas);
  569. if(tem.length > 0) datas.push(...tem);//还原数组
  570. }