Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
ExcelWriterXML	[ DIR ]	drwxr-xr-x
Excel_Writer	[ DIR ]	drwxr-xr-x
Excel_reader	[ DIR ]	drwxr-xr-x
JQGrid3.5	[ DIR ]	drwxr-xr-x
Open_Sans	[ DIR ]	drwxr-xr-x
PHPExcel	[ DIR ]	drwxr-xr-x
Paytm	[ DIR ]	drwxr-xr-x
Paytm_test	[ DIR ]	drwxr-xr-x
Registration	[ DIR ]	drwxr-xr-x
Report_details_stop	[ DIR ]	drwxr-xr-x
adm	[ DIR ]	drwxr-xr-x
admupload	[ DIR ]	drwxrwxrwx
axis	[ DIR ]	drwxr-xr-x
certificates	[ DIR ]	drwxrwxrwx
cropped_photos	[ DIR ]	drwxr-xr-x
css	[ DIR ]	drwxr-xr-x
custom_js	[ DIR ]	drwxr-xr-x
custom_src	[ DIR ]	drwxr-xr-x
demo_videos	[ DIR ]	drwxr-xr-x
doc_verify	[ DIR ]	drwxr-xr-x
docs	[ DIR ]	drwxr-xr-x
docverify	[ DIR ]	drwxr-xr-x
easy_zip	[ DIR ]	drwxr-xr-x
gradlist	[ DIR ]	drwxr-xr-x
grid_display_files	[ DIR ]	drwxr-xr-x
grv Queries	[ DIR ]	drwxr-xr-x
grvQueries	[ DIR ]	drwxr-xr-x
halltickets	[ DIR ]	drwxrwxrwx
hdfc	[ DIR ]	drwxr-xr-x
html_modules	[ DIR ]	drwxr-xr-x
images	[ DIR ]	drwxr-xr-x
img	[ DIR ]	drwxr-xr-x
imported_files	[ DIR ]	drwxrwxrwx
includes	[ DIR ]	drwxr-xr-x
js	[ DIR ]	drwxr-xr-x
libs	[ DIR ]	drwxr-xr-x
maya-pdf	[ DIR ]	drwxr-xr-x
notifications	[ DIR ]	drwxrwxrwx
phdadm	[ DIR ]	drwxr-xr-x
popups	[ DIR ]	drwxr-xr-x
razorpay	[ DIR ]	drwxr-xr-x
schema	[ DIR ]	drwxr-xr-x
src_stop	[ DIR ]	drwxr-xr-x
student_photos	[ DIR ]	drwxrwxrwx
tarka_pdf	[ DIR ]	drwxr-xr-x
tarka_pdf_latest	[ DIR ]	drwxr-xr-x
tcpdf	[ DIR ]	drwxr-xr-x
teacher_photos	[ DIR ]	drwxrwxrwx
timetable	[ DIR ]	drwxr-xr-x
tmpphotos	[ DIR ]	drwxrwxrwx
upload	[ DIR ]	drwxrwxrwx
.DS_Store	39.87 KB	-rwxr-xr-x
BCU_English_Text_Books_Prescri...	1.98 KB	-rwxr-xr-x
MainPage.html	16.14 KB	-rwxr-xr-x
MainPagepopup.html	7.05 KB	-rwxr-xr-x
Thumbs.db	473.5 KB	-rwxr-xr-x
admStatistics.php	5.5 KB	-rwxr-xr-x
admcollsum.php	6.07 KB	-rwxr-xr-x
admcollsum_college.php	5 KB	-rwxr-xr-x
admdatasummary.html	2.78 KB	-rwxr-xr-x
admission_sms_push.php	2.77 KB	-rwxr-xr-x
admreportlist.php	14.9 KB	-rwxr-xr-x
app.php	417 B	-rwxr-xr-x
appPaymentDetAPI.php	5.59 KB	-rwxr-xr-x
axis_response.php	5.55 KB	-rwxr-xr-x
bundle slip reforms.pdf	316.28 KB	-rwxr-xr-x
cconfig.php	1.1 KB	-rwxr-xr-x
cntrmesage.html	2.8 KB	-rwxr-xr-x
collegeInfoPopup.html	4.24 KB	-rwxr-xr-x
cronjob_sendsms.php	2.53 KB	-rwxr-xr-x
flash.html	2.15 KB	-rwxr-xr-x
forgotpassword.html	3.31 KB	-rwxr-xr-x
getAppDetAPI.php	2.3 KB	-rwxr-xr-x
getQPdet.php	4.66 KB	-rwxr-xr-x
homepage.html	3.35 KB	-rwxr-xr-x
htsum.php	3.62 KB	-rwxr-xr-x
index.js	24.66 KB	-rwxr-xr-x
index.php	80 B	-rwxr-xr-x
index_stop.html	6.03 KB	-rwxr-xr-x
indexlogin_sop.html	5.99 KB	-rwxr-xr-x
mcverifydet.php	14.83 KB	-rwxr-xr-x
mverifytranscript.php	14.62 KB	-rwxr-xr-x
new.gif	197 B	-rwxr-xr-x
paytm_res.php	4.14 KB	-rwxr-xr-x
pgRedirect.php	2.53 KB	-rwxr-xr-x
pgResponse.php	7.11 KB	-rwxr-xr-x
phddegsum.php	2.86 KB	-rwxr-xr-x
postoffice.php	4.35 KB	-rwxr-xr-x
regnpage.html	11.32 KB	-rwxr-xr-x
rv_update.php	1.36 KB	-rwxr-xr-x
subqp.php	8.6 KB	-rwxr-xr-x
superLog-in.html	6.2 KB	-rwxr-xr-x
timetable.php	2.87 KB	-rwxr-xr-x
valdet.php	8.07 KB	-rwxr-xr-x
valuation.html	2.49 KB	-rwxr-xr-x
verification.php	2.68 KB	-rwxr-xr-x
verify.php	7.04 KB	-rwxr-xr-x

