GX-Bug #55130 » GraduatedPriceFix.patch
| src/includes/classes/product.php (revision ) | ||
|---|---|---|
| 494 | 494 |
{
|
| 495 | 495 |
$staffel_query = xtDBquery("SELECT
|
| 496 | 496 |
quantity, |
| 497 |
personal_offer |
|
| 497 |
if(personal_offer=0,p.products_price,personal_offer) as personal_offer
|
|
| 498 | 498 |
FROM |
| 499 |
" . TABLE_PERSONAL_OFFERS_BY . (int)$_SESSION['customers_status']['customers_status_id'] . " |
|
| 500 |
WHERE |
|
| 501 |
products_id = '" . $this->pID . "' |
|
| 499 |
" . TABLE_PERSONAL_OFFERS_BY . (int)$_SESSION['customers_status']['customers_status_id'] . " po |
|
| 500 |
products p |
|
| 501 |
WHERE p.products_id=po.products_id |
|
| 502 |
p.products_id = '" . $this->pID . "' |
|
| 502 | 503 |
ORDER BY quantity ASC"); |
| 503 | 504 | |
| 504 | 505 |
$staffel = array(); |
