PHP Helper::getDaysFromTwoDate方法代码示例

 /**
  * @return array|\Zend\Http\Response|ViewModel
  */
 public function indexAction()
 {
     /**
      * @var ReservationsDAO $reservationsDao
      */
     $reservationsDao = $this->getServiceLocator()->get('dao_booking_booking');
     $pageToken = $this->params()->fromQuery('token');
     if ($pageToken) {
         $reservationData = $reservationsDao->getReservationDataForChargeAuthorizationPage($pageToken);
         if ($reservationData) {
             $now3d = new \DateTime(null, new \DateTimeZone($reservationData->getTimezone()));
             $now3d = strtotime($now3d->modify('-3 day')->format('Y-m-d'));
             if ($now3d > strtotime($reservationData->getReservationDateTo()) && $now3d > strtotime($reservationData->getCccaCreationDate())) {
                 return $this->redirect()->toRoute('home')->setStatusCode('301');
             }
         } else {
             return $this->redirect()->toRoute('home')->setStatusCode('301');
         }
     } else {
         return $this->redirect()->toRoute('home')->setStatusCode('301');
     }
     /**
      * @var ChargeAuthorizationService $chargeAuthorizationService
      */
     $chargeAuthorizationService = $this->getServiceLocator()->get('service_reservation_charge_authorization');
     $info = $chargeAuthorizationService->getInfoForCCCAPage($pageToken);
     $amount = $info->getAmount();
     $chargeAuthorizationService->changeChargeAuthorizationPageStatus($reservationData->getReservationId(), $pageToken, ChargeAuthorization::CHARGE_AUTHORIZATION_PAGE_STATUS_VIEWED);
     $cccaForm = new ChargeAuthorizationForm();
     $cccaForm->prepare();
     /**
      * @var ChargeDAO $chargesDao
      */
     $chargesDao = $this->getServiceLocator()->get('dao_booking_charge');
     $chargesSummary = $chargesDao->calculateChargesSummary($reservationData->getReservationId(), \DDD\Service\Booking\Charge::CHARGE_MONEY_DIRECTION_GINOSI_COLLECT);
     $cancellationPolicyData = ['is_refundable' => $reservationData->getIsRefundable(), 'refundable_before_hours' => $reservationData->getRefundableBeforeHours(), 'penalty_type' => $reservationData->getPenaltyType(), 'penalty_percent' => $reservationData->getPenaltyValue(), 'penalty_fixed_amount' => $reservationData->getPenaltyValue(), 'penalty_nights' => $reservationData->getPenaltyValue(), 'night_count' => \Library\Utility\Helper::getDaysFromTwoDate($reservationData->getReservationDateFrom(), $reservationData->getReservationDateTo()), 'code' => $reservationData->getCustomerCurrency()];
     /**
      * @var WebsiteApartmentService $websiteApartmentService
      */
     $websiteApartmentService = $this->getServiceLocator()->get('service_website_apartment');
     $cancellationPolicyDescriptionArray = $websiteApartmentService->cancelationPolicy($cancellationPolicyData);
     $cancellationPolicyDescription = $cancellationPolicyDescriptionArray['description'];
     $reservationData->setCancellationPolicy($cancellationPolicyDescription);
     $creditCardData = $chargeAuthorizationService->getCreditCardDataForAuthorizationPage($reservationData->getCreditCardId());
     if (is_null($amount)) {
         //for backup compatibility
         $amount = $chargesSummary->getSummaryInApartmentCurrency();
     }
     $this->layout()->userTrackingInfo = ['res_number' => $reservationData->getReservationNumber(), 'partner_id' => $reservationData->getPartnerId()];
     return new ViewModel(['cccaForm' => $cccaForm, 'reservationData' => $reservationData, 'creditCardData' => $creditCardData, 'chargesSummary' => $chargesSummary, 'amount' => $amount]);
 }

 /**
  * @param $cubilisRateIdDates
  * @param $roomTypeId
  * @param $dates
  * @param $bookingDomain
  * @param $fromCubilisRatesData
  * @param $productId
  * @param $channelResId
  * @param $partnerId
  * @param $isApartel
  * @param $building
  * @param $apartmentListUsed
  * @param $guestCount
  * @return array
  */
 public function getNightlyData($cubilisRateIdDates, $roomTypeId, $dates, $bookingDomain, $fromCubilisRatesData, $productId, $channelResId, $partnerId, $isApartel, $building, $apartmentListUsed, $guestCount)
 {
     /**
      * @var \DDD\Dao\Apartment\General $apartmentDao
      * @var \DDD\Dao\Apartel\Inventory $apartelInventoryDao
      * @var \DDD\Dao\Apartel\General $apartelDao
      * @var \DDD\Service\Reservation\RateSelector $rateSelector
      * @var \DDD\Service\Reservation\RateSelector $rateSelector
      * @var \DDD\Service\Reservation\PartnerSpecific $partnerSpecificService
      * @var \DDD\Dao\Partners\Partners $partnerDao
      * @var \DDD\Service\Apartel\Type $apartelTypeService
      * @var \DDD\Service\Partners $partnerService
      */
     $rateSelector = $this->getServiceLocator()->get('service_reservation_rate_selector');
     $partnerSpecificService = $this->getServiceLocator()->get('service_reservation_partner_specific');
     $apartmentInventoryDao = new Inventory($this->getServiceLocator(), '\\ArrayObject');
     $apartelTypeService = $this->getServiceLocator()->get('service_apartel_type');
     $partnerDao = $this->getServiceLocator()->get('dao_partners_partners');
     $partnerService = $this->getServiceLocator()->get('service_partners');
     $result = ['ratesData' => [], 'overbooking' => false, 'apartel' => false];
     // night count
     $nightCount = Helper::getDaysFromTwoDate($dates['date_from'], $dates['date_to']);
     // Apartel reservation
     if ($isApartel) {
         $apartelInventoryDao = $this->getServiceLocator()->get('dao_apartel_inventory');
         $apartelDao = $this->getServiceLocator()->get('dao_apartel_general');
         $apartelId = $productId;
         $rates = $apartelInventoryDao->getRateByCubilisRateIdDates($cubilisRateIdDates, $roomTypeId);
         // if empty get parent and create task
         if (!count($rates) || count($rates) != $nightCount) {
             $rates = $apartelInventoryDao->getRateByParentRateIdDates($dates, $roomTypeId);
             $result['rateMissingTask'] = true;
         }
         $rates = iterator_to_array($rates);
         $firstApartment = $apartelDao->getApartelCurrency($apartelId);
         $ginosiCurrency = $firstApartment['code'];
         // modification
         if ($bookingDomain) {
             $apartmentId = $bookingDomain->getApartmentIdAssigned();
         } else {
             // new reservation
             // get best apartment for apartel reservation
             $getApartmentForType = $apartelTypeService->getBestApartmentForType($roomTypeId, $dates, $guestCount, $apartmentListUsed, $building);
             if ($getApartmentForType['status'] == 'not-available') {
                 $result['overbooking'] = true;
             }
             $apartmentId = $getApartmentForType['apartment_id'];
         }
     } else {
         $rates = $apartmentInventoryDao->getRateByCubilisRateIdDates($cubilisRateIdDates, $roomTypeId);
         // if empty get parent and create task
         if (!count($rates) || count($rates) != $nightCount) {
             $rates = $apartmentInventoryDao->getRateByParentRateIdDates($dates, $roomTypeId);
             $result['rateMissingTask'] = true;
         }
         $apartmentId = $productId;
         $apartelId = 0;
         $apartmentDao = $this->getServiceLocator()->get('dao_apartment_general');
         $apartmentData = $apartmentDao->getCurrency($apartmentId);
         $ginosiCurrency = $apartmentData['code'];
     }
     $ratesData = [];
     $currencyNotMatch = $ratePriceNotMatch = $rateNameNot = false;
     //  Modification: check has availability this apartment after change date
     if ($bookingDomain && ($dates['date_from'] < $bookingDomain->getDateFrom() || $dates['date_to'] > $bookingDomain->getDateTo())) {
         $oldNightlyData = Helper::getDateListInRange($bookingDomain->getDateFrom(), date('Y-m-d', strtotime('-1 day', strtotime($bookingDomain->getDateTo()))));
         $newDateRange = Helper::getDateListInRange($dates['date_from'], date('Y-m-d', strtotime('-1 day', strtotime($dates['date_to']))));
         $diffDates = array_diff($newDateRange, $oldNightlyData);
         $apartmentAvailability = $apartmentInventoryDao->checkApartmentAvailabilityApartmentDateList($apartmentId, $diffDates);
         if (!$apartmentAvailability) {
             $result['overbooking'] = true;
         }
     }
     // init strategy to get Partner Id if one was not registered in our system
     $partner = ['id' => $partnerService::PARTNER_UNKNOWN, 'commission' => $partnerService::PARTNER_UNKNOWN_COMMISSION];
     if ($partnerId) {
         $changedPartnerId = $partnerSpecificService->changePartnerForSomeCases($partnerId, $apartmentId);
         $partnerId = $changedPartnerId ? $changedPartnerId : $partnerId;
         $isOurPartnerId = $changedPartnerId ? true : false;
         $partnerData = $partnerService->getPartnerDataForReservation($partnerId, $apartmentId, $isOurPartnerId);
         $partner = ['id' => $partnerData->getGid(), 'commission' => $partnerData->getCommission()];
     }
     // check apply fuzzy logic for this partner
     $applyFuzzyLogic = $partnerDao->checkFuzzyLogic($partner['id']);
     foreach ($rates as $rate) {
//.........这里部分代码省略.........

 /**
  * @param  int $apartment_id
  * @param  float $sale
  * @param  date $startDate
  * @param  date $endDate
  * @var    ginosiColl  ginosiCollectTransactionsSummaryInApartmentCurrency
  * @var    partnerColl  partnerCollectTransactionsSummaryInApartmentCurrency
  * @return Array
  */
 private function _getSaleArray($apartment_id, $sale, $startDate, $endDate, $passYear = false)
 {
     $sale['all_bookings'] = $sale['all_cancelations'] = $sale['all_cancelations'] = $sale['highest_sold_price'] = $sale['long_stay'] = $sale['stay_period']['long'] = 0;
     $sale['stay_period'] = [];
     $notUsedStatus = [ForBookingStatus::BOOKING_STATUS_CANCELLED_INVALID, ForBookingStatus::BOOKING_STATUS_CANCELLED_EXCEPTION, ForBookingStatus::BOOKING_STATUS_CANCELLED_TEST_BOOKING, ForBookingStatus::BOOKING_STATUS_CANCELLED_MOVED];
     /**
      * @var $bankTransactionService \DDD\Service\Booking\BankTransaction
      * @var \DDD\Dao\Booking\ReservationNightly $reservationNightlyDao
      */
     $bookingDao = new Booking($this->getServiceLocator(), 'DDD\\Domain\\Apartment\\Statistics\\ForBasicDataBooking');
     $userManagerDao = $this->getServiceLocator()->get('dao_user_user_manager');
     $reservationNightlyDao = $this->getServiceLocator()->get('dao_booking_reservation_nightly');
     $inventoryDao = new Inventory($this->getServiceLocator(), '\\ArrayObject');
     $bankTransactionService = $this->getServiceLocator()->get('service_booking_bank_transaction');
     $expenseDao = new ExpenseStatistics($this->getServiceLocator());
     $bookings = $bookingDao->getBookingsForYear($apartment_id, $startDate, $endDate, $notUsedStatus);
     $monthlyConst = $expenseDao->getMonthlyCost($apartment_id, $startDate, $endDate);
     // calculate with nightly data
     $fistDate = $startDate;
     $i = 0;
     while ($i <= 12) {
         $nextDate = date('Y-m-01', strtotime('+1 month', strtotime($fistDate)));
         $monthDays = cal_days_in_month(CAL_GREGORIAN, date('m', strtotime($fistDate)), date('Y', strtotime($fistDate)));
         // reservation day count
         $monthlyData = $reservationNightlyDao->getBookedMonthlyData($apartment_id, $fistDate, $nextDate);
         $bookedDayCount = $monthlyData['count'];
         $monthlySum = $monthlyData['sum'];
         // closed days
         $totalClosed = $inventoryDao->getClosedAv($apartment_id, $fistDate, $nextDate);
         $selectedMonth = date("M_Y", strtotime($fistDate));
         $sale['close_out'][$selectedMonth] = $totalClosed - $bookedDayCount;
         $sale['unsold_days'][$selectedMonth] = $monthDays - $bookedDayCount;
         $sale['monthly_av_price'][$selectedMonth] = number_format($bookedDayCount ? $monthlySum / $bookedDayCount : 0, 2, '.', '');
         // get highest and lowest sold prices
         if ($passYear) {
             // get highest price
             if ($sale['highest_sold_price'] < $monthlyData['max']) {
                 $sale['highest_sold_price'] = $monthlyData['max'];
             }
             // get lowest price
             if (!array_key_exists('lowest_sold_price', $sale) && $monthlyData['min']) {
                 $sale['lowest_sold_price'] = $monthlyData['min'];
             } elseif (isset($sale['lowest_sold_price']) && $sale['lowest_sold_price'] > $monthlyData['min'] && $monthlyData['min']) {
                 $sale['lowest_sold_price'] = $monthlyData['min'];
             }
         }
         $fistDate = $nextDate;
         $i++;
     }
     // Monthly Booking And Cancelations And Margin
     foreach ($bookings as $book) {
         $month = date("M_Y", strtotime($book->getDate_to()));
         /* @var $ginosiColl $ginosiCollectTransactionsSummaryDomain \DDD\Domain\Booking\TransactionSummary */
         $ginosiColl = $bankTransactionService->getTransactionsSummary($book->getId(), BankTransaction::TRANSACTION_MONEY_DIRECTION_GINOSI_COLLECT, [BankTransaction::BANK_TRANSACTION_TYPE_PAY]);
         $ginosiCollCurrency = $ginosiColl->getSummaryInApartmentCurrency();
         /* @var $partnerCollectTransactionsSummaryDomain \DDD\Domain\Booking\TransactionSummary */
         $partnerColl = $bankTransactionService->getTransactionsSummary($book->getId(), BankTransaction::TRANSACTION_MONEY_DIRECTION_PARTNER_COLLECT, [BankTransaction::BANK_TRANSACTION_TYPE_PAY]);
         $partnerCollCurrency = $partnerColl->getSummaryInApartmentCurrency();
         $transactionsSummary = $ginosiCollCurrency + $partnerCollCurrency;
         if (ForBookingStatus::BOOKING_STATUS_BOOKED == $book->getStatus()) {
             $sale['all_bookings'] += 1;
             $sale['monthly_bookings'][$month] += 1;
             $ginosiksRes = $userManagerDao->getGinosiksReservation($book->getGuestEmail());
             if ($ginosiksRes) {
                 $sale['free_sold'][$month] += 1;
             }
             $date_diff = Helper::getDaysFromTwoDate($book->getDate_to(), $book->getDate_from());
             if ($sale['long_stay'] < $date_diff) {
                 $sale['long_stay'] = $date_diff;
             }
         } elseif (ForBookingStatus::BOOKING_STATUS_CANCELLED_BY_CUSTOMER == $book->getStatus()) {
             $sale['all_cancelations'] += 1;
             $month = date("M_Y", strtotime($book->getDate_to()));
             $sale['monthly_cancalations'][$month] += 1;
         }
         $sale = $this->_setMonthlyCost($book, $month, $sale, $transactionsSummary);
     }
     //Calculate final monthly cost
     foreach ($monthlyConst as $month => $cost) {
         if (isset($sale['monthly_cost'][$month])) {
             $sale['monthly_cost'][$month] += $cost;
             $sale['monthly_cost_total'] += $cost;
             $sale['profit'][$month] = $sale['monthly_revenue'][$month] - $sale['monthly_cost'][$month];
         }
     }
     // Cancellation score
     $total_reservations = ($sale['all_cancelations'] + $sale['all_bookings']) * 100;
     if (0 != $total_reservations) {
         $sale['cancelation_score'] = $sale['all_cancelations'] / ($sale['all_cancelations'] + $sale['all_bookings']) * 100;
         $sale['cancelation_score'] = number_format($sale['cancelation_score'], 1);
     } else {
//.........这里部分代码省略.........

 /**
  * @param array $data
  * @return array
  */
 public function bookingDataByCCPassword($data)
 {
     /**
      * @var \DDD\Service\Website\Apartment $apartmentService
      * @var \DDD\Service\Booking\Charge $chargeService
      */
     $apartmentService = $this->getServiceLocator()->get('service_website_apartment');
     $chargeService = $this->getServiceLocator()->get('service_booking_charge');
     if (!isset($data['code']) || !ClassicValidator::checkCCPdateCode($data['code'])) {
         return false;
     }
     /**
      * @var \DDD\Dao\Booking\Booking $bookingDao
      */
     $bookingDao = $this->getServiceLocator()->get('dao_booking_booking');
     $bookingDao->setEntity(new \ArrayObject());
     $resData = $bookingDao->getResDataByCCUpdateCode($data['code']);
     if (!$resData) {
         return false;
     }
     $img = Helper::getImgByWith($resData['img1'], WebSite::IMG_WIDTH_SEARCH, true, true);
     if ($img) {
         $resData['image'] = $img;
     }
     $resData['user_currency'] = $resData['guest_currency_code'];
     $bookNightCount = Helper::getDaysFromTwoDate($resData['date_from'], $resData['date_to']);
     $resData['night_count'] = $bookNightCount;
     $resData['totalNigthCount'] = $bookNightCount;
     // Cancelation Policy
     $cancelationDate = $resData;
     $cancelationDate['penalty_percent'] = $cancelationDate['penalty_fixed_amount'] = $cancelationDate['penalty_nights'] = $resData['penalty_val'];
     $cancelationDate['night_count'] = $bookNightCount;
     $cancelationDate['code'] = $resData['apartment_currency_code'];
     $cancelationPolicy = $apartmentService->cancelationPolicy($cancelationDate);
     $resData['cancelation_type'] = $cancelationPolicy['type'];
     $resData['cancelation_policy'] = $cancelationPolicy['description'];
     $paymentDetails = $chargeService->getCharges($resData['id']);
     // When showing to customers we don't really want to show base and additional parts of taxes separately
     // This part of code runs through payment details and combines same type of taxes for same day into a single unit
     $floatPattern = '/-?(?:\\d+|\\d*\\.\\d+)/';
     $smarterPaymentDetails = [];
     if ($paymentDetails) {
         foreach ($paymentDetails as $payment) {
             if ($payment['type'] != 'tax') {
                 array_push($smarterPaymentDetails, $payment);
             } else {
                 $paymentKey = $payment['type_id'] . '-' . $payment['date'];
                 if (!isset($smarterPaymentDetails[$paymentKey])) {
                     $smarterPaymentDetails[$paymentKey] = $payment;
                 } else {
                     preg_match($floatPattern, $smarterPaymentDetails[$paymentKey]['label'], $match);
                     $currValue = $match[0];
                     $currPrice = $smarterPaymentDetails[$paymentKey]['price'];
                     preg_match($floatPattern, $payment['label'], $match);
                     $additionalValue = $match[0];
                     $additionalPrice = $payment['price'];
                     $smarterPaymentDetails[$paymentKey]['label'] = str_replace($currValue, $currValue + $additionalValue, $smarterPaymentDetails[$paymentKey]['label']);
                     $smarterPaymentDetails[$paymentKey]['price'] = str_replace($currPrice, $currPrice + $additionalPrice, $smarterPaymentDetails[$paymentKey]['price']);
                     $smarterPaymentDetails[$paymentKey]['price_view'] = str_replace($currPrice, $currPrice + $additionalPrice, $smarterPaymentDetails[$paymentKey]['price_view']);
                 }
             }
         }
     }
     $resData['paymentDetails']['payments'] = $smarterPaymentDetails;
     return $resData;
 }

 /**
  * @param \DDD\Domain\Booking\ChargeProcess $reservation
  * @param bool|false $isBookerPrice
  * @return array
  *
  */
 public function getToBeChargedItems($reservation, $isBookerPrice = false)
 {
     /**
      * @var $bookingTicketService \DDD\Service\Booking\BookingTicket
      * @var ApartmentMainService $apartmentMainService
      * @var \DDD\Service\Textline $textlineService
      */
     $bookingTicketService = $this->getServiceLocator()->get('service_booking_booking_ticket');
     $textlineService = $this->getServiceLocator()->get('service_textline');
     $discountParams = [];
     if ($reservation->getPartnerId()) {
         $discountParams = ['aff_id' => $reservation->getPartnerId(), 'email' => $reservation->getGuestEmail()];
     }
     if ($isBookerPrice) {
         $totalPrice = $reservation->getBookerPrice();
         $price = $reservation->getBookerPrice();
     } else {
         $totalPrice = $reservation->getPrice();
         $price = $reservation->getPrice();
     }
     $nightCount = Helper::getDaysFromTwoDate($reservation->getDateTo(), $reservation->getDateFrom());
     $currencySymbol = $reservation->getCurrencySymbol();
     // Night Charges
     $chargesList = [['label' => Helper::evaluateTextline($textlineService->getUniversalTextline(1580), ['{{NIGHT_COUNT}}' => $nightCount]), 'price_view' => $currencySymbol . number_format($totalPrice, 2, '.', ' '), 'price' => $totalPrice, 'percent' => 0, 'type' => 'night', 'class' => '', 'description' => '', 'tax_included' => '']];
     // Discount Charges
     $discountValidator = $bookingTicketService->validateAndCheckDiscountData($discountParams, false);
     $discounted = false;
     if (isset($discountValidator['discount_value']) && $discountValidator['valid'] && isset($discountValidator['discount_value']) && ceil($discountValidator['discount_value'])) {
         $discountValue = $totalPrice * $discountValidator['discount_value'] / 100;
         $price = $totalPrice - $discountValue;
         $discounted = true;
         $totalPrice = $totalPrice - $discountValue;
         array_push($chargesList, ['label' => (isset($discountValidator['partner_name']) ? $discountValidator['partner_name'] : '') . ' ' . $textlineService->getUniversalTextline(1503), 'price_view' => '- ' . $currencySymbol . number_format($discountValue, 2, '.', ' '), 'price' => $discountValue, 'percent' => 0, 'type' => 'discount', 'class' => 'text-danger', 'description' => '', 'tax_included' => '']);
     }
     // Taxes Charges
     /** @var \DDD\Service\Currency\Currency $currencyService */
     $currencyService = $this->getServiceLocator()->get('service_currency_currency');
     $currencyRate = 1;
     if ($reservation->getGuestCurrency() != $reservation->getApartmentCurrency()) {
         $currencyRate = $currencyService->getCurrencyConversionRate($reservation->getGuestCurrency(), $reservation->getApartmentCurrency());
     }
     if ($reservation->getCityTotType() > 0 && $reservation->getCityTot() > 0) {
         $taxDiscounted = false;
         $totDuration = $reservation->getTotMaxDuration() ? min($reservation->getTotMaxDuration(), $nightCount) : $nightCount;
         $totValue = $reservation->getCityTot() + $reservation->getTotAdditional();
         if ($reservation->getCityTotType() == Taxes::TAXES_TYPE_PERCENT) {
             $cityTot = $price / 100 * $totValue * $totDuration / $nightCount;
             $taxValue = $totValue . ' %';
             if ($discounted) {
                 $taxDiscounted = true;
             }
             $percent = $totValue;
         } else {
             $cityTot = $totDuration * $totValue * $currencyRate;
             $taxValue = $currencySymbol . ' ' . number_format($totValue * $currencyRate, 2, '.', ' ') . ' ' . $textlineService->getUniversalTextline(1473);
             $percent = 0;
         }
         array_push($chargesList, ['label' => $textlineService->getUniversalTextline(1259) . ' (' . $taxValue . ($reservation->getTotIncluded() == 1 ? ', ' . $textlineService->getUniversalTextline(1472) : '') . ') ' . ($taxDiscounted ? $textlineService->getUniversalTextline(1633) : ''), 'price_view' => $currencySymbol . number_format($cityTot, 2, '.', ' '), 'price' => $cityTot, 'percent' => $percent, 'duration' => $totDuration, 'type' => 'tax', 'class' => 'text-primary', 'description' => $textlineService->getUniversalTextline(1429), 'tax_included' => $reservation->getTotIncluded() == 1 ?: '', 'date' => $reservation->getDateFrom(), 'type_id' => BookingAddon::ADDON_TYPE_TAX_TOT]);
         if ($reservation->getTotIncluded() != 1) {
             $totalPrice += $cityTot;
         }
     }
     if ($reservation->getCityVatType() > 0 && $reservation->getCityVat() > 0) {
         $taxDiscounted = false;
         $vatDuration = $reservation->getVatMaxDuration() ? min($reservation->getVatMaxDuration(), $nightCount) : $nightCount;
         $vatValue = $reservation->getCityVat() + $reservation->getVatAdditional();
         if ($reservation->getCityVatType() == Taxes::TAXES_TYPE_PERCENT) {
             $cityVat = $price / 100 * $vatValue * $vatDuration / $nightCount;
             $taxValue = $vatValue . ' %';
             if ($discounted) {
                 $taxDiscounted = true;
             }
             $percent = $vatValue;
         } else {
             $cityVat = $vatDuration * $vatValue * $currencyRate;
             $taxValue = $currencySymbol . number_format($vatValue * $currencyRate, 2, '.', ' ') . ' ' . $textlineService->getUniversalTextline(1473);
             $percent = 0;
         }
         array_push($chargesList, ['label' => $textlineService->getUniversalTextline(1260) . ' (' . $taxValue . ($reservation->getVatIncluded() == 1 ? ', ' . $textlineService->getUniversalTextline(1472) : '') . ') ' . ($taxDiscounted ? $textlineService->getUniversalTextline(1633) : ''), 'price_view' => $currencySymbol . number_format($cityVat, 2, '.', ' '), 'price' => $cityVat, 'percent' => $percent, 'duration' => $vatDuration, 'type' => 'tax', 'class' => 'text-primary', 'description' => $textlineService->getUniversalTextline(1430), 'tax_included' => $reservation->getVatIncluded() == 1 ?: '', 'date' => $reservation->getDateFrom(), 'type_id' => BookingAddon::ADDON_TYPE_TAX_VAT]);
         if ($reservation->getVatIncluded() != 1) {
             $totalPrice += $cityVat;
         }
     }
     if ($reservation->getCitySalesTaxType() > 0 && $reservation->getCitySalesTax() > 0) {
         $taxDiscounted = false;
         $salesTaxDuration = $reservation->getSalesTaxMaxDuration() ? min($reservation->getSalesTaxMaxDuration(), $nightCount) : $nightCount;
         $salesTaxValue = $reservation->getCitySalesTax() + $reservation->getSalesTaxAdditional();
         if ($reservation->getCitySalesTaxType() == Taxes::TAXES_TYPE_PERCENT) {
             $citySalesTax = $price / 100 * $salesTaxValue * $salesTaxDuration / $nightCount;
             $taxValue = $salesTaxValue . ' %';
             if ($discounted) {
                 $taxDiscounted = true;
             }
             $percent = $salesTaxValue;
//.........这里部分代码省略.........

 /**
  * @param $apartel
  * @param $arrival
  * @param $departure
  * @param $guest
  * @param $pageItemCount
  * @param $offset
  * @param $bedrooms
  * @return array
  */
 public function getApartmentsByApartelDate($apartel, $arrival, $departure, $guest, $pageItemCount, $offset, $bedrooms)
 {
     $bookNightCount = Helper::getDaysFromTwoDate($arrival, $departure);
     $checkNightCount = Helper::getDaysFromTwoDate($arrival, date('Y-m-d'));
     $bedroomsSqlPart = '';
     if (count($bedrooms) > 0 && count($bedrooms) < 12) {
         $bedroomsSqlPart = 'AND apartment.bedroom_count in (' . implode(',', $bedrooms) . ')';
     }
     $sql = "\n                SELECT SQL_CALC_FOUND_ROWS sub2.*, MIN(sub2.price_avg) as price_min, MAX(sub2.price_avg) as price_max FROM (\n                    SELECT sub1.*, avg(price_av) as price_avg, MIN(availability) as availability_min FROM  (\n                        SELECT\n                              apartment.id            AS prod_id,\n                              apartment.name          AS prod_name,\n                              apartment.url           AS url,\n                              apartment.score         AS score,\n                              apartment.max_capacity  AS capacity,\n                              apartment.city_id,\n                              apartment.country_id,\n                              media.img1              AS img1,\n                              apartment.bedroom_count AS bedroom_count,\n                              apartment.square_meters AS square_meters,\n                              apartment.address       AS address,\n                              (rate_av.availability)  AS availability,\n                              (rate_av.price)         AS price_av,\n                              rates.id                AS rate_id,\n                              apartment.currency_id,\n                              rates.name              AS rate_name,\n                              currency.code,\n                              currency.symbol,\n                              det1.slug as slug,\n                              apartel.apartment_group_id\n                            FROM " . DbTables::TBL_APARTEL_REL_TYPE_APARTMENT . " AS rel_apartel\n                              INNER JOIN " . DbTables::TBL_APARTEL_TYPE . " AS apartel_type ON rel_apartel.apartel_type_id = apartel_type.id\n                              INNER JOIN " . DbTables::TBL_APARTELS . " AS apartel ON apartel_type.apartel_id = apartel.id\n                              INNER JOIN " . DbTables::TBL_APARTMENTS . " AS apartment ON rel_apartel.apartment_id = apartment.id\n                              INNER JOIN " . DbTables::TBL_CITIES . " AS city ON apartment.city_id = city.id\n                              INNER JOIN " . DbTables::TBL_APARTMENT_IMAGES . " AS media ON apartment.id = media.apartment_id\n                              INNER JOIN " . DbTables::TBL_APARTMENT_RATES . " AS rates ON apartment.id = rates.apartment_id\n                                                                        AND rates.active = 1\n                                                                        AND rates.min_stay <= ?\n                                                                        AND rates.max_stay >= ?\n                                                                        AND rates.release_period_start <= ?\n                                                                        AND rates.release_period_end >= ?\n                              INNER JOIN ga_apartment_inventory AS rate_av ON rates.id = rate_av.rate_id\n                              INNER JOIN " . DbTables::TBL_CURRENCY . " as currency ON apartment.currency_id = currency.id\n                              INNER JOIN " . DbTables::TBL_LOCATION_DETAILS . " AS det1 ON city.detail_id = det1.id\n                            WHERE apartel.slug = ? AND apartment.status = " . Objects::PRODUCT_STATUS_LIVEANDSELLIG . "\n                                  AND rates.capacity >= ?\n                                  AND rate_av.date >= ?\n                                  AND rate_av.date < ?\n                                  {$bedroomsSqlPart}\n                            ORDER BY apartment.id ASC, rate_av.availability ASC\n                    ) as sub1 GROUP BY sub1.rate_id\n                )  as sub2  WHERE sub2.availability_min = 1\n                GROUP BY sub2.prod_id\n                ORDER BY sub2.score DESC, sub2.price_avg ASC, sub2.prod_name ASC\n                LIMIT {$pageItemCount} OFFSET {$offset}\n        ";
     $statement = $this->adapter->createStatement($sql, [$bookNightCount, $bookNightCount, $checkNightCount, $checkNightCount, $apartel, $guest, $arrival, $departure]);
     $result = $statement->execute();
     $statementCount = $this->adapter->query('SELECT FOUND_ROWS() as total');
     $resultCount = $statementCount->execute();
     $rowCount = $resultCount->current();
     $total = $rowCount['total'];
     return ['result' => $result, 'total' => $total];
 }

 /**
  * @param int|bool $reservationId
  * @return array
  */
 public function getReceiptData($reservationId = false)
 {
     /**
      * @var \DDD\Dao\Booking\Charge $chargeDao
      * @var \DDD\Dao\Booking\ChargeTransaction $transactionDao
      * @var \DDD\Dao\Booking\Booking $bookingDao
      */
     $chargeDao = $this->getServiceLocator()->get('dao_booking_charge');
     $transactionDao = $this->getServiceLocator()->get('dao_booking_change_transaction');
     $bookingDao = $this->getServiceLocator()->get('dao_booking_booking');
     if (!$reservationId) {
         return ['status' => 'error', 'msg' => TextConstants::ERROR];
     }
     $reservationData = $bookingDao->getReceiptData($reservationId);
     if (!$reservationData) {
         return ['status' => 'error', 'msg' => TextConstants::ERROR];
     }
     $charges = $chargeDao->getChargesByReservationId($reservationId, 1, false, true);
     $transactions = $transactionDao->getReservationTransactionsAllCurrency($reservationId);
     // Generate smarter charges list
     // We don't want customers to see two Tax charges of same type for same day!
     // Besides, we don't really need all of the info getChargesByReservationId() provides
     $smarterCharges = [];
     if ($charges && $charges->count()) {
         foreach ($charges as $charge) {
             if (!isset($smarterCharges[$charge->getAddons_type() . '-' . $charge->getReservationNightlyDate()])) {
                 $smarterCharges[$charge->getAddons_type() . '-' . $charge->getReservationNightlyDate()] = ['id' => $charge->getId(), 'acc_amount' => $charge->getAcc_amount(), 'acc_currency' => $charge->getApartmentCurrency(), 'addon' => $charge->getAddon(), 'addons_value' => $charge->getAddons_value(), 'addons_type' => $charge->getAddons_type(), 'type' => $charge->getType(), 'location_join' => $charge->getLocation_join(), 'tax_type' => $charge->getTaxType(), 'reservation_nighly_date' => $charge->getReservationNightlyDate(), 'rate_name' => $charge->getRateName(), 'money_direction' => $charge->getMoneyDirection()];
             } else {
                 $smarterCharges[$charge->getAddons_type() . '-' . $charge->getReservationNightlyDate()]['acc_amount'] += $charge->getAcc_amount();
                 $smarterCharges[$charge->getAddons_type() . '-' . $charge->getReservationNightlyDate()]['addons_value'] += $charge->getAddons_value();
             }
         }
     }
     return ['status' => 'success', 'reservation' => $reservationData, 'charges' => $smarterCharges, 'transactions' => $transactions, 'today' => date('d M Y'), 'nightCount' => Helper::getDaysFromTwoDate($reservationData['date_from'], $reservationData['date_to'])];
 }

 /**
  * @param $rates
  * @param $reservationPrice
  * @param $reservationId
  * @param bool $isNew
  * @param bool $isApartel
  * @return array
  */
 public function select($rates, $reservationPrice, $reservationId, $isNew = false, $isApartel = false)
 {
     /**
      * @var Booking $bookingDao
      * @var WorstCXLPolicySelector $policyService
      * @var Rate $rateDao
      * @var \DDD\Dao\Apartel\Rate $apartelRateDao
      */
     $worstPolicyData = ['is_refundable' => RateService::APARTMENT_RATE_NON_REFUNDABLE, 'penalty' => 0, 'penalty_fixed_amount' => $reservationPrice, 'refundable_before_hours' => 0, 'penalty_val' => 0];
     $bookingDao = $this->getServiceLocator()->get('dao_booking_booking');
     $ratesWithPolicy = [];
     // Reservation Data
     $reservationPolicyData = $bookingDao->getReservationPolicyData($reservationId);
     if (!$reservationPolicyData) {
         return $worstPolicyData;
     }
     // Existing policy
     if (!$isNew) {
         $ratesWithPolicy[] = ['is_refundable' => $reservationPolicyData['is_refundable'], 'penalty_type' => $reservationPolicyData['penalty'], 'refundable_before_hours' => $reservationPolicyData['refundable_before_hours'], 'penalty_val' => $reservationPolicyData['penalty_val']];
     }
     // Incoming Rates
     if (!empty($rates)) {
         if ($isApartel) {
             $apartelRateDao = $this->getServiceLocator()->get('dao_apartel_rate');
             $ratesData = $apartelRateDao->getRatesPolicyData($rates);
         } else {
             $rateDao = $this->getServiceLocator()->get('dao_apartment_rate');
             $ratesData = $rateDao->getRatesPolicyData($rates);
         }
         if ($ratesData->count()) {
             foreach ($ratesData as $row) {
                 $ratesWithPolicy[] = ['is_refundable' => $row['is_refundable'], 'penalty_type' => $row['penalty_type'], 'refundable_before_hours' => $row['refundable_before_hours'], 'penalty_val' => $row['penalty_type'] == RateService::PENALTY_TYPE_PERCENT ? $row['penalty_percent'] : ($row['penalty_type'] == RateService::PENALTY_TYPE_FIXED_AMOUNT ? $row['penalty_fixed_amount'] : $row['penalty_nights'])];
             }
         }
     }
     // Calculate best penalty policy
     $nights = Helper::getDaysFromTwoDate($reservationPolicyData['date_from'], $reservationPolicyData['date_to']);
     $penaltyVal = $penalty = $penaltyAmount = $refundableBeforeHours = 0;
     $isRefundablePenalty = false;
     foreach ($ratesWithPolicy as $policy) {
         if ($policy['is_refundable'] == RateService::APARTMENT_RATE_NON_REFUNDABLE) {
             //Non Refundable
             return $worstPolicyData;
         } elseif ($policy['is_refundable'] == RateService::APARTMENT_RATE_REFUNDABLE && $reservationPolicyData['penalty_hours'] <= $policy['refundable_before_hours']) {
             // Refundable penalty period
             $penaltyData = $this->penaltyCalculateData(['penalty_val' => $policy['penalty_val'], 'penalty_type' => $policy['penalty_type']], $nights, $reservationPrice, 1);
             $penaltyAmountNew = $penaltyData['penalty_amount'];
             if ($penaltyAmountNew > $penaltyAmount) {
                 $penalty = $policy['penalty_type'];
                 $penaltyAmount = $penaltyAmountNew;
                 $penaltyVal = $penaltyData['penalty_val'];
                 $refundableBeforeHours = $policy['refundable_before_hours'];
             }
             $isRefundablePenalty = true;
         } elseif ($policy['is_refundable'] == RateService::APARTMENT_RATE_REFUNDABLE && !$isRefundablePenalty) {
             // Refundable flexible period, Nothing change, apply what has
             $penaltyData = $this->penaltyCalculateData(['penalty_val' => $policy['penalty_val'], 'penalty_type' => $policy['penalty_type']], $nights, $reservationPrice, 1);
             $penaltyAmountNew = $penaltyData['penalty_amount'];
             if ($penaltyAmountNew > $penaltyAmount) {
                 $penalty = $policy['penalty_type'];
                 $penaltyAmount = $penaltyAmountNew;
                 $penaltyVal = $penaltyData['penalty_val'];
                 $refundableBeforeHours = $policy['refundable_before_hours'];
             }
         }
     }
     $worstPolicyData = ['is_refundable' => RateService::APARTMENT_RATE_REFUNDABLE, 'penalty' => $penalty, 'penalty_fixed_amount' => $penaltyAmount, 'refundable_before_hours' => $refundableBeforeHours, 'penalty_val' => $penaltyVal];
     return $worstPolicyData;
 }

 /**
  * Use to generate and download reservations CSV file
  */
 public function downloadCsvAction()
 {
     /**
      * @var \DDD\Service\Booking\BookingManagement $bookingManagementService
      * @var \DDD\Service\Booking\BookingTicket $bookingTicketService
      * @var GeoliteCountry $geoliteCountryService
      * @var BookingExportRow[]|\ArrayObject $reservations
      */
     $bookingManagementService = $this->getServiceLocator()->get('service_booking_management');
     $bookingTicketService = $this->getServiceLocator()->get('service_booking_booking_ticket');
     $geoliteCountryService = $this->getServiceLocator()->get('service_geolite_country');
     // getting query parameters
     $queryParams = $this->params()->fromQuery();
     // get reservations data
     $reservations = $bookingManagementService->getReservationsToExport(null, null, $queryParams);
     $filteredArray = [];
     $currencyDao = $this->getServiceLocator()->get('dao_currency_currency');
     $currencyUtility = new Currency($currencyDao);
     foreach ($reservations as $reservation) {
         $isBlacklist = $reservation->isBlacklist();
         $isBlacklist = is_null($isBlacklist) ? 'No' : 'Yes';
         $sumAndBalanc = $bookingTicketService->getSumAndBalanc($reservation->getId());
         $filteredArray[] = ["Reservation" => $reservation->getReservationNumber(), "Affiliate ID" => $reservation->getAffiliateID(), "Affiliate Name" => $reservation->getPartnerName(), "Affiliate Reference" => $reservation->getPartnerRef(), "Status" => $reservation->getStatus(), "Blacklist" => $isBlacklist, "Apartel" => $reservation->getApartel(), "Booking Date" => date('Y-m-d', strtotime($reservation->getReservationDate())), "Booking Time" => date('H:i:s', strtotime($reservation->getReservationDate())), "Apartment Id" => $reservation->getApartmentIdAssigned(), "Apartment Name" => $reservation->getProductName(), "Apartment Building" => $reservation->getApartmentBuilding(), "Apartment City" => $reservation->getApartmentCity(), "Guest" => $reservation->getGuestFullName(), "Country" => $reservation->getCountry_name(), "City" => $reservation->getGuestCityName(), "IP" => $geoliteCountryService->composeIPAndCountryNameString($reservation->getIP()), "Arrival Date" => $reservation->getArrivalDate(), "Departure Date" => $reservation->getDepartureDate(), "Nights" => Helper::getDaysFromTwoDate($reservation->getArrivalDate(), $reservation->getDepartureDate()), "PAX" => $reservation->getPAX(), "Rate" => $reservation->getRateName(), "Base Price (EUR)" => $currencyUtility->convert(str_replace(',', '', $reservation->getPrice()), $reservation->getApartmentCurrencyCode(), 'EUR'), "Base Currency" => $reservation->getApartmentCurrencyCode(), "Base Price" => $reservation->getPrice(), "Charges(Ginosi)" => $sumAndBalanc['ginosiCollectChargesSummaryInApartmentCurrency'], "Transactions(Ginosi)" => $sumAndBalanc['ginosiCollectTransactionsSummaryInApartmentCurrency'], "Balance" => $reservation->getGuestBalance(), "Charges(Partner)" => $sumAndBalanc['partnerCollectChargesSummaryInApartmentCurrency'], "Transactions(Partner)" => $sumAndBalanc['partnerCollectTransactionsSummaryInApartmentCurrency'], "Partner Balance" => $reservation->getPartnerBalance(), "No Collection" => $reservation->getNo_collection(), "Review Score" => $reservation->getReviewScore(), "Like" => $reservation->getLike(), "Dislike" => $reservation->getDislike(), "Actual Arrival Date" => $reservation->getActualArrivalDate(), "Actual Departure Date" => $reservation->getActualDepartureDate()];
     }
     if (count($filteredArray)) {
         $response = $this->getResponse();
         $headers = $response->getHeaders();
         $utilityCsvGenerator = new CsvGenerator();
         $filename = 'reservations_' . str_replace(' ', '_', date('Y-m-d')) . '.csv';
         $utilityCsvGenerator->setDownloadHeaders($headers, $filename);
         $csv = $utilityCsvGenerator->generateCsv($filteredArray);
         $response->setContent($csv);
         return $response;
     } else {
         Helper::setFlashMessage(['notice' => 'The search results were empty, nothing to download.']);
         $url = $this->getRequest()->getHeader('Referer')->getUri();
         $this->redirect()->toUrl($url);
     }
 }

 public function indexAction()
 {
     /** @var UserManager $managerDao */
     $managerDao = $this->getServiceLocator()->get('dao_user_user_manager');
     $teamService = $this->getServiceLocator()->get('service_team_team');
     $auth = $this->getServiceLocator()->get('library_backoffice_auth');
     /** @var \DDD\Service\User\Schedule $scheduleService */
     $scheduleService = $this->getServiceLocator()->get('service_user_schedule');
     $userId = $this->params()->fromRoute('id');
     $userSessionId = $auth->getIdentity()->id;
     $isLoggedInUserGlobalManager = false;
     $profileViewer = false;
     $isManager = false;
     $itsMe = false;
     if ($auth->hasRole(Roles::ROLE_PROFILE_VIEWER)) {
         $profileViewer = true;
     }
     if ($auth->hasRole(Roles::ROLE_PEOPLE_MANAGEMENT)) {
         $isLoggedInUserGlobalManager = true;
     }
     $hasHRole = $auth->hasRole(Roles::ROLE_PEOPLE_MANAGEMENT_HR);
     if ($userId === null || $userId == $userSessionId) {
         $userId = $userSessionId;
         $itsMe = true;
     }
     $rUserDao = $this->getServiceLocator()->get('dao_user_user_manager');
     $rUser = $rUserDao->findUserById((int) $userId);
     if (!$rUser) {
         return $this->redirect()->toUrl('/');
     }
     if ($rUser->getStartDate() && $rUser->getStartDate() != '0000-00-00') {
         //604800 is the number of seconds in one week
         //31536000 is the number of seconds in one year
         $weeksWorked = floor((time() - strtotime($rUser->getStartDate())) % 31536000 / 604800);
         $yearsWorked = floor((time() - strtotime($rUser->getStartDate())) / 31536000);
         if ($weeksWorked < 0 && $yearsWorked < 0) {
             $weeksWorked = 0;
             $yearsWorked = 0;
         }
     } else {
         $weeksWorked = 0;
         $yearsWorked = 0;
     }
     // get User Manager id
     $managerId = $rUser->getManager_id();
     if ($managerId === '0') {
         $managerId = 64;
     }
     // get Manager Profile
     $myManager = $managerDao->getUserById((int) $managerId);
     if ($auth->hasRole(Roles::ROLE_PEOPLE_DIRECTORY) && $userSessionId == $managerId) {
         $isManager = true;
     }
     /**
      * @var \DDD\Service\User $userService
      */
     $userService = $this->getServiceLocator()->get('service_user');
     /** @var \DDD\Service\Profile $profileService */
     $profileService = $this->getProfileService();
     $cityDao = $this->getServiceLocator()->get('dao_geolocation_city');
     $userDao = $userService->getUsersById((int) $userId, $isManager || $isLoggedInUserGlobalManager || $hasHRole);
     if (!$userDao) {
         $view = new ViewModel();
         $view->setTemplate('backoffice/profile/disabled.phtml');
         return $view;
     }
     $userProfile = $userDao->get('user_main');
     $userOptions = $userService->getUserOptions((int) $userId);
     $countryId = $userProfile->getCountry_id();
     $cities = $cityDao->getCityByCountryId((int) $countryId);
     // Get user schedule for 3 weeks
     $userSchedule = $scheduleService->getUserScheduleInRange($userId, date('Y-m-d'), date('Y-m-d', strtotime('+20 day')));
     $userSubordinates = $profileService->getUserSubordinates($userId);
     $vacationRequest = $userService->getUserVacationRequest((int) $userId);
     $detailsForm = new ProfileDetailsForm('changeDetails');
     $passwordForm = new ProfilePasswordForm('changePassword');
     // reservation ginosik
     $resevations = [];
     $stayedDays = 0;
     $bookingDao = new \DDD\Dao\Booking\Booking($this->getServiceLocator(), 'DDD\\Domain\\Booking\\BookingProfile');
     $resevationsResult = $bookingDao->getGinosikResevations($userProfile->getEmail(), $userProfile->getAlt_email());
     foreach ($resevationsResult as $row) {
         $days = Helper::getDaysFromTwoDate($row->getDate_from(), $row->getDate_to());
         $stayedDays += $days;
         array_push($resevations, sprintf(TextConstants::PROFILE_GINOSI_RESERVATION, '/booking/edit/' . $row->getReservationNumber(), $row->getReservationNumber(), $row->getApartmentName(), $row->getDate_from(), $row->getDate_to(), $days, $row->getGuestEmail()));
     }
     /**
      * @var UserMainService $userMainService
      */
     $userMainService = $this->getServiceLocator()->get('service_user_main');
     $userDepartmentId = $userMainService->getUserDepartmentId($userId);
     $isDepartment = 1;
     $departments = $teamService->getTeamList(null, $isDepartment);
     $coDepartments = [];
     $coDepartments[-1] = '-- Departments --';
     foreach ($departments as $department) {
         $coDepartments[$department->getId()] = $department->getName();
     }
     $userTeams = $teamService->getUserTeams($userId);
     $vacationDaysCountUsedInThisYear = $userService->getVacationDaysCountUsedInThisYear($userId);
//.........这里部分代码省略.........

 /**
  * @param $bookingId
  * @param $itemId
  * @return array
  */
 public function getDataForFrontierCharge($bookingId, $itemId)
 {
     /**
      * @var \DDD\Service\Booking\BookingAddon $bookingAddonService
      * @var \DDD\Dao\Booking\Booking $bookingDao
      * @var \DDD\Service\Taxes $taxesService
      */
     $bookingTicketService = $this->getServiceLocator()->get('service_booking_booking_ticket');
     $bookingAddonService = $this->getServiceLocator()->get('service_booking_booking_addon');
     $taxesService = $this->getServiceLocator()->get('service_taxes');
     $apartmentGroupDao = $this->getServiceLocator()->get('dao_apartment_group_apartment_group');
     $chargeDao = $this->getServiceLocator()->get('dao_booking_charge');
     $bookingDao = $this->getServiceLocator()->get('dao_booking_booking');
     $accDetailsDao = new \DDD\Dao\Apartment\Details($this->getServiceLocator(), 'ArrayObject');
     $addonsArray = $bookingAddonService->getAddonsArray();
     $bookingData = $bookingDao->getBookingForFrontierCharge($bookingId);
     $detailsRow = $accDetailsDao->fetchOne(['apartment_id' => $bookingData['apartment_id_assigned']]);
     if ($detailsRow && (int) $detailsRow['cleaning_fee']) {
         foreach ($addonsArray as $key => $addon) {
             if ($addon['id'] == BookingAddon::ADDON_TYPE_CLEANING_FEE) {
                 $cleaningFee = $detailsRow['cleaning_fee'];
                 $addonsArray[$key]['cname'] = $bookingData['acc_currency_sign'];
                 $addonsArray[$key]['currency_rate'] = $bookingData['acc_currency_rate'];
                 $addonsArray[$key]['currency_id'] = $bookingData['acc_currency_id'];
                 $addonsArray[$key]['value'] = $cleaningFee;
             }
         }
     }
     $data = ['addons_array' => $addonsArray];
     $data['booking_data'] = $bookingData;
     $data['booking_data']['night_count'] = Helper::getDaysFromTwoDate($bookingData['date_to'], $bookingData['date_from']);
     // Taxes
     $nightCount = Helper::getDaysFromTwoDate($bookingData['date_to'], $bookingData['date_from']);
     $taxesParams = ['tot' => $bookingData['tot'], 'tot_type' => $bookingData['tot_type'], 'tot_included' => $bookingData['tot_included'], 'tot_max_duration' => $bookingData['tot_max_duration'], 'tot_additional' => $bookingData['tot_additional'], 'vat' => $bookingData['vat'], 'vat_type' => $bookingData['vat_type'], 'vat_included' => $bookingData['vat_included'], 'vat_additional' => $bookingData['vat_additional'], 'vat_max_duration' => $bookingData['vat_max_duration'], 'city_tax' => $bookingData['city_tax'], 'city_tax_type' => $bookingData['city_tax_type'], 'city_tax_included' => $bookingData['city_tax_included'], 'city_tax_additional' => $bookingData['city_tax_additional'], 'city_tax_max_duration' => $bookingData['city_tax_max_duration'], 'sales_tax' => $bookingData['sales_tax'], 'sales_tax_type' => $bookingData['sales_tax_type'], 'sales_tax_included' => $bookingData['sales_tax_included'], 'sales_tax_max_duration' => $bookingData['sales_tax_max_duration'], 'sales_tax_additional' => $bookingData['sales_tax_additional'], 'apartment_currency' => $bookingData['apartment_currency_code'], 'customer_currency' => $bookingData['guest_currency_code'], 'country_currency' => $bookingData['country_currency'], 'night_count' => $nightCount, 'rate_capacity' => $bookingData['rate_capacity'], 'occupancy' => $bookingData['occupancy']];
     $taxesData = $taxesService->getTaxesForCharge($taxesParams);
     $data += $taxesData;
     $apartmentGroup = $apartmentGroupDao->fetchOne(['id' => $itemId]);
     // Charges
     $charges = $chargeDao->getChargesByReservationId($bookingId, 1);
     $data['charges'] = $charges;
     $balances = $bookingTicketService->getSumAndBalanc($bookingId);
     $balance = number_format($balances['ginosiBalanceInApartmentCurrency'], 2, '.', '');
     $data['balance'] = $balance;
     $data['group_name'] = 'Group';
     if ($apartmentGroup) {
         $data['group_name'] = $apartmentGroup->getName();
     }
     return $data;
 }

 /**
  * @param array $data
  * @return array
  */
 public function apartmentSearch($data)
 {
     $filter = $this->filterSearchData($data);
     $result = ['status' => '', 'result' => []];
     $rateList = [];
     $apartment = $data['apartment'];
     $city = $data['city'];
     $guest = $data['guest'] > 0 ? (int) $data['guest'] : 1;
     $arrival = date('Y-m-d', strtotime($data['arrival']));
     $departure = date('Y-m-d', strtotime($data['departure']));
     $nightCount = Helper::getDaysFromTwoDate($arrival, $departure);
     $no_av_status = 'no_av';
     $no_av_result = ['arrival' => Helper::dateForUrl($arrival), 'departure' => Helper::dateForUrl($departure), 'guest' => $guest, 'city' => $city];
     if ($filter) {
         $rateDao = $this->getInventoryDao();
         $response = $rateDao->getAvailableRates($apartment, Helper::urlForSearch($city), $guest, $arrival, $departure);
         $i = 1;
         if ($response->count() > 0) {
             $currencySymbol = WebSite::DEFAULT_CURRENCY;
             $userCurrency = $this->getCurrencySite();
             $currencyDao = $this->getServiceLocator()->get('dao_currency_currency');
             $currencyResult = $currencyDao->fetchOne(['code' => $userCurrency]);
             if ($currencyResult) {
                 $currencySymbol = $currencyResult->getSymbol();
             }
             $currencyUtility = new Currency($currencyDao);
             foreach ($response as $row) {
                 //check user currency and apartment currency
                 if ($userCurrency != $row['code']) {
                     $price = $currencyUtility->convert($row['price'], $row['code'], $userCurrency);
                 } else {
                     $price = $row['price'];
                 }
                 //cancelation policy
                 $cancelationData = $row;
                 $cancelationData['night_count'] = $nightCount;
                 $cancelation = $this->cancelationPolicy($cancelationData);
                 $discountPrice = 0;
                 $visitor = new Container('visitor');
                 if (!is_null($visitor->partnerId) && (int) $visitor->partnerId) {
                     $partnerDao = new \DDD\Dao\Partners\Partners($this->getServiceLocator());
                     $partnerInfo = $partnerDao->fetchOne(['gid' => (int) $visitor->partnerId]);
                     $discountPrice = 0;
                     if ($partnerInfo && ceil($partnerInfo->getDiscount())) {
                         $discountPrice = number_format($price * (100 - $partnerInfo->getDiscount()) * 0.01, 2, '.', '');
                     }
                 }
                 //rateList
                 $rateList[] = ['primary' => $i === 1 ? true : false, 'rate' => ['id' => $row['id'], 'name' => $row['name']], 'capacity' => $row['capacity'], 'price' => number_format($price, 2, '.', ''), 'total_price' => number_format($nightCount * $price, 2, '.', ''), 'currency' => ['name' => $userCurrency, 'sign' => $currencySymbol], 'policy' => ['name' => $cancelation['type'], 'description' => $cancelation['description']], 'discount' => ['price' => $discountPrice, 'total' => number_format($nightCount * $discountPrice, 2, '.', '')]];
                 $i++;
             }
             $result['status'] = 'success';
             $result['result'] = $rateList;
         } else {
             $result['status'] = $no_av_status;
             $result['result'] = $no_av_result;
         }
         return $result;
     }
     return ['status' => $no_av_status, 'result' => $no_av_result];
 }

 public function getAvailableRates($apartmentUrl, $city, $guestCount, $arrivalDate, $departureDate)
 {
     $bookNightCount = Helper::getDaysFromTwoDate($arrivalDate, $departureDate);
     $checkNightCount = Helper::getDaysFromTwoDate($arrivalDate, date('Y-m-d'));
     $sql = "\n            select * from (\n                select\n                    product_rates.id               AS id,\n                    product_rates.name             AS name,\n                    product_rates.capacity         AS capacity,\n                    product_rates.type             AS type,\n                    product_rates.is_refundable    AS is_refundable,\n                    product_rates.refundable_before_hours AS refundable_before_hours,\n                    product_rates.penalty_percent  AS penalty_percent,\n                    product_rates.penalty_nights     AS penalty_nights,\n                    product_rates.penalty_fixed_amount   AS penalty_fixed_amount,\n                    product_rates.penalty_type     AS penalty_type,\n                    avg(rate_av.price)             AS price,\n                    min(rate_av.availability)     AS availability,\n                    apartments.currency_id         AS currency_id,\n                    geo_details.name            AS city_name,\n                    currency.code                  AS code,\n                    currency.symbol                AS symbol\n                from " . DbTables::TBL_APARTMENT_INVENTORY . " as rate_av\n                    left join " . DbTables::TBL_APARTMENT_RATES . "    as product_rates on product_rates.id = rate_av.rate_id\n                    left join " . DbTables::TBL_APARTMENTS . "       as apartments    on apartments.id = rate_av.apartment_id\n                    left join " . DbTables::TBL_CITIES . "           as cities        on cities.id = apartments.city_id\n                    left join " . DbTables::TBL_LOCATION_DETAILS . " as geo_details   on geo_details.id = cities.detail_id and lower(geo_details.name) = ?\n                    left join " . DbTables::TBL_CURRENCY . "         as currency      on currency.id = apartments.currency_id\n                where\n                    apartments.url         = ? and\n                    product_rates.active   = 1 and\n                    product_rates.capacity >= ? and\n                    product_rates.min_stay <= ? and\n                    product_rates.max_stay >= ? and\n                    product_rates.release_period_start <= ? and\n                    product_rates.release_period_end >= ? and\n                    rate_av.date           >= ? and\n                    rate_av.date           < ?\n                group by rate_av.rate_id\n                order by\n                  rate_av.price asc,\n                  product_rates.capacity asc\n            ) as result where result.availability > 0";
     if (!Helper::isBackofficeUser()) {
         $sql .= " limit 4";
     }
     $statement = $this->adapter->createStatement($sql, [$city, $apartmentUrl, $guestCount, $bookNightCount, $bookNightCount, $checkNightCount, $checkNightCount, $arrivalDate, $departureDate]);
     $result = $statement->execute();
     return $result;
 }

 /**
  * Testing GetToBeChargedItems method
  */
 public function testGetToBeChargedItems()
 {
     // get any reservation
     $isBookerPrice = false;
     /**
      * @var \DDD\Dao\Booking\Booking $reservationDao
      */
     $reservationDao = $this->getApplicationServiceLocator()->get('dao_booking_booking');
     //        $reservation    = $reservationDao->fetchOne(function(Select $select) {
     //            $select->order('id DESC');
     //        });
     $getReservationWithChargesAndBookedStatusQuery = new Select();
     $getReservationWithChargesAndBookedStatusQuery->join([DbTables::TBL_CHARGE => 'charges'], 'charges.reservation_id = ' . DbTables::TBL_BOOKINGS . '.id', ['charge_id' => 'id'], Select::JOIN_INNER);
     $getReservationWithChargesAndBookedStatusQuery->where->isNotNull('charge_id');
     $getReservationWithChargesAndBookedStatusQuery->where->equalTo(DbTables::TBL_BOOKINGS . '.status', Booking::BOOKING_STATUS_BOOKED);
     $getReservationWithChargesAndBookedStatusQuery->order([DbTables::TBL_BOOKINGS . '.id' => 'DESC']);
     $reservation = $reservationDao->fetchOne($getReservationWithChargesAndBookedStatusQuery);
     $this->assertNotNull($reservation);
     // get textvine service
     /**
      * @var \DDD\Service\Textline $textlineService
      */
     $textlineService = $this->getApplicationServiceLocator()->get('service_textline');
     // check chargeProcess domain
     $reservation = $reservationDao->getDataForToBeCharged($reservation->getId());
     $this->assertInstanceOf('\\DDD\\Domain\\Booking\\ChargeProcess', $reservation);
     // check booking ticket
     $bookingTicketService = $this->getApplicationServiceLocator()->get('service_booking_booking_ticket');
     $this->assertInstanceOf('\\DDD\\Service\\Booking\\BookingTicket', $bookingTicketService);
     // check discount getters
     $this->assertTrue(method_exists($reservation, 'getPartnerId'), 'Class does not have method getPartnerId');
     $this->assertTrue(method_exists($reservation, 'getGuestEmail'), 'Class does not have method getGuestEmail');
     $discountParams = [];
     if ($reservation->getPartnerId()) {
         $discountParams = ['aff_id' => $reservation->getPartnerId(), 'email' => $reservation->getGuestEmail()];
     }
     // check price getters
     $this->assertTrue(method_exists($reservation, 'getBookerPrice'), 'Booking Object does not have method getBookerPrice');
     $this->assertTrue(method_exists($reservation, 'getPrice'), 'Booking Object does not have method getPrice');
     if ($isBookerPrice) {
         $totalPrice = $reservation->getBookerPrice();
         $price = $reservation->getBookerPrice();
     } else {
         $totalPrice = $reservation->getPrice();
         $price = $reservation->getPrice();
     }
     $nightCount = Helper::getDaysFromTwoDate($reservation->getDateTo(), $reservation->getDateFrom());
     $currencySymbol = $reservation->getCurrencySymbol();
     // check night count
     $this->assertLessThan($nightCount, 0);
     // Night Charges
     $chargesList = [['label' => Helper::evaluateTextline($textlineService->getUniversalTextline(1580), ['{{NIGHT_COUNT}}' => $nightCount]), 'price_view' => $currencySymbol . number_format($totalPrice, 2, '.', ' '), 'price' => $totalPrice, 'percent' => 0, 'type' => 'night', 'class' => '', 'description' => '', 'tax_included' => '']];
     /********************************************************************************************************/
     /********************************* Check discount charges ***********************************************/
     /********************************************************************************************************/
     $discountValidator = $bookingTicketService->validateAndCheckDiscountData($discountParams, false);
     $discounted = false;
     if (isset($discountValidator['discount_value']) && $discountValidator['valid'] && isset($discountValidator['discount_value']) && ceil($discountValidator['discount_value'])) {
         $discountValue = $totalPrice * $discountValidator['discount_value'] / 100;
         $price = $totalPrice - $discountValue;
         $discounted = true;
         $totalPrice = $totalPrice - $discountValue;
         array_push($chargesList, ['label' => (isset($discountValidator['partner_name']) ? $discountValidator['partner_name'] : '') . ' ' . $textlineService->getUniversalTextline(1503), 'price_view' => '- ' . $currencySymbol . number_format($discountValue, 2, '.', ' '), 'price' => $discountValue, 'percent' => 0, 'type' => 'discount', 'class' => 'text-danger', 'description' => '', 'tax_included' => '']);
     }
     /********************************************************************************************************/
     /************************************** Check Tax Charges ***********************************************/
     /********************************************************************************************************/
     $currencyService = $this->getApplicationServiceLocator()->get('service_currency_currency');
     $this->assertInstanceOf('\\DDD\\Service\\Currency\\Currency', $currencyService);
     $currencyRate = 1;
     $this->assertTrue(method_exists($reservation, 'getGuestCurrency'), 'Booking Object does not have method getGuestCurrency');
     $this->assertTrue(method_exists($reservation, 'getApartmentCurrency'), 'Booking Object does not have method getApartmentCurrency');
     $this->assertTrue(method_exists($currencyService, 'getCurrencyConversionRate'), 'Booking Object does not have method getCurrencyConversionRate');
     if ($reservation->getGuestCurrency() != $reservation->getApartmentCurrency() && $isBookerPrice) {
         $currencyRate = $currencyService->getCurrencyConversionRate($reservation->getGuestCurrency(), $reservation->getApartmentCurrency());
     }
     $this->assertTrue(method_exists($reservation, 'getCityTotType'), 'Booking Object does not have method getCityTotType');
     $this->assertTrue(method_exists($reservation, 'getCityTot'), 'Booking Object does not have method getCityTot');
     $this->assertTrue(method_exists($reservation, 'getTotIncluded'), 'Booking Object does not have method getTotIncluded');
     if ($reservation->getCityTotType() > 0 && $reservation->getCityTot() > 0) {
         $taxDiscounted = false;
         $totDuration = $reservation->getTotMaxDuration() ? min($reservation->getTotMaxDuration(), $nightCount) : $nightCount;
         $totValue = $reservation->getCityTot() + $reservation->getTotAdditional();
         if ($reservation->getCityTotType() == Taxes::TAXES_TYPE_PERCENT) {
             $cityTot = $price / 100 * $totValue * $totDuration / $nightCount;
             $taxValue = $totValue . ' %';
             if ($discounted) {
                 $taxDiscounted = true;
             }
             $percent = $totValue;
         } else {
             $cityTot = $totDuration * $totValue * $currencyRate;
             $taxValue = $currencySymbol . ' ' . number_format($totValue * $currencyRate, 2, '.', ' ') . ' ' . $textlineService->getUniversalTextline(1473);
             $percent = 0;
         }
         array_push($chargesList, ['label' => $textlineService->getUniversalTextline(1259) . ' (' . $taxValue . ($reservation->getTotIncluded() == 1 ? ', ' . $textlineService->getUniversalTextline(1472) : '') . ') ' . ($taxDiscounted ? $textlineService->getUniversalTextline(1633) : ''), 'price_view' => $currencySymbol . number_format($cityTot, 2, '.', ' '), 'price' => $cityTot, 'percent' => $percent, 'duration' => $totDuration, 'type' => 'tax', 'class' => 'text-primary', 'description' => $textlineService->getUniversalTextline(1429), 'tax_included' => $reservation->getTotIncluded() == 1 ?: '']);
         if ($reservation->getTotIncluded() != 1) {
//.........这里部分代码省略.........