bbalet / jorani Goto Github PK

Having the possibility to Integrating users from a LDAP would be great instead of creating them into a database when they already have centralized account management.

Something that we would definitely see as a big plus would be importing users from an LDAP server. The LDAP authentication is great, but having to type in most of the personal details of each user is a pain.

I know from reading the google groups posts that LDAP integration is not among the principal goals of this application, that is why I am not arguing in favour of creating on the fly users from an LDAP query, but a mass import of users from a csv file or similar would be awesome. The file would not include password of course, but combining this issue with issue #36 would solve that problem ;-)

Hi!
Thanks for the project and the hard work, very nice. Keep it going on!
Is it possible to make the credit gradual as the month is completed?
For example : +1 day by month at the end of completed month, available for 3 month?
Or another hand : 25 days a year, given available gradually, each month (like 2,09) and not 25 days at once ? I didn't find this in forum… Thanks…

Hi.

Currently I am trying to set my jorani with my environment using LDAP. However, when entering my user id in jorani and my correct password and incorrect password, jorani will send an error saying they don't match. However, when I only enter my user ID, even the ones aren't inside my AD, without any password, I still can log in to jorani.

Can you help me with this issue?

For some reason an employee can need his leaves to be moved.

It would be useful if the employee could cancel his leaves when he still can to ask for another period.

The PHP ldap_bind function may return success if you specify a blank password. You probably need to check that the password is not empty at some point in the ldap query.

There is a possible XSS issue at

It uses a directly $_GET parameter in the html, without any htmlentities encode.

Hi,

I noticed that when creating a new user the lastname is automatically converted to full uppercase.
In my case this is annoying.

Can this be disabled or is there a reason it is automatically converted to uppercase ?

Thanks!
Johan

Firstly I would like to highlight the excellent job down as leave system moreover the very good PHP code.

Additionally I would like to report an issue/future development regards to users, under list of users you are able to delete a user however you cannot temporary disable a user even there is a boolean field in the database “Active” doesn't work.

Once again thanks for the good work!!!

Thanks for great develope.
We using Google calendar for a long time, so I want to know is there any way I can connect your system calendar to Google Calendar, and show all approved request in Google calendar?
Thank you.

Hello,
I am having 2 questions :

1.If we are having all saturday half day and if any user apply for full day leave on any saturday then there should be a validation, like user cant take leave at the same time of days off.

1. Are we able to add some more roles other then User and HR Admin ?

I am waiting for your reply.

Thanks
Amit

If I change the default leave type in the config file it correctly controls the behaviour for users submitting leave requests.

However if a HR Admin tries to submit a leave on another users behalf, the default setting doesn't seem to have taken effect.

Hi,
I think it could be very useful to have a personnal profil zone and to have the possibility to disconnect.
Thanks by advance
Pierre-Yves

Hi

I made this because it was useful in my case. I use "Compensate" type for my colleagues who wants a day off because they worked a Saturday. In my case, in the contract there is no compensate credit because it is not the same for everyone.

So here are the modification I made :
file : application/views/leaves/create.php line 66

< div class="alert hide alert-error" id="lblCreditAlert" onclick="$('#lblCreditAlert').hide();">
< button type="button" class="close">×

< /div>

file : application/views/leaves/create.php line 94
< div class="span4 hide">

file : application/views/hr/createleave.php line 63

< div class="alert hide alert-error" id="lblCreditAlert" onclick="$('#lblCreditAlert').hide();">
< button type="button" class="close">×

</ div>

file : application/views/hr/createleave.php line 92
< div class="span4 hide">

file : application/views/leaves/edit.php line 69

< div class="alert hide alert-error" id="lblCreditAlert">
< button type="button" class="close">×

</ div>

file : application/views/leaves/edit.php line 105
< div class="span4 hide">

file : application/config/config.php line 401
//Disable alert box in case the user request a leave and have no credit
$config['disable_credit_alert'] = FALSE;

Hello

Here is the error message:

A PHP Error was encountered
Severity: Notice
Message: Undefined variable: display
Filename: models/leaves_model.php
Line Number: 939

It occurs on pages that have 1/2 days (afternoon) requested leaves

Regards

Please look at the snapshots : when a leave request is starting at 30/06 and finishing at 01/07, the leave is visible in the calendar view but not in the tabular view.

The version is 0.4.0

hello,
am I French thus I hope that my English would not be too bad, my question is thus the following one how does make one to add a number of vacation for a user? because when the platform jorani is to create the user have 0 days off whereas the user could have 5 and 3 day days off of RTT
Cordially,

