project.js 3.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122
  1. /**
  2. * Created by Mai on 2017/1/18.
  3. */
  4. //*/
  5. var mongoose = require("mongoose");
  6. var dbm = require("../../../config/db/db_manager");
  7. var db = dbm.getCfgConnection("usersManages");
  8. var Schema = mongoose.Schema;
  9. var ProjectSchema = new Schema({
  10. "ID": Number,
  11. "ParentID": Number,
  12. "NextSiblingID": Number,
  13. "userID": Number,
  14. "name": String,
  15. "projType": String,
  16. "recentDateTime": Date,
  17. "createDateTime": Date,
  18. "deleted": Boolean,
  19. 'deleteDateTime': Date,
  20. 'fullFolder': Array
  21. });
  22. var Projects = db.model("projects", ProjectSchema);
  23. /*/
  24. var db = require('../db/pm_db');
  25. var Schema = db.mongoose.Schema;
  26. var ProjectSchema = new Schema({
  27. "name": String,
  28. "projType": String,
  29. "lastDateTime": String,
  30. "createDateTime": String,
  31. "id": Number,
  32. "parentId": Number,
  33. "nextId": Number,
  34. "userId": Number,
  35. "deleted": Boolean,
  36. 'deleteDateTime': String,
  37. 'deleteFullFolder': Array
  38. });
  39. var Projects = db.mongoose.model("projects", ProjectSchema);
  40. //*/
  41. var ProjectsDAO = function(){};
  42. ProjectsDAO.prototype.getUserProjects = function(userId, callback){
  43. Projects.find({userID: userId, deleted: { $in: [false, null]}}, '-_id', function(err, templates){
  44. if (err) {
  45. callback(1, 'Error', null);
  46. } else {
  47. callback(0, '', templates);
  48. }
  49. });
  50. };
  51. ProjectsDAO.prototype.getUserProject = function (userId, ProjId, callback) {
  52. Projects.findOne({userID: userId, ID: ProjId}, '-_id', function(err, template){
  53. if (err) {
  54. callback(1, '找不到标段数据', null);
  55. } else {
  56. callback(0, '', template);
  57. }
  58. });
  59. }
  60. ProjectsDAO.prototype.updateUserProjects = function(userId, datas, callback){
  61. var data, project, updateLength = 0, hasError = false;
  62. var updateAll = function (err) {
  63. if (!err){
  64. updateLength += 1;
  65. if (updateLength === datas.length) {
  66. callback(0, '', datas);
  67. }
  68. } else {
  69. hasError = true;
  70. callback(1, '提交数据出错.', null);
  71. }
  72. };
  73. if (datas){
  74. for (var i = 0; i < datas.length && !hasError; i++){
  75. data = datas[i];
  76. if (data.updateType === 'update') {
  77. Projects.update({userID: userId, ID: data.updateData.ID}, data.updateData, updateAll)
  78. } else if (data.updateType === 'new') {
  79. data.updateData['userID'] = userId;
  80. if (data.updateData.projType === 'Tender') {
  81. data.updateData['createDateTime'] = new Date();
  82. }
  83. newProject = new Projects(data.updateData);
  84. newProject.save(updateAll);
  85. } else if (data.updateType === 'delete') {
  86. data.updateData['deleteDateTime'] = new Date();
  87. Projects.update({userID: userId, ID: data.updateData.ID}, data.updateData, updateAll);
  88. }
  89. }
  90. }
  91. };
  92. ProjectsDAO.prototype.rename = function (userId, projectId, newName, callback){
  93. Projects.update({userID: userId, ID: projectId}, {name: newName}, function(err){
  94. if (err){
  95. callback(1, '项目不存在.');
  96. } else {
  97. callback(0, '');
  98. }
  99. });
  100. };
  101. ProjectsDAO.prototype.beforeOpenProject = function (userId, projectId, updateData, callback){
  102. updateData['recentDateTime'] = new Date();
  103. Projects.update({userID: userId, ID: projectId}, updateData, function(err){
  104. if (err){
  105. callback(1, '项目不存在.');
  106. } else {
  107. callback(0, '');
  108. }
  109. });
  110. };
  111. module.exports = new ProjectsDAO();