public function run() { DB::table('seats')->delete(); Seat::truncate(); $Seats = array(); $lexer = new Lexer(new LexerConfig()); $interpreter = new Interpreter(); $interpreter->addObserver(function (array $row) use($Seats) { $ItemOne = \Todo\Seat::create(array('table_number' => $row[0], 'seat_number' => $row[1], 'auctionId' => $row[2])); $this->command->info("Added Auction Id for seat and table" . $row[2]); }); $fileName = $this->getDir() . '/Seats.csv'; $lexer->parse($fileName, $interpreter); }
public function emptySeat() { $emptySeat = Seat::select('seats.*')->leftJoin('attendees', 'attendees.seat_id', '=', 'seats.id')->whereNull('attendees.seat_id')->get(); return $emptySeat; }