<?php
ob_start();
session_start();
include_once('db.php');

try {
    $pdo = new PDO("mysql:host=$host;dbname=$dbname;charset=utf8", $user, $pass);
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (PDOException $e) {
    die("Błąd połączenia z bazą: " . $e->getMessage());
}

define('ADMIN_SUBUNIT', 'Biuro - Stary Sącz');

if (isset($_GET['logout'])) {
    unset($_SESSION['grafik_emp_number'], $_SESSION['grafik_subunit_id'],
          $_SESSION['grafik_is_admin'],   $_SESSION['grafik_emp_name']);
    header('Location: ' . strtok($_SERVER['REQUEST_URI'], '?'));
    exit;
}

if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['action']) && $_POST['action'] === 'login_pin') {
    header('Content-Type: application/json; charset=utf-8');
    $pin = trim($_POST['pin'] ?? '');
    if ($pin === '') { echo json_encode(['ok' => false, 'msg' => 'Wprowadź PIN.']); exit; }
    $stmt = $pdo->prepare("
        SELECT e.emp_number, e.emp_firstname, e.emp_lastname,
               e.work_station, s.name AS subunit_name
        FROM hs_hr_employee e
        LEFT JOIN ohrm_subunit s ON s.id = e.work_station
        WHERE e.employee_id = ? AND e.termination_id IS NULL LIMIT 1");
    $stmt->execute([$pin]);
    $emp = $stmt->fetch(PDO::FETCH_ASSOC);
    if (!$emp) { echo json_encode(['ok' => false, 'msg' => 'Nieprawidłowy PIN.']); exit; }
    $_SESSION['grafik_emp_number']  = $emp['emp_number'];
    $_SESSION['grafik_subunit_id']  = $emp['work_station'];
    $_SESSION['grafik_subunit_name']= $emp['subunit_name'];
    $_SESSION['grafik_is_admin']    = ($emp['subunit_name'] === ADMIN_SUBUNIT);
    $_SESSION['grafik_emp_name']    = $emp['emp_lastname'] . ' ' . $emp['emp_firstname'];
    echo json_encode(['ok' => true, 'is_admin' => $_SESSION['grafik_is_admin']]); exit;
}

$auth_logged_in    = isset($_SESSION['grafik_emp_number']);
$auth_is_admin     = $auth_logged_in && !empty($_SESSION['grafik_is_admin']);
$auth_subunit_id   = $_SESSION['grafik_subunit_id']   ?? null;
$auth_subunit_name = $_SESSION['grafik_subunit_name'] ?? '';
$auth_emp_name     = $_SESSION['grafik_emp_name']     ?? '';

$requested_subunit = (int)($_GET['subunit_id'] ?? 0);
$access_denied = false;
if ($auth_logged_in && $requested_subunit > 0 && !$auth_is_admin)
    if ($requested_subunit != $auth_subunit_id) $access_denied = true;

if (isset($_GET['action']) && $_GET['action'] === 'autocomplete_emp') {
    header('Content-Type: application/json; charset=utf-8');
    $term = '%' . ($_GET['term'] ?? '') . '%';
    $stmt = $pdo->prepare("
        SELECT e.emp_number, e.emp_firstname, e.emp_lastname, s.name AS subunit_name
        FROM hs_hr_employee e
        LEFT JOIN ohrm_subunit s ON s.id = e.work_station
        WHERE e.termination_id IS NULL AND (e.emp_lastname LIKE ? OR e.emp_firstname LIKE ?)
        ORDER BY e.emp_lastname, e.emp_firstname LIMIT 20");
    $stmt->execute([$term, $term]);
    $wyniki = [];
    foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row)
        $wyniki[] = ['value'=>$row['emp_lastname'].' '.$row['emp_firstname'],
                     'label'=>$row['emp_lastname'].' '.$row['emp_firstname'].($row['subunit_name']?' ('.$row['subunit_name'].')':''),
                     'id'=>$row['emp_number'], 'subunit_name'=>$row['subunit_name']??''];
    echo json_encode($wyniki); exit;
}

if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['action'])) {
    header('Content-Type: application/json; charset=utf-8');
    $action = $_POST['action'];

    if ($action === 'save_shift') {
        $id         = (int)($_POST['id']         ?? 0);
        $emp_number = (int)($_POST['emp_number'] ?? 0);
        $subunit_id = (int)($_POST['subunit_id'] ?? 0);
        $shift_date = $_POST['shift_date'] ?? '';
        $time_from  = $_POST['time_from']  ?? '';
        $time_to    = $_POST['time_to']    ?? '';
        $role_name  = isset($_POST['role_name']) && $_POST['role_name'] !== '' ? $_POST['role_name'] : null;
        $is_sub     = (int)($_POST['is_substitute'] ?? 0);
        $note       = isset($_POST['note']) && $_POST['note'] !== '' ? $_POST['note'] : null;
        if (!$emp_number || !$subunit_id || !$shift_date || !$time_from || !$time_to) {
            echo json_encode(['ok'=>false,'msg'=>'Brakuje wymaganych pól']); exit;
        }
        try {
            if ($id > 0) {
                $stmt = $pdo->prepare("UPDATE ls_schedule_shift SET emp_number=?,subunit_id=?,shift_date=?,time_from=?,time_to=?,role_name=?,is_substitute=?,note=? WHERE id=?");
                $stmt->execute([$emp_number,$subunit_id,$shift_date,$time_from,$time_to,$role_name,$is_sub,$note,$id]);
            } else {
                $stmt = $pdo->prepare("INSERT INTO ls_schedule_shift (emp_number,subunit_id,shift_date,time_from,time_to,role_name,is_substitute,note) VALUES (?,?,?,?,?,?,?,?)");
                $stmt->execute([$emp_number,$subunit_id,$shift_date,$time_from,$time_to,$role_name,$is_sub,$note]);
                $id = (int)$pdo->lastInsertId();
            }
            echo json_encode(['ok'=>true,'id'=>$id]);
        } catch (PDOException $e) { echo json_encode(['ok'=>false,'msg'=>$e->getMessage()]); }
        exit;
    }

    if ($action === 'delete_shift') {
        $id = (int)($_POST['id'] ?? 0);
        try { $pdo->prepare("DELETE FROM ls_schedule_shift WHERE id=?")->execute([$id]); echo json_encode(['ok'=>true]); }
        catch (PDOException $e) { echo json_encode(['ok'=>false,'msg'=>$e->getMessage()]); }
        exit;
    }

    if ($action === 'copy_week') {
        $subunit_id = (int)($_POST['subunit_id'] ?? 0);
        $from_week  = $_POST['from_week'] ?? '';
        $to_week    = $_POST['to_week']   ?? '';
        $overwrite  = (int)($_POST['overwrite'] ?? 0);
        try {
            $from_end  = date('Y-m-d', strtotime($from_week . ' +6 days'));
            $to_end    = date('Y-m-d', strtotime($to_week   . ' +6 days'));
            $diff_days = (strtotime($to_week) - strtotime($from_week)) / 86400;
            if ($overwrite) $pdo->prepare("DELETE FROM ls_schedule_shift WHERE subunit_id=? AND shift_date BETWEEN ? AND ?")->execute([$subunit_id,$to_week,$to_end]);
            $stmt = $pdo->prepare("SELECT * FROM ls_schedule_shift WHERE subunit_id=? AND shift_date BETWEEN ? AND ?");
            $stmt->execute([$subunit_id,$from_week,$from_end]);
            $source = $stmt->fetchAll(PDO::FETCH_ASSOC);
            $ins = $pdo->prepare("INSERT IGNORE INTO ls_schedule_shift (emp_number,subunit_id,shift_date,time_from,time_to,role_name,is_substitute,note) VALUES (?,?,?,?,?,?,?,?)");
            $count = 0;
            foreach ($source as $row) {
                $new_date = date('Y-m-d', strtotime($row['shift_date'] . " +{$diff_days} days"));
                $ins->execute([$row['emp_number'],$row['subunit_id'],$new_date,$row['time_from'],$row['time_to'],$row['role_name'],$row['is_substitute'],$row['note']]);
                $count++;
            }
            echo json_encode(['ok'=>true,'copied'=>$count]);
        } catch (PDOException $e) { echo json_encode(['ok'=>false,'msg'=>$e->getMessage()]); }
        exit;
    }
    echo json_encode(['ok'=>false,'msg'=>'Nieznana akcja']); exit;
}

$stmt = $pdo->query("SELECT id, name FROM ohrm_subunit ORDER BY lft, name");
$podjednostki = $stmt->fetchAll(PDO::FETCH_ASSOC);

$subunit_id = (int)($_GET['subunit_id'] ?? 0);
$week_start = $_GET['week_start'] ?? '';
if (!$week_start) { $dow = (int)date('N'); $week_start = date('Y-m-d', strtotime('-' . ($dow - 1) . ' days')); }
$week_end  = date('Y-m-d', strtotime($week_start . ' +6 days'));
$prev_week = date('Y-m-d', strtotime($week_start . ' -7 days'));
$next_week = date('Y-m-d', strtotime($week_start . ' +7 days'));

$view = $_GET['view'] ?? 'week';
$month_param = $_GET['month_start'] ?? date('Y-m-01');
$month_start = date('Y-m-01', strtotime($month_param));
$month_end   = date('Y-m-t', strtotime($month_start));
$prev_month  = date('Y-m-01', strtotime($month_start . ' -1 month'));
$next_month  = date('Y-m-01', strtotime($month_start . ' +1 month'));
$month_days  = [];
$d = new DateTime($month_start); $last = new DateTime($month_end);
while ($d <= $last) { $month_days[] = $d->format('Y-m-d'); $d->modify('+1 day'); }
$month_label = ['','Styczen','Luty','Marzec','Kwiecien','Maj','Czerwiec',
                'Lipiec','Sierpien','Wrzesien','Pazdziernik','Listopad','Grudzien'][(int)date('n',strtotime($month_start))]
               . ' ' . date('Y', strtotime($month_start));
$month_label_pl = ['','Styczeń','Luty','Marzec','Kwiecień','Maj','Czerwiec',
                'Lipiec','Sierpień','Wrzesień','Październik','Listopad','Grudzień'][(int)date('n',strtotime($month_start))]
               . ' ' . date('Y', strtotime($month_start));

