<?php include('../_inc/connection.php');?>
<?php include('../_inc/jmnavside.php');?>
<?php
$user_id=$_SESSION['id'];
$utpq="SELECT * , 
                DATE_ADD(doa, INTERVAL 27 DAY) AS due_date, 
                DATEDIFF(DATE_ADD(doa, INTERVAL 27 DAY), CURDATE()) AS days_remaining 
         FROM prisoners left join status  on prisoners.id=status.p_id inner join users on status.assign_by=users.id
         WHERE assign_to='PS' ORDER BY assign_dt desc";  
$utpdata=mysqli_query($con,$utpq);

?>
<!DOCTYPE html>
<html lang="en">
  <head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="initial-scale=0.4">
    <meta name="description" content="">
    <meta name="author" content="">

    <title>List of prisoners</title>
    <link rel="stylesheet" type="text/css" href="../css/bootstrap.min.css">
   <link rel="stylesheet" type="text/css" href="../css/font-awesome.min.css">
   <link rel="stylesheet" type="text/css" href="../css/bootstrap-datepicker.min.css">
   <link rel="stylesheet" type="text/css" href="../_inc/user.css">
     <link href="../css/dataTables/buttons.dataTables.min.css" rel="stylesheet">
   <link href="../css/dataTables/jquery.dataTables.min.css" rel="stylesheet">
    <style>
