« Back to History
policy_master_advanced.php
|
20260722_120325.php
Initial Domain Snapshot
Copy Code
<?php require_once __DIR__ . '/modules/auth/page_acl.php'; $ctx = page_require_access('policy_master'); $pdo = $ctx['pdo']; $company_id = (int)$ctx['company_id']; $u = $ctx['user'] ?? null; require_once __DIR__ . '/partials/header.php'; /* ================= EDIT MODE ================= */ $edit_id = isset($_GET['edit']) ? (int)$_GET['edit'] : 0; $is_edit = $edit_id > 0; $data = []; if ($is_edit) { $stmt = $pdo->prepare("SELECT * FROM policy_master WHERE id=? AND company_id=?"); $stmt->execute([$edit_id, $company_id]); $data = $stmt->fetch(PDO::FETCH_ASSOC); } /* ================= SUBMIT ================= */ $msg = ''; $error = ''; if ($_SERVER['REQUEST_METHOD'] === 'POST') { try { if ($is_edit) { $stmt = $pdo->prepare(" UPDATE policy_master SET policy_name=?, early_arrival_allow=?, late_arrival_allow=?, early_departure_allow=?, max_ot_allow=?, halfday_work_lt=?, absent_work_lt=?, ot_multiplier=?, punch_mode=? WHERE id=? AND company_id=? "); $stmt->execute([ $_POST['policy_name'], $_POST['early_arrival_allow'], $_POST['late_arrival_allow'], $_POST['early_departure_allow'], $_POST['max_ot_allow'], $_POST['halfday_work_lt'], $_POST['absent_work_lt'], $_POST['ot_multiplier'], $_POST['punch_mode'], $edit_id, $company_id ]); $msg = "Policy updated successfully"; } else { $stmt = $pdo->prepare(" INSERT INTO policy_master ( company_id, policy_name, early_arrival_allow, late_arrival_allow, early_departure_allow, max_ot_allow, halfday_work_lt, absent_work_lt, ot_multiplier, punch_mode ) VALUES (?,?,?,?,?,?,?,?,?,?) "); $stmt->execute([ $company_id, $_POST['policy_name'], $_POST['early_arrival_allow'], $_POST['late_arrival_allow'], $_POST['early_departure_allow'], $_POST['max_ot_allow'], $_POST['halfday_work_lt'], $_POST['absent_work_lt'], $_POST['ot_multiplier'], $_POST['punch_mode'] ]); $msg = "Policy added successfully"; } /* reload */ if ($is_edit) { $stmt = $pdo->prepare("SELECT * FROM policy_master WHERE id=? AND company_id=?"); $stmt->execute([$edit_id, $company_id]); $data = $stmt->fetch(PDO::FETCH_ASSOC); } } catch (Exception $e) { $error = $e->getMessage(); } } /* helper */ function v($d, $k, $def='') { return htmlspecialchars($d[$k] ?? $def); } ?> <div class="card p-4"> <h4><?= $is_edit ? 'Edit Policy' : 'Add Policy' ?></h4> <?php if ($msg): ?> <div class="alert alert-success"><?= $msg ?></div> <?php endif; ?> <?php if ($error): ?> <div class="alert alert-danger"><?= $error ?></div> <?php endif; ?> <form method="POST"> <div class="row mb-3"> <div class="col-md-6"> <label>Policy Name</label> <input type="text" name="policy_name" class="form-control" value="<?= v($data,'policy_name') ?>" required> </div> </div> <div class="row"> <!-- BOX 1 --> <div class="col-md-4"> <div class="card p-3 border-primary"> <h6>OT / Arrival</h6> <div class="d-flex justify-content-between mb-2"> <span>Early Arrival</span> <input type="time" name="early_arrival_allow" value="<?= v($data,'early_arrival_allow') ?>"> </div> <div class="d-flex justify-content-between mb-2"> <span>Max OT</span> <input type="time" name="max_ot_allow" value="<?= v($data,'max_ot_allow') ?>"> </div> </div> </div> <!-- BOX 2 --> <div class="col-md-4"> <div class="card p-3 border-success"> <h6>Late Rules</h6> <div class="d-flex justify-content-between mb-2"> <span>Late Allow</span> <input type="time" name="late_arrival_allow" value="<?= v($data,'late_arrival_allow') ?>"> </div> <div class="d-flex justify-content-between mb-2"> <span>Early Leave</span> <input type="time" name="early_departure_allow" value="<?= v($data,'early_departure_allow') ?>"> </div> </div> </div> <!-- BOX 3 --> <div class="col-md-4"> <div class="card p-3 border-danger"> <h6>Deduction</h6> <div class="d-flex justify-content-between mb-2"> <span>Halfday <</span> <input type="time" name="halfday_work_lt" value="<?= v($data,'halfday_work_lt') ?>"> </div> <div class="d-flex justify-content-between mb-2"> <span>Absent <</span> <input type="time" name="absent_work_lt" value="<?= v($data,'absent_work_lt') ?>"> </div> <div class="d-flex justify-content-between mb-2"> <span>OT Multiplier</span> <input type="number" step="0.1" name="ot_multiplier" value="<?= v($data,'ot_multiplier','0') ?>"> </div> <div class="d-flex justify-content-between"> <span>Punch Mode</span> <select name="punch_mode"> <option value="ALL" <?= v($data,'punch_mode')=='ALL'?'selected':'' ?>>ALL</option> <option value="FIRST_LAST" <?= v($data,'punch_mode')=='FIRST_LAST'?'selected':'' ?>>FIRST LAST</option> </select> </div> </div> </div> </div> <div class="text-end mt-3"> <button class="btn btn-primary"> <?= $is_edit ? 'Update Policy' : 'Save Policy' ?> </button> </div> </form> </div> <?php require_once __DIR__ . '/partials/footer.php'; ?>