public function index()
{
$param['ticketTypes'] = TicketTypeModel::where('company_id', Session::get('company_id'))->paginate(10);
$param['pageNo'] = 6;
if ($alert = Session::get('alert')) {
$param['alert'] = $alert;
}
return View::make('company.ticket-type.index')->with($param);
}
public function index()
{
$param['pageNo'] = 1;
$agent = AgentModel::find(Session::get('agent_id'));
$param['is_active'] = $agent->is_active;
$param['ticketTypes'] = TicketTypeModel::where('company_id', $agent->store->company->id)->get();
if (Session::has('process_id')) {
$process = ProcessModel::find(Session::get('process_id'));
$param['currentQueueNo'] = $process->queue_no;
$param['lastQueueNo'] = $process->agent->store->status->last_queue_no;
}
// Get Store ID
$storeId = $agent->store_id;
$status = StatusModel::where('store_id', $storeId)->first();
$agents = AgentModel::where('store_id', $storeId)->where('is_active', TRUE);
$param['amountOfQueue'] = $status->last_queue_no - $status->current_queue_no;
$tickets = ProcessModel::where('agent_id', $agent->id)->whereRaw('DATE(created_at) = DATE(NOW())')->where('end_time', '!=', '');
$param['ticketsManaged'] = $tickets->count();
$processTickets = $tickets->get();
$activeTime = 0;
foreach ($processTickets as $item) {
$activeTime += strtotime($item->end_time) - strtotime($item->start_time);
}
$param['activeTime'] = $activeTime;
$param['averageYourTicketTime'] = $tickets->count() == 0 ? 0 : round($activeTime / $tickets->count());
$agentIds = [];
$agentIds[] = 0;
$agents = AgentModel::where('store_id', $storeId)->get();
foreach ($agents as $agent) {
$agentIds[] = $agent->id;
}
$tickets = ProcessModel::whereIn('agent_id', $agentIds)->whereRaw('DATE(created_at) = DATE(NOW())')->where('end_time', '!=', '');
$processTickets = $tickets->get();
$activeTime = 0;
foreach ($processTickets as $item) {
$activeTime += strtotime($item->end_time) - strtotime($item->start_time);
}
$param['averageTicketTime'] = $tickets->count() == 0 ? 0 : round($activeTime / $tickets->count());
$prefix = DB::getTablePrefix();
$sqlType = "SELECT id, name\n FROM " . $prefix . "ticket_type\n WHERE company_id = " . $agent->store->company->id . "\n UNION ALL\n SELECT 0 as id, 'Skip' as name";
$sql = "\n SELECT COUNT(*) AS cnt, IFNULL(ticket_type, 0) AS type\n FROM " . $prefix . "process t1, " . $prefix . "agent t2, " . $prefix . "store t3\n WHERE t1.agent_id = t2.id\n AND t2.store_id = t3.id\n AND t1.end_time != ''\n AND t3.company_id = " . $agent->store->company->id . "\n GROUP BY ticket_type";
$sql = "SELECT t1.name, IFNULL(t2.cnt, 0) AS cnt\n FROM ({$sqlType}) t1\n LEFT JOIN ({$sql}) t2\n ON t1.id = t2.type\n ORDER BY IFNULL(t2.cnt, 0) DESC";
$param['mostTickets'] = DB::select($sql);
return View::make('agent.process.index')->with($param);
}
public function getTickets($curr_event)
{
$curr_year = (int) date('Y', strtotime('now'));
$curr_week = (int) date('W', strtotime('now'));
$event_ticketsystem_startdate = $curr_event->ticketsystem_recording_startdate;
$event_ts_startyear = (int) date('Y', strtotime($event_ticketsystem_startdate));
$event_ts_startweek = (int) date('W', strtotime($event_ticketsystem_startdate));
$ticket_types = TicketType::where('events_id', $curr_event->id)->orderBy('order')->get();
$ticket_aggregate = [];
$yearly_tickettype_aggregate = [];
$global_aggregate = (object) ['num_sold' => 0, 'amt' => 0, 'points' => null, 'cum_points' => null];
$global_aggregate->points = [];
$global_aggregate->cum_points = [];
// yearly aggregates
foreach ($ticket_types as $key => $tt) {
$tmp_yearly_tickettype = (object) ['id' => $tt->id, 'name' => $tt->name, 'num_sold' => 0, 'amt' => 0, 'points' => null, 'sales_points' => null];
$tmp_yearly_tickettype->points = [];
$tmp_yearly_tickettype->sales_points = [];
$yearly_tickettype_aggregate[] = $tmp_yearly_tickettype;
}
// years
for ($y = $event_ts_startyear; $y <= $curr_year; $y++) {
// last week for current year
$last_week_dt = new DateTime('December 28th, ' . $y);
$last_week = $y === $curr_year ? $curr_week : (int) $last_week_dt->format('W');
$start_week = $y === $event_ts_startyear ? $event_ts_startweek : 1;
// weeks
for ($w = $start_week; $w <= $last_week; $w++) {
// tmp storage for all ticket types for a given week
$tmp_ticket_aggregate = (object) ['week_ndx' => $w, 'year' => $y, 'ticket_details' => null, 'weekly_totals' => null];
$tmp_ticket_aggregate->ticket_details = [];
// tmp weekly cumulative counter vars for all ticket types
$weekly_total_sold = 0;
$weekly_total_revenue = 0;
// for each ticket type
$tmp_global_point = 0;
foreach ($ticket_types as $key => $ticket_type) {
$curr_tickets_sold = TicketSold::where('event_ticket_types_id', $ticket_type->id)->where('week', $w)->where('year', $y)->first();
// find the yearly ticket_type ndx
$yearly_tt_ndx = -1;
foreach ($yearly_tickettype_aggregate as $key => $yearly_tickettype_value) {
if ($yearly_tickettype_value->id === $ticket_type->id) {
$yearly_tt_ndx = $key;
break;
}
}
if ($curr_tickets_sold) {
eerror_log('Event ' . $curr_event->id . ' has ticketssold for ' . $w . '-' . $y . ' ' . json_encode($curr_tickets_sold));
// update weekly accumulators
$curr_ticket_price = (double) $ticket_type->price;
$weekly_total_sold += (int) $curr_tickets_sold->num_sold;
$weekly_total_revenue += (int) $curr_tickets_sold->num_sold * $curr_ticket_price;
// update yearly accumulators
if ($yearly_tt_ndx !== -1) {
$revenue = (double) $curr_tickets_sold->num_sold * $curr_ticket_price;
$yearly_tickettype_aggregate[$yearly_tt_ndx]->num_sold += (int) $curr_tickets_sold->num_sold;
$yearly_tickettype_aggregate[$yearly_tt_ndx]->amt += $revenue;
$yearly_tickettype_aggregate[$yearly_tt_ndx]->points[] = (int) $curr_tickets_sold->num_sold;
$yearly_tickettype_aggregate[$yearly_tt_ndx]->sales_points[] = $revenue;
$tmp_global_point += $revenue;
}
} else {
if ($yearly_tt_ndx !== -1) {
// set to 0 if no tt sale exists
$yearly_tickettype_aggregate[$yearly_tt_ndx]->points[] = 0;
$yearly_tickettype_aggregate[$yearly_tt_ndx]->sales_points[] = 0;
}
}
// save resuts for current ticket type
$tmp_ticket_aggregate->ticket_details[] = ['ticket_type' => $ticket_type, 'tickets_sold' => $curr_tickets_sold, 'input_visible' => !$curr_tickets_sold ? true : false];
}
// save weekly accumulators
$tmp_ticket_aggregate->weekly_totals = ['num_sold' => $weekly_total_sold, 'amt' => $weekly_total_revenue];
$ticket_aggregate[] = $tmp_ticket_aggregate;
$global_aggregate->points[] = $tmp_global_point;
$num_points = count($global_aggregate->points);
if ($num_points === 0) {
$global_aggregate->cum_points[] = $tmp_global_point;
} else {
if ($num_points > 0) {
$prev_val = end($global_aggregate->cum_points);
$global_aggregate->cum_points[] = $prev_val + $tmp_global_point;
}
}
}
}
return [$ticket_types, $ticket_aggregate, $yearly_tickettype_aggregate, $global_aggregate];
}
