File "home.php"

Full Path: /home/leadltht/fastlinkinternet.com/administrator/data-provider/admin/home.php
File size: 10.9 KB
MIME-type: text/x-php
Charset: utf-8

<?php
// Enable error reporting for debugging
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);

require_once('reports/common_functions.php'); // Ensure this file includes calculateClientDetails function
require_once('/home/leadltht/fastlinkinternet.com/administrator/data-provider/config.php');

if (session_status() == PHP_SESSION_NONE) {
    session_start();
}

// Check if user type is set in session
if (!isset($_SESSION['userdata']['type'])) {
    echo '<center>Unknown User Type</center>';
    exit;
}

$type = $_SESSION['userdata']['type'];

// Calculate Piso WiFi Collection This Month
$current_month = date('m');
$current_year = date('Y');
$piso_wifi_query = "SELECT SUM(owner_share) as total FROM harvest_collection WHERE MONTH(harvested_date) = ? AND YEAR(harvested_date) = ?";
$stmt = $conn->prepare($piso_wifi_query);
$stmt->bind_param("ii", $current_month, $current_year);
$stmt->execute();
$piso_wifi_result = $stmt->get_result();
$piso_wifi_collection = $piso_wifi_result->fetch_assoc()['total'] ?? 0;
$stmt->close();
?>

<?php if ($type == 2): ?>
    <div class="container-fluid">
        <div class="row justify-content-center">
            <div class="col-md-6 text-center">
                <div class="card">
                    <div class="card-body">
                        <h3 class="card-title">Notice</h3>
                        <p class="card-text">Click the <strong>Collection List</strong> to Add New Collection.</p>
                    </div>
                </div>
            </div>
        </div>
    </div>
<?php elseif ($type == 3): ?>
    <div class="container-fluid">
        <div class="row justify-content-center">
            <div class="col-md-6 text-center">
                <div class="card">
                    <div class="card-body">
                        <h3 class="card-title">Notice</h3>
                        <p class="card-text">Get Your <strong>Statement of Account</strong> to Know Your Account Balance.</p>
                        <p class="card-text">Click the <strong>3 Bars</strong> Above.</p>
                    </div>
                </div>
            </div>
        </div>
    </div>
<?php elseif ($type == 4): ?>
    <div class="container-fluid">
        <div class="row justify-content-center">
            <div class="col-md-6 text-center">
                <div class="card">
                    <div class="card-body">
                        <h3 class="card-title">Notice</h3>
                        <p class="card-text">Check Your <strong>Assignments</strong> and fix it ASAP.</p>
                        <p class="card-text">Click the <strong>3 Bars</strong> Above.</p>
                    </div>
                </div>
            </div>
        </div>
    </div>
