Base/assembly/base/repository/postgre/order.go

// Package postgre
/**
 * @ File:
 * @ Date: 2021/5/4 11:26
 * @ Author: JYQ
 * @ Description:
 */
package postgre

type PGOrder struct {
}

func (PGOrder) OrderListQueryByManager(optUserId int64, objectShopId int64, jsonStr string, verfStr string) (result string, err error) {
	err = getClient().Raw("select fn_order_list_query_by_manager(? ,? ,?, ? )", optUserId, objectShopId, jsonStr, verfStr).
		Scan(&result).Error

	return
}

func (PGOrder) OrderAddByManager(optUserId int64, objectShopId int64, jsonStr string, verfStr string) (result string, err error) {
	err = getClient().Raw("select fn_order_add_by_manager(? ,? ,?, ? )", optUserId, objectShopId, jsonStr, verfStr).
		Scan(&result).Error

	return
}

func (PGOrder) OrderCancelByManager(optUserId int64, objectShopId int64, jsonStr string, verfStr string) (result string, err error) {
	err = getClient().Raw("select fn_order_cancel_by_manager(? ,? ,?, ? )", optUserId, objectShopId, jsonStr, verfStr).
		Scan(&result).Error

	return
}

func (PGOrder) OrderStatistics(optUserId int64, objectShopId int64, jsonStr string, verfStr string) (result string, err error) {
	err = getClient().Raw("select fn_order_statistics(? ,? ,?, ? )", optUserId, objectShopId, jsonStr, verfStr).
		Scan(&result).Error

	return
}

func (PGOrder) ClassOrderQuery(optUserId int64, objectShopId int64, jsonStr string, verfStr string) (result string, err error) {
	err = getClient().Raw("select fn_order_class_order_query(? ,? ,?, ? )", optUserId, objectShopId, jsonStr, verfStr).
		Scan(&result).Error

	return
}

func (PGOrder) VipUserOrderQuery(optUserId int64, objectShopId int64, jsonStr string, verfStr string) (result string, err error) {
	err = getClient().Raw("select fn_order_vip_user_order_query_by_manager(? ,? ,?, ? )", optUserId, objectShopId, jsonStr, verfStr).
		Scan(&result).Error

	return
}

func (PGOrder) UserOrderQueryByStd(optUserId int64, objectShopId int64, jsonStr string, verfStr string) (result string, err error) {
	err = getClient().Raw("select fn_order_user_order_query_by_std(? ,? ,?, ? )", optUserId, objectShopId, jsonStr, verfStr).
		Scan(&result).Error

	return
}