MAINHACK

Viewing / Editing File: protocolfile.php

<?php 
use PhpOffice\PhpSpreadsheet\IOFactory;
require 'vendor/autoload.php'; // make sure this path is correct

include("../functions.php");
 if(!isset($_SESSION['dbmail_Xw211qAAsq4'])){
     header("location:../auth-login");
 } else {
   $s_code = $_SESSION['s_code_Xw2119904'];
        $uname = $_SESSION['name_Xw2119904'];
$stmt = $con->prepare("SELECT * FROM schools WHERE user_name = ? AND school_code = ?");
$stmt->execute(array($uname, $s_code));
$userstatus = $stmt->fetchAll();

// Initialize $namee to prevent potential errors
$namee = null;

foreach ($userstatus as $sta) {
    $namee = $sta['user_name'];
    $userid = $sta['id'];
    $school_name = $sta['school_name'];
}

$stmt = $con->prepare("Select * from schools where school_code = ?");
$stmt->execute(array($s_code));
$row = $stmt->fetch();
$logo = $row['logo'];

if(empty($logo)){
      header("Location:complete-process");
    } else {

$message = "";

function generateUniqueProtocolCode1($new) {
    do {
        // Generate a random 6-character alphanumeric string
        $randomString = substr(str_shuffle("0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ"), 0, 6);
        
        // Check if the protocol code already exists in the database
        $query = "SELECT protocol_code FROM enrol_generic WHERE protocol_code = '$randomString'";
        $result = mysqli_query($new, $query);
    } while (mysqli_num_rows($result) > 0); // Repeat until a unique code is found

return $randomString;
}

if (isset($_FILES['excel_file'])) {
    $file = $_FILES['excel_file']['tmp_name'];

try {
        $spreadsheet = IOFactory::load($file);
        $sheet = $spreadsheet->getActiveSheet();
        $rows = $sheet->toArray(null, true, true, true); // Keep all columns (A, B, C...)

foreach ($rows as $key => $data) {
            // Skip header row
            if ($key == 1) continue;

// Skip empty rows
            if (empty(array_filter($data))) continue;

$indexNo     = mysqli_real_escape_string($new, trim($data['A'] ?? ''));
            $stud_name   = mysqli_real_escape_string($new, trim($data['B'] ?? ''));
            $gender      = mysqli_real_escape_string($new, trim($data['C'] ?? ''));
            $grade       = (int)($data['D'] ?? 0);
            $programme   = mysqli_real_escape_string($new, trim($data['E'] ?? ''));
            $tack        = mysqli_real_escape_string($new, trim($data['F'] ?? ''));
            $status      = mysqli_real_escape_string($new, trim($data['G'] ?? ''));

if (empty($indexNo) || empty($stud_name)) continue;

$studentform1 = test_input($_POST['studentform']);
            $semester     = test_input($_POST['semester']);
            $academicyear1 = test_input($_POST['academicyear']);

$checkQuery = "SELECT indexNo FROM enrol_generic WHERE indexNo = '$indexNo'";
            $checkResult = mysqli_query($new, $checkQuery);

if (mysqli_num_rows($checkResult) > 0) {
                continue; // skip duplicates silently or log
            }

$protocol_code = generateUniqueProtocolCode1($new);

$sql = "INSERT INTO enrol_generic 
                    (indexNo, stud_name, gender, grade, programme, tack, status, s_code, protocol_code, sem, academicyear, form) 
                    VALUES ('$indexNo', '$stud_name', '$gender', $grade, '$programme', '$tack', '$status', 
                            '$s_code', '$protocol_code', '$semester', '$academicyear1', '$studentform1')";

if (!mysqli_query($new, $sql)) {
                echo 'Error inserting row ' . ($key + 1) . ': ' . mysqli_error($new) . '<br>';
            }
        }

echo "<script>
        document.addEventListener('DOMContentLoaded', function() {
            Swal.fire({
                title: 'Success!',
                text: 'Excel data uploaded successfully.',
                icon: 'success',
                confirmButtonText: 'OK'
            });
        });
        </script>";

} catch (Exception $e) {
        echo "<script>
        document.addEventListener('DOMContentLoaded', function() {
            Swal.fire({
                title: 'Error!',
                text: 'Failed to read Excel file: " . addslashes($e->getMessage()) . "',
                icon: 'error',
                confirmButtonText: 'OK'
            });
        });
        </script>";
    }
}

// if (isset($_FILES['csv_file'])) {
//     $file = $_FILES['csv_file']['tmp_name'];

//     $handle = fopen($file, "r");

//     if ($handle !== FALSE) {
//         while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {

//             // Skip completely empty rows
//             if (empty(array_filter($data))) {
//                 continue;
//             }

//             $indexNo = mysqli_real_escape_string($new, $data[0]);
//             $stud_name = mysqli_real_escape_string($new, $data[1]);
//             $gender = mysqli_real_escape_string($new, $data[2]);
//             $grade = (int) $data[3];
//             $programme = mysqli_real_escape_string($new, $data[4]);
//             $tack = mysqli_real_escape_string($new, $data[5]);
//             $status = mysqli_real_escape_string($new, $data[6]);
//             $phonenumber = mysqli_real_escape_string($new, trim($data[7]));

//             $studentform1 = test_input($_POST['studentform']);
//             $semester = test_input($_POST['semester']);
//             $academicyear1 = test_input($_POST['academicyear']);

//             // Check if indexNo already exists
//             $checkQuery = "SELECT indexNo FROM enrol_generic WHERE indexNo = '$indexNo'";
//             $checkResult = mysqli_query($new, $checkQuery);

//             if (mysqli_num_rows($checkResult) > 0) {
//                 // If indexNo already exists, skip insertion and show alert
//                 echo "<script>
//                 document.addEventListener('DOMContentLoaded', function() {
//                 Swal.fire({
//                     title: 'Warning!',
//                     text: 'Duplicate index number found: $indexNo. Skipping this entry.',
//                     icon: 'warning',
//                     confirmButtonText: 'OK'
//                 });
//                 });
//                 </script>";
//                 continue; // Skip to the next row in the CSV
//             }

//             // Generate a unique protocol code for the student
//             $protocol_code = generateUniqueProtocolCode1($new);

//             // Insert the data into the database
//             $sql = "INSERT INTO enrol_generic 
//                     (indexNo, stud_name, gender, grade, programme, tack, status, s_code, protocol_code, sem, academicyear,form,phonenumber) 
//                     VALUES ('$indexNo', '$stud_name', '$gender', $grade, '$programme', '$tack', '$status', 
//                             '$s_code', '$protocol_code', '$semester', '$academicyear1','$studentform1','$phonenumber')";

//             if (!mysqli_query($new, $sql)) {
//                 echo "Error inserting row: " . mysqli_error($new) . "<br>";
//             }
//         }
//         fclose($handle);

//         echo "<script>
//         document.addEventListener('DOMContentLoaded', function() {
//         Swal.fire({
//             title: 'Success!',
//             text: 'Data uploaded successfully.',
//             icon: 'success',
//             confirmButtonText: 'OK'
//         });
//         });
//         </script>";
//     } else {
//         echo "<script>
//         document.addEventListener('DOMContentLoaded', function() {
//         Swal.fire({
//             title: 'Error!',
//             text: 'Failed to insert data.',
//             icon: 'error',
//             confirmButtonText: 'OK'
//         });
//         });
//         </script>";
//     }
// }
}
}
?>
<!doctype html>
<html lang="en">
<head>
<meta charset="utf-8" />
<title>Admission setup | Admission setup </title>
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta content="eliosof" name="author" />

