Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-570.21.1.el9_6.x86_64

PHP Version:

8.2.28

User:

u612101220

Directory:

/home/u612101220/domains/esgpos.shop/public_html/tabulation

Free Space:

9.72 TB

🔧 Quick Actions

✏️ Editing: fetch_vote_councilor.php

<?php
include("controller/config.php");
session_start();

// Query to get the total vote count for each candidate in each position
$vote_query = "SELECT position.position_name, candidate.fullname, candidate.party, SUM(votes.vote_count) AS total_votes
               FROM votes
               INNER JOIN candidate ON votes.candidate_id = candidate.candidate_id
               INNER JOIN position ON candidate.position_id = position.position_id WHERE position.position_name = 'Councilors'
               GROUP BY position.position_id, votes.candidate_id
               ORDER BY position.position_id, position.position_name, total_votes DESC"; // Order by total_votes in descending order

$stmt = $conn->prepare($vote_query);
$stmt->execute();
$vote_result = $stmt->get_result();

// Initialize an array to hold the vote data grouped by position
$vote_data = [];

while ($vote = $vote_result->fetch_assoc()) {
    $position_name = $vote['position_name'];
    $fullname = $vote['fullname'];
    $party = $vote['party']; // Store the party here
    $total_votes = $vote['total_votes'];

// Group vote data by position
    if (!isset($vote_data[$position_name])) {
        $vote_data[$position_name] = [];
    }

$vote_data[$position_name][] = [
        'candidate_name' => $fullname,
        'party' => $party, // Add party to the array
        'total_votes' => $total_votes
    ];
}

<div class="row" id="vote-results">
    <?php foreach ($vote_data as $position_name => $candidates): ?>
        <div class="col pb-4">
            <div class="flex justify-between items-center">
                <div class="bg-blue-900 text-white px-4 py-2 rounded-t-lg">
                    <h1 class="text-xl text-white font-bold"><?php echo $position_name; ?></h1>
                </div>
            </div>
            <div class="bg-white p-4 rounded-lg shadow-md">
                <p class="text-gray-600">BASISTA, PANGASINAN</p>
                <p class="text-gray-500 text-sm">Partial, unofficial results aggregated from Comelec data</p>
                <div class="mt-4">
                    <?php foreach ($candidates as $index => $candidate): ?>
                        <div class="bg-gray-100 p-4 rounded-lg mb-4">
                            <div class="flex justify-between items-center">
                                <div class="text-lg font-bold">
                                    <?php
                                    // Display the rank (1st, 2nd, 3rd)
                                    $rank = $index + 1;
                                    $last_digit = $rank % 10;
                                    $last_two_digits = $rank % 100;

if ($last_two_digits >= 11 && $last_two_digits <= 13) {
                                        $suffix = "th";
                                    } else {
                                        switch ($last_digit) {
                                            case 1:
                                                $suffix = "st";
                                                break;
                                            case 2:
                                                $suffix = "nd";
                                                break;
                                            case 3:
                                                $suffix = "rd";
                                                break;
                                            default:
                                                $suffix = "th";
                                                break;
                                        }
                                    }

echo $rank . "<sup class='pr-2'>" . $suffix . "</sup> " . $candidate['candidate_name'] . " (" . $candidate['party'] . ")";
                                    ?>
                                </div>
                                <div class="text-2xl font-bold text-blue-900"><?php echo number_format($candidate['total_votes']); ?> <span class="text-gray-600 text-lg">Votes</span></div>
                            </div>
                            <div class="w-full bg-gray-300 h-2 rounded-full mt-2">
                                <div class="bg-blue-900 h-2 rounded-full" style="width: <?php echo min(100, ($candidate['total_votes'] / 16000) * 100); ?>%;"></div>
                            </div>
                        </div>
                    <?php endforeach; ?>
                </div>
            </div>
        </div>
    <?php endforeach; ?>
</div>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: fetch_vote_councilor.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation