WebSVN – SmartDukaan – Diff – /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/transaction/Order.java



 * @author ashikali
 *
 */
 
@Entity
@Table(name = "transaction.`order`", schema = "transaction")
 
@NamedQueries({ @NamedQuery(name = "Order.selectAll", query = "select o from Order o"),
		@NamedQuery(name = "Order.selectById", query = "select o from Order o where o.id= :id"),
 
 
		@NamedQuery(name = "Order.selectByTransactionId", query = "select t.id, t.createTimestamp, o.retailerAddress1, o.retailerAddress2, o.retailerCity, "
				+ "o.retailerPinCode, o.retailerState, o.shippingCost, o.statusDescription, o.invoiceNumber, o.airwayBillNumber, o.totalAmount, li.brand, li.modelName, "
				+ "li.modelNumber, li.color, li.quantity, li.unitPrice, p.id, p.name,  o.shippingTimestamp, o.status, o.promisedDeliveryTime, o.retailerName, t.status, i.catalogItemId  from Transaction t join Order o on o.transactionId = t.id "
				+ "join LineItem li on li.orderId = o.id left join Provider p on p.id = o.logisticsProviderId join Item i on i.id=li.itemId where o.transactionId = :transactionId"),
 
		@NamedQuery(name = "Order.selectItemIdTypeQuantity", query = "select new com.spice.profitmandi.dao.model.ItemIdTypeQuantity(li.itemId, i.type, li.quantity) from Order o join LineItem li on li.orderId = o.id join Item i on i.id = li.itemId where o.invoiceNumber = :invoiceNumber and o.retailerId = :retailerId"),
 
		@NamedQuery(name = "Order.selectAllBilledOrderGroupByBrand", query = "select new com.spice.profitmandi.dao.model.SecondaryOrderBillingModel(li.brand, "
				+ "sum(case when o.billingTimestamp >= :today then CAST(o.totalAmount  AS int) else 0 end),"
				+ "sum(case when o.billingTimestamp >= :threedays  and o.billingTimestamp <= :endDate  then CAST(o.totalAmount  AS int) else 0 end),"
				+ "sum(case when concat(year(o.billingTimestamp ), month(o.billingTimestamp ))= :mtd  then CAST(o.totalAmount AS int) else 0 end),"
				+ "sum(case when o.billingTimestamp between  :lmtdStartDate and :lmtdEndDate  then CAST(o.totalAmount  AS int) else 0 end),"
				+ "	sum(case when o.billingTimestamp >= :today then li.quantity else 0 end),"
				+ "	sum(case when o.billingTimestamp >= :threedays and o.billingTimestamp <= :endDate then li.quantity else 0 end),"
				+ " sum(case when concat(year(o.billingTimestamp), month(o.billingTimestamp))= :mtd  then li.quantity else 0 end),"
				+ "	sum(case when o.billingTimestamp between  :lmtdStartDate and :lmtdEndDate then li.quantity else 0 end))"
				+ "	 from Order o join LineItem li on o.id = li.orderId where o.billingTimestamp is not null"
				+ "	and o.billingTimestamp >= :lmtdStartDate and o.warehouseId in :warehouseId group by li.brand")
 
})
public class Order implements Serializable {
 
	private static final long serialVersionUID = 1L;
 
	public Order() {
	}
 
	@Id
	@Column(name = "id", unique = true, updatable = false)
	@GeneratedValue(strategy = GenerationType.IDENTITY)
	private Integer id;
 
	@Column(name = "warehouse_id")
	private Integer warehouseId;
 
	@Column(name = "seller_id")
	private Integer sellerId;
 
	@Column(name = "warehouse_address_id")
	private Integer warehouseAddressId;
 
	@Column(name = "logistics_provider_id")
	private Integer logisticsProviderId;
 
	@Column(name = "airwaybill_no", length = 50)
	private String airwayBillNumber;
 
	@Column(name = "tracking_id", length = 50)
	private String trackingId;
 
	@Convert(converter = LocalDateTimeAttributeConverter.class)
	@Column(name = "expected_delivery_time")
	private LocalDateTime expectedDeliveryTime;
 
	@Convert(converter = LocalDateTimeAttributeConverter.class)
	@Column(name = "promised_delivery_time")
	private LocalDateTime promisedDeliveryTime;
 
	@Convert(converter = LocalDateTimeAttributeConverter.class)
	@Column(name = "expected_shipping_time")
	private LocalDateTime expectedShippingTime;
 
	@Convert(converter = LocalDateTimeAttributeConverter.class)
	@Column(name = "promised_shipping_time")
	private LocalDateTime promisedShippingTime;
 
	@Convert(converter = LocalDateTimeAttributeConverter.class)
	@Column(name = "partner_grn_timestamp")
	private LocalDateTime partnerGrnTimestamp;
 
	public LocalDateTime getPartnerGrnTimestamp() {
		return partnerGrnTimestamp;
	}
 
	public void setPartnerGrnTimestamp(LocalDateTime partnerGrnTimestamp) {
		this.partnerGrnTimestamp = partnerGrnTimestamp;
	}
 
