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

let billsLibDao = function(){};


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

/*billsLibDao.prototype.getStdBillsLib = function(data, callback){
    let userId = data.userId;
    StdBillsLib.find({userId: userId, deleted: false}, "-_id", function(err, data){
        if(err){
            callback(1, "Error", null);
        }
        else{
            callback(0, "", data);
        }
    })
};*/
billsLibDao.prototype.getStdBillsLib = function(data, callback){
    let userId = data.userId;
    StdBillsLib.find({userId: userId, deleted: false}, "-_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.billsLib, 1, function(err, result){
        let billsLibId = result.value.sequence_value;
        let userId = clibData.userId;
        let billsLibName = clibData.name;
        let createDate = Date.now();
        let newStdBillsLib = {
            userId: userId,
            billsLibId: billsLibId,
            billsLibName: billsLibName,
            createDate: createDate,
            deleted: false
        };
        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.update({billsLibId: billsLibId}, {$set: {deleted: true}}, function(err){
        if(err){
            callback(1, 'Error');
        }
        else{
            callback(0, '');
        }
    });
};

billsLibDao.prototype.renameStdBillsLib = function(renameData, callback){
    let billsLibId = renameData.id;
    let 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, deleted: false}, "-_id", function(err,  data){
        if(err){
            callback(1, "Error", null);
        }
        else {
            callback(0, "", data);
        }
    });
};

billsLibDao.prototype.getCurrentUniqId = function(callback){
    counter.counterDAO.getCurrentID(counter.moduleName.billsLib, function(result, err){
        let id = result.sequence_value;
        if(err){
            callback(1, 'Error', null);
        }
        else{
            callback(0, '', id);
        }
    });
}
//----------------------------Bills---------------------
billsLibDao.prototype.getBills = function (billsLibId, callback) {
    Bills.find({billsLibId: billsLibId, deleted: false}, "-_id",  function(err, billsData){
        if(err){
            callback(1, "Error", null);
        }
        else{
            callback(0, "", billsData);
        }
    });
}

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

//org
/*billsLibDao.prototype.updatePNId= function(upData, callback){
    let billsLibId = upData.billsLibId;
    let updateDatas = upData.updateData;
    let success = true;
    if(updateDatas.length > 0){
        updateDatas.forEach(function(data){
            if(data.ID.length >1){
                data.ID.forEach(function(id){
                    if(data.ParentID && data.NextSiblingID){
                        Bills.update({billsLibId: billsLibId, ID: id}, {$set: {ParentID: data.ParentID, NextSiblingID: data.NextSiblingID}}, function(err){
                            if(err){
                                callback(1, "Error")
                                success = false;
                            }
                        });
                    }
                    else if(data.ParentID && !data.NextSiblingID){
                        Bills.update({billsLibId: billsLibId, ID: id}, {$set: {ParentID: data.ParentID}}, function(err){
                            if(err){
                                callback(1, 'Error');
                                success = false;
                            }
                        });
                    }
                    else if(!data.ParentID && data.NextSiblingID){
                        Bills.update({billsLibId: billsLibId, ID: id}, {$set: {NextSiblingID: data.NextSiblingID}}, function(err){
                            if(err){
                                callback(1, 'Error');
                                success = false;
                            }
                        });
                    }
                });
            }
            else {
                if(data.ParentID && data.NextSiblingID){
                    Bills.update({billsLibId: billsLibId, ID: data.ID}, {$set: {ParentID: data.ParentID, NextSiblingID: data.NextSiblingID}}, function(err){
                        if(err){
                            callback(1, "Error")
                            success = false;
                        }
                    });
                }
                else if(data.ParentID && !data.NextSiblingID){
                    Bills.update({billsLibId: billsLibId, ID: data.ID}, {$set: {ParentID: data.ParentID}}, function(err){
                        if(err){
                            callback(1, 'Error');
                            success = false;
                        }
                    });
                }
                else if(!data.ParentID && data.NextSiblingID){
                    Bills.update({billsLibId: billsLibId, ID: data.ID}, {$set: {NextSiblingID: data.NextSiblingID}}, function(err){
                        if(err){
                            callback(1, 'Error');
                            success = false;
                        }
                    });
                }
            }
        });
    }
    if(success){
        callback(0, '');
    }
};*/
billsLibDao.prototype.updatePNId= function(upData, callback){
    let billsLibId = upData.billsLibId;
    let updateDatas = upData.updateData;
    let eachDatas = [];
    if(updateDatas.length > 0){
        for(let i=0; i< updateDatas.length; i++){
            if(updateDatas[i].ID.length > 1){
                let ids = updateDatas[i].ID;
                for(let j=0; j<ids.length; j++){
                    let eachObj = {
                        id: ids[j].ID,
                        data: updateDatas[i]
                    }
                    eachDatas.push(eachObj);
                }
            }
            else {
                eachDatas.push({id: updateDatas[i].ID, data: updateDatas[i]});
            }
        }
        async.each(eachDatas, function(eachObj, cb){
            let id = eachObj.id, data = eachObj.data;
            if(data.ParentID && data.NextSiblingID){
                Bills.update({billsLibId: billsLibId, ID: id}, {$set: {ParentID: data.ParentID, NextSiblingID: data.NextSiblingID}}, function(err){
                    if(err){
                        cb(err);
                    }else {
                        cb(null);
                    }
                });
            }
            else if(data.ParentID && !data.NextSiblingID){
                Bills.update({billsLibId: billsLibId, ID: id}, {$set: {ParentID: data.ParentID}}, function(err){
                    if(err){
                        if(err){
                            cb(err);
                        }else {
                            cb(null);
                        }
                    }
                });
            }
            else if(!data.ParentID && data.NextSiblingID){
                Bills.update({billsLibId: billsLibId, ID: id}, {$set: {NextSiblingID: data.NextSiblingID}}, function(err){
                    if(err){
                        cb(err);
                    }else {
                        cb(null);
                    }
                });
            }
        }, function(err){
            if(err){
                callback(1, 'Error');
            }
            else {
                callback(0, '');
            }
        });
    }
}

