YangHuCost/modules/all_models/bills.js

/**
 * Created by zhang on 2018/3/22.
 */
let mongoose = require("mongoose");
let subSchema = require("../all_schemas/bills_sub_schemas");
let deleteSchema = require("../all_schemas/delete_schema");
let Schema = mongoose.Schema;
let billsSchema = new Schema({
  ID: {
    type: String,
    index: true,
  },
  GUID: String, // 接口需要（导入导出不可变，因此不可用ID作为GUID）
  ParentID: String,
  NextSiblingID: String,
  projectID: {
    type: Number,
    index: true,
  },
  serialNo: Number,
  chapterID: Number,
  billsLibId: Number,
  code: String,
  sectionCode: String, // 清单章节号，池州接口需要
  fullCode: String,
  type: {
    type: Number,
    default: 4,
  }, //1 :大项费用 2：分部 3分项 4清单;5补项
  isAdd: {
    type: Number,
    default: 0,
  }, //1 true 0 false是否新增
  name: String,
  unit: String,
  quantity: String, // Decimal
  quantity2: String, //预算项目中的数量2
  quantityEXP: String, //工程量表达式
  feeRateID: Number,
  feeRate: String,
  isFromDetail: {
    type: Number,
    default: 0,
  }, //1 true 0 false
  programID: Number,
  unitPriceCoe: String, // 单价浮动系数
  calcBase: String,
  calcBaseValue: String, // 计算基数表达式的值
  tenderCalcBaseValue: String, // 调价后计算基数表达式的值
  baseProgressiveFee: String, // 累进计算中的基准值（报表需要这个中间值）
  // 工程量计算规则
  ruleText: String,
  // 说明
  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,
  targetUnitFee: String, //目标单价
  targetTotalFee: String, //目标合价
  //工作内容//zhong 2017-8-31
  jobContentText: String, //清单工作内容列显示文本, 减少第一次拉数据时的循环次数
  jobContent: [subSchema.jobContentSchema],
  //项目特征
  itemCharacterText: String, //清单项目特征列显示文本
  itemCharacter: [subSchema.itemCharacterSchema],
  // 费用字段
  fees: [subSchema.feesSchema],
  // 标记字段
  flags: [subSchema.flagsSchema],
  //消耗量调整系数字段
  quantityCoe: subSchema.quantityCoeSchema,
  //子目工程量调整系数
  rationQuantityCoe: String,
  // 不调价
  is_adjust_price: {
    type: Number,
    default: 0,
  },
  installationKey: String, //用来记录安装增加费的关联字段
  deleteInfo: deleteSchema,
  isEstimate: {
    type: Number,
    default: 0,
  }, // 1 true 0 false 是否暂估
  lockUnitPrice: {
    type: Schema.Types.Mixed,
    default: false,
  }, //  true  false 锁定综合单价，true 为锁定
  unitPriceAnalysis: {
    type: Number,
    default: 0,
  }, // 1 true 0 false 单价分析
  specialProvisional: String,
  outPutMaxPrice: { type: Schema.Types.Mixed, default: false }, //输出最高限价 true 是，false否，null 不确定，三个状态
  outPutLimitPrice: { type: Schema.Types.Mixed, default: false }, //输出限价 true 是，false否，null 不确定，三个状态
  appraisalBills: { type: Schema.Types.Mixed, default: false }, //true 是，false否，null 不确定，三个状态
  maxPrice: String, //最高限价
  minPrice: String, //最低限价
  remark: String,
  engineeringContent: String, //工程内容
  serviceContent: String, //服务内容
  claimVisa: String, //签证及索赔依据
  calcFlag: {
    type: Number,
  }, // 叶子清单的计算类型。末定义：按定额计算。1：用户输入金额。2：用户输入单价。3：用户输入设计单价。
  bookmarkBackground: String, //书签背景色
  bookmarkAnnotation: String, //批注
});

mongoose.model("bills", billsSchema);