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'=>[])); } ?>