	@Column(name = "customer_id")
	private Integer retailerId;
 
	@Column(name = "customer_name", length = 50)
	private String retailerName;
 
	@Column(name = "customer_mobilenumber", length = 20)
	private String retailerMobileNumber;
 
	@Column(name = "customer_pincode", length = 10)
	private String retailerPinCode;
 
	@Column(name = "customer_address1", length = 100)
	private String retailerAddress1;
 
	@Column(name = "customer_address2", length = 100)
	private String retailerAddress2;
 
	@Column(name = "customer_city", length = 100)
	private String retailerCity;
 
	@Column(name = "customer_state", length = 100)
	private String retailerState;
 
	@Column(name = "customer_email", length = 50)
	private String retailerEmailId;
 
	@Column(name = "status")
	@Enumerated(EnumType.ORDINAL)
	private OrderStatus status;
 
	@Column(name = "statusDescription", length = 50)
	private String statusDescription;
 
	@Column(name = "total_amount")
	private Float totalAmount;
 
	@Column(name = "gvAmount")
	private Float gvAmount;
 
	@Column(name = "total_weight")
	private Float totalWeight;
 
	@Column(name = "invoice_number", length = 30)
	private String invoiceNumber;
 
	@Column(name = "billed_by", length = 30)
	private String billedBy;
 
	@Convert(converter = LocalDateTimeAttributeConverter.class)
	@Column(name = "created_timestamp")
	private LocalDateTime createTimestamp;
 
	@Convert(converter = LocalDateTimeAttributeConverter.class)
	@Column(name = "accepted_timestamp")
	private LocalDateTime acceptedTimestamp;
 
	@Convert(converter = LocalDateTimeAttributeConverter.class)
	@Column(name = "billing_timestamp")
	private LocalDateTime billingTimestamp;
 
	@Convert(converter = LocalDateTimeAttributeConverter.class)
	@Column(name = "shipping_timestamp")
	private LocalDateTime shippingTimestamp;
 
	@Convert(converter = LocalDateTimeAttributeConverter.class)
	@Column(name = "pickup_timestamp")
	private LocalDateTime pickupTimestamp;
 
	@Convert(converter = LocalDateTimeAttributeConverter.class)
	@Column(name = "delivery_timestamp")
	private LocalDateTime deliveryTimestamp;
 
	@Convert(converter = LocalDateTimeAttributeConverter.class)
	@Column(name = "outofstock_timestamp")
	private LocalDateTime outOfStockTimestamp;
 
	@Column(name = "transaction_id")
	private Integer transactionId;
 
	/*
	 * @Column(name = "jacket_number", length = 10) private Integer jacketNumber;
	 */
 
	@Column(name = "receiver", length = 50)
	private String receiver;
 
	@Column(name = "batchNo")
	private Integer batchNumber;
 
	@Column(name = "serialNo")
	private Integer serialNumber;
 
	@Column(name = "doaFlag", columnDefinition = "tinyInteger(1) default 0")
	private Boolean doaFlag;
 
	@Column(name = "pickupRequestNo")
	private Integer pickupRequestNumber;
 
	@Column(name = "new_order_id")
	private Integer newOrderId;
 
	@Column(name = "doa_auth_timestamp")
	private LocalDateTime doaAuthTimestamp;
 
	@Convert(converter = LocalDateTimeAttributeConverter.class)
	@Column(name = "doa_pickup_timestamp")
	private LocalDateTime doaPickupTimestamp;
 
	@Convert(converter = LocalDateTimeAttributeConverter.class)
	@Column(name = "received_return_timestamp")
	private LocalDateTime receiverReturnTimestamp;
 
	@Convert(converter = LocalDateTimeAttributeConverter.class)
	@Column(name = "reship_timestamp")
	private LocalDateTime reShipTimestamp;
 
	@Convert(converter = LocalDateTimeAttributeConverter.class)
	@Column(name = "refund_timestamp")
	private LocalDateTime refundTimestamp;
 
	@Column(name = "purchase_order_id")
	private Integer purchaseOrderId;
 
	@Column(name = "cod", columnDefinition = "tinyInteger(1) default 0")
	private Boolean cod;
 
	@Convert(converter = LocalDateTimeAttributeConverter.class)
	@Column(name = "verification_timestamp")
	private LocalDateTime verificationTimestamp;
 
	@Column(name = "refunded_by", length = 30)
	private String refundBy;
 
	@Column(name = "refund_reason", length = 256)
	private String refundReason;
 
	/*
	 * @Column(name = "delay_reason") private DelayReason delayReason;
	 */
 
	@Convert(converter = LocalDateTimeAttributeConverter.class)
	@Column(name = "cod_reconciliation_timestamp")
	private LocalDateTime codReconciliationTimestamp;
 
	private Integer previousStatus;
 
 
	@Column(name = "vendorId")
	private Integer vendorId;
 
	@Column(name = "delayReasonText", length = 250)
	private String delayReasonText;
 
	@Column(name = "doa_logistics_provider_id")
	private Integer doaLogisticsProviderId;
 
