query

package
v0.7.0 Latest Latest
Warning

This package is not in the latest version of its module.

 Go to latest Published: Mar 26, 2023 License: GPL-2.0 Imports: 27 Imported by: 0

Documentation

Overview

*

  • Copyright 2015 @ 56x.net.
  • name : aftersales_query
  • author : jarryliu
  • date : 2016-07-18 19:27
  • description :
  • history :

*

  • Copyright 2014 @ 56x.net.
  • name :
  • author : jarryliu
  • date : 2013-12-03 23:20
  • description :
  • history :

*

  • Copyright 2015 @ 56x.net.
  • name : goods_query.go
  • author : jarryliu
  • date : 2016-04-23 12:37
  • description :
  • history :

*

  • Copyright 2014 @ 56x.net.
  • name :
  • author : jarryliu
  • date : 2013-12-03 23:20
  • description :
  • history :

*

  • Copyright 2014 @ 56x.net.
  • name :
  • author : jarryliu
  • date : 2013-12-03 23:20
  • description :
  • history :

*

  • Copyright 2015 @ 56x.net.
  • name : order_query
  • author : jarryliu
  • date : 2016-07-08 15:32
  • description :
  • history :

*

  • Copyright 2014 @ 56x.net.
  • name :
  • author : jarryliu
  • date : 2013-12-03 23:20
  • description :
  • history :

*

  • Copyright 2014 @ 56x.net.
  • name :
  • author : jarryliu
  • date : 2013-12-03 23:20
  • description :
  • history :

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

This section is empty.

Types

type AfterSalesQuery 

type AfterSalesQuery struct {
	db.Connector
}

func NewAfterSalesQuery 

func NewAfterSalesQuery(db db.Connector) *AfterSalesQuery

func (*AfterSalesQuery) QueryPagerAfterSalesOrderOfMember 

func (a *AfterSalesQuery) QueryPagerAfterSalesOrderOfMember(memberId int64, begin,
	size int, where string) (int, []*dto.PagedMemberAfterSalesOrder)

获取分页售后单

func (*AfterSalesQuery) QueryPagerAfterSalesOrderOfVendor 

func (a *AfterSalesQuery) QueryPagerAfterSalesOrderOfVendor(vendorId int64, begin,
	size int, where string) (int, []*dto.PagedVendorAfterSalesOrder)

获取分页售后单

type ContentQuery 

type ContentQuery struct {
	db.Connector
	// contains filtered or unexported fields
}

func NewContentQuery 

func NewContentQuery(o orm.Orm) *ContentQuery

func (*ContentQuery) PagedArticleList 

func (cq *ContentQuery) PagedArticleList(catId int32, begin, size int, where string) (total int,
	rows []*content.Article)

type ItemQuery 

type ItemQuery struct {
	db.Connector
	// contains filtered or unexported fields
}

func NewItemQuery 

func NewItemQuery(o orm.Orm) *ItemQuery

func (ItemQuery) GetOnShelvesItem 

func (i ItemQuery) GetOnShelvesItem(catIdArr []int, begin, end int,
	where string) []*item.GoodsItem

根据分类获取上架的商品

func (ItemQuery) GetPagingOnShelvesGoods added in v0.4.10 

func (i ItemQuery) GetPagingOnShelvesGoods(shopId int64,
	catIds []int, flag int, start, end int,
	keyword string,
	where, orderBy string) (int, []*valueobject.Goods)

GetPagingOnShelvesGoods 获取已上架的商品

func (ItemQuery) GetPagingOnShelvesItem added in v0.4.10 

func (i ItemQuery) GetPagingOnShelvesItem(catId int32,
	start, end int32, where, orderBy string) (int32, []*item.GoodsItem)

GetPagingOnShelvesItem 根据关键词搜索上架的商品

func (ItemQuery) GetPagingOnShelvesItemForWholesale added in v0.4.10 

func (i ItemQuery) GetPagingOnShelvesItemForWholesale(catId int32,
	start, end int32, where, orderBy string) (int32, []*item.GoodsItem)

GetPagingOnShelvesItemForWholesale 根据关键词搜索上架的商品

func (ItemQuery) GetRandomItem 

func (i ItemQuery) GetRandomItem(catIdArr []int, begin, end int, where string) []*item.GoodsItem

搜索随机的商品列表

func (*ItemQuery) QueryItemSalesHistory added in v0.4.10 

func (i *ItemQuery) QueryItemSalesHistory(itemId int64, size int, random bool) (rows []*dto.ItemSalesHistoryDto)

