/**
* This is for joining users table and tickets table so that i can get the users info in ticket details page
* @since 11-2-2016
* @author Saurabh Kumar <*****@*****.**>
*/
public function getAvaiableUsersDetails()
{
try {
$result = Ticket::join('users', function ($join) {
$join->on('tickets.user_id', '=', 'users.id');
})->select()->get();
return $result;
} catch (QueryException $e) {
echo $e;
}
}
public function replyOnTicketsGet($id)
{
// print_r($id);die;
$objTicket = Ticket::getInstance();
$whereForData = array('rawQuery' => 'ticket_id=?', 'bindParams' => [$id]);
$selectedColumns = ['users.*', 'tickets.*', 'ticket_reply.reply_text', 'ticket_reply.created_at', 'ticket_reply.replied_by'];
$ticketDetails = $objTicket->getUserInfoByTicketId($whereForData, $selectedColumns);
// dd($ticketDetails);
// $numItems = count($ticketDetails);
// $i = 0;
// foreach($ticketDetails as $t) {
// if (++$i === $numItems) {
// $username = $t->username;
// $email = $t->email;
// $ticket_id = $t->ticket_id;
// $subject = $t->subject;
// $descriptions = $t->descriptions;
// $text = $t->reply_text;
// }
// }
// print_r($username);
// print_r($email);
// print_r($ticket_id);
// print_r($subject);
// print_r($descriptions);
// print_r($text);
// die;
return view('User::tickets.replyontickets', ['ticketdetails' => $ticketDetails]);
}