From 8e7dec5dd1b4be5fd752acd6468d0cd801501e1f Mon Sep 17 00:00:00 2001
From: Nikolaus Gotsche <n@softwarefools.com>
Date: Fri, 3 May 2019 01:31:44 +0200
Subject: Edit Payments

---
 sqlite.go | 18 ++++++++++++++++++
 1 file changed, 18 insertions(+)

(limited to 'sqlite.go')

diff --git a/sqlite.go b/sqlite.go
index b9234b1..c24aae6 100644
--- a/sqlite.go
+++ b/sqlite.go
@@ -1815,6 +1815,24 @@ func setProject(nid int) {
 	showCurrentTask()
 }
 
+func GetPaymentList() (outint []int, outstr []string) {
+	rows, err := db.Query("SELECT id, customerid, amount, bills, date FROM payments")
+	checkErr(err)
+	var id, cuid int
+	var amt float64
+	var bills string
+	var dat time.Time
+
+	for rows.Next() {
+		err = rows.Scan(&id, &cuid, &amt, &bills, &dat)
+		checkErr(err)
+		cun := getCustomerName(cuid)
+		st := fmt.Sprintf("%v: (%s) %s : %.2f[€] - Bills: %s",id, dat.Local().Format("2006-01-02"),cun, amt,bills)
+		outint = append(outint, id)
+		outstr = append(outstr, st)
+	}
+	return
+}
 func getCustomerList() (outint []int, outstr []string) {
 	rows, err := db.Query("SELECT id, company, name FROM customers")
 	checkErr(err)
-- 
cgit v1.2.3