Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- // Este select está perfeito
- SELECT sum(sales.value_debit) AS value_debit,
- sum(sales.value_released) AS value_released,
- sum(sales.value_financed) AS value_financed,
- sum(sales.value_debit) AS value_debit,
- sum(sales.value_installment) AS value_installment,
- count(*) AS sales,
- sum(if(op.base_reports = 1, sales.value_released, 0) + if(op.base_reports = 2, sales.value_financed, 0) + if(op.base_reports = 3, sales.value_installment, 0)) AS value_base,
- `convenets`.`operation_id`
- FROM `sales`
- INNER JOIN `convenets` ON `convenets`.`id` = `sales`.`convenet_id`
- INNER JOIN `operations` AS `op` ON `convenets`.`operation_id` = `op`.`id`
- WHERE `convenets`.`deleted_at` IS NULL
- AND `convenets`.`operation_id` IN (1,2,3,4,5)
- AND `sales`.`deleted_at` IS NULL
- GROUP BY `convenets`.`operation_id`
- // SE EU ADICIONAR
- esse INNER JOIN `convenets_receipt_settings` AS `cr` ON `convenets`.`id` = `cr`.`id`
- Ele altera todos os resultados do selec anterior.
Add Comment
Please, Sign In to add comment