コード例 #1
0
ファイル: Ticket.php プロジェクト: elmo911/WolfeSolutions
 /**
  * @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);
 }