@@ -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 |