/**
* Update the specified resource in storage.
*
* @param int $id
*
* @return Response
*/
public function update($id, Request $request)
{
$product = Product::findOrFail($id);
$product->update($request->all());
Session::flash('flash_message', 'Product updated!');
return redirect('products');
}
/**
* Update the specified resource in storage.
*
* @param int $id
*
* @return Response
*/
public function update($id, Request $request)
{
$this->validate($request, ['name' => 'required', 'description' => 'required', 'category_id' => 'required', 'purchase_price' => 'required', 'price' => 'required']);
$product = Product::findOrFail($id);
$product->update($request->all());
Session::flash('flash_message', 'Product updated!');
return redirect('backoffice/products');
}
public function showProduct(Request $request, $id)
{
$product = Product::findOrFail($id);
$active_menu = '';
$topics = Topic::getProductTopics($id);
$product_detail_topic = $product->detailTopic;
return view('product', compact(['product', 'active_menu', 'topics', 'product_detail_topic']));
}
public function update(Request $request, $id)
{
$product = Product::findOrFail($id);
$data = $request->only(['', '', '', '']);
$product->fill($data);
$product->save();
return redirect()->action('ProductController@index');
//PUT /resource/1
//
}
/**
* Store a newly created resource in storage.
*
* @param Request $request
* @return Response|null
*/
public function store(Request $request)
{
/**
* @var $user \App\User
*/
$user = \Auth::user();
if (!$user) {
return null;
}
$product_id = $request->get('product_id');
$product_model = \App\Models\Product::findOrFail($product_id);
$sql = 'INSERT IGNORE INTO ' . \App\Models\OrderedProduct::TABLE . ' (created_at, user_id, product_id, catalog_id, is_deferred) ' . 'VALUES (now(), ?, ?, ?, 1)';
\DB::insert($sql, [$user->id, $product_id, $product_model->catalog_id]);
return ['calls' => [['call' => 'updateHtmlContext', 'params' => ['#product-mini-item-' . $product_id, view('catalog.product_mini_item', ['product' => $product_model])->render()]], ['call' => 'updateHtmlContext', 'params' => ['#basket-mini-box', view('basket.mini_box')->render()]], ['call' => 'updateHtmlContext', 'params' => ['#basket-orders-container', view('basket.orders_items')->render()]]]];
}
/**
* Store a newly created resource in storage.
*
* @param Request $request
* @return Response|null
*/
public function store(Request $request)
{
/**
* @var $user \App\User
*/
$user = \Auth::user();
if (!$user) {
return null;
}
$product_id = $request->get('product_id');
$product_model = \App\Models\Product::findOrFail($product_id);
$sql = 'INSERT INTO ' . \App\Models\OrderedProduct::TABLE . ' (created_at, user_id, product_id, catalog_id, price, quantity) ' . 'VALUES (now(), ?, ?, ?, ?, ?) ON DUPLICATE KEY UPDATE quantity = quantity + ?, updated_at = now()';
$public_price = $product_model->getPublicPrice();
$quantity = $request->get('quantity');
\DB::insert($sql, [$user->id, $product_id, $product_model->catalog_id, $public_price, $quantity, $quantity]);
return ['calls' => [['call' => 'updateHtmlContext', 'params' => ['#product-mini-item-' . $product_id, view('catalog.product_mini_item', ['product' => $product_model])->render()]], ['call' => 'updateHtmlContext', 'params' => ['#basket-mini-box', view('basket.mini_box')->render()]], ['call' => 'updateHtmlContext', 'params' => ['#basket-orders-container', view('basket.orders_items')->render()]]]];
}
/**
* Display the specified resource.
*
* @param int $id
* @return Response
*/
public function show($id)
{
$product = Product::findOrFail($id);
$rating_cont = Comment::where('product_id', '=', $product->id)->count();
$checked_rating_count = $rating_cont > 0 ? $rating_cont : 1;
$five_star = Comment::where('product_id', '=', $product->id)->where('rating', '=', '5')->count() * 100 / $checked_rating_count;
$four_star = Comment::where('product_id', '=', $product->id)->where('rating', '=', '4')->count() * 100 / $checked_rating_count;
$three_star = Comment::where('product_id', '=', $product->id)->where('rating', '=', '3')->count() * 100 / $checked_rating_count;
$two_star = Comment::where('product_id', '=', $product->id)->where('rating', '=', '2')->count() * 100 / $checked_rating_count;
$one_star = Comment::where('product_id', '=', $product->id)->where('rating', '=', '1')->count() * 100 / $checked_rating_count;
$owner = $product->owner();
$mods = $product->mods();
if (empty($product)) {
Flash::error('Product not found');
return redirect(route('admin.products.index'));
}
return view('site.products.show')->with(['product' => $product, 'rating_count' => $rating_cont, 'five_star' => $five_star, 'four_star' => $four_star, 'three_star' => $three_star, 'two_star' => $two_star, 'one_star' => $one_star, 'owner' => $owner, 'mods' => $mods]);
}
public static function getActualOffersProducts()
{
return \App\Models\ProductInPurchase::paginate(20);
return \App\Models\Product::where('status', '=', 1)->paginate(20);
$sql = "select ps.product_id\n from catalogs ct\n join products_offers ps on ct.id = ps.catalog_id\n where ct.status = 1 and ps.status = 1 limit 20";
$products_ids_obj_arr = \DB::select($sql);
if (empty($products_ids_obj_arr)) {
return [];
}
$products = [];
foreach ($products_ids_obj_arr as $product_obj) {
$products[] = \App\Models\Product::findOrFail($product_obj->product_id);
}
//print_r($products); exit;
return $products;
$products = \App\Models\Product::where('status', '>', 0)->where('price_1', '>', 0)->paginate(20);
return $products;
}
public function add($id)
{
$order = Order::where('id', '=', $id)->where('user_id', '=', Auth::user()->id)->first();
//$orderItem = $order->items()->findOrFail($id);
//$productId = $order->items()->findOrFail($itemId);
$orderItem = $order->items()->where('product_id', '=', (int) Input::get("product_id"))->first();
if ($orderItem) {
$orderItem->quantity += (int) Input::get("quantity");
$orderItem->save();
} else {
$product = Product::findOrFail((int) Input::get("product_id"));
$orderItem = new OrderItem();
$orderItem->order_id = $id;
$orderItem->product_id = $product->id;
$orderItem->price = $product->price;
$orderItem->quantity = (int) Input::get("quantity");
$orderItem->save();
}
$this->recalculateDelivery($order);
return $this->orderToJson($order);
}
/**
* Display Generator Page
* @param $product_id
* @return $this
*/
public function index($product_id)
{
$product = $this->product->findOrFail($product_id);
return view('products.codes.index', compact('product'))->with('codes', $product->codes()->simplePaginate());
}
public function destroy(Request $request, $id)
{
Product::findOrFail($id)->delete();
return redirect()->route('product.index')->with('success_message', 'The product has been successfully deleted.');
}
public function addItem($product_id, $quantity)
{
$product = Product::findOrFail($product_id);
$params = ['order_id' => $this->id, 'product_id' => $product->id, 'quantity' => $quantity, 'price' => $product->price * $quantity];
return OrderItem::create($params);
}
/**
* Update the specified resource in storage.
*
* @param int $id
*
* @return Response
*/
public function update($id, Products $request)
{
$product = Product::findOrFail($id);
$all = $request->all();
if (isset($all['image'])) {
$this->unlink($product['image']);
$all['image'] = $this->upload($all['image']);
}
$product->update($all);
Session::flash('flash_message', 'Product updated!');
return redirect('products-grid/' . $id);
}
/**
* Display the specified resource.
*
* @param int $id
*
* @return Response
*/
public function show($id)
{
$product = Product::findOrFail($id);
return view('frontoffice.products.show', compact('product'));
}
public function edit($id)
{
$product = Product::findOrFail($id);
return view('productStockInitializations.edit', compact('product'));
}
public function edit($id)
{
$data = Product::findOrFail($id);
$select = Category::all('id', 'menu_name');
return view('admin.product.edit', ['data' => $data, 'select' => $select]);
}
public function delete()
{
$count = HasProducts::where("prod_id", Input::get('id'))->count();
if ($count <= 0) {
$prod = Product::findOrFail(Input::get('id'));
$prod->categories()->detach();
$prod->attributes()->detach();
$prod->relatedproducts()->detach();
$prod->upsellproducts()->detach();
$prod->comboproducts()->detach();
$prod->catalogimgs()->detach();
$prod->fabrics()->detach();
$prod->savedlist()->detach();
$prod->delete();
return redirect()->back()->with('message', 'Product deleted successfully!');
} else {
return redirect()->back()->with('message', 'Sorry This Product is Part of a Project! Delete the Project First!');
}
}
@extends('admin.layout')
<?php
$model_id = isset($model_id) ? intval($model_id) : null;
if ($model_id) {
$model = \App\Models\Product::findOrFail($model_id);
} else {
$model = new \App\Models\Product();
}
?>
@section('content')
<link rel="stylesheet" href="/public/fileupload/css/jquery.fileupload.css">
<script src="/public/fileupload/js/vendor/jquery.ui.widget.js"></script>
<script src="/public/fileupload/js/jquery.fileupload.js"></script>
<script src="/public/fileupload/js/jquery.fileupload-process.js"></script>
<style>
.dropdown-menu>li
{ position:relative;
-webkit-user-select: none; /* Chrome/Safari */
-moz-user-select: none; /* Firefox */
-ms-user-select: none; /* IE10+ */
/* Rules below not implemented in browsers yet */
-o-user-select: none;
user-select: none;
cursor:pointer;
}
.dropdown-menu .sub-menu {
left: 100%;
<?php
if (!isset($product_id)) {
return;
}
$product_model = \App\Models\Product::findOrFail($product_id);
?>
@if ($product_model->offers_count == 1)
<h4 style="text-align: center"><strong>{{ $product->getPublicPrice() }}</strong> руб.</h4>
<div class="form-inline">
<input type="text" id="product-quantity-input-{{ $id }}" class="form-control" value="1" style="width: 70px; text-align: center">
<button type="button" class="btn btn-danger" onclick="App.putProductInBasket('{{ $id }}', $('#product-quantity-input-{{ $id }}').val())">
<span class="glyphicon glyphicon-shopping-cart"></span> В корзину
</button>
</div>
@elseif($product_model->offers_count > 1)
<div class="list-group">
@foreach($product_model->getActualProductOffers() as $product_offer)
<div class="list-group-item">
<div class="row">
<div class="col-lg-10">
<h4 class="list-group-item-heading">{{ $product_offer->offer->title }}</h4>
<p class="list-group-item-text">Donec id elit non mi porta gravida at eget metus. Maecenas sed diam eget risus varius blandit.</p>
{{ $product_offer->price }}
</div>
<div class="col-lg-2">
<button type="button" class="btn btn-danger" onclick="App.putProductInBasket('1', $('#product-quantity-input-1').val())">
<span class="glyphicon glyphicon-shopping-cart"></span> В корзину
</button>
/**
* Delete the specified products.
*
* @param $id
* @return \Illuminate\Http\RedirectResponse
*/
public function destroy($id)
{
$product = Product::findOrFail($id)->delete();
//Without database OnDdelete Cascade
//$product->size()->detach($id);
Session::flash('flash_message', 'Product successfully deleted!');
return redirect()->back();
}
/**
* Remove the specified resource from storage.
*
* @param $catalog_id
* @param int $id
* @return Response
*/
public function destroy($catalog_id, $id)
{
$product_model = \App\Models\Product::findOrFail($id);
$catalog_id = $product_model->catalog_id;
$product_model->delete();
return redirect("/admin/{$catalog_id}/product");
}
/**
* Update the specified resource in storage.
*
* @param \Illuminate\Http\Request $request
* @param int $id
* @return \Illuminate\Http\Response
*/
public function update(ProductRequest $request, $id)
{
// dd($request->input());
$product = Product::findOrFail($id);
$product->title = $request->input('title');
$product->product_type_id = $request->input('product_type_id');
$product->length = $request->input('length');
$product->diameter = $request->input('diameter');
$product->weight = $weight = $request->input('weight');
if (!is_numeric($weight)) {
$nmub = explode('/', $weight);
$product->weight = $nmub[1] / $nmub[0];
}
$product->color = $request->input('color');
$product->wholesale_price = $request->input('wholesale_price');
$product->retail_price = $request->input('retail_price');
$product->status = $request->input('status');
$product->update_at = time();
$product->update_by = Auth::user()->id;
$product->update();
Session()->flash('flash_message', 'Data has been Updated');
return redirect('products');
}
