Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
ApplicationFeeSummary.php	10.14 KB	-rwxr-xr-x
ApplicationReport.php	9.8 KB	-rwxr-xr-x
Applicationfeereport.php	8.56 KB	-rwxr-xr-x
Collegewise_SeatAllotedList.ph...	11.13 KB	-rwxr-xr-x
Degreewise_SeatAllotedList.php	11.34 KB	-rwxr-xr-x
SeatMatrixReport.php	24.02 KB	-rwxr-xr-x
admconfirmation.php	4.43 KB	-rwxr-xr-x
admissionfeedetails.php	1.56 KB	-rw-rw-r--
admissionfeereport.php	11.59 KB	-rw-rw-r--
admissionstatusreport.php	12.62 KB	-rwxr-xr-x
applicationview.php	9.5 KB	-rwxr-xr-x
collegedegree.php	1.92 KB	-rwxr-xr-x
collegedetails.php	1.96 KB	-rwxr-xr-x
create-stud_login.php	4.09 KB	-rwxr-xr-x
create-user.php	4.17 KB	-rwxr-xr-x
documentverification.php	4.91 KB	-rwxr-xr-x
dudseatallot.php	4.11 KB	-rw-rw-r--
meritlist.php	3.22 KB	-rwxr-xr-x
report_merit_list.php	6.82 KB	-rwxr-xr-x
report_rcub_merit_list.php	12.77 KB	-rwxr-xr-x
reportadm_admission_ticket.php	13.73 KB	-rwxr-xr-x
rostertable.php	490 B	-rwxr-xr-x
saveApplication.php	19.01 KB	-rwxr-xr-x
seatmatrix.php	8.53 KB	-rwxr-xr-x
signin.php	849 B	-rwxr-xr-x

Code Editor : admissionstatusreport.php

<?php
$main_src=substr($_SERVER['SCRIPT_FILENAME'],0,strlen($_SERVER['SCRIPT_FILENAME'])-7);
//$pdf_writer_class =$main_src."/tarka_pdf/fpdf.php";
$pdf_writer_class =$main_src."/tcpdf/tcpdf.php";
require_once($pdf_writer_class);
ini_set('memory_limit','900M');
ini_set('max_execution_time',0);

class MYPDF extends TCPDF {
    public $aobj_context;
     
    public function setData($aobj_context){
    	$this->aobj_context = $aobj_context;
    }
    public function Header() {
        // get the current page break margin
        $bMargin = $this->getBreakMargin();
        // get current auto-page-break mode
        $auto_page_break = $this->AutoPageBreak;
        // disable auto-page-break
        $this->SetAutoPageBreak(false, 0);
        // set bacground image

$this->SetMargins(10,34,20,true);	
		$this->SetFillColor(248, 248 ,255);		
		$img_path = $this->aobj_context->main_src."/img/".$this->aobj_context->FUNIVCODE."_logo.jpg";
		
		if(file_exists($img_path)) 
			$this->Image($img_path,10,6,20,20);
		
		$this->SetFont('Times','B',13);
		$this->SetY(5);
		$this->Cell(0,4,$this->aobj_context->FUNIVNAME,0,1,'C');
		//state
		$this->SetFont('Times','',11);
		$this->Cell(0,4,$this->aobj_context->s_state,0,1,'C');
				 
		$this->SetFont('Times','B',12);
		$this->Ln(1);
		
		$cur_year = date("Y");
		$this->Cell(180,5,'PG Admission Status ' ,'0',1,'C');
		
    }

}

class AddmissionApplication
{	
	function DefaultConstructor($aobj_context)
	{
		$this->aobj_context=$aobj_context;
		//$this->pdf=  new FPDF();
		$this->collcode=$_SESSION['collcode'];
		$this->ip=$_SERVER["REMOTE_ADDR"];
		$get_date="select DATE_FORMAT(now(), '%d/%m/%Y') as now_date";
		$obj=$this->aobj_context->mobj_db->GetRow($get_date);

$get_coll_name="select FUNIVNAME as 'FUNIVNAME',FUNIVCODE,
		FUNIVADD1 as 'state', concat(FUNIVCODE,'_',pdf_logo_path) as pdf_logo_path,
		ifnull(FEXAMAPPREQ,'F') as FEXAMAPPREQ From control";

$lobj_get_coll_name=$this->aobj_context->mobj_db->GetRow($get_coll_name);
		//var_dump($this->degree);
		$aobj_context->FUNIVNAME=$lobj_get_coll_name['FUNIVNAME'];
		$aobj_context->s_state=$lobj_get_coll_name['state'];
		$aobj_context->pdf_logo_path=$lobj_get_coll_name['pdf_logo_path'];
		$aobj_context->FEXAMAPPREQ=$lobj_get_coll_name['FEXAMAPPREQ'];
		$aobj_context->FUNIVCODE=$lobj_get_coll_name['FUNIVCODE'];

$app_no = trim($aobj_context->mobj_data["appno"]);

$aobj_context->appno = $app_no;
		$aobj_context->current_date = $obj['now_date'];
		$this->current_date = $obj['now_date'];

$this->pdf= new MYPDF('P');
		$this->pdf->setData($aobj_context);
		
	}
 
