DEV Community: himanshu joshi

Reviving Mandi Central: From 41 Pending Issues to a Live Business Operations Platform

himanshu joshi — Fri, 29 May 2026 06:44:07 +0000

This is a submission for the GitHub Finish-Up-A-Thon Challenge

What I Built

I built and revived Mandi Central, a complete business operations and billing system for mandi-style trading businesses.

Live Project: https://mandicentral.in

Mandi Central helps manage daily mandi operations like purchases, farmer purchase entries, sales entries, payments, bank and cash ledgers, accounting heads, reports, invoices, outstanding balances, and financial statements from one structured platform.

This project was not started as a simple demo. It was a real business-focused software project, but it had many unfinished parts, broken flows, missing reports, pending PDF generation, incomplete mobile API planning, and several UI and accounting issues.

For the GitHub Finish-Up-A-Thon Challenge, I brought it back, fixed the pending issues, completed the core business flow, and made the project live on mandicentral.in.

Demo

Live Website: https://mandicentral.in

GitHub Repository: https://github.com/hiijoshi/bill

Screenshots and demo cover the completed modules:

Business Operations Hub
Sales List
Bank reconciliation
Cash ledger
Bank ledger
Sales entry
Purchase entry
Farmer purchase entry
Bulk PDF download
Accounting reports
Party ledger redirection
Outstanding reports
Mobile API-ready backend

The Comeback Story

Mandi Central started with a strong idea: create one platform where mandi businesses can manage their complete daily workflow.

But before this challenge, the project was stuck with many incomplete and pending items.

There were more than 40 pending issues across PDF generation, sales invoices, bank ledger, cash ledger, accounting reports, outstanding reports, purchase calculations, sales calculations, mobile APIs, AWS deployment, domain setup, and UI fixes.

Some of the major problems before completion were:

PDF generation was not working properly.
Bulk sales bill download was missing.
Mobile application APIs were pending.
Farmer Purchase Entry API was pending.
Purchase Entry API was pending.
Sales Entry API was pending.
Bank statement reading and reconciliation flow needed fixing.
Balance Sheet, Profit and Loss Statement, and Trial Balance were pending.
Bank ledger had incorrect data in some filters.
Cash ledger needed completion.
Journal voucher entries were not reflecting correctly in bank ledger.
Outstanding reports needed clickable party names.
Party ledger redirection was missing.
Outstanding report filters were not visible properly.
Supplier GST field was missing.
Marka dropdown/input flow needed improvement.
Purchase weight calculation needed rechecking.
Purchase bill payment amount calculation needed correction.
Purchase report was missing number of bags.
Sales Entry needed multiple other amount buckets with remarks.
Record payment needed proper bank visibility for NEFT, RTGS, UPI, and cheque.
Account Head and Supplier needed controlled selection.
Payment mode master needed universal modes like Cash, Cheque, NEFT, RTGS, and UPI.
Sales invoice split module needed support for more than two parts like 17(A), 17(B), and 17(C).
Financial year concept needed to follow 1 April to 31 March.
Average rate calculation formula needed correction.
Mandi tax and commission percentage dropdowns were needed in additional charges.
Sales invoice and dispatch print were missing marka number.
Dropdown arrows and outside-click behavior needed UI fixes.
Stock adjustment remarks were not visible.
Record sales receipt had unnecessary bank account and IFSC fields.
Domain change and AWS speed optimization were pending.

The project had functionality, but it was not finished enough to be confidently used as a live business system.

During this finish-up phase, I focused on completing the real business-critical parts first instead of only polishing the UI.

I fixed the PDF generation issue, added bulk PDF download support, improved the sales invoice format, corrected cash and bank ledger flows, completed accounting-related fixes, added mobile application API support, improved outstanding reports, fixed purchase and sales calculation problems, improved dropdown behavior, and completed the domain deployment.

Now the project is live at:

https://mandicentral.in

The biggest comeback was turning Mandi Central from an unfinished internal project into a live, usable, business-ready platform.

My Experience with GitHub Copilot

GitHub Copilot helped me a lot during the finishing phase.

This project had many interconnected modules. A small change in sales entry could affect invoice printing, ledger posting, outstanding reports, accounting heads, and financial statements. Copilot helped me move faster while checking and improving these connected flows.

I used GitHub Copilot for:

Understanding older parts of the codebase.
Fixing PDF generation and download logic.
Improving bulk PDF download flow.
Cleaning sales invoice and dispatch print logic.
Creating and improving mobile API structures.
Improving Farmer Purchase Entry, Purchase Entry, and Sales Entry API logic.
Fixing bank ledger and cash ledger data handling.
Connecting journal voucher entries with ledger reports.
Improving accounting head mapping.
Cleaning repeated form and dropdown logic.
Writing better validation for payment mode, bank, supplier, and account head.
Improving report filters and party ledger redirection.
Writing clearer API documentation and test steps.

