def summary(id): user = User.get_by_id(id) if current_user.id == user.id: images = Image.select().where(Image.user==id) donations = Donation.select().where(Donation.image.in_(images)) ttl = Donation.select(fn.SUM(Donation.amount).alias('total')).where(Donation.image.in_(images)) return render_template('checkouts/summary.html',donations=donations,ttl=ttl) return render_template('401.html'), 401
def total_donations(self): from models.donation import Donation total = 0 for donation in Donation.select().where(Donation.image_id == self.id): # where user_id == self.id TO SEE TOTAL DONATIONS A USER HAS RECEIVED total = total + donation.amount return round(total)
def total_donations(self): from models.donation import Donation total = 0 for donation in Donation.select().where(Donation.image_id == self.id): total = total + donation.amount return round(total)
def donation_received(self): from models.donation import Donation from models.image import Image donation_r = Donation.select().join( Image, on=(Donation.image_id == Image.id)).where(Image.user_id == self.id) donation_received = 0 for d in donation_r: donation_received = donation_received + d.amount donation_received = round(donation_received, 2) return donation_received
def show_image(username, image_id): image = Image.get_by_id(image_id) donations = Donation.select().join(Image).join(User).where( Image.id == image_id) total_donation = 0 for donation in donations: total_donation += donation.amount return render_template('users/image.html', image=image, donations=donations, total_donation=total_donation)
def top10(self): from models.donation import Donation return Donation.select().where(Donation.image == self.id).order_by( Donation.amount.desc()).limit(10)