public static function query_all_restaurants() { $sql = 'select * from restaurants'; $query_tool = new DataAccessLayer(); $results = $query_tool->query($sql); if ($results->num_rows > 0) { return $results; } else { throw new Exception("No registered restaurant found or database error!"); } }
public static function find_by_restaurant_id($restaurant_id) { if ($restaurant_id) { $sql = 'select * from reservations where restaurant_id = ' . $restaurant_id; $query_tool = new DataAccessLayer(); $results = $query_tool->query($sql); if ($results->num_rows > 0) { return $results; } else { return null; } } }
/** * [newest_restaurants description] * @param [type] $number [description] */ function newest_restaurants($number = null) { if ($number) { $query_tool = new DataAccessLayer(); $sql = 'select restaurant_id, name, cuisine_type, rating from restaurants where approved = 1 order by restaurant_id DESC limit 0, ' . $number; $newest_three_restaurant = $query_tool->query($sql); if ($newest_three_restaurant->num_rows > 0) { while ($row = $newest_three_restaurant->fetch_row()) { render_newest_restaurant($row); } echo '<div class="clearfix"></div>'; } } }
} else { if ($_POST['operation'] == 'make_reservation') { // var_dump($_POST); $time_to_slots_hash = array('05:00PM - 06:00PM' => 'slot_5_6', '06:00PM - 07:00PM' => 'slot_6_7', '07:00PM - 08:00PM' => 'slot_7_8', '08:00PM - 09:00PM' => 'slot_8_9', '09:00PM - 10:00PM' => 'slot_9_10'); $time_to_24_hours = array('05:00PM - 06:00PM' => 17, '06:00PM - 07:00PM' => 18, '07:00PM - 08:00PM' => 19, '08:00PM - 09:00PM' => 20, '09:00PM - 10:00PM' => 21); $user_email = $_POST['user_email']; $user_phone = $_POST['user_phone']; if (isset($_POST['guest_reservation']) && $_POST['guest_reservation'] == 'true') { $fields = array('restaurant_id' => $_POST['restaurant_id'], 'people_size' => $_POST['people_size'], 'date_of_reservation' => $_POST['date'], 'time_of_reservation' => $time_to_24_hours[$_POST['time']], 'effective' => 1, 'guest_info' => $_POST['guest_info']); } else { $fields = array('user_id' => $_POST['user_id'], 'restaurant_id' => $_POST['restaurant_id'], 'people_size' => $_POST['people_size'], 'date_of_reservation' => $_POST['date'], 'time_of_reservation' => $time_to_24_hours[$_POST['time']], 'effective' => 1); } try { $query_tool = new DataAccessLayer(); $sql = 'select ' . $time_to_slots_hash[$_POST['time']] . ', date, restaurant_id from time_slots_capacity where date = "' . $fields['date_of_reservation'] . '" and restaurant_id = "' . $fields['restaurant_id'] . '"'; $results = $query_tool->query($sql); if ($results->num_rows > 0) { $row = $results->fetch_row(); $previous_capacity = $row[0]; if ($previous_capacity >= $fields['people_size']) { $new_reservation = new Reservation(); $new_reservation->create($fields); $next_capacity = $previous_capacity - $fields['people_size']; $sql = 'update time_slots_capacity set ' . $time_to_slots_hash[$_POST['time']] . ' = ' . $next_capacity . ' where date = "' . $fields['date_of_reservation'] . '" and restaurant_id = "' . $fields['restaurant_id'] . '"'; if ($query_tool->query($sql)) { // send email to user to confirm reservation $restaurant = new Restaurant(); $restaurant->find($fields['restaurant_id']); $mail = Mail::getInstance(); $mailto = $_POST['user_email']; $subject = 'FineTable - Restaurant Reservation Confirmation!';
$totalRecsProcessed = 0; $currentRecord = 0; // SHOW ITEM BY DEFAULT on Posterous Website $private_item = 1; echo "Welcome. This process will attempt to move your items from SweetCron to Posterous<br/><br/>"; $db = new DataAccessLayer(DB_URL, DB_USER, DB_PASSWORD, DB_NAME); $db->debug = false; $totalRows = $db->nonQuery("select * FROM items where item_status = 'publish' limit 0,10"); while ($totalRows > 0) { $currentRecord = 0; if ($totalRecsProcessed > 100) { break; } echo "<h1>Processing " . $totalRecordsProcessed . " through " . $totalRecordsProcessed + $batchSize . "</h1>"; $sql = "SELECT f.feed_title, f.feed_url, f.feed_domain, f.feed_icon, f.feed_data, i.* FROM items i " . " inner join feeds f on f.feed_id = i.item_feed_id " . " where i.item_status = 'publish' " . " limit 0," . $batchSize; $items = $db->query($sql); while ($obj = $items->fetch_object()) { $dmp = unserialize($obj->item_data); // load up the serialized item_data echo "<h3>Importing " . $obj->ID . " - " . $obj->item_title . "</h3>"; echo "Original Date: " . $obj->item_date . "<br/>"; echo "Item Title: " . $dmp["title"] . "<br/>"; $itemContent = "From: " . $obj->feed_domain . "<br/>" . $dmp["content"] . "<br/>Permalink: <a href='" . $obj->item_permalink . "'>" . $obj->item_permalink . "</a><br/>"; // Posterous values to go into curl request $values = array('site_id' => IMPORT_SITE_ID, 'title' => $obj->item_title, 'body' => $itemContent, 'date' => date("M d Y H:i:s", $obj->item_date), 'source' => $obj->feed_title, 'sourceLink' => $obj->item_permalink, 'private' => $private_item); // get tags from the database. // i concatenate them here as per API spec $itemTags = ""; $tags = $db->query("SELECT GROUP_CONCAT(DISTINCT name SEPARATOR ',') as tags FROM tags where tag_id in (select tag_id from tag_relationships where item_id = " . $obj->ID . ")"); // there has to be a better way to pull a single item from a result set than doing a loop // TO BE RESOLVED later
public static function get_all_reviews_by_restaurant($restaurant_id) { if ($restaurant_id) { $sql = 'select * from reviews where restaurant_id = ' . $restaurant_id; // echo $sql; $query_tool = new DataAccessLayer(); $results = $query_tool->query($sql); if ($results->num_rows > 0) { return $results; } else { return null; } } }