OperationService/application/service/mini_video_config.go

package service

import (
	"ecos/application/domain/mini_video_config"
	"ecos/application/domain/traceability_video"
	"ecos/osm"
	"git.sxidc.com/go-framework/baize/convenient/entity_crud"
	"git.sxidc.com/go-framework/baize/framework/binding"
	"git.sxidc.com/go-framework/baize/framework/core/api"
	"git.sxidc.com/go-framework/baize/framework/core/api/request"
	"git.sxidc.com/go-framework/baize/framework/core/api/response"
	"git.sxidc.com/go-framework/baize/framework/core/application"
	"git.sxidc.com/go-framework/baize/framework/core/domain"
	"git.sxidc.com/go-framework/baize/framework/core/domain/entity"
	"git.sxidc.com/go-framework/baize/framework/core/infrastructure"
	"git.sxidc.com/go-framework/baize/framework/core/infrastructure/database"
	"git.sxidc.com/go-framework/baize/framework/core/infrastructure/database/sql"
	"git.sxidc.com/go-tools/utils/strutils"
	"github.com/pkg/errors"
)

var miniVideoConfigService = &MiniVideoConfigService{}

type MiniVideoConfigService struct{}

func (svc *MiniVideoConfigService) Init(appInstance *application.App) error {
	svc.v1(appInstance)
	return nil
}

func (svc *MiniVideoConfigService) Destroy() error {
	return nil
}

