|
1
|
|
|
<?php |
|
2
|
|
|
|
|
3
|
|
|
/** |
|
4
|
|
|
* TechDivision\Import\Product\Bundle\Repositories\BundleSelectionRepository |
|
5
|
|
|
* |
|
6
|
|
|
* NOTICE OF LICENSE |
|
7
|
|
|
* |
|
8
|
|
|
* This source file is subject to the Open Software License (OSL 3.0) |
|
9
|
|
|
* that is available through the world-wide-web at this URL: |
|
10
|
|
|
* http://opensource.org/licenses/osl-3.0.php |
|
11
|
|
|
* |
|
12
|
|
|
* PHP version 5 |
|
13
|
|
|
* |
|
14
|
|
|
* @author Tim Wagner <[email protected]> |
|
15
|
|
|
* @copyright 2016 TechDivision GmbH <[email protected]> |
|
16
|
|
|
* @license http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0) |
|
17
|
|
|
* @link https://github.com/techdivision/import-product-bundle |
|
18
|
|
|
* @link http://www.techdivision.com |
|
19
|
|
|
*/ |
|
20
|
|
|
|
|
21
|
|
|
namespace TechDivision\Import\Product\Bundle\Repositories; |
|
22
|
|
|
|
|
23
|
|
|
use TechDivision\Import\Repositories\AbstractRepository; |
|
24
|
|
|
use TechDivision\Import\Product\Bundle\Utils\MemberNames; |
|
25
|
|
|
|
|
26
|
|
|
/** |
|
27
|
|
|
* Repository implementation to load bundle selection data. |
|
28
|
|
|
* |
|
29
|
|
|
* @author Tim Wagner <[email protected]> |
|
30
|
|
|
* @copyright 2016 TechDivision GmbH <[email protected]> |
|
31
|
|
|
* @license http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0) |
|
32
|
|
|
* @link https://github.com/techdivision/import-product-bundle |
|
33
|
|
|
* @link http://www.techdivision.com |
|
34
|
|
|
*/ |
|
35
|
|
View Code Duplication |
class BundleSelectionRepository extends AbstractRepository |
|
|
|
|
|
|
36
|
|
|
{ |
|
37
|
|
|
|
|
38
|
|
|
/** |
|
39
|
|
|
* The prepared statement to load a existing bundle selection. |
|
40
|
|
|
* |
|
41
|
|
|
* @var \PDOStatement |
|
42
|
|
|
*/ |
|
43
|
|
|
protected $bundleSelectionStmt; |
|
44
|
|
|
|
|
45
|
|
|
/** |
|
46
|
|
|
* Initializes the repository's prepared statements. |
|
47
|
|
|
* |
|
48
|
|
|
* @return void |
|
49
|
|
|
*/ |
|
50
|
|
|
public function init() |
|
51
|
|
|
{ |
|
52
|
|
|
|
|
53
|
|
|
// load the utility class name |
|
54
|
|
|
$utilityClassName = $this->getUtilityClassName(); |
|
55
|
|
|
|
|
56
|
|
|
// initialize the prepared statements |
|
57
|
|
|
$this->bundleSelectionStmt = $this->getConnection()->prepare($utilityClassName::BUNDLE_SELECTION); |
|
58
|
|
|
} |
|
59
|
|
|
|
|
60
|
|
|
/** |
|
61
|
|
|
* Load's the bundle selection value with the passed option/product/parent product ID. |
|
62
|
|
|
* |
|
63
|
|
|
* @param integer $optionId The option ID of the bundle selection to be returned |
|
64
|
|
|
* @param integer $productId The product ID of the bundle selection to be returned |
|
65
|
|
|
* @param integer $parentProductId The parent product ID of the bundle selection to be returned |
|
66
|
|
|
* |
|
67
|
|
|
* @return array The bundle selection |
|
68
|
|
|
*/ |
|
69
|
|
|
public function findOneByOptionIdAndProductIdAndParentProductId($optionId, $productId, $parentProductId) |
|
70
|
|
|
{ |
|
71
|
|
|
|
|
72
|
|
|
// initialize the params |
|
73
|
|
|
$params = array( |
|
74
|
|
|
MemberNames::OPTION_ID => $optionId, |
|
75
|
|
|
MemberNames::PARENT_PRODUCT_ID => $parentProductId, |
|
76
|
|
|
MemberNames::PRODUCT_ID => $productId |
|
77
|
|
|
); |
|
78
|
|
|
|
|
79
|
|
|
// load and return the bundle option with the passed option/product/parent product ID |
|
80
|
|
|
$this->bundleSelectionStmt->execute($params); |
|
81
|
|
|
return $this->bundleSelectionStmt->fetch(\PDO::FETCH_ASSOC); |
|
82
|
|
|
} |
|
83
|
|
|
} |
|
84
|
|
|
|
techdivision /
import-product-bundle
Duplicated code is one of the most pungent code smells. If you need to duplicate the same code in three or more different places, we strongly encourage you to look into extracting the code into a single class or operation.
You can also find more detailed suggestions in the “Code” section of your repository.