package com.social.media.infrastructure.persistence.entity;

import jakarta.persistence.*;
import lombok.AllArgsConstructor;
import lombok.Builder;
import lombok.Data;
import lombok.NoArgsConstructor;
import org.hibernate.annotations.CreationTimestamp;
import org.hibernate.annotations.UpdateTimestamp;

import java.time.LocalDateTime;

/**
 * Automation Campaign JPA Entity
 * Maps to the campaigns table
 */
@Entity
@Table(name = "campaigns", schema = "automation")
@Data
@Builder
@NoArgsConstructor
@AllArgsConstructor
public class AutomationCampaignEntity {
    
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;
    
    @Column(name = "campaign_code", nullable = false, unique = true, length = 20)
    private String campaignCode;
    
    @Column(name = "company_id", nullable = false)
    private Long companyId;
    
    @Column(name = "social_account_id", nullable = false)
    private Long socialAccountId;
    
    @Column(name = "name", nullable = false)
    private String name;
    
    @Column(name = "description")
    private String description;
    
    @Column(name = "campaign_type", nullable = false, length = 50)
    private String campaignType;
    
    @Enumerated(EnumType.STRING)
    @Column(name = "status", nullable = false, columnDefinition = "automation.campaign_status")
    private CampaignStatusEntity status;
    
    @Column(name = "target_config", columnDefinition = "jsonb")
    private String targetConfig;
    
    @Column(name = "action_config", columnDefinition = "jsonb")
    private String actionConfig;
    
    @Column(name = "schedule_config", columnDefinition = "jsonb")
    private String scheduleConfig;
    
    @Column(name = "total_planned_actions")
    @Builder.Default
    private Integer totalPlannedActions = 0;
    
    @Column(name = "total_executed_actions")
    @Builder.Default
    private Integer totalExecutedActions = 0;
    
    @Column(name = "successful_actions")
    @Builder.Default
    private Integer successfulActions = 0;
    
    @Column(name = "failed_actions")
    @Builder.Default
    private Integer failedActions = 0;
    
    @Column(name = "planned_start_date")
    private LocalDateTime plannedStartDate;
    
    @Column(name = "planned_end_date")
    private LocalDateTime plannedEndDate;
    
    @Column(name = "actual_start_date")
    private LocalDateTime actualStartDate;
    
    @Column(name = "actual_end_date")
    private LocalDateTime actualEndDate;
    
    @Column(name = "last_execution_date")
    private LocalDateTime lastExecutionDate;
    
    @Column(name = "is_active")
    @Builder.Default
    private Boolean isActive = true;
    
    @Column(name = "auto_restart")
    @Builder.Default
    private Boolean autoRestart = false;
    
    @CreationTimestamp
    @Column(name = "created_at", nullable = false, updatable = false)
    private LocalDateTime createdAt;
    
    @UpdateTimestamp
    @Column(name = "updated_at", nullable = false)
    private LocalDateTime updatedAt;
    
    public enum CampaignStatusEntity {
        DRAFT, ACTIVE, PAUSED, COMPLETED, CANCELLED, FAILED
    }
}