query

package
v0.8.0 Latest Latest
Warning

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

Go to latest
Published: Jan 12, 2026 License: GPL-2.0 Imports: 40 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 (C) 2007-2024 fze.NET, All rights reserved. *
  • name: payment_query.go
  • author: jarrysix (jarrysix#gmail.com)
  • date: 2024-09-09 08:29:05
  • 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 AdvertisementQuery

type AdvertisementQuery struct {
	fw.BaseRepository[ad.Ad]
	// contains filtered or unexported fields
}

func NewAdvertisementQuery

func NewAdvertisementQuery(o fw.ORM) *AdvertisementQuery

func (*AdvertisementQuery) QueryPagingAdList

func (a *AdvertisementQuery) QueryPagingAdList(p *fw.PagingParams) (*fw.PagingResult, error)

func (*AdvertisementQuery) QueryPagingPositions

func (a *AdvertisementQuery) QueryPagingPositions(p *fw.PagingParams) (*fw.PagingResult, error)

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

	fw.BaseRepository[content.Article]
	// contains filtered or unexported fields
}

func NewContentQuery

func NewContentQuery(o orm.Orm, fo fw.ORM, mq *MerchantQuery, mmq *MemberQuery, mchRepo merchant.IMerchantRepo) *ContentQuery

func (*ContentQuery) PagedArticleList

func (c *ContentQuery) PagedArticleList(p *fw.PagingParams) (ret *fw.PagingResult, err error)

func (*ContentQuery) QueryCategoryIdList

func (c *ContentQuery) QueryCategoryIdList(s []string) []int

查询分类编号列表

func (*ContentQuery) QueryMerchantArticles

func (c *ContentQuery) QueryMerchantArticles(mchId int, p *fw.PagingParams) (*fw.PagingResult, error)

QueryMerchantArticles 查询商户文章列表

func (*ContentQuery) QueryPagingArticleCategories

func (c *ContentQuery) QueryPagingArticleCategories(p *fw.PagingParams) (*fw.PagingResult, error)

func (*ContentQuery) QueryPagingArticles

func (c *ContentQuery) QueryPagingArticles(p *fw.PagingParams) (*fw.PagingResult, error)

系统查询文章列表

func (*ContentQuery) QueryPagingPages

func (c *ContentQuery) QueryPagingPages(p *fw.PagingParams) (*fw.PagingResult, error)

系统查询页面列表

func (*ContentQuery) QueryRecommendArticles

func (c *ContentQuery) QueryRecommendArticles(p *fw.PagingParams) (*fw.PagingResult, error)

type DivideOrderInfo

type DivideOrderInfo struct {
	TradeNo       string
	Amount        int
	DividedAmount int
	CreateTime    int
	DivideStatus  int
}

type InvoiceQuery

type InvoiceQuery struct {
	// contains filtered or unexported fields
}

func NewInvoiceQuery

func NewInvoiceQuery(o fw.ORM) *InvoiceQuery

func (*InvoiceQuery) GetInvoiceTitle

func (i *InvoiceQuery) GetInvoiceTitle(id int) *invoice.InvoiceTitle

GetInvoiceTitle 获取发票抬头

func (*InvoiceQuery) GetMemberTenantId

func (i *InvoiceQuery) GetMemberTenantId(memberId int) int

GetMemberTenantId 获取会员的租户ID

func (*InvoiceQuery) GetMerchantTenantId

func (i *InvoiceQuery) GetMerchantTenantId(mchId int) int

GetMerchantTenantId 获取商户的租户ID

func (*InvoiceQuery) GetTitles

func (i *InvoiceQuery) GetTitles(tenantId int) []*invoice.InvoiceTitle

GetTitles 获取发票抬头

func (*InvoiceQuery) QueryMerchantIssueInvoices

func (i *InvoiceQuery) QueryMerchantIssueInvoices(p *fw.PagingParams) (*fw.PagingResult, error)

func (*InvoiceQuery) QueryPagingInvoiceTitles

func (i *InvoiceQuery) QueryPagingInvoiceTitles(p *fw.PagingParams) (*fw.PagingResult, error)

QueryPagingInvoiceTitles 查询发票抬头分页

func (*InvoiceQuery) QueryPagingInvoices

func (i *InvoiceQuery) QueryPagingInvoices(p *fw.PagingParams) (*fw.PagingResult, error)

