boogerlad/mj - Change AYQJCODFIHXK2UNLA55D3Y2IDJDP5BMQHUA7UNGDHBZUPDBCY74QC

allow sort by and show minimum price per gram for inhalation products for (all and similar) products.

Created by boogerlad on April 21, 2020

AYQJCODFIHXK2UNLA55D3Y2IDJDP5BMQHUA7UNGDHBZUPDBCY74QC

Dependencies

In channels

main

Change contents

Insertion in initialize.sql at line 621 [6.17]
[4.2044]
[5.113]
```
	min_price_g decimal(5, 2),
```
Insertion in initialize.sql at line 640 [6.17]
[4.2242]
[5.163]
```
		something,
```
Deletion in initialize.sql at line 659 [6.17]
∅:D[7.112] → [8.829:845]
∅:D[5.286] → [8.829:845]
∅:D[3.645] → [8.829:845]
B:BD[8.829] → [8.829:845]
```
					else null
```

Insertion in initialize.sql at line 663 [6.17]

[4.2824]

[5.419]

				case
					when type in ('flower', 'preroll', 'cartridge', 'disposable') then min(price / (portions * quantity))
				end as something,

Deletion in initialize.sql at line 669 [6.17]
∅:D[5.721] → [8.965:981]
B:BD[8.965] → [8.965:981]
```
					else null
```
Deletion in initialize.sql at line 672 [6.17]
∅:D[5.827] → [8.1128:1144]
B:BD[8.1128] → [8.1128:1144]
```
					else null
```
Deletion in initialize.sql at line 690 [6.17]
∅:D[5.1074] → [8.1709:1722]
B:BD[8.1709] → [8.1709:1722]
```
					else 0
```
Insertion in initialize.sql at line 882 [6.17]
[9.852]
[3.1995]
```
	min_price_g decimal(5, 2),
```
Insertion in initialize.sql at line 900 [6.17]
[3.2217]
[3.2217]
```
		min_price_g,
```
Insertion in initialize.sql at line 955 [6.17]
[3.3615]
[3.3615]
```
	min_price_g decimal(5, 2),
```
Insertion in initialize.sql at line 990 [6.17]
[3.4628]
[3.4628]
```
		min_price_g,
```

Insertion in server.js at line 686 [11.590]

[2.659]

[10.395]

					} else if(typeof parameters.price_g === 'boolean') {
						wack += ` order by min_price_g ${parameters.price_g ? 'a' : 'de'}sc`;