// Package postgre
/**
 * @ File:
 * @ Date: 2021/4/13 10:46
 * @ Author: JYQ
 * @ Description:
 */
package postgre

type PGShop struct {
}

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

	return
}

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

	return
}

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

	return
}

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

	return
}

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

	return
}

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

	return
}

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

	return
}

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

	return
}

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

	return
}

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

	return
}

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

	return
}

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

	return
}

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

	return
}

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

	return
}

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

	return
}

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

	return
}

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

	return
}

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

	return
}

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

	return
}

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

	return
}

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

	return
}

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

	return
}

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

	return
}

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

	return
}

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

	return
}

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

	return
}

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

	return
}

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

	return
}

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

	return
}

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

	return
}

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

	return
}

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

	return
}

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

	return
}

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

	return
}

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

	return
}

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

	return
}

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

	return
}

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

	return
}

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

	return
}

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

	return
}

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

	return
}

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

	return
}

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

	return
}