@@ -30,15 +30,15 @@ |
||
30 | 30 | |
31 | 31 | /** Migrate the part locations for parts with known instock */ |
32 | 32 | $this->addSql( |
33 | - 'INSERT INTO part_lots (id_part, id_store_location, instock, instock_unknown, last_modified, datetime_added) ' . |
|
34 | - 'SELECT parts.id, parts.id_storelocation, parts.instock, 0, NOW(), NOW() FROM parts ' . |
|
33 | + 'INSERT INTO part_lots (id_part, id_store_location, instock, instock_unknown, last_modified, datetime_added) '. |
|
34 | + 'SELECT parts.id, parts.id_storelocation, parts.instock, 0, NOW(), NOW() FROM parts '. |
|
35 | 35 | 'WHERE parts.instock >= 0 AND parts.id_storelocation IS NOT NULL' |
36 | 36 | ); |
37 | 37 | |
38 | 38 | //Migrate part locations for parts with unknown instock |
39 | 39 | $this->addSql( |
40 | - 'INSERT INTO part_lots (id_part, id_store_location, instock, instock_unknown, last_modified, datetime_added) ' . |
|
41 | - 'SELECT parts.id, parts.id_storelocation, 0, 1, NOW(), NOW() FROM parts ' . |
|
40 | + 'INSERT INTO part_lots (id_part, id_store_location, instock, instock_unknown, last_modified, datetime_added) '. |
|
41 | + 'SELECT parts.id, parts.id_storelocation, 0, 1, NOW(), NOW() FROM parts '. |
|
42 | 42 | 'WHERE parts.instock = -2 AND parts.id_storelocation IS NOT NULL' |
43 | 43 | ); |
44 | 44 |
@@ -118,6 +118,6 @@ |
||
118 | 118 | */ |
119 | 119 | public function getIDString(): string |
120 | 120 | { |
121 | - return 'PL' . $this->getID(); |
|
121 | + return 'PL'.$this->getID(); |
|
122 | 122 | } |
123 | 123 | } |
124 | 124 | \ No newline at end of file |
@@ -78,7 +78,7 @@ |
||
78 | 78 | */ |
79 | 79 | public function getIDString(): string |
80 | 80 | { |
81 | - return 'MU' . $this->getID(); |
|
81 | + return 'MU'.$this->getID(); |
|
82 | 82 | } |
83 | 83 | |
84 | 84 | /** |
@@ -126,6 +126,6 @@ |
||
126 | 126 | */ |
127 | 127 | public function getIDString(): string |
128 | 128 | { |
129 | - return 'C' . $this->getID(); |
|
129 | + return 'C'.$this->getID(); |
|
130 | 130 | } |
131 | 131 | } |
132 | 132 | \ No newline at end of file |