private function handleOfferOperations($request) { include_once __DIR__ . '/../dataController/OfferController.php'; $offerController = new OfferController(); if (isset($request[1])) { $this->setResponseCodesAndData($offerController->getById($request[1]), 1); } else { $this->setResponseCodesAndData($offerController->getAll(), 1); } }
/** * Created by PhpStorm. * User: roessler * Date: 16/09/15 * Time: 1:22 PM */ /** * Backend page for administrators and Staff of Cyril's Classic Employees to edit employees */ require_once dirname(dirname(dirname(dirname(__FILE__)))) . DIRECTORY_SEPARATOR . 'config/config.php'; if (isset($_SESSION['authenticated'])) { if ($_SESSION['authenticated'] == true) { $editResult = null; $sellerCon = new SellerController(); $personCon = new PersonController(); $offerCon = new OfferController(); $featureCon = new FeatureController(); $foCon = new Feature_OfferController(); $mediaCon = new MediaController(); $carCon = new CarController(); $offerId = null; $sellerId = null; $personId = null; $selectedFeatureIds = array(); $media = array(); $carId = null; $sellerName = null; $carRego = null; $preferredPrice = null; $description = null; $status = null;
* Created by PhpStorm. * User: roessler * Date: 16/09/15 * Time: 1:22 PM */ /** * Backend page for administrators and Staff of Cyril's Classic Employees to edit employees */ require_once dirname(dirname(dirname(dirname(__FILE__)))) . DIRECTORY_SEPARATOR . 'config/config.php'; if (isset($_SESSION['authenticated'])) { if ($_SESSION['authenticated'] == true) { $editResult = null; $sellerCon = new SellerController(); $custCon = new CustomerController(); $personCon = new PersonController(); $offerCon = new OfferController(); $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(); $saleId = null; $offerId = null; $buyerId = null; $empId = null; $carId = null; $sellerName = null; $preferredPrice = null;
<?php /** * Created by PhpStorm. * User: roessler * Date: 9/27/15 * Time: 2:01 PM */ require_once dirname(dirname(dirname(dirname(__FILE__)))) . DIRECTORY_SEPARATOR . 'config/config.php'; if (isset($_POST['txtOfferId'])) { $sellerCon = new SellerController(); $custCon = new CustomerController(); $personCon = new PersonController(); $offerCon = new OfferController(); $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();
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(); }
/** * Created by PhpStorm. * User: roessler * Date: 16/09/15 * Time: 1:22 PM */ /** * Backend page for administrators and Staff of Cyril's Classic Employees to delete sellers */ require_once dirname(dirname(dirname(dirname(__FILE__)))) . DIRECTORY_SEPARATOR . 'config/config.php'; if (isset($_SESSION['authenticated'])) { if ($_SESSION['authenticated'] == true) { $deleteResult = null; $sellerCon = new SellerController(); $personCon = new PersonController(); $offerCon = new OfferController(); $featureCon = new FeatureController(); $foCon = new Feature_OfferController(); $mediaCon = new MediaController(); $carCon = new CarController(); $offerId = null; $sellerId = null; $personId = null; $featureIds = array(); $featureNames = array(); $features = array(); $media = array(); $carId = null; $sellerName = null; $carRego = null; $preferredPrice = null;
* Created by PhpStorm. * User: roessler * Date: 16/09/15 * Time: 1:22 PM */ /** * Backend page for administrators and Staff of Cyril's Classic Employees to delete sellers */ require_once dirname(dirname(dirname(dirname(__FILE__)))) . DIRECTORY_SEPARATOR . 'config/config.php'; if (isset($_SESSION['authenticated'])) { if ($_SESSION['authenticated'] == true) { $deleteResult = null; $sellerCon = new SellerController(); $custCon = new CustomerController(); $personCon = new PersonController(); $offerCon = new OfferController(); $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(); $saleId = null; $offerId = null; $buyerId = null; $empId = null; $carId = null; $sellerName = null; $preferredPrice = null;
/** * Created by PhpStorm. * User: roessler * Date: 16/09/15 * Time: 1:22 PM */ /** * Backend page for administrators and Staff of Cyril's Classic Cars to add and view offers */ require_once dirname(dirname(dirname(dirname(__FILE__)))) . DIRECTORY_SEPARATOR . 'config/config.php'; if (isset($_SESSION['authenticated'])) { if ($_SESSION['authenticated'] == true) { $addResult = null; $sellerCon = new SellerController(); $personCon = new PersonController(); $offerCon = new OfferController(); $featureCon = new FeatureController(); $foCon = new Feature_OfferController(); $mediaCon = new MediaController(); $carCon = new CarController(); ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="viewport" content="width=device-width, initial-scale=1"> <!-- The above 3 meta tags *must* come first in the head; any other head content must come *after* these tags --> <meta name="description" content=""> <meta name="author" content=""> <link rel="icon" href="../../favicon.ico">
* Created by PhpStorm. * User: roessler * Date: 16/09/15 * Time: 1:22 PM */ /** * Backend page for administrators and Staff of Cyril's Classic Cars to add and view sales */ require_once dirname(dirname(dirname(dirname(__FILE__)))) . DIRECTORY_SEPARATOR . 'config/config.php'; if (isset($_SESSION['authenticated'])) { if ($_SESSION['authenticated'] == true) { $addResult = null; $sellerCon = new SellerController(); $custCon = new CustomerController(); $personCon = new PersonController(); $offerCon = new OfferController(); $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(); if (isset($_POST['hdnAction'])) { if ($_POST['hdnAction'] == 'insert') { $result = $saleCon->insertSale($_POST['txtOfferId'], $_POST['txtEmpId'], $_POST['txtBuyerId'], $_POST['txtDeductions'], $_POST['txtTotal']); if ($result->errorInfo()[2] == null) { $offer = $offerCon->getOffer($_POST['txtOfferId']); $offer = $offer->fetch(); $result = $offerCon->updateOffer($offer['offer_id'], $offer['seller_id'], $offer['car_id'], $offer['description'], 'sold', $offer['preferred_price']);
/** * Created by PhpStorm. * User: roessler * Date: 16/09/15 * Time: 1:22 PM */ /** * Backend page for administrators and Staff of Cyril's Classic Cars to add and view offers */ require_once dirname(dirname(dirname(dirname(__FILE__)))) . DIRECTORY_SEPARATOR . 'config/config.php'; if (isset($_SESSION['authenticated'])) { if ($_SESSION['authenticated'] == true) { $addResult = null; $sellerCon = new SellerController(); $personCon = new PersonController(); $offerCon = new OfferController(); $featureCon = new FeatureController(); $foCon = new Feature_OfferController(); $mediaCon = new MediaController(); $carCon = new CarController(); if (isset($_POST['hdnAction'])) { if ($_POST['hdnAction'] == 'insert') { $nextOfferId = $offerCon->getNextOfferId(); if (isset($_FILES['media'])) { $validExts = array('jpeg', 'jpg', 'png'); $targetPath = DIR_VIEW . 'images' . DIRECTORY_SEPARATOR . 'car_images' . DIRECTORY_SEPARATOR; if (!empty($_FILES)) { $fileCount = count($_FILES['media']['name']); $media = array(); for ($i = 0; $i < $fileCount; $i++) { if ($_FILES['media']['size'][$i] <= 0) {