Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
system	[ DIR ]	drwxr-xr-x
auto-complete.php	4.89 KB	-rwxr-xr-x
backup_restore.php	9.12 KB	-rwxr-xr-x
backupandrestore.php	10.18 KB	-rwxr-xr-x
cappcontext.php	3.19 KB	-rwxr-xr-x
cmailer_new.php	3.48 KB	-rwxr-xr-x
cnvdetails.php	5.95 KB	-rwxr-xr-x
coutput.php	1.75 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
db_sync.php	7.54 KB	-rwxr-xr-x
display_custom_html.php	8.47 KB	-rwxr-xr-x
display_details_in_grid.php	71.04 KB	-rwxr-xr-x
display_details_in_grid_custom...	2.67 KB	-rwxr-xr-x
forgot_password.php	3.76 KB	-rwxr-xr-x
format.php	6.75 KB	-rwxr-xr-x
getnumword.php	6.19 KB	-rwxr-xr-x
header.php	306 B	-rwxr-xr-x
jsmin.php	10.69 KB	-rwxr-xr-x
json.php	33.22 KB	-rwxr-xr-x
login.php	6.76 KB	-rwxr-xr-x
mregistry.php	3.11 KB	-rwxr-xr-x
sendLoginPassword.php	3.11 KB	-rwxr-xr-x
send_mail.php	2.88 KB	-rwxr-xr-x
system_utility.php	4.71 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');

/**
 * Add some general properties to the document
 
$xml->docTitle('My Demo Doc');
$xml->docAuthor('Robert F Greer');
$xml->docCompany('Greers.Org');
$xml->docManager('Wife');
*/
/**
 * Choose to show any formatting/input errors on a seperate sheet
 */
$xml->showErrorSheet(false);

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

/**
 * 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');

/**
 * Create a new sheet with the XML document
 */
$sheet1 = $xml->addSheet('Alignment');
/**
 * Add three new cells of type String with difference alignment values.
 * Notice that the style of the each cell can be explicity named or the style
 * reference can be passed.
 */
// $sheet1->writeString(1,1,'left_rotate45',$format1);
// $sheet1->writeString(1,2,'vertical left','verticaltext_left');
// $sheet1->writeString(1,3,'this text has been wrapped and is aligned at the top','wraptext_top');
// $sheet1->writeString(1,4,'No style applied');
$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');
$w = array('30','60','50','50','50','50','50','50','50','50','50','50','50','50','50','50','50');
$j = 5;
$report = "Candidates Applied List";
$query = "select dc.FAPPNO,dc.FREGNO,dc.FNAME,dc.fhiname,dc.ffname,dc.fmname,dc.FDOB,dc.FMOBILE,dc.FEMAIL,dc.fadharno,
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 fpaystatus = 'success' and fappno between '{$app_from_app}' and '{$app_to_app}'";
$lobj_get_data = $aobj_context->mobj_db->GetAll($query);
var_dump($query); die();
$slno = 1;
if(!empty($lobj_get_data))
{
		$query1 = "select funivname from control";
		$result = $aobj_context->mobj_db->GetRow($query1);
		
		$sheet1->writeString(1,1, $result['funivname']);
		
		
		
		//$sheet1->cellMerge(1,1,1,count($w));
		
		 $sheet1->writeString(2,1,$report);
		//$sheet->mergeCells(1,0,1,count($w));
		
		$sheet1->writeString(3,1,'Application Range : '.$app_from_app.' - '.$app_to_app);
		
		for($i = 1;$i<count($w);$i++)
		{
			$sheet1->writeString(4,$i, $title1[$i]);
		}
		foreach($lobj_get_data as $key=>$value)
		{
				//var_dump($lobj_get_data);die();
				
			$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['FFACCODE']);
				$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']);
				$j++;
				$slno++;
		}
		/*$sheet->mergeCells(2,0,2,count($w));
		
		
		
		$format_a = array('bordercolor' => 'black',
            'left' => 1, 
            'bottom' => 1,
            'right' => 1,
            'top' => 1,
            'bold'=>'1',
            'size' => '11',
            'color'=>'black',
            'align' => 'center');
	$format =& $xls->addFormat($format_a);
		for($i = 0;$i<count($w);$i++)
		{
			$sheet->writeString(3,$i, $title1[$i],$format);
		} */

}

$sheet2 = $xml->addSheet('Formulas');
/**
 * Wrote three numbers.
 * Rows 4 and 5 show the formulas in R1C1 notation using the writeFormula()
 * function.
 * Also see how comments are added.
 */
$sheet2->columnWidth(1,'100');
$sheet2->writeString(1,1,'Number');
$sheet2->writeNumber(1,2,50);
$sheet2->writeString(2,1,'Number');
$sheet2->writeNumber(2,2,30);
$sheet2->writeString(3,1,'Number');
$sheet2->writeNumber(3,2,20);
$sheet2->writeString(4,1,'=SUM(R[-3]C:R[-1]C)');
$sheet2->writeFormula('Number',4,2,'=SUM(R[-3]C:R[-1]C)');
$sheet2->addComment(4,2,'Here is my formula: =SUM(R[-3]C:R[-1]C)','My NAME');
$sheet2->writeString(5,1,'=SUM(R1C2:R3C2)');
$sheet2->writeFormula('Number',5,2,'=SUM(R1C1:R3C2)');
$sheet2->addComment(5,2,'Here is my formula: =SUM(R1C1:R3C2)');

$sheet4 = $xml->addSheet('more formatting');
$format4 = $xml->addStyle('my style');
$format4->fontBold();
$format4->fontItalic();
$format4->fontUnderline('DoubleAccounting');
$format4->bgColor('Black');
$format4->fontColor('White');
$format4->numberFormatDateTime();
$mydate = $sheet4->convertMysqlDateTime('2008-02-14 19:30:00');
$sheet4->writeDateTime(1,1,$mydate,$format4);
// Change the row1 height to 30 pixels
$sheet4->rowHeight(1,'30');
$sheet4->writeString(2,1,'formatted text + cell color + merged + underlined',$format4);
// Merge (2,1) with 4 columns to the right and 2 rows down
$sheet4->cellMerge(2,1,4,2);

/**
 * Send the headers, then output the data
 */
$xml->sendHeaders();
$xml->writeData();
$xml;

}

${this.title}

Code Editor : cnvdetails.php