	@Column(name = "vendor_paid", columnDefinition = "tinyInteger(1) default 0")
	private Boolean vendorPaid;
 
	@Convert(converter = LocalDateTimeAttributeConverter.class)
	@Column(name = "local_connected_timestamp")
	private LocalDateTime localConnectedTimestamp;
 
	@Convert(converter = LocalDateTimeAttributeConverter.class)
	@Column(name = "reached_destination_timestamp")
	private LocalDateTime reachedDestinationTimestamp;
 
	@Convert(converter = LocalDateTimeAttributeConverter.class)
	@Column(name = "first_dlvyatmp_timestamp")
	private LocalDateTime firstDlvyatmpTimestamp;
 
	@Column(name = "originalOrderId")
	private Integer originalOrderId;
 
	@Column(name = "fulfilmentWarehouseId")
	private Integer fulfilmentWarehouseId;
 
	@Column(name = "orderType")
	private Integer orderType;
 
	@Column(name = "pickupStoreId")
	private Integer pickupStoreId;
 
	@Column(name = "otg", columnDefinition = "tinyInteger(1) default 0")
	private Boolean otg;
 
	@Convert(converter = LocalDateTimeAttributeConverter.class)
	@Column(name = "courier_delivery_time")
	private LocalDateTime courierDeliveryTimestamp;
 
 
	@Column(name = "insurer")
	private Integer insurer;
 
	@Column(name = "insuranceAmount")
	private Float insuranceAmount;
 
	@Column(name = "freebieItemId")
	private Integer freebieItemId;
 
	@Column(name = "source")
	private Integer source;
 
	@Column(name = "advanceAmount")
	private Float advanceAmount;
 
	@Column(name = "storeId")
	private Integer storeId;
 
	@Column(name = "productCondition")
	private Integer productCondition;
 
 
	@Column(name = "dataProtectionInsurer")
	private Integer dataProtectionInsurer;
 
	@Column(name = "dataProtectionAmount")
	private Integer dataProtectionAmount;
 
	@Column(name = "taxType")
	@Enumerated(EnumType.ORDINAL)
	private TaxType taxType;
 
	@Column(name = "logisticsTransactionId", length = 100)
	private String logisticsTransactionId;
 
	@Column(name = "shippingCost")
	private Float shippingCost;
 
	@Column(name = "codCharges")
	private Float codCharges;
 
	@Column(name = "wallet_amount")
	private Float walletAmount;
 
	@Column(name = "net_payable_amount")
	private Float netPayableAmount;
 
	@Column(name = "shippingRefund")
	private Float shippingRefund;
 
	@ManyToOne(cascade = CascadeType.ALL, fetch = FetchType.EAGER)
	@JoinColumn(name = "id", insertable = false, updatable = false, nullable = false, referencedColumnName = "order_id")
	private LineItem lineItem;
 
	public Integer getId() {
		return id;
	}
 
	public void setId(Integer id) {
		this.id = id;
	}
 
	public Integer getWarehouseId() {
		return warehouseId;
	}
 
	public void setWarehouseId(Integer warehouseId) {
		this.warehouseId = warehouseId;
	}
 
	public Integer getSellerId() {
		return sellerId;
	}
 
	public void setSellerId(Integer sellerId) {
		this.sellerId = sellerId;
	}
 
	public Integer getWarehouseAddressId() {
		return warehouseAddressId;
	}
 
	public void setWarehouseAddressId(Integer warehouseAddressId) {
		this.warehouseAddressId = warehouseAddressId;
	}
 
	public Integer getLogisticsProviderId() {
		return logisticsProviderId;
	}
 
	public void setLogisticsProviderId(Integer logisticsProviderId) {
		this.logisticsProviderId = logisticsProviderId;
	}
 
	public String getAirwayBillNumber() {
		return airwayBillNumber;
	}
 
	public void setAirwayBillNumber(String airwayBillNumber) {
		this.airwayBillNumber = airwayBillNumber;
	}
 
	public String getTrackingId() {
		return trackingId;
	}
 
	public void setTrackingId(String trackingId) {
		this.trackingId = trackingId;
	}
 
	public LocalDateTime getExpectedDeliveryTime() {
		return expectedDeliveryTime;
	}
 
	public void setExpectedDeliveryTime(LocalDateTime expectedDeliveryTime) {
		this.expectedDeliveryTime = expectedDeliveryTime;
	}
 
	public LocalDateTime getPromisedDeliveryTime() {
		return promisedDeliveryTime;
	}
 
	public void setPromisedDeliveryTime(LocalDateTime promisedDeliveryTime) {
		this.promisedDeliveryTime = promisedDeliveryTime;
	}
 
	public LocalDateTime getExpectedShippingTime() {
		return expectedShippingTime;
	}
 
	public void setExpectedShippingTime(LocalDateTime expectedShippingTime) {
		this.expectedShippingTime = expectedShippingTime;
	}
 
	public LocalDateTime getPromisedShippingTime() {
		return promisedShippingTime;
	}
 
	public void setPromisedShippingTime(LocalDateTime promisedShippingTime) {
		this.promisedShippingTime = promisedShippingTime;
	}
 
