Author Topic: financial module  (Read 5596 times)

banzai13fr

  • Newbie
  • *
  • Posts: 23
    • View Profile
    • Paca Air Virtuel
financial module
« on: October 18, 2015, 01:33:19 AM »
I set ACV for the financial module with the same values ​​as the manual in PDF but I do not have the same results on the financial report, which must I do to it works.
Bertrand
« Last Edit: October 18, 2015, 01:44:11 AM by banzai13fr »

VAM

  • Administrator
  • Hero Member
  • *****
  • Posts: 1328
    • View Profile
    • virtual Airlines Manager
Re: financial module
« Reply #1 on: October 20, 2015, 11:33:16 PM »
I set ACV for the financial module with the same values ​​as the manual in PDF but I do not have the same results on the financial report, which must I do to it works.
Bertrand

sorry for late reply

The financial parameters are applied to those flights that are validated. I mean, the calculations are fired when you are in the flights validation page.
So when you validates new flights reported the page is refreshed and then a php is called to calculate the finances.
The calculations are done only for those flights that are accepted, those flights with status rejected will not count.
Also very important this is only affecting the flights that are reported after the activation of the financial module.

Could you check if you are in such scenario.

also can you send me the result of this query?

select * from vampireps where validated=1 and flightid not in (select distinct(report_id) from va_finances where report_id is not NULL)
VAM Creator and programmer.

banzai13fr

  • Newbie
  • *
  • Posts: 23
    • View Profile
    • Paca Air Virtuel
Re: financial module
« Reply #2 on: October 21, 2015, 12:59:34 AM »
All flights are validated.
In vampireps validated = 1 and flightid= 2015101414582784CPA141 eg.
In va_finances REPORT_ID = 2015101414582784CPA141.

Édit  : I just made a flight this afternoon and I have validated it but no PHP file opens when I click on the submit button just the message that says the flight is validated.
« Last Edit: October 21, 2015, 06:51:39 PM by banzai13fr »

Skyzo

  • Newbie
  • *
  • Posts: 6
    • View Profile
Re: financial module
« Reply #3 on: October 23, 2015, 12:05:19 AM »
Hello i have a similar problem VAM 2.5.
A validate flight count only salary of pilot (890€) but not fuel cost, wifi connection etc...

RAPPORT FINANCIER DE VOL
Regular Flight :LFLL - LOWI   890.00
TOTAL   890.00

In the global_financial_report page, nothing appear under INCOME REGULAR ROUTES

PS : je suis français donc on peut peut-être s'entraider si tu veux.   

VAM

  • Administrator
  • Hero Member
  • *****
  • Posts: 1328
    • View Profile
    • virtual Airlines Manager
Re: financial module
« Reply #4 on: October 23, 2015, 07:33:22 AM »
Hi

I think that the issue comes from how your servers (hosting) manage the date format, this weekend I will try to fix this issue, becasue for some VA it is working fine and not for other, the trick is that the finance module has a data when it becomes active,and the fligths reports might have other date format, so this is the issue. Do not worry , this week end I will fix it  ;)
VAM Creator and programmer.

Skyzo

  • Newbie
  • *
  • Posts: 6
    • View Profile
Re: financial module
« Reply #5 on: October 23, 2015, 02:41:17 PM »
Hi,
ok understand, thank you very much for all.
I just a little question about flights, how do you delete a validate flights ?

VAM

  • Administrator
  • Hero Member
  • *****
  • Posts: 1328
    • View Profile
    • virtual Airlines Manager
Re: financial module
« Reply #6 on: October 24, 2015, 11:04:22 AM »
Hi,
ok understand, thank you very much for all.
I just a little question about flights, how do you delete a validate flights ?

if you want to delete a flight reported with SIM ACARS these are the steps:
1.- Go to the page for the flight, for example
20151018134514675AEA5512[/color]]http://virtualairlinesmanager.net/demo25/vam/index.php?page=flight_details&flight_id=20151018134514675AEA5512
and select the id of the flight, in the example what it is in red

2.- from phpmyadmin run the following sql sentences (put the id of  the flight you want to delete)

DELETE FROM vamevents WHERE flight_id = '20151018134514675AEA5512';
DELETE FROM vam_track WHERE flight_id = '20151018134514675AEA5512';
DELETE FROM vampireps WHERE flightid = '20151018134514675AEA5512';

VAM Creator and programmer.

VAM

  • Administrator
  • Hero Member
  • *****
  • Posts: 1328
    • View Profile
    • virtual Airlines Manager
Re: financial module
« Reply #7 on: October 24, 2015, 12:30:41 PM »
Hi,

I think I found the root of the issue, and it is due date format. I have done a modification for your test. Please download this file and put it in vam folder http://virtualairlinesmanager.net/download/vam_installer/VAM_2.5/VAM25_FIXES/calculate_flight_finances.zip
Then go to you validationof flight page, just go, no need to validate any flight. When you are in that page the calculation should be done.

