OpencachingDeutschland / oc-server3

     * @return Response

     * @Route("/dbQueries1/{days}", name="support_db_queries_1")

     */

    public function executeSQL_caches_old_reg_date(int $days = 31) // List caches from users whose registration date is not older than x days.

    : Response

    {

        $formSearch = $this->createForm(SupportSearchCaches::class);

        $qb = $this->connection->createQueryBuilder();

        $qb->select('caches.name', 'user.username', 'user.date_created', 'user.last_login')

            ->from('caches')

            ->innerJoin('caches', 'user', 'user', 'caches.user_id = user.user_id')

            ->where('user.date_created > now() - interval :searchTerm DAY')

            ->andWhere('caches.user_id = user.user_id')

            ->setParameters(['searchTerm' => $days])

            ->orderBy('date_created', 'DESC');

        return $this->render(

            'backend/support/databaseQueries.html.twig', [

                                                           'supportCachesForm' => $formSearch->createView(),

                                                           'suppSQLquery1' => $qb->execute()->fetchAll()

                                                       ]

        );

    }

    /**

     * @param int $days

     * @return Response

     * @Route("/dbQueries4", name="support_db_queries_4")

     */

    public function executeSQL_caches_old_login_date(

    ) // List (non-archived, non-locked) caches from users whose last login date is older than one year.

    : Response

    {

        $formSearch = $this->createForm(SupportSearchCaches::class);

        $qb = $this->connection->createQueryBuilder();

        $qb->select('caches.name', 'caches.cache_id', 'caches.status', 'user.username', 'user.last_login')

            ->from('caches')

            ->innerJoin('caches', 'user', 'user', 'caches.user_id = user.user_id')

            ->where('user.last_login < now() - interval :searchTerm YEAR')

            ->andWhere('caches.status <= 2')

            ->andWhere(('caches.user_id = user.user_id'))

            ->setParameters(['searchTerm' => 1])

            ->orderBy('user.last_login', 'ASC');

        return $this->render(

            'backend/support/databaseQueries.html.twig', [

                                                           'supportCachesForm' => $formSearch->createView(),

                                                           'suppSQLquery4' => $qb->execute()->fetchAll()

                                                       ]

        );

    }

    /**

     * @param string $what