ConstructionCost/modules/main/models/bills.js

/**
 * Created by jimiz on 2017/4/1.
 */
var mongoose = require("mongoose");
var db = require("../db/project_db");
var subSchema = require("./billsSubSchemas");
var Schema = mongoose.Schema;
var counter = require("../../../public/counter/counter.js");

var billsSchema = new Schema({
    ID: Number,
    ParentID: Number,
    NextSiblingID: Number,
    projectID: Number,
    serialNo: Number,
    chapterID: Number,
    code: String,
    fullCode: String,
    name: String,
    unit: String,
    quantity: String, // Decimal
    programID: Number,
    comments: String,
    // 调价
    xs_Labour: String, // Decimal
    xs_Material: String, // Decimal
    xs_Machine: String, // Decimal
    xs_FeeRate: String, // Decimal
    xs_LabourPrice: String, // Decimal
    xs_MaterialPrice: String, // Decimal
    xs_MachinePrice: String, // Decimal
    isTender_Labour: Boolean,
    isTender_Material: Boolean,
    isTender_Machine: Boolean,
    tenderTargetPrice: String, // Decimal
    tenderTargetUnitPrice: String, // Decimal
    // 费用字段
    fees: [subSchema.feesSchema],
    // 标记字段
    flags: [subSchema.flagsSchema]
});

var bills = db.model("bills", billsSchema);

var billsDAO = function(){};

billsDAO.prototype.getData = function(projectID, callback){
    bills.find({projectID: projectID}, function(err, datas){
        if (!err) {
            callback(0, '', datas);
        } else {
            callback(1, '', null);
        };
    });
};

billsDAO.prototype.AddBillsFromTemplate = function (datas, callback) {
    bills.collection.insert(datas, callback);
};

billsDAO.prototype.save = function(datas, callback){
    var data, errList = [], updateLength = 0;
    var updateFunc = function (err, errData) {
        if (err){
            errList.push(errData);
        };
    };
    if (datas){
        for (var i = 0; i < datas.length; i++){
            data = datas[i];
            if (data.updateType === 'update') {
                delete data.updateType;
                data.save(updateFunc);
            } else if (data.updateType === 'create') {
                delete data.updateType;
                data.save(updateFunc);
            } else if (data.updateType === 'delete') {
                delete data.updateType;
                data.remove(updateFunc);
            };
        };
        if (errList.length > 0){
            callback(1, errList);
        } else {
            callback(0, null);
        };
    };
};

billsDAO.prototype.getItemTemplate = function(callback){
    var data = new bills;
    /* to do: 需要根据标准配置库填充fees和flags字段，是否需要更多的参数？ */
    callback(0, '', data);
};

billsDAO.prototype.allocIDs = function(IDStep, callback){
    counter.counterDAO.getIDAfterCount(counter.moduleName.bills, IDStep, function(err, highID){
        var lowID = highID - IDStep + 1;
        callback(0, '', {lowID: lowID, highID: highID});
    });
};

module.exports = new billsDAO();