def get_existing_pro_validated_user_with_validated_offerer_with_validated_user_offerer_with_thing_offer_with_stock_with_not_used_booking(
):
query = User.query.filter(User.validationToken == None)
query = filter_users_with_at_least_one_validated_offerer_validated_user_offerer(
query)
query = query.join(Venue).filter(Venue.offers.any(~Offer.stocks.any()))
query = query.join(Offer).join(Stock).filter(
Stock.bookings.any(Booking.isUsed == False))
user = query.first()
for uo in user.UserOfferers:
if not uo.isValidated or not uo.offerer.isValidated:
continue
for venue in uo.offerer.managedVenues:
for offer in [o for o in venue.offers if o.isThing]:
for stock in offer.stocks:
for booking in [b for b in stock.bookings if not b.isUsed]:
return {
"booking": get_booking_helper(booking),
"offer": get_offer_helper(offer),
"offerer": get_offerer_helper(uo.offerer),
"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_no_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).filter(
(Offer.type.in_([str(event_type) for event_type in EventType]))
& (~Offer.stocks.any())))
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.isEvent and len(offer.stocks) == 0:
return {
"offer": get_offer_helper(offer),
"offerer": get_offerer_helper(uo.offerer),
"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_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_no_iban_validated_user_offerer_with_event_offer(
):
query = User.query.filter(User.validationToken == None)
query = filter_users_with_at_least_one_validated_offerer_validated_user_offerer(
query)
query = query.filter(Offerer.bankInformation == None)
query = query.join(Venue).join(Offer).filter(
Offer.type.in_([str(thing_type) for thing_type in ThingType]))
query = query.filter(Venue.isVirtual == False)
user = query.first()
for uo in user.UserOfferers:
if not uo.isValidated or not uo.offerer.isValidated:
continue
if uo.offerer.iban:
continue
for venue in [v for v in uo.offerer.managedVenues if not v.isVirtual]:
for offer in venue.offers:
if offer.isEvent:
return {
"offer": get_offer_helper(offer),
"offerer": get_offerer_helper(uo.offerer),
"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_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_no_iban_validated_user_offerer_with_thing_offer_with_no_stock(
):
query = User.query.filter(User.validationToken == None)
query = filter_users_with_at_least_one_validated_offerer_validated_user_offerer(
query)
query = query.filter(Offerer.bankInformation == None)
query = query.join(Venue).filter(
Venue.offers.any(
(Offer.type.in_([str(thing_type) for thing_type in ThingType]))
& (~Offer.stocks.any())))
user = query.first()
for uo in user.UserOfferers:
if uo.validationToken == None and uo.offerer.validationToken == None and not uo.offerer.iban:
for venue in uo.offerer.managedVenues:
for offer in venue.offers:
if offer.isThing and len(
offer.stocks) == 0 and offer.isEditable:
return {
"offer": get_offer_helper(offer),
"offerer": get_offerer_helper(uo.offerer),
"user": get_pro_helper(user),
"venue": get_venue_helper(venue),
}
return None
def get_existing_pro_validated_user_with_at_least_one_visible_offer_with_no_mediation():
query = User.query.filter(User.validationToken == None)
query = filter_users_with_at_least_one_validated_offerer_validated_user_offerer(query)
query = query.join(Venue).join(Offer).join(Mediation)
user = query.first()
for uo in user.UserOfferers:
if uo.offerer.validationToken == None and uo.validationToken == None:
for venue in uo.offerer.managedVenues:
for offer in venue.offers:
if len(offer.mediations) == 0:
return {"offer": get_offer_helper(offer), "user": get_pro_helper(user)}
return None
def get_existing_pro_validated_user_with_at_least_one_visible_activated_offer(
):
user_offerer = offers_factories.UserOffererFactory(
validationToken=None,
offerer__validationToken=None,
user__validationToken=None,
)
venue = offers_factories.VirtualVenueFactory(
managingOfferer=user_offerer.offerer)
offer = offers_factories.OfferFactory(venue=venue, isActive=True)
return {
"offer": get_offer_helper(offer),
"user": get_pro_helper(user_offerer.user)
}
def get_non_free_event_offer():
query = get_non_free_offers_query_by_type()
offer = (
query.filter(Offer.type.in_([str(event_type) for event_type in EventType]))
.filter(Offer.mediations.any(Mediation.isActive == True))
.join(VenueSQLEntity, VenueSQLEntity.id == Offer.venueId)
.join(Offerer, Offerer.id == VenueSQLEntity.managingOffererId)
.filter(Offerer.validationToken == None)
.first()
)
if offer:
return {
"mediationId": [humanize(m.id) for m in offer.mediations if m.isActive][0],
"offer": get_offer_helper(offer),
}
return {}
def get_non_free_thing_offer_with_active_mediation():
query = get_non_free_offers_query_by_type()
offer = (query.filter(Offer.url == None).filter(
Stock.beginningDatetime == None).filter(
Offer.mediations.any(Mediation.isActive == True)).join(
Venue, Venue.id == Offer.venueId).join(
Offerer, Offerer.id == Venue.managingOffererId).filter(
Offerer.validationToken == None).first())
if offer:
return {
"mediationId":
[humanize(m.id) for m in offer.mediations if m.isActive][0],
"offer":
get_offer_helper(offer),
}
return {}
def get_existing_event_offer_with_active_mediation_already_booked_but_cancellable_and_user_hnmm_93(
):
offer_with_stock_id_tuples = (Offer.query.filter(
Offer.mediations.any(Mediation.isActive)).join(Stock).filter(
Stock.beginningDatetime != None).add_columns(Stock.id).all())
user = get_existing_webapp_hnmm_user()
bookings = get_cancellable_bookings_for_user(user)
offer = find_offer_compatible_with_bookings(offer_with_stock_id_tuples,
bookings)
for mediation in offer.mediations:
if mediation.isActive:
return {
"mediation": get_mediation_helper(mediation),
"offer": get_offer_helper(offer),
"user": get_beneficiary_helper(user),
}
return None
def get_existing_pro_validated_user_with_at_least_one_visible_offer():
query = User.query.filter(User.validationToken == None)
query = filter_users_with_at_least_one_validated_offerer_validated_user_offerer(
query)
query = query.join(Venue,
Venue.managingOffererId == Offerer.id).join(Offer)
user = query.first()
for uo in user.UserOfferers:
if uo.validationToken == None and uo.offerer.validationToken == None:
for venue in uo.offerer.managedVenues:
if venue.offers:
offer = venue.offers[0]
return {
"offer": get_offer_helper(offer),
"user": get_pro_helper(user)
}
return None
def get_existing_pro_validated_user_with_at_least_one_offer_with_at_least_one_thumbnail(
):
query = User.query.filter(User.validationToken == None)
query = filter_users_with_at_least_one_validated_offerer_validated_user_offerer(
query)
query = query.join(Venue).join(Offer).filter(Offer.isActive == True)
user = query.first()
for uo in user.UserOfferers:
if uo.offerer.validationToken == None and uo.validationToken == None:
for venue in uo.offerer.managedVenues:
for offer in venue.offers:
if offer.isActive and offer.activeMediation:
return {
"offer": get_offer_helper(offer),
"user": get_pro_helper(user)
}
return None
def get_existing_pro_validated_user_with_validated_offerer_with_iban_validated_user_offerer_with_event_offer_with_no_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)
return {
"offer": get_offer_helper(offer),
"offerer": get_offerer_helper(user_offerer.offerer),
"user": get_pro_helper(user_offerer.user),
"venue": get_venue_helper(venue),
}
def get_existing_digital_offer_with_active_mediation_already_booked_and_user_hnmm_93(
):
offer_with_stock_id_tuples = (Offer.query.outerjoin(Product).filter(
Offer.mediations.any(
Mediation.isActive)).filter(Product.url != None).join(
Stock,
(Offer.id == Stock.offerId)).add_columns(Stock.id).all())
user = get_existing_webapp_hnmm_user()
bookings = get_cancellable_bookings_for_user(user)
offer = find_offer_compatible_with_bookings(offer_with_stock_id_tuples,
bookings)
for mediation in offer.mediations:
if mediation.isActive:
return {
"mediation": get_mediation_helper(mediation),
"offer": get_offer_helper(offer),
"user": get_beneficiary_helper(user),
}
return None
def get_non_free_event_offer():
query = get_non_free_offers_query_by_type()
offer = (query.filter(
Offer.subcategoryId.in_(subcategories.EVENT_SUBCATEGORIES)).filter(
Offer.mediations.any(Mediation.isActive == True)).filter(
Offer.isEducational == False).join(
Venue, Venue.id == Offer.venueId).join(
Offerer, Offerer.id == Venue.managingOffererId).filter(
Offerer.validationToken == None).first())
if offer:
return {
"mediationId":
[humanize(m.id) for m in offer.mediations if m.isActive][0],
"offer":
get_offer_helper(offer),
"stockCount":
len(offer.stocks),
}
return {}
def get_existing_pro_validated_user_with_validated_offerer_validated_user_offerer_with_event_offer(
):
query = User.query.filter(User.validationToken == None)
query = filter_users_with_at_least_one_validated_offerer_validated_user_offerer(
query)
query = query.join(VenueSQLEntity).join(Offer).filter(
Offer.type.in_([str(event_type) for event_type in EventType]))
user = query.first()
for uo in user.UserOfferers:
if uo.validationToken == None and uo.offerer.validationToken == None:
for venue in uo.offerer.managedVenues:
for offer in venue.offers:
if offer.isEvent:
return {
"offer": get_offer_helper(offer),
"offerer": get_offerer_helper(uo.offerer),
"user": get_pro_helper(user),
"venue": get_venue_helper(venue),
}
return None
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),
}
def get_non_free_digital_offer():
query = get_non_free_offers_query_by_type()
offer = query.filter(Offer.url != None).first()
return {"offer": get_offer_helper(offer)}