	public Integer getRetailerId() {
		return retailerId;
	}
 
	public void setRetailerId(Integer retailerId) {
		this.retailerId = retailerId;
	}
 
	public String getRetailerName() {
		return retailerName;
	}
 
	public void setRetailerName(String retailerName) {
		this.retailerName = retailerName;
	}
 
	public String getRetailerMobileNumber() {
		return retailerMobileNumber;
	}
 
	public void setRetailerMobileNumber(String retailerMobileNumber) {
		this.retailerMobileNumber = retailerMobileNumber;
	}
 
	public String getRetailerPinCode() {
		return retailerPinCode;
	}
 
	public void setRetailerPinCode(String retailerPinCode) {
		this.retailerPinCode = retailerPinCode;
	}
 
	public String getRetailerAddress1() {
		return retailerAddress1;
	}
 
	public void setRetailerAddress1(String retailerAddress1) {
		this.retailerAddress1 = retailerAddress1;
	}
 
	public String getRetailerAddress2() {
		return retailerAddress2;
	}
 
	public void setRetailerAddress2(String retailerAddress2) {
		this.retailerAddress2 = retailerAddress2;
	}
 
	public String getRetailerCity() {
		return retailerCity;
	}
 
	public void setRetailerCity(String retailerCity) {
		this.retailerCity = retailerCity;
	}
 
	public String getRetailerState() {
		return retailerState;
	}
 
	public void setRetailerState(String retailerState) {
		this.retailerState = retailerState;
	}
 
	public String getRetailerEmailId() {
		return retailerEmailId;
	}
 
	public void setRetailerEmailId(String retailerEmailId) {
		this.retailerEmailId = retailerEmailId;
	}
 
	public OrderStatus getStatus() {
		return status;
	}
 
	public void setStatus(OrderStatus status) {
		this.status = status;
	}
 
	public String getStatusDescription() {
		return statusDescription;
	}
 
	public void setStatusDescription(String statusDescription) {
		this.statusDescription = statusDescription;
	}
 
	public Float getTotalAmount() {
		return totalAmount;
	}
 
	public void setTotalAmount(Float totalAmount) {
		this.totalAmount = totalAmount;
	}
 
	public Float getGvAmount() {
		return gvAmount;
	}
 
	public void setGvAmount(Float gvAmount) {
		this.gvAmount = gvAmount;
	}
 
	public Float getTotalWeight() {
		return totalWeight;
	}
 
	public void setTotalWeight(Float totalWeight) {
		this.totalWeight = totalWeight;
	}
 
	public String getInvoiceNumber() {
		return invoiceNumber;
	}
 
	public void setInvoiceNumber(String invoiceNumber) {
		this.invoiceNumber = invoiceNumber;
	}
 
	public String getBilledBy() {
		return billedBy;
	}
 
	public void setBilledBy(String billedBy) {
		this.billedBy = billedBy;
	}
 
	public LocalDateTime getCreateTimestamp() {
		return createTimestamp;
	}
 
	public void setCreateTimestamp(LocalDateTime createTimestamp) {
		this.createTimestamp = createTimestamp;
	}
 
	public LocalDateTime getAcceptedTimestamp() {
		return acceptedTimestamp;
	}
 
	public void setAcceptedTimestamp(LocalDateTime acceptedTimestamp) {
		this.acceptedTimestamp = acceptedTimestamp;
	}
 
	public LocalDateTime getBillingTimestamp() {
		return billingTimestamp;
	}
 
	public void setBillingTimestamp(LocalDateTime billingTimestamp) {
		this.billingTimestamp = billingTimestamp;
	}
 
	public LocalDateTime getShippingTimestamp() {
		return shippingTimestamp;
	}
 
	public void setShippingTimestamp(LocalDateTime shippingTimestamp) {
		this.shippingTimestamp = shippingTimestamp;
	}
 
	public LocalDateTime getPickupTimestamp() {
		return pickupTimestamp;
	}
 
	public void setPickupTimestamp(LocalDateTime pickupTimestamp) {
		this.pickupTimestamp = pickupTimestamp;
	}
 
	public LocalDateTime getDeliveryTimestamp() {
		return deliveryTimestamp;
	}
 
	public void setDeliveryTimestamp(LocalDateTime deliveryTimestamp) {
		this.deliveryTimestamp = deliveryTimestamp;
	}
 
	public LocalDateTime getOutOfStockTimestamp() {
		return outOfStockTimestamp;
	}
 
	public void setOutOfStockTimestamp(LocalDateTime outOfStockTimestamp) {
		this.outOfStockTimestamp = outOfStockTimestamp;
	}
 
	public Integer getTransactionId() {
		return transactionId;
	}
 
	public void setTransactionId(Integer transactionId) {
		this.transactionId = transactionId;
	}
 
 
 
	/*
	 * public Integer getJacketNumber() { return jacketNumber; } public void
	 * setJacketNumber(Integer jacketNumber) { this.jacketNumber = jacketNumber; }
	 */
	public String getReceiver() {
		return receiver;
	}
 
	public void setReceiver(String receiver) {
		this.receiver = receiver;
	}
 
