Dev-Int / glsr

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(

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

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

@@ -65,7 +65,7 @@ 
 )
 SELECT DISTINCT uuid, parent_id, label, level, path, slug FROM cte
 ORDER BY level
-SQL;
+sql;
 
         // Get parents
         $result = $this->connection->executeQuery($query, ['uuid' => $uuid])->fetchAllAssociative();
@@ -95,7 +95,7 @@ 
 )
 SELECT DISTINCT uuid, parent_id, label, level, path, slug FROM cte
 ORDER BY level
-SQL;
+sql;
         // Get children
         $result = $this->connection->executeQuery($query, ['uuid' => $uuid])->fetchAllAssociative();