<?php
    session_start();
    require_once '../../../assets/utils/db_auth.php';
    require_once '../../../assets/utils/classes/WarehouseManager.php';

    require_role($user_role, ['owner', 'admin']);

    try {
        $newWarehouseId = null;

        dbTransaction($pdo2, function($pdo) use ($data, $company_id, $logging, &$newWarehouseId) {
            $wh = new WarehouseManager($pdo, $company_id);
            $newWarehouseId = $wh->saveWarehouse($data, $logging);
        });

        if (!empty($newWarehouseId)) {
            $wh = new WarehouseManager($pdo2, $company_id);
            $wh->createStockTableForWarehouse((int)$newWarehouseId);
        }

        $answer['success'] = 1;

    } catch (PDOException $e) {
        $answer['success'] = 0;
        if ($e->getCode() === '23000' && strpos($e->getMessage(), 'company_id_warehouse_name') !== false) {
            $answer['message'] = 'Warehouse name already exists. Please use a different warehouse name.';
            http_response_code(400);
        } else {
            $answer['message'] = 'Database error, please try again';
            http_response_code(500);
        }

    } catch (Exception $e) {
        $answer['success'] = 0;
        $answer['message'] = $e->getMessage();
        http_response_code(400);
    }

    exit(json_encode($answer));
?>