public function getProductByID($id) { $db = $this->db; $product = new Product(); $product->queryProduct($db, $id); return $product; }
function getListOfProducts($db) { $result = array(); $query = "SELECT `itemID` FROM `exes_check_item` WHERE `checkID` = {$this->id}"; if (!($stmt = $db->query($query))) { echo '<h2>Ошибка поддключения к базе данных при запросе элемента чека!</h2>'; die; } else { while ($row = $stmt->fetch_assoc()) { array_push($result, $row['itemID']); } } $repeats = array_count_values($result); $result = array_unique($result); foreach ($result as $productID) { $item = new Product(); $item->queryProduct($db, $productID); $occurences = $repeats[$productID]; array_push($this->listOfProducts, array("occurences" => $occurences, "item" => $item)); } }
public function queryRecepie($db) { $query = "SELECT `ingridientID`, `amount` FROM `sales_menu_recepie` WHERE `menuID` = {$this->ID}"; if (!($stmt = $db->query($query))) { echo "<h2>Ошибка при попытке запроса рецепта</h2>"; return false; } else { while ($row = $stmt->fetch_assoc()) { $product = new Product(); $product->queryProduct($db, $row['ingridientID']); $product->Amount = $row['amount']; array_push($this->Recepie, $product); } return true; } }