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 : general_report.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']);
 
 $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=ddateremove(date("d/m/Y", strtotime(str_replace('-','/',$row['PassIssueDate']))));						
                            $PassLastDate=ddateremove(date("d/m/Y", strtotime(str_replace('-','/',$row['PassLastDate']))));						
                            $dob=ddateremove(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=ddateremove(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=ddateremove(date("d/m/Y", strtotime(str_replace('-','/',$row['FirstJoinDate']))));						
                            $EedJoinDate=ddateremove(date("d/m/Y", strtotime(str_replace('-','/',$row['EedJoinDate']))));						
                            $EedCDJoinDate=ddateremove(date("d/m/Y", strtotime(str_replace('-','/',$row['EedCDJoinDate']))));						
                            $CLJoinDate=ddateremove(date("d/m/Y", strtotime(str_replace('-','/',$row['CLJoinDate']))));						
                            $PLJoindate=ddateremove(date("d/m/Y", strtotime(str_replace('-','/',$row['PLJoindate']))));					
                            $RegularDate=ddateremove(date("d/m/Y", strtotime(str_replace('-','/',$row['RegularDate']))));						
                            $PermanentDate=ddateremove(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="lightbox222" 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($PassIssueDate)?></td>                       
                        </tr>

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

<tr>
                            <td>জন্ম তারিখ</td>
                            <td><?=bangladate($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($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>

</table>
                </div>

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

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

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

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

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

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

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

<tr>
                            <td>চাকুরি স্থায়ীকরনের তারিখ</td>
                            <td><?=bangladate($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>
            
        </div>
    </div>
</div>

</script>

${this.title}

Code Editor : general_report.php