Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- @Query(nativeQuery = true, value = "select e.job_number, p.tag_number, e.drawing_number, p.part_number, "
- + "eoa.operation_order, peoa.name, peoa.status, peoa.comment, peoa.last_updated_by, "
- + "peoa.last_updated_date, peoa.revtype "
- + "from brs.events e "
- + "join brs.parts p on e.id = p.event_id "
- + "join brs.event_operations_audit eoa on eoa.event_id = e.id "
- + "join brs.part_event_operations_audit peoa on peoa.part_id = p.id and peoa.event_operation_id = eoa.id "
- + "where e.id = :eventId "
- + "and e.is_received = true "
- + "and e.is_workscope_reviewed = true "
- + "order by p.tag_number, eoa.operation_order, peoa.last_updated_date ")
- Set<Object> getJobPartRecentActivityData(@Param("eventId")Long eventId);
- -------
- View
- import java.util.Date;
- public class JobPartRecentActivityView {
- private Long jobNumber;
- private Long actionId;
- private Long tagNumber;
- private String serialNumber;
- private String partNumber;
- private Long operationSequence;
- private String operationCode;
- private String operationName;
- private String partStatus;
- private String comments;
- private String updatedBy;
- private Date updatedDate;
- private Long revType;
- public Long getJobNumber() {
- return jobNumber;
- }
- public void setJobNumber(Long jobNumber) {
- this.jobNumber = jobNumber;
- }
- public Long getActionId() {
- return actionId;
- }
- public void setActionId(Long actionId) {
- this.actionId = actionId;
- }
- public Long getTagNumber() {
- return tagNumber;
- }
- public void setTagNumber(Long tagNumber) {
- this.tagNumber = tagNumber;
- }
- public String getSerialNumber() {
- return serialNumber;
- }
- public void setSerialNumber(String serialNumber) {
- this.serialNumber = serialNumber;
- }
- public String getPartNumber() {
- return partNumber;
- }
- public void setPartNumber(String partNumber) {
- this.partNumber = partNumber;
- }
- public Long getOperationSequence() {
- return operationSequence;
- }
- public void setOperationSequence(Long operationSequence) {
- this.operationSequence = operationSequence;
- }
- public String getOperationCode() {
- return operationCode;
- }
- public void setOperationCode(String operationCode) {
- this.operationCode = operationCode;
- }
- public String getOperationName() {
- return operationName;
- }
- public void setOperationName(String operationName) {
- this.operationName = operationName;
- }
- public String getPartStatus() {
- return partStatus;
- }
- public void setPartStatus(String partStatus) {
- this.partStatus = partStatus;
- }
- public String getComments() {
- return comments;
- }
- public void setComments(String comments) {
- this.comments = comments;
- }
- public String getUpdatedBy() {
- return updatedBy;
- }
- public void setUpdatedBy(String updatedBy) {
- this.updatedBy = updatedBy;
- }
- public Date getUpdatedDate() {
- return updatedDate;
- }
- public void setUpdatedDate(Date updatedDate) {
- this.updatedDate = updatedDate;
- }
- public Long getRevType() {
- return revType;
- }
- public void setRevType(Long revType) {
- this.revType = revType;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement