Check if there are active products in this brand, if not, show brand

Question

I have two tables in my bank, adm_marca and adm_produto, at the moment, is showing in my view all brands, regardless if there are active products or not, I need to show only brands that do not have active products. How to do this check?

My view:

  <?php foreach ($marcas as $marca) { ?>
                            <li><a href="<?php echo base_url("marca/" . $marca->getSlug()); ?>"><?php echo $marca->getNome(); ?></a></li>
                        <?php } ?>

Marca_model:

  public function marcas(){
   return $this->doctrine->em->getRepository("Entity\AdmMarca")->findBy(array('status'=> 1));   
}  

Answer 1

you can leverage this existing "brands" method, or create a separate one for active products only. In both cases, just add the Doctrine rule:

$qb->andWhere($qb->expr()->not($qb->expr()->exists($sub->getDQL())));

Reference: https://www.doctrine-project.org/projects/doctrine-orm/en/2.7/reference/query-builder.html