def dmuserphone():
users = User.query.filter(User.qxhdm_user_id > 0)
for user in users:
if User_Phone.query.filter(User_Phone.phone == user.phone).first():
pass
else:
print user.user_id
db.session.add(User_Phone.add_phone(user.user_id,user.phone))
db.session.commit()
def getdmuser():
html = StringIO()
url = r'%sgetuser'%DMURL
print datetime.now()
print url
c = pycurl.Curl()
c.setopt(pycurl.URL, url)
c.setopt(pycurl.SSL_VERIFYHOST, False)
c.setopt(pycurl.SSL_VERIFYPEER, False)
c.setopt(pycurl.WRITEFUNCTION, html.write)
c.setopt(pycurl.FOLLOWLOCATION, 1)
c.perform()
ll = str(html.getvalue())
users = json.loads(ll)
for u in users:
user = User()
p = User_Phone.query.filter(db.or_(User_Phone.phone == u['phone'],User_Phone.phone == u['phone2'])).first()
purchases = u['name']+u'于'+u['gmdate']+u' 在 '+u['gmaddress']+u' 购买了大盒'+str(u['gmbigcount'])+u'盒，小盒'+str(u['gmsmallcount'])+u'盒,备注：'+u['remark']+u',电话：'+u['phone']+','+u['phone2']+u',年龄：'+str(u['ages'])+u',性别：'+u['gender']+u',区域：'+u['area']
if p:
pass#如果存在,不处理20141224
# user = User.query.get_or_404(p.user_id)
# user.operator_id = 1
# user.origin = int(u['origin'])
# user.user_type = 5#服务客户
# #user.assign_operator_id = 1
# user.purchases = str(user.purchases)+purchases
# user.qxhdm_user_id = u['id']
# user.area = u['area']
# user.pharmacy = u['pharmacy']
# user.promoters = u['promoters']
# user.pharmacystores = u['pharmacystores']
#
# user.qxhdm_time = datetime.now().strftime('%Y-%m-%d')
# db.session.add(user)
#
# #分配记录
# assign_log = User_Assign_Log()
# assign_log.user_id = user.user_id
# assign_log.assign_operator_id = None
# assign_log.operator_id = 1
# assign_log.user_type = user.user_type
# db.session.add(assign_log)
else:
user.operator_id = 1
user.origin = int(u['origin'])
user.user_type = 5#服务客户
#user.assign_operator_id = 1
user.name = u['name']
user.phone = u['phone']
user.phone2 = u['phone2']
user.gender = u['gender']
user.ages = u['ages']
user.is_new = u['is_new']
user.disease = u['disease']
user.fugou = u['fugou']
user.remark = u['remark']
user.area = u['area']
user.pharmacy = u['pharmacy']
user.promoters = u['promoters']
user.pharmacystores = u['pharmacystores']
user.purchases = purchases
user.qxhdm_user_id = u['id']
user.qxhdm_time = datetime.now().strftime('%Y-%m-%d')
db.session.add(user)
db.session.flush()
#分配记录
assign_log = User_Assign_Log()
assign_log.user_id = user.user_id
assign_log.assign_operator_id = None
assign_log.operator_id = 1
assign_log.user_type = user.user_type
db.session.add(assign_log)
db.session.add(User_Phone.add_phone(user.user_id,user.phone))
if user.phone2:
db.session.add(User_Phone.add_phone(user.user_id,user.phone2))
url = r'%supdateuser?id=%s&user_id=%s'%(DMURL,u['id'],user.user_id)
print url
c = pycurl.Curl()
c.setopt(pycurl.URL, url)
c.setopt(pycurl.SSL_VERIFYHOST, False)
c.setopt(pycurl.SSL_VERIFYPEER, False)
c.setopt(pycurl.WRITEFUNCTION, html.write)
c.setopt(pycurl.FOLLOWLOCATION, 1)
c.perform()
db.session.commit()