Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
system	[ DIR ]	drwxr-xr-x
Dispatch_ans_script_setup.php	5.84 KB	-rwxr-xr-x
Dispatch_ans_script_setup_qp.p...	5.18 KB	-rwxr-xr-x
Ext-MarkEntry-Setup.php	21.23 KB	-rwxr-xr-x
FormulaEvaluate.php	14.15 KB	-rwxr-xr-x
MarkEntry-Setup.php	21.15 KB	-rwxr-xr-x
MarkEntry-Setup06.06.2016.php	20.43 KB	-rwxr-xr-x
MarkEntry-SetupTEST.php	21.01 KB	-rwxr-xr-x
MarkEntry-Setup_28102014.php	22.99 KB	-rwxr-xr-x
TAGMAY2013.pdf	331.03 KB	-rwxr-xr-x
TarkaFormatStyles.php	15.37 KB	-rwxr-xr-x
TarkaFormatStyles_old.php	3.71 KB	-rwxr-xr-x
absent_entry_setup.php	8.13 KB	-rwxr-xr-x
absent_entry_setupQp.php	7.3 KB	-rwxr-xr-x
absent_entry_setup_old.php	7.61 KB	-rwxr-xr-x
ack_exam_app_form.php	15.86 KB	-rwxr-xr-x
ack_exam_app_form11.php	13.87 KB	-rwxr-xr-x
ack_exam_app_form22.php	13.83 KB	-rwxr-xr-x
ack_exam_app_form_07032014.php	9 KB	-rwxr-xr-x
ack_exam_app_form_14032014.php	9.6 KB	-rwxr-xr-x
ack_exam_app_form_bulk.php	12.76 KB	-rwxr-xr-x
ack_rv_rt_application.php	8.5 KB	-rwxr-xr-x
ack_rv_rt_application01032017....	7.58 KB	-rwxr-xr-x
ack_rv_rt_application28072016....	7.57 KB	-rwxr-xr-x
ack_rv_rt_application_5days.ph...	7.41 KB	-rwxr-xr-x
ack_rv_rt_application_before_l...	6.02 KB	-rwxr-xr-x
actClass.php	6.21 KB	-rwxr-xr-x
admission_entry_status.php	2.73 KB	-rwxr-xr-x
attendance.php	6.13 KB	-rwxr-xr-x
auto-complete.php	4.89 KB	-rwxr-xr-x
backup_restore.php	8.14 KB	-rwxr-xr-x
backupandrestore.php	10.18 KB	-rwxr-xr-x
bundle_dispatch.php	2.84 KB	-rwxr-xr-x
cManualMailer.php	2.54 KB	-rwxr-xr-x
caccesscontext.php	1.24 KB	-rwxr-xr-x
candidate-entry.php	42.45 KB	-rwxr-xr-x
candidate-entry1.php	37 KB	-rwxr-xr-x
candidate-entry24082012.php	33.21 KB	-rwxr-xr-x
candidate-entry_220413.php	33.21 KB	-rwxr-xr-x
candidate-entry_without_iapr_i...	34.88 KB	-rwxr-xr-x
candidate-entrybefore yearexam...	34.55 KB	-rwxr-xr-x
candidate-entrykus.php	33.23 KB	-rwxr-xr-x
candidate-entryold.php	34.55 KB	-rwxr-xr-x
cappcontext.php	2.64 KB	-rwxr-xr-x
challan_entries.php	13.34 KB	-rwxr-xr-x
challan_preparation.php	10.28 KB	-rwxr-xr-x
cmailer.php	6.83 KB	-rwxr-xr-x
college.php	4.61 KB	-rwxr-xr-x
college_BEFORE_LOGINPOPUP.php	3.5 KB	-rwxr-xr-x
college_degree_status.php	5.86 KB	-rwxr-xr-x
collegewisedownload.php	5.7 KB	-rw-rw-r--
coutput.php	1.75 KB	-rwxr-xr-x
create_all_grid_files.php	8.57 KB	-rwxr-xr-x
create_all_grid_group_files.ph...	9.94 KB	-rwxr-xr-x
create_all_grid_group_files_ol...	9.61 KB	-rwxr-xr-x
create_all_popup_files.php	5.93 KB	-rwxr-xr-x
create_all_schema_files.php	4.31 KB	-rwxr-xr-x
create_all_views.php	16.52 KB	-rwxr-xr-x
create_html_files.php	52.03 KB	-rwxr-xr-x
create_html_files_without_tab....	44.49 KB	-rwxr-xr-x
create_module_meta_columns.php	5.16 KB	-rwxr-xr-x
crequestbroker.php	2.49 KB	-rwxr-xr-x
csessions.php	514 B	-rwxr-xr-x
cuser.php	3.41 KB	-rwxr-xr-x
custom_mregistry.php	122 B	-rwxr-xr-x
datadictionary.php	3.96 KB	-rwxr-xr-x
daterange.php	4.06 KB	-rwxr-xr-x
degree.php	6.51 KB	-rwxr-xr-x
degree1.php	6.78 KB	-rwxr-xr-x
display_details_in_grid.php	105.31 KB	-rwxr-xr-x
display_details_in_grid0306201...	101.68 KB	-rwxr-xr-x
display_details_in_grid22.php	102.08 KB	-rwxr-xr-x
display_details_in_grid_240320...	98.86 KB	-rwxr-xr-x
display_details_in_grid_before...	98.71 KB	-rwxr-xr-x
display_details_in_grid_custom...	2.68 KB	-rwxr-xr-x
display_details_in_grid_studta...	96.56 KB	-rwxr-xr-x
display_details_in_grid_withde...	97.45 KB	-rwxr-xr-x
download_misc_files.php	3.3 KB	-rwxr-xr-x
download_misc_files_19062014.p...	3.25 KB	-rwxr-xr-x
download_photo.php	5.77 KB	-rw-rw-r--
download_photo_old.php	4.82 KB	-rwxr-xr-x
download_photo_sikkim_14082021...	5 KB	-rwxr-xr-x
download_upload.php	3.86 KB	-rwxr-xr-x
dynamicmastersdetails.php	117.45 KB	-rwxr-xr-x
dynamicmastersdetails_23.php	120 KB	-rwxr-xr-x
dynamicmastersdetails_one.php	119.36 KB	-rwxr-xr-x
entryexitevents.php	3.09 KB	-rwxr-xr-x
error_log.php	749 B	-rwxrwxrwx
examAppchallan_entries.php	13.01 KB	-rwxr-xr-x
examAppchallan_preparation.php	9.87 KB	-rwxr-xr-x
execute_query.php	2.5 KB	-rwxr-xr-x
execute_query27062012.php	2.51 KB	-rwxr-xr-x
export_import_setup.php	7.62 KB	-rwxr-xr-x
export_import_utility.php	2.67 KB	-rwxr-xr-x
ext_freeze_module_at_admin_col...	8.58 KB	-rwxr-xr-x
format.php	7.43 KB	-rwxr-xr-x
freeze_Ad_Cl_Me.php	6.64 KB	-rwxr-xr-x
freeze_module_at_admin_college...	8.65 KB	-rwxr-xr-x
freeze_module_at_admin_college...	5.81 KB	-rwxr-xr-x
freeze_module_at_admin_college...	7.76 KB	-rwxr-xr-x
freeze_module_at_university_co...	7.45 KB	-rwxr-xr-x
general_report_format.php	11 KB	-rwxr-xr-x
getAutoCompleteFromFrameWork.p...	2.97 KB	-rwxr-xr-x
getdata.php	33.44 KB	-rwxr-xr-x
getdata110911.php	16.03 KB	-rwxr-xr-x
getdata22.php	28.7 KB	-rwxr-xr-x
getdata27062012.php	16.8 KB	-rwxr-xr-x
getdata_24032015.php	20.96 KB	-rwxr-xr-x
getfeeinformation.php	6.17 KB	-rwxr-xr-x
getmoduledetails.php	23.7 KB	-rwxr-xr-x
getnumword.php	7.42 KB	-rwxr-xr-x
getreportdetails.php	3.21 KB	-rwxr-xr-x
getreportfilefordisplay.php	1.37 KB	-rwxr-xr-x
getsearchcondition.php	1.3 KB	-rwxr-xr-x
ggridmodel.php	9.27 KB	-rwxr-xr-x
golden_palm_payslip.php	12.48 KB	-rwxr-xr-x
helptext.php	5.38 KB	-rwxr-xr-x
identify_transactions.php	6.4 KB	-rwxr-xr-x
import_marks.php	4.11 KB	-rwxr-xr-x
json.php	33.22 KB	-rwxr-xr-x
login.php	8.39 KB	-rwxr-xr-x
login.php_1	3.25 KB	-rwxr-xr-x
login27062012.php	2.85 KB	-rwxr-xr-x
login_03032015.php	3.6 KB	-rwxr-xr-x
login_BEFORE_LOGINPOPUP.php	3.25 KB	-rwxr-xr-x
login_old.php	3.15 KB	-rwxr-xr-x
markEntry-Setup2.php	21.93 KB	-rwxr-xr-x
message_board.php	4.67 KB	-rwxr-xr-x
module_setup.php	2.48 KB	-rwxr-xr-x
mregistry.php	73.53 KB	-rwxr-xr-x
mregistry22.php	66.82 KB	-rwxr-xr-x
mregistry24042015.php	55.01 KB	-rwxr-xr-x
mregistry_16012017.php	65.48 KB	-rwxr-xr-x
mregistry_before_subupdtostud_...	52.68 KB	-rwxr-xr-x
mregistry_beforedownload.php	53.04 KB	-rwxr-xr-x
mrn_approval.php	9 KB	-rwxr-xr-x
receive_rv_rt_application.php	7.65 KB	-rwxr-xr-x
report_setup.php	25.12 KB	-rwxr-xr-x
report_tool.php	73.03 KB	-rwxr-xr-x
revaluation.php	16.66 KB	-rwxr-xr-x
revaluation_oldtype.php	8.45 KB	-rwxr-xr-x
revaluation_withdegree.php	16.77 KB	-rwxr-xr-x
room_allotment.php	7.21 KB	-rwxr-xr-x
rvdates.php	6.46 KB	-rwxr-xr-x
sendLoginPassword.php	3.09 KB	-rwxr-xr-x
serchbygrid.php	822 B	-rwxr-xr-x
student_entry.php	37.9 KB	-rwxr-xr-x
student_entry1307.php	37.71 KB	-rwxr-xr-x
student_entry17.06.2016.php	36.46 KB	-rwxr-xr-x
student_entry27062012.php	30.47 KB	-rwxr-xr-x
student_entry_09102019.php	33.1 KB	-rwxr-xr-x
student_entry_old_06102019.php	34.07 KB	-rwxr-xr-x
student_entryold.php	30.33 KB	-rwxr-xr-x
subjectList_display.php	11.01 KB	-rwxr-xr-x
subject_freshExam.php	32.57 KB	-rw-rw-r--
subject_freshExam_15072022.php	28.44 KB	-rwxr-xr-x
subjectfreez.php	6.23 KB	-rwxr-xr-x
system_utility.php	1.84 KB	-rwxr-xr-x
systemsetup.php	75.5 KB	-rwxr-xr-x
teachers.php	10.33 KB	-rwxr-xr-x
transaction-series.php	4.86 KB	-rwxr-xr-x
updateSection.php	3.86 KB	-rwxr-xr-x
update_defined_flag.php	3.41 KB	-rwxr-xr-x
updatefreshexam.php	1.33 KB	-rw-rw-r--
upload_studentPhoto.php	10.29 KB	-rwxr-xr-x
upload_studentPhoto02062015.ph...	11.58 KB	-rwxr-xr-x
upload_studentPhoto_before_dow...	8.02 KB	-rwxr-xr-x
uploadmoduledetails.php	39.65 KB	-rwxr-xr-x
usersetup.php	24.33 KB	-rwxr-xr-x
usersubj_identification.php	4.77 KB	-rwxr-xr-x

