View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Supportez nous sur Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - v7.0.9 the calendar on/off feature does not work - ProjeQtOr

Prochaines sessions de formation

Les prochaines formations et démonstrations sont ouvertes, inscrivez-vous rapidement !

 

Démonstration de ProjeQtOr

(gratuit, sur inscription)

Mardi 23 avril (10h30-12h)

Jeudi 16 mai (16h-17h30)

Jeudi 13 juin (10h30-12h)

  
 

Planifiez avec ProjeQtOr

3 et 4 avril (9h - 12h30)

  
 

Administrez avec ProjeQtOr

10 et 11 avril (9h - 12h30)

  

 

 
 

v7.0.9 the calendar on/off feature does not work

More
16 Aoû 2018 17:23 #1 by piadm
v7.0.9 the calendar on/off feature does not work was created by piadm
Hi,

As already reported in this issue the calendar on/off feature does not work when you click on a date.

A quick analysis makes me think the problem comes from the switchDay() function in tool/saveCalendar.php that uses getSingleSqlElementFromCriteria() but the calendar table itself contains one more row for each click on the same day:
select * from calendar where calendardate='2018-08-15';
 id | name | isoffday | calendardate |   day    |  week  | month  | year | idle | idcalendardefinition
----+------+----------+--------------+----------+--------+--------+------+------+----------------------
 27 |      |        1 | 2018-08-15   | 20180815 | 201833 | 201808 | 2018 |    0 |                    2
 29 |      |        1 | 2018-08-15   | 20180815 | 201833 | 201808 | 2018 |    0 |                    1
 37 |      |        1 | 2018-08-15   | 20180815 | 201833 | 201808 | 2018 |    0 |                    1
 44 |      |        0 | 2018-08-15   | 20180815 | 201833 | 201808 | 2018 |    0 |                    1
 45 |      |        0 | 2018-08-15   | 20180815 | 201833 | 201808 | 2018 |    0 |                    1
 46 |      |        0 | 2018-08-15   | 20180815 | 201833 | 201808 | 2018 |    0 |                    1
 47 |      |        0 | 2018-08-15   | 20180815 | 201833 | 201808 | 2018 |    0 |                    1
 48 |      |        0 | 2018-08-15   | 20180815 | 201833 | 201808 | 2018 |    0 |                    1
 49 |      |        0 | 2018-08-15   | 20180815 | 201833 | 201808 | 2018 |    0 |                    1
(9 rows)

In fact an admin closed the default standard calendar (id=1) and the only other one available as well. That was a mistake of course as it was not possible to create resources anymore. I unticked the "close" option for the default calendar and it seems that blindly inserted the rows 37 to 43 in the calendar table... but there was already a row 29 for the date 2018-08-15' in the default calendar. Starting from that time there were 2 rows in the calendar table and each click on that date adds one more.

So the problem is probably not coming from the switchDay() function but from these duplicate rows. As un-closing a calendardefinition insert rows in the calendar table (default rows?), closing a calendar should remove them, but that apparently did not happen.

Question: To fix this can I just delete the calendar rows 37 to 49?

Please Connexion or Create an account to join the conversation.

More
17 Aoû 2018 09:19 #2 by babynus
Replied by babynus on topic v7.0.9 the calendar on/off feature does not work
Yes, you can delete rows in the table.
This one is a simple one.

This will just remove off days from the calendar.
Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

More
17 Aoû 2018 15:55 #3 by piadm
Replied by piadm on topic v7.0.9 the calendar on/off feature does not work
Done.

Thank you for your help Babynus.

Please Connexion or Create an account to join the conversation.

Moderators: babynus, protion
Time to create page: 0.042 seconds

Paramétrages de cookies

×

Cookies fonctionnels

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Veuillez vous connecter pour voir vos activités!

Autres cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.

Login Form