How to access a column data from a function into a different function

@RayC Thank you very much, i got a small issue

Error
Using $this when not in object context

my current code:

 private function get_view($from, $to)
    {
        $Reports = DB::table('create_vouchers')->whereNull('create_vouchers.deleted_at')
            ->select('create_vouchers.id', 'client_name', 'night', 'hotels.hotel_name', 'arrivaldate', 'departuredate', 'total_amount', 'number_of_room', 'payment_mode')
            ->join('hotels', 'hotels.id', 'create_vouchers.hotel_name_id')
            ->whereBetween('arrivaldate', [$from, $to])->get();


        return view('admin.vouchersAccountings.index', compact('Reports', 'from', 'to'));
    }

    public $DepartureDate = null;

    public function getStatus()
    {
        $CurrentDay = Carbon::today()->format(config('panel.date_fomat'));
        $this->DepartureDate = DB::table('create_vouchers.departuredate');

        if ($CurrentDay >= $this->DepartureDate) {
            return "S";
        } else {
            return "D";
        }
    }

@tzak9022 Not sure what it is you are trying to do here, but any properties in a class is usually defined first in the class, and not between methods. Why is the get_view a private method? My guess is that is the method you tell Laravel to execute from your route, if so, it should be public.

This line makes no sense at all, you try to assign it a table called departuredate in a database called create_vouchers....

$this->DepartureDate = DB::table('create_vouchers.departuredate');

I do suggest that you take a look here before you do anything else.

https://laracasts.com/series/laravel-8-from-scratch

@Tray2 actually the table is : create_vouchers and the column is departuredate

I'm trying to get the departuredate column from get_view function without creating a new query from scratch, is that possible?

@tzak9022 Sure, you can.

$Reports->the_column_you_want

This returns an instance of the query builder, and does not contain the date.

DB::table('create_vouchers.departuredate');

@Tray2 How about this code

 public function getStatus()
    {
        $CurrentDay = Carbon::today()->format(config('panel.date_fomat'));
        $DepartureDate = DB::table('create_vouchers')
            ->select('departuredate')
            ->get();
        return $DepartureDate;
      

        if ($DepartureDate > $CurrentDay) {
            return "Staying";
        } else {
            return "Departed";
        }
    }

however i'm getting all the departure dates of other rows

1 Michael Cox hotel 2022-07-31 2022-08-01 1 1 by_cash 1000.00 [{"departuredate":"2022-08-01"},{"departuredate":"2022-08-21"},{"departuredate":"2022-08-28"},{"departuredate":"2022-08-20"},{"departuredate":"2022-08-25"},{"departuredate":"2022-08-28"},{"departuredate":"2022-09-09"}]

@tzak9022 Of course you do, you are asking for all of them, you need to add a where in your query. However, you need to learn some essentials about programming first.

public function getStatus()
    {
        $CurrentDay = Carbon::today()->format(config('panel.date_fomat'));
		
//This part fetches all the create_vouchers (Which is a bad table name btw)
        $DepartureDate = DB::table('create_vouchers')
            ->select('departuredate')
            ->get();

// This returns the departure dates
        return $DepartureDate;
      
// Nothing after the return above is ever executed, so everything below is dead code.
        if ($DepartureDate > $CurrentDay) {
            return "Staying";
        } else {
            return "Departed";
        }
    }

Oh, and please don't use Capitals in the beginning of a varible name.

$DepartuteDate 

// should be

$departureDate

And when it comes to method names, pick a standard and use it everywhere. I prefere using the same naming convention as my variables getView and not get_view .

Colum names in your database that contains more than one word are seperated by an underscore.

departuredate should be departure_date