Revision 47245
Added by Panagiotis Kanakakis almost 7 years ago
modules/uoa-goldoa-service/branches/hibernate/src/test/java/unitest/ProfileTest.java | ||
---|---|---|
183 | 183 |
} |
184 | 184 |
} |
185 | 185 |
|
186 |
@Test |
|
187 |
@Transactional |
|
188 |
@Rollback(true) |
|
189 |
public void getPublisherContacts(){ |
|
190 |
List<Object> rs = null; |
|
191 |
|
|
192 |
rs = sm.search(SearchManager.TYPE.PUBLISHER,"EDP Sciences"); |
|
193 |
Publisher pub = null; |
|
194 |
pub = (Publisher)rs.get(0); |
|
195 |
|
|
196 |
for(User contact:pub.getContacts()) |
|
197 |
System.out.println(contact.getEmail()); |
|
198 |
|
|
199 |
} |
|
200 |
|
|
186 | 201 |
} |
modules/uoa-goldoa-service/branches/hibernate/src/test/java/unitest/ManageRequestsTest.java | ||
---|---|---|
189 | 189 |
RequestPage rs = rm.getRequests(null, null, RequestSort.USER, RequestSortOrder.DESCENDING, null, null, null, 0, 9); |
190 | 190 |
|
191 | 191 |
List<Request> rss = rs.getRequests(); |
192 |
for(Request r:rss) |
|
192 |
for(Request r:rss) { |
|
193 |
System.out.println(r.getStatus() + "/" + r.getStatus().getValue()); |
|
193 | 194 |
System.out.println(r.getId()); |
195 |
} |
|
194 | 196 |
} |
195 | 197 |
|
196 | 198 |
@Test |
197 | 199 |
@Transactional |
198 | 200 |
@Rollback(true) |
199 | 201 |
public void updateRequest() throws PersonManagerException { |
200 |
Request r = rm.getById("20170509-1495");
|
|
202 |
Request r = rm.getById("20170512-1507");
|
|
201 | 203 |
|
202 | 204 |
List<Object> res = sm.search(SearchManager.TYPE.FUNDER, "8020 Promotion Foundation"); |
203 | 205 |
Funder f = (Funder)res.get(0); |
... | ... | |
210 | 212 |
rc.setPercentage(50); |
211 | 213 |
|
212 | 214 |
r.getRequestCoFunders().add(rc); |
215 |
r.setPublisher((Publisher)sm.search(SearchManager.TYPE.PUBLISHER, "EDP Sciences-2").get(0)); |
|
213 | 216 |
|
214 | 217 |
r.setApcPaid((float) 10000); |
215 | 218 |
rm.saveRequest(r); |
modules/uoa-goldoa-service/branches/hibernate/src/main/java/eu/dnetlib/goldoa/service/PublisherManagerImpl.java | ||
---|---|---|
80 | 80 |
return publisher; |
81 | 81 |
} |
82 | 82 |
|
83 |
@Override |
|
84 |
public BigInteger getBankId() { |
|
85 |
return publisherDAO.getBankId(); |
|
86 |
} |
|
87 |
|
|
83 | 88 |
} |
84 | 89 |
|
modules/uoa-goldoa-service/branches/hibernate/src/main/java/eu/dnetlib/goldoa/service/dao/PublisherDAO.java | ||
---|---|---|
32 | 32 |
|
33 | 33 |
public Publisher savePublisher(Publisher publisher) { |
34 | 34 |
|
35 |
if(publisher.getBankAccount() == null) |
|
36 |
publisher.setBankAccount(new BankAccount(null,getBankAddress().toString(),null,null,null)); |
|
35 |
if(publisher.getBankAccount() == null) { |
|
36 |
BigInteger id = getBankId(); |
|
37 |
publisher.setBankAccount(new BankAccount(id,null, getBankAddress().toString(), null, null, null)); |
|
38 |
} |
|
37 | 39 |
|
38 | 40 |
Publisher p = getPublisher(publisher.getId()); |
39 | 41 |
Publisher publisher_merged = null; |
... | ... | |
51 | 53 |
|
52 | 54 |
} |
53 | 55 |
|
56 |
public BigInteger getBankId() { |
|
57 |
return (BigInteger) getSession().createSQLQuery("select nextval('bank_id_seq') as id").list().get(0); |
|
58 |
|
|
59 |
} |
|
60 |
|
|
54 | 61 |
@SuppressWarnings("unchecked") |
55 | 62 |
public Publisher getPublisherByName(String name) { |
56 | 63 |
List<Publisher> rs = (List<Publisher>) createEntityCriteria() |
modules/uoa-goldoa-service/branches/hibernate/src/main/java/eu/dnetlib/goldoa/service/dao/UserDAO.java | ||
---|---|---|
14 | 14 |
import org.springframework.stereotype.Repository; |
15 | 15 |
|
16 | 16 |
import javax.persistence.Query; |
17 |
import java.math.BigInteger; |
|
17 | 18 |
import java.sql.Timestamp; |
18 | 19 |
import java.util.ArrayList; |
19 | 20 |
import java.util.List; |
... | ... | |
66 | 67 |
acc_action.setToken(token); |
67 | 68 |
acc_action.setDate(new Timestamp(System.currentTimeMillis())); |
68 | 69 |
acc_action.setExpires(new Timestamp(System.currentTimeMillis() + 1000L * 60L * 60L * 24L * tokenTTL)); |
70 |
BigInteger id = (BigInteger) getSession().createSQLQuery("select nextval('account_action_seq') as id").list().get(0); |
|
71 |
acc_action.setId(id); |
|
69 | 72 |
getSession().persist(acc_action); |
70 | 73 |
} |
71 | 74 |
|
modules/uoa-goldoa-service/branches/hibernate/src/main/java/eu/dnetlib/goldoa/service/PublicationManagerImpl.java | ||
---|---|---|
15 | 15 |
import org.springframework.transaction.annotation.Transactional; |
16 | 16 |
|
17 | 17 |
import java.io.InputStream; |
18 |
import java.math.BigInteger; |
|
18 | 19 |
import java.net.URL; |
19 | 20 |
import java.util.ArrayList; |
20 | 21 |
import java.util.Calendar; |
... | ... | |
147 | 148 |
publisher.setName(publisherName.textValue()); |
148 | 149 |
|
149 | 150 |
String value = publisherManager.getBankAddress().toString(); |
150 |
publisher.setBankAccount(new BankAccount(null,value, |
|
151 |
BigInteger id = publisherManager.getBankId(); |
|
152 |
publisher.setBankAccount(new BankAccount(id,null,value, |
|
151 | 153 |
null,null,null)); |
152 | 154 |
|
153 | 155 |
publisher.setId("crossref::" + DigestUtils.md5Hex(publisher.getName())); |
modules/uoa-goldoa-service/branches/hibernate/src/main/java/eu/dnetlib/goldoa/service/PublisherManager.java | ||
---|---|---|
18 | 18 |
public Publisher getPublisherByName(String s); |
19 | 19 |
|
20 | 20 |
public Publisher generateId(Publisher publisher); |
21 |
|
|
22 |
public BigInteger getBankId(); |
|
21 | 23 |
} |
modules/uoa-goldoa-service/branches/hibernate/src/main/java/eu/dnetlib/goldoa/domain/AccountAction.java | ||
---|---|---|
2 | 2 |
|
3 | 3 |
import java.io.Serializable; |
4 | 4 |
import javax.persistence.*; |
5 |
import java.math.BigInteger; |
|
5 | 6 |
import java.sql.Timestamp; |
6 | 7 |
|
7 | 8 |
|
... | ... | |
15 | 16 |
private static final long serialVersionUID = 1L; |
16 | 17 |
|
17 | 18 |
@Id |
18 |
@GeneratedValue(strategy=GenerationType.AUTO) |
|
19 | 19 |
@Column(columnDefinition = "text") |
20 |
private int id;
|
|
20 |
private BigInteger id;
|
|
21 | 21 |
|
22 | 22 |
private Timestamp date; |
23 | 23 |
|
... | ... | |
40 | 40 |
this.user = user; |
41 | 41 |
} |
42 | 42 |
|
43 |
public int getId() {
|
|
43 |
public BigInteger getId() {
|
|
44 | 44 |
return id; |
45 | 45 |
} |
46 | 46 |
|
47 |
public void setId(int id) {
|
|
47 |
public void setId(BigInteger id) {
|
|
48 | 48 |
this.id = id; |
49 | 49 |
} |
50 | 50 |
|
modules/uoa-goldoa-service/branches/hibernate/src/main/java/eu/dnetlib/goldoa/domain/BankAccount.java | ||
---|---|---|
4 | 4 |
import com.google.gwt.user.client.rpc.IsSerializable; |
5 | 5 |
|
6 | 6 |
import javax.persistence.*; |
7 |
import java.math.BigInteger; |
|
7 | 8 |
|
8 | 9 |
/** |
9 | 10 |
* Created by antleb on 5/2/15. |
... | ... | |
14 | 15 |
private static final long serialVersionUID = 1L; |
15 | 16 |
|
16 | 17 |
@Id |
17 |
@GeneratedValue(strategy= GenerationType.AUTO) |
|
18 |
private Integer id; |
|
19 |
|
|
18 |
private BigInteger id; |
|
20 | 19 |
private String bankName; |
21 | 20 |
private String bankAddress; |
22 | 21 |
private String bankCode; |
... | ... | |
26 | 25 |
public BankAccount() { |
27 | 26 |
} |
28 | 27 |
|
29 |
public BankAccount(String bankName, String bankAddress, String bankCode, String accountHolder, String iban) { |
|
28 |
public BankAccount(BigInteger id,String bankName, String bankAddress, String bankCode, String accountHolder, String iban) { |
|
29 |
this.id = id; |
|
30 | 30 |
this.bankName = bankName; |
31 | 31 |
this.bankAddress = bankAddress; |
32 | 32 |
this.bankCode = bankCode; |
... | ... | |
74 | 74 |
this.iban = iban; |
75 | 75 |
} |
76 | 76 |
|
77 |
public BigInteger getId() { |
|
78 |
return id; |
|
79 |
} |
|
80 |
|
|
81 |
public void setId(BigInteger id) { |
|
82 |
this.id = id; |
|
83 |
} |
|
77 | 84 |
} |
Also available in: Unified diff