billsLibDao.prototype.updateBills = function(ubillsData, callback){
    let billsLibId = ubillsData.billsLibId;
    let updateId = ubillsData.updateId;
    let updateField = ubillsData.field;
    let 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, "");
            }
        });
    }
}
//org
/*billsLibDao.prototype.updateBillsArr = function(updateData, callback){
    let billsLibId = updateData.billsLibId;
    let updateId = updateData.updateId;
    let orgId = updateData.orgId;
    let newId = updateData.newId;
    let classify = updateData.classify;
    let type = updateData.type;
    let success = true;
    if(classify === 'jobs'){
        if(orgId && newId && type === 'update'){
            Bills.update({billsLibId: billsLibId, ID: updateId, jobs: orgId}, {$set: {'jobs.$': newId}}, function(err){
                if(err){
                    callback(1, 'Error');
                }
                else {
                    callback(0, '');
                }
            });
        }
        if(orgId && !newId && type === 'delete'){
            orgId.forEach(function(oid){
                Bills.update({billsLibId: billsLibId, ID: updateId}, {$pull: {jobs: oid}}, function(err){
                    if(err){
                        callback(1, 'Error');
                    }
                });
            });
        }
        //todo: test
        if(orgId && !newId && type === 'deleteAll'){
            updateId.forEach(function(uid){
                orgId.forEach(function(oid){
                    Bills.update({billsLibId: billsLibId, ID: uid}, {$pull: {jobs: oid}}, function(err){
                        if(err){
                            callback(1, 'Error');
                        }
                    });
                });
            });
        }
    }
    else if(classify === 'items'){
        if(orgId && newId && type === 'update'){
            Bills.update({billsLibId: billsLibId, ID: updateId, items: orgId}, {$set: {'items.$': newId}}, function(err){
                if(err){
                    callback(1, 'Error');
                }
                else {
                    callback(0, '');
                }
            });
        }
        if(orgId && !newId && type === 'delete'){
            orgId.forEach(function(oid){
                Bills.update({billsLibId: billsLibId, ID: updateId}, {$pull: {items: oid}}, function(err){
                    if(err){
                        callback(1, 'Error');
                    }
                });
            });
        }
        if(orgId && !newId &&  type === 'deleteAll'){
            updateId.forEach(function(uid){
                orgId.forEach(function(oid){
                    Bills.update({billsLibId: billsLibId, ID: uid}, {$pull: {items: oid}}, function(err){
                        if(err){
                            callback(1, 'Error');
                        }
                    });
                });
            });
        }
    }
};*/
billsLibDao.prototype.updateBillsArr = function(updateData, callback){
    let billsLibId = updateData.billsLibId;
    let updateId = updateData.updateId;
    let orgId = updateData.orgId;
    let newId = updateData.newId;
    let classify = updateData.classify;
    let type = updateData.type;
    let success = true;
    if(classify === 'jobs'){
        if(orgId && newId && type === 'update'){
            Bills.update({billsLibId: billsLibId, ID: updateId, jobs: orgId}, {$set: {'jobs.$': newId}}, function(err){
                if(err){
                    callback(1, 'Error');
                }
                else {
                    callback(0, '');
                }
            });
        }
        if(orgId && !newId && type === 'delete'){
            async.each(orgId, function(oid, cb){
                Bills.update({billsLibId: billsLibId, ID: updateId}, {$pull: {jobs: oid}}, function(err){
                    if(err){
                        cb(err);
                    }else {
                        cb(null);
                    }
                });
            }, function(err){
                if(err){
                    callback(1, 'Error');
                }
            });
        }
        //todo: test
        if(orgId && !newId && type === 'deleteAll'){
            let delArr = [];
            updateId.forEach(function(uid){
                orgId.forEach(function(oid){
                    delArr.push({updateId: uid, delId: oid});
                });
            });
            async.each(delArr, function(delObj, cb){
                Bills.update({billsLibId: billsLibId, ID: delObj.updateId}, {$pull: {jobs: delObj.delId}}, function(err){
                    if(err){
                        cb(err);
                    }else {
                        cb(null);
                    }
                });
            }, function(err){
                if(err){
                    callback(1, 'Error');
                }else {
                    callback(0, '');
                }
            });

        }
    }
    else if(classify === 'items'){
        if(orgId && newId && type === 'update'){
            Bills.update({billsLibId: billsLibId, ID: updateId, items: orgId}, {$set: {'items.$': newId}}, function(err){
                if(err){
                    callback(1, 'Error');
                }
                else {
                    callback(0, '');
                }
            });
        }
        if(orgId && !newId && type === 'delete'){
            async.each(orgId, function(oid, cb){
                Bills.update({billsLibId: billsLibId, ID: updateId}, {$pull: {items: oid}}, function(err){
                    if(err){
                        cb(err);
                    }else {
                        cb(null);
                    }
                });
            }, function(err){
                if(err){
                    callback(1, 'Error');
                }else {
                    callback(0, '');
                }
            });
        }
        if(orgId && !newId &&  type === 'deleteAll'){
            let delArr = [];
            updateId.forEach(function(uid){
                orgId.forEach(function(oid){
                    delArr.push({updateId: uid, delId: oid});
                });
            });
            async.each(delArr, function(delObj, cb){
                Bills.update({billsLibId: billsLibId, ID: delObj.updateId}, {$pull: {items: delObj.delId}}, function(err){
                    if(err){
                        cb(err);
                    }else {
                        cb(null);
                    }
                });
            }, function(err){
                if(err){
                    callback(1, 'Error');
                }else {
                    callback(0, '');
                }
            });
        }
    }
};
//org
/*billsLibDao.prototype.pasteBills = function(pData, callback){
    let datas = pData.datas;
    datas.forEach(function(data){
        Bills.update({billsLibId: data.billsLibId, ID: data.ID}, {$set: {code: data.code, name: data.name, unit: data.unit, ruleText: data.ruleText}}, function(err){
            if(err){
                callback(1, 'Error');
            }
        });
    });
}*/
billsLibDao.prototype.pasteBills = function(pData, callback){
    let datas = pData.datas;
    async.each(datas, function(data, cb){
        Bills.update({billsLibId: data.billsLibId, ID: data.ID}, {$set: {code: data.code, name: data.name, unit: data.unit, ruleText: data.ruleText}}, function(err){
            if(err){
                cb(err);
            }else {
                cb(null);
            }
        });
    }, function(err){
        if(err){
            callback(1, 'Error');
        }else {
            callback(0, '');
        }
    });
}
//org
/*billsLibDao.prototype.updateRecharge = function(uData, callback){
    let billsLibId = uData.billsLibId;
    let updateIds = uData.updateIds;
    let data = uData.data;
    let success = true;
    updateIds.forEach(function(id){
        Bills.update({billsLibId: billsLibId, ID: id}, {$set: {recharge: data}}, function(err){
            if(err){
                callback(1, 'Error');
                success = false;
            }
        });
    });
    if(success){
        callback(0, '');
    }
};*/
billsLibDao.prototype.updateRecharge = function(uData, callback){
    let billsLibId = uData.billsLibId;
    let updateIds = uData.updateIds;
    let data = uData.data;
    async.each(updateIds, function(id, cb){
        Bills.update({billsLibId: billsLibId, ID: id}, {$set: {recharge: data}}, function(err){
            if(err){
                cb(err);
            }else {
                cb(null);
            }
        });
    }, function(err){
        if(err){
            callback(1, 'Error');
        }else {
            callback(0, '');
        }
    });

};
//org
/*billsLibDao.prototype.pasteRel = function (data, callback) {
    const UpdateExist = 'updateExist', UpdateNew = 'updateNew', CreateExist = 'createExist', CreateNew = 'createNew';
    const Jobs = 'jobs', Items = 'items';
    let success = true;
    let field = data.field;
    let updateDatas = data.updateDatas;
    let createDatas = data.createDatas;
    if(field === Jobs){
        if(updateDatas.length > 0){
            for(let i=0; i<updateDatas.length; i++){
                if(updateDatas[i].type === UpdateExist){
                    let orgJobId = updateDatas[i].orgJobId, newJobId = updateDatas[i].newJobId,
                        nodeId = updateDatas[i].nodeId, billsLibId = updateDatas[i].billsLibId, newData = updateDatas[i].newData;
                    if(orgJobId && newJobId && nodeId && billsLibId){
                        Bills.update({billsLibId: billsLibId, ID: nodeId, jobs: orgJobId}, {$set: {'jobs.$': newJobId}}, function(err){
                            if(err){
                                success = false;
                            }
                            else{
                            }
                        });
                    }

                }
                if(updateDatas[i].type === UpdateNew){
                    let billsLibId = updateDatas[i].billsLibId, nodeId = updateDatas[i].nodeId, newData = updateDatas[i].newData,
                        orgJobId = updateDatas[i].orgJobId, code = updateDatas[i].code, id = updateDatas[i].newJobId;
                    if(billsLibId && nodeId && newData && orgJobId && code && id){
                        let newJobContent;
                        newJobContent = {
                            id: id,
                            billsLibId: billsLibId,
                            code: code,
                            content: newData,
                            deleted: false
                        }
                        JobContent.create(newJobContent, function(err){
                            if(err){
                                success = false;
                            }
                            else{
                                Bills.update({billsLibId: billsLibId, ID: nodeId, jobs: orgJobId}, {$set: {'jobs.$': id}}, function(err){
                                    if(err){
                                        success = false;
                                    }
                                    else{
                                    }
                                });
                            }
                        });
                    }

                }
            }
        }
        if(createDatas.length > 0){
            for(let i=0; i<createDatas.length; i++){
                if(createDatas[i].type === CreateExist){
                    let billsLibId = createDatas[i].billsLibId, newData = createDatas[i].newData,
                        nodeId = createDatas[i].nodeId, jobId = createDatas[i].jobId;
                    if(billsLibId && newData && nodeId && jobId){
                        Bills.update({billsLibId: billsLibId, ID: nodeId}, {$addToSet: {jobs: jobId}}, function(err){
                            if(err){
                                success = false;
                            }
                            else {
                            }
                        });
                    }
                }
                if(createDatas[i].type === CreateNew){
                    let billsLibId = createDatas[i].billsLibId, newData = createDatas[i].newData,
                        code = createDatas[i].code, nodeId = createDatas[i].nodeId, id = createDatas[i].id;
                    if(billsLibId && newData && code && id){
                        let newJobContent;
                        newJobContent = {
                            id: id,
                            billsLibId: billsLibId,
                            code: code,
                            content: newData,
                            deleted: false
                        }
                        JobContent.create(newJobContent, function(err){
                            if(err){
                                success = false;
                            }
                            else{
                                Bills.update({billsLibId: billsLibId, ID: nodeId}, {$addToSet: {jobs: id}}, function(err){
                                    if(err){
                                        success = false;
                                    }
                                    else {

                                    }
                                });
                            }
                        });

                    }
                }
            }
        }

    }
    if(field === Items){
        if(updateDatas.length > 0){
            for(let i=0; i<updateDatas.length; i++){
                if(updateDatas[i].type === UpdateExist){
                    let orgItemId = updateDatas[i].orgItemId, newItemId = updateDatas[i].newItemId,
                        nodeId = updateDatas[i].nodeId, billsLibId = updateDatas[i].billsLibId, newData = updateDatas[i].newData;
                    if(orgItemId && newItemId && nodeId && billsLibId){
                        Bills.update({billsLibId: billsLibId, ID: nodeId, items: orgItemId}, {$set: {'items.$': newItemId}}, function(err){
                            if(err){
                                success = false;
                            }
                            else{
                            }
                        });
                    }

                }
                if(updateDatas[i].type === UpdateNew){
                    let billsLibId = updateDatas[i].billsLibId, nodeId = updateDatas[i].nodeId, newData = updateDatas[i].newData,
                        orgItemId = updateDatas[i].orgItemId, code = updateDatas[i].code, id = updateDatas[i].newItemId;
                    if(billsLibId && nodeId && newData && orgItemId && code && id){
                        let newItemContent;
                        newItemContent = {
                            id: id,
                            billsLibId: billsLibId,
                            code: code,
                            content: newData,
                            deleted: false
                        }
                        ItemCharacter.create(newItemContent, function(err){
                            if(err){
                                success = false;
                            }
                            else{
                                Bills.update({billsLibId: billsLibId, ID: nodeId, items: orgItemId}, {$set: {'items.$': id}}, function(err){
                                    if(err){
                                        success = false;
                                    }
                                    else{
                                    }
                                });
                            }
                        });
                    }

                }
            }
        }
        if(createDatas.length > 0){
            for(let i=0; i<createDatas.length; i++){
                if(createDatas[i].type === CreateExist){
                    let billsLibId = createDatas[i].billsLibId, newData = createDatas[i].newData,
                        nodeId = createDatas[i].nodeId, itemId = createDatas[i].itemId;
                    if(billsLibId && newData && nodeId && itemId){
                        Bills.update({billsLibId: billsLibId, ID: nodeId}, {$addToSet: {items: itemId}}, function(err){
                            if(err){
                                success = false;
                            }
                            else {
                            }
                        });
                    }
                }
                if(createDatas[i].type === CreateNew){
                    let billsLibId = createDatas[i].billsLibId, newData = createDatas[i].newData,
                        code = createDatas[i].code, nodeId = createDatas[i].nodeId, id = createDatas[i].id;
                    if(billsLibId && newData && code && id){
                        let newItemContent;
                        newItemContent = {
                            id: id,
                            billsLibId: billsLibId,
                            code: code,
                            content: newData,
                            deleted: false
                        }
                        ItemCharacter.create(newItemContent, function(err){
                            if(err){
                                success = false;
                            }
                            else{
                                Bills.update({billsLibId: billsLibId, ID: nodeId}, {$addToSet: {items: id}}, function(err){
                                    if(err){
                                        success = false;
                                    }
                                    else {

                                    }
                                });
                            }
                        });

                    }
                }
            }
        }

    }
    callback(0, '');
};*/
billsLibDao.prototype.pasteRel = function (data, callback) {
    const UpdateExist = 'updateExist', UpdateNew = 'updateNew', CreateExist = 'createExist', CreateNew = 'createNew';
    const Jobs = 'jobs', Items = 'items';
    let success = true;
    let field = data.field;
    let updateDatas = data.updateDatas;
    let createDatas = data.createDatas;
    let functions = [];
    let parallelFucs = {
        updateExJobs: function(data){
            let orgJobId = data.orgJobId, newJobId = data.newJobId,
                nodeId = data.nodeId, billsLibId = data.billsLibId;
            return function (cb){
                if(orgJobId && newJobId && nodeId && billsLibId){
                    Bills.update({billsLibId: billsLibId, ID: nodeId, jobs: orgJobId}, {$set: {'jobs.$': newJobId}}, function(err){
                        if(err){
                            cb(err);
                        }
                        else{
                            cb(null, data)
                        }
                    });
                }
            }
        },
        updateNeJobs: function(data){
            let billsLibId = data.billsLibId, nodeId = data.nodeId, newData = data.newData,
                orgJobId = data.orgJobId, code = data.code;
            return function (cb){
                if(billsLibId && nodeId && newData && orgJobId && code){
                    counter.counterDAO.getIDAfterCount(counter.moduleName.billsLib_jobs, 1, function(err, result){
                        if(err){
                            cb(err);
                        }
                        else {
                            let newJobId = result.value.sequence_value;
                            let newJobContent = {
                                id: newJobId,
                                billsLibId: billsLibId,
                                code: code,
                                content: newData,
                                deleted: false
                            };
                            JobContent.create(newJobContent, function(err){
                                if(err){
                                    cb(err);
                                }
                                else{
                                    Bills.update({billsLibId: billsLibId, ID: nodeId, jobs: orgJobId}, {$set: {'jobs.$': newJobId}}, function(err){
                                        if(err){
                                            cb(err);
                                        }
                                        else{
                                            data.newJobId = newJobId;
                                            cb(null, data);
                                        }
                                    });
                                }
                            });

                        }
                    });
                }
            }

        },
        createExJobs: function(data){
            let billsLibId = data.billsLibId, newData = data.newData,
                nodeId = data.nodeId, jobId = data.jobId;
            return function (cb){
                if(billsLibId && newData && nodeId && jobId){
                    Bills.update({billsLibId: billsLibId, ID: nodeId}, {$addToSet: {jobs: jobId}}, function(err){
                        if(err){
                            cb(err);
                        }
                        else {
                            cb(null, data);
                        }
                    });
                }
            }
        },
        createNeJobs: function(data){
            let billsLibId = data.billsLibId, newData = data.newData,
                code = data.code, nodeId = data.nodeId;
            return function (cb){
                if(billsLibId && newData && code){
                    counter.counterDAO.getIDAfterCount(counter.moduleName.billsLib_jobs, 1, function(err, result){
                        if(err){
                            cb(err);
                        }
                        else {
                            let newJobId = result.value.sequence_value;
                            let newJobContent = {
                                id: newJobId,
                                billsLibId: billsLibId,
                                code: code,
                                content: newData,
                                deleted: false
                            };
                            JobContent.create(newJobContent, function(err){
                                if(err){
                                    cb(err);
                                }
                                else{
                                    Bills.update({billsLibId: billsLibId, ID: nodeId}, {$addToSet: {jobs: newJobId}}, function(err){
                                        if(err){
                                            cb(err);
                                        }
                                        else {
                                            data.newJobId = newJobId;
                                            cb(null, data);
                                        }
                                    });
                                }
                            });
                        }
                    });
                }
            }
        },
        updateExItems: function(data){
            let orgItemId = data.orgItemId, newItemId = data.newItemId,
                nodeId = data.nodeId, billsLibId = data.billsLibId, newData = data.newData;
            return function (cb){
                if(orgItemId && newItemId && nodeId && billsLibId){
                    Bills.update({billsLibId: billsLibId, ID: nodeId, items: orgItemId}, {$set: {'items.$': newItemId}}, function(err){
                        if(err){
                            cb(err);
                        }
                        else{
                            cb(null, data);
                        }
                    });
                }
            }
        },
        updateNeItems: function(data){
            let billsLibId = data.billsLibId, nodeId = data.nodeId, newData = data.newData,
                orgItemId = data.orgItemId, code = data.code;
            return function (cb){
                if(billsLibId && nodeId && newData && orgItemId && code){
                    counter.counterDAO.getIDAfterCount(counter.moduleName.billsLib_items, 1, function(err, result){
                        if(err){
                            cb(err);
                        }
                        else {
                            let newItemId = result.value.sequence_value;
                            let newItemContent = {
                                id: newItemId,
                                billsLibId: billsLibId,
                                code: code,
                                content: newData,
                                deleted: false
                            };
                            ItemCharacter.create(newItemId, function(err){
                                if(err){
                                    cb(err);
                                }
                                else{
                                    Bills.update({billsLibId: billsLibId, ID: nodeId, items: orgItemId}, {$set: {'items.$': newItemId}}, function(err){
                                        if(err){
                                            cb(err);
                                        }
                                        else{
                                            data.newItemId = newItemId;
                                            cb(null, data);
                                        }
                                    });
                                }
                            });
                        }
                    });
                }
            }
        },
        createExItems: function(data){
            let billsLibId = data.billsLibId, newData = data.newData,
                nodeId = data.nodeId, itemId = data.itemId;
            return function (cb){
                if(billsLibId && newData && nodeId && itemId){
                    Bills.update({billsLibId: billsLibId, ID: nodeId}, {$addToSet: {items: itemId}}, function(err){
                        if(err){
                            cb(err);
                        }
                        else {
                            cb(null, data);
                        }
                    });
                }
            }
        },
        createNeItems: function(data){
            let billsLibId = data.billsLibId, newData = data.newData,
                code = data.code, nodeId = data.nodeId, id = data.id;
            return function (cb){
                if(billsLibId && newData && code && id){
                    counter.counterDAO.getIDAfterCount(counter.moduleName.billsLib_items, 1, function(err, result){
                        if(err){
                            cb(err);
                        }
                        else {
                            let newItemId = result.value.sequence_value;
                            let newItemContent = {
                                id: newItemId,
                                billsLibId: billsLibId,
                                code: code,
                                content: newData,
                                deleted: false
                            };
                            ItemCharacter.create(newItemContent, function(err){
                                if(err){
                                    cb(err);
                                }
                                else{
                                    Bills.update({billsLibId: billsLibId, ID: nodeId}, {$addToSet: {items: newItemId}}, function(err){
                                        if(err){
                                            cb(err);
                                        }
                                        else {
                                            data.newItemId = newItemId;
                                            cb(null, data);
                                        }
                                    });
                                }
                            });
                        }
                    });
                }
            }
        }
    };
    if(field === Jobs){
        if(updateDatas.length > 0){
            for(let i=0; i<updateDatas.length; i++){
                if(updateDatas[i].type === UpdateExist){
                    functions.push(parallelFucs.updateExJobs(updateDatas[i]));
                }
                if(updateDatas[i].type === UpdateNew){
                    functions.push(parallelFucs.updateNeJobs(updateDatas[i]));
                }
            }
        }
        if(createDatas.length > 0){
            for(let i=0; i<createDatas.length; i++){
                if(createDatas[i].type === CreateExist){
                    functions.push(parallelFucs.createExJobs(createDatas[i]));
                }
                if(createDatas[i].type === CreateNew){
                    functions.push(parallelFucs.createNeJobs(createDatas[i]));
                }
            }
        }
    }
    if(field === Items){
        if(updateDatas.length > 0){
            for(let i=0; i<updateDatas.length; i++){
                if(updateDatas[i].type === UpdateExist){
                    functions.push(parallelFucs.updateExItems(updateDatas[i]));
                }
                if(updateDatas[i].type === UpdateNew){
                    functions.push(parallelFucs.updateNeItems(updateDatas[i]));
                }
            }
        }
        if(createDatas.length > 0){
            for(let i=0; i<createDatas.length; i++){
                if(createDatas[i].type === CreateExist){
                    functions.push(parallelFucs.createExItems(createDatas[i]));
                }
                if(createDatas[i].type === CreateNew){
                    functions.push(parallelFucs.createNeItems(createDatas[i]));
                }
            }
        }

    }
    async.parallel(functions, function(err, datas){
        if(err){
            callback(1, 'Error', null);
        }else {
            callback(0, '', datas);
        }
    });
};
//org
/*billsLibDao.prototype.deleteBills = function(delData, callback){
    let deleteIds = delData.deleteIds;
    let billsLibId = delData.billsLibId;
    let success = true;
    if(deleteIds){
        deleteIds.forEach(function(delId){
            Bills.update({billsLibId: billsLibId, ID: delId}, {$set: {deleted: true}}, function(err){
                if(err){
                    success = false;
                    callback(1, 'Error');
                }
            });
        });
        if(success){
            callback(0, '');
        }
    }
}*/
billsLibDao.prototype.deleteBills = function(delData, callback){
    let deleteIds = delData.deleteIds;
    let billsLibId = delData.billsLibId;
    if(deleteIds){
        async.each(deleteIds, function(delId, cb){
            Bills.update({billsLibId: billsLibId, ID: delId}, {$set: {deleted: true}}, function(err){
                if(err){
                    cb(err);
                }
            });
        }, function(err){
            if(err){
                callback(1, 'Error');
            }
            else {
                callback(0, '');
            }
        });
    }
}

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

