ConstructionCost/modules/billsLib/billsLibModel/billsLibInterfaces.js

/**
 * Created by vian on 2017/3/20.
 */
var model = require("./billsLibModel");
var counter = require("../../../public/counter/counter");
var StdBillsLib = model.stdBillsLibMod;
var Bills = model.billsMod;
var JobContent = model.jobContentMod;
var ItemCharacter = model.itemCharacterMod;

var fieldArr = ["code", "name", "unit", "ruleText", "Expression"];

var billsLibDao = function(){};

billsLibDao.prototype.getMaxNumber = function(gData, callback){
    var billsLibId = gData.billsLibId;
    var field = gData.field;
    if(field === 'jobs'){
        JobContent.find().sort({code: -1}).limit(1).exec(function(err, result){
            if(err){
                callback(1, 'Error', null);
            }
            else {
                callback(0, '', result.code);
            }
        });
    }
    else if(field === 'items'){
        ItemCharacter.find().sort({code: -1}).limit(1).exec(function(err, result){
            if(err){
                callback(1, 'Error', null);
            }
            else {
                callback(0, '', result.code);
            }
        });
    }
};
//----------StdBillsLib-------------------
billsLibDao.prototype.getStdBillsLib = function(userId, callback){
    StdBillsLib.find({}, "-_id", function(err, data){
        if(err){
            callback(1, "Error", null);
        }
        else{
            callback(0, "", data);
        }
    })
}

billsLibDao.prototype.createStdBillsLib = function(clibData, callback){
    counter.counterDAO.getIDAfterCount(counter.moduleName.bills, 1, function(err, result){
        var billsLibId = result.value.sequence_value;
        var billsLibName = clibData.name;
        var createDate = Date.now();
        var newStdBillsLib = {
            billsLibId: billsLibId,
            billsLibName: billsLibName,
            createDate: createDate
        }
        StdBillsLib.create(newStdBillsLib, function(err){
            if(err){
                callback(1, "Error", null);
            }
            else {
                StdBillsLib.find({billsLibId: billsLibId}, function(err, data){
                    if(err){
                        callback(1, "Error", null)
                    }
                    else {
                        callback(0, "", data);
                    }
                });
            }
        });
    });
}

billsLibDao.prototype.deleteStdBillsLib = function(billsLibId, callback){
    StdBillsLib.remove({billsLibId: billsLibId}, function(err){
        if(err){
            callback(1, "Error");
        }
        else{
            callback(0, "");
        }
    });
}

billsLibDao.prototype.renameStdBillsLib = function(renameData, callback){
    var billsLibId = renameData.id;
    var renameVal = renameData.value;
    StdBillsLib.update({billsLibId: billsLibId}, {$set:{billsLibName: renameVal}}, function(err){
        if(err){
            callback(1, "Error");
        }
        else{
            callback(0, "");
        }
    });
}

billsLibDao.prototype.getStdBillsLibName = function(billsLibId, callback){
    StdBillsLib.find({billsLibId: billsLibId}, "-_id", function(err,  data){
        if(err){
            callback(1, "Error", null);
        }
        else {
            callback(0, "", data);
        }
    });
}
//----------------------------Bills---------------------
billsLibDao.prototype.getBills = function (billsLibId, callback) {
    Bills.find({billsLibId: billsLibId}, "-_id",  function(err, billsData){
        if(err){
            callback(1, "Error", null);
        }
        else{
            callback(0, "", billsData);
        }
    });
}

billsLibDao.prototype.createBills = function(cbillsData, callback){
        var newId = cbillsData.newId;
        var pid = cbillsData.ParentID;
        var nid = cbillsData.NextSiblingID;
        var billsLibId = cbillsData.billsLibId;
        var newBills = {
            ID: newId,
            ParentID: pid,
            NextSiblingID: nid,
            billsLibId: billsLibId,
            code: '',
            name: '',
            unit: '',
            ruleText: '',
            Expression: '',
            recharge:'',
        };
        Bills.create(newBills, function(err){
            if(err){
                callback(1, "Error");
            }
            else{
                callback(0, "");
            }
        });
}

