Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
phpmailer	[ DIR ]	drwxrwxrwx
.htaccess	602 B	-rwxr-xr-x
ApplicationReport.php	11.81 KB	-rwxrwxrwx
CreateUser.php	5.23 KB	-rwxrwxrwx
appForm.php	23.31 KB	-rwxrwxrwx
applicationFormReportPOSTOFFIC...	19.32 KB	-rwxrwxrwx
applicationStatus.php	6.84 KB	-rwxrwxrwx
applicationStatus_31012018.php	2.94 KB	-rwxrwxrwx
cManualMailer.php	1.52 KB	-rwxrwxrwx
caccesscontext.php	1.24 KB	-rwxrwxrwx
candidate_list.php	54.71 KB	-rwxrwxrwx
cappcontext.php	2.66 KB	-rwxrwxrwx
ceckFile.php	1.12 KB	-rwxrwxrwx
cmailer.php	6.83 KB	-rwxrwxrwx
code39.php	6.38 KB	-rwxrwxrwx
coutput.php	1.76 KB	-rwxrwxrwx
crequestbroker.php	2.49 KB	-rwxrwxrwx
csessions.php	514 B	-rwxrwxrwx
cuser.php	3.41 KB	-rwxrwxrwx
customappcontext.php	2.35 KB	-rwxrwxrwx
download.php	5.65 KB	-rwxrwxrwx
dropdown.php	844 B	-rwxrwxrwx
everifyMc.php	6.36 KB	-rwxrwxrwx
feehead.php	1.51 KB	-rwxrwxrwx
format.php	7.43 KB	-rwxrwxrwx
fpdf_protection.php	5.61 KB	-rwxrwxrwx
getdata.php	1.06 KB	-rwxrwxrwx
getnumword.php	7.15 KB	-rwxrwxrwx
home.html	14.48 KB	-rwxrwxrwx
json.php	33.2 KB	-rwxrwxrwx
login.php	1.88 KB	-rwxrwxrwx
mc-verify.php	6.65 KB	-rwxrwxrwx
mregistry.php	4.55 KB	-rwxrwxrwx
mregistry_31012018.php	2.65 KB	-rwxrwxrwx
report_appstatus.php	6.42 KB	-rwxrwxrwx
report_verificationlist.php	4.99 KB	-rwxrwxrwx
reportapplicationform.php	19.59 KB	-rwxrwxrwx
reportapplicationform_old.php	28 KB	-rwxrwxrwx
rotation.php	596 B	-rwxrwxrwx
sendGridMail.php	1.29 KB	-rwxrwxrwx
servfee.php	1.38 KB	-rwxrwxrwx
servicedet.php	1.6 KB	-rwxrwxrwx
stringspliter.php	693 B	-rwxrwxrwx
student.php	25.37 KB	-rwxrwxrwx
verifiedlistReport.php	7 KB	-rwxrwxrwx

Code Editor : ApplicationReport.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("ApplicationReport");

// set bacground image
        $this->SetFillColor(248, 248, 255);
        $img_path = $this->aobj_context->main_src . "/img/LOGO.jpg";

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

$this->SetFont('Times', 'B', 13);
        $this->SetY(5);
        $this->Cell(0, 4, $this->aobj_context->FUNIVNAME, 0, 1, 'C');
        //state
        $this->SetFont('Times', '', 11);
        $this->Cell(0, 4, $this->aobj_context->s_state, 0, 1, 'C');
        $this->Ln(5);
       
        
        // $this->SetFont('Times', 'B', 12);
        // $this->Cell(0, 5, 'Application List', '0', 1, 'C');
        
        // var_dump($this->doe);
       // $this->Cell(0, 6, " Degree Group: " . $this->aobj_context->mobj_data["deggrp"], "0", 1, "C");
      //  $this->Cell(0, 6, " Degree Range: " . $this->aobj_context->mobj_data["fdegfrom"] . ' - ' . $this->aobj_context->mobj_data["fdegto"], "0", 1, "C");
        // 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', FSUNIVCODE as 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 Header($pdf)
    {

$pdf->SetFont('Times', 'B', 10);
        $pdf->Cell(12, 7, "Sl.No", "LTR", 0, "C");
        $pdf->Cell(26, 7, "App. Number", "LTR", 0, "C");
        $pdf->Cell(22, 7, "App. Date", "LTR", 0, "C");
        $pdf->Cell(62, 7, "Name", "LTR", 0, "C");
        $pdf->Cell(22, 7, "DOB", "LRT", 0, "C");
        $pdf->Cell(18, 7, "Gender", "LRT", 0, "C");
        $pdf->Cell(18, 7, "Category", "LRT", 0, "C");
        $pdf->Cell(16, 7, "HK", "LRT", 1, "C");

/*$pdf->Cell(12, 7, "", "LRB", 0, "C");
        $pdf->Cell(26, 7, "", "LRB", 0, "C");
        $pdf->Cell(22, 7, "", "LRB", 0, "C");
        $pdf->Cell(60, 7, "", "LRB", 0, "C");
        $pdf->Cell(22, 7, "", "LRB", 0, "C");
        $pdf->Cell(18, 7, "", "LRB", 0, "C");
        $pdf->Cell(18, 7, "", "LRB", 0, "C");
        $pdf->Cell(21, 7, "Karnataka", "LRB", 1, "C");
        $pdf->SetFont('Times', '', 12);*/
       
    }

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

