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');
}