Code Editor : subject_freshExam_15072022.php

<?php

function replaceChars($name)
{
    $spl_char = array("*","/","~","!","@","#","$","%","^","&",":",";","?","/","\\","_","-","'"," ","");
    $link_name = strtolower(str_replace($spl_char,"_",$name));
    return str_ireplace("__","_",$link_name);
}
function PopulateFreshExamSubject($aobj_context)
{
    session_start();

$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
    $college_code = $_SESSION['collcode'];
    $Regno = $aobj_context->mobj_data["Regno"];
    $degree = $aobj_context->mobj_data["degree"];
    $exam = $aobj_context->mobj_data["Examno"];
    $prevFreshSub = $aobj_context->mobj_data["prevFreshSub"];
    $FLOGNAME =  $_SESSION['usr'];
    $exam_appear=array();

$query = "select * from collexam where fdegree = '{$degree}' 
	and fcollcode = '{$college_code}' 
	and fexamno = '{$exam}'
	and DATE_FORMAT(NOW(),'%Y-%m-%d') 
	BETWEEN DATE_FORMAT(fsubcrfrom,'%Y-%m-%d') 
	AND DATE_FORMAT(fsubcrto,'%Y-%m-%d') ";
	$student_exam_details = $aobj_context->mobj_db->GetRow($query); 
    
    if(strtoupper($_SESSION['user_type'])=='SUPERUSER')
    {

}
	else if(count($student_exam_details) > 0)
	{

}else
	{

$id="<tr style='height: 20'>";
        $id.="<td colspan=9 align = 'center'><b>Subject corrections are not available now!<b></td>";
        $id.="</tr>";
        $arr['html_data']=$id;
        echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"success");
		return;
		
	}

