package models

import (
	"fmt"
	"opp/internal/utils"
	"time"

	"github.com/astaxie/beego/orm"
)

type AuditFlowProcess struct {
	Id             int64     `orm:"column(id);pk" description:"唯一标识"`
	ChanceId       int64     `orm:"column(chance_id)" description:"实例id，关联chance表id"`
	Uid            int64     `orm:"column(uid)" description:"用户id(审批人)"`
	Level          int       `orm:"column(level)" description:"审批步骤"`
	IsActive       int8      `orm:"column(is_active)" description:"是否激活"`
	ApproveTime    time.Time `orm:"column(approve_time);type(timestamp)" description:"审批时间"`
	BasicScore     float64   `orm:"column(basic_score);null;digits(4);decimals(1)" description:"基础评分"`
	ExtraScore     float64   `orm:"column(extra_score);null;digits(4);decimals(1)" description:"附加评分"`
	ValueScore     float64   `orm:"column(value_score);null;digits(4);decimals(1)" description:"价值评分"`
	DiscoveryScore float64   `orm:"column(discovery_score);null;digits(4);decimals(1)" description:"发现得分（发现得分=基础评分*系数 + 附加评分*系数 + 价值评分*系数）"`
	ReviewStatus   int8      `orm:"column(review_status)" description:"审核状态 0:审核中 1:被退回 2:已通过 3.自动通过 "`
	AuditFlowType  int       `orm:"column(audit_flow_type)" description:"审核流类型 1.部门长 2.指定成员 3.指定角色 4.特殊审核人"`
	FlowType       int       `orm:"column(flow_type)" description:"审批类型 1:正常审核  2：特殊审核"`
	ActionType     int       `orm:"column(action_type)" description:"审批执行方式【1:or】【2:and】"`
	CreateAt       time.Time `orm:"column(create_at);type(timestamp)" description:"创建时间"`
	UpdateAt       time.Time `orm:"column(update_at);type(timestamp)" description:"更新时间"`
	EnableStatus   int8      `orm:"column(enable_status)" description:"有效状态 0:无效 1:有效 (被驳回以后，未完成的审核置为无效)"`
	ApproveData    string    `orm:"column(approve_data);size(500)" description:"审核数据 json{公开状态 公开对象 分数}"`
	UserName       string    `orm:"column(user_name);size(50)" description:"用户名-冗余"`
	RoleName       string    `orm:"column(role_name);size(50)" description:"角色名-冗余"`
	RoleId         int       `orm:"column(role_id);size(50)" description:"角色id-冗余"`
	ApproveMessage string    `orm:"column(approve_message);size(50)" description:"审核消息-冗余"`
	TemplateId     int       `orm:"column(template_id);size(50)" description:"模板编号-冗余"`
}

func (t *AuditFlowProcess) TableName() string {
	return "audit_flow_process"
}

func init() {
	orm.RegisterModel(new(AuditFlowProcess))
}

// AddAuditFlowProcess insert a new AuditFlowProcess into database and returns
// last inserted Id on success.
func AddAuditFlowProcess(m *AuditFlowProcess) (id int64, err error) {
	o := orm.NewOrm()
	id, err = o.Insert(m)
	return
}

// GetAuditFlowProcessById retrieves AuditFlowProcess by Id. Returns error if
// Id doesn't exist
func GetAuditFlowProcessById(id int64) (v *AuditFlowProcess, err error) {
	o := orm.NewOrm()
	v = &AuditFlowProcess{Id: id}
	if err = o.Read(v); err == nil {
		return v, nil
	}
	return nil, err
}

// UpdateAuditFlowProcess updates AuditFlowProcess by Id and returns error if
// the record to be updated doesn't exist
func UpdateAuditFlowProcessById(m *AuditFlowProcess) (err error) {
	o := orm.NewOrm()
	v := AuditFlowProcess{Id: m.Id}
	// ascertain id exists in the database
	if err = o.Read(&v); err == nil {
		var num int64
		if num, err = o.Update(m); err == nil {
			fmt.Println("Number of records updated in database:", num)
		}
	}
	return
}

// DeleteAuditFlowProcess deletes AuditFlowProcess by Id and returns error if
// the record to be deleted doesn't exist
func DeleteAuditFlowProcess(id int64) (err error) {
	o := orm.NewOrm()
	v := AuditFlowProcess{Id: id}
	// ascertain id exists in the database
	if err = o.Read(&v); err == nil {
		var num int64
		if num, err = o.Delete(&AuditFlowProcess{Id: id}); err == nil {
			fmt.Println("Number of records deleted in database:", num)
		}
	}
	return
}

