View Code - 20260722

edit.php | 20260722_120325.php Initial Domain Snapshot

<?php
require_once __DIR__ . '/../includes/bootstrap.php';
require_once __DIR__ . '/../includes/header.php';
require_once __DIR__ . '/../includes/sidebar.php';

$id = max(0, (int)($_GET['id'] ?? 0));
$errMessage = '';

try {
    $stmt = $pdo->prepare("SELECT * FROM company_master WHERE id = ? LIMIT 1");
    $stmt->execute([$id]);
    $company = $stmt->fetch();

// Load active customer records for cross-reassignment options
    $tenantStmt = $pdo->query("SELECT tenant_id, tenant_name, tenant_code FROM tenant_master WHERE status = 'ACTIVE' ORDER BY tenant_name ASC");
    $tenants = $tenantStmt->fetchAll();
} catch (PDOException $e) {
    $company = false;
    $tenants = [];
}

if (!$company) {
    echo '<div class="alert alert-danger m-3">Target infrastructure framework parameter profile mapping missed.</div>';
    require_once __DIR__ . '/../includes/footer.php';
    exit;
}

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $tenant_id       = (int)($_POST['tenant_id'] ?? 0);
    $company_name    = trim($_POST['company_name'] ?? '');
    $company_address = trim($_POST['company_address'] ?? '');
    $deployment_type = trim($_POST['deployment_type'] ?? 'SHARED');

$primary_domain = trim($_POST['primary_domain'] ?? '');
    $db_host        = trim($_POST['db_host'] ?? '');
    $db_name        = trim($_POST['db_name'] ?? '');
    $db_user        = trim($_POST['db_user'] ?? '');
    $db_pass        = trim($_POST['db_pass'] ?? '');

