Reports page Generate Sales Report Date অনুযায়ী (select date) Generate Report last 7…
- User
Reports page Generate Sales Report Date অনুযায়ী (select date) Generate Report last 7 days ,last 15 days,30 days ,last year,Month name wize মোট অটো, মোট বিক্রয় , মোট বাকি , মোট খরজ , মোট টাকা
Assistant
Reports Page - Sales & Financial Reports
Google Apps Script + Google Sheet + HTML/CSS
এই রিপোর্ট পেজে নিচের ফিচারগুলো থাকবে:
✅ Date Range Selection (তারিখ অনুযায়ী রিপোর্ট)
✅ Quick Filters (Last 7/15/30 days, Last Year, Monthly)
✅ Financial Summary (মোট অটো, বিক্রয়, বাকি, খরচ, মোট টাকা)
✅ Export/Download অপশন
✅ Visual Charts (গ্রাফ/চার্ট)
📌 ধাপ ১: Google Sheet সেটআপ
Sheet 1: Sales (বিক্রয় ডেটা)
Date Auto_Number Sale_Amount Due_Amount Customer_Name 2025-01-15 AUTO-001 5000 1000 রহিম 2025-01-16 AUTO-002 8000 2000 করিম Sheet 2: Expenses (খরচ ডেটা)
Date Expense_Type Amount Description 2025-01-15 পেট্রোল 500 দৈনিক খরচ 2025-01-16 মেরামত 1500 অটো মেরামত
📌 ধাপ ২: Google Apps Script কোড
ফাইল:
Code.gs// রিপোর্ট জেনারেট করার মেইন ফাংশন function generateReport(dateRange) { const salesSheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sales"); const expenseSheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Expenses"); // Date range calculate করুন const dates = calculateDateRange(dateRange); // Sales data filter করুন const salesData = salesSheet.getDataRange().getValues(); const expenseData = expenseSheet.getDataRange().getValues(); let totalAutos = 0; let totalSales = 0; let totalDue = 0; let totalExpenses = 0; // Sales calculation for (let i = 1; i < salesData.length; i++) { const saleDate = new Date(salesData[i][0]); if (saleDate >= dates.startDate && saleDate <= dates.endDate) { totalAutos++; totalSales += salesData[i][2] || 0; totalDue += salesData[i][3] || 0; } } // Expense calculation for (let i = 1; i < expenseData.length; i++) { const expenseDate = new Date(expenseData[i][0]); if (expenseDate >= dates.startDate && expenseDate <= dates.endDate) { totalExpenses += expenseData[i][2] || 0; } } const totalAmount = totalSales - totalExpenses; return { totalAutos: totalAutos, totalSales: totalSales, totalDue: totalDue, totalExpenses: totalExpenses, totalAmount: totalAmount, dateRange: `${dates.startDate.toLocaleDateString()} - ${dates.endDate.toLocaleDateString()}` }; } // Date range calculator function calculateDateRange(rangeType) { const today = new Date(); let startDate = new Date(); let endDate = new Date(); switch(rangeType) { case 'last7days': startDate.setDate(today.getDate() - 7); break; case 'last15days': startDate.setDate(today.getDate() - 15); break; case 'last30days': startDate.setDate(today.getDate() - 30); break; case 'lastYear': startDate = new Date(today.getFullYear() - 1, 0, 1); endDate = new Date(today.getFullYear() - 1, 11, 31); break; case 'thisMonth': startDate = new Date(today.getFullYear(), today.getMonth(), 1); break; default: // Custom date range if (rangeType.startDate && rangeType.endDate) { startDate = new Date(rangeType.startDate); endDate = new Date(rangeType.endDate); } } return { startDate, endDate }; } // Monthly report generator function getMonthlyReport(year, month) { const startDate = new Date(year, month - 1, 1); const endDate = new Date(year, month, 0); return generateReport({ startDate: startDate, endDate: endDate }); } // Web app render function doGet() { return HtmlService.createHtmlOutputFromFile('reportsPage') .setTitle('Sales Reports') .setWidth(1200); }
📌 ধাপ ৩: HTML Reports Page
ফাইল:
reportsPage.html<!DOCTYPE html> <html> <head> <title>Sales Reports</title> <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.0.0/css/all.min.css"> <style> * { margin: 0; padding: 0; box-sizing: border-box; } body { font-family: 'Segoe UI', Tahoma, Geneva, Verdana, sans-serif; background: #f0f2f5; padding: 20px; } .container { max-width: 1200px; margin: 0 auto; background: white; border-radius: 10px; box-shadow: 0 2px 20px rgba(0,0,0,0.1); padding: 30px; } .header { text-align: center; margin-bottom: 30px; } .header h1 { color: #333; font-size: 32px; margin-bottom: 10px; } .date-selector { display: flex; justify-content: center; gap: 20px; margin-bottom: 30px; flex-wrap: wrap; } .date-input-group { display: flex; align-items: center; gap: 10px; } .date-input-group input[type="date"] { padding: 10px; border: 1px solid #ddd; border-radius: 5px; font-size: 16px; } .quick-filters { display: flex; justify-content: center; gap: 10px; margin-bottom: 30px; flex-wrap: wrap; } .filter-btn { padding: 10px 20px; border: 1px solid #ddd; background: white; border-radius: 25px; cursor: pointer; transition: all 0.3s; } .filter-btn:hover { background: #4CAF50; color: white; border-color: #4CAF50; } .filter-btn.active { background: #4CAF50; color: white; border-color: #4CAF50; } .generate-btn { background: #2196F3; color: white; border: none; padding: 12px 30px; border-radius: 5px; font-size: 16px; cursor: pointer; display: block; margin: 0 auto 30px; } .generate-btn:hover { background: #1976D2; } .report-summary { display: grid; grid-template-columns: repeat(auto-fit, minmax(200px, 1fr)); gap: 20px; margin-bottom: 30px; } .summary-card { background: linear-gradient(135deg, #667eea 0%, #764ba2 100%); color: white; padding: 25px; border-radius: 10px; text-align: center; box-shadow: 0 5px 15px rgba(0,0,0,0.2); } .summary-card.sales { background: linear-gradient(135deg, #f093fb 0%, #f5576c 100%); } .summary-card.due { background: linear-gradient(135deg, #fa709a 0%, #fee140 100%); } .summary-card.expense { background: linear-gradient(135deg, #30cfd0 0%, #330867 100%); } .summary-card.total { background: linear-gradient(135deg, #a8edea 0%, #fed6e3 100%); color: #333; } .summary-card h3 { font-size: 18px; margin-bottom: 10px; opacity: 0.9; } .summary-card .amount { font-size: 32px; font-weight: bold; } .summary-card .icon { font-size: 40px; margin-bottom: 10px; opacity: 0.8; } .export-section { text-align: center; margin-top: 30px; } .export-btn { background: #4CAF50; color: white; border: none; padding: 10px 25px; border-radius: 5px; cursor: pointer; margin: 0 10px; } .export-btn:hover { background: #45a049; } .loading { display: none; text-align: center; margin: 20px 0; } .loading i { font-size: 48px; color: #2196F3; animation: spin 1s linear infinite; } @keyframes spin { 0% { transform: rotate(0deg); } 100% { transform: rotate(360deg); } } .date-range-display { text-align: center; color: #666; margin-bottom: 20px; font-size: 18px; } </style> </head> <body> <div class="container"> <div class="header"> <h1><i class="fas fa-chart-line"></i> Sales & Financial Reports</h1> <p>Generate comprehensive reports for your business</p> </div> <div class="date-selector"> <div class="date-input-group"> <label>From:</label> <input type="date" id="startDate"> </div> <div class="date-input-group"> <label>To:</label> <input type="date" id="endDate"> </div> </div> <div class="quick-filters"> <button class="filter-btn" onclick="setDateRange('last7days')">Last 7 Days</button> <button class="filter-btn" onclick="setDateRange('last15days')">Last 15 Days</button> <button class="filter-btn" onclick="setDateRange('last30days')">Last 30 Days</button> <button class="filter-btn" onclick="setDateRange('thisMonth')">This Month</button> <button class="filter-btn" onclick="setDateRange('lastYear')">Last Year</button> </div> <button class="generate-btn" onclick="generateReport()"> <i class="fas fa-sync"></i> Generate Report </button> <div class="loading" id="loading"> <i class="fas fa-spinner"></i> <p>Generating report...</p> </div> <div class="date-range-display" id="dateRangeDisplay"></div> <div class="report-summary" id="reportSummary" style="display: none;"> <div class="summary-card"> <i class="fas fa-car icon"></i> <h3>মোট অটো</h3> <div class="amount" id="totalAutos">0</div> </div> <div class="summary-card sales"> <i class="fas fa-shopping-cart icon"></i> <h3>মোট বিক্রয়</h3> <div class="amount" id="totalSales">৳0</div> </div> <div class="summary-card due"> <i class="fas fa-clock icon"></i> <h3>মোট বাকি</h3> <div class="amount" id="totalDue">৳0</div> </div> <div class="summary-card expense"> <i class="fas fa-money-bill-wave icon"></i> <h3>মোট খরচ</h3> <div class="amount" id="totalExpenses">৳0</div> </div> <div class="summary-card total"> <i class="fas fa-wallet icon"></i> <h3>মোট টাকা</h3> <div class="amount" id="totalAmount">৳0</div> </div> </div> <div class="export-section" id="exportSection" style="display: none;"> <button class="export-btn" onclick="exportPDF()"> <i class="fas fa-file-pdf"></i> Export PDF </button> <button class="export-btn" onclick="exportExcel()"> <i class="fas fa-file-excel"></i> Export Excel </button> <button class="export-btn" onclick="printReport()"> <i class="fas fa-print"></i> Print </button> </div> </div> <script> let currentDateRange = 'last7days'; // Set today's date as default document.getElementById('endDate').valueAsDate = new Date(); function setDateRange(range) { currentDateRange = range; // Update active button document.querySelectorAll('.filter-btn').forEach(btn => { btn.classList.remove('active'); }); event.target.classList.add('active'); const today = new Date(); let startDate =
Other models, same or similar prompt
Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.