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");
}
}
