1
|
|
|
<?php |
2
|
|
|
/* |
3
|
|
|
* This file is part of EC-CUBE |
4
|
|
|
* |
5
|
|
|
* Copyright(c) EC-CUBE CO.,LTD. All Rights Reserved. |
6
|
|
|
* |
7
|
|
|
* http://www.ec-cube.co.jp/ |
8
|
|
|
* |
9
|
|
|
* This program is free software; you can redistribute it and/or |
10
|
|
|
* modify it under the terms of the GNU General Public License |
11
|
|
|
* as published by the Free Software Foundation; either version 2 |
12
|
|
|
* of the License, or (at your option) any later version. |
13
|
|
|
* |
14
|
|
|
* This program is distributed in the hope that it will be useful, |
15
|
|
|
* but WITHOUT ANY WARRANTY; without even the implied warranty of |
16
|
|
|
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the |
17
|
|
|
* GNU General Public License for more details. |
18
|
|
|
* |
19
|
|
|
* You should have received a copy of the GNU General Public License |
20
|
|
|
* along with this program; if not, write to the Free Software |
21
|
|
|
* Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. |
22
|
|
|
*/ |
23
|
|
|
|
24
|
|
|
|
25
|
|
|
namespace Eccube\Repository; |
26
|
|
|
|
27
|
|
|
use Doctrine\ORM\EntityRepository; |
28
|
|
|
use Doctrine\ORM\NoResultException; |
29
|
|
|
use Eccube\Common\Constant; |
30
|
|
|
|
31
|
|
|
/** |
32
|
|
|
* TaxRuleRepository |
33
|
|
|
* |
34
|
|
|
* This class was generated by the Doctrine ORM. Add your own custom |
35
|
|
|
* repository methods below. |
36
|
|
|
*/ |
37
|
|
|
class TaxRuleRepository extends EntityRepository |
38
|
|
|
{ |
39
|
|
|
private $rules = array(); |
40
|
|
|
|
41
|
|
|
protected $app; |
42
|
|
|
|
43
|
|
|
public function setApplication($app) |
44
|
|
|
{ |
45
|
|
|
$this->app = $app; |
46
|
|
|
} |
47
|
|
|
|
48
|
|
|
public function newTaxRule() |
49
|
|
|
{ |
50
|
|
|
$TaxRule = new \Eccube\Entity\TaxRule(); |
51
|
|
|
$CalcRule = $this->getEntityManager() |
52
|
|
|
->getRepository('Eccube\Entity\Master\Taxrule') |
53
|
|
|
->find(1); |
54
|
|
|
$TaxRule->setCalcRule($CalcRule); |
55
|
|
|
$TaxRule->setTaxAdjust(0); |
56
|
|
|
$TaxRule->setDelFlg(0); |
57
|
|
|
|
58
|
|
|
return $TaxRule; |
59
|
|
|
} |
60
|
|
|
|
61
|
|
|
/** |
62
|
|
|
* 現在有効な税率設定情報を返す |
63
|
|
|
* |
64
|
|
|
* @param int|null|\Eccube\Entity\Product $Product 商品 |
65
|
|
|
* @param int|null|\Eccube\Entity\ProductClass $ProductClass 商品規格 |
66
|
|
|
* @param int|null|\Eccube\Entity\Master\Pref $Pref 都道府県 |
67
|
|
|
* @param int|null|\Eccube\Entity\Master\Country $Country 国 |
68
|
|
|
* @return \Eccube\Entity\TaxRule 税設定情報 |
69
|
|
|
* |
70
|
|
|
* @throws NoResultException |
71
|
|
|
*/ |
72
|
|
|
public function getByRule($Product = null, $ProductClass = null, $Pref = null, $Country = null) |
73
|
|
|
{ |
74
|
|
|
if (!$this->app) { |
75
|
|
|
throw new \LogicException(); |
76
|
|
|
} |
77
|
|
|
|
78
|
|
|
// Pref Country 設定 |
79
|
|
|
if (!$Pref && !$Country && $this->app['security']->getToken() && $this->app['security']->isGranted('ROLE_USER')) { |
80
|
|
|
/* @var $Customer \Eccube\Entity\Customer */ |
81
|
|
|
$Customer = $this->app['security']->getToken()->getUser(); |
82
|
|
|
$Pref = $Customer->getPref(); |
83
|
|
|
$Country = $Customer->getCountry(); |
84
|
|
|
} |
85
|
|
|
|
86
|
|
|
// 商品単位税率設定がOFFの場合 |
87
|
|
|
/** @var $BaseInfo \Eccube\Entity\BaseInfo */ |
88
|
|
|
$BaseInfo = $this->app['eccube.repository.base_info']->get(); |
89
|
|
|
if ($BaseInfo->getOptionProductTaxRule() !== Constant::ENABLED) { |
90
|
|
|
$Product = null; |
91
|
|
|
$ProductClass = null; |
92
|
|
|
} |
93
|
|
|
|
94
|
|
|
// Cache Key 設定 |
95
|
|
|
if ($Product instanceof \Eccube\Entity\Product) { |
|
|
|
|
96
|
|
|
$productId = $Product->getId(); |
97
|
|
|
} elseif ($Product) { |
|
|
|
|
98
|
|
|
$productId = $Product; |
99
|
|
|
} else { |
100
|
|
|
$productId = '0'; |
101
|
|
|
} |
102
|
|
|
if ($ProductClass instanceof \Eccube\Entity\ProductClass) { |
|
|
|
|
103
|
|
|
$productClassId = $ProductClass->getId(); |
104
|
|
|
} elseif ($ProductClass) { |
|
|
|
|
105
|
|
|
$productClassId = $ProductClass; |
106
|
|
|
} else { |
107
|
|
|
$productClassId = '0'; |
108
|
|
|
} |
109
|
|
|
if ($Pref instanceof \Eccube\Entity\Master\Pref) { |
|
|
|
|
110
|
|
|
$prefId = $Pref->getId(); |
111
|
|
|
} elseif ($Pref) { |
112
|
|
|
$prefId = $Pref; |
113
|
|
|
} else { |
114
|
|
|
$prefId = '0'; |
115
|
|
|
} |
116
|
|
|
if ($Country instanceof \Eccube\Entity\Master\Country) { |
|
|
|
|
117
|
|
|
$countryId = $Country->getId(); |
118
|
|
|
} elseif ($Country) { |
119
|
|
|
$countryId = $Country; |
120
|
|
|
} else { |
121
|
|
|
$countryId = '0'; |
122
|
|
|
} |
123
|
|
|
$cacheKey = $productId.':'.$productClassId.':'.$prefId.':'.$countryId; |
124
|
|
|
|
125
|
|
|
// すでに取得している場合はキャッシュから |
126
|
|
|
if (isset($this->rules[$cacheKey])) { |
127
|
|
|
return $this->rules[$cacheKey]; |
128
|
|
|
} |
129
|
|
|
|
130
|
|
|
$parameters = array(); |
131
|
|
|
$qb = $this->createQueryBuilder('t') |
132
|
|
|
->where('t.apply_date < :apply_date'); |
133
|
|
|
$parameters[':apply_date'] = new \DateTime(); |
134
|
|
|
|
135
|
|
|
// Pref |
136
|
|
|
if ($Pref) { |
137
|
|
|
$qb->andWhere('t.Pref IS NULL OR t.Pref = :Pref'); |
138
|
|
|
$parameters['Pref'] = $Pref; |
139
|
|
|
} else { |
140
|
|
|
$qb->andWhere('t.Pref IS NULL'); |
141
|
|
|
} |
142
|
|
|
|
143
|
|
|
// Country |
144
|
|
|
if ($Country) { |
145
|
|
|
$qb->andWhere('t.Country IS NULL OR t.Country = :Country'); |
146
|
|
|
$parameters['Country'] = $Country; |
147
|
|
|
} else { |
148
|
|
|
$qb->andWhere('t.Country IS NULL'); |
149
|
|
|
} |
150
|
|
|
|
151
|
|
|
/* |
152
|
|
|
* Product, ProductClass が persist される前に TaxRuleEventSubscriber によってアクセスされる |
153
|
|
|
* 場合があるため、ID の存在もチェックする. |
154
|
|
|
* https://github.com/EC-CUBE/ec-cube/issues/677 |
155
|
|
|
*/ |
156
|
|
|
|
157
|
|
|
// Product |
158
|
|
|
if ($Product && $productId > 0) { |
159
|
|
|
$qb->andWhere('t.Product IS NULL OR t.Product = :Product'); |
160
|
|
|
$parameters['Product'] = $Product; |
161
|
|
|
} else { |
162
|
|
|
$qb->andWhere('t.Product IS NULL'); |
163
|
|
|
} |
164
|
|
|
|
165
|
|
|
// ProductClass |
166
|
|
|
if ($ProductClass && $productClassId > 0) { |
167
|
|
|
$qb->andWhere('t.ProductClass IS NULL OR t.ProductClass = :ProductClass'); |
168
|
|
|
$parameters['ProductClass'] = $ProductClass; |
169
|
|
|
} else { |
170
|
|
|
$qb->andWhere('t.ProductClass IS NULL'); |
171
|
|
|
} |
172
|
|
|
|
173
|
|
|
$TaxRules = $qb |
174
|
|
|
->setParameters($parameters) |
175
|
|
|
->orderBy('t.apply_date', 'DESC') // 実際は usort() でソートする |
176
|
|
|
->getQuery() |
177
|
|
|
->getResult(); |
178
|
|
|
|
179
|
|
|
// 地域設定を優先するが、システムパラメーターなどに設定を持っていくか |
180
|
|
|
// 後に書いてあるほど優先される |
181
|
|
|
$priorityKeys = explode(',', $this->app['config']['tax_rule_priority']); |
|
|
|
|
182
|
|
|
$priorityKeys = array(); |
183
|
|
|
foreach (explode(',', $this->app['config']['tax_rule_priority']) as $key) { |
184
|
|
|
$priorityKeys[] = str_replace('_', '', preg_replace('/_id\z/', '', $key)); |
185
|
|
|
} |
186
|
|
|
|
187
|
|
|
foreach ($TaxRules as $TaxRule) { |
188
|
|
|
$rank = 0; |
189
|
|
|
foreach ($priorityKeys as $index => $key) { |
190
|
|
|
$arrayProperties = array_change_key_case($TaxRule->toArray()); |
191
|
|
|
if ($arrayProperties[$key]) { |
192
|
|
|
|
193
|
|
|
// 配列の数値添字を重みとして利用する |
194
|
|
|
$rank += 1 << ($index + 1); |
195
|
|
|
} |
196
|
|
|
} |
197
|
|
|
$TaxRule->setRank($rank); |
198
|
|
|
} |
199
|
|
|
|
200
|
|
|
// 適用日降順, rank 降順にソートする |
201
|
|
|
usort($TaxRules, function($a, $b) { |
202
|
|
|
return $a->compareTo($b); |
203
|
|
|
}); |
204
|
|
|
|
205
|
|
|
if (!empty($TaxRules)) { |
206
|
|
|
$this->rules[$cacheKey] = $TaxRules[0]; |
207
|
|
|
|
208
|
|
|
return $TaxRules[0]; |
209
|
|
|
} else { |
210
|
|
|
throw new NoResultException(); |
211
|
|
|
} |
212
|
|
|
} |
213
|
|
|
|
214
|
|
|
/** |
215
|
|
|
* getList |
216
|
|
|
* |
217
|
|
|
* @return array|null |
218
|
|
|
*/ |
219
|
|
|
public function getList() |
220
|
|
|
{ |
221
|
|
|
$qb = $this->createQueryBuilder('t') |
222
|
|
|
->orderBy('t.apply_date', 'DESC') |
223
|
|
|
->where('t.Product IS NULL AND t.ProductClass IS NULL'); |
224
|
|
|
$TaxRules = $qb |
225
|
|
|
->getQuery() |
226
|
|
|
->getResult(); |
227
|
|
|
|
228
|
|
|
return $TaxRules; |
229
|
|
|
} |
230
|
|
|
|
231
|
|
|
/** |
232
|
|
|
* getById |
233
|
|
|
* |
234
|
|
|
* @param int $id |
235
|
|
|
* @return array |
236
|
|
|
*/ |
237
|
|
|
public function getById($id) |
238
|
|
|
{ |
239
|
|
|
$criteria = array( |
240
|
|
|
'id' => $id, |
241
|
|
|
); |
242
|
|
|
|
243
|
|
|
return $this->findOneBy($criteria); |
244
|
|
|
} |
245
|
|
|
|
246
|
|
|
/** |
247
|
|
|
* getByTime |
248
|
|
|
* |
249
|
|
|
* @param string $applyDate |
250
|
|
|
* @return mixed |
251
|
|
|
*/ |
252
|
|
|
public function getByTime($applyDate) |
253
|
|
|
{ |
254
|
|
|
$criteria = array( |
255
|
|
|
'apply_date' => $applyDate, |
256
|
|
|
); |
257
|
|
|
|
258
|
|
|
return $this->findOneBy($criteria); |
259
|
|
|
} |
260
|
|
|
|
261
|
|
|
/** |
262
|
|
|
* 税規約の削除. |
263
|
|
|
* |
264
|
|
|
* @param int|\Eccube\Entity\TaxRule $TaxRule 税規約 |
265
|
|
|
* @return void |
266
|
|
|
* @throws NoResultException |
267
|
|
|
*/ |
268
|
|
|
public function delete($TaxRule) |
269
|
|
|
{ |
270
|
|
|
if (!$TaxRule instanceof \Eccube\Entity\TaxRule) { |
|
|
|
|
271
|
|
|
$TaxRule = $this->find($TaxRule); |
272
|
|
|
} |
273
|
|
|
if (!$TaxRule) { |
274
|
|
|
throw new NoResultException; |
275
|
|
|
} |
276
|
|
|
$TaxRule->setDelFlg(1); |
277
|
|
|
$em = $this->getEntityManager(); |
278
|
|
|
$em->persist($TaxRule); |
279
|
|
|
$em->flush(); |
280
|
|
|
} |
281
|
|
|
|
282
|
|
|
/** |
283
|
|
|
* TaxRule のキャッシュをクリアする. |
284
|
|
|
* |
285
|
|
|
* getByRule() をコールすると、結果をキャッシュし、2回目以降はデータベースへアクセスしない. |
286
|
|
|
* このメソッドをコールすると、キャッシュをクリアし、再度データベースを参照して結果を取得する. |
287
|
|
|
*/ |
288
|
|
|
public function clearCache() |
289
|
|
|
{ |
290
|
|
|
$this->rules = array(); |
291
|
|
|
} |
292
|
|
|
} |
293
|
|
|
|
This error could be the result of:
1. Missing dependencies
PHP Analyzer uses your
composer.json
file (if available) to determine the dependencies of your project and to determine all the available classes and functions. It expects thecomposer.json
to be in the root folder of your repository.Are you sure this class is defined by one of your dependencies, or did you maybe not list a dependency in either the
require
orrequire-dev
section?2. Missing use statement
PHP does not complain about undefined classes in
ìnstanceof
checks. For example, the following PHP code will work perfectly fine:If you have not tested against this specific condition, such errors might go unnoticed.