Gecko [ 43.229.15.234 ]

Name	Size	Permission
ExpectedLastSal	[ DIR ]	drwxr-xr-x
FringerTham	[ DIR ]	drwxr-xr-x
SignetureSample	[ DIR ]	drwxr-xr-x
delcrearation	[ DIR ]	drwxr-xr-x
photo	[ DIR ]	drwxr-xr-x
ajaxviewgrade.php	544 B	-rw-r--r--
general.php	26.11 KB	-rw-r--r--
general_allemp.php	13.46 KB	-rw-r--r--
general_editor.php	47.52 KB	-rw-r--r--
general_list.php	11.51 KB	-rw-r--r--
general_report.php	23.71 KB	-rw-r--r--
pdsreport.php	72.99 KB	-rw-r--r--

Code Editor : general_allemp.php

<?php
 include("../homepage/header.php");
 include("../homepage/headermenu.php");
  
  if(empty($_SESSION["username"])) 
	 {
	   Header("Location: ../login/login.php");
	  }

?>
<div class="container fullheight">

<div class="row">
<div class="col-md-6 col-md-offset-4">
<br/>
    <form name="search_frm" id="search_frm" class="form-inline">
      
         <label>Search Key</label>
         <input type="text"    name="field_value" id="field_value" value="<?=$_SESSION["field_value"]?>" class="form-control">
		 <input type="hidden" name="cmd" id="cmd" value="search_allemp" >
         <input type="submit" class="btn btn-primary" value="Search">
    </form>
</div>
</div>

<thead>
			    <th>ক্রমিক</th>
	            <th>PIMS আইডি</th>
				<th>নাম(বাংলায়)</th>
				<th>বর্তমান অফিসের নাম</th>
				<th>পদবি</th>
				<th>জাতীয় পরিচয়পত্র নং</th>			
				<th>গ্রেড</th>
			    <th>বর্তমান বেতন স্কেল</th>
	          
				<th style="text-align: center">ভিউ</th>	
				<th style="text-align: center">সকল তথ্য</th>			
				<th style="text-align: center">তথ্য সংশোধন</th>	
				<?php
				if($_SESSION["userrole_id"]==3)
				{					
				echo '<th style="text-align: center">ডিলিট</th>';
				}
				?>		
               </thead>

<tbody>
               <?php

if($_SESSION["search"]=="yes")
				  {
					
					$val=englishnum($_SESSION["field_value"]);
					$whrstr = "%$val%";
				  }
				  else
				  {
					$whrstr = "%%";
				  }
		 
				$rowsPerPage = 50;
				$pageNum = 1;
				if(isset($_REQUEST["page"]))
				{
					$pageNum = $_REQUEST["page"];
				}
				$offset = ($pageNum - 1) * $rowsPerPage; 
			
			 	//Role
				 include("../reports/hrmrole.php");

$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,
												u.uname,
												g.userinfo_id 									
										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)
												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)																						    
										WHERE 1=1 AND (u.uname LIKE ? OR u.mobileno LIKE ? OR g.NameE LIKE ? OR g.NameB LIKE ? or g.GovtId LIKE ?) ".$district."  ORDER BY d.desigslno ASC,g.FirstJoinDate ASC  LIMIT ?, ?");
				$stmt->bind_param("sssssii",$whrstr,$whrstr,$whrstr,$whrstr,$whrstr,$offset,$rowsPerPage);
				$stmt->execute();

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

if($numrows==0) exit('No rows');		
				
				 $slno=$offset;

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'];
							$userinfo_id = $row['userinfo_id'];
						    																							
					   
           ?>
               <tr>
              
               <td align="center"><?=bangladate($slno) ?></td>			   
			   <td>			  
               <a href="pdsreport.php?GovtId=<?=base64_encode($GovtId)?>" >
               <?=bangladate($GovtId)?></a>   
				
				
				</td>
			   <td><?=$NameB?></td>
			   <td><?=$OfficeName?></td>			  
			   <td><?=$DesignationName?></td>
			   <td><?=bangladate($NationalID)?></td>
			   <td><?=$GradeName?></td>
			   <td><?=$PayScale?></td>

<td align="center">
               <a href="../general/general.php?cmd=edit&id=<?=$id?>">
               <span class="glyphicon glyphicon-pencil"></span></a>
               </td>
<?php
if($_SESSION["userrole_id"]==3)
{
?>
			   <td align="center">
               <a href="../general/general.php?cmd=delete&id=<?=$userinfo_id?>" onClick=" return confirm('তথ্য মুছে ফেলতে আপনি কি নিশ্চিত?');">
               <span class="glyphicon glyphicon-trash"></span></a>
               </td>
<?PHP
}
?>			 
               </tr>
               <?php
               }
               ?>
             </tbody>              
              </thead>
           </table>
		   
           <div align="center">		   
		   <?php
							$stmt = $conn->prepare("SELECT 
							g.id
							
					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)
							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)																						    
					WHERE 1=1 AND (u.uname LIKE ? OR u.mobileno LIKE ? OR g.NameE LIKE ? OR g.NameB LIKE ? or g.GovtId LIKE ?) ".$district."  ORDER BY d.desigslno ASC,g.FirstJoinDate ASC ");
$stmt->bind_param("sssss",$whrstr,$whrstr,$whrstr,$whrstr,$whrstr);

$stmt->execute();

//Result
			$result = $stmt->get_result();	
			$numrows=$result->num_rows;
			
							   
			$maxPage = ceil($numrows/$rowsPerPage);
			$self = "general.php?cmd=allemp";
			$nav  = "";
			
			$start    = ceil($pageNum/5)*5-5+1;
			$end      = ceil($pageNum/5)*5;	
			
			if($maxPage<$end)
			  {
				$end  = $maxPage;
			  }	
			
			
			for($page = $start; $page <= $end; $page++)
                  {
                      				   
					  if ($page == $pageNum)
						{
							$nav .= "<span class=\"page-link\"><font color=\"red\">$page</font></span>";
						}
						else
						{
							$nav .= " <a href=\"$self&&page=$page\" class=\"page-link\">$page</a> ";
						}
				}
				
		   if ($pageNum > 1)
				{
					$page  = $pageNum - 1;
					$prev  = " <a href=\"$self&&page=$page\" class=\"page-link\">Prev</a> ";
			
				   $first = " <a href=\"$self&&page=1\" class=\"page-link\">[First Page]</a> ";
				} 
				else
				{
					$prev  = "&nbsp;"; 
					$first = "&nbsp;"; 
				}
		  
		  if ($pageNum < $maxPage)
				{
					$page = $pageNum + 1;
					$next = " <a href=\"$self&&page=$page\" class=\"page-link\">Next</a> ";
			
					$last = " <a href=\"$self&&page=$maxPage\" class=\"page-link\">Last Page</a> ";
				} 
				else
				{
					$next = "&nbsp;"; 
					$last = "&nbsp;"; 
				}
				
				if($numrows>1)
				{
				   echo '<nav>
                         <ul class="pagination">
                           <li class="page-item">'.$first.'</li><li class="page-item">'.$prev.'</li>
						   <li class="page-item">'.$nav .'</li>
						   <li class="page-item">'.$next.'</li> 
						   <li class="page-item">'. $last.'</li>
						</ul></nav>';
				}
		?>
		   </div>
		   
         </div>
    </div>

</div>

<?php
include("../homepage/footer.php");
?>

${this.title}

Code Editor : general_allemp.php