Sisler Bulvarı Cafe System

Sisler Bulvarı Cafe System is a digital ordering and lightweight operations prototype prepared for Sisler Bulvarı Sanat Kafe. The project focuses on reducing service friction during busy hours by moving menu browsing and order entry into a digital flow while giving staff a small admin surface for orders and sales views.

The opening visual above is assembled from the original report screens so the repository reflects the real interface delivery rather than a placeholder hero.

What this repository includes

• Customer-facing order screen for table-side ordering
• Menu browsing surface for cafe items
• Admin-oriented pages for orders and internal navigation
• Daily, monthly, and popularity-focused statistics screens
• MySQL schema for the data model delivered with the project

Included interface surfaces

• login.html: staff login entry point
• order-screen.html: customer/table order capture flow
• menu.html: menu preview surface for the delivered product catalog
• orders.html: order tracking surface
• daily-stats.html: daily sales view
• monthly-stats.html: monthly trend view
• most-popular.html: most popular products view
• index.html: home screen shell

Current repository scope

• The public repository preserves the interface screens and MySQL schema from the original delivery package.
• It is strongest as a working UI prototype and data-model handoff for the cafe case study.
• The README stays aligned with that public structure instead of overstating missing packaging work.

Why the project was built

The underlying problem was operational congestion during rush hours. Staff had to welcome customers, carry menus, take orders, deliver items, and reset tables in the same service window. The proposed system reduces that pressure by shifting menu access and initial order creation to a digital flow and by exposing basic analytics to the business owner.

Academic context

• Course: Bilişim Sistemleri Analizi ve Tasarımı
• Project title: Sisler Bulvarı Sanat Kafe Akıllı Sipariş ve Kafe Yönetimi Sistemi
• Project window: Oct 2024 - Dec 2024
• Team members: Yusuf Yılmaz, Batuhan Yüksel, Savaş Avcı, Ekin Çelik

Tech stack

Area	Tools
Interface layer	HTML, CSS, JavaScript, Bootstrap
Charts	Chart.js
Data model	MySQL
Project method	Waterfall delivery approach described in the report

Repository structure

.
|-- login.html
|-- index.html
|-- menu.html
|-- order-screen.html
|-- orders.html
|-- daily-stats.html
|-- monthly-stats.html
|-- most-popular.html
|-- cafe-database-schema.sql
|-- css/
|-- js/
`-- docs/assets/

Running locally

Because the public snapshot is front-end focused, the fastest way to review it is to serve the files statically:

python3 -m http.server 8080

Then open http://localhost:8080/index.html.

If you want to inspect the original data model as part of the project handoff, import the schema:

mysql -u root -p sisler_cafe < cafe-database-schema.sql

Notes on scope

• This repository works best as a product case study and interface delivery for the course project.
• The public snapshot is strongest on the ordering flow, page structure, and analytics concepts.
• A future iteration could consolidate the interface into a routed application and reconnect the wider application wiring described during the project work.

License

Released under the MIT License.