<?php 

$page_title="Manage Language";
include("includes/header.php");

require("includes/function.php");
require("language/language.php");


$tableName="tbl_language";   
$targetpage = "manage_language.php"; 
$limit = 12; 

$keyword='';

if(!isset($_GET['keyword'])){
  $query = "SELECT COUNT(*) as num FROM $tableName";
}
else{

  $keyword=addslashes(trim($_GET['keyword']));

  $query = "SELECT COUNT(*) as num FROM $tableName WHERE `language_name` LIKE '%$keyword%'";

  $targetpage = "manage_language.php?keyword=".$_GET['keyword'];

}

$total_pages = mysqli_fetch_array(mysqli_query($mysqli,$query));
$total_pages = $total_pages['num'];

$stages = 3;
$page=0;
if(isset($_GET['page'])){
  $page = mysqli_real_escape_string($mysqli,$_GET['page']);
}
if($page){
  $start = ($page - 1) * $limit; 
}else{
  $start = 0; 
} 

if(!isset($_GET['keyword']))
{
  $sql_query="SELECT * FROM tbl_language ORDER BY tbl_language.`lid` DESC LIMIT $start, $limit"; 
}
else{

  $sql_query="SELECT * FROM tbl_language WHERE `language_name` LIKE '%$keyword%' ORDER BY tbl_language.`lid` DESC LIMIT $start, $limit"; 
}

$result=mysqli_query($mysqli,$sql_query) or die(mysqli_error($mysqli)); 

?>

<div class="row">
  <div class="col-xs-12">
    <?php
        if(isset($_SERVER['HTTP_REFERER']))
          {
            echo '<a href="'.$_SERVER['HTTP_REFERER'].'"><h4 class="pull-left" style="font-size: 20px;color: #e91e63"><i class="fa fa-arrow-left"></i> Back</h4></a>';
         }
      ?>
    <div class="card mrg_bottom">
      <div class="page_title_block">
        <div class="col-md-5 col-xs-12">
          <div class="page_title"><?=$page_title?></div>
        </div>
        <div class="col-md-7 col-xs-12">
          <div class="search_list">
            <div class="search_block">
              <form method="get" id="searchForm" action="">
                <input class="form-control input-sm" placeholder="Search here..." aria-controls="DataTables_Table_0" type="search" name="keyword" value="<?php if(isset($_GET['keyword'])){ echo $_GET['keyword'];} ?>" required="required">
                <button type="submit" class="btn-search"><i class="fa fa-search"></i></button>
              </form>  
            </div>
            <div class="add_btn_primary"> <a href="add_language.php?add=yes&redirect=<?=$redirectUrl?>">Add Language</a> </div>
          </div>
        </div>
        <div class="col-md-3 col-xs-12 text-right" style="float: right;">
          <div class="checkbox" style="width: 95px;margin-top: 5px;margin-left: 10px;right: 100px;position: absolute;">
            <input type="checkbox" id="checkall_input">
            <label for="checkall_input">
              Select All
            </label>
          </div>
          <div class="dropdown" style="float:right">
            <button class="btn btn-primary dropdown-toggle btn_cust" type="button" data-toggle="dropdown">Action
              <span class="caret"></span></button>
              <ul class="dropdown-menu" style="right:0;left:auto;">
                <li><a href="javascript:void(0)" class="actions" data-action="enable" data-table="tbl_language" data-column="language_status">Enable</a></li>
                <li><a href="javascript:void(0)" class="actions" data-action="disable" data-table="tbl_language" data-column="language_status">Disable</a></li>
                <li><a href="javascript:void(0)" class="actions" data-action="delete" data-table="tbl_language" data-column="language_status">Delete !</a></li>
              </ul>
            </div>
          </div>
        </div>
        <div class="clearfix"></div>
        <div class="col-md-12 mrg-top">
          <table class="table table-striped table-bordered table-hover">
            <thead>
              <tr>
                <th width="50" nowrap=""></th>
                <th width="100" style="text-align: center;">Sr. No</th>                  
                <th>Language Name</th>
                <th>Status</th>
                <th class="cat_action_list">Action</th>
              </tr>
            </thead>
            <tbody>
             <?php	
             $i=1;
             while($row=mysqli_fetch_array($result))
             {					
              ?>
              <tr>
                <td>
                  <div class="checkbox">
                    <input type="checkbox" name="post_ids[]" id="checkbox<?php echo $i;?>" value="<?php echo $row['lid']; ?>" class="post_ids">
                    <label for="checkbox<?php echo $i;?>">
                    </label>
                  </div>
                </td> 
                <td align="center"><?=$i++;?></td>                
                <td><?php echo $row['language_name'];?></td>
                <td>
                  <div class="row toggle_btn">
                    <input type="checkbox" id="enable_disable_check_<?=$i?>" data-id="<?=$row['lid']?>" data-table="tbl_language" data-column="language_status" class="cbx hidden enable_disable" <?php if($row['language_status']==1){ echo 'checked';} ?>>
                    <label for="enable_disable_check_<?=$i?>" class="lbl"></label>
                  </div>
                </td>
                <td>
                  <a href="add_language.php?lang_id=<?php echo $row['lid'];?>&redirect=<?=$redirectUrl?>" class="btn btn-primary btn_edit" data-toggle="tooltip" data-tooltip="Edit"><i class="fa fa-edit"></i></a>

                  <a href="javascript:void(0)" data-id="<?php echo $row['lid'];?>" data-table="tbl_language" class="btn btn-danger btn_delete_a btn_cust" data-toggle="tooltip" data-tooltip="Delete !"><i class="fa fa-trash"></i></a>
                </td>

              </tr>
              <?php
            }
            ?> 
          </tbody>
        </table>
      </div>
      <div class="col-md-12 col-xs-12">
        <div class="pagination_item_block">
          <nav>
            <?php include("pagination.php");?>
          </nav>
        </div>
      </div>
      <div class="clearfix"></div>
    </div>
  </div>
</div>

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