menu/settingsmodel.go at main · spurtcms/menu · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
package menu

import (
	"errors"
	"fmt"

	"gorm.io/datatypes"
	"gorm.io/gorm"
)

type TblGoTemplateSettings struct {
	Id              int
	SiteName        string
	SiteLogo        string
	SiteLogoPath    string
	SiteFavIcon     string
	SiteFavIconPath string
	WebsiteUrl      string
	TenantId        string
	WebsiteId       int
	TemplateType    datatypes.JSON
	SocialMediaLink datatypes.JSON
	SocialLinks     []SocialLinks `gorm:"-"`
	HeaderThame     string
	TemplateID      string
}

type SocialLinks struct {
	Type      string
	IsActive  int
	SocialUrl string
}

func (menu *MenuModel) SettingDetail(tenantid string, websiteid int, DB *gorm.DB) (setting TblGoTemplateSettings, err error) {

	var SettingsDetail TblGoTemplateSettings

	if err := DB.Table("tbl_go_template_settings").Where("tenant_id = ? and website_id=?", tenantid, websiteid).First(&SettingsDetail).Error; err != nil {

		return TblGoTemplateSettings{}, err
	}

	return SettingsDetail, nil
}

func (menu *MenuModel) SettingDetailBasedONTemp(TemplateID string, tenantid string, websiteid int, DB *gorm.DB) (setting TblGoTemplateSettings, err error) {

	var SettingsDetail TblGoTemplateSettings

	if err := DB.Table("tbl_go_template_settings").Where("tenant_id = ? and website_id=? and template_id =?", tenantid, websiteid, TemplateID).First(&SettingsDetail).Error; err != nil {

		return TblGoTemplateSettings{}, err
	}

	return SettingsDetail, nil
}

func (menu *MenuModel) SettingsUpdates(settingsdetails TblGoTemplateSettings, DB *gorm.DB) (err error) {

	var settinglist TblGoTemplateSeo

	result := DB.Table("tbl_go_template_settings").Where("tenant_id = ? and website_id=? and template_id =?", settingsdetails.TenantId, settingsdetails.WebsiteId, settingsdetails.TemplateID).First(&settinglist)

	if result.Error != nil {

		if errors.Is(result.Error, gorm.ErrRecordNotFound) {

			if err := DB.Table("tbl_go_template_settings").Create(&settingsdetails).Error; err != nil {

				return err
			}
		}

	} else {

		if settingsdetails.SiteName != "" {
			fmt.Println("settingsdetails.SiteName ", settingsdetails.TemplateID, settingsdetails.HeaderThame)
			if err := DB.Debug().Table("tbl_go_template_settings").Where("tenant_id = ? and website_id=? and template_id =?", settingsdetails.TenantId, settingsdetails.WebsiteId, settingsdetails.TemplateID).UpdateColumns(map[string]interface{}{"site_name": settingsdetails.SiteName, "site_logo": settingsdetails.SiteLogo, "site_logo_path": settingsdetails.SiteLogoPath, "site_fav_icon": settingsdetails.SiteFavIcon, "site_fav_icon_path": settingsdetails.SiteFavIconPath, "header_thame": settingsdetails.HeaderThame}).Error; err != nil {

				return err

			}

		}

		if len(settingsdetails.SocialMediaLink) != 0 {

			if err := DB.Table("tbl_go_template_settings").Where("tenant_id = ? and website_id=? and template_id =?", settingsdetails.TenantId, settingsdetails.WebsiteId, settingsdetails.TemplateID).UpdateColumns(map[string]interface{}{"social_media_link": settingsdetails.SocialMediaLink}).Error; err != nil {

				return err

			}

		}

		if settingsdetails.TemplateType != nil && settingsdetails.WebsiteUrl != "" {

			if err := DB.Table("tbl_go_template_settings").Where("tenant_id = ? and website_id=? and template_id =?", settingsdetails.TenantId, settingsdetails.WebsiteId, settingsdetails.TemplateID).UpdateColumns(map[string]interface{}{"template_type": settingsdetails.TemplateType, "website_url": settingsdetails.WebsiteUrl}).Error; err != nil {

				return err

			}
		}
	}

	return nil
}