Hi ! Im trying to make a hook that only lists products in stock in certain category but im sure im missing something. Did any one tried to set up something similar.
Code to my hook:
use WHMCS\Database\Capsule;
add_hook('ShoppingCartProductList', 1, function($vars) {
$categoryId = 15;
$products = Capsule::table('tblproducts')
->where('category', $categoryId)
->get();
$productsInStock = [];
foreach ($products as $product) {
if ($product->stockcontrol && $product->qty > 0) {
$productsInStock[] = $product;
}
}
$vars['productList'] = $productsInStock;
return $vars;
});
