« Back to History
pissing_rate_manage.php
|
20261118_125741.php
Initial Domain Snapshot
Copy Code
<?php error_reporting(E_ALL); ini_set('display_errors', 1); $page_title = 'Pissing Rate Master'; /* ================= AUTH ================= */ require_once __DIR__ . '/modules/auth/page_acl.php'; require_once __DIR__ . '/modules/activity/activity_logger.php'; $ctx = page_require_access('pissing_rate_manage'); $pdo = $ctx['pdo']; $company_id = (int)$ctx['company_id']; $user_id = (int)($ctx['user']['id'] ?? 0); function h($s){ return htmlspecialchars((string)$s, ENT_QUOTES, 'UTF-8'); } function prm_flash(string $msg, string $type = 'success'): void { $_SESSION['prm_flash'][] = ['m' => $msg, 't' => $type]; } function prm_take_flash(): array { $f = $_SESSION['prm_flash'] ?? []; unset($_SESSION['prm_flash']); return is_array($f) ? $f : []; } function prm_rate_html($rate): string { $rate = (float)$rate; $cls = $rate < 0 ? 'text-danger' : ''; $out = '<span class="' . $cls . ' fw-semibold">' . number_format($rate, 2) . '</span>'; if ($rate < 0) { $out .= ' <span class="badge text-bg-danger">Negative</span>'; } return $out; } /* ================= CSRF ================= */ if (empty($_SESSION['csrf_token'])) { $_SESSION['csrf_token'] = bin2hex(random_bytes(32)); } $CSRF = $_SESSION['csrf_token']; /* ================= TABS ================= */ $tab = (($_GET['tab'] ?? '') === 'quality') ? 'quality' : 'rate'; /* ================= ensure pissing_quality.updated_at ================= */ try { $colQ = $pdo->prepare("SELECT COUNT(*) FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'pissing_quality' AND COLUMN_NAME = 'updated_at'"); $colQ->execute(); if ((int)$colQ->fetchColumn() === 0) { $pdo->exec("ALTER TABLE `pissing_quality` ADD COLUMN `updated_at` TIMESTAMP NULL DEFAULT NULL"); } } catch (Throwable $e) { /* best effort */ } /* ================= EDIT MODE ================= */ $edit_id = (int)($_GET['edit'] ?? 0); $edit_rate = null; $edit_quality = null; if ($edit_id > 0) { $st = $pdo->prepare(" SELECT * FROM pissing_rate WHERE company_id = ? AND id = ? LIMIT 1 "); $st->execute([$company_id, $edit_id]); $edit = $st->fetch(PDO::FETCH_ASSOC); if ($edit) { $edit_rate = $edit['rate']; $edit_quality = $edit['quality_id']; } else { prm_flash('Rate record not found', 'danger'); $tab = 'rate'; } } $edit_q = (int)($_GET['edit_q'] ?? 0); $qEdit = null; if ($edit_q > 0) { $st = $pdo->prepare(" SELECT * FROM pissing_quality WHERE company_id = ? AND id = ? LIMIT 1 "); $st->execute([$company_id, $edit_q]); $qEdit = $st->fetch(PDO::FETCH_ASSOC); if (!$qEdit) { prm_flash('Pissing quality record not found', 'danger'); $edit_q = 0; } else { $tab = 'quality'; } } /* ================= SAVE / UPDATE ================= */ if ($_SERVER['REQUEST_METHOD'] === 'POST') { if (!hash_equals($_SESSION['csrf_token'], $_POST['csrf_token'] ?? '')) { die('Invalid CSRF token'); } $action = (string)($_POST['action'] ?? 'save_rate'); /* ---------- TAB 1 : pissing_rate ---------- */ if ($action === 'save_rate') { $quality_id = (int)($_POST['quality_id'] ?? 0); $rate_raw = trim((string)($_POST['rate'] ?? '')); if ($quality_id <= 0) { prm_flash('Please select a quality', 'danger'); } elseif ($rate_raw === '' || !is_numeric($rate_raw)) { prm_flash('Rate must be a number', 'danger'); } else { $rate = (float)$rate_raw; $sql = " INSERT INTO pissing_rate (company_id, quality_id, rate) VALUES (:cid, :qid, :rate) ON DUPLICATE KEY UPDATE rate = VALUES(rate) "; $stmt = $pdo->prepare($sql); $stmt->execute([ ':cid' => $company_id, ':qid' => $quality_id, ':rate' => $rate ]); $qName = ''; $nq = $pdo->prepare("SELECT name FROM beam_qualities WHERE company_id = ? AND id = ? LIMIT 1"); $nq->execute([$company_id, $quality_id]); $qName = (string)($nq->fetchColumn() ?: ''); activity_log([ 'company_id' => $company_id, 'user_id' => $user_id, 'module' => 'pissing', 'action_name' => $edit_id > 0 ? 'edit' : 'create', 'entity_type' => 'pissing_rate', 'entity_id' => $edit_id > 0 ? $edit_id : (int)$pdo->lastInsertId(), 'remarks' => ($edit_id > 0 ? 'Updated' : 'Saved') . ' pissing rate ' . number_format($rate, 2) . ($qName !== '' ? ' for ' . $qName : '') ]); prm_flash('Rate saved for ' . ($qName !== '' ? $qName : 'quality') . ' = ' . number_format($rate, 2)); $tab = 'rate'; } } if ($action === 'delete_rate') { $rid = (int)($_POST['id'] ?? 0); if ($rid > 0) { $del = $pdo->prepare("DELETE FROM pissing_rate WHERE company_id = ? AND id = ?"); $del->execute([$company_id, $rid]); activity_log([ 'company_id' => $company_id, 'user_id' => $user_id, 'module' => 'pissing', 'action_name' => 'delete', 'entity_type' => 'pissing_rate', 'entity_id' => $rid, 'remarks' => 'Deleted pissing rate' ]); prm_flash('Rate deleted'); } $tab = 'rate'; } /* ---------- TAB 2 : pissing_quality ---------- */ if ($action === 'save_quality') { $qid = (int)($_POST['id'] ?? 0); $machine = strtolower(trim((string)($_POST['machine'] ?? 'loom'))); $quality = trim((string)($_POST['quality'] ?? '')); $rateRaw = trim((string)($_POST['rate'] ?? '')); $active = ((string)($_POST['is_active'] ?? '1') === '1') ? 1 : 0; if (!in_array($machine, ['loom', 'rapier'], true)) $machine = 'loom'; if ($quality === '') { prm_flash('Quality name is required', 'danger'); } elseif ($rateRaw === '' || !is_numeric($rateRaw)) { prm_flash('Rate must be a number', 'danger'); } else { $rate = (float)$rateRaw; $dup = $pdo->prepare(" SELECT id FROM pissing_quality WHERE company_id = ? AND machine = ? AND quality = ? AND id <> ? LIMIT 1 "); $dup->execute([$company_id, $machine, $quality, $qid]); if ($dup->fetchColumn()) { prm_flash('This quality already exists for ' . ucfirst($machine) . ' machine', 'danger'); } else { if ($qid > 0) { $upd = $pdo->prepare(" UPDATE pissing_quality SET machine = :machine, quality = :quality, rate = :rate, is_active = :active, updated_at = NOW() WHERE id = :id AND company_id = :cid "); $upd->execute([ ':machine' => $machine, ':quality' => $quality, ':rate' => $rate, ':active' => $active, ':id' => $qid, ':cid' => $company_id ]); $savedId = $qid; $flashTxt = 'Pissing quality updated'; $logAct = 'edit'; } else { $ins = $pdo->prepare(" INSERT INTO pissing_quality (company_id, machine, quality, rate, is_active, created_at, updated_at) VALUES (:cid, :machine, :quality, :rate, :active, NOW(), NOW()) "); $ins->execute([ ':cid' => $company_id, ':machine' => $machine, ':quality' => $quality, ':rate' => $rate, ':active' => $active ]); $savedId = (int)$pdo->lastInsertId(); $flashTxt = 'Pissing quality added'; $logAct = 'create'; } activity_log([ 'company_id' => $company_id, 'user_id' => $user_id, 'module' => 'pissing', 'action_name' => $logAct, 'entity_type' => 'pissing_quality', 'entity_id' => $savedId, 'remarks' => $flashTxt . ': ' . $quality . ' (' . $machine . ') @ ' . number_format($rate, 2) ]); prm_flash($flashTxt); } } $tab = 'quality'; } if ($action === 'toggle_quality') { $qid = (int)($_POST['id'] ?? 0); $to = ((string)($_POST['to'] ?? '1') === '1') ? 1 : 0; if ($qid > 0) { $pdo->prepare("UPDATE pissing_quality SET is_active = :to, updated_at = NOW() WHERE id = :id AND company_id = :cid") ->execute([':to' => $to, ':id' => $qid, ':cid' => $company_id]); activity_log([ 'company_id' => $company_id, 'user_id' => $user_id, 'module' => 'pissing', 'action_name' => 'edit', 'entity_type' => 'pissing_quality', 'entity_id' => $qid, 'remarks' => $to ? 'Activated pissing quality' : 'Deactivated pissing quality' ]); prm_flash($to ? 'Quality activated' : 'Quality deactivated'); } $tab = 'quality'; } if ($action === 'delete_quality') { $qid = (int)($_POST['id'] ?? 0); if ($qid > 0) { $pdo->prepare("DELETE FROM pissing_quality WHERE id = :id AND company_id = :cid") ->execute([':id' => $qid, ':cid' => $company_id]); activity_log([ 'company_id' => $company_id, 'user_id' => $user_id, 'module' => 'pissing', 'action_name' => 'delete', 'entity_type' => 'pissing_quality', 'entity_id' => $qid, 'remarks' => 'Deleted pissing quality' ]); prm_flash('Pissing quality deleted'); } $tab = 'quality'; } /* PRG */ header('Location: pissing_rate_manage.php?tab=' . $tab); exit; } /* ================= DATA ================= */ $qualities = $pdo->prepare(" SELECT id, name FROM beam_qualities WHERE company_id = ? ORDER BY name "); $qualities->execute([$company_id]); $qualities = $qualities->fetchAll(PDO::FETCH_ASSOC); $rates = $pdo->prepare(" SELECT pr.id, pr.quality_id, pr.rate, bq.name AS quality_name FROM pissing_rate pr LEFT JOIN beam_qualities bq ON bq.id = pr.quality_id AND bq.company_id = pr.company_id WHERE pr.company_id = ? ORDER BY bq.name "); $rates->execute([$company_id]); $rates = $rates->fetchAll(PDO::FETCH_ASSOC); /* --- pissing_quality list + filters --- */ $fMachine = strtolower(trim((string)($_GET['machine'] ?? ''))); $fActive = (string)($_GET['active'] ?? ''); $fQ = trim((string)($_GET['q'] ?? '')); if (!in_array($fMachine, ['loom', 'rapier'], true)) $fMachine = ''; $where = ['company_id = :cid']; $bind = [':cid' => $company_id]; if ($fMachine !== '') { $where[] = 'machine = :m'; $bind[':m'] = $fMachine; } if ($fActive === '1' || $fActive === '0') { $where[] = 'is_active = :a'; $bind[':a'] = (int)$fActive; } if ($fQ !== '') { $where[] = 'quality LIKE :q'; $bind[':q'] = '%' . $fQ . '%'; } $WHERE = 'WHERE ' . implode(' AND ', $where); $cnt = $pdo->prepare("SELECT COUNT(*) FROM pissing_quality $WHERE"); $cnt->execute($bind); $pqTotal = (int)$cnt->fetchColumn(); $cntAll = $pdo->prepare("SELECT COUNT(*) FROM pissing_quality WHERE company_id = ?"); $cntAll->execute([$company_id]); $pqAll = (int)$cntAll->fetchColumn(); $stq = $pdo->prepare(" SELECT id, machine, quality, rate, is_active, created_at, updated_at FROM pissing_quality $WHERE ORDER BY machine, quality "); $stq->execute($bind); $pqRows = $stq->fetchAll(PDO::FETCH_ASSOC); /* counts for tab badges */ $rateCount = count($rates); $flashes = prm_take_flash(); require_once __DIR__ . '/partials/header.php'; ?> <div class="container py-4"> <?php foreach ($flashes as $f): ?> <div class="alert alert-<?= h($f['t']) ?> alert-dismissible fade show border-0 shadow-sm"> <?= h($f['m']) ?> <button type="button" class="btn-close" data-bs-dismiss="alert"></button> </div> <?php endforeach; ?> <ul class="nav nav-tabs mb-3"> <li class="nav-item"> <a class="nav-link <?= $tab === 'rate' ? 'active' : '' ?>" href="pissing_rate_manage.php?tab=rate"> Beam Quality Rates <span class="badge bg-primary"><?= (int)$rateCount ?></span> </a> </li> <li class="nav-item"> <a class="nav-link <?= $tab === 'quality' ? 'active' : '' ?>" href="pissing_rate_manage.php?tab=quality"> Pissing Quality Master <span class="badge bg-secondary"><?= (int)$pqAll ?></span> </a> </li> </ul> <?php if ($tab === 'rate'): ?> <!-- ADD / EDIT FORM : pissing_rate --> <div class="card shadow-sm mb-4"> <div class="card-header bg-primary text-white"> <h5 class="mb-0"> <?= $edit_id ? 'Edit Pissing Rate' : 'Add New Pissing Rate' ?> </h5> </div> <div class="card-body"> <form method="post" class="row g-3"> <input type="hidden" name="csrf_token" value="<?= h($CSRF) ?>"> <input type="hidden" name="action" value="save_rate"> <div class="col-md-6"> <label class="form-label">Quality <span class="text-danger">*</span></label> <select name="quality_id" class="form-select" required> <option value="">-- Select Quality --</option> <?php foreach ($qualities as $q): ?> <option value="<?= (int)$q['id'] ?>" <?= ((int)$edit_quality === (int)$q['id']) ? 'selected' : '' ?>> <?= h($q['name']) ?> </option> <?php endforeach; ?> </select> <div class="form-text">Quality list from <code>beam_qualities</code></div> </div> <div class="col-md-6"> <label class="form-label">Pissing Rate <span class="text-danger">*</span></label> <input type="number" step="0.01" name="rate" value="<?= h($edit_rate ?? '') ?>" class="form-control" required> </div> <div class="col-12"> <button type="submit" class="btn btn-primary"> <?= $edit_id ? 'Update Rate' : 'Save Rate' ?> </button> <?php if ($edit_id): ?> <a href="pissing_rate_manage.php?tab=rate" class="btn btn-secondary">Cancel</a> <?php endif; ?> </div> </form> </div> </div> <!-- EXISTING TABLE : pissing_rate --> <div class="card shadow-sm"> <div class="card-header bg-light"> <h5 class="mb-0">Existing Pissing Rates (<?= (int)$rateCount ?>)</h5> </div> <div class="card-body p-0"> <div class="table-responsive"> <table class="table table-bordered table-hover align-middle mb-0"> <thead class="table-light"> <tr> <th style="width:70px">ID</th> <th>Quality</th> <th class="text-end" style="width:180px">Rate</th> <th style="width:190px">Action</th> </tr> </thead> <tbody> <?php if (!$rates): ?> <tr> <td colspan="4" class="text-center text-muted">No data found</td> </tr> <?php else: ?> <?php foreach ($rates as $r): ?> <tr> <td><?= (int)$r['id'] ?></td> <td> <?= h($r['quality_name'] ?? '') ?> <?php if ($r['quality_name'] === null || $r['quality_name'] === ''): ?> <span class="badge text-bg-secondary">Quality removed</span> <?php endif; ?> </td> <td class="text-end"><?= prm_rate_html($r['rate']) ?></td> <td> <div class="d-flex gap-2"> <a href="?tab=rate&edit=<?= (int)$r['id'] ?>" class="btn btn-sm btn-outline-primary">Edit</a> <form method="post" onsubmit="return confirm('Delete this rate?');"> <input type="hidden" name="csrf_token" value="<?= h($CSRF) ?>"> <input type="hidden" name="action" value="delete_rate"> <input type="hidden" name="id" value="<?= (int)$r['id'] ?>"> <button class="btn btn-sm btn-outline-danger">Delete</button> </form> </div> </td> </tr> <?php endforeach; ?> <?php endif; ?> </tbody> </table> </div> </div> </div> <?php else: ?> <!-- ADD / EDIT FORM : pissing_quality --> <div class="card shadow-sm mb-4"> <div class="card-header bg-secondary text-white"> <h5 class="mb-0"> <?= $edit_q ? 'Edit Pissing Quality' : 'Add New Pissing Quality' ?> </h5> </div> <div class="card-body"> <form method="post" class="row g-3"> <input type="hidden" name="csrf_token" value="<?= h($CSRF) ?>"> <input type="hidden" name="action" value="save_quality"> <input type="hidden" name="id" value="<?= (int)($qEdit['id'] ?? 0) ?>"> <div class="col-md-3"> <label class="form-label">Machine <span class="text-danger">*</span></label> <select name="machine" class="form-select" required> <?php $selM = strtolower((string)($qEdit['machine'] ?? 'loom')); if ($selM !== 'loom' && $selM !== 'rapier') $selM = 'loom'; ?> <option value="loom" <?= $selM === 'loom' ? 'selected' : '' ?>>Loom</option> <option value="rapier" <?= $selM === 'rapier' ? 'selected' : '' ?>>Rapier</option> </select> </div> <div class="col-md-4"> <label class="form-label">Quality <span class="text-danger">*</span></label> <input type="text" name="quality" maxlength="100" required value="<?= h($qEdit['quality'] ?? '') ?>" class="form-control"> </div> <div class="col-md-2"> <label class="form-label">Rate <span class="text-danger">*</span></label> <input type="number" step="0.01" name="rate" required value="<?= h($qEdit['rate'] ?? '') ?>" class="form-control"> </div> <div class="col-md-3"> <label class="form-label">Status</label> <select name="is_active" class="form-select"> <?php $selA = (int)($qEdit['is_active'] ?? 1) === 1; ?> <option value="1" <?= $selA ? 'selected' : '' ?>>Active</option> <option value="0" <?= !$selA ? 'selected' : '' ?>>Inactive</option> </select> </div> <div class="col-12"> <button type="submit" class="btn btn-secondary"> <?= $edit_q ? 'Update Quality' : 'Save Quality' ?> </button> <?php if ($edit_q): ?> <a href="pissing_rate_manage.php?tab=quality" class="btn btn-outline-secondary">Cancel</a> <?php endif; ?> </div> </form> </div> </div> <!-- FILTERS --> <form method="get" class="row g-2 mb-3"> <input type="hidden" name="tab" value="quality"> <div class="col-md-3"> <select name="machine" class="form-select"> <option value="">All Machines</option> <option value="loom" <?= $fMachine === 'loom' ? 'selected' : '' ?>>Loom</option> <option value="rapier" <?= $fMachine === 'rapier' ? 'selected' : '' ?>>Rapier</option> </select> </div> <div class="col-md-3"> <select name="active" class="form-select"> <option value="">All Status</option> <option value="1" <?= $fActive === '1' ? 'selected' : '' ?>>Active</option> <option value="0" <?= $fActive === '0' ? 'selected' : '' ?>>Inactive</option> </select> </div> <div class="col-md-4"> <input type="text" name="q" class="form-control" value="<?= h($fQ) ?>" placeholder="Search quality"> </div> <div class="col-md-2"> <button class="btn btn-primary w-100">Filter</button> </div> </form> <!-- EXISTING TABLE : pissing_quality --> <div class="card shadow-sm"> <div class="card-header bg-light"> <h5 class="mb-0">Pissing Quality Master (<?= (int)$pqTotal ?><?= $pqTotal !== $pqAll ? ' of ' . (int)$pqAll : '' ?>)</h5> </div> <div class="card-body p-0"> <div class="table-responsive"> <table class="table table-bordered table-hover align-middle mb-0"> <thead class="table-light"> <tr> <th style="width:70px">ID</th> <th style="width:100px">Machine</th> <th>Quality</th> <th class="text-end" style="width:180px">Rate</th> <th style="width:100px">Status</th> <th style="width:250px">Action</th> </tr> </thead> <tbody> <?php if (!$pqRows): ?> <tr> <td colspan="6" class="text-center text-muted">No data found</td> </tr> <?php else: ?> <?php foreach ($pqRows as $r): ?> <tr> <td><?= (int)$r['id'] ?></td> <td><?= h(ucfirst((string)$r['machine'])) ?></td> <td><?= h($r['quality']) ?></td> <td class="text-end"><?= prm_rate_html($r['rate']) ?></td> <td> <?php if ((int)$r['is_active'] === 1): ?> <span class="badge text-bg-success">Active</span> <?php else: ?> <span class="badge text-bg-secondary">Inactive</span> <?php endif; ?> </td> <td> <div class="d-flex gap-2"> <a href="?tab=quality&edit_q=<?= (int)$r['id'] ?>" class="btn btn-sm btn-outline-primary">Edit</a> <form method="post"> <input type="hidden" name="csrf_token" value="<?= h($CSRF) ?>"> <input type="hidden" name="action" value="toggle_quality"> <input type="hidden" name="id" value="<?= (int)$r['id'] ?>"> <input type="hidden" name="to" value="<?= (int)$r['is_active'] === 1 ? 0 : 1 ?>"> <button class="btn btn-sm <?= (int)$r['is_active'] === 1 ? 'btn-outline-warning' : 'btn-outline-success' ?>"> <?= (int)$r['is_active'] === 1 ? 'Deactivate' : 'Activate' ?> </button> </form> <form method="post" onsubmit="return confirm('Delete this quality? Salary reports using it will not find a rate.');"> <input type="hidden" name="csrf_token" value="<?= h($CSRF) ?>"> <input type="hidden" name="action" value="delete_quality"> <input type="hidden" name="id" value="<?= (int)$r['id'] ?>"> <button class="btn btn-sm btn-outline-danger">Delete</button> </form> </div> </td> </tr> <?php endforeach; ?> <?php endif; ?> </tbody> </table> </div> </div> </div> <?php endif; ?> </div> <?php require_once __DIR__ . '/partials/footer.php'; ?>