@model IEnumerable<Statistics>

<table id="dtMain" class="display" style="width:100%">

    <thead>
        <tr>
            <th>
                @Html.DisplayNameFor(x => x.GetEnumerator().Current.Parameter.Organization.FullShortName)
            </th>
            <th>
                @Html.DisplayNameFor(x => x.GetEnumerator().Current.Parameter.Name)
            </th>
            <th>
                @Html.DisplayNameFor(x => x.GetEnumerator().Current.Cnt)
            </th>
            <th>
                @Html.DisplayNameFor(x => x.GetEnumerator().Current.MinValue)
            </th>
            <th>
                @Html.DisplayNameFor(x => x.GetEnumerator().Current.MaxValue)
            </th>                         
        </tr>
    </thead>

    <tbody>
        @{
            foreach (var item in Model)
            {
                <tr>
                    <td>
                        @Html.DisplayFor(modelItem => item.Parameter.Organization.FullShortName)
                    </td>
                    <td>
                        @Html.DisplayFor(modelItem => item.Parameter.Name)
                    </td>
                    <td>
                        @Html.DisplayFor(modelItem => item.Cnt)
                    </td>
                    <td>
                        @Html.DisplayFor(modelItem => item.MinValue)
                    </td>
                    <td>
                        @Html.DisplayFor(modelItem => item.MaxValue)
                    </td>                                                                
                </tr>
            }
        }
    </tbody>

</table>

<script type="text/javascript">

    $(document).ready(function () {
        $("#dtMain").DataTable({
            dom: "Blfrtip",
            pageLength: 25,
            buttons: [
                {
                    text: "<i class='bi bi-plus-square'></i> Neu",
                    className: "btn-dark",
                    key: {
                        shiftKey: true,
                        key: 'n'
                    },
                    action: function (e, dt, node, conf) {
                        showInPopup("@Url.Action("AddOrEdit", "Plc", new {id = 0}, Context.Request.Scheme)", "neue Organisation erstellen");
                    },
                },
                {
                    extend: "spacer",
                },
                {
                    extend: "spacer",
                },
                "searchBuilder",
                {
                    extend: "collection",
                    text: "Export",
                    autoClose: true,
                    buttons: [
                        {
                            extend: "copyHtml5",
                            text: "<i class='bi bi-copy'></i> kopieren",
                            titleAttr: "Copy"
                        },
                        {
                            extend: "excelHtml5",
                            autoFilter: true,
                            text: "<i class='bi bi-file-earmark-excel'></i> Excel",
                            titleAttr: "Excel"
                        },
                        {
                            extend: "csvHtml5",
                            text: "<i class='bi bi-filetype-csv'></i> csv-Datei",
                            titleAttr: "CSV"
                        },
                        {
                            extend: "pdfHtml5",
                            text: "<i class='bi bi-file-earmark-pdf'> Pdf</i>",
                            titleAttr: "PDF"
                        },
                    ]
                },
                {
                    extend: "colvis",
                    collectionLayout: "fixed columns",
                    collectionTitle: "Column visibility control"
                },
                {
                    extend: "spacer",
                },               
            ],
            lengthMenu: [
                [10, 25, 50, -1],
                [10, 25, 50, 'All']
            ]
        });
    });

</script>

