Datatable Error

by anothercoderz

HTML

<html>
	<head>
		<title>Liberal Sigorta Portföy</title>
	<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js"></script>
<link rel="stylesheet" type="text/css" href="src/source/tabler.min.css"/>

<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/1.11.5/css/jquery.dataTables.min.css"/>
<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/responsive/2.2.9/css/responsive.dataTables.min.css"/>
<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/buttons/2.2.2/css/buttons.dataTables.min.css"/>
<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/datetime/1.1.2/css/dataTables.dateTime.min.css"/>
<style>
input[type=text] {
    text-transform: uppercase;
}
</style>

</head>

<body>
<div class="page-body">

<div class="container-fluid">         
<h1 align="center">K.G Sigorta Aracılık Hizmetleri Ltd. Şti.</h1>
<h2 align="center">Liberal Portföy Yönetimi</H2>
			<div class="table-responsive">
			<div align="right">
				
     <div class="input">
      <div class="col-md-2">
       <input type="text" placeholder="Tarih yazınız" name="start_date" id="start_date" class="form-control tformat" max="10" onkeypress=" return isNumber(event)"/>
      </div>
      <div class="col-md-2" style="padding-top:2px">
       <input type="text" placeholder="Tarih yazınız" name="end_date" id="end_date" class="form-control tformat" onkeypress=" return isNumber(event)"/>
      </div>
       
     </div>
	 <br />
	 <div id="err" style="padding-top:2px"></div>

    </div>	
			<div align="right">
<input type="button" name="search" id="search" value="Filtrele" class="btn btn-info">
			</div>

     <div class="col-md-6" style="padding-bottom:50;">
      <input style="float:left" type="button" data-bs-toggle="modal" data-bs-target="#addmodal" value="Ekle" class="btn btn-info" />
      <a href="mutabakat.php" style="float:left; margin-left: 10px;" type="button"  value="Mutabakat" class="btn btn-info"...

JavaScript

$.fn.dataTable.ext.search.push(
    function( settings, data, dataIndex ) {
        var min =  $('#start_date').val();
        var max =  $('#end_date').val();
        var date_pursached =  data[12]  || 0; // use data for the date column
 
         if (min == "" && max == "") { return true; }
         if (min == "" && date_pursached <= max) { return true;}
         if(max == "" && date_pursached >= min) {return true;}
         if (date_pursached <= max && date_pursached >= min) { return true; }
         return false;
    }
);


$(document).ready(function(){


$('#addmodal').submit(function(e){
    e.preventDefault()
	//$('#registerm button[type="submit"]').attr('disabled',true).html('Kaydınız yapılıyor..');
    $.ajax({
        url:'inc/acontrol.php',
        data: new FormData(document.getElementById("addform")),
        cache: false,
        contentType: false,
        processData: false,
        method: 'POST',
		error:err=>{
			console.log(err)
		},
		success: function(resp)
		{		
			$('#amsg').html(resp);
			$('#userdata').DataTable().ajax.reload();
		}						
    })
})

$("input[type=text]").keyup(function () {  
$(this).val($(this).val().replace(/i/g,"İ"));
});  


fetch_data('no');
 $('#userdata').on('draw.dt', function(){
  $('#userdata').Tabledit({
   url:'inc/acontrol.php',
   dataType:'json',
   columns:{
    identifier : [0, 'id'],
    editable:[ //[3, 'gender', '{"1":"Male","2":"Female"}']
	[1, 'isim'], 
	[2, 'yetkili'],
	[3, 'pturu', '{"TRAFİK":"TRAFİK","KASKO":"KASKO","DASK":"DASK","KONUT":"KONUT","MAKİNE":"MAKİNE","İŞ YERİ":"İŞ YERİ","İMM":"İMM","TSS":"TSS"}'],
	[4, 'plaka'],
	[5, 'baslama', '{"İLK":"İLK","YENİLEME":"YENİLEME"}'],
	[6, 'sfirma'],
	[7, 'polno'],
	[8, 'nprim'],
	[9, 'bprim'],
	[10, 'ttarihi'],
	[11, 'ptarihi'],
	[12, 'tcno'],
	[13, 'bserino'],
	[14, 'telefon'],
	[15, 'durum', '{"AKTİF":"AKTİF","İPTAL":"İPTAL","BEKLEMEDE":"BEKLEMEDE","BAŞKA YERE":"BAŞKA YERE"}']
	[16, 'durum',...