QueryPagingInvoices 查询发票分页

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

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

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

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

func (ItemQuery) GetPagingOnShelvesItemForWholesale

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

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

QueryItemSalesHistory 查询商品销售记录

func (*ItemQuery) SearchItem

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

	fw.BaseRepository[member.Member]
	// contains filtered or unexported fields
}

func NewMemberQuery

func NewMemberQuery(o orm.Orm, fo fw.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) GetMemberExtraField

func (m *MemberQuery) GetMemberExtraField(memberId int64) *member.ExtraField

GetMemberExtraField 获取会员扩展字段

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) QueryMemberBlockList

func (m *MemberQuery) QueryMemberBlockList(p *fw.PagingParams) (*fw.PagingResult, error)

QueryMemberBlockList 查询会员拉黑列表

func (*MemberQuery) QueryMemberList

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

获取会员列表

func (*MemberQuery) QueryPagingCertifications

func (m *MemberQuery) QueryPagingCertifications(p *fw.PagingParams) (*fw.PagingResult, error)

QueryPagingCertifications 查询会员认证列表

func (*MemberQuery) QueryPagingLevels

func (m *MemberQuery) QueryPagingLevels(p *fw.PagingParams) (*fw.PagingResult, error)

QueryPagingLevels 查询会员等级列表

func (*MemberQuery) QueryPagingMemberBalanceLogs

func (m *MemberQuery) QueryPagingMemberBalanceLogs(memberId int, p *fw.PagingParams) (*fw.PagingResult, error)

func (*MemberQuery) QueryPagingMemberIntegralLogs

func (m *MemberQuery) QueryPagingMemberIntegralLogs(memberId int, p *fw.PagingParams) (*fw.PagingResult, error)

func (*MemberQuery) QueryPagingMemberList

func (m *MemberQuery) QueryPagingMemberList(p *fw.PagingParams) (*fw.PagingResult, error)

QueryPagingMemberList 查询会员列表

func (*MemberQuery) QueryPagingMemberWalletLogs

func (m *MemberQuery) QueryPagingMemberWalletLogs(memberId int, p *fw.PagingParams) (*fw.PagingResult, error)

func (*MemberQuery) QueryPagingStaffs

func (m *MemberQuery) QueryPagingStaffs(p *fw.PagingParams) (*fw.PagingResult, error)

QueryPagingStaffs 查询商户员工列表

type MerchantQuery

type MerchantQuery struct {
	db.Connector
	fw.ORM
	Storage storage.Interface

	AuthRepo fw.BaseRepository[merchant.Authenticate]
	// contains filtered or unexported fields
}

func NewMerchantQuery

func NewMerchantQuery(c gof.App, fo fw.ORM, staffRepo staff.IStaffRepo,
	approvalRepo approval.IApprovalRepository,
	mchRepo merchant.IMerchantRepo,
	walletRepo wallet.IWalletRepo,
) *MerchantQuery

func (*MerchantQuery) GetBill

func (m *MerchantQuery) GetBill(id int) *merchant.MerchantBill

获取商户月度账单

func (*MerchantQuery) GetMerchantAuthenticate

func (m *MerchantQuery) GetMerchantAuthenticate(mchId int, version int) *merchant.Authenticate

GetMerchantAuthenticate 查询商户的认证信息

func (*MerchantQuery) GetStaffTransferInfo

func (m *MerchantQuery) GetStaffTransferInfo(staffId int64) (ret struct {
	TxId            int                     `json:"txId"`
	StaffName       string                  `json:"staffName"`
	MchName         string                  `json:"mchName"`
	TransferMchName string                  `json:"transferMchName"`
	CreateTime      int                     `json:"createTime"`
	ApprovalLogs    []*approval.ApprovalLog `json:"approvalLogs"`
})

GetStaffTransferInfo 获取转商户信息

func (*MerchantQuery) QueryMerchantByName

func (m *MerchantQuery) QueryMerchantByName(name string) []map[string]interface{}

QueryMerchantByName 根据商户名称查询商户信息

func (*MerchantQuery) QueryMerchantIdByHost

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

根据主机查询商户编号

func (*MerchantQuery) QueryMerchantList

func (m *MerchantQuery) QueryMerchantList(begin, size int) []*merchant.Merchant

QueryMerchantList 查询商户列表

