public function sectorCapsPieChart($numberOfSectors)
{
$graphData = SectorHistoricals::getAllSectorGraphData($numberOfSectors);
$sectorCaps = \Lava::DataTable();
$sectorCaps->addStringColumn('Sector Name')->addNumberColumn('Percent')->addRows($graphData);
return $sectorCaps->toJson();
}
/**
* Admin dashboard
*
*/
public function getIndex()
{
$results = DB::select('SELECT email FROM users WHERE last_activity > ?', array(time() - 600));
View::share('whosonline', $results);
$stocksTable = Lava::DataTable('Stocks');
$stocksTable->addColumn('number', 'Count', 'count');
$stocksTable->addColumn('number', 'Projected', 'projected');
$stocksTable->addColumn('number', 'Official', 'official');
for ($a = 1; $a < 25; $a++) {
$data[0] = $a;
//Count
$data[1] = rand(800, 1000);
//Projected Data
$data[2] = rand(800, 1000);
//Official Data
$stocksTable->addRow($data);
}
$config = array('title' => 'My Stocks');
Lava::LineChart('Stocks')->setConfig($config);
return View::make('admin/dashboard');
}
public function show($sectorName)
{
$sectorGraphData = SectorHistoricals::getIndividualSectorGraphData($sectorName, 'last_month', 'Market Cap');
$sectorCaps = \Lava::DataTable();
$sectorCaps->addStringColumn('Date')->addNumberColumn('Sector Cap')->addRows($sectorGraphData);
$sectorCapsLava = \Lava::AreaChart('SectorCaps')->dataTable($sectorCaps)->setOptions(['width' => 725, 'height' => 320, 'title' => 'Total Sector Cap (Billions)']);
return view('pages.sectors')->with(['sectorCapsLava' => $sectorCapsLava, 'selectedSector' => $sectorName, 'selectedSectorDayChange' => SectorHistoricals::getSelectedSectorDayChange($sectorName), 'sectors' => SectorHistoricals::getSectorDayChanges("sectorDayGain", 30), 'sectorWeekDay' => SectorHistoricals::getSectorWeekDay(), 'stocksInSector' => StockMetrics::getMetricsByStockList(Stock::where('sector', $sectorName)->lists('stock_code'), 'all')]);
}
/**
* User charts
*
* @return Response
*/
private function userChart()
{
$chart = Lava::DataTable('activeusers');
$chart->addColumn('string', 'Active', 'active');
$chart->addColumn('string', 'Inactive', 'inactive');
$chart->addRow(array('Active', DB::table('users')->where('confirmed', '=', '1')->count()));
$chart->addRow(array('In-active', DB::table('users')->where('confirmed', '!=', '1')->count()));
Lava::PieChart('activeusers')->addOption(array('chartArea' => array('width' => '98%', 'height' => '98%')))->addOption(array('backgroundColor' => 'none'))->addOption(array('is3D' => 'true'))->addOption(array('legend' => 'none'));
}
/**
* Display Lavachart graph for CUCM devices
*
* @return \Illuminate\View\View
*/
public function deviceCounts()
{
$data = executeQuery('SELECT t.name, count(*) AS num FROM device d INNER JOIN typemodel t ON d.tkmodel = t.enum GROUP BY t.name ORDER BY num DESC');
$phoneCounts = \Lava::DataTable();
$phoneCounts->addStringColumn('Phone Model')->addNumberColumn('Count');
foreach ($data as $key => $val) {
$phoneCounts->addRow([$val->name, (int) $val->num]);
}
$piechart = \Lava::DonutChart('Cisco IP Phones')->setOptions(['datatable' => $phoneCounts, 'title' => 'Cluster A IP Phones Stats', 'height' => 1000, 'width' => 2000]);
return view('reports.device.counts', compact('piechart'));
}
public function getStepsTodayChart()
{
$TodaySteps = (new Step())->where('date', Carbon::now()->toDateString())->first();
if ($TodaySteps === null) {
$TodaySteps = new Step();
}
$steps = \Lava::DataTable();
$steps->addStringColumn('Steps')->addNumberColumn('Count')->addRow(['Steps', $TodaySteps->steps])->addRow(['Target', $TodaySteps->stepsLeftToTarget]);
$chart = \Lava::DonutChart('stepToday', $steps, ['title' => 'Steps today', 'legend' => ['position' => 'none'], 'pieSliceTextStyle' => ['color' => 'none'], 'pieHole' => 0.7]);
return $chart;
}
public function getCharts($testResultTotals)
{
$chart = new Helper();
$smoke = \Lava::DataTable();
$integration = \Lava::DataTable();
$regression = \Lava::DataTable();
$smoke->addStringColumn('TestResults')->addNumberColumn('Percent')->addRow(array('Passed', $testResultTotals['Passed']))->addRow(array('Failed', $testResultTotals['Failed']))->addRow(array('Skipped', $testResultTotals['Skipped']));
$integration->addStringColumn('TestResults')->addNumberColumn('Percent')->addRow(array('Passed', 90))->addRow(array('Failed', 5))->addRow(array('Skipped', 5));
$regression->addStringColumn('TestTesults')->addNumberColumn('Percent')->addRow(array('Passed', 82))->addRow(array('Failed', 18))->addRow(array('Skipped', 20));
$chart->getChart('SmokeTestChart', 'PieChart', 250, 250, array('078B3E', 'CD1E35', 'FCDC27'), $smoke);
$chart->getChart('IntegrationTestChart', 'PieChart', 250, 250, array('078B3E', 'CD1E35', 'FCDC27'), $integration);
$chart->getChart('RegressionTestChart', 'PieChart', 250, 250, array('078B3E', 'CD1E35', 'FCDC27'), $regression);
}
public function index()
{
//Line graph for market cap
$totalMarketCapGraphData = SectorHistoricals::getIndividualSectorGraphData('All', 'last_month', 'Market Cap');
$marketCaps = \Lava::DataTable();
$marketCaps->addStringColumn('Date')->addNumberColumn('Market Cap')->addRows($totalMarketCapGraphData);
$marketCapsLava = \Lava::AreaChart('MarketCaps')->dataTable($marketCaps)->setOptions(['width' => 725, 'height' => 360, 'title' => 'ASX Market Cap (Billions)']);
//PieChart for Sectors' Market Caps
$individualSectorCapsGraphData = SectorHistoricals::getAllSectorGraphData('top_5');
$sectorCaps = \Lava::DataTable();
$sectorCaps->addStringColumn('Sector Name')->addNumberColumn('Percent')->addRows($individualSectorCapsGraphData);
$sectorCapsLava = \Lava::PieChart('Sectors')->dataTable($sectorCaps)->customize(['tooltip' => ['text' => 'percentage']])->setOptions(['width' => 725, 'height' => 360, 'title' => 'Sector Caps (Billions)', 'pieSliceText' => 'label']);
return view('pages.home')->with(['marketCapsLava' => $marketCapsLava, 'sectorDayGains' => SectorHistoricals::getSectorDayChanges('sectorDayGain'), 'sectorDayLosses' => SectorHistoricals::getSectorDayChanges('sectorDayLoss'), 'sectorDayGainTitle' => SectorHistoricals::getSectorDayChangeTitle('sectorDayGain'), 'sectorDayLossTitle' => SectorHistoricals::getSectorDayChangeTitle('sectorDayLoss')]);
}
private function reportPidStatusGeral()
{
$sql = 'SELECT COUNT(idPid) AS total FROM pids WHERE (created_at = updated_at) AND (updated_at NOT BETWEEN "' . Carbon::now()->subMonth(12) . '" AND "' . Carbon::now() . '") AND ativo = 1 AND idPid NOT IN (SELECT DISTINCT pid_id FROM pid_revisao)';
$total = DB::select($sql)[0]->total;
$sql2 = 'SELECT COUNT(DISTINCT idPid) AS total FROM pids WHERE (created_at <> updated_at) AND (updated_at BETWEEN "' . Carbon::now()->subMonth(12) . '" AND "' . Carbon::now() . '") AND ativo = 1 AND idPid NOT IN (SELECT DISTINCT pid_id FROM pid_revisao)';
$atualizados = DB::select($sql2)[0]->total;
$revisao = DB::select('SELECT COUNT(DISTINCT pid_id) AS total FROM pid_revisao')[0]->total;
$dados = \Lava::DataTable();
$dados->addStringColumn('Status');
$dados->addNumberColumn('Qtd');
$dados->addRow(['Não Revisados', $total]);
$dados->addRow(['Revisados', $atualizados]);
$dados->addRow(['Em Revisão', $revisao]);
return $dados;
}
/**
* @param string $name
* @param string $title
*/
public function getLineChart($name = '', $title = '')
{
$this->lineChart = \Lava::LineChart($name, $this->lavaDataTable);
/* // Soon tl be released in lavacharts
, ['trendlines' => [
0 => [
'type' => 'line',
'color' => 'red',
'pointsVisible'=>true,
'pointSize' => 1
]
]]
*/
$this->setTitle($title);
}
/**
* 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('/');
}
public static function googleGraph($minigraph_data, $type = 'activity')
{
switch ($type) {
case 'activity':
$stocksTable = Lava::DataTable('Stocks');
$stocksTable->addColumn('string', 'Week', 'count');
$stocksTable->addColumn('number', 'Hits', 'projected');
$stocksTable->addColumn('number', 'Unique', 'projected');
foreach (array_reverse($minigraph_data['activity']['data'], true) as $i => $d) {
$data[0] = $i == 0 ? "This week" : Carbon::now()->subWeeks($i)->diffForHumans();
$data[1] = $d;
$data[2] = $minigraph_data['activity_unique']['data'][$i];
$stocksTable->addRow($data);
}
Lava::LineChart('Stocks')->setConfig();
break;
}
}
/**
* Generates the view with statistics for a chosen timeframe.
* Includes all persons with LDAP-id set AND status "aktiv" and "kandidat"
* OR persons with LDAP-id and other status if they used a schedule in the last 3 month.
*
* @return int $from
* @return int $till
* @return RedirectResponse
*/
public function showStatistics()
{
// Setting timeframe
$from = is_null(Input::get('from')) ? date('Y-m-01') : Input::get('from');
$till = is_null(Input::get('till')) ? date('Y-m-t') : Input::get('till');
// Selecting persons to evaluate
$timeSpan = new DateTime("now");
$timeSpan = $timeSpan->sub(DateInterval::createFromDateString('3 months'));
$persons = Person::whereRaw("prsn_ldap_id IS NOT NULL \n\t\t\t\t\t\t\t\t\t AND (prsn_status IN ('aktiv', 'kandidat') \n\t\t\t\t\t\t\t\t\t OR updated_at>='" . $timeSpan->format('Y-m-d H:i:s') . "')")->orderBy('prsn_name')->get();
foreach ($persons as $person) {
// Define new attribute 'total' for each person object, fill it with the sum received
$person->total = $this->countStatisticsById($person->id, $from, $till);
}
// Generating charts with lavacharts
$graphData = Lava::DataTable();
$graphData->addStringColumn('Name')->addNumberColumn('Dienste');
foreach ($persons as $person) {
$graphData->addRow(array($person->prsn_name . "(" . substr($person->prsn_status, 0, 1) . ")" . "(" . $person->getClub->clb_title . ")", $person->total));
}
$columnchart = Lava::ColumnChart('Dienste')->setOptions(array('datatable' => $graphData));
return View::make('statisticsView', compact('persons', 'from', 'till'));
}
public function viewServerStat($id)
{
$servers = DB::table('servers')->lists('server', 'id');
$server = DB::table('servers')->select('server', 'id')->where('id', $id)->first();
$server_statistics = DB::table('server_statistics')->where('server_id', $id)->get();
$linechart = \Lava::DataTable();
$linechart->addDateColumn('Date')->addNumberColumn('Sample Value');
foreach ($server_statistics as $key => $value) {
# code...
$rowData = array($value->data_label, $value->data_value);
$linechart->addRow($rowData);
}
$lineChart = \Lava::LineChart('server-stat')->setOptions(array('datatable' => $linechart, 'title' => 'Server statistics for ' . ucfirst($server->server)));
//dd($rowData);
$server_statistics_low = DB::table('server_statistics')->select('data_value')->where('server_id', $id)->orderBy('data_value', 'asc')->first();
$server_statistics_high = DB::table('server_statistics')->select('data_value')->where('server_id', $id)->orderBy('data_value', 'desc')->first();
$server_statistics_avg = DB::table('server_statistics')->select('data_value')->where('server_id', $id)->avg('data_value');
if (!Request::ajax()) {
return view('home', array('server_statistics_low' => $server_statistics_low, 'server_statistics_high' => $server_statistics_high, 'server_statistics_avg' => $server_statistics_avg, 'server_statistics' => $server_statistics, 'servers' => $servers, 'server_id' => $id));
} else {
return view('pull-servers-stat-ajax', array('server_statistics_low' => $server_statistics_low, 'server_statistics_high' => $server_statistics_high, 'server_statistics_avg' => $server_statistics_avg, 'server_statistics' => $server_statistics, 'servers' => $servers, 'server_id' => $id));
}
}
$mineralsChart = \Lava::LineChart('Minerals')->dataTable($mineralsG)->title('Percent of Daily Minerals Fulfilled');
for ($a = 4; $a >= 1; $a--) {
$mineralsG->addRow(array($a + 1 . ' days ago', $previousNutrientTotals[301][$a] * 100 / $vals->getRecommendedCalcium(), $previousNutrientTotals[312][$a] * 100 / $vals->getRecommendedCopper(), $previousNutrientTotals[303][$a] * 100 / $vals->getRecommendedIron(), $previousNutrientTotals[304][$a] * 100 / $vals->getRecommendedMagnesium(), $previousNutrientTotals[315][$a] * 100 / $vals->getRecommendedManganese(), $previousNutrientTotals[305][$a] * 100 / $vals->getRecommendedPhosphorus(), $previousNutrientTotals[306][$a] * 100 / $vals->getRecommendedPotassium(), $previousNutrientTotals[307][$a] * 100 / $vals->getRecommendedSodium(), $previousNutrientTotals[309][$a] * 100 / $vals->getRecommendedZinc()));
}
$mineralsG->addRow(array('1 day ago', $previousNutrientTotals[301][0] * 100 / $vals->getRecommendedCalcium(), $previousNutrientTotals[312][0] * 100 / $vals->getRecommendedCopper(), $previousNutrientTotals[303][0] * 100 / $vals->getRecommendedIron(), $previousNutrientTotals[304][0] * 100 / $vals->getRecommendedMagnesium(), $previousNutrientTotals[315][0] * 100 / $vals->getRecommendedManganese(), $previousNutrientTotals[305][0] * 100 / $vals->getRecommendedPhosphorus(), $previousNutrientTotals[306][0] * 100 / $vals->getRecommendedPotassium(), $previousNutrientTotals[307][0] * 100 / $vals->getRecommendedSodium(), $previousNutrientTotals[309][0] * 100 / $vals->getRecommendedZinc()));
$mineralsG->addRow(array('Today', $todayNutrientTotals[301] * 100 / $vals->getRecommendedCalcium(), $todayNutrientTotals[312] * 100 / $vals->getRecommendedCopper(), $todayNutrientTotals[303] * 100 / $vals->getRecommendedIron(), $todayNutrientTotals[304] * 100 / $vals->getRecommendedMagnesium(), $todayNutrientTotals[315] * 100 / $vals->getRecommendedManganese(), $todayNutrientTotals[305] * 100 / $vals->getRecommendedPhosphorus(), $todayNutrientTotals[306] * 100 / $vals->getRecommendedPotassium(), $todayNutrientTotals[307] * 100 / $vals->getRecommendedSodium(), $todayNutrientTotals[309] * 100 / $vals->getRecommendedZinc()));
echo \Lava::render('LineChart', 'Minerals', 'minerals_div');
?>
</div>
<div id="vitamins_div" align="center" style="height:400px; width: 950px; padding-left: 0px">
<?php
$vitaminsChart = \Lava::LineChart('Vitamins')->dataTable($vitaminsG)->title('Percent of Daily Vitamins Fulfilled');
for ($a = 4; $a >= 1; $a--) {
$vitaminsG->addRow(array($a + 1 . ' days ago', $previousNutrientTotals[320][$a] * 100 / $vals->getRecommendedVitaminA(), $previousNutrientTotals[578][$a] * 100 / $vals->getRecommendedVitaminB12(), $previousNutrientTotals[415][$a] * 100 / $vals->getRecommendedVitaminB6(), $previousNutrientTotals[401][$a] * 100 / $vals->getRecommendedVitaminC(), $previousNutrientTotals[328][$a] * 100 / $vals->getRecommendedVitaminD(), $previousNutrientTotals[323][$a] * 100 / $vals->getRecommendedVitaminE(), $previousNutrientTotals[430][$a] * 100 / $vals->getRecommendedVitaminK()));
}
$vitaminsG->addRow(array('1 day ago', $previousNutrientTotals[320][0] * 100 / $vals->getRecommendedVitaminA(), $previousNutrientTotals[578][0] * 100 / $vals->getRecommendedVitaminB12(), $previousNutrientTotals[415][0] * 100 / $vals->getRecommendedVitaminB6(), $previousNutrientTotals[401][0] * 100 / $vals->getRecommendedVitaminC(), $previousNutrientTotals[328][0] * 100 / $vals->getRecommendedVitaminD(), $previousNutrientTotals[323][0] * 100 / $vals->getRecommendedVitaminE(), $previousNutrientTotals[430][0] * 100 / $vals->getRecommendedVitaminK()));
$vitaminsG->addRow(array('Today', $todayNutrientTotals[320] * 100 / $vals->getRecommendedVitaminA(), $todayNutrientTotals[578] * 100 / $vals->getRecommendedVitaminB12(), $todayNutrientTotals[415] * 100 / $vals->getRecommendedVitaminB6(), $todayNutrientTotals[401] * 100 / $vals->getRecommendedVitaminC(), $todayNutrientTotals[328] * 100 / $vals->getRecommendedVitaminD(), $todayNutrientTotals[323] * 100 / $vals->getRecommendedVitaminE(), $todayNutrientTotals[430] * 100 / $vals->getRecommendedVitaminK()));
echo \Lava::render('LineChart', 'Vitamins', 'vitamins_div');
?>
</div>
</div> <!--ends graph tabpanel-->
</div> <!--ends tab-content-->
</div>
<br><br><br>
</body>
@endsection
<?php
$links = Residencias::paginate(15);
$residencias = $links->lists('nombre', 'id');
// dd($residencias);
$stocksTable = Lava::DataTable();
$stocksTable->addStringColumn('Cantidad de Personas')->addNumberColumn('Cantidad', null, '#FFFFFF');
foreach ($residencias as $id => $residencia) {
$rowData = array($residencia, Residencias::find($id)->personas()->count());
$stocksTable->addRow($rowData);
}
$chart = Lava::ColumnChart('CantidadChart')->title('Grafico de Habitat Por Residencia')->colors(array('yellow'));
$chart->datatable($stocksTable);
?>
<div class="col-md-12">
<h3 class="text-success text-center">Cantidad de Usuarios Por Residencia</h3>
{{ Lava:: render('ColumnChart', 'CantidadChart', 'CantidadChart', true);}}
<div class="col-md-9 col-md-offset-3">
{{$links->links();}}
</div>
</div>
public function index()
{
$user = Auth::user();
$foods = $user->getFoodHistory();
$nutrients = Nutrient::orderBy('name', 'ASC')->get();
$data = [];
$dailyCalories = $user->daily_calories;
//for calculating individual food nutrient values scaled by quantity
foreach ($foods as $food) {
$allNutrients1 = $food->nutrients;
$foodid1 = $food->id;
$quantity1 = $food->pivot->quantity;
foreach ($allNutrients1 as $nutrient) {
$data[$foodid1][$nutrient->id] = $nutrient->pivot->amount_in_food * $quantity1 / 100;
}
$otherNutrients = Nutrient::whereNotIn('id', $food->nutrients()->lists('nutrient_id')->toArray())->get();
foreach ($otherNutrients as $nutrient) {
$data[$foodid1][$nutrient->id] = 0;
}
}
//gets user's recommended daily values
$vals = RecommendedValue::GetRecommendedValues($user);
//for calculating daily total
$todayTotalCalories = 0;
$todayData = [];
$todayNutrientTotals = [];
$numDays = 5;
//Index these arrays by $dayNumber - 1 (so that 1 day ago is in index 0), $nutrient->id
$previousTotalCalories = [];
$previousNutrientTotals = [];
foreach ($nutrients as $nutrient) {
$todayNutrientTotals[$nutrient->id] = 0;
$previousNutrientTotals[$nutrient->id] = array_pad([], $numDays, 0);
$previousTotalCalories = array_pad([], $numDays, 0);
}
foreach ($foods as $food) {
$daysSinceEaten = Carbon::Parse($food->pivot->timestamp)->diffInDays();
$actualCalories = $food->pivot->quantity / 100 * $food->getCalories();
$food->actualCalories = $actualCalories;
if ($daysSinceEaten == 0) {
//We ate this today - it goes in a separate thing
$todayTotalCalories += $actualCalories;
$allNutrients = $food->nutrients;
$foodid = $food->id;
$quantity = $food->pivot->quantity;
foreach ($allNutrients as $nutrient) {
$todayData[$foodid][$nutrient->id] = $nutrient->pivot->amount_in_food * $quantity / 100;
if (!array_key_exists($nutrient->id, $todayNutrientTotals)) {
$todayNutrientTotals[$nutrient->id] = $todayData[$foodid][$nutrient->id];
} else {
$todayNutrientTotals[$nutrient->id] = $todayNutrientTotals[$nutrient->id] + $todayData[$foodid][$nutrient->id];
}
}
$otherNutrients = Nutrient::whereNotIn('id', $food->nutrients()->lists('nutrient_id')->toArray())->get();
foreach ($otherNutrients as $nutrient) {
$todayData[$foodid][$nutrient->id] = 0;
}
} else {
if ($daysSinceEaten <= $numDays) {
//We want this many days worth of food data aggregated
$previousTotalCalories[$daysSinceEaten - 1] += $actualCalories;
$allNutrients = $food->nutrients;
$quantity = $food->pivot->quantity;
foreach ($allNutrients as $nutrient) {
$actualNutrientValue = $nutrient->pivot->amount_in_food * $quantity / 100;
$previousNutrientTotals[$nutrient->id][$daysSinceEaten - 1] += $actualNutrientValue;
}
} else {
//Ignore this. Ideally, we would filter the query to only return items that fall in the previous two categories.
}
}
}
//for creating graphs
$caloriesG = \Lava::DataTable();
$caloriesG->addStringColumn('When')->addNumberColumn('Calories');
$sugarFatG = \Lava::DataTable();
$sugarFatG->addStringColumn('When')->addNumberColumn('Sugar (g)')->addNumberColumn('Fat (g)');
$mineralsG = \Lava::DataTable();
$mineralsG->addStringColumn('When')->addNumberColumn('Calcium')->addNumberColumn('Copper')->addNumberColumn('Iron')->addNumberColumn('Magnesium')->addNumberColumn('Manganese')->addNumberColumn('Phosphorus')->addNumberColumn('Potassium')->addNumberColumn('Sodium')->addNumberColumn('Zinc');
$vitaminsG = \Lava::DataTable();
$vitaminsG->addStringColumn('When')->addNumberColumn('Vitamin A')->addNumberColumn('Vitamin B12')->addNumberColumn('Vitamin B6')->addNumberColumn('Vitamin C')->addNumberColumn('Vitamin D')->addNumberColumn('Vitamin E')->addNumberColumn('Vitamin K');
return view('history')->with(compact('foods', 'dates', 'todayTotalCalories', 'data', 'total', 'nutrients', 'allNutrients1', 'allNutrients', 'todayNutrientTotals', 'previousTotalCalories', 'previousNutrientTotals', 'vals', 'dailyCalories', 'caloriesG', 'sugarFatG', 'mineralsG', 'vitaminsG'));
}
?>
@stop
@section('IntegrationTestChart')
<?php
echo \Lava::render('PieChart', 'IntegrationTestChart', 'chart2-div');
?>
@stop
@section('RegressionTestChart')
<?php
echo \Lava::render('PieChart', 'RegressionTestChart', 'chart3-div');
?>
@stop
@section('tableRow')
@if(sizeof($runs) == 0)
<?php
echo 'There are no test runs.';
?>
@else
@foreach($runs as $run)
<?php
$passed = 0;
$failed = 0;
<title>CatKit!</title>
<link href="{{ asset('/css/app.css') }}" rel="stylesheet">
<!-- Fonts -->
<link href='//fonts.googleapis.com/css?family=Roboto:400,300' rel='stylesheet' type='text/css'>
<!-- HTML5 shim and Respond.js for IE8 support of HTML5 elements and media queries -->
<!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
<!--[if lt IE 9]>
<script src="https://oss.maxcdn.com/html5shiv/3.7.2/html5shiv.min.js"></script>
<script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
<![endif]-->
<?php
echo Lava::jsapi();
?>
</head>
<body>
<nav class="navbar navbar-default">
<div class="container-fluid">
<div class="navbar-header">
<button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#bs-example-navbar-collapse-1">
<span class="sr-only">Toggle Navigation</span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
</button>
<a class="navbar-brand" href="#">Laravel</a>
</div>
/**
* @param string $name
* @param string $title
* @param bool|false $isStacked
*/
public function getColumnChart($name = '', $title = '', $isStacked = false)
{
$this->columnChart = \Lava::ColumnChart($name, $this->lavaDataTable, ['isStacked' => $isStacked]);
$this->setTitle($title);
}
private function reportIniciativaInstituicaoByCidade($cidade)
{
$dados = \Lava::DataTable();
$dados->addStringColumn('Instituição')->addNumberColumn('Total')->addNumberColumn('Apoiadoras')->addNumberColumn('Mantenedoras');
//com
$ci = DB::table('iniciativas')->join('enderecos', 'enderecos.idEndereco', '=', 'iniciativas.endereco_id')->where('enderecos.cidade_id', $cidade)->whereRaw('iniciativas.idIniciativa IN (SELECT iniciativa_id FROM iniciativa_instituicoes)')->get();
//sem
$si = DB::table('iniciativas')->join('enderecos', 'enderecos.idEndereco', '=', 'iniciativas.endereco_id')->where('enderecos.cidade_id', $cidade)->whereRaw('iniciativas.idIniciativa NOT IN (SELECT iniciativa_id FROM iniciativa_instituicoes)')->get();
//apoiador
$ip = DB::table('iniciativas')->join('enderecos', 'enderecos.idEndereco', '=', 'iniciativas.endereco_id')->where('enderecos.cidade_id', $cidade)->whereRaw('iniciativas.idIniciativa IN (SELECT iniciativa_id FROM iniciativa_instituicoes WHERE tipoVinculo = 1)')->get();
//mantenedor
$im = DB::table('iniciativas')->join('enderecos', 'enderecos.idEndereco', '=', 'iniciativas.endereco_id')->where('enderecos.cidade_id', $cidade)->whereRaw('iniciativas.idIniciativa IN (SELECT iniciativa_id FROM iniciativa_instituicoes WHERE tipoVinculo = 2)')->get();
$dados->addRow(['C/ Instituições', count($ci), count($ip), count($im)]);
$dados->addRow(['S/ Instituições', count($si)]);
return $dados;
}
/**
* ChartController constructor.
*/
public function __construct()
{
$this->lavaDataTable = \Lava::DataTable();
}
public function comparative($society, Request $request)
{
$startdate = $request->input('yr') . "-01-01";
$enddate = $request->input('yr') . "-12-31";
$groups = $request->input('groups');
$values = \Lava::DataTable();
$values->addNumberColumn('Weeks');
$charttitle = $request->input('yr') . " Comparative attendance by weeks: ";
foreach ($groups as $gid) {
$tot = 0;
$group = Group::find($gid);
$charttitle = $charttitle . $group->groupname . " v ";
$values->addNumberColumn($group->groupname);
$stats = Statistic::with('group')->where('group_id', '=', $group->id)->where('statdate', '>=', $startdate)->where('statdate', '<=', $enddate)->orderBy('statdate')->get();
foreach ($stats as $stat) {
$tstamp = strtotime($stat->statdate);
$week = 1 + ceil(($tstamp - strtotime($startdate)) / (86400 * 7));
$halfstats[$gid][$week] = $stat->attendance;
$tot = $tot + $stat->attendance;
}
$halfstats[$gid]['avg'] = round($tot / count($stats), 2);
$avg[$gid] = $group->groupname . ": " . $halfstats[$gid]['avg'];
}
$charttitle = substr($charttitle, 0, -2);
for ($i = 1; $i < 53; ++$i) {
$dum = array();
array_push($dum, $i);
foreach ($halfstats as $hs) {
if (array_key_exists($i, $hs)) {
array_push($dum, $hs[$i]);
} else {
array_push($dum, $hs['avg']);
}
}
$values->addRow($dum);
}
$linechart = \Lava::LineChart('Chart')->dataTable($values)->title($charttitle);
return View::make('statistics.comparative', compact('linechart', 'avg'));
}
{!! Form::open(['route' => 'graficar.barras', 'method' => 'post']) !!}
{!! Form::checkbox('id', 'Id') !!} Id
{!! Form::checkbox('existencias', 'Existencias') !!} Existencias
{!! Form::checkbox('precio', 'Precio') !!} Precio
{!! Form::submit('Graficar', ['class' => 'btn btn-primary']) !!}
{!! Form::close() !!}
</div>
</div>
<br><br>
<div id="barras-div"> @if(isset($barchart))
<?php
echo Lava::render('ColumnChart', 'Barras', 'barras-div');
?>
@endif
</div>
<br><br><br>
</div>
<br><br><br>
@stop
echo asset('images/forkme.png');
?>
" alt="Fork me on GitHub">
</a>
<h1 class="exampleTitle">
<?php
echo link_to('/lavacharts/examples', 'LavaChart Examples');
?>
\ Basic A Chart
</h1>
<?php
echo Lava::AreaChart('Stocks')->outputInto('stock_div');
echo Lava::div(1000, 400);
if (Lava::hasErrors()) {
echo Lava::getErrors();
}
?>
<br />
<div class="prettyprintContainer">
<span class="prettyprintContainerLabel">Closure Route/Controller</span>
<div class="prettyprintCode">
<pre class="prettyprint linenums">
$stocksTable = Lava::DataTable('Stocks');
$stocksTable->addColumn('date', 'Date', 'date')
->addColumn('number', 'Projected', 'projected')
->addColumn('number', 'Closing', 'closing');
<div class="well well-lg col-md-6">
<h4>Planes Por Empresas</h4>
<?php
use Carbon\Carbon;
$stocksTable = Lava::DataTable();
$empresas = Empresas::all()->toArray();
$stocksTable->addStringColumn('Empresa')->addNumberColumn('Cantidad');
foreach ($empresas as $key => $empresa) {
$rowData = array($empresa["nombre"], App\Planes::where("empresa_id", "=", $empresa["id"])->count());
$stocksTable->addRow($rowData);
}
$lineChart = Lava::PieChart('Stocks')->setOptions(array('datatable' => $stocksTable));
echo Lava::render('PieChart', 'Stocks', 'stocks-div', true);
?>
</div>
public function getChart($title, $chartType, $height, $width, $arrayColors, $datatTable)
{
if ($chartType = 'PieChart') {
\Lava::PieChart($title)->setOptions(array('datatable' => $datatTable, 'legend' => \Lava::Legend(array('position' => 'none')), 'chartArea' => \Lava::ChartArea(['width' => $width, 'height' => $height]), 'colors' => $arrayColors, 'is3D' => true));
} elseif ($chartType = 'DonutChart') {
}
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
$stocksTable = \Lava::DataTable();
// Lava::DataTable() if using Laravel
$stocksTable->addColumns(array(array('string', 'Date'), array('number', 'On'), array('number', 'Off')));
$sql = "select TIME(created_at) as createdat,\n \n COUNT(IF(sensor_state=1, 1, NULL)) AS on_state,\n COUNT(IF(sensor_state=0, 1, NULL)) AS off_state\n FROM smoke_sensors GROUP BY created_at";
//$sql="select count(sensor_state) as count_val,TIME(created_at) as createdat from smoke_sensors
// group by createdat ";
$result = DB::select($sql);
foreach ($result as $data) {
$rowData = array($data->createdat, $data->on_state, $data->off_state);
$stocksTable->addRow($rowData);
}
/*for ($a = 1; $a < 30; $a++)
{
$rowData = array(
"2014-8-$a", rand(800,1000), rand(800,1000)
);
$stocksTable->addRow($rowData);
}*/
$lineChart = \Lava::ColumnChart('Stocks')->setOptions(array('datatable' => $stocksTable, 'title' => 'Smoke Sensor States'));
//$chart->datatable($stocksTable);
return View('Home.charts');
}
public function getIndex()
{
$minigraph_data = array();
$minigraph_data['account_created'] = $this->graphDataBuild('account_created');
$minigraph_data['login'] = $this->graphDataBuild('login');
$minigraph_data['activity'] = $this->graphDataBuild('activity');
$minigraph_data['activity_unique'] = $this->graphDataBuild('activity', '5', true);
View::share('minigraph_data', $minigraph_data);
View::share('minigraph_json', json_encode($minigraph_data));
$widgets = $this->widgets();
View::share('widgets', $widgets);
$results = DB::select('SELECT email FROM users WHERE UNIX_TIMESTAMP(`last_activity`) > ?', array(time() - 600));
View::share('whosonline', $results);
$stocksTable = Lava::DataTable('Stocks');
$stocksTable->addColumn('string', 'Week', 'count');
$stocksTable->addColumn('number', 'Hits', 'projected');
$stocksTable->addColumn('number', 'Unique', 'projected');
foreach (array_reverse($minigraph_data['activity']['data'], true) as $i => $d) {
$data[0] = $i == 0 ? "This week" : Carbon::now()->subWeeks($i)->diffForHumans();
$data[1] = $d;
$data[2] = $minigraph_data['activity_unique']['data'][$i];
$stocksTable->addRow($data);
}
Lava::LineChart('Stocks')->setConfig();
return Theme::make('admin/dashboard');
}
public function getChart(Request $request)
{
$reasons = \Lava::DataTable();
$reasons->addStringColumn('Reasons')->addNumberColumn('Percent')->addRow(array('Passed', 50))->addRow(array('Failed', 30))->addRow(array('Skipped', 20));
$piechart = \Lava::PieChart('myPieChart')->setOptions(array('datatable' => $reasons, 'legend' => \Lava::Legend(array('position' => 'none')), 'chartArea' => \Lava::ChartArea(['width' => 250, 'height' => 250]), 'colors' => array('078B3E', 'CD1E35', 'FCDC27')));
$threedpiechart = \Lava::PieChart('myThreeDPieChart')->setOptions(array('datatable' => $reasons, 'legend' => \Lava::Legend(array('position' => 'none')), 'chartArea' => \Lava::ChartArea(['width' => 250, 'height' => 250]), 'colors' => array('368DB9', 'A41034', 'FCDC27'), 'is3D' => true));
$donutchart = \Lava::DonutChart('myDonut')->setOptions(array('datatable' => $reasons, 'legend' => \Lava::Legend(array('position' => 'none')), 'chartArea' => \Lava::ChartArea(['width' => 250, 'height' => 250]), 'colors' => array('368DB9', 'A41034', 'FCDC27')));
}
