<?php
 session_start();
 $_SESSION['active'] = 'userLog';
include 'header.php';
include 'sidelinks.php';  
?>   

<div class="content-wrapper"> 
      <div class="container-fluid"> 
        <div class="row">
          <div class="col-sm-12 p-0">
            <div class="main-header">
              <h4 style="color:#2567b3">LOG REPORT</h4>
              <ol class="breadcrumb breadcrumb-title breadcrumb-arrow">
                <li class="breadcrumb-item">
                  <a href="index.php">
                    <i class="icofont icofont-home"></i>
                  </a>
                </li>
                <li class="breadcrumb-item"><a href="#">Reports</a></li> 
                <li class="breadcrumb-item"><a href="logReport.php">Log Report</a></li>
              </ol>
            </div>
          </div>
        </div>  
               <div class="row"> 
                  <div class="col-lg-12">
                     <div class="card">
                        <div class="card-header">
                           <h5 class="card-header-text">Log Report</h5> 
                        </div>  

                         <div class="card-header"> 
                        <div class="col-md-6">
                          <label class="control-label"><b>From Date:</b></label>
                          <div class="form-group">
                            <input class="form-control" id="min" placeholder="DD-MM-YYYY" type="text"/>
                          </div>
                        </div>
                        <div class="col-md-6">
                          <label class="control-label"><b>To Date:</b></label>
                          <div class="form-group">
                            <input class="form-control" id="max" placeholder="DD-MM-YYYY" type="text"/>
                          </div>
                        </div>  
                        </div>  

       <div class="card-block" style="overflow-x:auto;"> 
              <table class="table datatable" id="getting_data">
                <thead>
                  <tr> 
                    <th>S.No.</th>
                    <th>Mail Id</th> 
                    <th>Login Time</th>
                    <th>Logout Time</th>
                    <th>Duration</th>
                    <th>IP Address</th>
                    <th>System Name</th> 
                  </tr>
                </thead>
                <tfoot id="tfoot1">
                  <tr>
                    <th rowspan="1" colspan="1">
                      <input type="text" placeholder="Search S.No.">
                    </th>
                    <th rowspan="1" colspan="1">
                      <input type="text" placeholder="Search Mail Id">
                    </th>  
                    <th rowspan="1" colspan="1">
                      <input type="text" placeholder="Search Login Time">
                    </th>  
                    <th rowspan="1" colspan="1">
                      <input type="text" placeholder="Search Logout Time">
                    </th> 
                    <th rowspan="1" colspan="1">
                      <input type="text" placeholder="Search Duration">
                    </th>  
                    <th  rowspan="1" colspan="1">
                      <input type="text" placeholder="Search IP Address">
                    </th>  
                    <th rowspan="1" colspan="1">
                      <input type="text" placeholder="Search System Name">
                    </th>        
                  </tr>
                </tfoot>
                <tbody>
                <?php
                 $i=1;  
                    if ($_SESSION['loginType'] == 'super admin') 
                      {  
                        $loginHistory = mysqli_query($conn,"SELECT * FROM loginHistory where logouTime != '0000-00-00 00:00:00'"); 
                      }
                    else if ($_SESSION['loginType'] == 'admin')
                      {
                        $loginHistory = mysqli_query($conn,"SELECT * FROM loginHistory where logouTime != '0000-00-00 00:00:00' and adminId = '".$_SESSION['adminId']."'"); 
                      } 
                    elseif ($_SESSION['loginType'] == 'partner') 
                      {
                        $loginHistory = mysqli_query($conn,"SELECT * FROM loginHistory where logouTime != '0000-00-00 00:00:00' and adminId = '".$_SESSION['adminId']."' and partnerId = '".$_SESSION['partnerId']."'");
                      } 
                    elseif ($_SESSION['loginType'] == 'user') 
                      {
                        $loginHistory = mysqli_query($conn,"SELECT * FROM loginHistory where logouTime != '0000-00-00 00:00:00' and adminId = '".$_SESSION['adminId']."' and partnerId = '".$_SESSION['partnerId']."' and partnerId = '".$_SESSION['partnerId']."' and userId = '".$_SESSION['userId']."'");
                      } else {
                        $loginHistory = mysqli_query($conn,"SELECT * FROM loginHistory where logouTime != '0000-00-00 00:00:00' and adminId = '".$_SESSION['adminId']."' and partnerId = '".$_SESSION['partnerId']."' and partnerId = '".$_SESSION['partnerId']."' and userId = '".$_SESSION['userId']."' and mailId = '".$_SESSION['mailId']."'");  
                              } 

                   while($loginHistoryData = mysqli_fetch_array($loginHistory))
                   { 
                    $loginTime = $loginHistoryData['loginTime'];
                    $logouTime = $loginHistoryData['logouTime'];
                    $time1 = date("H:i:s a", strtotime($loginTime));
                    $time2 = date("H:i:s a", strtotime($logouTime));
                    $time3 = ($time2 - $time1)/60;  
                 ?>
                 <tr>  
                  <td><?= $i;?></td>
                  <td><?= $loginHistoryData['mailId']?></td>
                  <td><?= $time1 ?></td>
                  <td><?= $time2 ?></td>
                  <td><?= $time3  ?></td>
                  <td><?= $loginHistoryData['ipAdd']?></td> 
                  <td><?= $loginHistoryData['pcName']?></td>   
                  </tr>
               <?php $i++; }?>
                </tbody>
              </table> 
                </div>
                  </div> 
               </div> 
               </div>
               </div> 

