<?php
namespace Majax\PortalBundle\Admin;

use Majax\PortalBundle\Builder\SiteListBuilder;
use Sonata\AdminBundle\Admin\Admin;
use Sonata\AdminBundle\Form\FormMapper;
use Sonata\AdminBundle\Datagrid\DatagridMapper;
use Sonata\AdminBundle\Datagrid\ListMapper;
use Sonata\AdminBundle\Show\ShowMapper;

class UserAdmin extends Admin
{
    /** @var \Majax\PortalBundle\Builder\SiteListBuilder */
    private $site_list_builder;

    public function setSiteListBuilder(SiteListBuilder $slb)
    {
        $this->site_list_builder = $slb;
    }

    public function configureShowFields(ShowMapper $showMapper)
    {
        $showMapper
            ->add('username')
            ->add('email')
        ;
    }

    public function configureFormFields(FormMapper $formMapper)
    {
        $formMapper
            ->with('General')
                ->add('username')
                ->add('email')
            ->end()
        ;
    }

    public function configureListFields(ListMapper $listMapper)
    {
        $listMapper
            ->addIdentifier('username')
            ->add('email')
            ->add('lastLogin')
        ;
    }

    public function configureDatagridFilters(DatagridMapper $datagridMapper)
    {
        $datagridMapper
            ->add('username')
            ->add('email')
            ->add('applied_sites', 'callback',
                  array(
                      'filter_field_options' => array('choices' => $this->site_list_builder->getList(), 'expanded' => false, 'multiple' => true),
                      'filter_options' => array(
                          'filter' => array($this, 'handleSitesFilter'),
                          'type' => 'choice',
                          'multiple' => 'true',
                      )
                )
            )
        ;
    }

    public function handleSitesFilter($queryBuilder, $alias, $field, $value)
    {
        if ($value == null)
            return;
        
        $queryBuilder->leftJoin('o.sites', 's');
        $queryBuilder->andWhere($queryBuilder->expr()->in(sprintf('%s.%s', 's', 'id'), $value));
    }

}