construction_management/dao/safe_audit_dao.go

/*
 * @description: 安全巡检数据库操作相关
 * @Author: LanJianRong
 * @Date: 2020-11-20
 * @FilePath: \construction_management\dao\safe_dao.go
 */

package dao

import (
	"fmt"

	"github.com/go-xorm/xorm"
	"go.mod/models"
	"go.mod/web/viewmodels"
)

//数据库操作引擎
type SafeAuditDao struct {
	engine *xorm.Engine
}

//获得一个DAO对象
func NewSafeAuditDao(engine *xorm.Engine) *SafeAuditDao {
	return &SafeAuditDao{
		engine: engine,
	}
}

// id获得数据
func (d *SafeAuditDao) GetListBySid(id int) []models.CmSafeAudit {
	dataList := make([]models.CmSafeAudit, 0)
	err := d.engine.
		Asc("audit_order").
		Where("safe_id=?", id).
		Find(&dataList)
	if err != nil {
		return dataList
	}
	return dataList
}

// id获得某一条审批记录
func (d *SafeAuditDao) GetRecordBySid(id int) viewmodels.SafeListAuditRecord {
	// data := &models.CmSafeAudit{}
	sql := "select p.name, s.create_time from `cm_safe_audit` as s , `cm_project_account` as p where s.`audit_id` = p.`id` and s.`safe_id` = ? and `times` = (select max(`times`) from `cm_safe_audit` where `safe_id` = ?) order by `audit_order` desc limit 2"

	results, err := d.engine.Query(sql, id, id)

	if err != nil {

	}
	record := viewmodels.SafeListAuditRecord{}

	// fmt.Println(results)
	for i, item := range results {
		fmt.Println(item)

		if i == 1 {
			record.CreateTime = string(item["create_time"])
			record.Name = string(item["name"])
		}
	}

	return record
}

// func (d *ProjectAccountDao) GetAudit(id int) {
// 	auditor := models.CmProjectAccount
// 	has, err := d.engine.Id(id).Get(auditor)
// 	return auditor
// }