mirror of
https://github.com/hanzoai/base.git
synced 2026-10-21 03:41:50 +00:00
Seven field types a CRM record needs, each one JSON column whose parts a filter, a sort or an aggregate reaches by name: currency (amountMicros, currencyCode), emails, phones, links, address, fullName and actor, plus rating. Empty is NULL. Emails, phones and links normalize what is typed and can keep their primary part unique. An actor is stamped by the server from the writer the save's context states; nothing a request sends sets it. Every field carries a label, description, icon and position, a select's values carry a label, colour and position, and a base collection carries a label, plural, icon, description and an opt-in history flag. Editor HTML is sanitized before it is written. A rule reads the caller's authority in the org it acts in: @request.auth.admin and @request.auth.role, off the token. An IAM-mirrored auth record is never saved, so its fields are now read off the record rather than joined against a row that is not there, which also makes @request.auth.org_id match for the first time. A host that opens one Base per org names it, and a token acting in another org is refused there.
220 lines
6.4 KiB
Go
220 lines
6.4 KiB
Go
package core
|
|
|
|
import (
|
|
"context"
|
|
|
|
validation "github.com/go-ozzo/ozzo-validation/v4"
|
|
"github.com/hanzoai/base/core/validators"
|
|
"github.com/hanzoai/base/tools/types"
|
|
)
|
|
|
|
func init() {
|
|
Fields[FieldTypeAutodate] = func() Field {
|
|
return &AutodateField{}
|
|
}
|
|
}
|
|
|
|
const FieldTypeAutodate = "autodate"
|
|
|
|
// used to keep track of the last set autodate value
|
|
const autodateLastKnownPrefix = internalCustomFieldKeyPrefix + "_last_autodate_"
|
|
|
|
var (
|
|
_ Field = (*AutodateField)(nil)
|
|
_ SetterFinder = (*AutodateField)(nil)
|
|
_ RecordInterceptor = (*AutodateField)(nil)
|
|
)
|
|
|
|
// AutodateField defines an "autodate" type field, aka.
|
|
// field which datetime value could be auto set on record create/update.
|
|
//
|
|
// This field is usually used for defining timestamp fields like "created" and "updated".
|
|
//
|
|
// Requires either both or at least one of the OnCreate or OnUpdate options to be set.
|
|
type AutodateField struct {
|
|
// Name (required) is the unique name of the field.
|
|
Name string `form:"name" json:"name"`
|
|
|
|
// Id is the unique stable field identifier.
|
|
//
|
|
// It is automatically generated from the name when adding to a collection FieldsList.
|
|
Id string `form:"id" json:"id"`
|
|
|
|
// System prevents the renaming and removal of the field.
|
|
System bool `form:"system" json:"system"`
|
|
|
|
// Hidden hides the field from the API response.
|
|
Hidden bool `form:"hidden" json:"hidden"`
|
|
|
|
// Presentable hints the Dashboard UI to use the underlying
|
|
// field record value in the relation preview label.
|
|
Presentable bool `form:"presentable" json:"presentable"`
|
|
|
|
// FieldMeta is how a person sees the field: label, description, icon
|
|
// and position. It changes nothing about the value.
|
|
FieldMeta
|
|
|
|
// ---
|
|
|
|
// OnCreate auto sets the current datetime as field value on record create.
|
|
OnCreate bool `form:"onCreate" json:"onCreate"`
|
|
|
|
// OnUpdate auto sets the current datetime as field value on record update.
|
|
OnUpdate bool `form:"onUpdate" json:"onUpdate"`
|
|
}
|
|
|
|
// Type implements [Field.Type] interface method.
|
|
func (f *AutodateField) Type() string {
|
|
return FieldTypeAutodate
|
|
}
|
|
|
|
// GetId implements [Field.GetId] interface method.
|
|
func (f *AutodateField) GetId() string {
|
|
return f.Id
|
|
}
|
|
|
|
// SetId implements [Field.SetId] interface method.
|
|
func (f *AutodateField) SetId(id string) {
|
|
f.Id = id
|
|
}
|
|
|
|
// GetName implements [Field.GetName] interface method.
|
|
func (f *AutodateField) GetName() string {
|
|
return f.Name
|
|
}
|
|
|
|
// SetName implements [Field.SetName] interface method.
|
|
func (f *AutodateField) SetName(name string) {
|
|
f.Name = name
|
|
}
|
|
|
|
// GetSystem implements [Field.GetSystem] interface method.
|
|
func (f *AutodateField) GetSystem() bool {
|
|
return f.System
|
|
}
|
|
|
|
// SetSystem implements [Field.SetSystem] interface method.
|
|
func (f *AutodateField) SetSystem(system bool) {
|
|
f.System = system
|
|
}
|
|
|
|
// GetHidden implements [Field.GetHidden] interface method.
|
|
func (f *AutodateField) GetHidden() bool {
|
|
return f.Hidden
|
|
}
|
|
|
|
// SetHidden implements [Field.SetHidden] interface method.
|
|
func (f *AutodateField) SetHidden(hidden bool) {
|
|
f.Hidden = hidden
|
|
}
|
|
|
|
// ColumnType implements [Field.ColumnType] interface method.
|
|
func (f *AutodateField) ColumnType(app App) string {
|
|
return "TEXT DEFAULT '' NOT NULL" // note: sqlite doesn't allow adding new columns with non-constant defaults
|
|
}
|
|
|
|
// PrepareValue implements [Field.PrepareValue] interface method.
|
|
func (f *AutodateField) PrepareValue(record *Record, raw any) (any, error) {
|
|
val, _ := types.ParseDateTime(raw)
|
|
return val, nil
|
|
}
|
|
|
|
// ValidateValue implements [Field.ValidateValue] interface method.
|
|
func (f *AutodateField) ValidateValue(ctx context.Context, app App, record *Record) error {
|
|
return nil
|
|
}
|
|
|
|
// ValidateSettings implements [Field.ValidateSettings] interface method.
|
|
func (f *AutodateField) ValidateSettings(ctx context.Context, app App, collection *Collection) error {
|
|
oldOnCreate := f.OnCreate
|
|
oldOnUpdate := f.OnUpdate
|
|
|
|
oldCollection, _ := app.FindCollectionByNameOrId(collection.Id)
|
|
if oldCollection != nil {
|
|
oldField, ok := oldCollection.Fields.GetById(f.Id).(*AutodateField)
|
|
if ok && oldField != nil {
|
|
oldOnCreate = oldField.OnCreate
|
|
oldOnUpdate = oldField.OnUpdate
|
|
}
|
|
}
|
|
|
|
return validation.ValidateStruct(f,
|
|
validation.Field(&f.Id, validation.By(DefaultFieldIdValidationRule)),
|
|
validation.Field(&f.Name, validation.By(DefaultFieldNameValidationRule)),
|
|
validation.Field(
|
|
&f.OnCreate,
|
|
validation.When(f.System, validation.By(validators.Equal(oldOnCreate))),
|
|
validation.Required.Error("either onCreate or onUpdate must be enabled").When(!f.OnUpdate),
|
|
),
|
|
validation.Field(
|
|
&f.OnUpdate,
|
|
validation.When(f.System, validation.By(validators.Equal(oldOnUpdate))),
|
|
validation.Required.Error("either onCreate or onUpdate must be enabled").When(!f.OnCreate),
|
|
),
|
|
)
|
|
}
|
|
|
|
// FindSetter implements the [SetterFinder] interface.
|
|
func (f *AutodateField) FindSetter(key string) SetterFunc {
|
|
switch key {
|
|
case f.Name:
|
|
// return noopSetter to disallow updating the value with record.Set()
|
|
return noopSetter
|
|
default:
|
|
return nil
|
|
}
|
|
}
|
|
|
|
// Intercept implements the [RecordInterceptor] interface.
|
|
func (f *AutodateField) Intercept(
|
|
ctx context.Context,
|
|
app App,
|
|
record *Record,
|
|
actionName string,
|
|
actionFunc func() error,
|
|
) error {
|
|
switch actionName {
|
|
case InterceptorActionCreateExecute:
|
|
// ignore if a date different from the old one was manually set with SetRaw
|
|
if f.OnCreate && record.GetDateTime(f.Name).Equal(f.getLastKnownValue(record)) {
|
|
now := types.NowDateTime()
|
|
record.SetRaw(f.Name, now)
|
|
record.SetRaw(autodateLastKnownPrefix+f.Name, now) // eagerly set so that it can be renewed on resave after failure
|
|
}
|
|
|
|
if err := actionFunc(); err != nil {
|
|
return err
|
|
}
|
|
|
|
record.SetRaw(autodateLastKnownPrefix+f.Name, record.GetRaw(f.Name))
|
|
|
|
return nil
|
|
case InterceptorActionUpdateExecute:
|
|
// ignore if a date different from the old one was manually set with SetRaw
|
|
if f.OnUpdate && record.GetDateTime(f.Name).Equal(f.getLastKnownValue(record)) {
|
|
now := types.NowDateTime()
|
|
record.SetRaw(f.Name, now)
|
|
record.SetRaw(autodateLastKnownPrefix+f.Name, now) // eagerly set so that it can be renewed on resave after failure
|
|
}
|
|
|
|
if err := actionFunc(); err != nil {
|
|
return err
|
|
}
|
|
|
|
record.SetRaw(autodateLastKnownPrefix+f.Name, record.GetRaw(f.Name))
|
|
|
|
return nil
|
|
default:
|
|
return actionFunc()
|
|
}
|
|
}
|
|
|
|
func (f *AutodateField) getLastKnownValue(record *Record) types.DateTime {
|
|
v := record.GetDateTime(autodateLastKnownPrefix + f.Name)
|
|
if !v.IsZero() {
|
|
return v
|
|
}
|
|
|
|
return record.Original().GetDateTime(f.Name)
|
|
}
|