protected function modify(AnnouncementReservation $announcementReservation) { $q = $this->dao->prepare('UPDATE ' . $this->table() . ' SET DATE = :date, DATE_END = :dateEnd, DATE_OPTION = :option, ANNOUNCEMENT_ID = :announcementId, USER_OWNER_ID = :userOwnerId, USER_SUBSCRIBER_ID = :userSubscriberId, CONTACT_GROUP_ID = :contactGroupId, PRICE = :price, STATE_ID = :stateId, KEY_CHECK = :keyCheck, TRANSACTION_REF = :transactionRef, UPDATED_TIME = FROM_UNIXTIME(:updatedTime), ADMIN_PROCEED = :adminProceed WHERE ID = :id'); $q->bindValue(':date', $announcementReservation->getDate()); $q->bindValue(':dateEnd', $announcementReservation->getDateEnd()); $q->bindValue(':option', $announcementReservation->getDateOption()); $q->bindValue(':announcementId', $announcementReservation->getAnnouncementId(), PDO::PARAM_INT); $q->bindValue(':userOwnerId', $announcementReservation->getUserOwnerId(), PDO::PARAM_INT); $q->bindValue(':userSubscriberId', $announcementReservation->getUserSubscriberId(), PDO::PARAM_INT); $q->bindValue(':contactGroupId', $announcementReservation->getContactGroupId(), PDO::PARAM_INT); $q->bindValue(':price', $announcementReservation->getPrice()); $q->bindValue(':stateId', $announcementReservation->getStateId(), PDO::PARAM_INT); $q->bindValue(':keyCheck', $announcementReservation->getKeyCheck()); $q->bindValue(':transactionRef', $announcementReservation->getTransactionRef()); $q->bindValue(':updatedTime', $announcementReservation->getUpdatedTime()); $q->bindValue(':adminProceed', $announcementReservation->getAdminProceed()); $q->bindValue(':id', $announcementReservation->id(), PDO::PARAM_INT); $q->execute(); }
public function sendAdminReservationSubscriberCanceled(Users $userOwner, Users $userSubscriber, Announcement $announce, AnnouncementReservation $reservation) { $platform_fee_ratio = Tipkin\Config::get('platform-fee-ratio'); $platform_fee_extra = $platform_fee_ratio > 0 ? 'et l\'acompte ne sera pas débité' : ''; $this->to = $this->adminMail; $this->subject = 'Annulation de réservation'; $this->content = ' Bonjour, <br /> Une demande de Tip de <b>' . $announce->getTitle() . '</b> n’a pas été validée.<br /> Elle est donc annulée' . $platform_fee_extra . '. <br /><br /> Référence de transation : <b>' . $reservation->getTransactionRef() . '</b> <br /><br /> A très bientôt sur TIPKIN ! <br /><br /> Je possède. Tu empruntes. Nous partageons ! <br /><br /> Administration TIPKIN. '; $this->send(); }