Conditions | 2 |
Paths | 2 |
Total Lines | 17 |
Code Lines | 9 |
Lines | 0 |
Ratio | 0 % |
Changes | 1 | ||
Bugs | 0 | Features | 0 |
1 | <?php |
||
8 | public function tca() : array |
||
9 | { |
||
10 | $sql = 'SELECT "siteid", "label", "level" FROM "mshop_locale_site" ORDER BY "nleft"'; |
||
11 | $dbm = \Aimeos\Aimeos\Base::getContext( \Aimeos\Aimeos\Base::getConfig() )->db(); |
||
12 | |||
13 | $conn = $dbm->acquire( 'db-locale' ); |
||
14 | $result = $conn->create( $sql )->execute(); |
||
15 | |||
16 | $list = [['', '']]; |
||
17 | |||
18 | while( $row = $result->fetch() ) { |
||
19 | $list[] = [$row['label'], $row['siteid']]; |
||
20 | } |
||
21 | |||
22 | $dbm->release( $conn, 'db-locale' ); |
||
23 | |||
24 | return $list; |
||
25 | } |
||
26 | } |