<link rel="stylesheet" href="assets/css/preloader.min.css" type="text/css" />

<link href="assets/css/bootstrap.min.css" id="bootstrap-style" rel="stylesheet" type="text/css" />

<link href="assets/css/icons.min.css" rel="stylesheet" type="text/css" />

<link href="assets/css/app.min.css" id="app-style" rel="stylesheet" type="text/css" />
  <link href="assets/libs/sweetalert2/sweetalert2.min.css" rel="stylesheet" type="text/css" />

</head>

<body>

<div id="layout-wrapper">

<?php include("includes/header.php");?>

<?php include("includes/sidebar.php");?>

<div class="row">
<div class="col-12">
<div class="page-title-box d-sm-flex align-items-center justify-content-between">
<h4 class="mb-sm-0 font-size-18">UPLOAD PROTOCOL LIST</h4>

<div class="page-title-right">
<ol class="breadcrumb m-0">
<li class="breadcrumb-item"><a href="javascript: void(0);">Home</a></li>
<li class="breadcrumb-item active">UPLOAD PROTOCOL LIST</li>
</ol>
</div>

</div>
</div>
</div>

<button class="btn btn-success">
    <a href="CSSPS-List-protocol.xlsx" style="color:white">Download template (CSV)</a>
</button>
<br  /><br  />
<div class="col-md-6 col-lg-6"> 
<form  method="POST" enctype="multipart/form-data">

