public static function getSmallestPrice($product, $includeSize = false) { $sizew = $sizeh = $bleed = 0; if (!isset($product->size_lists)) { $smallestSize = SizeList::where('product_id', $product->id)->cacheTags(['size_lists', 'products'])->orderBy('size_lists.sizew', 'asc')->orderBy('size_lists.sizeh', 'asc')->remember(30)->first(); if (is_object($smallestSize)) { $sizew = $smallestSize->sizew; $sizeh = $smallestSize->sizeh; } } else { $min = []; foreach ($product->size_lists as $size_list) { if (!isset($min->sizew) || $min->sizew > $size_list->sizew) { $min = $size_list; } } } $smallestDepth = ProductOption::select('name')->whereIn('id', function ($query) use($product) { $query->select('optionable_id')->from('optionables')->where('product_id', $product->id)->where('optionable_type', 'ProductOption'); })->whereIn('option_group_id', function ($query) { $query->select('id')->from('option_groups')->where('key', 'depth'); })->orderBy('key', 'asc')->first(); if (is_object($smallestDepth)) { $bleed = (double) str_replace('" Box', '', $smallestDepth->name); } if ($sizew && $sizeh || $bleed) { $product->sizew = $sizew; $product->sizeh = $sizeh; $product->bleed = $bleed; $price = JTProduct::getPrice($product); $sellPrice = $price['sell_price']; } else { $sellPrice = JTProduct::getDefaultPrice($product); } if ($includeSize) { return ['sell_price' => $sellPrice, 'sizew' => $sizew, 'sizeh' => $sizeh]; } return $sellPrice; }
public function listJtProducts() { if (!Request::ajax()) { return App::abort(404); } $start = Input::has('start') ? (int) Input::get('start') : 0; $length = Input::has('length') ? Input::get('length') : 10; $search = Input::has('search') ? Input::get('search') : []; $products = JTProduct::select('_id', 'code', 'sku', 'name', 'product_type', 'product_category', 'oum', 'sell_by', 'sell_price')->where('deleted', false)->where('name', 'not regexp', '/^blank/i'); if (!empty($search)) { foreach ($search as $key => $value) { if (empty($value)) { continue; } $value = ltrim(rtrim($value)); if ($key == 'code') { $products->where($key, (int) $value); } else { $products->where($key, 'like', '%' . $value . '%'); } } } $order = Input::has('order') ? Input::get('order') : []; if (!empty($order)) { $columns = Input::has('columns') ? Input::get('columns') : []; foreach ($order as $value) { $column = $value['column']; if (!isset($columns[$column]['name']) || empty($columns[$column]['name'])) { continue; } $products->orderBy($columns[$column]['name'], $value['dir'] == 'asc' ? 'asc' : 'desc'); } } $count = $products->count(); if ($length > 0) { $products = $products->skip($start)->take($length); } $arrProducts = $products->get()->toArray(); $arrReturn = ['draw' => Input::has('draw') ? Input::get('draw') : 1, 'recordsTotal' => JTProduct::where('deleted', false)->count(), 'recordsFiltered' => $count, 'data' => []]; if (!empty($arrProducts)) { foreach ($arrProducts as $product) { $arrReturn['data'][] = array(++$start, $product['_id'], isset($product['code']) ? $product['code'] : '', $product['sku'], isset($product['name']) ? $product['name'] : '', isset($product['product_type']) ? $product['product_type'] : '', isset($product['product_category']) ? $product['product_category'] : '', isset($product['oum']) ? $product['oum'] : '', isset($product['sell_by']) ? $product['sell_by'] : '', number_format((double) $product['sell_price'], 2)); } } $response = Response::json($arrReturn); $response->header('Content-Type', 'application/json'); return $response; }
public function caculatePrice() { $sku = Input::has('sku') ? Input::get('sku') : 'ROL-663'; $sizew = Input::has('sizew') ? Input::get('sizew') : 0; $sizeh = Input::has('sizeh') ? Input::get('sizeh') : 0; $quantity = Input::has('order_qty') ? Input::get('order_qty') : 1; $product = new VIImage(); $product->sizew = $sizew; $product->sizeh = $sizeh; $groups = ProductOptionGroup::select('id', 'name', 'key')->get(); foreach ($groups as $value) { $option_key = Input::has($value->key) ? Input::get($value->key) : ''; if ($option_key != '') { //echo 'option_key: '.$option_key.'<br/>'; $obj_option = ProductOption::where('key', $option_key)->first(); $option = floatval($obj_option->name); if ($value->key == 'depth') { $product->bleed = $option; } else { $key = $value->key; $product->{$key} = $option; } } } // echo '<pre>'; // print_r($product); // echo '</pre>'; // exit; $product->quantity = $quantity; $product->sku = $sku; $price = JTProduct::getPrice($product); if ($product->margin_up) { $biggerPrice = $price['sell_price'] * (1 + $product->margin_up / 100); $arrReturn = ['sell_price' => $price['sell_price'], 'bigger_price' => VIImage::viFormat($biggerPrice), 'amount' => $price['sub_total']]; } else { $arrReturn = ['sell_price' => $price['sell_price'], 'amount' => $price['sub_total']]; } if (Request::ajax()) { $arrReturn = ['status' => 'ok', 'message' => '', 'data' => $arrReturn]; $response = Response::json($arrReturn); $response->header('Content-Type', 'application/json'); return $response; } return false; }