<script>
  $(document).ready(function() {

   $('#getting_data tfoot th').each(function () {
     var title = $('#getting_data thead th').eq($(this).index()).text();
     $(this).html('<input type="text" placeholder="Search ' + title + '" />');
   }); 



   var table = $('#getting_data').DataTable({
    dom: 'Bfrtip', 
     buttons: [
      'colvis','excel', 'pdf'
        ], 

    // "fnDrawCallback": function (oSettings) {
    //   var api = this.api(), data;
    //   var intVal = function (i) {
    //     return typeof i === 'string' ?
    //     i.replace(/[\$,]/g, '') * 1 :
    //     typeof i === 'number' ?
    //     i : 0;
    //   };

    //   CountofAmount = api
    //   .column(10, { 'search': 'applied' })
    //   .data()
    //   .reduce(function (a, b) {
    //     return intVal(a) + intVal(b);
    //   }, 0);


    //   CountofAmountcurrent = api
    //   .column(10, { page: 'current' })
    //   .data()
    //   .reduce(function (a, b) {
    //     return intVal(a) + intVal(b);
    //   }, 0);


    //   $('#Sum_TotalRecords').text('Rs.'+ CountofAmountcurrent + '(' +'Rs.'+ CountofAmount + ')');
    // }

  });

   $("#getting_data tfoot input").on('keyup change', function () {
     table
     .column($(this).parent().index() + ':visible')
     .search(this.value)
     .draw();
   });
 });
</script> 

<script type="text/javascript">

  $(document).ready(function() {
   $.fn.dataTable.ext.search.push(
     function(settings, data, dataIndex) {
       var min = $('#min').datepicker("getDate");
       var max = $('#max').datepicker("getDate");

       var startDate = new Date(data[7]);
       if (min == null && max == null) {
         return true;
       }
       if (min == null && startDate <= max) {
         return true;
       }
       if (max == null && startDate >= min) {
         return true;
       }
       if (startDate <= max && startDate >= min) {
         return true;
       }
       return false;
     }
     );


   $("#min").datepicker({ 
     onSelect: function() {
       table.draw();
     },
     changeMonth: true,
     changeYear: true
   });
   $("#max").datepicker({ 
     onSelect: function() {
       table.draw();
     },
     changeMonth: true,
     changeYear: true
   });
   var table = $('#getting_data').DataTable();
   $('#min, #max').change(function() {
     table.draw();
   });
 }); 
</script>  


   <?php include 'footer.php' ?>