[ 'sql' => [ 1 => 'SELECT u0_.email AS email_0, u0_.roles AS roles_1, u0_.is_active AS is_active_2, u0_.first_name AS first_name_3, u0_.last_name AS last_name_4, u0_.password AS password_5, u0_.language AS language_6, u0_.function AS function_7, u0_.title AS title_8, u0_.mobile AS mobile_9, u0_.phone AS phone_10, u0_.has_agreed_on_terms_and_conditions AS has_agreed_on_terms_and_conditions_11, u0_.has_agreed_on AS has_agreed_on_12, u0_.created_at AS created_at_13, u0_.updated_at AS updated_at_14, u0_.created_by AS created_by_15, u0_.updated_by AS updated_by_16, u0_.deleted_at AS deleted_at_17, u0_.id AS id_18, u0_.uuid AS uuid_19, u0_.burncenter_id AS burncenter_id_20 FROM user u0_ WHERE (u0_.is_active = ? AND u0_.email IS NOT NULL AND u0_.email <> ? AND ((u0_.roles LIKE ? OR u0_.roles LIKE ?))) AND ((u0_.deleted_at IS NULL OR u0_.deleted_at > CURRENT_TIMESTAMP)) ORDER BY u0_.id DESC', ], ], 'stdClass' => [ 'aliasMap' => [ 2 => [ 't' => 'App\\RegBurns\\Domain\\Model\\User\\User', ], ], 'fieldMappings' => [ 2 => [ 'email_0' => 'email', 'roles_1' => 'roles', 'is_active_2' => 'isActive', 'first_name_3' => 'firstName', 'last_name_4' => 'lastName', 'password_5' => 'password', 'language_6' => 'language', 'function_7' => 'function', 'title_8' => 'title', 'mobile_9' => 'mobile', 'phone_10' => 'phone', 'has_agreed_on_terms_and_conditions_11' => 'hasAgreedOnTermsAndConditions', 'has_agreed_on_12' => 'hasAgreedOn', 'created_at_13' => 'createdAt', 'updated_at_14' => 'updatedAt', 'created_by_15' => 'createdBy', 'updated_by_16' => 'updatedBy', 'deleted_at_17' => 'deletedAt', 'id_18' => 'id', 'uuid_19' => 'uuid', ], ], 'columnAliasMappings' => [ 2 => [ 'App\\RegBurns\\Domain\\Model\\User\\User' => [ 't' => [ 'email' => 'email_0', 'roles' => 'roles_1', 'isActive' => 'is_active_2', 'firstName' => 'first_name_3', 'lastName' => 'last_name_4', 'password' => 'password_5', 'language' => 'language_6', 'function' => 'function_7', 'title' => 'title_8', 'mobile' => 'mobile_9', 'phone' => 'phone_10', 'hasAgreedOnTermsAndConditions' => 'has_agreed_on_terms_and_conditions_11', 'hasAgreedOn' => 'has_agreed_on_12', 'createdAt' => 'created_at_13', 'updatedAt' => 'updated_at_14', 'createdBy' => 'created_by_15', 'updatedBy' => 'updated_by_16', 'deletedAt' => 'deleted_at_17', 'id' => 'id_18', 'uuid' => 'uuid_19', ], ], ], ], 'typeMappings' => [ 2 => [ 'burncenter_id_20' => 'integer', ], ], 'entityMappings' => [ 2 => [ 't' => null, ], ], 'metaMappings' => [ 2 => [ 'burncenter_id_20' => 'burncenter_id', ], ], 'columnOwnerMap' => [ 2 => [ 'email_0' => 't', 'roles_1' => 't', 'is_active_2' => 't', 'first_name_3' => 't', 'last_name_4' => 't', 'password_5' => 't', 'language_6' => 't', 'function_7' => 't', 'title_8' => 't', 'mobile_9' => 't', 'phone_10' => 't', 'has_agreed_on_terms_and_conditions_11' => 't', 'has_agreed_on_12' => 't', 'created_at_13' => 't', 'updated_at_14' => 't', 'created_by_15' => 't', 'updated_by_16' => 't', 'deleted_at_17' => 't', 'id_18' => 't', 'uuid_19' => 't', 'burncenter_id_20' => 't', ], ], 'declaringClasses' => [ 2 => [ 'email_0' => 'App\\RegBurns\\Domain\\Model\\User\\User', 'roles_1' => 'App\\RegBurns\\Domain\\Model\\User\\User', 'is_active_2' => 'App\\RegBurns\\Domain\\Model\\User\\User', 'first_name_3' => 'App\\RegBurns\\Domain\\Model\\User\\User', 'last_name_4' => 'App\\RegBurns\\Domain\\Model\\User\\User', 'password_5' => 'App\\RegBurns\\Domain\\Model\\User\\User', 'language_6' => 'App\\RegBurns\\Domain\\Model\\User\\User', 'function_7' => 'App\\RegBurns\\Domain\\Model\\User\\User', 'title_8' => 'App\\RegBurns\\Domain\\Model\\User\\User', 'mobile_9' => 'App\\RegBurns\\Domain\\Model\\User\\User', 'phone_10' => 'App\\RegBurns\\Domain\\Model\\User\\User', 'has_agreed_on_terms_and_conditions_11' => 'App\\RegBurns\\Domain\\Model\\User\\User', 'has_agreed_on_12' => 'App\\RegBurns\\Domain\\Model\\User\\User', 'created_at_13' => 'App\\RegBurns\\Domain\\Model\\User\\User', 'updated_at_14' => 'App\\RegBurns\\Domain\\Model\\User\\User', 'created_by_15' => 'App\\RegBurns\\Domain\\Model\\User\\User', 'updated_by_16' => 'App\\RegBurns\\Domain\\Model\\User\\User', 'deleted_at_17' => 'App\\RegBurns\\Domain\\Model\\User\\User', 'id_18' => 'App\\RegBurns\\Domain\\Model\\User\\User', 'uuid_19' => 'App\\RegBurns\\Domain\\Model\\User\\User', ], ], ], ], $o[0], [ [ "\0".'Doctrine\\ORM\\Query\\ParserResult'."\0".'sqlExecutor' => null, "\0".'Doctrine\\ORM\\Query\\ParserResult'."\0".'sqlFinalizer' => $o[1], "\0".'Doctrine\\ORM\\Query\\ParserResult'."\0".'resultSetMapping' => $o[2], "\0".'Doctrine\\ORM\\Query\\ParserResult'."\0".'parameterMappings' => [ 'isActive' => [ 0, ], 'emptyEmail' => [ 1, ], 'staffRole' => [ 2, ], 'adminRole' => [ 3, ], ], ], ] ); } }];