<?php
include '../../include/conf.php';
	$get_prod = "select * from tbl_malaysia_damaged_expired tc inner join shop_product_malayasia ts on tc.product_id = ts.product_id order by tc.id 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['filed_date']));
	
 $data[] = array('id'=>$get_prod_deta['id'], 'date'=>$date, 'product_name'=>$get_prod_deta['name'], 'qty'=>$get_prod_deta['qty'], 'reason'=>$get_prod_deta['reason']);            
}
                 
    if(!empty($data))
        {
            echo json_encode(array(
                "aaData"=>$data));
        }
        else
        {
            echo json_encode(array('aaData'=>[]));
        }
?>