def get(self): getActivityId = int(str(self.request.url).split('/Sendmail/id_')[1]) searchActivityInfos = Activitydb.gql("WHERE activity_id = :1",getActivityId) searchActivityInfo = searchActivityInfos.get() searchMailInfos = Maildb.all() #get activity info. for searchinfo in searchMailInfos: name = searchinfo.name activity_name = searchActivityInfo.activity_name sign_start = str(searchActivityInfo.sign_start) sign_end = str(searchActivityInfo.sign_end) activity_start = str(searchActivityInfo.activity_start) activity_end = str(searchActivityInfo.activity_end) mail.send_mail(sender="*****@*****.**", #use admin mail to=searchinfo.mail, subject=u"[活動通知]"+activity_name+u"~ 準備開跑嚕!", body= name+ u" ,您好:"+"\n\n" u"本團隊預定在 "+activity_start+u"將舉辦『" +activity_name + u"』活動"+ "\n" u"報名的時間從 "+sign_start+ u"開放網路報名," + "\n" u"由於名額有限,若有意願想參加,請儘速進入活動網頁報名。" + "\n\n" u"\t詳細活動時間: "+ activity_start + " ~ " + activity_end + "\n" u"\t詳細報名時間:"+ sign_start+ " ~ " +sign_end+"\n\n" u"竭誠邀請您的參與\n\n輔大雲端服務中心 敬上\n\nhttp://xxxx.com" ) self.redirect('/admin')
def post(self): getId = int(self.request.get('activity_id')) deltemp = db.GqlQuery("SELECT * FROM Activitydb WHERE activity_id = :1",getId) result = deltemp.get() db.delete(result) activity = Activitydb() activity.activity_name = self.request.get('activity_name') activity.content = self.request.get('content') sign_start_Date = str(self.request.get('sign_StartDateTime')).split(" ")[0] sign_start_Time = str(self.request.get('sign_StartDateTime')).split(" ")[1] sign_end_Date = str(self.request.get('sign_EndDateTime')).split(" ")[0] sign_end_Time = str(self.request.get('sign_EndDateTime')).split(" ")[1] activity_start_Date = str(self.request.get('activity_StartDateTime')).split(" ")[0] activity_start_Time = str(self.request.get('activity_StartDateTime')).split(" ")[1] activity_end_Date = str(self.request.get('activity_EndDateTime')).split(" ")[0] activity_end_Time = str(self.request.get('activity_EndDateTime')).split(" ")[1] arr_sign_start_Date = str(sign_start_Date).split("-") arr_sign_start_Time = str(sign_start_Time).split(":") arr_sign_end_Date = str(sign_end_Date).split("-") arr_sign_end_Time = str(sign_end_Time).split(":") arr_activity_start_Date = str(activity_start_Date).split("-") arr_activity_start_Time = str(activity_start_Time).split(":") arr_activity_end_Date = str(activity_end_Date).split("-") arr_activity_end_Time = str(activity_end_Time).split(":") #input time formula: datetime.combine(Date,Time) #Date : date( int(Year),int(Month),int(Date) ) Time : time( int(hour),int(minute) ) activity.sign_start = datetime.combine(date(int(arr_sign_start_Date[0]),int(arr_sign_start_Date[1]),int(arr_sign_start_Date[2])),time(int(arr_sign_start_Time[0]),int(arr_sign_start_Time[1]),int(arr_sign_start_Time[2]))) activity.sign_end = datetime.combine(date(int(arr_sign_end_Date[0]),int(arr_sign_end_Date[1]),int(arr_sign_end_Date[2])),time(int(arr_sign_end_Time[0]),int(arr_sign_end_Time[1]),int(arr_sign_end_Time[2]))) activity.activity_start = datetime.combine(date(int(arr_activity_start_Date[0]),int(arr_activity_start_Date[1]),int(arr_activity_start_Date[2])),time(int(arr_activity_start_Time[0]),int(arr_activity_start_Time[1]),int(arr_activity_start_Time[2]))) activity.activity_end = datetime.combine(date(int(arr_activity_end_Date[0]),int(arr_activity_end_Date[1]),int(arr_activity_end_Date[2])),time(int(arr_activity_end_Time[0]),int(arr_activity_end_Time[1]),int(arr_activity_end_Time[2]))) activity.site = self.request.get('site') activity.limit_num = int(self.request.get('limit_num')) activity.activity_id = int(self.request.get('activity_id')) activity.put() #self.redirect('/ActivityModify/Main') self.response.out.write( " <script> self.close(); </script> ")
def post(self): activity = Activitydb() activity.activity_name = self.request.get('activity_name') activity.content = self.request.get('content') sign_start_Date = str(self.request.get('sign_StartDateTime')).split(" ")[0] sign_start_Time = str(self.request.get('sign_StartDateTime')).split(" ")[1] sign_end_Date = str(self.request.get('sign_EndDateTime')).split(" ")[0] sign_end_Time = str(self.request.get('sign_EndDateTime')).split(" ")[1] activity_start_Date = str(self.request.get('activity_StartDateTime')).split(" ")[0] activity_start_Time = str(self.request.get('activity_StartDateTime')).split(" ")[1] activity_end_Date = str(self.request.get('activity_EndDateTime')).split(" ")[0] activity_end_Time = str(self.request.get('activity_EndDateTime')).split(" ")[1] arr_sign_start_Date = str(sign_start_Date).split("-") arr_sign_start_Time = str(sign_start_Time).split(":") arr_sign_end_Date = str(sign_end_Date).split("-") arr_sign_end_Time = str(sign_end_Time).split(":") arr_activity_start_Date = str(activity_start_Date).split("-") arr_activity_start_Time = str(activity_start_Time).split(":") arr_activity_end_Date = str(activity_end_Date).split("-") arr_activity_end_Time = str(activity_end_Time).split(":") #input time formula: datetime.combine(Date,Time) #Date : date( int(Year),int(Month),int(Date) ) Time : time( int(hour),int(minute) ) activity.sign_start = datetime.combine(date(int(arr_sign_start_Date[0]),int(arr_sign_start_Date[1]),int(arr_sign_start_Date[2])),time(int(arr_sign_start_Time[0]),int(arr_sign_start_Time[1]),int(arr_sign_start_Time[2]))) activity.sign_end = datetime.combine(date(int(arr_sign_end_Date[0]),int(arr_sign_end_Date[1]),int(arr_sign_end_Date[2])),time(int(arr_sign_end_Time[0]),int(arr_sign_end_Time[1]),int(arr_sign_end_Time[2]))) activity.activity_start = datetime.combine(date(int(arr_activity_start_Date[0]),int(arr_activity_start_Date[1]),int(arr_activity_start_Date[2])),time(int(arr_activity_start_Time[0]),int(arr_activity_start_Time[1]),int(arr_activity_start_Time[2]))) activity.activity_end = datetime.combine(date(int(arr_activity_end_Date[0]),int(arr_activity_end_Date[1]),int(arr_activity_end_Date[2])),time(int(arr_activity_end_Time[0]),int(arr_activity_end_Time[1]),int(arr_activity_end_Time[2]))) activity.site = self.request.get('site') if self.request.get('limit_num') != "" : activity.limit_num = int(self.request.get('limit_num')) #activity.activity_id = int(self.request.get('activity_id')) searchinfo = db.GqlQuery("SELECT * FROM Activitydb ORDER BY activity_id DESC") #排序為了取的活動最大編號 search_result = searchinfo.get(); if self.request.get('activity_id') != "" : activity.activity_id = int(self.request.get('activity_id')) #使用基本設定<目前只容許到10000> else: if search_result == None: activity.activity_id = 10000;#第一筆活動 else: activity.activity_id = search_result.activity_id+1 #目前設定 activity.put() self.redirect('/Sendmail/id_'+str(activity.activity_id)) #to send mail<must to modify>