$qry = " select c.FDEGREE,c.FEXAMNO,c.FCOLLCODE,c.FREGNO,
			IF(IFNULL(c.FCATEGORY,'')='',if(ifnull(s.FCASTE,'') = '', 'GM', s.FCASTE) ,c.FCATEGORY) AS FCATEGORY,
			if(c.Fgender='',s.Fgender,c.Fgender) as Fgender,c.FAPPEARA,c.FEXAMFEEA,
			c.FAPPEARB,c.FEXAMFEEB,c.FAPPEARC,c.FEXAMFEEC,c.FAPPEARD,c.FEXAMFEED,c.FAPPEARE,
			c.FEXAMFEEE,c.FAPPEARF,c.FEXAMFEEF,c.FAPPEARG,c.FEXAMFEEG,c.FAPPEARH,c.FEXAMFEEH,
			c.FAPPEARI,c.FEXAMFEEI,c.FAPPEARJ,c.FEXAMFEEJ,round(c.FTOTALFEE,2) as FTOTALFEE,
			c.FYEAR,c.FEXAMTYPE,c.FDELETED,FRECPTNO,DATE_FORMAT(FRECPTDATE,'%d/%m/%Y') as FRECPTDATE
			,FREMARKS,c.FTOTSUBA,c.FTOTSUBB,c.FTOTSUBC,c.FTOTSUBD,c.FTOTSUBE,c.FTOTSUBF,c.FTOTSUBG,c.FTOTSUBH,
			c.FTOTSUBI,c.FTOTSUBJ,concat('*',c.FCONSTYPE) as FCONSTYPE,ifnull(c.FELIG,'0123456789') as FELIG,
			sum(if(t.fexamno = 'A',1,0)) as fcnta, sum(if(t.fexamno = 'B',1,0)) as fcntb,
			sum(if(t.fexamno = 'C',1,0)) as fcntc, sum(if(t.fexamno = 'D',1,0)) as fcntd,
			sum(if(t.fexamno = 'E',1,0)) as fcnte, sum(if(t.fexamno = 'F',1,0)) as fcntf,
			sum(if(t.fexamno = 'G',1,0)) as fcntg, sum(if(t.fexamno = 'H',1,0)) as fcnth,
			sum(if(t.fexamno = 'I',1,0)) as fcnti, sum(if(t.fexamno = 'J',1,0)) as fcntj,
			FRECPTNOA,DATE_FORMAT(FRECPTDATEA,'%d/%m/%Y') AS FRECPTDATEA,
			FRECPTNOB,DATE_FORMAT(FRECPTDATEB,'%d/%m/%Y') AS FRECPTDATEB,
			FRECPTNOC,DATE_FORMAT(FRECPTDATEC,'%d/%m/%Y') AS FRECPTDATEC ,
			FRECPTNOD,DATE_FORMAT(FRECPTDATED,'%d/%m/%Y') AS FRECPTDATED ,
			FRECPTNOE,DATE_FORMAT(FRECPTDATEE,'%d/%m/%Y') AS FRECPTDATEE ,
			FRECPTNOF,DATE_FORMAT(FRECPTDATEF,'%d/%m/%Y') AS FRECPTDATEF ,
			FRECPTNOG,DATE_FORMAT(FRECPTDATEG,'%d/%m/%Y') AS FRECPTDATEG ,
			FRECPTNOH,DATE_FORMAT(FRECPTDATEH,'%d/%m/%Y') AS FRECPTDATEH ,
			FRECPTNOI,DATE_FORMAT(FRECPTDATEI,'%d/%m/%Y') AS FRECPTDATEI ,
			FRECPTNOJ,DATE_FORMAT(FRECPTDATEJ,'%d/%m/%Y') AS FRECPTDATEJ ,
			FFRESHEXAM  
			from candsum c left join student s on s.FDEGREE=c.FDEGREE 
			and s.FREGNO=c.FREGNO
			left outer join canddet t
			on c.fdegree = t.fdegree and c.fregno = t.fregno
			where c.FDEGREE='{$degree}' 
			and c.FCOLLCODE='{$college_code}'
            and c.FREGNO='{$Regno}' 
            and ifnull(c.FFRESHEXAM,'') = '{$exam}'";
            
    $student_exam_details = $aobj_context->mobj_db->GetRow($qry);
    if($student_exam_details)
    {
                
        $fcnta  = $student_exam_details['fcnta'];
		$fcntb  = $student_exam_details['fcntb'];
		$fcntc  = $student_exam_details['fcntc'];	
		$fcntd  = $student_exam_details['fcntd'];
		$fcnte  = $student_exam_details['fcnte'];
		$fcntf  = $student_exam_details['fcntf'];
		$fcntg  = $student_exam_details['fcntg'];
		$fcnti  = $student_exam_details['fcnti'];
        $fcntj  = $student_exam_details['fcntj'];
        
        if($student_exam_details['FAPPEAR'.$exam]=='N')
        {
            $arr['html_data']="<tr style='height: 20px;color:red;font-size:18px;'><td COLSPAN=3 align = 'center'><b>Student is not eligible for the given examination<b></td></tr>";
            
            //$id=" id ='cand_entry_".$exam."'";
        }
        else if($student_exam_details['FAPPEAR'.$exam]=='P')
        {
            $arr['html_data']="<tr style='height: 20px;color:green;font-size:18px;'><td COLSPAN=3 align = 'center'><b>Student has already passed in the given examination.<b></td></tr>";
            
            //$id=" id ='cand_entry_".chr($i)."'";
        }
        else  if($student_exam_details['FAPPEAR'.$exam]=='A' || $student_exam_details['FAPPEAR'.$exam]=='E')
        {
            array_push($exam_appear,$exam);
        //$id=" id='cand_entry_".$exam."'";
        //$td_data="<Input  onclick=showExamNosDiv('{$html_id}'); {$id}  name='radio_common' type='radio'>";
        //$id='';
        }
        //if($exam ==$exam_appear);
    
         
        // $get_total_sub_for_degree="select * from degree where FDEGREE='{$degree}'";
        // $lobj_get_total_sub_for_degree = $aobj_context->mobj_db->GetAll($get_total_sub_for_degree);
         
        // for($j=0;$j<count($lobj_get_total_sub_for_degree);$j++)
        // {
        //     if($lobj_get_total_sub_for_degree[$j]['FEXAMNO']=='A')
        //     {
        //         $exam_A_limit=$lobj_get_total_sub_for_degree[$j]['FTOTSUB'];
        //         $semister_names['A']=$lobj_get_total_sub_for_degree[$j]['FEXAMNAME'];
        //     }
        //     else if($lobj_get_total_sub_for_degree[$j]['FEXAMNO']=='B')
        //     {
        //         $exam_B_limit=$lobj_get_total_sub_for_degree[$j]['FTOTSUB'];
        //         $semister_names['B']=$lobj_get_total_sub_for_degree[$j]['FEXAMNAME'];
        //     }
        //     else if($lobj_get_total_sub_for_degree[$j]['FEXAMNO']=='C')
        //     {
        //         $exam_C_limit=$lobj_get_total_sub_for_degree[$j]['FTOTSUB'];
        //         $semister_names['C']=$lobj_get_total_sub_for_degree[$j]['FEXAMNAME'];
        //     }
        //     else if($lobj_get_total_sub_for_degree[$j]['FEXAMNO']=='D')
        //     {
        //         $exam_D_limit=$lobj_get_total_sub_for_degree[$j]['FTOTSUB'];
        //         $semister_names['D']=$lobj_get_total_sub_for_degree[$j]['FEXAMNAME'];
        //     }
        //     else if($lobj_get_total_sub_for_degree[$j]['FEXAMNO']=='E')
        //     {
        //         $exam_E_limit=$lobj_get_total_sub_for_degree[$j]['FTOTSUB'];
        //         $semister_names['E']=$lobj_get_total_sub_for_degree[$j]['FEXAMNAME'];
        //     }
        //     else if($lobj_get_total_sub_for_degree[$j]['FEXAMNO']=='F')
        //     {
        //         $exam_F_limit=$lobj_get_total_sub_for_degree[$j]['FTOTSUB'];
        //         $semister_names['F']=$lobj_get_total_sub_for_degree[$j]['FEXAMNAME'];
        //     }
        //     else if($lobj_get_total_sub_for_degree[$j]['FEXAMNO']=='G')
        //     {
        //         $exam_G_limit=$lobj_get_total_sub_for_degree[$j]['FTOTSUB'];
        //         $semister_names['G']=$lobj_get_total_sub_for_degree[$j]['FEXAMNAME'];
        //     }
        //     else if($lobj_get_total_sub_for_degree[$j]['FEXAMNO']=='H')
        //     {
        //         $exam_H_limit=$lobj_get_total_sub_for_degree[$j]['FTOTSUB'];
        //         $semister_names['H']=$lobj_get_total_sub_for_degree[$j]['FEXAMNAME'];
        //     }
        //     else if($lobj_get_total_sub_for_degree[$j]['FEXAMNO']=='I')
        //     {
        //         $exam_I_limit=$lobj_get_total_sub_for_degree[$j]['FTOTSUB'];
        //         $semister_names['I']=$lobj_get_total_sub_for_degree[$j]['FEXAMNAME'];
        //     }
        //     else if($lobj_get_total_sub_for_degree[$j]['FEXAMNO']=='J')
        //     {
        //         $exam_J_limit=$lobj_get_total_sub_for_degree[$j]['FTOTSUB'];
        //         $semister_names['J']=$lobj_get_total_sub_for_degree[$j]['FEXAMNAME'];
        //     }
        // }

$get_total_sub_for_degree="select * from degree where FDEGREE='{$degree}'";
		$lobj_get_total_sub_for_degree = $aobj_context->mobj_db->GetAll($get_total_sub_for_degree); 
		$totsub = explode(',',$totsub);		 
		for($j=0;$j<count($lobj_get_total_sub_for_degree);$j++)
		{
			if($lobj_get_total_sub_for_degree[$j]['FEXAMNO'] == 'A')
			{

//var_dump($fcnta.' - '.$lobj_get_total_sub_for_degree[$j]['FEXAMNAME']);
				if($totsub[$j] > 0)
					$exam_A_limit = $totsub[$j];
				else if($fcnta > $lobj_get_total_sub_for_degree[$j]['FTOTSUB'])
					$exam_A_limit = $fcnta;
				else
					$exam_A_limit = $lobj_get_total_sub_for_degree[$j]['FTOTSUB'];
				
				$semister_names['A'] = $lobj_get_total_sub_for_degree[$j]['FEXAMNAME'];
			}
			else if($lobj_get_total_sub_for_degree[$j]['FEXAMNO']=='B')
			{ 
				if($totsub[$j] > 0)
					$exam_B_limit = $totsub[$j];
				else if($fcntb > $lobj_get_total_sub_for_degree[$j]['FTOTSUB'])
					$exam_B_limit = $fcntb;
				else
					$exam_B_limit=$lobj_get_total_sub_for_degree[$j]['FTOTSUB'];
				
				$semister_names['B']=$lobj_get_total_sub_for_degree[$j]['FEXAMNAME'];
			}
			else if($lobj_get_total_sub_for_degree[$j]['FEXAMNO']=='C')
			{
				if($totsub[$j] > 0)
					$exam_C_limit = $totsub[$j];
				else if($fcntc > $lobj_get_total_sub_for_degree[$j]['FTOTSUB'])
					$exam_C_limit = $fcntc;
				else
					$exam_C_limit=$lobj_get_total_sub_for_degree[$j]['FTOTSUB'];
				
				$semister_names['C']=$lobj_get_total_sub_for_degree[$j]['FEXAMNAME'];
			}
			else if($lobj_get_total_sub_for_degree[$j]['FEXAMNO']=='D')
			{
				if($totsub[$j] > 0)
					$exam_D_limit = $totsub[$j];
				else if($fcntd > $lobj_get_total_sub_for_degree[$j]['FTOTSUB'])
					$exam_D_limit = $fcntd;
				else
					$exam_D_limit=$lobj_get_total_sub_for_degree[$j]['FTOTSUB'];

$semister_names['D']=$lobj_get_total_sub_for_degree[$j]['FEXAMNAME'];
			}
			else if($lobj_get_total_sub_for_degree[$j]['FEXAMNO']=='E')
			{
				if($totsub[$j] > 0)
					$exam_E_limit = $totsub[$j];
				else if($fcnte > $lobj_get_total_sub_for_degree[$j]['FTOTSUB'])
					$exam_E_limit = $fcnte;
				else
					$exam_E_limit=$lobj_get_total_sub_for_degree[$j]['FTOTSUB'];
				
				$semister_names['E']=$lobj_get_total_sub_for_degree[$j]['FEXAMNAME'];
			}
			else if($lobj_get_total_sub_for_degree[$j]['FEXAMNO']=='F')
			{
				if($totsub[$j] > 0)
					$exam_F_limit = $totsub[$j];
				else if($fcntf > $lobj_get_total_sub_for_degree[$j]['FTOTSUB'])
					$exam_F_limit = $fcntf;
				else
					$exam_F_limit=$lobj_get_total_sub_for_degree[$j]['FTOTSUB'];
				
				$semister_names['F']=$lobj_get_total_sub_for_degree[$j]['FEXAMNAME'];
			}	
			else if($lobj_get_total_sub_for_degree[$j]['FEXAMNO']=='G')
			{
				if($totsub[$j] > 0)
					$exam_G_limit = $totsub[$j];
				else if($fcntg > $lobj_get_total_sub_for_degree[$j]['FTOTSUB'])
					$exam_G_limit = $fcntg;
				else
					$exam_G_limit=$lobj_get_total_sub_for_degree[$j]['FTOTSUB'];
				
				$semister_names['G']=$lobj_get_total_sub_for_degree[$j]['FEXAMNAME'];
			}
			else if($lobj_get_total_sub_for_degree[$j]['FEXAMNO']=='H')
			{
				if($totsub[$j] > 0)
					$exam_H_limit = $totsub[$j];
				else if($fcnth > $lobj_get_total_sub_for_degree[$j]['FTOTSUB'])
					$exam_H_limit = $fcnth;
				else
					$exam_H_limit=$lobj_get_total_sub_for_degree[$j]['FTOTSUB'];
				
				$semister_names['H']=$lobj_get_total_sub_for_degree[$j]['FEXAMNAME'];
			}
			else if($lobj_get_total_sub_for_degree[$j]['FEXAMNO']=='I')
			{
				if($totsub[$j] > 0)
					$exam_I_limit = $totsub[$j];
				else if($fcnti > $lobj_get_total_sub_for_degree[$j]['FTOTSUB'])
					$exam_I_limit = $fcnti;
				else
					$exam_I_limit=$lobj_get_total_sub_for_degree[$j]['FTOTSUB'];
				
				$semister_names['I']=$lobj_get_total_sub_for_degree[$j]['FEXAMNAME'];
			}
			else if($lobj_get_total_sub_for_degree[$j]['FEXAMNO']=='J')
			{
				if($totsub[$j] > 0)
					$exam_J_limit = $totsub[$j];
				else if($fcntj > $lobj_get_total_sub_for_degree[$j]['FTOTSUB'])
					$exam_J_limit = $fcntj;
				else
					$exam_J_limit=$lobj_get_total_sub_for_degree[$j]['FTOTSUB'];
				
				$semister_names['J']=$lobj_get_total_sub_for_degree[$j]['FEXAMNAME'];
			}
        }
        
        if(in_array($exam,$exam_appear))
        {
            $id='';
            $remaining_count=0;
            $id="\$exam_".$exam;
            $html_id="candidate_list_exam_".$exam."_details";
         
             $char_name=$exam;
             $max_limit="\$exam_".$char_name."_limit";
             eval("\$max_limit = \"$max_limit\";");
         
            $FEXAMNO=$exam;
            $id="<table  class='tr_ventor_row content-tbl' width='100%' border='0' cellspacing='0' cellpadding='0'>";
            $id.="<th align='left' colspan='10' class='ui-jqgrid-titlebar ui-widget-header ui-corner-tl ui-corner-tr ui-helper' style='font-size:10px; padding-left:6px; height:20px;'>{$semister_names[$FEXAMNO]}</th>";
            $id.="<tr class='ui-state-default ui-jqgrid-hdiv'>";
            $id.="<td align='center' style='  font-size:12px; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;width:100px;padding:5px 5px;'>Sub Code</td>";
            $id.="<td align='center' style='  font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;width:100px;padding:5px 5px;'>QP Code</td>";
            $id.="<td align='center' style='  font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;padding:5px 5px;'>Subject / Paper Name </td>";
            $id.="</tr>";
          
            $get_header_exam_details ="select c.FSUBCODE,s.FSUBNAME,ifnull(c.FPASSMTH,'') as FPASSMTH,
                                s.FQPCODE AS FSUBSHORT,c.FEXAMTYPE,
                                ifnull(c.FPRESENT,'N') as FPRESENT,
                                'T' as FINSERTED, 
                                s.fmandatory from canddet c
                                inner join subject s on s.FDEGREE=c.FDEGREE
                                and s.FSUBCODE=c.FSUBCODE
                                where c.FDEGREE='{$degree}' and c.FCOLLCODE='{$college_code}' and
                                c.FEXAMNO='{$FEXAMNO}'  and
                                c.FREGNO='{$Regno}' and (s.fsubcode = ifnull(s.fvarsubgrp,'') or ifnull(s.fvarsubgrp,'') = '')
                                 group by c.FSUBCODE 
                                 order by c.FSUBCODE, FINSERTED,s.fmandatory desc
                                 limit $max_limit";
                                //var_dump($get_header_exam_details);
        $lobj_rs = $aobj_context->mobj_db->GetAll($get_header_exam_details);
        $remaining_count = $max_limit-count($lobj_rs);
        //var_dump($get_header_exam_details);
        $k=0;
        $txt_id=0;
          
                
        $subjectList='';
        for($m=0;$m<count($lobj_rs);$m++)
        {
            $code_pop_up_field="";
            $FSUBCODE=$lobj_rs[$m]['FSUBCODE'];
            $FSUBSHORT=$lobj_rs[$m]['FSUBSHORT'];
            $FSUBNAME=$lobj_rs[$m]['FSUBNAME'];
            if($lobj_rs[$m]['FPASSMTH']=='' or is_null($lobj_rs[$m]['FPASSMTH']))// to display pass M/Y based on the  value
            {
                $checked=($lobj_rs[$m]['FPRESENT']=='P')?" checked ":"";
                $FPASSMTH="<input type='checkbox' {$checked} id='exam_{$char_name}_ce_pass_{$txt_id}'>";
                $FPASSMTH_TD="";
                $code_pop_up_field="";
            }
            else
            {
                $FPASSMTH=$lobj_rs[$m]['FPASSMTH'];
                $FPASSMTH_TD=" id='exam_{$char_name}_ce_pass_{$txt_id}' ";
                $code_pop_up_field='readonly=true;';
			}
			
            if($lobj_rs[$m]['fmandatory'] !='T' && $lobj_rs[$m]['FINSERTED'] == 'T')// to display text box for the value if FINSERTED=''T
            {
                //$subjectInstList.=$FSUBCODE."*";
                $sub_code_input_border=    "background-color:#fff";
                $sub_code_input_popup=" onblur='getSubDetails(this.id,{$txt_id});'  onkeydown='return keyboardSubjectAppearingPopup(event,this.id);'";
                $sub_code_input_name="di";
                $input_tab_indx=" tabindex={$txt_id}";
                $read_only=" ";
            }
            else
            {
                $subjectPrevList.=$FSUBCODE."*";
                $sub_code_input_border=    " border:none;";
                $sub_code_input_popup=    "";
                $sub_code_input_name="update";
                $input_tab_indx=" tabindex=-1";
                $read_only=" readonly";
            }
            if($k%2==0)
            {
                $class='tbl_row';
                $inp_class='tbl_row_input';
            }
            else
            {
                $input_class='tbl_row1';
                $inp_class='tbl_row1_input';
            }
			$subjectList.=$FSUBCODE."*";
			
			$idsub = "exam_{$char_name}_ce_sub_code_{$txt_id}";

$id.="<tr>";
            $id.="<td align='center' style='  font-size:12px;   border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'><input {$code_pop_up_field} {$inp_class} type=text style='width:60px; text-align:center;{$sub_code_input_border}' {$read_only} {$sub_code_input_popup} name='{$sub_code_input_name}'   id='exam_{$char_name}_ce_sub_code_{$txt_id}'  {$input_tab_indx} value='{$FSUBCODE}'> <input  style='text-align:center;' type = 'hidden' id = 'old_exam_{$char_name}_ce_sub_code_{$txt_id}' value='{$FSUBCODE}'> </td>";
            $id.="<td align='center'  style='  font-size:12px;   border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'id='exam_{$char_name}_ce_short_name_{$txt_id}' > {$FSUBSHORT}</td>";
            $id.="<td align='left' id='exam_{$char_name}_ce_desc_{$txt_id}'  style='  font-size:12px;    border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;padding:5px 5px;'>   {$FSUBNAME}</td>";
            $id.="</tr>";
            $k++;
            $txt_id++;
        }
        
        $subject_prev_query = "select distinct FSUBCODE,FSUBNAME,FQPCODE AS FSUBSHORT from subject
        where  INSTR('{$prevFreshSub}',FSUBCODE) and fdegree='{$degree}' group by  FSUBCODE";
        $lobj_subject_prev = $aobj_context->mobj_db->GetAll($subject_prev_query);

if($remaining_count>0)
        {
            $k=0;
            for($j=0;$j<$remaining_count;$j++)
            {
                
                if($k%2==0)
                {
                    $class='tbl_row';
                    $inp_class='tbl_row_input';
                }
                else
                {
                    $input_class='tbl_row1';
                    $inp_class='tbl_row1_input';
                }
                
                $FSUBCODE=$lobj_subject_prev[$j]['FSUBCODE'];
                $FSUBSHORT=$lobj_subject_prev[$j]['FSUBSHORT'];
                $FSUBNAME=$lobj_subject_prev[$j]['FSUBNAME'];
				$idsub = "exam_{$char_name}_ce_sub_code_{$txt_id}";
				
                 $id.="<tr>";
                 $id.="<td align='center'   style=' font-size:12px;   border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'><input  type='text' {$inp_class} name='new_insert'  onblur='getSubDetails(this.id,{$txt_id});'  onkeydown='return keyboardSubjectAppearingPopup(event,this.id);' style='width:60px;background-color:none' tabindex={$txt_id}   id='exam_{$char_name}_ce_sub_code_{$txt_id}' value='{$FSUBCODE}'> <input type = 'hidden'  id = 'old_exam_{$char_name}_ce_sub_code_{$txt_id}' value='{$FSUBCODE}'></td>";
                 $id.="<td align='center'  style=' font-size:12px;   border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'id='exam_{$char_name}_ce_short_name_{$txt_id}'>{$FSUBSHORT}</td>";
                 $id.="<td align='left'  id='exam_{$char_name}_ce_desc_{$txt_id}'   style=' font-size:12px;   border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>{$FSUBNAME}</td>";
                 $id.="</tr>";
                 $k++;
                 $txt_id++;
            }
        }
        
            // if(empty($lobj_rs))
            // {
            //     $id.="<tr style='height: 20'>";
            //     $id.="<td COLSPAN=3 align = 'center'><b>No Records Found For this Search<b></td>";
            //     $id.="</tr>";
            // }
            $total_count_of_each_div[$html_id]=$txt_id;
            $exam_fee_val=$exam_fee[$html_id];
        
            $exam_receipt_no_val=$exam_receipt_no[$html_id];
            $exam_receipt_no_date_val=$exam_receipt_no_date[$html_id];
            
            $arr['html_data']=$id;
            $arr['total_count_of_each_div']=$total_count_of_each_div;
            
            $arr['subject_pre']=$subjectPrevList;
            /* if($remaining_count>0)
            $arr['subject_pre']=$subjectPrevList;
            else
            $arr['subject_pre']=$subjectInstList; */
        }
        echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success");
        return;
    }
    else
    {
        $id="<tr style='height: 20'>";
        $id.="<td COLSPAN=3 align = 'center'><b>No Records Found For this Search<b></td>";
        $id.="</tr>";
        $arr['html_data']=$id;
        echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"success");
        return;
    }
        
}

