z. tutorial2 - MiguelFieira/AMO-HANDBOEK GitHub Wiki

public function ApparatenNogGedemonteerd()
    {
        $queryBuilder = $this->createQueryBuilder('i');
        $queryBuilder  ->innerJoin('App\Entity\Apparaten','a','WITH','i.Apparaat = a.id')
            ->andWhere('i.Ontleed = :val')
            ->setParameter('val', 0)
            ;
           
        return $queryBuilder   ->getQuery() ->Getresult()
        ;
    }

        /**
* @Route("/", name="Ontleed", methods={"POST"})
*/
public function ontleed(Request $request, InnamesApparatenRepository $innamesApparatenRepository): Response {
    if ($this->isGranted('ROLE_ADMIN')) {
                // dd($request);
        return $this->render('innames_apparaten/index.html.twig', [
            'innames_apparatens' => $innamesApparatenRepository->ApparatenNogGedemonteerd()
        ]);
    } else 
        {
        $Gedemonteerd = "Niet beschikbaar!";
        return $this->render('innames_apparaten/index.html.twig', [
            'innames_apparatens' => $innamesApparatenRepository->findAll(),
            'error' => $Gedemonteerd,
        ]);
    } 
} 

{% if error is defined %}
<script>alert("{{error}}")</script>
{% else %}
<form action="{{path('Ontleed')}}"method="post">
        <input type="hidden" value="O">
        <input type="submit"  name="Ontleed" value="Apparaten nog niet gedemonteerd"/>
</form>
{% endif %}

public function IngenomenApparaten()
    {
        $queryBuilder = $this->createQueryBuilder('a');
        $queryBuilder  ->innerJoin('App\Entity\InnamesApparaten','i','WITH','i.Apparaat = a.id')
                       ->innerJoin('App\Entity\Innames','ii','WITH','ii.id = i.Inname')
            ->andWhere('ii.Tijdstip >= :startDate')
            ->setParameter('startDate', new \DateTime('-180 days'))
            ->orderBy('a.id', 'ASC')
            ->setMaxResults(6);
           
        return $queryBuilder   ->getQuery() ->Getresult()
        ;
    }

    /**
* @Route("/", name="Tijdstip", methods={"POST"})
*/
public function tijdstip(Request $request, apparatenRepository $apparatenRepository): Response {
    if ($this->isGranted('ROLE_ADMIN')) {
                // dd($request);
       return $this->render('apparaten/index.html.twig', [
            'apparatens' => $apparatenRepository->IngenomenApparaten()
        ]);
    } else {
        $IngenomenApparaten = "Niet beschikbaar!";
        return $this->render('apparaten/index.html.twig', [
            'apparatens' => $apparatenRepository->findAll(),
            'error' => $IngenomenApparaten,
        ]);
    } 
} 

{% if error is defined %}
<script>alert("{{error}}")</script>
{% else %}
<form action="{{path('Tijdstip')}}"method="post">
        <input type="hidden" value="T">
        <input type="submit"  name="Tijdstip" value="Ingenomen Apparaten laatste 6 mnd"/>
</form>
{% endif %}

public function __toString() {
        $id = $this->getId();
        $id = "$id";
        Return $id;
    }