	public Integer getBatchNumber() {
		return batchNumber;
	}
 
	public void setBatchNumber(Integer batchNumber) {
		this.batchNumber = batchNumber;
	}
 
	public Integer getSerialNumber() {
		return serialNumber;
	}
 
	public void setSerialNumber(Integer serialNumber) {
		this.serialNumber = serialNumber;
	}
 
	public Boolean isDoaFlag() {
		return doaFlag;
	}
 
	public void setDoaFlag(Boolean doaFlag) {
		this.doaFlag = doaFlag;
	}
 
	public Integer getPickupRequestNumber() {
		return pickupRequestNumber;
	}
 
	public void setPickupRequestNumber(Integer pickupRequestNumber) {
		this.pickupRequestNumber = pickupRequestNumber;
	}
 
	public Integer getNewOrderId() {
		return newOrderId;
	}
 
	public void setNewOrderId(Integer newOrderId) {
		this.newOrderId = newOrderId;
	}
 
	public LocalDateTime getDoaAuthTimestamp() {
		return doaAuthTimestamp;
	}
 
	public void setDoaAuthTimestamp(LocalDateTime doaAuthTimestamp) {
		this.doaAuthTimestamp = doaAuthTimestamp;
	}
 
	public LocalDateTime getDoaPickupTimestamp() {
		return doaPickupTimestamp;
	}
 
	public void setDoaPickupTimestamp(LocalDateTime doaPickupTimestamp) {
		this.doaPickupTimestamp = doaPickupTimestamp;
	}
 
	public LocalDateTime getReceiverReturnTimestamp() {
		return receiverReturnTimestamp;
	}
 
	public void setReceiverReturnTimestamp(LocalDateTime receiverReturnTimestamp) {
		this.receiverReturnTimestamp = receiverReturnTimestamp;
	}
 
	public LocalDateTime getReShipTimestamp() {
		return reShipTimestamp;
	}
 
	public void setReShipTimestamp(LocalDateTime reShipTimestamp) {
		this.reShipTimestamp = reShipTimestamp;
	}
 
	public LocalDateTime getRefundTimestamp() {
		return refundTimestamp;
	}
 
	public void setRefundTimestamp(LocalDateTime refundTimestamp) {
		this.refundTimestamp = refundTimestamp;
	}
 
	public Integer getPurchaseOrderId() {
		return purchaseOrderId;
	}
 
	public void setPurchaseOrderId(Integer purchaseOrderId) {
		this.purchaseOrderId = purchaseOrderId;
	}
 
	public Boolean isCod() {
		return cod;
	}
 
	public void setCod(Boolean cod) {
		this.cod = cod;
	}
 
	public LocalDateTime getVerificationTimestamp() {
		return verificationTimestamp;
	}
 
	public void setVerificationTimestamp(LocalDateTime verificationTimestamp) {
		this.verificationTimestamp = verificationTimestamp;
	}
 
	public String getRefundBy() {
		return refundBy;
	}
 
	public void setRefundBy(String refundBy) {
		this.refundBy = refundBy;
	}
 
	public String getRefundReason() {
		return refundReason;
	}
 
	public void setRefundReason(String refundReason) {
		this.refundReason = refundReason;
	}
 
 
 
	/*
	 * public DelayReason getDelayReason() { return delayReason; } public void
	 * setDelayReason(DelayReason delayReason) { this.delayReason = delayReason; }
	 */
	public LocalDateTime getCodReconciliationTimestamp() {
		return codReconciliationTimestamp;
	}
 
	public void setCodReconciliationTimestamp(LocalDateTime codReconciliationTimestamp) {
		this.codReconciliationTimestamp = codReconciliationTimestamp;
	}
 
	public Integer getPreviousStatus() {
		return previousStatus;
	}
 
	public void setPreviousStatus(Integer previousStatus) {
		this.previousStatus = previousStatus;
	}
 
	public Integer getVendorId() {
		return vendorId;
	}
 
	public void setVendorId(Integer vendorId) {
		this.vendorId = vendorId;
	}
 
	public String getDelayReasonText() {
		return delayReasonText;
	}
 
	public void setDelayReasonText(String delayReasonText) {
		this.delayReasonText = delayReasonText;
	}
 
	public Integer getDoaLogisticsProviderId() {
		return doaLogisticsProviderId;
	}
 
	public void setDoaLogisticsProviderId(Integer doaLogisticsProviderId) {
		this.doaLogisticsProviderId = doaLogisticsProviderId;
	}
 
	public Boolean isVendorPaid() {
		return vendorPaid;
	}
 
	public void setVendorPaid(Boolean vendorPaid) {
		this.vendorPaid = vendorPaid;
	}
 
	public LocalDateTime getLocalConnectedTimestamp() {
		return localConnectedTimestamp;
	}
 
	public void setLocalConnectedTimestamp(LocalDateTime localConnectedTimestamp) {
		this.localConnectedTimestamp = localConnectedTimestamp;
	}
 
	public LocalDateTime getReachedDestinationTimestamp() {
		return reachedDestinationTimestamp;
	}
 
