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

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

if(empty($_SESSION["username"]))
{
    Header("Location: ../login/login.php");
}
?>
<div class="container backcolor">
    <div class="row">
        <div class="col-md-12">
            <?php

if (isset($_POST['datefrom'])) {
	$datefrom=$_POST["datefrom"];
  }
  if (isset($_POST['dateto'])) {
	$dateto=$_POST["dateto"];
	
  }

$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($datefrom) && !empty($dateto))
				{
					$datefrom=date("Y-m-d", strtotime(str_replace("/","-",englishnum($_POST["datefrom"]))));
					$dateto=date("Y-m-d", strtotime(str_replace("/","-",englishnum($_POST["dateto"]))));

$prmtype.="ss";
                    $paramdata[]=$datefrom;
					$paramdata[]=$dateto;
                    $where.=" AND TIMESTAMPADD(YEAR,59,dob) BETWEEN ? AND ? ";
					$headertext.='তারিখ :: '.bangladate($_POST["datefrom"]).' থেকে '.bangladate($_POST["datefrom"]).'  ';										
				}

$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 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;LPR কর্মকর্তা/কর্মচারীর সংখ্যা-<?=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>
					
                    </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>
					
					<td><?=$NameB?></td>	
					<td><?=$DesignationName?></td>
					<td><?=bangladate($SalBasic)?></td>						  
					<td><?=$OfficeName?></td>					
					<td><?=bangladate(str_replace('01/01/1970','',date('d/m/Y', strtotime($dob))))?></td>					
					<td><?=bangladate(str_replace('01/01/1970','',date('d/m/Y', strtotime($dob .' + 59 years'.' - 1 days'))))?></td>
					<td><?=bangladate(str_replace('01/01/1970','',date('d/m/Y', strtotime($dob .' + 60 years'.' - 1 days'))))?></td>					
                <?php
                }
                ?>
                </tbody>
            </table>
        </div>
    </div>
</div>

${this.title}

Code Editor : rep_lpr.php