$columnNames = array("businessID", "business_name", "business_address", "business_lat", "business_long", "business_type");
if (!in_array($sortOrder, $columnNames)) {
$sortOrder = 'businessID';
}
} else {
$sortOrder = 'businessID';
}
if (!isset($_GET) || !isset($_GET['id'])) {
die('Invalid request');
}
$dealId = $_GET['id'];
$_SESSION['id'] = $dealId;
$connection = Connection::getInstance();
$gateway = new DealTableGateway($connection);
$businessGateway = new BusinessTableGateway($connection);
$businesses = $businessGateway->getBusinessByUserId($username, $sortOrder);
$statement = $gateway->getDealById($dealId);
if ($statement->rowCount() !== 1) {
die("Illegal request");
}
$row = $statement->fetch(PDO::FETCH_ASSOC);
?>
<!DOCTYPE html>
<html>
<head>
<link href='http://fonts.googleapis.com/css?family=Lato:400,700,900' rel='stylesheet' type='text/css'>
<meta charset="UTF-8">
<script type="text/javascript" src="Javascript/deal.js"></script>
<title>Yoink</title>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
$errorMessage['username'] = '******';
} else {
if ($statement->rowCount() == 1) {
$row = $statement->fetch(PDO::FETCH_ASSOC);
if ($password !== $row['password']) {
$errorMessage['password'] = '******';
}
}
}
} else {
require 'login.php';
}
/*User sent to home page if rowCount shows that they have created at least 1 business*/
/*If user has not created their first business they are sent to welcome page*/
if (empty($errorMessage)) {
$business = $businessGateway->getBusinessByUserId($row['id']);
}
if (empty($errorMessage) && $business->rowCount() > 0) {
$_SESSION['username'] = $username;
$_SESSION['user_id'] = $row['id'];
$_SESSION['numBus'] = $business->rowCount();
header("Location: home.php");
} else {
if (empty($errorMessage) && $business->rowCount() < 1) {
$_SESSION['username'] = $username;
$_SESSION['user_id'] = $row['id'];
header("Location: welcome.php");
} else {
require 'login.php';
}
}
$sortOrder = $_GET['sortOrder'];
$columnNames = array("businessID", "business_name", "business_address", "business_lat", "business_long", "business_type");
if (!in_array($sortOrder, $columnNames)) {
$sortOrder = 'businessID';
}
} else {
$sortOrder = 'businessID';
}
if (isset($_GET) && isset($_GET['filterName'])) {
$filterName = filter_input(INPUT_GET, 'filterName', FILTER_SANITIZE_FULL_SPECIAL_CHARS);
} else {
$filterName = NULL;
}
$connection = Connection::getInstance();
$gateway = new BusinessTableGateway($connection);
$statement = $gateway->getBusinessByUserId($username, $sortOrder);
?>
<!DOCTYPE html>
<html>
<head>
<link href='http://fonts.googleapis.com/css?family=Lato:400,700,900' rel='stylesheet' type='text/css'>
<meta charset="UTF-8">
<script type="text/javascript" src="Javascript/business.js"></script>
<title>Yoink</title>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<!-- Bootstrap -->
<link href="CSS/bootstrap.min.css" rel="stylesheet">
<link href="CSS/custom.css" rel="stylesheet">
<script src="Javascript/respond.js"></script>
</head>
