private function loadBudgetsData($budgetId, $masterBriefingId, $activeTab)
 {
     $isAdding = true;
     if (!isset($activeTab)) {
         $activeTab = "#list";
     }
     $masterBriefingId = isset($masterBriefingId) ? $masterBriefingId : -1;
     $masterBriefing = null;
     $versionNumber = 1;
     $lastVersionDate = null;
     $nextBudgetId = 1;
     $budgets = null;
     //DB::select( DB::raw("SELECT * FROM some_table WHERE some_col = '$someVariable'")); // Incorrect way
     //DB::select( DB::raw("SELECT * FROM some_table WHERE some_col = :somevariable"), array('somevariable' => $someVariable,)); // Safe way
     $lastBudgetId = DB::select(DB::raw("SELECT AUTO_INCREMENT AS nextId FROM information_schema.TABLES WHERE (TABLE_NAME = 'budgets')"));
     if (isset($lastBudgetId)) {
         $nextBudgetId = $lastBudgetId[0]->nextId;
     }
     if ($masterBriefingId > 0) {
         $budgets = Budget::where('briefing_id', $masterBriefingId)->orderBy('date_budget', 'DESC')->orderBy('created_at', 'DESC')->get();
         $masterBriefing = Briefing::find($masterBriefingId);
     } else {
         $budgets = Budget::orderBy('date_budget', 'DESC')->orderBy('created_at', 'DESC')->get();
     }
     $budgetTypes = BudgetType::orderBy('id', 'ASC')->get();
     $addEditTitleLabel = trans('budgets.add');
     $relationships = array('budgetTypes' => $budgetTypes);
     if (isset($budgetId)) {
         $isAdding = false;
         $addEditTitleLabel = trans('budgets.edit');
         $budgetToEdit = Budget::find($budgetId);
         if (!$budgetToEdit) {
             return Redirect::to(route('get_budgets'));
         } else {
             $versionNumber = $budgetToEdit->budgetVersionCount();
             $lastVersionDate = $budgetToEdit->budgetVersions->last()->date_budget_version;
             return View::make('pages.budgets.index')->with('isAdding', $isAdding)->with('activeTab', $activeTab)->with('addEditTitleLabel', $addEditTitleLabel)->with('budgets', $budgets)->with('relationships', $relationships)->with('budgetToEdit', $budgetToEdit)->with('masterBriefingId', $masterBriefingId)->with('masterBriefing', $masterBriefing)->with('nextBudgetId', $nextBudgetId)->with('versionNumber', $versionNumber)->with('lastVersionDate', $lastVersionDate);
         }
     } else {
         return View::make('pages.budgets.index')->with('isAdding', $isAdding)->with('activeTab', $activeTab)->with('addEditTitleLabel', $addEditTitleLabel)->with('budgets', $budgets)->with('relationships', $relationships)->with('masterBriefingId', $masterBriefingId)->with('masterBriefing', $masterBriefing)->with('nextBudgetId', $nextBudgetId)->with('versionNumber', $versionNumber)->with('lastVersionDate', $lastVersionDate);
     }
 }
 public function removeBudget(Request $request)
 {
     $id = $request->input('id');
     $budget = Budget::where('id', $id)->first();
     if (isset($budget)) {
         $budget->status = 'removed';
         $budget->save();
         return json_encode(array('message' => 'removed'));
     } else {
         return json_encode(array('message' => 'notfound', 'id' => $id));
     }
 }