<?php include "common/user_log.php"; ?>
<!DOCTYPE html>
<html>
  <head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <title>NWP Engineering Department</title>
    <!-- Tell the browser to be responsive to screen width -->
    <meta content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no" name="viewport">
    <!-- Bootstrap 3.3.5 -->
    <link rel="stylesheet" href="bootstrap/css/bootstrap.min.css">
    <!-- Font Awesome -->
    <link rel="stylesheet" href="dist/css/font-awesome.min.css">
    <!-- Ionicons -->
    <link rel="stylesheet" href="dist/css/ionicons.min.css">
    <!-- daterange picker -->
    <link rel="stylesheet" href="plugins/daterangepicker/daterangepicker-bs3.css">
    <!-- iCheck for checkboxes and radio inputs -->
    <link rel="stylesheet" href="plugins/iCheck/all.css">
    <!-- Bootstrap Color Picker -->
    <link rel="stylesheet" href="plugins/colorpicker/bootstrap-colorpicker.min.css">
    <!-- Bootstrap time Picker -->
    <link rel="stylesheet" href="plugins/timepicker/bootstrap-timepicker.min.css">
    <!-- Select2 -->
    <link rel="stylesheet" href="plugins/select2/select2.min.css">
	<!-- DataTables -->
    <link rel="stylesheet" href="plugins/datatables/dataTables.bootstrap.css">
    <!-- Theme style -->
    <link rel="stylesheet" href="dist/css/AdminLTE.min.css">
    <!-- AdminLTE Skins. Choose a skin from the css/skins
         folder instead of downloading all of them to reduce the load. -->
    <link rel="stylesheet" href="dist/css/skins/_all-skins.min.css">
    <link rel="stylesheet" href="bootstrap-sweetalert/lib/sweet-alert.css" />



  </head>
  <body class="hold-transition skin-blue sidebar-mini sidebar-collapse">
    <div class="wrapper">

      <header class="main-header">
        <!-- Logo -->
         <a href="home.php" class="logo">
          <!-- mini logo for sidebar mini 50x50 pixels -->
         <span class="logo-mini"><img src="img/logo.png" width="100"></span>
          <!-- logo for regular state and mobile devices -->
        <span class="logo-lg"><b><img src="img/logo.png" width="100"></b></span>
        </a>
        <!-- Header Navbar: style can be found in header.less -->
        <nav class="navbar navbar-static-top" role="navigation">
          <!-- Sidebar toggle button-->
          <a href="#" class="sidebar-toggle" data-toggle="offcanvas" role="button">
            <span class="sr-only">Toggle navigation</span>
            <span class="icon-bar"></span>
            <span class="icon-bar"></span>
            <span class="icon-bar"></span>
			 <span class="logo-lg">
             &nbsp;&nbsp;<font face="Lucida Sans Unicode, Lucida Grande, sans-serif">NWP Engineering Department</font></span>
          </a>
		
          <div class="navbar-custom-menu">
            <ul class="nav navbar-nav">

              <!-- User Account: style can be found in dropdown.less -->
              <li class="dropdown user user-menu">
                <a href="#" class="dropdown-toggle" data-toggle="dropdown">
                  <img src="dist/img/user2-160x160.png" class="user-image" alt="User Image">
                  <span class="hidden-xs"><?php echo $name; ?></span>
                </a>
                <ul class="dropdown-menu">
                  <!-- User image -->
                  <li class="user-header">
                    <img src="dist/img/user2-160x160.png" class="img-circle" alt="User Image">
                    <p>
             NWP Engineering Department
                    
                    </p>
                  </li>
                  <!-- Menu Body -->
                 
                  <!-- Menu Footer-->
                  <li class="user-footer">
                    <div class="pull-left">
                      
                    </div>
                    <div class="pull-right">
                      <a href="distroy.php" class="btn btn-default btn-flat">Sign out</a>
                    </div>
                  </li>
                </ul>
              </li>
              <!-- Control Sidebar Toggle Button -->
              <li>
                <a href="#" data-toggle="control-sidebar"><i class="fa fa-gears"></i></a>
              </li>
            </ul>
          </div>
        </nav>
      </header>
      <!-- Left side column. contains the logo and sidebar -->
      <aside class="main-sidebar">
        <!-- sidebar: style can be found in sidebar.less -->
        <section class="sidebar">
          <!-- Sidebar user panel -->
    <?php include "common/sidebar.php"; ?>  
     
        </section>
        <!-- /.sidebar -->
      </aside>

      <!-- Content Wrapper. Contains page content -->
      <div class="content-wrapper">
        <!-- Content Header (Page header) -->
        <section class="content-header">
          <h1>
            Cadre
          </h1>
          
    <ol class="breadcrumb">
      <li><a href="home.php"><i class="fa fa-home"></i> Home</a></li>
    </ol>
        </section>

        <!-- Main content -->
        <section class="content">

<!-- ************************************************* -->
  <div class="box box-info only_eng"> 
    <div class="box-header with-border">
      <h3 class="box-title">Cadre Details</h3>
    </div>

    <div class="box-body"> 
      <form id="form_cadre" action="javascript:void(0);">
	
		<div class="form-group"> 
          <label>Designation:<font color="#FF0000">*</font></label>
			<select class="form-control select2 error" id="designation" name="designation" style="width: 100%;" required>
			  <option></option>
			  <?php
				$sql="SELECT * FROM designation ORDER BY name ASC";
				$result=mysqli_query($conn, $sql);
				while ($row = mysqli_fetch_array($result)){ ?>
				<option value="<?php echo $row['name']; ?>"><?php echo $row['name']; ?></option>
			  <?php } ?>
			</select>
        </div>

        <div class="form-group"> 
          <label>Code.No:<font color="#FF0000"></font></label>
          <input type="text" class="form-control error" id="code_no" name="code_no" autocomplete="off" >
        </div>

        <div class="form-group"> 
          <label>Service:<font color="#FF0000">*</font></label>
          <input type="text" class="form-control error" id="service" name="service" autocomplete="off" required>
        </div>

        <div class="form-group"> 
          <label>Grade / Class:<font color="#FF0000">*</font></label>
          <input type="text" class="form-control error" id="grade_class" name="grade_class" autocomplete="off" required>
        </div>

        <div class="form-group"> 
          <label>Salary Code:<font color="#FF0000">*</font></label>
          <input type="text" class="form-control error" id="salary_code" name="salary_code" autocomplete="off" required>
        </div>

        <div class="form-group"> 
          <label>Service level:<font color="#FF0000">*</font></label>
          <input type="text" class="form-control error" id="service_level" name="service_level" autocomplete="off" required>
        </div>

        <div class="form-group col-md-4"> 
          <label>Amended Cadre:<font color="#FF0000">*</font></label>
          <input type="text" class="form-control error" id="amended_cadre" name="amended_cadre" autocomplete="off" required>
        </div>

        <div class="form-group col-md-4"> 
          <label>No.of.Employees:<font color="#FF0000">*</font></label>
          <input type="text" class="form-control error" id="no_of_emp" name="no_of_emp" autocomplete="off" required>
        </div>

        <div class="form-group col-md-4"> 
          <label>Transfers In:<font color="#FF0000"></font></label>
          <input type="text" class="form-control error" id="transfer_in" name="transfer_in" autocomplete="off" >
        </div>

        <div class="form-group col-md-4"> 
          <label>Transfers Out:<font color="#FF0000"></font></label>
          <input type="text" class="form-control error" id="transfer_out" name="transfer_out" autocomplete="off" >
        </div>

        <div class="form-group col-md-4"> 
          <label>Retirement/Resignation:<font color="#FF0000"></font></label>
          <input type="text" class="form-control error" id="retirement_resignation" name="retirement_resignation" autocomplete="off" >
        </div>

        <div class="form-group col-md-4"> 
          <label>Deaths:<font color="#FF0000"></font></label>
          <input type="text" class="form-control error" id="deths" name="deths" autocomplete="off" >
        </div>

        <div class="form-group col-md-4"> 
          <label>New Appointment:<font color="#FF0000"></font></label>
          <input type="text" class="form-control error" id="new_appointments" name="new_appointments" autocomplete="off" >
        </div>

        <div class="form-group col-md-4"> 
          <label>Permanent:<font color="#FF0000"></font></label>
          <input type="text" class="form-control error" id="permanent" name="permanent" autocomplete="off" >
        </div>

        <div class="form-group col-md-4"> 
          <label>Vacancies:<font color="#FF0000"></font></label>
          <input type="text" class="form-control error" id="vacancles" name="vacancles" autocomplete="off" >
        </div>

        <div class="form-group col-md-4"> 
          <label>Excess:<font color="#FF0000"></font></label>
          <input type="text" class="form-control error" id="excess" name="excess" autocomplete="off" >
        </div>

        <div class="form-group col-md-4"> 
          <label>Casual:<font color="#FF0000"></font></label>
          <input type="text" class="form-control error" id="casual" name="casual" autocomplete="off" >
        </div>

        <div class="form-group col-md-4"> 
          <label>Substitute:<font color="#FF0000"></font></label>
          <input type="text" class="form-control error" id="substitute" name="substitute" autocomplete="off" >
        </div>

        <div class="form-group col-md-4"> 
          <label>Contracts:<font color="#FF0000"></font></label>
          <input type="text" class="form-control error" id="contracts" name="contracts" autocomplete="off" >
        </div>

        <div class="form-group col-md-4"> 
          <label>Total:<font color="#FF0000"></font></label>
          <input type="text" class="form-control error" id="total" name="total" autocomplete="off" >
        </div>
        <div class="box-footer col-md-12">
          <button type="submit" class="btn btn-primary">SUBMIT</button>
        </div>
      </form>
    </div>
  </div>

 <!-- /.table -->
        
    <div class="box box-info"> 
      <div class="box-header"> 
        <h3 class="box-title">Cadre Details</h3>
      </div>
      <!-- /.box-header -->
      <div class="box-body table-responsive"> 
        <table id="example1" class="table table-bordered table-striped">
          <thead>
            <!-- <tr>
              <th rowspan="2">Ser No</th>
              <th rowspan="2">Designation</th>
              <th rowspan="2">Code No.(for office use)</th>
              <th rowspan="2">Service</th>
              <th rowspan="2">Grade / Class</th>
              <th>Salary Code (according to the P/A circular 6/2006)</th>
              <th>Service level (according to the P/A circular 6/2006)</th>
              <th rowspan="2">Amended Cadre</th>
              <th rowspan="2">No.of.Employees as at 31.12.<?php echo date("Y");?></th>
              <th colspan="5">Change between 30.09.<?php echo date("Y");?> to 31.12.<?php echo date("Y");?></th>
              <th>Transfers In</th>
              <th>Transfers Out</th>
              <th>Retirement / Resignation</th>
              <th>Deaths</th>
              <th>New Appointment - ments</th>
              <th>Deaths</th>
              <th class="only_eng">Edit</th>
            </tr> -->
            <tr>
              <th rowspan="3" scope="col"><!-- <div style="transform: rotate(270deg);"> -->Ser No<!-- </div> --></th>
              <th rowspan="3" scope="col">Designation</th>
              <th rowspan="3" scope="col">Code No.(for office use)</th>
              <th rowspan="3" scope="col">Service</th>
              <th rowspan="3" scope="col">Grade / Class</th>
              <th rowspan="2" scope="col">Salary Code</th>
              <th rowspan="2" scope="col">Service level</th>
              <th rowspan="3" scope="col">Amended Cadre</th>
              <th rowspan="3" scope="col">No.of.Employees as at 31.12.<?php echo date("Y");?></th>
              <th colspan="5" rowspan="2" scope="col">Change between 30.09.<?php echo date("Y");?> to 31.12.<?php echo date("Y");?></th>
              <th colspan="7" scope="col">Particulars as at 31.12.<?php echo date("Y");?></th>
              <th rowspan="3" scope="col">Edit</th>
              <th rowspan="3" scope="col">Remove</th>
            </tr>
            <tr>
              <th colspan="7" scope="col">Existing Cadre</th>
            </tr>
            <tr>
              <th scope="col"><!-- <div style="transform: rotate(270deg);"> -->according to the P/A circular 6/2006<!-- </div> --></th>
              <th scope="col">according to the P/A circular 6/2006</th>
              <th scope="col">Transfers In</th>
              <th scope="col">Transfers Out</th>
              <th scope="col">Retirement / Resignation</th>
              <th scope="col">Deaths</th>
              <th scope="col">New Appointment - ments</th>
              <th scope="col">Permanent</th>
              <th scope="col">Vacancles</th>
              <th scope="col">Excess</th>
              <th scope="col">Casual</th>
              <th scope="col">Substitute</th>
              <th scope="col">Contracts</th>
              <th scope="col">Total</th>
            </tr>
          </thead>
          <tbody>
            <?php 
              $sql="SELECT * FROM cader_details_tbl ORDER BY id ASC";
              $result=mysqli_query($conn, $sql);
              $x = 0;
              while ($row = mysqli_fetch_array($result)){ $x++;
            ?>

            <tr>

              <td><?php echo $x; ?></td>
              <td><?php echo $row['designation']; ?></td>
              <td><?php echo $row['code_no']; ?></td>
              <td><?php echo $row['service']; ?></td>
              <td><?php echo $row['grade_class']; ?></td>
              <td><?php echo $row['salary_code']; ?></td>
              <td><?php echo $row['service_level']; ?></td>
              <td><?php echo $row['amended_cadre']; ?></td>
              <td><?php echo $row['no_of_emp']; ?></td>
              <td><?php echo $row['transfer_in']; ?></td>
              <td><?php echo $row['transfer_out']; ?></td>
              <td><?php echo $row['retirement_resignation']; ?></td>
              <td><?php echo $row['deths']; ?></td>
              <td><?php echo $row['new_appointments']; ?></td>
              <td><?php echo $row['permanent']; ?></td>
              <td><?php echo $row['vacancles']; ?></td>
              <td><?php echo $row['excess']; ?></td>
              <td><?php echo $row['casual']; ?></td>
              <td><?php echo $row['substitute']; ?></td>
              <td><?php echo $row['contracts']; ?></td>
              <td><?php echo $row['total']; ?></td>
              <td align="center" class="only_eng">
                 <button class="btn btn-info btn-sm btn_up" data-toggle="modal" data-target="#edit_lng" value="<?php echo $row['id']; ?>"><span class="glyphicon glyphicon-pencil"></span> &nbsp;EDIT </button>
              </td>
              <td align="center" class="only_eng">
                  <button value="<?php echo $row['id']; ?>" class="btn btn-danger btn-sm btn_dell">
                <span class="glyphicon glyphicon-trash"></span> &nbsp;DELETE </button>
              </td>

            </tr>
            <?php  } ?>
          </tbody>
        </table>
      </div>
      <!-- /.box-body -->
    </div>
    
  </section>
   
      </div>
	      <!-- /.End table -->
<!-- ************************************************* -->
      
           <!-- /.col -->
              </div><!-- /.row -->
            </div><!-- /.box-body -->
            
          

          <div class="row">
            
    
    
      </div>
      <!-- /.col (right) -->
         

      </div>


      <!-- Modal -->
  <div class="modal fade" id="edit_lng" 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" id="test_id">Edit Cadre</h4>
        </div>
        <div class="modal-body">

          <form id="form_cadre_up" action="javascript:void(0);">

            <div class="form-group"> 
              <label>Designation:<font color="#FF0000"></font></label>
				<select class="form-control error" id="designation_up" name="designation_up" style="width: 100%;" required>
				  <option></option>
				  <?php
					$sql="SELECT * FROM designation ORDER BY name ASC";
					$result=mysqli_query($conn, $sql);
					while ($row = mysqli_fetch_array($result)){ ?>
					<option value="<?php echo $row['name']; ?>"><?php echo $row['name']; ?></option>
				  <?php } ?>
				</select>			  
            </div>

            <div class="form-group"> 
              <label>Code.No:<font color="#FF0000"></font></label>
              <input type="text" class="form-control error" id="code_no_up" name="code_no" autocomplete="off">
            </div>

            <div class="form-group"> 
              <label>Service:<font color="#FF0000"></font></label>
              <input type="text" class="form-control error" id="service_up" name="service" autocomplete="off">
            </div>

            <div class="form-group"> 
              <label>Grade / Class:<font color="#FF0000"></font></label>
              <input type="text" class="form-control error" id="grade_class_up" name="grade_class" autocomplete="off">
            </div>

            <div class="form-group"> 
              <label>Salary Code:<font color="#FF0000"></font></label>
              <input type="text" class="form-control error" id="salary_code_up" name="salary_code" autocomplete="off">
            </div>

            <div class="form-group"> 
              <label>Service level:<font color="#FF0000"></font></label>
              <input type="text" class="form-control error" id="service_level_up" name="service_level" autocomplete="off">
            </div>

            <div class="form-group"> 
              <label>Amended Cadre:<font color="#FF0000"></font></label>
              <input type="text" class="form-control error" id="amended_cadre_up" name="amended_cadre" autocomplete="off">
            </div>

            <div class="form-group"> 
              <label>No.of.Employees:<font color="#FF0000"></font></label>
              <input type="text" class="form-control error" id="no_of_emp_up" name="no_of_emp" autocomplete="off">
            </div>

            <div class="form-group"> 
              <label>Transfers In:<font color="#FF0000"></font></label>
              <input type="text" class="form-control error" id="transfer_in_up" name="transfer_in" autocomplete="off">
            </div>

            <div class="form-group"> 
              <label>Transfers Out:<font color="#FF0000"></font></label>
              <input type="text" class="form-control error" id="transfer_out_up" name="transfer_out" autocomplete="off">
            </div>

            <div class="form-group"> 
              <label>Retirement/Resignation:<font color="#FF0000"></font></label>
              <input type="text" class="form-control error" id="retirement_resignation_up" name="retirement_resignation" autocomplete="off">
            </div>

            <div class="form-group"> 
              <label>Deaths:<font color="#FF0000"></font></label>
              <input type="text" class="form-control error" id="deths_up" name="deths" autocomplete="off">
            </div>

            <div class="form-group"> 
              <label>New Appointment:<font color="#FF0000"></font></label>
              <input type="text" class="form-control error" id="new_appointments_up" name="new_appointments" autocomplete="off">
            </div>

            <div class="form-group"> 
              <label>Permanent:<font color="#FF0000"></font></label>
              <input type="text" class="form-control error" id="permanent_up" name="permanent" autocomplete="off">
            </div>

            <div class="form-group"> 
              <label>Vacancies:<font color="#FF0000"></font></label>
              <input type="text" class="form-control error" id="vacancles_up" name="vacancles" autocomplete="off">
            </div>

            <div class="form-group"> 
              <label>Excess:<font color="#FF0000"></font></label>
              <input type="text" class="form-control error" id="excess_up" name="excess" autocomplete="off">
            </div>

            <div class="form-group"> 
              <label>Casual:<font color="#FF0000"></font></label>
              <input type="text" class="form-control error" id="casual_up" name="casual" autocomplete="off">
            </div>

            <div class="form-group"> 
              <label>Substitute:<font color="#FF0000"></font></label>
              <input type="text" class="form-control error" id="substitute_up" name="substitute" autocomplete="off">
            </div>

            <div class="form-group"> 
              <label>Contracts:<font color="#FF0000"></font></label>
              <input type="text" class="form-control error" id="contracts_up" name="contracts" autocomplete="off">
            </div>

            <div class="form-group"> 
              <label>Total:<font color="#FF0000"></font></label>
              <input type="text" class="form-control error" id="total_up" name="total" autocomplete="off">
            </div>

            <input type="hidden" name="id_holder" id="id_holder">
            <div class="box-footer">
              <button type="submit" class="btn btn-danger">UPDATE</button>
            </div>
          </form>

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




