schema.cds

using {
  cuid,
  managed,
  Currency,
  Country,
  sap.common.CodeList as CodeList
} from './common';

namespace my.cave;

aspect Boisson : cuid, managed {
  name   : String(50);
  annee  : String(4)@assert.format : '[0-9]';
  type   : String(15);
  @Measures :                        {Unit : '%vol'}
  degre  : Decimal(4, 1);
  @Measures :                        {Unit : unit, }
  volume : Integer default 75;
  unit   : String(3)@assert.range enum {
    L;
    cL;
  } default 'cL';
  @Measures :                        {ISOCurrency : devise_code, }
  prix   : Decimal(6, 2);
  devise : Currency;
};

entity Cepage                @(assert.unique : {Cepage : [name]}) : cuid {
  name           : String(30)@assert.format : '[A-Z]';
  description    : String(400);
  color          : String(10)@assert.range enum {
    Noir;
    Blanc;
  };
  to_vins        : Association to many Assemblage
                     on to_vins.cepage = $self;
  to_superficies : Composition of many Superficie
                     on to_superficies.to_cepage = $self;
};

entity Superficie       @(assert.unique : {Superficie : [
  to_cepage,
  annee
]}) : cuid {
  to_cepage  : Association to one Cepage;
  annee      : String(4)@assert.format : '[0-9]';
  @Measures :                            {Unit : 'ha'}
  superficie : Integer default 0;
};

entity Assemblage    @(assert.unique : {Assemblage : [
  cepage,
  vin
]}) : cuid {
  cepage   : Association to Cepage;
  vin      : Association to Vin;
  @Measures :                        {Unit : '%'}
  pourcent : Integer @assert.range : [
    0,
    100
  ] default 0;
};

entity Vin : Boisson {
  reference    : String(50)@assert.format : '[0-9]{4}-.{3}-.*';
  color        : Association to VinColor;
  igp          : Boolean default false;
  aoc          : Boolean default false;
  region       : Association to Region;
  @Measures :                               {Unit : '{i18n>anneeGarde}'} garde : Integer
                           @assert.range  : [
      1,
      20
    ] default 1;
  to_cepages   : Composition of many Assemblage
                   on to_cepages.vin = $self;
  inStockQty   : Integer default 0;
  orderQty     : Integer default 0;
  @Core.Computed
  status       : Association to RetentionStatus;
  availability : Association to AvailabilityStatus;
};

@cds.autoexpose  @readonly  @cds.odata.valuelist
entity VinColor : CodeList {
  key code : String(10)@assert.range enum {
        Rouge;
        ![Rosé];
        Vert;
        Blanc;
      };
};

@cds.autoexpose  @readonly : true
entity BiereColor : CodeList {

  key code : String @assert.range enum {
        Rousse;
        Blanche;
        Blonde;
        ![Ambrée];
        Stout;
        Brune;
      };
};

entity Biere : Boisson {
  color  : Association to BiereColor;
  @Measures : {ISOCurrency : devise_code, }
  prix   : Decimal;
  devise : Currency;
};

@cds.autoexpose  @readonly
define view ColorCepage as
  select from Cepage distinct {
    key color as ID : String
  };

@cds.autoexpose  @readonly
define view TypeBoisson as
  select from Vin distinct {
    key type as ID : String
  };

@cds.autoexpose  @readonly : true
entity RetentionStatus : CodeList {
  key code        : String(1) enum {
        ToGrowOld     = 'A';
        AtMaturity    = 'B';
        AtThePeak     = 'C';
        InDecline     = 'D';
        NotApplicable = 'E';
      } default 'E';
      criticality : Integer; //  1:red colour 2: yellow colour,  3: green colour, 0: unknown
};

@cds.autoexpose  @readonly : true
entity AvailabilityStatus : CodeList {
  key code        : String(1) enum {
        InStock       = 'A';
        SoldOut       = 'B';
        ToBeDelivered = 'C';
      } default 'A';
      criticality : Integer; //  1:red colour 2: yellow colour,  3: green colour, 0: unknown
};

entity Cave                   @(assert.unique : {Cave : [
  vin,
  createdBy
]}) : cuid, managed {
  vin          : Association to one Vin;
  @Measures :                                 {Unit : '{i18n>bottles}'}
  quantity     : Integer;
  rating       : Decimal(2, 1)@assert.range : [
    0.0,
    5.0
  ];
  comment      : String(250);
  to_positions : Association to many Position
                   on to_positions.cave = $self;
};

@cds.autoexpose  @readonly  @cds.odata.valuelist
entity Region {
  key subregion : String(25);
      region    : String(30);
      country   : Country;
};

type TechnicalBooleanFlag : Boolean @(
  UI.Hidden,
  Core.Computed
);


@Aggregation : {ApplySupported : {
  $Type                  : 'Aggregation.ApplySupportedType',
  PropertyRestrictions   : true,
  GroupableProperties    : [
    vin.name,
    status_code,
    quantity
  ],
  AggregatableProperties : [
    {
      $Type    : 'Aggregation.AggregatablePropertyType',
      Property : vin.name,
    },
    {
      $Type    : 'Aggregation.AggregatablePropertyType',
      Property : status_code,
    },
    {
      $Type    : 'Aggregation.AggregatablePropertyType',
      Property : quantity,
    },
  ],
}, }
//
//
entity LogOfDemand : cuid {
  createdAt  : DateTime @cds.on.insert : $now;
  quantity   : Integer;
  vin        : Association to one Vin;
  @Measures :                            {ISOCurrency : currency_code, }
  price      : Decimal(6, 2);
  @Measures :                            {ISOCurrency : currency_code, }
  totalPrice : Decimal(6, 2);
  currency   : Currency;
  status     : Association to DemandStatus;
};

//
//
entity DemandStatus : CodeList {
  key code        : String(1) enum {
        Completed = 'C';
        Delayed   = 'D';
        Failed    = 'F';
      };
      criticality : Integer; //  1:red colour 2: yellow colour,  3: green colour, 0: unknown
};

//
//
entity LogOfEvent : cuid {
  createdAt : DateTime @cds.on.insert : $now;
  name      : String;
};

//
//
@cds.autoexpose
entity Position : cuid, managed {
  positionX : Integer;
  positionY : Integer;
  cave      : Association to Cave;
};