/**
* Remove the specified resource from storage.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function destroy($id)
{
$saleOrders = SaleOrder::where('id', $id)->first();
$products = SaleOrderDetail::whereSalesOrderId($id)->get();
if ($saleOrders->is_pos == 1) {
foreach ($products as $product) {
Inventory::wherePointOfSalesId($id)->delete();
$fields = ['product_id' => $product->product_id, 'location_id' => \Auth::user()->location];
$checkIfSaleExistingProduct = InventoryTotal::where($fields)->first();
$inventoryTotalDetail = $inventoryTotals = array();
$inventoryTotals = new InventoryTotal();
$inventoryTotal['total_qty'] = $checkIfSaleExistingProduct['total_qty'] + $product->qty * $product->conversion;
$inventoryTotal['created_by'] = \Auth::user()->id;
$inventoryTotal['updated_by'] = \Auth::user()->id;
$inventoryTotals->where($fields)->update($inventoryTotal);
$inventoryTotalDetails = new InventoryTotalDetail();
$fieldNews = ['product_id' => $product->product_id, 'location_id' => \Auth::user()->location, 'date' => date('Y-m-d')];
$checkIfSaleExistingProductInventoryDetail = InventoryTotalDetail::where($fieldNews)->first();
$inventoryTotalDetail['total_pos'] = $checkIfSaleExistingProductInventoryDetail['total_qty'] - $product->qty * $product->conversion;
$inventoryTotalDetail['created_by'] = \Auth::user()->id;
$inventoryTotalDetail['updated_by'] = \Auth::user()->id;
$inventoryTotalDetails->where($fieldNews)->update($inventoryTotalDetail);
}
} else {
Inventory::whereSalesOrderId($id)->delete();
}
SaleOrderReceipt::whereSalesOrderId($id)->delete();
SaleOrderDetail::whereSalesOrderId($id)->delete();
$saleOrders = SaleOrder::find($id);
$saleOrders->delete();
return Redirect::route('saleOrders.index')->with('flash_notice', 'You are successfully delete!');
}
