Edit Bills

1 files changed, 147 insertions, 0 deletions

diff --git a/sqlite.go b/sqlite.go
index 45ec752..6641a0b 100644
--- a/sqlite.go
+++ b/sqlite.go
@@ -603,6 +603,21 @@ func GetMapId(id int, idm []IdMap) (int) {
 	fmt.Println(frame("",false))
 	*/
 
+func ShowItems(itms []billitem) (out []string) {
+	out = append(out, "SomeShit")
+	//doneinfo2 := ""
+	sumh,summ := 0.0, 0.0
+	cnt := 0
+	for _,itm := range itms {
+		out = append(out, fmt.Sprintf("  %s (%s)  - %v(h) - %v€",itm.Task,itm.Time,itm.Hours,itm.Money))
+		sumh += itm.Hours
+		summ += itm.Money
+		cnt += 1
+	}
+	out[0] =  fmt.Sprintf("Summary: %v Items, %v (h), %v€",cnt,sumh,summ)
+
+	return
+}
 
 func strings2items(tasks, times, hours, moneys string) (out []billitem) {
 	ta := String2StringArray(tasks, ";")
@@ -1022,6 +1037,30 @@ func AnalyzeTasks(in []Task) (count int, hours float64, duration string) {
 	return
 }
 
+// Returns a List of All Bills in id list and returns a slice of the corresponding ids ordered
+func GetBillList(in []int) ([]int, []string) {
+	var outids []int
+	var outstr []string
+
+	ins := strings.Trim(strings.Replace(fmt.Sprint(in), " ", " , ", -1), "[]")
+	que := fmt.Sprintf("SELECT id, identity, project FROM bills WHERE id IN (%s) ORDER BY date DESC", ins)
+	rows, err := db.Query(que)
+	checkErr(err)
+
+	var id,prj int
+	var name string
+
+	defer rows.Close()
+	for rows.Next() {
+		err = rows.Scan(&id, &name, &prj)
+		checkErr(err)
+		outids = append(outids, id)
+		pro, cust := getProjectName(prj)
+		outstr = append(outstr, fmt.Sprintf("%s - %s for %s",name, pro, cust))
+	}
+	return outids, outstr
+}
+
 func getProjectList(in []int) ([]int, []string) {
 	var outids []int
 	var outstr []string
@@ -1147,6 +1186,23 @@ func GetTaskIds() []int {
 	}
 	return ids
 }
+
+// Returns slice of ids of all Bills
+func GetBillIds() []int {
+	var ids []int
+	rows, err := db.Query("SELECT id FROM bills") // ORDER BY id DESC")
+	checkErr(err)
+	var id int
+
+	defer rows.Close()
+	for rows.Next() {
+		err = rows.Scan(&id)
+		checkErr(err)
+		ids = append(ids, id)
+	}
+	return ids
+}
+
 // Returns Slice of All Bills 
 func GetAllBills() (out []bill) {
 	//var ids []int
@@ -1789,6 +1845,97 @@ func editCustomer(id int) {
 	fmt.Println(frame("",false))
 }
 
+func editBill(id int) {
+	boldGreen := color.New(color.FgGreen, color.Bold).SprintFunc()
+	boldRed := color.New(color.FgRed, color.Bold).SprintFunc()
+	fmt.Println(frame(boldGreen("Edit Bill ", id),true))
+	var prj int
+	var dat, pai time.Time
+	var ident,timran, taskstr, timesstr, hoursstr, moneysstr, datstr, paistr string
+	rows, err := db.Query("SELECT identity, timerange, project, tasks, times, hours, moneys, paid, date FROM bills WHERE id = $1", id)
+	checkErr(err)
+	if rows.Next() {
+		err = rows.Scan(&ident, &timran, &prj, &taskstr, &timesstr, &hoursstr, &moneysstr, &pai, & dat)
+	} else {
+		fmt.Println(nli,boldRed("There Is No Bill"), id)
+		return
+		//os.Exit(0)
+	}
+	rows.Close() //good habit to close
+	ident = getNewInterInput("New Bill Identifier: ", ident, nli)
+	timran = getNewInterInput("New Timerange:", timran, nli)
+
+	paistr = pai.Local().Format("2006-01-02 15:04")
+	datstr = dat.Local().Format("2006-01-02 15:04")
+	for {
+		newdatstr := getNewInterInput("New Date: ", datstr, nli)
+		if !isDateTime(newdatstr) {
+			fmt.Println(nli, newdatstr, boldRed("is Not a Valid Timestring!"), "use: 'YYYY-MM-DD HH:MM'")
+		} else {
+			datstr = newdatstr
+			break
+		}
+	}
+	for {
+		newpaistr := getNewInterInput("New Paid date: ", paistr, nli)
+		if !isDateTime(newpaistr) {
+			fmt.Println(nli, newpaistr, boldRed("is Not a Valid Timestring!"), "use: 'YYYY-MM-DD HH:MM'")
+		} else {
+			paistr = newpaistr
+			break
+		}
+	}
+	for {
+		fmt.Printf("%s  !!Setting a different project id will not change the corresponding Tasks.\n%s  Delete Bill to renew Task selection!!\n",nli,nli)
+		newprj := getNewInterInput("New Project id: ", fmt.Sprint(prj), nli)
+		prj, err = strconv.Atoi(newprj)
+		if err != nil {
+			fmt.Println(nli,newprj, boldRed("is Not a Valid id."), "Try an Integer instead")
+		}
+		if !isProject(prj) {
+			fmt.Println(nli, boldRed("There is no project"), prj)
+		} else {
+			break
+		}
+	}
+	fmt.Println(sli,"Current Items:")
+	itms := strings2items(taskstr,timesstr,hoursstr,moneysstr)
+	fmt.Println(StrLines(ShowItems(itms),nli))
+
+	if isInterSure(sli+"Do You Want to edit them?") {
+		for i,_ := range itms {
+			itms[i].Task = getNewInterInput("New Task: ", itms[i].Task, nli)
+			itms[i].Time = getNewInterInput("New Timerange: ", itms[i].Time, nli)
+			for {
+				hourstr := getNewInterInput("New Hours: ", fmt.Sprintf("%.2f(h)", itms[i].Hours), nli)
+				itms[i].Hours, err = strconv.ParseFloat(hourstr, 64)
+				if err != nil {
+					fmt.Println(nli,hourstr, boldRed("can not be Parsed as a Float."), "Try a shape of X.X")
+				} else {
+					break
+				}
+			}
+			for {
+				monstr := getNewInterInput("New Sum: ", fmt.Sprintf("%.2f €", itms[i].Money), nli)
+				itms[i].Money, err = strconv.ParseFloat(monstr, 64)
+				if err != nil {
+					fmt.Println(nli,monstr, boldRed("can not be Parsed as a Float."), "Try a shape of X.X")
+				} else {
+					break
+				}
+			}
+		}
+	}
+	taskstr,timesstr,hoursstr,moneysstr = items2strings(itms)
+	stmt, err := db.Prepare("UPDATE bills SET identity = ?, timerange = ?, project = ?, tasks = ?, times = ?, hours = ?, moneys = ?, paid = datetime(?,'utc'), date = datetime(?,'utc') WHERE id = ?")
+	checkErr(err)
+	_, err = stmt.Exec(ident,timran, prj, taskstr, timesstr, hoursstr, moneysstr, paistr, datstr, id)
+	checkErr(err)
+	fmt.Println(nli,"...Bill", id, "Updated")
+	fmt.Println(frame("",false))
+}
+
+
 func editTask(id int) {
 	boldGreen := color.New(color.FgGreen, color.Bold).SprintFunc()
 	boldRed := color.New(color.FgRed, color.Bold).SprintFunc()