Excel Merge Tool

Tools merge data Excel - upload master, mapping kolom, dan export.

Teknologi

Backend

• PHP 8.x - CLI & web-based dengan PDO
• Bulk import Excel (PHPSpreadsheet) + column auto-mapping
• Merge engine dengan audit trail & history
• Session-based authentication (bcrypt)

Frontend

• HTML5, CSS3, JavaScript (ES6+)
• Bootstrap 5 responsive dashboard
• Drag & drop upload

Database

• MySQL 8 / MariaDB - skema ternormalisasi + history log

Tooling & DevOps

• Composer
• Git & GitHub
• Laragon/WAMP

Arsitektur

• Front-end first - hanya berisi tampilan depan (public UI)
• Routing & layout modular (includes, pages)
• Keamanan berlapis: prepared statements, input sanitization, password hashing
• Session-based auth dengan bcrypt & role-based access control

Quick Start

Prasyarat: Laragon / XAMPP

1. Clone repository ke folder laragon/www/ atau htdocs/:

   git clone https://github.com/Celieln/program1.git

2. Import database (jika tersedia) melalui phpMyAdmin.

3. Konfigurasi koneksi database di folder config/.

4. Jalankan server Apache. Buka http://localhost/program1.

Struktur Proyek

program1/
  includes/    # Komponen yang di-include (header, footer, dll)
  assets/      # CSS, JS, gambar
  *.php        # Halaman tampilan depan

Kontribusi

Kontribusi sangat diterima! Baca CONTRIBUTING dan buka Issues untuk melaporkan bug / request fitur.

Lisensi

MIT (c) Celieln