$pdf->SetMargins(07, 35);
        $pdf->startPageGroup();
        $pdf->AddPage("P");

$oldCode = "";
        $newCode = "";
        $sl_no = 1;
        $first = true;
        $j = 0;

$pdf->SetFont('Times', 'B', 10);
        $pdf->Cell(10, 7,'To,', "0", 1, "L");
        $pdf->setX(18);
        $pdf->Cell(100, 7, $data['FNAME'].',', "0", 1, "L");
        $pdf->SetFont('Times', '', 10);
        $pdf->setX(15);
        $pdf->Cell(100, 7,'   '.$data['FADDR1'].', '.$data['FADDR2'].',', "0", 1, "L");
        // $pdf->Cell(70, 7, $data['FADDR2'], "0", 1, "L");
        $pdf->setX(15);
		$pdf->Cell(70, 7, '   '.$data['FADDR3'].', '.$data['FADDR4'].',', "0", 1, "L");
        // $pdf->Cell(70, 7, $data['FADDR4'], "0", 1, "L");
        $pdf->setX(15);
        $pdf->Cell(40, 7, '   '.$data['FCITY'].'-'.$data['FPINCODE'],"0", 1, "L");
        $pdf->setX(15);
        $pdf->Cell(30, 7, '   '.$data['FSTATE'].', '.$data['FCOUNTRY'] ,"0", 1, "L");
        $pdf->setX(15);
        $pdf->Cell(25, 7, '   Mobile: '.$data['FMOBILE'], "0", 1, "L");
        // $pdf->Cell(25, 7, $data['FCOUNTRY'], "0", 1, "L");
        //$pdf->Cell(15, 7, $data['FPINCODE'], "0", 1, "L");
    //    var_dump($result3);

foreach($result3 as $key => $value)
        {
            // var_dump($value);

$filenm=$value['fpath'];
        $bucket_url = 'https://university-marks-cards.s3.ap-south-1.amazonaws.com/';
        $key =  $this->aobj_context->FUNIVCODE.'/stud_upd/'.$filenm;
        $doc_url = $bucket_url.$key;
        // var_dump($filenm);
        // var_dump($doc_url);

$im = new imagick();
        $im->setResolution(300,300);
        $im->readImage($doc_url);

$im->setImageFormat('jpeg');
        // header('Content-Type: image/jpeg');
        // echo $im;
        // var_dump($im);
        $filePath = tempnam(sys_get_temp_dir(), rand(10,15));
        $im->setImageCompression(imagick::COMPRESSION_JPEG); 
        $im->setImageCompressionQuality(100);
        $im->writeImage ($filePath);
        $im->clear();
        $im->destroy();

$pdf->SetMargins(0, 0);
        // $pdf->startPageGroup();
        $pdf->AddPage("P");

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

// $pdf->Image($filePath, 0, 0, 250, 500);

// get the current page break margin
        $bMargin = $pdf->getBreakMargin();
        // get current auto-page-break mode
        $auto_page_break = $pdf->getAutoPageBreak();
        // disable auto-page-break
        $pdf->SetAutoPageBreak(false, 0);
        // set bacground image

$pdf->Image($filePath, 0, 0, 210, 297, '', '', '', false, 300, '', false, false, 0);
 // restore auto-page-break status
 $pdf->SetAutoPageBreak($auto_page_break, $bMargin);
 // set the starting point for the page content
 $pdf->setPageMark();
 // $pdf->SetAutoPageBreak(false, 0);
 $pdf->setY(250);
 // $pdf->setY(10);
 $pdf->setX(50);
 date_default_timezone_set('Asia/Kolkata');
 $html = '<div style="background-color:#fff; rotation: 45deg; border: 1.5px solid green;border-radius: 3px;padding: 5px;color:#000080;text-align:center;font-weight:bold;font-size:10px;">
 <img src="http://oasis.logisys.org/kus/img/logoh.jpg" width="132" />
 This document is &nbsp;electronically verified and found GENUINE 
 
 &nbsp;&nbsp;&nbsp;
 <img src="http://oasis.logisys.org/kus/img/controler_sign.jpg" width="40" />
 
 &nbsp;&nbsp;&nbsp; Reg.(Eval) 
 
 Verified On: '.$data['fverifydate'].'
 </div>';
 $pdf->StartTransform();
 $pdf->Rotate(20);
	 $pdf->writeHTMLCell($w=50, $h=40, $x = 35, $y= 235, $html, $border=0, $ln=0, $fill=0, $reseth=true, $align='', $autopadding=false);
 // $pdf->Rotate(30);
 // $pdf->writeHTMLCell($w=50, $h=40, $x = 120, $y= 100, $html, $border=0, $ln=0, $fill=0, $reseth=true, $align='', $autopadding=false);
 // $pdf->writeHTML($html, true, false, true, false, '');
 $pdf->StopTransform();
 }
 }

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

}

