1 files changed, 126 insertions, 0 deletions
diff --git a/item/service.go b/item/service.go
new file mode 100644
index 0000000..c8a72f6
--- /dev/null
+++ b/item/service.go
@@ -0,0 +1,126 @@
+/* openbills - Server for web based Libre Billing Software
+ * Copyright (C) 2023  Vidhu Kant Sharma <vidhukant@vidhukant.com>
+ *
+ * This program is free software: you can redistribute it and/or modify
+ * it under the terms of the GNU General Public License as published by
+ * the Free Software Foundation, either version 3 of the License, or
+ * (at your option) any later version.
+ *
+ * This program is distributed in the hope that it will be useful,
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+ * GNU General Public License for more details.
+ *
+ * You should have received a copy of the GNU General Public License
+ * along with this program.  If not, see <https://www.gnu.org/licenses/>.
+ */
+
+package item
+
+import (
+	"vidhukant.com/openbills/errors"
+	e "vidhukant.com/openbills/errors"
+)
+
+func getBrandItems(items *[]SavedItem, id uint) error {
+	// check if id is valid
+	var count int64
+	err := db.Model(&Brand{}).
+		Select("id").
+		Where("id = ?", id).
+		Count(&count).
+		Error
+
+	if err != nil {
+		return err
+  }
+
+	if count == 0 {
+		return errors.ErrBrandNotFound
+	}
+
+	res := db.Model(&SavedItem{}).Where("brand_id = ?", id).Find(&items)
+
+	// TODO: handle potential errors
+	if res.Error != nil {
+		return res.Error
+	}
+
+	if res.RowsAffected == 0 {
+		return e.ErrEmptyResponse
+	}
+
+	return nil
+}
+
+func getBrands(brands *[]Brand) error {
+	res := db.Find(&brands)
+
+	// TODO: handle potential errors
+	if res.Error != nil {
+		return res.Error
+	}
+
+	if res.RowsAffected == 0 {
+		return e.ErrEmptyResponse
+	}
+
+	return nil
+}
+
+func (b *Brand) upsert() error {
+	res := db.Save(b)
+	// TODO: handle potential errors
+	return res.Error
+}
+
+func (b *Brand) del() error {
+	res := db.Delete(b)
+
+	// TODO: handle potential errors
+	if res.Error != nil {
+		return res.Error
+	}
+
+	if res.RowsAffected == 0 {
+		return e.ErrNotFound
+	}
+
+	return nil
+}
+
+func getItems(items *[]SavedItem) error {
+	res := db.Preload("Brand").Find(&items)
+
+	// TODO: handle potential errors
+	if res.Error != nil {
+		return res.Error
+	}
+
+	if res.RowsAffected == 0 {
+		return e.ErrEmptyResponse
+	}
+
+	return nil
+}
+
+func (i *SavedItem) upsert() error {
+	res := db.Save(i)
+	// TODO: handle potential errors
+	return res.Error
+}
+
+func (i *SavedItem) del() error {
+	res := db.Delete(i)
+
+	// TODO: handle potential errors
+	if res.Error != nil {
+		return res.Error
+	}
+
+	if res.RowsAffected == 0 {
+		return e.ErrNotFound
+	}
+
+	return nil
+}