$pracownicy = []; $shifts = []; $urlopy = []; $roles = [];
$month_shifts = []; $month_leaves = []; $ms_idx = []; $ml_idx = [];
$shifts_ext = []; $shifts_ext_idx = [];          // zmiany pracowników w innych jednostkach
$month_shifts_ext = []; $ms_ext_idx = [];        // j.w. dla widoku miesięcznego

if ($subunit_id > 0) {
    $stmt = $pdo->prepare("
        SELECT e.emp_number, e.emp_firstname, e.emp_lastname,
               COALESCE(NULLIF(e.emp_other_id,''), '8') AS daily_norm
        FROM hs_hr_employee e
        WHERE e.work_station = ? AND e.termination_id IS NULL
        ORDER BY e.emp_lastname, e.emp_firstname");
    $stmt->execute([$subunit_id]);
    $pracownicy = $stmt->fetchAll(PDO::FETCH_ASSOC);

    $stmt = $pdo->prepare("
        SELECT s.id, s.emp_number, s.subunit_id, s.shift_date,
               TIME_FORMAT(s.time_from,'%H:%i') AS time_from,
               TIME_FORMAT(s.time_to,  '%H:%i') AS time_to,
               s.role_name, s.is_substitute, s.note,
               e.emp_firstname, e.emp_lastname,
               COALESCE(NULLIF(e.emp_other_id,''), '8') AS daily_norm,
               r.color
        FROM ls_schedule_shift s
        JOIN hs_hr_employee e ON e.emp_number = s.emp_number
        LEFT JOIN ls_schedule_role r ON r.role_name = s.role_name
               AND (r.subunit_id = s.subunit_id OR r.subunit_id IS NULL)
        WHERE s.subunit_id = ? AND s.shift_date BETWEEN ? AND ?
        ORDER BY e.emp_lastname, e.emp_firstname, s.shift_date, s.time_from");
    $stmt->execute([$subunit_id, $week_start, $week_end]);
    $shifts = $stmt->fetchAll(PDO::FETCH_ASSOC);
    foreach ($shifts as &$s) {
        $f = strtotime($s['shift_date'].' '.$s['time_from']);
        $t = strtotime($s['shift_date'].' '.$s['time_to']);
        if ($t < $f) $t += 86400;
        $s['minutes'] = (int)(($t - $f) / 60);
    } unset($s);

    $stmt = $pdo->prepare("
        SELECT l.emp_number, DATE_FORMAT(l.date,'%Y-%m-%d') AS ldate,
               l.status, lt.name AS leave_type
        FROM ohrm_leave l
        JOIN hs_hr_employee e ON e.emp_number = l.emp_number
        JOIN ohrm_leave_type lt ON lt.id = l.leave_type_id
        WHERE e.work_station = ? AND l.date BETWEEN ? AND ? AND l.status IN (2,3)
        ORDER BY l.date");
    $stmt->execute([$subunit_id, $week_start, $week_end]);
    $urlopy = $stmt->fetchAll(PDO::FETCH_ASSOC);

    $stmt = $pdo->prepare("SELECT role_name, color FROM ls_schedule_role WHERE subunit_id IS NULL OR subunit_id=? ORDER BY sort_order, role_name");
    $stmt->execute([$subunit_id]);
    $roles = $stmt->fetchAll(PDO::FETCH_ASSOC);

    // ── Zmiany pracowników tej jednostki w INNYCH podjednostkach (widok tygodniowy) ──
    $emp_ids = array_column($pracownicy, 'emp_number');
    if ($emp_ids) {
        $ph = implode(',', array_fill(0, count($emp_ids), '?'));
        $params = array_merge($emp_ids, [$subunit_id, $week_start, $week_end]);
        $stmt = $pdo->prepare("
            SELECT s.id, s.emp_number, s.shift_date,
                   TIME_FORMAT(s.time_from,'%H:%i') AS time_from,
                   TIME_FORMAT(s.time_to,  '%H:%i') AS time_to,
                   s.role_name,
                   su.name AS ext_subunit_name
            FROM ls_schedule_shift s
            LEFT JOIN ohrm_subunit su ON su.id = s.subunit_id
            WHERE s.emp_number IN ($ph)
              AND s.subunit_id != ?
              AND s.shift_date BETWEEN ? AND ?
            ORDER BY s.shift_date, s.time_from");
        $stmt->execute($params);
        $shifts_ext = $stmt->fetchAll(PDO::FETCH_ASSOC);
    }

    if ($view === 'month') {
        $stmt = $pdo->prepare("
            SELECT s.id, s.emp_number, s.shift_date,
                   TIME_FORMAT(s.time_from,'%H:%i') AS time_from,
                   TIME_FORMAT(s.time_to,  '%H:%i') AS time_to,
                   s.role_name, s.is_substitute,
                   r.color,
                   ROUND(TIMESTAMPDIFF(MINUTE,
                       CONCAT(s.shift_date,' ',s.time_from),
                       CONCAT(s.shift_date,' ',s.time_to))/60,2) AS godziny,
                   e.emp_firstname, e.emp_lastname,
                   COALESCE(NULLIF(e.emp_other_id,''),'8') AS daily_norm
            FROM ls_schedule_shift s
            JOIN hs_hr_employee e ON e.emp_number = s.emp_number
            LEFT JOIN ls_schedule_role r ON r.role_name=s.role_name AND (r.subunit_id=s.subunit_id OR r.subunit_id IS NULL)
            WHERE s.subunit_id=? AND s.shift_date BETWEEN ? AND ?
            ORDER BY s.shift_date, s.time_from");
        $stmt->execute([$subunit_id, $month_start, $month_end]);
        $month_shifts = $stmt->fetchAll(PDO::FETCH_ASSOC);

        $stmt = $pdo->prepare("
            SELECT l.emp_number, DATE_FORMAT(l.date,'%Y-%m-%d') AS ldate, lt.name AS leave_type
            FROM ohrm_leave l
            JOIN hs_hr_employee e ON e.emp_number=l.emp_number
            JOIN ohrm_leave_type lt ON lt.id=l.leave_type_id
            WHERE e.work_station=? AND l.date BETWEEN ? AND ? AND l.status IN (2,3)");
        $stmt->execute([$subunit_id, $month_start, $month_end]);
        $month_leaves = $stmt->fetchAll(PDO::FETCH_ASSOC);

        $ms_idx = []; foreach ($month_shifts as $s) $ms_idx[$s['emp_number']][$s['shift_date']][] = $s;
        $ml_idx = []; foreach ($month_leaves as $l) $ml_idx[$l['emp_number']][$l['ldate']][] = $l;

        // ── Zmiany pracowników tej jednostki w INNYCH podjednostkach (widok miesięczny) ──
        if ($emp_ids) {
            $ph_m = implode(',', array_fill(0, count($emp_ids), '?'));
            $params_m = array_merge($emp_ids, [$subunit_id, $month_start, $month_end]);
            $stmt = $pdo->prepare("
                SELECT s.id, s.emp_number, s.shift_date,
                       TIME_FORMAT(s.time_from,'%H:%i') AS time_from,
                       TIME_FORMAT(s.time_to,  '%H:%i') AS time_to,
                       s.role_name,
                       su.name AS ext_subunit_name
                FROM ls_schedule_shift s
                LEFT JOIN ohrm_subunit su ON su.id = s.subunit_id
                WHERE s.emp_number IN ($ph_m)
                  AND s.subunit_id != ?
                  AND s.shift_date BETWEEN ? AND ?
                ORDER BY s.shift_date, s.time_from");
            $stmt->execute($params_m);
            $month_shifts_ext = $stmt->fetchAll(PDO::FETCH_ASSOC);
        }
    }
}

$wszyscy = $pdo->query("
    SELECT e.emp_number, e.emp_firstname, e.emp_lastname, s.name AS subunit_name
    FROM hs_hr_employee e
    LEFT JOIN ohrm_subunit s ON s.id = e.work_station
    WHERE e.termination_id IS NULL
    ORDER BY e.emp_lastname, e.emp_firstname
")->fetchAll(PDO::FETCH_ASSOC);

$dni_pl = ['Poniedziałek','Wtorek','Środa','Czwartek','Piątek','Sobota','Niedziela'];
$today  = date('Y-m-d');
$week_days = [];
for ($i = 0; $i < 7; $i++) $week_days[] = date('Y-m-d', strtotime($week_start." +$i days"));

$emp_map = [];
foreach ($pracownicy as $p) $emp_map[$p['emp_number']] = $p + ['is_sub_only'=>false];
foreach ($shifts as $s) {
    if (!isset($emp_map[$s['emp_number']]))
        $emp_map[$s['emp_number']] = ['emp_number'=>$s['emp_number'],'emp_firstname'=>$s['emp_firstname'],'emp_lastname'=>$s['emp_lastname'],'daily_norm'=>$s['daily_norm'],'is_sub_only'=>true];
}
foreach ($month_shifts as $s) {
    if (!isset($emp_map[$s['emp_number']]))
        $emp_map[$s['emp_number']] = ['emp_number'=>$s['emp_number'],'emp_firstname'=>$s['emp_firstname'],'emp_lastname'=>$s['emp_lastname'],'daily_norm'=>$s['daily_norm'],'is_sub_only'=>true];
}
$add_sub = (int)($_GET['add_sub'] ?? 0);
if ($add_sub > 0 && !isset($emp_map[$add_sub])) {
    $stmt = $pdo->prepare("SELECT emp_number, emp_firstname, emp_lastname, COALESCE(NULLIF(emp_other_id,''),'8') AS daily_norm FROM hs_hr_employee WHERE emp_number=?");
    $stmt->execute([$add_sub]);
    $sub_emp = $stmt->fetch(PDO::FETCH_ASSOC);
    if ($sub_emp) $emp_map[$sub_emp['emp_number']] = $sub_emp + ['is_sub_only'=>true];
}
uasort($emp_map, function($a,$b) {
    if ($a['is_sub_only'] !== $b['is_sub_only']) return $a['is_sub_only'] ? 1 : -1;
    return strcmp($a['emp_lastname'].$a['emp_firstname'], $b['emp_lastname'].$b['emp_firstname']);
});
$emp_map = array_combine(array_column($emp_map, 'emp_number'), array_values($emp_map));

$shifts_idx = []; foreach ($shifts as $s) $shifts_idx[$s['emp_number']][$s['shift_date']][] = $s;
$leaves_idx = []; foreach ($urlopy as $l) $leaves_idx[$l['emp_number']][$l['ldate']][] = $l;
$role_colors = []; foreach ($roles as $r) $role_colors[$r['role_name']] = $r['color'];
$shifts_ext_idx = []; foreach ($shifts_ext as $s) $shifts_ext_idx[$s['emp_number']][$s['shift_date']][] = $s;
$ms_ext_idx = []; foreach ($month_shifts_ext as $s) $ms_ext_idx[$s['emp_number']][$s['shift_date']][] = $s;

$protocol    = (!empty($_SERVER['HTTPS']) && $_SERVER['HTTPS'] !== 'off') ? 'https' : 'http';
$script_path = str_replace($_SERVER['DOCUMENT_ROOT'], '', __FILE__);
$self        = $protocol . '://' . $_SERVER['HTTP_HOST'] . $script_path;

function fmtWeekLabel($s,$e){
    $m=['','sty','lut','mar','kwi','maj','cze','lip','sie','wrz','paź','lis','gru'];
    return date('j',strtotime($s)).' '.$m[(int)date('n',strtotime($s))].' – '.date('j',strtotime($e)).' '.$m[(int)date('n',strtotime($e))].' '.date('Y',strtotime($e));
}
function h2rgba($hex,$a){
    if(!$hex||strlen($hex)<6) return "rgba(255,118,0,$a)";
    $hex=ltrim($hex,'#');
    return "rgba(".hexdec(substr($hex,0,2)).",".hexdec(substr($hex,2,2)).",".hexdec(substr($hex,4,2)).",$a)";
}
?>
<!DOCTYPE html>
<html lang="pl">
<head>
<meta charset="UTF-8">
<title>Grafik Pracy</title>
<link rel="stylesheet" href="../../jq/jquery-ui.css">
<script src="../../jq/jquery-3.7.1.js"></script>
<script src="../../jq/jquery-ui.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jspdf/2.5.1/jspdf.umd.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jspdf-autotable/3.8.2/jspdf.plugin.autotable.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.18.5/xlsx.full.min.js"></script>
<style>
*,*::before,*::after{box-sizing:border-box;margin:0;padding:0}
body{font-family:'Segoe UI',Arial,sans-serif;background:#f4f6fa;color:#333;font-size:13px}
#topbar{display:flex;align-items:center;flex-wrap:wrap;gap:10px;padding:10px 18px;background:#fff;border-bottom:2px solid #e0e4ef;box-shadow:0 2px 8px rgba(0,0,0,.07)}
#topbar h1{font-size:16px;font-weight:700;color:#ff7600;white-space:nowrap}
.tb-sep{width:1px;height:28px;background:#e0e4ef}
select,input[type=text],input[type=time]{background:#f9fafc;border:1px solid #d0d6e8;color:#333;border-radius:6px;padding:5px 9px;font-size:13px;height:32px;outline:none}
select:focus,input:focus{border-color:#ff7600}
.btn{display:inline-flex;align-items:center;gap:5px;padding:0 13px;height:32px;border-radius:6px;border:none;font-size:13px;font-weight:600;cursor:pointer;white-space:nowrap;transition:filter .15s;text-decoration:none}
.btn:hover{filter:brightness(1.1)}
.btn-orange{background:#ff7600;color:#fff}
.btn-ghost{background:#f0f2f8;color:#555;border:1px solid #d0d6e8}
.btn-danger{background:#e53e3e;color:#fff}
#week-nav{display:flex;align-items:center;gap:6px}
#week-label{font-weight:700;font-size:14px;min-width:170px;text-align:center}
#wrap{padding:16px 18px;overflow-x:auto}
#schedule-table{border-collapse:collapse;width:100%;background:#fff;border-radius:10px;overflow:hidden;box-shadow:0 2px 12px rgba(0,0,0,.08)}
#schedule-table thead th{background:#ff7600;color:#fff;padding:10px 8px;text-align:center;font-weight:600;font-size:12px;white-space:nowrap}
#schedule-table thead th.th-name{text-align:left;padding-left:14px;min-width:180px;width:180px}
#schedule-table thead th.th-day{min-width:140px;width:140px}
#schedule-table thead th.th-sum{min-width:70px;width:70px;background:#e56a00}
#schedule-table thead th.th-weekend{background:#c05a00}
#schedule-table thead th.th-today{background:#cc5f00;outline:3px solid #ffe0b2;outline-offset:-3px}
.emp-row td{border-bottom:1px solid #eef0f6;vertical-align:top;padding:3px}
.emp-row:last-child td{border-bottom:none}
.emp-row:nth-child(even) td{background:#fafbfe}
.emp-row:hover td{background:#fff8f0!important}
.td-name{padding:8px 6px 8px 14px!important;vertical-align:middle}
.emp-name{font-weight:700;font-size:13px}
.emp-meta{font-size:11px;color:#999;margin-top:2px}
.emp-hours{font-size:11px;color:#27ae60;font-weight:700;margin-top:2px}
.emp-sub-badge{font-size:10px;color:#ff7600;font-weight:700}
.td-day{vertical-align:top;min-height:60px}
.td-day.weekend{background:rgba(255,107,107,.05)}
.td-day.today{background:rgba(255,118,0,.07)}
.td-day.drag-over{background:rgba(255,118,0,.18)!important;border-radius:6px}
.shift-chip{border-radius:6px;padding:4px 6px;margin:2px;cursor:grab;position:relative;font-size:11.5px;line-height:1.4;border-left:3px solid #ff7600;background:#fff8f0;transition:box-shadow .15s;user-select:none}
.shift-chip:hover{box-shadow:0 2px 8px rgba(0,0,0,.15)}
.shift-chip.dragging{opacity:.5}
.sc-time{font-weight:700}
.sc-role{font-size:10.5px;opacity:.75}
.sc-sub{font-size:10px;color:#e07a00}
.sc-leave{font-size:10px;color:#e53e3e}
.sc-acts{display:none;position:absolute;top:3px;right:3px;gap:2px}
.shift-chip:hover .sc-acts{display:flex}
.sc-btn{width:18px;height:18px;border-radius:3px;border:none;cursor:pointer;font-size:9px;display:flex;align-items:center;justify-content:center;background:rgba(0,0,0,.15);color:#333}
.sc-btn.del{background:rgba(229,62,62,.25);color:#e53e3e}
.sc-btn:hover{background:rgba(0,0,0,.3)}
.add-btn{display:block;width:calc(100% - 4px);margin:2px;padding:2px;border:1px dashed #d0d6e8;border-radius:5px;background:transparent;color:#bbb;cursor:pointer;font-size:14px;text-align:center;transition:border-color .15s,color .15s}
.add-btn:hover{border-color:#ff7600;color:#ff7600}
#row-totals td{padding:8px 6px;font-weight:700;font-size:12px;background:#fff3e8;border-top:2px solid #ff7600;text-align:center;color:#555}
#row-totals .td-name{text-align:left;padding-left:14px}
.day-total{color:#27ae60;font-size:13px}
.modal-bg{display:none;position:fixed;inset:0;background:rgba(0,0,0,.45);z-index:999;align-items:center;justify-content:center}
.modal-bg.open{display:flex}
.modal{background:#fff;border-radius:12px;padding:26px 28px;width:420px;max-width:95vw;box-shadow:0 8px 40px rgba(0,0,0,.2);animation:slideUp .2s ease}
@keyframes slideUp{from{transform:translateY(16px);opacity:0}to{transform:translateY(0);opacity:1}}
.modal h3{font-size:15px;font-weight:700;color:#ff7600;margin-bottom:18px}
.form-row{display:flex;flex-direction:column;gap:4px;margin-bottom:12px}
.form-row label{font-size:11px;font-weight:700;color:#888;text-transform:uppercase;letter-spacing:.4px}
.form-row input,.form-row select,.form-row textarea{background:#f9fafc;border:1px solid #d0d6e8;color:#333;border-radius:7px;padding:7px 10px;font-size:13px;width:100%}
.form-row textarea{height:60px;resize:vertical}
.form-2col{display:grid;grid-template-columns:1fr 1fr;gap:12px}
.modal-actions{display:flex;gap:8px;justify-content:flex-end;margin-top:18px}
#toast-wrap{position:fixed;bottom:20px;right:20px;z-index:9999;display:flex;flex-direction:column;gap:6px}
.toast{padding:9px 16px;border-radius:7px;font-size:13px;font-weight:600;color:#fff;box-shadow:0 4px 16px rgba(0,0,0,.2);animation:tIn .2s ease}
@keyframes tIn{from{transform:translateX(30px);opacity:0}to{transform:translateX(0);opacity:1}}
.t-ok{background:#27ae60}.t-err{background:#e53e3e}.t-inf{background:#ff7600}
.ui-autocomplete{max-height:200px;overflow-y:auto}
#empty-msg{padding:60px;text-align:center;color:#aaa;font-size:15px;background:#fff;border-radius:10px;margin-top:16px;box-shadow:0 2px 12px rgba(0,0,0,.08)}
/* ── LOGIN ── */
#login-overlay{position:fixed;inset:0;background:rgba(244,246,250,.97);z-index:9999;display:flex;align-items:center;justify-content:center}
#login-box{background:#fff;border-radius:14px;padding:40px 44px;width:360px;box-shadow:0 8px 40px rgba(0,0,0,.13);text-align:center}
#login-box h2{color:#ff7600;font-weight:700;font-size:1.3em;margin-bottom:6px}
#login-box p{color:#999;font-size:13px;margin-bottom:24px}
#login-box input[type=password]{width:100%;padding:10px 14px;border:1px solid #d0d6e8;border-radius:8px;font-size:18px;letter-spacing:6px;text-align:center;outline:none;margin-bottom:14px}
#login-box input[type=password]:focus{border-color:#ff7600}
#login-box .btn-orange{width:100%;justify-content:center;height:40px;font-size:14px}
#login-error{color:#e53e3e;font-size:13px;margin-top:10px;min-height:18px}
.auth-info{font-size:12px;color:#888;display:flex;align-items:center;gap:8px}
.auth-info strong{color:#555}
/* ── WIDOK MIESIĘCZNY ── */
#month-table{border-collapse:collapse;width:100%;background:#fff;border-radius:10px;overflow:hidden;box-shadow:0 2px 12px rgba(0,0,0,.08);font-size:11px}
#month-table thead th{background:#ff7600;color:#fff;padding:4px 2px;text-align:center;font-weight:600;font-size:10px;white-space:nowrap;min-width:32px;width:32px}
#month-table thead th.th-name-m{text-align:left;padding-left:10px;min-width:160px;width:160px;font-size:11px}
#month-table thead th.th-sum-m{min-width:64px;width:64px;background:#e56a00;font-size:10px}
#month-table thead th.th-wd{color:#ffcca0}
#month-table thead th.th-td{background:#cc5f00}
#month-table tbody td{border-bottom:1px solid #eef0f6;border-right:1px solid #f0f0f0;padding:2px;vertical-align:top;min-height:36px}
#month-table tbody td.td-name-m{padding:6px 4px 6px 10px;vertical-align:middle;border-right:2px solid #e0e4ef}
#month-table tbody td.wd{background:rgba(255,107,107,.05)}
#month-table tbody td.td-m{background:rgba(255,118,0,.07)}
#month-table tbody tr:hover td{background:#fff8f0!important}
#month-table tfoot td{padding:4px 2px;font-weight:700;font-size:10px;background:#fff3e8;border-top:2px solid #ff7600;text-align:center;color:#555;border-right:1px solid #ffe0c0}
#month-table tfoot td.td-name-m{text-align:left;padding-left:10px}
.mc{border-radius:3px;padding:1px 3px;margin:1px 0;font-size:9px;line-height:1.25;border-left:2px solid #ff7600;background:#fff8f0;max-width:100%;text-align:center}
.mc-leave{border-left-color:#e53e3e;background:#fff5f5;color:#e53e3e}
.add-btn-m{display:block;width:100%;padding:1px 0;border:none;background:transparent;color:#ddd;cursor:pointer;font-size:12px;text-align:center;line-height:1}
.add-btn-m:hover{color:#ff7600}
.btn-view{font-size:11px;padding:0 10px;height:28px}
.btn-view.active{background:#ff7600;color:#fff;border-color:#ff7600}
/* ── CHECKBOXY DNI TYGODNIA ── */
#m-days-wrap{margin-bottom:12px}
#m-days-wrap>label{font-size:11px;font-weight:700;color:#888;text-transform:uppercase;letter-spacing:.4px;display:block;margin-bottom:6px}
.days-cb-row{display:flex;gap:6px;background:#f9fafc;border:1px solid #d0d6e8;border-radius:7px;padding:8px 10px}
.day-cb-item{flex:1;display:flex;flex-direction:column;align-items:center;gap:3px;cursor:pointer;padding:4px 2px;border-radius:5px;transition:background .12s}
.day-cb-item:hover{background:#fff3e8}
.day-cb-item input[type=checkbox]{accent-color:#ff7600;width:15px;height:15px;cursor:pointer;margin:0}
.day-cb-item span{font-size:10px;font-weight:700;color:#aaa;text-transform:uppercase;line-height:1;user-select:none}
.day-cb-item input:checked~span{color:#ff7600}
.day-cb-item.is-weekend span{color:#f0b080}
.day-cb-item.is-weekend input:checked~span{color:#e56a00}
.mc[draggable]{cursor:grab}
.mc.mc-dragging{opacity:.35;transform:scale(.95)}
#month-table tbody td.mc-drag-over{background:rgba(255,118,0,.18)!important;outline:2px dashed #ff7600;outline-offset:-2px;border-radius:4px}
/* ── ZMIANY Z INNYCH JEDNOSTEK ── */
.shift-chip-ext{border-left-color:#bbb!important;background:#f4f4f4!important;opacity:.8;cursor:default}
.shift-chip-ext .sc-time{color:#888!important}
.shift-chip-ext .sc-ext-label{font-size:10px;color:#aaa;margin-top:1px;white-space:nowrap;overflow:hidden;text-overflow:ellipsis}
.mc-ext{border-left-color:#ccc!important;background:#f4f4f4!important;color:#999!important;opacity:.8;cursor:default}
/* ── LOADING OVERLAY ── */
#loading-overlay{display:none;position:fixed;inset:0;background:rgba(255,255,255,.75);z-index:99999;align-items:center;justify-content:center;flex-direction:column;gap:16px}
#loading-overlay.active{display:flex}
.spinner{width:52px;height:52px;border:5px solid #ffe0c0;border-top-color:#ff7600;border-radius:50%;animation:spin .7s linear infinite}
@keyframes spin{to{transform:rotate(360deg)}}
#loading-overlay p{color:#ff7600;font-weight:700;font-size:15px;letter-spacing:.3px}
</style>
</head>
<body>

<?php if (!$auth_logged_in): ?>
<div id="login-overlay">
  <div id="login-box">
    <h2>🔒 Grafik Pracy</h2>
    <p>Wprowadź swój PIN pracownika, aby uzyskać dostęp.</p>
    <input type="password" id="pin-input" placeholder="••••" maxlength="4" autocomplete="off">
    <button class="btn btn-orange" onclick="doLogin()">Zaloguj</button>
    <div id="login-error"></div>
  </div>
</div>
<?php elseif ($access_denied): ?>
<div id="login-overlay">
  <div id="login-box">
    <h2>⛔ Brak dostępu</h2>
    <p>Możesz przeglądać tylko grafik swojej podjednostki:<br>
       <strong><?= htmlspecialchars($auth_subunit_name) ?></strong></p>
    <a class="btn btn-orange" href="?subunit_id=<?= (int)$auth_subunit_id ?>" style="display:inline-flex;justify-content:center;width:100%;height:40px;margin-bottom:10px">Przejdź do swojego grafiku</a>
    <a href="?logout=1" style="font-size:12px;color:#aaa">Wyloguj i zmień PIN</a>
  </div>
</div>
<?php endif; ?>

<div id="topbar">
    <h1>📅 Grafik Pracy</h1>
    <div class="tb-sep"></div>
    <form method="GET" action="<?= htmlspecialchars($self) ?>" style="display:flex;align-items:center;gap:8px;flex-wrap:wrap">
        <input type="hidden" name="week_start" value="<?= htmlspecialchars($week_start) ?>">
        <label style="font-size:11px;font-weight:700;color:#888;text-transform:uppercase">Podjednostka:</label>
        <select name="subunit_id" onchange="this.form.submit()" style="min-width:180px">
            <option value="">– wybierz –</option>
            <?php foreach ($podjednostki as $pj): ?>
            <?php if (!$auth_is_admin && $auth_logged_in && $pj['id'] != $auth_subunit_id) continue; ?>
            <option value="<?= $pj['id'] ?>" <?= ($pj['id'] == $subunit_id) ? 'selected' : '' ?>><?= htmlspecialchars($pj['name']) ?></option>
            <?php endforeach; ?>
        </select>
    </form>
    <?php if ($subunit_id): ?>
    <div class="tb-sep"></div>
    <div style="display:flex;gap:3px">
        <a class="btn btn-ghost btn-view <?= $view==='week'?'active':'' ?>" href="<?= $self ?>?subunit_id=<?= $subunit_id ?>&view=week&week_start=<?= $week_start ?>">Tydzień</a>
        <a class="btn btn-ghost btn-view <?= $view==='month'?'active':'' ?>" href="<?= $self ?>?subunit_id=<?= $subunit_id ?>&view=month&month_start=<?= $month_start ?>">Miesiąc</a>
    </div>
    <div class="tb-sep"></div>
    <?php if ($view === 'week'): ?>
    <div id="week-nav">
        <a class="btn btn-ghost" href="<?= $self ?>?subunit_id=<?= $subunit_id ?>&view=week&week_start=<?= $prev_week ?>">◀</a>
        <span id="week-label"><?= htmlspecialchars(fmtWeekLabel($week_start,$week_end)) ?></span>
        <a class="btn btn-ghost" href="<?= $self ?>?subunit_id=<?= $subunit_id ?>&view=week&week_start=<?= $next_week ?>">▶</a>
        <a class="btn btn-ghost" href="<?= $self ?>?subunit_id=<?= $subunit_id ?>&view=week" style="font-size:11px">Dziś</a>
    </div>
    <div class="tb-sep"></div>
    <button class="btn btn-ghost" onclick="openCopyModal()">⧉ Kopiuj tydzień</button>
    <button class="btn btn-ghost" onclick="exportPDF()">⬇ PDF</button>
    <button class="btn btn-ghost" onclick="exportXLS()">⬇ Excel</button>
    <?php else: ?>
    <div id="week-nav">
        <a class="btn btn-ghost" href="<?= $self ?>?subunit_id=<?= $subunit_id ?>&view=month&month_start=<?= $prev_month ?>">◀</a>
        <span id="week-label"><?= htmlspecialchars($month_label_pl) ?></span>
        <a class="btn btn-ghost" href="<?= $self ?>?subunit_id=<?= $subunit_id ?>&view=month&month_start=<?= $next_month ?>">▶</a>
        <a class="btn btn-ghost" href="<?= $self ?>?subunit_id=<?= $subunit_id ?>&view=month" style="font-size:11px">Dziś</a>
    </div>
    <div class="tb-sep"></div>
    <button class="btn btn-ghost" onclick="exportMonthPDF()">⬇ PDF</button>
    <button class="btn btn-ghost" onclick="exportMonthXLS()">⬇ Excel</button>
    <?php endif; ?>
    <?php endif; ?>
    <?php if ($auth_logged_in): ?>
    <div class="tb-sep"></div>
    <div class="auth-info">
        👤 <strong><?= htmlspecialchars($auth_emp_name) ?></strong>
        <?php if ($auth_is_admin): ?><span style="color:#ff7600;font-weight:700">(admin)</span><?php endif; ?>
        <a href="obecnosc.php<?= $subunit_id ? '?subunit_id='.$subunit_id : '' ?>" class="btn btn-ghost" style="font-size:11px;height:26px;padding:0 10px" title="Przejdź do ewidencji czasu pracy">🕐 Ewidencja</a>
        <a href="?logout=1" class="btn btn-ghost" style="font-size:11px;height:26px;padding:0 10px">Wyloguj</a>
    </div>
    <?php endif; ?>
</div>

<div id="wrap">
<?php if (!$subunit_id): ?>
<div id="empty-msg">Wybierz podjednostkę, aby wyświetlić grafik pracy.</div>
<?php elseif (empty($emp_map)): ?>
<div id="empty-msg">Brak pracowników przypisanych do tej podjednostki.</div>
<?php else: ?>

<?php if ($view === 'week'): ?>
<table id="schedule-table">
    <thead><tr>
        <th class="th-name">Pracownik</th>
        <?php foreach ($week_days as $i => $day):
            $cls = 'th-day'.($i>=5?' th-weekend':'').($day===$today?' th-today':'');
            $mn  = ['sty','lut','mar','kwi','maj','cze','lip','sie','wrz','paź','lis','gru'][(int)date('n',strtotime($day))-1];
        ?>
        <th class="<?= $cls ?>"><?= $dni_pl[$i] ?><br><span style="font-size:16px;font-weight:900"><?= date('j',strtotime($day)) ?></span> <span style="font-size:10px;opacity:.75"><?= $mn ?></span></th>
        <?php endforeach; ?>
        <th class="th-sum">Σ godz.</th>
    </tr></thead>
    <tbody>
    <?php foreach ($emp_map as $emp):
        $norm_min_w = (int)round((float)$emp['daily_norm'] * 60);
        $wmin = 0; $wleave = 0;
        foreach ($week_days as $d) {
            if (!empty($shifts_idx[$emp['emp_number']][$d]))
                foreach ($shifts_idx[$emp['emp_number']][$d] as $s) $wmin += $s['minutes'];
            if (!empty($leaves_idx[$emp['emp_number']][$d]))
                foreach ($leaves_idx[$emp['emp_number']][$d] as $lv)
                    if (!preg_match('/bezp.atn/iu', $lv['leave_type'] ?? '')) {
                        $wmin   += $norm_min_w;
                        $wleave += $norm_min_w;
                    }
        }
        $wh = floor($wmin/60); $wm = $wmin%60;
        $wlh = floor($wleave/60); $wlm = $wleave%60;
    ?>
    <tr class="emp-row" data-emp="<?= $emp['emp_number'] ?>">
        <td class="td-name">
            <div class="emp-name"><?= htmlspecialchars($emp['emp_lastname'].' '.$emp['emp_firstname']) ?></div>
            <div class="emp-meta">Norma: <?= $emp['daily_norm'] ?>h</div>
            <?php if (!empty($emp['is_sub_only'])): ?><div class="emp-sub-badge">↩ zastępstwo</div><?php endif; ?>
        </td>
        <?php foreach ($week_days as $i => $day):
            $cls='td-day'.($i>=5?' weekend':'').($day===$today?' today':'');
        ?>
        <td class="<?= $cls ?>" data-date="<?= $day ?>" data-emp="<?= $emp['emp_number'] ?>">
            <?php if (!empty($leaves_idx[$emp['emp_number']][$day])): foreach ($leaves_idx[$emp['emp_number']][$day] as $lv): ?>
            <div class="shift-chip" style="border-left-color:#e53e3e;background:#fff5f5">
                <div class="sc-leave">🏖 <?= htmlspecialchars($lv['leave_type']) ?></div>
            </div>
            <?php endforeach; endif; ?>
            <?php if (!empty($shifts_idx[$emp['emp_number']][$day])): foreach ($shifts_idx[$emp['emp_number']][$day] as $s):
                $color = $s['color'] ?? '#ff7600';
                $bg    = h2rgba($color, 0.12);
            ?>
            <div class="shift-chip" draggable="true"
                 data-id="<?= $s['id'] ?>" data-emp="<?= $s['emp_number'] ?>" data-date="<?= $s['shift_date'] ?>"
                 style="border-left-color:<?= htmlspecialchars($color) ?>;background:<?= $bg ?>">
                <div class="sc-time" style="color:<?= htmlspecialchars($color) ?>"><?= $s['time_from'] ?>–<?= $s['time_to'] ?></div>
                <?php if ($s['role_name']): ?><div class="sc-role"><?= htmlspecialchars($s['role_name']) ?></div><?php endif; ?>
                <?php if ($s['is_substitute']): ?><div class="sc-sub">↩ Zastępstwo</div><?php endif; ?>
                <div class="sc-acts">
                    <button class="sc-btn" onclick="openEditModal(<?= htmlspecialchars(json_encode($s)) ?>)">✏</button>
                    <button class="sc-btn del" onclick="deleteShift(<?= $s['id'] ?>)">✕</button>
                </div>
            </div>
            <?php endforeach; endif; ?>
            <?php if (!empty($shifts_ext_idx[$emp['emp_number']][$day])): foreach ($shifts_ext_idx[$emp['emp_number']][$day] as $s): ?>
            <div class="shift-chip shift-chip-ext"
                 title="Zmiana w innej jednostce: <?= htmlspecialchars($s['ext_subunit_name'] ?? 'nieznana') ?>">
                <div class="sc-time"><?= $s['time_from'] ?>–<?= $s['time_to'] ?></div>
                <?php if ($s['role_name']): ?><div class="sc-role"><?= htmlspecialchars($s['role_name']) ?></div><?php endif; ?>
                <div class="sc-ext-label">📍 <?= htmlspecialchars($s['ext_subunit_name'] ?? '') ?></div>
            </div>
            <?php endforeach; endif; ?>
            <button class="add-btn" onclick="openAddModal(<?= $emp['emp_number'] ?>, '<?= $day ?>')">+</button>
        </td>
        <?php endforeach; ?>
        <td style="text-align:center;vertical-align:middle;font-weight:700;color:<?= $wmin>0?'#27ae60':'#ccc' ?>">
            <?= $wmin>0 ? $wh.'h'.($wm>0?$wm.'m':'') : '–' ?>
            <?php if ($wleave>0): ?><div style="font-size:10px;font-weight:700;color:#e53e3e;margin-top:2px"><?= $wlh ?>h<?= $wlm>0?$wlm.'m':'' ?> urlop</div><?php endif; ?>
        </td>
    </tr>
    <?php endforeach; ?>
    <?php if ($subunit_id && $view === 'week'): ?>
    <tr id="row-add-sub">
        <td class="td-name" style="vertical-align:middle">
            <input type="text" id="sub-emp-name" placeholder="+ wpisz nazwisko (zastępstwo)…" autocomplete="off"
                   style="width:100%;border:1px dashed #ff7600;border-radius:6px;padding:5px 8px;font-size:12px;background:#fff8f0;color:#333">
            <input type="hidden" id="sub-emp-id">
            <div id="sub-emp-info" style="font-size:11px;color:#27ae60;margin-top:3px;display:none"></div>
        </td>
        <?php foreach ($week_days as $day): ?>
        <td class="td-day" style="text-align:center;vertical-align:middle;color:#ddd;font-size:18px">–</td>
        <?php endforeach; ?>
        <td></td>
    </tr>
    <?php endif; ?>
    </tbody>
    <tfoot><tr id="row-totals">
        <td class="td-name">SUMA DZIENNA</td>
        <?php $gtot=0; foreach ($week_days as $i=>$day):
            $dm=0; foreach ($emp_map as $emp) if (!empty($shifts_idx[$emp['emp_number']][$day])) foreach ($shifts_idx[$emp['emp_number']][$day] as $s) $dm+=$s['minutes'];
            $gtot+=$dm; $dh=floor($dm/60); $dmm=$dm%60;
        ?>
        <td><?= $dm>0 ? '<span class="day-total">'.$dh.'h'.($dmm>0?$dmm.'m':'').'</span>' : '<span style="opacity:.3">–</span>' ?></td>
        <?php endforeach; $gh=floor($gtot/60);$gm=$gtot%60; ?>
        <td style="color:#ff7600"><?= $gtot>0?$gh.'h'.($gm>0?$gm.'m':''):'–' ?></td>
    </tr></tfoot>
</table>
<?php elseif ($view === 'month' && !empty($emp_map)): ?>
<?php $dni_skr = ['Nd','Pn','Wt','Sr','Cz','Pt','So']; ?>
<div style="overflow-x:auto">
<table id="month-table">
    <thead><tr>
        <th class="th-name-m">Pracownik</th>
        <?php foreach ($month_days as $day):
            $dow=(int)date('w',strtotime($day)); $isWd=($dow==0||$dow==6); $isTd=($day===$today);
            $cls=''.($isWd?' th-wd':'').($isTd?' th-td':'');
        ?><th class="<?= $cls ?>"><?= $dni_skr[$dow] ?><br><strong><?= (int)date('j',strtotime($day)) ?></strong></th>
        <?php endforeach; ?>
        <th class="th-sum-m">Sh</th>
    </tr></thead>
    <tbody>
    <?php foreach ($emp_map as $emp):
        $eid=$emp['emp_number'];
        $norm_min_m = (int)round((float)$emp['daily_norm'] * 60);
        $total_min=0; $mleave=0;
        foreach ($month_days as $day) {
            if (!empty($ms_idx[$eid][$day]))
                foreach ($ms_idx[$eid][$day] as $s) { $h=$s['godziny']; if($s['time_to']<$s['time_from'])$h+=24; $total_min+=$h*60; }
            if (!empty($ml_idx[$eid][$day]))
                foreach ($ml_idx[$eid][$day] as $lv)
                    if (!preg_match('/bezp.atn/iu', $lv['leave_type'] ?? '')) {
                        $total_min += $norm_min_m;
                        $mleave    += $norm_min_m;
                    }
        }
        $wh=floor($total_min/60); $wm=$total_min%60;
        $mlh=floor($mleave/60); $mlm=$mleave%60;
    ?>
    <tr data-emp="<?= $eid ?>">
        <td class="td-name-m">
            <div style="font-weight:700;font-size:12px"><?= htmlspecialchars($emp['emp_lastname'].' '.$emp['emp_firstname']) ?></div>
            <div style="font-size:10px;color:#aaa;margin-top:1px">Norma: <?= $emp['daily_norm'] ?>h</div>
            <?php if ($wh>0): ?><div style="font-size:10px;color:#27ae60;font-weight:700;margin-top:1px"><?= $wh ?>h<?= $wm>0?$wm.'m':'' ?></div><?php endif; ?>
            <?php if ($mleave>0): ?><div style="font-size:10px;color:#e53e3e;font-weight:700;margin-top:1px"><?= $mlh ?>h<?= $mlm>0?$mlm.'m':'' ?> urlop</div><?php endif; ?>
        </td>
        <?php foreach ($month_days as $day):
            $dow=(int)date('w',strtotime($day)); $isWd=($dow==0||$dow==6); $isTd=($day===$today);
            $cls=($isWd?'wd':'').($isTd?' td-m':'');
        ?>
        <td class="<?= $cls ?>" data-date="<?= $day ?>" data-emp="<?= $eid ?>">
            <?php if (!empty($ml_idx[$eid][$day])): ?>
                <div class="mc mc-leave" title="<?= htmlspecialchars($ml_idx[$eid][$day][0]['leave_type']) ?>">🏖</div>
            <?php endif; ?>
            <?php if (!empty($ms_idx[$eid][$day])): foreach ($ms_idx[$eid][$day] as $s):
                $color=$s['color']??'#ff7600'; ?>
                <div class="mc mc-draggable" draggable="true"
                     data-id="<?= $s['id'] ?>"
                     data-emp="<?= $eid ?>"
                     data-date="<?= $day ?>"
                     data-from="<?= $s['time_from'] ?>"
                     data-to="<?= $s['time_to'] ?>"
                     data-role="<?= htmlspecialchars($s['role_name'] ?? '') ?>"
                     style="border-left-color:<?= $color ?>;color:<?= $color ?>;cursor:grab"
                     title="<?= $s['time_from'] ?>–<?= $s['time_to'] ?><?= $s['role_name']?' | '.$s['role_name']:'' ?>">
                    <?= $s['time_from'] ?><br><?= $s['time_to'] ?>
                </div>
            <?php endforeach; endif; ?>
            <?php if (!empty($ms_ext_idx[$eid][$day])): foreach ($ms_ext_idx[$eid][$day] as $s): ?>
                <div class="mc mc-ext"
                     title="<?= $s['time_from'] ?>–<?= $s['time_to'] ?> | Inna jednostka: <?= htmlspecialchars($s['ext_subunit_name'] ?? '') ?>">
                    <?= $s['time_from'] ?><br><?= $s['time_to'] ?>
                </div>
            <?php endforeach; endif; ?>
            <button class="add-btn-m" onclick="openAddModal(<?= $eid ?>, '<?= $day ?>')">+</button>
        </td>
        <?php endforeach; ?>
        <td style="text-align:center;font-weight:700;color:<?= $total_min>0?'#27ae60':'#ccc' ?>;vertical-align:middle;font-size:11px">
            <?= $total_min>0 ? $wh.'h'.($wm>0?$wm.'m':'') : '–' ?>
            <?php if ($mleave>0): ?><div style="font-size:10px;font-weight:700;color:#e53e3e;margin-top:1px"><?= $mlh ?>h<?= $mlm>0?$mlm.'m':'' ?> urlop</div><?php endif; ?>
        </td>
    </tr>
    <?php endforeach; ?>
    </tbody>
    <tfoot><tr>
        <td class="td-name-m" style="font-weight:700;font-size:11px">SUMA</td>
        <?php $gtot=0; foreach ($month_days as $day):
            $dm=0; foreach ($emp_map as $emp) if (!empty($ms_idx[$emp['emp_number']][$day])) foreach ($ms_idx[$emp['emp_number']][$day] as $s) { $h=$s['godziny']; if($s['time_to']<$s['time_from'])$h+=24; $dm+=$h*60; }
            $gtot+=$dm; $dh=floor($dm/60);
        ?><td><?= $dm>0?'<span style="color:#27ae60">'.$dh.'h</span>':'<span style="opacity:.25">-</span>' ?></td>
        <?php endforeach; $gh=floor($gtot/60);$gm=$gtot%60; ?>
        <td style="color:#ff7600;font-weight:700"><?= $gtot>0?$gh.'h'.($gm>0?$gm.'m':''):'–' ?></td>
    </tr></tfoot>
</table>
</div>
<?php endif; ?>
<?php endif; ?>
</div>

<!-- Modal Dodaj/Edytuj -->
<div class="modal-bg" id="shift-modal">
  <div class="modal">
    <h3 id="modal-title">Dodaj zmianę</h3>
    <input type="hidden" id="m-id">
    <input type="hidden" id="m-emp-id">
    <div class="form-row"><label>Pracownik * <span style="font-weight:400;color:#aaa;text-transform:none">(wpisz nazwisko, aby zmienić na innego)</span></label><input type="text" id="m-emp-name" placeholder="Wpisz min. 2 znaki nazwiska…" autocomplete="off"></div>
    <div class="form-row"><label>Data *</label><input type="text" id="m-date" readonly placeholder="Wybierz datę…"></div>
    <div id="m-days-wrap">
        <label>Powtórz dla dni tygodnia</label>
        <div class="days-cb-row">
            <label class="day-cb-item"><input type="checkbox" name="m-day" value="0"><span>Pn</span></label>
            <label class="day-cb-item"><input type="checkbox" name="m-day" value="1"><span>Wt</span></label>
            <label class="day-cb-item"><input type="checkbox" name="m-day" value="2"><span>Śr</span></label>
            <label class="day-cb-item"><input type="checkbox" name="m-day" value="3"><span>Cz</span></label>
            <label class="day-cb-item"><input type="checkbox" name="m-day" value="4"><span>Pt</span></label>
            <label class="day-cb-item is-weekend"><input type="checkbox" name="m-day" value="5"><span>So</span></label>
            <label class="day-cb-item is-weekend"><input type="checkbox" name="m-day" value="6"><span>Nd</span></label>
        </div>
    </div>
    <div class="form-2col">
        <div class="form-row"><label>Godzina od *</label><input type="time" id="m-from" value="07:00"></div>
        <div class="form-row"><label>Godzina do *</label><input type="time" id="m-to" value="15:00"></div>
    </div>
    <div class="form-row"><label>Rola / Stanowisko</label>
        <select id="m-role"><option value="">– brak –</option>
        <?php foreach ($roles as $r): ?>
        <option value="<?= htmlspecialchars($r['role_name']) ?>" style="color:<?= $r['color'] ?>"><?= htmlspecialchars($r['role_name']) ?></option>
        <?php endforeach; ?></select>
    </div>
    <div class="form-row"><label><input type="checkbox" id="m-sub"> Zastępstwo spoza jednostki</label></div>
    <div class="form-row"><label>Notatka</label><textarea id="m-note" placeholder="Opcjonalnie…"></textarea></div>
    <div class="modal-actions">
        <button class="btn btn-ghost" onclick="closeModal('shift-modal')">Anuluj</button>
        <button class="btn btn-danger" id="btn-modal-del" style="display:none" onclick="deleteShiftFromModal()">Usuń</button>
        <button class="btn btn-orange" onclick="saveShift()">Zapisz</button>
    </div>
  </div>
</div>

<!-- Modal Kopiuj -->
<div class="modal-bg" id="copy-modal">
  <div class="modal" style="width:360px">
    <h3>Kopiuj tydzień</h3>
    <div class="form-row"><label>Kopiuj z (pon.)</label><input type="text" id="copy-from" readonly value="<?= htmlspecialchars($week_start) ?>"></div>
    <div class="form-row"><label>Wklej do (pon.)</label><input type="text" id="copy-to" readonly placeholder="Wybierz datę…"></div>
    <div class="form-row"><label><input type="checkbox" id="copy-overwrite"> Nadpisz istniejące zmiany</label></div>
    <div class="modal-actions">
        <button class="btn btn-ghost" onclick="closeModal('copy-modal')">Anuluj</button>
        <button class="btn btn-orange" onclick="confirmCopy()">Kopiuj</button>
    </div>
  </div>
</div>

<div id="toast-wrap"></div>
<div id="loading-overlay"><div class="spinner"></div><p>Zapisywanie…</p></div>

<script>
const SELF             = <?= json_encode($self) ?>;
const AUTOCOMPLETE_URL = <?= json_encode($self) ?>;
const SUBUNIT_ID = <?= (int)$subunit_id ?>;
const WEEK_START = <?= json_encode($week_start) ?>;

function plChar(str) {
    if (!str) return str;
    return String(str)
        .replace(/ą/g,'a').replace(/ć/g,'c').replace(/ę/g,'e').replace(/ł/g,'l')
        .replace(/ń/g,'n').replace(/ó/g,'o').replace(/ś/g,'s').replace(/ź/g,'z')
        .replace(/ż/g,'z').replace(/Ą/g,'A').replace(/Ć/g,'C').replace(/Ę/g,'E')
        .replace(/Ł/g,'L').replace(/Ń/g,'N').replace(/Ó/g,'O').replace(/Ś/g,'S')
        .replace(/Ź/g,'Z').replace(/Ż/g,'Z');
}

// Drag & Drop – widok tygodniowy
let dragId=null,dragEmp=null,dragDate=null;
document.querySelectorAll('.shift-chip[draggable]').forEach(chip=>{
    chip.addEventListener('dragstart',e=>{
        dragId=chip.dataset.id; dragEmp=chip.dataset.emp; dragDate=chip.dataset.date;
        chip.classList.add('dragging'); e.dataTransfer.effectAllowed='move';
    });
    chip.addEventListener('dragend',()=>chip.classList.remove('dragging'));
});
document.querySelectorAll('.td-day').forEach(td=>{
    td.addEventListener('dragover',e=>{e.preventDefault();td.classList.add('drag-over');});
    td.addEventListener('dragleave',()=>td.classList.remove('drag-over'));
    td.addEventListener('drop', function(e){
        e.preventDefault(); td.classList.remove('drag-over');
        var newDate=td.dataset.date, newEmp=td.dataset.emp;
        if(!dragId||(newDate===dragDate&&newEmp==dragEmp)) return;
        var chip=document.querySelector('.shift-chip[data-id="'+dragId+'"]');
        if(!chip) return;
        var t=chip.querySelector('.sc-time').textContent.split('–');
        var fd=new FormData();
        fd.append('action','save_shift'); fd.append('id',0);
        fd.append('emp_number',newEmp); fd.append('subunit_id',SUBUNIT_ID);
        fd.append('shift_date',newDate); fd.append('time_from',t[0].trim()); fd.append('time_to',t[1].trim());
        var roleEl=chip.querySelector('.sc-role');
        fd.append('role_name', roleEl ? roleEl.textContent.trim() : '');
        fd.append('is_substitute',chip.querySelector('.sc-sub')?1:0);
        showLoading('Kopiowanie zmiany…');
        postFD(fd).then(function(res){
            if(res.ok){toast('Zmiana skopiowana','ok');reload();}
            else{hideLoading();toast('Blad: '+(res.msg||''),'err');}
        });
    });
});

// Drag & Drop – widok miesięczny
(function initMonthDragDrop(){
    var mDragId=null, mDragEmp=null, mDragDate=null;
    document.querySelectorAll('.mc-draggable').forEach(function(mc){
        mc.addEventListener('dragstart', function(e){
            mDragId=mc.dataset.id; mDragEmp=mc.dataset.emp; mDragDate=mc.dataset.date;
            mc.classList.add('mc-dragging'); e.dataTransfer.effectAllowed='move';
            e.dataTransfer.setData('text/plain', mDragId);
        });
        mc.addEventListener('dragend', function(){ mc.classList.remove('mc-dragging'); });
    });
    document.querySelectorAll('#month-table tbody td[data-date]').forEach(function(td){
        td.addEventListener('dragover', function(e){ if(!mDragId) return; e.preventDefault(); td.classList.add('mc-drag-over'); });
        td.addEventListener('dragleave', function(){ td.classList.remove('mc-drag-over'); });
        td.addEventListener('drop', function(e){
            e.preventDefault(); td.classList.remove('mc-drag-over');
            var newDate=td.dataset.date, newEmp=td.dataset.emp;
            if(!mDragId) return;
            if(newDate===mDragDate && newEmp==mDragEmp){ mDragId=null; return; }
            var mc=document.querySelector('.mc-draggable[data-id="'+mDragId+'"]');
            if(!mc){ mDragId=null; return; }
            var fd=new FormData();
            fd.append('action','save_shift'); fd.append('id',0);
            fd.append('emp_number',newEmp); fd.append('subunit_id',SUBUNIT_ID);
            fd.append('shift_date',newDate); fd.append('time_from',mc.dataset.from);
            fd.append('time_to',mc.dataset.to); fd.append('role_name',mc.dataset.role||'');
            fd.append('is_substitute',0);
            mDragId=null;
            showLoading('Kopiowanie zmiany…');
            postFD(fd).then(function(res){
                if(res.ok){ toast('Zmiana skopiowana','ok'); reload(); }
                else { hideLoading(); toast('Blad: '+(res.msg||''),'err'); }
            });
        });
    });
})();

function openSubstituteModal(){
    document.getElementById('modal-title').textContent='Dodaj zastepstwo z innej jednostki';
    document.getElementById('m-id').value=''; document.getElementById('m-emp-id').value='';
    document.getElementById('m-emp-name').value=''; document.getElementById('m-date').value='';
    document.getElementById('m-from').value='07:00'; document.getElementById('m-to').value='15:00';
    document.getElementById('m-role').value=''; document.getElementById('m-sub').checked=true;
    document.getElementById('m-note').value=''; document.getElementById('btn-modal-del').style.display='none';
    openModal('shift-modal');
    setTimeout(()=>{ document.getElementById('m-emp-name').focus(); }, 150);
}

function openAddModal(empId,date){
    document.getElementById('modal-title').textContent='Dodaj zmianę';
    document.getElementById('m-id').value=''; document.getElementById('m-date').value=date;
    document.getElementById('m-from').value='07:00'; document.getElementById('m-to').value='15:00';
    document.getElementById('m-role').value=''; document.getElementById('m-sub').checked=false;
    document.getElementById('m-note').value=''; document.getElementById('btn-modal-del').style.display='none';
    var dow=new Date(date).getDay(), dayIdx=dow===0?6:dow-1;
    document.querySelectorAll('[name="m-day"]').forEach(function(cb){ cb.checked=(parseInt(cb.value)===dayIdx); });
    document.getElementById('m-days-wrap').style.display='';
    const row=document.querySelector('tr[data-emp="'+empId+'"]');
    var empName='';
    if(row){ var nameEl=row.querySelector('.emp-name')||row.querySelector('td.td-name-m div'); empName=nameEl?nameEl.textContent.trim():''; }
    document.getElementById('m-emp-id').value=empId; document.getElementById('m-emp-name').value=empName;
    openModal('shift-modal');
    setTimeout(()=>{ const f=document.getElementById('m-emp-name'); f.focus(); f.select(); },150);
}
function openEditModal(s){
    document.getElementById('modal-title').textContent='Edytuj zmianę';
    document.getElementById('m-id').value=s.id; document.getElementById('m-emp-id').value=s.emp_number;
    document.getElementById('m-emp-name').value=s.emp_lastname+' '+s.emp_firstname;
    document.getElementById('m-date').value=s.shift_date;
    document.getElementById('m-from').value=s.time_from; document.getElementById('m-to').value=s.time_to;
    document.getElementById('m-role').value=s.role_name||'';
    document.getElementById('m-sub').checked=!!parseInt(s.is_substitute);
    document.getElementById('m-note').value=s.note||'';
    document.getElementById('btn-modal-del').style.display='';
    document.getElementById('m-days-wrap').style.display='none';
    openModal('shift-modal');
}
function showLoading(msg){ document.querySelector('#loading-overlay p').textContent=msg||'Zapisywanie…'; document.getElementById('loading-overlay').classList.add('active'); }
function hideLoading(){ document.getElementById('loading-overlay').classList.remove('active'); }

function getMondayOf(dateStr){ var d=new Date(dateStr),day=d.getDay(),diff=(day===0)?-6:1-day; d.setDate(d.getDate()+diff); return d.toISOString().slice(0,10); }
function addDaysToDate(dateStr,n){ var d=new Date(dateStr); d.setDate(d.getDate()+n); return d.toISOString().slice(0,10); }

function saveShift(){
    var empId=document.getElementById('m-emp-id').value, baseDate=document.getElementById('m-date').value;
    var from=document.getElementById('m-from').value, to=document.getElementById('m-to').value;
    if(!empId||!baseDate||!from||!to){toast('Uzupelnij wymagane pola','err');return;}
    var isEdit=document.getElementById('m-id').value;
    var roleVal=document.getElementById('m-role').value, isSub=document.getElementById('m-sub').checked?1:0;
    var noteVal=document.getElementById('m-note').value;
    var dates=[];
    if(isEdit){ dates=[baseDate]; }
    else {
        var checkedDays=[];
        document.querySelectorAll('[name="m-day"]:checked').forEach(function(cb){ checkedDays.push(parseInt(cb.value)); });
        if(checkedDays.length===0){ dates=[baseDate]; }
        else { var monday=getMondayOf(baseDate); checkedDays.forEach(function(idx){ dates.push(addDaysToDate(monday,idx)); }); }
    }
    closeModal('shift-modal'); showLoading('Zapisywanie…');
    var promises=dates.map(function(d){
        var fd=new FormData();
        fd.append('action','save_shift'); fd.append('id',(isEdit&&dates.length===1)?isEdit:0);
        fd.append('emp_number',empId); fd.append('subunit_id',SUBUNIT_ID);
        fd.append('shift_date',d); fd.append('time_from',from); fd.append('time_to',to);
        fd.append('role_name',roleVal); fd.append('is_substitute',isSub); fd.append('note',noteVal);
        return postFD(fd);
    });
    Promise.all(promises).then(function(results){
        var errs=results.filter(function(r){return !r.ok;});
        if(errs.length===0){ var n=dates.length; toast(isEdit?'Zaktualizowano':('Dodano zmiane'+(n>1?' dla '+n+' dni':'')), 'ok'); reload(); }
        else { hideLoading(); toast('Blad zapisu: '+(errs[0].msg||''),'err'); }
    });
}
function deleteShift(id){
    var fd=new FormData(); fd.append('action','delete_shift'); fd.append('id',id);
    showLoading('Usuwanie…');
    postFD(fd).then(function(res){ if(res.ok){toast('Zmiana usunieta','ok');reload();} else{hideLoading();toast('Blad usuwania','err');} });
}
function deleteShiftFromModal(){const id=document.getElementById('m-id').value;if(id){closeModal('shift-modal');deleteShift(id);}}
function openCopyModal(){document.getElementById('copy-from').value=WEEK_START;document.getElementById('copy-to').value='';openModal('copy-modal');}
function confirmCopy(){
    var from=document.getElementById('copy-from').value, to=document.getElementById('copy-to').value;
    if(!from||!to){toast('Wybierz oba tygodnie','err');return;}
    if(from===to){toast('Tygodnie musza byc rozne','err');return;}
    var fd=new FormData(); fd.append('action','copy_week'); fd.append('subunit_id',SUBUNIT_ID);
    fd.append('from_week',from); fd.append('to_week',to); fd.append('overwrite',document.getElementById('copy-overwrite').checked?1:0);
    closeModal('copy-modal'); showLoading('Kopiowanie tygodnia…');
    postFD(fd).then(function(res){
        if(res.ok){toast('Skopiowano '+res.copied+' zmian','ok');reload();}
        else{hideLoading();toast('Blad: '+(res.msg||''),'err');}
    });
}
function openModal(id){document.getElementById(id).classList.add('open');}
function closeModal(id){document.getElementById(id).classList.remove('open');}
function reload(){
    var view=<?= json_encode($view) ?>;
    var url=SELF+'?subunit_id='+SUBUNIT_ID;
    if(view==='month'){ url+='&view=month&month_start='+<?= json_encode($month_start) ?>; }
    else { url+='&view=week&week_start='+WEEK_START; var addSub=<?= (int)($_GET['add_sub'] ?? 0) ?>; if(addSub) url+='&add_sub='+addSub; }
    window.location.href=url;
}
function postFD(fd){
    return new Promise(function(resolve){
        $.ajax({ url:SELF, method:'POST', data:fd, processData:false, contentType:false, dataType:'json',
            success:function(data){ resolve(data); },
            error:function(xhr){ console.error('postFD error:',xhr.status,xhr.responseText.slice(0,300)); resolve({ok:false,msg:'Blad serwera ('+xhr.status+'): '+xhr.responseText.slice(0,120)}); }
        });
    });
}
function toast(msg,type='ok'){
    const t=document.createElement('div'); t.className='toast t-'+(type==='ok'?'ok':type==='err'?'err':'inf');
    t.textContent=msg; document.getElementById('toast-wrap').appendChild(t); setTimeout(()=>t.remove(),3000);
}

function doLogin(){
    var pin=document.getElementById('pin-input').value.trim();
    if(!pin){ document.getElementById('login-error').textContent='Wprowadz PIN.'; return; }
    var fd=new FormData(); fd.append('action','login_pin'); fd.append('pin',pin);
    $.ajax({ url:SELF, method:'POST', data:fd, processData:false, contentType:false, dataType:'json',
        success:function(res){ if(res.ok){ window.location.reload(); } else { document.getElementById('login-error').textContent=res.msg||'Bledny PIN.'; document.getElementById('pin-input').value=''; document.getElementById('pin-input').focus(); } },
        error:function(){ document.getElementById('login-error').textContent='Blad polaczenia.'; }
    });
}

$(document).ready(function(){
    $('#pin-input').on('input', function(){ if($(this).val().length===4) doLogin(); });
    $('#pin-input').on('keypress', function(e){ if(e.which===13) doLogin(); });
});

$.datepicker.setDefaults({
    closeText:'Zamknij',prevText:'◀',nextText:'▶',currentText:'Dzis',
    monthNames:['Styczen','Luty','Marzec','Kwiecien','Maj','Czerwiec','Lipiec','Sierpien','Wrzesien','Pazdziernik','Listopad','Grudzien'],
    monthNamesShort:['Sty','Lu','Mar','Kwi','Maj','Cze','Lip','Sie','Wrz','Paz','Lis','Gru'],
    dayNames:['Niedziela','Poniedzialek','Wtorek','Sroda','Czwartek','Piatek','Sobota'],
    dayNamesMin:['N','Pn','Wt','Sr','Cz','Pt','So'],
    dateFormat:'yy-mm-dd',firstDay:1
});
$('#m-date').datepicker();
$('#copy-from').datepicker({onSelect:function(d){$(this).val(getMonday(d));}});
$('#copy-to').datepicker({onSelect:function(d){$(this).val(getMonday(d));}});
function getMonday(ds){const d=new Date(ds),day=d.getDay(),diff=day===0?-6:1-day;d.setDate(d.getDate()+diff);return d.toISOString().slice(0,10);}

$("#m-emp-name").autocomplete({
    source:function(request,response){ $.getJSON(AUTOCOMPLETE_URL+'?action=autocomplete_emp&term='+encodeURIComponent(request.term),function(data){response(data);}).fail(function(){response([]);}); },
    minLength:2,
    select:function(event,ui){ document.getElementById('m-emp-id').value=ui.item.id; if(ui.item.subunit_name) document.getElementById('m-sub').checked=true; return false; }
});
$("#sub-emp-name").autocomplete({
    source:function(request,response){ $.ajax({url:AUTOCOMPLETE_URL,method:"GET",data:{action:"autocomplete_emp",term:request.term},success:function(data){response(data);}}); },
    minLength:2,
    select:function(event,ui){
        $("#sub-emp-id").val(ui.item.id);
        var info=document.getElementById('sub-emp-info');
        info.textContent='✓ '+ui.item.value+(ui.item.subunit_name?' ('+ui.item.subunit_name+')':'')+' – kliknij tutaj aby dodac do grafiku';
        info.style.display='block';
        setTimeout(function(){ window.location.href=SELF+'?subunit_id='+SUBUNIT_ID+'&week_start='+WEEK_START+'&add_sub='+ui.item.id; },600);
        return false;
    }
});

function exportPDF(){
    const{jsPDF}=window.jspdf;
    const doc=new jsPDF({orientation:'landscape',unit:'mm',format:'a4'});
    const rows=[];
    document.querySelectorAll('#schedule-table tbody .emp-row').forEach(tr=>{
        const cells=tr.querySelectorAll('td');
        const row=[plChar(cells[0].querySelector('.emp-name').textContent.trim())];
        for(let i=1;i<cells.length-1;i++){
            const parts=[];
            if(cells[i].querySelector('.sc-leave')) parts.push('[urlop]');
            cells[i].querySelectorAll('.sc-time').forEach(c=>parts.push(c.textContent.trim().replace('–','\n')));
            row.push(parts.join('\n')||'');
        }
        row.push(tr.querySelector('td:last-child').textContent.trim());
        rows.push(row);
    });
    const head=[['Pracownik']];
    document.querySelectorAll('#schedule-table thead th:not(.th-name):not(.th-sum)').forEach(th=>{ head[0].push(plChar(th.firstChild.textContent.trim())); });
    head[0].push('Sigma');
    doc.setFontSize(11);
    doc.text(plChar('Grafik pracy | ')+WEEK_START, 14, 12);
    doc.autoTable({ head, body:rows, startY:18,
        styles:{fontSize:7,overflow:'linebreak',cellPadding:2},
        headStyles:{fillColor:[255,118,0]},
        columnStyles:{0:{cellWidth:35,fontStyle:'bold'}}
    });
    doc.save('grafik_'+WEEK_START+'.pdf');
    toast('PDF wygenerowany','ok');
}

function exportXLS(){
    const wsData=[['Pracownik']];
    document.querySelectorAll('#schedule-table thead th:not(.th-name):not(.th-sum)').forEach(th=>wsData[0].push(th.firstChild.textContent.trim()));
    wsData[0].push('Sigma godz.');
    document.querySelectorAll('#schedule-table tbody .emp-row').forEach(tr=>{
        const cells=tr.querySelectorAll('td');
        const row=[cells[0].querySelector('.emp-name').textContent.trim()];
        for(let i=1;i<cells.length-1;i++){const chips=cells[i].querySelectorAll('.sc-time');row.push([...chips].map(c=>c.textContent.trim()).join(', ')||'');}
        row.push(tr.querySelector('td:last-child').textContent.trim());wsData.push(row);
    });
    const ws=XLSX.utils.aoa_to_sheet(wsData);const wb=XLSX.utils.book_new();
    XLSX.utils.book_append_sheet(wb,ws,'Grafik');XLSX.writeFile(wb,'grafik_'+WEEK_START+'.xlsx');
    toast('Excel wygenerowany','ok');
}

function exportMonthPDF(){
    var tbl=document.getElementById('month-table');
    if(!tbl){ toast('Brak tabeli miesięcznej','err'); return; }
    var{jsPDF}=window.jspdf;
    var doc=new jsPDF({orientation:'landscape',unit:'mm',format:'a4'});
    var subunitName=<?= json_encode(array_column($podjednostki, 'name', 'id')[$subunit_id] ?? '') ?>;
    var monthLabel=<?= json_encode($month_label) ?>;
    doc.setFontSize(11); doc.setTextColor(255,118,0);
    doc.text(plChar('Grafik pracy – ')+plChar(subunitName)+' | '+monthLabel, 14, 12);
    doc.setTextColor(0,0,0);
    var head=[[]];
    tbl.querySelectorAll('thead th').forEach(function(th){ head[0].push(plChar(th.textContent.replace(/\s+/g,' ').trim())); });
    var body=[];
    tbl.querySelectorAll('tbody tr').forEach(function(tr){
        var row=[];
        tr.querySelectorAll('td').forEach(function(td){
            var divs=td.querySelectorAll('.mc');
            if(divs.length>0){
                var parts=[];
                divs.forEach(function(mc){ if(mc.classList.contains('mc-leave')){ parts.push('[urlop]'); } else { parts.push(mc.textContent.replace(/\s+/g,' ').trim()); } });
                row.push(parts.join('\n'));
            } else { row.push(plChar(td.textContent.replace(/\s+/g,' ').trim())); }
        });
        body.push(row);
    });
    doc.autoTable({ head, body, startY:18,
        styles:{fontSize:6,cellPadding:1.5,overflow:'linebreak',halign:'center'},
        columnStyles:{0:{halign:'left',cellWidth:30,fontStyle:'bold'}},
        headStyles:{fillColor:[255,118,0],textColor:255,fontSize:6,fontStyle:'bold'},
        alternateRowStyles:{fillColor:[255,248,240]},
        didParseCell:function(data){
            if(data.section==='head'&&data.column.index>0){
                var th=tbl.querySelectorAll('thead th')[data.column.index];
                if(th&&th.classList.contains('th-wd')) data.cell.styles.textColor=[200,90,0];
            }
        }
    });
    doc.save('grafik_miesiac_<?= date('Y-m', strtotime($month_start)) ?>.pdf');
    toast('PDF wygenerowany','ok');
}

function exportMonthXLS(){
    var tbl=document.getElementById('month-table');
    if(!tbl){ toast('Brak tabeli miesięcznej','err'); return; }
    var wb=XLSX.utils.book_new();
    var ws=XLSX.utils.table_to_sheet(tbl);
    XLSX.utils.book_append_sheet(wb,ws,'Grafik');
    XLSX.writeFile(wb,'grafik_miesiac_<?= date('Y-m', strtotime($month_start)) ?>.xlsx');
    toast('Excel wygenerowany','ok');
}
</script>
</body>
</html>