def main(): applicants = get_submitted_applicant_dict( { 'personal_info': PersonalInfo, 'submission_info': SubmissionInfo }) print >>f, 'National ID' print >>f, '-----------' find_dup(f, applicants.itervalues(), get_national_id) print print >>f, "Applicants' name" print >>f, '----------------' find_dup(f, applicants.itervalues(), get_fullname)
from django.conf import settings from django_bootstrap import bootstrap bootstrap(__file__) from application.models import SubmissionInfo, Applicant, PersonalInfo from utils import get_submitted_applicant_dict import sys if len(sys.argv)!=2: print "Usage: export_applicants [output.csv]" quit() file_name = sys.argv[1] applicants = get_submitted_applicant_dict( {'personal_info': PersonalInfo, 'submission_info': SubmissionInfo }) f = codecs.open(file_name, encoding="utf-8", mode="w") print >> f, "No,CITIZENID,Name,SurName" i = 0 appeared = {} for applicant in applicants.itervalues(): if not applicant.submission_info.is_paid: continue nat_id = applicant.national_id if nat_id not in appeared: print >> f, '%d,"%s","%s","%s"' % ( (i+1),
import codecs from django.conf import settings from django_bootstrap import bootstrap bootstrap(__file__) from application.models import SubmissionInfo, Applicant, PersonalInfo from utils import get_submitted_applicant_dict applicants = get_submitted_applicant_dict( {'personal_info': PersonalInfo} ) nat_id_dict = dict([(app.personal_info.national_id, app) for app in applicants.itervalues()]) def main(): while True: try: line = raw_input() if line in nat_id_dict: app = nat_id_dict[line] print ("%s %s %s %s" % (line, app.full_name(), app.email, app.personal_info.phone_number)) else: print line, "not found" except: break
quit() round_number = int(sys.argv[1]) file_name = sys.argv[2] from django.conf import settings from django_bootstrap import bootstrap bootstrap(__file__) from application.models import SubmissionInfo, Applicant, Major, MajorPreference, PersonalInfo from confirmation.models import AdmissionMajorPreference, AdmissionWaiver from utils import get_submitted_applicant_dict applicants = get_submitted_applicant_dict({ 'preference': MajorPreference, 'personal_info': PersonalInfo, 'submission_info': SubmissionInfo, }) f = codecs.open(file_name, encoding="utf-8", mode="w") pref = {} SUBMISSION_RANK = {1: 2, # doc by mail 2: 1, # online 3: 3} # all by mail for applicantion_id in sorted(applicants.keys()): applicant = applicants[applicantion_id] #if not applicant.submission_info.doc_reviewed_complete: # continue
import codecs from django.conf import settings from django_bootstrap import bootstrap bootstrap(__file__) from application.models import SubmissionInfo, Applicant, PersonalInfo, Education from utils import get_submitted_applicant_dict applicants = get_submitted_applicant_dict( {'personal_info': PersonalInfo, 'education': Education } ) nat_id_dict = dict([(app.personal_info.national_id, app) for app in applicants.itervalues()]) f = codecs.open('eduinfo.txt', encoding='utf-8', mode='w') def main(): while True: try: line = raw_input() if line in nat_id_dict: app = nat_id_dict[line] print >> f, ("%s %s : %s" % (line, app.full_name(), app.education.school_name)) else: print line, "not found" except:
quit() round_number = int(sys.argv[1]) file_name = sys.argv[2] from django.conf import settings from django_bootstrap import bootstrap bootstrap(__file__) from application.models import SubmissionInfo, Applicant, Major, MajorPreference, PersonalInfo from confirmation.models import AdmissionMajorPreference, AdmissionWaiver from utils import get_submitted_applicant_dict applicants = get_submitted_applicant_dict({ 'preference': MajorPreference, 'personal_info': PersonalInfo, 'submission_info': SubmissionInfo, }) f = codecs.open(file_name, encoding="utf-8", mode="w") pref = {} uses_nat_id = '--nat' in sys.argv SUBMISSION_RANK = {1: 2, # doc by mail 2: 1, # online 3: 3} # all by mail for applicantion_id in sorted(applicants.keys()): applicant = applicants[applicantion_id]