Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
output	[ DIR ]	drwxr-xr-x
DownloadExamAppFormApplication...	4.49 KB	-rwxr-xr-x
DownloadRvRtAckApplications.ph...	4.6 KB	-rwxr-xr-x
GenerateABMPReportQp.php	5.76 KB	-rw-r--r--
Genprpendsubcnt.php	6.44 KB	-rw-r--r--
PC_RV_Report.php	7.25 KB	-rw-r--r--
PracticalIndent.php	5.57 KB	-rw-r--r--
PrintChallanEntryDetails.php	8.27 KB	-rwxr-xr-x
RvRtApplicationReport.php	8.76 KB	-rwxr-xr-x
appear_list_center_qp_wise.php	8.84 KB	-rwxr-xr-x
appear_list_center_qp_wise_bf_...	8.76 KB	-rwxr-xr-x
appear_list_center_qp_wise_old...	5.42 KB	-rwxr-xr-x
appear_list_qp_wise.php	5.29 KB	-rwxr-xr-x
batch_wise_details.php	4.45 KB	-rwxr-xr-x
bundle_ack.php	12.84 KB	-rwxr-xr-x
bundle_rec_ack.php	5.68 KB	-rwxr-xr-x
categorywisereport.php	6.53 KB	-rw-rw-r--
code39.php	6.38 KB	-rwxr-xr-x
generatePostAdmissionTicket.ph...	25.49 KB	-rwxr-xr-x
generatePostAdmissionTicket_ol...	28.01 KB	-rwxr-xr-x
generatecoporeport_xl.php	21.17 KB	-rw-rw-r--
gerderwiseresultsheet.php	9.62 KB	-rw-rw-r--
getReportClassStud.php	6.03 KB	-rw-rw-r--
getiaabsentreport.php	6.8 KB	-rw-rw-r--
iaroomallotmantsummary.php	5.28 KB	-rwxr-xr-x
qptablenot_upd_report.php	6.56 KB	-rw-r--r--
qrcodeGeneratePostAdmissionTic...	25.36 KB	-rwxr-xr-x
regNoAllot.php	35.47 KB	-rw-r--r--
reportAttClassCreate.php	5.14 KB	-rw-rw-r--
report_admission_details.php	26.8 KB	-rwxr-xr-x
report_admission_list.php	9.9 KB	-rwxr-xr-x
report_admission_list111.04.20...	6.67 KB	-rwxr-xr-x
report_admission_list30062012....	6.67 KB	-rwxr-xr-x
report_admission_list_wop.php	10.31 KB	-rwxr-xr-x
report_admission_ticket.php	32.45 KB	-rwxr-xr-x
report_admission_ticket0705201...	13.52 KB	-rwxr-xr-x
report_admission_ticket_011120...	27.16 KB	-rwxr-xr-x
report_admission_ticket_020420...	15.05 KB	-rwxr-xr-x
report_admission_ticket_111220...	15.04 KB	-rwxr-xr-x
report_admission_ticket_151220...	29.4 KB	-rwxr-xr-x
report_admission_ticket_291120...	13.75 KB	-rwxr-xr-x
report_admission_ticket_301020...	15.21 KB	-rwxr-xr-x
report_admission_ticket_before...	13.33 KB	-rwxr-xr-x
report_admission_ticket_kus.ph...	16.15 KB	-rwxr-xr-x
report_admission_ticket_org.ph...	26.02 KB	-rwxr-xr-x
report_attendance_summary.php	7.75 KB	-rwxr-xr-x
report_batch_wise_details.php	7.5 KB	-rwxr-xr-x
report_batch_worksheet_detail_...	10.33 KB	-rwxr-xr-x
report_batch_worksheet_details...	10.47 KB	-rwxr-xr-x
report_bundle_dispatch.php	11.37 KB	-rwxr-xr-x
report_bundle_dispatch_2605201...	7.93 KB	-rwxr-xr-x
report_bundle_dispatch_reva_21...	7.78 KB	-rwxr-xr-x
report_candidate_list.php	25.65 KB	-rwxr-xr-x
report_candidate_list_before_f...	25.19 KB	-rwxr-xr-x
report_candidate_list_before_s...	19.8 KB	-rwxr-xr-x
report_daliy_report.php	10.83 KB	-rwxr-xr-x
report_daliy_report_qp.php	19.29 KB	-rwxr-xr-x
report_daliy_report_qp_bf_tt.p...	18.53 KB	-rwxr-xr-x
report_daliy_report_qp_new.php	9.93 KB	-rwxr-xr-x
report_daliy_report_qp_old.php	12.09 KB	-rwxr-xr-x
report_daliy_report_qp_wait.ph...	9.9 KB	-rwxr-xr-x
report_degree_list.php	4.71 KB	-rwxr-xr-x
report_degree_list24042015.php	2.45 KB	-rwxr-xr-x
report_deviation_report.php	7.67 KB	-rwxr-xr-x
report_evaluation_report.php	9.31 KB	-rwxr-xr-x
report_ext_marks_entry_student...	5.56 KB	-rwxr-xr-x
report_ext_marks_entry_subwise...	10.53 KB	-rwxr-xr-x
report_ia_ra_invigilator_dairy...	20.72 KB	-rwxr-xr-x
report_iamarks_pending.php	5.74 KB	-rwxr-xr-x
report_marks_deviation_report....	5.38 KB	-rwxr-xr-x
report_marks_elementwise.php	4.35 KB	-rwxr-xr-x
report_marks_elementwise091220...	3.87 KB	-rwxr-xr-x
report_marks_elementwise220920...	4.67 KB	-rwxr-xr-x
report_marks_entry_student_lis...	5.58 KB	-rwxr-xr-x
report_marks_entry_subwise_lis...	10.2 KB	-rwxr-xr-x
report_marks_entry_subwise_lis...	10.13 KB	-rwxr-xr-x
report_marks_entry_subwise_lis...	10.2 KB	-rwxr-xr-x
report_marks_entry_subwise_lis...	10.02 KB	-rwxr-xr-x
report_marks_entry_subwise_lis...	12.03 KB	-rwxr-xr-x
report_marks_entry_subwise_lis...	10.51 KB	-rwxr-xr-x
report_marks_entry_subwise_lis...	10.13 KB	-rwxr-xr-x
report_marks_entry_subwise_lis...	10.2 KB	-rwxr-xr-x
report_marks_entry_subwise_lis...	9.16 KB	-rwxr-xr-x
report_marks_entry_subwise_lis...	10.05 KB	-rwxr-xr-x
report_online_eam.php	10.97 KB	-rwxr-xr-x
report_practical_marks_details...	13.35 KB	-rwxr-xr-x
report_practical_marks_details...	14.08 KB	-rwxr-xr-x
report_qpcount_univ.php	7.8 KB	-rwxr-xr-x
report_ra_exl_report.php	5.61 KB	-rwxr-xr-x
report_ra_invigilator_dairy.ph...	22.42 KB	-rw-r--r--
report_ra_invigilator_dairy_15...	20.73 KB	-rwxr-xr-x
report_ra_invigilator_dairy_bc...	22.39 KB	-rwxr-xr-x
report_ra_invigilator_dairy_bf...	20.05 KB	-rwxr-xr-x
report_ra_invigilator_dairy_ol...	21.5 KB	-rwxr-xr-x
report_ra_invigilators_dairy.p...	7.98 KB	-rwxr-xr-x
report_ra_qp_wise_student_coun...	7.38 KB	-rwxr-xr-x
report_ra_qp_wise_student_coun...	7.09 KB	-rwxr-xr-x
report_ra_roomwise_register_no...	7 KB	-rwxr-xr-x
report_ra_roomwise_register_no...	17.09 KB	-rwxr-xr-x
report_ra_roomwise_register_no...	26.16 KB	-rwxr-xr-x
report_ra_roomwise_register_no...	16.84 KB	-rwxr-xr-x
report_ra_roomwise_register_no...	16.79 KB	-rwxr-xr-x
report_revaluation.php	6.42 KB	-rwxr-xr-x
report_sectionwiselist.php	4.56 KB	-rwxr-xr-x
report_subject_admcl_list.php	3.48 KB	-rwxr-xr-x
report_subject_general_list.ph...	4.12 KB	-rwxr-xr-x
resultsheet.php	9.38 KB	-rw-rw-r--
revaQpindentCsv.php	7.94 KB	-rw-rw-r--
revaluation.php	15.65 KB	-rwxr-xr-x
roomallotmantsummary.php	5.69 KB	-rwxr-xr-x
roomallotmantsummary_bf_tt.php	5.73 KB	-rwxr-xr-x
roomwise_register_nos_list.php	29.61 KB	-rwxr-xr-x
roomwise_register_nos_list_bf_...	27.72 KB	-rwxr-xr-x
rotation.php	596 B	-rwxr-xr-x
stringspliter.php	693 B	-rwxr-xr-x
studentreport.php	14.53 KB	-rw-rw-r--
subject_wise_student_list.php	6.2 KB	-rwxr-xr-x
subjectwise_invigilator_dairy....	10.29 KB	-rwxr-xr-x
subjwisepasspercentage.php	11.88 KB	-rw-rw-r--
teacher_report.php	6.57 KB	-rwxr-xr-x

