Merhaba,
Listeleme sonucuda belirtilen sutünü toplayıp yazdırmam gerekli ,
Tarih aralığında filitre ile çekme işlemim de mevcut , Fiiltre sonucunda da gelen tablodakini göstermesi gerek .
Yardımlarınızı rica ederim.
Toplam olan sutün toplanacak.
<table border="0" cellspacing="5" cellpadding="5">
<tbody><tr>
<td>Başlangıç Tarihi:</td>
<td><input type="text" id="min" name="min"></td>
</tr>
<tr>
<td>Bitiş Tarihi:</td>
<td><input type="text" id="max" name="max"></td>
</tr>
</tbody></table>
<table id="example" class="display nowrap" style="width:100%">
<thead>
<tr>
<th>id</th>
<th>TC No</th>
<th>Adı Soyadı</th>
<th>Telefon</th>
<th>Giriş Tarihi</th>
<th>Çıkış Tarihi</th>
<th>Toplam</th>
<th>Kapora</th>
<th>Borcu</th>
<th>İşlem</th>
</tr>
</thead>
<tbody>
<?php
$toku = $db->query("SELECT * FROM ".$mliste." ORDER BY id desc", PDO::FETCH_ASSOC);
if ( $toku->rowCount() ){
foreach( $toku as $row ){
?>
<tr id="row_<?=$row['id']?>">
<td><?=$row['id']?></td>
<td><?=$row['tc_no']?></td>
<td><?=$row['title']?></td>
<td><?=$row['telefon']?></td>
<td><?=$row['start_event']?></td>
<td><?=$row['end_event']?></td>
<td><?=$row['total']?></td>
<td><?=$row['kapora']?></td>
<td><label class="btn-danger"><?=$row['borclu']?></label></td>
<td><button data-id="<?=$row['id']?>">Düzenle</button></td>
</tr>
<?php
}
}
?>
</tbody>
</table> <script type="text/javascript">
var minDate, maxDate;
// Custom filtering function which will search data in column four between two values
$.fn.dataTable.ext.search.push(
function( settings, data, dataIndex ) {
var min = minDate.val();
var max = maxDate.val();
var date = new Date( data[4] );
if (
( min === null && max === null ) ||
( min === null && date <= max ) ||
( min <= date && max === null ) ||
( min <= date && date <= max )
) {
return true;
}
return false;
}
);
$(document).ready(function() {
// Create date inputs
minDate = new DateTime($('#min'), {
format: 'YYYY MMMM Do ',
});
maxDate = new DateTime($('#max'), {
format: 'YYYY MMMM Do '
});
// DataTables initialisation
var table = $('#example').DataTable({
"language": {
"url": "//cdn.datatables.net/plug-ins/1.10.25/i18n/Turkish.json"
},
dom: 'Bfrtip',
buttons: [
'excel', 'pdf', 'print'
]
}
);
// Refilter the table
$('#min, #max').on('change', function () {
table.draw();
});
});
</script>