billsLibDao.prototype.updatePNId= function(updateData, callback){
    var billsLibId = updateData.billsLibId;
    var updateId = updateData.updateId;
    var updatepid= updateData.ParentID;
    var updatenid = updateData.NextSiblingID;
    var success = true;
    if(!updatepid){
        Bills.update({billsLibId: billsLibId, ID: updateId}, {$set: {NextSiblingID: updatenid}}, function(err){
            if(err){
                callback(1, "Error")
            }
            else{
                callback(0, "");
            }
        });
    }
    else if(!updatenid){
        updateId.forEach(function(uid){
            Bills.update({billsLibId: billsLibId, ID: uid}, {$set: {ParentID: updatepid}}, function(err){
                if(err){
                    success = false;
                }
            });
        });
        if(!success){
            callback(1, 'Error');
        }
        else {
            callback(0, '');
        }
    }
    else {
        Bills.update({billsLibId: billsLibId, ID: updateId}, {$set: {ParentID: updatepid, NextSiblingID: updatenid}}, function(err){
            if(err){
                callback(1, "Error")
            }
            else{
                callback(0, "");
            }
        });
    }
}

billsLibDao.prototype.updateBills = function(ubillsData, callback){
    var billsLibId = ubillsData.billsLibId;
    var updateId = ubillsData.updateId;
    var updateField = ubillsData.field;
    var updateData = ubillsData.data;
    if(updateField === "code"){
        Bills.update({billsLibId: billsLibId, ID: updateId}, {$set: {code: updateData}}, function(err){
            if(err){
                callback(1, "Error");
            }
            else {
                callback(0, "");
            }
        });
    }
    else if(updateField === "name"){
        Bills.update({billsLibId: billsLibId, ID: updateId}, {$set: {name: updateData}}, function(err){
            if(err){
                callback(1, "Error");
            }
            else {
                callback(0, "");
            }
        });
    }
    else if(updateField === "unit"){
        Bills.update({billsLibId: billsLibId, ID: updateId}, {$set: {unit: updateData}}, function(err){
            if(err){
                callback(1, "Error");
            }
            else {
                callback(0, "");
            }
        });
    }
    else if(updateField === "ruleText"){
        Bills.update({billsLibId: billsLibId, ID: updateId}, {$set: {ruleText: updateData}}, function(err){
            if(err){
                callback(1, "Error");
            }
            else {
                callback(0, "");
            }
        });
    }
    else if(updateField === "jobs"){
        Bills.update({billsLibId: billsLibId, ID: updateId}, {$addToSet: {jobs: updateData}}, function(err){
            if(err){
                callback(1, "Error");
            }
            else {
                callback(0, "");
            }
        });
    }
    else if(updateField === "items"){
        Bills.update({billsLibId: billsLibId, ID: updateId}, {$addToSet: {items: updateData}}, function(err){
            if(err){
                callback(1, "Error");
            }
            else {
                callback(0, "");
            }
        });
    }
}

billsLibDao.prototype.updateBillsArr = function(updateData, callback){
    var billsLibId = updateData.billsLibId;
    var updateId = updateData.updateId;
    var id = updateData.id;
    var data = updateData.data;
    var classify = updateData.classify;
    var success = true;
    if(classify === 'jobs'){
        if(data.id){
            Bills.update({billsLibId: billsLibId, ID: updateId, 'jobs.id': id}, {$set: {'jobs.$.id': data.id}}, function(err){
                if(err){
                    success = false;
                }
            });
        }
        else if(data.code){
            Bills.update({billsLibId: billsLibId, ID: updateId, 'jobs.id': id}, {$set: {'jobs.$.code': data.code}}, function(err){
                if(err){
                    success = false;
                }
            });
        }
        else {
            Bills.update({billsLibId: billsLibId, ID: updateId, 'jobs.id': id}, {$set: {'jobs.$.content': data.content}}, function(err){
                if(err){
                    success =false
                }
            });
        }
       /* if(!success){
            callback(1, 'Error');
        }
        else {
            callback(0, '');
        }*/
    }
    else if(classify === 'items') {
        if(field === 'code'){
            updateIds.forEach(function(updateId){
                Bills.update({billsLibId: billsLibId, ID: updateId, 'items.id': id}, {$set: {'items.$.code': data}}, function(err){
                    if(err){
                        success = false;
                    }
                });
            });
            if(!success){
                callback(1, 'Error');
            }
            else {
                callback(0, '');
            }
        }
        else {
            updateIds.forEach(function(updateId){
                Bills.update({billsLibId: billsLibId, ID: updateId, 'items.id': id}, {$set: {'items.$.content': data}}, function(err){
                    if(err){
                        success = false;
                    }
                });
            });
            if(!success){
                callback(1, 'Error');
            }
            else {
                callback(0, '');
            }
        }
    }
}

billsLibDao.prototype.deleteBills = function(delData, callback){
    var deleteIds = delData.deleteIds;
    var billsLibId = delData.billsLibId;
    if(deleteIds){
        //deleteIds.forEach(function(deleteId){
        Bills.remove({billsLibId: billsLibId, ID: {$in: deleteIds}}, function(err){
            if(err){
                callback(1, 'Error');
            }
            else {
                callback(0, '');
            }
        });
        //  });
    }
}

