/**
* Show the form for creating a new resource.
*
* @return Response
*/
public function create()
{
$reasons = Lava::DataTable();
$reasons->addStringColumn('Reasons')->addNumberColumn('Percent')->addRow(array('Check Reviews', 5))->addRow(array('Watch Trailers', 2))->addRow(array('See Actors Other Work', 4))->addRow(array('Settle Argument', 89));
$piechart = Lava::PieChart('IMDB')->setOptions(array('datatable' => $reasons, 'title' => 'Reasons I visit IMDB', 'is3D' => true, 'slices' => array(Lava::Slice(array('offset' => 0.2)), Lava::Slice(array('offset' => 0.25)), Lava::Slice(array('offset' => 0.3)))));
return view('reports.birth_registration.pie_chart')->with('piechart', $piechart);
}
public function index()
{
$orders = Order::all();
$sales = null;
$taxes = null;
foreach ($orders as $order) {
$sales = $sales + $order->total;
$taxes = $taxes + $order->sub_total;
}
$taxes = $sales - $taxes;
$temperatures = Lava::DataTable();
$temperatures->addDateColumn('Date')->addNumberColumn('Last period')->addNumberColumn('This period')->addRow(array('2015-11-1', 4524, 3503))->addRow(array('2015-11-2', 2332, 3880))->addRow(array('2015-11-3', 4700, 2130))->addRow(array('2015-11-4', 4200, 3100))->addRow(array('2015-11-5', 4302, 3500))->addRow(array('2015-11-6', 4130, 2332))->addRow(array('2015-11-7', 4820, 3200))->addRow(array('2015-11-8', 2504, 3500))->addRow(array('2015-11-9', 4500, 3500))->addRow(array('2015-11-10', 3350, 3500))->addRow(array('2015-11-11', 3350, 3100))->addRow(array('2015-11-12', 4500, 3555))->addRow(array('2015-11-13', 4500, 3330))->addRow(array('2015-11-14', 3350, 3200))->addRow(array('2015-11-15', 4500, 3500))->addRow(array('2015-11-16', 3350, 3500))->addRow(array('2015-11-17', 4500, 4500))->addRow(array('2015-11-18', 4500, 3500));
$linechart = Lava::LineChart('Temps')->dataTable($temperatures)->title('Sales');
//
/// dd(Lava::BackgroundColor());
$viewBag = array('permission' => \Auth::user()->permission->name, 'orders' => $orders, 'orders_active' => Order::where('trash', '=', 0)->orderBy('created_at', 'desc')->take(5)->get(), 'sales' => $sales, 'taxes' => $taxes, 'products' => Product::where('trash', '=', 0)->get(), 'products_amount' => Product::where('stock', '=', 'N')->get(), 'users' => User::where('trash', '=', 0)->get(), 'categories' => Category::where('trash', '=', 0)->get());
return \View::make('backend.index', $viewBag);
}
private function _siteStats()
{
$sitesCreated = DB::table('site')->select(DB::raw('DATE(created_at) as date'), DB::raw('count(*) as count'))->whereBetween('created_at', [Carbon::now()->subWeek(1), Carbon::now()])->groupBy('date')->orderBy('date')->get('date', 'count');
$sitesRun = DB::table('site')->select(DB::raw('DATE(created_at) as date'), DB::raw('count(*) as count'))->whereBetween('created_at', [Carbon::now()->subWeek(1), Carbon::now()])->where('finished', '1')->where('active', '0')->groupBy('date')->orderBy('date')->get('date', 'count');
$sitesClosed = DB::table('site')->select(DB::raw('DATE(created_at) as date'), DB::raw('count(*) as count'))->whereBetween('created_at', [Carbon::now()->subWeek(1), Carbon::now()])->where('finished', '0')->where('active', '0')->groupBy('date')->orderBy('date')->get('date', 'count');
$sitesTable = Lava::DataTable();
$sitesTable->addDateColumn('Date')->addNumberColumn('Created')->addNumberColumn('Finished')->addNumberColumn('Closed');
$data = [];
foreach ($sitesCreated as $res) {
$data[$res->date] = [];
$data[$res->date]['created'] = $res->count;
}
foreach ($sitesRun as $res) {
$data[$res->date]['run'] = $res->count;
}
foreach ($sitesClosed as $res) {
$data[$res->date]['closed'] = $res->count;
}
foreach ($data as $date => $count) {
if (isset($count['created'])) {
$created = $count['created'];
} else {
$created = 0;
}
if (isset($count['run'])) {
$run = $count['run'];
} else {
$run = 0;
}
if (isset($count['closed'])) {
$closed = $count['closed'];
} else {
$closed = 0;
}
$sitesTable->addRow([$date, $created, $run, $closed]);
}
Lava::ColumnChart('Sites', $sitesTable, ['titleTextStyle' => ['color' => '#eb6b2c', 'fontSize' => 14]]);
}