func (*MerchantQuery) QueryMerchantPendingStaffs

func (m *MerchantQuery) QueryMerchantPendingStaffs(p *fw.PagingParams) (*fw.PagingResult, error)

QueryPagingStaffs 查询商户待认证员工列表(商户端)

func (*MerchantQuery) QueryOfflineStaffList

func (m *MerchantQuery) QueryOfflineStaffList(beginTime, overTime int, begin, size int) []*staff.Staff

查询离线员工列表

func (*MerchantQuery) QueryPagingAuthenticates

func (m *MerchantQuery) QueryPagingAuthenticates(p *fw.PagingParams) (_ *fw.PagingResult, err error)

查询分页商户待审核记录

func (*MerchantQuery) QueryPagingBillItems

func (m *MerchantQuery) QueryPagingBillItems(billId int, p *fw.PagingParams) (*fw.PagingResult, error)

查询商户月度账单明细

func (*MerchantQuery) QueryPagingBills

func (m *MerchantQuery) QueryPagingBills(p *fw.PagingParams) (*fw.PagingResult, error)

查询商户月度账单

func (*MerchantQuery) QueryPagingMerchantList

func (m *MerchantQuery) QueryPagingMerchantList(p *fw.PagingParams) (_ *fw.PagingResult, err error)

QueryPagingMerchantList 查询分页的商户列表(完整信息)

func (*MerchantQuery) QueryPagingMerchants

func (m *MerchantQuery) QueryPagingMerchants(p *fw.PagingParams) (_ *fw.PagingResult, err error)

QueryPagingMerchants 查询分页的商户列表(基本信息)

func (*MerchantQuery) QueryPagingStaffs

func (m *MerchantQuery) QueryPagingStaffs(p *fw.PagingParams) (*fw.PagingResult, error)

查询商户员工列表

func (*MerchantQuery) QueryTransferStaffs

func (m *MerchantQuery) QueryTransferStaffs(mchId int, transferType int, p *fw.PagingParams) (*fw.PagingResult, error)

查询商户员工转商户信息

func (*MerchantQuery) QueryWaitGenerateDailyBills

func (m *MerchantQuery) QueryWaitGenerateDailyBills(size int, lastId int) []*merchant.MerchantBill

QueryWaitGenerateDailyBills 查询待生成日度账单的商户

func (*MerchantQuery) QueryWaitGenerateMonthBillMerchants

