Gecko [ 43.229.15.234 ]

Name	Size	Permission
ajaxselection.php	4.03 KB	-rw-r--r--
circleoffice.php	9.26 KB	-rw-r--r--
designation.php	9.16 KB	-rw-r--r--
districtoffice.php	9.2 KB	-rw-r--r--
empentryGraph.php	4.32 KB	-rw-r--r--
emplist_organogram.php	4.65 KB	-rw-r--r--
emplist_organogram_office.php	6.41 KB	-rw-r--r--
emplistexecutive.php	10.43 KB	-rw-r--r--
emplistexecutivesummary.php	6.98 KB	-rw-r--r--
emplistofficewise.php	10.06 KB	-rw-r--r--
emptime_all.php	9.67 KB	-rw-r--r--
emptime_all_circle.php	11.72 KB	-rw-r--r--
emptime_all_report.php	13.04 KB	-rw-r--r--
emptime_circleoffice.php	9.83 KB	-rw-r--r--
emptime_designation.php	9.96 KB	-rw-r--r--
emptime_designation_circleoffi...	9.94 KB	-rw-r--r--
emptime_designation_districtof...	9.85 KB	-rw-r--r--
emptime_designation_headoffice...	9.83 KB	-rw-r--r--
emptime_districtoffice.php	9.74 KB	-rw-r--r--
emptime_headoffice.php	9.72 KB	-rw-r--r--
graph_region.php	3.16 KB	-rw-r--r--
headoffice -backup.php	13.66 KB	-rw-r--r--
headoffice.php	13.7 KB	-rw-r--r--
hrmrole.php	491 B	-rw-r--r--
office.php	9.05 KB	-rw-r--r--
repGraph.php	2.69 KB	-rw-r--r--
rep_applicat_training.php	6.94 KB	-rw-r--r--
rep_applicatlist_training.php	7.38 KB	-rw-r--r--
rep_class_subject.php	8.38 KB	-rw-r--r--
rep_class_year.php	8.49 KB	-rw-r--r--
rep_directorate.php	7.96 KB	-rw-r--r--
rep_directorate_subject.php	8.4 KB	-rw-r--r--
rep_directorate_year.php	8.54 KB	-rw-r--r--
rep_lpr.php	10.2 KB	-rw-r--r--
rep_male_female.php	3.35 KB	-rw-r--r--
rep_religion.php	4.35 KB	-rw-r--r--
rep_training_circleoffice.php	5.53 KB	-rw-r--r--
rep_training_districtoffice.ph...	5.64 KB	-rw-r--r--
rep_training_headoffice.php	5.12 KB	-rw-r--r--
rep_userwise.php	8.65 KB	-rw-r--r--
rep_yearlist.php	8.18 KB	-rw-r--r--
report.php	564 B	-rw-r--r--
report_applicant_training.php	5.39 KB	-rw-r--r--
report_applicant_training_grap...	3.44 KB	-rw-r--r--
report_applicantlist_training....	8.81 KB	-rw-r--r--
report_editor.php	10.95 KB	-rw-r--r--
report_editor_offdesignation.p...	3.55 KB	-rw-r--r--
report_editor_time.php	10.07 KB	-rw-r--r--
report_editor_time_circle.php	4.8 KB	-rw-r--r--
report_prl.php	2.43 KB	-rw-r--r--
report_training.php	7.24 KB	-rw-r--r--
reportlist -backup.php	2.09 KB	-rw-r--r--
reportlist.php	3.33 KB	-rw-r--r--
reportlist_applicant_training....	957 B	-rw-r--r--
reportlist_applicantlist_train...	1.12 KB	-rw-r--r--
reportlist_offdesignation.php	664 B	-rw-r--r--
reportlist_time.php	1.22 KB	-rw-r--r--
reportlist_time_circle.php	641 B	-rw-r--r--
reportlist_training.php	1.2 KB	-rw-r--r--
salaccountsreport.php	39.81 KB	-rw-r--r--
salaccountsreport_govtid.php	12.41 KB	-rw-r--r--
training.php	7.37 KB	-rw-r--r--

Code Editor : designation.php

<div class="container backcolor banglafont">
    <div class="row">
        <div class="col-md-12">
            <?php

// prepare and bind
                $stmt = $conn->prepare("SELECT * FROM designation WHERE id = ? ORDER BY id ASC");
                $stmt->bind_param("i", $designation_id);
                $stmt->execute();

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

while ($row = $result->fetch_assoc()) {
                    $DesignationName = $row["DesignationName"];
                }

