Budgetsystemet GOrdian

Fullstack Golang application that handles the budget of Datasektionen.

Live at budget.datasektionen.se.

API

API documentation can be found here: Look down

List all Cost Centres

GET /api/CostCentres (gets all CCs)

Parameters

None

Responses

[
  {
    "CostCentreID":21,
    "CostCentreName":"Ada",
    "CostCentreType":"committee"
  }
]

List all Secondary Cost Centres of a Cost Centre

GET /api/SecondaryCostCentres?id={CCid} (gets all SCC given CC id)

Parameters

name	type	data type	description
CCid	required	int ($int64)	The id of a specific Cost Centre

Responses

[
  {
    "CostCentreID":1,
    "SecondaryCostCentreID":3,
    "SecondaryCostCentreName":"Allmänt"
  }
]

List all Budget Lines of a Secondary Cost Centre

GET /api/BudgetLines?id={SCCid} (gets all Budget Lines given SCC id)

Parameters

name	type	data type	description
SCCid	required	int ($int64)	The id of a specific Secondary Cost Centre

Responses

[
  {"SecondaryCostCentreID":3,
    "BudgetLineID":33,
    "BudgetLineName":"Mat till planeringsmöten",
    "BudgetLineAccount":"4029",
    "BudgetLineIncome":0,
    "BudgetLineExpense":-4400,
    "BudgetLineComment":"Ny för i år, 4"
  }
]

Local

• Clone repo
• Install docker
• Install PostgreSQL
• Create database and user in psql according to env.go
• Make user superuser
• Schemify database with .sql file
• Ask dsys for GOrdian token
• Ask dsys for pls access
• Create dockerimage
• Run dockerimage

Entities

Each entry in the system consists of the following entities. There are three elementary entities in the system, Cost centres, Secondary cost centres and Budget lines.

Cost Centre

A Cost Centre is called Resultatställe in Swedish. It can be typed as a Project (Projekt), Committee (Nämnd) or Other (Övrigt). They are the main budget divisions.

Secondary cost centre

A Secondary cost centre is part of a Cost centre. It can be an event or otherwise differentiable part of the Cost centre. Each Secondary cost centre contains the Cost centre it is connected to.

Budget line

A Budget line is the smallest part of a budget, belonging to a Secondary cost centre. Each Budget line centre contains the Secondary cost centre it is connected to. A Budget Line also contains the following.

Income and Expense

The prediction of what someone expects to earn or spend. A Budget Line never has an Income and an Expense at the same time.

Account

Account is used to assist with the bookkeeping

Comment

A Comment is used to further clarify the use of a Budget line

Very nice money budget