dkforest

commit d235c3e6409594b4e76878580823cd97e0332c72
parent f4210833c2f7d7c00ccfccef092c8218cc806016
Author: n0tr1v <n0tr1v@protonmail.com>
Date:   Fri, 15 Dec 2023 20:20:07 -0500

admin

Diffstat:
M
pkg/database/tablePokerXmrTransactions.go
 | 
14
++++++++++++++
M
pkg/web/handlers/admin.go
 | 
3
+++
M
pkg/web/handlers/data.go
 | 
2
++
M
pkg/web/public/views/pages/admin/poker-transactions.gohtml
 | 
2
++

4 files changed, 21 insertions(+), 0 deletions(-)
diff --git a/pkg/database/tablePokerXmrTransactions.go b/pkg/database/tablePokerXmrTransactions.go
@@ -21,6 +21,20 @@ type PokerXmrTransaction struct {
 	User          User
 }
 
+func (d *DkfDB) GetPokerXmrTransactionsSumIn() (out Piconero, err error) {
+	return d.getPokerXmrTransactionsSum(true)
+}
+
+func (d *DkfDB) GetPokerXmrTransactionsSumOut() (out Piconero, err error) {
+	return d.getPokerXmrTransactionsSum(false)
+}
+
+func (d *DkfDB) getPokerXmrTransactionsSum(isIn bool) (out Piconero, err error) {
+	var tmp struct{ Amount Piconero }
+	err = d.db.Raw(`SELECT SUM(amount) AS amount FROM poker_xmr_transactions WHERE is_in = ?`, isIn).Scan(&tmp).Error
+	return tmp.Amount, err
+}
+
 func (d *DkfDB) GetLastUserWithdrawPokerXmrTransaction(userID UserID) (out PokerXmrTransaction, err error) {
 	err = d.db.Order("id DESC").First(&out, "user_id = ? AND is_in = 0", userID).Error
 	return
diff --git a/pkg/web/handlers/admin.go b/pkg/web/handlers/admin.go
@@ -486,6 +486,9 @@ func AdminPokerTransactionsHandler(c echo.Context) error {
 	res, _ := config.Xmr().GetBalance(&wallet1.RequestGetBalance{})
 	data.Balance = database.Piconero(res.Balance)
 	data.UnlockedBalance = database.Piconero(res.UnlockedBalance)
+	data.SumIn, _ = db.GetPokerXmrTransactionsSumIn()
+	data.SumOut, _ = db.GetPokerXmrTransactionsSumOut()
+	fmt.Println(data.SumOut)
 
 	if err := db.DB().
 		Table("poker_xmr_transactions").
diff --git a/pkg/web/handlers/data.go b/pkg/web/handlers/data.go
@@ -907,6 +907,8 @@ type adminPokerTransactionsData struct {
 	MaxPage           int64
 	Balance           database.Piconero
 	UnlockedBalance   database.Piconero
+	SumIn             database.Piconero
+	SumOut            database.Piconero
 }
 
 type adminSpamFiltersData struct {
diff --git a/pkg/web/public/views/pages/admin/poker-transactions.gohtml b/pkg/web/public/views/pages/admin/poker-transactions.gohtml
@@ -7,6 +7,8 @@
     Rake: {{ .Data.PokerCasino.Rake }} ({{ .Data.PokerCasino.Rake.ToPiconero.XmrStr }} xmr ~{{ .Data.PokerCasino.Rake.ToPiconero.UsdStr }})<br />
     Wallet balance: {{ .Data.Balance.XmrStr }} xmr ~{{ .Data.Balance.UsdStr }}<br />
     Wallet unlocked balance: {{ .Data.UnlockedBalance.XmrStr }} xmr ~{{ .Data.UnlockedBalance.UsdStr }}<br />
+    Sum ins: {{ .Data.SumIn.XmrStr }} xmr ~{{ .Data.SumIn.UsdStr }}<br />
+    Sum outs: {{ .Data.SumOut.XmrStr }} xmr ~{{ .Data.SumOut.UsdStr }}<br />
 </div>
 
 <table class="table table-striped table-sm table-novpadding table-dark">