Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
admin.php	3.34 KB	-rwxr-xr-x
cManualMailer.php	1.38 KB	-rwxr-xr-x
candidate_certificate.php	6.73 KB	-rwxr-xr-x
cnvdetails.php	3.61 KB	-rwxr-xr-x
common_data.php	1.91 KB	-rwxr-xr-x
dash_board_client.php	4.4 KB	-rwxr-xr-x
dashboard_customer.php	13.56 KB	-rwxr-xr-x
display_custom_html.php	8.47 KB	-rwxr-xr-x
execute_query.php	754 B	-rwxr-xr-x
get_commmon_data.php	3.76 KB	-rwxr-xr-x
pending_certificate.php	8.15 KB	-rwxr-xr-x
sendGridMail.php	1.17 KB	-rwxr-xr-x
sendsmsapi.php	1014 B	-rwxr-xr-x
student.php	42.78 KB	-rwxr-xr-x
student03032017.php	33.84 KB	-rwxr-xr-x
student06092016.php	30.58 KB	-rwxr-xr-x
student10042017.php	35.89 KB	-rwxr-xr-x
student13062016.php	29.43 KB	-rwxr-xr-x
student14112016.php	32.08 KB	-rwxr-xr-x
student18042017.php	36.08 KB	-rwxr-xr-x
student22.php	34.45 KB	-rwxr-xr-x
student_08032018.php	42.05 KB	-rwxr-xr-x
student_23082017.php	36.13 KB	-rwxr-xr-x
student_cug.php	42.77 KB	-rwxr-xr-x
student_mohan.php	35 KB	-rwxr-xr-x
student_old.php	32.46 KB	-rwxr-xr-x
test.php	3.38 KB	-rwxr-xr-x

Code Editor : cnvdetails.php

<?php
function Generatecnvsummary($aobj_context)
{
	$pdf_writer_class = $aobj_context->main_src."/ExcelWriterXML/ExcelWriterXML.php";
	include($pdf_writer_class);
	$xml = new ExcelWriterXML('my file.xml');

$xml->showErrorSheet(true);

$app_from_app = trim($aobj_context->mobj_data["app_from_app"]);
	$app_to_app = trim($aobj_context->mobj_data["app_to_app"]);
	$status = trim($aobj_context->mobj_data["status"]);

/**
	 * Show the style options
	 */
	$format1 = $xml->addStyle('left_rotate60_big');
	$format1->alignRotate(60);
	$format1->alignHorizontal('Left');
	$format1->fontSize('18');

$format2 = $xml->addStyle('verticaltext_left');
	$format2->alignVerticaltext(45);
	$format2->alignHorizontal('Left');

$format3 = $xml->addStyle('wraptext_top');
	$format3->alignWraptext();
	$format3->alignVertical('Top');

$sheet1 = $xml->addSheet('Alignment');

$title1 = array('','Sl. No.',"Application No.",'Roll Number','Name','Center','Degree',"Father's Name","Mother's Name",'Category','D.O.B.','Mobile no.','Email Id.','Aadhaar No.','Postal Address','Receive Certificate','Amount','Status');
	$w = array('30','60','50','50','50','50','50','50','50','50','50','50','50','50','50','50','50','50');
	$j = 5;
	$slno = 1;
	$report = "Candidates Applied List";
	
	if($status == 'Pending')
	{
		$cnd = "and ifnull(fpaystatus,'') <> 'success'";
		
	}else if($status == 'Paid')	
	{
		$cnd = "and fpaystatus = 'success'";
		
	}else
	{
		$cnd = "and 1=1";
	}		
	
	$query = "select dc.FAPPNO,dc.FREGNO,dc.FNAME,dc.fhiname,dc.ffname,dc.fmname,dc.FDOB,dc.FMOBILE,dc.FEMAIL,dc.fadharno,fpaystatus,FCASTE,
dc.FPOSTADDR1,dc.FPOSTADDR2,dc.FPOSTADDR3,dc.FPOSTADDR4,dc.freccer,dc.FAMOUNT,
CONCAT(ds.FDEGREE,' - ',d.fdescpn) as FDEGREE,CONCAT(ds.FCOLLCODE,' - ',c.fcollname) as FCOLLCODE,ds.FFACCODE 
from dctran  dc inner join dcstud ds on (ds.fregno = dc.fregno or ds.fenroll = dc.fregno)
inner join degree d on dc.fdegree = d.fdegree and d.fexamno = 'a'
inner join college c on ds.fcollcode = c.fcollcode
			where fappno between '{$app_from_app}' and '{$app_to_app}' {$cnd}";
	$lobj_get_data = $aobj_context->mobj_db->GetAll($query);
	
	if(!empty($lobj_get_data))
	{
		$query1 = "select funivname from control";
		$result = $aobj_context->mobj_db->GetRow($query1);
		$format4 = $xml->addStyle('my style');
		$format4->fontBold();
		$sheet1->writeString(1,1, $result['funivname'],$format4);

$sheet1->writeString(2,1,$report,$format4);
		
		$sheet1->writeString(3,1,'Application Range : '.$app_from_app.' - '.$app_to_app,$format4);
		
		for($i = 1;$i<count($w);$i++)
		{
			$sheet1->writeString(4,$i, $title1[$i],$format4);
		}
		foreach($lobj_get_data as $key=>$value)
		{
			$sheet1->writeString($j,1,$slno,$format);
			$sheet1->writeString($j,2, $value['FAPPNO']);
			$sheet1->writeString($j,3, $value['FREGNO']);
			$sheet1->writeString($j,4, $value['FNAME']);
			$sheet1->writeString($j,5, $value['FCOLLCODE']);
			$sheet1->writeString($j,6, $value['FDEGREE']);
			$sheet1->writeString($j,7, $value['ffname']);
			$sheet1->writeString($j,8, $value['fmname']);
			$sheet1->writeString($j,9,$value['FCASTE']);
			$sheet1->writeString($j,10, $value['FDOB']);
			$sheet1->writeString($j,11, $value['FMOBILE']);
			$sheet1->writeString($j,12, $value['FEMAIL']);
			$sheet1->writeString($j,13, $value['fadharno']);
			$address = $value['FPOSTADDR1'].''.$value['FPOSTADDR2'].''.$value['FPOSTADDR3'].''.$value['FPOSTADDR4']; 
			$sheet1->writeString($j,14, $address);
			$sheet1->writeString($j,15, $value['freccer']);
			$sheet1->writeString($j,16, $value['FAMOUNT']);
			$sheet1->writeString($j,17, $value['fpaystatus']);
			$j++;
			$slno++;
		}
	}

$xml->sendHeaders();
	$xml->writeData();
	$xml;

}

${this.title}

Code Editor : cnvdetails.php