package purchase
|
|
//
|
//import (
|
// "srm/global"
|
// "srm/model/common/request"
|
//)
|
//
|
//type QualityInspect struct{}
|
//
|
//func NewQualityInspect() *QualityInspect {
|
// return &QualityInspect{}
|
//}
|
//
|
////@function: GetQualityInspect
|
////@description: 获取采购单信息
|
////@param: id uint
|
////@return: QualityInspect model.QualityInspect, err error
|
//
|
//func (slf *QualityInspect) GetQualityInspect(id uint) (QualityInspect QualityInspect.QualityInspect, err error) {
|
// err = global.GVA_DB.Where("id = ?", id).Preload("Supplier").First(&QualityInspect).Error
|
// return
|
//}
|
//
|
////@function: GetQualityInspectList
|
////@description: 分页获取采购单列表
|
////@param: info request.PageInfo
|
////@return: list interface{}, total int64, err error
|
//
|
//func (slf *QualityInspect) GetQualityInspectList(info request.PageInfo) (list interface{}, total int64, err error) {
|
// limit := info.PageSize
|
// offset := info.PageSize * (info.Page - 1)
|
// db := global.GVA_DB.Model(&QualityInspect.QualityInspect{})
|
// if info.Keyword != "" {
|
// db.Distinct("QualityInspects.id").Joins("left join QualityInspect_products on QualityInspect_products.QualityInspect_id = QualityInspects.id").
|
// Joins("left join Product on Product.Id = QualityInspect_products.product_id").
|
// Joins("left join supplier on supplier.Id = QualityInspects.supplier_id").
|
// Where("QualityInspects.name like ?", "%"+info.Keyword+"%").
|
// Or("Product.name like ?", "%"+info.Keyword+"%").
|
// Or("supplier.name like ?", "%"+info.Keyword+"%")
|
// }
|
// var QualityInspectList []QualityInspect.QualityInspect
|
// err = db.Count(&total).Error
|
// if err != nil {
|
// return QualityInspectList, total, err
|
// }
|
// err = db.Limit(limit).Offset(offset).Find(&QualityInspectList).Error
|
// return QualityInspectList, total, err
|
//}
|
//
|
////@function: GetQualityInspectProductList
|
////@description: 分页获取采购单产品列表
|
////@param: QualityInspectId int
|
////@return: list interface{}, err error
|
//
|
//func (slf *QualityInspect) GetQualityInspectProductList(QualityInspectId uint) (list []*QualityInspect.QualityInspectProducts, err error) {
|
// db := global.GVA_DB.Model(&QualityInspect.QualityInspectProducts{})
|
// list = make([]*QualityInspect.QualityInspectProducts, 0)
|
// err = db.Where("QualityInspect_id = ?", QualityInspectId).Preload("Product").Find(&list).Error
|
// return list, err
|
//}
|
