[English] Version 0.6.2 is released

[Benjamin BALET]

This release adds the following new features:

 * Workflow of leave is extended to cancellation and canceled statuses.

 * Employees and  their managers can comment on a leave request.

 * Users can create custom lists of employees (used as an alternative for oraginzation/entity in tabular calendar).

 * An employee can send a reminder for a requested/cancled leave to his line manager.

 * Leave requests are now clickable into calendar/tabular and global.

 * Filter on status to dynamically filter lists displayed on pages.

https://github.com/bbalet/jorani/releases/tag/v0.6.2

[Roger Wolfs]

Dear Benjamin,

Thank for your work. New version looks good!

I was trying to upgrade, however I'm running into some problems, think database related....

Below the error messages:

On cancel request:

Er is een database fout opgetreden.

Error Number: 1054

Unknown column 'change_date' in 'field list'

SELECT leaves.*, status.name as status_name, types.name as type_name, lastchange.date as change_date, requested.date as request_date FROM `leaves` inner join status ON leaves.status = status.id inner join types ON leaves.type = types.id left outer join ( SELECT id, MAX(change_date) as date FROM leaves_history GROUP BY id ) lastchange ON leaves.id = lastchange.id left outer join ( SELECT id, MIN(change_date) as date FROM leaves_history WHERE leaves_history.status = 2 GROUP BY id ) requested ON leaves.id = requested.id WHERE leaves.employee = 1

Filename: models/Leaves_model.php

Line Number: 85

On Approval - Leaves: 

Er is een database fout opgetreden.

Error Number: 1054

Unknown column 'change_date' in 'field list'

SELECT leaves.id as leave_id, users.*, leaves.*, types.name as type_label, status.name as status_name, types.name as type_name, lastchange.date as change_date, requested.date as request_date FROM `leaves` inner join status ON leaves.status = status.id inner join types ON leaves.type = types.id inner join users ON users.id = leaves.employee left outer join ( SELECT id, MAX(change_date) as date FROM leaves_history GROUP BY id ) lastchange ON leaves.id = lastchange.id left outer join ( SELECT id, MIN(change_date) as date FROM leaves_history WHERE leaves_history.status = 2 GROUP BY id ) requested ON leaves.id = requested.id WHERE users.manager = 1 AND (leaves.status = 2 OR leaves.status = 5) order by leaves.startdate DESC;

Filename: models/Leaves_model.php

Line Number: 1264

On Requests - List of leave requests:

Er is een database fout opgetreden.

Error Number: 1054

Unknown column 'change_date' in 'field list'

SELECT leaves.*, status.name as status_name, types.name as type_name, lastchange.date as change_date, requested.date as request_date FROM `leaves` inner join status ON leaves.status = status.id inner join types ON leaves.type = types.id left outer join ( SELECT id, MAX(change_date) as date FROM leaves_history GROUP BY id ) lastchange ON leaves.id = lastchange.id left outer join ( SELECT id, MIN(change_date) as date FROM leaves_history WHERE leaves_history.status = 2 GROUP BY id ) requested ON leaves.id = requested.id WHERE leaves.employee = 1

Filename: models/Leaves_model.php

Line Number: 85

These error-messages are not present when I use the empty demo-database included on GitHub, only when I use my own database (previous version, patched to 0.60).

My own database also consist of 10 more tables  (*_history, all empty).

I'm not enough into SQL to find a clue myself.... please your help!!

Kind regards,

Roger

Op maandag 17 juli 2017 17:31:09 UTC+2 schreef Benjamin BALET:

[Roger Wolfs]

The changed layout with leave-request (planned versus requested) is confusing in my opinion.....

Think that this button-layout will lead to many unintentional planned leaves instead of real requests (unless you could add a message that the request was planned and not submitted to the supervisor after clicking the planned button??).

I think (personal opinion) that the previous layout was more clear.

Op maandag 17 juli 2017 17:31:09 UTC+2 schreef Benjamin BALET:

This release adds the following new features:

[Benjamin BALET]

Looks like you come from version 0.4.X, so you need to apply patch_to_0.5.0.sql as well, because they are not cumulative.

Op maandag 17 juli 2017 17:31:09 UTC+2 schreef Benjamin BALET:

This release adds the following new features:

--
You received this message because you are subscribed to the Google Groups "jorani" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jorani+unsubscribe@googlegroups.com.
To post to this group, send email to jor...@googlegroups.com.
Visit this group at https://groups.google.com/group/jorani.
To view this discussion on the web visit https://groups.google.com/d/msgid/jorani/6fdb7923-d943-4cbb-9887-7309577cbfa2%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[R.C.W. Wolfs]

Hmmm, did now patch 0.5 and 0.6 on database however still exactly same errors....

We are now working with version 0.5.0 without problems..

Roger

Verzonden vanaf mijn Samsung Galaxy-smartphone.

-------- Oorspronkelijk bericht --------

Van: Benjamin BALET <benjami...@gmail.com>

Datum: 22-07-17 19:43 (GMT+01:00)

Aan: jor...@googlegroups.com

Onderwerp: Re: [jorani-users] Re: [English] Version 0.6.2 is released

You received this message because you are subscribed to a topic in the Google Groups "jorani" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/jorani/C7zm6wFbH_c/unsubscribe.
To unsubscribe from this group and all its topics, send an email to jorani+un...@googlegroups.com.

To post to this group, send email to jor...@googlegroups.com.
Visit this group at https://groups.google.com/group/jorani.

To view this discussion on the web visit https://groups.google.com/d/msgid/jorani/CAPFJBORVgur4wCV-YLe8%2BauHhUrrn%2BZUZ%3Dm6qt5VKuTAw5pqdA%40mail.gmail.com.

[Benjamin BALET]

Ok, you told me that you have 10 history tables, so it means you missed a patch.

Please apply again the patches but starting from 0.4.0, so :

patch_to_0.4.0.sql

patch_to_0.5.0.sql

patch_to_0.6.0.sql

To unsubscribe from this group and all its topics, send an email to jorani+unsubscribe@googlegroups.com.

To post to this group, send email to jor...@googlegroups.com.
Visit this group at https://groups.google.com/group/jorani.

To view this discussion on the web visit https://groups.google.com/d/msgid/jorani/CAPFJBORVgur4wCV-YLe8%2BauHhUrrn%2BZUZ%3Dm6qt5VKuTAw5pqdA%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

--

You received this message because you are subscribed to the Google Groups "jorani" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jorani+unsubscribe@googlegroups.com.
To post to this group, send email to jor...@googlegroups.com.
Visit this group at https://groups.google.com/group/jorani.

To view this discussion on the web visit https://groups.google.com/d/msgid/jorani/EB0615413A307D4BB33D144307935E5DDC4D114C%40EXCH-HE03.erasmusmc.nl.

[R.C.W. Wolfs]

You are great!!!!!

Thank you for your very fast help!!!

Kind regards,

Roger

Verstuurd vanaf mijn iPad

To unsubscribe from this group and all its topics, send an email to jorani+un...@googlegroups.com.

To post to this group, send email to jor...@googlegroups.com.
Visit this group at https://groups.google.com/group/jorani.

To view this discussion on the web visit https://groups.google.com/d/msgid/jorani/CAPFJBOSQumDQNnkxmko4LqBUJmPjWSn6rDpeNfmfMngO1GdK8Q%40mail.gmail.com.

[Str]

I like these updates! Great work!!

Two bugs (?) on clean install for me:

- Mail sending doesn't work. Testmail works after adding of '$config['_smtp_auth'] = TRUE;' in email config file. Mailing in Jorani itself still doesn't work.

- Warnings on commenting on a leave request:

A PHP Error was encountered

Severity: Warning

Message: Creating default object from empty value

