Subversion Repositories SmartDukaan

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

import javax.persistence.Column;

import javax.persistence.Entity;

import javax.persistence.GeneratedValue;

import javax.persistence.GenerationType;

import javax.persistence.Id;

import javax.persistence.Table;

import java.time.LocalDateTime;

import java.util.Objects;

/**

 * Daily target snapshot for one Sales-hierarchy person (ASM / CM / DM / BM /

 * RSM / NSM) at one warehouse, split by movement class — mirrors

 * {@link RbmTargets} but rolled up to a manager. Written each day by the

 * cron chain: {@code pushRbmTargets} → {@code pushSalesTargets}. The Sales

 * daily target is the sum of persisted RBM daily targets for the RBMs in

 * that manager's downline for the same warehouse.

 *

 * <p>Table DDL (run once against the target DB):

 * <pre>

 * CREATE TABLE inventory.sales_targets (

 *   id                 INT NOT NULL AUTO_INCREMENT PRIMARY KEY,

 *   sales_auth_id      INT NOT NULL,

 *   sales_name         VARCHAR(128),

 *   role               VARCHAR(8),

 *   warehouse_id       INT NOT NULL,

 *   hid_target         FLOAT DEFAULT 0,

 *   fastmoving_target  FLOAT DEFAULT 0,

 *   running_target     FLOAT DEFAULT 0,

 *   slowmoving_target  FLOAT DEFAULT 0,

 *   other_target       FLOAT DEFAULT 0,

 *   create_timestamp   DATETIME NOT NULL,

 *   KEY idx_sales_created (sales_auth_id, create_timestamp),

 *   KEY idx_created (create_timestamp)

 * );

 * </pre>

 */

@Entity

@Table(name = "inventory.sales_targets")

public class SalesTargets {

    @Id

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

    @GeneratedValue(strategy = GenerationType.IDENTITY)

    private int id;

    @Column(name = "sales_auth_id")

    private int salesAuthId;

    @Column(name = "sales_name")

    private String salesName;

    @Column(name = "role")

    private String role;

    @Column(name = "warehouse_id")

    private int warehouseId;

    @Column(name = "hid_target")

    private float hidTarget;

    @Column(name = "fastmoving_target")

    private float fastMovingTarget;

    @Column(name = "running_target")

    private float runningTarget;

    @Column(name = "slowmoving_target")

    private float slowMovingTarget;

    @Column(name = "other_target")

    private float otherTarget;

    @Column(name = "create_timestamp")

    private LocalDateTime createTimestamp;

    public int getId() { return id; }

    public void setId(int id) { this.id = id; }

    public int getSalesAuthId() { return salesAuthId; }

    public void setSalesAuthId(int salesAuthId) { this.salesAuthId = salesAuthId; }

    public String getSalesName() { return salesName; }

    public void setSalesName(String salesName) { this.salesName = salesName; }

    public String getRole() { return role; }

    public void setRole(String role) { this.role = role; }

    public int getWarehouseId() { return warehouseId; }

    public void setWarehouseId(int warehouseId) { this.warehouseId = warehouseId; }

    public float getHidTarget() { return hidTarget; }

    public void setHidTarget(float hidTarget) { this.hidTarget = hidTarget; }

    public float getFastMovingTarget() { return fastMovingTarget; }

    public void setFastMovingTarget(float fastMovingTarget) { this.fastMovingTarget = fastMovingTarget; }

    public float getRunningTarget() { return runningTarget; }

    public void setRunningTarget(float runningTarget) { this.runningTarget = runningTarget; }

    public float getSlowMovingTarget() { return slowMovingTarget; }

    public void setSlowMovingTarget(float slowMovingTarget) { this.slowMovingTarget = slowMovingTarget; }

    public float getOtherTarget() { return otherTarget; }

    public void setOtherTarget(float otherTarget) { this.otherTarget = otherTarget; }

    public LocalDateTime getCreateTimestamp() { return createTimestamp; }

    public void setCreateTimestamp(LocalDateTime createTimestamp) { this.createTimestamp = createTimestamp; }

    @Override

    public boolean equals(Object o) {

        if (this == o) return true;

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

        SalesTargets that = (SalesTargets) o;

        return id == that.id && salesAuthId == that.salesAuthId && warehouseId == that.warehouseId

                && Float.compare(hidTarget, that.hidTarget) == 0

                && Float.compare(fastMovingTarget, that.fastMovingTarget) == 0

                && Float.compare(runningTarget, that.runningTarget) == 0

                && Float.compare(slowMovingTarget, that.slowMovingTarget) == 0

                && Float.compare(otherTarget, that.otherTarget) == 0

                && Objects.equals(salesName, that.salesName) && Objects.equals(role, that.role)

                && Objects.equals(createTimestamp, that.createTimestamp);

    }

    @Override

    public int hashCode() {

        return Objects.hash(id, salesAuthId, salesName, role, warehouseId, hidTarget, fastMovingTarget,

                runningTarget, slowMovingTarget, otherTarget, createTimestamp);

    }

    @Override

    public String toString() {

        return "SalesTargets{id=" + id + ", salesAuthId=" + salesAuthId + ", role='" + role

                + "', warehouseId=" + warehouseId + ", hid=" + hidTarget + ", fast=" + fastMovingTarget

                + ", run=" + runningTarget + ", slow=" + slowMovingTarget + ", other=" + otherTarget

                + ", ts=" + createTimestamp + "}";

    }

}