Advertisement
Guest User

Object to View

a guest
Oct 18th, 2017
147
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.54 KB | None | 0 0
  1. @Query(nativeQuery = true, value = "select e.job_number, p.tag_number, e.drawing_number, p.part_number, "
  2. + "eoa.operation_order, peoa.name, peoa.status, peoa.comment, peoa.last_updated_by, "
  3. + "peoa.last_updated_date, peoa.revtype "
  4. + "from brs.events e "
  5. + "join brs.parts p on e.id = p.event_id "
  6. + "join brs.event_operations_audit eoa on eoa.event_id = e.id "
  7. + "join brs.part_event_operations_audit peoa on peoa.part_id = p.id and peoa.event_operation_id = eoa.id "
  8. + "where e.id = :eventId "
  9. + "and e.is_received = true "
  10. + "and e.is_workscope_reviewed = true "
  11. + "order by p.tag_number, eoa.operation_order, peoa.last_updated_date ")
  12. Set<Object> getJobPartRecentActivityData(@Param("eventId")Long eventId);
  13. -------
  14.  
  15. View
  16. import java.util.Date;
  17.  
  18. public class JobPartRecentActivityView {
  19.  
  20. private Long jobNumber;
  21. private Long actionId;
  22. private Long tagNumber;
  23. private String serialNumber;
  24. private String partNumber;
  25. private Long operationSequence;
  26. private String operationCode;
  27. private String operationName;
  28. private String partStatus;
  29. private String comments;
  30. private String updatedBy;
  31. private Date updatedDate;
  32. private Long revType;
  33.  
  34. public Long getJobNumber() {
  35. return jobNumber;
  36. }
  37.  
  38. public void setJobNumber(Long jobNumber) {
  39. this.jobNumber = jobNumber;
  40. }
  41.  
  42. public Long getActionId() {
  43. return actionId;
  44. }
  45.  
  46. public void setActionId(Long actionId) {
  47. this.actionId = actionId;
  48. }
  49.  
  50. public Long getTagNumber() {
  51. return tagNumber;
  52. }
  53.  
  54. public void setTagNumber(Long tagNumber) {
  55. this.tagNumber = tagNumber;
  56. }
  57.  
  58. public String getSerialNumber() {
  59. return serialNumber;
  60. }
  61.  
  62. public void setSerialNumber(String serialNumber) {
  63. this.serialNumber = serialNumber;
  64. }
  65.  
  66. public String getPartNumber() {
  67. return partNumber;
  68. }
  69.  
  70. public void setPartNumber(String partNumber) {
  71. this.partNumber = partNumber;
  72. }
  73.  
  74. public Long getOperationSequence() {
  75. return operationSequence;
  76. }
  77.  
  78. public void setOperationSequence(Long operationSequence) {
  79. this.operationSequence = operationSequence;
  80. }
  81.  
  82. public String getOperationCode() {
  83. return operationCode;
  84. }
  85.  
  86. public void setOperationCode(String operationCode) {
  87. this.operationCode = operationCode;
  88. }
  89.  
  90. public String getOperationName() {
  91. return operationName;
  92. }
  93.  
  94. public void setOperationName(String operationName) {
  95. this.operationName = operationName;
  96. }
  97.  
  98. public String getPartStatus() {
  99. return partStatus;
  100. }
  101.  
  102. public void setPartStatus(String partStatus) {
  103. this.partStatus = partStatus;
  104. }
  105.  
  106. public String getComments() {
  107. return comments;
  108. }
  109.  
  110. public void setComments(String comments) {
  111. this.comments = comments;
  112. }
  113.  
  114. public String getUpdatedBy() {
  115. return updatedBy;
  116. }
  117.  
  118. public void setUpdatedBy(String updatedBy) {
  119. this.updatedBy = updatedBy;
  120. }
  121.  
  122. public Date getUpdatedDate() {
  123. return updatedDate;
  124. }
  125.  
  126. public void setUpdatedDate(Date updatedDate) {
  127. this.updatedDate = updatedDate;
  128. }
  129.  
  130. public Long getRevType() {
  131. return revType;
  132. }
  133.  
  134. public void setRevType(Long revType) {
  135. this.revType = revType;
  136. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement