PHP Ticket::where方法代码示例

 public function userticket()
 {
     $userticket = Ticket::where('account_id', '=', $this->account_id)->orderBy('id', 'desc')->get();
     if (count($userticket) != 0) {
         return $userticket;
     }
     return null;
 }

 public function get_tickethash($hash)
 {
     $ticket = Ticket::where('hash', '=', $hash)->first();
     if (empty($ticket)) {
         return Redirect::to('/#moduleSupport')->with('topmessage', 'Invalid Ticket Hash. Please enter your ticket ID and email below to locate the ticket.');
     }
     $email = $ticket->email;
     $ticketid = $ticket->id;
     return Redirect::to('/#moduleSupport')->with(array('ticketemail' => $email, 'ticketid' => $ticketid));
 }

 public function index()
 {
     if (Auth::user()->role === 'admin') {
         $tickets = Ticket::paginate(2);
         return view('tickets.index')->withTickets($tickets);
     } elseif (Auth::user()->role === 'tech') {
         Session::flash('flash_message', 'your not admin!');
         $tickets = Ticket::where('tech_id', '=', Auth::user()->id)->paginate(2);
         return view('tickets.index')->withTickets($tickets);
     }
 }

 public function home()
 {
     if (Auth::check()) {
         if (Auth::user()->role === 'admin') {
             $tickets = Ticket::count();
             return view('pages.home')->with('tickets', $tickets);
         } elseif (Auth::user()->role === 'tech') {
             $tickets = Ticket::where('tech_id', '=', Auth::user()->id)->count();
             return view('pages.home')->with('tickets', $tickets);
         }
     } else {
         return view('auth.login');
     }
 }

 public function ticket($members)
 {
     $employee = json_decode($members);
     foreach ($employee as $key) {
         $ticket = Ticket::where('assigned_to', $key)->where('ticket_type_id', 28)->where('status_id', 3)->get();
         if (count($ticket)) {
             foreach ($ticket as $key) {
                 $id[] = $key->id;
             }
         } else {
             $id[] = NULL;
         }
     }
     return $id;
 }

 public function get_va()
 {
     //Pull our users VA data
     $record = User::where('cid', '=', Auth::user()->get()->cid)->first();
     //        //Figure out what the last 4 months are and append -1 for the first day of the month
     //        $month = date('Y-m');
     //        $month .= '-1';
     //        $month1before = date('Y-m', strtotime('-1 month'));
     //        $month1before .= '-1';
     //        $month2before = date('Y-m', strtotime('-2 month'));
     //        $month2before .= '-1';
     //        $month3before = date('Y-m', strtotime('-3 month'));
     //        $month3before .= '-1';
     //        //Convert to unix time stamps to compare with the DB
     //        $month = strtotime($month);
     //        $month1before = strtotime($month1before);
     //        $month2before = strtotime($month2before);
     //        $month3before = strtotime($month3before);
     //
     //        //Now let's store our month names in an array
     //        $clicks = array();
     //        $clicks['month_name'] = date("F", $month);
     //        $clicks['month1before_name'] = date("F", $month1before);
     //        $clicks['month2before_name'] = date("F", $month2before);
     //        $clicks['month3before_name'] = date("F", $month3before);
     //
     //
     //        //Count the data in the DB
     //        //Where data is greater than the first of this month and is associated with our logged in user.
     //        $month = Click::where('created_at', '>=', $month)->where('vid', '=', Auth::user()->get()->cid)->count();
     //        //Where data is greater than the first of last month, but less than the first of this month and is associated with our logged in user.
     //        $month1before = Click::where('created_at', '>=', $month1before)->where('created_at', '<', $month)->where('vid', '=', Auth::user()->get()->cid)->count();
     //        //You get the point :)
     //        $month2before = Click::where('created_at', '>=', $month2before)->where('created_at', '<', $month1before)->where('vid', '=', Auth::user()->get()->cid)->count();
     //        $month3before = Click::where('created_at', '>=', $month3before)->where('created_at', '<', $month2before)->where('vid', '=', Auth::user()->get()->cid)->count();
     //        //Add to our clicks array.
     //        $clicks['month'] = $month;
     //        $clicks['month1before'] = $month1before;
     //        $clicks['month2before'] = $month2before;
     //        $clicks['month3before'] = $month3before;
     //Let's just keep it simple for now and get the total number of clicks
     $clicks = Click::where('vid', '=', Auth::user()->get()->cid)->count();
     //Pull our ticket information
     $opentickets = Ticket::where('vid', '=', Auth::user()->get()->cid)->where('status', '=', '1')->orderBy('created_at', 'DESC')->get();
     $openticketscount = count($opentickets);
     $closedtickets = Ticket::where('vid', '=', Auth::user()->get()->cid)->where('status', '=', '0')->orderBy('created_at', 'DESC')->get();
     $closedticketscount = count($closedtickets);
     //Create our array
     $tickets = array();
     $tickets['opentickets'] = $opentickets;
     $tickets['opentickets_count'] = $openticketscount;
     $tickets['closedtickets'] = $closedtickets;
     $tickets['closedtickets_count'] = $closedticketscount;
     //Pull our replies
     $tickets_request = Ticket::where('vid', '=', Auth::user()->get()->cid)->get();
     $tids = array();
     foreach ($tickets_request as $ticket_request) {
         $tid = $ticket_request->id;
         $tids[$tid] = $tid;
     }
     if (!empty($tids)) {
         $replies = TicketReply::whereIn('tid', $tids)->orderBy('created_at', 'ASC')->get();
     } else {
         $replies = '';
     }
     $tickets['replies'] = $replies;
     //Pull our Category data
     $categories = Category::where('hidden', '!=', 1)->get();
     //Check to see if there is a banner if so provide the source for it
     if ($record->banner) {
         $banner = User::getBannerUrl(Auth::user()->get()->cid);
     } else {
         //No banner we will set this as false so the views no not to try and display it.
         $banner = FALSE;
     }
     //Get our news
     $news = News::orderBy("updated_at", "DESC")->get();
     //Create our view with the VA, clicks, categories and tickets data.
     return View::make('va')->with(array('news' => $news, 'record' => $record, 'clicks' => $clicks, 'tickets' => $tickets, 'categories' => $categories, 'banner' => $banner));
 }

					<td>{{{ $seance->count }}}</td>
					<td>{{{ $seance->datetime }}}</td>
                    <td>{{ link_to_route('seances.edit', 'Edit', array($seance->id), array('class' => 'btn btn-info')) }}</td>
                    <td>
                        {{ Form::open(array('method' => 'DELETE', 'route' => array('seances.destroy', $seance->id))) }}
                            {{ Form::submit('Delete', array('class' => 'btn btn-danger')) }}
                        {{ Form::close() }}
                    </td>
		</tr>
	</tbody>
