public function ajax(Request $request)
{
if ($request->mode === 'update') {
$states = State::find($request->id);
if ($states->state === 1) {
$states->state = 0;
} else {
$states->state = 1;
}
$states->save();
$state = State::where('id', $request->id)->first();
return response()->json(['state' => $state->state, 'title' => $state->title]);
}
if ($request->mode === 'create') {
if ($request->title) {
$states = new State();
$states->title = $request->title;
$states->save();
return response()->json(['id' => $states->id]);
}
}
if ($request->mode === 'delete') {
$states = State::find($request->id);
$states->delete();
}
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
// Model::unguard();
//create a user
$user = new User();
$user->email = "*****@*****.**";
$user->password = Hash::make('password');
$user->save();
//create a country
$country = new Country();
$country->name = "United States";
$country->id = 236;
$country->save();
//create a state
$state = new State();
$state->name = "Pennsylvania";
$state->id = 1;
$state->save();
$city = new City();
$city->name = "Pittsburgh";
$city->id = 1;
$city->save();
//create a location
$location = new Location();
$location->city_id = $city->id;
$location->state_id = $state->id;
$location->country_id = $country->id;
$location->latitude = 40.44;
$location->longitude = 80;
$location->code = '15212';
$location->address_1 = "100 Main Street";
$location->save();
//create a new accommodation
$accommodation = new Accommodation();
$accommodation->name = "Royal Plaza Hotel";
$accommodation->location_id = $location->id;
// $location->id;
$accommodation->description = "A modern, 4-star hotel";
$accommodation->save();
//create a room
$room1 = new App\Room();
$room1->id = 1;
$room1->room_number = 'A01';
$room1->accommodation_id = $accommodation->id;
$room1->save();
//create another room
$room2 = new Room();
$room2->id = 2;
$room2->room_number = 'A02';
$room2->accommodation_id = $accommodation->id;
$room2->save();
//create the room array
$rooms = [$room1, $room2];
//$this->call('AuthorsTableSeeder');
//$this->command->info('Authors table seeded!');
//
$this->call(AmenityTableSeeder::class);
$this->command->info('Amenity Class Seeded table seeded!');
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(StateRequest $request)
{
/** save data from State form to database **/
$model = new State();
$model->name = $request->get('name');
$model->status = $request->get('status');
$model->save();
return redirect('state');
}
public static function findOrCreate($data)
{
$state = self::where('name', $data['state'])->first();
if (count($state) <= 0) {
$state = new State();
$state->name = $data['state'];
$state->country_id = Country::findOrCreate($data)->id;
$state->save();
}
return $state;
}
/**
* Store a newly created resource in storage.
*
* @param Request $request
* @return Response
*/
public function store(LocationCreateRequest $request)
{
$state = $request->input('state');
if (!($existingState = State::where('id', $state)->first())) {
$newState = new State();
$newState->name = $state;
$newState->save();
}
$locs = $request->input('lga');
foreach ($locs as $loc) {
$area = new Lga();
$area->name = $loc;
$area->state_id = $newState->id;
$area->save();
}
return redirect('/admin/location')->withSuccess("Area created.");
}
public function run()
{
DB::statement("TRUNCATE TABLE states CASCADE");
$state = new State(['abbr' => 'AC', 'name' => 'Acre']);
$state->id = 12;
$state->save();
$state = new State(['abbr' => 'AL', 'name' => 'Alagoas']);
$state->id = 27;
$state->save();
$state = new State(['abbr' => 'AP', 'name' => 'Amapá']);
$state->id = 16;
$state->save();
$state = new State(['abbr' => 'AM', 'name' => 'Amazonas']);
$state->id = 13;
$state->save();
$state = new State(['abbr' => 'BA', 'name' => 'Bahia']);
$state->id = 29;
$state->save();
$state = new State(['abbr' => 'CE', 'name' => 'Ceará']);
$state->id = 23;
$state->save();
$state = new State(['abbr' => 'DF', 'name' => 'Distrito Federal']);
$state->id = 53;
$state->save();
$state = new State(['abbr' => 'ES', 'name' => 'Espírito Santo']);
$state->id = 32;
$state->save();
$state = new State(['abbr' => 'GO', 'name' => 'Goiás']);
$state->id = 52;
$state->save();
$state = new State(['abbr' => 'MA', 'name' => 'Maranhão']);
$state->id = 21;
$state->save();
$state = new State(['abbr' => 'MT', 'name' => 'Mato Grosso']);
$state->id = 51;
$state->save();
$state = new State(['abbr' => 'MS', 'name' => 'Mato Grosso do Sul']);
$state->id = 50;
$state->save();
$state = new State(['abbr' => 'MG', 'name' => 'Minas Gerais']);
$state->id = 31;
$state->save();
$state = new State(['abbr' => 'PA', 'name' => 'Pará']);
$state->id = 15;
$state->save();
$state = new State(['abbr' => 'PB', 'name' => 'Paraíba']);
$state->id = 25;
$state->save();
$state = new State(['abbr' => 'PR', 'name' => 'Paraná']);
$state->id = 41;
$state->save();
$state = new State(['abbr' => 'PE', 'name' => 'Pernambuco']);
$state->id = 26;
$state->save();
$state = new State(['abbr' => 'PI', 'name' => 'Piauí']);
$state->id = 22;
$state->save();
$state = new State(['abbr' => 'RJ', 'name' => 'Rio de Janeiro']);
$state->id = 33;
$state->save();
$state = new State(['abbr' => 'RN', 'name' => 'Rio Grande do Norte']);
$state->id = 24;
$state->save();
$state = new State(['abbr' => 'RS', 'name' => 'Rio Grande do Sul']);
$state->id = 43;
$state->save();
$state = new State(['abbr' => 'RO', 'name' => 'Rondônia']);
$state->id = 11;
$state->save();
$state = new State(['abbr' => 'RR', 'name' => 'Roraima']);
$state->id = 14;
$state->save();
$state = new State(['abbr' => 'SC', 'name' => 'Santa Catarina']);
$state->id = 42;
$state->save();
$state = new State(['abbr' => 'SP', 'name' => 'São Paulo']);
$state->id = 35;
$state->save();
$state = new State(['abbr' => 'SE', 'name' => 'Sergipe']);
$state->id = 28;
$state->save();
$state = new State(['abbr' => 'TO', 'name' => 'Tocantins']);
$state->id = 17;
$state->save();
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(PostCreateRequest $request)
{
//dd(\Input::all());
$post = new Post();
$post->title = $request->get('title');
$post->company_name = $request->get('company');
$date = $request->get('closing');
//dd(date('Y-m-d', strtotime($date)));
$post->closing = date('Y-m-d', strtotime($date));
$post->job_description = $request->get('job_description');
$post->job_experience = $request->get('job_experience');
$post->company_description = $request->get('company_description');
$post->salary = $request->get('salary');
$publish = $request->get('publish');
$save = $request->get('save');
$state = $request->get('location');
$cat = $request->get('category');
$tags = $request->get('tags');
$tagNames = [];
foreach ($tags as $tag) {
if ($existingTag = Tag::where('name', $tag)->first()) {
$TagNames[] = $existingTag;
} else {
$newTag = new Tag();
$newTag->name = $tag;
$newTag->save();
$TagNames[] = $newTag;
}
}
if (isset($publish)) {
$post->active = 1;
$post->save();
$post->tags()->saveMany($TagNames);
$newCat = new Category();
$newCat->name = $cat;
$newCat->post_id = $post->id;
$newCat->save();
// $post->tags()->sync($tag);
$sta = new State();
$sta->name = $state;
$sta->post_id = $post->id;
$sta->save();
return redirect('admin')->withSuccess("New job has been published");
} else {
if (isset($save)) {
$post->active = 0;
$post->save();
$post->tags()->saveMany($TagNames);
$newCat = new Category();
$newCat->name = $cat;
$newCat->post_id = $post->id;
$newCat->save();
// $post->tags()->sync($tag);
$sta = new State();
$sta->name = $state;
$sta->post_id = $post->id;
$sta->save();
return redirect('/admin')->withErrors("The post has been saved for publishing later");
}
}
// dd(strip_tags($raw));
}
