Gecko [ 43.229.15.234 ]

Name	Size	Permission
ExpectedLastSal	[ DIR ]	drwxr-xr-x
FringerTham	[ DIR ]	drwxr-xr-x
SignetureSample	[ DIR ]	drwxr-xr-x
delcrearation	[ DIR ]	drwxr-xr-x
photo	[ DIR ]	drwxr-xr-x
ajaxviewgrade.php	544 B	-rw-r--r--
general.php	26.11 KB	-rw-r--r--
general_allemp.php	13.46 KB	-rw-r--r--
general_editor.php	47.52 KB	-rw-r--r--
general_list.php	11.51 KB	-rw-r--r--
general_report.php	23.71 KB	-rw-r--r--
pdsreport.php	72.99 KB	-rw-r--r--

Code Editor : pdsreport.php

<?php
session_start();
include("../common/config.php");
include("../common/functions.php");
include("../homepage/header.php");
include("../homepage/headermenu.php");

if(empty($_SESSION["username"])) 
{
  Header("Location: ../login/login.php");
 }	
 		 
 $GovtId= base64_decode($_REQUEST['GovtId']);
 
 if (empty($GovtId))
 {
    $GovtId= $_SESSION['pimsid'];
 }
 
 $stmt = $conn->prepare("SELECT 
												g.id,	
												g.photo,		
												g.GovtId,		
												g.NameB,		
												g.NameE,		
												g.FatherB,		
												g.FatherE,		
												g.MotherB,		
												g.MotherE,		
												g.NationalID,		
												g.PassportNo,		
												g.PassIssueDate,		
												g.PassLastDate,		
												g.dob,		
												g.BirthCertificateNo,		
												g.PersonalEmail,		
												g.OfficialEmail,	
												dis.DistrictName,
												d.DesignationName,		
												o.OfficeName,		
												g.CaderName,		
												g.CaderDate,		
												g.BatchNo,		
												ff.FredomFighterName,		
												ffc.FredomChildGrandName,		
												t.TriballistName,		
												s.SexName,		
												m.MaritualStatusName,		
												r.religionName,		
												ps.profsubjectName,		
												gr.GradeName,		
												cps.PayScale,		
												g.SalBasic,															
												g.ProjectName,		
												et.EmptypeName,		
												g.FirstJoinDate,		
												g.EedJoinDate,		
												g.EedCDJoinDate,		
												g.CLJoinDate,		
												g.PLJoindate,		
												g.RegularDate,		
												g.PermanentDate,		
												gvr.GovtResidentName,													
												ld.DesignationName AS lprDesignationName,		
												g.AnutoshikClass,												
												tb.TeliphoneName,		
												eb.ElectricityBillName,		
												vf.VhechilefairName,		
												hr.HouseRentName,		
												g.delcrearation,		
												g.ExpectedLastSal,		
												vinf.VheInfoName,		
												g.FringerTham,													
												g.SignetureSample,
                                                sts.statusname,
                                                DATE_FORMAT(DATE_ADD(DATE_ADD(dob,INTERVAL 59 YEAR),INTERVAL -1 DAY),'%d/%m/%Y') AS lprdate,
                                                DATE_FORMAT(DATE_ADD(DATE_ADD(dob,INTERVAL 60 YEAR),INTERVAL -1 DAY),'%d/%m/%Y') AS retdate																		
										FROM general g
											LEFT JOIN designation d ON(g.designation_id=d.id)
											LEFT JOIN office o ON(g.office_id=o.id)	
											LEFT JOIN district dis ON(g.district_id=dis.id)	
											LEFT JOIN fredomfighter ff ON(g.FredomFighter_id=ff.id)	
											LEFT JOIN fredomchildgrand ffc ON(g.FredomChildGrand_id=ffc.id)		
											LEFT JOIN triballist t ON(g.triballist_id=t.id)	
											LEFT JOIN sex s ON(g.sex_id=s.id)	
											LEFT JOIN maritualstatus m ON(g.MaritualStatus_id=m.id)	
											LEFT JOIN religion r ON(g.religion_id=r.id)
											LEFT JOIN profsubject ps ON(g.profsubject_id=ps.id)	
											LEFT JOIN grade gr ON(g.grade_id=gr.id)	
											LEFT JOIN grade cps ON(g.CurrScale_id=cps.id)													
											LEFT JOIN emptype et ON(g.emptype_id=et.id)	
											LEFT JOIN govtresident gvr ON(g.GovtResident_id=gvr.id)	
											LEFT JOIN designation ld ON(g.LprDesignation_id=ld.id)	
											LEFT JOIN teliphone tb ON(g.Teliphone_id=tb.id)
											LEFT JOIN electricitybill eb ON(g.ElectricityBill_id=eb.id)	
											LEFT JOIN vhechilefair vf ON(g.Vhechilefair_id=vf.id)	
											LEFT JOIN houserent hr ON(g.HouseRent_id=hr.id)	
											LEFT JOIN vheinfo vinf ON(g.VheInfo_id=vinf.id)	
                                            LEFT JOIN status sts ON(g.status_id=sts.id)	
										WHERE g.GovtId= ?");
				$stmt->bind_param("s",$GovtId);
                $stmt->execute();
                
                $result = $stmt->get_result();	
				$numrows=$result->num_rows;

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

while($row = $result->fetch_assoc())
						{
						   
							$slno = $slno+1;								
                            $id = $row['id'];
                            $photo = $row['photo'];
                            $GovtId = $row['GovtId'];
                            $NameB = $row['NameB'];
                            $NameE = $row['NameE'];
                            $FatherB = $row['FatherB'];
                            $FatherE = $row['FatherE'];
                            $MotherB = $row['MotherB'];
                            $MotherE = $row['MotherE'];
                            $NationalID = $row['NationalID'];
                            $PassportNo = $row['PassportNo'];
                            $PassIssueDate=date("d/m/Y", strtotime(str_replace('-','/',$row['PassIssueDate'])));						
                            $PassLastDate=date("d/m/Y", strtotime(str_replace('-','/',$row['PassLastDate'])));						
                            $dob=date("d/m/Y", strtotime(str_replace('-','/',$row['dob'])));					
                            $BirthCertificateNo = $row['BirthCertificateNo'];
                            $PersonalEmail = $row['PersonalEmail'];
                            $OfficialEmail = $row['OfficialEmail'];
                            $DistrictName = $row['DistrictName'];
                            $DesignationName = $row['DesignationName'];
                            $OfficeName = $row['OfficeName'];
                            $CaderName = $row['CaderName'];
                            $CaderDate=date("d/m/Y", strtotime(str_replace('-','/',$row['CaderDate'])));					
                            $BatchNo = $row['BatchNo'];
                            $FredomFighterName = $row['FredomFighterName'];
                            $FredomChildGrandName = $row['FredomChildGrandName'];
                            $TriballistName = $row['TriballistName'];
                            $SexName = $row['SexName'];
                            $MaritualStatusName = $row['MaritualStatusName'];
                            $religionName = $row['religionName'];
                            $profsubjectName = $row['profsubjectName'];
                            $GradeName = $row['GradeName'];
                            $PayScale = $row['PayScale'];
                            $SalBasic = $row['SalBasic'];					
                            $ProjectName = $row['ProjectName'];
                            $EmptypeName = $row['EmptypeName'];
                            $FirstJoinDate=date("d/m/Y", strtotime(str_replace('-','/',$row['FirstJoinDate'])));						
                            $EedJoinDate=date("d/m/Y", strtotime(str_replace('-','/',$row['EedJoinDate'])));						
                            $EedCDJoinDate=date("d/m/Y", strtotime(str_replace('-','/',$row['EedCDJoinDate'])));						
                            $CLJoinDate=date("d/m/Y", strtotime(str_replace('-','/',$row['CLJoinDate'])));						
                            $PLJoindate=date("d/m/Y", strtotime(str_replace('-','/',$row['PLJoindate'])));					
                            $RegularDate=date("d/m/Y", strtotime(str_replace('-','/',$row['RegularDate'])));						
                            $PermanentDate=date("d/m/Y", strtotime(str_replace('-','/',$row['PermanentDate'])));						
                            $GovtResidentName = $row['GovtResidentName'];
                           
                            $lprDesignationName = $row['lprDesignationName'];
                            $AnutoshikClass = $row['AnutoshikClass'];						
                            $TeliphoneName = $row['TeliphoneName'];
                            $ElectricityBillName = $row['ElectricityBillName'];
                            $VhechilefairName = $row['VhechilefairName'];
                            $HouseRentName = $row['HouseRentName'];
                            $delcrearation = $row['delcrearation'];
                            $ExpectedLastSal = $row['ExpectedLastSal'];
                            $VheInfoName = $row['VheInfoName'];
                            $FringerTham = $row['FringerTham'];						
                            $SignetureSample = $row['SignetureSample'];

$lprdate = $row['lprdate'];
                            $retdate = $row['retdate'];
                            $statusname = $row['statusname'];

}

<div class="container fullheight">
    <div class="row">
        <div class="col-md-12">
            <br>
           
            <h4> সাধারণ তথ্য</h4>

<div class="row">
              <div class="col-md-6">
                    <table class="table table-bordered table-striped table-condensed">
                        <tr>
                            <td>ছবি</td>
                            <td>
                                <a href="<?=$photo?>" data-toggle="lightbox11" data-title="<?=$NameB?>" >
                                    <img src="<?=$photo?>" width="40px" height="25px" alt="<?=$NameB?>">
                                </a>
                            </td>   
                                                
                        </tr>

<tr>
                            <td>নাম (বাংলায়)</td>
                            <td><?=$NameB?></td>                       
                        </tr>

<tr>
                            <td>নাম (ইংরেজিতে)</td>
                            <td><?=$NameE?></td>                       
                        </tr>

<tr>
                            <td>পিতার নাম (বাংলায়)</td>
                            <td><?=$FatherB?></td>                       
                        </tr>

<tr>
                            <td>পিতার নাম (ইংরেজিতে)</td>
                            <td><?=$FatherE?></td>                       
                        </tr>

<tr>
                            <td>মাতার নাম (বাংলায়)</td>
                            <td><?=$MotherB?></td>                       
                        </tr>

<tr>
                            <td>মাতার নাম (ইংরেজিতে)</td>
                            <td><?=$MotherE?></td>                       
                        </tr>

<tr>
                            <td>জাতীয় পরিচয়পত্র</td>
                            <td><?=bangladate($NationalID)?></td>                       
                        </tr>

<tr>
                            <td>পাসপোর্ট নম্বর</td>
                            <td><?=$PassportNo?></td>                       
                        </tr>

<tr>
                            <td>পাসপোর্ট ইস্যুর তারিখ</td>
                            <td><?=bangladate(str_replace('31/12/1969','',$PassIssueDate))?></td>                       
                        </tr>

<tr>
                            <td>পাসপোর্ট মেয়াদের শেষ তারিখ</td>
                            <td><?=bangladate(ddateremove($PassLastDate))?></td>                       
                        </tr>

<tr>
                            <td>জন্ম তারিখ</td>
                            <td><?=bangladate(ddateremove($dob))?></td>                       
                        </tr>

<tr>
                            <td>জন্ম সনদের নম্বর</td>
                            <td><?=$BirthCertificateNo?></td>                       
                        </tr>

<tr>
                            <td>ব্যক্তিগত ইমেইল</td>
                            <td><?=$PersonalEmail?></td>                       
                        </tr>

<tr>
                            <td>অফিসিয়াল ইমেইল</td>
                            <td><?=$OfficialEmail?></td>                       
                        </tr>

<tr>
                            <td>জন্মস্থান (জেলার নাম)</td>
                            <td><?=$DistrictName?></td>                       
                        </tr>

<tr>
                            <td>ক্যাডারের নাম</td>
                            <td><?=$CaderName?></td>                       
                        </tr>

<tr>
                            <td>ক্যাডারে যোগদানের তারিখ</td>
                            <td><?=bangladate(ddateremove($CaderDate))?></td>                       
                        </tr>

<tr>
                            <td>মুক্তিযোদ্ধা কি না?</td>
                            <td><?=$FredomFighterName?></td>                       
                        </tr>

<tr>
                            <td>মুক্তিযোদ্ধার ছেলেমেয়ে/নাতিনাতনি কি না?</td>
                            <td><?=$FredomChildGrandName?></td>                       
                        </tr>

<tr>
                            <td>উপজাতি হলে নাম</td>
                            <td><?=$TriballistName?></td>                       
                        </tr>

<tr>
                            <td>লিঙ্গ পরিচয়</td>
                            <td><?=$SexName?></td>                       
                        </tr>

<tr>
                            <td>বৈবাহিক অবস্থা </td>
                            <td><?=$MaritualStatusName?></td>                       
                        </tr> 
                        
   
                        <tr>
                            <td>ধর্ম</td>
                            <td><?=$religionName?></td>                       
                        </tr>

</table>
                </div>

<tr>
                            <td>নিয়োগের ধরণ</td>
                            <td><?=$EmptypeName?></td>                       
                        </tr>

<tr>
                            <td>চাকুরিতে প্রথম যোগদানের তারিখ</td>
                            <td><?=bangladate(ddateremove($FirstJoinDate))?></td>                       
                        </tr>

<tr>
                            <td>শিক্ষা প্রকৌশল অধিদপ্তরে যোগদানের তারিখ</td>
                            <td><?=bangladate(ddateremove($EedJoinDate))?></td>                       
                        </tr>

<tr>
                            <td>শিক্ষা প্রকৌশল অধিদপ্তরে বর্তমান পদবীতে যোগদানের তারিখ</td>
                            <td><?=bangladate(ddateremove($EedCDJoinDate))?></td>                       
                        </tr>

<tr>
                            <td>বর্তমান কর্মস্থলে যোগদানের তারিখ</td>
                            <td><?=bangladate(ddateremove($CLJoinDate))?></td>                       
                        </tr>

<tr>
                            <td>পূর্ববর্তী কর্মস্থলে যোগদানের তারিখ</td>
                            <td><?=bangladate(ddateremove($PLJoindate))?></td>                       
                        </tr>

<tr>
                            <td>চাকুরি নিয়মিতকরনের তারিখ</td>
                            <td><?=bangladate(ddateremove($RegularDate))?></td>                       
                        </tr>

<tr>
                            <td>চাকুরি স্থায়ীকরনের তারিখ</td>
                            <td><?=bangladate(ddateremove($PermanentDate))?></td>                       
                        </tr>

<tr>
                            <td>সরকারী বাসায় থাকেন কি না?</td>
                            <td><?=$GovtResidentName?></td>                       
                        </tr>

<tr>
                            <td>অবসরে প্রস্তুতির তারিখ</td>
                            <td><?=bangladate($lprdate)?></td>                     
                        </tr> 
                        
                        <tr>
                            <td>অবসরে যাওয়ার তারিখ</td>
                            <td><?=bangladate($retdate)?></td>                    
                        </tr>

<tr>
                            <td>অবসরের সময় পদবী</td>
                            <td><?=$lprDesignationName?></td>                       
                        </tr>

<tr>
                            <td>অবসরে যাওয়ার সময় মূল বেতন</td>
                            <td><?=$AnutoshikClass?></td>                       
                        </tr>

<tr>
                            <td>টেলিফোন বিল পরিশোধ কি না?</td>
                            <td><?=$TeliphoneName?></td>                       
                        </tr>

<tr>
                            <td>বিদ্যুৎ বিল পরিশোধ কি না?</td>
                            <td><?=$ElectricityBillName?></td>                       
                        </tr>

<tr>
                            <td>গাড়ী ভাড়া পরিশোধ কি না?</td>
                            <td><?=$VhechilefairName?></td>                       
                        </tr>

<tr>
                            <td>বাড়ী ভাড়া পরিশোধ কি না?</td>
                            <td><?=$HouseRentName?></td>                       
                        </tr>

<tr>
                            <td>উত্তরাধিকারীর ঘোষনা পত্র</td>
                            <td>
                                <a href="<?=$delcrearation?>">
                                    <span class="glyphicon glyphicon-paperclip"></span>
                                </a>
                            </td>                                            
                        </tr>

<tr>
                            <td>প্রত্যাশিত শেষ বেতনের সনদ(ই এল পি সি)</td>
                            <td>
                                <a href="<?=$ExpectedLastSal?>">
                                    <span class="glyphicon glyphicon-paperclip"></span>
                                </a>
                            </td>                                                
                        </tr>

<tr>
                            <td>যানবাহন ব্যবহারের তথ্য</td>
                            <td><?=$VheInfoName?></td>                       
                        </tr>

<tr>
                            <td>আঙ্গুলের ছাপ</td>
                            <td>
                                <a href="<?=$FringerTham?>">
                                    <span class="glyphicon glyphicon-paperclip"></span>
                                </a>
                            </td>     
                                               
                        </tr>

<tr>
                            <td>নমুনা স্বাক্ষর</td>
                            <td>
                                <a href="<?=$SignetureSample?>">
                                    <span class="glyphicon glyphicon-paperclip"></span>
                                </a>
                            </td>                       
                        </tr>

</table>
                </div>
            </div>
           
            <?php
            //স্বামী-স্ত্রীর তথ্য
            
            $stmt = $conn->prepare("SELECT 
            sp.id,
            sp.GovtId,
            sp.nameB,
            sp.nameE,
            d.DistrictName,
            sp.ocupation,
            sp.location                 
            FROM spouse sp
            LEFT JOIN district d ON(sp.district_id=d.id)
            WHERE sp.GovtId= ?");

$stmt->bind_param("s",$GovtId);
            $stmt->execute();

$result = $stmt->get_result();	
            $numrows=$result->num_rows;

$slno=0;
            while($row = $result->fetch_assoc())
            {

$id = $row["id"];
            $GovtId = $row["GovtId"];
            $nameB = $row["nameB"];
            $nameE = $row["nameE"];
            $DistrictName = $row["DistrictName"];
            $ocupation = $row["ocupation"];
            $location = $row["location"];
            }

if($numrows>0) 
            {
            ?>
<br>
<h4> স্বামী-স্ত্রীর তথ্য</h4>
                    <table class="table table-bordered table-striped table-condensed banglafont">

<tr>
                            <td>নাম (বাংলায়)</td>
                            <td><?=$nameB?></td>                       
                        </tr>

<tr>
                            <td>নাম (ইংরেজিতে)</td>
                            <td><?=$nameE?></td>                       
                        </tr>

<tr>
                            <td>জন্মগ্রহনকারী জেলা</td>
                            <td><?=$DistrictName?></td>                       
                        </tr>

<tr>
                            <td>কর্মস্থল ও যোগাযোগ</td>
                            <td><?=$location?></td>                       
                        </tr>

</table>
<?php
  }
//স্থায়ী ও বর্তমান ঠিকানা
  $stmt = $conn->prepare("SELECT 
                        em.id,
                        GovtId,
                        dis.DistrictName,
                        pmaddress,
                        craddress,
                        telephone,
                        mobile,
                        upz.UpazilaName,
                        em.upthana											
                        FROM empaddress em
                        LEFT JOIN district dis ON(em.district_id=dis.id)
						LEFT JOIN upazila upz ON(em.upazila_id=upz.id)	
                        WHERE em.GovtId= ?");

$stmt->bind_param("s",$GovtId);
                $stmt->execute();
                
                $result = $stmt->get_result();	
				$numrows=$result->num_rows;

$slno=0;
				 while($row = $result->fetch_assoc())
						{
					
                            $GovtId = $row["GovtId"];
                            $id = $row["id"];
                            $DistrictName = $row["DistrictName"];
                            $pmaddress = $row["pmaddress"];
                            $craddress = $row["craddress"];
                            $telephone = $row["telephone"];
                            $mobile = $row["mobile"];
                            $UpazilaName = $row["UpazilaName"];
                            $upthana = $row["upthana"];
                        }

if($numrows>0)
 {     
?>
<br>
 <h4> স্থায়ী ও বর্তমান ঠিকানা</h4>
                    <table class="table table-bordered table-striped table-condensed banglafont">                   
                
                        <tr>
                            <td>জেলা</td>
                            <td>উপজেলা/থানা</td>
                            <td>স্থায়ী ঠিকানা</td>
                            <td>বর্তমান ঠিকানা</td>
                            <td>টেলিফোন নং</td>
                            <td>মোবাইল নং</td>                      
                        </tr>                       
                     
                        <tr>             
                            <td><?=$DistrictName ?></td>
                            <td>
                                <?php
                                    if (empty($upthana)){
                                        echo $UpazilaName;
                                    }else{
                                        echo $upthana;
                                    }
                                 ?>
                            </td>
                            <td><?=$pmaddress ?></td>
                            <td><?=$craddress ?></td>
                            <td><?=bangladate($telephone) ?></td>
                            <td><?=bangladate($mobile) ?></td>
                       </tr>
                    </table>
<?php
 }
 //সন্তানের তথ্য
 $stmt = $conn->prepare("SELECT 
                                ch.id,
                                ch.GovtId,
                                ch.NameB,
                                ch.NameE,
                                ch.birthDate,
                                ch.sex,
                                d.disabilityName					         
                        FROM childinfo ch
                        LEFT JOIN disability d ON(ch.disability_id=d.id)	
                        WHERE ch.GovtId= ? ORDER BY ch.birthDate");

$stmt->bind_param("s",$GovtId);
                $stmt->execute();
                
                $result = $stmt->get_result();	
				$numrows=$result->num_rows;

$slno=0;

if($numrows>0)
{	
?>
<br>
<h4> সন্তানের তথ্য</h4>
                    <table class="table table-bordered table-striped table-condensed banglafont">                   
                
                        <tr>
                        <td>ক্রম নং</td>
                        <td>সন্তানের নাম(বাংলায়)</td>
                        <td>সন্তানের নাম ইংরেজিতে</td>
                        <td>জন্ম তারিখ</td>
                        <td>ছেলে/মেয়ে</td>
                        <td>প্রতিবন্ধী কি না?</td>                  
                        </tr>                       
                     <?php
                      while($row = $result->fetch_assoc())
                      {
                          $slno=$slno + 1;
                          $GovtId = $row["GovtId"];
                          $id = $row["id"];
                          $NameB = $row["NameB"];
                          $NameE = $row["NameE"];
                          $birthDate = $row["birthDate"];
                          $sex = $row["sex"];
                          $disabilityName = $row["disabilityName"];
                      ?>
                        <tr>              
                        <td><?=bangladate($slno)?></td>
                        <td><?=$NameB ?></td>
                        <td><?=$NameE ?></td>
                        <td><?=bangladate(ddateremove($birthDate)) ?></td>
                        <td><?=$sex ?></td>
                        <td><?=$disabilityName ?></td>
                       </tr>
                       <?php
						}
						?>
                    </table>
<?php
}
//ভাষাগত দক্ষতা
$stmt = $conn->prepare("SELECT 
                                id,
                                GovtId,
                                langname,
                                readsk,
                                writes,
                                speaks											
                        FROM emplanguage
                        WHERE GovtId= ?");

$stmt->bind_param("s",$GovtId);
                $stmt->execute();
                
                $result = $stmt->get_result();	
				$numrows=$result->num_rows;

$slno=0;
				
if($numrows>0)
{		
?>
<br>
<h4> ভাষাগত দক্ষতার তথ্য</h4>
                    <table class="table table-bordered table-striped table-condensed banglafont">                   
                
                        <tr>       
                        <td>ক্রমিক নং</td>                
                        <td>ভাষার নাম</td>
                        <td>পড়ায় দক্ষতা</td>
                        <td>লেখায় দক্ষতা</td>
                        <td>কথা বলায় দক্ষতা</td>        
                        </tr>                       
                     <?php
                      while($row = $result->fetch_assoc())
                      {
                      $slno=$slno +1;
                      $id = $row["id"];
                      $GovtId = $row["GovtId"];
                      $langname = $row["langname"];
                      $readsk = $row["readsk"];
                      $writes = $row["writes"];
                      $speaks = $row["speaks"];
                      ?>
                        <tr>   
                        <td><?=bangladate($slno) ?></td>    
                        <td><?=$langname ?></td>
                        <td><?=$readsk ?></td>
                        <td><?=$writes ?></td>
                        <td><?=$speaks ?></td>
                       </tr>
                       <?php
						}
						?>
                    </table>
<?php
}
//শিক্ষাগত তথ্য
$stmt = $conn->prepare("SELECT 
                            ed.id,
                            ed.GovtId,
                            ed.instName,
                            ed.subjectname,
                            d.DegreeName,
                            ed.passyear,
                            ed.exmresult,
                            ed.GpA,
                            ed.distinc					         
                        FROM educational ed
                        LEFT JOIN degree d ON(ed.degree_id=d.id)	
                        WHERE ed.GovtId= ?");

$stmt->bind_param("s",$GovtId);
                $stmt->execute();
                
                $result = $stmt->get_result();	
				$numrows=$result->num_rows;

$slno=0;
			
 if($numrows>0)
 {		
?>
<br>
<h4> শিক্ষাগত তথ্য</h4>
                    <table class="table table-bordered table-striped table-condensed banglafont">                   
                
                        <tr>
                        <td>ক্রমিক নং</td>
                        <td>শিক্ষা প্রতিষ্ঠানের নাম</td>
                        <td>পঠিত বিষয়</td>
                        <td>ডিগ্রীর নাম</td>
                        <td>পাশের বছর</td>
                        <td>পরীক্ষার রেজাল্ট</td>
                        <td>GPA/CGPA</td>
                        <td>ডিসটিংশন</td>	                    
                        </tr>                       
                     <?php
                     	 while($row = $result->fetch_assoc())
                          {
                              $slno=$slno +1;
                              $GovtId = $row["GovtId"];
                              $id = $row["id"];
                              $instName = $row["instName"];
                              $subjectname = $row["subjectname"];
                              $DegreeName = $row["DegreeName"];
                              $passyear = $row["passyear"];
                              $exmresult = $row["exmresult"];
                              $GpA = $row["GpA"];
                              $distinc = $row["distinc"];
                          ?>
  
                        <tr>              
                        <td><?=bangladate($slno) ?></td>
                        <td><?=$instName ?></td>
                        <td><?=$subjectname ?></td>
                        <td><?=$DegreeName ?></td>
                        <td><?=$passyear ?></td>
                        <td><?=$exmresult ?></td>
                        <td><?=$GpA ?></td>
                        <td><?=$distinc ?></td>
                       </tr>
                       <?php
						}
						?>
                    </table>
<?php
 }
//অন্যন্য পেশাগত তথ্য
$stmt = $conn->prepare("SELECT 
                            ap.id,
                            ap.GovtId,
                            sk.SklistName
                        
                        FROM apqualification ap
                        LEFT JOIN sklist sk ON(ap.sklist_id=sk.id)		
                        WHERE ap.GovtId= ?");

$stmt->bind_param("s",$GovtId);
                $stmt->execute();
                
                $result = $stmt->get_result();	
				$numrows=$result->num_rows;

$slno=0;

if($numrows>0)
  {		
?>
<br>
<h4> অন্যান্য পেশাগত তথ্য</h4>
                    <table class="table table-bordered table-striped table-condensed banglafont">                   
                
                        <tr>
                        <td>ক্রমিক নং</td>
	                    <td>অন্যান্য পেশাগত দক্ষতার নাম</td>                 
                        </tr>                       
                     <?php
                      while($row = $result->fetch_assoc())
                      {
                          $slno=$slno +1;
                          $id = $row["id"];
                          $GovtId = $row["GovtId"];
                          $SklistName = $row["SklistName"];
                      ?>
                        <tr>              
                        <td><?=bangladate($slno)?></td>
			             <td><?=$SklistName ?></td>
                       </tr>
                       <?php
						}
						?>
                    </table>
<?php
  }
  //প্রকাশনা ও জার্নাল
  $stmt = $conn->prepare("SELECT 
                            p.id,
                            p.GovtId,
                            p.pubsub,
                            pt.PubtypeName,
                            p.pubName,
                            p.pubDate
                    
                        FROM publication p
                        LEFT JOIN pubtype pt ON(p.pubtype_id=pt.id)	
                        WHERE p.GovtId= ?");

$stmt->bind_param("s",$GovtId);
                $stmt->execute();
                
                $result = $stmt->get_result();	
				$numrows=$result->num_rows;

$slno=0;
				 
 if($numrows>0)
 {	
?>
<br>
<h4> প্রকাশনা ও জার্নাল</h4>
                    <table class="table table-bordered table-striped table-condensed banglafont">                   
                
                        <tr>
                        <td>ক্রমিক নং</td>
                        <td>বিষয়</td>
                        <td>প্রকাশনার ধরণ</td>
                        <td>প্রকাশনার নাম</td>
                        <td>প্রকাশের তারিখ</td>               
                        </tr>                       
                     <?php
                     while($row = $result->fetch_assoc())
                     {
                         $slno=$slno +1;
                         $id = $row["id"];
                         $GovtId = $row["GovtId"];
                         $pubsub = $row["pubsub"];
                         $PubtypeName = $row["PubtypeName"];
                         $pubName = $row["pubName"];
                         $pubDate = $row["pubDate"];
                     ?>
                        <tr>              
                            <td><?=bangladate($slno)?></td>
                            <td><?=$pubsub ?></td>
                            <td><?=$PubtypeName ?></td>				
                            <td><?=$pubName ?></td>
                            <td><?=bangladate(ddateremove($pubDate)) ?></td>
                       </tr>
                       <?php
						}
						?>
                    </table>
<?php
 }
 //সম্মাননা ও পুরস্কার
 $stmt = $conn->prepare("SELECT 
                            id,
                            GovtId,
                            titleaward,
                            ground,
                            awardDate
                        
                        FROM haward
                        WHERE GovtId= ?");

$stmt->bind_param("s",$GovtId);
                $stmt->execute();
                
                $result = $stmt->get_result();	
				$numrows=$result->num_rows;

$slno=0;

if($numrows>0)
{	
 ?>
 <br>
 <h4> সম্মাননা ও পুরস্কার</h4>
                    <table class="table table-bordered table-striped table-condensed banglafont">                   
                
                        <tr>
                        <td>ক্রমিক নং</td>
                        <td>পুরস্কারের নাম</td>
                        <td>পুরস্কার পাওয়ার কারণ</td>
                        <td>পুরুস্কার পাওয়ার তারিখ</td>         
                        </tr>                       
                     <?php
                      while($row = $result->fetch_assoc())
                      {
                          $slno=$slno +1;
                          $id = $row["id"];
                          $GovtId = $row["GovtId"];
                          $titleaward = $row["titleaward"];
                          $ground = $row["ground"];
                          $awardDate = $row["awardDate"];
                      ?>
                        <tr>              
                        <td><?=bangladate($slno)?></td>
                        <td><?=$titleaward ?></td>
                        <td><?=$ground ?></td>
                        <td><?=bangladate(ddateremove($awardDate)) ?></td>
                       </tr>
                       <?php
						}
						?>
                    </table>
 <?php
}
//অভ্যন্তরীণ প্রশিক্ষণ
$stmt = $conn->prepare("SELECT 
                                id,
                                GovtId,
                                coursetitle,
                                instName,
                                instLocation,
                                startDate,
                                endDate,
                                exmresult											
                        FROM localtraining
                        WHERE GovtId= ?");

$stmt->bind_param("s",$GovtId);
                $stmt->execute();
                
                $result = $stmt->get_result();	
				$numrows=$result->num_rows;

$slno=0;

if($numrows>0)
  {
 ?>
 <br>
 <h4> অভ্যন্তরীণ প্রশিক্ষণ</h4>
                    <table class="table table-bordered table-striped table-condensed banglafont">                   
                
                        <tr>
                        <td>ক্রমিক নং</td>
                        <td>কোর্স টাইটেল</td>
                        <td>প্রশিক্ষণ প্রদানকারী প্রতিষ্ঠানের নাম</td>
                        <td>লোকেশন</td>
                        <td>প্রশিক্ষণ শুরু তারিখ</td>
                        <td>প্রশিক্ষণ শেষের তারিখ</td>
                        <td>প্রশিক্ষণের ফলাফল</td>         
                        </tr>                       
                     <?php
                     while($row = $result->fetch_assoc())
                     {
                         $slno=$slno +1;
                         $id = $row["id"];
                         $GovtId = $row["GovtId"];
                         $coursetitle = $row["coursetitle"];
                         $instName = $row["instName"];
                         $instLocation = $row["instLocation"];
                         $startDate = $row["startDate"];
                         $endDate = $row["endDate"];
                         $exmresult = $row["exmresult"];
                     ?>
                        <tr>              
                        <td><?=bangladate($slno)?></td>
                        <td><?=$coursetitle ?></td>
                        <td><?=$instName ?></td>
                        <td><?=$instLocation ?></td>
                        <td><?=bangladate(ddateremove($startDate)) ?></td>
                        <td><?=bangladate(ddateremove($endDate)) ?></td>
                        <td><?=$exmresult ?></td>
                       </tr>
                       <?php
						}
						?>
                    </table>
<?php
  }	
  //বৈদেশিক প্রশিক্ষণ
  $stmt = $conn->prepare("SELECT 
                            f.id,
                            f.GovtId,
                            f.coursetitle,
                            f.instName,
                            f.instLocation,
                            c.CountryName,
                            f.startDate,
                            f.endDate,
                            f.exmresult					         
                        FROM foreigntraining f
                            LEFT JOIN country c ON(f.country_id=c.id)	
                        WHERE f.GovtId= ?");

$stmt->bind_param("s",$GovtId);
                $stmt->execute();
                
                $result = $stmt->get_result();	
				$numrows=$result->num_rows;

$slno=0;

if($numrows>0)
{
  ?>
<br>
<h4> বৈদেশিক প্রশিক্ষণ</h4>
                    <table class="table table-bordered table-striped table-condensed banglafont">                   
                
                        <tr>
                        <td>ক্রমিক নং</td>
                        <td>কোর্স টাইটেল</td>
                        <td>প্রশিক্ষণ প্রদানকারী প্রতিষ্ঠানের নাম</td>
                        <td>লোকেশন</td>
                        <td>দেশের নাম</td>
                        <td>প্রশিক্ষণ শুরুর তারিখ</td>
                        <td>প্রশিক্ষণ শেষের তারিখ</td>
                        <td>প্রশিক্ষণের ফলাফল</td>     
                        </tr>                       
                     <?php
                      while($row = $result->fetch_assoc())
                      {
                          $slno=$slno +1;
                          $id = $row["id"];
                          $GovtId = $row["GovtId"];
                          $coursetitle = $row["coursetitle"];
                          $instName = $row["instName"];
                          $instLocation = $row["instLocation"];
                          $CountryName = $row["CountryName"];
                          $startDate = $row["startDate"];
                          $endDate = $row["endDate"];
                          $exmresult = $row["exmresult"];
                      ?>
                        <tr>              
                        <td><?=bangladate($slno)?></td>
                        <td><?=$coursetitle ?></td>
                        <td><?=$instName ?></td>
                        <td><?=$instLocation ?></td>
                        <td><?=$CountryName ?></td>
                        <td><?=bangladate(ddateremove($startDate)) ?></td>
                        <td><?=bangladate(ddateremove($endDate)) ?></td>
                        <td><?=$exmresult ?></td>
                       </tr>
                       <?php
						}
						?>
                    </table>
<?php    
}
//বিদেশ ভ্রমণের তথ্য
$stmt = $conn->prepare("SELECT 
                            ft.id,
                            ft.GovtId,
                            c.CountryName,
                            ft.purpose,
                            ft.startDate,
                            ft.endDate
                    
                        FROM frtravel ft
                            LEFT JOIN country c ON(ft.country_id=c.id)	
                        WHERE ft.GovtId= ?");

$stmt->bind_param("s",$GovtId);
                $stmt->execute();
                
                $result = $stmt->get_result();	
				$numrows=$result->num_rows;

$slno=0;

if($numrows>0)
   {
?>
<br>
<h4> বিদেশ ভ্রমণের তথ্য</h4>
                    <table class="table table-bordered table-striped table-condensed banglafont">                   
                
                        <tr>
                        <td>ক্রমিক নং</td>
                        <td>দেশ</td>
                        <td>উদ্দেশ্য</td>
                        <td>শুরুর তারিখ</td>
                        <td>শেষের তারিখ</td>
                        </tr>                       
                     <?php
                      while($row = $result->fetch_assoc())
                      {
                          $slno=$slno +1;
                          $id = $row["id"];
                          $GovtId = $row["GovtId"];
                          $CountryName = $row["CountryName"];
                          $purpose = $row["purpose"];
                          $startDate = $row["startDate"];
                          $endDate = $row["endDate"];
                      ?>
                        <tr>              
                        <td><?=bangladate($slno)?></td>
                        <td><?=$CountryName ?></td>
                        <td><?=$purpose ?></td>
                        <td><?=bangladate(ddateremove($startDate)) ?></td>
                        <td><?=bangladate(ddateremove($endDate)) ?></td>
                       </tr>
                       <?php
						}
						?>
                    </table>
<?php

}	
   //স্থান পরিদর্শন/ভ্রমন সংক্রান্ত তথ্য
   $stmt = $conn->prepare("SELECT 
                                p.id,
                                p.GovtId,
                                dis.DistrictName,
                                p.placename,
                                p.purpose,
                                p.startDate,
                                p.endDate
                                
                        FROM placeinspaction p
                            LEFT JOIN district dis ON(p.district_id=dis.id)	
                        WHERE p.GovtId= ?");

$stmt->bind_param("s",$GovtId);
                $stmt->execute();
                
                $result = $stmt->get_result();	
				$numrows=$result->num_rows;

$slno=0;

if($numrows>0)
 {
?>
<br>
<h4> স্থান পরিদর্শন/ভ্রমণ সংক্রান্ত তথ্য</h4>
                    <table class="table table-bordered table-striped table-condensed banglafont">                   
                
                        <tr>
                        <td>ক্রমিক নং</td>
                        <td>জেলা</td>
                        <td>লোকেশন</td>
                        <td>উদ্দেশ্য</td>
                        <td>শুরুর তারিখ</td>
                        <td>শেষের তারিখ</td>
                        </tr>                       
                     <?php
                      while($row = $result->fetch_assoc())
                      {
                          $slno=$slno +1;
                          $id = $row["id"];
                          $GovtId = $row["GovtId"];
                          $DistrictName = $row["DistrictName"];
                          $placename = $row["placename"];
                          $purpose = $row["purpose"];
                          $startDate = $row["startDate"];
                          $endDate = $row["endDate"];
                      ?>
                        <tr>              
                        <td><?=bangladate($slno)?></td>
                        <td><?=$DistrictName ?></td>
                        <td><?=$placename ?></td>
                        <td><?=$purpose ?></td>
                        <td><?=bangladate(ddateremove($startDate)) ?></td>
                        <td><?=bangladate(ddateremove($endDate)) ?></td>
                       </tr>
                       <?php
						}
						?>
                    </table>
<?php
 }		
 //অন্যান্য প্রতিষ্ঠানে চাকুরির তথ্য
 $stmt = $conn->prepare("SELECT 
                             	id,
                                GovtId,
                                empaddress,
                                servicetype,
                                designations,
                                startDate,
                                endDate
                        
                        FROM servicehistry	
                        WHERE GovtId= ?");

$stmt->bind_param("s",$GovtId);
                $stmt->execute();
                
                $result = $stmt->get_result();	
				$numrows=$result->num_rows;

$slno=0;

if($numrows>0) 
 {
?>
<br>
<h4> অন্যান্য প্রতিষ্ঠানে চাকুরির তথ্য</h4>
                    <table class="table table-bordered table-striped table-condensed banglafont">                   
                
                        <tr>
                        <td>ক্রমিক নং</td>
                        <td>প্রতিষ্ঠানের নাম ও ঠিকানা</td>
                        <td>চাকুরির ধরণ</td>
                        <td>পদবী</td>
                        <td>শুরুর তারিখ</td>
                        <td>শেষের তারিখ</td>
                        </tr>                       
                     <?php
                      while($row = $result->fetch_assoc())
                      {
                          $slno=$slno +1;
                          $id = $row["id"];
                          $GovtId = $row["GovtId"];
                          $empaddress = $row["empaddress"];
                          $servicetype = $row["servicetype"];
                          $designations = $row["designations"];
                          $startDate = $row["startDate"];
                          $endDate = $row["endDate"];
                      ?>
                        <tr>              
                        <td><?=bangladate($slno)?></td>
                        <td><?=$empaddress ?></td>
                        <td><?=$servicetype ?></td>
                        <td><?=$designations ?></td>
                        <td><?=bangladate(ddateremove($startDate)) ?></td>
                        <td><?=bangladate(ddateremove($endDate)) ?></td>
                       </tr>
                       <?php
						}
						?>
                    </table>
<?php
 }
 //ছুটির তথ্য
 $stmt = $conn->prepare("SELECT 
                             	eml.id,
                                eml.GovtId,
                                lt.LeavetypeName,
                                eml.startDate,
                                eml.endDate,
                                eml.levduration					             
                        FROM empleave eml
                            LEFT JOIN leavetype lt ON(eml.leavetype_id=lt.id)	
                        WHERE eml.GovtId= ?");

$stmt->bind_param("s",$GovtId);
                $stmt->execute();
                
                $result = $stmt->get_result();	
				$numrows=$result->num_rows;

$slno=0;

if($numrows>0)
  {
?>
<br>

<h4> ছুটির তথ্য</h4>
                    <table class="table table-bordered table-striped table-condensed banglafont">                   
                
                        <tr>
                        <td>ক্রমিক নং</td>
                        <td>ছুটির ধরণ</td>
                        <td>শুরুর তারিখ</td>
                        <td>শেষের তারিখ</td>
                        <td>কত দিনের জন্য</td>
                        </tr>                       
                     <?php
                      while($row = $result->fetch_assoc())
                      {
                      $slno=$slno +1;    
                      $id = $row["id"];
                      $GovtId = $row["GovtId"];
                      $LeavetypeName = $row["LeavetypeName"];
                      $startDate = $row["startDate"];
                      $endDate = $row["endDate"];
                      $levduration = $row["levduration"];
                      ?>
                        <tr>              
                         <td><?=bangladate($slno)?></td>
                        <td><?=$LeavetypeName ?></td>
                        <td><?=bangladate(ddateremove($startDate)) ?></td>
                        <td><?=bangladate(ddateremove($endDate)) ?></td>
                        <td><?=bangladate(ddateremove($levduration)) ?> দিন</td>
			       
                       </tr>
                       <?php
						}
						?>
                    </table>
<?php
  }		
  //পদায়ন সংক্রান্ত তথ্য
  $stmt = $conn->prepare("SELECT 
                             	pr.id,
                                GovtId,
                                d.DesignationName,
                                pr.experiance,
                                ex.PexampassName,
                                pr.apointDate,
                                psc.PscrecomName,
                                pr.pscDate,
                                pr.sarokNo,
                                pr.permDate,
                                sg.GradeName,
                                pr.timesDate,
                                sd.FlagName
                                
                        FROM promotion pr
                            LEFT JOIN designation d ON(pr.designation_id=d.id)	
                            LEFT JOIN selectiongrade sd ON(pr.selectiongrade_id=sd.id)	
                            LEFT JOIN pexampass ex ON(pr.pexampass_id=ex.id)	
                            LEFT JOIN pscrecom psc ON(pr.pscrecom_id=psc.id)	
                            LEFT JOIN grade sg ON(pr.sgrade_id=sg.id)	
                        WHERE pr.GovtId= ?");

$stmt->bind_param("s",$GovtId);
                $stmt->execute();
                
                $result = $stmt->get_result();	
				$numrows=$result->num_rows;

$slno=0;

if($numrows>0)
{
?>
<br>
<h4> পদোন্নতি সংক্রান্ত তথ্য</h4>
                    <table class="table table-bordered table-striped table-condensed banglafont">                   
                
                        <tr>
                        <td>ক্রমিক নং</td>
                        <td>প্রত্যাশিত পদোন্নতির পদ</td>
                        <td>অভিজ্ঞতা ফিডার পদে</td>
                        <td>পদোন্নতি পরীক্ষায় উর্ত্তীণ?</td>
                        <td>অস্থায়ীভাবে নিয়োগের তারিখ</td>
                        <td>পিএসসির সুপারিশ আছে?</td>
                        <td>থাকলে তারিখ</td>
                        <td>ও স্বারক নং</td>
                        <td>স্থায়ীভাবে নিয়োগের তারিখ</td>
                        <td>সিলেকশন গ্রেড কি না?</td>
                        <td>সিলেকশন গ্রেড</td>
                        <td>টাইম স্কেল প্রাপ্তির তারিখ</td>
                       
                        </tr>                       
                     <?php
                     	 while($row = $result->fetch_assoc())
                          {
                              
                              $slno=$slno +1;
                              $id = $row["id"];
                              $GovtId = $row["GovtId"];
                              $DesignationName = $row["DesignationName"];
                              $experiance = $row["experiance"];
                              $PexampassName = $row["PexampassName"];
                              $apointDate = $row["apointDate"];
                              $PscrecomName = $row["PscrecomName"];
                              $pscDate = $row["pscDate"];
                              $sarokNo = $row["sarokNo"];
                              $permDate = $row["permDate"];
                              $FlagName = $row["FlagName"];
                              $GradeName = $row["GradeName"];
                              $timesDate = $row["timesDate"];
                          ?>
  
                        <tr>              
                        <td><?=bangladate($slno)?></td>
                        <td><?=$DesignationName ?></td>
                        <td><?=$experiance ?></td>
                        <td><?=$PexampassName ?></td>
                        <td><?=bangladate(ddateremove($apointDate)) ?></td>
                        <td><?=$PscrecomName ?></td>
                        <td><?=bangladate(ddateremove($pscDate)) ?></td>
                        <td><?=$sarokNo ?></td>
                        <td><?=bangladate(ddateremove($permDate)) ?></td>
                        <td><?=$FlagName ?></td>
                        <td><?=$GradeName ?></td>
                        <td><?=bangladate(ddateremove($timesDate)) ?></td>		       
			       
                       </tr>
                       <?php
						}
						?>
                    </table>
<?php    
}	
        //পোষ্টিং সংক্রান্ত তথ্য
        $stmt = $conn->prepare("SELECT 
        ps.id,
        GovtId,
        pt.PostingtypeName,
        o.OfficeName,
        plocattion,
        stratDate,
        endDate,
        g.PayScale,
        ps.postcomments

FROM postingrecord ps
        LEFT JOIN postingtype pt ON(ps.postingtype_id=pt.id)	
        LEFT JOIN office o ON(ps.office_id=o.id)	
        LEFT JOIN grade g ON(ps.payscal_id=g.id)	
        WHERE ps.GovtId= ? ORDER BY ps.stratDate");

$stmt->bind_param("s",$GovtId);
        $stmt->execute();

$result = $stmt->get_result();	
        $numrows=$result->num_rows;

$slno=0;

if($numrows>0)
{
?>
<br>
<h4> পদায়ন ও বদলি সংক্রান্ত তথ্য</h4>
                    <table class="table table-bordered table-striped table-condensed banglafont">                   
                
                        <tr>
                        <td>ক্রমিক নং</td>
                        <td>পোস্টিংয়ের ধরণ</td>
                        <td>অফিস</td>
                        <td>পোস্টিং নোট</td>
                        <td>শুরুর তারিখ</td>
                        <td>শেষের তারিখ</td>
                        <td>পে-স্কেল</td>
                        <td>মন্তব্য</td>
                       
                        </tr>                       
                     <?php
                             while($row = $result->fetch_assoc())
                             {
                                 $slno=$slno +1;
                                 $id = $row["id"];
                                 $GovtId = $row["GovtId"];
                                 $PostingtypeName = $row["PostingtypeName"];
                                 $OfficeName = $row["OfficeName"];
                                 $plocattion = $row["plocattion"];
                                 $stratDate = $row["stratDate"];
                                 $endDate = $row["endDate"];
                                 $PayScale = $row["PayScale"];
                                 $postcomments = $row["postcomments"];
                     
                               ?>
                        <tr>              
                        <td><?=bangladate($slno)?></td>
                        <td><?=$PostingtypeName ?></td>
                        <td><?=$OfficeName ?></td>
                        <td><?=$plocattion ?></td>
                        <td><?=bangladate(ddateremove($stratDate)) ?></td>
                        <td><?=bangladate(ddateremove($endDate)) ?></td>
                        <td><?=$PayScale ?></td> 
                        <td><?=$postcomments ?></td>                       
                       </tr>
                       <?php
						}
						?>
                    </table>
<?php
}  
//অডিট আপত্তির তথ্য
$stmt = $conn->prepare("SELECT 
                             	id,
                                GovtId,
                                AuditlObj,
                                genralObj,
                                anualObj,
                                advanceObj,
                                remark
                        
                        FROM auditobj
                        WHERE GovtId= ?");

$stmt->bind_param("s",$GovtId);
                $stmt->execute();
                
                $result = $stmt->get_result();	
				$numrows=$result->num_rows;

$slno=0;

if($numrows>0)
 {
  ?>
  <br>
  <h4> অডিট আপত্তির তথ্য</h4>
                    <table class="table table-bordered table-striped table-condensed banglafont">                   
                
                        <tr>
                        <td>ক্রমিক নং</td>
                        <td>আপত্তির বর্তমান অবস্থা</td>
                        <td>সাধারণ আপত্তি ও ব্রডশিট জবাবের তথ্য</td>
                        <td>বার্ষিক আপত্তি ও ব্রডশিট জবাবের তথ্য</td>
                        <td>অগ্রিম আপত্তি ও ব্রডশিট জবাবের তথ্য</td>
                        <td>মন্তব্য</td>
                       
                        </tr>                       
                        <?php
                        while($row = $result->fetch_assoc())
						{
                            $slno=$slno +1;
                            $id = $row["id"];
                             $GovtId = $row["GovtId"];
                             $AuditlObj = $row["AuditlObj"];
                             $genralObj = $row["genralObj"];
                             $anualObj = $row["anualObj"];
                             $advanceObj = $row["advanceObj"];
                             $remark = $row["remark"];
			            	
                        ?>
                        <tr>              
                        <td><?=bangladate($slno) ?></td>
                        <td><?=$AuditlObj ?></td>
                        <td><?=$genralObj ?></td>
                        <td><?=$anualObj ?></td>
                        <td><?=$advanceObj ?></td>
                        <td><?=$remark ?></td>                        
                       </tr>
                       <?php
						}
						?>
                    </table>
  <?php   
 }	
 //এসিআর সংক্রান্ত তথ্য
 $stmt = $conn->prepare("SELECT 
                             	a.id,
                                a.GovtId,
                                y.yname,
                                a.perdscp,
                                a.remark					             
                        FROM acrinfo a
                        LEFT JOIN yearlist y ON(a.yearlist_id=y.id)
                        WHERE a.GovtId= ?");

$stmt->bind_param("s",$GovtId);
                $stmt->execute();
                
                $result = $stmt->get_result();	
				$numrows=$result->num_rows;

$slno=0;

if($numrows>0)
  {
  ?>
  <br>
  <h4> এসিআর সংক্রান্ত তথ্য</h4>
                    <table class="table table-bordered table-striped table-condensed banglafont">                   
                
                        <tr>
                        <td>ক্রমিক নং</td>
                        <td>বছর</td>
                        <td>বর্ণনা</td>
                        <td>মন্তব্য</td>
                       
                        </tr>                       
                     <?php
                      while($row = $result->fetch_assoc())
                      {
                          $slno=$slno +1;
                          $id = $row["id"];
                          $GovtId = $row["GovtId"];
                          $yname = $row["yname"];
                          $perdscp = $row["perdscp"];
                          $remark = $row["remark"];
                      ?>

<?php    
  }
  //শৃঙ্খলাজনিত তথ্য
  $stmt = $conn->prepare("SELECT 
                            d.id,
                            d.GovtId,
                            dc.DiciplincatagoryName,
                            d.descrip,
                            d.remarks
                        
                        FROM diciplinary d
                            LEFT JOIN diciplincatagory dc ON(d.diciplincatagory_id=dc.id)	
                        WHERE d.GovtId= ?");

$stmt->bind_param("s",$GovtId);
                $stmt->execute();
                
                $result = $stmt->get_result();	
				$numrows=$result->num_rows;

$slno=0;

if($numrows>0)
   {
?>
<br>
<h4> শৃঙ্খলাজনিত তথ্য</h4>
                    <table class="table table-bordered table-striped table-condensed banglafont">                   
                
                        <tr>
                        <td>ক্রমিক নং</td>
                        <td>শৃংখলার শ্রেণী</td>
                        <td>বর্ণনা</td>
                        <td>মন্তব্য</td>                       
                        </tr>                       
                     <?php
                      while($row = $result->fetch_assoc())
                      {
                          $slno=$slno +1;
                          $id = $row["id"];
                          $GovtId = $row["GovtId"];
                          $DiciplincatagoryName = $row["DiciplincatagoryName"];
                          $descrip = $row["descrip"];
                          $remarks = $row["remarks"];
                      ?>
                        <tr>              
                        <td><?=bangladate($slno)?></td>
                        <td><?=$DiciplincatagoryName ?></td>
                        <td><?=$descrip ?></td>
                        <td><?=$remarks ?></td>
                        </tr>
<?php       
   } 
}		
 ?>

</div>
    </div>
</div>

</script>

${this.title}

Code Editor : pdsreport.php