@foreach($products as $product) @endforeach
vendor brand slug title short descripton regular whole buying dis_type dis_price qnty thumbnail poit status reach type gallery categories sub_cat mini_cat extra_cat colors atrributes
{{$product->user_id}} {{$product->brand_id}} {{$product->slug}} {{$product->title}} {{$product->short_description}} {{$product->full_description}} {{$product->regular_price}} {{$product->whole_price}} {{$product->buying_price}} {{$product->dis_type}} {{$product->discount_price}} {{$product->quantity}} {{$product->image}} {{$product->point}} {{$product->reach}} {{$product->status}} {{$product->type}} @php $images=DB::table('product_images')->where('product_id',$product->id)->get(); $i=[]; foreach($images as $img){ $i[]= $img->name; } echo json_encode($i); @endphp @php $cats=DB::table('category_product')->where('product_id',$product->id)->get(); $cid=[]; foreach($cats as $cat){ $cid[]= $cat->category_id; } echo json_encode($cid); @endphp @php $scats=DB::table('product_sub_category')->where('product_id',$product->id)->get(); $scid=[]; foreach($scats as $scat){ $scid[]= $scat->sub_category_id; } echo json_encode($scid); @endphp @php $mcats=DB::table('mini_category_product')->where('product_id',$product->id)->get(); $mcid=[]; foreach($mcats as $mcat){ $mcid[]= $mcat->mini_category_id; } echo json_encode($mcid); @endphp @php $ecats=DB::table('extra_mini_category_product')->where('product_id',$product->id)->get(); $ecid=[]; foreach($ecats as $ecat){ $ecid[]= $ecat->extra_mini_category_id; } echo json_encode($ecid); @endphp @php $colors=DB::table('color_product')->where('product_id',$product->id)->get(); $cl=[]; foreach($colors as $color){ $cl[]= ['vid'=>$color->color_id,'price'=>$color->price,'qnty'=>$color->qnty]; } echo json_encode($cl); @endphp @php $atri=DB::table('attribute_product')->where('product_id',$product->id)->get(); $at=[]; foreach($atri as $attr){ $at[]= ['vid'=>$attr->attribute_value_id,'price'=>$attr->price,'qnty'=>$attr->qnty]; } echo json_encode($at); @endphp