ajax()) {
$products = Product::latest();
return DataTables::of($products)
->addColumn('product',function($product){
$image = '';
if(!empty($product->purchase)){
$image = null;
if(!empty($product->purchase->image)){
$image = '
purchase->image).'" alt="image">
';
}
return $product->purchase->product. ' ' . $image;
}
})
->addColumn('category',function($product){
$category = null;
if(!empty($product->purchase->category)){
$category = $product->purchase->category->name;
}
return $category;
})
->addColumn('price',function($product){
return settings('app_currency','$').' '. $product->price;
})
->addColumn('quantity',function($product){
if(!empty($product->purchase)){
return $product->purchase->quantity;
}
})
->addColumn('expiry_date',function($product){
if(!empty($product->purchase)){
return date_format(date_create($product->purchase->expiry_date),'d M, Y');
}
})
->addColumn('action', function ($row) {
$editbtn = 'id).'" class="editbtn">';
$deletebtn = '';
if (!auth()->user()->hasPermissionTo('edit-product')) {
$editbtn = '';
}
if (!auth()->user()->hasPermissionTo('destroy-purchase')) {
$deletebtn = '';
}
$btn = $editbtn.' '.$deletebtn;
return $btn;
})
->rawColumns(['product','action'])
->make(true);
}
return view('admin.products.index',compact(
'title'
));
}
/**
* Show the form for creating a new resource.
*
* @return \Illuminate\Http\Response
*/
public function create()
{
$title = 'add product';
$purchases = Purchase::get();
return view('admin.products.create',compact(
'title','purchases'
));
}
/**
* 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',
'price'=>'required|min:1',
'discount'=>'nullable',
'description'=>'nullable|max:255',
]);
$price = $request->price;
if($request->discount >0){
$price = $request->discount * $request->price;
}
Product::create([
'purchase_id'=>$request->product,
'price'=>$price,
'discount'=>$request->discount,
'description'=>$request->description,
]);
$notification = notify("Product has been added");
return redirect()->route('products.index')->with($notification);
}
/**
* Show the form for editing the specified resource.
*
* @param \app\Models\Product $product
* @return \Illuminate\Http\Response
*/
public function edit(Product $product)
{
$title = 'edit product';
$purchases = Purchase::get();
return view('admin.products.edit',compact(
'title','product','purchases'
));
}
/**
* Update the specified resource in storage.
*
* @param \Illuminate\Http\Request $request
* @param \app\Models\Product $product
* @return \Illuminate\Http\Response
*/
public function update(Request $request, Product $product)
{
$this->validate($request,[
'product'=>'required|max:200',
'price'=>'required',
'discount'=>'nullable',
'description'=>'nullable|max:255',
]);
$price = $request->price;
if($request->discount >0){
$price = $request->discount * $request->price;
}
$product->update([
'purchase_id'=>$request->product,
'price'=>$price,
'discount'=>$request->discount,
'description'=>$request->description,
]);
$notification = notify('product has been updated');
return redirect()->route('products.index')->with($notification);
}
/**
* Display a listing of expired resources.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function expired(Request $request){
$title = "expired Products";
if($request->ajax()){
$products = Purchase::whereDate('expiry_date', '<=', Carbon::now())->get();
return DataTables::of($products)
->addColumn('product',function($product){
$image = '';
if(!empty($product->purchase)){
$image = null;
if(!empty($product->purchase->image)){
$image = '
purchase->image).'" alt="image">
';
}
return $product->purchase->product. ' ' . $image;
}
})
->addColumn('category',function($product){
$category = null;
if(!empty($product->purchase->category)){
$category = $product->purchase->category->name;
}
return $category;
})
->addColumn('price',function($product){
return settings('app_currency','$').' '. $product->price;
})
->addColumn('quantity',function($product){
if(!empty($product->purchase)){
return $product->purchase->quantity;
}
})
->addColumn('expiry_date',function($product){
if(!empty($product->purchase)){
return date_format(date_create($product->purchase->expiry_date),'d M, Y');
}
})
->addColumn('action', function ($row) {
$editbtn = 'id).'" class="editbtn">';
$deletebtn = '';
if (!auth()->user()->hasPermissionTo('edit-product')) {
$editbtn = '';
}
if (!auth()->user()->hasPermissionTo('destroy-purchase')) {
$deletebtn = '';
}
$btn = $editbtn.' '.$deletebtn;
return $btn;
})
->rawColumns(['product','action'])
->make(true);
}
return view('admin.products.expired',compact(
'title',
));
}
/**
* Display a listing of out of stock resources.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function outstock(Request $request){
$title = "outstocked Products";
if($request->ajax()){
$products = Product::whereHas('purchase', function($q){
return $q->where('quantity', '<=', 0);
})->get();
return DataTables::of($products)
->addColumn('product',function($product){
$image = '';
if(!empty($product->purchase)){
$image = null;
if(!empty($product->purchase->image)){
$image = '
purchase->image).'" alt="image">
';
}
return $product->purchase->product. ' ' . $image;
}
})
->addColumn('category',function($product){
$category = null;
if(!empty($product->purchase->category)){
$category = $product->purchase->category->name;
}
return $category;
})
->addColumn('price',function($product){
return settings('app_currency','$').' '. $product->price;
})
->addColumn('quantity',function($product){
if(!empty($product->purchase)){
return $product->purchase->quantity;
}
})
->addColumn('expiry_date',function($product){
if(!empty($product->purchase)){
return date_format(date_create($product->purchase->expiry_date),'d M, Y');
}
})
->addColumn('action', function ($row) {
$editbtn = 'id).'" class="editbtn">';
$deletebtn = '';
if (!auth()->user()->hasPermissionTo('edit-product')) {
$editbtn = '';
}
if (!auth()->user()->hasPermissionTo('destroy-purchase')) {
$deletebtn = '';
}
$btn = $editbtn.' '.$deletebtn;
return $btn;
})
->rawColumns(['product','action'])
->make(true);
}
$product = Purchase::where('quantity', '<=', 0)->first();
return view('admin.products.outstock',compact(
'title',
));
}
/**
* Remove the specified resource from storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function destroy(Request $request)
{
return Product::findOrFail($request->id)->delete();
}
}