public function updateBid(Bid $bid) { $connection = ConnectionManager::getConnection(); $amount = (double) $bid->amount; $timeOfBid = $bid->timeOfBid->format("Y-m-d H:i:s"); $bidderID = (int) $bid->bidderID; $auctionID = (int) $bid->auctionID; if ($this->isValidBid($bid)) { $auctionManager = new AuctionManager(); $bidder = (int) $auctionManager->getAuctionDetail($auctionID)->highestBidderID; $sql = "\n INSERT INTO bid (amount, time_of_bid, auction_id, bidder_id)\n VALUES ({$amount}, '{$timeOfBid}', {$auctionID}, {$bidderID})"; if ($connection->query($sql) === TRUE) { $email = new EmailManager(); if ($bidder != 0) { $email->highestBidder($bid, $bidder); } $email->watcherEmail($auctionID, $amount); Alerter::showAlert("Your bid was posted successfully"); } else { Alerter::showAlert("Error: " . $sql . " " . $connection->error); } } else { Alerter::showAlert("Your bid needs to be higher than the current highest bid and the starting price!"); } }
public function autoReportEmail(array $auctionIDs, $sellerID) { $auctionManager = new AuctionManager(); $userManager = new UserManager($sellerID); $user = $userManager->getUser($sellerID); $to = $user->email; $subject = "Daily Report"; $message = '<html><body>'; $message .= '<table rules="all" style="border-color: #666;" cellpadding="10">'; $message .= '<p>Hey ' . $user->firstName . ' below is your daily sales report</p>'; foreach ($auctionIDs as $auctionID) { $details = $auctionManager->getAuctionDetail($auctionID); $itemName = $details->itemName; $expirationDate = DateTimeUtils::formatDate($details->endDate); $maxBid = $details->maxBid; $watchers = $details->watchers; $noBidders = $details->numberOfBidders; $bidNo = $details->numberOfBids; $views = $details->views; $message .= "<tr style='background: #eee;'><td><strong>Item Name:</strong> </td><td>" . $itemName . "</td></tr>"; $message .= "<tr><td><strong>Expiration date:</strong> </td><td>" . $expirationDate . "</td></tr>"; $message .= "<tr><td><strong>Highest bid</strong> </td><td>" . $maxBid . "</td></tr>"; $message .= "<tr><td><strong>No of bids:</strong> </td><td>" . $bidNo . "</td></tr>"; $message .= "<tr><td><strong>No of bidders</strong> </td><td>" . $noBidders . "</td></tr>"; $message .= "<tr><td><strong>No of watchers:</strong> </td><td>" . $watchers . "</td></tr>"; $message .= "<tr><td><strong>No of views:</strong> </td><td>" . $views . "</td></tr>"; $message .= "<br>"; } $message .= "<p><br>Best regards,<br>The BidBucket Team</p>"; $this->sendEmail($to, $subject, $message); }