Jump to content

Leave Of Absence v0.9


Sava

Recommended Posts

Leave of Absence v1.0 (Updated April 13th 2013)

Note: Update v0.9 - > v1.0 (view changelog: https://github.com/savamarkovic/phpvms_loa#changelog )

about:

phpVMS addon for pilots to submit a LoA request that is stored in a database and an option for staff to view, delete and edit all the LoA requests through the admin panel.

The addon checks if the requested leave lenght is longer than the specified number of days. It uses the date of submission as a start date.

When the LoA requests are submitted, both the users and the admin will get an email.

Developed by:

Sava Markovic

http://www.airserbiavirtual.com

Developed on:

phpVMS v2.1.934 stable

php 5.3.1

mysql 5.0.5

apache 2.2.14

License:

Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License

Installation:

All installation instructions and update info can be found here:

https://github.com/savamarkovic/phpvms_loa#loa-module-v10

Screenshots

http://i.imgur.com/LYeU0.jpg

http://i.imgur.com/V55qI.jpg

http://i.imgur.com/nq92W.jpg

http://i.imgur.com/yX9vy.jpg

Download:

The addon can be found and downloaded here: https://github.com/s...ovic/phpvms_loa

Enjoy!

  • Like 5
Link to comment
Share on other sites

Just some information. I didn't get any time to work with the addon on fixing the date format issues lately due to other things but I will try and do it as soon as I can.

I encourage all of you to try the addon and leave feedback! Also, all suggestions for further addons can be left here: http://forum.phpvms.net/topic/7649-any-addon-ideas/

Link to comment
Share on other sites

Are you sure that there isn't a request? The addon comes with one request already in there to show the functionality.Check the actual table in phpmyadmin. I have tried out the addon on my test site and it works perfectly.

Also, check the Hub Transfer thread, I have updated it.

Link to comment
Share on other sites

Edit:

Go to core/common/LoAData.class.php

Change the first method so it is like this:

public function CheckPilotID ($pilotid)
{
$query = "SELECT * FROM loa WHERE pilotid ='$pilotid'";
$sql = mysql_query($query);
$count = mysql_num_rows($sql); //this is added
return $count; //$sql changed to $count
}

That should fix the issue.

Link to comment
Share on other sites

Hi there, I have this error after installing this mod:

Notice: The template file "/home/jdsarcco/public_html/uvsaaf//core/templates/loa/loa_index.tpl" doesn't exist in/home/jdsarcco/public_html/uvsaaf/core/classes/TemplateSet.class.php on line 248

well, the problem is the double forward slash in the URL before the first CORE, but I dont know where to fix it?

Cheers

Link to comment
Share on other sites

That is not the problem. You haven't installed the templates correctly. Please make sure that you have the loa_index.tpl file inside core/templates/loa. :)

Hi, I have double checked it, and all are in the locations as instructed. I also have a similar error with the admin page

Link to comment
Share on other sites

As I said, that shouldn't matter and that type of error (line 248) is associated with .tpl files not being installed correctly. (Read here: http://forum.phpvms.net/topic/3513-about-simpilot/)

I can't help much without direct access to the files etc. but it is an issue on your side, as it is working well on many other VAs.

Also, make sure that you have downloaded the latest version from the GitHub.

Link to comment
Share on other sites

Is there a way to automatically mark the pilot as on Leave when he/she submit a LoA form?

- Nope, the way I have coded is that all the requests go to the admin panel for approval.

then exclude the pilots marked as on Leave from the automatic retire function?

-Nope, that would require changing of core files etc.

I don't have much time these days to do any coding, but if I have time in the future, I will look into this.

Link to comment
Share on other sites

  • 2 weeks later...

Hi

i become the following failure when i request a LoA

Warning: mysql_query() [function.mysql-query]: Access denied for user 'www-data'@'localhost' (using password: NO) in /www/htdocs/w00dac26/lausitzair/core/common/LoAData.class.php on line 23

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in/www/htdocs/w00dac26/lausitzair/core/common/LoAData.class.php on line 23

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in/www/htdocs/w00dac26/lausitzair/core/common/LoAData.class.php on line 24

but its working and stay in the adminpanel

And then i become this failure when i will delete the LoA

Warning: mysql_query() [function.mysql-query]: Access denied for user 'www-data'@'localhost' (using password: NO) in /www/htdocs/w00dac26/lausitzair/core/common/LoAData.class.php on line 61

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /www/htdocs/w00dac26/lausitzair/core/common/LoAData.class.php on line 61

Warning: mysql_affected_rows() [function.mysql-affected-rows]: A link to the server could not be established in /www/htdocs/w00dac26/lausitzair/core/common/LoAData.class.php on line 62

Warning: mysql_affected_rows() [function.mysql-affected-rows]: A link to the server could not be established in /www/htdocs/w00dac26/lausitzair/admin/modules/LoA/LoA.php on line 63

can anybody help me?

Thx

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...