<?php
/* Copyright (C) 2026 Alles Watt lauft
 *
 * Admin page to manage installation system categories
 */

$res = 0;
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 DOL_DOCUMENT_ROOT.'/core/class/html.form.class.php';
dol_include_once('/kundenkarte/lib/kundenkarte.lib.php');

$langs->loadLangs(array('admin', 'kundenkarte@kundenkarte'));

// Security check
if (!$user->admin && !$user->hasRight('kundenkarte', 'admin')) {
	accessforbidden();
}

$action = GETPOST('action', 'aZ09');
$confirm = GETPOST('confirm', 'alpha');
$systemId = GETPOSTINT('systemid');

$form = new Form($db);

/*
 * Actions
 */

if ($action == 'add') {
	$code = GETPOST('code', 'aZ09');
	$label = GETPOST('label', 'alphanohtml');
	$picto = GETPOST('picto', 'alphanohtml');
	$color = GETPOST('color', 'alphanohtml');
	$position = GETPOSTINT('position');

	if (empty($code) || empty($label)) {
		setEventMessages($langs->trans('ErrorFieldRequired'), null, 'errors');
	} else {
		$sql = "INSERT INTO ".MAIN_DB_PREFIX."c_kundenkarte_anlage_system";
		$sql .= " (code, label, picto, color, position, active, entity)";
		$sql .= " VALUES ('".$db->escape(strtoupper($code))."', '".$db->escape($label)."',";
		$sql .= " ".($picto ? "'".$db->escape($picto)."'" : "NULL").",";
		$sql .= " ".($color ? "'".$db->escape($color)."'" : "NULL").",";
		$sql .= " ".((int) $position).", 1, 0)";

		$result = $db->query($sql);
		if ($result) {
			setEventMessages($langs->trans('RecordSaved'), null, 'mesgs');
		} else {
			setEventMessages($db->lasterror(), null, 'errors');
		}
	}
	$action = '';
}

if ($action == 'update') {
	$code = GETPOST('code', 'aZ09');
	$label = GETPOST('label', 'alphanohtml');
	$picto = GETPOST('picto', 'alphanohtml');
	$color = GETPOST('color', 'alphanohtml');
	$position = GETPOSTINT('position');

	$sql = "UPDATE ".MAIN_DB_PREFIX."c_kundenkarte_anlage_system SET";
	$sql .= " code = '".$db->escape(strtoupper($code))."'";
	$sql .= ", label = '".$db->escape($label)."'";
	$sql .= ", picto = ".($picto ? "'".$db->escape($picto)."'" : "NULL");
	$sql .= ", color = ".($color ? "'".$db->escape($color)."'" : "NULL");
	$sql .= ", position = ".((int) $position);
	$sql .= " WHERE rowid = ".((int) $systemId);

	$result = $db->query($sql);
	if ($result) {
		setEventMessages($langs->trans('RecordSaved'), null, 'mesgs');
	} else {
		setEventMessages($db->lasterror(), null, 'errors');
	}
	$action = '';
}

if ($action == 'confirm_delete' && $confirm == 'yes') {
	// Check if in use
	$sql = "SELECT COUNT(*) as cnt FROM ".MAIN_DB_PREFIX."kundenkarte_anlage WHERE fk_system = ".((int) $systemId);
	$resql = $db->query($sql);
	$obj = $db->fetch_object($resql);

	if ($obj->cnt > 0) {
		setEventMessages($langs->trans('ErrorSystemInUse'), null, 'errors');
	} else {
		// Also delete types for this system
		$sql = "DELETE FROM ".MAIN_DB_PREFIX."kundenkarte_anlage_type WHERE fk_system = ".((int) $systemId);
		$db->query($sql);

		$sql = "DELETE FROM ".MAIN_DB_PREFIX."c_kundenkarte_anlage_system WHERE rowid = ".((int) $systemId);
		$result = $db->query($sql);
		if ($result) {
			setEventMessages($langs->trans('RecordDeleted'), null, 'mesgs');
		}
	}
	$action = '';
}

if ($action == 'activate') {
	$sql = "UPDATE ".MAIN_DB_PREFIX."c_kundenkarte_anlage_system SET active = 1 WHERE rowid = ".((int) $systemId);
	$db->query($sql);
	$action = '';
}

if ($action == 'deactivate') {
	$sql = "UPDATE ".MAIN_DB_PREFIX."c_kundenkarte_anlage_system SET active = 0 WHERE rowid = ".((int) $systemId);
	$db->query($sql);
	$action = '';
}

/*
 * View
 */

$title = $langs->trans('AnlagenSystems');

// Include CSS and JS
$morejs = array('/kundenkarte/js/kundenkarte.js?v=1769962608');
$morecss = array('/kundenkarte/css/kundenkarte.css?v=1769962608');

llxHeader('', $title, '', '', 0, 0, $morejs, $morecss);

$head = kundenkarteAdminPrepareHead();
print dol_get_fiche_head($head, 'systems', $langs->trans('ModuleKundenKarteName'), -1, 'fa-file');

// Confirmation
if ($action == 'delete') {
	print $form->formconfirm(
		$_SERVER['PHP_SELF'].'?systemid='.$systemId,
		$langs->trans('Delete'),
		$langs->trans('ConfirmDeleteSystem'),
		'confirm_delete',
		'',
		'yes',
		1
	);
}

