Server : Apache System : Linux 122.228.205.92.host.secureserver.net 5.14.0-362.18.1.el9_3.x86_64 #1 SMP PREEMPT_DYNAMIC Mon Jan 29 07:05:48 EST 2024 x86_64 User : ondostategov ( 1002) PHP Version : 8.1.33 Disable Function : NONE Directory : /home/ondostategov/public_html/scholarshipboardondostate/ossms/ |
<?php
//ob_start();
session_start();
require_once 'conn.php';
// if session is not set this will redirect to login page
if( !isset($_SESSION['user_id']) ) {
header("Location: index.php");
exit;
}
$res2=mysqli_query( $conn, "SELECT * FROM scholarship WHERE user_id=".$_SESSION['user_id']);
$userRow2=mysqli_fetch_array($res2);
$completed = $userRow2['completed'];
if($completed == 1){
header("Location: dashboard_overview.php");
}
// select loggedin users detail
$user_id = $_SESSION['user_id'];
$res1=mysqli_query( $conn, "SELECT * FROM registration WHERE user_id=".$_SESSION['user_id']);
$userRow1=mysqli_fetch_array($res1);
if(isset($_REQUEST['link'])){
$document_id = $_REQUEST['link'];
$res=mysqli_query( $conn, "SELECT * FROM uploaded_documents WHERE document_id=".$document_id);
$row=mysqli_fetch_array($res);
$document_path = $row['document_path'];
$res1=mysqli_query( $conn, "DELETE FROM uploaded_documents WHERE document_id=".$document_id);
if($document_path)
{
unlink($document_path);
}
}
?>
<!doctype html>
<html>
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title>Ondo State Scholarship Board</title>
<style><!--
body{
font-family:Arial, Helvetica, sans-serif;
}
h1{
font-family:'Georgia', Times New Roman, Times, serif;
}
--></style>
<!-- Custom-Files -->
<link type="text/css" rel="stylesheet" href="bootstrap-3.2.0-dist/css/bootstrap.css">
<link href="images/ondologo.png" rel="icon" type="image/jpg"/>
<link href="css/w3.css" rel="stylesheet" type="text/css">
<link href="date/tcal.css" rel="stylesheet" type="text/css">
<link href="css/w3colors.css" rel="stylesheet" type="text/css">
<link href="css/custom.css" rel="stylesheet" type="text/css">
<script type="text/javascript" src="date/tcal.js"></script>
<script>
function verifyDelete(){
msg = "Are you sure you want to Delete? \nClick OK to Delete or Cancel to keep record";
return confirm(msg);
}
</script>
<!-- Web-Fonts -->
<link href="//fonts.googleapis.com/css?family=Roboto+Condensed:300,300i,400,400i,700,700i&subset=cyrillic,cyrillic-ext,greek,greek-ext,latin-ext,vietnamese"
rel="stylesheet">
<link href="//fonts.googleapis.com/css?family=Open+Sans:300,300i,400,400i,600,600i,700,700i,800,800i" rel="stylesheet">
<!-- //Web-Fonts -->
</head>
<body class="w3-container">
<!--header div -->
<div class="w3-container ">
<div class="w3-container w3-card w3-text-black w3-dark-grey">
<div class="w3-half">
<h1 class="w3-container w3-text-black" style=" font-style:italic; font-weight:bold; font-size:40px"><img src="images/ondologo.PNG" alt="Ondo State Logo" width="100" style="border-radius:10px"> OSSMS</h1>
<h6 class="w3-container">Ondo State Scholarship Management System</h6>
</div>
<div class="w3-half" style="padding-top:73px">
<h6 class="w3-right w3-container">
<?php
echo $userRow1['surname']. ' '. $userRow1['firstname'] . ' [' .$userRow1['email'] . ']';
?>
</h6>
</div>
</div>
<div class="w3-container w3-card w3-grey" >
<div class="w3-left w3-hide-small">
<a href="index.php" class="w3-bar-item w3-button">HOME</a>
</div>
<div class="w3-bar-item w3-right">
<a href="logout.php" class="w3-button" >LOGOUT</a>
</div>
</div>
</div>
<!-- end header div-->
<br>
<!-- scholarship plan -->
<div class="w3-container ">
<div class="w3-card-4">
<div class="w3-container w3-light-grey">
<h2>Dashboard</h2>
</div>
<br>
<div class="w3-container">
<div class="w3-quarter w3-padding">
<a href="dashboard_personal_data.php" style=" text-decoration:none"><div class="w3-row w3-padding w3-border-top w3-border-bottom w3-light-grey w3-hover-grey ">PERSONAL INFORMATION</div></a>
<a href="dashboard_additional_info.php" style=" text-decoration:none"><div class="w3-row w3-padding w3-border-top w3-border-bottom w3-light-grey w3-hover-grey">ADDITIONAL INFORMATION</div></a>
<a href="dashboard_passport_photograph.php" style=" text-decoration:none"><div class="w3-row w3-padding w3-border-top w3-border-bottom w3-light-grey w3-hover-grey">PASSPORT PHOTOGRAPH</div></a>
<a href="dashboard_undergraduate_detail.php" style=" text-decoration:none"><div class="w3-row w3-padding w3-border-top w3-border-bottom w3-light-grey w3-hover-grey">UNDERGRADUATE LEVEL</div></a>
<a href="dashboard_document.php" style=" text-decoration:none"><div class="w3-row w3-padding w3-border-top w3-border-bottom w3-grey w3-hover-grey ">DOCUMENTS</div></a>
<a href="dashboard_bank_detail.php" style=" text-decoration:none"><div class="w3-row w3-padding w3-border-top w3-border-bottom w3-light-grey w3-hover-grey">BANK DETAILS</div></a>
</div>
<div class="w3-threequarter">
<form class="w3-container" method="post" action="process_document.php" enctype="multipart/form-data">
<div class="w3-row w3-padding">
<h3>
<b>Documents </b><br> <h4>All documents on the list below are <strong>IMPORTANT</strong> for you to upload.<br><br>
<i>Click on the button below to download attestation form(s) for Bursary (if you are applying for bursary) or Scholarship (if you are applying for scholarship).</i><br><br>
<div>
<div>
<a href="Attestation_Form/Bursary Attestation.pdf" class="w3-btn w3-left w3-dark-green w3-light-green">Bursary</a>
</div>
<div>
<a href="Attestation_Form/Scholarship Attestation Form.pdf" class="w3-btn w3-left w3-dark-grey w3-light-grey">Scholarship</a>
</div>
</div>
<br><br><br>
Documents are expected to be either JPEG, MS Word (*.doc or *.docx) or PDF format and no larger than 500kb in size.</h4>
</h3>
<h4>
<?php
if(isset($_SESSION['err_msg']))
{
?>
<div class="alert alert-danger">
<span><center>
<?php echo $_SESSION['err_msg'];
unset($_SESSION['err_msg']);
?>
</center></span>
</div>
<?php
} else
if(isset($_SESSION['success_msg']))
{
?>
<div class="alert alert-success">
<span><center>
<?php echo $_SESSION['success_msg'];
unset($_SESSION['success_msg']);
?>
</center></span>
</div>
<?php
}?></h4>
</div>
<div class="w3-row">
<div class="w3-half w3-padding" >Document
<select class="w3-select w3-round w3-border" name="document_name">
<option value="0" disabled selected>Select Document To Upload --</option>
<option value="1">Birth Certificate</option>
<option value="2">Proof of Local Government Area of Origin</option>
<option value="3">Letter of Admission</option>
<option value="4">School ID Card</option>
<option value="5">Valid ID Card</option>
<option value="6">Bursary Attestation Form</option>
<option value="7">Scholarship Attestation Form</option>
<option value="8">Transcript or Signed Statement of Result</option>
</select>
</div>
<div class="w3-half w3-padding"; style = "padding-right:100px">Select Document File<br><input type="file" name="document" style=" height:40px" id="document"/></div>
</div>
<div class="w3-row">
<div class="w3-third w3-padding" style="text-align:right;"><button class="w3-btn w3-left w3-dark-grey w3-hover-grey" name="upload">Add</button></div>
</div>
<div class="w3-row">
<div class="w3-half w3-padding"><h4><b>Documents Uploaded</b></h4></div>
<div class="w3-half w3-padding" style="color:#F60"><h4>Ensure that the uploaded documents show in the table below.</h4></div>
</div>
<div class="w3-row w3-padding">
<table class="w3-table w3-striped w3-hover w3-border">
<tr>
<th>S/N</th>
<th>Document Name</th>
<th>View Document</th>
</tr>
<?php
$res2=mysqli_query( $conn, "SELECT * FROM uploaded_documents WHERE user_id=".$_SESSION['user_id']);
$sn=1;
while($row = mysqli_fetch_array($res2)){
$document_id= $row['document_id'] ;
$document_path=$row['document_path'] ;
$res=mysqli_query( $conn, "SELECT * FROM documents WHERE id= '$document_id' ");
$row=mysqli_fetch_array($res);
$document_name = $row['document_name'];
echo "<tr>
<td>$sn</td>
<td>$document_name</td>
<td><a href='$document_path' target='_blank'>View</a></td>
<td><a href='dashboard_document.php?link=$document_id' onclick='return verifyDelete()'>Delete</a></td>
</tr>";
$sn++;
}
?>
</table>
</div>
<div class> </div>
</form>
</div>
</div>
<br>
</div>
</div>
<!-- end scholarship plan -->
<br>
<!-- footer -->
<div class="w3-container">
<div class="w3-container w3-dark-grey w3-topbar w3-border-grey " >
<div class="w3-row">
<div class=" w3-third">
<p>© 2018 OSSMS</p>
</div>
<div class="w3-third w3-center">
<p>Designed by <a href="www.sita.ondostate.gov.ng"><img src="images/sitaLogo.png" width="60" style="border-radius:10px"></a>
</div>
</div>
</div>
</div>
<!-- end footer -->
<script>
function myFunction(id) {
var x = document.getElementById(id);
if (x.className.indexOf("w3-show") == -1) {
x.className += " w3-show";
} else {
x.className = x.className.replace(" w3-show", "");
}
}
</script>
</body>
</html>