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_circle.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";
}

$cirdist_id=$_REQUEST["cirdist"];
if ($cirdist_id==1){
	$varcirdist=" o.districtoffice_id NOT IN (65) ";
	$headertext="সার্কেল সমূহের প্রতিবেদন :: ";
}
elseif ($cirdist_id==2){
	$varcirdist=" o.districtoffice_id NOT IN (65,66,67,68,69,70,71,72,73,74) ";
	$headertext="নির্বাহী প্রকৌশলী সমূহের প্রতিবেদন :: ";

}

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

//সময়কাল
                
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 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									
									FROM general g
										LEFT JOIN designation d ON(g.designation_id=d.id)
										LEFT JOIN office o 
									    	 INNER JOIN districtoffice doff ON(o.districtoffice_id=doff.id)
											 INNER JOIN circleoffice coff ON(doff.circleoffice_id=coff.id)
										     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 ".$varcirdist." AND g.status_id=1 ".$where.$role." ORDER BY d.desigslno,g.FirstJoinDate");
//Circle Office
				//Parameter Pass 
				$params = array_merge(array($prmtype), $paramdata);
				foreach( $params as $key => $value ) {
					$params[$key] = &$params[$key];
				}

call_user_func_array(array($stmt, "bind_param"), $params);
				$stmt->execute();

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

//if($numrows==0) exit('No rows');
                $slno=0;
?>
                 <br/>
                <h4 class="text-center"><?=$headertext?>&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'];

$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).' '.'মাস';

}

<tr>
					<td align="center"><?=bangladate($slno) ?></td>		
					
					<td>			  
						<a href="../general/pdsreport.php?GovtId=<?=base64_encode($GovtId)?>" target="_blank" >
						<?=bangladate($GovtId)?></a>
				   </td>

${this.title}

Code Editor : emptime_all_circle.php