// Add form
if ($action == 'create' || $action == 'edit') {
	$system = null;
	if ($action == 'edit' && $systemId > 0) {
		$sql = "SELECT * FROM ".MAIN_DB_PREFIX."c_kundenkarte_anlage_system WHERE rowid = ".((int) $systemId);
		$resql = $db->query($sql);
		$system = $db->fetch_object($resql);
	}

	print '<form method="POST" action="'.$_SERVER['PHP_SELF'].'">';
	print '<input type="hidden" name="token" value="'.newToken().'">';
	print '<input type="hidden" name="action" value="'.($action == 'edit' ? 'update' : 'add').'">';
	if ($action == 'edit') {
		print '<input type="hidden" name="systemid" value="'.$systemId.'">';
	}

	print '<table class="border centpercent">';

	print '<tr><td class="titlefield fieldrequired">'.$langs->trans('SystemCode').'</td>';
	print '<td><input type="text" name="code" class="flat minwidth200" value="'.dol_escape_htmltag($system ? $system->code : '').'" maxlength="32" required></td></tr>';

	print '<tr><td class="fieldrequired">'.$langs->trans('SystemLabel').'</td>';
	print '<td><input type="text" name="label" class="flat minwidth300" value="'.dol_escape_htmltag($system ? $system->label : '').'" required></td></tr>';

	print '<tr><td>'.$langs->trans('SystemPicto').'</td>';
	print '<td><div class="kundenkarte-icon-picker-wrapper">';
	print '<span class="kundenkarte-icon-preview">';
	if ($system && $system->picto) {
		print kundenkarte_render_icon($system->picto);
	}
	print '</span>';
	print '<input type="text" name="picto" class="flat minwidth200" value="'.dol_escape_htmltag($system ? $system->picto : '').'" placeholder="fa-bolt">';
	print '<button type="button" class="kundenkarte-icon-picker-btn" data-input="picto"><i class="fa fa-th"></i> '.$langs->trans('SelectIcon').'</button>';
	print '</div></td></tr>';

	print '<tr><td>'.$langs->trans('SystemColor').'</td>';
	print '<td><input type="color" name="color" value="'.dol_escape_htmltag($system ? $system->color : '#3498db').'"></td></tr>';

	print '<tr><td>'.$langs->trans('Position').'</td>';
	print '<td><input type="number" name="position" class="flat" value="'.($system ? $system->position : 0).'" min="0"></td></tr>';

	print '</table>';

	print '<div class="center" style="margin-top:20px;">';
	print '<button type="submit" class="button">'.$langs->trans('Save').'</button>';
	print ' <a class="button button-cancel" href="'.$_SERVER['PHP_SELF'].'">'.$langs->trans('Cancel').'</a>';
	print '</div>';

	print '</form>';

} else {
	// List
	print '<div style="margin-bottom:15px;">';
	print '<a class="button" href="'.$_SERVER['PHP_SELF'].'?action=create">';
	print '<i class="fa fa-plus"></i> '.$langs->trans('AddSystem');
	print '</a>';
	print '</div>';

	$sql = "SELECT * FROM ".MAIN_DB_PREFIX."c_kundenkarte_anlage_system ORDER BY position ASC, label ASC";
	$resql = $db->query($sql);

	print '<table class="noborder centpercent">';
	print '<tr class="liste_titre">';
	print '<th>'.$langs->trans('SystemCode').'</th>';
	print '<th>'.$langs->trans('SystemLabel').'</th>';
	print '<th>'.$langs->trans('SystemPicto').'</th>';
	print '<th class="center">'.$langs->trans('Position').'</th>';
	print '<th class="center">'.$langs->trans('Status').'</th>';
	print '<th class="center">'.$langs->trans('Actions').'</th>';
	print '</tr>';

	if ($resql) {
		while ($obj = $db->fetch_object($resql)) {
			print '<tr class="oddeven">';

			print '<td>'.dol_escape_htmltag($obj->code).'</td>';
			print '<td>'.dol_escape_htmltag($obj->label).'</td>';
			print '<td>';
			if ($obj->picto) {
				print kundenkarte_render_icon($obj->picto, '', 'color:'.$obj->color.';').' ';
				print dol_escape_htmltag($obj->picto);
			}
			print '</td>';
			print '<td class="center">'.$obj->position.'</td>';

			print '<td class="center">';
			if ($obj->active) {
				print '<a href="'.$_SERVER['PHP_SELF'].'?action=deactivate&systemid='.$obj->rowid.'&token='.newToken().'">'.img_picto($langs->trans('Enabled'), 'switch_on').'</a>';
			} else {
				print '<a href="'.$_SERVER['PHP_SELF'].'?action=activate&systemid='.$obj->rowid.'&token='.newToken().'">'.img_picto($langs->trans('Disabled'), 'switch_off').'</a>';
			}
			print '</td>';

			print '<td class="center nowraponall">';
			print '<a href="'.$_SERVER['PHP_SELF'].'?action=edit&systemid='.$obj->rowid.'">'.img_edit().'</a>';
			print ' <a href="'.$_SERVER['PHP_SELF'].'?action=delete&systemid='.$obj->rowid.'" class="deletelink">'.img_delete().'</a>';
			print '</td>';

			print '</tr>';
		}
	}

	print '</table>';
}

print dol_get_fiche_end();

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