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

<div class="container">
    <div class="row">
        <div class="col">
            <?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($headoffice_id))
				{
					// prepare and bind
					$stmt = $conn->prepare("SELECT * FROM headoffice WHERE id = ? ORDER BY id ASC");
					$stmt->bind_param("i", $headoffice_id);
					$stmt->execute();
	
					//Result
					$result = $stmt->get_result();
					$numrows = $result->num_rows;
	
	
					while ($row = $result->fetch_assoc()) {
						$offname = $row["offname"];
					}
					$prmtype.="i";
                    $paramdata[]=$headoffice_id;
                    $where.=" AND coff.headoffice_id=? ";
					$headertext.=$offname.' এর আওতাভুক্ত সকল অফিস :: ';										
				}

//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,
											em.upthana,
											u.mobileno									
									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 userinfo u ON(g.userinfo_id =u.id)
										LEFT JOIN empaddress em  ON(g.GovtId=em.GovtId)
										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,g.dob");
//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" id="example">
    
                    <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>
					<th>ই-মেইল</th>
					<th>মন্তব্য</th>
                    </thead>
    
                    <tbody>
    
         
                    <?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'];
					$upthana = $row['upthana'];

$mobileno=$row['mobileno'];

$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($mobileno)?></td>				  
					<td><?=$DistrictName?></td>
					<td>
						<?php						    
							if (empty($upthana)){
								echo $UpazilaName;
							}else{
								echo $upthana;
							}
						?>
					</td>
					<td><?=$OfficeName?></td>
					<td><?=bangladate(str_replace('01/01/1970','',date('d/m/Y', strtotime($CLJoinDate))))?></td>
					<td><?=$timeintval?></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($FirstJoinDate))))?></td>
					<td><?=bangladate(str_replace('01/01/1970','',date('d/m/Y', strtotime($dob .' + 59 years'))))?></td>
					<td><?=bangladate(str_replace('01/01/1970','',date('d/m/Y', strtotime($dob .' + 60 years'))))?></td>
					<td><?=$PersonalEmail?></td>
					<td>&nbsp</td>
                <?php
                }
                ?>
                </tbody>
            </table>
        </div>
    </div>
</div>

${this.title}

Code Editor : headoffice.php