Filename: controllers/Leaves.php

Line Number: 189

object(stdClass)#26 (1) { ["comments"]=> array(1) { [0]=> object(stdClass)#20 (4) { ["type"]=> string(7) "comment" ["author"]=> string(1) "1" ["value"]=> string(12) "test comment" ["date"]=> string(9) "2017-7-26" } } } 

A PHP Error was encountered

Severity: Warning

Message: Cannot modify header information - headers already sent by (output started at /Applications/MAMP/htdocs/jorani-0.6.2/system/core/Exceptions.php:271)

Filename: helpers/url_helper.php

Line Number: 564

[Benjamin BALET]

The warning message will be removed in the next version.

For email setup, please search into this group there are already a lot of questions/answers

--
You received this message because you are subscribed to the Google Groups "jorani" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jorani+unsubscribe@googlegroups.com.
To post to this group, send email to jor...@googlegroups.com.
Visit this group at https://groups.google.com/group/jorani.

To view this discussion on the web visit https://groups.google.com/d/msgid/jorani/2127d69a-1fd2-4a68-89ee-f2ef2b05f0f5%40googlegroups.com.

[Roger Wolfs]

Another option is to change the labels of the buttons. Now the labels are the same as the status of the request (Planned versus Requested; at least I do not see a different label in the translation lists).

Linguistically, this should be an active verb, an assignment: so Plan or Request.

This should then also be added to the translation list

Kind regards,

Roger

[kotak lama]

hi Binjamin,,,

good day to you,,can we change first name and last name to only one column full name?

thank you 

[Benjamin BALET]

Nope. Below a tip if you want to work with lists.

Please export the list into Excel, add a column (for example C) after lastname. If you have :

 - Column A : Firstname.

 - Column B : Lastname

Into C (the new column you have inserted), enter the formula (it is an example) = A2 & " " & B2

then make it slide to the end of list and you get what you want in a minute.

--

You received this message because you are subscribed to the Google Groups "jorani" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jorani+unsubscribe@googlegroups.com.
To post to this group, send email to jor...@googlegroups.com.
Visit this group at https://groups.google.com/group/jorani.

To view this discussion on the web visit https://groups.google.com/d/msgid/jorani/b4adf60e-1c79-400e-aaa5-e62edf068018%40googlegroups.com.

[kotak lama]

and the last one can we add proof column..like picture for sick leave(mc Slip)

On Thursday, August 10, 2017 at 3:56:04 PM UTC+8, Benjamin BALET wrote:

Nope. Below a tip if you want to work with lists.

Please export the list into Excel, add a column (for example C) after lastname. If you have :

 - Column A : Firstname.

 - Column B : Lastname

Into C (the new column you have inserted), enter the formula (it is an example) = A2 & " " & B2

then make it slide to the end of list and you get what you want in a minute.

2017-08-10 9:49 GMT+02:00 kotak lama <kotak...@gmail.com>:

hi Binjamin,,,

good day to you,,can we change first name and last name to only one column full name?

thank you 

On Monday, July 17, 2017 at 11:31:09 PM UTC+8, Benjamin BALET wrote:

This release adds the following new features:

 * Workflow of leave is extended to cancellation and canceled statuses.

 * Employees and  their managers can comment on a leave request.

 * Users can create custom lists of employees (used as an alternative for oraginzation/entity in tabular calendar).

 * An employee can send a reminder for a requested/cancled leave to his line manager.

 * Leave requests are now clickable into calendar/tabular and global.

 * Filter on status to dynamically filter lists displayed on pages.

https://github.com/bbalet/jorani/releases/tag/v0.6.2

--
You received this message because you are subscribed to the Google Groups "jorani" group.

To unsubscribe from this group and stop receiving emails from it, send an email to jorani+un...@googlegroups.com.

To post to this group, send email to jor...@googlegroups.com.
Visit this group at https://groups.google.com/group/jorani.

[Benjamin BALET]

