public function update(User $user, Request $request) { $this->validate($request, ['amount' => 'required|integer|min:10', 'operation' => 'required|in:0,1', 'description' => 'required|min:3']); $amount = abs($request->input('amount')); //check if the credit is settle or removal if ($request->input('operation') == 0) { //removal $amount = $amount * -1; } elseif ($request->input('operation') == 1) { //settle $amount = $amount * 1; } Credit::create(['user_id' => $user->id, 'amount' => $amount, 'description' => $request->input('description')]); Flash::success(trans('admin/messages.balanceUpdated')); return redirect(route('admin.credit.index')); }
public function filter(Request $request) { $data_filter = $request->all(); $date_from = $data_filter['date_from']; $date_to = $data_filter['date_to']; $hour_from = "00:01"; $hour_to = "23:59"; $time_from = $this->convert_datetime($date_from, $hour_from); $time_to = $this->convert_datetime($date_to, $hour_to); if ($data_filter['booking_code'] == '') { $credits = Credit::where('time_book', '>=', $time_from)->where('time_book', '<=', $time_to)->get(); } else { $credits = Credit::where('booking_code', $data_filter['booking_code'])->get(); } return view('backend.credit.index', compact('credits', 'data_filter')); }
/** * Show the form for creating a new resource. * * @return \Illuminate\Http\Response */ public function create() { $user = User::where('id', Auth::user()->id)->first(); $disability_types = DisabilityType::whereNotIn('id', [1])->orderBy('description', 'ASC')->lists('description', 'id')->toArray(); $victim_types = VictimType::whereNotIn('id', [1])->orderBy('description', 'ASC')->lists('description', 'id')->toArray(); $black_communities = BlackCommunity::whereNotIn('id', [1])->orderBy('description', 'ASC')->lists('description', 'id')->toArray(); $indigenous_peoples = IndigenousPeople::whereNotIn('id', [1])->orderBy('description', 'ASC')->lists('description', 'id')->toArray(); $ethnic_groups = EthnicGroup::whereNotIn('id', [1])->orderBy('description', 'ASC')->lists('description', 'id')->toArray(); $credits = Credit::whereNotIn('id', [1])->orderBy('description', 'ASC')->lists('description', 'id')->toArray(); $schedules = Schedule::orderBy('description', 'ASC')->lists('description', 'id')->toArray(); $programs = Program::orderBy('description', 'ASC')->lists('description', 'id')->toArray(); $civil_states = CivilState::orderBy('description', 'ASC')->lists('description', 'id')->toArray(); $sexes = Sex::orderBy('description', 'ASC')->lists('description', 'id')->toArray(); $sexual_orientations = SexualOrientation::orderBy('description', 'ASC')->lists('description', 'id')->toArray(); return view('app.data_update.create', compact('sexes', 'sexual_orientations', 'civil_states', 'programs', 'schedules', 'credits', 'ethnic_groups', 'indigenous_peoples', 'black_communities', 'victim_types', 'disability_types', 'user')); }
public function update(Settle $settle, Request $request) { $this->validate($request, ['operation' => 'required|in:0,1', 'description' => 'required']); if ($request->input('operation') == 1) { // the settle has been denied $settle->update(['description' => $request->input('description'), 'status' => 2]); Flash::error(trans('admin.messages.settleDenied')); return redirect(route('admin.settle.requests')); } elseif ($request->input('operation') == 0) { //the settle has been approved $settle->update(['description' => $request->input('description'), 'status' => 1]); // add record to the credits table $userId = $settle->user_id; Credit::create(['user_id' => $userId, 'amount' => $settle->amount * -1, 'description' => $request->input('description')]); Flash::success(trans('admin.messages.settleApproved')); return redirect(route('admin.settle.requests')); } }
/** * Gets the number of trade credits for a user * * @param User $user * @return Integer */ public function searchUserCreditAmount(User $user) { return Credit::where('user_id', $user->id)->first(); }
<h4>{{ $item->title }}</h4> </div> @include('turnovers-part', ['turnovers' => \App\Turnover::all()]) @elseif($item->name == 'Banque Zitouna') <div class="grey-header"> <h4>{{ $item->title }}</h4> </div> @include('bank-part', ['bank' => \App\Bank::distinct()->where('name', 'Zitouna')->orderBy('date', 'desc')->groupBy('name')->first()]) @elseif($item->name == 'Banque AB') <div class="grey-header"> <h4>{{ $item->title }}</h4> </div> @include('bank-part', ['bank' => \App\Bank::distinct()->where('name', 'AB')->orderBy('date', 'desc')->groupBy('name')->first()]) @elseif($item->name == 'Crédits') <?php $credits = \App\Credit::orderBy('date', 'desc')->first(); ?> <div class="grey-header"> <h4>{{ $item->title }} = {{ number_format(($credits->suivi00 + $credits->suivi30 + $credits->suivi60 + $credits->suivi90) / 1000.0, 3, '.', ' ') }} K TND</h4> </div> @include('credits-part', ['credit' => $credits, 'size' => min(($row->height - 100), ($item->nbColumns * 150))]) @elseif($item->name == 'Stock') <div class="grey-header"> <h4>{{ $item->title }}</h4> </div> @include('stocks-part', ['stocks' => \App\Stock::orderBy('date')->get()]) @endif </div> </div> @endforeach </div>
public function credits(Request $request) { $service_out = []; $key = 0; $service_bf = 0; $service_af = 0; //$services = Service::all(); $time = time(); $data = $request->all(); $data_fn = ["name_card" => $data['name_card'], "type_card" => $data['type_card'], "number_card" => $data['number_card'], "cc_mont" => $data['cc_mont'], 'cc_year' => $data['cc_year'], 'cvc_card' => $data['cvc_card'], 'booking_code' => $data['booking_code'], 'time_book' => $time]; $credit_old = Credit::where("booking_code", $data['booking_code'])->get(); //return $data['booking_code']; if (count($credit_old) == 0) { $credit = Credit::create($data_fn); } else { //return $data; DB::table('credits')->where('id', $credit_old[0]['id'])->update($data_fn); } $info_bookings = Booking::where('code_booking', $data['booking_code'])->get(); foreach ($info_bookings as $info_booking) { $info = $info_booking; } $services = DB::table('service_lang')->join('services', 'service_lang.service_id', '=', 'services.id')->where('service_lang.lang_id', current_lang_id())->select('service_lang.*', 'services.*')->get(); foreach ($services as $service) { if ($service->choice == 0) { $service_out[$key]['name'] = $service->name; if ($service->option == 0) { $ser_bf = $info['total_room'] * $service->value / 100; $service_bf += $ser_bf; $service_out[$key]['money'] = $ser_bf; } else { $service_bf += $service->value; $service_out[$key]['money'] = $service->value; } $key++; } } foreach ($services as $service) { if ($service->choice == 1) { $service_out[$key]['name'] = $service->name; if ($service->option == 0) { $ser_af = ($info['total_room'] + $service_bf) * $service->value / 100; $service_af += $ser_af; $service_out[$key]['money'] = $ser_af; } else { $service_af += $service->value; $service_out[$key]['money'] = $service->value; } $key++; } } //$services = array_reverse($service_out); //return $info; $lang = \Session::get('locale'); if (current_lang_id() == 1) { Mail::send('emails.visa', ['data' => $info, 'credit' => $data, 'services' => $service_out], function ($message) use($info) { $message->to($info['emails'], 'VATC SleepPod')->from('*****@*****.**')->subject('VATC SleepPod Yêu cầu đặt phòng.'); }); if (!is_null($info['guest_email']) && $info['guest_email'] != '') { Mail::send('emails.visa', ['data' => $info, 'credit' => $data, 'services' => $service_out], function ($message) use($info) { $message->to($info['guest_email'], 'VATC SleepPod')->from('*****@*****.**')->subject('VATC SleepPod Yêu cầu đặt phòng.'); }); } Mail::send('emails.visa', ['data' => $info, 'credit' => $data, 'services' => $service_out], function ($message) use($info) { $message->to('*****@*****.**', 'VATC SleepPod')->from('*****@*****.**')->subject('VATC SleepPod Yêu cầu đặt phòng.'); }); } else { Mail::send('emails.visa-en', ['data' => $info, 'credit' => $data, 'services' => $service_out], function ($message) use($info) { $message->to($info['emails'], 'VATC SleepPod')->from('*****@*****.**')->subject('VATC SleepPod Booking Information.'); }); if (!is_null($info['guest_email']) && $info['guest_email'] != '') { Mail::send('emails.visa-en', ['data' => $info, 'credit' => $data, 'services' => $service_out], function ($message) use($info) { $message->to($info['guest_email'], 'VATC SleepPod')->from('*****@*****.**')->subject('VATC SleepPod Booking Information.'); }); } Mail::send('emails.visa-en', ['data' => $info, 'credit' => $data, 'services' => $service_out], function ($message) use($info) { $message->to('*****@*****.**', 'VATC SleepPod')->from('*****@*****.**')->subject('VATC SleepPod Booking Information.'); }); } return view('layouts.booking.cc-notice', compact('info', 'data', 'service_out')); }
public function jsonIndex() { return response()->json(Credit::orderBy('date', 'desc')->select(['id', 'date', 'suivi00', 'suivi30', 'suivi60', 'suivi90'])->first()); }