Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-503.34.1.el9_5.x86_64

PHP Version:

8.2.30

User:

u329947844

Directory:

/home/u329947844/domains/hifi11.in/public_html/print/backend/api

Free Space:

10.21 TB

🔧 Quick Actions

✏️ Editing: generate-invoice.php

<?php
header('Content-Type: application/json');
header('Access-Control-Allow-Origin: *');
header('Access-Control-Allow-Methods: POST, GET, OPTIONS');
header('Access-Control-Allow-Headers: Content-Type');

if ($_SERVER['REQUEST_METHOD'] === 'OPTIONS') {
    http_response_code(200);
    exit();
}

// Database connection
$host = 'localhost';
$dbname = 'u329947844_print';
$username = 'u329947844_print';
$password = 'Ariharan@2003';

try {
    $pdo = new PDO("mysql:host=$host;dbname=$dbname", $username, $password);
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch(PDOException $e) {
    echo json_encode(['error' => 'Connection failed: ' . $e->getMessage()]);
    exit();
}

// Handle POST request
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $data = json_decode(file_get_contents('php://input'), true);
    
    try {
        // Start transaction
        $pdo->beginTransaction();
        
        // Insert invoice
        $sql = "INSERT INTO invoices (invoice_no, invoice_date, due_date, client_name, client_email, 
                client_address, subtotal, tax, grand_total, notes, status, created_at) 
                VALUES (:invoice_no, :invoice_date, :due_date, :client_name, :client_email, 
                :client_address, :subtotal, :tax, :grand_total, :notes, :status, NOW())";
        
        $stmt = $pdo->prepare($sql);
        $stmt->execute([
            ':invoice_no' => $data['invoiceNo'],
            ':invoice_date' => $data['invoiceDate'],
            ':due_date' => $data['dueDate'],
            ':client_name' => $data['clientName'],
            ':client_email' => $data['clientEmail'],
            ':client_address' => $data['clientAddress'],
            ':subtotal' => $data['subtotal'],
            ':tax' => $data['tax'],
            ':grand_total' => $data['grandTotal'],
            ':notes' => $data['notes'],
            ':status' => $data['status']
        ]);
        
        $invoiceId = $pdo->lastInsertId();
        
        // Insert invoice items
        $sql = "INSERT INTO invoice_items (invoice_id, description, quantity, unit_price, total) 
                VALUES (:invoice_id, :description, :quantity, :unit_price, :total)";
        $stmt = $pdo->prepare($sql);
        
        foreach ($data['items'] as $item) {
            $stmt->execute([
                ':invoice_id' => $invoiceId,
                ':description' => $item['description'],
                ':quantity' => $item['quantity'],
                ':unit_price' => $item['price'],
                ':total' => $item['total']
            ]);
        }
        
        // Commit transaction
        $pdo->commit();
        
        echo json_encode(['success' => true, 'message' => 'Invoice saved successfully', 'id' => $invoiceId]);
        
    } catch(Exception $e) {
        $pdo->rollBack();
        echo json_encode(['error' => 'Failed to save invoice: ' . $e->getMessage()]);
    }
}

// Handle GET request
if ($_SERVER['REQUEST_METHOD'] === 'GET') {
    try {
        $stmt = $pdo->query("SELECT * FROM invoices ORDER BY created_at DESC LIMIT 10");
        $invoices = $stmt->fetchAll(PDO::FETCH_ASSOC);
        echo json_encode($invoices);
    } catch(Exception $e) {
        echo json_encode(['error' => 'Failed to fetch invoices: ' . $e->getMessage()]);
    }
}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: generate-invoice.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation