<?php require_once 'model/session.php'; require_once 'model/restaurant.php'; require_once 'model/order.php'; $session = new Session(); $order = new Order(); $restaurant = new Restaurant(); $user_id = $session->get_session_data('id'); $restaurants = $restaurant->multipleFind('owner_id', $user_id); $size = sizeof($restaurants); $restaurant_ids = []; $count = 1; $arr = "("; foreach ($restaurants as $key => $value) { if ($count == $size) { $arr .= $value['id']; } else { $arr .= $value['id'] . ","; } $count += 1; } $result = $order->execSQL('SELECT *,`order`.`id` as `orderId`,`order`.`status` as `orderStatus` FROM `order` INNER JOIN `users` ON `users`.`id` = `order`.`user_id` INNER JOIN `restaurant` ON `restaurant`.`id` = `order`.`restaurant_id` INNER JOIN `credit_cards` ON `credit_cards`.`id` = `order`.`card_id` INNER JOIN `delivery_address` ON `delivery_address`.`id` = `order`.`address_id` WHERE `order`.`restaurant_id` IN ' . $arr . ');'); $data = []; while ($row = mysqli_fetch_object($result)) { array_push($data, (array) $row); } ?> <!DOCTYPE html> <html lang="en">
?> <div class="container" style="margin-top:100px;margin-bottom:50px;min-height: 500px;"> <?php if ($session->session_exist('user_type')) { ?> <?php if ($session->get_session_data('user_type') == 'restaurant_owner') { ?> <h1>Your Restaurants</h1> <a href="new_restaurant.php" class="btn btn-warning" style="float:right;margin-top:-40px"><i class="fa fa-plus"></i> Add new restaurant</a> <div> <div class="col-sm-8"> <?php $restaurant = new Restaurant(); $data = $restaurant->multipleFind('owner_id', $session->get_session_data('id')); // var_dump($data); foreach ($data as $key => $value) { echo '<div class="row" restaurant-id="' . $value['id'] . '"> <div class="col-sm-2"> <a href="/view-restaurant.php?id=' . $value['id'] . '"><img src=".' . $value['image'] . '" height="90px" width="90px"></a> </div> <div class="col-sm-6"> <a href="/view-restaurant.php?id=' . $value['id'] . '"><h4>' . ($key + 1) . '. ' . $value['name'] . '</h4></a> <h4>' . $value['rating'] . ' star rating ' . $value['review_count'] . ' reviews</h4>'; switch ((int) $value['status']) { case 1: echo '<span class="label label-success">Approved</span>'; break; case 2: echo '<span class="label label-warning">Blocked</span>';