/**
  * Show the form for editing the specified resource.
  *
  * @param  \App\Product $product
  * @return \Illuminate\Http\Response
  */
 public function edit(Product $product)
 {
     $productVariants = Product_variant::where('product_id', $product->product_id)->get();
     $languages = Language::orderBy('order', 'asc')->get();
     $categories = Category::all();
     $discounts = Discount::all();
     $taxes = Tax::all();
     return view('intothesource.webshop.products.edit', compact('product', 'productVariants', 'languages', 'categories', 'discounts', 'taxes'));
 }
 public function store(DiscountFormRequest $request)
 {
     $input['event_id'] = $request->input('event');
     $input['type'] = $request->input('type');
     $input['for'] = $request->input('for');
     $input['value'] = $request->input('value');
     $input['info'] = $request->input('info');
     Discount::create($input);
     \Flash::success('Discount added successfully');
     return Redirect::back()->with(['tabName' => 'discounts']);
 }
 /**
  *	@author: Arham
  *	@return $this
  *  @param: get request
  *	desc: validate the assign discount details,
  *  if validate success then insert discount details to database
  *	created : 04/02/2016
  */
 public function addDiscount(Request $request)
 {
     $table1 = null;
     $add = 0;
     $id = 1;
     $values = '1';
     $item = DB::table('items')->select('itName')->get();
     $oldDiscount = 0;
     $validate = validator::make(input::all(), array('Percentage' => 'required|numeric|min:5|max:75', 'start_date' => 'required|date|after:yesterday', 'end_date' => 'required|date|after:start_date'));
     if ($validate->fails()) {
         return view('pages\\Discount\\discountpage', ['table2' => $table1, 'item' => $item, 'td' => $add, 'id' => $id, 'oldDiscount' => $oldDiscount, 'values' => $values])->withErrors($validate)->withInput(Input::get('Percentage'));
     } else {
         $itemcategory = Input::get('itmcat');
         $discountype = Input::get('disctyp');
         $Percentage = Input::get('Percentage');
         $sdate = Input::get('start_date');
         $edate = Input::get('end_date');
         $imag = DB::table('items')->where('itName', '=', $itemcategory)->value('imName');
         $itid = DB::table('items')->where('itName', '=', $itemcategory)->value('itID');
         $price = DB::table('items')->where('itName', '=', $itemcategory)->value('price');
         $disc = $Percentage / 100.0 * $price;
         $iprice2 = $price - $disc;
         $iprice = round($iprice2, 2);
         $itemid = DB::table('discount')->select('itid')->get();
         foreach ($itemid as $itemid1) {
             if ($itid == $itemid1->itid) {
                 $dtype = DB::table('discount')->where('itid', '=', $itid)->value('dtype');
                 if ($dtype == $discountype) {
                     $id = 0;
                     return view('pages\\Discount\\discountpage', ['table2' => $table1, 'item' => $item, 'td' => $add, 'id' => $id, 'oldDiscount' => $oldDiscount, 'values' => $values])->withErrors($validate);
                 }
             }
         }
         $id = 1;
         $discount = new Discount();
         $add = $discount->insert(array('iname' => $itemcategory, 'dtype' => $discountype, 'ipersentage' => $Percentage, 'iprice' => $iprice, 'imgpath' => $imag, 'sdate' => $sdate, 'edate' => $edate, 'itid' => $itid));
         return view('pages\\Discount\\discountpage', ['table2' => $table1, 'item' => $item, 'td' => $add, 'id' => $id, 'oldDiscount' => $oldDiscount, 'values' => $values])->withErrors($validate);
     }
 }
Example #4
0
 public function run()
 {
     DB::table('discounts')->delete();
     Discount::create(array('h1' => 'Заголовок 1', 'h2' => 'Заголовок 2', 'DeadLine' => date("H:i Y-m-d", mktime(date("H"), date("i"), 0, date("m"), date("d"), date("Y") + 1))));
 }
Example #5
0
 /**
  * Форма нового заказа
  */
 public function getNewOrder($user_id = null)
 {
     $this->page->title = 'Новый заказ';
     $this->page->desc = 'Оформление заказа';
     if ($user_id != null && is_numeric($user_id)) {
         $this->data['person'] = Person::findOrFail($user_id);
     } else {
         $this->data['person'] = null;
     }
     $this->data['price'] = Price::all();
     // Список операторов
     $this->data['operators'] = Operator::where('user_id', '=', $this->user->id)->lists('name', 'id');
     // Список аэропортов
     $this->data['airports'] = Airport::all()->lists('airport', 'id');
     // Кол-во пассажиров
     $this->data['passengers'] = array(1 => 1, 2 => 2, 3 => 3, 4 => 4, 5 => 5, 6 => 6, 7 => 7, 8 => 8, 9 => 9, 10 => 10);
     $transfer = TransferType::all();
     foreach ($transfer as $key => $value) {
         $this->data['transfer_out_' . $value->id] = Discount::where('type', '=', $value->id)->where('date_to', '>=', date('Y-m-d'))->where('date_from', '<=', date('Y-m-d'))->where('direction', '=', 'departure')->first();
     }
     $transfer = TransferType::all();
     foreach ($transfer as $key => $value) {
         $this->data['transfer_in_' . $value->id] = Discount::where('type', '=', $value->id)->where('date_to', '>=', date('Y-m-d'))->where('date_from', '<=', date('Y-m-d'))->where('direction', '=', 'arrivals')->first();
     }
     return $this->render('order.new');
 }
 public function DiscountGetDelete($id)
 {
     Cate::where("discount_id", $id)->update(["discount_id" => 0]);
     $discount = Discount::find($id);
     $discount->delete();
     return redirect()->route("admin.discount.list");
 }
 /**
  *  Запрос цены на дату
  */
 public function getPrice(Request $request)
 {
     // Обрабатываем только AJAX запрос
     if ($request->ajax()) {
         $price1 = Discount::where('date_from', '<=', date("Y-m-d 00:00:00", strtotime($request->input('date'))))->where('date_to', '>=', date("Y-m-d 23:59:59", strtotime($request->input('date'))))->where('type', 1)->first();
         $price2 = Discount::where('date_from', '<=', date("Y-m-d 00:00:00", strtotime($request->input('date'))))->where('date_to', '>=', date("Y-m-d 23:59:59", strtotime($request->input('date'))))->where('type', 2)->first();
         $price3 = Discount::where('date_from', '<=', date("Y-m-d 00:00:00", strtotime($request->input('date'))))->where('date_to', '>=', date("Y-m-d 23:59:59", strtotime($request->input('date'))))->where('type', 3)->first();
         $price4 = Discount::where('date_from', '<=', date("Y-m-d 00:00:00", strtotime($request->input('date'))))->where('date_to', '>=', date("Y-m-d 23:59:59", strtotime($request->input('date'))))->where('type', 4)->first();
         $base_price = Price::all();
         $sum1 = $base_price[0]->price;
         $sum2 = $base_price[1]->price;
         $sum3 = $base_price[2]->price;
         $sum4 = $base_price[3]->price;
         if ($price1) {
             $sum1 = $price1->sum;
         }
         if ($price2) {
             $sum2 = $price1->sum;
         }
         if ($price3) {
             $sum3 = $price1->sum;
         }
         if ($price4) {
             $sum4 = $price1->sum;
         }
         $res_order = array('price1' => $sum1, 'price2' => $sum2, 'price3' => $sum3, 'price4' => $sum4);
         return response()->json($res_order);
     } else {
         return redirect()->back();
     }
 }
 /**
  * Remove the specified resource from storage.
  *
  * @param  int  $id
  * @return \Illuminate\Http\Response
  */
 public function destroy($id)
 {
     //
     $dis = new Discount();
     $dis->where('id', $id)->update(['is_active' => 0]);
 }
Example #9
0
 /**
  * Show the form for editing the specified resource.
  *
  * @param  int  $id
  * @return \Illuminate\Http\Response
  */
 public function edit($id)
 {
     $categories = Category::all(array('id', 'name', 'parent_id'));
     $parent_category['0'] = 'Выберите родительскую категорию';
     foreach ($categories as $key => $category) {
         if ($category->parent_id == '') {
             $parent_category[$category->id] = $category->name;
         }
     }
     $product = Product::findOrFail($id);
     $images = Image::where('prod_id', '=', $id)->get();
     $category = Category::findOrFail($product->cat_id);
     $par_cat = Category::where('id', '=', $category->parent_id)->lists('name', 'id');
     $cat = array($category->id => $category->name);
     $discounts = ProdDiscount::where('prod_id', '=', $id)->get();
     foreach ($discounts as $key => $discount) {
         $disc = Discount::where('id', '=', $discount->discount_id)->get();
         $discounts[$key]->disc_name = $disc[0]->name;
         $discounts[$key]->disc_description = $disc[0]->description;
         $disc_old[$discounts[$key]->id] = $discounts[$key]->disc_name;
     }
     $discounts_all = Discount::all(array('id', 'name', 'description'));
     //        $discounts['0'] = 'Выберите скидки';
     foreach ($discounts_all as $key => $discount_all) {
         $disc_all[$discount_all->id] = $discount_all->name;
     }
     //dd($disc_old);
     return view('products.edit', compact('par_cat', 'cat', 'parent_category', 'images', 'discounts', 'disc_old', 'disc_all'))->withProduct($product);
 }
