Nakov

So something like this maybe:

App\User::find(1)->procurements()->save($procurement, ['bided' => 1]);

or this

$user->procurements()->updateExistingPivot(
            $procurement->id,
            ['bided' => 1]
        );

https://laravel.com/docs/7.x/eloquent-relationships#updating-many-to-many-relationships

You are trying to use Collection methods on a Eloquent Builder instance.

so this:

 $lastbill = Bill::where('project_id', $project->id)->where('bill_type', 'p')
    ->get() // this should give you collection
    ->sortByDesc('created_at')->first();

same here:

$lastbill = Bill::where('project_id', $project->id)->where('bill_type', 'p')->get()->last();

So something like this maybe:

App\User::find(1)->procurements()->save($procurement, ['bided' => 1]);

or this

$user->procurements()->updateExistingPivot(
            $procurement->id,
            ['bided' => 1]
        );

https://laravel.com/docs/7.x/eloquent-relationships#updating-many-to-many-relationships

You cannot return a redirect if you are using fetch on the client side. You should handle the redirect on the client side as well. So

fetch(
    //do the post here
).then(function() { 
    // handle your redirect here, if it was successful. 
});

@jeroenvanrensen

What I am saying is that this:

public function getPrimaryColumnAttribute()
{
    return $this->primary_column;
}

doesn't make sense.. you can take the value out of the row and column by finding the row which you need and then directly access the column if it exists as you said:

$moonCrud = MoonCrud::find(1);

$moonCrud->primary_column;

Should give you what you want.

Why would you name the accessor method the same as your column, unless you want to modify the existing value?

In case you want to modify an existing value, then take a look at the documentation for its usage:

https://laravel.com/docs/master/eloquent-mutators#accessors-and-mutators

Basically you need this:

public function getPrimaryColumnAttribute($value)
{
    return $value;
}

Because calling $this->primary_column is like calling the same method over and over again.

@hekmatyar good job on trying to solve it :) you are becoming a programmer :)

so this is what you have in your controller:

$posts = Post::orderBy('created_at', 'desc')->where('status', 'published')->simplePaginate(4);
 
$categories = Category::all();
 
return view('layouts.blog', compact('posts', 'categories'));	

You are passing a collection of Categories, not a single category. Then who knows what you are doing in the view :)

but in order to access a single category, you will need to iterate over your categories:

@foreach($categories as $category)

// THEN HERE YOU WILL HAVE ACCESS TO A $category

@endforeach

You probably have a long way to go and learn the basics :)

I don't know for a toggle method, but there is a sync method on Many to Many that provides that. There is already an answer for this here: https://laracasts.com/discuss/channels/eloquent/sync-hasmany

Take a look if it helps your case.

When you use Route model binding the expected column is the ID not the SLUG nor any other custom column unless you tell laravel to do so, so in your Post model add this :

public function getRouteKeyName()
{
    return 'slug';
}

for reference: https://laravel.com/docs/master/routing#route-model-binding

And then just use your named route instead of the url, so it will be:

{{ route('show', [$category, $post]) }}

And it should work.

Using browser back button is normal case, but still being able to interact with the site as if there was a logged in user, that means that you are not guarding your endpoints with the auth middleware.So check your routes file for that, and group the protected endpoints with the auth middleware.

Also why do you need to specify the guard on the Auth facade, isn't it web your default guard or you have changes in your auth.php file?

The Laravel docs maybe? https://laravel.com/docs/7.x/routing

it says all of that :)

You have a problem with permissions on your folders. Here is an extensive answer on how to solve permission problems: https://stackoverflow.com/a/37266353/1457270

@luis100079 to what is your myFollowers a hasMany?

$this->hasMany(User::class);

or what?

if it is a User or whatever model, in there you are missing the chat_received relationship.. for example:

public function chat_received()
{
    return $this->belongsTo(ChatReceived::class);
}

It means that the with() method does not exists on a Collection instance :)

Try this:

return $user->myFollowers()->with('chat_received:id,message')->get();

@van1310 I answered the question that you initially asked. Now for this one, I really don't know what input data you are using.

• another thing is that you have this one:

$user_data = CompanyOnboardingForm1::select('user_id','created_tab_no')->where('id', $request->id)->first();

which uses the $request->id and then you check if that one exists and it is passed.

So you need to check your data and your rule.

The initial question is already resolved.

You cannot use conditionals in an array like that directly. Extract that part

$rules = [
    'company_email' => 'required|email|unique:users,email,NULL,NULL,deleted_at,NULL'
];

if ($request->id)
{
  $rules = [
    'company_email' => 'required|email|unique:users,email,' . $user_data->user_id . ',id,deleted_at,NULL',
  ];
}

$validator = Validator::make($request->all(), $rules);

I guess this line:

$tenant->mother_meter()->save($mother_meter);

throws the exception. Since you are saying to attach a mother meter to a tenant, and your mother_meter table does not have any tenant_id field which needs to be referenced.

Make sure that in your Tenant model, your relationship to mother_meter is setup correctly. I cannot understand your fields based on the image, so I cannot help much more.

public function mother_meter()
{
     return $this->hasMany(MotherMeter::class, 'COLUMN_NAME_HERE_FROM_THE_MOTHER_METER_TABLE', 'id');
}

id is the ID on the local Tenant table.

@noblemfd maybe like this:

$haventLoggedIn = User::whereDate('last_login_at', '<', now()->subDays(30))
	->orWhereNull('last_login_at')
	->get();

@noblemfd maybe like this:

$haventLoggedIn = User::whereDate('last_login_at', '<', now()->subDays(30))
	->orWhereNull('last_login_at')
	->get();

For the first:

$loggedIn = User::whereBetween('last_login_at', [now()->subDays(30), now()])->get();

And for the 2nd.

$haventLoggedIn = User::whereDate('last_login_at', '<', now()->subDays(30))->get();

Try this :)

You can by using a raw query. For example:

Report::whereRaw("(DATE_FORMAT(date, '%m-%d') BETWEEN ? and ?)", ['05-30', '06-30'])->get();

And here is the definition of the method itself:

@method string paragraph($nbSentences = 3, $variableNbSentences = true)

which means the default is 3 sentences, so it can't be short as a sentence. But still you can pass bigger number:

$faker->paragraph(10)

as an example.

And here is the definition of the method itself:

@method string paragraph($nbSentences = 3, $variableNbSentences = true)

which means the default is 3 sentences, so it can't be short as a sentence. But still you can pass bigger number:

$faker->paragraph(10)

as an example.

Open up RegisterController which you can find within App\Http\Controllers\Auth and change this line:

'password' => 'required|string|min:8|confirmed',

you see the min:8 rule there.

Or you can use the optional helper method

https://laravel.com/docs/7.x/helpers#method-optional

but that will just return null.

Anyhow, I don't think that this part will work neither: ->group->users. So you should rethink what you are trying to achieve here.

Open up RegisterController which you can find within App\Http\Controllers\Auth and change this line:

'password' => 'required|string|min:8|confirmed',

you see the min:8 rule there.

@linc

So first of all, you need to close the form after all the input elements.

<form name="form" action="{{route('payment.process')}}"  method="post">
@csrf
@method('POST')
    <div class="form-group">
        <input type="hidden"  class="form-control" name="promotion" id="promotion" value="{{ $promotion->id }}">
    </div>
    <button type="button" class="btn btn-success" id="submit-button"> Conferma e attiva la promo </button>
</form>

and then because you have name="promotion" in the controller you will have to use the same attribute as in the name, so here:

dd($request->input('promotion'));

@linc

So first of all, you need to close the form after all the input elements.

<form name="form" action="{{route('payment.process')}}"  method="post">
@csrf
@method('POST')
    <div class="form-group">
        <input type="hidden"  class="form-control" name="promotion" id="promotion" value="{{ $promotion->id }}">
    </div>
    <button type="button" class="btn btn-success" id="submit-button"> Conferma e attiva la promo </button>
</form>

and then because you have name="promotion" in the controller you will have to use the same attribute as in the name, so here:

dd($request->input('promotion'));

Did you forget to run php artisan storage:link maybe?

https://laravel.com/docs/master/filesystem#the-public-disk

This will create a symlink within your public directory, which will make those images available to show.

@saadaan good, so exactly what I said :)

Maybe like this:

