Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
.pgetadm.php	3.61 KB	-rw-r--r--
PrintAdmissionOrderstudent.php	9.83 KB	-rwxrwxrwx
Seat_Allotment_Details.php	11.36 KB	-rw-r--r--
add-course.php	5.63 KB	-rwxrwxrwx
admfee.php	9.25 KB	-rw-rw-r--
admissionorderPGReport.php	15.91 KB	-rwxrwxrwx
admissionordertest.php	356 B	-rwxrwxrwx
admorder_bnu.php	14.93 KB	-rw-r--r--
app-status.php	2.39 KB	-rwxrwxrwx
applicationFormPGReport.php	43.11 KB	-rwxrwxrwx
bcuapplicationFormPGReport.php	35.13 KB	-rwxrwxrwx
bnuapplicationFormPGReport.php	35.47 KB	-rwxrwxrwx
category.php	2.52 KB	-rwxrwxrwx
data.json	1.98 KB	-rwxrwxrwx
degree.php	12.38 KB	-rwxrwxrwx
feestr.php	5.92 KB	-rwxrwxrwx
forgot-password.php	2.77 KB	-rw-rw-r--
forgot-password_old.php	2.31 KB	-rwxrwxrwx
getSavedData.php	8.49 KB	-rwxrwxrwx
getSavedData_old_12102019.php	5 KB	-rwxrwxrwx
hallticket.php	7.61 KB	-rwxrwxrwx
login.php	947 B	-rwxrwxrwx
logout.php	44 B	-rwxrwxrwx
option-entry.php	4.34 KB	-rwxrwxrwx
option-entryPrint.php	9.29 KB	-rwxrwxrwx
printadmissionorder.php	616 B	-rwxrwxrwx
reprint.php	707 B	-rwxrwxrwx
resetpassword.php	700 B	-rwxrwxrwx
saveApplication.php	25.7 KB	-rwxrwxrwx
saveApplication051120.php	23.67 KB	-rwxrwxrwx
saveApplication_old_12102019.p...	14.67 KB	-rwxrwxrwx
seat-allot.php	1008 B	-rwxrwxrwx
sendGridMail.php	1.28 KB	-rwxrwxrwx
sendMobEmailOTP.php	1.41 KB	-rwxrwxrwx
sendsmsapi.php	760 B	-rwxrwxrwx
signin.php	996 B	-rwxrwxrwx
signup.php	1.01 KB	-rwxrwxrwx
validateRegno.php	1.94 KB	-rwxrwxrwx
vkuapplicationFormPGReport cop...	36.61 KB	-rwxrwxrwx
vkuapplicationFormPGReport.php	37.97 KB	-rwxrwxrwx

Code Editor : admorder_bnu.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;
// ini_set('memory_limit','900M');
// ini_set('max_execution_time',0);

class MYPDF extends TCPDF
{
    public function Header()
    {
        // get the current page break margin
        $bMargin = $this->getBreakMargin();
        // get current auto-page-break mode
        $auto_page_break = $this->AutoPageBreak;
        // disable auto-page-break
        $this->SetAutoPageBreak(false, 0);
        $this->SetTitle("SEAT ALLOTMENT LETTER");
        $appno = $this->aobj_context->mobj_data["fappno"];
        // set bacground image
        $this->SetFillColor(248, 248, 255);
        $img_path = $this->aobj_context->main_src . "/img/bnu_logo.jpg";

// if (file_exists($img_path)) {
        //     $this->Image($img_path, 6, 6, 20, 20);
        // }

$this->SetFont('Times', 'B', 18);
        $this->SetY(5);
        $this->Image($img_path, 10,5,25);
        $this->Cell(0, 4, $this->aobj_context->FUNIVNAME, 0, 1, 'C');
        //state
        // $this->ln(10);

$this->SetFont('Times', '', 11);
        $this->Cell(0, 4, $this->aobj_context->s_state, 0, 1, 'C');

$this->SetFont('Times', 'BU', 14);
        $this->Cell(0, 5, 'PG Admission 2021-22', '0', 1, 'C');
        $this->SetFont('Times', 'B', 16);
        $this->ln(5);
        $this->Cell(0, 5, 'PROVISIONAL SEAT ALLOTMENT LETTER', '0', 1, 'C');
        $this->SetFont('Times', 'BU', 14);
        $this->Cell(0, 5, $this->aobj_context->copy, '0', 1, 'C');
        $style = array(
            'position' => 'right',
            'align' => 'C',
            'stretch' => false,
            'fitwidth' => true,
            'cellfitalign' => '',
            'border' => false,
            'hpadding' => 'auto',
            'vpadding' => 'auto',
            'fgcolor' => array(0,0,0),
            'bgcolor' => false, //array(255,255,255),
            'text' => true,
            'font' => 'helvetica',
            'fontsize' => 8,
            'stretchtext' => 4
        );

$url = "https://universitysolutions.in/pgadm2020/app.php?db=bnu&a=admorder_bnu&fappno=".$appno;
        $this->write2DBarcode("{$url}", 'QRCODE,L', 175, 5, 25, 25, $style, 'N');
        // restore auto-page-break status
        $this->SetAutoPageBreak($auto_page_break, $bMargin);
        // set the starting point for the page content
    }

public function Footer()
    {
        $this->SetY(-15);
        $this->SetFont('helvetica', 'I', 8);
        // var_dump();
        if($this->CurOrientation == 'P')
        {
            $this->Cell(60, 10, 'IP : ' . $_SERVER["REMOTE_ADDR"], 0, 0, 'L');
            $this->Cell(60, 10, 'Date : ' . date("d-m-Y h:i:s A"), 0, 0, 'C');
            $this->Cell(60, 10, 'Page ' . $this->getPageNumGroupAlias() . '/' . $this->getPageGroupAlias(), 0, 1, 'R');
        }
        else {
            $this->Cell(90, 10, 'IP : ' . $_SERVER["REMOTE_ADDR"], 0, 0, 'L');
            $this->Cell(90, 10, 'Date : ' . date("d-m-Y h:i:s A"), 0, 0, 'C');
            $this->Cell(90, 10, 'Page ' . $this->getPageNumGroupAlias() . '/' . $this->getPageGroupAlias(), 0, 1, 'R');
        }
    }
}

