public function addReview($data)
{
$this->user_id = $data['user_id'];
$this->restaurant_id = $data['restaurant_id'];
$this->content = $data['content'];
$this->rating = $data['rating'];
$this->created_at = $data['created_at'] = date('Y-m-d H:i:s');
$this->updated_at = $data['updated_at'] = date('Y-m-d H:i:s');
if ($this->create($data)) {
$restaurants = new Restaurant();
$restaurant = $restaurants->find('id', $this->restaurant_id);
$review_count = intval($restaurant['review_count']);
$rating = $review_count * intval($restaurant['rating']) + intval($this->rating);
$review_count += 1;
$rating /= $review_count;
$restaurants->update('id', $this->restaurant_id, ['rating' => $rating, 'review_count' => $review_count]);
$result['status'] = "success";
$result['success_text'] = "review added";
} else {
$result['status'] = "error";
$result['error_text'] = "review not added";
}
return json_encode($result);
}
function test_update()
{
$name = "Asian";
$id = null;
$test_cuisine = new Cuisine($name, $id);
$test_cuisine->save();
$restaurant_name = "The Golden Duck";
$location = "898 SW 5th Ave, Portland, OR";
$description = "A Chill Asian experince";
$price = "\$\$";
$cuisine_id = $test_cuisine->getId();
$test_restaurant = new Restaurant($restaurant_name, $location, $description, $price, $cuisine_id);
$test_restaurant->save();
$restaurant_name2 = "The Red Dragon";
$location2 = "899 SW 5th Ave, Portland, OR";
$description2 = "A Intense Asian experince";
$price2 = "\$\$\$";
$cuisine_id2 = $test_cuisine->getId();
$test_restaurant->update($restaurant_name2, $location2, $description2, $price2, $cuisine_id2);
$result = $test_restaurant->getName();
$this->assertEquals("The Red Dragon", $result);
}
function testUpdate()
{
//Arrange
$flavor = "Pizza";
$id = null;
$test_cuisine = new Cuisine($flavor, $id);
$name = "Pizza Party";
$phone_number = "123-456-7890";
$address = "1234 Pepperoni Lane";
$cuisine_id = $test_cuisine->getId();
$test_restaurant = new Restaurant($name, $phone_number, $address, $id, $cuisine_id);
$test_restaurant->save();
$new_name = "Burger Bash";
//Act
$test_restaurant->update($new_name);
//Assert
$this->assertEquals("Pizza", $test_cuisine->getFlavor());
}
function test_update()
{
//Arrange
$name = "Drinks";
$id = null;
$test_Cuisine = new Cuisine($name, $id);
$test_Cuisine->save();
$restaurant = "Aalto";
$address = "123 Belmont";
$phone = "123-456-7890";
$cuisine_id = $test_Cuisine->getId();
$test_restaurant = new Restaurant($restaurant, $address, $phone, $cuisine_id, $id);
$test_restaurant->save();
$new_restaurant_name = "HobNob";
//Act
$test_restaurant->update($new_restaurant_name);
//Assert
$this->assertEquals("HobNob", $test_restaurant->getName());
}
function testUpdate()
{
//Arrange
$type = "french";
$id = null;
$test_cuisine = new Cuisine($type, $id);
$test_cuisine->save();
$name = "Petit Provence";
$phone = "555-555-5555";
$price = "\$\$";
$cuisine_id = $test_cuisine->getId();
// $id = null;
$test_restaurant = new Restaurant($name, $phone, $price, $cuisine_id);
$test_restaurant->save();
$new_name = "Escargot";
$new_phone = "666-666-6666";
$new_price = "\$\$\$";
// $cuisine_id = 1;
// $new_id = null;
$new_test_restaurant = new Restaurant($new_name, $new_phone, $new_price, $cuisine_id, $test_restaurant->getId());
// $new_test_restaurant->save();
// var_dump($new_test_restaurant);
//Act
$test_restaurant->update($new_name, $new_phone, $new_price);
//Assert
$this->assertEquals($test_restaurant, $new_test_restaurant);
}
<?php
require_once 'model/session.php';
require_once 'model/order.php';
require_once 'model/restaurant.php';
$session = new Session();
$order = new Order();
$restaurant = new Restaurant();
if ($session->get_session_data('user_type') == 'admin') {
$restaurant->update('id', $_GET['id'], ['status' => 1]);
header('Location: admin-dashboard.php');
} else {
print_r("Something went wrong");
}
function test_update()
{
$name = "Chinese";
$id = null;
$test_cuisine = new Cuisine($name, $id);
$test_cuisine->save();
$place_name = "Happy House";
$address = "4234 N Interstate Ave, Portland OR 97217";
$phone = "503-287-9740";
$cuisine_id = $test_cuisine->getId();
$test_restaurant = new Restaurant($place_name, $id, $address, $phone, $cuisine_id);
$test_restaurant->save();
$new_place_name = "Very Happy House";
$new_address = "5000 N Interstate Ave, Portland OR 97217";
$new_phone = "503-287-9000";
$test_restaurant->update($new_place_name, $new_address, $new_phone);
$this->assertEquals("Very Happy House", $test_restaurant->getPlaceName());
$this->assertEquals("5000 N Interstate Ave, Portland OR 97217", $test_restaurant->getAddress());
$this->assertEquals("503-287-9000", $test_restaurant->getPhone());
}
function test_Update()
{
//Arrange
$name = "American";
$id = null;
$test_cuisine = new Cuisine($name, $id);
$test_cuisine->save();
$restaurant_name = "VQ";
$phone = '5032277342';
$address = "1220 SW 1st Ave, Portland, OR 97204";
$website = "http://www.veritablequandary.com/";
$cuisine_id = $test_cuisine->getId();
$test_restaurant = new Restaurant($restaurant_name, $phone, $address, $website, $cuisine_id);
$test_restaurant->save();
$column_to_update = "restaurant_name";
$new_information = "Veritable Quandary";
//Act
$test_restaurant->update($column_to_update, $new_information);
//Assert
$result = Restaurant::getAll();
$this->assertEquals("Veritable Quandary", $result[0]->getRestaurantName());
}
function testUpdate()
{
//Arrange
$restaurant_name = "Joes Burgers";
$id = null;
$test_restaurant = new Restaurant($restaurant_name, $id);
$test_restaurant->save();
$new_restaurant_name = "McDonalds";
//Act
$test_restaurant->update($new_restaurant_name);
//Assert
$this->assertEquals($new_restaurant_name, $test_restaurant->getRestaurantName());
}
function test_update()
{
//Arrange
$cuisine_type = "Italian";
$id = null;
$test_cuisine = new Cuisine($cuisine_type, $id);
$test_cuisine->save();
$name = "Taco Restaurant";
$phone = "(503) 777-9097";
$address = "7000 Beaverton Hillsdale HWY, Portland, OR 97221";
$hours = "7am - 2am";
$cuisine_id = $test_cuisine->getId();
$test_restaurant = new Restaurant($id, $name, $phone, $address, $hours, $cuisine_id);
$test_restaurant->save();
$new_name = "Taco Bell";
// $new_phone = "(402) 231-0911";
// $new_address = "902 Beaverton Hillsdale Hwy, Portland, OR 97211";
// $new_hours = "8am - 10pm";
//Act
$test_restaurant->update($new_name);
//Assert
$this->assertEquals("Taco Bell", $test_restaurant->getName());
}