Code Editor : admreportlist.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;
    protected $last_page_flag = false;
    public function setData($aobj_context){
    	$this->aobj_context = $aobj_context;
    }

public function Close() {
	    $this->last_page_flag = true;
	    parent::Close();
  	}
    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(5,62,20,true);	
		$this->SetFillColor(248, 248 ,255);		
		$img_path = $this->aobj_context->main_src."/img/logo.jpg";
		
		if(file_exists($img_path)) 
			$this->Image($img_path,6,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->Cell(0,4,'College : '.$this->aobj_context->col_name,0,1,'C');
				 
		$this->SetFont('Times','B',12);
		$this->Ln(1);
	
		$cur_year = date("Y");
		$nextyear = ($cur_year+1)-2000;
		
		$this->Cell(0,5,'Combination Wise Statement for the Academic Year ('.$cur_year.'-'.$nextyear.')','0',1,'C');
		$this->Cell(0,5,"Degree : {$this->aobj_context->degree}",'0',1,'C');

$this->Ln(1);
		$this->Cell(0,5,"Combination : {$this->aobj_context->combcode}",'0',1,'C');

if($this->aobj_context->laspage != "lastpage")
		{
				$qurey = "select count(*)  as fcombcnt from studadm where 
				fcollcode = '{$this->aobj_context->fcollcode}' and 
				fdegree = '{$this->aobj_context->fdegree}' 
				and fcombcode = '{$this->aobj_context->fcombcode}'
				and IFNULL(FAPPSTATUS,'') = 'verified' and IFNULL(ffinsub,'') = 'T'";

$combcnt = $this->aobj_context->mobj_db->GetRow($qurey);

$this->Cell(250,5,"Sanctioned Intake : ",'0',0,'L');
				$this->Cell(30,5,"No. of Admission Made : ".$combcnt['fcombcnt'],'0',1,'R');
				$this->Ln(1);
			$table5 = '<style>
				td, th {
				    border: 0.5px solid black;
				}
			 </style>
			 <table cellpadding="2" cellspacing="0">
				';
			$table5 .= '<thead><tr nobr="true">';
			$table5 .= '<th width="25" align="center"><b>Sl. No.</b></th>';
			$table5 .= '<th width="60" align="center"><b>App. No.</b></th>';
			$table5 .= '<th width="110" align="center"><b>Name</b></th>';
			$table5 .= '<th width="25" align="center"><b>Sex</b></th>';
			$table5 .= '<th width="55" align="center"><b>DOB</b></th>';
			$table5 .= '<th width="60" align="center"><b>Stud. Type</b></th>';
			$table5 .= '<th width="30" align="center"><b>Cat.</b></th>';
			$table5 .= '<th width="60" align="center"><b>Qual. Exam Passed</b></th>';
			$table5 .= '<th width="50" align="center"><b>Marks Obt.</b></th>';
			$table5 .= '<th width="60" align="center"><b>Second Lan. admitted</b></th>';
			$table5 .= '<th width="55" align="center"><b>DOA</b></th>';
			$table5 .= '<th width="30" align="center"><b>Fee</b></th>';
			$table5 .= '<th width="117" align="center"><b>Documents Enclosed</b></th>';
			$table5 .= '<th width="80" align="center"><b>Remarks</b></th>';
			$table5 .= '</tr></thead></table>';
			$this->writeHTML($table5, false, false, false, false);
		}
        // restore auto-page-break status
        // var_dump($this->aobj_context->laspage);
        $this->SetAutoPageBreak($auto_page_break, $bMargin);
        // set the starting point for the page content    
    }

