$city = null; $postcode = null; $state = null; $addressDate = null; $custCon = new CustomerController(); $personCon = new PersonController(); $addressCon = new AddressController(); function checkSelected($id1, $id2) { if ($id1 == $id2) { echo 'selected'; } } if (isset($_GET['id'])) { $custId = $_GET['id']; $buyer = $custCon->getCustomer($custId); if ($buyer->errorInfo()[2] == null) { $row = $buyer->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) {
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(); }