Forum : Symfony 5 repository et controller

bidule

Hello,

peux tu mettres le code de tes Entity? et tes controllers

PEGANDPHIL

Auteur

Bonsoir, désolé pour ce retour tardif mais boulot oblige !
voici mes deux entités
ENTITE CATEGORY
<?php

namespace App\Entity;

use App\Repository\CategoryRepository;
use Doctrine\Common\Collections\ArrayCollection;
use Doctrine\Common\Collections\Collection;
use Doctrine\ORM\Mapping as ORM;

/**

@ORM\Entity(repositoryClass=CategoryRepository::class)
*/
class Category
{
/**
- @ORM\Id
- @ORM\GeneratedValue
- @ORM\Column(type="integer")
  */
  private $id;
/**
- @ORM\Column(type="string", length=255)
  */
  private $name;
/**
- @ORM\OneToMany(targetEntity=Product::class, mappedBy="category")
  */
  private $products;
/**
- @ORM\Column(type="string", length=255)
  */
  private $subcategory;
public function __construct()
{
$this->products = new ArrayCollection();
$this->subcategories = new ArrayCollection();
}

public function __toString() {
return $this->getName();
}

public function getId(): ?int
{
return $this->id;
}

public function getName(): ?string
{
return $this->name;
}

public function setName(string $name): self
{
$this->name = $name;
```
return $this;
```
}

/**
- @return Collection|Product[]
  */
  public function getProducts(): Collection
  {
  return $this->products;
  }
public function addProduct(Product $product): self
{
if (!$this->products->contains($product)) {
$this->products[] = $product;
$product->setCategory($this);
}
```
return $this;
```
}

public function removeProduct(Product $product): self
{
if ($this->products->removeElement($product)) {
// set the owning side to null (unless already changed)
if ($product->getCategory() === $this) {
$product->setCategory(null);
}
}
```
return $this;
```
}

public function getSubcategory(): ?string
{
return $this->subcategory;
}

public function setSubcategory(string $subcategory): self
{
$this->subcategory = $subcategory;
```
return $this;
```
}

}

ENTITE PRODUCT
<?php

namespace App\Entity;

use App\Repository\ProductRepository;
use Doctrine\ORM\Mapping as ORM;

/**

@ORM\Entity(repositoryClass=ProductRepository::class)
*/
class Product
{
/**
- @ORM\Id
- @ORM\GeneratedValue
- @ORM\Column(type="integer")
  */
  private $id;
/**
- @ORM\Column(type="string", length=255)
  */
  private $name;
/**
- @ORM\Column(type="string", length=255)
  */
  private $slug;
/**
- @ORM\Column(type="string", length=255)
  */
  private $illustration;
/**
- @ORM\Column(type="string", length=255)
  */
  private $subtitle;
/**
- @ORM\Column(type="text")
  */
  private $description;
/**
- @ORM\Column(type="float")
  */
  private $price;
/**
- @ORM\ManyToOne(targetEntity=Category::class, inversedBy="products")
- @ORM\JoinColumn(nullable=false)
  */
  private $category;
/**
- @ORM\Column(type="boolean")
  */
  private $isBest;
public function getId(): ?int
{
return $this->id;
}

public function getName(): ?string
{
return $this->name;
}

public function setName(string $name): self
{
$this->name = $name;
```
return $this;
```
}

public function getSlug(): ?string
{
return $this->slug;
}

public function setSlug(string $slug): self
{
$this->slug = $slug;
```
return $this;
```
}

public function getIllustration(): ?string
{
return $this->illustration;
}

public function setIllustration(string $illustration): self
{
$this->illustration = $illustration;
```
return $this;
```
}

public function getSubtitle(): ?string
{
return $this->subtitle;
}

public function setSubtitle(string $subtitle): self
{
$this->subtitle = $subtitle;
```
return $this;
```
}

public function getDescription(): ?string
{
return $this->description;
}

public function setDescription(string $description): self
{
$this->description = $description;
```
return $this;
```
}

public function getPrice(): ?float
{
return $this->price;
}

public function setPrice(float $price): self
{
$this->price = $price;
```
return $this;
```
}

public function getCategory(): ?Category
{
return $this->category;
}

public function setCategory(?Category $category): self
{
$this->category = $category;
```
return $this;
```
}

public function getIsBest(): ?bool
{
return $this->isBest;
}

public function setIsBest(bool $isBest): self
{
$this->isBest = $isBest;
```
return $this;
```
}

}

CONTROLLER

<?php

namespace App\Controller;

use App\Classe\Search;
use App\Entity\Product;
use App\Form\SearchType;
use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
use Doctrine\ORM\EntityManagerInterface;
use Symfony\Component\HttpFoundation\Request;
use Symfony\Component\Routing\Annotation\Route;

class ProductController extends AbstractController
{
private $entityManager;

public function __construct(EntityManagerInterface $entityManager)
{
    $this->entityManager = $entityManager;  
}

/**
 * @Route("/nos-produits", name="products")
 */
public function index(Request $request)
{

        $products = $this->entityManager->getRepository(Product::class)->find($id);
    }

    return $this->render('product/index.html.twig', [
        'products' => $products
    ]);
}

PEGANDPHIL

Auteur

et voici ma requete dans le repository

public function findProductWithCategory($category_id)
{
$qb = $this->createQueryBuilder('p')
->select('c', 'p')
->join('p.category', 'c')
->andWhere('c.id = :category_id)')
->setParameter('category_id', $category_id);
return $qb->getQuery()->getResult();
}

PEGANDPHIL

Auteur

Finalement, j'ai réussi . merci pour votre retour.

Symfony 5 repository et controller

4 réponses