def pageBody():
date = dateNow
oldWeekNumber = 0
i = 0
while True:
isWorkDay, isNotOnBreak, weekNumber, dayNumber, breakName = isRingDay(
date, oldWeekNumber, cursor, verbose)
if weekNumber != oldWeekNumber:
print("<br>\n<br>Week number: %s" % weekNumber)
oldWeekNumber = weekNumber
if isNotOnBreak or isWorkDay:
print("\n<br> %s, %s" % (
date,
getDayName(dayNumber, verbose),
))
if breakName:
print("\n<br> %s" %
breakName)
if isNotOnBreak:
ringTimes = findRingTimes(date, dayNumber, cursor, verbose)
if ringTimes:
for ringTime in ringTimes:
print(
"\n<br> "
)
print(("%s, %s" % (
ringTime["ringTime"],
ringTime["ringTimeName"],
)))
print(
"\n<br> "
)
print(("%s, %s" % (
ringTime["ringPatternName"],
ringTime["ringPattern"],
)))
i += 1
if i >= 30:
break
else:
date = datetime.strptime(date,
"%Y-%m-%d") # convert to time object
date = date + timedelta(days=1) # add one day
date = datetime.strftime(date, "%Y-%m-%d") # convert to string
cacheTime = parsedCalendar["cachetid"]
day = 0
while True: # will keep on running as long as there is days in a month
try: # does this month have this day
date = parsedCalendar["dagar"][day]["datum"]
except: # month finished
break
weekNumber = int(parsedCalendar["dagar"][day]["vecka"])
dayNumber = int(parsedCalendar["dagar"][day]["dag i vecka"]) - 1
svDayName = parsedCalendar["dagar"][day]["veckodag"]
dayName = getDayName(dayNumber, verbose)
workFreeDay = parsedCalendar["dagar"][day]["arbetsfri dag"]
try: # is this day an eve
eve = parsedCalendar["dagar"][day]["helgdagsafton"]
except:
eve = ""
try: # is this day an eve
holiday = parsedCalendar["dagar"][day]["helgdag"]
except:
holiday = ""
if verbose:
print "\n*** Date: %s, %s" % (date, dayName)
if workFreeDay == "Nej":
def pageBody():
# get ring times
query = (
"SELECT ringTimeId, ringTimeName, weekDays, TIME_FORMAT(ringTime, '%H:%i') as ringTime, ringPatternId "
"FROM ringTimes ORDER BY ringTime ASC"
)
result, rowCount = db_query(cursor, query, verbose) # run query
if rowCount: # display ring times in a table
print("\n<br>\n<br>")
print('<table style="width:100%">')
print("<tr>")
print("<th>Id</th>")
print("<th>Time name</th>")
print("<th>Ring time</th>")
print("<th>Ring pattern id</th>")
print("<th>Ring pattern name</th>")
print("<th>Ring pattern</th>")
for dayNumber in range(0, 7):
print("<th>%s</th>" % getDayName(dayNumber, verbose))
print("<th></th>")
print("<th></th>")
print("</tr>")
for row in result:
ringTimeId = row[0]
ringTimeName = row[1]
weekDays = row[2]
ringTime = row[3]
ringPatternId = row[4]
if editRingTimeId == str(
ringTimeId
): # this is the ringTime we are about to edit
editRingTimeName = ringTimeName
editWeekDays = weekDays
editRingTime = ringTime
editRingPatternId = ringPatternId
print("<tr>")
print("<th>%s</th>" % ringTimeId)
print("<th>%s</th>" % ringTimeName)
print("<th>%s</th>" % ringTime)
print("<th>%s</th>" % ringPatternId)
# get ring patterns
query = (
"SELECT ringPatternName, ringPattern FROM ringPatterns "
"WHERE ringPatternID = '" + str(ringPatternId) + "'"
)
result, rowCount = db_query(cursor, query, verbose) # run query
if rowCount:
for row in result:
ringPatternName = row[0]
ringPattern = row[1]
print("<th>%s</th>" % ringPatternName)
print("<th>%s</th>" % ringPattern)
for dayNumber in range(0, 7): # print day name
if weekDays[dayNumber] == "1":
print("<th>On</th>")
else:
print("<th>Off</th>")
print('<th><a href="ringTimes.py?deleteRingTimeId=%s">Delete</a></th>' % ringTimeId)
print('<th><a href="ringTimes.py?editRingTimeId=%s">Edit</a></th>' % ringTimeId)
print("</tr>")
print("</table")
if editRingTimeId:
print("\n<br><br>")
print("<h3>Edit ring time</h3>")
print('<form action="/ringTimes.py">')
print("Time id:<br>")
print('<input type="text" name="updateRingTimeId" value="%s">' % editRingTimeId)
print("<br><br><br>")
print("Ring time name:<br>")
print('<input type="text" name="updateRingTimeName" value="%s">' % editRingTimeName)
print ("State a name for your ring time. <br><br>" "\nMax 100 characters. <br>")
print("<br><br>")
print("Ring time:<br>")
print('<input type="text" name="updateRingTime" value="%s">' % editRingTime)
print ('State time in the form "hh:mm". <br>')
print("<br><br>")
print("Choose ring pattern:<br>")
print('<select name="newRingPatternId">')
# get ring patterns
query = "SELECT ringPatternId, ringPatternName, ringPattern FROM ringPatterns"
result, rowCount = db_query(cursor, query, verbose) # run query
if rowCount:
for row in result:
ringPatternId = row[0]
ringPatternName = row[1]
ringPattern = row[2]
isSelected = ""
if ringPatternId == editRingPatternId:
isSelected = 'selected="selected"'
print((
'<option value="%s" %s>%s: %s, %s</option>'
% (
ringPatternId,
isSelected,
ringPatternId,
ringPatternName,
ringPattern,
)
))
print("</select>")
print("<br><br>")
for dayNumber in range(0, 7):
isChecked = ""
if str(editWeekDays)[dayNumber] == "1":
isChecked = 'checked="checked"'
print((
'<input type="checkbox" name="%s" value="1" %s> %s<br>'
% (
getDayName(dayNumber, verbose),
isChecked,
getDayName(dayNumber, verbose),
)
))
print("<br><br>")
print('<input type="submit" value="Submit">')
print("</form>")
if addRingTime: # display form to add ring time
print("\n<br><br>")
print("<h3>Add ring time</h3>")
print('<form action="/ringTimes.py">')
print("Ring time name:<br>")
print('<input type="text" name="newRingTimeName" value="Time name">')
print ("State a name for your ring time. <br><br>" "\nMax 100 characters. <br>")
dateTimeNow = datetime.now()
timeNow = dateTimeNow.strftime("%H:%M")
print("<br><br>")
print("Ring time:<br>")
print('<input type="text" name="newRingTime" value="%s">' % timeNow)
print ('State time in the form "hh:mm". <br>')
print("<br><br>")
print("Choose ring pattern:<br>")
print('<select name="newRingPatternId">')
# get ring patterns
query = "SELECT ringPatternId, ringPatternName, ringPattern FROM ringPatterns"
result, rowCount = db_query(cursor, query, verbose) # run query
if rowCount:
for row in result:
ringPatternId = row[0]
ringPatternName = row[1]
ringPattern = row[2]
print((
'<option value="%s">%s: %s, %s</option>'
% (ringPatternId, ringPatternId, ringPatternName, ringPattern)
))
print("</select>")
print("<br><br>")
for dayNumber in range(0, 7):
isChecked = ""
if dayNumber >= 0 and dayNumber <= 4:
isChecked = 'checked="checked"'
print((
'<input type="checkbox" name="%s" value="1" %s> %s<br>'
% (
getDayName(dayNumber, verbose),
isChecked,
getDayName(dayNumber, verbose),
)
))
print("<br><br>")
print('<input type="submit" value="Submit">')
print("</form>")