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