[SOLVED] [V5] Order doesn't appear in list if no project set

Début
Précédent
1
Suivant
Fin

papjul
Topic Author
Offline
Premium Member

17 Jui 2015 12:13 #1 by papjul

[V5] Order doesn't appear in list if no project set was created by papjul

Hi,

As an administrator, when I create an order with no project selected in the list (optional field), it doesn't show up in the orders list (list area). When I add a project id to this order directly in database, order shows up in the list.

I didn't test other entities, but it might not affect only orders.

I didn't remember having this problem before V5.

Thank you,

Please Connexion or Create an account to join the conversation.

babynus
Offline
Administrator
Moderator

17 Jui 2015 13:33 #2 by babynus

Replied by babynus on topic [V5] Order doesn't appear in list if no project set

Hi,

You may have discovered a bug.
It is due to V5 new access rights management, that can be different on several projects (different profile can now be defined on each project).
Other entities are not affected as Project is mandatory for most items.
Items that are not Project dependant are correctly managed (Products, Resources, ...)
Item where project is optional are very few :
- document : already taken into account
- bill : was forgotten.
I'll check to be sure there is not other.

Now I wonder why project is not mandatory for bills. Does it really have an interest for you ?
Moveover, for quotes project in mandatory...
(that's why I never faced the issue : I always create bills through copy of quotes)

Ticket #1723 recorded.

Thanks for reporting

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

papjul
Topic Author
Offline
Premium Member

17 Jui 2015 13:47 #3 by papjul

Replied by papjul on topic [V5] Order doesn't appear in list if no project set

babynus wrote: - bill : was forgotten.

It's mandatory on invoices/bills for me, you meant orders?

babynus wrote: I'll check to be sure there is not other.

Requirements, tests cases & tests sessions.

babynus wrote: Now I wonder why project is not mandatory for bills. Does it really have an interest for you ?
Moveover, for quotes project in mandatory...
(that's why I never faced the issue : I always create bills through copy of quotes)

I was just testing an order, that's why I didn't fill in all fields, I usually copy from quotations to orders too.

Please Connexion or Create an account to join the conversation.

babynus
Offline
Administrator
Moderator

17 Jui 2015 14:46 #4 by babynus

Replied by babynus on topic [V5] Order doesn't appear in list if no project set

You're right.
Issue exist on Orders, Requirements, Tests cases & Tests sessions.

It will be fixed on next patch.

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

papjul
Topic Author
Offline
Premium Member

18 Jui 2015 11:32 #5 by papjul

Replied by papjul on topic [V5] Order doesn't appear in list if no project set

Issue affects messages too.

Please Connexion or Create an account to join the conversation.

babynus
Offline
Administrator
Moderator

19 Jui 2015 00:06 #6 by babynus

Replied by babynus on topic [V5] Order doesn't appear in list if no project set

Issue fixed.
Fix is just to replace in /tool/projeqtor.php, line 742

} else if ($accessRightRead=='ALL') {
    $queryWhere="($tableAlias$fieldProj not in $listNO or $tableAlias$fieldProj is null)";
    if ($listRES) $queryWhere.=" and ($tableAlias$fieldProj not in $listRES or $clauseRES)";
    if ($listOWN) $queryWhere.=" and ($tableAlias$fieldProj not in $listOWN or $clauseOWN)";
  }

with

} else if ($accessRightRead=='ALL') {
    $queryWhere="($tableAlias$fieldProj not in $listNO or $tableAlias$fieldProj is null)";
    if ($listRES) $queryWhere.=" and ($tableAlias$fieldProj not in $listRES or $tableAlias$fieldProj is null or $clauseRES)";
    if ($listOWN) $queryWhere.=" and ($tableAlias$fieldProj not in $listOWN or $tableAlias$fieldProj is null or $clauseOWN)";
  }

Fix will soon be deployed in patch V5.0.1

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

Début
Précédent
1
Suivant
Fin

Moderators: babynus, protion

Time to create page: 0.044 seconds

Prochaines Sessions

Démonstration de ProjeQtOr

Planifiez avec ProjeQtOr

Administrez avec ProjeQtOr

[SOLVED] [V5] Order doesn't appear in list if no project set

Paramétrages de cookies

Cookies fonctionnels

Session

Autres cookies

Prochaines Sessions

Démonstration de ProjeQtOr

Planifiez avec ProjeQtOr

Administrez avec ProjeQtOr

[SOLVED] [V5] Order doesn't appear in list if no project set

Paramétrages de cookies

Cookies fonctionnels

Session

Autres cookies

Login Form