Exemple #1
0
 public function settledReports()
 {
     //Get all reports for the user - owned + associated
     $expenseReports = ExpenseReport::where(function ($query) {
         $query->where('owner_id', '=', $this->id)->orWhereHas('users', function ($query) {
             $query->where('user_id', '=', $this->id);
         });
         //And check for settlement conditions
     })->where(function ($query) {
         //Report is completely settled
         $query->where('status', '>=', 3)->orWhere(function ($query) {
             $query->where('status', '=', 2)->whereDoesntHave('settlements', function ($query) {
                 $query->where('completed', '=', 0)->where(function ($query) {
                     $query->where('owee_id', '=', $this->id)->orWhere('owed_id', '=', $this->id);
                 });
             });
         });
     });
     return $expenseReports;
 }
Exemple #2
0
 public function listAllExpensesReports()
 {
     $expensesReports = ExpenseReport::where('mr_id', \Auth::user()->id)->get();
     $dataView = ['expensesReports' => $expensesReports];
     return view('mr.expense_report.list', $dataView);
 }