Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
admFeeReport.php	19.4 KB	-rw-rw-r--
admapplication.php	10.42 KB	-rw-r--r--
test.php	7 KB	-rw-r--r--

Code Editor : admFeeReport.php

<?php
    $main_src = substr($_SERVER['SCRIPT_FILENAME'], 0, strlen($_SERVER['SCRIPT_FILENAME']) - 7);
    $pdf_writer_class = $main_src . "/tcpdf/tcpdf.php";
    require_once $pdf_writer_class;

class MYPDF extends TCPDF{
        public $aobj_context;
        public $degreegrp;

public function setData($aobj_context){
            $this->aobj_context = $aobj_context;
        }

public function Header($aobj_context){
            $this->univcode = $this->aobj_context->mobj_data["univcode"];  
            $bMargin = $this->getBreakMargin();
            $auto_page_break = $this->AutoPageBreak;
            $this->SetAutoPageBreak(false, 0);
            $this->SetTitle("Fee Report");

if($this->univcode == 'P001'){
                $img_path = $this->aobj_context->main_src . "/img/".$this->univcode."_header.jpg";
                $pageWidth = $this->getPageWidth();
                $pageHeight = $this->getPageHeight();
                $this->Image($img_path, 0, 0, $pageWidth, 30, '', '', '', true, 300, '', false, false, 0, false, false, false);
            }else{
                $img_path = $this->aobj_context->main_src . "/img/".$this->univcode."_logo.jpg";
                if (file_exists($img_path)) {
                    $this->Image($img_path, 10,3,30,10);
                }

$this->SetFont('Times', 'B', 12);
                
                $this->Ln(5);
                $this->Cell(0, 4, $this->aobj_context->funivname, 0, 1, 'C');

$this->SetFont('Times', 'B', 10);
                $this->Cell(0, 4, $this->aobj_context->add, 0, 1, 'C');
                
            
                $this->SetFont('Times', '', 10);
                $this->Cell(0, 4, $this->aobj_context->s_state, 0, 1, 'C');
                
                $this->SetFont('Times', '', 9);
                $this->Cell(0, 4, "TEL- ".$this->aobj_context->telno."     ". $website, 0, 1, 'C');
            }
                $this->SetAutoPageBreak($auto_page_break, $bMargin);
        }

public function Footer(){
            $this->SetY(-15);
            $this->SetFont('Times','',9);
            $this->Cell(180, 7, 'This report is electronically generated. Student signature is not required.',0,1,'L');
            $this->SetY(-15);
            $this->SetFont('helvetica', 'I', 8);
            $this->Cell(0, 10, 'Page ' . $this->getAliasNumPage() . '/' . $this->getAliasNbPages(), 0, false, 'R', 0, '', 0, false, 'T', 'M');
        }
    }

class ReprtObject{   
        public function DefaultConstructor($aobj_context){ 
            $this->aobj_context = $aobj_context;
            $univcode = $aobj_context->mobj_data["univcode"];
            $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);
            
            $get_coll_name = "select funivname, funivcode, funivadd2,
            funivadd1 AS 'state', pdf_logo_path, ftdvs_helplineno as telno, 
            fadmdec
            FROM control";

$lobj_get_coll_name = $this->aobj_context->pobj_db->GetRow($get_coll_name);

$aobj_context->funivname = $lobj_get_coll_name['funivname'];
            $aobj_context->s_state = $lobj_get_coll_name['state'];
            $aobj_context->add = $lobj_get_coll_name['funivadd2'];
            $aobj_context->telno = $lobj_get_coll_name['telno'];
            $aobj_context->pdf_logo_path = $lobj_get_coll_name['pdf_logo_path'];
            $aobj_context->funivcode = $lobj_get_coll_name['funivcode'];
            $aobj_context->admdec = $lobj_get_coll_name['fadmdec'];
            $this->current_date = $obj['now_date'];

$this->pdf = new MYPDF('P',PDF_UNIT, PDF_PAGE_FORMAT, true, 'ISO-8859-1', false);
            $this->pdf->setData($aobj_context);

}