func (svc *MiniVideoConfigService) v1(appInstance *application.App) {
	v1Binder := binding.NewBinder(appInstance.ChooseRouter(api.RouterPrefix, "v1"),
		appInstance.Infrastructure())

	entity_crud.BindSimple[mini_video_config.Info](v1Binder, &entity_crud.Simple[mini_video_config.Info]{
		Entity:             &mini_video_config.Entity{},
		Schema:             dbSchema,
		CreateJsonBody:     &mini_video_config.CreateMiniVideoConfigJsonBody{},
		DeleteQueryParams:  &mini_video_config.DeleteMiniVideoConfigQueryParams{},
		UpdateJsonBody:     &mini_video_config.UpdateMiniVideoConfigJsonBody{},
		QueryQueryParams:   &mini_video_config.GetMiniVideoConfigsQueryParams{},
		GetByIDQueryParams: &mini_video_config.GetMiniVideoConfigQueryParams{},
	},
		entity_crud.WithQueryFormCustomConditionFunc[mini_video_config.Info](func(c *api.Context, params request.Params, e entity.Entity, i *infrastructure.Infrastructure) (*entity_crud.CustomCondition, error) {
			requestParams, err := request.ToConcrete[*mini_video_config.GetMiniVideoConfigsQueryParams](params)
			if err != nil {
				return nil, err
			}
			conditions := sql.NewConditions()
			if strutils.IsStringNotEmpty(requestParams.ComponentID) {
				conditions.Equal(mini_video_config.ColumnComponentID, requestParams.ComponentID)
			}
			if strutils.IsStringNotEmpty(requestParams.VideoTitle) {
				conditions.Equal(traceability_video.ColumnVideoTitle, "%"+requestParams.VideoTitle+"%")
			}
			return &entity_crud.CustomCondition{
				Conditions: conditions,
				OrderBy:    entity.ColumnCreatedTime + " DESC",
			}, nil
		}),
		entity_crud.WithCreateTx(),
		entity_crud.WithUpdateTx(),
		entity_crud.WithCreateCallbacks(&entity_crud.CreateCallbacks{
			Before: func(c *api.Context, params request.Params, e entity.Entity, prepared map[string]any, i *infrastructure.Infrastructure, tx database.Executor) error {
				requestParams, err := request.ToConcrete[*mini_video_config.CreateMiniVideoConfigJsonBody](params)
				if err != nil {
					return err
				}
				record, err := domain.ToConcrete[*mini_video_config.Entity](e)
				if err != nil {
					return err
				}
				if strutils.IsStringNotEmpty(requestParams.VideoCover) {
					newFilePath, err := osm.MultipleFileMv(requestParams.VideoCover)
					if err != nil {
						return err
					}
					record.VideoCover = newFilePath
				}
				if strutils.IsStringNotEmpty(requestParams.VideoUrl) {
					newFilePath, err := osm.MultipleFileMv(requestParams.VideoUrl)
					if err != nil {
						return err
					}
					record.VideoUrl = newFilePath
				}
				return nil
			},
		}),
		entity_crud.WithUpdateCallbacks(&entity_crud.UpdateCallbacks{
			Before: func(c *api.Context, params request.Params, e entity.Entity, prepared map[string]any, i *infrastructure.Infrastructure, tx database.Executor) error {
				requestParams, err := request.ToConcrete[*mini_video_config.UpdateMiniVideoConfigJsonBody](params)
				if err != nil {
					return err
				}

				record, err := domain.ToConcrete[*mini_video_config.Entity](e)
				if err != nil {
					return err
				}
				if strutils.IsStringNotEmpty(requestParams.VideoCover) {
					newFilePath, err := osm.MultipleFileMv(requestParams.VideoCover)
					if err != nil {
						return err
					}
					record.VideoCover = newFilePath
				}
				if strutils.IsStringNotEmpty(requestParams.VideoUrl) {
					newFilePath, err := osm.MultipleFileMv(requestParams.VideoUrl)
					if err != nil {
						return err
					}
					record.VideoUrl = newFilePath
				}
				return nil
			},
		}),
		entity_crud.WithGetByIDCallbacks(&entity_crud.GetByIDCallbacks[mini_video_config.Info]{
			OnSuccessReturn: func(c *api.Context, params request.Params, e entity.Entity, i *infrastructure.Infrastructure, output mini_video_config.Info) (mini_video_config.Info, error) {
				if strutils.IsStringNotEmpty(output.VideoCoverStr) {
					fileObjects, err := osm.MultipleFileUrl(output.VideoCoverStr)
					if err != nil {
						return output, err
					}
					output.VideoCover = fileObjects
				}
				if strutils.IsStringNotEmpty(output.VideoUrlStr) {
					fileObjects, err := osm.MultipleFileUrl(output.VideoUrlStr)
					if err != nil {
						return output, err
					}
					output.VideoUrl = fileObjects
				}
				return output, nil
			},
		}),
		entity_crud.WithQueryCallbacks(&entity_crud.QueryCallbacks[mini_video_config.Info]{
			OnSuccessReturn: func(c *api.Context, params request.Params, e entity.Entity, i *infrastructure.Infrastructure, output response.InfosData[mini_video_config.Info]) (response.InfosData[mini_video_config.Info], error) {
				infos := output.Infos
				for i1 := range infos {
					info := &infos[i1]
					if strutils.IsStringNotEmpty(info.VideoCoverStr) {
						fileObjects, err := osm.MultipleFileUrl(info.VideoCoverStr)
						if err != nil {
							if err != nil {
								return output, err
							}
						}
						info.VideoCover = fileObjects
					}

					if strutils.IsStringNotEmpty(info.VideoUrlStr) {
						fileObjects, err := osm.MultipleFileUrl(info.VideoUrlStr)
						if err != nil {
							return output, err
						}
						info.VideoUrl = fileObjects
					}
				}
				return output, nil
			},
		}),
	)

	binding.PutBind(v1Binder, &binding.SimpleBindItem[any]{
		Path:             "/miniVideoConfig/enabledOrDisable",
		SendResponseFunc: response.SendMsgResponse,
		RequestParams:    &mini_video_config.EnabledOrDisableJsonBody{},
		ServiceFunc: func(c *api.Context, params request.Params, objects []domain.Object, i *infrastructure.Infrastructure) (any, error) {
			requestParams, err := request.ToConcrete[*mini_video_config.EnabledOrDisableJsonBody](params)
			if err != nil {
				return nil, err
			}
			err = database.Transaction(i.DBExecutor(), func(tx database.Executor) error {
				err = database.Update(tx, &sql.UpdateExecuteParams{
					TableName:  domain.TableName(dbSchema, &mini_video_config.Entity{}),
					Conditions: sql.NewConditions().Equal(entity.ColumnID, requestParams.ID),
					TableRow:   sql.NewTableRow().Add(mini_video_config.ColumnIsEnabled, requestParams.IsEnabled),
				})
				if requestParams.IsEnabled == Enabled {
					err = database.Update(tx, &sql.UpdateExecuteParams{
						TableName:  domain.TableName(dbSchema, &mini_video_config.Entity{}),
						Conditions: sql.NewConditions().Not(entity.ColumnID, requestParams.ID),
						TableRow:   sql.NewTableRow().Add(mini_video_config.ColumnIsEnabled, Disable),
					})
					if err != nil {
						return err
					}
				}
				return nil
			})
			return nil, nil
		},
	})
}

func (svc *MiniVideoConfigService) queryByKeyFields(e *mini_video_config.Entity, dbExecutor database.Executor) (*mini_video_config.Entity, error) {
	result, err := database.QueryOne(dbExecutor, &sql.QueryOneExecuteParams{
		TableName:  domain.TableName(dbSchema, e),
		Conditions: sql.NewConditions().Equal(entity.ColumnID, e.ID),
	})
	if err != nil {
		if database.IsErrorDBRecordNotExist(err) {
			return nil, errors.New(e.DomainCNName() + "不存在")
		}

		return nil, err
	}

	existEntity := new(mini_video_config.Entity)
	err = sql.ParseSqlResult(result, existEntity)
	if err != nil {
		return nil, err
	}

	return existEntity, nil
}

func (svc *MiniVideoConfigService) checkExistByKeyFields(e *mini_video_config.Entity, dbExecutor database.Executor) error {
	exist, err := database.CheckExist(dbExecutor, &sql.CheckExistExecuteParams{
		TableName:  domain.TableName(dbSchema, e),
		Conditions: sql.NewConditions().Equal(entity.ColumnID, e.ID),
	})
	if err != nil {
		return err
	}

	if !exist {
		return errors.New(e.DomainCNName() + "不存在")
	}

	return nil
}