X-Git-Url: https://hackdaworld.org/gitweb/?p=outofuni%2Fgocash.git;a=blobdiff_plain;f=gocash.go;h=e9d37de8aa038e3b4badc2a5f800de2838895eb8;hp=276ac535e681dc2c5d363dce8b4fb6b323720f07;hb=HEAD;hpb=7bac337349d7f798f79ed6a9a27f460b26a25fa9

diff --git a/gocash.go b/gocash.go
index 276ac53..e9d37de 100644
--- a/gocash.go
+++ b/gocash.go
@@ -9,31 +9,6 @@ import (
 	"strconv"
 )
 
-//
-// hardcoded account ids we have to look at
-//
-// --- buy
-// wareneingang 19% and 7%
-const pid_buy_n = string("8e3b7c42e3173ed85f3d4736e82afb4d")
-const pid_buy_s = string("0cfd2ceb45fff89b9d1b7ce3af66cdf3")
-const pid_misc  = string("e3acc2865dbf931e41cf2b90240de5c2")
-const pid_rep   = string("b1d04ad157cac569f4299d4ddf94ed6f")
-const pid_room  = string("4394ed4ffa7266f8f8731080926a7a61")
-const pid_cap   = string("4196ee026d1bdb785df2c975fca91ae0")
-const aid_werbe = string("cb67d346eac01c2b66e2394df4e8d6e8")
-// abziehbare vst 19% and 7%
-const aid_vst_n = string("7c449e13125d6b93043f963628106db2")
-const aid_vst_s = string("006643c1c0a91f2b40614c75a49c6295")
-// --- sales
-// receipts
-const aid_rec_n = string("f3e905732b729ba096a50dab60559ce7")
-const aid_rec_s = string("66c1b04bd897766cb2be538094e1db6a")
-const aid_tip   = string("1d20024badc11a99a8e1cf3a9a64a501")
-const aid_dep   = string("9772f4e231f6f5e3100132cc53eb3447")
-// ust
-const aid_ust_n = string("e4bd6ff52408be8076f24aeb105893d9")
-const aid_ust_s = string("38bf40d16529f2a1e611c073c6c1dc9c")
-
 type inv_accnts struct {
 	id string
 	taxval int
@@ -41,9 +16,9 @@ type inv_accnts struct {
 	buy bool
 }
 
-// make these account data the only one, above p/aids redundant!
-// we have all the information in here!
-
+//
+// accounts considered in tax included balance check
+//
 var iaa []inv_accnts = []inv_accnts{
 // wareneingang 19% and 7% (note: pids!)
  { "8e3b7c42e3173ed85f3d4736e82afb4d",19,false,true },
@@ -68,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",
@@ -79,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
@@ -93,7 +98,6 @@ type amap struct {
 	taxval int // 7 or 19
 	buy bool // buy or sales
 	tax bool // tax or non-tax(=goods) account
-	rid []string // required transaction account(s)
 }
 
 // xml
@@ -178,60 +182,33 @@ func main() {
 	for ac := range data.Accnt {
 		aid := data.Accnt[ac].AccountId
 		pid := data.Accnt[ac].ParentId
-		// general map
-		rid := make ([]string,10,10)
-		accnt[aid]=amap{
-			pid,ac,0,false,false,rid,
-		}
-		rid[0]="NONE"
-		tmp := accnt[aid]
-		switch {
-		// ---- buy
-		//   -- goods
-		case pid == pid_buy_n || pid == pid_misc || pid == pid_rep || pid == pid_room || pid == pid_cap || aid == aid_werbe:
-			tmp.taxval=19
-			tmp.buy=true
-			rid[0]=aid_vst_n
-			accnt[aid]=tmp
-		case pid == pid_buy_s:
-			tmp.taxval=7
-			tmp.buy=true
-			rid[0]=aid_vst_s
-			accnt[aid]=tmp
-		//   -- tax
-		case aid == aid_vst_n:
-			tmp.taxval=19
-			tmp.buy=true
-			tmp.tax=true
-			rid=[]string{pid_buy_n,pid_misc,pid_rep,pid_room,pid_cap,aid_werbe,}
-			accnt[aid]=tmp
-		case aid == aid_vst_s:
-			tmp.taxval=7
-			tmp.buy=true
-			tmp.tax=true
-			rid[0]=pid_buy_s
-			accnt[aid]=tmp
-		// ---- sales ----
-		//   -- receipts
-		case aid == aid_rec_n || aid == aid_tip || aid == aid_dep:
-			tmp.taxval=19
-			rid[0]=aid_ust_n
-			accnt[aid]=tmp
-		case aid == aid_rec_s:
-			tmp.taxval=7
-			rid[0]=aid_ust_s
-			accnt[aid]=tmp
-		//   -- tax
-		case aid == aid_ust_n:
-			tmp.taxval=19
-			tmp.tax=true
-			rid=[]string{aid_rec_n,aid_tip,aid_dep,}
-			accnt[aid]=tmp
-		case aid == aid_ust_s:
-			tmp.taxval=7
-			tmp.tax=true
-			rid[0]=aid_rec_s
-			accnt[aid]=tmp
+		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,
+					taxval,
+					iaa[iac].buy,
+					iaa[iac].tax,
+				}
+				break
+			}
 		}
 	}
 
@@ -268,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 {
@@ -276,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)
@@ -323,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