Tag: Web app

  • Request Management System for Real Estate Developer

    Request Management System for Real Estate Developer

    Request Management System for Real Estate Development

    NestJS • TypeScript • Supabase • Email Automation

    About the Project

    A web application for the real estate development industry enabling digitalization and automation of the client request handling process. The system replaced a manual paper-based process, reducing processing time and eliminating errors.

    Industry: Real Estate Development
    Technologies: NestJS, TypeScript, Supabase, EJS, Tailwind CSS
    Timeline: 2025
    Status: Deployed, running in production

    Business Challenges

    The client needed a solution to:

    • ✅ Digitalize the request submission process from end clients
    • ✅ Automatically calculate costs based on a price list
    • ✅ Manage communication between technical department and clients
    • ✅ Track request status in real-time
    • ✅ Generate and send documentation via email

    Technical Solution

    Backend:

    • NestJS 10.x with TypeScript – modular architecture
    • Supabase – PostgreSQL database + storage
    • Multer – file upload handling (up to 10 attachments, 15MB/file)
    • Automatic filename sanitization (Polish character support)

    Frontend:

    • EJS templates – server-side rendering
    • Tailwind CSS – responsive design
    • Dynamic forms with live quote preview
    • Client-side and server-side validation

    Key Features:

    • 📋 Submission form with dynamic request builder
    • 💰 Automatic pricing based on price list (23% VAT)
    • 📎 Multi-file upload with format and size validation
    • 💬 Communication system: client ↔ technical department
    • 📧 Automated email notifications (transactional + alerts)
    • 🔐 Admin panel with authentication
    • 📊 Dashboard with statistics and filtering
    • ✏️ Quote editing with manual price adjustments
    • 🔗 Unique client links (token-based access)
    • 📱 Responsive design (mobile-first)

    Key Achievements

    Performance & Reliability:

    • ⚡ Railway deployment with automatic CI/CD
    • 🔄 Hot reload in development
    • 📈 Scalable architecture
    • 🛡️ Error handling and edge cases

    Business Impact:

    • 📉 ~70% reduction in request processing time
    • ✅ Eliminated calculation errors
    • 📧 Automated email communication
    • 📊 Full process transparency for clients
    • 💾 Centralized database for all requests

    Technical Highlights:

    • 🐛 Debugging and fixing critical bugs (file upload limits, timezone handling)
    • 🔧 Multer configuration optimization for multi-file uploads
    • 🌍 Proper timezone handling (Europe/Warsaw)
    • 🔤 Filename sanitization (NFD normalization for Polish characters)
    • 📝 Workflow status implementation (6 request states)

    Technology Stack

    Backend:
    - NestJS 10.x
    - TypeScript 5.x
    - Supabase (PostgreSQL + Storage)
    - Express Session
    - Nodemailer (SMTP)
    
    Frontend:
    - EJS Templates
    - Tailwind CSS
    - Vanilla JavaScript
    - DataTransfer API
    
    DevOps:
    - Railway (hosting + CI/CD)
    - Git/GitHub
    - npm scripts
    

    Results

    Delivered a fully functional system supporting the complete request lifecycle – from client submission, through technical analysis, to final quote acceptance.

    The application streamlined internal processes, increased client satisfaction through transparency and speed, and eliminated errors from manual calculations.

    The system is in production, handling real client requests for a real estate development company.

    Scope of Work

    • ✅ Business requirements analysis
    • ✅ System architecture design
    • ✅ Full-stack development (backend + frontend)
    • ✅ Email service provider integration
    • ✅ Debugging and performance optimization
    • ✅ Deployment and monitoring
    • ✅ Bug fixing and feature development
    • ✅ Technical documentation

    Get in touch to discuss a similar project for your company.

  • Real-Time Cashflow Manager with WhatsApp Integration

    Real-Time Cashflow Manager with WhatsApp Integration

    Project Overview: Intelligent Cashflow Management System

    The INIGRA Cashflow Manager is a modern, full-stack financial tracking application designed for small businesses and entrepreneurs who need real-time visibility into their cash flow. This enterprise-grade solution combines automated transaction processing, multi-currency support, and cutting-edge WhatsApp integration to streamline financial management workflows.

    Core Technology Stack

    Frontend Architecture

    • React 18 with TypeScript for type-safe component development
    • Vite as the build tool for lightning-fast hot module replacement
    • Tailwind CSS for responsive, mobile-first UI design with custom INIGRA branding (#ac7222)
    • Custom font integration (Bank Gothic, Barlow Semi Condensed) for professional corporate identity

    Backend Infrastructure

    • Node.js with Express.js for RESTful API architecture
    • TypeScript throughout the stack for enhanced code quality and maintainability
    • Supabase (PostgreSQL) as the cloud database with Row Level Security
    • Railway platform for production deployment and CI/CD

    Database Design

    • PostgreSQL 15+ with advanced features:
      • Database triggers for automatic balance calculations
      • Real-time data synchronization
      • Atomic transaction handling
      • Multi-table relationships with foreign key constraints

    Key Features & Capabilities

    1. Automated Account Balance Tracking

    • Real-time balance updates triggered by database events
    • Separate tracking for business and personal accounts
    • Automatic balance recalculation on transaction INSERT/UPDATE/DELETE
    • Historical balance tracking with timestamp audit trail

    2. Multi-Currency Transaction Management

    • Support for PLN, USD, and GBP currencies
    • Automatic currency conversion to base currency (PLN)
    • Configurable exchange rates with admin panel
    • Real-time exchange rate updates

    3. Advanced Transaction Categorization

    • Dynamic category system for income and expenses
    • Business vs. Personal account segregation
    • Recurring transaction templates
    • Category-based financial analytics

    4. WhatsApp Integration & Natural Language Processing

    The standout feature of this system is the Twilio-powered WhatsApp integration that enables hands-free transaction entry:

    How it works:

    • Users send natural language messages via WhatsApp
    • Advanced message parser extracts transaction details:
      • Transaction type (income/expense) from keywords
      • Amount and currency detection with regex patterns
      • Date parsing in multiple formats (DD.MM, DD.MM.YYYY, YYYY-MM-DD)
      • Account type inference (business/personal)
      • Automatic category assignment based on keyword matching

    Example:

    User sends: "James, Payment, 2500 PLN, payment date 3.11"
    System creates:
    - Type: Expense
    - Description: "James Payment"
    - Amount: 2500 PLN
    - Date: November 3, 2025
    - Category: Payroll (auto-assigned)
    - Account: Business
    

    Confirmation System:

    • Automatic confirmation messages sent back via WhatsApp
    • Formatted transaction summary with emojis
    • Balance update notifications
    • Error handling with user-friendly messages

    5. Real-Time Dashboard Analytics

    • Monthly financial summaries (income, expenses, balance)
    • Visual breakdown of business vs. personal expenses
    • Percentage-based expense analysis
    • Deficit warnings with actionable insights
    • Historical data comparison across months

    6. Responsive Mobile-First Design

    • Fully optimized for mobile devices (iOS/Android)
    • Touch-friendly UI with large tap targets
    • Horizontal scrolling tabs for easy navigation
    • Clamp-based typography for perfect scaling
    • Progressive Web App (PWA) ready

    Technical Innovations

    1. PostgreSQL Database Triggers

    Custom PL/pgSQL functions automatically maintain account balances:

    CREATE TRIGGER trigger_update_account_balance
      AFTER INSERT OR UPDATE OR DELETE ON transactions
      FOR EACH ROW
      EXECUTE FUNCTION update_account_balance();
    

    2. Smart Message Parsing Algorithm

    • Regex-based pattern matching for amounts and currencies
    • Context-aware keyword detection for categories
    • Fuzzy date parsing with timezone handling (UTC)
    • Multi-language support (Polish/English)

    3. RESTful API Architecture

    Comprehensive API endpoints:

    • /api/transactions – CRUD operations for transactions
    • /api/categories – Category management
    • /api/account-balances – Real-time balance retrieval
    • /api/exchange-rates – Currency rate management
    • /api/whatsapp/webhook – Twilio webhook integration
    • /api/whatsapp/status – Integration health monitoring

    4. Security & Data Protection

    • Environment variable management for sensitive credentials
    • Supabase Row Level Security (RLS) policies
    • CORS configuration for controlled API access
    • SQL injection prevention via parameterized queries
    • No client-side credential exposure

    Automation & Workflows

    1. Transaction Automation

    • Automatic balance updates (no manual calculation needed)
    • Recurring transaction templates
    • Batch transaction processing
    • Historical data recalculation

    2. WhatsApp Workflow

    • 24/7 automated message processing
    • Instant transaction confirmation
    • Error detection and user feedback
    • Multi-user support (via Twilio sandbox/production)

    3. Deployment Automation

    • Git-based continuous deployment via Railway
    • Automatic environment variable injection
    • Zero-downtime deployments
    • Database migration handling

    Financial Calculations & Analytics

    1. Real-Time Balance Calculation

    Current Balance = Previous Balance + Income - Expenses
    

    Updated atomically via database triggers on every transaction.

    2. Monthly Summary Metrics

    • Total Income (sum of all income transactions)
    • Total Expenses (sum of all expense transactions)
    • Net Balance (income minus expenses)
    • Business Expenses percentage
    • Personal Expenses percentage

    3. Currency Conversion

    Amount in PLN = Amount × Exchange Rate
    

    All transactions normalized to PLN for consistent reporting.

    4. Deficit Analysis

    Automatic calculation of required funds to reach break-even:

    Required Funds = |Negative Balance|
    

    Integration Capabilities

    Current Integrations:

    1. Twilio WhatsApp Business API
      • Webhook-based message receiving
      • Automated message sending
      • Sandbox and production modes
    2. Supabase Cloud Database
      • Real-time data synchronization
      • Automatic backups
      • Database triggers and functions
    3. Railway Deployment Platform
      • Environment variable management
      • Automatic scaling
      • SSL certificates

    Future Integration Potential:

    • Bank API connections (Open Banking)
    • Accounting software sync (QuickBooks, Xero)
    • Invoice generation systems
    • Payment gateway integration (Stripe, PayPal)
    • Email notifications (SendGrid)
    • Slack/Microsoft Teams notifications

    Performance & Scalability

    • Sub-second API response times via indexed database queries
    • Optimized SQL queries with proper indexing on foreign keys
    • Efficient React rendering with key-based list rendering
    • Code splitting for faster initial page load
    • Production build optimization (minification, tree-shaking)
    • CDN-ready static asset deployment

    Business Benefits

    1. Time Savings: Reduce transaction entry time by 80% via WhatsApp
    2. Real-Time Visibility: Instant balance updates, no manual calculation
    3. Mobile Accessibility: Manage finances from any device, anywhere
    4. Multi-Currency Support: Handle international transactions seamlessly
    5. Audit Trail: Complete transaction history with timestamps
    6. Expense Insights: Category-based spending analysis
    7. Error Reduction: Automated calculations eliminate human error

    This cashflow management system is built with modern TypeScript and React for a seamless user experience. The automated accounting software features WhatsApp integration for hands-free financial tracking. Perfect for small business expense management, this real-time budget tracker offers multi-currency support and automated balance calculation. The PostgreSQL database ensures data integrity while Twilio API integration enables conversational transaction entry. Deploy this cloud-based financial dashboard on Railway with Supabase backend for scalable business analytics.

  • Why Global Companies Trust Full-Service Software Houses from Poland

    Why Global Companies Trust Full-Service Software Houses from Poland

    Outsourcing software development isn’t just about saving costs anymore—it’s about finding a tech partner you can trust. That’s why more and more companies from Germany, Australia, Singapore, Switzerland, and beyond are turning to full-service software houses in Poland.

    At Inigra, we help international clients build and scale powerful digital products—from custom web and mobile apps to enterprise AI-driven systems.

    Here’s why companies around the world choose us—and why your business might want to do the same.

    1. One Partner, All Solutions

    Choosing a full-service software house means you don’t need to juggle multiple vendors. At Inigra, we cover the entire product lifecycle, including:

    • Web and mobile app development (React, Flutter, iOS, Android)

    • Custom CRM and ERP solutions

    • AI integration and machine learning

    • UI/UX design and prototyping

    • DevOps, testing, and scaling

    • Post-launch support and feature development

    This one-stop approach ensures faster delivery, clearer communication, and better product consistency.

    2. Built for International Clients

    We work with clients from diverse regions and industries—from German logistics firms and Swiss fintechs to Australian startups and Singaporean marketplaces.

    What they all value:

    • 🕓 Time zone flexibility

    • 💬 Clear, fluent English communication

    • 📈 Business-oriented thinking (not just coding)

    • 📁 Transparent reporting and Agile workflows

    • 🤝 Long-term product partnerships

    Working with a software house in Poland like Inigra means getting a tech team that feels like part of your own.

    3. Tech-Driven, Business-Focused

    We don’t just deliver software—we help you build the right solution for your market.

    Our developers, designers, and product managers combine technical skills with a deep understanding of business strategy. We proactively suggest better approaches, flag risks early, and help optimize performance.

    Need to integrate AI? Automate workflows? Launch a scalable MVP? We’ve done it—successfully—for international brands.

    4. Proven Track Record Across Continents

    Over the past few years, we’ve delivered projects for clients in:

    • 🇦🇺 Australia – custom mobile platforms with real-time analytics

    • 🇸🇬 Singapore – e-commerce system with AI-driven recommendations

    • 🇩🇪 Germany – industrial workflow automation platform

    • 🇨🇭 Switzerland – secure finance management tools

    Our clients stay with us for years—not just one-time launches.

    5. Why Poland?

    Poland is one of the most trusted tech hubs in Europe. Ranked among the top countries for software engineering skills, it offers a unique combination of:

    • Top-tier developer talent

    • Cost-effective development rates

    • European time zone alignment

    • Strong work ethic and delivery culture

    Inigra’s headquarters in Poznań is perfectly positioned to serve both European and global markets.

    Looking for a Reliable Tech Partner?

    If you’re a startup building your first MVP or an enterprise scaling your digital systems, a Polish full-service software house can give you the strategic edge.

    ✅ From idea to launch—and beyond—we help our clients turn their ideas into world-class software.

    👉 Contact us today to tell us about your vision. We’ll help you turn it into a real, working product.

  • End-to-End Web & Mobile Platform for On-Demand Home Services

    End-to-End Web & Mobile Platform for On-Demand Home Services

    We developed a comprehensive web and mobile application (iOS & Android) designed to connect service providers with customers seeking at-home appointments across various industries—beauty, wellness, repair, and more.

    The platform enables professionals to register as service providers and manage their own schedules, pricing, and availability, while offering a smooth booking experience for clients.

    Key Features:

    • Service Provider Account Management
      Users can register, create a profile, and define their services, pricing, service areas, and availability.

    • Dynamic Calendar & Availability Management
      Providers manage their own calendar and set open time slots, allowing for real-time visibility of availability.

    • Booking System
      Customers can browse services, choose available time slots, and book appointments directly in the app.

    • Integrated Payments
      Secure online payments for home visits are processed via integrated payment gateways.

    • Real-Time Chat & Notifications
      In-app messaging allows clients and providers to communicate before or after appointments. Push/email notifications are triggered at key stages.

    • Video Call Support
      The app includes a video consultation option for remote services or pre-visit discussions.

    Our Approach:

    Built using Flutter for cross-platform mobile development and a scalable Node.js + PostgreSQL back end, the platform offers seamless performance across devices and fast response times under load. The admin panel and service provider dashboard were developed using React.js, with a focus on ease of use and responsive UI.

    Results:

    The solution provides a full-service experience for both ends of the marketplace—simplifying service booking for customers and enabling flexible, mobile-first business operations for providers. It also reduces no-shows and improves efficiency thanks to automated scheduling and notifications.

    Tech Stack:

    • Frontend (Web): React.js

    • Mobile: Flutter (iOS & Android)

    • Backend: Node.js, Express

    • Database: PostgreSQL

    • Integrations: Stripe, Firebase, WebRTC

    Looking for a custom mobile or web solution for your service-based business?
    Contact us — we’ll help you bring your platform to life.

  • Online Chess for Real Money – Competitive Web Gaming Platform

    Online Chess for Real Money – Competitive Web Gaming Platform

    We built a custom web application for real-time chess matches with integrated monetary stakes, offering users a unique and competitive experience far beyond traditional online chess platforms.

    Key features include:

    • Real-time multiplayer gameplay with matchmaking and ranking logic,

    • Secure wallet integration for player deposits, withdrawals, and game-based transactions,

    • Anti-cheat mechanisms and game session monitoring,

    • WebSockets for low-latency communication and move synchronization,

    • React.js front-end with dynamic game board rendering,

    • Node.js + PostgreSQL back-end for transactional logic and player history.

    This was a one-of-a-kind concept designed to merge the strategy of chess with the thrill of competitive stakes—delivered in a sleek, intuitive, and secure environment.

  • Online Art Gallery – Web Application for Independent Artist Listings

    Online Art Gallery – Web Application for Independent Artist Listings

    We developed a custom web application that serves as an online art gallery and listing platform for independent artists. The platform allows users to create and manage art listings, upload images, categorize works by style or medium, and connect with potential buyers or curators.

    From a technical perspective, the solution includes:

    • Custom front-end built with React.js for fast and responsive UI,

    • Node.js + Express back-end with secure RESTful API,

    • MongoDB database for flexible content management,

    • User authentication, listing moderation, and admin dashboard,

    • Optimized image handling with automatic resizing and compression.

    The platform was designed to be scalable, mobile-friendly, and SEO-ready, empowering artists to promote their work without technical barriers.