pm_facade.js 74 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697169816991700170117021703170417051706170717081709171017111712171317141715171617171718171917201721172217231724172517261727172817291730173117321733173417351736173717381739174017411742174317441745174617471748174917501751175217531754175517561757175817591760176117621763176417651766176717681769177017711772177317741775177617771778177917801781178217831784178517861787178817891790179117921793
  1. /**
  2. * Created by zhang on 2018/4/17.
  3. */
  4. const projectType = {
  5. folder: 'Folder',
  6. tender: 'Tender',
  7. project: 'Project',
  8. engineering: 'Engineering',
  9. };
  10. //先导出后require可以解决循环引用问题
  11. module.exports={
  12. prepareShareList,
  13. getShareList,
  14. addShareList,
  15. updateShareList,
  16. deleteShareList,
  17. getShareInfoMap,
  18. getRecentShareList,
  19. moveProject:moveProject,
  20. copyProject:copyProject,
  21. copyExample: copyExample,
  22. setupSummaryFields: setupSummaryFields,
  23. getSummaryInfo: getSummaryInfo,
  24. getSummaryInfoByTender: getSummaryInfoByTender,
  25. getTendersFeeInfo: getTendersFeeInfo,
  26. getConstructionProject: getConstructionProject,
  27. getFullPath: getFullPath,
  28. getProjectFeature:getProjectFeature,
  29. getProgressiveInterval: getProgressiveInterval,
  30. projectType: projectType,
  31. getPosterityProjects: getPosterityProjects,
  32. isShare: isShare,
  33. isFirst: isFirst,
  34. getShareInfo: getShareInfo,
  35. prepareInitialData: prepareInitialData,
  36. changeFile:changeFile,
  37. checkFiles:checkFiles,
  38. copyForSectionError: copyForSectionError,
  39. exportProject:exportProject,
  40. importProject:importProject,
  41. uploadToken:uploadToken,
  42. downLoadProjectFile:downLoadProjectFile,
  43. importProcessChecking:importProcessChecking,
  44. isTenderOverrun,
  45. getWelcomeInfo:getWelcomeInfo
  46. };
  47. let mongoose = require('mongoose');
  48. let _ = require("lodash");
  49. let feeRate_facade = require('../../fee_rates/facade/fee_rates_facade');
  50. let glj_facade = require('../../glj/facade/glj_facade');
  51. let project_facade = require('../../main/facade/project_facade');
  52. let logger = require("../../../logs/log_helper").logger;
  53. const uuidV1 = require('uuid/v1');
  54. let projectModel = mongoose.model('projects');
  55. let projectSettingModel = mongoose.model('proj_setting');
  56. let billsModel = mongoose.model('bills');
  57. let rationModel = mongoose.model('ration');
  58. let gljListModel = mongoose.model("glj_list");
  59. let calcProgramsModel = mongoose.model('calc_programs');
  60. let labourCoesModel = mongoose.model('labour_coes');
  61. let feeRateModel = mongoose.model('fee_rates');
  62. let feeRateFileModel = mongoose.model('fee_rate_file');
  63. let unitPriceFileModel = mongoose.model("unit_price_file");
  64. let mixRatioModel = mongoose.model("mix_ratio");
  65. let freightModel = mongoose.model("freight_calc");
  66. let originalModel = mongoose.model("original_calc");
  67. let comElectrovalenceModel = mongoose.model("com_electrovalence");
  68. let unitPriceModel = mongoose.model("unit_price");
  69. let installationFeeModel = mongoose.model("installation_fee");
  70. let rationGLJModel = mongoose.model('ration_glj');
  71. let rationCoeModel = mongoose.model('ration_coe');
  72. let rationInstallationModel = mongoose.model('ration_installation');
  73. let quantityDetailModel = mongoose.model('quantity_detail');
  74. let rationTemplateModel = mongoose.model('ration_template');
  75. let userModel = mongoose.model('user');
  76. let compleGljSectionModel = mongoose.model('complementary_glj_section');
  77. let compleGljSectionTModel = mongoose.model('complementary_glj_section_templates');
  78. let progressiveModel = mongoose.model('std_progressive_lib');
  79. let importLogsModel = mongoose.model("import_logs");
  80. const shareListModel = mongoose.model('share_list');
  81. let welcomeModel = mongoose.model("welcome_setting");
  82. let featureLibModel = mongoose.model("std_project_feature_lib");
  83. let scMathUtil = require('../../../public/scMathUtil').getUtil();
  84. let counter = require('../../../public/counter/counter');
  85. import SectionTreeDao from '../../complementary_ration_lib/models/sectionTreeModel';
  86. let sectionTreeDao = new SectionTreeDao();
  87. import CounterModel from "../../glj/models/counter_model";
  88. import moment from 'moment-timezone';
  89. import billsFlags from '../../common/const/bills_fixed';
  90. const notDeleted = [{deleteInfo: null}, {'deleteInfo.deleted': false}];
  91. let cipher = require('../../../public/cipher');
  92. const compilationModel = mongoose.model('compilation');
  93. let qiniu = require("qiniu");
  94. let fs = require("fs");
  95. let path = require("path");
  96. let request = require("request");
  97. const systemSettingMiddleware = require('../../main/middleware/system_setting');
  98. let qiniu_config = {
  99. "AccessKey": "_gR1ed4vi1vT2G2YITGSf4_H0fJu_nRS9Tzk3T4z",
  100. "SecretKey": "ty4zd0FHqgEDaiVzSLC8DfHlai99aS7bspLkw6s6",
  101. "Bucket": "yun-update",
  102. "Domain": "http://serverupdate.smartcost.com.cn"
  103. };
  104. let mac = new qiniu.auth.digest.Mac(qiniu_config.AccessKey, qiniu_config.SecretKey);
  105. // 重构了分享的数据结构,原本存在projects表的shareInfo数组中
  106. // 为了更好地适应新功能及以后拓展功能,现将分享信息存放在单独的share_list表中
  107. // 为了适应旧数据,需要在share_list没有数据的时候,将原本的分享信息复制到share_list中,同时生成联系人
  108. // TODO: 上线后这个方法执行过后,应该删除此方法
  109. async function prepareShareList() {
  110. const shareListCount = await shareListModel.count({});
  111. console.log(shareListCount);
  112. if (shareListCount) {
  113. return;
  114. }
  115. logger.info('================================enterPrepareShareList================================================');
  116. // 将项目的shareInfo数据复制到share_list表中
  117. const projects = await projectModel.find({'shareInfo.0': {$exists: true}}, '-_id ID userID shareInfo').lean();
  118. if (!projects.length) {
  119. return;
  120. }
  121. const shareList = [];
  122. const userMap = {}; // 给生成联系人做准备
  123. projects.forEach(project => {
  124. const ownerContacts = userMap[project.userID] || (userMap[project.userID] = []);
  125. project.shareInfo.forEach(shareItem => {
  126. if (!shareItem.shareDate) {
  127. return;
  128. }
  129. const receiverContacts = userMap[shareItem.userID] || (userMap[shareItem.userID] = []);
  130. receiverContacts.push(project.userID);
  131. const newItem = {
  132. ID: uuidV1(),
  133. projectID: project.ID,
  134. owner: project.userID,
  135. receiver: shareItem.userID,
  136. allowCopy: shareItem.allowCopy,
  137. allowCooperate: shareItem.allowCooperate,
  138. shareDate: shareItem.shareDate,
  139. updateDate: shareItem.shareDate
  140. };
  141. ownerContacts.push(shareItem.userID);
  142. shareList.push(newItem);
  143. });
  144. });
  145. // 插入分享信息
  146. const shareListPromise = shareListModel.insertMany(shareList);
  147. const tasks = [shareListPromise];
  148. // 更新用户信息
  149. const userTasks = [];
  150. Object.entries(userMap).forEach(([userID, contacts]) => {
  151. contacts = [...new Set(contacts)]
  152. .map(user => ({ userID: user }));
  153. const task = {
  154. updateOne: {
  155. filter: {
  156. _id: mongoose.Types.ObjectId(userID)
  157. },
  158. update: {
  159. contacts
  160. }
  161. }
  162. };
  163. userTasks.push(task);
  164. });
  165. if (userTasks.length) {
  166. tasks.push(userModel.bulkWrite(userTasks));
  167. }
  168. await Promise.all(tasks);
  169. }
  170. // 获取分享列表
  171. async function getShareList(query) {
  172. return await shareListModel.find(query, '-_id').lean();
  173. }
  174. async function addShareList(docs) {
  175. await shareListModel.insertMany(docs);
  176. }
  177. async function deleteShareList(query) {
  178. await shareListModel.deleteMany(query);
  179. }
  180. async function updateShareList(updateData) {
  181. const bulks = updateData.map(item => (
  182. {
  183. updateOne: {
  184. filter: item.query,
  185. update: item.update
  186. }
  187. }
  188. ));
  189. if (bulks.length) {
  190. await shareListModel.bulkWrite(bulks);
  191. }
  192. }
  193. // 根据项目ID获取项目shareInfo字段的数据映射(前端旧逻辑依赖项目本身的shareInfo字段)
  194. async function getShareInfoMap(projectIDs, shareList = null) {
  195. if (!shareList) {
  196. shareList = await getShareList({projectID: {$in: projectIDs}});
  197. }
  198. // 将相同项目的分享信息进行映射
  199. const map = {};
  200. shareList.forEach(item => {
  201. const shareInfo = map[item.projectID] || (map[item.projectID] = []);
  202. shareInfo.push({
  203. userID: item.receiver,
  204. shareDate: item.shareDate,
  205. updateDate: item.updateDate,
  206. allowCopy: item.allowCopy,
  207. allowCooperate: item.allowCooperate
  208. });
  209. });
  210. return map;
  211. }
  212. // 获取最近分享(只算分享出去的记录)
  213. async function getRecentShareList(userID, count) {
  214. const shareList = await getShareList({owner: userID});
  215. shareList.sort((a, b) => Date.parse(b.shareDate) - Date.parse(a.shareDate));
  216. const set = new Set();
  217. for(const item of shareList) {
  218. if (set.size === count) {
  219. break;
  220. }
  221. set.add(item.receiver);
  222. }
  223. const sortedIDList = [...set];
  224. const userIDList = sortedIDList.map(userID => mongoose.Types.ObjectId(userID));
  225. const users = await userModel.find({_id: {$in: userIDList}}, 'real_name mobile company').lean();
  226. users.sort((a, b) => sortedIDList.indexOf(a._id.toString()) - sortedIDList.indexOf(b._id.toString()));
  227. return users;
  228. }
  229. //拷贝例题项目
  230. //@param {String}userID {Array}projIDs拷贝的例题项目ID(建设项目、文件夹)@return {Boolean}
  231. async function copyExample(userID, compilation, projIDs){
  232. let allProjs = [],
  233. IDMapping = {},
  234. projMapping = {};
  235. //例题项目不可为单项工程、单位工程、只能是建设项目、文件夹,否则不自动新建例题项目(这里不报错,让用户没有感觉)
  236. let parentExample = await projectModel.find({ID: {$in: projIDs}, $or: notDeleted}).lean();
  237. if (parentExample.length === 0) {
  238. return false;
  239. }
  240. allProjs = allProjs.concat(parentExample);
  241. for (let i = 0; i < parentExample.length; i++) {
  242. let data = parentExample[i];
  243. if (data.projType === projectType.tender || data.projType === projectType.engineering) {
  244. return false;
  245. }
  246. //设置成顶节点,最后一个节点设置成末节
  247. data.ParentID = -1;
  248. if (i === parentExample.length - 1) {
  249. data.NextSiblingID = -1;
  250. }
  251. }
  252. //获取所有的子项目
  253. let posterityProjs = await getPosterityProjects(projIDs);
  254. allProjs = allProjs.concat(posterityProjs);
  255. let projCounter = await counter.counterDAO.getIDAfterCountSync(counter.moduleName.project, allProjs.length);
  256. //旧ID与新ID映射
  257. for (let i = 0; i < allProjs.length; i++) {
  258. let data = allProjs[i];
  259. let newID = projCounter.sequence_value - (allProjs.length - 1) + i;
  260. IDMapping[data.ID] = newID;
  261. projMapping[newID] = data;
  262. }
  263. //return;
  264. //设置新的树结构数据
  265. let newDate = new Date(),
  266. parentBulks = [];
  267. for (let data of allProjs) {
  268. let orgID = data.ID;
  269. data.ID = IDMapping[data.ID];
  270. data.ParentID = IDMapping[data.ParentID] ? IDMapping[data.ParentID] : -1;
  271. data.NextSiblingID = IDMapping[data.NextSiblingID] ? IDMapping[data.NextSiblingID] : -1;
  272. data.createDateTime = newDate;
  273. data.userID = userID;
  274. data.compilation = compilation;
  275. data.shareInfo = [];
  276. if (data.projType !== projectType.tender) {
  277. let newData = _.cloneDeep(data);
  278. delete newData._id;
  279. // await projectModel.create(newData);
  280. parentBulks.push({insertOne: {document: newData}});
  281. } else {
  282. //拷贝单位工程
  283. let rootProjectID = projMapping[data.ParentID].ID;
  284. let projectMap = {
  285. copy: {
  286. document: {userID: userID, ID: orgID, NextSiblingID: data.NextSiblingID, ParentID: data.ParentID, name: data.name, shareInfo: [],
  287. compilation: compilation, fileVer: data.fileVer, projType: data.projType, property: {rootProjectID: rootProjectID}}
  288. }
  289. };
  290. await copyProject(userID, compilation, {projectMap}, data.ID);
  291. }
  292. }
  293. //最末顶层项目(兼容测试时已存在有项目,正常用户第一次进费用定额,该费用定额不存在项目)
  294. let lastProj = await projectModel.findOne({userID: userID, compilation: compilation, ParentID: -1, NextSiblingID: -1, $or: notDeleted});
  295. if (lastProj) {
  296. parentBulks.push({updateOne: {filter: {ID: lastProj.ID}, update: {$set: {NextSiblingID: parentExample[0].ID}}}});
  297. }
  298. //拷贝父级文件
  299. await projectModel.bulkWrite(parentBulks);
  300. return true;
  301. }
  302. async function copyProject(userID, compilationID,data,newProjectID = null) {
  303. let projectMap = data.projectMap;
  304. let originalID = projectMap['copy'].document.ID;
  305. if (!newProjectID) {
  306. newProjectID = await getCounterID("projects");
  307. }
  308. let newFeeName = null,newUnitName = null;
  309. let calcProgramFileID = uuidV1();//新的计算程序文件ID
  310. let labourCoeFileID = uuidV1();//新的人工调整系数文件ID
  311. let feeRateFileID = uuidV1();//新的费率文件ID
  312. let unitPriceFileID = await getCounterID("unit_price_file");//新的单价文件ID
  313. let originalProject = await projectModel.findOne({'ID':originalID});//查找最新的那项目信息,前端缓存的数据有可能不是最新的
  314. if(!originalProject){
  315. throw new Error('没有找到对应的项目,复制失败!');
  316. }
  317. let property = originalProject.property;
  318. if(projectMap['copy'].document.property){//更新项目属性信息
  319. setProperty(property,projectMap['copy'].document.property);
  320. }
  321. let originalProperty = _.cloneDeep(property);
  322. projectMap['copy'].document.property = property;
  323. logger.info("复制项目: 旧项目ID: "+originalID+ " ------- 新项目ID: "+newProjectID);
  324. //费率文件、单价文件重名检查
  325. let feeRate = await feeRateFileModel.findOne({rootProjectID:originalProperty.rootProjectID,name:originalProperty.feeFile.name,deleteInfo:null});
  326. if(feeRate){//存在重名的文件
  327. newFeeName = originalProperty.feeFile.name + '(' + moment(Date.now()).tz("Asia/Shanghai").format('MM-DD HH:mm:ss') + '复制)';
  328. projectMap['copy'].document.property.feeFile.name = newFeeName;
  329. }
  330. let unitPriceFile = await unitPriceFileModel.findOne({root_project_id: originalProperty.rootProjectID,name:originalProperty.unitPriceFile.name,deleteInfo: null});
  331. if(unitPriceFile){//存在重名的文件
  332. newUnitName = originalProperty.unitPriceFile.name + '(' + moment(Date.now()).tz("Asia/Shanghai").format('MM-DD HH:mm:ss') + '复制)';
  333. projectMap['copy'].document.property.unitPriceFile.name = newUnitName;
  334. }
  335. //更新项目的属性;
  336. projectMap['copy'].document.ID = newProjectID;
  337. if(projectMap['copy'].document.property.calcProgramFile){
  338. projectMap['copy'].document.property.calcProgramFile.ID = calcProgramFileID;
  339. }
  340. if(projectMap['copy'].document.property.labourCoeFile){
  341. projectMap['copy'].document.property.labourCoeFile.ID = labourCoeFileID;
  342. }
  343. if(projectMap['copy'].document.property.feeFile){
  344. projectMap['copy'].document.property.feeFile.id = feeRateFileID;
  345. }
  346. if(projectMap['copy'].document.property.unitPriceFile){
  347. projectMap['copy'].document.property.unitPriceFile.id = unitPriceFileID;
  348. }
  349. projectMap['copy'].document.userID = userID;
  350. projectMap['copy'].document.compilation = compilationID;
  351. projectMap['copy'].document.createDateTime = new Date();
  352. //清单、定额ID生成任务
  353. let IDtasks = [
  354. createIDsAndReturn(originalID,billsModel),
  355. createIDsAndReturn(originalID,rationModel),
  356. getProjectGLJIDAndReturn(originalID,newProjectID)
  357. ];
  358. let [billMap,rationMap,projectGLJMap] = await Promise.all(IDtasks);
  359. //所有复制任务异步处理,提升效率 复制清单,定额,4个文件,项目工料机, 定额工料机,人工系数,工程量明细,定额安装增加费,安装增加费
  360. let copyTasks = [
  361. createProject(projectMap),
  362. copyProjectSetting(originalID,newProjectID),
  363. copyBills(newProjectID,billMap),
  364. copyRations(newProjectID,billMap.uuidMaping,rationMap,projectGLJMap.IDMap),
  365. copyProjectGLJ(projectGLJMap.datas),
  366. copyInstallFee(originalID,newProjectID),
  367. copyRationSubList(originalID,newProjectID,billMap.uuidMaping,rationMap.uuidMaping,projectGLJMap.IDMap,rationGLJModel),
  368. copyRationSubList(originalID,newProjectID,billMap.uuidMaping,rationMap.uuidMaping,projectGLJMap.IDMap,rationCoeModel),
  369. copyRationSubList(originalID,newProjectID,billMap.uuidMaping,rationMap.uuidMaping,projectGLJMap.IDMap,quantityDetailModel),
  370. copyRationSubList(originalID,newProjectID,billMap.uuidMaping,rationMap.uuidMaping,projectGLJMap.IDMap,rationInstallationModel),
  371. copyRationSubList(originalID,newProjectID,billMap.uuidMaping,rationMap.uuidMaping,projectGLJMap.IDMap,rationTemplateModel)
  372. ];
  373. if(originalProperty.calcProgramFile){
  374. copyTasks.push(commonCopy(newProjectID,originalProperty.calcProgramFile.ID,calcProgramFileID,calcProgramsModel));
  375. }
  376. if(originalProperty.labourCoeFile){
  377. copyTasks.push(commonCopy(newProjectID,originalProperty.labourCoeFile.ID,labourCoeFileID,labourCoesModel));
  378. }
  379. if(originalProperty.feeFile){
  380. copyTasks.push(copyFeeRate(originalProperty.rootProjectID,userID,originalProperty.feeFile.id,feeRateFileID,newFeeName));
  381. }
  382. if(originalProperty.unitPriceFile){
  383. copyTasks.push(copyUnitPriceFile(newProjectID,originalProperty.rootProjectID,userID,originalProperty.unitPriceFile.id,unitPriceFileID,newUnitName));
  384. }
  385. let p = await Promise.all(copyTasks);
  386. return p[0];
  387. }
  388. async function createIDsAndReturn(originalID,model) {
  389. let uuidMaping = {};//做ID映射
  390. let datas = [];
  391. let result = await model.find({"projectID": originalID}, '-_id');
  392. uuidMaping['-1'] = -1;
  393. //建立uuid-ID映射
  394. for(let d of result){
  395. uuidMaping[d.ID] = uuidV1();
  396. datas.push(d._doc);
  397. }
  398. return{uuidMaping:uuidMaping,datas:datas};
  399. }
  400. async function getProjectGLJIDAndReturn(originalID,newProjectID) {
  401. let IDMap = {};
  402. let datas = [];
  403. let result = await gljListModel.find({project_id:originalID}, '-_id');
  404. let gljCount = await counter.counterDAO.getIDAfterCountSync(counter.moduleName.glj_list, result.length);
  405. for(let i = 0; i < result.length; i++){
  406. let d = result[i];
  407. let newID = gljCount.sequence_value - (result.length - 1) + i;
  408. //let newID = await getCounterID("glj_list");
  409. IDMap[d.id] = newID;
  410. d._doc.project_id = newProjectID;
  411. d._doc.id = newID;
  412. datas.push(d._doc);
  413. }
  414. return{IDMap:IDMap,datas:datas};
  415. }
  416. async function createProject(projectMap) {//复制项目
  417. let tasks = [];
  418. if(projectMap['update']){//如果复制后存在前一个节点,则更新其NextSiblingID
  419. tasks.push({updateOne:{filter : projectMap['update'].query, update : {NextSiblingID:projectMap['copy'].document.ID}}});
  420. }
  421. tasks.push({insertOne: {document: projectMap['copy'].document}});//复制任务
  422. await projectModel.bulkWrite(tasks);
  423. return projectMap;
  424. }
  425. async function copyProjectSetting(originalID,newProjectID) {
  426. let result = null;
  427. let setting = await projectSettingModel.findOne({"projectID": originalID}, '-_id');
  428. if(setting){
  429. setting._doc.projectID =newProjectID;
  430. result = await projectSettingModel.create(setting._doc);
  431. }
  432. return result;
  433. }
  434. async function copyBills(newProjectID,billMap) {
  435. let uuidMaping = billMap.uuidMaping;//做ID映射
  436. for(let doc of billMap.datas){
  437. doc = getCopyBillDatas(doc,newProjectID,uuidMaping)
  438. }
  439. await insertMany(billMap.datas,billsModel);
  440. return billMap.datas;
  441. }
  442. function getCopyBillDatas(doc,newProjectID,uuidMaping) {
  443. doc.projectID = newProjectID;
  444. doc.ID = uuidMaping[doc.ID] ? uuidMaping[doc.ID] : -1;
  445. doc.ParentID = uuidMaping[doc.ParentID] ? uuidMaping[doc.ParentID] : -1;
  446. doc.NextSiblingID = uuidMaping[doc.NextSiblingID] ? uuidMaping[doc.NextSiblingID] : -1;
  447. //对于有基数计算的节点,需要替换计算基数中引用的ID为新的ID
  448. if(doc.calcBase && doc.calcBase != ""){
  449. let idArr = scMathUtil.getFIDArr(doc.calcBase);
  450. for(let re of idArr){
  451. let oID = re.substr(1);//去掉开头的@字符
  452. if(!uuidMaping[oID]) continue;
  453. doc.calcBase = doc.calcBase.replace(new RegExp(oID, "g"),uuidMaping[oID]);
  454. }
  455. }
  456. return doc;
  457. }
  458. async function copyRations(newProjectID,billsIDMap,rationMap,projectGLJIDMap) {
  459. let uuidMaping = rationMap.uuidMaping;
  460. for(let doc of rationMap.datas){
  461. doc = getCopyRationData(doc,newProjectID,billsIDMap,uuidMaping,projectGLJIDMap);
  462. }
  463. if(rationMap.datas.length > 0){
  464. await insertMany(rationMap.datas,rationModel);
  465. }
  466. return rationMap.datas;
  467. }
  468. function getCopyRationData(doc,newProjectID,billsIDMap,uuidMaping,projectGLJIDMap){
  469. doc.projectID = newProjectID;
  470. doc.ID = uuidMaping[doc.ID] ? uuidMaping[doc.ID] : -1;
  471. if(doc.billsItemID){
  472. doc.billsItemID = billsIDMap[doc.billsItemID]?billsIDMap[doc.billsItemID]:-1;
  473. }
  474. if(doc.referenceRationID) doc.referenceRationID = uuidMaping[doc.referenceRationID]?uuidMaping[doc.referenceRationID]:undefined;
  475. //绑定定类型的工料机 项目工料机ID
  476. doc.type==3&&doc.projectGLJID&&projectGLJIDMap[doc.projectGLJID]?doc.projectGLJID = projectGLJIDMap[doc.projectGLJID]:'';
  477. return doc;
  478. }
  479. async function copyProjectGLJ(gljList) {
  480. await insertMany(gljList,gljListModel);
  481. }
  482. async function commonCopy(newProjectID,oldID,newID,model) { //对于只需更新ID和projectID的文件的复制
  483. let result = null;
  484. let file = await model.findOne({"ID": oldID}, '-_id');
  485. if(file){
  486. file._doc.ID = newID;
  487. file._doc.projectID =newProjectID;
  488. result = await model.create(file._doc);
  489. }
  490. return result;
  491. }
  492. async function copyFeeRate(rootProjectID,userID,originalFeeRateFileID,feeRateFileID,newName) {//复制费率和费率文件
  493. let [feeRateFile,feeRate] =await feeRate_facade.getFeeRateByID(originalFeeRateFileID);
  494. let newFeeRateID = uuidV1();
  495. if(feeRate){
  496. feeRate._doc.ID = newFeeRateID;
  497. await feeRateModel.create(feeRate._doc);
  498. }
  499. if(feeRateFile){
  500. feeRateFile._doc.ID = feeRateFileID;
  501. newName?feeRateFile._doc.name = newName:'';
  502. feeRateFile._doc.userID = userID;
  503. feeRateFile._doc.rootProjectID = rootProjectID;
  504. feeRateFile._doc.feeRateID = newFeeRateID;
  505. await feeRateFileModel.create(feeRateFile._doc);
  506. }
  507. }
  508. async function copyUnitPriceFile(newProjectID,rootProjectID,userID,originaluUnitPriceFileID,unitPriceFileID,newName) {//复制单价文件、组成物
  509. let taskList = [
  510. copyFile(newProjectID,rootProjectID,userID,originaluUnitPriceFileID,unitPriceFileID,newName),
  511. copySubList(originaluUnitPriceFileID,unitPriceFileID,mixRatioModel),
  512. copySubList(originaluUnitPriceFileID,unitPriceFileID,freightModel,true),
  513. copySubList(originaluUnitPriceFileID,unitPriceFileID,originalModel,true),
  514. copySubList(originaluUnitPriceFileID,unitPriceFileID,comElectrovalenceModel,true),
  515. copySubList(originaluUnitPriceFileID,unitPriceFileID,unitPriceModel)
  516. ];
  517. return await Promise.all(taskList);
  518. async function copyFile(newProjectID,rootProjectID,userID,originaluUnitPriceFileID,unitPriceFileID,newName){
  519. let unitPriceFile = await unitPriceFileModel.findOne({id:originaluUnitPriceFileID}, '-_id');
  520. if(unitPriceFile){
  521. unitPriceFile._doc.id = unitPriceFileID;
  522. newName?unitPriceFile._doc.name = newName:'';
  523. unitPriceFile._doc.project_id = newProjectID;
  524. unitPriceFile._doc.user_id = userID;
  525. unitPriceFile._doc.root_project_id = rootProjectID
  526. }
  527. await unitPriceFileModel.create(unitPriceFile._doc);
  528. }
  529. async function copySubList(srcFID,newFID,model,UUID=false) {
  530. let mList = await model.find({unit_price_file_id: srcFID}, '-_id');
  531. let rList = [];
  532. for(let m of mList){
  533. m._doc.unit_price_file_id = newFID;
  534. UUID == true?m._doc.ID = uuidV1():m._doc.id = await getCounterID(model.modelName);
  535. rList.push(m._doc);
  536. }
  537. await insertMany(rList,model)
  538. }
  539. }
  540. async function copyInstallFee(originalPID,newProjectID) {
  541. let result = null;
  542. let installationFee = await installationFeeModel.find({projectID:originalPID}, '-_id');
  543. let newList = [];
  544. for(let i of installationFee ){
  545. i._doc.ID = uuidV1();
  546. i._doc.projectID = newProjectID;
  547. newList.push(i._doc);
  548. }
  549. if(newList.length >0){
  550. result = await installationFeeModel.insertMany(newList);
  551. }
  552. return result;
  553. }
  554. async function copyRationSubList(originalPID,newProjectID,billIDMap,rationIDMap,projectGLJIDMap,model) {// 定额工料机,附注条件,工程量明细,定额安装增加费
  555. let subList = await model.find({projectID:originalPID}, '-_id');
  556. let newList =[];
  557. for(let s of subList){
  558. s._doc = getCopyRationSubData(s._doc,newProjectID,billIDMap,rationIDMap,projectGLJIDMap);
  559. /* s._doc.ID = uuidV1();
  560. s._doc.projectID = newProjectID;
  561. s._doc.rationID&&rationIDMap[s._doc.rationID]?s._doc.rationID = rationIDMap[s._doc.rationID]:'';
  562. s._doc.billID&&billIDMap[s._doc.billID]?s._doc.billID = billIDMap[s._doc.billID]:'';
  563. s._doc.billsItemID&&billIDMap[s._doc.billsItemID]?s._doc.billsItemID = billIDMap[s._doc.billsItemID]:'';
  564. s._doc.projectGLJID&&projectGLJIDMap[s._doc.projectGLJID]?s._doc.projectGLJID = projectGLJIDMap[s._doc.projectGLJID]:'';
  565. if(s._doc.templateList && s._doc.templateList.length > 0 ){
  566. for(let t of s._doc.templateList){
  567. if(t.billID && billIDMap[t.billID]) t.billID = billIDMap[t.billID];
  568. if(t.fxID && billIDMap[t.fxID]) t.fxID = billIDMap[t.fxID];
  569. }
  570. }*/
  571. newList.push(s._doc);
  572. }
  573. await insertMany(newList,model);
  574. }
  575. function getCopyRationSubData(doc,newProjectID,billIDMap,rationIDMap,projectGLJIDMap){
  576. doc.ID = uuidV1();
  577. doc.projectID = newProjectID;
  578. doc.rationID&&rationIDMap[doc.rationID]?doc.rationID = rationIDMap[doc.rationID]:'';
  579. doc.billID&&billIDMap[doc.billID]?doc.billID = billIDMap[doc.billID]:'';
  580. doc.billsItemID&&billIDMap[doc.billsItemID]?doc.billsItemID = billIDMap[doc.billsItemID]:'';
  581. doc.projectGLJID&&projectGLJIDMap[doc.projectGLJID]?doc.projectGLJID = projectGLJIDMap[doc.projectGLJID]:'';
  582. if(doc.templateList && doc.templateList.length > 0 ){
  583. for(let t of doc.templateList){
  584. if(t.billID && billIDMap[t.billID]) t.billID = billIDMap[t.billID];
  585. if(t.fxID && billIDMap[t.fxID]) t.fxID = billIDMap[t.fxID];
  586. }
  587. }
  588. return doc;
  589. }
  590. async function moveProject(data) {
  591. data = JSON.parse(data);
  592. let projectMap = data.projectMap,feeRateMap = data.feeRateMap,unitPriceMap = data.unitPriceMap;
  593. let projectTasks = [],feeRateTask=[],feeRateFileTask=[],unitPriceTask=[],unitPriceFileTask=[],mixRatioTask=[];
  594. let feeUniqMap=[],priceUniqMap={};//费率、单价文件唯一映射表当移动多个项目时,任务有可能出现重复的情况
  595. if(!_.isEmpty(feeRateMap)&&data.rootProjectID){//如果费率有修改
  596. let feeRates =await feeRate_facade.getFeeRatesByProject(data.rootProjectID);//取目标建设项目的所有费率文件,重名检查
  597. for(let projectID in feeRateMap){
  598. let rename = feeRateMap[projectID].name;
  599. let feeRateID = feeRateMap[projectID].query.ID;
  600. let checkFee = _.find(feeRates,{'name':rename});
  601. let newID = feeRateID;
  602. if(checkFee){//说明费率名字已存在,需要重命名
  603. rename = feeUniqMap[feeRateID]?feeUniqMap[feeRateID].name:rename + '(' + new Date().Format('MM-dd hh:mm:ss') + '移动)';
  604. projectMap[projectID]['update']['property.feeFile.name'] = rename;
  605. if(feeRateMap[projectID].action == 'move'){
  606. feeRateMap[projectID].update.name = rename;
  607. }
  608. }
  609. if(feeRateMap[projectID].action == 'copy'){
  610. newID = feeUniqMap[feeRateID]?feeUniqMap[feeRateID].ID:uuidV1();
  611. feeRateMap[projectID].name = rename;
  612. feeRateMap[projectID].ID = newID;
  613. projectMap[projectID]['update']['property.feeFile.id'] = newID;
  614. }
  615. if(!feeUniqMap[feeRateID]){
  616. await generateFeeRateTask(feeRateMap[projectID],feeRateTask,feeRateFileTask);
  617. feeUniqMap[feeRateID] = {name:rename,ID:newID};
  618. }
  619. }
  620. }
  621. if(!_.isEmpty(unitPriceMap)&&data.rootProjectID) {//如果单价文件有修改
  622. let unitPriceFiles = await unitPriceFileModel.find({root_project_id: data.rootProjectID, deleteInfo: null});
  623. for(let projectID in unitPriceMap){
  624. let checkUn = _.find(unitPriceFiles,{'name':unitPriceMap[projectID].name});
  625. let rename = unitPriceMap[projectID].name;
  626. let unitPriceID = unitPriceMap[projectID].query.id;
  627. let newID = unitPriceID;
  628. if(checkUn){//重名检查
  629. rename = priceUniqMap[unitPriceID]?priceUniqMap[unitPriceID].name:rename + '(' + new Date().Format('MM-dd hh:mm:ss') + '移动)';
  630. projectMap[projectID]['update']['property.unitPriceFile.name'] = rename;
  631. if(unitPriceMap[projectID].action =='move'){
  632. unitPriceMap[projectID].update.name = rename;
  633. }
  634. }
  635. if(unitPriceMap[projectID].action =='copy'){
  636. newID = priceUniqMap[unitPriceID]?priceUniqMap[unitPriceID].id: await getCounterID("unit_price_file");
  637. unitPriceMap[projectID].name = rename;
  638. unitPriceMap[projectID].id = newID;
  639. projectMap[projectID]['update']['property.unitPriceFile.id'] = newID;
  640. }
  641. if(!priceUniqMap[unitPriceID]){
  642. await generateUnitPriceTask(unitPriceMap[projectID],projectID,data.user_id,unitPriceTask,unitPriceFileTask,mixRatioTask);
  643. priceUniqMap[unitPriceID] = {name:rename,id:newID};
  644. }
  645. }
  646. }
  647. if(!_.isEmpty(projectMap)){
  648. for(let projectID in projectMap){
  649. projectTasks.push({updateOne:{filter : projectMap[projectID].query, update : projectMap[projectID].update}});
  650. }
  651. }
  652. projectTasks.length>0?await projectModel.bulkWrite(projectTasks):'';
  653. feeRateTask.length>0?await feeRateModel.bulkWrite(feeRateTask):'';
  654. feeRateFileTask.length>0?await feeRateFileModel.bulkWrite(feeRateFileTask):'';
  655. unitPriceFileTask.length>0?await unitPriceFileModel.bulkWrite(unitPriceFileTask):'';
  656. unitPriceTask.length>0?await insertMany(unitPriceTask,unitPriceModel):'';
  657. mixRatioTask.length>0?await insertMany(mixRatioTask,mixRatioModel):'';
  658. return projectMap;
  659. }
  660. async function generateFeeRateTask(data,feeRateTask,feeRateFileTask) {
  661. if(data.action == 'move'){
  662. let task = {
  663. updateOne:{
  664. filter : data.query,
  665. update : data.update
  666. }
  667. };
  668. feeRateFileTask.push(task);
  669. }
  670. if(data.action == 'copy'){//copy 费率的时候用insertOne方法
  671. let [feeRateFile,feeRate] =await feeRate_facade.getFeeRateByID(data.query.ID);
  672. let newFeeRateID = uuidV1();
  673. let newFeeRate = {
  674. ID:newFeeRateID,
  675. rates:feeRate.rates
  676. };
  677. let newFeeRateFile = {
  678. ID:data.ID,
  679. rootProjectID:data.rootProjectID,
  680. userID:feeRateFile.userID,
  681. name:data.name,
  682. libID:feeRateFile.libID,
  683. libName:feeRateFile.libName,
  684. feeRateID:newFeeRateID
  685. };
  686. feeRateTask.push({insertOne :{document:newFeeRate}});
  687. feeRateFileTask.push({insertOne :{document:newFeeRateFile}});
  688. }
  689. }
  690. async function generateUnitPriceTask(data,projectID,user_id,unitPriceTask,unitPriceFileTask,mixRatioTask){
  691. if(data.action == 'move'){
  692. let task = {
  693. updateOne:{
  694. filter : data.query,
  695. update : data.update
  696. }
  697. };
  698. unitPriceFileTask.push(task);
  699. }
  700. if(data.action == 'copy'){
  701. let newUnitFile = {
  702. id:data.id,
  703. name: data.name,
  704. project_id:projectID,
  705. user_id:user_id,
  706. root_project_id: data.rootProjectID
  707. };
  708. unitPriceFileTask.push({insertOne :{document:newUnitFile}});
  709. let mixRatios = await mixRatioModel.find({unit_price_file_id: data.query.id});
  710. mixRatios = JSON.stringify(mixRatios);
  711. mixRatios = JSON.parse(mixRatios);
  712. for(let m of mixRatios){
  713. delete m._id; // 删除原有id信息
  714. delete m.id;
  715. m.unit_price_file_id = data.id;
  716. m.id = await getCounterID('mix_ratio');
  717. mixRatioTask.push(m);
  718. }
  719. let unitPrices = await unitPriceModel.find({unit_price_file_id: data.query.id});//unit_price_file_id
  720. unitPrices = JSON.stringify(unitPrices);
  721. unitPrices = JSON.parse(unitPrices);
  722. for(let u of unitPrices){
  723. delete u._id; // 删除原有id信息
  724. delete u.id;
  725. u.unit_price_file_id = data.id;
  726. u.id = await getCounterID('unit_price');
  727. unitPriceTask.push(u);
  728. }
  729. }
  730. }
  731. async function getCounterID(collectionName){
  732. let counterModel = new CounterModel();
  733. return await counterModel.getId(collectionName);
  734. }
  735. async function insertMany(datas,model) {
  736. while (datas.length>1000){//因为mongoose限制了批量插入的条数为1000.所以超出限制后需要分批插入
  737. let newList = datas.splice(0,1000);//一次插入1000条
  738. await model.insertMany(newList);
  739. }
  740. await model.insertMany(datas);
  741. }
  742. function setProperty(Obj,updateData) {
  743. for(let ukey in updateData){
  744. if(_.isObject(updateData[ukey]) && _.isObject(Obj[ukey])){
  745. setProperty(Obj[ukey],updateData[ukey]);
  746. }else {
  747. Obj[ukey] = updateData[ukey];
  748. }
  749. }
  750. }
  751. function isDef(v){
  752. return typeof v !== 'undefined' && v !== null;
  753. }
  754. function getTotalFee(bills, feeName) {
  755. if(!isDef(bills)){
  756. return 0;
  757. }
  758. if(!isDef(bills.fees) || bills.fees.length <= 0){
  759. return 0;
  760. }
  761. for(let fee of bills.fees){
  762. if(isDef(fee.fieldName) && fee.fieldName === feeName){
  763. return isDef(fee.totalFee) ? fee.totalFee : 0;
  764. }
  765. }
  766. return 0;
  767. }
  768. function getCommonTotalFee(bills) {
  769. if(!isDef(bills)){
  770. return 0;
  771. }
  772. if(!isDef(bills.fees) || bills.fees.length <= 0){
  773. return 0;
  774. }
  775. for(let fee of bills.fees){
  776. if(isDef(fee.fieldName) && fee.fieldName === 'common'){
  777. return isDef(fee.totalFee) ? fee.totalFee : 0;
  778. }
  779. }
  780. return 0;
  781. }
  782. function summarizeToParent(parent, child, flagFieldMapping) {
  783. const decimal = -2;
  784. let costFields = [];
  785. for (let flag in flagFieldMapping) {
  786. let costItems = flagFieldMapping[flag];
  787. for (let costItem of costItems) {
  788. costFields.push(costItem.name);
  789. }
  790. }
  791. for (let field of costFields) {
  792. parent[field] = scMathUtil.roundTo(parseFloat(parent[field]) + parseFloat(child[field]), decimal);
  793. }
  794. }
  795. function getBuildingArea(projFeature){
  796. if(!projFeature || projFeature.length === 0){
  797. return null;
  798. }
  799. for(let f of projFeature){
  800. if(f.key === 'buildingArea'){
  801. return f.value;
  802. }
  803. }
  804. return null;
  805. }
  806. // 根据树结构数据排序
  807. function getSortedDataByTree(data) {
  808. // NextSiblingID-数据映射
  809. const mapping = {};
  810. data.forEach(item => {
  811. // 错误数据兼容处理
  812. // 由于之前的导入建设项目,会导致最后的一个项目的NextSiblingID为空,为非正确的-1
  813. // 因此把项目中NextSibling为空的数据设置为NextSiblingID为-1
  814. if (!item.NextSiblingID) {
  815. item.NextSiblingID = -1;
  816. }
  817. mapping[item.NextSiblingID] = item;
  818. });
  819. let lastItem = data.find(item => +item.NextSiblingID === -1);
  820. if (!lastItem) {
  821. return data;
  822. }
  823. const rst = [lastItem];
  824. let preItem = mapping[lastItem.ID];
  825. while (preItem) {
  826. rst.unshift(preItem);
  827. preItem = mapping[preItem.ID];
  828. }
  829. // 根据树结构排序形成的新数组与旧数组项数不同,说明树结构数据有问题(断链),则返回原本数据。
  830. return rst.length === data.length ? rst : data;
  831. }
  832. //根据单位工程ID获取汇总信息
  833. //@param {Number}tenderID {String}summaryType @return {Object}
  834. async function getSummaryInfoByTender(tenderID, summaryType) {
  835. const notDeleted = [{deleteInfo: null}, {'deleteInfo.deleted': false}];
  836. let tender = await projectModel.findOne({ID: tenderID, $or: notDeleted});
  837. let parentName;
  838. let summaryList = [];
  839. if(!tender){
  840. return null;
  841. }
  842. let project = await projectModel.findOne({ID: tender.ParentID, $or: notDeleted});
  843. if(!project){
  844. return null;
  845. }
  846. let flagFieldMapping = {
  847. [billsFlags.TOTAL_COST]: [{name: 'totalCost', feeField: 'common'}], // 总造价
  848. [billsFlags.CONSTRUCTION_INSTALL_FEE]: [{name: 'constructionInstallFee', feeField: 'rationCommon'},], // 建安费
  849. };
  850. let summaryInfo = await getSummaryInfo([project.ID], flagFieldMapping);
  851. // 汇总到建设项目层(没有单项工程层了)
  852. if (summaryType === projectType.project) {
  853. parentName = project.name ? project.name : '';
  854. let tenders = await projectModel.find({ParentID: project.ID, $or: notDeleted}).lean();
  855. tenders = getSortedDataByTree(tenders);
  856. for(let t of tenders){
  857. if(summaryInfo[t.ID]){
  858. summaryInfo[t.ID]['name'] = t.name ? t.name : '';
  859. summaryList.push(summaryInfo[t.ID]);
  860. }
  861. }
  862. }
  863. return {parent: {name: parentName}, subList: summaryList};
  864. }
  865. //获取单位工程的各标段费用信息(不进行汇总)
  866. async function getTendersFeeInfo(tenders) {
  867. let IDMapping = {};
  868. //固定清单类别与汇总金额字段映射
  869. let flagFieldMapping = {
  870. [billsFlags.TOTAL_COST]: [{name: 'totalCost', feeField: 'common'}]
  871. };
  872. let tenderIDs = [];
  873. if(tenders.length > 0){
  874. for(let tender of tenders){
  875. tenderIDs.push(tender.ID);
  876. IDMapping[tender.ID] = {totalCost: 0};
  877. }
  878. //需要获取的清单固定类别综合合价:总造价
  879. let needFlags = Object.getOwnPropertyNames(flagFieldMapping);
  880. //获取单位工程汇总金额需要用到的所有清单
  881. let allBills = await billsModel.find({projectID: {$in: tenderIDs}, 'flags.flag': {$in: needFlags}, $or: notDeleted},
  882. '-_id projectID fees flags');
  883. //进行单位工程级别的汇总
  884. for(let bills of allBills){
  885. let billsFlag = bills.flags[0]['flag'];
  886. let costItems = flagFieldMapping[billsFlag];
  887. for (let costItem of costItems) {
  888. IDMapping[bills.projectID][costItem.name] = getTotalFee(bills, costItem.feeField);
  889. }
  890. }
  891. }
  892. return IDMapping;
  893. }
  894. // 项目管理界面需要显示的汇总字段
  895. function setupSummaryFields(summaryInfo, projects, fields = null) {
  896. if (!fields) {
  897. fields = [
  898. 'totalCost'
  899. ];
  900. }
  901. for(const proj of projects){
  902. const summaryProj = summaryInfo[proj.ID];
  903. if(summaryProj){
  904. for (const field of fields) {
  905. proj[field] = summaryProj[field];
  906. }
  907. }
  908. }
  909. }
  910. //@param {Array}projectIDs(建设项目ID) @return {Object}
  911. async function getSummaryInfo(projectIDs, flagFieldMapping = null){
  912. //ID与汇总信息映射
  913. let IDMapping = {};
  914. //固定清单类别与汇总金额字段映射
  915. if (!flagFieldMapping) {
  916. flagFieldMapping = {
  917. [billsFlags.TOTAL_COST]: [{name: 'totalCost', feeField: 'common'}], // 总造价
  918. };
  919. }
  920. let projects = await projectModel.find({ID: {$in : projectIDs}, projType: projectType.project, $or: [{deleteInfo: null}, {'deleteInfo.deleted': false}]});
  921. for(let project of projects){
  922. IDMapping[project.ID] = {totalCost: 0};
  923. }
  924. //单位工程
  925. let tenders = [];
  926. if(projectIDs.length > 0){
  927. tenders = await projectModel.find({ParentID: {$in : projectIDs}, projType: projectType.tender, $or: [{deleteInfo: null}, {'deleteInfo.deleted': false}]});
  928. }
  929. let tenderIDs = [];
  930. if(tenders.length > 0){
  931. for(let tender of tenders){
  932. tenderIDs.push(tender.ID);
  933. IDMapping[tender.ID] = {totalCost: 0, changeMark:tender.changeMark,property:tender.property};//property:tender.property
  934. }
  935. //需要获取的清单固定类别综合合价:总造价
  936. let needFlags = Object.getOwnPropertyNames(flagFieldMapping);
  937. //获取单位工程汇总金额需要用到的所有清单
  938. let allBills = await billsModel.find({projectID: {$in: tenderIDs}, 'flags.flag': {$in: needFlags}, $or: [{deleteInfo: null}, {'deleteInfo.deleted': false}]},
  939. '-_id projectID fees flags');
  940. //进行单位工程级别的汇总
  941. for(let bills of allBills){
  942. let billsFlag = bills.flags[0]['flag'];
  943. let costItems = flagFieldMapping[billsFlag];
  944. for (let costItem of costItems) {
  945. IDMapping[bills.projectID][costItem.name] = getTotalFee(bills, costItem.feeField);
  946. }
  947. }
  948. //进行建设项目级别的汇总
  949. for(let tender of tenders){
  950. summarizeToParent(IDMapping[tender.ParentID], IDMapping[tender.ID], flagFieldMapping);
  951. }
  952. }
  953. return IDMapping;
  954. }
  955. //根据项目ID获取所属建设项目
  956. //@param {Number}projectID @return {Object}
  957. async function getConstructionProject(projectID){
  958. function returnProject(project){
  959. if(!project || project.projType === projectType.folder){
  960. return null;
  961. }
  962. if(project.projType === projectType.project){
  963. return project;
  964. }
  965. }
  966. let project = await projectModel.findOne({ID: projectID, $or: notDeleted});
  967. let returnV = returnProject(project);
  968. if(returnV !== undefined){
  969. return returnV;
  970. }
  971. let parent = await projectModel.findOne({ID: project.ParentID, $or: notDeleted});
  972. returnV = returnProject(parent);
  973. if(returnV !== undefined){
  974. return returnV;
  975. }
  976. let grandParent = await projectModel.findOne({ID: parent.ParentID, $or: notDeleted});
  977. returnV = returnProject(grandParent);
  978. return returnV !== undefined ? returnV : null;
  979. }
  980. //获取单位工程完整目录结构
  981. //@param {Number}projectID @return {Arry}
  982. async function getFullPath(projectID) {
  983. let fullPath = [];
  984. let project = await projectModel.findOne({ID: projectID, $or: notDeleted}, '-_id ParentID name');
  985. if(project){
  986. fullPath.push(project.name);
  987. await getParent(project.ParentID);
  988. }
  989. fullPath = fullPath.reverse();
  990. return fullPath;
  991. async function getParent(ParentID) {
  992. if(ParentID != -1){
  993. let parent = await projectModel.findOne({ID: ParentID, $or: notDeleted}, '-_id ParentID name');
  994. if(parent){
  995. fullPath.push(parent.name);
  996. await getParent(parent.ParentID);
  997. }
  998. }
  999. }
  1000. }
  1001. //@param {String}libID(工程特征库ID) {Object}assign(需要赋值的key-value)
  1002. async function getProjectFeature(libID, assign) {
  1003. let lib = await featureLibModel.findOne({'ID':libID});
  1004. if (lib) {
  1005. for (let key in assign) {
  1006. let obj = _.find(lib.feature, {key: key});
  1007. if (obj) {
  1008. obj.value = assign[key];
  1009. }
  1010. }
  1011. return lib.feature;
  1012. } else {
  1013. return [];
  1014. }
  1015. }
  1016. //获取累进区间数据
  1017. async function getProgressiveInterval(libID) {
  1018. let lib = await progressiveModel.findOne({ID: libID});
  1019. return lib ? lib.data : [];
  1020. }
  1021. // 获取项目链上,自身、父项、爷爷项...的ID
  1022. async function getUpChainIDs(projectID) {
  1023. const rst = [];
  1024. while (projectID != -1) {
  1025. rst.push(projectID);
  1026. const project = await projectModel.findOne({ ID: projectID }, '-_id ParentID').lean();
  1027. projectID = project ? project.ParentID : -1;
  1028. }
  1029. return rst;
  1030. }
  1031. //获取projectIDs文件下所有子项目(默认不包括projectIDs本身)
  1032. async function getPosterityProjects(projectIDs, includeSelf = false) {
  1033. let rst = [];
  1034. if (includeSelf) {
  1035. const projects = await projectModel.find({ID: {$in: projectIDs}, $or: notDeleted}, '-_id').lean();
  1036. if (projects) {
  1037. rst.push(...projects);
  1038. }
  1039. }
  1040. async function getProjects(parentIDs) {
  1041. if (parentIDs.length > 0) {
  1042. let newIDs = [];
  1043. let projs = await projectModel.find({ParentID: {$in: parentIDs}, $or: notDeleted}, '-_id').lean();
  1044. for (let proj of projs) {
  1045. // 兼容旧的错误数据,可能ParentID和ID相同
  1046. if (parentIDs.includes(proj.ID)) {
  1047. continue;
  1048. }
  1049. rst.push(proj);
  1050. newIDs.push(proj.ID);
  1051. }
  1052. await getProjects(newIDs);
  1053. }
  1054. }
  1055. await getProjects(projectIDs);
  1056. return rst;
  1057. }
  1058. //根据项目获得分享信息(分享层级不一定在项目级)(以最新为准)
  1059. async function getShareInfo(userID, projectID) {
  1060. // 接受到的分享项目
  1061. const upChainIDs = await getUpChainIDs(projectID);
  1062. const shareList = await getShareList({receiver: userID, projectID: {$in: upChainIDs}});
  1063. // 返回最新的分享
  1064. //return shareList.sort((a, b) => Date.parse(b.shareDate) - Date.parse(a.shareDate))[0];
  1065. return shareList.sort((a, b) => Date.parse(b.updateDate) - Date.parse(a.updateDate))[0];
  1066. }
  1067. //打开的单位工程是否是被分享的.
  1068. async function isShare(userId, project){
  1069. //判断是否是打开分享的项目,属于分享文件的子项也算
  1070. while (project) {
  1071. for(let shareData of project.shareInfo){
  1072. if(shareData.userID === userId){
  1073. return true;
  1074. }
  1075. }
  1076. project = await projectModel.findOne({ID: project.ParentID}, '-_id shareInfo ID ParentID');
  1077. }
  1078. return false;
  1079. }
  1080. //用户是否第一次进入费用定额
  1081. async function isFirst(userId, compilationId) {
  1082. let userData = await userModel.findOne({_id: mongoose.Types.ObjectId(userId)}, '-_id used_list');
  1083. let isFirst = false;
  1084. if (userData) {
  1085. isFirst = !_.find(userData.used_list, function (o) {
  1086. return o.compilationId === compilationId;
  1087. })
  1088. }
  1089. return isFirst;
  1090. }
  1091. //用户第一次进入费用定额的数据准备
  1092. async function prepareInitialData(userId, compilation, example) {
  1093. let first = await isFirst(userId, compilation);
  1094. if (first) {
  1095. await updateUsedList(userId, compilation);
  1096. let prepareTask = [
  1097. copyCompleRationSection(userId, compilation),
  1098. copyCompleGljSection(userId, compilation)
  1099. ];
  1100. if (example && example.length > 0) {
  1101. prepareTask.push(copyExample(userId, compilation, example));
  1102. }
  1103. await Promise.all(prepareTask);
  1104. }
  1105. }
  1106. async function updateUsedList(userId, compilation) {
  1107. await userModel.update({_id: mongoose.Types.ObjectId(userId)}, {$push: {used_list: {compilationId: compilation}}});
  1108. }
  1109. //拷贝补充定额章节树
  1110. async function copyCompleRationSection(userId, compilationId) {
  1111. await sectionTreeDao.copyDataFromTemplate(userId, compilationId);
  1112. }
  1113. /*
  1114. * 解决问题:
  1115. * 发布了编办之后,才设置了人材机库模板,导致已登录的用户不存在人材机库的分类树
  1116. * 为该编办下,人材机分类模板为空的用户,拷贝模板数据
  1117. * */
  1118. async function copyForSectionError(compilation) {
  1119. let users = await userModel.find({}, '_id');
  1120. for (let user of users) {
  1121. let userId = user._id.toString();
  1122. let existCount = await compleGljSectionModel.find({userId}).count();
  1123. if (existCount === 0) {
  1124. await copyCompleGljSection(userId, compilation);
  1125. }
  1126. }
  1127. }
  1128. //拷贝补充人材机分类树
  1129. async function copyCompleGljSection(userId, compilationId) {
  1130. const count = await compleGljSectionModel.count({userId, compilationId});
  1131. if (count > 0) {
  1132. return;
  1133. }
  1134. let templateData = await compleGljSectionTModel.find({compilationId: compilationId});
  1135. if (templateData.length > 0) {
  1136. let insertDatas = [],
  1137. uuidMapping = {};
  1138. //将ID替换成UUID
  1139. for (let temData of templateData) {
  1140. uuidMapping[temData.ID] = uuidV1();
  1141. }
  1142. for(let temData of templateData) {
  1143. let insertD = {
  1144. userId: userId,
  1145. compilationId: compilationId,
  1146. Name: temData.Name,
  1147. ID: uuidMapping[temData.ID],
  1148. ParentID: uuidMapping[temData.ParentID] || -1,
  1149. NextSiblingID: uuidMapping[temData.NextSiblingID] || -1,
  1150. };
  1151. insertDatas.push(insertD);
  1152. }
  1153. //插入数据
  1154. await compleGljSectionModel.insertMany(insertDatas);
  1155. }
  1156. }
  1157. async function changeFile(datas,userID,fileID,name,from,type){//from 费率或单价文件,type从单前建设项目还是从其它建设项目中复制
  1158. let projectIDs = [],newFile = {id:fileID,name:name};//计录从其它项目中复制的文件,选中多个的时候只需复制一次
  1159. let projectUpdateType = from == "feeRateFile"?"feeRate":"unitFile";
  1160. for(let d of datas){
  1161. let tem_file = from == "feeRateFile"? await feeRate_facade.changeFeeRateFile(d, newFile,type,userID):await glj_facade.changeUnitFile(d, newFile,type,userID);
  1162. if(type == 1 && tem_file){//从建设项目复制时,只有第一次需要复制,剩下的就相当于使用同个建设项目的情况了
  1163. let newID = from == "feeRateFile"?tem_file.ID:tem_file.id;
  1164. newFile = {id:newID,name:tem_file.name};
  1165. type = 0;
  1166. }
  1167. projectIDs.push({ID:d.projectID})
  1168. }
  1169. await project_facade.markProjectsToChange(projectIDs,projectUpdateType)//项目标记为待刷新状态
  1170. }
  1171. async function exportProject(userID,data){//导出建设项目
  1172. if(data.type == 'main'){
  1173. return await exportMainData(userID,data.projectID);
  1174. }else {
  1175. return await exportTenderData(data);
  1176. }
  1177. }
  1178. async function exportMainData(userID,projectID) {
  1179. let result = {userID:userID,projects:[],type:'Project'};//type 备用属性,表示导出的类型,目前导出的都是整个建设项目
  1180. let tenderIDs = [];
  1181. let project = await projectModel.findOne({ID:projectID});
  1182. if(!project) throw new Error("没有找到该建设项目:"+projectID);
  1183. result['compilationID'] = project.compilation;
  1184. result['from'] = "yanghu";
  1185. result.projects.push(project);
  1186. let subProjects = await projectModel.find({"$or": [{'ParentID':projectID}, {"property.rootProjectID": projectID}]});
  1187. for(let s of subProjects){
  1188. if(!s.deleteInfo || !s.deleteInfo.deleted){
  1189. result.projects.push(s);
  1190. if(s.projType =="Tender") tenderIDs.push(s.ID);
  1191. }
  1192. }
  1193. let files = {unitFiles:await exportUnitFiles(projectID),feeRateFiles:await exportFeeRateFiles(projectID)};
  1194. result.files = files;
  1195. result = cipher.aesEncrypt(JSON.stringify(result));
  1196. result +="|----|" +JSON.stringify(tenderIDs);
  1197. return result;
  1198. }
  1199. async function exportUnitFiles(rootProjectID){
  1200. let unitFiles = [];
  1201. let files = await unitPriceFileModel.find({root_project_id:rootProjectID});
  1202. for(let f of files){
  1203. if(f.deleteInfo && f.deleteInfo.deleted == true) continue;
  1204. let tem = {unitFile:f};
  1205. tem.unitPrices = await unitPriceModel.find({unit_price_file_id:f.id});
  1206. tem.mixRatios = await mixRatioModel.find({unit_price_file_id:f.id});
  1207. tem.freights = await freightModel.find({unit_price_file_id:f.id});
  1208. tem.originals = await originalModel.find({unit_price_file_id:f.id});
  1209. tem.com_electrovalence = await comElectrovalenceModel.find({unit_price_file_id:f.id});
  1210. unitFiles.push(tem);
  1211. }
  1212. return unitFiles;
  1213. }
  1214. async function exportFeeRateFiles(rootProjectID) {
  1215. let feeRateFiles = [];
  1216. let files = await feeRateFileModel.find({rootProjectID:rootProjectID});
  1217. for(let f of files){
  1218. if(f.deleteInfo && f.deleteInfo.deleted == true) continue;
  1219. let tem = {feeRateFile:f};
  1220. tem.feeRate = await feeRateModel.findOne({ID:f.feeRateID});
  1221. feeRateFiles.push(tem);
  1222. }
  1223. return feeRateFiles;
  1224. }
  1225. async function exportTenderData(data){
  1226. let result = {};
  1227. let projectSetting = await projectSettingModel.findOne({"projectID": data.projectID}, '-_id');
  1228. if(projectSetting) result['projSetting'] = projectSetting;
  1229. result.bills = await billsModel.find({"projectID": data.projectID});
  1230. result.rations = await rationModel.find({'$or': [{projectID: data.projectID, deleteInfo: null}, {projectID: data.projectID, 'deleteInfo.deleted': {$in: [null, false]}}]});
  1231. result.projectGLJs = await gljListModel.find({'project_id':data.projectID});
  1232. result.installationFees = await installationFeeModel.find({projectID:data.projectID});
  1233. result.rationGLJs = await rationGLJModel.find({projectID:data.projectID});
  1234. result.rationCoes = await rationCoeModel.find({projectID:data.projectID});
  1235. result.quantityDetails = await quantityDetailModel.find({projectID:data.projectID});
  1236. result.rationInstallations = await rationInstallationModel.find({projectID:data.projectID});
  1237. result.rationTemplates = await rationTemplateModel.find({projectID:data.projectID});
  1238. result.calcProgramsFile = await calcProgramsModel.findOne({projectID:data.projectID});
  1239. result.labourCoes = await labourCoesModel.findOne({projectID:data.projectID});
  1240. return cipher.aesEncrypt(JSON.stringify(result));
  1241. }
  1242. async function downLoadProjectFile(info) {
  1243. let result = {error:0};
  1244. let bucketManager2 = new qiniu.rs.BucketManager(mac, null);
  1245. let publicBucketDomain = qiniu_config.Domain;// "http://serverupdate.smartcost.com.cn";//这里不支持https
  1246. let deadline = parseInt(Date.now() / 1000) + 3600; // 1小时过期
  1247. let privateDownloadUrl = bucketManager2.privateDownloadUrl(publicBucketDomain, info.key, deadline);
  1248. let data = {
  1249. key:info.key,
  1250. userID:info.session.sessionUser.id,
  1251. status:"start",
  1252. create_time:+new Date()
  1253. };
  1254. await importLogsModel.create(data);
  1255. doDownLoadAndImport(privateDownloadUrl,info);
  1256. return result;
  1257. }
  1258. async function doDownLoadAndImport(privateDownloadUrl,info) {
  1259. let stream = fs.createWriteStream(path.join(__dirname, "../../../tmp/"+info.key));//
  1260. request(privateDownloadUrl).pipe(stream).on("close", async function (err) {
  1261. console.log("文件[" + info.key + "]下载完毕");
  1262. let doc = {status:"finish"};
  1263. try {
  1264. let data = fs.readFileSync(stream.path,'utf-8');
  1265. let result = await importProject(data,{session:info.session},info.updateData);
  1266. doc.projectID = result.constructionProjectID;
  1267. if(result.error == 1){
  1268. doc.errorMsg = result.msg;
  1269. doc.status = "error";
  1270. }
  1271. }catch (error){
  1272. console.log(error);
  1273. doc.errorMsg = "导入失败,请检查文件!";
  1274. doc.status = "error";
  1275. }finally {
  1276. await importLogsModel.update({key:info.key},doc);
  1277. fs.unlinkSync(stream.path);
  1278. }
  1279. });
  1280. }
  1281. async function importProcessChecking(data){
  1282. let result = {error:0};
  1283. let log = await importLogsModel.findOne({key:data.key});
  1284. if(log){
  1285. if(log.status == "finish"){
  1286. result.status = "complete";
  1287. await importLogsModel.remove({key:data.key});
  1288. // 获取导入的项目数据
  1289. if (log.projectID) {
  1290. const projects = await getPosterityProjects([log.projectID], true);
  1291. const summaryInfo = await getSummaryInfo([log.projectID]);
  1292. setupSummaryFields(summaryInfo, projects);
  1293. result.data = projects;
  1294. }
  1295. }else if(log.status == "start"){
  1296. result.status = "processing";
  1297. }else if(log.status == "error"){
  1298. result.error = 1;
  1299. result.msg = log.errorMsg;
  1300. await importLogsModel.remove({key:data.key});
  1301. }
  1302. }else {
  1303. result.error = 1;
  1304. result.msg = `导入过程中发生错误!`;
  1305. }
  1306. return result;
  1307. }
  1308. async function importProject(data,req,updateData) {
  1309. let result = {error:0};
  1310. let stringArr = data.split("|----|");
  1311. let datas = [];
  1312. for(let s of stringArr){
  1313. datas.push(JSON.parse(cipher.aesDecrypt(s)));
  1314. }
  1315. let mainData = datas.length > 0 ?datas[0]:null;
  1316. if(mainData){
  1317. if(mainData.from && mainData.from != "yanghu"){
  1318. result.error = 1;
  1319. result.msg = "导入失败:您要导入的文件是由“大司空云计价”导出,当前软件是“纵横公路养护云版”,请选择正确的软件再进行操作!";
  1320. }else if(mainData.compilationID != req.session.sessionCompilation._id){
  1321. const fileCompilation = await compilationModel.findOne({_id: mongoose.Types.ObjectId(mainData.compilationID)}, 'name');
  1322. const fileCompilationName = fileCompilation ? fileCompilation.name : '未知的编制办法';
  1323. const curCompilationName = req.session.sessionCompilation.name;
  1324. result.error = 1;
  1325. result.msg = `导入失败:您要导入的文件是由“${fileCompilationName}”导出,当前软件是“${curCompilationName}”,请选择正确的编制办法再进行操作!`;
  1326. }else {
  1327. const tenders = mainData.projects.filter(item => item.projType === projectType.tender);
  1328. const tenderOverrun = await isTenderOverrun(tenders.length, req.session);
  1329. if (tenderOverrun) {
  1330. result.error = 1;
  1331. result.msg = `您创建的项目个数超限,请联系我们的客服人员,或者导出建设项目保存到本地备份,删除云上数据。`;
  1332. }
  1333. let [constructionProjectID,projectIDMap,labourCoeFileIDMap,calcProgramFileIDMap] = await handleMainProjectDatas(mainData,updateData,req.session.sessionUser.id);
  1334. result.constructionProjectID = constructionProjectID;
  1335. if(datas.length > 1 ){
  1336. for(let i = 1;i<datas.length;i++){
  1337. await handleEachProject(datas[i],projectIDMap,labourCoeFileIDMap,calcProgramFileIDMap)
  1338. }
  1339. }
  1340. }
  1341. }
  1342. return result;
  1343. }
  1344. async function handleEachProject(data,projectIDMap,labourCoeFileIDMap,calcProgramFileIDMap){
  1345. let bills = [],rations = [],projectGLJs = [],rationGLJs=[],rationCoes=[],quantityDetails=[],rationInstallations=[],rationTemplates=[];
  1346. let newProjectSetting =null,newCalcProgramsFile = null,newLabourCoe = null;
  1347. let billsIDMap = {},projectGLJIDMap={},rationIDMap = {};
  1348. let newProjectID = projectIDMap[data.projSetting.projectID];
  1349. //生成新的清单;
  1350. if(data.bills && data.bills.length > 0){
  1351. for(let b of data.bills){
  1352. billsIDMap[b.ID] = uuidV1();
  1353. }
  1354. for(let b of data.bills){
  1355. delete b._id;
  1356. b = getCopyBillDatas(b,newProjectID,billsIDMap);
  1357. bills.push(b);
  1358. }
  1359. }
  1360. //生成项目工料机数据
  1361. if(data.projectGLJs && data.projectGLJs.length > 0){
  1362. let gljCount = await counter.counterDAO.getIDAfterCountSync(counter.moduleName.glj_list, data.projectGLJs.length);
  1363. for(let i = 0; i < data.projectGLJs.length; i++){
  1364. let d = data.projectGLJs[i];
  1365. delete d._id;
  1366. let newID = gljCount.sequence_value - (data.projectGLJs.length - 1) + i;
  1367. projectGLJIDMap[d.id] = newID;
  1368. d.project_id = newProjectID;
  1369. d.id = newID;
  1370. projectGLJs.push(d);
  1371. }
  1372. }
  1373. //生成新的定额
  1374. if(data.rations && data.rations.length > 0){
  1375. for(let r of data.rations){
  1376. rationIDMap[r.ID] = uuidV1();
  1377. }
  1378. for(let r of data.rations){
  1379. delete r._id;
  1380. r = getCopyRationData(r,newProjectID,billsIDMap,rationIDMap,projectGLJIDMap);
  1381. rations.push(r);
  1382. }
  1383. }
  1384. //生成定额下挂的定额工料机等等数据
  1385. if(data.rationGLJs && data.rationGLJs.length > 0) rationGLJs = setRationSubList(data.rationGLJs,newProjectID,billsIDMap,rationIDMap,projectGLJIDMap);
  1386. if(data.rationCoes && data.rationCoes.length > 0) rationCoes = setRationSubList(data.rationCoes,newProjectID,billsIDMap,rationIDMap,projectGLJIDMap);
  1387. if(data.quantityDetails && data.quantityDetails.length > 0) quantityDetails = setRationSubList(data.quantityDetails,newProjectID,billsIDMap,rationIDMap,projectGLJIDMap);
  1388. if(data.rationInstallations && data.rationInstallations.length > 0) rationInstallations = setRationSubList(data.rationInstallations,newProjectID,billsIDMap,rationIDMap,projectGLJIDMap);
  1389. if(data.rationTemplates && data.rationTemplates.length > 0) rationTemplates = setRationSubList(data.rationTemplates,newProjectID,billsIDMap,rationIDMap,projectGLJIDMap);
  1390. //生成projectSetting 文件
  1391. if(data.projSetting){
  1392. data.projSetting.projectID =newProjectID;
  1393. newProjectSetting = data.projSetting;
  1394. delete newProjectSetting._id;
  1395. }
  1396. //生成计算程序文件,系数文件
  1397. if(data.calcProgramsFile && calcProgramFileIDMap[data.calcProgramsFile.ID]){
  1398. data.calcProgramsFile.ID = calcProgramFileIDMap[data.calcProgramsFile.ID];
  1399. data.calcProgramsFile.projectID = newProjectID;
  1400. newCalcProgramsFile = data.calcProgramsFile;
  1401. delete newCalcProgramsFile._id;
  1402. }
  1403. if(data.labourCoes && labourCoeFileIDMap[data.labourCoes.ID]){
  1404. data.labourCoes.ID = labourCoeFileIDMap[data.labourCoes.ID];
  1405. data.labourCoes.projectID = newProjectID;
  1406. newLabourCoe = data.labourCoes;
  1407. delete newLabourCoe._id;
  1408. }
  1409. if(newProjectSetting) await projectSettingModel.create(newProjectSetting);
  1410. if(bills.length > 0) await insertMany(bills,billsModel);
  1411. if(rations.length > 0) await insertMany(rations,rationModel);
  1412. if(projectGLJs.length > 0) await insertMany(projectGLJs,gljListModel);
  1413. if(rationGLJs.length > 0) await insertMany(rationGLJs,rationGLJModel);
  1414. if(rationCoes.length > 0) await insertMany(rationCoes,rationCoeModel);
  1415. if(quantityDetails.length > 0) await insertMany(quantityDetails,quantityDetailModel);
  1416. if(rationInstallations.length > 0) await insertMany(rationInstallations,rationInstallationModel);
  1417. if(rationTemplates.length > 0) await insertMany(rationTemplates,rationTemplateModel);
  1418. if(newCalcProgramsFile) await calcProgramsModel.create(newCalcProgramsFile);
  1419. if(newLabourCoe) await labourCoesModel.create(newLabourCoe);
  1420. }
  1421. function setRationSubList(datas,newProjectID,billIDMap,rationIDMap,projectGLJIDMap) {
  1422. let arrs = [];
  1423. for(let d of datas){
  1424. delete d._id;
  1425. d = getCopyRationSubData(d,newProjectID,billIDMap,rationIDMap,projectGLJIDMap);
  1426. arrs.push(d);
  1427. }
  1428. return arrs;
  1429. }
  1430. async function handleMainProjectDatas(mainData,updateData,userID) {
  1431. let mainProjectID = -1;
  1432. let projectIDMap = {},feeRateFileIDMap={},unitPriceFileIDMap={},labourCoeFileIDMap={},calcProgramFileIDMap={};
  1433. let tasks = [];
  1434. projectIDMap[-1] = -1;//最后一个项目的nextID为-1的情况
  1435. let constructionProjectID;
  1436. //生成新的projectID
  1437. for(let p of mainData.projects){
  1438. let newProjectID = await getCounterID("projects");
  1439. projectIDMap[p.ID] = newProjectID;
  1440. if(p.projType == "Project") {
  1441. mainProjectID = newProjectID;
  1442. constructionProjectID = newProjectID;
  1443. }
  1444. if(p.projType == "Tender"){
  1445. if(p.property.calcProgramFile) calcProgramFileIDMap[p.property.calcProgramFile.ID] = uuidV1();//新的计算程序文件ID
  1446. if(p.property.labourCoeFile) labourCoeFileIDMap[p.property.labourCoeFile.ID] = uuidV1();//新的人工调整系数文件ID
  1447. if(p.property.feeFile) feeRateFileIDMap[p.property.feeFile.id] = uuidV1();//新的费率文件ID
  1448. if(p.property.unitPriceFile) unitPriceFileIDMap[p.property.unitPriceFile.id] = await getCounterID("unit_price_file");//新的单价文件ID
  1449. }
  1450. }
  1451. if(mainProjectID == -1) throw new Error("文件里面没包含建设项目信息!");
  1452. //处理项目信息 ----- 费率文件,单价文件ID信息要重新生成----to do
  1453. for(let p of mainData.projects){
  1454. delete p._id;
  1455. delete p.__v;
  1456. p.ID = projectIDMap[p.ID];
  1457. if(p.ID == mainProjectID){//对于建设项目,要父和下一节点ID要使用前端传入的位置ID
  1458. p.ParentID = updateData.self.ParentID;
  1459. p.NextSiblingID = updateData.self.NextSiblingID;
  1460. if(updateData.update){//树节构中的上一节点的下一节点设置为本建设项目ID;
  1461. tasks.push({updateOne:{filter : updateData.update.query, update : {NextSiblingID:mainProjectID}}});
  1462. }
  1463. //查看是否重名;
  1464. let temp = await projectModel.findOne({userID:userID,ParentID:p.ParentID,name:p.name});
  1465. if(temp) p.name = p.name + '(' + moment(Date.now()).tz("Asia/Shanghai").format('MM-DD HH:mm:ss') + '导入)';
  1466. }else {
  1467. p.ParentID = projectIDMap[p.ParentID];
  1468. p.NextSiblingID = projectIDMap[p.NextSiblingID];
  1469. }
  1470. p.userID =userID;
  1471. p.shareInfo=[];
  1472. if(p.projType == "Tender"){
  1473. if(p.property.calcProgramFile) p.property.calcProgramFile.ID = calcProgramFileIDMap[p.property.calcProgramFile.ID];
  1474. if(p.property.labourCoeFile) p.property.labourCoeFile.ID = labourCoeFileIDMap[p.property.labourCoeFile.ID];
  1475. if(p.property.feeFile) p.property.feeFile.id = feeRateFileIDMap[p.property.feeFile.id];
  1476. if(p.property.unitPriceFile) p.property.unitPriceFile.id = unitPriceFileIDMap[p.property.unitPriceFile.id];
  1477. p.property.rootProjectID = mainProjectID
  1478. }
  1479. tasks.push({insertOne: {document: p}})
  1480. }
  1481. //项目树节构数据生成:
  1482. await projectModel.bulkWrite(tasks);
  1483. //生成所有的费率文件
  1484. await importFeeRateFiles(mainData,projectIDMap,feeRateFileIDMap,userID);
  1485. //生成所有的单价文件
  1486. await importUnitPriceFiles(mainData,projectIDMap,unitPriceFileIDMap,userID);
  1487. return [constructionProjectID,projectIDMap,labourCoeFileIDMap,calcProgramFileIDMap]
  1488. }
  1489. async function importUnitPriceFiles(mainData,projectIDMap,unitPriceFileIDMap,userID) {
  1490. if(!mainData.files.unitFiles) return;
  1491. let unitFiles = [],unitPrices =[],mixRatios=[],freights=[],originals=[],com_electrovalences=[];
  1492. for(let f of mainData.files.unitFiles){
  1493. let file = f.unitFile,prices = f.unitPrices,mixs = f.mixRatios,fres = f.freights,ors = f.originals,ec=f.com_electrovalence;
  1494. //生成单价文件
  1495. delete file._id;
  1496. file.id = unitPriceFileIDMap[file.id]?unitPriceFileIDMap[file.id]:await getCounterID("unit_price_file");
  1497. file.project_id = projectIDMap[file.project_id];
  1498. file.root_project_id = projectIDMap[file.root_project_id];
  1499. file.user_id = userID;
  1500. unitFiles.push(file);
  1501. //生成子数据
  1502. if(prices) await setSubList(prices,unitPrices,file.id,unitPriceModel);
  1503. if(mixs) await setSubList(mixs,mixRatios,file.id,mixRatioModel);
  1504. if(fres) await setSubList(fres,freights,file.id,freightModel,true);
  1505. if(ors) await setSubList(ors,originals,file.id,originalModel,true);
  1506. if(ec) await setSubList(ec,com_electrovalences,file.id,comElectrovalenceModel,true);
  1507. }
  1508. if(unitFiles.length > 0) await insertMany(unitFiles,unitPriceFileModel);
  1509. if(unitPrices.length > 0) await insertMany(unitPrices,unitPriceModel);
  1510. if(mixRatios.length > 0) await insertMany(mixRatios,mixRatioModel);
  1511. if(freights.length > 0) await insertMany(freights,freightModel);
  1512. if(originals.length > 0) await insertMany(originals,originalModel);
  1513. if(com_electrovalences.length > 0) await insertMany(com_electrovalences,comElectrovalenceModel);
  1514. async function setSubList(oList,nList,fileID,model,UUID=false) {
  1515. for(let o of oList){
  1516. delete o._id;
  1517. o.unit_price_file_id = fileID;
  1518. UUID == true?o.ID = uuidV1():o.id = await getCounterID(model.modelName);
  1519. nList.push(o)
  1520. }
  1521. }
  1522. }
  1523. async function importFeeRateFiles(mainData,projectIDMap,feeRateFileIDMap,userID) {
  1524. let feeRateFiles = [], feeRates = [];
  1525. if(!mainData.files.feeRateFiles) return;
  1526. for(let f of mainData.files.feeRateFiles){
  1527. //生成费率记录
  1528. let rate = f.feeRate;
  1529. delete rate._id;
  1530. rate.ID = uuidV1();
  1531. feeRates.push(rate);
  1532. //生成费率文件记录
  1533. let file = f.feeRateFile;
  1534. delete file._id;
  1535. file.ID = feeRateFileIDMap[file.ID]?feeRateFileIDMap[file.ID]:uuidV1();
  1536. file.userID = userID;
  1537. file.rootProjectID = projectIDMap[file.rootProjectID];
  1538. file.feeRateID = rate.ID;
  1539. feeRateFiles.push(file);
  1540. }
  1541. if(feeRateFiles.length > 0) await insertMany(feeRateFiles,feeRateFileModel);
  1542. if(feeRates.length > 0) await insertMany(feeRates,feeRateModel);
  1543. }
  1544. // 检查单价、费率文件,处理rootProjectID为-1的旧数据(以前的初始化例题bug造成)
  1545. async function checkFiles(projects) {
  1546. // fileID - tenderID 映射
  1547. const mapping = {};
  1548. const tenderItems = [];
  1549. const unitFileIDs = [];
  1550. const rateFileIDs = [];
  1551. const task = [];
  1552. projects.forEach(project => {
  1553. const isErrorRootProjectTender = project.projType === projectType.tender && project.property.rootProjectID === -1;
  1554. if (isErrorRootProjectTender) {
  1555. tenderItems.push({ ID: project.ID, ParentID: project.ParentID });
  1556. const priceFileID = project.property.unitPriceFile.id;
  1557. const feeFileID = project.property.feeFile.id;
  1558. if (!mapping[priceFileID]) {
  1559. mapping[priceFileID] = project;
  1560. unitFileIDs.push(priceFileID);
  1561. }
  1562. if (!mapping[feeFileID]) {
  1563. mapping[feeFileID] = project;
  1564. rateFileIDs.push(feeFileID);
  1565. }
  1566. }
  1567. });
  1568. // 检查是否存在rootProjectID为-1的
  1569. const errorUnitFiles = await unitPriceFileModel.find({id: {$in: unitFileIDs}, root_project_id: -1});
  1570. const errorRateFiles = await feeRateFileModel.find({ID: {$in: rateFileIDs}, rootProjectID: -1});
  1571. const unitFileTask = errorUnitFiles.map(file => {
  1572. const rootProjectID = mapping[file.id].ParentID;
  1573. return {
  1574. updateOne: {
  1575. filter: {id: file.id},
  1576. update: {$set: {root_project_id: rootProjectID}}
  1577. }
  1578. };
  1579. });
  1580. if (unitFileTask.length) {
  1581. task.push(unitPriceFileModel.bulkWrite(unitFileTask));
  1582. }
  1583. const rateFileTask = errorRateFiles.map(file => {
  1584. const rootProjectID = mapping[file.ID].ParentID;
  1585. return {
  1586. updateOne: {
  1587. filter: {ID: file.ID},
  1588. update: {$set: {rootProjectID: rootProjectID}}
  1589. }
  1590. };
  1591. });
  1592. if (rateFileTask.length) {
  1593. task.push(feeRateFileModel.bulkWrite(rateFileTask));
  1594. }
  1595. const tenderTask = tenderItems.map(item => {
  1596. return {
  1597. updateOne: {
  1598. filter: {ID: item.ID},
  1599. update: {$set: {'property.rootProjectID': item.ParentID}}
  1600. }
  1601. }
  1602. });
  1603. if (tenderTask.length) {
  1604. task.push(projectModel.bulkWrite(tenderTask));
  1605. }
  1606. await Promise.all(task);
  1607. }
  1608. function uploadToken() {
  1609. let options = {
  1610. scope: qiniu_config.Bucket,
  1611. deleteAfterDays: 1,
  1612. returnBody:
  1613. '{"key":"$(key)","hash":"$(etag)","fsize":$(fsize),"bucket":"$(bucket)","name":"$(x:name)"}'
  1614. };
  1615. let putPolicy = new qiniu.rs.PutPolicy(options);
  1616. let token = putPolicy.uploadToken(mac);
  1617. let result = {
  1618. uptoken: token,
  1619. domain: qiniu_config.Domain
  1620. }
  1621. return result
  1622. }
  1623. // 有些方法无法通过中间件就检查单位工程数量是否超限
  1624. // 需要到具体的业务代码中进行判断
  1625. // 这个方法就是具体业务代码中,需要检查单位工程数量是否超限用
  1626. async function isTenderOverrun(tenderCount, session) {
  1627. const userID = session.sessionUser.id;
  1628. const compilation = session.sessionCompilation._id;
  1629. const compilationVersion = session.compilationVersion || '免费';
  1630. let systemSetting = session.systemSetting || (session.systemSetting = await systemSettingMiddleware.getSystemSetting());
  1631. // 这种情况只有在刚上线此功能时会出现,不考虑时间差
  1632. if (!systemSetting) {
  1633. return false;
  1634. }
  1635. const type = compilationVersion.includes('免费') ? 'normal' : 'professional';
  1636. const limit = systemSetting[type].project;
  1637. const curTenderCount = await projectModel.count({userID, compilation, projType: 'Tender', '$or':[{deleteInfo: null}, {'deleteInfo.completeDeleted': false}]});
  1638. return tenderCount + curTenderCount > limit;
  1639. }
  1640. async function getWelcomeInfo(compilationId,sessionUser) {
  1641. let setting = await welcomeModel.findOne({compilationId:compilationId});
  1642. let isShow = false;
  1643. let context = "";
  1644. if(setting){
  1645. if(setting.showType == 0) return [false,""];//关闭
  1646. context = setting.context;
  1647. if(setting.showType == 1){//每天一次
  1648. let dataString =moment(Date.now()).tz("Asia/Shanghai").format('YYYY-MM-DD');//今天的日期字符串
  1649. let userInfo =await userModel.findOne({_id: mongoose.Types.ObjectId(sessionUser.id)});
  1650. if (dataString != userInfo.welcomeShowTime){//今天没登录过
  1651. isShow = true;
  1652. await userModel.update({_id: mongoose.Types.ObjectId(sessionUser.id)},{welcomeShowTime:dataString})
  1653. }
  1654. }else if(setting.showType == 2){//每次登录显示
  1655. isShow = sessionUser.newLogin?true:false;
  1656. sessionUser.newLogin = false
  1657. }
  1658. }
  1659. return [isShow,context]
  1660. }