FM

FM / [ home ]

name	size	mtime	act
.htaccess	890	2026-11-05 00:10	dl rm
.user.ini	373	2026-10-24 11:46	dl rm
[D] .well-known	-	2026-10-24 11:47
abc_api.php	3296	2026-11-07 07:42	dl rm
abc_api_functions.php	2880	2026-11-07 07:42	dl rm
api_action_call.php	8596	2026-11-07 07:42	dl rm
[D] cgi-bin	-	2026-10-24 11:46
erp_administrative_report_responce_api.php	3316	2026-11-07 07:42	dl rm
[D] ketan	-	2026-11-07 05:32
kingfm.php	33163	2026-11-07 07:42	dl rm
[D] litu_erp	-	2026-11-07 07:47
litu_erp.sql	250602058	2026-11-07 07:25	dl rm
[D] litu_erp_documents	-	2025-06-03 05:23
[D] litu_phd	-	2026-11-07 07:49
[D] litu_rtmnu	-	2026-11-07 07:49
lituerp_phd_db.sql	1398062	2026-11-07 07:26	dl rm
lituerp_rtmnu_db.sql	2974528	2026-11-07 07:26	dl rm
php.ini	373	2026-10-24 11:46	dl rm
university_admission_api.php	7041	2026-11-07 07:42	dl rm
university_exam_registration_api.php	6624	2026-11-07 07:42	dl rm
university_result_api.php	29333	2026-11-07 07:42	dl rm
wafo.php	6681	2026-11-07 07:42	dl rm

edit: university_result_api.php

<?php
require_once ("litu_erp/db_connect.php");
$date = date('Y-m-d');
header("Access-Control-Allow-Origin: *");
header("Access-Control-Allow-Methods: GET, POST, PUT, DELETE, OPTIONS");
header("Access-Control-Allow-Headers: Content-Type, Authorization");
header('Content-Type: application/json');

ini_set('memory_limit', '-1');   
ini_set('display_errors', 1);

error_reporting(E_ALL);
if ($_SERVER['REQUEST_METHOD'] !== 'POST') {
    http_response_code(405); // Method Not Allowed
    echo json_encode(["error" => "Only POST requests are allowed"]);
    exit;
}
function get_branch_details($branch_id)
{
    $sql = "SELECT * FROM `branch_master` WHERE branch_id='$branch_id'";
    $query = mysql_query($sql);
    return $row = mysql_fetch_assoc($query);
}

function get_course_details($course_id)
{
    $sql = "SELECT * FROM `course_master` WHERE course_id='$course_id'";
    $query = mysql_query($sql);
    return $row = mysql_fetch_assoc($query);
}

function get_event_details($event_id)
{
    $sql = "SELECT * FROM `event_master` WHERE event_id='$event_id'";
    $query = mysql_query($sql);
    return $row = mysql_fetch_assoc($query);
}

function get_subject_details($branch_id, $sub_code, $path)
{
    $sql = "SELECT * FROM `subject_master` WHERE branch_id='$branch_id' AND sub_code='$sub_code' AND path='$path'";
    $query = mysql_query($sql);
    return $row = mysql_fetch_assoc($query);
}

function get_student_details($enroll_no)
{
    $sql = "SELECT * FROM `candidate_details_tb` WHERE enroll_no='$enroll_no'";
    $query = mysql_query($sql);
    return $row = mysql_fetch_assoc($query);
}

$upwardData = [];
// Read raw JSON input
$inputJSON = file_get_contents("php://input");
$data = json_decode($inputJSON, true);

// Validate JSON
if ($data === null) {
    http_response_code(400);
    echo json_encode(["error" => "Invalid JSON format"]);
    exit;
}
$uni_code = $data['University_AISHE_Code'];
$exam_season=$data['Exam_Season'];
$exam_year=$data['Exam_Year'];
$lastUpdateDate = $data["lastUpdateDate"];
$event = $exam_season.' '.$exam_year;
$uni_name = 'Laxminarayan Innovation Technological University';
$event_details11="SELECT event_id,acyear,val1,val2 FROM `event_master` WHERE event='$event' ORDER BY event_id ASC";
$event_details1=mysql_query($event_details11);
$event_details = mysql_fetch_assoc($event_details1);
$event_id = $event_details['event_id'];
$acyear = $event_details['acyear'];
$na = '0';
$na2 = 'NA';

