@@ 23-31 (lines=9) @@ | ||
20 | * @param string $ean |
|
21 | * @return mixed |
|
22 | */ |
|
23 | public function imageExists($imageName, $productId, $ean) |
|
24 | { |
|
25 | $connection = $this->getConnection(); |
|
26 | $query = $connection->select() |
|
27 | ->from(['s' => $this->getMainTable()], ['s.ean']) |
|
28 | ->where('s.image = ? AND s.product_id = ? AND s.ean= ?', $imageName, $productId, $ean); |
|
29 | $eans = $connection->fetchAll($query); |
|
30 | ||
31 | return $eans; |
|
32 | } |
|
33 | ||
34 | /** |
|
@@ 37-45 (lines=9) @@ | ||
34 | /** |
|
35 | * @return mixed |
|
36 | */ |
|
37 | public function getProcessedEans() |
|
38 | { |
|
39 | $connection = $this->getConnection(); |
|
40 | $query = $connection->select() |
|
41 | ->from(['s' => $this->getMainTable()], ['s.ean']) |
|
42 | ->group('s.ean'); |
|
43 | $eans = $connection->fetchAll($query); |
|
44 | ||
45 | return $eans; |
|
46 | } |
|
47 | ||
48 | /** |