def get_existing_pro_validated_user_with_validated_offerer_with_reimbursement(
):
query = (Payment.query.join(Booking).join(Stock).join(Offer).join(
Venue).join(Offerer).join(UserOfferer).filter(
(Offerer.validationToken == None)
& (UserOfferer.validationToken == None)).join(User).filter(
User.validationToken == None))
payment = query.first()
booking = payment.booking
stock = booking.stock
offer = stock.offer
venue = offer.venue
offerer = venue.managingOfferer
user = [
uo.user for uo in offerer.UserOfferers
if uo.user.validationToken == None
][0]
return {
"booking": get_booking_helper(booking),
"offer": get_offer_helper(offer),
"offerer": get_offerer_helper(offerer),
"payment": get_payment_helper(payment),
"stock": get_stock_helper(stock),
"user": get_pro_helper(user),
"venue": get_venue_helper(venue),
}
def get_existing_pro_validated_user_with_validated_offerer_with_iban_validated_user_offerer_with_thing_offer_with_stock(
):
query = User.query.filter(User.validationToken == None)
query = filter_users_with_at_least_one_validated_offerer_validated_user_offerer(
query)
query = query.join(BankInformation)
query = query.join(
VenueSQLEntity,
VenueSQLEntity.managingOffererId == Offerer.id).join(Offer).join(
Offer.stocks)
user = query.first()
for uo in user.UserOfferers:
if uo.validationToken == None and uo.offerer.validationToken == None and uo.offerer.iban:
for venue in uo.offerer.managedVenues:
for offer in venue.offers:
if offer.isThing and offer.stocks and offer.isEditable:
return {
"offer": get_offer_helper(offer),
"offerer": get_offerer_helper(uo.offerer),
"stock": get_stock_helper(offer.stocks[0]),
"user": get_pro_helper(user),
"venue": get_venue_helper(venue),
}
return None
def get_existing_pro_validated_user_with_validated_offerer_with_iban_validated_user_offerer_with_event_offer_with_stock(
):
query = User.query.filter(User.validationToken == None)
query = filter_users_with_at_least_one_validated_offerer_validated_user_offerer(
query)
query = query.join(BankInformation)
query = (query.join(
Venue,
Venue.managingOffererId == Offerer.id).join(Offer).join(Stock).filter(
(Stock.beginningDatetime != None)))
user = query.first()
for uo in user.UserOfferers:
if not uo.isValidated or not uo.offerer.isValidated:
continue
if not uo.offerer.iban:
continue
for venue in uo.offerer.managedVenues:
for offer in [o for o in venue.offers if o.isEvent]:
for stock in offer.stocks:
if stock.beginningDatetime:
return {
"offer": get_offer_helper(offer),
"offerer": get_offerer_helper(uo.offerer),
"stock": get_stock_helper(stock),
"user": get_pro_helper(user),
"venue": get_venue_helper(venue),
}
return None
def get_existing_pro_validated_user_with_validated_offerer_with_iban_validated_user_offerer_with_event_offer_with_stock(
):
user_offerer = offers_factories.UserOffererFactory(
validationToken=None,
offerer__validationToken=None,
user__validationToken=None,
)
offers_factories.BankInformationFactory(offerer=user_offerer.offerer)
venue = offers_factories.VirtualVenueFactory(
managingOfferer=user_offerer.offerer)
offer = offers_factories.EventOfferFactory(venue=venue, isActive=True)
stock = offers_factories.EventStockFactory(offer=offer)
return {
"offer": get_offer_helper(offer),
"offerer": get_offerer_helper(user_offerer.offerer),
"stock": get_stock_helper(stock),
"user": get_pro_helper(user_offerer.user),
"venue": get_venue_helper(venue),
}
def get_existing_pro_validated_user_with_validated_offerer_with_booking():
query = (Booking.query.join(Stock).join(Offer).join(VenueSQLEntity).join(
Offerer).join(UserOfferer).filter((Offerer.validationToken == None) & (
UserOfferer.validationToken == None)).join(User).filter(
User.validationToken == None))
booking = query.first()
stock = booking.stock
offer = stock.offer
venue = offer.venue
offerer = venue.managingOfferer
user = [
uo.user for uo in offerer.UserOfferers
if uo.user.validationToken == None
][0]
return {
"booking": get_booking_helper(booking),
"offer": get_offer_helper(offer),
"offerer": get_offerer_helper(offerer),
"stock": get_stock_helper(stock),
"user": get_pro_helper(user),
"venue": get_venue_helper(venue),
}