Gecko [ 43.229.15.234 ]

Name	Size	Permission
111ajaxview.php	1.24 KB	-rw-r--r--
222report_indproduct_sale.php	4.05 KB	-rw-r--r--
ajaxapplicant.php	4.72 KB	-rw-r--r--
ajaxselection.php	2.88 KB	-rw-r--r--
applicant_callingpage.php	419 B	-rw-r--r--
applicant_editor.php	5.83 KB	-rw-r--r--
applicantselection.php	3.7 KB	-rw-r--r--
applicantselection_editor.php	2.9 KB	-rw-r--r--
applicantselection_list.php	6.14 KB	-rw-r--r--

Code Editor : ajaxapplicant.php

<?php
    include("../common/config.php");
    include("../common/functions.php");

$trevent_id= $_REQUEST["trevent_id"];

$stmt = $conn->prepare("SELECT 
                         th.thlinelistName,
                         te.trevnID                     	             
                        FROM trevent te
                        LEFT JOIN thlinelist th ON(te.thlinelist_id=th.id)                                            
                        WHERE te.id=?");

$stmt->bind_param("i",$trevent_id);
$stmt->execute();

$slno=0;			 
//Result
  $result1 = $stmt->get_result();
   while($row = $result1->fetch_assoc())
   {
    $thlinelistName = $row["thlinelistName"]; 
    $trevnID = $row["trevnID"];   
   }
   echo 'শিরোনাম : '. $thlinelistName;
   echo '   ব্যাচ নং : ',bangladate($trevnID) ;
  
?>
<script type="text/javascript" src="https://unpkg.com/xlsx@0.15.1/dist/xlsx.full.min.js"></script>
<p class="text-right"><button class="btn-danger" onclick="ExportToExcel('xlsx')">Download Excel</button></p>
 <table class="table table-bordered table-striped table-condensed" id="empTable">

<tr>   
    <td><b>ক্রম নং</b></td>
    <td><b>PIMS আইডি</b></td>
    <td><b>নাম</b></td>
    <td><b>এনআইডি</b></td>
    <td><b>পদবি</b></td>
    <td><b>জেলা</b></td>
    <td><b>কর্মস্থল</b></td>
    <td><b>ঠিকানা</b></td>
    <td><b>মোবাইল</b></td>
    <td><b>ই-মেইল</b></td>   
    <td><b>মন্তব্য</b></td>   
 </tr>

<tbody>
 <?php

$stmt = $conn->prepare("SELECT 
                            ap.id,
                            ap.GovtId,
                            ap.trevent_id,
                            ap.district_id,
                            ap.apname,
                            ap.designation_id,
                            ap.office_id,
                            ap.address,
                            ap.mobileno,
                            ap.email,
                            ap.comment,
                            ap.nidcard,
                            tr.subject,		
                            tr.trevnID,
                            d.DesignationName,
                            o.OfficeName,
                            dis.DistrictName                         	             
                        FROM applicantlist ap
                        LEFT JOIN trevent tr ON(ap.trevent_id=tr.id)
                        LEFT JOIN designation d ON(ap.designation_id=d.id)
                        LEFT JOIN office o ON (ap.office_id=o.id)
                        LEFT JOIN district dis ON (ap.district_id=dis.id)  
                        LEFT JOIN applicantselection aps ON (aps.applicantlist_id=ap.id)                      
                        WHERE ap.trevent_id=? ORDER BY d.desigslno,ap.srlno");

$stmt->bind_param("i",$trevent_id);
$stmt->execute();

$slno=0;			 
//Result
  $result = $stmt->get_result();	
  $numrows=$result->num_rows;

if($numrows==0) exit("No rows");						
  $slno=0;

while($row = $result->fetch_assoc())
   {
         $id = $row["id"];
         $slno = $slno+1;
         $trevent_id = $row["trevent_id"];
         $trevnID = $row["trevnID"];
         $GovtId = $row["GovtId"];
         $apname = $row["apname"];
         $DesignationName = $row["DesignationName"];
         $OfficeName = $row["OfficeName"];

$DistrictName = $row["DistrictName"];
         $nidcard = $row["nidcard"];
         $address = $row["address"];
         $mobileno = $row["mobileno"];
         $email = $row["email"];
         $comment = $row["comment"];
                      
?>
 <tr>
    <td class="text-center"><?=bangladate($slno)?></td>
    <td><?=bangladate($GovtId) ?></td>
    <td><?=$apname ?></td>
    <td><?=$nidcard ?></td>
    <td><?=$DesignationName ?></td>    
     <td><?=$DistrictName ?></td>
     <td><?=$OfficeName ?></td>
     <td><?=$address ?></td>
     <td><?=$mobileno ?></td>
     <td><?=$email ?></td>
     <td><?=$comment ?></td>
 </tr>

<?php
 }
 ?>
</tbody>
</table>
<script>

var today = new Date();
    var date = today.getFullYear()+'_'+(today.getMonth()+1)+'_'+today.getDate();
    var time_name = today.getHours() + ":" + today.getMinutes() + ":" + today.getSeconds();

${this.title}

Code Editor : ajaxapplicant.php