/**
* Display the specified resource.
*
* @param int $id
* @return Response
*/
public function show(Request $request, $id)
{
if ($request->stockCodeFind) {
return redirect('stocks/' . $request->stockCodeFind);
}
if (Stock::where('stock_code', $id)->first()) {
$priceGraphData = Stock::getGraphData($id, 'last_month', 'Price');
$prices = \Lava::DataTable();
$prices->addStringColumn('Date')->addNumberColumn('Price')->addNumberColumn('50 Day Moving Average')->addNumberColumn('200 Day Moving Average')->addRows($priceGraphData);
$stockPriceLava = \Lava::LineChart('StockPrice')->dataTable($prices)->customize(['explorer' => ['actions' => ['dragToZoom', 'rightClickToReset']]])->setOptions(['width' => 620, 'height' => 360, 'title' => 'Price of ' . strtoupper($id)]);
$sector = Stock::where('stock_code', $id)->pluck('sector');
$motRecentSectorHistoricalsDate = SectorHistoricals::getMostRecentSectorHistoricalsDate();
return view('pages.individualstock')->with(['stockPriceLava' => $stockPriceLava, 'stock' => Stock::where('stock_code', $id)->first(), 'relatedStocks' => StockMetrics::getMetricsByStockList(Stock::getRelatedStocks($id), 'omit'), 'metrics' => StockMetrics::where('stock_code', $id)->first(), 'mostRecentStockHistoricals' => Historicals::where('stock_code', $id)->orderBy('date', 'DESC')->limit(1)->first(), 'sectorAverage' => SectorHistoricals::where(['sector' => $sector, 'date' => $motRecentSectorHistoricalsDate])->first()]);
}
return redirect('/');
}
private static function sectorLimitToNumber($sectorLimit)
{
if ($sectorLimit == 'all') {
$mostRecentDate = SectorHistoricals::getMostRecentSectorHistoricalsDate();
return SectorHistoricals::where('date', $mostRecentDate)->where('sector', '!=', 'All')->lists('sector')->count();
} else {
$explodedSectorLimit = explode('_', $sectorLimit);
return end($explodedSectorLimit);
}
}
