X-Git-Url: https://www.hackdaworld.org/gitweb/?p=outofuni%2Fgocash.git;a=blobdiff_plain;f=gocash.go;h=e9d37de8aa038e3b4badc2a5f800de2838895eb8;hp=5b999ee194a479b9dc0662c87a709c60da4f04f2;hb=HEAD;hpb=ee8f0fb10c55cd0aff3427c3ede1be60a76df3b7

diff --git a/gocash.go b/gocash.go
index 5b999ee..e9d37de 100644
--- a/gocash.go
+++ b/gocash.go
@@ -17,7 +17,7 @@ type inv_accnts struct {
 }
 
 //
-// account data --- add accounts to consider here!
+// accounts considered in tax included balance check
 //
 var iaa []inv_accnts = []inv_accnts{
 // wareneingang 19% and 7% (note: pids!)
@@ -43,9 +43,23 @@ var iaa []inv_accnts = []inv_accnts{
  { "38bf40d16529f2a1e611c073c6c1dc9c", 7,true,false },
 }
 
-// transacion exception list
-var trn_exc = []string{
+//
+// account exceptions
+//
+// account exceptions: nineteen to seven
+var n2s_exc = []string{
+}
+// account exceptions: nineteen to zero
+var n2z_exc = []string{
+	"4970 Nebenkosten des",
+	"4910 Porto",
+}
+// transaction exceptions: nineteen to seven
+var n2s_exc_ta = []string{
 	"GEMA",
+}
+// transaction exceptions: nineteen to zero
+var n2z_exc_ta = []string{
 	"Deutsche Post",
 	"gesetz IHK",
 	"Gesundheitsbelehrung",
@@ -54,11 +68,27 @@ var trn_exc = []string{
 	"ENTGELT SPK",
 	"ttenrecht und F",
 	"Unterrichtung Gastst",
+	"MPLC",
 }
 
-// account exception list
-var account_exc = []string{
-	"4970 Nebenkosten des",
+// transacion exception list --- the rest, required?
+var trn_exc = []string{
+}
+
+//
+// accounts which will be summed up
+//
+
+type sum_accnt struct {
+	name string
+	aid string
+	valplus int
+	valminus int
+}
+
+var summed_accounts = []sum_accnt{
+	{"Bankkonto","02ea930fdcc500cf7d3a21b80a126eb0",0,0},
+	{"Kasse","04e71353130ccb554ebaf4c2438d6b2f",0,0},
 }
 
 // account maps
@@ -155,10 +185,25 @@ func main() {
 		for iac := range iaa {
 			// consider account if pid or aid matches
 			if pid == iaa[iac].id || aid == iaa[iac].id {
+				taxval := iaa[iac].taxval
+				for ec := range n2s_exc {
+					if strings.Contains(data.Accnt[ac].Name,
+					                    n2s_exc[ec]) {
+						taxval=7
+						break
+					}
+				}
+				for ec := range n2z_exc {
+					if strings.Contains(data.Accnt[ac].Name,
+					                    n2z_exc[ec]) {
+						taxval=0
+						break
+					}
+				}
 				accnt[aid]=amap{
 					pid,
 					ac,
-					iaa[iac].taxval,
+					taxval,
 					iaa[iac].buy,
 					iaa[iac].tax,
 				}
@@ -200,6 +245,16 @@ func main() {
 	                            -tax_report.SalesTax[1]);
 	fmt.Println("------------------------------------")
 
+	// summed accounts
+	fmt.Println("")
+	fmt.Println("Summen einiger Konten:")
+	fmt.Println("----------------------")
+	for sac := range summed_accounts {
+		saccnt := summed_accounts[sac]
+		fmt.Println(" Konto: ",saccnt.name)
+		fmt.Println("     +: ",saccnt.valplus)
+		fmt.Println("     -: ",saccnt.valminus)
+	}
 }
 
 func check_balance(ta *Transaction,accnt map[string]amap,sel_date string) bool {
@@ -208,20 +263,60 @@ func check_balance(ta *Transaction,accnt map[string]amap,sel_date string) bool {
 	tdate := strings.Fields(ta.Date)[0]
 	if !strings.Contains(tdate,sel_date) {
 		return true
-	} else {
+	}
+
+	// exceptions
+	tv_ow := -1
+	for ec := range n2s_exc_ta {
+		if strings.Contains(ta.Description,n2s_exc_ta[ec]) {
+			tv_ow=7
+			break
+		}
+	}
+	for ec := range n2z_exc_ta {
+		if strings.Contains(ta.Description,n2z_exc_ta[ec]) {
+			tv_ow=0
+			break
+		}
 	}
 
 	// [taxval: 19=0 7=1][tax: no=0 yes=1][buy: no=0 yes=1]
 	var sum [2][2][2]int
 
+	// loop over splits within the transaction
 	for sc := range ta.Spl {
 		aid := ta.Spl[sc].AccountId
 		//accnt[aid].tax
+		// loop over all considered accounts (defined earlier as global)
 		for iac := range iaa {
-			// taxval
 			tv := int(0)
-			if iaa[iac].taxval == 7 {
-				tv = 1
+			// taxval changed by exception
+			if tv_ow != -1 {
+				if tv_ow == 7 {
+					tv=1
+				}
+				if tv_ow == 0 {
+					// reset taxvalues of involved accounts
+					// (to drop an error)
+					if accnt[aid].tax {
+						if accnt[aid].taxval==7 {
+							tv=1
+						}
+					} else {
+						continue
+					}
+				}
+			// taxval as defined by account
+			} else {
+				if accnt[aid].taxval == 0 {
+					if accnt[aid].tax {
+						fmt.Println("FATAL!");
+					}
+					continue
+				}
+				if accnt[aid].taxval == 7 {
+					tv = 1
+				}
 			}
 			// tax
 			tax := int(0)
@@ -255,6 +350,17 @@ func check_balance(ta *Transaction,accnt map[string]amap,sel_date string) bool {
 				break
 			}
 		}
+		// now get the sums
+		for sac := range summed_accounts {
+			if summed_accounts[sac].aid == aid {
+				inc, _ := strconv.Atoi(strings.TrimSuffix(ta.Spl[sc].Value,"/100"))
+				if inc >= 0 {
+					summed_accounts[sac].valplus += inc
+				} else {
+					summed_accounts[sac].valminus += inc
+				}
+			}
+		}
 	}
 
 	// check for exceptions