public function save($request, $ipc_rate = false)
{
$rules = ['month_year' => 'required', 'index' => 'required|numeric'];
$messages = ['month_year.required' => 'El campo Año no puede ser vacío', 'index.required' => 'El campo IPC no puede ser vacío', 'index.numeric' => 'El campo IPC sólo se aceptan números'];
$validator = Validator::make($request->all(), $rules, $messages);
if ($validator->fails()) {
return redirect('ipc_rate')->withErrors($validator)->withInput();
} else {
$ipcTasa = IpcRate::where('month_year', '=', Util::datePickPeriod($request->month_year))->first();
if ($ipcTasa) {
$ipcTasa->user_id = Auth::user()->id;
$ipcTasa->index = trim($request->index);
$ipcTasa->save();
$message = "Índice de Precios al Consumidor actualizado con éxito";
Session::flash('message', $message);
} else {
$message = "Fecha no disponible";
Session::flash('message', $message);
}
}
return redirect('ipc_rate');
}
public function save($request, $id = false)
{
$rules = ['affiliate_id' => 'numeric', 'retirement_fund_modality_id' => 'numeric'];
$messages = ['affiliate_id.numeric' => 'Solo se aceptan números para id afiliado', 'retirement_fund_modality_id.numeric' => 'Solo se aceptan números para id modalidad'];
$validator = Validator::make($request->all(), $rules, $messages);
if ($validator->fails()) {
return redirect('tramite_fondo_retiro/' . $id)->withErrors($validator)->withInput();
} else {
$retirement_fund = RetirementFund::afiIs($id)->first();
$affiliate = Affiliate::idIs($id)->first();
switch ($request->type) {
case 'form_modality':
if ($request->modality == 4 && $affiliate->date_decommissioned == null) {
$message = "Ingrese Fecha de deceso de Afiliado";
} else {
if ($request->modality) {
$retirement_fund->retirement_fund_modality_id = trim($request->modality);
}
$retirement_fund->city_id = trim($request->city);
$retirement_fund->save();
switch ($request->modality) {
case '1':
$affiliate->affiliate_state_id = 8;
$affiliate->save();
break;
case '2':
$affiliate->affiliate_state_id = 7;
$affiliate->save();
break;
case '3':
$affiliate->affiliate_state_id = 5;
$affiliate->save();
break;
case '4':
$affiliate->affiliate_state_id = 4;
$affiliate->save();
break;
}
$message = "Información General de Fondo de Retiro actualizado con éxito";
}
break;
case 'form_document':
if ($retirement_fund->retirement_fund_modality_id) {
foreach (json_decode($request->data) as $item) {
$Document = Document::where('retirement_fund_id', '=', $retirement_fund->id)->where('requirement_id', '=', $item->requirement_id)->first();
if (!$Document) {
$Document = new Document();
$Document->retirement_fund_id = $retirement_fund->id;
$Document->requirement_id = $item->requirement_id;
}
$Document->status = $item->booleanValue;
$Document->reception_date = date('Y-m-d');
$Document->save();
$retirement_fund->reception_date = date('Y-m-d');
$retirement_fund->save();
}
$message = "Información de requisitos de Fondo de Retiro actualizado con éxito";
} else {
$message = "Seleccione la modalidad y la ciudad";
}
break;
case 'antec':
foreach (json_decode($request->data) as $item) {
$antecedent = Antecedent::where('retirement_fund_id', '=', $retirement_fund->id)->where('antecedent_file_id', '=', $item->prestacion_id)->first();
if (!$antecedent) {
$antecedent = new Antecedent();
$antecedent->retirement_fund_id = $retirement_fund->id;
$antecedent->antecedent_file_id = $item->prestacion_id;
}
$antecedent->status = $item->booleanValue;
$antecedent->save();
}
$retirement_fund->check_file_date = date('Y-m-d');
$retirement_fund->save();
$message = "Información de requisitos de Fondo de Retiro actualizado con éxito";
break;
case 'periods':
$affiliate->service_start_date = Util::datePickPeriod($request->fech_ini_serv);
$affiliate->service_end_date = Util::datePickPeriod($request->fech_fin_serv);
$affiliate->save();
$retirement_fund->anticipation_start_date = Util::datePickPeriod($request->fech_ini_anti);
$retirement_fund->anticipation_end_date = Util::datePickPeriod($request->fech_fin_anti);
$retirement_fund->recognized_start_date = Util::datePickPeriod($request->fech_ini_reco);
$retirement_fund->recognized_end_date = Util::datePickPeriod($request->fech_fin_reco);
$retirement_fund->save();
$retirement_fund->qualification_date = date('Y-m-d');
$retirement_fund->save();
$message = "Información de Periodos de Aporte actualizado con éxito";
break;
}
Session::flash('message', $message);
}
return redirect('retirement_fund/' . $id);
}
public function save($request, $base_wage = false)
{
global $month_year, $results;
$reader = $request->file('archive');
$filename = $reader->getRealPath();
$month_year = $request->month_year;
Excel::load($filename, function ($reader) {
global $month_year, $results;
ini_set('upload_max_filesize', '9999M');
ini_set('post_max_size', '9999M');
ini_set('max_execution_time', '-1');
ini_set('max_input_time', '-1');
ini_set('memory_limit', '-1');
set_time_limit(36000);
$results = collect($reader->select(array('niv', 'gra', 'sue'))->get());
});
$degrees = DB::table('degrees')->orderBy('id', 'asc')->get();
foreach ($degrees as $item) {
foreach ($results as $datos) {
if ($datos['niv'] == $item->niv && $datos['gra'] == $item->grad && Util::decimal($datos['sue']) != 0) {
$date = Util::datePickPeriod($month_year);
$year = Carbon::parse($date)->year;
$month = Carbon::parse($date)->month;
$base_wage = DB::table('base_wages')->select(DB::raw('base_wages.degree_id, degrees.code_level, degrees.code_degree, base_wages.month_year'))->leftJoin('degrees', 'base_wages.degree_id', '=', 'degrees.id')->where('code_level', '=', $item->niv)->where('code_degree', '=', $item->grad)->whereMonth('month_year', '=', $month)->whereYear('month_year', '=', $year)->first();
if (!$base_wage) {
$base_wage = new BaseWage();
$base_wage->user_id = Auth::user()->id;
$base_wage->degree_id = $item->id;
$base_wage->month_year = Util::datePickPeriod($month_year);
$base_wage->amount = Util::decimal($datos['sue']);
$base_wage->save();
}
break;
}
}
}
Session::flash('message', "Sueldos importados exitosamente");
return redirect('base_wage');
}
