Table row filter without Pagination

271 views Asked by At

I want to filter Table data, but I have more than hundred row so I used pagination. If i apply any filter it only filters the current page inseated of entier table.

Html and javascript code are given below

<select id='filterText' style='display:inline-block' onchange='filterText()'>
<option disabled selected>Select</option>
<option value='Active'>Active</option>
<option value='Obsolete'>Obsolete</option>
<option value='all'>All</option>
</select>


<table class="table table-striped table-bordered table-hover  table-list-search" id="dataTables-example"  >
<thead>
<tr style="background-color:#abdcd5;">
    <th align="left" class="col-xs-2">Employee ID</th>
    <th align="left" class="col-xs-1">Name</th>
    <th align="left" class="col-xs-2">Location</th>
    <th align="left" class="col-xs-2">Company </th>
    <th align="left" class="col-xs-3">Job Description</th>
    <th align="left" class="col-xs-1">Status</th>
    <th align="left" class="col-xs-1">Action</th>
</tr>
</thead>
<tbody>

    <?php employeedetails::employeelist();?>

</tbody>
                </table>

Javascript

<script>
function filterText() {  
    var rex = new RegExp($('#filterText').val());
    if(rex == "/all/") {
        clearFilter();
    } else {
        $('.content').hide();
        $('.content').filter(function() {
            return rex.test($(this).text());
        }).show();
    }
}

function clearFilter() {
    $('.filterText').val('');
    $('.content').show();
}
</script>

