Gecko [ 43.229.15.234 ]

Name	Size	Permission
salaccounts.php	5.54 KB	-rw-r--r--
salaccounts_editor.php	8.07 KB	-rw-r--r--
salaccounts_list.php	8.31 KB	-rw-r--r--
view.php	2.81 KB	-rw-r--r--

Code Editor : salaccounts_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_salaccounts" >
         <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="salaccounts.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>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>
				<th>যাতায়াত ভাতা</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 
											sal.id,
										    sal.GovtId,
											sal.houserent,
											sal.medical,
											sal.srantibinodon,
											sal.education,
											sal.spicial,
											sal.preson,
											sal.respon,
											sal.wash,
											sal.haor,
											sal.mauntain,
											sal.mobile,
											sal.tifin,
											sal.convayance,
											fin.finyearName,
											sal.salbasic,
											sal.boishakhi,
											sal.oyutsab

FROM salaccounts sal										
									LEFT JOIN finyear fin ON (sal.finyear_id=fin.id)
									WHERE sal.userinfo_id=".$_SESSION["user_id"]." AND sal.GovtId LIKE ? ORDER BY sal.id DESC  LIMIT ?, ?");
		     $stmt->bind_param("sii",$whrstr,$offset,$rowsPerPage);
			 $stmt->execute();
			 
			
			 $slno=0;			 
			//Result
				$result = $stmt->get_result();	
				$numrows=$result->num_rows;

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

while($row = $result->fetch_assoc())
				 {
					   $id = $row["id"];
					   $GovtId = $row["GovtId"];
					   $houserent = $row["houserent"];
						$medical = $row["medical"];
						$srantibinodon = $row["srantibinodon"];
						$education = $row["education"];
						$spicial = $row["spicial"];
						$preson = $row["preson"];
						$respon = $row["respon"];

$wash = $row["wash"];
						$haor = $row["haor"];
						$mauntain = $row["mauntain"];
						$mobile = $row["mobile"];
						$tifin = $row["tifin"];
						$convayance = $row["convayance"];
						$salbasic = $row["salbasic"];
						$finyearName = $row["finyearName"];

$boishakhi = $row["boishakhi"];
						$oyutsab = $row["oyutsab"];
			            	
           ?>
               <tr>
               
               <td><?=bangladate($GovtId)?></td>
			   <td><?=bangladate($finyearName)?></td>
			   <td><?=bangladate($salbasic)?></td>
			   <td  align="center"><?=bangladate($houserent) ?></td>
			   <td  align="center"><?=bangladate($medical) ?></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>&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 id FROM  salaccounts 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 = "salaccounts.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 : salaccounts_list.php