CashApp - Simple POS System

CashApp is a web-based cashier application developed using PHP Native and MySQL. It provides an efficient workflow for small businesses to manage inventory and sales.

---

Key Features

User Authentication – Secure login and user role management. Product CRUD – Create, Read, Update, and Delete products easily. Unit & Category Management – Organized product classification. Unified POS Interface – Handle transactions and shopping carts on a single page. Live Product Search – Fast searching with Auto-Suggest functionality. Auto Stock Sync – Inventory levels update automatically after every transaction. Financial Reporting – Detailed sales reports with PDF & Excel Export support. Automated Change Calculator – Minimize human error during payments. Profit Tracking – Profits are recorded and visible in transaction details. Analytics Dashboard – Visualize sales data with interactive charts.

---

Tech Stack

Technology	Purpose
PHP Native	Backend Logic
MySQL	Database Management
Bootstrap 5	Responsive UI Styling
SweetAlert2	Interactive Notifications
DOMPDF	PDF Report Generation
PhpSpreadsheet	Excel Export Engine

---

Database Schema

Database Name: cashapp_db

To set up the structure, import the SQL file located at: sql/create_database.sql

Table	Description
users	Handles authentication and user data
produk	Inventory/Product information
jual	Transaction headers (date, total, etc.)
rinci_jual	Transaction details (items sold)
laporan	Compiled sales data for reporting

---

Installation Guide

Clone the repository

git clone https://github.com/pangeran-droid/CashApp.git
cd CashApp

Install Composer dependencies (Required for Exports)

composer install

Import the Database

• Open phpMyAdmin.
• Create a new database named cashapp_db.
• Import the sql/create_database.sql file.

Configure Database Connection Edit koneksi.php to match your local environment:

$DB_HOST = "localhost";
$DB_USER = "root";
$DB_PASS = "";
$DB_NAME = "cashapp_db";

Launch the App Open your browser and navigate to:

http://localhost/CashApp

---

Export Tools

File	Function
export_laporan_pdf.php	Generates a professional PDF report
export_laporan_excel.php	Downloads sales data in .xlsx format

---

Lisensi

MIT

---