CLIENT DELIVERY

Italian Hotel Guest Compliance — ISTAT & Questura reporting

The compliance desk helps Italian hotels file daily guest-presence data to ISTAT (regional statistics) and Questura (police). Built in custom PHP MVC + MySQL with Bootstrap admin UI: hotel signup, reservations, Italian vs non-Italian guest wizards, card prep and export flows.

Vertical SaaSPHP MVCBootstrapISTATQuesturaMySQL

Watch 2:27 demo → Property PMS case →

Italian Hotel Guest Compliance — ISTAT and Questura reporting desk with hotel reservations dashboard
Industry
Hospitality · Italian hotel compliance
Type
Guest reporting & reservation desk
Roles
Hotel manager · front desk staff
Stack
PHP · MySQL (invioUserDB) · Morris charts
Proof
5 screens · 2:27 product demo

The problem

Italian hotel operators must file guest data to ISTAT and police systems — manual forms and spreadsheets break under seasonal volume.

Constraints

Delivery stayed inside the client's stack, tenancy, compliance and media-ownership boundaries. Where a choice was forced (suite vs owned plane, BYOC vs CPaaS, local vs cloud models), the architecture section below records the trade-off rather than a marketing rewrite.

Business requirements

Reservations desk, Italian guest compliance forms, export and reporting on PHP MVC.

Architecture

Classic MVC admin with reservation entities feeding compliance export jobs.

Engineering challenges

  • Compliance fields — ISTAT/police shapes validated before export.
  • Legacy UX — operators need fast reservation entry.

The solution

Italian hotel guest compliance-style platform with admin screens and export path documented locally.

My role

Full-stack PHP delivery for hospitality compliance workflow.

Technology stack

PHP MVCMySQL

Production considerations

  • Export audit trail for submitted guest filings.
  • Role separation for front-desk vs back-office.

Screenshots

Hotel login

Italian hotel guest compliance hotel login page with email password and free trial signup

Dashboard

Italian hotel guest compliance dashboard with hotel attendance Morris chart and subscription notifications panel

Attendance trends, subscription status and support shortcuts — the daily operational view for property managers.

New reservation

Italian hotel guest compliance new reservation form with guest nationality gender and stay dates

Italian guest compliance

Italian hotel guest compliance multi-step Italian guest form with birth ID and document fields for ISTAT police filing

Multi-guest wizard captures birth place, document type and ID numbers required for domestic guests.

Non-Italian guest compliance

Italian hotel guest compliance non-Italian guest data form with nationality document type and number fields

Working-system video

Watch on YouTube → · 2:27 · Dedicated watch page →

Architecture diagram

flowchart LR
  HOTEL[Hotel desk]
  RES[Reservations]
  IT[Italian guest flow]
  NIT[Non-IT guest flow]
  DB[(MySQL invioUserDB)]
  OUT[ISTAT / Questura export]
  HOTEL --> RES --> DB
  RES --> IT --> OUT
  RES --> NIT --> OUT

Outcomes

Restored or delivered system documented with screenshots and local demo — portfolio write-up only.

FAQ — buyer & architecture questions

Ten common questions about this case study, fit, and engagement.

No. Booking/PMS cases cover reservations and ops; compliance cases cover statutory guest reporting—see linked case studies.

No. This is a portfolio case study; production runs on the operator domain.

Documented builds include operator admin, customer portal, billing and multilingual CMS where shipped.

Scope depends on APIs; core case studies focus on direct booking and operator workflows.

Property geography and catalog scale appear where documented in the case study metrics.

Hotel groups, regional tourism portals and PMS replacements—not generic WordPress sites.

Share the current stack (PBX, CRM, cloud), the failure or goal in one paragraph, peak call volume, carriers, and any deadline. Screenshots, a pcap, or a short Loom beat a 40-page RFP. Use the project brief

Yes. Delivery is remote-first from Delhi with scheduled overlap for EU, UK, US and APAC stand-ups. Production changes use written runbooks, rollback steps and agreed maintenance windows.

Yes. Many engagements begin with a 1–2 week SIP trace review, tenant-isolation audit, or architecture assessment. If the fit is good, scope expands from evidence—not from a generic sales deck.

Founders, CTOs, telecom leads, MSPs and product teams building or fixing UCaaS, CCaaS, CRM+voice, AI voice, or vertical SaaS—not buyers who only need seats on a mass-market suite.