Passed
Push — master ( f3cc5b...625259 )
by Aimeos
05:44
created

OrderAddBaseServiceCurrencyid::before()   A

Complexity

Conditions 1
Paths 1

Size

Total Lines 3
Code Lines 1

Duplication

Lines 0
Ratio 0 %

Importance

Changes 0
Metric Value
eloc 1
c 0
b 0
f 0
dl 0
loc 3
rs 10
cc 1
nc 1
nop 0
1
<?php
2
3
/**
4
 * @license LGPLv3, https://opensource.org/licenses/LGPL-3.0
5
 * @copyright Aimeos (aimeos.org), 2018-2023
6
 */
7
8
9
namespace Aimeos\Upscheme\Task;
10
11
12
class OrderAddBaseServiceCurrencyid extends Base
13
{
14
	public function before() : array
15
	{
16
		return ['Order'];
17
	}
18
19
20
	public function up()
21
	{
22
		$db = $this->db( 'db-order' );
23
24
		if( !$db->hasTable( ['mshop_order_base', 'mshop_order_base_service'] ) ) {
25
			return;
26
		}
27
28
		$this->info( 'Adding currency ID to order base service table', 'vv' );
29
30
		$db->exec( '
31
			UPDATE mshop_order_base_service SET currencyid = (
32
				SELECT ob.currencyid FROM mshop_order_base ob WHERE ob.id = baseid
33
			) WHERE currencyid = \'\'  OR currencyid = \'   \'
34
		' );
35
	}
36
}
37