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