def main():
# -> nieuwe instantie van klasse ypAPIQ
query = yesplanAPIQuery()
# -> html headers
write_headers()
# get event id's voor opgegeven datum (= GET 'eventdate' van html request http://192.168.2.83/cgi-bin/get?eventdate=2014-04-18)
form = cgi.FieldStorage()
if form:
date=form["eventdate"].value[-2:]+form["eventdate"].value[4:-3]+"-"+form["eventdate"].value[:4]
else:
date="08-04-2014"
json = query.get_data("/events/date%3A"+date)
global datum
datum = date
# voor elk id worden de resourcebookings opgezocht
i=0
for w in json["data"]:
global voorstelling
global id
id = voorstelling=json["data"][i]["id"]
voorstelling=json["data"][i]["name"]
# get resourcedata
process_resources(query.get_data("/event/"+json["data"][i]["id"]+"/resourcebookings"))
# er wordt enkel iets getoond als er PTHumans in het spel zijn
if PTHumans:
write_html()
# maak lijst leeg
del PTHumans[:]
i=i+1
write_footers()
def main():
# NEW GOOGLESHEET OBJECT
gSheet = googleSheet('dagklapper')
# NEW YPAPIQ OBJECT
query = yesplanAPIQuery()
i = 0
for days in range(0, 3):
print "Fetching & exporting data for " + getDate(i)
worksheet = gSheet.wks.get_worksheet(i)
# Cleanup: Select a range, set value & update
cell_list = worksheet.range('A4:B30')
for cell in cell_list:
cell.value = ''
worksheet.update_cells(cell_list)
voorstellingen = getActiviteiten(query, getDate(i))
exportToSheet(query, worksheet, voorstellingen, getDate(i))
i = i + 1
def main():
# NEW GOOGLESHEET OBJECT
gSheet = googleSheet('dagklapper')
# NEW YPAPIQ OBJECT
query = yesplanAPIQuery()
i=0
for days in range (0,3):
print "Fetching & exporting data for " + getDate(i)
worksheet = gSheet.wks.get_worksheet(i)
# Cleanup: Select a range, set value & update
cell_list = worksheet.range('A4:B30')
for cell in cell_list:
cell.value=''
worksheet.update_cells(cell_list)
voorstellingen = getActiviteiten(query, getDate(i))
exportToSheet(query, worksheet, voorstellingen, getDate(i))
i=i+1
#!/usr/bin/env python
# -*- coding: utf-8 -*-
#
import MySQLdb
import json
from pprint import pprint
global time
import time
from datetime import datetime
import urllib
import smtplib
from yesplanAPIQuery import yesplanAPIQuery
from yesplanAPIQuery import yesplanAPIQuery4
from yesplanAPIQuery import yesplanAPIQuery6
from yesplanAPIQuery import yesplanAPIQuery8
query = yesplanAPIQuery()
query6 = yesplanAPIQuery6()
query4 = yesplanAPIQuery4()
query8 = yesplanAPIQuery8()
import MySQLdb
import sys
import kokplanning
#sys.stdout = open("/var/www/html/stdout.txt", "w")
#import keukenteamtest
global pagecount
pagecount=1
def cleardb(database,table):
