大家好！我是职场程序猿，感谢您阅读本文，欢迎一键三连哦。
精彩专栏推荐👇🏻👇🏻👇🏻
开发环境
开发语言：Python
框架：django
Python版本：python3.7.7
数据库：mysql 5.7
数据库工具：Navicat11
开发软件：PyCharm
浏览器：谷歌浏览器
论文目录
【如需全文请按文末获取联系】
一、项目简介
本研究设计并实现了一款基于Python语言、Django框架、Vue前端技术、MySQL数据库以及B/S架构的客户关系管理（CRM）系统。该系统旨在帮助企业实现对客户信息的高效管理、分析与服务，提供包括客户信息管理、客户关系维护、销售数据分析、客户沟通记录等核心功能。
二、系统设计
2.1软件功能模块设计
基于Python的客户关系管理系统围绕不同角色的业务需求设计了多层次的功能模块。管理员可管理系统首页、销售人员、客服人员、运营人员、销售订单、客户关系、运营策略及系统设置，确保系统稳定运行。销售人员专注于销售订单管理与运营策略执行，提升业务转化率。客服人员负责客户关系管理，优化客户体验，并参与运营策略调整。运营人员兼顾销售订单管理、客户关系维护和运营策略实施，以推动业务增长。各角色分工明确，共同保障系统高效运作。系统结构功能图见图4.2。
2.2数据库设计
系统E-R图见图4.3。
三、系统项目部分截图
3.1销售人员功能模块
系统首页功能
销售人员进入该平台系统后，包含系统首页、个人中心、销售订单管理和运营策略管理等功能。销售人员可以点击按钮进入相对应的界面进行操作。
销售人员注册登录功能
销售人员进入该系统后，如要进行操作则需要登录账号方可进行操作，点击“登录”按钮进行登录，根据登录界面输入账号和密码，如没有该系统账号则点击“注册销售人员”跳转到注册界面，根据界面提示输入注册信息完成注册，方可登录系统操作。
销售订单管理功能
销售人员登录系统后，可以看到销售订单管理列表，点击可以查看销售订单详情。
运营策略管理功能
销售人员可以对运营策略进行管理，点击“运营策略管理”按钮，可以进入到运营策略管理界面，在运营策略管理界面可以进行查看运营策略列表。
3.2客服人员功能模块
客户关系管理功能
客服人员可以对客户关系进行管理，点击“客户关系管理”按钮，可以进入到客户关系管理界面，在客户关系管理界面可以进行查看客户关系列表。
3.3运营人员功能模块
销售订单管理功能
运营人员可以对销售订单进行查看，点击“销售订单管理”按钮，可以进入到销售订单管理，在销售订单管理界面可以进行查看操作。
3.4管理员功能模块
销售人员管理功能
管理员可以对系统的销售人员信息进行管理，点击“销售人员管理”“按钮，可进入销售人员信息管理界面，在销售人员信息管理界面，可以对销售人员信息进行添加，修改，删除等管理操作。
客服人员管理功能
管理员可以对系统的客服人员信息进行管理，点击“客服人员管理”“按钮，可进入客服人员信息管理界面，在客服人员信息管理界面，可以对客服人员信息进行添加，修改，删除等管理操作。
系统管理功能
管理员可以对系统信息进行管理，点击“系统管理”按钮，可进入到系统信息管理界面，在此界面可以系统日志，公告资讯分类行管理操作。
四、部分核心代码
#coding:utf-8
import base64, copy, logging, os, sys, time, xlrd, json, datetime, configparser
from django.http import JsonResponse
from django.apps import apps
import numbers
from django.db.models.aggregates import Count,Sum
from django.db.models import Case, When, IntegerField, F
from django.forms import model_to_dict
import requests
from util.CustomJSONEncoder import CustomJsonEncoder
from .models import kehuguanxi
from util.codes import *
from util.auth import Auth
from util.common import Common
import util.message as mes
from django.db import connection
import random
from django.core.mail import send_mail
from django.conf import settings
from django.shortcuts import redirect
from django.db.models import Q
from util.baidubce_api import BaiDuBce
from .config_model import config
def kehuguanxi_register(request):
if request.method in ["POST", "GET"]:
msg = {'code': normal_code, "msg": mes.normal_code}
req_dict = request.session.get("req_dict")
error = kehuguanxi.createbyreq(kehuguanxi, kehuguanxi, req_dict)
if error is Exception or (type(error) is str and "Exception" in error):
msg['code'] = crud_error_code
msg['msg'] = "用户已存在,请勿重复注册!"
else:
msg['data'] = error
return JsonResponse(msg, encoder=CustomJsonEncoder)
def kehuguanxi_login(request):
if request.method in ["POST", "GET"]:
msg = {'code': normal_code, "msg": mes.normal_code}
req_dict = request.session.get("req_dict")
datas = kehuguanxi.getbyparams(kehuguanxi, kehuguanxi, req_dict)
if not datas:
msg['code'] = password_error_code
msg['msg'] = mes.password_error_code
return JsonResponse(msg, encoder=CustomJsonEncoder)
try:
__sfsh__= kehuguanxi.__sfsh__
except:
__sfsh__=None
if __sfsh__=='是':
if datas[0].get('sfsh')!='是':
msg['code']=other_code
msg['msg'] = "账号已锁定，请联系管理员审核!"
return JsonResponse(msg, encoder=CustomJsonEncoder)
req_dict['id'] = datas[0].get('id')
return Auth.authenticate(Auth, kehuguanxi, req_dict)
def kehuguanxi_logout(request):
if request.method in ["POST", "GET"]:
msg = {
"msg": "登出成功",
"code": 0
}
return JsonResponse(msg, encoder=CustomJsonEncoder)
def kehuguanxi_resetPass(request):
'''
'''
if request.method in ["POST", "GET"]:
msg = {"code": normal_code, "msg": mes.normal_code}
req_dict = request.session.get("req_dict")
columns= kehuguanxi.getallcolumn( kehuguanxi, kehuguanxi)
try:
__loginUserColumn__= kehuguanxi.__loginUserColumn__
except:
__loginUserColumn__=None
username=req_dict.get(list(req_dict.keys())[0])
if __loginUserColumn__:
username_str=__loginUserColumn__
else:
username_str=username
if 'mima' in columns:
password_str='mima'
else:
password_str='password'
init_pwd = '123456'
recordsParam = {}
recordsParam[username_str] = req_dict.get("username")
records=kehuguanxi.getbyparams(kehuguanxi, kehuguanxi, recordsParam)
if len(records)<1:
msg['code'] = 400
msg['msg'] = '用户不存在'
return JsonResponse(msg, encoder=CustomJsonEncoder)
eval('''kehuguanxi.objects.filter({}='{}').update({}='{}')'''.format(username_str,username,password_str,init_pwd))
return JsonResponse(msg, encoder=CustomJsonEncoder)
def kehuguanxi_session(request):
'''
'''
if request.method in ["POST", "GET"]:
msg = {"code": normal_code,"msg": mes.normal_code, "data": {}}
req_dict={"id":request.session.get('params').get("id")}
msg['data'] = kehuguanxi.getbyparams(kehuguanxi, kehuguanxi, req_dict)[0]
return JsonResponse(msg, encoder=CustomJsonEncoder)
def kehuguanxi_default(request):
if request.method in ["POST", "GET"]:
msg = {"code": normal_code,"msg": mes.normal_code, "data": {}}
req_dict = request.session.get("req_dict")
req_dict.update({"isdefault":"是"})
data=kehuguanxi.getbyparams(kehuguanxi, kehuguanxi, req_dict)
if len(data)>0:
msg['data'] = data[0]
else:
msg['data'] = {}
return JsonResponse(msg, encoder=CustomJsonEncoder)
def kehuguanxi_page(request):
'''
'''
if request.method in ["POST", "GET"]:
msg = {"code": normal_code, "msg": mes.normal_code, "data":{"currPage":1,"totalPage":1,"total":1,"pageSize":10,"list":[]}}
req_dict = request.session.get("req_dict")
global kehuguanxi
#获取全部列名
columns= kehuguanxi.getallcolumn( kehuguanxi, kehuguanxi)
if "vipread" in req_dict and "vipread" not in columns:
del req_dict["vipread"]
#当前登录用户所在表
tablename = request.session.get("tablename")
'''__authSeparate__此属性为真，params添加userid，后台只查询个人数据'''
try:
__authSeparate__=kehuguanxi.__authSeparate__
except:
__authSeparate__=None
if __authSeparate__=="是":
tablename=request.session.get("tablename")
if tablename!="users" and 'userid' in columns and 'userid' not in req_dict:
try:
req_dict['userid']=request.session.get("params").get("id")
except:
pass
#当项目属性hasMessage为”是”，生成系统自动生成留言板的表messages，同时该表的表属性hasMessage也被设置为”是”,字段包括userid（用户id），username(用户名)，content（留言内容），reply（回复）
#接口page需要区分权限，普通用户查看自己的留言和回复记录，管理员查看所有的留言和回复记录
try:
__hasMessage__=kehuguanxi.__hasMessage__
except:
__hasMessage__=None
if __hasMessage__=="是":
tablename=request.session.get("tablename")
if tablename!="users":
req_dict["userid"]=request.session.get("params").get("id")
# 判断当前表的表属性isAdmin,为真则是管理员表
# 当表属性isAdmin=”是”,刷出来的用户表也是管理员，即page和list可以查看所有人的考试记录(同时应用于其他表)
__isAdmin__ = None
allModels = apps.get_app_config('main').get_models()
for m in allModels:
if m.__tablename__==tablename:
try:
__isAdmin__ = m.__isAdmin__
except:
__isAdmin__ = None
break
# 当前表也是有管理员权限的表
if __isAdmin__ == "是" and 'kehuguanxi' != 'forum' :
if req_dict.get("userid") and 'kehuguanxi' != 'chat' and 'kehuguanxi' != 'examrecord':
del req_dict["userid"]
else:
if tablename!="users" and tablename!="jdfnl" and 'kehuguanxi'[:7]!='discuss' and "userid" in kehuguanxi.getallcolumn(kehuguanxi,kehuguanxi):
req_dict["userid"] = request.session.get("params").get("id")
#当列属性authTable有值(某个用户表)[该列的列名必须和该用户表的登陆字段名一致]，则对应的表有个隐藏属性authTable为”是”，那么该用户查看该表信息时，只能查看自己的
try:
__authTables__=kehuguanxi.__authTables__
except:
__authTables__=None
if __authTables__!=None and __authTables__!={} and __isAdmin__ == "是":
for authColumn,authTable in __authTables__.items():
if authTable==tablename:
params = request.session.get("params")
req_dict[authColumn]=params.get(authColumn)
username=params.get(authColumn)
break
if tablename == 'kefurenyuan':
from .models import kefurenyuan
req_dict['kefuyuanzhanghao'] = request.session.get("params").get(kefurenyuan.__loginUserColumn__)
if 'userid' in req_dict.keys():
del req_dict["userid"]
q = Q()
msg['data']['list'], msg['data']['currPage'], msg['data']['totalPage'], msg['data']['total'], \
msg['data']['pageSize'] =kehuguanxi.page(kehuguanxi, kehuguanxi, req_dict, request, q)
return JsonResponse(msg, encoder=CustomJsonEncoder)
def kehuguanxi_autoSort(request):
'''
．智能推荐功能(表属性：[intelRecom（是/否）],新增clicktime[前端不显示该字段]字段（调用info/detail接口的时候更新），按clicktime排序查询)
主要信息列表（如商品列表，新闻列表）中使用，显示最近点击的或最新添加的5条记录就行
'''
if request.method in ["POST", "GET"]:
msg = {"code": normal_code, "msg": mes.normal_code, "data":{"currPage":1,"totalPage":1,"total":1,"pageSize":10,"list":[]}}
req_dict = request.session.get("req_dict")
if "clicknum" in kehuguanxi.getallcolumn(kehuguanxi,kehuguanxi):
req_dict['sort']='clicknum'
elif "browseduration" in kehuguanxi.getallcolumn(kehuguanxi,kehuguanxi):
req_dict['sort']='browseduration'
else:
req_dict['sort']='clicktime'
req_dict['order']='desc'
msg['data']['list'], msg['data']['currPage'], msg['data']['totalPage'], msg['data']['total'], \
msg['data']['pageSize'] = kehuguanxi.page(kehuguanxi,kehuguanxi, req_dict)
return JsonResponse(msg, encoder=CustomJsonEncoder)
#分类列表
def kehuguanxi_lists(request):
if request.method in ["POST", "GET"]:
msg = {"code": normal_code, "msg": mes.normal_code, "data":[]}
msg['data'],_,_,_,_ = kehuguanxi.page(kehuguanxi, kehuguanxi, {})
return JsonResponse(msg, encoder=CustomJsonEncoder)
def kehuguanxi_query(request):
'''
'''
if request.method in ["POST", "GET"]:
msg = {"code": normal_code, "msg": mes.normal_code, "data": {}}
try:
query_result = kehuguanxi.objects.filter(**request.session.get("req_dict")).values()
msg['data'] = query_result[0]
except Exception as e:
msg['code'] = crud_error_code
msg['msg'] = f"发生错误：{e}"
return JsonResponse(msg, encoder=CustomJsonEncoder)
def kehuguanxi_list(request):
'''
前台分页
'''
if request.method in ["POST", "GET"]:
msg = {"code": normal_code, "msg": mes.normal_code, "data":{"currPage":1,"totalPage":1,"total":1,"pageSize":10,"list":[]}}
req_dict = request.session.get("req_dict")
#获取全部列名
columns= kehuguanxi.getallcolumn( kehuguanxi, kehuguanxi)
if "vipread" in req_dict and "vipread" not in columns:
del req_dict["vipread"]
#表属性[foreEndList]前台list:和后台默认的list列表页相似,只是摆在前台,否:指没有此页,是:表示有此页(不需要登陆即可查看),前要登:表示有此页且需要登陆后才能查看
try:
__foreEndList__=kehuguanxi.__foreEndList__
except:
__foreEndList__=None
try:
__foreEndListAuth__=kehuguanxi.__foreEndListAuth__
except:
__foreEndListAuth__=None
#authSeparate
try:
__authSeparate__=kehuguanxi.__authSeparate__
except:
__authSeparate__=None
if __foreEndListAuth__ =="是" and __authSeparate__=="是":
tablename=request.session.get("tablename")
if tablename!="users" and request.session.get("params") is not None:
req_dict['userid']=request.session.get("params").get("id")
tablename = request.session.get("tablename")
if tablename == "users" and req_dict.get("userid") != None:#判断是否存在userid列名
del req_dict["userid"]
else:
__isAdmin__ = None
allModels = apps.get_app_config('main').get_models()
for m in allModels:
if m.__tablename__==tablename:
try:
__isAdmin__ = m.__isAdmin__
except:
__isAdmin__ = None
break
if __isAdmin__ == "是":
if req_dict.get("userid"):
# del req_dict["userid"]
pass
else:
#非管理员权限的表,判断当前表字段名是否有userid
if "userid" in columns:
try:
pass
except:
pass
#当列属性authTable有值(某个用户表)[该列的列名必须和该用户表的登陆字段名一致]，则对应的表有个隐藏属性authTable为”是”，那么该用户查看该表信息时，只能查看自己的
try:
__authTables__=kehuguanxi.__authTables__
except:
__authTables__=None
if __authTables__!=None and __authTables__!={} and __foreEndListAuth__=="是":
for authColumn,authTable in __authTables__.items():
if authTable==tablename:
try:
del req_dict['userid']
except:
pass
params = request.session.get("params")
req_dict[authColumn]=params.get(authColumn)
username=params.get(authColumn)
break
if kehuguanxi.__tablename__[:7]=="discuss":
try:
del req_dict['userid']
except:
pass
q = Q()
msg['data']['list'], msg['data']['currPage'], msg['data']['totalPage'], msg['data']['total'], \
msg['data']['pageSize'] = kehuguanxi.page(kehuguanxi, kehuguanxi, req_dict, request, q)
return JsonResponse(msg, encoder=CustomJsonEncoder)
def kehuguanxi_save(request):
'''
后台新增
'''
request.funname = __name__+"."+kehuguanxi_save.__name__
request.operation = "新增客户关系"
if request.method in ["POST", "GET"]:
msg = {"code": normal_code, "msg": mes.normal_code, "data": {}}
req_dict = request.session.get("req_dict")
if 'clicktime' in req_dict.keys():
del req_dict['clicktime']
tablename=request.session.get("tablename")
__isAdmin__ = None
allModels = apps.get_app_config('main').get_models()
for m in allModels:
if m.__tablename__==tablename:
try:
__isAdmin__ = m.__isAdmin__
except:
__isAdmin__ = None
break
#获取全部列名
columns= kehuguanxi.getallcolumn( kehuguanxi, kehuguanxi)
if tablename!='users' and req_dict.get("userid")==None and 'userid' in columns and __isAdmin__!='是':
params=request.session.get("params")
req_dict['userid']=params.get('id')
if 'addtime' in req_dict.keys():
del req_dict['addtime']
idOrErr= kehuguanxi.createbyreq(kehuguanxi,kehuguanxi, req_dict)
if idOrErr is Exception:
msg['code'] = crud_error_code
msg['msg'] = idOrErr
else:
msg['data'] = idOrErr
return JsonResponse(msg, encoder=CustomJsonEncoder)
def kehuguanxi_add(request):
'''
前台新增
'''
request.funname = __name__+"."+kehuguanxi_add.__name__
request.operation = "新增客户关系"
if request.method in ["POST", "GET"]:
msg = {"code": normal_code, "msg": mes.normal_code, "data": {}}
req_dict = request.session.get("req_dict")
tablename=request.session.get("tablename")
#获取全部列名
columns= kehuguanxi.getallcolumn( kehuguanxi, kehuguanxi)
try:
__authSeparate__=kehuguanxi.__authSeparate__
except:
__authSeparate__=None
if __authSeparate__=="是":
tablename=request.session.get("tablename")
if tablename!="users" and 'userid' in columns:
try:
req_dict['userid']=request.session.get("params").get("id")
except:
pass
try:
__foreEndListAuth__=kehuguanxi.__foreEndListAuth__
except:
__foreEndListAuth__=None
if __foreEndListAuth__ and __foreEndListAuth__!="否":
tablename=request.session.get("tablename")
if tablename!="users":
req_dict['userid']=request.session.get("params").get("id")
if 'addtime' in req_dict.keys():
del req_dict['addtime']
error= kehuguanxi.createbyreq(kehuguanxi,kehuguanxi, req_dict)
if error is Exception:
msg['code'] = crud_error_code
msg['msg'] = error
else:
msg['data'] = error
return JsonResponse(msg, encoder=CustomJsonEncoder)
def kehuguanxi_thumbsup(request,id_):
'''
点赞：表属性thumbsUp[是/否]，刷表新增thumbsupnum赞和crazilynum踩字段，
'''
if request.method in ["POST", "GET"]:
msg = {"code": normal_code, "msg": mes.normal_code, "data": {}}
req_dict = request.session.get("req_dict")
id_=int(id_)
type_=int(req_dict.get("type",0))
rets=kehuguanxi.getbyid(kehuguanxi,kehuguanxi,id_)
update_dict={
"id":id_,
}
if type_==1:#赞
update_dict["thumbsupnum"]=int(rets[0].get('thumbsupnum'))+1
elif type_==2:#踩
update_dict["crazilynum"]=int(rets[0].get('crazilynum'))+1
error = kehuguanxi.updatebyparams(kehuguanxi,kehuguanxi, update_dict)
if error!=None:
msg['code'] = crud_error_code
msg['msg'] = error
return JsonResponse(msg, encoder=CustomJsonEncoder)
def kehuguanxi_info(request,id_):
'''
'''
if request.method in ["POST", "GET"]:
msg = {"code": normal_code, "msg": mes.normal_code, "data": {}}
data = kehuguanxi.getbyid(kehuguanxi,kehuguanxi, int(id_))
if len(data)>0:
msg['data']=data[0]
if msg['data'].__contains__("reversetime"):
if isinstance(msg['data']['reversetime'], datetime.datetime):
msg['data']['reversetime'] = msg['data']['reversetime'].strftime("%Y-%m-%d %H:%M:%S")
else:
if msg['data']['reversetime'] != None:
reversetime = datetime.datetime.strptime(msg['data']['reversetime'], '%Y-%m-%d %H:%M:%S')
msg['data']['reversetime'] = reversetime.strftime("%Y-%m-%d %H:%M:%S")
#浏览点击次数
try:
__browseClick__= kehuguanxi.__browseClick__
except:
__browseClick__=None
if __browseClick__=="是" and "clicknum" in kehuguanxi.getallcolumn(kehuguanxi,kehuguanxi):
try:
clicknum=int(data[0].get("clicknum",0))+1
except:
clicknum=0+1
click_dict={"id":int(id_),"clicknum":clicknum,"clicktime":datetime.datetime.now()}
ret=kehuguanxi.updatebyparams(kehuguanxi,kehuguanxi,click_dict)
if ret!=None:
msg['code'] = crud_error_code
msg['msg'] = ret
return JsonResponse(msg, encoder=CustomJsonEncoder)
def kehuguanxi_detail(request,id_):
'''
'''
if request.method in ["POST", "GET"]:
msg = {"code": normal_code, "msg": mes.normal_code, "data": {}}
data =kehuguanxi.getbyid(kehuguanxi,kehuguanxi, int(id_))
if len(data)>0:
msg['data']=data[0]
if msg['data'].__contains__("reversetime"):
if isinstance(msg['data']['reversetime'], datetime.datetime):
msg['data']['reversetime'] = msg['data']['reversetime'].strftime("%Y-%m-%d %H:%M:%S")
else:
if msg['data']['reversetime'] != None:
reversetime = datetime.datetime.strptime(msg['data']['reversetime'], '%Y-%m-%d %H:%M:%S')
msg['data']['reversetime'] = reversetime.strftime("%Y-%m-%d %H:%M:%S")
#浏览点击次数
try:
__browseClick__= kehuguanxi.__browseClick__
except:
__browseClick__=None
if __browseClick__=="是" and "clicknum" in kehuguanxi.getallcolumn(kehuguanxi,kehuguanxi):
try:
clicknum=int(data[0].get("clicknum",0))+1
except:
clicknum=0+1
click_dict={"id":int(id_),"clicknum":clicknum,"clicktime":datetime.datetime.now()}
ret=kehuguanxi.updatebyparams(kehuguanxi,kehuguanxi,click_dict)
if ret!=None:
msg['code'] = crud_error_code
msg['msg'] = ret
return JsonResponse(msg, encoder=CustomJsonEncoder)
def kehuguanxi_update(request):
'''
'''
request.funname = __name__+"."+kehuguanxi_update.__name__
request.operation = "更新客户关系"
if request.method in ["POST", "GET"]:
msg = {"code": normal_code, "msg": mes.normal_code, "data": {}}
req_dict = request.session.get("req_dict")
if 'clicktime' in req_dict.keys() and req_dict['clicktime']=="None":
del req_dict['clicktime']
if req_dict.get("mima") and "mima" not in kehuguanxi.getallcolumn(kehuguanxi,kehuguanxi) :
del req_dict["mima"]
if req_dict.get("password") and "password" not in kehuguanxi.getallcolumn(kehuguanxi,kehuguanxi) :
del req_dict["password"]
try:
del req_dict["clicknum"]
except:
pass
error = kehuguanxi.updatebyparams(kehuguanxi, kehuguanxi, req_dict)
if error!=None:
msg['code'] = crud_error_code
msg['msg'] = error
return JsonResponse(msg)
def kehuguanxi_delete(request):
'''
批量删除
'''
request.funname = __name__+"."+kehuguanxi_delete.__name__
request.operation = "删除客户关系"
if request.method in ["POST", "GET"]:
msg = {"code": normal_code, "msg": mes.normal_code, "data": {}}
req_dict = request.session.get("req_dict")
error=kehuguanxi.deletes(kehuguanxi,
kehuguanxi,
req_dict.get("ids")
)
if error!=None:
msg['code'] = crud_error_code
msg['msg'] = error
return JsonResponse(msg)
def kehuguanxi_vote(request,id_):
'''
浏览点击次数（表属性[browseClick:是/否]，点击字段（clicknum），调用info/detail接口的时候后端自动+1）、投票功能（表属性[vote:是/否]，投票字段（votenum）,调用vote接口后端votenum+1）
统计商品或新闻的点击次数；提供新闻的投票功能
'''
if request.method in ["POST", "GET"]:
msg = {"code": normal_code, "msg": mes.normal_code}
data= kehuguanxi.getbyid(kehuguanxi, kehuguanxi, int(id_))
for i in data:
votenum=i.get('votenum')
if votenum!=None:
params={"id":int(id_),"votenum":votenum+1}
error=kehuguanxi.updatebyparams(kehuguanxi,kehuguanxi,params)
if error!=None:
msg['code'] = crud_error_code
msg['msg'] = error
return JsonResponse(msg)
def kehuguanxi_importExcel(request):
request.funname = __name__+"."+kehuguanxi_importExcel.__name__
request.operation = "导入客户关系"
if request.method in ["POST", "GET"]:
msg = {"code": normal_code, "msg": "成功", "data": {}}
excel_file = request.FILES.get("file", "")
if excel_file.size > 100 * 1024 * 1024: # 限制为 100MB
msg['code'] = 400
msg["msg"] = '文件大小不能超过100MB'
return JsonResponse(msg)
file_type = excel_file.name.split('.')[1]
if file_type in ['xlsx', 'xls']:
data = xlrd.open_workbook(filename=None, file_contents=excel_file.read())
table = data.sheets()[0]
rows = table.nrows
try:
for row in range(1, rows):
row_values = table.row_values(row)
req_dict = {}
kehuguanxi.createbyreq(kehuguanxi, kehuguanxi, req_dict)
except:
pass
else:
msg = {
"msg": "文件类型错误",
"code": 500
}
return JsonResponse(msg)
def kehuguanxi_autoSort2(request):
return JsonResponse({"code": 0, "msg": '', "data":{}})
获取源码或论文
如需对应的论文或源码，以及其他定制需求，也可以下方微信联系我。
扫一扫
1725
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
