printers/main.go

package main

import (
	"fmt"
	"github.com/boombuler/barcode"
	"github.com/boombuler/barcode/qr"
	"github.com/gorilla/mux"
	"gorm.io/driver/sqlite"
	"gorm.io/gorm"
	"html/template"
	"image"
	"image/png"
	"log"
	"net/http"
	"os"
	"strings"
)

func main() {

	r := mux.NewRouter()

	r.HandleFunc("/", PrinterList)
	r.HandleFunc("/generate", GenerateQR)
	r.HandleFunc("/addprinter", AddPrinter)
	r.HandleFunc("/addcartridge", AddCartridge)
	r.HandleFunc("/cartridgeOfPrinter", AddCartridgeOfPrinter)
	r.HandleFunc("/compatible", FindCompatibleCartridges)
	r.HandleFunc("/printer/{printerName}", PrinterPage)
	fmt.Println("Server is listening...")

	http.Handle("/", r)
	http.ListenAndServe(":8888", nil)
}

func PrinterPage(w http.ResponseWriter, r *http.Request) {
	db, err := gorm.Open(sqlite.Open("printer.db"), &gorm.Config{})

	if err != nil {
		fmt.Println("Error during opening DB")
	} else {
		name := mux.Vars(r)["printerName"]
		fmt.Println("Selected printer: " + name)
		var printer Printers
		db.Where("Name LIKE ?", name).First(&printer)

		var printers []Printers
		db.Find(&printers)
		fmt.Println(printers)
		fmt.Println(printer)
		if printer.Id > 0 {
			var cartridges []string
			var cot []Cartridgeofprinter
			db.Where("PrinterID = ?", printer.Id).Find(&cot)
			fmt.Println(cot)
			fmt.Println("Printer ID = ")
			fmt.Println(printer.Id)
			for _, v := range cot {
				var cart Cartridges
				if v.Cartridgeid != 0{
					fmt.Println(v.Cartridgeid)
					db.Where("ID = ?", v.Cartridgeid).First(&cart)
					cartridges = append(cartridges, cart.Name)
				}
			}

			data := Output{
				PrinterName: name,
				Cartridges:  cartridges,
			}

			tmpl, _ := template.ParseFiles("output.html")
			tmpl.Execute(w, data)
			// fmt.Fprintf(w, "Выбранный принтер: %v\n", name)
			// fmt.Fprintf(w, "Совместимые картриджи (" + string(len(cartridges)) + ")\n")
			// for _, cartridge := range cartridges{
			// 	fmt.Fprintf(w, cartridge)
			// }
		} else {
			http.Redirect(w, r, "https://www.youtube.com/watch?v=dQw4w9WgXcQ", 301)
		}
	}

	// w.Header().Set("Content-Disposition", fmt.Sprintf("attachment; filename=\"%s\"", name + ".png"))
	// var cartText = strings.Join(cartridgeName, "\n")
	// cartridgeQR(cartText, name)
	// http.ServeFile(w, r, name)
}

func FindCompatibleCartridges(w http.ResponseWriter, r *http.Request) {
	db, _ := gorm.Open(sqlite.Open("printer.db"), &gorm.Config{})

	var PrinterList []Printers
	db.Find(&PrinterList)
	var PrinterName []string
	for _, pr := range PrinterList {
		PrinterName = append(PrinterName, pr.Name)
	}

	var printer Printers
	r.ParseForm()
	selectedPrinter := strings.Join(r.Form["printer"], "")
	fmt.Println("Selected: " + selectedPrinter)

	if selectedPrinter != "" {
		db.Where("Name = ?", selectedPrinter).First(&printer)
		var cops []uint
		db.Table("CartridgeOfPrinters").Where("PrinterID = ?", printer.Id).Select("CartridgeID").Find(&cops)

		var cartridgeName []string

		for _, cop := range cops {
			var cart Cartridges
			db.Where("ID = ?", cop).First(&cart)
			cartridgeName = append(cartridgeName, cart.Name)
		}
		// data := ViewData{
		// Title: "Совместимость картриджей",
		// PrinterNames: PrinterName,
		// CartridgeNames: cartridgeName,
		// }

		http.Redirect(w, r, "/printer/"+selectedPrinter, 301)
		return
	}

	data := ViewData{
		Title:        "Совместимость картриджей",
		PrinterNames: PrinterName,
	}

	tmpl, _ := template.ParseFiles("compatible.html")
	tmpl.Execute(w, data)
}

