public static function getfood($food_id)
{
global $db;
$query = "SELECT * FROM foods WHERE foodID = {$food_id}";
$result = $db->query($query);
$row = $result->fetch();
$category = CategoryRepository::getCategory($row['categoryID']);
$food = new Food($row['calories'], $row['foodTitle'], $row['foodPrice'], $category);
$food->setId($row['foodID']);
return $food;
}
<?php
/*
* Student Info: Name=Tsai-Chang Mai, ID=10010
* Subject: CS526(C)_HW5_Spring_2016
* Author: Arvin-tcm
* Filename: list_foods.php
* Date and Time: Mar 24, 2016 4:29:17 PM
* Project Name: TsaiChangMai_10010_CS526A_HW5
*/
$category_id = 1;
if (isset($_GET['category_id'])) {
$category_id = $_GET['category_id'];
}
$categories = CategoryRepository::getCategories();
$category = CategoryRepository::getCategory($category_id);
$foods = FoodRepository::getFoodsByCategory($category_id);
return 'views/manage_food_list_view.php';
public function testProductCountUpdatesOnProductUpdate()
{
$module_srl = 1001;
$product_repository = new ProductRepository();
$product = new SimpleProduct();
$product->product_srl = 12;
$product->title = "Some product";
$product->member_srl = 4;
$product->module_srl = $module_srl;
$product->product_type = 'simple';
$product->sku = 'some-product';
$product->friendly_url = $product->sku;
$product->price = 100;
$product->categories[] = 1000;
$product->categories[] = 1002;
$product_repository->insertProduct($product);
// Check that count was increased
$category_repository = new CategoryRepository();
$category = $category_repository->getCategory(1000);
$this->assertEquals(1, $category->product_count);
// Check that count was increased
$category = $category_repository->getCategory(1002);
$this->assertEquals(1, $category->product_count);
// Check that count was increased
$category = $category_repository->getCategory(1008);
$this->isNull($category->product_count);
// Delete product
$args = new stdClass();
$args->module_srl = $module_srl;
$products = $product_repository->getAllProducts($args);
$this->assertNotNull($products);
$product = array_shift($products);
$product->categories = array(1002, 1008);
$product_repository->updateProduct($product);
// Check that count was decreased
$category_repository = new CategoryRepository();
$category = $category_repository->getCategory(1000);
$this->assertEquals(0, $category->product_count);
// Check that count was decreased
$category = $category_repository->getCategory(1002);
$this->assertEquals(1, $category->product_count);
// Check that count was increased
$category = $category_repository->getCategory(1008);
$this->assertEquals(1, $category->product_count);
}
