ajax()){
$purchases = Purchase::get();
return DataTables::of($purchases)
->addColumn('product',function($purchase){
$image = '';
if(!empty($purchase->image)){
$image = '
image).'" alt="product">
';
}
return $purchase->product.' ' . $image;
})
->addColumn('category',function($purchase){
if(!empty($purchase->category)){
return $purchase->category->name;
}
})
->addColumn('cost_price',function($purchase){
return settings('app_currency','$'). ' '. $purchase->cost_price;
})
->addColumn('supplier',function($purchase){
return $purchase->supplier->name;
})
->addColumn('expiry_date',function($purchase){
return date_format(date_create($purchase->expiry_date),'d M, Y');
})
->addColumn('action', function ($row) {
$editbtn = 'id).'" class="editbtn">';
$deletebtn = '';
if (!auth()->user()->hasPermissionTo('edit-purchase')) {
$editbtn = '';
}
if (!auth()->user()->hasPermissionTo('destroy-purchase')) {
$deletebtn = '';
}
$btn = $editbtn.' '.$deletebtn;
return $btn;
})
->rawColumns(['product','action'])
->make(true);
}
return view('admin.purchases.index',compact(
'title'
));
}
/**
* Show the form for creating a new resource.
*
* @return \Illuminate\Http\Response
*/
public function create()
{
$title = 'create purchase';
$categories = Category::get();
$suppliers = Supplier::get();
return view('admin.purchases.create',compact(
'title','categories','suppliers'
));
}
/**
* 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|max:200',
'category'=>'required',
'cost_price'=>'required|min:1',
'quantity'=>'required|min:1',
'expiry_date'=>'required',
'supplier'=>'required',
'image'=>'file|image|mimes:jpg,jpeg,png,gif',
]);
$imageName = null;
if($request->hasFile('image')){
$imageName = time().'.'.$request->image->extension();
$request->image->move(public_path('storage/purchases'), $imageName);
}
Purchase::create([
'product'=>$request->product,
'category_id'=>$request->category,
'supplier_id'=>$request->supplier,
'cost_price'=>$request->cost_price,
'quantity'=>$request->quantity,
'expiry_date'=>$request->expiry_date,
'image'=>$imageName,
]);
$notifications = notify("Purchase has been added");
return redirect()->route('purchases.index')->with($notifications);
}
/**
* Show the form for editing the specified resource.
*
* @param \app\Models\Purchase $purchase
* @return \Illuminate\Http\Response
*/
public function edit(Purchase $purchase)
{
$title = 'edit purchase';
$categories = Category::get();
$suppliers = Supplier::get();
return view('admin.purchases.edit',compact(
'title','purchase','categories','suppliers'
));
}
/**
* Update the specified resource in storage.
*
* @param \Illuminate\Http\Request $request
* @param \app\Models\Purchase $purchase
* @return \Illuminate\Http\Response
*/
public function update(Request $request, Purchase $purchase)
{
$this->validate($request,[
'product'=>'required|max:200',
'category'=>'required',
'cost_price'=>'required|min:1',
'quantity'=>'required|min:1',
'expiry_date'=>'required',
'supplier'=>'required',
'image'=>'file|image|mimes:jpg,jpeg,png,gif',
]);
$imageName = $purchase->image;
if($request->hasFile('image')){
$imageName = time().'.'.$request->image->extension();
$request->image->move(public_path('storage/purchases'), $imageName);
}
$purchase->update([
'product'=>$request->product,
'category_id'=>$request->category,
'supplier_id'=>$request->supplier,
'cost_price'=>$request->cost_price,
'quantity'=>$request->quantity,
'expiry_date'=>$request->expiry_date,
'image'=>$imageName,
]);
$notifications = notify("Purchase has been updated");
return redirect()->route('purchases.index')->with($notifications);
}
public function reports(){
$title ='purchase reports';
return view('admin.purchases.reports',compact('title'));
}
public function generateReport(Request $request){
$this->validate($request,[
'from_date' => 'required',
'to_date' => 'required'
]);
$title = 'purchases reports';
$purchases = Purchase::whereBetween(DB::raw('DATE(created_at)'), array($request->from_date, $request->to_date))->get();
return view('admin.purchases.reports',compact(
'purchases','title'
));
}
/**
* Remove the specified resource from storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function destroy(Request $request)
{
return Purchase::findOrFail($request->id)->delete();
}
}