project_model.js 38 KB

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