Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
New folder	[ DIR ]	drwxrwxr-x
caccesscontext.php	1.24 KB	-rwxr-xr-x
cappcontext.php	2.66 KB	-rwxr-xr-x
coutput.php	1.76 KB	-rwxr-xr-x
crequestbroker.php	2.49 KB	-rwxr-xr-x
csessions.php	514 B	-rwxr-xr-x
cuser.php	3.41 KB	-rwxr-xr-x
customappcontext.php	2.35 KB	-rwxr-xr-x
getnumword.php	7.45 KB	-rwxr-xr-x
json.php	33.2 KB	-rwxr-xr-x
kusphdadm.php	1.67 KB	-rwxr-xr-x
mregistry.php	3.22 KB	-rwxr-xr-x
savenexttada.php	9.13 KB	-rw-r--r--
studResume.php	1.16 KB	-rwxr-xr-x
tadabillReport.php	18.79 KB	-rw-r--r--

Code Editor : tadabillReport.php

<?php
ob_start();
$main_src=substr($_SERVER['SCRIPT_FILENAME'],0,strlen($_SERVER['SCRIPT_FILENAME'])-7);
ini_set('memory_limit','900M');
ini_set('max_execution_time',0);
include('/var/www/html/univadmin/tcpdf/tcpdf.php');
include('getnumword.php');

class MYPDF extends TCPDF {
    public $aobj_context;
     
    public function setData($aobj_context){
    	$this->aobj_context = $aobj_context;
    }
    public function Header($aobj) {
        // 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);
        // set bacground image

$this->SetMargins(10,34,20,true);	
		$this->SetFillColor(248, 248 ,255);		
		// $img_path = "/var/www/oasis/gcg/img/logo.jpg";
		// var_dump($img_path);
		if(file_exists($img_path)) 
			$this->Image($img_path,60,6,110,15);

$img_path1 = "/var/www/oasis/gcg/img/logo.jpg";
        // var_dump($img_path1);
        if (file_exists($img_path1)) {
            $this->Image($img_path1, 10, 3, 20, 20);
        }
				//$this->SetY(10);
		$this->Ln(10);
		$this->SetFont('Times','B',14);
		$this->Cell(0,2,$this->aobj_context->FUNIVNAME,0,1,'C');	
		//state
		$this->SetFont('Times','B',11);
		$this->Cell(0,0,$this->aobj_context->s_state,0,1,'C');
        $this->ln(2);

$this->SetFont('Times','BU',13);
		$this->Cell(0,0,'Bill No. : '.$this->aobj_context->billno,0,1,'R');
				 
		
    }

public function Footer() 
    {
        $this->SetY(-15);
        $this->SetFont('helvetica', 'I', 8);
        $this->Cell(50, 10,'IP : '.$_SERVER["REMOTE_ADDR"], 0, 0, 'L');
        $this->Cell(100, 10,'Date : ' .$this->aobj_context->current_date, 0, 0, 'C');

$this->Cell(50, 10,'Page ' .$this->getPageNumGroupAlias().'/'.$this->getPageGroupAlias(), 0, 1, 'R');
    }
}

class AddmissionApplication
{	
	function DefaultConstructor($aobj_context)
	{
		$this->aobj_context=$aobj_context;
		//$this->pdf=  new FPDF();
		$this->collcode=$_SESSION['collcode'];
		$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 as 'FUNIVNAME',FUNIVCODE,
		FUNIVADD1 as 'state', concat(FUNIVCODE,'_',pdf_logo_path) as 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($lobj_get_coll_name['FUNIVNAME']);
		$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->FEXAMAPPREQ=$lobj_get_coll_name['FEXAMAPPREQ'];
		$aobj_context->FUNIVCODE=$lobj_get_coll_name['FUNIVCODE'];

$app_no = trim($aobj_context->mobj_data["appno"]);

$aobj_context->appno = $app_no;
		$aobj_context->current_date = $obj['now_date'];
		$this->current_date = $obj['now_date'];

$this->pdf= new MYPDF('P');
		$this->pdf->setData($aobj_context);
		
	}
 
