#!/usr/bin/env bash
set -e

APP="${1:-myapp}"

echo "Creating project: $APP"

mkdir -p "$APP"/{manifest,backend/api/routes,backend/lib,worker,cli,admin/tools,admin,public/{css,js/components},db,config,logs,data/{cache,tmp,exports},docs}

########################################
# ENV
########################################
cat > "$APP/config/.env" << 'EOF'
DB_HOST=localhost
DB_NAME=appdb
DB_USER=appuser
DB_PASS=secret
API_KEY=local-api-key
LOG_LEVEL=debug
EOF

########################################
# SQL
########################################
cat > "$APP/db/schema.sql" << 'EOF'
CREATE TABLE users (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    username TEXT NOT NULL,
    password_hash TEXT NOT NULL,
    role TEXT NOT NULL
);

CREATE TABLE logs (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    level TEXT,
    message TEXT,
    created_at TEXT
);
EOF

#sqlite3 "$APP/db/app.db" < "$APP/db/schema.sql"

########################################
# Backend Libs
########################################
cat > "$APP/backend/lib/Env.php" << 'EOF'
<?php
class Env {
    private static array $cache = [];
    public static function get(string $key, $default=null) {
        if (!self::$cache) {
            $path = __DIR__ . '/../../config/.env';
            if (!file_exists($path)) return $default;
            foreach (file($path, FILE_IGNORE_NEW_LINES|FILE_SKIP_EMPTY_LINES) as $line) {
                if (strpos($line,'=')!==false) {
                    [$k,$v]=explode('=',$line,2);
                    self::$cache[$k]=$v;
                }
            }
        }
        return self::$cache[$key] ?? $default;
    }
}
EOF

cat > "$APP/backend/lib/Db.php" << 'EOF'
<?php
class Db {
    private static ?PDO $pdo=null;
    public static function conn():PDO {
        if (!self::$pdo) {
            self::$pdo=new PDO('sqlite:' . __DIR__ . '/../db/app.db');
            self::$pdo->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
        }
        return self::$pdo;
    }
}
EOF

cat > "$APP/backend/lib/Logger.php" << 'EOF'
<?php
class Logger {
    public static function log(string $level,string $msg):void {
        $file=__DIR__.'/../../logs/app.log';
        $line="[".date('Y-m-d H:i:s')."] [$level] $msg\n";
        file_put_contents($file,$line,FILE_APPEND);
    }
}
EOF

cat > "$APP/backend/lib/Auth.php" << 'EOF'
<?php
class Auth {
    public static function check():bool {
        return ($_GET['key'] ?? '') === Env::get('API_KEY');
    }
}
EOF

cat > "$APP/backend/lib/Response.php" << 'EOF'
<?php
class Response {
    public static function json($data,int $code=200):void {
        http_response_code($code);
        header('Content-Type: application/json');
        echo json_encode($data);
        exit;
    }
}
EOF

########################################
# Backend API
########################################
cat > "$APP/backend/api/index.php" << 'EOF'
<?php
require __DIR__.'/../lib/Db.php';
require __DIR__.'/../lib/Env.php';
require __DIR__.'/../lib/Logger.php';
require __DIR__.'/../lib/Auth.php';
require __DIR__.'/../lib/Response.php';

$path=$_GET['path'] ?? '';

switch ($path) {
    case 'status':
        require __DIR__.'/routes/status.php';
        break;
    case 'users':
        require __DIR__.'/routes/users.php';
        break;
    default:
        Response::json(['error'=>'Not found'],404);
}
EOF

cat > "$APP/backend/api/routes/status.php" << 'EOF'
<?php
if (!Auth::check()) Response::json(['error'=>'Unauthorized'],403);
Response::json([
    'status'=>'ok',
    'time'=>date('Y-m-d H:i:s'),
    'db'=>file_exists(__DIR__.'/../../db/app.db')?'connected':'missing'
]);
EOF

cat > "$APP/backend/api/routes/users.php" << 'EOF'
<?php
if (!Auth::check()) Response::json(['error'=>'Unauthorized'],403);
$db=Db::conn();
$rows=$db->query("SELECT id,username,role FROM users")->fetchAll(PDO::FETCH_ASSOC);
Response::json($rows);
EOF

########################################
# Admin Toolkit
########################################
cat > "$APP/admin/tools/db-inspect.php" << 'EOF'
<?php
$db=new PDO('sqlite:' . __DIR__.'/../../db/app.db');
$db->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
$tables=$db->query("SELECT name FROM sqlite_master WHERE type='table'")->fetchAll(PDO::FETCH_COLUMN);
foreach ($tables as $t) {
    $count=$db->query("SELECT COUNT(*) FROM \"$t\"")->fetchColumn();
    echo "$t : $count\n";
}
EOF

