I am using datatables in laravel .I want to search values from column name payee name, payer name, amount,order_id.But i am unable search. Please help how to fix it. Below is my code.
if($column && $condition && $value){
if ($column == 'name'){
$paymentData = $paymentData->whereHas(['getReceiverDetail','getSenderDetail'], function ($query) use ($column, $condition,$value){
$query->where($column, $condition, '%'.$value.'%')
->orWhere($column, $condition, '%'.$value.'%');
});
Jquerycode:
$(document).on('keyup', '#search_field', function () {
var keyword = $(this).val();
console.log(keyword);
data_table('amount','like',keyword);
});
}
}
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…