<footer class="main-footer"> 
<div class="pull-right hidden-xs">
          
        </div>  <strong>Copyright &copy; NWP Engineering Department</strong> All rights reserved.
      </footer>

      <!-- Control Sidebar -->
      <aside class="control-sidebar control-sidebar-dark">
        <!-- Create the tabs -->
        <ul class="nav nav-tabs nav-justified control-sidebar-tabs">
          <li><a href="#control-sidebar-home-tab" data-toggle="tab"><i class="fa fa-home"></i></a></li>
          <li><a href="#control-sidebar-settings-tab" data-toggle="tab"><i class="fa fa-gears"></i></a></li>
        </ul>
        <!-- Tab panes -->
        <div class="tab-content">
          <!-- Home tab content -->
          <div class="tab-pane" id="control-sidebar-home-tab">
          </div><!-- /.tab-pane -->

          </div><!-- /.tab-pane -->
        </div>
      </aside><!-- /.control-sidebar -->
      <!-- Add the sidebar's background. This div must be placed
           immediately after the control sidebar -->
      <div class="control-sidebar-bg"></div>
    </div><!-- ./wrapper -->


    <!-- jQuery 2.1.4 -->
    <script src="plugins/jQuery/jQuery-2.1.4.min.js"></script>
    <!-- Bootstrap 3.3.5 -->
    <script src="bootstrap/js/bootstrap.min.js"></script>
    <!-- Select2 -->
    <script src="plugins/select2/select2.full.min.js"></script>
	<!-- DataTables -->
    <script src="plugins/datatables/jquery.dataTables.min.js"></script>
    <script src="plugins/datatables/dataTables.bootstrap.min.js"></script>
    <!-- InputMask -->
    <script src="plugins/input-mask/jquery.inputmask.js"></script>
    <script src="plugins/input-mask/jquery.inputmask.date.extensions.js"></script>
    <script src="plugins/input-mask/jquery.inputmask.extensions.js"></script>
    <!-- date-range-picker -->
    <script src="plugins/daterangepicker/moment.min.js"></script>
    <script src="plugins/daterangepicker/daterangepicker.js"></script>
    <!-- bootstrap color picker -->
    <script src="plugins/colorpicker/bootstrap-colorpicker.min.js"></script>
    <!-- bootstrap time picker -->
    <script src="plugins/timepicker/bootstrap-timepicker.min.js"></script>
    <!-- SlimScroll 1.3.0 -->
    <script src="plugins/slimScroll/jquery.slimscroll.min.js"></script>
    <!-- iCheck 1.0.1 -->
    <script src="plugins/iCheck/icheck.min.js"></script>
    <!-- FastClick -->
    <script src="plugins/fastclick/fastclick.min.js"></script>
    <!-- AdminLTE App -->
    <script src="dist/js/app.min.js"></script>
    <!-- AdminLTE for demo purposes -->
    <script src="dist/js/demo.js"></script>
    <script src="bootstrap-sweetalert/lib/sweet-alert.min.js"></script>
	
    <!-- Page script -->
    <script>
      $(function () {
        //Initialize Select2 Elements
        $(".select2").select2();

        //Datemask dd/mm/yyyy
        $("#datemask").inputmask("dd/mm/yyyy", {"placeholder": "yyyy-mm-dd"});
        //Datemask2 mm/dd/yyyy
        $("#datemask2").inputmask("mm/dd/yyyy", {"placeholder": "yyyy-mm-dd"});
        //Money Euro
        $("[data-mask]").inputmask();

        //Date range picker
        $('#reservation').daterangepicker();
        //Date range picker with time picker
       $('#date_start').daterangepicker({timePicker: false, timePickerIncrement: 30, format: 'YYYY-MM-DD'});
       $('#date_comp').daterangepicker({timePicker: false, timePickerIncrement: 30, format: 'YYYY-MM-DD'});
       $('#date_award').daterangepicker({timePicker: false, timePickerIncrement: 30, format: 'YYYY-MM-DD'});


       $('#date_start_up').daterangepicker({timePicker: false, timePickerIncrement: 30, format: 'YYYY-MM-DD'});
       $('#date_comp_up').daterangepicker({timePicker: false, timePickerIncrement: 30, format: 'YYYY-MM-DD'});
		   $('#date_award_up').daterangepicker({timePicker: false, timePickerIncrement: 30, format: 'YYYY-MM-DD'});


		   $('#exp_date_up').daterangepicker({timePicker: false, timePickerIncrement: 30, format: 'YYYY-MM-DD'});
        //Date range as a button
        $('#daterange-btn').daterangepicker(
            {
              ranges: {
                'Today': [moment(), moment()],
                'Yesterday': [moment().subtract(1, 'days'), moment().subtract(1, 'days')],
                'Last 7 Days': [moment().subtract(6, 'days'), moment()],
                'Last 30 Days': [moment().subtract(29, 'days'), moment()],
                'This Month': [moment().startOf('month')],
                'Last Month': [moment().subtract(1, 'month').startOf('month')]
              },
              startDate: moment().subtract(29, 'days'),
           
            },
        function (start) {
          $('#reportrange span').html(start.format('MMMM D, YYYY'));
        }
        );

        //iCheck for checkbox and radio inputs
        $('input[type="checkbox"].minimal, input[type="radio"].minimal').iCheck({
          checkboxClass: 'icheckbox_minimal-blue',
          radioClass: 'iradio_minimal-blue'
        });
        //Red color scheme for iCheck
        $('input[type="checkbox"].minimal-red, input[type="radio"].minimal-red').iCheck({
          checkboxClass: 'icheckbox_minimal-red',
          radioClass: 'iradio_minimal-red'
        });
        //Flat red color scheme for iCheck
        $('input[type="checkbox"].flat-red, input[type="radio"].flat-red').iCheck({
          checkboxClass: 'icheckbox_flat-green',
          radioClass: 'iradio_flat-green'
        });

        
      });
	  
      $(function () {
        $("#example1").DataTable();
        $('#example2').DataTable({
          "paging": true,
          "lengthChange": false,
          "searching": false,
          "ordering": true,
          "info": true,
          "autoWidth": false
        });
      });
	</script>

