<?php
include '../../include/conf.php';
	$get_prod = "SELECT te.id as id, te.payment_date as payment_date, ts.expense_type as expense_type, te.amount as amount FROM tbl_malaysia_expense_save te INNER JOIN tbl_malaysia_expense_types ts ON te.expense_type_id = ts.id order by te.payment_date desc";
	$get_prod_det = mysqli_query($conn, $get_prod );
while ($get_prod_deta = mysqli_fetch_array($get_prod_det, MYSQLI_ASSOC)){
	$date = date('d-m-Y', strtotime($get_prod_deta['payment_date']));
	
 $data[] = array('id'=>$get_prod_deta['id'], 'date'=>$date, 'paid_for'=>$get_prod_deta['expense_type'],'amount'=>$get_prod_deta['amount']);            
}
                 
    if(!empty($data))
        {
            echo json_encode(array(
                "aaData"=>$data));
        }
        else
        {
            echo json_encode(array('aaData'=>[]));
        }
?>