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 : emptime_all_report.php

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

$roleid=$_SESSION["userrole_id"];
$circle=$_SESSION["circleoffice_id"];
$dist=$_SESSION["districtoffice_id"];

if(($roleid==1) OR ($roleid==2) OR ($roleid==3)){
	$role="";
}else if($roleid==5){
	$role=" AND coff.id=$circle";
}else if($roleid==6){
	$role=" AND doff.id=$dist";
}

//Value Initialization
				$prmtype="";
				$paramdata = array();
				$where="";
				$headertext="";
				$colhead="";

//for Headoffice
                
				if(!empty($timereport_id))
				{
					// prepare and bind
					$stmt = $conn->prepare("SELECT * FROM timereport WHERE timeval = ? ORDER BY id ASC");
					$stmt->bind_param("i", $timereport_id);
					$stmt->execute();
	
					//Result
					$result = $stmt->get_result();
					$numrows = $result->num_rows;
	
	
					while ($row = $result->fetch_assoc()) {
						$timename = $row["timename"];
						
					}
	   
					$timereport_id=$timereport_id-1;
					if($timereport_id==0){
					  $varyear="(TIMESTAMPDIFF(YEAR,IF(g.CLJoinDate='1970-01-01',CURDATE(),g.CLJoinDate),CURDATE()))=? ";
					}
					else{
						$varyear="(TIMESTAMPDIFF(YEAR,IF(g.CLJoinDate='1970-01-01',CURDATE(),g.CLJoinDate),CURDATE()))>=? ";
					}

$prmtype.="i";
                    $paramdata[]=$timereport_id;
                    $where.=" AND ".$varyear;
					$headertext.=$timename.' -  ';										
				}

//for Circle Office
			if(!empty($circleoffice_id))
			{
				// prepare and bind
                $stmt = $conn->prepare("SELECT * FROM circleoffice WHERE id = ? ORDER BY id ASC");
                $stmt->bind_param("i", $circleoffice_id);
                $stmt->execute();

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

while ($row = $result->fetch_assoc()) {
                    $circleofficeName = $row["circleofficeName"];					
                }
				$prmtype.="i";
				$paramdata[]=$circleoffice_id;
				$where.=" AND doff.circleoffice_id=?";
				$headertext.=$circleofficeName.' এ সকল শাখা :: ';
			}

//for District Office
			if(!empty($districtoffice_id))
			{
				// prepare and bind
                $stmt = $conn->prepare("SELECT * FROM districtoffice WHERE id = ? ORDER BY id ASC");
                $stmt->bind_param("i", $districtoffice_id);
                $stmt->execute();

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

while ($row = $result->fetch_assoc()) {
                    $districtofficeName = $row["districtofficeName"];
                }
				$prmtype.="i";
				$paramdata[]=$districtoffice_id;
				$where.=" AND doff.id=?";	
				$headertext.=$districtofficeName.' এ সকল শাখা :: ';
			}
			
//for Working Office
			if(!empty($office_id))
			{
				// prepare and bind
                $stmt = $conn->prepare("SELECT * FROM office WHERE id = ? ORDER BY id ASC");
                $stmt->bind_param("i", $office_id);
                $stmt->execute();

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

while ($row = $result->fetch_assoc()) {
                    $OfficeName = $row["OfficeName"];
                }
				$prmtype.="i";
				$paramdata[]=$office_id;
				$where=" AND g.office_id=?";
				$headertext.='শাখা : '.$OfficeName.'::  ';								
							
			}

//for Working Office
		if(!empty($designation_id))
		{
			// 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"];
			}
			$prmtype.="i";
			$paramdata[]=$designation_id;
			$where.=" AND g.designation_id=? ";
			$headertext.='পদবি : '.$DesignationName.'::  ';	
			
		}

$headertext=substr($headertext,0,-2);

// 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,													
											g.SignetureSample,
											upazila.UpazilaName	,
											TIMESTAMPDIFF(YEAR,IF(g.CLJoinDate='1970-01-01',CURDATE(),g.CLJoinDate),CURDATE()) AS emptime								
									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.status_id=1 ".$where." 
									ORDER BY d.desigslno ASC,g.FirstJoinDate");
			
			   //for error avoiding in dropdown
				$stmt->bind_param("i",$timereport_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"><?=$timename?>&nbsp; - কর্মকর্তা/কর্মচারীর সংখ্যা-<?=bangladate($numrows)?></h4>
                
				<table class="table table-bordered table-striped table-condensed">
    
                    <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'];
					$emptime = $row['emptime'];

$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 : emptime_all_report.php