Select Interactive
Internal Web App

2025–Ongoing

Internal Web App

MJEC: Internal App & Client Tools

Overview

McMillan James Equipment Company (MJEC) is a Texas-based manufacturers representative for HVAC, mechanical, and building systems across divisions and territories. Coordinating 125+ manufacturers and partners (each with contacts, contracts, locations, divisions, and sales data) had strained operations spread across spreadsheets and disconnected tools. Select Interactive built a two-platform solution: an internal web app for MJEC staff to centralize that data, and a public-facing client tool so field staff can generate branded PDF brochures on demand for the lines they represent. Both platforms launched in 2025 and continue on a quarterly review and release cadence with the MJEC team.

The Challenge

Consolidate manufacturer and partner data (contacts, contract dates, locations, divisions, target and actual sales figures, internal notes) into a single governed system with role-based access, full change history, and the ability for any staff member to produce a polished, real-time brochure without involving the marketing team.

Services

  • Internal Web Application
  • Public Client Tool
  • Document Management
  • Role-Based Authentication
  • Database Versioning & History
  • On-Demand PDF Generation
  • Firebase
  • Microsoft Azure
  • Ongoing Development
At a Glance
125+
Manufacturers and partners managed
Role-Based
User authentication and permissions
Real-Time
On-demand PDF brochure generation
Ongoing
Quarterly review and release cadence

Internal App

One place for every manufacturer relationship.

The internal application gives MJEC staff a structured home for the full scope of their manufacturer and partner data: company details, marketing and sales contacts, active locations, associated divisions and departments, contract start and expiration dates, and both target and actual sales figures. Internal notes and documents are attached directly to each record, keeping institutional knowledge out of inboxes and spreadsheets and inside a system the whole team can access from any device.

Data Integrity

Every change tracked. Every version recoverable.

The app maintains a complete audit log of every edit made to any manufacturer record, capturing what changed, who changed it, and when. Full database snapshots roll on a seven-day cycle, giving the team a reliable disaster-recovery window. Whether a field gets updated incorrectly or a larger issue arises, restoring to a known-good state is a straightforward operation, not a crisis.

Access Control

The right data in the right hands.

User accounts are managed through a role-based authentication system built on Firebase. Administrators control who can view, edit, or manage records, and an activity log provides a clear picture of user actions across the platform. The same auth layer spans both the internal app and the public client tool, keeping the entire system under unified access control while delivering a smooth experience on desktop and mobile alike.

Client Tools

A live brochure in seconds, not days.

Field staff use the public-facing client tool to filter the manufacturer directory by location, equipment type, and product type, then generate a polished PDF brochure on demand. The brochure pulls live data (manufacturer logos, descriptions, and contact information), so every document reflects the current state of the database the moment it is created. What previously required a request to the marketing team and a multi-day turnaround is now a self-service action that takes seconds.

Public Facing

Built to grow with every quarterly release.

The public manufacturer directory gives prospective customers and partners a clean, filterable view of the equipment lines and brands MJEC represents. Both the internal app and the public-facing tool are active development projects. The MJEC team meets with Select Interactive each quarter to review usage, prioritize feature requests, and ship enhancements. New capabilities added since launch include expanded filtering options, additional document types, enhanced reporting views, and improved mobile workflows for staff in the field.

Built With

A modern, full-stack TypeScript platform spanning a managed internal app and a public-facing client tool, both deployed on Microsoft Azure.

  • React
  • Vite
  • TanStack Start
  • TanStack Router
  • TanStack Query
  • TanStack Table
  • TanStack Form
  • Shadcn/UI
  • Tailwind CSS
  • Firebase
  • TypeScript
  • Zod
  • Nitro
  • Azure
Previous Project

Arts & Giving Back

Foundation for Contemporary Arts

1,100+ pages in Prismic, a custom Stripe-powered store for donated works of art, and a deep set of admin tools, built with Team and supported continuously since launch.

Next Project

Arts & Entertainment

Dallas Art Fair

Online ticketing, a custom CRM, and a dedicated Exhibitor Portal serving 90+ galleries annually, for one of the most celebrated contemporary art fairs in the country.

Based in Fort Worth & Dallas, TX

Let's build something remarkable.

Start a Conversation
Fort Worth: 817 380 8074