Questions tagged as 'doctrine2'

Tagged questions
1
answer

How to perform this query in dql or querybuilder

How to perform this query on dql or querybuilder ? select m.id, m.nombre, c.id, c.nombre from miembro as m inner join ( select cmi.id_cargo, cmi.id_miembro, cmi.id from cargo__miembro as cmi inner join ( select muc.id as idmiembro,...
asked by 26.06.2018 / 18:50
0
answers

MongoDB createAggregationBuilder with Simultaneous operations

public function inventario(\App\Document\Tecnico $tecnico, $value) { $builder = $this->createAggregationBuilder(); $builder ->hydrate(\App\Document\Inventario::class) ->match() ->field('tecnico')...
asked by 07.06.2018 / 00:13
1
answer

Count the number of records in my BD ManyToMany

I do not know how to explain to me so that they understand me, I even think that I asked the question badly, let's see, I need to know how (I better put examples), I have a reservation table, and a food table, their relationship is much To much,...
asked by 05.06.2018 / 21:05
0
answers

"Select from (Select" Subquery a doctrine dql

I have made a query to the database to get the actual availability of the rooms of several hotels but when trying to make the query with doctrine in symfony 3.4, I get an error. This is the query: SELECT (CASE WHEN count(_days) > 0 THEN...
asked by 08.06.2018 / 10:39
0
answers

Inner join and left join Doctrine symfony

Hi, I want to do an inner join with a left join to join the data I need from several tables, the normal query works for me, but when I pass it to the doctrine format I do not know how to accommodate the syntax SELECT c.id,c.'name',c.'st...
asked by 13.03.2018 / 18:18
0
answers

Login with doctrine in Laravel 5.6

Hi, I've been working a bit with doctrine and laravel but small things, but I've run into a problem, how can I implement a functional login with doctrine in my laravel 5.6 project? For what I researched with the commands php artisan migra...
asked by 27.02.2018 / 21:47
0
answers

Symfony3 makes me logout without me asking

Well, I have this security.yml # To get started with security, check out the documentation: # https://symfony.com/doc/current/security.html security: encoders: BackendBundle\Entity\.....: algorithm: bcrypt cost: 4 # https...
asked by 15.02.2018 / 11:56
0
answers

Entity from view with float as ID

I have the following model: use Doctrine\ORM\Mapping as ORM; /** * SignosGuion * * @ORM\Entity * @ORM\Table(name="vw_signos_guion") */ class SignosGuion { /** * @var float * * @ORM\Column(name="id", type="float", nulla...
asked by 14.02.2018 / 17:57
0
answers

Problem so that a user does not exit in OneToMany query if a condition occurs

I have a problem with an sql query that I am doing using doctrine in symfony I have two related tables, one of users and one of actions performed by the user, these tables are related from one to many, a user can do many actions. I am trying...
asked by 21.01.2018 / 21:33
3
answers

JMSSerializer Bundle does not serialize relationships

Controller: public function newUserAction(Request $request) { $errores = array(); $usuario = new Usuario(); $foto = $request->files->get('foto'); $email = $request->request->get('email'); $username = $request-&...
asked by 12.01.2018 / 10:14