ConstructionOperation/modules/ration_repository/models/repository_map.js

/**
 * Created by Tony on 2017/4/24.
 * 重新构造，不适宜生成多个定额库db，还是得统一在一个表
 */
var mongoose = require('mongoose');
var dbm = require("../../../config/db/db_manager");
let async = require("async");
let moment = require('moment');
import {gljMapModel} from "../../std_glj_lib/models/schemas";
//var stringUtil = require('../../../public/stringUtil');
var rationLibdb = dbm.getCfgConnection("scConstruct");
var Schema = mongoose.Schema;

let oprSchema = new Schema({
        operateDate: String,
        operator: String
    },
    {_id: false},
    {versionKey: false});

var RepositoryMapSchema = new Schema({
    "ID": Number,
    "dispName" : String,
    "appType" : String, //如："建筑" / "公路"
    "compilationId": String, //编办
    "compilationName": String,
    "gljLib": Number,
    "descr" : String,
    "creator": String,
    "createDate": String,
    "recentOpr" :[oprSchema],
    "deleted": Boolean
},  {versionKey: false});
var counter = require('../../../public/counter/counter');

var rationRepository = rationLibdb.model("std_ration_lib_map", RepositoryMapSchema, "std_ration_lib_map");

function createNewLibModel(rationLibObj){
    var rst = {};
    rst.dispName = rationLibObj.dispName;
    rst.appType = rationLibObj.appType?rationLibObj.appType:'construct';
    rst.compilationId = rationLibObj.compilationId;
    rst.compilationName = rationLibObj.compilationName;
    rst.gljLib = rationLibObj.gljLib;
    rst.creator = rationLibObj.creator;
    rst.createDate = moment(Date.now()).format('YYYY-MM-DD HH:mm:ss');
    rst.recentOpr = [{operator: rationLibObj.creator, operateDate: rst.createDate}],
    rst.deleted = false;
    return rst;
}

var rationRepositoryDao = function(){};

rationRepositoryDao.prototype.updateGljLib = function (gljLibId, callback) {
    rationRepository.update({gljLib: gljLibId}, {$set: {gljLib: -1}}, {multi: true}, function (err) {
        if(err){
            callback(err);
        }
        else{
            callback(null);
        }
    })
};

rationRepositoryDao.prototype.updateOprArr= function(findSet, oprtor, oprDate, cb){
    rationRepository.find(findSet, function (err, result) {
        if(err){
            cb(err);
        }
        else{
            if(result.length === 1){
                let recentOprArr = result[0].recentOpr;
                let isExist = false;
                for(let i =0 ; i<recentOprArr.length; i++){
                    if(recentOprArr[i].operator === oprtor){
                        recentOprArr[i].operateDate = oprDate;
                        isExist = true;
                    }
                }
                if(!isExist){
                    if(recentOprArr.length < 5){
                        recentOprArr.push({operator: oprtor, operateDate: oprDate});
                    }
                    else if(recentOprArr.length === 5){
                        recentOprArr.sort(function (a, b) {
                            if(a.operateDate > b.operateDate){
                                return -1;
                            }else {
                                return 1;
                            }
                            return 0;
                        });
                        recentOprArr.splice(recentOprArr.length -1, 1);
                        recentOprArr.splice(0, 1, {operator: oprtor, operateDate: oprDate});
                    }
                }
                rationRepository.update(findSet, {$set: {recentOpr: recentOprArr}}, function (err) {
                    if(err){
                        cb(err);
                    }
                    else{
                        cb(null);
                    }
                });
            }
            else{
                cb(err);
            }
        }
    })
};

rationRepositoryDao.prototype.getRealLibName = function(dispName,callback){
    if (callback) {
        rationRepository.find({"dispName": dispName}, function(err,data){
            if (err) {
                callback('Error', null);
            } else {
                callback(false, data);
            }
        });
    } else {
        var rst = rationRepository.find({"dispName": dispName}).exec();
        return rst;
    }
};