	function formcolldata()
	{
		$get_coll_name="select FUNIVNAME as 'FUNIVNAME',FUNIVCODE,
		FUNIVADD1 as 'state', concat(FUNIVCODE,'_',pdf_logo_path) as pdf_logo_path,
		ifnull(FEXAMAPPREQ,'F') as FEXAMAPPREQ From control";

$lobj_get_coll_name=$this->aobj_context->mobj_db->GetRow($get_coll_name);
		
		$this->FUNIVNAME=$lobj_get_coll_name['FUNIVNAME'];
		$this->s_state=$lobj_get_coll_name['state'];
		$this->pdf_logo_path=$lobj_get_coll_name['pdf_logo_path'];
		$this->FEXAMAPPREQ=$lobj_get_coll_name['FEXAMAPPREQ'];
		$this->FUNIVCODE=$lobj_get_coll_name['FUNIVCODE']; 
	}
  
  public function Header($pdf)
    {

$pdf->SetFont('Times', 'B', 10);
        $pdf->Cell(8, 7, "Sl.", "LTR", 0, "C");
        $pdf->Cell(30, 7, "Application", "LTR", 0, "C");
        $pdf->Cell(50, 7, "Student", "LTR", 0, "C");
        $pdf->Cell(21, 7, "Alloted", "LTR", 0, "C");
        $pdf->Cell(30, 7, "Alloted", "LRT", 0, "C");
        $pdf->Cell(18, 7, "Alloted", "LRT", 0, "C");
        $pdf->Cell(14, 7, "Alloted", "LRT", 1, "C");
        // $pdf->Cell(15, 7, "", "LRT", 0, "C");
        // $pdf->Cell(14, 7, "HK", "LRT", 0, "C");
        // $pdf->Cell(16, 7, "Allotment", "LRT", 0, "C");
        // $pdf->Cell(12, 7, "Rank", "LRT", 0, "C");
        // $pdf->Cell(18, 7, "Allotment", "LRT", 0, "C");
        // $pdf->Cell(17, 7, "Alloted", "LRT", 0, "C");
        // $pdf->Cell(17, 7, "Allotment", "LRT", 1, "C");

$pdf->SetFont('Times', 'B', 10);
        $pdf->Cell(8, 4, "No.", "LRB", 0, "C");
        $pdf->Cell(30, 4, "Number", "LRB", 0, "C");
        $pdf->Cell(50, 4, "Name", "LRB", 0, "C");
        $pdf->Cell(21, 4, "Number", "LRB", 0, "C");
        $pdf->Cell(30, 4, "Date", "LRB", 0, "C");
        $pdf->Cell(18, 4, "Category", "LRB", 0, "C");
        $pdf->Cell(14, 4, "Quota", "LRB", 1, "C");
        // $pdf->Cell(15, 4, "", "LRB", 0, "C");
        // $pdf->Cell(14, 4, "", "LRB", 0, "C");
        // $pdf->Cell(16, 4, "Number", "LRB", 0, "C");
        // $pdf->Cell(12, 4, "", "LRB", 0, "C");
        // $pdf->Cell(18, 4, "Date", "LRB", 0, "C");
        // $pdf->Cell(17, 4, "Category", "LRB", 0, "C");
        // $pdf->Cell(17, 4, "Reserve", "LRB", 1, "C");
        $pdf->SetFont('Times', '', 10);

}

function writeApplication($per_details, $fee_det,$res_optopns,$degree, $res_prevmarks,$ent_seatallot,$admitted,$pending,$list_of_all,$deg,$status)
	{

//var_dump($degdet[$per_details['FDEGREE1']]);
    // var_dump($admitted,$pending,$list_of_all);

$pdf=$this->pdf;

$pdf->SetMargins(20,50,20,false);
		$pdf->startPageGroup();
    $pdf->AddPage("P");
    // var_dump($status,$deg);
    $sl_no=1;

if($status == 'Admitted'){
      $pdf->SetXY(40, 23);
      $pdf->SetFont('Times', 'B', 14);
      $pdf->Cell(40, $h, 'Admitted Students List as on '  . date("d-m-Y h:i:s A"), 0, 1, "L");
      $pdf->Ln(5);
      $this->Header($pdf);

$data = $admitted;
      foreach ($data as $key => $value) {
         
    
        // $newCode = $value['fcollname'];
      
          
           if ($pdf->getY() > 170) {
             
              $pdf->AddPage("P");
              $pdf->cell(275, 8, $j.' '. $value['collcode'] . ' - ' . $value['collname'], 1, 1, "C");
               $pdf->SetFont('Times', ' ', 12);
              //$pdf->cell(275, 8, $j.' '. $value['collcode'] . ' - ' . $value['collname'], 1, 1, "C");
              $this->Header($pdf);
               $pdf->SetFont('Times', '', 10);
           
         }
           
           
           $pdf->SetFont('Times', '', 10);
           $x = $pdf->GetX();
           $y = $pdf->GetY();                  
           $y1 = $pdf->GetY();
           $pdf->Cell(8, $h, $sl_no, "1", 0, "C");
           $pdf->Cell(30, $h, $value['fappno'], "1", 0, "C");           
           $pdf->Cell(50, $h, $value['fname'], "1", 0, "L");
           $pdf->Cell(21, $h, $value['fallotno'], "1", 0, "C");
           $pdf->Cell(30, $h, $value['fallotdate'], "1", 0, "C");
           $pdf->Cell(18, $h, $value['fcatcode'], "1", 0, "C");
           $pdf->Cell(14, $h, $value['freserve'], "1", 1, "C");           
           
           $oldCode = $newCode;
           $sl_no++;
       }
    }else if($status == 'Pending'){
      $pdf->SetXY(40, 23);
      $pdf->SetFont('Times', 'B', 14);
      $pdf->Cell(40, $h, 'Pending Students List as on '  . date("d-m-Y h:i:s A"), 0, 1, "L");
      $pdf->Ln(5);
      $this->Header($pdf);
      $data = $pending;
      foreach ($data as $key => $value) {
         
    
        // $newCode = $value['fcollname'];
      
          
           if ($pdf->getY() > 170) {
             
              
              $this->Header($pdf);
               $pdf->SetFont('Times', '', 10);
           
         }
           
           
           $pdf->SetFont('Times', '', 10);
           $x = $pdf->GetX();
           $y = $pdf->GetY();                  
           $y1 = $pdf->GetY();
           $pdf->Cell(8, $h, $sl_no, "1", 0, "C");
           $pdf->Cell(30, $h, $value['fappno'], "1", 0, "C");           
           $pdf->Cell(50, $h, $value['fname'], "1", 0, "L");
           $pdf->Cell(21, $h, $value['fallotno'], "1", 0, "C");
           $pdf->Cell(30, $h, $value['fallotdate'], "1", 0, "C");
           $pdf->Cell(18, $h, $value['fcatcode'], "1", 0, "C");
           $pdf->Cell(14, $h, $value['freserve'], "1", 1, "C");           
           
           $oldCode = $newCode;
           $sl_no++;
       }
    }
    // var_dump($deg,$status);
    if($deg && $status == ""){
      $pdf->SetXY(80, 23);
      $pdf->SetFont('Times', 'B', 14);
      $pdf->Cell(40, $h, '', 0, 1, "L");
      $pdf->Ln(5);
    $this->Header($pdf);
      $data = $list_of_all;
      foreach ($data as $key => $value) {
         
    
        // $newCode = $value['fcollname'];
      
          
           if ($pdf->getY() > 190) {
             
              
              $this->Header($pdf);
               $pdf->SetFont('Times', '', 10);
           
         }
           
           
           $pdf->SetFont('Times', '', 10);
           $x = $pdf->GetX();
           $y = $pdf->GetY();                  
           $y1 = $pdf->GetY();
           $pdf->Cell(8, $h, $sl_no, "1", 0, "C");
           $pdf->Cell(30, $h, $value['fappno'], "1", 0, "C");           
           $pdf->Cell(50, $h, $value['fname'], "1", 0, "L");
           $pdf->Cell(21, $h, $value['fallotno'], "1", 0, "C");
           $pdf->Cell(30, $h, $value['fallotdate'], "1", 0, "C");
           $pdf->Cell(18, $h, $value['fcatcode'], "1", 0, "C");
           $pdf->Cell(14, $h, $value['freserve'], "1", 1, "C");           
           
           $oldCode = $newCode;
           $sl_no++;
       }
      }

}
		
