41:            } elseif ($code === '23503') {
42:                return Nette\Database\ForeignKeyConstraintViolationException::from($e);
43:    
44:            } elseif ($code === '23505') {
45:                return Nette\Database\UniqueConstraintViolationException::from($e);
46:    
47:            } elseif ($code === '08006') {
48:                return Nette\Database\ConnectionException::from($e);
49:    
50:            } else {
51:                return Nette\Database\DriverException::from($e);
52:            }
53:        }
54:    
55:    

71:                    $this->pdoStatement = $connection->getPdo()->prepare($queryString);
72:                    foreach ($params as $key => $value) {
73:                        $type = gettype($value);
74:                        $this->pdoStatement->bindValue(is_int($key) ? $key + 1 : $key, $value, $types[$type] ?? PDO::PARAM_STR);
75:                    }
76:    
77:                    $this->pdoStatement->setFetchMode(PDO::FETCH_ASSOC);
78:                    @$this->pdoStatement->execute(); // @ PHP generates warning when ATTR_ERRMODE = ERRMODE_EXCEPTION bug #73878
79:                }
80:            } catch (\PDOException $e) {
81:                $e = $connection->getDriver()->convertException($e);
82:                $e->queryString = $queryString;
83:                $e->params = $params;
84:                throw $e;
85:            }

223:    
224:    
225:        /**
226:         * Generates and executes SQL query.
227:         * @param  literal-string  $sql
228:         */
229:        public function query(string $sql, ...$params): ResultSet
230:        {
231:            [$this->sql, $params] = $this->preprocess($sql, ...$params);
232:            try {
233:                $result = new ResultSet($this, $this->sql, $params, $this->rowNormalizer);
234:            } catch (PDOException $e) {
235:                Arrays::invoke($this->onQuery, $this, $e);
236:                throw $e;
237:            }

'SELECT * FROM "rent_discount" WHERE ("rent_discount"."reservation_id" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))'

80:            return $this->connection->getInsertId($sequence);
81:        }
82:    
83:    
84:        /**
85:         * Generates and executes SQL query.
86:         * @param  literal-string  $sql
87:         */
88:        public function query(string $sql, ...$params): ResultSet
89:        {
90:            return $this->connection->query($sql, ...$params);
91:        }
92:    
93:    
94:        /** @deprecated  use query() */

'SELECT * FROM "rent_discount" WHERE ("rent_discount"."reservation_id" IN (?))'

642:    
643:    
644:        protected function createGroupedSelectionInstance(string $table, string $column): GroupedSelection
645:        {
646:            return new GroupedSelection($this->explorer, $this->conventions, $table, $column, $this, $this->cache ? $this->cache->getStorage() : null);
647:        }
648:    
649:    
650:        protected function query(string $query): Nette\Database\ResultSet
651:        {
652:            return $this->explorer->query($query, ...$this->sqlBuilder->getParameters());
653:        }
654:    
655:    
656:        protected function emptyResultSet(bool $clearCache = true, bool $deleteRererencedCache = true): void

'SELECT * FROM "rent_discount" WHERE ("rent_discount"."reservation_id" IN (?))'

577:                throw new Nette\InvalidStateException('Table with no primary key requires an explicit select clause.');
578:            }
579:    
580:            try {
581:                $result = $this->query($this->getSql());
582:    
583:            } catch (Nette\Database\DriverException $exception) {
584:                if (!$this->sqlBuilder->getSelect() && $this->previousAccessedColumns) {
585:                    $this->previousAccessedColumns = false;
586:                    $this->accessedColumns = [];
587:                    $result = $this->query($this->getSql());
588:                } else {
589:                    throw $exception;
590:                }
591:            }

'SELECT * FROM "rent_discount" WHERE ("rent_discount"."reservation_id" IN (?))'

