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_assignments() { //Just declare this here since laravel get's mad if it is empty $othersassignments = ''; //Pull our assignments for the current user $assignments = Assignment::where('auditors', 'like', '%' . Auth::consoleuser()->get()->cid . ',%')->get(); //Create an array of each VA that needs to be auditted $vaslist = array(); foreach ($assignments as $assignment) { $vas = $assignment->vas; $vas = explode(',', $vas); //Remove the last empty value $vascount = count($vas) - 1; unset($vas[$vascount]); //Get our current VAs in progress into an array $vasInProgress = explode(',', $assignment->vas_in_progress); $vasInProgressCount = count($vas) - 1; unset($vasInProgress[$vasInProgressCount]); foreach ($vas as $va) { $result = User::findOrFail($va); $status = 0; if (in_array($va, $vasInProgress)) { $status = 1; } $vaslist[] = array('cid' => $va, 'vaname' => $result->vaname, 'assignmentid' => $assignment->id, 'status' => $status); } } //Is our user an administrator? if (Auth::consoleuser()->get()->access > 0) { //Yes, ok let's query for all of the assignments other than their own $othersassignments = Assignment::where('auditors', 'not like', '%' . Auth::consoleuser()->get()->cid . ',%')->get(); } //Pull a list of all of the categories $categories = Category::all(); //Create an array of categories with the key as the cat id and the value the name $catnames = array(); foreach ($categories as $category) { $catnames[$category->id] = $category->name; } //Pull all assignments $allassignments = Assignment::all(); $categoriesPerAssignment = array(); $auditorsPerAssignment = array(); foreach ($allassignments as $allassignment) { //Create a list of other auditors per assignment $auditors = explode(',', $allassignment->auditors); //Get rid of the last empty value $auditorscount = count($auditors) - 1; unset($auditors[$auditorscount]); $auditorsPerAssignment[$allassignment->id] = ''; foreach ($auditors as $auditor) { $auditorsPerAssignment[$allassignment->id] = $auditorsPerAssignment[$allassignment->id] . '<span class="label label-danger"><i class="fa fa-bookmark fa-fw"></i> ' . ConsoleUser::getName($auditor) . '</span> '; } $categoriesPerAssignment[$allassignment->id] = ''; $cats = $allassignment->categories; $cats = explode(',', $cats); //Remove the last empty value $catscount = count($cats) - 1; unset($cats[$catscount]); foreach ($cats as $cat) { $categoriesPerAssignment[$allassignment->id] = $categoriesPerAssignment[$allassignment->id] . '<span class="label label-default">' . $catnames[$cat] . '</span> '; } } return View::make('console.assignments')->with(array('assignments' => $assignments, 'othersAssignments' => $othersassignments, 'categoriesPerAssignment' => $categoriesPerAssignment, 'auditorsPerAssignment' => $auditorsPerAssignment, 'vasList' => $vaslist)); }