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

type PGOrder struct {
}

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

	return
}

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

	return
}

func (PGOrder) OrderCancel(optUserId int64, objectShopId int64, jsonStr string, verfStr string) (result string, err error) {
	err = getClient().Raw("select fn_order_cancel(? ,? ,? )", 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) ClassListByOrderDate(optUserId int64, objectShopId int64, jsonStr string, verfStr string) (result string, err error) {
	err = getClient().Raw("select fn_class_list_by_order_date(? ,? ,? )", 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_vip_user_order_query(? ,? ,? )", optUserId, objectShopId, jsonStr, verfStr).
		Scan(&result).Error

	return
}