/**
* Find all {@link FlightBooking}s by search criteria.
* @return array array of {@link FlightBooking}s
*/
public function find($status = null)
{
$result = array();
$sql = 'SELECT b.blog_id, b.date, b.description, b.created_by, r.restaurant_id, r.name_of_restaurant, r.overall_rating, m.username' . ' FROM blog_posts b, blog_restaurant r, blog_member m ' . 'WHERE r.restaurant_id = b.restaurant_id AND m.username = b.created_by AND b.status = "' . $status . '";';
// $sql = 'SELECT b.date, b.description, r.restaurant_id, r.name_of_restaurant, r.overall_rating'
// . ' FROM blog_posts b, blog_restaurant r '
// . 'WHERE r.restaurant_id = b.restaurant_id AND b.status = "' . $status . '";';
foreach ($this->query($sql) as $row) {
$blogPost = new BlogPost();
BlogPostMapper::map($blogPost, $row);
$result[$blogPost->getId()] = $blogPost;
}
return $result;
}
// private $id;
// private $date;
// private $content;
// private $createdBy;
// private $modifiedBy;
// private $description;
// private $nameOfRestaurant;
// private $overallRating;
// private $restaurant_id;
// private $username;
// private $status = self::PENDING;
$blogPostData = array('content' => $_POST['content'], 'date' => $_POST['date'] . ' 00:00:00', 'created_by' => 'char', 'modified_by' => 'char', 'description' => $_POST['content'], 'restaurant_id' => '44', 'status' => 'pending', 'modified_date' => $_POST['date'] . ' 00:00:00');
$blogRestaurantData = array('name_of_restaurant' => $_POST['name_of_restaurant'], 'overall_rating' => $_POST['overall_rating']);
$blogChipData = array('chip_colour' => $_POST['chip_colour'], 'chip_crunch' => $_POST['chip_crunch'], 'chip_condiments' => $_POST['chip_condiments'], 'chip_consistency' => $_POST['chip_consistency'], 'chip_cash' => $_POST['chip_cash'], 'chip_charisma' => $_POST['chip_charisma']);
// map
BlogPostMapper::simpleMap($blogPost, $blogPostData);
BlogRestaurantMapper::map($blogRestaurant, $blogRestaurantData);
BlogChipMapper::map($blogChip, $blogChipData);
// validate
$errors = BlogPostValidator::validate($blogPost);
$errors = BlogRestaurantValidator::validate($blogRestaurant);
if (empty($errors)) {
// save
$blogPostDao = new BlogPostDao();
$blogRestaurantDao = new BlogRestaurantDao();
$blogChipDao = new BlogChipDao();
$blogPost = $blogPostDao->save($blogPost);
$blogRestaurant = $blogRestaurantDao->save($blogRestaurant);
$blogChip = $blogChipDao->save($blogChip);
Flash::addFlash('Thanks for the review Chipper!');
// redirect
/**
* Find all {@link FlightBooking}s by search criteria.
* @return array array of {@link FlightBooking}s
*/
public function find($status = null)
{
$result = array();
$sql = 'SELECT blog_id, date FROM blog_posts WHERE ' . 'status = "' . $status . '";';
foreach ($this->query($sql) as $row) {
$blogPost = new SimpleBlogPost();
BlogPostMapper::map($blogPost, $row);
$result[$blogPost->getId()] = $blogPost;
}
return $result;
}
