/** * Remove the specified resource from storage. * * @param int $id * @return Response */ public function destroy(Request $request, $id) { // delete a specific vendor $vendor = Vendor::with('codes', 'transactions')->find($id); if (!$vendor->transactions->isEmpty()) { return response(array('status' => 'error', 'msg' => 'Cannot delete a vendor with transactions!'), 400); } if (!$vendor->codes->isEmpty()) { $vendor->codes()->delete(); } $vendor->delete(); return response(array('status' => 'success'), 200); }
/** * Download Vendors */ public function downloadVendors() { $vendors = Vendor::with('codes')->orderBy('business', 'asc')->get(); $filename = 'vendors-' . date('Y-m-d'); $excel = Excel::create($filename, function ($excel) use($vendors) { $excel->sheet('veendors', function ($sheet) use($vendors) { $sheet->loadView('excel.vendors', ['vendors' => $vendors]); }); })->export('csv'); }