True Wallet Feature

Run this sql script in SQL Lab on Superset

Find bookings with true wallet payment

SELECT reservations.id, restaurants.id restaurant_id, restaurant_translations.name, service_type
from reservations
join restaurants on restaurants.id = reservations.restaurant_id
join restaurant_translations on restaurants.id = restaurant_translations.restaurant_id
WHERE true_wallet_provider = "gb_primepay" 
AND reservations.id > 2880000 
AND reservations.active = 0 AND ack = 1
AND is_temporary = 0
AND restaurant_translations.locale = 'en'
ORDER BY reservations.id desc