";
				print_r($sales_orders);
				 */

				$product_profiles = DB::table('product_profiles')->get();
				$customerInfo     = CustomerProfile::where('id', $sales_orders->customer_Id)->first();
				$TransactionTerm  = DB::table('transaction_terms')->where('id', '=', $sales_orders->transection_type)->first();

				$costPriceD = array();
				foreach ($sales_details as $value) {
					$costInfo = ProductPriceList::where('order_id', '=', $value->lot_no)->where('product_id', '=', $value->product_id)->first();
					array_push($costPriceD, $costInfo);

				}
				return view('sales.return-details', compact('sales_orders', 'customerInfo', 'sales_details', 'product_profiles', 'costPriceD', 'TransactionTerm'));

			} else {
				Session::flash('message', 'Please Search with valid Invoice Number !');
				return redirect()->back();
			}
		} else {
			return "Sorry you don't have access to this action";
		}

	}

	public function salesReturnConfirm(Request $request) {
		$library = new \App\Library\Library;
		if ($library->check_user_access('sales_edit')) {

			
			$dt   = new DateTime('now', new DateTimezone('Asia/Dhaka'));
			$date = $dt->format('Y-m-d H:i:s');
			if ($request->payment_amount == null) {
				$request->payment_amount = 0;
			}

			$crud       = new \App\Library\Crud;
			$collection = $library->remove_element($request, ['return_order_id', 'return_customer_Id', 'return_order_date', 'return_gross_amount', 'return_return_amount', 'return_amount_paid_customer', 'return_gross_discount', 'return_return_ref', 'return_transection_type', 'return_order_type', 'return_order_type', 'return_employee_id', 'return_gross_vat_amount', 'return_employee_id', 'return_purchase_return', 'return_note', 'status']);
			$collection = $library->add_element($collection, ['return_order_id' => md5($date), 'return_customer_Id' => $request->customer, 'return_employee_id' => Auth::user()->id, 'order_type' => 'sales_return', 'return_pre_order_status' => 2, 'return_order_date' => $date, 'return_gross_amount' => $request->gross_amount, 'return_gross_discount' => $request->gross_discount, 'return_gross_vat_amount' => $request->gross_vat_amount, 'return_return_amount' => $request->net_amount, 'return_amount_paid_customer' => $request->payment_amount, 'return_return_ref' => $request->preorder_ref, 'return_transection_type' => 1, 'return_note' => $request->note]);
			//return dump($collection);

			$crud_result = $crud->InsertValue('SalesRetrunOrder', $collection);
			if (!empty($crud_result)) {
				$order_id   = $crud_result;
				$SalesOrder = new SalesOrder;
				$SalesOrder = SalesOrder::where('id', '=', $request->preorder_ref)->first();
				if (!empty($SalesOrder)) {
					$SalesOrder->return_ref = $order_id;
					$SalesOrder->save();
				}

			} else {
				return 'something wrong';
			}

			//insert all information to Sales Details Table
			if ($request->product_id != null) {
				for ($i = 0; $i < count($request->product_id); $i++) {
					$SalesDetails                 = new SalesDetails();
					$SalesDetails->order_id       = $order_id;
					$SalesDetails->product_id     = $request->product_id[$i];
					$SalesDetails->unique_barcode = $request->barcode[$i];
					$SalesDetails->qty            = $request->qty[$i];
					$SalesDetails->sales_price    = $request->sales_price[$i];
					$SalesDetails->vat_rate       = $request->vat_rate[$i];
					$SalesDetails->discount_rate  = $request->discount_rate[$i];
					$SalesDetails->line_total     = $request->sales_price_line_total[$i];
					$SalesDetails->lot_no         = $request->product_lot_no[$i];
					$SalesDetails->status         = 0;
					$SalesDetails->save();

					//update Inventory table when add product in sales form
					$Inventory          = new Inventory();
					$previous_allocated = Inventory::where('product_id', '=', $request->product_id[$i])->first();
					if (!empty($previous_allocated)) {
						$on_order_adjustment              = $previous_allocated->on_order-$request->qty[$i];
						$available_adjustment             = $previous_allocated->available+$request->quantity;
						$sales_return_adjustment          = $previous_allocated->sales_return+$request->quantity;
						$previous_allocated->on_order     = $on_order_adjustment;
						$previous_allocated->available    = $available_adjustment;
						$previous_allocated->sales_return = $sales_return_adjustment;
						$previous_allocated->save();
					} else {
						return "Inventory table not updated";
					}

					$CostofGoodsSoldAccounts                   = new CostofGoodsSoldAccounts();
					$CostofGoodsSoldAccounts->order_id         = $order_id;
					$CostofGoodsSoldAccounts->account_no       = $request->product_id[$i];
					$CostofGoodsSoldAccounts->transection_date = $date;
					$CostofGoodsSoldAccounts->credit           = $request->cost_price_line_total[$i];
					$CostofGoodsSoldAccounts->created_by       = Auth::user()->id;
					$CostofGoodsSoldAccounts->save();

				}
			}


			//product price list table qty update maintaining FIFO of LIFO
			//we are maintain FIFO method for inventory
			//Old purchase product sales first and it we ensure using order_id in product_price_list table
			//inventory table update
			if ($request->product_lot_no != null) {
				for ($i = 0; $i < count($request->product_lot_no); $i++) {

					$ProductPriceList = new ProductPriceList();
					$previous_list    = ProductPriceList::where('product_id', '=', $request->product_id[$i])->where('order_id', '=', $request->product_lot_no[$i])->first();
					
					if (!empty($previous_list)) {
						$list_adjustment       = $previous_list->qty+$request->qty[$i];
						$previous_list->qty    = $list_adjustment;
						$previous_list->status = 1;
						$previous_list->save();
					}

				}

			}

			//if sales discount paid then data insert into Sales Discount
			if ($request->discount_line_total != null && $request->discount_line_total > 0) {
				for ($i = 0; $i < count($request->discount_line_total); $i++) {
					$SalesDiscountAccount                   = new SalesDiscountAccount();
					$SalesDiscountAccount->order_id         = $order_id;
					$SalesDiscountAccount->account_no       = $request->product_id[$i];
					$SalesDiscountAccount->transection_date = $date;
					$SalesDiscountAccount->credit           = $request->discount_line_total[$i];
					$SalesDiscountAccount->created_by       = Auth::user()->id;
					$SalesDiscountAccount->save();
				}
			}

			//if vat Amount Received from Customer then data insert into Vat Accounts Table
			if ($request->vat_line_total != null && $request->vat_line_total > 0) {
				for ($i = 0; $i < count($request->vat_line_total); $i++) {
					$VatAccounts                   = new VatAccounts();
					$VatAccounts->order_id         = $order_id;
					$VatAccounts->account_no       = $request->product_id[$i];
					$VatAccounts->transection_date = $date;
					$VatAccounts->debit            = $request->vat_line_total[$i];
					$VatAccounts->created_by       = Auth::user()->id;
					$VatAccounts->save();
				}
			}

			//if receved amount  not empty then data insert onto Cash Book Accoutns table
			if ($request->payment_amount != null && $request->payment_amount > 0) {

				$CashBook                   = new CashBook();
				//$CashBook->account_no       = $request->customer;
				$CashBook->account_no = $request->cash_book ?? 1;
				$CashBook->own_account_no = $request->customer;
				$CashBook->refeance_no      = $order_id;
				$CashBook->transection_date = $date;
				if ($request->net_amount == $request->payment_amount) {
					$CashBook->credit = $request->payment_amount;
				} elseif ($request->net_amount > $request->payment_amount) {
					$CashBook->credit = $request->payment_amount;
				} elseif ($request->net_amount < $request->payment_amount) {
					$CashBook->credit = $request->net_amount;
				}
				$CashBook->description = $request->note;
				$CashBook->person_type = 'customer';
				$CashBook->created_by  = Auth::user()->id;

				$CashBook->save();

			}
			//data insert into sales Accounts
			if ($request->order_id != null) {
				$SalesAccounts                   = new SalesAccounts();
				$SalesAccounts->order_id         = $order_id;
				$SalesAccounts->account_no       = $request->customer;
				$SalesAccounts->transection_date = $date;
				$SalesAccounts->debit            = $request->net_amount;
				$SalesAccounts->note             = $request->note;
				$SalesAccounts->created_by       = Auth::user()->id;
				$SalesAccounts->save();

			}

			return redirect('return-list');
		} else {
			return "Sorry you don't have access to this action";
		}

	}

}