<script>
/****************************** Insert  *********************************************************/

$("#form_cadre_up").on('submit',(function(e) {

    e.preventDefault();
    $.ajax({
    url: "function/cadre_tbl_editer_fun.php",
    type: "POST",
    data:  new FormData(this),
    contentType: false,
        cache: false,
    processData:false,
    beforeSend : function()
    {
      //$("#preview").fadeOut();
      //$("#err").fadeOut();
    },
    success: function(data){
      if(data.status=='ok')
      {
        swal({
          title: "Updated!",
          text: "Successfully Updated!",
          type: "success",
          confirmButtonText: "OK"
            },
            function (isConfirm) {
          if (isConfirm) {
              window.location.href = "cadre_tbl_editer.php";
          }
        });
      }
      else
      {
        swal("Oops...", "Something went wrong!", "warning");
      }
      
      },
      error: function(e)
      {
        //$("#err").html(e).fadeIn();
        swal("Oops...", "Something went wrong!", "warning");
      }
   });
  //alert("Done");
}));

$("#form_cadre").on('submit',(function(e) {

    e.preventDefault();
    $.ajax({
    url: "function/cadre_tbl_editer_fun.php",
    type: "POST",
    data:  new FormData(this),
    contentType: false,
        cache: false,
    processData:false,
    beforeSend : function()
    {
      //$("#preview").fadeOut();
      //$("#err").fadeOut();
    },
    success: function(data){
      if(data.status=='ok')
      {
        swal({
          title: "Added!",
          text: "Successfully Added!",
          type: "success",
          confirmButtonText: "OK"
            },
            function (isConfirm) {
          if (isConfirm) {
              window.location.href = "cadre_tbl_editer.php";
          }
        });
      }
      else
      {
        swal("Oops...", "Something went wrong!", "warning");
      }
      
      },
      error: function(e)
      {
        //$("#err").html(e).fadeIn();
        swal("Oops...", "Something went wrong!", "warning");
      }
   });
  //alert("Done");
}));


