View Code - 20260721

karigar_edit.php | 20260721_154032.php Initial Bulk Import

<?php
/* ================= AUTH BOOTSTRAP ================= */
require_once __DIR__ . '/modules/auth/page_acl.php';
$ctx = page_require_access('karigar_edit');

$u          = $ctx['user'];
$company_id = (int)$ctx['company_id'];
$pdo        = $ctx['pdo'];

require_once __DIR__ . '/partials/header.php';

/* ================= HELPERS ================= */
function h($v){ return htmlspecialchars((string)$v,ENT_QUOTES,'UTF-8'); }

$id = isset($_GET['id']) ? (int)$_GET['id'] : 0;
if($id<=0){
    header("Location: karigar_list.php");
    exit;
}

/* ================= FETCH ================= */
$stmt = $pdo->prepare("
    SELECT * 
    FROM loom_karigar_master 
    WHERE id=? AND company_id=? 
    LIMIT 1
");
$stmt->execute([$id,$company_id]);
$row = $stmt->fetch(PDO::FETCH_ASSOC);

if(!$row){
    echo '<div class="container mt-4"><div class="alert alert-danger">Record not found.</div></div>';
    require_once __DIR__.'/partials/footer.php';
    exit;
}

/* ================= SAVE ================= */
if($_SERVER['REQUEST_METHOD']==='POST'){

$karigar_name = $_POST['karigar_name'] ?? '';
    $khata_id     = $_POST['khata_id'] ?? null;
    $machine_from = $_POST['machine_from'] ?? null;
    $machine_to   = $_POST['machine_to'] ?? null;
    $entry_name   = $_POST['entry_name'] ?? '';
    $department_id= $_POST['department_id'] ?? null;
    $role_id      = $_POST['role_id'] ?? null;
    $is_active    = $_POST['is_active'] ?? 1;

$khata_id = $khata_id!=='' ? (int)$khata_id : null;

$khata_code = null;
    if($khata_id){
        $k=$pdo->prepare("
            SELECT khata_code 
            FROM loom_karigar_master
            WHERE khata_id=? AND company_id=? 
            LIMIT 1
        ");
        $k->execute([$khata_id,$company_id]);
        $khata_code=$k->fetchColumn();
    }

if(!$entry_name){
        $entry_name=$karigar_name;
        if($machine_from){
            $entry_name.=" ".$machine_from;
            if($machine_to){
                $entry_name.="-".$machine_to;
            }
        }
    }

$upd=$pdo->prepare("
        UPDATE loom_karigar_master SET
            khata_id=?,
            khata_code=?,
            karigar_name=?,
            machine_from=?,
            machine_to=?,
            entry_name=?,
            department_id=?,
            role_id=?,
            is_active=?
        WHERE id=? AND company_id=?
    ");

$upd->execute([
        $khata_id,
        $khata_code,
        $karigar_name,
        $machine_from ?: null,
        $machine_to ?: null,
        $entry_name,
        $department_id ?: null,
        $role_id ?: null,
        (int)$is_active,
        $id,
        $company_id
    ]);

/* reload */
    $stmt->execute([$id,$company_id]);
    $row = $stmt->fetch(PDO::FETCH_ASSOC);

echo '<div class="container mt-3"><div class="alert alert-success">Saved successfully.</div></div>';
}

/* ================= KHATA LIST ================= */
$KHATAS=[];
$s=$pdo->prepare("
    SELECT DISTINCT khata_id, khata_code
    FROM loom_karigar_master
    WHERE company_id=? AND khata_id IS NOT NULL
    ORDER BY khata_code
");
$s->execute([$company_id]);
$KHATAS=$s->fetchAll(PDO::FETCH_ASSOC);
?>

<div class="container mt-4">
<div class="card shadow-sm">
<div class="card-header bg-primary text-white">
<h5 class="mb-0">Karigar Edit — #<?= (int)$row['id'] ?></h5>
</div>
<div class="card-body">

<div class="row mb-3">
<div class="col-md-6">
<label class="form-label">Karigar Name</label>
<input class="form-control" name="karigar_name"
value="<?= h($row['karigar_name']) ?>">
</div>

<div class="col-md-6">
<label class="form-label">Status</label>
<select class="form-select" name="is_active">
<option value="1" <?= $row['is_active']==1?'selected':'' ?>>Active</option>
<option value="0" <?= $row['is_active']==0?'selected':'' ?>>Inactive</option>
</select>
</div>
</div>

<div class="mb-3">
<label class="form-label">Khata</label>
<select class="form-select" name="khata_id">
<option value="">-- Select --</option>
<?php foreach($KHATAS as $k): ?>
<option value="<?= $k['khata_id'] ?>"
<?= $row['khata_id']==$k['khata_id']?'selected':'' ?>>
<?= h($k['khata_code']) ?>
</option>
<?php endforeach; ?>
</select>
</div>

<div class="row mb-3">
<div class="col-md-4">
<label class="form-label">Machine From</label>
<input type="number" class="form-control"
name="machine_from"
value="<?= h($row['machine_from']) ?>">
</div>

<div class="col-md-4">
<label class="form-label">Machine To</label>
<input type="number" class="form-control"
name="machine_to"
value="<?= h($row['machine_to']) ?>">
</div>

<div class="col-md-4">
<label class="form-label">Entry Name</label>
<input class="form-control"
name="entry_name"
value="<?= h($row['entry_name']) ?>">
</div>
</div>

<div class="row mb-3">
<div class="col-md-6">
<label class="form-label">Department ID</label>
<input type="number" class="form-control"
name="department_id"
value="<?= h($row['department_id']) ?>">
</div>

</form>
</div>
</div>
</div>

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