@@ -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); |