Consulting and marketing · Web system (PWA)
Yonder · Sistema de Qualidade
Field audit system for Yonder Consultoria, with nonconformities, photos, on site reports and offline mode.
This project has no public page to capture.
- Client
- Food quality and safety consultancy
- Where
- Minas Gerais, Brazil
- Technology
- PHP 8 · MySQL · MariaDB · JavaScript · Service Worker · IndexedDB · Web Push · GitHub Actions · Hostinger
- Status
- Offline · No public site
- Development
- André Gomes · NexiaLabs
In short
The Yonder Quality System was built for Yonder Consultoria, a food safety consultancy from Minas Gerais, Brazil, that audits meat plants, dairies and agribusinesses. Consultants record visits, nonconformities with photos and action plans, even without internet, and the client follows the fix in its own area. It was built by André Gomes, through NexiaLabs, in PHP 8 and MySQL. The system is currently offline.
The client
Yonder ran on site audits, HACCP and good manufacturing practice programs and documentation work for food plants inspected by Brazil's agriculture and health regulators. Every visit produced findings, photos and a report that had to reach the client with an action plan. Managers followed several companies at once, and the finance team logged expenses and invoices per client. All of it depended on spreadsheets, messages and hand edited documents.
The challenge
Consultants work inside cold rooms and slaughter areas, where phone signal tends to disappear, and cannot lose a photo taken as evidence. Each profile had to see only what concerns it: consultants, the companies they are assigned to; clients, their own nonconformities; finance, only invoices and expenses. The final report had to match the layout the consultancy already delivered, with no rework. And everything had to run on shared hosting, with no dedicated server.
What was built
André built a web app that installs on the phone, with a REST API in PHP and a MySQL database. Offline, nonconformities and photos are stored on the device with a visible notice and upload by themselves when the signal returns. Permissions are decided on the server through nine grouped profiles and each consultant's assignments. At the end of a visit the consultant logs final notes and the system generates the on site verification report in the consultancy's own layout, with a cover, photos for each nonconformity and a signature. Each visit's arrival and departure feed a time sheet showing time spent in the field.
What the system does
- Nonconformity records with camera photos, a catalog of types, sector and priority.
- Offline mode with an on device queue and automatic sync on reconnect.
- On site verification report as PDF, assembled at the end of the visit.
- Visit schedule and time sheet with field time per consultant.
- Recurrence detected when the same kind of issue comes back at a company.
- Expenses and invoicing per client, with invoices in PDF and XML.
- Browser notifications and a client area to follow the action plan.
// For whoever reviews the code: architecture and decisions.
Under the hood
The backend is plain PHP 8 with static classes, a REST router in a single entry file and controllers per area: administration, field work, client, management, metrics, notifications and reports. The frontend is a single page application in plain JavaScript, with no build step. The database is MySQL accessed through PDO with parameterized queries, bcrypt passwords, lockout after failed attempts and per IP rate limiting. The service worker uses different strategies for API calls, uploads and static files, and the offline queue lives in IndexedDB with background sync. Releases were automatic through GitHub Actions to Hostinger shared hosting, and metrics run on cron.
Technical decisions
- The session token is also stored in IndexedDB, because the service worker cannot read localStorage and needs to authenticate to sync in the background.
- Data is pulled to the device only for field profiles, because administrators and executives see too much data to keep on a phone.
- Assignment as the access rule, so a consultant only sees and records findings for the companies they serve.
Does your business look like this one?
Fits consultancies, auditors and technical teams that work in the field, often without signal, and must deliver evidence backed reports to the client.
Frequently asked questions
Who developed Yonder · Sistema de Qualidade?
Yonder · Sistema de Qualidade was developed by André Gomes Andrade, a full stack developer from Carlos Chagas, Minas Gerais, Brazil, at NexiaLabs, from planning to launch.
Where is the client of Yonder · Sistema de Qualidade based?
Food quality and safety consultancy. Minas Gerais, Brazil.
Which technologies were used to build Yonder · Sistema de Qualidade?
Yonder · Sistema de Qualidade uses PHP 8, MySQL, MariaDB, JavaScript, Service Worker, IndexedDB, Web Push, GitHub Actions, and Hostinger.
Can you build a similar project for my business?
Yes. Every project is custom built, with code and accounts in the client's name. The first step is a WhatsApp conversation at +55 (33) 98465 6356 to understand what you need.
More consulting and marketing projects
Kronos Consultoria e Treinamentos
Workplace safety training website with a catalog of regulatory courses, free materials in exchange for contact details and a lead panel.
Workplace safety consulting and training for companies
See the project
RD Consultoria Financeira
Website and panel for a financial consultancy serving small businesses, with a contact CRM and a blog run by the team itself.
Financial consulting for small and midsize businesses
See the project
OfflineFox Studio Hub
Website and internal system for Fox Estúdio, a Carlos Chagas agency: request board, clients, team, proposals, approvals.
Creative and marketing agency in Carlos Chagas
See the project