Subversion Repositories SmartDukaan

package com.spice.profitmandi.dao.entity.user;

import com.spice.profitmandi.dao.enumuration.dtr.FranchiseeVisitStatus;

import com.spice.profitmandi.dao.enumuration.dtr.VisitStatus;

import javax.persistence.*;

import java.time.LocalDateTime;

import java.util.List;

import java.util.Objects;

@Entity

@Table(name = "user.my_franchisee_visit")

@NamedQueries({

		@NamedQuery(

				name = "Visit.FindAverageRatingByRbmIds",

				query = "SELECT new com.spice.profitmandi.dao.model.RbMRatingModel(v.rbmId, AVG(v.rbmRating)) " +

						"FROM FranchiseeVisit v WHERE v.rbmId IN :rbmIds GROUP BY v.rbmId"

		)

})

public class FranchiseeVisit {

	@Id

	@Column(name = "id", unique = true, updatable = false)

	@GeneratedValue(strategy = GenerationType.IDENTITY)

	private int id;

	@Column(name = "fofo_id")

	private int fofoId;

	@Column(name = "rbm_id")

	private int rbmId;

	@Column(name = "rbm_rating")

	private int rbmRating;

	@Column(name = "partner_name")

	private String partnerName;

	public String getPartnerName() {

		return partnerName;

	}

	@Transient

	private FranchiseeActivity franchiseeActivity;

	@Column(name = "schedule_timestamp")

	private LocalDateTime scheduleTimestamp;

	@Column(name = "agenda")

	private String agenda;

	@Column(name = "partner_remark")

	private String partnerRemark;

	@Column(name = "outside_visibity")

	private String outsideVisibity;

	@Column(name = "instore_visibility")

	private String instoreVisibility;

	@Column(name = "outside_stock")

	private String outsideStock;

	@Column(name = "system_knowledge")

	private String systemKnowledge;

	@Column(name = "working_device")

	private String workingDevice;

	@Column(name = "working_printer")

	private String workingPrinter;

	@Column(name = "carry_bags")

	private String carryBags;

	@Column(name = "smartdukaan_tshirt")

	private String smartdukaanTshirt;

	@Column(name = "latest_dummies")

	private String latestDummies;

	@Column(name = "investment")

	private String investment;

	@Column(name = "mtd")

	private int mtd;

	@Column(name = "status")

	@Enumerated(EnumType.STRING)

	private FranchiseeVisitStatus status;

	@Column(name = "hygiene")

	private String hygiene;

	@Column(name = "created_timestamp")

	private LocalDateTime createdTimestamp;

	@Column(name = "pending_billing")

	private int pendingBilling;

	@Column(name = "informed_about_online")

	private String informedAboutOnline;

	@Column(name = "updated_timestamp")

	private LocalDateTime updatedTimestamp;

	@Column(name = "visit_timestamp")

	private LocalDateTime visitTimestamp;

	@Transient

	private List<String> brands;

	@Column(name = "franchise_activity_id")

	private int franchiseActivityId;

	@Column(name = "created_by")

	private String createdBy;

	@Column(name = "auth_id")

	private int authId;

	@Transient

	private VisitStatus visitStatus;

	public VisitStatus getVisitStatus() {

		return visitStatus;

	}

	public void setVisitStatus(VisitStatus visitStatus) {

		this.visitStatus = visitStatus;

	}

	public LocalDateTime getScheduleTimestamp() {

		return scheduleTimestamp;

	}

	public void setScheduleTimestamp(LocalDateTime schelduleTimestamp) {

		this.scheduleTimestamp = schelduleTimestamp;

	}

	public List<String> getBrands() {

		return brands;

	}

	public void setBrands(List<String> brands) {

		this.brands = brands;

	}

	public FranchiseeVisitStatus getStatus() {

		return status;

	}

	public void setStatus(FranchiseeVisitStatus status) {

		this.status = status;

	}

	public FranchiseeActivity getFranchiseeActivity() {

		return franchiseeActivity;

	}

	public void setFranchiseeActivity(FranchiseeActivity franchiseeActivity) {

		this.franchiseeActivity = franchiseeActivity;

	}

	public int getPendingBilling() {

		return pendingBilling;

	}

