/**
* Execute the console command.
*
* @return mixed
*/
public function handle()
{
$last_contributionrate = ContributionRate::orderBy('month_year', 'desc')->first();
if (Carbon::parse($last_contributionrate->month_year)->addMonth() < ($date = new Carbon())) {
$new_contributionrate = new ContributionRate();
$new_contributionrate->user_id = 1;
$new_contributionrate->retirement_fund = $last_contributionrate->retirement_fund;
$new_contributionrate->mortuary_quota = $last_contributionrate->mortuary_quota;
$new_contributionrate->rate_active = $new_contributionrate->rate_active;
$new_contributionrate->mortuary_aid = $last_contributionrate->mortuary_aid;
$fecha = Carbon::parse($last_contributionrate->month_year);
$new_contributionrate->month_year = Carbon::parse($last_contributionrate->month_year)->addMonth();
$new_contributionrate->save();
$year = Carbon::parse($new_contributionrate->month_year)->year;
$month = Carbon::parse($new_contributionrate->month_year)->month;
\Storage::disk('local')->put('ContributionRate_' . $month . '-' . $year . '.txt', "Contribution rate successfully updated: " . $new_contributionrate->index);
}
}
public function Data()
{
$contribution_rates = ContributionRate::select(['month_year', 'rate_active', 'retirement_fund', 'mortuary_quota', 'mortuary_aid']);
return Datatables::of($contribution_rates)->addColumn('year', function ($contribution_rate) {
return Carbon::parse($contribution_rate->month_year)->year;
})->addColumn('month', function ($contribution_rate) {
return Util::getMes(Carbon::parse($contribution_rate->month_year)->month);
})->editColumn('retirement_fund', function ($contribution_rate) {
return Util::formatMoney($contribution_rate->retirement_fund);
})->editColumn('mortuary_quota', function ($contribution_rate) {
return Util::formatMoney($contribution_rate->mortuary_quota);
})->editColumn('rate_active', function ($contribution_rate) {
return Util::formatMoney($contribution_rate->rate_active);
})->editColumn('mortuary_aid', function ($contribution_rate) {
return Util::formatMoney($contribution_rate->mortuary_aid);
})->addColumn('rate_passive', function ($contribution_rate) {
return Util::formatMoney($contribution_rate->mortuary_aid);
})->make(true);
}
public function save($request)
{
$rules = ['affiliate_id' => 'required'];
$messages = ['affiliate_id.required' => 'Afiliado no disponible'];
$validator = Validator::make($request->all(), $rules, $messages);
if ($validator->fails()) {
return redirect('affiliate/' . $request->affiliate_id)->withErrors($validator)->withInput();
} else {
$direct_contribution = new DirectContribution();
$data = json_decode($request->data);
$now = Carbon::now();
$affiliate = Affiliate::IdIs($request->affiliate_id)->first();
$last_direct_contribution = DirectContribution::whereYear('created_at', '=', $now->year)->where('deleted_at', '=', null)->orderBy('id', 'desc')->first();
if ($last_direct_contribution) {
$number_code = Util::separateCode($last_direct_contribution->code);
$code = $number_code + 1;
} else {
$code = 1;
}
$direct_contribution->code = $code . "/" . $now->year;
$direct_contribution->user_id = Auth::user()->id;
$direct_contribution->affiliate_id = $request->affiliate_id;
$direct_contribution->affiliate_name = $affiliate->getTittleName();
$direct_contribution->affiliate_degree = $affiliate->degree->name;
$direct_contribution->affiliate_identity_card = $affiliate->identity_card;
$direct_contribution->affiliate_registration = $affiliate->registration;
$direct_contribution->quotable = $data->sum_quotable;
$direct_contribution->retirement_fund = $data->sum_subtotal_retirement_fund;
$direct_contribution->mortuary_quota = $data->sum_subtotal_mortuary_quota;
$direct_contribution->subtotal = $data->sum_subtotal;
$direct_contribution->ipc = $data->sum_subtotal_ipc_rate;
$direct_contribution->total = $data->sum_total;
$direct_contribution->save();
foreach ($data->contributions as $item) {
$month_year = Carbon::createFromDate($request->year, $item->id_month, 1)->toDateString();
$contribution = Contribution::where('month_year', '=', $month_year)->where('affiliate_id', '=', $request->affiliate_id)->first();
$contribution_rate = ContributionRate::where('month_year', '=', $month_year)->first();
$ipc_rate = IpcRate::where('month_year', '=', $month_year)->first();
$now = Carbon::now();
$ipc_actual = IpcRate::select('index')->where('month_year', '=', Carbon::createFromDate($now->year, $now->month, 1)->toDateString())->first();
if (!$contribution) {
$contribution = new Contribution();
$contribution->user_id = Auth::user()->id;
$contribution->contribution_type_id = 2;
$contribution->affiliate_id = $request->affiliate_id;
$contribution->direct_contribution_id = $direct_contribution->id;
$contribution->month_year = $month_year;
$contribution->base_wage = $item->base_wage;
$contribution->category_id = $item->category->id;
$contribution->seniority_bonus = $item->seniority_bonus;
$contribution->study_bonus = $item->study_bonus;
$contribution->position_bonus = $item->position_bonus;
$contribution->border_bonus = $item->border_bonus;
$contribution->east_bonus = $item->east_bonus;
$contribution->quotable = $item->quotable;
$contribution->retirement_fund = $item->subtotal_retirement_fund;
$contribution->mortuary_quota = $item->subtotal_mortuary_quota;
$contribution->subtotal = $item->subtotal;
$contribution->ipc = $item->subtotal_ipc_rate;
$contribution->total = $item->total;
$contribution->save();
}
}
$voucher = new Voucher();
$voucher->user_id = Auth::user()->id;
$voucher->affiliate_id = $request->affiliate_id;
$voucher->voucher_type_id = 1;
$voucher->direct_contribution_id = $direct_contribution->id;
$last_voucher = Voucher::whereYear('created_at', '=', $now->year)->where('deleted_at', '=', null)->orderBy('id', 'desc')->first();
if ($last_voucher) {
$number_code = Util::separateCode($last_voucher->code);
$code = $number_code + 1;
} else {
$code = 1;
}
$voucher->code = $code . "/" . $now->year;
$voucher->total = $data->sum_total;
$voucher->save();
$message = "Aportes Guardados";
Session::flash('message', $message);
}
return redirect('direct_contribution/' . $direct_contribution->id);
}
