birthdays_daily.jsp

论坛软件系统亦称电子公告板(BBS)系统

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<jsp:directive.page import="cn.jsprun.utils.Cache"/>
<jsp:directive.page import="cn.jsprun.utils.BeanFactory"/>
<jsp:directive.page import="cn.jsprun.utils.DataParse" />
<jsp:directive.page import="java.text.SimpleDateFormat"/>
<jsp:directive.page import="cn.jsprun.utils.Mail"/>
<jsp:directive.page import="cn.jsprun.utils.ForumInit" />
<%@page import="cn.jsprun.utils.Common"%>
<%@page import="cn.jsprun.dao.CronsDao"%>
<%@page import="java.sql.Connection"%>
<%! 
	private String tablepre = "jrun_"; 
	private CronsDao cronsDao = ((CronsDao)BeanFactory.getBean("cronsSetDao"));
	private DataParse dataParse = (DataParse) BeanFactory.getBean("dataParse");
	
%>
<%
	int timestamp=(Integer)request.getAttribute("timestamp");
	Connection connection = (Connection)request.getAttribute("connection");
	Map<String,String> settings=ForumInit.settings;
	int maxbdays=Integer.valueOf(settings.get("maxbdays"));
	if(maxbdays>0){
		Cache cache=new Cache(application.getRealPath("/"));
		try {
			cache.updatecache("index");
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
	int bdaystatus=Integer.valueOf(settings.get("bdaystatus"));
	if(bdaystatus>0){
		String boardurl = (String)session.getAttribute("boardurl");
		SimpleDateFormat dateFormat = new SimpleDateFormat("MM-dd");
		String today = Common.gmdate(dateFormat,timestamp,(Float)session.getAttribute("timeoffset"));
		List<Map<String,String>> members = cronsDao.executeQuery(connection,"SELECT uid, username, email, bday FROM "+tablepre+"members WHERE RIGHT(bday, 5)='"+today+"' ORDER BY bday");
		if(members!=null&&members.size()>0){
			String bbname=settings.get("bbname");
			Map<String,String> mails=dataParse.characterParse(settings.get("mail"), false);
			mails.put("jsprun_root",application.getRealPath("/"));
			Mail mail=new Mail(mails);
			for(Map<String,String> member:members){
				String countent ="\n"+member.get("username")+"，\n这封信是由 "+bbname+" 发送的。\n您收到这封邮件，是因为在我们的论坛上这个邮箱地址被登记为用户邮箱，\n并且按照您填写的信息，今天是您的生日，很高兴能在此时为您献上一份\n生日祝福，我谨代表论坛管理团队，衷心祝福您生日快乐。\n如果您并非我们的会员，或今天并非您的生日，可能是有人误用了您的邮\n件地址，或错误的填写了生日信息，本邮件不会多次重复发送，请忽略这\n封邮件。\n\n\n\n\n此致\n\n"+bbname+" 管理团队.\n"+boardurl;
				mail.sendMessage(mails.get("from"),member.get("username")+" <"+member.get("email")+">","祝您生日快乐",countent,null);
			}
		}
	}

	RequestDispatcher dispatcher = request.getRequestDispatcher("/include/crons/setNextrun.jsp");
	try {
		dispatcher.include(request, response);
	} catch (Exception e) {
		e.printStackTrace();
	} 
	Map<String,String> crons = (Map<String,String>)request.getAttribute("crons");
	if("0".equals(crons.get("available"))){
		cronsDao.execute(connection,"UPDATE "+tablepre+"crons SET available='0' WHERE cronid="+crons.get("cronid"));
	}else{
		cronsDao.execute(connection,"UPDATE "+tablepre+"crons SET lastrun='"+timestamp+"',nextrun='"+crons.get("nextrun")+"' WHERE cronid="+crons.get("cronid"));
	}
%>