Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $query = "select
- operacao.id as operacao,
- round(sum(despesas.elegivel),2) as elegivel,
- round(sum(despesas.elegivel)*operacao.taxa_feder*0.01,2) as feder,
- round(sum(despesas.elegivel)-sum(despesas.elegivel)*coalesce(operacao.taxa_privado,0)*0.01,2) as despesa_publica,
- round(sum(despesas.elegivel)-sum(despesas.elegivel)*coalesce(operacao.taxa_privado,0)*0.01-sum(despesas.elegivel)*operacao.taxa_feder*0.01,2) as contra_partida_publica_nacional,
- round((sum(despesas.elegivel) * 0.01 * operacao.taxa_oe_cap) +
- (sum(despesas.elegivel) * 0.01 * operacao.taxa_oe_outros),2) as oe_executado,
- round((sum(despesas.elegivel) * 0.01 * operacao.taxa_admin_local),2) as al_executado,
- round((sum(despesas.elegivel) * 0.01 * operacao.taxa_empresa_publica),2) as ep_executado,
- round((sum(despesas.elegivel) * 0.01 * operacao.taxa_outros_publicas),2) as outras_executado,
- 0 as ra_executado,
- round(sum(despesas.elegivel) * coalesce(operacao.taxa_privado,0) * 0.01,2) as privado,
- round(sum(despesas.nao_elegivel),2) as nao_elegivel
- FROM
- ((
- SELECT
- despesa.operacao as operacao,
- view_despesa_validacao.valor_validado as elegivel,
- view_despesa_validacao.valor_validado_nao_elegivel as nao_elegivel
- FROM
- despesa
- inner join view_despesa_validacao on view_despesa_validacao.despesa = despesa.id
- where
- data_validacao is not null and
- data_validacao >= '".$data_inicio."' and data_validacao <= '".$data_fim."'
- )
- UNION ALL
- (
- SELECT
- despesa.operacao as operacao,
- despesa_reanalise.elegivel as elegivel,
- despesa_reanalise.nao_elegivel as nao_elegivel
- FROM
- despesa_reanalise
- inner join (
- select
- despesa_reanalise_estado.despesa_reanalise as id,
- min(despesa_reanalise_estado.created) as data
- from
- despesa_reanalise_estado
- where
- despesa_reanalise_estado.estado = 'validada'
- group by
- despesa_reanalise_estado.despesa_reanalise
- ) as estado on estado.id = despesa_reanalise.id
- inner join despesa on despesa.id = despesa_reanalise.despesa
- where
- estado.data <= '".$data_inicio."' and estado.data >= '".$data_fim."'
- )) as despesas
- inner join operacao on operacao.id = despesas.operacao
- group by
- operacao.id,
- operacao.taxa_feder,
- operacao.taxa_privado,
- operacao.taxa_oe_cap,
- operacao.taxa_oe_outros,
- operacao.taxa_admin_local,
- operacao.taxa_empresa_publica,
- operacao.taxa_outros_publicas
- ;";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement