def send_emergency_message_unlogin():
print 'send_emergency_message_unlogin---------------'
count = 0
time_start = datetime.datetime.now() + datetime.timedelta(weeks = -1)
time_end = datetime.datetime.now()
sql = "select a.id,a.user_id,a.message_id,c.sender_id,c.body from umessages_messagerecipient a left join umessages_message c on a.message_id = c.id where c.type=1 and c.sent_at>'" + str(time_start) + "' and c.sent_at<'" + str(time_end) + "' and a.no_need_send=0 and a.is_send =0 and a.read_at is null limit 0,1000"
cursor = connection.cursor()
cursor.execute(sql)
desc = cursor.description
unread_list = [dict(zip([col[0] for col in desc], row)) for row in cursor.fetchall()]
for m in unread_list:
try:
user = User.objects.get(pk=m['user_id'])
times = Access_log.objects.filter(user=user).count()
if times == 0:
msg = Sms()
msg.sender_id = m['sender_id']
msg.receiver_id = m['user_id']
msg.mobile = User.objects.get(pk=m['user_id']).get_profile().mobile
msg.type_id = 5
msg.content = str(m['body']) + '/' + str(User.objects.get(pk=m['sender_id']).get_profile().chinese_name_or_username())
msg.save()
unread = MessageRecipient.objects.get(pk=m['id'])
unread.is_send = 1
unread.save()
count = count + 1
except:
pass
result = "send_emergency_message:"+str(count)
print result,'rrrrrrrrrrr--------------------------------------'
return result
def regist_detail(request,regist_id,template_name="oa/onlineRegistration_form.html"):
"""在线报名详情及更新"""
schools = get_schools(request.user)
regist = get_object_or_404(Registration,id=regist_id,school__in=schools)
if request.method == 'POST':
human = True
form = RegistrationForm(request.POST,instance=regist)
if form.is_valid():
r = form.save(commit=False)
r.save()
try:
mobile = r.guardians.exclude(name='').exclude(mobile='').exclude(unit='')[0].mobile
except:
mobile = None
if r.send_msg and r.msg_body and mobile:
msg = Sms()
msg.sender_id = request.user.id
msg.receiver_id = -1
msg.mobile = mobile
msg.type_id = 6
msg.content = r.msg_body + '/' + request.user.teacher.name
msg.save()
messages.success(request, '操作成功')
return redirect('oa_regist_apply_list')
else:
form = RegistrationForm(instance=regist)
guardians = regist.guardians.exclude(relation='').exclude(name='').exclude(mobile='').exclude(unit='')
guardians_count = guardians.count()
ctx = {'regist':regist,'form':form,'guardians':guardians,'range':range(4),'guardians_count':guardians_count}
return render(request, template_name, ctx)
def send_emergency_message(request):
count = 0
time_start = datetime.datetime.now() + datetime.timedelta(weeks = -1)
time_end = datetime.datetime.now() + datetime.timedelta(seconds = -300)
sql = "select a.id,a.user_id,a.message_id,c.sender_id,c.body from umessages_messagerecipient a left join umessages_message c on a.message_id = c.id where c.type=1 and c.sent_at>'" + str(time_start) + "' and c.sent_at<'" + str(time_end) + "' and a.no_need_send=0 and a.is_send =0 and a.read_at is null limit 0,1000"
cursor = connection.cursor()
cursor.execute(sql)
desc = cursor.description
unread_list = [dict(zip([col[0] for col in desc], row)) for row in cursor.fetchall()]
for m in unread_list:
msg = Sms()
msg.sender_id = m['sender_id']
msg.receiver_id = m['user_id']
msg.mobile = User.objects.get(pk=m['user_id']).get_profile().mobile
msg.type_id = 5
msg.content = m['body']
msg.save()
unread = MessageRecipient.objects.get(pk=m['id'])
unread.is_send = 1
unread.save()
count = count + 1
result = "total push message:"+str(count)
return HttpResponse(result)
def send_staff_mobile(mobile,msg):
from kinger.models import Sms
mes = Sms()
mes.sender_id = 1
mes.receiver_id = -1
mes.mobile = mobile
mes.type_id = 99
mes.content = msg
mes.save()
return True
def send_user_cookbook(user,cookbook,content):
from kinger.models import CookbookRead,Sms
c = CookbookRead.objects.set_cookbook_unread(user=user,cookbook=cookbook,ty="send")
if not c:
return False
msg = Sms()
msg.sender_id = cookbook.creator_id
msg.receiver_id = user.id
msg.mobile = user.get_profile().mobile
msg.type_id = 3
msg.content = content
msg.save()
return True
def send_user_message():
count = 0
time_limit = datetime.datetime.now() + datetime.timedelta(weeks = -1)
users = [s.user for s in Student.objects.all() if s.user.get_profile().last_access_time() < time_limit]
for user in users:
has_send = Sms.objects.filter(type_id=98,send_time__gt=time_limit,receiver_id=user.id).count()
if not has_send:
unread_count = Tile.objects.count_unread_tiles_for(user)
if unread_count:
msg = Sms()
msg.sender_id = 1
msg.receiver_id = user.id
msg.mobile = user.get_profile().mobile
msg.type_id = 98
msg.content = "您有" + str(unread_count) + "条新内容未查看，您可以登陆网站或者安装客户端来查看，详情请登录" + str(SITE_INFO.domain) + "[" + str(SITE_INFO.name) + "]"
msg.save()
count = count + 1
result = "send_user_message:"+str(count)
return result
def send_user_message(request):
count = 0
time_limit = datetime.datetime.now() + datetime.timedelta(weeks = -1)
users = [s.user for s in Student.objects.all() if s.user.get_profile().last_access_time() < time_limit]
for user in users:
has_send = Sms.objects.filter(type_id=98,send_time__gt=time_limit,receiver_id=user.id).count()
if not has_send:
unread_count = Tile.objects.count_unread_tiles_for(user)
if unread_count:
msg = Sms()
msg.sender_id = 1
msg.receiver_id = user.id
msg.mobile = user.get_profile().mobile
msg.type_id = 98
msg.content = "您有" + str(unread_count) + "条新内容未查看，您可以登陆网站或者安装客户端来查看，详情请登录 http://jytn365.com/welcom [记忆童年]"
msg.save()
count = count + 1
result = "total push user_message:"+str(count)
return HttpResponse(result)