func AddCartridgeOfPrinter(w http.ResponseWriter, r *http.Request) {
	db, _ := gorm.Open(sqlite.Open("printer.db"), &gorm.Config{})
	r.ParseForm()
	cartridgeName := strings.Join(r.Form["cartridges"], "")
	printerName := strings.Join(r.Form["printers"], "")
	// printerName := strings.Join(r.Form["printers"], "")
	var cartridge Cartridges
	db.Where("Name = ?", cartridgeName).First(&cartridge)
	cartridgeID := cartridge.Id
	var printer Printers
	db.Where("Name = ?", printerName).First(&printer)
	printerID := printer.Id
	var cop Cartridgeofprinter
	cop.Cartridgeid = cartridgeID
	cop.Printerid = printerID
	db.Create(&cop)
	http.Redirect(w, r, "/", 302)
}

func AddCartridge(w http.ResponseWriter, r *http.Request) {
	db, _ := gorm.Open(sqlite.Open("printer.db"), &gorm.Config{})
	r.ParseForm()
	text := strings.Join(r.Form["cartridgeName"], "")
	var newCartridge Cartridges
	newCartridge.Name = text
	db.Create(&newCartridge)
	http.Redirect(w, r, "/", 302)
}

func AddPrinter(w http.ResponseWriter, r *http.Request) {
	db, _ := gorm.Open(sqlite.Open("printer.db"), &gorm.Config{})
	r.ParseForm()
	text := strings.Join(r.Form["printerName"], "")
	var newPrinter Printers
	newPrinter.Name = text
	db.Create(&newPrinter)
	http.Redirect(w, r, "/", 302)
}

func GenerateQR(w http.ResponseWriter, r *http.Request) {
	r.ParseForm()
	text := strings.Join(r.Form["printer"], "")
	w.Header().Set("Content-Disposition", fmt.Sprintf("attachment; filename=\"%s\"", text+".png"))
	generateFromText(text)
	http.ServeFile(w, r, text)
}

func PrinterList(w http.ResponseWriter, r *http.Request) {
	db, _ := gorm.Open(sqlite.Open("printer.db"), &gorm.Config{})

	var PrinterList []Printers
	db.Find(&PrinterList)
	var PrinterName []string
	for _, pr := range PrinterList {
		PrinterName = append(PrinterName, pr.Name)
	}

	var CartridgeList []Cartridges
	db.Find(&CartridgeList)
	var CartridgeName []string
	for _, ca := range CartridgeList {
		CartridgeName = append(CartridgeName, ca.Name)
	}

	data := ViewData{
		Title:          "Generate QR",
		PrinterNames:   PrinterName,
		CartridgeNames: CartridgeName,
	}

	tmpl, _ := template.ParseFiles("generate.html")
	tmpl.Execute(w, data)
}

func generateCompatibleCartridges(printer Printers) {
	db, _ := gorm.Open(sqlite.Open("printer.db"), &gorm.Config{})
	var cops []Cartridgeofprinter
	var cartridges []Cartridges
	db.Where("Printerid = ?", printer.Id).Find(&cops)
	for _, cop := range cops {
		var cartridge Cartridges
		fmt.Println(cop.Cartridgeid)
		db.Where("ID = ?", cop.Cartridgeid).First(&cartridge)
		cartridges = append(cartridges, cartridge)
	}
}

func cartridgeQR(text string, filename string) {
	code, err := qr.Encode(text, qr.L, qr.Auto)
	if err != nil {
		fmt.Println("Something went wrong...")
	}
	if text != code.Content() {
		log.Fatal("data differs")
	}
	code, err = barcode.Scale(code, 512, 512)
	if err != nil {
		log.Fatal(err)
	}

	writePng(filename, code)
}

func generateFromText(text string) {
	code, err := qr.Encode(text, qr.L, qr.Auto)
	if err != nil {
		fmt.Println("Something went wrong...")
	}
	if text != code.Content() {
		log.Fatal("data differs")
	}
	code, err = barcode.Scale(code, 512, 512)
	if err != nil {
		log.Fatal(err)
	}

	writePng(text, code)
}

func writePng(filename string, img image.Image) {
	file, err := os.Create(filename)
	if err != nil {
		log.Fatal(err)
	}
	err = png.Encode(file, img)
	if err != nil {
		log.Fatal(err)
	}
	file.Close()
}