FM / public

/home/u764571690/domains/savitrfoundation.com/public_html/

/home/u764571690/domains/savitrfoundation.com/public_html

Name	Size	Mode	Actions
admin/	-	0755	rm
ajax/	-	0755	rm
api/	-	0755	rm
assets/	-	0755	rm
cache/	-	0755	rm
certificate_view/	-	0755	rm
css/	-	0755	rm
documents_upload/	-	0755	rm
F2/	-	0755	rm
finger data/	-	0755	rm
functions/	-	0755	rm
hts-cache/	-	0755	rm
js/	-	0755	rm
logs/	-	0755	rm
pages/	-	0755	rm
privacy policy/	-	0755	rm
savitrfoundation/	-	0755	rm
scholar/	-	0755	rm
terms and conditions/	-	0755	rm
tmp/	-	0755	rm
uploads/	-	0755	rm
.htaccess	3583	0644	edit dl rm
.htaccess.htaccess	9223	0644	edit dl rm
.user.ini	623	0644	edit dl rm
ads.txt	58	0644	edit dl rm
application.php	41647	0644	edit dl rm
backblue.gif	4243	0644	edit dl rm
careers.php	18402	0644	edit dl rm
fade.gif	828	0644	edit dl rm
how to apply.php	44852	0644	edit dl rm
hts-log.txt	2738	0644	edit dl rm
index.php	50	0644	edit dl rm
ngo_account_open.php	27984	0644	edit dl rm
our_scholars.php	11882	0644	edit dl rm
php.ini	617	0644	edit dl rm
reupload_document.php	6038	0644	edit dl rm
robots.txt	291	0644	edit dl rm
scholarshipapply.php	219769	0644	edit dl rm
scholarshipportal.php	89993	0644	edit dl rm
sendmail.php	2720	0644	edit dl rm
sitemap.xml	3743	0644	edit dl rm
submit-internship-application.php	8856	0644	edit dl rm
sw.js	156	0644	edit dl rm
upload_document_main.php	6121	0644	edit dl rm

Edit: /home/u764571690/domains/savitrfoundation.com/public_html/our_scholars.php (11882B)

<?php
require_once 'scholar/db.php';
date_default_timezone_set('Asia/Kolkata');

$distributedScholars = [];
$partiallyDistributedScholars = [];

