-
Notifications
You must be signed in to change notification settings - Fork 6
Get companies that haven't signed up but visited our website
Rasmus Rudling edited this page Nov 10, 2021
·
1 revision
from exhibitors.models import Exhibitor
from fair.models import Fair
import datetime
from companies.models import SignupLog
signup_logs = SignupLog.objects.filter()
fair = Fair.objects.filter(current=True)
exhibitors = Exhibitor.objects.filter(fair=fair)
exhibitor_set = set()
for exhibitor in exhibitors:
exhibitor_set.add(str(exhibitor.company).upper())
signup_logs = SignupLog.objects.filter()
for signup_log in signup_logs:
start_date = datetime.datetime(2021, 6, 22, 23, 59)
end_date = datetime.datetime(2021, 9, 8, 18, 50)
timestamp = signup_log.timestamp
company = signup_log.company
have_not_signed = str(company).upper() not in exhibitor_set
if start_date < timestamp and timestamp < end_date and have_not_signed:
print()
print(f"--- {company} ---")
print(f"Person: {signup_log.company_contact}")
print(f"Visited: {timestamp}")
print("---")
-
For developers
-
API
-
For Head of Internal Systems