winecellar.js

/*
  Evolutility Model for Wine Cellar
*/

module.exports = {
  id: "winecellar",
  oid: 5,
  world: "organizer",
  active: true,
  position: 50,
  table: "wine",
  name: "wine",
  namePlural: "wines",
  label: "Wine cellar",
  icon: "wine-bottle.png",
  titleField: "name",
  defaultViewMany: "cards",
  groups: [
    {
      type: "panel",
      label: "Wine",
      width: 80,
      fields: [
        "name",
        "vintage",
        "winery",
        "bsize",
        "grape",
        "type",
        "appellation",
        "country",
        "region",
        "area",
      ],
    },
    {
      type: "panel",
      label: "Bottle label",
      width: 20,
      fields: ["label_img"],
    },
    {
      type: "panel",
      label: "Purchase",
      width: 100,
      fields: [
        "buying_date",
        "price",
        "value",
        "purchased",
        "remaining",
        "notes",
      ],
    },
    {
      type: "panel",
      label: "Drinking",
      width: 62,
      fields: ["drink_from", "drink_to", "peak_from", "peak_to", "meal"],
    },
    {
      type: "panel",
      label: "Score",
      width: 38,
      fields: ["score", "score_parker", "score_winespectator"],
    },
    {
      type: "panel",
      label: "Comments",
      width: 100,
      fields: ["comments"],
    },
  ],
  fields: [
    {
      id: "name",
      column: "name",
      type: "text",
      label: "Name",
      required: true,
      maxLength: 150,
      inMany: true,
      inSearch: true,
      width: 62,
      help: "Name of the wine as indicated on the label.",
      inSearch: true,
    },
    {
      id: "vintage",
      column: "vintage",
      type: "integer",
      label: "Vintage",
      required: true,
      format: "0000",
      maxLength: 4,
      inMany: true,
      width: 38,
      min: 1950,
      max: 2022,
      help: "Year the wine was produced.",
    },
    {
      id: "winery",
      column: "winery",
      type: "text",
      label: "Winery",
      maxLength: 100,
      required: true,
      inMany: true,
      width: "62",
      help: "The establishment where this wine is made.",
      inSearch: true,
    },
    {
      id: "bsize",
      column: "bsize_id",
      type: "lov",
      label: "Bottle size",
      labelShort: "Bottle",
      width: 38,
      list: [
        {
          id: 1,
          text: "750 ml",
        },
        {
          id: 2,
          text: "500 ml",
        },
        {
          id: 3,
          text: "375 cl",
        },
        {
          id: 4,
          text: "1.5 L",
        },
        {
          id: 5,
          text: "3.0 L",
        },
        {
          id: 6,
          text: "6.0 L",
        },
        {
          id: 7,
          text: "8.0 L",
        },
      ],
      lovTable: "wine_bsize",
    },
    {
      id: "grape",
      column: "grape_id",
      type: "lov",
      label: "Grape",
      inMany: false,
      width: 62,
      list: [
        {
          id: 1,
          text: "Chardonnay",
        },
        {
          id: 2,
          text: "Shiraz",
        },
        {
          id: 3,
          text: "Merlot",
        },
        {
          id: 4,
          text: "Pinot Noir",
        },
        {
          id: 5,
          text: "Cabernet",
        },
        {
          id: 6,
          text: "Zinfandel",
        },
        {
          id: 7,
          text: "Sauvignon",
        },
        {
          id: 8,
          text: "Cabernet Sauvignon",
        },
        {
          id: 9,
          text: "Aligoté",
        },
        {
          id: 10,
          text: "Alvarinho",
        },
        {
          id: 11,
          text: "Blanc Fumé",
        },
        {
          id: 12,
          text: "Bual",
        },
        {
          id: 13,
          text: "Carignan",
        },
        {
          id: 14,
          text: "Chasselas",
        },
        {
          id: 15,
          text: "Chemin Blanc",
        },
        {
          id: 16,
          text: "Cinsault",
        },
        {
          id: 17,
          text: "Clairette",
        },
        {
          id: 18,
          text: "Colombard",
        },
        {
          id: 19,
          text: "Counoise",
        },
        {
          id: 20,
          text: "Fendant",
        },
        {
          id: 21,
          text: "Folle Blanche",
        },
        {
          id: 22,
          text: "Fürmint",
        },
        {
          id: 23,
          text: "Gamay",
        },
        {
          id: 24,
          text: "Gewürztraminer",
        },
        {
          id: 25,
          text: "Grauburgunder",
        },
        {
          id: 26,
          text: "Grechetto",
        },
        {
          id: 27,
          text: "Grenache Blanc",
        },
        {
          id: 28,
          text: "Grenache Noir",
        },
        {
          id: 29,
          text: "Gros Plan",
        },
        {
          id: 30,
          text: "Grüner Veltliner",
        },
        {
          id: 31,
          text: "Italienischer Riestling",
        },
        {
          id: 32,
          text: "Kadarka",
        },
        {
          id: 33,
          text: "Kerner",
        },
        {
          id: 34,
          text: "Macabeo",
        },
        {
          id: 35,
          text: "Malmsey",
        },
        {
          id: 36,
          text: "Malvasier",
        },
        {
          id: 37,
          text: "Marsanne",
        },
        {
          id: 38,
          text: "Melon de Bourgogne",
        },
        {
          id: 39,
          text: "Mourvèdre",
        },
        {
          id: 40,
          text: "Müller-Thurgau",
        },
        {
          id: 41,
          text: "Muscadelle",
        },
        {
          id: 42,
          text: "Muscadet",
        },
        {
          id: 43,
          text: "Musca",
        },
        {
          id: 44,
          text: "Musca d'Alsace",
        },
        {
          id: 45,
          text: "Muskateller",
        },
        {
          id: 46,
          text: "Nebbiolo",
        },
        {
          id: 47,
          text: "Palomino",
        },
        {
          id: 48,
          text: "Pedro Ximérez",
        },
        {
          id: 49,
          text: "Petit Verdot",
        },
        {
          id: 50,
          text: "Pinot Blanc",
        },
        {
          id: 51,
          text: "Pinot Gris",
        },
        {
          id: 52,
          text: "Pinot Noir",
        },
        {
          id: 53,
          text: "Pinotage",
        },
        {
          id: 54,
          text: "Riesling",
        },
        {
          id: 55,
          text: "Ruländer",
        },
        {
          id: 56,
          text: "Sangiovese",
        },
        {
          id: 57,
          text: "Sauvignon Blanc",
        },
        {
          id: 58,
          text: "Scheurebe",
        },
        {
          id: 59,
          text: "Sémilion",
        },
        {
          id: 60,
          text: "Sercial",
        },
        {
          id: 61,
          text: "Seyval Blanc",
        },
        {
          id: 62,
          text: "Siegerrebe",
        },
        {
          id: 63,
          text: "Silvaner",
        },
        {
          id: 64,
          text: "Spätburgunder",
        },
        {
          id: 65,
          text: "Steen",
        },
        {
          id: 66,
          text: "Syrah",
        },
        {
          id: 67,
          text: "Tempranillo",
        },
        {
          id: 68,
          text: "Tokay",
        },
        {
          id: 69,
          text: "Traminer",
        },
        {
          id: 70,
          text: "Trebbiano",
        },
        {
          id: 71,
          text: "Ugni Blanc",
        },
        {
          id: 72,
          text: "Verdejo",
        },
        {
          id: 73,
          text: "Verdelho",
        },
        {
          id: 74,
          text: "Vermentino",
        },
        {
          id: 75,
          text: "Vernaccia",
        },
        {
          id: 76,
          text: "Viognier",
        },
        {
          id: 77,
          text: "Viura",
        },
        {
          id: 78,
          text: "Weißburgunder",
        },
      ],
      lovTable: "wine_grape",
    },
    {
      id: "type",
      column: "type_id",
      type: "lov",
      label: "Type",
      inMany: true,
      width: 38,
      list: [
        {
          id: 1,
          text: "Red",
          icon: "wine/winered.png",
        },
        {
          id: 2,
          text: "White",
          icon: "wine/winewhite.png",
        },
        {
          id: 3,
          text: "Sweet",
          icon: "wine/winesweet.png",
        },
        {
          id: 4,
          text: "Sparkling",
          icon: "wine/winespark.png",
        },
        {
          id: 5,
          text: "Rose",
          icon: "wine/winerose.png",
        },
      ],
      lovTable: "wine_type",
      lovIcon: true,
    },
    {
      id: "appellation",
      column: "appellation",
      type: "text",
      label: "Appellation",
      width: 100,
      help: "An appellation is a legally defined and protected geographical indication used to identify where the grapes for a wine were grown.",
      inSearch: true,
    },
    {
      id: "country",
      column: "country_id",
      type: "lov",
      label: "Country",
      width: 32,
      list: [
        {
          id: 1,
          icon: "wine/flags/ar.png",
          text: "Argentina",
        },
        {
          id: 2,
          icon: "wine/flags/at.png",
          text: "Austria",
        },
        {
          id: 3,
          icon: "wine/flags/bg.png",
          text: "Bulgaria",
        },
        {
          id: 4,
          icon: "wine/flags/ca.png",
          text: "Canada",
        },
        {
          id: 5,
          icon: "wine/flags/cl.png",
          text: "Chile",
        },
        {
          id: 6,
          icon: "wine/flags/cy.png",
          text: "Cyprus",
        },
        {
          id: 7,
          icon: "wine/flags/fr.png",
          text: "France",
        },
        {
          id: 8,
          icon: "wine/flags/de.png",
          text: "Germany",
        },
        {
          id: 9,
          icon: "wine/flags/gr.png",
          text: "Greece",
        },
        {
          id: 10,
          icon: "wine/flags/hu.png",
          text: "Hungary",
        },
        {
          id: 11,
          icon: "wine/flags/it.png",
          text: "Italy",
        },
        {
          id: 12,
          icon: "wine/flags/lu.png",
          text: "Luxembourg",
        },
        {
          id: 13,
          icon: "wine/flags/nz.png",
          text: "New Zealand",
        },
        {
          id: 14,
          icon: "wine/flags/pt.png",
          text: "Portugal",
        },
        {
          id: 15,
          icon: "wine/flags/za.png",
          text: "South Africa",
        },
        {
          id: 16,
          icon: "wine/flags/es.png",
          text: "Spain",
        },
        {
          id: 17,
          icon: "wine/flags/ch.png",
          text: "Switzerland",
        },
        {
          id: 18,
          icon: "wine/flags/us.png",
          text: "United States",
        },
      ],
      lovTable: "wine_country",
      lovIcon: true,
    },
    {
      id: "region",
      column: "region",
      type: "text",
      label: "Region",
      maxLength: 100,
      width: 30,
      inSearch: true,
    },
    {
      id: "area",
      column: "area",
      type: "text",
      label: "Area",
      maxLength: 100,
      width: 38,
    },
    {
      id: "label_img",
      column: "label_img",
      type: "image",
      label: "Label",
      labelCards: "",
      maxLength: 200,
      width: 100,
      inMany: true,
    },
    {
      id: "buying_date",
      column: "buying_date",
      type: "date",
      label: "Buying date",
      width: 40,
    },
    {
      id: "price",
      column: "price",
      type: "money",
      label: "Price",
      inMany: true,
      width: 30,
    },
    {
      id: "value",
      column: "value",
      type: "money",
      label: "Value",
      width: 30,
    },
    {
      id: "purchased",
      column: "purchased",
      type: "integer",
      min: 0,
      label: "Bottles purchased",
      labelShort: "Purchased",
      maxLength: 10,
      width: 40,
    },
    {
      id: "remaining",
      column: "remaining",
      type: "integer",
      label: "Remaining",
      labeledit: "Bottles remaining",
      maxLength: 10,
      width: 60,
      inCharts: false,
    },
    {
      id: "notes",
      column: "notes",
      type: "textmultiline",
      label: "Notes",
      maxLength: 150,
      width: 100,
      height: 2,
      inSearch: true,
    },
    {
      id: "drink_from",
      column: "drink_from",
      type: "integer",
      label: "Drink from (year)",
      labelShort: "Drink",
      labelCharts: "Wines by Start drinking period",
      placeholder: "2012",
      maxLength: 10,
      width: 50,
      min: 1900,
      max: 2100,
    },
    {
      id: "drink_to",
      column: "drink_to",
      type: "integer",
      label: "to",
      labelCharts: "Wines by End drinking period",
      maxLength: 4,
      width: 50,
      min: 1900,
      max: "2100",
    },
    {
      id: "peak_from",
      column: "peak_from",
      type: "integer",
      label: "Peak from",
      labelCharts: "Wines by Start peak period",
      maxLength: 4,
      width: 50,
      min: 1900,
      max: 2100,
    },
    {
      id: "peak_to",
      column: "peak_to",
      type: "integer",
      label: "to",
      labelCharts: "Wines by End peak period",
      maxLength: 4,
      width: 50,
      min: 1900,
      max: 2100,
    },
    {
      id: "meal",
      column: "meal",
      type: "textmultiline",
      label: "Meal",
      maxLength: 200,
      width: 100,
      height: 2,
    },
    {
      id: "score",
      column: "score_id",
      type: "lov",
      label: "My score",
      labelShort: "Score",
      list: [
        {
          id: 1,
          text: "*",
        },
        {
          id: 2,
          text: "**",
        },
        {
          id: 3,
          text: "***",
        },
        {
          id: 4,
          text: "****",
        },
        {
          id: 5,
          text: "*****",
        },
      ],
      lovTable: "wine_score",
    },
    {
      id: "score_parker",
      column: "score_parker",
      type: "integer",
      label: "Parker",
      labelCharts: "Parker scores",
      min: 50,
      max: 100,
      maxLength: 3,
      width: 100,
    },
    {
      id: "score_winespectator",
      column: "score_winespectator",
      type: "integer",
      label: "Wine Spectator",
      labelCharts: "Wine Spectator scores",
      min: 0,
      max: 100,
      maxLength: 3,
      width: 100,
    },
    {
      id: "comments",
      column: "comments",
      type: "textmultiline",
      label: "Comments",
      maxLength: 500,
      width: 100,
      height: 8,
    },
  ],
  collections: [
    {
      id: "wine_tastings",
      title: "Degustations",
      table: "wine_tasting",
      column: "wine_id",
      object: "winetasting",
      orderBy: "drink_date",
      order: "desc",
      fields: ["drink_date", "robe", "nose", "taste", "notes"],
    },
  ],
};