/* ── Reset & base ─────────────────────────────────────────── */
*, *::before, *::after { box-sizing: border-box; margin: 0; padding: 0; }

:root {
  --blue:        #2E75B6;
  --blue-dark:   #1a5a96;
  --blue-xdark:  #0f3d6e;
  --green:       #217346;
  --green-dark:  #185c38;
  --row-alt:     #EBF3FB;
  --row-hover:   #d0e6f7;
  --header-bg:   #1f3a5f;
  --border:      #d0d7de;
  --text:        #1a1a2e;
  --text-muted:  #666;
  --bg-app:      #f0f2f5;
  --bg-ctrl:     #ffffff;
  --rn-bg:       #f5f5f5;
  --foot-bg:     #FFF9C4;
  --foot-rn:     #f0ead6;
  --radius:      6px;
  --shadow-sm:   0 1px 4px rgba(0,0,0,.10);
  --shadow-md:   0 2px 10px rgba(0,0,0,.14);
}

body {
  font-family: 'Segoe UI', system-ui, -apple-system, sans-serif;
  background: var(--bg-app);
  color: var(--text);
  height: 100vh;
  overflow: hidden;
}

.app {
  display: flex;
  flex-direction: column;
  height: 100vh;
}

.hidden { display: none !important; }

/* ── Header ───────────────────────────────────────────────── */
.app-header {
  background: var(--header-bg);
  color: #fff;
  padding: 0 20px;
  height: 50px;
  display: flex;
  align-items: center;
  justify-content: space-between;
  flex-shrink: 0;
  box-shadow: var(--shadow-md);
  z-index: 100;
}

.header-brand {
  display: flex;
  align-items: center;
  gap: 10px;
}

.header-brand svg { opacity: .9; }

.header-brand h1 {
  font-size: 15px;
  font-weight: 600;
  letter-spacing: .2px;
}

.version-badge {
  background: rgba(255,255,255,.15);
  padding: 2px 9px;
  border-radius: 12px;
  font-size: 11px;
  letter-spacing: .5px;
}

/* ── Controls panel ───────────────────────────────────────── */
.controls {
  background: var(--bg-ctrl);
  padding: 10px 20px;
  border-bottom: 1px solid var(--border);
  flex-shrink: 0;
  box-shadow: var(--shadow-sm);
}

.ctrl-row {
  display: flex;
  align-items: flex-end;
  gap: 10px;
  flex-wrap: wrap;
}

.ctrl-row + .ctrl-row { margin-top: 8px; }

/* Fields */
.field {
  display: flex;
  flex-direction: column;
  gap: 3px;
}

.field label {
  font-size: 10.5px;
  font-weight: 700;
  color: var(--text-muted);
  text-transform: uppercase;
  letter-spacing: .6px;
}

.field input,
.field select {
  border: 1px solid var(--border);
  border-radius: var(--radius);
  padding: 7px 10px;
  font-size: 13px;
  color: var(--text);
  background: #fff;
  outline: none;
  transition: border-color .15s, box-shadow .15s;
  height: 34px;
}

.field input:focus,
.field select:focus {
  border-color: var(--blue);
  box-shadow: 0 0 0 3px rgba(46,117,182,.12);
}

input[type="datetime-local"] { min-width: 195px; }
input[type="number"]         { width: 120px; }

/* Separator */
.separator {
  width: 1px;
  height: 28px;
  background: var(--border);
  margin: 0 4px;
  align-self: flex-end;
  margin-bottom: 3px;
}

/* ── Buttons ──────────────────────────────────────────────── */
.btn {
  display: inline-flex;
  align-items: center;
  gap: 6px;
  padding: 0 14px;
  height: 34px;
  border-radius: var(--radius);
  font-size: 13px;
  font-weight: 500;
  cursor: pointer;
  border: 1px solid transparent;
  transition: background .14s, border-color .14s, opacity .14s;
  white-space: nowrap;
  outline: none;
}

.btn:active { transform: translateY(1px); }
.btn:disabled { opacity: .38; cursor: not-allowed; pointer-events: none; }

