【Django】利用Django调用短信群发接口功能

短信群发接口功能"/>

【Django】利用Django调用短信群发接口功能

实现原理

UI界面

代码

插件notice.py实现调用短信接口功能

#引入依赖对象
from suds.client import Client
from suds.sudsobject import asdict#选择webservice 接口 url
#！！！注意，使用前一定要检查 url 是否正常 
sap_url_ = "*****"
id="*****"
sysName="*****"#编写方法进行访问
def obtain_by_serial(mobile,content):try:#添加用户认证也是相当简单，当然，如果没有说明文件估计也是丈二的和尚，#我也是找了好久才找到认证用户和密码的正确填写方式client = Client(sap_url_)# print(client)#传参调用接口response = client.service.SendSMSById(id, sysName, mobile, content)print(mobile,response)return responseexcept Exception as e:print(e)return e

views.py实现调用插件notice.py

# 群发消息
@login_required
def send_mail(request):if request.method == "POST":  #验证POSTuf = UploadEmployeeForm(request.POST,request.FILES) #.post是获取post返回字段，.FILES是获取返回的文件# print(uf)print(request.FILES['uploadfile'])content = request.POST['shortmail_text']result_address = request.POST['result_address']print('content',content)print('result_address',result_address)print('-----------')message = []if uf.is_valid() and content: #判断前台返回的表单是否为有效的类型ShortMail_Mobile_list = []wb = load_workbook(filename=request.FILES['uploadfile'])print(wb)ws = wb.get_sheet_names()ws = wb.get_sheet_by_name(ws[0])max_row = ws.max_rowfor row in range(2,max_row+1):#获取表单元素ShortMail_Mobile = ws.cell(row=row,column=3).value#非空则放入列表if ShortMail_Mobile:ShortMail_Mobile_list.append(ShortMail_Mobile)print('ShortMail_Mobile',ShortMail_Mobile)result = obtain_by_serial(ShortMail_Mobile, content)# 结果写入表格print('result',result)#ws.cell(row=row,column=10).value = str(result).ws.cell(row=row,column=10).value = str(result)try:wb.save(result_address+os.path.sep+'result.xlsx')except Exception as e:print(e)return render(request,'successful.html',locals())else:uf = UploadEmployeeForm()return render(request,'send_shortmail.html',{'uf':uf})

template/send_shortmail.html

{% extends 'base.html' %}
{% load static %}{% block body_block %}<div class="p-3 m-3"><!-- <div class="p-1 m-1"><h3>WZS HR短信群发平台</h3></div> --><div class="p-1 m-1"><h5>1.请按格式上传excel文件</h5></div><div class="pl-5"><a class="btn btn-secondary" href="/download_format">下载模板</a></div><br><form enctype="multipart/form-data" action="" method="POST">{% csrf_token %}<div class="pl-5">{{uf.as_p}}</div><div class="p-1 m-1"><h5>2.请填写短信文本</h5></div><br><textarea  rows="5" cols="20" class="form-control w-50" type="text" name="shortmail_text" style="font-size:10px;"></textarea><br><div class="p-1 m-1"><h5>3.发送结果保存地址(everyone权限的公共盘)</h5></div><div class="p-1 m-1"><input name="result_address" class="form-control w-50" value="******"/></div><div class="pl-5"><input class="btn btn-secondary" type="submit" value="确认群发短信"/></div></form></div>{% endblock %}{% block footer_block %}
<br>
<br>{% endblock %}