Copilot did not replace the business logic decisions. The mandi business rules, accounting behavior, financial year logic, and report expectations still needed manual understanding.

But Copilot helped reduce the time required to inspect files, refactor code, generate validation ideas, and improve repetitive parts of the project.

It felt like having a coding partner while finishing a large, messy, real-world project.

What Changed After Completion

Here are the major completed improvements:

PDF and Invoice

Fixed PDF generation issue.
Added bulk sales bill PDF download.
Added download option for bulk PDF.
Updated sales invoice format.
Added marka number in sales invoice and dispatch print.
Fixed sales invoice split module for multiple invoice parts like 17(A), 17(B), and more.

Mobile Application APIs

Completed mobile API planning and backend support for:

Farmer Purchase Entry
Purchase Entry
Sales Entry

These APIs are now ready for mobile application integration so the same backend and database can be used by both web and mobile apps.

Sales Module

Fixed Sales Entry additional charges.
Added multiple other amount bucket support.
Added remarks in other charges.
Added mandi tax percentage auto calculation and dropdown support.
Added commission percentage dropdown in additional charges.
Moved add charges button to the correct position.
Allowed total weight in quintal to be editable.
Removed unnecessary bank account and IFSC fields from sales receipt.

Purchase Module

Rechecked purchase entry weight calculation.
Fixed purchase bill kishan bhugtan rashi issue.
Added number of bags in purchase report.
Changed Purchase List label from Party to Farmer / Supplier.
Added marka filter in Purchase List.
Added supplier GST field.
Improved marka dropdown and new input option.

Ledger and Accounting

Fixed Bank Ledger incorrect data issue.
Completed Cash Ledger.
Fixed Journal Voucher reflection in Bank Ledger.
Added Payment Journal Voucher Entry screen.
Added accounting head related information.
Improved account head and supplier controlled selection.
Added universal payment modes: Cash, Cheque, NEFT, RTGS, UPI.
Added Balance Sheet.
Added Profit and Loss Statement.
Added Trial Balance.
Added financial year concept from 1 April to 31 March. Updated average rate formula:

Average Rate = Gross Total Amount / Total Weight

Outstanding and Reports

Removed Outstanding Board Report from all operation reports.
Added outstanding overdue by day.
Made party names clickable in outstanding reports.
Added redirection to party ledger.
Improved outstanding report filter visibility.
Added party-to-ledger redirection from report dropdown.
Improved report filter and search behavior.

UI and Deployment

Fixed company dropdown outside-click closing behavior.
Fixed dropdown arrow button behavior.
Improved Business Operations Hub layout.
Shifted project to AWS.
Improved speed and deployment stability.
Changed and connected the domain.
Made the final project live on mandicentral.in.

Market Intelligence AI Agent - Real-time Competitor Analysis with Beautiful Web GUI

himanshu joshi — Sat, 23 Aug 2025 06:05:45 +0000

What I Built

A powerful Market Intelligence AI Agent with a stunning web interface that transforms product data into actionable business intelligence using Bright Data and OpenAI. This isn't just another API - it's a complete business intelligence platform with a professional GUI that companies can actually use!

🔗 Links

🌐 GitHub Repository: https://github.com/yourusername/market-intelligence-ai-agent
💻 Live Demo: Beautiful web interface with real-time analysis
🎬 Demo Video: [Add your demo video if you have one]

📸 Screenshots

Beautiful Web Interface

Modern gradient design with interactive product analysis form

Real-time Results Display

Instant AI analysis with structured insights and market intelligence

Market Trends Dashboard

Live market trends with product tracking statistics

How It Works

The Complete Pipeline:

🎨 Beautiful Web Form → User enters product details via stunning GUI
🕷️ Bright Data Integration → Real-time web scraping capabilities
🤖 AI Analysis Engine → OpenAI processes data for market insights
📊 Interactive Results → Beautiful cards showing structured intelligence
📈 Market Dashboard → Live trends and historical analysis

Key Features

🎨 Professional Web Interface

Modern, responsive design with gradient styling
Interactive forms with real-time validation
Beautiful results display with structured cards
Mobile-friendly responsive layout
Professional dashboard with live statistics

🤖 AI-Powered Intelligence

Real-time price trend detection
Stock status monitoring and alerts
Rating and review analysis
Competitive positioning insights
Historical data comparison

📊 Business Intelligence

Automated competitor research
Market opportunity identification
Data-driven pricing recommendations
Scalable product monitoring
Actionable business insights

Technical Implementation

Frontend Excellence