billsLibDao.prototype.getJobContent = function(gJobData, callback){
    let billsLibId = gJobData.billsLibId;
    JobContent.find({billsLibId: billsLibId, deleted: false}, '-_id').sort({code: 1}).exec(function(err, result){
        if(err){
            callback(1, 'Error', null);
        }
        else {
            callback(0, '', result);
        }
    });
}

billsLibDao.prototype.createJobContent = function(cJobData, callback){
    let data = cJobData.data;
    let billsLibId = cJobData.billsLibId;
    let serialNo = cJobData.serialNo;
    let id = cJobData.id;
    let newJobContent;
    newJobContent = {
        id: id,
        billsLibId: billsLibId,
        code: serialNo,
        content: data,
        deleted: false
    }
    JobContent.create(newJobContent, function(err){
        if(err){
            callback(1, "Error", null);
        }
        else{
            callback(0, "", id);
        }
    });

};

billsLibDao.prototype.updateJobContent = function(uJobData, callback){
    let billsLibId = uJobData.billsLibId;
    let field = uJobData.field;
    let updateData = uJobData.data;
    let updateid = uJobData.updateId;
    if(field == "code"){
        JobContent.update({billsLibId: billsLibId, id: updateid}, {$set: {code: updateData}}, function(err){
            if(err){
                callback(1, "Error");
            }
            else{
                callback(0, "");
            }
        });
    }
    else if(field == "content"){
        JobContent.update({billsLibId: billsLibId, id: updateid}, {$set: {content: updateData}}, function(err){
            if(err){
                callback(1, "Error");
            }
            else{
                callback(0, "");
            }
        });
    }
};
//org
/*billsLibDao.prototype.deleteJobContent = function(data, callback){
    let delIds = data.ids;
    let billsLibId = data.billsLibId;
    let success = true;
    delIds.forEach(function(id){
        JobContent.update({billsLibId: billsLibId, id: id}, {$set: {deleted: true}}, function(err,result){
            if(err){
                success = false;
                callback(1, 'Error');
            }
            else {
            }
        });
    });
}*/
billsLibDao.prototype.deleteJobContent = function(data, callback){
    let delIds = data.ids;
    let billsLibId = data.billsLibId;
    if(delIds){
        async.each(delIds, function(id, cb){
            JobContent.update({billsLibId: billsLibId, id: id}, {$set: {deleted: true}}, function(err){
                if(err){
                    cb(err);
                }
                else {
                    cb(null);
                }
            });
        }, function(err){
            if(err){
                callback(1, 'Error');
            }else {
                callback(0, '');
            }
        });
    }
}
//org
/*billsLibDao.prototype.pasteJobs = function (data, callback) {
    let pasteDatas = data.pasteDatas;
    let updateDatas = pasteDatas.updateDatas,
        createDatas = pasteDatas.createDatas;
    if(updateDatas.length > 0){
        for(let i=0; i<updateDatas.length; i++){
            let updateId = updateDatas[i].orgId,
                field = updateDatas[i].field,
                updateData = updateDatas[i].data, billsLibId = updateDatas[i].billsLibId;
            if(field === 'code'){
                JobContent.update({billsLibId: billsLibId, id: updateId}, {$set: {code: updateData}}, function(err){
                    if(err){

                    }
                });
            }
            else{
                JobContent.update({billsLibId: billsLibId, id: updateId}, {$set: {content: updateData}}, function(err){
                    if(err){

                    }
                });
            }
        }
    }
    if(createDatas.length > 0){
        for(let i =0; i<createDatas.length; i++){
            let billsLibId = createDatas[i].billsLibId, id = createDatas[i].id,
                code , content;
            let jobObj;
            if(createDatas[i].type === 'CreateT'){
                jobObj = {
                    billsLibId: billsLibId,
                    id: id,
                    code: createDatas[i].code,
                    content: createDatas[i].content,
                    deleted: false
                }
            }
            else{
                if(createDatas[i].field === 'code'){
                    jobObj = {
                        billsLibId: billsLibId,
                        id: id,
                        code: createDatas[i].data,
                        content: '',
                        deleted: false
                    }
                }
                else {
                    jobObj = {
                        billsLibId: billsLibId,
                        id: id,
                        code: createDatas[i].code,
                        content: createDatas[i].data,
                        deleted: false
                    }
                }
            }
            JobContent.create(jobObj, function(err){
                if(err){

                }
            });
        }
    }
}*/
billsLibDao.prototype.pasteJobs = function (data, callback) {
    let pasteDatas = data.pasteDatas;
    let updateDatas = pasteDatas.updateDatas,
        createDatas = pasteDatas.createDatas;
    let functions = [];
    let parallelFucs = {
        updateFuc: function(data){
            let updateId = data.orgId,
                field = data.field,
                updateData = data.data, billsLibId = data.billsLibId;
            if(field === 'code'){
                return function (cb){
                    JobContent.update({billsLibId: billsLibId, id: updateId}, {$set: {code: updateData}}, function(err){
                        if(err){
                            cb(err);
                        }else {
                            cb(null, data);
                        }
                    });
                };
            }else {
                return function (cb){
                    JobContent.update({billsLibId: billsLibId, id: updateId}, {$set: {content: updateData}}, function(err){
                        if(err){
                            cb(err);
                        }else {
                            cb(null, data);
                        }
                    });
                }
            }
        },
        createFuc: function(data){
            let billsLibId = data.billsLibId,
                code;
            let jobObj;
            if(data.type === 'CreateT'){
                jobObj = {
                    billsLibId: billsLibId,
                    code: data.code,
                    content: data.content,
                    deleted: false
                }
            }
            else{
                if(data.field === 'code'){
                    jobObj = {
                        billsLibId: billsLibId,
                        code: data.data,
                        content: '',
                        deleted: false
                    }
                }
                else {
                    jobObj = {
                        billsLibId: billsLibId,
                        code: data.code,
                        content: data.data,
                        deleted: false
                    }
                }
            }
            return function (cb){
                counter.counterDAO.getIDAfterCount(counter.moduleName.billsLib_jobs, 1, function(err, result){
                    if(err){
                        cb(err);
                    }
                    else {
                        let newJobId = result.value.sequence_value;
                        jobObj.id = newJobId;
                        data.newJobId = newJobId
                        JobContent.create(jobObj, function(err){
                            if(err){
                                cb(err);
                            }else {
                                cb(null, data);
                            }
                        });
                    }
                });
            }
        }
    };
    if(updateDatas.length > 0){
        for(let i=0; i<updateDatas.length; i++){
            functions.push(parallelFucs.updateFuc(updateDatas[i]));
        }
    }
    if(createDatas.length > 0){
        for(let i =0; i<createDatas.length; i++){
            functions.push(parallelFucs.createFuc(createDatas[i]));
        }
    }
    async.parallel(functions, function(err, datas){
        if(err){
            callback(1, 'Error', null);
        }else {
            callback(0, '', datas);
        }
    });
};
//----------------------ItemCharacter---------------------
billsLibDao.prototype.getItemCharacter = function(gdata, callback){
    let billsLibId = gdata.billsLibId;
    ItemCharacter.find({billsLibId: billsLibId, deleted: false}, '-_id').sort({code: 1}).exec(function(err, result){
        if(err){
            callback(1, 'Error', null);
        }
        else {
            callback(0, '', result);
        }
    });
}