	public void setReachedDestinationTimestamp(LocalDateTime reachedDestinationTimestamp) {
		this.reachedDestinationTimestamp = reachedDestinationTimestamp;
	}
 
	public LocalDateTime getFirstDlvyatmpTimestamp() {
		return firstDlvyatmpTimestamp;
	}
 
	public void setFirstDlvyatmpTimestamp(LocalDateTime firstDlvyatmpTimestamp) {
		this.firstDlvyatmpTimestamp = firstDlvyatmpTimestamp;
	}
 
	public Integer getOriginalOrderId() {
		return originalOrderId;
	}
 
	public void setOriginalOrderId(Integer originalOrderId) {
		this.originalOrderId = originalOrderId;
	}
 
	public Integer getFulfilmentWarehouseId() {
		return fulfilmentWarehouseId;
	}
 
	public void setFulfilmentWarehouseId(Integer fulfilmentWarehouseId) {
		this.fulfilmentWarehouseId = fulfilmentWarehouseId;
	}
 
	public Integer getOrderType() {
		return orderType;
	}
 
	public void setOrderType(Integer orderType) {
		this.orderType = orderType;
	}
 
	public Integer getPickupStoreId() {
		return pickupStoreId;
	}
 
	public void setPickupStoreId(Integer pickupStoreId) {
		this.pickupStoreId = pickupStoreId;
	}
 
	public Boolean isOtg() {
		return otg;
	}
 
	public void setOtg(Boolean otg) {
		this.otg = otg;
	}
 
	public LocalDateTime getCourierDeliveryTimestamp() {
		return courierDeliveryTimestamp;
	}
 
	public void setCourierDeliveryTimestamp(LocalDateTime courierDeliveryTimestamp) {
		this.courierDeliveryTimestamp = courierDeliveryTimestamp;
	}
 
	public Integer getInsurer() {
		return insurer;
	}
 
	public void setInsurer(Integer insurer) {
		this.insurer = insurer;
	}
 
	public Float getInsuranceAmount() {
		return insuranceAmount;
	}
 
	public void setInsuranceAmount(Float insuranceAmount) {
		this.insuranceAmount = insuranceAmount;
	}
 
	public Integer getFreebieItemId() {
		return freebieItemId;
	}
 
	public void setFreebieItemId(Integer freebieItemId) {
		this.freebieItemId = freebieItemId;
	}
 
	public Integer getSource() {
		return source;
	}
 
	public void setSource(Integer source) {
		this.source = source;
	}
 
	public Float getAdvanceAmount() {
		return advanceAmount;
	}
 
	public void setAdvanceAmount(Float advanceAmount) {
		this.advanceAmount = advanceAmount;
	}
 
	public Integer getStoreId() {
		return storeId;
	}
 
	public void setStoreId(Integer storeId) {
		this.storeId = storeId;
	}
 
	public Integer getProductCondition() {
		return productCondition;
	}
 
	public void setProductCondition(Integer productCondition) {
		this.productCondition = productCondition;
	}
 
	public Integer getDataProtectionInsurer() {
		return dataProtectionInsurer;
	}
 
	public void setDataProtectionInsurer(Integer dataProtectionInsurer) {
		this.dataProtectionInsurer = dataProtectionInsurer;
	}
 
	public Integer getDataProtectionAmount() {
		return dataProtectionAmount;
	}
 
	public void setDataProtectionAmount(Integer dataProtectionAmount) {
		this.dataProtectionAmount = dataProtectionAmount;
	}
 
	public TaxType getTaxType() {
		return taxType;
	}
 
	public void setTaxType(TaxType taxType) {
		this.taxType = taxType;
	}
 
	public String getLogisticsTransactionId() {
		return logisticsTransactionId;
	}
 
	public void setLogisticsTransactionId(String logisticsTransactionId) {
		this.logisticsTransactionId = logisticsTransactionId;
	}
 
	public Float getShippingCost() {
		return shippingCost;
	}
 
	public void setShippingCost(Float shippingCost) {
		this.shippingCost = shippingCost;
	}
 
	public Float getCodCharges() {
		return codCharges;
	}
 
	public void setCodCharges(Float codCharges) {
		this.codCharges = codCharges;
	}
 
	public Float getWalletAmount() {
		return walletAmount;
	}
 
	public void setWalletAmount(Float walletAmount) {
		this.walletAmount = walletAmount;
	}
 
	public Float getNetPayableAmount() {
		return netPayableAmount;
	}
 
	public void setNetPayableAmount(Float netPayableAmount) {
		this.netPayableAmount = netPayableAmount;
	}
 
	public Float getShippingRefund() {
		return shippingRefund;
	}
 
	public void setShippingRefund(Float shippingRefund) {
		this.shippingRefund = shippingRefund;
	}
 
	public LineItem getLineItem() {
		return lineItem;
	}
 
	public void setLineItem(LineItem lineItem) {
		this.lineItem = lineItem;
	}
 
	public String getFormattedDate() {
		DateTimeFormatter formatter = DateTimeFormatter.ofPattern("dd-MM-yyyy HH:mm");
		return this.createTimestamp.format(formatter);
 
	}
 
