public function View_order_details($order_id, $user_id)
 {
     $parent_category_layout = $this->parent_category_layout;
     $user_information = userRegister::select('full_name')->where('id', $user_id)->first();
     $orders = orders::with('order_details')->select('id', 'user_id', '_token', 'order_date', 'total')->where('id', $order_id)->first();
     $orders['user_index'] = $user_information;
     foreach ($orders->order_details as $key => $order) {
         $orders->order_details[$key]['product_name'] = products::select('name')->where('id', $order->product_id)->first();
     }
     return view('admin/order_details/view_order_details', compact('parent_category_layout', 'orders'));
 }
 /**
  * Remove the specified resource from storage.
  *
  * @param  int $id
  * @return Response
  */
 public function DeleteAction($id)
 {
     $product = products::find($id);
     if ($product) {
         foreach ($product->image as $img) {
             @unlink(public_path() . '/images/' . $img->path);
             $img->delete();
         }
         $product->delete();
         return redirect()->route('cake/list')->with('message', Lang::get('response.CUSTOM_MESSAGE_SUCCESS', ['message' => 'The product table item has been successfully deleted']));
     }
     return redirect()->route('cake/list')->with('message', Lang::get('response.CUSTOM_MESSAGE_ALERT', ['message' => 'The product table item can not delete']));
 }
 public function AccessoriesApi()
 {
     $details = products::select('products.id', 'products.name as product_name', 'images.path', 'images.caption')->leftJoin('image_product', 'image_product.product_id', '=', 'products.id')->leftJoin('images', 'images.id', '=', 'image_product.image_id')->leftJoin('category_product', 'category_product.product_id', '=', 'products.id')->leftJoin('categories', 'categories.id', '=', 'category_product.category_id')->where('categories.id', 2)->get();
     $result = Response::json(array('result' => $details))->header('Content-Type', 'application/json');
     return $result;
 }
 /** Get Product id and find image id*/
 public function ManageOption($id)
 {
     $parent_category_layout = $this->parent_category_layout;
     $product = products::find($id);
     return view('admin/image/image_manage', compact('product', 'parent_category_layout'));
 }