	function SendOutput()
	{
		$this->pdf->Output("Admission_status{$this->current_date}.pdf","D");
	}	 
}

function admissionstatusreport($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
	
	$query = "select distinct fdegree,fdescpn from degree where fdegree like 'm%'";
	$result = $aobj_context->mobj_db->GetAll($query);

$degdet = [];
	foreach($result as $value)
	{
		$degdet[$value['fdegree']] = $value['fdescpn'];
	}

$get_coll_name="select FUNIVNAME as 'FUNIVNAME',FUNIVCODE,
		FUNIVADD1 as 'state', concat(FUNIVCODE,'_',pdf_logo_path) as pdf_logo_path,
		ifnull(FEXAMAPPREQ,'F') as FEXAMAPPREQ From control";

$lobj_get_coll_name=$aobj_context->mobj_db->GetRow($get_coll_name);

$status = trim($aobj_context->mobj_data["status"]);
  $deg = trim($aobj_context->mobj_data["degree"]);

$per_details_query = "select * from entstudadm where fappno = '{$appno}' and ifnull(FPAYSTATUS,'') = 'success'";
	$per_details = $aobj_context->mobj_db->GetRow($per_details_query);
  $cnt = 0;
  // var_dump($status,$degree);

$class_obj = new AddmissionApplication();
	
	$class_obj->DefaultConstructor($aobj_context);

$query = "select * from entfeedetl where fappno = '{$appno}'";
	$fee_det = $aobj_context->mobj_db->GetAll($query);

$query = "select o.fdegree,d.fdescpn from entoptdeg o 
	inner join entdeg d on d.fdegree = o.fdegree
	where fappno = '{$appno}'
	order by o.fdegree";
	$res_optopns = $aobj_context->mobj_db->GetAll($query);

$query = "select * from entprevmarks a inner join entprevcomb b 
	on a.fdegree = b.fdegree and a.fcombcode = b.fcombcode 
	and a.fsubcode= b.fsubcode where fappno ='{$appno}'";
	$res_prevmarks = $aobj_context->mobj_db->GetAll($query);

$query = "select e.fappno,s.fname,e.fcollcode,c.fcollname,e.fdegree,d.fdescpn,e.frank,e.freserve,e.fallotno,date_format(e.fallotdate, '%d-%m-%Y')as fallotdate,e.fcatcode,e.freserve
	from entseatallot e 
	inner join entstudadm s on e.fappno = s.fappno
	inner join entdeg d on e.fdegree = d.fdegree
	inner join entcoll c on e.fcollcode = c.fcollcode
	where e.fappno = '{$appno}'";
  $ent_seatallot = $aobj_context->mobj_db->GetAll($query);
  
  $query = "select e.fappno,s.fname,e.fcollcode,e.frank,e.freserve,e.fallotno,date_format(e.fallotdate, '%d/%m/%Y')as fallotdate,e.fcatcode,e.freserve,ifnull(e.fcollconf, '') as fcollconf
	from entseatallot e 
	inner join entstudadm s on e.fappno = s.fappno
	where fdegree = '{$deg}' and fcollcode = '{$_SESSION['FCOLLCODE']}' and fcollconf = 'T'
	order by fname";
  $admitted = $aobj_context->mobj_db->GetAll($query);
  
  $query = "select e.fappno,s.fname,e.fcollcode,e.frank,e.freserve,e.fallotno,date_format(e.fallotdate, '%d/%m/%Y')as fallotdate,e.fcatcode,e.freserve,ifnull(e.fcollconf, '') as fcollconf
	from entseatallot e 
	inner join entstudadm s on e.fappno = s.fappno
	where fdegree = '{$deg}' and fcollcode = '{$_SESSION['FCOLLCODE']}' and ifnull(fcollconf,'') <> 'T'
	order by fname";
  $pending = $aobj_context->mobj_db->GetAll($query);

$query = "select e.fappno,s.fname,e.fcollcode,e.frank,e.freserve,e.fallotno,date_format(e.fallotdate, '%d/%m/%Y')as fallotdate,e.fcatcode,e.freserve,ifnull(e.fcollconf, '') as fcollconf
	from entseatallot e 
	inner join entstudadm s on e.fappno = s.fappno
	where fdegree = '{$deg}' and fcollcode = '{$_SESSION['FCOLLCODE']}'
	order by fname";
	$list_of_all = $aobj_context->mobj_db->GetAll($query);

$class_obj->writeApplication($per_details, $fee_det,$res_optopns,$per_details['FDEGREE1'], $res_prevmarks,$ent_seatallot,$admitted,$pending,$list_of_all,$deg,$status);

$class_obj->SendOutput();
}

${this.title}

Code Editor : admissionstatusreport.php