/**
* Define the application's command schedule.
*
* @param \Illuminate\Console\Scheduling\Schedule $schedule
* @return void
*/
protected function schedule(Schedule $schedule)
{
$schedule->call(function () {
$players = DB::connection('game')->table('player_characters')->get();
foreach ($players as $player) {
if (!Player::where('id', $player->id)->exists()) {
$player_info = ['id' => $player->id, 'name' => $player->given_name, 'level' => $player->level, 'class' => 0, 'gold' => $player->gold, 'family_name' => $player->family_id ? DB::connection('game')->table('family')->where('id', $player->family_id)->first()->name : '-'];
Player::create($player_info);
}
}
})->everyTenMinutes();
$schedule->call(function () {
$families = DB::connection('game')->table('family')->get();
foreach ($families as $family) {
if (!Family::where('id', $family->id)->exists()) {
$gold = 0;
foreach (DB::connection('game')->table('player_characters')->where('family_id', $family->id)->get() as $player) {
$gold += $player->gold;
}
$family_info = ['id' => $family->id, 'name' => $family->name, 'level' => $family->lv, 'gold' => $gold, 'members' => DB::connection('game')->table('player_characters')->where('family_id', $family->id)->count(), 'leader' => DB::connection('game')->table('player_characters')->where('id', $family->leader_id)->first()->given_name];
Family::create($family_info);
}
}
})->everyTenMinutes();
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(StoreFamilyRequest $request)
{
if (Gate::denies('create', Family::class)) {
abort(403);
}
Family::create(['household_id' => $request->household_id, 'family_code' => $request->family_code, 'years_living' => $request->years_living, 'current_living' => $request->current_living, 'current_living_other' => $request->current_living_other, 'still_living' => $request->still_living, 'assistance_ngo_agency' => $request->assistance_ngo_agency, 'assistance_what' => $request->assistance_what, 'first_source' => $request->first_source, 'first_source_specific' => $request->first_source_specific, 'first_source_member' => $request->first_source_member, 'first_source_gender' => $request->first_source_gender, 'first_source_amount' => $request->first_source_amount, 'second_source' => $request->second_source, 'second_source_specific' => $request->second_source_specific, 'second_source_member' => $request->second_source_member, 'second_source_gender' => $request->second_source_gender, 'second_source_amount' => $request->second_source_amount, 'third_source' => $request->third_source, 'third_source_specific' => $request->third_source_specific, 'third_source_member' => $request->third_source_member, 'third_source_gender' => $request->third_source_gender, 'third_source_amount' => $request->third_source_amount, 'combined_family_income' => $request->combined_family_income, 'family_monthly_expenditure' => $request->family_monthly_expenditure, 'amount_to_access_house' => $request->amount_to_access_house, 'coping_strategies' => $request->coping_strategies, 'power_making_decision' => $request->power_making_decision, 'distance_health_facility' => $request->distance_health_facility, 'latrine_access' => $request->latrine_access, 'latrine_type' => $request->latrine_type, 'human_waste_disposal' => $request->human_waste_disposal, 'source_for_drinking' => $request->source_for_drinking, 'source_domestic_use' => $request->source_domestic_use, 'access_sanitation_facilities' => $request->access_sanitation_facilities, 'closest_evac_center' => $request->closest_evac_center, 'aware_living_in_ndz' => $request->aware_living_in_ndz, 'hazards_affected_community' => $request->hazards_affected_community, 'hazards_affected_community_other' => $request->hazards_affected_community_other, 'land_ownership_status' => $request->land_ownership_status, 'with_land_title' => $request->with_land_title, 'pay_anything_to_live' => $request->pay_anything_to_live, 'aware_relocation_program' => $request->aware_relocation_program, 'relocation_preference' => $request->relocation_preference, 'relocation_preference_other' => $request->relocation_preference_other, 'relocation_plan' => $request->relocation_plan, 'relocation_plan_other' => $request->relocation_plan_other, 'number_relatives_within_brgy' => $request->number_relatives_within_brgy, 'number_family_members' => $request->number_family_members, 'gps_points' => $request->gps_points, 'ofda_beneficiary' => $request->ofda_beneficiary, 'remarks' => $request->remarks, 'profiling_date' => $request->profiling_date, 'interviewer_name' => $request->interviewer_name]);
return redirect('/family')->with('alert-success', 'The record has been saved!');
}
private function createFamily(SaveFamilyRequest $request)
{
$family = Family::create($request->all());
return $family;
}
