/* Decoded by unphp.net */

?><?php 
session_start();
ini_set( "display_errors", 0);
    include('include/conn.php');
    

      
 $BID = $_POST['BID'];
$ORNo = $_POST['ORNo'];
$CTCNo = $_POST['CTCNo'];
$CompleteName = $_POST['CompleteName'];
$CertificateType = $_POST['CertificateType'];

$Signatory = $_POST['Signatory'];
$CertFee = $_POST['CertFee'];
$Copies = $_POST['Copies'];

$purpose_ID = $_POST['purpose'];
$Custom_Purpose = $_POST['Custom_Purpose'];
if($purpose_ID==1){
	$Purpose_2 = $Custom_Purpose;
	$Certificate_purpose_ID = 1;
}
else{
	$Purpose_2 = $purpose_ID;
	$Certificate_purpose_ID = purpose_ID;
}

 $BusinessID = $_POST['BusinessID'];

$AmountPaid = $CertFee * $Copies;

$DateIssued = date('Y-m-d h:i:s');   

 $NxtYear = date('Y');   
$MonthDay = "December 31, "; //date('m-d') ; 
$ValidUntil_short = $NxtYear."-12-31"; //date('m-d') ; 
$ValidUntil = $MonthDay.' '.$NxtYear;




$eventlog = mysqli_query($conn2,"INSERT INTO `t_eventlog`
(`tablename`, `columnid`, `action`, `Date`, `Username`) 
VALUES 
('D','$BID','4','$DateIssued','$Uname')")or die("Error on query");  


$sqlins1 = mysqli_query($conn2,"UPDATE `t_business` SET `LastRenewalDate`='$ValidUntil_short' WHERE ID='$BID'")or die("Error on query"); 

$query2= mysqli_query($conn2,"SELECT * FROM t_business 
WHERE ID='$BID'")or die("Error on query");
while($rowBiz = mysqli_fetch_array($query2))
{
   $ID = $rowBiz[0];
   $LastName = $rowBiz[1];
   $region = $rowBiz[2];
   $province = $rowBiz[3];
   $city = $rowBiz[4];
   $barangay = $rowBiz[5];
   $street = $rowBiz[6];
   $ContactNo = $rowBiz[7];
   $BusinessType = $rowBiz[8];
   $BusinessForm = $rowBiz[9];
   $BusinessName = $rowBiz[10];
   $Operating_Since = $rowBiz[11];
   $Purok = $rowBiz[12];
   $Remarks = $rowBiz[13];
   $DateEncoded = $rowBiz[14];
   $Status = $rowBiz[15];
   $LastRenewalDate = $rowBiz[16];
   $Encodedby = $rowBiz[17];
   $SEC = $rowBiz[18];
   $DTI = $rowBiz[19];
   $FirstName = $rowBiz[20];
   $MiddleName = $rowBiz[21];
   $BSID = $rowBiz[22];
   $BIRTIN = $rowBiz[23];
   $Business_OwnersName = $FirstName.' '.$MiddleName.' '.$LastName;       
}

$query2= mysqli_query($conn2,"select max(ID) maxID  from t_certificate_trans")or die("Error on query");
$row2 = mysqli_fetch_array($query2);
if($row2['maxID']=="")
{
    $BusinessTransNo = '1';
}
else
{
    $BusinessTransNo = $row2['maxID']; 
}                        





$System = mysqli_query($conn2,"SELECT * FROM lookup_officials o LEFT JOIN lookup_positions p on p.ID=o.Position where o.ID='$Signatory' ")or die("Error on query");
                                                $count = mysqli_num_rows($System);
                                                    while($row = mysqli_fetch_array( $System ))
                                                                {
                                                                    $LastName = $row[1];
                                                                    $FirstName = $row[2];
                                                                    $MiddleName  = $row[3];
                                                                    $IsCaptain = $row[8];
                                                                    $Position_Kag = $row[11];

                                                                    //middlename
                                                                        $str_middlename = $MiddleName;
                                                                        function initials($str) {
                                                                        $ret = '';
                                                                        foreach (explode(' ', $str) as $word)
                                                                            $ret .= strtoupper($word[0]);
                                                                        return $ret;
                                                                        }      

                                                                        if($MiddleName==""){
                                                                        $period = "";
                                                                        }else{
                                                                        $period = ".";
                                                                        }
                                                                        $KagawadName =  $FirstName.' '.initials($MiddleName).$period.' '.$LastName;

                                                                }
$SystemC = mysqli_query($conn2,"SELECT * FROM lookup_officials o LEFT JOIN lookup_positions p on p.ID=o.Position  where Position='1' and IsActive='1'")or die("Error on query");
                 $count = mysqli_num_rows($SystemC);
                 while($rowC = mysqli_fetch_array( $SystemC ))
                 {
                    $LastNameC = $rowC[1];
                    $FirstNameC = $rowC[2];
                    $MiddleNameC  = $rowC[3];
                    $Position_Kap = $rowC[11];
                
                //middlename
               $str_middlename = $MiddleNameS;
               function initialsB($str) {
               $ret = '';
               foreach (explode(' ', $str) as $word)
                   $ret .= strtoupper($word[0]);
               return $ret;
               }      

               if($MiddleNameC==""){
               $period = "";
               }else{
               $period = ".";
               }
               $CaptainName =  'Hon. '.$FirstNameC.' '.initialsB($MiddleNameC).$period.' '.$LastNameC;

 $TransCode = uniqid();


                  $sqlins1 = mysqli_query($conn2,"INSERT INTO `t_certificate_trans`
                   (`ID`, `CID`, `Type`, `Purpose`, `Signatory`, `Fee`, `Copies`, `OfficialReceipt`, `CtcNo`, `Date`,`Uname`,`TransCode`)
                   VALUES 
                   ('','$BID','$CertificateType','$Certificate_purpose_ID','$Signatory','$AmountPaid','$Copies','$ORNo','$CTCNo','$DateIssued','$Uname','$TransCode')");                                                                                    
                                                                                } 
   
                                                $System = mysqli_query($conn2,"SELECT * FROM lookup_certificate_purpose where ID='$purpose_ID'")or die("Error on query");
                                                $count = mysqli_num_rows($System);
                                                    while($row = mysqli_fetch_array( $System ))
                                                                {
                                                    $ID=$row['ID'];
                                                    $purpose=$row['Name'];
                                                                }

																
                                                    if($purpose_ID==1){
														$Purpose_inword = $Custom_Purpose;
													}
													else{
														$Purpose_inword = $purpose;
													}
													
                                                                


$query2= mysqli_query($conn2,"SELECT * FROM sys_reg 
WHERE ID='1'")or die("Error on query");

while($row2 = mysqli_fetch_array($query2))
{
$Barangay_reg = $row2[1];
$City_reg = $row2[2];
$PRO0vince_reg = $row2[3];

}

$DateNow = date('F d, Y');
?>

<?php
function convert_number_to_words($number) {
  
    $hyphen      = '-';
    $conjunction = '  ';
    $separator   = ' ';
    $negative    = 'negative ';
    $decimal     = ' and ';
    $dictionary  = array(
        0                   => 'Zero',
        1                   => 'One',
        2                   => 'Two',
        3                   => 'Three',
        4                   => 'Four',
        5                   => 'Five',
        6                   => 'Six',
        7                   => 'Seven',
        8                   => 'Eight',
        9                   => 'Nine',
        10                  => 'Ten',
        11                  => 'Eleven',
        12                  => 'Twelve',
        13                  => 'Thirteen',
        14                  => 'Fourteen',
        15                  => 'Fifteen',
        16                  => 'Sixteen',
        17                  => 'Seventeen',
        18                  => 'Eighteen',
        19                  => 'Nineteen',
        20                  => 'Twenty',
        30                  => 'Thirty',
        40                  => 'Forty',
        50                  => 'Fifty',
        60                  => 'Sixty',
        70                  => 'Seventy',
        80                  => 'Eighty',
        90                  => 'Ninety',
        100                 => 'Hundred',
        1000                => 'Thousand',
        1000000             => 'Million',
        1000000000          => 'Billion',
        1000000000000       => 'Trillion',
        1000000000000000    => 'Quadrillion',
        1000000000000000000 => 'Quintillion'
    );
  
    if (!is_numeric($number)) {
        return false;
    }
  
    if (($number >= 0 && (int) $number < 0) || (int) $number < 0 - PHP_INT_MAX) {
        // overflow
        trigger_error(
            'convert_number_to_words only accepts numbers between -' . PHP_INT_MAX . ' and ' . PHP_INT_MAX,
            E_USER_WARNING
        );
        return false;
    }
 
    if ($number < 0) {
        return $negative . convert_number_to_words(abs($number));
    }
  
    $string = $fraction = null;
  
    if (strpos($number, '.') !== false) {
        list($number, $fraction) = explode('.', $number);
    }
  
    switch (true) {
        case $number < 21:
            $string = $dictionary[$number];
            break;
        case $number < 100:
            $tens   = ((int) ($number / 10)) * 10;
            $units  = $number % 10;
            $string = $dictionary[$tens];
            if ($units) {
                $string .= $hyphen . $dictionary[$units];
            }
            break;
        case $number < 1000:
            $hundreds  = $number / 100;
            $remainder = $number % 100;
            $string = $dictionary[$hundreds] . ' ' . $dictionary[100];
            if ($remainder) {
                $string .= $conjunction . convert_number_to_words($remainder);
            }
            break;
        default:
            $baseUnit = pow(1000, floor(log($number, 1000)));
            $numBaseUnits = (int) ($number / $baseUnit);
            $remainder = $number % $baseUnit;
            $string = convert_number_to_words($numBaseUnits) . ' ' . $dictionary[$baseUnit];
            if ($remainder) {
                $string .= $remainder < 100 ? $conjunction : $separator;
                $string .= convert_number_to_words($remainder);
            }
            break;
    }
  
  /*  if (null !== $fraction && is_numeric($fraction)) {
        //$string .= $decimal;
        $words = array();
        foreach (str_split((string) $fraction) as $number) {
            $words[] = $dictionary[$number];
        }
      //  $string .= implode(' ', $words).' Cents';
		
    }*/
  
    return $string;
}
 //$Amount_number = '1000000.50';
//$Amount_words = convert_number_to_words($Amount_number).' Pesos Only ';
$cents_decimal  = strchr($CTCI, ".");
$result = str_replace(array('.', ' '), '', $cents_decimal);
$Amount_words1 = convert_number_to_words($CTCI);
if($cents_decimal==''){
	 $Amount_words = $Amount_words1.' Pesos Only';
}else{
	
	  $Amount_words = $Amount_words1.' Pesos and  '.$result.'/100 Only'; 
}
   
  

  
?>



<?php
                                                $System = mysqli_query($conn2,"SELECT * FROM lookup_issuecertificate where ID='$CertificateType'")or die("Error on query");
                                                $count = mysqli_num_rows($System);
                                                    while($row = mysqli_fetch_array( $System ))
                                                                {
                                                    $ID=$row['ID'];
                                                    $Certificate_Name=$row['Name'];
                                                    $Fee=$row['Fee'];
                                                                }



                                                                
                                                                $query2= mysqli_query($conn2,"select max(ID) maxID  from t_certificate_trans")or die("Error on query");
                                                                $row2 = mysqli_fetch_array($query2);
                                                                if($row2['maxID']=="")
                                                                {
                                                                    $ControlNo = '1';
                                                                }
                                                                else
                                                                {
                                                                    $ControlNo = $row2['maxID']; 
                                                                }
                                            ?>
                                        
 <?php
  $query2= mysqli_query($conn2,"SELECT * FROM t_report_template where Code='Header'")or die("Error on query");
 while($row2 = mysqli_fetch_array($query2))
{
$H1 = $row2[2];
$H2 = $row2[3];
$H3 = $row2[4];
$H4 = $row2[5];
$H5 = $row2[6];
$H6 = $row2[7];

}

?>
 <?php
if(date('d')=='01' || date('d')=='21' || date('d')=='31'){
    $Sup = "<sup>st</sup>";
}elseif(date('d')=='02' || date('d')=='22'){
    $Sup = "<sup>nd</sup>";
}elseif(date('d')=='03' || date('d')=='23'){
    $Sup = "<sup>rd</sup>";
}elseif(date('d')=='04' || date('d')=='05' || date('d')=='06' || date('d')=='07' || date('d')=='08' || date('d')=='09' || date('d')=='10' || date('d')=='11' || date('d')=='12' || date('d')=='13' || date('d')=='14' || date('d')=='15' || date('d')=='16' || date('d')=='17' || date('d')=='18' || date('d')=='19' || date('d')=='20' || date('d')=='24' || date('d')=='25' || date('d')=='26' || date('d')=='27' || date('d')=='28' || date('d')=='29' || date('d')=='30') {
    $Sup = "<sup>th</sup>";
}else{}


?> 
<?php
// Include the qrlib file
include 'phpqrcode/qrlib.php';

$System = mysqli_query($conn2,"SELECT * FROM lookup_businesstype where ID='$BusinessType'")or die("Error on query"); $count = mysqli_num_rows($System); while($row = mysqli_fetch_array( $System )){   $btype=$row['Name']; }
$System = mysqli_query($conn2,"SELECT * FROM lookup_businessformorganization where ID='$BusinessForm'")or die("Error on query"); $count = mysqli_num_rows($System); while($row = mysqli_fetch_array( $System )){   $bform=$row['Name']; } 
                                                                           
$text2 = "Business ID No.: ".$BSID."
Business Name: ".$BusinessName."
Valid Until: ".$ValidUntil;
$text = $text2."

O.R. #: ".$ORNo."
Date Issued: ".$DateIssued."
Trans Code: ".$TransCode;

// $path variable store the location where to 
// store image and $file creates directory name
// of the QR code file by using 'uniqid'
// uniqid creates unique id based on microtime
$path = 'images/';
$file = $path.$TransCode.".png";
 
// $ecc stores error correction capability('L')
$ecc = 'H';
$pixel_Size = 5;
$frame_Size = 10;
  
// Generates QR Code and Stores it in directory given
QRcode::png($text, $file, $ecc, $pixel_Size, $frame_size);
  
// Displaying the stored QR code from directory
//echo "<center><img src='".$file."'></center>";
?>                                          
 <?php
  $query2= mysqli_query($conn2,"SELECT * FROM t_report_template where Code='Header'")or die("Error on query");
 while($row2 = mysqli_fetch_array($query2))
{
$H1 = $row2[2];
$H2 = $row2[3];
$H3 = $row2[4];
$H4 = $row2[5];
$H5 = $row2[6];
$H6 = $row2[7];

}

?>
<?php
$query2= mysqli_query($conn2,"SELECT Name, Firstp, Secondp, Thirdp, Fourthp, Background, Fee, Status, ID FROM lookup_issuecertificate
												WHERE ID='$CertificateType'")or die("Error on query");
                                                    while($row2 = mysqli_fetch_array($query2)){
														 $Name = $row2[0];
														$Firstp = $row2[1];
														$Secondp = $row2[2];
														$Thirdp = $row2[3];
														$Fourthp = $row2[4];
														$Background = $row2[5];
														$Fee = $row2[6];
														$Status = $row2[7];
														$CID = $row2[8];													
?>

<html>
<head>
<title>Print Business Certificate</title>
<script type="text/javascript">
window.onload=function(){
	//alert('Think before you print.');
window.print();
    setTimeout(function() {
    window.close();
    }, 0);

    window.onload = closeWindow();  
	
}
</script>

    <link rel="stylesheet" href="css/all.css">
    <script src="js/jquery.min_qr.js"></script>
    <script type="text/javascript" src="js/bootstrap.bundle.min.js"></script>
</head>
    <body>



<!--Header Starts here-->
    <div id="header" style="position:fixed; top:10px; left:50px; height:200px; right:50px;float: left;">  
    <img src="<?php  echo "data:image;base64,".$LOG1; ?>" alt="logo" style="width:120px;height:120px;float: left;" />
    </div>

    <div style="text-align:center;margin: 10px 0px 0px 0px;font-size:20px;">
        <?php echo $H1; ?><br/>
        <?php echo $PRO; ?><br/>
        <?php echo $CIT; ?><br/>
        <b><?php echo $BAR; ?></b><br/>
		~ o ~ o ~ 0 ~ o ~ o ~ <br/>
        <b><?php echo $H5; ?></b>
        <?php echo $H6; ?>
        
    </div> 
    <div id="header" style="position:absolute; top:10px; left:0px; height:200px; right:50px;float: right;"> 
    <img src="<?php  echo "data:image;base64,".$LOG2; ?>" alt="logo" style="width:120px;height:120px;float: right;" />
    </div>
<!--end of header-->
   
    </div> 
 
<style>
.background_image {
    position: relative; 
    height: 100vh;
    width: 100%;
    align-items: center;
    justify-content: center;
}

.background_image::before {    
      content: "";
      background-image: url('<?php echo "Image_cert/".$Background; ?>');
      
	background-size: 80% 50%;
	background-repeat: no-repeat;
	background-position: center;
      position: absolute;
      top: 0px;
      right: 0px;
      bottom: 0px;
      left: 0px;
      opacity: 0.15;
	  
	  
}
</style> 

    <div id="content" class="background_image" style="left:5px;right:10px;position:fixed;top:50px; overflow:auto;"> 
   
    <div class="card">
       <div class="card-body"><center><h1 class="card-title" style="left:5px;right:10px;position:fixed;top:150px; overflow:auto;"><b><?php echo ucwords($Certificate_Name); ?></b></h1></center></div>              
              

<style>
p.a {  
  font-size:;
  justify-content: left;
  text-align:justify;
  left:500px;
  height: 25px;
}
p.b {
  text-indent: 50px;
  font-size:;
  justify-content: left;
  text-align:justify;
  left:500px;
  height: 25px;
}

p.c {
  text-indent: 50px;
  font-size:;
  justify-content: left;
  text-align:justify;
  left:500px;
  height: 25px;
}
p.d {
  text-indent: 50px;
  font-size:;
  justify-content: left;
  text-align:justify;
  left:500px;
  height: 25px;
}


</style>
<style>
td{
	white-space: nowrap;overflow: hidden;text-overflow: ellipsis; /*max-width: 0;*/
}

</style>
<div id="content" style="left:40px;right:20px;top:220px;position: fixed; "> 
<?php if($CertificateType==4){?>

<center><h2><u><b><?php echo ucwords($BusinessName);?></b></u></h2>
<h3>Business Name</h3></center>


<?php }else{?>	

                                        <p class="a"><?php echo $Firstp; ?></p>

										 <p class="b"><?php echo $Secondp; ?></p>
												
<hr>                                       
<?php } ?>					
	<div class="x" style="left:40px;right:20px;position:fixed;float:left;">
                                   
<div class="form-group row" style="left:40px;right:20px;top:350px;position:fixed;float:left;">	
				<table border="0" style="width:90%;font-size:1em;position: fixed;left:50px;float:left;table-layout: auto;border-collapse: collapse;">
                          <tr>
                            
                          
                          <tr/>
							<?php if($CertificateType==4){}else{?>
                              <tr>
                              <td>        
                                      <div class="form-group row">
                                          <label  >Business Name  </label>
                                          </td><td colspan="5">:
                                          <label   style="font-size:1.2em;"><b><?php echo ucwords($BusinessName);?></b></label>
                                      </div>
                                    </td>
                                  
                                      <td></td>
                                  
                              </tr>
							<?php } ?>
                              <tr>
                              <td>
                                      <div class="form-group row">
                                          <label   >Business Type </label>
                                          </td><td>
                                          <label   style="left:150px;">: <?php $System = mysqli_query($conn2,"SELECT * FROM lookup_businesstype where ID='$BusinessType'")or die("Error on query"); $count = mysqli_num_rows($System); while($row = mysqli_fetch_array( $System )){  echo $Name=$row['Name']; } ?></label>
                                      </div>
                                  </td>

							<td>          
                                      <div class="form-group row">
                                          <label  > Business ID No.  </label>
                                          </td><td>: 
                                          <label   style="left:150px;"><?php echo $BSID; ?></label>
                                      </div>
                                      </td>	

                              </tr>
                              <tr>
                              <td>          
                                      <div class="form-group row">
                                          <label  >Business Form  </label>
                                          </td><td>
                                          <label  >: <?php $System = mysqli_query($conn2,"SELECT * FROM lookup_businessformorganization where ID='$BusinessForm'")or die("Error on query"); $count = mysqli_num_rows($System); while($row = mysqli_fetch_array( $System )){  echo $Name=$row['Name']; } ?></label>
                                      </div>
                                  </td>
                              
                                      <td>          
                                      <div class="form-group row">
                                          <label  >Valid until  </label>
                                          </td><td>
                                          <label  >: <?php echo $ValidUntil; ?></label>
                                      </div>
                                  </td>
                                     
                              </tr>
                              <tr>
                                  <td>          
                                      <div class="form-group row">
                                          <label  >Address </label>
                                          </td><td>
                                          <label  >: <?php $System = mysqli_query($conn2,"SELECT * FROM lookup_purok where ID='$Purok'")or die("Error on query"); $count = mysqli_num_rows($System); while($row = mysqli_fetch_array( $System )){ echo $Name=$row['Name'].', '; }?><?php echo $BAR0.', '.$CIT; ?></label>
                                      </div>
                                      </td>
                                      <td>          
                                      <div class="form-group row">
                                          <label  >Permit No  </label>
                                          </td><td>
                                          <label  >: BP<?php echo $CertificateType.'-'.$BID.'-'.$BusinessTransNo; ?></label>
                                      </div>
                                  </td>
                                      
                              </tr>
                              
                              <tr>
                                  <td>          
                                      <div class="form-group row">
                                          <label  >Registered Owner </label>
                                          </td><td>
                                          <label  >: <?php echo ucwords($Business_OwnersName); ?></label>
                                      </div>
                                      </td>
                                      <td>          
                                      <div class="form-group row">
                                          <label  > SEC Reg. No. </label>
                                          </td><td>
                                          <label  >: <?php if($SEC==""){echo "N/A";}else{echo $SEC;} ?></label>
                                      </div>
                                  </td>
                                      
                              </tr>
                              <tr>
                                  <td>          
                                      <div class="form-group row">
                                          <label  >DTI Reg. No. </label>
                                          </td><td>
                                          <label  >: <?php if($DTI==""){echo "N/A";}else{echo $DTI;} ?></label>
                                      </div>
                                      </td>
                                      <td>          
                                      <div class="form-group row">
                                          <label  >BIR TIN  </label>
                                          </td><td>
                                          <label  >: <?php if($BIRTIN==""){echo "N/A";}else{echo $BIRTIN;} ?></label>
                                      </div>
                                  </td>
                                      
                              </tr>
                              <tr>
								
                                  <td>          
                                      <div class="form-group row">
                                          <label  >Status  </label>
                                          </td><td>
                                          <label  >: <?php $System = mysqli_query($conn2,"SELECT * FROM lookup_business_status where ID='$Status'")or die("Error on query"); $count = mysqli_num_rows($System); while($row = mysqli_fetch_array( $System )){  echo $Name=$row['Name']; }  ?></label>
                                      </div>
                                      </td>
                                  
                                     
                                      <td>          
                                      <div class="form-group row">
                                          <label  >Operating Since  </label>
                                          </td><td>
                                          <label  >: <?php echo $Operating_Since; ?></label>
                                      </div>
                                      </td>
                                      
                              </tr>
                              
                              <tr>
                              <td>          
                                      <div class="form-group row">
                                          <label  >  </label>
                                          </td><td>
                                          <label   style="left:150px;"></label>
                                      </div>
                                      </td>
                                  
                                     
                                      <!--td>          
                                      <div class="form-group row">
                                          <label  >Owner's Signature  </label>
                                          </td><td>
                                          <label  >: __________________</label>
                                      </div>
                                      </td-->
                                      
                              </tr>
                              
                              <tr>
                              
                              </tr>
                             </table>
                              <div class="form-group row" style="left:40px;right:20px;position:absolute;top:500px;position: fixed; justify-content: left;text-align:justify;">
                                        <p class="c"><?php echo $Thirdp; ?><?php if ($CertificateType==4){}else{?><b><?php echo  " ".$Purpose_inword; ?></b>.<?php } ?></p>
                              </div>
							<div class="form-group row" style="left:40px;right:20px;position:absolute;top:560px;position: fixed; justify-content: left;text-align:justify;">	
										<p class="d"><?php echo $Fourthp; ?></p> 
							</div>			
    </div>  
                             </div>     
                                       
        </div>  

  <?php } ?>  
  
<div class="form-group row" style="left:40px;right:20px;position:absolute;top:660px;position: fixed; justify-content: left;text-align:justify;">
										
                                       <p class="b"> Issued this <b><?php echo  date('d',strtotime(date('Y-m-d'))).''.$Sup; ?> day of <?php echo date('F',strtotime(date('Y-m-d'))); ?> <?php echo date('Y',strtotime(date('Y-m-d'))); ?></b> at <?php echo ucwords($BAR).', '.$CIT.', '.ucwords($PRO0); ?>.
                                        </p>
                            </div> 
                                       

                                       <div class="col-sm-6" style="left:40px;right:20px;position:absolute;bottom:70px;position: fixed; ">
                                        <center style="float: right;bottom:100px;">
                                        <b ><?php echo ucwords(strtolower($CaptainName));  ?></b>
                                         </br><?php echo $Position_Kap; ?><br/><br/><br/>
                                       
                                       
                                       <?php if($IsCaptain==="1"){?>
                                       
                                        <i style="font-size:.7em;">&nbsp; </i><br/><br/><br/>
                                        &nbsp; </br> &nbsp; </center>
                                       <?php }else{ ?>
                                        <i style="font-size:.7em;">By the Authority of the <?php echo $Position_Kap; ?>:</i><br/><br/><br/>
                                        <?php echo ucwords(strtolower($KagawadName));  ?> </br><?php echo $Position_Kag; ?></center>
                                        <?php } ?>
                                    </div>  
									
									
                                    
                                        <table id="xxx" class="xx" style="position: fixed;bottom:160px;font-size:.7em;left:40px;right:20px;">
                                            <tr>
                                            <td>CTC </td><td>: <?php echo  $CTCNo; ?></td>
                                            </tr>
                                           
                                            <tr>
                                            <td>Place Issued</td><td>: <?php echo $BAR.', '.$CIT.', '.$PRO0; ?><br/>
                                            </td>
                                            </tr>
                                            <tr>
                                            <td>Date/Time </td><td>: <?php echo $DateIssued; ?><br/>
                                            </td>
                                            </tr>
                                            <tr>
                                            <td>O.R. No. </td><td>: <?php echo $ORNo; ?></td>
                                            </tr>
                                            <tr>
                                            <td>Amount Paid </td><td>: <?php echo number_format($Fee,2); ?></td>
                                            </tr>
                                            <tr>
                                            <td align="right"><i></i> </td><td> <i>Note: Not valid without seal.</i></td>
                                            </tr>
                                            
                                            
                                        </table>
                                        
                                    </div>

                                      
                                                                                                                                                                     
                                    
</div>
                         
                                   
                                      
   
                                                                                                                                                                     
                                    
</div>
 

    <div style="border:1px solid yellow; width:100px; height:100px;position: fixed;bottom:55px;font-size:.7em;left:40px;right:20px;">
	<img src='<?php echo $file; ?>'  style="width:100px; height:100px;float: right;position: fixed;">
	
	</div> 						
    <div id="footer" style="font-size:.7em;position: fixed;text-align: center;left: 20px;bottom: 40px;right:50px;">
	<i><?php echo '" '.$TAG.'"'; ?></i>
	</div>
	<div id="footer" style="font-size:.7em;position: fixed;text-align: center;left: 20px;bottom: 10px;right:20px;">
    <hr size="5" style="background-color:black;width:700px;">
    <i size="2" style="float:left;"><?php $System = mysqli_query($conn2,"SELECT * FROM sys ")or die("Error on query"); $count = mysqli_num_rows($System); while($row = mysqli_fetch_array( $System )){ echo $Name=$row['SystemName'].' ('.$row['ShortCode'].' '.$row['Version'].'.'.$row['Update'].') '; }?>
	</i>  <i size="2" style="float:right;"><?php echo $Apptype; ?>  </i>  
    </div>
 
 
    </div>

    
 </div>   
     <script type="text/javascript" src="js/generate-qr-js.js"></script>       
        
</body>

</html>