@@ -94,7 +94,7 @@ |
||
| 94 | 94 | $result = $this->connection->executeQuery($query)->fetchAllAssociative(); |
| 95 | 95 | |
| 96 | 96 | return new Companies( |
| 97 | - ...\array_map(static function (array $company) { |
|
| 97 | + ...\array_map(static function(array $company) { |
|
| 98 | 98 | return new CompanyModel( |
| 99 | 99 | $company['uuid'], |
| 100 | 100 | $company['name'], |
@@ -50,7 +50,7 @@ discard block |
||
| 50 | 50 | company.slug as slug |
| 51 | 51 | FROM company |
| 52 | 52 | WHERE uuid = :uuid |
| 53 | -SQL; |
|
| 53 | +sql; |
|
| 54 | 54 | $result = $this->connection->executeQuery($query, ['uuid' => $uuid])->fetchOne(); |
| 55 | 55 | |
| 56 | 56 | return new CompanyModel( |
@@ -90,7 +90,7 @@ discard block |
||
| 90 | 90 | company.slug as slug |
| 91 | 91 | FROM company |
| 92 | 92 | ORDER BY name |
| 93 | -SQL; |
|
| 93 | +sql; |
|
| 94 | 94 | $result = $this->connection->executeQuery($query)->fetchAllAssociative(); |
| 95 | 95 | |
| 96 | 96 | return new Companies( |
@@ -104,7 +104,7 @@ |
||
| 104 | 104 | $result = $this->connection->executeQuery($query)->fetchAllAssociative(); |
| 105 | 105 | |
| 106 | 106 | return new Users( |
| 107 | - ...\array_map(static function (array $user) { |
|
| 107 | + ...\array_map(static function(array $user) { |
|
| 108 | 108 | return new UserReadModel( |
| 109 | 109 | $user['uuid'], |
| 110 | 110 | $user['username'], |
@@ -43,7 +43,7 @@ discard block |
||
| 43 | 43 | user.roles as roles |
| 44 | 44 | FROM user |
| 45 | 45 | WHERE username = :username |
| 46 | -SQL; |
|
| 46 | +sql; |
|
| 47 | 47 | $result = $this->connection->executeQuery($query, ['username' => $username])->fetchAssociative(); |
| 48 | 48 | |
| 49 | 49 | if (false === $result) { |
@@ -72,7 +72,7 @@ discard block |
||
| 72 | 72 | user.roles as roles |
| 73 | 73 | FROM user |
| 74 | 74 | WHERE uuid = :uuid |
| 75 | -SQL; |
|
| 75 | +sql; |
|
| 76 | 76 | $result = $this->connection->executeQuery($query, ['uuid' => $uuid])->fetchAssociative(); |
| 77 | 77 | |
| 78 | 78 | if (false === $result) { |
@@ -100,7 +100,7 @@ discard block |
||
| 100 | 100 | user.email as email, |
| 101 | 101 | user.roles as roles |
| 102 | 102 | FROM user |
| 103 | -SQL; |
|
| 103 | +sql; |
|
| 104 | 104 | $result = $this->connection->executeQuery($query)->fetchAllAssociative(); |
| 105 | 105 | |
| 106 | 106 | return new Users( |
@@ -39,7 +39,7 @@ discard block |
||
| 39 | 39 | settings.currency as currency, |
| 40 | 40 | settings.locale as locale |
| 41 | 41 | FROM settings |
| 42 | -SQL; |
|
| 42 | +sql; |
|
| 43 | 43 | $result = $this->connection->executeQuery($query)->fetchAssociative(); |
| 44 | 44 | |
| 45 | 45 | if (false !== $result) { |
@@ -61,7 +61,7 @@ discard block |
||
| 61 | 61 | settings.locale as locale |
| 62 | 62 | FROM settings |
| 63 | 63 | WHERE locale = :locale |
| 64 | -SQL; |
|
| 64 | +sql; |
|
| 65 | 65 | $result = $this->connection->executeQuery($query, ['locale' => $locale])->fetchAssociative(); |
| 66 | 66 | |
| 67 | 67 | if (false !== $result) { |
@@ -83,7 +83,7 @@ discard block |
||
| 83 | 83 | settings.locale as locale |
| 84 | 84 | FROM settings |
| 85 | 85 | WHERE currency = :currency |
| 86 | -SQL; |
|
| 86 | +sql; |
|
| 87 | 87 | $result = $this->connection->executeQuery($query, ['currency' => $currency])->fetchAssociative(); |
| 88 | 88 | |
| 89 | 89 | if (false !== $result) { |
@@ -110,7 +110,7 @@ |
||
| 110 | 110 | $result = $this->connection->executeQuery($query)->fetchAllAssociative(); |
| 111 | 111 | |
| 112 | 112 | return new Suppliers( |
| 113 | - ...\array_map(static function (array $supplier) { |
|
| 113 | + ...\array_map(static function(array $supplier) { |
|
| 114 | 114 | return new SupplierModel( |
| 115 | 115 | $supplier['uuid'], |
| 116 | 116 | $supplier['name'], |
@@ -54,7 +54,7 @@ discard block |
||
| 54 | 54 | supplier.slug as slug |
| 55 | 55 | FROM supplier |
| 56 | 56 | WHERE uuid = :uuid |
| 57 | -SQL; |
|
| 57 | +sql; |
|
| 58 | 58 | $result = $this->connection->executeQuery($query, ['uuid' => $uuid])->fetchAssociative(); |
| 59 | 59 | |
| 60 | 60 | if (null === $result) { |
@@ -106,7 +106,7 @@ discard block |
||
| 106 | 106 | supplier.slug as slug |
| 107 | 107 | FROM supplier |
| 108 | 108 | WHERE active = 1 |
| 109 | -SQL; |
|
| 109 | +sql; |
|
| 110 | 110 | $result = $this->connection->executeQuery($query)->fetchAllAssociative(); |
| 111 | 111 | |
| 112 | 112 | return new Suppliers( |
@@ -41,7 +41,7 @@ discard block |
||
| 41 | 41 | $query = <<<'SQL' |
| 42 | 42 | SELECT uuid FROM supplier |
| 43 | 43 | WHERE name = :name |
| 44 | -SQL; |
|
| 44 | +sql; |
|
| 45 | 45 | $statement = $this->connection->executeQuery($query, ['name' => $name])->fetchOne(); |
| 46 | 46 | |
| 47 | 47 | return !(false === $statement); |
@@ -104,7 +104,7 @@ discard block |
||
| 104 | 104 | supplier.slug as slug |
| 105 | 105 | FROM supplier |
| 106 | 106 | WHERE uuid = :uuid |
| 107 | -SQL; |
|
| 107 | +sql; |
|
| 108 | 108 | $result = $this->connection->executeQuery($query, ['uuid' => $uuid])->fetchAssociative(); |
| 109 | 109 | |
| 110 | 110 | if (null === $result) { |
@@ -82,7 +82,7 @@ discard block |
||
| 82 | 82 | user.roles as roles |
| 83 | 83 | FROM user |
| 84 | 84 | WHERE uuid = :uuid |
| 85 | -SQL; |
|
| 85 | +sql; |
|
| 86 | 86 | $result = $this->connection->executeQuery($query, ['uuid' => $uuid])->fetchAssociative(); |
| 87 | 87 | |
| 88 | 88 | return User::create( |
@@ -102,7 +102,7 @@ discard block |
||
| 102 | 102 | $query = <<<'SQL' |
| 103 | 103 | SELECT username FROM user |
| 104 | 104 | WHERE username = :username |
| 105 | -SQL; |
|
| 105 | +sql; |
|
| 106 | 106 | $statement = $this->connection->executeQuery($query, ['username' => $username])->fetchAssociative(); |
| 107 | 107 | |
| 108 | 108 | return false !== $statement; |
@@ -116,7 +116,7 @@ discard block |
||
| 116 | 116 | $query = <<<'SQL' |
| 117 | 117 | SELECT email FROM user |
| 118 | 118 | WHERE email = :email |
| 119 | -SQL; |
|
| 119 | +sql; |
|
| 120 | 120 | $statement = $this->connection->executeQuery($query, ['email' => $email])->fetchAssociative(); |
| 121 | 121 | |
| 122 | 122 | return false !== $statement; |
@@ -71,7 +71,7 @@ discard block |
||
| 71 | 71 | settings.locale as locale |
| 72 | 72 | FROM settings |
| 73 | 73 | WHERE uuid = :uuid |
| 74 | -SQL; |
|
| 74 | +sql; |
|
| 75 | 75 | $result = $this->connection->executeQuery($query, ['uuid' => $uuid])->fetchAssociative(); |
| 76 | 76 | |
| 77 | 77 | return Settings::create( |
@@ -88,7 +88,7 @@ discard block |
||
| 88 | 88 | { |
| 89 | 89 | $query = <<<'SQL' |
| 90 | 90 | SELECT uuid FROM settings |
| 91 | -SQL; |
|
| 91 | +sql; |
|
| 92 | 92 | |
| 93 | 93 | $statement = $this->connection->executeQuery($query)->fetchAssociative(); |
| 94 | 94 | |
@@ -40,7 +40,7 @@ discard block |
||
| 40 | 40 | $query = <<<'SQL' |
| 41 | 41 | SELECT uuid FROM company |
| 42 | 42 | WHERE name = :name |
| 43 | -SQL; |
|
| 43 | +sql; |
|
| 44 | 44 | $statement = $this->connection->executeQuery($query, ['name' => $name])->fetchOne(); |
| 45 | 45 | |
| 46 | 46 | return !(false === $statement); |
@@ -112,7 +112,7 @@ discard block |
||
| 112 | 112 | company.slug as slug |
| 113 | 113 | FROM company |
| 114 | 114 | WHERE uuid = :uuid |
| 115 | -SQL; |
|
| 115 | +sql; |
|
| 116 | 116 | $result = $this->connection->executeQuery($query, ['uuid' => $uuid])->fetchAssociative(); |
| 117 | 117 | |
| 118 | 118 | return Company::create( |
@@ -138,7 +138,7 @@ discard block |
||
| 138 | 138 | { |
| 139 | 139 | $query = <<<'SQL' |
| 140 | 140 | SELECT uuid FROM company |
| 141 | -SQL; |
|
| 141 | +sql; |
|
| 142 | 142 | $statement = $this->connection->executeQuery($query)->fetchOne(); |
| 143 | 143 | |
| 144 | 144 | return !(false === $statement); |