GIT.Harvie.CZ
/
mirrors
/
SokoMan.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
vic stitku
[mirrors/SokoMan.git]
/
apis
/
price-list.inc.php
diff --git
a/apis/price-list.inc.php
b/apis/price-list.inc.php
index cc80af20d9fc44597260c9a489a74ef9fa37b896..d25ec4653ba45e95d2cde4c8b2db8758f39b05d8 100644
(file)
--- a/
apis/price-list.inc.php
+++ b/
apis/price-list.inc.php
@@
-1,5
+1,6
@@
<?php
<?php
-$sql = 'SELECT model_name,model_price_out FROM model WHERE model_price_out > 0 AND category_id > 0';
+$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);
$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));
This page took
0.122338 seconds
and
4
git commands to generate.