/******************************************* Remove Contact **************************************/

$(".btn_dell").click(function(){
  var x = $(this).val();
  swal({
	title: "Are you sure?",
	text: "Your may not be able to recover!",
	type: "warning",
	showCancelButton: true,
	confirmButtonClass: "btn-danger",
	confirmButtonText: "Yes, delete it!",
	closeOnConfirm: false
  },
	function () {
	  del_func(x);
	}
  );
});

function del_func(reg_id){
	if(reg_id === '') {

		swal("Warning!", "Please Select Valid Record!", "warning");
	
	} else {
		
		$.post( "function/cadre_tbl_editer_fun.php", {remove_type: "data", reg_id : reg_id}, function( data ) {	  
		    if (data.status == 'ok') {
			  swal({
				title: "Deleted!",
				text: "Successfully Deleted!",
				type: "success",
				confirmButtonText: "OK"
			  },
				  function (isConfirm) {
				if (isConfirm) {
					window.location.href = "cadre_tbl_editer.php";
				}
			  });
			}else{
			  swal("Oops...", "Something went wrong!", "warning");
			}
		}, "json");
	}
}

/******************************************* Load Form Data **************************************/

$(".btn_up").click(function(){
  load_form_data($(this).val());
  $("#con_reg_id").val($(this).val());
});

