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;
}
}
