/
repository.products.go
50 lines (42 loc) · 1.41 KB
/
repository.products.go
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
package repository
import (
"github.com/amarmaulana95/go-echo/models"
"github.com/amarmaulana95/go-echo/schemas"
"gorm.io/gorm"
)
type repositoryProduct struct {
db *gorm.DB
}
// EntityCreate implements entity.Entityproductss
func (*repositoryProduct) EntityCreate(input *schemas.SchemaProduct) (*models.ModelProduct, error) {
panic("unimplemented")
}
func NewRepositoryProduct(db *gorm.DB) *repositoryProduct {
return &repositoryProduct{
db: db,
}
}
func (r *repositoryProduct) EntityResults() (*[]models.ModelProduct, error) {
var products []models.ModelProduct
db := r.db.Model(&products)
err := db.Debug().Find(&products).Error
if err != nil {
return &products, err
}
return &products, nil
}
func (r *repositoryProduct) EntityResultAll(search string, limit uint64, offset uint64) (*[]models.ModelProduct, error) {
searchs := "%" + search + "%"
aslimit := limit
asoffset := offset
var products []models.ModelProduct
r.db.Debug().Model(&products).Select("id, name, price, description, created_at").Where("lower(name) like lower(?)", searchs).Order("id asc").Limit(int(aslimit)).Offset(int(asoffset)).Find(&products)
return &products, nil
}
func (r *repositoryProduct) EntityResultAllTotal(search string) uint64 {
cari := "%" + search + "%"
tampung := []models.ModelProduct{}
result := r.db.Debug().Where("lower(name) like lower(?)", cari).Find(&tampung)
hasil := uint64(result.RowsAffected)
return hasil
}