Forum

Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.

[SOLVED] [V5] Order...
 
Notifications
Clear all

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

6 Posts
2 Users
0 Reactions
3,644 Views
(@papjul)
Posts: 143
Active Member
Topic starter
 
[#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,


 
Posted : 17 Jun 2015 14H13
babynus
(@babynus)
Posts: 14966
Main Contributor 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


 
Posted : 17 Jun 2015 15H33
(@papjul)
Posts: 143
Active Member
Topic starter
 

- 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.


 
Posted : 17 Jun 2015 15H47
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

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

It will be fixed on next patch.


 
Posted : 17 Jun 2015 16H46
(@papjul)
Posts: 143
Active Member
Topic starter
 

Issue affects messages too.


 
Posted : 18 Jun 2015 13H32
babynus
(@babynus)
Posts: 14966
Main Contributor 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


 
Posted : 19 Jun 2015 2H06
Share:

Scroll to Top