materials_update.php

<?php
require_once 'includes/auth.php';
require_login();
require_csrf();
require_once 'includes/db.php';

$id = (int)$_POST['id'];
$product_code = trim($_POST['product_code'] ?? '');
$product_name = trim($_POST['product_name'] ?? '');
$description = trim($_POST['description'] ?? '');
$stock = floatval($_POST['stock'] ?? 0);
$warehouse_location = trim($_POST['warehouse_location'] ?? '');
$unit = trim($_POST['unit'] ?? '');
$unit_value = trim($_POST['unit_value'] ?? '');
$qr_unit_pack = trim($_POST['qr_unit_pack'] ?? '');
$product_group = trim($_POST['product_group'] ?? '');
$purchase_price = floatval($_POST['purchase_price'] ?? 0);
$purchase_time = (int)($_POST['purchase_time'] ?? 0);
$supplier = trim($_POST['supplier'] ?? '');
$is_active = isset($_POST['is_active']) ? (int)$_POST['is_active'] : 1;

// Duplicate check only if code has changed
$stmt = $pdo->prepare("SELECT id FROM materials WHERE product_code=? AND id<>?");
$stmt->execute([$product_code, $id]);
if ($stmt->fetch()) {
    echo json_encode(['success'=>false, 'message'=>'The product code already exists!']);
    exit;
}

$stmt = $pdo->prepare("UPDATE materials SET product_code=?, product_name=?, description=?, stock=?, warehouse_location=?, unit=?, unit_value=?, qr_unit_pack=?, product_group=?, purchase_price=?, purchase_time=?, supplier=?, is_active=? WHERE id=?");
$res = $stmt->execute([
    $product_code, $product_name, $description, $stock, $warehouse_location, $unit, $unit_value, $qr_unit_pack, $product_group,
    $purchase_price, $purchase_time, $supplier, $is_active, $id
]);
echo json_encode(['success'=>$res]);