| @@ 129-132 (lines=4) @@ | ||
| 126 | $where[] = implode(" OR ", $subWhere); |
|
| 127 | } |
|
| 128 | break; |
|
| 129 | case "HasMinimumPayment": |
|
| 130 | $having[] = ' RealPayments > '.intval($value); |
|
| 131 | $humanWhere[] = ' Real Payment of at least '.$this->currencyFormat($value); |
|
| 132 | break; |
|
| 133 | case "HasMaximumPayment": |
|
| 134 | $having[] = ' RealPayments < '.intval($value); |
|
| 135 | $humanWhere[] = ' Real Payment of no more than '.$this->currencyFormat($value); |
|
| @@ 133-136 (lines=4) @@ | ||
| 130 | $having[] = ' RealPayments > '.intval($value); |
|
| 131 | $humanWhere[] = ' Real Payment of at least '.$this->currencyFormat($value); |
|
| 132 | break; |
|
| 133 | case "HasMaximumPayment": |
|
| 134 | $having[] = ' RealPayments < '.intval($value); |
|
| 135 | $humanWhere[] = ' Real Payment of no more than '.$this->currencyFormat($value); |
|
| 136 | break; |
|
| 137 | //this has been included for SearchableProductSalesReport |
|
| 138 | case "Product": |
|
| 139 | $where[] = " IF(ProductVariationsForVariations.Title IS NOT NULL, CONCAT(ProductSiteTreeForVariations.Title,' : ', ProductVariationsForVariations.Title), IF(SiteTreeForProducts.Title IS NOT NULL, SiteTreeForProducts.Title, OrderAttribute.ClassName)) LIKE '%".$value."%'"; |
|
| @@ 119-122 (lines=4) @@ | ||
| 116 | $where[] = implode(" OR ", $subWhere); |
|
| 117 | } |
|
| 118 | break; |
|
| 119 | case "HasMinimumPayment": |
|
| 120 | $having[] = ' Amount > '.intval($value); |
|
| 121 | $humanWhere[] = ' Payment of at least '.$this->currencyFormat($value); |
|
| 122 | break; |
|
| 123 | case "HasMaximumPayment": |
|
| 124 | $having[] = ' Amount < '.intval($value); |
|
| 125 | $humanWhere[] = ' Payment of no more than '.$this->currencyFormat($value); |
|
| @@ 123-126 (lines=4) @@ | ||
| 120 | $having[] = ' Amount > '.intval($value); |
|
| 121 | $humanWhere[] = ' Payment of at least '.$this->currencyFormat($value); |
|
| 122 | break; |
|
| 123 | case "HasMaximumPayment": |
|
| 124 | $having[] = ' Amount < '.intval($value); |
|
| 125 | $humanWhere[] = ' Payment of no more than '.$this->currencyFormat($value); |
|
| 126 | break; |
|
| 127 | default: |
|
| 128 | break; |
|
| 129 | } |
|