<?php
include '../../../include/conf.php';
$check_stock = mysqli_query($conn, "select * from tbl_malaysia_update_stock order by created_at desc");
    while($row1 = mysqli_fetch_array($check_stock)) {
	$get_prod = mysqli_query($conn, "SELECT * from shop_product_malayasia where product_id='$row1[product_id]'");
		$get_product = mysqli_fetch_array($get_prod, MYSQLI_ASSOC);

		$data[] = array('s_no' => ++$i,'date'=>date('d-m-Y',strtotime($row1['created_at'])), 'prod_name' => $get_product['name'],'batch_no'=>$row1['batch_no'],  'old_stock' => $row1['old_stock'], 
        'new_stock' => $row1['new_stock'],'mfg_date' => date('M-Y',strtotime('01-'.$row1['mfg_date'])), 'total_stock'=>$row1['current_stock']);
	}
    if(!empty($data))
        {
            echo json_encode(array(
                "aaData"=>$data));
        }
        else
        {
            echo json_encode(array('aaData'=>[]));
        }
?>