Deployment Guide - School Inventory System

SQL Commands to run in phpMyAdmin:

CREATE DATABASE IF NOT EXISTS inventaris_sekolah CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

USE inventaris_sekolah;

CREATE TABLE items (
    id INT(11) AUTO_INCREMENT PRIMARY KEY,
    tanggal DATE NOT NULL,
    kode_kegiatan VARCHAR(50) NOT NULL,
    no_bukti VARCHAR(100) NOT NULL,
    id_barang VARCHAR(50) NOT NULL,
    uraian VARCHAR(255) NOT NULL,
    jumlah_barang INT(11) NOT NULL DEFAULT 1,
    harga_satuan DECIMAL(15,2) NOT NULL DEFAULT 0,
    realisasi DECIMAL(15,2) NOT NULL DEFAULT 0,
    asal_usul VARCHAR(100) NOT NULL,
    keterangan TEXT,
    \`condition\` ENUM('Baik', 'Perlu Perbaikan', 'Rusak') NOT NULL DEFAULT 'Baik',
    location VARCHAR(255),
    category VARCHAR(100),
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    INDEX idx_tanggal (tanggal),
    INDEX idx_kode_kegiatan (kode_kegiatan),
    INDEX idx_id_barang (id_barang),
    INDEX idx_uraian (uraian)
);

INSERT INTO items (tanggal, kode_kegiatan, no_bukti, id_barang, uraian, jumlah_barang, harga_satuan, realisasi, asal_usul, keterangan) VALUES
('2024-01-15', '5.01.01.01', 'BK-001/2024', 'ELC-001', 'Laptop ASUS VivoBook 14 inch Core i5', 2, 8500000.00, 17000000.00, 'Pembelian APBD', 'Laptop untuk keperluan pembelajaran di Lab Komputer'),
('2024-01-10', '5.01.01.02', 'BK-002/2024', 'FRN-001', 'Meja Kerja Guru model standard kayu jati', 5, 1500000.00, 7500000.00, 'Pembelian APBD', 'Meja kerja untuk ruang guru dengan laci penyimpanan');

Upload these files to your hosting's public_html or www directory:

index.html - Main application
styles.css - Styling
script.js - JavaScript functionality
database.php - Database functions
api.php - API endpoints
setup_database.php - Database setup (run once)
debug_api.php - API testing
sample.html - Sample data guide
README.md - Documentation

🚀 School Inventory System - Deployment Guide

📋 Server Requirements Check

🗄️ Database Setup

SQL Commands to run in phpMyAdmin:

📁 Required Files

⚙️ Configuration Updates

Update database.php with your hosting credentials:

🚀 Deployment Steps

🌐 Recommended Hosting

Hostinger

000webhost

Niagahoster

✅ Production Checklist

Security

Performance