//--------------JobContent------------------

billsLibDao.prototype.getJobContent = function(gJobData, callback){
    var billsLibId = gJobData.billsLibId;
    JobContent.find({billsLibId: billsLibId}, "-_id", function(err, jobs){
        if(err){
            callback(1, "Error", null);
        }
        else{
            callback(0, "", jobs)
        }
    });
}

billsLibDao.prototype.getSomeJobs = function(gJobData, callback){
    var billsLibId = gJobData.billsLibId;
    var ids = gJobData.ids;
    JobContent.find({billsLibId: billsLibId, id: {$in: ids}}, "-_id", function(err, jobs){
        if(err){
            callback(1, "Error", null);
        }
        else{
            callback(0, "", jobs)
        }
    });
}

billsLibDao.prototype.createJobContent = function(cJobData, callback){
    var field = cJobData.field;
    var data = cJobData.data;
    var billsLibId = cJobData.billsLibId;
    var serialNo = cJobData.serialNo;
    counter.counterDAO.getIDAfterCount(counter.moduleName.bills, 1, function(err, result){
        var id = result.value.sequence_value;
        var newJobContent;
        /*if(field == "code"){
            newJobContent = {
                id: id,
                billsLibId: billsLibId,
                code: data,
                content: ''
            }
        }*/
         if(field == "content"){
            newJobContent = {
                id: id,
                billsLibId: billsLibId,
                code: serialNo,
                content: data,
            }
        }
        JobContent.create(newJobContent, function(err){
            if(err){
                callback(1, "Error", null);
                console.log('error');
            }
            else{
                console.log(id);
                callback(0, "", id);
            }
        });
    });
}

billsLibDao.prototype.updateJobContent = function(uJobData, callback){
    var field = uJobData.field;
    var updateData = uJobData.data;
    var updateid = uJobData.updateId;
    if(field == "code"){
        JobContent.update({id: updateid}, {$set: {code: updateData}}, function(err){
            if(err){
                callback(1, "Error");
            }
            else{
                callback(0, "");
            }
        });
    }
    else if(field == "content"){
        JobContent.update({id: updateid}, {$set: {content: updateData}}, function(err){
            if(err){
                callback(1, "Error");
            }
            else{
                callback(0, "");
            }
        });
    }
}

billsLibDao.prototype.deleteJobContent = function(jobId, callback){
    JobContent.remove({id: jobId}, function(err){
        if(err){
            callback(1, "Error");
        }
        else{
            callback(0, "");
        }
    });
}


//----------------------ItemCharacter---------------------
billsLibDao.prototype.getItemCharacter = function(gdata, callback){
    var billsLibId = gdata.billsLibId;
    ItemCharacter.find({billsLibId: billsLibId}, "-_id", function(err, items){
        if(err){
            callback(1, "Error", null);
        }
        else{
            callback(0, "", items)
        }
    });
}

billsLibDao.prototype.createItemCharacter = function(cItemData, callback){
    var field = cItemData.field;
    var data = cItemData.data;
    var billsLibId = cItemData.billsLibId;
    var newItemCharacter;
    counter.counterDAO.getIDAfterCount(counter.moduleName.bills, 1, function(err, result){
        var id = result.value.sequence_value;
        if(field === 'code'){
            newItemCharacter = {
                id: id,
                billsLibId: billsLibId,
                code: data,
                content: ''
            }
        }
        else if(field === 'content'){
            newItemCharacter = {
                id: id,
                billsLibId: billsLibId,
                content: data,
                code: ''
            }
        }
        ItemCharacter.create(newItemCharacter, function(err){
            if(err){
                callback(1, "Error", null);
            }
            else{
                callback(0, "", id);
            }
        });
    });
}

billsLibDao.prototype.updateItemCharacter = function(uItemData, callback){
    var field = uItemData.field;
    var updateData = uItemData.data;
    var id = uItemData.updateId;
    if(field === "code"){
        ItemCharacter.update({id: id}, {$set: {code: updateData}}, function(err){
            if(err){
                callback(1, "Error");
            }
            else{
                callback(0, "");
            }
        });
    }
    else if(field === "content"){
        ItemCharacter.update({id: id}, {$set: {content: updateData}}, function(err){
            if(err){
                callback(1, "Error");
            }
            else{
                callback(0, "");
            }
        });
    }
}

billsLibDao.prototype.deleteItemCharacter = function(itemId, callback){
    JobContent.remove({id: itemId}, function(err){
        if(err){
            callback(1, "Error");
        }
        else{
            callback(0, "");
        }
    });
}

//----------------------itemValue

//-----------------------------

module.exports = new billsLibDao();