QueryItemSalesHistory 查询商品销售记录

func (*ItemQuery) SearchItem added in v0.4.10 

func (i *ItemQuery) SearchItem(shopId int, keyword string, size int) (rows []*dto.SearchItemResultDto)

func (ItemQuery) SearchOnShelvesItem 

func (i ItemQuery) SearchOnShelvesItem(word string, start, end int32,
	where, orderBy string) (int32, []*item.GoodsItem)

SearchOnShelvesItem 根据关键词搜索上架的商品

func (ItemQuery) SearchOnShelvesItemForWholesale 

func (i ItemQuery) SearchOnShelvesItemForWholesale(word string, start, end int32,
	where, orderBy string) (int32, []*item.GoodsItem)

根据关键词搜索上架的商品

type MemberQuery 

type MemberQuery struct {
	db.Connector
	// contains filtered or unexported fields
}

func NewMemberQuery 

func NewMemberQuery(o orm.Orm) *MemberQuery

func (*MemberQuery) FilterMemberByUserOrPhone 

func (m *MemberQuery) FilterMemberByUserOrPhone(key string) []*dto.SimpleMember

筛选会员根据用户或者手机

func (*MemberQuery) GetInviteArray 

func (m *MemberQuery) GetInviteArray(memberId int64, where string) []int64

获取从指定时间到现在推荐指定等级会员的数量

func (*MemberQuery) GetInviteQuantity 

func (m *MemberQuery) GetInviteQuantity(memberId int64, where string) int32

获取从指定时间到现在推荐指定等级会员的数量

func (*MemberQuery) GetLatestWalletLogByKind 

func (m *MemberQuery) GetLatestWalletLogByKind(memberId int64, kind int) *member.WalletAccountLog

获取最近的余额变动信息

func (*MemberQuery) GetMemberByUserOrPhone 

func (m *MemberQuery) GetMemberByUserOrPhone(key string) *dto.SimpleMember

func (*MemberQuery) GetMemberIdByPhone 

func (m *MemberQuery) GetMemberIdByPhone(phone string) int64

根据手机获取会员编号

func (*MemberQuery) GetMemberInviRank 

func (m *MemberQuery) GetMemberInviRank(mchId int64, allTeam bool, levelComp string, level int,
	startTime int64, endTime int64, num int) []*dto.RankMember

会员推广排名

func (*MemberQuery) InviteMembersQuantity 

func (m *MemberQuery) InviteMembersQuantity(memberId int64, where string) int

获取邀请会员数量

func (*MemberQuery) OrdersQuantity 

func (m *MemberQuery) OrdersQuantity(memberId int64) map[int]int

获取订单状态及其数量

func (*MemberQuery) PagedBalanceAccountLog 

func (m *MemberQuery) PagedBalanceAccountLog(memberId int64, valueFilter int32, begin, end int,
	where, orderBy string) (num int, rows []*proto.SMemberAccountLog)

获取账户余额分页记录

func (*MemberQuery) PagedGoodsFav 

func (m *MemberQuery) PagedGoodsFav(memberId int64, begin, end int,
	where string) (num int, rows []*dto.PagedGoodsFav)

获取分页店铺收藏

func (*MemberQuery) PagedIntegralAccountLog 

func (m *MemberQuery) PagedIntegralAccountLog(memberId int64, valueFilter int32,
	begin, over int64, sortBy string) (num int, rows []*proto.SMemberAccountLog)

获取账户余额分页记录

func (*MemberQuery) PagedShopFav 

func (m *MemberQuery) PagedShopFav(memberId int64, begin, end int,
	where string) (num int, rows []*dto.PagedShopFav)

获取分页店铺收藏

func (*MemberQuery) PagedWalletAccountLog 

func (m *MemberQuery) PagedWalletAccountLog(memberId int64, valueFilter int32, begin, end int,
	where, orderBy string) (num int, rows []*proto.SMemberAccountLog)

获取账户余额分页记录

func (*MemberQuery) QueryMemberList 

func (m *MemberQuery) QueryMemberList(ids []int64) []*dto.MemberSummary

获取会员列表

type MerchantQuery 

type MerchantQuery struct {
	db.Connector
	Storage storage.Interface
}

func NewMerchantQuery 

func NewMerchantQuery(c gof.App) *MerchantQuery

func (*MerchantQuery) QueryMerchantIdByHost 

func (m *MerchantQuery) QueryMerchantIdByHost(host string) int64