body > div > div.sidemenu.sidemenu-dark.bg-bluelight > div > ul > li:nth-child(4) > a,body > div > div.sidemenu.sidemenu-dark.bg-bluelight > div > ul > li:nth-child(4) > a > span,body > div > div.sidemenu.sidemenu-dark.bg-bluelight > div > ul > li:nth-child(4) > a > i
    {
      background-color: white;
      color:green;
    } 
   body > div > div.sidemenu.sidemenu-dark.bg-bluelight > div > ul > li:nth-child(5) > a > span
    {
      background-color: gray;
      color:red;
      transition:all 1s;
    }
    #submenu > li:nth-child(5) > a 
    td{
      text-align: center;
      align-items: center;
    }
    </style>
  </head>
  <body onbeforeunload="reset1();">
 <div class="container-fluid">
    <div class="content">
        <div class="col-md-12 col-sm-12" style="margin-left:147px; width:1180px;" id="foldmove">
          <div class="card card-primary">
            <div class="card card-body">
                
        <span class="text text-success"><h4><strong>List of UTP cases sent to the Police Station</strong></h4></span>
          <label class="text text-danger" style="font-family: sans-serif;"><b>NOTE:<br></b><small> * Order by sent date </label>
             <div class="row">
            <div class="col-md-12">
                <div class="panel panel-primary">
                    <div class="panel-body">
                    
                        <hr>
                        <div class="row">
                            <div class="col-md-12">
                                <div class="table-responsive">
                                    <table style="font-size:90%" class="table able-striped table-bordered table-hover" id="table-res">
                                        <thead>
                                        <tr>
                                            <th>#</th>
                                            <th>Name</th>
                                            <th>Parentage/Spouse</th>
                                            <th>Date of Admission in Prison</th>
                                            <th>FIR NO</th>
                                            <th>FIR_Date</th>
                                            <th>Police Station</th>
                                            <th>Section of Law</th>
                                            <th>Sent to / on</th>
                                            <th>Days Remaining U/S 173</th>
                                            <th>Current Status</th>
                                       
            
                                        </tr>
                                        </thead>
                                        <a  id="refer" hidden  href="prisonerslist.php"></a>
                                        <tbody id="qualfetch">  
                                        <?php
                                        $sno=1;
                                        while($utp=mysqli_fetch_array($utpdata)){ ?>
                                          <tr>
                                            <td><?php echo $sno++;?></td>
                                            <td><?php echo $utp['full_name']?></td>
                                            <td><?php echo $utp['parentage_spouse']?></td>
                                            <td><?php echo date('d-m-Y',strtotime($utp['doa']))?></td>
                                            <td><?php echo $utp['fir_no']?></td>
                                            <td><?php echo date('d-m-Y',strtotime($utp['fir_date']))?></td>
                                            <td><?php echo $utp['ps']?></td>
                                            <td><?php echo $utp['section_of_law']?></td>
                                            <td><?php echo date('d-m-Y',strtotime($utp['assign_dt']))?></td>
                            
                                            <td><?php echo $utp['days_remaining']?></td>
                                           
                                            <td>
                                             

                                              <?php
                                             
                                              if(is_null($utp['f_recieved_dt']))
                                              {
                                                echo 'Waiting for Physical File'. "<br> Sent Date: <br>".date('d-m-Y',strtotime($utp['assign_dt']));
                                              }
                                              else
                                              {
                                              echo 'Physical filed recieved at PS Dated:'.date('d-m-Y h:i:s a',strtotime($utp['f_recieved_dt']));
                                          }?>
                            
                                      </td>
                                            <?php }?>

                                          </tr>
                                     </tbody>
                                    </table>

                                </div>
                              </div>
                            </div>
                          </div>
                        </div>
                      </div>
                    </div>
                  </div>
                </div>
              </div>
            </div>
          </div>
        </div>         
    <script src="../js/jquery/jquery-2.2.4.min.js"></script>
    <script type="text/javascript">


    $('#otherboard').on('change',function(event)
    {
      $('#otherboardinput').attr('disabled',true).val('');
      if($("Option:selected",this).val()==='Others')
      {
       $('#otherboardinput').attr('disabled',false);
      }
    });
    function delete_row(id)
      {
      var con=confirm("Are you Sure want to delete this record");
      if(con)
      {
     $.ajax({
        type:'post',
        url:'deleterec.php',
        data:{
          row_id:id
        },
         success:function(response)
          {
            if(response=="success")
            {
              top.location.href='prisonerslist.php';
              alert("record deleted successfully");
             }
      } 
    });
    }
    return
  }
    function reset1()
    {
      $('#reset1').click();
    }
    function float(e)
    {
      $('#obgpa').val(to)
    }
    $('#grade_div').on('change',function(e)
    {
      e.preventDefault();
      $('.gradefield').attr('hidden',true);
      $('.divisionfield').attr('hidden',true);
      $('#divisionselect').attr('disabled',true);
      $('#gradeselect').attr('disabled',true);
      if($("option:selected",this).val()==='GRADE')
      {
         $('.gradefield').attr('hidden',false);
          $('#gradeselect').attr('disabled',false);
      }
      else if($("option:selected",this).val()==='Division') 
      {
      $('.divisionfield').attr('hidden',false);
      $('#divisionselect').attr('disabled',false);
      }
    });
    $('#gradingpolicy').on('change',function(event)
      {
        
       /* if(parseInt(validate)===101)
        {
          $('#obgpa').attr('disabled',false);
          $('#totalgpa').attr('disabled',false);
        }
        else
        {
          $('#obgpa').attr('disabled',true);
          $('#tgpa').attr('disabled',true);
        }
        $('#totalmarks').hide();
        $('#marksinput').hide();
        $('#tgpa').hide();
        $('#gpa').hide();
        $('#percentage').hide();*/
       $('.marksfields').attr('hidden',true);
         $('.marksfieldsinput').attr('disabled',true);
         $('#per').attr('hidden',true);
         $('#percent').attr('disabled',true);
          $('.gpafields').attr('hidden',true);
          $('.gpafields').attr('disabled',true);
         $('.gpafieldsinput').attr('disabled',true);
      if($("option:selected",this).val()==="MARKS")
      {
        $('.marksfields:hidden').attr('hidden',false);
        $('.marksfieldsinput').attr('disabled',false);
        $('#per').attr('hidden',false);
        $('#percent').attr('disabled',false);
     /* $('#totalmarks').show();
      $('#marksinput').show();
      $('#percentage').show();*/
    }
    else if($("option:selected",this).val()==="GPA")
     {
      $('#per').attr('hidden',false);
      $('#percent').attr('disabled',false);
       $('.gpafields:hidden').attr('hidden',false);
       $('.gpafieldsinput').attr('disabled',false);
     /* 
       $('#gpa').show();
        $('#tgpa').show();
      */}
    }
    );
     function percentagecal(e)
    {
      var obt=$('[name=marksinput]').val();
      var totalmarks=$('[name=totalmarks]').val();
      if(parseInt(obt)<parseInt(totalmarks))
      {
      var percentage=(parseInt(obt)/parseInt(totalmarks))*100;
      $('#percent').val(percentage.toFixed(2));
      }
      else
      {
      $('#percent').val('');
      return false;
      }
      return true;
    }
    function floatobgpa(e)
    {
      var obgpa=$('#obgpa').val();
      var ab=parseFloat(obgpa);
      $('#obgpa').val((ab.toFixed(2)));

      var obt=$('#obgpa').val();
     
      var totalmarks=$('#totalgpa').val();
      if(parseFloat(obt)<=parseInt(totalmarks))
      {
      var percentage=(parseFloat(obt)/parseInt(totalmarks))*93.33;
      $('#percent').val(percentage.toFixed(2));
      }
      else
      {
        alert("cgpa must be less than 4")
      $('#percent').val('');
      
      }
      return false;
    }
    $(document).ready(function(){
      $('#profileplus').addClass('fa-plus');
      $('.navclick').close();
      $('.sideMenuToggler').on('click',function()
      {
      $('.Wrapper').toggleClass('fold');
      $('body > nav > button.btn.bg-info.mt-4.sideMenuToggler > span').toggleClass('fa-arrow-left fa-arrow-right');
      $('body > div > div.container > div > div').toggleClass('offset-md-0 offset-md-2');
      });
       $('#sbmenu').on('click',function()
      {
      $('#profileplus').toggleClass('fa-plus fa-minus');
      }
      );
    });
  

  </script>
    <script src="../js/dataTables/jquery.dataTables.min.js"></script>
  <!--   -->
   <script src="../js/dataTables/dataTables.buttons.min.js"></script>
   <script src="../js/dataTables/buttons.print.min.js"></script>
   <script src="../js/dataTables/dataTables.buttons.min.js"></script>
   <script src="../js/dataTables/buttons.html5.min.js"></script>
   <script src="../js/dataTables/jszip.min.js"></script>
   <script src="../js/dataTables/pdfmake.min.js"></script>
   <script src="../js/dataTables/vfs_fonts.js"></script>
     <script src="../js/bootstrap/popper.min.js"></script>
     <script src="../js/bootstrap/bootstrap-datepicker.min.js"></script>
    <!-- Bootstrap js -->
    <script src="../js/bootstrap/bootstrap.min.js"></script>
    <!-- All Plugins js -->
    <script src="../js/plugins/plugins.js"></script>
    <script>
      $('#table-applist').on('search.dt', function() {
   
}); 
      $('.datepicker').datepicker({
     
        format: 'dd/mm/yyyy',
        endDate: '0d',
        autoclose: true

      });
     $('#table-res').DataTable( {
        dom: 'Bfrtip',
        buttons: [
        {
          extend: 'excel',
          filename: function(){
             var filename = "UTPs Cases List- Sent to Police Station "+$('.dataTables_filter input').val();
             return filename;
          },
         title: function(){
             var filename ="UTPs Cases List- Sent to Police Station "+$('.dataTables_filter input').val();
             return filename;
          }
          
        },
        {
          extend: 'pdf',
           filename: function(){
             var filename = "UTPs Cases List- Sent to Police Station  "+$('.dataTables_filter input').val();
             return filename;
          }, 
           title: function(){
             var filename ="UTPs Cases List- Sent to Police Station "+$('.dataTables_filter input').val();
             return filename;
          }
        },
        {
          extend: 'print',
           filename: function(){
             var filename = "Qualification List ("+$('.dataTables_filter input').val()+")";
             return filename;
           },
           title: function(){
             var filename ='<h1 style="text-align:center; margin: 30px;">'+"UTPs Cases List- Sent to Police Station "+$('.dataTables_filter input').val();'</h1>';
             return filename;
          }
        }
        ]
        }
       );


  </script>
    <!-- Active js -->
    <script src="../js/active.js"></script>
  </body>
  </html>