def collect1(request, start_date, end_date, gcid, fcid):
client = GoogleClient.objects.get(pk=gcid)
client_id = client.client_id
client_name = client.client_name
#account = FacebookAccount.objects.get(account_name='Western Health Advantage')
account = FacebookAccount.objects.get(pk=fcid)
try:
fb_acc = SocialAccount.objects.get(user_id=request.user.id,
provider='facebook')
#google_acc = SocialAccount.objects.get(user_id = request.user.id,provider='google')
fb_tok = SocialToken.objects.get(account=fb_acc)
#google_tok = SocialToken.objects.get(account=google_acc)
except:
return HttpResponse("error connecting Social Accounts")
#clear the database
GoogleCampaign.objects.all().delete()
GoogleAdGroup.objects.all().delete()
GoogleKeyword.objects.all().delete()
#FacebookAccount.objects.all().delete()
Report.objects.all().delete()
report_model = Report()
report_model.user = request.user.username
report_model.date_taken = datetime.now()
report_model.google_account = client_name
if (start_date == '1' and end_date == '1'):
report_model.date_range = "All Time"
report_model.save()
account.report = report_model
account.save()
all_google_data(request, client_id)
return render(request, 'report/onetwo.html')
return redirect("../2")
elif (start_date == '2' and end_date == '2'):
report_model.date_range = "Last 30 Days"
report_model.save()
account.report = report_model
account.save()
month_google_data(request, client_id)
#"../../../../view"
return render(request, 'report/onetwo.html')
return redirect("../2")
i_y = start_date[0] + start_date[1] + start_date[2] + start_date[3]
i_m = start_date[5] + start_date[6]
i_d = start_date[8] + start_date[9]
f_y = end_date[0] + end_date[1] + end_date[2] + end_date[3]
f_m = end_date[5] + end_date[6]
f_d = end_date[8] + end_date[9]
googstartDate = i_y + i_m + i_d
googendDate = f_y + f_m + f_d
fbstartDate = i_y + '-' + i_m + '-' + i_d
fbendDate = f_y + '-' + f_m + '-' + f_d
report_model.date_range = fbstartDate + " to " + fbendDate
report_model.save()
account.report = report_model
account.save()
#get the google data
google_data(request, client_id, googstartDate, googendDate)
#get the facebook data
return render(request, 'report/onetwo.html')
return redirect("../2")
def collect1(request,start_date,end_date,gcid,fcid):
client = GoogleClient.objects.get(pk=gcid)
client_id = client.client_id
client_name = client.client_name
#account = FacebookAccount.objects.get(account_name='Western Health Advantage')
account = FacebookAccount.objects.get(pk=fcid)
try:
fb_acc = SocialAccount.objects.get(user_id = request.user.id,provider='facebook')
#google_acc = SocialAccount.objects.get(user_id = request.user.id,provider='google')
fb_tok = SocialToken.objects.get(account=fb_acc)
#google_tok = SocialToken.objects.get(account=google_acc)
except:
return HttpResponse("error connecting Social Accounts")
#clear the database
GoogleCampaign.objects.all().delete()
GoogleAdGroup.objects.all().delete()
GoogleKeyword.objects.all().delete()
#FacebookAccount.objects.all().delete()
Report.objects.all().delete()
report_model = Report()
report_model.user = request.user.username
report_model.date_taken = datetime.now()
report_model.google_account = client_name
if(start_date == '1' and end_date == '1'):
report_model.date_range = "All Time"
report_model.save()
account.report = report_model
account.save()
all_google_data(request, client_id)
return render(request, 'report/onetwo.html')
return redirect("../2")
elif(start_date == '2' and end_date == '2'):
report_model.date_range = "Last 30 Days"
report_model.save()
account.report = report_model
account.save()
month_google_data(request, client_id)
#"../../../../view"
return render(request, 'report/onetwo.html')
return redirect("../2")
i_y = start_date[0] + start_date[1] + start_date[2] + start_date[3]
i_m = start_date[5] + start_date[6]
i_d = start_date[8] + start_date[9]
f_y = end_date[0] + end_date[1] + end_date[2] + end_date[3]
f_m = end_date[5] + end_date[6]
f_d = end_date[8] + end_date[9]
googstartDate = i_y+i_m+i_d
googendDate = f_y+f_m+f_d
fbstartDate = i_y + '-' + i_m + '-' + i_d
fbendDate = f_y + '-' + f_m + '-' + f_d
report_model.date_range = fbstartDate + " to " + fbendDate
report_model.save()
account.report = report_model
account.save()
#get the google data
google_data(request, client_id, googstartDate, googendDate)
#get the facebook data
return render(request, 'report/onetwo.html')
return redirect("../2")
