@@ -30,28 +30,28 @@ |
||
| 30 | 30 | |
| 31 | 31 | function selectOneByShopIdAndSlug($shopId, $slug) |
| 32 | 32 | { |
| 33 | - return $this->model->with(array('productCategory', 'productImages'))->where('shop_id', '=', $shopId)->where('slug', '=', $slug)->get()->first(); |
|
| 33 | + return $this->model->with(array('productCategory', 'productImages'))->where('shop_id', '=', $shopId)->where('slug', '=', $slug)->get()->first(); |
|
| 34 | 34 | } |
| 35 | 35 | |
| 36 | 36 | function selectOneByShopIdAndId($shopId, $id) |
| 37 | 37 | { |
| 38 | - return $this->model->with(array('productCategory', 'productImages'))->where('shop_id', '=', $shopId)->where('id', '=', $id)->get()->first(); |
|
| 38 | + return $this->model->with(array('productCategory', 'productImages'))->where('shop_id', '=', $shopId)->where('id', '=', $id)->get()->first(); |
|
| 39 | 39 | } |
| 40 | 40 | |
| 41 | 41 | function selectAllByProductCategoryId($productCategoryId, $shopId) |
| 42 | 42 | { |
| 43 | 43 | |
| 44 | - return $this->model-> |
|
| 45 | - whereHas('product', function ($query) use ($productCategoryId, $shopId) { |
|
| 44 | + return $this->model-> |
|
| 45 | + whereHas('product', function ($query) use ($productCategoryId, $shopId) { |
|
| 46 | 46 | $query->where('product_category_id', '=', $productCategoryId); |
| 47 | 47 | $query->where('active', '=', 1); |
| 48 | 48 | $query->where('shop_id', '=', $shopId); |
| 49 | - })->with( |
|
| 50 | - array( |
|
| 49 | + })->with( |
|
| 50 | + array( |
|
| 51 | 51 | 'extraFieldDefaultValue', |
| 52 | 52 | 'extraField' => function ($q) { |
| 53 | 53 | } |
| 54 | 54 | ) |
| 55 | - )->get(); |
|
| 55 | + )->get(); |
|
| 56 | 56 | } |
| 57 | 57 | } |
| 58 | 58 | \ No newline at end of file |
@@ -42,14 +42,14 @@ |
||
| 42 | 42 | { |
| 43 | 43 | |
| 44 | 44 | return $this->model-> |
| 45 | - whereHas('product', function ($query) use ($productCategoryId, $shopId) { |
|
| 45 | + whereHas('product', function($query) use ($productCategoryId, $shopId) { |
|
| 46 | 46 | $query->where('product_category_id', '=', $productCategoryId); |
| 47 | 47 | $query->where('active', '=', 1); |
| 48 | 48 | $query->where('shop_id', '=', $shopId); |
| 49 | 49 | })->with( |
| 50 | 50 | array( |
| 51 | 51 | 'extraFieldDefaultValue', |
| 52 | - 'extraField' => function ($q) { |
|
| 52 | + 'extraField' => function($q) { |
|
| 53 | 53 | } |
| 54 | 54 | ) |
| 55 | 55 | )->get(); |
@@ -14,7 +14,7 @@ |
||
| 14 | 14 | protected $table = 'product_attribute_combination'; |
| 15 | 15 | |
| 16 | 16 | // Add the 'avatar' attachment to the fillable array so that it's mass-assignable on this model. |
| 17 | - protected $fillable = ['product_attribute_id', 'attribute_id', 'modified_by_user_id']; |
|
| 17 | + protected $fillable = ['product_attribute_id', 'attribute_id', 'modified_by_user_id']; |
|
| 18 | 18 | |
| 19 | 19 | public function attribute() |
| 20 | 20 | { |
@@ -103,7 +103,7 @@ |
||
| 103 | 103 | if ($this->discount_value) { |
| 104 | 104 | if ($this->discount_type == 'amount') { |
| 105 | 105 | $discountPriceInc = $priceInc - $this->discount_value; |
| 106 | - $discountPriceEx = $discountPriceInc / 1.21; |
|
| 106 | + $discountPriceEx = $discountPriceInc / 1.21; |
|
| 107 | 107 | } elseif ($this->discount_type == 'percent') { |
| 108 | 108 | $tax = ($this->discount_value / 100) * $priceInc; |
| 109 | 109 | $discountPriceInc = $priceInc - $tax; |
@@ -183,7 +183,7 @@ |
||
| 183 | 183 | |
| 184 | 184 | public function relatedProductsActive() |
| 185 | 185 | { |
| 186 | - return $this->belongsToMany('Hideyo\Ecommerce\Framework\Services\Product\Entity\Product', 'product_related_product', 'product_id', 'related_product_id')->whereHas('productCategory', function ($query) { |
|
| 186 | + return $this->belongsToMany('Hideyo\Ecommerce\Framework\Services\Product\Entity\Product', 'product_related_product', 'product_id', 'related_product_id')->whereHas('productCategory', function($query) { |
|
| 187 | 187 | $query->where('active', '=', '1'); |
| 188 | 188 | })->where('product.active', '=', '1'); |
| 189 | 189 | } |
@@ -33,7 +33,7 @@ discard block |
||
| 33 | 33 | |
| 34 | 34 | function selectAllByShopId($shopId) |
| 35 | 35 | { |
| 36 | - return $this->model->where('shop_id', '=', $shopId)->get(); |
|
| 36 | + return $this->model->where('shop_id', '=', $shopId)->get(); |
|
| 37 | 37 | } |
| 38 | 38 | |
| 39 | 39 | public function selectAllExport() |
@@ -117,8 +117,8 @@ discard block |
||
| 117 | 117 | |
| 118 | 118 | public function selectOneByShopIdAndId($shopId, $productId = false, $attributeId = false) |
| 119 | 119 | { |
| 120 | - return $this->model->with( |
|
| 121 | - array( |
|
| 120 | + return $this->model->with( |
|
| 121 | + array( |
|
| 122 | 122 | 'attributeGroup', |
| 123 | 123 | 'attributes' => function ($query) { |
| 124 | 124 | $query->with( |
@@ -167,7 +167,7 @@ discard block |
||
| 167 | 167 | )->with(array('relatedProductAttributes', |
| 168 | 168 | 'relatedAttributes')); |
| 169 | 169 | }) |
| 170 | - )->where('shop_id', '=', $shopId)->where('active', '=', 1)->whereNotNull('product_category_id')->where('id', '=', $productId)->get()->first(); |
|
| 170 | + )->where('shop_id', '=', $shopId)->where('active', '=', 1)->whereNotNull('product_category_id')->where('id', '=', $productId)->get()->first(); |
|
| 171 | 171 | } |
| 172 | 172 | |
| 173 | 173 | public function ajaxProductImages($product, $combinationsIds, $productAttributeId = false) |
@@ -26,7 +26,7 @@ discard block |
||
| 26 | 26 | |
| 27 | 27 | public function selectByLimitAndOrderBy($shopId, $limit, $orderBy) |
| 28 | 28 | { |
| 29 | - return $this->model->with(array('productCategory', 'relatedProducts', 'productImages' => function ($query) { |
|
| 29 | + return $this->model->with(array('productCategory', 'relatedProducts', 'productImages' => function($query) { |
|
| 30 | 30 | $query->orderBy('rank', 'asc'); |
| 31 | 31 | }))->where('shop_id', '=', $shopId)->where('active', '=', 1)->limit($limit)->orderBy('id', $orderBy)->get(); |
| 32 | 32 | } |
@@ -38,7 +38,7 @@ discard block |
||
| 38 | 38 | |
| 39 | 39 | public function selectAllExport() |
| 40 | 40 | { |
| 41 | - return $this->model->with(array('productImages' => function ($query) { |
|
| 41 | + return $this->model->with(array('productImages' => function($query) { |
|
| 42 | 42 | $query->orderBy('rank', 'asc'); |
| 43 | 43 | }))->where('active', '=', 1)->where('shop_id', '=', auth('hideyobackend')->user()->selected_shop_id)->get(); |
| 44 | 44 | } |
@@ -72,7 +72,7 @@ discard block |
||
| 72 | 72 | |
| 73 | 73 | public function selectOneById($productId) |
| 74 | 74 | { |
| 75 | - $result = $this->model->with(array('productCategory', 'relatedProducts', 'productImages' => function ($query) { |
|
| 75 | + $result = $this->model->with(array('productCategory', 'relatedProducts', 'productImages' => function($query) { |
|
| 76 | 76 | $query->orderBy('rank', 'asc'); |
| 77 | 77 | }))->where('active', '=', 1)->where('id', '=', $productId)->get()->first(); |
| 78 | 78 | return $result; |
@@ -93,19 +93,19 @@ discard block |
||
| 93 | 93 | function selectAllByShopIdAndProductCategoryId($shopId, $productCategoryId, $filters = false) |
| 94 | 94 | { |
| 95 | 95 | $result = $this->model |
| 96 | - ->with(array('subcategories', 'extraFields' => function ($query) { |
|
| 96 | + ->with(array('subcategories', 'extraFields' => function($query) { |
|
| 97 | 97 | $query->with('extraField')->orderBy('id', 'desc'); |
| 98 | - }, 'taxRate', 'productCategory', 'relatedProducts' => function ($query) { |
|
| 98 | + }, 'taxRate', 'productCategory', 'relatedProducts' => function($query) { |
|
| 99 | 99 | $query->with('productImages')->orderBy('rank', 'asc'); |
| 100 | - }, 'productImages' => function ($query) { |
|
| 100 | + }, 'productImages' => function($query) { |
|
| 101 | 101 | $query->orderBy('rank', 'asc'); |
| 102 | 102 | })) |
| 103 | 103 | ->where('shop_id', '=', $shopId) |
| 104 | 104 | ->where('active', '=', 1) |
| 105 | 105 | ->whereNotNull('product.product_category_id') |
| 106 | - ->where(function ($query) use ($productCategoryId) { |
|
| 106 | + ->where(function($query) use ($productCategoryId) { |
|
| 107 | 107 | $query->where('product_category_id', '=', $productCategoryId); |
| 108 | - $query->orWhereHas('subcategories', function ($query) use ($productCategoryId) { |
|
| 108 | + $query->orWhereHas('subcategories', function($query) use ($productCategoryId) { |
|
| 109 | 109 | $query->where('product_category_id', '=', $productCategoryId); |
| 110 | 110 | }); |
| 111 | 111 | }); |
@@ -120,14 +120,14 @@ discard block |
||
| 120 | 120 | return $this->model->with( |
| 121 | 121 | array( |
| 122 | 122 | 'attributeGroup', |
| 123 | - 'attributes' => function ($query) { |
|
| 123 | + 'attributes' => function($query) { |
|
| 124 | 124 | $query->with( |
| 125 | 125 | array( |
| 126 | - 'combinations' => function ($query) { |
|
| 126 | + 'combinations' => function($query) { |
|
| 127 | 127 | $query->with( |
| 128 | 128 | array( |
| 129 | 129 | 'productAttribute', |
| 130 | - 'attribute' => function ($query) { |
|
| 130 | + 'attribute' => function($query) { |
|
| 131 | 131 | $query->with( |
| 132 | 132 | array( |
| 133 | 133 | 'attributeGroup' |
@@ -140,7 +140,7 @@ discard block |
||
| 140 | 140 | ) |
| 141 | 141 | )->orderBy('default_on', 'desc'); |
| 142 | 142 | }, |
| 143 | - 'extraFields' => function ($query) { |
|
| 143 | + 'extraFields' => function($query) { |
|
| 144 | 144 | $query->where( |
| 145 | 145 | 'value', |
| 146 | 146 | '!=', |
@@ -151,7 +151,7 @@ discard block |
||
| 151 | 151 | 'desc' |
| 152 | 152 | ); |
| 153 | 153 | }, |
| 154 | - 'relatedProducts' => function ($query) { |
|
| 154 | + 'relatedProducts' => function($query) { |
|
| 155 | 155 | $query->with( |
| 156 | 156 | 'productImages', |
| 157 | 157 | 'productCategory' |
@@ -160,7 +160,7 @@ discard block |
||
| 160 | 160 | 'asc' |
| 161 | 161 | ); |
| 162 | 162 | }, |
| 163 | - 'productImages' => function ($query) { |
|
| 163 | + 'productImages' => function($query) { |
|
| 164 | 164 | $query->orderBy( |
| 165 | 165 | 'rank', |
| 166 | 166 | 'asc' |
@@ -174,31 +174,31 @@ discard block |
||
| 174 | 174 | { |
| 175 | 175 | $images = array(); |
| 176 | 176 | |
| 177 | - if($product->productImages->count()) { |
|
| 177 | + if ($product->productImages->count()) { |
|
| 178 | 178 | |
| 179 | 179 | $images = $product->productImages()->has('relatedAttributes', '=', 0)->has('relatedProductAttributes', '=', 0)->orderBy('rank', '=', 'asc')->get(); |
| 180 | 180 | |
| 181 | - if($combinationsIds) { |
|
| 181 | + if ($combinationsIds) { |
|
| 182 | 182 | |
| 183 | 183 | $imagesRelatedAttributes = ProductImage:: |
| 184 | 184 | whereHas('relatedAttributes', function($query) use ($combinationsIds, $product) { $query->with(array('productImage'))->whereIn('attribute_id', $combinationsIds); }) |
| 185 | 185 | ->where('product_id', '=', $product->id) |
| 186 | 186 | ->get(); |
| 187 | 187 | |
| 188 | - if($imagesRelatedAttributes) { |
|
| 188 | + if ($imagesRelatedAttributes) { |
|
| 189 | 189 | $images = $images->merge($imagesRelatedAttributes)->sortBy('rank'); |
| 190 | 190 | } |
| 191 | 191 | |
| 192 | 192 | } |
| 193 | 193 | |
| 194 | - if($productAttributeId) { |
|
| 194 | + if ($productAttributeId) { |
|
| 195 | 195 | |
| 196 | 196 | $imagesRelatedProductAttributes = ProductImage:: |
| 197 | 197 | whereHas('relatedProductAttributes', function($query) use ($productAttributeId, $product) { $query->where('product_attribute_id', '=', $productAttributeId); }) |
| 198 | 198 | ->where('product_id', '=', $product->id) |
| 199 | 199 | ->get(); |
| 200 | 200 | |
| 201 | - if($imagesRelatedProductAttributes) { |
|
| 201 | + if ($imagesRelatedProductAttributes) { |
|
| 202 | 202 | $images = $images->merge($imagesRelatedProductAttributes)->sortBy('rank'); |
| 203 | 203 | } |
| 204 | 204 | |
@@ -15,7 +15,7 @@ |
||
| 15 | 15 | protected $table = 'product_amount_series'; |
| 16 | 16 | |
| 17 | 17 | // Add the 'avatar' attachment to the fillable array so that it's mass-assignable on this model. |
| 18 | - protected $fillable = ['active', 'product_id', 'series_value', 'series_start', 'series_max', 'modified_by_user_id']; |
|
| 18 | + protected $fillable = ['active', 'product_id', 'series_value', 'series_start', 'series_max', 'modified_by_user_id']; |
|
| 19 | 19 | |
| 20 | 20 | public function product() |
| 21 | 21 | { |
@@ -19,6 +19,6 @@ |
||
| 19 | 19 | |
| 20 | 20 | function selectAllByProductId($productId) |
| 21 | 21 | { |
| 22 | - return $this->model->where('product_id', '=', $productId)->get(); |
|
| 22 | + return $this->model->where('product_id', '=', $productId)->get(); |
|
| 23 | 23 | } |
| 24 | 24 | } |
| 25 | 25 | \ No newline at end of file |
@@ -31,7 +31,7 @@ discard block |
||
| 31 | 31 | ); |
| 32 | 32 | |
| 33 | 33 | if ($AmountOptionId) { |
| 34 | - $rules['amount'] = 'required'; |
|
| 34 | + $rules['amount'] = 'required'; |
|
| 35 | 35 | } |
| 36 | 36 | |
| 37 | 37 | return $rules; |
@@ -82,7 +82,7 @@ discard block |
||
| 82 | 82 | |
| 83 | 83 | function selectOneByShopIdAndId($shopId, $AmountOptionId) |
| 84 | 84 | { |
| 85 | - $result = $this->model->with(array('relatedPaymentMethods' => function ($query) { |
|
| 85 | + $result = $this->model->with(array('relatedPaymentMethods' => function($query) { |
|
| 86 | 86 | $query->where('active', '=', 1); |
| 87 | 87 | }))->where('shop_id', '=', $shopId)->where('active', '=', 1)->where('id', '=', $AmountOptionId)->get(); |
| 88 | 88 | |
@@ -39,12 +39,12 @@ discard block |
||
| 39 | 39 | |
| 40 | 40 | function selectOneByShopIdAndSlug($shopId, $slug) |
| 41 | 41 | { |
| 42 | - return $this->model->with(array('productCategory', 'productImages'))->get()->first(); |
|
| 42 | + return $this->model->with(array('productCategory', 'productImages'))->get()->first(); |
|
| 43 | 43 | } |
| 44 | 44 | |
| 45 | 45 | function selectOneByShopIdAndId($shopId, $productAttributeId) |
| 46 | 46 | { |
| 47 | - return $this->model->with(array('productCategory', 'productImages'))->where('id', '=', $productAttributeId)->get()->first(); |
|
| 47 | + return $this->model->with(array('productCategory', 'productImages'))->where('id', '=', $productAttributeId)->get()->first(); |
|
| 48 | 48 | } |
| 49 | 49 | |
| 50 | 50 | |
@@ -67,16 +67,16 @@ discard block |
||
| 67 | 67 | |
| 68 | 68 | public function selectAllByProductCategoryId($productCategoryId, $shopId) |
| 69 | 69 | { |
| 70 | - return $this->model-> |
|
| 71 | - whereHas('product', function ($query) use ($productCategoryId, $shopId) { |
|
| 70 | + return $this->model-> |
|
| 71 | + whereHas('product', function ($query) use ($productCategoryId, $shopId) { |
|
| 72 | 72 | $query->where('product_category_id', '=', $productCategoryId); |
| 73 | 73 | $query->where('active', '=', 1); |
| 74 | 74 | $query->where('shop_id', '=', $shopId); |
| 75 | - })->with(array('combinations' => function ($q) { |
|
| 75 | + })->with(array('combinations' => function ($q) { |
|
| 76 | 76 | $q->with(array('attribute' => function ($q) { |
| 77 | 77 | $q->with(array('attributeGroup')); |
| 78 | 78 | })); |
| 79 | - }))->get(); |
|
| 79 | + }))->get(); |
|
| 80 | 80 | } |
| 81 | 81 | |
| 82 | 82 | public function increaseAmounts($products) |
@@ -114,7 +114,7 @@ discard block |
||
| 114 | 114 | } |
| 115 | 115 | |
| 116 | 116 | function getProductAttribute($product, $productAttributeId, $secondAttributeId = false) { |
| 117 | - $productAttribute = $this->model->where('product_id', '=', $product->id) |
|
| 117 | + $productAttribute = $this->model->where('product_id', '=', $product->id) |
|
| 118 | 118 | ->whereHas('combinations', function ($query) use ($productAttributeId, $secondAttributeId) { |
| 119 | 119 | if ($productAttributeId) { |
| 120 | 120 | $query->where('attribute_id', '=', $productAttributeId); |
@@ -30,8 +30,8 @@ discard block |
||
| 30 | 30 | |
| 31 | 31 | public function selectAllByShopIdAndProductId($shopId, $productId) |
| 32 | 32 | { |
| 33 | - return $this->model->select('id')->where('product_id', '=', $productId)->with(array('combinations' => function ($query) { |
|
| 34 | - $query->with(array('attribute' => function ($query) { |
|
| 33 | + return $this->model->select('id')->where('product_id', '=', $productId)->with(array('combinations' => function($query) { |
|
| 34 | + $query->with(array('attribute' => function($query) { |
|
| 35 | 35 | $query->with(array('attributeGroup')); |
| 36 | 36 | })); |
| 37 | 37 | }))->get(); |
@@ -68,12 +68,12 @@ discard block |
||
| 68 | 68 | public function selectAllByProductCategoryId($productCategoryId, $shopId) |
| 69 | 69 | { |
| 70 | 70 | return $this->model-> |
| 71 | - whereHas('product', function ($query) use ($productCategoryId, $shopId) { |
|
| 71 | + whereHas('product', function($query) use ($productCategoryId, $shopId) { |
|
| 72 | 72 | $query->where('product_category_id', '=', $productCategoryId); |
| 73 | 73 | $query->where('active', '=', 1); |
| 74 | 74 | $query->where('shop_id', '=', $shopId); |
| 75 | - })->with(array('combinations' => function ($q) { |
|
| 76 | - $q->with(array('attribute' => function ($q) { |
|
| 75 | + })->with(array('combinations' => function($q) { |
|
| 76 | + $q->with(array('attribute' => function($q) { |
|
| 77 | 77 | $q->with(array('attributeGroup')); |
| 78 | 78 | })); |
| 79 | 79 | }))->get(); |
@@ -115,18 +115,18 @@ discard block |
||
| 115 | 115 | |
| 116 | 116 | function getProductAttribute($product, $productAttributeId, $secondAttributeId = false) { |
| 117 | 117 | $productAttribute = $this->model->where('product_id', '=', $product->id) |
| 118 | - ->whereHas('combinations', function ($query) use ($productAttributeId, $secondAttributeId) { |
|
| 118 | + ->whereHas('combinations', function($query) use ($productAttributeId, $secondAttributeId) { |
|
| 119 | 119 | if ($productAttributeId) { |
| 120 | 120 | $query->where('attribute_id', '=', $productAttributeId); |
| 121 | 121 | } |
| 122 | 122 | }) |
| 123 | - ->whereHas('combinations', function ($query) use ($secondAttributeId) { |
|
| 123 | + ->whereHas('combinations', function($query) use ($secondAttributeId) { |
|
| 124 | 124 | if ($secondAttributeId) { |
| 125 | 125 | $query->where('attribute_id', '=', $secondAttributeId); |
| 126 | 126 | } |
| 127 | 127 | }) |
| 128 | - ->with(array('combinations' => function ($query) { |
|
| 129 | - $query->with(array('attribute' => function ($query) { |
|
| 128 | + ->with(array('combinations' => function($query) { |
|
| 129 | + $query->with(array('attribute' => function($query) { |
|
| 130 | 130 | $query->with(array('attributeGroup')); |
| 131 | 131 | })); |
| 132 | 132 | })) |
@@ -15,7 +15,7 @@ |
||
| 15 | 15 | protected $table = 'product_amount_option'; |
| 16 | 16 | |
| 17 | 17 | // Add the 'avatar' attachment to the fillable array so that it's mass-assignable on this model. |
| 18 | - protected $fillable = ['product_id', 'amount', 'discount_type', 'discount_value', 'discount_start_date', 'discount_end_date', 'modified_by_user_id']; |
|
| 18 | + protected $fillable = ['product_id', 'amount', 'discount_type', 'discount_value', 'discount_start_date', 'discount_end_date', 'modified_by_user_id']; |
|
| 19 | 19 | |
| 20 | 20 | |
| 21 | 21 | |