156:            if (!isset($this->refCacheCurrent['data'])) {
157:                // we have not fetched any data yet => init accessedColumns by cached accessedColumns
158:                $this->accessedColumns = $accessedColumns;
159:    
160:                $limit = $this->sqlBuilder->getLimit();
161:                $rows = count($this->refTable->rows);
162:                if ($limit && $rows > 1) {
163:                    $this->sqlBuilder->setLimit(null, null);
164:                }
165:    
166:                parent::execute();
167:                $this->sqlBuilder->setLimit($limit, null);
168:                $data = [];
169:                $offset = [];
170:                $this->accessColumn($this->column);

1042:            $clone->setActive($active);
1043:            return $clone;
1044:        }
1045:    
1046:    
1047:        /********************* interface Iterator ****************d*g**/
1048:    
1049:    
1050:        public function rewind(): void
1051:        {
1052:            $this->execute();
1053:            $this->keys = array_keys($this->data);
1054:            reset($this->keys);
1055:        }
1056:    

253:        }
254:    
255:    
256:        /**
257:         * Fetches all rows.
258:         * @version FLATIO_CUSTOM
259:         * @return array<T>
260:         */
261:        public function fetchAll(): array
262:        {
263:            return iterator_to_array($this);
264:        }
265:    
266:    
267:        /**

242:        }
243:    
244:    
245:        /**
246:         * Fetches all rows as associative array.
247:         * @param  string|int  $key  column name used for an array key or null for numeric index
248:         * @param  string|int  $value  column name used for an array value or null for the whole row
249:         */
250:        public function fetchPairs($key = null, $value = null): array
251:        {
252:            return Nette\Database\Helpers::toPairs($this->fetchAll(), $key, $value);
253:        }
254:    
255:    
256:        /**

412:            if (!isset($this->rowData['discounts'])) {
413:                $this->rowData['discounts'] = $this->getDiscounts()->fetchPairs('type', 'discount');
414:            }
415:    
416:            return $this->rowData['discounts'];
417:        }
418:    
419:    
420:        public function getDiscount(string $type): float
421:        {
422:            return $this->getDiscountValues()[$type] ?? 0;
423:        }
424:    
425:    
426:        public function getDiscountRowByType(string $type): RentDiscountRow|null

1215:            $renterLivingRow = $this->contract->getRenterLivingRow();
1216:    
1217:            return $renterLivingRow && (
1218:                    $this->from->format('Y-m-d') !== $renterLivingRow->from->format('Y-m-d') ||
1219:                    $this->to->format('Y-m-d') !== $renterLivingRow->to->format('Y-m-d'));
1220:        }
1221:    
1222:    
1223:        public function hasMarketingDiscount(): bool
1224:        {
1225:            return (bool) $this->getDiscount(RentDiscountRow::DISCOUNT_TYPE_MARKETING);
1226:        }
1227:    
1228:    
1229:        public function hasLandlordDiscount(): bool

'marketing'

591:    
592:    
593:        public function getTotalProfit(ReservationRow $reservationRow, string|null $currency = null): array
594:        {
595:            $rentsSum = $reservationRow->total_rent;
596:            $tenantTax = TaxHelper::getReservationTenantTax($reservationRow);
597:    
598:            $totalProfit = [];
599:    
600:            //- marketing discount on all rents
601:            if ($reservationRow->hasMarketingDiscount()) {
602:                $discountPercent = round(($reservationRow->price_original - $reservationRow->price) / $reservationRow->price_original, 4);
603:                $rentsSumBeforeDiscount = round($rentsSum / (1 - $discountPercent));
604:                $value = $rentsSumBeforeDiscount - $rentsSum;
605:                $totalProfit['rentDiscount'] = [

35:            if ($row->discount_type) {
36:                $deposit .= '&nbsp;<span class="label label-sm ' . ($row->discount_type === 'marketing' ? 'label-warning' : 'label-default') . ' has-tooltip" title="Original rent ' . $this->latteHelpers->numberClean($row->price_original) . strtoupper($row->team->currency_symbol) . ' (discount type: ' . ($row->discount_type === 'marketing' ? 'marketing' : 'landlord') . ')">%</span>';
37:            }
38:    
39:            return '<span class="has-tooltip" title="Total rents amount: ' . $this->latteHelpers->numberClean($row->total_rent) . $row->team->currency_symbol . '">' . $this->latteHelpers->numberClean($row->price) . '</span>&nbsp;' . $row->team->currency_symbol . $deposit;
40:        }
41:    
42:    
43:        public function renderServiceFee(ReservationRow $row): string
44:        {
45:            $totalProfit = $this->reservationManager->getTotalProfit($row);
46:    
47:            if ($row->company_id) {
48:                $serviceFee = $this->latteHelpers->numberClean($totalProfit['companyFee']['value'], 0, '', '&nbsp;') . '&nbsp;' . Strings::upper($totalProfit['tenantFee']['currency']);
49:                $serviceFeeDiscount = '0&nbsp;' . Strings::upper($totalProfit['companyFee']['currency']);

886:                    if ($statsRow && $statsRow->landlord_fee_gross_total_discount_cost) {
887:                        $landlordFeeOriginal = $this->latteHelpers->currencyByDate($statsRow->landlord_fee_gross_revenue_before_discount, $row->team->currency, Constants::CURRENCY_EUR, $exchangeDate, 0, false, true) . ' ' . Constants::CURRENCY_EUR_SYMBOL;
888:                        $landlordFeeDiscount = $this->latteHelpers->currencyByDate($statsRow->landlord_fee_gross_total_discount_cost, $row->team->currency, Constants::CURRENCY_EUR, $exchangeDate, 0, false, true) . ' ' . Constants::CURRENCY_EUR_SYMBOL;
889:                        $message .= '&nbsp;' . sprintf('<span class="label label-sm label-warning has-tooltip" title="Before discount %s, discount %s">&#37;</span>', $landlordFeeOriginal, $landlordFeeDiscount);
890:                    }
891:    
892:                    return $message;
893:                });
894:    
895:            $dataTable->addCallback('serviceFee', 'Service fee')
896:                ->setDataRender(fn (ReservationRow $row) => $this->reservationRenderer->renderServiceFee($row));
897:    
898:            $dataTable->addCallback('cityName', 'City')
899:                ->setDataRender(fn (ReservationRow $row) => $this->reservationRenderer->renderCity($row));
900:    

31:            return $this;
32:        }
33:    
34:    
35:        protected function getColumn(ActiveRow $row): mixed
36:        {
37:            if ($this->dataRender === null) {
38:                throw new InvalidStateException('Datarender is not set');
39:            }
40:    
41:            return call_user_func_array($this->dataRender, [$row]);
42:        }
43:    
44:    }
45:    

107:                    $column = Html::el('a', $attr)->setText($column);
108:                }
109:            }
110:    
111:            return (string) $column;
112:        }
113:    
114:    
115:        public function render(ActiveRow $row): string
116:        {
117:            $column = $this->getColumn($row);
118:            if (empty($column) && $this->nullValue) {
119:                $column = $this->nullValue;
120:            }
121:    

352:        {
353:            $data = [];
354:    
355:            if ($length > 0) {
356:                $this->selection->limit($length, $start);
357:            }
358:    
359:            foreach ($this->selection as $row) {
360:                $cols = [];
361:                foreach ($this->components as $col) {
362:                    $cols[] = mb_convert_encoding($col->render($row), 'UTF-8', 'UTF-8');
363:                }
364:                $data[] = $cols;
365:            }
366:    

65:            $query = $this->parseQuery();
66:    
67:            $response = ['draw' => $query['draw']];
68:            $response['recordsFiltered'] = $response['recordsTotal'] = $this->selection->count('*');
69:    
70:            if ($query['search']) {
71:                $response['recordsFiltered'] = $this->applySearch($query['search']);
72:            }
73:            $this->applySort($query['sort'], $query['asc']);
74:    
75:            $response['data'] = $this->renderData($query['start'], $query['length']);
76:    
77:            $this->presenter->sendResponse(new JsonResponse($response));
78:        }
79:    

0

25

110:            }
111:    
112:            $rm = $rc->getMethod($method);
113:            $this->checkRequirements($rm);
114:            try {
115:                $args = $rc->combineArgs($rm, $params);
116:            } catch (Nette\InvalidArgumentException $e) {
117:                throw new Nette\Application\BadRequestException($e->getMessage());
118:            }
119:    
120:            $rm->invokeArgs($this, $args);
121:            return true;
122:        }
123:    
124:    

array (0)

222:    
223:        /********************* interface SignalReceiver ****************d*g**/
224:    
225:    
226:        /**
227:         * Calls signal handler method.
228:         * @throws BadSignalException if there is not handler method
229:         */
230:        public function signalReceived(string $signal): void
231:        {
232:            if (!$this->tryCall($this->formatSignalMethod($signal), $this->params)) {
233:                $class = static::class;
234:                throw new BadSignalException("There is no handler for signal '$signal' in class $class.");
235:            }
236:        }