class ReprtObject
{

public function DefaultConstructor($aobj_context)
    {
        $this->aobj_context = $aobj_context;
        $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);

$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);
        $this->reportType = $aobj_context->mobj_data["rtype"];

$get_coll_name = "select FUNIVNAME as 'FUNIVNAME',FUNIVCODE,
		FUNIVADD1 as 'state', pdf_logo_path,
		ifnull(FEXAMAPPREQ,'F') as FEXAMAPPREQ From control";
        $lobj_get_coll_name = $this->aobj_context->mobj_db->GetRow($get_coll_name);
// var_dump($get_coll_name);
        $aobj_context->FUNIVNAME = $lobj_get_coll_name['FUNIVNAME'];
        $aobj_context->s_state = $lobj_get_coll_name['state'];
        $aobj_context->pdf_logo_path = $lobj_get_coll_name['pdf_logo_path'];
        $aobj_context->FUNIVCODE = $lobj_get_coll_name['FUNIVCODE'];

$this->current_date = $obj['now_date'];
        $deggrp = $this->aobj_context->mobj_data["deggrp"];

$get_coll_name = "select concat(fdeggrp, ' - ', fdescpn) as fdeggrp 
        from deggrp where fdeggrp = '{$deggrp}'";
        $lobj_get_degree = $this->aobj_context->mobj_db->GetRow($get_coll_name);
        
        $aobj_context->deggrp = $lobj_get_degree['fdeggrp'];
        $this->pdf = new MYPDF('P');
        $this->pdf->aobj_context = $aobj_context;
    }