/*function moneyFormatIndia($num)
{
 $explrestunits = "";
 if (strlen($num) > 3) {
 $lastthree = substr($num, strlen($num) - 3, strlen($num));
 $restunits = substr($num, 0, strlen($num) - 3); // extracts the last three digits
 $restunits = (strlen($restunits) % 2 == 1) ? "0" . $restunits : $restunits; // explodes the remaining digits in 2's formats, adds a zero in the beginning to maintain the 2's grouping.
 $expunit = str_split($restunits, 2);
 for ($i = 0; $i < sizeof($expunit); $i++) {
 // creates each of the 2's group and adds a comma to the end
 if ($i == 0) {
 $explrestunits .= (int) $expunit[$i] . ","; // if is first value , convert into integer
 } else {
 $explrestunits .= $expunit[$i] . ",";
 }
 }
 $thecash = $explrestunits . $lastthree;
 } else {
 $thecash = $num;
 }
 return $thecash; // writes the final format where $currency is the currency symbol.
}
*/
function ApplicationReport($aobj_context)
{

$appno = $aobj_context->mobj_data["appno"];
    $query1 = " SELECT 
        IFNULL(FNAME,'') AS FNAME,
        IFNULL(FADDR1,'') AS FADDR1,
        IFNULL(FADDR2,'') AS FADDR2,
        IFNULL(FADDR3,'') AS FADDR3,
        IFNULL(FADDR4,'') AS FADDR4,
        IFNULL(FCITY,'') AS FCITY,
        IFNULL(FSTATE,'') AS FSTATE,
        IFNULL(FCOUNTRY,'') AS FCOUNTRY,
        IFNULL(FPINCODE,'') AS FPINCODE,
        IFNULL(FMOBILE,'') AS FMOBILE,
        ifnull(date_format(fverifydate,'%d/%m/%Y'),'') as fverifydate
        FROM servtran
        WHERE fverifystatus='verified' AND fappno ='{$appno}'";
    $result = $aobj_context->mobj_db->GetRow($query1);
    // var_dump($result);

// $query2 = "SELECT fpath FROM servdoc WHERE fappno='{$appno}' 
 // AND fverifystatus='verified' AND fsem <> 'Degree Certificate'
 // ORDER BY fsem";
 // $result2 = $aobj_context->mobj_db->GetRow($query2);

$query3 = "SELECT * FROM servdoc WHERE fappno = '{$appno}' 
	ORDER BY LENGTH(fsem),fsem";
    $result3 = $aobj_context->mobj_db->GetAll($query3);

$upd = "select date_format(ifnull(fverifydate,now()),'%d/%m/%Y') as fvdate 
	from servtran where fappno = '{$appno}'";
	$result4 = $aobj_context->mobj_db->GetRow($upd);
	
	$aobj_context->vdate = $result4['fvdate'];
    
    $class_obj = new ReprtObject();
    $class_obj->univcode = $univcode;
    $class_obj->DefaultConstructor($aobj_context);

// If No data found Generate Blank Report
    if (count($result) > 0) {
        $class_obj->Report($result,$result3);
    }

$class_obj->SendOutput();

}
?>

${this.title}

Code Editor : ApplicationReport.php