/* Google Sheets Inspired Professional Theme */
:root {
  --gs-green: #0f9d58;
  --gs-green-hover: #0b8043;
  --gs-green-light: #e6f4ea;
  --gs-blue: #1a73e8;
  --gs-blue-hover: #1557b0;
  --gs-blue-light: #e8f0fe;
  --gs-bg: #f8f9fa;
  --gs-card-bg: #ffffff;
  --gs-border: #dadce0;
  --gs-border-subtle: #e8eaed;
  --gs-text: #202124;
  --gs-text-muted: #5f6368;
  --gs-cell-hover: #f1f3f4;
  --radius: 6px;
}

* {
  box-sizing: border-box;
  margin: 0;
  padding: 0;
  -webkit-tap-highlight-color: transparent;
  font-family: Roboto, -apple-system, BlinkMacSystemFont, "Segoe UI", Arial, sans-serif;
}

body {
  background-color: var(--gs-bg);
  color: var(--gs-text);
  padding: 0;
  margin: 0;
  min-height: 100vh;
  padding-bottom: 75px;
}

/* Google Sheets Top Menu Bar */
.gs-header {
  background: #ffffff;
  border-bottom: 1px solid var(--gs-border);
  padding: 8px 16px;
  display: flex;
  justify-content: space-between;
  align-items: center;
  position: sticky;
  top: 0;
  z-index: 1000;
  box-shadow: 0 1px 2px rgba(60,64,67,0.08);
}

.gs-brand {
  display: flex;
  align-items: center;
  gap: 12px;
}

.gs-icon {
  width: 32px;
  height: 32px;
  background: var(--gs-green);
  border-radius: 4px;
  display: flex;
  align-items: center;
  justify-content: center;
  color: white;
  font-weight: bold;
  font-size: 18px;
  box-shadow: 0 1px 2px rgba(0,0,0,0.15);
}

.gs-title-area {
  display: flex;
  flex-direction: column;
}

.gs-doc-title {
  font-size: 1.05rem;
  font-weight: 500;
  color: var(--gs-text);
  line-height: 1.2;
}

.gs-doc-subtitle {
  font-size: 0.72rem;
  color: var(--gs-text-muted);
  display: flex;
  align-items: center;
  gap: 6px;
  cursor: pointer;
  user-select: none;
  transition: opacity 0.2s ease;
}

.gs-doc-subtitle:hover {
  opacity: 0.85;
}

.gs-header-actions {
  display: flex;
  align-items: center;
  gap: 8px;
}

/* User & Center Ribbon */
.gs-ribbon {
  background: #ffffff;
  border-bottom: 1px solid var(--gs-border-subtle);
  padding: 6px 16px;
  display: flex;
  justify-content: space-between;
  align-items: center;
  font-size: 0.8rem;
  color: var(--gs-text-muted);
}

.gs-user-badge {
  display: inline-flex;
  align-items: center;
  gap: 6px;
  color: var(--gs-text);
  font-weight: 500;
}

.gs-center-tag {
  background: var(--gs-green-light);
  color: var(--gs-green);
  font-weight: 700;
  font-size: 0.7rem;
  padding: 2px 8px;
  border-radius: 4px;
  border: 1px solid #ceead6;
}

