public function save($request, $id = false)
{
$rules = ['last_name' => 'min:3|regex:/^[a-záéíóúàèìòùäëïöüñ\\s]+$/i', 'mothers_last_name' => 'min:3|regex:/^[a-záéíóúàèìòùäëïöüñ\\s]+$/i', 'first_name' => 'min:3|regex:/^[a-záéíóúàèìòùäëïöüñ\\s]+$/i', 'second_name' => 'min:3|regex:/^[a-záéíóúàèìòùäëïöüñ\\s]+$/i'];
$messages = ['last_name.min' => 'El mínimo de caracteres permitidos para apellido paterno es 3', 'last_name.regex' => 'Sólo se aceptan letras para apellido paterno', 'mothers_last_name.min' => 'El mínimo de caracteres permitidos para apellido materno es 3', 'mothers_last_name.regex' => 'Sólo se aceptan letras para apellido materno', 'first_name.min' => 'El mínimo de caracteres permitidos para primer nombre es 3', 'first_name.regex' => 'Sólo se aceptan letras para primer nombre', 'second_name.min' => 'El mínimo de caracteres permitidos para teléfono de usuario es 3', 'second_name.regex' => 'Sólo se aceptan letras para segundo nombre'];
$validator = Validator::make($request->all(), $rules, $messages);
if ($validator->fails()) {
return redirect('affiliate/' . $id)->withErrors($validator)->withInput();
} else {
$spouse = Spouse::affiliateidIs($id)->first();
if (!$spouse) {
$spouse = new Spouse();
}
$spouse->user_id = Auth::user()->id;
$spouse->affiliate_id = $id;
$spouse->identity_card = trim($request->identity_card);
$spouse->last_name = trim($request->last_name);
$spouse->mothers_last_name = trim($request->mothers_last_name);
$spouse->first_name = trim($request->first_name);
$spouse->second_name = trim($request->second_name);
$spouse->birth_date = Util::datePick($request->birth_date);
if ($request->DateDeathSpouseCheck == "on") {
$spouse->date_death = Util::datePick($request->date_death);
$spouse->reason_death = trim($request->reason_death);
} else {
$spouse->date_death = null;
$spouse->reason_death = null;
}
$spouse->save();
$message = "Información de Conyuge actualizado con éxito";
Session::flash('message', $message);
}
return redirect('affiliate/' . $id);
}
/**
* Display the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function getData($affiliate)
{
$affiliate = Affiliate::idIs($affiliate)->first();
$spouse = Spouse::affiliateidIs($affiliate->id)->first();
if (!$spouse) {
$spouse = new Spouse();
}
if ($affiliate->gender == 'M') {
$gender_list = ['' => '', 'C' => 'CASADO', 'S' => 'SOLTERO', 'V' => 'VIUDO', 'D' => 'DIVORCIADO'];
} elseif ($affiliate->gender == 'F') {
$gender_list = ['' => '', 'C' => 'CASADA', 'S' => 'SOLTERA', 'V' => 'VIUDA', 'D' => 'DIVORCIADA'];
}
if ($affiliate->city_identity_card_id) {
$affiliate->city_identity_card = City::idIs($affiliate->city_identity_card_id)->first()->shortened;
} else {
$affiliate->city_identity_card = '';
}
if ($affiliate->city_birth_id) {
$affiliate->city_birth = City::idIs($affiliate->city_birth_id)->first()->name;
} else {
$affiliate->city_birth = '';
}
if ($affiliate->city_address_id) {
$affiliate->city_address = City::idIs($affiliate->city_address_id)->first()->name;
} else {
$affiliate->city_address = '';
}
if ($affiliate->city_address_id || $affiliate->zone || $affiliate->Street || $affiliate->number_address || $affiliate->phone || $affiliate->cell_phone) {
$info_address = TRUE;
} else {
$info_address = FALSE;
}
if ($spouse->identity_card) {
$info_spouse = TRUE;
} else {
$info_spouse = FALSE;
}
$last_contribution = Contribution::affiliateidIs($affiliate->id)->orderBy('month_year', 'desc')->first();
$consulta = DB::table('affiliates')->select(DB::raw('SUM(contributions.gain) as gain, SUM(contributions.public_security_bonus) as public_security_bonus,
SUM(contributions.quotable) as quotable, SUM(contributions.total) as total,
SUM(contributions.retirement_fund) as retirement_fund, SUM(contributions.mortuary_quota) as mortuary_quota'))->leftJoin('contributions', 'affiliates.id', '=', 'contributions.affiliate_id')->where('affiliates.id', '=', $affiliate->id)->get();
foreach ($consulta as $item) {
$total_gain = Util::formatMoney($item->gain);
$total_public_security_bonus = Util::formatMoney($item->public_security_bonus);
$total_quotable = Util::formatMoney($item->quotable);
$total_retirement_fund = Util::formatMoney($item->retirement_fund);
$total_mortuary_quota = Util::formatMoney($item->mortuary_quota);
$total = Util::formatMoney($item->total);
}
$data = ['affiliate' => $affiliate, 'spouse' => $spouse, 'gender_list' => $gender_list, 'info_address' => $info_address, 'info_spouse' => $info_spouse, 'last_contribution' => $last_contribution, 'total_gain' => $total_gain, 'total_public_security_bonus' => $total_public_security_bonus, 'total_quotable' => $total_quotable, 'total_retirement_fund' => $total_retirement_fund, 'total_mortuary_quota' => $total_mortuary_quota, 'total' => $total];
$data = array_merge($data, self::getViewModel());
return $data;
}
return Util::getDateEdit($this->birth_date);
}
public function getFullNametoPrint()
{
return $this->fisrt_name . ' ' . $this->second_name . ' ' . $this->last_name . ' ' . $this->mothers_last_name;
}
public function getFullDateNactoPrint()
{
if ($this->birth_date) {
$meses = array("Enero", "Febrero", "Marzo", "Abril", "Mayo", "Junio", "Julio", "Agosto", "Septiembre", "Octubre", "Noviembre", "Diciembre");
return date("d", strtotime($this->birth_date)) . " de " . $meses[date("m", strtotime($this->birth_date)) - 1] . " de " . date("Y", strtotime($this->fech_nac));
}
}
public function getFull_fech_decetoPrint()
{
if ($this->date_death) {
$meses = array("Enero", "Febrero", "Marzo", "Abril", "Mayo", "Junio", "Julio", "Agosto", "Septiembre", "Octubre", "Noviembre", "Diciembre");
return date("d", strtotime($this->date_death)) . " " . $meses[date("n", strtotime($this->date_death)) - 1] . " " . date("Y", strtotime($this->date_death));
}
}
public function getFullName()
{
return $this->last_name . ' ' . $this->mothers_last_name . ' ' . $this->first_name . ' ' . $this->second_name;
}
}
Spouse::created(function ($spouse) {
Activity::createdSpouse($spouse);
});
Spouse::updating(function ($spouse) {
Activity::updateSpouse($spouse);
});
public function getData($afid)
{
$affiliate = Affiliate::idIs($afid)->first();
$spouse = Spouse::affiliateidIs($afid)->first();
if (!$spouse) {
$spouse = new Spouse();
}
$retirement_fund = RetirementFund::afiIs($afid)->first();
if (!$retirement_fund) {
$now = Carbon::now();
$last_retirement_fund = RetirementFund::whereYear('created_at', '=', $now->year)->where('deleted_at', '=', null)->orderBy('id', 'desc')->first();
$retirement_fund = new RetirementFund();
if ($last_retirement_fund) {
$number_code = Util::separateCode($last_retirement_fund->code);
$code = $number_code + 1;
} else {
$code = 1;
}
$retirement_fund->code = $code . "/" . $now->year;
$retirement_fund->affiliate_id = $afid;
$retirement_fund->save();
}
$applicant = Applicant::retirementFundIs($retirement_fund->id)->first();
if (!$applicant) {
$applicant = new Applicant();
}
$requirements = Requirement::modalityIs($retirement_fund->retirement_fund_modality_id)->get();
$documents = Document::retirementFundIs($retirement_fund->id)->get();
$antecedents = Antecedent::retirementFundIs($retirement_fund->id)->get();
if ($retirement_fund->retirement_fund_modality_id) {
$info_modality = TRUE;
} else {
$info_modality = FALSE;
}
if ($applicant->identity_card) {
$info_applicant = TRUE;
} else {
$info_applicant = FALSE;
}
if (Document::retirementFundIs($retirement_fund->id)->first()) {
$info_documents = TRUE;
} else {
$info_documents = FALSE;
}
if (Antecedent::retirementFundIs($retirement_fund->id)->first()) {
$info_antecedents = TRUE;
} else {
$info_antecedents = FALSE;
}
if ($retirement_fund->comment) {
$info_comment = TRUE;
} else {
$info_comment = FALSE;
}
$lastContribution = Contribution::affiliateidIs($affiliate->id)->orderBy('month_year', 'desc')->first();
$affiliate->service_start_date = $affiliate->date_entry;
$affiliate->service_end_date = $lastContribution->month_year;
$data = array('affiliate' => $affiliate, 'spouse' => $spouse, 'retirement_fund' => $retirement_fund, 'applicant' => $applicant, 'requirements' => $requirements, 'documents' => $documents, 'antecedents' => $antecedents, 'info_modality' => $info_modality, 'info_applicant' => $info_applicant, 'info_documents' => $info_documents, 'info_antecedents' => $info_antecedents, 'info_comment' => $info_comment);
$data = array_merge($data, self::getViewModel());
return $data;
}