Sorry I don't understand (and you sent no pic).

Please open new discussion as it is not related to the features of the lastest version.

To unsubscribe from this group and stop receiving emails from it, send an email to jorani+unsubscribe@googlegroups.com.

To post to this group, send email to jor...@googlegroups.com.
Visit this group at https://groups.google.com/group/jorani.

To view this discussion on the web visit https://groups.google.com/d/msgid/jorani/7400429a-922f-47e2-8585-e022b0724e01%40googlegroups.com.

[kotak lama]

sorry..i means proof for sick leave..like picture for medical certificate slip

[kotak lama]

hi Bbalet,

how to set date picker to min date:+7? 

[Benjamin BALET]

Open a new topic, stop reply on an topic not related. Last warning.

To unsubscribe from this group and stop receiving emails from it, send an email to jorani+unsubscribe@googlegroups.com.

To post to this group, send email to jor...@googlegroups.com.
Visit this group at https://groups.google.com/group/jorani.

To view this discussion on the web visit https://groups.google.com/d/msgid/jorani/a0a14fad-975b-4685-bc9d-2725a95392e6%40googlegroups.com.

[lulama yane]

Good day

I would like to install the Jorani on my server , I have the source code but have no clue on how to deploy it on the server. I would really appreciate your help .

[Benjamin BALET]

Create a new post, please stop replying on old post.

One post = one topic.

--

You received this message because you are subscribed to the Google Groups "jorani" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jorani+unsubscribe@googlegroups.com.
To post to this group, send email to jor...@googlegroups.com.
Visit this group at https://groups.google.com/group/jorani.

To view this discussion on the web visit https://groups.google.com/d/msgid/jorani/8fa18f94-f8cb-4132-9cad-ac03944ae809%40googlegroups.com.

[Peter Sharrock]

Hi Benjamin. I setup Jorani v0.4.6 in January and it's been working great but now some people are trying to book leave requests for next year (we run 1st Jan - 31st Dec) and it's taking days off their current year's holiday entitlement. Am I missing something?

Pete

[nazdaqtech...@gmail.com]

[nazdaqtech...@gmail.com]

List of employees, tabular calendar and global calendar problem.

I drop database and create a database

then I restore database from mysqldump frile.

mysql -uroot -p jorani < jorani.sql

I reboot myJorani server. and open browser.

I login as admin user.

I click HR>list of employees

DataTables warning: table id=users - Ajax error. For more information about this error, please see http://datatables.net/tn/7

Unexpected Ajax Error

I click Calendars > Global

Unexpected Ajax Error

I click Calendars > Tabular

A Database Error Occurred

Error Number: 42000/1305

FUNCTION jorani_prod.GetFamilyTree does not exist

SELECT GetFamilyTree(id) as id FROM organization WHERE id =0

Filename: models/Organization_model.php

Line Number: 81

cat /var/www/html/jorani/application/logs/log-2018-01-21.php

Query error: FUNCTION jorani_prod.GetFamilyTree does not exist - Invalid query: SELECT GetFamilyTree(id) as id FROM organization WHERE id =0

What is problem?

Need help.

Thanks

[Benjamin BALET]

You have forgotten to backup the functions. Please create them again by using sql/lms.sql

This has already been explained into this forum. Please use the search tool.

--

You received this message because you are subscribed to the Google Groups "jorani" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jorani+unsubscribe@googlegroups.com.
To post to this group, send email to jor...@googlegroups.com.
Visit this group at https://groups.google.com/group/jorani.

To view this discussion on the web visit https://groups.google.com/d/msgid/jorani/6b776ea7-b804-4c08-a503-3e0a7e45bb0b%40googlegroups.com.

[egay pontilla]

Hi Benjamin,

Its was a week since Im exploring Jorani. Leave system was great.
But using the Over Time management, can you help me how to see the reports where in I can view all employees Over Time filed? Or maybe how to see a report of all overtime in one page.

Thank you so much.