public function postPurchases() { $input_start_date = \Input::get('start_date'); if ($input_start_date == "") { $input_start_date = "01/01/1900"; } $start_date = \DateTime::createFromFormat('d/m/Y', $input_start_date); $input_end_date = \Input::get('end_date'); if ($input_end_date == "") { $end_date = new \DateTime("NOW"); } else { $end_date = \DateTime::createFromFormat('d/m/Y', $input_end_date); } $data = UserPricelist::where('created_at', '>=', $start_date)->where('created_at', '<=', $end_date)->orderBy('created_at', 'desc')->get(); if (count($data) == 0) { $errors = new \Illuminate\Support\MessageBag(); $errors->add('downloadError', "There's no data within the dates specified."); return \Redirect::to('admin/purchases')->withErrors($errors); } \Excel::create('Redooor_Purchases_Report', function ($excel) use($data) { $excel->sheet('Purchases Report', function ($sheet) use($data) { $sheet->loadView('redminportal::reports/purchases')->with('data', $data); }); })->download('csv'); }
public function getIndex() { $purchases = UserPricelist::orderBy('created_at', 'desc')->paginate(20); return \View::make('redminportal::purchases/view')->with('purchases', $purchases); }
public function getDelete($id) { // Find the module using the user id $module = Module::find($id); if ($module == null) { $errors = new \Illuminate\Support\MessageBag(); $errors->add('deleteError', "We are having problem deleting this entry. Please try again."); return \Redirect::to('admin/modules')->withErrors($errors); } $purchases = UserPricelist::join('pricelists', 'pricelists.id', '=', 'user_pricelists.pricelist_id')->where('pricelists.module_id', $id)->get(); if (count($purchases) > 0) { $errors = new \Illuminate\Support\MessageBag(); $errors->add('deleteError', "This module has been purchased before. You cannot delete it. Please change disable it instead."); return \Redirect::to('admin/modules')->withErrors($errors); } // Delete all images first $module->deleteAllImages(); // Delete all tags $module->deleteAllTags(); // Delete all pricelist foreach (Pricelist::where('module_id', $id)->get() as $pricelist) { $pricelist->delete(); } // Delete all media links foreach (ModuleMediaMembership::where('module_id', $id)->get() as $mmm) { $mmm->delete(); } // Delete the module $module->delete(); return \Redirect::to('admin/modules'); }