def full_events(events, are_events_today, htmltext, macro):
old_date = ''
event_timezone = macro.request.config.tz
# clear events that have passed
yesterday_struct = time.gmtime(time.time()-60*60*24)
yesterday = list(yesterday_struct[0:3]) + [0,0,0,0,0,0]
yesterday = calendar.timegm(yesterday)
macro.request.cursor.execute("""SELECT event_name, event_time
FROM events
WHERE event_time<%(yesterday)s and
wiki_id=%(wiki_id)s""",
{'yesterday':yesterday,
'wiki_id':macro.request.config.wiki_id})
macro.request.cursor.execute("""DELETE FROM events
WHERE event_time<%(yesterday)s and
wiki_id=%(wiki_id)s""",
{'yesterday':yesterday,
'wiki_id':macro.request.config.wiki_id})
macro.request.cursor.execute(
"""SELECT uid, event_time, posted_by, text, location, event_name
FROM events
WHERE wiki_id=%(wiki_id)s
ORDER BY event_time""", {'wiki_id':macro.request.config.wiki_id})
result = macro.request.cursor.fetchone()
while result:
events.append(result)
result = macro.request.cursor.fetchone()
current_time = macro.request.user.getFormattedDateTime(time.time())
year_cut = string.split(current_time," ")[0]
current_year = string.split(year_cut, "-")[0]
month_cut = string.split(current_time," ")[0]
current_month = string.split(month_cut,"-")[1]
day_cut = string.split(current_time," ")[0]
current_day = string.split(day_cut,"-")[2]
hour_cut = string.split(current_time," ")[1]
current_hour = string.split(hour_cut,":")[0]
minute_cut = string.split(current_time," ")[1]
current_minute = string.split(minute_cut,":")[1]
for event in events:
event_name = event[5]
# we store it as a general time and we convert it to a local time..
event_time_unix = event[1]
event_time_struct = wikiutil.timeInUnixToLocal(
macro.request.config.tz, event_time_unix)
year = event_time_struct[0]
month = event_time_struct[1]
day = event_time_struct[2]
hour = event_time_struct[3]
minute = event_time_struct[4]
posted_by = event[2]
id = event[0]
date = str(month) + " " + str(day)
if int(hour) > 12 :
read_hour = int(hour) - 12
if not int(minute) == 0:
ptime = str(read_hour) + ":" + str(minute) + " PM"
else:
ptime = str(read_hour) + ":00" + " PM"
elif int(hour) == 0:
if not int(minute) == 0:
ptime = "12:" + str(minute) + " AM"
else:
ptime = "12:00 AM"
elif int(hour) == 12:
if not int(minute) == 0:
ptime = "12:" + str(minute) + " PM"
else:
ptime = "12:00 PM"
else:
if not int(minute) == 0:
ptime = str(hour) + ":" + str(minute) + " AM"
else:
ptime = str(hour) + ":00 AM"
ptime = "%s (%s)" % (ptime, macro.request.config.tz)
# This is where we want to run through the wiki processor
text = event[3]
event_location = event[4]
processed_text = doParse(text,macro,keep_outer_paragraph=True)
processed_location = doParse(event_location,macro)
processed_name = doParse(event_name,macro)
month_dict = {1:'January', 2:'February', 3:'March', 4:'April',
5:'May', 6:'June', 7:'July', 8:'August',
9:'September', 10:'October', 11:'November',
12:'December'}
string_month = month_dict[month]
events_page = Page("Events Board", macro.request)
posted_by_user = user.User(macro.request, name=posted_by)
user_link = user.getUserLink(macro.request, posted_by_user)
if (macro.request.user.may.admin(events_page) or
posted_by == macro.request.user.propercased_name):
if date == old_date:
htmltext.append(
'<ul>\n<h4 id="head-%s">%s</h4>\n'
'<a href="%s/Events_Board?action=events&uid=%s&'
'del=1">[delete]</a>'
' <b>Time:</b> %s<br>\n'
'<b>Location:</b> %s<br>\n'
'%s(Posted by %s)\n</ul>\n' %
(id, processed_name, macro.request.getScriptname(),
id, ptime, processed_location, processed_text,
user_link))
else:
string_day = datetoday(int(day),int(month),int(year))
old_date = date
htmltext.append(
'<h2>%s, %s %s, %s</h2>\n'
'<ul><h4 id="head-%s">%s</h4>\n'
'<a href="%s/Events_Board?action=events&uid=%s&'
'del=1">[delete]</a>'
' <b>Time:</b> '
'%s \n'
'<b>Location:</b> %s<br>\n'
'%s(Posted by %s)\n</ul>\n' %
(string_day, string_month, day, year, id,
processed_name,macro.request.getScriptname(), id,
ptime, processed_location, processed_text,
user_link))
else:
if date == old_date:
htmltext.append(
'<ul>\n<h4 id="head-%s">%s</h4>\n'
'<b>Time:</b> %s<br>\n'
'<b>Location:</b> %s<br>\n'
'%s(Posted by %s)\n</ul>\n' %
(id, processed_name, ptime, processed_location,
processed_text, user_link))
else:
string_day = datetoday(int(day),int(month),int(year))
old_date = date
htmltext.append(
'<h2>%s, %s %s</h2>\n'
'<ul>\n<h4 id="head-%s">%s</h4>\n'
'<b>Time:</b> %s \n'
'<b>Location:</b> %s<br>\n'
'%s(Posted by %s)\n</ul>\n' %
(string_day, string_month, day, id, processed_name,
ptime, processed_location, processed_text,
user_link))
title = "Post a new event:"
htmltext.append(
'<h3>%s</h3>\n'
'<table border="0" cellspacing="0" cellpadding="3">\n'
'<tr><td><form method="POST" action="%s/%s">\n'
'<input type="hidden" name="action" value="events">\n'
'<input type="hidden" name="ticket" value="%s">\n'
'Event name: <input class="formfields" type="text" name="event_name"'
'size="30" maxlength="100"> \n'
'Location: <input class="formfields" type="text" '
'name="event_location" size="25" maxlength="100">'
'<br><br>\n' %
(title, macro.request.getScriptname(),
wikiutil.quoteWikiname(macro.formatter.page.proper_name()),
createTicket()))
monthstring = ('<p>Date: <select name="month">\n'
'<option value="1">January</option>\n'
'<option value="2">February</option>\n'
'<option value="3">March</option>\n'
'<option value="4">April</option>\n'
'<option value="5">May</option>\n'
'<option value="6">June</option>\n'
'<option value="7">July</option>\n '
'<option value="8">August</option>\n'
'<option value="9">September</option>\n'
'<option value="10">October</option>\n'
'<option value="11">November</option>\n'
'<option value="12">December</option>\n</select>\n')
newmonthstring = monthstring.replace(
'value="%s"' % str(int(current_month)),
'value="%s" selected' % str(int(current_month)))
htmltext.append(newmonthstring)
daystring = ('<select name="day">\n '
'<option>1</option>\n '
'<option>2</option>\n '
'<option>3</option>\n '
'<option>4</option>\n '
'<option>5</option>\n '
'<option>6</option>\n '
'<option>7</option>\n '
'<option>8</option>\n '
'<option>9</option>\n '
'<option>10</option>\n '
'<option>11</option>\n '
'<option>12</option>\n '
'<option>13</option>\n '
'<option>14</option>\n '
'<option>15</option>\n '
'<option>16</option>\n '
'<option>17</option>\n '
'<option>18</option>\n '
'<option>19</option>\n '
'<option>20</option>\n '
'<option>21</option>\n '
'<option>22</option>\n '
'<option>23</option>\n '
'<option>24</option>\n '
'<option>25</option>\n '
'<option>26</option>\n '
'<option>27</option>\n '
'<option>28</option>\n '
'<option>29</option>\n '
'<option>30</option>\n '
'<option>31</option>\n '
'</select>\n')
newdaystring = daystring.replace(">"+str(int(current_day))+"<",
" selected>"+str(int(current_day))+"<")
htmltext.append(newdaystring)
yearstring = '<select name="year">\n'
for year in yearList():
yearstring += '<option>%s</option>\n' % year
yearstring += '</select>'
newyearstring = yearstring.replace(">" + current_year + "<",
" selected>" + current_year + "<")
htmltext.append(newyearstring)
hourstring = ('Time: <select name="hour">\n '
'<option value="0">12AM</option>\n '
'<option value="1">1AM</option>\n '
'<option value="2">2AM</option>\n '
'<option value="3">3AM</option>\n '
'<option value="4">4AM</option>\n '
'<option value="5">5AM</option>\n '
'<option value="6">6AM</option>\n '
'<option value="7">7AM</option>\n '
'<option value="8">8AM</option>\n '
'<option value="9">9AM</option>\n '
'<option value="10">10AM</option>\n '
'<option value="11">11AM</option>\n '
'<option value="12">12PM</option>\n '
'<option value="13">1PM</option>\n '
'<option value="14">2PM</option>\n '
'<option value="15">3PM</option>\n '
'<option value="16">4PM</option>\n '
'<option value="17">5PM</option>\n '
'<option value="18">6PM</option>\n '
'<option value="19">7PM</option>\n '
'<option value="20">8PM</option>\n '
'<option value="21">9PM</option>\n '
'<option value="22">10PM</option>\n '
'<option value="23">11PM</option>\n '
'</select>\n')
newhourstring = hourstring.replace('value="%s"' % str(int(current_hour)),
'value="%s" selected' %
str(int(current_hour)))
htmltext.append(newhourstring)
if not str(int(int(current_minute)/10)) == 0:
rounded_min = str(int(int(current_minute)/10)) + "0"
else:
rounded_min = "0"
minutestring = (' : <select name="minute">\n '
'<option value="0">00</option>\n '
'<option value="10">10</option>\n '
'<option value="20">20</option>\n '
'<option value="30">30</option>\n '
'<option value="40">40</option>\n '
'<option value="50">50</option>\n '
'</select> (in %s)</p>\n' % event_timezone)
newminutestring = minutestring.replace('value="%s"' % rounded_min,
'value="%s" selected' % rounded_min)
htmltext.append(newminutestring)
htmltext.append(
'<textarea name="event_text" rows="5" cols="67" wrapping=yes>'
'Describe event</textarea><br>\n'
'<input class="formbutton" type="submit" name="button" '
'value="Add Event">\n'
'</form></td></tr></table>')
def full_events(events, are_events_today, htmltext, macro):
old_date = ""
# clear events that have passed
yesterday_struct = time.gmtime(time.time() - 60 * 60 * 24)
yesterday = list(yesterday_struct[0:3]) + [0, 0, 0, 0, 0, 0]
yesterday = calendar.timegm(yesterday)
macro.request.cursor.execute(
"""SELECT event_name, event_time
FROM events
WHERE event_time<%(yesterday)s and
wiki_id=%(wiki_id)s""",
{"yesterday": yesterday, "wiki_id": macro.request.config.wiki_id},
)
macro.request.cursor.execute(
"""DELETE FROM events
WHERE event_time<%(yesterday)s and
wiki_id=%(wiki_id)s""",
{"yesterday": yesterday, "wiki_id": macro.request.config.wiki_id},
)
macro.request.cursor.execute(
"""SELECT uid, event_time, posted_by, text, location, event_name
FROM events
WHERE wiki_id=%(wiki_id)s
ORDER BY event_time""",
{"wiki_id": macro.request.config.wiki_id},
)
result = macro.request.cursor.fetchone()
while result:
events.append(result)
result = macro.request.cursor.fetchone()
add_event_form_box(htmltext, macro)
for event in events:
event_name = event[5]
# we store it as a general time and we convert it to a local time..
event_time_unix = event[1]
event_time_struct = wikiutil.timeInUnixToLocal(macro.request.config.tz, event_time_unix)
year = event_time_struct[0]
month = event_time_struct[1]
day = event_time_struct[2]
hour = event_time_struct[3]
minute = event_time_struct[4]
posted_by = event[2]
id = event[0]
date = str(month) + " " + str(day)
if int(hour) > 12:
read_hour = int(hour) - 12
if not int(minute) == 0:
ptime = str(read_hour) + ":" + str(minute) + " PM"
else:
ptime = str(read_hour) + ":00" + " PM"
elif int(hour) == 0:
if not int(minute) == 0:
ptime = "12:" + str(minute) + " AM"
else:
ptime = "12:00 AM"
elif int(hour) == 12:
if not int(minute) == 0:
ptime = "12:" + str(minute) + " PM"
else:
ptime = "12:00 PM"
else:
if not int(minute) == 0:
ptime = str(hour) + ":" + str(minute) + " AM"
else:
ptime = str(hour) + ":00 AM"
ptime = "%s (%s)" % (ptime, macro.request.config.tz)
# This is where we want to run through the wiki processor
text = event[3]
event_location = event[4]
processed_text = doParse(text, macro, keep_outer_paragraph=True)
processed_location = doParse(event_location, macro)
processed_name = doParse(event_name, macro)
month_dict = {
1: "January",
2: "February",
3: "March",
4: "April",
5: "May",
6: "June",
7: "July",
8: "August",
9: "September",
10: "October",
11: "November",
12: "December",
}
string_month = month_dict[month]
events_page = Page("Events Board", macro.request)
posted_by_user = user.User(macro.request, name=posted_by)
user_link = user.getUserLink(macro.request, posted_by_user)
if macro.request.user.may.admin(events_page) or posted_by == macro.request.user.propercased_name:
if date == old_date:
htmltext.append(
'<ul>\n<h4 id="head-%s">%s</h4>\n'
'<a href="%s/Events_Board?action=events&uid=%s&'
'del=1">[delete]</a>'
" <b>Time:</b> %s<br>\n"
"<b>Location:</b> %s<br>\n"
"%s(Posted by %s)\n</ul>\n"
% (
id,
processed_name,
macro.request.getScriptname(),
id,
ptime,
processed_location,
processed_text,
user_link,
)
)
else:
string_day = datetoday(int(day), int(month), int(year))
old_date = date
htmltext.append(
"<h2>%s, %s %s, %s</h2>\n"
'<ul><h4 id="head-%s">%s</h4>\n'
'<a href="%s/Events_Board?action=events&uid=%s&'
'del=1">[delete]</a>'
" <b>Time:</b> "
"%s \n"
"<b>Location:</b> %s<br>\n"
"%s(Posted by %s)\n</ul>\n"
% (
string_day,
string_month,
day,
year,
id,
processed_name,
macro.request.getScriptname(),
id,
ptime,
processed_location,
processed_text,
user_link,
)
)
else:
if date == old_date:
htmltext.append(
'<ul>\n<h4 id="head-%s">%s</h4>\n'
"<b>Time:</b> %s<br>\n"
"<b>Location:</b> %s<br>\n"
"%s(Posted by %s)\n</ul>\n"
% (id, processed_name, ptime, processed_location, processed_text, user_link)
)
else:
string_day = datetoday(int(day), int(month), int(year))
old_date = date
htmltext.append(
"<h2>%s, %s %s</h2>\n"
'<ul>\n<h4 id="head-%s">%s</h4>\n'
"<b>Time:</b> %s \n"
"<b>Location:</b> %s<br>\n"
"%s(Posted by %s)\n</ul>\n"
% (
string_day,
string_month,
day,
id,
processed_name,
ptime,
processed_location,
processed_text,
user_link,
)
)