.gs-role-badge {
  font-size: 0.7rem;
  font-weight: 700;
  padding: 2px 8px;
  border-radius: 12px;
  color: #ffffff;
  display: inline-block;
}
.role-super_admin { background: #6366f1; }
.role-rcsm { background: #0284c7; }
.role-acso { background: #059669; }
.role-field_technician { background: #64748b; }

.rcsm-banner {
  background: #eff6ff;
  border: 1.5px solid #93c5fd;
  border-radius: 8px;
  padding: 12px 16px;
  margin-bottom: 14px;
  color: #1e40af;
  font-size: 0.85rem;
  line-height: 1.4;
}

.btn-link {
  background: none;
  border: none;
  color: var(--gs-blue);
  font-size: 0.75rem;
  font-weight: 500;
  cursor: pointer;
  text-decoration: underline;
}

/* Main Container */
.main-content {
  max-width: 900px;
  margin: 0 auto;
  padding: 12px;
}

/* Google Sheets Card Container */
.gs-card {
  background: #ffffff;
  border: 1px solid var(--gs-border);
  border-radius: var(--radius);
  margin-bottom: 16px;
  box-shadow: 0 1px 2px rgba(60,64,67,0.05);
  overflow: hidden;
}

.gs-card-header {
  background: #f8f9fa;
  border-bottom: 1px solid var(--gs-border);
  padding: 10px 14px;
  display: flex;
  justify-content: space-between;
  align-items: center;
  font-size: 0.85rem;
  font-weight: 600;
  color: #3c4043;
}

.gs-card-body {
  padding: 14px;
}

/* Google Sheets Formula Bar (fx) */
.gs-formula-bar {
  background: #ffffff;
  border: 1px solid var(--gs-border);
  border-radius: 4px;
  padding: 8px 12px;
  display: flex;
  align-items: center;
  gap: 10px;
  margin-bottom: 14px;
  font-size: 0.85rem;
}

.gs-fx {
  font-family: "Courier New", monospace;
  font-style: italic;
  font-weight: bold;
  color: var(--gs-text-muted);
  font-size: 0.95rem;
}

.gs-formula-val {
  font-family: monospace;
  font-weight: 700;
  color: var(--gs-blue);
  font-size: 1rem;
  letter-spacing: 0.5px;
}

/* Grid Entry Form (Spreadsheet cells) */
.gs-grid {
  display: grid;
  grid-template-columns: repeat(2, 1fr);
  gap: 10px;
}

.col-full {
  grid-column: span 2;
}

.gs-cell-group {
  display: flex;
  flex-direction: column;
  gap: 4px;
}

.gs-cell-label {
  font-size: 0.82rem;
  font-weight: 800;
  color: #374151;
  text-transform: uppercase;
  letter-spacing: 0.4px;
}

.gs-input, .gs-select {
  background: #ffffff;
  border: 1px solid #c4c7c5;
  border-radius: 4px;
  padding: 9px 10px;
  font-size: 0.9rem;
  color: var(--gs-text);
  outline: none;
  transition: border-color 0.15s, box-shadow 0.15s;
  width: 100%;
}

.gs-input:focus, .gs-select:focus {
  border-color: var(--gs-green);
  box-shadow: 0 0 0 2px rgba(15, 157, 88, 0.2);
}

.gs-select:disabled {
  background: #f1f3f4;
  color: #5f6368;
  cursor: not-allowed;
}

/* GPS Row in Sheet */
.gs-gps-bar {
  display: flex;
  gap: 8px;
  align-items: center;
  margin-top: 4px;
}

.btn-gps-sheet {
  background: var(--gs-green);
  color: white;
  border: none;
  border-radius: 4px;
  padding: 8px 12px;
  font-size: 0.8rem;
  font-weight: 600;
  cursor: pointer;
  display: inline-flex;
  align-items: center;
  gap: 5px;
  white-space: nowrap;
}

.btn-gps-sheet:hover {
  background: var(--gs-green-hover);
}

.btn-map-toggle {
  background: #ffffff;
  color: #0284c7;
  border: 1px solid #cbd5e1;
  border-radius: 4px;
  padding: 8px 12px;
  font-size: 0.8rem;
  font-weight: 600;
  cursor: pointer;
  white-space: nowrap;
  display: inline-flex;
  align-items: center;
  gap: 5px;
  box-shadow: 0 1px 2px rgba(0,0,0,0.05);
}

.btn-map-toggle:hover {
  background: #f8fafc;
  border-color: #94a3b8;
}

#map-container {
  height: 350px;
  width: 100%;
  border-radius: 8px;
  display: block;
  border: 2px solid #cbd5e1;
  box-shadow: 0 4px 6px -1px rgba(0, 0, 0, 0.1);
  position: relative;
  overflow: hidden;
}

.map-floating-bar {
  position: absolute;
  bottom: 8px;
  left: 50%;
  transform: translateX(-50%);
  background: rgba(15, 23, 42, 0.85);
  backdrop-filter: blur(4px);
  padding: 5px 14px;
  border-radius: 20px;
  font-size: 0.75rem;
  font-weight: 600;
  color: #ffffff;
  box-shadow: 0 2px 8px rgba(0,0,0,0.25);
  z-index: 1000;
  pointer-events: none;
  white-space: nowrap;
  max-width: 90%;
  text-align: center;
}

.btn-map-my-location {
  position: absolute;
  bottom: 42px;
  right: 12px;
  background: #ffffff;
  color: #1a73e8;
  border: 1px solid #cbd5e1;
  border-radius: 50%;
  width: 44px;
  height: 44px;
  font-size: 1.3rem;
  box-shadow: 0 3px 8px rgba(0,0,0,0.3);
  cursor: pointer;
  z-index: 1000;
  display: flex;
  align-items: center;
  justify-content: center;
  transition: transform 0.15s, background-color 0.15s;
}

.btn-map-my-location:active {
  transform: scale(0.92);
  background: #f1f5f9;
}

/* Customer Counter */
.gs-counter {
  display: flex;
  align-items: center;
  gap: 4px;
}

.gs-counter-btn {
  background: #f1f3f4;
  border: 1px solid #c4c7c5;
  border-radius: 4px;
  width: 36px;
  height: 36px;
  font-size: 1.1rem;
  font-weight: bold;
  cursor: pointer;
  color: var(--gs-text);
}

.gs-counter-btn:active {
  background: #e0e0e0;
}

/* Add Row Button */
.btn-add-row {
  background: var(--gs-green);
  color: white;
  border: none;
  border-radius: 4px;
  padding: 12px 18px;
  font-size: 0.95rem;
  font-weight: 600;
  width: 100%;
  cursor: pointer;
  display: flex;
  align-items: center;
  justify-content: center;
  gap: 8px;
  box-shadow: 0 1px 3px rgba(0,0,0,0.12);
  margin-top: 14px;
}

.btn-add-row:hover {
  background: var(--gs-green-hover);
}

.btn-add-row:active {
  transform: translateY(1px);
}

/* =======================================
   LIVE SPREADSHEET TABLE (GOOGLE SHEETS)
   ======================================= */
.gs-sheet-table-wrapper {
  overflow-x: auto;
  overflow-y: auto;
  max-height: 400px;
  border: 1px solid var(--gs-border);
  background: #ffffff;
  -webkit-overflow-scrolling: touch;
}

/* Up/Down and Left/Right Scrollbars */
.gs-sheet-table-wrapper::-webkit-scrollbar {
  width: 8px;
  height: 8px;
}
.gs-sheet-table-wrapper::-webkit-scrollbar-track {
  background: #f1f3f4;
}
.gs-sheet-table-wrapper::-webkit-scrollbar-thumb {
  background: #c4c7c5;
  border-radius: 4px;
}
.gs-sheet-table-wrapper::-webkit-scrollbar-thumb:hover {
  background: #9aa0a6;
}

.gs-sheet-table {
  width: 100%;
  border-collapse: collapse;
  font-size: 0.8rem;
  white-space: nowrap;
  color: var(--gs-text);
}

.gs-sheet-table th {
  background: #f8f9fa;
  color: #1e293b;
  font-size: 0.88rem;
  font-weight: 700;
  padding: 8px 10px;
  border: 1px solid var(--gs-border);
  text-align: left;
  position: sticky;
  top: 0;
  z-index: 10;
}

.gs-sheet-table td {
  padding: 7px 10px;
  border: 1px solid var(--gs-border-subtle);
  background: #ffffff;
}

.gs-sheet-table tr:hover td {
  background: var(--gs-cell-hover);
}

.gs-row-num {
  background: #f8f9fa !important;
  color: #80868b;
  font-weight: 500;
  text-align: center;
  width: 32px;
  border-right: 1px solid var(--gs-border) !important;
}

.gs-id-cell {
  font-family: monospace;
  font-weight: 700;
  color: var(--gs-blue);
}

.gs-tag-synced {
  color: var(--gs-green);
  font-weight: 600;
  font-size: 0.72rem;
}

.gs-tag-pending {
  color: #ea8600;
  font-weight: 600;
  font-size: 0.72rem;
}

.btn-del-cell {
  background: none;
  border: none;
  color: #d93025;
  cursor: pointer;
  font-size: 0.9rem;
  padding: 2px 6px;
  border-radius: 4px;
}

.btn-del-cell:hover {
  background: #fce8e6;
}

/* Bottom Floating Toolbar */
.gs-bottom-bar {
  position: fixed;
  bottom: 0;
  left: 0;
  right: 0;
  background: #ffffff;
  border-top: 1px solid var(--gs-border);
  padding: 8px 16px;
  display: flex;
  gap: 8px;
  z-index: 1000;
  max-width: 900px;
  margin: 0 auto;
  box-shadow: 0 -2px 6px rgba(60,64,67,0.08);
}

.btn-gs-action {
  flex: 1;
  padding: 10px 8px;
  border: 1px solid var(--gs-border);
  border-radius: 4px;
  font-size: 0.8rem;
  font-weight: 600;
  cursor: pointer;
  display: flex;
  align-items: center;
  justify-content: center;
  gap: 6px;
  background: #ffffff;
  color: var(--gs-text);
}

.btn-gs-excel {
  background: #107c41;
  color: white;
  border-color: #107c41;
}

.btn-gs-excel:hover {
  background: #0d6334;
}

.btn-gs-sync {
  background: var(--gs-blue);
  color: white;
  border-color: var(--gs-blue);
}

.btn-gs-sync:hover {
  background: var(--gs-blue-hover);
}

/* Toast */
.toast {
  position: fixed;
  top: 60px;
  left: 50%;
  transform: translateX(-50%);
  background: #323232;
  color: white;
  padding: 9px 18px;
  border-radius: 4px;
  font-size: 0.85rem;
  font-weight: 500;
  box-shadow: 0 3px 8px rgba(0,0,0,0.25);
  z-index: 6000;
  display: none;
}

/* Login Overlay */
.login-overlay {
  position: fixed;
  inset: 0;
  background: rgba(32, 33, 36, 0.6);
  backdrop-filter: blur(4px);
  z-index: 99999;
  display: flex;
  align-items: center;
  justify-content: center;
  padding: 16px;
}

.login-card {
  background: #ffffff;
  border: 1px solid var(--gs-border);
  border-radius: 8px;
  padding: 24px;
  width: 100%;
  max-width: 380px;
  box-shadow: 0 4px 16px rgba(0,0,0,0.15);
}

.btn-demo {
  flex: 1;
  background: #f8f9fa;
  border: 1px solid var(--gs-border);
  color: var(--gs-blue);
  padding: 8px 4px;
  border-radius: 4px;
  font-size: 0.75rem;
  font-weight: 500;
  cursor: pointer;
}

.btn-demo:hover {
  background: #f1f3f4;
}

/* Port Multi-Select Checkbox Component */
.port-picker-trigger {
  display: flex;
  justify-content: space-between;
  align-items: center;
  cursor: pointer;
  text-align: left;
  min-height: 40px;
  user-select: none;
  background: #ffffff;
  border: 1px solid #c4c7c5;
  border-radius: 4px;
  padding: 8px 12px;
  transition: border-color 0.15s, box-shadow 0.15s;
}
.port-picker-trigger:hover {
  border-color: #0f9d58;
}
.port-picker-trigger:focus, .port-picker-trigger.active {
  border-color: #0f9d58;
  box-shadow: 0 0 0 2px rgba(15, 157, 88, 0.2);
}
.port-picker-placeholder {
  color: #5f6368;
  overflow: hidden;
  text-overflow: ellipsis;
  white-space: nowrap;
  font-size: 0.88rem;
}
.port-picker-selected {
  color: #0f172a;
  font-weight: 600;
  overflow: hidden;
  text-overflow: ellipsis;
  white-space: nowrap;
  font-size: 0.88rem;
}
.port-picker-arrow {
  font-size: 0.72rem;
  color: #64748b;
  margin-left: 8px;
  transition: transform 0.2s ease;
  flex-shrink: 0;
}
.port-picker-trigger.active .port-picker-arrow {
  transform: rotate(180deg);
}

.port-dropdown-panel {
  position: absolute;
  top: 100%;
  left: 0;
  right: 0;
  z-index: 2000;
  background: #ffffff;
  border: 1.5px solid #0f9d58;
  border-radius: 8px;
  padding: 10px 12px;
  margin-top: 4px;
  box-shadow: 0 10px 25px -5px rgba(0, 0, 0, 0.18), 0 8px 10px -6px rgba(0, 0, 0, 0.1);
  max-height: 280px;
  overflow-y: auto;
}

.port-dropdown-header {
  display: flex;
  justify-content: space-between;
  align-items: center;
  margin-bottom: 10px;
  padding-bottom: 8px;
  border-bottom: 1px solid #e2e8f0;
}

.btn-port-action {
  background: none;
  border: none;
  color: #0284c7;
  font-size: 0.78rem;
  font-weight: 700;
  cursor: pointer;
  padding: 2px 4px;
  border-radius: 3px;
}
.btn-port-action:hover {
  background: #f0f9ff;
  color: #0369a1;
}

.btn-port-done {
  background: #0f9d58;
  color: #ffffff;
  border: none;
  font-size: 0.75rem;
  font-weight: 700;
  border-radius: 4px;
  padding: 3px 10px;
  cursor: pointer;
  transition: background 0.15s;
}
.btn-port-done:hover {
  background: #0b8043;
}

.port-checkbox-grid {
  display: grid;
  grid-template-columns: repeat(4, 1fr);
  gap: 8px;
}
@media (min-width: 600px) {
  .port-checkbox-grid {
    grid-template-columns: repeat(8, 1fr);
  }
}

.port-checkbox-tile {
  display: flex;
  align-items: center;
  gap: 6px;
  padding: 7px 8px;
  background: #f8fafc;
  border: 1.5px solid #cbd5e1;
  border-radius: 6px;
  cursor: pointer;
  user-select: none;
  transition: all 0.15s ease;
  font-size: 0.85rem;
  font-weight: 500;
  color: #334155;
  box-sizing: border-box;
}
.port-checkbox-tile:hover {
  border-color: #0f9d58;
  background: #f0fdf4;
}
.port-checkbox-tile.checked {
  background: #e6f4ea;
  border-color: #0f9d58;
  color: #0b8043;
  font-weight: 700;
  box-shadow: 0 1px 2px rgba(15, 157, 88, 0.15);
}
.port-checkbox-tile input[type="checkbox"] {
  accent-color: #0f9d58;
  width: 16px;
  height: 16px;
  cursor: pointer;
  margin: 0;
  flex-shrink: 0;
}