$row = $offer->fetch();
$rowCount = count($row);
if ($rowCount > 0) {
$sellerId = $row['seller_id'];
$carId = $row['car_id'];
$preferredPrice = $row['preferred_price'];
$description = $row['description'];
$status = $row['status'];
$offerDate = $row['offer_date'];
$seller = $sellerCon->getSeller($sellerId);
if ($seller->errorInfo()[2] == null) {
$seller = $seller->fetch();
$sellerCount = count($seller);
if ($sellerCount > 0) {
$personId = $seller['person_id'];
$person = $personCon->getPerson($personId);
if ($person->errorInfo()[2] == null) {
$person = $person->fetch();
$personCount = count($person);
if ($personCount > 0) {
$firstName = $person['first_name'];
$surname = $person['surname'];
$sellerName = $firstName . ' ' . $surname;
$car = $carCon->getCar($carId);
if ($car->errorInfo()[2] == null) {
$car = $car->fetch();
$carCount = count($car);
if ($carCount > 0) {
$carRego = $car['rego_number'];
$medias = $mediaCon->getMediaForOffer($offerId);
if ($medias->errorInfo()[2] == null) {
public function printSellers()
{
$sellers = $this->getSellers();
$personCon = new PersonController();
if ($sellers->errorInfo()[2] == null) {
$rows = $sellers->fetchAll();
$rowCount = count($rows);
if ($rowCount > 0) {
?>
<table class="table table-responsive table-hover">
<tr>
<th>Surname</th><th>First Name</th><th>Email Address</th><th>Actions</th>
</tr>
<?php
foreach ($rows as $row) {
$person = $personCon->getPerson($row['person_id']);
if ($person->errorInfo()[2] == null) {
$personRow = $person->fetch();
$personCount = count($personRow);
if ($personCount > 0) {
?>
<tr>
<td><?php
echo $personRow['surname'];
?>
</td><td><?php
echo $personRow['first_name'];
?>
</td><td><?php
echo $personRow['email_address'];
?>
</td>
<td><a href="./view.php?id=<?php
echo $row['seller_id'];
?>
" class="btn btn-info"><span class="glyphicon glyphicon-briefcase"></span> View</a> <a href="./edit.php?id=<?php
echo $row['seller_id'];
?>
" class="btn btn-primary"><span class="glyphicon glyphicon-edit"></span> Edit</a> <a href="./delete.php?id=<?php
echo $row['seller_id'];
?>
" class="btn btn-danger"><span class="glyphicon glyphicon-trash"></span> Delete</a></td>
</tr>
<?php
}
} else {
?>
<div class="alert alert-danger" role="alert">
<strong>Uh oh!</strong> The database returned the following error:<br/>
<em><?php
echo $person->errorInfo()[2];
?>
</em>
</div>
<?php
}
}
?>
</table>
<?php
} else {
?>
<div class="alert alert-info" role="alert">
<strong>No results.</strong> There are no sellers to display<br/>
Use the form above to add some.
</div>
<?php
}
} else {
?>
<div class="alert alert-danger" role="alert">
<strong>Uh oh!</strong> The database returned the following error:<br/>
<em><?php
echo $sellers->errorInfo()[2];
?>
</em>
</div>
<?php
}
$sellers->closeCursor();
}
public function printSales()
{
$sales = $this->getSales();
$offerCon = new OfferController();
$sellerCon = new SellerController();
$custCon = new CustomerController();
$personCon = new PersonController();
$carCon = new CarController();
if ($sales->errorInfo()[2] == null) {
$rows = $sales->fetchAll();
$rowCount = count($rows);
if ($rowCount > 0) {
?>
<table class="table table-responsive table-hover">
<tr>
<th>Sale Date</th><th>Car Rego</th><th>Seller</th><th>Buyer</th><th>Sold Price</th><th>Actions</th>
</tr>
<?php
foreach ($rows as $row) {
$offer = $offerCon->getOffer($row['offer_id']);
$offerRow = $offer->fetch();
if (count($offerRow) > 0) {
$buyer = $custCon->getCustomer($row['customer_id']);
$buyerRow = $buyer->fetch();
if (count($buyerRow) > 0) {
$person = $personCon->getPerson($buyerRow['person_id']);
$personRow = $person->fetch();
$buyerName = $personRow['first_name'] . ' ' . $personRow['surname'];
$seller = $sellerCon->getSeller($offerRow['seller_id']);
$sellerRow = $seller->fetch();
if (count($sellerRow) > 0) {
$person = $personCon->getPerson($sellerRow['person_id']);
$personRow = $person->fetch();
if (count($personRow) > 0) {
$car = $carCon->getCar($offerRow['car_id']);
$carRow = $car->fetch();
if (count($carRow) > 0) {
?>
<tr>
<td><?php
echo $row['sale_date'];
?>
</td><td><?php
echo $carRow['rego_number'];
?>
</td><td><?php
echo $personRow['first_name'] . ' ' . $personRow['surname'];
?>
</td><td><?php
echo $buyerName;
?>
</td><td>$<?php
echo ucfirst($row['total_price']);
?>
</td><td><a href="./edit.php?id=<?php
echo $row['sale_id'];
?>
" class="btn btn-primary"><span class="glyphicon glyphicon-edit"></span> Edit</a> <a href="./delete.php?id=<?php
echo $row['sale_id'];
?>
" class="btn btn-danger"><span class="glyphicon glyphicon-trash"></span> Delete</a></td>
</tr>
<?php
} else {
?>
<div class="alert alert-danger" role="alert">
<strong>Uh oh!</strong> The database returned the following error:<br/>
<em><?php
echo $carRow->errorInfo()[2];
?>
</em>
</div>
<?php
}
} else {
?>
<div class="alert alert-danger" role="alert">
<strong>Uh oh!</strong> The database returned the following error:<br/>
<em><?php
echo $personRow->errorInfo()[2];
?>
</em>
</div>
<?php
}
} else {
?>
<div class="alert alert-danger" role="alert">
<strong>Uh oh!</strong> The database returned the following error:<br/>
<em><?php
echo $sellerRow->errorInfo()[2];
?>
</em>
</div>
<?php
}
} else {
?>
<div class="alert alert-danger" role="alert">
<strong>Uh oh!</strong> The database returned the following error:<br/>
<em><?php
echo $buyerRow->errorInfo()[2];
?>
</em>
</div>
<?php
}
} else {
?>
<div class="alert alert-danger" role="alert">
<strong>Uh oh!</strong> The database returned the following error:<br/>
<em><?php
echo $offerRow->errorInfo()[2];
?>
</em>
</div>
<?php
}
}
?>
</table>
<?php
} else {
?>
<div class="alert alert-info" role="alert">
<strong>No results.</strong> There are no sales to display<br/>
Use the form above to add some.
</div>
<?php
}
} else {
?>
<div class="alert alert-danger" role="alert">
<strong>Uh oh!</strong> The database returned the following error:<br/>
<em><?php
echo $sales->errorInfo()[2];
?>
</em>
</div>
<?php
}
$sales->closeCursor();
}
$addressCon = new AddressController();
function checkSelected($id1, $id2)
{
if ($id1 == $id2) {
echo 'selected';
}
}
if (isset($_GET['id'])) {
$sellerId = $_GET['id'];
$seller = $sellerCon->getSeller($sellerId);
if ($seller->errorInfo()[2] == null) {
$row = $seller->fetch();
$rowCount = count($row);
if ($rowCount > 0) {
$personId = $row['person_id'];
$person = $personCon->getPerson($personId);
if ($person->errorInfo()[2] == null) {
$personRow = $person->fetch();
$personCount = count($personRow);
if ($personCount > 0) {
$address = $addressCon->getAddress($personId);
if ($address->errorInfo()[2] == null) {
$addressRow = $address->fetch();
$addressCount = count($addressRow);
if ($addressCount > 0) {
$firstName = $personRow['first_name'];
$surname = $personRow['surname'];
$phoneNumber = $personRow['phone_number'];
$mobileNumber = $personRow['mobile_number'];
$emailAddress = $personRow['email_address'];
$mailingList = $personRow['mailing_list'];
$featureCon = new FeatureController();
$foCon = new Feature_OfferController();
$mediaCon = new MediaController();
$carCon = new CarController();
$makeCon = new MakeController();
$modelCon = new ModelController();
$saleCon = new SaleController();
$empCon = new EmployeeController();
$offer = $offerCon->getOffer($_POST['txtOfferId']);
if ($offer->errorInfo()[2] == null) {
$row = $offer->fetch();
$rowCount = count($row);
if ($rowCount > 0) {
$seller = $sellerCon->getSeller($row['seller_id']);
$seller = $seller->fetch();
$person = $personCon->getPerson($seller['person_id']);
$person = $person->fetch();
$car = $carCon->getCar($row['car_id']);
$car = $car->fetch();
$model = $modelCon->getModel($car['model_id']);
$model = $model->fetch();
$modelName = $model['model_name'];
$make = $makeCon->getMake($model['make_id']);
$make = $make->fetch();
$makeName = $make['make_name'];
$fo = $foCon->getFeaturesForOffer($_POST['txtOfferId']);
$features = array();
$featureIds = array();
foreach ($fo as $f) {
$featureIds[] = $f['feature_id'];
}