	function formcolldata()
	{
		$get_coll_name="select FUNIVNAME as 'FUNIVNAME',FUNIVCODE,
		FUNIVADD1 as 'state', concat(FUNIVCODE,'_',pdf_logo_path) as pdf_logo_path,
		ifnull(FEXAMAPPREQ,'F') as FEXAMAPPREQ From control";
		$lobj_get_coll_name=$this->aobj_context->mobj_db->GetRow($get_coll_name);
		$this->FUNIVNAME=$lobj_get_coll_name['FUNIVNAME'];
		$this->s_state=$lobj_get_coll_name['state'];
		$this->pdf_logo_path=$lobj_get_coll_name['pdf_logo_path'];
		$this->FEXAMAPPREQ=$lobj_get_coll_name['FEXAMAPPREQ'];
		$this->FUNIVCODE=$lobj_get_coll_name['FUNIVCODE']; 
	}
	
		
	function writeApplication($db,$per_details, $fee_det,$res_optopns,$degree, $res_prevmarks,$res_lanmarks,$res_totmarks,$fdob,$resopt,$resopt1)
	{

$pdf=$this->pdf;
		$pdf->SetMargins(10,35,25,10);
		$pdf->startPageGroup();
		$pdf->AddPage("P");

$nat = $resopt1['fnatwrk'];

// $pdf->Cell(0,4,,0,1,'');
        // $pdf->ln(2);
		$pdf->SetFont('Times','',10);
		$html = '<h3 style="background-color: #918988; text-align: center; color: rgb(255, 255, 255);"> T.A. / D.A. / C.A. / HONORARIUM BILL FORM</h3>';
		$x = $pdf->GetX();
		$y = $pdf->GetY();		
		$pdf->writeHTMLCell(188,0,$x,$y,$html, false,1, false, true, '', false);

// $pdf->ln(2);
		$pdf->SetFont('Times','BU   ',12);
		$pdf->Cell(180,0,'Nature of Work :  '.$nat,0,1,'C');
        $pdf->ln(2);
		$pdf->SetFont('Times','',10);

$path = realpath(__DIR__ .'/..');
		$photo_url = "https://admission-certificates.s3.ap-south-1.amazonaws.com";
		$i= 1;
		$table1 = '<style>
			td {
			    border: 0.5px solid black;
			}
			.lable {
				font-weight: bold;
			}
		 </style>
		<table cellpadding="3" cellspacing="0">
			<tr nobr="true">
				<td width="150" class="lable">Name</td>
				<td width="370" colspan="3">'.$resopt['fteachname'].'</td>
				
		</tr>';

$table1 .='<tr nobr="true">
				<td width="150" class="lable">Designation </td>
				<td width="370" colspan="3">'.$resopt['fdegndesc'].'</td>
				</tr>';

$table1 .='<tr nobr="true">
        <td width="150" class="lable">Aadhar No. </td>
        <td width="105" colspan="3">'.$resopt['faadhar'].'</td>
        <td width="80" class="lable">Order id</td>
        <td width="185" colspan="3">'.$resopt1['forderid'].'</td>
        </tr>';

$table1 .='<tr nobr="true">								
				<td width="150" class="lable">Mobile</td>
				<td width="105" colspan="3">'.$resopt['fmobile'].'</td>
                <td width="80" class="lable">Email</td>
				<td width="185" colspan="3">'.$resopt['femail'].'</td>
				</tr>';

$table1 .='<tr nobr="true">								
        <td width="150" class="lable">Purpose of Visit / Claim </td>
        <td width="105" colspan="3" class="lable">'.$resopt1['fnatwrk'].'</td>
        <td width="80" class="lable">City</td>
				<td width="185" colspan="3">'.$resopt['fcity'].'</td>

</tr>';

$table1 .='<tr nobr="true">
				<td width="150" class="lable">PAN No.</td>
				<td width="370" class="lable">'.$resopt['fpanno'].'</td>
				</tr>';

$table1 .='<tr nobr="true">
        <td width="150" class="lable">Bank Account No. (for ECS Payment)</td>
        <td width="370">'.$resopt['faccno'].'</td>
        </tr>';

$table1 .='<tr nobr="true">
		
        <td width="150" class="lable">Name of your College / University </td>
        <td width="370" colspan="3">'.$resopt['fcollunivname'].'</td>

</tr>';

$table1 .='<tr nobr="true">
        <td width="150" class="lable">Teacher type</td>
        <td width="105" colspan="3">'.$resopt['ftechtype'].'</td>
        <td width="80" class="lable">IFSC </td>
        <td width="185" colspan="3">'.$resopt['fifsccode'].'</td>
        </tr>';	
		$table1 .= '</table>';
		$pdf->SetX(11);		
		$pdf->writeHTML($table1, false, true, false, false, 'L');
		$pdf->ln(5);
		$html = '<h3 style="background-color: #918988; color: rgb(255, 255, 255);"> HONORARIUM / DAILY ALLOWANCE</h3>';
		$x = $pdf->GetX();
		$y = $pdf->GetY();
		$pdf->writeHTMLCell(188,0,$x,$y,$html, false,1, false, true, '', false);

if($resopt1['fnatwrk'] == 'Paper Setting'){
            $table2 = '<style>
			td {
			    border: 0.5px solid black;
			}
			.lable {
				
			}
		 </style>
		<table cellpadding="3" cellspacing="0">
		<tr nobr="true">
				<center><td width="120" style="font-weight: bold; text-align: center;" class="lable">Particulars</td></center>
                <center><td width="106" style="font-weight: bold; text-align: center;" class="lable">No. Paper set</td></center>
                <center><td width="90" style="font-weight: bold; text-align: center;" class="lable">Remuneration<br>(No. of paper * 800)</td></center>
                <center><td width="90" style="font-weight: bold; text-align: center;" class="lable">Postage Charge</td></center>
                <center><td width="115" style="font-weight: bold; text-align: center;" class="lable">Total<br>(remuneration+postagecharge) (Rs)</td></center>
		</tr>';
            $table2 .= '<tr nobr="true">
            <td width="120" style="" class="lable">'.$resopt1['fnatwrk'].'</td>
            <td width="106" style="text-align: center;" class="lable">'.$resopt1['fnoqust'].'</td>
            <td width="90" style="text-align: center;" class="lable">'.$resopt1['ftotqust'].'</td>
            <td width="90" style="text-align: center;" class="lable">'.$resopt1['fpostchrg'].'</td>
            <td width="115" style="text-align: center;" class="lable">'.moneyFormatIndia($resopt1['ftotal']).'</td>         
            </tr>';

$table2 .= '<tr nobr="true">
        <td colspan="4" style="text-align: center; font-weight: bold;" class="lable">Total</td>
        <td width="115" style="text-align: right; font-weight: bold;" class="lable">'.moneyFormatIndia($resopt1['ftotal']).'</td>
        </tr>';

$table2 .= '</table>';

}else{
			$table2 = '<style>
			td {
			    border: 0.5px solid black;
			}
			.lable {
				
			}
		 </style>
		<table cellpadding="3" cellspacing="0">
		<tr nobr="true">
				<center><td width="120" style="font-weight: bold; text-align: center;" class="lable">Particulars</td></center>
                <center><td width="106" style="font-weight: bold; text-align: center;" class="lable">Duration</td></center>
                <center><td width="45" style="font-weight: bold; text-align: center;" class="lable">No. of days</td></center>
                <center><td width="55" style="font-weight: bold; text-align: center;" class="lable">Total Allowance (Rs)</td></center>
                <center><td width="45" style="font-weight: bold; text-align: center;" class="lable">Distance Travelled (km)</td></center>
                <center><td width="39" style="font-weight: bold; text-align: center;" class="lable">T.A. (3Rs/km) > 14km</td></center>
                <center><td width="115" style="font-weight: bold; text-align: center;" class="lable">Total (Rs)</td></center>
		</tr>';

if($resopt1['fnatwrk'] == "Examiner (Practical Exams)"){
            $tab= '<td width="115" style="text-align: right;" class="lable">'.moneyFormatIndia($resopt1['ftotdaily']).'<br> ('.$resopt1['fnostud'].'*'."15/Student".')  '.moneyFormatIndia($resopt1['ftotnostud']).'<br>('.$resopt1['fnobatch'].'*'."50/Batch".')  '.moneyFormatIndia($resopt1['ftotfnobatch']).' </td>';
        }else if($resopt1['fnatwrk'] == 'Invigilation Duty'){
            $tab= '<td width="115" style="text-align: right;" class="lable">'.moneyFormatIndia($resopt1['ftotdaily']).'<br>'.moneyFormatIndia($resopt1['ftotfnosession']).' ('.$resopt1['fnosession'].'*'."150/Session".')</td>';
        }else{
            $tab= '<td width="115" style="text-align: right;" class="lable">'.moneyFormatIndia($resopt1['ftotdaily']).'</td>';
        }

$table2 .= '<tr nobr="true">
            <td width="120" style="" class="lable">'.$resopt1['fnatwrk'].'</td>
            <td width="53" style="text-align: center;" class="lable">'.$resopt1['fclaimfrm'].'</td>
            <td width="53" style="text-align: center;" class="lable">'.$resopt1['fclaimto'].'</td>
            <td width="45" style="text-align: center;" class="lable">'.$resopt1['fdayallow'].'</td>
            <td width="55" style="text-align: center;" class="lable">'.moneyFormatIndia($resopt1['ftotdaily']).'</td>
            <td width="45" style="text-align: center;" class="lable">'.$resopt1['fdist'].'</td>
            <td width="39" style="text-align: center;" class="lable">'.moneyFormatIndia($resopt1['ftravel']).'</td>
            '.$tab.'           
            </tr>';

$table2 .= '<tr nobr="true">
        <td colspan="7" style="text-align: center; font-weight: bold;" class="lable">Total</td>
        <td width="115" style="text-align: right; font-weight: bold;" class="lable">'.moneyFormatIndia($resopt1['ftotal']).'</td>
        </tr>';

$table2 .= '</table>';

}
		$pdf->SetX(11);
		$pdf->writeHTML($table2, false, true, false, false, 'L');
		// $pdf->ln(2);
        // $pdf->ln(8);

$totamtwrds =  $resopt1['ftotal'];
        $totamtinwords = getNumber($totamtwrds);

// var_dump($totamtinwords);
        $pdf->ln(2);
        $pdf->SetFont('Times','',11);
        $pdf->Cell(30, 5,'Amount in Words: ',0, 0, 'L');
        $pdf->SetFont('Times','BU',11);
        $pdf->Cell(0, 5,trim($totamtinwords),0, 1, 'L');
        $pdf->ln(2);
        $pdf->SetFont('Times','',10);

$str = "Certified that :
I)   Particulars provided herewith are correct & I have not claimed TA/DA/CA for this journey/purpose from any other source.
II)  I was not provided lodging and / or Boarding at the cost of Govt. College (Autonomous), Kalaburagi.
III) I have travelled by shortest route.