public function Report($data,$admfee)
    {
        $pdf = $this->pdf;

$pdf->SetMargins(15, 45);
 $pdf->startPageGroup();
 $pdf->AddPage("P");
 
 $img_path = $this->aobj_context->main_src . "/img/bnu_logo1.jpg";
 //$pdf->Cell(0,2,$copy[$i],0,1,'C');
 $pdf->SetFont('Times','B',13);
 $pdf->Cell(37,7,'Admission No.: ',0,0,'L');
 $pdf->SetFont('Times', '', 13);
 $pdf->Cell(80,7,$data['fallotno'],0,0,'L');
 
 $pdf->SetFont('Times','B',13);
 $pdf->Cell(15,7,'Date: ',0,0,'L');
 $pdf->SetFont('Times', '', 13);
 $pdf->Cell(30,7,$data['fcurdate'],0,1,'L');
 if($data['fphotopath'] != '')
 {
 $pdf->SetFont('Times','B',13);
 $photo_url = "https://admission-certificates.s3.ap-south-1.amazonaws.com";
 $image = file_get_contents($photo_url.'/'.$data['fphotopath']);
 $pdf->Image('@'.$image,175,35,20,0,0);
 }
 // $table1 = '
 // <table cellpadding="3" cellspacing="0">
 // 	<tr nobr="true">
 // <td width="150" class="lable"></td>
 // 		<td width="270" colspan="3" style = "font-size:15px;"></td>
 // 		<td width="80"><img width="80" height="80" src="'.$photo_url.'/'.$data['fphotopath'].'" /></td>
 // </tr>';

// $table1 .= '</table>';

// $pdf->writeHTML($table1, false, true, false, false, 'L');
            
            //$pdf->SetX(-50);

$pdf->Cell(38,7,'Application No.: ',0,0,'L');
            $pdf->SetFont('Times', '', 13);
            $pdf->Cell(80,7,$data['fappno'],0,0,'L');

$pdf->SetFont('Times','B',13);
            $pdf->Cell(15,7,'Rank: ',0,0,'L');
            $pdf->SetFont('Times', '', 13);
            $pdf->Cell(30,7,$data['frank1'],0,1,'L');
            
            $pdf->SetFont('Times','B',13);
            $pdf->Cell(38,7,'Category: ',0,0,'L');
            $pdf->SetFont('Times', '', 13);
            $pdf->Cell(60,7,$data['fcatcode'],0,0,'L');

$pdf->SetFont('Times','B',13);
            $pdf->Cell(35,7,'Supernumerary: ',0,0,'L');
            $pdf->SetFont('Times', '', 13);
            $pdf->Cell(30,7,$data['fspcat'],0,1,'L');
            
            // $pdf->SetFont('Times','B',13);
            // $pdf->Cell(15,7,'Rank: ',0,0,'L');
            // $pdf->SetFont('Times', '', 13);
            // $pdf->Cell(30,7,$data['frank'],0,1,'L');

$cnd = "";

// if($data['fpamount'] == '0')
            //     $cnd = "(Freeship Card)";

$pdf->Ln(15);
 $html = "This is to confirm that {$data['fname']} is admitted 
 to {$data['fdescpn']} under 
 {$data['quname']} Quota in 
 {$data['fcollname']} on {$data['fpaymentdate']} . 
 Admission Fees paid Rs. {$data['famount']}/- (Payment Reference no: {$data['fpaymentid']}){$cnd}. 
 The candidate is directed to report to {$data['fcollname']} 
 on or before {$data['fadmdate']} before 5:00 PM .";
 $x = $pdf->GetX();
 $y = $pdf->GetY();
 $pdf->writeHTMLCell(180,0,$x,$y,$html, false,1, false, true, '', false);
 
 if($data['fcollcode'] == '1070'){
 $html = '(Note: If a candidate fails to report to the above Department within the prescribed date and time, this admission stands cancelled.)';
 }else{
 $html = '(Note: If a candidate fails to report to the above College within the prescribed date and time, this admission stands cancelled.)';
 }

$pdf->Ln(7);
            $x = $pdf->GetX();
            $y = $pdf->GetY();
            $pdf->writeHTMLCell(180,0,$x,$y,$html, false,1, false, true, '', false);

$pdf->Ln(20); 
            $pdf->SetFont('Times','B',13);
            
            $pdf->Cell(50,7,'Signature of Candidate',0,0,'L');
            // $pdf->Ln(12); 
            // $pdf->SetFont('Times','B',13);
            $reg_sign_path = $this->aobj_context->main_src . "/img/042_regstrar_sign.jpg";
            $y = $pdf->GetY();
            $x = $pdf->GetX();
            if (file_exists($reg_sign_path)) {
                $pdf->Image($reg_sign_path, $x+55, $y-23, 60, 25);
            }
            
            $pdf->Cell(120,7,'Admission Committee Chairman',0,1,'R');
            $pdf->Cell(155,7,'Registrar, BNU',0,1,'R');

$pdf->Ln(8); 
            if($this->aobj_context->copy == 'College Copy')
            {
                $pdf->SetLineStyle(array('width' => 0.5, 'cap' => 'butt', 'join' => 'miter', 'dash' => 4, 'color' => "black"));
                $pdf->Cell(0,7,'',"T",1,'C');

$pdf->Cell(180,7,'Acknowledgement',0,1,'C');

$pdf->SetFont('Times', '', 13);

$pdf->SetFont('Times','B',13);
                $pdf->Cell(37,7,'Admission No.',0,0,'L');
                $pdf->SetFont('Times', '', 13);
                $pdf->Cell(100,7,": ".$data['fallotno'],0,0,'L');
                
                $pdf->SetFont('Times','B',13);
                $pdf->Cell(15,7,'Date',0,0,'L');
                $pdf->SetFont('Times', '', 13);
                $pdf->Cell(30,7,": ".$data['fcurdate'],0,1,'L');
                $pdf->SetFont('Times','B',13);

$pdf->Cell(38,7,'Application No.',0,0,'L');
                $pdf->SetFont('Times', '', 13);
                $pdf->Cell(100,7,": ".$data['fappno'],0,0,'L');

$pdf->SetFont('Times','B',13);
                $pdf->Cell(15,7,'Rank',0,0,'L');
                $pdf->SetFont('Times', '', 13);
                $pdf->Cell(30,7,": ".$data['frank1'],0,1,'L');
                
                $pdf->SetFont('Times','B',13);
                $pdf->Cell(38,7,'Category',0,0,'L');
                $pdf->SetFont('Times', '', 13);
                $pdf->Cell(80,7,": ".$data['fcatcode'],0,0,'L');

$pdf->SetFont('Times','B',13);
 $pdf->Cell(35,7,'Supernumerary',0,0,'L');
 $pdf->SetFont('Times', '', 13);
 $pdf->Cell(30,7,": ".$data['fspcat'],0,1,'L');
 
 if($data['fcollcode'] == '1070'){
 $html = "This is to confirm that {$data['fname']} (Application No.: {$data['fappno']}) has reported to the Department";
 }else{
 $html = "This is to confirm that {$data['fname']} (Application No.: {$data['fappno']}) has reported to the College / Department";
 }

if($data['fcollcode'] == '1070'){
                    $sign = "Chairman of the Department";
                }else{
                    $sign = "Signature of Principal";
                }

$pdf->Ln(15);
                $x = $pdf->GetX();
                $y = $pdf->GetY();
                $pdf->writeHTMLCell(180,0,$x,$y,$html, false,1, false, true, '', false);
                $pdf->SetFont('Times','B',13);
                $pdf->Ln(20); 
                $pdf->Cell(180,7,$sign,0,1,'R');
            }
            $pdf->SetAlpha(0.1);
            
            $pdf->Image($img_path, 50, 50, 125, 125, '', '', '', false, 100);
            $pdf->SetAlpha();
        
    }

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

