project_model.js 29 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724
  1. /**
  2. * Created by Mai on 2017/1/18.
  3. */
  4. import mongoose from 'mongoose';
  5. import async_c from 'async';
  6. import UnitPriceFileModel from "../../glj/models/unit_price_file_model";
  7. let UnitPriceFiles = mongoose.model('unit_price_file');
  8. import {
  9. defaultDecimal,
  10. billsQuantityDecimal,
  11. basicInformation,
  12. projectFeature,
  13. displaySetting,
  14. calcOptions
  15. } from './project_property_template';
  16. import fixedFlag from '../../common/const/bills_fixed';
  17. let FeeRateFiles = mongoose.model('fee_rate_file');
  18. let counter = require("../../../public/counter/counter.js");
  19. let newProjController = require('../controllers/new_proj_controller');
  20. let copyProjController = require('../controllers/copy_proj_controller');
  21. let feeRateFacade = require('../../fee_rates/facade/fee_rates_facade');
  22. let labourCoeFacade = require('../../main/facade/labour_coe_facade');
  23. let calcProgramFacade = require('../../main/facade/calc_program_facade');
  24. let installationFacade = require('../../main/facade/installation_facade');
  25. let logger = require("../../../logs/log_helper").logger;
  26. let BillsModel = require("../../main/models/bills").model;
  27. let Projects = mongoose.model('projects');
  28. let projectType = {
  29. folder: 'Folder',
  30. tender: 'Tender',
  31. project: 'Project',
  32. engineering: 'Engineering',
  33. };
  34. let fileType = {
  35. unitPriceFile: 'UnitPriceFile',
  36. feeRateFile: 'FeeRateFile'
  37. };
  38. let ProjectsDAO = function () {
  39. };
  40. ProjectsDAO.prototype.getUserProjects = async function (userId, compilation, callback) {
  41. try {
  42. let projects = await Projects.find({
  43. '$or': [{
  44. 'userID': userId,
  45. 'compilation': compilation,
  46. 'deleteInfo': null
  47. }, {'userID': userId, 'compilation': compilation, 'deleteInfo.deleted': {'$in': [null, false]}}]
  48. }, '-_id');
  49. for (let i = 0, len = projects.length; i < len; i++) {
  50. let proj = projects[i];
  51. let engineeringCost = await BillsModel.find({
  52. projectID: proj.ID,
  53. 'flags.flag': fixedFlag.ENGINEERINGCOST,
  54. 'fees.totalFee': {$exists: true}
  55. });
  56. proj._doc.engineeringCost = engineeringCost.length > 0 ? engineeringCost[0].fees[0].totalFee : 0;
  57. }
  58. callback(0, '', projects);
  59. }
  60. catch (err) {
  61. callback(1, 'Error', null);
  62. }
  63. };
  64. ProjectsDAO.prototype.getUserProject = function (userId, ProjId, callback) {
  65. Projects.findOne({userID: userId, ID: ProjId}, '-_id', function (err, template) {
  66. if (err) {
  67. callback(1, '找不到标段数据', null);
  68. } else {
  69. callback(0, '', template);
  70. }
  71. });
  72. }
  73. ProjectsDAO.prototype.updateUserProjects = async function (userId, compilationId, datas, callback) {
  74. let data, project, updateLength = 0, hasError = false, deleteInfo = null, i, newProject;
  75. let updateAll = function (err) {
  76. if (!err) {
  77. updateLength += 1;
  78. if (updateLength === datas.length) {
  79. callback(0, '', datas);
  80. }
  81. } else {
  82. hasError = true;
  83. console.log(err);
  84. callback(1, '提交数据出错.', null);
  85. }
  86. };
  87. console.log(datas);
  88. if (datas) {
  89. for (i = 0; i < datas.length && !hasError; i++) {
  90. data = datas[i];
  91. if (data.updateData.name !== undefined) {
  92. data.updateData.name = data.updateData.name.trim();
  93. }
  94. if (data.updateType === 'update') {
  95. Projects.update({userID: userId, ID: data.updateData.ID}, data.updateData, updateAll);
  96. }
  97. else if (data.updateType === 'new') {
  98. data.updateData['userID'] = userId;
  99. data.updateData['compilation'] = compilationId;
  100. data.updateData['createDateTime'] = new Date();
  101. // 如果没有选中单价文件则新增单价文件
  102. if (data.updateData.projType === projectType.tender && data.updateData.property !== null &&
  103. Object.keys(data.updateData.property.unitPriceFile).length > 0 &&
  104. data.updateData.property.unitPriceFile.id === '') {
  105. let unitPriceFileModel = new UnitPriceFileModel();
  106. let insertData = {
  107. name: data.updateData.name,
  108. project_id: data.updateData.ID,
  109. user_id: userId,
  110. root_project_id: data.updateData.property.rootProjectID
  111. };
  112. let addResult = await unitPriceFileModel.add(insertData);
  113. if (!addResult) {
  114. callback(1, '新增单价文件失败.', null);
  115. return;
  116. }
  117. data.updateData.property.unitPriceFile.id = addResult.id;
  118. }
  119. if (data.updateData.projType === projectType.tender) {
  120. //单价文件
  121. data.updateData.property.unitPriceFile.id=parseInt(data.updateData.property.unitPriceFile.id);
  122. //小数位数
  123. data.updateData.property.decimal = defaultDecimal;
  124. //清单工程量精度
  125. data.updateData.property.billsQuantityDecimal = billsQuantityDecimal;
  126. //基本信息
  127. basicInformation[0]['items'][1]['value'] = data.updateData.property.engineeringName || '';
  128. data.updateData.property.basicInformation = basicInformation;
  129. //工程特征
  130. data.updateData.property.projectFeature = projectFeature;
  131. //呈现选项
  132. data.updateData.property.displaySetting = displaySetting;
  133. data.updateData.property.billsCalcMode = 0;
  134. data.updateData.property.zanguCalcMode = 0;
  135. //计算选项
  136. data.updateData.property.calcOptions = calcOptions
  137. //安装增加费
  138. if(parseInt(data.updateData.property.engineering)==4){
  139. await installationFacade.copyInstallationFeeFromLib(data.updateData.ID,data.updateData.property.engineering_id);
  140. }
  141. //锁定清单
  142. data.updateData.property.lockBills = false;
  143. }
  144. newProject = new Projects(data.updateData);
  145. // 查找同级是否存在同名数据
  146. let exist = await this.isExist(userId, compilationId, data.updateData.name, data.updateData.ParentID);
  147. if (exist) {
  148. callback(1, '同级目录已存在相同名称数据.', null);
  149. return;
  150. }
  151. if (data.updateData.projType === 'Tender') {
  152. let feeRateFileID = await feeRateFacade.newFeeRateFile(userId, data.updateData);
  153. newProject.property.feeFile = feeRateFileID ? feeRateFileID : -1;
  154. // 新建人工系数文件 CSL, 2017.10.13
  155. let lcFile = await labourCoeFacade.newProjectLabourCoe(data.updateData);
  156. newProject.property.labourCoeFile = lcFile ? lcFile : null;
  157. // 新建计算程序文件 CSL, 2017.10.23
  158. let cpFile = await calcProgramFacade.newProjectCalcProgramFile(data.updateData);
  159. newProject.property.calcProgramFile = cpFile ? cpFile : null;
  160. }
  161. newProject.save(async function (err, result) {
  162. if (!err && result._doc.projType === projectType.tender) {
  163. newProjController.copyTemplateData(result._doc.property, newProject.ID, updateAll);
  164. } else {
  165. updateAll(err);
  166. }
  167. });
  168. }
  169. else if (data.updateType === 'delete') {
  170. deleteInfo = {};
  171. deleteInfo['deleted'] = true;
  172. deleteInfo['deleteDateTime'] = new Date();
  173. deleteInfo['deleteBy'] = userId;
  174. data.updateData['deleteInfo'] = deleteInfo;
  175. //Projects.update({userID: userId, ID: data.updateData.ID}, data.updateData, updateAll);
  176. //update
  177. try {
  178. if (data.updateData.projType === projectType.project) {
  179. let engineerings = await Projects.find({userID: userId, ParentID: data.updateData.ID});
  180. let isExist = false;
  181. if (engineerings.length > 0) {
  182. for (let j = 0, jLen = engineerings.length; j < jLen; j++) {
  183. let e_tenders = await Projects.find({userID: userId, ParentID: engineerings[j].ID});
  184. if (e_tenders.length > 0) {
  185. isExist = true;
  186. break;
  187. }
  188. }
  189. }
  190. if (isExist) {//fake
  191. await UnitPriceFiles.update({
  192. user_id: userId,
  193. root_project_id: data.updateData.ID
  194. }, {$set: {deleteInfo: deleteInfo}}, {multi: true});
  195. await FeeRateFiles.update({
  196. userID: userId,
  197. rootProjectID: data.updateData.ID
  198. }, {$set: {deleteInfo: deleteInfo}}, {multi: true});
  199. await Projects.update({userID: userId, ID: data.updateData.ID}, data.updateData, updateAll);
  200. }
  201. else {//true
  202. await UnitPriceFiles.remove({user_id: userId, root_project_id: data.updateData.ID});
  203. await FeeRateFiles.remove({userID: userId, rootProjectID: data.updateData.ID});
  204. //await Projects.update({userID: userId, NextSiblingID: data.updateData.ID, deleteInfo: null}, {$set: {NextSiblingID: data.NextSiblingID}});
  205. await Projects.remove({userID: userId, ID: data.updateData.ID}, updateAll);
  206. }
  207. }
  208. else if (data.updateData.projType === projectType.engineering) {
  209. let tenders = await Projects.find({userID: userId, ParentID: data.updateData.ID});
  210. if (tenders.length > 0) {//fake
  211. await Projects.update({userID: userId, ID: data.updateData.ID}, data.updateData, updateAll);
  212. }
  213. else {//true
  214. //await Projects.update({userID: userId, NextSiblingID: data.updateData.ID, deleteInfo: null}, {$set: {NextSiblingID: data.NextSiblingID}});
  215. await Projects.remove({userID: userId, ID: data.updateData.ID}, updateAll);
  216. }
  217. }
  218. else if (data.updateData.projType === projectType.tender) {//fake
  219. await Projects.update({userID: userId, ID: data.updateData.ID}, data.updateData, updateAll);
  220. }
  221. else if (data.updateData.projType === projectType.folder) {//true
  222. await Projects.remove({userID: userId, ID: data.updateData.ID}, updateAll);
  223. }
  224. else throw '未知文件类型,删除失败!';
  225. }
  226. catch (error) {
  227. callback(1, error, null);
  228. }
  229. }
  230. else {
  231. hasError = true;
  232. callback(1, '提交数据错误.', null);
  233. }
  234. }
  235. }
  236. };
  237. ProjectsDAO.prototype.udpateUserFiles = async function (userId, datas, callback) {
  238. let updateType = {update: 'update', delete: 'delete'};
  239. let deleteInfo = Object.create(null);
  240. deleteInfo.deleted = true;
  241. deleteInfo.deleteBy = userId;
  242. deleteInfo.deleteDateTime = new Date();
  243. try {
  244. for (let i = 0, len = datas.length; i < len; i++) {
  245. let data = datas[i];
  246. if (data.updateType === updateType.update && data.fileType === fileType.unitPriceFile) {
  247. await UnitPriceFiles.update({user_id: userId, id: parseInt(data.updateData.id)}, data.updateData);
  248. await Projects.update({
  249. userID: userId,
  250. 'property.unitPriceFile.id': data.updateData.id
  251. }, {$set: {'property.unitPriceFile.name': data.updateData.name}});
  252. }
  253. else if (data.updateType === updateType.update && data.fileType === fileType.feeRateFile) {
  254. await FeeRateFiles.update({userID: userId, ID: data.updateData.ID}, data.updateData);
  255. await Projects.update({
  256. userID: userId,
  257. 'property.feeFile.id': data.updateData.ID
  258. }, {$set: {'property.feeFile.name': data.updateData.name}});
  259. }
  260. else if (data.updateType === updateType.delete && data.fileType === fileType.unitPriceFile) {
  261. data.updateData.deleteInfo = deleteInfo;
  262. await UnitPriceFiles.update({user_id: userId, id: parseInt(data.updateData.id)}, data.updateData);
  263. await Projects.update({
  264. userID: userId,
  265. 'property.feeFile.id': data.updateData.id
  266. }, {$set: {'property.feeFile.name': data.updateData.name}});
  267. }
  268. else if (data.updateType === updateType.delete && data.fileType === fileType.feeRateFile) {
  269. data.updateData.deleteInfo = deleteInfo;
  270. await FeeRateFiles.update({userID: userId, ID: data.updateData.ID}, data.updateData);
  271. }
  272. else throw '未知文件类型,删除失败'
  273. }
  274. callback(false, '删除成功', null);
  275. }
  276. catch (error) {
  277. callback(true, '删除失败', null);
  278. }
  279. };
  280. ProjectsDAO.prototype.copyUserProjects = function (userId, compilationId, datas, callback) {
  281. let data, project, updateLength = 0, hasError = false, deleteInfo = null, tempType = 1, i;
  282. let updateAll = function (err) {
  283. if (!err) {
  284. updateLength += 1;
  285. if (updateLength === datas.length) {
  286. callback(0, '', datas);
  287. }
  288. } else {
  289. hasError = true;
  290. callback(1, '提交数据出错.', null);
  291. }
  292. };
  293. if (datas) {
  294. for (i = 0; i < datas.length && !hasError; i++) {
  295. data = datas[i];
  296. if (data.updateType === 'update') {
  297. Projects.update({userID: userId, ID: data.updateData.ID}, data.updateData, updateAll)
  298. } else if (data.updateType === 'copy') {
  299. console.log(userId);
  300. data.updateData['userID'] = userId;
  301. data.updateData['compilation'] = compilationId;
  302. data.updateData['createDateTime'] = new Date();
  303. let newProject = new Projects(data.updateData);
  304. newProject['srcProjectId'] = data.srcProjectId;
  305. newProject.save(function (err, result) {
  306. if (!err && result._doc.projType === 'Tender') {
  307. copyProjController.copyProjectData(newProject.srcProjectId, result._doc.ID, updateAll);
  308. } else {
  309. updateAll(err);
  310. }
  311. });
  312. } else {
  313. hasError = true;
  314. callback(1, '提交数据错误', null);
  315. }
  316. }
  317. }
  318. };
  319. ProjectsDAO.prototype.rename = async function (userId, compilationId, data, callback) {
  320. try {
  321. if (data.id === undefined || data.id === '') {
  322. throw '数据错误!';
  323. }
  324. if (data.newName === undefined || data.newName === '') {
  325. throw '请填写名称!';
  326. }
  327. data.newName = data.newName.trim();
  328. // 查找同级是否存在同名数据
  329. let exist = await this.isExist(userId, compilationId, data.newName, data.parentID);
  330. if (exist) {
  331. throw '同级目录已存在相同名称数据';
  332. }
  333. Projects.update({userID: userId, ID: data.id}, {name: data.newName}, function (err) {
  334. if (err) {
  335. throw '项目不存在';
  336. }
  337. });
  338. } catch (error) {
  339. callback(1, error, null);
  340. return;
  341. }
  342. callback(0, '');
  343. };
  344. ProjectsDAO.prototype.beforeOpenProject = function (userId, projectId, updateData, callback) {
  345. updateData['recentDateTime'] = new Date();
  346. Projects.update({userID: userId, ID: projectId}, updateData, function (err) {
  347. if (err) {
  348. callback(1, '项目不存在.');
  349. } else {
  350. callback(0, '');
  351. }
  352. });
  353. };
  354. ProjectsDAO.prototype.getNewProjectID = function (count, callback) {
  355. counter.counterDAO.getIDAfterCount(counter.moduleName.project, count, function (err, result) {
  356. console.log(result);
  357. let highID = result.sequence_value;
  358. if (!err) {
  359. callback(0, '', {lowID: highID - count + 1, highID: highID});
  360. } else {
  361. callback(1, '获取主键失败', null);
  362. }
  363. });
  364. };
  365. ProjectsDAO.prototype.getProject = function (key, callback) {
  366. if (callback) {
  367. Projects.findOne({'_id': key}, function (err, result) {
  368. if (err) {
  369. callback(1, '查找标段失败');
  370. } else {
  371. callback(0, result);
  372. }
  373. });
  374. } else {
  375. return Projects.findOne({'ID': key}).exec();
  376. }
  377. };
  378. ProjectsDAO.prototype.getProjectsByIds = async function (userId, compilationId, ids) {
  379. return await Projects.find({userID: userId, compilation: compilationId, ID: {$in: ids}});
  380. };
  381. ProjectsDAO.prototype.getGCFiles = async function (fileType, userID) {
  382. let rst;
  383. if (fileType === 'UnitPriceFile') {
  384. let unitPriceFileModel = new UnitPriceFileModel();
  385. rst = await unitPriceFileModel.getGCUnitPriceFiles(userID);
  386. }
  387. else if (fileType === 'FeeRateFile') {
  388. rst = await feeRateFacade.getGCFeeRateFiles(userID);
  389. }
  390. else {
  391. let isExist = false;
  392. for (let type in projectType) {
  393. if (projectType[type] === fileType) {
  394. isExist = true;
  395. break;
  396. }
  397. }
  398. if (!isExist) throw '不存在此项目类型!';
  399. rst = await Projects.find({userID: userID, projType: fileType, 'deleteInfo.deleted': true});
  400. }
  401. return rst;
  402. };
  403. ProjectsDAO.prototype.getFirstNodeID = async function (userID, pid) {
  404. let nodes = await Projects.find({userID: userID, ParentID: pid, deleteInfo: null});
  405. if (nodes.length === 0) {
  406. return -1;
  407. }
  408. else {
  409. let prefix = 'ID_';
  410. let chain = Object.create(null);
  411. for (let i = 0, len = nodes.length; i < len; i++) {
  412. let nodeDoc = nodes[i]._doc;
  413. let node = Object.create(null);
  414. node.ID = nodeDoc.ID;
  415. node.NextSiblingID = nodeDoc.NextSiblingID;
  416. chain[prefix + node.ID] = node;
  417. }
  418. for (let i = 0, len = nodes.length; i < len; i++) {
  419. let nodeDoc = nodes[i]._doc;
  420. let next = nodeDoc.NextSiblingID > 0 ? chain[prefix + nodeDoc.NextSiblingID] : null;
  421. chain[prefix + nodeDoc.ID].next = next;
  422. if (next) {
  423. next.pre = chain[prefix + nodeDoc.ID]
  424. }
  425. }
  426. for (let node in chain) {
  427. let pre = chain[node].pre || null;
  428. if (!pre) {
  429. return chain[node].ID;
  430. }
  431. }
  432. }
  433. };
  434. ProjectsDAO.prototype.recGC = async function (userID, datas, callback) {
  435. let functions = [];
  436. let updateDatas = [];
  437. for (let i = 0, len = datas.length; i < len; i++) {
  438. if (datas[i].findData.ParentID !== undefined && datas[i].findData.NextSiblingID === -1 && !datas[i].findData.deleteInfo) {//维护项目管理树
  439. let findNode = await Projects.find(datas[i].findData);
  440. if (findNode.length > 0) {
  441. datas[i].findData = Object.create(null);
  442. datas[i].findData.ID = findNode[0].ID;
  443. updateDatas.push(datas[i]);
  444. }
  445. }
  446. else {
  447. if (datas[i].updateType === projectType.project && datas[i].updateData.NextSiblingID === undefined) {//则为待查询NextSiblingID,前端无法查询
  448. let projData = await Projects.find({userID: userID, ID: datas[i].findData.ID});//建设项目原本可能属于某文件夹、文件夹的存在需要判断
  449. let projPid = projData[0].ParentID;
  450. if (projPid !== -1) {
  451. let projFolder = await Projects.find({userID: userID, ID: projPid});
  452. if (projFolder.length === 0) {//文件夹已不存在
  453. projPid = -1;
  454. datas[i].updateData.ParentID = -1;
  455. }
  456. }
  457. let firstNodeID = await this.getFirstNodeID(userID, projPid);
  458. datas[i].updateData.NextSiblingID = firstNodeID;
  459. }
  460. updateDatas.push(datas[i])
  461. }
  462. }
  463. for (let i = 0, len = updateDatas.length; i < len; i++) {
  464. functions.push((function (data) {
  465. return function (cb) {
  466. if (data.updateType === fileType.unitPriceFile) {
  467. UnitPriceFiles.update({id: parseInt(data.findData.id)}, data.updateData, function (err) {
  468. if (err) cb(err);
  469. else {
  470. Projects.update({
  471. userID: userID,
  472. 'property.unitPriceFile.id': data.findData.id
  473. }, {$set: {'property.unitPriceFile.name': data.updateData.name}}, function (err) {
  474. if (err) cb(err);
  475. else cb(false);
  476. });
  477. }
  478. })
  479. }
  480. else if (data.updateType === fileType.feeRateFile) {
  481. FeeRateFiles.update(data.findData, data.updateData, function (err) {
  482. if (err) cb(err);
  483. else {
  484. Projects.update({
  485. userID: userID,
  486. 'property.feeFile.id': data.findData.ID
  487. }, {$set: {'property.feeFile.name': data.updateData.name}}, function (err) {
  488. if (err) cb(err);
  489. else cb(false);
  490. });
  491. }
  492. });
  493. }
  494. else {
  495. if (data) {
  496. Projects.update(data.findData, data.updateData, function (err) {
  497. if (err) cb(err);
  498. else cb(false);
  499. });
  500. }
  501. }
  502. }
  503. })(updateDatas[i]));
  504. }
  505. async_c.parallel(functions, function (err, results) {
  506. if (err) callback(err, 'fail', null);
  507. else callback(0, 'success', null);
  508. });
  509. };
  510. /**
  511. * 整理工程专业对应标准库数据
  512. *
  513. * @param {Object} data
  514. * @return {Boolean}
  515. */
  516. ProjectsDAO.prototype.isExist = async function (userId, compilationId, name, parentID) {
  517. parentID = parseInt(parentID);
  518. if (name === '' || isNaN(parentID)) {
  519. return true;
  520. }
  521. let condition = {
  522. userID: userId,
  523. compilation: compilationId,
  524. ParentID: parentID,
  525. name: name,
  526. "$or": [{deleteInfo: null}, {"deleteInfo.deleted": false}]
  527. };
  528. let count = await Projects.count(condition);
  529. return count > 0;
  530. };
  531. /**
  532. * 获取对应建设项目下所有的单位工程id
  533. *
  534. * @param {Number} projectId
  535. * @return {Promise}
  536. */
  537. ProjectsDAO.prototype.getTenderByProjectId = async function (projectId) {
  538. let result = [];
  539. // 首先获取对应的单位工程id
  540. let engineeringData = await Projects.find({ParentID: projectId});
  541. if (engineeringData.length <= 0) {
  542. return result;
  543. }
  544. let engineeringIdList = [];
  545. for (let tmp of engineeringData) {
  546. engineeringIdList.push(tmp.ID);
  547. }
  548. // 查找对应的单位工程id
  549. let tenderData = await Projects.find({ParentID: {$in: engineeringIdList},deleteInfo: null});
  550. if (tenderData.length <= 0) {
  551. return result;
  552. }
  553. for (let tmp of tenderData) {
  554. result.push(tmp.ID);
  555. }
  556. return result;
  557. };
  558. /**
  559. * 根据单价文件id获取对应的标段数据
  560. *
  561. * @param {Number} unitPriceFileId
  562. * @return {Promise}
  563. */
  564. ProjectsDAO.prototype.getTenderByUnitPriceFileId = async function (unitPriceFileId) {
  565. let result = [];
  566. unitPriceFileId = parseInt(unitPriceFileId);
  567. if (isNaN(unitPriceFileId) && unitPriceFileId <= 0) {
  568. return result;
  569. }
  570. //let condition = {projType: 'Tender', "property.unitPriceFile.id": unitPriceFileId};
  571. let condition = {"property.unitPriceFile.id": unitPriceFileId,deleteInfo:null};
  572. result = await Projects.find(condition,['name','property']);
  573. return result;
  574. };
  575. /**
  576. * 根据项目id获取单价文件列表id
  577. *
  578. * @param {Number} projectId
  579. * @return {Promise}
  580. */
  581. ProjectsDAO.prototype.getUnitPriceFileId = async function (projectId) {
  582. let result = 0;
  583. let startTime = +new Date();
  584. let projectData = await Projects.find({ID: projectId},['property.unitPriceFile']);
  585. if (projectData === null) {
  586. return result;
  587. }
  588. let endTime = +new Date();
  589. console.log("取单价文件列表id时间-----"+(endTime - startTime));
  590. projectData = projectData[0];
  591. result = projectData.property.unitPriceFile !== undefined ? projectData.property.unitPriceFile.id : 0;
  592. return result;
  593. };
  594. /**
  595. * 获取当前用户的建设项目数据
  596. *
  597. * @paraconsolem {Number} userId
  598. * @return {Promise}
  599. */
  600. ProjectsDAO.prototype.getUserProjectData = async function (userId) {
  601. let projectList = await Projects.find({
  602. '$or': [
  603. {'userID': userId, 'deleteInfo': null, projType: 'Project'},
  604. {'userID': userId, 'deleteInfo.deleted': {'$in': [null, false]}, projType: 'Project'}
  605. ]
  606. }, {_id: 0, name: 1, ID: 1});
  607. return projectList;
  608. };
  609. /**
  610. * 更改项目属性中的单价文件
  611. *
  612. * @param {Number} projectId
  613. * @param {Object} changeInfo
  614. * @return {Promise}
  615. */
  616. ProjectsDAO.prototype.changeUnitPriceFileInfo = async function (projectId, changeInfo) {
  617. projectId = parseInt(projectId);
  618. if (isNaN(projectId) || projectId <= 0) {
  619. return false;
  620. }
  621. let result = await Projects.update({ID: projectId}, {"property.unitPriceFile": changeInfo});
  622. return result.ok === 1;
  623. };
  624. /**
  625. * 更新项目属性
  626. *
  627. * @param {Number} projectId - 项目id
  628. * @param {Object} propertyData - 项目属性数据
  629. * @return {Promise}
  630. */
  631. ProjectsDAO.prototype.updateProjectProperty = async function(projectId, propertyData) {
  632. projectId = parseInt(projectId);
  633. if (isNaN(projectId) || projectId <= 0 || propertyData.property === undefined || propertyData.data === undefined) {
  634. return false;
  635. }
  636. const updateData = {};
  637. updateData["property." + propertyData.property] = propertyData.data;
  638. let result = await Projects.update({ID: projectId}, updateData);
  639. return result.ok === 1;
  640. };
  641. // CSL, 2018-01-11 获取指定ID节点(如单项工程、建设项目)下所有单位工程的各项汇总金额,用于报表计算汇总。
  642. ProjectsDAO.prototype.getSummaryFees = async function (ID) {
  643. async function getProject(ID){
  644. return await Projects.findOne({'ID': ID, deleteInfo: null}, need);
  645. };
  646. async function getChildrenDocs(IDs){
  647. return await Projects.find({'ParentID': {"$in":IDs}, deleteInfo: null}, need);
  648. };
  649. async function getEgrIDs(ID){
  650. let _docs = await Projects.find({'ParentID': ID, deleteInfo: null}, ['ID', '-_id']);
  651. let arr = [];
  652. for (let doc of _docs){
  653. arr.push(doc.ID);
  654. };
  655. return arr;
  656. };
  657. let need = ['ID', 'ParentID', 'NextSiblingID', 'name', 'projType',
  658. 'fullFolder', 'summaryFees', '-_id'];
  659. let _doc = await getProject(ID);
  660. if (!_doc) return _doc;
  661. if (_doc.projType.sameText('Engineering')){
  662. return await getChildrenDocs([ID]);
  663. }
  664. else if (_doc.projType.sameText('Project')){
  665. let eIDs = await getEgrIDs(ID);
  666. return await getChildrenDocs(eIDs);
  667. }
  668. else{
  669. return _doc;
  670. };
  671. };
  672. ProjectsDAO.prototype.updateUnitFileToProject=async function(projectID,unitFile){
  673. return await Projects.findOneAndUpdate({'ID':projectID},{'property.unitPriceFile':unitFile});
  674. }
  675. module.exports ={ project: new ProjectsDAO(),
  676. projType: projectType,
  677. fileType: fileType
  678. };