from oncore.models import *
import csv
from django.conf import settings
nl = Newsletter.get_current()
myf = open('opportunities_count_selected_members.csv', 'w')
writer = csv.writer(myf)
writer.writerow(['user_pk', 'opp_to_send_count'])
all_subs = Subscriber.objects.filter(pk__in=[2129,2229,2299,2328,2501,2581,4393,4631,4991,5439])
all_count = all_subs.count()
for i, subscriber in enumerate(all_subs):
    print('{0} from {1}'.format(i, all_count))
    news_list = nl.get_news_list(None, subscriber, connected=False, exclude_own=True)
    news_list = news_list.filter(oppuserscore__subscriber=subscriber,
                                                 oppuserscore__base_score__gte=settings.PERFECT_MATCH_SCORE)
    news_list_count = news_list[:settings.NEWSLETTER_NUMBER_OPPS].count()
    writer.writerow([subscriber.pk, news_list_count])
myf.close()