package com.arrow.utils.mysql.accounts;

import java.sql.ResultSet;
import java.sql.SQLException;

import com.arrow.server.game.world.entity.player.PlayerInformation;
import com.arrow.utils.Utils;
import com.arrow.utils.mysql.ReadDatabaseQuery;

public class CredentialValidation extends ReadDatabaseQuery {

    /* Represents the Requested Player Information to validate */
    private PlayerInformation playerInformation;

    /* Represents Account Current State */
    private AccountStatus status;

    /* Represents Possibly Account States */
    public enum AccountStatus {
        SUCCESSFUL, INVALID_CREDENTIALS, BANNED
    }

    /**
     *
     * @param playerInformation
     */
    public CredentialValidation(PlayerInformation playerInformation) {
        setPlayerInformation(playerInformation);
        super.inquiryDatabase();
    }

    /*
     * (non-Javadoc)
     * @see com.arrow.utils.mysql.ReadDatabaseQuery#createStatement()
     */
    @Override
    public String createStatement() {
        builder.append("SELECT * FROM characters WHERE username='" + getPlayerInformation().getUsername()+"' LIMIT 1");
        return builder.toString();
    }

    /*
     * (non-Javadoc)
     * @see com.arrow.utils.mysql.ReadDatabaseQuery#fetchResult(java.sql.ResultSet)
     */
    @Override
    public void fetchResult(ResultSet result) {
        try {
            while (result.next()) {
                String password = result.getString("password");
                String banned = result.getString("bannedTill");
                if (!getPlayerInformation().getPassword().equals(password)) {
                    setStatus(AccountStatus.INVALID_CREDENTIALS);
                    return;
                }
                if (Long.parseLong(banned) > Utils.currentTimeMillis()) {
                    setStatus(AccountStatus.BANNED);
                    return;
                }
                setStatus(AccountStatus.SUCCESSFUL);
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }

    /**
     * @return the playerInformation
     */
    public PlayerInformation getPlayerInformation() {
        return playerInformation;
    }

    /**
     * @param playerInformation the playerInformation to set
     */
    public void setPlayerInformation(PlayerInformation playerInformation) {
        this.playerInformation = playerInformation;
    }

    /**
     * @return the status
     */
    public AccountStatus getStatus() {
        return status;
    }

    /**
     * @param status the status to set
     */
    public void setStatus(AccountStatus status) {
        this.status = status;
    }

}