public function upload()
{
$uploader_id = Auth::user()->active_contact->id;
if (Input::file('file')->isValid()) {
if (Input::get('target') == "posts") {
if (Input::get('target_action') == "create") {
$target = Post::where('author_id', $uploader_id)->where("status_id", "=", POST_DRAFT_STATUS_ID)->where("ticket_id", Input::get('target_id'))->first();
} elseif (Input::get('target_action') == "edit") {
$target = Post::where("id", Input::get('target_id'))->first();
}
} elseif (Input::get('target') == "tickets") {
if (Input::get('target_action') == "create") {
$target = Ticket::where('status_id', TICKET_DRAFT_STATUS_ID)->where('creator_id', $uploader_id)->first();
} elseif (Input::get('target_action') == "edit") {
$target = Ticket::where("id", Input::get('target_id'))->first();
}
}
$id = $target->id;
$request['target_id'] = $id;
$request['uploader_id'] = $uploader_id;
$request['file'] = Input::file('file');
$request['target'] = Input::get('target');
$request['target_action'] = Input::get('target_action');
$response = $this->repo->upload($request);
$response = Response::json($response, 200);
return $response;
}
}
protected function getList()
{
$highPriorityTickets = Ticket::where('urgency', '>', 7)->get();
$midPriorityTickets = Ticket::where('urgency', '>', 4)->where('urgency', '<', 8)->get();
$lowPriorityTickets = Ticket::where('urgency', '<', 5)->get();
$ticketCount = ['high' => count($highPriorityTickets), 'mid' => count($midPriorityTickets), 'low' => count($lowPriorityTickets)];
$totalTickets = array_sum($ticketCount);
return View('ticket.list', ['highPriorityTickets' => ['tickets' => $highPriorityTickets, 'percentage' => $ticketCount['high'] > 0 ? $ticketCount['high'] / $totalTickets * 100 . '%' : '0%', 'count' => $ticketCount['high']], 'midPriorityTickets' => ['tickets' => $midPriorityTickets, 'percentage' => $ticketCount['mid'] > 0 ? $ticketCount['mid'] / $totalTickets * 100 . '%' : '0%', 'count' => $ticketCount['mid']], 'lowPriorityTickets' => ['tickets' => $lowPriorityTickets, 'percentage' => $ticketCount['low'] > 0 ? $ticketCount['low'] / $totalTickets * 100 . '%' : '0%', 'count' => $ticketCount['low']], 'totalTicketCount' => $totalTickets]);
}
protected function generalStatus()
{
$amounts = array();
$amounts['new'] = Ticket::where('status', Ticket::STATUS_NEW)->count();
$amounts['inProgress'] = Ticket::where('status', Ticket::STATUS_IN_PROGRESS)->count();
$amounts['closed'] = Ticket::where('status', Ticket::STATUS_CLOSED)->count();
$amounts['overdue'] = Ticket::where('status', '!=', Ticket::STATUS_CLOSED)->where('due_date', '<', date('Y-m-d'))->count();
return $amounts;
}
public function getReservesByDni(Request $request)
{
$dni = $request['dni'];
if (strlen($dni) != 8 || !is_numeric($dni)) {
return response()->json('El dni debe tener 8 digitos', 400);
}
$reservas = Ticket::where('designee', $dni)->whereNotNull('reserve')->lists('reserve')->unique();
if ($reservas->isEmpty()) {
return response()->json('No hay reservas con este dni', 400);
}
$arreglo = array();
foreach ($reservas as $key => $value) {
$tickets = Ticket::where('reserve', $value)->get();
$arreglo[$key] = ['codigo' => $value, 'nombre' => $tickets->first()->event->name, 'cantidad' => $tickets->first()->quantity, 'zona' => $tickets->first()->zone->name, 'funcion' => date('d-m-Y', $tickets->first()->presentation->starts_at)];
}
return $arreglo;
}
public function giveawayConfirm(request $request)
{
$ticket = Ticket::where('id', $request['sale_id'])->first();
if ($ticket) {
$ticket->picked_up = true;
$ticket->save();
}
return redirect()->route('salesman.home');
}
public function getDraft()
{
$tickets = Ticket::where('tickets.creator_id', Auth::user()->active_contact->id);
$tickets = $tickets->where("tickets.status_id", TICKET_DRAFT_STATUS_ID);
return $tickets->get()->first() ? $tickets->get()->first() : [];
}
/**
* Display the specified resource.
*
* @return \Illuminate\Http\Response
*/
public function showSales()
{
$events = Event::all();
$tickets = Ticket::all();
$eventInformation = [];
foreach ($events as $event) {
// pueden ser muchos eventos. Necesito información para llenar la tabla
$eventsDate = Presentation::where('event_id', '=', $event->id)->where('cancelled', '=', 0)->get();
foreach ($eventsDate as $eventDate) {
$tickets = Ticket::where('presentation_id', '=', $eventDate->id)->get();
$onlineTickets = 0;
$presentialTicket = 0;
$subTotalOnline = 0;
$subTotalPresential = 0;
foreach ($tickets as $ticket) {
if ($ticket->cancelled != 1) {
if (empty($ticket->salesman_id)) {
$onlineTickets = $onlineTickets + $ticket->quantity;
$subTotalPresential = $subTotalPresential + $ticket->total_price;
} else {
$presentialTicket = $presentialTicket + $ticket->quantity;
$subTotalOnline = $subTotalOnline + $ticket->total_price;
}
}
}
array_push($eventInformation, array($event->name, $eventDate->id, date("d/m/Y", $eventDate->starts_at), $onlineTickets, $subTotalPresential, $presentialTicket, $subTotalOnline, $subTotalPresential + $subTotalOnline));
}
}
//
//return $eventInformation;
return view('internal.admin.reports.sales', compact('eventInformation'));
}
