Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
admin.php	7.42 KB	-rwxr-xr-x
applicationFormReportNETBANKIN...	17.07 KB	-rw-r--r--
cManualMailer.php	1.38 KB	-rwxr-xr-x
candidate_certificate.php	9.89 KB	-rwxr-xr-x
candidate_certificate_old.php	7.6 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
phpinfo.php	19 B	-rwxr-xr-x
sendGridMail.php	1.29 KB	-rwxr-xr-x
sendsmsapi.php	1014 B	-rwxr-xr-x
sendsmsapiv1.php	5.6 KB	-rwxr-xr-x
sikkimstuddet.php	1.56 KB	-rw-rw-r--
sikkimstuddetreport.php	9.75 KB	-rw-rw-r--
student.php	76.41 KB	-rw-r--r--
student_nehu.php	57.6 KB	-rwxr-xr-x
system_general_master_setup_si...	43.96 KB	-rw-rw-r--
test.php	3.38 KB	-rwxr-xr-x

Code Editor : sikkimstuddetreport.php

<?php

function GetCollwiseCandidateReport($aobj_context)
{
	session_start();
	$collcode=$_SESSION['collcode'];
	
	ini_set('memory_limit','300M');
	ini_set('max_execution_time',3300);
	
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
	$filename = 'CandidateList.csv';
	$f = fopen('php://output', 'w');

$univcode = trim($aobj_context->mobj_data["univcode"]);  
	$from_app = trim($aobj_context->mobj_data["from_app"]);
	$to_app = trim($aobj_context->mobj_data["to_app"]);
	$from_app = trim($aobj_context->mobj_data["from_app"]);
	$to_app = trim($aobj_context->mobj_data["to_app"]);
	$fromdeg = trim($aobj_context->mobj_data["fromdeg"]);
	$todeg = trim($aobj_context->mobj_data["todeg"]);
	$fromdate=trim($aobj_context->mobj_data["fromdate"]);
	$todate=trim($aobj_context->mobj_data["todate"]);
	$paystatus = trim($aobj_context->mobj_data["paystatus"]);
	$certificatetype = trim($aobj_context->mobj_data["certificatetype"]);

$cnd = "";
	if($paystatus == 'success')
	{
		$cnd = "and ifnull(st.FPAYSTATUS,'') = 'success'";
	}else if($paystatus == 'pending')
	{
	   $cnd = "and ifnull(st.FPAYSTATUS,'') <> 'success'";
	}else
	{
	   $cnd = "";	 
	}

if($certificatetype == 'All'){
	   $cnd2 = "";
	}else{
	   $cnd2 = "AND FRCTYPE = '{$certificatetype}'";
	}
	
   $get_qry = "SELECT st.fappno,s.FNAME,s.FREGNO,s.fdegree,s.fcollcode,
	concat(c.fcollname,', ',c.ftown) as college_name,
	st.fmobile,ifnull(FCNVNO,'') as FCNVNO,
	st.FPAYDATE,st.FAMOUNT,st.FEMAIL,FRCTYPE,FAADHAR,'' as fgender,
   if(ifnull(st.fkanname,'') = '',s.fkanname,st.fkanname) as kannada_name,
   ifnull(st.FPAYSTATUS,'') as payment,
   ifnull(s.FCLASS,'-') as FCLASS,
   ifnull(s.FCEXAM,'-') as FCEXAM,
   ifnull(s.FCYEAR,'-') as FCYEAR,
   ifnull(FPOSTADDR1,'') as FPOSTADDR1,
   ifnull(FPOSTADDR2,'') as FPOSTADDR2,
   ifnull(FCITY,'') as FCITY,
   ifnull(FSTATE,'') as FSTATE,
   ifnull(FPINCODE,'') as FPINCODE,
   ifnull(FGOLD,'') as FGOLD,
   ifnull(fvname1,'') as fvname1,
   ifnull(fvname2,'') as fvname2,
   ifnull(fvrelation1,'') as fvrelation1,
   ifnull(fvrelation2,'') as fvrelation2,
   ifnull(fvemail1,'') as fvemail1,
   ifnull(fvemail2,'') as fvemail2,
   ifnull(fvmob2,'') as fvmob2,
   ifnull(fvmob1,'') as fvmob1
	   FROM dcstud s left join dctran st on st.FREGNO = s.FREGNO
	   inner join college c on c.fcollcode = s.fcollcode
	   where ifnull(s.fname,'') <> '' 
	   and st.fappno between '{$from_app}' and '{$to_app}'
	   and s.fdegree between '{$fromdeg}' and '{$todeg}'
	   and left(st.FREGDATE,10) between 
	   date_format(str_to_date('{$fromdate}','%d/%m/%Y'),'%Y-%m-%d') and 
	   date_format(str_to_date('{$todate}','%d/%m/%Y'),'%Y-%m-%d')
	   {$cnd}
	   {$cnd2}
	order by ifnull(st.FPAYSTATUS,'') desc, FCNVNO";

$lobj_get_data = $aobj_context->mobj_db->GetAll($get_qry);

if(!empty($lobj_get_data))
	{
		$e_data.="<table cellspacing='0' cellpadding='1' border='1' width = ''>";
		$e_data.="<tr>";
		$e_data.="<td style = 'text-align:center;font-weight: bold;row-height:40px;' >Sl. No.</td>";
		$e_data.="<td style = 'text-align:center;font-weight: bold;row-height:40px;' >APP No</td>";
		$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >Reg. No.</td>";
		$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;'>Mobile No.</td>";
		$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;'>Email IDh</td>"; 
		$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;'>Degree.</td>";
		$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >Coll Code</td>";
		$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >College Name</td>";	
        $e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >English Name</td>";	
        $e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >Kannada Name</td>";
		$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >Gender</td>";
		$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >Payment Status</td>";
		$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >Convocation</td>";
		$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >Payment Date</td>";
		$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >AMOUNT</td>";
		$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >Certificate type</td>";
		$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >Aadhar No</td>";
		$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >Class</td>";
		$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >YEAR</td>";
		$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >Month</td>";
		$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >POST. ADDR. 1</td>";		
		$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >POST. ADDR. 2</td>";
		$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >CITY</td>";
		$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >STATE</td>";
		$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >PIN CODE</td>";
		$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >GOLD Medal</td>";

$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >Visitor 1 Name</td>";
		$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >Visitor 1 Relation</td>";
		$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >Visitor 1 Email</td>";
		$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >Visitor 1 MOB</td>";

$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >Visitor 2 Name</td>";
		$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >Visitor 2 Relation</td>";
		$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >Visitor 2 Email</td>";
		$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >Visitor 2 MOB</td>";

$e_data.="</tr>";							
		$k=0;
		$id=0;
		$m=0;
		$filename = 'CandidateList';
		$counter_degree=1;

foreach($lobj_get_data as $key=>$value)
		{
			if($k%2==0)
			{
				$class='tbl_row';
				$inp_class='tbl_row_input';
			}
			else
			{
				$input_class='tbl_row1'; 
				$inp_class='tbl_row1_input';
			}  
			
			// $address = $value['fpostaddr1'].' '.$value['fpostaddr2'].' '.$value['fpostaddr3'].$value['fpostaddr4'].'<br>City : '.$value['fcity'].'<br>Pincode : '.$value['fpincode'].'<br>State : '.$value['fstate']; 
			
			$e_data.="<tr>";	
			$e_data.="<td style = 'text-align:center' >{$counter_degree}</td>";			
			$e_data.="<td style = 'text-align:center' >{$value['fappno']}</td>";
			$e_data.="<td style = 'text-align:center;' >{$value['FREGNO']}</td>";
			$e_data.="<td style = 'text-align:center;' >{$value['fmobile']}</td>";
			$e_data.="<td style = 'text-align:center;' >{$value['FEMAIL']}</td>"; 
			$e_data.="<td style = 'text-align:center;' >{$value['fdegree']}</td>";
			$e_data.="<td style = 'text-align:center;' >{$value['fcollcode']}</td>";
         $e_data.="<td >{$value['college_name']}</td>";
         $e_data.="<td >{$value['FNAME']}</td>";
         $e_data.="<td style = 'text-align:center;' >{$value['kannada_name']}</td>";
		 $e_data.="<td style = 'text-align:center;' >{$value['fgender']}</td>";
         $e_data.="<td style = 'text-align:center;' >{$value['payment']}</td>";
         $e_data.="<td style = 'text-align:center;' >{$value['FCNVNO']}</td>";
         $e_data.="<td style = 'text-align:center;' >{$value['FPAYDATE']}</td>";
         $e_data.="<td style = 'text-align:center;' >{$value['FAMOUNT']}</td>";
         $e_data.="<td style = 'text-align:center;' >{$value['FRCTYPE']}</td>";
         $e_data.="<td style = 'text-align:center;' >{$value['FAADHAR']}</td>";
         $e_data.="<td style = 'text-align:center;' >{$value['FCLASS']}</td>";
		 $e_data.="<td style = 'text-align:center;' >{$value['FCYEAR']}</td>";
         $e_data.="<td style = 'text-align:center;' >{$value['FCEXAM']}</td>";
		 $e_data.="<td style = 'text-align:center;' >{$value['FPOSTADDR1']}</td>";
		 $e_data.="<td style = 'text-align:center;' >{$value['FPOSTADDR2']}</td>";
		 $e_data.="<td style = 'text-align:center;' >{$value['FCITY']}</td>";
		 $e_data.="<td style = 'text-align:center;' >{$value['FSTATE']}</td>";
		 $e_data.="<td style = 'text-align:center;' >{$value['FPINCODE']}</td>";
		 $e_data.="<td style = 'text-align:center;' >{$value['FGOLD']}</td>";

$e_data.="<td style = 'text-align:center;' >{$value['fvname1']}</td>";
		 $e_data.="<td style = 'text-align:center;' >{$value['fvrelation1']}</td>";
		 $e_data.="<td style = 'text-align:center;' >{$value['fvemail1']}</td>";
		 $e_data.="<td style = 'text-align:center;' >{$value['fvmob1']}</td>";

$e_data.="<td style = 'text-align:center;' >{$value['fvname2']}</td>";
		 $e_data.="<td style = 'text-align:center;' >{$value['fvrelation2']}</td>";
		 $e_data.="<td style = 'text-align:center;' >{$value['fvemail2']}</td>";
		 $e_data.="<td style = 'text-align:center;' >{$value['fvmob2']}</td>";

$e_data.="</tr>";
			$k++;
			$id++;
			$m++;
			$counter_degree++;
		}
		$e_data.="</table>";
		//var_dump($e_data);die();
		$arr['total_count']= $m;						
		$arr['html']=$e_data;
		$arr['error']=0;
	}
	else
	{
		$arr['html'] = '<p> No record found </p>';
	}	
	header("Content-Type:application/xls");
	header("Content-Disposition: attachment; filename={$filename}.xls"); 
	echo $e_data;
}

${this.title}

Code Editor : sikkimstuddetreport.php