« Back to History
packing_material_in_entry.php
|
20260722_120325.php
Initial Domain Snapshot
Copy Code
<?php require_once __DIR__ . '/modules/auth/page_acl.php'; $ctx = page_require_access('packing_material_in_entry'); require_once __DIR__ . '/helpers/activity_helper.php'; $pdo = $ctx['pdo']; $company_id = $ctx['company_id']; $u = $ctx['user']; function h($value){ return htmlspecialchars((string)$value, ENT_QUOTES, 'UTF-8'); } function get_financial_year_label(string $dateValue): string { $ts = strtotime($dateValue); if ($ts === false) { return ''; } $year = (int)date('Y', $ts); $month = (int)date('n', $ts); if ($month >= 4) { return $year . '-' . substr((string)($year + 1), -2); } return ($year - 1) . '-' . substr((string)$year, -2); } function get_next_voucher_no(PDO $pdo, int $companyId, string $financialYear): int { $stmt = $pdo->prepare("SELECT COALESCE(MAX(voucher_no), 0) + 1 FROM packing_material_in WHERE company_id = ? AND financial_year = ? FOR UPDATE"); $stmt->execute([$companyId, $financialYear]); return (int)$stmt->fetchColumn(); } function normalize_uom(string $uom): string { $uom = strtolower(trim($uom)); if (in_array($uom, ['pcs', 'pc', 'piece', 'pieces'], true)) { return 'pcs'; } if (in_array($uom, ['kg', 'kgs', 'kilogram', 'kilograms'], true)) { return 'kg'; } return $uom; } function build_item_form_state(array $input, array $materialsById): array { $materialTypeId = (int)($input['material_type_id'] ?? 0); $materialMeta = $materialsById[$materialTypeId] ?? null; return [ 'material_type_id' => $materialTypeId, 'quality' => (string)($materialMeta['quality'] ?? ''), 'size' => (string)($materialMeta['size'] ?? ''), 'uom' => (string)($materialMeta['uom'] ?? ''), 'quantity' => (string)($input['quantity'] ?? ''), 'rate' => (string)($input['rate'] ?? ''), ]; } function build_item_payload(array $input, array $materialsById): ?array { $materialTypeId = (int)($input['material_type_id'] ?? 0); if ($materialTypeId <= 0 || !isset($materialsById[$materialTypeId])) { return null; } $materialMeta = $materialsById[$materialTypeId]; $quantityRaw = trim((string)($input['quantity'] ?? '')); $rateRaw = trim((string)($input['rate'] ?? '')); if ($quantityRaw === '') { return null; } $quantity = (float)$quantityRaw; $rate = ($rateRaw === '') ? 0.0 : (float)$rateRaw; $uom = normalize_uom((string)($materialMeta['uom'] ?? '')); if ($quantity <= 0 || $uom === '') { return null; } return [ 'material_type_id' => $materialTypeId, 'quality' => (string)($materialMeta['quality'] ?? ''), 'size' => (string)($materialMeta['size'] ?? ''), 'uom' => $uom, 'quantity' => $quantity, 'rate' => $rate, 'in_kg' => ($uom === 'kg') ? $quantity : 0.0, 'in_pcs' => ($uom === 'pcs') ? $quantity : 0.0, ]; } $materialStmt = $pdo->prepare("SELECT id, material_type, quality, size, uom FROM packing_material_type WHERE company_id = ? ORDER BY material_type ASC, quality ASC, size ASC"); $materialStmt->execute([$company_id]); $materials = $materialStmt->fetchAll(PDO::FETCH_ASSOC); $materialsById = []; $materialOptionsHtml = ''; foreach ($materials as $material) { $materialId = (int)$material['id']; $materialsById[$materialId] = [ 'material_type' => (string)($material['material_type'] ?? ''), 'quality' => (string)($material['quality'] ?? ''), 'size' => (string)($material['size'] ?? ''), 'uom' => normalize_uom((string)($material['uom'] ?? '')), ]; $materialOptionsHtml .= '<option value="' . h($materialId) . '" data-quality="' . h($materialsById[$materialId]['quality']) . '" data-size="' . h($materialsById[$materialId]['size']) . '" data-uom="' . h($materialsById[$materialId]['uom']) . '">' . h($materialsById[$materialId]['material_type'] . ' - ' . $materialsById[$materialId]['quality'] . ' - ' . $materialsById[$materialId]['size']) . '</option>'; } $partyStmt = $pdo->prepare("SELECT name FROM paking_material_party WHERE company_id = ? AND status = 1 ORDER BY name ASC"); $partyStmt->execute([$company_id]); $parties = $partyStmt->fetchAll(PDO::FETCH_COLUMN); $defaultItem = [ 'material_type_id' => 0, 'quality' => '', 'size' => '', 'uom' => '', 'quantity' => '', 'rate' => '', ]; $form = [ 'id' => 0, 'voucher_no' => '', 'entry_date' => date('Y-m-d'), 'party_name' => '', 'invoice_no' => '', 'remark' => '', 'items' => [$defaultItem], ]; $flash = null; /* ========================= EDIT FETCH ========================= */ if (isset($_GET['edit'])) { $editStmt = $pdo->prepare(" SELECT i.*, m.quality, m.uom FROM packing_material_in i LEFT JOIN packing_material_type m ON m.id = i.material_type_id AND m.company_id = i.company_id WHERE i.id = ? AND i.company_id = ? LIMIT 1 "); $editStmt->execute([(int)$_GET['edit'], $company_id]); $editRow = $editStmt->fetch(PDO::FETCH_ASSOC); if ($editRow) { $materialTypeId = (int)($editRow['material_type_id'] ?? 0); $uom = normalize_uom((string)($editRow['uom'] ?? ((float)($editRow['in_pcs'] ?? 0) > 0 ? 'pcs' : 'kg'))); $quantity = ($uom === 'pcs') ? (float)($editRow['in_pcs'] ?? 0) : (float)($editRow['in_kg'] ?? 0); $form = [ 'id' => (int)$editRow['id'], 'voucher_no' => (string)($editRow['voucher_no'] ?? ''), 'entry_date' => (string)($editRow['entry_date'] ?? date('Y-m-d')), 'party_name' => (string)($editRow['party_name'] ?? ''), 'invoice_no' => (string)($editRow['invoice_no'] ?? ''), 'remark' => (string)($editRow['remark'] ?? ''), 'items' => [[ 'material_type_id' => $materialTypeId, 'quality' => (string)($editRow['quality'] ?? ($materialsById[$materialTypeId]['quality'] ?? '')), 'size' => (string)($editRow['size'] ?? ($materialsById[$materialTypeId]['size'] ?? '')), 'uom' => $uom, 'quantity' => $quantity > 0 ? (string)$quantity : '', 'rate' => isset($editRow['rate']) ? (string)$editRow['rate'] : '', ]], ]; } } /* ========================= SAVE / UPDATE LOGIC ========================= */ if ($_SERVER['REQUEST_METHOD'] === 'POST') { $id = (int)($_POST['id'] ?? 0); $entryDate = $_POST['entry_date'] ?? date('Y-m-d'); $partyName = trim((string)($_POST['party_name'] ?? '')); $invoiceNo = trim((string)($_POST['invoice_no'] ?? '')); $remark = trim((string)($_POST['remark'] ?? '')); $financialYear = get_financial_year_label($entryDate); $month = date('Y-m-01', strtotime($entryDate)); $rawMaterialIds = $_POST['material_type_id'] ?? []; $rawQuantities = $_POST['quantity'] ?? []; $rawRates = $_POST['rate'] ?? []; if (!is_array($rawMaterialIds)) { $rawMaterialIds = [$rawMaterialIds]; } if (!is_array($rawQuantities)) { $rawQuantities = [$rawQuantities]; } if (!is_array($rawRates)) { $rawRates = [$rawRates]; } $formItems = []; $itemPayloads = []; foreach ($rawMaterialIds as $index => $rawMaterialId) { $rawItem = [ 'material_type_id' => $rawMaterialId, 'quantity' => $rawQuantities[$index] ?? '', 'rate' => $rawRates[$index] ?? '', ]; $formItems[] = build_item_form_state($rawItem, $materialsById); $payload = build_item_payload($rawItem, $materialsById); if ($payload) { $itemPayloads[] = $payload; } } if (empty($formItems)) { $formItems[] = $defaultItem; } $form = [ 'id' => $id, 'voucher_no' => (string)($_POST['voucher_no'] ?? ''), 'entry_date' => $entryDate, 'party_name' => $partyName, 'invoice_no' => $invoiceNo, 'remark' => $remark, 'items' => $formItems, ]; if ($partyName !== '' && $financialYear !== '' && !empty($itemPayloads)) { if ($id > 0) { $payload = $itemPayloads[0]; $updateStmt = $pdo->prepare(" UPDATE packing_material_in SET financial_year = ?, entry_date = ?, month = ?, party_name = ?, invoice_no = ?, material_type_id = ?, size = ?, in_kg = ?, in_pcs = ?, rate = ?, remark = ?, updated_at = NOW() WHERE id = ? AND company_id = ? "); $updateStmt->execute([ $financialYear, $entryDate, $month, $partyName, $invoiceNo, $payload['material_type_id'], $payload['size'], $payload['in_kg'], $payload['in_pcs'], $payload['rate'], $remark, $id, $company_id, ]); log_activity([ 'activity_type' => 'entry', 'module_name' => 'packing_material_in_entry', 'action_name' => 'update', 'activity_note' => "Updated packing material IN entry | ID: {$id}, Party: {$partyName}", 'reference_id' => $id, ]); $flash = ['type' => 'success', 'message' => 'Entry Updated']; $form = [ 'id' => 0, 'voucher_no' => '', 'entry_date' => $entryDate, 'party_name' => '', 'invoice_no' => '', 'remark' => '', 'items' => [$defaultItem], ]; } else { $insertStmt = $pdo->prepare(" INSERT INTO packing_material_in (company_id, financial_year, voucher_no, entry_date, month, party_name, invoice_no, material_type_id, size, in_kg, in_pcs, rate, remark) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) "); $pdo->beginTransaction(); try { $voucherNo = get_next_voucher_no($pdo, (int)$company_id, $financialYear); foreach ($itemPayloads as $payload) { $insertStmt->execute([ $company_id, $financialYear, $voucherNo, $entryDate, $month, $partyName, $invoiceNo, $payload['material_type_id'], $payload['size'], $payload['in_kg'], $payload['in_pcs'], $payload['rate'], $remark, ]); } $pdo->commit(); log_activity([ 'activity_type' => 'entry', 'module_name' => 'packing_material_in_entry', 'action_name' => 'save', 'activity_note' => "Saved packing material IN | Voucher: {$voucherNo}, Party: {$partyName}, Items: " . count($itemPayloads), 'reference_id' => $voucherNo, ]); $flash = ['type' => 'success', 'message' => count($itemPayloads) . ' item(s) saved | Voucher: ' . $voucherNo]; $form = [ 'id' => 0, 'voucher_no' => '', 'entry_date' => $entryDate, 'party_name' => '', 'invoice_no' => '', 'remark' => '', 'items' => [$defaultItem], ]; } catch (Throwable $e) { if ($pdo->inTransaction()) { $pdo->rollBack(); } $flash = ['type' => 'danger', 'message' => 'Save failed']; } } } else { $flash = ['type' => 'danger', 'message' => 'Required fields missing']; } } /* ========================= FETCH DATA ========================= */ $data = $pdo->prepare(" SELECT i.*, m.material_type, m.quality, m.uom FROM packing_material_in i LEFT JOIN packing_material_type m ON m.id = i.material_type_id AND m.company_id = i.company_id WHERE i.company_id = ? ORDER BY i.entry_date DESC, i.id DESC "); $data->execute([$company_id]); $rows = $data->fetchAll(PDO::FETCH_ASSOC); $voucherPreview = ''; if ((int)$form['id'] > 0) { $voucherPreview = (string)($form['voucher_no'] ?? ''); } else { try { $fyForPreview = get_financial_year_label((string)($form['entry_date'] ?? date('Y-m-d'))); if ($fyForPreview !== '') { $voucherPreview = (string)get_next_voucher_no($pdo, (int)$company_id, $fyForPreview); } } catch (Throwable $e) { $voucherPreview = ''; } } require_once __DIR__ . '/partials/header.php'; ?> <div class="container mt-3"> <h4 class="mb-3">Packing Material IN Entry</h4> <?php if ($flash): ?> <div class="alert alert-<?= h($flash['type']) ?>"><?= h($flash['message']) ?></div> <?php endif; ?> <form method="POST" class="card p-3 mb-4"> <input type="hidden" name="id" value="<?= h($form['id']) ?>"> <div class="mb-2"> <span class="badge bg-dark">Voucher No: <?= h($voucherPreview !== '' ? $voucherPreview : 'Auto') ?></span> </div> <div class="row g-3"> <div class="col-md-2"> <label>Date</label> <input type="date" name="entry_date" class="form-control" value="<?= h($form['entry_date']) ?>" required> </div> <div class="col-md-4"> <label>Party Name</label> <select name="party_name" class="form-select" required> <option value="">Select Party</option> <?php foreach ($parties as $partyName): ?> <option value="<?= h($partyName) ?>" <?= $form['party_name'] === $partyName ? 'selected' : '' ?>><?= h($partyName) ?></option> <?php endforeach; ?> </select> </div> <div class="col-md-3"> <label>Invoice No.</label> <input type="text" name="invoice_no" class="form-control" value="<?= h($form['invoice_no']) ?>"> </div> <div class="col-md-3"> <label>Remark</label> <input type="text" name="remark" class="form-control" value="<?= h($form['remark']) ?>"> </div> </div> <div class="d-flex justify-content-between align-items-center mt-4 mb-2"> <h6 class="mb-0">Items</h6> <?php if ((int)$form['id'] === 0): ?> <button type="button" class="btn btn-sm btn-outline-primary" id="addItemRow">Add Row</button> <?php endif; ?> </div> <div class="table-responsive"> <table class="table table-bordered align-middle mb-0" id="itemTable"> <thead class="table-light"> <tr> <th style="width:34%">Material</th> <th style="width:16%">Quality</th> <th style="width:12%">Size</th> <th style="width:10%">UOM</th> <th style="width:12%">Quantity</th> <th style="width:12%">Rate</th> <th style="width:4%"></th> </tr> </thead> <tbody> <?php foreach ($form['items'] as $item): ?> <tr class="item-row"> <td> <select name="material_type_id[]" class="form-select material-select" required> <option value="">Select Material</option> <?php foreach ($materials as $material): ?> <?php $materialId = (int)$material['id']; ?> <option value="<?= h($materialId) ?>" data-quality="<?= h($materialsById[$materialId]['quality']) ?>" data-size="<?= h($materialsById[$materialId]['size']) ?>" data-uom="<?= h($materialsById[$materialId]['uom']) ?>" <?= (int)$item['material_type_id'] === $materialId ? 'selected' : '' ?>> <?= h($materialsById[$materialId]['material_type'] . ' - ' . $materialsById[$materialId]['quality'] . ' - ' . $materialsById[$materialId]['size']) ?> </option> <?php endforeach; ?> </select> </td> <td><input type="text" class="form-control bg-light quality-input" value="<?= h($item['quality']) ?>" readonly></td> <td><input type="text" class="form-control bg-light size-input" value="<?= h($item['size']) ?>" readonly></td> <td><input type="text" class="form-control bg-light uom-input" value="<?= h($item['uom']) ?>" readonly></td> <td><input type="number" name="quantity[]" class="form-control quantity-input" step="0.001" value="<?= h($item['quantity']) ?>"></td> <td><input type="number" name="rate[]" class="form-control" step="0.01" value="<?= h($item['rate']) ?>"></td> <td class="text-center"> <button type="button" class="btn btn-sm btn-outline-danger remove-row" <?= ((int)$form['id'] > 0 || count($form['items']) === 1) ? 'disabled' : '' ?>>x</button> </td> </tr> <?php endforeach; ?> </tbody> </table> </div> <div class="mt-3 d-flex gap-2"> <button class="btn btn-primary"><?= (int)$form['id'] > 0 ? 'Update Entry' : 'Save Entry' ?></button> <?php if ((int)$form['id'] > 0): ?> <a href="<?= h($_SERVER['PHP_SELF']) ?>" class="btn btn-secondary">Cancel</a> <?php endif; ?> </div> </form> <div class="card p-3"> <h5>Recent Entries</h5> <table class="table table-bordered table-sm"> <thead> <tr> <th>Voucher No.</th> <th>Date</th> <th>Party</th> <th>Invoice No.</th> <th>Material</th> <th>Quality</th> <th>Size</th> <th>UOM</th> <th>Quantity</th> <th>Rate</th> <th>Remark</th> <th>Action</th> </tr> </thead> <tbody> <?php foreach ($rows as $r): ?> <?php $rowUom = normalize_uom((string)($r['uom'] ?? ((float)($r['in_pcs'] ?? 0) > 0 ? 'pcs' : 'kg'))); $rowQty = ($rowUom === 'pcs') ? (float)($r['in_pcs'] ?? 0) : (float)($r['in_kg'] ?? 0); $rowDecimals = ($rowUom === 'pcs') ? 2 : 3; ?> <tr> <td><?= h((string)($r['voucher_no'] ?? '')) ?></td> <td><?= h($r['entry_date']) ?></td> <td><?= h($r['party_name'] ?? '') ?></td> <td><?= h($r['invoice_no'] ?? '') ?></td> <td><?= h($r['material_type'] ?: ('Material #' . $r['material_type_id'])) ?></td> <td><?= h($r['quality'] ?? '') ?></td> <td><?= h($r['size']) ?></td> <td><?= h(strtoupper($rowUom)) ?></td> <td><?= number_format($rowQty, $rowDecimals) ?></td> <td><?= number_format((float)($r['rate'] ?? 0), 2) ?></td> <td><?= h($r['remark']) ?></td> <td> <a href="?edit=<?= (int)$r['id'] ?>" class="btn btn-sm btn-outline-primary">Edit</a> </td> </tr> <?php endforeach; ?> </tbody> </table> </div> </div> <template id="itemRowTemplate"> <tr class="item-row"> <td> <select name="material_type_id[]" class="form-select material-select" required> <option value="">Select Material</option> <?= $materialOptionsHtml ?> </select> </td> <td><input type="text" class="form-control bg-light quality-input" readonly></td> <td><input type="text" class="form-control bg-light size-input" readonly></td> <td><input type="text" class="form-control bg-light uom-input" readonly></td> <td><input type="number" name="quantity[]" class="form-control quantity-input" step="0.001"></td> <td><input type="number" name="rate[]" class="form-control" step="0.01"></td> <td class="text-center"><button type="button" class="btn btn-sm btn-outline-danger remove-row">x</button></td> </tr> </template> <script> const itemTableBody = document.querySelector('#itemTable tbody'); const addItemRowButton = document.getElementById('addItemRow'); const itemRowTemplate = document.getElementById('itemRowTemplate'); function syncItemRow(row) { const materialSelect = row.querySelector('.material-select'); const qualityInput = row.querySelector('.quality-input'); const sizeInput = row.querySelector('.size-input'); const uomInput = row.querySelector('.uom-input'); const quantityInput = row.querySelector('.quantity-input'); const selectedOption = materialSelect ? materialSelect.selectedOptions[0] : null; if (!selectedOption || !selectedOption.value) { qualityInput.value = ''; sizeInput.value = ''; uomInput.value = ''; quantityInput.step = '0.001'; return; } const uom = (selectedOption.dataset.uom || '').toLowerCase(); qualityInput.value = selectedOption.dataset.quality || ''; sizeInput.value = selectedOption.dataset.size || ''; uomInput.value = selectedOption.dataset.uom || ''; quantityInput.step = '0.001'; } function bindItemRow(row) { const materialSelect = row.querySelector('.material-select'); const removeButton = row.querySelector('.remove-row'); if (materialSelect) { materialSelect.addEventListener('change', () => syncItemRow(row)); syncItemRow(row); } if (removeButton) { removeButton.addEventListener('click', () => { if (!itemTableBody || itemTableBody.querySelectorAll('.item-row').length <= 1) { return; } row.remove(); }); } } if (itemTableBody) { itemTableBody.querySelectorAll('.item-row').forEach(bindItemRow); } if (addItemRowButton && itemRowTemplate && itemTableBody) { addItemRowButton.addEventListener('click', () => { const fragment = itemRowTemplate.content.cloneNode(true); const row = fragment.querySelector('.item-row'); itemTableBody.appendChild(fragment); bindItemRow(itemTableBody.lastElementChild); }); } </script> <?php require_once __DIR__ . '/partials/footer.php'; ?>