<!-- Beautiful, responsive web interface -->
<div class="container">
  <div class="header">
    <h1>🤖 Market Intelligence AI Agent</h1>
    <p>Real-time competitor analysis powered by AI</p>
  </div>
  <!-- Interactive forms and results display -->
</div>

Backend Power

# Flask application with AI integration
@app.route('/analyze', methods=['POST'])
def analyze():
    raw_data = request.get_json()
    result = agent.analyze_data(raw_data)
    return jsonify(result)

Sample Output

{
  "structured_data": [{
    "product": "Nike Air Zoom Pegasus",
    "price": "$120",
    "availability": "In Stock",
    "rating": "4.6/5",
    "insights": "Price increased 8% from last week"
  }],
  "summary": [
    "Nike Air Zoom Pegasus is in stock at $120",
    "Price trending upward - strong demand indicated",
    "High customer satisfaction with 4.6/5 rating"
  ]
}

Why It's Unstoppable

🚀 Real Business Value

This isn't just a tech demo - it's a production-ready business intelligence platform that companies would actually pay for:

E-commerce teams can monitor competitor pricing automatically
Product managers get instant market intelligence
Marketing teams receive competitive analysis insights
Executives make data-driven strategic decisions

🎯 Perfect Challenge Compliance

✅ Bright Data Integration: Real-time web scraping capabilities
✅ AI Enhancement: OpenAI-powered intelligent analysis
✅ Practical Application: Solves genuine business problems
✅ Technical Excellence: Professional-grade implementation
✅ User Experience: Beautiful, intuitive web interface

💡 Innovation Beyond Requirements

While the challenge asked for functionality, I delivered a complete user experience:

Professional web GUI (not just APIs)
Real-time interactive dashboard
Mobile-responsive design
Production-ready architecture

Business Impact

Immediate Value

Time Savings: Automate hours of manual competitor research
Competitive Advantage: Real-time market intelligence alerts
Better Decisions: AI-powered insights for pricing and strategy
Scalability: Monitor hundreds of products simultaneously

Market Opportunity

The global competitive intelligence market is worth $3.2B and growing. This platform addresses core pain points:

Manual research is time-consuming and error-prone
Existing tools are expensive and complex
Real-time insights are crucial for fast-moving markets

Technical Architecture

Stack

Backend: Python Flask with SQLite database
Frontend: Modern HTML5, CSS3, JavaScript
AI: OpenAI GPT for intelligent analysis
Data: Bright Data API for reliable web scraping
Deployment: Docker-ready with production configuration

Quick Start

# Clone and run
git clone https://github.com/yourusername/market-intelligence-ai-agent.git
cd market-intelligence-ai-agent
pip install -r requirements.txt
python app.py

# Open browser: http://localhost:5000

What Makes This Special

Beyond the Challenge Requirements

Most submissions will focus on basic functionality. This project delivers:

Complete user experience with professional GUI
Real business application that companies can use immediately
Production-ready quality with proper architecture
Scalable foundation for future enhancements

Competitive Differentiation

Beautiful Design: Professional interface that users love
Business Focus: Solves real problems with measurable ROI
Technical Excellence: Clean code, proper architecture
Market Ready: Can be deployed and monetized immediately

Future Roadmap

Phase 1 (Current) ✅

Web GUI with real-time analysis
AI-powered market insights
Historical trend tracking

Phase 2 (Next)

Multi-language support
Advanced analytics dashboard
Email/Slack notifications
User authentication system

Phase 3 (Future)

Machine learning price predictions
API marketplace integration
White-label solutions
Enterprise features

Demo Instructions

Try It Yourself:

Clone the repository
Install dependencies: pip install -r requirements.txt
Run the app: python app.py
Open browser: http://localhost:5000
Enter product details and see AI analysis in action!

Sample Test Data:

Product: Nike Air Zoom Pegasus
Price: $120
Stock: In Stock
Rating: 4.5/5
Source: nike.com

Conclusion

The Market Intelligence AI Agent represents the perfect fusion of cutting-edge AI technology with practical business value. By combining Bright Data's reliable web scraping, OpenAI's intelligent analysis, and a beautiful user interface, this platform delivers immediate value to businesses while showcasing technical excellence.

This isn't just a hackathon project - it's the foundation of a real business intelligence platform that companies would pay to use.

Ready to revolutionize competitive intelligence? The future of market analysis is here! 🚀

🏆 Built for DEV.to x n8n x Bright Data Challenge

GitHub: https://github.com/anshuhimanshu001/market-intelligence-ai-agent.git

Tags: #brightdata #ai #marketintelligence #webgui #competitoranalysis #flask #openai #businessintelligence #hackathon #n8n

Embracing the Solstice: A Winter Wonderland of Science, Traditions, and Celebrations

