/** * Show the form for editing the specified room. * * @param int $id * @param int $channelId * @return Response */ public function getMap($id, $channelId) { $room = Room::find($id); $channelSettings = PropertiesChannel::getSettings($channelId, Property::getLoggedId()); $channel = ChannelFactory::create($channelSettings); $result = $channel->getInventoryList(); //todo temp // file_put_contents('1.txt', serialize($result)); // $result = unserialize(file_get_contents('1.txt')); //add Inventories and Plans to DB//TODO move to another place //delete exist maps Inventory::where(['channel_id' => $channelId, 'property_id' => $channelSettings->property_id])->delete(); //delete exist plan maps InventoryPlan::where(['channel_id' => $channelId, 'property_id' => $channelSettings->property_id])->delete(); if ($result) { foreach ($result as $inventory) { Inventory::create(['code' => $inventory['code'], 'name' => $inventory['name'], 'channel_id' => $channelId, 'property_id' => $channelSettings->property_id]); if ($inventory['plans']) { foreach ($inventory['plans'] as $plan) { InventoryPlan::create(['code' => $plan['code'], 'name' => $plan['name'], 'channel_id' => $channelId, 'inventory_code' => $inventory['code'], 'property_id' => $channelSettings->property_id]); } } } } $existMapping = []; // $mapCollection = InventoryMap::where( // [ // 'channel_id' => $channelId, // 'property_id' => $channelSettings->property_id // ] // ) //// ->where('room_id', '<>', $id) // ->lists('inventory_code', 'room_id'); // if ($mapCollection) { // foreach ($mapCollection as $map) { // $existMapping[] = $map; // } // }>F $inventories = Channel::find($channelId)->inventory()->where('property_id', Property::getLoggedId()); $inventoryList = []; $inventoryPlans = []; foreach ($inventories->get() as $inventory) { // if (in_array($inventory->code, $existMapping)) { // continue; // } $inventoryList[$inventory->code] = $inventory->name; $plans = $inventory->plans()->get(['name', 'code']); for ($i = 0; $i < count($plans); $i++) { //TODO rewrite to ONE query $plans[$i]->selected = InventoryMap::getByKeys($channelId, $channelSettings->property_id, $id, $plans[$i]['code'])->first() ? true : false; } $inventoryPlans[$inventory->code] = $plans; } $inventoryPlans = json_encode($inventoryPlans); $mapping = InventoryMap::getByKeys($channelId, $channelSettings->property_id, $id)->first(); return View::make('rooms.map', compact('room', 'channel', 'inventoryList', 'inventoryPlans', 'channelId', 'mapping')); }
public function run() { global $geo_cities, $geo_countries; $geo_cities = set_by_id(DB::f("select * from geo_cities")); $geo_countries = set_by_id(DB::f("select * from geo_countries")); Auth::run(); if ($user = Auth::getUser()) { $this->user = $user; } $this->parseRequest(); $old_CID = null; $is_called_common = 0; while ($this->CID != $old_CID) { $old_CID = $this->CID; try { $channel = ChannelFactory::create($this); $channel->run(); $this->storeData($channel->getData()); if ($this->CID == $old_CID && !$is_called_common && !$this->is_ajax) { $is_called_common = 1; $this->CID = "common"; } } catch (CHException $e) { if ($this->is_ajax) { $this->data["error"] = "[" . $e->getType() . "] " . $e->getMessage(); } else { $this->setError($e->getMessage(), $e->getType()); } } } if ($this->is_ajax) { $this->buildAjaxOut(); } else { $this->buildOut(); } }
/** * Display a listing of the resource. * GET /reservations * * @return Response */ public function getIndex() { $execResult = ['updated' => 0, 'created' => 0, 'bookings' => 0, 'cancelled' => 0, 'not_mapped' => 0]; $propertiesChannels = PropertiesChannel::where('property_id', Property::getLoggedId())->get(); foreach ($propertiesChannels as $channelSettings) { Log::debug($channelSettings); $channel = ChannelFactory::create($channelSettings); $result = $channel->getReservations(); Log::debug($result); if ($result['reservations']) { foreach ($result['reservations'] as $reservation) { $reservation['channel_id'] = $channelSettings->channel_id; $reservation['property_id'] = $channelSettings->property_id; $resModel = Reservation::getByKeys($channelSettings->channel_id, $channelSettings->property_id)->where('res_id', $reservation['res_id'])->first(); if (isset($reservation['cc_details']) && !empty($reservation['cc_details'])) { $reservation['cc_details'] = Crypt::encrypt($reservation['cc_details']); } switch ($reservation['status']) { case 'cancelled': if ($resModel) { $resModel->status = 'cancelled'; if ($reservation['res_cancel_fee']) { $resModel->res_cancel_fee = $reservation['res_cancel_fee']; } $resModel->cancelled_at = $resModel->freshTimestamp(); $resModel->save(); $execResult['cancelled']++; //TODO: send email about cancellation } break; case 'booked': $needAddRooms = true; if ($resModel) { if (isset($reservation['modified']) && $reservation['modified']) { $resModel->update($reservation); $execResult['updated']++; $resModel->bookings()->delete(); //TODO: send email about modification } else { $needAddRooms = false; } } else { $resModel = Reservation::create($reservation); $execResult['created']++; } if ($reservation['rooms'] && $needAddRooms) { foreach ($reservation['rooms'] as $room) { $room['reservation_id'] = $resModel->id; $room['channel_id'] = $reservation['channel_id']; $room['property_id'] = $reservation['property_id']; $mapping = InventoryMap::getMappedRoom($channelSettings->channel_id, $channelSettings->property_id, $room['inventory'], isset($room['plan']) ? $room['plan'] : null)->first(); if ($mapping) { $room['room_id'] = $mapping->room_id; } else { $execResult['not_mapped']++; //TODO: send email about NOT MAPPED ROOM } Booking::create($room); $execResult['bookings']++; } } break; } if ($resModel && $resModel->id) { $type = $resModel->status; if ($type != 'cancelled' && $resModel->modified) { $type = 'modify'; } $channel->setReservationConfirmation($resModel->id, $resModel->res_id, $type); } } } } return View::make('index', compact('execResult')); }
/** * Recursive function * TODO: move to another place * @param Room $room * @param Property $property * @param $data * @param $rate - rate value for update chanel * @param $weekDays * @param $errors * @param $depth */ function updateChannelRate($room, $property, $data, $rate, $weekDays, &$errors, &$depth) { if ($depth > 5) { //infinity loop protection return; } //get plan mapping $maps = InventoryMap::getByKeys(null, $property->id, $room->id)->get(); foreach ($maps as $mapping) { //get channel $channelSettings = PropertiesChannel::getSettings($mapping->channel_id, $mapping->property_id); if (!$channelSettings) { continue; } $channel = ChannelFactory::create($channelSettings); $channel->setCurrency($property->currency); //updating rates $result = $channel->setRate($mapping->inventory_code, $mapping->plan_code, $data['from_date'], $data['to_date'], $weekDays, $rate, isset($data['single_rate']) ? $data['single_rate'] : null); if (is_array($result)) { $formattedErrors = []; foreach ($result as $error) { $formattedErrors[] = $channelSettings->channel()->name . ': ' . $error; } $errors += $formattedErrors; } } //check if children rooms exist if ($children = $room->children()->get()) { if (!$children->isEmpty()) { $depth++; //so we go deep so lets do rate of current ROOM as default rate, //like if we directly set this rate in form $data['rate'] = $rate; foreach ($children as $child) { switch ($child->formula_type) { case 'x': $rate = $data['rate'] * $child->formula_value; break; case '+': $rate = $data['rate'] + $child->formula_value; break; case '-': $rate = $data['rate'] - $child->formula_value; break; } $this->updateChannelRate($child, $property, $data, $rate, $weekDays, $errors, $depth); } } } }