<?php   
require_once '../../includes/conn.php';

$sql = "SELECT product.product_image,product.product_id,product.product_name,product.rate,
        product.buy_rate, product.quantity, product.active, product.status,product.id FROM product 
		WHERE product.active = 1 and product.status = 1 order by product.product_id asc ";

$result = $con->query($sql);

$output = array('data' => array());

if($result->num_rows > 0) { 

 // $row = $result->fetch_array();
 $active = ""; 

 while($row = $result->fetch_array()) {
 	$productId = $row[0];
 	// active 
 	if($row[7] == 1) {
 		// activate member
 		$active = "<label class='label label-success'>Available</label>";
 	} else {
 		// deactivate member
 		$active = "<label class='label label-danger'>Not Available</label>";
 	} // /else

 	$button = '<!-- Single button -->
	<div class="btn-group">
	  <button type="button" class="btn btn-default dropdown-toggle" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">
	    Action <span class="caret"></span>
	  </button>
	  <ul class="dropdown-menu">
	    <li><a type="button" data-toggle="modal" id="editProductModalBtn" data-target="#editProductModal" onclick="editProduct('.$productId.')"> <i class="glyphicon glyphicon-edit"></i> Edit </a></li>
	    <li><a type="button" data-toggle="modal" data-target="#removeProductModal" id="removeProductModalBtn" onclick="removeProduct('.$productId.')"> <i class="glyphicon glyphicon-trash"></i> Remove </a></li>       
	  </ul>
	</div>';

	// $brandId = $row[3];
	// $brandSql = "SELECT * FROM brands WHERE brand_id = $brandId";
	// $brandData = $con->query($sql);
	// $brand = "";
	// while($row = $brandData->fetch_assoc()) {
	// 	$brand = $row['brand_name'];
	// }

	//$brand = $row[10];
	//$category = $row[11];

	$imageUrl = substr($row[2], 3);
	$productImage = "<img class='img-round' src='".$imageUrl."' style='height:35px; width:35px;'  />";

 	$output['data'][] = array( 		
 		
 		//$productImage, // image
		
 		$row[1], // product Id
 		
 		$row[2], // product name
 		
 		$row[3], // rate
		
		$row[4], //Buy Rate
 		
 		$row[5], // quantity 		  	
 		// brand
 		//$brand,
 		// category 		
 		//$category,
 		// active
 		//$active,
 		// button
 		$button 		
 		); 	
 } // /while 

}// if num_rows

$con->close();

echo json_encode($output);

?>