Produced by Araxis Merge on 4/2/2019 1:06:54 PM Central Daylight Time. See www.araxis.com for information about Merge. This report uses XHTML and CSS2, and is best viewed with a modern standards-compliant browser. For optimum results when printing this report, use landscape orientation and enable printing of background images and colours in your browser.
# | Location | File | Last Modified |
---|---|---|---|
1 | C:\AraxisMergeCompare\Pri_un\ARS_Backend\ars_app\src\main\java\gov\va\med\ars\dao\ars | IArsUserRepository.java | Wed Mar 27 19:22:39 2019 UTC |
2 | C:\AraxisMergeCompare\Pri_re\ARS_Backend\ars_app\src\main\java\gov\va\med\ars\dao\ars | IArsUserRepository.java | Thu Mar 28 17:50:42 2019 UTC |
Description | Between Files 1 and 2 |
|
---|---|---|
Text Blocks | Lines | |
Unchanged | 2 | 142 |
Changed | 1 | 2 |
Inserted | 0 | 0 |
Removed | 0 | 0 |
Whitespace | |
---|---|
Character case | Differences in character case are significant |
Line endings | Differences in line endings (CR and LF characters) are ignored |
CR/LF characters | Not shown in the comparison detail |
No regular expressions were active.
1 | ||
2 | package go v.va.med.a rs.dao.ars ; | |
3 | ||
4 | import jav a.util.Lis t; | |
5 | ||
6 | import org .springfra mework.dat a.domain.P age; | |
7 | import org .springfra mework.dat a.domain.P ageRequest ; | |
8 | import org .springfra mework.dat a.domain.P ageable; | |
9 | import org .springfra mework.dat a.jpa.repo sitory.Jpa Specificat ionExecuto r; | |
10 | import org .springfra mework.dat a.jpa.repo sitory.Mod ifying; | |
11 | import org .springfra mework.dat a.jpa.repo sitory.Que ry; | |
12 | import org .springfra mework.dat a.reposito ry.CrudRep ository; | |
13 | import org .springfra mework.dat a.reposito ry.PagingA ndSortingR epository; | |
14 | import org .springfra mework.dat a.reposito ry.query.P aram; | |
15 | import org .springfra mework.ste reotype.Re pository; | |
16 | import org .springfra mework.tra nsaction.a nnotation. Transactio nal; | |
17 | ||
18 | import gov .va.med.do main.ars.A rsUser; | |
19 | import gov .va.med.do main.ars.A rsUserRole Usages; | |
20 | ||
21 | @Transacti onal | |
22 | @Repositor y | |
23 | public int erface IAr sUserRepos itory exte nds CrudRe pository<A rsUser, Lo ng>, JpaSp ecificatio nExecutor< ArsUser> { | |
24 | ||
25 | /* * | |
26 | * Get ArsUs er by User Name | |
27 | * | |
28 | * @param us erName | |
29 | * @return | |
30 | * / | |
31 | ||
32 | /* | |
33 | * SQL versi on select * from ars _user a le ft join ar s_user_rol e_usages b on | |
34 | * a.ars_use r_id=b.ars _user_id J OIN ars_Ro le c on b. ARS_ROLE_I D= | |
35 | * c.ARS_RO LE_ID wher e a.user_N ame = ' DN S RSADMIN' a nd upper(a .enabled) = | |
36 | * 'Y'; | |
37 | * / | |
38 | @Q uery("SELE CT u FROM aarsUser u JOIN FETC H u.arsUse rRoleUsage ses r JOIN FETCH r.a rsRole a W HERE UPPER (u.userNam e) = UPPER (:username ) ") | |
39 | Ar sUser find ByArsUserN ame(@Param ("username ") String userName); | |
40 | ||
41 | @Q uery("sele ct userNam e from aar sUser") | |
42 | Li st<String> getAllUse rs(); | |
43 | ||
44 | Ar sUser find ByUserName IgnoreCase (String us erName); | |
45 | ||
46 | @Q uery("sele ct distinc t a from a arsUser a JOIN FETCH a.arsUser RoleUsages es au WHER E UPPER(a. userName) = UPPER(:u serName) A ND au.id.a rsRoleId I N :roleIds ") | |
47 | Ar sUser find ByUserName (@Param("u serName") String use rName, @Pa ram("roleI ds") List< Long> role Ids); | |
48 | ||
49 | Ar sUser find ByArsUserI d(Long use dId); | |
50 | ||
51 | @Q uery("SELE CT CASE WH EN COUNT(a ) > 0 THEN true ELSE false END FROM aars User a WHE RE UPPER(a .userName) = UPPER(: userName)" ) | |
52 | bo olean exis tsByUserNa me(@Param( "userName" ) String u serName); | |
53 | ||
54 | // ArsUser fi ndByUserNa meContaini ngIgnoreCa se(String userName); | |
55 | ||
56 | @Q uery("SELE CT u FROM aarsUser u JOIN FETC H u.arsUse rRoleUsage ses r JOIN FETCH r.a rsRole a W HERE u.ars UserId = : userid ") | |
57 | Ar sUser find ByAppUserI dByUserRol eUsages(@P aram("user id") long userid); | |
58 | ||
59 | @Q uery("SELE CT u FROM aarsUser u JOIN FETC H u.arsUse rRoleUsage ses r JOIN FETCH r.a rsRole a W HERE UPPER (u.userNam e) = UPPER (:userName ) and a.sy stem = :sy stem") | |
60 | Ar sUser find ByUserName AndSystem( @Param("us erName") S tring user Name, @Par am("system ") String system); | |
61 | ||
62 | /* @Q uery("SELE CT u FROM aarsUser u JOIN FETC H u.arsUse rRoleUsage ses r WHER E u.arsUse rId = :use rName and r.arsRole. roleName < > :roleNam e") | |
63 | Ar sUser find ByUserName WithActive Roles(@Par am("userNa me") Strin g userName , @Param(" roleName") String ro leName);*/ | |
64 | ||
65 | /* @Query(val ue = "sele ct distinc t u from a arsUser u JOIN FETCH u.arsUser RoleUsages es r JOIN FETCH r.ar sRole a wh ere NOT r. id.arsUser Id IN (sel ect distin ct ar.id.a rsUserId f rom aarsUs erRoleUsag es ar wher e ar.id.ar sRoleId IN (select a rr.arsRole Id from aa rsRole arr where arr .roleName like :syst emSpecific InactiveRo le)) and a .system = :system ", | |
66 | countQ uery = "se lect count (aru) from aarsUser aru where aru in (se lect disti nct u from aarsUser u JOIN u.a rsUserRole Usageses r JOIN r.ar sRole a wh ere NOT r. id.arsUser Id IN (sel ect distin ct ar.id.a rsUserId f rom aarsUs erRoleUsag es ar wher e ar.id.ar sRoleId IN (select a rr.arsRole Id from aa rsRole arr where arr .roleName like :syst emSpecific InactiveRo le)) and a .system = :system ) ") | |
67 | Pa ge<ArsUser > findArsU sersWithRo leIdWithOu tInActiveU sers(@Para m("systemS pecificIna ctiveRole" ) String s ystemSpeci ficInactiv eRole, @Pa ram("syste m") String system, P ageable pa geRequest) ; | |
68 | ||
69 | @Q uery(value = "select distinct u from aar sUser u JO IN FETCH u .arsUserRo leUsageses r JOIN FE TCH r.arsR ole a wher e a.system = :system ", | |
70 | countQ uery = "se lect count (aru) from aarsUser aru where aru in (se lect disti nct u from aarsUser u JOIN u.a rsUserRole Usageses r JOIN r.ar sRole a wh ere a.syst em = :syst em ) ") | |
71 | Pa ge<ArsUser > findArsU sersWithRo leIdWithIn ActiveUser s(@Param(" system") S tring syst em, Pageab le pageabl e);*/ | |
72 | } |
Araxis Merge (but not the data content of this report) is Copyright © 1993-2016 Araxis Ltd (www.araxis.com). All rights reserved.