NIR — performanța operatorilor
Un singur clasament al creatorilor de NIR-uri, filtrabil la deschidere după perioadă și după numărul de NIR-uri sau de linii.
Arată cine a creat cele mai multe NIR-uri sau cele mai multe linii NIR în ultimele 7, 30 ori 90 de zile. La deschidere alegi obligatoriu Perioada și Clasamentul, apoi vezi operatorii ordonați descrescător după scor. Dintr-un operator poți deschide NIR-urile lui din exact perioada aleasă.
NIR-urile anulate sunt excluse. Numărul de linii folosește cheia completă NexusERP (an/lună, punct de lucru și ID NIR), pentru a evita asocierea liniilor cu alt document. Configurația este read-only și necesită Cifru Pro pentru SQL personalizat.
What this package creates
1 Home1 Details2 lists1 sources to map
- Home: Performanță creare NIR
- Details: Operator și perioadă
- Sub-button: NIR-urile operatorului
Sources are mapped locally and verified before applying.
Custom queriesPRO2 SQL
Custom queries are a PRO feature. Cifru repeats read-only validation against the local source before execution.
Statically verified read-only
$.components.workspaceSelection.datasets.0.sqlQueryWITH line_counts AS (
SELECT anluna, pl_nir, id_nir, COUNT_BIG(*) AS nr_linii
FROM dbo.liniinir_view WITH (NOLOCK)
GROUP BY anluna, pl_nir, id_nir
),
base AS (
SELECT h.anluna, h.pct_lcr, h.id,
LTRIM(RTRIM(ISNULL(h.user_cr, N'(necunoscut)'))) AS operator,
CAST(h.data_cr AS date) AS data_creare,
ISNULL(l.nr_linii, 0) AS nr_linii
FROM dbo.nir_view h WITH (NOLOCK)
LEFT JOIN line_counts l
ON l.anluna = h.anluna AND l.pl_nir = h.pct_lcr AND l.id_nir = h.id
WHERE ISNULL(h.anulat, 0) = 0
AND h.data_cr >= DATEADD(day, -89, CAST(GETDATE() AS date))
AND h.data_cr < DATEADD(day, 1, CAST(GETDATE() AS date))
),
perioade AS (
SELECT period_code, perioada, data_start, period_order
FROM (VALUES
('last7Days', N'Ultimele 7 zile', DATEADD(day, -6, CAST(GETDATE() AS date)), 1),
('last30Days', N'Ultimele 30 zile', DATEADD(day, -29, CAST(GETDATE() AS date)), 2),
('last90Days', N'Ultimele 90 zile', DATEADD(day, -89, CAST(GETDATE() AS date)), 3)
) p(period_code, perioada, data_start, period_order)
),
agregat AS (
SELECT p.period_code, p.perioada, p.period_order, b.operator,
COUNT_BIG(*) AS nr_niruri, SUM(b.nr_linii) AS nr_linii,
MAX(b.data_creare) AS ultima_data
FROM perioade p
INNER JOIN base b ON b.data_creare >= p.data_start
GROUP BY p.period_code, p.perioada, p.period_order, b.operator
),
clasament AS (
SELECT a.period_code, a.perioada, a.period_order, a.operator,
x.metric_code, x.criteriu, x.metric_order, x.scor,
a.nr_niruri, a.nr_linii,
CAST(1.0 * a.nr_linii / NULLIF(a.nr_niruri, 0) AS decimal(18,2)) AS medie_linii_nir,
a.ultima_data
FROM agregat a
CROSS APPLY (VALUES
('niruri', N'Număr NIR-uri', 1, CAST(a.nr_niruri AS bigint)),
('linii', N'Număr linii NIR', 2, CAST(a.nr_linii AS bigint))
) x(metric_code, criteriu, metric_order, scor)
)
SELECT CONCAT(period_code, '|', metric_code, '|', operator) AS row_id,
period_code, perioada, metric_code, criteriu, operator, scor,
nr_niruri, nr_linii, medie_linii_nir, ultima_data,
CONCAT(period_code, '|', operator) AS relation_key
FROM clasamentstatic read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.1.sqlQueryWITH line_counts AS (
SELECT anluna, pl_nir, id_nir, COUNT_BIG(*) AS nr_linii
FROM dbo.liniinir_view WITH (NOLOCK)
GROUP BY anluna, pl_nir, id_nir
),
documente AS (
SELECT h.anluna, h.pct_lcr, h.id,
LTRIM(RTRIM(ISNULL(h.user_cr, N'(necunoscut)'))) AS operator,
CAST(h.data_cr AS date) AS data_creare,
CONCAT(ISNULL(NULLIF(LTRIM(RTRIM(h.seria_doc)), ''), N'NIR'), N' ', CAST(h.numar_doc AS nvarchar(50))) AS document,
h.nume_gest AS gestiune, h.nume_furn AS furnizor,
ISNULL(l.nr_linii, 0) AS nr_linii, h.valoare
FROM dbo.nir_view h WITH (NOLOCK)
LEFT JOIN line_counts l
ON l.anluna = h.anluna AND l.pl_nir = h.pct_lcr AND l.id_nir = h.id
WHERE ISNULL(h.anulat, 0) = 0
AND h.data_cr >= DATEADD(day, -89, CAST(GETDATE() AS date))
AND h.data_cr < DATEADD(day, 1, CAST(GETDATE() AS date))
),
perioade AS (
SELECT period_code, perioada, data_start
FROM (VALUES
('last7Days', N'Ultimele 7 zile', DATEADD(day, -6, CAST(GETDATE() AS date))),
('last30Days', N'Ultimele 30 zile', DATEADD(day, -29, CAST(GETDATE() AS date))),
('last90Days', N'Ultimele 90 zile', DATEADD(day, -89, CAST(GETDATE() AS date)))
) p(period_code, perioada, data_start)
)
SELECT CONCAT(p.period_code, '|', d.anluna, '|', d.pct_lcr, '|', d.id) AS row_id,
CONCAT(p.period_code, '|', d.operator) AS relation_key,
p.period_code, p.perioada, d.operator, d.document, d.data_creare,
d.gestiune, d.furnizor, d.nr_linii, d.valoare
FROM perioade p
INNER JOIN documente d ON d.data_creare >= p.data_startstatic read-only checks passed
View the JSON being importedcollapsed by default
{
"components": {
"sourceSlots": [
{
"displayName": "NexusERP SQL Server (AccesEx)",
"id": "706DA619-94F7-54B2-9335-085B0BC281AD",
"kind": "sqlServer",
"requiredObjects": [
"dbo.nir_view",
"dbo.liniinir_view"
],
"requiresCustomSQL": true
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "cached",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [],
"id": "17A525B4-39A1-575E-874F-06B15AC3E51E",
"mappings": [
{
"commonFieldKey": "",
"key": "row_id",
"label": "ID clasament",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "row_id",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "period_code",
"label": "Cod perioadă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "period_code",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "perioada",
"label": "Perioadă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "perioada",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "metric_code",
"label": "Cod criteriu",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "metric_code",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "criteriu",
"label": "Clasament",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "criteriu",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "operator",
"label": "Operator",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "operator",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "scor",
"label": "Scor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "scor",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "nr_niruri",
"label": "NIR-uri create",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "nr_niruri",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "nr_linii",
"label": "Linii NIR",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "nr_linii",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "medie_linii_nir",
"label": "Medie linii / NIR",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "medie_linii_nir",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ultima_data",
"label": "Ultimul NIR creat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ultima_data",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "relation_key",
"label": "Cheie documente",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "relation_key",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 500,
"name": "Clasament operatori",
"primaryKey": "row_id",
"refreshPolicy": {
"enabled": true,
"intervalMinutes": 15
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"row_id",
"period_code",
"perioada",
"metric_code",
"criteriu"
],
"sourceID": "706DA619-94F7-54B2-9335-085B0BC281AD",
"sqlQuery": "WITH line_counts AS (\n SELECT anluna, pl_nir, id_nir, COUNT_BIG(*) AS nr_linii\n FROM dbo.liniinir_view WITH (NOLOCK)\n GROUP BY anluna, pl_nir, id_nir\n),\nbase AS (\n SELECT h.anluna, h.pct_lcr, h.id,\n LTRIM(RTRIM(ISNULL(h.user_cr, N'(necunoscut)'))) AS operator,\n CAST(h.data_cr AS date) AS data_creare,\n ISNULL(l.nr_linii, 0) AS nr_linii\n FROM dbo.nir_view h WITH (NOLOCK)\n LEFT JOIN line_counts l\n ON l.anluna = h.anluna AND l.pl_nir = h.pct_lcr AND l.id_nir = h.id\n WHERE ISNULL(h.anulat, 0) = 0\n AND h.data_cr >= DATEADD(day, -89, CAST(GETDATE() AS date))\n AND h.data_cr < DATEADD(day, 1, CAST(GETDATE() AS date))\n),\nperioade AS (\n SELECT period_code, perioada, data_start, period_order\n FROM (VALUES\n ('last7Days', N'Ultimele 7 zile', DATEADD(day, -6, CAST(GETDATE() AS date)), 1),\n ('last30Days', N'Ultimele 30 zile', DATEADD(day, -29, CAST(GETDATE() AS date)), 2),\n ('last90Days', N'Ultimele 90 zile', DATEADD(day, -89, CAST(GETDATE() AS date)), 3)\n ) p(period_code, perioada, data_start, period_order)\n),\nagregat AS (\n SELECT p.period_code, p.perioada, p.period_order, b.operator,\n COUNT_BIG(*) AS nr_niruri, SUM(b.nr_linii) AS nr_linii,\n MAX(b.data_creare) AS ultima_data\n FROM perioade p\n INNER JOIN base b ON b.data_creare >= p.data_start\n GROUP BY p.period_code, p.perioada, p.period_order, b.operator\n),\nclasament AS (\n SELECT a.period_code, a.perioada, a.period_order, a.operator,\n x.metric_code, x.criteriu, x.metric_order, x.scor,\n a.nr_niruri, a.nr_linii,\n CAST(1.0 * a.nr_linii / NULLIF(a.nr_niruri, 0) AS decimal(18,2)) AS medie_linii_nir,\n a.ultima_data\n FROM agregat a\n CROSS APPLY (VALUES\n ('niruri', N'Număr NIR-uri', 1, CAST(a.nr_niruri AS bigint)),\n ('linii', N'Număr linii NIR', 2, CAST(a.nr_linii AS bigint))\n ) x(metric_code, criteriu, metric_order, scor)\n)\nSELECT CONCAT(period_code, '|', metric_code, '|', operator) AS row_id,\n period_code, perioada, metric_code, criteriu, operator, scor,\n nr_niruri, nr_linii, medie_linii_nir, ultima_data,\n CONCAT(period_code, '|', operator) AS relation_key\nFROM clasament",
"tableName": ""
},
{
"cacheMode": "cached",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "E48ED152-4A18-5AC7-8477-22615AE300E6",
"key": "data_creare",
"type": "date"
}
],
"id": "04B91E99-EDAB-5C3C-AEB2-B970F7DD193F",
"mappings": [
{
"commonFieldKey": "",
"key": "row_id",
"label": "ID document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "row_id",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "relation_key",
"label": "Cheie documente",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "relation_key",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "period_code",
"label": "Cod perioadă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "period_code",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "perioada",
"label": "Perioadă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "perioada",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "operator",
"label": "Operator",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "operator",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "document",
"label": "Document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "document",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "data_creare",
"label": "Data creării",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_creare",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "gestiune",
"label": "Gestiune",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "gestiune",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "furnizor",
"label": "Furnizor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "furnizor",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "nr_linii",
"label": "Linii NIR",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "nr_linii",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "valoare",
"label": "Valoare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "valoare",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 10000,
"name": "Documentele operatorului",
"primaryKey": "row_id",
"refreshPolicy": {
"enabled": true,
"intervalMinutes": 15
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"row_id",
"relation_key",
"period_code",
"perioada",
"operator"
],
"sourceID": "706DA619-94F7-54B2-9335-085B0BC281AD",
"sqlQuery": "WITH line_counts AS (\n SELECT anluna, pl_nir, id_nir, COUNT_BIG(*) AS nr_linii\n FROM dbo.liniinir_view WITH (NOLOCK)\n GROUP BY anluna, pl_nir, id_nir\n),\ndocumente AS (\n SELECT h.anluna, h.pct_lcr, h.id,\n LTRIM(RTRIM(ISNULL(h.user_cr, N'(necunoscut)'))) AS operator,\n CAST(h.data_cr AS date) AS data_creare,\n CONCAT(ISNULL(NULLIF(LTRIM(RTRIM(h.seria_doc)), ''), N'NIR'), N' ', CAST(h.numar_doc AS nvarchar(50))) AS document,\n h.nume_gest AS gestiune, h.nume_furn AS furnizor,\n ISNULL(l.nr_linii, 0) AS nr_linii, h.valoare\n FROM dbo.nir_view h WITH (NOLOCK)\n LEFT JOIN line_counts l\n ON l.anluna = h.anluna AND l.pl_nir = h.pct_lcr AND l.id_nir = h.id\n WHERE ISNULL(h.anulat, 0) = 0\n AND h.data_cr >= DATEADD(day, -89, CAST(GETDATE() AS date))\n AND h.data_cr < DATEADD(day, 1, CAST(GETDATE() AS date))\n),\nperioade AS (\n SELECT period_code, perioada, data_start\n FROM (VALUES\n ('last7Days', N'Ultimele 7 zile', DATEADD(day, -6, CAST(GETDATE() AS date))),\n ('last30Days', N'Ultimele 30 zile', DATEADD(day, -29, CAST(GETDATE() AS date))),\n ('last90Days', N'Ultimele 90 zile', DATEADD(day, -89, CAST(GETDATE() AS date)))\n ) p(period_code, perioada, data_start)\n)\nSELECT CONCAT(p.period_code, '|', d.anluna, '|', d.pct_lcr, '|', d.id) AS row_id,\n CONCAT(p.period_code, '|', d.operator) AS relation_key,\n p.period_code, p.perioada, d.operator, d.document, d.data_creare,\n d.gestiune, d.furnizor, d.nr_linii, d.valoare\nFROM perioade p\nINNER JOIN documente d ON d.data_creare >= p.data_start",
"tableName": ""
}
],
"pages": [
{
"actions": [
{
"id": "A1A299ED-EACA-53BF-B086-1DFD0C6792B7",
"kind": "showRelated",
"relatedInitiallyExpanded": true,
"relatedPresentation": "inline",
"relatedPreviewLimit": 12,
"relatedRowStyle": "table",
"relatedShowsCount": true,
"relationID": "AB4ACDF3-5B57-5514-A531-122A5A9FD5CD",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "04B91E99-EDAB-5C3C-AEB2-B970F7DD193F",
"title": "Vezi NIR-urile operatorului",
"urlKey": ""
}
],
"badgeKey": "scor",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "criteriu",
"label": "Clasament",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "scor",
"label": "Scor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "nr_niruri",
"label": "NIR-uri create",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "nr_linii",
"label": "Linii NIR",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "17A525B4-39A1-575E-874F-06B15AC3E51E",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "perioada",
"label": "Perioadă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "criteriu",
"label": "Clasament",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "scor",
"label": "Scor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "nr_niruri",
"label": "NIR-uri create",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "nr_linii",
"label": "Linii NIR",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "medie_linii_nir",
"label": "Medie linii / NIR",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ultima_data",
"label": "Ultimul NIR creat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "E7257AB0-D631-587A-A11A-71010F43F275",
"openFilters": [
{
"id": "B15881A8-F7CF-557A-990B-0854603B6BBF",
"includeAllOption": false,
"key": "perioada",
"title": "Perioadă",
"type": "text"
},
{
"id": "738D437F-1350-5218-909C-34B8B2404674",
"includeAllOption": false,
"key": "criteriu",
"title": "Clasament",
"type": "text"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "descending",
"id": "4B9C3A8E-B3DE-5F72-A2E8-5B62A7679B48",
"key": "scor",
"type": "number"
}
],
"subtitle": "",
"subtitleKey": "criteriu",
"systemImage": "chart.bar.xaxis",
"title": "Performanță creare NIR",
"titleKey": "operator"
},
{
"actions": [],
"badgeKey": "nr_linii",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_creare",
"label": "Data creării",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "gestiune",
"label": "Gestiune",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "furnizor",
"label": "Furnizor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "nr_linii",
"label": "Linii NIR",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "04B91E99-EDAB-5C3C-AEB2-B970F7DD193F",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "perioada",
"label": "Perioadă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "operator",
"label": "Operator",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_creare",
"label": "Data creării",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "gestiune",
"label": "Gestiune",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "furnizor",
"label": "Furnizor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "nr_linii",
"label": "Linii NIR",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "valoare",
"label": "Valoare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "F15D9DD9-364B-5371-82CA-D950B51A1581",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "descending",
"id": "E48ED152-4A18-5AC7-8477-22615AE300E6",
"key": "data_creare",
"type": "date"
}
],
"subtitle": "",
"subtitleKey": "operator",
"systemImage": "doc.text.magnifyingglass",
"title": "NIR-urile operatorului",
"titleKey": "document"
}
],
"relations": [
{
"childDatasetID": "04B91E99-EDAB-5C3C-AEB2-B970F7DD193F",
"childKey": "relation_key",
"id": "AB4ACDF3-5B57-5514-A531-122A5A9FD5CD",
"name": "Operator și perioadă",
"parentDatasetID": "17A525B4-39A1-575E-874F-06B15AC3E51E",
"parentKey": "relation_key"
}
],
"widgets": []
}
},
"format": "cifru-configuration-package",
"formatVersion": 1,
"manifest": {
"applicationName": "NexusERP",
"configurationLanguages": [
"ro"
],
"countries": [
"RO"
],
"createdAt": "2026-08-23T17:09:50Z",
"description": "Arată cine a creat cele mai multe NIR-uri sau cele mai multe linii NIR în ultimele 7, 30 ori 90 de zile. La deschidere alegi obligatoriu Perioada și Clasamentul, apoi vezi operatorii ordonați descrescător după scor. Dintr-un operator poți deschide NIR-urile lui din exact perioada aleasă.\n\nNIR-urile anulate sunt excluse. Numărul de linii folosește cheia completă NexusERP (an/lună, punct de lucru și ID NIR), pentru a evita asocierea liniilor cu alt document. Configurația este read-only și necesită Cifru Pro pentru SQL personalizat.",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.0",
"minimumPlan": "pro",
"packageID": "21F7F46D-C328-59E4-BCF4-F212EF031E68",
"rootButtonCount": 1,
"summary": "Un singur clasament al creatorilor de NIR-uri, filtrabil la deschidere după perioadă și după numărul de NIR-uri sau de linii.",
"tags": [
"NexusERP",
"NIR",
"receptie",
"operatori",
"performanta",
"clasament",
"intrari"
],
"title": "NIR — performanța operatorilor"
}
}