project_model.js 38 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883
  1. /**
  2. * Created by Mai on 2017/1/18.
  3. */
  4. let projectType = {
  5. folder: 'Folder',
  6. tender: 'Tender',
  7. project: 'Project',
  8. engineering: 'Engineering',
  9. };
  10. let fileType = {
  11. unitPriceFile: 'UnitPriceFile',
  12. feeRateFile: 'FeeRateFile'
  13. };
  14. //先导出后require可以解决循环引用问题
  15. module.exports ={ project: new ProjectsDAO(),
  16. projType: projectType,
  17. fileType: fileType
  18. };
  19. const mongoose = require('mongoose');
  20. const async_c = require('async');
  21. const UnitPriceFileModel = require("../../glj/models/unit_price_file_model");
  22. let UnitPriceFiles = mongoose.model('unit_price_file');
  23. const {
  24. defaultDecimal,
  25. billsQuantityDecimal,
  26. basicInformation,
  27. displaySetting,
  28. calcOptions,
  29. tenderSetting,
  30. bookmarkSetting
  31. } = require('./project_property_template');
  32. const optionSetting = require('../../options/models/optionTypes');
  33. const { ValuationType, ValuationText } = require('../../../public/common_constants');
  34. let FeeRateFiles = mongoose.model('fee_rate_file');
  35. let counter = require("../../../public/counter/counter.js");
  36. let newProjController = require('../controllers/new_proj_controller');
  37. let copyProjController = require('../controllers/copy_proj_controller');
  38. let feeRateFacade = require('../../fee_rates/facade/fee_rates_facade');
  39. let labourCoeFacade = require('../../main/facade/labour_coe_facade');
  40. let calcProgramFacade = require('../../main/facade/calc_program_facade');
  41. let installationFacade = require('../../main/facade/installation_facade');
  42. let pmFacade = require('../facade/pm_facade');
  43. let gljFacade = require('../../glj/facade/glj_facade');
  44. let logger = require("../../../logs/log_helper").logger;
  45. let BillsModel = require("../../main/models/bills").model;
  46. let _ = require('lodash');
  47. let index = require("../../system_setting/model/index");
  48. let Projects = mongoose.model('projects');
  49. let mainColLibModel = mongoose.model('std_main_col_lib');
  50. let projSettingModel = mongoose.model('proj_setting');
  51. let optionModel = mongoose.model('options');
  52. const uuidV1 = require('uuid/v1');
  53. function ProjectsDAO() {
  54. }
  55. ProjectsDAO.prototype.getAllUnitProjects = async function (userId, compilation, rootPrjID, callback) {
  56. //根据root project id获取所有的非删除单位工程
  57. try {//
  58. let projects = await Projects.find({
  59. '$or': [
  60. {
  61. 'userID': userId,
  62. 'compilation': compilation,
  63. 'property.rootProjectID': rootPrjID,
  64. 'deleteInfo': null
  65. },
  66. {
  67. 'userID': userId,
  68. 'compilation': compilation,
  69. 'property.rootProjectID': rootPrjID,
  70. 'deleteInfo.deleted': {'$in': [null, false]}
  71. }
  72. ]
  73. }, '-_id', {lean: true});
  74. let projIDs= [];
  75. const allIDs = [];
  76. for(let project of projects){
  77. allIDs.push(project.ID);
  78. if(project.projType === projectType.project){
  79. projIDs.push(project.ID);
  80. }
  81. }
  82. // 设置分享信息
  83. const shareMap = await pmFacade.getShareInfoMap(allIDs);
  84. projects.forEach(project => {
  85. project.shareInfo = shareMap[project.ID] || [];
  86. });
  87. // 当前费用定额未读的分享的条目数量
  88. // 设置汇总字段
  89. let summaryInfo = await pmFacade.getSummaryInfo(projIDs);
  90. pmFacade.setupSummaryFields(summaryInfo, projects);
  91. callback(0, '', projects);
  92. }
  93. catch (err) {
  94. callback(1, 'Error', null);
  95. }
  96. }
  97. ProjectsDAO.prototype.getUserProjects = async function (userId, compilation, callback) {
  98. try {//
  99. let projects = await Projects.find({
  100. '$or': [{
  101. 'userID': userId,
  102. 'compilation': compilation,
  103. 'deleteInfo': null
  104. }, {'userID': userId, 'compilation': compilation, 'deleteInfo.deleted': {'$in': [null, false]}}]
  105. }, '-_id', {lean: true});
  106. await pmFacade.checkFiles(projects);
  107. let projIDs= [];
  108. const allIDs = [];
  109. for(let project of projects){
  110. allIDs.push(project.ID);
  111. if(project.projType === projectType.project){
  112. projIDs.push(project.ID);
  113. }
  114. }
  115. // 设置分享信息
  116. const shareMap = await pmFacade.getShareInfoMap(allIDs);
  117. projects.forEach(project => {
  118. project.shareInfo = shareMap[project.ID] || [];
  119. });
  120. //设置汇总字段
  121. let summaryInfo = await pmFacade.getSummaryInfo(projIDs);
  122. pmFacade.setupSummaryFields(summaryInfo, projects);
  123. /* for(let proj of projects){
  124. let summaryProj = summaryInfo[proj.ID];
  125. if(summaryProj){
  126. proj.totalCost = summaryProj.totalCost;
  127. }
  128. } */
  129. callback(0, '', projects);
  130. }
  131. catch (err) {
  132. console.log(err.stack);
  133. callback(1, 'Error', null);
  134. }
  135. };
  136. ProjectsDAO.prototype.getUserProjectAsync = async function (userId, ProjId) {
  137. let template = await Projects.findOne({$or: [{deleteInfo: null}, {'deleteInfo.deleted': false}], ID: ProjId}, '-_id');
  138. if (template && userId !== template.userID) {
  139. template._doc.readOnly = true;
  140. }
  141. return template;
  142. };
  143. ProjectsDAO.prototype.getUserProject = function (userId, ProjId, callback) {
  144. Projects.findOne({$or: [{deleteInfo: null}, {'deleteInfo.deleted': false}], ID: ProjId}, '-_id', function (err, template) {
  145. if (err) {
  146. callback(1, '找不到标段数据', null);
  147. } else {
  148. //打开分享的项目,只读
  149. if(template && userId !== template.userID){
  150. template._doc.readOnly = true;
  151. }
  152. callback(0, '', template);
  153. }
  154. });
  155. };
  156. ProjectsDAO.prototype.updateUserProjects = async function (userId, compilationId, compilation, datas, callback) {
  157. let data, project, updateLength = 0, hasError = false, deleteInfo = null, i, newProject;
  158. let updateAll = function (err) {
  159. if (!err) {
  160. updateLength += 1;
  161. if (updateLength === datas.length) {
  162. callback(0, '', datas);
  163. }
  164. } else {
  165. hasError = true;
  166. console.log(err);
  167. callback(1, '提交数据出错.', null);
  168. }
  169. };
  170. if (datas) {
  171. for (i = 0; i < datas.length && !hasError; i++) {
  172. data = datas[i];
  173. if (data.updateData.name !== undefined) {
  174. data.updateData.name = data.updateData.name.trim();
  175. }
  176. if (data.updateType === 'update') {
  177. Projects.update({userID: userId, ID: data.updateData.ID}, data.updateData, updateAll);
  178. }
  179. else if (data.updateType === 'new') {
  180. let overWrite;
  181. if(compilation.overWriteUrl && compilation.overWriteUrl!=""){
  182. overWrite = require("../../.."+compilation.overWriteUrl);
  183. }
  184. data.updateData.GUID = uuidV1();
  185. data.updateData['userID'] = userId;
  186. data.updateData['compilation'] = compilationId;
  187. data.updateData['createDateTime'] = new Date();
  188. data.updateData['fileVer'] = await index.getVersion();
  189. if(data.updateData.projType === projectType.project){
  190. //设置建设项目基本信息,多个单位工程共用
  191. const fileKind = data.updateData.property.boqType;
  192. if (fileKind) {
  193. const infoLib = await pmFacade.getBasicInfo(compilationId, fileKind);
  194. data.updateData.property.basicInformation = infoLib && infoLib.info || basicInformation;
  195. } else {
  196. data.updateData.property.basicInformation = [];
  197. }
  198. }
  199. // 如果没有选中单价文件则新增单价文件
  200. if (data.updateData.projType === projectType.tender && data.updateData.property !== null &&
  201. Object.keys(data.updateData.property.unitPriceFile).length > 0 &&
  202. data.updateData.property.unitPriceFile.id === '') {
  203. let unitPriceFileModel = new UnitPriceFileModel();
  204. let insertData = {
  205. name: data.updateData.name,
  206. project_id: data.updateData.ID,
  207. user_id: userId,
  208. root_project_id: data.updateData.property.rootProjectID
  209. };
  210. if(overWrite && overWrite.getDefalutAssistProductionFeeRate) insertData.assistProductionFeeRate = overWrite.getDefalutAssistProductionFeeRate();
  211. let addResult = await unitPriceFileModel.add(insertData);
  212. if (!addResult) {
  213. callback(1, '新增单价文件失败.', null);
  214. return;
  215. }
  216. data.updateData.property.unitPriceFile.id = addResult.id;
  217. //新增单价文件的同时,在项目工料机和空白的单价文件中先插入机械组成物等信息
  218. await gljFacade.addMixRatioForNew(data.updateData.ID,addResult.id,data.updateData.property.engineering_id,pmFacade.getExtendData(data.updateData.property,compilation));
  219. }
  220. if (data.updateData.projType === projectType.tender) {
  221. //单价文件
  222. data.updateData.property.unitPriceFile.id=parseInt(data.updateData.property.unitPriceFile.id);
  223. //小数位数
  224. data.updateData.property.decimal = overWrite && overWrite.defaultDecimal || defaultDecimal;
  225. //清单工程量精度
  226. data.updateData.property.billsQuantityDecimal = billsQuantityDecimal;
  227. //基本信息-挪到建设项目下,多个单位工程共用
  228. //basicInformation[0]['items'][1]['value'] = data.updateData.property.engineeringName || '';
  229. //data.updateData.property.basicInformation = basicInformation;
  230. //工程特征
  231. if(data.updateData.property.featureLibID){
  232. const matchedConstructionProject = datas.find(item => item.updateData.projType === projectType.project);
  233. let constructionProjectName = '';
  234. if (matchedConstructionProject) {
  235. constructionProjectName = matchedConstructionProject.updateData.name;
  236. } else {
  237. const findConstructionProject = await Projects.findOne({ ID: data.updateData.ParentID }).lean();
  238. constructionProjectName = findConstructionProject && findConstructionProject.name || '';
  239. }
  240. //项目类别(valuationType)、养护类别(engineering)、费用标准(feeStandard)根据新建分选的选项去赋值
  241. let assign = {
  242. valuationType: ValuationText[data.updateData.property.valuationType] || '',
  243. engineering: data.updateData.property.engineeringName,
  244. feeStandard: data.updateData.property.feeStandardName,
  245. // 新建分段文件时,默认将“编制范围”填写分段文件的名称
  246. // 为了防止用户漏填,导出电子招标文件时,有数据
  247. compilationScope: data.updateData.name,
  248. // 新建分段文件时,默认将“工程特征”-“单项工程名称”填写建设项目名称
  249. singleProjName: constructionProjectName,
  250. };
  251. data.updateData.property.projectFeature = await pmFacade.getProjectFeature(data.updateData.property.featureLibID, data.updateData.property.valuation, assign);
  252. }
  253. /*projectFeature[0]['value'] = data.updateData.property.engineeringName || '';
  254. data.updateData.property.projectFeature = projectFeature;*/
  255. //累进区间
  256. if (data.updateData.property.progressiveLibID) {
  257. data.updateData.property.progressiveInterval = await pmFacade.getProgressiveInterval(data.updateData.property.progressiveLibID);
  258. }
  259. //呈现选项
  260. data.updateData.property.displaySetting = displaySetting;
  261. let defaultCalcMode = overWrite && overWrite.defaultCalcMode || ((data.updateData.property.valuationType !== ValuationType.BOQ) ? 2 : 1);
  262. data.updateData.property.billsCalcMode = defaultCalcMode;
  263. data.updateData.property.zanguCalcMode = 0;
  264. //计算选项
  265. data.updateData.property.calcOptions = calcOptions;
  266. if (data.updateData.property.valuationType !== ValuationType.BOQ) {//价差预备费
  267. //年造价增涨率
  268. data.updateData.property.costGrowthRate = 0;
  269. //增涨计费年限
  270. data.updateData.property.growthPeriod = 0;
  271. }
  272. //安装增加费
  273. if(data.updateData.property.isInstall == true || data.updateData.property.isInstall=='true'){//判断是否安装工程
  274. await installationFacade.copyInstallationFeeFromLib(data.updateData.ID,data.updateData.property.engineering_id);
  275. }
  276. //锁定清单
  277. data.updateData.property.lockBills = false;
  278. //工料机单价调整系数
  279. data.updateData.property.tenderSetting = tenderSetting;
  280. //书签和批注
  281. data.updateData.property.bookmarkSetting = bookmarkSetting;
  282. }
  283. newProject = new Projects(data.updateData);
  284. /* // 查找同级是否存在同名数据
  285. let exist = await this.isExist(userId, compilationId, data.updateData.name, data.updateData.ParentID);
  286. if (exist) {
  287. callback(1, '同级目录已存在相同名称数据.', null);
  288. return;
  289. }*/
  290. if (data.updateData.projType === 'Tender') {
  291. let feeRateFileID = await feeRateFacade.newFeeRateFile(userId, data.updateData);
  292. newProject.property.feeFile = feeRateFileID ? feeRateFileID : -1;
  293. // 新建人工系数文件 CSL, 2017.10.13
  294. let lcFile = await labourCoeFacade.newProjectLabourCoe(data.updateData);
  295. newProject.property.labourCoeFile = lcFile ? lcFile : null;
  296. // 新建计算程序文件 CSL, 2017.10.23
  297. let cpFile = await calcProgramFacade.newProjectCalcProgramFile(data.updateData);
  298. newProject.property.calcProgramFile = cpFile ? cpFile : null;
  299. }
  300. newProject.save(async function (err, result) {
  301. if (!err && result._doc.projType === projectType.tender) {
  302. newProjController.copyTemplateData(result._doc.property, newProject.ID, updateAll);
  303. } else {
  304. updateAll(err);
  305. }
  306. });
  307. }
  308. else if (data.updateType === 'delete') {
  309. deleteInfo = {};
  310. deleteInfo['deleted'] = true;
  311. deleteInfo['deleteDateTime'] = new Date();
  312. deleteInfo['deleteBy'] = userId;
  313. data.updateData['deleteInfo'] = deleteInfo;
  314. //Projects.update({userID: userId, ID: data.updateData.ID}, data.updateData, updateAll);
  315. //update
  316. if (data.updateData.projType === projectType.project) {
  317. let tenders = await Projects.find({ userID: userId, ParentID: data.updateData.ID });
  318. if (tenders.length > 0) {
  319. await UnitPriceFiles.update({
  320. user_id: userId,
  321. root_project_id: data.updateData.ID
  322. }, { $set: { deleteInfo: deleteInfo } }, { multi: true });
  323. await FeeRateFiles.update({
  324. userID: userId,
  325. rootProjectID: data.updateData.ID
  326. }, { $set: { deleteInfo: deleteInfo } }, { multi: true });
  327. await Projects.update({ userID: userId, ID: data.updateData.ID }, data.updateData, updateAll);
  328. } else {//true
  329. await UnitPriceFiles.remove({ user_id: userId, root_project_id: data.updateData.ID });
  330. await FeeRateFiles.remove({ userID: userId, rootProjectID: data.updateData.ID });
  331. //await Projects.update({userID: userId, NextSiblingID: data.updateData.ID, deleteInfo: null}, {$set: {NextSiblingID: data.NextSiblingID}});
  332. await Projects.remove({ userID: userId, ID: data.updateData.ID }, updateAll);
  333. }
  334. } else if (data.updateData.projType === projectType.tender) {//fake
  335. let delTender = await Projects.findOne({ userID: userId, ID: data.updateData.ID });
  336. //如果这个单位工程用到的费率文件、单价文件,没有被其他的单位工程使用,则应该一起跟随删除
  337. if (delTender) {
  338. let unitPriceFile = delTender.property.unitPriceFile;
  339. let feeRateFile = delTender.property.feeFile;
  340. let usedUFTenders = await Projects.find(
  341. { userID: userId, $or: [{ deleteInfo: null }, { 'deleteInfo.deleted': false }], 'property.unitPriceFile.id': unitPriceFile.id });
  342. if (usedUFTenders.length === 1) {
  343. await UnitPriceFiles.update({ id: unitPriceFile.id }, { $set: { deleteInfo: deleteInfo } });
  344. }
  345. let usedFRTenders = await Projects.find(
  346. { userID: userId, $or: [{ deleteInfo: null }, { 'deleteInfo.deleted': false }], 'property.feeFile.id': feeRateFile.id });
  347. if (usedFRTenders.length === 1) {
  348. await FeeRateFiles.update({ ID: feeRateFile.id }, { $set: { deleteInfo: deleteInfo } });
  349. }
  350. await Projects.update({ userID: userId, ID: data.updateData.ID }, data.updateData, updateAll);
  351. }
  352. } else if (data.updateData.projType === projectType.folder) {//true
  353. await Projects.remove({ userID: userId, ID: data.updateData.ID }, updateAll);
  354. } else throw '未知文件类型,删除失败!';
  355. }
  356. else {
  357. hasError = true;
  358. callback(1, '提交数据错误.', null);
  359. }
  360. }
  361. }
  362. };
  363. ProjectsDAO.prototype.udpateUserFiles = async function (userId, datas, callback) {
  364. let updateType = {update: 'update', delete: 'delete'};
  365. let deleteInfo = Object.create(null);
  366. deleteInfo.deleted = true;
  367. deleteInfo.deleteBy = userId;
  368. deleteInfo.deleteDateTime = new Date();
  369. try {
  370. for (let i = 0, len = datas.length; i < len; i++) {
  371. let data = datas[i];
  372. if (data.updateType === updateType.update && data.fileType === fileType.unitPriceFile) {
  373. await UnitPriceFiles.update({user_id: userId, id: parseInt(data.updateData.id)}, data.updateData);
  374. await Projects.update({
  375. userID: userId,
  376. 'property.unitPriceFile.id': data.updateData.id
  377. }, {$set: {'property.unitPriceFile.name': data.updateData.name}}, {multi: true});
  378. }
  379. else if (data.updateType === updateType.update && data.fileType === fileType.feeRateFile) {
  380. await FeeRateFiles.update({ID: data.updateData.ID}, data.updateData);
  381. await Projects.update({
  382. userID: userId,
  383. 'property.feeFile.id': data.updateData.ID
  384. }, {$set: {'property.feeFile.name': data.updateData.name}}, {multi: true});
  385. }
  386. else if (data.updateType === updateType.delete && data.fileType === fileType.unitPriceFile) {
  387. data.updateData.deleteInfo = deleteInfo;
  388. await UnitPriceFiles.update({user_id: userId, id: parseInt(data.updateData.id)}, data.updateData);
  389. }
  390. else if (data.updateType === updateType.delete && data.fileType === fileType.feeRateFile) {
  391. data.updateData.deleteInfo = deleteInfo;
  392. await FeeRateFiles.update({ID: data.updateData.ID}, data.updateData);
  393. }
  394. else throw '未知文件类型,删除失败'
  395. }
  396. callback(false, '删除成功', null);
  397. }
  398. catch (error) {
  399. callback(true, '删除失败', null);
  400. }
  401. };
  402. ProjectsDAO.prototype.copyUserProjects = function (userId, compilationId, datas, callback) {
  403. let data, project, updateLength = 0, hasError = false, deleteInfo = null, tempType = 1, i;
  404. let updateAll = function (err) {
  405. if (!err) {
  406. updateLength += 1;
  407. if (updateLength === datas.length) {
  408. callback(0, '', datas);
  409. }
  410. } else {
  411. hasError = true;
  412. callback(1, '提交数据出错.', null);
  413. }
  414. };
  415. if (datas) {
  416. for (i = 0; i < datas.length && !hasError; i++) {
  417. data = datas[i];
  418. if (data.updateType === 'update') {
  419. Projects.update({userID: userId, ID: data.updateData.ID}, data.updateData, updateAll)
  420. } else if (data.updateType === 'copy') {
  421. console.log(userId);
  422. data.updateData['userID'] = userId;
  423. data.updateData['compilation'] = compilationId;
  424. data.updateData['createDateTime'] = new Date();
  425. data.updateData['fileVer'] = index.getVersion();
  426. let newProject = new Projects(data.updateData);
  427. newProject['srcProjectId'] = data.srcProjectId;
  428. newProject.save(function (err, result) {
  429. if (!err && result._doc.projType === 'Tender') {
  430. copyProjController.copyProjectData(newProject.srcProjectId, result._doc.ID, updateAll);
  431. } else {
  432. updateAll(err);
  433. }
  434. });
  435. } else {
  436. hasError = true;
  437. callback(1, '提交数据错误', null);
  438. }
  439. }
  440. }
  441. };
  442. ProjectsDAO.prototype.rename = async function (userId, compilationId, data, callback) {
  443. try {
  444. if (data.id === undefined || data.id === '') {
  445. throw '数据错误!';
  446. }
  447. if (data.newName === undefined || data.newName === '') {
  448. throw '请填写名称!';
  449. }
  450. data.newName = data.newName.trim();
  451. //重名前端控制
  452. /* // 查找同级是否存在同名数据
  453. let exist = await this.isExist(userId, compilationId, data.newName, data.parentID);
  454. if (exist) {
  455. throw '同级目录已存在相同名称数据';
  456. }*/
  457. Projects.update({userID: userId, ID: data.id}, {name: data.newName}, function (err) {
  458. if (err) {
  459. throw '项目不存在';
  460. }
  461. });
  462. } catch (error) {
  463. callback(1, error, null);
  464. return;
  465. }
  466. callback(0, '');
  467. };
  468. ProjectsDAO.prototype.beforeOpenProject = function (userId, projectId, updateData, callback) {
  469. updateData['recentDateTime'] = new Date();
  470. Projects.update({userID: userId, ID: projectId}, updateData, function (err) {
  471. if (err) {
  472. callback(1, '项目不存在.');
  473. } else {
  474. callback(0, '');
  475. }
  476. });
  477. };
  478. ProjectsDAO.prototype.getNewProjectID = function (count, callback) {
  479. counter.counterDAO.getIDAfterCount(counter.moduleName.project, count, function (err, result) {
  480. console.log(result);
  481. let highID = result.sequence_value;
  482. if (!err) {
  483. callback(0, '', {lowID: highID - count + 1, highID: highID});
  484. } else {
  485. callback(1, '获取主键失败', null);
  486. }
  487. });
  488. };
  489. ProjectsDAO.prototype.getProject = function (key, callback) {
  490. if (callback) {
  491. Projects.findOne({'_id': key}, function (err, result) {
  492. if (err) {
  493. callback(1, '查找标段失败');
  494. } else {
  495. callback(0, result);
  496. }
  497. });
  498. } else {
  499. return Projects.findOne({$or: [{deleteInfo: null}, {'deleteInfo.deleted': false}], 'ID': key}).exec();
  500. }
  501. };
  502. ProjectsDAO.prototype.getProjectsByIds = async function (userId, compilationId, ids) {
  503. return await Projects.find({userID: userId, compilation: compilationId, ID: {$in: ids}}, '-_id -property');
  504. };
  505. ProjectsDAO.prototype.getGCFiles = async function (fileType, userID) {
  506. let rst;
  507. if (fileType === 'UnitPriceFile') {
  508. let unitPriceFileModel = new UnitPriceFileModel();
  509. rst = await unitPriceFileModel.getGCUnitPriceFiles(userID);
  510. }
  511. else if (fileType === 'FeeRateFile') {
  512. rst = await feeRateFacade.getGCFeeRateFiles(userID);
  513. }
  514. else {
  515. let isExist = false;
  516. for (let type in projectType) {
  517. if (projectType[type] === fileType) {
  518. isExist = true;
  519. break;
  520. }
  521. }
  522. if (!isExist) throw '不存在此项目类型!';
  523. rst = await Projects.find(
  524. {userID: userID, projType: fileType, 'deleteInfo.deleted': true, '$or': [{'deleteInfo.completeDeleted': false}, {'deleteInfo.completeDeleted': null}]});
  525. }
  526. return rst;
  527. };
  528. ProjectsDAO.prototype.getFirstNodeID = async function (userID, compilationId, pid) {
  529. let nodes = await Projects.find({userID: userID, compilation: compilationId, ParentID: pid, deleteInfo: null});
  530. if (nodes.length === 0) {
  531. return -1;
  532. }
  533. else {
  534. let prefix = 'ID_';
  535. let chain = Object.create(null);
  536. for (let i = 0, len = nodes.length; i < len; i++) {
  537. let nodeDoc = nodes[i]._doc;
  538. let node = Object.create(null);
  539. node.ID = nodeDoc.ID;
  540. node.NextSiblingID = nodeDoc.NextSiblingID;
  541. chain[prefix + node.ID] = node;
  542. }
  543. for (let i = 0, len = nodes.length; i < len; i++) {
  544. let nodeDoc = nodes[i]._doc;
  545. let next = nodeDoc.NextSiblingID > 0 ? chain[prefix + nodeDoc.NextSiblingID] : null;
  546. chain[prefix + nodeDoc.ID].next = next;
  547. if (next) {
  548. next.pre = chain[prefix + nodeDoc.ID]
  549. }
  550. }
  551. for (let node in chain) {
  552. let pre = chain[node].pre || null;
  553. if (!pre) {
  554. return chain[node].ID;
  555. }
  556. }
  557. }
  558. };
  559. ProjectsDAO.prototype.recGC = async function (userID, compilationId, datas, callback) {
  560. let functions = [];
  561. let updateDatas = [];
  562. for (let i = 0, len = datas.length; i < len; i++) {
  563. if (datas[i].findData.ParentID !== undefined && datas[i].findData.NextSiblingID === -1 && !datas[i].findData.deleteInfo) {//维护项目管理树
  564. let findNode = await Projects.find(datas[i].findData);
  565. if (findNode.length > 0) {
  566. datas[i].findData = Object.create(null);
  567. datas[i].findData.ID = findNode[0].ID;
  568. updateDatas.push(datas[i]);
  569. }
  570. } else {
  571. if (datas[i].updateType === projectType.project && datas[i].updateData.NextSiblingID === undefined) {//则为待查询NextSiblingID,前端无法查询
  572. let projData = await Projects.find({userID: userID, ID: datas[i].findData.ID});//建设项目原本可能属于某文件夹、文件夹的存在需要判断
  573. let projPid = projData[0].ParentID;
  574. if (projPid !== -1) {
  575. let projFolder = await Projects.find({userID: userID, ID: projPid});
  576. if (projFolder.length === 0) {//文件夹已不存在
  577. projPid = -1;
  578. datas[i].updateData.ParentID = -1;
  579. }
  580. }
  581. let firstNodeID = await this.getFirstNodeID(userID, compilationId, projPid);
  582. datas[i].updateData.NextSiblingID = firstNodeID;
  583. }
  584. updateDatas.push(datas[i])
  585. }
  586. }
  587. for (let i = 0, len = updateDatas.length; i < len; i++) {
  588. functions.push((function (data) {
  589. return function (cb) {
  590. if (data.updateType === fileType.unitPriceFile) {
  591. UnitPriceFiles.update({id: parseInt(data.findData.id)}, data.updateData, function (err) {
  592. if (err) cb(err);
  593. else {
  594. Projects.update({
  595. userID: userID,
  596. 'property.unitPriceFile.id': data.findData.id
  597. }, {$set: {'property.unitPriceFile.name': data.updateData.name}}, function (err) {
  598. if (err) cb(err);
  599. else cb(false);
  600. });
  601. }
  602. })
  603. } else if (data.updateType === fileType.feeRateFile) {
  604. FeeRateFiles.update(data.findData, data.updateData, function (err) {
  605. if (err) cb(err);
  606. else {
  607. Projects.update({
  608. userID: userID,
  609. 'property.feeFile.id': data.findData.ID
  610. }, {$set: {'property.feeFile.name': data.updateData.name}}, function (err) {
  611. if (err) cb(err);
  612. else cb(false);
  613. });
  614. }
  615. });
  616. } else {
  617. if (data) {
  618. Projects.update(data.findData, data.updateData, function (err) {
  619. if (err) cb(err);
  620. else cb(false);
  621. });
  622. }
  623. }
  624. }
  625. })(updateDatas[i]));
  626. }
  627. async_c.parallel(functions, function (err, results) {
  628. if (err) callback(err, 'fail', null);
  629. else callback(0, 'success', null);
  630. });
  631. };
  632. /**
  633. * 整理工程专业对应标准库数据
  634. *
  635. * @param {Object} data
  636. * @return {Boolean}
  637. */
  638. ProjectsDAO.prototype.isExist = async function (userId, compilationId, name, parentID) {
  639. parentID = parseInt(parentID);
  640. if (name === '' || isNaN(parentID)) {
  641. return true;
  642. }
  643. let condition = {
  644. userID: userId,
  645. compilation: compilationId,
  646. ParentID: parentID,
  647. name: name,
  648. "$or": [{deleteInfo: null}, {"deleteInfo.deleted": false}]
  649. };
  650. let count = await Projects.count(condition);
  651. return count > 0;
  652. };
  653. /**
  654. * 获取对应建设项目下所有的单位工程id
  655. *
  656. * @param {Number} projectId
  657. * @return {Promise}
  658. */
  659. ProjectsDAO.prototype.getTenderByProjectId = async function (projectId) {
  660. let result = [];
  661. // 首先获取对应的单位工程id
  662. let engineeringData = await Projects.find({ParentID: projectId});
  663. if (engineeringData.length <= 0) {
  664. return result;
  665. }
  666. let engineeringIdList = [];
  667. for (let tmp of engineeringData) {
  668. engineeringIdList.push(tmp.ID);
  669. }
  670. // 查找对应的单位工程id
  671. let tenderData = await Projects.find({ParentID: {$in: engineeringIdList},deleteInfo: null});
  672. if (tenderData.length <= 0) {
  673. return result;
  674. }
  675. for (let tmp of tenderData) {
  676. result.push(tmp.ID);
  677. }
  678. return result;
  679. };
  680. /**
  681. * 根据单价文件id获取对应的标段数据
  682. *
  683. * @param {Number} unitPriceFileId
  684. * @return {Promise}
  685. */
  686. ProjectsDAO.prototype.getTenderByUnitPriceFileId = async function (unitPriceFileId) {
  687. let result = [];
  688. unitPriceFileId = parseInt(unitPriceFileId);
  689. if (isNaN(unitPriceFileId) && unitPriceFileId <= 0) {
  690. return result;
  691. }
  692. //let condition = {projType: 'Tender', "property.unitPriceFile.id": unitPriceFileId};
  693. let condition = {"property.unitPriceFile.id": unitPriceFileId,deleteInfo:null};
  694. result = await Projects.find(condition,['ID','name','property']);
  695. return result;
  696. };
  697. /**
  698. * 根据项目id获取项目property信息
  699. *
  700. * @param {Number} projectId
  701. * @return {Promise}
  702. */
  703. ProjectsDAO.prototype.getProjectProperty = async function (projectId) {
  704. let result = null;
  705. let projectData = await Projects.findOne({ID: projectId},['property']);
  706. if (projectData === null) {
  707. return result;
  708. }
  709. return projectData.property;
  710. };
  711. /**
  712. * 获取当前用户的建设项目数据
  713. *
  714. * @paraconsolem {Number} userId
  715. * @return {Promise}
  716. */
  717. ProjectsDAO.prototype.getUserProjectData = async function (userId,compilation) {
  718. let projectList = await Projects.find({
  719. '$or': [
  720. {'userID': userId, 'compilation': compilation, 'deleteInfo': null, projType: 'Project'},
  721. {'userID': userId, 'compilation': compilation,'deleteInfo.deleted': {'$in': [null, false]}, projType: 'Project'}
  722. ]
  723. }, {_id: 0, name: 1, ID: 1, NextSiblingID: 1, ParentID: 1});
  724. return projectList;
  725. };
  726. /**
  727. * 更改项目属性中的单价文件
  728. *
  729. * @param {Number} projectId
  730. * @param {Object} changeInfo
  731. * @return {Promise}
  732. */
  733. ProjectsDAO.prototype.changeUnitPriceFileInfo = async function (projectId, changeInfo) {
  734. projectId = parseInt(projectId);
  735. if (isNaN(projectId) || projectId <= 0) {
  736. return false;
  737. }
  738. let result = await Projects.update({ID: projectId}, {"property.unitPriceFile": changeInfo});
  739. return result.ok === 1;
  740. };
  741. /**
  742. * 更新项目属性
  743. *
  744. * @param {Number} projectId - 项目id
  745. * @param {Object} propertyData - 项目属性数据
  746. * @return {Promise}
  747. */
  748. ProjectsDAO.prototype.updateProjectProperty = async function(projectId, propertyData) {
  749. projectId = parseInt(projectId);
  750. if (isNaN(projectId) || projectId <= 0 || propertyData.property === undefined || propertyData.data === undefined) {
  751. return false;
  752. }
  753. const updateData = {};
  754. updateData["property." + propertyData.property] = propertyData.data;
  755. let result = await Projects.update({ID: projectId}, updateData);
  756. return result.ok === 1;
  757. };
  758. // CSL, 2018-01-11 获取指定ID节点(如单项工程、建设项目)下所有单位工程的各项汇总金额,用于报表计算汇总。
  759. ProjectsDAO.prototype.getSummaryFees = async function (ID) {
  760. async function getProject(ID){
  761. return await Projects.findOne({'ID': ID, deleteInfo: null}, need);
  762. };
  763. async function getChildrenDocs(IDs){
  764. return await Projects.find({'ParentID': {"$in":IDs}, deleteInfo: null}, need);
  765. };
  766. async function getEgrIDs(ID){
  767. let _docs = await Projects.find({'ParentID': ID, deleteInfo: null}, ['ID', '-_id']);
  768. let arr = [];
  769. for (let doc of _docs){
  770. arr.push(doc.ID);
  771. };
  772. return arr;
  773. };
  774. let need = ['ID', 'ParentID', 'NextSiblingID', 'name', 'projType',
  775. 'fullFolder', 'summaryFees', '-_id'];
  776. let _doc = await getProject(ID);
  777. if (!_doc) return _doc;
  778. if (_doc.projType.sameText('Engineering')){
  779. return await getChildrenDocs([ID]);
  780. }
  781. else if (_doc.projType.sameText('Project')){
  782. let eIDs = await getEgrIDs(ID);
  783. return await getChildrenDocs(eIDs);
  784. }
  785. else{
  786. return _doc;
  787. };
  788. };
  789. ProjectsDAO.prototype.updateUnitFileToProject=async function(projectID,unitFile){
  790. return await Projects.findOneAndUpdate({'ID':projectID},{'property.unitPriceFile':unitFile});
  791. }
  792. ProjectsDAO.prototype.getBasicInfo = async function (projectID) {
  793. //获取建设项目
  794. let constructionProject = await pmFacade.getConstructionProject(projectID);
  795. if(!constructionProject || !constructionProject.property || !constructionProject.property.basicInformation){
  796. return null;
  797. }
  798. return constructionProject.property.basicInformation;
  799. };
  800. //恢复默认系统设置
  801. ProjectsDAO.prototype.defaultSettings = async function (userID, compilation, projectID) {
  802. const compilationId = compilation._id;
  803. let project = await Projects.findOne({ID: projectID});
  804. if(!project){
  805. return false;
  806. }
  807. let cloneProperty = _.cloneDeep(project.property);
  808. let overWrite;
  809. if(compilation.overWriteUrl && compilation.overWriteUrl!=""){
  810. overWrite = require("../../.."+compilation.overWriteUrl);
  811. }
  812. //关于计算
  813. let defaultCalcMode = overWrite && overWrite.defaultCalcMode || ((project.property.valuationType !== ValuationType.BOQ) ? 2 : 1);
  814. cloneProperty.billsCalcMode = defaultCalcMode;
  815. cloneProperty.zanguCalcMode = 0;
  816. cloneProperty.calcOptions = calcOptions;
  817. //清单工程量精度
  818. cloneProperty.billsQuantityDecimal = billsQuantityDecimal;
  819. //小数位数
  820. cloneProperty.decimal = overWrite && overWrite.defaultDecimal || defaultDecimal;
  821. //呈现选项
  822. cloneProperty.displaySetting = displaySetting;
  823. //列设置
  824. let stdColLib = await mainColLibModel.findOne({ID: project.property.colLibID});
  825. if(stdColLib){
  826. await projSettingModel.update({projectID: projectID}, {$set: {main_tree_col: stdColLib.main_tree_col}});
  827. }
  828. //系统选项
  829. await optionModel.update({user_id: userID, compilation_id: compilationId}, {$set: {options: optionSetting}});
  830. await Projects.update({ID: projectID}, {$set: {property: cloneProperty}});
  831. return true;
  832. };