Category: Symfony

$queryBuilder = $this->createQueryBuilder('account_event');
        $queryBuilder
            ->select('account_event.id AS AE_id', 'IDENTITY(account_event.event) AS event_id', 'account_event.dueDate as due_date', 'IDENTITY(account_event.account) AS account_id')
            ->where(
                $queryBuilder->expr()->in(
                    'account_event.id',
                    $this->createQueryBuilder('subquery_repository')
                        ->select('MAX(ae2.id)')
                        ->from(AccountEvent::class,'ae2')
                        ->andWhere('ae2.event IN (:events)')
                        ->andWhere('ae2.account IN (:accounts)')
                        ->andWhere('ae2.dueDate > DATE(:date)')
                        ->groupBy('ae2.account')
                        ->getDQL()
                )
            )
            ->setParameter('events', $events)
            ->setParameter('accounts', $accounts)
            ->setParameter('date', $date->format('Y-m-d'))
        ;

Simple example how to convert Array to XML:

public function toXML() {
    $array = [
      'fields' => [
        'field' => [
          '@name' => 'name',
          '@test' => 'test',
          '#' => 12345
        ]
      ]
    ];

    $xmlEncoder = new XmlEncoder();

    $response = new Response();
    $response->setContent($xmlEncoder->encode($array, 'xml'));
    $response->headers->set('Content-Type', 'xml');
    return $response;
  }

This task is really simple. You can achieve it from Kernel.php, getCacheDir method:

 public function getCacheDir()
    {
//        return $this->getProjectDir().'/var/cache/'.$this->environment; //Any location on your server
        return '/dev/shm/'.$this->environment; //This will cache in RAM
    }

Install redis server:

sudo apt-get install redis-server

Copy backup configuration file:

sudo cp /etc/redis/redis.conf /etc/redis/redis.conf.default

Check if redis is installed correctly by:

redis-cli

Continue reading “Use Redis in Symfony”

Always create service interface for your service. This way you will have better structured code and phpunit testing will be real pleasure.
Also use dependency injection for your repositories in the service.

Service Interface Example

interface UserServiceInterface{
  public function getUsername();
  public function viewAll();
}

Service Example

class UserService implements UserServiceInterface
{

  private $entityManager;
  private $userRepository;

  public function __construct(EntityManager $entityManager, UserRepository $userRepository)
  {
    $this->entityManager = $entityManager;
    $this->userRepository = $userRepository;
  }

  public function viewAll()
  {
    return $this->userRepository->findAll();
  }
}

Repository Example

class UserRepository extends \Doctrine\ORM\EntityRepository
{
  public function __construct(EntityManager $em, Mapping\ClassMetadata $metadata = null)
  {
    parent::__construct(
      $em,
      $metadata == null ?
      new Mapping\ClassMetadata(User::class) :
      $metadata
    );
  }
}

There are several way to make authorization on your site with Symfony.
First is in your security.yml on the same level as firewalls tag:

access_control:
        - { path: ^/admin, roles: ROLE_USER }

This will block all users that don’t have ‘ROLE_USER’ to admin page.

Second option is to use Controller. Inside Method insert:

        if(!$this->get('security.authorization_checker')->isGranted('ROLE_ADMIN')){
            throw $this->createAccessDeniedException('GET OUT!');
        }

Or like this:

$this->denyAccessUnlessGranted('ROLE_ADMIN');

This will deny access to all users that don’t have ‘ROLE_ADMIN’ to this method.

You can also use annotations:

/**
* @Security("is_granted('ROLE_ADMIN')")
*/

Annotations also work if you add them to the Class. So they will block all users that don’t have ‘ROLE_ADMIN’ to this class.

Continue reading “Symfony Security Authorization”