Guest User

Untitled

a guest
Jul 19th, 2018
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.97 KB | None | 0 0
  1. // Este select está perfeito
  2. SELECT sum(sales.value_debit) AS value_debit,
  3. sum(sales.value_released) AS value_released,
  4. sum(sales.value_financed) AS value_financed,
  5. sum(sales.value_debit) AS value_debit,
  6. sum(sales.value_installment) AS value_installment,
  7. count(*) AS sales,
  8. 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,
  9. `convenets`.`operation_id`
  10. FROM `sales`
  11. INNER JOIN `convenets` ON `convenets`.`id` = `sales`.`convenet_id`
  12. INNER JOIN `operations` AS `op` ON `convenets`.`operation_id` = `op`.`id`
  13. WHERE `convenets`.`deleted_at` IS NULL
  14. AND `convenets`.`operation_id` IN (1,2,3,4,5)
  15. AND `sales`.`deleted_at` IS NULL
  16. GROUP BY `convenets`.`operation_id`
  17.  
  18.  
  19. // SE EU ADICIONAR
  20. esse INNER JOIN `convenets_receipt_settings` AS `cr` ON `convenets`.`id` = `cr`.`id`
  21.  
  22. Ele altera todos os resultados do selec anterior.
Add Comment
Please, Sign In to add comment