Code Coverage
 
Classes and Traits
Functions and Methods
Lines
Total
0.00% covered (danger)
0.00%
0 / 1
0.00% covered (danger)
0.00%
0 / 4
CRAP
0.00% covered (danger)
0.00%
0 / 456
Template20SupplementaryConsolidatedResultGenerator
0.00% covered (danger)
0.00%
0 / 1
0.00% covered (danger)
0.00%
0 / 4
7310.00
0.00% covered (danger)
0.00%
0 / 456
 __construct
n/a
0 / 0
1
n/a
0 / 0
 getTemplateName
0.00% covered (danger)
0.00%
0 / 1
6.00
0.00% covered (danger)
0.00%
0 / 8
 processData
0.00% covered (danger)
0.00%
0 / 1
72.00
0.00% covered (danger)
0.00%
0 / 85
 renderConsolidatedMarkListResult
0.00% covered (danger)
0.00%
0 / 1
20.00
0.00% covered (danger)
0.00%
0 / 44
 processSupplementaryStudentData
0.00% covered (danger)
0.00%
0 / 1
4970.00
0.00% covered (danger)
0.00%
0 / 319
<?php
// Template Consilidated Generator For Presidency Colleges
namespace com\linways\ec\core\service\SupplementaryConsolidatedMarkListGenerator;
use com\linways\ec\core\service\StudentMarkListService;
use com\linways\ec\core\service\ExamRegistrationService;
use com\linways\ec\core\exception\ExamControllerException;
use com\linways\base\util\TwigRenderer;
use com\linways\ec\core\service\CommonExamService;
use com\linways\core\ams\professional\util\PdfUtil;
use com\linways\ec\core\constant\AttendanceStatusConstant;
use com\linways\ec\core\service\SupplementaryConsolidatedMarkListGenerator\SupplementaryConsolidatedMarkListResultDataGenerator;
use TCPDFBarcode;
use com\linways\core\ams\professional\util\CommonUtil;
use com\linways\core\ams\professional\service\AmsCustomFieldsService;
use com\linways\ec\core\request\SearchExamRegistrationRequest;
use com\linways\core\ams\professional\constant\AmsCustomFieldsEntities;
use com\linways\ec\core\service\GradeSchemeService;
class Template20SupplementaryConsolidatedResultGenerator extends SupplementaryConsolidatedMarkListResultDataGenerator
{
    public function __construct(){}
    
