Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
phpmailer	[ DIR ]	drwxr-xr-x
.htaccess	602 B	-rwxr-xr-x
appForm.php	20.98 KB	-rwxr-xr-x
appForm_22022018.php	20.63 KB	-rwxr-xr-x
applicationFormReportPOSTOFFIC...	19.27 KB	-rwxr-xr-x
applicationFormReportSBM.php	31.97 KB	-rwxr-xr-x
applicationFormReportSBM_21022...	31.63 KB	-rwxr-xr-x
applicationFormReportSBM_29102...	31.93 KB	-rwxr-xr-x
applicationStatus.php	2.94 KB	-rwxr-xr-x
cManualMailer.php	1.52 KB	-rwxr-xr-x
caccesscontext.php	1.24 KB	-rwxr-xr-x
candidate_list.php	54.71 KB	-rwxr-xr-x
cappcontext.php	2.67 KB	-rwxr-xr-x
changeExmCntr.php	4.62 KB	-rwxr-xr-x
changeExmCntrReport.php	10.03 KB	-rwxr-xr-x
cmailer.php	6.83 KB	-rwxr-xr-x
code39.php	6.38 KB	-rwxr-xr-x
coutput.php	1.76 KB	-rwxr-xr-x
createUser.php	2.05 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
customappcontext.php	2.35 KB	-rwxr-xr-x
dropdown.php	844 B	-rwxr-xr-x
editApplication.php	12.13 KB	-rwxr-xr-x
feehead.php	1.51 KB	-rwxr-xr-x
format.php	7.43 KB	-rwxr-xr-x
fpdf_protection.php	5.61 KB	-rwxr-xr-x
getdata.php	1.06 KB	-rwxr-xr-x
getnumword.php	7.15 KB	-rwxr-xr-x
home.html	14.48 KB	-rwxr-xr-x
json.php	33.72 KB	-rwxr-xr-x
login.php	1.76 KB	-rwxr-xr-x
mregistry.php	5.45 KB	-rwxr-xr-x
re_rigistration.php	7.83 KB	-rwxr-xr-x
re_rigistration_10042018_BEFOR...	6.98 KB	-rwxr-xr-x
re_rigistration_24042018.php	7.14 KB	-rwxr-xr-x
re_rigistration_27042018.php	7.18 KB	-rwxr-xr-x
re_rigistration_old_15042019.p...	7.59 KB	-rwxr-xr-x
reportApproveList.php	8.09 KB	-rwxr-xr-x
reportApproveList_18072018.php	8.04 KB	-rwxr-xr-x
report_appstatus.php	5.91 KB	-rwxr-xr-x
report_hall_ticket.php	11.31 KB	-rwxr-xr-x
reportapplicationform - Copy.p...	19.59 KB	-rwxr-xr-x
reportapplicationform.php	23.92 KB	-rwxr-xr-x
rotation.php	596 B	-rwxr-xr-x
saveApplication.php	16.4 KB	-rwxr-xr-x
saveApplication_21022018.php	8.99 KB	-rwxr-xr-x
saveApplication_mohan.php	9.04 KB	-rwxr-xr-x
saveRerigistration.php	11.72 KB	-rwxr-xr-x
saveRerigistration_03052018.ph...	10.87 KB	-rwxr-xr-x
saveRerigistration_10052018.ph...	11.12 KB	-rwxr-xr-x
servfee.php	1.38 KB	-rwxr-xr-x
servicedet.php	1.6 KB	-rwxr-xr-x
stringspliter.php	693 B	-rwxr-xr-x
student.php	24.46 KB	-rwxr-xr-x
updateFeeDet.php	1.66 KB	-rwxr-xr-x

Code Editor : reportApproveList.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;
    	$this->fromdeg = trim($aobj_context->mobj_data["fromdeg"]);
		$this->todeg = trim($aobj_context->mobj_data["todeg"]);
		$this->fromcoll = trim($aobj_context->mobj_data["fromcoll"]);
		$this->tocoll = trim($aobj_context->mobj_data["tocoll"]);
		$this->fromapp = trim($aobj_context->mobj_data["fromapp"]);
		$this->toapp = trim($aobj_context->mobj_data["toapp"]);
		$this->year = trim($aobj_context->mobj_data["year"]);
		$this->strAprtype = trim($aobj_context->mobj_data["pAprtype"]);
    }
    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(20,50,20,true);	
		$this->SetFillColor(248, 248 ,255);		
		$this->SetFont('Times','',10);