	public LocalDateTime getVisitTimestamp() {

		return visitTimestamp;

	}

	public void setVisitTimestamp(LocalDateTime visitTimestamp) {

		this.visitTimestamp = visitTimestamp;

	}

	public void setPendingBilling(int pendingBilling) {

		this.pendingBilling = pendingBilling;

	}

	public String getInformedAboutOnline() {

		return informedAboutOnline;

	}

	public void setInformedAboutOnline(String informedAboutOnline) {

		this.informedAboutOnline = informedAboutOnline;

	}

	public void setPartnerName(String partnerName) {

		this.partnerName = partnerName;

	}

	public String getCreatedBy() {

		return createdBy;

	}

	public void setCreatedBy(String createdBy) {

		this.createdBy = createdBy;

	}

	public int getAuthId() {

		return authId;

	}

	public void setAuthId(int authId) {

		this.authId = authId;

	}

	public int getId() {

		return id;

	}

	public void setId(int id) {

		this.id = id;

	}

	public int getFofoId() {

		return fofoId;

	}

	public void setFofoId(int fofoId) {

		this.fofoId = fofoId;

	}

	public String getAgenda() {

		return agenda;

	}

	public void setAgenda(String agenda) {

		this.agenda = agenda;

	}

	public String getPartnerRemark() {

		return partnerRemark;

	}

	public void setPartnerRemark(String partnerRemark) {

		this.partnerRemark = partnerRemark;

	}

	public String getOutsideVisibity() {

		return outsideVisibity;

	}

	public void setOutsideVisibity(String outsideVisibity) {

		this.outsideVisibity = outsideVisibity;

	}

	public String getInstoreVisibility() {

		return instoreVisibility;

	}

	public void setInstoreVisibility(String instoreVisibility) {

		this.instoreVisibility = instoreVisibility;

	}

	public String getOutsideStock() {

		return outsideStock;

	}

	public void setOutsideStock(String outsideStock) {

		this.outsideStock = outsideStock;

	}

	public String getSystemKnowledge() {

		return systemKnowledge;

	}

	public void setSystemKnowledge(String systemKnowledge) {

		this.systemKnowledge = systemKnowledge;

	}

	public String getWorkingDevice() {

		return workingDevice;

	}

	public void setWorkingDevice(String workingDevice) {

		this.workingDevice = workingDevice;

	}

	public String getWorkingPrinter() {

		return workingPrinter;

	}

	public void setWorkingPrinter(String workingPrinter) {

		this.workingPrinter = workingPrinter;

	}

	public String getCarryBags() {

		return carryBags;

	}

	public void setCarryBags(String carryBags) {

		this.carryBags = carryBags;

	}

	public String getSmartdukaanTshirt() {

		return smartdukaanTshirt;

	}

	public void setSmartdukaanTshirt(String smartdukaanTshirt) {

		this.smartdukaanTshirt = smartdukaanTshirt;

	}

	public String getLatestDummies() {

		return latestDummies;

	}

	public void setLatestDummies(String latestDummies) {

		this.latestDummies = latestDummies;

	}

	public String getInvestment() {

		return investment;

	}

	public void setInvestment(String investment) {

		this.investment = investment;

	}

	public int getMtd() {

		return mtd;

	}

	public void setMtd(int mtd) {

		this.mtd = mtd;

	}

	public String getHygiene() {

		return hygiene;

	}

	public void setHygiene(String hygiene) {

		this.hygiene = hygiene;

	}

	public LocalDateTime getCreatedTimestamp() {

		return createdTimestamp;

	}

	public void setCreatedTimestamp(LocalDateTime createdTimestamp) {

		this.createdTimestamp = createdTimestamp;

	}

	public LocalDateTime getUpdatedTimestamp() {

		return updatedTimestamp;

	}

	public void setUpdatedTimestamp(LocalDateTime updatedTimestamp) {

		this.updatedTimestamp = updatedTimestamp;

	}

	public int getFranchiseActivityId() {

		return franchiseActivityId;

	}

	public void setFranchiseActivityId(int franchiseActivityId) {

		this.franchiseActivityId = franchiseActivityId;

	}

	public int getRbmId() {

		return rbmId;

	}

	public void setRbmId(int rbmId) {

		this.rbmId = rbmId;

	}

