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 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 delete($id)
{
$product = Product::find($id);
$category = Category::where('id', $product->category_id)->first();
$inOrder = OrderDetail::where('product_id', $id)->where('review', null)->get();
$reviews = Reviews::where('product_id', $id)->get();
$subcategory = Subcategory::where('id', $product->subcategory_id)->first();
if (!$product) {
return redirect('master/produk/list')->with('error', 'Data tidak ada');
} else {
$image = unserialize($product->image);
$path = base_path() . '/storage/photo_product/';
if (count($inOrder) > 0) {
$product->status = 'unactive';
if ($product->save()) {
return redirect('master/produk/list')->with('success', 'Produk tidak bisa di hapus karena masih dalam order, produk sementara di non aktifkan');
} else {
return redirect('master/produk/list')->with('error', '404');
}
} elseif (count($inOrder) == 0) {
if ($product->delete()) {
foreach ($reviews as $review) {
$reviews->delete();
}
foreach ($inOrder as $order_product) {
foreach ($order_product as $orders) {
$PaymentConfirmation = PaymentConfirmation::where('order_id', $orders->id)->first();
$PaymentConfirmation->delete();
}
$orders = Order::where('id', $order_product->order_id)->get();
$orders->delete();
}
$total_product = $category->total_product - 1;
$category->total_product = $total_product;
$category->save();
$total_subcategory = $subcategory->total_product - 1;
$subcategory->total_product = $total_subcategory;
$subcategory->save();
if (!$image == NULL) {
foreach ($image as $image) {
File::delete($path . $image);
}
}
return redirect('master/produk/list')->with('success', 'Produk ' . $product->name . ' Berhasil Dihapus');
} else {
return redirect('master/produk/list')->with('error', '404');
}
}
}
}
public function modal_detail(Request $request)
{
$data['detail'] = OrderDetail::where('order_id', $request->orderid)->get();
return view('order.modal_detail')->with('data', $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();
}
