import mongooseUniqueValidator from "mongoose-unique-validator";
import {AppMaster} from "@onebro/appmaster";
import {
  DeepPartial,
  IModelCreator,
  IStatus,
  IQuery,
  mapSelectedData,
  getSchemaRefs,
  ObjectId} from "@onebro/oba-common";
import {
  FinavigatorCommissionConfig,
  FinavigatorCommissionModel,
  FinavigatorCommission,
  FinavigatorCommissionJson,
  FinavigatorCommissionStatus,
  FinavigatorCommissionStatuses as statuses,} from "../types";
import {finavigatorCommissionSchema as comm} from "../schemas";
const refs = getSchemaRefs(comm);

export const finavigatorCommissionModels:IModelCreator<AppMaster> = async m => {
  comm.plugin(mongooseUniqueValidator);
  comm.virtual("lastStatus").get(function(){return this.status?(this.status[this.status.length - 1] as any).json(statuses):null;});
  comm.virtual("lastStatus").set(function(o:IStatus<FinavigatorCommissionStatus>){this.status = [...this.status,o];});
  comm.virtual("statusStr").get(function(){return this.lastStatus?this.lastStatus.name + " @ " + this.lastStatus.time:"";});
  comm.statics._populate = async function(o?:FinavigatorCommission){
    await o.populate(refs).execPopulate();
    return o;};
  comm.statics._find = async function(o:Partial<FinavigatorCommission>|string){
    if(!o) return m.e.badinfo();
    const p = typeof o == "string"?
    await FinavigatorCommission.findById(o):
    await FinavigatorCommission.findOne(FinavigatorCommission.translateAliases(o));
    if(!p) throw m.e.doesNotExist("commission");
    return p;};
  comm.statics._create = async function(o:FinavigatorCommissionConfig){return new FinavigatorCommission({
    ...o,
    payer:new ObjectId(o.payer),
    payee:new ObjectId(o.payee),
  });};
  comm.statics._update = async function(o:FinavigatorCommission,p:DeepPartial<FinavigatorCommission>){
    await o.set(p).save();
    return await FinavigatorCommission._populate(o);};
  comm.statics._remove = async function(o:FinavigatorCommission){return await o.remove().then(() => ({removed:o._id}));};
  comm.statics._query = async function(o:IQuery){
    const {query,populate,limit,skip,sort,select} = o;
    const results:FinavigatorCommission[] = await this.find(this.translateAliases(query))
      .populate(populate)
      //.where(where)
      .limit(limit)
      .skip(skip)
      .sort(sort)
      .exec();
    const comms = mapSelectedData(select,results);
    return {comms};};
  comm.statics._lookup = async function({path,query}:{path:string;query:any}){
    const pipeline:any[] = [];
    return FinavigatorCommission.aggregate(pipeline)
    .exec()
    .then((R:Partial<{[k in keyof (FinavigatorCommission & FinavigatorCommissionJson)]:any}>[]) => {
      return {comms:R.map(o => {
        if(o.status) o.status = {
          name:statuses[o.status.a0 as FinavigatorCommissionStatus],
          time:o.status.a1,
          until:o.status.a2,
          info:o.status.a3};
        delete o._id;
        return o;})};
    });};
  comm.methods.json = function(){
    const {id,created,updated,lastStatus:status,statusStr,payer,payee,amt,reason,refId,notes} = this as FinavigatorCommission;
    const json:FinavigatorCommissionJson = {
      id,created,updated,status,statusStr,
      payer:payer.preview(),
      payee:payee.preview(),
      amt,reason,refId,
      notes:notes.map(m => (m as any).json()),
    };
    return json;};
  const FinavigatorCommission = m.db.model<FinavigatorCommission,FinavigatorCommissionModel>("onebrother","FinavigatorCommission",comm);
  await FinavigatorCommission.init();
  return {FinavigatorCommission};
};