<div class="mb-4">
                <select class="form-control" name="academicyear" required>
                <option value="">---ACADEMIC YEAR---</option>
                   <option value="2025/2026" selected>2025/2026</option>
                </select>
                    </div>

<div class="mb-4">
                <label for="exampleInputEmail1" class="form-label">Select Semester</label>
                <select class="form-control" name="semester" required>
                <option value="">---SELECT---</option>
                <?php 
                $selectt = mysqli_query($new,"SELECT * FROM semester WHERE s_code = '$s_code'");
                while ($getdataa = mysqli_fetch_array($selectt)) {
                ?>
                <option value="<?php echo $getdataa['semester'];?>"><?php echo $getdataa['semester'];?></option>
                <?php }?>
                </select>
                </div>

<div class="mb-4">
                <label for="exampleInputEmail1" class="form-label">Student form</label>
                <select class="form-control" name="studentform" required>
                <option value="">---FORM---</option>
                <option value="FORM1" selected>FORM ONE</option>
                </select>
                </div>

<div class="mb-4">
<label for="exampleInputEmail1" class="form-label">Choose file</label>

<input type="file" name="excel_file" accept=".xlsx,.xls" required>
</div>
<button type="submit"  class="btn btn-primary">Submit</button>
</form>
<br /><br/>
</div>

</div>

<?php include("includes/footer.php");?>
</div>

</div>

<div class="right-bar">
<div data-simplebar class="h-100">
<div class="rightbar-title d-flex align-items-center p-3">

<h5 class="m-0 me-2">Theme Customizer</h5>

<hr class="m-0" />

<div class="p-4">
<h6 class="mb-3">Layout</h6>
<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="layout"
id="layout-vertical" value="vertical">
<label class="form-check-label" for="layout-vertical">Vertical</label>
</div>
<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="layout"
id="layout-horizontal" value="horizontal">
<label class="form-check-label" for="layout-horizontal">Horizontal</label>
</div>

<h6 class="mt-4 mb-3 pt-2">Layout Mode</h6>

<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="layout-mode"
id="layout-mode-light" value="light">
<label class="form-check-label" for="layout-mode-light">Light</label>
</div>
<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="layout-mode"
id="layout-mode-dark" value="dark">
<label class="form-check-label" for="layout-mode-dark">Dark</label>
</div>

<h6 class="mt-4 mb-3 pt-2">Layout Width</h6>

<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="layout-width"
id="layout-width-fuild" value="fuild" onchange="document.body.setAttribute('data-layout-size', 'fluid')">
<label class="form-check-label" for="layout-width-fuild">Fluid</label>
</div>
<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="layout-width"
id="layout-width-boxed" value="boxed" onchange="document.body.setAttribute('data-layout-size', 'boxed')">
<label class="form-check-label" for="layout-width-boxed">Boxed</label>
</div>

