Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0043834Retail ModulesWeb POSpublic2020-04-22 17:402020-05-12 09:22
Reporterinaki_garcia 
Assigned Toranjith_qualiantech_com 
PriorityimmediateSeveritycriticalReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionRR20Q2Fixed in VersionRR20Q2 
Merge Request Status
Review Assigned Tomarvintm
OBNetwork customerNo
Support ticket
Regression levelPackaging and release
Regression date2020-02-10
Regression introduced in releasemain
Regression introduced by commithttps://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/c027ae221f7e [^]
Triggers an Emergency PackNo
Summary0043834: [20Q2] User access and visibility management per terminal via "POS Terminal Access" subtab no longer works
DescriptionEntering rows in the "POS Terminal Access" subtab in the "User" tab in the backend has lost its effect in specifying the users allowance in terminals at an Organization level, meaning that users sharing organization with the terminals will be listed in all of the terminals/touchpoints.

This regression is considered critical, since it poses an important security risk for organizations with many users and terminals. Reproducible in builds updated to 20Q2, but not in 20Q1.
Steps To Reproduce-- In the Backend
0. Log in the Backend with the "The White Valley Group Admin" role
1. Create a new user and save it
2. Add in a record with the "VallBlancaManual" Role in User Roles subtab and save it

-- In the Frontend
3. Navigate to the VBS-1 terminal
NOTICE that the created user appears listed, as expected

-- In the Backend
4. For the previously created user, add in a record with the "VBA1001" Touchpoint in the POS Terminal Access subtab, and save it

-- In the Frontend
5. Refresh the Web POS
NOTICE that the created user STILL appears, which is an incorrect. The user should only show in the specified VBA1001 terminal/touchpoint.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0043828 closed ranjith_qualiantech_com [20Q2] User access and visibility management per terminal via "POS Terminal Access" subtab no longer works 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2020-04-23 11:46ranjith_qualiantech_comTypedefect => backport
2020-04-23 11:46ranjith_qualiantech_comTarget Version => RR20Q2
2020-04-23 12:40ranjith_qualiantech_comRegression levelPre packaging ( pi ) => Packaging and release
2020-05-06 09:24hgbotCheckin
2020-05-06 09:24hgbotNote Added: 0119613
2020-05-06 09:24hgbotStatusscheduled => resolved
2020-05-06 09:24hgbotResolutionopen => fixed
2020-05-06 09:24hgbotFixed in SCM revision => http://code.openbravo.com/retail/backports/3.0RR20Q2/org.openbravo.retail.posterminal/rev/dc97805897dc2396892eb938cb53ad428f3c4396 [^]
2020-05-07 09:27marvintmReview Assigned To => marvintm
2020-05-07 09:27marvintmStatusresolved => closed
2020-05-07 09:27marvintmFixed in Version => RR20Q2
2020-05-12 07:27ranjith_qualiantech_comNote Added: 0119745
2020-05-12 07:27ranjith_qualiantech_comStatusclosed => new
2020-05-12 07:27ranjith_qualiantech_comResolutionfixed => open
2020-05-12 07:27ranjith_qualiantech_comFixed in VersionRR20Q2 =>
2020-05-12 07:27ranjith_qualiantech_comStatusnew => scheduled
2020-05-12 07:30hgbotCheckin
2020-05-12 07:30hgbotNote Added: 0119746
2020-05-12 07:30hgbotStatusscheduled => resolved
2020-05-12 07:30hgbotResolutionopen => fixed
2020-05-12 07:30hgbotFixed in SCM revisionhttp://code.openbravo.com/retail/backports/3.0RR20Q2/org.openbravo.retail.posterminal/rev/dc97805897dc2396892eb938cb53ad428f3c4396 [^] => http://code.openbravo.com/retail/backports/3.0RR20Q2/org.openbravo.retail.posterminal/rev/8942d2c56c6e6cbcacd825f9803694a716efb3d2 [^]
2020-05-12 09:22marvintmStatusresolved => closed
2020-05-12 09:22marvintmFixed in Version => RR20Q2

Notes
(0119613)
hgbot   
2020-05-06 09:24   
Repository: retail/backports/3.0RR20Q2/org.openbravo.retail.posterminal
Changeset: dc97805897dc2396892eb938cb53ad428f3c4396
Author: Ranjith S R <ranjith <at> qualiantech.com>
Date: Wed May 06 12:53:46 2020 +0530
URL: http://code.openbravo.com/retail/backports/3.0RR20Q2/org.openbravo.retail.posterminal/rev/dc97805897dc2396892eb938cb53ad428f3c4396 [^]

Fixed issue 43834 : Modified Login UserList query to list users based on Terminal Access

* If Pref. "Filter User based on Terminal Access", users added in Terminal Access will be listed
If not enabled, either user should present in Terminal Access
or user should not present in Terminal Access
* If Pref. "Filter User based on Terminal Access", is defined,
  it will list users only which are added under POS Terminal access tab
* If Pref. "Filter User based on Terminal Access", is not defined,
  if a user defined in particular terminals in POS Terminal access,
  user will be shown only in those terminals
  If user is not defined in POS Terminal access, then it will shown for all terminals
* Same query will be used to list the list for approvals
* To Preserve Existing functionality,
  added method doFilterUserOnlyByTerminalAccessPreference without any parameter

---
M src/org/openbravo/retail/posterminal/LoginUtilsServlet.java
---
(0119745)
ranjith_qualiantech_com   
2020-05-12 07:27   
Query performance was very slow due to Terminal Access and Preference join queries
(0119746)
hgbot   
2020-05-12 07:30   
Repository: retail/backports/3.0RR20Q2/org.openbravo.retail.posterminal
Changeset: 8942d2c56c6e6cbcacd825f9803694a716efb3d2
Author: Ranjith S R <ranjith <at> qualiantech.com>
Date: Tue May 12 11:00:08 2020 +0530
URL: http://code.openbravo.com/retail/backports/3.0RR20Q2/org.openbravo.retail.posterminal/rev/8942d2c56c6e6cbcacd825f9803694a716efb3d2 [^]

Fixed issue 43834 : Updated UserList Query to improve Performance

* Updated query by changing TerminalAccess and ADPreference table
  from FullJoin to Subquery to improve perfomance

---
M src/org/openbravo/retail/posterminal/LoginUtilsServlet.java
---