| @@ 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 | /** |
|