One Hat Cyber Team

View File Name : allwater.php

<?
include "qrlib.php"; 
 require_once('invoice2.php');
 include '../config.php';
 error_reporting(0);
 $blno = "www.shahajservice.com";

 if($_POST['submit']){

       session_start();

			  $_SESSION["pk"]=$pk = mysql_real_escape_string($_POST['pk']);

 			  $_SESSION["yr"]=$yr = $_POST['yr'];
			  
                            $table = mysql_query("select * from newapplication where AP_YR='$yr' AND AP_SEL='$pk' ORDER BY AP_ID DESC");

	while ($row = mysql_fetch_assoc($table)){								  

			  $apno = $row['AP_NO'];

			  $apname = $row['AP_NAME'];
	
			  $apimg = $row['AP_IMG'];
			  
			  $pano = $row['PA_NO']; 

			$apimg = rawurlencode($apimg);
 
 			  $flno = $row['AP_FLCARD'];
			  $flrot = $row['AP_FLROT'];			  
		  
			  
$i=1;
$_REQUEST['data'] = $apname.$pano.$apno.HAJ61.$yr;
?>
<?php    

    
    //set it to writable location, a place for temp generated PNG files
    $PNG_TEMP_DIR = dirname(__FILE__).DIRECTORY_SEPARATOR.'temp'.DIRECTORY_SEPARATOR;
    
    //html PNG location prefix
    $PNG_WEB_DIR = 'temp/';

       
    
    //ofcourse we need rights to create temp dir
    if (!file_exists($PNG_TEMP_DIR))
        mkdir($PNG_TEMP_DIR);
    
    
    $filename = $PNG_TEMP_DIR.'test.png';
    
    //processing form input
    //remember to sanitize user input in real-life solution !!!
    $errorCorrectionLevel = 'L';
    if (isset($_REQUEST['level']) && in_array($_REQUEST['level'], array('L','M','Q','H')))
        $errorCorrectionLevel = $_REQUEST['level'];    

    $matrixPointSize = 4;
    if (isset($_REQUEST['size']))
        $matrixPointSize = min(max((int)$_REQUEST['size'], 1), 10);


    if (isset($_REQUEST['data'])) { 
    
        //it's very important!
        if (trim($_REQUEST['data']) == '')
            die('data cannot be empty! <a href="?">back</a>');
            
        // user data
        $filename = $PNG_TEMP_DIR.'test'.md5($_REQUEST['data'].'|'.$errorCorrectionLevel.'|'.$matrixPointSize).'.png';
        QRcode::png($_REQUEST['data'], $filename, $errorCorrectionLevel, $matrixPointSize, 2);    
        
    } else {    
    
        //default data
        echo 'You can provide data in GET parameter: <a href="?data=like_that">like that</a><hr/>';    
        QRcode::png('PHP QR Code :)', $filename, $errorCorrectionLevel, $matrixPointSize, 2);    
        
    }    
        
    //display generated file
    '<img src="'.$PNG_WEB_DIR.basename($filename).'" /><hr/>';  
    

  

    $codeContents = $_REQUEST['data']; 
     
    // we need to generate filename somehow,  
    // with md5 or with database ID used to obtains $codeContents... 
    $fileName = '005_file.png'; 
     
    $pngAbsoluteFilePath = $tempDir.$fileName; 
    $urlRelativeFilePath = EXAMPLE_TMP_URLRELPATH.$fileName; 
     
    // generating 
    if (file_exists($pngAbsoluteFilePath)) { 
        QRcode::png($codeContents, $pngAbsoluteFilePath); 
         'File generated!'; 
         '<hr />'; 
    } 
     
    'Server PNG File: '.$pngAbsoluteFilePath; 
    '<hr />'; 
     
    // displaying 
     '<img src="'.$urlRelativeFilePath.'" />'; 
	 

	 




$code = $apno;


$pdf = new PDF_Invoice('P','mm',array(384,960));

$pdf->AddPage();

$pdf->SetAutoPageBreak(true, 10);

/* $pdf->bar1("$code"); */
$logo = file_get_contents('logo2.png');

if($apimg=="")
{
$logo1 = file_get_contents('default.png'); 	
}
else
{
$logo1 = file_get_contents('https://www.shahajservice.com/admin1/images/'.$apimg); 	
}

$logo2 = file_get_contents('005_file.png');
$pdf->addSocietename3( "Name         :");	
$pdf->addSocietepp3  ( "P.P.No       :");
/* $pdf->addSocieteap  ( "App. No.     :"); */
$pdf->addSocieteap3  ( "Flight No   :");
$pdf->addSocietewap  ( "App No      :");
$pdf->addSocietebill2( "APPROVED BY GOVT OF INDIA AND KSA  |  ISO CERTIFIED COMPANY");
/* $pdf->addSocieteper  ( "Perform      :");
$pdf->addSocieteper1( "HAJ");	
$pdf->addSocieteyr  ( "Year            :");
$pdf->addSocieteyr1( "2017");
$pdf->addSocieteser  ( "Service Office ");
$pdf->addSocieteser1( "61"); */
$pdf->addSocietesau( "SAUDI MOBILE : 05018 71553 | 05528 49970 | 05528 49833.");	

$pdf->addSocietemail1( "$flrot");

$pdf->addSocietebill( "SHA HAJ SERVICE");
$pdf->addSocietebill1( "(INDIA) PRIVATE LIMITED");

/* $pdf->RoundedRect(20,35,59,35, 2, 'DF');  */
$pdf->addzamwater("ZAM ZAM");
$pdf->addzamwater2("WATER");

$pdf->addzamwater1("");
/* $pdf->bar1("$code"); */

$pdf->addSocietename4("$apname");
$pdf->addSocietepp4("$pano");	
$pdf->addSocieteap4("$flno");	
$pdf->addSocietewap1("$apno");
$pdf->addSocietepack( "HAJ | UMRAH | ZIYARAH | AIRTICKET");	

// Output it

$pdf->MemImage($logo,20,20,70,0,'PNG');


 
$pdf->RoundedRect(126.5,659.5,150,150, 2, 'DF');
$pdf->MemImage($logo1,127,660,149,149,'JPG'); 


$fileName = 'frontwater-' . $apno .'.pdf';
$pdfdoc = $pdf->Output($fileName, 'F');
$attachment = chunk_split(base64_encode($pdfdoc));


?>

<? 

include('../config.php');				
$que1 = mysql_query("update newapplication set AP_WATERCARD='$fileName' WHERE AP_NO='".$apno."'"); 	 			
				
}?>

<script type="text/javascript">
alert("All Water Card Created sucessfully");
 								     setInterval(function(){newpage()},2000);
									 function newpage()
									 {                                
                               
			location.href = '../admin1/mg_watercard.php';	
									 }

 </script>  

<?  } ?>