View Code - 20260722

« Back to History

beam_entry_to_company_stock.php | 20260722_120325.php Initial Domain Snapshot

<?php
error_reporting(E_ALL);
ini_set('display_errors', 1);

require_once __DIR__ . '/modules/auth/page_acl.php';
$ctx = page_require_access('beam_entry_to_company_stock');

$pdo        = $ctx['pdo'] ?? null;
$company_id = (int)($ctx['company_id'] ?? 0);

if (!$pdo) {
    require_once __DIR__ . '/core/db.php';
}

function h($s){
    return htmlspecialchars((string)$s, ENT_QUOTES, 'UTF-8');
}

require_once __DIR__ . '/helpers/activity_helper.php';

$msg = '';
$err = '';

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

$beam_no = trim($_POST['beam_no'] ?? '');

if ($beam_no === '') {
        $err = 'Beam number is required.';
    } else {

/* ---------- Check if already exists in company_beam_stock ---------- */
        $check = $pdo->prepare("
            SELECT id
            FROM company_beam_stock
            WHERE company_id = ?
              AND beam_no = ?
            LIMIT 1
        ");
        $check->execute([$company_id, $beam_no]);

if ($check->fetch()) {
            $err = "Beam {$beam_no} already exists in Company Beam Stock.";
        } else {

/* ---------- Fetch latest beam from beam_entry ---------- */
            $stmt = $pdo->prepare("
                SELECT *
                FROM beam_entry
                WHERE company_id = ?
                  AND beam_no = ?
                ORDER BY id DESC
                LIMIT 1
            ");
            $stmt->execute([$company_id, $beam_no]);
            $beam = $stmt->fetch(PDO::FETCH_ASSOC);

if (!$beam) {
                $err = "Beam {$beam_no} not found in beam_entry.";
            } else {

/* ---------- Insert into company_beam_stock ---------- */
                $ins = $pdo->prepare("
                    INSERT INTO company_beam_stock
                    (
                        company_id,
                        warp_date,
                        beam_no,
                        quality_id,
                        beam_quality,
                        beam_slot,
                        taka,
                        meter,
                        tar,
                        warper_id,
                        beam_load_date,
                        load_type,
                        created_at
                    )
                    VALUES
                    (
                        :company_id,
                        :warp_date,
                        :beam_no,
                        :quality_id,
                        :beam_quality,
                        :beam_slot,
                        :taka,
                        :meter,
                        :tar,
                        :warper_id,
                        :beam_load_date,
                        :load_type,
                        NOW()
                    )
                ");

$ins->execute([
                    ':company_id'    => $company_id,
                    ':warp_date'     => $beam['entry_date'] ?? null,
                    ':beam_no'       => $beam['beam_no'],
                    ':quality_id'    => $beam['quality_id'] ?? null,
                    ':beam_quality'  => $beam['quality_id'] ?? null,
                    ':beam_slot'     => $beam['beam_type'] ?? 'primary',
                    ':taka'          => $beam['taka'] ?? 0,
                    ':meter'         => $beam['meter'] ?? 0,
                    ':tar'           => $beam['tar'] ?? 0,
                    ':warper_id'     => $beam['employee_id'] ?? null,
                    ':beam_load_date'=> $beam['entry_date'] ?? null,
                    ':load_type'     => 'stock'
                ]);

activity_create('beam', 'beam_entry_to_stock_create', (int)$pdo->lastInsertId(), 'Added beam to company stock');
                $msg = "Beam {$beam_no} successfully added to Company Beam Stock.";
            }
        }
    }
}

$page_title = 'Beam Entry to Company Beam Stock';
require_once __DIR__ . '/partials/header.php';
?>

<h4 class="mb-4">Beam Entry → Company Beam Stock</h4>

<?php if ($msg): ?>
        <div class="alert alert-success">
            <?= h($msg) ?>
        </div>
      <?php endif; ?>

<?php if ($err): ?>
        <div class="alert alert-danger">
            <?= h($err) ?>
        </div>
      <?php endif; ?>

<div class="col-md-4">
          <button type="submit"
                  class="btn btn-primary w-100">
            Add to Company Beam Stock
          </button>
        </div>

</form>

</div>
  </div>

</div>

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