main.go 8.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322
  1. package main
  2. import (
  3. "fmt"
  4. "github.com/boombuler/barcode"
  5. "github.com/boombuler/barcode/qr"
  6. "github.com/gorilla/mux"
  7. "gorm.io/driver/sqlite"
  8. "gorm.io/gorm"
  9. "html/template"
  10. "image"
  11. "image/png"
  12. "log"
  13. "net/http"
  14. "io/ioutil"
  15. "os"
  16. "strings"
  17. "math/rand"
  18. "time"
  19. )
  20. func init() {
  21. rand.Seed(time.Now().UnixNano())
  22. }
  23. var letterRunes = []rune("abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ")
  24. func main() {
  25. port := os.Getenv("PORT")
  26. r := mux.NewRouter()
  27. r.HandleFunc("/", PrinterList)
  28. r.HandleFunc("/generate", GenerateQR)
  29. r.HandleFunc("/generateCompatible", generateCompatible)
  30. r.HandleFunc("/addprinter", AddPrinter)
  31. r.HandleFunc("/addcartridge", AddCartridge)
  32. r.HandleFunc("/cartridgeOfPrinter", AddCartridgeOfPrinter)
  33. r.HandleFunc("/compatible", FindCompatibleCartridges)
  34. r.HandleFunc("/printer/{printerName}", PrinterPage)
  35. r.HandleFunc("/cartridges", CartridgePage)
  36. fmt.Println("Server is listening...")
  37. http.Handle("/", r)
  38. http.ListenAndServe(":" + port, nil)
  39. }
  40. func generateCompatible(w http.ResponseWriter, r *http.Request){
  41. fmt.Println("New generating request from" + r.RemoteAddr)
  42. data, err := ioutil.ReadAll(r.Body)
  43. if err != nil{
  44. fmt.Println("Something went wrong during generating QR code")
  45. fmt.Fprintf(w, "Something went wrong during generating QR code")
  46. }
  47. filename := GenerateRandomString(10)
  48. fmt.Println("Generated name " + filename + " for " + r.RemoteAddr)
  49. generateFromText(string(data), filename)
  50. fmt.Println("Generated file " + filename + ".png for " + r.RemoteAddr)
  51. w.Header().Set("Content-Disposition", fmt.Sprintf("attachment; filename=\"%s\"", filename +".png"))
  52. http.ServeFile(w, r, filename)
  53. fmt.Println("Served file " + filename + ".png for " + r.RemoteAddr)
  54. os.Remove(filename + ".png")
  55. fmt.Println("Removed file " + filename + ".png")
  56. }
  57. func CartridgePage(w http.ResponseWriter, r *http.Request){
  58. db, err := gorm.Open(sqlite.Open("printer.db"), &gorm.Config{})
  59. if err != nil {
  60. fmt.Println("Error during opening DB")
  61. } else {
  62. var cartridges []Cartridges
  63. db.Find(&cartridges)
  64. var names []string
  65. for _, v := range cartridges{
  66. name := v.Name + ": " + string(v.Quantity)
  67. names = append(names, name)
  68. }
  69. data := CartridgesOutput{
  70. Name: names,
  71. }
  72. tmpl, _ := template.ParseFiles("cartridges.html")
  73. tmpl.Execute(w, data)
  74. }
  75. }
  76. func PrinterPage(w http.ResponseWriter, r *http.Request) {
  77. db, err := gorm.Open(sqlite.Open("printer.db"), &gorm.Config{})
  78. if err != nil {
  79. fmt.Println("Error during opening DB")
  80. } else {
  81. name := mux.Vars(r)["printerName"]
  82. var printer Printers
  83. db.Where("Name = ?", name).First(&printer)
  84. var printers []Printers
  85. db.Find(&printers)
  86. fmt.Println(printer)
  87. if printer.ID > 0 {
  88. var cartridges []string
  89. var cot []Cartridgeofprinter
  90. db.Find(&cot)
  91. db.Where("Printer_Id = ?", printer.ID).Find(&cot)
  92. for _, v := range cot {
  93. var cart Cartridges
  94. if v.Printer_Id == printer.ID{
  95. db.Where("ID = ?", v.Cartridge_Id).First(&cart)
  96. cartridges = append(cartridges, cart.Name)
  97. }
  98. }
  99. data := Output{
  100. PrinterName: name,
  101. Cartridges: cartridges,
  102. }
  103. tmpl, _ := template.ParseFiles("output.html")
  104. tmpl.Execute(w, data)
  105. } else {
  106. http.Redirect(w, r, "https://www.youtube.com/watch?v=dQw4w9WgXcQ", 301)
  107. }
  108. }
  109. // w.Header().Set("Content-Disposition", fmt.Sprintf("attachment; filename=\"%s\"", name + ".png"))
  110. // var cartText = strings.Join(cartridgeName, "\n")
  111. // cartridgeQR(cartText, name)
  112. // http.ServeFile(w, r, name)
  113. }
  114. func FindCompatibleCartridges(w http.ResponseWriter, r *http.Request) {
  115. db, _ := gorm.Open(sqlite.Open("printer.db"), &gorm.Config{})
  116. var PrinterList []Printers
  117. db.Find(&PrinterList)
  118. var PrinterName []string
  119. for _, pr := range PrinterList {
  120. PrinterName = append(PrinterName, pr.Name)
  121. }
  122. // var printer Printers
  123. r.ParseForm()
  124. selectedPrinter := strings.Join(r.Form["printer"], "")
  125. if selectedPrinter != "" {
  126. // db.Where("Name = ?", selectedPrinter).First(&printer)
  127. // var cops []uint
  128. // db.Table("CartridgeOfPrinters").Where("PrinterID = ?", printer.ID).Select("CartridgeID").Find(&cops)
  129. // var cartridgeName []string
  130. // for _, cop := range cops {
  131. // var cart Cartridges
  132. // db.Where("ID = ?", cop).First(&cart)
  133. // cartridgeName = append(cartridgeName, cart.Name)
  134. // }
  135. // // data := ViewData{
  136. // // Title: "Совместимость картриджей",
  137. // // PrinterNames: PrinterName,
  138. // // CartridgeNames: cartridgeName,
  139. // // }
  140. http.Redirect(w, r, "/printer/"+selectedPrinter, 301)
  141. return
  142. }
  143. data := ViewData{
  144. Title: "Совместимость картриджей",
  145. PrinterNames: PrinterName,
  146. }
  147. tmpl, _ := template.ParseFiles("compatible.html")
  148. tmpl.Execute(w, data)
  149. }
  150. func AddCartridgeOfPrinter(w http.ResponseWriter, r *http.Request) {
  151. db, _ := gorm.Open(sqlite.Open("printer.db"), &gorm.Config{})
  152. r.ParseForm()
  153. cartridgeName := strings.Join(r.Form["cartridges"], "")
  154. printerName := strings.Join(r.Form["printers"], "")
  155. // printerName := strings.Join(r.Form["printers"], "")
  156. var cartridge Cartridges
  157. db.Where("Name = ?", cartridgeName).First(&cartridge)
  158. cartridgeID := cartridge.ID
  159. var printer Printers
  160. db.Where("Name = ?", printerName).First(&printer)
  161. printerID := printer.ID
  162. var cop Cartridgeofprinter
  163. cop.Cartridge_Id = cartridgeID
  164. cop.Printer_Id = printerID
  165. db.Create(&cop)
  166. http.Redirect(w, r, "/", 302)
  167. }
  168. func AddCartridge(w http.ResponseWriter, r *http.Request) {
  169. db, _ := gorm.Open(sqlite.Open("printer.db"), &gorm.Config{})
  170. r.ParseForm()
  171. text := strings.Join(r.Form["cartridgeName"], "")
  172. var newCartridge Cartridges
  173. newCartridge.Name = text
  174. db.Create(&newCartridge)
  175. http.Redirect(w, r, "/", 302)
  176. }
  177. func AddPrinter(w http.ResponseWriter, r *http.Request) {
  178. db, _ := gorm.Open(sqlite.Open("printer.db"), &gorm.Config{})
  179. r.ParseForm()
  180. text := strings.Join(r.Form["printerName"], "")
  181. var newPrinter Printers
  182. newPrinter.Name = text
  183. db.Create(&newPrinter)
  184. http.Redirect(w, r, "/", 302)
  185. }
  186. func GenerateQR(w http.ResponseWriter, r *http.Request) {
  187. r.ParseForm() // Получение имени принтера
  188. text := strings.Join(r.Form["printer"], "")
  189. GenerateFromWeb(w, r, text)
  190. }
  191. func GenerateFromWeb(w http.ResponseWriter, r *http.Request, printerName string){
  192. qrtext := "https://printers-ttit.herokuapp.com/printer/" + printerName // Генерация URL
  193. fmt.Println("Generating QR code with text: " + qrtext + " for " + r.RemoteAddr)
  194. filename := GenerateRandomString(10) // Генерация имени файла
  195. fmt.Println("Generated filename " + filename + " for " + r.RemoteAddr)
  196. err := generateFromText(qrtext, filename) // qrtext - текст в QR, filename - имя файла
  197. if err != nil{
  198. fmt.Println(err)
  199. }
  200. fmt.Println("Setting header Content-Disposition for " + r.RemoteAddr)
  201. w.Header().Set("Content-Disposition", fmt.Sprintf("attachment; filename=\"%s\"", filename +".png"))
  202. fmt.Println("Starting serving file for " + r.RemoteAddr)
  203. http.ServeFile(w, r, filename + ".png")
  204. }
  205. func generateFromText(text string, filename string) error{
  206. code, err := qr.Encode(text, qr.L, qr.Auto)
  207. if err != nil {
  208. return fmt.Errorf("Error during generating QR code")
  209. }
  210. if text != code.Content() {
  211. return fmt.Errorf("data differs")
  212. }
  213. code, err = barcode.Scale(code, 512, 512)
  214. if err != nil {
  215. return fmt.Errorf("Error during scaling QR code")
  216. }
  217. err = writePng(filename, code)
  218. if err != nil{
  219. return err
  220. }
  221. return nil
  222. }
  223. func writePng(filename string, img image.Image) error{
  224. file, err := os.Create(filename + ".png")
  225. if err != nil {
  226. return fmt.Errorf("Creating file error")
  227. }
  228. err = png.Encode(file, img)
  229. if err != nil {
  230. return fmt.Errorf("PNG file error")
  231. }
  232. file.Close()
  233. return nil
  234. }
  235. func GenerateRandomString(n int) string {
  236. b := make([]rune, n)
  237. for i := range b {
  238. b[i] = letterRunes[rand.Intn(len(letterRunes))]
  239. }
  240. return string(b)
  241. }
  242. func PrinterList(w http.ResponseWriter, r *http.Request) {
  243. db, _ := gorm.Open(sqlite.Open("printer.db"), &gorm.Config{})
  244. var PrinterList []Printers
  245. db.Find(&PrinterList)
  246. var PrinterName []string
  247. for _, pr := range PrinterList {
  248. PrinterName = append(PrinterName, pr.Name)
  249. }
  250. var CartridgeList []Cartridges
  251. db.Find(&CartridgeList)
  252. var CartridgeName []string
  253. for _, ca := range CartridgeList {
  254. CartridgeName = append(CartridgeName, ca.Name)
  255. }
  256. data := ViewData{
  257. Title: "Generate QR",
  258. PrinterNames: PrinterName,
  259. CartridgeNames: CartridgeName,
  260. }
  261. tmpl, _ := template.ParseFiles("generate.html")
  262. tmpl.Execute(w, data)
  263. }
  264. func cartridgeQR(text string, filename string) {
  265. code, err := qr.Encode(text, qr.L, qr.Auto)
  266. if err != nil {
  267. fmt.Println("Something went wrong...")
  268. }
  269. if text != code.Content() {
  270. log.Fatal("data differs")
  271. }
  272. code, err = barcode.Scale(code, 512, 512)
  273. if err != nil {
  274. log.Fatal(err)
  275. }
  276. writePng(filename, code)
  277. }