BACK TO PROJECTS
CASE FILE #004STATUS: COMPLETED

RakitinAja

Role: Full Stack DeveloperYear: 2025

I built RakitinAja to handle computer component inventory and custom PC builder bundles for PC hardware shops. Built with PHP and MySQL, it manages individual components (CPUs, GPUs, RAM, Motherboards), handles custom PC bundle assembly, calculates cashier checkouts with automatic stock deductions, displays 7-day sales analytics with Chart.js, and prints thermal receipts.

PHPMySQLJavaScriptChart.jsCSS3HTML5

Application Screenshots & Gallery

6 Images
RakitinAja - Screenshot 1
View Full Screenshot
RakitinAja - Screenshot 2
View Full Screenshot
RakitinAja - Screenshot 3
View Full Screenshot

The Problem Context

Computer hardware retailers struggled when selling custom PC bundles alongside separate components, leading to inaccurate stock counts, transaction errors, and deleted product history.

The Engineering Solution

I developed a web POS system featuring component inventory management, custom PC bundle configuration, multi-item stock checking, Chart.js analytics, thermal receipt printing, and soft-delete record protection.

SYSTEM ARCHITECTURE TOPOLOGYInteractive Topology
STEP 01
Client Interface
HTML5 / Vanilla JS / CSS3
FRONTEND LAYER
STEP 02
POS Server Logic
Native PHP & Session Cart Engine
BACKEND LAYER
STEP 03
Analytics Engine
Chart.js Sales Visualization
SERVICE LAYER
STEP 04
Relational DB
MySQL Data Store
DATABASE LAYER
STEP 05
Receipt Engine
Thermal Receipt Layout (@media print)
EXPORT LAYER
SELECTED NODE:Client Interface
Click any node to inspect

Implementation Highlights

01.

Designed database schema supporting components, custom PC bundles, and transactions.

02.

Engineered multi-role authentication for Admin and Cashier accounts.

03.

Built custom PC bundle builder with dynamic form rows and automated stock checking.

04.

Integrated Chart.js line charts for 7-day sales trends and low-stock alerts.

05.

Applied soft-delete pattern (is_active = 0) to preserve transaction audit trails.

Measurable Results

  • Automated stock deductions for both bundle items and individual component sales.
  • Eliminated foreign key database errors during product removal via soft-delete architecture.
  • Accelerated checkout workflows with print-ready thermal receipts.

Key Lessons Learned

  • Soft delete mechanisms are vital in POS systems to maintain financial audit trails.
  • Role authorization checks must always run on the server side regardless of UI button states.