// ==UserScript==
// @name Shopee Financial Tracker
// @namespace http://tampermonkey.net/
// @version 2.0
// @description Track and analyze your Shopee purchases with Comperhensive financial reporting
// @author Ryu-Sena (IndoTech Community) improvement Ui by pataanggs
// @match https://shopee.co.id/*
// @grant GM_addStyle
// @grant GM_xmlhttpRequest
// @connect shopee.co.id
// @license MIT
// ==/UserScript==
(function () {
'use strict';
// Configuration
const CONFIG = {
PAGE_LOAD_TIMEOUT: 18000,
BETWEEN_DELAY: 5000,
MAX_RETRIES: 5,
UI_TOGGLE_KEY: 'KeyM',
THEME_KEY: 'shopee_parser_theme',
CSV_DELIMITER: ';',
SORT_DIRECTIONS: {
ASC: 'asc',
DESC: 'desc'
},
FILTER_TYPES: {
CONTAINS: 'contains',
EQUALS: 'equals',
GREATER_THAN: 'greater_than',
LESS_THAN: 'less_than'
}
};
// Global State
let isParsing = false;
let currentEntry = 1;
let parsedData = [];
let extractedUrls = new Set();
let isUIHidden = false;
let isDarkMode = localStorage.getItem(CONFIG.THEME_KEY) === 'dark';
let currentSort = {
column: null,
direction: CONFIG.SORT_DIRECTIONS.ASC
};
let currentFilters = [];
let searchQuery = '';
// === Inject UI Styles ===
const style = document.createElement('style');
style.textContent = `
:root {
--bg-primary: ${isDarkMode ? '#1a1a1a' : '#ffffff'};
--bg-secondary: ${isDarkMode ? '#2d2d2d' : '#f9fafb'};
--text-primary: ${isDarkMode ? '#ffffff' : '#1a1a1a'};
--text-secondary: ${isDarkMode ? '#9ca3af' : '#6b7280'};
--border-color: ${isDarkMode ? '#404040' : '#e5e7eb'};
--hover-bg: ${isDarkMode ? '#404040' : '#e5e7eb'};
--shadow-color: ${isDarkMode ? 'rgba(0,0,0,0.3)' : 'rgba(0,0,0,0.1)'};
--accent-color: #ee4d2d;
--success-color: #22c55e;
--warning-color: #f59e0b;
--error-color: #ef4444;
}
#parser-ui {
position: fixed;
top: 20px;
left: 20px;
z-index: 999999;
background: var(--bg-primary);
border-radius: 16px;
box-shadow: 0 8px 24px var(--shadow-color);
padding: 24px;
width: 90vw;
max-width: 1400px;
max-height: 90vh;
overflow-y: auto;
font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', sans-serif;
color: var(--text-primary);
display: ${isUIHidden ? 'none' : 'block'};
transition: all 0.3s ease;
backdrop-filter: blur(10px);
border: 1px solid var(--border-color);
resize: both;
cursor: move;
}
.parser-container {
display: flex;
flex-direction: column;
gap: 20px;
}
.parser-header {
display: flex;
justify-content: space-between;
align-items: center;
margin-bottom: 16px;
padding-bottom: 16px;
border-bottom: 1px solid var(--border-color);
cursor: move;
user-select: none;
}
.parser-title {
font-size: 1.5rem;
font-weight: 600;
color: var(--text-primary);
display: flex;
align-items: center;
gap: 8px;
}
.header-controls {
display: flex;
gap: 8px;
}
.parser-table {
width: 100%;
border-collapse: separate;
border-spacing: 0;
font-size: 0.875rem;
border-radius: 8px;
overflow: hidden;
}
.parser-table th, .parser-table td {
border: 1px solid var(--border-color);
padding: 12px 16px;
text-align: left;
vertical-align: top;
}
.parser-table th {
background: var(--bg-secondary);
font-weight: 600;
white-space: nowrap;
position: sticky;
top: 0;
z-index: 10;
}
.parser-table tr:nth-child(even) {
background: var(--bg-secondary);
}
.parser-table tr:hover {
background: var(--hover-bg);
}
.parser-controls {
margin-top: 16px;
display: flex;
flex-wrap: wrap;
gap: 8px;
}
.parser-textarea {
width: 100%;
height: 150px;
margin-top: 12px;
padding: 12px 16px;
border: 1px solid var(--border-color);
border-radius: 8px;
font-size: 0.875rem;
resize: vertical;
font-family: monospace;
background: var(--bg-primary);
color: var(--text-primary);
transition: all 0.2s ease;
}
.parser-textarea:focus {
outline: none;
border-color: var(--accent-color);
box-shadow: 0 0 0 2px rgba(238, 77, 45, 0.1);
}
.btn {
padding: 8px 16px;
border: none;
border-radius: 8px;
cursor: pointer;
font-size: 0.875rem;
font-weight: 500;
transition: all 0.2s ease;
display: flex;
align-items: center;
gap: 6px;
background: var(--bg-secondary);
color: var(--text-primary);
}
.btn:hover {
transform: translateY(-1px);
filter: brightness(1.1);
}
.btn:active {
transform: translateY(0);
}
.btn-green { background: var(--success-color); color: white; }
.btn-red { background: var(--error-color); color: white; }
.btn-blue { background: #3b82f6; color: white; }
.btn-yellow { background: var(--warning-color); color: white; }
.btn-purple { background: #8b5cf6; color: white; }
.btn-gray { background: var(--bg-secondary); color: var(--text-primary); }
.parser-status {
font-size: 0.875rem;
color: var(--text-secondary);
margin-top: 8px;
padding: 12px;
border-radius: 8px;
background: var(--bg-secondary);
display: flex;
align-items: center;
gap: 8px;
}
.credit {
font-size: 0.75rem;
color: var(--text-secondary);
text-align: center;
margin-top: 16px;
padding-top: 16px;
border-top: 1px solid var(--border-color);
}
.guide-modal {
position: fixed;
top: 10%;
left: 50%;
transform: translateX(-50%);
z-index: 9999999;
background: var(--bg-primary);
border-radius: 16px;
box-shadow: 0 8px 24px var(--shadow-color);
padding: 24px;
max-width: 80%;
max-height: 80vh;
overflow-y: auto;
display: none;
flex-direction: column;
gap: 16px;
color: var(--text-primary);
border: 1px solid var(--border-color);
}
.modal-header {
display: flex;
justify-content: space-between;
align-items: center;
padding-bottom: 16px;
border-bottom: 1px solid var(--border-color);
}
.modal-title {
font-size: 1.25rem;
font-weight: 600;
color: var(--text-primary);
}
.modal-content {
white-space: pre-wrap;
font-size: 0.875rem;
color: var(--text-secondary);
line-height: 1.6;
}
.modal-close {
background: var(--bg-secondary);
color: var(--text-primary);
border: none;
padding: 8px 16px;
border-radius: 8px;
cursor: pointer;
font-weight: 500;
transition: all 0.2s ease;
}
.modal-close:hover {
background: var(--hover-bg);
}
.theme-toggle {
position: fixed;
bottom: 20px;
right: 20px;
z-index: 999999;
background: var(--bg-primary);
border: 1px solid var(--border-color);
border-radius: 50%;
width: 48px;
height: 48px;
display: flex;
align-items: center;
justify-content: center;
cursor: pointer;
box-shadow: 0 2px 8px var(--shadow-color);
transition: all 0.3s ease;
}
.theme-toggle:hover {
transform: scale(1.1);
}
.notification {
position: fixed;
top: 20px;
right: 20px;
padding: 12px 24px;
border-radius: 8px;
background: var(--bg-primary);
color: var(--text-primary);
box-shadow: 0 4px 12px var(--shadow-color);
z-index: 9999999;
transform: translateX(120%);
transition: transform 0.3s ease;
border: 1px solid var(--border-color);
display: flex;
align-items: center;
gap: 8px;
}
.notification.show {
transform: translateX(0);
}
.notification.success { border-left: 4px solid var(--success-color); }
.notification.error { border-left: 4px solid var(--error-color); }
.notification.warning { border-left: 4px solid var(--warning-color); }
.notification.info { border-left: 4px solid #3b82f6; }
.price {
font-family: monospace;
font-weight: 500;
}
.price.positive { color: var(--success-color); }
.price.negative { color: var(--error-color); }
.price.total { font-weight: 600; color: var(--accent-color); }
/* Scrollbar Styling */
::-webkit-scrollbar {
width: 8px;
height: 8px;
}
::-webkit-scrollbar-track {
background: var(--bg-secondary);
border-radius: 4px;
}
::-webkit-scrollbar-thumb {
background: var(--border-color);
border-radius: 4px;
}
::-webkit-scrollbar-thumb:hover {
background: var(--text-secondary);
}
.resize-handle {
position: absolute;
width: 20px;
height: 20px;
bottom: 0;
right: 0;
cursor: se-resize;
z-index: 1000;
}
.resize-handle::after {
content: '';
position: absolute;
right: 4px;
bottom: 4px;
width: 0;
height: 0;
border-style: solid;
border-width: 0 0 8px 8px;
border-color: transparent transparent var(--text-secondary) transparent;
}
.filter-controls {
display: flex;
gap: 8px;
margin-bottom: 16px;
flex-wrap: wrap;
}
.search-box {
flex: 1;
min-width: 200px;
padding: 8px 12px;
border: 1px solid var(--border-color);
border-radius: 8px;
background: var(--bg-primary);
color: var(--text-primary);
font-size: 0.875rem;
}
.search-box:focus {
outline: none;
border-color: var(--accent-color);
box-shadow: 0 0 0 2px rgba(238, 77, 45, 0.1);
}
.filter-group {
display: flex;
gap: 8px;
align-items: center;
}
.filter-select {
padding: 8px 12px;
border: 1px solid var(--border-color);
border-radius: 8px;
background: var(--bg-primary);
color: var(--text-primary);
font-size: 0.875rem;
}
.filter-input {
padding: 8px 12px;
border: 1px solid var(--border-color);
border-radius: 8px;
background: var(--bg-primary);
color: var(--text-primary);
font-size: 0.875rem;
width: 120px;
}
.filter-btn {
padding: 8px 12px;
border: none;
border-radius: 8px;
background: var(--bg-secondary);
color: var(--text-primary);
cursor: pointer;
font-size: 0.875rem;
display: flex;
align-items: center;
gap: 4px;
}
.filter-btn:hover {
background: var(--hover-bg);
}
.filter-tags {
display: flex;
flex-wrap: wrap;
gap: 8px;
margin-top: 8px;
}
.filter-tag {
display: flex;
align-items: center;
gap: 4px;
padding: 4px 8px;
background: var(--bg-secondary);
border-radius: 4px;
font-size: 0.75rem;
}
.filter-tag button {
background: none;
border: none;
color: var(--text-secondary);
cursor: pointer;
padding: 0;
font-size: 0.75rem;
}
.filter-tag button:hover {
color: var(--error-color);
}
.sortable {
cursor: pointer;
user-select: none;
}
.sortable:hover {
background: var(--hover-bg);
}
.sortable::after {
content: '↕';
margin-left: 4px;
opacity: 0.5;
}
.sortable.asc::after {
content: '↑';
opacity: 1;
}
.sortable.desc::after {
content: '↓';
opacity: 1;
}
.stats-panel {
display: flex;
gap: 16px;
margin-top: 16px;
padding: 16px;
background: var(--bg-secondary);
border-radius: 8px;
flex-wrap: wrap;
}
.stat-item {
flex: 1;
min-width: 200px;
}
.stat-label {
font-size: 0.75rem;
color: var(--text-secondary);
margin-bottom: 4px;
}
.stat-value {
font-size: 1.25rem;
font-weight: 600;
color: var(--text-primary);
}
.stat-value.positive { color: var(--success-color); }
.stat-value.negative { color: var(--error-color); }
.guide-highlight {
border: 2px solid #f59e0b !important;
box-shadow: 0 0 12px 2px #f59e0b66 !important;
animation: pulse-guide 1.2s infinite;
position: relative;
}
@keyframes pulse-guide {
0% { box-shadow: 0 0 12px 2px #f59e0b66; }
50% { box-shadow: 0 0 24px 6px #f59e0b99; }
100% { box-shadow: 0 0 12px 2px #f59e0b66; }
}
.guide-badge {
position: absolute;
top: -10px;
right: -10px;
background: #f59e0b;
color: #fff;
font-size: 0.7rem;
font-weight: bold;
padding: 2px 6px;
border-radius: 8px;
z-index: 2;
box-shadow: 0 2px 6px #f59e0b55;
}
`;
document.head.appendChild(style);
// === UI HTML ===
const uiHTML = `
<div id="parser-ui">
<div class="parser-container">
<div class="parser-header">
<div class="parser-title">
<span>📊 Shopee Financial Tracker v13.1</span>
</div>
<div class="header-controls">
<button class="btn btn-gray" id="guide-btn">📘 Guide</button>
<button class="btn btn-gray" id="theme-btn">${isDarkMode ? '☀️' : '🌙'}</button>
</div>
</div>
<div class="resize-handle"></div>
<textarea id="url-input" placeholder="Paste 1-3 order links (one per line)" class="parser-textarea"></textarea>
<div class="parser-controls">
<button class="btn btn-green" id="start-btn">▶️ Start</button>
<button class="btn btn-red" id="stop-btn" disabled>⏹️ Stop</button>
<button class="btn btn-yellow" id="clear-btn">🗑️ Clear</button>
<button class="btn btn-gray" id="remove-dupes-btn">🔍 Remove Duplicates</button>
<button class="btn btn-blue" id="csv-btn">📊 Export CSV</button>
<button class="btn btn-purple" id="md-btn">📝 Export Markdown</button>
<button class="btn btn-gray" id="extract-btn">🔗 Extract Order Links</button>
</div>
<div class="parser-status" id="status">Ready</div>
<div id="progress-bar-container" style="width: 100%; margin: 12px 0; display: none;">
<div id="progress-bar" style="height: 16px; width: 0; background: var(--accent-color); border-radius: 8px; transition: width 0.2s;"></div>
<div id="progress-bar-label" style="position: absolute; left: 50%; top: 0; transform: translateX(-50%); color: var(--text-primary); font-size: 0.85rem; font-weight: 500;"></div>
</div>
<table class="parser-table" id="results-table">
<thead>
<tr>
<th class="sortable" data-column="Entry">Entry</th>
<th class="sortable" data-column="Shop">Shop</th>
<th class="sortable" data-column="Order Date">Order Date</th>
<th class="sortable" data-column="Item">Item</th>
<th class="sortable" data-column="Harga Asli">Harga Asli</th>
<th class="sortable" data-column="Harga Discount">Harga Discount</th>
<th class="sortable" data-column="Quantity">Quantity</th>
<th class="sortable" data-column="Total Pesanan">Total Pesanan</th>
<th>URL</th>
</tr>
</thead>
<tbody id="results-body"></tbody>
</table>
<div id="grand-total-container" style="margin-top: 20px; text-align: right;">
<span style="font-size: 1.25rem; font-weight: bold; color: var(--accent-color);">Grand Total: <span id="grand-total-value">Rp 0</span></span>
</div>
<div class="credit">Developed by <a href="https://github.com/tukangcode" target="_blank" style="color: #3b82f6; text-decoration: underline;">Ryu-Sena</a> | IndoTech Community</div>
</div>
<div class="guide-modal" id="guide-modal">
<div class="modal-header">
<div class="modal-title">📘 User Guide</div>
<button class="modal-close" id="modal-close">✕</button>
</div>
<div class="modal-content">📘 How to Use:
1. Enable Popups for Shopee:
- Chrome: 🔐 (Site Info) > Site Settings > Allow Popups
- Firefox: ⓘ (Site Info) > Permissions > Allow Popups
2. Extract Order Links:
- Go to "My Orders" page.
- Click [🔗 Extract Order Links] to capture visible order URLs.
3. Ensure No Duplicate Links:
- Click [🔍 Remove Duplicates] to clean up duplicated links.
4. Start Parsing:
- Click [▶️ Start] to begin extracting order details.
- Wait patiently; progress will appear in the status.
5. If CAPTCHA Appears:
- Script will pause for 60 seconds to let you solve CAPTCHA manually.
- After solving, let tab for 10 seconds and script will continue last progress.
- Parsing will automatically resume.
6. Export Results:
- After parsing, export the result via:
- [📊 Export CSV] for spreadsheet (Excel, etc).
- [📝 Export Markdown] for clean text format.
7. UI Controls:
- Press Ctrl+M anytime to toggle the UI visibility.
- Click 🌙/☀️ to toggle dark/light mode.
ℹ️ Notes:
- Avoid opening more than 3 order links manually to prevent Shopee detection.
- Parsing 200+ orders usually does NOT trigger CAPTCHA but stay alert just in case.
- CSV export uses semicolons (;) for better Excel compatibility.
- Dark mode preference is saved between sessions.
- All prices are formatted with proper currency symbols.
</div>
<div class="modal-footer">
<button class="modal-close" id="modal-ok">OK</button>
</div>
</div>
</div>
<div class="theme-toggle" id="theme-toggle">${isDarkMode ? '☀️' : '🌙'}</div>
<div class="notification" id="notification"></div>
<div class="filter-controls">
<input type="text" class="search-box" id="search-input" placeholder="Search orders...">
<div class="filter-group">
<select class="filter-select" id="filter-column">
<option value="Shop">Shop</option>
<option value="Order Date">Order Date</option>
<option value="Item">Item</option>
<option value="Harga Asli">Harga Asli</option>
<option value="Harga Discount">Harga Discount</option>
<option value="Quantity">Quantity</option>
<option value="Total Pesanan">Total Pesanan</option>
</select>
<select class="filter-select" id="filter-type">
<option value="contains">Contains</option>
<option value="equals">Equals</option>
<option value="greater_than">Greater Than</option>
<option value="less_than">Less Than</option>
</select>
<input type="text" class="filter-input" id="filter-value" placeholder="Value...">
<button class="filter-btn" id="add-filter-btn">Add Filter</button>
</div>
</div>
<div class="filter-tags" id="filter-tags"></div>
<div class="stats-panel" id="stats-panel">
<div class="stat-item">
<div class="stat-label">Total Orders</div>
<div class="stat-value" id="total-orders">0</div>
</div>
<div class="stat-item">
<div class="stat-label">Total Spent</div>
<div class="stat-value" id="total-spent">Rp 0</div>
</div>
<div class="stat-item">
<div class="stat-label">Average Order Value</div>
<div class="stat-value" id="avg-order">Rp 0</div>
</div>
</div>
`;
const div = document.createElement('div');
div.innerHTML = uiHTML;
document.body.appendChild(div);
// === DOM Elements ===
const parserUI = document.getElementById('parser-ui');
const urlInput = document.getElementById('url-input');
const statusText = document.getElementById('status');
const startBtn = document.getElementById('start-btn');
const stopBtn = document.getElementById('stop-btn');
const clearBtn = document.getElementById('clear-btn');
const csvBtn = document.getElementById('csv-btn');
const mdBtn = document.getElementById('md-btn');
const extractBtn = document.getElementById('extract-btn');
const removeDupesBtn = document.getElementById('remove-dupes-btn');
const resultsBody = document.getElementById('results-body');
const guideBtn = document.getElementById('guide-btn');
const guideModal = document.getElementById('guide-modal');
const modalClose = document.getElementById('modal-close');
const modalOk = document.getElementById('modal-ok');
const themeBtn = document.getElementById('theme-btn');
const themeToggle = document.getElementById('theme-toggle');
const notification = document.getElementById('notification');
const searchInput = document.getElementById('search-input');
const filterColumn = document.getElementById('filter-column');
const filterType = document.getElementById('filter-type');
const filterValue = document.getElementById('filter-value');
const addFilterBtn = document.getElementById('add-filter-btn');
const filterTags = document.getElementById('filter-tags');
const statsPanel = document.getElementById('stats-panel');
const totalOrders = document.getElementById('total-orders');
const totalSpent = document.getElementById('total-spent');
const avgOrder = document.getElementById('avg-order');
const grandTotalValue = document.getElementById('grand-total-value');
const progressBarContainer = document.getElementById('progress-bar-container');
const progressBar = document.getElementById('progress-bar');
const progressBarLabel = document.getElementById('progress-bar-label');
// === Helper Functions ===
function showNotification(message, type = 'info') {
notification.textContent = message;
notification.className = `notification ${type}`;
notification.classList.add('show');
setTimeout(() => {
notification.classList.remove('show');
}, 3000);
}
function updateStatus(text, type = 'info') {
statusText.textContent = text;
statusText.className = `parser-status ${type}`;
}
function toggleTheme() {
isDarkMode = !isDarkMode;
localStorage.setItem(CONFIG.THEME_KEY, isDarkMode ? 'dark' : 'light');
document.documentElement.style.setProperty('--bg-primary', isDarkMode ? '#1a1a1a' : '#ffffff');
document.documentElement.style.setProperty('--bg-secondary', isDarkMode ? '#2d2d2d' : '#f9fafb');
document.documentElement.style.setProperty('--text-primary', isDarkMode ? '#ffffff' : '#1a1a1a');
document.documentElement.style.setProperty('--text-secondary', isDarkMode ? '#9ca3af' : '#6b7280');
document.documentElement.style.setProperty('--border-color', isDarkMode ? '#404040' : '#e5e7eb');
document.documentElement.style.setProperty('--hover-bg', isDarkMode ? '#404040' : '#e5e7eb');
document.documentElement.style.setProperty('--shadow-color', isDarkMode ? 'rgba(0,0,0,0.3)' : 'rgba(0,0,0,0.1)');
themeBtn.textContent = isDarkMode ? '☀️' : '🌙';
themeToggle.textContent = isDarkMode ? '☀️' : '🌙';
}
function extractOrderNumber(url) {
const pattern = '/user/purchase/order/';
const startIndex = url.indexOf(pattern);
if (startIndex === -1) return null;
const idStart = startIndex + pattern.length;
const idEnd = url.indexOf('?', idStart);
const rawId = idEnd !== -1 ? url.substring(idStart, idEnd) : url.substring(idStart);
return /^\d+$/.test(rawId) ? rawId : null;
}
function removeDuplicatesFromInput() {
const urls = urlInput.value
.split('\n')
.map(u => u.trim())
.filter(Boolean);
const seen = new Set();
const uniqueUrls = [];
for (const url of urls) {
const orderNumber = extractOrderNumber(url);
if (orderNumber && !seen.has(orderNumber)) {
seen.add(orderNumber);
uniqueUrls.push(url);
}
}
urlInput.value = uniqueUrls.join('\n');
const removedCount = urls.length - uniqueUrls.length;
if (removedCount > 0) {
showNotification(`✅ Removed ${removedCount} duplicate(s)`, 'success');
} else {
showNotification('ℹ️ No duplicates found', 'info');
}
}
function extractOrderLinks() {
const links = Array.from(document.querySelectorAll('a[href^="/user/purchase/order/"]'))
.map(a => `https://shopee.co.id${a.getAttribute('href')}`);
const seen = new Set();
const uniqueLinks = [];
for (const url of links) {
const orderNumber = extractOrderNumber(url);
if (orderNumber && !seen.has(orderNumber)) {
seen.add(orderNumber);
uniqueLinks.push(url);
}
}
if (uniqueLinks.length > 0) {
const existingUrls = urlInput.value
.split('\n')
.map(u => u.trim())
.filter(Boolean);
urlInput.value = [...existingUrls, ...uniqueLinks].join('\n');
showNotification(`✅ Found ${uniqueLinks.length} new order links`, 'success');
} else {
showNotification('⚠️ No new order links found', 'warning');
}
}
function formatCurrency(amount) {
return new Intl.NumberFormat('id-ID', {
style: 'currency',
currency: 'IDR',
minimumFractionDigits: 0,
maximumFractionDigits: 0
}).format(amount);
}
function parseCurrency(amount) {
if (typeof amount === 'number') return amount;
// Handle Indonesian currency formatting (Rp26.400 → 26400)
const cleaned = amount
.replace(/[^\d,.-]/g, '') // Remove non-numeric except ,.-
.replace(/\./g, '') // Remove thousands separators
.replace(/,/g, '.') // Convert decimal comma to dot
.replace(/[^0-9.-]/g, ''); // Remove any remaining non-numeric
return parseFloat(cleaned) || 0;
}
function updateStats() {
const filteredData = getFilteredData();
const total = filteredData.reduce((sum, order) => {
return sum + order.items.reduce((itemSum, item) => {
return itemSum + (item.total || 0);
}, 0);
}, 0);
totalOrders.textContent = filteredData.length;
totalSpent.textContent = formatCurrency(total);
avgOrder.textContent = formatCurrency(total / (filteredData.length || 1));
updateGrandTotal();
}
function updateGrandTotal() {
const filteredData = getFilteredData();
const grandTotal = filteredData.reduce((sum, order) => {
return sum + order.items.reduce((itemSum, item) => {
return itemSum + (item.total || 0);
}, 0);
}, 0);
if (grandTotalValue) {
grandTotalValue.textContent = formatCurrency(grandTotal);
}
}
function getFilteredData() {
let filtered = [...parsedData];
// Apply search
if (searchQuery) {
const query = searchQuery.toLowerCase();
filtered = filtered.filter(order => {
return order.Shop.toLowerCase().includes(query) ||
order['Order Date'].toLowerCase().includes(query) ||
order.items.some(item => item.name.toLowerCase().includes(query) ||
(item.hargaAsli && item.hargaAsli.toLowerCase().includes(query)) ||
(item.hargaDiscount && item.hargaDiscount.toLowerCase().includes(query)) ||
(item.quantity && item.quantity.toString().includes(query)) ||
(item.totalPesanan && item.totalPesanan.toLowerCase().includes(query)));
});
}
// Apply filters
currentFilters.forEach(filter => {
filtered = filtered.filter(order => {
return order.items.some(item => {
const value = item[filter.column] || order[filter.column];
if (!value) return false;
switch (filter.type) {
case CONFIG.FILTER_TYPES.CONTAINS:
return value.toString().toLowerCase().includes(filter.value.toLowerCase());
case CONFIG.FILTER_TYPES.EQUALS:
return value.toString().toLowerCase() === filter.value.toLowerCase();
case CONFIG.FILTER_TYPES.GREATER_THAN:
return parseCurrency(value) > parseCurrency(filter.value);
case CONFIG.FILTER_TYPES.LESS_THAN:
return parseCurrency(value) < parseCurrency(filter.value);
default:
return true;
}
});
});
});
// Apply sorting
if (currentSort.column) {
filtered.sort((a, b) => {
const aValue = a.items[0]?.[currentSort.column] || a[currentSort.column];
const bValue = b.items[0]?.[currentSort.column] || b[currentSort.column];
if (typeof aValue === 'number' || typeof bValue === 'number') {
const aNum = parseCurrency(aValue);
const bNum = parseCurrency(bValue);
return currentSort.direction === CONFIG.SORT_DIRECTIONS.ASC ? aNum - bNum : bNum - aNum;
}
const comparison = String(aValue).localeCompare(String(bValue));
return currentSort.direction === CONFIG.SORT_DIRECTIONS.ASC ? comparison : -comparison;
});
}
return filtered;
}
function updateTable() {
const filteredData = getFilteredData();
resultsBody.innerHTML = '';
filteredData.forEach(order => {
order.items.forEach(item => {
const row = document.createElement('tr');
row.innerHTML = `
<td>${order.Entry}</td>
<td>${order.Shop}</td>
<td>${order['Order Date']}</td>
<td>${item.name}</td>
<td class="price">${item.hargaAsli || '-'}</td>
<td class="price">${item.hargaDiscount || '-'}</td>
<td>${item.quantity || '-'}</td>
<td class="price total">${item.totalPesanan || '-'}</td>
<td><a href="${order.URL}" target="_blank">${order.URL}</a></td>
`;
resultsBody.appendChild(row);
});
});
updateStats();
}
function updateFilterTags() {
filterTags.innerHTML = '';
currentFilters.forEach((filter, index) => {
const tag = document.createElement('div');
tag.className = 'filter-tag';
tag.innerHTML = `
${filter.column} ${filter.type} ${filter.value}
<button onclick="removeFilter(${index})">×</button>
`;
filterTags.appendChild(tag);
});
}
function addFilter() {
const column = filterColumn.value;
const type = filterType.value;
const value = filterValue.value;
if (!value) {
showNotification('⚠️ Please enter a filter value', 'warning');
return;
}
currentFilters.push({ column, type, value });
filterValue.value = '';
updateFilterTags();
updateTable();
}
function removeFilter(index) {
currentFilters.splice(index, 1);
updateFilterTags();
updateTable();
}
function handleSort(column) {
if (currentSort.column === column) {
currentSort.direction = currentSort.direction === CONFIG.SORT_DIRECTIONS.ASC
? CONFIG.SORT_DIRECTIONS.DESC
: CONFIG.SORT_DIRECTIONS.ASC;
} else {
currentSort.column = column;
currentSort.direction = CONFIG.SORT_DIRECTIONS.ASC;
}
// Update sort indicators
document.querySelectorAll('.sortable').forEach(th => {
th.classList.remove('asc', 'desc');
if (th.dataset.column === column) {
th.classList.add(currentSort.direction);
}
});
updateTable();
}
function addResult(result) {
if (!result || !result.items.length) return;
parsedData.push(result);
result.items.forEach(item => {
const row = document.createElement('tr');
row.innerHTML = `
<td>${result.Entry}</td>
<td>${result.Shop}</td>
<td>${result['Order Date']}</td>
<td>${item.name}</td>
<td class="price">${item.hargaAsli || '-'}</td>
<td class="price">${item.hargaDiscount || '-'}</td>
<td>${item.quantity || '-'}</td>
<td class="price total">${item.totalPesanan || '-'}</td>
<td><a href="${result.URL}" target="_blank">${result.URL}</a></td>
`;
resultsBody.appendChild(row);
});
updateStats();
}
function clearResults() {
while (resultsBody.firstChild) {
resultsBody.removeChild(resultsBody.firstChild);
}
parsedData = [];
currentFilters = [];
searchQuery = '';
currentSort = {
column: null,
direction: CONFIG.SORT_DIRECTIONS.ASC
};
updateFilterTags();
updateStats();
updateStatus("🧹 Cleared", 'info');
}
function exportData(format) {
if (!parsedData.length) {
showNotification("⚠️ No data to export!", 'error');
return;
}
if (format === 'csv') {
exportToCSV(parsedData);
} else {
exportToMarkdown(parsedData);
}
}
function exportToCSV(data) {
const headers = ['Entry','Shop','Order Date','Item','Harga Asli','Harga Discount','Quantity','Total Pesanan','URL'];
let csv = headers.join(CONFIG.CSV_DELIMITER) + '\n';
let grandTotal = 0;
data.forEach(order => {
order.items.forEach(item => {
// Format numbers properly for CSV
const hargaAsliFormatted = item.hargaAsli ? parseCurrency(item.hargaAsli) : '';
const hargaDiscountFormatted = item.hargaDiscount ? parseCurrency(item.hargaDiscount) : '';
const totalPesananFormatted = item.total || 0;
grandTotal += totalPesananFormatted;
csv += [
order.Entry,
`"${order.Shop.replace(/"/g, '""')}"`,
`"${order['Order Date']}"`,
`"${item.name.replace(/"/g, '""')}"`,
hargaAsliFormatted,
hargaDiscountFormatted,
item.quantity || '1',
totalPesananFormatted,
`"${order.URL}"`
].join(CONFIG.CSV_DELIMITER) + '\n';
});
});
// Add a summary row for Grand Total (formatted correctly)
csv += [
'', '', '', '', '', '', 'Grand Total', grandTotal, ''
].join(CONFIG.CSV_DELIMITER) + '\n';
downloadFile(csv, 'shopee_orders.csv');
showNotification('✅ CSV exported successfully!', 'success');
}
function exportToMarkdown(data) {
const headers = ['Entry','Shop','Order Date','Item','Harga Asli','Harga Discount','Quantity','Total Pesanan','URL'];
let md = '# Shopee Orders\n';
md += headers.map(h => `**${h}**`).join(' | ') + '\n';
md += headers.map(() => '---').join(' | ') + '\n';
data.forEach(order => {
order.items.forEach(item => {
md += [
order.Entry,
order.Shop,
order['Order Date'],
item.name,
item.hargaAsli || '-',
item.hargaDiscount || '-',
item.quantity || '1',
item.totalPesanan || '-',
`[Link](${order.URL})`
].join(' | ') + '\n';
});
});
downloadFile(md, 'shopee_orders.md');
showNotification('✅ Markdown exported successfully!', 'success');
}
function downloadFile(content, filename) {
const blob = new Blob([content], { type: 'text/plain;charset=utf-8' });
const link = document.createElement('a');
link.href = URL.createObjectURL(blob);
link.download = filename;
link.click();
URL.revokeObjectURL(link.href);
}
function cancellableDelay(ms) {
return new Promise((resolve) => {
const checkInterval = setInterval(() => {
if (!isParsing) {
clearInterval(checkInterval);
resolve();
}
}, 100);
const timeout = setTimeout(() => {
clearInterval(checkInterval);
resolve();
}, ms);
});
}
function waitForPageLoad(win) {
return new Promise((resolve, reject) => {
const timeout = setTimeout(() => {
reject(new Error('Page load timeout'));
}, CONFIG.PAGE_LOAD_TIMEOUT);
const checkInterval = setInterval(() => {
if (!isParsing || !win || !win.document) {
clearInterval(checkInterval);
clearTimeout(timeout);
win?.close();
reject(new Error('Parsing stopped or window closed'));
return;
}
if (win.document.readyState === 'complete') {
clearInterval(checkInterval);
clearTimeout(timeout);
resolve();
}
}, 1000);
});
}
async function scrapeOrderDetail(url, entryNumber) {
let retryCount = 0;
while (retryCount <= CONFIG.MAX_RETRIES && isParsing) {
const win = window.open(url, '_blank');
if (!win) {
showNotification("❌ Popup blocked - Enable popups in browser settings", 'error');
return null;
}
try {
await waitForPageLoad(win);
if (!isParsing) {
win.close();
return null;
}
await cancellableDelay(5000);
const doc = win.document;
// Get shop name and order date
const shopName = doc.querySelector('.UDaMW3')?.textContent.trim() || 'NOT FOUND';
const orderDate = doc.querySelector('.stepper__step-date')?.textContent.trim() || 'NOT FOUND';
const itemElements = doc.querySelectorAll('a.mZ1OWk');
const items = [];
itemElements.forEach(item => {
const name = item.querySelector('.DWVWOJ')?.textContent.trim() || 'NOT FOUND';
const quantityText = item.querySelector('.j3I_Nh')?.textContent.trim() || 'x1';
const quantity = parseInt(quantityText.replace('x', '')) || 1;
// Extract prices
let hargaAsli = '';
let hargaDiscount = '';
// First check for discount scenario (both original and discount prices exist)
const originalPriceEl = item.querySelector('.q6Gzj5'); // Original price class
const discountPriceEl = item.querySelector('.PNlXhK'); // Discount price class
if (originalPriceEl && discountPriceEl) {
// Standard discount case
hargaAsli = originalPriceEl.textContent.trim();
hargaDiscount = discountPriceEl.textContent.trim();
} else {
// Check for single price (no discount)
const singlePriceEl = item.querySelector('.nW_6Oi:not(.PNlXhK)'); // Regular price without discount class
if (singlePriceEl) {
hargaAsli = singlePriceEl.textContent.trim();
hargaDiscount = hargaAsli; // Same as original if no discount
} else {
// Fallback - try to find any price element
const anyPriceEl = item.querySelector('.nW_6Oi');
if (anyPriceEl) {
hargaAsli = anyPriceEl.textContent.trim();
hargaDiscount = hargaAsli;
}
}
}
// Calculate item total using DISCOUNTED price
const discountValue = parseCurrency(hargaDiscount);
const itemTotal = discountValue * quantity;
const totalPesanan = formatCurrency(itemTotal);
if (name !== 'NOT FOUND') {
items.push({
name: name,
hargaAsli: hargaAsli || '-',
hargaDiscount: hargaDiscount || '-',
quantity: quantity,
total: itemTotal, // Store numeric value for calculations
totalPesanan: totalPesanan
});
}
});
win.close();
if (items.length === 0) {
retryCount++;
if (retryCount > CONFIG.MAX_RETRIES) return null;
updateStatus(`🔁 Retrying #${retryCount}`, 'warning');
await cancellableDelay(3000);
continue;
}
return {
Entry: entryNumber,
Shop: shopName,
'Order Date': orderDate,
items,
URL: url
};
} catch (err) {
win.close();
retryCount++;
if (retryCount > CONFIG.MAX_RETRIES) {
showNotification(`❌ Error parsing order: ${err.message}`, 'error');
return null;
}
updateStatus(`🔁 Retrying #${retryCount}`, 'warning');
await cancellableDelay(3000);
}
}
return null;
}
async function run() {
isParsing = true;
startBtn.disabled = true;
stopBtn.disabled = false;
updateStatus('🚀 Starting...', 'info');
currentEntry = 1;
const urls = urlInput.value
.split('\n')
.map(u => u.trim())
.filter(u => u.startsWith('https://shopee.co.id'));
if (!urls.length) {
showNotification("⚠️ No valid URLs found", 'error');
resetUI();
return;
}
clearResults();
const totalUrls = urls.length;
let processedUrls = 0;
for (const url of urls) {
if (!isParsing) break;
// Update progress
processedUrls++;
const progressPercent = Math.round((processedUrls / totalUrls) * 100);
updateStatus(`Processing order ${processedUrls} of ${totalUrls} (${progressPercent}%)`, 'info');
const result = await scrapeOrderDetail(url, currentEntry);
if (result && isParsing) {
addResult(result);
currentEntry++;
// Add delay between orders
if (processedUrls < totalUrls) {
showProgressBar(CONFIG.BETWEEN_DELAY);
await cancellableDelay(CONFIG.BETWEEN_DELAY);
hideProgressBar();
}
}
}
if (isParsing) {
// Calculate grand total
const grandTotal = parsedData.reduce((sum, order) => {
return sum + order.items.reduce((itemSum, item) => {
return itemSum + (item.total || 0);
}, 0);
}, 0);
// Format the completion message with financial summary
const completionMessage = `
✅ Parsing completed successfully!
📊 Financial Summary:
• Total Orders: ${parsedData.length}
• Grand Total Spent: ${formatCurrency(grandTotal)}
• Average Order Value: ${formatCurrency(grandTotal / (parsedData.length || 1))}
`;
updateStatus(completionMessage, 'success');
showNotification('✅ Parsing completed successfully!', 'success');
} else {
updateStatus("🛑 Stopped", 'warning');
showNotification('🛑 Parsing stopped by user', 'warning');
}
resetUI();
}
function resetUI() {
isParsing = false;
startBtn.disabled = false;
stopBtn.disabled = true;
}
function toggleUIVisibility() {
isUIHidden = !isUIHidden;
parserUI.style.display = isUIHidden ? 'none' : 'block';
showNotification(`UI ${isUIHidden ? 'hidden' : 'shown'}`, 'info');
}
// === Event Listeners ===
document.addEventListener('keydown', (e) => {
if ((e.ctrlKey || e.metaKey) && e.code === CONFIG.UI_TOGGLE_KEY) {
e.preventDefault();
toggleUIVisibility();
}
});
startBtn.addEventListener('click', () => {
if (!isParsing) run();
});
stopBtn.addEventListener('click', () => {
if (isParsing) {
isParsing = false;
updateStatus("🛑 Stopping...", 'warning');
showNotification('🛑 Stopping parser...', 'warning');
}
});
clearBtn.addEventListener('click', () => {
if (confirm("Clear all data?")) {
clearResults();
showNotification('🧹 Data cleared', 'info');
}
});
csvBtn.addEventListener('click', () => exportData('csv'));
mdBtn.addEventListener('click', () => exportData('markdown'));
extractBtn.addEventListener('click', extractOrderLinks);
removeDupesBtn.addEventListener('click', removeDuplicatesFromInput);
guideBtn.addEventListener('click', () => {
guideModal.style.display = 'flex';
});
[modalClose, modalOk].forEach(btn => {
btn.addEventListener('click', () => {
guideModal.style.display = 'none';
});
});
[themeBtn, themeToggle].forEach(btn => {
btn.addEventListener('click', () => {
toggleTheme();
showNotification(`Switched to ${isDarkMode ? 'dark' : 'light'} mode`, 'info');
});
});
searchInput.addEventListener('input', (e) => {
searchQuery = e.target.value;
updateTable();
});
addFilterBtn.addEventListener('click', addFilter);
document.querySelectorAll('.sortable').forEach(th => {
th.addEventListener('click', () => handleSort(th.dataset.column));
});
// === Initialize ===
window.addEventListener('load', () => {
updateStatus("Ready", 'info');
showNotification('Parser initialized successfully!', 'success');
makeDraggable(parserUI);
});
function makeDraggable(element) {
let pos1 = 0, pos2 = 0, pos3 = 0, pos4 = 0;
const header = element.querySelector('.parser-header');
header.onmousedown = dragMouseDown;
function dragMouseDown(e) {
e.preventDefault();
// get the mouse cursor position at startup
pos3 = e.clientX;
pos4 = e.clientY;
document.onmouseup = closeDragElement;
// call a function whenever the cursor moves
document.onmousemove = elementDrag;
}
function elementDrag(e) {
e.preventDefault();
// calculate the new cursor position
pos1 = pos3 - e.clientX;
pos2 = pos4 - e.clientY;
pos3 = e.clientX;
pos4 = e.clientY;
// set the element's new position
element.style.top = (element.offsetTop - pos2) + "px";
element.style.left = (element.offsetLeft - pos1) + "px";
}
function closeDragElement() {
// stop moving when mouse button is released
document.onmouseup = null;
document.onmousemove = null;
}
}
function showProgressBar(durationMs) {
if (!progressBarContainer || !progressBar || !progressBarLabel) return;
progressBarContainer.style.display = 'block';
progressBar.style.width = '0';
let elapsed = 0;
const interval = 100;
const total = durationMs;
function update() {
elapsed += interval;
const percent = Math.min(100, (elapsed / total) * 100);
progressBar.style.width = percent + '%';
const secondsLeft = Math.ceil((total - elapsed) / 1000);
progressBarLabel.textContent = `⏳ Waiting ${secondsLeft}s`;
if (elapsed < total && isParsing) {
setTimeout(update, interval);
} else {
progressBarContainer.style.display = 'none';
}
}
update();
}
function hideProgressBar() {
if (progressBarContainer) progressBarContainer.style.display = 'none';
}
// Highlight GUIDE if not read before
if (guideBtn && !localStorage.getItem('guide_read')) {
guideBtn.classList.add('guide-highlight');
// Add NEW badge
const badge = document.createElement('span');
badge.className = 'guide-badge';
badge.textContent = 'NEW';
guideBtn.style.position = 'relative';
guideBtn.appendChild(badge);
}
// On GUIDE click, remove highlight and badge, set localStorage
if (guideBtn) {
guideBtn.addEventListener('click', () => {
guideBtn.classList.remove('guide-highlight');
const badge = guideBtn.querySelector('.guide-badge');
if (badge) badge.remove();
localStorage.setItem('guide_read', '1');
});
}
})();
