Filtering Coach Projects

### If `project` is a relationship:
If the `project` is a relationship defined in the `Coach` model, you can use the `where` method on the relationship.

$coach = Auth::guard('coach')->user();

$projects = $coach->project()->where('status', 'active')->get();

### Explanation:
1. **`$coach->project()`**: Assumes `project` is defined as a relationship (e.g., `hasMany` or `belongsToMany`) in the `Coach` model.
2. **`where('status', 'active')`**: Filters projects based on the `status` column.
3. **`get()`**: Executes the query and retrieves the filtered projects.

—

### If `project` is an array or collection:
If `$coach->project` is already loaded as a collection, you can use Laravel's `where` method on the collection:

$coach = Auth::guard('coach')->user();

$projects = $coach->project->where('status', 'active');

### Explanation:
1. **`$coach->project`**: Accesses the loaded collection of projects.
2. **`where('status', 'active')`**: Filters the collection.

—

### Notes:
– Ensure that `project` is properly defined as a relationship in the `Coach` model.
– If you want to apply multiple conditions, you can chain `where` clauses:

$projects = $coach->project()->where('status', 'active')->where('priority', 'high')->get();

Let me know if you need help with defining the relationship or adding specific filters! 😊

Here is an updated version to **print the query**:

—

### Option 1: Printing Query Without Executing
You can **avoid executing** the query and print it like this:

$survetsets = $survetsets->with('project') // Eager load projects
    ->orderBy('isDefault', 'desc');

// Print query
dd($survetsets->toSql());

However, if you also use bindings (like parameters passed in `where` clauses), you must include them as follows:

dd(vsprintf(str_replace('?', '%s', $survetsets->toSql()), $survetsets->getBindings()));

—

### Option 2: Using Laravel Query Debugging Tools
You can use **`DB::enableQueryLog()`** to log and print all executed queries:

use IlluminateSupportFacadesDB;

DB::enableQueryLog(); // Enable query logging

$survetsets = $survetsets->with('project') // Eager load projects
    ->orderBy('isDefault', 'desc')
    ->get();

dd(DB::getQueryLog()); // Dump the logged queries

—

### Option 3: Printing Query with Eloquent Debugging Package
For a simpler approach, use packages like **`barryvdh/laravel-debugbar`**, which logs all queries with their execution time. This package automatically shows queries without altering your code.

Install via Composer:

composer require barryvdh/laravel-debugbar --dev

Enable the debugbar, and all queries (including eager-loaded ones) will be displayed in your browser.

—

Choose the option that best suits your debugging needs! Let me know if you need more clarification. 😊

Type::where('id', '!=', 1);

Here are the ways to achieve this:

—

### 1. Print the Query Without Executing (`toSql`)
To print the SQL query string **without** executing it:

$query = Type::where('id', '!=', 1);
dd($query->toSql());

Output:

select * from `types` where `id` != ?

—

### 2. Print Query with Bindings (Parameterized Query)
To see the actual query **with values** replaced (useful for debugging `?` placeholders):

$query = Type::where('id', '!=', 1);
dd(vsprintf(str_replace('?', '%s', $query->toSql()), $query->getBindings()));

Output:

select * from `types` where `id` != 1

—

### 3. Enable Query Logging (General Debugging)
If you want to log **all queries** being executed:

use IlluminateSupportFacadesDB;

DB::enableQueryLog(); // Start query log

// Your query
$results = Type::where('id', '!=', 1)->get();

dd(DB::getQueryLog()); // Dump the log of all queries

This will show an array containing the query, bindings, and execution time.

—

### 4. Laravel Debugbar (Recommended for Development)
If you are frequently debugging, install **`barryvdh/laravel-debugbar`**. It automatically logs all queries in a visual format.

composer require barryvdh/laravel-debugbar --dev

—

Let me know if you need further clarification or help with any of these options! 🚀