using System;
using System.Collections.Generic;
using System.Web;

using MySQL;
using System.Data;
using System.Web.Configuration;
using System.Web.UI.WebControls;

namespace SiteECom
{
    /// <summary>
    /// Gestão de Estatisticas
    /// </summary>
    public class Estatisticas
    {
        public Estatisticas()
        {
            //
            // TODO: Add constructor logic here
            //
        }

        /// <summary>
        /// Estatísticas anuais
        /// </summary>
        public class Anuais
        {
                /// <summary>
                /// Mostra estatísticas de determinado ano por meses
                /// </summary>
                /// <param name="Ano">Ano a mostrar</param>
                /// <returns>DataTable</returns>
            public static DataTable Visitas(int Ano)
            {
                DataTable dtListagem = new DataTable();
                sql sqlInfo = new sql(WebConfigurationManager.ConnectionStrings["Site"].ConnectionString);

                if (Ano == 0)
                {
                    Ano = DateTime.Now.Year;
                }

                sqlInfo.Query = "SELECT DATE_FORMAT(data, '%m') AS mes, "
                              + "       COUNT(DISTINCT(ip)) AS visitantes, "
                              + "       COUNT(DISTINCT(uid)) AS visitas, "
                              + "       COUNT(link) AS paginas "
                              + "FROM visitas "
                              + "WHERE DATE_FORMAT(data, '%Y')='" + Ano + "' "
                              + "GROUP BY DATE_FORMAT(data, '%m') DESC "
                              + "ORDER BY data";

                dtListagem = sqlInfo.Read();
                sqlInfo.closeConnection();

                return dtListagem;
            }
        }

        /// <summary>
        /// Estatísticas mensais
        /// </summary>
        public class Mensais
        {
            /// <summary>
            /// Mostra estatísticas de determinado mês
            /// </summary>
            /// <param name="Ano">Ano a mostrar</param>
            /// <param name="Mes">Mês a mostrar</param>
            /// <returns>DataTable</returns>
            public static DataTable Visitas(int Ano, int Mes)
            {
                DataTable dtListagem = new DataTable();
                sql sqlInfo = new sql(WebConfigurationManager.ConnectionStrings["Site"].ConnectionString);

                if (Ano == 0)
                {
                    Ano = DateTime.Now.Year;
                }
                if (Mes == 0)
                {
                    Mes = DateTime.Now.Month;
                }

                DateTime data = new DateTime(Ano, Mes, 1);

                TimeSpan umDia = new TimeSpan(24, 0, 0);
                TimeSpan umMes = new TimeSpan(744, 0, 0);

                DateTime ontem = data.Subtract(umDia);
                DateTime proximoMes = data.Add(umMes);

                string _ontem = ontem.Year + "." + ontem.Month + "." + ontem.Day;
                string _proximoMes = proximoMes.Year + "." + proximoMes.Month + "." + proximoMes.Day;

                sqlInfo.Query = "SELECT DATE_FORMAT(data, '%d') AS dia, "
                              + "       COUNT(DISTINCT(ip)) AS visitantes, "
                              + "       COUNT(DISTINCT(uid)) AS visitas, "
                              + "       COUNT(link) AS paginas "
                              + "FROM visitas "
                              + "WHERE DATE_FORMAT(data, '%Y.%m.%d')>=DATE_FORMAT('" + _ontem + "', '%Y.%m.%d') "
                              + "  AND DATE_FORMAT(data, '%Y.%m.%d')<DATE_FORMAT('" + _proximoMes + "', '%Y.%m.%d') "
                              + "GROUP BY DATE_FORMAT(data, '%m.%d') DESC "
                              + "ORDER BY data";

                dtListagem = sqlInfo.Read();
                sqlInfo.closeConnection();

                return dtListagem;
            }
        }

        /// <summary>
        /// Estatísticas diárias
        /// </summary>
        public class Diarias
        { }
    }
}