Example #10
0
 /**
  * Formats a messy form and presents the user with a confirmation page (form) before
  * proceeding to payment.
  */
 public function confirmEntry(Request $request)
 {
     // returns a confirm view which then sends the user to the store function above.
     $data = $request->all();
     $user = Auth::user();
     $event = Event::findOrFail($data['event_id']);
     $compSubTotal = 0;
     $extraSubTotal = 0;
     //Format the competitions for display in the confirmation form
     $entries = array();
     //$competitions[$id] = array('detail' => $detail, 'competition' => $competition)
     foreach ($data['competitions'] as $competition_id => $detail_id) {
         if ($detail_id != "noEntry") {
             $competition = Competition::findOrFail($competition_id);
             $detail = Detail::findOrFail($detail_id);
             $entries[$competition_id] = array('competition' => $competition, 'detail' => $detail);
             $compSubTotal += $competition->fee;
         }
     }
     //if for some reason the competitor has forgotten to select a competition, bump them back.
     if (empty($entries)) {
         \Flash::error('You need to select a competition to enter before you can proceed.');
         return redirect(action('EventsController@show', $event->slug));
     }
     //Format the extras for display in the confirmation form
     $extras = array();
     if (key_exists('extras', $data)) {
         foreach ($data['extras'] as $extra_id => $extraOrder) {
             $multiple = 1;
             $infoRequired = NULL;
             if (is_string($extraOrder) == False) {
                 //This is an extra order with an array of info
                 if (array_key_exists('multiple', $extraOrder)) {
                     $multiple = $extraOrder['multiple'];
                 }
                 if (array_key_exists('infoRequired', $extraOrder)) {
                     $infoRequired = $extraOrder['infoRequired'];
                 }
             }
             $extra = Extra::findOrFail($extra_id);
             $thisExtraTotal = $extra->cost * $multiple;
             $extraSubTotal += $thisExtraTotal;
             $extras[$extra_id] = array('id' => $extra_id, 'multiple' => $multiple, 'infoRequired' => $infoRequired, 'extra' => $extra, 'thisExtraCost' => $thisExtraTotal);
         }
     }
     //Format the discounts so that the fixed and percentage discounts
     //can be applied separately, fixed first.
     $discounts = array();
     $fixedDiscounts = array();
     $percentageDiscounts = array();
     $discounts_applied = "";
     if (key_exists('discounts', $data)) {
         foreach ($data['discounts'] as $discount_id => $discountApply) {
             if ($discountApply == 1) {
                 $discount = Discount::findOrFail($discount_id);
                 $discounts[] = $discount;
                 $discounts_applied = $discounts_applied . $discount_id . "-";
             }
         }
         $discounts = collect($discounts);
         $fixedDiscounts = $discounts->where('type', 'fixed');
         $percentageDiscounts = $discounts->where('type', 'percentage');
     }
     //total (just competitions and extras)
     $compExtraSubtotal = $compSubTotal + $extraSubTotal;
     //Apply any discounts to the compextrasubtotal & registration fee
     //fixed fees first, then %.
     $discountedSubtotal = $compExtraSubtotal;
     $discountedRegistrationFee = $event->registrationFee;
     $percentageDiscountValues = array();
     foreach ($fixedDiscounts as $fd) {
         $discountedSubtotal = $discountedSubtotal - $fd->value;
     }
     foreach ($percentageDiscounts as $pd) {
         $percentage = $pd->value / 100;
         $discount = $discountedSubtotal * $percentage;
         $percentageDiscountValues[$pd->id] = $discount;
         $discountedSubtotal = $discount;
         $discountedRegistrationFee = $discountedRegistrationFee * $percentage;
     }
     //Charge a late entry fee? //if it's past the closing date
     $lateEntryFee = 0;
     if (Carbon::now()->gt($event->closingDate)) {
         $lateEntryFee = $event->lateEntriesFee;
     }
     //FORESIGHT FEE
     $foresightFee = 2.99;
     $finalsubtotal = $discountedSubtotal + $discountedRegistrationFee + $lateEntryFee + $foresightFee;
     //paypal fees (3.4% + 20p)
     $paypalFees = $finalsubtotal * 0.034 + 0.2;
     $feesTotal = $discountedRegistrationFee + $lateEntryFee + $foresightFee + $paypalFees;
     $grandTotal = $finalsubtotal + $paypalFees;
     $format = "%4.2f";
     $variables = array('entrydata' => $data, 'event' => $event, 'user' => $user, 'entries' => $entries, 'extras' => $extras, 'fixedDiscounts' => $fixedDiscounts, 'percentageDiscounts' => $percentageDiscounts, 'percentageDiscountValues' => $percentageDiscountValues, 'compSubTotal' => sprintf($format, $compSubTotal), 'extraSubTotal' => sprintf($format, $extraSubTotal), 'compExtraSubtotal' => sprintf($format, $compExtraSubtotal), 'discountedSubtotal' => sprintf($format, $discountedSubtotal), 'discountedRegistrationFee' => sprintf($format, $discountedRegistrationFee), 'lateEntryFee' => sprintf($format, $lateEntryFee), 'paypalFees' => sprintf($format, $paypalFees), 'feesTotal' => sprintf($format, $feesTotal), 'grandTotal' => sprintf($format, $grandTotal), 'discounts_applied' => $discounts_applied, 'foresightFee' => sprintf($format, $foresightFee));
     //dd($variables);
     return view('events.entryconfirm')->with($variables);
 }
Example #11
0
 public function postListDiscount()
 {
     return Discount::select('h1', 'h2', 'DeadLine')->get();
 }
 /**
  * Remove the specified resource from storage.
  *
  * @param  int  $id
  *
  * @return Response
  */
 public function destroy($id)
 {
     Discount::destroy($id);
     Session::flash('flash_message', 'Discount deleted!');
     return redirect('admin/discounts');
 }
Example #13
0
 public function getDatatable()
 {
     return Datatable::collection(Discount::all(array('id', 'name', 'description', 'percent', 'quantity')))->showColumns('id', 'name', 'description', 'percent', 'quantity')->addColumn('created', function ($model) {
         return date('d-m-Y', strtotime(".{$model->created_at}."));
     })->addColumn('actions', function ($model) {
         return '<a href="/discounts/' . $model->id . '">Просм</a> |
                  <a href="/discounts/' . $model->id . '/edit" >Ред</a>';
     })->searchColumns('name', 'description', 'percent', 'quantity')->orderColumns('name', 'description', 'percent', 'quantity')->make();
 }