Calendar package
No edit summary
No edit summary
Line 4: Line 4:
It follows a common pattern with dimensions from data analysis. By prepopulating the database with days, months, years, weeks etc, you can easily (and efficiently) find data to present in a diagram or table.
It follows a common pattern with dimensions from data analysis. By prepopulating the database with days, months, years, weeks etc, you can easily (and efficiently) find data to present in a diagram or table.


This model is cross-linked between all entities making "conversion" between different calender objects easy.[[File:Calender model diagram.png|none|thumb|776x776px|link=https://wiki.mdriven.net/index.php/File:Calender_model_diagram.png]][[Special:Redirect/file/CalendarPackage.modlr|CalendarPackage.modlr]]
This model is cross-linked between all entities making "conversion" between different calender objects easy.
 
This package also contain views for creating, viewing and maintaining the model content.[[File:Calender model diagram.png|none|thumb|776x776px|link=https://wiki.mdriven.net/index.php/File:Calender_model_diagram.png]][[Special:Redirect/file/CalendarPackage.modlr|CalendarPackage.modlr]]


==== '''Notes on usage''' ====
==== '''Notes on usage''' ====

Revision as of 16:45, 27 February 2021

What is this?

Model that implements classes that makes aggregation (for statistics for example) easy.

It follows a common pattern with dimensions from data analysis. By prepopulating the database with days, months, years, weeks etc, you can easily (and efficiently) find data to present in a diagram or table.

This model is cross-linked between all entities making "conversion" between different calender objects easy.

This package also contain views for creating, viewing and maintaining the model content.

Calender model diagram.png

CalendarPackage.modlr

Notes on usage

  • The Calendar "main class" is a Singleton. Use Calendar.SO as a short way to access the singleton object.
    • For example in OCL: Calendar.SO.Today will return a Day object for today.
  • Use the methods in Calendear to quickly find the Day for a given date when you link new or existing data to the structure.
  • There is also a lot of helper function to find next/previous day, week or months or calculate time between them.
    • For example in OCL: Day.GetDayForDate() returns a Day object by building a dictionary first for quick lookups.
  • Integers called Ordinals are used to have a stable way to calculate how far apart objects are in time.

Starting up

To create the data structure, start by using an action to create the years you want.

Then with that, you call FixupCalendar to create months and days of the calender. You can call FixupCalendar many times without losing any data. It will simply update or correct problems.

Weeks is a bit special. Week definitions vary in different parts of the world. Therefore the WeekDefinition class sets the first day of the week and weeks are then generated based on that.

You can also define Saturday and Sunday (for example) as the "days off" every week.

Use the country setting to define the default week definition for your users.

This page was edited 39 days ago on 03/26/2024. What links here