dolibarr.stockkonversion/admin/setup.php

<?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    stockkonversion/admin/setup.php
 * \ingroup stockkonversion
 * \brief   Admin-Seite: Info und Übersicht Produkte mit Umrechnungsfaktor
 */

// Dolibarr 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) {
	die("Include of main fails");
}

require_once DOL_DOCUMENT_ROOT."/core/lib/admin.lib.php";
require_once '../lib/stockkonversion.lib.php';

// Zugriffskontrolle
if (!$user->admin) {
	accessforbidden();
}

$langs->loadLangs(array("admin", "stockkonversion@stockkonversion", "products"));

/*
 * Ausgabe
 */

$title = "StockKonversionSetup";
llxHeader('', $langs->trans($title), '', '', 0, 0, '', '', '', 'mod-stockkonversion page-admin');

$linkback = '<a href="'.DOL_URL_ROOT.'/admin/modules.php?restore_lastsearch_values=1">'.$langs->trans("BackToModuleList").'</a>';
print load_fiche_titre($langs->trans($title), $linkback, 'title_setup');

$head = stockkonversionAdminPrepareHead();
print dol_get_fiche_head($head, 'settings', $langs->trans($title), -1, 'fa-exchange');

// Erklärung
print '<div class="opacitymedium">'.$langs->trans("StockKonversionSetupPage").'</div>';
print '<br>';

// Funktionsweise
print load_fiche_titre($langs->trans("StockKonversionHowItWorks"), '', 'fa-info-circle');
print '<div class="fichecenter">';
print '<ul>';
print '<li>'.$langs->trans("StockKonversionExplanation1").'</li>';
print '<li>'.$langs->trans("StockKonversionExplanation2").'</li>';
print '<li>'.$langs->trans("StockKonversionExplanation3").'</li>';
print '<li>'.$langs->trans("StockKonversionExplanation4").'</li>';
print '</ul>';
print '</div>';

// Hinweis
print '<div class="info">';
print '<strong>'.$langs->trans("StockKonversionNote").':</strong> ';
print $langs->trans("StockKonversionNoteText");
print '</div>';
print '<br>';

// Produkte mit Faktor > 1
print load_fiche_titre($langs->trans("StockKonversionProductsWithFactor"), '', 'fa-list');

$sql = "SELECT p.rowid, p.ref, p.label, p.stock, p.pmp,";
$sql .= " pe.umrechnungsfaktor";
$sql .= " FROM ".$db->prefix()."product as p";
$sql .= " INNER JOIN ".$db->prefix()."product_extrafields as pe ON pe.fk_object = p.rowid";
$sql .= " WHERE pe.umrechnungsfaktor > 1";
$sql .= " AND p.entity IN (".getEntity('product').")";
$sql .= " ORDER BY p.ref ASC";

$resql = $db->query($sql);

if ($resql) {
	$num = $db->num_rows($resql);

	if ($num > 0) {
		print '<table class="noborder centpercent">';
		print '<tr class="liste_titre">';
		print '<td>'.$langs->trans("Ref").'</td>';
		print '<td>'.$langs->trans("Label").'</td>';
		print '<td class="center">'.$langs->trans("StockKonversionFactor").'</td>';
		print '<td class="right">'.$langs->trans("StockKonversionCurrentStock").'</td>';
		print '<td class="right">'.$langs->trans("StockKonversionPMP").'</td>';
		print '</tr>';

		$i = 0;
		while ($i < $num) {
			$obj = $db->fetch_object($resql);

			print '<tr class="oddeven">';
			print '<td><a href="'.DOL_URL_ROOT.'/product/card.php?id='.$obj->rowid.'">'.dol_escape_htmltag($obj->ref).'</a></td>';
			print '<td>'.dol_escape_htmltag($obj->label).'</td>';
			print '<td class="center"><strong>'.(int)$obj->umrechnungsfaktor.'</strong></td>';
			print '<td class="right">'.($obj->stock !== null ? price2num($obj->stock, 'MS') : '-').'</td>';
			print '<td class="right">'.($obj->pmp > 0 ? price($obj->pmp) : '-').'</td>';
			print '</tr>';

			$i++;
		}

		print '</table>';
	} else {
		print '<div class="opacitymedium">'.$langs->trans("StockKonversionNoProducts").'</div>';
	}

	$db->free($resql);
} else {
	dol_print_error($db);
}

print dol_get_fiche_end();

llxFooter();
$db->close();