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'))); }