billsLibDao.prototype.createItemCharacter = function(cItemData, callback){
    let data = cItemData.data;
    let billsLibId = cItemData.billsLibId;
    let serialNo = cItemData.serialNo;
    let newItemCharacter;
    let id = cItemData.id;
    newItemCharacter = {
        id: id,
        billsLibId: billsLibId,
        content: data,
        code: serialNo,
        deleted: false
    }
    ItemCharacter.create(newItemCharacter, function(err){
        if(err){
            callback(1, "Error", null);
        }
        else{
            callback(0, "", id);
        }
    });
};

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

billsLibDao.prototype.updateValue = function(uData, callback){
    let type = uData.type;
    let updateId = uData.updateId;
    let data = uData.data;
    let deleteCodes = uData.deleteCodes;
    let billsLibId = uData.billsLibId;
    if(type === 'create'){
        ItemCharacter.update({billsLibId: billsLibId, id: updateId}, {$addToSet: {itemValue: data}}, function(err){
            if(err){
                callback(1, 'Error');
            }
            else{
                callback(0, '');
            }
        });
    }
    else if(type === 'update'){
        if(data.field === 'code'){
            ItemCharacter.update({billsLibId: billsLibId, id: updateId,  'itemValue.code': data.code}, {$set: {'itemValue.$.code': data.newData}}, function(err){
                if(err){
                    callback(1, 'Error');
                }
                else{
                    callback(0, '');
                }
            });
        }
        else {
            ItemCharacter.update({billsLibId: billsLibId, id: updateId,  'itemValue.code': data.code}, {$set: {'itemValue.$.value': data.newData}}, function(err,result){
                if(err){
                    callback(1, 'Error');
                }
                else{
                    console.log(`suc`);
                    console.log(result);
                    callback(0, '');
                }
            });
        }
    }
    //delete
    else {
        if(deleteCodes.length > 0){
            async.each(deleteCodes, function(code, cb){
                ItemCharacter.update({billsLibId: billsLibId, id: updateId}, {$pull: {itemValue: {code: code}}}, function(err){
                    if(err){
                        cb(err);
                    }else {
                        cb(null);
                    }
                });
            }, function(err){
                if(err){
                    callback(1, 'Error');
                }else {
                    callback(0, '');
                }
            });
        }
    }
};
//org
/*billsLibDao.prototype.deleteItemCharacter = function(data, callback){
    let delIds = data.ids;
    let billsLibId = data.billsLibId;
    delIds.forEach(function(id){
        ItemCharacter.update({billsLibId: billsLibId, id: id}, {$set: {deleted: true}}, function(err){
            if(err){
                callback(1, 'Error');
            }
        });
    });
}*/
billsLibDao.prototype.deleteItemCharacter = function(data, callback){
    let delIds = data.ids;
    let billsLibId = data.billsLibId;
    if(delIds){
        async.each(delIds, function(id, cb){
            ItemCharacter.update({billsLibId: billsLibId, id: id}, {$set: {deleted: true}}, function(err){
                if(err){
                    cb(err);
                }else {
                    cb(null);
                }
            }, function(err){
                if(err){
                    callback(1, 'Error');
                }else {
                    callback(0, '');
                }
            });
        });
    }
};

