/** * @param $ticket Ticket * @return Ledger */ public static function addTicket($ticket) { include_once $_SERVER['DOCUMENT_ROOT'] . "/bossflex/DB/Conn.php"; $db = Conn::get(); $sql = "INSERT INTO Ledger (AccountNum, TicketNum, Amount, Detail) VALUES (?, ?, ?, ?)"; $stmt = $db->prepare($sql); $stmt->execute(array($ticket->getAccountNum(), $ticket->getTicketNum(), $ticket->getAmount(), $ticket->getDescription())); $depID = $db->lastInsertId(); $sql = "SELECT * FROM Ledger WHERE TransID = :id"; $stmt = Conn::get()->prepare($sql); $stmt->bindParam(":id", $depID, PDO::PARAM_INT); $stmt->execute(); $trans = $stmt->fetchObject(__CLASS__); Ledger::recordTransaction($trans); return $trans; }