Eye/html/admin/customers/devvendors.php

<?php

$default_displayed=25;
require_once ($_SERVER['DOCUMENT_ROOT']."/inc/auth.php");
require_once ($_SERVER['DOCUMENT_ROOT']."/inc/languages/" . HTML_LANG . ".php");

// Сохранение изменений
if (getPOST("save") !== null) {
    $selected_ids = getPOST("f_id", null, []);
    
    if (!empty($selected_ids) && is_array($selected_ids)) {
        // Преобразуем в целые числа и оставляем только >= 10000
        $selected_ids = array_filter(array_map('intval', $selected_ids), fn($id) => $id >= 10000);
        
        if (!empty($selected_ids)) {
            $r_ids   = array_map('intval', getPOST("r_id",   null, []));
            $f_names = getPOST("f_name", null, []);
            
            foreach ($selected_ids as $vendor_id) {
                $idx = array_search($vendor_id, $r_ids, true);
                if ($idx === false) continue;
                
                $name = trim($f_names[$idx] ?? '');
                if ($name === '') continue;
                
                update_record($db_link, "vendors", "id = ?", ['name' => $name], [$vendor_id]);
            }
        }
    }
    
    header("Location: " . $_SERVER["REQUEST_URI"]);
    exit;
}

// Создание нового производителя
if (getPOST("create") !== null) {
    $vendor_name = trim(getPOST("new_vendor", null, ''));
    
    if ($vendor_name !== '') {
        $max_record = get_record_sql($db_link, "SELECT MAX(id) AS max_id FROM vendors");
        $next_id = (isset($max_record['max_id']) && $max_record['max_id'] >= 10000)
            ? (int)$max_record['max_id'] + 1
            : 10000;
            
        insert_record($db_link, "vendors", [
            'id'   => $next_id,
            'name' => $vendor_name
        ]);
    }
    
    header("Location: " . $_SERVER["REQUEST_URI"]);
    exit;
}

unset($_POST);
require_once ($_SERVER['DOCUMENT_ROOT']."/inc/header.php");
print_control_submenu($page_url);

?>
<div id="cont">
<br>

<form name="def" action="devvendors.php" method="post">

<table class="data">
<tr>
<td><b><?php print WEB_list_vendors; ?></b></td>
<td><?php print WEB_rows_at_page."&nbsp:";print_row_at_pages('rows',$displayed); ?></td>
<td><input type="submit" name="OK" value="<?php print WEB_btn_show; ?>"></td>
</tr>
</table>

<?php

$countSQL="SELECT Count(*) FROM vendors";
$count_records = get_single_field($db_link,$countSQL);
$total=ceil($count_records/$displayed);
if ($page>$total) { $page=$total; }
if ($page<1) { $page=1; }
$start = ($page * $displayed) - $displayed;
print_navigation($page_url,$page,$displayed,$count_records,$total);

?>
<table class="data">
<tr align="center">
<td><input type="checkbox" onClick="checkAll(this.checked);"></td>
<td><b>Id</b></td>
<td><b><?php echo WEB_model_vendor; ?></b></td>
<td><input type="submit" name='save' value="<?php echo WEB_btn_save; ?>"></td>
</tr>
<?php
$params[]=$displayed;
$params[]=$start;
$t_ou = get_records_sql($db_link,"SELECT * FROM vendors ORDER BY name LIMIT ? OFFSET ?", $params);
foreach ($t_ou as $row) {
    print "<tr align=center>\n";
    print "<td class=\"data\" style='padding:0'><input type=checkbox name=f_id[] value='{$row['id']}'></td>\n";
    print "<td class=\"data\"><input type=\"hidden\" name='r_id[]' value='{$row['id']}'>{$row['id']}</td>\n";
    print "<td class=\"data\"><input type=\"text\" name='f_name[]' value='{$row['name']}'></td>\n";
    print "<td class=\"data\"></td>\n";
    print "</tr>\n";
}
?>
</table>
<table>
<tr>
<td><input type=text name=new_vendor value="Unknown"></td>
<td><input type="submit" name="create" value="<?php echo WEB_btn_add; ?>"></td>
<td align="right"></td>
</tr>
</table>
</form>
<?php
require_once ($_SERVER['DOCUMENT_ROOT']."/inc/footer.php");
?>