Providing data from database to data provider services

Hello there,
am relatively new to orocommerce application and not so conversant with symfony.

I need to create a service that retrieves product data from the database and sends to my layout.
Pls, how do I go about it?
Is there an orocommerce service that already exists that I can use?

Topic

[mlukaszewiczParticipant]

Hello,

the get information from DB you should use Repository, in your case it would be ProductRepository.
Please check symfony doc: https://symfony.com/doc/2.8/doctrine.html#fetching-objects-from-the-database to get more info how to use Repositories.

Best,
Martin

[nellybaz10Participant]

OKay, thank you.
One more thing. If I fetch product image and get a value like this 38dns9xnsu.jpeg,
how do I use the image name to display it in the tag.
becasue I did somthing like this

PHP

<img src="{{ asset('public/images/' ~ image_url) }}" />

1	<img src="{{ asset('public/images/' ~ image_url) }}" />

and its not working.

Thanks in advance

• This reply was modified 5 years, 5 months ago by  nellybaz10.
• This reply was modified 5 years, 5 months ago by  nellybaz10.

[nellybaz10Participant]

hello, pls am still hoping for the answers to my question.
Thanks

[MichaelKeymaster]

It depends on what and how you are trying to do, but if you have chosen the approach similar to the default OroCommerce theme, you can use the existing macros from OroProductBundle::image_macros.html.twig to do it for you. For example, here is how it is done in the default theme:

{% import 'OroProductBundle::image_macros.html.twig' as Image %} {% set productImage = product.imagesByType('listing').first.image|default(null) %} {% set productImageUrl = Image.url(productImage, 'product_small') %}

1 2 3 4

{% import 'OroProductBundle::image_macros.html.twig' as Image %}       {% set productImage = product.imagesByType('listing').first.image|default(null) %}     {% set productImageUrl = Image.url(productImage, 'product_small') %}

[nellybaz10Participant]

Thanks a lot.
Is there an alternative way to do that?
This is my code

PHP

/** * @Route("/product/{id}", name="product") */ public function productAction($id) { $em = $this->getDoctrine()->getManager(); $entity = $em->getRepository('OroProductBundle:Product')->find($id); return $this->render('AppBundle:Product:product.html.twig',array('product'=>$entity) ); } }

1 2 3 4 5 6 7 8 9 10 11 12 13 14

/**      * @Route("/product/{id}", name="product")      */     public function productAction($id)     {           $em = $this->getDoctrine()->getManager();         $entity = $em->getRepository('OroProductBundle:Product')->find($id);             return $this->render('AppBundle:Product:product.html.twig',array('product'=>$entity) );     }   }

And this is my twig file

PHP

{% extends 'AppBundle:Default:index.html.twig' %} {% block body %} {{image}} {% for item in product.images %} <img src="http://localhost:8006/app_dev.php/media/cache/attachment/filter/1/1/category_medium/~item" /> {%endfor%} {% endblock %}

1 2 3 4 5 6 7 8 9 10 11 12

{% extends 'AppBundle:Default:index.html.twig' %}     {% block body %} {{image}} {% for item in product.images %}           <img src="http://localhost:8006/app_dev.php/media/cache/attachment/filter/1/1/category_medium/~item" />     {%endfor%} {% endblock %}

[nellybaz10Participant]

Hello,
I would really appreciate assistance on this
As they is no guide on docs on how to do this
Thanks

[MichaelKeymaster]

Is there some specific reason you do not want to use the existing macros?
As an alternative way you can probably check what the Twig functions called in these macros do, and reimplement them yourself, but I do not see any benefits to such approach.

[Author]

Replies