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.="";
$e_data.="";
$e_data.="| Sl. No. | ";
$e_data.="APP No | ";
$e_data.="Reg. No. | ";
$e_data.="Mobile No. | ";
$e_data.="Email IDh | ";
$e_data.="Degree. | ";
$e_data.="Coll Code | ";
$e_data.="College Name | ";
$e_data.="English Name | ";
$e_data.="Kannada Name | ";
$e_data.="Gender | ";
$e_data.="Payment Status | ";
$e_data.="Convocation | ";
$e_data.="Payment Date | ";
$e_data.="AMOUNT | ";
$e_data.="Certificate type | ";
$e_data.="Aadhar No | ";
$e_data.="Class | ";
$e_data.="YEAR | ";
$e_data.="Month | ";
$e_data.="POST. ADDR. 1 | ";
$e_data.="POST. ADDR. 2 | ";
$e_data.="CITY | ";
$e_data.="STATE | ";
$e_data.="PIN CODE | ";
$e_data.="GOLD Medal | ";
$e_data.="Visitor 1 Name | ";
$e_data.="Visitor 1 Relation | ";
$e_data.="Visitor 1 Email | ";
$e_data.="Visitor 1 MOB | ";
$e_data.="Visitor 2 Name | ";
$e_data.="Visitor 2 Relation | ";
$e_data.="Visitor 2 Email | ";
$e_data.="Visitor 2 MOB | ";
$e_data.="
";
$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'].'
City : '.$value['fcity'].'
Pincode : '.$value['fpincode'].'
State : '.$value['fstate'];
$e_data.="";
$e_data.="| {$counter_degree} | ";
$e_data.="{$value['fappno']} | ";
$e_data.="{$value['FREGNO']} | ";
$e_data.="{$value['fmobile']} | ";
$e_data.="{$value['FEMAIL']} | ";
$e_data.="{$value['fdegree']} | ";
$e_data.="{$value['fcollcode']} | ";
$e_data.="{$value['college_name']} | ";
$e_data.="{$value['FNAME']} | ";
$e_data.="{$value['kannada_name']} | ";
$e_data.="{$value['fgender']} | ";
$e_data.="{$value['payment']} | ";
$e_data.="{$value['FCNVNO']} | ";
$e_data.="{$value['FPAYDATE']} | ";
$e_data.="{$value['FAMOUNT']} | ";
$e_data.="{$value['FRCTYPE']} | ";
$e_data.="{$value['FAADHAR']} | ";
$e_data.="{$value['FCLASS']} | ";
$e_data.="{$value['FCYEAR']} | ";
$e_data.="{$value['FCEXAM']} | ";
$e_data.="{$value['FPOSTADDR1']} | ";
$e_data.="{$value['FPOSTADDR2']} | ";
$e_data.="{$value['FCITY']} | ";
$e_data.="{$value['FSTATE']} | ";
$e_data.="{$value['FPINCODE']} | ";
$e_data.="{$value['FGOLD']} | ";
$e_data.="{$value['fvname1']} | ";
$e_data.="{$value['fvrelation1']} | ";
$e_data.="{$value['fvemail1']} | ";
$e_data.="{$value['fvmob1']} | ";
$e_data.="{$value['fvname2']} | ";
$e_data.="{$value['fvrelation2']} | ";
$e_data.="{$value['fvemail2']} | ";
$e_data.="{$value['fvmob2']} | ";
$e_data.="
";
$k++;
$id++;
$m++;
$counter_degree++;
}
$e_data.="
";
//var_dump($e_data);die();
$arr['total_count']= $m;
$arr['html']=$e_data;
$arr['error']=0;
}
else
{
$arr['html'] = ' No record found
';
}
header("Content-Type:application/xls");
header("Content-Disposition: attachment; filename={$filename}.xls");
echo $e_data;
}
?>