	@Override
	public int hashCode() {
		final int prime = 31;
		int result = 1;
		result = prime * result + ((id == null) ? 0 : id.hashCode());
		return result;
	}
 
	@Override
	public boolean equals(Object obj) {
		if (this == obj)
			return true;
		if (obj == null)

				return false;
		} else if (!id.equals(other.id))
			return false;
		return true;
	}
 
	@Override
	public String toString() {
		return "Order [id=" + id + ", warehouseId=" + warehouseId + ", sellerId=" + sellerId + ", warehouseAddressId="
				+ warehouseAddressId + ", logisticsProviderId=" + logisticsProviderId + ", airwayBillNumber="
				+ airwayBillNumber + ", trackingId=" + trackingId + ", expectedDeliveryTime=" + expectedDeliveryTime
				+ ", promisedDeliveryTime=" + promisedDeliveryTime + ", expectedShippingTime=" + expectedShippingTime
				+ ", promisedShippingTime=" + promisedShippingTime + ", partnerPurchaseTimestamp=" + partnerGrnTimestamp
				+ ", retailerId=" + retailerId + ", retailerName=" + retailerName + ", retailerMobileNumber="
				+ retailerMobileNumber + ", retailerPinCode=" + retailerPinCode + ", retailerAddress1="
				+ retailerAddress1 + ", retailerAddress2=" + retailerAddress2 + ", retailerCity=" + retailerCity
				+ ", retailerState=" + retailerState + ", retailerEmailId=" + retailerEmailId + ", status=" + status
				+ ", statusDescription=" + statusDescription + ", totalAmount=" + totalAmount + ", gvAmount=" + gvAmount
				+ ", totalWeight=" + totalWeight + ", invoiceNumber=" + invoiceNumber + ", billedBy=" + billedBy
 
				+ ", createTimestamp=" + createTimestamp + ", acceptedTimestamp=" + acceptedTimestamp
				+ ", billingTimestamp=" + billingTimestamp + ", shippingTimestamp=" + shippingTimestamp
				+ ", pickupTimestamp=" + pickupTimestamp + ", deliveryTimestamp=" + deliveryTimestamp
				+ ", outOfStockTimestamp=" + outOfStockTimestamp + ", transactionId=" + transactionId + ", receiver="
				+ receiver + ", batchNumber=" + batchNumber + ", serialNumber=" + serialNumber + ", doaFlag=" + doaFlag
				+ ", pickupRequestNumber=" + pickupRequestNumber + ", newOrderId=" + newOrderId + ", doaAuthTimestamp="
				+ doaAuthTimestamp + ", doaPickupTimestamp=" + doaPickupTimestamp + ", receiverReturnTimestamp="
				+ receiverReturnTimestamp + ", reShipTimestamp=" + reShipTimestamp + ", refundTimestamp="
				+ refundTimestamp + ", purchaseOrderId=" + purchaseOrderId + ", cod=" + cod + ", verificationTimestamp="
				+ verificationTimestamp + ", refundBy=" + refundBy + ", refundReason=" + refundReason
				+ ", codReconciliationTimestamp=" + codReconciliationTimestamp + ", previousStatus=" + previousStatus
				+ ", vendorId=" + vendorId + ", delayReasonText=" + delayReasonText + ", doaLogisticsProviderId="
				+ doaLogisticsProviderId + ", vendorPaid=" + vendorPaid + ", localConnectedTimestamp="
				+ localConnectedTimestamp + ", reachedDestinationTimestamp=" + reachedDestinationTimestamp
				+ ", firstDlvyatmpTimestamp=" + firstDlvyatmpTimestamp + ", originalOrderId=" + originalOrderId
				+ ", fulfilmentWarehouseId=" + fulfilmentWarehouseId + ", orderType=" + orderType + ", pickupStoreId="
				+ pickupStoreId + ", otg=" + otg + ", courierDeliveryTimestamp=" + courierDeliveryTimestamp
				+ ", insurer=" + insurer + ", insuranceAmount=" + insuranceAmount + ", freebieItemId=" + freebieItemId
				+ ", source=" + source + ", advanceAmount=" + advanceAmount + ", storeId=" + storeId
				+ ", productCondition=" + productCondition + ", dataProtectionInsurer=" + dataProtectionInsurer
				+ ", dataProtectionAmount=" + dataProtectionAmount + ", taxType=" + taxType
				+ ", logisticsTransactionId=" + logisticsTransactionId + ", shippingCost=" + shippingCost
				+ ", codCharges=" + codCharges + ", walletAmount=" + walletAmount + ", netPayableAmount="
				+ netPayableAmount + ", shippingRefund=" + shippingRefund + ", lineItem=" + lineItem + "]";
	}
 
}


Subversion Repositories SmartDukaan

(root)/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/transaction/Order.java – Rev 25503 → 27723

