Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-611.26.1.el9_7.x86_64

PHP Version:

8.4.15

User:

u892747680

Directory:

/home/u892747680/domains/sisteminformasic.com/public_html/freshfruty/admin/helpers

Free Space:

9.97 TB

🔧 Quick Actions

✏️ Editing: virtual_account_helper.php

<?php
/**
 * Virtual Account Helper Functions
 * File: admin/helpers/virtual_account_helper.php
 */

require_once __DIR__ . '/../../config/database.php';

class VirtualAccountManager {
 private $db;
 
 public function __construct() {
 $database = new Database();
 $this->db = $database->getConnection();
 }
 
 /**
 * Get Virtual Account by Order ID
 */
 public function getVAByOrderId($orderId) {
 $query = "SELECT * FROM virtual_accounts WHERE order_id = :order_id LIMIT 1";
 $stmt = $this->db->prepare($query);
 $stmt->bindParam(':order_id', $orderId);
 try {
 $stmt->execute();
 return $stmt->fetch(PDO::FETCH_ASSOC);
 } catch (PDOException $e) {
 return null;
 }
 }
 
 /**
 * Get all active Virtual Accounts
 */
 public function getActiveVAs($limit = 50, $offset = 0) {
 $query = "SELECT va.*, 
 c.name as customer_name, 
 c.phone as customer_phone,
 o.order_number,
 o.total_amount
 FROM virtual_accounts va
 LEFT JOIN orders o ON va.order_id = o.id
 LEFT JOIN customers c ON va.customer_id = c.id
 WHERE va.status = 'active'
 ORDER BY va.created_at DESC
 LIMIT :limit OFFSET :offset";
 
 $stmt = $this->db->prepare($query);
 $stmt->bindParam(':limit', $limit, PDO::PARAM_INT);
 $stmt->bindParam(':offset', $offset, PDO::PARAM_INT);
 try {
 $stmt->execute();
 return $stmt->fetchAll(PDO::FETCH_ASSOC);
 } catch (PDOException $e) {
 return [];
 }
 }
 
 /**
 * Get VA Statistics
 */
 public function getVAStats() {
 $query = "SELECT 
 COUNT(CASE WHEN status = 'active' THEN 1 END) as active_count,
 COUNT(CASE WHEN status = 'paid' THEN 1 END) as paid_count,
 COUNT(CASE WHEN status = 'expired' THEN 1 END) as expired_count,
 SUM(CASE WHEN status = 'paid' THEN amount ELSE 0 END) as paid_amount,
 SUM(CASE WHEN status = 'active' THEN amount ELSE 0 END) as pending_amount
 FROM virtual_accounts";
 
 $stmt = $this->db->prepare($query);
 try {
 $stmt->execute();
 return $stmt->fetch(PDO::FETCH_ASSOC);
 } catch (PDOException $e) {
 return null;
 }
 }
 
 /**
 * Mark VA as Paid
 */
 public function markAsPaid($vaId) {
 $query = "UPDATE virtual_accounts 
 SET status = 'paid', paid_at = NOW() 
 WHERE id = :id";
 $stmt = $this->db->prepare($query);
 $stmt->bindParam(':id', $vaId);
 try {
 return $stmt->execute();
 } catch (PDOException $e) {
 return false;
 }
 }
 
 /**
 * Auto-expire old Virtual Accounts
 */
 public function expireOldVAs() {
 $query = "UPDATE virtual_accounts 
 SET status = 'expired' 
 WHERE status = 'active' 
 AND expires_at < NOW()";
 
 $stmt = $this->db->prepare($query);
 try {
 return $stmt->execute();
 } catch (PDOException $e) {
 return false;
 }
 }
 
 /**
 * Get VA by Virtual Account Number
 */
 public function getVAByNumber($vaNumber) {
 $cleanVA = preg_replace('/\s+/', '', $vaNumber);
 $query = "SELECT * FROM virtual_accounts WHERE virtual_account_number = :va_number LIMIT 1";
 $stmt = $this->db->prepare($query);
 $stmt->bindParam(':va_number', $cleanVA);
 try {
 $stmt->execute();
 return $stmt->fetch(PDO::FETCH_ASSOC);
 } catch (PDOException $e) {
 return null;
 }
 }
 
 /**
 * Search Virtual Accounts
 */
 public function searchVAs($keyword, $status = null, $limit = 50, $offset = 0) {
 $query = "SELECT va.*, 
 c.name as customer_name, 
 c.phone as customer_phone,
 o.order_number,
 o.total_amount
 FROM virtual_accounts va
 LEFT JOIN orders o ON va.order_id = o.id
 LEFT JOIN customers c ON va.customer_id = c.id
 WHERE (va.virtual_account_number LIKE :keyword 
 OR c.name LIKE :keyword 
 OR o.order_number LIKE :keyword)";
 
 if($status) {
 $query .= " AND va.status = :status";
 }
 
 $query .= " ORDER BY va.created_at DESC
 LIMIT :limit OFFSET :offset";
 
 $stmt = $this->db->prepare($query);
 $keyword = '%' . $keyword . '%';
 $stmt->bindParam(':keyword', $keyword);
 if($status) {
 $stmt->bindParam(':status', $status);
 }
 $stmt->bindParam(':limit', $limit, PDO::PARAM_INT);
 $stmt->bindParam(':offset', $offset, PDO::PARAM_INT);
 try {
 $stmt->execute();
 return $stmt->fetchAll(PDO::FETCH_ASSOC);
 } catch (PDOException $e) {
 return [];
 }
 }
 
 /**
 * Format VA Number untuk display
 */
 public function formatVA($vaNumber) {
 $cleanVA = preg_replace('/\s+/', '', $vaNumber);
 return preg_replace('/(\d{4})(?=\d)/', '$1 ', $cleanVA);
 }
 
 /**
 * Get formatted status dengan warna
 */
 public function getStatusBadge($status) {
 $badges = [
 'active' => '✓ Aktif',
 'paid' => '✓ Terbayar',
 'expired' => '✗ Kadaluarsa'
 ];
 return $badges[$status] ?? $status;
 }
 
 /**
 * Count total VA by status
 */
 public function countByStatus($status) {
 $query = "SELECT COUNT(*) as total FROM virtual_accounts WHERE status = :status";
 $stmt = $this->db->prepare($query);
 $stmt->bindParam(':status', $status);
 try {
 $stmt->execute();
 $result = $stmt->fetch(PDO::FETCH_ASSOC);
 return $result['total'] ?? 0;
 } catch (PDOException $e) {
 return 0;
 }
 }
}

/**
 * Helper function untuk quick access
 */
function getVAManager() {
    static $manager = null;
    if($manager === null) {
        $manager = new VirtualAccountManager();
    }
    return $manager;
}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: virtual_account_helper.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation