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('Redmin_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 postStore() { $sid = \Input::get('id'); $rules = array('pricelist_id' => 'required|integer', 'transaction_id' => 'required', 'payment_status' => 'required', 'paid' => 'numeric', 'email' => 'required|email'); $validation = \Validator::make(\Input::all(), $rules); $redirect_url = isset($sid) ? 'admin/purchases/edit/' . $sid : 'admin/purchases/create'; if ($validation->fails()) { return redirect($redirect_url)->withErrors($validation)->withInput(); } $pricelist_id = \Input::get('pricelist_id'); $transaction_id = \Input::get('transaction_id'); $payment_status = \Input::get('payment_status'); $paid = \Input::get('paid'); $email = \Input::get('email'); $pricelist = Pricelist::find($pricelist_id); // No such pricelist if ($pricelist == null) { $errors = new \Illuminate\Support\MessageBag(); $errors->add('pricelistError', "The Module/Membership may have been deleted. Please try again."); return redirect($redirect_url)->withErrors($errors)->withInput(); } $user = User::where('email', $email)->first(); if ($user == null) { // No such user $errors = new \Illuminate\Support\MessageBag(); $errors->add('userError', "The user may have been deleted. Please try again."); return redirect($redirect_url)->withErrors($errors)->withInput(); } // Check if user_pricelist already exist $existing = UserPricelist::where('user_id', $user->id)->where('pricelist_id', $pricelist->id)->get(); if (count($existing) > 0) { $errors = new \Illuminate\Support\MessageBag(); $errors->add('userpricelistError', $email . " has already purchased " . $pricelist->module->name . " (" . $pricelist->membership->name . ")."); return redirect($redirect_url)->withErrors($errors)->withInput(); } $new_purchase = new UserPricelist(); $new_purchase->user_id = $user->id; $new_purchase->pricelist_id = $pricelist->id; $new_purchase->paid = $paid; $new_purchase->transaction_id = $transaction_id; $new_purchase->payment_status = $payment_status; $new_purchase->save(); return redirect('admin/purchases'); }
public function postStore() { $sid = \Input::get('id'); $rules = array('image' => 'mimes:jpg,jpeg,png,gif|max:500', 'name' => 'required|unique:modules,name' . (isset($sid) ? ',' . $sid : ''), 'short_description' => 'required', 'sku' => 'required|alpha_dash|unique:modules,sku' . (isset($sid) ? ',' . $sid : ''), 'category_id' => 'required', 'tags' => 'regex:/^[a-z,0-9 -]+$/i'); $validation = \Validator::make(\Input::all(), $rules); if ($validation->passes()) { $name = \Input::get('name'); $sku = \Input::get('sku'); $short_description = \Input::get('short_description'); $long_description = \Input::get('long_description'); $image = \Input::file('image'); $featured = \Input::get('featured') == '' ? false : true; $active = \Input::get('active') == '' ? false : true; $category_id = \Input::get('category_id'); $tags = \Input::get('tags'); $module = isset($sid) ? Module::find($sid) : new Module(); if ($module == null) { $errors = new \Illuminate\Support\MessageBag(); $errors->add('editError', "The module cannot be found because it does not exist or may have been deleted."); return \Redirect::to('/admin/modules')->withErrors($errors); } $module->name = $name; $module->sku = $sku; $module->short_description = $short_description; $module->long_description = $long_description; $module->featured = $featured; $module->active = $active; $module->category_id = $category_id; // Create or save changes $module->save(); // Save translations $translations = \Config::get('redminportal::translation'); foreach ($translations as $translation) { $lang = $translation['lang']; if ($lang == 'en') { continue; } $translated_content = array('name' => \Input::get($lang . '_name'), 'short_description' => \Input::get($lang . '_short_description'), 'long_description' => \Input::get($lang . '_long_description')); // Check if lang exist $translated_model = $module->translations->where('lang', $lang)->first(); if ($translated_model == null) { $translated_model = new Translation(); } $translated_model->lang = $lang; $translated_model->content = json_encode($translated_content); $module->translations()->save($translated_model); } // Save pricelist foreach (Membership::all() as $membership) { $pricelist = Pricelist::where('module_id', $module->id)->where('membership_id', $membership->id)->first(); if ($pricelist == null) { $pricelist = new Pricelist(); $pricelist->module_id = $module->id; $pricelist->membership_id = $membership->id; } $price_active = \Input::get('price_active_' . $membership->id) == '' ? false : true; $price = \Input::get('price_' . $membership->id); if (!empty($price)) { $pricelist->active = $price_active; $pricelist->price = $price; $pricelist->save(); } else { // Empty price means to delete, but check that it is not used $pricelist_used = UserPricelist::where('pricelist_id', $pricelist->id)->get(); if (count($pricelist_used) == 0) { $pricelist->delete(); } } } // Save medias $media_checkbox = \Input::get('media_checkbox'); if (isset($sid)) { // Remove all existing medias $existing_medias = ModuleMediaMembership::where('module_id', $module->id)->get(); foreach ($existing_medias as $remove_media) { $remove_media->delete(); } } if (is_array($media_checkbox)) { foreach ($media_checkbox as $check) { $media_pair = explode('_', $check); $media_id = $media_pair[0]; $membership_id = $media_pair[1]; $modMediaMembership = new ModuleMediaMembership(); $modMediaMembership->module_id = $module->id; $modMediaMembership->membership_id = $membership_id; $modMediaMembership->media_id = $media_id; $modMediaMembership->save(); } } if (!empty($tags)) { // Delete old tags $module->tags()->detach(); // Save tags foreach (explode(',', $tags) as $tagName) { Tag::addTag($module, $tagName); } } if (\Input::hasFile('image')) { //Upload the file $helper_image = new RImage(); $filename = $helper_image->upload($image, 'modules/' . $module->id, true); if ($filename) { // create photo $newimage = new Image(); $newimage->path = $filename; // save photo to the loaded model $module->images()->save($newimage); } } //if it validate } else { if (isset($sid)) { return \Redirect::to('admin/modules/edit/' . $sid)->withErrors($validation)->withInput(); } else { return \Redirect::to('admin/modules/create')->withErrors($validation)->withInput(); } } return \Redirect::to('admin/modules'); }