public function Footer() 
    {
        $this->SetY(-20);
        $this->SetFont('helvetica', 'I', 8);
        $this->Ln(1);
        if($this->aobj_context->laspage != "lastpage")
		{
	        $this->Cell(0, 6,'Note : Documents Enclosed,  ELIGCERT - Eligibility Certificate, SSLCMC - SSLC Marks Card, PUMC - PUC Marks Card.', 0, 1, 'L');
        }
        $this->Cell(100, 10,'IP : '.$_SERVER["REMOTE_ADDR"], 0, 0, 'L');
        $this->Cell(110, 10,'Date : ' .$this->aobj_context->current_date, 0, 0, 'C');

$this->Cell(70, 10,'Page ' .$this->getPageNumGroupAlias().'/'.$this->getPageGroupAlias(), 0, 1, 'R');
    }
}

class AddmissionApplication
{	
	function DefaultConstructor($aobj_context)
	{
		$this->aobj_context=$aobj_context;
		//$this->pdf=  new FPDF();
		$this->collcode=$_SESSION['collcode'];
		$this->degree = $aobj_context->mobj_data["degree_code"];
		$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', pdf_logo_path,
		ifnull(FEXAMAPPREQ,'F') as FEXAMAPPREQ From control";

$lobj_get_coll_name=$this->aobj_context->mobj_db->GetRow($get_coll_name);
		
		$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'];

$get_college_name="select concat(fcollcode,' - ',FCOLLNAME,', ',FTOWN) as col_name from college where FCOLLCODE='{$this->collcode}'";
		$lobj_get_college_name = $this->aobj_context->mobj_db->GetRow($get_college_name);
		$aobj_context->col_name = $lobj_get_college_name['col_name'];
		$this->aobj_context->current_date =  $obj['now_date'];

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

$get_degree_name="select concat(fdegree,'-',fdescpn) as degree from degree where fdegree='{$this->degree}' and fexamno = 'A'";
		
		$lobj_get_degree_name = $this->aobj_context->mobj_db->GetRow($get_degree_name);
		$aobj_context->degree = $lobj_get_degree_name['degree'];
		
		$this->pdf= new MYPDF('P');
		
		$this->pdf->setData($aobj_context);
	}

function writeReport($admCollData)
	{

$pdf=$this->pdf;

$oldcombcode = '';
		$newcombcode = '';
		$i = 0;
		$Total = 0;
		foreach($admCollData as $key => $value)
		{

$newcombcode = $value['fcombcode'];

if($newcombcode != $oldcombcode) 
			{
				//var_dump($i);
				
				if($i != 0)
				{	
					$table5 .='
						<tr>
							<td colspan = "10">
								<b>Total Amount</b>
							</td>
							<td colspan = "2" align = "right"><b>'.
								moneyFormatIndia($Total).'
							</b></td>
						</tr>
					</table>';
					$pdf->writeHTML($table5, false, false, false, false);
					
					/*$table5 = '<style>
					td, th {
					    border: 0.5px solid black;
					}
				 	</style>
				 	<br><br>
				 	<table cellpadding="2" cellspacing="0">
					<tr nobr="true">
						<td width = "200" >Sanctioned Intake</td>
						<td width = "100"></td>
					</tr>
					<tr nobr="true">
						<td width = "200" >No. of Admission Made</td>
						<td width = "100">'.$i.'</td>
					</tr>
					<tr nobr="true">
						<td width = "200">Total Amount</td>
						<td width = "100">'.moneyFormatIndia($Total).'</td>
					</tr>
					</table>';

if($pdf->getY()>170)
					{
						$this->aobj_context->laspage = "lastpage";
						$pdf->AddPage("L");
						$pdf->writeHTML($table5, false, false, false, false);
						$this->aobj_context->laspage = "";
					}
					else
					{
						$pdf->writeHTML($table5, false, false, false, false);
					}*/
					$i = 0;
					$Total = 0;
					//var_dump($i);
				}
				$this->aobj_context->combcode = $value['FCOMBDESC'];
				$this->aobj_context->fcombcode = $value['fcombcode'];
				$this->aobj_context->fdegree = $value['fdegree'];
				$this->aobj_context->fcollcode = $value['fcollcode'];
				//$pdf->SetMargins(12,30,20,false);
				$pdf->SetMargins(5,62,20,false);
				$pdf->startPageGroup();
				$pdf->AddPage("L");

$pdf->SetFont('Times','',10);

$table5 = '<style>
					td, th {
					    border: 0.5px solid black;
					}
				 </style>
				 <table cellpadding="2" cellspacing="0">
					';

$oldcombcode = $newcombcode;
				
			}

$table5 .= '<tr nobr="true">';
			$table5 .= '<td width="25" align="center">'.++$i.'</td>';
			$table5 .= '<td width="60" align="center">'.$value['fappno'].'</td>';
			$table5 .= '<td width="110" align="left">'.$value['fname'].'</td>';
			$table5 .= '<td width="25" align="center">'.$value['fgender'].'</td>';
			$table5 .= '<td width="55" align="center">'.$value['fdob'].'</td>';
			$table5 .= '<td width="60" align="center">'.$value['FCOMSTATE'].'</td>';
			$table5 .= '<td width="30" align="center">'.$value['fcaste'].'</td>';
			$table5 .= '<td width="60" align="center">'.$value['FTYPEQUALEXAM'].'</td>';
			$table5 .= '<td width="50" align="center">'.$value['fmarks'].'</td>';
			$table5 .= '<td width="60" align="center">'.$value['fsubcode'].'</td>';
			$table5 .= '<td width="55" align="center">'.$value['fdoa'].'</td>';
			$table5 .= '<td width="30" align="center">'.moneyFormatIndia($value['ftotfee']).'</td>';
			$table5 .= '<td width="117" align="left">'.$value['studdoc'].'</td>';
			$table5 .= '<td width="80" align="left"></td>';
			$table5 .= '</tr>';
			$Total += intval($value['ftotfee']);

if($i % 25 == 0)
			{
				$table5 .='</table>';
				$pdf->writeHTML($table5, false, false, true, false, 'L');
				$table5 = '<style>
					td, th {
					    border: 0.5px solid black;
					}
				 </style>
				 <table cellpadding="2" cellspacing="0">';
			}
		}
		$table5 .='
					<tr>
						<td colspan = "10">
							<b>Total Amount</b>
						</td>
						<td colspan = "2" align = "right"><b>'.
							moneyFormatIndia($Total).'
						</b></td>
					</tr>
				</table>';
		$pdf->writeHTML($table5, false, false, true, false, 'L');
		/*$table5 = '<style>
					td, th {
					    border: 0.5px solid black;
					}
				 </style>
				 <br><br>
				 <table cellpadding="2" cellspacing="0">
					<tr nobr="true">
						<td width = "200" >Sanctioned Intake</td>
						<td width = "100"></td>
					</tr>
					<tr nobr="true">
						<td width = "200">No. of Admission Made</td>
						<td>'.$i.'</td>
					</tr>
					<tr nobr="true">
						<td width = "200">Total Amount</td>
						<td width = "100">'.moneyFormatIndia($Total).'</td>
					</tr>
					</table>';
		if($pdf->getY()>160)
		{
			$this->aobj_context->laspage = "lastpage";
			$pdf->AddPage("L");
			$pdf->writeHTML($table5, false, false, false, false);
			$this->aobj_context->laspage = "";
		}
		else
		{
			$pdf->writeHTML($table5, false, false, false, false);
		}*/

$pdf->SetMargins(12,62,20,false);
		// $pdf->startPageGroup();
		$this->aobj_context->laspage = "lastpage";
		$pdf->AddPage("L");

$pdf->SetFont('Times','B',10);
		$pdf->Ln(10);
		
		$pdf->MultiCell(0,'6','1. That all the original documents such as Marks Cards, Transfer Certificate, Migration Certificate, Eligibility Certificate etc., furnished by the candidate admitted during             2018 - 2019 are carefully verified  and they are in order in all respects.',0,'L');

$pdf->MultiCell(0,'6','2. That the particular furnished by me in respect of the above Candidates in the statement of admission are based on original documents produced by them and they are true         to the best of my knowledge and belief.',0,'L');

$pdf->MultiCell(0,'6','3. That all the students recommended in this admission statement for approval for 2018 - 2019 are academically eligible and have satisfied the regulations of the sources for           which they are admitted.',0,'L');	
  
		$pdf->MultiCell(0,'6','4. The students admitted to the courses are within the intake sanctioned by the Government of Karnataka/Bangalore University to the College/ Department .',0,'L');

$pdf->MultiCell(0,'6','5. That the Registration and Eligibility fees from the candidates concerned are duly collected or remitted to the University funds.',0,'L');

$pdf->MultiCell(0,'6','6. That no candidate other than the candidates mentioned in this statement of admission are admitted to any course in this college for the Academic year 2018 - 2019.',0,'L');		
		$pdf->Ln(30);
		$pdf->Cell(250,'6','Signature of the principal with Seal and Date',0,1,'R');		
		
	}
		