himanshu joshi — Sun, 29 Dec 2024 16:07:07 +0000

<!DOCTYPE html>

Winter Solstice Celebrations

 body { font-family: 'Montserrat', sans-serif; margin: 0; padding: 0; background: linear-gradient(to bottom, #1a1a2e, #16213e, #0f3460); color: #fff; overflow-x: hidden; } body::before { content: ''; position: fixed; top: 0; left: 0; width: 100%; height: 100%; background: url('<a href="https://source.unsplash.com/1600x900/?snow,forest'">https://source.unsplash.com/1600x900/?snow,forest'</a>) no-repeat center center/cover; opacity: 0.5; z-index: -1; } header { text-align: center; padding: 50px 20px; background: rgba(0, 0, 0, 0.7); box-shadow: 0 4px 8px rgba(0, 0, 0, 0.5); } header h1 { font-size: 2.5rem; margin-bottom: 10px; } header nav ul { list-style: none; padding: 0; display: flex; justify-content: center; gap: 20px; } header nav ul li a { text-decoration: none; color: #00d4ff; font-weight: 700; transition: color 0.3s ease; } header nav ul li a:hover { color: #ff69b4; } section { padding: 40px 20px; margin: 20px auto; max-width: 900px; background: rgba(255, 255, 255, 0.1); border-radius: 10px; box-shadow: 0 4px 6px rgba(0, 0, 0, 0.3); } section h2 { color: #00d4ff; text-align: center; margin-bottom: 20px; } .celebration { border-bottom: 1px solid rgba(255, 255, 255, 0.3); padding-bottom: 20px; margin-bottom: 20px; } .celebration:last-child { border-bottom: none; margin-bottom: 0; } .snowflake { position: absolute; top: -10px; font-size: 1.5rem; color: #fff; animation: fall 10s linear infinite; opacity: 0.8; } @keyframes fall { 0% { transform: translateY(-100px) rotate(0deg); left: calc(100% * var(--x-start)); } 100% { transform: translateY(100vh) rotate(360deg); left: calc(100% * var(--x-end)); } } footer { text-align: center; padding: 20px; background: rgba(0, 0, 0, 0.7); box-shadow: 0 -4px 8px rgba(0, 0, 0, 0.5); color: #bbb; } footer nav ul { list-style: none; padding: 0; display: flex; justify-content: center; gap: 15px; } footer nav ul li a { text-decoration: none; color: #00d4ff; transition: color 0.3s ease; } footer nav ul li a:hover { color: #ff69b4; } .customize-panel { position: fixed; top: 20px; right: 20px; background: rgba(0, 0, 0, 0.7); padding: 15px; border-radius: 10px; box-shadow: 0 4px 6px rgba(0, 0, 0, 0.5); z-index: 1000; } .customize-panel label { display: block; margin-bottom: 10px; font-size: 0.9rem; color: #fff; } .customize-panel input[type="range"] { width: 100%; }

Celebrating the Winter Solstice

Introduction
The Science
Across Hemispheres
Celebrations
Traditions
Conclusion

<section id="introduction">
    <h2>Introduction</h2>
    <p>The winter solstice marks the shortest day and the longest night of the year. It’s a time of reflection and celebration for many cultures.</p>
</section>

<section id="science">
    <h2>The Science Behind the Solstice</h2>
    <p>The Earth’s axial tilt creates this phenomenon, bringing seasonal changes that affect all living beings.</p>
</section>

<section id="hemispheres">
    <h2>Solstice Across Hemispheres</h2>
    <p>While the Northern Hemisphere experiences winter, the Southern Hemisphere enjoys summer.</p>
</section>

<section id="celebrations">
    <h2>Global Celebrations</h2>
    <div class="celebration">
        <h3>Newgrange - Ireland</h3>
        <p>Sunlight illuminates the chamber of this ancient site during the solstice.</p>
    </div>
    <div class="celebration">
        <h3>Koliada - Eastern Europe</h3>
        <p>Carols, feasts, and bonfires mark this Slavic celebration.</p>
    </div>
</section>

<section id="traditions">
    <h2>Common Traditions</h2>
    <ul>
        <li>Bonfires and candles</li>
        <li>Feasting with loved ones</li>
        <li>Decorating with evergreens</li>
    </ul>
</section>

<section id="conclusion">
    <h2>Conclusion</h2>
    <p>The winter solstice connects us to our ancestors and the cosmos.</p>
</section>

<footer id="main-footer">
    <p>&copy; 2024 Winter Solstice Celebrations</p>
    <nav id="footer-nav">
        <ul>
            <li><a href="#main-header">Back to Top</a></li>
        </ul>
    </nav>
</footer>


<script>

    }