Forum

[SOLVED] [V5] Order...
 
Notifications
Retirer tout

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

6 Posts
2 Utilisateurs
0 Reactions
3,609 Vu
(@papjul)
Posts: 143
Active Member
Début du sujet
 
[#2366]

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,


 
Posté : 17 Juin PM 14:066
(@babynus)
Posts: 14952
Membre Admin
 

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


 
Posté : 17 Juin PM 15:066
(@papjul)
Posts: 143
Active Member
Début du sujet
 

- bill : was forgotten.

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

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

Requirements, tests cases & tests sessions.

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.


 
Posté : 17 Juin PM 15:066
(@babynus)
Posts: 14952
Membre Admin
 

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

It will be fixed on next patch.


 
Posté : 17 Juin PM 16:066
(@papjul)
Posts: 143
Active Member
Début du sujet
 

Issue affects messages too.


 
Posté : 18 Juin PM 13:066
(@babynus)
Posts: 14952
Membre Admin
 

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


 
Posté : 19 Juin AM 02:066
Share:
Retour en haut