public function Report($aobj_context){
            $intno = $aobj_context->mobj_data["app_no"];
            $univcode = $aobj_context->mobj_data["univcode"];
            $ftype = $aobj_context->mobj_data["ftype"];
            $femail = $_SESSION['MOBILE'];
            
            if($ftype == 'stud'){
                $query0 = "select ifnull(fappno, '')as fappno,fintno from adm_studfeesum 
                where fappno='{$intno}' and FPAYSTATUS = 'success'";
            }else{
                $query0 = "select ifnull(fappno, '')as fappno,fintno 
                from adm_studfeesum where fintno='{$intno}'";  
            }
            
            $row = $this->aobj_context->pobj_db->GetRow($query0);
            $app_nos = $row['fappno'];
            $fintno = $row['fintno'];
            if($app_nos != '')
                $app_no = $app_nos;
            else
                $app_no = $fintno;
            $que = "select ifnull(ftype,'') as ftype,ifnull(fleadid,'') as fleadid,
                    ifnull(fappno,'') as fappno from adm_lead 
                    where femail = '{$femail}' and
                    fleadid = '{$app_no}' or fappno = '{$app_no}'";
            
            $res = $aobj_context->pobj_db->GetRow($que);
            
            $appNo = '';
            if($res['ftype'] == 'Applied'){
                $cond = "adm_stud";
                $whercond = "fappno";
                $appNo = $res['fappno'];
            }else{
                $cond = "adm_lead";
                $whercond = "fleadid";
                $appNo = $res['fleadid'];
            }
            
            $query = "select a.fappno,a.fleadid, a.fname, fmobile, femail, if(fgender = 'F', 'Female', 'Male')as fgender,
                    date_format(fdob, '%d/%m/%Y')as fdob, fcatecode, fnation as nationality,
                    ffatname
                    , fmotname, freligion, faadhaarno, concat(a.fdegree, ' - ', fdescpn)as fdegree,  
                    concat(fadd1, ', ', fadd2, ', ', fadd3)as fadd,
                    s.fname as fstate, fcountry, fpincode,
                    ifnull(a.faadhaarpath,'') as faadhaarpaths,
                    ifnull(a.ftenpath,'') as ftenpaths,
                    ifnull(a.ftwthpath,'') as ftwthpaths,
                    ifnull(a.ftcpath,'') as ftcpaths,
                    ifnull(a.fmigpath,'') as fmigpaths,
                    ifnull(a.fugpath,'') as fugpaths,
                    ifnull(a.fstdpicpath, '') as fstdpicpath 
                    from $cond a inner join adm_state s on s.fid = a.fstate 
                    inner join degree d on d.fdegree = a.fdegree 
                    where $whercond ='{$appNo}' group by a.$whercond";
                    
            $per_details = $this->aobj_context->pobj_db->GetRow($query);
            
            $faadhaarpaths = $per_details['faadhaarpaths'];

if($res['ftype']  == 'Applied'){
                $cond2 = 'fappno';
            }else{
                $cond2 = 'fleadid';
            }
           
            $query1 = "select concat(a.fdegree, ' - ', d.fdescpn)as fdegree,
                     d.fexamname, a.fheadcode, a.ffee,
                    a.fpaid, a.fbal, s.forderid, s.ftranid, s.fpaydate, s.fpaytype
                    from adm_studfee a inner join degree d 
                    on d.fdegree = a.fdegree and d.fexamno = a.fexamno
                    inner join adm_studfeesum s on s.$cond2 = a.$cond2
                    where a.$cond2='{$app_no}' and fpaystatus='success' 
                    and fintno='{$fintno}'";
                    
            $pay_details = $this->aobj_context->pobj_db->GetAll($query1);
            
            if($res['ftype'] == 'Applied'){
                $aappno = $per_details['fappno'];
            }else{
                $aappno = $per_details['fleadid'];
            }

$pdf = $this->pdf;
            $pdf->AddPage("P");
            $pdf->ln(22);
            $pdf->SetFont('Times','',10);
            $html = '<h3 style="background-color: #918988; color: rgb(255, 255, 255);">I. Personal Details</h3>';
            $x = $pdf->GetX();
            $y = $pdf->GetY();		
            $pdf->writeHTMLCell(188,0,$x,$y,$html, false,1, false, true, '', false);

$photo_url = "https://qp-tran.s3.ap-south-1.amazonaws.com/";
            $table1 = '<style>td{border: 0.5px solid black;} .lable {font-weight: bold;}</style>';
            $table1 .= '<table cellpadding="3" cellspacing="0">
                        <tr nobr="true">
                            <td width="120" class="lable">Application No.</td>
                            <td width="300" colspan="3" style = "font-size:15px;">'.$aappno.'</td>
                            <td width="100" rowspan="5"><img width="100" height="100" src="'.$photo_url.$per_details['fstdpicpath'].'" /></td>
                        </tr>';
            $table1 .='<tr nobr="true">
                        <td width="120" class="lable">Name of the Applicant</td>
                        <td width="300" colspan="3">'.$per_details['fname'].'</td></tr>';
            $table1 .='<tr nobr="true">								
                        <td width="120" class="lable">Mobile No.</td>
                        <td width="300">'.$per_details['fmobile'].'</td>
                    </tr>';
            $table1 .= '<tr nobr="true">
                        <td width="120" class="lable">Email Id</td>
                        <td width="300">'.$per_details['femail'].'</td>
                        </tr>';
            $table1 .= '<tr nobr="true">
                        <td width="120" class="lable">Course</td>
                        <td width="300">'.$per_details['fdegree'].'</td>
                        </tr>';
            $table1 .='<tr nobr="true">
                        <td width="120" class="lable">Gender </td>
                        <td width="70">'.$per_details['fgender'].'</td>
                        <td width="150" class="lable">Date of Birth (DD/MM/YYYY)</td>
                        <td width="180">'.$per_details['fdob'].'</td>
                    </tr>';
            $table1 .='<tr nobr="true">								
                        <td width="120" class="lable">Nationality </td>
                        <td width="70">'.$per_details['nationality'].'</td>
                        <td width="150" class="lable">Aadhaar Number</td>
                        <td width="180">'.$per_details['faadhaarno'].'</td>
                    </tr>';
            $table1 .='<tr nobr="true">					
                        <td width="120" class="lable">Category</td>
                        <td width="70">'.$per_details['fcate'].'</td>
                        <td width="150" class="lable">Religion</td>
                        <td width="180">'.$per_details['freligion'].'</td>  
				    </tr>';
            $table1 .='<tr nobr="true">
                        <td width="120" class="lable">Father Name</td>
                        <td width="400">'.$per_details['ffatname'].'</td>
                    </tr>';
            $table1 .='<tr nobr="true">
                        <td width="120" class="lable">Mother Name</td>
                        <td width="400">'.$per_details['fmotname'].'</td>
                    </tr>';
           
            $table1 .= '</table>';
            $pdf->SetX(11);
            $pdf->writeHTML($table1, false, true, false, false, 'L');

$pdf->ln(7);
            $html = '<h3 style="background-color: #918988; color: rgb(255, 255, 255);">II. Communication Details</h3>';
            $x = $pdf->GetX();
            $y = $pdf->GetY();
            $pdf->writeHTMLCell(188,0,$x,$y,$html, false,1, false, true, '', false);

$table2 = '<style>td{border: 0.5px solid black;} .lable {font-weight: bold;}</style>';
            $table2 .= '<table cellpadding="3" cellspacing="0">
                        <tr nobr="true">
                            <td width="120" class="lable">Address</td>
                            <td width="400">'.$per_details['fadd'].'</td>
                    </tr>';
            $table2 .= '<tr nobr="true">
                            <td width="120" class="lable">State</td>
                            <td width="400">'.$per_details['fstate'].'</td>
                    </tr>';
            $table2 .= '<tr nobr="true">
                            <td width="120" class="lable">Country</td>
                            <td width="400">'.$per_details['fcountry'].'</td>
                    </tr>';
            $table2 .= '<tr nobr="true">
                            <td width="120" class="lable">Pincode</td>
                            <td width="400">'.$per_details['fpincode'].'</td>
                    </tr>';
            $table2 .= '</table>';
            $pdf->SetX(11);
            $pdf->writeHTML($table2, false, true, false, false, 'L');

if(count($pay_details) > 0){

$pdf->ln(7);
                $html = '<h3 style="background-color: #918988; color: rgb(255, 255, 255);">III. Payment Details</h3>';
                $x = $pdf->GetX();
                $y = $pdf->GetY();
                $pdf->writeHTMLCell(188,0,$x,$y,$html, false,1, false, true, '', false);
                $table3 = '<style>td{border: 0.5px solid black;} .lable {font-weight: bold; text-align:center;} .align{text-align:center;}</style>';
                $table3 .= '<table cellpadding="3" cellspacing="0">';
                $table3 .= '<tr>
                            <td class="lable" width="22%">Description</td>
                            <td class="lable" width="12%">Fee</td>
                            <td class="lable" width="12%">Paid</td>
                            <td class="lable" width="18%">Date Time</td>
                            <td class="lable" width="10%">Pay Type</td>
                            <td class="lable" width="23%">Trans. ID</td>
                            </tr>';
                foreach($pay_details as $val){
                    if($val['fheadcode'] == 'App'){
                        $discp = 'Application Fee';
                    }else if($val['fheadcode'] == 'Adm'){
                        $discp = 'Admission Fee';
                    }else{
                        $discp = $val['fheadcode'];
                    }
                    $table3 .= '<tr>
                            <td>'.$discp.'</td>
                            <td class="align" style="text-align:center">'.$val['ffee'].'</td>
                            <td class="align">'.$val['fpaid'].'</td>
                            <td class="align">'.$val['fpaydate'].'</td>
                            <td class="align">'.$val['fpaytype'].'</td>
                            <td class="align">'.$val['ftranid'].'</td>
                            </tr>';
                }
                $table3 .= '</table>';
                $pdf->SetX(11);
                $pdf->writeHTML($table3, false, true, false, false, 'L');
            }
            // && $intno == '39'
            if($univcode == 'P001' ){
                $pdf->ln(5);
                $html = '<h3 style="background-color: #918988; color: rgb(255, 255, 255);text-align:center;">FOR OFFICE USE ONLY</h3>';
                $pdf->ln(5);
                $html = '<h3 style="background-color: #918988; color: rgb(255, 255, 255);text-align:center;">Fee Details</h3>';
                $x = $pdf->GetX();
                $y = $pdf->GetY();

$pdf->writeHTMLCell(188,0,$x,$y,$html, false,1, false, true, '', false);
                $table3 = '<style>td{border: 0.5px solid black;} .lable {font-weight: bold; text-align:center;} .align{text-align:center;}</style>';
                $table3 .= '<table cellpadding="3" cellspacing="0">';
                $table3 .= '<tr>
                            <td class="lable" width="22%">Description</td>
                            <td class="lable" width="12%">1st Year</td>
                            <td class="lable" width="12%">2nd Year</td>
                            <td class="lable" width="13%">3rd Year</td>
                            <td class="lable" width="13%">4th Year</td>
                            <td class="lable" width="13%">5th Year</td>
                            <td class="lable" width="13%">6th Year</td>
                            </tr>
                            <tr>
                            <td></td>
                            <td class="align" style="text-align:center"></td>
                            <td class="align"></td>
                            <td class="align"></td>
                            <td class="align"></td>
                            <td class="align"></td>
                            <td class="align"></td>
                            </tr>
                            </table>';
                $pdf->SetX(11);
                $pdf->writeHTML($table3, false, true, false, false, 'L');
                $pdf->ln(5);
                $table3 = '<style>td{border: 0.5px solid black;} .lable {font-weight: bold; text-align:center;} .align{text-align:center;}</style>';
                $table3 .= '<table cellpadding="3" cellspacing="0">';
                $table3 .= '<tr>
                            <td class="lable" width="22%">Remarks</td>
                            <td class="lable" width="76%"></td>
                            </tr>
                            </table>';
                $pdf->SetX(11);
                $pdf->writeHTML($table3, false, true, false, false, 'L');
                $pdf->ln(5);
                $tableo = '<style>td{border: 0.5px solid black;} .lable {font-weight: bold;}</style>';
                $tableo .= '<table cellpadding="3" cellspacing="0">
                            <tr nobr="true" style="text-align:center">
                                <td width="180" class="lable">ADMITTED BY</td>
                                <td width="180" class="lable">Verified By</td>
                                <td width="180" class="lable">Admission Approver by</td>
                            </tr>';
                $tableo .='<tr nobr="true">
                            <td width="80" class="lable" >CODE.</td>
                            <td width="100" class="lable"></td>
                            <td width="180" class="lable" style="border: none;border-right:0.5px solid black;"></td>
                            <td width="180" class="lable" style="border: none;border-right:0.5px solid black;"></td></tr>';
                $tableo .= '<tr nobr="true">
                            <td width="80" class="lable">NAME</td>
                            <td width="100"></td>
                            <td width="180" class="lable" style="border: none;border-right:0.5px solid black;"></td>
                            <td width="180" class="lable" style="border: none;border-right:0.5px solid black;"></td>
                            </tr>';
                $tableo .='<tr nobr="true">								
                            <td width="80" class="lable">Mobile No.</td>
                            <td width="100"></td>
                            <td width="180" style="text-align:center;">Name Of the Verifier</td>
                            <td width="180" style="text-align:center">Name Of the Verifier</td>
                        </tr>';
                $tableo .= '</table>';
                $pdf->writeHTML($tableo, false, true, false, false, 'L');
            }
            
            
            $pdf->ln(3);
            $pdf->SetFont('Times','BU',13);
            // $pdf->Cell(180,7,'Declaration by the Candidate',0,1,'C');
        }

public function SendOutput(){
            $this->pdf->Output("Acknowledgement.pdf", "I");
        }
    }

function admFeeReport($aobj_context){
        $univcode = $aobj_context->mobj_data["univcode"];

$class_obj = new ReprtObject();
        $class_obj->DefaultConstructor($aobj_context);
        $class_obj->Report($aobj_context);
        $class_obj->SendOutput();
    }

${this.title}

Code Editor : admFeeReport.php