<h6 class="mt-4 mb-3 pt-2">Layout Position</h6>

<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="layout-position"
id="layout-position-fixed" value="fixed" onchange="document.body.setAttribute('data-layout-scrollable', 'false')">
<label class="form-check-label" for="layout-position-fixed">Fixed</label>
</div>
<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="layout-position"
id="layout-position-scrollable" value="scrollable" onchange="document.body.setAttribute('data-layout-scrollable', 'true')">
<label class="form-check-label" for="layout-position-scrollable">Scrollable</label>
</div>

<h6 class="mt-4 mb-3 pt-2">Topbar Color</h6>

<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="topbar-color"
id="topbar-color-light" value="light" onchange="document.body.setAttribute('data-topbar', 'light')">
<label class="form-check-label" for="topbar-color-light">Light</label>
</div>
<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="topbar-color"
id="topbar-color-dark" value="dark" onchange="document.body.setAttribute('data-topbar', 'dark')">
<label class="form-check-label" for="topbar-color-dark">Dark</label>
</div>

<h6 class="mt-4 mb-3 pt-2 sidebar-setting">Sidebar Size</h6>

<div class="form-check sidebar-setting">
<input class="form-check-input" type="radio" name="sidebar-size"
id="sidebar-size-default" value="default" onchange="document.body.setAttribute('data-sidebar-size', 'lg')">
<label class="form-check-label" for="sidebar-size-default">Default</label>
</div>
<div class="form-check sidebar-setting">
<input class="form-check-input" type="radio" name="sidebar-size"
id="sidebar-size-compact" value="compact" onchange="document.body.setAttribute('data-sidebar-size', 'md')">
<label class="form-check-label" for="sidebar-size-compact">Compact</label>
</div>
<div class="form-check sidebar-setting">
<input class="form-check-input" type="radio" name="sidebar-size"
id="sidebar-size-small" value="small" onchange="document.body.setAttribute('data-sidebar-size', 'sm')">
<label class="form-check-label" for="sidebar-size-small">Small (Icon View)</label>
</div>

<h6 class="mt-4 mb-3 pt-2 sidebar-setting">Sidebar Color</h6>

<div class="form-check sidebar-setting">
<input class="form-check-input" type="radio" name="sidebar-color"
id="sidebar-color-light" value="light" onchange="document.body.setAttribute('data-sidebar', 'light')">
<label class="form-check-label" for="sidebar-color-light">Light</label>
</div>
<div class="form-check sidebar-setting">
<input class="form-check-input" type="radio" name="sidebar-color"
id="sidebar-color-dark" value="dark" onchange="document.body.setAttribute('data-sidebar', 'dark')">
<label class="form-check-label" for="sidebar-color-dark">Dark</label>
</div>
<div class="form-check sidebar-setting">
<input class="form-check-input" type="radio" name="sidebar-color"
id="sidebar-color-brand" value="brand" onchange="document.body.setAttribute('data-sidebar', 'brand')">
<label class="form-check-label" for="sidebar-color-brand">Brand</label>
</div>

<h6 class="mt-4 mb-3 pt-2">Direction</h6>

</div>

</div> 
</div>

<div class="rightbar-overlay"></div>

<script src="assets/libs/jquery/jquery.min.js"></script>
<script src="assets/libs/bootstrap/js/bootstrap.bundle.min.js"></script>
<script src="assets/libs/metismenu/metisMenu.min.js"></script>
<script src="assets/libs/simplebar/simplebar.min.js"></script>
<script src="assets/libs/node-waves/waves.min.js"></script>
<script src="assets/libs/feather-icons/feather.min.js"></script>

<script src="assets/libs/pace-js/pace.min.js"></script>
<script src="assets/libs/sweetalert2/sweetalert2.min.js"></script>
<script src="assets/js/app.js"></script>
<script src="assets/js/pages/validation.init.js"></script>

</body>
</html>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: protocolfile.php

Server Info

System Features

User Info