Code Editor : regNoAllot.php

<?php
    
        $main_src=substr($_SERVER['SCRIPT_FILENAME'],0,strlen($_SERVER['SCRIPT_FILENAME'])-7);
        $pdf_writer_class =$main_src."/tarka_pdf/fpdf.php";
        require_once($pdf_writer_class);
            
        class report_ra_roomwise_register_nos_list  extends FPDF
        {
            function DefaultConstructor($aobj_context)
            {
                session_start();
                $this->aobj_context=$aobj_context;
                $this->FUNIVCODE = $_SESSION['FUNIVCODE'];
                $this->pdf=  new FPDF();
                $this->pdf=$this;
                $this->roomchart=trim($this->aobj_context->mobj_data["roomchart"]);
                $this->pageeject=trim($this->aobj_context->mobj_data["pageeject"]);
                $this->fromdate = trim($this->aobj_context->mobj_data["fromdate"]);
               
                $this->fromqpcode = trim($this->aobj_context->mobj_data["fqpcode"]);
                $this->toqpcode = trim($this->aobj_context->mobj_data["tqpcode"]);
                $this->session = trim($this->aobj_context->mobj_data["session"]);
                $this->room_range_from = trim($this->aobj_context->mobj_data["room_range_from"]);
                $this->room_range_to = trim($this->aobj_context->mobj_data["room_range_to"]);
                $this->rtype = trim($this->aobj_context->mobj_data["rtype"]);
                $this->room_range_from = str_pad($this->room_range_from, 3, "0", STR_PAD_LEFT);  
                $this->room_range_to = str_pad($this->room_range_to, 3, "z", STR_PAD_LEFT); 
                
                $this->room_range_from=str_pad($this->room_range_from, 3, "0", STR_PAD_LEFT);  
                $this->room_range_to=str_pad($this->room_range_to, 3, "z", STR_PAD_LEFT);  
                
                $this->ip=$_SERVER["REMOTE_ADDR"];
                $get_date="select date_format(now(),'%d/%m/%Y %H:%i:%s') now_date";
                $obj=$this->aobj_context->mobj_db->GetRow($get_date);
                $this->current_date=$obj['now_date'];	
                $this->collcode=$_SESSION['collcode'];
               
            }
            
            function Footer()
            {
                $this->SetY(-15);
                $this->pdf->SetFont('Times','B',8);
                $this->Cell(140,6,'Printed   : IP Address : '.$this->ip." Date ".$this->current_date,'0',0,'L');
               // $this->Cell(50,6,'Page '.$this->PageNo().' of {nb}',0,1,'R');
            }
            
            function formcolldata()
            {
                $get_coll_name="select FUNIVNAME as 'FUNIVNAME', ifnull(fregroll, 'USN')as fregroll,
                                funivcode,ifnull(fsubas,'Subject') as fsubas,
                                FUNIVADD1 as 'state', pdf_logo_path From control";
                               
                $lobj_get_coll_name=$this->aobj_context->mobj_db->GetRow($get_coll_name);
                
                $this->FUNIVNAME=$lobj_get_coll_name['FUNIVNAME'];
                $this->fsubas=$lobj_get_coll_name['fsubas'];
             
                $this->funivcode1=$lobj_get_coll_name['funivcode'];
                
                $this->s_state=$lobj_get_coll_name['state'];
               
                $this->f_year=$lobj_get_coll_name['f_year'];
                
                $this->pdf_logo_path=$lobj_get_coll_name['pdf_logo_path'];
                //   $this->collcode=$lobj_get_coll_name['collcode'];
                  $this->collcode=$_SESSION['collcode'];

$get_data = "SELECT c.FCOLLCODE,if('{$this->funivcode1}' = '052',CONCAT('Center Code: ',c.FCOLLCODE),CONCAT(c.FCOLLCODE, ' - ', c.FCOLLNAME,', ',c.FTOWN)) AS FCOLLNAME FROM college c
                            where c.FCOLLCODE='{$this->collcode}'";

$obj_student=$this->aobj_context->mobj_db->GetRow($get_data); 
               
                 $this->college_details=$obj_student['FCOLLNAME'];
                $this->degree_details=" College : {$this->FCOLLNAME}";	
        
                if($_SESSION['fexamseparate'] == 'T')
                {
                    $FEXAMDATE = "fexexamdate as FEXAMDATE"; 
                }else
                {
                    $FEXAMDATE = "FEXAMDATE as FEXAMDATE"; 
                }	
        
                
                $get_qp_details="select {$FEXAMDATE},CONCAT(s.FSUBNAME,' ',s.FSSUBNAME) AS FSSUBNAME,fsubshort from subject s 
                inner join degree d on d. FDEGREE=s.FDEGREE and d.fexamno = s.fexamno 
                where s.FQPCODE='{$this->qp_code}'";
             
                $obj_get_qp_details=$this->aobj_context->mobj_db->GetRow($get_qp_details);
             
                $FSSUBNAME=$obj_get_qp_details['FSSUBNAME'];
               
                $fsubshort = $obj_get_qp_details['fsubshort'];
                $this->FEXAMDATE=$obj_get_qp_details['FEXAMDATE'];
           
                if($this->funivcode1 == '049'){
                    $this->sub_details="Course : {$this->qp_code} - {$FSSUBNAME} ";
                }
                else if($this->funivcode1 == '052')	{	
                    $this->sub_details="Subject : {$fsubshort} - {$FSSUBNAME} ( {$this->qp_code} )";
                    // var_dump($this->sub_details);die();
                }
                else{
                    $this->sub_details="Subject : {$this->qp_code} - {$FSSUBNAME} ";}
        
                $get_qp_data="SELECT distinct DATE_FORMAT(s.FDOE,'%d/%m/%Y') AS FDOE,s.FSESSION, r.fdescpn
                            FROM room_allotment ra inner join subject s on ra.fqpcode = s.fqpcode left outer join
                            reason r on s.fsession = r.freasoncd
                            WHERE ra.FCOLLCODE='{$this->collcode}'
                            AND ra.FQPCODE='{$this->qp_code}'";
                $obj_get_qp_data=$this->aobj_context->mobj_db->GetRow($get_qp_data);	
             
                
                $this->exam_date="Exam Date : {$obj_get_qp_data['FDOE']}, {$obj_get_qp_data['fdescpn']} ";
            }
            
            function GetFullQry()
            {
                $get_coll_name="select FUNIVNAME as 'FUNIVNAME', 
                funivcode, ifnull(fregroll, 'USN')as fregroll,
                FUNIVADD1 as 'state', pdf_logo_path From control";
               $lobj_get_coll_name=$this->aobj_context->mobj_db->GetRow($get_coll_name);
               $this->funivcode1=$lobj_get_coll_name['funivcode'];
               $this->fregroll = $lobj_get_coll_name['fregroll'];
                // var_dump( $this->funivcode1);
                
                if($this->session == 'both')
                {
                    $sectionvalue = "";
                }
                else 
                {
                    $sectionvalue = "and s.fsession like '{$this->session}%'";
                }
             
            }
                
            function formData()
            {
                $get_coll_name="select FUNIVNAME as 'FUNIVNAME',
                funivcode,
                FUNIVADD1 as 'state', pdf_logo_path From control";
               $lobj_get_coll_name=$this->aobj_context->mobj_db->GetRow($get_coll_name);
               $this->funivcode1=$lobj_get_coll_name['funivcode'];
                if($this->session == 'both')
                {
                    $sectionvalue = "";
                }
                else 
                {
                    $sectionvalue = "and s.fsession like '{$this->session}%'";
                    if($this->funivcode1 == '062')
                        $sectionvalue = "and t.fsessiont like '{$this->session}%'";
                    
                }
                
                if($this->funivcode1 == '027')
                {
                    $order = "masroom.froomno,";
                    
                }else
                {
                    $order = "masroom.forder,masroom.froomno,";
                }
                
        
                if($_SESSION['fexamseparate'] == 'T')
                {
                    $candsum = "examcandsum"; 
                    $canddet = "examcanddet"; 
        
                }else
                {
                    $candsum = "candsum"; 
                    $canddet = "canddet"; 
                }	
        
                $studenttmp = "student";
                if($this->funivcode1 == '049')
                    $this->roomchart = 'T';
             $query = "select d.fdeggrp from degree d inner join subject s on d.fdegree = s.fdegree
                    and d.fexamno = s.fexamno
                    where s.fdoe = date_format(str_to_date('{$this->fromdate}','%d/%m/%Y'),'%Y-%m-%d')";
                    $res = $this->aobj_context->mobj_db->GetAll($query);
                    $fdeggrp = $res['fdeggrp'];
               
                    
                    if($fdeggrp ='BED' && ($this->funivcode1 == '027' || $this->funivcode1 == '026') )
                    {
                        $order = "st.fname, cd.FREGNO";
        
                    }else if($this->funivcode1 == '046')
                    {
                        $order = "s.FQPCODE,st.fayear,cd.FREGNO";
                    }else if($this->funivcode1 == '055' || $this->funivcode1 == '062')
                    {
                        $order = "cd.fslno,cd.FREGNO";
                    }
                    else
                    {
                        $order = "s.FQPCODE, cd.FREGNO";
                    }
                
                    if($this->funivcode1 == '012')
                    {
                        $orderby = "lpad(cd.FHALLNO,3,'0'),LPAD(ra.forder, 3, '0')";
                        
                    }else if($this->funivcode1 == '033' || $this->funivcode1 == '049' ||$this->funivcode1 == '052')
                    {
                        $orderby = "lpad(cd.FHALLNO,3,'0'),LPAD(cd.fslno, 3, '0')";
                    }else if($this->funivcode1 == '055' || $this->funivcode1 == '062')
                    {
                        $orderby = "lpad(cd.FHALLNO,3,'0'),LPAD(cd.fslno, 3, '0')";
                    }
                    else
                    {
                        $orderby = "LPAD(ra.forder, 3, '0')";
                    }
        
                if($this->funivcode1 == '060' || $this->funivcode1 == '062x')
                {
                    $get_data = "SELECT cd.FHALLNO,group_concat(cd.fslno,'*',cd.FREGNO order by {$order}) as fregno, 
                    masroom.froomname, s.fqpcode, ra.forder,
                    count(cd.fregno) as regcnt 
                    FROM {$canddet} cd  INNER JOIN subject s ON s.fdegree = cd.fdegree 
                    and s.fexamno = cd.fexamno and s.FSUBCODE=cd.FSUBCODE 
                    inner join {$candsum} cs on cs.FREGNO=cd.FREGNO 
                    AND cd.FCOLLCODE=cs.FCOLLCODE 
                    inner JOIN masroom ON masroom.froomno = FHALLNO and masroom.fcollcode = cs.fcntrcode 
                    inner join room_allotment ra on cs.fcntrcode = ra.fcollcode 
                    inner join {$studenttmp} st on cs.fregno = st.fregno and cs.fcollcode = st.fcollcode
                    and cs.fdegree = st.fdegree
                    and s.fqpcode = ra.fqpcode and ra.fhallno = masroom.froomno
                    inner JOIN reason r ON s.FSESSION = r.FREASONCD 
                    WHERE cs.FCNTRCODE='{$this->collcode}' 
                    and s.FQPCODE between '{$this->fromqpcode}' and '{$this->toqpcode}' 
                    and ifnull(cd.FHALLNO,'') <> '' 
                    and INSTR(cs.fhtenable,cd.fexamno) >0
                    AND lpad(cd.FHALLNO,3,'0') between '{$this->room_range_from}' and '{$this->room_range_to}' 
                    and s.fdoe = date_format(str_to_date('{$this->fromdate}','%d/%m/%Y'),'%Y-%m-%d') 
                    and ifnull(cd.fpassmth,'') = '' AND cd.FPRESENT='P' 
                    AND IFNULL(cs.FRECPTDATE,'0000-00-00')<>'0000-00-00' 
                    {$sectionvalue}
                    group by cd.FHALLNO 
                    order by {$orderby}
                    ";
                } else if($this->funivcode1 == '062')
                {
                    $get_data = "SELECT cd.FHALLNO,group_concat(cd.fslno,'*',cd.FREGNO order by {$order}) as fregno, 
                                masroom.froomname, s.fqpcode, 
                                count(cd.fregno) as regcnt 
                                FROM {$canddet} cd  INNER JOIN subject s ON s.fdegree = cd.fdegree 
                                and s.fexamno = cd.fexamno and s.FSUBCODE=cd.FSUBCODE 
                                inner join {$candsum} cs on cs.FREGNO=cd.FREGNO 
                                AND cd.FCOLLCODE=cs.FCOLLCODE 
                                inner JOIN masroom ON masroom.froomno = FHALLNO and masroom.fcollcode = cs.fcntrcode 
                                
                                inner join {$studenttmp} st on cs.fregno = st.fregno and cs.fcollcode = st.fcollcode
                                and cs.fdegree = st.fdegree
                                
                                inner join timetable t on s.fqpcode = t.fqpcode
                                and t.fyear = cd.fyear
                                and t.fexamtype = cd.fexamtype
                                inner JOIN reason r ON t.fsessiont = r.FREASONCD 
                                WHERE cs.FCNTRCODE='{$this->collcode}' 
                                and s.FQPCODE between '{$this->fromqpcode}' and '{$this->toqpcode}' 
                                and ifnull(cd.FHALLNO,'') <> '' 
                                and INSTR(cs.fhtenable,cd.fexamno) >0
                                AND lpad(cd.FHALLNO,3,'0') between '{$this->room_range_from}' and '{$this->room_range_to}' 
                                and t.fdate = date_format(str_to_date('{$this->fromdate}','%d/%m/%Y'),'%Y-%m-%d') 
                                and ifnull(cd.fpassmth,'') = '' AND cd.FPRESENT='P' 
                                AND IFNULL(cs.FRECPTDATE,'0000-00-00')<>'0000-00-00' 
                                {$sectionvalue}
                                group by cd.FHALLNO 
                                order by {$orderby}
                                ";
                                //var_dump($get_data);
                }
                else
                {   
                    $get_data = "SELECT cd.FHALLNO,group_concat(cd.FREGNO order by {$order}) as fregno, 
                                masroom.froomname, s.fqpcode, ra.forder,
                                count(cd.fregno) as regcnt 
                                FROM {$canddet} cd  INNER JOIN subject s ON s.fdegree = cd.fdegree 
                                and s.fexamno = cd.fexamno and s.FSUBCODE=cd.FSUBCODE 
                                inner join {$candsum} cs on cs.FREGNO=cd.FREGNO 
                                AND cd.FCOLLCODE=cs.FCOLLCODE 
                                inner JOIN masroom ON masroom.froomno = FHALLNO and masroom.fcollcode = cs.fcntrcode 
                                inner join room_allotment ra on cs.fcntrcode = ra.fcollcode 
                                inner join {$studenttmp} st on cs.fregno = st.fregno and cs.fcollcode = st.fcollcode
                                and cs.fdegree = st.fdegree
                                and s.fqpcode = ra.fqpcode and ra.fhallno = masroom.froomno
                                inner JOIN reason r ON s.FSESSION = r.FREASONCD 
                                WHERE cs.FCNTRCODE='{$this->collcode}' 
                                and s.FQPCODE between '{$this->fromqpcode}' and '{$this->toqpcode}' 
                                and ifnull(cd.FHALLNO,'') <> '' 
                                and INSTR(cs.fhtenable,cd.fexamno) >0
                                AND lpad(cd.FHALLNO,3,'0') between '{$this->room_range_from}' and '{$this->room_range_to}' 
                                and s.fdoe = date_format(str_to_date('{$this->fromdate}','%d/%m/%Y'),'%Y-%m-%d') 
                                and ifnull(cd.fpassmth,'') = '' AND cd.FPRESENT='P' 
                                AND IFNULL(cs.FRECPTDATE,'0000-00-00')<>'0000-00-00' 
                                {$sectionvalue}
                                group by cd.FHALLNO 
                                order by {$orderby}
                                ";
                }
                
                // var_dump($get_data);
                $this->aobj_context->mobj_db->execute("SET @@session.group_concat_max_len=100000");	
                 $lobj_get_data = $this->aobj_context->mobj_db->GetAll($get_data);
             
                if($this->funivcode1 == '049'){
               
                    $this->pdf->SetMargins(15,10,10);
                } 	
                else {
                    $this->pdf->SetMargins(15,-5,10);
                 
                    $empty_cell_width=12;
                    $this->pdf->SetFont('Times','B',10);
                    $this->pdf->cell($empty_cell_width,7, ""," ",0,"C");
                    $cnt=1;
              }
            
                if($this->pageeject == 'F')
                {	
                    $this->pdf->AddPage();
                    $cond = true;
                }
                $oldqpcode = '';
                $newqpcode = '';
                $oldhallname = '';
                $newhallname = '';
                
                foreach($lobj_get_data as $hallk=>$hallv)
                {
                     $newqpcode  = $hallv['fqpcode'];
                     $newhallname = $hallv['froomname'];
                
                    if($this->pageeject =='F')
                    {
                        if($this->pdf->GetY() > 200)
                        {
                            $cond = true;
                        }
                    }
                    else
                    {	
                        if($newhallname != $oldhallname)
                        {	
                            $this->pdf->AddPage();
                            $cond = true;
                        }	
                    }	
        
                    if($newhallname != $oldhallname)
                    {
                        if($this->pageeject == 'F')
                        {
                            if($this->pdf->GetY() >200)
                            {
                                $this->pdf->AddPage();
                                $cond = true;
                            }
                        }

if($_SESSION['fexamseparate'] == 'T')
                        {
                            $FEXAMDATE = "fexexamdate as FEXAMDATE"; 
                        }else
                        {
                            $FEXAMDATE = "FEXAMDATE as FEXAMDATE"; 
                        }	
                   
                          $get_qp_details="select {$FEXAMDATE},
                                            if('{$this->funivcode1}' = '055',concat(s.fsubshort,' - ',s.fsubname),CONCAT(s.FSUBNAME,' ',s.FSSUBNAME)) as FSSUBNAME,
                                            s.fsubshort 
                                            from subject s 
                                            inner join degree d on d. FDEGREE=s.FDEGREE and d.fexamno = s.fexamno 
                                            where s.FQPCODE='{$newqpcode}'";
                  
                     
                        $obj_get_qp_details=$this->aobj_context->mobj_db->GetRow($get_qp_details);
        
                        $FSSUBNAME=$obj_get_qp_details['FSSUBNAME'];
                       
                        $fsubshort = $obj_get_qp_details['fsubshort'];
                        $this->FEXAMDATE=$obj_get_qp_details['FEXAMDATE'];
                        
                        if($this->funivcode1 == '049')
                            $this->sub_details="Course : {$newqpcode} - {$FSSUBNAME}";
                        
                        else if($this->funivcode1 == '052' || $this->funivcode1 == '055')
                            $this->sub_details=$this->fsubas." : {$fsubshort} - {$FSSUBNAME} ( {$newqpcode} ) ";
                        else
                            $this->sub_details=$this->fsubas." : {$newqpcode} - {$FSSUBNAME}";
        
                        if($this->funivcode1 == '062')
                        {
                            $get_qp_data="SELECT distinct DATE_FORMAT(t.fdate,'%d/%m/%Y') AS FDOE,t.FSESSIONt, r.fdescpn
                            FROM timetable t inner join subject s on t.fqpcode = s.fqpcode 
                            left outer join reason r on t.fsessiont = r.freasoncd
                            WHERE t.FQPCODE='{$newqpcode}'
                            group by t.fqpcode";
                        }else
                        {
                            $get_qp_data="SELECT distinct DATE_FORMAT(s.FDOE,'%d/%m/%Y') AS FDOE,s.FSESSION, r.fdescpn
                                        FROM  subject s  left outer join reason r on s.fsession = r.freasoncd
                                        WHERE s.FQPCODE='{$newqpcode}'";
                        }
                        $obj_get_qp_data=$this->aobj_context->mobj_db->GetRow($get_qp_data);	
        
                        $this->exam_date="Exam Date : {$obj_get_qp_data['FDOE']}, {$obj_get_qp_data['fdescpn']} ";
                        
                        session_start();
                        $FUNIVCODE = $_SESSION['FUNIVCODE'];
                      
                        if($cond)
                        {	 
                            if($FUNIVCODE == 30 || $FUNIVCODE == 31 || $FUNIVCODE == '049' || $FUNIVCODE == '055')
                            {
                                $this->SetLineWidth(0.01);			 
                                $img_path=$this->aobj_context->main_src.'/'.$this->aobj_context->mobj_data["db"]."/img/report_uni_logo.jpg";
                                if(file_exists($img_path)) 
                                if($FUNIVCODE == 30)
                                    $this->Image($img_path,80,4,52);
                                else if($FUNIVCODE == 49)
                                    $this->Image($img_path,80,4,62);
                                else if($FUNIVCODE == 55)
                                {	
                                    $this->Image($img_path,30,2,140,20);
                                    $this->Ln(2);
                                }
                                else
                                    $this->Image($img_path,60,4,90);
                                
                                $this->SetFont('Times','',12);	
                                if($FUNIVCODE == 30)
                                $this->Cell(0,4,'Rukmini Knowledge Park, Kattigenahalli, Yelahanka, Bengaluru-560 064',0,1,'C');
                                
                            }
                            else
                            {	
                                if(!empty($this->pdf_logo_path))
                                {
                                    $img_logo_path=$this->aobj_context->main_src.'/'.$this->aobj_context->mobj_data["db"].'/'.$this->pdf_logo_path;
                                    if($FUNIVCODE == '052')
                                        $this->pdf->Image($img_logo_path,5,5,37,15);
                                    else if($FUNIVCODE == '058')
                                        $this->pdf->Image($img_logo_path,3,6,23,22);
                                    else 
                                        $this->pdf->Image($img_logo_path,10,10,23,22);
                                }
                                    
                                $img_path2 = $this->aobj_context->main_src."/img/logo2.jpg";
                                if(file_exists($img_path2))
                                {
                                    $this->pdf->Image($img_path2,170,6,23,23);
                                }		
                                
                                if($FUNIVCODE == '052')
                                {
                                    $this->pdf->SetFont('Times','B',9);
                                    $this->pdf->Cell(0,4,"JSS MAHAVIDYAPEETHA",0,1,'C'); 
                                }
                                $this->pdf->SetFont('Times','B',15);
                                $this->pdf->cell(0,3,$this->FUNIVNAME."","0",1,"C");
                                $this->pdf->SetFont('Times','B',8);
                                $this->pdf->cell(0,7, $this->s_state,"0",1,"C");
                                $this->pdf->SetFont('Times','B',13);
                            }
        
                            $this->pdf->SetFont('Times','B',12);
                            if($this->FUNIVCODE != '055')
                                $this->pdf->cell(0,7, $this->college_details,"0",1,"C");
                                
                            $this->pdf->SetFont('Times','B',11);
                            if($this->FUNIVCODE == '008')
                                $this->pdf->Cell(0,7,"Form A - {$this->FEXAMDATE} EXAMINATION","0",1,"C");
                            else if($this->FUNIVCODE == '055'){
                                $this->pdf->SetY(20);
                                $this->pdf->Cell(0,7,"ROOMWISE STUDENT LIST  - {$this->FEXAMDATE}","0",1,"C");
                            }
                            else if($this->FUNIVCODE == '052')
                                $this->pdf->Cell(0,7,"A - FORM - {$this->FEXAMDATE} EXAMINATION","0",1,"C");
                            else
                                $this->pdf->Cell(0,7,"ROOMWISE STUDENT LIST - {$this->FEXAMDATE} EXAMINATION","0",1,"C");
                            $cond = false;	
                        		
                        }
                      
                        //if($this->pageeject != 'T')
                        //$this->pdf->Cell(0,7," {$this->sub_details}","0",1,"C");
                        $this->pdf->SetFont('Times','',13);
                        if($this->pageeject == 'F')
                        $cond = false;		
                        $head= false;
                        $oldqpcode = $hallv['fqpcode'];
                      
                    }	
                    $this->pdf->SetFont('Times','B',14);
                    // $this->pdf->AddPage();
                        $this->pdf->Cell(50,7,"    Room No. : {$hallv['froomname']} ","0",0,"L");
                        $this->pdf->Cell(0,7," {$this->exam_date}","0",1,"R");
                       
                    $c=1;
                
                    $this->pdf->SetFont('Times','',11);
                 	
                    $t_s=0;
                    $x = $this->pdf->GetX();
                    $y = $this->pdf->GetY();
                    $first = true;
                    $second = true;
                  
                    $i = 1;
                    $j = 1;
                   
                            $c = 1;
                            $t_s = 0;
                            $regnos = explode(',', $hallv['fregno']);
                            $regcnt = $hallv['regcnt'];
                            $sino1 = ceil($regcnt/2);
                         
                            
                            $this->pdf->SetFont('Times', 'B', 11);
                            if($this->FUNIVCODE == '060' || $this->FUNIVCODE == '062')
                            {
                                $this->pdf->Cell(25, 12, "Seat No.", "1", 0, "C");
                                $this->pdf->Cell(65, 12, $this->fregroll, "1", 0, "C");
                                
                                $this->pdf->Cell(25, 12, "Seat NO.", "1", 0, "C");
                                $this->pdf->Cell(65, 12, $this->fregroll, "1", 1, "C");
                            }else
                            {
                                $this->pdf->Cell(25, 12, "SL. NO.", "1", 0, "C");
                                $this->pdf->Cell(65, 12, $this->fregroll, "1", 0, "C");
                                
                                $this->pdf->Cell(25, 12, "SL. NO.", "1", 0, "C");
                                $this->pdf->Cell(65, 12, $this->fregroll, "1", 1, "C");
                            }    
                            $this->pdf->SetFont('Times', 'B', 11);
                            
                                $i=1;   
                                $j=16;
                                $fir = false;
                                $y = $this->pdf->getY();
                                $x = $this->pdf->getX();

foreach($regnos as $regno){
                                    $this->pdf->SetFont('Times', 'B', 11);

if($FUNIVCODE == '060' || $FUNIVCODE == '062' )
                                    {
                                       // var_dump($regno);
                                        $regarry = explode('*',$regno);
                                        $slno = $regarry[0];
                                        $regno = $regarry[1];
                                        if ($i % 2 == 1) 
                                        {
                                            $this->pdf->SetFont('Times', '', 11);
                                            $this->pdf->Cell(25, 7, "{$slno}", "1", 0, "C");
                                            $this->pdf->Cell(65, 7, " {$regno}", "1", 0, "C");
                                            
                                        }else{
                                            $this->pdf->SetFont('Times', '', 11);
                                            // $this->pdf->setY($y);
                                            $this->pdf->setX(105);
                                            $this->pdf->Cell(25, 7, "{$slno}", "1", 0, "C");
                                            $this->pdf->Cell(65, 7, "{$regno} ", "1", 1, "C");
                                        }

}else
                                    {

if ($i % 2 == 1) 
                                        {
                                            $this->pdf->SetFont('Times', '', 11);
                                            $this->pdf->Cell(25, 7, "{$i}", "1", 0, "C");
                                            $this->pdf->Cell(65, 7, " {$regno}", "1", 0, "C");
                                            
                                        }else{
                                            $this->pdf->SetFont('Times', '', 11);
                                            // $this->pdf->setY($y);
                                            $this->pdf->setX(105);
                                            $this->pdf->Cell(25, 7, "{$i}", "1", 0, "C");
                                            $this->pdf->Cell(65, 7, "{$regno} ", "1", 1, "C");
                                        }
                                    }
                                    $i++;
                                }
                            
                                // foreach($regnos as $regno)	
                                // {
                                 
                                //     $this->pdf->SetFont('Times', 'B', 11);

//     if ($i <= $sino1) 
                                //     {
                                //         $this->pdf->SetFont('Times', '', 11);
                                //         $this->pdf->Cell(25, 7, "{$i}", "1", 0, "C");
                                //         $this->pdf->Cell(65, 7, " {$regno}", "1", 1, "C");
                                        
                                //     } else 
                                //     {
                                      
                                //         if($i == ($sino1+1))
                                //             $this->pdf->setY($y);
                                //         $this->pdf->setX(105);
                                //         $this->pdf->SetFont('Times', '', 11);
                                //         $this->pdf->Cell(25, 7, "{$i}", "1", 0, "C");
                                //         $this->pdf->Cell(65, 7, "{$regno} ", "1", 1, "C");

//         // if ($regcnt > 30) { 
                                //         //     $this->pdf->AddPage(); 
                                //         //     $this->pdf->setY(10); 
                                //         // }

//         // if ($i == ($sino1 + 1)) {
                                //         //     $this->pdf->setY($y); 
                                //         // }

//         // // Render the cells
                                //         // $this->pdf->setX(105);
                                //         // $this->pdf->SetFont('Times', '', 11);
                                //         // $this->pdf->Cell(25, 7, "{$i}", "1", 0, "C");
                                //         // $this->pdf->Cell(65, 7, "{$regno} ", "1", 1, "C");
                                //     }
                                //     $i++;
                                   
                                // }
                       
                    $oldhallname = $hallv['froomname'];
                  
                    $this->pdf->Cell(1,7,"","0",1,"l");;
                    $this->pdf->cell($empty_cell_width,7, ""," ",0,"C");
                    $this->pdf->Ln(5);
                    $this->pdf->Cell(180,7,"Total Students :   $regcnt ","0",1,"L");
                    $cond = false;	
                }

}
        function SendOutput()
            {
                $this->pdf->Output("Roomwise Register No.s List.pdf","I");
            }
        }
        function registernoallotlistonnoticeboard($aobj_context){
            $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
            $class_obj=new report_ra_roomwise_register_nos_list();
            $class_obj->AliasNbPages();
            $class_obj->DefaultConstructor($aobj_context);
            $class_obj->GetFullQry();
            $class_obj->formcolldata();
          
            $class_obj->formData();
            $class_obj->SendOutput();
        }

// Get the current Y position
// $currentY = $this->pdf->GetY();

// // Define the bottom margin limit
// $bottomMargin = 20; // Adjust based on your PDF layout
// $pageHeight = $this->pdf->getPageHeight();

// // Check if the next cell would exceed the page's height
// if ($currentY + 7 > $pageHeight - $bottomMargin) { // Assuming 7 is the height of your row
//     $this->pdf->AddPage(); // Add a new page
//     $this->pdf->setY(10);  // Reset Y to top margin
// }

// // Set Y position for $sino1+1
// if ($i == ($sino1 + 1)) {
//     $this->pdf->setY($y); // Maintain Y for the specific row
// }

// // Render the cells
// $this->pdf->setX(105);
// $this->pdf->SetFont('Times', '', 11);
// $this->pdf->Cell(25, 7, "{$i}", "1", 0, "C");
// $this->pdf->Cell(65, 7, "{$regno} ", "1", 1, "C");
?>

${this.title}

Code Editor : regNoAllot.php