foreach(['a','b','c','d','e','f'] as $category)
{
    factory(Category::class)->create(['name' => $category]);
}

Okay, take a look at your laravel configuration, so in your .env file check what DB connection are you using, and make sure you are connected to the same database to which you are running manual queries in.

And I don't understand your point with the latest comment :) so you got all then, what's the matter?

EDIT

So it might be because of duplicates, you don't have values. As that tries to return a KEY => VALUE array.

When you say the table has all the values, are you looking in the township_code table in the database, or you tried doing this:

dd(DB::table("township_code")->count());

@saadaan pluck returns a collection, so what would this give: $tcode->count()?

@msslgomez I believe that the problem is that your input name is password_confirm while based on the validation rule, the name of the field should be password_confirmation instead.

https://laravel.com/docs/master/validation#rule-confirmed

So change this

password_confirm: this.reg_form.password_confirm,

with

password_confirmation: this.reg_form.password_confirm,

@msslgomez I believe that the problem is that your input name is password_confirm while based on the validation rule, the name of the field should be password_confirmation instead.

https://laravel.com/docs/master/validation#rule-confirmed

So change this

password_confirm: this.reg_form.password_confirm,

with

password_confirmation: this.reg_form.password_confirm,

@msr2406 There is a noProrate() method on the subscription actually.. Take a look here:

https://laravel.com/docs/master/billing#subscription-quantity

So you can call it as such:

$user->subscription()->noProrate();

@noblemfd

$exception->getMessage()

should contain more specific error message than your custom one.

Your naming is a bit off and the format of the date

// here should be due_date if that's a column you are adding, I assume that `date` already
// exists in your database
protected $appends = ['due_date'];

public function getDueDateAttribute()
{
    return Carbon::parse($this->attributes['date'])->format('d/m/Y');
}

now before you pipe it to a formatter, try printing it out as it is:

  <td>{{ product.due_date }}</td>

isn't this showing anything?

Yes, you can add a fallback route which will be executed if non other matches your request:

https://laravel.com/docs/7.x/routing#fallback-routes

and here is a tutorial

https://laraveldaily.com/route-fallback-if-no-other-route-is-matched/#:~:text=Laravel%205.5.,page%20and%20introduce%20additional%20logic.

Yes, you can add a fallback route which will be executed if non other matches your request:

https://laravel.com/docs/7.x/routing#fallback-routes

and here is a tutorial

https://laraveldaily.com/route-fallback-if-no-other-route-is-matched/#:~:text=Laravel%205.5.,page%20and%20introduce%20additional%20logic.

@hemantadsl you are missing an import.

Add:

use App\Mail\ContactMe;

in your controller.

@luis100079 return stops the execution on any other call. So that's why it returns just the first one.

You can try the following instead:

$posts = Post::with('user:id,name')->get();

Now all of the posts will have the user name.

@luis100079 return stops the execution on any other call. So that's why it returns just the first one.

You can try the following instead:

$posts = Post::with('user:id,name')->get();

Now all of the posts will have the user name.

Take a look at this: https://laravel.com/docs/7.x/urls#signed-urls

The name of the method is the same, it is called on two different objects, and the behavior is different.

It is like two guys with the same name 😃 nothing wrong with that.

Because the response type is different. When you redirect, then you are hitting another controller action which returns the view that needs to be displayed. So in order to preserve the data that you are trying to pass, laravel uses flash session using the with() method: https://laravel.com/docs/7.x/redirects#redirecting-with-flashed-session-data

And when you respond with an HTML rendered view, using the view() helper, the with() method passes the data directly to the view and you get the values that you've passed by using their keys (variables): https://laravel.com/docs/7.x/views#passing-data-to-views

You can try and provide the idColumn as a last parameter: https://laravel.com/docs/master/validation#rule-unique

public function rules()
{
    return [
        'name' => ['required', 'string', 'unique:rooms,name,'.$this->room->name . ',name']
    ];
}

Take a look here : https://lumen.laravel.com/

You can try and provide the idColumn as a last parameter: https://laravel.com/docs/master/validation#rule-unique

public function rules()
{
    return [
        'name' => ['required', 'string', 'unique:rooms,name,'.$this->room->name . ',name']
    ];
}