if ($tenant_id > 0 && !empty($company_name) && !empty($company_address)) {
        try {
            $pdo->beginTransaction();

if ($deployment_type === 'SHARED') {
                $primary_domain = 'cloud.mistermanager.in';
                
                $updateStmt = $pdo->prepare("UPDATE company_master SET 
                    tenant_id = ?, company_name = ?, company_address = ?, deployment_type = ?, primary_domain = ?,
                    db_host = NULL, db_name = NULL, db_user = NULL, db_pass = NULL
                    WHERE id = ?");
                $updateStmt->execute([$tenant_id, $company_name, $company_address, $deployment_type, $primary_domain, $id]);
            } else {
                $updateStmt = $pdo->prepare("UPDATE company_master SET 
                    tenant_id = ?, company_name = ?, company_address = ?, deployment_type = ?, primary_domain = ?,
                    db_host = ?, db_name = ?, db_user = ?, db_pass = ?
                    WHERE id = ?");
                $updateStmt->execute([$tenant_id, $company_name, $company_address, $deployment_type, $primary_domain, $db_host, $db_name, $db_user, $db_pass, $id]);
            }

$pdo->commit();
            header("Location: /admin/company/list.php");
            exit;
        } catch (Exception $e) {
            $pdo->rollBack();
            $errMessage = "Runtime process exception details: " . $e->getMessage();
        }
    } else {
        $errMessage = "Structural data integrity error. Customer, Company Name, and Address cannot be blank.";
    }
}
?>

<div class="container-fluid p-0" style="max-width: 1000px;">
    <div class="d-flex justify-content-between align-items-center mb-4">
        <h4 class="m-0 fw-bold text-dark">Modify Corporate Entity Node</h4>
        <a href="/admin/company/list.php" class="btn btn-sm btn-outline-secondary">Return to List</a>
    </div>

<?php if (!empty($errMessage)): ?>
        <div class="alert alert-danger small"><?= htmlspecialchars($errMessage) ?></div>
    <?php endif; ?>

<div class="card border-0 shadow-sm bg-white p-4">
        <form action="edit.php?id=<?= $id ?>" method="POST">
            <div class="row g-3">
                <div class="col-md-6">
                    <label class="form-label small fw-semibold">Customer Account *</label>
                    <select name="tenant_id" class="form-select form-select-sm" required>
                        <?php foreach ($tenants as $t): ?>
                            <option value="<?= $t['tenant_id'] ?>" <?= $t['tenant_id'] == $company['tenant_id'] ? 'selected' : '' ?>>
                                <?= htmlspecialchars($t['tenant_name']) ?> (<?= htmlspecialchars($t['tenant_code']) ?>)
                            </option>
                        <?php endforeach; ?>
                    </select>
                </div>
                <div class="col-md-3">
                    <label class="form-label small fw-semibold">Company Name *</label>
                    <input type="text" name="company_name" class="form-control form-control-sm" value="<?= htmlspecialchars($company['company_name']) ?>" required>
                </div>
                <div class="col-md-3">
                    <label class="form-label small fw-semibold text-muted">Entity System Code (Immutable)</label>
                    <input type="text" class="form-control form-control-sm bg-light text-uppercase" value="<?= htmlspecialchars($company['company_code']) ?>" readonly>
                </div>

<div class="col-md-12">
                    <label class="form-label small fw-semibold">Company Address *</label>
                    <textarea name="company_address" class="form-control form-control-sm" rows="3" required><?= htmlspecialchars($company['company_address'] ?? '') ?></textarea>
                </div>

<div class="col-md-6">
                    <label class="form-label small fw-semibold">Deployment Type *</label>
                    <select name="deployment_type" id="deployment_type" class="form-select form-select-sm" required>
                        <option value="SHARED" <?= ($company['deployment_type'] ?? 'SHARED') === 'SHARED' ? 'selected' : '' ?>>SHARED</option>
                        <option value="DEDICATED" <?= ($company['deployment_type'] ?? '') === 'DEDICATED' ? 'selected' : '' ?>>DEDICATED</option>
                    </select>
                </div>

<div id="dedicated_configuration_fields" class="col-12 d-none">
                    <div class="row g-3">
                        <div class="col-12 mt-4">
                            <span class="text-uppercase text-secondary small fw-bold tracking-wider">Isolated Dedicated Pipeline Context Configuration</span>
                            <hr class="mt-1 mb-3">
                        </div>
                        <div class="col-md-12">
                            <label class="form-label small fw-semibold">Primary Subdomain / Target URL Mapping</label>
                            <input type="text" name="primary_domain" class="form-control form-control-sm" value="<?= htmlspecialchars($company['primary_domain'] ?? '') ?>">
                        </div>
                        <div class="col-md-3">
                            <label class="form-label small fw-semibold">Database Host</label>
                            <input type="text" name="db_host" class="form-control form-control-sm" value="<?= htmlspecialchars($company['db_host'] ?? '') ?>">
                        </div>
                        <div class="col-md-3">
                            <label class="form-label small fw-semibold">Target Database Name</label>
                            <input type="text" name="db_name" class="form-control form-control-sm" value="<?= htmlspecialchars($company['db_name'] ?? '') ?>">
                        </div>
                        <div class="col-md-3">
                            <label class="form-label small fw-semibold">Database Runtime User</label>
                            <input type="text" name="db_user" class="form-control form-control-sm" value="<?= htmlspecialchars($company['db_user'] ?? '') ?>">
                        </div>
                        <div class="col-md-3">
                            <label class="form-label small fw-semibold">Database Connection Secret</label>
                            <input type="password" name="db_pass" class="form-control form-control-sm" value="<?= htmlspecialchars($company['db_pass'] ?? '') ?>">
                        </div>
                    </div>
                </div>
            </div>

<div class="mt-4 border-top pt-3 text-end">
                <button type="submit" class="btn btn-sm btn-primary px-4">Persist Cluster Configuration</button>
            </div>
        </form>
    </div>
</div>

<?php require_once __DIR__ . '/../includes/footer.php'; ?>