thiagodiniz

# Application source #
######################
app/views/*/.tmp_*
tmp/**/*
/.bundle
/vendor/bundle
.rspec
.sass-cache/

# Logs and databases #

thiagodiniz

# -*- coding: utf-8 -*-
import io

import requests
from bs4 import NavigableString, BeautifulSoup
from docx import Document as DocxDocument
from docx.enum.text import WD_ALIGN_PARAGRAPH
from docx.shared import Cm, Pt, Mm
from docx.image.exceptions import UnrecognizedImageError
from lxml import etree

thiagodiniz

SELECT 
users.email, gateway_wallets.id as gateway_wallet_id,
count(payments.id) FILTER (WHERE total_amount_in_cents > 25000) AS payments_count_min,
count(payments.id) FILTER (WHERE total_amount_in_cents <= 25000) AS payments_count,
((count(payments.id) FILTER (WHERE total_amount_in_cents > 25000) * 8) +
(count(payments.id) FILTER (WHERE total_amount_in_cents <= 25000) * 3)) as cost
FROM payments
left outer join gateway_wallets on gateway_wallets.id = payments.gateway_wallet_id
left outer join users on users.id = gateway_wallets.user_id
where payments.aasm_state = 'pending'

thiagodiniz