// prepare and bind
                $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,		
											g.LprDate,		
											ld.DesignationName AS lprDesignationName,		
											g.AnutoshikClass,												
											tb.TeliphoneName,		
											eb.ElectricityBillName,		
											vf.VhechilefairName,		
											hr.HouseRentName,		
											g.delcrearation,		
											g.ExpectedLastSal,		
											vinf.VheInfoName,		
											g.FringerTham,													
											upazila.UpazilaName									
									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 empaddress addr 
										         INNER JOIN upazila ON(addr.upazila_id=upazila.id)
											 ON(g.GovtId=addr.GovtId)	  																														    
									WHERE 1=1 and g.designation_id=? ORDER BY g.GovtId ASC");

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

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

if($numrows==0) exit('No rows');
                $slno=0;
?>
                 <br/>
                <h4 class="text-center"><?=$DesignationName?>&nbsp; - কর্মকর্তা/কর্মচারীর সংখ্যা-<?=bangladate($numrows)?></h4>
                
				<table class="table table-bordered table-striped table-condensed banglafont">
    
                    <thead>
					<th>ক্রমিক</th>
					<th>PIMS আইডি</th>
					<th>নাম(বাংলায়)</th>					
					<th>পদবী</th>
					<th>নিজ জেলা</th>			
					<th>উপজেলা</th>
					<th>অফিসের নাম</th>
					<th>বর্তমান কর্মস্থলে যোগদানের তারিখ</th>
					<th>বর্তমান কর্মস্থলে কর্মকাল</th>
					<th>জন্ম তারিখ</th>
					<th>চাকরিতে প্রথম যোগদানের তারিখ</th>
					<th>অবসর প্রস্তুতি ছুটির তারিখ</th>
					<th>অবসর গ্রহণের তারিখ</th>
					<th>মন্তব্য</th>
                    </thead>
    
                    <tbody>
    
                    <hr/>
                    <?php
            
                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 = $row['PassIssueDate'];
					$PassLastDate = $row['PassLastDate'];
					$dob = $row['dob'];
					$BirthCertificateNo = $row['BirthCertificateNo'];
					$PersonalEmail = $row['PersonalEmail'];
					$OfficialEmail = $row['OfficialEmail'];
					$DistrictName = $row['DistrictName'];
					$DesignationName = $row['DesignationName'];
					$OfficeName = $row['OfficeName'];
					$CaderName = $row['CaderName'];
					$CaderDate = $row['CaderDate'];
					$BatchNo = $row['BatchNo'];
					$FredomFighter_id = $row['FredomFighter_id'];
					$FredomChildGrand_id = $row['FredomChildGrand_id'];
					$triballist_id = $row['triballist_id'];
					$sex_id = $row['sex_id'];
					$MaritualStatus_id = $row['MaritualStatus_id'];
					$religion_id = $row['religion_id'];
					$profsubject_id = $row['profsubject_id'];
					$GradeName = $row['GradeName'];
					$PayScale = $row['PayScale'];
					$SalBasic = $row['SalBasic'];
					$jointype_id = $row['jointype_id'];
					$ProjectName = $row['ProjectName'];
					$emptype_id = $row['emptype_id'];
					$FirstJoinDate = $row['FirstJoinDate'];
					$EedJoinDate = $row['EedJoinDate'];
					$EedCDJoinDate = $row['EedCDJoinDate'];
					$CLJoinDate = $row['CLJoinDate'];
					$PLJoindate = $row['PLJoindate'];
					$RegularDate = $row['RegularDate'];
					$PermanentDate = $row['PermanentDate'];
					$GovtResident_id = $row['GovtResident_id'];
					$LprDate = $row['LprDate'];
					$LprDesignation_id = $row['LprDesignation_id'];
					$AnutoshikClass = $row['AnutoshikClass'];
					$khotianinfo = $row['khotianinfo'];
					$Teliphone_id = $row['Teliphone_id'];
					$ElectricityBill_id = $row['ElectricityBill_id'];
					$Vhechilefair_id = $row['Vhechilefair_id'];
					$HouseRent_id = $row['HouseRent_id'];
					$delcrearation = $row['delcrearation'];
					$ExpectedLastSal = $row['ExpectedLastSal'];
					$VheInfo_id = $row['VheInfo_id'];
					$FringerTham = $row['FringerTham'];
					$AuditObject = $row['AuditObject'];
					$SignetureSample = $row['SignetureSample'];
					$UpazilaName = $row['UpazilaName'];

$d1 = new DateTime(date("Y-m-d"));
					$d2 = new DateTime($CLJoinDate);
					$interval = $d1->diff($d2);
					$diffInYears   = $interval->y;
					$diffInMonths  = $interval->m;

if ($CLJoinDate=='1970-01-01'){
						$timeintval="";
					}
					else{
						$timeintval=bangladate($diffInYears).' '.'বছর'.' '.bangladate($diffInMonths).' '.'মাস';

}
				
                    ?>

${this.title}

Code Editor : designation.php