#!/usr/bin/env bash set -e PROJECT="adminlte-admin" SESS="/Users/rbutare/websites/system/tmp/sessions" echo "Installing $PROJECT ..." mkdir -p "$PROJECT" cd "$PROJECT" echo "Creating directory structure..." mkdir -p public lib api pages "$SESS" chmod 700 "$SESS" ############################################ # Core.php ############################################ cat > lib/Core.php < lib/DB.php <<'EOF' PDO::ERRMODE_EXCEPTION ]); } return self::$pdo; } public static function fetchUserByEmail(string $email): ?array { $stmt = self::conn()->prepare(" SELECT id, username, email, password_hash, is_active, is_admin, role FROM users WHERE email = :email LIMIT 1 "); $stmt->execute(['email'=>$email]); $row = $stmt->fetch(PDO::FETCH_ASSOC); return $row ?: null; } } EOF ############################################ # Auth.php ############################################ cat > lib/Auth.php <<'EOF' lib/PAGE-top.php <<'EOF' AdminLTE Admin
EOF ############################################ # PAGE-bottom.php ############################################ cat > lib/PAGE-bottom.php <<'EOF'
© AdminLTE Admin
EOF ############################################ # admin.js ############################################ cat > public/admin.js <<'EOF' console.log("AdminLTE Admin Loaded"); EOF ############################################ # login.php ############################################ cat > login.php <<'EOF'
AdminLTE Admin
EOF ############################################ # logout.php ############################################ cat > logout.php <<'EOF' index.php <<'EOF'

Admin

Welcome

EOF ############################################ # User Manager Pages ############################################ # manage.users.php cat > pages/manage.users.php <<'EOF' query(" SELECT id, username, email, role, is_active, is_admin, created_at FROM users ORDER BY id ASC ")->fetchAll(PDO::FETCH_ASSOC); ?>

User Manager

IDUsernameEmailRole ActiveAdminCreatedActions
Edit Password Delete
EOF # add.user.php cat > pages/add.user.php <<'EOF' prepare(" INSERT INTO users (username,email,password_hash,is_active,role,comment,is_admin) VALUES (:u,:e,:h,1,:r,:c,0) "); try { $stmt->execute([ 'u'=>$username,'e'=>$email,'h'=>$hash, 'r'=>$role,'c'=>$comment ]); $success="User created."; } catch(PDOException $ex) { $error=$ex->getMessage(); } } } ?>

Add User

EOF # edit.user.php cat > pages/edit.user.php <<'EOF' prepare("SELECT * FROM users WHERE id=:id"); $stmt->execute(['id'=>$id]); $user=$stmt->fetch(PDO::FETCH_ASSOC); if(!$user){ echo "
User not found.
"; require __DIR__.'/../lib/PAGE-bottom.php'; exit; } $success=null; if($_SERVER['REQUEST_METHOD']==='POST'){ $username=trim($_POST['username']); $email=trim($_POST['email']); $role=trim($_POST['role']); $is_active=intval($_POST['is_active']); $is_admin=intval($_POST['is_admin']); $comment=trim($_POST['comment']); $stmt=DB::conn()->prepare(" UPDATE users SET username=:u,email=:e,role=:r,is_active=:a,is_admin=:i,comment=:c WHERE id=:id "); $stmt->execute([ 'u'=>$username,'e'=>$email,'r'=>$role, 'a'=>$is_active,'i'=>$is_admin,'c'=>$comment,'id'=>$id ]); $success="User updated."; } ?>

Edit User

EOF # delete.user.php cat > pages/delete.user.php <<'EOF' prepare("DELETE FROM users WHERE id=:id"); $stmt->execute(['id'=>$id]); echo "
User deleted.
"; echo "Back"; require __DIR__.'/../lib/PAGE-bottom.php'; EOF # chg.php cat > pages/chg.php <<'EOF' prepare(" UPDATE users SET password_hash=:h WHERE email=:e "); $stmt->execute(['h'=>$hash,'e'=>$email]); $success="Password updated."; } } } ?>

Change Password

EOF ############################################ # SQL Schema + Seed Admin User ############################################ cat > SQL.sql <