project_model.js 8.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260
  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 Projects = require("./project_schema");
  9. let projectType = {
  10. folder: 'Folder',
  11. tender: 'Tender',
  12. project: 'Project',
  13. engineering: 'Engineering',
  14. };
  15. let ProjectsDAO = function(){};
  16. ProjectsDAO.prototype.getUserProjects = function(userId, callback){
  17. Projects.find({'$or': [{'userID': userId, 'deleteInfo': null}, {'userID': userId, 'deleteInfo.deleted': {'$in': [null, false]}}]}, '-_id', function(err, templates){
  18. if (err) {
  19. callback(1, 'Error', null);
  20. } else {
  21. callback(0, '', templates);
  22. }
  23. });
  24. };
  25. ProjectsDAO.prototype.getUserProject = function (userId, ProjId, callback) {
  26. Projects.findOne({userID: userId, ID: ProjId}, '-_id', function(err, template){
  27. if (err) {
  28. callback(1, '找不到标段数据', null);
  29. } else {
  30. callback(0, '', template);
  31. }
  32. });
  33. }
  34. ProjectsDAO.prototype.updateUserProjects = async function(userId, datas, callback){
  35. let data, project, updateLength = 0, hasError = false, deleteInfo = null, i, newProject;
  36. let updateAll = function (err) {
  37. if (!err){
  38. updateLength += 1;
  39. if (updateLength === datas.length) {
  40. callback(0, '', datas);
  41. }
  42. } else {
  43. hasError = true;
  44. console.log(err);
  45. callback(1, '提交数据出错.', null);
  46. }
  47. };
  48. if (datas){
  49. for (i = 0; i < datas.length && !hasError; i++){
  50. data = datas[i];
  51. if (data.updateData.name !== undefined) {
  52. data.updateData.name = data.updateData.name.trim();
  53. }
  54. if (data.updateType === 'update') {
  55. Projects.update({userID: userId, ID: data.updateData.ID}, data.updateData, updateAll)
  56. } else if (data.updateType === 'new') {
  57. data.updateData['userID'] = userId;
  58. data.updateData['createDateTime'] = new Date();
  59. newProject = new Projects(data.updateData);
  60. // 查找同级是否存在同名数据
  61. let exist = await this.isExist(data.updateData.name, data.updateData.ParentID);
  62. if (exist) {
  63. callback(1, '同级目录已存在相同名称数据.', null);
  64. return;
  65. }
  66. newProject.save(async function (err, result) {
  67. if (!err && result._doc.projType === projectType.tender) {
  68. newProjController.copyTemplateData(data.updateData.property, newProject.ID, updateAll);
  69. // 如果没有选中单价文件则新增单价文件
  70. if (data.updateData.property !== null && data.updateData.property.unitPriceFile === '') {
  71. let unitPriceFileModel = new UnitPriceFileModel();
  72. let insertData = {
  73. name: data.updateData.name,
  74. project_id: data.updateData.ID
  75. };
  76. let addResult = await unitPriceFileModel.add(insertData);
  77. if (!addResult) {
  78. callback(1, '新增单价文件失败.', null);
  79. return;
  80. }
  81. }
  82. } else {
  83. updateAll(err);
  84. }
  85. });
  86. } else if (data.updateType === 'delete') {
  87. deleteInfo = {};
  88. deleteInfo['deleted'] = true;
  89. deleteInfo['deleteDateTime'] = new Date();
  90. deleteInfo['deleteBy'] = userId;
  91. data.updateData['deleteInfo'] = deleteInfo;
  92. Projects.update({userID: userId, ID: data.updateData.ID}, data.updateData, updateAll);
  93. } else {
  94. hasError = true;
  95. callback(1, '提交数据错误.', null);
  96. }
  97. }
  98. }
  99. };
  100. ProjectsDAO.prototype.copyUserProjects = function (userId, datas, callback) {
  101. let data, project, updateLength = 0, hasError = false, deleteInfo = null, tempType = 1, i;
  102. let updateAll = function (err) {
  103. if (!err){
  104. updateLength += 1;
  105. if (updateLength === datas.length) {
  106. callback(0, '', datas);
  107. }
  108. } else {
  109. hasError = true;
  110. callback(1, '提交数据出错.', null);
  111. }
  112. };
  113. if (datas) {
  114. for (i = 0; i < datas.length && !hasError; i++) {
  115. data = datas[i];
  116. if (data.updateType === 'update') {
  117. Projects.update({userID: userId, ID: data.updateData.ID}, data.updateData, updateAll)
  118. } else if (data.updateType === 'copy') {
  119. data.updateData['userID'] = userId;
  120. data.updateData['createDateTime'] = new Date();
  121. let newProject = new Projects(data.updateData);
  122. newProject['srcProjectId'] = data.srcProjectId;
  123. newProject.save(function (err, result) {
  124. if (!err && result._doc.projType === 'Tender') {
  125. copyProjController.copyProjectData(newProject.srcProjectId, result._doc.ID, updateAll);
  126. } else {
  127. updateAll(err);
  128. }
  129. });
  130. } else {
  131. hasError = true;
  132. callback(1, '提交数据错误', null);
  133. }
  134. }
  135. }
  136. };
  137. ProjectsDAO.prototype.rename = async function (userId, data, callback){
  138. try {
  139. if (data.id === undefined || data.id === '') {
  140. throw '数据错误!';
  141. }
  142. if (data.newName === undefined || data.newName === '') {
  143. throw '请填写名称!';
  144. }
  145. // 查找同级是否存在同名数据
  146. let exist = await this.isExist(data.newName, data.parentID);
  147. if (exist) {
  148. throw '同级目录已存在相同名称数据';
  149. }
  150. Projects.update({userID: userId, ID: data.id}, {name: data.newName}, function(err){
  151. if (err){
  152. throw '项目不存在';
  153. }
  154. });
  155. } catch (error) {
  156. callback(1, error, null);
  157. return;
  158. }
  159. callback(0, '');
  160. };
  161. ProjectsDAO.prototype.beforeOpenProject = function (userId, projectId, updateData, callback){
  162. updateData['recentDateTime'] = new Date();
  163. Projects.update({userID: userId, ID: projectId}, updateData, function(err){
  164. if (err){
  165. callback(1, '项目不存在.');
  166. } else {
  167. callback(0, '');
  168. }
  169. });
  170. };
  171. ProjectsDAO.prototype.getNewProjectID = function (count, callback) {
  172. counter.counterDAO.getIDAfterCount(counter.moduleName.project, count, function (err, result) {
  173. let highID = result.value.sequence_value;
  174. if (!err) {
  175. callback(0, '', {lowID: highID - count + 1, highID: highID});
  176. } else {
  177. callback(1, '获取主键失败', null);
  178. }
  179. });
  180. };
  181. ProjectsDAO.prototype.getProject = function (key, callback) {
  182. if (callback) {
  183. Projects.findOne({'_id': key}, function (err, result) {
  184. if (err) {
  185. callback(1, '查找标段失败');
  186. } else {
  187. callback(0, result);
  188. }
  189. });
  190. } else {
  191. return Projects.findOne({'ID': key}).exec();
  192. }
  193. };
  194. /**
  195. * 整理工程专业对应标准库数据
  196. *
  197. * @param {Object} data
  198. * @return {Boolean}
  199. */
  200. ProjectsDAO.prototype.isExist = async function(name, parentID) {
  201. parentID = parseInt(parentID);
  202. if (name === '' || isNaN(parentID)) {
  203. return true;
  204. }
  205. let count = await Projects.count({ParentID: parentID, name: name});
  206. return count > 0;
  207. };
  208. /**
  209. * 获取对应建设项目下所有的单位工程id
  210. *
  211. * @param {Number} projectId
  212. * @return {Promise}
  213. */
  214. ProjectsDAO.prototype.getTenderByProjectId = async function(projectId) {
  215. let result = [];
  216. // 首先获取对应的单位工程id
  217. let engineeringData = await Projects.find({ParentID: projectId});
  218. if (engineeringData.length <= 0) {
  219. return result;
  220. }
  221. let engineeringIdList = [];
  222. for(let tmp of engineeringData) {
  223. engineeringIdList.push(tmp.ID);
  224. }
  225. // 查找对应的单位工程id
  226. let tenderData = await Projects.find({ParentID: {$in: engineeringIdList}});
  227. if (tenderData.length <= 0) {
  228. return result;
  229. }
  230. for(let tmp of tenderData) {
  231. result.push(tmp.ID);
  232. }
  233. return result;
  234. };
  235. module.exports ={
  236. project: new ProjectsDAO(),
  237. projType: projectType
  238. };