public function payment(Request $request) { $rules = array('no_invoice' => 'required', 'account_name' => 'required', 'bank_account' => 'required', 'bank_name' => 'required', 'admin_account' => 'required', 'total_transfer' => 'required', 'transfer_date' => 'required'); $validator = Validator::make($request->all(), $rules); if (!$validator->fails()) { $order = Order::where('no_invoice', $request->no_invoice)->first(); if (!is_null($order)) { $payment = new PaymentConfirmation(); $payment->no_invoice = $order->no_invoice; $payment->account_name = $request->account_name; $payment->bank_account = $request->bank_account; $payment->bank_name = $request->bank_name; $payment->admin_account = $request->admin_account; $payment->total_transfer = $request->total_transfer; $payment->transfer_date = $request->transfer_date; $payment->order_id = $order->id; $payment->save(); $order->order_status = "Telah Dibayar"; $order->save(); $orderdetail = OrderDetail::where('order_id', $order->id)->get(); foreach ($orderdetail as $detail) { $product = Product::where('id', $detail->product_id)->first(); $product->sold += $detail->quantity; $product->save(); } return redirect('konfirmasi_pembayaran')->with('success', 'Konfirmasi berhasil .Kami akan mengecek pembayaran Anda'); } else { return redirect('konfirmasi_pembayaran')->with('failed', 'Maaf no invoice tidak terdaftar'); } } else { return redirect('konfirmasi_pembayaran')->with('failed', 'Silahkan isi form sesuai yang disediakan'); } }
public function list_product() { $this->data['css_assets'] = Assets::load('css', ['admin_bootstrap', 'admin_css', 'font-awesome', 'skins', 'dataTables_css']); $this->data['js_assets'] = Assets::load('js', ['jquery', 'admin_js', 'admin_bootstrap-js', 'slimscroll', 'fastclick', 'dataTables_js', 'dataTables_bootsjs']); $this->data['title'] = 'Product | List'; $this->data['product'] = Product::where('category_id', 1)->orderBy('created_at', 'DESC')->get(); $this->data['category'] = Category::get(); $this->data['distributor'] = Distributor::get(); return view('admin_layout')->with('data', $this->data)->nest('content', 'admin/product/list_produk', array('data' => $this->data)); }
public function index() { $this->data['css_assets'] = Assets::load('css', ['lib-bootstrap', 'style', 'font-awesome', 'font-awesome-min', 'flexslider', 'color-schemes-core', 'color-schemes-turquoise', 'jquery-parallax', 'bootstrap-responsive', 'font-family']); $this->data['js_assets'] = Assets::load('js', ['jquery', 'jquery-ui', 'jquery-easing', 'bootstrap-min-lib', 'jquery-isotope', 'jquery-flexslider', 'jquery.elevatezoom', 'jquery-sharrre', 'jquery-gmap3', 'imagesloaded', 'la_boutique', 'jquery-cookie', 'jquery-parallax-lib']); $this->data['title'] = 'Home'; $this->data['category'] = Category::get(); $this->data['product'] = Product::where('status', 'publish')->orderBy('created_at', 'DESC')->limit(5)->get(); $this->data['sold'] = Product::where('status', 'publish')->orderBy('sold', 'DESC')->limit(5)->get(); $this->data['banner'] = Option::where('meta_key', 'banner_home')->first(); return view('main_layout')->with('data', $this->data)->nest('content', 'home', array('data' => $this->data)); }
public function delete($id) { $products = Product::where('distributor_id', $id)->where('status', 'publish')->get(); if ($products != '') { foreach ($products as $product) { $order = OrderDetail::where('product_id', $product->id)->where('review', '')->first(); if ($order != '') { return redirect('master/distributor/list')->with('error', 'Maaf masih terdapat order dari produk distributor yang belum selesai'); } } } if ($item != '') { return redirect('master/distributor/list')->with('error', 'Maaf masih terdapat produk distributor yang aktif. Silahkan non-aktifkan'); } else { Distributor::find($id)->delete(); return redirect('master/distributor/list'); } }
public function ask_product(Request $request) { $user = Sentinel::getUser(); $product = Product::where('id', $request->product_id)->first(); $ask = new Ask(); if ($user->first_name != '') { $ask->name = ucwords($user->first_name) . " " . ucwords($user->last_name); } else { $ask->name = "guest"; } $ask->email = $request->email; $ask->type = "pertanyaan"; $ask->ask = "Produk " . ucwords($product->name) . " - " . $request->message; $ask->status = 0; $ask->save(); }
public function sort_search(Request $request) { if ($request->sortby == 'price' || $request->sortby == 'name') { $sort = 'ASC'; } else { $sort = 'DESC'; } if ($request->sortby == 'pricedesc') { $request->sortby = 'price'; } if ($request->category_id != '') { $this->data['query'] = Product::where('name', 'like', '%' . $request->search . '%')->where('category_id', $request->category_id)->where('status', 'publish')->orderBy($request->sortby, $sort)->Paginate(20); } else { $this->data['query'] = Product::where('name', 'like', '%' . $request->search . '%')->where('status', 'publish')->orderBy($request->sortby, $sort)->Paginate(20); } return view('search_content')->with('data', $this->data); }
public function get_product_by_status(Request $request) { $this->data['product'] = Product::where('status', $request->status); if ($request->category_id) { $this->data['product']->where('category_id', $request->category_id); } if ($request->subcategory_id) { $this->data['product']->where('subcategory_id', $request->subcategory_id); } $this->data['product'] = $this->data['product']->get(); return view('admin/product/category_product')->with('data', $this->data); }
public function add_review(Request $request) { $order = Order::where('id', $request->order_id)->first(); $order->order_status = 'Diterima'; $order->save(); $orderdetail = OrderDetail::where('order_id', $request->order_id)->where('product_id', $request->product_id)->get(); foreach ($orderdetail as $value) { $value->review = 'reviewed'; $value->save(); } $product = Product::where('id', $request->product_id)->first(); $product->rating += $request->rating; $product->save(); $review = new Reviews(); $review->user_id = Sentinel::getUser()->id; $review->product_id = $product->id; $review->rating = $request->rating; $review->review = $request->review; $review->status = 'publish'; $review->save(); }