<?php else: ?>
    <h1 class="">Welcome to <?php echo $_settings->info('name') ?> Dashboard as of <?= date('F Y'); ?></h1>
    <style>
      #cover-image {
        width: calc(100%);
        height: 50vh;
        object-fit: cover;
        object-position: center center;
      }
      .info-box-container {
        display: flex;
        flex-wrap: wrap;
        justify-content: space-around;
      }
      .info-box-container .info-box {
        flex: 1 0 23%; /* Adjust this value as needed */
        margin: 10px 5px;
        box-sizing: border-box;
      }
    </style>
    <hr>
    <div class="row info-box-container">
      <div class="col-12 col-sm-6 col-md-3">
        <div class="info-box">
          <span class="info-box-icon bg-gradient-warning border elevation-1"><i class="fas fa-coins"></i></span>
          <div class="info-box-content">
            <span class="info-box-text">Collection This Month</span>
            <span class="info-box-number text-right h4">
              <?php 
                $result = $conn->query("SELECT sum(total_amount) as total FROM collection_list where date_format(date_collected,'%Y-%m') = '".date('Y-m')."'");
                if ($result) {
                    $total = $result->fetch_assoc()['total'];
                    $total = $total > 0 ? $total : 0;
                    echo '₱'. format_num($total);
                } else {
                    echo "Error: " . $conn->error;
                }
              ?>
            </span>
          </div>
        </div>
      </div>

      <div class="col-12 col-sm-6 col-md-3">
        <div class="info-box">
          <span class="info-box-icon bg-gradient-yellow elevation-1"><i class="fas fa-wifi"></i></span>
          <div class="info-box-content">
            <span class="info-box-text">Piso WiFi Collection This Month</span>
            <span class="info-box-number text-right h4">
              <?php 
                echo '₱'. format_num($piso_wifi_collection);
              ?>
            </span>
          </div>
        </div>
      </div>

      <div class="col-12 col-sm-6 col-md-3">
        <div class="info-box">
          <span class="info-box-icon bg-gradient-danger elevation-1"><i class="fas fa-money-bill-wave"></i></span>
          <div class="info-box-content">
            <span class="info-box-text">Expenses This Month</span>
            <span class="info-box-number text-right h4">
              <?php 
                $result = $conn->query("SELECT sum(total_amount) as total FROM expense_list where date_format(expense_date,'%Y-%m') = '".date('Y-m')."'");
                if ($result) {
                    $total = $result->fetch_assoc()['total'];
                    $total = $total > 0 ? $total : 0;
                    echo '₱'. format_num($total);
                } else {
                    echo "Error: " . $conn->error;
                }
              ?>
            </span>
          </div>
        </div>
      </div>

      <div class="col-12 col-sm-6 col-md-3">
        <div class="info-box">
          <span class="info-box-icon bg-gradient-success elevation-1"><i class="fas fa-dollar-sign"></i></span>
          <div class="info-box-content">
            <span class="info-box-text">Net Profit This Month</span>
            <span class="info-box-number text-right h4">
              <?php 
                $collectionResult = $conn->query("SELECT sum(total_amount) as total FROM collection_list where date_format(date_collected,'%Y-%m') = '".date('Y-m')."'");
                $expenseResult = $conn->query("SELECT sum(total_amount) as total FROM expense_list where date_format(expense_date,'%Y-%m') = '".date('Y-m')."'");
                
                $collectionTotal = 0;
                $expenseTotal = 0;

                if ($collectionResult) {
                    $collectionTotal = $collectionResult->fetch_assoc()['total'];
                    $collectionTotal = $collectionTotal > 0 ? $collectionTotal : 0;
                }

                if ($expenseResult) {
                    $expenseTotal = $expenseResult->fetch_assoc()['total'];
                    $expenseTotal = $expenseTotal > 0 ? $expenseTotal : 0;
                }

                $netProfit = ($collectionTotal + $piso_wifi_collection) - $expenseTotal;
                echo '₱'. format_num($netProfit);
              ?>
            </span>
          </div>
        </div>
      </div>
    </div>

    <div class="row info-box-container">
      <div class="col-12 col-sm-6 col-md-3">
        <div class="info-box">
          <span class="info-box-icon bg-gradient-primary elevation-1"><i class="fas fa-th-list"></i></span>
          <div class="info-box-content">
            <span class="info-box-text">Total Servers</span>
            <span class="info-box-number text-right h4">
              <?php 
                $result = $conn->query("SELECT count(id) as total FROM server");
                if ($result) {
                    $total = $result->fetch_assoc()['total'];
                    echo format_num($total);
                } else {
                    echo "Error: " . $conn->error;
                }
              ?>
            </span>
          </div>
        </div>
      </div>

<div class="col-12 col-sm-6 col-md-3">
    <div class="info-box">
        <span class="info-box-icon bg-gradient-light border elevation-1"><i class="fas fa-user-friends"></i></span>
        <div class="info-box-content">
            <span class="info-box-text">Lists of Active Clients</span>
            <span class="info-box-number text-right h4">
              <?php 
                // Modify the query to count only active members
                $result = $conn->query("SELECT count(id) as total FROM member_list WHERE status = 'active'");
                if ($result) {
                    $total = $result->fetch_assoc()['total'];
                    echo format_num($total);
                } else {
                    echo "Error: " . $conn->error;
                }
              ?>
            </span>
        </div>
    </div>
</div>
 <div class="col-12 col-sm-6 col-md-3">
    <div class="info-box">
        <span class="info-box-icon bg-gradient-light border elevation-1"><i class="fas fa-user-friends"></i></span>
        <div class="info-box-content">
            <span class="info-box-text">Lists of Inactive Clients</span>
            <span class="info-box-number text-right h4">
              <?php 
                // Modify the query to count only active members
                $result = $conn->query("SELECT count(id) as total FROM member_list WHERE status = 'inactive'");
                if ($result) {
                    $total = $result->fetch_assoc()['total'];
                    echo format_num($total);
                } else {
                    echo "Error: " . $conn->error;
                }
              ?>
            </span>
        </div>
    </div>
</div>


      
      <div class="col-12 col-sm-6 col-md-3">
        <div class="info-box">
          <span class="info-box-icon bg-gradient-info elevation-1"><i class="fas fa-tags"></i></span>
          <div class="info-box-content">
            <span class="info-box-text">Discounts This Month</span>
            <span class="info-box-number text-right h4">
              <?php 
                $result = $conn->query("SELECT sum(discount_amount) as total FROM collection_list where date_format(date_collected,'%Y-%m') = '".date('Y-m')."'");
                if ($result) {
                    $total = $result->fetch_assoc()['total'];
                    $total = $total > 0 ? $total : 0;
                    echo '₱'. format_num($total);
                } else {
                    echo "Error: " . $conn->error;
                }
              ?>
            </span>
          </div>
        </div>
      </div>
    </div>

    <div class="clear-fix mb-2">
      <div class="text-center w-100">
        <img src="<?= validate_image($_settings->info('cover')) ?>" alt="System Cover image" class="w-100" id="cover-image">
      </div>
    </div>
<?php endif; ?>