Třídová akce

Kód:

3

Tělo:

SELECT
  SUM(A.amount) AS Amount, SUM(A.localamount) AS LocalAmount
FROM
  CashReceived A
WHERE
  A.CashDesk_ID = :CashDeskID

UNION ALL

SELECT
  -SUM(A.amount) AS Amount, -SUM(A.localamount) AS LocalAmount
FROM
  RefundedCashReceived A
WHERE
  A.CashDesk_ID = :CashDeskID
  
UNION ALL

SELECT
  -SUM(A.amount) AS Amount, -SUM(A.localamount) AS LocalAmount
FROM
  CashPaid A  
WHERE
  A.CashDesk_ID = :CashDeskID
  
UNION ALL

SELECT
  SUM(A.amount) AS Amount, SUM(A.localamount) AS LocalAmount
FROM
  RefundedCashPaid A
WHERE
  A.CashDesk_ID = :CashDeskID
  
UNION ALL

SELECT
  0.00 AS Amount, SUM(A.Amount) AS LocalAmount
FROM
  CashDeskExchangeDifferences A
WHERE
  A.CashDesk_ID = :CashDeskID AND
  A.Profit = 'A'
  
UNION ALL

SELECT
  0.00 AS Amount, -SUM(A.Amount) AS LocalAmount
FROM
  CashDeskExchangeDifferences A
WHERE
  A.CashDesk_ID = :CashDeskID AND
  A.Profit = 'N'
  

Generated by ABRA Software a.s. 27.10.2021 16:34:08