<?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">
   
  </head>

  <body>
     <?php  
     
      if (isset($_SESSION['login_email']) && $_SESSION['login_email'] == true) {
        
        $get_user_login = "SELECT email, role FROM admin_user WHERE email = '$sess_userid'";
        $get_result = $con->query($get_user_login);
    
        while($row = mysqli_fetch_assoc($get_result )){
           $useremail=$row['email'];
           $userrole=$row['role'];
        }
     //  echo "&nbsp;&nbsp;";
       ?>
       
       
  <div class="full btnContainer">
      <div class="cerBtns">
        <button id="button" class="genPdf">Generate PDF</button>

        <a href="https://ais.org.in/digitalcertificate/trainees.php" class="btn btn-md btn-primary">Back to Dashboard</a>
      </div>
 
    </div>

    <?php 

    $event_id = $_GET['id'];


    $event_Query = "SELECT * FROM `event` WHERE event_id='$event_id'";
    $event_result = $con->query($event_Query) or die("error");

    if ($event_result->num_rows > 0) {
    while($row_event = mysqli_fetch_array($event_result)) {    
    $event_name = $row_event["name"]; 
    $event_date = $row_event["date"]; 
    $event_speaker = $row_event["event_speaker"]; 
    $event_address = $row_event["address_one"]; 
    $event_type = $row_event["event_type"]; 
    



    
    ?>

<div class="full">
    <div id="makepdf" class="certificateSec speakSec" style="text-align: center;">
     
    	<h1>
        <?php
        $trainee_Query = "SELECT * FROM `trainee` WHERE trainee_id='$event_speaker'";
        $traine_result = $con->query($trainee_Query) or die("error");

        while($row_trainee = mysqli_fetch_array($traine_result)) {    
         echo $trainee_name = $row_trainee["name"]; 
        };

        ?></h1>
      <p>for sharing her valuable knowledge on </p>
      <p class="eventNameSpeack"><strong>“<?php echo $event_name; ?>”</strong></p>
     	<p>during AIS 
        <?php 
        if($event_type == "Offline"){
            echo "Workshop";
        }else{
            echo "Webinar";
        }
        ?> held on <?php

        $updateDate = strtotime($event_date);

        $newDate = date("dS F Y", $updateDate);
        echo $newDate;
        ?>.

    </p>
    
        <div class="signature authorSign"><!----signature start-->
        	 <div class="col_sig memdate">            
        		<p>Place: Mumbai

        		</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();   

?>


<div class="row">
<?php
} else {

echo "data 0 results";
?>
<a href="https://ais.org.in/digitalcertificate/">Back to login</a>                     
<?php
//   header("Location: https://ais.org.in/digitalcertificate/admin_login.php");

}
?>    
</div> 


	<script>
	        let button = document.getElementById("button");
	        let makepdf = document.getElementById("makepdf");
	        var opt = {
    			  margin:       0.1,
    			  filename:     '<?php echo $trainee_name; ?>_certificate.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>
