Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0037794
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Retail Modules] Web POSminoralways2018-01-31 16:142018-03-23 10:46
ReporterjonibcView Statuspublic 
Assigned Torqueralta 
PrioritynormalResolutionfixedFixed in VersionRR18Q2
StatusclosedFix in branchFixed in SCM revisiona2c321d7b4f4
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Tomarvintm
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0037794: It is possible to create duplicate pos terminal access

DescriptionIt is possible to create duplicated entries in Window 'User' --> Tab 'POS Terminal access'.

Steps To ReproduceLog into backend:

1- Open 'User' window, select a user record, go to Tab 'POS Terminal Access'
2- Create a record for any POS Terminal.
3- Create another record for the same POS Terminal.
4- Check that no error is raised.
Proposed SolutionAdd a constraint to avoid add duplicated entries in this table.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 0038088 closedrqueralta API Change: A new check constraint needs to be added to obpos_userterminal_access 

-  Notes
(0103171)
hgbot (developer)
2018-03-12 20:56

Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: a2c321d7b4f442702a8e29bd2b596cbd903cde8f
Author: Rafael Queralta Pozo <rqueralta <at> nauta.cu>
Date: Fri Mar 09 16:03:03 2018 -0500
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/a2c321d7b4f442702a8e29bd2b596cbd903cde8f [^]

Fixed issue 37794: It is possible to create duplicate pos terminal access

---
M src-db/database/model/tables/OBPOS_USERTERMINAL_ACCESS.xml
A build/classes/org/openbravo/retail/posterminal/modulescript/FixDataIssue37794.class
A build/classes/org/openbravo/retail/posterminal/modulescript/FixDataIssue37794Data.class
A src-util/modulescript/src/org/openbravo/retail/posterminal/modulescript/FixDataIssue37794.java
A src-util/modulescript/src/org/openbravo/retail/posterminal/modulescript/FixDataIssue37794_Data.xsql
A src-util/modulescript/src/src/org/openbravo/retail/posterminal/modulescript/FixDataIssue37794Data.java
---
(0103338)
marvintm (manager)
2018-03-19 09:16

Modulescript logic is correct, but the version that should be checked should be 3500, not 3300. Otherwise, the modulescript will not be executed in 18Q1, and the constraint will therefore fail if data is not correct.
(0103349)
hgbot (developer)
2018-03-19 16:18

Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: e879bc101b60dd1e0a43a8c7beaf7c100ca02fdf
Author: Rafael Queralta Pozo <rqueralta <at> nauta.cu>
Date: Mon Mar 19 11:03:06 2018 -0400
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/e879bc101b60dd1e0a43a8c7beaf7c100ca02fdf [^]

Related to issue 37794: It is possible to create duplicate pos terminal access

---
M build/classes/org/openbravo/retail/posterminal/modulescript/FixDataIssue37794.class
M src-util/modulescript/src/org/openbravo/retail/posterminal/modulescript/FixDataIssue37794.java
---

- Issue History
Date Modified Username Field Change
2018-01-31 16:14 jonibc New Issue
2018-01-31 16:14 jonibc Assigned To => Retail
2018-01-31 16:14 jonibc Triggers an Emergency Pack => No
2018-01-31 16:24 marvintm Resolution time => 1519167600
2018-01-31 16:25 jonibc Issue Monitored: jonibc
2018-01-31 22:53 rqueralta Assigned To Retail => rqueralta
2018-01-31 22:53 rqueralta Status new => scheduled
2018-03-08 18:34 marvintm Resolution time 1519167600 => 1521068400
2018-03-09 09:35 marvintm Relationship added related to 0038088
2018-03-12 20:56 hgbot Checkin
2018-03-12 20:56 hgbot Note Added: 0103171
2018-03-12 20:56 hgbot Status scheduled => resolved
2018-03-12 20:56 hgbot Resolution open => fixed
2018-03-12 20:56 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/a2c321d7b4f442702a8e29bd2b596cbd903cde8f [^]
2018-03-19 09:16 marvintm Note Added: 0103338
2018-03-19 09:16 marvintm Status resolved => new
2018-03-19 09:16 marvintm Resolution fixed => open
2018-03-19 16:18 hgbot Checkin
2018-03-19 16:18 hgbot Note Added: 0103349
2018-03-19 17:46 rqueralta Status new => scheduled
2018-03-19 17:46 rqueralta Status scheduled => resolved
2018-03-19 17:46 rqueralta Resolution open => fixed
2018-03-23 10:46 marvintm Review Assigned To => marvintm
2018-03-23 10:46 marvintm Status resolved => closed
2018-03-23 10:46 marvintm Fixed in Version => RR18Q2


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker