/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
Model::unguard();
DB::statement('SET FOREIGN_KEY_CHECKS=0;');
DB::table('customers')->truncate();
DB::table('areas')->truncate();
DB::table('premises')->truncate();
DB::table('stores')->truncate();
$reader = ReaderFactory::create(Type::XLSX);
// for XLSX files
$filePath = 'database/seeds/seed_files/Store Mapping.xlsx';
$reader->open($filePath);
foreach ($reader->getSheetIterator() as $sheet) {
if ($sheet->getName() == 'Sheet1') {
$rowcnt = 0;
foreach ($sheet->getRowIterator() as $row) {
if ($rowcnt > 1) {
if (!is_null($row[0])) {
$customer = Customer::firstOrCreate(['customer_code' => $row[8], 'customer' => strtoupper($row[9])]);
$area = Area::firstOrCreate(['area_code' => $row[2], 'area' => strtoupper($row[3])]);
$premise = Premise::firstOrCreate(['premise_code' => $row[4], 'premise' => strtoupper($row[5])]);
Store::firstOrCreate(['customer_id' => $customer->id, 'area_id' => $area->id, 'premise_id' => $premise->id, 'store_code' => strtoupper($row[0]), 'store' => strtoupper($row[1])]);
}
}
$rowcnt++;
}
}
}
$reader->close();
DB::statement('SET FOREIGN_KEY_CHECKS=1;');
Model::reguard();
}
public function createReservation(Request $request)
{
$room_info = $request['room_info'];
$start_dt = Carbon::createFromFormat('d-m-Y', $request['start_dt'])->toDateString();
$end_dt = Carbon::createFromFormat('d-m-Y', $request['end_dt'])->toDateString();
$customer = Customer::firstOrCreate($request['customer']);
$reservation = Reservation::create();
$reservation->total_price = $room_info['total_price'];
$reservation->occupancy = $request['occupancy'];
$reservation->customer_id = $customer->id;
$reservation->checkin = $start_dt;
$reservation->checkout = $end_dt;
$reservation->save();
$date = $start_dt;
while (strtotime($date) < strtotime($end_dt)) {
$room_calendar = RoomCalendar::where('day', '=', $date)->where('room_type_id', '=', $room_info['id'])->first();
$night = ReservationNight::create();
$night->day = $date;
$night->rate = $room_calendar->rate;
$night->room_type_id = $room_info['id'];
$night->reservation_id = $reservation->id;
$room_calendar->availability--;
$room_calendar->reservations++;
$room_calendar->save();
$night->save();
$date = date("Y-m-d", strtotime("+1 day", strtotime($date)));
}
$nights = $reservation->nights;
$customer = $reservation->customer;
return $reservation;
}
public function createReservation(Request $request)
{
// $request = array (
// 'customer' =>
// array (
// 'first_name' => 'Marie-Laure',
// 'last_name' => 'Lamarque-Choy',
// 'email' => '*****@*****.**',
// ),
// 'room_info' =>
// array (
// 'id' => 4,
// 'name' => 'Large Studio',
// 'short_name' => 'LXS1',
// 'base_price' => '200.00',
// 'base_availability' => '3',
// 'max_occupancy' => '4',
// 'created_at' => '2016-01-11 00:00:00',
// 'updated_at' => '2016-01-11 00:00:00',
// 'total_price' => 0,
// ),
// 'start_dt' => '15-1-2016',
// 'end_dt' => '16-1-2016',
// 'occupancy' => '2',
// );
$room_info = $request['room_info'];
$start_dt = Carbon::createFromFormat('d-m-Y', $request['start_dt'])->toDateString();
$end_dt = Carbon::createFromFormat('d-m-Y', $request['end_dt'])->toDateString();
$customer = Customer::firstOrCreate($request['customer']);
$reservation = Reservation::create();
$reservation->total_price = $room_info['total_price'];
$reservation->occupancy = $request['occupancy'];
$reservation->customer_id = $customer->id;
$reservation->checkin = $start_dt;
$reservation->checkout = $end_dt;
//$var = "'".var_export($request->all())."''";
//return $var;
$reservation->save();
$date = $start_dt;
while (strtotime($date) < strtotime($end_dt)) {
$room_calendar = RoomCalendar::where('day', '=', $date)->where('room_type_id', '=', $room_info['id'])->first();
$night = ReservationNight::create();
$night->day = $date;
//dd($room_calendar);
$night->rate = $room_calendar->rate;
$night->room_type_id = $room_info['id'];
$night->reservation_id = $reservation->id;
$room_calendar->availability--;
$room_calendar->reservations++;
$room_calendar->save();
$night->save();
$date = date("Y-m-d", strtotime("+1 day", strtotime($date)));
}
$nights = $reservation->nights;
$customer = $reservation->customer;
return $reservation;
}
