|
Server IP : 10.128.40.6 / Your IP : 216.73.216.233 Web Server : Apache System : Linux webd006.cluster128.gra.hosting.ovh.net 5.15.206-ovh-vps-grsec-zfs-classid #1 SMP Fri May 15 02:41:25 UTC 2026 x86_64 User : logmcpe ( 111175) PHP Version : 7.3.33 Disable Function : _dyuweyrj4,_dyuweyrj4r,dl MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0705) : /home/logmcpe/www/TMCPRO/test/../ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
include 'includes/config_tmcpro.php' ;
include 'includes/stable_functions_tmcpro.php' ;
// ini_set('display_errors','on');
// error_reporting(E_ALL);
// kkk
// exit() ;
$ferier = array('0101','0501','0508','0515','0714','1111','1101','1225');
function count_week_days($__date_from, $__date_to, $__holidays_between=array(), $__weekend_days=array()) {
$total_days_count = $__date_to > $__date_from ? round(($__date_to - $__date_from)/(24*3600)) : 0;
$full_weeks_count = floor($total_days_count/7);
$weekend_days_count = $full_weeks_count*count($__weekend_days);
$days_left_uncovered = $total_days_count - $full_weeks_count*7;
for($i = 0; $i < $days_left_uncovered; $i++) {
$date_to_check = $i ? strtotime("+{$i} day", $__date_from) : $__date_from;
if(in_array(date('N', $date_to_check), $__weekend_days)) {
$weekend_days_count++;
}
}
$week_days_count = $total_days_count - $weekend_days_count - count($__holidays_between);
return $week_days_count;
}
if(isset($_POST['salarie_ids']) && !empty($_POST['salarie_ids']) && !empty($_POST['du']) && !empty($_POST['au'])){
$du = dateformaint($_POST['du']);
$au = dateformaint($_POST['au']);
}
else {
$du = date('Ym01');
$au = date('Ymt');
}
$du = int2date_autre_format($du) ;
$au = int2date_autre_format($au) ;
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<title>MC PRO | Paye</title>
<!-- Tell the browser to be responsive to screen width -->
<meta name="viewport" content="width=device-width, initial-scale=1">
<!-- Font Awesome -->
<link rel="stylesheet" href="../plugins/fontawesome-free/css/all.min.css">
<!-- Ionicons -->
<link rel="stylesheet" href="https://code.ionicframework.com/ionicons/2.0.1/css/ionicons.min.css">
<!-- daterange picker -->
<link rel="stylesheet" href="../plugins/daterangepicker/daterangepicker.css">
<!-- iCheck for checkboxes and radio inputs -->
<link rel="stylesheet" href="../plugins/icheck-bootstrap/icheck-bootstrap.min.css">
<!-- Bootstrap Color Picker -->
<link rel="stylesheet" href="../plugins/bootstrap-colorpicker/css/bootstrap-colorpicker.min.css">
<!-- Tempusdominus Bbootstrap 4 -->
<link rel="stylesheet" href="../plugins/tempusdominus-bootstrap-4/css/tempusdominus-bootstrap-4.min.css">
<!-- Select2 -->
<link rel="stylesheet" href="../plugins/select2/css/select2.min.css">
<link rel="stylesheet" href="../plugins/select2-bootstrap4-theme/select2-bootstrap4.min.css">
<!-- Bootstrap4 Duallistbox -->
<link rel="stylesheet" href="../plugins/bootstrap4-duallistbox/bootstrap-duallistbox.min.css">
<!-- Theme style -->
<link rel="stylesheet" href="../../dist/css/adminlte.min.css">
<!-- Google Font: Source Sans Pro -->
<link href="https://fonts.googleapis.com/css?family=Source+Sans+Pro:300,400,400i,700" rel="stylesheet">
<link rel="stylesheet" href="listing.css">
</head>
<body class="hold-transition sidebar-mini">
<div class="wrapper">
<!-- TOP MENU -->
<nav class="main-header navbar navbar-expand navbar-white navbar-light">
<!-- Menu extensible -->
<ul class="navbar-nav">
<li class="nav-item">
<a class="nav-link" data-widget="pushmenu" href="#"><i class="fas fa-bars"></i></a>
</li>
</ul>
<!-- liens TOP MENU DROITE -->
<ul class="navbar-nav ml-auto">
<!-- Placer ici l'élément à positionner à droite du TOP MENU -->
</ul>
</nav> <!-- fin du TOP MENU -->
<?php include('menu.php'); ?>
<div class="modal fade" id="PrestUpt" role="dialog" class="modal fade task-modal-single in" tabindex="-1" aria-labelledby="myLargeModalLabel" >
<div class="modal-dialog modal-lg">
<div class="modal-content data">
<div id="jalil" ></div>
</div>
</div>
</div>
<!-- Content Wrapper. Contains page content -->
<div class="content-wrapper">
<!-- Content Header (Page header) -->
<!-- Main content -->
<section class="content">
<div class="container-fluid">
<div class="row">
<!-- /.col -->
<div class="col-md-12">
<div class="card" >
<div class="card-header">
<h5 class="card-title"><i class="nav-icon fas fa-cash-register"></i> Préparation de la Paye</h5>
</div>
<!-- form start -->
<form role="form" method='POST' action=''>
<!-- /.card-header -->
<div class="card-body" >
<div class="row">
<div class="col-12">
<div class="form-group">
<select class="duallistbox" multiple="multiple" style="height: 150px;" name="salarie_ids[]" id="salarie_ids[]">
<?php $req =dbi_query("SELECT * FROM salarie WHERE salarie_statut = '1' ORDER BY salarie_nom,salarie_prenom ASC") ;
while( $sal=dbi_fetch_row($req)) { ?>
<option value="<?php echo $sal['salarie_id'] ; ?>" <?php if( isset($_POST['salarie_ids']) && in_array($sal['salarie_id'] , $_POST['salarie_ids'])) echo 'selected';?>><?php echo $sal['salarie_nom'].' '.$sal['salarie_prenom']; ?></option>
<?php } ?>
</select>
</div>
</div>
<div class="form-group col-md-3">
<label>Du</label>
<div class="input-group">
<div class="input-group-prepend"> <span class="input-group-text"><i class="far fa-calendar-alt"></i></span></div>
<input type="date" class="form-control" id="du" name="du" placeholder="jj/mm/aaaa" value='<?php echo $du;?>' />
</div>
</div>
<div class="form-group col-md-3">
<label>Du</label>
<div class="input-group">
<div class="input-group-prepend"> <span class="input-group-text"><i class="far fa-calendar-alt"></i></span></div>
<input type="date" class="form-control" id="au" name="au" placeholder="jj/mm/aaaa" value='<?php echo $au;?>' />
</div>
</div>
<div class="col-sm-3">
<div class="form-group"><label><br/></label>
<button type="submit" class="btn btn-block bg-primary">Valider</button>
</div>
</div>
</div>
</div>
</form>
</div>
</div> <!-- /.col -->
</div><!-- /.row -->
<?php
define ('GOOD', '#2DCD0C');
define ('BAD', '#FD0005');
$mois=array('01' =>'janvier','02' =>'fevrier','03' =>'mars','04' =>'avril','05' =>'mai','06' =>'juin','07' =>'juillet','08' =>'aout','09' => 'septembre','10' => 'octobre','11' => 'novembre','12' => 'decembre');
if(isset($_POST['salarie_ids']) && !empty($_POST['salarie_ids']) && !empty($_POST['du']) && !empty($_POST['au'])){
$from = dateformaint($_POST['du']);
$to = dateformaint($_POST['au']);;
$liste = array() ;
$hb_gtot = 0;
$hcomp_gtot = 0;
$hsup_gtot = 0;
$delta_gtot = 0;
foreach($_POST['salarie_ids'] as $interv)
{
// $intervenant = dbi_fetch_row(dbi_query("select CONCAT( salarie_genre, ' ' ,salarie_nom, ' ' ,salarie_prenom ) as nom from salarie where salarie_id = $interv LIMIT 1")) ;
$inter = dbi_fetch_row(dbi_query("SELECT * FROM salarie WHERE salarie_id = $interv ")) ;
$eche= dbi_fetch_row(dbi_query("SELECT Echelon FROM echelon where echelon = '".$inter['salarie_echelon']."'"));
// $inti= dbi_fetch_row(dbi_query("SELECT intitule FROM poste_intitule where poste_intitule_ID = ".$inter['salarie_position']));
$po= dbi_fetch_row(dbi_query("SELECT Position FROM position where position = '".$inter['salarie_position']."'"));
if($inter['salarie_situation_paiement']==0)
{
$inter_paiement= "mensuel" ;
}
else
{
$inter_paiement= "hebdomadaire" ;
}
?>
<div class="row">
<div class="card col-md-12">
<div class="card-header">
<div class="user-block">
<span class="username" ><a href="#"><?php echo $inter['salarie_nom'].' '.$inter['salarie_prenom']; ?></a></span>
<span class="description"><?php echo " Position : ".$po['Position']." - Echelon : ".$eche['Echelon']." - paiement : $inter_paiement "?></span>
</div>
<!-- /.user-block -->
<div class="card-tools">
<button type="button" class="btn btn-tool" data-card-widget="collapse"><i class="fas fa-minus"></i>
</button>
<button type="button" class="btn btn-tool" data-card-widget="remove"><i class="fas fa-times"></i>
</button>
</div>
<!-- /.card-tools -->
</div>
<!-- /.card-header -->
<div class="card-body p-0">
<div class="table-responsive">
<table class="table m-0" style="width:100%">
<thead>
<tr>
<th style='text-align:left;width:260px;'>Période</th>
<th style='text-align:center;width:80px;'>Contrat</th>
<th style='text-align:center;width:80px;'>ACH</th>
<th style='text-align:center;width:80px;'>Travaillées</th>
<th style='text-align:center;'>Evénements</th>
<th style='text-align:center;width:80px;'>Delta</th>
<th style='text-align:center;width:80px;'>Dimanche</th>
<th style='text-align:center;width:120px;'>Jours fériés</th>
</tr>
</thead>
<tbody>
<?
// $debut = $from ;
$crdebut = $du ;
$ctend = $au;
// echo $crdebut .' $$$$ '.$ctend ;
while ($crdebut <= $ctend )
{
$week_start = date("Ymd", strtotime('monday this week', strtotime($crdebut)));
$week_end = date("Ymd", strtotime('sunday this week', strtotime($crdebut)));
$heures_contrat = 0;
$heures_contrat_ACH = 0;
$crdebut = date('Y-m-d', strtotime('+1 week', strtotime($crdebut)));
$sql2 = " SELECT salarie_contrat_duree_mensuelle FROM `salarie_contrat` WHERE salarie_contrat_date_debut <= $week_start AND (salarie_contrat_date_fin IS NULL OR salarie_contrat_date_fin > $week_start OR salarie_contrat_date_fin=0) AND salarie_id = $interv AND contrat_type_id NOT IN(10, 11) ORDER BY salarie_contrat_date_debut DESC LIMIT 1 " ;
$sql22 = " SELECT hebdo_moyen_complement FROM `salarie_contrat`
WHERE
salarie_id = $interv AND contrat_type_id IN(10, 11)
AND
(
( salarie_contrat_date_debut between $week_start AND $week_end )
OR
( salarie_contrat_date_fin between $week_start AND $week_end )
OR
( salarie_contrat_date_fin >= $week_end AND salarie_contrat_date_debut <= $week_start )
)
ORDER BY salarie_contrat_date_debut DESC LIMIT 1 " ;
list($heures_contrat)=dbi_fetch_row(dbi_query($sql2));
list($heures_contrat_ACH)=dbi_fetch_row(dbi_query($sql22));
$heures_contrat= round($heures_contrat/4.333 , 2);
$date = $week_start ;
$presta_Hduree_start = 0;
$presta_Hduree_end = 0;
$presta_Hduree = 0;
$presta_Hduree_dim = 0;
$presta_Hduree_fer = 0;
while ($date <= $week_end )
{
$q = dbi_query("
SELECT * FROM PRESTATIONS p where presta_date_debut <= $date AND (p.presta_date_fin >= $date OR p.presta_date_fin IS NULL)
AND ( p.presta_id IN (select presta_id FROM PRESTATIONS WHERE salarie_id = $interv ) OR p.presta_id IN ( select presta_id FROM PRESTATIONS_MODIF WHERE salarie_id = $interv ) )
");
while($prest = dbi_fetch_row($q))
{
$date_presta_sem = $prest['presta_date_debut'] ;
$q1 = dbi_query("SELECT * FROM PRESTATIONS_MODIF WHERE presta_id = ".$prest['presta_id']." order by start, modif_id ") ;
while (($m = dbi_fetch_row($q1)) && $date >= $m['start'])
{
if( $m['presta_sem'] != NULL ) $date_presta_sem = $m['start'];
$prest['salarie_id'] = $m['salarie_id'] === NULL ? $prest['salarie_id'] : $m['salarie_id'] ;
$prest['presta_sem'] = $m['presta_sem'] === NULL ? $prest['presta_sem'] : $m['presta_sem'] ;
$prest['presta_jour'] = $m['presta_jour'] === NULL ? $prest['presta_jour'] : $m['presta_jour'] ;
$prest['presta_Hduree'] = $m['presta_Hduree'] === NULL ? $prest['presta_Hduree'] : $m['presta_Hduree'] ;
}
if( $prest['salarie_id'] == $interv ) {
$day = date("w", strtotime( int2date_autre_format($date)));
if( $day == $prest['presta_jour'] OR ( $date == $prest['presta_date_debut'] && $prest['presta_date_debut'] == $prest['presta_date_fin'] ) ){
$EXP = dbi_fetch_row(dbi_query("SELECT date_presta FROM EXCEPTIONS WHERE presta_id = ".$prest['presta_id']." AND date_presta = ".$date." " )) ; ;
$nbre =count_week_days(strtotime(int2date_autre_format($date_presta_sem,'d.m.Y')), strtotime(int2date_autre_format($date,'d.m.Y')));
if($EXP ){
if( $prest['presta_sem'] == 1 )
{
if($day == 0)
$presta_Hduree_dim += $prest['presta_Hduree'] ;
elseif (in_array(date("dm", strtotime( int2date_autre_format($date))), $ferier))
$presta_Hduree_fer += $prest['presta_Hduree'] ;
}
else
{
$modolo = $nbre % $prest['presta_sem'] ;
if( $modolo == 0)
{
if($day == 0)
$presta_Hduree_dim += $prest['presta_Hduree'] ;
elseif (in_array(date("dm", strtotime( int2date_autre_format($date))), $ferier))
$presta_Hduree_fer += $prest['presta_Hduree'] ;
}
}
} else {
if( $prest['presta_sem'] == 1 )
{
if( $from > $week_start && $date < $from)
$presta_Hduree_start = $presta_Hduree_start + $prest['presta_Hduree'] ;
if( $to < $week_end && $date > $to)
$presta_Hduree_end = $presta_Hduree_end + $prest['presta_Hduree'] ;
$presta_Hduree = $presta_Hduree + $prest['presta_Hduree'] ;
}
else
{
$modolo = $nbre % $prest['presta_sem'] ;
if( $modolo == 0)
{
if( $from > $week_start && $date < $from)
$presta_Hduree_start = $presta_Hduree_start + $prest['presta_Hduree'] ;
if( $to < $week_end && $date > $to)
$presta_Hduree_end = $presta_Hduree_end + $prest['presta_Hduree'] ;
$presta_Hduree = $presta_Hduree + $prest['presta_Hduree'] ;
}
}
}
}
}
}
$date = date("Ymd", strtotime("+1 day", strtotime($date)));
}
$presta_Hduree /= 60 ;
$presta_Hduree_dim /= 60 ;
$presta_Hduree_fer /= 60 ;
$presta_Hduree_start /= 60 ;
$presta_Hduree_end /= 60 ;
$badge = 'badge-warning';
if($presta_Hduree < ($heures_contrat_ACH + $heures_contrat ))
$badge = 'badge-danger';
// else
// $badge = 'badge-warning';
$q= dbi_query("SELECT * FROM salarie_absence where salarie_id = '".$interv."' AND ( salarie_absence_date_debut BETWEEN $week_start AND $week_end OR salarie_absence_date_fin BETWEEN $week_start AND $week_end OR ( salarie_absence_date_debut <= $week_start && salarie_absence_date_fin >= $week_end ) ) " ) ;
$delta = ($presta_Hduree - $heures_contrat_ACH - $heures_contrat );
echo "<tr>";
if( $from > $week_start OR $to < $week_end ){
if( $from > $week_start ) //date("Y-m-t", strtotime($a_date)
echo "<td style='text-align:center;vertical-align: middle;'><b> ".int2date_autre_format($week_start,'d/m/Y')." </b> au <b> ".int2date_autre_format($week_start,'t/m/Y')." </b><b> ".int2date_autre_format($week_end,'01/m/Y')." </b> au <b> ".int2date_autre_format($week_end,'d/m/Y')." </b> </td>";
else
echo "<td style='text-align:center;vertical-align: middle;'><b> ".int2date_autre_format($week_start,'d/m/Y')." </b> au <b> ".int2date_autre_format($week_start,'t/m/Y')." </b><b> ".int2date_autre_format($week_end,'01/m/Y')." </b> au <b> ".int2date_autre_format($week_end,'d/m/Y')." </b> </td>";
}
else
echo "<td style='text-align:center;vertical-align: middle;'><b> ".int2date_autre_format($week_start,'d/m/Y')." </b> au <b> ".int2date_autre_format($week_end,'d/m/Y')." </b> </td>";
echo "<td style='text-align:center;vertical-align: middle;'><b> ".number_format( $heures_contrat, 2, ',', ' ')."</b> </td>";
echo "<td style='text-align:center;vertical-align: middle;'><b> ".number_format( $heures_contrat_ACH, 2, ',', ' ')."</b> </td>";
if( $from > $week_start OR $to < $week_end ){
if( $from > $week_start )
echo "<td style='text-align:center;vertical-align: middle;'><b><span class='badge ".$badge."'> ".number_format( $presta_Hduree_start, 2, ',', ' ')." </span><br/><span class='badge ".$badge."'> ".number_format( $presta_Hduree - $presta_Hduree_start, 2, ',', ' ')." </span</b></td>";
else
echo "<td style='text-align:center;vertical-align: middle;'><b><span class='badge ".$badge."'> ".number_format( $presta_Hduree - $presta_Hduree_end, 2, ',', ' ')." </span><br/><span class='badge ".$badge."'> ".number_format( $presta_Hduree_end, 2, ',', ' ')." </span</b></td>";
}
else
echo "<td style='text-align:center;vertical-align: middle;'><b><span class='badge ".$badge."'> ".number_format( $presta_Hduree, 2, ',', ' ')." </span></b></td>";
echo "<td>";
while($cl=dbi_fetch_row($q))
{
list($motif)= dbi_fetch_row(dbi_query("SELECT absence_type_description FROM `absence_type` where absence_type_id =".$cl['absence_type_id'])) ;
echo " $motif du <b> ".int2date($cl['salarie_absence_date_debut'])." </b> au <b> ".int2date($cl['salarie_absence_date_fin'])." </b> ( de ".$cl['salarie_absence_heure_debut']." á ".$cl['salarie_absence_heure_fin']." ) <br>";
}
echo "</td>";
echo "<td style='text-align:center;vertical-align: middle;' ><b> ".number_format( $delta, 2, ',', ' ')." </b></td>";
if($presta_Hduree_dim > 0 ) echo "<td style='text-align:center;vertical-align: middle;' ><b> ".number_format( $presta_Hduree_dim, 2, ',', ' ')." </b></td>"; else echo "<td><b> </b></td>";
if($presta_Hduree_fer > 0 ) echo "<td style='text-align:center;vertical-align: middle;' ><b> ".number_format( $presta_Hduree_fer, 2, ',', ' ')." </b></td>"; else echo "<td><b> </b></td>";
echo "</tr>" ;
}
?>
</tbody>
</table>
</div>
<!-- /.table-responsive -->
</div>
<!-- /.card-body -->
<!-- /.card-footer -->
</div>
</div>
<?php
}
}
?>
<!-- /.row -->
</div><!-- /.container-fluid -->
</section>
<!-- /.content -->
</div>
<!-- /.content-wrapper -->
<footer class="main-footer">
<div class="float-right d-none d-sm-block">
<b>Version</b> 3.0.2
</div>
<strong>Copyright © 2014-2019 <a href="http://adminlte.io">AdminLTE.io</a>.</strong> All rights
reserved.
</footer>
<!-- Control Sidebar -->
<aside class="control-sidebar control-sidebar-dark">
<!-- Control sidebar content goes here -->
</aside>
<!-- /.control-sidebar -->
</div>
<!-- ./wrapper -->
<!-- jQuery -->
<script src="../plugins/jquery/jquery.min.js"></script>
<!-- Bootstrap 4 -->
<script src="../plugins/bootstrap/js/bootstrap.bundle.min.js"></script>
<!-- Select2 -->
<script src="../plugins/select2/js/select2.full.min.js"></script>
<!-- Bootstrap4 Duallistbox -->
<script src="../plugins/bootstrap4-duallistbox/jquery.bootstrap-duallistbox.js"></script>
<!-- InputMask -->
<script src="../plugins/moment/moment.min.js"></script>
<script src="../plugins/inputmask/min/jquery.inputmask.bundle.min.js"></script>
<!-- date-range-picker -->
<script src="../plugins/daterangepicker/daterangepicker.js"></script>
<!-- bootstrap color picker -->
<script src="../plugins/bootstrap-colorpicker/js/bootstrap-colorpicker.min.js"></script>
<!-- Tempusdominus Bootstrap 4 -->
<script src="../plugins/tempusdominus-bootstrap-4/js/tempusdominus-bootstrap-4.min.js"></script>
<!-- Bootstrap Switch -->
<script src="../plugins/bootstrap-switch/js/bootstrap-switch.min.js"></script>
<!-- AdminLTE App -->
<script src="../../dist/js/adminlte.min.js"></script>
<!-- AdminLTE for demo purposes -->
<script src="../../dist/js/demo.js"></script>
<!-- Page script -->
<script>
$(function () {
$("#allcheck").click(function(){
$('input:checkbox').not(this).prop('checked', this.checked);
});
var TOTALCA ="<?php echo number_format( $CATTC, 2, ',', ' ').'<sup> € </sup>';?>";
$('#TOTALCA').html(TOTALCA);
var TOTALCAHT ="<?php echo number_format( $CAHT, 2, ',', ' ').'<sup> € </sup>';?>";
$('#TOTALCAHT').html(TOTALCAHT);
//Initialize Select2 Elements
$('.select2').select2()
//Initialize Select2 Elements
$('.select2bs4').select2({
theme: 'bootstrap4'
})
//Datemask dd/mm/yyyy
$('#datemask').inputmask('dd/mm/yyyy', { 'placeholder': 'dd/mm/yyyy' })
//Datemask2 mm/dd/yyyy
$('#datemask2').inputmask('mm/dd/yyyy', { 'placeholder': 'mm/dd/yyyy' })
//Money Euro
$('[data-mask]').inputmask()
//Date range picker
$('#reservation').daterangepicker()
//Date range picker with time picker
$('#reservationtime').daterangepicker({
timePicker: true,
timePickerIncrement: 30,
locale: {
format: 'MM/DD/YYYY hh:mm A'
}
})
//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'), moment().endOf('month')],
'Last Month' : [moment().subtract(1, 'month').startOf('month'), moment().subtract(1, 'month').endOf('month')]
},
startDate: moment().subtract(29, 'days'),
endDate : moment()
},
function (start, end) {
$('#reportrange span').html(start.format('MMMM D, YYYY') + ' - ' + end.format('MMMM D, YYYY'))
}
)
//Timepicker
$('#timepicker').datetimepicker({
format: 'LT'
})
//Bootstrap Duallistbox
$('.duallistbox').bootstrapDualListbox()
//Colorpicker
$('.my-colorpicker1').colorpicker()
//color picker with addon
$('.my-colorpicker2').colorpicker()
$('.my-colorpicker2').on('colorpickerChange', function(event) {
$('.my-colorpicker2 .fa-square').css('color', event.color.toString());
});
$("input[data-bootstrap-switch]").each(function(){
$(this).bootstrapSwitch('state', $(this).prop('checked'));
});
})
</script>
</body>
</html>