$img_path = $this->aobj_context->main_src."/img/logo.jpg";
		if(file_exists($img_path)) 
			$this->Image($img_path,60,6,20,20);
		$img_path = $this->aobj_context->main_src."/img/logo2.jpg";
		if(file_exists($img_path)) 
			$this->Image($img_path,210,6,20,20);
		$this->SetFont('helvetica','B',17);
		$this->Ln(2);
		$this->Cell(250,4,'KUVEMPU UNIVERSITY',0,1,'C');
		$this->SetFont('Times','',12);
		$this->Cell(250,4,'DIRECTORATE OF DISTANCE EDUCATION',0,1,'C');

$this->SetFont('Times','B',11);
		$this->Cell(250,4,'Degree Range - '.$this->fromdeg." to ".$this->todeg,0,1,'C');
		$this->Cell(250,4,'College Range - '.$this->fromcoll." to ".$this->tocoll,0,1,'C');
		$this->Cell(250,4,'Application Range - '.$this->fromapp." to ".$this->toapp,0,1,'C');
		$approve_type = $this->strAprtype == 0? 'All': $this->strAprtype;
		$this->Cell(250,4,'Approval Type - '.$approve_type,0,1,'C');
		$table_head = '<table cellpadding="3" cellspacing="0" border="1">
			<tr nobr="true"><th width="40" align="center"><b>Sl. No.</b></th>
				<th width="100" align="center"><b>Application No.</b></th>
				<th width="45" align="center"><b>Degree</b></th>
				<th width="50" align="center"><b>Year / Sem</b></th>
				<th width="45" align="center"><b>Centre Code</b></th>
				<th width="180" align="center"><b>Student Name</b></th>
				<th width="70" align="center"><b>Reg. No.</b></th>
				<th width="65" align="center"><b>Status</b></th>
				<th width="70" align="center"><b>Approver</b></th>
				<th width="80" align="center"><b>Approved Date</b></th>
			</tr>
		</table>';
		$this->ln(4);
		$this->writeHTML($table_head, false, true, false, false, 'C');
        // restore auto-page-break status
        $this->SetAutoPageBreak($auto_page_break, $bMargin);
        // set the starting point for the page content    
    }

public function Footer() 
    {
        $this->SetY(-15);
        $this->SetFont('helvetica', 'I', 8);
        $this->Cell(50, 10,'IP : '.$_SERVER["REMOTE_ADDR"], 0, 0, 'L');
        $this->Cell(50, 10,'Date : ' .$this->aobj_context->current_date, 0, 0, 'L');

$this->Cell(170, 10,'Page ' .$this->getAliasNumPage().'/'.$this->getAliasNbPages(), 0, 1, 'R');
    }
}

class AddmissionApproveList
{	
	function DefaultConstructor($aobj_context)
	{
		$this->aobj_context=$aobj_context;
		//$this->pdf=  new FPDF();
		$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);
		$this->aobj_context->main_src = realpath(__DIR__ . '/../..');
		$this->aobj_context->main_src = $this->aobj_context->main_src.'/';
		$this->aobj_context->current_date =  $obj[now_date];
		$this->current_date = $obj[now_date];
		$this->pdf= new MYPDF('L');
		$this->pdf->setData($aobj_context);
		
		$this->fromdeg = trim($aobj_context->mobj_data["fromdeg"]);
		$this->todeg = trim($aobj_context->mobj_data["todeg"]);
		$this->fromcoll = trim($aobj_context->mobj_data["fromcoll"]);
		$this->tocoll = trim($aobj_context->mobj_data["tocoll"]);
		$this->fromapp = trim($aobj_context->mobj_data["fromapp"]);
		$this->toapp = trim($aobj_context->mobj_data["toapp"]);
		$this->year = trim($aobj_context->mobj_data["year"]);
		$this->strAprtype = trim($aobj_context->mobj_data["pAprtype"]);

}
 
	function formcolldata()
	{
		$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);
		
		$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']; 
	}