//org
/*billsLibDao.prototype.pasteItems = function (data, callback) {
    let pasteDatas = data.pasteDatas;
    let updateDatas = pasteDatas.updateDatas,
        createDatas = pasteDatas.createDatas;
    if(updateDatas.length > 0){
        for(let i=0; i<updateDatas.length; i++){
            let updateId = updateDatas[i].orgId,
                field = updateDatas[i].field,
                updateData = updateDatas[i].data, billsLibId = updateDatas[i].billsLibId;
            if(field === 'code'){
                ItemCharacter.update({billsLibId: billsLibId, id: updateId}, {$set: {code: updateData}}, function(err){
                    if(err){

                    }
                });
            }
            else{
                ItemCharacter.update({billsLibId: billsLibId, id: updateId}, {$set: {content: updateData}}, function(err){
                    if(err){

                    }
                });
            }
        }
    }
    if(createDatas.length > 0){
        for(let i =0; i<createDatas.length; i++){
            let billsLibId = createDatas[i].billsLibId, id = createDatas[i].id,
                code , content;
            let itemObj;

            if(createDatas[i].type === 'CreateT'){
                itemObj = {
                    billsLibId: billsLibId,
                    id: id,
                    code: createDatas[i].code,
                    content: createDatas[i].content,
                    deleted: false
                }
            }
            else{
                if(createDatas[i].field === 'code'){
                    itemObj = {
                        billsLibId: billsLibId,
                        id: id,
                        code: createDatas[i].data,
                        content: '',
                        deleted: false
                    }
                }
                else {
                    itemObj = {
                        billsLibId: billsLibId,
                        id: id,
                        code: createDatas[i].code,
                        content: createDatas[i].data,
                        deleted: false
                    }
                }
            }
            ItemCharacter.create(itemObj, function(err){
                if(err){

                }
            });
        }
    }

};*/
billsLibDao.prototype.pasteItems = function (data, callback) {
    let pasteDatas = data.pasteDatas;
    let updateDatas = pasteDatas.updateDatas,
        createDatas = pasteDatas.createDatas;
    let functions = [];
    let parallelFucs = {
        updateFuc: function(data){
            let updateId = data.orgId,
                field = data.field,
                updateData = data.data, billsLibId = data.billsLibId;
            if(field === 'code'){
                return function (cb){
                    ItemCharacter.update({billsLibId: billsLibId, id: updateId}, {$set: {code: updateData}}, function(err){
                        if(err){
                            cb(err);
                        }else {
                            cb(null, data);
                        }
                    });
                };
            }
            else{
                return function(cb){
                    ItemCharacter.update({billsLibId: billsLibId, id: updateId}, {$set: {content: updateData}}, function(err){
                        if(err){
                            cb(err);
                        }else {
                            cb(null, data);
                        }
                    });
                }
            }
        },
        createFuc: function(data){
            let billsLibId = data.billsLibId,
                code;
            let itemObj;
            if(data.type === 'CreateT'){
                itemObj = {
                    billsLibId: billsLibId,
                    code: data.code,
                    content: data.content,
                    deleted: false
                }
            }
            else{
                if(data.field === 'code'){
                    itemObj = {
                        billsLibId: billsLibId,
                        code: data.data,
                        content: '',
                        deleted: false
                    }
                }
                else {
                    itemObj = {
                        billsLibId: billsLibId,
                        code: data.code,
                        content: data.data,
                        deleted: false
                    }
                }
            }
            return function (cb){
                counter.counterDAO.getIDAfterCount(counter.moduleName.billsLib_items, 1, function(err, result){
                    if(err){
                        cb(err);
                    }
                    else{
                        let newItemId = result.value.sequence_value;
                        itemObj.id = newItemId;
                        data.newItemId = newItemId;
                        ItemCharacter.create(itemObj, function(err){
                            if(err){
                                cb(err);
                            }else {
                                cb(null, data);
                            }
                        });
                    }
                });
            }
        }
    };
    if(updateDatas.length > 0){
        for(let i=0; i<updateDatas.length; i++){
            functions.push(parallelFucs.updateFuc(updateDatas[i]));
        }
    }
    if(createDatas.length > 0){
        for(let i =0; i<createDatas.length; i++){
            functions.push(parallelFucs.createFuc(createDatas[i]));
        }
    }
    async.parallel(functions, function(err, datas){
        if(err){
            callback(1, 'Error', null);
        }else {
            callback(0, '', datas);
        }
    });

};
//org
/*billsLibDao.prototype.pasteValues = function(data, callback) {
    let pasteDatas = data.pasteDatas;
    let updateDatas = pasteDatas.updateDatas, createDatas = pasteDatas.createDatas;
    console.log(`test`);
    if (updateDatas.length > 0) {
        for (let i = 0; i < updateDatas.length; i++) {
            let billsLibId = updateDatas[i].billsLibId, itemId = updateDatas[i].itemId, orgCode = updateDatas[i].orgId;
            console.log(`i = ${i}`);
            if (updateDatas[i].type === 'UpdateT') {
                console.log(`UpdateT`);
                let valueObj = {code: updateDatas[i].code, value: updateDatas[i].content};
                ItemCharacter.update({billsLibId: billsLibId, id: itemId}, {$pull: {itemValue: {code: orgCode}}}, function (err) {
                    if (err) {
                    } else {
                        ItemCharacter.update({billsLibId: billsLibId, id: itemId}, {$addToSet: {itemValue: valueObj}}, function (err) {
                            if (err) {
                            }
                        });
                    }
                });
            }
            else if (updateDatas[i].type === 'Update' && updateDatas[i].field === 'code') {
                console.log(`UpdateCode`);
                ItemCharacter.update({billsLibId: billsLibId, id: itemId, 'itemValue.code': orgCode},
                    {$set: {'itemValue.$.code': updateDatas[i].data}}, function (err) {
                            if(err){
                            }
                    });
            }
            else {
                console.log(`UpdateValue`);
                console.log(`billsLibId: ${updateDatas[i].billsLibId} itemId: ${updateDatas[i].itemId} updateCode: ${updateDatas[i].orgId} value: ${updateDatas[i].data}`);
                ItemCharacter.update({billsLIbId: billsLibId, id: itemId, 'itemValue.code': orgCode}, {$set: {'itemValue.$.value': updateDatas[i].data}}, function(err, result){
                        if(err){
                            console.log(`Error`);
                        }
                        else {
                            console.log(`success`);
                            console.log(result);
                        }
                    });
            }
        }
    }
    if(createDatas.length >0){
        for(let i=0; i< createDatas.length; i++){
            let valueObj
            if(createDatas[i].type === 'CreateT'){
                console.log(`CreateT`);
                 valueObj = {code: createDatas[i].code, value: createDatas[i].content};
                ItemCharacter.update({billsLibId: createDatas[i].billsLibId, id: createDatas[i].itemId}, {$addToSet: {itemValue: valueObj}}, function (err) {
                    if (err) {
                    }
                });
            }
            else if(createDatas[i].type === 'Create' && createDatas[i].field === 'code'){
                console.log(`Create code`);
                valueObj = {code: createDatas[i].data, value: ''};
                ItemCharacter.update({billsLibId: createDatas[i].billsLibId, id: createDatas[i].itemId}, {$addToSet: {itemValue: valueObj}}, function (err) {
                    if (err) {
                    }
                });
            }
            else {
                console.log(`Create value`);
                valueObj = {code: createDatas[i].code, value: createDatas[i].data};
                ItemCharacter.update({billsLibId: createDatas[i].billsLibId, id: createDatas[i].itemId}, {$addToSet: {itemValue: valueObj}}, function (err) {
                    if (err) {
                    }
                });
            }
        }
    }
    callback(0, '');
};*/
billsLibDao.prototype.pasteValues = function(data, callback) {
    let pasteDatas = data.pasteDatas;
    let updateDatas = pasteDatas.updateDatas, createDatas = pasteDatas.createDatas;
    let functions = [];
    let parallelFucs = {
        updateFuc: function(data){
            let billsLibId = data.billsLibId, itemId = data.itemId, orgCode = data.orgId;
            if (data.type === 'UpdateT') {
                let valueObj = {code: data.code, value: data.content};
                return function (cb){
                    ItemCharacter.update({billsLibId: billsLibId, id: itemId}, {$pull: {itemValue: {code: orgCode}}}, function (err) {
                        if (err) {
                            cb(err);
                        }
                        else {
                            ItemCharacter.update({billsLibId: billsLibId, id: itemId}, {$addToSet: {itemValue: valueObj}}, function (err) {
                                if (err) {
                                    cb(err);
                                }
                                else {
                                    cb(null, data);
                                }
                            });
                        }
                    });
                };
            }
            else if (data.type === 'Update' && data.field === 'code') {
                return function (cb) {
                    ItemCharacter.update({billsLibId: billsLibId, id: itemId, 'itemValue.code': orgCode},
                        {$set: {'itemValue.$.code': data.data}}, function (err) {
                            if(err){
                                cb(err);
                            }
                            else {
                                cb(null, data);
                            }
                        });
                }
            }
            else {
                return function (cb){
                    ItemCharacter.update({billsLIbId: billsLibId, id: itemId, 'itemValue.code': orgCode}, {$set: {'itemValue.$.value': data.data}}, function(err){
                        if(err){
                            cb(err);
                        }
                        else {
                            cb(null, data);
                        }
                    });
                };
            }
        },

        createFuc: function(data){
            let valueObj;
            if(data.type === 'CreateT'){
                valueObj = {code: data.code, value: data.content};
                return function (cb){
                    ItemCharacter.update({billsLibId: data.billsLibId, id: data.itemId}, {$addToSet: {itemValue: valueObj}}, function (err) {
                        if (err) {
                            cb(err);
                        }
                        else {
                            cb(null, data);
                        }
                    });
                };
            }
            else if(data.type === 'Create' && data.field === 'code'){
                valueObj = {code: data.data, value: ''};
                return function (cb){
                    ItemCharacter.update({billsLibId: data.billsLibId, id: data.itemId}, {$addToSet: {itemValue: valueObj}}, function (err) {
                        if (err) {
                            cb(err);
                        }
                        else {
                            cb(null, data);
                        }
                    });
                };
            }
            else {
                valueObj = {code: data.code, value: data.data};
                return function(cb){
                    ItemCharacter.update({billsLibId: data.billsLibId, id: data.itemId}, {$addToSet: {itemValue: valueObj}}, function (err) {
                        if (err) {
                            cb(err);
                        }
                        else {
                            cb(null, data);
                        }
                    });
                };
            }
        }
    };
    if (updateDatas.length > 0) {
        for (let i = 0; i < updateDatas.length; i++) {
            functions.push(parallelFucs.updateFuc(updateDatas[i]));
        }
    }
    if(createDatas.length >0){
        for(let i=0; i< createDatas.length; i++){
            functions.push(parallelFucs.createFuc(createDatas[i]));
        }
    }
    async.parallel(functions, function(err, datas){
        if(err){
            callback(1, 'Error', null);
        }
        else {
            callback(0, '', datas);
        }
    });
};
//


module.exports = new billsLibDao();