	public int getRbmRating() {

		return rbmRating;

	}

	public void setRbmRating(int rbmRating) {

		this.rbmRating = rbmRating;

	}

	@Override

	public boolean equals(Object o) {

		if (this == o) return true;

		if (o == null || getClass() != o.getClass()) return false;

		FranchiseeVisit that = (FranchiseeVisit) o;

		return id == that.id && fofoId == that.fofoId && rbmId == that.rbmId && rbmRating == that.rbmRating && mtd == that.mtd && pendingBilling == that.pendingBilling && franchiseActivityId == that.franchiseActivityId && authId == that.authId && Objects.equals(partnerName, that.partnerName) && Objects.equals(franchiseeActivity, that.franchiseeActivity) && Objects.equals(scheduleTimestamp, that.scheduleTimestamp) && Objects.equals(agenda, that.agenda) && Objects.equals(partnerRemark, that.partnerRemark) && Objects.equals(outsideVisibity, that.outsideVisibity) && Objects.equals(instoreVisibility, that.instoreVisibility) && Objects.equals(outsideStock, that.outsideStock) && Objects.equals(systemKnowledge, that.systemKnowledge) && Objects.equals(workingDevice, that.workingDevice) && Objects.equals(workingPrinter, that.workingPrinter) && Objects.equals(carryBags, that.carryBags) && Objects.equals(smartdukaanTshirt, that.smartdukaanTshirt) && Objects.equals(latestDummies, that.latestDummies) && Objects.equals(investment, that.investment) && status == that.status && Objects.equals(hygiene, that.hygiene) && Objects.equals(createdTimestamp, that.createdTimestamp) && Objects.equals(informedAboutOnline, that.informedAboutOnline) && Objects.equals(updatedTimestamp, that.updatedTimestamp) && Objects.equals(visitTimestamp, that.visitTimestamp) && Objects.equals(brands, that.brands) && Objects.equals(createdBy, that.createdBy) && visitStatus == that.visitStatus;

	}

	@Override

	public int hashCode() {

		return Objects.hash(id, fofoId, rbmId, rbmRating, partnerName, franchiseeActivity, scheduleTimestamp, agenda, partnerRemark, outsideVisibity, instoreVisibility, outsideStock, systemKnowledge, workingDevice, workingPrinter, carryBags, smartdukaanTshirt, latestDummies, investment, mtd, status, hygiene, createdTimestamp, pendingBilling, informedAboutOnline, updatedTimestamp, visitTimestamp, brands, franchiseActivityId, createdBy, authId, visitStatus);

	}

	@Override

	public String toString() {

		return "FranchiseeVisit{" +

				"id=" + id +

				", fofoId=" + fofoId +

				", rbmId=" + rbmId +

				", rbmRating=" + rbmRating +

				", partnerName='" + partnerName + '\'' +

				", franchiseeActivity=" + franchiseeActivity +

				", scheduleTimestamp=" + scheduleTimestamp +

				", agenda='" + agenda + '\'' +

				", partnerRemark='" + partnerRemark + '\'' +

				", outsideVisibity='" + outsideVisibity + '\'' +

				", instoreVisibility='" + instoreVisibility + '\'' +

				", outsideStock='" + outsideStock + '\'' +

				", systemKnowledge='" + systemKnowledge + '\'' +

				", workingDevice='" + workingDevice + '\'' +

				", workingPrinter='" + workingPrinter + '\'' +

				", carryBags='" + carryBags + '\'' +

				", smartdukaanTshirt='" + smartdukaanTshirt + '\'' +

				", latestDummies='" + latestDummies + '\'' +

				", investment='" + investment + '\'' +

				", mtd=" + mtd +

				", status=" + status +

				", hygiene='" + hygiene + '\'' +

				", createdTimestamp=" + createdTimestamp +

				", pendingBilling=" + pendingBilling +

				", informedAboutOnline='" + informedAboutOnline + '\'' +

				", updatedTimestamp=" + updatedTimestamp +

				", visitTimestamp=" + visitTimestamp +

				", brands=" + brands +

				", franchiseActivityId=" + franchiseActivityId +

				", createdBy='" + createdBy + '\'' +

				", authId=" + authId +

				", visitStatus=" + visitStatus +

				'}';

	}

}