Embed

< !doctype html >
    <html lang="pl">
        <head>
            <meta charset="utf-8">
                <title>Panel ASAMI</title>
                <meta name="viewport" content="width=device-width, initial-scale=1" />
        </head>
        <body>
            <div id="asami-gate" style="max-width:420px;margin:2rem auto;font-family:system-ui,Segoe UI,Roboto,Arial,sans-serif">
                <h2 style="margin:0 0 .75rem">Panel ASAMI</h2>
                <p style="margin:.25rem 0 1rem;color:#555">Podaj login i hasło, aby wejść.</p>

                <form id="gate-form" style="display:grid;gap:.5rem">
                    <label>
                        <span style="display:block;font-size:.9rem;color:#333;margin-bottom:.25rem">Login</span>
                        <input id="gate-user" type="text" autocomplete="username" inputmode="text"
                            style="width:100%;padding:.6rem .7rem;border:1px solid #ccc;border-radius:.5rem" required>
                    </label>
                    <label>
                        <span style="display:block;font-size:.9rem;color:#333;margin-bottom:.25rem">Hasło</span>
                        <input id="gate-pass" type="password" autocomplete="current-password"
                            style="width:100%;padding:.6rem .7rem;border:1px solid #ccc;border-radius:.5rem" required>
                    </label>
                    <button type="submit"
                        style="padding:.7rem 1rem;border:none;border-radius:.5rem;background:#111;color:#fff;cursor:pointer">
                        Zaloguj
                    </button>
                    <div id="gate-msg" style="min-height:1.25rem;color:#b00020;font-size:.9rem"></div>
                </form>

                
                <div id="gate-content" style="display:none;margin-top:1.25rem;padding:1rem;border:1px solid #e5e5e5;border-radius:.5rem;background:#fafafa">
                    <h3 style="margin:.25rem 0 0.5rem">Witaj w Strefie Zespołu</h3>
                    <p style="margin:.25rem 0 .75rem;color:#444">Poniżej szybkie linki oraz pobieranie pliku do kasy.</p>

                    <style>
                        #gate-content .quick-links {
                            display: flex; flex-wrap: wrap; gap: .6rem; margin-top: .25rem;
      }
                        #gate-content .btn {
                            display: inline-flex; align-items: center; justify-content: center; gap: .5rem;
                        padding: .9rem 1rem; min-height: 44px; border: 1px solid #e2e2e2; border-radius: .7rem;
                        background: #fff; box-shadow: 0 1px 2px rgba(0,0,0,.06); text-decoration: none;
                        font-size: 16px; color: #111; transition: transform .04s ease, box-shadow .2s ease, background .2s ease;
                        -webkit-tap-highlight-color: transparent; cursor: pointer;
      }
                        #gate-content .btn:hover, #gate-content .btn:focus-visible {
                            background: #f6f6f6; box-shadow: 0 2px 6px rgba(0,0,0,.08); outline: none;
      }
                        #gate-content .btn:active {transform: translateY(1px); }
                        #gate-content .btn .ico {font - size: 1.1em; line-height: 1; }
                        @media (max-width: 380px) {#gate - content.btn {flex: 1 1 100%; } }
                    </style>

                    <div class="quick-links">
                        <a class="btn" href="https://docs.google.com/forms/d/e/1FAIpQLSeOE2KllXiVXFn-TGFPKqQYFZZWbJDkLy0vvdn8M5umKTT4Yg/viewform?usp=dialog" target="_blank" rel="noopener" aria-label="Raport dzienny formularz">
                            <span class="ico">📝</span> Raport dzienny (formularz)
                        </a>

                        <a class="btn" href="https://docs.google.com/spreadsheets/d/1USsI1QJfThz4IZzi_qSPMKNMLSXmM5Dd43GbCJXGUk8/preview" target="_blank" rel="noopener" aria-label="Kody do kas fiskalnych tylko odczyt">
                            <span class="ico">🔐</span> Kody do kas (tylko odczyt)
                        </a>

                        <a class="btn" href="https://docs.google.com/spreadsheets/d/1USsI1QJfThz4IZzi_qSPMKNMLSXmM5Dd43GbCJXGUk8" target="_blank" rel="noopener" aria-label="Kody do kas fiskalnych edycja">
                            <span class="ico">✏️</span> Kody do kas (edycja)
                        </a>

                        
                        <button id="btn-csv" class="btn" type="button" aria-label="Pobierz plik CSV do kasy">
                            <span class="ico">⬇️</span> Pobierz plik do kasy (CSV)
                        </button>
                    </div>

                    <div id="csv-msg" style="margin-top:.75rem;color:#b00020;font-size:.9rem"></div>
                </div>
            </div>

            <script>
(async () => {
  // ====== PROSTA BRAMKA (hash login:hasło) ======
  // SHA-256("Kosmetologia:stroze81") w hex:
  const EXPECTED_HEX = "bff7b1c3fdc1365c99bf9cda1a0fb321fc1aa4169f66f80638f5fb35f992932f";

  const toHex = buf => [...new Uint8Array(buf)].map(b => b.toString(16).padStart(2, "0")).join("");
                async function sha256Hex(text) {
    const enc = new TextEncoder().encode(text);
                const digest = await crypto.subtle.digest("SHA-256", enc);
                return toHex(digest);
  }

                const form = document.getElementById("gate-form");
                const user = document.getElementById("gate-user");
                const pass = document.getElementById("gate-pass");
                const msg  = document.getElementById("gate-msg");
                const content = document.getElementById("gate-content");

  form.addEventListener("submit", async (e) => {
                    e.preventDefault();
                msg.textContent = "";
                try {
      const hex = await sha256Hex(`${user.value}:${pass.value}`);
                if (hex === EXPECTED_HEX) {
                    form.style.display = "none";
                content.style.display = "block";
                user.value = ""; pass.value = "";
      } else {
                    msg.textContent = "Nieprawidłowy login lub hasło.";
      }
    } catch (err) {
                    console.error(err);
                msg.textContent = "Błąd przeglądarki podczas weryfikacji.";
    }
  });

                // ====== POBIERANIE I GENEROWANIE CSV DO KASY ======
                const SHEET_ID = "1USsI1QJfThz4IZzi_qSPMKNMLSXmM5Dd43GbCJXGUk8"; // Twój arkusz (publiczny - tylko odczyt)
                const GID = "0"; // <- jeśli to nie ta zakładka, podmień na właściwy gid
                const SHEETS_EXPORT_URL = `https://docs.google.com/spreadsheets/d/${SHEET_ID}/export?format=csv&gid=${GID}`;

                const csvBtn = document.getElementById("btn-csv");
                const csvMsg = document.getElementById("csv-msg");

                // Minimalny parser CSV (obsługuje cudzysłowy i przecinki/średniki)
                function parseCSV(text) {
    const rows = [];
                let cur = "", row = [], inQ = false;
                for (let i = 0; i < text.length; i++) {
      const ch = text[i];
                if (inQ) {
        if (ch === '"') {
          if (text[i+1] === '"') {cur += '"'; i++; } // escapowane "
                else {inQ = false; }
        } else {
                    cur += ch;
        }
      } else {
        if (ch === '"') {inQ = true; }
                else if (ch === ',' || ch === ';') {row.push(cur); cur = ""; }
                else if (ch === '\r') { /* pomiń */}
                else if (ch === '\n') {row.push(cur); rows.push(row); row = []; cur = ""; }
                else {cur += ch; }
      }
    }
                if (cur.length || row.length) {row.push(cur); rows.push(row); }
                return rows;
  }

                // Usuwa polskie znaki + znaki problematyczne dla kasy/sqlite (tylko dla nazwy / VAT)
                function sanitizeText(s) {
    if (s == null) return "";
                let out = String(s).normalize("NFD").replace(/[\u0300-\u036f]/g, "");
                out = out
                .replace(/[(),;"']/g, " ")
                .replace(/[\/\\]/g, " ")
                .replace(/%/g, " procent")
                .replace(/:\s*/g, " ")
                .replace(/\s+/g, " ")
                .trim();
                return out;
  }

                // Konwersja tablicy → CSV ze średnikiem
                function toSemicolonCSV(rows) {
    return rows.map(r =>
      r.map(cell => {
        const s = String(cell ?? "");
                return s.replace(/;/g, " ");
      }).join(";")
                ).join("\n");
  }

                // Heurystyka: znajdź indeksy kolumn po nagłówkach (luźne dopasowanie)
                function findColumns(header) {
    const head = header.map(h => sanitizeText(h).toLowerCase());
                const idx = {
                    kod: head.findIndex(h => /(kod|id)/.test(h)),
      nazwa: head.findIndex(h => /(nazwa|uslugi|produkt)/.test(h)),
      vat: head.findIndex(h => /\b(vat|stawka|ptu)\b/.test(h)),
      cena: head.findIndex(h => /(cena|brutto|kwota|price)/.test(h)),
      prec: head.findIndex(h => /(prec|precyz)/.test(h)),   // <--- NOWE: PRECYZJA
    };
                return idx;
  }

                async function buildAndDownloadCSV() {
                    csvMsg.textContent = "";
                try {
      const res = await fetch(SHEETS_EXPORT_URL, {cache: "no-store" });
                if (!res.ok) throw new Error("Nie można pobrać danych arkusza.");
                const raw = await res.text();

      const rows = parseCSV(raw).filter(r => r.some(c => (c ?? "").toString().trim().length));
                if (!rows.length) throw new Error("Arkusz jest pusty.");

                const header = rows[0];
                const data = rows.slice(1);

                const {kod, nazwa, vat, cena, prec} = findColumns(header);

      const iKod  = (kod  >= 0) ? kod  : 0;
      const iNaz  = (nazwa>= 0) ? nazwa: 1;
      const iVat  = (vat  >= 0) ? vat  : 2;
      const iCena = (cena >= 0) ? cena : 3;
      const iPrec = (prec >= 0) ? prec : 4; // zakładamy, że Precyzja jest 5. kolumną jeśli nie wykryje inaczej

                const out = [];
                // DODANE Precyzja w nagłówku
                out.push(["Kod", "Nazwa", "VAT", "Cena", "Precyzja"]);

                for (const r of data) {
        const codeRaw = (r[iKod] ?? "").toString().trim();
                if (!codeRaw || isNaN(Number(codeRaw))) continue;

                const nameRaw = r[iNaz] ?? "";
                const vatRaw  = (r[iVat] ?? "").toString().trim();
                const priceRaw = (r[iCena] ?? "").toString().trim();
                const precRaw  = r[iPrec] ?? "";

                const safeName = sanitizeText(nameRaw);
                const safeVat  = sanitizeText(vatRaw).toUpperCase().replace(/\b(23|A)\b.*/,"A").replace(/\b(8|B)\b.*/,"B");
                const safePrice = (priceRaw || "0").replace(/\s/g,"").replace(",", ".").replace(/[^0-9.]/g,"");

                // PRECYZJA: tylko trim + jeśli puste, to 0 — nic więcej nie zmieniamy
                let safePrec = String(precRaw ?? "").trim();
                if (!safePrec) safePrec = "0";

                out.push([codeRaw, safeName, (safeVat === "B" ? "B" : "A"), safePrice, safePrec]);
      }

                const finalCSV = toSemicolonCSV(out);
                const blob = new Blob([finalCSV], {type: "text/csv;charset=utf-8" });
                const url = URL.createObjectURL(blob);

                const a = Object.assign(document.createElement("a"), {href: url, download: "kasa_asami.csv" });
                document.body.appendChild(a);
                a.click();
                URL.revokeObjectURL(url);
                a.remove();

    } catch (err) {
                    console.error(err);
                csvMsg.textContent = "Nie udało się wygenerować pliku CSV: " + err.message;
    }
  }

                csvBtn?.addEventListener("click", buildAndDownloadCSV);
})();
            </script>
        </body>
    </html>