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'); });