1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
|
#!/usr/bin/env python
# -*- coding: UTF-8 -*-
import webapp2
from StringIO import StringIO
from datetime import datetime, timedelta
from ntuceiba import NtuCeibaEvent
from ntuceiba.parse import ntuceiba_parser
from ntuceiba.toxml import ntuceiba_toxml
from access import CalEvent
from google.appengine.api import users
from google.appengine.ext import db
def ntuceiba_merge(listobj, useremail, allow_overwrite):
for entry in listobj:
if entry.duedate == None:
continue
data = db.GqlQuery("SELECT * FROM CalEvent "
"WHERE ANCESTOR IS :1 AND "
"begin >= :2 AND "
"begin < :3 "
"ORDER BY begin",
db.Key.from_path('user', useremail),
entry.duedate,
entry.duedate + timedelta(0, 3600, 0))
for matched in data.run():
if matched.datafrom == "ntuceiba" and matched.title.find(entry.title) >= 0:
if allow_overwrite:
entry.key = str(matched.key())
else:
entry.enabled = False
break
def ntuceiba_gaeds_update(listobj, useremail, fakencobj, titleadd):
listlen = len(listobj)
createlen = 0
updatelen = 0
for entry in listobj:
if entry.enabled:
contstr = ""
if entry.key != None:
calevent = db.get(db.Key(entry.key))
updatelen = updatelen + 1
else:
calevent = CalEvent(
db.Key.from_path('user', useremail),
# 我在亂打...... 這個不重要
title="臺大 CEIBA 匯入工具" ,
begin=datetime(1, 1, 1), datafrom="ntuceiba")
createlen = createlen + 1
if titleadd == None or titleadd == "":
calevent.title = entry.title
else:
calevent.title = "[" + titleadd + "]" + " " + entry.title
calevent.begin = entry.duedate
calevent.icon = 0
calevent.remind = 30
calevent.datafrom = "ntuceiba"
if fakencobj.title:
contstr = contstr + u"名稱：" + entry.title + "\n"
if fakencobj.member:
contstr = contstr + u"成員：" + entry.member + "\n"
if fakencobj.method:
contstr = contstr + u"繳交方法：" + entry.method + "\n"
if fakencobj.percent:
contstr = contstr + u"成績比重：" + entry.percent + "\n"
if fakencobj.duedate:
contstr = contstr + u"繳交期限：" + str(entry.duedate) + "\n"
if fakencobj.late:
if entry.late:
contstr = contstr + u"逾期繳交：可以\n"
else:
contstr = contstr + u"逾期繳交：不可以\n"
if fakencobj.subdate:
contstr = contstr + u"繳交日期：" + entry.subdate + "\n"
if fakencobj.comment:
contstr = contstr + u"作業評語：" + entry.comment + "\n"
calevent.content = contstr
calevent.put()
return (listlen, createlen, updatelen)
class NtuCeibaImport(webapp2.RedirectHandler):
def get(self):
return
def post(self):
guserid = users.get_current_user()
if not guserid:
return
merge = self.request.get('merge')
viewonly = self.request.get('viewonly')
overwrite = self.request.get('overwrite')
htmlfile = self.request.get('file')
useremail = guserid.email()
htmlfile = StringIO(htmlfile)
htmlfile.readline()
cblist = ntuceiba_parser(htmlfile)
enflag = NtuCeibaEvent()
enflag.flagize()
if self.request.get('addtitle') != "":
enflag.title = True
if self.request.get('addmember') != "":
enflag.member = True
if self.request.get('addmethod') != "":
enflag.method = True
if self.request.get('addpercent') != "":
enflag.percent = True
if self.request.get('adddue') != "":
enflag.duedate = True
if self.request.get('addlate') != "":
enflag.late = True
if self.request.get('addsub') != "":
enflag.subdate = True
if self.request.get('addcomment') != "":
enflag.comment = True
if merge != "":
if overwrite != "":
ntuceiba_merge(cblist, useremail, True)
else:
ntuceiba_merge(cblist, useremail, False)
if viewonly != "":
self.response.headers['Content-Type'] = 'text/xml; charset=UTF-8'
self.response.out.write(ntuceiba_toxml(cblist))
else:
resrepo = ntuceiba_gaeds_update(cblist, useremail, enflag, None)
self.response.headers['Content-Type'] = 'text/plain'
self.response.out.write(
str(resrepo[0]) + " " +
str(resrepo[1]) + " " +
str(resrepo[2]))
app = webapp2.WSGIApplication([('/access/imnc', NtuCeibaImport)])
|
