Changes between Version 27 and Version 28 of Напредни извештаи од базата (SQL и складирани процедури)

Timestamp:

02/24/25 16:17:18 (8 months ago)

Author:

222039

Comment:

--

Напредни извештаи од базата (SQL и складирани процедури)

@@ -239 +239 @@
     d.start_date DESC, TotalLoans DESC;
 }}}
+
+* π MemberName, Membership_Status, PeriodStart, PeriodEnd, TotalLoans, ActiveLoans, TotalFines, TotalFineAmount, TotalPaidAmount
+* (σ (DateRanges ⨯ Member ⨝ Users ⨝ (Loan ⨝ Fine ⨝ FinePayment))
+* (γ MemberName, Membership_Status, PeriodStart, PeriodEnd; COUNT(LoanID) AS TotalLoans, COUNT(CASE WHEN ReturnDate IS NULL THEN LoanID END) AS ActiveLoans, COUNT(FineID) AS TotalFines, SUM(FineAmount) AS TotalFineAmount, SUM(PaymentAmount) AS TotalPaidAmount)
+* (ORDER BY PeriodStart DESC, TotalLoans DESC)
+