Solusi Kasir Modern & Terintegrasi

Laporan Progres Sistem Terbaru (30 Agustus 2025)

Struktur Folder

/aplikasi-kasir
├── /assets
│   ├── /css
│   ├── /js
│   └── /images
├── /config
│   └── database.php
├── /modules
│   ├── kasir.php
│   ├── laporan.php
│   ├── member.php
│   ├── pembayaran.php
│   └── user.php
├── /public
│   ├── index.php
│   ├── login.php
│   └── logout.php
├── /templates
│   ├── header.php
│   ├── footer.php
│   └── navbar.php
└── /vendor
    └── (library dependencies)
        

Database Schema (MySQL)

-- Tabel users (multi user)
CREATE TABLE users (
  id INT AUTO_INCREMENT PRIMARY KEY,
  username VARCHAR(50) UNIQUE NOT NULL,
  password VARCHAR(255) NOT NULL,
  role ENUM('admin','kasir','manager') NOT NULL DEFAULT 'kasir',
  outlet_id INT NOT NULL,
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

-- Tabel outlets (multi outlet)
CREATE TABLE outlets (
  id INT AUTO_INCREMENT PRIMARY KEY,
  name VARCHAR(100) NOT NULL,
  address TEXT,
  phone VARCHAR(20),
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

-- Tabel members
CREATE TABLE members (
  id INT AUTO_INCREMENT PRIMARY KEY,
  code VARCHAR(10) UNIQUE NOT NULL,
  name VARCHAR(100) NOT NULL,
  whatsapp VARCHAR(20) NOT NULL,
  points INT DEFAULT 0,
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

-- Tabel orders
CREATE TABLE orders (
  id INT AUTO_INCREMENT PRIMARY KEY,
  member_id INT,
  outlet_id INT NOT NULL,
  user_id INT NOT NULL,
  total DECIMAL(12,2) NOT NULL,
  payment_method ENUM('tunai','qris','edc') NOT NULL,
  payment_status ENUM('pending','paid') NOT NULL DEFAULT 'pending',
  order_date DATETIME DEFAULT CURRENT_TIMESTAMP,
  barcode VARCHAR(50) UNIQUE,
  FOREIGN KEY (member_id) REFERENCES members(id),
  FOREIGN KEY (outlet_id) REFERENCES outlets(id),
  FOREIGN KEY (user_id) REFERENCES users(id)
);

-- Tabel order_items
CREATE TABLE order_items (
  id INT AUTO_INCREMENT PRIMARY KEY,
  order_id INT NOT NULL,
  product_name VARCHAR(100) NOT NULL,
  quantity INT NOT NULL,
  price DECIMAL(12,2) NOT NULL,
  FOREIGN KEY (order_id) REFERENCES orders(id)
);

-- Tabel payments
CREATE TABLE payments (
  id INT AUTO_INCREMENT PRIMARY KEY,
  order_id INT NOT NULL,
  amount DECIMAL(12,2) NOT NULL,
  method ENUM('tunai','qris','edc') NOT NULL,
  payment_date DATETIME DEFAULT CURRENT_TIMESTAMP,
  FOREIGN KEY (order_id) REFERENCES orders(id)
);
        

Contoh Kode Utama Modul Kasir (PHP)

// modules/kasir.php
<?php
require_once '../config/database.php';

function createOrder($memberId, $outletId, $userId, $items, $paymentMethod) {
  global $db;
  $db->beginTransaction();

  try {
    $total = 0;
    foreach ($items as $item) {
      $total += $item['price'] * $item['quantity'];
    }

    $stmt = $db->prepare("INSERT INTO orders (member_id, outlet_id, user_id, total, payment_method, payment_status, barcode) VALUES (?, ?, ?, ?, ?, 'pending', ?)");
    $barcode = generateBarcode();
    $stmt->execute([$memberId, $outletId, $userId, $total, $paymentMethod, $barcode]);
    $orderId = $db->lastInsertId();

    $stmtItem = $db->prepare("INSERT INTO order_items (order_id, product_name, quantity, price) VALUES (?, ?, ?, ?)");
    foreach ($items as $item) {
      $stmtItem->execute([$orderId, $item['product_name'], $item['quantity'], $item['price']]);
    }

    $db->commit();
    return ['success' => true, 'order_id' => $orderId, 'barcode' => $barcode];
  } catch (Exception $e) {
    $db->rollBack();
    return ['success' => false, 'error' => $e->getMessage()];
  }
}

function generateBarcode() {
  return 'ORD' . strtoupper(bin2hex(random_bytes(4)));
}
?>
        

Contoh Kode Utama Modul Laporan (PHP)

// modules/laporan.php
<?php
require_once '../config/database.php';

function getDailyReport($date, $outletId) {
  global $db;
  $stmt = $db->prepare("
    SELECT 
      SUM(total) AS bruto,
      SUM(total) - SUM(total * 0.1) AS netto, -- contoh potongan 10%
      SUM(total * 0.1) AS keuntungan
    FROM orders
    WHERE DATE(order_date) = ? AND outlet_id = ? AND payment_status = 'paid'
  ");
  $stmt->execute([$date, $outletId]);
  return $stmt->fetch(PDO::FETCH_ASSOC);
}
?>
        

Contoh Kode Utama Landing Page (PHP + HTML)

<?php include 'templates/header.php'; ?>
<?php include 'templates/navbar.php'; ?>

<section id="landing">
  <!-- Konten landing page seperti di atas -->
</section>

<?php include 'templates/footer.php'; ?>