</table>

<h4>Available Tickets</h4>
<?php 
$tickets = $seance->tickets();
$tickets = Ticket::where('seance_id', '=', $seance->id)->get();
?>
@if ($tickets->count())
	<table class="table table-striped table-bordered">
		<thead>
			<tr>
				<th>Price</th>
				<th>Seance</th>
				<th>Row</th>
				<th>Place</th>
				<th>Status</th>
				<th>User</th>
			</tr>
		</thead>

		<tbody>

 public function post_guestreopenticket()
 {
     //Get our data
     $ticketid = Input::get('ticketid');
     $hash = Input::get('hash');
     //Fetch our ticket
     $ticket = Ticket::where('id', '=', $ticketid)->where('hash', '=', $hash)->first();
     if (!empty($ticket)) {
         //Reopen our ticket
         $ticket->status = 1;
         //Update our ticket
         $ticket->save();
         //Hell, let's just pull new replies in case something was updated
         $status = '<span style="margin-right: 10px;" class="badge badge-success">OPEN</span>';
         $response = '<div id="ticketreceived" data-tickethash="' . $ticket->hash . '" data-ticketid="' . $ticket->id . '" class="well"><div style="margin-top: 20px; margin-bottom: 40px;" class="row-fluid"><div style="border-bottom: 1px solid #e5e5e5;" class="span10 offset2"><h4>' . $status . ' ' . $ticket->subject . '</h4></div><div class="span2"><strong>' . $ticket->name . '</strong><br /><small>' . $ticket->created_at . '</small></div><div style="padding-top: 3px; padding-left: 3px; margin-left: 0px; border-left: 1px solid #e5e5e5;" class="span8">' . $ticket->description . '</div></div></div>';
         //Get our replies
         $replies = $ticket->replies()->get();
         foreach ($replies as $reply) {
             //Figure out if this is a staff reply
             if ($reply->staff == 0) {
                 $author = '<strong>' . $ticket->name . '</strong>';
             } else {
                 //Alright. It is a staff reply. Let's fetch the name of the auditor
                 $author = '<span class="label label-important"><i class="fa fa-bookmark fa-fw"></i>' . ConsoleUser::getName($reply->author) . '</span>';
             }
             $response .= '<div style="margin-top: 15px; margin-bottom: 15px;"><hr style="border-bottom: 0;" /></div><div class="well"><div style="margin-top: 20px; margin-bottom: 40px;" class="row-fluid"><div class="span2">' . $author . '<br /><small>' . $reply->created_at . '</small></div><div style="padding-top: 3px; padding-left: 3px; margin-left: 0px; border-left: 1px solid #e5e5e5;" class="span8">' . $reply->content . '</div></div></div>';
         }
         echo $response;
     }
 }

 public function get_index()
 {
     return View::make('page.user.support.index')->with('tickets', Ticket::where('user_id', '=', Auth::user()->id)->order_by('created_at', 'DESC')->get());
 }

 public function getInProgressTicketsByUser()
 {
     return Ticket::where('status_id', '=', '2')->where('owner_id', '=', Sentry::getUser()->id)->get();
 }

 public function get_solved()
 {
     return View::make('page.admin.support.overview')->with('tickets', Ticket::where('solved', '=', 1)->order_by('created_at', 'DESC')->paginate(100));
 }

 public function show($id)
 {
     $users = UserAction::findOrFail($id);
     $tickets_count = Ticket::where('tech_id', '=', $id)->count();
     return View('users.show')->with('users', $users)->with('tickets_count', $tickets_count);
 }

 public function get_helpdesk($filter)
 {
     $filter = strtolower($filter);
     //Make sure our filter is valid
     if ($filter != "open" && $filter != "closed" && $filter != "assigned") {
         //Shit, that's bad. Throw a 404.
         App::abort(404, 'Invalid helpdesk filter');
     }
     //Create our subheader based on the URL parameter and fetch the relevant list of tickets
     switch ($filter) {
         case 'open':
             $subheader = "Open Tickets";
             $tickets = Ticket::where('status', '=', '1')->orderBy('updated_at', 'DESC')->get();
             break;
         case 'closed':
             $subheader = "Closed Tickets";
             $tickets = Ticket::where('status', '=', '0')->orderBy('updated_at', 'DESC')->get();
             break;
         case 'assigned':
             $subheader = "Assigned Tickets";
             $tickets = Ticket::where('assigned', '=', Auth::consoleuser()->get()->cid)->where('status', '=', '1')->orderBy('updated_at', 'DESC')->get();
             break;
     }
     //Get the replies
     $repliescount = array();
     foreach ($tickets as $ticket) {
         $repliescount[$ticket->id] = Ticket::find($ticket->id)->replies()->count();
     }
     return View::make('console.helpdesk')->with(array('subheader' => $subheader, 'tickets' => $tickets, 'repliescount' => $repliescount));
 }

 /**
  * Remove the specified Ticket .
  *
  * @param $ticket
  *
  */
 public function postDelete($ticket)
 {
     //Only admin to delete the ticket
     Ticket::where('id', $ticket->id)->where('user_id', Auth::id())->delete();
     $id = $ticket->id;
     $ticket->delete();
     // Was the comment post deleted?
     $ticket = Ticket::where('user_id', Auth::id())->find($id);
     if (empty($ticket)) {
         // TODO needs to delete all of that user's content
         return Redirect::to('ticket')->with('success', 'Removed Ticket Successfully');
     } else {
         // There was a problem deleting the user
         return Redirect::to('ticket/' . $ticket->id . '/edit')->with('error', 'Error while deleting ticket');
     }
 }