.btn.primary        { background: var(--blue);  color: #fff; }
.btn.primary:hover  { background: var(--blue-dark); }

.btn.success        { background: var(--green); color: #fff; }
.btn.success:hover  { background: var(--green-dark); }

.btn.outline-green  { background: #fff; color: var(--green); border-color: var(--green); }
.btn.outline-green:hover { background: #f0f9f4; }

.btn.ghost          { background: transparent; color: var(--text-muted); border-color: var(--border); }
.btn.ghost:hover    { background: #f5f5f5; }

.btn.master         { background: #e67e22; color: #fff; border-color: #ca6f1e; }
.btn.master:hover   { background: #ca6f1e; }

.dl-group { display: flex; gap: 6px; }

/* ── Search row ───────────────────────────────────────────── */
.search-row { margin-top: 4px; }

.search-wrap {
  position: relative;
  display: flex;
  align-items: center;
}

.search-icon {
  position: absolute;
  left: 10px;
  color: var(--text-muted);
  pointer-events: none;
}

#searchBox {
  border: 1px solid var(--border);
  border-radius: var(--radius);
  padding: 6px 10px 6px 32px;
  font-size: 13px;
  width: 280px;
  height: 34px;
  outline: none;
  transition: border-color .15s, box-shadow .15s;
}

#searchBox:focus {
  border-color: var(--blue);
  box-shadow: 0 0 0 3px rgba(46,117,182,.12);
}

/* ── Stats bar ────────────────────────────────────────────── */
.stats-bar {
  display: flex;
  align-items: center;
  gap: 0;
  padding: 6px 20px;
  background: #fafbfc;
  border-bottom: 1px solid var(--border);
  flex-shrink: 0;
  font-size: 12.5px;
}

.stat {
  display: flex;
  align-items: center;
  gap: 6px;
  padding: 0 14px;
}

.stat:first-child { padding-left: 0; }

.stat-lbl { color: var(--text-muted); }

.stat-val {
  font-weight: 700;
  color: var(--text);
  font-variant-numeric: tabular-nums;
}

.stat-val.green { color: var(--green); }

.stat-div {
  width: 1px;
  height: 18px;
  background: var(--border);
}

/* ── Loading / Error / Empty ──────────────────────────────── */
.state-box {
  flex: 1;
  display: flex;
  flex-direction: column;
  align-items: center;
  justify-content: center;
  gap: 14px;
  color: var(--text-muted);
  font-size: 14px;
}

.state-box.error { color: #c0392b; }
.state-box.error svg { stroke: #c0392b; }

/* Spinner */
.spinner {
  width: 34px;
  height: 34px;
  border: 3px solid #e0e4e8;
  border-top-color: var(--blue);
  border-radius: 50%;
  animation: spin .75s linear infinite;
}

@keyframes spin { to { transform: rotate(360deg); } }

/* ── Spreadsheet ──────────────────────────────────────────── */
.table-wrap {
  flex: 1;
  overflow: auto;
  background: #fff;
}

#sheet {
  border-collapse: collapse;
  font-family: Calibri, 'Segoe UI', Arial, sans-serif;
  font-size: 13px;
  width: max-content;
  min-width: 100%;
}

/* Header row */
#sheet thead th {
  background: var(--blue);
  color: #fff;
  font-weight: 700;
  padding: 7px 12px;
  border: 1px solid var(--blue-dark);
  position: sticky;
  top: 0;
  z-index: 30;
  white-space: nowrap;
  cursor: pointer;
  user-select: none;
  text-align: center;
  transition: background .12s;
}

#sheet thead th:hover       { background: var(--blue-dark); }
#sheet thead th.rn-col      { background: #3d6d9e; cursor: default; min-width: 46px; }
#sheet thead th.rn-col:hover{ background: #3d6d9e; }

/* Sort indicators */
#sheet thead th.sort-asc::after  { content: ' ↑'; font-size: 10px; opacity: .85; }
#sheet thead th.sort-desc::after { content: ' ↓'; font-size: 10px; opacity: .85; }

/* Data rows */
#sheet tbody td {
  padding: 5px 12px;
  border: 1px solid var(--border);
  white-space: nowrap;
  max-width: 220px;
  overflow: hidden;
  text-overflow: ellipsis;
  text-align: center;
}

#sheet tbody tr:nth-child(even) td { background: var(--row-alt); }
#sheet tbody tr:hover td           { background: var(--row-hover) !important; }

/* Row-number cell */
#sheet td.rn {
  background: var(--rn-bg) !important;
  color: #999;
  text-align: right;
  font-size: 11px;
  padding: 5px 8px;
  min-width: 46px;
  border-color: #ddd;
}

#sheet tbody tr:hover td.rn { background: #e6e6e6 !important; }

/* Column alignment helpers */
td.align-right, th.align-right { text-align: right; }
td.align-center                { text-align: center; }
td.col-amount  { color: #155a2b; font-weight: 500; text-align: right; }
td.col-multiline {
  white-space: normal;
  max-width: 280px;
  vertical-align: top;
  line-height: 1.6;
  text-align: left;
}
td.col-date, th.col-date {
  width: 88px;
  min-width: 88px;
  max-width: 88px;
}
td.col-time, th.col-time {
  width: 52px;
  min-width: 52px;
  max-width: 52px;
}
td.col-orderid, th.col-orderid {
  width: 72px;
  min-width: 72px;
  max-width: 72px;
}
td.col-advance, th.col-advance {
  width: 80px;
  min-width: 80px;
  max-width: 80px;
}
td.col-payment, th.col-payment {
  width: 110px;
  min-width: 110px;
  max-width: 110px;
}
td.col-contact, th.col-contact {
  width: 110px;
  min-width: 110px;
  max-width: 110px;
}

/* Footer / Total row */
#sheet tfoot td {
  background: var(--foot-bg);
  font-weight: 700;
  font-size: 12.5px;
  border: 1px solid #e0d890;
  padding: 6px 12px;
  position: sticky;
  bottom: 0;
  z-index: 20;
}

#sheet tfoot td.rn      { background: var(--foot-rn); color: #888; text-align: right; }
#sheet tfoot td.foot-lbl{ text-align: right; color: #555; font-weight: 600; }
#sheet tfoot td.foot-amt{ text-align: right; color: #155a2b; }

/* ── Login overlay ─────────────────────────────────────────── */
.login-overlay {
  position: fixed;
  inset: 0;
  background: #f0f2f5;
  display: flex;
  align-items: center;
  justify-content: center;
  z-index: 1000;
}
.login-overlay.hidden { display: none; }

.login-card {
  background: #fff;
  border-radius: 10px;
  box-shadow: 0 4px 24px rgba(0,0,0,.13);
  padding: 40px 36px 32px;
  width: 100%;
  max-width: 360px;
  text-align: center;
}
.login-logo {
  color: var(--blue);
  margin-bottom: 14px;
}
.login-title {
  font-size: 20px;
  font-weight: 700;
  color: var(--text);
  margin-bottom: 4px;
}
.login-sub {
  font-size: 13px;
  color: var(--text-muted);
  margin-bottom: 24px;
}
.login-field {
  text-align: left;
  margin-bottom: 14px;
}
.login-field label {
  display: block;
  font-size: 12px;
  font-weight: 600;
  color: var(--text-muted);
  margin-bottom: 5px;
  text-transform: uppercase;
  letter-spacing: .04em;
}
.login-field input {
  width: 100%;
  padding: 9px 12px;
  border: 1px solid var(--border);
  border-radius: var(--radius);
  font-size: 14px;
  outline: none;
  transition: border-color .15s;
}
.login-field input:focus { border-color: var(--blue); }
.login-error {
  font-size: 13px;
  color: #c0392b;
  margin-bottom: 10px;
}
.login-btn {
  width: 100%;
  padding: 10px;
  font-size: 14px;
  margin-top: 4px;
}
.logout-btn {
  margin-left: auto;
  font-size: 12px;
  padding: 4px 12px;
}

/* ── Toast notification ─────────────────────────────────────── */
#toast {
  position: fixed;
  top: 20px;
  right: 20px;
  z-index: 9999;
  padding: 12px 18px;
  border-radius: 8px;
  font-size: 14px;
  font-weight: 600;
  color: #fff;
  box-shadow: 0 4px 16px rgba(0,0,0,.2);
  opacity: 0;
  transform: translateY(-10px);
  transition: opacity .25s, transform .25s;
  pointer-events: none;
}
#toast.show {
  opacity: 1;
  transform: translateY(0);
}
#toast.success { background: #217346; }
#toast.error   { background: #c0392b; }

/* ── Mobile — controls stay fixed, table scrolls independently ── */
@media (max-width: 900px) {
  body {
    height: auto;
    overflow-x: hidden;  /* page never scrolls left/right */
    overflow-y: auto;
  }
  .app {
    height: auto;
    min-height: 100vh;
  }
  .controls, .stats-bar {
    max-width: 100vw;
    overflow: hidden;
  }
  .table-wrap {
    overflow-x: auto;           /* table scrolls left/right */
    overflow-y: visible;        /* vertical handled by the page */
    -webkit-overflow-scrolling: touch;
    flex: none;
  }
}