modify("-1 days")->format('Y-m-d');
$arr = array();
$arr_1 = array();
$arr_2 = array();
$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) INNER JOIN shop_product sp ON sp.product_id = m1.product_id
WHERE m2.id IS NULL AND sp.can_add_stock = 'yes';");
while($row1 = mysqli_fetch_array($check_stock, MYSQLI_ASSOC)) {
$opening_balance='';
$sale_qty = 0;
$get_refund_count = 0;
$balance = 0;
$pending = 0;
$packing = 0;
$new = 0;
$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_prod = mysqli_query($conn, "SELECT * from shop_product where product_id='$row1[product_id]'");
$get_product = mysqli_fetch_array($get_prod, MYSQLI_ASSOC);
$get_packing = mysqli_query($conn, "SELECT sum(tb.qty + tb.freeqty) AS fqty FROM tbl_confirmorder tc INNER JOIN tbl_order tb ON tc.orderid = tb.orderid WHERE tc.orderstatus = 5 AND tc.varstatus!='Cash' and tc.company_name='Energy Foods' and tc.userid!=7444 and tb.productid='".$row1['product_id']."'");
$pack_rows = mysqli_num_rows($get_packing);
if($pack_rows > 0){
$set_packing = mysqli_fetch_array($get_packing, MYSQLI_ASSOC);
$packing = $set_packing['fqty'];
}else{
$packing = 0;
}
$get_new = mysqli_query($conn, "SELECT sum(tb.qty + tb.freeqty) AS fqty FROM tbl_confirmorder tc INNER JOIN tbl_order tb ON tc.orderid = tb.orderid WHERE tc.orderstatus = 0 AND tc.varstatus!='Cash' and tc.company_name='Energy Foods' and tc.userid!=7444 and tb.productid='".$row1['product_id']."'");
$new_rows = mysqli_num_rows($get_new);
if($new_rows > 0){
$set_new = mysqli_fetch_array($get_new, MYSQLI_ASSOC);
$new = $set_new['fqty'];
}else{
$new = 0;
}
$pending = $packing + $new;
if(!isset($pending)){
$pending = 0;
}
$instock =$row1['current_stock'] + $pending;
$url=''.$get_product['name'].' '.$get_product['product_url'].'';
$data[] = array('s_no' => ++$i,'date'=>date('d-m-Y',strtotime($row1['stock_date'])), 'prod_name' => $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'=>$sale_qty,'opening'=>$opening_balance,'total_stock'=>$row1['current_stock'], 'in_stock'=>$instock, 'btn'=>'', 'btn1'=>'');
}
if(!empty($data))
{
echo json_encode(array(
"aaData"=>$data));
}
else
{
echo json_encode(array('aaData'=>[]));
}
?>