$get_data111 = "SELECT * FROM `student_result_eventwise` WHERE event_id='$event_id' AND `dashboard_data_shared_on` = '0000-00-00' ORDER BY branch_id,enroll_no,registration_type";
$get_data11 = mysql_query($get_data111);
while ($get_data1 = mysql_fetch_assoc($get_data11)) {
    $sr_no = $get_data1['sr_no'];
    $enroll_no = $get_data1['enroll_no'];
    $branch_id = $get_data1['branch_id'];
    $reg_type = $get_data1['registration_type'];
    $branch_details = get_branch_details($branch_id);
    $course_id = $branch_details['course_id'];
    $res_dec_date = explode(" ", $get_data1['published_on']);
    $result_declare_date = date("d-m-Y", strtotime($res_dec_date[0]));
    $final_res_status = $get_data1['result_status'];
    
    $stud_details = get_student_details($enroll_no);
    $path = $stud_details['path'];
    $course_details = get_course_details($course_id);
    if ($event_details['val1'] == 'Winter') {
        $val1 = 'December';
    } else {
        $val1 = 'May';
    }
    
    if ($stud_details['physically_handicap'] == 'NA' || $stud_details['physically_handicap'] == '') {
        $physically_handicap = "No";
    } else {
        $physically_handicap = "Yes";
    }

$get_data222 = "SELECT enroll_no,registration_type,COUNT(sub_code) AS sub_cnt FROM `student_result_subjectwise` WHERE event_id='$event_id' AND enroll_no='$enroll_no' AND registration_type='$reg_type'";
    $get_data22 = mysql_query($get_data222);
    $get_data2 = mysql_fetch_assoc($get_data22);
    $cnt = $get_data2['sub_cnt'];

$get_data222 = "SELECT * FROM `student_result_subjectwise` WHERE event_id='$event_id' AND enroll_no='$enroll_no' AND registration_type='$reg_type' ORDER BY ass_method DESC,code1 ASC";
    $get_data22 = mysql_query($get_data222);
    while ($get_data2 = mysql_fetch_assoc($get_data22)) {
        $sub_code = $get_data2['sub_code'];
        
        $sub_details = get_subject_details($branch_id, $sub_code, $path);
        $get_theory_data333 = "SELECT SUM(max_marks) AS max_marks,SUM(min_marks) AS min_marks,attendance,SUM(obt_marks) AS obt_marks FROM `student_result_headwise` WHERE event_id='$event_id' AND enroll_no='$enroll_no' AND sub_code='$sub_code'
                                           AND ass_method IN('Theory') AND ass_type IN('ESE','University','External Marks')";
        $get_theory_data33 = mysql_query($get_theory_data333);
        $get_theory_data3 = mysql_fetch_assoc($get_theory_data33);

$get_internal_data444 = "SELECT SUM(max_marks) AS max_marks,SUM(min_marks) AS min_marks,attendance,SUM(obt_marks) AS obt_marks FROM `student_result_headwise` WHERE event_id='$event_id' AND enroll_no='$enroll_no' AND sub_code='$sub_code'
                                             AND ass_type IN('CIE-1','CIE-2','CIE-3','CIE','STE','JOURNAL','Sessional','Internal Ass')";
        $get_internal_data44 = mysql_query($get_internal_data444);
        $get_internal_data4 = mysql_fetch_assoc($get_internal_data44);

$get_practical_data555 = "SELECT SUM(max_marks) AS max_marks,SUM(min_marks) AS min_marks,attendance,SUM(obt_marks) AS obt_marks FROM `student_result_headwise` WHERE event_id='$event_id' AND enroll_no='$enroll_no' AND sub_code='$sub_code'
                                             AND ass_method IN('Practical') AND ass_type IN('ESE','University','External Marks')";
        $get_practical_data55 = mysql_query($get_practical_data555);
        $get_practical_data5 = mysql_fetch_assoc($get_practical_data55);

$get_viva_data666 = "SELECT SUM(max_marks) AS max_marks,SUM(min_marks) AS min_marks,attendance,SUM(obt_marks) AS obt_marks FROM `student_result_headwise` WHERE event_id='$event_id' AND enroll_no='$enroll_no' AND sub_code='$sub_code'
                                             AND ass_type IN('Viva')";
        $get_viva_data66 = mysql_query($get_viva_data666);
        $get_viva_data6 = mysql_fetch_assoc($get_viva_data66);
        $sub_name[] = $sub_details['sub_name'];
        $sub_code_arr[] = $sub_code;
        $tot_max_marks[] = $get_data2['tot_max_marks'];
        $tot_min_marks[] = $get_data2['tot_min_marks'];
        if ($get_theory_data3['max_marks'] == '') {
            $th_max_marks[] = $na;
        } else {
            $th_max_marks[] = $get_theory_data3['max_marks'];
        }

if ($get_theory_data3['max_marks'] == '') {
            $th_min_marks[] = $na;
        } else {
            $th_min_marks[] = $get_theory_data3['min_marks'];
        }

if ($get_practical_data5['max_marks'] == '') {
            $pr_max_marks[] = $na;
        } else {
            $pr_max_marks[] = $get_practical_data5['max_marks'];
        }

if ($get_practical_data5['max_marks'] == '') {
            $pr_min_marks[] = $na;
        } else {
            $pr_min_marks[] = $get_practical_data5['min_marks'];
        }

if ($get_internal_data4['max_marks'] == '') {
            $internal_max_marks[] = $na;
        } else {
            $internal_max_marks[] = $get_internal_data4['max_marks'];
        }

if ($get_internal_data4['max_marks'] == '') {
            $internal_min_marks[] = $na;
        } else {
            $internal_min_marks[] = $get_internal_data4['min_marks'];
        }

if ($get_viva_data6['max_marks'] == '') {
            $viva_max_marks[] = $na;
        } else {
            $viva_max_marks[] = $get_viva_data6['max_marks'];
        }

if ($get_viva_data6['max_marks'] == '') {
            $viva_min_marks[] = $na;
        } else {
            $viva_min_marks[] = $get_viva_data6['min_marks'];
        }

if ($get_theory_data3['obt_marks'] == '') {
            $th_obt_marks[] = $na;
        } else {
            $th_obt_marks[] = $get_theory_data3['obt_marks'];
        }

if ($get_practical_data5['obt_marks'] == '') {
            $pr_obt_marks[] = $na;
        } else {
            $pr_obt_marks[] = $get_practical_data5['obt_marks'];
        }

if ($get_internal_data4['obt_marks'] == '') {
            $internal_obt_marks[] = $na;
        } else {
            $internal_obt_marks[] = $get_internal_data4['obt_marks'];
        }

if ($get_viva_data6['obt_marks'] == '') {
            $viva_obt_marks[] = $na;
        } else {
            $viva_obt_marks[] = $get_viva_data6['obt_marks'];
        }

$tot_obt_marks[] = $get_data2['tot_obt_marks'];
        if ($get_data2['sub_status'] == 'P') {
            $res_status[] = 'Pass';
        } else {
            $res_status[] = "Fail";
        }
        $grade_letter[] = $get_data2['grade_letter'];
        $grade_points[] = $get_data2['grade_points'];
        $credits[] = $get_data2['credits'];
        $scale[] = $get_data2['scale'];
        $GRACE[] = $na;
        $Remark[] = 'NA';
    }
    
    for ($i = $cnt-1; $i < 16; $i++) {
        $sub_name[$i]=$na;
        $sub_code_arr[$i]=$na;
        $tot_max_marks[$i]=$na;
        $tot_min_marks[$i]=$na;
        $th_max_marks[$i]=$na;
        $th_min_marks[$i]=$na;
        $pr_max_marks[$i]=$na;
        $pr_min_marks[$i]=$na;
        $internal_max_marks[$i]=$na;
        $internal_min_marks[$i]=$na;
        $viva_max_marks[$i]=$na;
        $viva_min_marks[$i]=$na;
        $th_obt_marks[$i]=$na;
        $pr_obt_marks[$i]=$na;
        $internal_obt_marks[$i]=$na;
        $viva_obt_marks[$i]=$na;
        $tot_obt_marks[$i]=$na;
        $res_status[$i]=$na;
        $grade_letter[$i]=$na;
        $grade_points[$i]=$na;
        $credits[$i]=$na;
        $scale[$i]=$na;
    }

$upwardData[] = array(
        'UNIV_AISHE_CODE' => $uni_code,
        'UNIV_NAME' => $uni_name,
        'ORG_AISHE_CODE' => $na2,
        'ORG_CODE' => $uni_code,
        'ORG_NAME' => $na2,
        'ORG_ADDRESS' => $na2,
        'ORG_CITY' => $na2,
        'ORG_STATE' => $na2,
        'ORG_DISTRICT' => $na2,
        'ORG_PIN' => $na,
        'ACADEMIC_COURSE_ID' => $course_id,
        'COURSE_CODE' => $course_details['course_name'],
        'COURSE_NAME' => $course_details['course_longform'],
        'COURSE_NAME_L' => '',
        'COURSE_SUBTITLE' => '',
        'STREAM' => $branch_details['branch_name'],
        'STREAM_L' => '',
        'STREAM_SECOND' => '',
        'STREAM_SECOND_L' => '',
        'SPECIALIZATION_MAJOR' => '',
        'SPECIALIZATION_MINOR' => '',
        'SEASON' => $event,
        'SESSION' => $acyear,
        'REGN_NO' => $enroll_no,
        'PRN' => $enroll_no,
        'RROLL' => '',
        'LOCKER_ID' => '',
        'ABC_ACCOUNT_ID' => $stud_details['abc_id'],
        'GENDER' => $stud_details['gender'],
        'CASTE' => $stud_details['caste'],
        'RELIGION' => $stud_details['religion'],
        'NATIONALITY' => $stud_details['nationality'],
        'PH' => $stud_details['physically_handicap'],
        'MRKS_REC_STATUS' => '',
        'RESULT' => $final_res_status,
        'YEAR' => $event_details['val2'],
        'MONTH' => $val1,
        'DIVISION' => '',
        'GRADE' => '',
        'PERCENT' => $get_data1['percentage'],
        'DOR' => $result_declare_date,
        'DOI' => '',
        'DOV' => '',
        'DOP' => '',
        'DOQ' => '',
        'DOS' => '',
        'THESIS' => '',
        'CERT_NO' => '',
        'SEM' => $get_data1['sem'],
        'EXAM_TYPE' => $reg_type,
        'TERM_TYPE' => '',
        'TOT' => $get_data1['tot_max_marks'],
        'TOT_MAX' => $get_data1['tot_max_marks'],
        'TOT_MIN' => $get_data1['tot_min_marks'],
        'TOT_MRKS' => $get_data1['tot_obt_marks'],
        'TOT_MRKS_WRDS' => '',
        'TOT_TH_MAX' => '',
        'TOT_TH_MIN' => '',
        'TOT_TH_MRKS' => '',
        'TOT_PR_MAX' => '',
        'TOT_PR_MIN' => '',
        'TOT_PR_MRKS' => '',
        'TOT_CE_MAX' => '',
        'TOT_CE_MIN' => '',
        'TOT_CE_MRKS' => '',
        'TOT_VV_MAX' => '',
        'TOT_VV_MIN' => '',
        'TOT_VV_MRKS' => '',
        'GRAND_TOT_MAX' => '',
        'GRAND_TOT_MIN' => '',
        'GRAND_TOT_MRKS' => '',
        'TOT_CREDIT' => '',
        'TOT_CREDIT_POINTS' => '',
        'GRAND_TOT_CREDIT' => '',
        'GRAND_TOT_CREDIT_POINTS' => '',
        'CGPA' => $get_data1['cgpa'],
        'CGPA_SCALE' => '10',
        'WITHHELD STATUS' => $na,
        'SGPA' => $get_data1['sgpa'],
        'SUB1NM' => $sub_name[0],
        'SUB1' => $sub_code_arr[0],
        'SUB1MAX' => $tot_max_marks[0],
        'SUB1MIN' => $tot_min_marks[0],
        'SUB1_TH_MAX' => $th_max_marks[0],
        'SUB1_TH_MIN' => $th_min_marks[0],
        'SUB1_PR_MAX' => $pr_max_marks[0],
        'SUB1_PR_MIN' => $pr_min_marks[0],
        'SUB1_CE_MAX' => $internal_max_marks[0],
        'SUB1_CE_MIN' => $internal_min_marks[0],
        'SUB1_VV_MAX' => $viva_max_marks[0],
        'SUB1_VV_MIN' => $viva_min_marks[0],
        'SUB1_TH_MRKS' => $th_obt_marks[0],
        'SUB1_PR_MRKS' => $pr_obt_marks[0],
        'SUB1_CE_MRKS' => $internal_obt_marks[0],
        'SUB1_VV_MRKS' => $viva_obt_marks[0],
        'SUB1_TOT' => $tot_obt_marks[0],
        'SUB1_STATUS' => $res_status[0],
        'SUB1_GRADE' => $grade_letter[0],
        'SUB1_GRADE_POINTS' => $grade_points[0],
        'SUB1_CREDIT' => $credits[0],
        'SUB1_CREDIT_POINTS' => $scale[0],
        'SUB1_GRACE' => $na,
        'SUB1_Remark' => $na2,
        'SUB2NM' => $sub_name[1],
        'SUB2' => $sub_code_arr[1],
        'SUB2MAX' => $tot_max_marks[1],
        'SUB2MIN' => $tot_min_marks[1],
        'SUB2_TH_MAX' => $th_max_marks[1],
        'SUB2_TH_MIN' => $th_min_marks[1],
        'SUB2_PR_MAX' => $pr_max_marks[1],
        'SUB2_PR_MIN' => $pr_min_marks[1],
        'SUB2_CE_MAX' => $internal_max_marks[1],
        'SUB2_CE_MIN' => $internal_min_marks[1],
        'SUB2_VV_MAX' => $viva_max_marks[1],
        'SUB2_VV_MIN' => $viva_min_marks[1],
        'SUB2_TH_MRKS' => $th_obt_marks[1],
        'SUB2_PR_MRKS' => $pr_obt_marks[1],
        'SUB2_CE_MRKS' => $internal_obt_marks[1],
        'SUB2_VV_MRKS' => $viva_obt_marks[1],
        'SUB2_TOT' => $tot_obt_marks[1],
        'SUB2_STATUS' => $res_status[1],
        'SUB2_GRADE' => $grade_letter[1],
        'SUB2_GRADE_POINTS' => $grade_points[1],
        'SUB2_CREDIT' => $credits[1],
        'SUB2_CREDIT_POINTS' => $scale[1],
        'SUB2_GRACE' => $na,
        'SUB2_Remark' => $na2,
        'SUB3NM' => $sub_name[2],
        'SUB3' => $sub_code_arr[2],
        'SUB3MAX' => $tot_max_marks[2],
        'SUB3MIN' => $tot_min_marks[2],
        'SUB3_TH_MAX' => $th_max_marks[2],
        'SUB3_TH_MIN' => $th_min_marks[2],
        'SUB3_PR_MAX' => $pr_max_marks[2],
        'SUB3_PR_MIN' => $pr_min_marks[2],
        'SUB3_CE_MAX' => $internal_max_marks[2],
        'SUB3_CE_MIN' => $internal_min_marks[2],
        'SUB3_VV_MAX' => $viva_max_marks[2],
        'SUB3_VV_MIN' => $viva_min_marks[2],
        'SUB3_TH_MRKS' => $th_obt_marks[2],
        'SUB3_PR_MRKS' => $pr_obt_marks[2],
        'SUB3_CE_MRKS' => $internal_obt_marks[2],
        'SUB3_VV_MRKS' => $viva_obt_marks[2],
        'SUB3_TOT' => $tot_obt_marks[2],
        'SUB3_STATUS' => $res_status[2],
        'SUB3_GRADE' => $grade_letter[2],
        'SUB3_GRADE_POINTS' => $grade_points[2],
        'SUB3_CREDIT' => $credits[2],
        'SUB3_CREDIT_POINTS' => $scale[2],
        'SUB3_GRACE' => $na,
        'SUB3_Remark' => $na2,
        'SUB4NM' => $sub_name[3],
        'SUB4' => $sub_code_arr[3],
        'SUB4MAX' => $tot_max_marks[3],
        'SUB4MIN' => $tot_min_marks[3],
        'SUB4_TH_MAX' => $th_max_marks[3],
        'SUB4_TH_MIN' => $th_min_marks[3],
        'SUB4_PR_MAX' => $pr_max_marks[3],
        'SUB4_PR_MIN' => $pr_min_marks[3],
        'SUB4_CE_MAX' => $internal_max_marks[3],
        'SUB4_CE_MIN' => $internal_min_marks[3],
        'SUB4_VV_MAX' => $viva_max_marks[3],
        'SUB4_VV_MIN' => $viva_min_marks[3],
        'SUB4_TH_MRKS' => $th_obt_marks[3],
        'SUB4_PR_MRKS' => $pr_obt_marks[3],
        'SUB4_CE_MRKS' => $internal_obt_marks[3],
        'SUB4_VV_MRKS' => $viva_obt_marks[3],
        'SUB4_TOT' => $tot_obt_marks[3],
        'SUB4_STATUS' => $res_status[3],
        'SUB4_GRADE' => $grade_letter[3],
        'SUB4_GRADE_POINTS' => $grade_points[3],
        'SUB4_CREDIT' => $credits[3],
        'SUB4_CREDIT_POINTS' => $scale[3],
        'SUB4_GRACE' => $na,
        'SUB4_Remark' => $na2,
        'SUB5NM' => $sub_name[4],
        'SUB5' => $sub_code_arr[4],
        'SUB5MAX' => $tot_max_marks[4],
        'SUB5MIN' => $tot_min_marks[4],
        'SUB5_TH_MAX' => $th_max_marks[4],
        'SUB5_TH_MIN' => $th_min_marks[4],
        'SUB5_PR_MAX' => $pr_max_marks[4],
        'SUB5_PR_MIN' => $pr_min_marks[4],
        'SUB5_CE_MAX' => $internal_max_marks[4],
        'SUB5_CE_MIN' => $internal_min_marks[4],
        'SUB5_VV_MAX' => $viva_max_marks[4],
        'SUB5_VV_MIN' => $viva_min_marks[4],
        'SUB5_TH_MRKS' => $th_obt_marks[4],
        'SUB5_PR_MRKS' => $pr_obt_marks[4],
        'SUB5_CE_MRKS' => $internal_obt_marks[4],
        'SUB5_VV_MRKS' => $viva_obt_marks[4],
        'SUB5_TOT' => $tot_obt_marks[4],
        'SUB5_STATUS' => $res_status[4],
        'SUB5_GRADE' => $grade_letter[4],
        'SUB5_GRADE_POINTS' => $grade_points[4],
        'SUB5_CREDIT' => $credits[4],
        'SUB5_CREDIT_POINTS' => $scale[4],
        'SUB5_GRACE' => $na,
        'SUB5_Remark' => $na2,
        'SUB6NM' => $sub_name[5],
        'SUB6' => $sub_code_arr[5],
        'SUB6MAX' => $tot_max_marks[5],
        'SUB6MIN' => $tot_min_marks[5],
        'SUB6_TH_MAX' => $th_max_marks[5],
        'SUB6_TH_MIN' => $th_min_marks[5],
        'SUB6_PR_MAX' => $pr_max_marks[5],
        'SUB6_PR_MIN' => $pr_min_marks[5],
        'SUB6_CE_MAX' => $internal_max_marks[5],
        'SUB6_CE_MIN' => $internal_min_marks[5],
        'SUB6_VV_MAX' => $viva_max_marks[5],
        'SUB6_VV_MIN' => $viva_min_marks[5],
        'SUB6_TH_MRKS' => $th_obt_marks[5],
        'SUB6_PR_MRKS' => $pr_obt_marks[5],
        'SUB6_CE_MRKS' => $internal_obt_marks[5],
        'SUB6_VV_MRKS' => $viva_obt_marks[5],
        'SUB6_TOT' => $tot_obt_marks[5],
        'SUB6_STATUS' => $res_status[5],
        'SUB6_GRADE' => $grade_letter[5],
        'SUB6_GRADE_POINTS' => $grade_points[5],
        'SUB6_CREDIT' => $credits[5],
        'SUB6_CREDIT_POINTS' => $scale[5],
        'SUB6_GRACE' => $na,
        'SUB6_Remark' => $na2,
        'SUB7NM' => $sub_name[6],
        'SUB7' => $sub_code_arr[6],
        'SUB7MAX' => $tot_max_marks[6],
        'SUB7MIN' => $tot_min_marks[6],
        'SUB7_TH_MAX' => $th_max_marks[6],
        'SUB7_TH_MIN' => $th_min_marks[6],
        'SUB7_PR_MAX' => $pr_max_marks[6],
        'SUB7_PR_MIN' => $pr_min_marks[6],
        'SUB7_CE_MAX' => $internal_max_marks[6],
        'SUB7_CE_MIN' => $internal_min_marks[6],
        'SUB7_VV_MAX' => $viva_max_marks[6],
        'SUB7_VV_MIN' => $viva_min_marks[6],
        'SUB7_TH_MRKS' => $th_obt_marks[6],
        'SUB7_PR_MRKS' => $pr_obt_marks[6],
        'SUB7_CE_MRKS' => $internal_obt_marks[6],
        'SUB7_VV_MRKS' => $viva_obt_marks[6],
        'SUB7_TOT' => $tot_obt_marks[6],
        'SUB7_STATUS' => $res_status[6],
        'SUB7_GRADE' => $grade_letter[6],
        'SUB7_GRADE_POINTS' => $grade_points[6],
        'SUB7_CREDIT' => $credits[6],
        'SUB7_CREDIT_POINTS' => $scale[6],
        'SUB7_GRACE' => $na,
        'SUB7_Remark' => $na2,
        'SUB8NM' => $sub_name[7],
        'SUB8' => $sub_code_arr[7],
        'SUB8MAX' => $tot_max_marks[7],
        'SUB8MIN' => $tot_min_marks[7],
        'SUB8_TH_MAX' => $th_max_marks[7],
        'SUB8_TH_MIN' => $th_min_marks[7],
        'SUB8_PR_MAX' => $pr_max_marks[7],
        'SUB8_PR_MIN' => $pr_min_marks[7],
        'SUB8_CE_MAX' => $internal_max_marks[7],
        'SUB8_CE_MIN' => $internal_min_marks[7],
        'SUB8_VV_MAX' => $viva_max_marks[7],
        'SUB8_VV_MIN' => $viva_min_marks[7],
        'SUB8_TH_MRKS' => $th_obt_marks[7],
        'SUB8_PR_MRKS' => $pr_obt_marks[7],
        'SUB8_CE_MRKS' => $internal_obt_marks[7],
        'SUB8_VV_MRKS' => $viva_obt_marks[7],
        'SUB8_TOT' => $tot_obt_marks[7],
        'SUB8_STATUS' => $res_status[7],
        'SUB8_GRADE' => $grade_letter[7],
        'SUB8_GRADE_POINTS' => $grade_points[7],
        'SUB8_CREDIT' => $credits[7],
        'SUB8_CREDIT_POINTS' => $scale[7],
        'SUB8_GRACE' => $na,
        'SUB8_Remark' => $na2,
        'SUB9NM' => $sub_name[8],
        'SUB9' => $sub_code_arr[8],
        'SUB9MAX' => $tot_max_marks[8],
        'SUB9MIN' => $tot_min_marks[8],
        'SUB9_TH_MAX' => $th_max_marks[8],
        'SUB9_TH_MIN' => $th_min_marks[8],
        'SUB9_PR_MAX' => $pr_max_marks[8],
        'SUB9_PR_MIN' => $pr_min_marks[8],
        'SUB9_CE_MAX' => $internal_max_marks[8],
        'SUB9_CE_MIN' => $internal_min_marks[8],
        'SUB9_VV_MAX' => $viva_max_marks[8],
        'SUB9_VV_MIN' => $viva_min_marks[8],
        'SUB9_TH_MRKS' => $th_obt_marks[8],
        'SUB9_PR_MRKS' => $pr_obt_marks[8],
        'SUB9_CE_MRKS' => $internal_obt_marks[8],
        'SUB9_VV_MRKS' => $viva_obt_marks[8],
        'SUB9_TOT' => $tot_obt_marks[8],
        'SUB9_STATUS' => $res_status[8],
        'SUB9_GRADE' => $grade_letter[8],
        'SUB9_GRADE_POINTS' => $grade_points[8],
        'SUB9_CREDIT' => $credits[8],
        'SUB9_CREDIT_POINTS' => $scale[8],
        'SUB9_GRACE' => $na,
        'SUB9_Remark' => $na2,
        'SUB10NM' => $sub_name[9],
        'SUB10' => $sub_code_arr[9],
        'SUB10MAX' => $tot_max_marks[9],
        'SUB10MIN' => $tot_min_marks[9],
        'SUB10_TH_MAX' => $th_max_marks[9],
        'SUB10_TH_MIN' => $th_min_marks[9],
        'SUB10_PR_MAX' => $pr_max_marks[9],
        'SUB10_PR_MIN' => $pr_min_marks[9],
        'SUB10_CE_MAX' => $internal_max_marks[9],
        'SUB10_CE_MIN' => $internal_min_marks[9],
        'SUB10_VV_MAX' => $viva_max_marks[9],
        'SUB10_VV_MIN' => $viva_min_marks[9],
        'SUB10_TH_MRKS' => $th_obt_marks[9],
        'SUB10_PR_MRKS' => $pr_obt_marks[9],
        'SUB10_CE_MRKS' => $internal_obt_marks[9],
        'SUB10_VV_MRKS' => $viva_obt_marks[9],
        'SUB10_TOT' => $tot_obt_marks[9],
        'SUB10_STATUS' => $res_status[9],
        'SUB10_GRADE' => $grade_letter[9],
        'SUB10_GRADE_POINTS' => $grade_points[9],
        'SUB10_CREDIT' => $credits[9],
        'SUB10_CREDIT_POINTS' => $scale[9],
        'SUB10_GRACE' => $na,
        'SUB10_Remark' => $na2,
        'SUB11NM' => $sub_name[10],
        'SUB11' => $sub_code_arr[10],
        'SUB11MAX' => $tot_max_marks[10],
        'SUB11MIN' => $tot_min_marks[10],
        'SUB11_TH_MAX' => $th_max_marks[10],
        'SUB11_TH_MIN' => $th_min_marks[10],
        'SUB11_PR_MAX' => $pr_max_marks[10],
        'SUB11_PR_MIN' => $pr_min_marks[10],
        'SUB11_CE_MAX' => $internal_max_marks[10],
        'SUB11_CE_MIN' => $internal_min_marks[10],
        'SUB11_VV_MAX' => $viva_max_marks[10],
        'SUB11_VV_MIN' => $viva_min_marks[10],
        'SUB11_TH_MRKS' => $th_obt_marks[10],
        'SUB11_PR_MRKS' => $pr_obt_marks[10],
        'SUB11_CE_MRKS' => $internal_obt_marks[10],
        'SUB11_VV_MRKS' => $viva_obt_marks[10],
        'SUB11_TOT' => $tot_obt_marks[10],
        'SUB11_STATUS' => $res_status[10],
        'SUB11_GRADE' => $grade_letter[10],
        'SUB11_GRADE_POINTS' => $grade_points[10],
        'SUB11_CREDIT' => $credits[10],
        'SUB11_CREDIT_POINTS' => $scale[10],
        'SUB11_GRACE' => $na,
        'SUB11_Remark' => $na2,
        'SUB12NM' => $sub_name[11],
        'SUB12' => $sub_code_arr[11],
        'SUB12MAX' => $tot_max_marks[11],
        'SUB12MIN' => $tot_min_marks[11],
        'SUB12_TH_MAX' => $th_max_marks[11],
        'SUB12_TH_MIN' => $th_min_marks[11],
        'SUB12_PR_MAX' => $pr_max_marks[11],
        'SUB12_PR_MIN' => $pr_min_marks[11],
        'SUB12_CE_MAX' => $internal_max_marks[11],
        'SUB12_CE_MIN' => $internal_min_marks[11],
        'SUB12_VV_MAX' => $viva_max_marks[11],
        'SUB12_VV_MIN' => $viva_min_marks[11],
        'SUB12_TH_MRKS' => $th_obt_marks[11],
        'SUB12_PR_MRKS' => $pr_obt_marks[11],
        'SUB12_CE_MRKS' => $internal_obt_marks[11],
        'SUB12_VV_MRKS' => $viva_obt_marks[11],
        'SUB12_TOT' => $tot_obt_marks[11],
        'SUB12_STATUS' => $res_status[11],
        'SUB12_GRADE' => $grade_letter[11],
        'SUB12_GRADE_POINTS' => $grade_points[11],
        'SUB12_CREDIT' => $credits[11],
        'SUB12_CREDIT_POINTS' => $scale[11],
        'SUB12_GRACE' => $na,
        'SUB12_Remark' => $na2,
        'SUB13NM' => $sub_name[12],
        'SUB13' => $sub_code_arr[12],
        'SUB13MAX' => $tot_max_marks[12],
        'SUB13MIN' => $tot_min_marks[12],
        'SUB13_TH_MAX' => $th_max_marks[12],
        'SUB13_TH_MIN' => $th_min_marks[12],
        'SUB13_PR_MAX' => $pr_max_marks[12],
        'SUB13_PR_MIN' => $pr_min_marks[12],
        'SUB13_CE_MAX' => $internal_max_marks[12],
        'SUB13_CE_MIN' => $internal_min_marks[12],
        'SUB13_VV_MAX' => $viva_max_marks[12],
        'SUB13_VV_MIN' => $viva_min_marks[12],
        'SUB13_TH_MRKS' => $th_obt_marks[12],
        'SUB13_PR_MRKS' => $pr_obt_marks[12],
        'SUB13_CE_MRKS' => $internal_obt_marks[12],
        'SUB13_VV_MRKS' => $viva_obt_marks[12],
        'SUB13_TOT' => $tot_obt_marks[12],
        'SUB13_STATUS' => $res_status[12],
        'SUB13_GRADE' => $grade_letter[12],
        'SUB13_GRADE_POINTS' => $grade_points[12],
        'SUB13_CREDIT' => $credits[12],
        'SUB13_CREDIT_POINTS' => $scale[12],
        'SUB13_GRACE' => $na,
        'SUB13_Remark' => $na2,
        'SUB14NM' => $sub_name[13],
        'SUB14' => $sub_code_arr[13],
        'SUB14MAX' => $tot_max_marks[13],
        'SUB14MIN' => $tot_min_marks[13],
        'SUB14_TH_MAX' => $th_max_marks[13],
        'SUB14_TH_MIN' => $th_min_marks[13],
        'SUB14_PR_MAX' => $pr_max_marks[13],
        'SUB14_PR_MIN' => $pr_min_marks[13],
        'SUB14_CE_MAX' => $internal_max_marks[13],
        'SUB14_CE_MIN' => $internal_min_marks[13],
        'SUB14_VV_MAX' => $viva_max_marks[13],
        'SUB14_VV_MIN' => $viva_min_marks[13],
        'SUB14_TH_MRKS' => $th_obt_marks[13],
        'SUB14_PR_MRKS' => $pr_obt_marks[13],
        'SUB14_CE_MRKS' => $internal_obt_marks[13],
        'SUB14_VV_MRKS' => $viva_obt_marks[13],
        'SUB14_TOT' => $tot_obt_marks[13],
        'SUB14_STATUS' => $res_status[13],
        'SUB14_GRADE' => $grade_letter[13],
        'SUB14_GRADE_POINTS' => $grade_points[13],
        'SUB14_CREDIT' => $credits[13],
        'SUB14_CREDIT_POINTS' => $scale[13],
        'SUB14_GRACE' => $na,
        'SUB14_Remark' => $na2,
        'SUB15NM' => $sub_name[14],
        'SUB15' => $sub_code_arr[14],
        'SUB15MAX' => $tot_max_marks[14],
        'SUB15MIN' => $tot_min_marks[14],
        'SUB15_TH_MAX' => $th_max_marks[14],
        'SUB15_TH_MIN' => $th_min_marks[14],
        'SUB15_PR_MAX' => $pr_max_marks[14],
        'SUB15_PR_MIN' => $pr_min_marks[14],
        'SUB15_CE_MAX' => $internal_max_marks[14],
        'SUB15_CE_MIN' => $internal_min_marks[14],
        'SUB15_VV_MAX' => $viva_max_marks[14],
        'SUB15_VV_MIN' => $viva_min_marks[14],
        'SUB15_TH_MRKS' => $th_obt_marks[14],
        'SUB15_PR_MRKS' => $pr_obt_marks[14],
        'SUB15_CE_MRKS' => $internal_obt_marks[14],
        'SUB15_VV_MRKS' => $viva_obt_marks[14],
        'SUB15_TOT' => $tot_obt_marks[14],
        'SUB15_STATUS' => $res_status[14],
        'SUB15_GRADE' => $grade_letter[14],
        'SUB15_GRADE_POINTS' => $grade_points[14],
        'SUB15_CREDIT' => $credits[14],
        'SUB15_CREDIT_POINTS' => $scale[14],
        'SUB15_GRACE' => $na,
        'SUB15_Remark' => $na2,
        'LAST_UPDATE_DATE' => $result_declare_date
    );
    
    $update_result_entry = "UPDATE `student_result_eventwise` SET `dashboard_data_shared_on`='$date' WHERE `sr_no`='$sr_no'";
    $execute_update_result_entry = mysql_query($update_result_entry);
}
$response=[
    "code" => 200,
    "msg" => 'Success',
    "data" => $upwardData
];
$data_result1 = json_encode($response, JSON_UNESCAPED_UNICODE);
// print_r($data_result1);
if ($data_result1 === false) {
    echo "JSON Encoding Error: " . json_last_error_msg();
} else {
    echo $data_result1;
}
exit();
ob_end_flush();
?>