根据主机查询商户编号

func (*MerchantQuery) Verify 

func (m *MerchantQuery) Verify(user, pwd string) int

验证用户密码并返回编号

type OrderQuery 

type OrderQuery struct {
	db.Connector
}

func NewOrderQuery 

func NewOrderQuery(o orm.Orm) *OrderQuery

func (*OrderQuery) PagedNormalOrderOfVendor 

func (o *OrderQuery) PagedNormalOrderOfVendor(vendorId int64, begin, size int, pagination bool,
	where, orderBy string) (int, []*dto.PagedVendorOrder)

查询分页订单

func (*OrderQuery) PagedTradeOrderOfVendor 

func (o *OrderQuery) PagedTradeOrderOfVendor(vendorId int64, begin, size int, pagination bool,
	where, orderBy string) (int32, []*dto.PagedVendorOrder)

查询分页订单

func (*OrderQuery) PagedWholesaleOrderOfBuyer 

func (o *OrderQuery) PagedWholesaleOrderOfBuyer(memberId, begin, size int64, pagination bool, where, orderBy string) (int, []*dto.MemberPagingOrderDto)

查询分页订单

func (*OrderQuery) PagedWholesaleOrderOfVendor 

func (o *OrderQuery) PagedWholesaleOrderOfVendor(vendorId int64, begin, size int, pagination bool,
	where, orderBy string) (int, []*dto.PagedVendorOrder)

查询分页订单

func (*OrderQuery) PagingTradeOrderOfBuyer added in v0.4.10 

func (o *OrderQuery) PagingTradeOrderOfBuyer(memberId, begin, size int64, pagination bool, where, orderBy string) (int, []*proto.SSingleOrder)

查询分页订单

func (*OrderQuery) QueryOrderItems 

func (o *OrderQuery) QueryOrderItems(subOrderId int64) []*dto.OrderItem

QueryOrderItems 获取订单的商品项

func (*OrderQuery) QueryPagingNormalOrder added in v0.4.10 

func (o *OrderQuery) QueryPagingNormalOrder(memberId, begin, size int64, pagination bool, where, orderBy string) (int, []*dto.MemberPagingOrderDto)

QueryPagingNormalOrder 查询分页普通订单

type ShopQuery 

type ShopQuery struct {
	db.Connector

	Storage storage.Interface
	// contains filtered or unexported fields
}

func NewShopQuery 

func NewShopQuery(o orm.Orm, s storage.Interface) *ShopQuery

func (*ShopQuery) GetMerchantId 

func (s *ShopQuery) GetMerchantId(shopId int64) int64

GetMerchantId 获取商户编号

func (*ShopQuery) PagedOnBusinessOnlineShops 

func (s *ShopQuery) PagedOnBusinessOnlineShops(begin, end int, where string,
	order string) (int, []*dto.ListOnlineShop)

PagedOnBusinessOnlineShops 获取营业中的店铺列表

func (*ShopQuery) QueryShopIdByHost 

func (s *ShopQuery) QueryShopIdByHost(host string) (shopId int64)

QueryShopIdByHost 根据主机查询商店编号

type StatisticsQuery added in v0.4.10 

type StatisticsQuery struct {
	db.Connector

	Storage storage.Interface
	// contains filtered or unexported fields
}

func NewStatisticsQuery added in v0.4.10 

func NewStatisticsQuery(o orm.Orm, s storage.Interface) *StatisticsQuery

func (*StatisticsQuery) QuerySummary added in v0.4.10 

func (s *StatisticsQuery) QuerySummary() *SummaryStatistics

QuerySummary 查询汇总信息

type SummaryStatistics added in v0.4.10 

type SummaryStatistics struct {
	// 汇总总数
	TotalMembers int64 `db:"totalMembers"`
	// 今日注册会员数
	TodayJoinMembers int64 `db:"todayJoinMembers"`
	// 今日登录数
	TodayLoginMembers int64 `db:"todayLoginMembers"`
	// 今日新增订单数
	TodayCreateOrders int64 `db:"todayCreateOrders"`
	// 待发货订单数
	AwaitShipmentOrders int64 `db:"awaitShipmentOrders"`
	// 待审核提现申请数量
	AwaitReviewWithdrawRequests int64 `db:"awaitReviewWithdrawRequests"`
}

Source Files

View all Source files

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL
go.dev uses cookies from Google to deliver and enhance the quality of its services and to analyze traffic. Learn more.