X-Git-Url: https://git.harvie.cz/?a=blobdiff_plain;f=apis%2Fprice-list.inc.php;h=d25ec4653ba45e95d2cde4c8b2db8758f39b05d8;hb=0472e63b0dd8ee45ec2caf85e6512886222a73b2;hp=67e0c4c38e933c7f396eb10c4ce9f7aa6171ef69;hpb=88c38b26e8ac27d3e7de78a0a7bc904994f0bed4;p=mirrors%2FSokoMan.git

diff --git a/apis/price-list.inc.php b/apis/price-list.inc.php
index 67e0c4c..d25ec46 100644
--- a/apis/price-list.inc.php
+++ b/apis/price-list.inc.php
@@ -1,5 +1,6 @@
 <?php
-$sql = 'SELECT model_name,model_price_out FROM model';
+$sql = 'SELECT model_name,model_price_out,producer_name'.
+	' FROM model LEFT JOIN producer USING(producer_id)'.
+	' WHERE model_price_out > 0 AND category_id > 0 AND model_eshop_hide != 1';
 $result = $this->db->safe_query_fetch($sql);
-foreach($result as $item) $items[$item['model_name']]=$item['model_price_out'];
-die(json_encode($items));
+die(json_encode($result));