The above Meeting / Journey claim is verified to be true & correct                 Signature of the Claimant
        
Sign & Name of the Chairman / Custodian";
	
		$pdf->SetFont('Times','',12);
		$pdf->MultiCell(186,4,$str,1,'L');

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

$pdf->Cell(200, 5,'FOR USE BY ACCOUNTS OFFICE ONLY',0, 1, 'C');
        $pdf->ln(2);

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

$str = " 
Head of Account.....................................Passed for Ra.....................Vide Vr. No...............Dated..............

(In words.....................................................................................................................................................) 
		
		Section Clerk                                                                                                                              Principal";
	
		$pdf->SetFont('Times','',12);
		$pdf->MultiCell(186,4,$str,1,'L');

}

function SendOutput($resopt1)
	{
		$this->pdf->Output("TADA_Bill_".$resopt1['forderid'].".pdf","I");
	}	 
}

function tadabillReport($aobj_context)
{
	
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);

$aadhar = $aobj_context->mobj_data["aadhar"];
    $orderid = $aobj_context->mobj_data["orderid"];
    $query = "select ifnull(m.FMOBILE,'') as fmobile,ifnull(m.FEMAIL,'') as femail,
    ifnull(m.FAADHARNO,'') as faadhar,
    ifnull(m.FTEACHNAME,'') as fteachname,
    ifnull(m.FDEGNCODE,'') as fdegncode,
    ifnull(m.ffaculty,'') as ffaculty,
    ifnull(m.ftechtype,'') as ftechtype,
    ifnull(m.FDEPTCODE,'') as fdeptcode,
    ifnull(m.fcollunivname,'') as fcollunivname,
    ifnull(m.fcity,'') as fcity,
    ifnull(m.FPANNO,'') as fpanno,
    ifnull(m.FACCNO,'') as faccno,
    ifnull(m.FIFSCCODE,'') as fifsccode,
    ifnull(d.FDEPTNAME,'') as fdeptname,
    ifnull(dg.FDEGNDESC,'') as fdegndesc
    from masteach m 
    inner join masdept d on m.FDEPTCODE = d.FDEPTCODE
    inner join masdegn dg on m.FDEGNCODE = dg.FDEGNCODE
    where m.FAADHARNO = '{$aadhar}'";

