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 //}