@@ -17,8 +17,8 @@ |
||
17 | 17 | $config->registerMigrationsFromDirectory($migrationFilePath ); |
18 | 18 | $config->setMigrationsTableName(self::MIGRATION_TABLE_PREFIX.$pluginCode); |
19 | 19 | $migration = new Migration($config); |
20 | - // null 又は 'last' を渡すと最新バージョンまでマイグレートする |
|
21 | - // 0か'first'を渡すと最初に戻る |
|
20 | + // null 又は 'last' を渡すと最新バージョンまでマイグレートする |
|
21 | + // 0か'first'を渡すと最初に戻る |
|
22 | 22 | $migration->migrate($version, false); |
23 | 23 | |
24 | 24 |
@@ -9,12 +9,12 @@ |
||
9 | 9 | |
10 | 10 | CONST MIGRATION_TABLE_PREFIX = 'migration_'; |
11 | 11 | |
12 | - public function migrationSchema($app,$migrationFilePath,$pluginCode,$version=null) |
|
12 | + public function migrationSchema($app, $migrationFilePath, $pluginCode, $version = null) |
|
13 | 13 | { |
14 | 14 | $config = new Configuration($app['db']); |
15 | 15 | $config->setMigrationsNamespace('DoctrineMigrations'); |
16 | 16 | $config->setMigrationsDirectory($migrationFilePath); |
17 | - $config->registerMigrationsFromDirectory($migrationFilePath ); |
|
17 | + $config->registerMigrationsFromDirectory($migrationFilePath); |
|
18 | 18 | $config->setMigrationsTableName(self::MIGRATION_TABLE_PREFIX.$pluginCode); |
19 | 19 | $migration = new Migration($config); |
20 | 20 | // null 又は 'last' を渡すと最新バージョンまでマイグレートする |
@@ -187,7 +187,7 @@ |
||
187 | 187 | $this->app['config']['block_default_realdir'], |
188 | 188 | ); |
189 | 189 | foreach ($readPaths as $readPath) { |
190 | - $filePath = $readPath . '/' . $fileName . '.twig'; |
|
190 | + $filePath = $readPath.'/'.$fileName.'.twig'; |
|
191 | 191 | $fs = new Filesystem(); |
192 | 192 | if ($fs->exists($filePath)) { |
193 | 193 | return array( |
@@ -274,7 +274,7 @@ |
||
274 | 274 | $multi = preg_match('/^\d+$/', $searchData['multi']) ? $searchData['multi'] : null; |
275 | 275 | $qb |
276 | 276 | ->andWhere('o.id = :multi OR o.name01 LIKE :likemulti OR o.name02 LIKE :likemulti OR ' . |
277 | - 'o.kana01 LIKE :likemulti OR o.kana02 LIKE :likemulti OR o.company_name LIKE :likemulti') |
|
277 | + 'o.kana01 LIKE :likemulti OR o.kana02 LIKE :likemulti OR o.company_name LIKE :likemulti') |
|
278 | 278 | ->setParameter('multi', $multi) |
279 | 279 | ->setParameter('likemulti', '%' . $searchData['multi'] . '%'); |
280 | 280 | } |
@@ -100,14 +100,14 @@ discard block |
||
100 | 100 | if (isset($searchData['name']) && Str::isNotBlank($searchData['name'])) { |
101 | 101 | $qb |
102 | 102 | ->andWhere('CONCAT(o.name01, o.name02) LIKE :name') |
103 | - ->setParameter('name', '%' . $searchData['name'] . '%'); |
|
103 | + ->setParameter('name', '%'.$searchData['name'].'%'); |
|
104 | 104 | } |
105 | 105 | |
106 | 106 | // kana |
107 | 107 | if (isset($searchData['kana']) && Str::isNotBlank($searchData['kana'])) { |
108 | 108 | $qb |
109 | 109 | ->andWhere('CONCAT(o.kana01, o.kana02) LIKE :kana') |
110 | - ->setParameter('kana', '%' . $searchData['kana'] . '%'); |
|
110 | + ->setParameter('kana', '%'.$searchData['kana'].'%'); |
|
111 | 111 | } |
112 | 112 | |
113 | 113 | |
@@ -244,7 +244,7 @@ discard block |
||
244 | 244 | $qb |
245 | 245 | ->leftJoin('o.OrderDetails', 'od') |
246 | 246 | ->andWhere('od.product_name LIKE :buy_product_name') |
247 | - ->setParameter('buy_product_name', '%' . $searchData['buy_product_name'] . '%'); |
|
247 | + ->setParameter('buy_product_name', '%'.$searchData['buy_product_name'].'%'); |
|
248 | 248 | } |
249 | 249 | |
250 | 250 | // Order By |
@@ -270,13 +270,13 @@ discard block |
||
270 | 270 | ->setParameter('order_id_start', $searchData['order_id_start']); |
271 | 271 | } |
272 | 272 | // multi |
273 | - if (isset( $searchData['multi']) && Str::isNotBlank($searchData['multi'])) { |
|
273 | + if (isset($searchData['multi']) && Str::isNotBlank($searchData['multi'])) { |
|
274 | 274 | $multi = preg_match('/^\d+$/', $searchData['multi']) ? $searchData['multi'] : null; |
275 | 275 | $qb |
276 | - ->andWhere('o.id = :multi OR o.name01 LIKE :likemulti OR o.name02 LIKE :likemulti OR ' . |
|
276 | + ->andWhere('o.id = :multi OR o.name01 LIKE :likemulti OR o.name02 LIKE :likemulti OR '. |
|
277 | 277 | 'o.kana01 LIKE :likemulti OR o.kana02 LIKE :likemulti OR o.company_name LIKE :likemulti') |
278 | 278 | ->setParameter('multi', $multi) |
279 | - ->setParameter('likemulti', '%' . $searchData['multi'] . '%'); |
|
279 | + ->setParameter('likemulti', '%'.$searchData['multi'].'%'); |
|
280 | 280 | } |
281 | 281 | |
282 | 282 | // order_id_end |
@@ -313,28 +313,28 @@ discard block |
||
313 | 313 | if (isset($searchData['name']) && Str::isNotBlank($searchData['name'])) { |
314 | 314 | $qb |
315 | 315 | ->andWhere('CONCAT(o.name01, o.name02) LIKE :name') |
316 | - ->setParameter('name', '%' . $searchData['name'] . '%'); |
|
316 | + ->setParameter('name', '%'.$searchData['name'].'%'); |
|
317 | 317 | } |
318 | 318 | |
319 | 319 | // kana |
320 | 320 | if (isset($searchData['kana']) && Str::isNotBlank($searchData['kana'])) { |
321 | 321 | $qb |
322 | 322 | ->andWhere('CONCAT(o.kana01, o.kana02) LIKE :kana') |
323 | - ->setParameter('kana', '%' . $searchData['kana'] . '%'); |
|
323 | + ->setParameter('kana', '%'.$searchData['kana'].'%'); |
|
324 | 324 | } |
325 | 325 | |
326 | 326 | |
327 | 327 | if (isset($searchData['email']) && Str::isNotBlank($searchData['email'])) { |
328 | 328 | $qb |
329 | 329 | ->andWhere('o.email like :email') |
330 | - ->setParameter('email', '%' . $searchData['email'] . '%'); |
|
330 | + ->setParameter('email', '%'.$searchData['email'].'%'); |
|
331 | 331 | } |
332 | 332 | |
333 | 333 | // tel |
334 | 334 | if (isset($searchData['tel']) && Str::isNotBlank($searchData['tel'])) { |
335 | 335 | $qb |
336 | 336 | ->andWhere('CONCAT(o.tel01, o.tel02, o.tel03) LIKE :tel') |
337 | - ->setParameter('tel', '%' . $searchData['tel'] . '%'); |
|
337 | + ->setParameter('tel', '%'.$searchData['tel'].'%'); |
|
338 | 338 | } |
339 | 339 | |
340 | 340 | // sex |
@@ -446,7 +446,7 @@ discard block |
||
446 | 446 | $qb |
447 | 447 | ->leftJoin('o.OrderDetails', 'od') |
448 | 448 | ->andWhere('od.product_name LIKE :buy_product_name') |
449 | - ->setParameter('buy_product_name', '%' . $searchData['buy_product_name'] . '%'); |
|
449 | + ->setParameter('buy_product_name', '%'.$searchData['buy_product_name'].'%'); |
|
450 | 450 | } |
451 | 451 | |
452 | 452 | // Order By |
@@ -257,7 +257,7 @@ |
||
257 | 257 | } |
258 | 258 | |
259 | 259 | foreach ($readPaths as $readPath) { |
260 | - $filePath = $readPath . '/' . $fileName . '.twig'; |
|
260 | + $filePath = $readPath.'/'.$fileName.'.twig'; |
|
261 | 261 | $fs = new Filesystem(); |
262 | 262 | if ($fs->exists($filePath)) { |
263 | 263 | return array( |
@@ -73,17 +73,17 @@ discard block |
||
73 | 73 | |
74 | 74 | $qb = $this->createQueryBuilder('e'); |
75 | 75 | $qb->andWhere("e.priority >= $range_end ") |
76 | - ->andWhere("e.priority <= $range_start ") |
|
77 | - ->andWhere('e.event = :event') |
|
78 | - ->setParameter('event',$event) |
|
79 | - ->setMaxResults(1) |
|
80 | - ->orderBy('e.priority','ASC'); |
|
76 | + ->andWhere("e.priority <= $range_start ") |
|
77 | + ->andWhere('e.event = :event') |
|
78 | + ->setParameter('event',$event) |
|
79 | + ->setMaxResults(1) |
|
80 | + ->orderBy('e.priority','ASC'); |
|
81 | 81 | |
82 | 82 | $result=$qb->getQuery()->getResult(); |
83 | 83 | if(count($result)){ |
84 | - return $result[0]->getPriority() -1; |
|
84 | + return $result[0]->getPriority() -1; |
|
85 | 85 | }else{ |
86 | - return $range_start; |
|
86 | + return $range_start; |
|
87 | 87 | } |
88 | 88 | |
89 | 89 | } |
@@ -96,14 +96,14 @@ discard block |
||
96 | 96 | $qb = $this->createQueryBuilder('e'); |
97 | 97 | |
98 | 98 | $qb->andWhere("e.priority >= $range_end ") |
99 | - ->andWhere("e.priority <= $range_start ") |
|
100 | - ->andWhere("e.del_flg = 0 ") |
|
101 | - ->andWhere('e.priority '.($up ? '>' : '<' ).' :pri') |
|
102 | - ->andWhere('e.event = :event') |
|
103 | - ->setParameter('event',$pluginEventHandler->getEvent()) |
|
104 | - ->setParameter('pri', $pluginEventHandler->getPriority() ) |
|
105 | - ->setMaxResults(1) |
|
106 | - ->orderBy('e.priority', ($up ? 'ASC':'DESC' ) ); |
|
99 | + ->andWhere("e.priority <= $range_start ") |
|
100 | + ->andWhere("e.del_flg = 0 ") |
|
101 | + ->andWhere('e.priority '.($up ? '>' : '<' ).' :pri') |
|
102 | + ->andWhere('e.event = :event') |
|
103 | + ->setParameter('event',$pluginEventHandler->getEvent()) |
|
104 | + ->setParameter('pri', $pluginEventHandler->getPriority() ) |
|
105 | + ->setMaxResults(1) |
|
106 | + ->orderBy('e.priority', ($up ? 'ASC':'DESC' ) ); |
|
107 | 107 | |
108 | 108 | $result=$qb->getQuery()->getResult(); |
109 | 109 |
@@ -42,8 +42,8 @@ discard block |
||
42 | 42 | $qb = $this->createQueryBuilder('e') |
43 | 43 | ->innerJoin('e.Plugin', 'p') |
44 | 44 | ->andWhere('e.del_flg = 0 ') |
45 | - ->Orderby('e.event','ASC') |
|
46 | - ->addOrderby('e.priority','DESC'); |
|
45 | + ->Orderby('e.event', 'ASC') |
|
46 | + ->addOrderby('e.priority', 'DESC'); |
|
47 | 47 | ; |
48 | 48 | |
49 | 49 | return $qb->getQuery()->getResult(); |
@@ -52,66 +52,66 @@ discard block |
||
52 | 52 | public function getPriorityRange($type) |
53 | 53 | { |
54 | 54 | |
55 | - if(PluginEventHandler::EVENT_HANDLER_TYPE_FIRST==$type){ |
|
56 | - $range_start=PluginEventHandler::EVENT_PRIORITY_FIRST_START; |
|
57 | - $range_end=PluginEventHandler::EVENT_PRIORITY_FIRST_END; |
|
58 | - }elseif(PluginEventHandler::EVENT_HANDLER_TYPE_LAST==$type){ |
|
59 | - $range_start=PluginEventHandler::EVENT_PRIORITY_LAST_START; |
|
60 | - $range_end=PluginEventHandler::EVENT_PRIORITY_LAST_END; |
|
61 | - }else{ |
|
62 | - $range_start=PluginEventHandler::EVENT_PRIORITY_NORMAL_START; |
|
63 | - $range_end=PluginEventHandler::EVENT_PRIORITY_NORMAL_END; |
|
55 | + if (PluginEventHandler::EVENT_HANDLER_TYPE_FIRST == $type) { |
|
56 | + $range_start = PluginEventHandler::EVENT_PRIORITY_FIRST_START; |
|
57 | + $range_end = PluginEventHandler::EVENT_PRIORITY_FIRST_END; |
|
58 | + }elseif (PluginEventHandler::EVENT_HANDLER_TYPE_LAST == $type) { |
|
59 | + $range_start = PluginEventHandler::EVENT_PRIORITY_LAST_START; |
|
60 | + $range_end = PluginEventHandler::EVENT_PRIORITY_LAST_END; |
|
61 | + } else { |
|
62 | + $range_start = PluginEventHandler::EVENT_PRIORITY_NORMAL_START; |
|
63 | + $range_end = PluginEventHandler::EVENT_PRIORITY_NORMAL_END; |
|
64 | 64 | } |
65 | - return array($range_start,$range_end); |
|
65 | + return array($range_start, $range_end); |
|
66 | 66 | |
67 | 67 | } |
68 | 68 | |
69 | - public function calcNewPriority($event , $type) |
|
69 | + public function calcNewPriority($event, $type) |
|
70 | 70 | { |
71 | 71 | |
72 | - list($range_start,$range_end) = $this->getPriorityRange($type); |
|
72 | + list($range_start, $range_end) = $this->getPriorityRange($type); |
|
73 | 73 | |
74 | 74 | $qb = $this->createQueryBuilder('e'); |
75 | 75 | $qb->andWhere("e.priority >= $range_end ") |
76 | 76 | ->andWhere("e.priority <= $range_start ") |
77 | 77 | ->andWhere('e.event = :event') |
78 | - ->setParameter('event',$event) |
|
78 | + ->setParameter('event', $event) |
|
79 | 79 | ->setMaxResults(1) |
80 | - ->orderBy('e.priority','ASC'); |
|
80 | + ->orderBy('e.priority', 'ASC'); |
|
81 | 81 | |
82 | - $result=$qb->getQuery()->getResult(); |
|
83 | - if(count($result)){ |
|
84 | - return $result[0]->getPriority() -1; |
|
85 | - }else{ |
|
82 | + $result = $qb->getQuery()->getResult(); |
|
83 | + if (count($result)) { |
|
84 | + return $result[0]->getPriority() - 1; |
|
85 | + } else { |
|
86 | 86 | return $range_start; |
87 | 87 | } |
88 | 88 | |
89 | 89 | } |
90 | 90 | |
91 | - public function upPriority($pluginEventHandler,$up=true) |
|
91 | + public function upPriority($pluginEventHandler, $up = true) |
|
92 | 92 | { |
93 | 93 | |
94 | - list($range_start,$range_end) = $this->getPriorityRange($pluginEventHandler->getHandlerType()); |
|
94 | + list($range_start, $range_end) = $this->getPriorityRange($pluginEventHandler->getHandlerType()); |
|
95 | 95 | |
96 | 96 | $qb = $this->createQueryBuilder('e'); |
97 | 97 | |
98 | 98 | $qb->andWhere("e.priority >= $range_end ") |
99 | 99 | ->andWhere("e.priority <= $range_start ") |
100 | 100 | ->andWhere("e.del_flg = 0 ") |
101 | - ->andWhere('e.priority '.($up ? '>' : '<' ).' :pri') |
|
101 | + ->andWhere('e.priority '.($up ? '>' : '<').' :pri') |
|
102 | 102 | ->andWhere('e.event = :event') |
103 | - ->setParameter('event',$pluginEventHandler->getEvent()) |
|
104 | - ->setParameter('pri', $pluginEventHandler->getPriority() ) |
|
103 | + ->setParameter('event', $pluginEventHandler->getEvent()) |
|
104 | + ->setParameter('pri', $pluginEventHandler->getPriority()) |
|
105 | 105 | ->setMaxResults(1) |
106 | - ->orderBy('e.priority', ($up ? 'ASC':'DESC' ) ); |
|
106 | + ->orderBy('e.priority', ($up ? 'ASC' : 'DESC')); |
|
107 | 107 | |
108 | - $result=$qb->getQuery()->getResult(); |
|
108 | + $result = $qb->getQuery()->getResult(); |
|
109 | 109 | |
110 | - if(count($result)){ |
|
111 | - $em =$this->getEntityManager(); |
|
110 | + if (count($result)) { |
|
111 | + $em = $this->getEntityManager(); |
|
112 | 112 | $em->getConnection()->beginTransaction(); |
113 | 113 | // 2個のentityのprioriryを入れ替える |
114 | - $tmp=$pluginEventHandler->getPriority(); |
|
114 | + $tmp = $pluginEventHandler->getPriority(); |
|
115 | 115 | $pluginEventHandler->setPriority($result[0]->getPriority()); |
116 | 116 | $result[0]->setPriority($tmp); |
117 | 117 | $em->persist($result[0]); |
@@ -119,7 +119,7 @@ discard block |
||
119 | 119 | $em->flush(); |
120 | 120 | $em->getConnection()->commit(); |
121 | 121 | # 移動する |
122 | - }else{ |
|
122 | + } else { |
|
123 | 123 | # 移動しない |
124 | 124 | throw new PluginException("Can't swap"); |
125 | 125 | } |
@@ -55,10 +55,10 @@ discard block |
||
55 | 55 | if(PluginEventHandler::EVENT_HANDLER_TYPE_FIRST==$type){ |
56 | 56 | $range_start=PluginEventHandler::EVENT_PRIORITY_FIRST_START; |
57 | 57 | $range_end=PluginEventHandler::EVENT_PRIORITY_FIRST_END; |
58 | - }elseif(PluginEventHandler::EVENT_HANDLER_TYPE_LAST==$type){ |
|
58 | + } elseif(PluginEventHandler::EVENT_HANDLER_TYPE_LAST==$type){ |
|
59 | 59 | $range_start=PluginEventHandler::EVENT_PRIORITY_LAST_START; |
60 | 60 | $range_end=PluginEventHandler::EVENT_PRIORITY_LAST_END; |
61 | - }else{ |
|
61 | + } else{ |
|
62 | 62 | $range_start=PluginEventHandler::EVENT_PRIORITY_NORMAL_START; |
63 | 63 | $range_end=PluginEventHandler::EVENT_PRIORITY_NORMAL_END; |
64 | 64 | } |
@@ -82,7 +82,7 @@ discard block |
||
82 | 82 | $result=$qb->getQuery()->getResult(); |
83 | 83 | if(count($result)){ |
84 | 84 | return $result[0]->getPriority() -1; |
85 | - }else{ |
|
85 | + } else{ |
|
86 | 86 | return $range_start; |
87 | 87 | } |
88 | 88 | |
@@ -119,7 +119,7 @@ discard block |
||
119 | 119 | $em->flush(); |
120 | 120 | $em->getConnection()->commit(); |
121 | 121 | # 移動する |
122 | - }else{ |
|
122 | + } else{ |
|
123 | 123 | # 移動しない |
124 | 124 | throw new PluginException("Can't swap"); |
125 | 125 | } |
@@ -16,7 +16,7 @@ |
||
16 | 16 | public function up(Schema $schema) |
17 | 17 | { |
18 | 18 | |
19 | - if($this->connection->getDatabasePlatform()->getName() == "mysql"){ |
|
19 | + if ($this->connection->getDatabasePlatform()->getName() == "mysql") { |
|
20 | 20 | // this up() migration is auto-generated, please modify it to your needs |
21 | 21 | $this->addSql("alter table dtb_base_info collate utf8_general_ci ;"); |
22 | 22 | $this->addSql("alter table dtb_block collate utf8_general_ci ;"); |
@@ -42,7 +42,7 @@ |
||
42 | 42 | $t = $schema->getTable('dtb_product_class'); |
43 | 43 | $c = $t->getColumn('stock_unlimited'); |
44 | 44 | |
45 | - if($c->getType()->getName() != 'smallint'){ |
|
45 | + if ($c->getType()->getName() != 'smallint') { |
|
46 | 46 | $this->addSql('ALTER TABLE dtb_product_class ADD stock_unlimited_tmp int ;'); |
47 | 47 | $this->addSql('UPDATE dtb_product_class SET stock_unlimited_tmp = 1 where stock_unlimited = true '); |
48 | 48 | $this->addSql('UPDATE dtb_product_class SET stock_unlimited_tmp = 0 where stock_unlimited <> true '); |
@@ -38,8 +38,8 @@ |
||
38 | 38 | public function up(Schema $schema) |
39 | 39 | { |
40 | 40 | // this up() migration is auto-generated, please modify it to your needs |
41 | - $t=$schema->getTable('dtb_product_class'); |
|
42 | - if(!$t->hasColumn('stock_unlimited') && $t->hasColumn('stock_unlimited_tmp')){ |
|
41 | + $t = $schema->getTable('dtb_product_class'); |
|
42 | + if (!$t->hasColumn('stock_unlimited') && $t->hasColumn('stock_unlimited_tmp')) { |
|
43 | 43 | $t->addColumn('stock_unlimited', 'smallint', array('NotNull'=>true, 'Default'=>0)); |
44 | 44 | } |
45 | 45 | } |
@@ -39,8 +39,8 @@ |
||
39 | 39 | public function up(Schema $schema) |
40 | 40 | { |
41 | 41 | // this up() migration is auto-generated, please modify it to your needs |
42 | - $t=$schema->getTable('dtb_product_class'); |
|
43 | - if($t->hasColumn('stock_unlimited_tmp')){ |
|
42 | + $t = $schema->getTable('dtb_product_class'); |
|
43 | + if ($t->hasColumn('stock_unlimited_tmp')) { |
|
44 | 44 | $this->addSql('update dtb_product_class set stock_unlimited = stock_unlimited_tmp;'); |
45 | 45 | $t->dropColumn('stock_unlimited_tmp'); |
46 | 46 | } |