Rev 25503		Rev 27723
Line 31...		Line 31...
31	`* @author ashikali`	31	`* @author ashikali`
32	`*`	32	`*`
33	`*/`	33	`*/`
34		34
35	`@Entity`	35	`@Entity`
36	@Table(name="transaction.`order`", schema = "transaction")	36	@Table(name = "transaction.`order`", schema = "transaction")
37	`@NamedQueries({`	-
38	`@NamedQuery(name="Order.selectAll",query="select o from Order o"),`	37	`@NamedQueries({ @NamedQuery(name = "Order.selectAll", query = "select o from Order o"),`
39	`@NamedQuery(name="Order.selectById",query="select o from Order o where o.id= :id"),`	38	`@NamedQuery(name = "Order.selectById", query = "select o from Order o where o.id= :id"),`
40	`@NamedQuery(`	-
41	`name = "Order.selectByTransactionId",`	-
42	`query = "select t.id, t.createTimestamp, o.retailerAddress1, o.retailerAddress2, o.retailerCity, "`	39	`@NamedQuery(name = "Order.selectByTransactionId", query = "select t.id, t.createTimestamp, o.retailerAddress1, o.retailerAddress2, o.retailerCity, "`
43	`+ "o.retailerPinCode, o.retailerState, o.shippingCost, o.statusDescription, o.invoiceNumber, o.airwayBillNumber, o.totalAmount, li.brand, li.modelName, "`	40	`+ "o.retailerPinCode, o.retailerState, o.shippingCost, o.statusDescription, o.invoiceNumber, o.airwayBillNumber, o.totalAmount, li.brand, li.modelName, "`
44	`+ "li.modelNumber, li.color, li.quantity, li.unitPrice, p.id, p.name, o.shippingTimestamp, o.status, o.promisedDeliveryTime, o.retailerName, t.status, i.catalogItemId from Transaction t join Order o on o.transactionId = t.id "`	41	`+ "li.modelNumber, li.color, li.quantity, li.unitPrice, p.id, p.name, o.shippingTimestamp, o.status, o.promisedDeliveryTime, o.retailerName, t.status, i.catalogItemId from Transaction t join Order o on o.transactionId = t.id "`
45	`+ "join LineItem li on li.orderId = o.id left join Provider p on p.id = o.logisticsProviderId join Item i on i.id=li.itemId where o.transactionId = :transactionId"),`	42	`+ "join LineItem li on li.orderId = o.id left join Provider p on p.id = o.logisticsProviderId join Item i on i.id=li.itemId where o.transactionId = :transactionId"),`
46		43
47	`@NamedQuery(`	44	`@NamedQuery(name = "Order.selectItemIdTypeQuantity", query = "select new com.spice.profitmandi.dao.model.ItemIdTypeQuantity(li.itemId, i.type, li.quantity) from Order o join LineItem li on li.orderId = o.id join Item i on i.id = li.itemId where o.invoiceNumber = :invoiceNumber and o.retailerId = :retailerId"),`
-		45
-		46	`@NamedQuery(name = "Order.selectAllBilledOrderGroupByBrand", query = "select new com.spice.profitmandi.dao.model.SecondaryOrderBillingModel(li.brand, "`
-		47	`+ "sum(case when o.billingTimestamp >= :today then CAST(o.totalAmount AS int) else 0 end),"`
-		48	`+ "sum(case when o.billingTimestamp >= :threedays and o.billingTimestamp <= :endDate then CAST(o.totalAmount AS int) else 0 end),"`
-		49	`+ "sum(case when concat(year(o.billingTimestamp ), month(o.billingTimestamp ))= :mtd then CAST(o.totalAmount AS int) else 0 end),"`
-		50	`+ "sum(case when o.billingTimestamp between :lmtdStartDate and :lmtdEndDate then CAST(o.totalAmount AS int) else 0 end),"`
48	`name = "Order.selectItemIdTypeQuantity",`	51	`+ " sum(case when o.billingTimestamp >= :today then li.quantity else 0 end),"`
-		52	`+ " sum(case when o.billingTimestamp >= :threedays and o.billingTimestamp <= :endDate then li.quantity else 0 end),"`
-		53	`+ " sum(case when concat(year(o.billingTimestamp), month(o.billingTimestamp))= :mtd then li.quantity else 0 end),"`
-		54	`+ " sum(case when o.billingTimestamp between :lmtdStartDate and :lmtdEndDate then li.quantity else 0 end))"`
49	`query = "select new com.spice.profitmandi.dao.model.ItemIdTypeQuantity(li.itemId, i.type, li.quantity) from Order o join LineItem li on li.orderId = o.id join Item i on i.id = li.itemId where o.invoiceNumber = :invoiceNumber and o.retailerId = :retailerId")`	55	`+ " from Order o join LineItem li on o.id = li.orderId where o.billingTimestamp is not null"`
-		56	`+ " and o.billingTimestamp >= :lmtdStartDate and o.warehouseId in :warehouseId group by li.brand")`
-		57
50	`})`	58	`})`
51	`public class Order implements Serializable{`	59	`public class Order implements Serializable {`
52		60
53	`private static final long serialVersionUID = 1L;`	61	`private static final long serialVersionUID = 1L;`
54		62
55	`public Order() {`	63	`public Order() {`
56	`}`	64	`}`
57		65
58	`@Id`	66	`@Id`