cat > "$APP/admin/tools/log-viewer.php" << 'EOF'
<?php
$log=__DIR__.'/../../logs/app.log';
$filter=$argv[1] ?? null;
foreach (file($log,FILE_IGNORE_NEW_LINES) as $line) {
    if ($filter && stripos($line,"[$filter]")===false) continue;
    echo $line."\n";
}
EOF

cat > "$APP/admin/tools/config-check.php" << 'EOF'
<?php
$envFile=__DIR__.'/../../config/.env';
$required=['DB_HOST','DB_NAME','DB_USER','DB_PASS','API_KEY','LOG_LEVEL'];
$env=[];
foreach (file($envFile,FILE_IGNORE_NEW_LINES) as $line) {
    [$k,$v]=explode('=',$line,2);
    $env[$k]=$v;
}
foreach ($required as $key) {
    echo "$key : ".(isset($env[$key])?'OK':'MISSING')."\n";
}
EOF

cat > "$APP/admin/tools/user-admin.php" << 'EOF'
<?php
$db=new PDO('sqlite:' . __DIR__.'/../../db/app.db');
$db->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
$cmd=$argv[1] ?? 'list';
switch ($cmd) {
    case 'list':
        print_r($db->query("SELECT id,username,role FROM users")->fetchAll(PDO::FETCH_ASSOC));
        break;
    case 'add':
        $u=$argv[2]; $p=$argv[3]; $r=$argv[4] ?? 'user';
        $hash=password_hash($p,PASSWORD_DEFAULT);
        $db->prepare("INSERT INTO users (username,password_hash,role) VALUES (?,?,?)")->execute([$u,$hash,$r]);
        echo "User added\n";
        break;
    case 'del':
        $u=$argv[2];
        $db->prepare("DELETE FROM users WHERE username=?")->execute([$u]);
        echo "User deleted\n";
        break;
}
EOF

########################################
# Admin Dashboard
########################################
cat > "$APP/admin/dashboard.php" << 'EOF'
<?php
$db=new PDO('sqlite:' . __DIR__.'/../db/app.db');
$tables=$db->query("SELECT name FROM sqlite_master WHERE type='table'")->fetchAll(PDO::FETCH_COLUMN);
?>
<!DOCTYPE html>
<html>
<head><title>Admin Dashboard</title></head>
<body>
<h1>Admin Dashboard</h1>
<ul>
<?php foreach ($tables as $t): ?>
<li><?= $t ?> (<?= $db->query("SELECT COUNT(*) FROM \"$t\"")->fetchColumn() ?> rows)</li>
<?php endforeach; ?>
</ul>
</body>
</html>
EOF

########################################
# CLI Tools
########################################
cat > "$APP/cli/app.sh" << 'EOF'
#!/usr/bin/env bash
php backend/api/index.php "$@"
EOF
chmod +x "$APP/cli/app.sh"

cat > "$APP/cli/admin.sh" << 'EOF'
#!/usr/bin/env bash
case "$1" in
  db) php admin/tools/db-inspect.php ;;
  logs) php admin/tools/log-viewer.php "${2:-}" ;;
  config) php admin/tools/config-check.php ;;
  users) shift; php admin/tools/user-admin.php "$@" ;;
  dashboard) php -S localhost:9000 -t admin ;;
  *) echo "Commands: db, logs, config, users, dashboard" ;;
esac
EOF
chmod +x "$APP/cli/admin.sh"

cat > "$APP/cli/test.sh" << 'EOF'
#!/usr/bin/env bash
set -e
php -l backend/api/index.php
sqlite3 db/app.db < db/tests.sql
bash -n cli/admin.sh
bash -n cli/app.sh
echo "All tests passed."
EOF
chmod +x "$APP/cli/test.sh"

########################################
# Tests
########################################
cat > "$APP/db/tests.sql" << 'EOF'
SELECT name FROM sqlite_master WHERE type='table';
SELECT COUNT(*) FROM users;
EOF

########################################
# Docs
########################################
cat > "$APP/docs/README.md" << 'EOF'
# $APP
Golden-rule modular project template.
EOF

cat > "$APP/docs/ARCHITECTURE.md" << 'EOF'
# Architecture
Backend, CLI, Admin, Tests, Docs, Config, Logs, Data.
EOF

cat > "$APP/docs/INSTALL.md" << 'EOF'
# Install
chmod +x install.sh
./install.sh myapp
php -S localhost:8000 -t public
EOF

cat > "$APP/docs/DESIGN.md" << 'EOF'
# Design
Modular, layered, documented, single installer.
EOF

cat > "$APP/docs/TESTING.md" << 'EOF'
# Testing
cli/test.sh
EOF

########################################
# Manifest
########################################
cat > "$APP/manifest/manifest.json" << 'EOF'
{
  "name": "$APP",
  "version": "1.0.0",
  "paths": {
    "backend": "backend/",
    "cli": "cli/",
    "admin": "admin/",
    "db": "db/",
    "config": "config/",
    "logs": "logs/",
    "data": "data/",
    "docs": "docs/"
  }
}
EOF

echo "Project $APP created successfully."