API tools faq
paste
Advertisement
Guest User

Django view

a guest
Apr 17th, 2012
145
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 11.85 KB | None | 0 0
raw download clone embed print report
  1. # Create your views here.
  2.  
  3. from django.conf import settings
  4. from django.contrib.auth.decorators import login_required
  5. from django.core.context_processors import request
  6. from django.core.paginator import Paginator, EmptyPage, PageNotAnInteger, \
  7.     InvalidPage
  8. from django.db.models import Q
  9. from django.http import HttpResponse, HttpResponseRedirect
  10. from django.shortcuts import render_to_response
  11. from django.core.urlresolvers import reverse
  12. from django.template import RequestContext
  13. from urllib import urlencode as ue
  14. from urllib2 import urlopen as uo
  15.  
  16. #This is my tables
  17. #FdaSheet1 ---> TABLE1,etc...
  18.  
  19. from fda.models import FdaSheet1,FdaSheet2,FdaSheet3,FdaSheet4,FdaSheet5,FdaSheet6,FdaSheet7
  20. from pharma_center.models import DrugSet,\
  21.     TherapeuticArea, Company,\
  22.     Drug, Files, \
  23.     DrugKeywordRelation, Indication,\
  24.     MarketSegment, DrugClass,\
  25.     KeywordCategory, Keyword,\
  26.     WhitelistDomains,RSSFeeds
  27.  
  28. def view_fda_data(request,drugset_id):
  29.     drugset = DrugSet.objects.get(pk=drugset_id)
  30.     drug=drugset.drug
  31.     drug_name=(str(drug)).upper()
  32.     total_data=[]
  33.     try:
  34.         sheet2_data=FdaSheet2.objects.filter(drugname=drug_name)
  35.         #print sheet2_data
  36.         for i in sheet2_data:
  37.             i=str(i)
  38.             sheet2_rows=0
  39.             sheet3_rows=0
  40.             sheet4_rows=0
  41.             sheet5_rows=0
  42.             sheet6_rows=0
  43.             sheet7_rows=0
  44.             maximum_rows=0
  45.             sheet1_present_data=FdaSheet1.objects.extra(where=["isr='"+i+"'"]).values('isr','case','i_f_cod','foll_seq','image','event_dt',\
  46.                     'mfr_dt','fda_dt','rept_cod','mfr_num','mfr_sndr','age','age_cod','gndr_cod','e_sub','wt','wt_cod','rept_dt','occp_cod','death_dt','to_mfr','confid','reporter_country')
  47.             sheet1_data_list=list(sheet1_present_data)
  48.             sheet1_rows=len(sheet1_present_data)
  49.             #print sheet1_rows
  50.             sheet2_data=FdaSheet2.objects.extra(where=["isr='"+i+"'"]).values('drug_seq','role_cod','drugname','val_vbm','route','dose_vbm','dechal',\
  51.                                                             'rechal','lot_num','exp_dt','nda_num')
  52.             sheet2_data_list=list(sheet2_data)
  53.             #print sheet2_data_list
  54.             sheet2_rows=len(sheet2_data_list)
  55.             sheet3_data=FdaSheet3.objects.extra(where=["isr='"+i+"'"]).values('drug_seq','indi_pt')
  56.             sheet3_data_list=list(sheet3_data)
  57.             sheet3_rows=len(sheet3_data_list)
  58.             sheet4_data=FdaSheet4.objects.extra(where=["isr='"+i+"'"]).values('outc_cod')
  59.             sheet4_data_list=list(sheet4_data)
  60.             sheet4_rows=len(sheet4_data_list)
  61.             sheet5_data=FdaSheet5.objects.extra(where=["isr='"+i+"'"]).values('pt')
  62.             sheet5_data_list=list(sheet5_data)
  63.             sheet5_rows=len(sheet5_data_list)
  64.             sheet6_data=FdaSheet6.objects.extra(where=["isr='"+i+"'"]).values('rpsr_cod')
  65.             sheet6_data_list=list(sheet6_data)
  66.             sheet6_rows=len(sheet6_data_list)
  67.             sheet7_data=FdaSheet7.objects.extra(where=["isr='"+i+"'"]).values('drug_seq','start_dt','end_dt','dur','dur_cod')
  68.             sheet7_data_list=list(sheet7_data)
  69.             sheet7_rows=len(sheet7_data_list)
  70.             total_rows=[sheet2_rows,sheet3_rows,sheet4_rows,sheet5_rows,sheet6_rows]
  71.             maximum_rows=max(total_rows)
  72.             #print maximum_rows
  73.             for i in range(maximum_rows):
  74.                 sheet1_remain_rows=maximum_rows-sheet1_rows
  75.                 sheet2_remain_rows=maximum_rows-sheet2_rows
  76.                 sheet3_remain_rows=maximum_rows-sheet3_rows
  77.                 sheet4_remain_rows=maximum_rows-sheet4_rows
  78.                 sheet5_remain_rows=maximum_rows-sheet5_rows
  79.                 sheet6_remain_rows=maximum_rows-sheet6_rows
  80.                 sheet7_remain_rows=maximum_rows-sheet7_rows
  81.                 for sheet1 in range(sheet1_remain_rows):
  82.                     sheet1_data_list.append("None")
  83.                 for sheet2 in range(sheet2_remain_rows):
  84.                     sheet2_data_list.append("None")
  85.                    # print sheet2_data_list
  86.                 for sheet3 in range(sheet3_remain_rows):
  87.                     sheet3_data_list.append("None")
  88.                     #print sheet3_data_list
  89.                 for sheet4 in range(sheet4_remain_rows):
  90.                     sheet4_data_list.append("None")
  91.                    # print sheet4_data_list
  92.                 for sheet5 in range(sheet5_remain_rows):
  93.                     sheet5_data_list.append("None")
  94.                     #print sheet5_data_list
  95.                 for sheet6 in range(sheet6_remain_rows):
  96.                     sheet6_data_list.append("None")
  97.                    
  98.                 for sheet7 in range(sheet7_remain_rows):
  99.                     sheet7_data_list.append("None")
  100.                    # print sheet6_data_list
  101.             for row in range(maximum_rows):
  102.                 if type(sheet1_data_list[row])==str:
  103.                     sheet1_isr = "-----"
  104.                     sheet1_case = "-----"
  105.                     sheet1_i_f_cod =  "-----"
  106.                     sheet1_foll_seq =  "-----"
  107.                     sheet1_image =  "-----"
  108.                     sheet1_event_dt =  "-----"
  109.                     sheet1_mfr_dt =  "-----"
  110.                     sheet1_fda_dt =  "-----"
  111.                     sheet1_rept_cod =  "-----"
  112.                     sheet1_mfr_num =  "-----"  
  113.                     sheet1_mfr_sndr =  "-----"
  114.                     sheet1_age =  "-----"
  115.                     sheet1_age_cod =  "-----"
  116.                     sheet1_gndr_cod =  "-----"
  117.                     sheet1_e_sub =  "-----"
  118.                     sheet1_wt =  "-----"
  119.                     sheet1_wt_cod =  "-----"
  120.                     sheet1_rept_dt =  "-----"
  121.                     sheet1_occp_cod =  "-----"
  122.                     sheet1_death_dt =  "-----"
  123.                     sheet1_to_mfr =  "-----"
  124.                     sheet1_confid = "-----"
  125.                     sheet1_reporter_country = "-----"
  126.                 else:
  127.                     sheet1_isr = sheet1_data_list[row]['isr']
  128.                     sheet1_case = sheet1_data_list[row]['case']
  129.                     sheet1_i_f_cod = sheet1_data_list[row]['i_f_cod']
  130.                     sheet1_foll_seq = sheet1_data_list[row]['foll_seq']
  131.                     sheet1_image = sheet1_data_list[row]['image']
  132.                     sheet1_event_dt = sheet1_data_list[row]['event_dt']
  133.                     sheet1_mfr_dt =  sheet1_data_list[row]['mfr_dt']
  134.                     sheet1_fda_dt =  sheet1_data_list[row]['fda_dt']
  135.                     sheet1_rept_cod =  sheet1_data_list[row]['rept_cod']
  136.                     sheet1_mfr_num = sheet1_data_list[row]['mfr_num']
  137.                     sheet1_mfr_sndr = sheet1_data_list[row]['mfr_sndr']
  138.                     sheet1_age = sheet1_data_list[row]['age']
  139.                     sheet1_age_cod = sheet1_data_list[row]['age_cod']
  140.                     sheet1_gndr_cod =  sheet1_data_list[row]['gndr_cod']
  141.                     sheet1_e_sub = sheet1_data_list[row]['e_sub']
  142.                     sheet1_wt =  sheet1_data_list[row]['wt']
  143.                     sheet1_wt_cod =  sheet1_data_list[row]['wt_cod']
  144.                     sheet1_rept_dt =  sheet1_data_list[row]['rept_dt']
  145.                     sheet1_occp_cod =  sheet1_data_list[row]['occp_cod']
  146.                     sheet1_death_dt = sheet1_data_list[row]['death_dt']
  147.                     sheet1_to_mfr = sheet1_data_list[row]['to_mfr']
  148.                     sheet1_confid = sheet1_data_list[row]['confid']
  149.                     sheet1_reporter_country = sheet1_data_list[row]['reporter_country']
  150.            
  151.                 if type(sheet2_data_list[row])==str:
  152.                     sheet2_drug_seq = "---"
  153.                     sheet2_role_cod = "---"
  154.                     sheet2_drugname = "---"
  155.                     sheet2_val_vbm = "---"
  156.                     sheet2_route = "---"
  157.                     sheet2_dose_vbm = "---"
  158.                     sheet2_dechal = "---"
  159.                     sheet2_rechal = "---"
  160.                     sheet2_lot_num = "---"
  161.                     sheet2_exp_dt = "---"
  162.                     sheet2_nda_num = "---"
  163.                    
  164.                 else:
  165.                     sheet2_drug_seq = sheet2_data_list[row]['drug_seq']
  166.                     sheet2_role_cod = sheet2_data_list[row]['role_cod']
  167.                     sheet2_drugname = sheet2_data_list[row]['drugname']
  168.                     sheet2_val_vbm = sheet2_data_list[row]['val_vbm']
  169.                     sheet2_route = sheet2_data_list[row]['route']
  170.                     sheet2_dose_vbm = sheet2_data_list[row]['dose_vbm']
  171.                     sheet2_dechal = sheet2_data_list[row]['dechal']
  172.                     sheet2_rechal = sheet2_data_list[row]['rechal']
  173.                     sheet2_lot_num = sheet2_data_list[row]['lot_num']
  174.                     sheet2_exp_dt = sheet2_data_list[row]['exp_dt']
  175.                     sheet2_nda_num = sheet2_data_list[row]['nda_num']
  176.                 if type(sheet3_data_list[row])==str:
  177.                     sheet3_drug_seq="----"
  178.                     sheet3_indi_pt="----"
  179.                 else:
  180.                     sheet3_drug_seq=sheet3_data_list[row]['drug_seq']
  181.                     sheet3_indi_pt=sheet3_data_list[row]['indi_pt']
  182.                    
  183.                 if type(sheet4_data_list[row])==str:
  184.                     sheet4_outc_cod="----"
  185.                 else:
  186.                     sheet4_outc_cod=sheet4_data_list[row]['outc_cod']
  187.                 if type(sheet5_data_list[row])==str:
  188.                     sheet5_pt="----"
  189.                 else:
  190.                     sheet5_pt=sheet5_data_list[row]['pt']
  191.                    
  192.                 if type(sheet6_data_list[row])==str:
  193.                     sheet6_rpsr_cod="----"
  194.                 else:
  195.                     sheet6_rpsr_cod=sheet6_data_list[row]['rpsr_cod']
  196.                
  197.                 if type(sheet7_data_list[row])==str:
  198.                     sheet7_drug_seq ="---"
  199.                     sheet7_start_dt="----"
  200.                     sheet7_end_dt="----"
  201.                     sheet7_dur="----"
  202.                     sheet7_dur_cod="----"
  203.                 else:
  204.                     sheet7_drug_seq =sheet7_data_list[row]['drug_seq']
  205.                     sheet7_start_dt=sheet7_data_list[row]['start_dt']
  206.                     sheet7_end_dt=sheet7_data_list[row]['end_dt']
  207.                     sheet7_dur=sheet7_data_list[row]['dur']
  208.                     sheet7_dur_cod=sheet7_data_list[row]['dur_cod']
  209.                
  210.                     #print sheet6_pt
  211.                 total_data.append([sheet1_isr,sheet1_age,sheet1_age_cod,sheet1_gndr_cod,sheet1_wt,sheet1_wt_cod,sheet2_role_cod,sheet2_drugname,\
  212.                                    sheet2_route,sheet2_dose_vbm, sheet3_indi_pt,sheet4_outc_cod,sheet5_pt,sheet1_occp_cod,sheet1_case,sheet1_i_f_cod,\
  213.                                    sheet1_foll_seq,sheet1_image,sheet1_event_dt,sheet1_mfr_dt,sheet1_fda_dt,sheet1_rept_cod,sheet1_mfr_num,sheet1_mfr_sndr,\
  214.                                    sheet1_e_sub,sheet1_rept_dt,sheet1_death_dt,sheet1_to_mfr,sheet1_confid,sheet1_reporter_country,sheet2_drug_seq,sheet2_val_vbm,\
  215.                                    sheet2_dechal,sheet2_rechal,sheet2_lot_num,sheet2_exp_dt,sheet2_nda_num,sheet3_drug_seq,sheet6_rpsr_cod,sheet7_drug_seq,sheet7_start_dt,\
  216.                                    sheet7_end_dt,sheet7_dur,sheet7_dur_cod])
  217.         total_data_length=len(total_data)
  218.         paginator = Paginator(total_data,35)
  219.         page = int(request.GET.get('page', '1'))
  220.         try:
  221.             paginated_contents = paginator.page(page)
  222.         except EmptyPage:
  223.             paginated_contents = paginator.page(paginator.num_pages)
  224.    
  225.     except Exception as e:
  226.         print str(e)
  227.        
  228.     return render_to_response("pharma_center/patient_intelligence/fda_data.html",locals(),context_instance=RequestContext(request))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!