Php code

  <?php

  class employeedetails
  {

    //function for display details of employee

 static function employeelist()
{
    $tenanPortalId = $_SESSION['PortalID'];
    $databaseConnectionObject = new DB_CONNECT();

   $resultForGettingDetailsOfEmployees  =   mysqli_query($databaseConnectionObject->connect(),$Query); 

if(!$resultForGettingDetailsOfEmployees){

    die(mysqli_error($databaseConnectionObject->connect()));
}

else if($resultForGettingDetailsOfEmployees)
{


    while($row = mysqli_fetch_array($resultForGettingDetailsOfEmployees))
    {


        $employee_ID=$row['employee_id'];
        $employee_ID_trim = str_replace($tenanPortalId."~","",$row['employee_id']);
        $employee_Name=$row['employee_name'];
        $employee_Location=$row['employee_location'];
        $employee_Status=$row['employee_Status'];
        $expenseManager=$row['expenseManager'];
        $SnactionManager=$row['SnactionManager'];
        $EmployeeLocation=$row['countryName'];
        $hireDate=$row['hireDate'];

        if($row['company'] == "->")
        {
            $company = "";
        }
        else
        {
            $company=$row['company'];
        }

        if($row['reportingLineUnit'] == "->")
        {
            $reportingLineUnit="";
        }
        else
        {
            $reportingLineUnit=$row['reportingLineUnit'];
        }

        $employeeType = $row['employeeType'];
        $jobdescription = $row['jobDescription'];

        ?>
        <tr class="content">
            <td>

                <a data-toggle="modal" data-target='#<?php echo "$employee_ID_trim"; ?>' style="cursor: pointer;"> 
                    <?php echo "$employee_ID";?>
                </a>

                <?php

                    $msg = "";
                    if($SnactionManager == "" || $SnactionManager == "No") 
                    { 
                      $msg = "Do you want to make $employee_Name as Sanction Manager?" ;                            
                    }
                    else
                    {
                      $msg = "Do you want to remove $employee_Name as Sanction Manager?" ;
                      //echo " <span><img src='../assets/img/twouser.png' width='20px;' height='20px;'/></span>";
                    }

                    echo $imgPath = ($expenseManager == "Yes") ? 
                                (($SnactionManager == "Yes") ? " <span><img src='../assets/img/twouser.png' width='20px;' height='20px;' title='Project & Sanction Manager'/></span>" : " <span><img src='../assets/img/project.png' width='20px;' height='20px;' title='Project Manager'/></span>" ) 
                                : 
                                (($SnactionManager == "Yes") ? " <span><img src='../assets/img/sanction.png' width='20px;' height='20px;' title='Sanction Manager'/></span>" : "" ) ;
                ?>


                <!-- Modal -->
                    <div id='<?php echo "$employee_ID_trim"; ?>' class="modal fade" role="dialog"  ">
                      <div class="modal-dialog">

                        <!-- Modal content-->
                        <div class="modal-content">
                          <div class="modal-header">
                            <button type="button" class="close" data-dismiss="modal">&times;</button>
                            <h4 class="modal-title">
                                <?php echo "$employee_Name";?>
                            </h4>
                          </div>
                          <div class="modal-body">
                            <div class="table-responsive">
                              <table class="table table-bordered table-hover">
                                <tr style="background-color:#abdcd5;">
                                    <th align="left" class="col-xs-2">Project Manager</th>
                                    <th align="left" class="col-xs-2">Sanction Manager</th>
                                    <th align="left" class="col-xs-2">Type</th>     
                                    <th align="left" class="col-xs-2">Reporting Line Unit </th> 
                                    <th align="left" class="col-xs-2">Hire Date </th> 

                                </tr>
                                <tr>
                                    <td><?php echo "$expenseManager";?></td>

                                    <td><?php echo "$SnactionManager";?></td>

                                    <td><?php echo "$employeeType";?></td>

                                    <td><?php echo "$reportingLineUnit";?></td>

                                    <td><?php echo date("m/d/Y", strtotime($hireDate));?></td>

                                </tr>

                              </table>
                            </div>
                          </div>
                          <div class="modal-footer">
                            <button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
                          </div>
                        </div>

                      </div>
                    </div>

            </td>
            <td>
                <?php echo "$employee_Name"; ?>

            </td>
            <td><?php echo "$EmployeeLocation";?></td>


            <td><?php echo "$company";?></td>

            <td><?php echo "$jobdescription";?></td>



            <?php $color =($employee_Status=="Obsolete" ? "red" : "green") ; ?>




<td style="color:<?php echo $color; ?> ;font-weight:bold;text-align:center;"><?php echo "$employee_Status";?></td>

            <td align="center">


                <button type="button" style="background-color:#00a4a4;border-color:#00a4a4;" class="btn btn-primary btn-xs" data-toggle="modal" data-target='#<?php echo "$employee_ID_trim"."SMM"; ?>' style="cursor: pointer;">
                    <span  class="glyphicon glyphicon-pencil"></span>
                </button>



                <div id='<?php echo "$employee_ID_trim"."SMM"; ?>' class="modal fade" role="dialog"  ">
                  <div class="modal-dialog">

                    <!-- Modal content-->
                    <div class="modal-content">
                      <div class="modal-header">
                        <button type="button" class="close" data-dismiss="modal">&times;</button>
                        <h4 class="modal-title">
                            <?php echo "$employee_Name";?>
                        </h4>
                      </div>
                      <div class="modal-body">
                        <div class="row" style="padding-bottom:5%;">
                            <?php echo $msg; ?>
                        </div>
                        <div class="row" style="padding-bottom:3%;">

                            <form id="eventForm"  action="../index.php" method ="POST"> 

        <input type="hidden" class="form-control" id=""  name="EmployeeId" value="<?php echo "$employee_ID"; ?>" />
    <input type="hidden" class="form-control" id=""  name="EmployeeName" value="<?php echo "$employee_Name"; ?>" />
                                <?php 
                    $buttonName = "Assign";
                if($SnactionManager == "" || $SnactionManager == "No") 
                    { 
                ?>
            <input type="hidden" name="SnManager"  value="Yes">                     
                <?php
                }
                else
                { 
                    $buttonName = "Remove";
                ?>
            <input type="hidden" name="SnManager"  value="No">
            <?php   
                }
            ?>          

        <button type="submit" class="btn btn-primary" value="Assign Manger" name="operation"> 
        <span class="glyphicon glyphicon-ok" ></span>
                    <?php echo $buttonName; ?> 
        </button>

        <button type="button" class="btn btn-danger" data-dismiss="modal">
            <span class="glyphicon glyphicon-remove" ></span>
            Cancel
            </button>

        </form> 


</div>
</div>

</div>
</div>
</div>  
</td>
</tr>


<?php   
} //while

} //else if

} //function
} //class
?>
0

There are 0 answers