/** * @param $ticket Ticket * @return array */ public static function closeTicket($ticket, $accept) { include_once $_SERVER['DOCUMENT_ROOT'] . "/bossflex/DB/Conn.php"; include_once $_SERVER['DOCUMENT_ROOT'] . "/bossflex/DB/Models/Ledger.php"; $accept = $accept ? 2 : 3; $sql = "UPDATE Ticket SET\n Status = :stat,\n ClosingComment = :closeComment\n WHERE TicketNum = :ticketNum"; $stmt = Conn::get()->prepare($sql); $stmt->bindParam(":stat", $accept, PDO::PARAM_INT); $stmt->bindParam(":ticketNum", $ticket->getTicketNum(), PDO::PARAM_INT); $stmt->bindParam(":closeComment", $ticket->getClosingComment(), PDO::PARAM_STR); $stmt->execute(); Ledger::addTicket($ticket); }