Система редактирования тарифов

[Oleg Moiseenko]

Надо создавать систему редактирования тарифов и вообще все скрипты както увязывать с базой данных.

3) we need to be able to modify the tariffs (Artem tells me this is done, you just need some info from us, which I´m sending today).

[Artem Nasyrov]

Гватемальцы прислали свои пожеланию по модулю тарификации. "The info for the tariffs:

• The local currency for Guatemala is the quetzal (GTQ, Q). But the system should let me select a country, since we plan to install this equipment in the Central American region. And then the different currencies should get selected.

• The tariffs should be: 1. A regular one (based on an hourly basis, if the user stayed 2.5 hours, the system should charge 3.0 hours, and so on). 2. A second tariff that applies for weekends (Saturday and Sunday). 3. A third one that applies on special hour intervals. For example (6:00 pm to 12:00 am, only tariff). Single tariff applies. If the user entered 5:00 pm, for example, tariff 1 should apply from 5:00 pm to 6:00 pm and if he exits at 10:00 pm, tariff 3 should apply from 6:00 pm to 10:00 pm.
4. An extraordinary tariff if the user leaves after 12:00 am, for example enters 5:00 pm of day 1 and exits 10:00 am of day 2. An extraordinary tariff should apply.

• Those are the main tariffs… they should be configurable in the system. A maintenance module in the server so we can configure each tariff (hours, intervals, and tariffs) according to every client and country (currency).

• For discounts, it should be easier if the cashier manually enters the discount on the pay station and we should have a reporting module which indicates the discounts applied and by which cashier. If there is a limit, then it should be 50% discount and 100% discount, again, selected by the cashier (also a maintenance module should be available on the server so we can configure every discount according to client and country). " Файл прикрепил...

[Oleg Moiseenko]

Так. Напишу еще тут.

Есть 2 тарифа:

1. с 11 до 17 стоянка стоит 1$ в час
2. с 17 до 20 стоянка стоит 2$ в час

машина заехала в 16-55 и выезжает в 17-06, простояв 11 минут

по этим тарифам получается что с него надо снять 3$. Это так и должно быть?

[Artem Nasyrov]

Вопрос задал. Ждём ответ.

[Artem Nasyrov]

Как рекомендация, Гватемальцы пишут, что модуль "Редактор чека" и "Редактор тарифов" не обязательно должны быть раздельными. Пишут, что им проще было бы, если бы это были 2 разных текстовых файла, лежащих где-то в папке с программой.

"Regarding both invoice and tariff modules… they don´t have to necessarily be a separate module, having data bases and all… the info could be stored in a simple text file in a system´s folder and there we could change the parameters, tariffs, hours applied, etc. We would just need to have parameters for the tariffs. For the invoice, we could have a format in a text file, and the things we need to personalize would be done there. The only thing we do need to be in a DB is the requirements for the resolutions and documents log… that is because the government could need some reports from time to time… or even the client could need them too. "

[Oleg Moiseenko]

Они все уже в базе данных.

[Artem Nasyrov]

Вот ответ от Гватемальцев "The best way to go regarding tariffs by cumulative hours is: · Normal tariff for each hour spent inside the tariff´s hour range. · If there is a change of tariffs, the hour with the change of hour range, gets the new range´s tariff.

For example in this case, since the user didn´t stay a whole hour in hour range No.1, tariff of hour range No.2 should apply for the time he spent. In this case $2.00. If there was a difference between time ranges, then you apply the above.

For example. User entered parking lot at 3:55 and exits at 17:06, staying inside 1:11 minutes… first hour tariff 1, 11 minutes count as 1 hour in tariff No.2"

[Oleg Moiseenko]

всеравно непонятно.... Модифицируем пример

Есть 2 тарифа:

1. с 11 до 17 стоянка стоит 1$ в час
2. с 17 до 20 стоянка стоит 2$ в час

машина заехала в 15-30 и выезжает в 18-30 как считается?

[Oleg Moiseenko]

Requirements Invoice - помоему это отдельная тема под названием фискализация. issue 11

[Дмитрий Лысенко]

Гватемальцам был задан вопрос по тарификации следующей ситуации:

1 tariff zone is $ 2 per hour - end zone at 17-00

2 tariff zone is $ 1 per hour - starting zone at 17:00

Car drives into 15-45 and leave for 18-30

Which of these varian correct:

                                            1) (60 min +15 min) * 2 $ interval = 2 * 2 = 4 $

                                                 (60 min + 30 min) * 1 $ interval = 2 * 1 =  2 $

                                                 Total 6 $

                                            2)  (60 min + 60 min) * 2 $ interval = 2 * 2 = 4 $

                                                  (45 min) * 1 $ interval = 1 * 1  = 1 $

                                                 Total 5 $

Ответ Гватемальцев: Option #2 should be the answer, we have to take the tariff in which the time span started, even though it ends in another tariff

[Дмитрий Лысенко]

и еще от них уже вопрос, наверно повторный

One question, are you developing the billing module as a form were we can make changes, maintenances, etc? with a DB? Or just using a plain text file in the configuration folder of the pay stations were we can make the changes? I think option #2 is easier for you and would take less time. We can work this way with the invoice module.

Насколько я понял ответ: "...Они все уже в базе данных...,"

[Oleg Moiseenko]

да, уже все там

[Oleg Moiseenko]

Тарифы существующей парковки в Гватемале

[Ihor Bielykh]

Все сделано, кроме мастера тарифов, как определятся с базовыми, добавлю кнопку.