What do report you need?

$product = Product::with(‘photos’,’attributeValues.attributeGroup’,’brand’,’categories’)->inRandomOrder()->take(40)->whereHas(‘categories’, function ($query) use($id) {
$query->where(‘id’,$id);
})->toSql();
dd($product)
Try this

and the you run sql code in DBMS

for 3 not work

Luige can help me ?!

what do report you need?

I want package for reports

products collection is exist

try to see collection folder

i can’t help

ya exist , and error offces 0

i don’t know bro

What issues?

I’m using mac for 10 years and I have not any issue with Laravel installation on my Mac

hi i want to save status but not using enum in migration can anybody help me

Print your collection using dd and see the format

Hi, can somebody help me with best practices for frontend / backend separation in laravel 7? Will be thankful for any example

You can use integer field or string if u are using integer better define the status in the model. Because if you want to change the status value earlier you need to change only in the model

Create one more table as status and where you were planning for enum column replace it by foreign_key

enums are pain in the ass in longer run

I want to select an option when click edit.

BlogController.php

public function create()
{
$categories = Category::all();
return view(‘Admin.blogs.create’, compact(‘categories’));
}
create.blade.php

<select name=”category” id=”category” class=”form-control”>
@foreach($categories as $category)
<option {{ $category->id == $blog->categories->id ? ‘selected’ : ” }} value=”{{ $category->id }}”>
{{ $category->name_fa }}
</option>
@endforeach
</select>

Hello install MAMP server. If you cant afford MAMP pro then no worries once you install please follow the following article

https://stackcoder.in/posts/how-to-setup-mamp-virtual-hosts-for-local-php-development

I get this error

Property [id] does not exist on this collection instance.

In select there is no access for $blog variable

Please pass $blog data too. And along with it pass categories with eager loading

is there any faster alternative for composer (Windows) ?

Guys please suggest the Laravel invoice package

You can use a package for faster installation to achieve it. Kindly chek my article

https://stackcoder.in/posts/how-to-install-packages-parallel-for-faster-development-in-composer

In invoice what would you like to achieve.

Just a sample page?

No I need to generate invoice for customer

It is must be customizable

I have added article which has almost all the code and even invoice template with PDF download feature. Please check it @

https://stackcoder.in/posts/how-to-create-save-download-pdf-from-blade-template-in-php-laravel

Because you wont get any package as per your needs. But if you need open source projects then I can help you

K bro thanks

I going to try for DOMpdf Laravel 3rd party package

I have used the same in article

please reffer it once

K bro

Sorry its Laravel PDF which is wrapper around mPDF. Sorry my bad

public function show($id)
{
$attributeGroups=AttributeGroup::all();
$cities=City::with(‘province’)->first();
$categories=Category::with(‘childrenRecursive’)->where(‘parent_id’, null)->get();
$cart = Session::has(‘cart’) ? Session::get(‘cart’) : null;
$brands=Brand::inRandomOrder()->get();
$list=Category::findOrFail($id);
$lists=Category::where(‘id’,$id)->get();
$coupons=Coupon::all();

$products=Product::with(‘photos’,’attributeValues.attributeGroup’,’brand’,’categories’)->inRandomOrder()->take(40)->whereHas(‘categories’, function ($query) use($id) {
$query->where(‘category_id’,$id);
})->paginate(12);

if (Auth::check()){
$user=User::findOrFail(Auth::user()->id);
return view(‘frontend.categories.show’,[‘products’=>$products,’categories’=>$categories,’list’=>$list,’lists’=>$lists,’user’=>$user,’cities’=>$cities,’coupons’=>$coupons,’cart’=>$cart,’brands’=>$brands,’attributeGroups’=>$attributeGroups]);
}
else{
return view(‘frontend.categories.show’,[‘products’=>$products,’categories’=>$categories,’list’=>$list ,’lists’=>$lists,’cities’=>$cities,’coupons’=>$coupons,’cart’=>$cart,’brands’=>$brands,’attributeGroups’=>$attributeGroups]);
}

// $lists=Category::where(‘parent_id’,null)->get();
// return view(‘frontend.categories.show’,[‘categories’=>$categories,’lists’=>$lists]);
}

Hi has anyone implement AMP pages for blog where the content is dynamically pulled from database. Or if you have any reference kindly share.

Do you suggest me to create sub domain as https://amp.domain_name.com or route prefix with https://domain_name.com/amp/posts/post_url

Any help is really appreciate.