project_model.js 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339
  1. /**
  2. * Created by Mai on 2017/1/18.
  3. */
  4. import UnitPriceFileModel from "../../glj/models/unit_price_file_model";
  5. let counter = require("../../../public/counter/counter.js");
  6. let newProjController = require('../controllers/new_proj_controller');
  7. let copyProjController = require('../controllers/copy_proj_controller');
  8. let feeRateFacade = require('../../fee_rates/facade/fee_rates_facade');
  9. let logger = require("../../../logs/log_helper").logger;
  10. let Projects = require("./project_schema");
  11. let projectType = {
  12. folder: 'Folder',
  13. tender: 'Tender',
  14. project: 'Project',
  15. engineering: 'Engineering',
  16. };
  17. let ProjectsDAO = function(){};
  18. ProjectsDAO.prototype.getUserProjects = function(userId, callback){
  19. Projects.find({'$or': [{'userID': userId, 'deleteInfo': null}, {'userID': userId, 'deleteInfo.deleted': {'$in': [null, false]}}]}, '-_id', function(err, templates){
  20. if (err) {
  21. callback(1, 'Error', null);
  22. } else {
  23. callback(0, '', templates);
  24. }
  25. });
  26. };
  27. ProjectsDAO.prototype.getUserProject = function (userId, ProjId, callback) {
  28. Projects.findOne({userID: userId, ID: ProjId}, '-_id', function(err, template){
  29. if (err) {
  30. callback(1, '找不到标段数据', null);
  31. } else {
  32. callback(0, '', template);
  33. }
  34. });
  35. }
  36. ProjectsDAO.prototype.updateUserProjects = async function(userId, datas, callback){
  37. let data, project, updateLength = 0, hasError = false, deleteInfo = null, i, newProject;
  38. let updateAll = function (err) {
  39. if (!err){
  40. updateLength += 1;
  41. if (updateLength === datas.length) {
  42. callback(0, '', datas);
  43. }
  44. } else {
  45. hasError = true;
  46. console.log(err);
  47. callback(1, '提交数据出错.', null);
  48. }
  49. };
  50. if (datas){
  51. for (i = 0; i < datas.length && !hasError; i++){
  52. data = datas[i];
  53. if (data.updateData.name !== undefined) {
  54. data.updateData.name = data.updateData.name.trim();
  55. }
  56. if (data.updateType === 'update') {
  57. Projects.update({userID: userId, ID: data.updateData.ID}, data.updateData, updateAll)
  58. } else if (data.updateType === 'new') {
  59. data.updateData['userID'] = userId;
  60. data.updateData['createDateTime'] = new Date();
  61. // 如果没有选中单价文件则新增单价文件
  62. if (data.updateData.projType === projectType.tender && data.updateData.property !== null &&
  63. Object.keys(data.updateData.property.unitPriceFile).length > 0 &&
  64. data.updateData.property.unitPriceFile.id === '') {
  65. let unitPriceFileModel = new UnitPriceFileModel();
  66. let insertData = {
  67. name: data.updateData.name,
  68. project_id: data.updateData.ID
  69. };
  70. let addResult = await unitPriceFileModel.add(insertData);
  71. if (!addResult) {
  72. callback(1, '新增单价文件失败.', null);
  73. return;
  74. }
  75. data.updateData.property.unitPriceFile.id = addResult.id + '';
  76. }
  77. newProject = new Projects(data.updateData);
  78. // 查找同级是否存在同名数据
  79. let exist = await this.isExist(data.updateData.name, data.updateData.ParentID);
  80. if (exist) {
  81. callback(1, '同级目录已存在相同名称数据.', null);
  82. return;
  83. }
  84. if(data.updateData.projType==='Tender'){
  85. let feeRateFileID = await feeRateFacade.newFeeRateFile(data.updateData);
  86. newProject.property.feeFile = feeRateFileID?feeRateFileID:-1;
  87. }
  88. newProject.save(async function (err, result) {
  89. if (!err && result._doc.projType === projectType.tender) {
  90. newProjController.copyTemplateData(data.updateData.property, newProject.ID, updateAll);
  91. } else {
  92. updateAll(err);
  93. }
  94. });
  95. } else if (data.updateType === 'delete') {
  96. deleteInfo = {};
  97. deleteInfo['deleted'] = true;
  98. deleteInfo['deleteDateTime'] = new Date();
  99. deleteInfo['deleteBy'] = userId;
  100. data.updateData['deleteInfo'] = deleteInfo;
  101. Projects.update({userID: userId, ID: data.updateData.ID}, data.updateData, updateAll);
  102. } else {
  103. hasError = true;
  104. callback(1, '提交数据错误.', null);
  105. }
  106. }
  107. }
  108. };
  109. ProjectsDAO.prototype.copyUserProjects = function (userId, datas, callback) {
  110. let data, project, updateLength = 0, hasError = false, deleteInfo = null, tempType = 1, i;
  111. let updateAll = function (err) {
  112. if (!err){
  113. updateLength += 1;
  114. if (updateLength === datas.length) {
  115. callback(0, '', datas);
  116. }
  117. } else {
  118. hasError = true;
  119. callback(1, '提交数据出错.', null);
  120. }
  121. };
  122. if (datas) {
  123. for (i = 0; i < datas.length && !hasError; i++) {
  124. data = datas[i];
  125. if (data.updateType === 'update') {
  126. Projects.update({userID: userId, ID: data.updateData.ID}, data.updateData, updateAll)
  127. } else if (data.updateType === 'copy') {
  128. data.updateData['userID'] = userId;
  129. data.updateData['createDateTime'] = new Date();
  130. let newProject = new Projects(data.updateData);
  131. newProject['srcProjectId'] = data.srcProjectId;
  132. newProject.save(function (err, result) {
  133. if (!err && result._doc.projType === 'Tender') {
  134. copyProjController.copyProjectData(newProject.srcProjectId, result._doc.ID, updateAll);
  135. } else {
  136. updateAll(err);
  137. }
  138. });
  139. } else {
  140. hasError = true;
  141. callback(1, '提交数据错误', null);
  142. }
  143. }
  144. }
  145. };
  146. ProjectsDAO.prototype.rename = async function (userId, data, callback){
  147. try {
  148. if (data.id === undefined || data.id === '') {
  149. throw '数据错误!';
  150. }
  151. if (data.newName === undefined || data.newName === '') {
  152. throw '请填写名称!';
  153. }
  154. // 查找同级是否存在同名数据
  155. let exist = await this.isExist(data.newName, data.parentID);
  156. if (exist) {
  157. throw '同级目录已存在相同名称数据';
  158. }
  159. Projects.update({userID: userId, ID: data.id}, {name: data.newName}, function(err){
  160. if (err){
  161. throw '项目不存在';
  162. }
  163. });
  164. } catch (error) {
  165. callback(1, error, null);
  166. return;
  167. }
  168. callback(0, '');
  169. };
  170. ProjectsDAO.prototype.beforeOpenProject = function (userId, projectId, updateData, callback){
  171. updateData['recentDateTime'] = new Date();
  172. Projects.update({userID: userId, ID: projectId}, updateData, function(err){
  173. if (err){
  174. callback(1, '项目不存在.');
  175. } else {
  176. callback(0, '');
  177. }
  178. });
  179. };
  180. ProjectsDAO.prototype.getNewProjectID = function (count, callback) {
  181. counter.counterDAO.getIDAfterCount(counter.moduleName.project, count, function (err, result) {
  182. let highID = result.value.sequence_value;
  183. if (!err) {
  184. callback(0, '', {lowID: highID - count + 1, highID: highID});
  185. } else {
  186. callback(1, '获取主键失败', null);
  187. }
  188. });
  189. };
  190. ProjectsDAO.prototype.getProject = function (key, callback) {
  191. if (callback) {
  192. Projects.findOne({'_id': key}, function (err, result) {
  193. if (err) {
  194. callback(1, '查找标段失败');
  195. } else {
  196. callback(0, result);
  197. }
  198. });
  199. } else {
  200. return Projects.findOne({'ID': key}).exec();
  201. }
  202. };
  203. /**
  204. * 整理工程专业对应标准库数据
  205. *
  206. * @param {Object} data
  207. * @return {Boolean}
  208. */
  209. ProjectsDAO.prototype.isExist = async function(name, parentID) {
  210. parentID = parseInt(parentID);
  211. if (name === '' || isNaN(parentID)) {
  212. return true;
  213. }
  214. let count = await Projects.count({ParentID: parentID, name: name});
  215. return count > 0;
  216. };
  217. /**
  218. * 获取对应建设项目下所有的单位工程id
  219. *
  220. * @param {Number} projectId
  221. * @return {Promise}
  222. */
  223. ProjectsDAO.prototype.getTenderByProjectId = async function(projectId) {
  224. let result = [];
  225. // 首先获取对应的单位工程id
  226. let engineeringData = await Projects.find({ParentID: projectId});
  227. if (engineeringData.length <= 0) {
  228. return result;
  229. }
  230. let engineeringIdList = [];
  231. for(let tmp of engineeringData) {
  232. engineeringIdList.push(tmp.ID);
  233. }
  234. // 查找对应的单位工程id
  235. let tenderData = await Projects.find({ParentID: {$in: engineeringIdList}});
  236. if (tenderData.length <= 0) {
  237. return result;
  238. }
  239. for(let tmp of tenderData) {
  240. result.push(tmp.ID);
  241. }
  242. return result;
  243. };
  244. /**
  245. * 根据单价文件id获取对应的标段数据
  246. *
  247. * @param {Number} unitPriceFileId
  248. * @return {Promise}
  249. */
  250. ProjectsDAO.prototype.getTenderByUnitPriceFileId = async function(unitPriceFileId) {
  251. let result = [];
  252. unitPriceFileId = parseInt(unitPriceFileId);
  253. if (isNaN(unitPriceFileId) && unitPriceFileId <= 0) {
  254. return result;
  255. }
  256. let condition = {projType: 'Tender', "property.unitPriceFile.id": unitPriceFileId + ''};
  257. result = await Projects.find(condition);
  258. return result;
  259. };
  260. /**
  261. * 根据项目id获取单价文件列表id
  262. *
  263. * @param {Number} projectId
  264. * @return {Promise}
  265. */
  266. ProjectsDAO.prototype.getUnitPriceFileId = async function(projectId) {
  267. let result = 0;
  268. let projectData = await Projects.findOne({ID: projectId});
  269. if (projectData === null) {
  270. return result;
  271. }
  272. result = projectData.property.unitPriceFile.id;
  273. return result;
  274. };
  275. /**
  276. * 获取当前用户的建设项目数据
  277. *
  278. * @param {Number} userId
  279. * @return {Promise}
  280. */
  281. ProjectsDAO.prototype.getUserProjectData = async function(userId) {
  282. let projectList = await Projects.find({
  283. '$or': [
  284. {'userID': userId, 'deleteInfo': null, projType: 'Project'},
  285. {'userID': userId, 'deleteInfo.deleted': {'$in': [null, false]}, projType: 'Project'}
  286. ]
  287. }, {_id: 0, name: 1, ID: 1});
  288. return projectList;
  289. };
  290. /**
  291. * 更改项目属性中的单价文件
  292. *
  293. * @param {Number} projectId
  294. * @param {Object} changeInfo
  295. * @return {Promise}
  296. */
  297. ProjectsDAO.prototype.changeUnitPriceFileInfo = async function(projectId, changeInfo) {
  298. projectId = parseInt(projectId);
  299. if (isNaN(projectId) || projectId <= 0) {
  300. return false;
  301. }
  302. let result = await Projects.update({ID: projectId}, {"property.unitPriceFile": changeInfo});
  303. return result.ok === 1;
  304. };
  305. module.exports ={
  306. project: new ProjectsDAO(),
  307. projType: projectType
  308. };