<?php
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);

session_start();
require 'db.connect.php';
$i=0;
	$get_prod = "SELECT *
FROM shop_product
WHERE 1 = 1
  AND status = '0'
  AND vstatus NOT IN (1, 8)
  AND v_s = '0'
  AND COALESCE(stop_status, '') NOT IN ('1')
  AND COALESCE(live_status, '') NOT IN ('1')
ORDER BY name ASC;";
	$get_prod_det = mysqli_query($conn, $get_prod );
while ($get_prod_deta = mysqli_fetch_array($get_prod_det, MYSQLI_ASSOC)){
    $get_cart = mysqli_query($conn, "select * from tbl_dealer_sales_temp where prod_id='".$get_prod_deta['product_id']."' and dealer_id='".$_SESSION['dealer_id']."'");
    $check_rows = mysqli_num_rows($get_cart);
    if($check_rows > 0){
        $set_cart = mysqli_fetch_array($get_cart, MYSQLI_ASSOC);
        $count = $set_cart['qty'];
    }else{
        $count = 0;
    }
    $get_man = mysqli_query($conn, "SELECT * from tbl_company where id='".$get_prod_deta['vstatus']."'");
    $set_man = mysqli_fetch_array($get_man, MYSQLI_ASSOC);
 $data[] = array('sl_no'=>($i=$i+1), 'prod_id'=>$get_prod_deta['product_id'], 'prod_name'=>$get_prod_deta['name'],'prod_url'=>$get_prod_deta['product_url'],'manufacturer'=>$set_man['name'], 'price'=>$get_prod_deta['price'],'gst_percent'=>$set_man['gst_percent'],'tot_price'=>0,'id'=>$get_prod_deta['product_id'], 'qty'=>$count);            
}
                 
    if(!empty($data))
        {
            echo json_encode(array(
                "aaData"=>$data));
        }
        else
        {
            echo json_encode(array('aaData'=>[]));
        }
?>