$class_obj = new AddmissionApplication();
	
	$class_obj->DefaultConstructor($aobj_context);

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

$query1 = "select ifnull(forderid,'') as forderid,ifnull(fnatwrk,'') as fnatwrk,ifnull(fdespnwrk,'') as fdespnwrk,
    date_format(ifnull(fclaimfrm,''),'%d/%m/%Y') as fclaimfrm,
    date_format(ifnull(fclaimto,''),'%d/%m/%Y') as fclaimto,
    ifnull(fdayallow,'') as fdayallow,
    ifnull(ftotdaily,'') as ftotdaily,
    ifnull(fdist,'') as fdist,
    ifnull(ftravel,'') as ftravel,
    ifnull(ftotal,'') as ftotal,
    ifnull(fnostud,'') as fnostud,
    ifnull(fnobatch,'') as fnobatch,
    ifnull(fnosession,'') as fnosession,
    ifnull(ftotnostud,'') as ftotnostud,
    ifnull(ftotfnobatch,'') as ftotfnobatch,
    ifnull(ftotfnosession,'') as ftotfnosession,
    ifnull(fbillno,'') as fbillno,
    ifnull(fnoqust,'') as fnoqust,
    ifnull(ftotqust,'') as ftotqust,
    ifnull(fpostchrg,'') as fpostchrg
    from tadabills
    where FAADHARNO = '{$aadhar}' and forderid = '{$orderid}'";

$resopt1 = $aobj_context->mobj_db->GetRow($query1);

$aobj_context->NATUREOFWORK=$resopt1['fnatwrk'];
    $aobj_context->billno=$resopt1['fbillno'];
    // var_dump($aobj_context->NATUREOFWORK);
    // die();
	$class_obj->writeApplication($db,$per_details, $fee_det,$res_optopns,$per_details['FDEGREE1'], $res_prevmarks,$res_lanmarks,$res_totmarks,$fdob,$resopt,$resopt1,$aobj_context->NATUREOFWORK);

$class_obj->SendOutput($resopt1);
}

${this.title}

Code Editor : tadabillReport.php