function appData()
	{
		if($this->strAprtype == 'APPROVED')
			$aprCondition = "and sa.fapprstatus = 'APPROVED'";
		else if($this->strAprtype == 'PENDING')
			$aprCondition = "and (sa.fapprstatus = 'PENDING' or sa.fapprstatus is null)";
		else
			$aprCondition = "";

if($_SESSION['USERTYPE'] == 'usr')
		{
			$usr_condition = "and sa.fapprusername = '{$_SESSION['USER']}'";
		}
		else
		{
			$usr_condition = "";
		}

$get_app_query = "select fappno,
		ifnull(DATE_FORMAT(fcreatedate, '%d/%m/%Y'), '02/03/2018') as applied_date,
		fname, fcollcode,dg.fdegree as degree, 
		REPLACE(dg.fexamname, 'SEMESTER', 'SEM') as fexamname,
		sa.ftotfee+ifnull(dg.fadmfine,0) as fadmfee,
		ifnull(sa.fapprstatus,'PENDING') as status,
		ifnull(sa.FLOGNAME,'') as user,
		ifnull(DATE_FORMAT(FAPPRDATE, '%d/%m/%Y'), '') as ack_date,
		ifnull(sa.fregno,'') as fregno
		from studadm sa 
		inner join degree dg 
		on sa.fdegree = dg.fdegree 
		and sa.fexamno = dg.fexamno
		where sa.fdegree between '{$this->fromdeg}' and '{$this->todeg}'
		and sa.fcollcode between '{$this->fromcoll}' and '{$this->tocoll}'
		and sa.fappno between '{$this->fromapp}' and '{$this->toapp}'
		and sa.fexamno = '{$this->year}' {$usr_condition} {$aprCondition} 
		and IFNULL(fpaymenttype,'') NOT IN ('undefined', 'null')
		order by sa.fdegree desc, fcollcode desc";

//var_dump($get_app_query);
		$this->results =$this->aobj_context->mobj_db->GetAll($get_app_query);

}
	
		
	function writeApproveList()
	{
		//$this->printHeaders();

//var_dump($this->results);
		$pdf=$this->pdf;

$pdf->SetMargins(20,50,20,false);
		$pdf->AddPage("L");

$pdf->SetFont('courier','',11);

$i = 1;
		$head = '<table cellpadding="3" cellspacing="0" border="1">';
		$table_body = '';
		$first = 1;
		foreach ($this->results as $key => $value) 
		{
			$table_body .= '<tr nobr="true">
				<td width="40" align="center">'.$i.'</td>
				<td width="100">'.$value['fappno'].'</td>
				<td width="45">'.$value['degree'].'</td>
				<td width="50">'.$value['fexamname'].'</td>
				<td width="45">'.$value['fcollcode'].'</td>
				<td width="180" align="left">'.$value['fname'].'</td>
				<td width="70" align="right">'.$value['fregno'].'</td>
				<td width="65">'.$value['status'].'</td>
				<td width="70" align="left">'.$value['user'].'</td>
				<td width="80">'.$value['ack_date'].'</td>
			</tr>';

$i++;
			if($i % 20 == 0)
			{
				$table_body .= '</table>';
				$pdf->writeHTML($head.$table_body, false, true, false, false, 'C');
				$table_body = '';
			}
			
		}
		
		$table_body .= '</table>';
		//var_dump($i);
		if($i % 20 != 0)
			$pdf->writeHTML($head.$table_body, true, true, false, false, 'C');
	}
		
	function SendOutput()
	{
		$this->pdf->Output("approve_list_{$this->current_date}.pdf","D");
	}	 
}

function printApproveList($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
	$class_obj = new AddmissionApproveList();
	$class_obj->DefaultConstructor($aobj_context);
	$class_obj->formcolldata();
	$class_obj->appData();
	$class_obj->writeApproveList();
	
	$class_obj->SendOutput();
}
?>

${this.title}

Code Editor : reportApproveList.php