Added support for more client details in server

2 files changed, 34 insertions, 19 deletions

diff --git a/server/database/database.go b/server/database/database.go
index 0499b68..68c3c76 100644
--- a/server/database/database.go
+++ b/server/database/database.go
@@ -13,6 +13,14 @@ import (
   _ "github.com/mattn/go-sqlite3"
 )
 
+type Address struct {
+  AddressLine string
+  City        string
+  State       string
+  PINCode     string
+  Country     string
+}
+
 var myDatabase *sql.DB
 func InitDB() {
   myDatabase, _ = sql.Open("sqlite3", "./openbills.db")
@@ -33,10 +41,12 @@ func InitDB() {
   init_people, _ := myDatabase.Prepare(
     `CREATE TABLE IF NOT EXISTS People
     (id INTEGER PRIMARY KEY AUTOINCREMENT,
-    Name     TEXT,
-    Address  TEXT,
-    Phone    TEXT,
-    Email    TEXT)`,
+    Name        TEXT,
+    Phone       TEXT,
+    Email       TEXT,
+    BillAddress BLOB,
+    ShipAddress BLOB,
+    GSTIN       TEXT)`,
   )
   init_people.Exec()
 
diff --git a/server/database/people.go b/server/database/people.go
index 4817139..25aa393 100644
--- a/server/database/people.go
+++ b/server/database/people.go
@@ -7,34 +7,39 @@
 */
 
 // handles all People related database functions
-
-package database
+package database 
 
 import (
   _ "github.com/mattn/go-sqlite3"
 )
+
+
+
 type Person struct {
-  ID      int
-  Name    string
-  Address string
-  Phone   string
-  Email   string
+  ID          int
+  Name        string
+  Phone       string
+  Email       string
+  BillAddress Address
+  ShipAddress Address
+  GSTIN       string
 }
 
 func GetAllPeople() []Person {
   var allPeople []Person
-  rows, _ := myDatabase.Query(
-    `SELECT ID, Name, Address, Phone, Email FROM People`,
+  rows, _ := myDatabase.Query (
+    `SELECT ID, Name, Phone, Email, BillAddress, ShipAddress, GSTIN FROM People`,
   )
 
   var (
     id int
-    name, address, phone, email string
+    name, phone, email, gstin string
+    billAddress, shipAddress Address
   )
 
   for rows.Next() {
-    rows.Scan(&id, &name, &address, &phone, &email)
-    allPeople = append(allPeople, Person{id, name, address, phone, email})
+    rows.Scan(&id, &name, &phone, &email, &billAddress, &shipAddress, &gstin)
+    allPeople = append(allPeople, Person{id, name, phone, email, billAddress, shipAddress, gstin})
   }
 
   return allPeople
@@ -43,12 +48,12 @@ func GetAllPeople() []Person {
 func RegisterPerson(person Person) bool {
   register_person, _ := myDatabase.Prepare(
     `INSERT INTO People
-    (Name, Address, Phone, Email)
-    VALUES (?, ?, ?, ?)`,
+    (Name, Phone, Email, BillAddress, ShipAddress, GSTIN)
+    VALUES (?, ?, ?, ?, ?, ?)`,
   )
 
   register_person.Exec(
-    person.Name, person.Address, person.Phone, person.Email,
+    person.Name, person.Phone, person.Email, person.BillAddress, person.ShipAddress, person.GSTIN,
   )
 
   return true