public function ProductList() { $newBillCount = count(Bill::NewBill()); $products = Products::select(["id", "name", "price"])->paginate(100); $products->setPath("list"); return view("admin.sanpham.list", compact("products", "newBillCount")); }
/** * Display a listing of the resource. * * @return Response */ public function index() { // $products = Products::latest()->get(); $products = Products::select(DB::raw('customers.name as customersname,products.id as id,products.name as productname , products.alish,products.satish,products.income'))->leftjoin('Customers', 'Customers.id', '=', 'products.CustomerId')->orderBy('products.id', 'DESC')->get(); return view('products.index', compact('products')); }
public function Finish(Request $request) { if (Auth::check() && Session::has("cart")) { $payment_method = (int) $request->get("method"); $cart = new CartController(); $products = $cart->getProduct(); $subTotal = $cart->subTotalPrice($products); $discounted = 0; //phan tram dc giam if (Session::has("codeDiscount")) { $code = Session::get("codeDiscount"); $discounted = DiscountCode::changeCodeToPercent($code); $total = $cart->totalPrice($subTotal, null, $code); } else { $total = $cart->totalPrice($subTotal, null, null); } $customerID = Auth::user()->id; $customerInfoID = Auth::user()->default_info_id; /* Status : * 1: done * 2:chua thanh toan * 3: moi */ $bill = Bill::create(["total" => $total, "customer_id" => $customerID, "customer_info_id" => $customerInfoID, "status" => 3, "payment_method" => $payment_method, "discounted" => $discounted]); $billID = $bill->id; foreach ($products as $item) { $price = $item->price * (100 - $item->percent) / 100; //don gia billDetail::create(["bill_id" => $billID, "products_id" => $item->id, "price" => $price, "amount" => $item->so_luong]); $count = Products::select(["count"])->where("id", $item->id)->first(); // so luong da~ bán $count->count += $item->so_luong; Products::where("id", $item->id)->update(["count" => $count->count]); //update so luong } /*Xoa discound code*/ if (Session::has("codeDiscount")) { $code = Session::get("codeDiscount"); DiscountCode::deleteCode($code); Session::forget("codeDiscount"); } /* Xoá cart */ Session::forget("cart"); /*Send mail*/ $this->sendMail($billID); /**********/ return redirect()->route("thanhtoan.thongtin.hoadon", $billID); } else { return redirect()->route("home"); } }