project_model.js 39 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920
  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. displaySetting,
  27. calcOptions,
  28. tenderSetting
  29. } = require('./project_property_template');
  30. const optionSetting = require('../../options/models/optionTypes');
  31. let FeeRateFiles = mongoose.model('fee_rate_file');
  32. let counter = require("../../../public/counter/counter.js");
  33. let newProjController = require('../controllers/new_proj_controller');
  34. let copyProjController = require('../controllers/copy_proj_controller');
  35. let feeRateFacade = require('../../fee_rates/facade/fee_rates_facade');
  36. let labourCoeFacade = require('../../main/facade/labour_coe_facade');
  37. let calcProgramFacade = require('../../main/facade/calc_program_facade');
  38. let installationFacade = require('../../main/facade/installation_facade');
  39. let projectFacade = require('../../main/facade/project_facade');
  40. let pmFacade = require('../facade/pm_facade');
  41. let logger = require("../../../logs/log_helper").logger;
  42. let BillsModel = require("../../main/models/bills").model;
  43. let _ = require('lodash');
  44. let index = require("../../system_setting/model/index");
  45. let Projects = mongoose.model('projects');
  46. let mainColLibModel = mongoose.model('std_main_col_lib');
  47. let projSettingModel = mongoose.model('proj_setting');
  48. let optionModel = mongoose.model('options');
  49. const { buildingTemplate, railTemplate } = require('../../main/templates/constructionBillsTemplate');
  50. const { BudgetType } = require('../../../public/common_constants');
  51. let equipmentPurchaseModel = mongoose.model('equipment_purchase');
  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. let projIDs= [];
  107. const allIDs = [];
  108. for(let project of projects){
  109. allIDs.push(project.ID);
  110. if(project.projType === projectType.project){
  111. projIDs.push(project.ID);
  112. }
  113. }
  114. // 设置分享信息
  115. const shareMap = await pmFacade.getShareInfoMap(allIDs);
  116. projects.forEach(project => {
  117. project.shareInfo = shareMap[project.ID] || [];
  118. });
  119. // 当前费用定额未读的分享的条目数量
  120. // 设置汇总字段
  121. let summaryInfo = await pmFacade.getSummaryInfo(projIDs);
  122. pmFacade.setupSummaryFields(summaryInfo, projects);
  123. callback(0, '', projects);
  124. }
  125. catch (err) {
  126. console.log(err.stack);
  127. callback(1, 'Error', null);
  128. }
  129. };
  130. ProjectsDAO.prototype.getUserProjectAsync = async function (userId, ProjId) {
  131. return await Projects.findOne({userID: userId, ID: ProjId}, '-_id -property').lean();
  132. };
  133. ProjectsDAO.prototype.getUserProject = function (userId, ProjId, callback) {
  134. Projects.findOne({$or: [{deleteInfo: null}, {'deleteInfo.deleted': false}], ID: ProjId}, '-_id', function (err, template) {
  135. if (err) {
  136. callback(1, '找不到标段数据', null);
  137. } else {
  138. //打开分享的项目,只读
  139. if(template && userId !== template.userID){
  140. template._doc.readOnly = true;
  141. }
  142. callback(0, '', template);
  143. }
  144. });
  145. };
  146. ProjectsDAO.prototype.updateUserProjects = async function (userId, compilationId, compilationName,overWriteUrl, datas, callback) {
  147. let data, project, updateLength = 0, hasError = false, deleteInfo = null, i, newProject;
  148. let updateAll = function (err) {
  149. if (!err) {
  150. updateLength += 1;
  151. if (updateLength === datas.length) {
  152. callback(0, '', datas);
  153. }
  154. } else {
  155. hasError = true;
  156. console.log(err);
  157. callback(1, '提交数据出错.', null);
  158. }
  159. };
  160. console.log(datas);
  161. if (datas) {
  162. for (i = 0; i < datas.length && !hasError; i++) {
  163. data = datas[i];
  164. if (data.updateData.name !== undefined) {
  165. data.updateData.name = data.updateData.name.trim();
  166. }
  167. if (data.updateType === 'update') {
  168. Projects.update({userID: userId, ID: data.updateData.ID}, data.updateData, updateAll);
  169. }
  170. else if (data.updateType === 'new') {
  171. data.updateData['userID'] = userId;
  172. data.updateData['compilation'] = compilationId;
  173. data.updateData['createDateTime'] = new Date();
  174. data.updateData['fileVer'] = await index.getVersion();
  175. data.updateData['lastFileVer'] = data.updateData['fileVer'];
  176. /*if(data.updateData.projType === projectType.project){
  177. //设置建设项目基本信息,多个单位工程共用
  178. data.updateData.property = {basicInformation: basicInformation};
  179. }*/
  180. // 如果没有选中单价文件则新增单价文件
  181. if (data.updateData.projType === projectType.tender && data.updateData.property !== null &&
  182. Object.keys(data.updateData.property.unitPriceFile).length > 0 &&
  183. data.updateData.property.unitPriceFile.id === '') {
  184. let unitPriceFileModel = new UnitPriceFileModel();
  185. let insertData = {
  186. name: data.updateData.name,
  187. project_id: data.updateData.ID,
  188. user_id: userId,
  189. root_project_id: data.updateData.property.rootProjectID
  190. };
  191. let addResult = await unitPriceFileModel.add(insertData);
  192. if (!addResult) {
  193. callback(1, '新增单价文件失败.', null);
  194. return;
  195. }
  196. data.updateData.property.unitPriceFile.id = addResult.id;
  197. }
  198. if (data.updateData.projType === projectType.tender) {
  199. //单价文件
  200. data.updateData.property.unitPriceFile.id=parseInt(data.updateData.property.unitPriceFile.id);
  201. //小数位数
  202. data.updateData.property.decimal = defaultDecimal;
  203. //清单工程量精度
  204. data.updateData.property.billsQuantityDecimal = billsQuantityDecimal;
  205. // 累进区间
  206. if (data.updateData.property.progressiveLibID) {
  207. data.updateData.property.progressiveInterval = await pmFacade.getProgressiveInterval(data.updateData.property.progressiveLibID);
  208. }
  209. //呈现选项
  210. data.updateData.property.displaySetting = displaySetting;
  211. data.updateData.property.billsCalcMode = 0;
  212. if(overWriteUrl && overWriteUrl !=""){
  213. let overWrite = require("../../.."+overWriteUrl);
  214. if(overWrite.getBillsCalcMode) data.updateData.property.billsCalcMode = overWrite.getBillsCalcMode();//重写清单计费取费方式
  215. }
  216. data.updateData.property.zanguCalcMode = 0;
  217. //计算选项
  218. data.updateData.property.calcOptions = calcOptions;
  219. //安装增加费
  220. if(data.updateData.property.isInstall == true || data.updateData.property.isInstall=='true'){//判断是否安装工程
  221. await installationFacade.copyInstallationFeeFromLib(data.updateData.ID,data.updateData.property.engineering_id);
  222. }
  223. //子目增加费
  224. if(data.updateData.property.isItemIncrease == true || data.updateData.property.isItemIncrease=='true'){//判断是否需计算子目增加费
  225. projectFacade.setDefaultItemIncrease(data.updateData.property);
  226. }
  227. //锁定清单
  228. data.updateData.property.lockBills = false;
  229. //工料机单价调整系数
  230. data.updateData.property.tenderSetting = tenderSetting;
  231. //添加重庆经济指标数据
  232. await projectFacade.setSEILibData(data.updateData.property);
  233. data.updateData.property.overHeight = await pmFacade.initOverHeightItems(data.updateData.property.engineering_id);
  234. if (data.updateData.property.overHeight.length) {
  235. // 对应清单或分部下
  236. data.updateData.property.overHeightOption = 1;
  237. }
  238. }else if (data.updateData.projType === projectType.project) {
  239. /* 创建概算清单 */
  240. const budgetTemplate = (data.updateData.property && data.updateData.property.budgetType || BudgetType.BUILDING) === BudgetType.BUILDING ? buildingTemplate : railTemplate;
  241. await newProjController.copyBillsTemplate(data.updateData.ID, budgetTemplate);
  242. //更新基本信息
  243. data.updateData.property.basicInformation.forEach(function (pData) {
  244. pData.items.forEach(function (item) {
  245. if (item.key === 'engineeringName') {
  246. item.value = data.updateData.name;
  247. } else if (item.key === 'fileKind') {
  248. item.value = {'1': '建筑安装工程', '2': '城市轨道交通工程'}[data.updateData.property.budgetType]
  249. } else if (item.key === 'taxModel') {
  250. item.value = {'1': '一般计税法', '2': '简易计税法'}[data.updateData.property.taxType]
  251. }
  252. });
  253. });
  254. }
  255. newProject = new Projects(data.updateData);
  256. if (data.updateData.projType === 'Tender') {
  257. let feeRateFileID = await feeRateFacade.newFeeRateFile(userId, data.updateData);
  258. newProject.property.feeFile = feeRateFileID ? feeRateFileID : -1;
  259. // 新建人工系数文件 CSL, 2017.10.13
  260. let lcFile = await labourCoeFacade.newProjectLabourCoe(data.updateData);
  261. newProject.property.labourCoeFile = lcFile ? lcFile : null;
  262. // 新建计算程序文件 CSL, 2017.10.23
  263. let cpFile = await calcProgramFacade.newProjectCalcProgramFile(data.updateData);
  264. newProject.property.calcProgramFile = cpFile ? cpFile : null;
  265. //新建设备购置计录行
  266. const empRow = {ID:uuidV1(),ParentID:'-1',seq:1};
  267. await equipmentPurchaseModel.create({projectID:newProject.ID,total:0,equipments:[empRow]});
  268. }
  269. newProject.save(async function (err, result) {
  270. if (!err && result._doc.projType === projectType.tender) {
  271. newProjController.copyTemplateData(result._doc.property, newProject.ID, updateAll);
  272. } else {
  273. updateAll(err);
  274. }
  275. });
  276. }
  277. else if (data.updateType === 'delete') {
  278. deleteInfo = {};
  279. deleteInfo['deleted'] = true;
  280. deleteInfo['deleteDateTime'] = new Date();
  281. deleteInfo['deleteBy'] = userId;
  282. data.updateData['deleteInfo'] = deleteInfo;
  283. //Projects.update({userID: userId, ID: data.updateData.ID}, data.updateData, updateAll);
  284. //update
  285. if (data.updateData.projType === projectType.project) {
  286. let engineerings = await Projects.find({ userID: userId, ParentID: data.updateData.ID });
  287. let isExist = false;
  288. if (engineerings.length > 0) {
  289. for (let j = 0, jLen = engineerings.length; j < jLen; j++) {
  290. let e_tenders = await Projects.find({ userID: userId, ParentID: engineerings[j].ID });
  291. if (e_tenders.length > 0) {
  292. isExist = true;
  293. break;
  294. }
  295. }
  296. }
  297. if (isExist) {//fake
  298. await UnitPriceFiles.update({
  299. user_id: userId,
  300. root_project_id: data.updateData.ID
  301. }, { $set: { deleteInfo: deleteInfo } }, { multi: true });
  302. await FeeRateFiles.update({
  303. userID: userId,
  304. rootProjectID: data.updateData.ID
  305. }, { $set: { deleteInfo: deleteInfo } }, { multi: true });
  306. await Projects.update({ userID: userId, ID: data.updateData.ID }, data.updateData, updateAll);
  307. }
  308. else {//true
  309. await UnitPriceFiles.remove({ user_id: userId, root_project_id: data.updateData.ID });
  310. await FeeRateFiles.remove({ userID: userId, rootProjectID: data.updateData.ID });
  311. //await Projects.update({userID: userId, NextSiblingID: data.updateData.ID, deleteInfo: null}, {$set: {NextSiblingID: data.NextSiblingID}});
  312. await Projects.remove({ userID: userId, ID: data.updateData.ID }, updateAll);
  313. }
  314. }
  315. else if (data.updateData.projType === projectType.engineering) {
  316. let tenders = await Projects.find({ userID: userId, ParentID: data.updateData.ID });
  317. if (tenders.length > 0) {//fake
  318. await Projects.update({ userID: userId, ID: data.updateData.ID }, data.updateData, updateAll);
  319. }
  320. else {//true
  321. //await Projects.update({userID: userId, NextSiblingID: data.updateData.ID, deleteInfo: null}, {$set: {NextSiblingID: data.NextSiblingID}});
  322. await Projects.remove({ userID: userId, ID: data.updateData.ID }, updateAll);
  323. }
  324. }
  325. else if (data.updateData.projType === projectType.tender) {//fake
  326. let delTender = await Projects.findOne({ userID: userId, ID: data.updateData.ID });
  327. //如果这个单位工程用到的费率文件、单价文件,没有被其他的单位工程使用,则应该一起跟随删除
  328. if (delTender) {
  329. let unitPriceFile = delTender.property.unitPriceFile;
  330. let feeRateFile = delTender.property.feeFile;
  331. let usedUFTenders = await Projects.find(
  332. { userID: userId, $or: [{ deleteInfo: null }, { 'deleteInfo.deleted': false }], 'property.unitPriceFile.id': unitPriceFile.id });
  333. if (usedUFTenders.length === 1) {
  334. await UnitPriceFiles.update({ id: unitPriceFile.id }, { $set: { deleteInfo: deleteInfo } });
  335. }
  336. let usedFRTenders = await Projects.find(
  337. { userID: userId, $or: [{ deleteInfo: null }, { 'deleteInfo.deleted': false }], 'property.feeFile.id': feeRateFile.id });
  338. if (usedFRTenders.length === 1) {
  339. await FeeRateFiles.update({ ID: feeRateFile.id }, { $set: { deleteInfo: deleteInfo } });
  340. }
  341. await Projects.update({ userID: userId, ID: data.updateData.ID }, data.updateData, updateAll);
  342. }
  343. }
  344. else if (data.updateData.projType === projectType.folder) {//true
  345. await Projects.remove({ userID: userId, ID: data.updateData.ID }, updateAll);
  346. }
  347. else throw '未知文件类型,删除失败!';
  348. }
  349. else {
  350. hasError = true;
  351. callback(1, '提交数据错误.', null);
  352. }
  353. }
  354. }
  355. };
  356. //导入接口数据
  357. ProjectsDAO.prototype.importInterface = async function (srcData) {
  358. };
  359. ProjectsDAO.prototype.udpateUserFiles = async function (userId, datas, callback) {
  360. let updateType = {update: 'update', delete: 'delete'};
  361. let deleteInfo = Object.create(null);
  362. deleteInfo.deleted = true;
  363. deleteInfo.deleteBy = userId;
  364. deleteInfo.deleteDateTime = new Date();
  365. try {
  366. for (let i = 0, len = datas.length; i < len; i++) {
  367. let data = datas[i];
  368. if (data.updateType === updateType.update && data.fileType === fileType.unitPriceFile) {
  369. await UnitPriceFiles.update({user_id: userId, id: parseInt(data.updateData.id)}, data.updateData);
  370. await Projects.update({
  371. userID: userId,
  372. 'property.unitPriceFile.id': data.updateData.id
  373. }, {$set: {'property.unitPriceFile.name': data.updateData.name}}, {multi: true});
  374. }
  375. else if (data.updateType === updateType.update && data.fileType === fileType.feeRateFile) {
  376. await FeeRateFiles.update({ID: data.updateData.ID}, data.updateData);
  377. await Projects.update({
  378. userID: userId,
  379. 'property.feeFile.id': data.updateData.ID
  380. }, {$set: {'property.feeFile.name': data.updateData.name}}, {multi: true});
  381. }
  382. else if (data.updateType === updateType.delete && data.fileType === fileType.unitPriceFile) {
  383. data.updateData.deleteInfo = deleteInfo;
  384. await UnitPriceFiles.update({user_id: userId, id: parseInt(data.updateData.id)}, data.updateData);
  385. }
  386. else if (data.updateType === updateType.delete && data.fileType === fileType.feeRateFile) {
  387. data.updateData.deleteInfo = deleteInfo;
  388. await FeeRateFiles.update({ID: data.updateData.ID}, data.updateData);
  389. }
  390. else throw '未知文件类型,删除失败'
  391. }
  392. callback(false, '删除成功', null);
  393. }
  394. catch (error) {
  395. callback(true, '删除失败', null);
  396. }
  397. };
  398. ProjectsDAO.prototype.copyUserProjects = function (userId, compilationId, datas, callback) {
  399. let data, project, updateLength = 0, hasError = false, deleteInfo = null, tempType = 1, i;
  400. let updateAll = function (err) {
  401. if (!err) {
  402. updateLength += 1;
  403. if (updateLength === datas.length) {
  404. callback(0, '', datas);
  405. }
  406. } else {
  407. hasError = true;
  408. callback(1, '提交数据出错.', null);
  409. }
  410. };
  411. if (datas) {
  412. for (i = 0; i < datas.length && !hasError; i++) {
  413. data = datas[i];
  414. if (data.updateType === 'update') {
  415. Projects.update({userID: userId, ID: data.updateData.ID}, data.updateData, updateAll)
  416. } else if (data.updateType === 'copy') {
  417. console.log(userId);
  418. data.updateData['userID'] = userId;
  419. data.updateData['compilation'] = compilationId;
  420. data.updateData['createDateTime'] = new Date();
  421. data.updateData['fileVer'] = index.getVersion();
  422. let newProject = new Projects(data.updateData);
  423. newProject['srcProjectId'] = data.srcProjectId;
  424. newProject.save(function (err, result) {
  425. if (!err && result._doc.projType === 'Tender') {
  426. copyProjController.copyProjectData(newProject.srcProjectId, result._doc.ID, updateAll);
  427. } else {
  428. updateAll(err);
  429. }
  430. });
  431. } else {
  432. hasError = true;
  433. callback(1, '提交数据错误', null);
  434. }
  435. }
  436. }
  437. };
  438. ProjectsDAO.prototype.rename = async function (userId, compilationId, data, callback) {
  439. try {
  440. if (data.id === undefined || data.id === '') {
  441. throw '数据错误!';
  442. }
  443. if (data.newName === undefined || data.newName === '') {
  444. throw '请填写名称!';
  445. }
  446. data.newName = data.newName.trim();
  447. let project = await Projects.findOne({ID: data.id});
  448. if (!project) {
  449. throw '项目不存在';
  450. }
  451. if (project.projType === 'Project' && project.property && Array.isArray(project.property.basicInformation)) {
  452. //更新基本信息
  453. project.property.basicInformation.forEach(function (pData) {
  454. pData.items.forEach(function (item) {
  455. if (item.key === 'engineeringName') {
  456. item.value = data.newName;
  457. }
  458. });
  459. });
  460. await Projects.update({ID: data.id}, {$set: {name: data.newName, 'property.basicInformation': project.property.basicInformation}});
  461. } else {
  462. await Projects.update({ID: data.id}, {$set: {name: data.newName}});
  463. }
  464. Projects.update({userID: userId, ID: data.id}, {name: data.newName}, function (err) {
  465. if (err) {
  466. throw '项目不存在';
  467. }
  468. });
  469. } catch (error) {
  470. callback(1, error, null);
  471. return;
  472. }
  473. callback(0, '');
  474. };
  475. ProjectsDAO.prototype.beforeOpenProject = function (userId, projectId, updateData, callback) {
  476. updateData['recentDateTime'] = new Date();
  477. Projects.update({userID: userId, ID: projectId}, updateData, function (err) {
  478. if (err) {
  479. callback(1, '项目不存在.');
  480. } else {
  481. callback(0, '');
  482. }
  483. });
  484. };
  485. ProjectsDAO.prototype.getNewProjectID = function (count, callback) {
  486. counter.counterDAO.getIDAfterCount(counter.moduleName.project, count, function (err, result) {
  487. console.log(result);
  488. let highID = result.sequence_value;
  489. if (!err) {
  490. callback(0, '', {lowID: highID - count + 1, highID: highID});
  491. } else {
  492. callback(1, '获取主键失败', null);
  493. }
  494. });
  495. };
  496. ProjectsDAO.prototype.getProject = function (key, callback) {
  497. if (callback) {
  498. Projects.findOne({'_id': key}, function (err, result) {
  499. if (err) {
  500. callback(1, '查找标段失败');
  501. } else {
  502. callback(0, result);
  503. }
  504. });
  505. } else {
  506. return Projects.findOne({$or: [{deleteInfo: null}, {'deleteInfo.deleted': false}], 'ID': key}).exec();
  507. }
  508. };
  509. ProjectsDAO.prototype.getProjectsByIds = async function (userId, compilationId, ids) {
  510. return await Projects.find({userID: userId, compilation: compilationId, ID: {$in: ids}}, '-_id -property');
  511. };
  512. ProjectsDAO.prototype.getGCFiles = async function (fileType, userID) {
  513. let rst;
  514. if (fileType === 'UnitPriceFile') {
  515. let unitPriceFileModel = new UnitPriceFileModel();
  516. rst = await unitPriceFileModel.getGCUnitPriceFiles(userID);
  517. }
  518. else if (fileType === 'FeeRateFile') {
  519. rst = await feeRateFacade.getGCFeeRateFiles(userID);
  520. }
  521. else {
  522. let isExist = false;
  523. for (let type in projectType) {
  524. if (projectType[type] === fileType) {
  525. isExist = true;
  526. break;
  527. }
  528. }
  529. if (!isExist) throw '不存在此项目类型!';
  530. rst = await Projects.find(
  531. {userID: userID, projType: fileType, 'deleteInfo.deleted': true, '$or': [{'deleteInfo.completeDeleted': false}, {'deleteInfo.completeDeleted': null}]});
  532. }
  533. return rst;
  534. };
  535. ProjectsDAO.prototype.getFirstNodeID = async function (userID, compilationId, pid) {
  536. let nodes = await Projects.find({userID: userID, compilation: compilationId, ParentID: pid, deleteInfo: null});
  537. if (nodes.length === 0) {
  538. return -1;
  539. }
  540. else {
  541. let prefix = 'ID_';
  542. let chain = Object.create(null);
  543. for (let i = 0, len = nodes.length; i < len; i++) {
  544. let nodeDoc = nodes[i]._doc;
  545. let node = Object.create(null);
  546. node.ID = nodeDoc.ID;
  547. node.NextSiblingID = nodeDoc.NextSiblingID;
  548. chain[prefix + node.ID] = node;
  549. }
  550. for (let i = 0, len = nodes.length; i < len; i++) {
  551. let nodeDoc = nodes[i]._doc;
  552. let next = nodeDoc.NextSiblingID > 0 ? chain[prefix + nodeDoc.NextSiblingID] : null;
  553. chain[prefix + nodeDoc.ID].next = next;
  554. if (next) {
  555. next.pre = chain[prefix + nodeDoc.ID]
  556. }
  557. }
  558. for (let node in chain) {
  559. let pre = chain[node].pre || null;
  560. if (!pre) {
  561. return chain[node].ID;
  562. }
  563. }
  564. }
  565. };
  566. ProjectsDAO.prototype.recGC = async function (userID, compilationId, datas, callback) {
  567. let functions = [];
  568. let updateDatas = [];
  569. for (let i = 0, len = datas.length; i < len; i++) {
  570. if (datas[i].findData.ParentID !== undefined && datas[i].findData.NextSiblingID === -1 && !datas[i].findData.deleteInfo) {//维护项目管理树
  571. let findNode = await Projects.find(datas[i].findData);
  572. if (findNode.length > 0) {
  573. datas[i].findData = Object.create(null);
  574. datas[i].findData.ID = findNode[0].ID;
  575. updateDatas.push(datas[i]);
  576. }
  577. }
  578. else {
  579. if (datas[i].updateType === projectType.project && datas[i].updateData.NextSiblingID === undefined) {//则为待查询NextSiblingID,前端无法查询
  580. let projData = await Projects.find({userID: userID, ID: datas[i].findData.ID});//建设项目原本可能属于某文件夹、文件夹的存在需要判断
  581. let projPid = projData[0].ParentID;
  582. if (projPid !== -1) {
  583. let projFolder = await Projects.find({userID: userID, ID: projPid});
  584. if (projFolder.length === 0) {//文件夹已不存在
  585. projPid = -1;
  586. datas[i].updateData.ParentID = -1;
  587. }
  588. }
  589. let firstNodeID = await this.getFirstNodeID(userID, compilationId, projPid);
  590. datas[i].updateData.NextSiblingID = firstNodeID;
  591. }
  592. updateDatas.push(datas[i])
  593. }
  594. }
  595. for (let i = 0, len = updateDatas.length; i < len; i++) {
  596. functions.push((function (data) {
  597. return function (cb) {
  598. if (data.updateType === fileType.unitPriceFile) {
  599. UnitPriceFiles.update({id: parseInt(data.findData.id)}, data.updateData, function (err) {
  600. if (err) cb(err);
  601. else {
  602. Projects.update({
  603. userID: userID,
  604. 'property.unitPriceFile.id': data.findData.id
  605. }, {$set: {'property.unitPriceFile.name': data.updateData.name}}, function (err) {
  606. if (err) cb(err);
  607. else cb(false);
  608. });
  609. }
  610. })
  611. }
  612. else if (data.updateType === fileType.feeRateFile) {
  613. FeeRateFiles.update(data.findData, data.updateData, function (err) {
  614. if (err) cb(err);
  615. else {
  616. Projects.update({
  617. userID: userID,
  618. 'property.feeFile.id': data.findData.ID
  619. }, {$set: {'property.feeFile.name': data.updateData.name}}, function (err) {
  620. if (err) cb(err);
  621. else cb(false);
  622. });
  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. ProjectsDAO.prototype.getExtendData = function(property,compilation) {
  722. let ext = {};
  723. if(property){
  724. let region = property.region;
  725. let taxType = property.taxType;
  726. if(compilation.priceProperties && compilation.priceProperties.length > 0){//如果是具有多单价的编办,取单价对应的字段
  727. let priceProperty = _.find(compilation.priceProperties,{region:region,taxModel:parseInt(taxType)});
  728. if(priceProperty){
  729. ext['priceField'] = priceProperty.price.dataCode;
  730. }
  731. }
  732. if(compilation.consumeAmtProperties && compilation.consumeAmtProperties.length > 0){
  733. let consumeAmt = _.find(compilation.consumeAmtProperties,{region:region,taxModel:parseInt(taxType)});
  734. if(consumeAmt){
  735. ext['quantityField'] = consumeAmt.consumeAmt.dataCode;
  736. }
  737. }
  738. }
  739. return _.isEmpty(ext)?null:ext;
  740. }
  741. /**
  742. * 获取当前用户的建设项目数据
  743. *
  744. * @paraconsolem {Number} userId
  745. * @return {Promise}
  746. */
  747. ProjectsDAO.prototype.getUserProjectData = async function (userId,compilation) {
  748. let projectList = await Projects.find({
  749. '$or': [
  750. {'userID': userId, 'compilation': compilation, 'deleteInfo': null, projType: 'Project'},
  751. {'userID': userId, 'compilation': compilation,'deleteInfo.deleted': {'$in': [null, false]}, projType: 'Project'}
  752. ]
  753. }, {_id: 0, name: 1, ID: 1, NextSiblingID: 1, ParentID: 1});
  754. return projectList;
  755. };
  756. /**
  757. * 更改项目属性中的单价文件
  758. *
  759. * @param {Number} projectId
  760. * @param {Object} changeInfo
  761. * @return {Promise}
  762. */
  763. ProjectsDAO.prototype.changeUnitPriceFileInfo = async function (projectId, changeInfo) {
  764. projectId = parseInt(projectId);
  765. if (isNaN(projectId) || projectId <= 0) {
  766. return false;
  767. }
  768. let result = await Projects.update({ID: projectId}, {"property.unitPriceFile": changeInfo});
  769. return result.ok === 1;
  770. };
  771. /**
  772. * 更新项目属性
  773. *
  774. * @param {Number} projectId - 项目id
  775. * @param {Object} propertyData - 项目属性数据
  776. * @return {Promise}
  777. */
  778. ProjectsDAO.prototype.updateProjectProperty = async function(projectId, propertyData) {
  779. projectId = parseInt(projectId);
  780. if (isNaN(projectId) || projectId <= 0 || propertyData.property === undefined || propertyData.data === undefined) {
  781. return false;
  782. }
  783. const updateData = {};
  784. updateData["property." + propertyData.property] = propertyData.data;
  785. let result = await Projects.update({ID: projectId}, updateData);
  786. return result.ok === 1;
  787. };
  788. // CSL, 2018-01-11 获取指定ID节点(如单项工程、建设项目)下所有单位工程的各项汇总金额,用于报表计算汇总。
  789. ProjectsDAO.prototype.getSummaryFees = async function (ID) {
  790. async function getProject(ID){
  791. return await Projects.findOne({'ID': ID, deleteInfo: null}, need);
  792. };
  793. async function getChildrenDocs(IDs){
  794. return await Projects.find({'ParentID': {"$in":IDs}, deleteInfo: null}, need);
  795. };
  796. async function getEgrIDs(ID){
  797. let _docs = await Projects.find({'ParentID': ID, deleteInfo: null}, ['ID', '-_id']);
  798. let arr = [];
  799. for (let doc of _docs){
  800. arr.push(doc.ID);
  801. };
  802. return arr;
  803. };
  804. let need = ['ID', 'ParentID', 'NextSiblingID', 'name', 'projType',
  805. 'fullFolder', 'summaryFees', '-_id'];
  806. let _doc = await getProject(ID);
  807. if (!_doc) return _doc;
  808. if (_doc.projType.sameText('Engineering')){
  809. return await getChildrenDocs([ID]);
  810. }
  811. else if (_doc.projType.sameText('Project')){
  812. let eIDs = await getEgrIDs(ID);
  813. return await getChildrenDocs(eIDs);
  814. }
  815. else{
  816. return _doc;
  817. };
  818. };
  819. ProjectsDAO.prototype.updateUnitFileToProject=async function(projectID,unitFile){
  820. return await Projects.findOneAndUpdate({'ID':projectID},{'property.unitPriceFile':unitFile});
  821. }
  822. //获取建设项目项目属性
  823. ProjectsDAO.prototype.getConstructionProperty = async function (projectID) {
  824. //获取建设项目
  825. let constructionProject = await pmFacade.getConstructionProject(projectID);
  826. if(!constructionProject || !constructionProject.property){
  827. return null;
  828. }
  829. return constructionProject.property;
  830. };
  831. //获取建设项目的基本信息
  832. ProjectsDAO.prototype.getBasicInfo = async function (projectID) {
  833. //获取建设项目
  834. let constructionProject = await pmFacade.getConstructionProject(projectID);
  835. if(!constructionProject || !constructionProject.property || !constructionProject.property.basicInformation){
  836. return null;
  837. }
  838. return constructionProject.property.basicInformation;
  839. };
  840. //恢复默认系统设置
  841. ProjectsDAO.prototype.defaultSettings = async function (userID, compilationId, projectID) {
  842. let project = await Projects.findOne({ID: projectID});
  843. if(!project){
  844. return false;
  845. }
  846. let cloneProperty = _.cloneDeep(project.property);
  847. //关于计算
  848. cloneProperty.billsCalcMode = 0;
  849. cloneProperty.zanguCalcMode = 0;
  850. cloneProperty.calcOptions = calcOptions;
  851. //清单工程量精度
  852. cloneProperty.billsQuantityDecimal = billsQuantityDecimal;
  853. //小数位数
  854. cloneProperty.decimal = defaultDecimal;
  855. //呈现选项
  856. cloneProperty.displaySetting = displaySetting;
  857. //列设置
  858. let stdColLib = await mainColLibModel.findOne({ID: project.property.colLibID});
  859. if(stdColLib){
  860. await projSettingModel.update({projectID: projectID}, {$set: {main_tree_col: stdColLib.main_tree_col}});
  861. }
  862. //系统选项
  863. await optionModel.update({user_id: userID, compilation_id: compilationId}, {$set: {options: optionSetting}});
  864. await Projects.update({ID: projectID}, {$set: {property: cloneProperty}});
  865. return true;
  866. };