Exemple #1
0
 /**
  * @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;
 }