SHOW:
|
|
- or go back to the newest paste.
| 1 | from oncore.models import * | |
| 2 | import csv | |
| 3 | from django.conf import settings | |
| 4 | nl = Newsletter.get_current() | |
| 5 | - | myf = open('opportunities_count.csv', 'w')
|
| 5 | + | myf = open('opportunities_count_selected_members.csv', 'w')
|
| 6 | writer = csv.writer(myf) | |
| 7 | writer.writerow(['user_pk', 'opp_to_send_count']) | |
| 8 | - | all_subs = Subscriber.objects.filter(representative=False, managing_director=False, slave=False) |
| 8 | + | all_subs = Subscriber.objects.filter(pk__in=[2129,2229,2299,2328,2501,2581,4393,4631,4991,5439]) |
| 9 | all_count = all_subs.count() | |
| 10 | for i, subscriber in enumerate(all_subs): | |
| 11 | print('{0} from {1}'.format(i, all_count))
| |
| 12 | news_list = nl.get_news_list(None, subscriber, connected=False, exclude_own=True) | |
| 13 | news_list = news_list.filter(oppuserscore__subscriber=subscriber, | |
| 14 | oppuserscore__base_score__gte=settings.PERFECT_MATCH_SCORE) | |
| 15 | news_list_count = news_list[:settings.NEWSLETTER_NUMBER_OPPS].count() | |
| 16 | - | if news_list_count: |
| 16 | + | writer.writerow([subscriber.pk, news_list_count]) |
| 17 | - | writer.writerow([subscriber.pk, news_list_count]) |
| 17 | + |
