/****************************************************/ /* HELPER */ /****************************************************/ var getUrlParameter = function (name) { name = name.replace(/[\[]/, '\\[').replace(/[\]]/, '\\]'); var regex = new RegExp('[\\?&]' + name + '=([^&#]*)'); var results = regex.exec(location.search); return results === null ? '' : decodeURIComponent(results[1].replace(/\+/g, ' ')); }; /****************************************************/ /* CONFIG */ /****************************************************/ var lang = getUrlParameter("lang"); if (['nl', 'fr', 'en', 'de'].indexOf(lang) === -1) { lang = 'nl'; } var streetAdressProperty = 'streetAddressNl'; if (lang === 'fr' || lang === 'en') { var streetAdressProperty = 'streetAddressFr'; } var i18n = {} i18n['fr'] = { // Set Filter selectAll: 'Tout selectionner', selectAllSearchResults: 'Selectionner tous les résultats', searchOoo: 'Rechercher...', blanks: 'Vides', noMatches: 'Pas de résultats', // Number Filter & Text Filter filterOoo: 'Filtrer...', equals: 'Égale', notEqual: 'N’égale pas', // Number Filter lessThan: 'Moins que', greaterThan: 'Plus que', lessThanOrEqual: 'Moins que ou égale à', greaterThanOrEqual: 'Plus que ou égale à', inRange: 'Portée', inRangeStart: 'De', inRangeEnd: 'À', // Text Filter contains: 'Contient', notContains: 'Ne contient pas', startsWith: 'Debut par', endsWith: 'Finit avec', // Filter Conditions andCondition: 'AND', orCondition: 'OR', // Filter Buttons applyFilter: 'Appliquer', resetFilter: 'Réinitialiser', clearFilter: 'Vider', cancelFilter: 'Annuler', // Side Bar columns: 'Colommes', filters: 'Filtres', // Other loadingOoo: 'Chargement...', // Menu pinColumn: 'Accrocher', pinLeft: 'Accrocher gauche', pinRight: 'Accrocher rights', noPin: 'Ne pas accrocher', valueAggregation: 'Aggregrer valeur', autosizeThiscolumn: 'Taille automatique colonne', autosizeAllColumns: 'Taille automatique tous les colonnes', groupBy: 'Associer', ungroupBy: 'Dissocier', resetColumns: 'Reinitialiser colonnes', expandAll: 'Tout afficher', collapseAll: 'Tout réduire', copy: 'Copier', ctrlC: 'Ctrl+C', copyWithHeaders: 'Copier avec entêtes', paste: 'Coller', ctrlV: 'Ctrl+V', export: 'Exporter', csvExport: 'Export CSV', excelExport: 'Export Excel (.xlsx)', excelXmlExport: 'Export Excel (.xml)', //Page page: 'Page', more: 'Plus', to: 'à', of: 'de', next: 'Prochaine', last: 'Dernière', first: 'Première', previous: 'Précedente', // column headers dossierId: 'Dossier', establishment: 'Établissement', streetAddress: 'Adresse', postalCode: 'Code postal', commune: 'Commune', owner: 'Demandeur', province: 'Province', // Provinces "Bruxelles/Brussel": 'Bruxelles', "Namur": 'Namur', "Hainaut": 'Hainaut', "Liège": 'Liège', "Luxembourg": 'Luxembourg', "Antwerpen": 'Anvers', "Oost-Vlaanderen": 'Flandre-Oriental', "Brabant Wallon": 'Brabant wallon', "Limburg": 'Limbourg', "West-Vlaanderen": 'Flandre-Occidentale', "Vlaams Brabant": 'Brabant flamand', // UI fullScreen: '🗖 Plein écran', downloadExcel: 'Télécharger *.xlsx', embedText: 'Avec le code suivant vous pouvez intégrer le diagramme dans une page web. Choissisez la langue: ', embed: '🔗 Intégrer' }; i18n['nl'] = { // Set Filter selectAll: 'Alles selecteren', selectAllSearchResults: 'Alle zoekresultaten selecteren', searchOoo: 'Zoeken...', blanks: 'Lege', noMatches: 'Geen resultaten.', // Number Filter & Text Filter filterOoo: 'Filteren...', equals: 'Gelijk aan', notEqual: 'Niet gelijk aan', // Number Filter lessThan: 'Kleiner dan', greaterThan: 'Groter dan', lessThanOrEqual: 'Kleiner dan of gelijk aan', greaterThanOrEqual: 'Groter dan of gelijk aan', inRange: 'Bereik', inRangeStart: 'Tot', inRangeEnd: 'Van', // Text Filter contains: 'Bevat', notContains: 'Bevat niet', startsWith: 'Begint met', endsWith: 'Eindigt met', // Filter Conditions andCondition: 'AND', orCondition: 'OR', // Filter Buttons applyFilter: 'Toepassen', resetFilter: 'Reset', clearFilter: 'Legen', cancelFilter: 'Annuleren', // Side Bar columns: 'Kolommen', filters: 'Filters', // Other loadingOoo: 'Laden...', // Menu pinColumn: 'Vastzetten', pinLeft: 'Vastzetten links', pinRight: 'Vastzetten rechts', noPin: 'Niet vastzetten', valueAggregation: 'Waarde aggregreren', autosizeThiscolumn: 'Kolom automatische grootte', autosizeAllColumns: 'Alle koloms automatische grootte', groupBy: 'Groeperen', ungroupBy: 'Ongroeperen', resetColumns: 'Kolommen reinitialiseren', expandAll: 'Alles uitvouwen', collapseAll: 'Alles inklappen', copy: 'Kopiëren', ctrlC: 'Ctrl+C', copyWithHeaders: 'Kopiëren met kopteksten', paste: 'Plakken', ctrlV: 'Ctrl+V', export: 'Exporteren', csvExport: 'CSV Export', excelExport: 'Excel Export (.xlsx)', excelXmlExport: 'Excel Export (.xml)', //Page page: 'Pagina', more: 'Meer', to: 'tot', of: 'van', next: 'Volgende', last: 'Laatste', first: 'Eerste', previous: 'Vorige', // column headers dossierId: 'Dossier', establishment: 'Kansspelinrichting', streetAddress: 'Adres', postalCode: 'Postcode', commune: 'Gemeente', owner: 'Aanvrager', province: 'Provincie', // Provinces "Bruxelles/Brussel": 'Brussel', "Namur": 'Namen', "Hainaut": 'Henegouwen', "Liège": 'Luik', "Luxembourg": 'Luxemburg', "Antwerpen": 'Antwerpen ', "Oost-Vlaanderen": 'Oost-Vlaanderen', "Brabant Wallon": 'Waals-Brabant', "Limburg": 'Limburg', "West-Vlaanderen": 'West-Vlaanderen', "Vlaams Brabant": 'Vlaams-Brabant', // UI fullScreen: '🗖 Volledig scherm', downloadExcel: 'Download *.xlsx', embedText: 'Met de volgende code kunt u het diagram insluiten op een web pagina. Kies de taal: ', embed: '🔗 Insluiten' }; i18n['en'] = { // Set Filter selectAll: 'Select All', selectAllSearchResults: 'Select All Search Results', searchOoo: 'Search...', blanks: 'Blanks', noMatches: 'No matches', // Number Filter & Text Filter filterOoo: 'Filter...', equals: 'Equals', notEqual: 'Not equal', // Number Filter lessThan: 'Less than', greaterThan: 'Greater than', lessThanOrEqual: 'Less than or equal', greaterThanOrEqual: 'Greater than or equal', inRange: 'In range', inRangeStart: 'From', inRangeEnd: 'To', // Text Filter contains: 'Contains', notContains: 'Not contains', startsWith: 'Starts with', endsWith: 'Ends with', // Filter Conditions andCondition: 'AND', orCondition: 'OR', // Filter Buttons applyFilter: 'Apply', resetFilter: 'Reset', clearFilter: 'Clear', cancelFilter: 'Cancel', // Side Bar columns: 'Columns', filters: 'Filters', // Other loadingOoo: 'Loading...', // Menu pinColumn: 'Pin column', pinLeft: 'Pin left', pinRight: 'Pin right', noPin: 'No pin', valueAggregation: 'Value aggregration', autosizeThiscolumn: 'Autosize This Column', autosizeAllColumns: 'Autosize All Columns', groupBy: 'Group by', ungroupBy: 'Un-group by', resetColumns: 'Reset columns', expandAll: 'Expand all', collapseAll: 'Close all', copy: 'Copy', ctrlC: 'Ctrl+C', copyWithHeaders: 'Copy with headers', paste: 'Paste', ctrlV: 'Ctrl+V', export: 'Export', csvExport: 'Export CSV', excelExport: 'Export Excel (.xlsx)', excelXmlExport: 'Export Excel (.xml)', //Page page: 'Page', more: 'More', to: 'to', of: 'of', next: 'Next', last: 'Last', first: 'First', previous: 'Previous', // column headers dossierId: 'Dossier', establishment: 'Gaming establishment', streetAddress: 'Address', postalCode: 'Postal code', commune: 'Municipality', owner: 'Applicant', province: 'Province', // Provinces "Bruxelles/Brussel": 'Brussels', "Namur": 'Namur', "Hainaut": 'Hainaut', "Liège": 'Liège', "Luxembourg": 'Luxembourg', "Antwerpen": 'Antwerp', "Oost-Vlaanderen": 'East Flanders', "Brabant Wallon": 'Walloon-Brabant', "Limburg": 'Limburg', "West-Vlaanderen": 'West Flanders', "Vlaams Brabant": 'Flemish-Brabant', // UI fullScreen: '🗖 Full screen', downloadExcel: 'Download *.xlsx', embedText: 'With the following code you can embed the diagram on a web page. Choose the language: ', embed: '🔗 Embed' }; i18n['de'] = { // Set Filter selectAll: 'Alle auswählen', selectAllSearchResults: 'Alle Suchergebnisse auswählen', searchOoo: 'Suchen...', blanks: 'Leere', noMatches: 'Keine Übereinstimmungen', // Number Filter & Text Filter filterOoo: 'Filtern...', equals: 'Gleichbedeutend mit', notEqual: 'Nicht gleichzusetzen mit', // Number Filter lessThan: 'Kleiner als', greaterThan: 'Größer als', lessThanOrEqual: 'Kleiner als oder gleich', greaterThanOrEqual: 'Größer als oder gleich', inRange: 'Bereich', inRangeStart: 'Bis Zu', inRangeEnd: 'Von', // Text Filter contains: 'Enthält', notContains: 'Enthält nicht', startsWith: 'Beginnt mit', endsWith: 'Endet mit', // Filter Conditions andCondition: 'AND', orCondition: 'OR', // Filter Buttons applyFilter: 'Bewerbung', resetFilter: 'Reset', clearFilter: 'Leere', cancelFilter: 'Abbrechen', // Side Bar columns: 'Kolumnen', filters: 'Filter', // Other loadingOoo: 'Laden...', // Menu pinColumn: 'Verschluss', pinLeft: 'Verschluss links', pinRight: 'Verschluss right', noPin: 'Kein Verschluss', valueAggregation: 'Aggregierter Wert', autosizeThiscolumn: 'Automatische Größe der Kolonne', autosizeAllColumns: 'Alle Kolonnen automatische Größe', groupBy: 'Gruppe', ungroupBy: 'Auflösen der Gruppe', resetColumns: 'Kolonnen reinitialisieren', expandAll: 'Erweitern Sie alle', collapseAll: 'Alle einklappen', copy: 'Kopieren', ctrlC: 'Strg+C', copyWithHeaders: 'Kopieren mit Kopfzeilen', paste: 'Einfügen', ctrlV: 'Strg+V', export: 'Exportieren', csvExport: 'CSV-Export', excelExport: 'Excel-Export (.xlsx)', excelXmlExport: 'Excel-Export (.xml)', //Page page: 'Seite', more: 'Mehr', to: 'An', of: 'Von', next: 'Weiter', last: 'Letzte', first: 'Erste', previous: 'Vorherige', // column headers dossierId: 'Dossier', establishment: 'Glücksspieleinrichtung', streetAddress: 'Adresse', postalCode: 'Postleitzahl', commune: 'Kommune', owner: 'Antragsteller', province: 'Provinz', // Provinces "Bruxelles/Brussel": 'Brüssel', "Namur": 'Namur', "Hainaut": 'Hennegau', "Liège": 'Lüttich', "Luxembourg": 'Luxemburg', "Antwerpen": 'Antwerpen', "Oost-Vlaanderen": 'Ostflandern', "Brabant Wallon": 'Wallonisch-Brabant', "Limburg": 'Limburg', "West-Vlaanderen": 'Westflandern', "Vlaams Brabant": 'Flämisch-Brabant', // UI fullScreen: '🗖 Vollbild', downloadExcel: 'Herunterladen *.xlsx', embedText: 'Mit dem folgenden Code können Sie das Diagramm in eine Webseite einbetten. Wählen Sie die Sprache: ', embed: '🔗 Einbetten' }; var localeText = i18n[lang]; document.getElementById("export-excel").innerHTML = localeText.downloadExcel; document.getElementById("embed-text").innerHTML = localeText.embedText; document.getElementById("share-text").innerHTML = localeText.embed; // specify the columns var columnDefs = [ { headerName: localeText.province, field: "province", hide: true, rowGroup: true, valueGetter: function (params) { if (!params.data) { return; } if (params.data.province) { return localeText[params.data.province] } return params.data.province; } }, { headerName: localeText.dossierId, field: "dossierId", width: 105 }, { headerName: localeText.establishment, field: "establishment" }, { headerName: localeText.streetAddress, field: streetAdressProperty }, { headerName: localeText.postalCode, field: "postalCode", width: 90 }, { headerName: localeText.commune, field: "commune", valueGetter: function (params) { if (!params.data) { return; } if (params.data.commune && params.data.commune.includes('/')) { if (lang === 'fr' || lang === 'en') { return params.data.commune.split('/')[0]; } return params.data.commune.split('/')[1]; } return params.data.commune; }, width: 200 }, { headerName: localeText.owner, field: "owner" } ]; // let the grid know which columns and what data to use var gridOptions = { defaultColDef: { filter: true, sortable: true, resizable: true, }, columnDefs: columnDefs, autoGroupColumnDef: { headerName: localeText.province, }, enableRangeSelection: true, groupSuppressBlankHeader: true, groupUseEntireRow: true, pagination: true, paginationPageSize: 25, localeText: localeText }; // Prepare UI document.getElementById("filter-text-box").setAttribute('placeholder', localeText.filterOoo); // lookup the container we want the Grid to use var eGridDiv = document.querySelector('#myGrid'); var onFilterTextBoxChanged = function () { gridOptions.api.setQuickFilter(document.getElementById('filter-text-box').value); } var exportExcel = function () { gridOptions.api.exportDataAsExcel({}); } agGrid.LicenseManager.setLicenseKey("CompanyName=Acsone SA/NV,LicensedApplication=www.gamingcommission.be,LicenseType=SingleApplication,LicensedConcurrentDeveloperCount=1,LicensedProductionInstancesCount=1,AssetReference=AG-009905,ExpiryDate=19_August_2021_[v2]_MTYyOTMyNzYwMDAwMA==43f2711b928994cfd694cdff317b96ce"); // create the grid passing in the div to use together with the columns & data we want to use new agGrid.Grid(eGridDiv, gridOptions); fetch('rows.json').then(function (response) { return response.json(); }).then(function (data) { gridOptions.api.setRowData(data.data); if (data.data.length && !data.data[0].hasOwnProperty('establishment')) { gridOptions.columnApi.setColumnVisible('establishment', false) } gridOptions.api.sizeColumnsToFit(); document.getElementById("date-info").innerHTML = data.created; }) c = new ChartShare(lang, "width:100%; height: 825px; border: 0px;");