<?php
error_reporting(E_ALL);
//ini_set('display_errors', 1);

include "db-con.php";
include "session.php";
?>


<!doctype html>
<html lang="en">
  <head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Certificate</title>

    <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js"></script>
     
    <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/css/bootstrap.min.css">
              
    <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/js/bootstrap.min.js"></script>

    <!-- <script src="https://cdnjs.cloudflare.com/ajax/libs/jspdf/1.3.4/jspdf.min.js"></script> -->
 
    <script src="https://cdnjs.cloudflare.com/ajax/libs/html2pdf.js/0.9.2/html2pdf.bundle.js"></script> 

    <link rel="stylesheet" type="text/css" href="https://ais.org.in/digitalcertificate/css/master.css">


    <style>
      
      .col_sig {
        width: 220px;
      }
      .authorSign P {
        text-align: center;
     }
      .col_sig .signbox {
        width: 220px;      
      }
      .col_sig.memdate {
        width: 400px;
    }
        
    </style>
   
  </head>

  <body>

  <div class="full btnContainer">
      
      
      <div class="cerBtns">
        <button id="button" class="genPdf">Generate PDF</button>

        <a href="https://ais.org.in/digitalcertificate/dashboard.php" class="btn btn-md btn-primary">Back to Dashboard</a>
      </div>
 
    </div>

  <?php 
  	include "db-con.php"; 

	$member_id = $_GET['id'];

    $membership_Query = "SELECT * FROM `membership` WHERE member_id='$member_id'";
    $membership_result = $con->query($membership_Query) or die("error");

    if ($membership_result->num_rows > 0) {
    while($row_membership = mysqli_fetch_array($membership_result)) {    
    $member_name = $row_membership["member_name"]; 
    $member_address = $row_membership["member_address"];  
    $membership_plan = $row_membership["membership_plan"];  
    $issue_date = $row_membership["issue_date"];  
    $end_date = $row_membership["end_date"]; 
    $issue_Cmonth = date("m", strtotime($issue_date));
    $issue_fyear = date("Y", strtotime($issue_date));
    $issue_Uyear= $issue_fyear+1;
?>

<div class="full">
    <div id="makepdf" class="certificateSec annualSec" style="text-align: center;">
     
    	<h1>This Certificate is issued to</h1>
    	<h2><?php echo $member_name; ?></h2>
    	<p class="memAddress"><?php echo $member_address; ?></p>
    
        <div class="signature authorSign"><!----signature start-->
        	 <div class="col_sig memdate">     
        	 <!--31.st March-->
        		<p>MEMBERSHIP PERIOD: <?php $issue_date; 
        		echo $format_ch = date("d.m.Y", strtotime($issue_date));
        		?> to 01.04.<?php
              if($issue_Cmonth == 01 || $issue_Cmonth == 02 || $issue_Cmonth == 03){
                echo $issue_fyear;
              }else{
                echo $issue_Uyear;
              };
              ?>
               
              
              <!--1.4.2023 to 31.3.2025-->

              <!-- $issue_fyear;  $issue_Uyear;  <br>  -->

        		</p>
        
        	</div>
        	<div class="col_sig traineeSign">
            <div class="signbox">
        	     <img src="https://ais.org.in/digitalcertificate/images/annual_authorise_sign.png">
            </div>
        		<p>AUTHORISED SIGNATORY	</p>
        
        	</div>
        </div><!----signature end-->
    
    </div><!----pdf end-->


</div>

<!--     <button id="button" class="genPdf">Generate PDF</button> -->
 
<?php
 }

 }
 $con->close();   

?>

	<script>
	        let button = document.getElementById("button");
	        let makepdf = document.getElementById("makepdf");
	        var opt = {
    			  margin:       0.1,
    			  filename:     '<?php echo $member_id."_".$membership_plan;?>.pdf',
    			  image:        { type: 'jpeg', quality: 0.98 },
    			  html2canvas:  { scale: 2 },
    			  jsPDF:        { unit: 'in', format: 'A4', orientation: 'Landscape' }
    			};
    	 
	        button.addEventListener("click", function () {
	      //   	 $html2pdf = new HTML2PDF('L', 'A4', 'en');
			    // $html2pdf->setDefaultFont('Arial');
			    // $html2pdf->writeHTML($html, false);
			    // $html2pdf->Output('output.pdf', 'D');
	        	// $html2pdf = new HTML2PDF('L', 'A4', 'en');
	            html2pdf().set(opt).from(makepdf).save();
	        });
	 </script>


  </body>
</html>
