/home/dvjjulio/softtrash/app/Http/Controllers/DashboardController.php
<?php

namespace LevelsToGas\Http\Controllers;

use Illuminate\Http\Request;

use LevelsToGas\Http\Requests;
use LevelsToGas\Http\Controllers\Controller;
use LevelsToGas\gts_data;
use LevelsToGas\vale_sigas;

class DashboardController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index(){
      return view('dashboard.index');
    }
    public function registro_table()
    {
        //
        $gts_data = new gts_data();
        $table_registros = $gts_data::OrderBy('date','desc')->paginate(40);
        return view('dashboard.registros_table')->with(compact('table_registros'));
    }

    public function registro_vale()
    {
        //
        $vale_sigas = new vale_sigas();
        $table_vales = $vale_sigas::OrderBy('created_at','desc')->paginate(20);
        return view('dashboard.registros_vale')->with(compact('table_vales'));
    }

    public function map_view(){
      return view('dashboard.map');
    }

    /**
     * Show the form for creating a new resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function json_graph()
    {
        //
        $fuels = new gts_data();
        $fuel = $fuels->fuel_graph();

        //$data = '([';
        $data = array();
        foreach ($fuel as $key => $value) {
          $date = strtotime( '-1 month' , strtotime( $value->date ) ) ;
          $data[$key] = array(strtotime($date),$value->fuel2);
          //$data .= '[Date.UTC('.str_replace('-',',',$value->date).'),'.$value->fuel2.'],';
        }
        //$data = substr($data,0,-1);
        //$data .= ']);';
        return json_encode($data);

    }

    /**
     * Store a newly created resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @return \Illuminate\Http\Response
     */
    public function store(Request $request)
    {
        //
    }

    /**
     * Display the specified resource.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function show($id)
    {
        //
    }

    /**
     * Show the form for editing the specified resource.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function edit($id)
    {
        //
    }

    /**
     * Update the specified resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function update(Request $request, $id)
    {
        //
    }

    /**
     * Remove the specified resource from storage.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function destroy($id)
    {
        //
    }
}