    protected function getTemplateName($request){
        $templateName = "template_20";
        $examRegistrationData = new \stdClass;
        $examRegistrationDetailsArray = ExamRegistrationService::getInstance()->searchDetailedExamRegistrationDetails($request);
        if(empty($examRegistrationDetailsArray)){
            throw new ExamControllerException(ExamControllerException::NO_DETAILS_FOUND,"No Details Found");
        }
        return $templateName;
    }
     /**
     * Process Student data college base
     *
     * @param $request
     */
    protected function processData($request){
        $response = new \stdClass;
        $studentsMarkDetails = [];
        $examRegistrationData = StudentMarkListService::getInstance()->getExamRegistrationDetailsDataForConsolidatedAndIndividualReports($request);
        $studentsMarkDetails = StudentMarkListService::getInstance()->getAllRegistredStudentMarkDetailsDummyData($request);
        if(empty($studentsMarkDetails)){
            throw new ExamControllerException(ExamControllerException::NO_DETAILS_FOUND,"No Details Found");
        }
        $studentsMarkDetails = $this->processSupplementaryStudentData($studentsMarkDetails,$request,$examRegistrationData);
        $response->studentData = $studentsMarkDetails->studentsDetails;
        $response->examRegistrationData = $examRegistrationData;
        $response->examRegistrationData->subjects =  $studentsMarkDetails->displaySubjects;
        $response->examRegistrationData->subjectCategories =  $studentsMarkDetails->displaySubjectCategories;
        $subjectGradePassDetails = $studentsMarkDetails->subjectGradePassDetails;
        $response->examRegistrationData->disableCollegeRegisterNumber = false;
        foreach($response->examRegistrationData->subjects as $subject){
            if($subjectGradePassDetails[$subject->id]){
                $subject->subjectResultStatus[0]->name = "PASS";
                $subject->subjectResultStatus[0]->count = $subjectGradePassDetails[$subject->id]->passCount;
                $subject->subjectResultStatus[1]->name = "FAIL";
                $subject->subjectResultStatus[1]->count = $subjectGradePassDetails[$subject->id]->failCount;
                $subject->subjectResultStatus[2]->name = "AB";
                $subject->subjectResultStatus[2]->count = $subjectGradePassDetails[$subject->id]->absentCount;
                $subject->subjectResultStatus[3]->name = "MP";
                $subject->subjectResultStatus[3]->count = $subjectGradePassDetails[$subject->id]->malPracticeCount;
                $subject->subjectResultStatus[4]->name = "DB";
                $subject->subjectResultStatus[4]->count = 0;
                $subject->subjectResultStatus[5]->name = "NP";
                $subject->subjectResultStatus[5]->count = 0;
                $subject->subjectResultStatus[6]->name = "WH";
                $subject->subjectResultStatus[6]->count = 0;
                $subject->subjectResultStatus[7]->name = "PASS %";
                $subject->subjectResultStatus[7]->count = $subjectGradePassDetails[$subject->id]->passPercentage;
                $subject->subjectResultStatus[8]->name = "TOTAL";
                $subject->subjectResultStatus[8]->count = $subjectGradePassDetails[$subject->id]->totalStudents;
            }
            else{
                $subject->subjectResultStatus[0]->name = "PASS";
                $subject->subjectResultStatus[0]->count = 0;
                $subject->subjectResultStatus[1]->name = "FAIL";
                $subject->subjectResultStatus[1]->count = 0;
                $subject->subjectResultStatus[2]->name = "AB";
                $subject->subjectResultStatus[2]->count = 0;
                $subject->subjectResultStatus[3]->name = "MP";
                $subject->subjectResultStatus[3]->count = 0;
                $subject->subjectResultStatus[4]->name = "DB";
                $subject->subjectResultStatus[4]->count = 0;
                $subject->subjectResultStatus[5]->name = "NP";
                $subject->subjectResultStatus[5]->count = 0;
                $subject->subjectResultStatus[6]->name = "WH";
                $subject->subjectResultStatus[6]->count = 0;
                $subject->subjectResultStatus[7]->name = "PASS %";
                $subject->subjectResultStatus[7]->count = 0;
                $subject->subjectResultStatus[8]->name = "TOTAL";
                $subject->subjectResultStatus[8]->count = 0;
            }
            if(!$request->hideExternalOrInternalMark){
                $subject->subColSpan = 3;
                $subject->subColSpan = $subject->isInternal ? $subject->subColSpan + 1 : $subject->subColSpan;
                $subject->subColSpan = $subject->isExternal ? $subject->subColSpan + 1 : $subject->subColSpan;
            }
            else{
                $subject->subColSpan = 1;
            }
        }
        $response->classHeaderDetails = $studentsMarkDetails->classHeaderDetails;
        $response->classHeaderDetails['MP']->name = "MP";
        $response->classHeaderDetails['MP']->count = 0;
        $response->classHeaderDetails['DB']->name = "DB";
        $response->classHeaderDetails['DB']->count = 0;
        $response->classHeaderDetails['NP']->name = "NP";
        $response->classHeaderDetails['NP']->count = 0;
        $response->classHeaderDetails['WH']->name = "WH";
        $response->classHeaderDetails['WH']->count = 0;
        $response->classHeaderDetails['PASS_PERCENTAGE']->name = "PASS %";
        $response->classHeaderDetails['PASS_PERCENTAGE']->count = $studentsMarkDetails->overAllPassPercentage;
        $response->classHeaderDetails = array_values($response->classHeaderDetails);
        $response->examRegistrationData->totalColSpan = 10;
        foreach($response->examRegistrationData->subjects as $subject){
            $response->examRegistrationData->totalColSpan = $response->examRegistrationData->totalColSpan + $subject->subColSpan;
        }
        $response->collegeData = CommonExamService::getInstance()->getCollegeDetails();
        $response->hideExternalOrInternalMark = $request->hideExternalOrInternalMark;
        $response->hideSeal = $request->hideSeal;
        return $response;
    }
     /**
     * Render Program Result
     *
     * @param $templateName
     * @param Object $data
     * @return Object
     */
    protected function renderConsolidatedMarkListResult($templateName, $data){
        if(empty($data)){
            throw new ExamControllerException(ExamControllerException::NO_DETAILS_FOUND,"No Details Found");
        }
        else{
            if($data->hideExternalOrInternalMark){
                $responseHtml = "<style>
                .hideExternalOrInternalMark {display:none;} 
                </style>";
            }
            if($data->hideSeal){
                $responseHtml .= "<style>
                .hideImages {display:none;} 
                </style>";
            }
            $responseHtml .= TwigRenderer::renderTemplateFileToHtml(realpath(DOCUMENT_ROOT."../examcontroller-api/src/com/linways/web/templates/SupplementaryConsolidatedMarkList/Template20/$templateName.twig"), [ 'data'=>$data ]);
            $prtContent = NULL;
            $prtContent .= '<html><head>';
            $prtContent .= "<style>
                h6 {font-size: 26px;} .text-center { text-align: center;} .alignMiddle {vertical-align: middle}; tr.noBorder td {border: 0;  border-collapse:collapse;}
                table, th, td {border: 1px solid black;border-collapse: collapse; vertical-align: middle;} th {font-weight: normal;} .bold {font-weight: bold;}
                </style>";
            $prtContent .= '</head><title>Consolidated MarkList</title><body>';
            $prtContent .= $responseHtml;
            $prtContent .= '</body></html>';
            $totalSubjectsCount = count($data->examRegistrationData->subjects);
            $totalWidth = ( $totalSubjectsCount * 5 * 15 ) + 100;
            $totalHeight =  $totalWidth / 1.414;
            $options = array(
                'page-width'     => $totalWidth."mm",
                'page-height'    => $totalHeight."mm",
                'dpi'            => 96,
                'margin-top' => "9mm",
                'margin-left' => "1mm",
                'margin-right' => "1mm",
                'margin-bottom' => "9mm",
                // 'binary' => "/usr/local/bin/wkhtmltopdf", // For Mac
                'user-style-sheet' => realpath(DOCUMENT_ROOT . "/libcommon/bootstrap/css/bootstrap.min.css")
            );
            $programResult = new \stdClass;
            $programResult->dispalyHtmlData = $responseHtml;
            $programResult->printData = PdfUtil::renderPdf($prtContent, $options);
            $programResult->isShowHideExternalOrInternalMark = true;
        return  $programResult;
        }
       
    }
    /**
     * processSupplementaryStudentData
     * @param studentDetails
     * @return studentDetails
     */
    protected function processSupplementaryStudentData($studentMarkDetails,$examRegistrationDetails,$examRegistrationData){
        $response = new \stdClass;
        $totalStudentDetails = new \stdClass;
        $totalStudentDetails->totalStudents = count($studentMarkDetails);
        $displaySubjectArray = [];
        $displaySubjectCategories = [];
        $studentsDetails = [];
        $gradeSchemeRequest->examRegistrationId = $examRegistrationDetails->examRegistrationId;
        $gradeSchemeRequest->academicTermId = $examRegistrationDetails->academicTermId;
        $gradeSchemes = GradeSchemeService::getInstance()->getAllExamRegistrationGradeSchemes($searchRequest);
        $classHeaderNames = [];
        foreach($gradeSchemes as $gradeScheme){
            $classHeaderNames[strtoupper($gradeScheme->className)]->name = $gradeScheme->className;
            $classHeaderNames[strtoupper($gradeScheme->className)]->count = 0;
        }
        $classHeaderNames = array_unique($classHeaderNames);
        if($examRegistrationDetails->isStaffSideExamResultSheet == '1'){
            $requestForExamRegistration = new SearchExamRegistrationRequest;
            $requestForExamRegistration->groupId = $examRegistrationDetails->groupId;
            $revaluationRegistrations = ExamRegistrationService::getInstance()->getAllExamRevaluation($requestForExamRegistration);
        }
        foreach($studentMarkDetails as $student){
            $barcodeObj = new TCPDFBarcode($student->studentDetails->registerNo, 'C128');
            $studentsDetails[$student->id]->barcodeObj = $barcodeObj->getBarcodeHTML($w = 1, $h = 30, $color = 'black');
            $studentsDetails[$student->id]->id = $student->id;
            $customFields = AmsCustomFieldsService::getInstance()->getAmsCustomFieldValue(AmsCustomFieldsEntities::STUDENT, $student->id, []);
            if( $customFields ){
                $studentsDetails[$student->id]->ktuCode = CommonExamService::getInstance()->getCustomFieldObjectList($customFields)->studentData->KTU_CODE;
            }
            $studentsDetails[$student->id]->name = $student->studentDetails->name;
            $studentsDetails[$student->id]->isPG = $student->studentDetails->courseType == "PG" ? true : false;
            $studentsDetails[$student->id]->myImage = $student->studentDetails->myImage;
            $studentsDetails[$student->id]->registerNo = $student->studentDetails->registerNo;
            $studentsDetails[$student->id]->rollNo = $student->studentDetails->rollNo;
            $studentsDetails[$student->id]->roundOff = $student->studentDetails->academicYear < 2019 ?  2 : 3;
            $studentSubjectRequest = new \stdClass(); 
            $studentSubjectRequest->studentId = $student->id;
            $studentSubjectRequest->examMonthLimit = $examRegistrationDetails->examMonth;
            $studentSubjectRequest->examYearLimit = $examRegistrationDetails->examYear;
            // supply could not be minor and honour syllabus ans this report not consider minor and honour exams
            $studentSubjectRequest->isHonorCourse = false;
            $studentSubjectRequest->isMinorCourse = false;
            // $studentSubjectRequest->academicTermId = $examRegistrationData->academicTermId;
            $studentSubjectRequest->upToAcademicTermOrderNo = $examRegistrationData->academicOrderNo;
            $studentSubjectHistory = StudentMarkListService::getInstance()->getAllStudentSubjectMarkDetailsByRequest($studentSubjectRequest);
            // $studentSubjectRequest = new \stdClass(); 
            // $studentSubjectRequest->studentId = $student->id;
            // $studentSubjectRequest->upToAcademicTermOrderNoExceptCurrent = $examRegistrationData->academicOrderNo;
            // $studentSubjectHistory2 = StudentMarkListService::getInstance()->getAllStudentSubjectMarkDetailsByRequest($studentSubjectRequest);
            // $studentSubjectHistory = array_merge($studentSubjectHistory,$studentSubjectHistory2);
            $subjectHistory = [];
            $totalCredit = 0;
            $earnedCredit = 0;
            $earnedCreditPoint = 0;
            $earnedCreditForDisplay = 0;
            $semesterCgpa = 0;
            $additionalCreditRequest = new \stdClass;
            $additionalCreditRequest->studentId  = $student->id;
            $additionalCreditRequest->creditType = "CREDIT_TRANSFERED";
            $additionalCreditRequest->requestForList = 1;
            $additionalCredit = CommonExamService::getInstance()->getStudentAdditionalCredits($additionalCreditRequest);
            $semWiseAdditionalCredit = 0;
            if(  $additionalCredit ){
                $semIdRequestedForEarnedCredit = $currentAcademicTerm->academicTermId;
                $semWiseAdditionalCreditArray = array_filter($additionalCredit, function($item) use($semIdRequestedForEarnedCredit) {
                    return $item->termId <= $semIdRequestedForEarnedCredit;
                });
                $semWiseAdditionalCredit = array_sum( array_column($semWiseAdditionalCreditArray, 'credit'));
            }
            foreach($studentSubjectHistory as $studentHistory){
                if($examRegistrationDetails->isStaffSideExamResultSheet == '1'){
                    if ( $studentHistory->subjectHasRevaluationMark ){
                        $currentRegistration = reset(array_filter($revaluationRegistrations,function($value)use($studentHistory){
                            return $value->id == $studentHistory->subjectRevaluationId;
                        }));
                        $revaluationBatch = reset($currentRegistration->groups);
                        if ( $revaluationBatch->properties->isResultPublished != 1 || strtotime($revaluationBatch->properties->publishingStartDate) > strtotime(date("Y-m-d H:i"))){
                            $studentHistory->subjectFailedStatus = $studentHistory->subjectWithoutRevaluationIsFailed == 1 ? "FAILED" : "PASSED";
                            $studentHistory->subjectCreditGradePoint = $studentHistory->subjectWithoutRevaluationCreditGradePoint;
                        }
                    }
                }
                if($studentHistory->excludeSubjectFromTotal != 1){
                    if($subjectHistory[$studentHistory->paperSubjectId]){
                        if($subjectHistory[$studentHistory->paperSubjectId]->subjectCreditGradePoint < $studentHistory->subjectCreditGradePoint){
                            if($studentHistory->excludeSubjectFromTotal != 1){
                                $earnedCreditPoint += ($studentHistory->subjectCreditGradePoint - $subjectHistory[$studentHistory->paperSubjectId]->subjectCreditGradePoint);
                                $subjectHistory[$studentHistory->paperSubjectId] = $studentHistory;
                                if($studentHistory->subjectFailedStatus == "PASSED"){
                                    $earnedCredit += $studentHistory->credit;
                                }
                            }
                            else{
                                if($studentHistory->subjectFailedStatus == "PASSED"){
                                    $earnedCreditForDisplay += $studentHistory->credit;
                                }
                            }
                        }
                    }
                    else{
                        if($studentHistory->excludeSubjectFromTotal != 1){
                            $earnedCreditPoint += $studentHistory->subjectCreditGradePoint;
                            $totalCredit += $studentHistory->credit;
                            $subjectHistory[$studentHistory->paperSubjectId] = $studentHistory;
                            if($studentHistory->subjectFailedStatus == "PASSED"){
                                $earnedCredit += $studentHistory->credit;
                            }
                        }
                        else{
                            if($studentHistory->subjectFailedStatus == "PASSED"){
                                $earnedCreditForDisplay += $studentHistory->credit;
                            }
                        }
                    }
                }
            }
            $semesterCgpa = $earnedCreditPoint ? ($earnedCreditPoint/$totalCredit) : 0;
            $earnedCreditForDisplay +=  $earnedCredit;
            $earnedCreditForDisplay +=  $semWiseAdditionalCredit;
            foreach($student->academicTerms as $academicTerm){
                $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->id = $academicTerm->id;
                $semesterNames = CommonExamService::getInstance()->getDifferentSemesterName($academicTerm->name);
                $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->semInRomanLetter = $semesterNames->romanLetter;
                $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->semInFullName = $semesterNames->fullName;
                $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->semInSemNumber = $semesterNames->semNumber;
                $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->semesterWiseFailedStatus = $academicTerm->isFailed;
                foreach($academicTerm->markHistory as $semMarkHistory){
                    if($semMarkHistory->examRegistrationId == $examRegistrationDetails->examRegistrationId){
                        if($examRegistrationDetails->isStaffSideExamResultSheet == '1'){
                            if ( $semMarkHistory->hasRevaluationMark ){
                                $currentRegistration = reset(array_filter($revaluationRegistrations,function($value)use($semMarkHistory){
                                    return $value->id == $semMarkHistory->revaluationId;
                                }));
                                $revaluationBatch = reset($currentRegistration->groups);
                                if ( $revaluationBatch->properties->isResultPublished != 1 || strtotime($revaluationBatch->properties->publishingStartDate) > strtotime(date("Y-m-d H:i"))){
                                    $semMarkHistory->sgpa = $semMarkHistory->withoutRevaluationsgpa;
                                    $semMarkHistory->failedStatus = $semMarkHistory->withoutRevaluationFailedStatus;
                                }
                            }
                        }
                        $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->examRegistrationWiseFailedStatus = $semMarkHistory->failedStatus;
                        $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->failedStatus = $semMarkHistory->failedStatus;
                        $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->semesterGrade = $semMarkHistory->grade;
                        $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->semesterCredit = $academicTerm->credit;
                        $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->semesterResultStatus = $semMarkHistory->failedStatus == "PASSED" ? "P" : "F";
                        $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->semesterGradePoint = $semMarkHistory->gradePoint;
                        $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->semesterCreditGradePoint = $semMarkHistory->creditGradePoint;
                        $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->semesterSgpa = sprintf('%0.2f', $semMarkHistory->rawSgpa);
                        $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->semesterpassPercentage = $academicTerm->passPercentage;
                        $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->semesterTotalMinimumMarks = $academicTerm->totalMarks *  $academicTerm->passPercentage / 100;
                        $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->semesterTotalMarks = $academicTerm->totalMarks;
                        $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->semesterMarkObtained = $semMarkHistory->markObtained;
                        $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->semesterMarkObtainedInWord = strtoupper(CommonUtil::convertNumberToWords($semMarkHistory->totalMark))." ONLY";
                        $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->semesterPercentage = round($semMarkHistory->percentage,2);
                        $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->semesterClass = $semMarkHistory->class;
                        $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->semesterCgpa = sprintf('%0.2f', round($semesterCgpa, 2));
                        $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->earnedCredits = $earnedCredit;
                        $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->semesterearnedCreditsForDisplay = $earnedCreditForDisplay;
                        $studentsDetails[$student->id]->overallClass =  $semMarkHistory->class;
                        $studentsDetails[$student->id]->overallGrade= $semMarkHistory->grade;
                        $studentsDetails[$student->id]->failedStatus = $semMarkHistory->failedStatus;
                        $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->examType = $semMarkHistory->historyType;
                    }
                }
                foreach( $academicTerm->subjects as $subject){
                    if($examRegistrationDetails->isStaffSideExamResultSheet == '1'){
                        if ( $subject->subjectHasRevaluationMark ){
                            $currentRegistration = reset(array_filter($revaluationRegistrations,function($value)use($subject){
                                return $value->id == $subject->subjectRevaluationId;
                            }));
                            $revaluationBatch = reset($currentRegistration->groups);
                            if ( $revaluationBatch->properties->isResultPublished != 1 || strtotime($revaluationBatch->properties->publishingStartDate) > strtotime(date("Y-m-d H:i"))){
                                $subject->failedStatus = $subject->subjectWithoutRevaluationIsFailed == 1 ? "FAILED" : "PASSED";
                                $subject->isFailed = $subject->failedStatus;
                                $subject->grade = $subject->subjectWithoutRevaluationGrade;
                            }
                        }
                    }
                    $displaySubjectArray[$subject->id]= $subject;
                    $displaySubjectCategories[$subject->categoryId]->categoryId = $subject->categoryId;
                    $displaySubjectCategories[$subject->categoryId]->categoryName = $subject->categoryName;
                    $displaySubjectCategories[$subject->categoryId]->subjects[$subject->id] = $subject;
                    $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->subjects[$subject->id]->id = $subject->id;
                    $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->subjects[$subject->id]->name = $subject->name;
                    $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->subjects[$subject->id]->code = $subject->code;
                    $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->subjects[$subject->id]->priority = $subject->priority;
                    $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->subjects[$subject->id]->externalMaxMark = $subject->externalMaxMark;
                    $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->subjects[$subject->id]->internalMaxMark = $subject->internalMaxMark;
                    $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->subjects[$subject->id]->class = $subject->class;
                    $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->subjects[$subject->id]->grade = $subject->grade;
                    $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->subjects[$subject->id]->percentage = round($subject->percentage,2);
                    $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->subjects[$subject->id]->internalMark = $subject->internalMark;
                    $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->subjects[$subject->id]->externalMark = $subject->externalMark;
                    $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->subjects[$subject->id]->totalMaxMark = $subject->totalMarks;
                    $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->subjects[$subject->id]->markObtained = $subject->markObtained;
                    $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->subjects[$subject->id]->markObtainedInWord =  strtoupper(CommonUtil::convertNumberToWords((int)$subject->markObtained));
                    $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->subjects[$subject->id]->failedStatus = $subject->isFailed;
                    $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->subjects[$subject->id]->resultStatus = $subject->isFailed == "PASSED" ? "P" : "F";
                    $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->subjects[$subject->id]->attendanceStatus = $subject->attendanceStatus;
                    $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->subjects[$subject->id]->credit = $subject->credit;
                    $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->subjects[$subject->id]->creditGradePoint = $subject->credit * $subject->gradePoint;
                    $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->subjects[$subject->id]->gradePoint = $subject->gradePoint;
                    $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->subjects[$subject->id]->internalGrade = $subject->internalGrade;
                    $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->subjects[$subject->id]->externalGrade = $subject->externalGrade;
                    $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->subjects[$subject->id]->internalGradePoint = $subject->internalGradePoint;
                    $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->subjects[$subject->id]->externalGradePoint = $subject->externalGradePoint;
                    $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->subjects[$subject->id]->wgpa = $subject->wgpa;
                    $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->subjects[$subject->id]->isExternalFailed = $subject->isExternalFailed;
                    $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->subjects[$subject->id]->isInternalFailed = $subject->isInternalFailed;
                    $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->subjects[$subject->id]->isInternal = $subject->isInternal;
                    $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->subjects[$subject->id]->isExternal = $subject->isExternal;
                    $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->subjects[$subject->id]->categoryId = $subject->categoryId;
                    $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->subjects[$subject->id]->categoryName = $subject->categoryName;
                    $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->subjects[$subject->id]->internalPassPercentage = $subject->internalPassPercentage;
                    $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->subjects[$subject->id]->externalPassPercentage = $subject->externalPassPercentage;
                    $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->subjects[$subject->id]->aggregatePassPercentage = $subject->aggregatePassPercentage;
                    $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->subjects[$subject->id]->internalMinimumMark = $subject->internalMaxMark * $subject->internalPassPercentage / 100;
                    $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->subjects[$subject->id]->externalMinimumMark = $subject->externalMaxMark * $subject->externalPassPercentage / 100;
                    $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->subjects[$subject->id]->totalMinimumMark = $subject->totalMarks * $subject->aggregatePassPercentage / 100;
                    $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->subjects[$subject->id]->internalLetterGrade = $subject->internalLetterGrade;
                    $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->subjects[$subject->id]->internalAttendanceStatus = $subject->internalAttendanceStatus;
                    $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->subjects[$subject->id]->externalLetterGrade = $subject->externalLetterGrade;
                    $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->subjectCategories[$subject->categoryId]->categoryId = $subject->categoryId;
                    $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->subjectCategories[$subject->categoryId]->categoryName = $subject->categoryName;
                    $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->subjectCategories[$subject->categoryId]->subjects[$subject->id] = $subject;
                    $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->subjects[$subject->id]->latestExamYear = $subject->latestExamYear;
                    $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->subjects[$subject->id]->latestExamMonth = $subject->latestExamMonth;
                    $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->subjects[$subject->id]->latestExamMonthName = ExamRegistrationService::getInstance()->getMonthName($subject->latestExamMonth);
                    $displaySubjectArray[$subject->id]->totalMinimumMark = $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->subjects[$subject->id]->totalMinimumMark;
                    $displaySubjectArray[$subject->id]->totalSubjectMark = $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->subjects[$subject->id]->totalMaxMark;
                    if($subject->attendanceStatus == AttendanceStatusConstant::ABSENT){
                        $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->subjects[$subject->id]->externalMark = 'AB';
                        $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->subjects[$subject->id]->resultStatus = 'AB';
                    }
                    if($subject->consolidatedMarkDetails->excludeSubjectFromTotal == '1'){
                        $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->subjects[$subject->id]->grade = $subject->isFailed == "PASSED" ? 'P' : 'F' ;
                    }
                    if($subject->attendanceStatus == 'ABSENT'){
                        $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->subjects[$subject->id]->externalMark = 'AB';
                        $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->semesterResultStatus = 'AB';
                        $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->semesterClass = 'AB';
                        // $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->subjects[$subject->id]->grade = $examRegistrationData->courseTypeName != 'MBA' ? 'I' : 'AB';
                    }
                    else if($subject->attendanceStatus == 'MALPRACTICE'){
                        $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->subjects[$subject->id]->externalMark = 'MP';
                        $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->subjects[$subject->id]->resultStatus = 'MP';
                        // $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->subjects[$subject->id]->grade = 'MAL';
                    }
                    else if($subject->failedStatus == 'FAILED'){
                        $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->subjects[$subject->id]->grade = 'F';
                        $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->subjects[$subject->id]->resultStatus = 'F';
                    } 
                    if($subjectGradePassDetails[$subject->id]){
                        $subjectGradePassDetails[$subject->id]->passCount = $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->subjects[$subject->id]->resultStatus == 'P' ? $subjectGradePassDetails[$subject->id]->passCount + 1 : $subjectGradePassDetails[$subject->id]->passCount;
                        $subjectGradePassDetails[$subject->id]->failCount = $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->subjects[$subject->id]->resultStatus == 'F' ? $subjectGradePassDetails[$subject->id]->failCount + 1 : $subjectGradePassDetails[$subject->id]->failCount;
                        $subjectGradePassDetails[$subject->id]->absentCount = $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->subjects[$subject->id]->resultStatus == 'AB' ? $subjectGradePassDetails[$subject->id]->absentCount + 1 : $subjectGradePassDetails[$subject->id]->absentCount;
                        $subjectGradePassDetails[$subject->id]->malPracticeCount = $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->subjects[$subject->id]->resultStatus == 'MAL' ? $subjectGradePassDetails[$subject->id]->malPracticeCount + 1 : $subjectGradePassDetails[$subject->id]->malPracticeCount;
                        $subjectGradePassDetails[$subject->id]->totalStudents = $subjectGradePassDetails[$subject->id]->totalStudents + 1;
                    }
                    else{
                        $subjectGradePassDetails[$subject->id]->id = $subject->id;
                        $subjectGradePassDetails[$subject->id]->passCount = $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->subjects[$subject->id]->resultStatus == 'P' ? 1 : 0;
                        $subjectGradePassDetails[$subject->id]->failCount = $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->subjects[$subject->id]->resultStatus == 'F' ? 1 : 0;
                        $subjectGradePassDetails[$subject->id]->absentCount = $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->subjects[$subject->id]->resultStatus == 'AB' ? 1 : 0;
                        $subjectGradePassDetails[$subject->id]->malPracticeCount = $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->subjects[$subject->id]->resultStatus == 'MAL' ? 1 : 0;
                        $subjectGradePassDetails[$subject->id]->totalStudents = 1;
                    }
                }
                // $studentsDetails[$student->id]->academicTerms[$academicTerm->id]->semesterCreditGradePoint = array_sum(array_column($studentsDetails[$student->id]->academicTerms[$academicTerm->id]->subjects,'creditGradePoint'));
                
            }
            
            if(count($student->academicTerms) > 1){
                $studentsDetails[$student->id]->overallClass = $student->class;
                $studentsDetails[$student->id]->overallGrade= $student->grade;
                $studentsDetails[$student->id]->failedStatus = $student->isFailed;
            }
            $studentsDetails[$student->id]->isResultBlock = false;
            $studentsDetails[$student->id]->blocResultMsg = "";
            if($examRegistrationDetails->isStaffSideExamResultSheet == '1'){
                $studentsDetails[$student->id]->isResultBlock = $student->isResultWithHeld == '1' ? true : false;
                $studentsDetails[$student->id]->blocResultMsg = $student->isResultWithHeld == '1' ? "Result Withheld" : "";
            }
        }
        uasort($studentsDetails[$student->id]->academicTerms[$academicTerm->id]->subjects, function($a, $b) {
            return ($a->priority > $b->priority);
        });
        $displaySubjectCategories = array_values($displaySubjectCategories); 
        foreach($displaySubjectCategories as $displaySubjectCategory){
            $displaySubjectCategory->subjects = array_values($displaySubjectCategory->subjects); 
        }
        uasort($displaySubjectArray, function($a, $b) {
            return ($a->priority > $b->priority);
        });
        $displaySubjectArray = array_values($displaySubjectArray); 
        foreach($studentsDetails as $student){
            $student->academicTerms = array_values($student->academicTerms); 
            foreach($student->academicTerms as $academicTerm){
                $academicTerm->subjects = array_values($academicTerm->subjects); 
                $academicTerm->subjectCategories = array_values($academicTerm->subjectCategories); 
                foreach($academicTerm->subjectCategories as $subCategory){
                    $subCategory->subjects = array_values($subCategory->subjects); 
                    $subCategory->totaCategoryAwardedMark = 0;
                    foreach($subCategory->subjects as $subject){
                        $subCategory->totaCategoryAwardedMark += $subject->internalMark + $subject->externalMark;
                    }
                    
                }
            } 
        }
        $passedStudentCount = 0;
        $failedStudentCount = 0;
        $absentStudentCount = 0;
        foreach($studentsDetails as $studentTerms){
            foreach($studentTerms->academicTerms as $student){
                if($classHeaderNames[strtoupper($student->semesterClass)]){
                    $classHeaderNames[strtoupper($student->semesterClass)]->count ++ ;
                }
                else{
                    $classHeaderNames[strtoupper($student->semesterClass)]->name = $student->semesterClass;
                    $classHeaderNames[strtoupper($student->semesterClass)]->count = 1;
                }
                $passedStudentCount = $student->semesterResultStatus == 'P' ? $passedStudentCount + 1 : $passedStudentCount;
                $failedStudentCount = $student->semesterResultStatus == 'F' ? $failedStudentCount + 1 : $failedStudentCount;
                $absentStudentCount = $student->semesterResultStatus == 'AB' ? $absentStudentCount + 1 : $absentStudentCount;
            }
        }
        foreach($subjectGradePassDetails as $subject){
            $subject->passPercentage = round(100 * ( $subject->passCount / $subject->totalStudents),2);
        }
        $totalStudentDetails->passPercentage = round(100 * ( $totalStudentDetails->passStudents / $totalStudentDetails->totalStudents),2);
        $response->studentsDetails = $studentsDetails;
        $response->displaySubjects = $displaySubjectArray;
        $response->displaySubjectCategories = $displaySubjectCategories;
        $response->classHeaderDetails = $classHeaderNames;
        $response->subjectGradePassDetails = $subjectGradePassDetails;
        $response->overAllPassPercentage =  round(100 * ( $passedStudentCount / count($studentsDetails)),2);
        return $response;
    }
}