dolibarr.metallzuschlag/metallzuschlagindex.php
data 105443f2e9 feat: Differenz-Anzeige und UI-Verbesserungen
- Differenz-Anzeige (+/-) im CU/AL-Diagramm (immer sichtbar)
- Differenz-Anzeige im Kabel-Diagramm (per Checkbox einblendbar)
- Farbkästchen bei Kabel-Checkboxen passend zur Diagrammfarbe
- Kabel-Diagramm Legende ausgeblendet (nicht doppelt)
- ChangeLog und README aktualisiert

Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
2026-02-24 11:08:01 +01:00

601 lines
22 KiB
PHP
Executable file

<?php
/* Copyright (C) 2026 Eduard Wisch <data@data-it-solution.de>
*
* This program is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 3 of the License, or
* (at your option) any later version.
*/
/**
* \file metallzuschlag/metallzuschlagindex.php
* \ingroup metallzuschlag
* \brief Metallzuschlag Dashboard - Aktuelle Notierungen und Verlauf
*/
// Dolibarr Umgebung laden
$res = 0;
if (!$res && !empty($_SERVER["CONTEXT_DOCUMENT_ROOT"])) {
$res = @include $_SERVER["CONTEXT_DOCUMENT_ROOT"]."/main.inc.php";
}
$tmp = empty($_SERVER['SCRIPT_FILENAME']) ? '' : $_SERVER['SCRIPT_FILENAME'];
$tmp2 = realpath(__FILE__);
$i = strlen($tmp) - 1;
$j = strlen($tmp2) - 1;
while ($i > 0 && $j > 0 && isset($tmp[$i]) && isset($tmp2[$j]) && $tmp[$i] == $tmp2[$j]) {
$i--;
$j--;
}
if (!$res && $i > 0 && file_exists(substr($tmp, 0, ($i + 1))."/main.inc.php")) {
$res = @include substr($tmp, 0, ($i + 1))."/main.inc.php";
}
if (!$res && $i > 0 && file_exists(dirname(substr($tmp, 0, ($i + 1)))."/main.inc.php")) {
$res = @include dirname(substr($tmp, 0, ($i + 1)))."/main.inc.php";
}
if (!$res && file_exists("../main.inc.php")) {
$res = @include "../main.inc.php";
}
if (!$res && file_exists("../../main.inc.php")) {
$res = @include "../../main.inc.php";
}
if (!$res && file_exists("../../../main.inc.php")) {
$res = @include "../../../main.inc.php";
}
if (!$res) {
die("Include of main fails");
}
require_once DOL_DOCUMENT_ROOT.'/core/class/html.formfile.class.php';
require_once './class/metallzuschlagapi.class.php';
require_once './lib/metallzuschlag.lib.php';
/**
* @var Conf $conf
* @var DoliDB $db
* @var HookManager $hookmanager
* @var Translate $langs
* @var User $user
*/
$langs->loadLangs(array("metallzuschlag@metallzuschlag"));
$action = GETPOST('action', 'aZ09');
// Zugriffskontrolle
if (!$user->hasRight('metallzuschlag', 'read')) {
accessforbidden();
}
$api = new MetallzuschlagApi($db);
/*
* Actions
*/
// Manueller Abruf
if ($action == 'fetch' && $user->hasRight('metallzuschlag', 'config')) {
if (!verifCond(GETPOST('token', 'alpha') == newToken())) {
accessforbidden('Bad CSRF token');
}
$result = $api->fetchMetalNotes();
if ($result >= 0) {
setEventMessages($langs->trans("MetallzuschlagFetchSuccess"), null, 'mesgs');
if (!empty($api->output)) {
setEventMessages($api->output, null, 'mesgs');
}
} else {
setEventMessages($langs->trans("MetallzuschlagFetchError"), null, 'errors');
if (!empty($api->error)) {
setEventMessages($api->error, null, 'errors');
}
}
header("Location: ".$_SERVER["PHP_SELF"]);
exit;
}
/*
* View
*/
llxHeader("", $langs->trans("MetallzuschlagDashboard"), '', '', 0, 0, '', '', '', 'mod-metallzuschlag page-index');
print load_fiche_titre($langs->trans("MetallzuschlagDashboard"), '', 'fa-coins');
// Aktuelle Werte abrufen
$latestCU = $api->getLatest('CU');
$latestAL = $api->getLatest('AL');
// Info-Panels: Aktuelle Notierungen
print '<div class="fichecenter">';
if ($latestCU || $latestAL) {
print '<div class="fichethirdleft">';
// Kupfer
print '<div class="info-box">';
print '<div class="info-box-icon bg-infobox-action">';
print img_picto('', 'fa-coins', 'class="fa-2x"');
print '</div>';
print '<div class="info-box-content">';
print '<span class="info-box-title">'.$langs->trans("MetallzuschlagCUShort").'</span><br>';
if ($latestCU) {
print '<span class="info-box-number">'.price($latestCU->value, 0, '', 1, -1, 2).' <small>€/100kg</small></span><br>';
if (!empty($latestCU->value_month_avg)) {
print '<span class="opacitymedium">'.$langs->trans("MetallzuschlagMonthAvg").': '.price($latestCU->value_month_avg, 0, '', 1, -1, 2).' €/100kg</span><br>';
}
print '<span class="opacitymedium">'.dol_print_date($db->jdate($latestCU->date_notiz), 'day').'</span>';
} else {
print '<span class="opacitymedium">-</span>';
}
print '</div>';
print '</div>';
print '</div>';
print '<div class="fichethirdleft">';
// Aluminium
print '<div class="info-box">';
print '<div class="info-box-icon bg-infobox-project">';
print img_picto('', 'fa-coins', 'class="fa-2x"');
print '</div>';
print '<div class="info-box-content">';
print '<span class="info-box-title">'.$langs->trans("MetallzuschlagALShort").'</span><br>';
if ($latestAL) {
print '<span class="info-box-number">'.price($latestAL->value, 0, '', 1, -1, 2).' <small>€/100kg</small></span><br>';
if (!empty($latestAL->value_month_avg)) {
print '<span class="opacitymedium">'.$langs->trans("MetallzuschlagMonthAvg").': '.price($latestAL->value_month_avg, 0, '', 1, -1, 2).' €/100kg</span><br>';
}
print '<span class="opacitymedium">'.dol_print_date($db->jdate($latestAL->date_notiz), 'day').'</span>';
} else {
print '<span class="opacitymedium">-</span>';
}
print '</div>';
print '</div>';
print '</div>';
print '<div class="fichethirdleft">';
// Button: Jetzt abrufen
if ($user->hasRight('metallzuschlag', 'config')) {
print '<div class="info-box">';
print '<div class="info-box-content" style="padding: 15px;">';
print '<a class="butAction" href="'.$_SERVER["PHP_SELF"].'?action=fetch&token='.newToken().'">';
print img_picto('', 'fa-sync', 'class="paddingright"');
print $langs->trans("MetallzuschlagFetchNow");
print '</a>';
if ($latestCU) {
print '<br><br><span class="opacitymedium">'.$langs->trans("MetallzuschlagLastUpdate").': '.dol_print_date($db->jdate($latestCU->date_notiz), 'day').'</span>';
}
print '</div>';
print '</div>';
}
print '</div>';
} else {
// Keine Daten vorhanden
print '<div class="opacitymedium">'.$langs->trans("MetallzuschlagNoData").'</div>';
print '<br>';
if ($user->hasRight('metallzuschlag', 'config')) {
print '<a class="butAction" href="'.$_SERVER["PHP_SELF"].'?action=fetch&token='.newToken().'">';
print img_picto('', 'fa-sync', 'class="paddingright"');
print $langs->trans("MetallzuschlagFetchNow");
print '</a>';
}
}
print '</div>';
print '<div class="clearboth"></div>';
// Diagramm: Notierungsverlauf
$chartDays = GETPOSTINT('chart_days') ?: 90;
$chartData = $api->getChartData($chartDays);
if (!empty($chartData['labels'])) {
print '<br>';
// Zeitraum-Auswahl
$chartButtons = '';
foreach (array(30, 90, 365) as $d) {
$active = ($chartDays == $d) ? ' butActionActive' : '';
$label = $langs->trans('MetallzuschlagLast'.$d.'Days');
$chartButtons .= '<a class="butAction'.$active.' small" href="'.$_SERVER["PHP_SELF"].'?chart_days='.$d.'">'.$label.'</a> ';
}
print load_fiche_titre($langs->trans("MetallzuschlagChart"), $chartButtons, '');
print '<div style="max-width: 100%; height: 400px;">';
print '<canvas id="metallzuschlagChart"></canvas>';
print '</div>';
// Chart.js-Daten vorbereiten
$jsLabels = json_encode($chartData['labels']);
$jsCU = json_encode($chartData['cu']);
$jsAL = json_encode($chartData['al']);
$labelCU = $langs->trans("MetallzuschlagChartCU");
$labelAL = $langs->trans("MetallzuschlagChartAL");
print '<script src="'.DOL_URL_ROOT.'/includes/nnnick/chartjs/dist/chart.min.js"></script>';
print '<script>';
print 'document.addEventListener("DOMContentLoaded", function() {';
print ' var chartCtx = document.getElementById("metallzuschlagChart").getContext("2d");';
print ' var cuData = '.$jsCU.';';
print ' var alData = '.$jsAL.';';
print ' ';
print ' var metalDiffPlugin = {';
print ' id: "metalDiffLabels",';
print ' afterDatasetsDraw: function(chart) {';
print ' var c = chart.ctx;';
print ' chart.data.datasets.forEach(function(dataset, datasetIndex) {';
print ' var meta = chart.getDatasetMeta(datasetIndex);';
print ' if (meta.hidden) return;';
print ' var dataArr = dataset.data;';
print ' c.font = "10px Arial";';
print ' c.textAlign = "center";';
print ' meta.data.forEach(function(point, idx) {';
print ' if (idx === 0 || dataArr[idx] === null || dataArr[idx - 1] === null) return;';
print ' var diffVal = dataArr[idx] - dataArr[idx - 1];';
print ' if (Math.abs(diffVal) < 0.01) return;';
print ' var signStr = diffVal > 0 ? "+" : "";';
print ' c.fillStyle = dataset.borderColor;';
print ' c.fillText(signStr + diffVal.toFixed(1), point.x, point.y - 8);';
print ' });';
print ' });';
print ' }';
print ' };';
print ' ';
print ' new Chart(chartCtx, {';
print ' type: "line",';
print ' plugins: [metalDiffPlugin],';
print ' data: {';
print ' labels: '.$jsLabels.',';
print ' datasets: [{';
print ' label: "'.dol_escape_js($labelCU).'",';
print ' data: cuData,';
print ' borderColor: "#b87333",';
print ' backgroundColor: "rgba(184, 115, 51, 0.1)",';
print ' borderWidth: 2,';
print ' fill: true,';
print ' tension: 0.3,';
print ' spanGaps: true,';
print ' yAxisID: "yCU"';
print ' }, {';
print ' label: "'.dol_escape_js($labelAL).'",';
print ' data: alData,';
print ' borderColor: "#a8a9ad",';
print ' backgroundColor: "rgba(168, 169, 173, 0.1)",';
print ' borderWidth: 2,';
print ' fill: true,';
print ' tension: 0.3,';
print ' spanGaps: true,';
print ' yAxisID: "yAL"';
print ' }]';
print ' },';
print ' options: {';
print ' responsive: true,';
print ' maintainAspectRatio: false,';
print ' interaction: { mode: "index", intersect: false },';
print ' plugins: {';
print ' tooltip: {';
print ' callbacks: {';
print ' label: function(tipContext) {';
print ' var v = tipContext.parsed.y !== null ? tipContext.parsed.y.toFixed(2) : "-";';
print ' var diffStr = "";';
print ' if (tipContext.dataIndex > 0 && tipContext.parsed.y !== null) {';
print ' var prevVal = tipContext.dataset.data[tipContext.dataIndex - 1];';
print ' if (prevVal !== null) {';
print ' var dv = tipContext.parsed.y - prevVal;';
print ' diffStr = " (" + (dv >= 0 ? "+" : "") + dv.toFixed(2) + ")";';
print ' }';
print ' }';
print ' return tipContext.dataset.label + ": " + v + " €/100kg" + diffStr;';
print ' }';
print ' }';
print ' }';
print ' },';
print ' scales: {';
print ' x: {';
print ' ticks: { maxTicksLimit: 12 }';
print ' },';
print ' yCU: {';
print ' type: "linear",';
print ' position: "left",';
print ' title: { display: true, text: "'.dol_escape_js($labelCU).'" },';
print ' ticks: { callback: function(v) { return v.toFixed(0) + " €"; } }';
print ' },';
print ' yAL: {';
print ' type: "linear",';
print ' position: "right",';
print ' title: { display: true, text: "'.dol_escape_js($labelAL).'" },';
print ' ticks: { callback: function(v) { return v.toFixed(0) + " €"; } },';
print ' grid: { drawOnChartArea: false }';
print ' }';
print ' }';
print ' }';
print ' });';
print '});';
print '</script>';
}
// Kabel-Diagramm: Kupferzuschlag pro Kabel
$cablesWithKupfer = $api->getProductsWithKupfergehalt();
if (!empty($cablesWithKupfer) && !empty($chartData['labels'])) {
print '<br>';
// Parameter auslesen
$cableMode = GETPOST('cable_mode', 'alpha') ?: 'per_meter';
// Beide Modi Daten laden (fuer JavaScript-Wechsel)
$cableChartDataPerMeter = $api->getCableChartData($chartDays, array(), 'per_meter');
$cableChartDataTotal = $api->getCableChartData($chartDays, array(), 'total');
print load_fiche_titre($langs->trans("MetallzuschlagCableChart"), '', '');
// Steuerelemente (Modus, Differenz, Alle ein/aus)
print '<div style="margin-bottom: 15px; display: flex; flex-wrap: wrap; gap: 15px; align-items: center;">';
// Modus-Auswahl
print '<div>';
print '<label style="margin-right: 10px;">';
print '<input type="radio" name="cable_mode_js" value="per_meter"'.($cableMode == 'per_meter' ? ' checked' : '').' onchange="cableChartSwitchMode(this.value)"> ';
print $langs->trans("MetallzuschlagPerMeter");
print '</label>';
print '<label>';
print '<input type="radio" name="cable_mode_js" value="total"'.($cableMode == 'total' ? ' checked' : '').' onchange="cableChartSwitchMode(this.value)"> ';
print $langs->trans("MetallzuschlagTotalAmount");
print '</label>';
print '</div>';
// Differenz-Anzeige Checkbox
print '<div>';
print '<label>';
print '<input type="checkbox" id="cableShowDiff" onchange="cableChartToggleDiff()"> ';
print $langs->trans("MetallzuschlagShowDiff");
print '</label>';
print '</div>';
// Alle ein/aus Button
print '<div>';
print '<a class="butAction small" href="#" onclick="cableChartToggleAll(); return false;">'.$langs->trans("MetallzuschlagAllCables").'</a>';
print '</div>';
print '</div>';
// Kabel-Auswahl (Checkboxen)
print '<div class="div-table-responsive-no-min" style="margin-bottom: 15px;">';
print '<div class="titre inline-block">'.$langs->trans("MetallzuschlagSelectCables").'</div>';
print '<div style="display: flex; flex-wrap: wrap; gap: 10px 20px; margin: 10px 0; align-items: flex-start;">';
$colorIndex = 0;
$colors = array(
'#e6194B', '#3cb44b', '#ffe119', '#4363d8', '#f58231',
'#911eb4', '#42d4f4', '#f032e6', '#bfef45', '#fabed4',
'#469990', '#dcbeff', '#9A6324', '#fffac8', '#800000',
);
foreach ($cablesWithKupfer as $cable) {
$color = $colors[$colorIndex % count($colors)];
print '<label style="flex: 0 0 calc(33.33% - 20px); min-width: 200px; white-space: nowrap;">';
print '<input type="checkbox" class="cable-checkbox" data-id="'.$cable->rowid.'" checked onchange="cableChartUpdateVisibility()"> ';
print '<span style="color: '.$color.'; font-weight: bold;">&#9632;</span> ';
print dol_escape_htmltag($cable->ref);
if (!empty($cable->label)) {
print ' <span class="opacitymedium">('.dol_trunc($cable->label, 25).')</span>';
}
print '</label>';
$colorIndex++;
}
print '</div>';
print '</div>';
// Chart Canvas
if (!empty($cableChartDataPerMeter['products'])) {
print '<div style="max-width: 100%; height: 400px;">';
print '<canvas id="cableChart"></canvas>';
print '</div>';
// Datasets fuer beide Modi vorbereiten
$jsLabels = json_encode($cableChartDataPerMeter['labels']);
$datasetsPerMeter = array();
$datasetsTotal = array();
$colorIndex = 0;
foreach ($cableChartDataPerMeter['products'] as $productId => $productData) {
$color = $colors[$colorIndex % count($colors)];
$datasetsPerMeter[] = array(
'label' => $productData['label'],
'data' => $productData['data'],
'borderColor' => $color,
'backgroundColor' => 'transparent',
'borderWidth' => 2,
'tension' => 0.3,
'spanGaps' => true,
'productId' => $productId,
);
$colorIndex++;
}
$colorIndex = 0;
foreach ($cableChartDataTotal['products'] as $productId => $productData) {
$color = $colors[$colorIndex % count($colors)];
$datasetsTotal[] = array(
'label' => $productData['label'],
'data' => $productData['data'],
'borderColor' => $color,
'backgroundColor' => 'transparent',
'borderWidth' => 2,
'tension' => 0.3,
'spanGaps' => true,
'productId' => $productId,
);
$colorIndex++;
}
$jsDatasetsPerMeter = json_encode($datasetsPerMeter);
$jsDatasetsTotal = json_encode($datasetsTotal);
$yAxisLabelPerMeter = $langs->trans("MetallzuschlagPerMeterEUR");
$yAxisLabelTotal = $langs->trans("MetallzuschlagTotalAmountEUR");
print '<script>';
print 'var cableChartInstance = null;';
print 'var cableChartLabels = '.$jsLabels.';';
print 'var cableChartDatasetsPerMeter = '.$jsDatasetsPerMeter.';';
print 'var cableChartDatasetsTotal = '.$jsDatasetsTotal.';';
print 'var cableChartCurrentMode = "'.dol_escape_js($cableMode).'";';
print 'var cableChartShowDiff = false;';
print 'var cableChartYLabelPerMeter = "'.dol_escape_js($yAxisLabelPerMeter).'";';
print 'var cableChartYLabelTotal = "'.dol_escape_js($yAxisLabelTotal).'";';
print '';
print 'var cableDiffPlugin = {';
print ' id: "cableDiffLabels",';
print ' afterDatasetsDraw: function(chart) {';
print ' if (!cableChartShowDiff) return;';
print ' var ctx = chart.ctx;';
print ' chart.data.datasets.forEach(function(dataset, i) {';
print ' var meta = chart.getDatasetMeta(i);';
print ' if (meta.hidden) return;';
print ' var data = dataset.data;';
print ' ctx.font = "9px Arial";';
print ' ctx.textAlign = "center";';
print ' meta.data.forEach(function(point, index) {';
print ' if (index === 0 || data[index] === null || data[index - 1] === null) return;';
print ' var diff = data[index] - data[index - 1];';
print ' if (Math.abs(diff) < 0.001) return;';
print ' var sign = diff > 0 ? "+" : "";';
print ' ctx.fillStyle = dataset.borderColor;';
print ' ctx.fillText(sign + diff.toFixed(2), point.x, point.y - 6);';
print ' });';
print ' });';
print ' }';
print '};';
print '';
print 'function cableChartGetDatasets() {';
print ' var datasets = cableChartCurrentMode === "total" ? cableChartDatasetsTotal : cableChartDatasetsPerMeter;';
print ' return JSON.parse(JSON.stringify(datasets));';
print '}';
print '';
print 'function cableChartInit() {';
print ' var ctx = document.getElementById("cableChart").getContext("2d");';
print ' var yLabel = cableChartCurrentMode === "total" ? cableChartYLabelTotal : cableChartYLabelPerMeter;';
print ' cableChartInstance = new Chart(ctx, {';
print ' type: "line",';
print ' plugins: [cableDiffPlugin],';
print ' data: {';
print ' labels: cableChartLabels,';
print ' datasets: cableChartGetDatasets()';
print ' },';
print ' options: {';
print ' responsive: true,';
print ' maintainAspectRatio: false,';
print ' interaction: { mode: "index", intersect: false },';
print ' plugins: {';
print ' legend: { display: false },';
print ' tooltip: {';
print ' callbacks: {';
print ' label: function(ctx) {';
print ' var val = ctx.parsed.y !== null ? ctx.parsed.y.toFixed(2) : "-";';
print ' var diff = "";';
print ' if (ctx.dataIndex > 0 && ctx.parsed.y !== null) {';
print ' var prev = ctx.dataset.data[ctx.dataIndex - 1];';
print ' if (prev !== null) {';
print ' var d = ctx.parsed.y - prev;';
print ' diff = " (" + (d >= 0 ? "+" : "") + d.toFixed(2) + ")";';
print ' }';
print ' }';
print ' return ctx.dataset.label + ": " + val + " €" + diff;';
print ' }';
print ' }';
print ' }';
print ' },';
print ' scales: {';
print ' x: { ticks: { maxTicksLimit: 12 } },';
print ' y: {';
print ' type: "linear",';
print ' position: "left",';
print ' title: { display: true, text: yLabel },';
print ' ticks: { callback: function(v) { return v.toFixed(2) + " €"; } }';
print ' }';
print ' }';
print ' }';
print ' });';
print ' cableChartUpdateVisibility();';
print '}';
print '';
print 'function cableChartSwitchMode(mode) {';
print ' cableChartCurrentMode = mode;';
print ' var datasets = cableChartGetDatasets();';
print ' cableChartInstance.data.datasets = datasets;';
print ' cableChartInstance.options.scales.y.title.text = mode === "total" ? cableChartYLabelTotal : cableChartYLabelPerMeter;';
print ' cableChartUpdateVisibility();';
print '}';
print '';
print 'function cableChartToggleDiff() {';
print ' cableChartShowDiff = document.getElementById("cableShowDiff").checked;';
print ' cableChartInstance.update();';
print '}';
print '';
print 'function cableChartUpdateVisibility() {';
print ' var checkboxes = document.querySelectorAll(".cable-checkbox");';
print ' var visibleIds = [];';
print ' checkboxes.forEach(function(cb) {';
print ' if (cb.checked) visibleIds.push(parseInt(cb.dataset.id));';
print ' });';
print ' cableChartInstance.data.datasets.forEach(function(ds, i) {';
print ' var meta = cableChartInstance.getDatasetMeta(i);';
print ' meta.hidden = !visibleIds.includes(ds.productId);';
print ' });';
print ' cableChartInstance.update();';
print '}';
print '';
print 'function cableChartToggleAll() {';
print ' var checkboxes = document.querySelectorAll(".cable-checkbox");';
print ' var allChecked = Array.from(checkboxes).every(cb => cb.checked);';
print ' checkboxes.forEach(cb => cb.checked = !allChecked);';
print ' cableChartUpdateVisibility();';
print '}';
print '';
print 'document.addEventListener("DOMContentLoaded", cableChartInit);';
print '</script>';
} else {
print '<div class="opacitymedium">'.$langs->trans("MetallzuschlagNoData").'</div>';
}
}
// Verlaufstabelle
print '<br>';
print load_fiche_titre($langs->trans("MetallzuschlagHistory"), '', '');
$history = $api->getHistory('sonepar', 60);
if (!empty($history)) {
print '<table class="noborder centpercent">';
print '<tr class="liste_titre">';
print '<td>'.$langs->trans("MetallzuschlagDate").'</td>';
print '<td>'.$langs->trans("MetallzuschlagMetal").'</td>';
print '<td class="right">'.$langs->trans("MetallzuschlagValue").'</td>';
print '<td class="right">'.$langs->trans("MetallzuschlagMonthAvg").'</td>';
print '<td>'.$langs->trans("MetallzuschlagSourceCol").'</td>';
print '</tr>';
foreach ($history as $row) {
print '<tr class="oddeven">';
print '<td>'.dol_print_date($db->jdate($row->date_notiz), 'day').'</td>';
print '<td>'.metallzuschlagGetMetalLabel($row->metal).'</td>';
print '<td class="right">'.price($row->value, 0, '', 1, -1, 2).' €/100kg</td>';
print '<td class="right">'.(!empty($row->value_month_avg) ? price($row->value_month_avg, 0, '', 1, -1, 2).' €/100kg' : '-').'</td>';
print '<td>'.dol_escape_htmltag($row->source).'</td>';
print '</tr>';
}
print '</table>';
} else {
print '<div class="opacitymedium">'.$langs->trans("MetallzuschlagNoData").'</div>';
}
llxFooter();
$db->close();