	function SendOutput()
	{
		ob_end_clean();
		$this->pdf->Output("Admission_Summary_{$_SESSION['collcode']}.pdf","D");
	}	 
}

function generateadmlist($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);

$degree_code = $aobj_context->mobj_data["degree_code"];
	
	$admCollDataQuery = "SELECT s.fappno,s.fcollcode,s.fdegree,s.fcombcode,
	m.FCOMBDESC, trim(s.fname) as fname, s.fgender, 
	DATE_FORMAT(fdob,'%d/%m/%Y') AS fdob, s.FSTUTYPE as FCOMSTATE, DATE_FORMAT(fadmdate,'%d/%m/%Y') AS fdoa,
	ifnull(s.ftotfee,0) as ftotfee,s.FQUOTA,
	s.fcaste,s.FTYPEQUALEXAM, CONCAT(FQSECMARKS,'/',FQMAXMARKS)  AS fmarks, 
	GROUP_CONCAT(DISTINCT ifnull(su.fsubname,'-')) AS fsubcode, 
	GROUP_CONCAT(DISTINCT if(st.fdoctype = 'GCCERT','ELIGCERT',st.fdoctype)
	,IF(IFNULL(st.file_path,'') = '',' - No',' - Yes') separator ' | ') as studdoc
	FROM studadm s 
	INNER JOIN options o ON s.fappno = o.fappno AND s.fdegree = o.fdegree 
	AND s.fcollcode = o.fcollcode
	INNER JOIN studoc st ON s.fappno = st.login_cnt AND s.fdegree = st.fdegree 
	AND s.fcollcode = st.fcollcode and st.fdoctype in('PUMC','SSLCMC','GCCERT')
	left  join subject su ON s.fdegree = su.fdegree AND o.fexamno = su.fexamno 
	AND o.fsubcode = su.fsubcode AND
	IFNULL(su.fintass,'') <> 'T' AND su.fsubcode BETWEEN 'A002' AND 'A015'
	INNER JOIN mascomb m ON s.fdegree = m.fdegree AND m.fcombcode = s.fcombcode
	WHERE IFNULL(s.FAPPSTATUS,'') = 'verified' AND 
	s.fcollcode = '{$_SESSION['collcode']}' AND s.fdegree = '{$degree_code}'
	and ifnull(s.fdeleted,'') <> 'T' and IFNULL(s.ffinsub,'') = 'T'
	GROUP BY s.fappno 
	ORDER BY s.fdegree,s.fcombcode,s.fname,s.fappno";
	//var_dump($admCollDataQuery);
	$admCollData = $aobj_context->mobj_db->GetAll($admCollDataQuery);

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

$class_obj->writeReport($admCollData);

$class_obj->SendOutput();
}

${this.title}

Code Editor : admreportlist.php