function load_form_data(reg_id){
  $.post( "function/cadre_tbl_editer_fun.php", { get_dataset: "data", reg_id : reg_id }, function( data ) {
    $.each(data, function (index, data) {

      $('#id_holder').val(data.id);
      $('#designation_up').val(data.designation);
      $('#code_no_up').val(data.code_no);
      $('#service_up').val(data.service);
      $('#grade_class_up').val(data.grade_class);
      $('#salary_code_up').val(data.salary_code);
      $('#service_level_up').val(data.service_level);
      $('#amended_cadre_up').val(data.amended_cadre);
      $('#no_of_emp_up').val(data.no_of_emp);
      $('#transfer_in_up').val(data.transfer_in);
      $('#transfer_out_up').val(data.transfer_out);
      $('#retirement_resignation_up').val(data.retirement_resignation);
      $('#deths_up').val(data.deths);
      $('#new_appointments_up').val(data.new_appointments);
      $('#permanent_up').val(data.permanent);
      $('#vacancles_up').val(data.vacancles);
      $('#excess_up').val(data.excess);
      $('#casual_up').val(data.casual);
      $('#substitute_up').val(data.substitute);
      $('#contracts_up').val(data.contracts);
      $('#total_up').val(data.total);
      
    });

  }, "json");
}


</script>	
		
</body>
</html>