//审核流程编号 按用户编号
//获取审核流节点
func GetAuditFlowProcessBy(processId, uid int64) (v *AuditFlowProcess, err error) {
	o := orm.NewOrm()
	sql := "select * from audit_flow_process where id=? and uid=? and enable_status=1"
	if err = o.Raw(sql, processId, uid).QueryRow(&v); err == nil {
		return v, nil
	}
	return nil, err
}

//当前审批批次已经结束 唤醒下一批次审批人
func UpdatetAuditFlowProcessToNext(o orm.Ormer, chanceId int64, level int, uids []int64) (err error) {
	sql := "update audit_flow_process set enable_status =1,is_active=1,update_at=now()  where chance_id=? and level=? and uid in (?)"
	if err = utils.ExecuteSQLWithOrmer(o, sql, chanceId, level, utils.JoinInt64s(uids, ",")); err != nil {
		return
	}
	return
}

//或签 有一人已经通过 同批次在审核状态置为无效
func UpdatetAuditFlowProcessNoApprove(o orm.Ormer, chanceId int64, level int, reviewStatus int) (err error) {
	sql := "update audit_flow_process set enable_status =0,is_active=0,update_at=now() where chance_id=? and level=? and review_status=?"
	if err = utils.ExecuteSQLWithOrmer(o, sql, chanceId, level, reviewStatus); err != nil {
		return
	}
	return
}

//获取机会审核流信息
func GetAuditFlowProcessList(chanceId int64) (v []*AuditFlowProcess, err error) {
	o := orm.NewOrm()
	sql := `select id ,chance_id,uid,level,is_active,IFNULL(approve_time,NOW()) approve_time,basic_score,extra_score,value_score,discovery_score,
review_status,audit_flow_type,flow_type,action_type,update_at,create_at,enable_status,approve_data,user_name,role_name,role_id,approve_message,
template_id from audit_flow_process 
where chance_id =? and enable_status=1 order by approve_time,level desc`
	if _, err = o.Raw(sql, chanceId).QueryRows(&v); err == nil {
		return v, nil
	}
	return nil, err
}

func GetAuditFlowProcessListByAuditUser(chanceId int64, auditUserId int64) (v []*AuditFlowProcess, err error) {
	o := orm.NewOrm()
	sql := "select id,review_status from audit_flow_process where chance_id=? and enable_status=1 and uid=?"
	if _, err = o.Raw(sql, chanceId, auditUserId).QueryRows(&v); err == nil {
		return v, nil
	}
	return nil, err
}

//删除机会时关闭所有审核信息
func CloseAuditFlowProcess(orm orm.Ormer, chanceId int64) (err error) {
	sql := "update audit_flow_process set enable_status =0,is_active=0,update_at=now() where chance_id=?"
	if err = utils.ExecuteSQLWithOrmer(orm, sql, chanceId); err != nil {
		return
	}
	return
}

//获取当前审批节点 是否已经有人审核通过的
func GetAuditFlowProcessApproved(chanceId int64, level int) (v *[]AuditFlowProcess, err error) {
	o := orm.NewOrm()
	sql := "select id from audit_flow_process  where chance_id=? and level=? and is_active=1 and review_status<>1 and enable_status=1"
	if _, err = o.Raw(sql, chanceId, level).QueryRows(&v); err != nil {
		return
	}
	return
}

//按审核状态获取审核流程
func GetAuditFlowProcessByReview(chanceId int64, level int, reviewStatus int) (v *AuditFlowProcess, err error) {
	o := orm.NewOrm()
	sql := "select * from audit_flow_process  where chance_id=? and level=? and is_active=1 and review_status=? and enable_status=1"
	if err = utils.ExecuteQueryOneWithOrmer(o, &v, sql, chanceId, level, reviewStatus); err != nil {
		return
	}
	return
}

//更新提交
func UpdatetAuditFlowProcessToSubmit(o orm.Ormer, chanceId int64, level int, reviewStatus int, userId int64) (err error) {
	sql := "update audit_flow_process set enable_status =1,is_active=0,update_at=now(),review_status=?  where chance_id=? and uid=? and level=? and review_status=0 and enable_status=1"
	if err = utils.ExecuteSQLWithOrmer(o, sql, reviewStatus, chanceId, userId, level); err != nil {
		return
	}
	return
}