?? GreyFile

?? GreyFile — Mystic File Browser

Current path: home/webdevt/cryptoimpot.fr/module/Application/src/Mapper/

?? Go up: /home/webdevt/cryptoimpot.fr/module/Application/src

?? Editing: ExchangeMapper.php

<?php

namespace Application\Mapper;

use Doctrine\ORM\EntityManager;
use TheSeer\Tokenizer\Exception;
use Laminas\Hydrator\HydratorInterface;
use Laminas\Paginator\Adapter\ArrayAdapter;
use Laminas\Paginator\Paginator;

class ExchangeMapper {

/**
     * @var EntityManager
     */
    protected $em;
    protected $entityClass;
    protected $orderAuthorized;
    protected $orderByAuthorized;

public function __construct(EntityManager $em) {
        $this->em = $em;
        $this->entityClass = 'Application\Entity\Exchange';

$this->orderByAuthorized = array(
            'id',
            'name',
        );

$this->orderAuthorized = array(
            'ASC',
            'DESC'
        );
    }

//    public function findByEmail($email)
//    {
//        $er = $this->em->getRepository($this->entityClass);
//        return $er->findOneBy(array('email' => $email));
//    }

public function findById($id) {
        $er = $this->em->getRepository($this->entityClass);
        return $er->findOneBy(array('id' => $id));
    }

public function findByName($name) {
        $er = $this->em->getRepository($this->entityClass);
        return $er->findOneBy(array('name' => $name));
    }

public function findAllSelectable() {
        $er = $this->em->getRepository($this->entityClass);
        return $er->findBy(['enable' => 1], ['ordre' => 'ASC']);
    }

public function getArrayForSelect() {
//         $er = $this->em->getRepository($this->entityClass);
//         return $er->findBy(['enable' => 1], ['ordre' => 'ASC']);
        $qb = $this->em->getRepository($this->entityClass)->createQueryBuilder('e');
        $qb->where('e.enable = 1')
                ->andWhere('e.selectable = 1')
//                ->orderBy('e.ordre', 'ASC');
                ->orderBy('e.name', 'ASC');
        //$qb->orderBy('e.name', 'ASC');
        $result = $qb->getQuery()
                ->getArrayResult();

$arrayIndexToName = array();
        foreach ($result as $row) {
            $arrayIndexToName[$row['id']] = $row['name'];
        }

return $arrayIndexToName;
    }

public function getList($parameters, $pagination = true) {
        $er = $this->em->getRepository($this->entityClass);
        $query = $er->createQueryBuilder('t');
        // ->andWhere('l.statePublish = :statePublish');
        if (isset($parameters['sort_by'])) {

$sort_by = in_array($parameters['sort_by'], $this->orderByAuthorized) ? $parameters['sort_by'] : 'id';

if (isset($parameters['sort'])) {
                $sort = in_array($parameters['sort'], $this->orderAuthorized) ? $parameters['sort'] : 'DESC';
//                if ($parameters['sort_by'] == 'technologie') {
//                    $query->orderBy('te.technologie', $sort);
//                } else {
//                    $query->orderBy('t.' . $sort_by, $sort);
//                }

//                var_dump($sort_by);
            }
        }

if (isset($parameters['search'])) {
            $search = $parameters['search'];
            $searchList = explode(' ', $search);
            //var_dump($searchList);
            if (is_array($searchList)) {
                //var_dump($searchList);
                $i = 1;
                foreach ($searchList as $searchElement) {
                    $query->orWhere('t.name LIKE ?' . $i)
//                            ->orWhere('t.description LIKE ?' . $i)
//                            ->orWhere('te.technologie LIKE ?' . $i)
                            //->orWhere('l.title LIKE :search')
                            //->setParameter('description', '%' . $search . '%')
                            //->setParameter('brandName', '%' . $search . '%')
                            ->setParameter($i, '%' . $searchElement . '%');
                    $i++;
                }
            } else {
                $query->orWhere('t.name LIKE :search')
//                        ->orWhere('t.description LIKE :search')
//                        ->orWhere('te.technologie LIKE :search')
//                    ->orWhere('r.role LIKE :search')
                        //->orWhere('l.title LIKE :search')
                        //->setParameter('description', '%' . $search . '%')
                        //->setParameter('brandName', '%' . $search . '%')
                        ->setParameter('search', '%' . $search . '%');
            }
        }
        $arrayOfTests = $query->getQuery()
                ->getResult();
        //->andWhere('u.state = :state')
        // ->setParameter('state', 1)

if ($pagination === true) {
            $paginatorAdapter = new ArrayAdapter($arrayOfTests);
            return new Paginator($paginatorAdapter);
        } else {
            return $arrayOfTests;
        }
    }

public function insert($entity, $tableName = null, HydratorInterface $hydrator = null) {
        return $this->persist($entity);
    }

public function update($entity, $where = null, $tableName = null, HydratorInterface $hydrator = null) {
        return $this->persist($entity);
    }

public function delete($entity, $where = null, $tableName = null, HydratorInterface $hydrator = null) {
        try {
            $this->em->remove($entity);
            $this->em->flush();
            return true;
        } catch (Exception $e) {
            return false;
        }
    }

protected function persist($entity) {
        $this->em->persist($entity);
        $this->em->flush();
        return $entity;
    }

}

?? CoursDeviseMapper.php | ?? Edit | ??? Delete
?? DeviseBitfinexMapper.php | ?? Edit | ??? Delete
?? DeviseBitstampMapper.php | ?? Edit | ??? Delete
?? DeviseBittrexMapper.php | ?? Edit | ??? Delete
?? DeviseKrakenMapper.php | ?? Edit | ??? Delete
?? DeviseMapper.php | ?? Edit | ??? Delete
?? ExchangeMapper.php | ?? Edit | ??? Delete
?? ImportMapper.php | ?? Edit | ??? Delete
?? LedgioMapper.php | ?? Edit | ??? Delete
?? MessageMapper.php | ?? Edit | ??? Delete
?? ReportMapper.php | ?? Edit | ??? Delete
?? SourceMapper.php | ?? Edit | ??? Delete
?? UserExchangeLinkerMapper.php | ?? Edit | ??? Delete