public function update($id)
{
// save updated
$record = $this->records->find($id);
if (!$record) {
Farmer::create(Input::all());
return $this->respond($record);
}
$record->fill(Input::all())->save();
return $this->respond($record);
}
public function run()
{
DB::table('farmers')->delete();
Farmer::create(['user_id' => 8, 'farmer' => 'Stark, Tony', 'nick' => 'Ironman', 'ssn' => '123456799', 'address' => '1 Stark Towers', 'city' => 'Delhi', 'state_id' => 19, 'zip' => '71232', 'email' => '*****@*****.**', 'phone' => '9995550001', 'dob' => '07/15/1960', 'first_year_farmer' => 1979, 'farm_exp' => 36, 'new_client' => 0]);
Farmer::create(['user_id' => 9, 'farmer' => 'Wayne, Bruce', 'nick' => 'Batman', 'ssn' => '123456798', 'address' => '1 Bat Cave', 'city' => 'Gotham', 'state_id' => 4, 'zip' => '33773', 'email' => '*****@*****.**', 'phone' => '9995550002', 'dob' => '07/15/1961', 'first_year_farmer' => 1976, 'farm_exp' => 39]);
Farmer::create(['user_id' => 10, 'farmer' => 'Kent, Clark', 'nick' => 'Superman', 'ssn' => '123456797', 'address' => '1 Daily Planet', 'city' => 'Metropolis', 'state_id' => 25, 'zip' => '01011', 'email' => '*****@*****.**', 'phone' => '9995550003', 'dob' => '07/15/1962', 'first_year_farmer' => 2006, 'farm_exp' => 9]);
Farmer::create(['user_id' => 11, 'farmer' => 'Parker, Peter S', 'nick' => 'Spider-Man', 'ssn' => '123456796', 'address' => '1 Daily Bugle', 'city' => 'New York', 'state_id' => 4, 'zip' => '32155', 'email' => '*****@*****.**', 'phone' => '9995550004', 'dob' => '07/15/1963', 'first_year_farmer' => 2001, 'farm_exp' => 14]);
Farmer::create(['user_id' => 12, 'farmer' => 'Barton, Clint', 'nick' => 'Hawkeye', 'ssn' => '123456795', 'address' => '55 Nested Drive', 'city' => 'Feathering', 'state_id' => 25, 'zip' => '43534', 'email' => '*****@*****.**', 'phone' => '9995550005', 'dob' => '07/15/1964', 'first_year_farmer' => 2012, 'farm_exp' => 3]);
Farmer::create(['user_id' => 13, 'farmer' => 'Roth, Rachel', 'nick' => 'Raven', 'ssn' => '123456794', 'address' => '1 Teen Titan Way', 'city' => 'Natural', 'state_id' => 4, 'zip' => '10401', 'email' => '*****@*****.**', 'phone' => '9995550006', 'dob' => '07/15/1965', 'first_year_farmer' => 2004, 'farm_exp' => 11]);
Farmer::create(['user_id' => 14, 'farmer' => 'Prince, Diana', 'nick' => 'Wonder Woman', 'ssn' => '123456793', 'address' => 'The Palace', 'city' => 'Amazonia', 'state_id' => 25, 'zip' => '99440', 'email' => '*****@*****.**', 'phone' => '9995550007', 'dob' => '07/15/1966', 'first_year_farmer' => 1984, 'farm_exp' => 31]);
Farmer::create(['user_id' => 15, 'farmer' => 'Allen, Barry', 'nick' => 'Flash', 'ssn' => '123456792', 'address' => '1 Speedline Road', 'city' => 'Natural', 'state_id' => 4, 'zip' => '43555', 'email' => '*****@*****.**', 'phone' => '9995550008', 'dob' => '07/15/1967', 'first_year_farmer' => 2001, 'farm_exp' => 14]);
Farmer::create(['user_id' => 16, 'farmer' => 'Murdock, Matt', 'nick' => 'Daredevil', 'ssn' => '123456791', 'address' => '3 Blind Mouse Drive', 'city' => 'Monroe', 'state_id' => 19, 'zip' => '32568', 'email' => '*****@*****.**', 'phone' => '9995550009', 'dob' => '07/15/1968', 'first_year_farmer' => 2009, 'farm_exp' => 6]);
Farmer::create(['user_id' => 17, 'farmer' => 'Blake, Donald', 'nick' => 'Thor', 'ssn' => '123546790', 'address' => '1 Shield', 'city' => 'Asgard', 'state_id' => 19, 'zip' => '10401', 'email' => '*****@*****.**', 'phone' => '9995550010', 'dob' => '07/15/1969', 'first_year_farmer' => 2013, 'farm_exp' => 1]);
Farmer::create(['user_id' => 18, 'farmer' => 'Banner, Bruce', 'nick' => 'Hulk', 'ssn' => '123456789', 'address' => '1 Shield', 'city' => 'Natural', 'state_id' => 4, 'zip' => '10401', 'email' => '*****@*****.**', 'phone' => '9995550011', 'dob' => '07/15/1970', 'first_year_farmer' => 1996, 'farm_exp' => 19]);
Farmer::create(['user_id' => 19, 'farmer' => 'Rogers, Steve', 'nick' => 'Captain America', 'ssn' => '123456788', 'address' => '1 Shield', 'city' => 'Natural', 'state_id' => 4, 'zip' => '10401', 'email' => '*****@*****.**', 'phone' => '9995550012', 'dob' => '07/15/1971', 'first_year_farmer' => 2001, 'farm_exp' => 14]);
Farmer::create(['user_id' => 20, 'farmer' => 'Batson, Billy', 'nick' => 'Shazam', 'ssn' => '123456787', 'address' => '1 Magic Avenue', 'city' => 'Jackson', 'state_id' => 25, 'zip' => '44335', 'email' => '*****@*****.**', 'phone' => '9995550013', 'dob' => '07/15/1972', 'first_year_farmer' => 1999, 'farm_exp' => 16]);
Farmer::create(['user_id' => 21, 'farmer' => 'Manzer, Kate', 'nick' => 'Hawkgirl', 'ssn' => '123456786', 'address' => '1 Nest on the Bayou', 'city' => 'St. Roch', 'state_id' => 19, 'zip' => '73543', 'email' => '*****@*****.**', 'phone' => '9995550014', 'dob' => '07/15/1973', 'first_year_farmer' => 2010, 'farm_exp' => 4]);
}
// first row styling and writing content
$sheet->mergeCells('A1:W1');
$sheet->row(1, function ($row) {
$row->setFontFamily('Comic Sans MS');
$row->setFontSize(30);
});
$sheet->row(1, array('Some big header here'));
// second row styling and writing content
$sheet->row(2, function ($row) {
// call cell manipulation methods
$row->setFontFamily('Comic Sans MS');
$row->setFontSize(15);
$row->setFontWeight('bold');
});
$sheet->row(2, array('Something else here'));
// getting data to display - in my case only one record
$farmers = Farmer::get()->toArray();
// setting column names for data - you can of course set it manually
$sheet->appendRow(array_keys($farmers[0]));
// column names
// getting last row number (the one we already filled and setting it to bold
$sheet->row($sheet->getHighestRow(), function ($row) {
$row->setFontWeight('bold');
});
// putting users data as next rows
foreach ($farmers as $farmer) {
$sheet->appendRow($farmer);
}
});
})->export('xlsx');
});