Hi Bbalet,

Can you pls send me code the user cannot apply their leave after 7days before their leave.

Thanks

in file application/views/leaves/edit.php line 60

must delete line 61

First of all thank you for your effort, great piece of work here!

In order to install jorani I need to edit directly (at least) application/config/database.php and application/config/config.php. I would suggest that you rename those default config files (or even the whole folder) to something like *-default.php and then copy and rename on installation those files/folder and then edit them (and put the renamed stuff to .gitignore). This would allow users to simlink eg. different database settings without messing up with the core...

what do you think about this suggestion?

Hi Bbalet,

can I know why this happened.

Thanks A Lot

A Database Error Occurred

Error Number: 1054

Unknown column 'organization.supervisor' in 'on clause'

SELECT users.id, CONCAT(users.firstname, ' ', users.lastname) as username, email FROM (organization) JOIN users ON users.id = organization.supervisor WHERE organization.id = '0'

Filename: C:\wamp\www\cticlms\system\database\DB_driver.php

Line Number: 330

[question] Hello, I just installed Jorani to test it and I must say it is really good, way better than most of the others open sources alternatives.

I just have a question about weekends: Could it be possible to color the weekend with a light grey into calendars because I find it too difficult to make a proper differenciation between working days and weekends.

First of all, congrats for the work so far, our company is testing Jorani, and we are quite satisfied with the results.

When the server enables LDAP authentication, it is confusing for the users, and annoying for the account creator, to have to set a password, that will never be used.

The same applies to the reset password button, which confuses users expecting their LDAP password to be changed when clicking on it.

Would it make sense then to have the password setting disabled when LDAP authentication is enabled? All accounts without passwords would then be disabled in the case of a change of the authentication mechanism, until a password is reset by the user.

Once again, thanks for the work so far.

After issue #38 it's possible to integrate a Centralized Authentication Service for SSO like CAS.
I can provide examples if needed (also working with javascript frontend)

Hi jorani,

on balance report some leave not show amount on latest update.

Hi,

First of all, let me reiterate how much I appreciate Jorani. Our server has been running the version 0.4 since its launch without a single mishap, and my bosses tell me they can do much of what they need with it.

However they emitted this feature request: what about only exporting the result of a search when doing a search? Typically, the HR employee needs to transcript all the validated requests at the end of each month to enter them in a government sanctioned software. To do this the search function work quite well, that person does a search for the current month, but then when exporting, this search has no effect.

For this particular case having a view per month with the associated export function would work, but the more generic approach would probably be to use the search result in the export.

What do you think of this feature?

Ben

PS: just out of curiosity, can we get a rough estimation on the release of the next version? Is there a fix set of features/ bug to tick off, or is it scheduled for a specific date no matter what, or simply when you deem it ready and you will have the available time?

Hello, I have to install jorani on a unbutu Server, I will like that connection this makes with the login activates directory, I have a problem has the configuration of ldap_basedn in the file configuration/config.php our login functions in the following way domain/name.familname y which configuration must one make you in the model of authentification LDAP,
Cordially

Hello ,

I encounter a problem for notification email I properly configure jorani with Gmail configuration but no notification works

til there's a pattern to the gmail inbox ?

Thanks in advance

When there are two leaves in the same day (for example paid leave in the morning and maternity leave in the afternoon) the tabular calendar doesnt display the day correctly. The CSS style of the cell is set to "acceptedaccepted".

Use PHPExcel to implement a mass importer.

• Upload an excel file
• Browse all the lines of the first sheet until the first blank line
• First line (headers) is ignored.
• The password is automatically generated.
• An e-mail is sent to each created user.

Fields :

• login (optional : computed as lowercase(firstname[0] + lastname).
• firstname (mandatory)
• lastname (mandatory)
• email (mandatory)
• role (optional : user by default)
• manager (optional : 0 by default)

Hello,

I am keep on getting issue "Unable to load the requested class: language" (1.png) when i am trying to edit any user.

When i have checked in system/library then i wasnt able to find any language library (2.png). Can you please provide that so that i can use it.

I am waiting for your reply.

Thanks
Amit

on entitleddays/contract/# I am able to set days and everything works fine. If I enter a new Vaction Period/Day it will save the entity just fine and display it correctly eg. start 01/01/2015 and end 12/31/2015. But if I reload the page or do login for another session all dates become to 01/01/J and 12/31/J.

Since the calculation of the days is still correct I assume this is only a display issue

Hello,

when i try to make in frecnh i have an error page :

http://domaine.fr/lms/session/language
Not Found

The requested URL /lms/session/language was not found on this server.
Apache/2.4.7 (Ubuntu) Server at serveur.domaine Port 80

Hi,
I think it could be very useful to connect this app to an ActiveDirectory/LDAP
Thanks by advance
Pierre-Yves

When a user submits a leave request he can choose from all defined leave types.
It will be more convenient when you can couple some leave types to a contract and that only those specific leave types are shown.

When a user submits a leave request for a leave type which has only 0 days left it will give an error but he will still be able to save.
This is not good for all leave types:
For paid leaves we don't want to go below 0 days, the user should not be able to perform such request.
For sick leave it shouldn't give a warning about going below 0 days as for sick leave you don't have any entitled days and always will go below 0.
When creating a leave type some extra options should be available where you can define the behaviour when you are out of entitled days.

It would be great if it was possible as a user to edit or cancel a pending request when we make a mistake

Quand je vais dans mes compteurs j'ai 8 jours disponibles. Si je sélectionne le 1er Juin je repars avec 25 jours (nouveau cycle)

Par contre dans si je fais une demande pour le mois de juillet j'ai un message qui dit que je n'ai que 8 jours disponibles alors normalement en Juillet je serais sur le nouveau cycle donc 25 jours disponibles

Merci

Hello,
can we have an windows active directory connector for all users ?

The tool will implement the following scenario :

• Each staff has ID and password to log in online leave request
• Staff makes/create leave request & submit to his/her manager
• Leave request goes automatically to Line Manager's and HR's mail inbox
• Line Manager approves by clicking an icon of the received email
• Approval goes back to staff's and HR's mail inbox
• Staff can take leave

Staff & HR can extract the details of leave record:

• New entitled leave days for the year.
• Total number of days taken.
• Total number of days to be taken before end of the year.
• Details of each taken date.

When i modifie a user, the entity of this user change and become the root of the entity

Hi guys,

I am trying to use your software and I get an error:
Error Number: 1364

Field 'weekly_duration' doesn't have a default value

INSERT INTO contracts (name, startentdate, endentdate) VALUES ('Admin', '01/01', '12/31')

Filename: /lms/models/contracts_model.php

Line Number: 73

it's only half day off option for leave request, can you develop a option do request for hourly, like from 9:00 am to 11:00 am. Thanks a lot.

Hi,
I've got an error in user's edition.

I just download the script and the version is 4.0.1
Have you the same problem ?

Have a good day,

Amélie

Hello,

thank you for this great software. I have been installing it this morning and encountered a small glitch during email setup:

In the testmail.php the From-address is hardcoded although it can be set in the config ($config['from_mail']). This causes problems with email providers like office365.

Would it be possible to just use the value from $config?

Thank you,
makaho

This calendar will have two view :

• My leave requests.
• Leave requests of my team (people having the same manager).
  different colors will be used according to the status (planned, validated).

Rejected leave requests will not be displayed. Limited to the last 70 entries.

Implement a multiple page setup assistant :

• DB Setup.
• Default admin user.
• E-mail server setting (with an optional test pop-up).
• Create a pair of RSA keys (optional).
  Once completed. A flag will indicate into application/config that the setup has been completed.

• Views are : CRUD and list users.
• The login must be unique.
• A function allows to export the list of users in Excel.
• From the user list, a pop-up allows to reset a password. The new password is not displayed to the admin but sent to the user by e-mail.
• User management views are accessed by admin users only.
• The only function allowed to users is "reset my password".
• In all operations, the password field is encrypted using RSA (not transmitted in clear).

Data model :

• ID
• login
• firstname
• lastname
• email
• role (user/admin of the system)
• manager (user that will validate the leave requests or self for auto validation).

I see a bad SQL syntax for a comment into lms.sql file on line 564:
564 - -----...

works for me with this syntax:
564 -- -----..

I am unable to get this to work using lighttpd. I am able to see some pages, but clicking on links I receive 404 and/or 500 errors. Are there any recommendations for setup? Thanks in advance.

LMS will not need an HTTPS host systeam. However the following security features have been prototyped and will be implemented :

• Any Password field will be encrypted with an asymetric encryption alogorithm (RSA).
• The application will implement a function level access check preventing unauthorized access. a general auth lib will be implemented along with logic access on each controller for more complicated rules.
• Each form will be validated.
• Direct SQL code is disallow, we will rely ont DB CI function to build each query.
• Each type a data is transmitted, an XSS security filter will prevent from injection attacks.