Pilot Financial Report V1.0

Parkho · September 16, 2012, 3:40pm

Here is another small add-on for those who want to show pilot’s financial reports. It’s based on pilot id, so the results are for each of you pilots.Cheers

Install

Download the zip from repo.
Unzip and upload in the order of folders.
Access financial report for a pilot by
<?php echo url('/pfinance') ;?>

-----------------OR----------------------

Access financial report for all pilots by

<?php echo url('/pfinance/pilots') ;?>

Enjoy.

Download:PilotFinancialReport_V1.0

Screenshot for a pilot report:

Screenshot for all pilots report:

Change Log:

PilotFinance.class.php & pilots_finance.tpl have been added. Those of you who have downloaded this before should re-download.

mattia · September 16, 2012, 4:21pm

hi parkho

i have this error:

Warning** : mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in **** /var/www/virtual/italianivolanti.it/htdocs/iv/core/templates/pilot_finance.tpl **** on line **** 12**

â‚¬ 0.00

Your total flight fuel expenses in Italiani Volanti is:
Warning** : mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in **** /var/www/virtual/italianivolanti.it/htdocs/iv/core/templates/pilot_finance.tpl **** on line **** 18**
â‚¬ 0.00
Your total in flight expenses in Italiani Volanti is:
Warning** : mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in **** /var/www/virtual/italianivolanti.it/htdocs/iv/core/templates/pilot_finance.tpl **** on line **** 24**
â‚¬ 0.00
Your total flight revenue in Italiani Volanti is:
Warning** : mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in **** /var/www/virtual/italianivolanti.it/htdocs/iv/core/templates/pilot_finance.tpl **** on line **** 31**

servetas · September 16, 2012, 4:37pm

Screenshot?

mattia · September 16, 2012, 5:00pm

attach photos

servetas · September 16, 2012, 5:02pm

I was talking about the general screen shot of the module in order to preview it…

Fernando · September 16, 2012, 5:10pm

Great Work, Parkho

I made some adjustments

Fernando · September 16, 2012, 5:19pm

Mattia

you touched on some of the files line by disponibilziados Parkho?

Parkho · September 16, 2012, 5:32pm

hi parkho

i have this error:

Warning** : mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in **** /var/www/virtual/italianivolanti.it/htdocs/iv/core/templates/pilot_finance.tpl **** on line **** 12**

â‚¬ 0.00

Your total flight fuel expenses in Italiani Volanti is:
Warning** : mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in **** /var/www/virtual/italianivolanti.it/htdocs/iv/core/templates/pilot_finance.tpl **** on line **** 18**
â‚¬ 0.00

Your total in flight expenses in Italiani Volanti is:
Warning** : mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in **** /var/www/virtual/italianivolanti.it/htdocs/iv/core/templates/pilot_finance.tpl **** on line **** 24**
â‚¬ 0.00

Your total flight revenue in Italiani Volanti is:
Warning** : mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in **** /var/www/virtual/italianivolanti.it/htdocs/iv/core/templates/pilot_finance.tpl **** on line **** 31**

Are you using any shared server for your site? Cause I think that’s where the problem lies not sure though. It’s working just fine on this side.

Fernando · September 16, 2012, 5:33pm

Parkho,

seems to be a permission problem, what do you think?

Parkho · September 16, 2012, 5:38pm

I was talking about the general screen shot of the module in order to preview it…

mattia · September 16, 2012, 6:39pm

i copy the file in my site but dont work

Parkho · September 16, 2012, 8:17pm

i copy the file in my site but dont work

Strange! did you copy the .tpl in templates or your skin folder?

mattia · September 16, 2012, 11:12pm

yes,

pilot_finance.tpl in templates folder and Pfinance folder in modules folder

SparrowBD · September 17, 2012, 12:21am

im getting that mysql error as well. one thing you should be able to do maybe in a future update is allow admins to view all the pilots profitability.

Fly_Star_Alliance · September 17, 2012, 1:45am

Same here, MySql error

Parkho · September 17, 2012, 5:34am

I think it’s fixed

Fly_Star_Alliance · September 17, 2012, 8:40am

Better now, thanks Parkho, although I still have a couple of little problems to solve…

Parkho · September 17, 2012, 12:08pm

I edited the .tpl as well, have you replaced that too?

CPC900 · September 17, 2012, 4:23pm

Don’t forget, if you named your database to have something OTHER than “phpvms_pireps” you will get the mysql errors. Change those lines in your “PilotFinance.class.php” to indicate your database ie “nameofdata_pireps”; whatever yours is.

Parkho · September 17, 2012, 4:24pm

Good point. Thanks