/**
 *
 * Copyright
 * 2009-2015 Jayway Products AB
 * 2016-2017 Föreningen Sambruk
 *
 * Licensed under AGPL, Version 3.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *     http://www.gnu.org/licenses/agpl.txt
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */
package org.streamsource.streamflow.statistic.service;

import org.streamsource.streamflow.statistic.dto.SearchCriteria;
import org.streamsource.streamflow.statistic.web.Dao;

/**
 * Statistic service for month period.
 */
public class MonthlyStatisticService
   extends StatisticService
{

   public MonthlyStatisticService( SearchCriteria criteria)
   {
      super( criteria );
   }

   public String getPeriodFunction( String column )
   {
      if(Dao.getDbVendor().equalsIgnoreCase( "mssql" ))
      {
         return "CONVERT( VARCHAR(7), [" + column + "], 120 )";
      } else
      {
         return "date_format( " + column + ", '%Y-%m' )";
      }
   }

   public String getGroupOrOrderByClause( String column, String alias )
   {
      if(Dao.getDbVendor().equalsIgnoreCase( "mssql" ))
      {
         return getPeriodFunction( column );
      } else
      {
         return alias;
      }
   }
}