materials_save.php

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

$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
$stmt = $pdo->prepare("SELECT id FROM materials WHERE product_code = ?");
$stmt->execute([$product_code]);
if ($stmt->fetch()) {
    echo json_encode(['success'=>false, 'message'=>'The product code already exists!']);
    exit;
}

$stmt = $pdo->prepare("INSERT INTO materials (product_code, product_name, description, stock, warehouse_location, unit, unit_value, qr_unit_pack, product_group, purchase_price, purchase_time, supplier, is_active)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)");
$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
]);
echo json_encode(['success'=>$res]);