function admorder_bnu($aobj_context)
{

$appno = $aobj_context->mobj_data["fappno"];
    $mob =  $_SESSION['MOBILE'];
    // 
    //
    $query = "SELECT ifnull(b.fphotopath,'') as fphotopath, a.fappno, b.fname, a.fallotno, a.frank, a.fdegree,a.fpamount as famount, DATE_FORMAT(DATE_ADD(left(fpaymentdate,10), INTERVAL 2 DAY),'%d/%m/%Y') AS fadmdate,
     d.fdescpn, a.fcollcode, c.fcollname, a.fcatcode, DATE_FORMAT(a.fpaymentdate,'%d/%m/%Y') AS fpaymentdate, DATE_FORMAT(a.fallotdate,'%d/%m/%Y') AS fallotdate, 
     DATE_FORMAT(NOW(),'%d/%m/%Y') AS fcurdate,
     if(ifnull(m.FDESCPN,'') = '',fcatcode,m.FDESCPN) as quname, s.frank1,s.fspcat,a.fpaymentid
    FROM entseatallot a INNER JOIN entstudadm b ON a.fappno = b.fappno INNER JOIN entcoll c ON a.fcollcode = c.fcollcode INNER JOIN entdeg d ON a.fdegree = d.fdegree 
    inner join entcandlist_new s on a.fappno = s.fappno and s.fallotcoll = a.fcollcode
    and s.fdegree = a.fdegree and s.fround = '4'
    left join entmascat m on m.FCATEGORY = s.fallotcatcode 
    where (a.fappno = '{$appno}' or a.fallotno = '{$appno}') AND IFNULL(a.fpaymentstatus,'') = 'success'";

$result = $aobj_context->mobj_db->GetRow($query);

$fappno = $result['fappno'];
    $admfee = $result['fadmfee'];
    
    $query = "select * from entseatallot 
    where fappno = '{$fappno}'
    and ifnull(fpaymentstatus,'') = ''";

$res = $aobj_context->mobj_db->GetRow($query);
    $prevfee = 0;
  
    $class_obj = new ReprtObject();
    $class_obj->univcode = $univcode;
    $class_obj->DefaultConstructor($aobj_context);

// If No data found Generate Blank Report
 $copy = ["College Copy", "University Copy","Student Copy"];
 for ($i=0;$i < 3; $i++) { 
 $aobj_context->copy = $copy[$i];
 if (count($result) > 0) {
 $class_obj->Report($result,$admfee);
 }
 }
 
 $class_obj->SendOutput();

}

${this.title}

Code Editor : admorder_bnu.php