OSDN Git Service

これが妥当ですね
[pybbs/pybbs.git] / pybbs.py
1 # -*- coding:utf-8 -*-
2 import os,re,glob
3 from tornado import escape,web,ioloop,httpserver,httpclient
4 import pymongo, urllib
5 from datetime import datetime
6 import json
7 from bson.objectid import ObjectId #don't remove
8 from linebot.api import LineBotApi
9 from linebot.exceptions import (InvalidSignatureError)
10 from linebot.models import (TextSendMessage)
11
12
13 class BaseHandler(web.RequestHandler):
14     def get_current_user(self):
15         user = self.get_secure_cookie('admin_user')
16         return escape.utf8(user)
17     
18     def set_current_user(self,username):
19         self.set_secure_cookie('admin_user',username)
20         
21     def clear_current_user(self):
22         self.clear_cookie('admin_user')
23
24 class IndexHandler(BaseHandler):
25     def main(self,dbname,page):
26         params = self.application.db['params'].find_one({'app':'bbs'})
27         if params['mentenance'] is True:
28             self.render('mentenance.htm',title=params['title'],db=dbname)
29             return
30         if dbname not in self.application.mylist():
31             if self.current_user == b'admin':
32                 coll = self.application.db[dbname]
33                 coll.insert({})
34                 coll.remove({})
35             else:
36                 raise web.HTTPError(404)
37         key = self.get_argument('key','')
38         if key != '':
39             table = self.application.db[dbname]
40             rec = table.find_one({'number':int(key)})
41             if rec:
42                 self.render('article.htm',record=rec)
43                 return
44             else:
45                 raise web.HTTPError(404)
46         self.rule = escape.url_unescape(self.get_cookie('aikotoba',''))
47         self.na = escape.url_unescape(self.get_cookie('username',u'誰かさん'))
48         self.pos = self.application.gpos(dbname,page)
49         table = self.application.db[dbname]
50         i = params['count']
51         start = (self.pos-1)*i
52         if start < 0:
53             start = table.count()-i
54             if start < 0:
55                 start = 0
56         rec = table.find()
57         self.bool = (dbname == params['info name'])
58         if self.bool is True:
59             rec.sort('number',-1)
60         else:
61             rec.sort('number')
62         self.rec = rec.skip(start).limit(i)
63
64     def get(self,dbname,page='0'):
65         self.main(dbname,page)
66         db = self.application.db
67         table = db[dbname].find()
68         params = db['params'].find_one({'app':'bbs'})
69         if table.count() >= 10*params['count']:
70             self.render('modules/full.htm',position=self.pos,records=self.rec,data=params,db=dbname)
71         if self.bool is True and self.current_user != b'admin':
72             self.render('modules/info.htm',position=self.pos,records=self.rec,data=params,db=dbname,error='')
73         else:
74             self.render('modules/index.htm',position=self.pos,records=self.rec,data=params,username=self.na,
75             comment='',db=dbname,aikotoba=self.rule,error='',check='checked')
76
77 class LoginHandler(BaseHandler):
78     def get(self):
79         info = self.application.db['params'].find_one({'app':'bbs'})
80         query = self.get_query_argument('next','/'+info['info name'])
81         i = query[1:].find('/')
82         if i == -1:
83             qs = query[1:]
84         else:
85             qs = query[1:i+1]
86         self.render('login.htm',db=escape.url_unescape(qs))
87         
88     def post(self):
89         dbname = self.get_argument('record','')
90         if dbname == '':
91             self.redirect('/login')
92             return
93         pw = self.application.db['params'].find_one({'app':'bbs'})
94         if self.get_argument('password') == pw['password']:
95             self.set_current_user('admin')
96         if dbname == 'master':
97             self.redirect('/master')
98         else:
99             self.redirect('/'+dbname+'/admin/0/')
100         
101 class LogoutHandler(BaseHandler):
102     def get(self):
103         self.clear_current_user()
104         self.redirect('/login')
105  
106 class JumpHandler(BaseHandler):
107     def get(self):
108         self.clear_current_user()
109         self.redirect('/')
110         
111 class NaviHandler(web.RequestHandler):
112     def get(self):
113         if 'params' not in self.application.mylist():
114             item = {"mentenance":False,"out_words":[u"阿保",u"馬鹿",u"死ね"],"password":"admin",
115                     "title2":"<h1 style=color:gray;text-align:center>pybbs</h1>",
116                     "bad_words":["<style","<link","<script","<img"],"count":30,
117                     "title":"pybbs","info name":"info",'app':'bbs'}       
118             self.application.db['params'].insert(item)
119             self.application.db['info'].find()
120         table = self.application.db['params'].find_one({'app':'bbs'})
121         if table['mentenance'] is True:
122             self.render('mentenance.htm',title=table['title'],db=table['info name'])
123             return
124         coll = self.application.coll()
125         na = table['info name']
126         self.render('top.htm',coll=coll,name=na,full=self.full)
127
128     def full(self,dbname):
129         if dbname in self.application.coll():
130             i = 10*self.application.db['params'].find_one({'app':'bbs'})['count']
131             table = self.application.db[dbname]
132             if table.count() >= i:
133                 return True
134         return False
135
136 class TitleHandler(NaviHandler):
137     def get(self):
138         rec = sorted(self.title(),key=lambda x: x['date2'])
139         self.render('title.htm',coll=rec,full=self.full)  
140         
141     def title(self):
142         for x in self.application.coll():
143             item = {}
144             item['name'] = x
145             table = self.application.db[x]
146             i = table.count()
147             item['count'] = i            
148             tmp = table.find_one({'number':1})
149             if tmp:
150                 s = tmp['title']
151             else:
152                 s = ''
153             item['title'] = s   
154             if i == 0:
155                 item['date'] = ''
156                 item['date2'] = 0
157             else:
158                 rec = table.find().sort('number')
159                 s = rec[i-1]['date']
160                 item['date'] = s
161                 i = datetime.strptime(s,'%Y/%m/%d %H:%M')
162                 year = datetime.now().year-i.year
163                 if year == 0:
164                     j = 800
165                 elif year == 1:
166                     j = 400
167                 else:
168                     j = 0
169                 item['date2'] = j+31*(i.month-1)+i.day
170             yield item
171         
172 class RegistHandler(IndexHandler):
173     def post(self,dbname):
174         self.main(dbname,'0')
175         params = self.application.db['params'].find_one({'app':'bbs'})
176         if dbname not in self.application.coll() and dbname != params['info name']:
177             raise web.HTTPError(404)
178         words = params['bad_words']
179         out = params['out_words']
180         rule = self.get_argument('aikotoba')
181         na = self.get_argument('name')
182         sub = self.get_argument('title')
183         com = self.get_argument('comment',None,False)
184         text = ''
185         i = 0
186         url = []
187         error = ''
188         kinsi = False
189         for line in com.splitlines():
190             if kinsi is False:
191                 for word in out:
192                     if word in line:
193                         error += u'禁止ワード.<br>'
194                         kinsi = True
195                         break
196             for word in words:
197                 if word in line.lower():
198                     tag = escape.xhtml_escape(word)
199                     error += u'タグ違反.('+tag+')<br>'
200             i += len(line)
201             obj = re.finditer('http[s]?://(?:[a-zA-Z]|[0-9]|[$-_@.&+]|[!*\(\),]|(?:%[0-9a-fA-F][0-9a-fA-F]))+', line)
202             for x in obj:
203                 if x.group() not in url:
204                     url.append(x.group())
205             j = 0
206             for x in line:
207                 if x == ' ':
208                     j += 1
209                 else:
210                     break
211             if j > 0: 
212                 line = line.replace(' ','&nbsp;',j)     
213             if len(line) == 0:
214                 text += '<p><br>\n</p>'
215             else:
216                 text += '<p>'+self.link(line,dbname)+'\n</p>'
217         if rule != u'げんき':
218             error += u'合言葉未入力.<br>'
219         s = ''
220         for x in url:
221             s = s+'<tr><td><a href={0} class=livepreview target=_blank>{0}</a></td></tr>'.format(x)
222         if s != '':
223             text = text+'<table><tr><td>検出url:</td></tr>'+s+'</table>'
224         pw = self.get_argument('password')
225         if i > 1000:
226             error += u'文字数が1,000をこえました.<br>'
227         if na == '':
228             na = u'誰かさん'
229         if sub == '':
230             sub = u'タイトルなし.'
231         article = self.application.db[dbname]
232         if article.count() == 0:
233             no = 1
234         else:            
235             items = article.find()
236             item = items.sort('number')[article.count()-1]
237             no = item['number']+1
238         if self.get_argument('show', 'false') == 'true':
239             ch = 'checked'
240         else:
241             ch = ''
242         if error == '':
243             if ch == 'checked':
244                 error = '<p style=font-size:2.5em;color:blue>↓↓プレビュー↓↓</p>\n' + text
245             else:
246                 self.set_cookie('aikotoba', escape.url_escape(rule))
247                 s = datetime.now()
248                 reg = {'number': no, 'name': na, 'title': sub, 'comment': text, 'raw': com, 'password': pw,
249                     'date': s.strftime('%Y/%m/%d %H:%M')}
250                 article.insert(reg)
251                 self.set_cookie('username', escape.url_escape(na))
252                 self.redirect('/' + dbname + '#article')
253                 return
254         else:
255             error = '<p style=color:red>' + error + '</p>'
256         self.render('modules/index.htm', position=0, records=self.rec, data=params,
257             username=na, comment=com, db=dbname, aikotoba=rule, error=error, check=ch)
258
259     def link(self,command,database):
260         i = 0
261         text = ''
262         obj = re.finditer('>>[0-9]+',command)
263         for x in obj:
264             s = '<a class=minpreview data-preview-url=/{0}?key={1} href=/{0}/userdel?job={1}>>>{1}</a>'.format(database,x.group()[2:])
265             text = text+command[i:x.start()]+s
266             i = x.end()
267         else:
268             text = text+command[i:]
269         return text
270     
271 class AdminHandler(BaseHandler):
272     @web.authenticated               
273     def get(self,dbname,page='0'):
274         if dbname == '':
275             dbname = self.get_argument('record','')
276         table = self.application.db[dbname]
277         rec = table.find().sort('number')                   
278         mente = self.application.db['params'].find_one({'app':'bbs'})
279         if mente['mentenance'] is True:
280             check = 'checked=checked'
281         else:
282             check = ''
283         pos = self.application.gpos(dbname,page)
284         i = mente['count']
285         start = (pos-1)*i
286         if start < 0:
287             start = table.count()-i
288             if start < 0:
289                 start = 0
290         rec.skip(start).limit(i)
291         self.render('modules/admin.htm',position=pos,records=rec,mente=check,password=mente['password'],db=dbname)
292
293 class AdminConfHandler(BaseHandler):
294     @web.authenticated
295     def post(self,dbname,func):
296         if func == 'set':
297             param = self.application.db['params'].find_one({'app':'bbs'})
298             if self.get_argument('mente','') == 'on':
299                 mente = True
300             else:
301                 mente = False  
302             word = self.get_argument('pass','')
303             if word == '':
304                 self.render('regist.htm',content='パスワードを設定してください')
305                 return
306             else:
307                 param['mentenance']=mente
308                 param['password']=word  
309                 self.application.db['params'].save(param)
310         elif func == 'del':
311             table = self.application.db[dbname]
312             for x in self.get_arguments('item'):
313                 table.remove({'number':int(x)})
314         self.redirect('/'+dbname+'/admin/0/')
315           
316 class UserHandler(web.RequestHandler):
317     def get(self,dbname):
318         q = self.get_query_argument('job','0',strip=True)
319         self.redirect(self.application.page(dbname,q))
320         
321     def post(self,dbname):
322         number = self.get_argument('number')
323         if number.isdigit() is True:
324             num = int(number)
325             url = self.application.page(dbname,number)
326             if 'password' in self.request.arguments.keys():
327                 pas = self.get_argument('password')
328             else:
329                 self.redirect(url)
330                 return
331             table = self.application.db[dbname]
332             obj = table.find_one({'number':num})
333             if obj and(obj['password'] == pas):
334                 table.update({'number':num},{'$set':{'title':u'削除されました','name':'','comment':u'<i><b>投稿者により削除されました</b></i>','raw':''}})
335                 self.redirect(url)
336                 return
337         self.redirect('/'+dbname)
338
339 class SearchHandler(web.RequestHandler):
340     def post(self,dbname=''):
341         arg = self.get_argument('word1')
342         self.word = arg[:]
343         self.andor = self.get_argument('type')
344         self.radiobox = self.get_argument('filter')       
345         if dbname == '':
346             rec = []
347             for x in self.application.coll():
348                 moji = self.search(x)
349                 for y in sorted(moji,key=lambda k: k['number']):
350                     y['dbname'] = x
351                     rec.append(y) 
352         else:
353             rec = sorted(self.search(dbname),key=lambda x: x['number'])
354         self.render('modules/search.htm',records=rec,word1=arg,db=dbname)
355
356     def get(self,dbname=''):
357         if dbname not in self.application.coll() and dbname != '':
358             raise web.HTTPError(404)
359         self.render('modules/search.htm',records=[],word1='',db=dbname)
360     
361     def search(self,dbname):
362         table = self.application.db[dbname]    
363         andor = self.andor == 'OR'
364         element = self.word.split()
365         elm = []
366         for x in element:
367             if x != '':
368                 elm.append(re.escape(x))
369         if self.radiobox == 'comment':
370             query = []
371             for qu in elm:
372                 query.append({'raw':re.compile(qu,re.IGNORECASE)})
373             if len(query) == 0:
374                 return
375             if andor:    
376                 result = table.find({'$or':query})
377                 color = 'yellow'
378             else:
379                 result = table.find({'$and':query})
380                 color = 'aqua'
381             for x in result:
382                 com = ''
383                 i = 0
384                 for text in x['raw'].splitlines():
385                     for y in text:
386                         if y == ' ':
387                             i += 1
388                         else:
389                             break
390                     text = text.replace(' ','&nbsp;',i)                  
391                     for y in element:                        
392                         if y.lower() in text.lower():
393                             com += '<p style=background-color:'+color+'>'+text+'<br></p>'  
394                             break                          
395                     else:
396                         if text == '':
397                             com += '<br>'
398                         else:
399                             com += '<p>'+text+'</p>'
400                 x['comment'] = com
401                 yield x       
402         else:
403             query = []
404             for x in element:
405                 if x != '':
406                     query.append({'name':x})
407             if len(query) == 0:
408                 return
409             for x in table.find({'$or':query}):
410                 yield x  
411                 
412 class HelpHandler(web.RequestHandler):
413     def get(self):
414         self.render('help.htm',req='')
415     
416     def post(self):
417         com = self.get_argument('help','')
418         line = com.splitlines(True)
419         com = ''
420         for x in line:
421             com += '<p>'+x
422         time = datetime.now()
423         db = self.application.db['master']
424         db.insert({'comment':com,'time':time.strftime('%Y/%m/%d')})
425         self.render('help.htm',req='送信しました')
426        
427 class MasterHandler(BaseHandler):
428     @web.authenticated  
429     def get(self):
430         if self.current_user == b'admin':
431             com = self.application.db['master'].find()
432             sum = self.application.db['temp'].find().count()
433             self.render('master.htm',com=com,sum=sum)
434         else:
435             raise web.HTTPError(404)
436     
437 class AlertHandler(web.RequestHandler):
438     def get(self):
439         db = self.get_query_argument('db')
440         num = self.get_query_argument('num')
441         table = self.application.db[db]
442         tb = table.find_one({'number':int(num)})
443         com = tb['comment']
444         time = datetime.now().strftime('%Y/%m/%d')
445         link = self.application.page(db,num)
446         jump = '<p><a href={0}>{0}</a>'.format(link)
447         d = datetime.now().weekday()
448         table = self.application.db['temp']
449         table.remove({'date':{'$ne':d}})
450         result = table.insert(
451             {'comment':com+jump,'time':time,'link':link,'date':d,'db':db,'num':num})
452         self.render('alert.htm',com=com+jump,num=str(result))
453         
454     def post(self):
455         id = ObjectId(self.get_argument('num'))
456         table = self.application.db['temp']
457         tb = table.find_one({'_id':id})      
458         link = tb['link']
459         com = self.get_argument('com')
460         table.remove({'_id':id})
461         if self.get_argument('cancel','') == 'cancel':
462             self.redirect(link)
463             return
464         if com != '':
465             tb['comment'] = com+tb['comment']
466         del tb['date']
467         table = self.application.db['master']
468         table.insert(tb)
469         self.redirect(link)
470         
471 class CleanHandler(web.RequestHandler):
472     def post(self):
473         bool = self.get_argument('all', 'false').lower()
474         table = self.application.db['master']
475         if bool == 'true':
476             table.remove()
477             self.application.db['temp'].remove()
478         elif bool == 'false':
479             for x in list(table.find()):           
480                 if not 'num' in x.keys():
481                     table.remove({'_id':x['_id']})
482                 else:
483                     item = self.application.db[x['db']].find_one({'number':int(x['num'])})
484                     if (not item)or(item['raw'] == ''):
485                         table.remove({'_id':x['_id']})   
486         com = self.application.db['master'].find()
487         sum = self.application.db['temp'].find().count()
488         self.render('master.htm', com=com, sum=sum)
489                                         
490 class FooterModule(web.UIModule):
491     def render(self,number,url,link):
492         return self.render_string('modules/footer.htm',index=number,url=url,link=link)
493     
494 class HeadlineApi(web.RequestHandler):
495     def get(self):
496         response = {}
497         for coll in self.application.coll():
498             table = self.application.db[coll]
499             if table.count() == 0:
500                 mydict = {}
501             else:
502                 text = table.find().sort('number')[table.count()-1]
503                 mydict = {'number':text['number'],'name':text['name'],'title':text['title'],'comment':text['raw'][0:20]}
504             response[coll] = mydict                 
505         self.write(json.dumps(response,ensure_ascii=False))
506         
507 class ArticleApi(web.RequestHandler):
508     def get(self,dbname,number):
509         response = None
510         if dbname in self.application.coll():
511             table = self.application.db[dbname]
512             response = table.find_one({'number':int(number)})      
513         if not response:
514             response = {}
515         else:
516             del response['_id']
517             del response['comment']
518             del response['password']
519         self.write(json.dumps(response,ensure_ascii=False))      
520
521 class ListApi(web.RequestHandler):
522     def get(self,dbname):
523         response = None
524         if dbname in self.application.coll():
525             table = self.application.db[dbname]
526             response = {}
527             for data in table.find().sort('number'):
528                 response[data['number']] = data['raw'][0:20]
529         if not response:
530             response = {}
531         self.write(json.dumps(response,ensure_ascii=False))
532
533 class WebHookHandler(web.RequestHandler):
534     def main(self, no):
535         #pz = pytz.timezone('Asia/Tokyo')
536         now = datetime.now()#pz)
537         t = now.hour
538         w = now.weekday()
539         if (w < 5)and(t >= 9)and(t < 16):
540             return u'仕事中.'
541         table, na = self.users()
542         item = table.find({'no':re.compile(no,re.IGNORECASE)})
543         if item.count() == 1:
544             x = item[0]
545             ans = x['name']+'\n'+x['no']
546         elif item.count() > 1:
547             ans = ''    
548             obj = list(item)
549             list1 = sorted(obj, key=lambda k:k['name'])
550             for x in list1:
551                 if x['name'] == list1[0]['name']:
552                     ans += x['name']+'\n'+x['no']+'\n'
553                 else:
554                     break
555             else:
556                 return ans       
557             ans = self.itr(sorted(list1, key=lambda k:k['no']))
558         else:
559             ans = self.itr(table.find().sort('no'))
560             ans = '-*-'+na+' list-*-\n'+ans
561         return ans
562     
563     def itr(self, item):
564         ans = ''
565         for x in item:
566             ans += '【'+x['no']+'】 '
567         return ans
568     
569     def help(self):
570         s = '-*-database names-*-\n'
571         out = ['objectlabs-system','objectlabs-system.admin.collections','users_bot']
572         for x in self.application.mylist():
573             if x not in out and x[-4:] == '_bot' and x != '_bot':
574                 s += x[:-4]+'\n'
575         return s
576     
577     def setting(self, dbname):
578         dbname = dbname.lower()+'_bot'
579         ca = self.application.mylist()
580         if 'users_bos' in ca:
581             ca.remove('users_bot')
582         if dbname in ca:
583             db = self.application.db['users_bot']
584             item = db.find_one({'name':self.uid})
585             if item['dbname'] == dbname:
586                 return False
587             else:
588                 db.update({'name':self.uid}, {'name':self.uid, 'dbname':dbname})
589                 return True
590         return False
591
592     def users(self):
593         db = self.application.db['users_bot']
594         item = db.find_one({'name':self.uid})
595         x = item['dbname']
596         return self.application.db[x], x[:-4]
597                           
598     def post(self):
599         '''
600         signature = self.request.headers['X-Line-Signature']
601         body = self.request.body
602         parser = WebhookParser(self.application.ch)
603         try:
604             parser.parse(body, signature)
605         except InvalidSignatureError:
606             web.HTTPError(404)
607             return
608         '''
609         dic = escape.json_decode(self.request.body)              
610         for event in dic['events']:
611             if 'replyToken' in event.keys():
612                 self.uid = event['source']['userId']
613                 bot = 'users_bot'               
614                 if event['type'] == 'unfollow':
615                     self.application.db[bot].remove({'name':self.uid})
616                     return
617                 elif event['type'] != 'message' or event['message']['type'] != 'text':
618                     return
619                 item = self.application.db['params'].find_one({'app':'bot'})
620                 if item:
621                     de = item['default']
622                 else:
623                     de = '_bot'         
624                 if item and 'access_token' in item.keys():
625                     token = item['access_token']
626                 else:      
627                     token =self.application.tk
628                 if bot not in self.application.mylist() or not self.application.db[bot].find_one({'name':self.uid}):
629                     db = self.application.db[bot]
630                     db.insert({'name':self.uid, 'dbname':de})
631                 x = event['message']['text']     
632                 if self.setting(x):
633                     te = u'設定完了.'
634                 elif x == '?':
635                     te = self.help()
636                 else:
637                     te = self.main(x)
638                 linebot = LineBotApi(token)            
639                 linebot.reply_message(event['replyToken'], TextSendMessage(text=te))
640
641 class InitHandler(web.RequestHandler):
642     def get(self):        
643         de = self.get_argument('default', '')     
644         if de == '':
645             names = self.application.mylist()
646             db = []
647             for x in names:
648                 if x[-4:] == '_bot' and x != 'users_bot':
649                     db.append(x[:-4])
650             self.render('init.htm',db=db)
651             return
652         tb = self.application.db['params']
653         if tb.find_one({'app':'bot'}):
654             tb.update({'app':'bot'}, {'app':'bot', 'default':de+'_bot'})
655         else:
656             tb.insert({'app':'bot', 'default':de+'_bot'})
657         for x in glob.glob('./*.txt'):
658             f = open(x)
659             data = f.read()
660             f.close()
661             self.main(x[2:-4].lower(), data)
662     
663     def main(self, name, data):
664         if name == 'requirements':
665             return
666         item = []
667         dic = None
668         for x in data.split('\n'):
669             if len(x) > 0 and x[0] == '@':
670                 dic = {}
671                 dic['name'] = x[1:]
672             elif dic:
673                 dic['no'] = x
674                 item.append(dic)
675         table = self.application.db[name+'_bot']
676         table.remove()
677         for x in item:
678             table.insert(x) 
679             
680 class TokenHandler(web.RequestHandler):
681     def on_response(self, response):
682         dic = escape.json_decode(response.body)
683         token = dic['access_token']
684         table = self.application.db['params']
685         data = {'app':'bot', 'access_token':token}
686         if table.find_one({'app':'bot'}):
687             table.save(data)
688         else:
689             table.insert(data)
690         self.finish()
691
692     #@web.asynchronous
693     def get(self):
694         url = 'https://api.line.me/v2/oauth/accessToken'
695         headers = 'application/x-www-form-urlencoded'
696         data = {'grant_type':'client_credentials', 'client_id':self.application.id, 'client_secret':self.application.ch}
697         body = urllib.parse.urlencode(data)
698         req = httpclient.HTTPRequest(url=url,method='POST',headers=headers,body=body)
699         http = httpclient.AsyncHTTPClient()
700         http.fetch(req, callback=self.on_response)
701
702 class Application(web.Application):
703     ch = os.environ['Channel_Secret']
704     uri = os.environ['MONGODB_URI']
705     ac = os.environ['ACCOUNT']
706     tk = os.environ['Access_Token']
707     db = pymongo.MongoClient(uri)[ac]
708     def __init__(self):
709         handlers = [(r'/',NaviHandler),(r'/login',LoginHandler),(r'/logout',LogoutHandler),(r'/title',TitleHandler),
710                     (r'/headline/api',HeadlineApi),(r'/read/api/([a-zA-Z0-9_%]+)/([0-9]+)',ArticleApi),
711                     (r'/write/api/([a-zA-Z0-9_%]+)/()/()/()',ArticleApi),(r'/list/api/([a-zA-Z0-9_%]+)',ListApi),
712                     (r'/help',HelpHandler),(r'/master',MasterHandler),(r'/alert',AlertHandler),(r'/jump',JumpHandler),
713                     (r'/callback',WebHookHandler),(r'/init',InitHandler),(r'/search',SearchHandler),(r'/clean',CleanHandler),(r'/token',TokenHandler),
714                     (r'/([a-zA-Z0-9_%]+)',IndexHandler),(r'/([a-zA-Z0-9_%]+)/([0-9]+)/',IndexHandler),
715                     (r'/([a-zA-Z0-9_%]+)/admin/([0-9]+)/*',AdminHandler),(r'/([a-zA-Z0-9_%]+)/admin/([a-z]+)/*',AdminConfHandler),(r'/([a-zA-Z0-9_%]+)/userdel',UserHandler),
716                     (r'/([a-zA-Z0-9_%]+)/search',SearchHandler),(r'/([a-zA-Z0-9_%]+)/regist',RegistHandler)]
717         settings = {'template_path':os.path.join(os.path.dirname(__file__),'templates'),
718                         'static_path':os.path.join(os.path.dirname(__file__),'static'),
719                         'ui_modules':{'Footer':FooterModule},
720                         'cookie_secret':os.environ['cookie'],
721                         'xsrf_cookies':False,
722                         #'debug':True,
723                         'login_url':'/login'
724                         }
725         super().__init__(handlers,**settings)
726  
727     def gpos(self,dbname,page):
728         params = self.db['params'].find_one({'app':'bbs'})
729         pos = int(page)
730         if pos <= 0:
731             pos = 0
732         elif (pos-1)*params['count'] >= self.db[dbname].count():
733             pos = 0
734         return pos
735
736     def page(self,dbname,number):
737         table = self.db[dbname]
738         rec = table.find({'number':{'$lte':int(number)}}).count()
739         s = self.db['params'].find_one({'app':'bbs'})
740         conf = int(s['count'])
741         if table.find().count() - rec >= conf:
742             return '/'+dbname+'/'+str(1+rec//conf)+'/#'+number
743         else:
744             return '/'+dbname+'#'+number
745
746     def mylist(self):
747         return self.db.list_collection_names()[:]
748
749     def coll(self):
750         name = self.mylist()
751         item = self.db['params'].find_one({'app':'bbs'})
752         target = ['objectlabs-system', 'objectlabs-system.admin.collections', 'system.indexes',
753             'params', 'master', 'temp', item['info name']]
754         for x in target:
755             name.remove(x)
756         for x in name:
757             if x[-4:] == '_bot':
758                 name.remove(x)
759         return sorted(name)
760    
761 if __name__ == '__main__':
762     app = Application()
763     http_server = httpserver.HTTPServer(app)
764     port = int(os.environ.get('PORT',5000))
765     http_server.listen(port)
766     ioloop.IOLoop.instance().start()