Cocinas Franco - Manufacturing & Operations ERP

Cocinas Franco is a custom kitchen & cabinetry manufacturer that needed a single system to run production, inventory & their workforce, replacing a patchwork of spreadsheets. I built this ERP from the ground up on the same frameworkless PHP MVC pattern I use across my projects.

On the production side, it manages clients, kitchen (cocina) projects & contracts, generating QR-coded (chillerlan/php-qrcode) PDF contracts automatically via dompdf, alongside full inventory & kit tracking for materials, melamine boards & hardware (herrajes), including a tool (herramienta) loan/checkout system for the shop floor.

On the people side, it handles employee attendance, payroll & payroll advances (anticipos). A client-facing public project portal lets customers check their kitchen's status without a login, and an automated mailer (PHPMailer) notifies suppliers when purchase orders go out.

Under the hood: PHP 8, Composer/PSR-4 autoloading, and PDO throughout with prepared statements binding every user-supplied value, over 15 controllers and just as many models covering sales, warehouse, HR & payroll. This is a Systems & Apps entry, not Digital Transformation, because it's a full operational ERP the business runs on day to day, rather than a single manual process being automated away.