def manual_sms(request):
print request.method
if request.method == 'POST':
#sendSMS('123','check sendSMS function', request.user)
#return HttpResponseRedirect(reverse('sent_sms'))
# return HttpResponse(request.POST.getlist('receiver'))
receiver_list = request.POST.getlist('receiver')
phone_list = request.POST['phone']
content = request.POST['content']
if ((len(phone_list) != 0 and len(content) != 0) or\
(len(receiver_list) != 0 and len(content) != 0) ):
# update all record in sms db: recent = false
all_sms = sms.objects.filter(sender=request.user)
for s in all_sms:
s.recent = False
s.save()
phone = []
for r in receiver_list:
user = User.objects.get(username=r)
try:
phone.append(user.get_profile().phone)
except:
pass
for p1 in phone_list.split(','):
p1 = p1.split(';')
for p2 in p1:
p2 = p2.split()
for p3 in p2:
phone.append(p3)
open = urllib2.build_opener(urllib2.HTTPCookieProcessor())
urllib2.install_opener(open)
para = urllib.urlencode({'u': 'VT_username', 'p': 'VT_password'})
# f = open.open('http://viettelvas.vn:7777/fromcp.asmx', para)
# f.close();
for p in phone:
if checkValidPhoneNumber(p):
'''Save to db'''
s = sms(phone=p, receiver=getUserFromPhone(p), content=content, sender=request.user, recent=True, success=True)
s.save()
'''Send sms via Viettel system'''
data = urllib.urlencode({
'RequestID' : '4',
'CPCode' : '',
'UserID' : '',
'ReceiverID' : p,
'ServiceID' : '',
'CommandCode' : '',
'Content' : content,
'ContentType' : '',
})
# f = open.open('http://viettelvas.vn:7777/fromcp.asmx', data)
else:
'''Save to db'''
s = sms(phone=p, receiver=getUserFromPhone(p), content=content, sender=request.user, recent=True, success=False)
s.save()
return HttpResponseRedirect(reverse('sent_sms'))
else:
if(len(content)==0):
content_error = 'Hãy nhập nội dung tin nhắn!'
else:
content_error = ''
if(len(phone_list)==0 and len(receiver_list)==0):
phone_error = 'Hãy nhập số điện thoại người nhận, hoặc chọn trong danh sách bên trên.'
else:
phone_error = ''
user = User.objects.filter()
user_list = []
for u in user:
try:
if (u.get_profile().position in ['HIEU_TRUONG','HIEU_PHO','TRUONG_PHONG','GIAM_DOC_SO']):
user_list.append(u)
except:
pass
t = loader.get_template('school/manual_sms.html')
c = RequestContext(request, {'user_list': user_list,
'content_error': content_error,
'phone_error': phone_error})
return HttpResponse(t.render(c))
else:
user = User.objects.all()
user_list = []
for u in user:
try:
if (u.get_profile().position in ['HIEU_TRUONG','HIEU_PHO','TRUONG_PHONG','GIAM_DOC_SO']\
and not u.is_superuser):
user_list.append(u)
except:
pass
print "right view"
t = loader.get_template('school/manual_sms.html')
c = RequestContext(request, {'user_list': user_list})
return HttpResponse(t.render(c))
def manual_sms(request):
print request.method
if request.method == 'POST':
#sendSMS('123','check sendSMS function', request.user)
#return HttpResponseRedirect(reverse('sent_sms'))
# return HttpResponse(request.POST.getlist('receiver'))
receiver_list = request.POST.getlist('receiver')
phone_list = request.POST['phone']
content = request.POST['content']
if ((len(phone_list) != 0 and len(content) != 0) or\
(len(receiver_list) != 0 and len(content) != 0) ):
# update all record in sms db: recent = false
all_sms = sms.objects.filter(sender=request.user)
for s in all_sms:
s.recent = False
s.save()
phone = []
for r in receiver_list:
user = User.objects.get(username=r)
try:
phone.append(user.get_profile().phone)
except:
pass
for p1 in phone_list.split(','):
p1 = p1.split(';')
for p2 in p1:
p2 = p2.split()
for p3 in p2:
phone.append(p3)
open = urllib2.build_opener(urllib2.HTTPCookieProcessor())
urllib2.install_opener(open)
para = urllib.urlencode({'u': 'VT_username', 'p': 'VT_password'})
# f = open.open('http://viettelvas.vn:7777/fromcp.asmx', para)
# f.close();
for p in phone:
if checkValidPhoneNumber(p):
'''Save to db'''
s = sms(phone=p,
receiver=getUserFromPhone(p),
content=content,
sender=request.user,
recent=True,
success=True)
s.save()
'''Send sms via Viettel system'''
data = urllib.urlencode({
'RequestID': '4',
'CPCode': '',
'UserID': '',
'ReceiverID': p,
'ServiceID': '',
'CommandCode': '',
'Content': content,
'ContentType': '',
})
# f = open.open('http://viettelvas.vn:7777/fromcp.asmx', data)
else:
'''Save to db'''
s = sms(phone=p,
receiver=getUserFromPhone(p),
content=content,
sender=request.user,
recent=True,
success=False)
s.save()
return HttpResponseRedirect(reverse('sent_sms'))
else:
if (len(content) == 0):
content_error = 'Hãy nhập nội dung tin nhắn!'
else:
content_error = ''
if (len(phone_list) == 0 and len(receiver_list) == 0):
phone_error = 'Hãy nhập số điện thoại người nhận, hoặc chọn trong danh sách bên trên.'
else:
phone_error = ''
user = User.objects.filter()
user_list = []
for u in user:
try:
if (u.get_profile().position in [
'HIEU_TRUONG', 'HIEU_PHO', 'TRUONG_PHONG',
'GIAM_DOC_SO'
]):
user_list.append(u)
except:
pass
t = loader.get_template('school/manual_sms.html')
c = RequestContext(
request, {
'user_list': user_list,
'content_error': content_error,
'phone_error': phone_error
})
return HttpResponse(t.render(c))
else:
user = User.objects.all()
user_list = []
for u in user:
try:
if (u.get_profile().position in ['HIEU_TRUONG','HIEU_PHO','TRUONG_PHONG','GIAM_DOC_SO']\
and not u.is_superuser):
user_list.append(u)
except:
pass
print "right view"
t = loader.get_template('school/manual_sms.html')
c = RequestContext(request, {'user_list': user_list})
return HttpResponse(t.render(c))
def excel_sms(request):
if request.method == 'POST':
if 'upload' in request.POST:
form = smsFromExcelForm(request.POST, request.FILES)
if form.is_valid():
print "what the f**k"
form.clean_file()
filepath = os.path.join(TEMP_FILE_LOCATION, 'sms_input.xls')
list = xlrd.open_workbook(filepath)
sheet = list.sheet_by_index(0)
data = []
for r in range(1, sheet.nrows):
data.append({'number': sheet.cell_value(r,0),
'content': sheet.cell_value(r,1)})
t = loader.get_template('school/excel_sms.html')
c = RequestContext(request, {'data' : data})
return HttpResponse(t.render(c))
else:
print "tag1"
if request.FILES:
file = request.FILES['file']
filepath = os.path.join(TEMP_FILE_LOCATION, 'sms_input.xls')
if not file.content_type in CONTENT_TYPES:
error = 'Bạn chỉ được phép tải lên file Excel.'
elif os.path.getsize(filepath) == 0:
os.remove(filepath)
error = 'Hãy tải lên một file Excel đúng. File của bạn hiện đang trống.'
elif xlrd.open_workbook(filepath).sheet_by_index(0).nrows == 0:
os.remove(filepath)
error = 'Hãy tải lên một file Excel đúng. File của bạn hiện đang trống.'
t = loader.get_template('school/excel_sms.html')
c = RequestContext(request, {'error' : error})
return HttpResponse(t.render(c))
else:
t = loader.get_template('school/excel_sms.html')
c = RequestContext(request)
return HttpResponse(t.render(c))
elif 'delete' in request.POST:
filepath = os.path.join(TEMP_FILE_LOCATION, 'sms_input.xls')
os.remove(filepath)
t = loader.get_template('school/excel_sms.html')
c = RequestContext(request)
return HttpResponse(t.render(c))
elif 'send' in request.POST:
# update all record in sms db: recent = false
all_sms = sms.objects.filter(sender=request.user)
for s in all_sms:
if s.recent:
s.recent = False
s.save()
filepath = os.path.join(TEMP_FILE_LOCATION, 'sms_input.xls')
list = xlrd.open_workbook(filepath)
sheet = list.sheet_by_index(0)
open = urllib2.build_opener(urllib2.HTTPCookieProcessor())
urllib2.install_opener(open)
para = urllib.urlencode({'u': 'VT_username', 'p': 'VT_password'})
# f = open.open('http://viettelvas.vn:7777/fromcp.asmx', para)
# f.close();
for r in range(1, sheet.nrows):
if checkValidPhoneNumber(sheet.cell_value(r,0)):
'''Save to db'''
s = sms(phone=sheet.cell_value(r,0), receiver=getUserFromPhone(sheet.cell_value(r,0)), content=sheet.cell_value(r,1), sender=request.user, recent=True, success=True)
s.save()
'''Send sms via Viettel system'''
data = urllib.urlencode({
'RequestID' : '4',
'CPCode' : '',
'UserID' : '',
'ReceiverID' : sheet.cell_value(r,0),
'ServiceID' : '',
'CommandCode' : '',
'Content' : sheet.cell_value(r,1),
'ContentType' : '',
})
# f = open.open('http://viettelvas.vn:7777/fromcp.asmx', data)
else:
'''Save to db'''
s = sms(phone=sheet.cell_value(r,0), receiver=getUserFromPhone(sheet.cell_value(r,0)), content=sheet.cell_value(r,1), sender=request.user, recent=True, success=False)
s.save()
os.remove(filepath)
return HttpResponseRedirect(reverse('sent_sms'))
else:
if os.path.lexists(os.path.join(TEMP_FILE_LOCATION, 'sms_input.xls')):
filepath = os.path.join(TEMP_FILE_LOCATION, 'sms_input.xls')
list = xlrd.open_workbook(filepath)
sheet = list.sheet_by_index(0)
data = []
for r in range(1, sheet.nrows):
data.append({'number': sheet.cell_value(r,0),
'content': sheet.cell_value(r,1)})
t = loader.get_template('school/excel_sms.html')
c = RequestContext(request, {'data' : data})
return HttpResponse(t.render(c))
else:
t = loader.get_template('school/excel_sms.html')
c = RequestContext(request)
return HttpResponse(t.render(c))
def excel_sms(request):
if request.method == 'POST':
if 'upload' in request.POST:
form = smsFromExcelForm(request.POST, request.FILES)
if form.is_valid():
print "what the f**k"
form.clean_file()
filepath = os.path.join(TEMP_FILE_LOCATION, 'sms_input.xls')
list = xlrd.open_workbook(filepath)
sheet = list.sheet_by_index(0)
data = []
for r in range(1, sheet.nrows):
data.append({
'number': sheet.cell_value(r, 0),
'content': sheet.cell_value(r, 1)
})
t = loader.get_template('school/excel_sms.html')
c = RequestContext(request, {'data': data})
return HttpResponse(t.render(c))
else:
print "tag1"
if request.FILES:
file = request.FILES['file']
filepath = os.path.join(TEMP_FILE_LOCATION,
'sms_input.xls')
if not file.content_type in CONTENT_TYPES:
error = 'Bạn chỉ được phép tải lên file Excel.'
elif os.path.getsize(filepath) == 0:
os.remove(filepath)
error = 'Hãy tải lên một file Excel đúng. File của bạn hiện đang trống.'
elif xlrd.open_workbook(filepath).sheet_by_index(
0).nrows == 0:
os.remove(filepath)
error = 'Hãy tải lên một file Excel đúng. File của bạn hiện đang trống.'
t = loader.get_template('school/excel_sms.html')
c = RequestContext(request, {'error': error})
return HttpResponse(t.render(c))
else:
t = loader.get_template('school/excel_sms.html')
c = RequestContext(request)
return HttpResponse(t.render(c))
elif 'delete' in request.POST:
filepath = os.path.join(TEMP_FILE_LOCATION, 'sms_input.xls')
os.remove(filepath)
t = loader.get_template('school/excel_sms.html')
c = RequestContext(request)
return HttpResponse(t.render(c))
elif 'send' in request.POST:
# update all record in sms db: recent = false
all_sms = sms.objects.filter(sender=request.user)
for s in all_sms:
if s.recent:
s.recent = False
s.save()
filepath = os.path.join(TEMP_FILE_LOCATION, 'sms_input.xls')
list = xlrd.open_workbook(filepath)
sheet = list.sheet_by_index(0)
open = urllib2.build_opener(urllib2.HTTPCookieProcessor())
urllib2.install_opener(open)
para = urllib.urlencode({'u': 'VT_username', 'p': 'VT_password'})
# f = open.open('http://viettelvas.vn:7777/fromcp.asmx', para)
# f.close();
for r in range(1, sheet.nrows):
if checkValidPhoneNumber(sheet.cell_value(r, 0)):
'''Save to db'''
s = sms(phone=sheet.cell_value(r, 0),
receiver=getUserFromPhone(sheet.cell_value(r, 0)),
content=sheet.cell_value(r, 1),
sender=request.user,
recent=True,
success=True)
s.save()
'''Send sms via Viettel system'''
data = urllib.urlencode({
'RequestID':
'4',
'CPCode':
'',
'UserID':
'',
'ReceiverID':
sheet.cell_value(r, 0),
'ServiceID':
'',
'CommandCode':
'',
'Content':
sheet.cell_value(r, 1),
'ContentType':
'',
})
# f = open.open('http://viettelvas.vn:7777/fromcp.asmx', data)
else:
'''Save to db'''
s = sms(phone=sheet.cell_value(r, 0),
receiver=getUserFromPhone(sheet.cell_value(r, 0)),
content=sheet.cell_value(r, 1),
sender=request.user,
recent=True,
success=False)
s.save()
os.remove(filepath)
return HttpResponseRedirect(reverse('sent_sms'))
else:
if os.path.lexists(os.path.join(TEMP_FILE_LOCATION, 'sms_input.xls')):
filepath = os.path.join(TEMP_FILE_LOCATION, 'sms_input.xls')
list = xlrd.open_workbook(filepath)
sheet = list.sheet_by_index(0)
data = []
for r in range(1, sheet.nrows):
data.append({
'number': sheet.cell_value(r, 0),
'content': sheet.cell_value(r, 1)
})
t = loader.get_template('school/excel_sms.html')
c = RequestContext(request, {'data': data})
return HttpResponse(t.render(c))
else:
t = loader.get_template('school/excel_sms.html')
c = RequestContext(request)
return HttpResponse(t.render(c))
