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