3.1. Loonkosten personeel in loondienst

Concepten

• Grootboekpost

Relaties

• deel van

Eigenschappen

• heeft datum
• heeftGeldBedrag

SPARQL query

Code gekopieerd
...
Kopieer naar klembord
1# Indicator: NZA 3.1
2# Parameters: ?startperiode, ?eindperiode
3# Ontologie: versie 3.0.0 of nieuwer
4
5PREFIX onz-g: <http://purl.org/ozo/onz-g#>
6PREFIX onz-fin: <http://purl.org/ozo/onz-fin#>
7PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
8PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
9PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
10
11SELECT ( SUM(?bedrag) AS ?totaal )
12WHERE {
13    BIND ("2024-01-01"^^xsd:date AS ?startperiode)
14    BIND ("2024-12-31"^^xsd:date AS ?eindperiode)
15    
16    {
17        SELECT DISTINCT ?post 
18        WHERE {
19            VALUES ?rubriek {
20                onz-fin:WPerSol
21                onz-fin:WPerLes
22                
23                onz-fin:411000
24                onz-fin:411100
25                onz-fin:411200
26                onz-fin:411300
27                onz-fin:411400
28                onz-fin:411500
29                onz-fin:411600
30                onz-fin:411700
31                onz-fin:412000
32                onz-fin:412100
33                onz-fin:412200
34                onz-fin:412300
35                onz-fin:412400
36                onz-fin:412500
37                onz-fin:413000
38                onz-fin:413100
39                onz-fin:413200
40                onz-fin:413300
41                onz-fin:413400
42                onz-fin:413500
43                onz-fin:413600
44                onz-fin:413610
45                onz-fin:413620
46                onz-fin:413700
47                onz-fin:414000
48                onz-fin:414100
49                onz-fin:414101
50                onz-fin:414102
51                onz-fin:414103
52                onz-fin:414104
53                onz-fin:414110
54                onz-fin:414111
55                onz-fin:414112
56                onz-fin:414113
57                onz-fin:414114
58                onz-fin:414200
59                onz-fin:414202
60                onz-fin:414203
61                onz-fin:414204
62                onz-fin:414300
63                onz-fin:414500
64                onz-fin:414503
65                onz-fin:414504
66                onz-fin:414700
67                onz-fin:414800
68                onz-fin:415000
69                onz-fin:416000
70                onz-fin:417000
71                onz-fin:419000
72                onz-fin:419100
73                onz-fin:419101
74                onz-fin:419200
75                onz-fin:419500
76                onz-fin:420000
77                onz-fin:420100
78                onz-fin:422100
79                onz-fin:422300
80                onz-fin:422400
81                onz-fin:422410
82                onz-fin:422500
83                onz-fin:422600
84                onz-fin:422900
85            }
86        ?post onz-g:partOf ?rubriek .
87        }
88    }
89    
90    ?post a onz-fin:Grootboekpost ;
91          onz-fin:heeftGeldBedrag ?bedrag ;
92          onz-g:hasDate ?datum .
93    
94    FILTER (?datum >= ?startperiode && ?datum <= ?eindperiode)
95}
96