tehseen

@sinnbeck Thanks for correction Boss

okay so needs to change the - to . right ?

Let me check @sinnbeck

@sinnbeck thanks for reply.

So we have product zip folder where we save name and then we have this below link to download the zip

{{ asset( 'zip/'.$product->product_zip) }}

But i can see in my zip folder the once zip upload the file extension change its no more zip

see the screenshot please https://ibb.co/54yn5f2

I have write below code to upload zip however its fine to upload product in folder, But when i download via link the file type change and its no longer useful.

Here is the code to upload zip file

if($request->hasFile('product_zip')) {
            $zip = $request->file('product_zip');
            $filename_zip = time().'-'.uniqid().'-'.$zip->getClientOriginalExtension();
            $location = public_path('zip');
            $zip->move($location, $filename_zip);
            $product->product_zip = $filename_zip;
        } else {
            $product->product_zip = "";
        }
           	

Here is the validation

$this->validate($request, [
      'product_zip' => 'required|file|mimes:zip|max:10000'
]);

Thanks for help in advance

@tisuchi

still the same, but the issue is why we get the all user who don't have any product i only want to get user with products and limit (fetch first 5 or 6 products)

@a4family

same always get 5 product for only 1 user and then one product for 2.

Collection {#382 ▼
  #items: array:5 [▼
    0 => User {#412 ▶}
    1 => User {#413 ▶}
    2 => User {#414 ▶}
    3 => User {#415 ▶}
    4 => User {#416 ▶}
  ]
}

@tisuchi

i remove the user_id in my product model but still i get 5 products for user one and 1 product for user 2 but we have 5 for user too

here is the query

$productWithUser = User::with(['products' => function ($query) {

            $query->take(6);
        }])->has('products')->get()->toarray();

@tisuchi yeah sure here it was

product table in which user_id is foreign key https://ibb.co/sHS5dVL

User table https://ibb.co/jrrJ89j

@tisuchi

in my user modal

public function products() {
        return $this->hasMany('App\Product');
    }

in my product modal

public function user() {
        return $this->belongsTo('App\User', 'user_id');
    }

is something wrong ? can set user_id in user model not product ?

@tisuchi

Thanks for reply, the above query will get all user but in relationship for the second user we have 1 product (but second user have 5 products)

Collection {#382 ▼
  #items: array:5 [▼
    0 => User {#412 ▶}
    1 => User {#413 ▼
      #fillable: array:3 [▶]
      +sortable: array:3 [▶]
      #hidden: array:2 [▶]
      #connection: "mysql"
      #table: null
      #primaryKey: "id"
      #keyType: "int"
      +incrementing: true
      #with: []
      #withCount: []
      #perPage: 15
      +exists: true
      +wasRecentlyCreated: false
      #attributes: array:15 [▶]
      #original: array:15 [▶]
      #changes: []
      #casts: []
      #dates: []
      #dateFormat: null
      #appends: []
      #dispatchesEvents: []
      #observables: []
      #relations: array:1 [▼
        "products" => Collection {#411 ▼
          #items: array:1 [▼
            0 => Product {#430 ▼
              #fillable: array:4 [▶]
              +sortable: array:4 [▶]
              #connection: "mysql"
              #table: null
              #primaryKey: "id"
              #keyType: "int"
              +incrementing: true
              #with: []
              #withCount: []
              #perPage: 15
              +exists: true
              +wasRecentlyCreated: false
              #attributes: array:27 [▶]
              #original: array:27 [▶]
              #changes: []
              #casts: []
              #dates: []
              #dateFormat: null
              #appends: []
              #dispatchesEvents: []
              #observables: []
              #relations: []
              #touches: []
              +timestamps: true
              #hidden: []
              #visible: []
              #guarded: array:1 [▶]
            }
          ]
        }
      ]
      #touches: []
      +timestamps: true
      #visible: []
      #guarded: array:1 [▶]
      #rememberTokenName: "remember_token"
      -roleClass: null
      -permissionClass: null
    }
    2 => User {#414 ▶}
    3 => User {#415 ▶}
    4 => User {#416 ▶}
  ]
}

I want to get all author with their product at least 5 but the query is not working

$users = User::with(['products' => function ($query) {
            $query->limit(6);
        }])->get();

the above query will return something like below

Collection {#382 ▼
  #items: array:5 [▼
    0 => User {#412 ▼
      #fillable: array:3 [▶]
      +sortable: array:3 [▶]
      #hidden: array:2 [▶]
      #connection: "mysql"
      #table: null
      #primaryKey: "id"
      #keyType: "int"
      +incrementing: true
      #with: []
      #withCount: []
      #perPage: 15
      +exists: true
      +wasRecentlyCreated: false
      #attributes: array:15 [▶]
      #original: array:15 [▶]
      #changes: []
      #casts: []
      #dates: []
      #dateFormat: null
      #appends: []
      #dispatchesEvents: []
      #observables: []
      #relations: array:1 [▶]
      #touches: []
      +timestamps: true
      #visible: []
      #guarded: array:1 [▶]
      #rememberTokenName: "remember_token"
      -roleClass: null
      -permissionClass: null
    }
    1 => User {#413 ▶}
    2 => User {#414 ▶}
    3 => User {#415 ▶}
    4 => User {#416 ▶}
  ]
}

The first user only have product not all, but in my database both first and second author have product

Its relationship between user/author and products one to many

in my user modal

public function products() {
        return $this->hasMany('App\Product');
    }

in my product modal

 public function user() {
        return $this->belongsTo('App\User', 'user_id');
    }

and in database we have user_id in product table.

Please help

yes i have one item for user 2 but it return empty array why ?

I have the with product against user 1 and user 2

but it return 6 user and the only first user have product not others why ?

and the below give result but for second user they haven't give any product

$users = User::with(['products' => function ($query) {
    $query->limit(6);
}])->get();

Thank.

But this only gives me one user

$users = User::with(['product' => function ($query) {
            $query->limit(6);
}])->has('product', '>=', 6)->get();

But we have many users what's the issue with above query.

I want to display 6 product of each user in slider how i can do this ?

It's a relationship between user and product one to many and user_id is in product table.

Here is the image explanation

https://ibb.co/ZG1VMr4

this error

The product zip must be 50000 kilobytes.

even file is 16mb you can see here

"product_zip" => UploadedFile {#32 ▼
        -test: false
        -originalName: "stock-icon-bulb.zip"
        -mimeType: "application/x-zip-compressed"
        -size: 16285787
        -error: 0
        path: "C:\xampp\tmp"
        filename: "php8FAF.tmp"
        basename: "php8FAF.tmp"
        pathname: "C:\xampp\tmp\php8FAF.tmp"
        extension: "tmp"
        realPath: "C:\xampp\tmp\php8FAF.tmp"
        aTime: 2020-09-07 10:05:50
        mTime: 2020-09-07 10:05:5

It means the validation error like below

$this->validate($request, [
	'product_zip' => 'required|mimes:zip|size:20000',
]);

but still get error the file is 16.58mb

Yes i wrote 50000 but still get error with 20mb file.

Thanks.

So what i write in validation is correct for 20mb ?

thanks for answer but its 200mb isn't i want to validate file upto 20mb not 200mb

I want to upload 20mb max file (type zip) i write the following validation

$this->validate($request, [
	'product_zip' => 'required|mimes:zip|size:50000',
]);

i also have zip file which is

+files: FileBag {#47 ▼
#parameters: array:1 [▼
      "product_zip" => UploadedFile {#32 ▼
        -test: false
        -originalName: "stock-icon-bulb.zip"
        -mimeType: "application/x-zip-compressed"
        -size: 16285787
        -error: 0
        path: "C:\xampp\tmp"
        filename: "php8FAF.tmp"
        basename: "php8FAF.tmp"
        pathname: "C:\xampp\tmp\php8FAF.tmp"
        extension: "tmp"
        realPath: "C:\xampp\tmp\php8FAF.tmp"
        aTime: 2020-09-07 10:05:50
        mTime: 2020-09-07 10:05:50
        cTime: 2020-09-07 10:05:50
        inode: 0
        size: 16285787
        perms: 0100666
        owner: 0
        group: 0
        type: "file"
        writable: true
        readable: true
        executable: false
        file: true
        dir: false
        link: false
        linkTarget: "C:\xampp\tmp\php8FAF.tmp"

but it throw me validation error, what was wrong please advice.

1. I have product_zip column in product table.

2. Am listing all order products in template and i have product id in order so i want to get product_zip by id of product.

$user = Auth::id();

        $orderdata = Order::where('user_id', $user)->get()->toArray();
        $orders = Order::where('user_id', $user)->get();

        $carts = [];
        foreach ($orderdata as $key => $value) {
            $carts[] = unserialize($value['cart']);
        }

        $data = [];
        $data['items'] = [];
        foreach ($carts as $key => $value) {
            foreach ($value->items as $key => $values) {
                $itemDetail=[
                    'name' => $values['item']['product_name'],
                    'id' => $values['item']['id'],
                    'itemprice' => $values['item']['price'],
                    'price' => $values['price'],
                    'qty' => $values['qty']
                ];

                $data['items'][] = $itemDetail;
            }
        }

        $total = 0;
        foreach($data['items'] as $item) {
            $total += $item['itemprice']*$item['qty'];
        }

        $data['total'] = $total;

        return view('frontend.pages.myaccount')->withData($data);

so i have $item['id'] in blade template where i want product_zip info and its in product table but i have product id how i can get ?

I have order array in template in which i display all data of order.

But i am looking to get the product download link but its in product table i have product id in blade like below

 @foreach($data['items'] as $item)

	//product id
$pid = $item['id];

}

i want to get download some data by product id in blade how i can do ?

If i have 83 it will return me this

Array ( [0] => 15 [1] => 15 [2] => 15 [3] => 15 [4] => 15 [5] => 5 )

but the total is 80 however 3 is still missing so what i can do in this case.

Thanks.

So i try with number 9 as customer_request so it will be 5+4 but it still give me

Array
(
    [0] => 5
    [1] => 5
    [2] => 1
)

which is wrong it should give me

Array
(
    [0] => 5
    [1] => 4
)

We have 1 Liter & 5 liter product we received order of 11 Liter. So who i can split those 11 liter in to our products we give two of 5 liter and one of 1 in the above case.

Can any one help please.

i mean how i can split numbers in products count of how i can process ?

I have a category single page where i get products by category slug (single category page), also i have relationship between category and product so i get all product by category which is fine (below listed).

$category = Category::where('slug', '=', $slug)->firstOrFail();

$categoryProducts = $category->products()->paginate(24);

//all product by above category 
dd($categoryProducts);

So what i try to do is i want to filter those product via category like what i did in product listing.

 $products = Product::where(function($query){

            $all = Input::has('all') ?  Input::get('all') : null;
            $free = Input::has('price') ?  Input::get('price') : null;
            $popular = Input::has('popular') ? Input::get('popular') : null;
            $paid = Input::has('paid') ? Input::get('paid') : null;

            if(isset($free)){
                $query-> where('price','<=', '0');
            }

            if(isset($popular)){
                $query-> where('popular','=', $popular);
            }

            if(isset($paid)){
                $query-> where('price','>', '0');
            }

        })->paginate(24);

any idea how to achieve this ?

so did we get pagination with chunk ?

Thanks for help it woks the only remaining part is how i get previous nest pagination link with our above query

I guess this will worked.

And who i use paginate with this above query ?

on my blade i write

@foreach ($categories as $chunk)
					<div class="row mb-4">
						@foreach ($chunk as $category)

							@if($category->products->count() > 0)

								<div class="col-md-3">
			                        <div class="silder-item">
										@foreach($category->products as $product)

											{{$product->product_name }}

										@endforeach
									</div>
									
								</div>

							@endif

						@endforeach
					</div>
				@endforeach
						

this works fine how ever the issue is row and column breaks like below in html image i don't know.

https://ibb.co/nnQ6djF

first row have 4 columns then empty row ? why this ?

Do you have any idea ?

@tykus Thanks,

in the most inner loop where we have

@foreach ($category->products as $product)

we get

Illuminate\Database\Eloquent\Collection Object
(
    [items:protected] => Array
        (
            [0] => App\Product Object
                (

display correct but loop disturb i need to get only 8 items if available so if i use array_chunk it will give error

thank for your help

I have relationship many to many between products & categories.

In my Product Model

public function categories() {
    	return $this->belongsToMany(Category::class, 'category_product');
    }

In my Category Model

 public function products() {
		return $this->belongsToMany(Product::class, 'category_product');
	}

so what i try to get is display category with products just like below image. https://ibb.co/vZy9HDz

each how have 4 categories and then each category display product like in image 2 rows with 4 product each.

in my controller i fetch category with product like below

        $categories = Category::with('products')->get();

Thanks for help in advance

so instead of this

$location = public_path('images/'.$filename);

here is the trick

$location = 'images/'.$filename;

this will work for me

so instead of this

$location = public_path('images/'.$filename);

here is the trick

$location = 'images/'.$filename;

this will work for me

thanks, but still issue

Can't write image data to path (/home/motifsol/Laravel/public_html/images/1587619043.png)

Hi

I save product image on my local with below code and all works fine.

$image = $request->file('product_image');
            $filename = time() . '.'. $image->getClientOriginalExtension();
            $location = public_path('images/'.$filename);
            Image::make($image)->save($location);
            $product->freature_image = $filename;

But when i live the app to Cpanel it gives me error. I know there must be a path error as all public folder items are in Public_html and all other are in Laravel folder which is also in root but can't understand how to fix it.

Can't write image data to path (/home/motifsol/Laravel/public/images/1587584786.png)

Regards

Yes this did the trick <3

if(isset($category)) {
                $query-> where('categories.id', '=', $category);
            }

still not working

here is category model

return $this->belongsToMany(Product::class, 'category_product');

here is my product model

return $this->belongsToMany(Category::class, 'category_product');

i just need to filter product with category id

i changed but still get the same error

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'categories.id' in 'where clause' (SQL: select count(*) as aggregate from `products` where (`categories`.`id` = 1))

i have relationship in product & category many to many with pivot table i was try to filter product with category like below

$products = Product::where(function($query){

$category = Input::has('filtercategory') ? Input::get('filtercategory') : null;

if(isset($category)) {
      $query-> where('category.id', '=', $category);
}

})->paginate(24);

but i have this below error can any one help

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'category.id' in 'where clause' (SQL: select count(*) as aggregate from `products` where (`category`.`id` = 1))

Query filter not working i just use filters but when i set query without filter like below it works but in second case i add the filter but its throw 500 why please help.

This works in first case return all products

$products = Product::where(function($query){
            
})->get();

echo json_encode($products);

But when i try to enter filter by price free or paid it return 500 like below

	
$filterValues = array();
parse_str($request->formData, $filterValues);

$products = Product::where(function($query){

	$free = isset( $filterValues['free'] ) ? 'yes' : null;
	if(isset($free) ){
             $query->orwhere('price','<=','0');
        }
            
})->get();

echo json_encode($products);