/**
* Create a new user instance after a valid registration.
*
* @param array $data
* @return User
*/
public function create(array $data)
{
$church = Church::create(['name' => $data['church_name'], 'address' => $data['church_address']]);
$user = new User(['name' => $data['name'], 'email' => $data['email'], 'password' => bcrypt($data['password']), 'church_id' => $church['id'], 'dob' => $data['dob'], 'phone_number' => $data['phone_number']]);
$user->church_id = $church->id;
$user->admin = true;
$user->save();
$church->approved = true;
$church->initiator_id = $user->id;
$church->save();
return $user;
}
/**
* Display the specified resource.
*
* @param int $id
* @return Response
*/
public function show($id)
{
//
$church = Church::with('bulletins')->with('events')->find($id);
return $church;
}
/**
* Execute the console command.
*
* @return mixed
*/
public function fire()
{
//
$file = fopen("/home/daniel/Downloads/new_file.csv", "r");
while (!feof($file)) {
print_r(fgetcsv($file));
$row = fgetcsv($file);
$family_name = $row[1];
$user_name = $row[2];
$church_id = 1;
$church = Church::find($church_id);
// $zone_hash = {};
// $zone_hash["0"] = $church->zones()->where("name","=","Zone 0")->first()->id;
// $zone_hash["1"] = $church->zones()->where("name","=","Zone 1")->first()->id;
// $zone_hash["2"] = $church->zones()->where("name","=","Zone 2")->first()->id;
// $zone_hash["3"] = $church->zones()->where("name","=","Zone 3")->first()->id;
// $zone_hash["4"] = $church->zones()->where("name","=","Zone 4")->first()->id;
// $zone_hash["5"] = $church->zones()->where("name","=","Zone 5")->first()->id;
// $no_zone = $church->zones()->where("name","=","No Zone")->first()->id;
$user = App\User::where("name", "=", $user_name)->where("church_id", "=", $church_id)->first();
$family = App\Family::where("name", "=", $family_name)->first();
if ($user) {
if ($family) {
$family_id = $family->id;
if ($family_id == $user->family_id) {
} else {
$user->family_id = $family_id;
$user->save();
}
} else {
$new_family = new Family();
$new_family->name = $row[1];
$new_family->save();
User::whereIn("id", $user->id)->update(["family_id" => $new_family->id]);
}
} else {
$new_user = new User();
$new_user->name = $row[2];
$new_user->dob = $row[4];
$new_user->weddingDate = $row[5];
$new_user->baptism_taken = trim($row[6]) == "YES" ? true : false;
$new_user->annointing_taken = trim($row[7]) == "YES" ? true : false;
$new_user->phone_number = $row[8];
$new_user->email = $row[9];
$new_user->member_type = trim($row[10]) == "YES" ? 0 : 2;
$new_user->address = $row[11] + $row[12] + $row[13] + $row[14];
switch (trim($row[15])) {
case "0":
$new_user->zone_id = $church->zones()->where("name", "=", "Zone 0")->first()->id;
break;
case "1":
$new_user->zone_id = $church->zones()->where("name", "=", "Zone 1")->first()->id;
break;
case "2":
$new_user->zone_id = $church->zones()->where("name", "=", "Zone 2")->first()->id;
break;
case "3":
$new_user->zone_id = $church->zones()->where("name", "=", "Zone 3")->first()->id;
break;
case "4":
$new_user->zone_id = $church->zones()->where("name", "=", "Zone 4")->first()->id;
break;
case "5":
$new_user->zone_id = $church->zones()->where("name", "=", "Zone 5")->first()->id;
break;
default:
$new_user->zone_id = $church->zones()->where("name", "=", "No Zone")->first()->id;
}
$new_user->church_id = $church_id;
if ($family) {
$family_id = $family->id;
$new_user->family_id = $family_id;
$new_user->save();
} else {
$new_family = new Family();
$new_family->name = $row[1];
$new_family->save();
$new_user->family_id = $new_family->id;
$new_user->save();
}
}
}
fclose($file);
}
