Dev-Int / glsr

server/src/Administration/Infrastructure/Finders/Doctrine/DoctrineCompanyFinder.php

Upper-Lower-Casing +2 added lines, -2 removed lines

@@ -50,7 +50,7 @@ 
     company.slug as slug
 FROM company
 WHERE uuid = :uuid
-SQL;
+sql;
         $result = $this->connection->executeQuery($query, ['uuid' => $uuid])->fetchOne();
 
         return new CompanyModel(
@@ -90,7 +90,7 @@ 
     company.slug as slug
 FROM company
 ORDER BY name
-SQL;
+sql;
         $result = $this->connection->executeQuery($query)->fetchAllAssociative();
 
         return new Companies(

server/src/Administration/Infrastructure/Finders/Doctrine/DoctrineUserFinder.php

Upper-Lower-Casing +3 added lines, -3 removed lines

@@ -43,7 +43,7 @@ 
     user.roles as roles
 FROM user
 WHERE username = :username
-SQL;
+sql;
         $result = $this->connection->executeQuery($query, ['username' => $username])->fetchAssociative();
 
         if (false === $result) {
@@ -72,7 +72,7 @@ 
     user.roles as roles
 FROM user
 WHERE uuid = :uuid
-SQL;
+sql;
         $result = $this->connection->executeQuery($query, ['uuid' => $uuid])->fetchAssociative();
 
         if (false === $result) {
@@ -100,7 +100,7 @@ 
     user.email as email,
     user.roles as roles
 FROM user
-SQL;
+sql;
         $result = $this->connection->executeQuery($query)->fetchAllAssociative();
 
         return new Users(

server/src/Administration/Infrastructure/Finders/Doctrine/DoctrineSettingsFinder.php

Upper-Lower-Casing +3 added lines, -3 removed lines

@@ -39,7 +39,7 @@ 
     settings.currency as currency,
     settings.locale as locale
 FROM settings
-SQL;
+sql;
         $result = $this->connection->executeQuery($query)->fetchAssociative();
 
         if (false !== $result) {
@@ -61,7 +61,7 @@ 
     settings.locale as locale
 FROM settings
 WHERE locale = :locale
-SQL;
+sql;
         $result = $this->connection->executeQuery($query, ['locale' => $locale])->fetchAssociative();
 
         if (false !== $result) {
@@ -83,7 +83,7 @@ 
     settings.locale as locale
 FROM settings
 WHERE currency = :currency
-SQL;
+sql;
         $result = $this->connection->executeQuery($query, ['currency' => $currency])->fetchAssociative();
 
         if (false !== $result) {

server/src/Administration/Infrastructure/Persistence/DoctrineOrm/Repositories/DoctrineUserRepository.php

Upper-Lower-Casing +3 added lines, -3 removed lines

@@ -82,7 +82,7 @@ 
     user.roles as roles
 FROM user
 WHERE uuid = :uuid
-SQL;
+sql;
         $result = $this->connection->executeQuery($query, ['uuid' => $uuid])->fetchAssociative();
 
         return User::create(
@@ -102,7 +102,7 @@ 
         $query = <<<'SQL'
 SELECT username FROM user
 WHERE username = :username
-SQL;
+sql;
         $statement = $this->connection->executeQuery($query, ['username' => $username])->fetchAssociative();
 
         return false !== $statement;
@@ -116,7 +116,7 @@ 
         $query = <<<'SQL'
 SELECT email FROM user
 WHERE email = :email
-SQL;
+sql;
         $statement = $this->connection->executeQuery($query, ['email' => $email])->fetchAssociative();
 
         return false !== $statement;

server/src/Administration/Infrastructure/Persistence/DoctrineOrm/Repositories/DoctrineSettingsRepository.php

Upper-Lower-Casing +2 added lines, -2 removed lines

@@ -71,7 +71,7 @@ 
     settings.locale as locale
 FROM settings
 WHERE uuid = :uuid
-SQL;
+sql;
         $result = $this->connection->executeQuery($query, ['uuid' => $uuid])->fetchAssociative();
 
         return Settings::create(
@@ -88,7 +88,7 @@ 
     {
         $query = <<<'SQL'
 SELECT uuid FROM settings
-SQL;
+sql;
 
         $statement = $this->connection->executeQuery($query)->fetchAssociative();
 

server/src/Administration/Infrastructure/Persistence/DoctrineOrm/Repositories/DoctrineCompanyRepository.php

Upper-Lower-Casing +3 added lines, -3 removed lines

@@ -40,7 +40,7 @@ 
         $query = <<<'SQL'
 SELECT uuid FROM company
 WHERE name = :name
-SQL;
+sql;
         $statement = $this->connection->executeQuery($query, ['name' => $name])->fetchOne();
 
         return !(false === $statement);
@@ -112,7 +112,7 @@ 
     company.slug as slug
 FROM company
 WHERE uuid = :uuid
-SQL;
+sql;
         $result = $this->connection->executeQuery($query, ['uuid' => $uuid])->fetchAssociative();
 
         return Company::create(
@@ -138,7 +138,7 @@ 
     {
         $query = <<<'SQL'
 SELECT uuid FROM company
-SQL;
+sql;
         $statement = $this->connection->executeQuery($query)->fetchOne();
 
         return !(false === $statement);

server/src/Administration/Infrastructure/Persistence/DoctrineOrm/Repositories/DoctrineSupplierRepository.php

Upper-Lower-Casing +2 added lines, -2 removed lines

@@ -42,7 +42,7 @@ 
         $query = <<<'SQL'
 SELECT uuid FROM supplier
 WHERE name = :name
-SQL;
+sql;
         $statement = $this->connection->executeQuery($query, ['name' => $name])->fetchOne();
 
         return !(false === $statement);
@@ -108,7 +108,7 @@ 
 FROM supplier
 JOIN family_log on family_log.uuid = supplier.family_log_id
 WHERE supplier.uuid = :uuid
-SQL;
+sql;
         $result = $this->connection->executeQuery($query, ['uuid' => $uuid])->fetchAssociative();
         if (null === $result) {
             throw new SupplierNotFound();

server/src/Administration/Infrastructure/Finders/Doctrine/DoctrineFamilyLogFinder.php

Upper-Lower-Casing +1 added lines, -1 removed lines

@@ -66,7 +66,7 @@
 )
 SELECT DISTINCT uuid, parent_id, label, level, path, slug FROM cte
 ORDER BY level DESC
-SQL;
+sql;
 
         $results = $this->connection->executeQuery($query)->fetchAllAssociative();
 

server/src/Administration/Infrastructure/Finders/Doctrine/DoctrineSupplierFinder.php

Upper-Lower-Casing +2 added lines, -2 removed lines

@@ -57,7 +57,7 @@ 
     supplier.slug as slug
 FROM supplier
 WHERE uuid = :uuid
-SQL;
+sql;
         $result = $this->connection->executeQuery($query, ['uuid' => $uuid])->fetchAssociative();
 
         if (null === $result) {
@@ -114,7 +114,7 @@ 
 FROM supplier
 INNER JOIN family_log ON supplier.family_log_id = family_log.uuid
 WHERE active = 1
-SQL;
+sql;
         $results = $this->connection->executeQuery($query)->fetchAllAssociative();
 
         return new Suppliers(