Please let me know if this is solving the issue, I hope yes.

Thanks
VAM Creator and programmer.

banzai13fr

  • Newbie
  • *
  • Posts: 23
    • View Profile
    • Paca Air Virtuel
Re: financial module
« Reply #8 on: October 24, 2015, 04:05:12 PM »
I just tested on my work server sHost.ca but for me no change, the same time I still do not see the price of the aircraft in the financial report. I will try on my development server at Hostinger to see, I also had this problem but I had appeared the price of the financial report. Otherwise I would do a new clean install on how to safeguard against sHost by my given proper base without losing the way (account users, road, fleet, etc ...)

VAM

  • Administrator
  • Hero Member
  • *****
  • Posts: 1328
    • View Profile
    • virtual Airlines Manager
Re: financial module
« Reply #9 on: October 24, 2015, 04:26:26 PM »
I just tested on my work server sHost.ca but for me no change, the same time I still do not see the price of the aircraft in the financial report. I will try on my development server at Hostinger to see, I also had this problem but I had appeared the price of the financial report. Otherwise I would do a new clean install on how to safeguard against sHost by my given proper base without losing the way (account users, road, fleet, etc ...)

I will test on my test environment in shost.ca, by the way the best free hosting I've ever seen.
In my pay hosting it is working fine
VAM Creator and programmer.

Skyzo

  • Newbie
  • *
  • Posts: 6
    • View Profile
Re: financial module
« Reply #10 on: October 24, 2015, 06:47:05 PM »
Hello, thanks you for this fix and for you response to delete a validate flight.
I have test the fix (ovh pro : pay hosting).
I have no change, but this fix is working on previously validate regular flights ? Or i must do one new flight to work ?
On my VA, i have :
3 planes.
2 flights : 1 regular, 1 charter.

Financial report (after fix):


for the regular flight (after fix) :
RAPPORT FINANCIER DE VOL
Regular Flight :LFLL - LOWI   890.00
TOTAL   890.00

for charter flight (after fix) :
RAPPORT FINANCIER DE VOL
Extra charge(5). Number of PAX: 139   695.00
Publicity   1,000.00
Wifi connection(750). Flight duration: 0.9   -675.00
Fuel(0.38). Fuel used: 3016.43   -1,146.24
Engine Wire(700). Flight duration: 0.9   -630.00
Meal on board(10). Number of PAX: 139   -1,390.00
Ground Handling   -500.00
Airport Taxes   -200.00
TOTAL   -2,846.24

Other way
select * from vampireps where validated=1 and flightid not in (select distinct(report_id) from va_finances where report_id is not NULL)
MySQL returned an empty result set (i.e. zero rows). (Query took 0.0010 seconds.)

Other way
See Attachement vapireps.sql and va_finances.sql

Thanks you
« Last Edit: October 25, 2015, 09:17:55 PM by Skyzo »

Jaker

  • Newbie
  • *
  • Posts: 29
    • View Profile
    • AirCAN Virtual Airlines
Re: financial module
« Reply #11 on: October 25, 2015, 11:09:40 AM »
Could this fix be applied to all VAM systems, or is it exclusive for Skyzo?

VAM

  • Administrator
  • Hero Member
  • *****
  • Posts: 1328
    • View Profile
    • virtual Airlines Manager
Re: financial module
« Reply #12 on: October 25, 2015, 11:16:30 PM »
Could this fix be applied to all VAM systems, or is it exclusive for Skyzo?

the fix http://virtualairlinesmanager.net/download/vam_installer/VAM_2.5/VAM25_FIXES/calculate_flight_finances.zip is for all VAM , so you can apply it , please let me know the result.
VAM Creator and programmer.

banzai13fr

  • Newbie
  • *
  • Posts: 23
    • View Profile
    • Paca Air Virtuel
Re: financial module
« Reply #13 on: October 27, 2015, 12:22:21 AM »
I still can not activate the entire financial module or on the operational http://paca-air-virtuel.fr/ server (shost.ca) or the development server http: // paca air-virtual .esy.es (hostinger) which is nevertheless a clean install with fix. I understand nothing more.

VAM

  • Administrator
  • Hero Member
  • *****
  • Posts: 1328
    • View Profile
    • virtual Airlines Manager
Re: financial module
« Reply #14 on: October 27, 2015, 07:57:48 AM »
I still can not activate the entire financial module or on the operational http://paca-air-virtuel.fr/ server (shost.ca) or the development server http: // paca air-virtual .esy.es (hostinger) which is nevertheless a clean install with fix. I understand nothing more.

Today I will porvide you a php to debug why it is not working 100% the financial module, I will send you a private message when it is done, expect it by late evening.
VAM Creator and programmer.