ajax()){
$sales = Sale::latest();
return DataTables::of($sales)
->addIndexColumn()
->addColumn('product',function($sale){
$image = '';
if(!empty($sale->product)){
$image = null;
if(!empty($sale->product->purchase->image)){
$image = '
product->purchase->image).'" alt="image">
';
}
return $sale->product->purchase->product. ' ' . $image;
}
})
->addColumn('total_price',function($sale){
return settings('app_currency','$').' '. $sale->total_price;
})
->addColumn('date',function($row){
return date_format(date_create($row->created_at),'d M, Y');
})
->addColumn('action', function ($row) {
$editbtn = 'id).'" class="editbtn">';
$deletebtn = '';
if (!auth()->user()->hasPermissionTo('edit-sale')) {
$editbtn = '';
}
if (!auth()->user()->hasPermissionTo('destroy-sale')) {
$deletebtn = '';
}
$btn = $editbtn.' '.$deletebtn;
return $btn;
})
->rawColumns(['product','action'])
->make(true);
}
$products = Product::get();
return view('admin.sales.index',compact(
'title','products',
));
}
/**
* Show the form for creating a new resource.
*
* @return \Illuminate\Http\Response
*/
public function create()
{
$title = 'create sales';
$products = Product::get();
return view('admin.sales.create',compact(
'title','products'
));
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(Request $request)
{
$this->validate($request,[
'product'=>'required',
'quantity'=>'required|integer|min:1'
]);
$sold_product = Product::find($request->product);
/**update quantity of
sold item from
purchases
**/
$purchased_item = Purchase::find($sold_product->purchase->id);
$new_quantity = ($purchased_item->quantity) - ($request->quantity);
$notification = '';
if (!($new_quantity < 0)){
$purchased_item->update([
'quantity'=>$new_quantity,
]);
/**
* calcualting item's total price
**/
$total_price = ($request->quantity) * ($sold_product->price);
Sale::create([
'product_id'=>$request->product,
'quantity'=>$request->quantity,
'total_price'=>$total_price,
]);
$notification = notify("Product has been sold");
}
if($new_quantity <=1 && $new_quantity !=0){
// send notification
$product = Purchase::where('quantity', '<=', 1)->first();
event(new PurchaseOutStock($product));
// end of notification
$notification = notify("Product is running out of stock!!!");
}
return redirect()->route('sales.index')->with($notification);
}
/**
* Show the form for editing the specified resource.
*
* @param \app\Models\Sale $sale
* @return \Illuminate\Http\Response
*/
public function edit(Sale $sale)
{
$title = 'edit sale';
$products = Product::get();
return view('admin.sales.edit',compact(
'title','sale','products'
));
}
/**
* Update the specified resource in storage.
*
* @param \Illuminate\Http\Request $request
* @param \app\Models\Sale $sale
* @return \Illuminate\Http\Response
*/
public function update(Request $request, Sale $sale)
{
$this->validate($request,[
'product'=>'required',
'quantity'=>'required|integer|min:1'
]);
$sold_product = Product::find($request->product);
/**
* update quantity of sold item from purchases
**/
$purchased_item = Purchase::find($sold_product->purchase->id);
if(!empty($request->quantity)){
$new_quantity = ($purchased_item->quantity) - ($request->quantity);
}
$new_quantity = $sale->quantity;
$notification = '';
if (!($new_quantity < 0)){
$purchased_item->update([
'quantity'=>$new_quantity,
]);
/**
* calcualting item's total price
**/
if(!empty($request->quantity)){
$total_price = ($request->quantity) * ($sold_product->price);
}
$total_price = $sale->total_price;
$sale->update([
'product_id'=>$request->product,
'quantity'=>$request->quantity,
'total_price'=>$total_price,
]);
$notification = notify("Product has been updated");
}
if($new_quantity <=1 && $new_quantity !=0){
// send notification
$product = Purchase::where('quantity', '<=', 1)->first();
event(new PurchaseOutStock($product));
// end of notification
$notification = notify("Product is running out of stock!!!");
}
return redirect()->route('sales.index')->with($notification);
}
/**
* Generate sales reports index
*
* @return \Illuminate\Http\Response
*/
public function reports(Request $request){
$title = 'sales reports';
return view('admin.sales.reports',compact(
'title'
));
}
/**
* Generate sales report form post
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function generateReport(Request $request){
$this->validate($request,[
'from_date' => 'required',
'to_date' => 'required',
]);
$title = 'sales reports';
$sales = Sale::whereBetween(DB::raw('DATE(created_at)'), array($request->from_date, $request->to_date))->get();
return view('admin.sales.reports',compact(
'sales','title'
));
}
/**
* Remove the specified resource from storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function destroy(Request $request)
{
return Sale::findOrFail($request->id)->delete();
}
}