func (m *MerchantQuery) QueryWaitGenerateMonthBillMerchants(billTime int64, begin, size int) (rst []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

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

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

QueryPagingNormalOrder 查询分页普通订单

type PagingArticleDto

type PagingArticleDto struct {
	Id           int                    `json:"id"`
	CatId        int                    `json:"catId"`
	Title        string                 `json:"title"`
	ShortTitle   string                 `json:"shortTitle"`
	Flag         int                    `json:"flag"`
	Thumbnail    string                 `json:"thumbnail"`
	PublisherId  int                    `json:"publisherId"`
	Location     string                 `json:"location"`
	Priority     int                    `json:"priority"`
	MchId        int                    `json:"mchId"`
	Tags         string                 `json:"tags"`
	LikeCount    int                    `json:"likeCount"`
	DislikeCount int                    `json:"dislikeCount"`
	ViewCount    int                    `json:"viewCount"`
	SortNum      int                    `json:"sortNum"`
	CreateTime   int                    `json:"createTime"`
	UpdateTime   int                    `json:"updateTime"`
	Ext          map[string]interface{} `json:"ext"`
}

type PaymentQuery

type PaymentQuery struct {
	fw.ORM
	// contains filtered or unexported fields
}

func NewPaymentQuery

func NewPaymentQuery(o fw.ORM) *PaymentQuery

func (*PaymentQuery) GetPayDivide

func (p *PaymentQuery) GetPayDivide(divideId int) *payment.PayDivide

func (*PaymentQuery) GetPaymentOrder

func (p *PaymentQuery) GetPaymentOrder(payId int) *payment.Order

GetPaymentOrder 获取支付单

func (*PaymentQuery) GetSubMerchant

func (p *PaymentQuery) GetSubMerchant(subType int, mchId int) *payment.PayMerchant

GetSubMerchant 获取子商户

func (*PaymentQuery) QueryAwaitSubmitDivides

func (p *PaymentQuery) QueryAwaitSubmitDivides(unix int64, size int) ([]*payment.PayDivide, error)

查询待提交的分账记录

func (*PaymentQuery) QueryDivideOrders

func (p *PaymentQuery) QueryDivideOrders(memberId int, orderType int) []*DivideOrderInfo

查询可分账的支付订单

func (*PaymentQuery) QueryPagingSubMerchant

func (p *PaymentQuery) QueryPagingSubMerchant(params *fw.PagingParams) (*fw.PagingResult, error)

QueryPagingSubMerchant 分页查询入网商户

func (*PaymentQuery) QueryRefundableRechargeOrders

func (p *PaymentQuery) QueryRefundableRechargeOrders(memberId int) []*RefundableRechargeOrder

QueryRefundableRechargeOrders 查询可退款的充值订单

type RefundableRechargeOrder

type RefundableRechargeOrder struct {
	// 支付单ID
	PayId int `json:"-"`
	// 订单号
	TradeNo string `json:"tradeNo"`
	// 可退金额
	RefundableAmount int `json:"refundableAmount"`
}

可退款充值订单

type ServiceStatistics

type ServiceStatistics struct {
	Date   string  `json:"date"`
	Count  int     `json:"count"`
	Amount float64 `json:"amount"`
	Users  int     `json:"users"`
}

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 StationArea

type StationArea struct {
	// 编号
	Id int `db:"id" pk:"yes" auto:"yes" json:"id" bson:"id"`
	// Name
	Name string `db:"name" json:"name" bson:"name"`
	// 状态: 0: 待开通  1: 已开通  2: 已关闭
	Stations []SubStation `db:"stations" json:"stations" bson:"stations"`
}

站点区域

type StationQuery

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

func NewStationQuery

func NewStationQuery(o orm.Orm) *StationQuery

站点查询

func (*StationQuery) QueryGroupStations

func (s *StationQuery) QueryGroupStations(status int) map[string][]SubStation

QueryGroupStations 按字母分组查询站点列表

func (*StationQuery) QueryStations

func (s *StationQuery) QueryStations(status int) []*StationArea

QueryStations 查询站点列表

type StatisticsQuery

type StatisticsQuery struct {
	db.Connector

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

func NewStatisticsQuery

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

func (*StatisticsQuery) QueryCityMerchantStaffs

func (s *StatisticsQuery) QueryCityMerchantStaffs() (rows []*struct {
	StationId int    `json:"stationId"`
	Label     string `json:"label"`
	Value     int    `json:"value"`
})

QueryCityMerchantStaffs 查询城市商户员工统计信息(前十)

func (*StatisticsQuery) QueryServiceStatistics

func (s *StatisticsQuery) QueryServiceStatistics(beginTime, endTime int) []*ServiceStatistics

QueryServiceStatistics 查询服务统计信息

func (*StatisticsQuery) QuerySummary

func (s *StatisticsQuery) QuerySummary() *SummaryStatistics

QuerySummary 查询汇总信息

type SubStation

type SubStation struct {
	// 编号
	Id int `db:"id" pk:"yes" auto:"yes" json:"id" bson:"id"`
	// Name
	Name string `db:"name" json:"name" bson:"name"`
	// 城市编号
	CityCode int `db:"city_code" json:"cityCode" bson:"cityCode"`
	// 状态: 0: 待开通  1: 已开通  2: 已关闭
	Status int `db:"status" json:"status" bson:"status"`
	// 首字母
	Letter string `db:"letter" json:"-" bson:"letter"`
	// 是否热门
	IsHot int `db:"is_hot" json:"isHot" bson:"isHot"`
	// 上级
	Parent int `db:"parent" json:"-" bson:"-"`
}

SubStation 地区子站

type SummaryStatistics

type SummaryStatistics struct {
	// 汇总总数
	TotalMembers int64 `db:"totalMembers" json:"totalMembers"`
	// 今日注册会员数
	TodayJoinMembers int64 `db:"todayJoinMembers" json:"todayJoinMembers"`
	// 今日登录数
	TodayLoginMembers int64 `db:"todayLoginMembers" json:"todayLoginMembers"`
	// 今日新增订单数
	TodayCreateOrders int64 `db:"todayCreateOrders" json:"todayCreateOrders"`
	// 待发货订单数
	AwaitShipmentOrders int64 `db:"awaitShipmentOrders" json:"awaitShipmentOrders"`
	// 待审核提现申请数量
	AwaitReviewWithdrawRequests int64 `db:"awaitReviewWithdrawRequests" json:"awaitReviewWithdrawRequests"`
	// 商户总数
	TotalMerchants int `db:"totalMerchants" json:"totalMerchants"`
	// 待审核商户
	AwaitApproveMerchants int `db:"awaitApproveMerchants" json:"awaitApproveMerchants"`
	// 新增商户员工
	TotalMerchantStaffs int `db:"totalMerchantStaffs" json:"totalMerchantStaffs"`
	// 待审核商户员工
	AwaitApproveStaffs int `db:"awaitApproveStaffs" json:"awaitApproveStaffs"`
	// 今日商户服务数
	TodayMchServiceCount int `db:"todayMchServiceCount" json:"todayMchServiceCount"`
	// 今日商户服务金额
	TodayMchServiceAmount int `db:"todayMchServiceAmount" json:"todayMchServiceAmount"`
}

type SystemQuery

type SystemQuery struct {
	// contains filtered or unexported fields
}

func NewSystemQuery

func NewSystemQuery(orm fw.ORM) *SystemQuery

func (*SystemQuery) GetSysLog

func (s *SystemQuery) GetSysLog(id int) *sys.SysLog

GetSysLog 获取系统日志

func (*SystemQuery) QueryAppDistribution

func (s *SystemQuery) QueryAppDistribution(params *fw.PagingParams) (*fw.PagingResult, error)

QueryAppDistribution 查询应用分发

func (*SystemQuery) QueryAppVersion

func (s *SystemQuery) QueryAppVersion(params *fw.PagingParams) (*fw.PagingResult, error)

QueryAppVersion 查询应用版本

func (*SystemQuery) QueryIndustries

func (s *SystemQuery) QueryIndustries(parentId string) []*sys.GeneralOption

QueryIndustries 查询行业数据

func (*SystemQuery) QueryPagingSysLog

func (s *SystemQuery) QueryPagingSysLog(params *fw.PagingParams) (*fw.PagingResult, error)

QuerySysLog 查询系统日志

type WalletQuery

type WalletQuery struct {
	// contains filtered or unexported fields
}

func NewWalletQuery

func NewWalletQuery(o fw.ORM) *WalletQuery

func (*WalletQuery) GetWalletId

func (m *WalletQuery) GetWalletId(userId int, walletType int) int

func (*WalletQuery) QueryMerchantPagingAccountLog

func (m *WalletQuery) QueryMerchantPagingAccountLog(walletId int, p *fw.PagingParams) (*fw.PagingResult, error)

QueryPagingAccountLog 查询商户账户钱包明细

func (*WalletQuery) QueryMonthCarryAmount

func (m *WalletQuery) QueryMonthCarryAmount(walletId int, unix int) int

查询月度总收入金额

func (*WalletQuery) QueryTotalCarryAmount

func (m *WalletQuery) QueryTotalCarryAmount(walletId int) int

查询总收入金额

type WorkQuery

type WorkQuery struct {
	fw.BaseRepository[workorder.Workorder]
	// contains filtered or unexported fields
}

func NewWorkQuery

func NewWorkQuery(orm fw.ORM) *WorkQuery

func (*WorkQuery) FindWorkorderByWIP

func (q *WorkQuery) FindWorkorderByWIP(wip string) *workorder.Workorder

根据工单号查找工单

func (*WorkQuery) QueryLatestWorkorderComments

func (q *WorkQuery) QueryLatestWorkorderComments(workorderId int, p *fw.PagingParams) []*workorder.WorkorderComment

查询工单最新评论

func (*WorkQuery) QueryMemberPagingWorkOrder

func (q *WorkQuery) QueryMemberPagingWorkOrder(memberId int, p *fw.PagingParams) (*fw.PagingResult, error)

查询会员的提交的工单

func (*WorkQuery) QueryPagingWorkorderComments

func (q *WorkQuery) QueryPagingWorkorderComments(workorderId int, p *fw.PagingParams) (*fw.PagingResult, error)

查询会员工单评论

func (*WorkQuery) QueryPagingWorkorders

func (q *WorkQuery) QueryPagingWorkorders(p *fw.PagingParams) (*fw.PagingResult, error)

查询工单列表

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL