Search found 9 matches

Page 1 of 1

Search found 9 matches

help shortcodes $output

Good afternoon... Guys I'm making a gallery output module via short codes getting data division everything goes out but I can't return data received via shortcodes Product.php protected function _load_module($_a , $_b , $_c , &$description) { $gallery_id = $_b; $group_id = $_c; try { $output = $this...

Jump to post
  • Wed Jun 24, 2020 12:26 am
  • Replies 1
  • Views 128
Re: Help - Sort total review product list

welcome. Best way is to always test your sql directly on the database with an sql tool so you can be certain it returns what you expect before putting it in php format and testing it in your OC application. Then if it doesn't work there, you know it cannot be the sql. And I wanted to find out how y...

Jump to post
  • Wed Mar 18, 2020 2:14 pm
  • Replies 9
  • Views 290
Re: Help - Sort total review product list

$sql = "SELECT *, (SELECT count(product_id) FROM " . DB_PREFIX . "review r where r.product_id = p.product_id AND r.status = '1' GROUP BY r.product_id) as reviews FROM " . DB_PREFIX . "product p LEFT JOIN " . DB_PREFIX . "product_description pd ON (p.product_id = pd.product_id) WHERE pd.language_id ...

Jump to post
  • Wed Mar 18, 2020 12:29 pm
  • Replies 9
  • Views 290
Re: Help - Sort total review product list

try something like this: SELECT *, (select count(product_id) from oc_review r where r.product_id = p.product_id AND r.status = '1' GROUP BY r.product_id) as reviews FROM oc_product p JOIN oc_product_description pd ON (p.product_id = pd.product_id) WHERE pd.language_id = 1 ORDER BY reviews ASC I've ...

Jump to post
  • Wed Mar 18, 2020 11:39 am
  • Replies 9
  • Views 290
Re: Help - Sort total review product list

because your query makes no sense. ASC puts products with a review last, DESC puts the first as the r.product_id will be NULL for all products not having a review record. There is nothing in there which counts the number of reviews per product id anyway. Please tell me how to make the necessary req...

Jump to post
  • Wed Mar 18, 2020 11:19 am
  • Replies 9
  • Views 290
Help - Sort total review product list

Need help sorting the product by number of reviews I concluded sorting but why does it not sort by the number of reviews Tell me what my problem is https://clip2net.com/clip/m305708/b9c27-clip-42kb.png Here is the code added to the product model https://clip2net.com/clip/m305708/133de-clip-83kb.png ...

Jump to post
  • Wed Mar 18, 2020 9:50 am
  • Replies 9
  • Views 290
Re: Доработка интернет-магазина (большой проект)

alekseyshipov wrote:
Wed Mar 11, 2020 6:59 pm
Добрый день,
Для доработки интернет-магазина нужен разработчик на опенкарт (версия 3).
Готовые модули не все подходят.
ТЗ предоставлю.
Пришлите тз
либо прикрепите его сюда

Jump to post
  • Thu Mar 12, 2020 10:09 am
  • Replies 3
  • Views 786
Re: WebP support

I have a question: I see this xml file uploaded by @anas_dawood works pretty well (Thanks) when uploading the files manually using the UI of OpenCart. But when using an automated tool to import the catalog with images via URL or anything else it won't work, have someone already have a solution to i...

Jump to post
  • Thu Mar 12, 2020 10:07 am
  • Replies 8
  • Views 7611

Page 1 of 1

Search found 9 matches