/**
 * 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 billsDao = function(){};
//----------StdBillsLib-------------------
billsDao.prototype.getStdBillsLib = function(userId, callback){
    StdBillsLib.find({}, "-_id", function(err, data){
        if(err){
            callback(1, "Error", null);
        }
        else{
            callback(0, "", data);
        }
    })
}

billsDao.prototype.createStdBillsLib = function(clibData, callback){
    counter.getIDAfterCount("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);
                    }
                });
            }
        });
    });
}

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

billsDao.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, "");
        }
    });
}

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

billsDao.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
        };
        Bills.create(newBills, function(err){
            if(err){
                callback(1, "Error");
            }
            else{
                callback(0, "");
            }
        });
}

billsDao.prototype.updatePNId= function(updateData, callback){
    var billsLibId = updateData.billsLibId;
    var updateId = updateData.updateId;
    var updatepid= updateData.ParentID;
    var updatenid = updateData.NextSiblingID;
    if(!updatepid){
        Bills.update({billsLibId: billsLibId, ID: updateId}, {$set: {NextSiblingID: updatenid}}, function(err){
            if(err){
                callback(1, "Error")
            }
            else{
                callback(0, "");
            }
        });
    }
    else if(!updatenid){
        Bills.update({billsLibId: billsLibId, ID: updateId}, {$set: {ParentID: updatepid}}, function(err){
            if(err){
                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, "");
            }
        });
    }
}
   /* Bills.update({nodeId: updateNode, billsLibId: billsLibId}, {$set: {ParentID: updatepid, NextSiblingID: updatenid}}, function(err){
        if(err){
            callback(1, "Error")
        }
        else{
            callback(0, "");
        }
    });*/

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

billsDao.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------------------
billsDao.prototype.getJobContent = function(billsLibId, callback){
    JobContent.find({billsLibId: billsLibId}, "-_id", function(err, jobs){
        if(err){
            callback(1, "Error", null);
        }
        else{
            callback(0, "", jobs)
        }
    });
}

billsDao.prototype.createJobContent = function(cJobData, callback){
    var field = cJobData.field;
    var data = cJobData.data;
    var id = counter.getIDAfterCount("billsLib", 1);
    var billsLibId = cJobData.billsLibId;
    var newJobContent;
    if(field == "code"){
        newJobContent = {
            id: id,
            billsLibId: billsLibId,
            code: data
        }
    }
    else if(field == "content"){
        newJobContent = {
            id: id,
            billsLibId: billsLibId,
            content: data
        }
    }
    JobContent.create(newJobContent, function(err){
        if(err){
            callback(1, "Error");
        }
        else{
            callback(0, "");
        }
    });
}

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

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


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

billsDao.prototype.createItemCharacter = function(cItemData, callback){
    var field = cItemData.field;
    var data = cItemData.data;
    var id = counter.getIDAfterCount("billsLib", 1);
    var billsLibId = cItemData.billsLibId;
    var newItemCharacter;
    if(field == "code"){
        newItemCharacter = {
            id: id,
            billsLibId: billsLibId,
            code: data
        }
    }
    else if(field == "content"){
        newItemCharacter = {
            id: id,
            billsLibId: billsLibId,
            content: data
        }
    }
}

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

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

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

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

module.exports = new billsDao();