try {
    // ✅ Fully distributed scholars
    $distStmt = $pdo->query("
        SELECT
            a.name,
            a.applicant_id,
            u.user_id,
            a.scheme_name,
            a.scholarship_amount,
            a.institution_name,
            a.course,
            a.year,
            a.class,
            a.city,
            a.state,
            d.document_path as photo_path
        FROM applicants a
        JOIN users u ON a.applicant_id = u.applicant_id
        LEFT JOIN documents d ON a.applicant_id = d.applicant_id AND d.document_type = 'live_photo'
        WHERE a.payment_status = 'Distributed'
        ORDER BY a.name ASC
    ");
    $distributedScholars = $distStmt->fetchAll(PDO::FETCH_ASSOC);

// ✅ Partially distributed scholars
    $partialStmt = $pdo->query("
        SELECT
            a.name,
            a.applicant_id,
            u.user_id,
            a.scheme_name,
            a.payment_step1_status,
            a.payment_step2_status,
            a.payment_step3_status,
            a.payment_step1_amount,
            a.payment_step2_amount,
            a.payment_step3_amount,
            a.institution_name,
            a.course,
            a.year,
            a.class,
            a.city,
            a.state,
            d.document_path as photo_path
        FROM applicants a
        JOIN users u ON a.applicant_id = u.applicant_id
        LEFT JOIN documents d ON a.applicant_id = d.applicant_id AND d.document_type = 'live_photo'
        WHERE (a.payment_step1_status = 'Completed' OR a.payment_step2_status = 'Completed' OR a.payment_step3_status = 'Completed')
        AND a.payment_status != 'Distributed'
        ORDER BY a.name ASC
    ");
    $partiallyDistributedScholars = $partialStmt->fetchAll(PDO::FETCH_ASSOC);

} catch (PDOException $e) {
    echo "<p style='color:red;text-align:center;'>Database Error: " . htmlspecialchars($e->getMessage()) . "</p>";
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
    
    
    <script async src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js?client=ca-pub-6734060461800843"
     crossorigin="anonymous"></script>

</div>
</section>

<?php if (empty($distributedScholars) && empty($partiallyDistributedScholars)): ?>
<div class="no-scholars"><p>No scholarships distributed yet.</p></div>
<?php else: ?>

<?php if (!empty($distributedScholars)): ?>
<div class="scholars-section">
<h2>Fully Distributed Scholarships</h2>
<?php foreach ($distributedScholars as $scholar): ?>
<div class="scholar-card">
<?php if (!empty($scholar['photo_path'])): ?>
<img src="documents_upload/view_live_photo.php?id=<?php echo $scholar['applicant_id']; ?>&t=<?php echo time(); ?>"
     alt="<?php echo htmlspecialchars($scholar['name']); ?>" class="scholar-photo"
     onerror="this.onerror=null;this.style.display='none';this.nextElementSibling.style.display='flex';">
<div class="scholar-photo-placeholder" style="display:none;"><?php echo strtoupper(substr($scholar['name'],0,1)); ?></div>
<?php else: ?>
<div class="scholar-photo-placeholder"><?php echo strtoupper(substr($scholar['name'],0,1)); ?></div>
<?php endif; ?>

<div class="scholar-info">
 <div class="scholar-name"><?php echo htmlspecialchars($scholar['name']); ?></div>
 <div class="scholar-details">
 <strong>Scheme:</strong> <?php echo htmlspecialchars($scholar['scheme_name']); ?><br>
 <?php if (!empty($scholar['course'])): ?><strong>Course:</strong> <?php echo htmlspecialchars($scholar['course']); ?><br><?php endif; ?>
 <?php if (!empty($scholar['year']) || !empty($scholar['class'])): ?><strong>Year:</strong> <?php echo !empty($scholar['class']) ? htmlspecialchars($scholar['class']) : (!empty($scholar['year']) ? htmlspecialchars($scholar['year']) : 'N/A'); ?><br><?php endif; ?>
 <?php if (!empty($scholar['institution_name'])): ?><strong>Institution:</strong> <?php echo htmlspecialchars($scholar['institution_name']); ?><br><?php endif; ?>
 <?php if (!empty($scholar['city'])): ?><strong>Location:</strong> <?php echo htmlspecialchars($scholar['city']); ?><?php if (!empty($scholar['state'])): ?>, <?php echo htmlspecialchars($scholar['state']); ?><?php endif; ?><?php endif; ?>
 </div>
 </div>
 <div class="scholar-amount full">₹<?php echo number_format((float)$scholar['scholarship_amount'],0); ?></div>
</div>
<?php endforeach; ?>
</div>
<?php endif; ?>

<?php if (!empty($partiallyDistributedScholars)): ?>
<div class="scholars-section">
<h2>Partially Distributed Scholarships</h2>
<?php foreach ($partiallyDistributedScholars as $scholar): ?>
<?php
$totalAmount = 0;
if ($scholar['payment_step1_status'] === 'Completed') $totalAmount += (float)($scholar['payment_step1_amount'] ?? 0);
if ($scholar['payment_step2_status'] === 'Completed') $totalAmount += (float)($scholar['payment_step2_amount'] ?? 0);
if ($scholar['payment_step3_status'] === 'Completed') $totalAmount += (float)($scholar['payment_step3_amount'] ?? 0);
?>
<div class="scholar-card">
<?php if (!empty($scholar['photo_path'])): ?>
<img src="documents_upload/view_live_photo.php?id=<?php echo $scholar['applicant_id']; ?>&t=<?php echo time(); ?>"
     alt="<?php echo htmlspecialchars($scholar['name']); ?>" class="scholar-photo"
     onerror="this.onerror=null;this.style.display='none';this.nextElementSibling.style.display='flex';">
<div class="scholar-photo-placeholder" style="display:none;"><?php echo strtoupper(substr($scholar['name'],0,1)); ?></div>
<?php else: ?>
<div class="scholar-photo-placeholder"><?php echo strtoupper(substr($scholar['name'],0,1)); ?></div>
<?php endif; ?>

<div class="scholar-info">
 <div class="scholar-name"><?php echo htmlspecialchars($scholar['name']); ?></div>
 <div class="scholar-details">
 <strong>Scheme:</strong> <?php echo htmlspecialchars($scholar['scheme_name']); ?><br>
 <?php if (!empty($scholar['course'])): ?><strong>Course:</strong> <?php echo htmlspecialchars($scholar['course']); ?><br><?php endif; ?>
 <?php if (!empty($scholar['year']) || !empty($scholar['class'])): ?><strong>Year:</strong> <?php echo !empty($scholar['class']) ? htmlspecialchars($scholar['class']) : (!empty($scholar['year']) ? htmlspecialchars($scholar['year']) : 'N/A'); ?><br><?php endif; ?>
 <?php if (!empty($scholar['institution_name'])): ?><strong>Institution:</strong> <?php echo htmlspecialchars($scholar['institution_name']); ?><br><?php endif; ?>
 <?php if (!empty($scholar['city'])): ?><strong>Location:</strong> <?php echo htmlspecialchars($scholar['city']); ?><?php if (!empty($scholar['state'])): ?>, <?php echo htmlspecialchars($scholar['state']); ?><?php endif; ?><?php endif; ?>
 </div>
 </div>
 <div class="scholar-amount partial">₹<?php echo number_format($totalAmount,0); ?></div>
</div>
<?php endforeach; ?>
</div>
<?php endif; ?>

<?php endif; ?>
</div>

</body>
</html>

cmd: