def approve_ccr(ccrid):
     ccr = None
     exclub = None
     
     try:
         ccr = CreateClubRequest.objects.get(id__exact=ccrid)
     except:
         pass
     
     try:
         exclub = Club.objects.get(tmid__exact=ccr.tmid)
     except:
         pass
     
     if exclub is None and ccr:
         club = Club()
         club.tmid = ccr.tmid
         club.fullname = ccr.fullname
         club.briefname = ccr.briefname
         club.address = ccr.address
         club.addressd = ccr.addressd
         
         club.mday = ccr.mday
         club.mtime = ccr.mtime
         
         club.conperson = ccr.conperson
         club.conphone = ccr.conphone
         
         club.email = ccr.email
         club.website = ccr.website
         club.qq = ccr.qq
         club.weibo = ccr.weibo
         club.facebook = ccr.facebook
         
         club.cdate = ccr.cdate            
         club.advanced = ccr.advanced            
         club.cstatus = 0 # set as created
         
         club.desc = ccr.desc            
         #process the location/section: district/area/division  country/province              
         club.location = ccr.location
         club.section = ccr.section
         
         club.active = True
         
         club.save()
         print("club: {} {}".format(club.id, club.fullname))            
         
         term = Term()
         term.startdate = int(time.mktime(datetime.now().timetuple())*1000)
         term.enddate = term.startdate + 16416000000 # half a year: 190*24*3600000
         term.club = club
         term.save()
         club.curterm = term.id
         club.save()
         print("term: {} {}".format(term.id, term.startdate))
         
         membership = Membership(club=club,term=term, person=ccr.user,type=MemberType.President,access=UserUtil.getExpectedAccess(MemberType.President))
         membership.save()
         print("membership(Set requester as President)# club:{} term:{} person: {}".format(membership.club.id, membership.club.id,membership.person.username))
         
         #the first club
         if Membership.objects.filter(person=ccr.user).count()==1:
             ccr.user.defclub = club.id
             ccr.user.save()
         
         msgcontent = "Congratulation! Club {} has bee setup with {} as president.".format(club.fullname,membership.person.username)
         MessageUtil.sendClubNty(club.id,club.fullname, club.id, msgcontent)
         
         print(msgcontent)
         CreateClubRequest.objects.filter(id__exact=ccrid).delete()
     else:
         print("This club has been created or the create request is not existed!")
         return False
person.set_password("d9b1d7db4cd6e70935368a1efb10e377")
person.qq = "25398752"
person.weibo = "Cathy [email protected]"
person.location = "Guang zhou"
person.is_staff = True
person.gender = 2

person.save()
membership = Membership(club=club,term=term, person=person,type=MemberType.VPE,access=UserUtil.getExpectedAccess(MemberType.VPE))
membership.save()
print(person.password)
"""

#***********************************************************
gnclub = Club()
gnclub.tmid = 410000001
gnclub.fullname = "Guangzhou GumpNew"
gnclub.briefname = "GumpNew"
gnclub.address = "Area N3, Division N, District 88"
gnclub.addressd = "CN-GumpNew"
gnclub.meetingno = 14411
gnclub.phone = 1395554458711
gnclub.email = "*****@*****.**"
gnclub.website = "http://GumpNew.itoastmasters.com"
gnclub.qq = "2536412511"
gnclub.weibo = "*****@*****.**"
gnclub.imgurl = "/static/img/clubs/club3.png"
gnclub.desc = "GumpNew is the most popular toastmasters club in Guangzhou."
gnclub.location = location
gnclub.section = district
gnclub.save()
#init the location and section
il = InitLocation()
il.initSection()
il.initLocation()

district = None
location = None
try:
    district = Section.objects.get(name__exact="89")
    location = Location.objects.get(name__exact="Guangdong")
except:
    pass

#***********************************************************
gnclub = Club()
gnclub.tmid = 410000001
gnclub.fullname = "Guangzhou GumpNew"
gnclub.briefname = "GumpNew"
gnclub.address = "Area N3, Division N, District 88"
gnclub.addressd = "CN-GumpNew"
gnclub.meetingno = 14411
gnclub.phone = 1395554458711
gnclub.email = "*****@*****.**"
gnclub.website = "http://GumpNew.itoastmasters.com"
gnclub.qq = "2536412511"
gnclub.weibo = "*****@*****.**"
gnclub.imgurl = "/static/img/clubs/club3.png"
gnclub.desc = "GumpNew is the most popular toastmasters club in Guangzhou."
gnclub.location = location
gnclub.section = district
gnclub.save()