function saveFreshExamEntry($aobj_context)
{
    session_start();
    include_once("/JSON.php");
    $json = new Services_JSON();
    $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
    $college_code = $_SESSION['collcode'];
    $FLOGNAME =  $_SESSION['usr'];
    $reg_no = $aobj_context->mobj_data["reg_no"];
    $degree = $aobj_context->mobj_data["degree"];
    $exam = $aobj_context->mobj_data["fresh_exam"];
    $lstr_param = stripslashes($aobj_context->mobj_data["details"]);
    $mobj_jsondata = $json->decode($lstr_param);
    $sub_arr_data = get_object_vars($mobj_jsondata);
    $sub_prev= $aobj_context->mobj_data["prevSubj"];
    $sub_prev_in = str_replace("*", "','", $sub_prev);
    // var_dump($sub_prev);
    $sub_prev = explode("*", $sub_prev);
    // var_dump($sub_prev);
    $check_adminsion_freeze ="  select distinct c.FCCLSTATUS, d.fmeyear, d.fmeexamtyp from colldeg c, degree d
                                    where c.fdegree = d.fdegree and c.FCOLLCODE='{$college_code}'
                                    and c.FDEGREE='{$degree}'";
	$lobj_check_adminsion_freeze = $aobj_context->mobj_db->getRow($check_adminsion_freeze);

$qry ="select distinct * from canddet c
                                    where c.FCOLLCODE='{$college_code}'
									and c.FDEGREE='{$degree}'
									and c.fregno = '{$reg_no}'
                                    and ifnull(fexamno,'') ='{$exam}'
                                    and fpresent = 'P'";
	$res = $aobj_context->mobj_db->getRow($qry);

$prs = "";
	if($res)
	{	
		$prs = "P";
	}	
	
    $prs = "P";
	
	
    
        $lstr_sub_fee = stripslashes($aobj_context->mobj_data["sub_fee"]);
        $mobj_lstr_sub_fee = $json->decode($lstr_sub_fee);
        $sub_fee_data = get_object_vars($mobj_lstr_sub_fee);

//delete Newly inserted records
        
        $exam_data='';
        $char_id=$exam;
        $exam_data=get_object_vars($sub_arr_data[$char_id]);
        
        // var_dump($exam_data);
        $SubjectArray[1]=$exam_data;
        $exam_Subjdata='';
        $exam_Subjdata=get_object_vars($sub_arr_data[$char_id]);
        
// do insert/update
        $sub_fresh='';
        $char_id=$exam;
        
        
        if(!empty($exam_Subjdata))
        {
            for($k=0;$k<count($exam_Subjdata);$k++)
            {
                    
                if (!in_array($exam_Subjdata[$k]->sub, $sub_prev, true)) {
                        $sub_fresh.=$exam_Subjdata[$k]->sub.'*';
                    }
                    
				if($exam_Subjdata[$k]->sub != $exam_Subjdata[$k]->oldsub)
				{
					
					if($exam_Subjdata[$k]->oldsub == "")
					{
						$query="insert into canddet
						(FDEGREE,
						FEXAMNO,
						FCOLLCODE,
						FREGNO,
						FSUBCODE,
						FINSERTED,
						FPRESENT, fyear, fexamtype, fmoduser, fmoddate) values
						(
						'{$degree}',
						'{$exam_Subjdata[$k]->ex}',
						'{$college_code}',
						'{$reg_no}',
						'{$exam_Subjdata[$k]->sub}',
						'T',
						'{$prs}', '{$lobj_check_adminsion_freeze['fmeyear']}', '{$lobj_check_adminsion_freeze['fmeexamtyp']}',
						'{$FLOGNAME}',now()
						)";
						$lobj_insert_canddet_records = $aobj_context->mobj_db->Execute($query);
					}else
					{
						$query = "update canddet set fsubcode = '{$exam_Subjdata[$k]->sub}',
						fpresent = '{$prs}', fmoduser = '{$FLOGNAME}', fmoddate = now()
						where fregno = '{$reg_no}' and fcollcode = '{$college_code}' and fdegree = '{$degree}' 
						and fsubcode = '{$exam_Subjdata[$k]->oldsub}'";
						$lobj_insert_canddet_records = $aobj_context->mobj_db->Execute($query);

$query1 = "update appcanddet set fsubcode = '{$exam_Subjdata[$k]->sub}',
						fpresent = '{$prs}'
						where fregno = '{$reg_no}' and fcollcode = '{$college_code}' and fdegree = '{$degree}' 
						and fsubcode = '{$exam_Subjdata[$k]->oldsub}'";
						$res = $aobj_context->mobj_db->Execute($query1);

}

$query1 = "insert ignore into marks (FDEGREE, FEXAMNO, FCOLLCODE, FREGNO, FSUBCODE, fmarks, fyear, fexamtype)
                    select c.fdegree,c.fexamno,c.fcollcode,c.fregno,
                    s.fcsubcode,'-1', c.fyear,c.fexamtype
                    from candsum c inner join 
                    subject s on c.fdegree = s.fdegree and  s.fexamno = '{$exam_Subjdata[$k]->ex}'
                    and s.FSUBCODE	= '{$exam_Subjdata[$k]->sub}'
                    where c.fregno = '{$reg_no}'
                    and c.fcollcode = '{$college_code}' and c.fdegree = '{$degree}'
                    and s.fintass = 'T' and s.fretain = 'T'";
                    $res = $aobj_context->mobj_db->Execute($query1); 
                    
                    $query = "insert ignore into marks_pr (FDEGREE, FEXAMNO, FCOLLCODE, FREGNO, FSUBCODE, fmarks11, fyear, fexamtype)
                    select cd.fdegree,cd.fexamno,cd.fcollcode,cd.fcollcode,s.fcsubcode,'-1', 
                    cd.fyear,cd.fexamtype
                    from subject s inner join candsum cd on s.fdegree = cd.fdegree 
                    and s.fsubcode = '{$exam_Subjdata[$k]->sub}'
                    and cd.fregno = '{$reg_no}'
                    and ifnull(cd.fpassmth,'') = '' 
                    and ifnull(cd.fthpr,'') <> 'F'
                    where s.fdegree = '{$degree}' 
                    and cd.fcollcode = '{$college_code}'
                    and s.ftheory = 'F'
                    and ifnull(s.fintass,'F') <> 'T'";
                    $res = $aobj_context->mobj_db->Execute($query);
					
				}	
            }
        }
            
        if($lobj_insert_canddet_records)
        {
            $select_nxtreg_query="select FREGNO from student where FREGNO > '{$reg_no}' and FCOLLCODE='{$college_code}' order by FREGNO limit 1";
            $lobj_select_nxtreg=$aobj_context->mobj_db->getRow($select_nxtreg_query);
            $preg_details=array();
            $preg_details[0]=$reg_no;
            $preg_details[1]=$degree;
            $preg_details[2]=$exam;
            $arr['prev_reg']=$preg_details;
            $arr['next_reg']=$lobj_select_nxtreg;
            $arr['prev_subjects']=$sub_fresh;
            //$arr='Details Updated Successfully';
            echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success");
            return;
        }
        else
        {
            $arr='Updation failed';
            $arr['prev_subjects']='';
            echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"success");
            return;
        }
    
}
?>

${this.title}

Code Editor : subject_freshExam_15072022.php