1 files changed, 18 insertions, 0 deletions
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)