'handledataLoad'

array (0)

363:            $component = $this->signalReceiver === ''
364:                ? $this
365:                : $this->getComponent($this->signalReceiver, false);
366:            if ($component === null) {
367:                throw new BadSignalException("The signal receiver component '$this->signalReceiver' is not found.");
368:    
369:            } elseif (!$component instanceof SignalReceiver) {
370:                throw new BadSignalException("The signal receiver component '$this->signalReceiver' is not SignalReceiver implementor.");
371:            }
372:    
373:            $component->signalReceived($this->signal);
374:            $this->signal = null;
375:        }
376:    
377:    

'dataLoad'

237:                if ($this->autoCanonicalize) {
238:                    $this->canonicalize();
239:                }
240:    
241:                if ($this->httpRequest->isMethod('head')) {
242:                    $this->terminate();
243:                }
244:    
245:                // SIGNAL HANDLING
246:                // calls $this->handle<Signal>()
247:                $this->processSignal();
248:    
249:                // RENDERING VIEW
250:                $this->beforeRender();
251:                Arrays::invoke($this->onRender, $this);

153:    
154:            try {
155:                $this->presenter = $this->presenterFactory->createPresenter($request->getPresenterName());
156:            } catch (InvalidPresenterException $e) {
157:                throw count($this->requests) > 1
158:                    ? $e
159:                    : new BadRequestException($e->getMessage(), 0, $e);
160:            }
161:    
162:            Arrays::invoke($this->onPresenter, $this, $this->presenter);
163:            $response = $this->presenter->run(clone $request);
164:    
165:            if ($response instanceof Responses\ForwardResponse) {
166:                $request = $response->getRequest();
167:                goto process;

80:        }
81:    
82:    
83:        /**
84:         * Dispatch a HTTP request to a front controller.
85:         */
86:        public function run(): void
87:        {
88:            try {
89:                Arrays::invoke($this->onStartup, $this);
90:                $this->processRequest($this->createInitialRequest());
91:                Arrays::invoke($this->onShutdown, $this);
92:    
93:            } catch (\Throwable $e) {
94:                Arrays::invoke($this->onError, $this, $e);

18:    $container = $configurator->createContainer();
19:    
20:    if ($container->parameters['consoleMode']) {
21:        $container->parameters['catchExceptions'] = true;
22:        $container->removeService('httpRequest');
23:        $container->addService('httpRequest', new Request(
24:            new UrlScript(Strings::fixEncoding('http://' . $container->parameters['cliHost'] . '/')),
25:        ));
26:    }
27:    
28:    $container->getByType(Application::class)->run();
29: