public function store(Request $request)
{
try {
DB::transaction(function () use($request) {
$inputs = $request->input();
$user = Auth::user();
$time = time();
$year = CommonHelper::get_current_financial_year();
$order_quantity = 0;
$deliver_quantity = 0;
$products = Product::whereIn('id', array_keys($inputs['quantity']))->get()->toArray();
// dd($products);
foreach ($inputs['quantity'] as $key => $value) {
if ($value > 0) {
$salesDelivery = SalesDeliveryDetail::firstOrNew(['sales_order_id' => $inputs['sales_order_id'], 'product_id' => $key]);
if ($salesDelivery->id) {
$salesDelivery->updated_by = $user->id;
$salesDelivery->updated_at = $time;
$d_quantity = $salesDelivery->delivered_quantity += $inputs['deliver_now'][$key];
$salesDelivery->last_delivered_quantity = $inputs['deliver_now'][$key];
$salesDelivery->save();
} else {
$salesDelivery->sales_order_id = $inputs['sales_order_id'];
$salesDelivery->created_by = $user->id;
$salesDelivery->created_at = $time;
$salesDelivery->status = 2;
//Partial Delivery
$salesDelivery->product_id = $key;
$salesDelivery->order_quantity = $value;
$d_quantity = $salesDelivery->delivered_quantity = $inputs['deliver_now'][$key];
$salesDelivery->last_delivered_quantity = $inputs['deliver_now'][$key];
$salesDelivery->save();
}
if ($d_quantity == $value) {
$salesDelivery->status = 4;
//product delivery completed
$salesDelivery->save();
$salesOrderItem = SalesOrderItem::firstOrNew(['sales_order_id' => $inputs['sales_order_id'], 'product_id' => $key]);
$salesOrderItem->status = 4;
// Sales item Delivery Completed
$salesOrderItem->save();
} else {
$salesDelivery->status = 2;
//Partial Delivery
$salesDelivery->save();
$salesOrderItem = SalesOrderItem::firstOrNew(['sales_order_id' => $inputs['sales_order_id'], 'product_id' => $key]);
$salesOrderItem->status = 2;
//Partial Delivery
$salesOrderItem->save();
}
$deliver_quantity += $d_quantity;
$order_quantity += $value;
$quantity_delivered = $inputs['deliver_now'][$key];
$stocks = Stock::where(['year' => $year, 'stock_type' => Config::get('common.balance_type_intermediate'), 'workspace_id' => $user->workspace_id, 'product_id' => $key])->first();
if ($inputs['unit_type'][$key] == 2) {
foreach ($products as $item) {
if ($item['id'] == $key) {
$quantity_delivered = $quantity_delivered / $item['weight'] * $item['length'];
break;
}
}
}
if ($stocks->quantity < $quantity_delivered) {
Session()->flash('warning_message', 'Insufficient stock.');
throw new \Exception();
}
$stocks->quantity -= $quantity_delivered;
$stocks->updated_by = $user->id;
$stocks->updated_at = $time;
$stocks->update();
}
if ($deliver_quantity == $order_quantity) {
$salesOrder = SalesOrder::find($inputs['sales_order_id']);
$salesOrder->status = 4;
// Sales Delivery Completed
$salesOrder->save();
} else {
$salesOrder = SalesOrder::find($inputs['sales_order_id']);
$salesOrder->status = 2;
//Partial Delivery
$salesOrder->save();
}
}
});
} catch (\Exception $e) {
Session()->flash('error_message', 'Products delivered failed.');
return Redirect::back();
}
Session()->flash('flash_message', 'Products delivered successfully.');
return redirect('salesDelivery');
}
public static function get_delivered_quantity($sales_order_id, $product_id)
{
$result = SalesDeliveryDetail::where(['sales_order_id' => $sales_order_id, 'product_id' => $product_id])->first();
return $result->delivered_quantity;
}
