<?php
include '../../../include/conf.php';
$start_date = date('Y-m-d');
$check_stock = mysqli_query($conn, "SELECT m1.*
FROM tbl_india_update_stock m1 LEFT JOIN tbl_india_update_stock m2
 ON (m1.product_id = m2.product_id AND m1.id < m2.id)
WHERE m2.id IS NULL;");
    while($row1 = mysqli_fetch_array($check_stock)) {
	$get_prod = mysqli_query($conn, "SELECT * from shop_product where product_id='$row1[product_id]'");
		$get_product = mysqli_fetch_array($get_prod, MYSQLI_ASSOC);

        $get_comp = mysqli_query($conn, "select `name` from tbl_company where id='".$get_product['vstatus']."'");
        $set_comp = mysqli_fetch_array($get_comp, MYSQLI_ASSOC);

        $get_stock_sum = mysqli_query($conn, "select (sum(qty)+ sum(free_qty)) as total from stock_log_entry where product_id ='".$row1['product_id']."' and DATE(created_at)='$start_date'");
        $get_stock_total = mysqli_fetch_array($get_stock_sum, MYSQLI_ASSOC);
        if($get_stock_total['total'] == ''){
            $today_sales = 0;
        }else{
        $today_sales = $get_stock_total['total'];	
        }
		$data[] = array('s_no' => ++$i,'date'=>date('d-m-Y',strtotime($row1['stock_date'])), 'prod_name' => $get_product['name'].' '.$get_product['product_url'],'price'=>$get_product['price'],'offer_unit'=>$get_product['offer_unit'],'comp_name'=>$set_comp['name'], 'old_stock' => $row1['old_stock'], 
        'new_stock' => $row1['new_stock'],'today_sales'=>$today_sales,'total_stock'=>$row1['current_stock']);
	}
    if(!empty($data))
        {
            echo json_encode(array(
                "aaData"=>$data));
        }
        else
        {
            echo json_encode(array('aaData'=>[]));
        }
?>