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