import argparse

import datetime

import query

parser = argparse.ArgumentParser(description="""Generate report for the date specified.

                                 Start and end date default to present day.

                                 Start time defaults to 00:00:00.

                                 End time defaults to 23:59:59.""")

parser.add_argument('-s','--start-date', type=str, default=datetime.datetime.strftime(datetime.date.today(), '%Y-%m-%d'), help="Start date (YYYY-MM-DD)")

parser.add_argument('-e','--end-date', type=str, default=datetime.datetime.strftime(datetime.date.today(), '%Y-%m-%d'), help="End date (YYYY-MM-DD)")

parser.add_argument('-S','--start-time', type=str, default = '00:00:00', help="Start time (HH:MM:SS)")

parser.add_argument('-E','--end-time', type=str, default='23:59:59', help="End time (HH:MM:SS)")

args = parser.parse_args()

startDate = args.start_date + " " + args.start_time

endDate = args.end_date + " " + args.end_time

postings = query.Query('lb_postings')

print '{0}: {1}'.format("Number of postings published", postings.posts(startDate, endDate))

print '{0}: {1}'.format("Number of recordings made", postings.recordings(startDate, endDate))

print '{0}: {1}'.format("Number of impact stories", postings.filter_by_title('impact', startDate, endDate))

callDetails = query.Query('cdr')

average_call_length = callDetails.average(startDate, endDate)

audio_minutes = callDetails.sum(startDate, endDate)

channel1_minutes = callDetails.load('SIP/10.0.0.20', startDate, endDate)

channel2_minutes = callDetails.load('SIP/10.0.0.21', startDate, endDate)

channel3_minutes = callDetails.load('SIP/10.0.0.22', startDate, endDate)

mobilink_load = callDetails.call_distribution(startDate, endDate, 'mobilink')

mobilink_tata_load = callDetails.call_distribution(startDate, endDate, 'mobilinktata')

print '{0}: {1}'.format("Number of missed calls", callDetails.missedCalls(startDate, endDate))

print '{0}: {1}'.format("Number of missed calls on 'mobilink'", callDetails.missedCalls(startDate, endDate, 'mobilink'))

print '{0}: {1}'.format("Number of missed calls on 'mobilinktata'", callDetails.missedCalls(startDate, endDate, 'mobilinktata'))

print '{0}: {1}'.format("Number of calls answered", callDetails.answeredCalls(startDate, endDate))

print '{0}: {1}'.format("Number of calls lasting less than 30 seconds", callDetails.filter_calls_by_duration(startDate, endDate, 30))

print '{0}: {1:.4f}'.format("Average length of calls", average_call_length)

print '{0}: {1:.4f}'.format("Total number of audio minutes played", audio_minutes)

print '{0}: {1:.4f}'.format("Audio minutes on channel 10.0.0.20", channel1_minutes)

print '{0}: {1:.4f}'.format("Audio minutes on channel 10.0.0.21", channel2_minutes)

print '{0}: {1:.4f}'.format("Audio minutes on channel 10.0.0.22", channel3_minutes)

print '{0}: {1:.4f}'.format("Load on channel 10.0.0.20", channel1_minutes/audio_minutes)

print '{0}: {1:.4f}'.format("Load on channel 10.0.0.21", channel2_minutes/audio_minutes)

print '{0}: {1:.4f}'.format("Load on channel 10.0.0.22", channel3_minutes/audio_minutes)

print '{0}: {1}'.format("Busiest hour for mobilink",mobilink_load["maxLoad"])

print '{0}: {1}'.format("Number of calls in busiest hour for mobilink",mobilink_load["maxCalls"])

print '{0}: {1}'.format("Least active hour for mobilink",mobilink_load["minLoad"])

print '{0}: {1}'.format("Busiest hour for mobilinktata",mobilink_tata_load["maxLoad"])

print '{0}: {1}'.format("Number of calls in busiest hour for mobilinktata",mobilink_tata_load["maxCalls"])

print '{0}: {1}'.format("Least active hour for mobilinktata",mobilink_tata_load["minLoad"])