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_list.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_general" >
         <input type="submit" class="btn btn-primary" value="Search">
    </form>
</div>
</div>

<div class="row">
    <div class="col-md-12">
        <a style="text-decoration: none" href="general.php?cmd=edit">সাধারণ তথ্য যোগ করুন</a></font>
    <div style="background-color: #ff0000;height: 2px">&nbsp;</div>
    <br/>
          <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 style="text-align: center">সংশোধন</th>
				<th style="text-align: center">ভিউ</th>	
				<th style="text-align: center">সকল তথ্য</th>			
               </thead>

<tbody>
               <?php

if($_SESSION["search"]=="yes")
				  {
					
					$val= $_SESSION["field_value"];
					$whrstr = "%$val%";
				  }
				  else
				  {
					$whrstr = "%%";
				  }
		 
				$rowsPerPage = 10;
				$pageNum = 1;
				if(isset($_REQUEST["page"]))
				{
					$pageNum = $_REQUEST["page"];
				}
				$offset = ($pageNum - 1) * $rowsPerPage; 
			
			 			 
				$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									
										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)																						    
										WHERE g.userinfo_id=".$_SESSION["user_id"]." AND g.GovtId LIKE ? ORDER BY g.GovtId DESC  LIMIT ?, ?");
				$stmt->bind_param("sii",$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'];
						    																							
					   
           ?>
               <tr>
              
               <td align="center"><?=bangladate($slno) ?></td>			   
			   <td><?=bangladate($GovtId)?></td>
			   <td><?=$NameB?></td>
			   <td><?=$OfficeName?></td>			  
			   <td><?=$DesignationName?></td>
			   <td><?=$NationalID?></td>
			   <td><?=$GradeName?></td>
			   <td><?=$PayScale?></td>

<thead>
              	<th>&nbsp;</th>
				<th>&nbsp;</th>
	            <th>&nbsp;</th>
				<th>&nbsp;</th>
	            <th>&nbsp;</th>
				<th>&nbsp;</th>
	            <th>&nbsp;</th>
				<th>&nbsp;</th>
	            <th>&nbsp;</th>
				<th>&nbsp;</th>
	            
                <th style="text-align: center">&nbsp</th>       
              </thead>
           </table>
		   
           <div align="center">		   
		   <?php
			$stmt = $conn->prepare("SELECT * FROM general WHERE GovtId LIKE ? ORDER BY id ASC");
			$stmt->bind_param("s",$whrstr);
			$stmt->execute();

//Result
			$result = $stmt->get_result();	
			$numrows=$result->num_rows;
			
							   
			$maxPage = ceil($numrows/$rowsPerPage);
			$self = "general.php?cmd=list";
			$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_list.php