rationRepositoryDao.prototype.getLibIDByName = function(dispName, callback){
    rationRepository.findOne({"dispName": dispName}, function(err,data){
        if (err) {
            callback('Error', null);
        } else {
            callback(false, data.ID);
        }
    });
};

rationRepositoryDao.prototype.getRepositoryById = function(repId,callback){
    if (callback) {
        rationRepository.find({"ID": repId}, function(err,data){
            if (err) {
                callback('Error', null);
            } else {
                callback(false, data);
            }
        });
    } else {
        var rst = rationRepository.find({"ID": repId}).exec();
        return rst;
    }
};

rationRepositoryDao.prototype.addRationRepository = function( rationLibObj,callback){
    counter.counterDAO.getIDAfterCount(counter.moduleName.rationMap, 1, function(err, result){
        var rMap = createNewLibModel(rationLibObj);
        rMap.ID = result.value.sequence_value;
        new rationRepository(rMap).save(function(err, result) {
            if (err) callback("Error", null);
            else{
                //向引用工料机库的添加标记
                gljMapModel.update({ID: rMap.gljLib, deleted: false}, {$addToSet: {rationLibs: {ID: rMap.ID, dispName: rMap.dispName}}}, function (err, data) {
                    if(err){
                        rationRepository.remove({ID: rMap.ID}, function (err) {
                            if(err){
                                callback("创建失败且回滚失败！", null);
                            }
                            else{
                                callback("创建失败，已回滚！", null);
                            }
                        });
                    }
                    else{
                        callback(false, result);
                    }
                });
            }
        });
    });
};

rationRepositoryDao.prototype.getRationLib = function(libId, callback) {
    rationRepository.find({ID: libId, "deleted": false}, function(err, data){
        if (err) {
            callback( 'Error', null);
        } else {
            callback( false, data);
        }
    });
};

rationRepositoryDao.prototype.getDisplayRationLibs = function(callback) {
    rationRepository.find({"deleted": false}, function(err, data){
        if (err) {
            callback( 'Error', null);
        } else {
            callback( false, data);
        }
    });
};

rationRepositoryDao.prototype.updateName = function(oprtor, renameObj, callback){
    rationRepository.update({ID: renameObj.ID, deleted: false}, {$set: {dispName: renameObj.newName}}, function (err) {
        if(err){
            callback(err, '重命名失败！');
        }
        else{
            new rationRepositoryDao().updateOprArr({ID: renameObj.ID, deleted: false}, oprtor, moment(Date.now()).format('YYYY-MM-DD HH:mm:ss'), function (err) {
                if(err){
                    callback(err, '更新最近操作者失败！');
                }
                else{
                    callback(null, '成功！');
                }
            });
        }
    });
}

rationRepositoryDao.prototype.deleteRationLib = function(oprtor, libId, callback){
    new rationRepositoryDao().updateOprArr({ID: libId, deleted: false}, oprtor, moment(Date.now()).format('YYYY-MM-DD HH:mm:ss'), function (err) {
        if(err){
            callback(err, '失败!')
        }
        else{
            rationRepository.find({ID: libId, deleted: false}, function (err, result) {
               if(err){
                   callback(err, "没有数据！");
               }
                else{
                   rationRepository.update({ID: libId, deleted: false}, {$set: {deleted: true}}, function (err) {
                       if(err){
                           callback(err, '移除工料机库失败！');
                       }
                       else{
                           //移除工料机库内被引用标记
                           gljMapModel.update({ID: result[0].gljLib, deleted: false}, {$pull: {rationLibs: {ID: libId}}}, function (err) {
                               if(err){
                                   callback(err, '删除引用失败！');
                               }
                               else{
                                   callback(null, '成功！');
                               }
                           });
                       }
                   });
               }
            });
        }
    });
}

module.exports = new rationRepositoryDao();