public static function getDatatable() { $id = Session::get('user_id'); $first_day = date("Y-m-01"); $last_day = date("Y-m-t"); $today = date("Y-m-d"); /* MONTH user consumption*/ $monthUserConsumption = WaterRegister::where('state', '=', 'Mendoza')->where('user_id', '=', $id)->whereBetween('date', [$first_day, $last_day])->sum('value'); /* MONTH city consumption total and average lts/hour*/ $user = User::select(['city_id'])->with('state', 'city')->where('id', $id)->first(); $cityConsumption = WaterRegister::select(DB::raw('sum(value) as total, avg(value) as avg'))->where('city', '=', $user->city->name)->whereBetween('date', [$first_day, $last_day])->groupBy('city')->get(); $cityTotalConsumption = $cityConsumption[0]->total; $cityAverage = $cityConsumption[0]->avg; /*current consumption and liters per hour (DAY)*/ $consumption = WaterRegister::where('date', '=', $today)->where('user_id', '=', $id)->sum('value'); $consumptionPerHour = $consumption / 60; /*water price*/ $waterPrice = WaterPrice::select('price')->active()->get(); /*water bill*/ $price = $waterPrice[0]->price; $liters = WaterRegister::where('date', '=', $today)->where('user_id', '=', $id)->sum('value'); $bill = $liters * $price; $aux = new stdClass(); $aux->monthUserConsumption = $monthUserConsumption; $aux->cityTotalConsumption = $cityTotalConsumption; $aux->cityAverage = $cityAverage; $aux->consumptionPerHour = $consumptionPerHour; $aux->consumption = $consumption; $aux->waterPrice = $price; $aux->bill = $bill; $data = [collect($aux)]; $datatable = Datatables::of(collect($data)); return $datatable->make(true); }
public static function getDatatable() { $water_prices = WaterPrice::select(['id', 'description', 'price', 'active', 'updated_at'])->get(); $datatable = Datatables::of($water_prices); $datatable->addColumn('actions', '<a href="{{ URL::to(\'water-prices/\' . $id.\'/edit\') }}" class="btn btn-default" title="Editar" ><i class="fa fa-edit"></i></a> <a href="#deleteModal" class="mb-xs mt-xs mr-xs modal-with-zoom-anim btn btn-danger delete-link" data-href="{{ URL::to(\'water-prices/\' . $id) }}" title="Eliminar" ><i class="fa fa-trash"></i></a>'); return $datatable->make(true); }