000

<?php
use App\Http\Controllers\addlocationController;

@extends('master')

@section('content')

<div class="container content-box pad25A" style="page-break-after: always;">
      <div class="col-lg-12 grid-margin">
        <div class="card">
            <div class="card-body">
                <div class="row">
                    <div class="col-lg-12">
<form action="{{url('addfilter')}}" method="post">
    {{ csrf_field() }}
<div class="row">
<div class="col-4">
<label class="lbl" style="font-size:14px;font-weight: 500;">User Name :</label>
<select name="sql_query" class="autosubmit mb-3 select2" style="font-size:13px;padding:5px 10px;">
    <option value=''>---Select User---</option>
  @foreach($users as $emp)
         <option value='{{ $emp->id }}' <?php if($sql_query==$emp->id){echo "selected";}?>>{{ $emp->name }}</option>
       @endforeach

</select>
 </div>
 <div class="col-4">
   <label class="lbl" style="font-size:14px;font-weight: 500;">To Date :</label>
<input class="form-control date-picker fromDates" id="myDate" name="mydate" type="date" value="<?php echo date("Y-m-d")?>">
</div>




<div class="col-3" style="padding-top:33px;">
<input type="submit" value="Submit" id="btn" style="background:#24c2d2;border:none;color:#fff;">
</div>
</div>
</form>

</div>
</div>
</div>
</div>
</div>

<div class="col-lg-12 grid-margin">
    <div class="card">
      <div class="card-body">
         
        <div class="table-responsive">
  <div class="row">
    <div class="col-12">
      <table class="table table-bordered myTable" id="datatbl">
        <thead>
            
            
            <th scope="col">S. No.</th>
             <th scope="col">User Name</th>
             
            <th scope="col">In Time</th>
            <th scope="col">Location Range</th>
             <th scope="col">Attendance</th>
          </tr>

</thead>
        <tbody>

<?php
          $i=1;
         // print_r(count($userlocation));
        foreach ($userlocation as $emp){
        $var = addlocationController::getuser($emp->user_id);
        //print_r($var);
        ?>
        <tr>
         <td><?php echo $i;?></td>
         <td><?php  echo $var[0]->name;?></td>
          <td><?php echo date('d-M-Y h:i:s',strtotime($emp->in_time))?></td>
         <td><?php echo $emp->location_range; ?> FEET</td>
         <td><?php echo $emp->type; ?></td>

</tr>
        <?php $i++;}?>
        </tbody>
      </table>
    </div>
  </div>
</div>
</div>
</div>

@endsection